{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["BD","Home","Listes","Accueil","Projet","Calepinage","Dessin","Bon de commande"],"not_rendered":{"charts":0,"images":102,"macros":1,"external_links":0,"defined_names":114,"comments":1,"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":"BD","index":0,"n_rows":187,"n_cols":18,"rows_kept":187,"cut":false,"hidden":true,"merged":[]}
["Variable","Français","English","Deutsch",null,null,"Références","Traduction","version","couleur","intitulé","anglais","allemand","Références Nav",null,"paysage"]
["HomeT1","BIENVENUE DANS L'OUTIL DE DIMENSIONNEMENT ET COMMANDE ","WELCOME TO THE SIZING AND CONTROL TOOL ","WILLKOMMEN BEIM AUSLEGUNGS- UND BESTELLTOOL ",null,null,"COINDALUATEC ","AberFaitDATEC","v.TS-1","ALU","Abergement Angle DROIT Gris-v.TS-1","Top RIGHT Angle Flashing Grey-v.TS-1","Winkelverblechung rechts v.TS-1 ALU","ART101379",null,"1559 / 1046","ART100401",34.15]
["HomeT2","DU GSE INTEGRATION IN-ROOF SYSTEM","OF GSE INTEGRATION IN-ROOF SYSTEM","FÜR DAS GSE INTEGRATION IN-ROOF SYSTEM",null,null,"COINDNOIRATEC ","AberFaitDATEC","v.TS-1","NOIR","Abergement Angle DROIT Noir-v.TS-1","Top RIGHT Angle Flashing Black-v.TS-1","Winkelverblechung rechts v.TS-1 Schwarz","ART101295",null,"1575 / 1082","ART100048",34.15]
["HomeT3","Vous trouverez à travers cette application l'outil qui vous permettra de calculer et de dimensionner vos commandes","You will find through this application the tool that will allow you to calculate and size your orders","Mit dieser Anwendung erhalten Sie ein Werkzeug, das es Ihnen erlaubt, Ihre Aufträge auszulegen und zu berechnen.",null,null,"ANGL_COIN_DROIT_AR ","AberFaitDATEC","v.A-1","Noir","Abergement Angle DROIT Noir-v.A-1","Top RIGHT Angle Flashing Black-v.A-1","Winkelverblechung rechts v.A-1 Schwarz","ART100195",null,"1580 / 808","ART100713",26]
["Dim","Dimensionner","Size","Auslegen",null,null,"COINGALUATEC ","AberFaitGATEC","v.TS-1","ALU","Abergement Angle GAUCHE Gris-v.TS-1","Top LEFT Angle Flashing Grey-v.TS-1","Winkelverblechung links v.TS-1 ALU","ART100785",null,"1640 / 992","ART100356",34.15]
["RefCmpPV","Référence du projet","Project reference","Projekt-Modulfeldreferenz",null,null,"COINGNOIRATEC ","AberFaitGATEC","v.TS-1","NOIR","Abergement Angle GAUCHE Noir-v.TS-1","Top LEFT Angle Flashing Black-v.TS-1","Winkelverblechung links v.TS-1 Schwarz","ART100285",null,"1650 / 992","ART101488",34.15]
["DimToit","Caractéristiques du toit","Roof Dimensions","Dachabmessungen",null,null,"ANGL_COIN_GAUCH_AR ","AberFaitGATEC","v.A-1","Noir","Abergement Angle GAUCHE Noir-v.A-1","Top LEFT Angle Flashing Black-v.A-1","Winkelverblechung links v.A-1 Schwarz","ART101291",null,"1660 / 992","ART101502",34.15]
["Calepinage","Calepinage","Layout","Lattenplan",null,null,"AFSA2013","AberFaitCATEC","LG 1.50 m","ALU","Abergement Haut Central Universel Gris L 1500mm","Universal Top Centre Flashing - Grey L 1500mm ","First-Hauptverblechung  LG 1.50 m ALU","ART100695",null,"1670 / 992","ART101266",34.15]
["DimMod","Caractéristiques du module","Module Dimensions","Modulabmessungen",null,null,"AFCUNL1500","AberFaitCATEC","LG 1.50 m","NOIR","Abergement Haut Central Universel Noir L 1500mm","Universal Top Centre Flashing - Black L 1500mm ","First-Hauptverblechung  LG 1.50 m Schwarz","ART101041 ",null,"1675 / 992 P33","ART100675",34.15]
["Long","Longueur (L)","Length (L)","Länge (L)",null,null,"COINDALU2014_15","AberFaitD",null,"ALU","Abergement Angle Haut Droit Universel Gris ","Top Right Corner Flashing - Grey","Eckverblechung rechts ALU","ART101340",null,"1680 / 992","ART100761",34.15]
["Ramp","Rampant (R)","Roof Width (R)","Länge der Dachschräge (R)",null,null,"COINDNOIR2014_15","AberFaitD",null,"NOIR","Abergement Angle Haut Droit Universel Noir ","Top Right Corner Flashing - Black","Eckverblechung rechts Schwarz","ART100574",null,"1686 / 1016","ART100252",34.15]
["Haut","Hauteur (H)","Height (H)","Höhe (H)",null,null,"COINGALU2014_15","AberFaitG",null,"ALU","Abergement Angle Haut Gauche Universel Gris ","Top Left Corner Flashing - Grey","Eckverblechung links ALU","ART100862",null,"1700 / 1016","ART100092",34.15]
["Larg","Largeur (W)","House Width (W)","Breite (W)",null,null,"COINGNOIR2014_15","AberFaitG",null,"NOIR","Abergement Angle Haut Gauche Universel Noir ","Top Left Corner Flashing - Black","Eckverblechung links Schwarz","ART100945",null,"1665 / 1020","ART102153",34.15]
["Epai","Epaisseur (E)","Thickness (E)","Dicke (E)",null,null,"AFJA2013","AberFaitJonc",null,"ALU","Abergement Haut Jonction Universel Gris L 375mm  ","Top Junction Flashing - Grey L 375mm","Verbindungsblech Firstverblechung ALU","ART100558",null,"1675 / 1020","ART102160",34.15]
["CalPort","Calepinage portrait","Portrait Layout","Lattenplan für hochkant-Montage",null,null,"AFJUNL375","AberFaitJonc",null,"NOIR","Abergement Haut Jonction Universel Noir L 375mm  ","Top Junction Flashing - Black L 375mm","Verbindungsblech Firstverblechung Schwarz","ART100039",null,"1680 / 1020","ART102167",34.15]
["CalPays","Calepinage paysage","Landscape Layout","Lattenplan für Querformat-Montage",null,null,"ABER_HAUT_ATEC_ALU ","AberFaitC","v.TS-1","ALU","Abergement haut Gris 1001-v.TS-1","Top Centre Flashing Grey 1001-v.TS-1 ","First-Hauptverblechung  1001-v.TS-1 ALU","ART100441",null,"1685 / 1020","ART102174",34.15]
["CorPlakGSE","Plaque GSE correspondante","Corresponding GSE Frame","Entsprechende GSE-Wanne",null,null,"ABER_HAUT_ATEC_NOI ","AberFaitC","v.TS-1","NOIR","Abergement haut Noir 1001-v.TS-1","Top Centre Flashing Black 1001-v.TS-1 ","First-Hauptverblechung  1001-v.TS-1 Schwarz","ART100557",null,"1690 / 1020","ART102181",34.15]
["FeatCmpPV","Composants du kit","Kit components","Eigenschaften der Installation des Modulfeldes",null,null,"AB_HAUT_1001_VA1 ","AberFaitC","v.A-1","NOIR","Abergement haut 1001-v.A-1","Top Centre Flashing 1001-v.A-1 ","First-Hauptverblechung  1001-v.A-1 ATEC Schiefer","ART101014",null,"1695 / 1020",null,34.15]
["TypeCov","Type de couverture","Roof covering","Art der Dachbedeckung",null,null,"AB_HAUT_1046_VA1 ","AberFaitC","v.A-1","NOIR","Abergement haut 1046-v.A-1","Top Centre Flashing 1046-v.A-1 ","First-Hauptverblechung  1046-v.A-1 ATEC Schiefer","ART101567",null,"1700 / 1020","ART102188",34.15]
["Ardoise","Ardoise","Slate","Schiefer",null,null,"AB_HAUT_992_VA1 ","AberFaitC","v.A-1","NOIR","Abergement haut 992-v.A-1","Top Centre Flashing 992-v.A-1 ","First-Hauptverblechung  992-v.A-1 ATEC Schiefer","ART100820",null,"1705 / 1020",null,34.15]
["TuileC","Tuile à fort galbe","Curved Tiles","Kanalziegel",null,null,"AB_HAUT_SPEC_ALU","AberFaitC","v.TS-1","ALU","Abergement Faîtage central zzz ALU","Top Centre Flashing zzz ALU","First-Hauptverblechung zzz ALU",null,null,"1720 / 1020",null,34.15]
["Tuile","Tuile plate","Flat tiles","Ziegel",null,null,"AB_HAUT_SPEC_NOIR","AberFaitC","v.TS-1","NOIR","Abergement Faîtage central zzz NOIR","Top Centre Flashing zzz BLACK","First-Hauptverblechung zzz Schwarz",null,null,"1740 / 1020","ART102195",34.15]
["PlaqueN","Plaque nervurée","Trapezoidal sheet","Trapezblech",null,null,"RACC_ABER_HAUT_ARD ","AberFaitJonc","v.A-1","NOIR","Jonction haute Noir-v.A-1","Junction for Top Flashing Black-v.A-1","Verbindungsblech Firstverblechung v.A-1 Schwarz","ART100110",null,"portrait"]
["TuileM","Tuile mécanique","Interlocking tile","Falzziegel",null,null,"ALAALUDROITATEC ","AberLatATEC","v.TS-1","ALU","Abergement latéral DROIT Gris-v.TS-1","RIGHT Lateral Flashing Grey-v.TS-1 ","Seitliche Verblechung Rechts  v.TS-1 ALU","ART100079",null,"1559 / 1046","ART100826",34.15]
["PlaqueO","Plaque ondulée","Corrugated sheet","Wellblech",null,null,"ALABLKDROITATEC ","AberLatATEC","v.TS-1","NOIR","Abergement latéral DROIT Noir-v.TS-1","RIGHT Lateral Flashing Black-v.TS-1 ","Seitliche Verblechung Rechts v.TS-1 Black","ART100973",null,"1575 / 1053","ART101493",34.15]
["InclT","Inclinaison (α)","Roof Slope (α)","Dachneigung (α)",null,null,"ABER_LAT_DROIT_ARD ","AberLatATEC","v.A-1","NOIR","Abergement latéral DROIT Noir-v.A-1","RIGHT Lateral Flashing Black-v.A-1","Seitliche Verblechung Rechts v.A-1 Black","ART100429",null,"1575 / 1082","ART101465",34.15]
["RacFait","Raccord haut","Top connection","Firstanbindung",null,null,"ALAALUGAUCHEATEC ","AberLatATEC","v.TS-1","ALU","Abergement latéral GAUCHE Gris-v.TS-1","LEFT Lateral Flashing Grey-v.TS-1 ","Seitliche Verblechung Links  v.TS-1 ALU","ART100057",null,"1580 / 808","ART100450",26]
["None1","Aucun","None","Keine",null,null,"ALABLKGAUCHEATEC ","AberLatATEC","v.TS-1","NOIR","Abergement latéral GAUCHE Noir-v.TS-1","LEFT Lateral Flashing Black-v.TS-1 ","Seitliche Verblechung Links v.TS-1 Black","ART101030",null,"1640 / 992","ART100220",34.15]
["AberFait","Abergement","Flashing","Firstverblechung",null,null,"ABER_LAT_GAUCH_AR ","AberLatATEC","v.A-1","NOIR","Abergement latéral GAUCHE Noir-v.A-1","LEFT Lateral Flashing Black-v.A-1","Seitliche Verblechung Links v.A-1 Black","ART100568",null,"1640 / 1001","ART100700",34.15]
["RacEgout","Raccord bas","Eaves connection ","Dichtigkeitsanbindung traufeseitig",null,null,"ALUAP30TUILBRUTRE3","AberLatUniv","P30","ALU","Abergement Latéral Universel P30 Tuile Gris  ","Lateral Flashing P30 - Grey","Seitliche Verblechung Universal P30 ALU","ART100703",null,"1640 / 1001 P33","ART100230",34.15]
["PowerMod","Puissance","Module Power","Modulleistung",null,null,"ALUNP30TUILNOIRRE3","AberLatUniv","P30","NOIR","Abergement Latéral Universel P30 Tuile Noir","Lateral Flashing P30 - Black","Seitliche Verblechung Universal P30 Schwarz","ART100927",null,"1686 / 1016","ART100702",34.15]
["AberLat","Raccord latéral","Lateral connection","Seitliche Verblechung",null,null,"ALUA","AberLatUniv",null,"ALU","Abergement Latéral Universel Gris ","Lateral Flashing - Grey","Seitliche Verblechung Universal ALU","ART100673",null,"1710 / 1000","ART102265",34.15]
["NbrEtrier","Nombre d'étriers","Number of Clamps","Anzahl Klemmen",null,null,"ALUN","AberLatUniv",null,"NOIR","Abergement Latéral Universel Noir","Lateral Flashing - Black","Seitliche Verblechung Universal Schwarz","ART100494",null,"1710 / 1005","ART102272",34.15]
["LargRooflex","Largeur FLEXALU","FLEXALU Width","Breite FLEXALU",null,null,"CORNIERELAQUEB","Corniere",null,"NOIR","Abergement Haut Cornière Laquée Noire L1400mm (pour la fixation des abergements centraux)","Top Corner Piece Flashing - Black L1400mm (To Join Module to Top Centre Flashings) ","Verbindungsstück (zur Befestigung der zentralen Verblechung) Schwarz","ART101409",null,"1710 / 1010",null,34.15]
["Noir","Noir","Black","Schwarz",null,null,"CORNIERE","Corniere",null,"ALU","Abergement Haut Cornière Grise L1400mm (pour la fixation des abergements centraux)","Top Corner Piece Flashing - Grey L1400mm (To Join Module to Top Centre Flashings) ","Verbindungsstück (zur Befestigung der zentralen Verblechung) ALU","ART100867",null,"1710 / 1020","ART102279",34.15]
["Rouge","Rouge","Red","Rot",null,null,"CROCHET","Crochet",null,null,"Crochet de Fixation d'Abergement In Roof","GSE Flashing Hook","Hafte zur Befestigung der Verblechung","ART100633",null,"1710 / 1025","ART102286",34.15]
["RoofDisplay","Afficher le toit","View the Roof","Dach anzeigen",null,"EtrDblH16ALU","EDH162014ALU (ASV09-35G)","EtrDbl","H16","ALU","Etrier Double H16 - Acier Inox - Gris - In Roof","Double Clamp H16 - Steel - Grey - In Roof ","Verstärkte Mittel-Klemme H16","ART100045",null,"1710 / 1030","ART102293",34.15]
["HomeBt","Accueil","Home","Startseite",null,"EtrDblH16NOIR","EDH162014N (ASV09-35V)","EtrDbl","H16","NOIR","Etrier Double H16 - Acier Inox - Noir - In Roof ","Double Clamp H16 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H16 Schwarz","ART100482",null,"1710 / 1040","ART103174",34.15]
["CalInstr","Colorier le toit (surface encadrée ci-dessous) à l'aide de la souris, en selectionnant les cellules/cases correspondant aux modules, pour créer le champ PV souhaité.","Color the roof (framed surface below) using the mouse, by selecting the cells / boxes corresponding to the modules, to create the desired PV Plant.","das Dach (untenstehende, gerahmte Fläche) mit Hilfe der Maus markieren und über das Auswählen der einzelnen Zellen das entsprechende PV-Modulfeld erstellen",null,"EtrDblH19ALU","EDH192014ALU (ASV-38G)","EtrDbl","H19","ALU","Etrier Double H19 - Acier Inox - Gris - In Roof ","Double Clamp H19 - Steel - Grey - In Roof  ","Verstärkte Mittel-Klemme H19","ART100171",null,"1710 / 1050","ART102300",34.15]
["NbrRows","Nombres de lignes","Number of Lines","Anzahl der Zeilen",null,"EtrDblH19NOIR","EDH192014N (ASV-38V)","EtrDbl","H19","NOIR","Etrier Double H19 - Acier Inox - Noir - In Roof ","Double Clamp H19 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H19 Schwarz","ART100548",null,"1710 / 1060","ART102307",34.15]
["NbrCol","Nombres de colonnes","Number of Columns","Anzahl der Spalten",null,"EtrDblH21ALU","EDH212014ALU (ASV09-40G)","EtrDbl","H21","ALU","Etrier Double H21 - Acier Inox - Gris - In Roof ","Double Clamp H21 - Steel - Grey - In Roof  ","Verstärkte Mittel-Klemme H21","ART100597"]
["NbrMod","Nombres modules","Number of Modules","Anzahl der Module",null,"EtrDblH21NOIR","EDH212014N (ASV09-40V)","EtrDbl","H21","NOIR","Etrier Double H21 - Acier Inox - Noir - In Roof ","Double Clamp H21 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H21 Schwarz","ART100744"]
["Ernergy","Energie","Energy","Energie",null,"EtrDblH23ALU","EDH232014ALU (ASV09-42G)","EtrDbl","H23","ALU","Etrier Double H23 - Acier Inox - Gris - In Roof ","Double Clamp H23 - Steel - Grey - In Roof  ","Verstärkte Mittel-Klemme H23","ART101192"]
["ResetCPV","Effacer champ PV","Erase PV Array","Modulfeld löschen",null,"EtrDblH23NOIR","EDH232014N (ASV9-42V)","EtrDbl","H23","NOIR","Etrier Double H23 - Acier Inox - Noir - In Roof ","Double Clamp H23 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H23 Schwarz","ART100658"]
["Purchase","Devis","Cost Estimate","Zitat",null,"EtrDblH26ALU","EDH262014ALU (ASV09-46G)","EtrDbl","H26","ALU","Etrier Double H26 - Acier Inox - Gris - In Roof ","Double Clamp H26 - Steel - Grey - In Roof  ","Verstärkte Mittel-Klemme H26","ART102202"]
["NbrPiece","Nombre de pièces","Number of Pieces","Menge pro Artikel",null,"EtrDblH26NOIR","EDH262014N (ASV09-46V)","EtrDbl","H26","NOIR","Etrier Double H26 - Acier Inox - Noir - In Roof ","Double Clamp H26 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H26 Schwarz","ART102335"]
["PlakGSEPays","Plaques GSE Paysage","GSE Frames Landscape","GSE-Wanne Querformat",null,"EtrDblH27ALU","EDH272014ALU (ASV09-46G)","EtrDbl","H27","ALU","Etrier Double H27 - Acier Inox - Gris - In Roof ","Double Clamp H27 - Steel - Grey - In Roof  ","Verstärkte Mittel-Klemme H27","ART100006"]
["PlakGSEPort","Plaques GSE Portrait","GSE Frames Portrait","GSE-Wanne Hochkant",null,"EtrDblH27NOIR","EDH272014N (ASV09-46V)","EtrDbl","H27","NOIR","Etrier Double H27 - Acier Inox - Noir - In Roof ","Double Clamp H27 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H27 Schwarz","ART100242"]
["AberLatUniv","Abergement latéral Universel","Universal Lateral Flashing","Seitliche Verblechung Universal",null,"EtrDblH31ALU","EDH312014ALU (ASV09-50G)","EtrDbl","H31","ALU","Etrier Double H31 - Acier Inox - Gris - In Roof ","Double Clamp H31 - Steel - Grey - In Roof  ","Verstärkte Mittel-Klemme H31","ART101326"]
["AberLatATEC","Abergement latéral","Lateral Flashing","Seitliche Verblechung",null,"EtrDblH31NOIR","EDH312014N (ASV09-50V)","EtrDbl","H31","NOIR","Etrier Double H31 - Acier Inox - Noir - In Roof ","Double Clamp H31 - Steel - Black - In Roof ","Verstärkte Mittel-Klemme H31 Schwarz","ART101288"]
["AberFaitD","Abergement Faîtage Droit","Top Right Corner Flashing","Eckverblechung rechts",null,"EtrSplH16ALU","ESH162014ALU (ASV08-35G)","EtrSpl","H16","ALU","Etrier Simple H16 - Acier Inox - Gris - In Roof ","Simple Clamp H16 - Steel - Grey - In Roof  ","Verstärkte Rand-Klemme H16","ART100376"]
["AberFaitG","Abergement Faîtage Gauche","Top Left Corner Flashing","Eckverblechung links",null,"EtrSplH16NOIR","ESH162014N (ASV08-35V)","EtrSpl","H16","NOIR","Etrier Simple H16 - Acier Inox - Noir - In Roof ","Simple Clamp H16 - Steel - Black - In Roof ","Verstärkte Rand-Klemme H16 Schwarz","ART100814"]
["AberFaitDATEC","Abergement Angle Droit","Top Right Angle Flashing","Winkelverblechung rechts",null,"EtrSplH16ALU","ESH162014ALU","EtrSpl","H16","ALU","Etrier Simple H16 - Acier Inox - Gris - In Roof ","Simple Clamp H16 - Steel - Grey - In Roof  ","Verstärkte Rand-Klemme H16","ART100376"]
["AberFaitGATEC","Abergement Angle Gauche","Top Left Angle Flashing","Winkelverblechung links",null,"EtrSplH16NOIR","ESH162014N","EtrSpl","H16","NOIR","Etrier Simple H16 - Acier Inox - Noir - In Roof ","Simple Clamp H16 - Steel - Black - In Roof ","Verstärkte Rand-Klemme H16 Schwarz","ART100814"]
["AberFaitC","Abergement Faîtage central","Top Centre Flashing","First-Hauptverblechung",null,"EtrSplH19ALU","ESH192014ALU (ASV08-38G)","EtrSpl","H19","ALU","Etrier Simple H19 - Acier Inox - Gris - In Roof ","Simple Clamp H19 - Steel - Grey - In Roof ","Verstärkte Rand-Klemme H19","ART101152"]
["AberFaitCATEC","Abergement Faîtage","Centre Flashing","First-Hauptverblechung",null,"EtrSplH19NOIR","ESH192014N (ASV08-38V)","EtrSpl","H19","NOIR","Etrier Simple H19 - Acier Inox - Noir - In Roof","Simple Clamp H19 - Steel - Black - In Roof ","Verstärkte Rand-Klemme H19 Schwarz","ART101299"]
["SelecATECModmsg1","Aucun module ATEC n'a été sélectionné.","No ATEC module has been selected.","Es wurde kein ATEC-Modul ausgewählt.",null,"EtrSplH21ALU","ESH212014ALU (ASV08-40G)","EtrSpl","H21","ALU","Etrier Simple H21 - Acier Inox - Gris - In Roof ","Simple Clamp H21 - Steel - Grey - In Roof ","Verstärkte Rand-Klemme H21","ART101279"]
["Corniere","Corniere ( pour Faîtage central)","Corner Piece (To Join Module to Top Centre Flashings)","Verbindungsstück (zur Befestigung der zentralen Verblechung)",null,"EtrSplH21NOIR","ESH212014N (ASV08-40V)","EtrSpl","H21","NOIR","Etrier Simple H21 - Acier Inox - Noir - In Roof ","Simple Clamp H21 - Steel - Black - In Roof  ","Verstärkte Rand-Klemme H21 Schwarz","ART100495"]
["Rivets","Rivets Pop (4 rivets de fixation par corniere de faîtage)","Pop Rivet (4-Fixations Rivet for Top Centre Flashing)","Pop-Niete (Halter für Verbindungsstücke)",null,"EtrSplH23ALU","ESH232014ALU (ASV08-42G)","EtrSpl","H23","ALU","Etrier Simple H23 - Acier Inox - Gris - In Roof ","Simple Clamp H23 - Steel - Grey - In Roof  ","Verstärkte Rand-Klemme H23","ART101215"]
["VisRondP","Vis + rondelle (6 par plaque) ALU","Selt-Trapping Screw + GSE Washer Silver ( 6 per Frame)","Schraube + GSE Unterlegscheibe (6 pro Platte) ALU",null,"EtrSplH23NOIR","ESH232014N (ASV08-42V)","EtrSpl","H23","NOIR","Etrier Simple H23 - Acier Inox - Noir - In Roof ","Simple Clamp H23 - Steel - Black- In Roof ","Verstärkte Rand-Klemme H23 Schwarz","ART101230"]
["VisRondE","Vis + rondelle pour fixation des étriers","Selt-Trapping Screw + GSE Washer Black to fix Clamp","Schraube + Unterlegscheibe zur Befestigung der Modulklemme",null,"EtrSplH26ALU","ESH262014ALU (ASV08-46G)","EtrSpl","H26","ALU","Etrier Simple H26 - Acier Inox - Gris - In Roof ","Simple Clamp H26 - Steel - Grey - In Roof  ","Verstärkte Rand-Klemme H26","ART102321"]
["Joints","Joints EPDM Cellulaire ","Cale EPDM Cell","EPDM-Dichtung CELL klebend",null,"EtrSplH26NOIR","ESH262014N (ASV08-46V)","EtrSpl","H26","NOIR","Etrier Simple H26 - Acier Inox - Noir - In Roof ","Simple Clamp H26 - Steel - Black - In Roof ","Verstärkte Rand-Klemme H26 Schwarz","ART102328"]
["EtrDbl","Etrier Double Renforcé","Reinforced Double Clamp","Verstärkte Mittel-Klemme",null,"EtrSplH27ALU","ESH272014ALU (ASV08-46G)","EtrSpl","H27","ALU","Etrier Simple H27 - Acier Inox - Gris - In Roof ","Simple Clamp H27 - Steel - Grey - In Roof ","Verstärkte Rand-Klemme H27","ART100063"]
["EtrSpl","Etrier Simple renforcé","Reinforced Single Clamp","Verstärkte Rand-Klemme",null,"EtrSplH27NOIR","ESH272014N (ASV08-46V)","EtrSpl","H27","NOIR","Etrier Simple H27 - Acier Inox - Noir - In Roof","Simple Clamp H27 - Steel - Black - In Roof ","Verstärkte Rand-Klemme H27 Schwarz","ART100260"]
["Grappe","Grappe de 4 Cales de renfort G et D pour étriers simples","Batch of 4 Reinforcement GSE Wedges L and R for Single Clamps","Cluster von 4 Randverstärkungen L und R für Rand-Klemme",null,"EtrSplH31ALU","ESH312014ALU (ASV08-50G)","EtrSpl","H31","ALU","Etrier Simple H31 - Acier Inox - Gris - In Roof ","Simple Clamp H31 - Steel - Grey - In Roof ","Verstärkte Rand-Klemme H31","ART100172"]
["Crochet","Crochets fixation abergements","GSE Flashing Hook","Hafte zur Befestigung der Verblechung",null,"EtrSplH31NOIR","ESH312014N (ASV08-50V)","EtrSpl","H31","NOIR","Etrier Simple H31 - Acier Inox - Noir - In Roof","Simple Clamp H31 - Steel - Black - In Roof ","Verstärkte Rand-Klemme H31 Schwarz","ART100381"]
["Option","Options","Options","Optionen",null,null,"CALE_GAUCHE / CALE_DROIT","Grappe",null,null,"Grappe de 4 Cales de renfort G et D pour étriers simples  ","Batch of 4 Reinforcement GSE Wedges L and R for Single Clamps","Cluster von 4 Randverstärkungen L und R für Rand-Klemme"]
["Rooflex","Bande d'étanchéité FLEXALU (Rouleau de 5 m)","FLEXALU Waterproofing Strip (5 m roll)","FLEXALU Dichtungband (5 m-Rolle)",null,null,"JOINT_PRE_CONTRAIN","JointImpr",null,null,"Joint pré-contraint - 20 x 40 mm (Rouleau de 5.5 m)  ","Pre-Compressed Seal - 20 x 40mm 5.5m (roll)","Vorkomprimiertes Dichtungsband - 20 x 40 mm (5.5 m-Rolle)","ART101088"]
["EcranToit","Ecran de sous toiture (Rouleau de 75 m²)","Roof-Underlay Screen (75 m² roll)","Unterspannbahn (75 m²-Rolle)",null,null,"JOINT_MOUSS_TRIAN ","JointTrImpr",null,null,"Joint mousse triangulaire TN2F 40X60 ADH LONG 2ML","Triangular Pre-Compressed Seal Roll - 40 x 60 mm (2 m roll)","Dreieckig vorkomprimiertes Dichtungsband - 40 x 60 mm (5.5 m-Rolle)"]
["JointImpr","Joint pré-contraint - 20 x 40 mm (Rouleau de 5.5 m)","Pre-Compressed Seal Roll - 20 x 40 mm (5.5 m roll)","Vorkomprimiertes Dichtungsband - 20 x 40 mm (5.5 m-Rolle)",null,null,"CALE_EPDM_CELL",null,null,null,"Cale EPDM Pour Vis In Roof (25x21 EP. 5mm)","EPDM Cell for Screw - In Roof (25x21 EP. 5mm)","EPDM-Dichtung CELL klebend","ART101138"]
["JointTrImpr","Joint pré-contraint triangulaire - 40 x 60 mm (Rouleau de 5.5 m)","Triangular Pre-Compressed Seal Roll - 40 x 60 mm (5.5 m roll)","Dreieckig vorkomprimiertes Dichtungsband - 40 x 60 mm (5.5 m-Rolle)",null,null,"PPAYS 1640 / 992","PlakGSEPays",null,null,"Plaques Paysage ","GSE Landscape Frame ","GSE-Wanne Querformat "]
["DimChamp","Taille du champ PV","Size of the PV Plant","Größe des Modulfeldes",null,null,"PPORT 1640 / 992","PlakGSEPort",null,null,"Plaques Portrait ","GSE Portrait Frame ","GSE-Wanne Hochkant "]
["HautCmpARE","Hauteur (avec FLEXALU en partie basse)","Height (with Low FLEXALU)","Höhe (mit FLEXALU an der Unterseite)",null,null,"RIVETPOP","Rivets",null,null,"Rivets Pop 4x8 (pour la fixation des cornières)","Pop Rivet 4x8 (Fixations Rivet for Top Centre Flashing)","Pop-Niete (Halter für Verbindungsstücke)","ART100389"]
["LargCmpAAL","Largeur (avec abergements latéraux)","Width (with Lateral Flashing)","Breite (mit seitlicher Verblechung)",null,null,"VIS2014A","VisRondP",null,"ALU","Vis GSE Integration 6.3mmx60mm Alu","GSE Integration Screw - 6.3mmx60mm - Grey","Schraube + GSE Unterlegscheibe (6 pro Platte) ALU","ART100931"]
["Coord","Coordonnées","Contact Details","Kontaktdaten",null,null,"VIS2014N","VisRondE",null,"NOIR","Vis GSE Integration 6.3mmx60mm Noir","GSE Integration Screw - 6.3mmx60mm - Black","Schraube + Unterlegscheibe zur Befestigung der Modulklemme","ART101552"]
["DateExp","Date de livraison souhaitée","Desired Delivery Date","Gewünschtes Versanddatum",null,null,"BANDE_FLEXALU_330","Rooflex",null,"NOIR","Flexalu Gris Ardoise 330mm L5m Butyle 20/100","Flexalu Waterproof Strip Black 330mm (5 m roll)","FLEXALU Dichtungband (5 m-Rolle) Schwarz 330mm","ART100385"]
["Adr","Adresse / Contact","Address / Contact","Adresse / Kontakt",null,null,"BANDE_FLEXALU_500","Rooflex",null,"NOIR","Flexalu Gris Ardoise 500mm L5m Butyle 20/100","Flexalu Waterproof Strip Black 500mm (5 m roll)","FLEXALU Dichtungband (5 m-Rolle) Schwarz 500mm","ART101405"]
["ScrolTitle","(Dimensions : Toit, Module PV & Plaque GSE)","(Dimensions: Roof, PV Module & GSE Frame)","(Größe: Dach, PV-Modul & GSE-Wanne)",null,null,"BANDE_FLEXALU-500","Rooflex",null,"ROUGE","Flexalu Rouge Terre Cuite 500mm L5m Butyle 20/100","Flexalu Waterproof Strip Red 500mm (5 m roll)","FLEXALU Dichtungband (5 m-Rolle) Rot 500mm","ART101272"]
["Toit","Toit","Roof","Dach",null,null,"ECRAN_SOUS_TOITURE ","EcranToit",null,null,"Ecran de sous toiture (Rouleau de 75 m²)  ","Roof-Underlay Screen (75 m² roll)","Unterspannbahn (75 m²-Rolle)","ART101292"]
["ModPV","Module PV","PV Module","PV-Modul",null,null,"CALE_GAUCHE",null,null,null,"Cale Gauche de Renfort pour Etriers Simple In Roof","Left Wedge for Simple Clamp - In Roof","Linker Verstärkungskeile für Rand-Klemme","ART100212"]
["Adj","Ajustement","Adjustment","Anpassung",null,null,"CALE_DROIT",null,null,null,"Cale Droite de Renfort pour Etriers Simple In Roof","Right Wedge for Simple Clamp - In Roof","Rechte Verstärkungskeile für Rand-Klemme","ART101501"]
["PlakGSE","Plaque GSE","GSE frame","GSE-Wanne"]
["Ref","Références","References","Referenzen"]
["Den","Dénomination","Denomination","Bezeichnung"]
["CalcRampTitle","Calculer le Rampant du toit","Calculate the Roof Width","Berechnung der Länge der Dachschräge"]
["LargMsn","Largeur de la maison (m)","Width of the house (m)","Breite des Hauses (m)"]
["NbrPans","Nombre de Pans","Number of Pans","Anzahl der Dachschrägen"]
["Calculer","Calculer","Compute","Berechnen"]
["Annuler","Annuler","Cancel","Abbrechen"]
["CalcRampMsg1","Les champs suivants doivent contenir une valeur numérique positive non nulle: 'Inclinaison toiture' et 'Largeur de la maison'.","\nThe following fields must contain a non-zero positive numeric value: 'Roof Slope' and 'Width of the House'.\n","Die folgenden Felder müssen einen positiven numerischen Wert ungleich Null enthalten: Dachneigung und Breite des Hauses."]
["CalcRampMsg2","Veuillez vérifier les valeurs de ces champs puis lancez de nouveau le calcul du Rampant.","Please check the values ​​of these fields then run the Roof Width calculation again.","Bitte überprüfen Sie die Werte dieser Felder und führen Sie die Berechnung der Länge der Dachschräge erneut aus."]
["DftRefCmpPV","Champ PV 1","PV Array 1","PV-Modulfeld 1"]
["CalcRampLink","Cliquez ici pour calculer le Rampant !","Click here to calculate the Roof Width !","Klicken Sie hier, um die Länge der Dachschräge zu berechnen !"]
["None2","Aucune","None","keine Angabe"]
["ColorAber","Couleur","Color","Farbe"]
["Yes","Oui","Yes","Ja"]
["No","Non","No","Nein"]
["ErrInfoMsg1","Ce champ doit contenir un nombre entre","This field must contain a number between","Dieses Feld muss eine Zahl enthalten zwischen"]
["And","et","and","und"]
["LongToit","Longueur du toit","Roof length","Dachlänge"]
["RampToit","Rampant du toit","Roof Width","Länge der Dachschräge"]
["HautModPVPo","Hauteur du module PV portrait","PV Portrait Module Height","Modulhöhe bei Hochkantmontage"]
["HautModPVPa","Hauteur du module PV paysage","PV Landscape Module Height","Modulhöhe bei Querformatmontage"]
["LargModPVPo","Largeur du module PV portrait","PV Portrait Module Width","Modulbreite bei Hochkantmontage"]
["LargModPVPa","Largeur du module PV paysage","PV Landscape Module Width","Modulbreite bei Querformatmontage"]
["ErrInfoMsg2","Le champ PV à créer doit avoir une référence d'au moins 6 caratères alphanumérique.","The PV plant to be created must have a reference of at least 6 alphanumeric characters.","Das zu erstellende PV-Feld muss eine Referenzangabe von mindestens 6 alphanumerischen Zeichen haben."]
["ErrInfoMsg3","Dans le cadre des évaluations techniques du système, l'étanchéité est garantie sur des pentes comprises entre 12° et 50°.","In accordance with the technical evaluations of the system, waterproofing is guaranteed on slopes between 12° to 50°.","Im Rahmen der technischen Bewertungen des Systems ist die Wasserdichtheit bei Dachneigungen zwischen 12 ° und 50 ° garantiert."]
["ErrInfoMsg4","En dessous et au dessus de ces pentes, bien contrôler l'étanchéité et la méthode d'installation.","Below and above these slopes, check the watertightness and installation method of the array.","Unterhalb und oberhalb dieser Dachneigungen sind Dichtheit und Installationsart der Anlage gesondert zu prüfen."]
["ErrInfoMsg5","L'utilisation des abergements de faitage n'est conseillée que sur des pentes supérieures à 17°.","The use of top flashings is recommended only for slopes greater than 17°.","Die Verwendung der Firstverblechung wird nur bei Neigungen empfohlen, die größer als 17 ° sind."]
["ErrInfoMsg6","En dessous de cette pente, bien se référer au manuel d'installation en ligne : ","Below this slope, refer to the online installation manual: ","Unterhalb dieser Dachneigung finden Sie gesonderte Hinweise in den Online-Installationsanweisungen: "]
["ErrInfoMsg7","Aucune plaque GSE correspondante n'a été trouvée !","No corresponding GSE frame has been found !","Es wurde keine passende GSE-Wanne gefunden!"]
["ErrInfoMsg8","Modifiez les dimensions du module PV pour trouver une plaque GSE correspondante.","Change the dimensions of the PV module to find a corresponding GSE Frame.","Ändern Sie die Abmessungen des PV-Moduls, um eine passende GSE-Wanne zu finden."]
["ErrInfoMsg9","Aucune référence du champ PV n'a été renseignée !","No reference of the PV array has been filled in !","Es wurde keine Referenz der PV-Anlage eingegeben!"]
["ErrInfoMsg10","Reseignez-en un.","Please, fill in one.","Bitte einmal ausfüllen."]
["Date","Date","Date","Datum"]
["Total","Total","Total","Gesamt"]
["PlanLat","Plan de lattage indisponible","Battening plan unavailable","Lattenplan nicht verfügbar"]
["Roul","Rouleau(x)","Roll(s)","Rolle(n)"]
["HautCmpSRFRE","Hauteur (sans Raccord faîtage et Raccord à l'égout)","Height (without Ridge connection and Connection to eaves)","Höhe (ohne Firstanbindung und Dichtigkeitsanbindung traufeseitig)"]
["LargCmpSAL","Largeur (sans abergements latéraux)","Width (without Lateral Flashing)","Breite (ohne seitliche Verblechung)"]
["Remise","Remise","Discount","Rabatt"]
["RemiseAber","Remise d'abergements supérieurs","Discount for top flashings","Rabatt der Obenverblechungen"]
["RemiseQuest","Avez-vous une remise ?","Do you have a discount ?","Haben Sie Rabatt?"]
["ErrInfoMsg11","La valeur de la remise saisie n'est pas correcte.","The discount value entered is not correct.","Der Wert des eingegebenen Rabattes ist nicht korrekt."]
["HautCmpARF","Hauteur (avec Raccord faîtage)","Height (with top connection)","Höhe (mit Firstanbindung)"]
["HautCmpARFRE","Hauteur (avec Raccord faîtage et Raccord à l'égout)","Height (with lateral connection and eaves connection)","Höhe (mit Firstanbindung und Dichtigkeitsanbindung traufeseitig)"]
["PUHT","P.U. (HT)","Unit Price (Excl Tax)","Pro Einheit (zzgl. MwSt.)"]
["AberFaitJonc","Abergement Faîtage Jonction","Top Flashing junction","Verbindungsblech Firstverblechung"]
["PUREM","P.U. REMISÉ ","Discounted unit price","Pro Einheit Diskontiert"]
["Portrait","Portrait","Portrait","Hochkant"]
["Paysage","Paysage","Landscape","Querformat"]
["NotePriceOpt","NB : Prix disponible auprès de votre interlocuteur habituel.","NB: Price available from your usual contact.","NB: Preisinformationen erhalten Sie bei Ihrem üblichen Ansprechpartner."]
["HidePrice","Masquer les prix","Hide prices","Preise ausblenden"]
["DisPrice","Afficher les prix","Show prices","Preise anzeigen"]
["WebLink1","Pour plus d’information sur le produit : www.gseintegration.com","For more information about the product: www.gseintegration.com","Für weitere Informationen über das Produkt: www.gseintegration.com"]
["UpQte","Modifier les quantités","Change quantities","Ändern Sie die Mengen"]
["FzQte","Bloquer les quantités","Freeze quantities","Mengen sperren"]
["Lang","Français","English","Deutsch"]
["PVPlant","Champ PV","PV Array","PV-Modulfeld"]
["nbAS","Nombre de GSE Air'System","Number of GSE Air'System","Anzhal der GSE Air'System"]
["KITATEC","Kit spécifique","Specific Kit","Spezifischer Kit"]
["KITUNI","Kit Universel","Universal Kit","Allgemeines Kit"]
["Autre","Autres","Others","Andere"]
["FENTOIT","Fenêtre de toit","Roof Window","Fenster am Dach"]
["NOFENTOIT","Pas de fenêtre","No Window","Kein Fenster"]
["VISU","Visualiser le positionnement des abergements hauts et des bandes d'étanchéité sur le champ PV","Show the position of the top flashings and sealing strips on the PV plant","Visualisierung der Positionierung der oberen Verblechungen und Dichtungsstreifen auf PV-modulfeld"]
["SelecATECModmsg2","Sélectionnez en un.","Choose one.","Wähle ein."]
["SelecATECModmsg3","La pente de toit est incorrecte pour la Tuile Canal (13.5° <= X <= 45°).","The roof slope is incorrect for 'Curved Tiles' (13.5° <= X <= 45°).","Die Dachneigung der 'Gewölbten Kacheln' ist falsch (13,5° <= X <= 45°)."]
["SelecATECModmsg4","Corrigez la valeur.","Correct the value.","Berichtigen Sie den Wert."]
["SelecATECModmsg5","La pente de toit est incorrecte pour l'ardoise (14° <= X <= 45°).","The roof slope is incorrect for 'Slate' (14° <= X <= 45°).","Die Dachneigung  der  'Schiefer' ist falsch (14° <= X <= 45°)."]
["Pan1","Simple pan","Monopitch","Einfache Dachfläche"]
["Pan2","Double pan","Duopitch","Doppelte Dachplatte"]
["Dimension","Dimensions","Dimensions","Dimensionen"]
["Conforme","Conforme à Avis Technique (France)","Compliant with the \"Avis Technique\" \n(French users only)","Entspricht der \"Avis Technique\" \n(nur für französische Benutzer)"]
["Avis","Module sous Avis Technique ","PV modules compliant with the \"Avis Technique\"","PV-Module, die mit der \"Avis Technique\" vorschriftsmäßig \nübereinstimmen"]
["Techno","Technologie","Technology","Technologie"]
["Jonction","Boite de jonction splittée","Split junction box","Anschlusskasten"]
["Renfort","Barre(s) de renfort","Rear support bar(s)","Bewehrungsstab"]
["Abergement","Abergements","Flashings","Verblechung"]
["Colorflex","Couleur FLEXALU","FLEXALU Color","FLEXALU Farbe"]
["Largeurflex","Largeur FLEXALU","FLEXALU Width","FLEXALU Breite"]
["Comment","Commentaires","Comments","Kommentare"]
["Dessin","Dessin","Drawing","Zeichnung"]
["Config","Insérer","Insert","Einfügen"]
["Objet","Objet","Item","Objekt"]
["Ajouter","Ajouter champ PV","Add new layout","Anbauen"]
["Deplacement","Déplacement du champs PV","PV array moving","Bewegung"]
["Message","Pour les abergements hauts des delais supplementaires de production sont a prevoir. Il est possible de les remplacer par du Flexalu","Additional time has to be considered for the production of the top center flashing. It is possible to replace it with Flexalu","Für die Herstellung der oberen Blechabdeckung muss zusätzliche Zeit berücksichtigt werden. Es ist möglich, sie durch Flexalu (Dichtungsband)  zu ersetzen."]
["Message_toit","Valeurs en dehors du toit","Out of the roof","Vom Dach aus"]
["Calcul","Calcul des pièces","Calculate parts","Berechnung"]
["Aucune_plaque","Aucune plaque trouvée","No GSE frame found","Keine GSE-Wanne gefunden"]
["Choisir_plaque","Choisir plaque","Select GSE frame","Auswählen GSE-Wanne"]
["EcranToiture","Ecran de sous toiture","Roofing Underlay","Unterspannbahn"]
["projet","projet","project","projekt\n"]
["info_rampant","Si vous ne connaissez pas la longueur de rampant, saisissez l’inclinaison et la largeur du toit pour la déterminer.","If you don’t know the roof width (R), enter the roof slope (α) and the house width (W) to determine it.","Wenn Sie die Dachfläche nicht kennen, geben Sie dessen Neigung und die Breite des Hauses ein, um diese zu bestimmen."]
["inserer","Insérer un champ prédéfini","Set up a predefined PV array","Einfügen einer vordefinierten PV-Anordnung"]
["ligne","Lignes","Lines","Zeilen"]
["colonne","Colonnes","Columns","Spalten"]
["Dessiner","Dessiner le champ PV","Draw the PV array","Zeichnen der PV-Anordnung"]
["liste","Liste de matériel","Bill of material","Stückliste"]
["legende1","Abergement de faîtage","Top Flashing","Eckverblechung"]
["legende2","Abergement latéral","Lateral Flashing","Seitliche Verblechung"]
["legende3","Bande d'étanchéité FLEXALU","FLEXALU Waterproofing Strip","FLEXALU Dichtungband"]
["Haut2","Hauteur (m)","Height (m)","Höhe (m)"]
["Larg2","Largeur (m)","Width (m)","Breite (m)"]
["Larg3","Largeur (L)","Width (L)","Breite (L)"]
["Messtoit","Veuillez saisir les dimensions du toit avant d’accéder à la partie Calepinage.","Please enter the roof dimensions before accessing the Layout section.","Please enter the roof dimensions before accessing the Layout section."]

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

{"sheet":"Listes","index":2,"n_rows":34,"n_cols":28,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["Epaisseur Module PV",null,"Pans","Module","Hauteur (mm)","Largeur (mm)","Epaisseur (mm)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type couverture","Oui/non","Raccord haut","Raccord bas","Couleur","Langue numéro","couleur etrier"]
[30,null,1,"AUO SunPrimo PM060PW1",1640,992,40,250,255,260,265,270,275,280,285,290,295,300,305,310,null,{"$f":"VLOOKUP(\"TuileM\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Tuile mécanique"},{"$f":"VLOOKUP(\"Yes\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Oui"},{"$f":"VLOOKUP(\"None1\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Aucun"},{"$f":"VLOOKUP(\"None1\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Aucun"},{"$f":"UPPER(trad(\"Noir\"))","v":"NOIR"},{"$f":"IF(s_langue=\"Deutsch\",3,IF(s_langue=\"English\",2,1))","v":1},{"$f":"IF(OR(Projet!R13=\"NOIR\",Projet!R13=\"BLACK\",Projet!R13=\"SCHWARZ\"),\"NOIR\",\"ALU\")","v":"NOIR"}]
[31,null,2,"AUO SunVivo PM060MX2",1640,992,40,250,255,260,265,270,275,280,285,290,295,300,305,310,null,{"$f":"VLOOKUP(\"Ardoise\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Ardoise"},{"$f":"VLOOKUP(\"No\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Non"},{"$f":"VLOOKUP(\"Aberfait\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Abergement"},"FLEXALU","ALU"]
[32,null,null,"AUO SunForte PM096B00",1559,1046,46,325,327,330,333,335,0,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(\"TuileC\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Tuile à fort galbe"},null,"FLEXALU"]
[33,null,null,"BISOL BMU",1649,991,35,250,255,260,265,270,275,280,285,0,0,0,0,0,null,{"$f":"VLOOKUP(\"Tuile\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Tuile plate"}]
[34,null,null,"BISOL BMO",1649,991,35,280,285,290,295,300,305,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(\"PlaqueN\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Plaque nervurée"}]
[35,null,null,"SolarWorld Sunmodule Plus SW poly",1675,1001,33,250,255,260,265,270,275,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(\"PlaqueO\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Plaque ondulée"}]
[36,null,null,"SolarWorld Sunmodule Plus SW mono",1675,1001,33,280,290,300,0,0,0,0,0,0,0,0,0,0]
[37,null,null,"Soluxtec Das Modul Multi Serie FR 60",1645,985,35,250,255,260,265,0,0,0,0,0,0,0,0,0]
[38,null,null,"Soluxtec Das Modul Mono Serie FR 60",1645,985,35,275,280,285,290,295,300,0,0,0,0,0,0,0]
[39,null,null,"SunPower SPR-E20/X21/X22",1559,1046,46,327,345,350,360,0,0,0,0,0,0,0,0,0]
[40,null,null,"Trina TSM-PD05",1650,992,35,255,260,265,270,0,0,0,0,0,0,0,0,0]
[41,null,null,"Trina TSM-DD05A",1650,992,35,270,275,280,285,290,0,0,0,0,0,0,0,0]
[42,null,null,"Viessmann Vitovolt 300 P",1640,992,40,250,255,260,265,270,0,0,0,0,0,0,0,0]
[43,null,null,"Viessmann Vitovolt 300 P",1640,992,40,275,280,285,290,295,300,305,310,0,0,0,0,0]
[44,null,null,"SOLUXTEC DAS MODUL Mono FS",1665,1005,35,315,320,325,330,0,0,0,0,0,0,0,0,0]
[45,null,null,"SUNPOWER Maxeon 2",1690,1046,40,340,345,350,355,360,0,0,0,0,0,0,0,0]
[46,null,null,"SUNPOWER Maxeon 3",1690,1046,40,370,375,380,385,390,395,400,0,0,0,0,0,0]
[47,null,null,"TRINASOLAR TSM-DE06M(II) ",1690,996,35,325,330,335,340,0,0,0,0,0,0,0,0,0]
[48,null,null,"TRINASOLAR TSM-DD06M.05(II)",1690,996,35,310,315,320,325,330,335,0,0,0,0,0,0,0]
[49,null,null,"TRINASOLAR TSM-PE06H",1690,996,35,285,290,295,300,0,0,0,0,0,0,0,0,0]
[50,null,null,"LG NeON’2  N1C",1686,1016,40,330,335,340,345,350,355,360,0,0,0,0,0,0]
[null,null,null,"LG NeON’2  N1K",1686,1016,40,325,330,335,340,0,0,0,0,0,0,0,0,0]
[null,null,null,"LG NeON’2  N1T",1686,1016,40,335,340,345,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"LG NeON’R Q1C",1700,1016,40,360,365,370,375,380,0,0,0,0,0,0,0,0]
[null,null,null,"LG NeON’R Q1K",1700,1016,40,335,340,345,350,355,360,365,370,0,0,0,0,0]
[null,null,null,"JA SOLAR JAP60S09/SC",1657,996,35,270,275,280,285,290,0,0,0,0,0,0,0,0]
[null,null,null,"JA SOLAR JAM60S09/PR",1657,996,35,310,315,320,325,330,0,0,0,0,0,0,0,0]
[null,null,null,"JA SOLAR JAM60S12/PR",1657,996,35,305,310,315,320,325,0,0,0,0,0,0,0,0]
[null,null,null,"CSUNxxx-60M 1640x990x35",1640,990,35,295,300,305,310,315,0,0,0,0,0,0,0,0]
[null,null,null,"CSUNxxx-60M 1658x996x35",1658,996,35,315,320,325,330,0,0,0,0,0,0,0,0,0]
[null,null,null,"CSUNxxx-120M",1684,1002,35,310,315,320,325,330,335,340,0,0,0,0,0,0]
[null,null,null,"PERLIGHT PLM-XXXMB-60",1640,992,35,270,275,280,285,290,295,300,305,310,0,0,0,0]
[null,null,null,"Autres",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Accueil","index":3,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":true,"merged":[[2,2,2,12],[3,2,3,12],[6,3,8,12],[41,3,41,4]]}
["                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      "]
[]
[null,null,{"$f":"VLOOKUP(\"HomeT1\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"BIENVENUE DANS L'OUTIL DE DIMENSIONNEMENT ET COMMANDE "}]
[null,null,{"$f":"VLOOKUP(\"HomeT2\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"DU GSE INTEGRATION IN-ROOF SYSTEM"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Français"]
[null,null,null,{"$f":"VLOOKUP(\"HomeT3\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Vous trouverez à travers cette application l'outil qui vous permettra de calculer et de dimensionner vos commandes"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,","]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(s_langue=\"Deutsch\",\"Produkte :\",IF(s_langue=\"English\",\"Products :\",\"Produits :\"))","v":"Produits :"},"GSE IN-ROOF"]
[]
[null,null,null,null,null,null,null,"GSE Intégration"]
[null,null,null,null,null,null,null,"5 - 9 rue Morand - 93400 Saint Ouen"]
[null,null,null,null,null,null,null,"Tel : +33(0)1.49.48.14.51 - contact@gseintegration.fr - www.gseintegration.com"]

{"sheet":"Projet","index":4,"n_rows":43,"n_cols":75,"rows_kept":43,"cut":false,"hidden":true,"merged":[[8,16,8,17],[16,17,16,19],[18,17,18,19],[20,17,20,19],[20,16,21,16],[10,17,10,19],[3,35,3,38],[3,42,3,43],[5,44,21,44],[22,44,42,44],[4,33,42,33],[37,9,37,11],[8,9,9,12],[1,9,1,12],[6,2,6,4],[8,2,8,3],[3,9,3,12],[10,9,11,12],[29,3,29,5],[12,9,12,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1020",1710,1020,"H21"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"RefCmpPV\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Référence du projet"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1025",1710,1025,"H21"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Référence","Tolérances dimensionnelles",null,null,null,null,null,null,"Dimensions de référence de la plaque GSE",null,null,null,"Hauteur ref :",1710,null,null,null,null,null,null,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base Plaque","PLAQUE","HAUTEUR MINIMUM","HAUTEUR MAXIMUM","LARGEUR MINIMUM","LARGEUR MAXIMUM","EPAISSEUR MIN","Demi cellule","Renfort","Hauteur ref","Larg ref",null,null,"Largueur ref :",1020]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1559 / 1046",1525,1615,1041,1046,35,null,null,1575,1046,"PORTRAIT",null,"Lignes :",6,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,{"$f":"VLOOKUP(\"DimToit\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Caractéristiques du toit"},null,null,null,null,null,null,{"$f":"VLOOKUP(\"DimMod\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Caractéristiques du module"},null,null,null,null,null,null,{"$f":"VLOOKUP(\"FeatCmpPV\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Composants du kit"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1575 / 1053",1525,1615,1048,1053,35,null,null,1575,1053,null,null,"Colonnes :",18,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1575 / 1082",1525,1615,1077,1082,35,null,null,1575,1082,null,null,"Ajustement :",0,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,{"$f":"VLOOKUP(\"Pan1\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Simple pan"},null,{"$f":"VLOOKUP(\"Pan2\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Double pan"},null,null,null,false,{"$f":"VLOOKUP(\"Conforme\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Conforme à Avis Technique (France)"},null,null,null,null,null,null,{"$f":"VLOOKUP(\"Abergement\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Abergements :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1580 / 808",1530,1620,803,808,35,null,null,1580,808,null,null,"Intermodule :",10,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1640 / 992",1590,1680,987,992,35,null,null,1640,992,null,null,"Hauteur :",10.48,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Avis\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Module sous Avis Technique "},null,null,null,null,null,2,{"$f":"VLOOKUP(\"KITUNI\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Kit Universel"},{"$f":"VLOOKUP(\"KITATEC\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Kit spécifique"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1640 / 1001",1590,1680,996,1001,35,null,null,1640,1001,null,null,"Longueur :",19.047000000000001,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1640 / 1001 P33",1590,1680,996,1001,32,null,null,1640,1001,null,null,"Etrier :","H21",null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,"Autres",null,null,null,null,null,null,{"$f":"VLOOKUP(\"ColorAber\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Couleur :"},"NOIR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1686 / 1016",1635,1725,1011,1016,35,null,null,1685,1016,null,null,"Nb etriers",{"$f":"IF(flex_etrier=1,4,6)","v":4},null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27","H27","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1000",1660,1750,995,1000,30,"Oui","Oui",1710,1000,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Dimension\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Dimensions :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1005",1660,1750,1000,1005,30,"Oui","Oui",1710,1005,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1010",1630,1750,1005,1010,30,"Oui","Oui",1710,1010,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Haut\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Hauteur (H) :"},1710,"mm",null,null,null,null,{"$f":"VLOOKUP(\"AberLat\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Raccord latéral :"},"Abergement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1020",1660,1750,1015,1020,30,"Oui","Oui",1710,1020,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1025",1660,1750,1020,1025,30,"Oui","Oui",1710,1025,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Larg3\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Largeur (L) :"},1020,"mm",null,null,null,null,{"$f":"VLOOKUP(\"RacFait\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Raccord haut :"},"Abergement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1030",1660,1750,1025,1030,30,"Oui","Oui",1710,1030,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1040",1630,1750,1035,1040,30,"Oui","Oui",1710,1040,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Epai\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Epaisseur (E) :"},35,"mm",null,null,null,null,{"$f":"VLOOKUP(\"RacEgout\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Raccord bas :"},"FLEXALU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1050",1660,1750,1045,1050,30,"Oui","Oui",1710,1050,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,{"$f":"VLOOKUP(\"Long\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Longueur (L) :"},20,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1710 / 1060",1660,1750,1055,1060,30,"Oui","Oui",1710,1060,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1559 / 1046",1032,1122,1554,1559,35,null,null,1082,1559,"PAYSAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,{"$f":"VLOOKUP(\"InclT\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Inclinaison (α) :"},17,"°",37.799999999999997,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1575 / 1082",1032,1122,1570,1575,35,null,null,1082,1575,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Colorflex\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Couleur FLEXALU :"},{"$f":"VLOOKUP(\"Noir\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Noir"},null,{"$f":"VLOOKUP(\"Rouge\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Rouge"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,"1580 / 808",758,848,1575,1580,35,null,null,808,1580,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,{"$f":"VLOOKUP(\"Ramp\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Rampant (R) :"},11,"m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1640 / 992",942,1032,1635,1640,35,null,null,992,1640,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,1,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"PowerMod\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Puissance :"},null,"Wc",null,null,null,null,{"$f":"VLOOKUP(\"Largeurflex\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Largeur FLEXALU :"},"330 mm",null,"500 mm",2,null,null,null,null,null,null,null,null,null,null,null,null,null,"1650 / 992 ",942,1032,1645,1650,35,null,null,992,1650,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,{"$f":"VLOOKUP(\"Larg\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Largeur (W) :"},10.6,"m",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1660 / 992",942,1032,1655,1660,35,null,null,992,1660,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Techno\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Technologie :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1670 / 992",942,1032,1665,1670,35,null,null,992,1670,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,{"$f":"VLOOKUP(\"TypeCov\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Type de couverture :"},"Ardoise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1675 / 992 P33",942,1032,1670,1675,35,null,null,992,1675,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Jonction\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Boite de jonction splittée"},null,null,null,false,null,null,{"$f":"VLOOKUP(\"NbrEtrier\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Nombre d'étriers :"},4,null,6,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"1680 / 992",942,1032,1675,1680,35,null,null,992,1680,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"Renfort\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Barre(s) de renfort"},null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1686 / 1016",942,1032,1681,1686,35,null,null,992,1686,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1700 / 1016",942,1032,1695,1700,35,null,null,992,1700,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31"]
[null,null,null,null,null,null,null,null,1,{"$f":"VLOOKUP(\"Portrait\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Portrait"},null,{"$f":"VLOOKUP(\"Paysage\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Paysage"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1665 / 1020",970,1060,1660,1665,30,"Oui",null,1020,1665,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"EcranToiture\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Ecran de sous toiture :"},null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1675 / 1020",970,1060,1670,1675,30,"Oui",null,1020,1675,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"CorPlakGSE\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Plaque GSE correspondante :"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1680 / 1020",970,1060,1675,1680,30,"Oui",null,1020,1680,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1685 / 1020",970,1060,1680,1685,30,"Oui",null,1020,1685,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,"1710 / 1020",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1690 / 1020",970,1060,1685,1690,30,"Oui",null,1020,1690,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1695 / 1020",940,1060,1690,1695,30,"Oui",null,1020,1695,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1700 / 1020",970,1060,1695,1700,30,"Oui",null,1020,1700,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1705 / 1020",940,1060,1700,1705,30,"Oui",null,1020,1705,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1720 / 1020",940,1060,1715,1720,30,"Oui",null,1020,1720,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1740 / 1020",970,1060,1735,1740,30,"Oui",null,1020,1740,null,null,null,null,null,null,null,null,null,null,"H16","H16","H16","H19","H19","H21","H21","H23","H23","H23","H26","H26","H27","H27",null,"H31","H31","H31"]

{"sheet":"Calepinage","index":5,"n_rows":323,"n_cols":38,"rows_kept":323,"cut":false,"hidden":false,"merged":[[4,201,4,202],[4,203,4,204],[4,155,4,156],[4,157,4,158],[4,195,4,196],[4,205,4,206],[5,5,206,5],[4,185,4,186],[4,187,4,188],[4,189,4,190],[4,191,4,192],[4,161,4,162],[4,163,4,164],[4,165,4,166],[4,167,4,168],[4,169,4,170],[4,171,4,172],[4,159,4,160],[4,137,4,138],[4,197,4,198],[4,199,4,200],[4,135,4,136],[4,139,4,140],[4,141,4,142],[4,143,4,144],[4,193,4,194],[4,173,4,174],[4,175,4,176],[4,177,4,178],[4,179,4,180],[4,181,4,182],[4,183,4,184],[4,149,4,150],[4,151,4,152],[4,153,4,154],[4,125,4,126],[4,127,4,128],[4,129,4,130],[4,131,4,132],[4,113,4,114],[4,115,4,116],[4,117,4,118],[4,119,4,120],[4,121,4,122],[4,133,4,134],[4,145,4,146],[4,147,4,148],[4,111,4,112],[4,89,4,90],[4,91,4,92],[4,93,4,94],[4,95,4,96],[4,97,4,98],[4,99,4,100],[4,101,4,102],[4,103,4,104],[4,105,4,106],[4,107,4,108],[4,109,4,110],[4,123,4,124],[4,83,4,84],[4,85,4,86],[4,87,4,88],[4,65,4,66],[4,67,4,68],[4,69,4,70],[4,71,4,72],[4,73,4,74],[4,75,4,76],[4,79,4,80],[4,81,4,82],[4,63,4,64],[4,51,4,52],[4,77,4,78],[3,16,3,17],[4,16,4,17],[4,53,4,54],[4,55,4,56],[4,57,4,58],[4,59,4,60],[4,61,4,62],[1,8,1,23],[4,37,4,48],[1,37,1,48],[2,37,3,48],[4,29,4,30],[4,31,4,32],[4,33,4,34],[4,35,4,36],[4,19,4,20],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,27,4,28],[3,6,4,11],[4,12,4,15],[3,12,3,15]]}
[]
[null,{"$f":"VLOOKUP(\"liste\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Liste de matériel"},null,null,null,null,null,null,{"$f":"VLOOKUP(\"dessiner\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Dessiner le champ PV"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\": \"&VLOOKUP(\"legende1\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":": Abergement de faîtage"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\": \"&VLOOKUP(\"legende2\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":": Abergement latéral"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(\"inserer\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Insérer un champ prédéfini"},null,null,null,null,null,{"$f":"VLOOKUP(\"ligne\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Lignes :"},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(\"colonne\",BD!$A$1:$D$200,Listes!$AA$2+1,0)&\" :\"","v":"Colonnes :"},null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\": \"&VLOOKUP(\"legende3\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":": Bande d'étanchéité FLEXALU"}]
[null,"KIT GSE INTEGRATION"]
[null,{"$f":"B302","v":"Plaques Portrait 1710 / 1020"},{"$f":"C302","v":0}]
[null,{"$f":"IFERROR(INDEX($B$301:$Z$321,MATCH(ROW(A10)-8,$Z$301:$Z$321,0),1),\"\")","v":"Abergement Latéral Universel Noir"},{"$f":"IFERROR(INDEX($B$301:$Z$321,MATCH(ROW(A10)-8,$Z$301:$Z$321,0),2),\"\")","v":0}]
[null,{"$f":"IFERROR(INDEX($B$301:$Z$321,MATCH(ROW(A11)-8,$Z$301:$Z$321,0),1),\"\")","v":"Abergement Angle Haut Droit Universel Noir "},{"$f":"IFERROR(INDEX($B$301:$Z$321,MATCH(ROW(A11)-8,$Z$301:$Z$321,0),2),\"\")","v":0}]
[null,"Abergement Angle Haut Gauche Universel Noir ",0]
[null,"Abergement Haut Central Universel Noir L 1500mm",0]
[null,"Crochet de Fixation d'Abergement In Roof",0]
[null,"Abergement Haut Cornière Laquée Noire L1400mm (pour la fixation des abergements centraux)",0]
[null,"Rivets Pop 4x8 (pour la fixation des cornières)",0]
[null,"Abergement Haut Jonction Universel Noir L 375mm  ",0]
[null,"Vis GSE Integration 6.3mmx60mm Alu",0]
[null,"Vis GSE Integration 6.3mmx60mm Noir",0]
[null,"Etrier Double H21 - Acier Inox - Noir - In Roof ",0]
[null,"Etrier Simple H21 - Acier Inox - Noir - In Roof ",0]
[null,"Cale Gauche de Renfort pour Etriers Simple In Roof",0]
[null,"Cale Droite de Renfort pour Etriers Simple In Roof",0]
[null,"Cale EPDM Pour Vis In Roof (25x21 EP. 5mm)",0]
[null,"Joint pré-contraint - 20 x 40 mm (Rouleau de 5.5 m)  ",0]
[null,"Flexalu Gris Ardoise 500mm L5m Butyle 20/100",0]
[null,"",""]
[null,"",{"$f":"IFERROR(INDEX($B$301:$Z$321,MATCH(ROW(A28)-8,$Z$301:$Z$321,0),2),\"\")","v":""}]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[null,"",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"KIT GSE INTEGRATION",null,1,2,3,4,5,6,7,8,9,10]
[{"$f":"SUM(C302:M302)","v":0},"Plaques Portrait 1710 / 1020",null,null,null,null,null,null,null,null,null,null,null,null,"PPORT",null,null,null,null,null,null,null,null,null,null,1]
[0,"Abergement Latéral Universel Noir",null,null,null,null,null,null,null,null,null,null,null,null,"ALUN",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B303<>\"\",Z302+1,Z302)","v":2}]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B304<>\"\",Z303+1,Z303)","v":2}]
[0,"Abergement Angle Haut Droit Universel Noir ",null,null,null,null,null,null,null,null,null,null,null,null,"COINDNOIR2014_15",null,null,null,null,null,null,null,null,null,null,3]
[0,"Abergement Angle Haut Gauche Universel Noir ",null,null,null,null,null,null,null,null,null,null,null,null,"COINGNOIR2014_15",null,null,null,null,null,null,null,null,null,null,4]
[0,"Abergement Haut Central Universel Noir L 1500mm",null,null,null,null,null,null,null,null,null,null,null,null,"AFCUNL1500",null,null,null,null,null,null,null,null,null,null,5]
[0,"Crochet de Fixation d'Abergement In Roof",null,null,null,null,null,null,null,null,null,null,null,null,"CROCHET",null,null,null,null,null,null,null,null,null,null,6]
[0,"Abergement Haut Cornière Laquée Noire L1400mm (pour la fixation des abergements centraux)",null,null,null,null,null,null,null,null,null,null,null,null,"CORNIERELAQUEB",null,null,null,null,null,null,null,null,null,null,7]
[0,"Rivets Pop 4x8 (pour la fixation des cornières)",null,null,null,null,null,null,null,null,null,null,null,null,"RIVETPOP",null,null,null,null,null,null,null,null,null,null,8]
[0,"Abergement Haut Jonction Universel Noir L 375mm  ",null,null,null,null,null,null,null,null,null,null,null,null,"AFJUNL375",null,null,null,null,null,null,null,null,null,null,9]
[0,"Vis GSE Integration 6.3mmx60mm Alu",null,null,null,null,null,null,null,null,null,null,null,null,"VIS2014A",null,null,null,null,null,null,null,null,null,null,10]
[0,"Vis GSE Integration 6.3mmx60mm Noir",null,null,null,null,null,null,null,null,null,null,null,null,"VIS2014N",null,null,null,null,null,null,null,null,null,null,11]
[0,"Etrier Double H21 - Acier Inox - Noir - In Roof ",null,null,null,null,null,null,null,null,null,null,null,null,"EDH212014N (ASV09-40V)",null,null,null,null,null,null,null,null,null,null,12]
[0,"Etrier Simple H21 - Acier Inox - Noir - In Roof ",null,null,null,null,null,null,null,null,null,null,null,null,"ESH212014N (ASV08-40V)",null,null,null,null,null,null,null,null,null,null,13]
[0,"Cale Gauche de Renfort pour Etriers Simple In Roof",null,null,null,null,null,null,null,null,null,null,null,null,"CALE_GAUCHE",null,null,null,null,null,null,null,null,null,null,14]
[0,"Cale Droite de Renfort pour Etriers Simple In Roof",null,null,null,null,null,null,null,null,null,null,null,null,"CALE_DROIT",null,null,null,null,null,null,null,null,null,null,15]
[0,"Cale EPDM Pour Vis In Roof (25x21 EP. 5mm)",null,null,null,null,null,null,null,null,null,null,null,null,"CALE_EPDM_CELL",null,null,null,null,null,null,null,null,null,null,16]
[0,"Joint pré-contraint - 20 x 40 mm (Rouleau de 5.5 m)  ",null,null,null,null,null,null,null,null,null,null,null,null,"JOINT_PRE_CONTRAIN",null,null,null,null,null,null,null,null,null,null,17]
[0,"Flexalu Gris Ardoise 500mm L5m Butyle 20/100",null,null,null,null,null,null,null,null,null,null,null,null,"BANDE_FLEXALU_500",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B320<>\"\",Z319+1,Z319)","v":18}]
[0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B321<>\"\",Z320+1,Z320)","v":18}]
[]
[0]

{"sheet":"Dessin","index":6,"n_rows":109,"n_cols":211,"rows_kept":109,"cut":false,"hidden":false,"merged":[[6,4,6,5],[12,4,12,5],[5,4,5,5],[11,4,11,5],[108,201,108,202],[108,203,108,204],[108,205,108,206],[108,207,108,208],[108,209,108,210],[108,189,108,190],[108,191,108,192],[108,193,108,194],[108,195,108,196],[108,197,108,198],[108,199,108,200],[108,177,108,178],[108,179,108,180],[108,181,108,182],[108,183,108,184],[108,185,108,186],[108,187,108,188],[108,165,108,166],[108,167,108,168],[108,169,108,170],[108,171,108,172],[108,173,108,174],[108,175,108,176],[108,153,108,154],[108,155,108,156],[108,157,108,158],[108,159,108,160],[108,161,108,162],[108,163,108,164],[108,141,108,142],[108,143,108,144],[108,145,108,146],[108,147,108,148],[108,149,108,150],[108,151,108,152],[108,129,108,130],[108,131,108,132],[108,133,108,134],[108,135,108,136],[108,137,108,138],[108,139,108,140],[108,117,108,118],[108,119,108,120],[108,121,108,122],[108,123,108,124],[108,125,108,126],[108,127,108,128],[108,105,108,106],[108,107,108,108],[108,109,108,110],[108,111,108,112],[108,113,108,114],[108,115,108,116],[108,93,108,94],[108,95,108,96],[108,97,108,98],[108,99,108,100],[108,101,108,102],[108,103,108,104],[108,81,108,82],[108,83,108,84],[108,85,108,86],[108,87,108,88],[108,89,108,90],[108,91,108,92],[108,69,108,70],[108,71,108,72],[108,73,108,74],[108,75,108,76],[108,77,108,78],[108,79,108,80],[108,57,108,58],[108,59,108,60],[108,61,108,62],[108,63,108,64],[108,65,108,66],[108,67,108,68],[108,45,108,46],[108,47,108,48],[108,49,108,50],[108,51,108,52],[108,53,108,54],[108,55,108,56],[108,33,108,34],[108,35,108,36],[108,37,108,38],[108,39,108,40],[108,41,108,42],[108,43,108,44],[108,21,108,22],[108,23,108,24],[108,25,108,26],[108,27,108,28],[108,29,108,30],[108,31,108,32],[107,201,107,202],[107,203,107,204],[107,205,107,206],[107,207,107,208],[107,209,107,210],[108,11,108,12],[108,13,108,14],[108,15,108,16],[108,17,108,18],[108,19,108,20],[107,189,107,190],[107,191,107,192],[107,193,107,194],[107,195,107,196],[107,197,107,198],[107,199,107,200],[107,177,107,178],[107,179,107,180],[107,181,107,182],[107,183,107,184],[107,185,107,186],[107,187,107,188],[107,165,107,166],[107,167,107,168],[107,169,107,170],[107,171,107,172],[107,173,107,174],[107,175,107,176],[107,153,107,154],[107,155,107,156],[107,157,107,158],[107,159,107,160],[107,161,107,162],[107,163,107,164],[107,141,107,142],[107,143,107,144],[107,145,107,146],[107,147,107,148],[107,149,107,150],[107,151,107,152],[107,129,107,130],[107,131,107,132],[107,133,107,134],[107,135,107,136],[107,137,107,138],[107,139,107,140],[107,117,107,118],[107,119,107,120],[107,121,107,122],[107,123,107,124],[107,125,107,126],[107,127,107,128],[107,105,107,106],[107,107,107,108],[107,109,107,110],[107,111,107,112],[107,113,107,114],[107,115,107,116],[107,93,107,94],[107,95,107,96],[107,97,107,98],[107,99,107,100],[107,101,107,102],[107,103,107,104],[107,81,107,82],[107,83,107,84],[107,85,107,86],[107,87,107,88],[107,89,107,90],[107,91,107,92],[107,69,107,70],[107,71,107,72],[107,73,107,74],[107,75,107,76],[107,77,107,78],[107,79,107,80],[107,57,107,58],[107,59,107,60],[107,61,107,62],[107,63,107,64],[107,65,107,66],[107,67,107,68],[107,45,107,46],[107,47,107,48],[107,49,107,50],[107,51,107,52],[107,53,107,54],[107,55,107,56],[107,33,107,34],[107,35,107,36],[107,37,107,38],[107,39,107,40],[107,41,107,42],[107,43,107,44],[107,21,107,22],[107,23,107,24],[107,25,107,26],[107,27,107,28],[107,29,107,30],[107,31,107,32],[106,201,106,202],[106,203,106,204],[106,205,106,206],[106,207,106,208],[106,209,106,210],[107,11,107,12],[107,13,107,14],[107,15,107,16],[107,17,107,18],[107,19,107,20],[106,189,106,190],[106,191,106,192],[106,193,106,194],[106,195,106,196],[106,197,106,198],[106,199,106,200],[106,177,106,178],[106,179,106,180],[106,181,106,182],[106,183,106,184],[106,185,106,186],[106,187,106,188],[106,165,106,166],[106,167,106,168],[106,169,106,170],[106,171,106,172],[106,173,106,174],[106,175,106,176],[106,153,106,154],[106,155,106,156],[106,157,106,158],[106,159,106,160],[106,161,106,162],[106,163,106,164],[106,141,106,142],[106,143,106,144],[106,145,106,146],[106,147,106,148],[106,149,106,150],[106,151,106,152],[106,129,106,130],[106,131,106,132],[106,133,106,134],[106,135,106,136],[106,137,106,138],[106,139,106,140],[106,117,106,118],[106,119,106,120],[106,121,106,122],[106,123,106,124],[106,125,106,126],[106,127,106,128],[106,105,106,106],[106,107,106,108],[106,109,106,110],[106,111,106,112],[106,113,106,114],[106,115,106,116],[106,93,106,94],[106,95,106,96],[106,97,106,98],[106,99,106,100],[106,101,106,102],[106,103,106,104],[106,81,106,82],[106,83,106,84],[106,85,106,86],[106,87,106,88],[106,89,106,90],[106,91,106,92],[106,69,106,70],[106,71,106,72],[106,73,106,74],[106,75,106,76],[106,77,106,78],[106,79,106,80],[106,57,106,58],[106,59,106,60],[106,61,106,62],[106,63,106,64],[106,65,106,66],[106,67,106,68],[106,45,106,46],[106,47,106,48],[106,49,106,50],[106,51,106,52],[106,53,106,54],[106,55,106,56],[106,33,106,34],[106,35,106,36],[106,37,106,38],[106,39,106,40],[106,41,106,42],[106,43,106,44],[106,21,106,22],[106,23,106,24],[106,25,106,26],[106,27,106,28],[106,29,106,30],[106,31,106,32],[105,201,105,202],[105,203,105,204],[105,205,105,206],[105,207,105,208],[105,209,105,210],[106,11,106,12],[106,13,106,14],[106,15,106,16],[106,17,106,18],[106,19,106,20],[105,189,105,190],[105,191,105,192],[105,193,105,194],[105,195,105,196],[105,197,105,198],[105,199,105,200],[105,177,105,178],[105,179,105,180],[105,181,105,182],[105,183,105,184],[105,185,105,186],[105,187,105,188],[105,165,105,166],[105,167,105,168],[105,169,105,170],[105,171,105,172],[105,173,105,174],[105,175,105,176],[105,153,105,154],[105,155,105,156],[105,157,105,158],[105,159,105,160],[105,161,105,162],[105,163,105,164],[105,141,105,142],[105,143,105,144],[105,145,105,146],[105,147,105,148],[105,149,105,150],[105,151,105,152],[105,129,105,130],[105,131,105,132],[105,133,105,134],[105,135,105,136],[105,137,105,138],[105,139,105,140],[105,117,105,118],[105,119,105,120],[105,121,105,122],[105,123,105,124],[105,125,105,126],[105,127,105,128],[105,105,105,106],[105,107,105,108],[105,109,105,110],[105,111,105,112],[105,113,105,114],[105,115,105,116],[105,93,105,94],[105,95,105,96],[105,97,105,98],[105,99,105,100],[105,101,105,102],[105,103,105,104],[105,81,105,82],[105,83,105,84],[105,85,105,86],[105,87,105,88],[105,89,105,90],[105,91,105,92],[105,69,105,70],[105,71,105,72],[105,73,105,74],[105,75,105,76],[105,77,105,78],[105,79,105,80],[105,57,105,58],[105,59,105,60],[105,61,105,62],[105,63,105,64],[105,65,105,66],[105,67,105,68],[105,45,105,46],[105,47,105,48],[105,49,105,50],[105,51,105,52],[105,53,105,54],[105,55,105,56],[105,33,105,34],[105,35,105,36],[105,37,105,38],[105,39,105,40],[105,41,105,42],[105,43,105,44],[105,21,105,22],[105,23,105,24],[105,25,105,26],[105,27,105,28],[105,29,105,30],[105,31,105,32],[104,201,104,202],[104,203,104,204],[104,205,104,206],[104,207,104,208],[104,209,104,210],[105,11,105,12],[105,13,105,14],[105,15,105,16],[105,17,105,18],[105,19,105,20],[104,189,104,190],[104,191,104,192],[104,193,104,194],[104,195,104,196],[104,197,104,198],[104,199,104,200],[104,177,104,178],[104,179,104,180],[104,181,104,182],[104,183,104,184],[104,185,104,186],[104,187,104,188],[104,165,104,166],[104,167,104,168],[104,169,104,170],[104,171,104,172],[104,173,104,174],[104,175,104,176],[104,153,104,154],[104,155,104,156],[104,157,104,158],[104,159,104,160],[104,161,104,162],[104,163,104,164],[104,141,104,142],[104,143,104,144],[104,145,104,146],[104,147,104,148],[104,149,104,150],[104,151,104,152],[104,129,104,130],[104,131,104,132],[104,133,104,134],[104,135,104,136],[104,137,104,138],[104,139,104,140],[104,117,104,118],[104,119,104,120],[104,121,104,122],[104,123,104,124],[104,125,104,126],[104,127,104,128],[104,105,104,106],[104,107,104,108],[104,109,104,110],[104,111,104,112],[104,113,104,114],[104,115,104,116],[104,93,104,94],[104,95,104,96],[104,97,104,98],[104,99,104,100],[104,101,104,102],[104,103,104,104],[104,81,104,82],[104,83,104,84],[104,85,104,86],[104,87,104,88],[104,89,104,90],[104,91,104,92],[104,69,104,70],[104,71,104,72],[104,73,104,74],[104,75,104,76],[104,77,104,78],[104,79,104,80],[104,57,104,58],[104,59,104,60],[104,61,104,62],[104,63,104,64],[104,65,104,66],[104,67,104,68],[104,45,104,46],[104,47,104,48],[104,49,104,50],[104,51,104,52],[104,53,104,54],[104,55,104,56],[104,33,104,34],[104,35,104,36],[104,37,104,38],[104,39,104,40],[104,41,104,42],[104,43,104,44],[104,21,104,22],[104,23,104,24],[104,25,104,26],[104,27,104,28],[104,29,104,30],[104,31,104,32],[103,201,103,202],[103,203,103,204],[103,205,103,206],[103,207,103,208],[103,209,103,210],[104,11,104,12],[104,13,104,14],[104,15,104,16],[104,17,104,18],[104,19,104,20],[103,189,103,190],[103,191,103,192],[103,193,103,194],[103,195,103,196],[103,197,103,198],[103,199,103,200],[103,177,103,178],[103,179,103,180],[103,181,103,182],[103,183,103,184],[103,185,103,186],[103,187,103,188],[103,165,103,166],[103,167,103,168],[103,169,103,170],[103,171,103,172],[103,173,103,174],[103,175,103,176],[103,153,103,154],[103,155,103,156],[103,157,103,158],[103,159,103,160],[103,161,103,162],[103,163,103,164],[103,141,103,142],[103,143,103,144],[103,145,103,146],[103,147,103,148],[103,149,103,150],[103,151,103,152],[103,129,103,130],[103,131,103,132],[103,133,103,134],[103,135,103,136],[103,137,103,138],[103,139,103,140],[103,117,103,118],[103,119,103,120],[103,121,103,122],[103,123,103,124],[103,125,103,126],[103,127,103,128],[103,105,103,106],[103,107,103,108],[103,109,103,110],[103,111,103,112],[103,113,103,114],[103,115,103,116],[103,93,103,94],[103,95,103,96],[103,97,103,98],[103,99,103,100],[103,101,103,102],[103,103,103,104],[103,81,103,82],[103,83,103,84],[103,85,103,86],[103,87,103,88],[103,89,103,90],[103,91,103,92],[103,69,103,70],[103,71,103,72],[103,73,103,74],[103,75,103,76],[103,77,103,78],[103,79,103,80],[103,57,103,58],[103,59,103,60],[103,61,103,62],[103,63,103,64],[103,65,103,66],[103,67,103,68],[103,45,103,46],[103,47,103,48],[103,49,103,50],[103,51,103,52],[103,53,103,54],[103,55,103,56],[103,33,103,34],[103,35,103,36],[103,37,103,38],[103,39,103,40],[103,41,103,42],[103,43,103,44],[103,21,103,22],[103,23,103,24],[103,25,103,26],[103,27,103,28],[103,29,103,30],[103,31,103,32],[102,201,102,202],[102,203,102,204],[102,205,102,206],[102,207,102,208],[102,209,102,210],[103,11,103,12],[103,13,103,14],[103,15,103,16],[103,17,103,18],[103,19,103,20],[102,189,102,190],[102,191,102,192],[102,193,102,194],[102,195,102,196],[102,197,102,198],[102,199,102,200],[102,177,102,178],[102,179,102,180],[102,181,102,182],[102,183,102,184],[102,185,102,186],[102,187,102,188],[102,165,102,166],[102,167,102,168],[102,169,102,170],[102,171,102,172],[102,173,102,174],[102,175,102,176],[102,153,102,154],[102,155,102,156],[102,157,102,158],[102,159,102,160],[102,161,102,162],[102,163,102,164],[102,141,102,142],[102,143,102,144],[102,145,102,146],[102,147,102,148],[102,149,102,150],[102,151,102,152],[102,129,102,130],[102,131,102,132],[102,133,102,134],[102,135,102,136],[102,137,102,138],[102,139,102,140],[102,117,102,118],[102,119,102,120],[102,121,102,122],[102,123,102,124],[102,125,102,126],[102,127,102,128],[102,105,102,106],[102,107,102,108],[102,109,102,110],[102,111,102,112],[102,113,102,114],[102,115,102,116],[102,93,102,94],[102,95,102,96],[102,97,102,98],[102,99,102,100],[102,101,102,102],[102,103,102,104],[102,81,102,82],[102,83,102,84],[102,85,102,86],[102,87,102,88],[102,89,102,90],[102,91,102,92],[102,69,102,70],[102,71,102,72],[102,73,102,74],[102,75,102,76],[102,77,102,78],[102,79,102,80],[102,57,102,58],[102,59,102,60],[102,61,102,62],[102,63,102,64],[102,65,102,66],[102,67,102,68],[102,45,102,46],[102,47,102,48],[102,49,102,50],[102,51,102,52],[102,53,102,54],[102,55,102,56],[102,33,102,34],[102,35,102,36],[102,37,102,38],[102,39,102,40],[102,41,102,42],[102,43,102,44],[102,21,102,22],[102,23,102,24],[102,25,102,26],[102,27,102,28],[102,29,102,30],[102,31,102,32],[101,201,101,202],[101,203,101,204],[101,205,101,206],[101,207,101,208],[101,209,101,210],[102,11,102,12],[102,13,102,14],[102,15,102,16],[102,17,102,18],[102,19,102,20],[101,189,101,190],[101,191,101,192],[101,193,101,194],[101,195,101,196],[101,197,101,198],[101,199,101,200],[101,177,101,178],[101,179,101,180],[101,181,101,182],[101,183,101,184],[101,185,101,186],[101,187,101,188],[101,165,101,166],[101,167,101,168],[101,169,101,170],[101,171,101,172],[101,173,101,174],[101,175,101,176],[101,153,101,154],[101,155,101,156],[101,157,101,158],[101,159,101,160],[101,161,101,162],[101,163,101,164],[101,141,101,142],[101,143,101,144],[101,145,101,146],[101,147,101,148],[101,149,101,150],[101,151,101,152],[101,129,101,130],[101,131,101,132],[101,133,101,134],[101,135,101,136],[101,137,101,138],[101,139,101,140],[101,117,101,118],[101,119,101,120],[101,121,101,122],[101,123,101,124],[101,125,101,126],[101,127,101,128],[101,105,101,106],[101,107,101,108],[101,109,101,110],[101,111,101,112],[101,113,101,114],[101,115,101,116],[101,93,101,94],[101,95,101,96],[101,97,101,98],[101,99,101,100],[101,101,101,102],[101,103,101,104],[101,81,101,82],[101,83,101,84],[101,85,101,86],[101,87,101,88],[101,89,101,90],[101,91,101,92],[101,69,101,70],[101,71,101,72],[101,73,101,74],[101,75,101,76],[101,77,101,78],[101,79,101,80],[101,57,101,58],[101,59,101,60],[101,61,101,62],[101,63,101,64],[101,65,101,66],[101,67,101,68],[101,45,101,46],[101,47,101,48],[101,49,101,50],[101,51,101,52],[101,53,101,54],[101,55,101,56],[101,33,101,34],[101,35,101,36],[101,37,101,38],[101,39,101,40],[101,41,101,42],[101,43,101,44],[101,21,101,22],[101,23,101,24],[101,25,101,26],[101,27,101,28],[101,29,101,30],[101,31,101,32],[100,201,100,202],[100,203,100,204],[100,205,100,206],[100,207,100,208],[100,209,100,210],[101,11,101,12],[101,13,101,14],[101,15,101,16],[101,17,101,18],[101,19,101,20],[100,189,100,190],[100,191,100,192],[100,193,100,194],[100,195,100,196],[100,197,100,198],[100,199,100,200],[100,177,100,178],[100,179,100,180],[100,181,100,182],[100,183,100,184],[100,185,100,186],[100,187,100,188],[100,165,100,166],[100,167,100,168],[100,169,100,170],[100,171,100,172],[100,173,100,174],[100,175,100,176],[100,153,100,154],[100,155,100,156],[100,157,100,158],[100,159,100,160],[100,161,100,162],[100,163,100,164],[100,141,100,142],[100,143,100,144],[100,145,100,146],[100,147,100,148],[100,149,100,150],[100,151,100,152],[100,129,100,130],[100,131,100,132],[100,133,100,134],[100,135,100,136],[100,137,100,138],[100,139,100,140],[100,117,100,118],[100,119,100,120],[100,121,100,122],[100,123,100,124],[100,125,100,126],[100,127,100,128],[100,105,100,106],[100,107,100,108],[100,109,100,110],[100,111,100,112],[100,113,100,114],[100,115,100,116],[100,93,100,94],[100,95,100,96],[100,97,100,98],[100,99,100,100],[100,101,100,102],[100,103,100,104],[100,81,100,82],[100,83,100,84],[100,85,100,86],[100,87,100,88],[100,89,100,90],[100,91,100,92],[100,69,100,70],[100,71,100,72],[100,73,100,74],[100,75,100,76],[100,77,100,78],[100,79,100,80],[100,57,100,58],[100,59,100,60],[100,61,100,62],[100,63,100,64],[100,65,100,66],[100,67,100,68],[100,45,100,46],[100,47,100,48],[100,49,100,50],[100,51,100,52],[100,53,100,54],[100,55,100,56],[100,33,100,34],[100,35,100,36],[100,37,100,38],[100,39,100,40],[100,41,100,42],[100,43,100,44],[100,21,100,22],[100,23,100,24],[100,25,100,26],[100,27,100,28],[100,29,100,30],[100,31,100,32],[99,201,99,202],[99,203,99,204],[99,205,99,206],[99,207,99,208],[99,209,99,210],[100,11,100,12],[100,13,100,14],[100,15,100,16],[100,17,100,18],[100,19,100,20],[99,189,99,190],[99,191,99,192],[99,193,99,194],[99,195,99,196],[99,197,99,198],[99,199,99,200],[99,177,99,178],[99,179,99,180],[99,181,99,182],[99,183,99,184],[99,185,99,186],[99,187,99,188],[99,165,99,166],[99,167,99,168],[99,169,99,170],[99,171,99,172],[99,173,99,174],[99,175,99,176],[99,153,99,154],[99,155,99,156],[99,157,99,158],[99,159,99,160],[99,161,99,162],[99,163,99,164],[99,141,99,142],[99,143,99,144],[99,145,99,146],[99,147,99,148],[99,149,99,150],[99,151,99,152],[99,129,99,130],[99,131,99,132],[99,133,99,134],[99,135,99,136],[99,137,99,138],[99,139,99,140],[99,117,99,118],[99,119,99,120],[99,121,99,122],[99,123,99,124],[99,125,99,126],[99,127,99,128],[99,105,99,106],[99,107,99,108],[99,109,99,110],[99,111,99,112],[99,113,99,114],[99,115,99,116],[99,93,99,94],[99,95,99,96],[99,97,99,98],[99,99,99,100],[99,101,99,102],[99,103,99,104],[99,81,99,82],[99,83,99,84],[99,85,99,86],[99,87,99,88],[99,89,99,90],[99,91,99,92],[99,69,99,70],[99,71,99,72],[99,73,99,74],[99,75,99,76],[99,77,99,78],[99,79,99,80],[99,57,99,58],[99,59,99,60],[99,61,99,62],[99,63,99,64],[99,65,99,66],[99,67,99,68],[99,45,99,46],[99,47,99,48],[99,49,99,50],[99,51,99,52],[99,53,99,54],[99,55,99,56],[99,33,99,34],[99,35,99,36],[99,37,99,38],[99,39,99,40],[99,41,99,42],[99,43,99,44],[99,21,99,22],[99,23,99,24],[99,25,99,26],[99,27,99,28],[99,29,99,30],[99,31,99,32],[98,201,98,202]],"merged_total":10105,"flags":["merged_cut"]}
[]
[]
[]
[]
[]
[null,null,null,null,"A"]
[null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,"1 m",null,"2 m",null,"3 m",null,"4 m",null,"5 m",null,"6 m",null,"7 m",null,"8 m",null,"9 m",null,"10 m",null,"11 m",null,"12 m",null,"13 m",null,"14 m",null,"15 m",null,"16 m",null,"17 m",null,"18 m",null,"19 m",null,"20 m",null,"21 m",null,"22 m",null,"23 m",null,"24 m",null,"25 m",null,"26 m",null,"27 m",null,"28 m",null,"29 m",null,"30 m",null,"31 m",null,"32 m",null,"33 m",null,"34 m",null,"35 m",null,"36 m",null,"37 m",null,"38 m",null,"39 m",null,"40 m",null,"41 m",null,"42 m",null,"43 m",null,"44 m",null,"45 m",null,"46 m",null,"47 m",null,"48 m",null,"49 m",null,"50 m",null,"51 m",null,"52 m",null,"53 m",null,"54 m",null,"55 m",null,"56 m",null,"57 m",null,"58 m",null,"59 m",null,"60 m",null,"61 m",null,"62 m",null,"63 m",null,"64 m",null,"65 m",null,"66 m",null,"67 m",null,"68 m",null,"69 m",null,"70 m",null,"71 m",null,"72 m",null,"73 m",null,"74 m",null,"75 m",null,"76 m",null,"77 m",null,"78 m",null,"79 m",null,"80 m",null,"81 m",null,"82 m",null,"83 m",null,"84 m",null,"85 m",null,"86 m",null,"87 m",null,"88 m",null,"89 m",null,"90 m",null,"91 m",null,"92 m",null,"93 m",null,"94 m",null,"95 m",null,"96 m",null,"97 m",null,"98 m",null,"99 m",null,"100 m"]
[null,null,"B",null,null,null,null,"D",null,null," 0\n\n1 m\n\n2 m\n\n3 m\n\n4 m\n\n5 m\n\n6 m\n\n7 m\n\n8 m\n\n9 m\n\n10 m\n\n11 m\n\n12 m\n\n13 m\n\n14 m\n\n15 m\n\n16 m\n\n17 m\n\n18 m\n\n19 m\n\n20 m\n\n21 m\n\n22 m\n\n23 m\n\n24 m\n\n25 m\n\n26 m\n\n27 m\n\n28 m\n\n29 m\n\n30 m\n\n31 m\n\n32 m\n\n33 m\n\n34 m\n\n35 m\n\n36 m\n\n37 m\n\n38 m\n\n39 m\n\n40 m\n\n41 m\n\n42 m\n\n43 m\n\n44 m\n\n45 m\n\n46 m\n\n47 m\n\n48 m\n\n49 m\n\n50 m\n\n51 m\n\n52 m\n\n53 m\n\n54 m\n\n55 m\n\n56 m\n\n57 m\n\n58 m\n\n59 m\n\n60 m\n\n61 m\n\n62 m\n\n63 m\n\n64 m\n\n65 m\n\n66 m\n\n67 m\n\n68 m\n\n69 m\n\n70 m\n\n71 m\n\n72 m\n\n73 m\n\n74 m\n\n75 m\n\n76 m\n\n77 m\n\n78 m\n\n79 m\n\n80 m\n\n81 m\n\n82 m\n\n83 m\n\n84 m\n\n85 m\n\n86 m\n\n87 m\n\n88 m\n\n89 m\n\n90 m\n\n91 m\n\n92 m\n\n93 m\n\n94 m\n\n95 m\n\n96 m\n\n97 m\n\n98 m\n\n 99 m\n\n100 m"]
[null,null,0,null,null,null,null,15833.333333333334,null,null,1]
[null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,"C",null,null,null,null,null,{"$f":"K11+1","v":3}]
[null,null,null,null,5766.666666666667,null,null,null,null,null,{"$f":"K12+1","v":4}]
[null,{"$f":"VLOOKUP(\"Deplacement\",BD!$A$1:$D$200,Listes!$AA$2+1,0)","v":"Déplacement du champs PV"},null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,7]
[null,null," ",null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,null,null,null,66]
[null,null,null,null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K76+1","v":68}]
[null,null,null,null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,null,null,null,100]

{"sheet":"Bon de commande","index":7,"n_rows":99,"n_cols":10,"rows_kept":99,"cut":false,"hidden":true,"merged":[[2,3,2,4],[5,3,5,4],[4,3,4,4],[3,3,3,4],[97,3,97,6],[93,3,93,4],[92,3,92,4],[95,2,95,7],[7,2,7,8],[9,2,9,4],[89,2,89,7],[91,2,91,4]]}
[]
[]
[null,null,{"$f":"TODAY()","v":"2021-01-25"},{"$f":"UPPER(VLOOKUP(\"Adr\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"ADRESSE / CONTACT"},null,{"$f":"UPPER(VLOOKUP(\"DateExp\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"DATE DE LIVRAISON SOUHAITÉE"}]
[]
[null,null,null,null,null,{"$f":"UPPER(VLOOKUP(\"Comment\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"COMMENTAIRES"}]
[]
[]
[null,null,{"$f":"IF(ref_projet<>\"\",ref_projet,\"\")","v":""},null,null,null,null,null,null,0]
[]
[null,null,{"$f":"UPPER(VLOOKUP(\"Ref\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"RÉFÉRENCES"},null,null,{"$f":"UPPER(VLOOKUP(\"NbrPiece\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"NOMBRE DE PIÈCES"},{"$f":"UPPER(VLOOKUP(\"PUHT\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"P.U. (HT)"},{"$f":"UPPER(VLOOKUP(\"PUREM\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"P.U. REMISÉ "},{"$f":"UPPER(VLOOKUP(\"Total\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"TOTAL"}]
[null,"PPAYS",{"$f":"IF(VLOOKUP(v_plaque,BD!$P$2:$R$22,2,0)=0,\"\",VLOOKUP(v_plaque,BD!$P$2:$R$22,2,0))","v":{"$error":"#N/A"}},null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B11,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B11,Calepinage!$O$301:$O$321,0),1),0)","v":0},{"$f":"IFERROR(VLOOKUP(C11,BD!$Q$2:$R$38,2,0),34.15)","v":34.15},34.15,{"$f":"IFERROR(F11*H11,0)","v":0}]
[null,"PPORT",{"$f":"IF(VLOOKUP(v_plaque,BD!$P$23:$R$39,2,0)=0,\"\",VLOOKUP(v_plaque,BD!$P$23:$R$39,2,0))","v":"ART102279"},null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B12,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Plaques Portrait 1710 / 1020"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B12,Calepinage!$O$301:$O$321,0),1),0)","v":0},{"$f":"IFERROR(VLOOKUP(C12,BD!$Q$2:$R$38,2,0),34.15)","v":34.15},34.15,0]
[null,"COINDALUATEC ","ART101379",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B13,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B13,Calepinage!$O$301:$O$321,0),1),0)","v":0},10.62,10.62,{"$f":"IFERROR(F13*H13,0)","v":0}]
[null,"COINDNOIRATEC ","ART101295",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B14,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B14,Calepinage!$O$301:$O$321,0),1),0)","v":0},15.31,15.31,{"$f":"IFERROR(F14*H14,0)","v":0}]
[null,"ANGL_COIN_DROIT_AR ","ART100195",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B15,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B15,Calepinage!$O$301:$O$321,0),1),0)","v":0},22.6,22.6,0]
[null,"COINGALUATEC ","ART100785",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B16,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B16,Calepinage!$O$301:$O$321,0),1),0)","v":0},10.62,10.62,0]
[null,"COINGNOIRATEC ","ART100285",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B17,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B17,Calepinage!$O$301:$O$321,0),1),0)","v":0},15.31,15.31,0]
[null,"ANGL_COIN_GAUCH_AR ","ART101291",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B18,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B18,Calepinage!$O$301:$O$321,0),1),0)","v":0},22.6,22.6,0]
[null,"AFSA2013","ART100695",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B19,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B19,Calepinage!$O$301:$O$321,0),1),0)","v":0},17,17,0]
[null,"AFCUNL1500","ART101041 ",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B20,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Abergement Haut Central Universel Noir L 1500mm"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B20,Calepinage!$O$301:$O$321,0),1),0)","v":0},20.239999999999998,20.239999999999998,0]
[null,"COINDALU2014_15","ART101340",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B21,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B21,Calepinage!$O$301:$O$321,0),1),0)","v":0},13.5,13.5,0]
[null,"COINDNOIR2014_15","ART100574",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B22,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Abergement Angle Haut Droit Universel Noir "},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B22,Calepinage!$O$301:$O$321,0),1),0)","v":0},16.07,16.07,0]
[null,"COINGALU2014_15","ART100862",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B23,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B23,Calepinage!$O$301:$O$321,0),1),0)","v":0},13.5,13.5,0]
[null,"COINGNOIR2014_15","ART100945",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B24,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Abergement Angle Haut Gauche Universel Noir "},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B24,Calepinage!$O$301:$O$321,0),1),0)","v":0},16.07,16.07,0]
[null,"AFJA2013","ART100558",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B25,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B25,Calepinage!$O$301:$O$321,0),1),0)","v":0},4.5,4.5,0]
[null,"AFJUNL375","ART100039",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B26,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Abergement Haut Jonction Universel Noir L 375mm  "},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B26,Calepinage!$O$301:$O$321,0),1),0)","v":0},5.36,5.36,0]
[null,"ABER_HAUT_ATEC_ALU ","ART100441",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B27,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B27,Calepinage!$O$301:$O$321,0),1),0)","v":0},20.309999999999999,20.309999999999999,0]
[null,"ABER_HAUT_ATEC_NOI ","ART100557",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B28,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B28,Calepinage!$O$301:$O$321,0),1),0)","v":0},27.63,27.63,0]
[null,"AB_HAUT_SPEC_ALU",null,null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B29,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B29,Calepinage!$O$301:$O$321,0),1),0)","v":0},17,17,0]
[null,"AB_HAUT_SPEC_NOIR",null,null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B30,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B30,Calepinage!$O$301:$O$321,0),1),0)","v":0},20.239999999999998,20.239999999999998,0]
[null,"ABER_HAUT_ATEC_ARD ",null,null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B31,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B31,Calepinage!$O$301:$O$321,0),1),0)","v":0},22.1,22.1,0]
[null,"AB_HAUT_1001_VA1 ","ART101014",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B32,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B32,Calepinage!$O$301:$O$321,0),1),0)","v":0},22.1,22.1,{"$f":"IFERROR(F32*H32,0)","v":0}]
[null,"AB_HAUT_1046_VA1 ","ART101567",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B33,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B33,Calepinage!$O$301:$O$321,0),1),0)","v":0},22.1,22.1,0]
[null,"AB_HAUT_992_VA1 ","ART100820",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B34,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B34,Calepinage!$O$301:$O$321,0),1),0)","v":0},22.1,22.1,0]
[null,"RACC_ABER_HAUT_ARD ","ART100110",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B35,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B35,Calepinage!$O$301:$O$321,0),1),0)","v":0},4.4000000000000004,4.4000000000000004,0]
[null,"ALAALUDROITATEC ","ART100079",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B36,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B36,Calepinage!$O$301:$O$321,0),1),0)","v":0},13.69,13.69,0]
[null,"ALABLKDROITATEC ","ART100973",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B37,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B37,Calepinage!$O$301:$O$321,0),1),0)","v":0},18.63,18.63,0]
[null,"ABER_LAT_DROIT_ARD ","ART100429",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B38,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B38,Calepinage!$O$301:$O$321,0),1),0)","v":0},13.6,13.6,0]
[null,"ALAALUGAUCHEATEC ","ART100057",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B39,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B39,Calepinage!$O$301:$O$321,0),1),0)","v":0},13.69,13.69,0]
[null,"ALABLKGAUCHEATEC ","ART101030",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B40,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B40,Calepinage!$O$301:$O$321,0),1),0)","v":0},18.63,18.63,0]
[null,"ABER_LAT_GAUCH_AR ","ART100568",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B41,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B41,Calepinage!$O$301:$O$321,0),1),0)","v":0},13.6,13.6,0]
[null,"ALUAP30TUILBRUTRE3","ART100703",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B42,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B42,Calepinage!$O$301:$O$321,0),1),0)","v":0},10.9,10.9,0]
[null,"ALUNP30TUILNOIRRE3","ART100927",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B43,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B43,Calepinage!$O$301:$O$321,0),1),0)","v":0},12.7,12.6,0]
[null,"ALUA","ART100673",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B44,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B44,Calepinage!$O$301:$O$321,0),1),0)","v":0},9.4,9.4,0]
[null,"ALUN","ART100494",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B45,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Abergement Latéral Universel Noir"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B45,Calepinage!$O$301:$O$321,0),1),0)","v":0},11.19,11.19,0]
[null,"CORNIERELAQUEB","ART101409",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B46,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Abergement Haut Cornière Laquée Noire L1400mm (pour la fixation des abergements centraux)"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B46,Calepinage!$O$301:$O$321,0),1),0)","v":0},4.17,4.17,0]
[null,"CORNIERE","ART100867",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B47,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B47,Calepinage!$O$301:$O$321,0),1),0)","v":0},3.5,3.5,0]
[null,"CROCHET","ART100633",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B48,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Crochet de Fixation d'Abergement In Roof"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B48,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.6,0.6,0]
[null,"EDH162014ALU (ASV09-35G)","ART100045",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B49,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B49,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH162014N (ASV09-35V)","ART100482",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B50,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B50,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"EDH162014ALU",null,null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B51,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B51,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH162014N",null,null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B52,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B52,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH192014ALU (ASV-38G)","ART100171",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B53,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B53,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH192014N (ASV-38V)","ART100548",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B54,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B54,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"EDH212014ALU (ASV09-40G)","ART100597",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B55,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B55,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH212014N (ASV09-40V)","ART100744",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B56,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Etrier Double H21 - Acier Inox - Noir - In Roof "},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B56,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"EDH232014ALU (ASV09-42G)","ART101192",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B57,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B57,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH232014N (ASV9-42V)","ART100658",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B58,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B58,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"EDH262014ALU (ASV09-46G)","ART102202",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B59,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B59,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH262014N (ASV09-46V)","ART102335",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B60,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B60,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"EDH272014ALU (ASV09-46G)","ART100006",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B61,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B61,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH272014N (ASV09-46V)","ART100242",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B62,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B62,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"EDH312014ALU (ASV09-50G)","ART101326",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B63,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B63,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.18,1.18,0]
[null,"EDH312014N (ASV09-50V)","ART101288",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B64,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B64,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.4,1.4,0]
[null,"ESH162014ALU (ASV08-35G)","ART100376",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B65,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B65,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH162014N (ASV08-35V)","ART100814",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B66,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B66,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"ESH162014ALU","ART100376",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B67,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B67,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH162014N","ART100814",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B68,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B68,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.02,0]
[null,"ESH192014ALU (ASV08-38G)","ART101152",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B69,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B69,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH192014N (ASV08-38V)","ART101299",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B70,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B70,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"ESH212014ALU (ASV08-40G)","ART101279",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B71,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B71,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH212014N (ASV08-40V)","ART100495",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B72,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Etrier Simple H21 - Acier Inox - Noir - In Roof "},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B72,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"ESH232014ALU (ASV08-42G)","ART101215",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B73,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B73,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH232014N (ASV08-42V)","ART101230",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B74,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B74,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"ESH262014ALU (ASV08-46G)","ART102321",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B75,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B75,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH262014N (ASV08-46V)","ART102328",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B76,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B76,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"ESH272014ALU (ASV08-46G)","ART100063",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B77,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B77,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,0]
[null,"ESH272014N (ASV08-46V)","ART100260",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B78,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B78,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"ESH312014ALU (ASV08-50G)","ART100172",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B79,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B79,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.02,1.02,{"$f":"IFERROR(F79*H79,0)","v":0}]
[null,"ESH312014N (ASV08-50V)","ART100381",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B80,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B80,Calepinage!$O$301:$O$321,0),1),0)","v":0},1.21,1.21,0]
[null,"CALE_GAUCHE","ART100212",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B81,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Cale Gauche de Renfort pour Etriers Simple In Roof"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B81,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.25,0.98,0]
[null,"CALE_DROIT","ART101501",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B82,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Cale Droite de Renfort pour Etriers Simple In Roof"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B82,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.25,0.98,0]
[null,"JOINT_PRE_CONTRAIN","ART101088",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B83,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Joint pré-contraint - 20 x 40 mm (Rouleau de 5.5 m)  "},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B83,Calepinage!$O$301:$O$321,0),1),0)","v":0},10.73,9.74,0]
[null,"CALE_EPDM_CELL","ART101138",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B84,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Cale EPDM Pour Vis In Roof (25x21 EP. 5mm)"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B84,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.08,0.08,0]
[null,"JOINT_MOUSS_TRIAN ",null,null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B85,Calepinage!$O$301:$O$321,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B85,Calepinage!$O$301:$O$321,0),1),0)","v":0},9.74,9.74,0]
[null,"RIVETPOP","ART100389",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B86,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Rivets Pop 4x8 (pour la fixation des cornières)"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B86,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.05,0.05,0]
[null,"VIS2014A","ART100931",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B87,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Vis GSE Integration 6.3mmx60mm Alu"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B87,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.23,0.23,0]
[null,"VIS2014N","ART101552",null,{"$f":"IFERROR(INDEX(Calepinage!$B$301:$O$321,MATCH('Bon de commande'!B88,Calepinage!$O$301:$O$321,0),1),\"\")","v":"Vis GSE Integration 6.3mmx60mm Noir"},{"$f":"IFERROR(INDEX(Calepinage!$A$301:$O$321,MATCH('Bon de commande'!B88,Calepinage!$O$301:$O$321,0),1),0)","v":0},0.27,0.27,0]
[]
[null,null,{"$f":"UPPER(VLOOKUP(\"Total\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"TOTAL"},null,null,null,null,null,{"$f":" SUM(I11:I88)","v":0}]
[]
[null,"TOTAL",{"$f":"UPPER(VLOOKUP(\"Option\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"OPTIONS"},null,null,{"$f":"UPPER(VLOOKUP(\"NbrPiece\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"NOMBRE DE PIÈCES"},{"$f":"UPPER(VLOOKUP(\"PUHT\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"P.U. (HT)"},{"$f":"UPPER(VLOOKUP(\"PUREM\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"P.U. REMISÉ "},{"$f":"UPPER(VLOOKUP(\"Total\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"TOTAL"}]
[null,"BANDE_FLEXALU-500",{"$f":"IF(flex_largeur=1,\"ART100385\",IF(flex_couleur=1,\"ART101405\",\"ART101272\"))","v":"ART101405"},{"$f":"Calepinage!B320","v":"Flexalu Gris Ardoise 500mm L5m Butyle 20/100"},null,{"$f":"Calepinage!A320","v":0},{"$f":"IF(flex_largeur=1,50.85,75.68)","v":75.680000000000007},75.680000000000007,{"$f":"F93*H93","v":0}]
[null,"OPTIONS","ART101292",{"$f":"IF(Calepinage!B321<>\"\",Calepinage!B321,\"\")","v":""},null,{"$f":"IF(Calepinage!A321>0,Calepinage!A321&\" (\"&Calepinage!A323&\" m2)\",0)","v":0},127.12,127.12,{"$f":"Calepinage!A321*H94","v":0}]
[]
[null,null,{"$f":"UPPER(VLOOKUP(\"Total\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"TOTAL"},null,null,null,null,null,{"$f":"I90+I93+I94","v":0}]
[]
[null,null,null,{"$f":"UPPER(VLOOKUP(\"NotePriceOpt\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"NB : PRIX DISPONIBLE AUPRÈS DE VOTRE INTERLOCUTEUR HABITUEL."}]
[null,null,null,{"$f":"UPPER(VLOOKUP(\"WebLink1\",BD!$A$1:$D$200,Listes!$AA$2+1,0))","v":"POUR PLUS D’INFORMATION SUR LE PRODUIT : WWW.GSEINTEGRATION.COM"}]