{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Projet 1","Table"],"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":"Projet 1","index":0,"n_rows":65,"n_cols":100,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,null,null,0]
[{"$f":" TODAY()","v":"2018-06-20"},null,null,{"$f":"TODAY()","v":"2018-06-20"}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"A2+D1","v":"2018-06-20"},{"$f":"E7+1","v":"2018-06-21"},{"$f":"F7+1","v":"2018-06-22"},"2018-06-23","2018-06-24","2018-06-25","2018-06-26","2018-06-27","2018-06-28","2018-06-29","2018-06-30","2018-07-01","2018-07-02","2018-07-03","2018-07-04","2018-07-05","2018-07-06","2018-07-07","2018-07-08","2018-07-09","2018-07-10","2018-07-11","2018-07-12","2018-07-13","2018-07-14","2018-07-15","2018-07-16","2018-07-17","2018-07-18","2018-07-19","2018-07-20","2018-07-21","2018-07-22","2018-07-23","2018-07-24","2018-07-25","2018-07-26","2018-07-27","2018-07-28","2018-07-29","2018-07-30","2018-07-31","2018-08-01","2018-08-02","2018-08-03","2018-08-04","2018-08-05","2018-08-06","2018-08-07","2018-08-08","2018-08-09","2018-08-10","2018-08-11","2018-08-12","2018-08-13","2018-08-14","2018-08-15","2018-08-16","2018-08-17","2018-08-18","2018-08-19","2018-08-20","2018-08-21","2018-08-22","2018-08-23","2018-08-24",{"$f":"BR7+1","v":"2018-08-25"},"2018-08-26","2018-08-27","2018-08-28","2018-08-29",{"$f":"BW7+1","v":"2018-08-30"},{"$f":"BX7+1","v":"2018-08-31"},{"$f":"BY7+1","v":"2018-09-01"},{"$f":"BZ7+1","v":"2018-09-02"},{"$f":"CA7+1","v":"2018-09-03"},{"$f":"CB7+1","v":"2018-09-04"},{"$f":"CC7+1","v":"2018-09-05"},{"$f":"CD7+1","v":"2018-09-06"},{"$f":"CE7+1","v":"2018-09-07"},{"$f":"CF7+1","v":"2018-09-08"},{"$f":"CG7+1","v":"2018-09-09"},{"$f":"CH7+1","v":"2018-09-10"},{"$f":"CI7+1","v":"2018-09-11"},{"$f":"CJ7+1","v":"2018-09-12"},{"$f":"CK7+1","v":"2018-09-13"},{"$f":"CL7+1","v":"2018-09-14"},{"$f":"CM7+1","v":"2018-09-15"},{"$f":"CN7+1","v":"2018-09-16"},{"$f":"CO7+1","v":"2018-09-17"},{"$f":"CP7+1","v":"2018-09-18"},{"$f":"CQ7+1","v":"2018-09-19"},{"$f":"CR7+1","v":"2018-09-20"},{"$f":"CS7+1","v":"2018-09-21"},{"$f":"CT7+1","v":"2018-09-22"},{"$f":"CU7+1","v":"2018-09-23"}]
[null,null,null,null,{"$f":"\"S \"&WEEKNUM(E7,2)","v":"S 25"},{"$f":"IF(F9=\"L\",\"S \"&WEEKNUM(F7,2),\"\")","v":""},"","","","S 26","","","","","","","S 27","","","","","","","S 28","","","","","","","S 29","","","","","","","S 30","","","","","","","S 31","","","","","","","S 32","","","","","","","S 33","","","","","","","S 34","","","",{"$f":"IF(BR9=\"L\",\"S \"&WEEKNUM(BR7,2),\"\")","v":""},"","","S 35","","","","","","","S 36","","","","","","","S 37","",{"$f":"IF(CK9=\"L\",\"S \"&WEEKNUM(CK7,2),\"\")","v":""},"","","","","S 38","","","","","",""]
["N° Affaire","Responsable","Nom d'affaire",null,{"$f":"VLOOKUP(WEEKDAY(E7,2),semaine,2,FALSE)","v":"M"},"J",{"$f":"VLOOKUP(WEEKDAY(G7,2),semaine,2,FALSE)","v":"V"},"S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S",{"$f":"VLOOKUP(WEEKDAY(AY7,2),semaine,2,FALSE)","v":"D"},"L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M",{"$f":"VLOOKUP(WEEKDAY(BX7,2),semaine,2,FALSE)","v":"J"},"V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D"]
[null,null,null,null,{"$f":"DAY(E7)","v":20},{"$f":"DAY(F7)","v":21},22,23,24,25,26,27,28,29,30,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,{"$f":"DAY(BR7)","v":24},25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,{"$f":"DAY(CK7)","v":12},13,14,15,16,17,18,19,20,21,22,23]
[null,null,null,null,{"$f":"A6+D5","v":0}]
["18/021","Clara","Pool routier - BdC n°20",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/046","Clara","Rénovation de la rue du Mercadial",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/057","Clara","Traversée du village",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/066","Clara","Pool routier - BdC n°21",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"Attente accord pour commence le PRO"]
["17/123","Emmanuel","Pool routier - BdC n°17 ",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/128","Emmanuel","Aménagement publics Zac PP",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"Phase EXE à débuter bientôt "]
["16/221","Léa","Réaménagement des arrêts de bus \"Cimetière\" et \"Fontaine\" ",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/100","Marine","Pool routier - BdC n°16",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/048","Marine/Philippe","Traverse - Labastide de Sérou "]
["15/266","Philippe","Val de Saune II - St Foy-d'Aigrefeuille",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["16/314","Philippe","Parc de stationnement - Rue des Jardins - Lévignac - Pool routier 2013- MS13 ",null,null,null,null,"Phase EXE à débuter bientôt "]
["17/104","Philippe","Rue Vimona - Cugnaux - Pool routier 2016 - Pôle S - BdC n°4"]
["17/121","Philippe","Giratoires - Gourdan Polignan - Pool routier SIVOM - BdC n°5"]
["18/065","Philippe","Etude centre bourg - Briatexte (rue des Moutons et rue Vannelle)"]
["18/087","Philippe","Assainnisement  - Briatexte (extension et mise en séparatif)",null,null,null,null,"A débuter -> 5 jours pour l'AVP et 2 jours pour le PRO"]
["16/086","Pierre","Aménagement d'un micro-giratoire RD77",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/120","Pierre","Construction de logements locatifs sociaux et en accession sociale",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/047","Pierre","Modification de plateaux traversants RD15",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/051","Pierre","Ilôt 47 à Beauzelle",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/054","Pierre","Contruction de 94 logements - ZAC Laubis à Seilh",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"Attente accord pour RAO"]
["18/056","Pierre","Logements collectifs 135 + 34 lgts - Chemin Licard",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/078","Pierre","Logements collectifs 47 lgts - Ilôt 25 Borderouge",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["15/237","Romain","Place de mairie - PINSAGUEL",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["16/330","Romain","Pool routier - BdC n°5",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["16/334","Romain","Pool routier - Bdc n°7 ",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/088","Romain","Pool routier - BdC n°15",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/137","Romain","Pool routier - BdC n°18 ",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/018","Romain","Contournement Nord d'Ondes",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/020","Romain","Pool routier - BdC n°19",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/068","Romain","Pool routier - BdC n°22",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/070","Romain","Pool routier - BdC n°24",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/071","Romain","Pool routier - BdC n°25",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"Attente retour client sur ESQ"]
["18/083","Romain","Urbanisation RD15 cheminement piétion et sécurisation ",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/091","Romain","Cinéma Pamiers",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["17/131","Stéphane","Travaux d'assainissement et VRD",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"A débuter -> 5 jours pour l'AVP et 2 jours pour le PRO"]
["18/067","Stéphane","Projet Escalquens",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"Attente du devis "]
["18/077","Stéphane","TM-GPV Reynerie - MS 22",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}}]
["18/084","Stéphane","Restructuration et extension pôle technique",{"$f":"#REF!+#REF!*(#REF!-#REF!)","v":{"$error":"#REF!"}},null,"Attente du BdC AVP "]
[]
[]
[]
[]
[]
[]
[]
["18/082","Marc","Lotissement - Impasse de la Lèze - Route de Plantaurel - Labarthe sur Lèze",null,null,null,null,"Attente retour client sur ESQ"]
["18/089","Marc","Lotissement 5/6 Lots - Impasse de la Lèze - Pins Justaret",null,null,null,null,"Attente du devis "]
[]
[]
[]
["16/154","Philippe","Route de Toulouse - Leguevin - Pool routier 2013 - MS11",null,null,null,null,"Attente accord pour commence le PRO"]
["17/133","Philippe","Route de Luscan - Barbazan - Pool routier SIVOM  - BdC n°6",null,null,null,null,"Attente Topo pour commencer EP"]
["18/053","Philippe","Réseaux de délestage ruisseau du Théron - Saïx",null,null,"Attente Topo pour commencer EP",null,"Attente accord pour RAO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["18/092","Philippe","Rue des Lys - La Salvetat St Gilles - Pool routier 2017 - BdC n°11",null,null,null,null,"Attente du BdC AVP "]

{"sheet":"Table","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[1,"L",null,"OUI"]
[2,"M",null,"NON"]
[3,"M"]
[4,"J"]
[5,"V"]
[6,"S"]
[7,"D"]