{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Confort","Tableaux Menuiseries, VR, BSO","Tarifs","FEUILLE DE PRIX VERANDA"],"not_rendered":{"charts":0,"images":11,"macros":0,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Confort","index":0,"n_rows":174,"n_cols":50,"rows_kept":174,"cut":false,"hidden":false,"merged":[[0,7,0,18],[22,3,24,20],[95,23,95,24],[94,23,94,24],[71,16,72,20],[98,2,98,12],[97,2,97,12],[70,3,70,4],[69,3,69,4],[67,2,68,2],[126,2,126,12],[119,1,119,12],[109,10,109,12],[110,10,110,12],[111,10,111,12],[105,2,105,12],[118,16,118,20],[126,16,126,20],[99,16,99,20],[106,16,106,20],[107,16,107,20],[109,16,109,18],[111,19,111,20],[76,16,76,20],[75,2,75,12],[99,2,99,12],[95,16,95,20],[97,16,97,20],[105,16,105,20],[110,16,110,18],[108,16,108,18],[108,19,108,20],[98,16,98,20],[130,16,130,20],[148,16,148,20],[123,16,123,20],[127,16,127,20],[134,16,134,20],[135,16,135,20],[117,16,117,20],[125,16,125,20],[122,16,122,20],[121,16,121,20],[75,16,75,20],[97,1,104,1],[110,1,115,1],[114,10,114,12],[127,1,127,2],[127,3,127,4],[101,7,102,12],[107,2,107,12],[106,2,106,12],[112,16,112,18],[115,16,115,18],[119,16,119,20],[124,16,124,20],[94,16,94,20],[109,19,109,20],[110,19,110,20],[108,13,108,15],[111,16,111,18],[101,16,101,20],[80,16,80,20],[81,16,81,20],[77,16,77,20],[78,16,78,20],[79,16,79,20],[104,2,104,12],[103,2,103,12],[100,2,100,12],[94,2,94,12],[96,2,96,12],[95,2,95,12],[108,10,108,12],[108,1,108,8],[91,1,94,1],[95,1,96,1],[160,24,160,25],[157,24,157,25],[156,24,156,25],[160,22,160,23],[147,16,147,20],[157,16,157,20],[140,16,140,20],[141,16,141,20],[143,16,143,20],[144,16,144,20],[145,16,145,20],[156,16,156,20],[154,16,155,20],[152,16,152,20],[142,16,142,20],[160,16,160,20],[150,16,150,20],[151,16,151,20],[146,16,146,20],[154,0,155,0],[96,16,96,20],[81,2,81,13],[127,5,127,6],[127,9,127,10],[87,16,87,20],[88,16,88,20],[102,16,102,20],[87,2,87,12],[103,16,103,20],[104,16,104,20],[91,2,91,12],[91,16,91,20],[92,16,92,20],[121,1,126,1],[100,16,100,20],[153,16,153,20],[128,1,130,1],[117,1,118,1],[138,16,138,20],[118,2,118,12],[117,2,117,12],[136,16,136,20],[120,16,120,20],[124,2,124,12],[125,2,125,12],[116,2,116,12],[115,10,115,12],[112,10,112,12],[113,10,113,12],[71,0,72,0],[74,16,74,20],[112,19,112,20],[113,16,113,18],[114,16,114,18],[116,16,116,20],[115,2,115,9],[114,2,114,9],[113,19,113,20],[114,19,114,20],[115,19,115,20],[112,2,112,9],[120,2,120,11],[121,2,121,12],[122,2,122,12],[123,2,123,12],[110,2,110,9],[109,2,109,9],[111,2,111,9],[25,2,26,2],[25,3,26,3],[25,4,26,4],[48,2,48,3],[25,11,26,11],[25,12,26,12],[77,2,77,12],[71,1,72,12],[69,7,70,9],[73,2,73,12],[76,2,76,12],[74,2,74,12],[57,1,70,1],[57,2,57,12],[68,5,68,12],[65,5,65,11],[65,3,65,4],[58,2,58,12],[59,2,59,12],[60,2,60,10],[73,1,80,1],[52,1,53,12],[25,6,26,6],[25,7,26,7],[25,5,26,5],[25,16,26,16],[25,17,26,17],[25,10,26,10],[132,2,132,7],[137,16,137,20],[135,2,135,12],[130,2,130,12],[129,2,129,12],[128,2,128,12],[131,16,131,20],[132,16,132,20],[149,16,149,20],[139,16,139,20],[133,16,133,20],[131,2,131,12],[173,1,173,15],[173,16,173,20],[172,4,172,15],[171,4,171,15],[163,16,163,20],[164,16,164,20],[170,16,170,20],[162,1,162,15],[161,16,161,20],[168,4,168,15],[167,4,167,15],[166,4,166,15],[170,4,170,15],[169,4,169,15],[167,2,167,3],[166,2,166,3],[165,2,165,3],[164,2,164,3],[163,2,163,3],[165,4,165,15],[161,1,161,14],[162,16,162,20],[167,16,167,20],[168,16,168,20],[172,16,172,20],[171,16,171,20],[163,1,172,1],[172,2,172,3],[171,2,171,3],[170,2,170,3],[169,16,169,20],[169,2,169,3],[163,4,163,15],[164,4,164,15],[168,2,168,3],[165,16,165,20],[166,16,166,20],[160,14,160,15],[140,1,149,1],[154,15,155,15],[156,4,156,5],[156,6,156,7],[142,2,142,12],[145,2,145,12],[144,2,144,12],[143,2,143,12],[141,2,141,12],[140,2,140,12],[151,2,151,5],[151,6,151,12],[150,6,150,12],[150,2,150,5],[150,1,151,1],[157,1,157,15],[156,2,156,3],[154,1,155,1],[154,14,155,14],[152,2,152,12],[153,1,153,12],[156,8,156,9],[156,10,156,12],[82,2,82,12],[89,16,89,20],[159,14,159,15],[159,16,159,20],[159,2,159,6],[158,13,158,15],[158,16,158,20],[131,1,135,1],[132,8,133,12],[136,1,139,1],[156,13,156,15],[154,13,155,13],[149,2,149,12],[148,2,148,12],[147,2,147,12],[146,2,146,12],[128,16,128,20],[129,16,129,20],[139,2,139,12],[138,2,138,12],[137,2,137,12],[136,2,136,12],[134,2,134,12],[133,2,133,7],[71,14,72,14],[71,15,72,15],[82,1,84,1],[93,23,93,24],[92,23,92,24],[82,13,82,15],[93,2,93,12],[92,2,92,12],[85,2,85,12],[86,16,86,20],[86,2,86,12],[85,16,85,20],[88,2,88,12],[82,16,82,20],[83,16,83,20],[83,2,83,12],[91,23,91,24],[90,23,90,24],[84,2,84,12],[84,16,84,20],[90,16,90,20],[93,16,93,20],[87,1,88,1],[85,1,86,1],[68,16,68,20],[69,16,69,20],[70,16,70,20],[56,16,56,20],[57,16,57,20],[58,13,59,13],[69,10,70,12],[80,2,80,12],[78,2,78,12],[79,2,79,12],[67,16,67,20],[67,3,68,4],[64,5,64,11],[64,3,64,4],[63,5,63,11],[63,3,63,4],[73,16,73,20],[62,16,62,18],[64,19,64,20],[65,19,65,20],[66,19,66,20],[63,16,63,18],[65,16,65,18],[71,13,72,13],[56,1,56,12],[54,3,54,4],[67,5,67,12],[60,16,60,18],[60,19,60,20],[54,5,54,7],[55,16,55,20],[54,1,54,2],[61,3,61,11],[61,19,61,20],[61,16,61,18],[62,3,62,11],[64,16,64,18],[66,5,66,11],[66,3,66,4],[1,32,2,32],[1,33,2,33],[2,14,3,16],[3,22,4,24],[3,25,4,25],[3,28,4,33],[4,14,4,16],[21,2,21,20],[66,16,66,18],[62,19,62,20],[63,19,63,20],[30,26,31,26],[30,27,31,27],[52,15,53,15],[48,12,48,13],[23,23,23,25],[30,23,30,24],[22,1,24,2],[25,18,26,18],[14,27,14,29],[15,19,15,22],[15,27,15,29],[58,21,59,21],[15,11,15,14],[54,16,54,20],[52,21,53,21],[58,14,59,14],[46,17,46,20],[50,17,50,19],[49,17,49,19],[48,17,48,19],[47,17,47,19],[25,8,26,8],[25,9,26,9],[48,7,48,8],[25,15,26,15],[25,13,26,13],[25,14,26,14],[52,16,53,20],[55,1,55,12],[52,13,53,14],[54,8,54,10],[54,11,54,12],[58,15,59,15],[58,16,59,20],[1,27,4,27],[1,28,2,31],[4,7,4,11],[3,7,3,11],[9,11,9,14],[9,19,9,22],[9,27,9,29],[10,11,10,14],[10,19,10,22],[10,27,10,29],[2,7,2,11],[1,7,1,11],[4,12,4,13],[3,12,3,13],[2,12,2,13],[1,12,1,13],[4,17,4,18],[3,17,3,18],[2,17,2,18],[1,17,1,18],[1,14,1,16],[14,11,14,14],[14,16,14,17],[14,19,14,22],[12,19,12,22],[12,27,12,29],[13,11,13,14],[13,19,13,22],[13,27,13,30],[6,11,6,17],[6,19,6,25],[6,27,6,33],[7,11,7,14],[7,19,7,22],[7,27,7,30],[8,11,8,14],[8,19,8,22],[8,27,8,29],[11,11,11,14],[11,19,11,22],[11,27,11,29],[12,11,12,14],[13,31,13,33]]}
[null,null,null,null,null,null,null,"dimensions à remplir pour base du calcul"]
[null,null,null,null,null,null,null," LONGUEUR EN MM",null,null,null,null,null,null,"SURFACE  M²",null,null,{"$f":"SUM(N2)*M3/1000000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null,"LARGEUR EN MM",null,null,null,null,null,null,"CHENEAU CLASSIC 130                                                                        CHENEAU VRI 145",null,null,"CHOIX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145]
[null,null,null,null,null,null,null,"HAUTEUR MAXI EN MM",null,null,null,null,null,null,null,null,null,130]
[null,null,null,null,null,null,null," SOUS CHENEAU EN MM",null,null,null,null,null,null,"PENTE EN %",null,null,{"$f":"IF(M4=0,\"\",AX10)","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOUS CHENEAU",{"$f":"M5","v":0},null,{"$f":"SUM(AR8-(AR7+BA19-20))","v":-130}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EXTERIEURE CADRE",{"$f":"M3","v":0},null,null,null,null,"SOUS SOLIN",{"$f":"M4-(150)","v":-150},null,{"$f":"(AT7)/(AL8-78)","v":1.6666666666666667},"%",null,null,{"$f":"AL9-(AL10+R4)","v":-171.66666666666666}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAUTEUR PROJETE AU MUR",{"$f":"SUM(AR8)+AT9","v":-41.666666666666657},null,null,null,null,null,null,null,{"$f":"SUM(AT8)*53+20","v":108.33333333333334},"mm",null,null,{"$f":"SUM(AL8)-(AL11-AL12)-40","v":-40}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HAUTEUR SOUS CHENEAU",{"$f":"SUM(AR7)","v":0},null,null,null,null,null,null,null,null,null,null,"PENTE%",{"$f":"SUM((AX8)/AX9)*100","v":429.16666666666663}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAB",0,null,null,null,null,null,null,null,null,null,null,"PENTE°",{"$f":"ATAN(AX10/100)*180/3.14159265","v":76.883563962460798}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FAH",0,null,null,null,null,null,null,null,"Z"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TYPE POTEAU CONTRE MUR",50,{"$f":"IF(AL13=0,\"\",SUM(AL9)-((AL15-AL11)*AX10/100+AL16*AX10/100)-AO40-22)","v":-63.666666666666657}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POTEAU D'ANGLE",55]
[null,null,null,null,null,null,null,"TVA",{"$f":"IF(C15=\"\",IF(Z92>9,\"20\",\"10\"),\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOURRURE FAB DE 8 A",{"$f":"IF(AL11<8,AL11,AL11+8)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOURRURE FAH DE 8 A",{"$f":"IF(AL12<9,AL12,AL12+8)","v":0},null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,null,"CHIFFRAGE CONFORT ALU "]
[null,"BASE",null,"le reste du tableau se rempli manuellement"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VALEUR BASE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y25:AO25)","v":0},{"$f":"IF(Y26=\"\",\"\",1)","v":""},{"$f":"IF(Z26=\"\",\"\",2)","v":""},{"$f":"IF(AA26=\"\",\"\",3)","v":""},{"$f":"IF(AB26=\"\",\"\",4)","v":""},{"$f":"IF(AC26=\"\",\"\",5)","v":""},{"$f":"IF(AD26=\"\",\"\",6)","v":""},{"$f":"IF(AE26=\"\",\"\",7)","v":""},{"$f":"IF(AF26=\"\",\"\",8)","v":""},{"$f":"IF(AG26=\"\",\"\",9)","v":""},{"$f":"IF(AH26=\"\",\"\",10)","v":""},{"$f":"IF(AI26=\"\",\"\",11)","v":""},{"$f":"IF(AJ26=\"\",\"\",12)","v":""},{"$f":"IF(AK26=\"\",\"\",13)","v":""},{"$f":"IF(AL26=\"\",\"\",14)","v":""},{"$f":"IF(AM26=\"\",\"\",15)","v":""},{"$f":"IF(AN26=\"\",\"\",16)","v":""},{"$f":"IF(AO26=\"\",\"\",17)","v":""}]
[null,"FACADE",2.4,3,3.6,4.2,4.8,5.4,6,6.6,7.2,7.8,8.4,9,9.6,10.199999999999999,10.8,11.4,12,"moins value ","moins value",null,null,"PIGNON",{"$f":"IF(AND($L$55>0.1,$L$55<1.1),$B28,\"\")","v":""},{"$f":"IF(AND($L$55>1,$L$55<1.251),$B29,\"\")","v":""},{"$f":"IF(AND($L$55>1.25,$L$55<1.51),$B30,\"\")","v":""},{"$f":"IF(AND($L$55>1.5,$L$55<1.751),$B31,\"\")","v":""},{"$f":"IF(AND($L$55>1.75,$L$55<2.1),$B32,\"\")","v":""},{"$f":"IF(AND($L$55>2,$L$55<2.251),$B33,\"\")","v":""},{"$f":"IF(AND($L$55>2.25,$L$55<2.51),$B34,\"\")","v":""},{"$f":"IF(AND($L$55>2.5,$L$55<2.751),$B35,\"\")","v":""},{"$f":"IF(AND($L$55>2.75,$L$55<3.1),$B36,\"\")","v":""},{"$f":"IF(AND($L$55>3,$L$55<3.251),$B37,\"\")","v":""},{"$f":"IF(AND($L$55>3.25,$L$55<3.51),$B38,\"\")","v":""},{"$f":"IF(AND($L$55>3.5,$L$55<3.751),$B39,\"\")","v":""},{"$f":"IF(AND($L$55>3.75,$L$55<4.1),$B40,\"\")","v":""},{"$f":"IF(AND($L$55>4,$L$55<4.251),$B41,\"\")","v":""},{"$f":"IF(AND($L$55>4.25,$L$55<4.51),$B42,\"\")","v":""}]
[null,"PIGNON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," 1 pignon","2 pignons",null,null,"FACADE",{"$f":"IF(AND($F$55>0.1,$F$55<2.41),C26,\"\")","v":""},{"$f":"IF(AND($F$55>2.4,$F$55<3.1),D26,\"\")","v":""},{"$f":"IF(AND($F$55>3,$F$55<3.61),E26,\"\")","v":""},{"$f":"IF(AND($F$55>3.6,$F$55<4.21),F26,\"\")","v":""},{"$f":"IF(AND($F$55>4.2,$F$55<4.81),G26,\"\")","v":""},{"$f":"IF(AND($F$55>4.8,$F$55<5.41),H26,\"\")","v":""},{"$f":"IF(AND($F$55>5.4,$F$55<6.1),I26,\"\")","v":""},{"$f":"IF(AND($F$55>6,$F$55<6.61),J26,\"\")","v":""},{"$f":"IF(AND($F$55>6.6,$F$55<7.21),K26,\"\")","v":""},{"$f":"IF(AND($F$55>7.2,$F$55<7.81),L26,\"\")","v":""},{"$f":"IF(AND($F$55>7.8,$F$55<8.41),M26,\"\")","v":""},{"$f":"IF(AND($F$55>8.4,$F$55<9.1),N26,\"\")","v":""},{"$f":"IF(AND($F$55>9,$F$55<9.61),O26,\"\")","v":""},{"$f":"IF(AND($F$55>9.6,$F$55<10.21),P26,\"\")","v":""},{"$f":"IF(AND($F$55>10.2,$F$55<10.81),Q26,\"\")","v":""},{"$f":"IF(AND($F$55>10.8,$F$55<11.41),R26,\"\")","v":""},{"$f":"IF(AND($F$55>11.4,$F$55<12.1),S26,\"\")","v":""}]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y28:AO28)","v":0},{"$f":"IF(Y27=\"\",\"\",1)","v":""},{"$f":"IF(Z27=\"\",\"\",2)","v":""},{"$f":"IF(AA27=\"\",\"\",3)","v":""},{"$f":"IF(AB27=\"\",\"\",4)","v":""},{"$f":"IF(AC27=\"\",\"\",5)","v":""},{"$f":"IF(AD27=\"\",\"\",6)","v":""},{"$f":"IF(AE27=\"\",\"\",7)","v":""},{"$f":"IF(AF27=\"\",\"\",8)","v":""},{"$f":"IF(AG27=\"\",\"\",9)","v":""},{"$f":"IF(AH27=\"\",\"\",10)","v":""},{"$f":"IF(AI27=\"\",\"\",11)","v":""},{"$f":"IF(AJ27=\"\",\"\",12)","v":""},{"$f":"IF(AK27=\"\",\"\",13)","v":""},{"$f":"IF(AL27=\"\",\"\",14)","v":""},{"$f":"IF(AM27=\"\",\"\",15)","v":""},{"$f":"IF(AN27=\"\",\"\",16)","v":""},{"$f":"IF(AO27=\"\",\"\",17)","v":""}]
[null,1.25]
[null,1.5]
[null,1.75]
[null,2]
[null,2.25]
[null,2.5]
[null,2.75]
[null,3]
[null,3.25]
[null,3.5]
[null,3.75]
[null,4]
[null,4.25]
[null,4.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORT",2,3,4,5,6,7,8,9,10,11,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y43:AI43)","v":0},{"$f":"IF($Z$93<2.1,2,\"\")","v":""},{"$f":"IF(AND($Z$93>2,$Z$93<3.1),3,\"\")","v":""},{"$f":"IF(AND($Z$93>3,$Z$93<4.1),4,\"\")","v":""},{"$f":"IF(AND($Z$93>4,$Z$93<5.1),5,\"\")","v":""},{"$f":"IF(AND($Z$93>5,$Z$93<6.1),6,\"\")","v":""},{"$f":"IF(AND($Z$93>6,$Z$93<7.1),7,\"\")","v":""},{"$f":"IF(AND($Z$93>7,$Z$93<8.1),8,\"\")","v":""},{"$f":"IF(AND($Z$93>8,$Z$93<9.1),9,\"\")","v":""},{"$f":"IF(AND($Z$93>9,$Z$93<10.1),10,\"\")","v":""},{"$f":"IF(AND($Z$93>10,$Z$93<11.1),11,\"\")","v":""},{"$f":"IF(AND($Z$93>11,$Z$93<12.1),12,\"\")","v":""}]
[]
[null,null,"1P",null,null,null,"3P",null,null,null,"5 PAB",null,null,null,"3 PS",null,null,"5 PABS",null,null,"3 PSC",null,null,"POSE",{"$f":"IF(Z92<5,5.7,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($Z$92>4.99,$Z$92<10),8.55,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($Z$92>9.99,$Z$92<15),11.4,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($Z$92>14.99,$Z$92<20),14.25,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($Z$92>19.99,$Z$92<25),17.1,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND($Z$92>24.99,$Z$92<30),19.95,\"\")","v":{"$error":"#VALUE!"}},{"$f":"SUM(Y45:AD45)","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rappel Dimensions projet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H2","v":" LONGUEUR EN MM"},null,null,{"$f":"M2","v":0}]
[null,null,"5 PABSC",null,null,null,null,"Chalet 2 P",null,null,null,null,"Victorienne 3 P",null,null,null,null,{"$f":"H3","v":"LARGEUR EN MM"},null,null,{"$f":"M3","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H4","v":"HAUTEUR MAXI EN MM"},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H5","v":" SOUS CHENEAU EN MM"},null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Victorienne 5 PAB"]
[null,"COTES EXTERIEURES POTEAUX",null,null,null,null,null,null,null,null,null,null,null,"Barème",null,"Quantité","TARIF DE SERIE HT",null,null,null,null,"Tarif option 5%+TVA ok"]
[]
[null,"Base 1 pan (1)",null,"FACADE",null,{"$f":"IF(M2=\"\",\"\",M2/1000)","v":""},null,null,"Profondeur",null,null,{"$f":"IF(M3=\"\",\"\",M3/1000)","v":""},null,null,null,{"$f":"IF(AND(M2=\"\",M3=\"\"),\"\",1)","v":""},{"$f":"IF(P55=\"\",\"\",(INDEX(C28:S42,X25,X28)))","v":""},null,null,null,null,{"$f":"IF(A55=\"\",\"\",(((P55*N55)*$P$162%)+P55*N55)*0.95)","v":""},null,null,null,null,null,null,null,"9010   Blanc brillant"]
[null,"Moins value 1 pignon",null,null,null,null,null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"IF(P56=\"\",\"\",(INDEX($T$28:$U$42,$X$25,1)))","v":""},null,null,null,null,{"$f":"IF(A56=\"\",\"\",(((P56*N56)*$P$162%)+P56*N56)*0.95)","v":""},null,null,null,null,null,null,null,"1015   Ivoire brillant"]
[null,"Moins value 2 pignons",null,null,null,null,null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"IF(P57=\"\",\"\",(INDEX($T$28:$U$42,$X$25,2)))","v":""},null,null,null,null,{"$f":"IF(A57=\"\",\"\",(((P57*N57)*$P$162%)+P57*N57)*0.95)","v":""},null,null,null,null,null,null,null,"7016   Gris mat"]
[null,"Forme","1 pan pour coffre chéneau sur 1 pignon",null,null,null,null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"N58*P58","v":0},null,null,null,null,{"$f":"IF(A58=\"\",\"\",(((P58*N58)*$P$162%)+P58*N58)*0.95)","v":""},null,null,null,null,null,null,null,"1247   Marron mat"]
[null,null,"1 pan pour coffre chéneau sur 2 pignons",null,null,null,null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"N59*P59","v":0},null,null,null,null,{"$f":"IF(A59=\"\",\"\",(((P59*N59)*$P$162%)+P59*N59)*0.95)","v":""},null,null,null,null,null,null,null,"6005 Vert mousse mat"]
[null,null,"forme chalet: compter 2x1P+ forfait assemblage+ pente(1.2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3004 Rouge pourpre mat"]
[null,null,"Cocher la case si \"1angle\"",null,null,null,null,null,null,null,null,null,"1 angle","2 angles",null,null,"1 angle",null,null,"2 angles",null,{"$f":"IF(A61=\"\",\"\",(((P61*N61)*$P$162%)+P61*N61)*0.95)","v":""},null,null,null,null,null,null,null,"Gris 7035 mat"]
[null,null,"90°","3P",null,null,null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"IF($L$61=\"X\",M62*P62,\"\")","v":""},null,null,{"$f":"IF($L$61=\"X\",\"\",N62*P62)","v":0},null,{"$f":"IF(A62=\"\",\"\",(((P62*N62)*$P$162%)+P62*N62))","v":""},null,null,null,null,null,null,null,"Vert 6019 mat"]
[null,null,"135°","5PAB",null,null,null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"IF($L$61=\"X\",M63*P63,\"\")","v":""},null,null,{"$f":"IF($L$61=\"X\",\"\",N63*P63)","v":0},null,"",null,null,null,null,null,null,null,"Vert 6021 mat"]
[null,null,"90°","3PS",null,"soleil (4)",null,null,null,null,null,null,null,null,"Forfait",null,"",null,null,0,null,"",null,null,null,null,null,null,null,"5010 Bleu gentiane mat"]
[null,null,"135°","5PABS",null,"soleil (5)",null,null,null,null,null,null,null,null,"Forfait",null,"",null,null,0,null,"",null,null,null,null,null,null,null,"5003 Bleu gentiane mat"]
[null,null,"90°","3PSC",null,"soleil complet (6)",null,null,null,null,null,null,null,null,"Forfait",null,"",null,null,0,null,"",null,null,null,null,null,null,null,"SP003 Bleu étoilé texturé"]
[null,null,"135°","5PABSC",null,"soleil complet (7)",null,null,null,null,null,null,null,null,"Forfait",null,"",null,null,0,null,"",null,null,null,null,null,null,null,"SP004 Gris givré texturé"]
[null,null,"90°","CHALET 2P",null,"chalet (8) 2 agates dos à dos",null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"IF(P68=\"\",\"\",(IF(A68=\"\",P68*N68,\"\")))","v":""},null,null,null,null,"",null,null,null,null,null,null,null,"SP034 Noir chiné texturé"]
[null,null,null,null,null,"si façade 4500 à 6000 (au-delà nous consulter)",null,null,null,null,null,null,null,null,"Forfait",null,{"$f":"IF(P69=\"\",\"\",(IF(A69=\"\",P69*N69,\"\")))","v":""},null,null,null,null,"",null,null,null,null,null,null,null,"SP005 Noir texturé"]
[null,null,"90°","VIC3P",null,"Victorienne (9)",null,"façade maxi 4500",null,null,"> 4500 CONSULTER",null,null,null,"Forfait",null,"",null,null,null,null,"",null,null,null,null,null,null,null,"SP030 RAL alu anodisé (approchant)"]
[null,null,"135°","VIC5PAB",null,"Victorienne (10)",null,null,null,null,null,null,null,null,"Forfait",null,"",null,null,null,null,"",null,null,null,null,null,null,null,"Bleu canon"]
[null,"Ferme ou Portique",null,null,null,null,null,null,null,null,null,null,null,null,"ml",null,{"$f":"IF(P72=\"\",\"\",(IF(A72=\"\",P72*N72,\"\")))","v":""},null,null,null,null,"",null,null,null,null,null,null,null,"9010 Granité texturé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"1015 Granité texturé"]
[null,"Chassis","assise périmétrale",null,null,null,null,null,null,null,null,null,null,null,"ml",null,{"$f":"IF(P74=\"\",\"\",(IF(A74=\"\",P74*N74,\"\")))","v":""},null,null,null,null,"",null,null,null,null,null,null,null,"7016 Granité texturé"]
[null,null,"porte 1 VT",null,null,null,null,null,null,null,null,null,null,null,"u",null,{"$f":"IF(P75=\"\",\"\",(IF(A75=\"\",P75*N75,\"\")))","v":""},null,null,null,null,"",null,null,null,null,null,null,null,"Autres teintes granitées sur demande"]
[null,null,"porte 2 VTx",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,"",null,null,null,null,null,null,null,"Chêne doré - SP038"]
[null,null,"Coulissant triple rail",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,"",null,null,null,null,null,null,null,"8011 Texture marron clair"]
[null,null,"Fenêtre 1 vantail OB",null,null,null,null,null,null,null,null,null,null,null,"u",null,{"$f":"IF(P78=\"\",\"\",(IF(A78=\"\",P78*N78,\"\")))","v":""},null,null,null,null,""]
[null,null,"Fenêtre 2 vantaux OB",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Abattant ou soufflet d'aération",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Liaison 135° confort ou fourrure 50*50 ou TI > 1000",null,null,null,null,null,null,null,null,null,null,null,"ml",null,{"$f":"IF(P81=\"\",\"\",(IF(A81=\"\",P81*N81,\"\")))","v":""},null,null,null,null,""]
[null,"Résidence","Menuiserie TV 42 concept levage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Coloris alu       intérieur et extérieur ","9010 blanc - 1015 beige - 1247 brun foncé - 6005 vert foncé - bordeaux 3004",null,null,null,null,null,null,null,null,null,null,"Compris",null,null,"",null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C84=\"\",\"\",VLOOKUP(C84,$AD$55:$AE$77,2,FALSE))","v":""},"%",null,{"$f":"IF(P84=\"\",\"\",(IF(A84=\"\",Q55*(N84/100),\"\")))","v":""},null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C85=\"\",\"\",VLOOKUP(C85,$AD$55:$AE$77,2,FALSE))","v":""},"%",null,{"$f":"IF(P85=\"\",\"\",(IF(A85=\"\",Q56*(N85/100),\"\")))","v":""},null,null,null,null,""]
[null,"Aérateur","Incorporé menuiserie",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Toit THK 170",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,"Bavette 40 x 20","Sol",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"Murêts",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"Corniche décorative (Pour véranda sans chéneau COFFRE) compris étanchéité renforcée",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"DEP mur ou intégrée dans poteau si chéneau classique, 2 unitées OBLIGATOIRE",null,null,null,null,null,null,null,null,null,null,null,"Forfait",null,"",null,null,null,null,"",null,"PERIMETRE",null,{"$f":"F55+L55+L55","v":{"$error":"#VALUE!"}}]
[null,"Chéneau coffre pour VR ou BSO","Poteau angles 90° (2m20) ou contre mur avec ou sans DEP",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,"",null,"surface pose",null,{"$f":"F55*L55","v":{"$error":"#VALUE!"}}]
[null,null,"Poteau angles 135° (2m20) avec ou sans DEP",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,"",null,"longueur transport",null,{"$f":"F55","v":""}]
[null,null,"Coffre alu VR/BSO/TOILE SOLAIRE",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,"",null,"Nombre spots",null,{"$f":"Z92/2","v":{"$error":"#VALUE!"}}]
[null,null,"Poteau intermédiaire ou contre mur, sans DEP",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,"",null,"facade",null,{"$f":"F55","v":""}]
[null,"Adaptation faitière","solin",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,"",null,"profondeur",null,{"$f":"L55","v":""}]
[null,null,"reprise sur toiture existante",null,null,null,null,null,null,null,null,null,null,null,"forfait",null,{"$f":"IF(P97=\"\",\"\",(IF(A97=\"\",P97*N97,\"\")))","v":""},null,null,null,null,""]
[null,"toiture","Isolation chéneau contre mur",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"Rattrapage faux niveau (terrasse carrelée) SANS garantie d'étanchéité",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"Chevrons support vitrages 100 mm rampant toiture < 3250",null,null,null,null,null,null,null,null,null,null,null,"ml",null,{"$f":"IF(P100=\"\",\"\",(IF(A100=\"\",P100*N100,\"\")))","v":""},null,null,null,null,""]
[null,null,"Chevrons 152 mm rampant toiture > 3250",null,null,null,null,null,null,null,null,null,null,null,"ml",null,{"$f":"IF(P101=\"\",\"\",(IF(A101=\"\",P101*N101,\"\")))","v":""},null,null,null,null,""]
[null,null,"Plus value TV suncool 52 mm",null,null,null,null,"Vitrages rectangulaires / autres formes consulter",null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"Plus value DV suncool 31 mm",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"Traverse intermédiaire sur toiture vitrage ou sur chassis",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Profil tubulaire pour spot",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"44.2 (compris traverse)",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF(P106=\"\",\"\",(IF(A106=\"\",N106*P106,\"\")))","v":""},null,null,null,null,""]
[null,null,"Soubassement PS 24 mm (compris traverse)",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF(P107=\"\",\"\",(IF(A107=\"\",N107*P107,\"\")))","v":""},null,null,null,null,""]
[null,null,"Soubassement PS 42 mm (compris traverse)",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF(P108=\"\",\"\",(IF(A108=\"\",N108*P108,\"\")))","v":""},null,null,null,null,""]
[null,"Cocher la case si \"forme soleil\"",null,null,null,null,null,null,null,null,"FORME SOLEIL",null,null,null,null,null,"Forme soleil",null,null,"Forme classique",null,""]
[null,"Polycarbonnate","Plus value P 32 RE",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF($J$109=\"X\",K110*P110,\"\")","v":""},null,null,{"$f":"IF($J$109=\"\",N110*P110,\"\")","v":0},null,""]
[null,"PANNEAU SANDWICH","Plus value PS 32Ac",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF($J$109=\"X\",K111*P111,\"\")","v":""},null,null,{"$f":"IF($J$109=\"\",N111*P111,\"\")","v":0},null,""]
[null,null,"Plus value PS 66Ac",null,null,null,null,null,null,null,null,null,null,null,"m²",null,null,null,null,0,null,""]
[null,null,"Plus value PS 71Ac+",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,0,null,""]
[null,null,"Plus value PS 68Ac+",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,0,null,""]
[null,null,"Plus value PS 107 mm (super thermo-acoustique)",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,{"$f":"IF($J$109=\"\",N115*P115,\"\")","v":0},null,""]
[null,null,"Plus value couche anti-grêle",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,0,null,""]
[null,null,"Traverse Entre Chassis imposte ou allège fixe ",null,null,null,null,null,null,null,null,null,null,null,"ML",null,{"$f":"IF(P117=\"\",\"\",P117*N117)","v":""},null,null,null,null,""]
[null,"Muret","Murêt structure bois ép. 131mm + canexell",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF(P118=\"\",\"\",(IF(A118=\"\",N118*P118,\"\")))","v":""},null,null,null,null,""]
[null,null,"Murêt structure bois ép. 231mm + canexell",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,"Moins value murêt en allege uniquement",null,null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF(P120=\"\",\"\",(IF(A120=\"\",N120*P120,\"\")))","v":""},null,null,null,null,""]
[null,null,"cocher la case si LED",null,null,null,null,null,null,null,null,null,"x",null,null,null,null,null,null,null,null,""]
[null,"Spots RT",{"$f":"IF($M$121=\"\",\"4 spots hallogenes\",\"3 spots LED\")","v":"3 spots LED"},null,null,null,null,null,null,null,null,null,null,null,"pack",null,{"$f":"IF(P122=\"\",\"\",(IF(A122=\"\",N122*P122,\"\")))","v":""},null,null,null,null,""]
[null,null,{"$f":"IF($M$121=\"\",\"6 spots hallogenes\",\"6 spots LED\")","v":"6 spots LED"},null,null,null,null,null,null,null,null,null,null,null,"pack",null,"",null,null,null,null,""]
[null,null,{"$f":"IF($M$121=\"\",\"9 spots hallogenes\",\"9 spots LED\")","v":"9 spots LED"},null,null,null,null,null,null,null,null,null,null,null,"pack",null,"",null,null,null,null,""]
[null,null,{"$f":"IF($M$121=\"\",\"12 spots hallogenes\",\"12 spots LED\")","v":"12 spots LED"},null,null,null,null,null,null,null,null,null,null,null,"pack",null,"",null,null,null,null,""]
[null,null,{"$f":"IF($M$121=\"\",\"15 spots hallogenes\",\"15 spots LED\")","v":"15 spots LED"},null,null,null,null,null,null,null,null,null,null,null,"pack",null,"",null,null,null,null,{"$f":"IF(A126=\"\",\"\",(((P126*N126)*$P$162%)+P126*N126))","v":""}]
[null,null,{"$f":"IF($M$121=\"\",\"18 spots hallogenes\",\"18 spots LED\")","v":"18 spots LED"},null,null,null,null,null,null,null,null,null,null,null,"pack",null,"",null,null,null,null,""]
[null,"Hauteur sous chéneau",null,"> 2200",null,null,null," > 2300 < 2400",null,null,null,"L = (A + B + C)",null,null,"ml",null,{"$f":"IF(N128=\"\",\"\",N128*P128)","v":""},null,null,null,null,""]
[null,"Déco victorienne","Pointe",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Crête",null,null,null,null,null,null,null,null,null,null,null,"ml",null,"",null,null,null,null,""]
[null,null,"flammes sur chéneau",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,"Déco vitrages","Petits bois (le carreau) 9010-1015-6005 (autres coloris consulter)",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Cintres 26x8 laiton-9010-1015-6005",null,null,null,null,null,"Bicoloration impossible",null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Cintres 26x8 autres coloris",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Sablages (formes 1-2-4-6)",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Sablages (formes 3-7-8-9)",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,"Déco panneaux","Clématite",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Myosotis",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Forme rectangulaire moulurée",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,null,"Forme rectangulaire plat 30x2",null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,"Vitrages isolants spéciaux ép : 24mm     forme rectangulaires","Double vitrage réfléchissant Suncool 40-20",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"1 face imprimé 200",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"dépoli surface totale",null,null,null,null,null,null,null,null,null,null,null,"m²",null,{"$f":"IF(P143=\"\",\"\",(IF(A143=\"\",N143*P143,\"\")))","v":""},null,null,null,null,""]
[null,null,"double vitrage 10-6-4 (phonique)",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"1 face feuilleté 44,2",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"1 face opale 44,2",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"Double vitrage bioclean",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"Double vitrage bioclean ACTIV+ suncool 40-20",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"2 faces feuilleté 44,2",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,null,"1 face feuilleté SP10",null,null,null,null,null,null,null,null,null,null,null,"m²",null,"",null,null,null,null,""]
[null,"divers",null,null,null,null,{"$f":"_maformule2","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"ma_formule","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"IF(AND($Q$153=\"\",'Tableaux Menuiseries, VR, BSO'!$J$54=\"\"),\"VR ou BSO\",IF(AND(Confort!A153=\"\",'Tableaux Menuiseries, VR, BSO'!J54>1,Confort!Q153=\"\"),\"ATTENTION VALEUR PROTECTIONS SOLAIRE\",'Tableaux Menuiseries, VR, BSO'!C35))","v":"VR ou BSO"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Permis",null,null,null,null,null,null,null,null,null,null,null,null,"u",null,"",null,null,null,null,""]
[null,"Transport",2,3,4,5,6,7,8,9,10,11,12,1,"u",{"$f":"IF(P55=1,1,\"\")","v":""},{"$f":"IF(P155=\"\",\"\",(INDEX(B155:L156,2,X43)))","v":""},null,null,null,null,{"$f":"IF(A155=\"\",\"\",(((P155*N155)*$P$162%)+P155*N155)*0.95)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A156=\"\",\"\",(((P156*N156)*$P$162%)+P156*N156)*0.95)","v":""},null,null,null,null,"ht"]
[null,"Pose",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F55=\"\",\"\",IF(Z92>30,19.95/30*Z92,AE45))","v":""},null,null,null,null,{"$f":"IF(A157=\"\",\"\",(((P157*N157)*$P$162%)+P157*N157)*0.95)","v":""},null,null,"VR",null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!J42=\"\",\"\",'Tableaux Menuiseries, VR, BSO'!J42)","v":""}]
[null,{"$f":"IF(X158<204,\"TOTAL POINTS HT \",\"TOTAL POINTS HT  -2% sup 200\")","v":"TOTAL POINTS HT "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X158>220,X158*0.98*0.95,X158*0.95)","v":0},null,null,null,null,null,null,{"$f":"SUM(Q55:U157)","v":0},"BSO",null,{"$f":"'Tableaux Menuiseries, VR, BSO'!J53","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total EURO HT hors code",null,null,{"$f":"IF(C15=\"\",Q158*1,Q158*1)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL EURO HT",null,{"$f":"+IF(C15=\"\",Q158*1,Q158*1)","v":0},null,null,null,null,null,null,null,"Concept Levage",null,{"$f":"IF(C15=\"\",'Tableaux Menuiseries, VR, BSO'!I30*190,'Tableaux Menuiseries, VR, BSO'!I30*230)","v":{"$error":"#VALUE!"}}]
[null,"TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15=\"\",I15,\"8\")","v":{"$error":"#VALUE!"}},{"$f":"IF(Q161=\"\",\"\",Q161*P162%)","v":{"$error":"#VALUE!"}}]
[null,"TOTAL TTC",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15=\"\",Q162+Q161,Q161+Q162)","v":{"$error":"#VALUE!"}}]
[1,{"$f":"\"PLUS VALUE TTC\"&CHAR(10)&\"compris code \"&M160","v":"PLUS VALUE TTC\ncompris code "},"OPTION",null,{"$f":"IF(ISNA(VLOOKUP(A164,$A$55:$A$157,1,FALSE)),\"\",(VLOOKUP(A164,$A$55:$U$157,3,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V164=\"\",\"\",IF(C15=\"\",V164*190,V164*230))","v":""},null,null,null,null,{"$f":"IF(ISNA(VLOOKUP(A164,$A$53:$V$157,1,FALSE)),\"\",(VLOOKUP(A164,$A$55:$V$157,22,FALSE)))","v":""}]
[2,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V165=\"\",\"\",IF(C16=\"\",V165*190,V165*230))","v":""},null,null,null,null,""]
[3,null,"OPTION",null,{"$f":"IF(ISNA(VLOOKUP(A166,$A$55:$A$157,1,FALSE)),\"\",(VLOOKUP(A166,$A$55:$U$157,3,FALSE)))","v":""},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[4,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[5,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[6,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[7,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[8,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[9,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,""]
[10,null,"OPTION",null,"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V173=\"\",\"\",IF(C24=\"\",V173*190,V173*230))","v":""},null,null,null,null,""]
[null,"TOTAL TTC AVEC OPTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q163:U173)","v":{"$error":"#VALUE!"}}]

{"sheet":"Tableaux Menuiseries, VR, BSO","index":1,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,3,43,4],[43,5,43,6],[43,7,43,8],[40,3,40,4],[40,5,40,6],[40,7,40,8],[42,7,42,8],[42,3,42,4],[42,5,42,6],[31,0,32,8],[39,3,39,4],[39,5,39,6],[39,7,39,8],[33,5,33,6],[33,3,33,4],[33,7,33,8],[36,3,36,4],[36,5,36,6],[36,7,36,8],[34,7,34,8],[35,7,35,8],[34,3,34,4],[34,5,34,6],[35,3,35,4],[35,5,35,6],[45,7,45,8],[49,7,49,8],[46,3,46,4],[46,5,46,6],[46,7,46,8],[47,3,47,4],[47,5,47,6],[47,7,47,8],[48,3,48,4],[48,5,48,6],[48,7,48,8],[49,3,49,4],[49,5,49,6],[45,3,45,4],[45,5,45,6],[44,3,44,4],[44,5,44,6],[44,7,44,8],[0,0,0,7],[0,13,1,13],[2,0,14,0],[15,0,27,0],[41,3,41,4],[41,5,41,6],[41,7,41,8],[37,3,37,4],[37,5,37,6],[37,7,37,8],[38,3,38,4],[38,5,38,6],[38,7,38,8],[52,7,52,8],[52,3,52,4],[52,5,52,6],[50,3,50,4],[50,5,50,6],[50,7,50,8],[51,3,51,4],[51,5,51,6],[51,7,51,8]]}
["fiche descriptive option levage",null,null,null,null,null,null,null,null,null,null,"HAUTEUR","HAUTEUR","COEFFICIENT"]
[null,"face","NBRE","type","largeur","hauteur","coef","valeur dv","valeur tv",null,null,"F-FT-C2-C3-C4-P-P2","O - DO - IT"]
["BASE",null,null,null,null,null,{"$f":"IF(OR(D3=\"f\",D3=\"ft\",D3=\"c2\",D3=\"c3\",D3=\"c4\",D3=\"p\",D3=\"p2\",D3=\"f tra\",D3=\"f ri\",D3=\"ft tra\",D3=\"ft ri\"),(VLOOKUP(F3,$L$3:$N$30,3,FALSE)),(IF(OR(D3=\"o\",D3=\"do\",D3=\"cob\",D3=\"fob\"),(VLOOKUP(F3,$M$3:$N$30,2,FALSE)),\"\")))","v":""},{"$f":"IF(C3=\"\",\"\",IF(D3=\"C2\",(HLOOKUP(E3,Tarifs!$C$13:$AG$15,2,FALSE)*G3),IF(D3=\"C3\",(HLOOKUP(E3,Tarifs!$C$37:$AI$39,2,FALSE)*G3),IF(D3=\"f\",(HLOOKUP(E3,Tarifs!$C$56:$Z$59,2,FALSE)*G3),IF(D3=\"ft\",(HLOOKUP(E3,Tarifs!$C$69:$Z$72,2,FALSE)*G3),IF(D3=\"c4\",(HLOOKUP(E3,Tarifs!$C$82:$AV$85,2,FALSE)*G3),IF(D3=\"p\",(HLOOKUP(E3,Tarifs!$C$107:$H$109,2,FALSE)*G3),IF(D3=\"p2\",(HLOOKUP(E3,Tarifs!$C$115:$N$117,2,FALSE)*G3),IF(D3=\"f tra\",((HLOOKUP(E3,Tarifs!$C$56:$Z$59,2,FALSE)*G3)*1.2),IF(D3=\"ft RI\",((HLOOKUP(E3,Tarifs!$C$69:$Z$72,2,FALSE)*G3)*1.4),IF(D3=\"f RI\",((HLOOKUP(E3,Tarifs!$C$56:$Z$59,2,FALSE)*G3)*1.4),IF(D3=\"ft TRA\",((HLOOKUP(E3,Tarifs!$C$69:$Z$72,2,FALSE)*G3)*1.2),IF(D3=\"o\",(HLOOKUP(E3,Tarifs!$C$133:$N$135,2,FALSE)*G3),IF(D3=\"cob\",((HLOOKUP(E3,Tarifs!$C$133:$N$135,2,FALSE)*G3)+1.25),IF(D3=\"do\",(HLOOKUP(E3,Tarifs!$C$139:$K$141,2,FALSE)*G3),IF(D3=\"fob\",((HLOOKUP(E3,Tarifs!C139:K141,2,FALSE)*G3)+1.25))))))))))))))))*C3)","v":""},null,null,null,3,null,1.27]
[null,null,null,null,null,null,"",{"$f":"IF(C4=\"\",\"\",IF(D4=\"C2\",(HLOOKUP(E4,Tarifs!$C$13:$AG$15,2,FALSE)*G4),IF(D4=\"C3\",(HLOOKUP(E4,Tarifs!$C$37:$AI$39,2,FALSE)*G4),IF(D4=\"f\",(HLOOKUP(E4,Tarifs!$C$56:$Z$59,2,FALSE)*G4),IF(D4=\"ft\",(HLOOKUP(E4,Tarifs!$C$69:$Z$72,2,FALSE)*G4),IF(D4=\"c4\",(HLOOKUP(E4,Tarifs!$C$82:$AV$85,2,FALSE)*G4),IF(D4=\"p\",(HLOOKUP(E4,Tarifs!$C$107:$H$109,2,FALSE)*G4),IF(D4=\"p2\",(HLOOKUP(E4,Tarifs!$C$115:$N$117,2,FALSE)*G4),IF(D4=\"f tra\",((HLOOKUP(E4,Tarifs!$C$56:$Z$59,2,FALSE)*G4)*1.2),IF(D4=\"ft RI\",((HLOOKUP(E4,Tarifs!$C$69:$Z$72,2,FALSE)*G4)*1.4),IF(D4=\"f RI\",((HLOOKUP(E4,Tarifs!$C$56:$Z$59,2,FALSE)*G4)*1.4),IF(D4=\"ft TRA\",((HLOOKUP(E4,Tarifs!$C$69:$Z$72,2,FALSE)*G4)*1.2),IF(D4=\"o\",(HLOOKUP(E4,Tarifs!$C$133:$N$135,2,FALSE)*G4),IF(D4=\"cob\",((HLOOKUP(E4,Tarifs!$C$133:$N$135,2,FALSE)*G4)+1.25),IF(D4=\"do\",(HLOOKUP(E4,Tarifs!$C$139:$K$141,2,FALSE)*G4),IF(D4=\"fob\",((HLOOKUP(E4,Tarifs!C140:K142,2,FALSE)*G4)+1.25))))))))))))))))*C4)","v":""},null,null,null,2.9,null,1.24]
[null,null,null,null,null,null,"",{"$f":"IF(C5=\"\",\"\",IF(D5=\"C2\",(HLOOKUP(E5,Tarifs!$C$13:$AG$15,2,FALSE)*G5),IF(D5=\"C3\",(HLOOKUP(E5,Tarifs!$C$37:$AI$39,2,FALSE)*G5),IF(D5=\"f\",(HLOOKUP(E5,Tarifs!$C$56:$Z$59,2,FALSE)*G5),IF(D5=\"ft\",(HLOOKUP(E5,Tarifs!$C$69:$Z$72,2,FALSE)*G5),IF(D5=\"c4\",(HLOOKUP(E5,Tarifs!$C$82:$AV$85,2,FALSE)*G5),IF(D5=\"p\",(HLOOKUP(E5,Tarifs!$C$107:$H$109,2,FALSE)*G5),IF(D5=\"p2\",(HLOOKUP(E5,Tarifs!$C$115:$N$117,2,FALSE)*G5),IF(D5=\"f tra\",((HLOOKUP(E5,Tarifs!$C$56:$Z$59,2,FALSE)*G5)*1.2),IF(D5=\"ft RI\",((HLOOKUP(E5,Tarifs!$C$69:$Z$72,2,FALSE)*G5)*1.4),IF(D5=\"f RI\",((HLOOKUP(E5,Tarifs!$C$56:$Z$59,2,FALSE)*G5)*1.4),IF(D5=\"ft TRA\",((HLOOKUP(E5,Tarifs!$C$69:$Z$72,2,FALSE)*G5)*1.2),IF(D5=\"o\",(HLOOKUP(E5,Tarifs!$C$133:$N$135,2,FALSE)*G5),IF(D5=\"cob\",((HLOOKUP(E5,Tarifs!$C$133:$N$135,2,FALSE)*G5)+1.25),IF(D5=\"do\",(HLOOKUP(E5,Tarifs!$C$139:$K$141,2,FALSE)*G5),IF(D5=\"fob\",((HLOOKUP(E5,Tarifs!C141:K143,2,FALSE)*G5)+1.25))))))))))))))))*C5)","v":""},null,null,null,2.8,null,1.21]
[null,null,null,null,null,null,"",{"$f":"IF(C6=\"\",\"\",IF(D6=\"C2\",(HLOOKUP(E6,Tarifs!$C$13:$AG$15,2,FALSE)*G6),IF(D6=\"C3\",(HLOOKUP(E6,Tarifs!$C$37:$AI$39,2,FALSE)*G6),IF(D6=\"f\",(HLOOKUP(E6,Tarifs!$C$56:$Z$59,2,FALSE)*G6),IF(D6=\"ft\",(HLOOKUP(E6,Tarifs!$C$69:$Z$72,2,FALSE)*G6),IF(D6=\"c4\",(HLOOKUP(E6,Tarifs!$C$82:$AV$85,2,FALSE)*G6),IF(D6=\"p\",(HLOOKUP(E6,Tarifs!$C$107:$H$109,2,FALSE)*G6),IF(D6=\"p2\",(HLOOKUP(E6,Tarifs!$C$115:$N$117,2,FALSE)*G6),IF(D6=\"f tra\",((HLOOKUP(E6,Tarifs!$C$56:$Z$59,2,FALSE)*G6)*1.2),IF(D6=\"ft RI\",((HLOOKUP(E6,Tarifs!$C$69:$Z$72,2,FALSE)*G6)*1.4),IF(D6=\"f RI\",((HLOOKUP(E6,Tarifs!$C$56:$Z$59,2,FALSE)*G6)*1.4),IF(D6=\"ft TRA\",((HLOOKUP(E6,Tarifs!$C$69:$Z$72,2,FALSE)*G6)*1.2),IF(D6=\"o\",(HLOOKUP(E6,Tarifs!$C$133:$N$135,2,FALSE)*G6),IF(D6=\"cob\",((HLOOKUP(E6,Tarifs!$C$133:$N$135,2,FALSE)*G6)+1.25),IF(D6=\"do\",(HLOOKUP(E6,Tarifs!$C$139:$K$141,2,FALSE)*G6),IF(D6=\"fob\",((HLOOKUP(E6,Tarifs!C142:K144,2,FALSE)*G6)+1.25))))))))))))))))*C6)","v":""},null,null,null,2.7,null,1.18]
[null,null,null,null,null,null,"",{"$f":"IF(C7=\"\",\"\",IF(D7=\"C2\",(HLOOKUP(E7,Tarifs!$C$13:$AG$15,2,FALSE)*G7),IF(D7=\"C3\",(HLOOKUP(E7,Tarifs!$C$37:$AI$39,2,FALSE)*G7),IF(D7=\"f\",(HLOOKUP(E7,Tarifs!$C$56:$Z$59,2,FALSE)*G7),IF(D7=\"ft\",(HLOOKUP(E7,Tarifs!$C$69:$Z$72,2,FALSE)*G7),IF(D7=\"c4\",(HLOOKUP(E7,Tarifs!$C$82:$AV$85,2,FALSE)*G7),IF(D7=\"p\",(HLOOKUP(E7,Tarifs!$C$107:$H$109,2,FALSE)*G7),IF(D7=\"p2\",(HLOOKUP(E7,Tarifs!$C$115:$N$117,2,FALSE)*G7),IF(D7=\"f tra\",((HLOOKUP(E7,Tarifs!$C$56:$Z$59,2,FALSE)*G7)*1.2),IF(D7=\"ft RI\",((HLOOKUP(E7,Tarifs!$C$69:$Z$72,2,FALSE)*G7)*1.4),IF(D7=\"f RI\",((HLOOKUP(E7,Tarifs!$C$56:$Z$59,2,FALSE)*G7)*1.4),IF(D7=\"ft TRA\",((HLOOKUP(E7,Tarifs!$C$69:$Z$72,2,FALSE)*G7)*1.2),IF(D7=\"o\",(HLOOKUP(E7,Tarifs!$C$133:$N$135,2,FALSE)*G7),IF(D7=\"cob\",((HLOOKUP(E7,Tarifs!$C$133:$N$135,2,FALSE)*G7)+1.25),IF(D7=\"do\",(HLOOKUP(E7,Tarifs!$C$139:$K$141,2,FALSE)*G7),IF(D7=\"fob\",((HLOOKUP(E7,Tarifs!C143:K145,2,FALSE)*G7)+1.25))))))))))))))))*C7)","v":""},null,null,null,2.6,null,1.1499999999999999]
[null,null,null,null,null,null,"",{"$f":"IF(C8=\"\",\"\",IF(D8=\"C2\",(HLOOKUP(E8,Tarifs!$C$13:$AG$15,2,FALSE)*G8),IF(D8=\"C3\",(HLOOKUP(E8,Tarifs!$C$37:$AI$39,2,FALSE)*G8),IF(D8=\"f\",(HLOOKUP(E8,Tarifs!$C$56:$Z$59,2,FALSE)*G8),IF(D8=\"ft\",(HLOOKUP(E8,Tarifs!$C$69:$Z$72,2,FALSE)*G8),IF(D8=\"c4\",(HLOOKUP(E8,Tarifs!$C$82:$AV$85,2,FALSE)*G8),IF(D8=\"p\",(HLOOKUP(E8,Tarifs!$C$107:$H$109,2,FALSE)*G8),IF(D8=\"p2\",(HLOOKUP(E8,Tarifs!$C$115:$N$117,2,FALSE)*G8),IF(D8=\"f tra\",((HLOOKUP(E8,Tarifs!$C$56:$Z$59,2,FALSE)*G8)*1.2),IF(D8=\"ft RI\",((HLOOKUP(E8,Tarifs!$C$69:$Z$72,2,FALSE)*G8)*1.4),IF(D8=\"f RI\",((HLOOKUP(E8,Tarifs!$C$56:$Z$59,2,FALSE)*G8)*1.4),IF(D8=\"ft TRA\",((HLOOKUP(E8,Tarifs!$C$69:$Z$72,2,FALSE)*G8)*1.2),IF(D8=\"o\",(HLOOKUP(E8,Tarifs!$C$133:$N$135,2,FALSE)*G8),IF(D8=\"cob\",((HLOOKUP(E8,Tarifs!$C$133:$N$135,2,FALSE)*G8)+1.25),IF(D8=\"do\",(HLOOKUP(E8,Tarifs!$C$139:$K$141,2,FALSE)*G8),IF(D8=\"fob\",((HLOOKUP(E8,Tarifs!C144:K146,2,FALSE)*G8)+1.25))))))))))))))))*C8)","v":""},null,null,null,2.5,1.7,1.1200000000000001]
[null,null,null,null,null,null,"",{"$f":"IF(C9=\"\",\"\",IF(D9=\"C2\",(HLOOKUP(E9,Tarifs!$C$13:$AG$15,2,FALSE)*G9),IF(D9=\"C3\",(HLOOKUP(E9,Tarifs!$C$37:$AI$39,2,FALSE)*G9),IF(D9=\"f\",(HLOOKUP(E9,Tarifs!$C$56:$Z$59,2,FALSE)*G9),IF(D9=\"ft\",(HLOOKUP(E9,Tarifs!$C$69:$Z$72,2,FALSE)*G9),IF(D9=\"c4\",(HLOOKUP(E9,Tarifs!$C$82:$AV$85,2,FALSE)*G9),IF(D9=\"p\",(HLOOKUP(E9,Tarifs!$C$107:$H$109,2,FALSE)*G9),IF(D9=\"p2\",(HLOOKUP(E9,Tarifs!$C$115:$N$117,2,FALSE)*G9),IF(D9=\"f tra\",((HLOOKUP(E9,Tarifs!$C$56:$Z$59,2,FALSE)*G9)*1.2),IF(D9=\"ft RI\",((HLOOKUP(E9,Tarifs!$C$69:$Z$72,2,FALSE)*G9)*1.4),IF(D9=\"f RI\",((HLOOKUP(E9,Tarifs!$C$56:$Z$59,2,FALSE)*G9)*1.4),IF(D9=\"ft TRA\",((HLOOKUP(E9,Tarifs!$C$69:$Z$72,2,FALSE)*G9)*1.2),IF(D9=\"o\",(HLOOKUP(E9,Tarifs!$C$133:$N$135,2,FALSE)*G9),IF(D9=\"cob\",((HLOOKUP(E9,Tarifs!$C$133:$N$135,2,FALSE)*G9)+1.25),IF(D9=\"do\",(HLOOKUP(E9,Tarifs!$C$139:$K$141,2,FALSE)*G9),IF(D9=\"fob\",((HLOOKUP(E9,Tarifs!C145:K147,2,FALSE)*G9)+1.25))))))))))))))))*C9)","v":""},null,null,null,2.4,1.6,1.0900000000000001]
[null,null,null,null,null,null,"",{"$f":"IF(C10=\"\",\"\",IF(D10=\"C2\",(HLOOKUP(E10,Tarifs!$C$13:$AG$15,2,FALSE)*G10),IF(D10=\"C3\",(HLOOKUP(E10,Tarifs!$C$37:$AI$39,2,FALSE)*G10),IF(D10=\"f\",(HLOOKUP(E10,Tarifs!$C$56:$Z$59,2,FALSE)*G10),IF(D10=\"ft\",(HLOOKUP(E10,Tarifs!$C$69:$Z$72,2,FALSE)*G10),IF(D10=\"c4\",(HLOOKUP(E10,Tarifs!$C$82:$AV$85,2,FALSE)*G10),IF(D10=\"p\",(HLOOKUP(E10,Tarifs!$C$107:$H$109,2,FALSE)*G10),IF(D10=\"p2\",(HLOOKUP(E10,Tarifs!$C$115:$N$117,2,FALSE)*G10),IF(D10=\"f tra\",((HLOOKUP(E10,Tarifs!$C$56:$Z$59,2,FALSE)*G10)*1.2),IF(D10=\"ft RI\",((HLOOKUP(E10,Tarifs!$C$69:$Z$72,2,FALSE)*G10)*1.4),IF(D10=\"f RI\",((HLOOKUP(E10,Tarifs!$C$56:$Z$59,2,FALSE)*G10)*1.4),IF(D10=\"ft TRA\",((HLOOKUP(E10,Tarifs!$C$69:$Z$72,2,FALSE)*G10)*1.2),IF(D10=\"o\",(HLOOKUP(E10,Tarifs!$C$133:$N$135,2,FALSE)*G10),IF(D10=\"cob\",((HLOOKUP(E10,Tarifs!$C$133:$N$135,2,FALSE)*G10)+1.25),IF(D10=\"do\",(HLOOKUP(E10,Tarifs!$C$139:$K$141,2,FALSE)*G10),IF(D10=\"fob\",((HLOOKUP(E10,Tarifs!C146:K148,2,FALSE)*G10)+1.25))))))))))))))))*C10)","v":""},null,null,null,2.2999999999999998,1.5,1.06]
[null,null,null,null,null,null,"",{"$f":"IF(C11=\"\",\"\",IF(D11=\"C2\",(HLOOKUP(E11,Tarifs!$C$13:$AG$15,2,FALSE)*G11),IF(D11=\"C3\",(HLOOKUP(E11,Tarifs!$C$37:$AI$39,2,FALSE)*G11),IF(D11=\"f\",(HLOOKUP(E11,Tarifs!$C$56:$Z$59,2,FALSE)*G11),IF(D11=\"ft\",(HLOOKUP(E11,Tarifs!$C$69:$Z$72,2,FALSE)*G11),IF(D11=\"c4\",(HLOOKUP(E11,Tarifs!$C$82:$AV$85,2,FALSE)*G11),IF(D11=\"p\",(HLOOKUP(E11,Tarifs!$C$107:$H$109,2,FALSE)*G11),IF(D11=\"p2\",(HLOOKUP(E11,Tarifs!$C$115:$N$117,2,FALSE)*G11),IF(D11=\"f tra\",((HLOOKUP(E11,Tarifs!$C$56:$Z$59,2,FALSE)*G11)*1.2),IF(D11=\"ft RI\",((HLOOKUP(E11,Tarifs!$C$69:$Z$72,2,FALSE)*G11)*1.4),IF(D11=\"f RI\",((HLOOKUP(E11,Tarifs!$C$56:$Z$59,2,FALSE)*G11)*1.4),IF(D11=\"ft TRA\",((HLOOKUP(E11,Tarifs!$C$69:$Z$72,2,FALSE)*G11)*1.2),IF(D11=\"o\",(HLOOKUP(E11,Tarifs!$C$133:$N$135,2,FALSE)*G11),IF(D11=\"cob\",((HLOOKUP(E11,Tarifs!$C$133:$N$135,2,FALSE)*G11)+1.25),IF(D11=\"do\",(HLOOKUP(E11,Tarifs!$C$139:$K$141,2,FALSE)*G11),IF(D11=\"fob\",((HLOOKUP(E11,Tarifs!C147:K149,2,FALSE)*G11)+1.25))))))))))))))))*C11)","v":""},null,null,null,2.2000000000000002,1.4,1.03]
[null,null,null,null,null,null,"",{"$f":"IF(C12=\"\",\"\",IF(D12=\"C2\",(HLOOKUP(E12,Tarifs!$C$13:$AG$15,2,FALSE)*G12),IF(D12=\"C3\",(HLOOKUP(E12,Tarifs!$C$37:$AI$39,2,FALSE)*G12),IF(D12=\"f\",(HLOOKUP(E12,Tarifs!$C$56:$Z$59,2,FALSE)*G12),IF(D12=\"ft\",(HLOOKUP(E12,Tarifs!$C$69:$Z$72,2,FALSE)*G12),IF(D12=\"c4\",(HLOOKUP(E12,Tarifs!$C$82:$AV$85,2,FALSE)*G12),IF(D12=\"p\",(HLOOKUP(E12,Tarifs!$C$107:$H$109,2,FALSE)*G12),IF(D12=\"p2\",(HLOOKUP(E12,Tarifs!$C$115:$N$117,2,FALSE)*G12),IF(D12=\"f tra\",((HLOOKUP(E12,Tarifs!$C$56:$Z$59,2,FALSE)*G12)*1.2),IF(D12=\"ft RI\",((HLOOKUP(E12,Tarifs!$C$69:$Z$72,2,FALSE)*G12)*1.4),IF(D12=\"f RI\",((HLOOKUP(E12,Tarifs!$C$56:$Z$59,2,FALSE)*G12)*1.4),IF(D12=\"ft TRA\",((HLOOKUP(E12,Tarifs!$C$69:$Z$72,2,FALSE)*G12)*1.2),IF(D12=\"o\",(HLOOKUP(E12,Tarifs!$C$133:$N$135,2,FALSE)*G12),IF(D12=\"cob\",((HLOOKUP(E12,Tarifs!$C$133:$N$135,2,FALSE)*G12)+1.25),IF(D12=\"do\",(HLOOKUP(E12,Tarifs!$C$139:$K$141,2,FALSE)*G12),IF(D12=\"fob\",((HLOOKUP(E12,Tarifs!C148:K150,2,FALSE)*G12)+1.25))))))))))))))))*C12)","v":""},null,null,null,2.1,1.3,1]
[null,null,null,null,null,null,"",{"$f":"IF(C13=\"\",\"\",IF(D13=\"C2\",(HLOOKUP(E13,Tarifs!$C$13:$AG$15,2,FALSE)*G13),IF(D13=\"C3\",(HLOOKUP(E13,Tarifs!$C$37:$AI$39,2,FALSE)*G13),IF(D13=\"f\",(HLOOKUP(E13,Tarifs!$C$56:$Z$59,2,FALSE)*G13),IF(D13=\"ft\",(HLOOKUP(E13,Tarifs!$C$69:$Z$72,2,FALSE)*G13),IF(D13=\"c4\",(HLOOKUP(E13,Tarifs!$C$82:$AV$85,2,FALSE)*G13),IF(D13=\"p\",(HLOOKUP(E13,Tarifs!$C$107:$H$109,2,FALSE)*G13),IF(D13=\"p2\",(HLOOKUP(E13,Tarifs!$C$115:$N$117,2,FALSE)*G13),IF(D13=\"f tra\",((HLOOKUP(E13,Tarifs!$C$56:$Z$59,2,FALSE)*G13)*1.2),IF(D13=\"ft RI\",((HLOOKUP(E13,Tarifs!$C$69:$Z$72,2,FALSE)*G13)*1.4),IF(D13=\"f RI\",((HLOOKUP(E13,Tarifs!$C$56:$Z$59,2,FALSE)*G13)*1.4),IF(D13=\"ft TRA\",((HLOOKUP(E13,Tarifs!$C$69:$Z$72,2,FALSE)*G13)*1.2),IF(D13=\"o\",(HLOOKUP(E13,Tarifs!$C$133:$N$135,2,FALSE)*G13),IF(D13=\"cob\",((HLOOKUP(E13,Tarifs!$C$133:$N$135,2,FALSE)*G13)+1.25),IF(D13=\"do\",(HLOOKUP(E13,Tarifs!$C$139:$K$141,2,FALSE)*G13),IF(D13=\"fob\",((HLOOKUP(E13,C1:L3,2,FALSE)*G13)+1.25))))))))))))))))*C13)","v":""},null,null,null,2,1.2,0.97]
[null,null,null,null,null,null,"",{"$f":"IF(C14=\"\",\"\",IF(D14=\"C2\",(HLOOKUP(E14,Tarifs!$C$13:$AG$15,2,FALSE)*G14),IF(D14=\"C3\",(HLOOKUP(E14,Tarifs!$C$37:$AI$39,2,FALSE)*G14),IF(D14=\"f\",(HLOOKUP(E14,Tarifs!$C$56:$Z$59,2,FALSE)*G14),IF(D14=\"ft\",(HLOOKUP(E14,Tarifs!$C$69:$Z$72,2,FALSE)*G14),IF(D14=\"c4\",(HLOOKUP(E14,Tarifs!$C$82:$AV$85,2,FALSE)*G14),IF(D14=\"p\",(HLOOKUP(E14,Tarifs!$C$107:$H$109,2,FALSE)*G14),IF(D14=\"p2\",(HLOOKUP(E14,Tarifs!$C$115:$N$117,2,FALSE)*G14),IF(D14=\"f tra\",((HLOOKUP(E14,Tarifs!$C$56:$Z$59,2,FALSE)*G14)*1.2),IF(D14=\"ft RI\",((HLOOKUP(E14,Tarifs!$C$69:$Z$72,2,FALSE)*G14)*1.4),IF(D14=\"f RI\",((HLOOKUP(E14,Tarifs!$C$56:$Z$59,2,FALSE)*G14)*1.4),IF(D14=\"ft TRA\",((HLOOKUP(E14,Tarifs!$C$69:$Z$72,2,FALSE)*G14)*1.2),IF(D14=\"o\",(HLOOKUP(E14,Tarifs!$C$133:$N$135,2,FALSE)*G14),IF(D14=\"cob\",((HLOOKUP(E14,Tarifs!$C$133:$N$135,2,FALSE)*G14)+1.25),IF(D14=\"do\",(HLOOKUP(E14,Tarifs!$C$139:$K$141,2,FALSE)*G14),IF(D14=\"fob\",((HLOOKUP(E14,C2:L4,2,FALSE)*G14)+1.25))))))))))))))))*C14)","v":""},null,null,null,1.9,1.1000000000000001,0.94]
[null,null,null,null,null,null,"",{"$f":"IF(C15=\"\",\"\",IF(D15=\"C2\",(HLOOKUP(E15,Tarifs!$C$13:$AG$15,2,FALSE)*G15),IF(D15=\"C3\",(HLOOKUP(E15,Tarifs!$C$37:$AI$39,2,FALSE)*G15),IF(D15=\"f\",(HLOOKUP(E15,Tarifs!$C$56:$Z$59,2,FALSE)*G15),IF(D15=\"ft\",(HLOOKUP(E15,Tarifs!$C$69:$Z$72,2,FALSE)*G15),IF(D15=\"c4\",(HLOOKUP(E15,Tarifs!$C$82:$AV$85,2,FALSE)*G15),IF(D15=\"p\",(HLOOKUP(E15,Tarifs!$C$107:$H$109,2,FALSE)*G15),IF(D15=\"p2\",(HLOOKUP(E15,Tarifs!$C$115:$N$117,2,FALSE)*G15),IF(D15=\"f tra\",((HLOOKUP(E15,Tarifs!$C$56:$Z$59,2,FALSE)*G15)*1.2),IF(D15=\"ft RI\",((HLOOKUP(E15,Tarifs!$C$69:$Z$72,2,FALSE)*G15)*1.4),IF(D15=\"f RI\",((HLOOKUP(E15,Tarifs!$C$56:$Z$59,2,FALSE)*G15)*1.4),IF(D15=\"ft TRA\",((HLOOKUP(E15,Tarifs!$C$69:$Z$72,2,FALSE)*G15)*1.2),IF(D15=\"o\",(HLOOKUP(E15,Tarifs!$C$133:$N$135,2,FALSE)*G15),IF(D15=\"cob\",((HLOOKUP(E15,Tarifs!$C$133:$N$135,2,FALSE)*G15)+1.25),IF(D15=\"do\",(HLOOKUP(E15,Tarifs!$C$139:$K$141,2,FALSE)*G15),IF(D15=\"fob\",((HLOOKUP(E15,C3:L5,2,FALSE)*G15)+1.25))))))))))))))))*C15)","v":""},null,null,null,1.8,1,0.91]
["REEL",null,null,null,null,null,"",null,{"$f":"IF(C16=\"\",\"\",IF(D16=\"C2\",(HLOOKUP(E16,Tarifs!$C$13:$AG$15,3,FALSE)*G16),IF(D16=\"C3\",(HLOOKUP(E16,Tarifs!$C$37:$AI$39,3,FALSE)*G16),IF(D16=\"f\",(HLOOKUP(E16,Tarifs!$C$56:$Z$59,3,FALSE)*G16),IF(D16=\"ft\",(HLOOKUP(E16,Tarifs!$C$69:$Z$72,3,FALSE)*G16),IF(D16=\"c4\",(HLOOKUP(E16,Tarifs!$C$82:$AV$85,3,FALSE)*G16),IF(D16=\"p\",(HLOOKUP(E16,Tarifs!$C$107:$H$109,3,FALSE)*G16),IF(D16=\"p2\",(HLOOKUP(E16,Tarifs!$C$115:$N$117,3,FALSE)*G16),IF(D16=\"f tra\",((HLOOKUP(E16,Tarifs!$C$56:$Z$59,3,FALSE)*G16)*1.2),IF(D16=\"ft RI\",((HLOOKUP(E16,Tarifs!$C$69:$Z$72,3,FALSE)*G16)*1.4),IF(D16=\"f ri\",((HLOOKUP(E16,Tarifs!$C$56:$Z$59,3,FALSE)*G16)*1.4),IF(D16=\"ft TRA\",((HLOOKUP(E16,Tarifs!$C$69:$Z$72,3,FALSE)*G16)*1.2),IF(D16=\"o\",(HLOOKUP(E16,Tarifs!$C$133:$N$135,3,FALSE)*G16),IF(D16=\"cob\",((HLOOKUP(E16,Tarifs!$C$133:$N$135,3,FALSE)*G16)+1.25),IF(D16=\"do\",(HLOOKUP(E16,Tarifs!$C$139:$K$141,3,FALSE)*G16),IF(D16=\"fob\",((HLOOKUP(E16,Tarifs!$C$139:$K$141,3,FALSE)*G16)+1.25),\"\")))))))))))))))*C16)","v":""},null,null,1.7,0.9,0.88]
[null,null,null,null,null,null,"",null,{"$f":"IF(C17=\"\",\"\",IF(D17=\"C2\",(HLOOKUP(E17,Tarifs!$C$13:$AG$15,3,FALSE)*G17),IF(D17=\"C3\",(HLOOKUP(E17,Tarifs!$C$37:$AI$39,3,FALSE)*G17),IF(D17=\"f\",(HLOOKUP(E17,Tarifs!$C$56:$Z$59,3,FALSE)*G17),IF(D17=\"ft\",(HLOOKUP(E17,Tarifs!$C$69:$Z$72,3,FALSE)*G17),IF(D17=\"c4\",(HLOOKUP(E17,Tarifs!$C$82:$AV$85,3,FALSE)*G17),IF(D17=\"p\",(HLOOKUP(E17,Tarifs!$C$107:$H$109,3,FALSE)*G17),IF(D17=\"p2\",(HLOOKUP(E17,Tarifs!$C$115:$N$117,3,FALSE)*G17),IF(D17=\"f tra\",((HLOOKUP(E17,Tarifs!$C$56:$Z$59,3,FALSE)*G17)*1.2),IF(D17=\"ft RI\",((HLOOKUP(E17,Tarifs!$C$69:$Z$72,3,FALSE)*G17)*1.4),IF(D17=\"f ri\",((HLOOKUP(E17,Tarifs!$C$56:$Z$59,3,FALSE)*G17)*1.4),IF(D17=\"ft TRA\",((HLOOKUP(E17,Tarifs!$C$69:$Z$72,3,FALSE)*G17)*1.2),IF(D17=\"o\",(HLOOKUP(E17,Tarifs!$C$133:$N$135,3,FALSE)*G17),IF(D17=\"cob\",((HLOOKUP(E17,Tarifs!$C$133:$N$135,3,FALSE)*G17)+1.25),IF(D17=\"do\",(HLOOKUP(E17,Tarifs!$C$139:$K$141,3,FALSE)*G17),IF(D17=\"fob\",((HLOOKUP(E17,Tarifs!$C$139:$K$141,3,FALSE)*G17)+1.25),\"\")))))))))))))))*C17)","v":""},null,null,1.6,0.8,0.85]
[null,null,null,null,null,null,"",null,{"$f":"IF(C18=\"\",\"\",IF(D18=\"C2\",(HLOOKUP(E18,Tarifs!$C$13:$AG$15,3,FALSE)*G18),IF(D18=\"C3\",(HLOOKUP(E18,Tarifs!$C$37:$AI$39,3,FALSE)*G18),IF(D18=\"f\",(HLOOKUP(E18,Tarifs!$C$56:$Z$59,3,FALSE)*G18),IF(D18=\"ft\",(HLOOKUP(E18,Tarifs!$C$69:$Z$72,3,FALSE)*G18),IF(D18=\"c4\",(HLOOKUP(E18,Tarifs!$C$82:$AV$85,3,FALSE)*G18),IF(D18=\"p\",(HLOOKUP(E18,Tarifs!$C$107:$H$109,3,FALSE)*G18),IF(D18=\"p2\",(HLOOKUP(E18,Tarifs!$C$115:$N$117,3,FALSE)*G18),IF(D18=\"f tra\",((HLOOKUP(E18,Tarifs!$C$56:$Z$59,3,FALSE)*G18)*1.2),IF(D18=\"ft RI\",((HLOOKUP(E18,Tarifs!$C$69:$Z$72,3,FALSE)*G18)*1.4),IF(D18=\"f ri\",((HLOOKUP(E18,Tarifs!$C$56:$Z$59,3,FALSE)*G18)*1.4),IF(D18=\"ft TRA\",((HLOOKUP(E18,Tarifs!$C$69:$Z$72,3,FALSE)*G18)*1.2),IF(D18=\"o\",(HLOOKUP(E18,Tarifs!$C$133:$N$135,3,FALSE)*G18),IF(D18=\"cob\",((HLOOKUP(E18,Tarifs!$C$133:$N$135,3,FALSE)*G18)+1.25),IF(D18=\"do\",(HLOOKUP(E18,Tarifs!$C$139:$K$141,3,FALSE)*G18),IF(D18=\"fob\",((HLOOKUP(E18,Tarifs!$C$139:$K$141,3,FALSE)*G18)+1.25),\"\")))))))))))))))*C18)","v":""},null,null,1.5,0.69999999999999896,0.82]
[null,null,null,null,null,null,"",null,{"$f":"IF(C19=\"\",\"\",IF(D19=\"C2\",(HLOOKUP(E19,Tarifs!$C$13:$AG$15,3,FALSE)*G19),IF(D19=\"C3\",(HLOOKUP(E19,Tarifs!$C$37:$AI$39,3,FALSE)*G19),IF(D19=\"f\",(HLOOKUP(E19,Tarifs!$C$56:$Z$59,3,FALSE)*G19),IF(D19=\"ft\",(HLOOKUP(E19,Tarifs!$C$69:$Z$72,3,FALSE)*G19),IF(D19=\"c4\",(HLOOKUP(E19,Tarifs!$C$82:$AV$85,3,FALSE)*G19),IF(D19=\"p\",(HLOOKUP(E19,Tarifs!$C$107:$H$109,3,FALSE)*G19),IF(D19=\"p2\",(HLOOKUP(E19,Tarifs!$C$115:$N$117,3,FALSE)*G19),IF(D19=\"f tra\",((HLOOKUP(E19,Tarifs!$C$56:$Z$59,3,FALSE)*G19)*1.2),IF(D19=\"ft RI\",((HLOOKUP(E19,Tarifs!$C$69:$Z$72,3,FALSE)*G19)*1.4),IF(D19=\"f ri\",((HLOOKUP(E19,Tarifs!$C$56:$Z$59,3,FALSE)*G19)*1.4),IF(D19=\"ft TRA\",((HLOOKUP(E19,Tarifs!$C$69:$Z$72,3,FALSE)*G19)*1.2),IF(D19=\"o\",(HLOOKUP(E19,Tarifs!$C$133:$N$135,3,FALSE)*G19),IF(D19=\"cob\",((HLOOKUP(E19,Tarifs!$C$133:$N$135,3,FALSE)*G19)+1.25),IF(D19=\"do\",(HLOOKUP(E19,Tarifs!$C$139:$K$141,3,FALSE)*G19),IF(D19=\"fob\",((HLOOKUP(E19,Tarifs!$C$139:$K$141,3,FALSE)*G19)+1.25),\"\")))))))))))))))*C19)","v":""},null,null,1.4,0.59999999999999898,0.79]
[null,null,null,null,null,null,"",null,{"$f":"IF(C20=\"\",\"\",IF(D20=\"C2\",(HLOOKUP(E20,Tarifs!$C$13:$AG$15,3,FALSE)*G20),IF(D20=\"C3\",(HLOOKUP(E20,Tarifs!$C$37:$AI$39,3,FALSE)*G20),IF(D20=\"f\",(HLOOKUP(E20,Tarifs!$C$56:$Z$59,3,FALSE)*G20),IF(D20=\"ft\",(HLOOKUP(E20,Tarifs!$C$69:$Z$72,3,FALSE)*G20),IF(D20=\"c4\",(HLOOKUP(E20,Tarifs!$C$82:$AV$85,3,FALSE)*G20),IF(D20=\"p\",(HLOOKUP(E20,Tarifs!$C$107:$H$109,3,FALSE)*G20),IF(D20=\"p2\",(HLOOKUP(E20,Tarifs!$C$115:$N$117,3,FALSE)*G20),IF(D20=\"f tra\",((HLOOKUP(E20,Tarifs!$C$56:$Z$59,3,FALSE)*G20)*1.2),IF(D20=\"ft RI\",((HLOOKUP(E20,Tarifs!$C$69:$Z$72,3,FALSE)*G20)*1.4),IF(D20=\"f ri\",((HLOOKUP(E20,Tarifs!$C$56:$Z$59,3,FALSE)*G20)*1.4),IF(D20=\"ft TRA\",((HLOOKUP(E20,Tarifs!$C$69:$Z$72,3,FALSE)*G20)*1.2),IF(D20=\"o\",(HLOOKUP(E20,Tarifs!$C$133:$N$135,3,FALSE)*G20),IF(D20=\"cob\",((HLOOKUP(E20,Tarifs!$C$133:$N$135,3,FALSE)*G20)+1.25),IF(D20=\"do\",(HLOOKUP(E20,Tarifs!$C$139:$K$141,3,FALSE)*G20),IF(D20=\"fob\",((HLOOKUP(E20,Tarifs!$C$139:$K$141,3,FALSE)*G20)+1.25),\"\")))))))))))))))*C20)","v":""},null,null,1.3,0.5,0.76]
[null,null,null,null,null,null,"",null,{"$f":"IF(C21=\"\",\"\",IF(D21=\"C2\",(HLOOKUP(E21,Tarifs!$C$13:$AG$15,3,FALSE)*G21),IF(D21=\"C3\",(HLOOKUP(E21,Tarifs!$C$37:$AI$39,3,FALSE)*G21),IF(D21=\"f\",(HLOOKUP(E21,Tarifs!$C$56:$Z$59,3,FALSE)*G21),IF(D21=\"ft\",(HLOOKUP(E21,Tarifs!$C$69:$Z$72,3,FALSE)*G21),IF(D21=\"c4\",(HLOOKUP(E21,Tarifs!$C$82:$AV$85,3,FALSE)*G21),IF(D21=\"p\",(HLOOKUP(E21,Tarifs!$C$107:$H$109,3,FALSE)*G21),IF(D21=\"p2\",(HLOOKUP(E21,Tarifs!$C$115:$N$117,3,FALSE)*G21),IF(D21=\"f tra\",((HLOOKUP(E21,Tarifs!$C$56:$Z$59,3,FALSE)*G21)*1.2),IF(D21=\"ft RI\",((HLOOKUP(E21,Tarifs!$C$69:$Z$72,3,FALSE)*G21)*1.4),IF(D21=\"f ri\",((HLOOKUP(E21,Tarifs!$C$56:$Z$59,3,FALSE)*G21)*1.4),IF(D21=\"ft TRA\",((HLOOKUP(E21,Tarifs!$C$69:$Z$72,3,FALSE)*G21)*1.2),IF(D21=\"o\",(HLOOKUP(E21,Tarifs!$C$133:$N$135,3,FALSE)*G21),IF(D21=\"cob\",((HLOOKUP(E21,Tarifs!$C$133:$N$135,3,FALSE)*G21)+1.25),IF(D21=\"do\",(HLOOKUP(E21,Tarifs!$C$139:$K$141,3,FALSE)*G21),IF(D21=\"fob\",((HLOOKUP(E21,Tarifs!$C$139:$K$141,3,FALSE)*G21)+1.25),\"\")))))))))))))))*C21)","v":""},null,null,1.2,0.39999999999999902,0.73]
[null,null,null,null,null,null,"",null,{"$f":"IF(C22=\"\",\"\",IF(D22=\"C2\",(HLOOKUP(E22,Tarifs!$C$13:$AG$15,3,FALSE)*G22),IF(D22=\"C3\",(HLOOKUP(E22,Tarifs!$C$37:$AI$39,3,FALSE)*G22),IF(D22=\"f\",(HLOOKUP(E22,Tarifs!$C$56:$Z$59,3,FALSE)*G22),IF(D22=\"ft\",(HLOOKUP(E22,Tarifs!$C$69:$Z$72,3,FALSE)*G22),IF(D22=\"c4\",(HLOOKUP(E22,Tarifs!$C$82:$AV$85,3,FALSE)*G22),IF(D22=\"p\",(HLOOKUP(E22,Tarifs!$C$107:$H$109,3,FALSE)*G22),IF(D22=\"p2\",(HLOOKUP(E22,Tarifs!$C$115:$N$117,3,FALSE)*G22),IF(D22=\"f tra\",((HLOOKUP(E22,Tarifs!$C$56:$Z$59,3,FALSE)*G22)*1.2),IF(D22=\"ft RI\",((HLOOKUP(E22,Tarifs!$C$69:$Z$72,3,FALSE)*G22)*1.4),IF(D22=\"f ri\",((HLOOKUP(E22,Tarifs!$C$56:$Z$59,3,FALSE)*G22)*1.4),IF(D22=\"ft TRA\",((HLOOKUP(E22,Tarifs!$C$69:$Z$72,3,FALSE)*G22)*1.2),IF(D22=\"o\",(HLOOKUP(E22,Tarifs!$C$133:$N$135,3,FALSE)*G22),IF(D22=\"cob\",((HLOOKUP(E22,Tarifs!$C$133:$N$135,3,FALSE)*G22)+1.25),IF(D22=\"do\",(HLOOKUP(E22,Tarifs!$C$139:$K$141,3,FALSE)*G22),IF(D22=\"fob\",((HLOOKUP(E22,Tarifs!$C$139:$K$141,3,FALSE)*G22)+1.25),\"\")))))))))))))))*C22)","v":""},null,null,1.1000000000000001,0.3,0.7]
[null,null,null,null,null,null,"",null,{"$f":"IF(C23=\"\",\"\",IF(D23=\"C2\",(HLOOKUP(E23,Tarifs!$C$13:$AG$15,3,FALSE)*G23),IF(D23=\"C3\",(HLOOKUP(E23,Tarifs!$C$37:$AI$39,3,FALSE)*G23),IF(D23=\"f\",(HLOOKUP(E23,Tarifs!$C$56:$Z$59,3,FALSE)*G23),IF(D23=\"ft\",(HLOOKUP(E23,Tarifs!$C$69:$Z$72,3,FALSE)*G23),IF(D23=\"c4\",(HLOOKUP(E23,Tarifs!$C$82:$AV$85,3,FALSE)*G23),IF(D23=\"p\",(HLOOKUP(E23,Tarifs!$C$107:$H$109,3,FALSE)*G23),IF(D23=\"p2\",(HLOOKUP(E23,Tarifs!$C$115:$N$117,3,FALSE)*G23),IF(D23=\"f tra\",((HLOOKUP(E23,Tarifs!$C$56:$Z$59,3,FALSE)*G23)*1.2),IF(D23=\"ft RI\",((HLOOKUP(E23,Tarifs!$C$69:$Z$72,3,FALSE)*G23)*1.4),IF(D23=\"f ri\",((HLOOKUP(E23,Tarifs!$C$56:$Z$59,3,FALSE)*G23)*1.4),IF(D23=\"ft TRA\",((HLOOKUP(E23,Tarifs!$C$69:$Z$72,3,FALSE)*G23)*1.2),IF(D23=\"o\",(HLOOKUP(E23,Tarifs!$C$133:$N$135,3,FALSE)*G23),IF(D23=\"cob\",((HLOOKUP(E23,Tarifs!$C$133:$N$135,3,FALSE)*G23)+1.25),IF(D23=\"do\",(HLOOKUP(E23,Tarifs!$C$139:$K$141,3,FALSE)*G23),IF(D23=\"fob\",((HLOOKUP(E23,Tarifs!$C$139:$K$141,3,FALSE)*G23)+1.25),\"\")))))))))))))))*C23)","v":""},null,null,1,null,0.67]
[null,null,null,null,null,null,"",null,{"$f":"IF(C24=\"\",\"\",IF(D24=\"C2\",(HLOOKUP(E24,Tarifs!$C$13:$AG$15,3,FALSE)*G24),IF(D24=\"C3\",(HLOOKUP(E24,Tarifs!$C$37:$AI$39,3,FALSE)*G24),IF(D24=\"f\",(HLOOKUP(E24,Tarifs!$C$56:$Z$59,3,FALSE)*G24),IF(D24=\"ft\",(HLOOKUP(E24,Tarifs!$C$69:$Z$72,3,FALSE)*G24),IF(D24=\"c4\",(HLOOKUP(E24,Tarifs!$C$82:$AV$85,3,FALSE)*G24),IF(D24=\"p\",(HLOOKUP(E24,Tarifs!$C$107:$H$109,3,FALSE)*G24),IF(D24=\"p2\",(HLOOKUP(E24,Tarifs!$C$115:$N$117,3,FALSE)*G24),IF(D24=\"f tra\",((HLOOKUP(E24,Tarifs!$C$56:$Z$59,3,FALSE)*G24)*1.2),IF(D24=\"ft RI\",((HLOOKUP(E24,Tarifs!$C$69:$Z$72,3,FALSE)*G24)*1.4),IF(D24=\"f ri\",((HLOOKUP(E24,Tarifs!$C$56:$Z$59,3,FALSE)*G24)*1.4),IF(D24=\"ft TRA\",((HLOOKUP(E24,Tarifs!$C$69:$Z$72,3,FALSE)*G24)*1.2),IF(D24=\"o\",(HLOOKUP(E24,Tarifs!$C$133:$N$135,3,FALSE)*G24),IF(D24=\"cob\",((HLOOKUP(E24,Tarifs!$C$133:$N$135,3,FALSE)*G24)+1.25),IF(D24=\"do\",(HLOOKUP(E24,Tarifs!$C$139:$K$141,3,FALSE)*G24),IF(D24=\"fob\",((HLOOKUP(E24,Tarifs!$C$139:$K$141,3,FALSE)*G24)+1.25),\"\")))))))))))))))*C24)","v":""},null,null,0.9,null,0.64]
[null,null,null,null,null,null,"",null,{"$f":"IF(C25=\"\",\"\",IF(D25=\"C2\",(HLOOKUP(E25,Tarifs!$C$13:$AG$15,3,FALSE)*G25),IF(D25=\"C3\",(HLOOKUP(E25,Tarifs!$C$37:$AI$39,3,FALSE)*G25),IF(D25=\"f\",(HLOOKUP(E25,Tarifs!$C$56:$Z$59,3,FALSE)*G25),IF(D25=\"ft\",(HLOOKUP(E25,Tarifs!$C$69:$Z$72,3,FALSE)*G25),IF(D25=\"c4\",(HLOOKUP(E25,Tarifs!$C$82:$AV$85,3,FALSE)*G25),IF(D25=\"p\",(HLOOKUP(E25,Tarifs!$C$107:$H$109,3,FALSE)*G25),IF(D25=\"p2\",(HLOOKUP(E25,Tarifs!$C$115:$N$117,3,FALSE)*G25),IF(D25=\"f tra\",((HLOOKUP(E25,Tarifs!$C$56:$Z$59,3,FALSE)*G25)*1.2),IF(D25=\"ft RI\",((HLOOKUP(E25,Tarifs!$C$69:$Z$72,3,FALSE)*G25)*1.4),IF(D25=\"f ri\",((HLOOKUP(E25,Tarifs!$C$56:$Z$59,3,FALSE)*G25)*1.4),IF(D25=\"ft TRA\",((HLOOKUP(E25,Tarifs!$C$69:$Z$72,3,FALSE)*G25)*1.2),IF(D25=\"o\",(HLOOKUP(E25,Tarifs!$C$133:$N$135,3,FALSE)*G25),IF(D25=\"cob\",((HLOOKUP(E25,Tarifs!$C$133:$N$135,3,FALSE)*G25)+1.25),IF(D25=\"do\",(HLOOKUP(E25,Tarifs!$C$139:$K$141,3,FALSE)*G25),IF(D25=\"fob\",((HLOOKUP(E25,Tarifs!$C$139:$K$141,3,FALSE)*G25)+1.25),\"\")))))))))))))))*C25)","v":""},null,null,0.8,null,0.61]
[null,null,null,null,null,null,"",null,{"$f":"IF(C26=\"\",\"\",IF(D26=\"C2\",(HLOOKUP(E26,Tarifs!$C$13:$AG$15,3,FALSE)*G26),IF(D26=\"C3\",(HLOOKUP(E26,Tarifs!$C$37:$AI$39,3,FALSE)*G26),IF(D26=\"f\",(HLOOKUP(E26,Tarifs!$C$56:$Z$59,3,FALSE)*G26),IF(D26=\"ft\",(HLOOKUP(E26,Tarifs!$C$69:$Z$72,3,FALSE)*G26),IF(D26=\"c4\",(HLOOKUP(E26,Tarifs!$C$82:$AV$85,3,FALSE)*G26),IF(D26=\"p\",(HLOOKUP(E26,Tarifs!$C$107:$H$109,3,FALSE)*G26),IF(D26=\"p2\",(HLOOKUP(E26,Tarifs!$C$115:$N$117,3,FALSE)*G26),IF(D26=\"f tra\",((HLOOKUP(E26,Tarifs!$C$56:$Z$59,3,FALSE)*G26)*1.2),IF(D26=\"ft RI\",((HLOOKUP(E26,Tarifs!$C$69:$Z$72,3,FALSE)*G26)*1.4),IF(D26=\"f ri\",((HLOOKUP(E26,Tarifs!$C$56:$Z$59,3,FALSE)*G26)*1.4),IF(D26=\"ft TRA\",((HLOOKUP(E26,Tarifs!$C$69:$Z$72,3,FALSE)*G26)*1.2),IF(D26=\"o\",(HLOOKUP(E26,Tarifs!$C$133:$N$135,3,FALSE)*G26),IF(D26=\"cob\",((HLOOKUP(E26,Tarifs!$C$133:$N$135,3,FALSE)*G26)+1.25),IF(D26=\"do\",(HLOOKUP(E26,Tarifs!$C$139:$K$141,3,FALSE)*G26),IF(D26=\"fob\",((HLOOKUP(E26,Tarifs!$C$139:$K$141,3,FALSE)*G26)+1.25),\"\")))))))))))))))*C26)","v":""},null,null,0.7,null,0.57999999999999996]
[null,null,null,null,null,null,"",null,{"$f":"IF(C27=\"\",\"\",IF(D27=\"C2\",(HLOOKUP(E27,Tarifs!$C$13:$AG$15,3,FALSE)*G27),IF(D27=\"C3\",(HLOOKUP(E27,Tarifs!$C$37:$AI$39,3,FALSE)*G27),IF(D27=\"f\",(HLOOKUP(E27,Tarifs!$C$56:$Z$59,3,FALSE)*G27),IF(D27=\"ft\",(HLOOKUP(E27,Tarifs!$C$69:$Z$72,3,FALSE)*G27),IF(D27=\"c4\",(HLOOKUP(E27,Tarifs!$C$82:$AV$85,3,FALSE)*G27),IF(D27=\"p\",(HLOOKUP(E27,Tarifs!$C$107:$H$109,3,FALSE)*G27),IF(D27=\"p2\",(HLOOKUP(E27,Tarifs!$C$115:$N$117,3,FALSE)*G27),IF(D27=\"f tra\",((HLOOKUP(E27,Tarifs!$C$56:$Z$59,3,FALSE)*G27)*1.2),IF(D27=\"ft RI\",((HLOOKUP(E27,Tarifs!$C$69:$Z$72,3,FALSE)*G27)*1.4),IF(D27=\"f ri\",((HLOOKUP(E27,Tarifs!$C$56:$Z$59,3,FALSE)*G27)*1.4),IF(D27=\"ft TRA\",((HLOOKUP(E27,Tarifs!$C$69:$Z$72,3,FALSE)*G27)*1.2),IF(D27=\"o\",(HLOOKUP(E27,Tarifs!$C$133:$N$135,3,FALSE)*G27),IF(D27=\"cob\",((HLOOKUP(E27,Tarifs!$C$133:$N$135,3,FALSE)*G27)+1.25),IF(D27=\"do\",(HLOOKUP(E27,Tarifs!$C$139:$K$141,3,FALSE)*G27),IF(D27=\"fob\",((HLOOKUP(E27,Tarifs!$C$139:$K$141,3,FALSE)*G27)+1.25),\"\")))))))))))*C27)))))","v":""},null,null,0.6,null,0.55000000000000004]
[null,null,null,null,null,null,"",null,{"$f":"IF(C28=\"\",\"\",IF(D28=\"C2\",(HLOOKUP(E28,Tarifs!$C$13:$AG$15,3,FALSE)*G28),IF(D28=\"C3\",(HLOOKUP(E28,Tarifs!$C$37:$AI$39,3,FALSE)*G28),IF(D28=\"f\",(HLOOKUP(E28,Tarifs!$C$56:$Z$59,3,FALSE)*G28),IF(D28=\"ft\",(HLOOKUP(E28,Tarifs!$C$69:$Z$72,3,FALSE)*G28),IF(D28=\"c4\",(HLOOKUP(E28,Tarifs!$C$82:$AV$85,3,FALSE)*G28),IF(D28=\"p\",(HLOOKUP(E28,Tarifs!$C$107:$H$109,3,FALSE)*G28),IF(D28=\"p2\",(HLOOKUP(E28,Tarifs!$C$115:$N$117,3,FALSE)*G28),IF(D28=\"f tra\",((HLOOKUP(E28,Tarifs!$C$56:$Z$59,3,FALSE)*G28)*1.2),IF(D28=\"ft RI\",((HLOOKUP(E28,Tarifs!$C$69:$Z$72,3,FALSE)*G28)*1.4),IF(D28=\"f ri\",((HLOOKUP(E28,Tarifs!$C$56:$Z$59,3,FALSE)*G28)*1.4),IF(D28=\"ft TRA\",((HLOOKUP(E28,Tarifs!$C$69:$Z$72,3,FALSE)*G28)*1.2),IF(D28=\"o\",(HLOOKUP(E28,Tarifs!$C$133:$N$135,3,FALSE)*G28),IF(D28=\"cob\",((HLOOKUP(E28,Tarifs!$C$133:$N$135,3,FALSE)*G28)+1.25),IF(D28=\"do\",(HLOOKUP(E28,Tarifs!$C$139:$K$141,3,FALSE)*G28),IF(D28=\"fob\",((HLOOKUP(E28,Tarifs!$C$139:$K$141,3,FALSE)*G28)+1.25),\"\")))))))))))*C28)))))","v":""},null,null,0.5,null,0.52]
[null,null,null,null,null,null,null,{"$f":"IF(H3=\"\",\"\",SUM(H3:H19))","v":""},{"$f":"IF(H3=\"\",\"\",SUM(I3:I28))","v":""},null,null,0.4,null,0.49]
[null,null,null,null,null,null,null,"DIFF",{"$f":"IF(H29=\"\",\"\",(SUM(I3:I28)-SUM(H3:H28)))","v":""},null,null,0.3,null,0.46]
[null,null,null,null,null,null,null,{"$f":"H29*1.03*190","v":{"$error":"#VALUE!"}}]
["VR - BSO - VRC - BSOC - BSOCM - ZS2"]
[]
["face","qté","type","largeur",null,"hauteur",null,"tarif ht avec RT"]
[null,null,null,null,null,null,null,{"$f":"IF(C35=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI153,Tarifs!BH153)*B35+200*B35,IF(C35=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI153,Tarifs!BH153)*B35+200*B35,IF(C35=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI153,Tarifs!BH153)*B35+200*B35,IF(C35=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI153,Tarifs!BH153)*B35+200*B35,IF(C35=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI153,Tarifs!BH153)*B35+200*B35,IF(C35=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI153,Tarifs!BH153)*B35+200*B35,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C36=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI154,Tarifs!BH154)*B36+200*B36,IF(C36=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI154,Tarifs!BH154)*B36+200*B36,IF(C36=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI154,Tarifs!BH154)*B36+200*B36,IF(C36=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI154,Tarifs!BH154)*B36+200*B36,IF(C36=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI154,Tarifs!BH154)*B36+200*B36,IF(C36=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI154,Tarifs!BH154)*B36+200*B36,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C37=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI155,Tarifs!BH155)*B37+200*B37,IF(C37=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI155,Tarifs!BH155)*B37+200*B37,IF(C37=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI155,Tarifs!BH155)*B37+200*B37,IF(C37=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI155,Tarifs!BH155)*B37+200*B37,IF(C37=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI155,Tarifs!BH155)*B37+200*B37,IF(C37=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI155,Tarifs!BH155)*B37+200*B37,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C38=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI156,Tarifs!BH156)*B38+200*B38,IF(C38=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI156,Tarifs!BH156)*B38+200*B38,IF(C38=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI156,Tarifs!BH156)*B38+200*B38,IF(C38=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI156,Tarifs!BH156)*B38+200*B38,IF(C38=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI156,Tarifs!BH156)*B38+200*B38,IF(C38=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI156,Tarifs!BH156)*B38+200*B38,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C39=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI157,Tarifs!BH157)*B39+200*B39,IF(C39=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI157,Tarifs!BH157)*B39+200*B39,IF(C39=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI157,Tarifs!BH157)*B39+200*B39,IF(C39=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI157,Tarifs!BH157)*B39+200*B39,IF(C39=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI157,Tarifs!BH157)*B39+200*B39,IF(C39=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI157,Tarifs!BH157)*B39+200*B39,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C40=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI158,Tarifs!BH158)*B40+200*B40,IF(C40=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI158,Tarifs!BH158)*B40+200*B40,IF(C40=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI158,Tarifs!BH158)*B40+200*B40,IF(C40=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI158,Tarifs!BH158)*B40+200*B40,IF(C40=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI158,Tarifs!BH158)*B40+200*B40,IF(C40=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI158,Tarifs!BH158)*B40+200*B40,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C41=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI159,Tarifs!BH159)*B41+200*B41,IF(C41=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI159,Tarifs!BH159)*B41+200*B41,IF(C41=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI159,Tarifs!BH159)*B41+200*B41,IF(C41=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI159,Tarifs!BH159)*B41+200*B41,IF(C41=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI159,Tarifs!BH159)*B41+200*B41,IF(C41=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI159,Tarifs!BH159)*B41+200*B41,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C42=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI160,Tarifs!BH160)*B42+200*B42,IF(C42=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI160,Tarifs!BH160)*B42+200*B42,IF(C42=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI160,Tarifs!BH160)*B42+200*B42,IF(C42=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI160,Tarifs!BH160)*B42+200*B42,IF(C42=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI160,Tarifs!BH160)*B42+200*B42,IF(C42=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI160,Tarifs!BH160)*B42+200*B42,\"\"))))))","v":""},null,{"$f":"IF(H35=\"\",\"\",SUM(H35:I42))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C43=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI161,Tarifs!BH161)*B43+200*B43,IF(C43=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI161,Tarifs!BH161)*B43+200*B43,IF(C43=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI161,Tarifs!BH161)*B43+200*B43,IF(C43=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI161,Tarifs!BH161)*B43+200*B43,IF(C43=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI161,Tarifs!BH161)*B43+200*B43,IF(C43=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI161,Tarifs!BH161)*B43+200*B43,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C44=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI162,Tarifs!BH162)*B44+200*B44,IF(C44=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI162,Tarifs!BH162)*B44+200*B44,IF(C44=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI162,Tarifs!BH162)*B44+200*B44,IF(C44=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI162,Tarifs!BH162)*B44+200*B44,IF(C44=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI162,Tarifs!BH162)*B44+200*B44,IF(C44=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI162,Tarifs!BH162)*B44+200*B44,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C45=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI163,Tarifs!BH163)*B45+200*B45,IF(C45=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI163,Tarifs!BH163)*B45+200*B45,IF(C45=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI163,Tarifs!BH163)*B45+200*B45,IF(C45=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI163,Tarifs!BH163)*B45+200*B45,IF(C45=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI163,Tarifs!BH163)*B45+200*B45,IF(C45=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI163,Tarifs!BH163)*B45+200*B45,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C46=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI164,Tarifs!BH164)*B46+200*B46,IF(C46=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI164,Tarifs!BH164)*B46+200*B46,IF(C46=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI164,Tarifs!BH164)*B46+200*B46,IF(C46=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI164,Tarifs!BH164)*B46+200*B46,IF(C46=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI164,Tarifs!BH164)*B46+200*B46,IF(C46=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI164,Tarifs!BH164)*B46+200*B46,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C47=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI165,Tarifs!BH165)*B47+200*B47,IF(C47=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI165,Tarifs!BH165)*B47+200*B47,IF(C47=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI165,Tarifs!BH165)*B47+200*B47,IF(C47=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI165,Tarifs!BH165)*B47+200*B47,IF(C47=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI165,Tarifs!BH165)*B47+200*B47,IF(C47=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI165,Tarifs!BH165)*B47+200*B47,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C48=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI166,Tarifs!BH166)*B48+200*B48,IF(C48=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI166,Tarifs!BH166)*B48+200*B48,IF(C48=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI166,Tarifs!BH166)*B48+200*B48,IF(C48=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI166,Tarifs!BH166)*B48+200*B48,IF(C48=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI166,Tarifs!BH166)*B48+200*B48,IF(C48=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI166,Tarifs!BH166)*B48+200*B48,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C49=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI167,Tarifs!BH167)*B49+200*B49,IF(C49=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI167,Tarifs!BH167)*B49+200*B49,IF(C49=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI167,Tarifs!BH167)*B49+200*B49,IF(C49=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI167,Tarifs!BH167)*B49+200*B49,IF(C49=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI167,Tarifs!BH167)*B49+200*B49,IF(C49=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI167,Tarifs!BH167)*B49+200*B49,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C50=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI168,Tarifs!BH168)*B50+200*B50,IF(C50=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI168,Tarifs!BH168)*B50+200*B50,IF(C50=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI168,Tarifs!BH168)*B50+200*B50,IF(C50=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI168,Tarifs!BH168)*B50+200*B50,IF(C50=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI168,Tarifs!BH168)*B50+200*B50,IF(C50=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI168,Tarifs!BH168)*B50+200*B50,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C51=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI169,Tarifs!BH169)*B51+200*B51,IF(C51=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI169,Tarifs!BH169)*B51+200*B51,IF(C51=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI169,Tarifs!BH169)*B51+200*B51,IF(C51=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI169,Tarifs!BH169)*B51+200*B51,IF(C51=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI169,Tarifs!BH169)*B51+200*B51,IF(C51=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI169,Tarifs!BH169)*B51+200*B51,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C52=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI170,Tarifs!BH170)*B52+200*B52,IF(C52=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI170,Tarifs!BH170)*B52+200*B52,IF(C52=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI170,Tarifs!BH170)*B52+200*B52,IF(C52=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI170,Tarifs!BH170)*B52+200*B52,IF(C52=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI170,Tarifs!BH170)*B52+200*B52,IF(C52=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI170,Tarifs!BH170)*B52+200*B52,\"\"))))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(C53=\"bso\",INDEX(Tarifs!$B$189:$AH$221,Tarifs!BI171,Tarifs!BH171)*B53+200*B53,IF(C53=\"vr\",INDEX(Tarifs!$B$149:$AH$181,Tarifs!BI171,Tarifs!BH171)*B53+200*B53,IF(C53=\"VRC\",INDEX(Tarifs!$B$227:$AH$259,Tarifs!BI171,Tarifs!BH171)*B53+200*B53,IF(C53=\"ZS2\",INDEX(Tarifs!$B$268:$BB$320,Tarifs!BI171,Tarifs!BH171)*B53+200*B53,IF(C53=\"bsoc\",INDEX(Tarifs!$B$370:$AH$402,Tarifs!BI171,Tarifs!BH171)*B53+200*B53,IF(C53=\"bsocm\",INDEX(Tarifs!$B$329:$AH$361,Tarifs!BI171,Tarifs!BH171)*B53+200*B53,\"\"))))))","v":""},null,{"$f":"IF(H44=\"\",\"\",SUM(H44:I53)*1.05)","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(J42=\"\",J53=\"\"),\"\",SUM(J42:J53))","v":""}]

{"sheet":"Tarifs","index":2,"n_rows":171,"n_cols":115,"rows_kept":171,"cut":false,"hidden":false,"merged":[[43,10,44,10],[51,1,51,3],[51,4,51,6],[51,7,51,9],[64,1,64,3],[64,4,64,6],[64,7,64,9],[19,12,24,12],[22,10,24,11],[42,3,42,5],[25,12,27,12],[30,1,30,3],[30,4,30,6],[30,7,30,9],[0,1,0,3],[0,4,0,6],[0,7,0,9],[19,10,21,11],[25,10,27,11],[131,1,131,13],[181,0,186,7],[224,0,224,7],[77,1,77,3],[77,4,77,6],[77,7,77,9],[102,1,102,3],[102,4,102,6],[102,7,102,9],[125,1,125,2],[127,0,127,2],[127,3,127,5],[127,6,127,8],[128,0,128,8],[262,0,265,5],[323,0,326,4],[364,0,367,5],[323,5,326,7],[137,1,137,10],[146,0,146,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,0.9,1,1.1000000000000001,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,2,2.1,2.2000000000000002,2.2999999999999998,2.4,2.5,2.6,2.7,2.8,2.9,3,3.1,3.2,3.3,3.4,3.5,3.6,3.7,3.8,3.9,4,4.0999999999999996,4.2,4.3,4.4000000000000004,4.5,4.5999999999999996,4.7,4.8,4.9000000000000004,5,5.0999999999999996,5.2,5.3,5.4,5.5,5.6,5.7,5.8000000000000096,5.9000000000000101,6,6.1000000000000103,6.2000000000000099,6.3000000000000096]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"largeur","hauteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D35=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D35,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F35=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F35,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D36=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D36,$BH$150:$DK$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F36=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F36,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D37=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D37,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F37=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F37,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D38=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D38,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F38=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F38,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D39=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D39,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F39=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F39,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D40=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D40,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F40=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F40,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D41=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D41,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F41=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F41,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D42=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D42,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F42=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F42,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D43=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D43,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F43=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F43,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D44=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D44,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F44=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F44,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D45=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D45,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F45=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F45,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D46=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D46,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F46=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F46,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D47=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D47,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F47=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F47,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D48=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D48,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F48=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F48,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D49=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D49,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F49=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F49,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D50=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D50,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F50=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F50,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D51=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D51,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F51=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F51,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D52=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D52,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F52=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F52,$BH$150:$CN$151,2,FALSE)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Tableaux Menuiseries, VR, BSO'!D53=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!D53,$BH$150:$CX$151,2,FALSE)))","v":""},{"$f":"IF('Tableaux Menuiseries, VR, BSO'!F53=\"\",\"\",(HLOOKUP('Tableaux Menuiseries, VR, BSO'!F53,$BH$150:$CN$151,2,FALSE)))","v":""}]

{"sheet":"FEUILLE DE PRIX VERANDA","index":3,"n_rows":110,"n_cols":17,"rows_kept":110,"cut":false,"hidden":false,"merged":[[0,0,52,8],[110,0,110,1],[87,7,87,8],[86,7,86,8],[94,7,94,8],[93,7,93,8],[92,7,92,8],[91,7,91,8],[100,7,100,8],[99,7,99,8],[98,7,98,8],[96,7,96,8],[95,7,95,8],[104,7,104,8],[103,7,103,8],[102,7,102,8],[110,7,110,8],[109,0,109,1],[109,7,109,8],[100,0,100,1],[99,0,99,1],[98,0,98,1],[97,0,97,1],[106,0,106,1],[108,7,108,8],[109,10,109,14],[109,15,109,17],[108,0,108,1],[107,0,107,1],[90,7,90,8],[89,7,89,8],[88,7,88,8],[79,10,79,15],[101,7,101,8],[101,0,101,1],[79,16,79,17],[94,10,94,17],[96,10,96,13],[96,14,96,17],[95,14,95,17],[95,10,95,13],[84,10,89,17],[100,10,100,13],[99,10,99,13],[98,10,98,13],[97,10,97,13],[100,14,100,17],[99,14,99,17],[98,14,98,17],[106,7,106,8],[105,7,105,8],[81,10,81,15],[82,0,83,1],[82,7,83,8],[84,0,85,1],[84,7,85,8],[96,0,96,1],[97,14,97,17],[105,0,105,1],[104,0,104,1],[103,0,103,1],[102,0,102,1],[86,0,86,1],[91,0,91,1],[90,0,90,1],[89,0,89,1],[88,0,88,1],[87,0,87,1],[95,0,95,1],[94,0,94,1],[93,0,93,1],[92,0,92,1],[97,7,97,8],[56,0,56,8],[57,0,57,8],[80,0,81,8],[83,10,83,11],[77,1,78,8],[75,1,76,8],[68,10,68,17],[73,1,74,8],[69,10,69,15],[69,16,69,17],[70,16,70,17],[71,16,71,17],[72,16,72,17],[73,16,73,17],[70,12,70,15],[81,16,81,17],[79,0,79,8],[71,10,71,15],[72,10,72,15],[73,10,73,15],[75,16,75,17],[76,16,76,17],[45,14,45,15],[44,14,44,15],[43,14,43,15],[91,10,91,13],[91,15,91,17],[80,10,80,12],[58,10,65,17],[102,10,106,17],[66,10,66,17],[67,10,67,17],[92,10,93,17],[80,16,80,17],[77,16,77,17],[78,16,78,17],[74,10,78,10],[74,16,74,17],[75,11,75,15],[76,11,76,15],[77,11,77,15],[78,11,78,15],[74,11,74,15],[56,10,56,17],[57,10,57,17]]}
["1ere feuille A3 word idéalement masqué pour confidentialité; dessous le verso qui idéalement se remplirai en partie automatiquement"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Etalans, le",{"$f":"TODAY()","v":"2016-11-19"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Votre conseiller"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Confort!C4=\"\",Confort!C5=\"\"),\"\",IF(AND(Confort!C4=\"\",Confort!C5=\"x\"),\"Jean-Marc Junot\",IF(AND(Confort!C4=\"x\",Confort!C5=\"\"),\"Thierry Schaegis\",\"\")))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DETAIL DE VOTRE VERANDA",null,null,null,null,null,null,null,null,null,"DEVIS QUANTITATIF - BON DE COMMANDE"]
["En complément de votre tableau « Choix des Matériaux »"]
[]
["Dimensions hors-tout extérieur poteaux:"]
[]
["Face A : pignon gauche",null,null,{"$f":"Confort!L55*1000","v":{"$error":"#VALUE!"}},"mm"]
[]
["Face B : façade",null,null,{"$f":"Confort!F55*1000","v":{"$error":"#VALUE!"}},"mm"]
[]
["Face C : pignon droit",null,null,{"$f":"D62","v":{"$error":"#VALUE!"}},"mm"]
[null,null,null,null,null,null,null,null,null,null,"Fourniture et pose:           "]
["Hauteur Maxi faîtière :",null,null,2780,"mm",null,null,null,null,null,"Maçonnerie: cf. devis ci-joint"]
[null,null,null,null,null,null,null,null,null,null,"Compris divers:"]
["Hauteur menuiseries sous chéneau:",null,null,{"$f":"'Tableaux Menuiseries, VR, BSO'!F3*1000","v":0},"mm ",null,null,null,null,null,"Montant de la véranda HT",null,null,null,null,null,{"$f":"Confort!Q161","v":0}]
[null,null,null,null,null,null,null,null,null,null,"T.V.A. à :",{"$f":"Confort!P162","v":{"$error":"#VALUE!"}},"%",null,null,null,{"$f":"Confort!Q162","v":{"$error":"#VALUE!"}}]
["Détail de vos menuiseries : (Selon plans ci-joints)",null,null,null,null,null,null,null,null,null,"Montant total général et forfaitaire",null,null,null,null,null,{"$f":"Confort!Q163","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Option règlement comptant: voir ci-dessous remise 5%",null,null,null,null,null,{"$f":"Confort!#REF!","v":{"$error":"#REF!"}}]
["Face (A) :",null,null,null,null,null,null,null,null,null,"Dans ce cas net TTC",null,null,null,null,null,{"$f":"Confort!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"Option en plus-value Net TTC                                                   (-5% comptant inclus)",{"$f":"Confort!E164","v":""},null,null,null,null,{"$f":"Confort!P164","v":0}]
["Face (B) :",null,null,null,null,null,null,null,null,null,null,{"$f":"Confort!E165","v":""},null,null,null,null,{"$f":"Confort!P165","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Confort!E166","v":""},null,null,null,null,{"$f":"Confort!V166","v":""}]
["Face (C) :",null,null,null,null,null,null,null,null,null,null,{"$f":"Confort!E167","v":""},null,null,null,null,{"$f":"Confort!V167","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Confort!E168","v":""},null,null,null,null,{"$f":"Confort!V168","v":""}]
["Options qualitatives en plus-values déterminant selon Contrat Ambassadeur ci-joint une remise:",null,null,null,null,null,null,null,null,null,"Montant total de votre commande avec options retenues"]
[null,null,null,null,null,null,null,null,null,null,"Remise Ambassadeur :",null,null,{"$f":"IF(Confort!#REF!=\"\",\"\",Confort!#REF!)","v":{"$error":"#REF!"}},"%",null,{"$f":"Confort!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,"MONTANT NET TTC",null,null,null,null,null,{"$f":"Confort!#REF!","v":{"$error":"#REF!"}}]
["E",null,null,null,null,null,null,"A"]
[]
["VERANDA CONFORT",null,null,null,null,null,null,"VERANDA RESIDENCE"]
[]
[]
["Structure Anti-tempête",null,null,null,null,null,null,"Structure Anti-tempête"]
["avec chéneau-coffre +",null,null,null,null,null,null,"avec chéneau-coffre +"]
["Poteaux 200x200",null,null,null,null,null,null,"Poteaux 200x200"]
[]
["Panneaux Toiture",null,null,null,null,null,null,"Panneaux toiture"]
["Panneaux sandwich ",null,null,null,null,null,null,"Panneau sandwich 68 mm"]
["55mm acoustique",null,null,null,null,null,null,"Super acoustique"]
["Puit de lumière suncool",null,null,null,null,null,null,"puit de lumière Suncool"]
["Double-vitrage 31 mm",null,null,null,null,null,null,"Triple Vitrage 52mm"]
[null,null,null,null,null,null,null,"Réflexion solaire 80%"]
[]
[null,null,null,null,null,null,null,"Vitrages isolants Triple-"]
["Vitrages isolants double-",null,null,null,null,null,null,"vitrages 42mm K 0.7"]
["vitrages 24 mm K:1.1",null,null,null,null,null,null,"Coulissant concept"]
[null,null,null,null,null,null,null,"levage"]
[null,null,null,null,null,null,null,"Volets roulants, ou, Brise-"]
[null,null,null,null,null,null,null,"Soleil orientables, ou,"]
["4 Spots",null,null,null,null,null,null,"toile solaire, ou, Toile "]
[null,null,null,null,null,null,null,"solaire et moustiquaire"]
[null,null,null,null,null,null,null,"Spots"]
[]
[null,null,null,null,null,null,null,null,null,null,"Fait à :",null,null,null,null,"Le :"]
["Remise Ambassadeur : -2%",null,null,null,null,null,null,"Remise Ambassadeur : -8%",null,null,"L’acheteur, Signature + « bon pour commande »",null,null,null,null,"Le technicien conseil :"]