{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Macros","PDF_sheet","Donnees_VRD","Donnees_engin","Donnees_installation","Resultats_simulation","calcul_cable","Etude_CO2","Case_liste","Database_tranchee","Chargement_tourets","lg_database_prysmian","lg_database_GC","diametre_cable"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":8,"comments":4,"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":"Macros","index":0,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,"Bienvenue dans le logiciel de simulation "]
[null,null,null,null,null,null,"de coût d'installation de câble EDR développé par Prysmian Group"]
[]
[null,null,null,null,null,null,"Afin de faire fonctionner ce logiciel"]
[null,null,null,null,null,null,"Merci d'activer les macros de ce fichier"]

{"sheet":"PDF_sheet","index":1,"n_rows":62,"n_cols":16,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,7,61,15],[61,0,61,6],[4,7,4,15],[29,4,29,6],[6,8,6,10],[6,12,6,14],[6,0,6,2],[6,4,6,6],[4,0,4,6]]}
[]
[]
[]
[]
[{"$f":"\"Simulation de coûts câble EDR vs standard - Prysmian Group \" & \"- \" & DAY(TODAY()) & \"/\"& TEXT(MONTH(TODAY()),\"00\") & \"/\" & YEAR(TODAY())  & \" - Page 1/2\"","v":"Simulation de coûts câble EDR vs standard - Prysmian Group - 24/01/2019 - Page 1/2"},null,null,null,null,null,null,{"$f":"\"Simulation de coûts câble EDR vs standard - Prysmian Group \" & \"- \" & DAY(TODAY()) & \"/\"& TEXT(MONTH(TODAY()),\"00\") & \"/\" & YEAR(TODAY()) & \" - Page 2/2\"","v":"Simulation de coûts câble EDR vs standard - Prysmian Group - 24/01/2019 - Page 2/2"}]
[]
["Données VRD",null,null,null,"Données engin",null,null,"Résultats simulation","câble standard",null,null,null,"câble EDR"]
["Longueur de liaison",{"$f":"Donnees_VRD!C3","v":0},"mètres",null,"Prix utilisation tractopelle",{"$f":"Donnees_engin!C4","v":0},"€/jour","Longueur de la liaison",{"$f":"Resultats_simulation!C3","v":0},"mètres",null,null,{"$f":"Resultats_simulation!H3","v":0},"mètres"]
["Nombre de câbles",{"$f":"Donnees_VRD!C6","v":0},"câble(s)",null,"Forfait Transport tractopelle",{"$f":"Donnees_engin!C5","v":0},"€","Nombre de câbles",{"$f":"B9","v":0},null,null,null,{"$f":"B9","v":0}]
[null,null,null,null,"Consommation carburant",{"$f":"calcul_cable!C25","v":9},"L/h"]
["Largeur tranchée",{"$f":"Donnees_VRD!C7","v":0},"mètres",null,null,null,null,"Volume de terre excavée",{"$f":"Resultats_simulation!C5","v":{"$error":"#DIV/0!"}},"mètres3",null,null,{"$f":"Resultats_simulation!H5","v":{"$error":"#DIV/0!"}},"mètres3"]
["Profondeur tranchée",{"$f":"Donnees_VRD!C8","v":0},"mètres",null,"Prix utilisation trancheuse",{"$f":"Donnees_engin!C8","v":0},"€/jour","Volume de terre (déblais)",{"$f":"Resultats_simulation!C6","v":{"$error":"#DIV/0!"}},"mètres3",null,null,{"$f":"Resultats_simulation!H6","v":0},"mètres3"]
["Epaisseur du lit de sable",{"$f":"Donnees_VRD!C9","v":0},"mètres",null,"Forfait Transport trancheuse",{"$f":"Donnees_engin!C9","v":0},"€","Poids terre (déblais)",{"$f":"Resultats_simulation!C7","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,{"$f":"Resultats_simulation!H7","v":0},"Tonnes"]
["Largeur tranchée raccordement",{"$f":"Donnees_VRD!C11","v":0},"mètres",null,"Consommation carburant",{"$f":"calcul_cable!C28","v":15},"L/h","Nombre de camions pour évacuation",{"$f":"Resultats_simulation!C8","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Resultats_simulation!E8","v":0},"tonnes",{"$f":"Resultats_simulation!H8","v":{"$error":"#DIV/0!"}},"camion(s) de",{"$f":"Resultats_simulation!J8","v":0},"tonnes"]
["Longueur tranchée raccordement",{"$f":"Donnees_VRD!C12","v":0},"mètres",null,null,null,null,"Coût traitement des déchets",{"$f":"Resultats_simulation!C9","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H9","v":0},"€"]
["Profondeur tranchée raccordement",{"$f":"Donnees_VRD!C13","v":0},"mètres",null,"Nombre de tractopelles utilisées câble standard",{"$f":"Donnees_engin!C16","v":0},null,"Coût évacuation déblais",{"$f":"Resultats_simulation!C10","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H10","v":{"$error":"#DIV/0!"}},"€"]
["Epaisseur du lit de sable raccordement",{"$f":"Donnees_VRD!C14","v":0},"mètres",null,"Nombre de trancheuses utilisées câble standard",{"$f":"Donnees_engin!C17","v":0},null,"Coût grillage avertisseur",{"$f":"Resultats_simulation!C31","v":0},"€",null,null,{"$f":"Resultats_simulation!H31","v":0},"€"]
[null,null,null,null,"Temps de pose câble standard",{"$f":"Donnees_installation!C9","v":0},"m/jour","Coût traitement de la terre",{"$f":"Resultats_simulation!C11","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H11","v":{"$error":"#DIV/0!"}},"€"]
["Densité terre excavée",{"$f":"Donnees_VRD!C16","v":0}]
["Densité du sable utilisé",{"$f":"Donnees_VRD!C17","v":0},null,null,"Nombre de tractopelles utilisées câble EDR",{"$f":"Donnees_engin!C20","v":0},null,"Volume de sable nécessaire pour pose cable",{"$f":"Resultats_simulation!C13","v":{"$error":"#DIV/0!"}},"mètres3",null,null,{"$f":"Resultats_simulation!H13","v":0},"mètres3"]
[null,null,null,null,"Nombre de trancheuses utilisées câble EDR",{"$f":"Donnees_engin!C21","v":0},null,"Poids du sable nécessaire pour pose cable",{"$f":"Resultats_simulation!C14","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,{"$f":"Resultats_simulation!H14","v":0},"Tonnes"]
["Distance carrière de sable",{"$f":"Donnees_VRD!C19","v":0},"kilomètres",null,"Temps de pose câble EDR",{"$f":"Donnees_installation!C11","v":1000},"m/jour","Nombre de boîtes raccordement",{"$f":"Resultats_simulation!C19","v":{"$error":"#DIV/0!"}},"unités",null,null,{"$f":"Resultats_simulation!H19","v":{"$error":"#DIV/0!"}},"unités"]
["Prix à la tonne de sable",{"$f":"Donnees_VRD!C22","v":0},"€/tonne",null,null,null,null,"Volume de sable nécessaire pour raccordement",{"$f":"Resultats_simulation!C20","v":{"$error":"#DIV/0!"}},"mètres3",null,null,{"$f":"Resultats_simulation!H20","v":{"$error":"#DIV/0!"}},"mètres3"]
["Distance décharge",{"$f":"Donnees_VRD!C26","v":0},"kilomètres",null,"Nombre d'opérateurs pour câble standard",{"$f":"Donnees_installation!C10","v":0},"personnes","Poids du sable nécessaire pour raccordement",{"$f":"Resultats_simulation!C21","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,{"$f":"Resultats_simulation!H21","v":{"$error":"#DIV/0!"}},"Tonnes"]
["Prix traitement déblais",{"$f":"Donnees_VRD!C34","v":0},"€/m3",null,"Nombre d'opérateurs pour câble EDR",{"$f":"Donnees_installation!F10","v":3},"personnes","Volume sable total",{"$f":"Resultats_simulation!C26","v":{"$error":"#DIV/0!"}},"tonnes",null,null,{"$f":"Resultats_simulation!H26","v":{"$error":"#DIV/0!"}},"tonnes"]
["Prix vente déblais",{"$f":"Donnees_VRD!C35","v":0},"€/m3",null,"Coût horaire d'un opérateur",{"$f":"Donnees_installation!C4","v":0},"€/heure","Nombre de camions total",{"$f":"Resultats_simulation!C27","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Resultats_simulation!E27","v":0},"tonnes",{"$f":"Resultats_simulation!H27","v":{"$error":"#DIV/0!"}},"camion(s) de",{"$f":"Resultats_simulation!J27","v":0},"tonnes"]
["Prix du grillage avertisseur ",{"$f":"Donnees_VRD!C37","v":0.17},"€/m",null,null,null,null,"Montant Achat sable ",{"$f":"Resultats_simulation!C28","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H28","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,null,null,null,"Montant transport sable",{"$f":"Resultats_simulation!C29","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H29","v":{"$error":"#DIV/0!"}},"€"]
["Type de camions ",{"$f":"Donnees_VRD!C29","v":0},"tonnes",null,null,null,null,"Montant total sable",{"$f":"Resultats_simulation!C30","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H30","v":{"$error":"#DIV/0!"}},"€"]
["Consommation essence camion ",{"$f":"calcul_cable!C13","v":35},"L/100 km",null,"Données installation"]
["Vitesse moyenne camion",{"$f":"Donnees_VRD!C30","v":0},"km/h",null,"Type de câbles",null,{"$f":"Donnees_installation!C3","v":"3 x 1 x 300 ALU"},"Coût tractopelle(s)",{"$f":"Resultats_simulation!C33","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H33","v":0},"€"]
["Temps de déchargement",{"$f":"Donnees_VRD!C31","v":0},"minutes",null,"Type de tension",{"$f":"Donnees_installation!C8","v":"12/20 kV"},null,"Coût trancheuse(s)",{"$f":"Resultats_simulation!C34","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H34","v":0},"€"]
["Prix essence au litre",{"$f":"Donnees_VRD!C32","v":0},"€/litre",null,"Fournisseur",{"$f":"Donnees_installation!C5","v":"GC"},null,"Coût engin tranchée",{"$f":"Resultats_simulation!C36","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H36","v":{"$error":"#DIV/0!"}},"€"]
["Coût horaire chauffeur",{"$f":"Donnees_VRD!C33","v":0},"€/heure",null,"Prix du câble standard",{"$f":"Donnees_installation!C6","v":0},"€"]
[null,null,null,null,"Prix du câble EDR",{"$f":"Donnees_installation!C7","v":0},"€","Sous total VRD",{"$f":"Resultats_simulation!C38","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H38","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,null,null,null,"Type de tourets souhaités",{"$f":"Donnees_installation!C12","v":"J"},null,"Quantité de câble pour liaison",{"$f":"Resultats_simulation!C40","v":0},"mètres",null,null,{"$f":"Resultats_simulation!H40","v":0},"mètres"]
[null,null,null,null,"Longueur câble standard",{"$f":"Donnees_installation!C13","v":800},"mètres","Quantité câble pour raccordement",{"$f":"Resultats_simulation!C65","v":{"$error":"#DIV/0!"}},"mètres",null,null,{"$f":"Resultats_simulation!H65","v":{"$error":"#DIV/0!"}},"mètres"]
[null,null,null,null,"Longueur câble EDR",{"$f":"Donnees_installation!C14","v":600},"mètres","Quantité de câble /touret",{"$f":"Resultats_simulation!C41","v":800},"mètres",null,null,{"$f":"Resultats_simulation!H41","v":600},"mètres"]
[null,null,null,null,"Charge utile ",{"$f":"Donnees_installation!C15","v":6000},"Kg","Nombre de tourets \"type\"",{"$f":"Resultats_simulation!C42","v":{"$error":"#DIV/0!"}},"tourets type",{"$f":"Resultats_simulation!E42","v":"J"},null,{"$f":"Resultats_simulation!H42","v":{"$error":"#DIV/0!"}},"tourets type",{"$f":"Resultats_simulation!J42","v":"J"}]
[null,null,null,null,"Tare touret",{"$f":"Donnees_installation!C16","v":" 850"},"Kg","Nombre d'heure de déroulage",{"$f":"Resultats_simulation!C43","v":{"$error":"#DIV/0!"}},"heures",null,null,{"$f":"Resultats_simulation!H43","v":0},"heures"]
[null,null,null,null,"Dimensions tourets : Joues",{"$f":"Donnees_installation!C17","v":3000},"mm","Coût opérateurs déroulage",{"$f":"Resultats_simulation!C44","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H44","v":0},"€"]
[null,null,null,null,"Dimensions tourets : Largeur intérieure",{"$f":"Donnees_installation!C18","v":" 960"},"mm","Montant achat câble",{"$f":"Resultats_simulation!C45","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H45","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,"Dimensions tourets : Fût",{"$f":"Donnees_installation!C19","v":" 1200"},"mm","Nombre de boîtes raccordement",{"$f":"Resultats_simulation!C46","v":{"$error":"#DIV/0!"}},"unités",null,null,{"$f":"Resultats_simulation!H46","v":{"$error":"#DIV/0!"}},"unités"]
[null,null,null,null,"Dimensions tourets : Largeur exterieure",{"$f":"Donnees_installation!C20","v":1140},"mm","Coût monteurs",{"$f":"Resultats_simulation!C69","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H69","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,null,null,null,"Montant total raccordement",{"$f":"Resultats_simulation!C47","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H47","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,"Prix achat accesoire raccordement",{"$f":"Donnees_installation!C22","v":0},"€"]
[null,null,null,null,"Nombre de monteurs",{"$f":"Donnees_installation!C21","v":2},"personnes","Total câble et raccordement",{"$f":"Resultats_simulation!C49","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H49","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,"Coût horaire raccordement",{"$f":"Donnees_installation!C23","v":0},"€/heure"]
[null,null,null,null,"Temps raccordement pour une boite",{"$f":"Donnees_installation!C24","v":0},"min","Montant total chantier",{"$f":"Resultats_simulation!C51","v":{"$error":"#DIV/0!"}},"€",null,null,{"$f":"Resultats_simulation!H51","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,"Longueur de garde de câble pour raccordement",{"$f":"Donnees_installation!C28","v":1.5},"mètres"]
[null,null,null,null,null,null,null,"Quantité équivalent CO2 Transport Chantier",{"$f":"Resultats_simulation!C53","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,{"$f":"Resultats_simulation!H53","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,null,null,null,null,null,null,"Quantité équivalent CO2 Engins Chantier",{"$f":"Resultats_simulation!C54","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,{"$f":"Resultats_simulation!H54","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,null,null,null,null,null,null,"Quantité équivalent CO2 Transport Prysmian",{"$f":"Resultats_simulation!C55","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,{"$f":"Resultats_simulation!H55","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,null,null,null,null,null,null,"Quantité équivalent CO2 Transport",{"$f":"Resultats_simulation!C57","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,{"$f":"Resultats_simulation!H57","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[]
[null,null,null,null,null,null,null,"Valeur de gain",null,null,null,null,{"$f":"Resultats_simulation!H59","v":{"$error":"#DIV/0!"}},"€"]
[null,null,null,null,null,null,null,"% de gain",null,null,null,null,{"$f":"Resultats_simulation!H60","v":{"$error":"#DIV/0!"}},"%"]
[null,null,null,null,null,null,null,"Réduction de l'impact CO2 du transport",null,null,null,null,{"$f":"Resultats_simulation!H61","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,null,null,null,null,null,null,"Réduction de l'impact CO2 du transport",null,null,null,null,{"$f":"Resultats_simulation!H62","v":{"$error":"#DIV/0!"}},"%"]
[]
["© PRYSMIAN 2019. Tous droits réservés. Il est interdit de copier, photocopier ou reproduire les informations contenues dans ce document dans quelque forme que ce soit, même en partie sans l’accord écrit préalable de Prysmian. Les informations sont communiquées à titre indicatif, Prysmian se réservant le droit de modifier les caractéristiques du produit sans préavis.\n© PRYSMIAN 2019. All Rights Reserved. The information contained within this document must not be copied, reprinted or reproduced in any form, either wholly or in part, without the written consent of Prysmian. The information is believed correct at the time of issue. Prysmian reserves the right to amend this specification without notice. This specification is not contractually valid unless specifically authorised by Prysmian.",null,null,null,null,null,null,"© PRYSMIAN 2019. Tous droits réservés. Il est interdit de copier, photocopier ou reproduire les informations contenues dans ce document dans quelque forme que ce soit, même en partie sans l’accord écrit préalable de Prysmian. Les informations sont communiquées à titre indicatif, Prysmian se réservant le droit de modifier les caractéristiques du produit sans préavis.\n© PRYSMIAN 2019. All Rights Reserved. The information contained within this document must not be copied, reprinted or reproduced in any form, either wholly or in part, without the written consent of Prysmian. The information is believed correct at the time of issue. Prysmian reserves the right to amend this specification without notice. This specification is not contractually valid unless specifically authorised by Prysmian."]

{"sheet":"Donnees_VRD","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Saisie des données VRD"]
[null,"Longueur de liaison",null,"mètres"]
[null,null,null,null,19]
[null,"Localisation chantier",null,null,53]
[null,"Nombre de câble dans tranchée",null,"cables"]
[null,"Largeur tranchée",null,"mètres std",50,"EDR",0.4,"mètres"]
[null,"Profondeur tranchée",null,"mètres std",51,"EDR",0.9,"mètres"]
[null,"Epaisseur du lit de sable",null,"mètres",52]
[]
[null,"Largeur tranchée raccordement",null,"mètres",57]
[null,"Longueur tranchée raccordement",null,"mètres",58]
[null,"Profondeur tranchée raccordement",null,"mètres std",56,"EDR",0.9,"mètres"]
[null,"Epaisseur du lit de sable raccordement",null,"mètres",59]
[]
[null,"Densité terre excavée",null,null,7]
[null,"Densité du sable utilisé",null,null,6]
[null,null,null,null,null,null," "]
[null,"Distance carrière de sable",null,"kilomètres",null," "]
[null,"Localisation carrière",null,null,10]
[null,"Distance carrière de sable calculée",null,"kilomètres"]
[null,"Prix à la tonne de sable",null,"€/tonne",9]
[null,"Prix à la tonne de sable selon cours actuel",null,"€/tonne"]
[null,null,null,null,8]
[]
[null,"Distance décharge",null,"kilomètres"]
[null,"Localisation décharge",null,null,11]
[null,"Distance décharge calculée",null,"kilomètres"]
[null,"Type de camions pour déblaiement des terres en surplus",null,"Tonnes",12]
[null,"Vitesse moyenne camion",null,"km/h",13]
[null,"Temps de déchargement",null,"minutes",14]
[null,"Prix essence au litre",null,"€/litre",15]
[null,"Coût horaire chauffeur",null,"€/heure",16]
[null,"Prix traitement déblais",null,"€/m3",17]
[null,"Prix vente déblais",null,"€/m3",18]
[]
[null,"Prix grillage avertisseur",0.17,"€"]

{"sheet":"Donnees_engin","index":3,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Saisie des données engin"]
[null,"Tractopelle"]
[null,"Prix utilisation à la journée",null,"€/jour",22,580,"€/jour"]
[null,"Forfait Transport",null,"€",21]
[]
[null,"Trancheuse à roue"]
[null,"Prix utilisation à la journée",null,"€/jour",24]
[null,"Forfait Transport",null,"€",23]
[]
[null,"Trancheuse à chaine"]
[null,"Prix utilisation à la journée",null,"€/jour",26]
[null,"Forfait Transport",null,"€",25]
[]
[]
[null,"Nombre tractopelle utilisé cable standard",null,null,28]
[null,"Nombre Trancheuse à roue utilisé cable standard",null,null,27]
[null,"Nombre Trancheuse à chaine utilisé cable standard",null,null,29]
[]
[null,"Nombre tractopelle utilisé cable EDR",null,null,32]
[null,"Nombre Trancheuse à roue utilisé cable EDR",null,null,31]
[null,"Nombre Trancheuse à chaine utilisé cable EDR",null,null,30]

{"sheet":"Donnees_installation","index":4,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Saisie des données installation cable"]
[null,"Type de cables","3 x 1 x 300 ALU"]
[null,"Coût horaire d'un operateur",null,"€/heure",35]
[null,"Fournisseur","GC",null,null,null,null,"GC"]
[null,"Prix du cable standard",null,"€",33]
[null,"Prix du cable EDR",null,"€",null,"EDR"]
[null,"Type de voltage","12/20 kV"]
[null,"Temps de pose standard",null,"m/jour"]
[null,"Nombre d'opérateurs",null,"personnes",null,3,"personnes"]
[null,"Temps de pose EDR",1000,"m/heure",null,null,null,"3 x 1 x 50 ALU"]
[null,"Type de tourets souhaités","J",null,null,null,null,"3 x 1 x 95 ALU"]
[null,"Longueur cable standard",{"$f":"E13","v":800},"mètres",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A32:I34,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)),(VLOOKUP(C12,lg_database_GC!A19:I21,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A93:I95,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)),(VLOOKUP(C12,lg_database_GC!A54:I56,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)))))","v":800},null,null,"3 x 1 x 150 ALU"]
[null,"Longueur cable EDR",{"$f":"E14","v":600},"mètres",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A7:I9,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)),(VLOOKUP(C12,lg_database_GC!A7:I9,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A81:I83,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)),(VLOOKUP(C12,lg_database_GC!A42:I44,IF(C3=H11,3,(IF(C3=H12,4,(IF(C3=H13,5,(IF(C3=H14,6,(IF(C3=H15,7,(IF(C3=H16,8,(IF(C3=H17,9,))))))))))))),FALSE)))))","v":600},null,null,"3 x 1 x 240 ALU"]
[null,"Charge utile ",6000,"Kg",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A56:J58,9,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,9,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A103:J105,9,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,9,FALSE)))))","v":6000},null,null,"3 x 1 x 300 ALU"]
[null,"Tare touret"," 850","Kg",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A56:J58,8,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,8,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A103:J105,8,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,8,FALSE)))))","v":" 850"},null,null,"3 x 1 x 400 ALU"]
[null,"Dimensions tourets : Joues",3000,"mm",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A56:J58,3,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,3,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A103:J105,3,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,3,FALSE)))))","v":3000},null,null,"3 x 1 x 240 CU"]
[null,"Dimensions tourets : Largeur intérieur"," 960","mm",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A56:J58,4,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,4,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A103:J105,4,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,4,FALSE)))))","v":" 960"}]
[null,"Dimensions tourets : Fût"," 1200","mm",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A56:J58,5,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,5,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A103:J105,5,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,5,FALSE)))))","v":" 1200"}]
[null,"Dimensions tourets : Largeur exterieur",1140,"mm",{"$f":"IF(C8=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A56:J58,6,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,6,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C12,lg_database_prysmian!A103:J105,6,FALSE)),(VLOOKUP(C12,lg_database_GC!A30:J32,6,FALSE)))))","v":1140}]
[null,"Nombre de monteurs",2,"personnes",null,null,null,"12/20 kV"]
[null,"Prix achat accesoire raccordement",null,"€",null,null,null,"18/30 kV"]
[null,"Coût horaire raccordement",null,"€/heure"]
[null,"Temps raccordement pour une boite",null,"min"]
[]
[null,"Distance Prysmian - chantier",700,"km"]
[]
[null,"longueur de garde raccordement",1.5,"mètres"]

{"sheet":"Resultats_simulation","index":5,"n_rows":82,"n_cols":15,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Saisie des données installation cable","Cable standard",null,null,null,null,"Cable EDR"]
[null,"Longueur de la tranchée",{"$f":"Donnees_VRD!C3","v":0},"mètres",null,null,null,{"$f":"Donnees_VRD!C3","v":0},"mètres"]
[]
[null,"Volume de terre excavée",{"$f":"Donnees_VRD!C8*Donnees_VRD!C7*Donnees_VRD!C3+C19*((Donnees_VRD!C11-Donnees_VRD!C7)*Donnees_VRD!C8*Donnees_VRD!C12)","v":{"$error":"#DIV/0!"}},"mètres3",null,null,null,{"$f":"C5","v":{"$error":"#DIV/0!"}},"mètres3"]
[null,"Volume de terre (déblais)",{"$f":"(Donnees_VRD!C11*Donnees_VRD!C12*Donnees_VRD!C14*Resultats_simulation!C19)+(Donnees_VRD!C3*Donnees_VRD!C7*Donnees_VRD!C9)-(C19*Donnees_VRD!C12*Donnees_VRD!C9*Donnees_VRD!C7)","v":{"$error":"#DIV/0!"}},"mètres3",null,null,null,0,"mètres3"]
[null,"Poids terre (déblais)",{"$f":"C6*Donnees_VRD!$C$16","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,null,{"$f":"H6*Donnees_VRD!$C$16","v":0},"Tonnes"]
[null,"Nombre de camions pour évacuation",{"$f":"ROUNDUP(C7/(E8),0)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!C29","v":0},"tonnes",null,{"$f":"H7/J8","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!C29","v":0},"tonnes"]
[null,"Coût traitement des déchets",{"$f":"Donnees_VRD!C34*Resultats_simulation!C6-Donnees_VRD!C35*Resultats_simulation!C6","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"Donnees_VRD!C34*Resultats_simulation!H6-Donnees_VRD!C35*Resultats_simulation!H6","v":0},"€"]
[null,"Coût évacuation déblais",{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$26/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$26*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!C8","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$26*(Donnees_VRD!$C$30/60)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$26*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!H8","v":{"$error":"#DIV/0!"}},"€"]
[null,"Coût traitement de la terre",{"$f":"C9+C10+C31","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H9+H10+H31","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Volume de sable nécessaire pour pose cable",{"$f":"(Donnees_VRD!C3*Donnees_VRD!C7*Donnees_VRD!C9)-((PI()*((calcul_cable!C6)/2)^2*Donnees_VRD!C3)*0.64*Donnees_VRD!C6)-(C19*Donnees_VRD!C12*Donnees_VRD!C9*Donnees_VRD!C7)","v":{"$error":"#DIV/0!"}},"mètres3",null,null,null,0,"mètres3"]
[null,"Poids du sable nécessaire pour pose cable",{"$f":"C13*Donnees_VRD!$C$17","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,null,{"$f":"H13*Donnees_VRD!$C$17","v":0},"Tonnes"]
[null,"Nombre de camions de sable pour pose cable",{"$f":"ROUNDUP(C14/(E15),0)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!C29","v":0},"tonnes",null,{"$f":"ROUNDUP(H14/J15,1)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!C29","v":0},"tonnes"]
[null,"Montant Achat sable pour pose cable",{"$f":"Donnees_VRD!$C$22*Resultats_simulation!C14","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"Donnees_VRD!$C$22*Resultats_simulation!H14","v":0},"€",null,null,null," "]
[null,"Montant transport sable pour pose cable",{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$19/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$19*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!C15","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$19/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$19*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!H15","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Nombre de boîtes raccordement",{"$f":"C46","v":{"$error":"#DIV/0!"}},"unités",null,null,null,{"$f":"H46","v":{"$error":"#DIV/0!"}},"unités"]
[null,"Volume de sable nécessaire pour raccordement",{"$f":"(Donnees_VRD!C11*Donnees_VRD!C12*Donnees_VRD!C14*Resultats_simulation!C19)-((PI()*((calcul_cable!C6)/2)^2*0.64*Donnees_VRD!C12*Resultats_simulation!C19)*Donnees_VRD!C6)","v":{"$error":"#DIV/0!"}},"mètres3",null,null,null,{"$f":"Donnees_VRD!$C$11*Donnees_VRD!$C$12*Donnees_VRD!$C$14*Resultats_simulation!H19-((PI()*((calcul_cable!C6)/2)^2*0.64*Donnees_VRD!C12*Resultats_simulation!H19)*Donnees_VRD!C6)","v":{"$error":"#DIV/0!"}},"mètres3"]
[null,"Poids du sable nécessaire pour raccordement",{"$f":"C20*Donnees_VRD!C17","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,null,{"$f":"H20*Donnees_VRD!C17","v":{"$error":"#DIV/0!"}},"Tonnes",null,null,null,null,null," "]
[null,"Nombre de camions de sable pour raccordement",{"$f":"ROUNDUP(C21/(E22),0)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!$C$29","v":0},"tonnes",null,{"$f":"ROUNDUP(H21/(J22),0)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!$C$29","v":0},"tonnes"]
[null,"Montant Achat sable pour raccordement",{"$f":"C21*Donnees_VRD!C22","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H21*Donnees_VRD!C22","v":{"$error":"#DIV/0!"}},"€"]
[null,"Montant livraison sable pour pose cable",{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$19/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$19*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!C22","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$19/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$19*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!H22","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Volume sable total",{"$f":"C14+C21","v":{"$error":"#DIV/0!"}},"tonnes",null,null,null,{"$f":"H14+H21","v":{"$error":"#DIV/0!"}},"tonnes"]
[null,"Nombre de camions total",{"$f":"ROUNDUP(C26/(E27),0)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!$C$29","v":0},"tonnes",null,{"$f":"ROUNDUP(H26/(J27),0)","v":{"$error":"#DIV/0!"}},"camions de",{"$f":"Donnees_VRD!$C$29","v":0},"tonnes"]
[null,"Montant Achat sable ",{"$f":"Donnees_VRD!$C$22*Resultats_simulation!C26","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"Donnees_VRD!$C$22*Resultats_simulation!H26","v":{"$error":"#DIV/0!"}},"€"]
[null,"Montant transport sable",{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$19/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$19*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!C27","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"((((Donnees_VRD!$C$31/60)+(Donnees_VRD!$C$19/(Donnees_VRD!$C$30)))*2*Donnees_VRD!$C$33)+(Donnees_VRD!$C$19*2*Donnees_VRD!$C$32*calcul_cable!$C$14))*Resultats_simulation!H27","v":{"$error":"#DIV/0!"}},"€"]
[null,"Montant total sable",{"$f":"C16+C17+C23+C24","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H16+H17+H23+H24","v":{"$error":"#DIV/0!"}},"€"]
[null,"Cout grillage avertisseur",{"$f":"Donnees_VRD!C37*Donnees_VRD!C3","v":0},"€",null,null,null,{"$f":"Donnees_VRD!C37*Donnees_VRD!C3","v":0},"€"]
[]
[null,"Coût tractopelle(s)",{"$f":"(Donnees_engin!C5+Donnees_engin!C4*ROUNDUP(Resultats_simulation!C43/8,0))*Donnees_engin!C16","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"(Donnees_engin!C5+Donnees_engin!C4*ROUNDUP(Resultats_simulation!H43/8,0))*Donnees_engin!C20","v":0}]
[null,"Coût trancheuse(s)",{"$f":"(Donnees_engin!C9+Donnees_engin!C8*ROUNDUP(Resultats_simulation!C43/8,0))*Donnees_engin!C17","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"(Donnees_engin!C9+Donnees_engin!C8*ROUNDUP(Resultats_simulation!H43/8,0))*Donnees_engin!C21","v":0}]
[null,"Coût trancheuse(s) à chaine",{"$f":"(Donnees_engin!C13+Donnees_engin!C12*Resultats_simulation!C43/8)*Donnees_engin!C18","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"(Donnees_engin!C13+Donnees_engin!C12*Resultats_simulation!C43/8)*Donnees_engin!C22","v":{"$error":"#DIV/0!"}}]
[null,"Coût engin tranchée",{"$f":"C33+C34+C35","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H33+H34+H35","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Sous total VRD",{"$f":"C36+C30+C11","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H36+H30+H11","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Quantité de câble nécessaire",{"$f":"Donnees_VRD!$C$3*Donnees_VRD!C6","v":0},"mètres",null,null,null,{"$f":"Donnees_VRD!$C$3*Donnees_VRD!C6","v":0},"mètres"]
[null,"Quantité de câble /touret",{"$f":"Donnees_installation!C13","v":800},"mètres",null,null,null,{"$f":"Donnees_installation!C14","v":600},"mètres"]
[null,"Nombre de tourets \"type\"",{"$f":"ROUNDUP((C3+(C66/Donnees_VRD!C6))/C41,0)*Donnees_VRD!C6","v":{"$error":"#DIV/0!"}},"tourets type",{"$f":"Donnees_installation!C12","v":"J"},null,null,{"$f":"ROUNDUP((H3+(H66/Donnees_VRD!C6))/H41,0)*Donnees_VRD!C6","v":{"$error":"#DIV/0!"}},"tourets type",{"$f":"Donnees_installation!C12","v":"J"}]
[null,"Nombre d'heure de déroulage",{"$f":"(Donnees_VRD!C3*Donnees_VRD!C6)/(Donnees_installation!$C$9/8)","v":{"$error":"#DIV/0!"}},"heures",null,null,null,{"$f":"(Donnees_VRD!C3*Donnees_VRD!C6)/(Donnees_installation!$C$11/8)","v":0},"heures"]
[null,"Coût opérateur déroulage",{"$f":"C43*Donnees_installation!$C$4*Donnees_installation!$C$10","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H43*Donnees_installation!$C$4*Donnees_installation!$F$10","v":0},"€"]
[null,"Montant achat câble",{"$f":"(C40+C65)*Donnees_installation!C6","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"(H40+H65)*Donnees_installation!C7","v":{"$error":"#DIV/0!"}},"€"]
[null,"Nombre de boîtes raccordement",{"$f":"((C42/Donnees_VRD!C6)-1)*Donnees_VRD!C6","v":{"$error":"#DIV/0!"}},"unités",null,null,null,{"$f":"((H42/Donnees_VRD!C6)-1)*Donnees_VRD!C6","v":{"$error":"#DIV/0!"}},"unités"]
[null,"Montant total raccordement",{"$f":"C46*Donnees_installation!$C$22+(C46*(Donnees_installation!$C$24/60)*Donnees_installation!$C$23*Donnees_installation!$C$21)","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H46*Donnees_installation!$C$22+(H46*(Donnees_installation!$C$24/60)*Donnees_installation!$C$23*Donnees_installation!$C$21)","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Total câble et raccordement",{"$f":"C44+C45+C47","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H44+H45+H47","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Montant total chantier",{"$f":"C49+C38","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H49+H38","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Quantité équivalent CO2 Transport Chantier",{"$f":"SUM(calcul_cable!C16:C17)","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,null,{"$f":"SUM(calcul_cable!F16:F17)","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,"Quantité équivalent CO2 Engins Chantier",{"$f":"calcul_cable!C33","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,null,{"$f":"calcul_cable!F33","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,"Quantité équivalent CO2 Transport Prysmian",{"$f":"calcul_cable!C21","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,null,{"$f":"calcul_cable!F21","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,"Quantité équivalent CO2 Cable",null,"kg éq. CO2",null,null,null,null,"kg éq. CO2"]
[null,"Quantité équivalent CO2 Transport",{"$f":"SUM(C53:C56)","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,null,null,{"$f":"SUM(H53:H56)","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[]
[null,"Valeur de gain",null,null,null,null,null,{"$f":"C51-H51","v":{"$error":"#DIV/0!"}},"€"]
[null,"% de gain",null,null,null,null,null,{"$f":"ROUNDUP((C51-H51)/C51 *100,1)","v":{"$error":"#DIV/0!"}},"%"]
[null,"Réduction de l'impact sur le réchauffement climatique",null,null,null,null,null,{"$f":"C57-H57","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,"Réduction de l'impact sur le réchauffement climatique",null,null,null,null,null,{"$f":"ROUNDUP((C57-H57)/C57*100,1)","v":{"$error":"#DIV/0!"}},"%"]
[null,"Travail horaire par opérateur",{"$f":"C43/Donnees_installation!C10","v":{"$error":"#DIV/0!"}},"h/personne",null,null,null,{"$f":"H43/Donnees_installation!F10","v":0},"h/personne"]
[]
[null,"Quantité câble pour raccordement",{"$f":"((2*Donnees_installation!C28*C46)+(2*4))*Donnees_VRD!C6","v":{"$error":"#DIV/0!"}},"mètres",null,null,null,{"$f":"((2*Donnees_installation!C28*H46)+(2*4))*Donnees_VRD!C6","v":{"$error":"#DIV/0!"}},"mètres"]
[null,null,{"$f":"((2*Donnees_installation!C28*(ROUNDUP((C3/C41),0)))+(2*2.5))*Donnees_VRD!C6","v":0},null,null,null,null,{"$f":"((2*Donnees_installation!C28*(ROUNDUP((C3/H41),0)))+(2*2.5))*Donnees_VRD!C6","v":0}]
[]
[null,"Cout opérateurs",{"$f":"C44","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H44","v":0},"€"]
[null,"Coût monteurs",{"$f":"C46*(Donnees_installation!$C$24/60)*Donnees_installation!$C$23*Donnees_installation!$C$21","v":{"$error":"#DIV/0!"}},"€",null,null,null,{"$f":"H46*(Donnees_installation!$C$24/60)*Donnees_installation!$C$23*Donnees_installation!$C$21","v":{"$error":"#DIV/0!"}},"€"]
[]
[null,"Nombre d'heures"]
[null,"Opérateurs",{"$f":"C43","v":{"$error":"#DIV/0!"}},"heures",null,null,null,{"$f":"H43","v":0},"heures"]
[null,"Monteurs",{"$f":"C46*Donnees_installation!C24","v":{"$error":"#DIV/0!"}},"heures",null,null,null,{"$f":"H46*Donnees_installation!C24","v":{"$error":"#DIV/0!"}},"heures"]
[null,"Total heures",{"$f":"C72+C73","v":{"$error":"#DIV/0!"}},"heures",null,null,null,{"$f":"H72+H73","v":{"$error":"#DIV/0!"}},"heures"]
[null,null,{"$f":"C74/8","v":{"$error":"#DIV/0!"}},"jours",null,null,null,{"$f":"H74/8","v":{"$error":"#DIV/0!"}},"jours"]
[]
[null,"Nombre de personnes"]
[null,"Opérateurs",{"$f":"Donnees_installation!C10","v":0},null,null,null,null,{"$f":"Donnees_installation!F10","v":3}]
[null,"Monteurs",{"$f":"Donnees_installation!C21","v":2},null,null,null,null,{"$f":"Donnees_installation!C21","v":2}]
[null,null,{"$f":"C78+C79","v":2},null,null,null,null,{"$f":"H78+H79","v":5}]
[]
[null,null,{"$f":"C75/C80","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"H75/H80","v":{"$error":"#DIV/0!"}}]

{"sheet":"calcul_cable","index":6,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Calcul cable","Cable standard",null,null,"Cable EDR"]
[null,"Voltage",{"$f":"Donnees_installation!C8","v":"12/20 kV"},null,null,{"$f":"C3","v":"12/20 kV"}]
[null,"Type de cables",{"$f":"Donnees_installation!C3","v":"3 x 1 x 300 ALU"},null,null,{"$f":"Donnees_installation!C3","v":"3 x 1 x 300 ALU"}]
[null,"Fournisseur",{"$f":"Donnees_installation!C5","v":"GC"},null,null,{"$f":"C5","v":"GC"}]
[null,"Diamètre torsade",{"$f":"IF(C3=\"12/20 kV\",(IF(C5=\"Prysmian\",(VLOOKUP(C4,diametre_cable!H3:J9,3,FALSE)),(VLOOKUP(C4,diametre_cable!H25:J31,3,FALSE)))),(IF(C5=\"Prysmian\",(VLOOKUP(C4,diametre_cable!H14:J20,3,FALSE)),(VLOOKUP(C4,diametre_cable!H36:J42,3,FALSE)))))","v":0.09},"mètres",null,{"$f":"IF(F3=\"12/20 kV\",(IF(F5=\"Prysmian\",(VLOOKUP(F4,diametre_cable!B3:D9,3,FALSE)),(VLOOKUP(F4,diametre_cable!B25:D31,3,FALSE)))),(IF(F5=\"Prysmian\",(VLOOKUP(F4,diametre_cable!B14:D20,3,FALSE)),(VLOOKUP(F4,diametre_cable!B36:D42,3,FALSE)))))","v":0.10100000000000001},"mètres"]
[null,"Type de touret souhaité",{"$f":"Donnees_installation!C12","v":"J"},null,null,{"$f":"Donnees_installation!C12","v":"J"}]
[null,"Longueur par touret",{"$f":"Donnees_installation!C13","v":800},null,null,{"$f":"Donnees_installation!C14","v":600}]
[]
[null,"Prix accessoire pièce",{"$f":"Donnees_installation!C22","v":0},"€",null,{"$f":"Donnees_installation!C22","v":0},"€"]
[null,"Nombre accesoires",{"$f":"ROUNDUP(((Donnees_VRD!$C$3/calcul_cable!C8)-1),0)","v":-1},null,null,{"$f":"ROUNDUP(((Donnees_VRD!$C$3/calcul_cable!F8)-1),0)","v":-1}]
[]
[null,"Consommation camion 20T",35,"L/100km"]
[null,"Consommation camion 20T",{"$f":"C13/100","v":0.35},"L/km"]
[]
[null,"Quantité équivalent CO2 Transport sable",{"$f":"Etude_CO2!$L$5*calcul_cable!$C$14*Donnees_VRD!$C$19*(Resultats_simulation!C15+Resultats_simulation!C22)*2","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"Etude_CO2!$L$5*calcul_cable!$C$14*Donnees_VRD!$C$19*(Resultats_simulation!H15+Resultats_simulation!H22)*2","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,"Quantité équivalent CO2 Transport déblais",{"$f":"Etude_CO2!$L$5*calcul_cable!$C$14*Donnees_VRD!$C$26*Resultats_simulation!C8*2","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"Etude_CO2!$L$5*calcul_cable!$C$14*Donnees_VRD!$C$26*Resultats_simulation!H8*2","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[]
[null,"Combien de tourets pleins sur 1 seul camion",{"$f":"VLOOKUP(C7,Chargement_tourets!B21:D33,3,FALSE)","v":8},null,null,{"$f":"C19","v":8}]
[null,"Combien de tourets vides sur 1 seul camion",{"$f":"VLOOKUP(C7,Chargement_tourets!B21:D33,2,FALSE)","v":8},null,null,{"$f":"C20","v":8}]
[null,"Quantité équivalent CO2 Transport Prysmian",{"$f":"(Donnees_installation!$C$26*ROUNDUP(Resultats_simulation!C42/calcul_cable!C19,0)+Donnees_installation!$C$26*ROUNDUP(Resultats_simulation!C42/calcul_cable!C20,0))*calcul_cable!$C$14*Etude_CO2!$L$5","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"(Donnees_installation!$C$26*ROUNDUP(Resultats_simulation!H42/calcul_cable!F19,0)+Donnees_installation!$C$26*ROUNDUP(Resultats_simulation!H42/calcul_cable!F20,0))*calcul_cable!$C$14*Etude_CO2!$L$5","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[]
[]
[null,"Nombre tractopelle ",{"$f":"Donnees_engin!C16","v":0},null,null,{"$f":"Donnees_engin!C20","v":0}]
[null,"Consommation carburant tractopelle",9,"L/H",null,{"$f":"C25","v":9},"L/H",null,null,"conso jour : 70L"]
[null,null,{"$f":"C24*C25*Resultats_simulation!$C$43*Etude_CO2!$L$5","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"F24*F25*Resultats_simulation!$H$43*Etude_CO2!$L$5","v":0},"kg éq. CO2"]
[null,"Nombre Trancheuse à roue ",{"$f":"Donnees_engin!C17","v":0},null,null,{"$f":"Donnees_engin!C21","v":0}]
[null,"Consommation carburant trancheuse à chaine",15,"L/H",null,{"$f":"C28","v":15},"L/H"]
[null,null,{"$f":"C27*C28*Resultats_simulation!$C$43*Etude_CO2!$L$5","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"F27*F28*Resultats_simulation!$H$43*Etude_CO2!$L$5","v":0},"kg éq. CO2"]
[null,"Nombre Trancheuse à chaine ",{"$f":"Donnees_engin!C18","v":0},null,null,{"$f":"Donnees_engin!C22","v":0}]
[null,"Consommation carburant",15,"L/H",null,{"$f":"C31","v":15},"L/H"]
[null,null,{"$f":"C30*C31*Resultats_simulation!$C$43*Etude_CO2!$L$5","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"F30*F31*Resultats_simulation!$C$43*Etude_CO2!$L$5","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]
[null,"Quantité équivalent CO2 Engins Chantier",{"$f":"SUM(C26+C29+C32)","v":{"$error":"#DIV/0!"}},"kg éq. CO2",null,{"$f":"SUM(F26+F29+F32)","v":{"$error":"#DIV/0!"}},"kg éq. CO2"]

{"sheet":"Etude_CO2","index":7,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,"Facteurs d’émission des sources d’énergie de l’arrêté du 10 avril 2012"]
[null,"GES = Quantité de gaz émis´ PRG",null,null,null,null,null,null,null,"Nature de la source d'énergie","Type détaillé de la source d'énergie","Facteur émission (kg CO2 par litre)"]
[null,"Résultat des mesures des effluents gazeux (débit,concentrations)",null,null,null,null,null,null,null,"Essence automobile","SP95 - SP98",2.71]
[null,"Pouvoir de Réchauffement Global des gaz (PRG)",null,null,null,null,null,null,null,"Gazole","Gazole routier à la pompe ",3.07]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L4","v":3.07}]
[]
[null,"GES = Donnée d 'activité ´ FE ´ PRG"]
[null,"Donnée d’activité"]
[null,"Facteur d’émission (FE)"]
[null,"PRG"]
[]
[]
[null,"Base consommation véhicule"]
[null,"Type (T)","Conso L/100km","Conso L/km",null,"Type (T)","Conso L/100km"]
[null,"0 a 3",43.2,{"$f":"C15/100","v":0.43200000000000005},null,0,43.2]
[null,"4 a 8",50.6,{"$f":"C16/100","v":0.50600000000000001},null,1,43.2]
[null,"10 a 15",42.5,{"$f":"C17/100","v":0.42499999999999999},null,2,43.2]
[null,"15 et +",48.1,{"$f":"C18/100","v":0.48100000000000004},null,3,43.2]
[null,null,null,null,null,4,50.6]
[null,null,null,null,null,5,50.6]
[null,null,null,null,null,6,50.6]
[null,null,null,null,null,7,50.6]
[null,null,null,null,null,8,50.6]
[null,null,null,null,null,9,50.6]
[null,null,null,null,null,10,42.5]
[null,null,null,null,null,11,42.5]
[null,null,null,null,null,12,42.5]
[null,null,null,null,null,13,42.5]
[null,null,null,null,null,14,42.5]
[null,null,null,null,null,15,42.5]
[null,null,null,null,null,16,48.1]
[null,null,null,null,null,17,48.1]
[null,null,null,null,null,18,48.1]
[null,null,null,null,null,19,48.1]
[null,null,null,null,null,20,48.1]
[null,null,null,null,null,21,48.1]
[null,null,null,null,null,22,48.1]
[null,null,null,null,null,23,48.1]
[null,null,null,null,null,24,48.1]
[null,null,null,null,null,25,48.1]
[null,null,null,null,null,26,48.1]
[null,null,null,null,null,27,48.1]
[null,null,null,null,null,28,48.1]
[null,null,null,null,null,29,48.1]
[null,null,null,null,null,30,48.1]

{"sheet":"Case_liste","index":8,"n_rows":303,"n_cols":29,"rows_kept":303,"cut":false,"hidden":true,"merged":[]}
[1]
[2]
[3]
[4,"cable",null,"monteurs"]
[5]
[6,1,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EDR - PR - 18/30kV",null,"EDR 18/30 kV",null,"EDR 12/20 kV"]
[7,2,null,2,"GC",null,null,null,null,"GBM",null,null,null,null,"EDR prysmian",null,null,null,null,null,null,"EDR - PR - 12/20kV",null,null,"95 &150",null,240,null,240]
[8,3,null,3,"Prysmian",null,null,null,null,"GBL"]
[9,4,null,null,null,null,null,null,null,"HBM",null,null,"EDR prysmian",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 240 CU",null,null,null,null,null,"H",null,"J",null,"I"]
[10,null,null,null,null,null,null,null,null,"HBL",null,null,null,null,"GBM","GBM","GBM","HBM","HBM",null,null,"3 x 1 x 50 ALU",null,null,"I",null,null,null,"J"]
[11,null,null,null,null,null,null,null,null,"IBM",null,null,"H",null,"HBM","HBM","HBM","IBM","IBM",null,null,"3 x 1 x 95 ALU",null,null,"J"]
[12,null,null,null,null,null,null,null,null,"GBE",null,null,"I",null,"IBM","IBM","IBM","HBE","HBE",null,null,"3 x 1 x 150 ALU"]
[13,null,null,null,null,null,null,null,null,"HBE",null,null,"J",null,"GBE","HBE","HBE","IBE","IBE",null,null,"3 x 1 x 240 ALU",null,null,"3 x 1 x 95 ALU"]
[14,null,null,null,null,null,null,null,null,"HBW34",null,null,null,null,"HBE","IBE","IBE","BOXY","BOXY",null,null,"3 x 1 x 300 ALU",null,null,"3 x 1 x 150 ALU"]
[15,null,null,null,null,null,"Cable disponible",null,null,"IBE",null,null,null,null,"HBW34","BOXY","BOXY","JFM1","JFM1",null,null,"3 x 1 x 400 ALU",null,null,"3 x 1 x 240 ALU"]
[16,null,null,null,null,null,null,null,null,"BOXY",null,null,null,null,"IBE","JFM1","JFM1","JFM2","JFM2",null,null,"3 x 1 x 240 CU",null,null,"3 x 1 x 300 ALU"]
[17,null,null,null,null,null,"3 x 1 x 50 ALU",null,null,"JFM1",null,null,null,null,"BOXY","JFM2","JFM2","JFM3","JFM3",null,null,null,null,null,"3 x 1 x 400 ALU"]
[18,null,null,null,null,null,"3 x 1 x 95 ALU",null,null,"JFM2",null,null,null,null,"JFM1","JFM3","JFM3",null,null,null,null,null,null,null,"3 x 1 x 240 CU"]
[19,null,null,null,null,null,"3 x 1 x 150 ALU",null,null,"JFM3",null,null,null,null,"JFM2"]
[20,"Type engin",null,null,null,null,"3 x 1 x 240 ALU",null,null,null,null,null,null,null,"JFM3"]
[21,"Tractopelle",null,null,null,null,"3 x 1 x 240 CU"]
[22,"Trancheuse à chaine",null,null,null,null,"3 x 1 x 300 ALU",null,null,null,null,null,null,null,null,"EDR GC"]
[23,"Trancheuse à roue",null,null,null,null,"3 x 1 x 400 ALU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EDR - GC - 18/30kV"]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 240 CU",null,null,null,"EDR - GC - 12/20kV",null,null,"3 x 1 x 95 ALU"]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H","H","H",null,null,null,"3 x 1 x 150 ALU",null,null,"3 x 1 x 150 ALU"]
[26,null,null,null,null,null,null,null,"12/20 kV",null,null,null,null,null,null,"I","I","I",null,null,null,"3 x 1 x 240 ALU",null,null,"3 x 1 x 240 ALU"]
[27,null,null,null,null,null,null,null,"18/30 kV",null,null,null,null,null,null,"J","J","J",null,null,null,"3 x 1 x 300 ALU",null,null,"3 x 1 x 300 ALU"]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 x 1 x 400 ALU",null,null,"3 x 1 x 400 ALU"]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 x 1 x 240 CU",null,null,"3 x 1 x 240 CU"]
[30]
[31]
[32]
[33]
[34]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HBW34","HBW34","HBW34"]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]

{"sheet":"Database_tranchee","index":9,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[null,1,2,3,4,5,6,7,8,9,10,11]
[]
[null,"Nombre de câble","Largeur std","Largeur EDR","Profondeur std","Profondeur EDR","Epaisseur lit de sable","Largueur racc","Longueur racc","Profondeur racc std","Profondeur racc EDR","Epaisseur sable racc"]
[null,1,0.3,0.2,0.8,0.7,0.3,1,1.1000000000000001,0.8,0.7,{"$f":"G4","v":0.3}]
[null,2,0.5,{"$f":"C5-0.1","v":0.4},0.8,0.7,0.3,{"$f":"E5+0.2","v":1},1.1000000000000001,0.8,{"$f":"F5","v":0.7},{"$f":"G5","v":0.3}]
[null,3,0.7,{"$f":"C6-0.1","v":0.6},0.8,0.7,0.3,{"$f":"E6+0.2","v":1},1.1000000000000001,0.8,{"$f":"F6","v":0.7},{"$f":"G6","v":0.3}]
[null,4,0.5,{"$f":"C7-0.1","v":0.4},1,0.9,0.5,{"$f":"E7+0.2","v":1.2},1.1000000000000001,{"$f":"E7","v":1},{"$f":"F7","v":0.9},{"$f":"G7","v":0.5}]
[]
[null,"Nombre de câble dans tranchée",{"$f":"Donnees_VRD!C6","v":0},"cables"]
[]
[null,"Largeur tranchée",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,2,FALSE)","v":{"$error":"#N/A"}},"mètres std",50,"EDR",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,3,FALSE)","v":{"$error":"#N/A"}},"mètres"]
[null,"Profondeur tranchée",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,4,FALSE)","v":{"$error":"#N/A"}},"mètres std",51,"EDR",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,5,FALSE)","v":{"$error":"#N/A"}},"mètres"]
[null,"Epaisseur du lit de sable",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,6,FALSE)","v":{"$error":"#N/A"}},"mètres",52]
[]
[null,"Largeur tranchée raccordement",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,7,FALSE)","v":{"$error":"#N/A"}},"mètres",57]
[null,"Longueur tranchée raccordement",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,8,FALSE)","v":{"$error":"#N/A"}},"mètres",58]
[null,"Profondeur tranchée raccordement",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,9,FALSE)","v":{"$error":"#N/A"}},"mètres std",56,"EDR",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,10,FALSE)","v":{"$error":"#N/A"}},"mètres"]
[null,"Epaisseur du lit de sable raccordement",{"$f":"VLOOKUP($C$9,Database_tranchee!B4:L7,11,FALSE)","v":{"$error":"#N/A"}},"mètres",59]

{"sheet":"Chargement_tourets","index":10,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Infos transmis par Chanoine Corinne le 30 octobre 2018"]
[null,null,null,"Capacité de chargement d'un camion "]
[null,null,null,"Encombrement / surface du plancher de 2.6 x 13.2m"]
[]
[null,"Diamètre ","Nombre de tourets vides","Nombre de tourets pleins - chargement < ou = à 24T","Remarque"]
[null,"A",480,85,"68 si ABP largeur 0.58 m"]
[null,"B",220,56]
[null,"C",120,48]
[null,"D ",81,30]
[null,"E",69,27]
[null,"F",48,21]
[null,"G",18,12,"ou 13 selon le poids (1 en canon à l'arrière)"]
[null,"H",16,10,"ou 11 selon le poids (1 en canon à l'arrière)"]
[null,"I",12,8,"ou 10 si longueur >13 m"]
[null,"J",8,8,"ou 4 si surbaissée si >3.5 / touret"]
[]
[]
[]
[]
[null,"Type","Nombre de tourets vides","Nombre de tourets pleins - chargement < ou = à 24T","Remarque"]
[null,"GBM",18,12,"ou 13 selon le poids (1 en canon à l'arrière)"]
[null,"GBL",18,12,"ou 13 selon le poids (1 en canon à l'arrière)"]
["HBM","H",16,10,"ou 11 selon le poids (1 en canon à l'arrière)"]
[null,"HBL",16,10,"ou 11 selon le poids (1 en canon à l'arrière)"]
["IBM","I",12,8,"ou 10 si longueur >13 m"]
[null,"GBE",18,12,"ou 13 selon le poids (1 en canon à l'arrière)"]
[null,"HBE",16,10,"ou 11 selon le poids (1 en canon à l'arrière)"]
[null,"HBW34",16,10,"ou 11 selon le poids (1 en canon à l'arrière)"]
[null,"IBE",12,8,"ou 10 si longueur >13 m"]
[null,"BOXY",8,4]
[null,"JFM1",8,8,"ou 4 si surbaissée si >3.5 / touret"]
[null,"JFM2",8,8,"ou 4 si surbaissée si >3.5 / touret"]
["JFM3","J",8,8,"ou 4 si surbaissée si >3.5 / touret"]

{"sheet":"lg_database_prysmian","index":11,"n_rows":105,"n_cols":11,"rows_kept":105,"cut":false,"hidden":true,"merged":[[74,2,74,9],[75,2,75,9],[86,2,86,9],[87,2,87,9],[25,2,25,9],[26,2,26,9],[51,2,51,9],[0,2,0,9],[1,2,1,9],[52,8,53,8],[52,9,54,9],[52,10,53,10],[52,2,53,2],[52,3,53,3],[52,4,53,4],[52,5,53,5],[52,6,54,6],[52,7,53,7],[99,10,100,10],[98,2,98,9],[99,2,100,2],[99,3,100,3],[99,4,100,4],[99,5,100,5],[99,6,101,6],[99,7,100,7],[99,8,100,8],[99,9,101,9]]}
[null,null,"CABLES EDR"]
[null,null,"12/20kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[null,"Code  CA","P26EDR-163","P26EDR-165","P26EDR-167","P26EDR-169","P26EDR-170","P26EDR-171","P26EDR-885"]
[null,"Code SAP",20234567,20171640,20171641,20171642,20171645,"NC",20171646]
[null,"Touret"]
["H","HBM",330,240,230,215,0,0,215]
["I","IBM",590,475,455,355,0,0,355]
["J","JFM2",760,650,615,490,440,0,480]
["GBM","DOF190M",170,160,155,0,0,0,0]
["GBL","DOF188M",0,0,0,0,0,0,0]
["HBL","DOF220F",0,0,0,0,0,0,0]
["GBE","DWF1900",280,0,0,0,0,0,0]
["HBE","DWF2200",330,240,230,215,0,0,215]
["HBW34","DWF2240",470,0,0,0,0,0,0]
["IBE","DWF2600",590,475,455,355,0,0,355]
["BOXY",null,845,645,645,475,0,0,475]
["JFM1","DOF300I",1150,900,895,685,640,475,670]
["JFM3","DOF300R",1235,975,955,735,705,510,735]
["TOURET 1 A CREER","-",3360,2695,2650,2075,1810,0,2075]
["TOURET 2 A CREER","-",2130,1800,1770,1300,1255,0,1300]
["TOURET 3  A CREER","-",1310,1055,1035,815,785,0,815]
[]
[]
[]
[null,null,"CABLES STANDARDS - TORSADE"]
[null,null,"12/20kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[null,"Code  CA","PBG6-163","PBG6-165","PBG6-167","PBG6-169","PBG6-170","PBG6-171","PBG6-885"]
[null,"Code SAP",20034743,20034744,20034745,20034746,20034747,20051891,20034756]
[null,"Touret"]
["H","HBM",480,450,430,345,220,0,310]
["I","IBM",910,780,755,535,440,0,510]
["J","JFM2",1235,905,940,740,550,435,685]
["GBM","DOF190M",285,265,265,200,150,0,160]
["GBL","DOF188M",345,315,300,220,0,0,220]
["HBL","DOF220F",620,510,510,430,0,0,420]
["GBE","DWF1900",410,310,300,0,0,0,0]
["HBE","DWF2200",480,450,360,310,220,0,310]
["HBW34","DYF224A",635,505,500,380,0,0,380]
["IBE","DWF2600",910,750,735,515,440,0,490]
["BOXY","FER PROCESS",1335,1070,890,660,620,460,660]
["JFM1","DOF300I",1750,1425,1400,950,870,655,920]
["JFM3","DOF300R",1893,1520,1500,995,930,700,995]
["TOURET 1 A CREER","-",3000,3000,3000,2740,2400,1790,2740]
["TOURET 2 A CREER","-",3000,2480,2450,1830,1560,1240,1830]
["TOURET 3  A CREER","-",2180,1590,1570,1250,1020,780,1250]
[]
[]
[]
[]
[null,null,"DIMENSIONS TOURETS pour cable 12/20kV"]
[null,null,"Joues","Larg. Int.","Fût","Larg. Ext.","Trou d'axe","Tare","Charge utile","Rampe","Larg. Ext. + collerettes"]
[]
["Touret",null,"mm","mm"," mm"," mm ",null," kg"," kg",null," mm "]
["H","HBM",2200,960,1200,1112,82,435,5000,"NON"]
["I","IBM",2600,960,1200,1132,82,640,6000,"NON"]
["J","JFM2",3000,920,1400,1160,150,920,7000,80]
["HBL","DOF220F",2200,990,980,1150,82,450,5000,"NON"]
["IBM","DOF260M",2600,960,1200,1132,82,920,6000,"NON"]
["GBE","DWF1900",1900,960,960,1120,82,378,4000,"NON"]
["HBE","DWF2200",2200,960,1200,1120,82,520,5000,"NON"]
["HBW34","DYF224A",2240,998,1020,1200,82,650,5000,"NON"]
["IBE","DWF2600",2600,960,1200,1132,82,854,6000,"NON"]
["BOXY","FER PROCESS",2600,1460,1350,1600,82,920,12000,"NON"]
["JFM1","DOF300I",3000,1500,1600,1800,145,850,9000,100]
["JFM2","DOF300R",3000,920,1400,1180,145,920,7000,80]
["JFM3","DOF300J",3000,1600,1600,1760,145,770,9000,"NON"]
["TOURET 1 A CREER","-",4100,1600,1400,1700,150,"NC",13000,"NON",1850]
["TOURET 2 A CREER","-",3500,1600,1400,1850,150,"NC",13000,"NON",1850]
["TOURET 3  A CREER","-",3000,1600,1400,1850,85,"NC",13000,"NON"]
[]
[]
[]
[null,null,"CABLES EDR"]
[null,null,"18/30kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[null,"Code  CA","P26EDR8163","P26EDR8165","P26EDR8167","P26EDR8169","P26EDR8170","NON FAISABLE","P26EDR8885"]
[null,"Code SAP","PAS DE DEMANDE POUR L'INSTANT","NC","NC","NC","NC","NON FAISABLE","PAS DE DEMANDE POUR L'INSTANT"," "]
[null,"Touret"]
["H","HBM",0,225,205,0,0,0,0]
["I","IBM",0,365,340,0,0,0,0]
["J","JFM2",0,585,480,445,350,0,0]
[]
[]
[]
[null,null,"CABLES STANDARDS - TORSADE"]
[null,null,"18/30kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[null,"Code  CA","PBG68163","PBG68165","PBG68167","PBG68169","PBG68170","PBG68171","PBG68769"]
[null,"Code SAP","NC",20034752,20034753,20035555,20193956,"NC",20034755]
[null,"Touret"]
["H","HBM",330,320,310,240,205,0,220]
["I","IBM",590,575,500,445,340,0,445]
["J","JFM2",835,705,690,555,435,345,555]
[]
[]
[]
[null,null,"DIMENSIONS TOURETS pour cables 18/30kV"]
[null,null,"Joues","Larg. Int.","Fût","Larg. Ext.","Trou d'axe","Tare","Charge utile","Rampe","Larg. Ext. + collerettes"]
[]
["Touret",null,"mm","mm"," mm"," mm ",null," kg"," kg",null," mm "]
["H","HBM",2200,960,1200,1112,82,435,5000,"NON"]
["I","IBM",2600,960,1200,1132,82,640,6000,"NON"]
["J","JFM2",3000,920,1400,1160,150,920,7000,80]

{"sheet":"lg_database_GC","index":12,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":true,"merged":[[35,2,35,9],[36,2,36,9],[47,2,47,9],[48,2,48,9],[26,7,27,7],[26,8,27,8],[26,9,28,9],[26,10,27,10],[0,2,0,9],[1,2,1,9],[12,2,12,9],[13,2,13,9],[25,2,25,9],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,28,6]]}
[null,null,"CABLES EDR"]
[null,null,"12/20kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[]
[]
[null,"Touret"]
["I",null,750,600,600,500,400,300,400]
["H",null,400,300,300,275,200,150,250]
["J",null,1000,875,875,650,600,425,600]
[]
[]
[]
[null,null,"CABLES STANDARDS - TORSADE"]
[null,null,"12/20kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[]
[]
[null,"Touret"]
["I",null,1100,800,800,620,525,375,620]
["H",null,675,530,530,390,300,250,390]
["J",null,1575,1230,1230,890,800,600,690]
[]
[]
[]
[]
[null,null,"DIMENSIONS TOURETS"]
[null,null,"Joues","Larg. Int.","Fût","Larg. Ext.","Trou d'axe","Tare","Charge utile","Rampe","Larg. Ext. + collerettes"]
[]
["Touret","Touret","mm","mm"," mm"," mm ",null," kg"," kg",null," mm "]
["H","H",2200," 960","1200 ",1140,82," 600",5000,"NON"]
["I","I",2600," 960"," 1200",1140,82," 800"," 6000","NON"]
["J","J",3000," 960"," 1200",1140,82," 850",6000,"NON"]
[]
[]
[]
[null,null,"CABLES EDR"]
[null,null,"18/30kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[]
[]
[null,"Touret"]
["H",null,0,250,200,175,175,125,175]
["I",null,0,400,375,350,275,275,350]
["J",null,0,650,600,550,475,400,550]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,null,"CABLES STANDARDS - TORSADE"]
[null,null,"18/30kV"]
["Touret",null,"3 x 1 x 50 ALU","3 x 1 x 95 ALU","3 x 1 x 150 ALU","3 x 1 x 240 ALU","3 x 1 x 300 ALU","3 x 1 x 400 ALU","3 x 1 x 240 CU"]
[]
[]
[null,"Touret"]
["H",null,0,400,375,275,250,200,275]
["I",null,0,650,600,475,375,350,475]
["J",null,0,1000,875,725,600,525,725]

{"sheet":"diametre_cable","index":13,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":true,"merged":[[11,0,11,9],[0,0,0,9],[22,0,22,9],[33,0,33,9]]}
["Cable disponible PRYSMIAN 12/20 kV"]
["Type","Nature","Nombre de cable","Diamètre total torsade (m)",null,null,"Type","Nature","Nombre de cable","Diamètre total torsade (m)"]
["EDR","3 x 1 x 50 ALU",3,7.2499999999999995E-2,null,null,"Standard","3 x 1 x 50 ALU",3,5.9700000000000003E-2]
["EDR","3 x 1 x 95 ALU",3,7.9500000000000001E-2,null,null,"Standard","3 x 1 x 95 ALU",3,6.6200000000000009E-2]
["EDR","3 x 1 x 150 ALU",3,8.1099999999999992E-2,null,null,"Standard","3 x 1 x 150 ALU",3,6.83E-2]
["EDR","3 x 1 x 240 ALU",3,9.11E-2,null,null,"Standard","3 x 1 x 240 ALU",3,7.8700000000000006E-2]
["EDR","3 x 1 x 240 CU",3,9.1200000000000003E-2,null,null,"Standard","3 x 1 x 240 CU",3,7.8700000000000006E-2]
["EDR","3 x 1 x 300 ALU",3,9.6849999999999992E-2,null,null,"Standard","3 x 1 x 300 ALU",3,8.3629999999999996E-2]
["EDR","3 x 1 x 400 ALU",3,0.10970000000000001,null,null,"Standard","3 x 1 x 400 ALU",3,9.4629999999999992E-2]
[]
[]
["Cable disponible PRYSMIAN 18/30 kV"]
["Type","Nature","Nombre de cable","Diamètre total torsade (m)",null,null,"Type","Nature","Nombre de cable","Diamètre total torsade (m)"]
["EDR","3 x 1 x 50 ALU",3,8.4699999999999998E-2,null,null,"Standard","3 x 1 x 50 ALU",3,7.1379999999999999E-2]
["EDR","3 x 1 x 95 ALU",3,8.7999999999999995E-2,null,null,"Standard","3 x 1 x 95 ALU",3,7.3900000000000007E-2]
["EDR","3 x 1 x 150 ALU",3,9.1200000000000003E-2,null,null,"Standard","3 x 1 x 150 ALU",3,7.7900000000000011E-2]
["EDR","3 x 1 x 240 ALU",3,9.8900000000000002E-2,null,null,"Standard","3 x 1 x 240 ALU",3,8.5510000000000003E-2]
["EDR","3 x 1 x 300 ALU",3,0.1055,null,null,"Standard","3 x 1 x 300 ALU",3,9.2200000000000004E-2]
["EDR","3 x 1 x 400 ALU",3,0.115,null,null,"Standard","3 x 1 x 400 ALU",3,0.10199999999999999]
["EDR","3 x 1 x 240 CU",3,9.9000000000000005E-2,null,null,"Standard","3 x 1 x 240 CU",3,8.5999999999999993E-2]
[]
[]
["Cable disponible GC 12/20 kV"]
["Type","Nature","Nombre de cable","Diamètre total torsade (m)",null,null,"Type","Nature","Nombre de cable","Diamètre total torsade (m)"]
["EDR","3 x 1 x 50 ALU",3,7.0000000000000007E-2,null,null,"Standard","3 x 1 x 50 ALU",3,5.8999999999999997E-2]
["EDR","3 x 1 x 95 ALU",3,7.6999999999999999E-2,null,null,"Standard","3 x 1 x 95 ALU",3,6.6000000000000003E-2]
["EDR","3 x 1 x 150 ALU",3,7.8E-2,null,null,"Standard","3 x 1 x 150 ALU",3,6.7000000000000004E-2]
["EDR","3 x 1 x 240 ALU",3,8.5999999999999993E-2,null,null,"Standard","3 x 1 x 240 ALU",3,7.4999999999999997E-2]
["EDR","3 x 1 x 240 CU",3,9.0999999999999998E-2,null,null,"Standard","3 x 1 x 240 CU",3,0.08]
["EDR","3 x 1 x 300 ALU",3,0.10100000000000001,null,null,"Standard","3 x 1 x 300 ALU",3,0.09]
["EDR","3 x 1 x 400 ALU",3,8.6999999999999994E-2,null,null,"Standard","3 x 1 x 400 ALU",3,7.9000000000000001E-2]
[]
[]
["Cable disponible GC 18/30 kV"]
["Type","Nature","Nombre de cable","Diamètre total (cable ou torsade) (m)",null,null,"Type","Nature","Nombre de cable","Diamètre total (cable ou torsade) (m)"]
["EDR","3 x 1 x 50 ALU",3,0.08,null,null,"Standard","3 x 1 x 50 ALU",3,6.9000000000000006E-2]
["EDR","3 x 1 x 95 ALU",3,8.4000000000000005E-2,null,null,"Standard","3 x 1 x 95 ALU",3,7.2999999999999995E-2]
["EDR","3 x 1 x 150 ALU",3,8.6999999999999994E-2,null,null,"Standard","3 x 1 x 150 ALU",3,7.5999999999999998E-2]
["EDR","3 x 1 x 240 ALU",3,9.2999999999999999E-2,null,null,"Standard","3 x 1 x 240 ALU",3,8.2000000000000003E-2]
["EDR","3 x 1 x 300 ALU",3,9.8000000000000004E-2,null,null,"Standard","3 x 1 x 300 ALU",3,8.6999999999999994E-2]
["EDR","3 x 1 x 400 ALU",3,0.106,null,null,"Standard","3 x 1 x 400 ALU",3,9.5000000000000001E-2]
["EDR","3 x 1 x 240 CU",3,9.4E-2,null,null,"Standard","3 x 1 x 240 CU",3,8.3000000000000004E-2]