{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Journée du 12 juillet  2024 ","journee du 15 juillet 2024","CR GENERAL","SYNTHESE ","Feuil2"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":2,"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":"Journée du 12 juillet  2024 ","index":0,"n_rows":13,"n_cols":18,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,2,18]]}
[]
[null,"CAMPAGNE DE LAVAGE NANTES   Journée du 12 juillet  2024"]
[]
[]
[null,"FLUX","TYPE","VILLE","ADRESSE","IDENTIFIANT ","LIEN GPS","PASSAGE","Photo avant ","Photo apres ","REALISE","SI NON , RAISONS ","PHOTOS  NON FAISABILITE ","DATE ","Heure ","CHAUFFEUR ","photos dysfon.","OBSERVATION "]
[null,"OM","enterree","NANTES","6 rue de  l'indre ","OM5191","47°12'50.3\"N 1°32'10.3\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","08:20:00","LOUIS",null,"ASCENSEUR HS"]
[null,"VERRE","aerienne","NANTES","rue barbara ","V4056","47°16'16.5\"N 1°31'14.8\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","09:20:00","LOUIS"]
[null,"TRI SAC","semi","NANTES","19 rue arsene  Leloup ","TS5632","47°12'44.6\"N 1°34'10.6\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","10:20:00","LOUIS",null,"remplacement etiquette de tri "]
[null,"TRI SAC","enterree","NANTES","20 rue  paul Marcel","TS5096","47°12'55.1\"N 1°32'18.1\"W - Google Maps","OUI",null,null,"NON","COLONNE CONDAMNEE",null,"2024-07-12","11:20:00","LOUIS"]
[null,"TRI SAC","enterree","NANTES","12 rue  lucien aubert ","TS5253","47°12'25.1\"N 1°36'26.6\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","11:45:00","LOUIS",null,"pompage eau  au fond plus de  50 cm"]
[null,"TRI SAC","enterree","NANTES","1 rue paul thery","TS5149","47°11'42.1\"N 1°32'18.4\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","12:15:00","LOUIS"]
[null,"TRI SAC","enterree","NANTES","6 rue samuel de  champlain","TS5080","47°15'38.8\"N 1°34'27.6\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","12:30:00","LOUIS"]
[null,"TRI SAC","enterree","NANTES","3 rue  nicolas lancret ","TS5207","47°13'21.4\"N 1°35'29.9\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-12","12:45:00","LOUIS"]

{"sheet":"journee du 15 juillet 2024","index":1,"n_rows":12,"n_cols":18,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,2,17]]}
[]
[null,"CAMPAGNE DE LAVAGE NANTES Journée du 15 JUILLET 2024"]
[]
[]
[null,"FLUX","TYPE","VILLE","ADRESSE","IDENTIFIANT ","LIEN GPS","PASSAGE","Photo avant ","Photo apres ","REALISE","SI NON , RAISONS ","PHOTOS  NON FAISABILITE ","DATE ","Heure ","CHAUFFEUR ","photos dysfon.","OBSERVATION "]
[null,"OM","enterree","Nantes","2 rue neruda","OM5614","47°13'14.7\"N 1°36'43.4\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-15","08:15:00","LOUIS"]
[null,"OM","enterree","Nantes","18 rue des fiefs","OM5529","47°10'38.4\"N 1°29'55.8\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-15","08:37:00","LOUIS"]
[null,"OM","enterree","Nantes","5 rue honore de balzac","OM5557","47°12'08.5\"N 1°34'55.1\"W - Google Maps","OUI",null,null,"OUI",null,null,"2024-07-15","08:54:00","LOUIS"]
[null,"OM","enterree","Nantes","rue du danube","OM5424","47°14'35.5\"N 1°36'47.5\"W - Google Maps"]
[null,"OM","enterree","Nantes","2 rue du port ","OM5541","47°11'34.1\"N 1°35'00.5\"W - Google Maps"]
[null,"OM","enterree","Nantes","rue lucie abrac ","OM5417","47°13'03.4\"N 1°37'03.2\"W - Google Maps"]
[null,"OM","enterree","Nantes","rue lucie abrac ","OM5419","47°13'03.4\"N 1°37'03.2\"W - Google Maps"]

{"sheet":"CR GENERAL","index":2,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,1,3,12],[45,7,45,10],[53,7,53,10],[61,7,61,10]]}
[]
[]
[null,"CAMPAGNE DE LAVAGE  TOURS  CR GENERAL"]
[]
[]
[null,"FLUX","VILLE","TYPE","ADRESSE","IDENTIFIANT ","LIEN GPS","REALISE","SI NON , RAISONS ","DATE","HEURE","CHAUFFEUR ","OBSERVATION "]
[null,"OM","NANTES","enterree","6 rue de  l'indre ","OM5191","47°12'50.3\"N 1°32'10.3\"W - Google Maps",{"$f":"'Journée du 12 juillet  2024 '!K6","v":"OUI"},null,{"$f":"'Journée du 12 juillet  2024 '!N6","v":"2024-07-12"},{"$f":"'Journée du 12 juillet  2024 '!O6","v":"08:20:00"},{"$f":"'Journée du 12 juillet  2024 '!P6","v":"LOUIS"},{"$f":"'Journée du 12 juillet  2024 '!R6","v":"ASCENSEUR HS"}]
[null,"VERRE","NANTES","aerienne","rue barbara ","V4056","47°16'16.5\"N 1°31'14.8\"W - Google Maps",{"$f":"'Journée du 12 juillet  2024 '!K7","v":"OUI"},null,{"$f":"'Journée du 12 juillet  2024 '!N7","v":"2024-07-12"},{"$f":"'Journée du 12 juillet  2024 '!O7","v":"09:20:00"},{"$f":"'Journée du 12 juillet  2024 '!P7","v":"LOUIS"}]
[null,"TRI SAC","NANTES","semi","19 rue arsene  Leloup ","TS5632","47°12'44.6\"N 1°34'10.6\"W - Google Maps",{"$f":"'Journée du 12 juillet  2024 '!K8","v":"OUI"},null,{"$f":"'Journée du 12 juillet  2024 '!N8","v":"2024-07-12"},{"$f":"'Journée du 12 juillet  2024 '!O8","v":"10:20:00"},{"$f":"'Journée du 12 juillet  2024 '!P8","v":"LOUIS"},"remplacement etiquette de tri "]
[null,"TRI SAC","NANTES","enterree","20 rue  paul Marcel","TS5096","47°12'55.1\"N 1°32'18.1\"W - Google Maps",{"$f":"'Journée du 12 juillet  2024 '!K9","v":"NON"},{"$f":"'Journée du 12 juillet  2024 '!L9","v":"COLONNE CONDAMNEE"},{"$f":"'Journée du 12 juillet  2024 '!N9","v":"2024-07-12"},{"$f":"'Journée du 12 juillet  2024 '!O9","v":"11:20:00"},{"$f":"'Journée du 12 juillet  2024 '!P9","v":"LOUIS"}]
[null,"TRI SAC","NANTES","enterree","12 rue  lucien aubert ","TS5253","47°12'25.1\"N 1°36'26.6\"W - Google Maps","OUI",null,{"$f":"'Journée du 12 juillet  2024 '!N10","v":"2024-07-12"},"11:45:00","LOUIS","pompage eau  au fond plus de  50 cm"]
[null,"TRI SAC","NANTES","enterree","1 rue paul thery","TS5149","47°11'42.1\"N 1°32'18.4\"W - Google Maps","OUI",null,"2023-07-12","12:15:00","LOUIS"]
[null,"TRI SAC","NANTES","enterree","6 rue samuel de  champlain","TS5080","47°15'38.8\"N 1°34'27.6\"W - Google Maps","OUI",null,"2023-07-12","12:30:00","LOUIS"]
[null,"TRI SAC","NANTES","enterree","3 rue  nicolas lancret ","TS5207","47°13'21.4\"N 1°35'29.9\"W - Google Maps","OUI",null,"2023-07-12","12:45:00","LOUIS"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D6","v":"Nantes"},"enterree","2 rue neruda","OM5614","47°13'14.7\"N 1°36'43.4\"W - Google Maps","OUI",null,"2023-07-13","08:15:00","LOUIS"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D7","v":"Nantes"},"enterree","18 rue des fiefs","OM5529","47°10'38.4\"N 1°29'55.8\"W - Google Maps","OUI",null,"2023-07-13","08:37:00","LOUIS"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D8","v":"Nantes"},"enterree","5 rue honore de balzac","OM5557","47°12'08.5\"N 1°34'55.1\"W - Google Maps","OUI",null,"2023-07-13","08:54:00","LOUIS"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D9","v":"Nantes"},"enterree","rue du danube","OM5424","47°14'35.5\"N 1°36'47.5\"W - Google Maps"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D10","v":"Nantes"},"enterree","2 rue du port ","OM5541","47°11'34.1\"N 1°35'00.5\"W - Google Maps"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D11","v":"Nantes"},"enterree","rue lucie abrac ","OM5417","47°13'03.4\"N 1°37'03.2\"W - Google Maps"]
[null,"OM",{"$f":"'journee du 15 juillet 2024'!D12","v":"Nantes"},"enterree","rue lucie abrac ","OM5419","47°13'03.4\"N 1°37'03.2\"W - Google Maps"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"SYNTHESE VERRE"]
[]
[null,null,null,null,null,null,null,null,"NOMBRE THEORIQUE ","NOMBRE REALISE","RESTANT "]
[null,null,null,null,null,null,null,"VERRE AERIENNE ",{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"aerienne\")","v":1},{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"aerienne\",H7:H21,\"OUI\")","v":1},{"$f":"I49-J49","v":0}]
[null,null,null,null,null,null,null,"VERRE ENTERREE",{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"enterree\")","v":0},{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"enterree\",H7:H21,\"OUI\")","v":0},{"$f":"I50-J50","v":0}]
[null,null,null,null,null,null,null,"VERRE SEMI E.",{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"semi\")","v":0},{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"semi\",H7:H21,\"OUI\")","v":0},0]
[null,null,null,null,null,null,null,"TOTAL VERRE",{"$f":"I49+I50+I51","v":1},{"$f":"J49+J50+J51","v":1},{"$f":"I52-J52","v":0}]
[]
[null,null,null,null,null,null,null,"SYNTHESE OM"]
[]
[null,null,null,null,null,null,null,null,"NOMBRE THEORIQUE ","NOMBRE REALISE","RESTANT "]
[null,null,null,null,null,null,null,"OM AERIENNE ",{"$f":"COUNTIFS(B7:B21,\"OM\",D7:D21,\"aerienne\")","v":0},{"$f":"COUNTIFS(B7:B21,\"OM\",D7:D21,\"aerienne\",H7:H21,\"OUI\")","v":0},{"$f":"I57-J57","v":0}]
[null,null,null,null,null,null,null,"OM ENTERREE",{"$f":"COUNTIFS(B7:B21,\"OM\",D7:D21,\"enterree\")","v":8},{"$f":"COUNTIFS(B7:B21,\"OM\",D7:D21,\"enterree\",H7:H21,\"OUI\")","v":4},{"$f":"I58-J58","v":4}]
[null,null,null,null,null,null,null,"OM SEMI E.",{"$f":"COUNTIFS(B7:B21,\"VERRE\",D7:D21,\"semi\")","v":0},{"$f":"COUNTIFS(B15:B51,\"VERRE\",D15:D51,\"semi\",H15:H51,\"OUI\")","v":0},0]
[null,null,null,null,null,null,null,"TOTAL OM",{"$f":"I57+I58+I59","v":8},{"$f":"J57+J58+J59","v":4},{"$f":"I60-J60","v":4}]
[]
[null,null,null,null,null,null,null,"SYNTHESE CS"]
[]
[null,null,null,null,null,null,null,null,"NOMBRE THEORIQUE ","NOMBRE REALISE","RESTANT "]
[null,null,null,null,null,null,null,"CS AERIENNE ",{"$f":"COUNTIFS(B7:B21,\"CS\",D7:D21,\"aerienne\")","v":0},{"$f":"COUNTIFS(B7:B21,\"CS\",D7:D21,\"aerienne\",H7:H21,\"OUI\")","v":0},{"$f":"I65-J65","v":0}]
[null,null,null,null,null,null,null,"CS ENTERREE",{"$f":"COUNTIFS(B7:B21,\"CS\",D7:D21,\"enterree\")","v":0},{"$f":"COUNTIFS(B7:B21,\"CS\",D7:D21,\"enterree\",H7:H21,\"OUI\")","v":0},{"$f":"I66-J66","v":0}]
[null,null,null,null,null,null,null,"CS SEMI E.",{"$f":"COUNTIFS(B7:B21,\"CS\",D7:D21,\"semi\")","v":0},{"$f":"COUNTIFS(B45:B59,\"VERRE\",D45:D59,\"semi\",H45:H59,\"OUI\")","v":0},{"$f":"I67-J67","v":0}]
[null,null,null,null,null,null,null,"TOTAL CS",{"$f":"I65+I66+I67","v":0},{"$f":"J65+J66+J67","v":0},{"$f":"I68-J68","v":0}]

{"sheet":"SYNTHESE ","index":3,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,1,4,4],[4,6,4,9],[4,11,4,14],[1,1,2,14]]}
[]
[null,"SYNTHESE "]
[]
[]
[null,"SYNTHESE VERRE",null,null,null,null,"SYNTHESE OM",null,null,null,null,"SYNTHESE TRISAC"]
[]
[null,null,"NOMBRE THEORIQUE ","NOMBRE REALISE","RESTANT ",null,null,"NOMBRE THEORIQUE ","NOMBRE REALISE","RESTANT ",null,null,"NOMBRE THEORIQUE ","NOMBRE REALISE","RESTANT "]
[null,"VERRE AERIENNE ",1,{"$f":"'CR GENERAL'!J49","v":1},{"$f":"C8-D8","v":0},null,"OM AERIENNE ",{"$f":"'CR GENERAL'!I57","v":0},{"$f":"'CR GENERAL'!J57","v":0},{"$f":"H8-I8","v":0},null,"CS AERIENNE ",{"$f":"'CR GENERAL'!I65","v":0},{"$f":"'CR GENERAL'!J65","v":0},{"$f":"M8-N8","v":0}]
[null,"VERRE ENTERREE",{"$f":"'CR GENERAL'!I50","v":0},{"$f":"'CR GENERAL'!J50","v":0},{"$f":"C9-D9","v":0},null,"OM ENTERREE",8,{"$f":"'CR GENERAL'!J58","v":4},{"$f":"H9-I9","v":4},null,"CS ENTERREE",5,4,{"$f":"M9-N9","v":1}]
[null,"VERRE SEMI E.",{"$f":"'CR GENERAL'!I51","v":0},{"$f":"'CR GENERAL'!J51","v":0},0,null,"OM SEMI E.",0,{"$f":"'CR GENERAL'!J59","v":0},0,null,"CS SEMI E.",1,1,{"$f":"M10-N10","v":0}]
[null,"TOTAL VERRE",{"$f":"C8+C9+C10","v":1},{"$f":"D8+D9+D10","v":1},{"$f":"C11-D11","v":0},null,"TOTAL OM",{"$f":"H8+H9+H10","v":8},{"$f":"I8+I9+I10","v":4},{"$f":"H11-I11","v":4},null,"TOTAL CS",{"$f":"M8+M9+M10","v":6},{"$f":"N8+N9+N10","v":5},{"$f":"M11-N11","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,1]

{"sheet":"Feuil2","index":4,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"realise","REALISE","raison ",null,null,null,"OBS"]
[null,null,null,null,"OUI","OUI","VEHICULE GENANT",null,null,null,"pompage  eau  au fond entre  20 et 50 cm"]
[null,null,null,null,null,"NON","ACCES DIFFICILE",null,null,null,"pompage eau  au fond plus de  50 cm"]
[null,null,null,null,null,null,"BARRIERE ",null,null,null,"CABLE HS"]
[null,null,null,null,null,null,"ACCES PRIVE",null,null,null,"CONTREPOIDS  HS "]
[null,null,null,null,null,null,"COLONNE NON VIDEE ",null,null,null,"ASCENSEUR HS"]
[null,null,null,null,null,null,"COLONNE CONDAMNEE",null,null,null,"PLATEFORME PIETON HS "]
[null,null,null,null,null,null,"COLONNE INCENDIEE",null,null,null,"EMMERGENCE CABOSSE"]
[null,null,null,null,null,null,"COLONNE CASSEE",null,null,null,"PREHENSION HS"]
[null,null,null,null,null,null,"COLONNE ABSENTE ",null,null,null,"CHAINE CASSEE"]
[null,null,null,null,null,null,"AUTRES",null,null,null,"TAMBOUR HS"]
[null,null,null,null,null,null,null,null,null,null,"PEDALE HS"]
[null,null,null,null,null,null,null,null,null,null,"ABSENCE DE TRAPPE "]
[null,null,null,null,null,null,null,null,null,null,"remplacement etiquette de tri "]
[null,null,null,null,null,null,null,null,null,null,"TUILE HS "]
[null,null,null,null,null,null,null,null,null,null,"COLONNE INCENDIEE "]
[null,null,null,null,null,null,null,null,null,null,"DEFAULT COLLECTE"]
[null,null,null,null,null,null,null,null,null,null,"ABSENCES DE CONSIGNES DE TRI "]
[null,null,null,null,null,null,null,null,null,null,"AUTRES "]