{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Feuil1","Feuil3","Proposition","Feuil2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":1,"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":"Feuil1","index":0,"n_rows":29,"n_cols":27,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["numero de plaque","numero de chassis","nom","societe","telephone","adresse mail","lesaing ou particulier","gratuit ou pas","marque pneu","dimension pneu","roue ou pas","saison","avant ","arriere","pneu present","allee","remarque","remarque","remarque","remarque","remarque","date 1","date 2","date 3","date 4","date 5","date 6"]
["HRB-0534",null,1,null,"087/451245","repris",null,null,"MI","205/55 R16 91H","oui","HIVER",5,6,"oui","3A",null,null,null,null,null,"2016-04-12"]
["1-DHR-0837",null,"AFFORD",null,"012/745214","repris",null,null,null,null,"non","ETE",null,null,"non","12A"]
["FWS-2697",null,"LEONARD",null,"0476/29,23,18","repris",null,null,"GOOD","205/55 R16 91H","oui","ETE",7,"-","oui","17D",null,null,null,null,null,"2016-11-08"]
["FWS-2697",null,"LEONARD",null,"067/21,79,68","repris",null,null,"GY","205/55 R16 91H","non","HIVER",6,"-","oui","17D",null,null,null,null,null,"2017-11-15"]
["HAA-0305",null,"BREYNE",null,"045/25458","repris",null,null,"MI","195/65 R15 91H","oui","ETE",2,5,"non","3C",null,null,null,null,null,"2017-11-28"]
["HAA-0305",null,"BREYNE",null,"0485/31,85,72","repris",null,null,"GOOD","195/65 R15 91T","oui","HIVER",6,8,"oui","3C",null,null,null,null,null,"2018-03-23"]
["494-K-44",null,"CHANTRENNE",null,"047/232541","repris",null,null,"MI","195/65 R15 91H","non","ETE",4,4,"oui","14B",null,null,null,null,null,"2017-12-04"]
["494-k-44",null,"CHANTRENNE",null,"012/457812","repris",null,null,"DU","195/65 R15 91T","non","HIVER",7,8,"non","14B",null,null,null,null,null,"2017-06-29"]
["1-FFA-77",null,"DEKEGEL",null,"011/458745","repris",null,null,"BR","205/55 R16 91V","oui","ETE",4,2,"oui","2C",null,null,null,null,null,"2017-11-06","2017-12-01"]
["1-FFA-77",null,"DEKEGEL",null,"067/33.43.75","repris",null,{"$f":"si","v":{"$error":"#NAME?"}},"DUN","205/55 R16 91T","non","HIVER",4,5,"non","2C",null,null,null,null,null,"2017-04-05","2017-12-02"]
[]
[null,null,null,null,null,null,null,null,null,820]
[null,null,{"$f":"F23","v":"rouge alle 3 c"},null,null,null,null,{"$f":"IF(F11=\"repris\",H14-5,IF(F10=\"repris\",H14-5,E24))","v":0}]
[]
[]
[]
[]
[]
[]
["rouge"]
[]
["rouge allee 1 c",14574,"rouge allee 1 c",null,{"$f":"MAX(A23:B29,2)","v":124780},{"$f":"VLOOKUP(E23,B23:C29,2)","v":"rouge alle 3 c"}]
["rougeallee 1 b",12458,"rougeallee 1 b",null,124785]
["rouge allee 1 a",1458,"rouge allee 1 a"]
[]
["rouge allee2 a",0,"rouge allee2 a"]
["rouge allee2 b",1254,"rouge allee2 b"]
["rouge alle 3 c",{"$f":"IF(F11=\"repris\",E24-5,E24)","v":124780},"rouge alle 3 c"]

{"sheet":"Feuil3","index":1,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":false,"merged":[[16,0,27,2],[19,6,19,20]]}
["nombre de place  reelle","emplacement restant ","hangar","ecrire emplacement desire en cm "]
[{"$f":"G14","v":8000000},{"$f":"A2-D2","v":7999750},{"$f":"VLOOKUP(G14,E15:F21,2,FALSE)","v":"place 7"},250]
[null,{"$f":"A3-D3","v":0},{"$f":"VLOOKUP(G15,E16:F22,2,FALSE)","v":{"$error":"#N/A"}},0]
[null,0,{"$error":"#N/A"},0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,{"$error":"#N/A"}]
[null,0,{"$error":"#N/A"}]
[null,null,null,null,"nombre d eplacement en cm  total","hangar",{"$f":"MAX(E15:E21,1)","v":8000000},null,null,null,null,"place "]
[null,null,null,null,100000,"place 1",null,null,null,null,null,{"$f":"C2=VLOOKUP(#REF!,E15:F21,2,FALSE)","v":{"$error":"#REF!"}}]
[null,null,null,null,200000,"place 2"]
[null,null,null,null,300000,"place 3"]
[null,null,null,null,40000,"place 4"]
[null,null,null,null,50000,"place 5"]
[null,null,null,null,600000,"place 6"]
[null,null,null,null,8000000,"place 7"]
[]
[]
[null,null,null,null,0]
[null,null,null,null,125,"occupe"]
[null,null,null,null,250,"vide"]
[null,null,null,null,375]
[null,null,null,null,400]
[null,null,null,null,100]
[null,null,null,null,800]

{"sheet":"Proposition","index":2,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["hangar","ecrire emplacement desire en cm ",null,"Nb placement en cm  total","Hangar","Occ Tot","Solde","Maxi solde","Place ","Encombrement"]
["place 7",125,null,100000,"place 1",{"$f":"SUMPRODUCT(($A$2:$A$13=$E2)*1,$B$2:$B$13)","v":0},{"$f":"D2-F2","v":100000},{"$f":"MAX(G2:G8)","v":799875},{"$f":"LOOKUP($H$2,$G$2:$G$8,$E$2:$E$8)","v":"place 7"},0]
["place 6",100,null,200000,"place 2",0,200000,null,null,125]
["place 6",800,null,300000,"place 3",0,300000,null,null,250]
[null,0,null,40000,"place 4",0,40000,null,null,375]
["place 6",100,null,50000,"place 5",0,50000,null,null,400]
["place 6",375,null,600000,"place 6",2400,597600,null,null,100]
["",0,null,800000,"place 7",125,{"$f":"D8-F8","v":799875},null,null,800]
["place 6",400]
["",0]
["place 6",250]
["",0]
["place 6",375]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"occupe"]
[null,null,null,"vide"]

{"sheet":"Feuil2","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["plaque client ","nom ","dimension pneu","emplacement pneu","nombre de pneu","extraction dela dimension","taille totale necessaire ","repris ou pas","phone","mail","adresse"]
["client 1","azerty1","165/80 R14 85 T",null,4,{"$f":"LEFT(C2,3)","v":"165"},{"$f":"F2*E2","v":660}]
["client 2","azerty2","175/80 R14 85 T",null,2,{"$f":"LEFT(C3,3)","v":"175"},{"$f":"F3*E3","v":350}]
["client 3","azerty3","185/80 R14 85 T",null,2,"185",370]
["client 4","azerty4","195/80 R14 85 T",null,4,"195",780]
["client 5","azerty5","125/80 R14 85 T",null,2,"125",250]
["client 6","azerty6","145/80 R14 85 T",null,2,"145",290]
["client 7","azerty7","165/80 R14 85 T",null,4,"165",660]
["client 8","azerty8","165/80 R14 85 T",null,4,"165",660]
[]
[]
[]
[]
[]
[]
[]
[]
["nom hangard","emplacement disponible"]
["hangar 1",1458000]
["hangar 2",1472000]
["hangar 3",1482000]
["hangar 4",2548000]
["hangar 5",1478000]
["hangar 6",2548000]
["hangar 7",21458000]
["hangar 8",1245000]
["hangar 9",145800]
["hangar 10",1212000]
["hangar 11",1472000]