{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSCRIPTION","RESTAURATION","MODE D'EMPLOI","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"INSCRIPTION","index":0,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":false,"merged":[[20,0,21,0],[20,1,21,1],[20,6,21,6],[20,2,21,2],[20,4,21,4],[20,5,21,5],[13,4,14,6],[15,4,16,6],[10,7,10,8],[19,1,19,5],[0,0,0,7],[4,2,4,7],[5,1,5,7],[6,2,6,7],[7,1,7,7],[10,4,10,6],[10,2,10,3],[3,2,3,7],[13,0,15,2],[16,0,16,2]]}
["INSCRIPTIONS CHALLENGES COURONNE D'OR 2019"]
[]
[]
[null,"NOM DU GROUPE : ","……………………………………………………………………………………………………………………………………"]
[null,"ADRESSE :","……………………………………………………………………………………………………………………………………."]
[null,"……………………………………………………………………………………….………………………………………………………………………….."]
[null,"RESPONSABLE :","……………………………………………………………………………………………………………………………………."]
[null,"Tél : ………………………………………………………...… Mail : …………………..………………………………………"]
[]
[]
[null,"CATEGORIE",null,null,null,null,null,{"$f":"IF(C11=\"COMMUNES_MOSSIG_VIGNOBLE\",\"<= Choisissez la commune\",\"\")","v":""}]
[]
[]
["TOTAL PARTICIPANTS",null,null,null,"TOTAL A REGLER"]
[]
[null,null,null,null,{"$f":"(SUM(H23:H57)+RESTAURATION!D22)","v":0}]
[{"$f":"COUNTA(B23:B57)","v":0}]
[]
[]
[null,"PARTICIPANTS"]
["N°","NOM","PRENOM","Adresse ","AGE","Licence FFCT","CIRCUIT"]
[null,null,null,"Mail",null,null,null,"TARIF"]
[{"$f":"IF(ISBLANK(B23),\" \",\"1\")","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(B23),\" \",IF(ISBLANK(E23),IF(G23=\"MARCHE\",3,IF(F23=\"OUI\",3,5)),IF(E23<18,0,IF(G23=\"MARCHE\",3,IF(F23=\"oui\",3,5)))))","v":" "},{"$f":"IF(ISNUMBER(H23),IF(ISBLANK(G23),\"RENSEIGNEZ CIRCUIT\",\" \"),\" \")","v":" "}]
[{"$f":"IF(ISBLANK(B24),\" \",A23+1)","v":" "},null,null,null,null,null,null,{"$f":"IF(ISBLANK(B24),\" \",IF(ISBLANK(E24),IF(G24=\"MARCHE\",3,IF(F24=\"OUI\",3,5)),IF(E24<18,0,IF(G24=\"MARCHE\",3,IF(F24=\"oui\",3,5)))))","v":" "},{"$f":"IF(ISNUMBER(H24),IF(ISBLANK(G24),\"RENSEIGNEZ CIRCUIT\",\" \"),\" \")","v":" "}]
[" ",null,null,null,null,null,null," ",{"$f":"IF(ISNUMBER(H25),IF(ISBLANK(G25),\"RENSEIGNEZ CIRCUIT\",\" \"),\" \")","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,{"$f":"IF(ISBLANK(B31),\" \",IF(AND(ISBLANK(G31),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B32),\" \",IF(AND(ISBLANK(G32),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,"",null," "," ",null,null,null,{"$f":"IF(ISBLANK(B33),\" \",IF(AND(ISBLANK(G33),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,"",null," "," ",null,null,null,{"$f":"IF(ISBLANK(B34),\" \",IF(AND(ISBLANK(G34),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,"",null,"",null," "," ",null,null,null,{"$f":"IF(ISBLANK(B35),\" \",IF(AND(ISBLANK(G35),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,"",null,"",null," "," ",null,null,null,{"$f":"IF(ISBLANK(B36),\" \",IF(AND(ISBLANK(G36),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B37),\" \",IF(AND(ISBLANK(G37),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B38),\" \",IF(AND(ISBLANK(G38),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B39),\" \",IF(AND(ISBLANK(G39),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(B40),\" \",IF(ISBLANK(E40),IF(G40=\"MARCHE\",3,IF(F40=\"OUI\",3,5)),IF(E40<18,0,IF(G40=\"MARCHE\",3,IF(F40=\"oui\",3,5)))))","v":" "}," ",null,null,null,{"$f":"IF(ISBLANK(B40),\" \",IF(AND(ISBLANK(G40),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[{"$f":"IF(ISBLANK(B41),\" \",A40+1)","v":" "},null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B41),\" \",IF(AND(ISBLANK(G41),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B42),\" \",IF(AND(ISBLANK(G42),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B43),\" \",IF(AND(ISBLANK(G43),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B44),\" \",IF(AND(ISBLANK(G44),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B45),\" \",IF(AND(ISBLANK(G45),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B46),\" \",IF(AND(ISBLANK(G46),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B47),\" \",IF(AND(ISBLANK(G47),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B48),\" \",IF(AND(ISBLANK(G48),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B49),\" \",IF(AND(ISBLANK(G49),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B50),\" \",IF(AND(ISBLANK(G50),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B51),\" \",IF(AND(ISBLANK(G51),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B52),\" \",IF(AND(ISBLANK(G52),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B53),\" \",IF(AND(ISBLANK(G53),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null,{"$f":"IF(ISBLANK(B54),\" \",IF(ISBLANK(E54),IF(G54=\"MARCHE\",3,IF(F54=\"OUI\",3,5)),IF(E54<18,0,IF(G54=\"MARCHE\",3,IF(F54=\"oui\",3,5)))))","v":" "}," ",null,null,null,{"$f":"IF(ISBLANK(B54),\" \",IF(AND(ISBLANK(G54),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B55),\" \",IF(AND(ISBLANK(G55),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[" ",null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B56),\" \",IF(AND(ISBLANK(G56),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[{"$f":"IF(ISBLANK(B57),\" \",A56+1)","v":" "},null,null,null,null,null,null," "," ",null,null,null,{"$f":"IF(ISBLANK(B57),\" \",IF(AND(ISBLANK(G57),ISBLANK(#REF!),ISBLANK(#REF!)),1,0))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"","",""]

{"sheet":"RESTAURATION","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["PRODUITS","PRIX","NOMBRE","MONTANT"]
[]
["BOISSONS (Verre de vin ou crémant, bière, jus fruits, eau 50cl, limonade)",2,null,{"$f":"C3*B3","v":0}]
[]
["BOUTEILLE de VIN",12,null,0]
[]
["BOUTEILLE DE CREMANT",14,null,0]
[]
["TARTE FLAMBEE NORMALE",6,null,{"$f":"C9*B9","v":0}]
[]
["TARTE FLAMBEE GRATINEE OU SUCREE",7,null,{"$f":"C11*B11","v":0}]
[]
["PIZZA",7,null,0]
[]
["KNACKS",3,null,0]
[]
["BRETZEL",1,null,0]
[]
["CAFE",1,null,0]
[]
[]
[null,"TOTAL",null,{"$f":"SUM(D3:D21)","v":0}]

{"sheet":"MODE D'EMPLOI","index":2,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,0,3,1],[3,2,3,13],[0,0,0,13],[28,0,28,12],[30,2,30,10],[2,0,2,12],[5,0,5,1],[6,0,6,12],[32,2,32,10],[7,0,7,1],[12,0,12,1],[12,2,12,11],[14,0,14,1],[14,2,14,11],[7,2,7,12],[24,0,24,1],[26,2,26,11],[9,2,9,12],[16,0,16,1],[20,0,20,1],[20,2,21,11],[18,0,18,1],[18,2,18,11]]}
["REMPLISSAGE DES RUBRIQUES"]
[]
["L'onglet \"INSCRIPTION\" vous permet de saisir les participants de votre groupe et l'onglet \"RESTAURATION\" vous offre la possibilité de commander de la nourriture et des boissons à l'avance. Ainsi au jour de la manifestation vous seront remis des coupons correspondants à vos achats en même temps que vos cartes de route. "]
["PRECISION IMPORTANTE",null,"Il n'est pas nécessaire pour l'inscription du groupe que tous les participants pratiquent la même activité ni le même circuit. Vous êtes totalement libres, seul le nombre de personnes inscrites au groupe sera déterminant pour le classement final.     "]
[]
["INSCRIPTION"]
["Remplissez le 1er cadre avec l'ensemble des informations demandées (Nom, adresse,,,,,,). Ces données nous seront utiles afin de vous avertir si vous avez gagné, elles nous permettront également de vous recontacter lors des prochaines éditions.  "]
["CATEGORIE",null,"Renseignez la catégorie de challenge avec la liste déroulante de la cellule C11. Si vous avez choisi \"COMMUNES_MOSSIG_VIGNOBLE\", vous devrez préciser la commune dans la cellule suivante à l'aide de la liste déroulante qui vous sera proposée. "]
[]
["PARTICIPANTS",null," Saisissez vos inscriptions dans le tableau, en oubliant pas de mentionner le circuit choisi par personne "]
[]
[]
["AGE",null,"Le tarif est gratuit pour les mineurs. Si l'âge n'est pas précisé, le tarif \"Adulte\" est appliqué. "]
[]
["Licence FFCT",null,"Utiliser la liste déroulante. Mettre OUI si la personne est titulaire d'une licence FFCT au titre de l'année 2019, L'absence d'information sera considérée comme NON "]
[]
["CIRCUIT",null,"Utiliser les listes déroulantes pour  préciser le circuit prévu pour le participant. "]
[]
["TARIF",null,"Ne le renseignez pas, il tarif est calculé automatiquement à l'aide des informations que vous avez fournies.  "]
[]
["TABLEAU",null,"Si le nombre de participants dépasse 35, insérer des lignes suplémentaires en vous positionnant sur n'importe quelle ligne du tableau et faites un clic droit  et \"insérer\".   "]
[]
[]
[]
["RESTAURATION"]
[]
[null,null,"Précisez le nombre de produits que vous désirez dans la colonne adéquate, le montant sera calculé automatiquement et ajouté à votre total à régler de l'onglet INSCRIPTION  "]
[]
["Une fois votre saisie terminée, 2 actions sont à entreprendre : ENVOYER et REGLER "]
[]
["1 - ENVOYER ",null,"Envoyer par mail le tableau Excel renseigné à l'adresse suivante : f.arnould@evc.net  \nA réception, une confirmation de bonne transmission vous sera donnée"]
[]
["2 - REGLER",null,"Le montant total à régler vous est indiqué sur l'onglet INSCRIPTION. Il tient compte de toutes vos inscriptions mais également de la nourriture et boissons que vous avez réservées. 2 moyens de paiement vous sont proposés :\n\n1.Chèque à l'ordre \"RANDONNEURS DE STRASBOURG\" à envoyer à l'adresse suivante en précisant le nom du groupe au dos du chèque de manière à faire le rapprochement avec vos inscriptions.  \n\nARNOULD François\n38 rue de la Souffel\n67370 Griesheim sur souffel \n   \n2. Virement au compte IBAN : FR76 1513 5090 1708 7713 5897 821   BIC : CEPAFRPP513     en précisant également dans les commentaires l'objet du virement et le nom du groupe,\n \nUne facture vous sera délivrée par mail une fois votre règlement effectué, \n  "]
[]
[]
[]
["En cas de difficulté ou d'incompréhension des consignes, joignez-moi au 06.63.34.68.96"]

{"sheet":"Feuil2","index":3,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"ENTREPRISES","ASSOCIATIONS","COMMUNES_MOSSIG_VIGNOBLE","FAMILLE, AMIS, VOISINS"]
[null,null,null,null,"BALBRONN"]
[null,null,null,null,"BERGBIETEN"]
[null,null,null,null,"CRASTATT"]
[null,null,null,null,"COSSWILLER "]
[null,null,null,null,"DAHLENHEIM"]
[null,null,null,null,"DANGOLSHEIM"]
[null,null,null,null,"FLEXBOURG"]
[null,null,null,null,"HOHENGOEFT"]
[null,null,null,null,"JETTERSWILLER"]
[null,null,null,null,"KIRCHHEIM"]
[null,null,null,null,"KNOERSHEIM"]
[null,null,null,null,"MARLENHEIM"]
[null,null,null,null,"NORDHEIM"]
[null,null,null,null,"ODRATZHEIM"]
[null,null,null,null,"RANGEN"]
[null,null,null,null,"ROMANSWILLER"]
[null,null,null,null,"SCHARRACHBERGHEIM-IRMSTETT"]
[null,null,null,null,"TRAENHEIM"]
[null,null,null,null,"WANGEN"]
[null,null,null,null,"WANGENBOURG-ENGENTHAL"]
[null,null,null,null,"WASSELONNE"]
[null,null,null,null,"WESTHOFFEN"]
[null,null,null,null,"ZEHNACKER"]
[null,null,null,null,"ZEINHEIM"]