{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Feuil1","index":0,"n_rows":37,"n_cols":14,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,1,0,6],[20,1,20,6]]}
["JOUR","LIEU"]
["DATE","DEVANT","DERRIERE","BUTTE","VOISIN","RUE","ABORDS",null,"DEVANT","DERRIERE","BUTTE","VOISIN","RUE","ABORDS"]
["2016-05-27","X","X","X","X","X","X",null,{"$f":"IF($A3<>\"\",IF(B3=\"\",\"\",INDEX($A:$A,MATCH(B3,B:B,0))))","v":"2016-05-27"},{"$f":"IF($A3<>\"\",IF(C3=\"\",\"\",INDEX($A:$A,MATCH(C3,C:C,0))))","v":"2016-05-27"},{"$f":"IF($A3<>\"\",IF(D3=\"\",\"\",INDEX($A:$A,MATCH(D3,D:D,0))))","v":"2016-05-27"},{"$f":"IF($A3<>\"\",IF(E3=\"\",\"\",INDEX($A:$A,MATCH(E3,E:E,0))))","v":"2016-05-27"},{"$f":"IF($A3<>\"\",IF(F3=\"\",\"\",INDEX($A:$A,MATCH(F3,F:F,0))))","v":"2016-05-27"},{"$f":"IF($A3<>\"\",IF(G3=\"\",\"\",INDEX($A:$A,MATCH(G3,G:G,0))))","v":"2016-05-27"}]
["2016-06-04",null,null,{"$f":"($A4-$A3)&\" jours\"","v":"8 jours"},null,null,null,null,{"$f":"IF($A4<>\"\",IF(B4=\"\",\"\",INDEX($A:$A,MATCH(B4,B:B,0))))","v":""},{"$f":"IF($A4<>\"\",IF(C4=\"\",\"\",INDEX($A:$A,MATCH(C4,C:C,0))))","v":""},{"$f":"IF($A4<>\"\",IF(D4=\"\",\"\",INDEX($A:$A,MATCH(D4,D:D,0))))","v":"2016-06-04"},{"$f":"IF($A4<>\"\",IF(E4=\"\",\"\",INDEX($A:$A,MATCH(E4,E:E,0))))","v":""},{"$f":"IF($A4<>\"\",IF(F4=\"\",\"\",INDEX($A:$A,MATCH(F4,F:F,0))))","v":""},{"$f":"IF($A4<>\"\",IF(G4=\"\",\"\",INDEX($A:$A,MATCH(G4,G:G,0))))","v":""}]
["2016-06-06",{"$f":"($A5-$A3)&\" jours\"","v":"10 jours"},{"$f":"($A5-$A3)&\" jours\"","v":"10 jours"},null,{"$f":"($A5-$A3)&\" jours\"","v":"10 jours"},{"$f":"($A5-$A3)&\" jours\"","v":"10 jours"},null,null,{"$f":"IF($A5<>\"\",IF(B5=\"\",\"\",INDEX($A:$A,MATCH(B5,B:B,0))))","v":"2016-06-06"},{"$f":"IF($A5<>\"\",IF(C5=\"\",\"\",INDEX($A:$A,MATCH(C5,C:C,0))))","v":"2016-06-06"},{"$f":"IF($A5<>\"\",IF(D5=\"\",\"\",INDEX($A:$A,MATCH(D5,D:D,0))))","v":""},{"$f":"IF($A5<>\"\",IF(E5=\"\",\"\",INDEX($A:$A,MATCH(E5,E:E,0))))","v":"2016-06-06"},{"$f":"IF($A5<>\"\",IF(F5=\"\",\"\",INDEX($A:$A,MATCH(F5,F:F,0))))","v":"2016-06-06"},{"$f":"IF($A5<>\"\",IF(G5=\"\",\"\",INDEX($A:$A,MATCH(G5,G:G,0))))","v":""}]
["2016-06-10",null,null,{"$f":"($A6-$A4)&\" jours\"","v":"6 jours"},null,null,null,null,{"$f":"IF($A6<>\"\",IF(B6=\"\",\"\",INDEX($A:$A,MATCH(B6,B:B,0))))","v":""},{"$f":"IF($A6<>\"\",IF(C6=\"\",\"\",INDEX($A:$A,MATCH(C6,C:C,0))))","v":""},{"$f":"IF($A6<>\"\",IF(D6=\"\",\"\",INDEX($A:$A,MATCH(D6,D:D,0))))","v":"2016-06-10"},{"$f":"IF($A6<>\"\",IF(E6=\"\",\"\",INDEX($A:$A,MATCH(E6,E:E,0))))","v":""},{"$f":"IF($A6<>\"\",IF(F6=\"\",\"\",INDEX($A:$A,MATCH(F6,F:F,0))))","v":""},{"$f":"IF($A6<>\"\",IF(G6=\"\",\"\",INDEX($A:$A,MATCH(G6,G:G,0))))","v":""}]
["2016-06-22",null,null,{"$f":"($A7-$A6)&\" jours\"","v":"12 jours"},{"$f":"($A7-$A5)&\" jours\"","v":"16 jours"},null,{"$f":"($A7-$A3)&\" jours\"","v":"26 jours"},null,{"$f":"IF($A7<>\"\",IF(B7=\"\",\"\",INDEX($A:$A,MATCH(B7,B:B,0))))","v":""},{"$f":"IF($A7<>\"\",IF(C7=\"\",\"\",INDEX($A:$A,MATCH(C7,C:C,0))))","v":""},{"$f":"IF($A7<>\"\",IF(D7=\"\",\"\",INDEX($A:$A,MATCH(D7,D:D,0))))","v":"2016-06-22"},{"$f":"IF($A7<>\"\",IF(E7=\"\",\"\",INDEX($A:$A,MATCH(E7,E:E,0))))","v":"2016-06-22"},{"$f":"IF($A7<>\"\",IF(F7=\"\",\"\",INDEX($A:$A,MATCH(F7,F:F,0))))","v":""},{"$f":"IF($A7<>\"\",IF(G7=\"\",\"\",INDEX($A:$A,MATCH(G7,G:G,0))))","v":"2016-06-22"}]
["2016-06-24",{"$f":"($A8-$A5)&\" jours\"","v":"18 jours"},{"$f":"($A8-$A5)&\" jours\"","v":"18 jours"},null,null,{"$f":"($A8-$A5)&\" jours\"","v":"18 jours"},null,null,{"$f":"IF($A8<>\"\",IF(B8=\"\",\"\",INDEX($A:$A,MATCH(B8,B:B,0))))","v":"2016-06-24"},{"$f":"IF($A8<>\"\",IF(C8=\"\",\"\",INDEX($A:$A,MATCH(C8,C:C,0))))","v":"2016-06-24"},{"$f":"IF($A8<>\"\",IF(D8=\"\",\"\",INDEX($A:$A,MATCH(D8,D:D,0))))","v":""},{"$f":"IF($A8<>\"\",IF(E8=\"\",\"\",INDEX($A:$A,MATCH(E8,E:E,0))))","v":""},{"$f":"IF($A8<>\"\",IF(F8=\"\",\"\",INDEX($A:$A,MATCH(F8,F:F,0))))","v":"2016-06-24"},{"$f":"IF($A8<>\"\",IF(G8=\"\",\"\",INDEX($A:$A,MATCH(G8,G:G,0))))","v":""}]
["2016-08-03",null,{"$f":"($A9-$A8)&\" jours\"","v":"40 jours"},{"$f":"($A9-$A7)&\" jours\"","v":"42 jours"},{"$f":"($A9-$A7)&\" jours\"","v":"42 jours"},null,null,null,{"$f":"IF($A9<>\"\",IF(B9=\"\",\"\",INDEX($A:$A,MATCH(B9,B:B,0))))","v":""},{"$f":"IF($A9<>\"\",IF(C9=\"\",\"\",INDEX($A:$A,MATCH(C9,C:C,0))))","v":"2016-08-03"},{"$f":"IF($A9<>\"\",IF(D9=\"\",\"\",INDEX($A:$A,MATCH(D9,D:D,0))))","v":"2016-08-03"},{"$f":"IF($A9<>\"\",IF(E9=\"\",\"\",INDEX($A:$A,MATCH(E9,E:E,0))))","v":"2016-08-03"},{"$f":"IF($A9<>\"\",IF(F9=\"\",\"\",INDEX($A:$A,MATCH(F9,F:F,0))))","v":""},{"$f":"IF($A9<>\"\",IF(G9=\"\",\"\",INDEX($A:$A,MATCH(G9,G:G,0))))","v":""}]
["2016-10-31",null,null,{"$f":"($A10-$A9)&\" jours\"","v":"89 jours"},null,null,null,null,{"$f":"IF($A10<>\"\",IF(B10=\"\",\"\",INDEX($A:$A,MATCH(B10,B:B,0))))","v":""},{"$f":"IF($A10<>\"\",IF(C10=\"\",\"\",INDEX($A:$A,MATCH(C10,C:C,0))))","v":""},{"$f":"IF($A10<>\"\",IF(D10=\"\",\"\",INDEX($A:$A,MATCH(D10,D:D,0))))","v":"2016-10-31"},{"$f":"IF($A10<>\"\",IF(E10=\"\",\"\",INDEX($A:$A,MATCH(E10,E:E,0))))","v":""},{"$f":"IF($A10<>\"\",IF(F10=\"\",\"\",INDEX($A:$A,MATCH(F10,F:F,0))))","v":""},{"$f":"IF($A10<>\"\",IF(G10=\"\",\"\",INDEX($A:$A,MATCH(G10,G:G,0))))","v":""}]
["2017-03-16",null,null,{"$f":"($A11-$A10)&\" jours\"","v":"136 jours"},null,null,null,null,{"$f":"IF($A11<>\"\",IF(B11=\"\",\"\",INDEX($A:$A,MATCH(B11,B:B,0))))","v":""},{"$f":"IF($A11<>\"\",IF(C11=\"\",\"\",INDEX($A:$A,MATCH(C11,C:C,0))))","v":""},{"$f":"IF($A11<>\"\",IF(D11=\"\",\"\",INDEX($A:$A,MATCH(D11,D:D,0))))","v":"2017-03-16"},{"$f":"IF($A11<>\"\",IF(E11=\"\",\"\",INDEX($A:$A,MATCH(E11,E:E,0))))","v":""},{"$f":"IF($A11<>\"\",IF(F11=\"\",\"\",INDEX($A:$A,MATCH(F11,F:F,0))))","v":""},{"$f":"IF($A11<>\"\",IF(G11=\"\",\"\",INDEX($A:$A,MATCH(G11,G:G,0))))","v":""}]
["2017-03-22",null,null,{"$f":"($A12-$A11)&\" jours\"","v":"6 jours"},null,null,null,null,{"$f":"IF($A12<>\"\",IF(B12=\"\",\"\",INDEX($A:$A,MATCH(B12,B:B,0))))","v":""},{"$f":"IF($A12<>\"\",IF(C12=\"\",\"\",INDEX($A:$A,MATCH(C12,C:C,0))))","v":""},{"$f":"IF($A12<>\"\",IF(D12=\"\",\"\",INDEX($A:$A,MATCH(D12,D:D,0))))","v":"2016-06-10"},{"$f":"IF($A12<>\"\",IF(E12=\"\",\"\",INDEX($A:$A,MATCH(E12,E:E,0))))","v":""},{"$f":"IF($A12<>\"\",IF(F12=\"\",\"\",INDEX($A:$A,MATCH(F12,F:F,0))))","v":""},{"$f":"IF($A12<>\"\",IF(G12=\"\",\"\",INDEX($A:$A,MATCH(G12,G:G,0))))","v":""}]
["2017-04-03",{"$f":"($A13-$A8)&\" jours\"","v":"283 jours"},{"$f":"($A13-$A9)&\" jours\"","v":"243 jours"},{"$f":"($A13-$A12)&\" jours\"","v":"12 jours"},null,{"$f":"($A13-$A8)&\" jours\"","v":"283 jours"},null,null,{"$f":"IF($A13<>\"\",IF(B13=\"\",\"\",INDEX($A:$A,MATCH(B13,B:B,0))))","v":"2017-04-03"},{"$f":"IF($A13<>\"\",IF(C13=\"\",\"\",INDEX($A:$A,MATCH(C13,C:C,0))))","v":"2017-04-03"},{"$f":"IF($A13<>\"\",IF(D13=\"\",\"\",INDEX($A:$A,MATCH(D13,D:D,0))))","v":"2016-06-22"},{"$f":"IF($A13<>\"\",IF(E13=\"\",\"\",INDEX($A:$A,MATCH(E13,E:E,0))))","v":""},{"$f":"IF($A13<>\"\",IF(F13=\"\",\"\",INDEX($A:$A,MATCH(F13,F:F,0))))","v":"2017-04-03"},{"$f":"IF($A13<>\"\",IF(G13=\"\",\"\",INDEX($A:$A,MATCH(G13,G:G,0))))","v":""}]
["2017-04-12",null,{"$f":"($A14-$A13)&\" jours\"","v":"9 jours"},null,{"$f":"($A14-$A9)&\" jours\"","v":"252 jours"},null,null,null,{"$f":"IF($A14<>\"\",IF(B14=\"\",\"\",INDEX($A:$A,MATCH(B14,B:B,0))))","v":""},{"$f":"IF($A14<>\"\",IF(C14=\"\",\"\",INDEX($A:$A,MATCH(C14,C:C,0))))","v":"2017-04-12"},{"$f":"IF($A14<>\"\",IF(D14=\"\",\"\",INDEX($A:$A,MATCH(D14,D:D,0))))","v":""},{"$f":"IF($A14<>\"\",IF(E14=\"\",\"\",INDEX($A:$A,MATCH(E14,E:E,0))))","v":"2017-04-12"},{"$f":"IF($A14<>\"\",IF(F14=\"\",\"\",INDEX($A:$A,MATCH(F14,F:F,0))))","v":""}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF($B16<>\"\",INDEX($A:$A,MATCH(B16,B:B,0)),\"\")","v":""},{"$f":"IF($C16<>\"\",INDEX($A:$A,MATCH(C16,C:C,0)),\"\")","v":""},{"$f":"IF($D16<>\"\",INDEX($A:$A,MATCH(D16,D:D,0)),\"\")","v":""},{"$f":"IF($E16<>\"\",INDEX($A:$A,MATCH(E16,E:E,0)),\"\")","v":""},{"$f":"IF($F16<>\"\",INDEX($A:$A,MATCH(F16,F:F,0)),\"\")","v":""},{"$f":"IF($G16<>\"\",INDEX($A:$A,MATCH(G16,G:G,0)),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null," "]
["Nota : plutôt que INDEX EQUIV j'aurais pu faire :",null,null,null,"mais je voudrais passer par INDEX……",null,null," "]
[null,null,null,null,null,null,null,null," "]
["JOUR","LIEU"]
["DATE","DEVANT","DERRIERE","BUTTE","VOISIN","RUE","ABORDS",null,"DEVANT","DERRIERE","BUTTE","VOISIN","RUE","ABORDS"]
["2016-05-27","X","X","X","X","X","X",null,{"$f":"IF(B23<>\"\",$A23,\"\")","v":"2016-05-27"},{"$f":"IF(C23<>\"\",$A23,\"\")","v":"2016-05-27"},"2016-05-27","2016-05-27","2016-05-27","2016-05-27"]
["2016-06-04",null,null,{"$f":"($A24-$A23)&\" jours\"","v":"8 jours"},null,null,null,null,{"$f":"IF(B24<>\"\",$A24,\"\")","v":""},"","2016-06-04","","",""]
["2016-06-06",{"$f":"($A25-$A23)&\" jours\"","v":"10 jours"},{"$f":"($A25-$A23)&\" jours\"","v":"10 jours"},null,{"$f":"($A25-$A23)&\" jours\"","v":"10 jours"},{"$f":"($A25-$A23)&\" jours\"","v":"10 jours"},null,null,"2016-06-06","2016-06-06","","2016-06-06","2016-06-06",""]
["2016-06-10",null,null,{"$f":"($A26-$A24)&\" jours\"","v":"6 jours"},null,null,null,null,"","","2016-06-10","","",""]
["2016-06-22",null,null,{"$f":"($A27-$A26)&\" jours\"","v":"12 jours"},{"$f":"($A27-$A25)&\" jours\"","v":"16 jours"},null,{"$f":"($A27-$A23)&\" jours\"","v":"26 jours"},null,"","","2016-06-22","2016-06-22","","2016-06-22"]
["2016-06-24",{"$f":"($A28-$A25)&\" jours\"","v":"18 jours"},{"$f":"($A28-$A25)&\" jours\"","v":"18 jours"},null,null,{"$f":"($A28-$A25)&\" jours\"","v":"18 jours"},null,null,"2016-06-24","2016-06-24","","","2016-06-24",""]
["2016-08-03",null,{"$f":"($A29-$A28)&\" jours\"","v":"40 jours"},{"$f":"($A29-$A27)&\" jours\"","v":"42 jours"},{"$f":"($A29-$A27)&\" jours\"","v":"42 jours"},null,null,null,"","2016-08-03","2016-08-03","2016-08-03","",""]
["2016-10-31",null,null,{"$f":"($A30-$A29)&\" jours\"","v":"89 jours"},null,null,null,null,"","","2016-10-31","","",""]
["2017-03-16",null,null,{"$f":"($A31-$A30)&\" jours\"","v":"136 jours"},null,null,null,null,"","","2017-03-16","","",""]
["2017-03-22",null,null,{"$f":"($A32-$A31)&\" jours\"","v":"6 jours"},null,null,null,null,"","","2017-03-22","","",""]
["2017-04-03",{"$f":"($A33-$A28)&\" jours\"","v":"283 jours"},{"$f":"($A33-$A29)&\" jours\"","v":"243 jours"},{"$f":"($A33-$A32)&\" jours\"","v":"12 jours"},null,{"$f":"($A33-$A28)&\" jours\"","v":"283 jours"},null,null,"2017-04-03","2017-04-03","2017-04-03","","2017-04-03",""]
["2017-04-12",null,{"$f":"($A34-$A33)&\" jours\"","v":"9 jours"},null,{"$f":"($A34-$A29)&\" jours\"","v":"252 jours"},null,null,null,null,null,null,"2017-04-12",null,""]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF($B37<>\"\",INDEX($A:$A,MATCH(B37,B:B,0)),\"\")","v":""},{"$f":"IF($C37<>\"\",INDEX($A:$A,MATCH(C37,C:C,0)),\"\")","v":""},{"$f":"IF($D37<>\"\",INDEX($A:$A,MATCH(D37,D:D,0)),\"\")","v":""},{"$f":"IF($E37<>\"\",INDEX($A:$A,MATCH(E37,E:E,0)),\"\")","v":""},{"$f":"IF($F37<>\"\",INDEX($A:$A,MATCH(F37,F:F,0)),\"\")","v":""},{"$f":"IF($G37<>\"\",INDEX($A:$A,MATCH(G37,G:G,0)),\"\")","v":""}]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}