{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Reporting","Pré-inscription"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"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":"Reporting","index":0,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[[1,0,1,1]]}
[]
["Ville des déposants"]
["Étiquettes de lignes","Nombre de Ville"]
["Genas",1]
["Paris",1]
["Total général",2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Reporting"]
[null,null,null,"Nombre d'articles déposés par catégorie"]
[null,null,null,"Nombre d'articles vendus par catégorie"]
[null,null,null,"Pourcentage"]
[null,null,null,"Nombre de vente (caisse)"]
[null,null,null,"Prix moyen d'un ticket"]
[]
[null,null,null,"Dernière optimisation (implique de tout adapter !)"]
[null,null,null,"Supprimer colonne B de pré-inscription + fiche inscription "]
[null,null,null,"Calculer le montant de dépôt en bas de la fiche via formule"]

{"sheet":"Pré-inscription","index":1,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,10],[8,7,8,9],[2,0,2,10],[3,0,3,9],[4,7,4,9],[4,10,6,10],[5,7,5,9],[5,1,5,3],[6,1,6,3],[4,1,4,3],[7,0,7,10]]}
["001","E.S.G.A. SKI :                FOIRE AUX SKIS ET AUX VELOS              Novembre 2024              06 32 03 74 12"]
[]
["DEPOSANT"]
["Coordonnées déposant",null,null,null,null,null,null,null,null,null,"QRcode déposant"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"QRCode(B5&\"|\"&B6&\"|\"&B7&\"|\"&F5&\"|\"&F6&\"|\"&F7&\"|\"&H5&\"|\"&H6)","v":""}]
["Nom",null,null,null,"Ville",null,"Téléphone"]
["Prénom"]
["ARTICLES"]
["N° Article",null,"Catégorie","Marque","Taille","Descriptif optionnel (modèle, couleur…)","Prix vente","Ne pas remplir",null,null,"QRcode article"]
[{"$f":"CONCATENATE($A$1,\"A\")","v":"001A"},null,null,null,null,null,null,null,null,null,{"$f":"QRCode($A10&\"|\"&C10&\"|\"&D10&\"|\"&E10&\"|\"&F10&\"|\"&G10)","v":""}]
[{"$f":"CONCATENATE($A$1,\"B\")","v":"001B"},null,null,null,null,null,null,null,null,null,{"$f":"QRCode($A11&\"|\"&C11&\"|\"&D11&\"|\"&E11&\"|\"&F11&\"|\"&G11)","v":""}]
[{"$f":"CONCATENATE($A$1,\"C\")","v":"001C"},null,null,null,null,null,null,null,null,null,{"$f":"QRCode($A12&\"|\"&C12&\"|\"&D12&\"|\"&E12&\"|\"&F12&\"|\"&G12)","v":""}]
[{"$f":"CONCATENATE($A$1,\"D\")","v":"001D"},null,null,null,null,null,null,null,null,null,""]
[{"$f":"CONCATENATE($A$1,\"E\")","v":"001E"},null,null,null,null,null,null,null,null,null,""]
[{"$f":"CONCATENATE($A$1,\"F\")","v":"001F"},null,null,null,null,null,null,null,null,null,""]
[{"$f":"CONCATENATE($A$1,\"G\")","v":"001G"},null,null,null,null,null,null,null,null,null,""]
[{"$f":"CONCATENATE($A$1,\"H\")","v":"001H"},null,null,null,null,null,null,null,null,null,""]
[{"$f":"CONCATENATE($A$1,\"I\")","v":"001I"},null,null,null,null,null,null,null,null,null,""]
[{"$f":"CONCATENATE($A$1,\"J\")","v":"001J"},null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"SUM(G10:G19)","v":0},"DÉPÔT  À RÉGLER ",{"$f":"CALCULDEPOT()","v":0}]