{"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":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"N","Boutique","Date carnet"]
[null,{"$f":"N(B2)+1","v":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"]
[null,6,"La licorne","2022-08-04"]

{"sheet":"Carnets","index":1,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,4,2,5],[2,6,2,7],[2,8,2,9],[1,4,1,9],[4,2,13,2],[4,3,13,3],[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]]}
[]
[null,5,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"},17806,null,17486,"x",15275,"x"]
[null,null,null,null,13033,"x",19789,"x",13013]
[null,null,null,null,12846,"x",11436,null,18251]
[null,null,null,null,11305,null,10209,null,11555,"x"]
[null,null,null,null,19110,"x",14628,"x",11458]
[null,null,null,null,15518,"x",13533,null,11684]
[null,null,null,null,18692,"x",17199,"x",13079,"x"]
[null,null,null,null,16356,null,14435,null,17046]
[null,null,null,null,18685,null,19899,null,17566]
[null,null,null,null,15107,null,16362,null,18116]
[null,2,{"$f":"VLOOKUP(B15,TBtq[],3,0)","v":"2022-07-12"},{"$f":"VLOOKUP(B15,TBtq[],2,0)","v":"Chez Ginette"},26450,null,22594,null,28825,"x"]
[null,null,null,null,25990,null,20905,"x",29551,"x"]
[null,null,null,null,28559,null,20029,"x",28319]
[null,null,null,null,26653,"x",24860,"x",28550]
[null,null,null,null,26839,null,20629,null,20127,"x"]
[null,null,null,null,27255,"x",21911,null,22962]
[null,null,null,null,29961,null,24182,"x",28635,"x"]
[null,null,null,null,29354,null,23389,"x",28453]
[null,null,null,null,20517,null,24577,"x",20362,"x"]
[null,null,null,null,23384,"x",23964,null,24926]
[null,3,{"$f":"VLOOKUP(B25,TBtq[],3,0)","v":"2022-07-13"},{"$f":"VLOOKUP(B25,TBtq[],2,0)","v":"La boutique du savon"},34583,"x",36026,"x",38560,"x"]
[null,null,null,null,31079,"x",36461,"x",30566,"x"]
[null,null,null,null,39831,"x",30796,"x",38994,"x"]
[null,null,null,null,38225,"x",35251,"x",32247,"x"]
[null,null,null,null,30969,"x",36385,"x",31247,"x"]
[null,null,null,null,33340,"x",38854,"x",34852,"x"]
[null,null,null,null,31294,"x",35707,"x",31595,"x"]
[null,null,null,null,31603,"x",35752,"x",30561,"x"]
[null,null,null,null,30036,"x",31763,"x",30459,"x"]
[null,null,null,null,31034,"x",36458,"x",37258,"x"]
[null,4,{"$f":"VLOOKUP(B35,TBtq[],3,0)","v":"2022-07-14"},{"$f":"VLOOKUP(B35,TBtq[],2,0)","v":"Chez Gégé"},48524,null,41756,null,43495]
[null,null,null,null,44679,null,43983,null,46683]
[null,null,null,null,46512,null,47848,null,42248]
[null,null,null,null,44496,null,43988,null,44537]
[null,null,null,null,46968,null,44237,null,47601]
[null,null,null,null,49650,null,41865,null,47990]
[null,null,null,null,43181,null,40730,null,49951]
[null,null,null,null,42235,null,48266,null,49055]
[null,null,null,null,43012,null,45134,null,43657]
[null,null,null,null,46239,null,40475,null,43486]
[null,5,{"$f":"VLOOKUP(B45,TBtq[],3,0)","v":"2022-07-15"},{"$f":"VLOOKUP(B45,TBtq[],2,0)","v":"Le grizzly rouge"},53479,"x",51387,null,59711,"x"]
[null,null,null,null,58327,"x",59650,null,59184,"x"]
[null,null,null,null,58773,null,55918,null,50042]
[null,null,null,null,51842,"x",58314,"x",59015,"x"]
[null,null,null,null,51293,"x",54405,null,59335,"x"]
[null,null,null,null,51344,"x",55667,"x",51029,"x"]
[null,null,null,null,52850,null,55157,null,54864]
[null,null,null,null,52728,"x",51234,"x",55987,"x"]
[null,null,null,null,51781,"x",56234,null,56604]
[null,null,null,null,52940,"x",50914,null,57162,"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":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,0,30,0],[13,7,13,8],[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":"La petite boutique de Léo"},-0.05,17806]
[null,null,null,null,13033,"x"]
[null,null,null,null,12846,"x"]
[null,null,null,null,11305]
[null,null,null,null,19110,"x"]
[null,null,null,null,15518,"x"]
[null,null,null,null,18692,"x"]
[null,null,null,null,16356]
[null,null,null,null,18685]
[null,null,null,null,15107]
[null,null,null,-0.1,17486,"x"]
[null,null,null,null,19789,"x"]
[null,null,null,null,11436,null,null,"Coupons utilisés"]
[null,null,null,null,10209,null,null,-0.05,{"$f":"COUNTIF(F2:F11,\"x\")","v":5}]
[null,null,null,null,14628,"x",null,-0.1,{"$f":"COUNTIF(F12:F21,\"x\")","v":4}]
[null,null,null,null,13533,null,null,-0.15,{"$f":"COUNTIF(F22:F31,\"x\")","v":3}]
[null,null,null,null,17199,"x",null,"Total :",{"$f":"I15+I16+I17","v":12}]
[null,null,null,null,14435,null,null,"Reste :",{"$f":"30-I18","v":18}]
[null,null,null,null,19899]
[null,null,null,null,16362]
[null,null,null,-0.15,15275,"x"]
[null,null,null,null,13013]
[null,null,null,null,18251]
[null,null,null,null,11555,"x"]
[null,null,null,null,11458]
[null,null,null,null,11684]
[null,null,null,null,13079,"x"]
[null,null,null,null,17046]
[null,null,null,null,17566]
[null,null,null,null,18116]