{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inscriptions","Chiffrage Détaillé","Boutons Macro","Références"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":68,"comments":2,"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":"Inscriptions","index":0,"n_rows":100,"n_cols":32,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,3,0,10],[2,5,2,7],[3,5,3,7]]}
[null,null,null,"JEUX NATIONAUX D'ÉTÉ AUDIOVISUEL\nBORDEAUX 30 Mai au 1er Juin 2020\n\nRECAPITULATIF REGION(S)"]
[]
[null,null,null,null,"Mise à jour ","    TOTAL A ENCAISSER :  ",null,null,{"$f":"SUM(Total_Couts)","v":0}]
[null,null,null,null,"2020-03-01","    TOTAL ENCAISSE : ",null,null,{"$f":"SUMIF(Payé,\"OUI\",Total_Couts)","v":0}]
[]
[null,null,null,"Cellule AS à Renseigner Obligatoirement",null,{"$f":"IF(E6=\"TOTAL_REGIONS\",'Chiffrage Détaillé'!Total_Participant,COUNTIF(Inscriptions_AS,E6))","v":0}]
[]
[null,null,"Saisir les données Impérativement dans l'ordre, de gauche à droite.",null,null,null,null,"Pour trier sur une colonne, double cliquer sur l'entête associée",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Options"]
["Payé","Date\nd'incription",{"$f":"\"NOM\"&\" (\"&COUNTA(NOM)&\" inscrits)\"","v":"NOM (0 inscrits)"},"Prénom","AS","Statut","N° carte","Société\n(Si  AGT)","Date de Naissance","Sexe",{"$f":"\"Age au \" &TEXT(Au_01_01_année_JNE, \"jj/mm/aa\")","v":"Age au 01/01/20"},"Catégorie\nAge","N° Téléphone\n(sans espace)"," Email\n(Préciser bien l'adresse Email)","Formules\nHébergement / Séjour\n(dont Enfant < 12 ans)",{"$f":"\"Option\nPique-Nique\nLundi midi\n(\"&COUNTA(Repas_3eJ)&\")\"","v":"Option\nPique-Nique\nLundi midi\n(0)"},"Affectation\nHôtel","Colocataire ou Conjoint\n(NOM & Prénom)","Moyen de Transport","Type Participation","Discipline 1\nPrincipale","N° Licence (D1)","Classement (D1)","Discipline 2\nSecondaire","N° Licence (D2)","Classement (D2)",{"$f":"\" EuroSports (\"&COUNTA(EuroSports)&\")\"","v":" EuroSports (0)"},{"$f":"Références!F12 & \" (\" & COUNTA(Option1)&\")\"","v":"Visite de la citée du vin  (0)"},{"$f":"Références!F13 & \" (\" & COUNTA(Option2)&\")\"","v":"Visite de la ville (0)"},{"$f":"Références!F14 & \" (\" & COUNTA(Option3)&\")\"","v":"Croisière sur la Garonne (0)"},"Repas\nContraintes Particulières","Total Coûts Participant"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(NOM=\"\",Date_Naissance=\"\"),\"\",DATEDIF(Date_Naissance,Au_01_01_année_JNE,\"y\"))","v":""},{"$f":"IF(OR(NOM=\"\",Date_Naissance=\"\"),\"\",IF(Age_01_01_année_JNE<Cat_junior,\"Junior\",IF(Age_01_01_année_JNE<Cat_senior,\"Sénior\",\"Vétéran\"))&\" \"&Sexe)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Hébergement=\"\",0,VLOOKUP(Hébergement,Tableau_Prix_Hebergement,2,FALSE))+IF(OR(P10=\"\",P10=\"Non\"),0,Repas_3eJ_Tarif)+IF(Option1<>\"x\",0,VLOOKUP(\"Option 1\",Tableau_Options,3,FALSE))+IF(Option2<>\"x\",0,VLOOKUP(\"Option 2\",Tableau_Options,3,FALSE))+IF(Option3<>\"x\",0,VLOOKUP(\"Option 3\",Tableau_Options,3,FALSE))","v":0}]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(NOM=\"\",Date_Naissance=\"\"),\"\",DATEDIF(Date_Naissance,Au_01_01_année_JNE,\"y\"))","v":""},{"$f":"IF(OR(NOM=\"\",Date_Naissance=\"\"),\"\",IF(Age_01_01_année_JNE<Cat_junior,\"Junior\",IF(Age_01_01_année_JNE<Cat_senior,\"Sénior\",\"Vétéran\"))&\" \"&Sexe)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Hébergement=\"\",0,VLOOKUP(Hébergement,Tableau_Prix_Hebergement,2,FALSE))+IF(OR(P36=\"\",P36=\"Non\"),0,Repas_3eJ_Tarif)+IF(Option1<>\"x\",0,VLOOKUP(\"Option 1\",Tableau_Options,3,FALSE))+IF(Option2<>\"x\",0,VLOOKUP(\"Option 2\",Tableau_Options,3,FALSE))+IF(Option3<>\"x\",0,VLOOKUP(\"Option 3\",Tableau_Options,3,FALSE))","v":0}]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(NOM=\"\",Date_Naissance=\"\"),\"\",DATEDIF(Date_Naissance,Au_01_01_année_JNE,\"y\"))","v":""},{"$f":"IF(OR(NOM=\"\",Date_Naissance=\"\"),\"\",IF(Age_01_01_année_JNE<Cat_junior,\"Junior\",IF(Age_01_01_année_JNE<Cat_senior,\"Sénior\",\"Vétéran\"))&\" \"&Sexe)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Hébergement=\"\",0,VLOOKUP(Hébergement,Tableau_Prix_Hebergement,2,FALSE))+IF(OR(P68=\"\",P68=\"Non\"),0,Repas_3eJ_Tarif)+IF(Option1<>\"x\",0,VLOOKUP(\"Option 1\",Tableau_Options,3,FALSE))+IF(Option2<>\"x\",0,VLOOKUP(\"Option 2\",Tableau_Options,3,FALSE))+IF(Option3<>\"x\",0,VLOOKUP(\"Option 3\",Tableau_Options,3,FALSE))","v":0}]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]
[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,0]

{"sheet":"Chiffrage Détaillé","index":1,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[16,10,16,11],[0,4,0,10],[1,4,1,10],[3,3,3,4],[3,8,3,9],[10,10,10,12],[14,10,14,11],[7,4,7,5],[4,8,4,9],[6,8,6,10],[7,8,7,10],[11,10,11,11],[12,10,12,11],[13,10,13,11],[47,1,49,1],[47,2,47,3],[37,3,40,3],[48,2,48,3],[41,3,44,3],[17,13,18,13],[19,13,20,13],[21,13,22,13],[35,1,36,1],[17,12,18,12],[19,12,20,12],[21,12,22,12],[29,4,29,7],[30,5,30,6],[31,5,31,6],[32,5,32,6],[35,6,35,8],[35,2,36,3],[31,10,33,10],[25,10,25,11],[48,10,48,11],[48,12,50,12],[48,4,48,5],[48,6,48,7],[48,8,48,9],[49,10,49,11],[39,6,40,7],[39,8,40,8],[47,4,47,5],[47,6,47,7],[47,8,47,9]]}
[null,null,null,null,"JEUX NATIONAUX D'ÉTÉ AUDIOVISUEL\nBORDEAUX 30 Mai au 1er Juin 2020"]
[null,null,null,null,"CHIFFRAGE DETAILLÉ REGION(S)"]
[]
[null,"Dernière Mise à Jour",null,"TOTAL_REGIONS",null,null,null,null,"TOTAL à ENCAISSER :",null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUM(Total_Couts),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Total_Couts)*1))","v":0}]
[null,{"$f":"Inscriptions!E4","v":"2020-03-01"},null,null,null,null,null,null,"TOTAL encaissé :",null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMIF(Payé,\"OUI\",Total_Couts),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Payé=\"OUI\")*(Total_Couts)))","v":0}]
[]
[null,null,null,null,null,null,null,null,"Reste à encaisser"]
[null,"AS Régionales ","Nbre Inscrits",null,"Type Participation",null,null,null,{"$f":"K4-K5","v":0}]
[null,"ALPES",{"$f":"COUNTIF(Inscriptions_AS,B9)","v":0},null,"Accompagnateur",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Type_Participation,E9),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Type_Participation=E9)*1))","v":0}]
[null,"ALSACE",0,null,"Compétiteur",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Type_Participation,E10),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Type_Participation=E10)*1))","v":0}]
[null,"AQUITAINE",0,null,null,null,null,null,null,null,"Répartition"]
[null,"BFC",0,null,"Disciplines","Principale","Secondaire","Total","Euro",null,"Nbre Noms Inscrits",null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTA(NOM),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(NOM<>\"\")*1))","v":0}]
[null,"CORSE",0,null,"Aucune",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((NOM<>\"\")*1,(Discipline1=E13)*1)+SUMPRODUCT((NOM<>\"\" )*1,(Discipline1=\"\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E13)*1)+SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=0)*1))","v":0},null,null,null,null,"Hommes",null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Sexe=\"H\")*(NOM<>\"\")),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Sexe=\"H\")*(NOM<>\"\")))","v":0}]
[null,"COTES D'AZUR",0,null,"Bowling",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E14),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E14)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E14),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E14)*1)))","v":0},{"$f":"F14+G14","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E14)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E14)*1,(EuroSports=\"X\")*1))","v":0},null,"Femmes",null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Sexe=\"F\")*(NOM<>\"\")),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Sexe=\"F\")*(NOM<>\"\")))","v":0}]
[null,"LCA",0,null,"Course 3 Km",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,\"Course*3*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline1=E15)*1)+((Discipline1=Courses_Toutes)*1)))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,\"Course*3*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E15)*1)+((Discipline2=Courses_Toutes)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E15)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E15)*1,(EuroSports=\"X\")*1))","v":0},null,"Enfants ( < 12 ans )",null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Age_01_01_année_JNE,\"<12\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Age_01_01_année_JNE<12)*1))","v":0}]
[null,"LIMOUSIN",0,null,"Course 10 Km",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,\"Course*10*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline1=E16)*1)+((Discipline1=Courses_Toutes)*1)))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,\"Course*10*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E16)*1)+((Discipline2=Courses_Toutes)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT(((Discipline1=E16)*1)+((Discipline1=Courses_Toutes)*1),(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline1=E16)*1)+((Discipline1=Courses_Toutes)*1),(EuroSports=\"X\")*1))","v":0}]
[null,"MIDI PYRENEES",0,null,"Cyclisme Ligne",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,\"*L*gn*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline1=E17)*1)))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,\"*L*gn*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E17)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E17)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E17)*1,(EuroSports=\"X\")*1))","v":0},null,"Catégories Age",null,"Total"]
[null,"NORD",{"$f":"COUNTIF(Inscriptions_AS,B18)","v":0},null,"Cyclisme Montre",null,null,{"$f":"F18+G18","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E18)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E18)*1,(EuroSports=\"X\")*1))","v":0},null,"Junior F",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Categorie,K18),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Categorie=K18)*1))","v":0},{"$f":"L18+L19","v":0},"< 18 ans"]
[null,"NORMANDIE",0,null,"Football",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E19),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E19)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E19),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E19)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E19)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E19)*1,(EuroSports=\"X\")*1))","v":0},null,"Junior H",0]
[null,"OUEST",0,null,"Golf",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E20),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E20)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E20),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E20)*1)))","v":0},{"$f":"F20+G20","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E20)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E20)*1,(EuroSports=\"X\")*1))","v":0},null,"Sénior F",0,{"$f":"L20+L21","v":0},{"$f":" \"< \" & [1]Références!F19 &\" ans\"","v":"< 50 ans"}]
[null,"PARIS",0,null,"Natation 50m",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,\"Natation*50*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline1=E21)*1)+((Discipline1=Natation_Toutes)*1)))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,\"Natation*50*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E21)*1)+((Discipline2=Natation_Toutes)*1)))","v":0},{"$f":"F21+G21","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E21)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E21)*1,(EuroSports=\"X\")*1))","v":0},null,"Sénior H",0]
[null,"PROVENCE",0,null,"Natation 100m",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,\"Natation*100*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E22)*1)+SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=Natation_Toutes)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,\"Natation*100*\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E22)*1)+((Discipline2=Natation_Toutes)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT(((Discipline1=E22)*1)+((Discipline1=Natation_Toutes)*1),(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline1=E22)*1)+((Discipline1=Natation_Toutes)*1),(EuroSports=\"X\")*1))","v":0},null,"Vétéran F",0,{"$f":"L22+L23","v":0},{"$f":" \">= \" & [1]Références!F19 &\" ans\"","v":">= 50 ans"}]
[null,"RHÔNE",0,null,"Pétanque",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E23),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E23)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E23),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E23)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E23)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E23)*1,(EuroSports=\"X\")*1))","v":0},null,"Vétéran H",0]
[null,"TOTAL",{"$f":"SUM(C9:C23)","v":0},null,"Tennis",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E24),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E24)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E24),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E24)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E24)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E24)*1,(EuroSports=\"X\")*1))","v":0},null,"TOTAL",{"$f":"SUM(L18:L23)","v":0}]
[null,null,null,null,"Tennis de Table",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E25),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E25)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E25),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E25)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E25)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E25)*1,(EuroSports=\"X\")*1))","v":0}]
[null,null,null,null,"Beach-Volley",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline1,E26),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E26)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Discipline2,E26),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,((Discipline2=E26)*1)))","v":0},0,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",SUMPRODUCT((Discipline1=E26)*1,(EuroSports=\"X\")*1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Discipline1=E26)*1,(EuroSports=\"X\")*1))","v":0},null,"Type Repas"]
[null,"Moyens de Transport","Nb Pers",null,"TOTAL",{"$f":"SUM(F13:F26)","v":0},null,null,{"$f":"SUM(I14:I26)","v":0},null,"Classique",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Nb_Végétariens,K27),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Nb_Végétariens=K27)*1))","v":0}]
[null,"Voiture",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Transport,B28),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Transport=B28)*1))","v":0},null,null,null,null,null,null,null,"Végétarien",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Nb_Végétariens,K28),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Nb_Végétariens=K28)*1))","v":0}]
[null,"Mini Bus",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Transport,B29),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Transport=B29)*1))","v":0},null,null,null,null,null,null,null,"Allergies",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Nb_Végétariens,K29),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Nb_Végétariens=K29)*1))","v":0}]
[null,"Car",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Transport,B30),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Transport=B30)*1))","v":0},null,"Options",null,null,null,null,null,"Autres contraintes",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Nb_Végétariens,K30),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Nb_Végétariens=K30)*1))","v":0}]
[null,"Train",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Transport,B31),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Transport=B31)*1))","v":0},null,"Option 1",{"$f":"Références!F12","v":"Visite de la citée du vin "},null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTA(Option1),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Option1=\"X\")*1))","v":0}]
[null,"Avion",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Transport,B32),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Transport=B32)*1))","v":0},null,"Option 2",{"$f":"Références!F13","v":"Visite de la ville"},null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTA(Option2),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Option2=\"X\")*1))","v":0},null,null,"Pique-Nique lundi midi","Non",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF((Repas_3eJ),L32),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Repas_3eJ=L32)*1))","v":0}]
[null,"TOTAL",{"$f":"SUM(C28:C32)","v":0},null,"Option 3",{"$f":"Références!F14","v":"Croisière sur la Garonne"},null,{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTA(Option3),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Option3=\"X\")*1))","v":0},null,null,null,"Oui",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF((Repas_3eJ),L33),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Repas_3eJ=L33)*1))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"A emporter",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF((Repas_3eJ),L34),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Repas_3eJ=L34)*1))","v":0}]
[]
[null,"Hébergement / Séjour\n(dont Enfant < 12 ans)","Nb Participants avec Hébergement",null,null,null,"Nb Participants sans Hébergement"]
[null,null,null,null,"Nb Chambres",null,"Adultes","Enfant < 12 ans","Total"]
[null,"2 Nuitées - Twin",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B51)*1),SUMPRODUCT((Hébergement=B51)*1))","v":0},{"$f":"SUM(C38:C41)","v":0},{"$f":"C38/2","v":0},null,{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=\"Sans Hébergement\")*1),SUMPRODUCT((Hébergement=\"Sans Hébergement\")*1))","v":0},{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=\"Sans Hébergement - Enfant\")*1),SUMPRODUCT((Hébergement=\"Sans Hébergement - Enfant\")*1))","v":0},{"$f":"H38+G38","v":0}]
[null,"2 Nuitées - Couple",0,null,{"$f":"C39/2","v":0}]
[null,"2 Nuitées - Twin - Enfant",0,null,0,null,"TOTAL - Avec et Sans\nHébergement :",null,{"$f":"D46+I38","v":0}]
[null,"2 Nuitées - Single",0]
[null,"3 Nuitées - Twin",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B55)*1),SUMPRODUCT((Hébergement=B55)*1))","v":0},{"$f":"SUM(C42:C45)","v":0},0]
[null,"3 Nuitées - Couple",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B56)*1),SUMPRODUCT((Hébergement=B56)*1))","v":0},null,0]
[null,"3 Nuitées - Twin - Enfant",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B57)*1),SUMPRODUCT((Hébergement=B57)*1))","v":0},null,0]
[null,"3 Nuitées - Single",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B58)*1),SUMPRODUCT((Hébergement=B58)*1))","v":0}]
[null,"TOTAL",{"$f":"SUM(C38:C45)","v":0},{"$f":"SUM(D38:D45)","v":0},null,null,"* N.B : Single non prévue pour enfants < 12 ans"]
[]
[null,"Détails\nHébergement / Séjour\n(dont Enfant < 12 ans)",{"$f":"Références!F5","v":"Village Corsaire"},null,{"$f":"Références!F6","v":"Hotel 2"},null,{"$f":"Références!F7","v":"Hotel 3"},null,{"$f":"Références!F8","v":"Hotel 4"}]
[null,null,{"$f":"IF(Références!G5=\"\",\"\",Références!G5)","v":"(300 places)"},null,{"$f":"IF(Références!G6=\"\",\"\",Références!G6)","v":""},null,{"$f":"IF(Références!G7=\"\",\"\",Références!G7)","v":""},null,{"$f":"IF(Références!G8=\"\",\"\",Références!G8)","v":""},null,{"$f":"Références!F9","v":"Hotel 5"},null,"Total\nNb Pers.\navec Hôtel"]
[null,null,"Nb Pers","Nb Ch","Nb Pers","Nb Ch","Nb Pers","Nb Ch","Nb Pers","Nb Ch",{"$f":"IF(Références!G9=\"\",\"\",Références!G9)","v":""}]
[null,"2 Nuitées - Twin",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B51)*1,(Hotel=Hotel1)*1),SUMPRODUCT((Hébergement=B51)*1,(Hotel=Hotel1)*1))","v":0},{"$f":"C51/2","v":0},{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B51)*1,(Hotel=Hotel2)*1),SUMPRODUCT((Hébergement=B51)*1,(Hotel=Hotel2)*1))","v":0},{"$f":"E51/2","v":0},{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B51)*1,(Hotel=Hotel3)*1),SUMPRODUCT((Hébergement=B51)*1,(Hotel=Hotel3)*1))","v":0},{"$f":"G51/2","v":0},{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B51)*1,(Hotel=Hotel4)*1),SUMPRODUCT((Hébergement=B51)*1,(Hotel=Hotel4)*1))","v":0},{"$f":"I51/2","v":0},"Nb Pers","Nb Ch"]
[null,"2 Nuitées - Couple",0,0,0,{"$f":"E52/2","v":0},0,{"$f":"G52/2","v":0},0,{"$f":"I52/2","v":0},{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B51)*1,(Hotel=Hotel5)*1),SUMPRODUCT((Hébergement=B51)*1,(Hotel=Hotel5)*1))","v":0},{"$f":"K52/2","v":0},{"$f":"C51+E51+G51+I51+K52","v":0}]
[null,"2 Nuitées - Twin - Enfant",0,0,0,{"$f":"E53/2","v":0},0,{"$f":"G53/2","v":0},0,{"$f":"I53/2","v":0},0,{"$f":"K53/2","v":0},0]
[null,"2 Nuitées - Single",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B54)*1,(Hotel=Hotel1)*1),SUMPRODUCT((Hébergement=B54)*1,(Hotel=Hotel1)*1))","v":0},{"$f":"C54","v":0},0,{"$f":"E54","v":0},0,{"$f":"G54","v":0},0,{"$f":"I54","v":0},0,{"$f":"K54/2","v":0},0]
[null,"3 Nuitées - Twin",0,0,0,{"$f":"E55/2","v":0},0,{"$f":"G55/2","v":0},0,{"$f":"I55/2","v":0},0,{"$f":"K55","v":0},0]
[null,"3 Nuitées - Couple",0,0,0,{"$f":"E56/2","v":0},0,{"$f":"G56/2","v":0},0,{"$f":"I56/2","v":0},0,{"$f":"K56/2","v":0},0]
[null,"3 Nuitées - Twin - Enfant",0,0,0,{"$f":"E57/2","v":0},0,{"$f":"G57/2","v":0},0,{"$f":"I57/2","v":0},0,{"$f":"K57/2","v":0},0]
[null,"3 Nuitées - Single",{"$f":"IF(Nom_Région<>\"TOTAL_REGIONS\",SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Hébergement=B58)*1,(Hotel=Hotel1)*1),SUMPRODUCT((Hébergement=B58)*1,(Hotel=Hotel1)*1))","v":0},{"$f":"C58","v":0},0,{"$f":"E58","v":0},0,{"$f":"G58","v":0},0,{"$f":"I58","v":0},0,{"$f":"K58/2","v":0},0]
[null,"TOTAL",{"$f":"SUM(C51:C58)","v":0},{"$f":"SUM(D51:D58)","v":0},{"$f":"SUM(E51:E58)","v":0},0,0,0,0,0,0,{"$f":"K59","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,"Statistiques","FTV","INA","RF","TDF","Total\nAGT","CJT","EXT","ENF - & +"]
[null,"Nb Agents",{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Société,C61),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Société=C61)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Société,D61),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Société=D61)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Société,E61),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Société=E61)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Société,F61),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Société=F61)*1))","v":0},{"$f":"SUM(C62:F62)","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Statut,H61),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Statut=H61)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Statut,I61),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(Statut=I61)*1))","v":0},{"$f":"IF(Nom_Région=\"TOTAL_REGIONS\",COUNTIF(Statut,\"ENF?\"),SUMPRODUCT((Inscriptions_AS=Nom_Région)*1,(MID(Statut,1,3)=\"ENF\")*1))","v":0},"Total\nHors AGT"]
[null,"% / Total Agents",{"$f":"IF(C62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",C62/COUNTIF(Statut,\"AGT\"),C62/Total_Agents),0)","v":0},{"$f":"IF(D62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",D62/COUNTIF(Statut,\"AGT\"),D62/Total_Agents),0)","v":0},{"$f":"IF(E62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",E62/COUNTIF(Statut,\"AGT\"),E62/Total_Agents),0)","v":0},{"$f":"IF(F62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",F62/COUNTIF(Statut,\"AGT\"),F62/Total_Agents),0)","v":0},{"$f":"SUM(C63:F63)","v":0},null,null,null,{"$f":"SUM(H62:J62)","v":0}]
[null,"% / Total Participants",{"$f":"IF(C62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",C62/Total_Participant,C62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0},{"$f":"IF(D62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",D62/Total_Participant,D62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0},{"$f":"IF(E62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",E62/Total_Participant,E62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0},{"$f":"IF(F62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",F62/Total_Participant,F62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0},{"$f":"SUM(C64:F64)","v":0},{"$f":"IF(H62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",H62/Total_Participant,H62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0},{"$f":"IF(I62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",I62/Total_Participant,I62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0},{"$f":"IF(J62<>0,IF(Nom_Région=\"TOTAL_REGIONS\",J62/Total_Participant,J62/VLOOKUP(Nom_Région,Tableau_Régions,2)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,"ENF- : < 18 ans",{"$f":"SUM(H64:J64)","v":0}]
[null,null,null,null,null,null,null,null,null,"ENF+ : 18 à 25 ans"]

{"sheet":"Boutons Macro","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
["Bouton Import Inscription Individuelle"]
[]
["Prérequis :","- Placer le fichier INSCRIPTION de préférence dans le même répertoire que le fichier REGION ou RECAP_REGION"]
[null,"- Contrôler le remplissage correcte du fichier Inscription Individuelle, avant toute commande d'Import"]
[null,"- Vérifier la conformité du Nom du fichier REGION ou RECAP utilisé (sinon le corriger) : "]
[null,null,null,"Si fichier REGION : ",{"$f":"Références!D29","v":"JNE_BORDEAUX_2020_REGION"}]
[null,null,null,"Si fichier RECAP :  ",{"$f":"Références!D27","v":"JNE_BORDEAUX_2020_RECAP_REGIONS"}]
[]
["Informations :","Peu importe le nom initial du fichier INSCRIPTION, il sera renomé avec rajout du NOM & Prénom du Participant"]
[]
[]
[]
[]
[]
[]
[]
["Bouton Import Inscriptions Région"]
[]
["Prérequis :","- Placer le fichier REGION d'une AS de préférence dans le même répertoire que le fichier RECAP_ REGIONS"]
[null,"- Contrôler le bon format de l'onglet \" Inscriptions \" et son remplissage correcte, avant toute commande d'Import"]
[null,"et surtout le champs AS (ligne 6) qui doit impérativement renseigné le nom de l'AS"]
[null,"- Vérifier la conformité du Nom du fichier  RECAP (sinon le corriger) : ",null,null,null,null,{"$f":"Références!D27","v":"JNE_BORDEAUX_2020_RECAP_REGIONS"}]
[]
["Informations :","Peu importe le nom initial du fichier REGION il sera renomé avec rajout du NOM de l'AS"]
[]
[]
[]
[]
[]
[]
[]
["Bouton Suppression Lignes"]
[]
["Prérequis :","ATTENTION : Sélectionner au préalable, la ou les lignes entières contigues à supprimer dans l'onglet Inscriptions"]
[]
[]
[]
[]
[]
[]
["Bouton Création Fichier Région"]

{"sheet":"Références","index":3,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,1,0,5],[1,1,1,5],[30,3,30,5],[26,3,26,5],[28,3,28,5],[16,5,17,5],[3,4,3,6]]}
[null,"JEUX NATIONAUX D'ÉTÉ\nBORDEAUX 30 Mai au 1er Juin 2020"]
[null,"RÉFÉRENCES"]
[]
["Liste AS","Liste Société","Liste Séjour","Liste Prix Séjour","Hôtels &  Réservations",null,null,null,"Disciplines"]
["ALPES","FTV","2 Nuitées - Twin",150,"Hotel1","Village Corsaire","(300 places)",null,"Aucune"]
["ALSACE","INA","2 Nuitées - Couple",150,"Hotel2","Hotel 2",null,null,"Bowling"]
["AQUITAINE","RF","2 Nuitées - Single",220,"Hotel3","Hotel 3",null,null,"Course 3 Km"]
["BFC","TDF","3 Nuitées - Twin",185,"Hotel4","Hotel 4",null,null,"Course 10 Km"]
["CORSE",null,"3 Nuitées - Couple",185,"Hotel5","Hotel 5",null,null,"Course 3 & 10 Km"]
["COTES D'AZUR",null,"3 Nuitées - Single",290,null,null,null,null,"Cyclisme Ligne"]
["LCA",null,"Sans hébergement",77,"Options","Libellé Options","Tarifs",null,"Football"]
["LIMOUSIN",null,"2 Nuitées - Twin - Enfant",100,"Option 1","Visite de la citée du vin ",18,null,"Golf"]
["MIDI PYRENEES",null,"3 Nuitées - Twin - Enfant",120,"Option 2","Visite de la ville",12,null,"Natation 50m"]
["NORD",null,"Sans hébergement - Enfant",null,"Option 3","Croisière sur la Garonne",21,null,"Natation 100m"]
["NORMANDIE",null,null,null,null,null,null,null,"Natation 50 & 100m"]
["OUEST",null,"Option Repas Midi 3e Jour",null,"Junior :  <",18,null,null,"Pétanque"]
["PARIS",null,null,null,"Senior :  <",50,null,null,"Tennis"]
["PROVENCE",null,null,null,"Vétéran :  >=",null,null,null,"Tennis de Table"]
["RHÔNE",null,null,null,null,null,null,null,"Plongée"]
["TOTAL_REGIONS",null,"Au 01/0/année JNE :","2020-01-01"]
[]
[]
[]
[]
[]
[]
["Nom du fichier RECAP REGIONS :",null,null,"JNE_BORDEAUX_2020_RECAP_REGIONS"]
[]
["Nom du fichier Inscriptions REGION :",null,null,"JNE_BORDEAUX_2020_REGION"]
[]
["Nom du fichier Inscription Individuelle :",null,null,"JNE_BORDEAUX_2020_INSCRIPTION"]
[]
["Mdp pour Protection (onglet Inscription, Classeur et macros VBA) :",null,null,null,"JNEBDX"]
["(Autres onglets avec protecion sans MdP)"]