{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Boutiques","Carnets","Récap","Edition"],"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":"Boutiques","index":0,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"N","Boutique","Date carnet"]
[null,1,"La petite boutique de Léo","2022-07-11"]
[null,2,"Chez Ginette","2022-07-12"]
[null,3,"La boutique du savon","2022-07-13"]
[null,4,"Chez Gégé","2022-07-14"]
[null,5,"Le grizzly rouge","2022-07-15"]

{"sheet":"Carnets","index":1,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,1,13,1],[24,2,33,2],[34,2,43,2],[44,1,53,1],[44,3,53,3],[34,3,43,3],[24,3,33,3],[14,3,23,3],[34,1,43,1],[24,1,33,1],[14,1,23,1],[44,2,53,2],[14,2,23,2],[2,4,2,5],[2,6,2,7],[2,8,2,9],[1,4,1,9],[4,2,13,2],[4,3,13,3]]}
[]
[null,1,null,null,"Réduction"]
[null,null,null,null,-0.05,null,-0.1,null,-0.15]
[null,"Carnet","Date","Boutique","Code","P","Code","P","Code","P"]
[null,1,{"$f":"VLOOKUP(B5,TBtq[],3,0)","v":"2022-07-11"},{"$f":"VLOOKUP(B5,TBtq[],2,0)","v":"La petite boutique de Léo"},null,null,null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x"]
[null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,"x",null,"x"]
[null,null,null,null,null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[]
[]
[]
[null,2,{"$f":"VLOOKUP(B15,TBtq[],3,0)","v":"2022-07-12"},{"$f":"VLOOKUP(B15,TBtq[],2,0)","v":"Chez Ginette"},null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"x",null,"x"]
[null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,"x",null,"x"]
[null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"x",null,"x"]
[null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"x",null,"x"]
[null,null,null,null,null,"x"]
[null,3,{"$f":"VLOOKUP(B25,TBtq[],3,0)","v":"2022-07-13"},{"$f":"VLOOKUP(B25,TBtq[],2,0)","v":"La boutique du savon"},null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,4,{"$f":"VLOOKUP(B35,TBtq[],3,0)","v":"2022-07-14"},{"$f":"VLOOKUP(B35,TBtq[],2,0)","v":"Chez Gégé"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,5,{"$f":"VLOOKUP(B45,TBtq[],3,0)","v":"2022-07-15"},{"$f":"VLOOKUP(B45,TBtq[],2,0)","v":"Le grizzly rouge"},null,"x",null,null,null,"x"]
[null,null,null,null,null,"x",null,null,null,"x"]
[]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x",null,null,null,"x"]
[null,null,null,null,null,"x",null,"x",null,"x"]
[]
[null,null,null,null,null,"x",null,"x",null,"x"]
[null,null,null,null,null,"x"]
[null,null,null,null,null,"x",null,null,null,"x"]

{"sheet":"Récap","index":2,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Carnet","Date de\ndistribution","Boutique","L1","L2",-0.05,-0.1,-0.15,"Total","Reste"]
[1,{"$f":"VLOOKUP(A2,TBtq[],3,0)","v":"2022-07-11"},{"$f":"VLOOKUP(A2,TBtq[],2,0)","v":"La petite boutique de Léo"},{"$f":"IF(A2=\"\",\"\",(A2-1)*10+5)","v":5},{"$f":"IF(A2=\"\",\"\",D2+9)","v":14},{"$f":"IF(A2=\"\",\"\",COUNTIF(INDIRECT(A$1&\"s!F\"&D2&\":F\"&E2),\"x\"))","v":5},{"$f":"IF(A2=\"\",\"\",COUNTIF(INDIRECT(A$1&\"s!H\"&D2&\":H\"&E2),\"x\"))","v":4},{"$f":"IF(A2=\"\",\"\",COUNTIF(INDIRECT(A$1&\"s!J\"&D2&\":J\"&E2),\"x\"))","v":3},{"$f":"F2+G2+H2","v":12},{"$f":"30-I2","v":18}]
[2,{"$f":"VLOOKUP(A3,TBtq[],3,0)","v":"2022-07-12"},{"$f":"VLOOKUP(A3,TBtq[],2,0)","v":"Chez Ginette"},{"$f":"IF(A3=\"\",\"\",(A3-1)*10+5)","v":15},{"$f":"IF(A3=\"\",\"\",D3+9)","v":24},{"$f":"IF(A3=\"\",\"\",COUNTIF(INDIRECT(A$1&\"s!F\"&D3&\":F\"&E3),\"x\"))","v":3},{"$f":"IF(A3=\"\",\"\",COUNTIF(INDIRECT(A$1&\"s!H\"&D3&\":H\"&E3),\"x\"))","v":6},{"$f":"IF(A3=\"\",\"\",COUNTIF(INDIRECT(A$1&\"s!J\"&D3&\":J\"&E3),\"x\"))","v":5},{"$f":"F3+G3+H3","v":14},{"$f":"30-I3","v":16}]
[3,{"$f":"VLOOKUP(A4,TBtq[],3,0)","v":"2022-07-13"},{"$f":"VLOOKUP(A4,TBtq[],2,0)","v":"La boutique du savon"},25,34,10,10,10,30,0]
[4,{"$f":"VLOOKUP(A5,TBtq[],3,0)","v":"2022-07-14"},{"$f":"VLOOKUP(A5,TBtq[],2,0)","v":"Chez Gégé"},35,44,0,0,0,0,30]
[5,{"$f":"VLOOKUP(A6,TBtq[],3,0)","v":"2022-07-15"},{"$f":"VLOOKUP(A6,TBtq[],2,0)","v":"Le grizzly rouge"},45,54,8,3,7,18,12]

{"sheet":"Edition","index":3,"n_rows":22,"n_cols":11,"rows_kept":22,"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"]
[4,{"$f":"OFFSET(Récap!B1,A2,0)","v":"2022-07-14"},{"$f":"OFFSET(Récap!C1,A2,0)","v":"Chez Gégé"},-0.05]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,-0.1,null,null,null,null,null,"Coupons utilisés"]
[null,null,null,null,null,null,null,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":0}]
[null,null,null,null,null,null,null,null,null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":0}]
[null,null,null,null,null,null,null,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":0}]
[null,null,null,null,null,null,null,null,null,"Total : ",{"$f":"K13+K14+K15","v":0}]
[null,null,null,null,null,null,null,null,null,"Reste : ",{"$f":"30-K16","v":30}]
[]
[]
[]
[]
[null,null,null,-0.15]