{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["LBtq","Visu","RCV","RBC","ECV","LBC"],"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":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"N","Boutique"]
[null,{"$f":"N(B2)+1","v":1},"La petite boutique de Léo"]
[null,2,"Chez Ginette"]
[null,3,"La boutique du savon"]
[null,4,"Chez Gégé Léopard"]
[null,5,"Le grizzly rouge"]

{"sheet":"Visu","index":1,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,3,2,7],[44,6,53,6],[44,7,53,7],[14,7,23,7],[24,6,33,6],[24,7,33,7],[34,6,43,6],[34,7,43,7],[14,3,23,3],[14,4,23,4],[1,8,1,13],[4,2,13,2],[24,2,33,2],[34,2,43,2],[44,2,53,2],[14,2,23,2],[2,1,2,2],[2,8,2,9],[2,10,2,11],[2,12,2,13],[4,6,13,6],[4,7,13,7],[14,6,23,6],[4,3,13,3],[4,4,13,4],[14,1,23,1],[44,1,53,1],[44,3,53,3],[44,4,53,4],[4,5,13,5],[14,5,23,5],[24,5,33,5],[34,5,43,5],[44,5,53,5],[24,1,33,1],[24,3,33,3],[24,4,33,4],[34,1,43,1],[34,3,43,3],[34,4,43,4],[4,1,13,1]]}
[]
[null,null,null,null,null,null,null,null,"Réduction",null,null,null,null,null,null,"N° de la Boutique :",5]
[null,"Boutique",null,"Carnet",null,null,null,null,"-5%",null,"-10%",null,"-15%",null,null,"N° du Carnet :",1]
[null,"N°","Nom","N°","S","Date","P","D","Code","P","Code","P","Code","P"]
[null,1,{"$f":"VLOOKUP(B5,TBtq[],2,0)","v":"La petite boutique de Léo"},1,1,"2022-07-11",4,4,17806,null,17486,"x",15275,"x"]
[null,null,null,null,null,null,null,null,13033,"x",19789,"x",13013]
[null,null,null,null,null,null,null,null,12846,"x",11436,null,18251]
[null,null,null,null,null,null,null,null,11305,null,10209,null,11555,"x"]
[null,null,null,null,null,null,null,null,19110,"x",14628,"x",11458]
[null,null,null,null,null,null,null,null,15518,"x",13533,null,11684]
[null,null,null,null,null,null,null,null,18692,"x",17199,"x",13079,"x"]
[null,null,null,null,null,null,null,null,16356,null,14435,null,17046]
[null,null,null,null,null,null,null,null,18685,null,19899,null,17566]
[null,null,null,null,null,null,null,null,15107,null,16362,null,18116]
[null,2,{"$f":"VLOOKUP(B15,TBtq[],2,0)","v":"Chez Ginette"},1,1,"2022-07-12",5,5,26450,null,22594,null,28825,"x"]
[null,null,null,null,null,null,null,null,25990,null,20905,"x",29551,"x"]
[null,null,null,null,null,null,null,null,28559,null,20029,"x",28319]
[null,null,null,null,null,null,null,null,26653,"x",24860,"x",28550]
[null,null,null,null,null,null,null,null,26839,null,20629,null,20127,"x"]
[null,null,null,null,null,null,null,null,27255,"x",21911,null,22962]
[null,null,null,null,null,null,null,null,29961,null,24182,"x",28635,"x"]
[null,null,null,null,null,null,null,null,29354,null,23389,"x",28453]
[null,null,null,null,null,null,null,null,20517,null,24577,"x",20362,"x"]
[null,null,null,null,null,null,null,null,23384,"x",23964,null,24926]
[null,3,{"$f":"VLOOKUP(B25,TBtq[],2,0)","v":"La boutique du savon"},1,1,"2022-07-13",6,6,34583,"x",36026,"x",38560,"x"]
[null,null,null,null,null,null,null,null,31079,"x",36461,"x",30566,"x"]
[null,null,null,null,null,null,null,null,39831,"x",30796,"x",38994,"x"]
[null,null,null,null,null,null,null,null,38225,"x",35251,"x",32247,"x"]
[null,null,null,null,null,null,null,null,30969,"x",36385,"x",31247,"x"]
[null,null,null,null,null,null,null,null,33340,"x",38854,"x",34852,"x"]
[null,null,null,null,null,null,null,null,31294,"x",35707,"x",31595,"x"]
[null,null,null,null,null,null,null,null,31603,"x",35752,"x",30561,"x"]
[null,null,null,null,null,null,null,null,30036,"x",31763,"x",30459,"x"]
[null,null,null,null,null,null,null,null,31034,"x",36458,"x",37258,"x"]
[null,4,{"$f":"VLOOKUP(B35,TBtq[],2,0)","v":"Chez Gégé Léopard"},1,1,"2022-07-14",7,7,48524,null,41756,null,43495]
[null,null,null,null,null,null,null,null,44679,null,43983,null,46683]
[null,null,null,null,null,null,null,null,46512,null,47848,null,42248]
[null,null,null,null,null,null,null,null,44496,null,43988,null,44537]
[null,null,null,null,null,null,null,null,46968,null,44237,null,47601]
[null,null,null,null,null,null,null,null,49650,null,41865,null,47990]
[null,null,null,null,null,null,null,null,43181,null,40730,null,49951]
[null,null,null,null,null,null,null,null,42235,null,48266,null,49055]
[null,null,null,null,null,null,null,null,43012,null,45134,null,43657]
[null,null,null,null,null,null,null,null,46239,null,40475,null,43486]
[null,5,{"$f":"VLOOKUP(B45,TBtq[],2,0)","v":"Le grizzly rouge"},1,1,"2022-07-15",8,8,53479,"x",51387,null,59711,"x"]
[null,null,null,null,null,null,null,null,58327,"x",59650,null,59184,"x"]
[null,null,null,null,null,null,null,null,58773,null,55918,null,50042]
[null,null,null,null,null,null,null,null,51842,"x",58314,"x",59015,"x"]
[null,null,null,null,null,null,null,null,51293,"x",54405,null,59335,"x"]
[null,null,null,null,null,null,null,null,51344,"x",55667,"x",51029,"x"]
[null,null,null,null,null,null,null,null,52850,null,55157,null,54864]
[null,null,null,null,null,null,null,null,52728,"x",51234,"x",55987,"x"]
[null,null,null,null,null,null,null,null,51781,"x",56234,null,56604]
[null,null,null,null,null,null,null,null,52940,"x",50914,null,57162,"x"]

{"sheet":"RCV","index":2,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,6,0,10],[0,0,0,3]]}
["Boutique",null,null,null,"Carnet",null,"Réductions"]
["N°","Nom","L1","L2","N°","Date","-5%","-10%","-15%","Total","Reste"]
[1,{"$f":"VLOOKUP(A3,TBtq[],2,0)","v":"La petite boutique de Léo"},{"$f":"IF(A3=\"\",\"\",(A3-1)*10+5)","v":5},{"$f":"IF(A3=\"\",\"\",C3+9)","v":14},{"$f":"INDIRECT(\"Visu!D\"&C3)","v":1},{"$f":"INDIRECT(\"Visu!F\"&C3)","v":"2022-07-11"},{"$f":"IF(A3=\"\",\"\",COUNTIF(INDIRECT(\"Visu!J\"&C3&\":J\"&D3),\"x\"))","v":5},{"$f":"IF(A3=\"\",\"\",COUNTIF(INDIRECT(\"Visu!L\"&C3&\":L\"&D3),\"x\"))","v":4},{"$f":"IF(A3=\"\",\"\",COUNTIF(INDIRECT(\"Visu!N\"&C3&\":N\"&D3),\"x\"))","v":3},{"$f":"G3+H3+I3","v":12},{"$f":"30-J3","v":18}]
[2,{"$f":"VLOOKUP(A4,TBtq[],2,0)","v":"Chez Ginette"},{"$f":"IF(A4=\"\",\"\",(A4-1)*10+5)","v":15},{"$f":"IF(A4=\"\",\"\",C4+9)","v":24},{"$f":"INDIRECT(\"Visu!D\"&C4)","v":1},{"$f":"INDIRECT(\"Visu!F\"&C4)","v":"2022-07-12"},{"$f":"IF(A4=\"\",\"\",COUNTIF(INDIRECT(\"Visu!J\"&C4&\":J\"&D4),\"x\"))","v":3},{"$f":"IF(A4=\"\",\"\",COUNTIF(INDIRECT(\"Visu!L\"&C4&\":L\"&D4),\"x\"))","v":6},{"$f":"IF(A4=\"\",\"\",COUNTIF(INDIRECT(\"Visu!N\"&C4&\":N\"&D4),\"x\"))","v":5},{"$f":"G4+H4+I4","v":14},{"$f":"30-J4","v":16}]
[3,{"$f":"VLOOKUP(A5,TBtq[],2,0)","v":"La boutique du savon"},{"$f":"IF(A5=\"\",\"\",(A5-1)*10+5)","v":25},{"$f":"IF(A5=\"\",\"\",C5+9)","v":34},{"$f":"INDIRECT(\"Visu!D\"&C5)","v":1},{"$f":"INDIRECT(\"Visu!F\"&C5)","v":"2022-07-13"},10,10,10,30,0]
[4,{"$f":"VLOOKUP(A6,TBtq[],2,0)","v":"Chez Gégé Léopard"},{"$f":"IF(A6=\"\",\"\",(A6-1)*10+5)","v":35},{"$f":"IF(A6=\"\",\"\",C6+9)","v":44},{"$f":"INDIRECT(\"Visu!D\"&C6)","v":1},{"$f":"INDIRECT(\"Visu!F\"&C6)","v":"2022-07-14"},0,0,0,0,30]
[5,{"$f":"VLOOKUP(A7,TBtq[],2,0)","v":"Le grizzly rouge"},{"$f":"IF(A7=\"\",\"\",(A7-1)*10+5)","v":45},{"$f":"IF(A7=\"\",\"\",C7+9)","v":54},{"$f":"INDIRECT(\"Visu!D\"&C7)","v":1},{"$f":"INDIRECT(\"Visu!F\"&C7)","v":"2022-07-15"},8,3,7,18,12]

{"sheet":"RBC","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"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"]
[5,{"$f":"IF(A3=\"\",\"\",IFERROR(VLOOKUP(A3,TBtq[],2,0),\"\"))","v":"Le grizzly rouge"}]
[]
["Carnet",null,"Réductions"]
["N°","Date","-5%","-10%","-15%","Total","Reste"]
[1,"2022-07-15",8,3,7,18,12]

{"sheet":"ECV","index":4,"n_rows":32,"n_cols":8,"rows_kept":32,"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"]
[5,1,"Réduction","Code"]
[{"$f":"IF(A2=\"\",\"\",IFERROR(VLOOKUP(A2,TBtq[],2,0),\"\"))","v":"Le grizzly rouge"},"2022-07-15",-0.05,53479,"x"]
[null,null,null,58327,"x"]
[null,null,null,58773]
[null,null,null,51842,"x"]
[null,null,null,51293,"x"]
[null,null,null,51344,"x"]
[null,null,null,52850]
[null,null,null,52728,"x"]
[null,null,null,51781,"x"]
[null,null,null,52940,"x"]
[null,null,-0.1,51387]
[null,null,null,59650]
[null,null,null,55918,null,null,"Coupons utilisés"]
[null,null,null,58314,"x",null,-0.05,{"$f":"COUNTIF(E3:E12,\"x\")","v":8}]
[null,null,null,54405,null,null,-0.1,{"$f":"COUNTIF(E13:E22,\"x\")","v":3}]
[null,null,null,55667,"x",null,-0.15,{"$f":"COUNTIF(E23:E32,\"x\")","v":7}]
[null,null,null,55157,null,null,"Total :",{"$f":"H16+H17+H18","v":18}]
[null,null,null,51234,"x",null,"Reste :",{"$f":"30-H19","v":12}]
[null,null,null,56234]
[null,null,null,50914]
[null,null,-0.15,59711,"x"]
[null,null,null,59184,"x"]
[null,null,null,50042]
[null,null,null,59015,"x"]
[null,null,null,59335,"x"]
[null,null,null,51029,"x"]
[null,null,null,54864]
[null,null,null,55987,"x"]
[null,null,null,56604]
[null,null,null,57162,"x"]

{"sheet":"LBC","index":5,"n_rows":8,"n_cols":66,"rows_kept":8,"cut":false,"hidden":false,"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]
[null,1,1,"2022-07-11",0,0,17806,13033,12846,11305,19110,15518,18692,16356,18685,15107,null,"x","x",null,"x","x","x",null,null,null,17486,19789,11436,10209,14628,13533,17199,14435,19899,16362,"x","x",null,null,"x",null,"x",null,null,null,15275,13013,18251,11555,11458,11684,13079,17046,17566,18116,"x",null,null,"x",null,null,"x"]
[null,2,1,"2022-07-12",0,0,26450,25990,28559,26653,26839,27255,29961,29354,20517,23384,null,null,null,"x",null,"x",null,null,null,"x",22594,20905,20029,24860,20629,21911,24182,23389,24577,23964,null,"x","x","x",null,null,"x","x","x",null,28825,29551,28319,28550,20127,22962,28635,28453,20362,24926,"x","x",null,null,"x",null,"x",null,"x"]
[null,3,1,"2022-07-13",0,0,34583,31079,39831,38225,30969,33340,31294,31603,30036,31034,"x","x","x","x","x","x","x","x","x","x",36026,36461,30796,35251,36385,38854,35707,35752,31763,36458,"x","x","x","x","x","x","x","x","x","x",38560,30566,38994,32247,31247,34852,31595,30561,30459,37258,"x","x","x","x","x","x","x","x","x","x"]
[null,4,1,"2022-07-14",0,0,48524,44679,46512,44496,46968,49650,43181,42235,43012,46239,null,null,null,null,null,null,null,null,null,null,41756,43983,47848,43988,44237,41865,40730,48266,45134,40475,null,null,null,null,null,null,null,null,null,null,43495,46683,42248,44537,47601,47990,49951,49055,43657,43486]
[null,5,1,"2022-07-15",0,0,53479,58327,58773,51842,51293,51344,52850,52728,51781,52940,"x","x",null,"x","x","x",null,"x","x","x",51387,59650,55918,58314,54405,55667,55157,51234,56234,50914,null,null,null,"x",null,"x",null,"x",null,null,59711,59184,50042,59015,59335,51029,54864,55987,56604,57162,"x","x",null,"x","x","x",null,"x",null,"x"]