{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Surlocations","Données"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"Surlocations","index":0,"n_rows":36,"n_cols":22,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,6,1,7],[1,11,1,12],[0,0,0,19]]}
["SURLOCATIONS"]
["Sur-surloc","Société","Adresse","Début location","Durée (j)","Fin location",null,null," Facturation","Durée surlocation","Fin surlocation",null,null,"Facturation 2","Durée surlocation 2","Fin surlocation 2",null,"Date fin réelle","Prix surlocation unitaire","Prix surlocation"]
[null,"Birmanie",null,"2021-01-01",36,{"$f":"IF(E3=\"\",\"\",IF(D3=\"\",\"\",D3+E3))","v":"2021-02-06"},{"$f":"IF(F3=\"\",\"\",IF(ISBLANK(R3),IF(TODAY()-F3>0,\"SURLOCATION\",\"\"),IF(R3-D3<=E3,\"\",IF(TODAY()-F3>0,\"SURLOCATION\",\"\"))))","v":"SURLOCATION"},{"$f":"IF(AND(G3=\"SURLOCATION\",COUNTIF(I3,1)=1),\"SURLOCATION EFFECTUE\",\"\")","v":"SURLOCATION EFFECTUE"},1,{"$f":"IF(H3=\"\",\"\",VLOOKUP(B3,Données,2,FALSE))","v":12},{"$f":"IF(J3=\"\",\"\",F3+J3)","v":"2021-02-18"},{"$f":"IF(K3=\"\",\"\",IF(ISBLANK(R3),IF(TODAY()-K3>0,\"SURLOCATION\",\"\"),IF(R3-F3<=J3,\"\",IF(TODAY()-K3>0,\"SURLOCATION\",\"\"))))","v":"SURLOCATION"},{"$f":"IF(AND(L3=\"SURLOCATION\",COUNTIF(N3,1)=1),\"SURLOCATION EFFECTUE\",\"\")","v":"SURLOCATION EFFECTUE"},1,{"$f":"IF(M3=\"\",\"\",VLOOKUP(B3,Données,2,FALSE))","v":12},{"$f":"IF(O3=\"\",\"\",K3+O3)","v":"2021-03-02"},{"$f":"IF(P3=\"\",\"\",IF(ISBLANK(R3),IF(TODAY()-P3>0,\"SURLOCATION\",\"\"),IF(R3-P3<=O3,\"\",IF(TODAY()-P3>0,\"SURLOCATION\",\"\"))))","v":"SURLOCATION"},null,450,{"$f":"IF(S3=\"\",\"\",(COUNTIF(A3:R3,\"SURLOCATION EFFECTUE\")*S3))","v":900}]
[1,"Birmanie",null,"2021-02-18",12,{"$f":"IF(E4=\"\",\"\",IF(D4=\"\",\"\",D4+E4))","v":"2021-03-02"},{"$f":"IF(F4=\"\",\"\",IF(ISBLANK(R4),IF(TODAY()-F4>0,\"SURLOCATION\",\"\"),IF(R4-D4<=E4,\"\",IF(TODAY()-F4>0,\"SURLOCATION\",\"\"))))","v":"SURLOCATION"},{"$f":"IF(AND(G4=\"SURLOCATION\",COUNTIF(I4,1)=1),\"SURLOCATION EFFECTUE\",\"\")","v":"SURLOCATION EFFECTUE"},1,12,{"$f":"IF(J4=\"\",\"\",F4+J4)","v":"2021-03-14"},{"$f":"IF(K4=\"\",\"\",IF(ISBLANK(R4),IF(TODAY()-K4>0,\"SURLOCATION\",\"\"),IF(R4-F4<=J4,\"\",IF(TODAY()-K4>0,\"SURLOCATION\",\"\"))))","v":""},{"$f":"IF(AND(L4=\"SURLOCATION\",COUNTIF(N4,1)=1),\"SURLOCATION EFFECTUE\",\"\")","v":""},null,"",null,{"$f":"IF(P4=\"\",\"\",IF(ISBLANK(R4),IF(TODAY()-P4>0,\"SURLOCATION\",\"\"),IF(R4-P4<=O4,\"\",IF(TODAY()-P4>0,\"SURLOCATION\",\"\"))))","v":""},"2021-03-13",450,{"$f":"IF(S4=\"\",\"\",(COUNTIF(A4:R4,\"SURLOCATION EFFECTUE\")*S4))","v":450}]
[null,"",null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,"",null," "]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,"",null," "]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]
[null,null,null,null,null,"","","",null,"","","","",null,"",null,"",null,null,""]

{"sheet":"Données","index":1,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["Société","Durée surlocation"]
["Afghanistan",25]
["Afrique du Sud",27]
["Albanie",29]
["Algérie",31]
["Allemagne",33]
["Angola",35]
["Antigua-et-Barbuda",37]
["Arabie saoudite",39]
["Argentine",41]
["Arménie",43]
["Australie",45]
["Autriche",47]
["Azerbaïdjan",49]
["Bahamas",51]
["Bahreïn",53]
["Bangladesh",55]
["Barbade",57]
["Belau",59]
["Belgique",61]
["Belize",63]
["Bénin",65]
["Bhoutan",67]
["Biélorussie",69]
["Birmanie",12]
["Bolivie",73]
["Bosnie-Herzégovine",75]