{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Récap","001","002","003","004","005"],"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":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Carnet","Feuille","Date de\ndistribution","Magasin",-0.05,-0.1,-0.15,"Total","Reste"]
[1,{"$f":"TEXT(A2,\"000\")","v":"001"},{"$f":"INDIRECT(B2&\"!B2\")","v":"2022-07-11"},{"$f":"INDIRECT(B2&\"!C2\")","v":"Boutique Léopard"},{"$f":"INDIRECT(B2&\"!K13\")","v":5},{"$f":"INDIRECT(B2&\"!K14\")","v":4},{"$f":"INDIRECT(B2&\"!K15\")","v":3},{"$f":"E2+F2+G2","v":12},{"$f":"30-H2","v":18}]
[2,{"$f":"TEXT(A3,\"000\")","v":"002"},{"$f":"INDIRECT(B3&\"!B2\")","v":"2022-07-12"},{"$f":"INDIRECT(B3&\"!C2\")","v":"Boutique Panthère"},{"$f":"INDIRECT(B3&\"!K13\")","v":2},{"$f":"INDIRECT(B3&\"!K14\")","v":6},{"$f":"INDIRECT(B3&\"!K15\")","v":5},{"$f":"E3+F3+G3","v":13},{"$f":"30-H3","v":17}]
[3,"003",{"$f":"INDIRECT(B4&\"!B2\")","v":"2022-07-13"},{"$f":"INDIRECT(B4&\"!C2\")","v":"Boutique Jaguar"},{"$f":"INDIRECT(B4&\"!K13\")","v":10},{"$f":"INDIRECT(B4&\"!K14\")","v":10},{"$f":"INDIRECT(B4&\"!K15\")","v":10},30,0]
[4,"004",{"$f":"INDIRECT(B5&\"!B2\")","v":"2022-07-14"},{"$f":"INDIRECT(B5&\"!C2\")","v":"Boutique Puma"},{"$f":"INDIRECT(B5&\"!K13\")","v":0},{"$f":"INDIRECT(B5&\"!K14\")","v":0},{"$f":"INDIRECT(B5&\"!K15\")","v":0},0,30]
[5,"005",{"$f":"INDIRECT(B6&\"!B2\")","v":"2022-07-15"},{"$f":"INDIRECT(B6&\"!C2\")","v":"Boutique Tigre"},{"$f":"INDIRECT(B6&\"!K13\")","v":8},{"$f":"INDIRECT(B6&\"!K14\")","v":3},{"$f":"INDIRECT(B6&\"!K15\")","v":7},18,12]

{"sheet":"001","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,"2022-07-11","Boutique Léopard",-0.05,18026]
[null,null,null,null,13846,"x"]
[null,null,null,null,14737,"x"]
[null,null,null,null,16391]
[null,null,null,null,16234,"x"]
[null,null,null,null,12262,"x"]
[null,null,null,null,12247,"x"]
[null,null,null,null,19961]
[null,null,null,null,18182]
[null,null,null,null,16301]
[null,null,null,-0.1,12973,"x",null,null,null,"Coupons utilisés"]
[null,null,null,null,11753,"x",null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":5}]
[null,null,null,null,13408,null,null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":4}]
[null,null,null,null,11332,null,null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":3}]
[null,null,null,null,18265,"x",null,null,null,"Total : ",{"$f":"K13+K14+K15","v":12}]
[null,null,null,null,17225,null,null,null,null,"Reste : ",{"$f":"30-K16","v":18}]
[null,null,null,null,15440,"x"]
[null,null,null,null,12385]
[null,null,null,null,16153,null,null,null,null,"Plante offerte le : ","2022-07-21"]
[null,null,null,null,12920,null,null,null,null,"Plante offerte le : "]
[null,null,null,-0.15,12782,"x",null,null,null,"Plante offerte le : "]
[null,null,null,null,19581]
[null,null,null,null,19399]
[null,null,null,null,11170,"x"]
[null,null,null,null,16561]
[null,null,null,null,15160]
[null,null,null,null,14413,"x"]
[null,null,null,null,13378]
[null,null,null,null,10690]
[null,null,null,null,13012]

{"sheet":"002","index":2,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,30,0],[1,1,30,1],[1,2,30,2],[1,3,10,3],[8,9,8,10],[11,3,20,3],[11,9,11,10],[21,3,30,3]]}
["Carnet ","Date","Boutique","Réduction","Code"]
[2,"2022-07-12","Boutique Panthère",-0.05,20600]
[null,null,null,null,22681]
[null,null,null,null,27252]
[null,null,null,null,29906,"x"]
[null,null,null,null,22219]
[null,null,null,null,26330,"x"]
[null,null,null,null,25223]
[null,null,null,null,21738]
[null,null,null,null,21991]
[null,null,null,null,23715]
[null,null,null,-0.1,26331,null,null,null,null,"Coupons utilisés"]
[null,null,null,null,24767,"x",null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":2}]
[null,null,null,null,25938,"x",null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":6}]
[null,null,null,null,25417,"x",null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":5}]
[null,null,null,null,28476,null,null,null,null,"Total : ",{"$f":"K13+K14+K15","v":13}]
[null,null,null,null,26686,null,null,null,null,"Reste : ",{"$f":"30-K16","v":17}]
[null,null,null,null,24270,"x"]
[null,null,null,null,21755,"x"]
[null,null,null,null,27973,"x",null,null,null,"Plante offerte le : ","2022-07-22"]
[null,null,null,null,25170,null,null,null,null,"Plante offerte le : "]
[null,null,null,-0.15,20395,"x",null,null,null,"Plante offerte le : "]
[null,null,null,null,21156,"x"]
[null,null,null,null,28942]
[null,null,null,null,27244]
[null,null,null,null,21721,"x"]
[null,null,null,null,27022]
[null,null,null,null,24305,"x"]
[null,null,null,null,20784]
[null,null,null,null,27374,"x"]
[null,null,null,null,23123]

{"sheet":"003","index":3,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,30,0],[1,1,30,1],[1,2,30,2],[1,3,10,3],[8,9,8,10],[11,3,20,3],[11,9,11,10],[21,3,30,3]]}
["Carnet ","Date","Boutique","Réduction","Code"]
[3,"2022-07-13","Boutique Jaguar",-0.05,32681,"x"]
[null,null,null,null,35376,"x"]
[null,null,null,null,37420,"x"]
[null,null,null,null,35270,"x"]
[null,null,null,null,36650,"x"]
[null,null,null,null,37093,"x"]
[null,null,null,null,33893,"x"]
[null,null,null,null,33480,"x"]
[null,null,null,null,31632,"x"]
[null,null,null,null,35811,"x"]
[null,null,null,-0.1,39245,"x",null,null,null,"Coupons utilisés"]
[null,null,null,null,35404,"x",null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":10}]
[null,null,null,null,34417,"x",null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":10}]
[null,null,null,null,34285,"x",null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":10}]
[null,null,null,null,35838,"x",null,null,null,"Total : ",{"$f":"K13+K14+K15","v":30}]
[null,null,null,null,32083,"x",null,null,null,"Reste : ",{"$f":"30-K16","v":0}]
[null,null,null,null,37508,"x"]
[null,null,null,null,38130,"x"]
[null,null,null,null,37449,"x",null,null,null,"Plante offerte le : ","2022-07-23"]
[null,null,null,null,30310,"x",null,null,null,"Plante offerte le : "]
[null,null,null,-0.15,36151,"x",null,null,null,"Plante offerte le : "]
[null,null,null,null,34731,"x"]
[null,null,null,null,32553,"x"]
[null,null,null,null,32784,"x"]
[null,null,null,null,37871,"x"]
[null,null,null,null,34643,"x"]
[null,null,null,null,30103,"x"]
[null,null,null,null,30772,"x"]
[null,null,null,null,35505,"x"]
[null,null,null,null,37811,"x"]

{"sheet":"004","index":4,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,30,0],[1,1,30,1],[1,2,30,2],[1,3,10,3],[8,9,8,10],[11,3,20,3],[11,9,11,10],[21,3,30,3]]}
["Carnet ","Date","Boutique","Réduction","Code"]
[4,"2022-07-14","Boutique Puma",-0.05,46526]
[null,null,null,null,45171]
[null,null,null,null,48557]
[null,null,null,null,44666]
[null,null,null,null,46909]
[null,null,null,null,40349]
[null,null,null,null,43895]
[null,null,null,null,48539]
[null,null,null,null,48133]
[null,null,null,null,40646]
[null,null,null,-0.1,43603,null,null,null,null,"Coupons utilisés"]
[null,null,null,null,40123,null,null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":0}]
[null,null,null,null,43768,null,null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":0}]
[null,null,null,null,45093,null,null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":0}]
[null,null,null,null,48711,null,null,null,null,"Total : ",{"$f":"K13+K14+K15","v":0}]
[null,null,null,null,41948,null,null,null,null,"Reste : ",{"$f":"30-K16","v":30}]
[null,null,null,null,47731]
[null,null,null,null,45223]
[null,null,null,null,41634,null,null,null,null,"Plante offerte le : ","2022-07-24"]
[null,null,null,null,45117,null,null,null,null,"Plante offerte le : "]
[null,null,null,-0.15,48392,null,null,null,null,"Plante offerte le : "]
[null,null,null,null,41766]
[null,null,null,null,48922]
[null,null,null,null,45003]
[null,null,null,null,45982]
[null,null,null,null,47955]
[null,null,null,null,44258]
[null,null,null,null,46031]
[null,null,null,null,45543]
[null,null,null,null,41884]

{"sheet":"005","index":5,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,30,0],[1,1,30,1],[1,2,30,2],[1,3,10,3],[8,9,8,10],[11,3,20,3],[11,9,11,10],[21,3,30,3]]}
["Carnet ","Date","Boutique","Réduction","Code"]
[5,"2022-07-15","Boutique Tigre",-0.05,51410,"x"]
[null,null,null,null,54797,"x"]
[null,null,null,null,57325]
[null,null,null,null,56046,"x"]
[null,null,null,null,57843,"x"]
[null,null,null,null,57951,"x"]
[null,null,null,null,53001]
[null,null,null,null,56102,"x"]
[null,null,null,null,58927,"x"]
[null,null,null,null,53441,"x"]
[null,null,null,-0.1,52806,null,null,null,null,"Coupons utilisés"]
[null,null,null,null,50372,null,null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":8}]
[null,null,null,null,57567,null,null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":3}]
[null,null,null,null,55679,"x",null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":7}]
[null,null,null,null,54121,null,null,null,null,"Total : ",{"$f":"K13+K14+K15","v":18}]
[null,null,null,null,54836,"x",null,null,null,"Reste : ",{"$f":"30-K16","v":12}]
[null,null,null,null,51441]
[null,null,null,null,54755,"x"]
[null,null,null,null,57306,null,null,null,null,"Plante offerte le : ","2022-07-25"]
[null,null,null,null,56543,null,null,null,null,"Plante offerte le : "]
[null,null,null,-0.15,55033,"x",null,null,null,"Plante offerte le : "]
[null,null,null,null,50337,"x"]
[null,null,null,null,53981]
[null,null,null,null,58759,"x"]
[null,null,null,null,54168,"x"]
[null,null,null,null,58080,"x"]
[null,null,null,null,57804]
[null,null,null,null,58629,"x"]
[null,null,null,null,53039]
[null,null,null,null,58532,"x"]