{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Récap","Carnet"],"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":"Récap","index":0,"n_rows":6,"n_cols":38,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Carnet","Date de\ndistribution","Boutique","\n1","\n2","\n3","\n4","\n5","\n6","\n7","\n8","\n9","1\n0","\n1","\n2","\n3","\n4","\n5","\n6","\n7","\n8","\n9","1\n0","\n1","\n2","\n3","\n4","\n5","\n6","\n7","\n8","\n9","1\n0",-0.05,-0.1,-0.15,"Total","Reste"]
[1,"2022-07-11","Léopard",null,"x","x",null,"x","x","x",null,null,null,"x","x",null,null,"x",null,"x",null,null,null,"x",null,null,"x",null,null,"x",null,null,null,{"$f":"COUNTIF(D2:M2,\"x\")","v":5},{"$f":"COUNTIF(N2:W2,\"x\")","v":4},{"$f":"COUNTIF(X2:AG2,\"x\")","v":3},{"$f":"AH2+AI2+AJ2","v":12},{"$f":"30-AK2","v":18}]
[2,"2022-07-12","Panthère",null,null,null,"x",null,"x",null,null,null,null,null,"x","x","x",null,null,"x","x","x",null,"x","x",null,null,"x",null,"x",null,"x",null,{"$f":"COUNTIF(D3:M3,\"x\")","v":2},{"$f":"COUNTIF(N3:W3,\"x\")","v":6},{"$f":"COUNTIF(X3:AG3,\"x\")","v":5},{"$f":"AH3+AI3+AJ3","v":13},{"$f":"30-AK3","v":17}]
[3,"2022-07-13","Jaguar","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",10,10,10,30,0]
[4,"2022-07-14","Puma",null,null,null,null,null,null,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,0,0,0,30]
[5,"2022-07-15","Tigre","x","x",null,"x","x","x",null,"x","x","x",null,null,null,"x",null,"x",null,"x",null,null,"x","x",null,"x","x","x",null,"x",null,"x",8,3,7,18,12]

{"sheet":"Carnet","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,30,0],[11,9,11,10],[8,9,8,10],[1,1,30,1],[1,3,10,3],[1,2,30,2],[11,3,20,3],[21,3,30,3]]}
["Carnet ","Date","Boutique","Réduction","Code"]
[1,{"$f":"OFFSET(Récap!B1,A2,0)","v":"2022-07-11"},{"$f":"OFFSET(Récap!C1,A2,0)","v":"Léopard"},-0.05,11725,{"$f":"OFFSET(Récap!D1,A2,0)","v":0}]
[null,null,null,null,12040,{"$f":"OFFSET(Récap!E1,A2,0)","v":"x"}]
[null,null,null,null,14787,{"$f":"OFFSET(Récap!F1,A2,0)","v":"x"}]
[null,null,null,null,14846,{"$f":"OFFSET(Récap!G1,A2,0)","v":0}]
[null,null,null,null,11637,{"$f":"OFFSET(Récap!H1,A2,0)","v":"x"}]
[null,null,null,null,14740,{"$f":"OFFSET(Récap!I1,A2,0)","v":"x"}]
[null,null,null,null,11883,{"$f":"OFFSET(Récap!J1,A2,0)","v":"x"}]
[null,null,null,null,10468,{"$f":"OFFSET(Récap!K1,A2,0)","v":0}]
[null,null,null,null,16554,{"$f":"OFFSET(Récap!L1,A2,0)","v":0}]
[null,null,null,null,17148,{"$f":"OFFSET(Récap!M1,A2,0)","v":0}]
[null,null,null,-0.1,15677,{"$f":"OFFSET(Récap!N1,A2,0)","v":"x"},null,null,null,"Coupons utilisés"]
[null,null,null,null,18531,{"$f":"OFFSET(Récap!O1,A2,0)","v":"x"},null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":5}]
[null,null,null,null,16525,{"$f":"OFFSET(Récap!P1,A2,0)","v":0},null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":4}]
[null,null,null,null,17247,{"$f":"OFFSET(Récap!Q1,A2,0)","v":0},null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":3}]
[null,null,null,null,17842,{"$f":"OFFSET(Récap!R1,A2,0)","v":"x"},null,null,null,"Total : ",{"$f":"K13+K14+K15","v":12}]
[null,null,null,null,17144,{"$f":"OFFSET(Récap!S1,A2,0)","v":0},null,null,null,"Reste : ",{"$f":"30-K16","v":18}]
[null,null,null,null,17856,{"$f":"OFFSET(Récap!T1,A2,0)","v":"x"}]
[null,null,null,null,14243,{"$f":"OFFSET(Récap!U1,A2,0)","v":0}]
[null,null,null,null,16390,{"$f":"OFFSET(Récap!V1,A2,0)","v":0},null,null,null,"Plante offerte le : ","2022-07-21"]
[null,null,null,null,15399,{"$f":"OFFSET(Récap!W1,A2,0)","v":0},null,null,null,"Plante offerte le : "]
[null,null,null,-0.15,13895,{"$f":"OFFSET(Récap!X1,A2,0)","v":"x"},null,null,null,"Plante offerte le : "]
[null,null,null,null,16215,{"$f":"OFFSET(Récap!Y1,A2,0)","v":0}]
[null,null,null,null,12701,{"$f":"OFFSET(Récap!Z1,A2,0)","v":0}]
[null,null,null,null,12280,{"$f":"OFFSET(Récap!AA1,A2,0)","v":"x"}]
[null,null,null,null,18312,{"$f":"OFFSET(Récap!AB1,A2,0)","v":0}]
[null,null,null,null,10281,{"$f":"OFFSET(Récap!AC1,A2,0)","v":0}]
[null,null,null,null,11055,{"$f":"OFFSET(Récap!AD1,A2,0)","v":"x"}]
[null,null,null,null,18071,{"$f":"OFFSET(Récap!AE1,A2,0)","v":0}]
[null,null,null,null,10881,{"$f":"OFFSET(Récap!AF1,A2,0)","v":0}]
[null,null,null,null,15243,{"$f":"OFFSET(Récap!AG1,A2,0)","v":0}]