{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["00-Recap","01-données","02-Présentation Recap","03-TRAME","COR _ 01 _ 19 "],"not_rendered":{"charts":3,"images":2,"macros":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"00-Recap","index":0,"n_rows":1230,"n_cols":49,"rows_kept":1230,"merged":[[5,1,5,11],[6,1,6,10],[6,30,6,32],[6,36,6,38],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,5,7,10],[7,11,8,11],[7,13,7,15],[7,17,8,17],[7,23,8,23],[7,24,8,24],[7,25,8,25],[7,26,8,26],[7,27,8,27],[7,28,8,28],[7,29,8,29],[7,30,8,30],[7,31,8,31],[7,32,8,32],[7,33,8,33],[7,34,8,34],[7,35,8,35],[7,36,8,36],[7,37,8,37],[7,38,8,38],[7,39,8,39],[7,40,8,40],[7,41,8,41],[7,42,8,42],[7,43,8,43],[7,44,8,44],[7,45,8,45],[7,46,8,46],[7,47,8,47],[7,48,8,48],[146,2,146,10],[147,3,147,5],[147,8,147,10]]}
[null,null,"Travaux engagés - commande passée","Travaux à engager en 2020"]
[null,null,"Travaux réalisés - dossier ou sous-dossier facturé"]
[null,null,"Dossier comportant plusieurs sous-dossiers"]
[]
[]
[null,"G.E.R. (Gros Entretien Renouvellement) -  - Prévisionnel 2019-2022"]
[{"$nulls":30},"CASE A COCHER",{"$nulls":5},"CASE A COCHER"]
[null,"N°","Objet","Lot",{"$nulls":7},"CUMUL €HT* ",null,"Service Travaux et GER",{"$nulls":3},"FACTURATION",{"$nulls":5},"SITE","N° FICHE","DATE","IMPUTATION","LOCALISATION","TYPE","ANNEE","CONSTAT INTERNE","CONSTAT SOUS-TRAITANT","CONSTAT ADMINISTRATION","CONSTAT ","RISQUES A MOYEN TERME","ORIGINE","chargement reglementaire","aobsolesence ","vetusté","DESCRIPTION DES TRAVAUX","nouvelle equipement dernier generation","nouvelle equipement equivalent autre marque","autres","OBSERVATIONS","PRECONISATION CONSTRUCTEUR","DUREE DE VIE THEORIQUE ","DUREE DE VIE NOUVEL EQUIPEMENT ","IMAGE","INDICE"]
[{"$nulls":4},"2019 Budget HT prévisionnel DISP du 19/02/2019","2019 Budget en cours","Commentaires plan GER 2019","Échéance travaux\n2019",{"v":2020,"d":"2,020"},{"v":2021,"d":"2,021"},{"v":2022,"d":"2,022"},null,null,"Demande d'implication","Charge de travail","Échéance"]
[1,"COR _ 01 _ 19 ","ddddd","ASC",{"$nulls":19},"COR","01","2019-11-11","11","11","ASC","19",false,false,false,"","","",false,false,false,"",false,false,false,"","","","",""]
{"$rows_empty":118}
[null,null,"Total € HT :",null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}},{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}]
[null,null,"* prévision GER à venir sans tenir compte de l'actualisation des prix",{"$nulls":3},"  "]
[{"$nulls":24},"",null,null,"","","",{"$nulls":3},"","","",{"$nulls":3},"",{"$nulls":3},"",""]
{"$rows_empty":15}
[null,null,"VALIDATION GER ANNEE 2019                                     date, nom, signature"]
[]
[null,null,"OUI                                                                                         NON","OUI",{"$nulls":4},"OUI",null,"NON"]
{"$rows_empty":45}
[{"$nulls":6},"Commentaires"]
[null,"ASC","Ascenseurs",{"$f":"F214/$F$229","v":{"$error":"#REF!"}},null,{"$f":"F214","v":{"$error":"#REF!"}},"Selon analyse ascensoriste"]
[null,"CFO","Courants Forts / Electricité",{"$error":"#REF!"},null,{"$error":"#REF!"},"Principalement renouvellement de luminaires"]
[null,"CVC","Chauffage Ventilation Climatisation et Désenfumage",{"$error":"#REF!"},null,{"$error":"#REF!"},"Montant important pour le renouvellement des multisplits de tous les bâtiments"]
[null,"ESA","Equipements de Sûreté Active",{"$error":"#REF!"},null,{"$error":"#REF!"},"Migration des API et Motorolas, renouvellement de la GSA, de la biométrie et du contrôle d'accès"]
[null,"ESP","Equipements de Sûreté Passive",{"$error":"#REF!"},null,{"$error":"#REF!"},"Interventions sur grilles et portes métalliques"]
[null,"EVE","Espaces Verts",{"$error":"#REF!"},null,{"$error":"#REF!"},"Terrassement au pied des barrières hyperfréquences"]
[null,"LFI","Lots de Finitions Intérieures",{"$error":"#REF!"},null,{"$error":"#REF!"},"Plan peinture proposé : Postes protégés + zones à définir avec l'établissement"]
[null,"MCO","Moyens de Communication",{"$error":"#REF!"},null,{"$error":"#REF!"},"Remplacement total des DECT"]
[null,"MIE","Menuiseries intérieures et extérieures (hors sûreté passive)",{"$error":"#REF!"},null,{"$f":"F222","v":{"$error":"#REF!"}},"Provision"]
[null,"MOB","Mobilier",{"$error":"#REF!"},null,{"$error":"#REF!"},"Budget pour renouvellement de mobilier"]
[null,"PSA","Pomberie et Appareils Sanitaires",{"$error":"#REF!"},null,{"$error":"#REF!"},"Renouvellements de 3 ballons ECS + pompes de bouclage"]
[null,"SIN","Sécurité Incendie",{"$error":"#REF!"},null,{"$error":"#REF!"},"Renouvellement de 200 BAES"]
[null,"SOV","Second Œuvre",{"$error":"#REF!"},null,{"$error":"#REF!"},"reprises fissures dans enrobés"]
[]
[]
[]
[]
[null,"Récap par lot",{"$nulls":3},"Prévisionnel"]
[null,"ASC",{"$nulls":3},{"$f":"SUMIF(#REF!,B214,#REF!)","v":{"$error":"#REF!"}}]
[null,"CFO",{"$nulls":3},{"$f":"SUMIF(#REF!,B215,#REF!)","v":{"$error":"#REF!"}}]
[null,"CVC",{"$nulls":3},{"$f":"SUMIF(#REF!,B216,#REF!)","v":{"$error":"#REF!"}}]
[null,"ESA",{"$nulls":3},{"$f":"SUMIF(#REF!,B217,#REF!)","v":{"$error":"#REF!"}}]
[null,"ESP",{"$nulls":3},{"$f":"SUMIF(#REF!,B218,#REF!)","v":{"$error":"#REF!"}}]
[null,"EVE",{"$nulls":3},{"$f":"SUMIF(#REF!,B219,#REF!)","v":{"$error":"#REF!"}}]
[null,"LFI",{"$nulls":3},{"$f":"SUMIF(#REF!,B220,#REF!)","v":{"$error":"#REF!"}}]
[null,"MCO",{"$nulls":3},{"$f":"SUMIF(#REF!,B221,#REF!)","v":{"$error":"#REF!"}}]
[null,"MIE",{"$nulls":3},{"$f":"SUMIF(#REF!,B222,#REF!)","v":{"$error":"#REF!"}}]
[null,"MOB",{"$nulls":3},{"$f":"SUMIF(#REF!,B223,#REF!)","v":{"$error":"#REF!"}}]
[null,"PSA",{"$nulls":3},{"$f":"SUMIF(#REF!,B224,#REF!)","v":{"$error":"#REF!"}}]
[null,"SIN",{"$nulls":3},{"$f":"SUMIF(#REF!,B225,#REF!)","v":{"$error":"#REF!"}}]
[null,"SOV",{"$nulls":3},{"$f":"SUMIF(#REF!,B226,#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Total",{"$nulls":3},{"$f":"SUM(F214:F228)","v":{"$error":"#REF!"}}]
{"$rows_empty":1000}
[null,1]

{"sheet":"01-données","index":1,"n_rows":14,"n_cols":3,"rows_kept":14}
["code metier","code site","indice"]
["ASC","COR"]
["CFO","BEZ","A"]
["CVC","ROA","B"]
["ESA","NAN","C"]
["ESP"]
["EVE"]
["LFI"]
["MCO"]
["MIE"]
["MOB"]
["PSA"]
["SIN"]
["SOV"]

{"sheet":"02-Présentation Recap","index":2,"n_rows":149,"n_cols":9,"rows_kept":149,"merged":[[5,1,5,8],[6,1,6,8],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,7,8]]}
[]
[]
[]
[]
[]
[null,"G.E.R. (Gros Entretien Renouvellement) - Corbas - Prévisionnel 2019-2022"]
[]
[null,"N°","Objet","Lot"]
[{"$nulls":4},"2019 Budget HT prévisionnel","Échéance travaux\n2019",{"v":2020,"d":"2,020"},{"v":2021,"d":"2,021"},{"v":2022,"d":"2,022"}]
{"$rows_empty":36}
[null,null,"Autres Prestations à prévoir pour les années 2020 à 2022"]
[]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}},{"$f":"'00-Recap'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Total € HT :",null,{"$f":"SUM(E10:E68)","v":{"v":0,"d":"0 €"}},null,{"$f":"SUM(G10:G68)","v":{"$error":"#REF!"}},{"$f":"SUM(H10:H68)","v":{"$error":"#REF!"}},{"$f":"SUM(I10:I68)","v":{"$error":"#REF!"}}]
[{"$nulls":4},{"v":1201141,"d":"1,201,141"}]
{"$rows_empty":42}
[{"$nulls":5},"Commentaires"]
[null,"ASC","Ascenseurs",{"$f":"E133/$E$149","v":{"$error":"#DIV/0!"}},{"$f":"E133","v":0},"Selon analyse ascensoriste"]
[null,"CFO","Courants Forts / Electricité",{"$error":"#DIV/0!"},0,"Principalement renouvellement de luminaires"]
[null,"CVC","Chauffage Ventilation Climatisation et Désenfumage",{"$error":"#DIV/0!"},0,"Montant important pour le renouvellement des multisplits de tous les bâtiments"]
[null,"ESA","Equipements de Sûreté Active",{"$error":"#DIV/0!"},0,"Migration des API et Motorolas, renouvellement de la GSA, de la biométrie et du contrôle d'accès"]
[null,"ESP","Equipements de Sûreté Passive",{"$error":"#DIV/0!"},0,"Interventions sur grilles et portes métalliques"]
[null,"EVE","Espaces Verts",{"$error":"#DIV/0!"},0,"Terrassement au pied des barrières hyperfréquences"]
[null,"GDE","Gestion Déléguée",{"$error":"#DIV/0!"},0,"Compacteur"]
[null,"LFI","Lots de Finitions Intérieures",{"$error":"#DIV/0!"},0,"Plan peinture proposé : Postes protégés + zones à définir avec l'établissement"]
[null,"MCO","Moyens de Communication",{"$error":"#DIV/0!"},0,"Remplacement total des DECT"]
[null,"MIE","Menuiseries intérieures et extérieures (hors sûreté passive)",{"$error":"#DIV/0!"},0]
[null,"MOB","Mobilier",{"$error":"#DIV/0!"},0,"Budget pour renouvellement de mobilier"]
[null,"PSA","Pomberie et Appareils Sanitaires",{"$error":"#DIV/0!"},0,"Renouvellements de 3 ballons ECS + pompes de bouclage"]
[null,"SIN","Sécurité Incendie",{"$error":"#DIV/0!"},0,"Renouvellement de 200 BAES"]
[null,"SOV","Second Œuvre",{"$error":"#DIV/0!"},0,"reprises fissures dans enrobés"]
[]
[]
[]
[]
[null,"Récap par lot",null,null,"Prévisionnel"]
[null,"ASC",null,null,{"$f":"SUMIF($D$10:$D$68,B133,$E$10:$E$68)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUMIF($D$10:$D$68,B133,$G$10:$G$68)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF($D$10:$D$68,B133,$H$10:$H$68)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUMIF($D$10:$D$68,B133,$I$10:$I$68)","v":{"v":0,"d":"0.00 €"}}]
[null,"CFO",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"CVC",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"ESA",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"ESP",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"EVE",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"GDE",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"LFI",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"MCO",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"MIE",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"MOB",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"PSA",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"SIN",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[null,"SOV",null,null,{"v":0,"d":"0.00 €"},null,{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"},{"v":0,"d":"0.00 €"}]
[]
[]
[null,"Total",null,null,{"$f":"SUM(E133:E148)","v":{"v":0,"d":"0.00 €"}},null,{"$f":"SUM(G133:G148)","v":{"v":0,"d":"0.00 €"}},{"$f":"SUM(H133:H148)","v":{"v":0,"d":"0.00 €"}},{"v":0,"d":"0.00 €"}]

{"sheet":"03-TRAME","index":3,"n_rows":35,"n_cols":18,"rows_kept":35,"merged":[[0,7,0,8],[2,1,2,7],[7,0,7,5],[7,7,7,11],[8,0,9,5],[11,7,11,9],[13,7,13,11],[14,0,14,5],[14,7,15,11],[15,0,17,5],[19,0,19,5],[19,7,37,11],[20,0,21,5],[26,0,26,5],[27,0,29,5],[34,0,34,5],[35,0,37,5]]}
[{"$nulls":7},"Version travaux_GER n° :",null,null,{"$f":"CONCATENATE(G6,\"_\", A6,\"_\",F6)","v":"__"}]
[]
["Objet :"]
[]
["Fiche N°","Date","Imputation","Localisation","Type","Priorité/année"]
[]
[]
["CONSTAT :",{"$nulls":6},"BUDGET"]
[{"$nulls":7},"Libellé","Quantité","PU","Estimé","Accepté",null,null,"Devis ST","MO","Coef","Total "]
[{"$nulls":8},0,{"$f":"R10","v":{"v":0,"d":"0 €"}},{"$f":"I10*J10","v":{"v":0,"d":"0 €"}},null,null,"XXX",0,"0",1.25,{"$f":"(O10+P10)*Q10","v":0}]
[null,"Constat interne ",{"$nulls":11},"XXX","0","0",1.25,{"$f":"(O11+P11)*Q11","v":0}]
[null,"Constat sous-traitant",{"$nulls":5},"Total général HT",null,null,{"$f":"R15","v":{"v":0,"d":"0 €"}},null,null,"XXX","0","0",1.25,{"$f":"(O12+P12)*Q12","v":0}]
[null,"Constat Administration Pénitentiaire",{"$nulls":11},"XXX","0","0",1.25,{"$f":"(O13+P13)*Q13","v":0}]
[{"$nulls":7},"PRÉCONISATIONS CONSTRUCTEUR :"]
["RISQUES À MOYEN TERME :",{"$nulls":15},"Total",{"$f":"SUM(R10:R14)","v":0}]
[]
[{"$nulls":7},"Durée de vie théorique de l'équipement en place"]
[{"$nulls":7},"Durée de vie résiduelle du nouvel équipement"]
[]
["ORIGINE :",{"$nulls":6},"Photo équipement"]
[]
[]
[null,"Changement réglementaire"]
[null,"Obsolescence produit ou équipement"]
[null,"Vétusté / usure produit ou équipement"]
[]
["DESCRIPTION DES TRAVAUX :"]
[]
[]
[]
["Nouvel équipement identique / dernière génération"]
["Nouvel équipement équivalent / autre marque"]
["Autres"]
[]
["OBSERVATIONS :"]

{"sheet":"COR _ 01 _ 19 ","index":4,"n_rows":36,"n_cols":18,"rows_kept":36,"merged":[[0,7,0,8],[2,1,2,7],[7,0,7,5],[7,7,7,11],[8,0,9,5],[11,7,11,9],[13,7,13,11],[14,0,14,5],[14,7,15,11],[15,0,17,5],[19,0,19,5],[19,7,37,11],[20,0,21,5],[26,0,26,5],[27,0,29,5],[34,0,34,5],[35,0,37,5]]}
[{"$nulls":7},"Version travaux_GER n° :",null,null,{"$f":"CONCATENATE(G6,\"_\", A6,\"_\",F6)","v":"COR_01_19"}]
[]
["Objet :","ddddd"]
[]
["Fiche N°","Date","Imputation","Localisation","Type","Priorité/année"]
["01","11/11/2019","11","11","ASC","19","COR"]
[]
["CONSTAT :",{"$nulls":6},"BUDGET"]
["",{"$nulls":6},"Libellé","Quantité","PU","Estimé","Accepté",null,null,"Devis ST","MO","Coef","Total "]
[{"$nulls":8},0,{"$f":"R10","v":{"v":0,"d":"0 €"}},{"$f":"I10*J10","v":{"v":0,"d":"0 €"}},null,null,"XXX",0,"0",1.25,{"$f":"(O10+P10)*Q10","v":0}]
[null,"Constat interne ",null,null,false,{"$nulls":8},"XXX","0","0",1.25,{"$f":"(O11+P11)*Q11","v":0}]
[null,"Constat sous-traitant",null,null,false,null,null,"Total général HT",null,null,{"$f":"R15","v":{"v":0,"d":"0 €"}},null,null,"XXX","0","0",1.25,{"$f":"(O12+P12)*Q12","v":0}]
[null,"Constat Administration Pénitentiaire",null,null,false,{"$nulls":8},"XXX","0","0",1.25,{"$f":"(O13+P13)*Q13","v":0}]
[{"$nulls":7},"PRÉCONISATIONS CONSTRUCTEUR :"]
["RISQUES À MOYEN TERME :",{"$nulls":6},"",{"$nulls":8},"Total",{"$f":"SUM(R10:R14)","v":0}]
[""]
[{"$nulls":7},"Durée de vie théorique de l'équipement en place",null,null,""]
[{"$nulls":7},"Durée de vie résiduelle du nouvel équipement",null,null,""]
[]
["ORIGINE :",{"$nulls":6},""]
[""]
[]
[null,"Changement réglementaire",null,null,false]
[null,"Obsolescence produit ou équipement",null,null,false]
[null,"Vétusté / usure produit ou équipement",null,null,false]
[]
["DESCRIPTION DES TRAVAUX :"]
[""]
[]
[]
["Nouvel équipement identique / dernière génération",{"$nulls":3},false]
["Nouvel équipement équivalent / autre marque",{"$nulls":3},false]
["Autres",{"$nulls":3},false]
[]
["OBSERVATIONS :"]
[""]