{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Circulaire","Convoqués","Stagiaires","Exemple"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":18,"defined_names":97,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Circulaire","index":0,"n_rows":147,"n_cols":13,"rows_kept":147,"cut":false,"hidden":false,"merged":[[68,1,68,9],[69,1,69,9],[8,10,9,10],[8,11,9,11],[17,10,18,10],[17,11,18,11],[59,1,59,9],[60,1,60,9],[61,1,61,9],[62,1,62,9],[63,1,63,9],[37,5,38,5],[37,6,38,6],[31,5,32,5],[31,6,32,6],[33,5,34,5],[33,6,34,6],[35,5,36,5],[35,6,36,6],[25,5,26,5],[25,6,26,6],[27,5,28,5],[27,6,28,6],[29,5,30,5],[29,6,30,6],[19,6,20,6],[1,3,5,9],[21,5,22,5],[21,6,22,6],[23,5,24,5],[23,6,24,6],[127,7,127,10],[129,7,129,10],[64,1,64,9],[65,1,65,9],[66,1,66,9],[67,1,67,9],[51,2,51,6],[53,1,53,9],[54,2,54,5],[55,2,55,5],[56,1,57,9],[58,1,58,9],[45,2,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[131,7,131,10],[144,7,144,10],[146,7,146,10],[17,5,18,5],[17,6,18,6],[19,5,20,5],[103,3,103,9],[105,3,105,9],[107,3,107,9],[109,3,111,9],[94,8,95,8],[94,9,95,9],[91,7,92,7],[91,8,92,8],[91,9,92,9],[85,9,86,9],[82,8,83,8],[82,9,83,9],[79,9,80,9],[71,1,71,9],[72,1,72,7],[72,8,72,9],[73,1,73,7],[73,8,73,9],[113,1,116,1],[113,2,116,4],[113,9,116,9],[97,9,98,9],[99,1,101,1],[99,2,101,2],[99,3,101,3],[99,4,101,4],[99,5,101,5],[100,6,101,6],[100,7,101,7],[100,8,101,8],[100,9,101,9],[96,1,98,1],[96,2,98,2],[96,3,98,3],[96,4,98,4],[96,5,98,5],[97,6,98,6],[97,7,98,7],[97,8,98,8],[93,1,95,1],[93,2,95,2],[93,3,95,3],[93,4,95,4],[93,5,95,5],[94,6,95,6],[94,7,95,7],[90,1,92,1],[90,2,92,2],[90,3,92,3],[90,4,92,4],[90,5,92,5],[91,6,92,6],[87,1,89,1],[87,2,89,2],[87,3,89,3],[87,4,89,4],[87,5,89,5],[88,6,89,6],[88,7,89,7],[88,8,89,8],[88,9,89,9],[84,1,86,1],[84,2,86,2],[84,3,86,3],[84,4,86,4],[84,5,86,5],[85,6,86,6],[85,7,86,7],[85,8,86,8],[79,7,80,7],[79,8,80,8],[81,1,83,1],[81,2,83,2],[81,3,83,3],[81,4,83,4],[81,5,83,5],[82,6,83,6],[82,7,83,7],[78,1,80,1],[78,2,80,2],[78,3,80,3],[78,4,80,4],[78,5,80,5],[79,6,80,6],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[50,2,50,6],[40,1,40,6],[40,7,40,9],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[39,2,39,5],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[7,13,7,15],[8,3,9,9],[9,13,12,15],[10,3,10,9],[11,3,11,9],[13,1,14,9],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[6,11,6,12],[7,2,10,2],[7,3,7,9],[15,1,15,6],[15,7,15,9],[16,2,16,3],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4]]}
[null,null,null,"Ordre",null,null,null,null,""]
[null,"",null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,"","DISCIPLINE - TITRE DE LA FORMATION"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"RESPONSABLE :"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()+K13","v":"2021-06-03"},"NOM et Prénom du responsable de l'action"]
[]
[null,null,null,null,null,null,null,null,null,null,"","Portable"]
[null,null,null,null,null,null,null,null,null,null,"","Mail"]
[null,{"$f":"IF(O3=\"\",\"\",IF(O3<>O4,\"Débutera le \"&TEXT(DATE(YEAR(O3),MONTH(O3),DAY(O3)),\"jj mmmm aaaa\")&IF(P3=\"\",\"\",\" à \"&HOUR(P3)&\"h\"&TEXT(MINUTE(P3),\"00\"))&\"\n et se terminera le \"&TEXT(DATE(YEAR(O4),MONTH(O4),DAY(O4)),\"jj mmmm aaaa\")&IF(P4=\"\",\"\",\" à \"&HOUR(P4)&\"h\"&TEXT(MINUTE(P4),\"00\")),\"Le \"&TEXT(DATE(YEAR(O3),MONTH(O3),DAY(O3)),\"jj mmmm aaaa\")&IF(P3=\"\",\"\",IF(P4=\"\",\" à \",\" de \")&HOUR(P3)&\"h\"&TEXT(MINUTE(P3),\"00\"))&IF(P4=\"\",\"\",\" à \"&HOUR(P4)&\"h\"&TEXT(MINUTE(P4),\"00\"))))","v":""},null,null,null,null,null,null,null,null,0]
[null,"Tous les participants doivent être licenciés pour la saison en cours.",null,null,null,null,null,null,null,null,{"$f":"TEXT(K9-(K10-1),\"jj/mm/aaaa\")","v":"04/06/2021"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(K9-(K10-1)+6,\"jj/mm/aaaa\")","v":"10/06/2021"}]
[null,"Planning",null,null,null,null,null,"Lieux restauration et hébergement",null,null,{"$f":"WEEKNUM(K14)","v":23}]
[null,"Dates","Horaires",null,"Libellé","Ville","Lieu","Déjeuner","Diner","Nuitée+pdj"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()+K22","v":{"$error":"#VALUE!"}},"Date : tapez 3/12/17\nHeure : tapez 9:00"]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,"Lieux",null,null,null,null,null,"Prix unitaire non prix en charge par le Comité régional"]
[null,"Nom","Adresse",null,null,null,null,"Déjeuner","Diner","Nuitée+pdj"]
[null,null,null,null,null,null,null,null,"non","non","","Nom et adresse du lieu. Tarif unitaire"]
[null,null,null,null,null,null,null,null,null,null,"","Nuitée + petit-déjeuner + taxe de séjour"]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,"Tarifs"]
[null,"TOTAL","Autres",null,null,null,"Frais péda.","Total déjeuners","Total diners","Total nuitées"]
[null,{"$f":"SUM(C56:J56)","v":0},{"$f":"M56","v":0},null,null,null,null,null,null,null,"","Calculer les totaux par type déjeuner etc."]
[]
[]
[null,"Observations et Prérequis"]
[null,null,null,null,null,null,null,null,null,null,"","Vos observations et prérequis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Inscription"]
[null,"Lien pour s'incrire",null,null,null,null,null,null,"Date limite d'inscription"]
[null,null,null,null,null,null,null,null,null,null,"","Date de fin d'inscription"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(K75)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"",null,{"$error":"#REF!"}]
[null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,{"$f":"\"Z\"&L9","v":"ZNOM et Prénom du responsable de l'action"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Template Google"]
[]
[null,null,null,null,null,null,null,{"$f":"CLEAN(N8)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"CLEAN(D4)","v":""}]
[]
[null,null,null,null,null,null,null,null,"Repas du midi","Repas du soir","Nuitée et petit déjeuner"]
[null,null,null,null,null,null,null,"",null,null,{"$f":"IF(H135>\"\",\"<<\"&SUBSTITUTE(H135,\" \",\"\")&$K$134&\">>\",\"\")","v":""},null,{"$f":"CLEAN(H130)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$S$25:$S$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$S$25:$S$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H136>\"\",IF(D$18=1,\"<<\"&H136&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H136>\"\",IF(F$18=1,\"<<\"&H136&\" [\"&$J$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H136>\"\",IF(E$18=1,\"<<\"&H136&\" [\"&$K$134&\"]>>\",\"-----\"),\"\")","v":""},null,{"$f":"CLEAN(H130&\" - <<NOM Prénom>>\")","v":" - <<NOM Prénom>>"}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$T$25:$T$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$T$25:$T$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H137>\"\",IF(D$22=1,\"<<\"&H137&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H137>\"\",IF(F$22=1,\"<<\"&H137&\" [\"&$J$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H137>\"\",IF(E$22=1,\"<<\"&H137&\" [\"&$K$134&\"]>>\",\"-----\"),\"\")","v":""},null,"<<Mail>>"]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$U$25:$U$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$U$25:$U$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H138>\"\",IF(D$26=1,\"<<\"&H138&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H138>\"\",IF(F26=1,\"<<\"&SUBSTITUTE(H138,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H138>\"\",IF(E26=1,\"<<\"&SUBSTITUTE(H138,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""},null,"<<Mail du club>>"]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$V$25:$V$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$V$25:$V$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H139>\"\",IF(D$29=1,\"<<\"&H139&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H139>\"\",IF(F29=1,\"<<\"&SUBSTITUTE(H139,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H139>\"\",IF(E29=1,\"<<\"&SUBSTITUTE(H139,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$W$25:$W$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$W$25:$W$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H140>\"\",IF(D$32=1,\"<<\"&H140&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H140>\"\",IF(F32=1,\"<<\"&SUBSTITUTE(H140,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H140>\"\",IF(E32=1,\"<<\"&SUBSTITUTE(H140,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$X$25:$X$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$X$25:$X$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H141>\"\",IF(D$43=1,\"<<\"&H141&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H141>\"\",IF(E43=1,\"<<\"&SUBSTITUTE(H141,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H141>\"\",IF(F43=1,\"<<\"&SUBSTITUTE(H141,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Y$25:$Y$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Y$25:$Y$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H142>\"\",IF(D$46=1,\"<<\"&H142&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H142>\"\",IF(E46=1,\"<<\"&SUBSTITUTE(H142,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H142>\"\",IF(F46=1,\"<<\"&SUBSTITUTE(H142,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Z$25:$Z$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Z$25:$Z$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H143>\"\",IF(D$49=1,\"<<\"&H143&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H143>\"\",IF(E49=1,\"<<\"&SUBSTITUTE(H143,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H143>\"\",IF(F49=1,\"<<\"&SUBSTITUTE(H143,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,{"$f":"\"<<NOM Prénom>>,\n\nNous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n\"&D2&\" - \"&D4&\"\n\n\"&N10&\"\n\nVeuillez trouver ci-joint un résumé de votre réservation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Franche-Comté\"","v":"<<NOM Prénom>>,\n\nNous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n - \n\n\n\nVeuillez trouver ci-joint un résumé de votre réservation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Franche-Comté"},{"$f":"G145","v":"<<NOM Prénom>>,\n\nNous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n - \n\n\n\nVeuillez trouver ci-joint un résumé de votre réservation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Franche-Comté"}]
[null,null,null,null,null,null,null,"Réponse :"]
[null,null,null,null,null,null,{"$f":"\"Nous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n\"&D2&\" - \"&D4&\"\n\n\"&N10&\"\n\nNous vous avons adressé un mail de confirmation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Bourgogne-Franche-Comté\"","v":"Nous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n - \n\n\n\nNous vous avons adressé un mail de confirmation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Bourgogne-Franche-Comté"},{"$f":"G147","v":"Nous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n - \n\n\n\nNous vous avons adressé un mail de confirmation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Bourgogne-Franche-Comté"}]

{"sheet":"Convoqués","index":1,"n_rows":19,"n_cols":40,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,39,19,39],[12,8,12,36],[13,1,14,36],[1,8,5,36],[7,8,7,36],[8,8,8,36],[9,8,9,36],[10,8,10,36],[11,8,11,36],[16,31,16,33],[16,34,16,36],[15,1,15,36],[16,13,16,15],[16,16,16,18],[16,19,16,21],[16,22,16,24],[16,25,16,27],[16,28,16,30],[16,4,16,6],[16,7,16,9],[16,10,16,12],[48,0,49,0],[46,0,47,0],[40,0,41,0],[38,0,39,0],[36,0,37,0],[34,0,35,0],[32,0,33,0],[30,0,31,0],[28,0,29,0],[26,0,27,0],[24,0,25,0],[22,0,23,0],[20,0,21,0],[18,0,19,0],[7,4,10,4]]}
[null,null,null,null,null,"Ordre",null,null,null,null,"",{"$f":"IF(ISERROR(TEXT(\"A\"&#REF!&\" - \"&K1&\" - Circulaire - \"&I4&\" \"&#REF!,\"@\")),TEXT(\"A\"&#REF!&\" - \"&K1&\" - Circulaire - \"&I4&\" \"&#REF!,\"@\"),TEXT(\"A\"&#REF!&\" - \"&K1&\" - Circulaire - \"&I4&\" \"&#REF!,\"@\"))","v":{"$error":"#REF!"}},"C:\\Users\\Utilisateur\\Documents\\GYMNASTIQUE\\BFC\\Saison 2017-2018\\Circulaires\\"]
[null,"",null,null,null,null,null,null,{"$f":"Circulaire!D2","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"RESPONSABLE :"]
[null,null,null,null,null,null,null,null,{"$f":"Circulaire!D9","v":0}]
[]
[null,null,null,null,null,null,null,null,{"$f":"Circulaire!D11","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"Circulaire!D12","v":0}]
[null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<>#REF!,\"Débutera le \"&TEXT(DATE(YEAR(#REF!),MONTH(#REF!),DAY(#REF!)),\"jj mmmm aaaa\")&IF(#REF!=\"\",\"\",\" à \"&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\"))&\"\n et se terminera le \"&TEXT(DATE(YEAR(#REF!),MONTH(#REF!),DAY(#REF!)),\"jj mmmm aaaa\")&IF(#REF!=\"\",\"\",\" à \"&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\")),\"Le \"&TEXT(DATE(YEAR(#REF!),MONTH(#REF!),DAY(#REF!)),\"jj mmmm aaaa\")&IF(#REF!=\"\",\"\",IF(#REF!=\"\",\" à \",\" de \")&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\"))&IF(#REF!=\"\",\"\",\" à \"&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\"))))","v":{"$error":"#REF!"}}]
[null,"Tous les intervenants doivent être licenciés pour la saison en cours."]
[]
[null,"Intervenants convoqués"]
[null,null,null,"Dates",{"$f":"IF(Circulaire!$B$18>0,Circulaire!$B$18,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$20>0,Circulaire!$B$20,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$22>0,Circulaire!$B$22,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$24>0,Circulaire!$B$24,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$26>0,Circulaire!$B$26,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$28>0,Circulaire!$B$28,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$30>0,Circulaire!$B$30,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$32>0,Circulaire!$B$32,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$34>0,Circulaire!$B$34,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$36>0,Circulaire!$B$36,0)","v":"00:00:00"},null,null,{"$f":"IF(Circulaire!$B$38>0,Circulaire!$B$38,0)","v":"00:00:00"}]
[null,"NOM Prénom","N° licence","Rôle",{"$f":"IF(E17>0,\"Matinée\",\"\")","v":""},{"$f":"IF(E17>0,\"Après-midi\",\"\")","v":""},{"$f":"IF(E17>0,\"Soirée\",\"\")","v":""},{"$f":"IF(H17>0,\"Matinée\",\"\")","v":""},{"$f":"IF(H17>0,\"Après-midi\",\"\")","v":""},{"$f":"IF(H17>0,\"Soirée\",\"\")","v":""},{"$f":"IF(K17>0,\"Matinée\",\"\")","v":""},{"$f":"IF(K17>0,\"Après-midi\",\"\")","v":""},{"$f":"IF(K17>0,\"Soirée\",\"\")","v":""},{"$f":"IF(N17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(N17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(N17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(Q17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(Q17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(Q17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(T17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(T17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(T17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(W17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(W17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(W17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(Z17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(Z17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(Z17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(AC17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(AC17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(AC17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(AF17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(AF17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(AF17>\"\",\"Soirée\",\"\")","v":""},{"$f":"IF(AI17>\"\",\"Matinée\",\"\")","v":""},{"$f":"IF(AI17>\"\",\"Après-midi\",\"\")","v":""},{"$f":"IF(AI17>\"\",\"Soirée\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()+AM22","v":"2021-06-03"},"Tapez 1 pour indiquer la présence de l'intervenant par demi-journée et soirée"]

{"sheet":"Stagiaires","index":2,"n_rows":19,"n_cols":40,"rows_kept":19,"cut":false,"hidden":false,"merged":[[16,25,16,27],[18,0,19,0],[18,39,19,39],[16,22,16,24],[59,0,60,0],[57,0,58,0],[55,0,56,0],[53,0,54,0],[47,0,52,0],[45,0,46,0],[42,0,43,0],[40,0,41,0],[38,0,39,0],[36,0,37,0],[33,0,34,0],[30,0,31,0],[28,0,29,0],[16,16,16,18],[16,19,16,21],[22,0,23,0],[20,0,21,0],[26,0,27,0],[24,0,25,0],[1,4,5,36],[7,4,7,36],[8,4,8,36],[9,4,9,36],[16,28,16,30],[16,31,16,33],[16,34,16,36],[10,4,10,36],[11,4,11,36],[12,8,12,36],[13,1,14,36],[15,1,15,36],[16,4,16,6],[16,7,16,9],[16,10,16,12],[16,13,16,15]]}
[null,null,null,null,null,"Ordre",null,null,null,null,"",{"$f":"IF(ISERROR(TEXT(\"A\"&#REF!&\" - \"&K1&\" - Circulaire - \"&I4&\" \"&#REF!,\"@\")),TEXT(\"A\"&#REF!&\" - \"&K1&\" - Circulaire - \"&I4&\" \"&#REF!,\"@\"),TEXT(\"A\"&#REF!&\" - \"&K1&\" - Circulaire - \"&I4&\" \"&#REF!,\"@\"))","v":{"$error":"#REF!"}},"C:\\Users\\Utilisateur\\Documents\\GYMNASTIQUE\\BFC\\Saison 2017-2018\\Circulaires\\"]
[null,"",null,null,{"$f":"Circulaire!D2","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,"RESPONSABLE :"]
[null,null,null,null,{"$f":"Circulaire!D9","v":0}]
[]
[null,null,null,null,{"$f":"Circulaire!D11","v":0}]
[null,null,null,null,{"$f":"Circulaire!D12","v":0}]
[null,{"$f":"IF(#REF!=\"\",\"\",IF(#REF!<>#REF!,\"Débutera le \"&TEXT(DATE(YEAR(#REF!),MONTH(#REF!),DAY(#REF!)),\"jj mmmm aaaa\")&IF(#REF!=\"\",\"\",\" à \"&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\"))&\"\n et se terminera le \"&TEXT(DATE(YEAR(#REF!),MONTH(#REF!),DAY(#REF!)),\"jj mmmm aaaa\")&IF(#REF!=\"\",\"\",\" à \"&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\")),\"Le \"&TEXT(DATE(YEAR(#REF!),MONTH(#REF!),DAY(#REF!)),\"jj mmmm aaaa\")&IF(#REF!=\"\",\"\",IF(#REF!=\"\",\" à \",\" de \")&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\"))&IF(#REF!=\"\",\"\",\" à \"&HOUR(#REF!)&\"h\"&TEXT(MINUTE(#REF!),\"00\"))))","v":{"$error":"#REF!"}}]
[null,"Tous les stagiaires être licenciés pour la saison en cours."]
[]
[null,"Stagiaires convoqués"]
[null,null,null,"Dates",{"$f":"IF(Circulaire!$B$18>0,Circulaire!$B$18,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$20>0,Circulaire!$B$20,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$22>0,Circulaire!$B$22,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$24>0,Circulaire!$B$24,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$26>0,Circulaire!$B$26,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$28>0,Circulaire!$B$28,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$30>0,Circulaire!$B$30,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$32>0,Circulaire!$B$32,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$34>0,Circulaire!$B$34,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$36>0,Circulaire!$B$36,\"\")","v":""},null,null,{"$f":"IF(Circulaire!$B$38>0,Circulaire!$B$38,\"\")","v":""}]
[null,"NOM Prénom","N° licence","Club","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée","Matinée","Après-midi","Soirée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()+AM22","v":"2021-06-03"},"Tapez 1 pour indiquer la présence du stagiaire par demi-journée et soirée"]

{"sheet":"Exemple","index":3,"n_rows":147,"n_cols":13,"rows_kept":147,"cut":false,"hidden":false,"merged":[[127,7,127,10],[129,7,129,10],[131,7,131,10],[144,7,144,10],[146,7,146,10],[100,9,101,9],[103,3,103,9],[105,3,105,9],[107,3,107,9],[109,3,111,9],[113,1,116,1],[113,2,116,4],[113,9,116,9],[97,8,98,8],[97,9,98,9],[99,1,101,1],[99,2,101,2],[99,3,101,3],[99,4,101,4],[99,5,101,5],[100,6,101,6],[100,7,101,7],[100,8,101,8],[94,7,95,7],[94,8,95,8],[94,9,95,9],[96,1,98,1],[96,2,98,2],[96,3,98,3],[96,4,98,4],[96,5,98,5],[97,6,98,6],[97,7,98,7],[93,1,95,1],[93,2,95,2],[93,3,95,3],[93,4,95,4],[93,5,95,5],[94,6,95,6],[90,1,92,1],[90,2,92,2],[90,3,92,3],[90,4,92,4],[90,5,92,5],[91,6,92,6],[91,7,92,7],[91,8,92,8],[91,9,92,9],[87,1,89,1],[87,2,89,2],[87,3,89,3],[87,4,89,4],[87,5,89,5],[88,6,89,6],[88,7,89,7],[88,8,89,8],[88,9,89,9],[84,1,86,1],[84,2,86,2],[84,3,86,3],[84,4,86,4],[84,5,86,5],[85,6,86,6],[85,7,86,7],[85,8,86,8],[85,9,86,9],[81,1,83,1],[81,2,83,2],[81,3,83,3],[81,4,83,4],[81,5,83,5],[82,6,83,6],[82,7,83,7],[82,8,83,8],[82,9,83,9],[71,1,71,9],[72,1,72,7],[72,8,72,9],[73,1,73,7],[73,8,73,9],[78,1,80,1],[78,2,80,2],[78,3,80,3],[78,4,80,4],[78,5,80,5],[79,6,80,6],[79,7,80,7],[79,8,80,8],[79,9,80,9],[64,1,64,9],[65,1,65,9],[66,1,66,9],[67,1,67,9],[68,1,68,9],[69,1,69,9],[58,1,58,9],[59,1,59,9],[60,1,60,9],[61,1,61,9],[62,1,62,9],[63,1,63,9],[50,2,50,6],[51,2,51,6],[53,1,53,9],[54,2,54,5],[55,2,55,5],[56,1,57,9],[44,2,44,6],[45,2,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[39,2,39,5],[40,1,40,6],[40,7,40,9],[41,2,41,6],[42,2,42,6],[43,2,43,6],[35,6,36,6],[37,0,38,0],[37,1,38,1],[37,2,38,2],[37,3,38,3],[37,4,38,4],[37,5,38,5],[37,6,38,6],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[35,5,36,5],[31,6,32,6],[33,0,34,0],[33,1,34,1],[33,2,34,2],[33,3,34,3],[33,4,34,4],[33,5,34,5],[33,6,34,6],[31,0,32,0],[31,1,32,1],[31,2,32,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[27,6,28,6],[29,0,30,0],[29,1,30,1],[29,2,30,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,6],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[23,6,24,6],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,6],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,6],[17,5,18,5],[17,6,18,6],[17,10,18,10],[17,11,18,11],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[11,3,11,9],[13,1,14,9],[15,1,15,6],[15,7,15,9],[16,2,16,3],[17,0,18,0],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[19,6,20,6],[1,3,5,9],[6,11,6,12],[7,2,10,2],[7,3,7,9],[7,13,7,15],[8,3,9,9],[8,10,9,10],[8,11,9,11],[9,13,12,15],[10,3,10,9]]}
[null,null,null,"Ordre",null,null,null,null,"",{"$f":"IF(ISERROR(TEXT(\"A\"&L9&\" - \"&I1&\" - Circulaire - \"&D4&\" \"&K3,\"@\")),TEXT(\"A\"&L9&\" - \"&I1&\" - Circulaire - \"&D4&\" \"&K3,\"@\"),TEXT(\"A\"&L9&\" - \"&I1&\" - Circulaire - \"&D4&\" \"&K3,\"@\"))","v":{"$error":"#VALUE!"}},"C:\\Users\\Utilisateur\\Documents\\GYMNASTIQUE\\BFC\\Saison 2017-2018\\Circulaires\\"]
[null,"",null,"GR - Formation Juge 1",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,"","DISCIPLINE - TITRE DE LA FORMATION"]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"."]
[null,null,null,"RESPONSABLE :"]
[null,null,null,"Fabienne RAZZOLINI",null,null,null,null,null,null,{"$f":"TODAY()+K13","v":"2021-06-03"},"NOM et Prénom du responsable de l'action"]
[]
[null,null,null,"06 01 14 26 53",null,null,null,null,null,null,"","Portable"]
[null,null,null,"fabienne.razzolini@hotmail.fr",null,null,null,null,null,null,"","Mail"]
[null,{"$f":"IF(O3=\"\",\"\",IF(O3<>O4,\"Débutera le \"&TEXT(DATE(YEAR(O3),MONTH(O3),DAY(O3)),\"jj mmmm aaaa\")&IF(P3=\"\",\"\",\" à \"&HOUR(P3)&\"h\"&TEXT(MINUTE(P3),\"00\"))&\"\n et se terminera le \"&TEXT(DATE(YEAR(O4),MONTH(O4),DAY(O4)),\"jj mmmm aaaa\")&IF(P4=\"\",\"\",\" à \"&HOUR(P4)&\"h\"&TEXT(MINUTE(P4),\"00\")),\"Le \"&TEXT(DATE(YEAR(O3),MONTH(O3),DAY(O3)),\"jj mmmm aaaa\")&IF(P3=\"\",\"\",IF(P4=\"\",\" à \",\" de \")&HOUR(P3)&\"h\"&TEXT(MINUTE(P3),\"00\"))&IF(P4=\"\",\"\",\" à \"&HOUR(P4)&\"h\"&TEXT(MINUTE(P4),\"00\"))))","v":""},null,null,null,null,null,null,null,null,0]
[null,"Tous les participants doivent être licenciés pour la saison en cours.",null,null,null,null,null,null,null,null,{"$f":"TEXT(K9-(K10-1),\"jj/mm/aaaa\")","v":"04/06/2021"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(K9-(K10-1)+6,\"jj/mm/aaaa\")","v":"10/06/2021"}]
[null,"Planning",null,null,null,null,null,"Lieux restauration et hébergement",null,null,{"$f":"WEEKNUM(K14)","v":23}]
[null,"Dates","Horaires",null,"Libellé","Ville","Lieu","Déjeuner","Diner","Nuitée+pdj"]
[null,"2017-12-03","09:00:00","18:00:00","Formation","Besançon","Gymnase La St-Claude","Repas tiré du sac","Cafétéria Casino","Hôtel Formule 1",{"$f":"TODAY()+K22","v":{"$error":"#VALUE!"}},"Date : tapez 3/12/17\nHeure : 9:00"]
[null,null,null,null,null,null,null,null,"Besançon","Besançon"]
[null,"2017-12-04","09:00:00","18:00:00","Formation","Besançon","Gymnase La St-Claude","Cafétéria Casino",null,null,""]
[null,null,null,null,null,null,null,"Besançon"]
[null,"2018-01-06","09:00:00","18:00:00","Formation","Marsannay la Côte","Espace Wallon","Repas tiré du sac","Flunch","Hôtel les Balladins",""]
[null,null,null,null,null,null,null,null,"Marsanay la Côte","Marsanay la Côte"]
[null,"2018-01-07","09:00:00","18:00:00","Examen","Marsannay la Côte","Espace Wallon","Flunch",null,null,""]
[null,null,null,null,null,null,null,"Marsanay la Côte"]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,"Lieux",null,null,null,null,null,"Prix unitaire non prix en charge par le Comité régional"]
[null,"Nom","Adresse",null,null,null,null,"Déjeuner","Diner","Nuitée+pdj"]
[null,"Gymnase la St-Claude","37, rue Francis Clerc - 25000 BESANÇON",null,null,null,null,0,0,0,"","Nom et adresse du lieu. Tarif unitaire"]
[null,"Cafétéria Casino","Zone commerciale Chateaufarine - 25000 BESANÇON",null,null,null,null,12.5,12.5,0,"","Nuitée + petit-déjeuner + taxe de séjour"]
[null,"Hôtel Formule 1","Rte de Chatillon le Duc - ZAC Valentin Centre - 25000 BESANÇON",null,null,null,null,0,0,42.4]
[null,"Espace Wallon","43, avenue Marguerite de Salin - 21160 MARSANNAY LA COTE",null,null,null,null,0,0,0,""]
[null,"Flunch","Parc Acti Sud, Centre Commercial Leclerc - 21160 MARSANNAY LA COTE",null,null,null,null,13,13,0]
[null,"Hôtel les Balladins","84, route de Beaume - 21160 MARSANNAY LA COTE",null,null,null,null,0,0,46.2]
[null,"","",null,null,null,null,0,0,0,""]
[null,"","",null,null,null,null,0,0,0]
[null,"","",null,null,null,null,0,0,0]
[null,"","",null,null,null,null,0,0,0,""]
[]
[null,"Tarifs"]
[null,"TOTAL","Autres",null,null,null,"Frais péda.","Total déjeuners","Total diners","Total nuitées"]
[null,{"$f":"SUM(C56:J56)","v":169.6},{"$f":"M56","v":0},null,null,null,30,25.5,25.5,{"$f":"42.4+46.2","v":88.6},"","Calculer les totaux par type déjeuner etc."]
[]
[]
[null,"Obsersations et Prérequis"]
[null,null,null,null,null,null,null,null,null,null,"","Vos observations et prérequis"]
[null,"Avoir 16 ans en 2018"]
[null,"Avoir un livret de juge"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Inscription"]
[null,"Lien pour s'incrire",null,null,null,null,null,null,"Date limite d'inscription"]
[null,null,null,null,null,null,null,null,"2017-11-03",null,"","Date de fin d'inscription"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"WEEKNUM(K75)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"",null,{"$error":"#REF!"}]
[null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,{"$f":"\"Z\"&L9","v":"ZNOM et Prénom du responsable de l'action"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Template Google"]
[]
[null,null,null,null,null,null,null,{"$f":"CLEAN(N8)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"CLEAN(D4)","v":""}]
[]
[null,null,null,null,null,null,null,null,"Repas du midi","Repas du soir","Nuitée et petit déjeuner"]
[null,null,null,null,null,null,null,"",null,null,{"$f":"IF(H135>\"\",\"<<\"&SUBSTITUTE(H135,\" \",\"\")&$K$134&\">>\",\"\")","v":""},null,{"$f":"CLEAN(H130)","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$S$25:$S$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$S$25:$S$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$S$25:$S$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H136>\"\",IF(D$18=1,\"<<\"&H136&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H136>\"\",IF(F$18=1,\"<<\"&H136&\" [\"&$J$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H136>\"\",IF(E$18=1,\"<<\"&H136&\" [\"&$K$134&\"]>>\",\"-----\"),\"\")","v":""},null,{"$f":"CLEAN(H130&\" - <<NOM Prénom>>\")","v":" - <<NOM Prénom>>"}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$T$25:$T$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$T$25:$T$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$T$25:$T$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H137>\"\",IF(D$22=1,\"<<\"&H137&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H137>\"\",IF(F$22=1,\"<<\"&H137&\" [\"&$J$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H137>\"\",IF(E$22=1,\"<<\"&H137&\" [\"&$K$134&\"]>>\",\"-----\"),\"\")","v":""},null,"<<Mail>>"]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$U$25:$U$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$U$25:$U$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$U$25:$U$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H138>\"\",IF(D$26=1,\"<<\"&H138&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H138>\"\",IF(F26=1,\"<<\"&SUBSTITUTE(H138,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H138>\"\",IF(E26=1,\"<<\"&SUBSTITUTE(H138,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""},null,"<<Mail du club>>"]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$V$25:$V$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$V$25:$V$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$V$25:$V$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H139>\"\",IF(D$29=1,\"<<\"&H139&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H139>\"\",IF(F29=1,\"<<\"&SUBSTITUTE(H139,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H139>\"\",IF(E29=1,\"<<\"&SUBSTITUTE(H139,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$W$25:$W$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$W$25:$W$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$W$25:$W$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H140>\"\",IF(D$32=1,\"<<\"&H140&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H140>\"\",IF(F32=1,\"<<\"&SUBSTITUTE(H140,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H140>\"\",IF(E32=1,\"<<\"&SUBSTITUTE(H140,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$X$25:$X$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$X$25:$X$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$X$25:$X$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H141>\"\",IF(D$43=1,\"<<\"&H141&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H141>\"\",IF(E43=1,\"<<\"&SUBSTITUTE(H141,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H141>\"\",IF(F43=1,\"<<\"&SUBSTITUTE(H141,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Y$25:$Y$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Y$25:$Y$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Y$25:$Y$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H142>\"\",IF(D$46=1,\"<<\"&H142&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H142>\"\",IF(E46=1,\"<<\"&SUBSTITUTE(H142,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H142>\"\",IF(F46=1,\"<<\"&SUBSTITUTE(H142,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Z$25:$Z$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(ISERROR(DGET(#REF!,\"Du\",$Z$25:$Z$26)),\"\",PROPER(TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"'jjjj\"))&\" \"&TEXT(DGET(#REF!,\"Du\",$Z$25:$Z$26),\"j mmmm aaaa\"))","v":""},{"$f":"IF(H143>\"\",IF(D$49=1,\"<<\"&H143&\" [\"&$I$134&\"]>>\",\"-----\"),\"\")","v":""},{"$f":"IF(H143>\"\",IF(E49=1,\"<<\"&SUBSTITUTE(H143,\" \",\"\")&$J$134&\">>\",\"-----\"),\"\")","v":""},{"$f":"IF(H143>\"\",IF(F49=1,\"<<\"&SUBSTITUTE(H143,\" \",\"\")&$K$134&\">>\",\"-----\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,{"$f":"\"<<NOM Prénom>>,\n\nNous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n\"&D2&\" - \"&D4&\"\n\n\"&N10&\"\n\nVeuillez trouver ci-joint un résumé de votre réservation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Franche-Comté\"","v":"<<NOM Prénom>>,\n\nNous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\nGR - Formation Juge 1 - \n\n\n\nVeuillez trouver ci-joint un résumé de votre réservation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Franche-Comté"},{"$f":"G145","v":"<<NOM Prénom>>,\n\nNous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\nGR - Formation Juge 1 - \n\n\n\nVeuillez trouver ci-joint un résumé de votre réservation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Franche-Comté"}]
[null,null,null,null,null,null,null,"Réponse :"]
[null,null,null,null,null,null,{"$f":"\"Nous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\n\"&D2&\" - \"&D4&\"\n\n\"&N10&\"\n\nNous vous avons adressé un mail de confirmation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Bourgogne-Franche-Comté\"","v":"Nous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\nGR - Formation Juge 1 - \n\n\n\nNous vous avons adressé un mail de confirmation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Bourgogne-Franche-Comté"},{"$f":"G147","v":"Nous vous confirmons avoir bien enregistré votre réservation pour l'action régionale suivante :\n\nGR - Formation Juge 1 - \n\n\n\nNous vous avons adressé un mail de confirmation.\n\nBien cordialement,\n\nDamien GARCIA\nComité Régional de Gymnastique\nde Bourgogne-Franche-Comté"}]