{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["LBtq","Visu","RCV","RBC","ECV","LBC","ELB"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"LBtq","index":0,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"N","Boutique"]
[null,{"$f":"N(B2)+1","v":1},"Nom 1"]

{"sheet":"Visu","index":1,"n_rows":4,"n_cols":16,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,3,2,7],[1,8,1,13],[2,1,2,2],[2,8,2,9],[2,10,2,11],[2,12,2,13]]}
[]
[null,null,null,null,null,null,null,null,"Réduction",null,null,null,null,null,null,"N° de la Boutique :"]
[null,"Boutique",null,"Carnet",null,null,null,null,"-5%",null,"-10%",null,"-15%",null,null,"N° du Carnet :"]
[null,"N°","Nom","N°","S","Date","P","D","Code","P","Code","P","Code","P"]

{"sheet":"RCV","index":2,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3],[0,4,0,5],[0,6,0,10]]}
["Boutique",null,null,null,"Carnet",null,"Réductions"]
["N°","Nom","L1","L2","N°","Date","-5%","-10%","-15%","Total","Reste"]

{"sheet":"RBC","index":3,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,1,1,3],[2,1,2,3],[4,0,4,1],[4,2,4,6]]}
["Boutique"]
["N°","Nom"]
[null,{"$f":"IF(A3=\"\",\"\",IFERROR(VLOOKUP(A3,TBtq[],2,0),\"\"))","v":""}]
[]
["Carnet",null,"Réductions"]
["N°","Date","-5%","-10%","-15%","Total","Reste"]

{"sheet":"ECV","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,4],[14,6,14,7],[2,0,31,0],[2,2,11,2],[2,1,31,1],[12,2,21,2],[22,2,31,2]]}
["Boutique","Carnet","Texte éventuel"]
[null,null,"Réduction","Code"]
[{"$f":"IF(A2=\"\",\"\",IFERROR(VLOOKUP(A2,TBtq[],2,0),\"\"))","v":""},null,-0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,-0.1]
[]
[null,null,null,null,null,null,"Coupons utilisés"]
[null,null,null,null,null,null,-0.05,{"$f":"COUNTIF(E3:E12,\"x\")","v":0}]
[null,null,null,null,null,null,-0.1,{"$f":"COUNTIF(E13:E22,\"x\")","v":0}]
[null,null,null,null,null,null,-0.15,{"$f":"COUNTIF(E23:E32,\"x\")","v":0}]
[null,null,null,null,null,null,"Total :",{"$f":"H16+H17+H18","v":0}]
[null,null,null,null,null,null,"Reste :",{"$f":"30-H19","v":30}]
[]
[]
[null,null,-0.15]

{"sheet":"LBC","index":5,"n_rows":3,"n_cols":66,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,6,0,25],[1,6,1,15],[1,16,1,25],[1,26,1,35],[1,2,1,5],[1,36,1,45],[1,56,1,65],[1,46,1,55],[0,46,0,65],[0,26,0,45]]}
[null,null,null,null,null,null,"R é d u c t i o n     - 5 %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R é d u c t i o n     - 1 0 %",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R é d u c t i o n     - 1 5 %"]
[null,"Btq","Carnet",null,null,null,"10 codes aléatoires",null,null,null,null,null,null,null,null,null,"10 coches",null,null,null,null,null,null,null,null,null,"10 codes aléatoires",null,null,null,null,null,null,null,null,null,"10 coches",null,null,null,null,null,null,null,null,null,"10 codes aléatoires",null,null,null,null,null,null,null,null,null,"10 coches"]
[null,"N°","N°","Date","S","P",1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6,7,8,9,10,1,2,3,4,5,6,7,8,9,10]

{"sheet":"ELB","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[1]