{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Calcul Surface","Gencode","Devis Bard Monoparoi M","Devis Bard Alveolaire Clic","Devis Bard Clair Voie","Parrainage"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calcul Surface","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[17,4,22,9],[0,1,0,9],[16,1,16,2],[16,4,16,9],[11,7,13,7],[11,1,11,4],[12,1,12,4],[13,1,13,4]]}
[null,"Lames composite pour BARDAGE Green Outside"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INFOS à renseigner…"]
[]
[null,"Longueur de la façade à couvrir en m.l.",null,null,null,6,"Marge de ",0.05]
[null,"Hauteur de la façade à couvrir en m.l.",null,null,null,3,"Sécurité : "]
[null,"Dimension peripherie pour finition en m.l.",null,null,null,18]
[null,null,null,null,null,null,null,"           5 à 8%  recommandé"]
[]
[null,"COLORIS à choisir",null,null,"CHOIX de votre lame de Bardage "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Green Outside : Lames composite de qualité supérieure"]
[null,null,null,"60% bois recyclés, 35% PEHD, 5% adjuvants sélectionnés"]
[]
[null,null,null,"Livraison directe domicile clients possible sous 15 -20 jours "]
[]
[null,null,null,"Pour tout renseignement : ",null,null,"secretariat@green-outside.com"]
[]
[null,null,null,"Pour tout suivi de livraison, tel : 04 74 55 36 54"]

{"sheet":"Gencode","index":1,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,1,1,1],[0,0,1,0],[0,3,1,3]]}
["Lame Bardage Composite \nGreen Outside","Gencode",null,"Prix généralement constatés"]
[null,null,"Prix TTC"]
["Lame Bardage Clin-Clic Chocolat 2600x146x21 mm",3760055271189,15.9,16]
["Lame Bardage Clin-Clic Gris 2600x146x21 mm",3760055271196,15.9,16]
["Lame Bardage Clin-Clic Anthracite 2600x146x21 mm",3760055271202,15.9,16]
["Lame Bardage Clin-Clic Beige 2600x146x21 mm",3760055271530,15.9,16]
["Rail de fixation pour bardage Clin Clic 98mm",3760055271226,4.9000000000000004,4.9000000000000004]
[" "," ",0]
["Lame Bardage Monoparoi Chocolat 2600x156x21 mm",3760055270595,15.9,16]
["Lame Bardage Monoparoi Gris 2600x156x21 mm",3760055270601,15.9,16]
["Lame Bardage Monoparoi Anthracite 2600x156x21 mm",3760055270618,15.9,16]
["Lame Bardage Monoparoi Beige 2600x156x21 mm",3760055271547,15.9,16]
[null,null,0]
["tasseau bois classe IV 27x45x2500 mm","?",0,0]
["tasseau bois classe IV 32x32x2000 mm","?",0,0]
[" "," ",0," "]
["Profil de départ Galva 40 x 15 x 2000 mm","?",0,0]
["Profil d'aération anti-rongeur 30 x 30 x 2000 mm","?",0,0]
["Film pare pluie HPV R2 rouleau 30m x 1m","?",0,0]
[" "," ",0]
["Cornière de finition Chocolat 30 x 50 x 2200 mm",3760055270144,8.9,6.9]
["Cornière de finition Gris clair 30 x 50 x 2200 mm",3760055270151,8.9,6.9]
["Cornière de finition Anthracite 30 x 50 x 2200 mm",3760055270663,8.9,6.9]
["Cornière de finition Beige 30 x 50 x 2200 mm",3760055271554,8.9,6.9]
[]
["Plat de finition Chocolat 30 x 50 x 2200 mm",3760055270168,8.9,6.9]
["Plat de finition Gris clair 30 x 50 x 2200 mm",3760055270175,8.9,6.9]
["Plat de finition Anthracite 30 x 50 x 2200 mm",3760055270502,8.9,6.9]
["Plat de finition Beige 30 x 50 x 2200 mm",3760055271561,8.9,6.9]
[]
["Lame Bardage Clair Voie Anthracite 2600x219x26mm",3760055272056,25.9,25.9]
["Lame Bardage Clair Voie Gris 2600x219x26mm",3760055272063,25.9,25.9]
["Lame Bardage Clair Voie bois cérusé 2600x219x26mm",3760055272070,25.9,25.9]
["Lame Bardage Clair Voie Antique 2600x219x26mm",3760055272087,25.9,25.9]

{"sheet":"Devis Bard Monoparoi M","index":2,"n_rows":133,"n_cols":9,"rows_kept":133,"cut":false,"hidden":false,"merged":[[0,1,1,5],[17,3,18,3],[19,1,20,2],[17,1,18,2],[19,3,20,5],[17,4,18,4],[24,1,24,4],[21,4,21,5],[32,1,34,2],[46,1,46,5],[34,3,34,4],[32,3,33,5],[92,1,92,5],[29,3,29,4],[30,3,30,4],[91,1,91,5],[89,1,89,5],[90,1,90,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5]]}
[null,"Bardage composite Green Outside \nPose sur tasseaux bois classe IV selon DTU 41.2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Surface Totale (selon dimensions page 1)",null,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13","v":18},"m²"]
[]
[null,"Lame bardage composite MONO PAROI",null,"BEIGE"]
[]
[null,"Références nécessaires pour le projet soumis","Gencode","Qté","Prix TTC généralement constaté"]
[null,{"$f":"B120","v":"Lame Bardage Monoparoi Beige 2600x156x21 mm"},{"$f":"VLOOKUP(B23,B117:C122,2,FALSE)","v":3760055271547},{"$f":"VLOOKUP(B23,B117:D122,3,FALSE)","v":55},{"$f":"VLOOKUP(B23,B117:E122,4,FALSE)","v":15.9},{"$f":"VLOOKUP(B23,B117:G120,6,FALSE)","v":874.5}]
[null,{"$f":"B133","v":"Cornière de finition Beige 30 x 50 x 2200 mm"},{"$f":"VLOOKUP(B24,B130:C133,2,FALSE)","v":3760055271554},{"$f":"VLOOKUP(C24,C130:D133,2,FALSE)","v":9},{"$f":"VLOOKUP(D24,D130:E133,2,FALSE)","v":8.9},{"$f":"VLOOKUP(B24,B130:G133,6,FALSE)","v":80.100000000000009}]
[null,"Pour la mise en œuvre de votre bardage composite, vous aurez besoin des produits complémentaires suivant:",null,null,null,"-"]
[null,"Tasseaux bois classe IV existe en 27 x 45 x 2500 mm",{"$f":"VLOOKUP(B26,B123:C128,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B26,B123:G127,3,FALSE)","v":22},{"$f":"VLOOKUP(C26,C123:H127,3,FALSE)","v":0},{"$f":"VLOOKUP(B26,B123:G128,6,FALSE)","v":0}]
[null,"Profil de départ Galva existe en 40 x 15 x 2000 mm",{"$f":"VLOOKUP(B27,B126:C128,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B27,B126:D128,3,FALSE)","v":12},{"$f":"VLOOKUP(B27,B126:E128,4,FALSE)","v":0},{"$f":"VLOOKUP(B27,B126:G129,6,FALSE)","v":0}]
[null,"Grille d'aération anti-rongeur existe en 30 x 30 x 2000 mm",{"$f":"VLOOKUP(B28,B127:C129,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B28,B127:D129,3,FALSE)","v":12},{"$f":"VLOOKUP(B28,B127:E129,4,FALSE)","v":0},{"$f":"VLOOKUP(B28,B126:G129,6,FALSE)","v":0}]
[null,"Film pare pluie existe en rouleau 30m x 1m",{"$f":"VLOOKUP(B29,B126:C128,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B29,B126:D128,3,FALSE)","v":1},{"$f":"VLOOKUP(B29,B126:E128,4,FALSE)","v":0},{"$f":"VLOOKUP(B29,B126:G129,6,FALSE)","v":0}]
[null,null,null,"Total TTC",null,{"$f":"F23+F24+F27+F28+F26+F29","v":954.6}]
[null,null,null,"soit prix /m²",null,{"$f":"F30/D18","v":53.033333333333331}]
[]
[null,null,null,"devis quantitatif selon données client, rapprochez vous de votre magasin pour une validation tarifaire."]
[]
[null,null,null,"fait depuis le site Web Green Outside le",null,{"$f":"TODAY()","v":"2020-07-27"}]
[]
[null,"Il revient au client final de vérifier que les quantités proposées correspondent bien à ses besoins au moment de valider sa commande."]
[null,"Seules les références Green Outside peuvent être prises en compte pour les commandes en livraison directe chez le client."]
[null,"Pour la fixation des profils de finition, un pré-percage est nécessaire avant vissage, sinon, vous risquez de fendre le profil."]
[null,"Besoin de quantité produits et prix indiqués à titre indicatif. "]
[]
[]
[]
[]
[]
[]
[]
[null,"Retrouvez nous sur www.green-outside.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Et pour completer  vos travaux d'aménagement, "]
[null,"retrouvez nos lames de terrasse   ."]
[]
[null,"Lame de Terrasse Alvéolaire -- Lame de Terrasse PLEINE  -- Lame de Terrasse Extra-Protect"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"lame Bardage Green Outside","code","qqte",null,"prix unitaire","total ttc"]
[]
[null,{"$f":"Gencode!A9","v":"Lame Bardage Monoparoi Chocolat 2600x156x21 mm"},{"$f":"Gencode!B9","v":3760055270595},{"$f":"ROUNDUP(H117,0)","v":55},{"$f":"Gencode!C9","v":15.9},{"$f":"E117","v":15.9},{"$f":"F117*D117","v":874.5},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I117","v":54.247990815154992},{"$f":"(1/(2.6*0.134))*(1+'Calcul Surface'!$H$12)","v":3.0137772675086105}]
[null,{"$f":"Gencode!A10","v":"Lame Bardage Monoparoi Gris 2600x156x21 mm"},{"$f":"Gencode!B10","v":3760055270601},55,{"$f":"Gencode!C10","v":15.9},{"$f":"E118","v":15.9},{"$f":"F118*D118","v":874.5},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I117","v":54.247990815154992}]
[null,{"$f":"Gencode!A11","v":"Lame Bardage Monoparoi Anthracite 2600x156x21 mm"},{"$f":"Gencode!B11","v":3760055270618},55,{"$f":"Gencode!C11","v":15.9},15.9,874.5,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I117","v":54.247990815154992}]
[null,{"$f":"Gencode!A12","v":"Lame Bardage Monoparoi Beige 2600x156x21 mm"},{"$f":"Gencode!B12","v":3760055271547},55,{"$f":"Gencode!C12","v":15.9},15.9,874.5,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I117","v":54.247990815154992}]
[null," "," "," ",null,null,null," "]
[null," "," "," ",null,null,null," "]
[null,"Tasseaux bois classe IV existe en 27 x 45 x 2500 mm","A voir en magasin",22,{"$f":"Gencode!C14","v":0},0,0,{"$f":"I123/2.5","v":21.42},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13))+('Calcul Surface'!F12*2))*(1+'Calcul Surface'!$H$12)","v":53.550000000000004}]
[null,"Tasseau bois classe IV 32 x 32 x 2000 mm","A voir en magasin",27,{"$f":"Gencode!C15","v":0},0,0,{"$f":"I124/2","v":26.775000000000002},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13))+('Calcul Surface'!F12*2))*(1+'Calcul Surface'!$H$12)","v":53.550000000000004}]
[null," "," "," ",null,null,null," "]
[null,"Profil de départ Galva existe en 40 x 15 x 2000 mm","A voir en magasin",12,{"$f":"Gencode!C17","v":0},0,0,{"$f":"('Calcul Surface'!F12*2)","v":12}]
[null,"Grille d'aération anti-rongeur existe en 30 x 30 x 2000 mm","A voir en magasin",12,{"$f":"Gencode!C18","v":0},0,0,{"$f":"('Calcul Surface'!F12*2)","v":12}]
[null,"Film pare pluie existe en rouleau 30m x 1m","A voir en magasin",1,{"$f":"Gencode!C19","v":0},0,0,{"$f":"I128/30","v":0.6},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13","v":18}]
[null," "," "," ",null,null,null," "]
[null,{"$f":"Gencode!A21","v":"Cornière de finition Chocolat 30 x 50 x 2200 mm"},{"$f":"Gencode!B21","v":3760055270144},9,{"$f":"Gencode!C21","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,{"$f":"Gencode!A22","v":"Cornière de finition Gris clair 30 x 50 x 2200 mm"},{"$f":"Gencode!B22","v":3760055270151},9,{"$f":"Gencode!C22","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,{"$f":"Gencode!A23","v":"Cornière de finition Anthracite 30 x 50 x 2200 mm"},{"$f":"Gencode!B23","v":3760055270663},9,{"$f":"Gencode!C23","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,{"$f":"Gencode!A24","v":"Cornière de finition Beige 30 x 50 x 2200 mm"},{"$f":"Gencode!B24","v":3760055271554},9,{"$f":"Gencode!C24","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]

{"sheet":"Devis Bard Alveolaire Clic","index":3,"n_rows":138,"n_cols":9,"rows_kept":138,"cut":false,"hidden":false,"merged":[[50,1,50,5],[49,1,49,5],[25,1,25,4],[33,3,34,5],[33,1,35,2],[47,1,47,5],[90,1,90,5],[21,4,21,5],[0,1,1,5],[17,3,18,3],[19,1,20,2],[19,3,20,5],[17,1,18,2],[30,3,30,4],[31,3,31,4],[17,4,18,4],[87,1,87,5],[88,1,88,5],[89,1,89,5],[46,1,46,5],[48,1,48,5],[35,3,35,4]]}
[null,"Bardage composite Green Outside \nPose sur rails et tasseaux bois classe IV selon DTU 41.2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Surface Totale selon dimensions page 1",null,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13","v":18},"m²"]
[]
[null,"Lame bardage Alvéolaire CLIN CLIC",null,"BEIGE"]
[]
[null,null,"Gencode","Qté","Prix TTC généralement constaté"]
[null,{"$f":"B125","v":"Lame Bardage Clin-Clic Beige 2600x146x21 mm"},{"$f":"VLOOKUP(B23,B122:C127,2,FALSE)","v":3760055271530},{"$f":"VLOOKUP(B23,B122:D127,3,FALSE)","v":51},{"$f":"VLOOKUP(B23,B122:G125,5,FALSE)","v":15.9},{"$f":"VLOOKUP(B23,B122:G125,6,FALSE)","v":810.9}]
[null,"Rail de fixation pour bardage Clin Clic 98mm",{"$f":"VLOOKUP(B24,B122:C126,2,FALSE)","v":3760055271226},{"$f":"VLOOKUP(B24,B122:D127,3,FALSE)","v":41},{"$f":"VLOOKUP(B24,B123:G126,5,FALSE)","v":4.9000000000000004},{"$f":"VLOOKUP(B24,B123:G126,6,FALSE)","v":200.9}]
[null,{"$f":"B138","v":"Cornière de finition Beige 30 x 50 x 2200 mm"},{"$f":"VLOOKUP(B25,B134:C138,2,FALSE)","v":3760055271554},{"$f":"VLOOKUP(B25,B134:D139,3,FALSE)","v":9},{"$f":"VLOOKUP(B25,B135:G138,5,FALSE)","v":8.9},{"$f":"VLOOKUP(B25,B135:G138,6,FALSE)","v":80.100000000000009}]
[null,"Pour la mise en œuvre de votre bardage composite, vous aurez besoin des produits complémentaires suivant:"]
[null,"Tasseaux bois classe IV existe en 27 x 45 x 2500 mm",{"$f":"VLOOKUP(B27,B128:G133,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B27,B128:G133,3,FALSE)","v":22},{"$f":"VLOOKUP(B27,B125:G133,5,FALSE)","v":0},{"$f":"VLOOKUP(B27,B123:G128,6,FALSE)","v":0}]
[null,"Profil de départ Galva existe en 40 x 15 x 2000 mm",{"$f":"VLOOKUP(B28,B128:G134,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B28,B129:G134,3,FALSE)","v":12},{"$f":"VLOOKUP(B28,B126:G134,5,FALSE)","v":0},{"$f":"VLOOKUP(B28,B127:G135,6,FALSE)","v":0}]
[null,"Grille d'aération anti-rongeur existe en 30 x 30 x 2000 mm",{"$f":"VLOOKUP(B29,B131:C133,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B29,B130:G135,3,FALSE)","v":12},{"$f":"VLOOKUP(B29,B127:G135,5,FALSE)","v":0},{"$f":"VLOOKUP(B29,B128:G136,6,FALSE)","v":0}]
[null,"Film pare pluie existe en rouleau 30m x 1m",{"$f":"VLOOKUP(B30,B130:H133,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B30,B131:G136,3,FALSE)","v":1},{"$f":"VLOOKUP(B30,B128:G136,5,FALSE)","v":0},{"$f":"VLOOKUP(B30,B129:G137,6,FALSE)","v":0}]
[null,null,null,"Total TTC",null,{"$f":"F23+F26+F27+F28+F30+F24+F29+F25","v":1091.8999999999999}]
[null,null,null,"soit prix /m²",null,{"$f":"F31/D18","v":60.661111111111104}]
[]
[null,null,null,"devis quantitatif selon données client, rapprochez vous de votre magasin pour une validation tarifaire."]
[]
[null,null,null,"fait depuis le site Web Green Outside le",null,{"$f":"TODAY()","v":"2020-07-27"}]
[]
[null,"Il revient au client final de vérifier que les quantités proposées correspondent bien à ses besoins au moment de valider sa commande."]
[null,"Seules les références Green Outside peuvent être prises en compte pour les commandes en livraison directe chez le client."]
[null,"Pour la fixation des profils de finition, un pré-percage est nécessaire avant vissage, sinon, vous risquez de fendre le profil."]
[null,"Besoin de quantité produits et prix indiqués à titre indicatif. "]
[]
[]
[]
[]
[]
[null,"Retrouvez nous sur www.green-outside.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Et pour completer  vos travaux d'aménagement, "]
[null,"retrouvez nos lames de terrasse   ."]
[]
[null,"Lame de Terrasse Alvéolaire -- Lame de Terrasse PLEINE  -- Lame de Terrasse Extra-Protect"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"lame Bardage Green Outside","code","qqte",null,"prix unitaire","total ttc"]
[]
[null,{"$f":"Gencode!A3","v":"Lame Bardage Clin-Clic Chocolat 2600x146x21 mm"},{"$f":"Gencode!B3","v":3760055271189},{"$f":"ROUNDUP(H122,0)","v":51},{"$f":"Gencode!C3","v":15.9},{"$f":"E122","v":15.9},{"$f":"F122*D122","v":810.9},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":50.132625994694962},{"$f":"(1/(2.6*0.145))*(1+'Calcul Surface'!$H$12)","v":2.7851458885941645}]
[null,{"$f":"Gencode!A4","v":"Lame Bardage Clin-Clic Gris 2600x146x21 mm"},{"$f":"Gencode!B4","v":3760055271196},51,{"$f":"Gencode!C4","v":15.9},15.9,{"$f":"F123*D123","v":810.9},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":50.132625994694962}]
[null,{"$f":"Gencode!A5","v":"Lame Bardage Clin-Clic Anthracite 2600x146x21 mm"},{"$f":"Gencode!B5","v":3760055271202},51,{"$f":"Gencode!C5","v":15.9},15.9,810.9,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":50.132625994694962}]
[null,{"$f":"Gencode!A6","v":"Lame Bardage Clin-Clic Beige 2600x146x21 mm"},{"$f":"Gencode!B6","v":3760055271530},51,{"$f":"Gencode!C6","v":15.9},15.9,810.9,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":50.132625994694962}]
[null,{"$f":"Gencode!A7","v":"Rail de fixation pour bardage Clin Clic 98mm"},{"$f":"Gencode!B7","v":3760055271226},41,{"$f":"Gencode!C7","v":4.9000000000000004},4.9000000000000004,200.9,{"$f":"I126","v":40.950000000000003},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13)))*(1+'Calcul Surface'!$H$12)","v":40.950000000000003}]
[null," "," "," ",null,null,null," "]
[null,"Tasseaux bois classe IV existe en 27 x 45 x 2500 mm","A voir en magasin",22,{"$f":"Gencode!C14","v":0},{"$f":"E128","v":0},0,{"$f":"I128/2.5","v":21.42},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13))+('Calcul Surface'!F12*2))*(1+'Calcul Surface'!$H$12)","v":53.550000000000004}]
[null,"Tasseau bois classe IV 32 x 32 x 2000 mm","A voir en magasin",27,{"$f":"Gencode!C15","v":0},0,0,{"$f":"I129/2","v":26.775000000000002},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13))+('Calcul Surface'!F12*2))*(1+'Calcul Surface'!$H$12)","v":53.550000000000004}]
[null," "," "," ",{"$f":"Gencode!C16","v":0},0,null," "]
[null,"Profil de départ Galva existe en 40 x 15 x 2000 mm","A voir en magasin",12,{"$f":"Gencode!C17","v":0},0,0,{"$f":"('Calcul Surface'!F12*2)","v":12}]
[null,"Grille d'aération anti-rongeur existe en 30 x 30 x 2000 mm","A voir en magasin",12,{"$f":"Gencode!C18","v":0},0,0,{"$f":"('Calcul Surface'!F12*2)","v":12}]
[null,"Film pare pluie existe en rouleau 30m x 1m","A voir en magasin",1,{"$f":"Gencode!C19","v":0},0,0,{"$f":"I133/30","v":0.6},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13","v":18}]
[null,{"$f":"Gencode!A20","v":" "},{"$f":"Gencode!B20","v":" "}," ",null,null,null," "]
[null,{"$f":"Gencode!A21","v":"Cornière de finition Chocolat 30 x 50 x 2200 mm"},{"$f":"Gencode!B21","v":3760055270144},9,{"$f":"Gencode!C21","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,{"$f":"Gencode!A22","v":"Cornière de finition Gris clair 30 x 50 x 2200 mm"},{"$f":"Gencode!B22","v":3760055270151},9,{"$f":"Gencode!C22","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,{"$f":"Gencode!A23","v":"Cornière de finition Anthracite 30 x 50 x 2200 mm"},{"$f":"Gencode!B23","v":3760055270663},9,{"$f":"Gencode!C23","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,{"$f":"Gencode!A24","v":"Cornière de finition Beige 30 x 50 x 2200 mm"},{"$f":"Gencode!B24","v":3760055271554},9,{"$f":"Gencode!C24","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]

{"sheet":"Devis Bard Clair Voie","index":4,"n_rows":138,"n_cols":9,"rows_kept":138,"cut":false,"hidden":false,"merged":[[46,1,46,5],[0,1,1,5],[17,1,18,2],[17,3,18,3],[17,4,18,4],[19,1,20,2],[19,3,20,5],[33,1,35,2],[21,4,21,5],[25,1,25,4],[30,3,30,4],[31,3,31,4],[33,3,34,5],[35,3,35,4],[89,1,89,5],[90,1,90,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[87,1,87,5],[88,1,88,5]]}
[null,"Bardage composite Green Outside \nPose sur rails et tasseaux bois classe IV selon DTU 41.2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Surface Totale (selon dimensions page 1)",null,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13","v":18},"m²"]
[]
[null,"Lame bardage Coextrusion CLAIR VOIE",null,"ANTIQUE (crème)"]
[]
[null,"Références nécessaires pour le projet soumis","Gencode","Qté","Prix TTC généralement constaté"]
[null,{"$f":"B125","v":"Lame Bardage Clair Voie Antique 2600x219x26mm"},{"$f":"VLOOKUP(B23,B122:C127,2,FALSE)","v":3760055272087},{"$f":"VLOOKUP(B23,B122:D127,3,FALSE)","v":37},{"$f":"VLOOKUP(B23,B122:G125,5,FALSE)","v":25.9},{"$f":"VLOOKUP(B23,B122:G125,6,FALSE)","v":958.3}]
[]
[null,{"$f":"B138","v":"Cornière coextrudée antique (crème) 57x57x2200 mm"},{"$f":"VLOOKUP(B25,B134:C138,2,FALSE)","v":3760055272124},{"$f":"VLOOKUP(B25,B134:D139,3,FALSE)","v":9},{"$f":"VLOOKUP(B25,B135:G138,5,FALSE)","v":8.9},{"$f":"VLOOKUP(B25,B135:G138,6,FALSE)","v":80.100000000000009}]
[null,"Pour la mise en œuvre de votre bardage composite, vous aurez besoin des produits complémentaires suivant:"]
[null,"Tasseaux bois classe IV existe en 27 x 45 x 2500 mm",{"$f":"VLOOKUP(B27,B128:G133,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B27,B128:G133,3,FALSE)","v":22},{"$f":"VLOOKUP(B27,B125:G133,5,FALSE)","v":0},{"$f":"VLOOKUP(B27,B123:G128,6,FALSE)","v":0}]
[null,"Profil de départ Galva existe en 40 x 15 x 2000 mm",{"$f":"VLOOKUP(B28,B128:G134,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B28,B129:G134,3,FALSE)","v":12},{"$f":"VLOOKUP(B28,B126:G134,5,FALSE)","v":0},{"$f":"VLOOKUP(B28,B127:G135,6,FALSE)","v":0}]
[null,"Grille d'aération anti-rongeur existe en 30 x 30 x 2000 mm",{"$f":"VLOOKUP(B29,B131:C133,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B29,B130:G135,3,FALSE)","v":12},{"$f":"VLOOKUP(B29,B127:G135,5,FALSE)","v":0},{"$f":"VLOOKUP(B29,B128:G136,6,FALSE)","v":0}]
[null,"Film pare pluie existe en rouleau 30m x 1m",{"$f":"VLOOKUP(B30,B130:H133,2,FALSE)","v":"A voir en magasin"},{"$f":"VLOOKUP(B30,B131:G136,3,FALSE)","v":1},{"$f":"VLOOKUP(B30,B128:G136,5,FALSE)","v":0},{"$f":"VLOOKUP(B30,B129:G137,6,FALSE)","v":0}]
[null,null,null,"Total TTC",null,{"$f":"F23+F26+F27+F28+F30+F24+F29+F25","v":1038.3999999999999}]
[null,null,null,"soit prix /m²",null,{"$f":"F31/D18","v":57.688888888888883}]
[]
[null,null,null,"devis quantitatif selon données client, rapprochez vous de votre magasin pour une validation tarifaire."]
[]
[null,null,null,"fait depuis le site Web Green Outside le",null,{"$f":"TODAY()","v":"2020-07-27"}]
[]
[null,"Il revient au client final de vérifier que les quantités proposées correspondent bien à ses besoins au moment de valider sa commande."]
[null,"Seules les références Green Outside peuvent être prises en compte pour les commandes en livraison directe chez le client."]
[null,"Pour la fixation des profils de finition, un pré-percage est nécessaire avant vissage, sinon, vous risquez de fendre le profil."]
[null,"Besoin de quantité produits et prix indiqués à titre indicatif. "]
[]
[]
[]
[]
[]
[null,"Retrouvez nous sur www.green-outside.com"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Et pour completer  vos travaux d'aménagement, "]
[null,"retrouvez nos lames de terrasse   ."]
[]
[null,"Lame de Terrasse Alvéolaire -- Lame de Terrasse PLEINE  -- Lame de Terrasse Extra-Protect"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"lame Bardage Green Outside","code","qqte",null,"prix unitaire","total ttc"]
[]
[null,{"$f":"Gencode!A33","v":"Lame Bardage Clair Voie bois cérusé 2600x219x26mm"},{"$f":"Gencode!B31","v":3760055272056},{"$f":"ROUNDUP(H122,0)","v":37},{"$f":"Gencode!C31","v":25.9},{"$f":"E122","v":25.9},{"$f":"F122*D122","v":958.3},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":36.346153846153847},{"$f":"(1/(2.6*0.2))*(1+'Calcul Surface'!$H$12)","v":2.0192307692307692}]
[null,{"$f":"Gencode!A32","v":"Lame Bardage Clair Voie Gris 2600x219x26mm"},{"$f":"Gencode!B32","v":3760055272063},37,{"$f":"Gencode!C32","v":25.9},25.9,{"$f":"F123*D123","v":958.3},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":36.346153846153847}]
[null,{"$f":"Gencode!A31","v":"Lame Bardage Clair Voie Anthracite 2600x219x26mm"},{"$f":"Gencode!B33","v":3760055272070},37,{"$f":"Gencode!C33","v":25.9},25.9,958.3,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":36.346153846153847}]
[null,{"$f":"Gencode!A34","v":"Lame Bardage Clair Voie Antique 2600x219x26mm"},{"$f":"Gencode!B34","v":3760055272087},37,{"$f":"Gencode!C34","v":25.9},25.9,958.3,{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13*I122","v":36.346153846153847}]
[null,null,null,null,null,null,0]
[null," "," "," ",null,null,null," "]
[null,"Tasseaux bois classe IV existe en 27 x 45 x 2500 mm","A voir en magasin",22,{"$f":"Gencode!C14","v":0},{"$f":"E128","v":0},0,{"$f":"I128/2.5","v":21.42},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13))+('Calcul Surface'!F12*2))*(1+'Calcul Surface'!$H$12)","v":53.550000000000004}]
[null,"Tasseau bois classe IV 32 x 32 x 2000 mm","A voir en magasin",27,{"$f":"Gencode!C15","v":0},0,0,{"$f":"I129/2","v":26.775000000000002},{"$f":"(((('Calcul Surface'!F12/0.5)+1)*('Calcul Surface'!F13))+('Calcul Surface'!F12*2))*(1+'Calcul Surface'!$H$12)","v":53.550000000000004}]
[null," "," "," ",{"$f":"Gencode!C16","v":0},0,null," "]
[null,"Profil de départ Galva existe en 40 x 15 x 2000 mm","A voir en magasin",12,{"$f":"Gencode!C17","v":0},0,0,{"$f":"('Calcul Surface'!F12*2)","v":12}]
[null,"Grille d'aération anti-rongeur existe en 30 x 30 x 2000 mm","A voir en magasin",12,{"$f":"Gencode!C18","v":0},0,0,{"$f":"('Calcul Surface'!F12*2)","v":12}]
[null,"Film pare pluie existe en rouleau 30m x 1m","A voir en magasin",1,{"$f":"Gencode!C19","v":0},0,0,{"$f":"I133/30","v":0.6},{"$f":"'Calcul Surface'!F12*'Calcul Surface'!F13","v":18}]
[null,{"$f":"Gencode!A20","v":" "},{"$f":"Gencode!B20","v":" "}," ",null,null,null," "]
[null,"Cornière coextrudée bois cérusé 57x57x2200 mm",3760055272117,9,{"$f":"Gencode!C21","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,"Cornière coextrudée gris 57x57x2200 mm",3760055272100,9,{"$f":"Gencode!C22","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,"Cornière coextrudée anthracite 57x57x2200 mm",3760055272094,9,{"$f":"Gencode!C23","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]
[null,"Cornière coextrudée antique (crème) 57x57x2200 mm",3760055272124,9,{"$f":"Gencode!C24","v":8.9},8.9,80.100000000000009,{"$f":"('Calcul Surface'!F14/2.2)*(1+'Calcul Surface'!$H$12)","v":8.5909090909090917}]

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