{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Liste de Prix","Bon de Commande","Detaile Mur 5-8","Detaile Mur 9-12","Detaile Mur 1-4","Sommaire","Transport","Ouvertures","Example","Débuter","Notes","Data"],"not_rendered":{"charts":1,"images":42,"macros":1,"external_links":0,"defined_names":7,"comments":6,"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":"Liste de Prix","index":0,"n_rows":56,"n_cols":22,"rows_kept":56,"cut":false,"hidden":true,"merged":[[54,1,54,2],[53,0,53,2],[0,13,0,15],[0,16,0,18],[0,19,0,21],[46,0,46,2],[1,13,1,15],[1,16,1,18],[1,19,1,21]]}
[null,null,null,null,"Price #",{"$f":"IF(Data!Z71=TRUE,3,IF(Data!Z70=TRUE,2,1))","v":1},null,null,null,null,null,null,null,"Prix 1",null,null,"Prix 2",null,null,"Prix 3"]
["Cocher pour inclure dans ",null,null,null,null,null,"Qty / Bdl.","Sq./Feet","Weight","Sq.Ft./ Bdl."," Ship.Size ","Waste %","Prix","Majoration Prix 1",null,null,"Majoration Prix 2",null,null,"Majoration Prix 3"]
["la page sommaire",null,null,null,null,null,null,null,null,null,"(Cu/ Ft.)",null,"Coûtant","% Majoré",null,"Totale","% Majoré",null,"Totale","% Majoré",null,"Totale"]
[true,null,"Panneau Standard",null,{"$f":"IF(A4=TRUE,Data!R44,0)","v":0},{"$f":"Sommaire!J32*K4","v":0},18,4.08,2.38,36.72,15.63,{"$f":"D54","v":3.5000000000000003E-2},0,0,{"$f":"IF(M4>=0,M4*N4,0)","v":0},{"$f":"ROUNDUP(M4+O4,2)","v":0},1,{"$f":"IF(M4>=0,M4*Q4,0)","v":0},{"$f":"ROUNDUP(M4+R4,2)","v":0},0,{"$f":"IF(M4>=0,M4*T4,0)","v":0},{"$f":"ROUNDUP(M4+U4,2)","v":0}]
[true,null,"Coin 90 Deg. (6\") (Int. & Ext.)",null,{"$f":"IF(A5=TRUE,Data!R47,0)","v":0},{"$f":"Sommaire!J33*K5","v":0},8,4.16,3.87,33.28,13.37,null,0,0,{"$f":"IF(M5>=0,M5*N5,0)","v":0},{"$f":"ROUNDUP(M5+O5,2)","v":0},0,{"$f":"IF(M5>=0,M5*Q5,0)","v":0},{"$f":"ROUNDUP(M5+R5,2)","v":0},0,{"$f":"IF(M5>=0,M5*T5,0)","v":0},{"$f":"ROUNDUP(M5+U5,2)","v":0}]
[true,null,"Coin 90 Deg. (8\") (Int. & Ext.)",null,{"$f":"IF(A6=TRUE,Data!R49,0)","v":0},{"$f":"Sommaire!J34*K6","v":0},8,4.51,4,36.08,18.87,null,0,0,0,0,0,0,0,0,0,0]
[false,null,"Coin 90 Deg. (10\") Future",null,0,{"$f":"Sommaire!J35*K7","v":0},8,"(Future)",null,null,null,null,0,0,{"$f":"IF(M7>=1,M7*N7,0)","v":0},0,0,0,0,0,0,0]
[true,null,"Mur en T (Coin 90 Deg. Intérieur)",null,{"$f":"IF(A8=TRUE,Data!R51,0)","v":0},{"$f":"Sommaire!J36*K8","v":0},16,null,null,null,10.74,null,0,0,{"$f":"IF(M8>=0,M8*N8,0)","v":0},0,0,0,0,0,0,0]
[true,null,"Coin 45 Deg. (Intérieur)",null,{"$f":"IF(A9=TRUE,Data!S52,0)","v":0},{"$f":"Sommaire!J37*K9","v":0},16,2.21,3.25,35.36,10.58,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Coin 45 Deg. (Extérieur)",null,{"$f":"IF(A10=TRUE,Data!S52,0)","v":0},{"$f":"Sommaire!J38*K10","v":0},16,2.99,3.5,47.84,15.31,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Panneau d'Assise - Brique",null,{"$f":"IF(A11=TRUE,Data!R42,0)","v":0},{"$f":"Sommaire!J39*K11","v":0},8,4.08,2.2999999999999998,32.64,17.28,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Panneau Biseauté",null,{"$f":"IF(A12=TRUE,Data!R43,0)","v":0},{"$f":"Sommaire!J40*K12","v":0},18,4.08,1.94,36.72,15.63,null,0,0,0,0,0,0,0,0,0,0]
[false,null,"IntegraBuck - Closoir - 4\" (Discontinué)",null,{"$f":"IF(A13=TRUE,Data!T34,0)","v":0},{"$f":"Sommaire!J41*K13","v":0},80,null,0.28000000000000003,null,5.6,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"IntegraBuck - Closoir - 6\" (152mm)",null,{"$f":"IF(A14=TRUE,Data!T37,0)","v":0},{"$f":"Sommaire!J42*K14","v":0},80,null,0.33,null,8.02,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"IntegraBuck - Closoir - 8\" (203mm)",null,{"$f":"IF(A15=TRUE,Data!T38,0)","v":0},{"$f":"Sommaire!J43*K15","v":0},80,null,0.43,null,12.99,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"SantaFe Buck - Closoir SantaFé - 6\" (152mm)",null,{"$f":"IF(A16=TRUE,Data!V37,0)","v":0},{"$f":"Sommaire!J44*K16","v":0},80,null,0.43,null,11.57,null,0,0,{"$f":"IF(M16>=0,M16*N16,0)","v":0},{"$f":"ROUNDUP(M16+O16,2)","v":0},0,{"$f":"IF(M16>=0,M16*Q16,0)","v":0},{"$f":"ROUNDUP(M16+R16,2)","v":0},0,{"$f":"IF(M16>=0,M16*T16,0)","v":0},{"$f":"ROUNDUP(M16+U16,2)","v":0}]
[true,null,"SantaFe Buck - Closoir SantaFé - 8\" (203mm)",null,{"$f":"IF(A17=TRUE,Data!V38,0)","v":0},{"$f":"Sommaire!J45*K17","v":0},80,null,0.43,null,14.88,null,0,0,{"$f":"IF(M17>=0,M17*N17,0)","v":0},{"$f":"ROUNDUP(M17+O17,2)","v":0},0,{"$f":"IF(M17>=0,M17*Q17,0)","v":0},{"$f":"ROUNDUP(M17+R17,2)","v":0},0,{"$f":"IF(M17>=0,M17*T17,0)","v":0},{"$f":"ROUNDUP(M17+U17,2)","v":0}]
[false,null,"Future",null,{"$f":"IF(A18=TRUE,1,0)","v":0},{"$f":"Sommaire!J46*K18","v":0},116,null,0.33,null,13.14,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entête 4\" (8 pi. (244cm) Long.)",null,{"$f":"IF(A19=TRUE,Data!T40,0)","v":0},{"$f":"Sommaire!J47*K19","v":0},30,null,1.66,null,10,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entête 6\" (8 pi. (244cm) Long.)",null,{"$f":"IF(A20=TRUE,Data!T41,0)","v":0},{"$f":"Sommaire!J48*K20","v":0},30,4,1.86,null,14.17,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entête 8\" (8 pi. (244cm) Long.)",null,{"$f":"IF(A21=TRUE,Data!T42,0)","v":0},{"$f":"Sommaire!J49*K21","v":0},30,5.28,2.06,null,20,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entête SantaFé 6\"  (8 pi. (244cm) Long.)",null,{"$f":"IF(A22=TRUE,Data!V41,0)","v":0},{"$f":"Sommaire!J50*K22","v":0},12,4,1.86,null,14.09,null,0,0,{"$f":"IF(M22>=0,M22*N22,0)","v":0},{"$f":"ROUNDUP(M22+O22,2)","v":0},0,{"$f":"IF(M22>=0,M22*Q22,0)","v":0},{"$f":"ROUNDUP(M22+R22,2)","v":0},0,{"$f":"IF(M22>=0,M22*T22,0)","v":0},{"$f":"ROUNDUP(M22+U22,2)","v":0}]
[true,null,"Entête SantaFé 8\"  (8 pi. (244cm) Long.)",null,{"$f":"IF(A23=TRUE,Data!V42,0)","v":0},{"$f":"Sommaire!J51*K23","v":0},12,5.28,2.06,null,18.420000000000002,null,0,0,{"$f":"IF(M23>=0,M23*N23,0)","v":0},{"$f":"ROUNDUP(M23+O23,2)","v":0},0,{"$f":"IF(M23>=0,M23*Q23,0)","v":0},{"$f":"ROUNDUP(M23+R23,2)","v":0},0,{"$f":"IF(M23>=0,M23*T23,0)","v":0},{"$f":"ROUNDUP(M23+U23,2)","v":0}]
[true,null,"Entretoise 5\" (127mm)",null,{"$f":"IF(A24=TRUE,Data!R35,0)","v":0},{"$f":"Sommaire!J52*K24","v":0},216,null,null,null,3.03,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entretoise 4\" (102mm)",null,{"$f":"IF(A25=TRUE,Data!R34,0)+IF(Data!R34<=-1,\"Error\")","v":0},{"$f":"Sommaire!J53*K25","v":0},216,null,0.16,null,2.74,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entretoise 6\" (152mm)",null,{"$f":"IF(A26=TRUE,Data!R37,0)+IF(Data!R37<=-1,\"Error\")","v":0},{"$f":"Sommaire!J54*K26","v":0},216,null,0.17,null,3.49,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entretoise 8\" (203mm)",null,{"$f":"IF(A27=TRUE,Data!R38,0)+IF(Data!R38<=-1,\"Error\")","v":0},{"$f":"Sommaire!J55*K27","v":0},216,null,0.22,null,4.79,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entretoise 10\" (254mm)",null,{"$f":"IF(A28=TRUE,Data!R39,0)","v":0},{"$f":"Sommaire!J56*K28","v":0},108,null,0.25,null,3.18,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Entretoise 12\" (305mm)",null,{"$f":"IF(A29=TRUE,Data!R40,0)","v":0},{"$f":"Sommaire!J57*K29","v":0},108,null,0.25,null,3.49,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Insert(s) Seulement",null,{"$f":"IF(A30=TRUE,1,0)","v":1},{"$f":"Sommaire!J58*K30","v":0},288,null,0.17,null,2.31,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Agraffe en \"H\" (4 pi. (122 cm) Long.)",null,{"$f":"IF(A31=TRUE,1,0)","v":1},{"$f":"Sommaire!J59*K31","v":0},54,null,0.51849999999999996,null,1.23,null,0,0,0,0,0,0,0,0,0,0]
[false,null,"Future (Blank)",null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Acier d'armature approx. - 10mm ou # 4",null,{"$f":"IF(A33=TRUE,Data!S23,0)","v":0},null,null,"N/A",0.52,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Acier d'armature approx. - 15mm ou # 5",null,{"$f":"IF(A34=TRUE,Data!S26,0)","v":0},null,null,"N/A",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Acier d'armature approx. - 20mm ou # 6",null,{"$f":"IF(A35=TRUE,Data!S28,0)","v":0},null,null,"N/A",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Acier d'armature approx. - 25mm ou # 8",null,{"$f":"IF(A36=TRUE,Data!S30,0)","v":0},null,null,"N/A",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Béton (20 mpa) Mètre Cu.",null,{"$f":"IF(A37=TRUE,IF(C37=C48,Data!V10+D47,IF(C37=C50,Data!V10+D47,IF(C37=C52,Data!V10+D47,IF(C37=C49,Data!V11+D47,IF(C37=C51,Data!V11+D47,IF(C37=C53,Data!V11+D47,0)))))))","v":0},null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Membrane IntegraProoF (Rolleau 75' X 3')",null,{"$f":"IF(A38=TRUE,1,0)","v":1},null,1,null,null,null,null,null,129,0,0,129,0,0,129,0,0,129]
[false,null,"Boulon d'ancrage",null,0,null,null,"N/A",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[false,null,"Ancrage pour Solive de bordure",null,0,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[false,null,"Système d'alignement et échaffaudage",null,{"$f":"IF(A41=TRUE,1,\"\")","v":""},null,null,"N/A",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[false,null,"Support Technique / Formation",null,0,null,null,"N/A",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[true,null,"Taxe 1",null,1,null,null,"N/A",null,null,null,null,0.05]
[true,null,"Taxe 2",null,1,null,null,"N/A",null,null,null,null,9.9750000000000005E-2]
[false,null,"Divers / Autre",null,0,null,null,null,null,null,null,null,0,0,{"$f":"IF(M45>=1,M45*N45,0)","v":0},{"$f":"ROUNDUP(M45+O45,2)","v":0},0,{"$f":"IF(M45>=1,M45*Q45,0)","v":0},{"$f":"SUM(M45+R45)","v":0},0,{"$f":"IF(M45>=1,M45*T45,0)","v":0},0]
[false,null,"Location Pompe à Béton ",null,0,null,null,null,null,null,null,null,0,0,{"$f":"IF(M46>=1,M46*N46,0)","v":0},{"$f":"ROUNDUP(M46+O46,2)","v":0},0,{"$f":"IF(M46>=1,M46*Q46,0)","v":0},{"$f":"SUM(M46+R46)","v":0},0,{"$f":"IF(M46>=1,M46*T46,0)","v":0},0]
["Béton additonelle pour pompage",null,null,0,"Shipping ",{"$f":"SUM(F4:F46)","v":0}]
[null,null,"Béton (20 mpa) Mètre Cu.",null,"Volume","Cu.Ft."]
[null,null,"Béton (3000 lb/po/ca) Verge Cu."]
[null,null,"Béton (25 mpa) Mètre Cu."]
[null,null,"Béton (3500 lb/po/ca.) Verge Cu."]
[null,null,"Béton (32 mpa) Mètre Cu."]
[null,null,"Béton (4500 lb/po/ca.) Verge Cu."]
["Facteur perte de matériel IntegraSpec",null,null,3.5000000000000003E-2,null,null,null,null,null,null,null,null,"À NOTER: Les itèmes en caractères Bleu penvent être changer.  Les changements"]
[false,"Transport / Livraison:",null,0,{"$f":"IF(A55=TRUE,1,0)","v":0},null,null,null,null,null,null,null,"vont aussi paraître sur la page Sommaire."]
[null,null,"Plus Taxe:",{"$f":"(D55*M43)+(D55*M44)","v":0},null,null,null,null,null,null,null,null,"N'oublier pas d'ajuster les prix en conséquence !"]

{"sheet":"Bon de Commande","index":1,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":true,"merged":[[43,0,43,1],[44,0,44,1],[51,0,51,24],[5,5,5,24],[6,5,6,24],[13,0,13,2],[15,0,15,24],[7,0,7,2],[8,0,8,2],[9,0,9,24],[14,2,14,4],[16,20,16,24],[16,5,16,14],[16,15,16,19],[20,15,20,19],[19,15,19,19],[17,15,17,19],[17,0,17,1],[18,0,18,1],[19,0,19,1],[16,0,16,1],[50,0,50,24],[36,5,36,14],[31,20,31,24],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[5,3,5,4],[3,3,3,4],[42,0,42,1],[49,0,49,24],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[21,0,21,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[22,0,22,1],[23,0,23,1],[40,0,40,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[41,0,41,1],[20,0,20,1],[20,20,20,24],[21,20,21,24],[24,0,24,1],[25,0,25,1],[26,0,26,1],[38,15,38,19],[37,5,37,14],[38,5,38,14],[36,15,36,19],[37,15,37,19],[35,5,35,14],[32,5,32,14],[29,5,29,14],[30,5,30,14],[31,5,31,14],[38,20,38,24],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[0,5,1,23],[2,3,2,4],[2,5,2,6],[2,7,2,11],[2,12,2,14],[2,15,2,24],[29,15,29,19],[30,15,30,19],[31,15,31,19],[21,5,21,14],[24,15,24,19],[21,15,21,19],[22,15,22,19],[23,15,23,19],[24,5,24,14],[26,5,26,14],[22,5,22,14],[23,5,23,14],[28,15,28,19],[26,15,26,19],[28,5,28,14],[25,15,25,19],[25,5,25,14],[27,5,27,14],[4,3,4,4],[4,5,4,24],[6,3,6,4],[7,3,7,4],[7,5,7,9],[7,10,7,24],[19,5,19,14],[14,5,14,6],[14,7,14,24],[10,0,10,24],[8,3,8,24],[11,0,11,24],[17,20,17,24],[18,20,18,24],[17,5,17,14],[18,5,18,14],[18,15,18,19],[19,20,19,24],[12,3,12,24],[13,4,13,24],[3,5,3,11],[3,12,3,24],[33,20,33,24],[34,20,34,24],[35,20,35,24],[36,20,36,24],[37,20,37,24],[32,15,32,19],[33,15,33,19],[35,15,35,19],[34,15,34,19],[20,5,20,14],[22,20,22,24],[23,20,23,24],[24,20,24,24],[25,20,25,24],[27,15,27,19],[34,5,34,14],[33,5,33,14],[26,20,26,24],[27,20,27,24],[28,20,28,24],[29,20,29,24],[30,20,30,24],[39,20,39,24],[40,5,40,14],[40,15,40,19],[40,20,40,24],[39,15,39,19],[39,5,39,14],[32,20,32,24],[47,5,47,14],[47,15,47,19],[47,20,47,24],[43,20,43,24],[44,5,44,14],[44,15,44,19],[44,20,44,24],[41,20,41,24],[42,5,42,14],[42,15,42,19],[42,20,42,24],[41,5,41,14],[41,15,41,19],[43,5,43,14],[43,15,43,19],[53,0,53,24],[54,0,54,24],[55,0,55,1],[55,2,55,3],[56,0,56,2],[52,0,52,24],[56,5,56,6],[56,12,56,16],[56,19,56,24],[55,4,55,24],[48,15,48,19],[48,20,48,24],[45,5,45,14],[45,15,45,19],[45,20,45,24],[46,5,46,14],[46,15,46,19],[46,20,46,24],[48,0,48,14]]}
[null,null,null,null,null,"Bureau de Commande \nCourriel:  commande@integraspec.com\nFax:    1-613-634-2291\n1-800-382-9102  Ext: 29"]
[]
["Nom du Distributeur",null,null,null,null,"P.O. #",null,null,null,null,null,null,"Date:"]
["Téléphone #",null,null,null,null,"Addresse de Livraison"]
["Fax #"]
["Contacte"]
[]
["Date Requise:",null,null,null,null,"Contacte sur site:"]
["Instructions Spéciale:"]
[]
[]
[null,null,null,false]
["Description du projet:"]
[" Nous organison le Transport",null,null,false,""]
["Par:",null,null,null,null,"Signature"]
["BON DE COMMANDE INTEGRASPEC®"]
["Qté Sommaire",null," +/- ","Ballot Totale","No. d'ITÈME","DESCRIPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRIX"]
[{"$f":"Sommaire!J32","v":0},null,null,{"$f":"A18+C18","v":0},"STD","IntegraSpec - Panneau Standard",null,null,null,null,null,null,null,null,null,"(18 pan./ballot)",null,null,null,null,{"$f":"D18*'Liste de Prix'!M4*'Liste de Prix'!G4","v":0}]
[{"$f":"Sommaire!J33","v":0},null,null,{"$f":"A19+C19","v":0},"90C-6","IntegraSpec - Coin 90 Deg. (6\") (Int. & Ext.)",null,null,null,null,null,null,null,null,null,"(8 coin/ballot)",null,null,null,null,{"$f":"D19*'Liste de Prix'!M5*'Liste de Prix'!G5","v":0}]
[{"$f":"Sommaire!J34","v":0},null,null,0,"90C-8","IntegraSpec - Coin 90 Deg. (8\") (Int. & Ext.)",null,null,null,null,null,null,null,null,null,"(8 coin/ballot)",null,null,null,null,{"$f":"D20*'Liste de Prix'!M6*'Liste de Prix'!G6","v":0}]
[{"$f":"Sommaire!J35","v":0},null,null,0]
[{"$f":"Sommaire!J36","v":0},null,null,0,"T-WALLS","IntegraSpec - Mur en T (Coin 90 Deg. Intérieur)",null,null,null,null,null,null,null,null,null,"(16 pan./ballot)",null,null,null,null,{"$f":"D22*'Liste de Prix'!M8*'Liste de Prix'!G8","v":0}]
[{"$f":"Sommaire!J37","v":0},null,null,0,"45-IN","IntegraSpec - Coin 45 Deg. (Intérieur)",null,null,null,null,null,null,null,null,null,"(16 pan./ballot)",null,null,null,null,{"$f":"D23*'Liste de Prix'!M9*'Liste de Prix'!G9","v":0}]
[{"$f":"Sommaire!J38","v":0},null,null,0,"45-OUT","IntegraSpec - Coin 45 Deg. (Extérieur)",null,null,null,null,null,null,null,null,null,"(16 pan./ballot)",null,null,null,null,{"$f":"D24*'Liste de Prix'!M10*'Liste de Prix'!G10","v":0}]
[{"$f":"Sommaire!J39","v":0},null,null,0,"BKL","IntegraSpec - Panneau d'Assise - Brique",null,null,null,null,null,null,null,null,null,"(8 pan./ballot)",null,null,null,null,{"$f":"D25*'Liste de Prix'!M11*'Liste de Prix'!G11","v":0}]
[{"$f":"Sommaire!J40","v":0},null,null,0,"TAP","IntegraSpec - Panneau Biseauté",null,null,null,null,null,null,null,null,null,"(18 pan./ballot)",null,null,null,null,{"$f":"D26*'Liste de Prix'!M12*'Liste de Prix'!G12","v":0}]
[null,null,null,0]
[{"$f":"Sommaire!J41","v":0},null,null,0]
[{"$f":"Sommaire!J42","v":0},null,null,0,"BK-6","IntegraBuck - Closoir (6\")",null,null,null,null,null,null,null,null,null,"(80 pcs./boîte)",null,null,null,null,{"$f":"D29*'Liste de Prix'!M14*'Liste de Prix'!G14","v":0}]
[{"$f":"Sommaire!J43","v":0},null,null,0,"BK-8","IntegraBuck - Closoir (8\")",null,null,null,null,null,null,null,null,null,"(80 pcs./boîte)",null,null,null,null,{"$f":"D30*'Liste de Prix'!M15*'Liste de Prix'!G15","v":0}]
[{"$f":"Sommaire!J44","v":0},null,null,0,"BK-6-SF","SantaFe Buck - Closoir SantaFé (6\")",null,null,null,null,null,null,null,null,null,"(80 pcs./boîte)",null,null,null,null,{"$f":"D31*'Liste de Prix'!M16*'Liste de Prix'!G16","v":0}]
[{"$f":"Sommaire!J45","v":0},null,null,0,"BK-8-SF","SantaFe Buck - Closoir SantaFé (8\")",null,null,null,null,null,null,null,null,null,"(80 pcs./boîte)",null,null,null,null,{"$f":"D32*'Liste de Prix'!M17*'Liste de Prix'!G17","v":0}]
[null,null,null,0]
[{"$f":"Sommaire!J47","v":0},null,null,0,"HD-4","IntegraHeader - Entête 4\" (8 pi. Long.)",null,null,null,null,null,null,null,null,null,"(30 pcs./ballot)",null,null,null,null,{"$f":"D34*'Liste de Prix'!M19*'Liste de Prix'!G19","v":0}]
[{"$f":"Sommaire!J48","v":0},null,null,0,"HD-6","IntegraHeader - Entête 6\" (8 pi. Long.)",null,null,null,null,null,null,null,null,null,"(30 pcs./ballot)",null,null,null,null,{"$f":"D35*'Liste de Prix'!M20*'Liste de Prix'!G20","v":0}]
[{"$f":"Sommaire!J49","v":0},null,null,0,"HD-8","IntegraHeader - Entête 8\" (8 pi. Long.)",null,null,null,null,null,null,null,null,null,"(30 pcs./ballot)",null,null,null,null,{"$f":"D36*'Liste de Prix'!M21*'Liste de Prix'!G21","v":0}]
[{"$f":"Sommaire!J50","v":0},null,null,0,"HD-6-SF","SantaFe Header 6\" - Entête (8 pi. Long.)",null,null,null,null,null,null,null,null,null,"(12 pcs./ballot)",null,null,null,null,{"$f":"D37*'Liste de Prix'!M22*'Liste de Prix'!G22","v":0}]
[{"$f":"Sommaire!J51","v":0},null,null,0,"HD-8-SF","SantaFe Header 8\" - Entête (8 pi. Long.)",null,null,null,null,null,null,null,null,null,"(12 pcs./ballot)",null,null,null,null,{"$f":"D38*'Liste de Prix'!M23*'Liste de Prix'!G23","v":0}]
[null,null,null,0]
[{"$f":"Sommaire!J53","v":0},null,null,0,"WB-4","IntegraSpec - Entretoise 4\"",null,null,null,null,null,null,null,null,null,"(216 pcs./boîte)",null,null,null,null,{"$f":"D40*'Liste de Prix'!M25*'Liste de Prix'!G25","v":0}]
[{"$f":"Sommaire!J52","v":0},null,null,0,"WB-5","IntegraSpec - Entretoise 5\"",null,null,null,null,null,null,null,null,null,"(216 pcs./boîte)",null,null,null,null,{"$f":"D41*'Liste de Prix'!M24*'Liste de Prix'!G24","v":0}]
[{"$f":"Sommaire!J54","v":0},null,null,0,"WB-6","IntegraSpec - Entretoise 6\"",null,null,null,null,null,null,null,null,null,"(216 pcs./boîte)",null,null,null,null,{"$f":"D42*'Liste de Prix'!M26*'Liste de Prix'!G26","v":0}]
[{"$f":"Sommaire!J55","v":0},null,null,0,"WB-8","IntegraSpec - Entretoise 8\"",null,null,null,null,null,null,null,null,null,"(216 pcs./boîte)",null,null,null,null,{"$f":"D43*'Liste de Prix'!M27*'Liste de Prix'!G27","v":0}]
[{"$f":"Sommaire!J56","v":0},null,null,0,"WB-10","IntegraSpec - Entretoise 10\"",null,null,null,null,null,null,null,null,null,"(108 pcs./boîte)",null,null,null,null,{"$f":"D44*'Liste de Prix'!M28*'Liste de Prix'!G28","v":0}]
[{"$f":"Sommaire!J57","v":0},null,null,0,"WB-12","IntegraSpec - Entretoise 12\"",null,null,null,null,null,null,null,null,null,"(108 pcs./boîte)",null,null,null,null,{"$f":"D45*'Liste de Prix'!M29*'Liste de Prix'!G29","v":0}]
[{"$f":"Sommaire!H65","v":0},null,null,0,"MEMBR","Membrane IntegraProoF (Rolleau 75' X 3')",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D46*'Liste de Prix'!M38*'Liste de Prix'!G38","v":0}]
[{"$f":"Sommaire!J58","v":0},null,null,0,"INSERT","Insert (Seulement)",null,null,null,null,null,null,null,null,null,"(288 pcs./boîte)",null,null,null,null,{"$f":"D47*'Liste de Prix'!M30*'Liste de Prix'!G30","v":0}]
[{"$f":"Sommaire!J59","v":0},null,null,{"$f":"A48+C48","v":0},"H-Clip","Integra Agraffe en \"H\" (4 pi. Long.)",null,null,null,null,null,null,null,null,null,"(54 pcs./ballot)",null,null,null,null,{"$f":"D48*'Liste de Prix'!M31*'Liste de Prix'!G31","v":0}]
["COMMENTAIRE ADDITIONEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totale:",null,null,null,null,{"$f":"SUM(U18:Y48)","v":0}]
[]
[]
[]
[]
[]
["Cette section est reservée pour le bureau de commande"]
["Date Received:"]
["Date Transportation Booked:",null,null,null,"Carrier:",null,null,"Plant Pickup Date:",null,null,null,null,null,null,null,null,null,"Plant:"]

{"sheet":"Detaile Mur 5-8","index":2,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":true,"merged":[[51,17,51,20],[38,17,38,20],[26,17,26,20],[52,2,52,8],[48,17,48,19],[49,17,49,19],[50,17,50,19],[36,17,36,19],[37,17,37,19],[47,17,47,20],[34,17,34,20],[35,17,35,19],[34,2,34,4],[47,2,47,4],[49,14,49,16],[33,13,33,16],[9,2,9,4],[22,2,22,4],[9,6,9,12],[22,6,22,12],[27,10,27,15],[11,14,11,16],[24,14,24,16],[27,2,27,8],[52,10,52,15],[39,10,39,15],[34,6,34,12],[47,6,47,12],[14,2,14,8],[46,13,46,16],[39,2,39,8],[36,14,36,16],[21,17,21,20],[33,17,33,20],[46,17,46,20],[8,17,8,20],[8,13,8,16],[21,13,21,16],[14,10,14,15],[9,17,9,20],[10,17,10,19],[11,17,11,19],[12,17,12,19],[13,17,13,20],[22,17,22,20],[23,17,23,19],[24,17,24,19],[25,17,25,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
[null,null,"Description du mur 5",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
["Info Client",null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U11*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U12","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U11*((12.25/12)*304.8),2)","v":0}]
[null,null,null,"mm",null,null,{"$f":"IF(E13>0,CONCATENATE(ROUND(E13/(12.25/12),2),\" \",\"Rangs\"),IF(E14>0,CONCATENATE(ROUND(E14*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
["Murs 1 à 4",null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I19,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P19,\"      Oui\",\"      Non\")","v":"      Non"}]
["Murs 5 à 8",null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Murs 9 à 12",null,"Description du mur 6",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U24*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U25","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U24*((12.25/12)*304.8),2)","v":0}]
["Ouvertures",null,null,"mm",null,null,{"$f":"IF(E26>0,CONCATENATE(ROUND(E26/(12.25/12),2),\" \",\"Rangs\"),IF(E27>0,CONCATENATE(ROUND(E27*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Waste %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Waste %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
["Sommaire",null,null,null,null,null,null,null,{"$f":"IF(I32,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P32,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Notes",null,"Description du mur 7",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U36*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U37","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U36*((12.25/12)*304.8),2)","v":0}]
["Liste de Prix",null,null,"mm",null,null,{"$f":"IF(E38>0,CONCATENATE(ROUND(E38/(12.25/12),2),\" \",\"Rangs\"),IF(E39>0,CONCATENATE(ROUND(E39*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
["Transport",null,null,null,null,null,null,null,{"$f":"IF(I44,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P44,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
["Bon de",null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Commande",null,"Description du mur 8",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U49*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U50","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U49*((12.25/12)*304.8),2)","v":0}]
[null,null,null,"mm",null,null,{"$f":"IF(E51>0,CONCATENATE(ROUND(E51/(12.25/12),2),\" \",\"Rangs\"),IF(E52>0,CONCATENATE(ROUND(E52*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Waste %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Waste %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I57,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P57,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]

{"sheet":"Detaile Mur 9-12","index":3,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":true,"merged":[[35,17,35,19],[36,17,36,19],[24,14,24,16],[36,14,36,16],[27,2,27,8],[34,17,34,20],[24,17,24,19],[25,17,25,19],[34,2,34,4],[34,6,34,12],[27,10,27,15],[26,17,26,20],[33,13,33,16],[33,17,33,20],[52,10,52,15],[37,17,37,19],[39,10,39,15],[47,2,47,4],[47,6,47,12],[47,17,47,20],[48,17,48,19],[49,17,49,19],[50,17,50,19],[52,2,52,8],[49,14,49,16],[38,17,38,20],[51,17,51,20],[46,13,46,16],[39,2,39,8],[46,17,46,20],[8,17,8,20],[11,17,11,19],[11,14,11,16],[12,17,12,19],[14,10,14,15],[8,13,8,16],[13,17,13,20],[23,17,23,19],[9,2,9,4],[9,6,9,12],[9,17,9,20],[10,17,10,19],[22,2,22,4],[22,6,22,12],[22,17,22,20],[21,13,21,16],[14,2,14,8],[21,17,21,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
[null,null,"Description du mur 9",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapprot au nombre de rang(s)."]
["Info Client",null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U11*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U12","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U11*((12.25/12)*304.8),2)","v":0}]
[null,null,null,"mm",null,null,{"$f":"IF(E13>0,CONCATENATE(ROUND(E13/(12.25/12),2),\" \",\"Rangs\"),IF(E14>0,CONCATENATE(ROUND(E14*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
["Murs 1 à 4",null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I19,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P19,\"      Oui\",\"      Non\")","v":"      Non"}]
["Murs 5 à 8",null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Murs 9 à 12",null,"Description du mur 10",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapprot au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->"]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U24*(12.25/12),2)","v":0}]
[null,null,null,"pi.",null,null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U24*((12.25/12)*304.8),2)","v":0}]
["Ouvertures",null,null,"mm",null,null,{"$f":"IF(E26>0,CONCATENATE(ROUND(E26/(12.25/12),2),\" \",\"Rangs\"),IF(E27>0,CONCATENATE(ROUND(E27*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
["Sommaire",null,null,null,null,null,null,null,{"$f":"IF(I32,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P32,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Notes",null,"Description du mur 11",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapprot au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->"]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U36*(12.25/12),2)","v":0}]
[null,null,null,"pi.",null,null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U36*((12.25/12)*304.8),2)","v":0}]
["Liste de Prix",null,null,"mm",null,null,{"$f":"IF(E38>0,CONCATENATE(ROUND(E38/(12.25/12),2),\" \",\"Rangs\"),IF(E39>0,CONCATENATE(ROUND(E39*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
["Transport",null,null,null,null,null,null,null,{"$f":"IF(I44,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P44,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
["Bon de",null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Commande",null,"Description du mur 12",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapprot au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->"]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U49*(12.25/12),2)","v":0}]
[null,null,null,"pi.",null,null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U49*((12.25/12)*304.8),2)","v":0}]
[null,null,null,"mm",null,null,{"$f":"IF(E51>0,CONCATENATE(ROUND(E51/(12.25/12),2),\" \",\"Rangs\"),IF(E52>0,CONCATENATE(ROUND(E52*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Côtés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Côtés"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I57,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P57,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]

{"sheet":"Detaile Mur 1-4","index":4,"n_rows":57,"n_cols":21,"rows_kept":57,"cut":false,"hidden":true,"merged":[[52,2,52,8],[11,13,11,15],[9,6,9,12],[22,6,22,12],[22,2,22,4],[39,10,39,15],[52,10,52,15],[36,14,36,15],[49,14,49,15],[47,2,47,4],[34,6,34,12],[47,6,47,12],[34,2,34,4],[46,13,46,16],[33,13,33,16],[27,2,27,8],[27,10,27,15],[24,14,24,15],[39,2,39,8],[9,2,9,4],[14,2,14,8],[8,13,8,16],[21,13,21,16],[21,17,21,20],[8,17,8,20],[14,10,14,15],[51,17,51,20],[36,17,36,19],[37,17,37,19],[50,17,50,19],[47,17,47,20],[48,17,48,19],[49,17,49,19],[46,17,46,20],[22,17,22,20],[11,17,11,19],[9,17,9,20],[26,17,26,20],[38,17,38,20],[23,17,23,19],[24,17,24,19],[25,17,25,19],[34,17,34,20],[35,17,35,19],[10,17,10,19],[12,17,12,19],[33,17,33,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
[null,null,"Description du mur 1",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",0,null,"par rapport au nombre de rang(s)."]
["Info Client",null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,0,null,0,null,"Mur en T","Pan. Biseauté / Longueur",null,null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U11*(12.25/12),2)","v":0}]
[null,null,0,"pi.",{"$f":"+U12","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,0,null,"Imp.(pi.)",0,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U11*((12.25/12)*304.8),2)","v":0}]
[null,null,null,"mm",null,null,{"$f":"IF(E13>0,CONCATENATE(ROUND(E13/(12.25/12),2),\" \",\"Rangs\"),IF(E14>0,CONCATENATE(ROUND(E14*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,0,null,0,null,null,null,"Métric(mm)"]
["Murs 1 à 4",null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Cotés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Cotés"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I19,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P19,\"       Oui\",\"       Non\")","v":"       Non"}]
["Murs 5 à 8",null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Murs 9 à 12",null,"Description du mur 2",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U24*(12.25/12),2)","v":0}]
[null,null,0,"pi.",{"$f":"+U25","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U24*((12.25/12)*304.8),2)","v":0}]
["Ouvertures",null,null,"mm",null,null,{"$f":"IF(E26>0,CONCATENATE(ROUND(E26/(12.25/12),2),\" \",\"Rangs\"),IF(E27>0,CONCATENATE(ROUND(E27*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Cotés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Cotés"]
[]
["Sommaire",null,null,null,null,null,null,null,{"$f":"IF(I32,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P32,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Notes",null,"Description du mur 3",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U36*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U37","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U36*((12.25/12)*304.8),2)","v":0}]
["Liste de Prix",null,null,"mm",null,null,{"$f":"IF(E38>0,CONCATENATE(ROUND(E38/(12.25/12),2),\" \",\"Rangs\"),IF(E39>0,CONCATENATE(ROUND(E39*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Cotés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Cotés"]
[]
["Transport",null,null,null,null,null,null,null,{"$f":"IF(I44,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P44,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[]
[]
["Bon de",null,null,null,null,null,null,null,null,null,null,null,null,"Pan. Assise Brique/ Longueur",null,null,null,"Hauteur du coffrage IntegraSpec calculé "]
["Commande",null,"Description du mur 4",null,null,null,null,null,null,null,null,null,null,null,"Imp.(pi.)",null,null,"par rapport au nombre de rang(s)."]
[null,null,null,null,null,null,null,null,"Coin Ext. 900",null,"Coin Int. 900",null,null,null,"Métric(mm)",null,null,"Entrer le nombre de rang(s) ici ->",null,null,0]
[null,null,"Longueur",null,"Hauteur",null,"Larg. Béton",null,null,null,null,null,"Mur en T",null,"Pan. Biseauté / Longueur",null,null,"Hauteur du Mur en Impériale (pi.)",null,null,{"$f":"ROUND(U49*(12.25/12),2)","v":0}]
[null,null,null,"pi.",{"$f":"+U50","v":0},null,null,null,"Coin Ext. 450",null,"Coin Int. 450",null,null,null,"Imp.(pi.)",null,null,"Hauteur du Mur Métric (mm)",null,null,{"$f":"ROUND(U49*((12.25/12)*304.8),2)","v":0}]
[null,null,null,"mm",null,null,{"$f":"IF(E51>0,CONCATENATE(ROUND(E51/(12.25/12),2),\" \",\"Rangs\"),IF(E52>0,CONCATENATE(ROUND(E52*0.00328083/(12.25/12),2),\" \",\"Rangs\"),\"\"))","v":""},null,null,null,null,null,null,null,"Métric(mm)"]
[null,null,"Acier Verticale (Incl.? Cliquer Oui / Non )",null,null,null,null,null,null,null,"Acier Horizontale (Incl.? Cliquer Oui / Non )"]
[null,null,"Perte %",3,"Diam.",null,"Espacement      2 Cotés",null,null,null,"Perte %",12,"Diam.",null,"Espacement      2 Cotés"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I57,\"Oui\",\"Non\")","v":"Non"},null,null,null,null,null,null,{"$f":"IF(P57,\"      Oui\",\"      Non\")","v":"      Non"}]
[null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false]

{"sheet":"Sommaire","index":5,"n_rows":79,"n_cols":22,"rows_kept":79,"cut":false,"hidden":true,"merged":[[32,7,32,8],[32,10,32,11],[33,7,33,8],[36,5,36,6],[11,9,11,11],[12,9,12,11],[12,1,12,2],[13,3,13,5],[12,3,12,5],[13,1,13,2],[33,5,33,6],[32,1,32,4],[33,1,33,4],[24,1,24,6],[32,5,32,6],[10,9,10,11],[31,10,31,11],[30,9,30,11],[31,7,31,8],[30,1,30,4],[30,5,30,6],[1,0,1,4],[2,0,2,4],[4,0,4,4],[6,2,6,4],[5,0,5,1],[5,2,5,4],[3,0,3,2],[3,3,3,4],[25,1,25,6],[31,5,31,6],[31,1,31,4],[26,1,26,6],[27,1,27,6],[28,1,28,6],[6,0,6,1],[9,1,9,5],[10,1,10,5],[11,1,11,5],[26,14,26,16],[30,7,30,8],[24,7,24,8],[25,7,25,8],[23,10,23,11],[17,10,17,11],[16,10,16,11],[18,10,18,11],[19,10,19,11],[21,7,21,8],[22,7,22,8],[23,7,23,8],[17,14,17,16],[16,14,16,16],[24,10,24,11],[25,10,25,11],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[28,10,28,11],[26,7,26,8],[27,7,27,8],[28,7,28,8],[37,5,37,6],[34,7,34,8],[35,7,35,8],[36,7,36,8],[37,7,37,8],[35,10,35,11],[46,1,46,4],[47,1,47,4],[48,1,48,4],[48,7,48,8],[38,5,38,6],[39,5,39,6],[34,5,34,6],[35,5,35,6],[37,1,37,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[38,1,38,4],[39,1,39,4],[52,1,52,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[45,1,45,4],[44,1,44,4],[43,1,43,4],[50,1,50,4],[49,1,49,4],[15,14,15,16],[18,1,18,6],[19,1,19,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[20,1,20,6],[18,14,18,16],[19,14,19,16],[20,7,20,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[15,0,15,13],[17,1,17,6],[16,1,16,6],[34,15,34,16],[35,15,35,16],[36,15,36,16],[37,15,37,16],[33,10,33,11],[34,10,34,11],[46,10,46,11],[38,15,38,16],[20,10,20,11],[21,10,21,11],[22,10,22,11],[28,14,28,16],[27,14,27,16],[30,15,30,16],[43,10,43,11],[36,10,36,11],[37,10,37,11],[31,15,31,16],[32,15,32,16],[33,15,33,16],[24,14,24,16],[25,14,25,16],[26,10,26,11],[27,10,27,11],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[46,15,46,16],[47,15,47,16],[48,15,48,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[43,15,43,16],[42,15,42,16],[45,15,45,16],[44,15,44,16],[57,5,57,6],[60,1,60,6],[61,1,61,6],[55,7,55,8],[55,1,55,4],[56,7,56,8],[57,7,57,8],[51,1,51,4],[52,15,52,16],[53,15,53,16],[51,10,51,11],[52,10,52,11],[53,10,53,11],[53,1,53,4],[54,1,54,4],[74,7,74,8],[74,15,74,16],[73,1,73,6],[73,7,73,8],[73,9,73,11],[72,7,72,8],[63,10,63,11],[64,10,64,11],[61,15,61,16],[61,7,61,8],[62,1,62,6],[72,10,72,11],[71,1,71,2],[71,3,71,6],[72,1,72,6],[67,15,67,16],[66,15,66,16],[73,15,73,16],[69,10,69,11],[68,15,68,16],[65,10,65,11],[66,10,66,11],[69,15,69,16],[74,10,74,11],[56,15,56,16],[53,7,53,8],[40,5,40,6],[41,5,41,6],[42,5,42,6],[55,5,55,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[52,5,52,6],[53,5,53,6],[50,5,50,6],[43,5,43,6],[43,7,43,8],[44,7,44,8],[45,7,45,8],[46,7,46,8],[54,5,54,6],[49,15,49,16],[50,15,50,16],[48,10,48,11],[48,5,48,6],[51,5,51,6],[44,5,44,6],[49,5,49,6],[68,1,68,6],[70,1,70,6],[68,7,68,8],[69,7,69,8],[70,7,70,8],[69,1,69,6],[65,1,65,6],[67,5,67,6],[66,1,66,6],[67,1,67,4],[65,7,65,8],[66,7,66,8],[67,7,67,8],[64,1,64,6],[62,7,62,8],[63,7,63,8],[64,7,64,8],[63,1,63,6],[56,1,56,4],[57,1,57,4],[50,7,50,8],[50,10,50,11],[51,7,51,8],[52,7,52,8],[72,15,72,16],[62,15,62,16],[63,15,63,16],[64,15,64,16],[65,15,65,16],[71,15,71,16],[70,10,70,11],[71,7,71,8],[62,9,62,11],[54,15,54,16],[55,15,55,16],[58,15,58,16],[59,15,59,16],[56,10,56,11],[57,10,57,11],[58,10,58,11],[54,10,54,11],[60,15,60,16],[51,15,51,16],[60,7,60,8],[80,0,80,18],[81,0,81,18],[82,0,82,18],[83,0,83,18],[84,0,84,18],[15,17,15,18],[29,0,29,18],[74,5,74,6],[75,5,75,6],[74,3,74,4],[75,3,75,4],[61,9,61,11],[58,1,58,4],[59,1,59,6],[56,5,56,6],[70,15,70,16],[57,15,57,16],[47,7,47,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[38,10,38,11],[75,7,75,8],[75,10,76,16],[76,0,76,9],[74,0,74,2],[9,14,9,18],[77,0,77,18],[78,0,78,18],[79,0,79,18],[10,13,10,18],[11,13,11,18],[12,13,12,18],[13,13,13,18],[9,9,9,11],[45,10,45,11],[44,10,44,11],[47,10,47,11],[54,7,54,8],[58,7,58,8],[59,7,59,8],[55,10,55,11],[49,7,49,8],[49,10,49,11],[59,9,59,11],[60,9,60,11]]}
[]
["Compagnie / Distributeur"]
["Addresse"]
["Ville",null,null,"Province"]
["Code Postale"]
["Téléphone",null,"FAX"]
["xxx-xxx-xxxx",null,"xxx-xxx-xxxx"]
[]
[]
["Nom",{"$f":"Data!C2","v":""},null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2025-02-06"},null,null,null,"Notes:"]
["Addresse",{"$f":"Data!C3","v":""},null,null,null,null,null,null,"Projet:",{"$f":"Data!C23","v":""}]
["Ville",{"$f":"Data!C4","v":""},null,null,null,null,null,null,"Location:",{"$f":"Data!C30","v":0}]
["Tel",{"$f":"CONCATENATE(\"Travaille\",Data!C8)","v":"Travaille"},null,{"$f":"CONCATENATE(\"Résidence\",Data!C9)","v":"Résidence"},null,null,null,null,"Autre:",{"$f":"Data!C31","v":0}]
[null,{"$f":"CONCATENATE(\"Mobile \",Data!C10)","v":"Mobile "},null,{"$f":"CONCATENATE(\"Fax \",Data!C11)","v":"Fax "}]
[]
["Sommaire et Détaile de Mur(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Espacement d'Acier d'Armature",null,null,"Diamètre des Barres"]
["Mur","Description / Notes",null,null,null,null,null,"Longueur",null,"Hauteur","Larg. Béton",null,"90 deg.","45 deg.","   Verticale (c.c.)       Horizontale (c.c.) ",null,null,"Verticale","Horizontale"]
[1,{"$f":"'Detaile Mur 1-4'!G10","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C14>0,CONCATENATE('Detaile Mur 1-4'!C14,\" \",\"mm\"),IF('Detaile Mur 1-4'!C13>0,CONCATENATE('Detaile Mur 1-4'!C13,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E14>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E14,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E13>0,CONCATENATE('Detaile Mur 1-4'!E13,\" pi.\",),\"\"))","v":""},{"$f":"IF(H18=\" \",\" \",Data!E71)","v":" "},null,{"$f":"Data!E12+Data!E13","v":0},{"$f":"Data!E14","v":0},null,null,null,{"$f":"IF(H18=\" \",\" \",Data!E18)","v":" "},{"$f":"IF(H18=\" \",\" \",Data!E27)","v":" "}]
[2,{"$f":"'Detaile Mur 1-4'!G23","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C27>0,CONCATENATE('Detaile Mur 1-4'!C27,\" \",\"mm\"),IF('Detaile Mur 1-4'!C26>0,CONCATENATE('Detaile Mur 1-4'!C26,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E27>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E27,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E26>0,CONCATENATE('Detaile Mur 1-4'!E26,\" pi.\",),\"\"))","v":""},{"$f":"IF(H19=\" \",\" \",Data!F71)","v":" "},null,{"$f":"Data!F12+Data!F13","v":0},{"$f":"Data!F14","v":0},null,null,null,{"$f":"IF(H19=\" \",\" \",Data!F18)","v":" "},{"$f":"IF(H19=\" \",\" \",Data!F27)","v":" "}]
[3,{"$f":"'Detaile Mur 1-4'!G35","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C39>0,CONCATENATE('Detaile Mur 1-4'!C39,\" \",\"mm\"),IF('Detaile Mur 1-4'!C38>0,CONCATENATE('Detaile Mur 1-4'!C38,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E39>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E39,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E38>0,CONCATENATE('Detaile Mur 1-4'!E38,\" pi.\",),\"\"))","v":""},{"$f":"IF(H20=\" \",\" \",Data!G71)","v":" "},null,{"$f":"Data!G12+Data!G13","v":0},{"$f":"Data!G14","v":0},null,null,null,{"$f":"IF(H20=\" \",\" \",Data!G18)","v":" "},{"$f":"IF(H20=\" \",\" \",Data!G27)","v":" "}]
[4,{"$f":"'Detaile Mur 1-4'!G48","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C52>0,CONCATENATE('Detaile Mur 1-4'!C52,\" \",\"mm\"),IF('Detaile Mur 1-4'!C51>0,CONCATENATE('Detaile Mur 1-4'!C51,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E52>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E52,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E51>0,CONCATENATE('Detaile Mur 1-4'!E51,\" pi.\",),\"\"))","v":""},{"$f":"IF(H21=\" \",\" \",Data!H71)","v":" "},null,{"$f":"Data!H12+Data!H13","v":0},{"$f":"Data!H14","v":0},null,null,null,{"$f":"IF(H21=\" \",\" \",Data!H18)","v":" "},{"$f":"IF(H21=\" \",\" \",Data!H27)","v":" "}]
[5,{"$f":"'Detaile Mur 5-8'!G10","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C14>0,CONCATENATE('Detaile Mur 5-8'!C14,\" \",\"mm\"),IF('Detaile Mur 5-8'!C13>0,CONCATENATE('Detaile Mur 5-8'!C13,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E14>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E14,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E13>0,CONCATENATE('Detaile Mur 5-8'!E13,\" pi.\",),\"\"))","v":""},{"$f":"IF(H22=\" \",\" \",Data!I71)","v":" "},null,{"$f":"Data!I12+Data!I13","v":0},{"$f":"Data!I14","v":0},null,null,null,{"$f":"IF(H22=\" \",\" \",Data!I18)","v":" "},{"$f":"IF(H22=\" \",\" \",Data!I27)","v":" "}]
[6,{"$f":"'Detaile Mur 5-8'!G23","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C27>0,CONCATENATE('Detaile Mur 5-8'!C27,\" \",\"mm\"),IF('Detaile Mur 5-8'!C26>0,CONCATENATE('Detaile Mur 5-8'!C26,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E27>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E27,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E26>0,CONCATENATE('Detaile Mur 5-8'!E26,\" pi.\",),\"\"))","v":""},{"$f":"IF(H23=\" \",\" \",Data!J71)","v":" "},null,{"$f":"Data!J12+Data!J13","v":0},{"$f":"Data!J14","v":0},null,null,null,{"$f":"IF(H23=\" \",\" \",Data!J18)","v":" "},{"$f":"IF(H23=\" \",\" \",Data!J27)","v":" "}]
[7,{"$f":"'Detaile Mur 5-8'!G35","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C39>0,CONCATENATE('Detaile Mur 5-8'!C39,\" \",\"mm\"),IF('Detaile Mur 5-8'!C38>0,CONCATENATE('Detaile Mur 5-8'!C38,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E39>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E39,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E38>0,CONCATENATE('Detaile Mur 5-8'!E38,\" pi.\",),\"\"))","v":""},{"$f":"IF(H24=\" \",\" \",Data!K71)","v":" "},null,{"$f":"Data!K12+Data!K13","v":0},{"$f":"Data!K14","v":0},null,null,null,{"$f":"IF(H24=\" \",\" \",Data!K18)","v":" "},{"$f":"IF(H24=\" \",\" \",Data!K27)","v":" "}]
[8,{"$f":"'Detaile Mur 5-8'!G48","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C52>0,CONCATENATE('Detaile Mur 5-8'!C52,\" \",\"mm\"),IF('Detaile Mur 5-8'!C51>0,CONCATENATE('Detaile Mur 5-8'!C51,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E52>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E52,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E51>0,CONCATENATE('Detaile Mur 5-8'!E51,\" pi.\",),\"\"))","v":""},{"$f":"IF(H25=\" \",\" \",Data!L71)","v":" "},null,{"$f":"Data!L12+Data!L13","v":0},{"$f":"Data!L14","v":0},null,null,null,{"$f":"IF(H25=\" \",\" \",Data!L18)","v":" "},{"$f":"IF(H25=\" \",\" \",Data!L27)","v":" "}]
[9,{"$f":"'Detaile Mur 9-12'!G10","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C14>0,CONCATENATE('Detaile Mur 9-12'!C14,\" \",\"mm\"),IF('Detaile Mur 9-12'!C13>0,CONCATENATE('Detaile Mur 9-12'!C13,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E14>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E14,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E13>0,CONCATENATE('Detaile Mur 9-12'!E13,\" pi.\",),\"\"))","v":""},{"$f":"IF(H26=\" \",\" \",Data!M71)","v":" "},null,{"$f":"Data!M12+Data!M13","v":0},{"$f":"Data!M14","v":0},null,null,null,{"$f":"IF(H26=\" \",\" \",Data!M18)","v":" "},{"$f":"IF(H26=\" \",\" \",Data!M27)","v":" "}]
[10,{"$f":"'Detaile Mur 9-12'!G23","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C27>0,CONCATENATE('Detaile Mur 9-12'!C27,\" \",\"mm\"),IF('Detaile Mur 9-12'!C26>0,CONCATENATE('Detaile Mur 9-12'!C26,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E27>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E27,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E26>0,CONCATENATE('Detaile Mur 9-12'!E26,\" pi.\",),\"\"))","v":""},{"$f":"IF(H27=\" \",\" \",Data!N71)","v":" "},null,{"$f":"Data!N12+Data!N13","v":0},{"$f":"Data!N14","v":0},null,null,null,{"$f":"IF(H27=\" \",\" \",Data!N18)","v":" "},{"$f":"IF(H27=\" \",\" \",Data!N27)","v":" "}]
[11,{"$f":"'Detaile Mur 9-12'!G35","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C39>0,CONCATENATE('Detaile Mur 9-12'!C39,\" \",\"mm\"),IF('Detaile Mur 9-12'!C38>0,CONCATENATE('Detaile Mur 9-12'!C38,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E39>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E39,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E38>0,CONCATENATE('Detaile Mur 9-12'!E38,\" pi.\",),\"\"))","v":""},{"$f":"IF(H28=\" \",\" \",Data!O71)","v":" "},null,{"$f":"Data!O12+Data!O13","v":0},{"$f":"Data!O14","v":0},null,null,null,{"$f":"IF(H28=\" \",\" \",Data!O18)","v":" "},{"$f":"IF(H28=\" \",\" \",Data!O27)","v":" "}]
[12,{"$f":"'Detaile Mur 9-12'!G48","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C52>0,CONCATENATE('Detaile Mur 9-12'!C52,\" \",\"mm\"),IF('Detaile Mur 9-12'!C51>0,CONCATENATE('Detaile Mur 9-12'!C51,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E52>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E52,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E51>0,CONCATENATE('Detaile Mur 9-12'!E51,\" pi.\",),\"\"))","v":""},{"$f":"IF(H29=\" \",\" \",Data!P71)","v":" "},null,{"$f":"Data!P12+Data!P13","v":0},{"$f":"Data!P14","v":0},null,null,null,{"$f":"IF(H29=\" \",\" \",Data!P18)","v":" "},{"$f":"IF(H29=\" \",\" \",Data!P27)","v":" "}]
["Sommaire et Liste de Matériel"]
[null,"Description",null,null,null,"Itèmes",null,"Qté arrondie",null,"Quantité à expédier",null,null,"Prix",{"$f":"+'Liste de Prix'!C43","v":"Taxe 1"},{"$f":"+'Liste de Prix'!C44","v":"Taxe 2"},"Totale",null,"*Itèmes Add.","*Surface Add."]
[1,{"$f":"IF('Liste de Prix'!E4>0,'Liste de Prix'!C4,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E4>=1,'Liste de Prix'!E4,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E4,'Liste de Prix'!G4)","v":0},null,{"$f":"ROUNDUP(H32/'Liste de Prix'!G4,0)","v":0},{"$f":"IF(H32>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H32*'Liste de Prix'!P4,IF('Liste de Prix'!F1=2,H32*'Liste de Prix'!S4,IF('Liste de Prix'!F1=3,H32*'Liste de Prix'!V4,\"\")))","v":0},{"$f":"IF('Liste de Prix'!$E$43=1,M32*'Liste de Prix'!$M$43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M32*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M32:O32)","v":0},null,{"$f":"IF(J32>0,H32-F32,0)","v":0},{"$f":"+R32*2.04","v":0},{"$f":"+S32","v":0},{"$f":"+F32*2.04","v":{"$error":"#VALUE!"}},{"$f":"IF(J32>0,U32,0)","v":0}]
[2,{"$f":"IF('Liste de Prix'!E5>=1,'Liste de Prix'!C5,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E5>=1,'Liste de Prix'!E5,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E5,'Liste de Prix'!G5)","v":0},null,{"$f":"ROUNDUP(H33/'Liste de Prix'!G5,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H33*'Liste de Prix'!P5,IF('Liste de Prix'!F1=2,H33*'Liste de Prix'!S5,IF('Liste de Prix'!F1=3,H33*'Liste de Prix'!V5,\"\")))","v":0},{"$f":"IF('Liste de Prix'!$E$43=1,M33*'Liste de Prix'!$M$43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M33*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M33:O33)","v":0},null,{"$f":"IF(J33>0,H33-F33,0)","v":0},{"$f":"+R33*4.16","v":0},{"$f":"+S33","v":0},{"$f":"+F33*4.16","v":{"$error":"#VALUE!"}},{"$f":"IF(J33>0,U33,0)","v":0}]
[3,{"$f":"IF('Liste de Prix'!E6>=1,'Liste de Prix'!C6,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E6>=1,'Liste de Prix'!E6,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E6,'Liste de Prix'!G6)","v":0},null,{"$f":"ROUNDUP(H34/'Liste de Prix'!G6,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H34*'Liste de Prix'!P6,IF('Liste de Prix'!F1=2,H34*'Liste de Prix'!S6,IF('Liste de Prix'!F1=3,H34*'Liste de Prix'!V6,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M34*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M34*'Liste de Prix'!M44,\"\")","v":0},0,null,0,{"$f":"+R34*4.51","v":0},0,null,0]
[4,{"$f":"IF('Liste de Prix'!E7>=1,'Liste de Prix'!C7,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E7>=1,'Liste de Prix'!E7,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E7,'Liste de Prix'!G7)","v":0},null,{"$f":"ROUNDUP(H35/'Liste de Prix'!G7,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H35*'Liste de Prix'!P7,IF('Liste de Prix'!F1=2,H35*'Liste de Prix'!S7,IF('Liste de Prix'!F1=3,H35*'Liste de Prix'!V7,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M35*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M35*'Liste de Prix'!M44,\"\")","v":0},0,null,0,null,0,null,0]
[5,{"$f":"IF('Liste de Prix'!E8>=1,'Liste de Prix'!C8,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E8>=1,'Liste de Prix'!E8,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E8,'Liste de Prix'!G8)","v":0},null,{"$f":"ROUNDUP(H36/'Liste de Prix'!G8,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H36*'Liste de Prix'!P8,IF('Liste de Prix'!F1=2,H36*'Liste de Prix'!S8,IF('Liste de Prix'!F1=3,H36*'Liste de Prix'!V8,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M36*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M36*'Liste de Prix'!M44,\"\")","v":0},0,null,0,{"$f":"+R36*0.42","v":0},0,{"$f":"+F36*0.42","v":{"$error":"#VALUE!"}},0]
[6,{"$f":"IF('Liste de Prix'!E9>=1,'Liste de Prix'!C9,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E9>=1,'Liste de Prix'!E9,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E9,'Liste de Prix'!G9)","v":0},null,{"$f":"ROUNDUP(H37/'Liste de Prix'!G9,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H37*'Liste de Prix'!P9,IF('Liste de Prix'!F1=2,H37*'Liste de Prix'!S9,IF('Liste de Prix'!F1=3,H37*'Liste de Prix'!V9,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M37*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M37*'Liste de Prix'!M44,\"\")","v":0},0,null,{"$f":"IF(J37>0,H37-F37,0)","v":0},{"$f":"+R37*2.21","v":0},0,{"$f":"+F37*2.21","v":{"$error":"#VALUE!"}},0]
[7,{"$f":"IF('Liste de Prix'!E10>=1,'Liste de Prix'!C10,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E10>=1,'Liste de Prix'!E10,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E10,'Liste de Prix'!G10)","v":0},null,{"$f":"ROUNDUP(H38/'Liste de Prix'!G10,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H38*'Liste de Prix'!P10,IF('Liste de Prix'!F1=2,H38*'Liste de Prix'!S10,IF('Liste de Prix'!F1=3,H38*'Liste de Prix'!V10,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M38*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M38*'Liste de Prix'!M44,\"\")","v":0},0,null,{"$f":"IF(J38>0,H38-F38,0)","v":0},{"$f":"+R38*2.99","v":0},0,{"$f":"+F38*2.99","v":{"$error":"#VALUE!"}},0]
[8,{"$f":"IF('Liste de Prix'!E11>=1,'Liste de Prix'!C11,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E11>=1,'Liste de Prix'!E11,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E11,'Liste de Prix'!G11)","v":0},null,{"$f":"ROUNDUP(H39/'Liste de Prix'!G11,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H39*'Liste de Prix'!P11,IF('Liste de Prix'!F1=2,H39*'Liste de Prix'!S11,IF('Liste de Prix'!F1=3,H39*'Liste de Prix'!V11,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M39*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M39*'Liste de Prix'!M44,\"\")","v":0},0,null,{"$f":"IF(J39>0,H39-F39,0)","v":0},{"$f":"+R39*2.04","v":0},0,{"$f":"+F39*2.04","v":{"$error":"#VALUE!"}},0]
[9,{"$f":"IF('Liste de Prix'!E12>=1,'Liste de Prix'!C12,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E12>=1,'Liste de Prix'!E12,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E12,'Liste de Prix'!G12)","v":0},null,{"$f":"ROUNDUP(H40/'Liste de Prix'!G12,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H40*'Liste de Prix'!P12,IF('Liste de Prix'!F1=2,H40*'Liste de Prix'!S12,IF('Liste de Prix'!F1=3,H40*'Liste de Prix'!V12,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M40*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M40*'Liste de Prix'!M44,\"\")","v":0},0,null,{"$f":"IF(J40>0,H40-F40,0)","v":0},{"$f":"+R40*2.04","v":0},0,{"$f":"+F40*2.04","v":{"$error":"#VALUE!"}},0]
[10,{"$f":"IF('Liste de Prix'!E13>=1,'Liste de Prix'!C13,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E13>=1,'Liste de Prix'!E13,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E13,'Liste de Prix'!G13)","v":0},null,{"$f":"ROUNDUP(H41/'Liste de Prix'!G13,0)","v":0},{"$f":"IF(H41>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H41*'Liste de Prix'!P13,IF('Liste de Prix'!F1=2,H41*'Liste de Prix'!S13,IF('Liste de Prix'!F1=3,H41*'Liste de Prix'!V13,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M41*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M41*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[11,{"$f":"IF('Liste de Prix'!E14>=1,'Liste de Prix'!C14,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E14>=1,'Liste de Prix'!E14,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E14,'Liste de Prix'!G14)","v":0},null,{"$f":"ROUNDUP(H42/'Liste de Prix'!G14,0)","v":0},{"$f":"IF(H42>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H42*'Liste de Prix'!P14,IF('Liste de Prix'!F1=2,H42*'Liste de Prix'!S14,IF('Liste de Prix'!F1=3,H42*'Liste de Prix'!V14,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M42*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M42*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[12,{"$f":"IF('Liste de Prix'!E15>=1,'Liste de Prix'!C15,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E15>=1,'Liste de Prix'!E15,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E15,'Liste de Prix'!G15)","v":0},null,{"$f":"ROUNDUP(H43/'Liste de Prix'!G15,0)","v":0},{"$f":"IF(H43>=1,\"Box(es)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H43*'Liste de Prix'!P15,IF('Liste de Prix'!F1=2,H43*'Liste de Prix'!S15,IF('Liste de Prix'!F1=3,H43*'Liste de Prix'!V15,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M43*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M43*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[13,{"$f":"IF('Liste de Prix'!E16>=1,'Liste de Prix'!C16,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E16>=1,'Liste de Prix'!E16,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E16,'Liste de Prix'!G16)","v":0},null,{"$f":"ROUNDUP(H44/'Liste de Prix'!G16,0)","v":0},{"$f":"IF(H44>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H44*'Liste de Prix'!P16,IF('Liste de Prix'!F1=2,H44*'Liste de Prix'!S16,IF('Liste de Prix'!F1=3,H44*'Liste de Prix'!V16,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M44*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M44*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M44:O44)","v":0},null,0]
[14,{"$f":"IF('Liste de Prix'!E17>=1,'Liste de Prix'!C17,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E17>=1,'Liste de Prix'!E17,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E17,'Liste de Prix'!G17)","v":0},null,{"$f":"ROUNDUP(H45/'Liste de Prix'!G17,0)","v":0},{"$f":"IF(H45>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H45*'Liste de Prix'!P17,IF('Liste de Prix'!F1=2,H45*'Liste de Prix'!S17,IF('Liste de Prix'!F1=3,H45*'Liste de Prix'!V17,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M45*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E46=1,M45*'Liste de Prix'!M46,\"\")","v":""},{"$f":"SUM(M45:O45)","v":0},null,0]
[15,{"$f":"IF('Liste de Prix'!E18>=1,'Liste de Prix'!C18,\"\")","v":""},null,null,null,0,null,{"$f":"CEILING(F46,116)","v":0},null,{"$f":"ROUNDUP(H46/'Liste de Prix'!G18,0)","v":0},{"$f":"IF(H46>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H46*'Liste de Prix'!P18,IF('Liste de Prix'!F1=2,H46*'Liste de Prix'!S18,IF('Liste de Prix'!F1=3,H46*'Liste de Prix'!V18,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M46*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M46*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[16,{"$f":"IF('Liste de Prix'!E19>=1,'Liste de Prix'!C19,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E19>=1,'Liste de Prix'!E19,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E19,'Liste de Prix'!G19)","v":0},null,{"$f":"ROUNDUP(H47/'Liste de Prix'!G19,0)","v":0},{"$f":"IF(H47>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H47*'Liste de Prix'!P19,IF('Liste de Prix'!F1=2,H47*'Liste de Prix'!S19,IF('Liste de Prix'!F1=3,H47*'Liste de Prix'!V19,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M47*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M47*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[17,{"$f":"IF('Liste de Prix'!E20>=1,'Liste de Prix'!C20,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E20>=1,'Liste de Prix'!E20,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E20,'Liste de Prix'!G20)","v":0},null,{"$f":"ROUNDUP(H48/'Liste de Prix'!G20,0)","v":0},{"$f":"IF(H48>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H48*'Liste de Prix'!P20,IF('Liste de Prix'!F1=2,H48*'Liste de Prix'!S20,IF('Liste de Prix'!F1=3,H48*'Liste de Prix'!V20,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M48*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M48*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[18,{"$f":"IF('Liste de Prix'!E21>=1,'Liste de Prix'!C21,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E21>=1,'Liste de Prix'!E21,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E21,'Liste de Prix'!G21)","v":0},null,{"$f":"ROUNDUP(H49/'Liste de Prix'!G21,0)","v":0},{"$f":"IF(H49>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H49*'Liste de Prix'!P21,IF('Liste de Prix'!F1=2,H49*'Liste de Prix'!S21,IF('Liste de Prix'!F1=3,H49*'Liste de Prix'!V21,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M49*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M49*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[19,{"$f":"IF('Liste de Prix'!E22>=1,'Liste de Prix'!C22,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E22>=1,'Liste de Prix'!E22,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E22,'Liste de Prix'!G22)","v":0},null,{"$f":"ROUNDUP(H50/'Liste de Prix'!G22,0)","v":0},{"$f":"IF(H50>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H50*'Liste de Prix'!P22,IF('Liste de Prix'!F1=2,H50*'Liste de Prix'!S22,IF('Liste de Prix'!F1=3,H50*'Liste de Prix'!V22,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M50*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M50*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M50:O50)","v":0},null,0]
[20,{"$f":"IF('Liste de Prix'!E23>=1,'Liste de Prix'!C23,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E23>=1,'Liste de Prix'!E23,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E23,'Liste de Prix'!G23)","v":0},null,{"$f":"ROUNDUP(H51/'Liste de Prix'!G23,0)","v":0},{"$f":"IF(H51>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H51*'Liste de Prix'!P23,IF('Liste de Prix'!F1=2,H51*'Liste de Prix'!S23,IF('Liste de Prix'!F1=3,H51*'Liste de Prix'!V23,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M51*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M51*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M51:O51)","v":0},null,0]
[21,{"$f":"IF('Liste de Prix'!E24>=1,'Liste de Prix'!C24,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E24>=1,'Liste de Prix'!E24,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E24,'Liste de Prix'!G24)","v":0},null,{"$f":"ROUNDUP(H52/'Liste de Prix'!G24,0)","v":0},{"$f":"IF(H52>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H52*'Liste de Prix'!P24,IF('Liste de Prix'!F1=2,H52*'Liste de Prix'!S24,IF('Liste de Prix'!F1=3,H52*'Liste de Prix'!V24,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M52*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M52*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[22,{"$f":"IF('Liste de Prix'!E25>=1,'Liste de Prix'!C25,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E25>=1,'Liste de Prix'!E25,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E25,'Liste de Prix'!G25)","v":0},null,{"$f":"ROUNDUP(H53/'Liste de Prix'!G25,0)","v":0},{"$f":"IF(H53>=1,\"Boîte(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H53*'Liste de Prix'!P25,IF('Liste de Prix'!F1=2,H53*'Liste de Prix'!S25,IF('Liste de Prix'!F1=3,H53*'Liste de Prix'!V25,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M53*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M53*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[23,{"$f":"IF('Liste de Prix'!E26>=1,'Liste de Prix'!C26,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E26>=1,'Liste de Prix'!E26,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E26,'Liste de Prix'!G26)","v":0},null,{"$f":"ROUNDUP(H54/'Liste de Prix'!G26,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H54*'Liste de Prix'!P26,IF('Liste de Prix'!F1=2,H54*'Liste de Prix'!S26,IF('Liste de Prix'!F1=3,H54*'Liste de Prix'!V26,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M54*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M54*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[24,{"$f":"IF('Liste de Prix'!E27>=1,'Liste de Prix'!C27,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E27>=1,'Liste de Prix'!E27,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E27,'Liste de Prix'!G27)","v":0},null,{"$f":"ROUNDUP(H55/'Liste de Prix'!G27,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H55*'Liste de Prix'!P27,IF('Liste de Prix'!F1=2,H55*'Liste de Prix'!S27,IF('Liste de Prix'!F1=3,H55*'Liste de Prix'!V27,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M55*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M55*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[25,{"$f":"IF('Liste de Prix'!E28>=1,'Liste de Prix'!C28,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E28>=1,'Liste de Prix'!E28,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E28,'Liste de Prix'!G28)","v":0},null,{"$f":"ROUNDUP(H56/'Liste de Prix'!G28,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H56*'Liste de Prix'!P28,IF('Liste de Prix'!F1=2,H56*'Liste de Prix'!S28,IF('Liste de Prix'!F1=3,H56*'Liste de Prix'!V28,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M56*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M56*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[26,{"$f":"IF('Liste de Prix'!E29>=1,'Liste de Prix'!C29,\"\")","v":""},null,null,null,{"$f":"IF('Liste de Prix'!E29>=1,'Liste de Prix'!E29,\"\")","v":""},null,{"$f":"CEILING('Liste de Prix'!E29,'Liste de Prix'!G29)","v":0},null,{"$f":"ROUNDUP(H57/'Liste de Prix'!G29,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H57*'Liste de Prix'!P29,IF('Liste de Prix'!F1=2,H57*'Liste de Prix'!S29,IF('Liste de Prix'!F1=3,H57*'Liste de Prix'!V29,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M57*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M57*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[27,{"$f":"IF('Liste de Prix'!E30=1,'Liste de Prix'!C30,\"\")","v":"Insert(s) Seulement"},null,null,null,0,null,{"$f":"CEILING(F58,288)","v":0},null,{"$f":"ROUNDUP(H58/'Liste de Prix'!G30,0)","v":0},"",null,{"$f":"IF('Liste de Prix'!F1=1,H58*'Liste de Prix'!P30,IF('Liste de Prix'!F1=2,H58*'Liste de Prix'!S30,IF('Liste de Prix'!F1=3,H58*'Liste de Prix'!V30,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M58*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M58*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[28,{"$f":"IF('Liste de Prix'!E31=1,'Liste de Prix'!C31,IF(F59>0,'Liste de Prix'!C31,IF(G59>0,'Liste de Prix'!C31,\"\")))","v":"Agraffe en \"H\" (4 pi. (122 cm) Long.)"},null,null,null,{"$f":"Data!Q65","v":0},null,{"$f":"CEILING((F59+G59),54)","v":0},null,{"$f":"ROUNDUP(H59/'Liste de Prix'!G31,0)","v":0},{"$f":"IF(H59>=1,\"Ballot(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H59*'Liste de Prix'!P31,IF('Liste de Prix'!F1=2,H59*'Liste de Prix'!S31,IF('Liste de Prix'!F1=3,H59*'Liste de Prix'!V31,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M59*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M59*'Liste de Prix'!M44,\"\")","v":0},0,null,0]
[29,{"$f":"IF('Liste de Prix'!E33>=1,'Liste de Prix'!C33,\"\")","v":""},null,null,null,null,null,{"$f":"'Liste de Prix'!E33","v":0},null,{"$f":"IF(H60>=1,CONCATENATE(\"Pied Linéair ou\",\" (\",ROUND(H60*0.3048,0),\"  Mètres )\"),\"\")","v":""},null,null,{"$f":"IF('Liste de Prix'!F1=1,H60*'Liste de Prix'!P33,IF('Liste de Prix'!F1=2,H60*'Liste de Prix'!S33,IF('Liste de Prix'!F1=3,H60*'Liste de Prix'!V33,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M60*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M60*'Liste de Prix'!M44,\"\")","v":0},0]
[30,{"$f":"IF('Liste de Prix'!E34>=1,'Liste de Prix'!C34,\"\")","v":""},null,null,null,null,null,{"$f":"'Liste de Prix'!E34","v":0},null,{"$f":"IF(H61>=1,CONCATENATE(\"Pied Linéair ou\",\" (\",ROUND(H61*0.3048,0),\"  Mètres )\"),\"\")","v":""},null,null,{"$f":"IF('Liste de Prix'!F1=1,H61*'Liste de Prix'!P34,IF('Liste de Prix'!F1=2,H61*'Liste de Prix'!S34,IF('Liste de Prix'!F1=3,H61*'Liste de Prix'!V34,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M61*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M61*'Liste de Prix'!M44,\"\")","v":0},0]
[31,{"$f":"IF('Liste de Prix'!E35>=1,'Liste de Prix'!C35,\"\")","v":""},null,null,null,null,null,{"$f":"'Liste de Prix'!E35","v":0},null,{"$f":"IF(H62>=1,CONCATENATE(\"Pied Linéair ou\",\" (\",ROUND(H62*0.3048,0),\"  Mètres )\"),\"\")","v":""},null,null,{"$f":"IF('Liste de Prix'!F1=1,H62*'Liste de Prix'!P35,IF('Liste de Prix'!F1=2,H62*'Liste de Prix'!S35,IF('Liste de Prix'!F1=3,H62*'Liste de Prix'!V35,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M62*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M62*'Liste de Prix'!M44,\"\")","v":0},0]
[32,{"$f":"IF('Liste de Prix'!E36>=1,'Liste de Prix'!C36,\"\")","v":""},null,null,null,null,null,{"$f":"'Liste de Prix'!E36","v":0},null,{"$f":"IF(H63>=1,CONCATENATE(\"Pied Linéair ou\",\" (\",ROUND(H63*0.3048,0),\"  Mètres )\"),\"\")","v":""},null,null,{"$f":"IF('Liste de Prix'!F1=1,H63*'Liste de Prix'!P36,IF('Liste de Prix'!F1=2,H63*'Liste de Prix'!S36,IF('Liste de Prix'!F1=3,H63*'Liste de Prix'!V36,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M63*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M63*'Liste de Prix'!M44,\"\")","v":0},0]
[33,{"$f":"IF('Liste de Prix'!E37>0,IF('Liste de Prix'!A37=TRUE,'Liste de Prix'!C37,\"\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF('Liste de Prix'!E37=FALSE,'Liste de Prix'!D48*'Liste de Prix'!D49,'Liste de Prix'!E37)","v":0},null,{"$f":"IF('Liste de Prix'!D47>=1,CONCATENATE(\"Ajout de\",\" \",'Liste de Prix'!D47,\" \",\"pour\"),\"\")","v":""},{"$f":"IF('Liste de Prix'!D47>=1,\"Perte pour pompe\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H64*'Liste de Prix'!P37,IF('Liste de Prix'!F1=2,H64*'Liste de Prix'!S37,IF('Liste de Prix'!F1=3,H64*'Liste de Prix'!V37,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M64*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M64*'Liste de Prix'!M44,\"\")","v":0},0]
[34,{"$f":"IF('Liste de Prix'!E38>=1,'Liste de Prix'!C38,\"\")","v":"Membrane IntegraProoF (Rolleau 75' X 3')"},null,null,null,null,null,0,null,{"$f":"IF(H65>=1,\"Rouleau(s)\",\"\")","v":""},null,null,{"$f":"IF('Liste de Prix'!F1=1,H65*'Liste de Prix'!P38,IF('Liste de Prix'!F1=2,H65*'Liste de Prix'!S38,IF('Liste de Prix'!F1=3,H65*'Liste de Prix'!V38,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M65*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M65*'Liste de Prix'!M44,\"\")","v":0},0]
[35,{"$f":"IF('Liste de Prix'!E39>=1,'Liste de Prix'!C39,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(H66>=1,\"Chq.\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H66*'Liste de Prix'!P39,IF('Liste de Prix'!F1=2,H66*'Liste de Prix'!S39,IF('Liste de Prix'!F1=3,H66*'Liste de Prix'!V39,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M66*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M66*'Liste de Prix'!M44,\"\")","v":0},0]
[36,{"$f":"IF('Liste de Prix'!E40>=1,'Liste de Prix'!C40,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(H67>=1,\"Chq.\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H67*'Liste de Prix'!P40,IF('Liste de Prix'!F1=2,H67*'Liste de Prix'!S40,IF('Liste de Prix'!F1=3,H67*'Liste de Prix'!V40,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M67*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M67*'Liste de Prix'!M44,\"\")","v":0},0]
[37,{"$f":"IF('Liste de Prix'!E41=1,'Liste de Prix'!C41,\"\")","v":""},null,null,null,0,null,{"$f":"ROUNDUP(F68/6,0)","v":0},null,{"$f":"IF(F68>=1,IF('Liste de Prix'!F1=1,'Liste de Prix'!P41,IF('Liste de Prix'!F1=2,'Liste de Prix'!S41,IF('Liste de Prix'!F1=3,'Liste de Prix'!V41,\"\"))))","v":false},0,{"$f":"IF(H68>=1,\"Jour(s)\",\"\")","v":""},{"$f":"IF('Liste de Prix'!F1=1,H68*'Liste de Prix'!P41*K68,IF('Liste de Prix'!F1=2,H68*'Liste de Prix'!S41*K68,IF('Liste de Prix'!F1=3,H68*'Liste de Prix'!V41*K68,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M68*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M68*'Liste de Prix'!M44,\"\")","v":0},0]
[38,{"$f":"IF('Liste de Prix'!E42>=1,'Liste de Prix'!C42,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(H69>=1,IF('Liste de Prix'!F1=1,'Liste de Prix'!P42,IF('Liste de Prix'!F1=2,'Liste de Prix'!S42,IF('Liste de Prix'!F1=3,'Liste de Prix'!V42,\"\"))))","v":false},null,{"$f":"IF(H69>=1,\"Jour(s)\",\"\")","v":""},{"$f":"IF('Liste de Prix'!F1=1,H69*'Liste de Prix'!P42*K69,IF('Liste de Prix'!F1=2,H69*'Liste de Prix'!S42*K69,IF('Liste de Prix'!F1=3,H69*'Liste de Prix'!V42*K69,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M69*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M69*'Liste de Prix'!M44,\"\")","v":0},0]
[39,{"$f":"IF('Liste de Prix'!E45>=1,'Liste de Prix'!C45,\"\")","v":""},null,null,null,null,null,{"$f":"IF(B70=\"Training and Technical Support\",1,0*0)","v":0},null,null,{"$f":"IF(H70>=1,\"Chq.\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H70*'Liste de Prix'!P45,IF('Liste de Prix'!F1=2,H70*'Liste de Prix'!S45,IF('Liste de Prix'!F1=3,H70*'Liste de Prix'!V45,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M70*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M70*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M70:O70)","v":0}]
[40,{"$f":"IF('Liste de Prix'!E46>=1,'Liste de Prix'!C46,\"\")","v":""},null,null,null,null,null,0,null,null,{"$f":"IF(H71>=1,\"Heure(s)\",\"\")","v":""},null,{"$f":"IF('Liste de Prix'!F1=1,H71*'Liste de Prix'!P46,IF('Liste de Prix'!F1=2,H71*'Liste de Prix'!S46,IF('Liste de Prix'!F1=3,H71*'Liste de Prix'!V46,\"\")))","v":0},{"$f":"IF('Liste de Prix'!E43=1,M71*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M71*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M71:O71)","v":0}]
[41,{"$f":"IF('Liste de Prix'!E55=1,'Liste de Prix'!B55,\"\")","v":""},null,0,null,null,null,{"$f":"IF(B72=\"Shipping:\",'Liste de Prix'!D55,0*0)","v":0},null,null,null,null,{"$f":"IF(B72=\"Shipping:\",'Liste de Prix'!D55,0*0)","v":0},{"$f":"IF('Liste de Prix'!E43=1,M72*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M72*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M72:O72)","v":0}]
[42,"Divers / Autre",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Liste de Prix'!E43=1,M73*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M73*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M73:O73)","v":0}]
[43,"Divers / Autre",null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF('Liste de Prix'!E43=1,M74*'Liste de Prix'!M43,\"\")","v":0},{"$f":"IF('Liste de Prix'!E44=1,M74*'Liste de Prix'!M44,\"\")","v":0},{"$f":"SUM(M74:O74)","v":0}]
["Surface totale de mur estimé:",null,null,{"$f":"+V76","v":0},null,"Pi/Ca",null,{"$f":"+D75/10.76391","v":0},null,"M/Ca","TOTALE",null,{"$f":"SUM(M32:M74)","v":0},{"$f":"SUM(N32:N74)","v":0},{"$f":"SUM(O32:O74)","v":0},{"$f":"SUM(P32:Q74)","v":0},null,null,null,null,null,"Pi/Ca Totale"]
["* Basé sur qté par ballot/boite:",null,null,{"$f":"+D75+S76","v":0},null,"*Pi/Ca",null,{"$f":"+D76/10.76391","v":0},null,"*M/Ca","* Surface de mur pour itème  additionel inclut  dans les ballots et ou boites:",null,null,null,null,null,null,"*Pi/Ca",{"$f":"SUM(T32:T40)","v":0},null,null,{"$f":"SUM(V32:V40)","v":0}]
["*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*M/Ca",{"$f":"+S76/10.76391","v":0}]
["* Surface de mur additionnel par rapport au nombre de pièces expédié en ballot(s) et ou Boite(s) en surplus du nombre estimé.*"]
["Voir la page de \"Notes Importantes\""]

{"sheet":"Transport","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["High Cube Truck","20' Container","40' Container","48' Transport","53' Transport"]
["30'x8'x10'(88%)","20'x8'x8'(88%)","40'x8'x8'(88%)","48'x8'x10'(88%)","53'x8'x10'(88%)"]
[{"$f":"'Liste de Prix'!F47","v":0},{"$f":"'Liste de Prix'!F47","v":0},{"$f":"'Liste de Prix'!F47","v":0},{"$f":"'Liste de Prix'!F47","v":0},{"$f":"'Liste de Prix'!F47","v":0}]
[2112,1068,2193,3008,3328]
[]
[null,null,null,{"$f":"+Sommaire!V76","v":0},"Pied Carré de Mur ou"]
["Camion Cube Haut",{"$f":"A3/A4","v":0},null,{"$f":"A3","v":0},"Pied Cube de Matériel"]
["20' Conteneur (Cube Normale)",{"$f":"E3/B4","v":0},null,null,"à être Transporté"]
["40' Conteneur (Cube Haut)",{"$f":"C3/C4","v":0},null,{"$f":"CONCATENATE(ROUNDUP(D6,2),\" \",E6,\" \",D7,\" \",E7,\" \",E8)","v":"0 Pied Carré de Mur ou 0 Pied Cube de Matériel à être Transporté"}]
["48' Camion",{"$f":"D3/D4","v":0}]
["53' Camion",{"$f":"E3/E4","v":0}]

{"sheet":"Ouvertures","index":7,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":true,"merged":[[57,11,57,14],[10,11,13,11],[14,11,17,11],[58,1,58,6],[45,1,45,6],[49,11,52,11],[27,11,30,11],[40,11,43,11],[21,11,21,12],[53,11,56,11],[48,11,48,12],[44,11,44,14],[34,11,34,12],[47,11,47,12],[35,11,35,12],[4,2,4,8],[5,2,5,8],[19,1,19,6],[32,1,32,6],[6,2,6,8],[8,11,8,12],[23,11,26,11],[36,11,39,11],[9,11,9,12],[18,11,18,14],[22,11,22,12],[31,11,31,14]]}
[false]
[true]
[false]
[{"$f":"IF(A1=TRUE,1,IF(A2=TRUE,2,IF(A3=TRUE,3,\"\")))","v":2}]
[null,null," *** IMPORTANT ***"]
["1-800-382-9102",null,{"$f":"IF(A4=1,\" ***Entrer Largeur et Hauteur en pouces (po.) ***\",IF(A4=2,\" ***  Entrer Largeur et Hauteur en pied (pi.) ***\",IF(A4=3,\"***  Entrer Largeur et Hauteur en Métric (mm) ***\",\"\")))","v":" ***  Entrer Largeur et Hauteur en pied (pi.) ***"}]
["info@integraspec.com",null,"*** Selectionner Closoir et Entête au haut de la section***"]
[]
[null,"Ouverture","Largeur","Hauteur","Quantité","Larg. Béton",{"$f":"IF(A1=TRUE,\"Pi. Carré\",IF(A2=TRUE,\"Pi. Carré\",IF(A3=TRUE,\"Metre Carré\")))","v":"Pi. Carré"},"Closoir","Entête",null,null,"Superficie Totale /",null,null,{"$f":"IF(A1=TRUE,\"Pied\",IF(A2=TRUE,\"Pied\",IF(A3=TRUE,\"Mètre\")))","v":"Pied"}]
[null,1,null,null,1,{"$f":"Data!Z7","v":6},{"$f":"IF(A4=1,((C10*D10)*E10)/144,IF(A4=2,(C10*D10)*E10,IF(A4=3,((C10*D10)/1000000)*E10,0)))","v":0},{"$f":"IF(A4=1,((D10*2)/12)*E10,IF(A4=2,((D10*2)*E10),IF(A4=3,((D10*0.00328083)*2)*E10,0)))","v":0},{"$f":"IF(J10>0,(J10+(0.33*E10))/8,0)","v":0},{"$f":"IF(A4=1,(C10/12)*E10,IF(A4=2,C10*E10,IF(A4=3,(C10*0.00328083)*E10,0)))","v":0},null," Aire d'Ouverture",null,null,{"$f":"SUM(G10:G19)","v":0}]
[null,2,null,null,1,{"$f":"Data!Z8","v":6},{"$f":"IF(A4=1,((C11*D11)*E11)/144,IF(A4=2,(C11*D11)*E11,IF(A4=3,((C11*D11)/1000000)*E11,0)))","v":0},{"$f":"IF(A4=1,((D11*2)/12)*E11,IF(A4=2,((D11*2)*E11),IF(A4=3,((D11*0.00328083)*2)*E11,0)))","v":0},{"$f":"IF(J11>0,(J11+(0.33*E11))/8,0)","v":0},{"$f":"IF(A4=1,(C11/12)*E11,IF(A4=2,C11*E11,IF(A4=3,(C11*0.00328083)*E11,0)))","v":0},{"$f":"SUMIF(F10:F19,4,H10:H19)","v":0},{"$f":"IF(Data!AB62=1,\"Nombre de Closoir\",\"Nombre de  Closoir SantaFe\")","v":"Nombre de Closoir"}]
["Info Client",3,null,null,1,{"$f":"Data!Z9","v":6},{"$f":"IF(A4=1,((C12*D12)*E12)/144,IF(A4=2,(C12*D12)*E12,IF(A4=3,((C12*D12)/1000000)*E12,0)))","v":0},{"$f":"IF(A4=1,((D12*2)/12)*E12,IF(A4=2,((D12*2)*E12),IF(A4=3,((D12*0.00328083)*2)*E12,0)))","v":0},0,{"$f":"IF(A4=1,(C12/12)*E12,IF(A4=2,C12*E12,IF(A4=3,(C12*0.00328083)*E12,0)))","v":0},{"$f":"SUMIF(F10:F19,6,H10:H19)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K12,0)","v":0}]
[null,4,null,null,1,{"$f":"Data!Z10","v":6},{"$f":"IF(A4=1,((C13*D13)*E13)/144,IF(A4=2,(C13*D13)*E13,IF(A4=3,((C13*D13)/1000000)*E13,0)))","v":0},{"$f":"IF(A4=1,((D13*2)/12)*E13,IF(A4=2,((D13*2)*E13),IF(A4=3,((D13*0.00328083)*2)*E13,0)))","v":0},0,{"$f":"IF(A4=1,(C13/12)*E13,IF(A4=2,C13*E13,IF(A4=3,(C13*0.00328083)*E13,0)))","v":0},{"$f":"SUMIF(F10:F19,8,H10:H19)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K13,0)","v":0}]
[null,5,null,null,1,{"$f":"Data!Z11","v":6},{"$f":"IF(A4=1,((C14*D14)*E14)/144,IF(A4=2,(C14*D14)*E14,IF(A4=3,((C14*D14)/1000000)*E14,0)))","v":0},{"$f":"IF(A4=1,((D14*2)/12)*E14,IF(A4=2,((D14*2)*E14),IF(A4=3,((D14*0.00328083)*2)*E14,0)))","v":0},0,{"$f":"IF(A4=1,(C14/12)*E14,IF(A4=2,C14*E14,IF(A4=3,(C14*0.00328083)*E14,0)))","v":0},{"$f":"SUMIF(F10:F19,10,H10:H19)","v":0},null,"10\"",null,{"$f":"IF(K14>=1,\"N / A\",0)","v":0}]
[null,6,null,null,1,{"$f":"Data!Z12","v":6},{"$f":"IF(A4=1,((C15*D15)*E15)/144,IF(A4=2,(C15*D15)*E15,IF(A4=3,((C15*D15)/1000000)*E15,0)))","v":0},{"$f":"IF(A4=1,((D15*2)/12)*E15,IF(A4=2,((D15*2)*E15),IF(A4=3,((D15*0.00328083)*2)*E15,0)))","v":0},0,{"$f":"IF(A4=1,(C15/12)*E15,IF(A4=2,C15*E15,IF(A4=3,(C15*0.00328083)*E15,0)))","v":0},{"$f":"SUMIF(F10:F19,4,I10:I19)","v":0},{"$f":"IF(Data!AB62=1,\"Nombre d'Entête - Longueur\",\"Nombre d'Entête SantaFe - Longueur\")","v":"Nombre d'Entête - Longueur"}]
["Murs 1 à 4",7,null,null,1,{"$f":"Data!Z14","v":6},{"$f":"IF(A4=1,((C16*D16)*E16)/144,IF(A4=2,(C16*D16)*E16,IF(A4=3,((C16*D16)/1000000)*E16,0)))","v":0},{"$f":"IF(A4=1,((D16*2)/12)*E16,IF(A4=2,((D16*2)*E16),IF(A4=3,((D16*0.00328083)*2)*E16,0)))","v":0},0,{"$f":"IF(A4=1,(C16/12)*E16,IF(A4=2,C16*E16,IF(A4=3,(C16*0.00328083)*E16,0)))","v":0},{"$f":"SUMIF(F10:F19,6,I10:I19)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K16,0)","v":0}]
[null,8,null,null,1,{"$f":"Data!Z15","v":6},{"$f":"IF(A4=1,((C17*D17)*E17)/144,IF(A4=2,(C17*D17)*E17,IF(A4=3,((C17*D17)/1000000)*E17,0)))","v":0},{"$f":"IF(A4=1,((D17*2)/12)*E17,IF(A4=2,((D17*2)*E17),IF(A4=3,((D17*0.00328083)*2)*E17,0)))","v":0},0,{"$f":"IF(A4=1,(C17/12)*E17,IF(A4=2,C17*E17,IF(A4=3,(C17*0.00328083)*E17,0)))","v":0},{"$f":"SUMIF(F10:F19,8,I10:I19)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K17,0)","v":0}]
[null,9,null,null,1,{"$f":"Data!Z16","v":6},{"$f":"IF(A4=1,((C18*D18)*E18)/144,IF(A4=2,(C18*D18)*E18,IF(A4=3,((C18*D18)/1000000)*E18,0)))","v":0},{"$f":"IF(A4=1,((D18*2)/12)*E18,IF(A4=2,((D18*2)*E18),IF(A4=3,((D18*0.00328083)*2)*E18,0)))","v":0},0,{"$f":"IF(A4=1,(C18/12)*E18,IF(A4=2,C18*E18,IF(A4=3,(C18*0.00328083)*E18,0)))","v":0},{"$f":"SUMIF(F10:F19,10,I10:I19)","v":0},null,"10\"",null,{"$f":"IF(K18>=1,\"N / A\",0)","v":0}]
[null,10,null,null,1,{"$f":"Data!Z17","v":6},{"$f":"IF(A4=1,((C19*D19)*E19)/144,IF(A4=2,(C19*D19)*E19,IF(A4=3,((C19*D19)/1000000)*E19,0)))","v":0},{"$f":"IF(A4=1,((D19*2)/12)*E19,IF(A4=2,((D19*2)*E19),IF(A4=3,((D19*0.00328083)*2)*E19,0)))","v":0},0,{"$f":"IF(A4=1,(C19/12)*E19,IF(A4=2,C19*E19,IF(A4=3,(C19*0.00328083)*E19,0)))","v":0},null,"Note:"]
["Murs 5 à 8","Description optionel (eg: Rez-de-chausser)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A1=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A2=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A3=TRUE,\"Ou Entrer la valeur totale en M/ca.\")))","v":"Ou Entrer la valeur totale en Pi./ca."}]
[]
[null,"Ouverture","Largeur","Hauteur","Quantité","Larg. Béton",{"$f":"IF(A1=TRUE,\"Pi. Carré\",IF(A2=TRUE,\"Pi. Carré\",IF(A3=TRUE,\"Metre Carré\")))","v":"Pi. Carré"},"Closoir","Entête",null,null,"Superficie Totale /",null,null,{"$f":"IF(A1=TRUE,\"Pied\",IF(A2=TRUE,\"Pied\",IF(A3=TRUE,\"Mètre\")))","v":"Pied"}]
[null,1,null,null,1,{"$f":"Data!Z18","v":6},{"$f":"IF(A4=1,((C23*D23)*E23)/144,IF(A4=2,(C23*D23)*E23,IF(A4=3,((C23*D23)/1000000)*E23,0)))","v":0},{"$f":"IF(A4=1,((D23*2)/12)*E23,IF(A4=2,((D23*2)*E23),IF(A4=3,((D23*0.00328083)*2)*E23,0)))","v":0},{"$f":"IF(J23>0,(J23+(0.33*E23))/8,0)","v":0},{"$f":"IF(A4=1,(C23/12)*E23,IF(A4=2,C23*E23,IF(A4=3,(C23*0.00328083)*E23,0)))","v":0},null," Aire d'Ouverture",null,null,{"$f":"SUM(G23:G32)","v":0}]
["Murs 9 à 12",2,null,null,1,{"$f":"Data!Z19","v":6},{"$f":"IF(A4=1,((C24*D24)*E24)/144,IF(A4=2,(C24*D24)*E24,IF(A4=3,((C24*D24)/1000000)*E24,0)))","v":0},{"$f":"IF(A4=1,((D24*2)/12)*E24,IF(A4=2,((D24*2)*E24),IF(A4=3,((D24*0.00328083)*2)*E24,0)))","v":0},{"$f":"IF(J24>0,(J24+(0.33*E24))/8,0)","v":0},{"$f":"IF(A4=1,(C24/12)*E24,IF(A4=2,C24*E24,IF(A4=3,(C24*0.00328083)*E24,0)))","v":0},{"$f":"SUMIF(F23:F32,4,H23:H32)","v":0},{"$f":"IF(Data!AB63=1,\"Nombre de Closoir\",\"Nombre de  Closoir SantaFe\")","v":"Nombre de Closoir"}]
[null,3,null,null,1,{"$f":"Data!Z20","v":6},{"$f":"IF(A4=1,((C25*D25)*E25)/144,IF(A4=2,(C25*D25)*E25,IF(A4=3,((C25*D25)/1000000)*E25,0)))","v":0},{"$f":"IF(A4=1,((D25*2)/12)*E25,IF(A4=2,((D25*2)*E25),IF(A4=3,((D25*0.00328083)*2)*E25,0)))","v":0},0,{"$f":"IF(A4=1,(C25/12)*E25,IF(A4=2,C25*E25,IF(A4=3,(C25*0.00328083)*E25,0)))","v":0},{"$f":"SUMIF(F23:F32,6,H23:H32)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K25,0)","v":0}]
[null,4,null,null,1,{"$f":"Data!Z21","v":6},{"$f":"IF(A4=1,((C26*D26)*E26)/144,IF(A4=2,(C26*D26)*E26,IF(A4=3,((C26*D26)/1000000)*E26,0)))","v":0},{"$f":"IF(A4=1,((D26*2)/12)*E26,IF(A4=2,((D26*2)*E26),IF(A4=3,((D26*0.00328083)*2)*E26,0)))","v":0},0,{"$f":"IF(A4=1,(C26/12)*E26,IF(A4=2,C26*E26,IF(A4=3,(C26*0.00328083)*E26,0)))","v":0},{"$f":"SUMIF(F23:F32,8,H23:H32)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K26,0)","v":0}]
[null,5,null,null,1,{"$f":"Data!Z22","v":6},{"$f":"IF(A4=1,((C27*D27)*E27)/144,IF(A4=2,(C27*D27)*E27,IF(A4=3,((C27*D27)/1000000)*E27,0)))","v":0},{"$f":"IF(A4=1,((D27*2)/12)*E27,IF(A4=2,((D27*2)*E27),IF(A4=3,((D27*0.00328083)*2)*E27,0)))","v":0},0,{"$f":"IF(A4=1,(C27/12)*E27,IF(A4=2,C27*E27,IF(A4=3,(C27*0.00328083)*E27,0)))","v":0},{"$f":"SUMIF(F23:F32,10,H23:H32)","v":0},null,"10\"",null,{"$f":"IF(K27>=1,\"N / A\",0)","v":0}]
["Ouvertures",6,null,null,1,{"$f":"Data!Z23","v":6},{"$f":"IF(A4=1,((C28*D28)*E28)/144,IF(A4=2,(C28*D28)*E28,IF(A4=3,((C28*D28)/1000000)*E28,0)))","v":0},{"$f":"IF(A4=1,((D28*2)/12)*E28,IF(A4=2,((D28*2)*E28),IF(A4=3,((D28*0.00328083)*2)*E28,0)))","v":0},0,{"$f":"IF(A4=1,(C28/12)*E28,IF(A4=2,C28*E28,IF(A4=3,(C28*0.00328083)*E28,0)))","v":0},{"$f":"SUMIF(F23:F32,4,I23:I32)","v":0},{"$f":"IF(Data!AB63=1,\"Nombre d'Entête - Longueur\",\"Nombre d'Entête SantaFe - Longueur\")","v":"Nombre d'Entête - Longueur"}]
[null,7,null,null,1,{"$f":"Data!Z24","v":6},{"$f":"IF(A4=1,((C29*D29)*E29)/144,IF(A4=2,(C29*D29)*E29,IF(A4=3,((C29*D29)/1000000)*E29,0)))","v":0},{"$f":"IF(A4=1,((D29*2)/12)*E29,IF(A4=2,((D29*2)*E29),IF(A4=3,((D29*0.00328083)*2)*E29,0)))","v":0},0,{"$f":"IF(A4=1,(C29/12)*E29,IF(A4=2,C29*E29,IF(A4=3,(C29*0.00328083)*E29,0)))","v":0},{"$f":"SUMIF(F23:F32,6,I23:I32)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K29,0)","v":0}]
[null,8,null,null,1,{"$f":"Data!Z26","v":6},{"$f":"IF(A4=1,((C30*D30)*E30)/144,IF(A4=2,(C30*D30)*E30,IF(A4=3,((C30*D30)/1000000)*E30,0)))","v":0},{"$f":"IF(A4=1,((D30*2)/12)*E30,IF(A4=2,((D30*2)*E30),IF(A4=3,((D30*0.00328083)*2)*E30,0)))","v":0},0,{"$f":"IF(A4=1,(C30/12)*E30,IF(A4=2,C30*E30,IF(A4=3,(C30*0.00328083)*E30,0)))","v":0},{"$f":"SUMIF(F23:F32,8,I23:I32)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K30,0)","v":0}]
[null,9,null,null,1,{"$f":"Data!Z27","v":6},{"$f":"IF(A4=1,((C31*D31)*E31)/144,IF(A4=2,(C31*D31)*E31,IF(A4=3,((C31*D31)/1000000)*E31,0)))","v":0},{"$f":"IF(A4=1,((D31*2)/12)*E31,IF(A4=2,((D31*2)*E31),IF(A4=3,((D31*0.00328083)*2)*E31,0)))","v":0},{"$f":"IF(J31>0,(J31+(0.33*E31))/8,0)","v":0},{"$f":"IF(A4=1,(C31/12)*E31,IF(A4=2,C31*E31,IF(A4=3,(C31*0.00328083)*E31,0)))","v":0},{"$f":"SUMIF(F23:F32,10,I23:I32)","v":0},null,"10\"",null,{"$f":"IF(K31>=1,\"N / A\",0)","v":0}]
["Sommaire",10,null,null,1,{"$f":"Data!Z28","v":6},{"$f":"IF(A4=1,((C32*D32)*E32)/144,IF(A4=2,(C32*D32)*E32,IF(A4=3,((C32*D32)/1000000)*E32,0)))","v":0},{"$f":"IF(A4=1,((D32*2)/12)*E32,IF(A4=2,((D32*2)*E32),IF(A4=3,((D32*0.00328083)*2)*E32,0)))","v":0},0,{"$f":"IF(A4=1,(C32/12)*E32,IF(A4=2,C32*E32,IF(A4=3,(C32*0.00328083)*E32,0)))","v":0},null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A1=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A2=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A3=TRUE,\"Ou Entrer la valeur totale en M/ca.\")))","v":"Ou Entrer la valeur totale en Pi./ca."}]
[]
[null,"Ouverture","Largeur","Hauteur","Quantité","Larg. Béton",{"$f":"IF(A1=TRUE,\"Pi. Carré\",IF(A2=TRUE,\"Pi. Carré\",IF(A3=TRUE,\"Metre Carré\")))","v":"Pi. Carré"},"Closoir","Entête",null,null,"Superficie Totale /",null,null,{"$f":"IF(A1=TRUE,\"Pied\",IF(A2=TRUE,\"Pied\",IF(A3=TRUE,\"Mètre\")))","v":"Pied"}]
["Bon de",1,null,null,1,{"$f":"Data!Z29","v":6},{"$f":"IF(A4=1,((C36*D36)*E36)/144,IF(A4=2,(C36*D36)*E36,IF(A4=3,((C36*D36)/1000000)*E36,0)))","v":0},{"$f":"IF(A4=1,((D36*2)/12)*E36,IF(A4=2,((D36*2)*E36),IF(A4=3,((D36*0.00328083)*2)*E36,0)))","v":0},{"$f":"IF(J36>0,(J36+(0.33*E36))/8,0)","v":0},{"$f":"IF(A4=1,(C36/12)*E36,IF(A4=2,C36*E36,IF(A4=3,(C36*0.00328083)*E36,0)))","v":0},null," Aire d'Ouverture",null,null,{"$f":"SUM(G36:G45)","v":0}]
["Commande",2,null,null,1,{"$f":"Data!Z30","v":6},{"$f":"IF(A4=1,((C37*D37)*E37)/144,IF(A4=2,(C37*D37)*E37,IF(A4=3,((C37*D37)/1000000)*E37,0)))","v":0},{"$f":"IF(A4=1,((D37*2)/12)*E37,IF(A4=2,((D37*2)*E37),IF(A4=3,((D37*0.00328083)*2)*E37,0)))","v":0},{"$f":"IF(J37>0,(J37+(0.33*E37))/8,0)","v":0},{"$f":"IF(A4=1,(C37/12)*E37,IF(A4=2,C37*E37,IF(A4=3,(C37*0.00328083)*E37,0)))","v":0},{"$f":"SUMIF(F36:F45,4,H36:H45)","v":0},{"$f":"IF(Data!AB64=1,\"Nombre de Closoir\",\"Nombre de  Closoir SantaFe\")","v":"Nombre de Closoir"}]
[null,3,null,null,1,{"$f":"Data!Z31","v":6},{"$f":"IF(A4=1,((C38*D38)*E38)/144,IF(A4=2,(C38*D38)*E38,IF(A4=3,((C38*D38)/1000000)*E38,0)))","v":0},{"$f":"IF(A4=1,((D38*2)/12)*E38,IF(A4=2,((D38*2)*E38),IF(A4=3,((D38*0.00328083)*2)*E38,0)))","v":0},0,{"$f":"IF(A4=1,(C38/12)*E38,IF(A4=2,C38*E38,IF(A4=3,(C38*0.00328083)*E38,0)))","v":0},{"$f":"SUMIF(F36:F45,6,H36:H45)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K38,0)","v":0}]
[null,4,null,null,1,{"$f":"Data!Z32","v":6},{"$f":"IF(A4=1,((C39*D39)*E39)/144,IF(A4=2,(C39*D39)*E39,IF(A4=3,((C39*D39)/1000000)*E39,0)))","v":0},{"$f":"IF(A4=1,((D39*2)/12)*E39,IF(A4=2,((D39*2)*E39),IF(A4=3,((D39*0.00328083)*2)*E39,0)))","v":0},0,{"$f":"IF(A4=1,(C39/12)*E39,IF(A4=2,C39*E39,IF(A4=3,(C39*0.00328083)*E39,0)))","v":0},{"$f":"SUMIF(F36:F45,8,H36:H45)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K39,0)","v":0}]
["Notes",5,null,null,1,{"$f":"Data!Z33","v":6},{"$f":"IF(A4=1,((C40*D40)*E40)/144,IF(A4=2,(C40*D40)*E40,IF(A4=3,((C40*D40)/1000000)*E40,0)))","v":0},{"$f":"IF(A4=1,((D40*2)/12)*E40,IF(A4=2,((D40*2)*E40),IF(A4=3,((D40*0.00328083)*2)*E40,0)))","v":0},0,{"$f":"IF(A4=1,(C40/12)*E40,IF(A4=2,C40*E40,IF(A4=3,(C40*0.00328083)*E40,0)))","v":0},{"$f":"SUMIF(F36:F45,10,H36:H45)","v":0},null,"10\"",null,{"$f":"IF(K40>=1,\"N / A\",0)","v":0}]
[null,6,null,null,1,{"$f":"Data!Z34","v":6},{"$f":"IF(A4=1,((C41*D41)*E41)/144,IF(A4=2,(C41*D41)*E41,IF(A4=3,((C41*D41)/1000000)*E41,0)))","v":0},{"$f":"IF(A4=1,((D41*2)/12)*E41,IF(A4=2,((D41*2)*E41),IF(A4=3,((D41*0.00328083)*2)*E41,0)))","v":0},0,{"$f":"IF(A4=1,(C41/12)*E41,IF(A4=2,C41*E41,IF(A4=3,(C41*0.00328083)*E41,0)))","v":0},{"$f":"SUMIF(F36:F45,4,I36:I45)","v":0},{"$f":"IF(Data!AB64=1,\"Nombre d'Entête - Longueur\",\"Nombre d'Entête SantaFe - Longueur\")","v":"Nombre d'Entête - Longueur"}]
[null,7,null,null,1,{"$f":"Data!Z35","v":6},{"$f":"IF(A4=1,((C42*D42)*E42)/144,IF(A4=2,(C42*D42)*E42,IF(A4=3,((C42*D42)/1000000)*E42,0)))","v":0},{"$f":"IF(A4=1,((D42*2)/12)*E42,IF(A4=2,((D42*2)*E42),IF(A4=3,((D42*0.00328083)*2)*E42,0)))","v":0},0,{"$f":"IF(A4=1,(C42/12)*E42,IF(A4=2,C42*E42,IF(A4=3,(C42*0.00328083)*E42,0)))","v":0},{"$f":"SUMIF(F36:F45,6,I36:I45)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K42,0)","v":0}]
[null,8,null,null,1,{"$f":"Data!Z37","v":6},{"$f":"IF(A4=1,((C43*D43)*E43)/144,IF(A4=2,(C43*D43)*E43,IF(A4=3,((C43*D43)/1000000)*E43,0)))","v":0},{"$f":"IF(A4=1,((D43*2)/12)*E43,IF(A4=2,((D43*2)*E43),IF(A4=3,((D43*0.00328083)*2)*E43,0)))","v":0},0,{"$f":"IF(A4=1,(C43/12)*E43,IF(A4=2,C43*E43,IF(A4=3,(C43*0.00328083)*E43,0)))","v":0},{"$f":"SUMIF(F36:F45,8,I36:I45)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K43,0)","v":0}]
["Liste de Prix",9,null,null,1,{"$f":"Data!Z38","v":6},{"$f":"IF(A4=1,((C44*D44)*E44)/144,IF(A4=2,(C44*D44)*E44,IF(A4=3,((C44*D44)/1000000)*E44,0)))","v":0},{"$f":"IF(A4=1,((D44*2)/12)*E44,IF(A4=2,((D44*2)*E44),IF(A4=3,((D44*0.00328083)*2)*E44,0)))","v":0},0,{"$f":"IF(A4=1,(C44/12)*E44,IF(A4=2,C44*E44,IF(A4=3,(C44*0.00328083)*E44,0)))","v":0},{"$f":"SUMIF(F36:F45,10,I36:I45)","v":0},null,"10\"",null,{"$f":"IF(K44>=1,\"N / A\",0)","v":0}]
[null,10,null,null,1,{"$f":"Data!Z39","v":6},{"$f":"IF(A4=1,((C45*D45)*E45)/144,IF(A4=2,(C45*D45)*E45,IF(A4=3,((C45*D45)/1000000)*E45,0)))","v":0},{"$f":"IF(A4=1,((D45*2)/12)*E45,IF(A4=2,((D45*2)*E45),IF(A4=3,((D45*0.00328083)*2)*E45,0)))","v":0},0,{"$f":"IF(A4=1,(C45/12)*E45,IF(A4=2,C45*E45,IF(A4=3,(C45*0.00328083)*E45,0)))","v":0},null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A1=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A2=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A3=TRUE,\"Ou Entrer la valeur totale en M/ca.\")))","v":"Ou Entrer la valeur totale en Pi./ca."}]
[]
["Page Retour","Ouverture","Largeur","Hauteur","Quantité","Larg. Béton",{"$f":"IF(A1=TRUE,\"Pi. Carré\",IF(A2=TRUE,\"Pi. Carré\",IF(A3=TRUE,\"Metre Carré\")))","v":"Pi. Carré"},"Closoir","Entête",null,null,"Superficie Totale /",null,null,{"$f":"IF(A1=TRUE,\"Pied\",IF(A2=TRUE,\"Pied\",IF(A3=TRUE,\"Mètre\")))","v":"Pied"}]
[null,1,null,null,1,{"$f":"Data!Z40","v":6},{"$f":"IF(A4=1,((C49*D49)*E49)/144,IF(A4=2,(C49*D49)*E49,IF(A4=3,((C49*D49)/1000000)*E49,0)))","v":0},{"$f":"IF(A4=1,((D49*2)/12)*E49,IF(A4=2,((D49*2)*E49),IF(A4=3,((D49*0.00328083)*2)*E49,0)))","v":0},{"$f":"IF(J49>0,(J49+(0.33*E49))/8,0)","v":0},{"$f":"IF(A4=1,(C49/12)*E49,IF(A4=2,C49*E49,IF(A4=3,(C49*0.00328083)*E49,0)))","v":0},null," Aire d'Ouverture",null,null,{"$f":"SUM(G49:G58)","v":0}]
[null,2,null,null,1,{"$f":"Data!Z41","v":6},{"$f":"IF(A4=1,((C50*D50)*E50)/144,IF(A4=2,(C50*D50)*E50,IF(A4=3,((C50*D50)/1000000)*E50,0)))","v":0},{"$f":"IF(A4=1,((D50*2)/12)*E50,IF(A4=2,((D50*2)*E50),IF(A4=3,((D50*0.00328083)*2)*E50,0)))","v":0},0,{"$f":"IF(A4=1,(C50/12)*E50,IF(A4=2,C50*E50,IF(A4=3,(C50*0.00328083)*E50,0)))","v":0},{"$f":"SUMIF(F49:F58,4,H49:H58)","v":0},{"$f":"IF(Data!AB65=1,\"Nombre de Closoir\",\"Nombre de  Closoir SantaFe\")","v":"Nombre de Closoir"}]
[null,3,null,null,1,{"$f":"Data!Z42","v":6},{"$f":"IF(A4=1,((C51*D51)*E51)/144,IF(A4=2,(C51*D51)*E51,IF(A4=3,((C51*D51)/1000000)*E51,0)))","v":0},{"$f":"IF(A4=1,((D51*2)/12)*E51,IF(A4=2,((D51*2)*E51),IF(A4=3,((D51*0.00328083)*2)*E51,0)))","v":0},0,{"$f":"IF(A4=1,(C51/12)*E51,IF(A4=2,C51*E51,IF(A4=3,(C51*0.00328083)*E51,0)))","v":0},{"$f":"SUMIF(F49:F58,6,H49:H58)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K51,0)","v":0}]
["Transport",4,null,null,1,{"$f":"Data!Z43","v":6},{"$f":"IF(A4=1,((C52*D52)*E52)/144,IF(A4=2,(C52*D52)*E52,IF(A4=3,((C52*D52)/1000000)*E52,0)))","v":0},{"$f":"IF(A4=1,((D52*2)/12)*E52,IF(A4=2,((D52*2)*E52),IF(A4=3,((D52*0.00328083)*2)*E52,0)))","v":0},0,{"$f":"IF(A4=1,(C52/12)*E52,IF(A4=2,C52*E52,IF(A4=3,(C52*0.00328083)*E52,0)))","v":0},{"$f":"SUMIF(F49:F58,8,H49:H58)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K52,0)","v":0}]
[null,5,null,null,1,{"$f":"Data!Z44","v":6},{"$f":"IF(A4=1,((C53*D53)*E53)/144,IF(A4=2,(C53*D53)*E53,IF(A4=3,((C53*D53)/1000000)*E53,0)))","v":0},{"$f":"IF(A4=1,((D53*2)/12)*E53,IF(A4=2,((D53*2)*E53),IF(A4=3,((D53*0.00328083)*2)*E53,0)))","v":0},0,{"$f":"IF(A4=1,(C53/12)*E53,IF(A4=2,C53*E53,IF(A4=3,(C53*0.00328083)*E53,0)))","v":0},{"$f":"SUMIF(F49:F58,10,H49:H58)","v":0},null,"10\"",null,{"$f":"IF(K53>=1,\"N / A\",0)","v":0}]
[null,6,null,null,1,{"$f":"Data!Z45","v":6},{"$f":"IF(A4=1,((C54*D54)*E54)/144,IF(A4=2,(C54*D54)*E54,IF(A4=3,((C54*D54)/1000000)*E54,0)))","v":0},{"$f":"IF(A4=1,((D54*2)/12)*E54,IF(A4=2,((D54*2)*E54),IF(A4=3,((D54*0.00328083)*2)*E54,0)))","v":0},0,{"$f":"IF(A4=1,(C54/12)*E54,IF(A4=2,C54*E54,IF(A4=3,(C54*0.00328083)*E54,0)))","v":0},{"$f":"SUMIF(F49:F58,4,I49:I58)","v":0},{"$f":"IF(Data!AB65=1,\"Nombre d'Entête - Longueur\",\"Nombre d'Entête SantaFe - Longueur\")","v":"Nombre d'Entête - Longueur"}]
[null,7,null,null,1,{"$f":"Data!Z47","v":6},{"$f":"IF(A4=1,((C55*D55)*E55)/144,IF(A4=2,(C55*D55)*E55,IF(A4=3,((C55*D55)/1000000)*E55,0)))","v":0},{"$f":"IF(A4=1,((D55*2)/12)*E55,IF(A4=2,((D55*2)*E55),IF(A4=3,((D55*0.00328083)*2)*E55,0)))","v":0},0,{"$f":"IF(A4=1,(C55/12)*E55,IF(A4=2,C55*E55,IF(A4=3,(C55*0.00328083)*E55,0)))","v":0},{"$f":"SUMIF(F49:F58,6,I49:I58)","v":0},null,"6\"",null,{"$f":"ROUNDUP(K55,0)","v":0}]
[null,8,null,null,1,{"$f":"Data!Z49","v":6},{"$f":"IF(A4=1,((C56*D56)*E56)/144,IF(A4=2,(C56*D56)*E56,IF(A4=3,((C56*D56)/1000000)*E56,0)))","v":0},{"$f":"IF(A4=1,((D56*2)/12)*E56,IF(A4=2,((D56*2)*E56),IF(A4=3,((D56*0.00328083)*2)*E56,0)))","v":0},0,{"$f":"IF(A4=1,(C56/12)*E56,IF(A4=2,C56*E56,IF(A4=3,(C56*0.00328083)*E56,0)))","v":0},{"$f":"SUMIF(F49:F58,8,I49:I58)","v":0},null,"8\"",null,{"$f":"ROUNDUP(K56,0)","v":0}]
[null,9,null,null,1,{"$f":"Data!Z50","v":6},{"$f":"IF(A4=1,((C57*D57)*E57)/144,IF(A4=2,(C57*D57)*E57,IF(A4=3,((C57*D57)/1000000)*E57,0)))","v":0},{"$f":"IF(A4=1,((D57*2)/12)*E57,IF(A4=2,((D57*2)*E57),IF(A4=3,((D57*0.00328083)*2)*E57,0)))","v":0},0,{"$f":"IF(A4=1,(C57/12)*E57,IF(A4=2,C57*E57,IF(A4=3,(C57*0.00328083)*E57,0)))","v":0},{"$f":"SUMIF(F49:F58,10,I49:I58)","v":0},null,"10\"",null,{"$f":"IF(K57>=1,\"N / A\",0)","v":0}]
[null,10,null,null,1,{"$f":"Data!Z51","v":6},{"$f":"IF(A4=1,((C58*D58)*E58)/144,IF(A4=2,(C58*D58)*E58,IF(A4=3,((C58*D58)/1000000)*E58,0)))","v":0},{"$f":"IF(A4=1,((D58*2)/12)*E58,IF(A4=2,((D58*2)*E58),IF(A4=3,((D58*0.00328083)*2)*E58,0)))","v":0},0,{"$f":"IF(A4=1,(C58/12)*E58,IF(A4=2,C58*E58,IF(A4=3,(C58*0.00328083)*E58,0)))","v":0},null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A1=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A2=TRUE,\"Ou Entrer la valeur totale en Pi./ca.\",IF(A3=TRUE,\"Ou Entrer la valeur totale en M/ca.\")))","v":"Ou Entrer la valeur totale en Pi./ca."}]

{"sheet":"Example","index":8,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,null,null,"Coin 45 Degrée Intérieur = 2"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Coin 45 Degrée Extérieur = 2"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Coin 90 Degré Extérieur = 7"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Coin 90 Degré Intérieur = 3"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Mur en T (Coin 90 Deg. Intérieur) = 2"]

{"sheet":"Débuter","index":9,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Info Client",null,"Ouvrir Fichier",null,"Liste des Prix",null,"Début",null,"Notes",null,"Sortie"]
[]
[]
["IntegraSpec Corp."]
["Tel: 1-800-382-9102 - www.integraspec.com",null,null,null,null,null,null,null,null,null,null,"Tout Droit Reservé 2025©"]

{"sheet":"Notes","index":10,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":true,"merged":[[71,0,71,16],[70,1,70,6],[64,1,64,16],[65,1,65,16],[66,1,66,16],[67,1,67,16],[68,1,68,16],[69,1,69,16],[70,7,70,8],[70,15,70,16],[70,9,70,10],[70,11,70,12],[70,13,70,14],[9,14,9,16],[10,13,10,16],[11,13,11,16],[12,13,12,16],[63,1,63,16],[58,1,58,16],[59,1,59,16],[60,1,60,16],[41,1,41,16],[42,1,42,16],[61,1,61,16],[62,1,62,16],[50,1,50,16],[57,1,57,16],[52,1,52,16],[53,1,53,16],[54,1,54,16],[55,1,55,16],[48,1,48,16],[49,1,49,16],[37,1,37,16],[38,1,38,16],[39,1,39,16],[35,1,35,16],[16,10,16,11],[40,1,40,16],[56,1,56,16],[51,1,51,16],[44,1,44,16],[45,1,45,16],[46,1,46,16],[47,1,47,16],[43,1,43,16],[19,14,19,16],[25,14,25,16],[25,7,25,8],[20,1,20,6],[21,1,21,6],[22,1,22,6],[23,1,23,6],[20,7,20,8],[28,10,28,11],[26,7,26,8],[27,7,27,8],[24,14,24,16],[20,14,20,16],[21,14,21,16],[22,14,22,16],[23,14,23,16],[36,1,36,16],[21,7,21,8],[22,7,22,8],[23,7,23,8],[25,1,25,6],[30,1,30,16],[31,1,31,16],[32,1,32,16],[33,1,33,16],[34,1,34,16],[26,1,26,6],[27,1,27,6],[28,1,28,6],[28,7,28,8],[28,14,28,16],[27,14,27,16],[26,14,26,16],[1,0,1,4],[2,0,2,4],[4,0,4,4],[6,2,6,4],[5,0,5,1],[5,2,5,4],[3,0,3,2],[3,3,3,4],[19,1,19,6],[6,0,6,1],[9,1,9,5],[10,1,10,5],[11,1,11,5],[13,3,13,5],[12,3,12,5],[13,1,13,2],[12,1,12,2],[15,0,15,13],[11,9,11,11],[12,9,12,11],[10,9,10,11],[17,7,17,8],[17,10,17,11],[9,9,9,11],[13,13,13,16],[18,10,18,11],[17,1,17,6],[16,1,16,6],[18,1,18,6],[29,0,29,16],[15,14,15,16],[19,10,19,11],[25,10,25,11],[26,10,26,11],[27,10,27,11],[20,10,20,11],[21,10,21,11],[22,10,22,11],[23,10,23,11],[24,1,24,6],[24,10,24,11],[18,7,18,8],[19,7,19,8],[24,7,24,8],[16,7,16,8],[18,14,18,16],[17,14,17,16],[16,14,16,16]]}
[]
[{"$f":"(Sommaire!A2)","v":"Compagnie / Distributeur"}]
[{"$f":"(Sommaire!A3)","v":"Addresse"}]
[{"$f":"(Sommaire!A4)","v":"Ville"},null,null,{"$f":"(Sommaire!D4)","v":"Province"}]
[{"$f":"(Sommaire!A5)","v":"Code Postale"}]
["Telephone"]
[{"$f":"(Sommaire!A7)","v":"xxx-xxx-xxxx"},null,{"$f":"(Sommaire!C7)","v":"xxx-xxx-xxxx"}]
[]
[]
["Nom",{"$f":"Data!C2","v":""},null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2025-02-06"},null,null,null,"Notes:"]
["Addresse",{"$f":"Data!C3","v":""},null,null,null,null,null,null,"Projet:",{"$f":"Data!C23","v":""}]
["Ville",{"$f":"Data!C4","v":""},null,null,null,null,null,null,"Location:",{"$f":"Data!C30","v":0}]
["Tel",{"$f":"CONCATENATE(\"W. \",Data!C8)","v":"W. "},null,{"$f":"CONCATENATE(\"R. \",Data!C9)","v":"R. "},null,null,null,null,"Autre:",{"$f":"Data!C31","v":0}]
[null,{"$f":"CONCATENATE(\"C. \",Data!C10)","v":"C. "},null,{"$f":"CONCATENATE(\"F. \",Data!C11)","v":"F. "}]
[]
["Sommaire et Détaile de Mur(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Espacement d'Acier"]
["Wall","Description / Notes",null,null,null,null,null,"Longueur",null,"Hauteur","Larg. Béton",null,"90 deg.","45 deg.","   Verticale (c.c.)   Horizontale (c.c.) "]
[1,{"$f":"'Detaile Mur 1-4'!G10","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C14>0,CONCATENATE('Detaile Mur 1-4'!C14,\" \",\"mm\"),IF('Detaile Mur 1-4'!C13>0,CONCATENATE('Detaile Mur 1-4'!C13,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E14>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E14,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E13>0,CONCATENATE('Detaile Mur 1-4'!E13,\" pi.\",),\"\"))","v":""},{"$f":"IF(H18=\" \",\" \",Data!E71)","v":" "},null,{"$f":"Data!E12+Data!E13","v":0},{"$f":"Data!E14","v":0}]
[2,{"$f":"'Detaile Mur 1-4'!G23","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C27>0,CONCATENATE('Detaile Mur 1-4'!C27,\" \",\"mm\"),IF('Detaile Mur 1-4'!C26>0,CONCATENATE('Detaile Mur 1-4'!C26,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E27>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E27,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E26>0,CONCATENATE('Detaile Mur 1-4'!E26,\" pi.\",),\"\"))","v":""},{"$f":"IF(H19=\" \",\" \",Data!F71)","v":" "},null,{"$f":"Data!F12+Data!F13","v":0},{"$f":"Data!F14","v":0}]
[3,{"$f":"'Detaile Mur 1-4'!G35","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C39>0,CONCATENATE('Detaile Mur 1-4'!C39,\" \",\"mm\"),IF('Detaile Mur 1-4'!C38>0,CONCATENATE('Detaile Mur 1-4'!C38,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E39>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E39,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E38>0,CONCATENATE('Detaile Mur 1-4'!E38,\" pi.\",),\"\"))","v":""},{"$f":"IF(H20=\" \",\" \",Data!G71)","v":" "},null,{"$f":"Data!G12+Data!G13","v":0},{"$f":"Data!G14","v":0}]
[4,{"$f":"'Detaile Mur 1-4'!G48","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 1-4'!C52>0,CONCATENATE('Detaile Mur 1-4'!C52,\" \",\"mm\"),IF('Detaile Mur 1-4'!C51>0,CONCATENATE('Detaile Mur 1-4'!C51,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 1-4'!E52>0,CONCATENATE(ROUND('Detaile Mur 1-4'!E52,0),\" \",\"mm\"),IF('Detaile Mur 1-4'!E51>0,CONCATENATE('Detaile Mur 1-4'!E51,\" pi.\",),\"\"))","v":""},{"$f":"IF(H21=\" \",\" \",Data!H71)","v":" "},null,{"$f":"Data!H12+Data!H13","v":0},{"$f":"Data!H14","v":0}]
[5,{"$f":"'Detaile Mur 5-8'!G10","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C14>0,CONCATENATE('Detaile Mur 5-8'!C14,\" \",\"mm\"),IF('Detaile Mur 5-8'!C13>0,CONCATENATE('Detaile Mur 5-8'!C13,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E14>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E14,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E13>0,CONCATENATE('Detaile Mur 5-8'!E13,\" pi.\",),\"\"))","v":""},{"$f":"IF(H22=\" \",\" \",Data!I71)","v":" "},null,{"$f":"Data!I12+Data!I13","v":0},{"$f":"Data!I14","v":0}]
[6,{"$f":"'Detaile Mur 5-8'!G23","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C27>0,CONCATENATE('Detaile Mur 5-8'!C27,\" \",\"mm\"),IF('Detaile Mur 5-8'!C26>0,CONCATENATE('Detaile Mur 5-8'!C26,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E27>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E27,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E26>0,CONCATENATE('Detaile Mur 5-8'!E26,\" pi.\",),\"\"))","v":""},{"$f":"IF(H23=\" \",\" \",Data!J71)","v":" "},null,{"$f":"Data!J12+Data!J13","v":0},{"$f":"Data!J14","v":0}]
[7,{"$f":"'Detaile Mur 5-8'!G35","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C39>0,CONCATENATE('Detaile Mur 5-8'!C39,\" \",\"mm\"),IF('Detaile Mur 5-8'!C38>0,CONCATENATE('Detaile Mur 5-8'!C38,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E39>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E39,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E38>0,CONCATENATE('Detaile Mur 5-8'!E38,\" pi.\",),\"\"))","v":""},{"$f":"IF(H24=\" \",\" \",Data!K71)","v":" "},null,{"$f":"Data!K12+Data!K13","v":0},{"$f":"Data!K14","v":0}]
[8,{"$f":"'Detaile Mur 5-8'!G48","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 5-8'!C52>0,CONCATENATE('Detaile Mur 5-8'!C52,\" \",\"mm\"),IF('Detaile Mur 5-8'!C51>0,CONCATENATE('Detaile Mur 5-8'!C51,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 5-8'!E52>0,CONCATENATE(ROUND('Detaile Mur 5-8'!E52,0),\" \",\"mm\"),IF('Detaile Mur 5-8'!E51>0,CONCATENATE('Detaile Mur 5-8'!E51,\" pi.\",),\"\"))","v":""},{"$f":"IF(H25=\" \",\" \",Data!L71)","v":" "},null,{"$f":"Data!L12+Data!L13","v":0},{"$f":"Data!L14","v":0}]
[9,{"$f":"'Detaile Mur 9-12'!G10","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C14>0,CONCATENATE('Detaile Mur 9-12'!C14,\" \",\"mm\"),IF('Detaile Mur 9-12'!C13>0,CONCATENATE('Detaile Mur 9-12'!C13,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E14>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E14,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E13>0,CONCATENATE('Detaile Mur 9-12'!E13,\" pi.\",),\"\"))","v":""},{"$f":"IF(H26=\" \",\" \",Data!M71)","v":" "},null,{"$f":"Data!M12+Data!M13","v":0},{"$f":"Data!M14","v":0}]
[10,{"$f":"'Detaile Mur 9-12'!G23","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C27>0,CONCATENATE('Detaile Mur 9-12'!C27,\" \",\"mm\"),IF('Detaile Mur 9-12'!C26>0,CONCATENATE('Detaile Mur 9-12'!C26,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E27>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E27,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E26>0,CONCATENATE('Detaile Mur 9-12'!E26,\" pi.\",),\"\"))","v":""},{"$f":"IF(H27=\" \",\" \",Data!N71)","v":" "},null,{"$f":"Data!N12+Data!N13","v":0},{"$f":"Data!N14","v":0}]
[11,{"$f":"'Detaile Mur 9-12'!G35","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C39>0,CONCATENATE('Detaile Mur 9-12'!C39,\" \",\"mm\"),IF('Detaile Mur 9-12'!C38>0,CONCATENATE('Detaile Mur 9-12'!C38,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E39>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E39,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E38>0,CONCATENATE('Detaile Mur 9-12'!E38,\" pi.\",),\"\"))","v":""},{"$f":"IF(H28=\" \",\" \",Data!O71)","v":" "},null,{"$f":"Data!O12+Data!O13","v":0}]
[12,{"$f":"'Detaile Mur 9-12'!G48","v":0},null,null,null,null,null,{"$f":"IF('Detaile Mur 9-12'!C52>0,CONCATENATE('Detaile Mur 9-12'!C52,\" \",\"mm\"),IF('Detaile Mur 9-12'!C51>0,CONCATENATE('Detaile Mur 9-12'!C51,\" pi.\",),\" \"))","v":" "},null,{"$f":"IF('Detaile Mur 9-12'!E52>0,CONCATENATE(ROUND('Detaile Mur 9-12'!E52,0),\" \",\"mm\"),IF('Detaile Mur 9-12'!E51>0,CONCATENATE('Detaile Mur 9-12'!E51,\" pi.\",),\"\"))","v":""},{"$f":"IF(H29=\" \",\" \",Data!P71)","v":" "},null,{"$f":"Data!P12+Data!P13","v":0},{"$f":"Data!P14","v":0}]
["Notes Importantes"]
[]
[]
[null,"Veuillez vérifier que toutes les dimensions et données entrées dans les feuilles \"Détail Mur (1 à 12)\" et \"Ouverture\" sont exactes"]
[null,"Le sommaire inclut les quantités de béton et de barres d’armature (lorsque choisi) à des fins budgétaire mes pas inclus dans le prix."]
[null,"Le transport, main-d'œuvre et le support technique sont à déterminer et ne sont pas inclus."]
[null,"Les prix sont basés sur des paquets complets ou des boîtes."]
[null,{"$f":"IF(Data!Q63>0,\"*** You have chosen a 10 inch concrete core, which the program has calculated additional 4 and 6 inch webs plus an H-clip for each corner ***\",\"\")","v":""}]
[null,{"$f":"IF('Liste de Prix'!E29>=1,\"*** You have selected a 12 inch concrete core which cannot used preformed corners and will require mitre cut standards on site ***\",\"\")","v":""}]
[]
[null,"Les barres d’armature sont basées sur la conception technique standard de 24 \"(H) x 16\" (V). Veuillez confirmer avec le code / ingénieur."]
[]
[]
[null,"Autre Détaile à Noter:"]

{"sheet":"Data","index":11,"n_rows":72,"n_cols":28,"rows_kept":72,"cut":false,"hidden":true,"merged":[[60,25,60,26],[65,2,66,2],[28,18,28,19],[4,22,4,24],[21,18,21,19],[23,18,23,19],[26,18,26,19]]}
[null,"Tab=Client",null,null,"Mur 1","Mur 2","Mur 3","Mur 4","Mur 5","Mur 6","Mur 7","Mur 8","Mur 9","Mur 10","Mur 11","Mur 12"]
[null,"Nom","","Descrip.",{"$f":"'Detaile Mur 1-4'!G10","v":0},{"$f":"'Detaile Mur 1-4'!G23","v":0},{"$f":"'Detaile Mur 1-4'!G35","v":0},{"$f":"'Detaile Mur 1-4'!G48","v":0},{"$f":"'Detaile Mur 5-8'!G10","v":0},{"$f":"'Detaile Mur 5-8'!G23","v":0},{"$f":"'Detaile Mur 5-8'!G35","v":0},{"$f":"'Detaile Mur 5-8'!G48","v":0},{"$f":"'Detaile Mur 9-12'!G10","v":0},{"$f":"'Detaile Mur 9-12'!G23","v":0},{"$f":"'Detaile Mur 9-12'!G35","v":0},{"$f":"'Detaile Mur 9-12'!G48","v":0}]
[null,"Addresse","","Longueur",{"$f":"IF('Detaile Mur 1-4'!C14>0,'Detaile Mur 1-4'!C14*0.00328083,'Detaile Mur 1-4'!C13)","v":0},{"$f":"IF('Detaile Mur 1-4'!C27>0,'Detaile Mur 1-4'!C27*0.00328083,'Detaile Mur 1-4'!C26)","v":0},{"$f":"IF('Detaile Mur 1-4'!C39>0,'Detaile Mur 1-4'!C39*0.00328083,'Detaile Mur 1-4'!C38)","v":0},{"$f":"IF('Detaile Mur 1-4'!C52>0,'Detaile Mur 1-4'!C52*0.00328083,'Detaile Mur 1-4'!C51)","v":0},{"$f":"IF('Detaile Mur 5-8'!C14>0,'Detaile Mur 5-8'!C14*0.00328083,'Detaile Mur 5-8'!C13)","v":0},{"$f":"IF('Detaile Mur 5-8'!C27>0,'Detaile Mur 5-8'!C27*0.00328083,'Detaile Mur 5-8'!C26)","v":0},{"$f":"IF('Detaile Mur 5-8'!C39>0,'Detaile Mur 5-8'!C39*0.00328083,'Detaile Mur 5-8'!C38)","v":0},{"$f":"IF('Detaile Mur 5-8'!C52>0,'Detaile Mur 5-8'!C52*0.00328083,'Detaile Mur 5-8'!C51)","v":0},{"$f":"IF('Detaile Mur 9-12'!C14>0,'Detaile Mur 9-12'!C14*0.00328083,'Detaile Mur 9-12'!C13)","v":0},{"$f":"IF('Detaile Mur 9-12'!C27>0,'Detaile Mur 9-12'!C27*0.00328083,'Detaile Mur 9-12'!C26)","v":0},{"$f":"IF('Detaile Mur 9-12'!C39>0,'Detaile Mur 9-12'!C39*0.00328083,'Detaile Mur 9-12'!C38)","v":0},{"$f":"IF('Detaile Mur 9-12'!C52>0,'Detaile Mur 9-12'!C52*0.00328083,'Detaile Mur 9-12'!C51)","v":0}]
[null,"Ville","","Hauteur",{"$f":"IF('Detaile Mur 1-4'!E14>0,'Detaile Mur 1-4'!E14*0.00328083,'Detaile Mur 1-4'!E13)","v":0},{"$f":"IF('Detaile Mur 1-4'!E27>0,'Detaile Mur 1-4'!E27*0.00328083,'Detaile Mur 1-4'!E26)","v":0},{"$f":"IF('Detaile Mur 1-4'!E39>0,'Detaile Mur 1-4'!E39*0.00328083,'Detaile Mur 1-4'!E38)","v":0},{"$f":"IF('Detaile Mur 1-4'!E52>0,'Detaile Mur 1-4'!E52*0.00328083,'Detaile Mur 1-4'!E51)","v":0},{"$f":"IF('Detaile Mur 5-8'!E14>0,'Detaile Mur 5-8'!E14*0.00328083,'Detaile Mur 5-8'!E13)","v":0},{"$f":"IF('Detaile Mur 5-8'!E27>0,'Detaile Mur 5-8'!E27*0.00328083,'Detaile Mur 5-8'!E26)","v":0},{"$f":"IF('Detaile Mur 5-8'!E39>0,'Detaile Mur 5-8'!E39*0.00328083,'Detaile Mur 5-8'!E38)","v":0},{"$f":"IF('Detaile Mur 5-8'!E52>0,'Detaile Mur 5-8'!E52*0.00328083,'Detaile Mur 5-8'!E51)","v":0},{"$f":"IF('Detaile Mur 9-12'!E14>0,'Detaile Mur 9-12'!E14*0.00328083,'Detaile Mur 9-12'!E13)","v":0},{"$f":"IF('Detaile Mur 9-12'!E27>0,'Detaile Mur 9-12'!E27*0.00328083,'Detaile Mur 9-12'!E26)","v":0},{"$f":"IF('Detaile Mur 9-12'!E39>0,'Detaile Mur 9-12'!E39*0.00328083,'Detaile Mur 9-12'!E38)","v":0},{"$f":"IF('Detaile Mur 9-12'!E52>0,'Detaile Mur 9-12'!E52*0.00328083,'Detaile Mur 9-12'!E51)","v":0}]
[null,"Code Postal / Zip","","Larg. Béton","Core","Core","Core","Core","Core","Core","Core","Core","Core","Core","Core","Core",null,null,null,null,null,null,"Moin Béton; Ouverture"]
[null,"Tab=Telephone",null,"4po / 102mm",3,3,3,3,3,3,3,3,3,3,3,3,null,null,"Pied Ca.",null,null,null,null,"Mètre","Verge","Larg. Béton","Moin ins.","Correction Larg. Béton"]
[null,null,null,"5po / 127mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G10*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G10*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G10*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G10*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G10*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G10*(Z7*0.0254)*1.308,0)))","v":0},{"$f":"IF(AB7=1,4,IF(AB7=2,5,IF(AB7=3,6,IF(AB7=4,8,IF(AB7=5,10,IF(AB7=6,12,\"\"))))))","v":6},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G10/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G10/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G10*10.76/4.08*6,0)))","v":0},3]
[null,"Travaille","","6po / 152mm",{"$f":"IF(E6=1,\"4\",IF(E6=2,\"5\",IF(E6=3,\"6\",IF(E6=4,\"8\",IF(E6=5,\"10\",IF(E6=6,\"12\",\"\"))))))","v":"6"},{"$f":"IF(F6=1,\"4\",IF(F6=2,\"5\",IF(F6=3,\"6\",IF(F6=4,\"8\",IF(F6=5,\"10\",IF(F6=6,\"12\",\"\"))))))","v":"6"},"6","6","6","6","6","6","6","6","6","6","Core (N/A)",null,"Ouverture","total Sq. Ft.",null,null,2,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G11*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G11*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G11*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G11*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G11*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G11*(Z7*0.0254)*1.308,0)))","v":0},{"$f":"IF(AB8=1,4,IF(AB8=2,5,IF(AB8=3,6,IF(AB8=4,8,IF(AB8=5,10,IF(AB8=6,12,\"\"))))))","v":6},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G11/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G11/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G11*10.76/4.08*6,0)))","v":0},3]
[null,"Résidence","","8po / 203mm",{"$f":"SUM(E3*E4)","v":0},{"$f":"SUM(F3*F4)","v":0},{"$f":"PRODUCT(G3*G4)","v":0},0,0,0,0,0,0,0,0,0,"Pied Ca.(Mur)",{"$f":"SUM(E9:P9)","v":0},{"$f":"IF(Ouvertures!A1=TRUE,SUM(Ouvertures!O10+Ouvertures!O23+Ouvertures!O36+Ouvertures!O49+Ouvertures!O20+Ouvertures!O33+Ouvertures!O46+Ouvertures!O59),IF(Ouvertures!A2=TRUE,SUM(Ouvertures!O10+Ouvertures!O23+Ouvertures!O36+Ouvertures!O49+Ouvertures!O20+Ouvertures!O33+Ouvertures!O46+Ouvertures!O59),IF(Ouvertures!A3=TRUE,SUM(Ouvertures!O10+Ouvertures!O23+Ouvertures!O36+Ouvertures!O49+Ouvertures!O20+Ouvertures!O33+Ouvertures!O46+Ouvertures!O59)*10.76,0)))","v":0},{"$f":"SUM(R9-S9)","v":0},null,null,3,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G12*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G12*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G12*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G12*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G12*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G12*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G12/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G12/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G12*10.76/4.08*6,0)))","v":0},3]
[null,"Mobile","","10po / 254mm",{"$f":"SUM(E3+E60+E61)*E4*(E8/12)/35.3147","v":0},0,0,0,0,0,0,0,0,0,0,0,"Mètre Cu.",{"$f":"SUM(E10:P10)-X52+S15","v":0},{"$f":"S9/4.08*2","v":0},null,null,{"$f":"CEILING(R10,0.5)","v":0},4,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G13*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G13*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G13*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G13*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G13*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G13*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G13/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G13/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G13*10.76/4.08*6,0)))","v":0},3]
[null,"Fax","","12po / 305mm",{"$f":"SUM(E3+E60+E61)*E4*(E8/12)/27","v":0},0,0,0,0,0,0,0,0,0,0,0,"Verge Cu.",{"$f":"SUM(E11:P11)-Y52+T15","v":0},"90-8\"","90-10\"","90-12\"",{"$f":"CEILING(R11,0.5)","v":0},5,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G14*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G14*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G14*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G14*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G14*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G14*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G14/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G14/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G14*10.76/4.08*6,0)))","v":0},3]
[null,"Tab=Cert. Inst.",null,"90 deg. (outside)",{"$f":"'Detaile Mur 1-4'!I12","v":0},{"$f":"'Detaile Mur 1-4'!I25","v":0},{"$f":"'Detaile Mur 1-4'!I37","v":0},{"$f":"'Detaile Mur 1-4'!I50","v":0},{"$f":"'Detaile Mur 5-8'!I12","v":0},{"$f":"'Detaile Mur 5-8'!I25","v":0},{"$f":"'Detaile Mur 5-8'!I37","v":0},{"$f":"'Detaile Mur 5-8'!I50","v":0},{"$f":"'Detaile Mur 9-12'!I12","v":0},{"$f":"'Detaile Mur 9-12'!I25","v":0},{"$f":"'Detaile Mur 9-12'!I37","v":0},{"$f":"'Detaile Mur 9-12'!I50","v":0},"90 deg.-6\" Out",{"$f":"SUMIF($E$6:$P$6,\"=3\",E12:P12)","v":0},{"$f":"SUMIF($E$6:$P$6,\"=4\",E12:P12)+SUMIF($E$6:$P$6,\"=5\",E12:P12)","v":0},null,null,null,6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G15*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G15*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G15*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G15*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G15*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G15*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G15/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G15/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G15*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"90 deg. (inside)",{"$f":"+'Detaile Mur 1-4'!K12","v":0},{"$f":"+'Detaile Mur 1-4'!K25","v":0},{"$f":"+'Detaile Mur 1-4'!K37","v":0},{"$f":"+'Detaile Mur 1-4'!K50","v":0},{"$f":"+'Detaile Mur 5-8'!K12","v":0},{"$f":"+'Detaile Mur 5-8'!K25","v":0},{"$f":"+'Detaile Mur 5-8'!K37","v":0},{"$f":"+'Detaile Mur 5-8'!K50","v":0},{"$f":"+'Detaile Mur 9-12'!K12","v":0},{"$f":"+'Detaile Mur 9-12'!K25","v":0},{"$f":"+'Detaile Mur 9-12'!K37","v":0},{"$f":"+'Detaile Mur 9-12'!K50","v":0},"90 deg.-6\" po",{"$f":"SUMIF($E$6:$P$6,\"=3\",E13:P13)","v":0},{"$f":"SUMIF($E$6:$P$6,\"=4\",E13:P13)+SUMIF($E$6:$P$6,\"=5\",E13:P13)","v":0}]
[null,"Nom","","45 deg.",{"$f":"'Detaile Mur 1-4'!I14+'Detaile Mur 1-4'!K14","v":0},{"$f":"'Detaile Mur 1-4'!I27+'Detaile Mur 1-4'!K27","v":0},{"$f":"'Detaile Mur 1-4'!I39+'Detaile Mur 1-4'!K39","v":0},{"$f":"'Detaile Mur 1-4'!I52+'Detaile Mur 1-4'!K52","v":0},{"$f":"'Detaile Mur 5-8'!I14+'Detaile Mur 5-8'!K14","v":0},{"$f":"'Detaile Mur 5-8'!I27+'Detaile Mur 5-8'!K27","v":0},{"$f":"'Detaile Mur 5-8'!I39+'Detaile Mur 5-8'!K39","v":0},{"$f":"'Detaile Mur 5-8'!I52+'Detaile Mur 5-8'!K52","v":0},{"$f":"'Detaile Mur 9-12'!I14+'Detaile Mur 9-12'!K14","v":0},{"$f":"'Detaile Mur 9-12'!I27+'Detaile Mur 9-12'!K27","v":0},{"$f":"'Detaile Mur 9-12'!I39+'Detaile Mur 9-12'!K39","v":0},{"$f":"'Detaile Mur 9-12'!I52+'Detaile Mur 9-12'!K52","v":0},"45 deg.",{"$f":"SUM(E14+F14+G14+H14+I14+J14+K14+L14+M14+N14+O14+P14)","v":0},"Béton Mètre","Béton Verge",null,null,7,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G16*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G16*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G16*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G16*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G16*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G16*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G16/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G16/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G16*10.76/4.08*6,0)))","v":0},3]
[null,"Telephone","","BrickLedge (ft)",{"$f":"IF('Detaile Mur 1-4'!P11>0,'Detaile Mur 1-4'!P11*0.00328083,'Detaile Mur 1-4'!P10)","v":0},{"$f":"IF('Detaile Mur 1-4'!P24>0,'Detaile Mur 1-4'!P24*0.00328083,'Detaile Mur 1-4'!P23)","v":0},{"$f":"IF('Detaile Mur 1-4'!P36>0,'Detaile Mur 1-4'!P36*0.00328083,'Detaile Mur 1-4'!P35)","v":0},{"$f":"IF('Detaile Mur 1-4'!P49>0,'Detaile Mur 1-4'!P49*0.00328083,'Detaile Mur 1-4'!P48)","v":0},{"$f":"IF('Detaile Mur 5-8'!P11>0,'Detaile Mur 5-8'!P11*0.00328083,'Detaile Mur 5-8'!P10)","v":0},{"$f":"IF('Detaile Mur 5-8'!P24>0,'Detaile Mur 5-8'!P24*0.00328083,'Detaile Mur 5-8'!P23)","v":0},{"$f":"IF('Detaile Mur 5-8'!P36>0,'Detaile Mur 5-8'!P36*0.00328083,'Detaile Mur 5-8'!P35)","v":0},{"$f":"IF('Detaile Mur 5-8'!P49>0,'Detaile Mur 5-8'!P49*0.00328083,'Detaile Mur 5-8'!P48)","v":0},{"$f":"IF('Detaile Mur 9-12'!P11>0,'Detaile Mur 9-12'!P11*0.00328083,'Detaile Mur 9-12'!P10)","v":0},{"$f":"IF('Detaile Mur 9-12'!P24>0,'Detaile Mur 9-12'!P24*0.00328083,'Detaile Mur 9-12'!P23)","v":0},{"$f":"IF('Detaile Mur 9-12'!P36>0,'Detaile Mur 9-12'!P36*0.00328083,'Detaile Mur 9-12'!P35)","v":0},{"$f":"IF('Detaile Mur 9-12'!P49>0,'Detaile Mur 9-12'!P49*0.00328083,'Detaile Mur 9-12'!P48)","v":0},"Panneau d'assise (pi)",{"$f":"SUM(E15+F15+G15+H15+I15+J15+K15+L15+M15+N15+O15+P15)","v":0},{"$f":"(R15*0.33*0.5)/35.3147","v":0},{"$f":"(R15*0.33*0.5)/27","v":0},null,null,8,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G17*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G17*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G17*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G17*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G17*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G17*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G17/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G17/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G17*10.76/4.08*6,0)))","v":0},3]
[null,"Certification","Niveau d'Accréditation","TaperedTop (ft)",{"$f":"IF('Detaile Mur 1-4'!P14>0,'Detaile Mur 1-4'!P14*0.00328083,'Detaile Mur 1-4'!P13)","v":0},{"$f":"IF('Detaile Mur 1-4'!P27>0,'Detaile Mur 1-4'!P27*0.00328083,'Detaile Mur 1-4'!P26)","v":0},{"$f":"IF('Detaile Mur 1-4'!P39>0,'Detaile Mur 1-4'!P39*0.00328083,'Detaile Mur 1-4'!P38)","v":0},{"$f":"IF('Detaile Mur 1-4'!P52>0,'Detaile Mur 1-4'!P52*0.00328083,'Detaile Mur 1-4'!P51)","v":0},{"$f":"IF('Detaile Mur 5-8'!P14>0,'Detaile Mur 5-8'!P14*0.00328083,'Detaile Mur 5-8'!P13)","v":0},{"$f":"IF('Detaile Mur 5-8'!P27>0,'Detaile Mur 5-8'!P27*0.00328083,'Detaile Mur 5-8'!P26)","v":0},{"$f":"IF('Detaile Mur 5-8'!P39>0,'Detaile Mur 5-8'!P39*0.00328083,'Detaile Mur 5-8'!P38)","v":0},{"$f":"IF('Detaile Mur 5-8'!P52>0,'Detaile Mur 5-8'!P52*0.00328083,'Detaile Mur 5-8'!P51)","v":0},{"$f":"IF('Detaile Mur 9-12'!P14>0,'Detaile Mur 9-12'!P14*0.00328083,'Detaile Mur 9-12'!P13)","v":0},{"$f":"IF('Detaile Mur 9-12'!P27>0,'Detaile Mur 9-12'!P27*0.00328083,'Detaile Mur 9-12'!P26)","v":0},{"$f":"IF('Detaile Mur 9-12'!P39>0,'Detaile Mur 9-12'!P39*0.00328083,'Detaile Mur 9-12'!P38)","v":0},{"$f":"IF('Detaile Mur 9-12'!P52>0,'Detaile Mur 9-12'!P52*0.00328083,'Detaile Mur 9-12'!P51)","v":0},"Panneau Biseauté (pi)",{"$f":"SUM(E16+F16+G16+H16+I16+J16+K16+L16+M16+N16+O16+P16)","v":0},null,null,null,null,9,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G18*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G18*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G18*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G18*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G18*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G18*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G18/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G18/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G18*10.76/4.08*6,0)))","v":0},3]
[null,"Niveau d'Accréditation","Niveau A","Vertical Steel",{"$f":"IF(E20=1,\"Yes\",\"No\")","v":"Yes"},{"$f":"IF(F20=1,\"Yes\",\"No\")","v":"Yes"},"Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Pied Linéair",{"$f":"SUM(E3+F3+G3+H3+I3+J3+K3+L3+M3+N3+O3+P3)","v":0},"de Mur",null,null,null,10,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G19*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G19*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G19*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G19*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G19*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G19*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G19/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G19/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G19*10.76/4.08*6,0)))","v":0},3]
[null,null,"Niveau B","#4 / 10mm",{"$f":"IF(E19=1,\"#4/10mm\",IF(E19=2,\"#5/15mm\",IF(E19=3,\"#6/20mm\",IF(E19=4,\"#8/25mm\",\"\"))))","v":"#5/15mm"},{"$f":"IF(F19=1,\"#4/10mm\",IF(F19=2,\"#5/15mm\",IF(F19=3,\"#6/20mm\",IF(F19=4,\"#8/25mm\",\"\"))))","v":"#5/15mm"},{"$f":"IF(G19=1,\"#4/10mm\",IF(G19=2,\"#5/15mm\",IF(G19=3,\"#6/20mm\",IF(G19=4,\"#8/25mm\",\"\"))))","v":"#5/15mm"},"#5/15mm","#5/15mm","#5/15mm","#5/15mm","#5/15mm","#5/15mm","#5/15mm","#5/15mm","#5/15mm","Ajouté (pi)",{"$f":"SUM((E35+F35+G35+H35+I35+J35+K35+L35+M35+N35+O35+P35)*2)","v":0},"Inv. + \"T\"",null,null,null,11,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G23*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G23*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G23*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G23*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G23*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G23*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G23/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G23/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G23*10.76/4.08*6,0)))","v":0},3]
[null,null,"Niveau C","#5 / 15mm",2,2,2,2,2,2,2,2,2,2,2,2,"Grand Totale",{"$f":"SUM(R17:R18)","v":0},"Pied Linéair",null,null,null,12,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G24*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G24*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G24*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G24*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G24*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G24*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G24/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G24/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G24*10.76/4.08*6,0)))","v":0},3]
[null,null,"Niveau D","#6 / 20mm",1,1,1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,13,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G25*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G25*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G25*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G25*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G25*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G25*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G25/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G25/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G25*10.76/4.08*6,0)))","v":0},3]
[null,"Commentaire","","#8 / 25mm",{"$f":"IF(E22=1,\"8\",IF(E22=2,\"12\",IF(E22=3,\"16\",IF(E22=4,\"24\",IF(E22=5,\"32\",IF(E22=6,\"40\",IF(E22=7,\"48\",\"\")))))))","v":"16"},"16","16","16","16","16","16","16","16","16","16","16","Verticale","Sub-Total",null,null,null,null,14,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G26*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G26*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G26*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G26*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G26*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G26*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G26/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G26/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G26*10.76/4.08*6,0)))","v":0},3]
[null,"Tab=Project info.",null,null,3,3,3,3,3,3,3,3,3,3,3,3,"10mm ou # 4",{"$f":"SUMIF(E19:P19,1,E31:P31)","v":0},"Totale 10mm ou # 4",null,null,null,15,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G27*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G27*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G27*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G27*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G27*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G27*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G27/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G27/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G27*10.76/4.08*6,0)))","v":0},3]
[null,"Nom du Projet","","Horizontal Steel",{"$f":"IF(E24=1,\"Yes\",\"No\")","v":"Yes"},"Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","15mm ou # 5",{"$f":"SUMIF(E19:P19,2,E31:P31)","v":0},{"$f":"SUM(R22+R28+S63+S68)","v":0},null,null,null,16,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G28*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G28*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G28*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G28*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G28*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G28*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G28/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G28/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G28*10.76/4.08*6,0)))","v":0},3]
[null,"Type de Projet","Nouveau Résidentiel","8po(203mm)",1,1,1,1,1,1,1,1,1,1,1,1,"20mm ou # 6",{"$f":"SUMIF(E19:P19,3,E31:P31)","v":0},"Totale 15mm ou # 5",null,null,null,17,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G29*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G29*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G29*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G29*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G29*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G29*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G29/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G29/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G29*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"12po(305mm)"]
[null,null,"Addition à un Bâtiment","16po(406mm)",1,1,1,1,1,1,1,1,1,1,1,1,"25mm ou # 8",{"$f":"SUMIF(E19:P19,4,E31:P31)","v":0},{"$f":"SUM(R23+R29+S64+S69)","v":0},null,null,null,18,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G30*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G30*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G30*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G30*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G30*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G30*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G30/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G30/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G30*10.76/4.08*6,0)))","v":0},3]
[null,null,"Commerciale","24po(610mm)",{"$f":"IF(E26=1,\"#4/10mm\",IF(E26=2,\"#5/15mm\",IF(E26=3,\"#6/20mm\",IF(E26=4,\"#8/25mm\",\"\"))))","v":"#4/10mm"},{"$f":"IF(F26=1,\"#4/10mm\",IF(F26=2,\"#5/15mm\",IF(F26=3,\"#6/20mm\",IF(F26=4,\"#8/25mm\",\"\"))))","v":"#4/10mm"},{"$f":"IF(G26=1,\"#4/10mm\",IF(G26=2,\"#5/15mm\",IF(G26=3,\"#6/20mm\",IF(G26=4,\"#8/25mm\",\"\"))))","v":"#4/10mm"},"#4/10mm","#4/10mm","#4/10mm","#4/10mm","#4/10mm","#4/10mm","#4/10mm","#4/10mm","#4/10mm","Horizontale",null,"Totale 20mm ou # 7",null,null,null,19,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G31*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G31*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G31*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G31*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G31*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G31*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G31/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G31/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G31*10.76/4.08*6,0)))","v":0},3]
[null,null,"Institutionnelle","32po(813mm)",4,4,4,4,4,4,4,4,4,4,4,4,"10mm ou # 4",{"$f":"SUMIF(E26:P26,1,E33:P33)","v":0},{"$f":"SUM(R24+R30+S65+S70)","v":0},null,null,null,20,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G32*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G32*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G32*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G32*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G32*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G32*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G32/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G32/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G32*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"40po(1016mm)",{"$f":"IF(E28=1,\"6\",IF(E28=2,\"12\",IF(E28=3,\"18\",IF(E28=4,\"24\",IF(E28=5,\"30\",IF(E28=6,\"36\",\"\"))))))","v":"24"},{"$f":"IF(F28=1,\"6\",IF(F28=2,\"12\",IF(F28=3,\"18\",IF(F28=4,\"24\",IF(F28=5,\"30\",IF(F28=6,\"36\",\"\"))))))","v":"24"},"24","24","24","24","24","24","24","24","24","24","15mm ou # 5",{"$f":"SUMIF(E26:P26,2,E33:P33)","v":0},"Totale 25mm ou # 8",null,null,null,21,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G36*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G36*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G36*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G36*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G36*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G36*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G36/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G36/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G36*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"48po(1219mm)","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","L. Vert.","20mm ou # 6",{"$f":"SUMIF(E26:P26,3,E33:P33)","v":0},{"$f":"SUM(R26+R31+S66+S71)","v":0},null,null,null,22,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G37*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G37*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G37*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G37*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G37*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G37*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G37/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G37/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G37*10.76/4.08*6,0)))","v":0},3]
[null,"Location",null,"6po(152mm)",{"$f":"IF(E20=1,E3/(E21/12)*E4*E37+E39,0)","v":0},{"$f":"IF(F20=1,F3/(F21/12)*F4*F37+F39,0)","v":0},{"$f":"IF(G20=1,G3/(G21/12)*G4*G37+G39,0)","v":0},{"$f":"IF(H20=1,H3/(H21/12)*H4*H37+H39,0)","v":0},{"$f":"IF(I20=1,I3/(I21/12)*I4*I37+I39,0)","v":0},0,0,0,0,0,0,0,"25mm ou # 8",{"$f":"SUMIF(E26:P26,4,E33:P33)","v":0},null,null,null,null,23,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G38*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G38*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G38*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G38*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G38*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G38*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G38/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G38/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G38*10.76/4.08*6,0)))","v":0},3]
[null,"Commentaire",null,"12po(305mm)","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.","L. Hor.",null,null,null,null,null,null,24,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G39*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G39*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G39*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G39*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G39*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G39*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G39/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G39/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G39*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"18po(457mm)",{"$f":"IF(E24=1,E4/(E29/12)*E3*E38,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,25,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G40*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G40*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G40*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G40*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G40*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G40*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G40/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G40/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G40*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"24po(610mm)",{"$f":"E12*E4/(E29/12)","v":0},{"$f":"F12*F4/(F29/12)","v":0},{"$f":"G12*G4/(G29/12)","v":0},0,0,0,0,0,0,0,0,0,"Entretoise 4\"",{"$f":"SUMIF($E$6:$P$6,1,$E$55:$P$55)-AA53+Q64","v":0},"Buck 4\"",{"$f":"IF(AB62=1,Ouvertures!O11,0)+IF(AB63=1,Ouvertures!O24,0)+IF(AB64=1,Ouvertures!O37,0)+IF(AB65=1,Ouvertures!O50,0)","v":0},"SantaFe 4\"",{"$f":"IF(AB62=2,Ouvertures!O11,0)+IF(AB63=2,Ouvertures!O24,0)+IF(AB64=2,Ouvertures!O37,0)+IF(AB65=2,Ouvertures!O50,0)","v":0},26,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G41*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G41*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G41*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G41*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G41*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G41*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G41/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G41/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G41*10.76/4.08*6,0)))","v":0},3]
[null,null,"T-walls","30po(762mm)",{"$f":"'Detaile Mur 1-4'!M13","v":0},{"$f":"'Detaile Mur 1-4'!M26","v":0},{"$f":"'Detaile Mur 1-4'!M38","v":0},{"$f":"'Detaile Mur 1-4'!M51","v":0},{"$f":"'Detaile Mur 5-8'!M13","v":0},{"$f":"'Detaile Mur 5-8'!M26","v":0},{"$f":"'Detaile Mur 5-8'!M38","v":0},{"$f":"'Detaile Mur 5-8'!M51","v":0},{"$f":"'Detaile Mur 9-12'!M13","v":0},{"$f":"'Detaile Mur 9-12'!M26","v":0},{"$f":"'Detaile Mur 9-12'!M38","v":0},{"$f":"'Detaile Mur 9-12'!M51","v":0},"Entretoise 5\"",{"$f":"SUMIF($E$6:$P$6,2,$E$55:$P$55)-AA54","v":0},"Buck 5\"",null,"SantaFe 5\"",null,27,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G42*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G42*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G42*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G42*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G42*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G42*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G42/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G42/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G42*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"36po(914mm)"]
[null,null,"Perte %","Vertical Steel",{"$f":"'Detaile Mur 1-4'!D16/100+1","v":1.03},{"$f":"'Detaile Mur 1-4'!D29/100+1","v":1.03},{"$f":"'Detaile Mur 1-4'!D41/100+1","v":1.03},{"$f":"'Detaile Mur 1-4'!D54/100+1","v":1.03},{"$f":"'Detaile Mur 5-8'!D16/100+1","v":1.03},{"$f":"'Detaile Mur 5-8'!D29/100+1","v":1.03},{"$f":"'Detaile Mur 5-8'!D41/100+1","v":1.03},{"$f":"'Detaile Mur 5-8'!D54/100+1","v":1.03},{"$f":"'Detaile Mur 9-12'!D16/100+1","v":1.03},{"$f":"'Detaile Mur 9-12'!D29/100+1","v":1.03},{"$f":"'Detaile Mur 9-12'!D41/100+1","v":1.03},{"$f":"'Detaile Mur 9-12'!D54/100+1","v":1.03},"Entretoise 6\"",{"$f":"SUMIF(E6:P6,3,E55:P55)-AA55+Q63","v":0},"Buck 6\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O12,0)+IF($AB$63=1,Ouvertures!O25,0)+IF($AB$64=1,Ouvertures!O38,0)+IF($AB$65=1,Ouvertures!O51,0))","v":0},"SantaFe 6\"",{"$f":"SUM(IF($AB$62=2,Ouvertures!O12,0)+IF($AB$63=2,Ouvertures!O25,0)+IF($AB$64=2,Ouvertures!O38,0)+IF($AB$65=2,Ouvertures!O51,0))","v":0},28,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G43*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G43*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G43*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G43*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G43*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G43*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G43/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G43/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G43*10.76/4.08*6,0)))","v":0},3]
[null,null,"Perte %","Horizontal Steel",{"$f":"'Detaile Mur 1-4'!L16/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 1-4'!L29/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 1-4'!L41/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 1-4'!L54/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 5-8'!L16/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 5-8'!L29/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 5-8'!L41/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 5-8'!L54/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 9-12'!L16/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 9-12'!L29/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 9-12'!L41/100+1","v":1.1200000000000001},{"$f":"'Detaile Mur 9-12'!L54/100+1","v":1.1200000000000001},"Entretoise 8\"",{"$f":"SUMIF(E6:P6,4,E55:P55)-AA56","v":0},"Buck 8\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O13,0)+IF($AB$63=1,Ouvertures!O26,0)+IF($AB$64=1,Ouvertures!O39,0)+IF($AB$65=1,Ouvertures!O52,0))","v":0},"SantaFe 8\"",{"$f":"SUM(IF($AB$62=2,Ouvertures!O13,0)+IF($AB$63=2,Ouvertures!O26,0)+IF($AB$64=2,Ouvertures!O39,0)+IF($AB$65=2,Ouvertures!O52,0))","v":0},29,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G44*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G44*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G44*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G44*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G44*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G44*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G44/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G44/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G44*10.76/4.08*6,0)))","v":0},3]
[null,null,"Acier Panneau d'assise + 4' (pour Coin)",null,{"$f":"SUM((E15*4)+((E12*E4/(E29/12)*4)))","v":0},{"$f":"SUM((F15*4)+((F12*F4/(F29/12)*4)))","v":0},0,0,0,0,0,0,0,0,0,0,"Entretoise 10\"",{"$f":"SUMIF(E6:P6,5,E55:P55)-AA57","v":0},"Buck 10\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O14,0)+IF($AB$63=1,Ouvertures!O27,0)+IF($AB$64=1,Ouvertures!O40,0)+IF($AB$65=1,Ouvertures!O53,0))","v":0},"SantaFe 10\"",{"$f":"SUM(IF($AB$62=2,Ouvertures!O14,0)+IF($AB$63=2,Ouvertures!O27,0)+IF($AB$64=2,Ouvertures!O40,0)+IF($AB$65=2,Ouvertures!O53,0))","v":0},30,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G45*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G45*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G45*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G45*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G45*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G45*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G45/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G45/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G45*10.76/4.08*6,0)))","v":0},3]
[null,null,"Panneau Standard",null,{"$f":"ROUNDUP((((((E$3*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084))-(E$45*4.1684)-(E$46*2.2968)-(E$47*4.5089)-(E$48*2.2968)-(E$52*2.6208))/4.08)*2)-(E$41+E$42)),0)","v":0},{"$f":"ROUNDUP((((((F$3*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084))-(F$45*4.1684)-(F$46*2.2968)-(F$47*4.5089)-(F$48*2.2968)-(F$52*2.6208))/4.08)*2)-(F$41+F$42)),0)","v":0},{"$f":"ROUNDUP((((((G$3*(CEILING(ROUND(G$4/1.02084,2),0.5)*1.02084))-(G$45*4.1684)-(G$46*2.2968)-(G$47*4.5089)-(G$48*2.2968)-(G$52*2.6208))/4.08)*2)-(G$41+G$42)),0)","v":0},0,0,0,0,0,0,0,0,0,"Entretoise 12\"",{"$f":"SUMIF(E6:P6,6,E55:P55)-AA58","v":0},"Header 4\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O15,0)+IF($AB$63=1,Ouvertures!O28,0)+IF($AB$64=1,Ouvertures!O41,0)+IF($AB$65=1,Ouvertures!O54,0))","v":0},null,{"$f":"SUM(IF($AB$62=2,Ouvertures!O15,0)+IF($AB$63=2,Ouvertures!O28,0)+IF($AB$64=2,Ouvertures!O41,0)+IF($AB$65=2,Ouvertures!O54,0))","v":0},31,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G49*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G49*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G49*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G49*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G49*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G49*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G49/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G49/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G49*10.76/4.08*6,0)))","v":0},3]
[null,null,"Panneau d'assise brique",null,{"$f":"ROUNDUP(E15/4,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Panneau Std",{"$f":"IF(SUM(E44:P44)<=0,\"0\",SUM(E44:P44))","v":"0"},"Header 6\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O16,0)+IF($AB$63=1,Ouvertures!O29,0)+IF($AB$64=1,Ouvertures!O42,0)+IF($AB$65=1,Ouvertures!O55,0))","v":0},"SantaFe 6\"",{"$f":"SUM(IF($AB$62=2,Ouvertures!O16,0)+IF($AB$63=2,Ouvertures!O29,0)+IF($AB$64=2,Ouvertures!O42,0)+IF($AB$65=2,Ouvertures!O55,0))","v":0},32,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G50*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G50*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G50*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G50*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G50*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G50*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G50/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G50/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G50*10.76/4.08*6,0)))","v":0},3]
[null,null,"Panneau Biseauté",null,{"$f":"ROUNDUP(E16/4,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Panneau d'assise",{"$f":"SUM(E41:P41)","v":0},"Header 8\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O17,0)+IF($AB$63=1,Ouvertures!O30,0)+IF($AB$64=1,Ouvertures!O43,0)+IF($AB$65=1,Ouvertures!O56,0))","v":0},"SantaFe 8\"",{"$f":"SUM(IF($AB$62=2,Ouvertures!O17,0)+IF($AB$63=2,Ouvertures!O30,0)+IF($AB$64=2,Ouvertures!O43,0)+IF($AB$65=2,Ouvertures!O56,0))","v":0},33,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G51*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G51*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G51*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G51*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G51*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G51*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G51/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G51/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G51*10.76/4.08*6,0)))","v":0},3]
[null,null,"Facteur de Perte",null,{"$f":"E40*'Liste de Prix'!L4","v":0},{"$f":"F40*'Liste de Prix'!L4","v":0},{"$f":"G40*'Liste de Prix'!L4","v":0},{"$f":"H40*'Liste de Prix'!L4","v":0},{"$f":"I40*'Liste de Prix'!L4","v":0},{"$f":"J40*'Liste de Prix'!L4","v":0},{"$f":"K40*'Liste de Prix'!L4","v":0},{"$f":"L40*'Liste de Prix'!L4","v":0},{"$f":"M40*'Liste de Prix'!L4","v":0},{"$f":"N40*'Liste de Prix'!L4","v":0},{"$f":"O40*'Liste de Prix'!L4","v":0},{"$f":"P40*'Liste de Prix'!L4","v":0},"Panneau Biseauté",{"$f":"SUM(E42:P42)","v":0},"Header 10\"",{"$f":"SUM(IF($AB$62=1,Ouvertures!O18,0)+IF($AB$63=1,Ouvertures!O31,0)+IF($AB$64=1,Ouvertures!O44,0)+IF($AB$65=1,Ouvertures!O57,0))","v":0},null,{"$f":"SUM(IF($AB$62=2,Ouvertures!O18,0)+IF($AB$63=2,Ouvertures!O31,0)+IF($AB$64=2,Ouvertures!O44,0)+IF($AB$65=2,Ouvertures!O57,0))","v":0},34,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G52*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G52*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G52*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G52*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G52*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G52*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G52/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G52/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G52*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"Panneau Totale",{"$f":"ROUNDUP(E40+E43+E72,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,"Panneau-ouverture",{"$f":"ROUNDUP(R41-S10-Q62,0)","v":0},null,null,null,null,35,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G53*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G53*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G53*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G53*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G53*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G53*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G53/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G53/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G53*10.76/4.08*6,0)))","v":0},3]
[null,null,0,"Coin 90 Deg. ( 6\") Ext.",{"$f":"IF(E$6=1,ROUNDDOWN(E12*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),IF(E$6=2,ROUNDDOWN(E12*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),IF(E$6=3,ROUNDDOWN(E12*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),0)))","v":0},{"$f":"IF(F$6=1,ROUNDDOWN(F12*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),IF(F$6=2,ROUNDDOWN(F12*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),IF(F$6=3,ROUNDDOWN(F12*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),0)))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,36,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G54*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G54*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G54*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G54*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G54*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G54*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G54/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G54/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G54*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"Coin 90 Deg. ( 6\") Int.",{"$f":"IF(E$6=1,ROUNDDOWN(E13*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),IF(E$6=2,ROUNDDOWN(E13*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),IF(E$6=3,ROUNDDOWN(E13*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),0)))","v":0},{"$f":"IF(F$6=1,ROUNDDOWN(F13*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),IF(F$6=2,ROUNDDOWN(F13*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),IF(F$6=3,ROUNDDOWN(F13*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),0)))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Coin 90 Deg. ( 8\") Ext.",{"$f":"IF(E$6=4,ROUNDDOWN(E12*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),IF(E$6=5,ROUNDDOWN(E12*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),0))","v":0},{"$f":"IF(F$6=4,ROUNDDOWN(F12*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),IF(F$6=5,ROUNDDOWN(F12*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),0))","v":0},0,0,0,0,0,0,0,0,0,0,"90 deg.-6\"",{"$f":"SUM(E45:P46)","v":0},null,null,null,null,37,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G55*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G55*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G55*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G55*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G55*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G55*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G55/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G55/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G55*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"Coin 90 Deg. ( 8\") Int.",{"$f":"IF(E$6=4,ROUNDDOWN(E13*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),IF(E$6=5,ROUNDDOWN(E13*(CEILING(ROUND(E$4/1.02084,2),0.5)*1.02084),0),0))","v":0},{"$f":"IF(F$6=4,ROUNDDOWN(F13*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),IF(F$6=5,ROUNDDOWN(F13*(CEILING(ROUND(F$4/1.02084,2),0.5)*1.02084),0),0))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"CONCATENATE(\"test\",  \" test1\")","v":"test test1"},null,"Coin 90 Deg. ( 10\")",null,null,null,null,null,null,null,null,null,null,null,null,"90 deg.-8\"",{"$f":"SUM(E47:P48)","v":0},null,null,null,null,38,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G56*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G56*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G56*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G56*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G56*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G56*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G56/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G56/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G56*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"Coin 90 Deg. (12\")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G57*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G57*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G57*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G57*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G57*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G57*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G57/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G57/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G57*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"Panneau (Mur en T)  Coin 90 Deg. Int.",{"$f":"ROUNDDOWN(E35*E4*2,0)","v":0},{"$f":"ROUNDDOWN(F35*F4*2,0)","v":0},0,0,0,0,0,0,0,0,0,0,"90 (Mur en T)",{"$f":"IF('Liste de Prix'!A8=TRUE,SUM(E51:P51),0)","v":0},null,null,null,null,40,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G58*(Z7/12)/35.3147,IF(Ouvertures!A2=TRUE,Ouvertures!G58*(Z7/12)/35.3147,IF(Ouvertures!A3=TRUE,Ouvertures!G58*(Z7*0.0254),0)))","v":0},{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G58*(Z7/12)/27,IF(Ouvertures!A2=TRUE,Ouvertures!G58*(Z7/12)/27,IF(Ouvertures!A3=TRUE,Ouvertures!G58*(Z7*0.0254)*1.308,0)))","v":0},6,{"$f":"IF(Ouvertures!A1=TRUE,Ouvertures!G58/4.08*6,IF(Ouvertures!A2=TRUE,Ouvertures!G58/4.08*6,IF(Ouvertures!A3=TRUE,Ouvertures!G58*10.76/4.08*6,0)))","v":0},3]
[null,null,null,"Coin 45 Deg.",{"$f":"ROUNDDOWN(E14*E4,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,"45 deg.",{"$f":"SUM(E52:P52)","v":0},{"$f":"R52","v":0},null,null,null,"Totale",{"$f":"SUM(X7:X51)","v":0},{"$f":"SUM(Y7:Y51)","v":0}]
[null,null,null,"furure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4\"",{"$f":"SUMIF($Z$7:$Z$51,4,$AA$7:$AA$51)","v":0}]
[null,null,null,"furure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5\"",{"$f":"SUMIF($Z$7:$Z$51,5,$AA$7:$AA$51)","v":0}]
[null,null,null,"Entretoise",{"$f":"ROUNDUP((E44*3)+(E45*4)+(E46*4)+(E47*4)+(E48*4)+(E51*2)+(E52*4)+(E42*3)+(E41*3),0)","v":0},{"$f":"ROUNDUP((F44*3)+(F45*4)+(F46*4)+(F47*4)+(F48*4)+(F51*2)+(F52*4)+(F42*3)+(F41*3),0)","v":0},0,0,0,0,0,0,0,0,{"$f":"ROUNDUP((O44*3)+(O45*4)+(O47*4)+(O51*2)+(O52*4)+(O42*3),0)","v":0},{"$f":"ROUNDUP((P44*3)+(P45*4)+(P46*4)+(P47*4)+(P48*4)+(P51*2)+(P52*4)+(P42*3)+(P41*3),0)","v":0},null,null,null,null,null,null,null,null,null,"6\"",{"$f":"SUMIF(Z7:Z51,6,AA7:AA51)","v":0}]
[null,null,null,"Vert . O?N?",{"$f":"IF(Sommaire!H18=\" \",\" \",IF('Detaile Mur 1-4'!I19=TRUE,CONCATENATE(E69,\" (2X)\",\" \"),IF(E20=1,E69,IF(E20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H19=\" \",\" \",IF('Detaile Mur 1-4'!I32=TRUE,CONCATENATE(F69,\" (2X)\",\" \"),IF(F20=1,F69,IF(F20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H20=\" \",\" \",IF('Detaile Mur 1-4'!I44=TRUE,CONCATENATE(G69,\" (2X)\",\" \"),IF(G20=1,G69,IF(G20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H21=\" \",\" \",IF('Detaile Mur 1-4'!I57=TRUE,CONCATENATE(H69,\" (2X)\",\" \"),IF(H20=1,H69,IF(H20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H22=\" \",\" \",IF('Detaile Mur 5-8'!I19=TRUE,CONCATENATE(I69,\" (2X)\",\" \"),IF(I20=1,I69,IF(I20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H23=\" \",\" \",IF('Detaile Mur 5-8'!I32=TRUE,CONCATENATE(J69,\" (2X)\",\" \"),IF(J20=1,J69,IF(J20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H24=\" \",\" \",IF('Detaile Mur 5-8'!I44=TRUE,CONCATENATE(K69,\" (2X)\",\" \"),IF(K20=1,K69,IF(K20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H25=\" \",\" \",IF('Detaile Mur 5-8'!I57=TRUE,CONCATENATE(L69,\" (2X)\",\" \"),IF(L20=1,L69,IF(L20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H26=\" \",\" \",IF('Detaile Mur 9-12'!I19=TRUE,CONCATENATE(M69,\" (2X)\",\" \"),IF(M20=1,M69,IF(M20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H27=\" \",\" \",IF('Detaile Mur 9-12'!I32=TRUE,CONCATENATE(N69,\" (2X)\",\" \"),IF(N20=1,N69,IF(N20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H28=\" \",\" \",IF('Detaile Mur 9-12'!I44=TRUE,CONCATENATE(O69,\" (2X)\",\" \"),IF(O20=1,O69,IF(O20=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H29=\" \",\" \",IF('Detaile Mur 9-12'!I57=TRUE,CONCATENATE(P69,\" (2X)\",\" \"),IF(P20=1,P69,IF(P20=2,\"Not Included\",))))","v":" "},null,null,null,{"$f":"ROUNDUP((((((F3*(CEILING(ROUND(F4/1.02084,2),0.5)*1.02084))-(F45*3.2324)-(F47*3.4025)-(F52*2.6208))/4.08)*2)-(F41+F42)),0)","v":0},null,null,null,null,null,"8\"",{"$f":"SUMIF(Z7:Z51,8,AA7:AA51)","v":0}]
[null,null,null,"Horiz.O?N?",{"$f":"IF(Sommaire!H18=\" \",\" \",IF('Detaile Mur 1-4'!P19=TRUE,CONCATENATE(E70,\" (2X)\",\" \"),IF(E24=1,E70,IF(E24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H19=\" \",\" \",IF('Detaile Mur 1-4'!P32=TRUE,CONCATENATE(F70,\" (2X)\",\" \"),IF(F24=1,F70,IF(F24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H20=\" \",\" \",IF('Detaile Mur 1-4'!P44=TRUE,CONCATENATE(G70,\" (2X)\",\" \"),IF(G24=1,G70,IF(G24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H21=\" \",\" \",IF('Detaile Mur 1-4'!P57=TRUE,CONCATENATE(H70,\" (2X)\",\" \"),IF(H24=1,H70,IF(H24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H22=\" \",\" \",IF('Detaile Mur 5-8'!P19=TRUE,CONCATENATE(I70,\" (2X)\",\" \"),IF(I24=1,I70,IF(I24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H23=\" \",\" \",IF('Detaile Mur 5-8'!P32=TRUE,CONCATENATE(J70,\" (2X)\",\" \"),IF(J24=1,J70,IF(J24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H24=\" \",\" \",IF('Detaile Mur 5-8'!P44=TRUE,CONCATENATE(K70,\" (2X)\",\" \"),IF(K24=1,K70,IF(K24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H25=\" \",\" \",IF('Detaile Mur 5-8'!P57=TRUE,CONCATENATE(L70,\" (2X)\",\" \"),IF(L24=1,L70,IF(L24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H26=\" \",\" \",IF('Detaile Mur 9-12'!P19=TRUE,CONCATENATE(M70,\" (2X)\",\" \"),IF(M24=1,M70,IF(M24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H27=\" \",\" \",IF('Detaile Mur 9-12'!P32=TRUE,CONCATENATE(N70,\" (2X)\",\" \"),IF(N24=1,N70,IF(N24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H28=\" \",\" \",IF('Detaile Mur 9-12'!P44=TRUE,CONCATENATE(O70,\" (2X)\",\" \"),IF(O24=1,O70,IF(O24=2,\"Not Included\",))))","v":" "},{"$f":"IF(Sommaire!H29=\" \",\" \",IF('Detaile Mur 9-12'!P57=TRUE,CONCATENATE(P70,\" (2X)\",\" \"),IF(P24=1,P70,IF(P24=2,\"Not Included\",))))","v":" "},null,null,null,null,null,null,null,null,null,"10\"",{"$f":"SUMIF(Z7:Z51,10,AA7:AA51)","v":0}]
[null,null,null,"Coin Int. 90 deg.",{"$f":"'Detaile Mur 1-4'!K12","v":0},{"$f":"'Detaile Mur 1-4'!K25","v":0},{"$f":"'Detaile Mur 1-4'!K37","v":0},{"$f":"'Detaile Mur 1-4'!K50","v":0},{"$f":"'Detaile Mur 5-8'!K12","v":0},{"$f":"'Detaile Mur 5-8'!K25","v":0},{"$f":"'Detaile Mur 5-8'!K37","v":0},{"$f":"'Detaile Mur 5-8'!K50","v":0},{"$f":"'Detaile Mur 9-12'!K12","v":0},{"$f":"'Detaile Mur 9-12'!K25","v":0},{"$f":"'Detaile Mur 9-12'!K37","v":0},{"$f":"'Detaile Mur 9-12'!K50","v":0},null,null,null,null,null,null,null,null,null,"12\"",{"$f":"SUMIF(Z7:Z51,12,AA7:AA51)","v":0}]
[null,null,null,"Ajouté Panneau",{"$f":"(((E8+5)/12)*2)*E58*E4/4.08","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E59:P59)","v":0},"Adding Panels"]
[null,null,null,"Ajouté Pi. Lin. 1",{"$f":"(((E8+5)/12)*2)*E58","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Ajouté Pi. Lin. 2",{"$f":"(((E8+5)/12)*2)*E35/2","v":0},{"$f":"(((F8+5)/12)*2)*F35/2","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"Buck & Headers Selection",null,null,"Section Ouverture"]
[null,null,null,"Moin Pan. Pour Mur en T avec Coin Int. 90deg",{"$f":"ROUNDDOWN(E51*2.2966/4.08,0)","v":0},{"$f":"ROUNDDOWN(F51*2.2966/4.08,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF('Liste de Prix'!A8=TRUE,SUM(E62:P62),0)","v":0},"Verticale","2ieme Côté",null,null,null,"Closoir & Entête",null,null,null,"Ouverture: Section 1 ",1]
[null,null,null,"6\"",{"$f":"IF(E6=5,(E47),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E63:P63)","v":0},"10mm ou # 4",{"$f":"SUMIF(E19:P19,1,E66:P66)","v":0},null,null,null,"Closoir SantaFe & Entête",null,null,null,"Ouverture: Section 2",1]
[null,null,"Coin 10\" utilisant :","4\"",{"$f":"IF(E6=5,(E47),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E64:P64)","v":0},"15mm ou # 5",{"$f":"SUMIF(E19:P19,2,E66:P66)","v":0},null,null,null,null,null,null,null,"Ouverture: Section 3",1]
[null,null,null,"Agraffen en H",{"$f":"IF(E6=5,E12*E4,0)","v":0},{"$f":"IF(F6=5,F12*F4,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"CEILING(SUM(E65:P65),4)/4","v":0},"20mm ou # 7",{"$f":"SUMIF(E19:P19,3,E66:P66)","v":0},null,null,null,null,null,null,null,"Ouverture: Section 4",1]
[null,null,"Acier / 2 Côtés","Verticale",{"$f":"IF('Detaile Mur 1-4'!I19,E31,\"\")","v":""},{"$f":"IF('Detaile Mur 1-4'!I32,F31,\"\")","v":""},{"$f":"IF('Detaile Mur 1-4'!I44,G31,\"\")","v":""},{"$f":"IF('Detaile Mur 1-4'!I57,H31,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!I19,I31,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!I32,J31,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!I44,K31,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!I57,L31,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!I19,M31,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!I32,N31,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!I44,O31,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!I57,P31,\"\")","v":""},null,"25mm ou # 8",{"$f":"SUMIF(E19:P19,4,E66:P66)","v":0}]
[null,null,null,"Horizontale",{"$f":"IF('Detaile Mur 1-4'!P19,E33,\"\")","v":""},{"$f":"IF('Detaile Mur 1-4'!P32,F33,\"\")","v":""},{"$f":"IF('Detaile Mur 1-4'!P44,G33,\"\")","v":""},{"$f":"IF('Detaile Mur 1-4'!P57,H33,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!P19,I33,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!P32,J33,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!P44,K33,\"\")","v":""},{"$f":"IF('Detaile Mur 5-8'!P57,L33,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!P19,M33,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!P32,N33,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!P44,O33,\"\")","v":""},{"$f":"IF('Detaile Mur 9-12'!P57,P33,\"\")","v":""},null,"Horizontale","2ieme Côté"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10mm ou # 4",{"$f":"SUMIF(E26:P26,1,E67:P67)","v":0}]
[null,null,null,"Nouv. Vert.",{"$f":"IF(E22=1,\"8po/203mm\",IF(E22=2,\"12po/305mm\",IF(E22=3,\"16po/406mm\",IF(E22=4,\"24po/610mm\",IF(E22=5,\"32po/813mm\",IF(E22=6,\"40po/ 016mm\",IF(E22=7,\"48po/219mm\",\" \")))))))","v":"16po/406mm"},"16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm","16po/406mm",null,"15mm ou # 5",{"$f":"SUMIF(E26:P26,2,E67:P67)","v":0},null,null,null,"Selection Prix:",null,"Prix 1",true]
[null,null,null,"Nouv. Horiz.",{"$f":"IF(E28=1,\"6po/152mm \",IF(E28=2,\"12po/305mm\",IF(E28=3,\"18po/457\",IF(E28=4,\"24po/610mm\",IF(E28=5,\"30po/762mm\",IF(E28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(F28=1,\"6po/152mm \",IF(F28=2,\"12po/305mm\",IF(F28=3,\"18po/457\",IF(F28=4,\"24po/610mm\",IF(F28=5,\"30po/762mm\",IF(F28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(G28=1,\"6po/152mm \",IF(G28=2,\"12po/305mm\",IF(G28=3,\"18po/457mm\",IF(G28=4,\"24po/610mm\",IF(G28=5,\"30po/762mm\",IF(G28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(H28=1,\"6po/152mm \",IF(H28=2,\"12po/305mm\",IF(H28=3,\"18po/457\",IF(H28=4,\"24po/610mm\",IF(H28=5,\"30po/762mm\",IF(H28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(I28=1,\"6po/152mm \",IF(I28=2,\"12po/305mm\",IF(I28=3,\"18po/457mm\",IF(I28=4,\"24po/610mm\",IF(I28=5,\"30po/762mm\",IF(I28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(J28=1,\"6po/152mm \",IF(J28=2,\"12po/305mm\",IF(J28=3,\"18po/457\",IF(J28=4,\"24po/610mm\",IF(J28=5,\"30po/762mm\",IF(J28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(K28=1,\"6po/152mm \",IF(K28=2,\"12po/305mm\",IF(K28=3,\"18po/457mm\",IF(K28=4,\"24po/610mm\",IF(K28=5,\"30po/762mm\",IF(K28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(L28=1,\"6po/152mm \",IF(L28=2,\"12po/305mm\",IF(L28=3,\"18po/457\",IF(L28=4,\"24po/610mm\",IF(L28=5,\"30po/762mm\",IF(L28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(M28=1,\"6po/152mm \",IF(M28=2,\"12po/305mm\",IF(M28=3,\"18po/457\",IF(M28=4,\"24po/610mm\",IF(M28=5,\"30po/762mm\",IF(M28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(N28=1,\"6po/152mm \",IF(N28=2,\"12po/305mm\",IF(N28=3,\"18po/457\",IF(N28=4,\"24po/610mm\",IF(N28=5,\"30po/762mm\",IF(N28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(O28=1,\"6po/152mm \",IF(O28=2,\"12po/305mm\",IF(O28=3,\"18po/457mm\",IF(O28=4,\"24po/610mm\",IF(O28=5,\"30po/762mm\",IF(O28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},{"$f":"IF(P28=1,\"6po/152mm \",IF(P28=2,\"12po/305mm\",IF(P28=3,\"18po/457mm\",IF(P28=4,\"24po/610mm\",IF(P28=5,\"30po/762mm\",IF(P28=6,\"36po/914mm\",\"\"))))))","v":"24po/610mm"},null,"20mm ou # 7",{"$f":"SUMIF(E26:P26,3,E67:P67)","v":0},null,null,null,null,null,"Prix 2",false]
[null,null,null,"Larg. Béton",{"$f":"IF(E6=1,\"4po / 102mm\",IF(E6=3,\"6po / 152mm\",IF(E6=4,\"8po / 203mm\",IF(E6=5,\"10po / 254mm\",IF(E6=6,\"12po / 305mm\",IF(E6=2,\"5po / 127mm\",\"\"))))))","v":"6po / 152mm"},"6po / 152mm","6po / 152mm","6po / 152mm","6po / 152mm","6po / 152mm",{"$f":"IF(K6=1,\"4po / 102mm\",IF(K6=3,\"6po / 152mm\",IF(K6=4,\"8po / 203mm\",IF(K6=5,\"10po / 254mm\",IF(K6=6,\"12po / 305mm\",IF(K6=2,\"5po / 127mm\",\"\"))))))","v":"6po / 152mm"},"6po / 152mm","6po / 152mm","6po / 152mm","6po / 152mm","6po / 152mm",null,"25mm ou # 8",{"$f":"SUMIF(E26:P26,4,E67:P67)","v":0},null,null,null,null,null,"Prix 3",false]
[null,null,null,"Plus Pan. pour Mur en T n'utilisant pas de 90deg",{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,E51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,F51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,G51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,H51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,I51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,J51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,K51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,L51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,M51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,N51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,O51*0.25)","v":0},{"$f":"IF('Liste de Prix'!$A$8=TRUE,0,P51*0.25)","v":0}]