{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Project Information","Validation Sheet","Input Form","Trunking Translation","Quotation","Instructions","Configurator","Components","Art. List"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":261,"comments":2,"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":"Project Information","index":0,"n_rows":130,"n_cols":14,"rows_kept":130,"cut":false,"hidden":false,"merged":[[42,3,42,6],[43,3,43,6],[44,3,44,6],[45,3,45,6],[46,3,46,6],[47,3,47,6],[48,3,48,6],[2,4,2,5],[20,1,20,13],[21,1,25,13],[29,1,29,13],[30,7,30,13],[10,3,10,4],[27,1,27,6],[27,7,27,13],[31,7,31,13],[3,1,4,13],[6,1,6,13],[8,5,8,11],[10,5,10,11],[16,5,16,11],[18,3,18,4],[18,5,18,11],[12,3,12,4],[12,5,12,11],[14,1,14,13],[30,3,30,6],[31,3,31,6],[30,1,30,2],[8,2,8,4],[16,2,16,4],[32,7,32,13],[33,7,33,13],[34,7,34,13],[35,7,35,13],[35,1,35,2],[32,3,32,6],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[33,3,33,6],[34,3,34,6],[35,3,35,6],[36,7,36,13],[37,7,37,13],[38,7,38,13],[48,1,48,2],[48,7,48,13],[39,1,39,2],[36,1,36,2],[42,1,42,2],[42,7,42,13],[43,1,43,2],[43,7,43,13],[40,1,40,2],[40,7,40,13],[41,1,41,2],[41,7,41,13],[37,1,37,2],[39,7,39,13],[38,1,38,2],[37,3,37,6],[36,3,36,6],[38,3,38,6],[39,3,39,6],[40,3,40,6],[41,3,41,6],[49,1,49,2],[49,7,49,13],[46,1,46,2],[46,7,46,13],[47,1,47,2],[47,7,47,13],[44,1,44,2],[44,7,44,13],[45,1,45,2],[45,7,45,13],[49,3,49,6],[54,1,54,2],[54,7,54,13],[55,1,55,2],[55,7,55,13],[52,1,52,2],[52,7,52,13],[53,1,53,2],[53,7,53,13],[50,1,50,2],[50,7,50,13],[51,1,51,2],[51,7,51,13],[51,3,51,6],[52,3,52,6],[53,3,53,6],[54,3,54,6],[55,3,55,6],[50,3,50,6],[60,1,60,2],[60,7,60,13],[61,1,61,2],[61,7,61,13],[58,1,58,2],[58,7,58,13],[59,1,59,2],[59,7,59,13],[56,1,56,2],[56,7,56,13],[57,1,57,2],[57,7,57,13],[56,3,56,6],[57,3,57,6],[58,3,58,6],[59,3,59,6],[60,3,60,6],[61,3,61,6],[66,1,66,2],[66,7,66,13],[67,1,67,2],[67,7,67,13],[64,1,64,2],[64,7,64,13],[65,1,65,2],[65,7,65,13],[62,1,62,2],[62,7,62,13],[63,1,63,2],[63,7,63,13],[62,3,62,6],[63,3,63,6],[64,3,64,6],[65,3,65,6],[66,3,66,6],[67,3,67,6],[72,1,72,2],[72,7,72,13],[73,1,73,2],[73,7,73,13],[70,1,70,2],[70,7,70,13],[71,1,71,2],[71,7,71,13],[68,1,68,2],[68,7,68,13],[69,1,69,2],[69,7,69,13],[68,3,68,6],[69,3,69,6],[70,3,70,6],[71,3,71,6],[72,3,72,6],[73,3,73,6],[78,1,78,2],[78,7,78,13],[79,1,79,2],[79,7,79,13],[76,1,76,2],[76,7,76,13],[77,1,77,2],[77,7,77,13],[74,1,74,2],[74,7,74,13],[75,1,75,2],[75,7,75,13],[74,3,74,6],[75,3,75,6],[76,3,76,6],[77,3,77,6],[78,3,78,6],[79,3,79,6],[84,1,84,2],[84,7,84,13],[85,1,85,2],[85,7,85,13],[82,1,82,2],[82,7,82,13],[83,1,83,2],[83,7,83,13],[80,1,80,2],[80,7,80,13],[81,1,81,2],[81,7,81,13],[80,3,80,6],[81,3,81,6],[82,3,82,6],[83,3,83,6],[84,3,84,6],[85,3,85,6],[90,1,90,2],[90,7,90,13],[91,1,91,2],[91,7,91,13],[88,1,88,2],[88,7,88,13],[89,1,89,2],[89,7,89,13],[86,1,86,2],[86,7,86,13],[87,1,87,2],[87,7,87,13],[86,3,86,6],[87,3,87,6],[88,3,88,6],[89,3,89,6],[90,3,90,6],[91,3,91,6],[96,1,96,2],[96,7,96,13],[97,1,97,2],[97,7,97,13],[94,1,94,2],[94,7,94,13],[95,1,95,2],[95,7,95,13],[92,1,92,2],[92,7,92,13],[93,1,93,2],[93,7,93,13],[92,3,92,6],[93,3,93,6],[94,3,94,6],[95,3,95,6],[96,3,96,6],[97,3,97,6],[102,1,102,2],[102,7,102,13],[103,1,103,2],[103,7,103,13],[100,1,100,2],[100,7,100,13],[101,1,101,2],[101,7,101,13],[98,1,98,2],[98,7,98,13],[99,1,99,2],[99,7,99,13],[98,3,98,6],[99,3,99,6],[100,3,100,6],[101,3,101,6],[102,3,102,6],[103,3,103,6],[108,1,108,2],[108,7,108,13],[109,1,109,2],[109,7,109,13],[106,1,106,2],[106,7,106,13],[107,1,107,2],[107,7,107,13],[104,1,104,2],[104,7,104,13],[105,1,105,2],[105,7,105,13],[104,3,104,6],[105,3,105,6],[106,3,106,6],[107,3,107,6],[108,3,108,6],[109,3,109,6],[114,1,114,2],[114,7,114,13],[115,1,115,2],[115,7,115,13],[112,1,112,2],[112,7,112,13],[113,1,113,2],[113,7,113,13],[110,1,110,2],[110,7,110,13],[111,1,111,2],[111,7,111,13],[110,3,110,6],[111,3,111,6],[112,3,112,6],[113,3,113,6],[114,3,114,6],[115,3,115,6],[120,1,120,2],[120,7,120,13],[121,1,121,2],[121,7,121,13],[118,1,118,2],[118,7,118,13],[119,1,119,2],[119,7,119,13],[116,1,116,2],[116,7,116,13],[117,1,117,2],[117,7,117,13],[116,3,116,6],[117,3,117,6],[118,3,118,6],[119,3,119,6],[120,3,120,6],[121,3,121,6],[124,1,124,2],[124,7,124,13],[125,1,125,2],[125,7,125,13],[122,1,122,2],[122,7,122,13],[123,1,123,2],[123,7,123,13],[122,3,122,6],[123,3,123,6],[124,3,124,6],[125,3,125,6],[128,1,128,2],[128,7,128,13],[129,1,129,2],[129,7,129,13],[128,3,128,6],[129,3,129,6],[126,1,126,2],[126,7,126,13],[127,1,127,2],[127,7,127,13],[126,3,126,6],[127,3,127,6]]}
[]
[]
[null,"Please select your language:",null,null,"English",null,null,null,null,null,null,null,null,"Version 3.2"]
[null,{"$f":"'Trunking Translation'!$B$13","v":"OPPLE LED Trunking Configurator"}]
[]
[]
[null,{"$f":"'Trunking Translation'!$B$14","v":"Project Information"}]
[]
[null,null,{"$f":"'Trunking Translation'!B15","v":"Project Name*"}]
[]
[null,null,null,{"$f":"'Trunking Translation'!B16","v":"Wholesaler"}]
[]
[null,null,null,{"$f":"'Trunking Translation'!B17","v":"Installer"}]
[]
[null,{"$f":"'Trunking Translation'!B18","v":"OPPLE Lighting B.V Information"}]
[]
[null,null,{"$f":"'Trunking Translation'!B19","v":"Representative*"}]
[]
[null,null,null,{"$f":"'Trunking Translation'!B20","v":"Date"},null,{"$f":"TODAY()","v":"2021-06-04"}]
[]
[null,{"$f":"'Trunking Translation'!B21","v":"Project Remark"}]
[]
[]
[]
[]
[]
[]
[null,"# Sections (Max. 100)",null,null,null,null,null,1]
[null,null,null,null,null,null,null,4]
[null,{"$f":"'Trunking Translation'!B22","v":"Section Name & Remark"}]
[1,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A31)","v":"Section_1"}]
[2,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A32)","v":"Section_2"}]
[3,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A33)","v":"Section_3"}]
[4,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A34)","v":"Section_4"}]
[5,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A35)","v":"Section_5"}]
[6,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A36)","v":"Section_6"}]
[7,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A37)","v":"Section_7"}]
[8,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A38)","v":"Section_8"}]
[9,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A39)","v":"Section_9"}]
[10,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A40)","v":"Section_10"}]
[11,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A41)","v":"Section_11"}]
[12,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A42)","v":"Section_12"}]
[13,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A43)","v":"Section_13"}]
[14,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A44)","v":"Section_14"}]
[15,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A45)","v":"Section_15"}]
[16,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A46)","v":"Section_16"}]
[17,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A47)","v":"Section_17"}]
[18,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A48)","v":"Section_18"}]
[19,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A49)","v":"Section_19"}]
[20,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A50)","v":"Section_20"}]
[21,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A51)","v":"Section_21"}]
[22,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A52)","v":"Section_22"}]
[23,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A53)","v":"Section_23"}]
[24,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A54)","v":"Section_24"}]
[25,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A55)","v":"Section_25"}]
[26,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A56)","v":"Section_26"}]
[27,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A57)","v":"Section_27"}]
[28,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A58)","v":"Section_28"}]
[29,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A59)","v":"Section_29"}]
[30,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A60)","v":"Section_30"}]
[31,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A61)","v":"Section_31"}]
[32,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A62)","v":"Section_32"}]
[33,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A63)","v":"Section_33"}]
[34,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A64)","v":"Section_34"}]
[35,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A65)","v":"Section_35"}]
[36,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A66)","v":"Section_36"}]
[37,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A67)","v":"Section_37"}]
[38,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A68)","v":"Section_38"}]
[39,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A69)","v":"Section_39"}]
[40,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A70)","v":"Section_40"}]
[41,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A71)","v":"Section_41"}]
[42,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A72)","v":"Section_42"}]
[43,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A73)","v":"Section_43"}]
[44,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A74)","v":"Section_44"}]
[45,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A75)","v":"Section_45"}]
[46,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A76)","v":"Section_46"}]
[47,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A77)","v":"Section_47"}]
[48,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A78)","v":"Section_48"}]
[49,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A79)","v":"Section_49"}]
[50,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A80)","v":"Section_50"}]
[51,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A81)","v":"Section_51"}]
[52,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A82)","v":"Section_52"}]
[53,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A83)","v":"Section_53"}]
[54,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A84)","v":"Section_54"}]
[55,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A85)","v":"Section_55"}]
[56,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A86)","v":"Section_56"}]
[57,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A87)","v":"Section_57"}]
[58,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A88)","v":"Section_58"}]
[59,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A89)","v":"Section_59"}]
[60,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A90)","v":"Section_60"}]
[61,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A91)","v":"Section_61"}]
[62,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A92)","v":"Section_62"}]
[63,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A93)","v":"Section_63"}]
[64,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A94)","v":"Section_64"}]
[65,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A95)","v":"Section_65"}]
[66,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A96)","v":"Section_66"}]
[67,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A97)","v":"Section_67"}]
[68,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A98)","v":"Section_68"}]
[69,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A99)","v":"Section_69"}]
[70,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A100)","v":"Section_70"}]
[71,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A101)","v":"Section_71"}]
[72,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A102)","v":"Section_72"}]
[73,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A103)","v":"Section_73"}]
[74,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A104)","v":"Section_74"}]
[75,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A105)","v":"Section_75"}]
[76,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A106)","v":"Section_76"}]
[77,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A107)","v":"Section_77"}]
[78,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A108)","v":"Section_78"}]
[79,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A109)","v":"Section_79"}]
[80,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A110)","v":"Section_80"}]
[81,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A111)","v":"Section_81"}]
[82,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A112)","v":"Section_82"}]
[83,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A113)","v":"Section_83"}]
[84,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A114)","v":"Section_84"}]
[85,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A115)","v":"Section_85"}]
[86,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A116)","v":"Section_86"}]
[87,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A117)","v":"Section_87"}]
[88,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A118)","v":"Section_88"}]
[89,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A119)","v":"Section_89"}]
[90,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A120)","v":"Section_90"}]
[91,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A121)","v":"Section_91"}]
[92,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A122)","v":"Section_92"}]
[93,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A123)","v":"Section_93"}]
[94,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A124)","v":"Section_94"}]
[95,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A125)","v":"Section_95"}]
[96,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A126)","v":"Section_96"}]
[97,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A127)","v":"Section_97"}]
[98,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A128)","v":"Section_98"}]
[99,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A129)","v":"Section_99"}]
[100,{"$f":"CONCATENATE('Trunking Translation'!$B$23, \"_\",A130)","v":"Section_100"}]

{"sheet":"Validation Sheet","index":1,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[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]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"Input Form","index":2,"n_rows":114,"n_cols":37,"rows_kept":114,"cut":false,"hidden":true,"merged":[[11,18,13,18],[11,19,13,19],[3,1,5,17],[7,3,7,5],[8,3,8,5],[9,3,9,5],[11,9,13,9],[11,12,13,12],[11,1,13,1],[11,10,13,10],[6,2,6,3],[11,2,13,2],[11,3,13,3],[11,4,13,4],[11,5,13,5],[11,7,13,7],[11,8,13,8],[11,17,13,17],[11,6,13,6],[11,13,13,13],[11,14,13,14],[11,16,13,16],[11,15,13,15],[11,11,13,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Probe L"]
[null,{"$f":"'Trunking Translation'!B25","v":"OPPLE LED Trunking: Input Form"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of Senfor per Line (FULL)",null,null,null,null,null,null,null,"Probe H",null,null,null,null,"Installation Height"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q15=$AF$6,1,IF(Q15=$AF$7,2,IF($AF$8=$AF$8,IF(P15=$AF$3,E15/VLOOKUP(O15,'Art. List'!I5:K15,2,FALSE),IF('Input Form'!P15='Input Form'!$AF$4,'Input Form'!E15/VLOOKUP('Input Form'!O15,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,null,null,null,null,null,null,null,"LED Module Occupation per Line",null,null,3]
[null,null,null,null,null,null,null,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":"'Trunking Translation'!B84","v":"Begin"},null,{"$f":"'Trunking Translation'!B52","v":"Full"},null,null,4]
[null,null,null,null,null,null,null,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":"'Trunking Translation'!B85","v":"Begin-End"},null,{"$f":"'Trunking Translation'!B53","v":"Half"},null,null,5]
[null,null,{"$f":"'Trunking Translation'!B15","v":"Project Name*"},{"$f":"IF(ISBLANK('Project Information'!F9),\"\",'Project Information'!F9)","v":""},null,null,null,{"$f":"'Trunking Translation'!B19","v":"Representative*"},{"$f":"IF(ISBLANK('Project Information'!F17),\"\",'Project Information'!F17)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Trunking Translation'!$B$52","v":"Full"},null,{"$f":"'Trunking Translation'!B54","v":"One-Third"},null,null,6]
[null,null,{"$f":"'Trunking Translation'!B16","v":"Wholesaler"},{"$f":"IF(ISBLANK('Project Information'!F11),\"\",'Project Information'!F11)","v":""},null,null,null,{"$f":"'Trunking Translation'!B20","v":"Date"},{"$f":"'Project Information'!F19","v":"2021-06-04"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Trunking Translation'!$B$55","v":"Custom"},null,{"$f":"'Trunking Translation'!B55","v":"Custom"},null,null,7]
[null,null,{"$f":"'Trunking Translation'!B17","v":"Installer"},{"$f":"IF(ISBLANK('Project Information'!F13),\"\",'Project Information'!F13)","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,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[null,{"$f":"'Trunking Translation'!B23","v":"Section"},{"$f":"'Trunking Translation'!B29","v":"LED Module"},{"$f":"'Trunking Translation'!B30","v":"No. of Lines"},{"$f":"'Trunking Translation'!B31","v":"Length per line (m)"},{"$f":"'Trunking Translation'!B32","v":"Feed-in-box"},{"$f":"'Trunking Translation'!C72","v":"Feed-out-box"},{"$f":"'Trunking Translation'!B33","v":"Mounting Method"},{"$f":"'Trunking Translation'!B34","v":"LED Module Occupation per Line"},{"$f":"'Trunking Translation'!B36","v":"LED Modules per Line"},{"$f":"'Trunking Translation'!B35","v":"Custom Amount"},{"$f":"'Trunking Translation'!B87","v":"Blind Covers per line"},{"$f":"'Trunking Translation'!B37","v":"Line ends with LED Module?"},{"$f":"'Trunking Translation'!$B73","v":"Sensor"},{"$f":"'Trunking Translation'!$B74","v":"Installation Height (m)"},{"$f":"'Trunking Translation'!$B76","v":"Sensor Type"},{"$f":"'Trunking Translation'!$B75","v":"Sensor Occupation per Line"},{"$f":"'Trunking Translation'!$B77","v":"No. of Sensors per Line"},{"$f":"'Trunking Translation'!B35","v":"Custom Amount"},"DALI \nPower Supply",null,null,null,null,null,null,null,null,null,null,null,true,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DALI",null,null,null,null,null,null,null,null,null,false,null,{"$f":"'Trunking Translation'!B47","v":"Yes"},null,null,12.5]
[null,null,null,null,null,null,null,null,null,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":"'Trunking Translation'!B48","v":"No"}]
[null,{"$f":"IF('Project Information'!D31=0,\"\",'Project Information'!D31)","v":""},null,null,null,null,null,null,null,{"$f":"ROUNDUP(IF(I15=$AH$6,E15/1.5,IF(I15=$AH$7,E15/3,IF(I15=$AH$8,E15/4.5,IF(I15=$AH$9,K15,0)))),)","v":0},null,{"$f":"E15/1.5-J15","v":0},{"$f":"IF(ISBLANK(I15),\"\",IF(I15=$AH$7,IF(RIGHT(E15/3-TRUNC(E15/3),1)=\"5\",$AH$13,$AH$14),IF(I15=$AH$8,IF(RIGHT(E15/4.5-TRUNC(E15/4.5),1)=\"3\",$AH$13,$AH$14),IF(I15=$AH$6,$AH$13,$AH$15))))","v":""},null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q15=$AF$6,1,IF(Q15=$AF$7,2,IF(Q15=$AF$8,IF(P15=$AF$3,E15/VLOOKUP(O15,'Art. List'!I5:K15,2,FALSE),IF('Input Form'!P15='Input Form'!$AF$4,'Input Form'!E15/VLOOKUP('Input Form'!O15,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),S15)","v":0},null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Trunking Translation'!B57","v":"Unknown"}]
[null,{"$f":"IF('Project Information'!D32=0,\"\",'Project Information'!D32)","v":""},null,null,null,null,null,null,null,{"$f":"ROUNDUP(IF(I16=$AH$6,E16/1.5,IF(I16=$AH$7,E16/3,IF(I16=$AH$8,E16/4.5,IF(I16=$AH$9,K16,0)))),)","v":0},null,{"$f":"E16/1.5-J16","v":0},{"$f":"IF(ISBLANK(I16),\"\",IF(I16=$AH$7,IF(RIGHT(E16/3-TRUNC(E16/3),1)=\"5\",$AH$13,$AH$14),IF(I16=$AH$8,IF(RIGHT(E16/4.5-TRUNC(E16/4.5),1)=\"3\",$AH$13,$AH$14),IF(I16=$AH$6,$AH$13,$AH$15))))","v":""},null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q16=$AF$6,1,IF(Q16=$AF$7,2,IF(Q16=$AF$8,IF(P16=$AF$3,E16/VLOOKUP(O16,'Art. List'!I6:K16,2,FALSE),IF('Input Form'!P16='Input Form'!$AF$4,'Input Form'!E16/VLOOKUP('Input Form'!O16,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D33=0,\"\",'Project Information'!D33)","v":""},null,null,null,null,null,null,null,{"$f":"ROUNDUP(IF(I17=$AH$6,E17/1.5,IF(I17=$AH$7,E17/3,IF(I17=$AH$8,E17/4.5,IF(I17=$AH$9,K17,0)))),)","v":0},null,{"$f":"E17/1.5-J17","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q17=$AF$6,1,IF(Q17=$AF$7,2,IF(Q17=$AF$8,IF(P17=$AF$3,E17/VLOOKUP(O17,'Art. List'!I7:K17,2,FALSE),IF('Input Form'!P17='Input Form'!$AF$4,'Input Form'!E17/VLOOKUP('Input Form'!O17,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D34=0,\"\",'Project Information'!D34)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q18=$AF$6,1,IF(Q18=$AF$7,2,IF(Q18=$AF$8,IF(P18=$AF$3,E18/VLOOKUP(O18,'Art. List'!I8:K18,2,FALSE),IF('Input Form'!P18='Input Form'!$AF$4,'Input Form'!E18/VLOOKUP('Input Form'!O18,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D35=0,\"\",'Project Information'!D35)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q19=$AF$6,1,IF(Q19=$AF$7,2,IF(Q19=$AF$8,IF(P19=$AF$3,E19/VLOOKUP(O19,'Art. List'!I9:K19,2,FALSE),IF('Input Form'!P19='Input Form'!$AF$4,'Input Form'!E19/VLOOKUP('Input Form'!O19,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D36=0,\"\",'Project Information'!D36)","v":""},null,null,null,null,null,null,null,0,null,{"$f":"E20/1.5-J20","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q20=$AF$6,1,IF(Q20=$AF$7,2,IF(Q20=$AF$8,IF(P20=$AF$3,E20/VLOOKUP(O20,'Art. List'!I10:K20,2,FALSE),IF('Input Form'!P20='Input Form'!$AF$4,'Input Form'!E20/VLOOKUP('Input Form'!O20,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D37=0,\"\",'Project Information'!D37)","v":""},null,null,null,null,null,null,null,0,null,{"$f":"E21/1.5-J21","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q21=$AF$6,1,IF(Q21=$AF$7,2,IF(Q21=$AF$8,IF(P21=$AF$3,E21/VLOOKUP(O21,'Art. List'!I11:K21,2,FALSE),IF('Input Form'!P21='Input Form'!$AF$4,'Input Form'!E21/VLOOKUP('Input Form'!O21,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D38=0,\"\",'Project Information'!D38)","v":""},null,null,null,null,null,null,null,0,null,{"$f":"E22/1.5-J22","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q22=$AF$6,1,IF(Q22=$AF$7,2,IF(Q22=$AF$8,IF(P22=$AF$3,E22/VLOOKUP(O22,'Art. List'!I12:K22,2,FALSE),IF('Input Form'!P22='Input Form'!$AF$4,'Input Form'!E22/VLOOKUP('Input Form'!O22,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D39=0,\"\",'Project Information'!D39)","v":""},null,null,null,null,null,null,null,0,null,{"$f":"E23/1.5-J23","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q23=$AF$6,1,IF(Q23=$AF$7,2,IF(Q23=$AF$8,IF(P23=$AF$3,E23/VLOOKUP(O23,'Art. List'!I13:K23,2,FALSE),IF('Input Form'!P23='Input Form'!$AF$4,'Input Form'!E23/VLOOKUP('Input Form'!O23,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D40=0,\"\",'Project Information'!D40)","v":""},null,null,null,null,null,null,null,0,null,{"$f":"E24/1.5-J24","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q24=$AF$6,1,IF(Q24=$AF$7,2,IF(Q24=$AF$8,IF(P24=$AF$3,E24/VLOOKUP(O24,'Art. List'!I14:K24,2,FALSE),IF('Input Form'!P24='Input Form'!$AF$4,'Input Form'!E24/VLOOKUP('Input Form'!O24,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D41=0,\"\",'Project Information'!D41)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q25=$AF$6,1,IF(Q25=$AF$7,2,IF(Q25=$AF$8,IF(P25=$AF$3,E25/VLOOKUP(O25,'Art. List'!I15:K25,2,FALSE),IF('Input Form'!P25='Input Form'!$AF$4,'Input Form'!E25/VLOOKUP('Input Form'!O25,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D42=0,\"\",'Project Information'!D42)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q26=$AF$6,1,IF(Q26=$AF$7,2,IF(Q26=$AF$8,IF(P26=$AF$3,E26/VLOOKUP(O26,'Art. List'!I16:K26,2,FALSE),IF('Input Form'!P26='Input Form'!$AF$4,'Input Form'!E26/VLOOKUP('Input Form'!O26,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D43=0,\"\",'Project Information'!D43)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q27=$AF$6,1,IF(Q27=$AF$7,2,IF(Q27=$AF$8,IF(P27=$AF$3,E27/VLOOKUP(O27,'Art. List'!I17:K27,2,FALSE),IF('Input Form'!P27='Input Form'!$AF$4,'Input Form'!E27/VLOOKUP('Input Form'!O27,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D44=0,\"\",'Project Information'!D44)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q28=$AF$6,1,IF(Q28=$AF$7,2,IF(Q28=$AF$8,IF(P28=$AF$3,E28/VLOOKUP(O28,'Art. List'!I18:K28,2,FALSE),IF('Input Form'!P28='Input Form'!$AF$4,'Input Form'!E28/VLOOKUP('Input Form'!O28,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D45=0,\"\",'Project Information'!D45)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q29=$AF$6,1,IF(Q29=$AF$7,2,IF(Q29=$AF$8,IF(P29=$AF$3,E29/VLOOKUP(O29,'Art. List'!I19:K29,2,FALSE),IF('Input Form'!P29='Input Form'!$AF$4,'Input Form'!E29/VLOOKUP('Input Form'!O29,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D46=0,\"\",'Project Information'!D46)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q30=$AF$6,1,IF(Q30=$AF$7,2,IF(Q30=$AF$8,IF(P30=$AF$3,E30/VLOOKUP(O30,'Art. List'!I20:K30,2,FALSE),IF('Input Form'!P30='Input Form'!$AF$4,'Input Form'!E30/VLOOKUP('Input Form'!O30,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D47=0,\"\",'Project Information'!D47)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q31=$AF$6,1,IF(Q31=$AF$7,2,IF(Q31=$AF$8,IF(P31=$AF$3,E31/VLOOKUP(O31,'Art. List'!I21:K31,2,FALSE),IF('Input Form'!P31='Input Form'!$AF$4,'Input Form'!E31/VLOOKUP('Input Form'!O31,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D48=0,\"\",'Project Information'!D48)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q32=$AF$6,1,IF(Q32=$AF$7,2,IF(Q32=$AF$8,IF(P32=$AF$3,E32/VLOOKUP(O32,'Art. List'!I22:K32,2,FALSE),IF('Input Form'!P32='Input Form'!$AF$4,'Input Form'!E32/VLOOKUP('Input Form'!O32,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D49=0,\"\",'Project Information'!D49)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q33=$AF$6,1,IF(Q33=$AF$7,2,IF(Q33=$AF$8,IF(P33=$AF$3,E33/VLOOKUP(O33,'Art. List'!I23:K33,2,FALSE),IF('Input Form'!P33='Input Form'!$AF$4,'Input Form'!E33/VLOOKUP('Input Form'!O33,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D50=0,\"\",'Project Information'!D50)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q34=$AF$6,1,IF(Q34=$AF$7,2,IF(Q34=$AF$8,IF(P34=$AF$3,E34/VLOOKUP(O34,'Art. List'!I24:K34,2,FALSE),IF('Input Form'!P34='Input Form'!$AF$4,'Input Form'!E34/VLOOKUP('Input Form'!O34,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D51=0,\"\",'Project Information'!D51)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q35=$AF$6,1,IF(Q35=$AF$7,2,IF(Q35=$AF$8,IF(P35=$AF$3,E35/VLOOKUP(O35,'Art. List'!I25:K35,2,FALSE),IF('Input Form'!P35='Input Form'!$AF$4,'Input Form'!E35/VLOOKUP('Input Form'!O35,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D52=0,\"\",'Project Information'!D52)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q36=$AF$6,1,IF(Q36=$AF$7,2,IF(Q36=$AF$8,IF(P36=$AF$3,E36/VLOOKUP(O36,'Art. List'!I26:K36,2,FALSE),IF('Input Form'!P36='Input Form'!$AF$4,'Input Form'!E36/VLOOKUP('Input Form'!O36,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D53=0,\"\",'Project Information'!D53)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q37=$AF$6,1,IF(Q37=$AF$7,2,IF(Q37=$AF$8,IF(P37=$AF$3,E37/VLOOKUP(O37,'Art. List'!I27:K37,2,FALSE),IF('Input Form'!P37='Input Form'!$AF$4,'Input Form'!E37/VLOOKUP('Input Form'!O37,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D54=0,\"\",'Project Information'!D54)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q38=$AF$6,1,IF(Q38=$AF$7,2,IF(Q38=$AF$8,IF(P38=$AF$3,E38/VLOOKUP(O38,'Art. List'!I28:K38,2,FALSE),IF('Input Form'!P38='Input Form'!$AF$4,'Input Form'!E38/VLOOKUP('Input Form'!O38,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D55=0,\"\",'Project Information'!D55)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q39=$AF$6,1,IF(Q39=$AF$7,2,IF(Q39=$AF$8,IF(P39=$AF$3,E39/VLOOKUP(O39,'Art. List'!I29:K39,2,FALSE),IF('Input Form'!P39='Input Form'!$AF$4,'Input Form'!E39/VLOOKUP('Input Form'!O39,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D56=0,\"\",'Project Information'!D56)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q40=$AF$6,1,IF(Q40=$AF$7,2,IF(Q40=$AF$8,IF(P40=$AF$3,E40/VLOOKUP(O40,'Art. List'!I30:K40,2,FALSE),IF('Input Form'!P40='Input Form'!$AF$4,'Input Form'!E40/VLOOKUP('Input Form'!O40,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
["x",{"$f":"IF('Project Information'!D57=0,\"\",'Project Information'!D57)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q41=$AF$6,1,IF(Q41=$AF$7,2,IF(Q41=$AF$8,IF(P41=$AF$3,E41/VLOOKUP(O41,'Art. List'!I31:K41,2,FALSE),IF('Input Form'!P41='Input Form'!$AF$4,'Input Form'!E41/VLOOKUP('Input Form'!O41,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D58=0,\"\",'Project Information'!D58)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q42=$AF$6,1,IF(Q42=$AF$7,2,IF(Q42=$AF$8,IF(P42=$AF$3,E42/VLOOKUP(O42,'Art. List'!I32:K42,2,FALSE),IF('Input Form'!P42='Input Form'!$AF$4,'Input Form'!E42/VLOOKUP('Input Form'!O42,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
["x",{"$f":"IF('Project Information'!D59=0,\"\",'Project Information'!D59)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q43=$AF$6,1,IF(Q43=$AF$7,2,IF(Q43=$AF$8,IF(P43=$AF$3,E43/VLOOKUP(O43,'Art. List'!I33:K43,2,FALSE),IF('Input Form'!P43='Input Form'!$AF$4,'Input Form'!E43/VLOOKUP('Input Form'!O43,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D60=0,\"\",'Project Information'!D60)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q44=$AF$6,1,IF(Q44=$AF$7,2,IF(Q44=$AF$8,IF(P44=$AF$3,E44/VLOOKUP(O44,'Art. List'!I34:K44,2,FALSE),IF('Input Form'!P44='Input Form'!$AF$4,'Input Form'!E44/VLOOKUP('Input Form'!O44,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D61=0,\"\",'Project Information'!D61)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q45=$AF$6,1,IF(Q45=$AF$7,2,IF(Q45=$AF$8,IF(P45=$AF$3,E45/VLOOKUP(O45,'Art. List'!I35:K45,2,FALSE),IF('Input Form'!P45='Input Form'!$AF$4,'Input Form'!E45/VLOOKUP('Input Form'!O45,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D62=0,\"\",'Project Information'!D62)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q46=$AF$6,1,IF(Q46=$AF$7,2,IF(Q46=$AF$8,IF(P46=$AF$3,E46/VLOOKUP(O46,'Art. List'!I36:K46,2,FALSE),IF('Input Form'!P46='Input Form'!$AF$4,'Input Form'!E46/VLOOKUP('Input Form'!O46,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D63=0,\"\",'Project Information'!D63)","v":""},null,null,null,null,null,null,null,{"$f":"ROUNDUP(IF(I47=$AH$6,E47/1.5,IF(I47=$AH$7,E47/3,IF(I47=$AH$8,E47/4.5,IF(I47=$AH$9,K47,0)))),)","v":0},null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q47=$AF$6,1,IF(Q47=$AF$7,2,IF(Q47=$AF$8,IF(P47=$AF$3,E47/VLOOKUP(O47,'Art. List'!I37:K47,2,FALSE),IF('Input Form'!P47='Input Form'!$AF$4,'Input Form'!E47/VLOOKUP('Input Form'!O47,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D64=0,\"\",'Project Information'!D64)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q48=$AF$6,1,IF(Q48=$AF$7,2,IF(Q48=$AF$8,IF(P48=$AF$3,E48/VLOOKUP(O48,'Art. List'!I38:K48,2,FALSE),IF('Input Form'!P48='Input Form'!$AF$4,'Input Form'!E48/VLOOKUP('Input Form'!O48,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D65=0,\"\",'Project Information'!D65)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q49=$AF$6,1,IF(Q49=$AF$7,2,IF(Q49=$AF$8,IF(P49=$AF$3,E49/VLOOKUP(O49,'Art. List'!I39:K49,2,FALSE),IF('Input Form'!P49='Input Form'!$AF$4,'Input Form'!E49/VLOOKUP('Input Form'!O49,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D66=0,\"\",'Project Information'!D66)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q50=$AF$6,1,IF(Q50=$AF$7,2,IF(Q50=$AF$8,IF(P50=$AF$3,E50/VLOOKUP(O50,'Art. List'!I40:K50,2,FALSE),IF('Input Form'!P50='Input Form'!$AF$4,'Input Form'!E50/VLOOKUP('Input Form'!O50,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D67=0,\"\",'Project Information'!D67)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q51=$AF$6,1,IF(Q51=$AF$7,2,IF(Q51=$AF$8,IF(P51=$AF$3,E51/VLOOKUP(O51,'Art. List'!I41:K51,2,FALSE),IF('Input Form'!P51='Input Form'!$AF$4,'Input Form'!E51/VLOOKUP('Input Form'!O51,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,false]
[null,{"$f":"IF('Project Information'!D68=0,\"\",'Project Information'!D68)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q52=$AF$6,1,IF(Q52=$AF$7,2,IF(Q52=$AF$8,IF(P52=$AF$3,E52/VLOOKUP(O52,'Art. List'!I42:K52,2,FALSE),IF('Input Form'!P52='Input Form'!$AF$4,'Input Form'!E52/VLOOKUP('Input Form'!O52,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D69=0,\"\",'Project Information'!D69)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q53=$AF$6,1,IF(Q53=$AF$7,2,IF(Q53=$AF$8,IF(P53=$AF$3,E53/VLOOKUP(O53,'Art. List'!I43:K53,2,FALSE),IF('Input Form'!P53='Input Form'!$AF$4,'Input Form'!E53/VLOOKUP('Input Form'!O53,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D70=0,\"\",'Project Information'!D70)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q54=$AF$6,1,IF(Q54=$AF$7,2,IF(Q54=$AF$8,IF(P54=$AF$3,E54/VLOOKUP(O54,'Art. List'!I44:K54,2,FALSE),IF('Input Form'!P54='Input Form'!$AF$4,'Input Form'!E54/VLOOKUP('Input Form'!O54,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0},null,null,true]
[null,{"$f":"IF('Project Information'!D71=0,\"\",'Project Information'!D71)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q55=$AF$6,1,IF(Q55=$AF$7,2,IF(Q55=$AF$8,IF(P55=$AF$3,E55/VLOOKUP(O55,'Art. List'!I45:K55,2,FALSE),IF('Input Form'!P55='Input Form'!$AF$4,'Input Form'!E55/VLOOKUP('Input Form'!O55,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D72=0,\"\",'Project Information'!D72)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q56=$AF$6,1,IF(Q56=$AF$7,2,IF(Q56=$AF$8,IF(P56=$AF$3,E56/VLOOKUP(O56,'Art. List'!I46:K56,2,FALSE),IF('Input Form'!P56='Input Form'!$AF$4,'Input Form'!E56/VLOOKUP('Input Form'!O56,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D73=0,\"\",'Project Information'!D73)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q57=$AF$6,1,IF(Q57=$AF$7,2,IF(Q57=$AF$8,IF(P57=$AF$3,E57/VLOOKUP(O57,'Art. List'!I47:K57,2,FALSE),IF('Input Form'!P57='Input Form'!$AF$4,'Input Form'!E57/VLOOKUP('Input Form'!O57,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D74=0,\"\",'Project Information'!D74)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q58=$AF$6,1,IF(Q58=$AF$7,2,IF(Q58=$AF$8,IF(P58=$AF$3,E58/VLOOKUP(O58,'Art. List'!I48:K58,2,FALSE),IF('Input Form'!P58='Input Form'!$AF$4,'Input Form'!E58/VLOOKUP('Input Form'!O58,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D75=0,\"\",'Project Information'!D75)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q59=$AF$6,1,IF(Q59=$AF$7,2,IF(Q59=$AF$8,IF(P59=$AF$3,E59/VLOOKUP(O59,'Art. List'!I49:K59,2,FALSE),IF('Input Form'!P59='Input Form'!$AF$4,'Input Form'!E59/VLOOKUP('Input Form'!O59,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D76=0,\"\",'Project Information'!D76)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q60=$AF$6,1,IF(Q60=$AF$7,2,IF(Q60=$AF$8,IF(P60=$AF$3,E60/VLOOKUP(O60,'Art. List'!I50:K60,2,FALSE),IF('Input Form'!P60='Input Form'!$AF$4,'Input Form'!E60/VLOOKUP('Input Form'!O60,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D77=0,\"\",'Project Information'!D77)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q61=$AF$6,1,IF(Q61=$AF$7,2,IF(Q61=$AF$8,IF(P61=$AF$3,E61/VLOOKUP(O61,'Art. List'!I51:K61,2,FALSE),IF('Input Form'!P61='Input Form'!$AF$4,'Input Form'!E61/VLOOKUP('Input Form'!O61,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D78=0,\"\",'Project Information'!D78)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q62=$AF$6,1,IF(Q62=$AF$7,2,IF(Q62=$AF$8,IF(P62=$AF$3,E62/VLOOKUP(O62,'Art. List'!I52:K62,2,FALSE),IF('Input Form'!P62='Input Form'!$AF$4,'Input Form'!E62/VLOOKUP('Input Form'!O62,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D79=0,\"\",'Project Information'!D79)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q63=$AF$6,1,IF(Q63=$AF$7,2,IF(Q63=$AF$8,IF(P63=$AF$3,E63/VLOOKUP(O63,'Art. List'!I53:K63,2,FALSE),IF('Input Form'!P63='Input Form'!$AF$4,'Input Form'!E63/VLOOKUP('Input Form'!O63,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D80=0,\"\",'Project Information'!D80)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q64=$AF$6,1,IF(Q64=$AF$7,2,IF(Q64=$AF$8,IF(P64=$AF$3,E64/VLOOKUP(O64,'Art. List'!I54:K64,2,FALSE),IF('Input Form'!P64='Input Form'!$AF$4,'Input Form'!E64/VLOOKUP('Input Form'!O64,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D81=0,\"\",'Project Information'!D81)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q65=$AF$6,1,IF(Q65=$AF$7,2,IF(Q65=$AF$8,IF(P65=$AF$3,E65/VLOOKUP(O65,'Art. List'!I55:K65,2,FALSE),IF('Input Form'!P65='Input Form'!$AF$4,'Input Form'!E65/VLOOKUP('Input Form'!O65,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D82=0,\"\",'Project Information'!D82)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q66=$AF$6,1,IF(Q66=$AF$7,2,IF(Q66=$AF$8,IF(P66=$AF$3,E66/VLOOKUP(O66,'Art. List'!I56:K66,2,FALSE),IF('Input Form'!P66='Input Form'!$AF$4,'Input Form'!E66/VLOOKUP('Input Form'!O66,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D83=0,\"\",'Project Information'!D83)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q67=$AF$6,1,IF(Q67=$AF$7,2,IF(Q67=$AF$8,IF(P67=$AF$3,E67/VLOOKUP(O67,'Art. List'!I57:K67,2,FALSE),IF('Input Form'!P67='Input Form'!$AF$4,'Input Form'!E67/VLOOKUP('Input Form'!O67,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D84=0,\"\",'Project Information'!D84)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q68=$AF$6,1,IF(Q68=$AF$7,2,IF(Q68=$AF$8,IF(P68=$AF$3,E68/VLOOKUP(O68,'Art. List'!I58:K68,2,FALSE),IF('Input Form'!P68='Input Form'!$AF$4,'Input Form'!E68/VLOOKUP('Input Form'!O68,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D85=0,\"\",'Project Information'!D85)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q69=$AF$6,1,IF(Q69=$AF$7,2,IF(Q69=$AF$8,IF(P69=$AF$3,E69/VLOOKUP(O69,'Art. List'!I59:K69,2,FALSE),IF('Input Form'!P69='Input Form'!$AF$4,'Input Form'!E69/VLOOKUP('Input Form'!O69,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D86=0,\"\",'Project Information'!D86)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q70=$AF$6,1,IF(Q70=$AF$7,2,IF(Q70=$AF$8,IF(P70=$AF$3,E70/VLOOKUP(O70,'Art. List'!I60:K70,2,FALSE),IF('Input Form'!P70='Input Form'!$AF$4,'Input Form'!E70/VLOOKUP('Input Form'!O70,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D87=0,\"\",'Project Information'!D87)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q71=$AF$6,1,IF(Q71=$AF$7,2,IF(Q71=$AF$8,IF(P71=$AF$3,E71/VLOOKUP(O71,'Art. List'!I61:K71,2,FALSE),IF('Input Form'!P71='Input Form'!$AF$4,'Input Form'!E71/VLOOKUP('Input Form'!O71,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D88=0,\"\",'Project Information'!D88)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q72=$AF$6,1,IF(Q72=$AF$7,2,IF(Q72=$AF$8,IF(P72=$AF$3,E72/VLOOKUP(O72,'Art. List'!I62:K72,2,FALSE),IF('Input Form'!P72='Input Form'!$AF$4,'Input Form'!E72/VLOOKUP('Input Form'!O72,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D89=0,\"\",'Project Information'!D89)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q73=$AF$6,1,IF(Q73=$AF$7,2,IF(Q73=$AF$8,IF(P73=$AF$3,E73/VLOOKUP(O73,'Art. List'!I63:K73,2,FALSE),IF('Input Form'!P73='Input Form'!$AF$4,'Input Form'!E73/VLOOKUP('Input Form'!O73,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D90=0,\"\",'Project Information'!D90)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q74=$AF$6,1,IF(Q74=$AF$7,2,IF(Q74=$AF$8,IF(P74=$AF$3,E74/VLOOKUP(O74,'Art. List'!I64:K74,2,FALSE),IF('Input Form'!P74='Input Form'!$AF$4,'Input Form'!E74/VLOOKUP('Input Form'!O74,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D91=0,\"\",'Project Information'!D91)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q75=$AF$6,1,IF(Q75=$AF$7,2,IF(Q75=$AF$8,IF(P75=$AF$3,E75/VLOOKUP(O75,'Art. List'!I65:K75,2,FALSE),IF('Input Form'!P75='Input Form'!$AF$4,'Input Form'!E75/VLOOKUP('Input Form'!O75,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D92=0,\"\",'Project Information'!D92)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q76=$AF$6,1,IF(Q76=$AF$7,2,IF(Q76=$AF$8,IF(P76=$AF$3,E76/VLOOKUP(O76,'Art. List'!I66:K76,2,FALSE),IF('Input Form'!P76='Input Form'!$AF$4,'Input Form'!E76/VLOOKUP('Input Form'!O76,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D93=0,\"\",'Project Information'!D93)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q77=$AF$6,1,IF(Q77=$AF$7,2,IF(Q77=$AF$8,IF(P77=$AF$3,E77/VLOOKUP(O77,'Art. List'!I67:K77,2,FALSE),IF('Input Form'!P77='Input Form'!$AF$4,'Input Form'!E77/VLOOKUP('Input Form'!O77,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D94=0,\"\",'Project Information'!D94)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q78=$AF$6,1,IF(Q78=$AF$7,2,IF(Q78=$AF$8,IF(P78=$AF$3,E78/VLOOKUP(O78,'Art. List'!I68:K78,2,FALSE),IF('Input Form'!P78='Input Form'!$AF$4,'Input Form'!E78/VLOOKUP('Input Form'!O78,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D95=0,\"\",'Project Information'!D95)","v":""},null,null,null,null,null,null,null,{"$f":"ROUNDUP(IF(I79=$AH$6,E79/1.5,IF(I79=$AH$7,E79/3,IF(I79=$AH$8,E79/4.5,IF(I79=$AH$9,K79,0)))),)","v":0},null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q79=$AF$6,1,IF(Q79=$AF$7,2,IF(Q79=$AF$8,IF(P79=$AF$3,E79/VLOOKUP(O79,'Art. List'!I69:K79,2,FALSE),IF('Input Form'!P79='Input Form'!$AF$4,'Input Form'!E79/VLOOKUP('Input Form'!O79,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D96=0,\"\",'Project Information'!D96)","v":""},null,null,null,null,null,null,null,0,null,0,{"$f":"IF(ISBLANK(I80),\"\",IF(I80=$AH$7,IF(RIGHT(E80/3-TRUNC(E80/3),1)=\"5\",$AH$13,$AH$14),IF(I80=$AH$8,IF(RIGHT(E80/4.5-TRUNC(E80/4.5),1)=\"3\",$AH$13,$AH$14),IF(I80=$AH$6,$AH$13,$AH$15))))","v":""},null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q80=$AF$6,1,IF(Q80=$AF$7,2,IF(Q80=$AF$8,IF(P80=$AF$3,E80/VLOOKUP(O80,'Art. List'!I70:K80,2,FALSE),IF('Input Form'!P80='Input Form'!$AF$4,'Input Form'!E80/VLOOKUP('Input Form'!O80,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D97=0,\"\",'Project Information'!D97)","v":""},null,null,null,null,null,null,null,0,null,{"$f":"E81/1.5-J81","v":0},"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q81=$AF$6,1,IF(Q81=$AF$7,2,IF(Q81=$AF$8,IF(P81=$AF$3,E81/VLOOKUP(O81,'Art. List'!I71:K81,2,FALSE),IF('Input Form'!P81='Input Form'!$AF$4,'Input Form'!E81/VLOOKUP('Input Form'!O81,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D98=0,\"\",'Project Information'!D98)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q82=$AF$6,1,IF(Q82=$AF$7,2,IF(Q82=$AF$8,IF(P82=$AF$3,E82/VLOOKUP(O82,'Art. List'!I72:K82,2,FALSE),IF('Input Form'!P82='Input Form'!$AF$4,'Input Form'!E82/VLOOKUP('Input Form'!O82,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D99=0,\"\",'Project Information'!D99)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q83=$AF$6,1,IF(Q83=$AF$7,2,IF(Q83=$AF$8,IF(P83=$AF$3,E83/VLOOKUP(O83,'Art. List'!I73:K83,2,FALSE),IF('Input Form'!P83='Input Form'!$AF$4,'Input Form'!E83/VLOOKUP('Input Form'!O83,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D100=0,\"\",'Project Information'!D100)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q84=$AF$6,1,IF(Q84=$AF$7,2,IF(Q84=$AF$8,IF(P84=$AF$3,E84/VLOOKUP(O84,'Art. List'!I74:K84,2,FALSE),IF('Input Form'!P84='Input Form'!$AF$4,'Input Form'!E84/VLOOKUP('Input Form'!O84,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D101=0,\"\",'Project Information'!D101)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q85=$AF$6,1,IF(Q85=$AF$7,2,IF(Q85=$AF$8,IF(P85=$AF$3,E85/VLOOKUP(O85,'Art. List'!I75:K85,2,FALSE),IF('Input Form'!P85='Input Form'!$AF$4,'Input Form'!E85/VLOOKUP('Input Form'!O85,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D102=0,\"\",'Project Information'!D102)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q86=$AF$6,1,IF(Q86=$AF$7,2,IF(Q86=$AF$8,IF(P86=$AF$3,E86/VLOOKUP(O86,'Art. List'!I76:K86,2,FALSE),IF('Input Form'!P86='Input Form'!$AF$4,'Input Form'!E86/VLOOKUP('Input Form'!O86,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D103=0,\"\",'Project Information'!D103)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q87=$AF$6,1,IF(Q87=$AF$7,2,IF(Q87=$AF$8,IF(P87=$AF$3,E87/VLOOKUP(O87,'Art. List'!I77:K87,2,FALSE),IF('Input Form'!P87='Input Form'!$AF$4,'Input Form'!E87/VLOOKUP('Input Form'!O87,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D104=0,\"\",'Project Information'!D104)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q88=$AF$6,1,IF(Q88=$AF$7,2,IF(Q88=$AF$8,IF(P88=$AF$3,E88/VLOOKUP(O88,'Art. List'!I78:K88,2,FALSE),IF('Input Form'!P88='Input Form'!$AF$4,'Input Form'!E88/VLOOKUP('Input Form'!O88,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D105=0,\"\",'Project Information'!D105)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q89=$AF$6,1,IF(Q89=$AF$7,2,IF(Q89=$AF$8,IF(P89=$AF$3,E89/VLOOKUP(O89,'Art. List'!I79:K89,2,FALSE),IF('Input Form'!P89='Input Form'!$AF$4,'Input Form'!E89/VLOOKUP('Input Form'!O89,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D106=0,\"\",'Project Information'!D106)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q90=$AF$6,1,IF(Q90=$AF$7,2,IF(Q90=$AF$8,IF(P90=$AF$3,E90/VLOOKUP(O90,'Art. List'!I80:K90,2,FALSE),IF('Input Form'!P90='Input Form'!$AF$4,'Input Form'!E90/VLOOKUP('Input Form'!O90,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D107=0,\"\",'Project Information'!D107)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q91=$AF$6,1,IF(Q91=$AF$7,2,IF(Q91=$AF$8,IF(P91=$AF$3,E91/VLOOKUP(O91,'Art. List'!I81:K91,2,FALSE),IF('Input Form'!P91='Input Form'!$AF$4,'Input Form'!E91/VLOOKUP('Input Form'!O91,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D108=0,\"\",'Project Information'!D108)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q92=$AF$6,1,IF(Q92=$AF$7,2,IF(Q92=$AF$8,IF(P92=$AF$3,E92/VLOOKUP(O92,'Art. List'!I82:K92,2,FALSE),IF('Input Form'!P92='Input Form'!$AF$4,'Input Form'!E92/VLOOKUP('Input Form'!O92,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D109=0,\"\",'Project Information'!D109)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q93=$AF$6,1,IF(Q93=$AF$7,2,IF(Q93=$AF$8,IF(P93=$AF$3,E93/VLOOKUP(O93,'Art. List'!I83:K93,2,FALSE),IF('Input Form'!P93='Input Form'!$AF$4,'Input Form'!E93/VLOOKUP('Input Form'!O93,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D110=0,\"\",'Project Information'!D110)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q94=$AF$6,1,IF(Q94=$AF$7,2,IF(Q94=$AF$8,IF(P94=$AF$3,E94/VLOOKUP(O94,'Art. List'!I84:K94,2,FALSE),IF('Input Form'!P94='Input Form'!$AF$4,'Input Form'!E94/VLOOKUP('Input Form'!O94,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D111=0,\"\",'Project Information'!D111)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q95=$AF$6,1,IF(Q95=$AF$7,2,IF(Q95=$AF$8,IF(P95=$AF$3,E95/VLOOKUP(O95,'Art. List'!I85:K95,2,FALSE),IF('Input Form'!P95='Input Form'!$AF$4,'Input Form'!E95/VLOOKUP('Input Form'!O95,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D112=0,\"\",'Project Information'!D112)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q96=$AF$6,1,IF(Q96=$AF$7,2,IF(Q96=$AF$8,IF(P96=$AF$3,E96/VLOOKUP(O96,'Art. List'!I86:K96,2,FALSE),IF('Input Form'!P96='Input Form'!$AF$4,'Input Form'!E96/VLOOKUP('Input Form'!O96,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D113=0,\"\",'Project Information'!D113)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q97=$AF$6,1,IF(Q97=$AF$7,2,IF(Q97=$AF$8,IF(P97=$AF$3,E97/VLOOKUP(O97,'Art. List'!I87:K97,2,FALSE),IF('Input Form'!P97='Input Form'!$AF$4,'Input Form'!E97/VLOOKUP('Input Form'!O97,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D114=0,\"\",'Project Information'!D114)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q98=$AF$6,1,IF(Q98=$AF$7,2,IF(Q98=$AF$8,IF(P98=$AF$3,E98/VLOOKUP(O98,'Art. List'!I88:K98,2,FALSE),IF('Input Form'!P98='Input Form'!$AF$4,'Input Form'!E98/VLOOKUP('Input Form'!O98,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D115=0,\"\",'Project Information'!D115)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q99=$AF$6,1,IF(Q99=$AF$7,2,IF(Q99=$AF$8,IF(P99=$AF$3,E99/VLOOKUP(O99,'Art. List'!I89:K99,2,FALSE),IF('Input Form'!P99='Input Form'!$AF$4,'Input Form'!E99/VLOOKUP('Input Form'!O99,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D116=0,\"\",'Project Information'!D116)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q100=$AF$6,1,IF(Q100=$AF$7,2,IF(Q100=$AF$8,IF(P100=$AF$3,E100/VLOOKUP(O100,'Art. List'!I90:K100,2,FALSE),IF('Input Form'!P100='Input Form'!$AF$4,'Input Form'!E100/VLOOKUP('Input Form'!O100,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D117=0,\"\",'Project Information'!D117)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q101=$AF$6,1,IF(Q101=$AF$7,2,IF(Q101=$AF$8,IF(P101=$AF$3,E101/VLOOKUP(O101,'Art. List'!I91:K101,2,FALSE),IF('Input Form'!P101='Input Form'!$AF$4,'Input Form'!E101/VLOOKUP('Input Form'!O101,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D118=0,\"\",'Project Information'!D118)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q102=$AF$6,1,IF(Q102=$AF$7,2,IF(Q102=$AF$8,IF(P102=$AF$3,E102/VLOOKUP(O102,'Art. List'!I92:K102,2,FALSE),IF('Input Form'!P102='Input Form'!$AF$4,'Input Form'!E102/VLOOKUP('Input Form'!O102,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D119=0,\"\",'Project Information'!D119)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q103=$AF$6,1,IF(Q103=$AF$7,2,IF(Q103=$AF$8,IF(P103=$AF$3,E103/VLOOKUP(O103,'Art. List'!I93:K103,2,FALSE),IF('Input Form'!P103='Input Form'!$AF$4,'Input Form'!E103/VLOOKUP('Input Form'!O103,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D120=0,\"\",'Project Information'!D120)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q104=$AF$6,1,IF(Q104=$AF$7,2,IF(Q104=$AF$8,IF(P104=$AF$3,E104/VLOOKUP(O104,'Art. List'!I94:K104,2,FALSE),IF('Input Form'!P104='Input Form'!$AF$4,'Input Form'!E104/VLOOKUP('Input Form'!O104,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D121=0,\"\",'Project Information'!D121)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q105=$AF$6,1,IF(Q105=$AF$7,2,IF(Q105=$AF$8,IF(P105=$AF$3,E105/VLOOKUP(O105,'Art. List'!I95:K105,2,FALSE),IF('Input Form'!P105='Input Form'!$AF$4,'Input Form'!E105/VLOOKUP('Input Form'!O105,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D122=0,\"\",'Project Information'!D122)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q106=$AF$6,1,IF(Q106=$AF$7,2,IF(Q106=$AF$8,IF(P106=$AF$3,E106/VLOOKUP(O106,'Art. List'!I96:K106,2,FALSE),IF('Input Form'!P106='Input Form'!$AF$4,'Input Form'!E106/VLOOKUP('Input Form'!O106,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D123=0,\"\",'Project Information'!D123)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q107=$AF$6,1,IF(Q107=$AF$7,2,IF(Q107=$AF$8,IF(P107=$AF$3,E107/VLOOKUP(O107,'Art. List'!I97:K107,2,FALSE),IF('Input Form'!P107='Input Form'!$AF$4,'Input Form'!E107/VLOOKUP('Input Form'!O107,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D124=0,\"\",'Project Information'!D124)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q108=$AF$6,1,IF(Q108=$AF$7,2,IF(Q108=$AF$8,IF(P108=$AF$3,E108/VLOOKUP(O108,'Art. List'!I98:K108,2,FALSE),IF('Input Form'!P108='Input Form'!$AF$4,'Input Form'!E108/VLOOKUP('Input Form'!O108,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D125=0,\"\",'Project Information'!D125)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q109=$AF$6,1,IF(Q109=$AF$7,2,IF(Q109=$AF$8,IF(P109=$AF$3,E109/VLOOKUP(O109,'Art. List'!I99:K109,2,FALSE),IF('Input Form'!P109='Input Form'!$AF$4,'Input Form'!E109/VLOOKUP('Input Form'!O109,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D126=0,\"\",'Project Information'!D126)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q110=$AF$6,1,IF(Q110=$AF$7,2,IF(Q110=$AF$8,IF(P110=$AF$3,E110/VLOOKUP(O110,'Art. List'!I100:K110,2,FALSE),IF('Input Form'!P110='Input Form'!$AF$4,'Input Form'!E110/VLOOKUP('Input Form'!O110,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D127=0,\"\",'Project Information'!D127)","v":""},null,null,null,null,null,null,null,{"$f":"ROUNDUP(IF(I111=$AH$6,E111/1.5,IF(I111=$AH$7,E111/3,IF(I111=$AH$8,E111/4.5,IF(I111=$AH$9,K111,0)))),)","v":0},null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q111=$AF$6,1,IF(Q111=$AF$7,2,IF(Q111=$AF$8,IF(P111=$AF$3,E111/VLOOKUP(O111,'Art. List'!I101:K111,2,FALSE),IF('Input Form'!P111='Input Form'!$AF$4,'Input Form'!E111/VLOOKUP('Input Form'!O111,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D128=0,\"\",'Project Information'!D128)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q112=$AF$6,1,IF(Q112=$AF$7,2,IF(Q112=$AF$8,IF(P112=$AF$3,E112/VLOOKUP(O112,'Art. List'!I102:K112,2,FALSE),IF('Input Form'!P112='Input Form'!$AF$4,'Input Form'!E112/VLOOKUP('Input Form'!O112,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D129=0,\"\",'Project Information'!D129)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q113=$AF$6,1,IF(Q113=$AF$7,2,IF(Q113=$AF$8,IF(P113=$AF$3,E113/VLOOKUP(O113,'Art. List'!I103:K113,2,FALSE),IF('Input Form'!P113='Input Form'!$AF$4,'Input Form'!E113/VLOOKUP('Input Form'!O113,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]
[null,{"$f":"IF('Project Information'!D130=0,\"\",'Project Information'!D130)","v":""},null,null,null,null,null,null,null,0,null,0,"",null,null,null,null,{"$f":"IFERROR(ROUNDUP(IF(Q114=$AF$6,1,IF(Q114=$AF$7,2,IF(Q114=$AF$8,IF(P114=$AF$3,E114/VLOOKUP(O114,'Art. List'!I104:K114,2,FALSE),IF('Input Form'!P114='Input Form'!$AF$4,'Input Form'!E114/VLOOKUP('Input Form'!O114,'Art. List'!$I$5:$K$15,3,FALSE),0)),$AH$15))),0),0)","v":0}]

{"sheet":"Trunking Translation","index":3,"n_rows":88,"n_cols":13,"rows_kept":88,"cut":false,"hidden":true,"merged":[[59,0,69,0],[1,0,10,0],[12,0,22,0],[24,0,26,0],[28,0,44,0],[46,0,57,0]]}
[{"$f":"IF('Project Information'!$E$3='Trunking Translation'!M1,1,IF('Project Information'!$E$3='Trunking Translation'!M2,2,IF('Project Information'!$E$3='Trunking Translation'!M3,3,IF('Project Information'!$E$3='Trunking Translation'!M4,4,IF('Project Information'!$E$3='Trunking Translation'!M5,5,IF('Project Information'!$E$3='Trunking Translation'!M6,6,IF('Project Information'!$E$3='Trunking Translation'!M7,7,\"\")))))))","v":1},null,"English","Nederlands","German","Italian","French","Spanish","Polish",null,null,null,"English"]
["Navigation Panel ",{"$f":"CONCATENATE(\"1. \",VLOOKUP(C2,$C:$L,$A$1,FALSE))","v":"1. Start Page"},"Start Page","Begin pagina","Startseite","Pagina iniziale","Page d'accueil","Página de inicio","Strona startowa",null,null,null,"Nederlands"]
[null,{"$f":"CONCATENATE(\"2. \",VLOOKUP(C3,$C:$L,$A$1,FALSE))","v":"2. Input Form"},"Input Form","Invulformulier","Eingabeformular","Modulo di input","Formulaire de saisie","Formulario de entrada","Formularz wejściowy",null,null,null,"Deutsch"]
[null,{"$f":"CONCATENATE(\"3. \",VLOOKUP(C4,$C:$L,$A$1,FALSE))","v":"3. Configurator"},"Configurator","Configurator","Konfigurator","Configuratore","Configurateur","Configurador","Konfigurator",null,null,null,"Italiano"]
[null,{"$f":"CONCATENATE(\"4. \",VLOOKUP(C5,$C:$L,$A$1,FALSE))","v":"4. Quotation"},"Quotation","Offerte","Angebot","Quotazione","Devis","Presupuesto","Wycena",null,null,null,"Français "]
[null,{"$f":"CONCATENATE(\"5. \",VLOOKUP(C6,$C:$L,$A$1,FALSE))","v":"5. Save As"},"Save As","Opslaan als","Speichern als","Salva come","Sauvegarder comme","Guardar como","Zapisz jako",null,null,null,"Español"]
[null,{"$f":"CONCATENATE(\"6. \",VLOOKUP(C7,$C:$L,$A$1,FALSE))","v":"6. Export PDF"},"Export PDF","Exporteer PDF","Export PDF","Esporta PDF","Exportation PDF","Exportar como PDF","Eksport do PDF",null,null,null,"Polski"]
[null,{"$f":"VLOOKUP(C8,$C:$L,$A$1,FALSE)","v":"Export Excel"},"Export Excel","Exporteer Excel","Export Excel","Esporta Excel","Exportation Excel","Exportar a Excel","Eksport do Excel"]
[null,{"$f":"VLOOKUP(C9,$C:$L,$A$1,FALSE)","v":"Clear Input"},"Clear Input","Wis input","Eingabe löschen","Cancella input","Effacer saisie","Borrar información","Wyczyść dane wejściowe"]
[null,{"$f":"VLOOKUP(C10,$C:$L,$A$1,FALSE)","v":"Update"},"Update","Updaten","Aktualisieren","Aggiornamento","Mise à jour","Actualizar","Aktualizuj"]
[null,{"$f":"VLOOKUP(C11,$C:$L,$A$1,FALSE)","v":"Clear All"},"Clear All","Wis alles","Alles löschen","Cancella tutto","Effacer tout","Borrarlo todo","Wyczyść wszystko"]
[null,null,null,null,null,""]
["Start Page",{"$f":"VLOOKUP(C13,$C:$L,$A$1,FALSE)","v":"OPPLE LED Trunking Configurator"},"OPPLE LED Trunking Configurator","OPPLE LED Trunking Configurator","OPPLE LED Lichtband-Konfigurator","Configuratore Sistema a Binario LED OPPLE","Configurateur rail précâblé OPPLE LEDTrunking","Configurador del sistema Trunking LED de OPPLE","Konfigurator listew oświetleniowych OPPLE LED"]
[null,"Project Information","Project Information","Project informatie","Projektinformation","Informazioni sul progetto","Information projet","Información del proyecto","Informacje o projekcie"]
[null,"Project Name*","Project Name*","Projectnaam*","Projektname*","Nome del progetto*","Nom du projet*","Nombre del proyecto*","Nazwa projektu*"]
[null,"Wholesaler","Wholesaler","Groothandel","Händler","Grossista","Grossiste","Mayorista","Hurtownik"]
[null,"Installer","Installer","Installateur","Installateur","Installatore","Installateur","Instalador","Instalator"]
[null,"OPPLE Lighting B.V Information","OPPLE Lighting B.V Information","OPPLE Lighting. B.V. Informatie","OPPLE Lighting B.V. Information","Informazioni su OPPLE Lighting B.V.","Information OPPLE Lighting B.V.","Información OPPLE Lighting B.V","Informacje o OPPLE Lighting B.V"]
[null,"Representative*","Representative*","Vertegenwoordiger*","Verkäufer*","Venditore*","Représentant*","Responsable comercial*","Przedstawiciel*"]
[null,"Date","Date","Datum","Datum","Data","Date","Fecha","Data"]
[null,"Project Remark","Project Remark","Project opmerkingen","Angaben zum Projekt","Commenti sul progetto","Remarques sur le projet","Observaciones sobre el proyecto","Uwagi dotyczące projektu"]
[null,"Section Name & Remark","Section Name & Remark","Sectie naam & opmerkingen","Bez. Abteilung u. Anmerkung","Nome della sezione & commenti","Section Nom & Remarque","Observaciones y nombre de la sección","Nazwa sekcji i uwagi"]
[null,"Section","Section","Sectie","Halle","Sezione","de fichier","Sección","Sekcja"]
[null,null,null,null,null,""]
["Sheet Title",{"$f":"VLOOKUP(C25,$C:$L,$A$1,FALSE)","v":"OPPLE LED Trunking: Input Form"},"OPPLE LED Trunking: Input Form","OPPLE LED Trunking: Invulformulier","OPPLE LED Lichtband: Eingabeformular","Binario LED OPPLE: informazioni per creare il sistema","Rail précâblé OPPLE LED : Formulaire de saisie","Sistema Trunking LED de OPPLE: Formulario de entrada","Konfigurator listew oświetleniowych OPPLE LED: Formularz wejściowy"]
[null,{"$f":"VLOOKUP(C26,$C:$L,$A$1,FALSE)","v":"OPPLE LED Trunking Configurator"},"OPPLE LED Trunking Configurator","OPPLE LED Trunking Configurator","OPPLE LED Lichtband-Konfigurator","Configuratore Sistema a Binario LED OPPLE","Configurateur rail précâblé OPPLE LEDTrunking","Configurador del sistema Trunking LED de OPPLE","Konfigurator listew oświetleniowych OPPLE LED"]
[null,{"$f":"VLOOKUP(C27,$C:$L,$A$1,FALSE)","v":"OPPLE LED Trunking: Total Gross Price and Product list"},"OPPLE LED Trunking: Total Gross Price and Product list","OPPLE LED Trunking: Bruto Prijs en Product lijst","OPPLE LED Tragschienen: Brutto Gesamtpreis und Produktübersicht","Binario LED OPPLE: Lista prodotti e prezzi di listino","Rail précâblé OPPLE LED : Total prix publics htva et liste de produits","Sistema Trunking LED de OPPLE: PVP  y lista de productos","Listwa oświetleniowa OPPLE LED: Całkowita cena brutto i lista produktów"]
[null,null,null,null,null,""]
["Headers",{"$f":"VLOOKUP(C29,$C:$L,$A$1,FALSE)","v":"LED Module"},"LED Module","LED Module bezetting","LED-Module ","Modulo LED","Module LED","Módulo LED","Moduł LED"]
[null,"No. of Lines","No. of Lines","Aantal lijnen","Anzahl der Lichtbänder","N. di linee","Nombre de lignes","Núm. de líneas","Nr przewodów"]
[null,"Length per line (m)","Length per line (m)","Lengte per lijn (m)","Länge pro Lichtband (in meter)","Lunghezza per linea (m)","Longueur par ligne (m)","Longitud por línea (m)","Długość na przewód (m)"]
[null,"Feed-in-box","Feed-in-box","Feed-in box","Feed-in-Box ( Endeinspeisung)","Box alimentazione","Boîte d'alimentation","Caja alimentación","Puszka instalacyjna"]
[null,"Mounting Method","Mounting Method","Montage methode","Befestigungsart","Montaggio","Méthode de montage","Método de montaje","Metoda montażu"]
[null,"LED Module Occupation per Line","LED Module Occupation per Line","LED Modulebezetting per Lijn","LED-Modul-Belegung pro Lichtband","Posizione del modulo LED per linea","Occupation LED Module par ligne","Ocupación del módulo LED por línea","Zajęty moduł LED na przewód"]
[null,"Custom Amount","Custom Amount","Aangepast aantal","Selbstfestgelegte Anzahl","Importo personalizzato","Quantité personnalisée","Personalizar cantidad","Kwota niestandardowa"]
[null,"LED Modules per Line","LED Modules per Line","LED Modules per lijn","LED-Module pro Lichtband","Moduli LED per linea","LED Modules par ligne","Módulos LED por línea","Moduły LED na przewód"]
[null,"Line ends with LED Module?","Line ends with LED Module?","Lijn eindigt met LED Module? ","Lichtband endet mit LED-Modul?","La linea termina con modulo LED?","Fins de ligne avec Module LED ?","¿Acaba la línea con el módulo LED?","Czy przewód kończy się modułem LED?"]
[null,"Article Code","Article Code","Artikel Code","Artikelcode","Codice articolo","Code article","Código de artículo","Kod artykułu"]
[null,"Article Description","Article Description","Artikel omschrijving","Artikelbeschreibung","Descrizione articolo","Description article","Descripción de artículo","Opis artykułu"]
[null,"Number of products needed","Number of products needed","Aantal benodigde producten","Anzahl benötigte Produkte","Numero di prodotti necessari","Nombre de produits souhaité","Cantidad necesaria de productos","Liczba potrzebnych produktów"]
[null,"Unit Gross Price","Unit Gross Price","Eenheid bruto prijs","Bruttopreis pro Einheit","Prezzo netto","Prix bruts unitaires","PVP por unidad","Cena jednostkowa brutto"]
[null,"Total Gross Price","Total Gross Price","Totale bruto prijs","Gesamt-Bruttopreis","Prezzo nettototale","Total prix brut htva","Precio total PVP ","Całkowita cena brutto"]
[null,"Remarks","Remarks","Opmerkingen","Anmerkungen","Commenti","Remarques","Observaciones","Uwagi"]
[null,"Quantity Needed","Quantity Needed","Aantal nodig","Benötigte Menge","Quantità necessaria","Quantité souhaitée","Cantidad necesaria","Potrzebna liczba"]
[null,"Power","Power","Vermogen","Stromversorgung","Alimentazione","Puissance","Alimentación","Moc"]
[null,null,null,null,null,""]
["Inputs",{"$f":"VLOOKUP(C47,$C:$L,$A$1,FALSE)","v":"Yes"},"Yes","Ja","Ja","Sì","Oui","Sí","Tak"]
[null,"No","No","Nee","Nein","No","Non","No","Nie"]
[null,"Mounting Clip Chain","Mounting Clip Chain","Montagebeugel voor ketting","Montageklammer-für Knotenkette","Catena di montaggio clip","Montage chaîne à pince","Cadena con clip de montaje","Łańcuch z zaciskiem montażowym"]
[null,"Cord 3m","Cord 3m","Kabel 3m","Stahlseil 3 m","Cavo 3 m","Corde 3m","Cuerda 3 m","Przewód 3 m"]
[null,"Mounting Clip","Mounting Clip","Montagebeugel","Montageklammer","Clip di montaggio","Montage pince de fixation","Clip de montaje","Zacisk montażowy"]
[null,"Full","Full","Volledig","Voll","Completo","À plein","Completo","Całe"]
[null,"Half","Half","Helft","Halb","Metà","À moitié","Mitad","Połowa"]
[null,"One-Third","One-Third","Een-derde","Ein Drittel","Un terzo","Un tiers","Un tercio","Jedna trzecia"]
[null,"Custom","Custom","Aangepast","Kundenspezifisch ","Personalizzato","Personnalisation","Personalizar","Niestandardowe"]
[null,"Update","Update","Updaten","Aktualisieren","Aggiornamento","Mise à jour","Actualizar","Aktualizuj"]
[null,"Unknown","Unknown","Onbekend","Unbekannt","Sconosciuto","Inconnu","Desconocido","Nieznane"]
[null,"Only needed in case not already present in the installation","Only needed in case not already present in the installation","Alleen nodig indien niet aanwezig in de installatie. ","Nur erforderlich, wenn nicht bereits in die Installation aufgenommen.","Necessario solo nel caso non sia già presente nell'impianto","Seulement nécessaire pour autant qu’absent de l'installation","Solo hacen falta si no están en la instalación","Potrzebne wyłącznie wówczas, jeśli nie znajdują się już w instalacji"]
[null,null,null,null,null,""]
["Message Box",{"$f":"VLOOKUP(C60,$C:$L,$A$1,FALSE)","v":"Cancel clicked"},"Cancel clicked","Annuleer geklikt","Abbruch angeklickt","Annulla","Annulez verrouillage","Se hizo clic en «anular»","Kliknięto na anuluj"]
[null,"Could not create PDF file","Could not create PDF file","Can de PDF file niet creeëren","PDF-Datei konnte nicht erstellt werden","Impossibile creare file PDF","Impossible de créer fichier PDF","No se pudo crear un archivo PDF","Nie udało się utworzyć pliku PDF"]
[null,"There is no project name","There is no project name","Er is geen project naam","Kein Projektname eingegeben","Non esiste un nome di progetto","Pas de nom de projet","El proyecto no tiene nombre","Nie ma nazwy projektu"]
[null,"You saved file","You saved file","Je hebt het bestand opgeslagen","Datei wurde gespeichert","Hai salvato il file","Vous avez sauvegardé le fichier","Archivo guardado","Zapisano plik"]
[null,"Customizable Quotation is created!","Customizable Quotation is created!","Aangepaste offerte is gecreeërd!","Ein (kundenspezisches) Angebot wurde erstellt!","La quotazione personalizzabile è stato creata!","Un devis personnalisable a été créé","¡Se creó un presupuesto personalizado!","Utworzono niestandardową wycenę"]
[null,"File not open","File not open","Bestand niet open","Datei nicht geöffnet","File non aperto","Le Fichier n’est pas ouvert","El archivo no se abre","Plik nie jest otwarty"]
[null,"Input Data Successfully!","Input Data Successfully!","Data succesvol ingevuld!","Dateneingabe war erfolgreich!","Inserimento dati riuscito!","Les données ont été encodées avec succès !","Datos introducidos correctamente","Pomyślnie wprowadzono dane!"]
[null,"The process may take around 10 to 20 seconds. Please wait!","The process may take around 10 to 20 seconds. Please wait!","Dit proces kan 10 tot 20 seconden duren. Even geduld!","Der Vorgang kann etwa 10 bis 20 Sekunden dauern. Bitte einen Moment warten!","Il processo può richiedere da 10 a 20 secondi circa. Attendere prego!","Le processus doit prendre entre 10 & 20 secondes Veuillez patienter !","El proceso puede tardar entre 10 y 20 segundos. Espere.","Ten proces może potrwać od 10 do 20 sekund. Prosimy czekać!"]
[null,"Please fill in all information for the sections.","Please fill in all information for the sections.","Vul voor iedere sectie alle informatie in.","Bitte füllen Sie alle Informationen für die Abschnitte aus.","Si prega di compilare tutte le informazioni","Veuillez remplir toutes les informations concernant les sections.","Complete toda la información de las secciones.","Prosimy podać wszystkie informacje w sekcjach."]
[null,"The file is saved!","The file is saved!","Het bestand is opgeslagen!","Die Datei wurde gespeichert!","Il file è salvato!","Le fichier a été sauvegardé !","Se guardó el archivo.","Plik został zapisany!"]
[null,"Length is not appropriate, the length will be round down","Length is not appropriate, the length will be round down","De lengte is niet passend, de lengte wordt afgerond naar beneden","Die Länge ist nicht zulässig, die Länge wird abgerundet","La lunghezza non è disponibile e sarà arrotondata.","La longueur n'est pas appropriée, la longueur sera arrondie au chiffre inférieur","La longitud no es la correcta, se redondeará hacia abajo.","Długość nie jest prawidłowa i zostanie zaokrąglona w dół"]
[null,null,null,null,null,""]
[null,{"$f":"VLOOKUP(C72,$C:$L,$A$1,FALSE)","v":"Feed-out-box"},"Feed-out-box","Feed-out box","Einspeisebox","Scatola di alimentazione","Boîte de distribution","Caja de alimentación","Puszka instalacyjna"]
[null,"Sensor","Sensor","Sensor","Sensor","Sensore","Détecteur","Sensor","Czujnik"]
[null,"Installation Height (m)","Installation Height (m)","Installatiehoogte (m)","Einbauhöhe (m)","Altezza di installazione (m)","Hauteur d'installation (m)","Altura de instalación (m)","Wysokość instalacji (m)"]
[null,"Sensor Occupation per Line","Sensor Occupation per Line","Sensorbezetting per lijn","Sensorbelegung pro Linie","Occupazione del sensore per linea","Détecteur d'occupation par ligne","Sensor de ocupación por línea","Zajęcie czujnika na linię"]
[null,"Sensor Type","Sensor Type","Sensortype","Sensortyp","Tipo di sensore","Type de détecteur","Tipo de sensor","Rodzaj czujnika"]
[null,"No. of Sensors per Line","No. of Sensors per Line","Aantal sensoren per lijn","Anzahl der Sensoren pro Linie","Numero di sensori per linea","Nombre de détecteurs par ligne","Núm. de sensores por línea","Liczba czujników na linię"]
[null,"Dali Power Supply","Dali Power Supply","Dali stroomvoorziening","Dali-Netzteil","Alimentatore Dali","Chaîne d'alimentation  Dali","Suministro eléctrico Dali","Zasilacz Dali"]
[null,"Line ends with Trunking Cover?","Line ends with Trunking Cover?","Lijn eindigt met bedekking kabelgoot?","Linie endet mit Kanalendkappe?","La linea termina con la copertura trunking?","Fin de ligne avec couvercle de gaine ?","¿Acaba la línea con una funda de derivación?","Czy linia kończy się pokrywą koryta kablowego?"]
[null,"LIGHT LINE CONFIGURATION","LIGHT LINE CONFIGURATION","CONFIGURATIE LICHTLIJN","LICHTLINIENKONFIGURATION","CONFIGURAZIONE DELLA LINEA LUMINOSA","CONFIGURATION DE LA LIGNE D'ÉCLAIRAGE","CONFIGURACIÓN DE LA LÍNEA LUMÍNICA","KONFIGURACJA LINII ŚWIATŁA"]
[null,"ACCESSORY","ACCESSORY","ACCESSOIRE","ZUBEHÖR","ACCESSORIO","ACCESSOIRE","ACCESORIO","AKCESORIA"]
[null,{"$f":"UPPER(VLOOKUP(C82,$C:$L,$A$1,FALSE))","v":"SENSOR"},"SENSOR","SENSOR","SENSOR","SENSORE","DÉTECTEUR","SENSOR","CZUJNIK"]
[null,{"$f":"VLOOKUP(C83,$C:$L,$A$1,FALSE)","v":"Select Print Area"},"Select Print Area","Kies afdrukbereik","Druckbereich auswählen","Selezionare l'area di stampa","Sélectionnez la zone d'impression","Seleccionar área de impresión","Wybierz obszar wydruku"]
[null,{"$f":"VLOOKUP(C84,$C:$L,$A$1,FALSE)","v":"Begin"},"Begin","Begin","Anfang","Inizio","Début","Inicio","Początek"]
[null,{"$f":"VLOOKUP(C85,$C:$L,$A$1,FALSE)","v":"Begin-End"},"Begin-End","Begin-Eind","Anfang-Ende","Inizio-fine","Début-Fin","Inicio-final","Początek-koniec"]
[null,{"$f":"VLOOKUP(C86,$C:$L,$A$1,FALSE) & \" \"","v":"The maximum number for this line is  "},"The maximum number for this line is ","Het maximum aantal voor deze lijn is","Die maximale Anzahl für dieses Lichtband","Il numero massimo per questa linea è","La quantité maximum pour cette ligne est ","El máximo número para esta línea es","Maksymalna liczba dla linii świetlnej "]
[null,{"$f":"VLOOKUP(C87,$C:$L,$A$1,FALSE)","v":"Blind Covers per line"},"Blind Covers per line","Blindplaten per lijn","Blenden pro Lichtband","Coperture cieche per linea","Nombre de couvertures de rail par ligne ","Tapas ciegas por línea","Liczba zaślepek dla linii świetlnej"]
[null,{"$f":"VLOOKUP(C88,$C:$L,$A$1,FALSE)","v":"To enable the PDF export of also the section data, please click the button \"No\" once, and afterwards set the correct print range manually in Excel.\nDid you already set the print range?"},"To enable the PDF export of also the section data, please click the button \"No\" once, and afterwards set the correct print range manually in Excel.\nDid you already set the print range?","Om de PDF uitvoer van de sectie gegevens mogelijk te maken gelieve eenmaal op de knop \"Nee\" drukken, en stel daarna het juiste printbereik handmatig in Excel.\nHeeft u het printbereik reeds ingesteld?","Klicken Sie auf \"No\", um die Daten der gewählten Abteilung in PDF zu exportieren und wählen Sie den Druckbereich in Excel.\nHaben Sie den Druckbereich bereits eingestellt?","Per esportare i dati della sezione in formato PDF, fare clic sul pulsante \"No\" e impostare manualmente il formato di stampa in Excel.\nHai già impostato l'intervallo di stampa?","Pour activer l’export PDF incluant la page des données, veuillez cliquer sur le bouton \"Non\", et par la suite sélectionnez manuellement la zone à imprimer dans le fichier excel.\nAvez-vous déjà défini la zone d'impression?","Para habilitar la exportación en archivo PDF de esta sección, por favor cliquee una vez el botón “No” y posteriormente elija manualmente el área correcta de impresión en Excel.\n¿Ya configuró el rango de impresión?","By wyeksportować dane wybranej sekcji do pliku PDF naciśnij przycisk \"Nie\" I wybierz ręcznie pole wydruku w Excelu.\nCzy ustawiłeś już zakres drukowania?"]

{"sheet":"Quotation","index":4,"n_rows":160,"n_cols":8,"rows_kept":160,"cut":false,"hidden":true,"merged":[[54,1,57,7],[53,1,53,7],[60,3,60,7],[61,3,61,7],[68,3,68,7],[69,3,69,7],[65,3,65,7],[59,1,59,7],[63,3,63,7],[64,3,64,7],[66,3,66,7],[67,3,67,7],[62,3,62,7],[12,1,14,1],[7,1,7,2],[8,4,8,5],[9,4,9,5],[4,1,6,7],[12,7,14,7],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[12,6,14,6],[75,3,75,7],[76,3,76,7],[77,3,77,7],[78,3,78,7],[79,3,79,7],[70,3,70,7],[71,3,71,7],[72,3,72,7],[73,3,73,7],[74,3,74,7],[85,3,85,7],[86,3,86,7],[87,3,87,7],[88,3,88,7],[89,3,89,7],[80,3,80,7],[81,3,81,7],[82,3,82,7],[83,3,83,7],[84,3,84,7],[95,3,95,7],[96,3,96,7],[97,3,97,7],[98,3,98,7],[99,3,99,7],[90,3,90,7],[91,3,91,7],[92,3,92,7],[93,3,93,7],[94,3,94,7],[105,3,105,7],[106,3,106,7],[107,3,107,7],[108,3,108,7],[109,3,109,7],[100,3,100,7],[101,3,101,7],[102,3,102,7],[103,3,103,7],[104,3,104,7],[115,3,115,7],[116,3,116,7],[117,3,117,7],[118,3,118,7],[119,3,119,7],[110,3,110,7],[111,3,111,7],[112,3,112,7],[113,3,113,7],[114,3,114,7],[125,3,125,7],[126,3,126,7],[127,3,127,7],[128,3,128,7],[129,3,129,7],[120,3,120,7],[121,3,121,7],[122,3,122,7],[123,3,123,7],[124,3,124,7],[135,3,135,7],[136,3,136,7],[137,3,137,7],[138,3,138,7],[139,3,139,7],[130,3,130,7],[131,3,131,7],[132,3,132,7],[133,3,133,7],[134,3,134,7],[145,3,145,7],[146,3,146,7],[147,3,147,7],[148,3,148,7],[149,3,149,7],[140,3,140,7],[141,3,141,7],[142,3,142,7],[143,3,143,7],[144,3,144,7],[155,3,155,7],[156,3,156,7],[157,3,157,7],[158,3,158,7],[159,3,159,7],[150,3,150,7],[151,3,151,7],[152,3,152,7],[153,3,153,7],[154,3,154,7]]}
[]
[]
[]
[]
[null,{"$f":"'Trunking Translation'!B27","v":"OPPLE LED Trunking: Total Gross Price and Product list"}]
[]
[]
[]
[null,{"$f":"'Project Information'!C9","v":"Project Name*"},{"$f":"IF(ISBLANK('Project Information'!F9),\"\",'Project Information'!F9)","v":""},null,{"$f":"'Project Information'!C17","v":"Representative*"},null,{"$f":"IF(ISBLANK('Project Information'!F17),\"\",'Project Information'!F17)","v":""}]
[null,{"$f":"'Project Information'!D11","v":"Wholesaler"},{"$f":"IF(ISBLANK('Project Information'!F11),\"\",'Project Information'!F11)","v":""},null,{"$f":"'Project Information'!D19","v":"Date"},null,{"$f":"'Project Information'!F19","v":"2021-06-04"}]
[null,{"$f":"'Project Information'!D13","v":"Installer"},{"$f":"IF(ISBLANK('Project Information'!F13),\"\",'Project Information'!F13)","v":""}]
[]
[null,{"$f":"'Trunking Translation'!$B$38","v":"Article Code"},{"$f":"'Trunking Translation'!$B$39","v":"Article Description"},{"$f":"'Trunking Translation'!$B$40","v":"Number of products needed"},{"$f":"'Trunking Translation'!$B$41","v":"Unit Gross Price"},{"$f":"'Trunking Translation'!$B$42","v":"Total Gross Price"},{"$f":"'Trunking Translation'!$B$43","v":"Remarks"},{"$f":"'Trunking Translation'!B45","v":"Power"}]
[null,{"$f":"'Trunking Translation'!$B$38","v":"Article Code"},{"$f":"'Trunking Translation'!$B$39","v":"Article Description"},{"$f":"'Trunking Translation'!$B$40","v":"Number of products needed"},{"$f":"'Trunking Translation'!$B$41","v":"Unit Gross Price"},{"$f":"'Trunking Translation'!$B$42","v":"Total Gross Price"},{"$f":"'Trunking Translation'!$C$43","v":"Remarks"}]
[null,{"$f":"'Trunking Translation'!$B$38","v":"Article Code"},{"$f":"'Trunking Translation'!$B$39","v":"Article Description"},{"$f":"'Trunking Translation'!$B$40","v":"Number of products needed"},{"$f":"'Trunking Translation'!$B$41","v":"Unit Gross Price"},{"$f":"'Trunking Translation'!$B$42","v":"Total Gross Price"},{"$f":"'Trunking Translation'!$C$43","v":"Remarks"}]
[null,542005008200,"LEDTrunking Module L15-35W-4000-120",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C16,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B16,'Art. List'!$C:$F,3,FALSE),0)","v":156},{"$f":"IFERROR(E16*D16,\"\")","v":0},null,{"$f":"_xlfn.IFNA(VLOOKUP(B16,'Art. List'!$C:$F,4,FALSE)*D16/1000,0)","v":0}]
[null,542005005800,"LEDTrunking Module L15-50W-4000-120",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C17,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B17,'Art. List'!$C:$F,3,FALSE),0)","v":179},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B17,'Art. List'!$C:$F,4,FALSE)*D17/1000,0)","v":0}]
[null,542005005900,"LEDTrunking Module L15-50W-4000-90",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C18,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B18,'Art. List'!$C:$F,3,FALSE),0)","v":179},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B18,'Art. List'!$C:$F,4,FALSE)*D18/1000,0)","v":0}]
[null,542005006000,"LEDTrunking Module L15-50W-4000-60",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C19,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B19,'Art. List'!$C:$F,3,FALSE),0)","v":179},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B19,'Art. List'!$C:$F,4,FALSE)*D19/1000,0)","v":0}]
[null,542005006100,"LEDTrunking Module L15-50W-4000-BW",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C20,Configurator!$D:$D)","v":260},{"$f":"_xlfn.IFNA(VLOOKUP(B20,'Art. List'!$C:$F,3,FALSE),0)","v":179},46540,null,{"$f":"_xlfn.IFNA(VLOOKUP(B20,'Art. List'!$C:$F,4,FALSE)*D20/1000,0)","v":13}]
[null,542005006200,"LEDTrunking Module L15-70W-4000-120",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C21,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B21,'Art. List'!$C:$F,3,FALSE),0)","v":257},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B21,'Art. List'!$C:$F,4,FALSE)*D21/1000,0)","v":0}]
[null,542005006300,"LEDTrunking Module L15-70W-4000-90",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C22,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B22,'Art. List'!$C:$F,3,FALSE),0)","v":257},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B22,'Art. List'!$C:$F,4,FALSE)*D22/1000,0)","v":0}]
[null,542005006400,"LEDTrunking Module L15-70W-4000-60",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C23,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B23,'Art. List'!$C:$F,3,FALSE),0)","v":257},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B23,'Art. List'!$C:$F,4,FALSE)*D23/1000,0)","v":0}]
[null,542005006500,"LEDTrunking Module L15-70W-4000-BW",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C24,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B24,'Art. List'!$C:$F,3,FALSE),0)","v":257},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B24,'Art. List'!$C:$F,4,FALSE)*D24/1000,0)","v":0}]
[null,542005008600,"LEDTrunking Module L15-35W-4000-120-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C25,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B25,'Art. List'!$C:$F,3,FALSE),0)","v":209},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B25,'Art. List'!$C:$F,4,FALSE)*D25/1000,0)","v":0}]
[null,542005006600,"LEDTrunking Module L15-50W-4000-120-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C26,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B26,'Art. List'!$C:$F,3,FALSE),0)","v":226},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B26,'Art. List'!$C:$F,4,FALSE)*D26/1000,0)","v":0}]
[null,542005006700,"LEDTrunking Module L15-50W-4000-90-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C27,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B27,'Art. List'!$C:$F,3,FALSE),0)","v":226},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B27,'Art. List'!$C:$F,4,FALSE)*D27/1000,0)","v":0}]
[null,542005006800,"LEDTrunking Module L15-50W-4000-60-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C28,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B28,'Art. List'!$C:$F,3,FALSE),0)","v":226},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B28,'Art. List'!$C:$F,4,FALSE)*D28/1000,0)","v":0}]
[null,542005006900,"LEDTrunking Module L15-50W-4000-BW-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C29,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B29,'Art. List'!$C:$F,3,FALSE),0)","v":226},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B29,'Art. List'!$C:$F,4,FALSE)*D29/1000,0)","v":0}]
[null,542005007000,"LEDTrunking Module L15-70W-4000-120-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C30,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B30,'Art. List'!$C:$F,3,FALSE),0)","v":305},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B30,'Art. List'!$C:$F,4,FALSE)*D30/1000,0)","v":0}]
[null,542005007100,"LEDTrunking Module L15-70W-4000-90-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C31,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B31,'Art. List'!$C:$F,3,FALSE),0)","v":305},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B31,'Art. List'!$C:$F,4,FALSE)*D31/1000,0)","v":0}]
[null,542005007200,"LEDTrunking Module L15-70W-4000-60-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C32,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B32,'Art. List'!$C:$F,3,FALSE),0)","v":305},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B32,'Art. List'!$C:$F,4,FALSE)*D32/1000,0)","v":0}]
[null,542005007300,"LEDTrunking Module L15-70W-4000-BW-DALI",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C33,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B33,'Art. List'!$C:$F,3,FALSE),0)","v":305},0,null,{"$f":"_xlfn.IFNA(VLOOKUP(B33,'Art. List'!$C:$F,4,FALSE)*D33/1000,0)","v":0}]
[null,542098001000,"LEDTrunking DALI Power Supply",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C34,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B34,'Art. List'!$C:$F,3,FALSE),0)","v":104},0]
[null,542098002100,"LEDTrunking Trunk 8 L15",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C35,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B35,'Art. List'!$C:$F,3,FALSE),0)","v":43.5},0]
[null,542098002300,"LEDTrunking Trunk 8 L30",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C36,Configurator!$D:$D)","v":120},{"$f":"_xlfn.IFNA(VLOOKUP(B36,'Art. List'!$C:$F,3,FALSE),0)","v":88},10560]
[null,542098001800,"LEDTrunking Cover L15",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C37,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B37,'Art. List'!$C:$F,3,FALSE),0)","v":14.5},0]
[null,542098002200,"LEDTrunking Trunk 8 L15 End Part",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C38,Configurator!$D:$D)","v":20},{"$f":"_xlfn.IFNA(VLOOKUP(B38,'Art. List'!$C:$F,3,FALSE),0)","v":43.5},870]
[null,542098002400,"LEDTrunking Trunk 8 L30 End Part",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C39,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B39,'Art. List'!$C:$F,3,FALSE),0)","v":88},0]
[null,542098001300,"LEDTrunking Feed-in Box 8",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C40,Configurator!$D:$D)","v":20},{"$f":"_xlfn.IFNA(VLOOKUP(B40,'Art. List'!$C:$F,3,FALSE),0)","v":62},1240]
[null,542098011200,"LEDTrunking Feed-out Box 8",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C41,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B41,'Art. List'!$C:$F,3,FALSE),0)","v":62},0]
[null,542098001700,"LEDTrunking End Cap",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C42,Configurator!$D:$D)","v":20},{"$f":"_xlfn.IFNA(VLOOKUP(B42,'Art. List'!$C:$F,3,FALSE),0)","v":9.5},190]
[null,542098011000,"LEDTrunking Cover End Cap",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C43,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B43,'Art. List'!$C:$F,3,FALSE),0)","v":9.5},{"$f":"IFERROR(E43*D43,\"\")","v":0}]
[null,542098003000,"LEDTrunking Cable Gland",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C44,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B44,'Art. List'!$C:$F,3,FALSE),0)","v":7.9},{"$f":"E44*D44","v":0}]
[null,542098001500,"LEDTrunking Feed-in Connector 8",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C45,Configurator!$D:$D)","v":0},{"$f":"_xlfn.IFNA(VLOOKUP(B45,'Art. List'!$C:$F,3,FALSE),0)","v":20},0]
[null,542098002900,"LEDTrunking Mounting Clip",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C46,Configurator!$D:$D)","v":0},{"$f":"VLOOKUP(B46,'Art. List'!C$7:E$41,3,0)","v":6.3},0]
[null,542098001900,"LEDTrunking Mounting Clip Chain",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C47,Configurator!$D:$D)","v":0},{"$f":"VLOOKUP(B47,'Art. List'!C$7:E$41,3,0)","v":7.4},0]
[null,542098002000,"LEDTrunking Cord-3m",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C48,Configurator!$D:$D)","v":140},{"$f":"VLOOKUP(B48,'Art. List'!C$7:E$41,3,0)","v":10.5},{"$f":"E48*D48","v":1470}]
[null,542098004600,"LEDTrunking Sensor Probe L",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C49,Configurator!$D:$D)","v":0},{"$f":"VLOOKUP(B49,'Art. List'!C$7:E$41,3,0)","v":314},{"$f":"E49*D49","v":0}]
[null,542098004700,"LEDTrunking Sensor Probe H",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C50,Configurator!$D:$D)","v":0},{"$f":"VLOOKUP(B50,'Art. List'!C$7:E$41,3,0)","v":471},{"$f":"E50*D50","v":0}]
[null,542098001100,"LEDTrunking Sensor Cover L15",{"$f":"SUMIF(Configurator!$C:$C,Quotation!C51,Configurator!$D:$D)","v":0},{"$f":"VLOOKUP(B51,'Art. List'!C$7:E$41,3,0)","v":51},{"$f":"E51*D51","v":0}]
[null,null,null,null,null,{"$f":"SUM(F16:F51)","v":60870},null,{"$f":"SUM(H16:H34)","v":13}]
[]
[null,{"$f":"'Trunking Translation'!B21","v":"Project Remark"}]
[null,{"$f":"IF(ISBLANK('Project Information'!B22),\"\",'Project Information'!B22)","v":""}]
[]
[]
[]
[]
[null,{"$f":"'Trunking Translation'!B22","v":"Section Name & Remark"}]
[1,{"$f":"'Project Information'!B31","v":"Section_1"},{"$f":"IF('Project Information'!D31=0,\"\",'Project Information'!D31)","v":""},{"$f":"IF(ISBLANK('Project Information'!H31),\"\",'Project Information'!H31)","v":""}]
[2,{"$f":"'Project Information'!B32","v":"Section_2"},{"$f":"IF('Project Information'!D32=0,\"\",'Project Information'!D32)","v":""},{"$f":"IF(ISBLANK('Project Information'!H32),\"\",'Project Information'!H32)","v":""}]
[3,{"$f":"'Project Information'!B33","v":"Section_3"},{"$f":"IF('Project Information'!D33=0,\"\",'Project Information'!D33)","v":""},{"$f":"IF(ISBLANK('Project Information'!H33),\"\",'Project Information'!H33)","v":""}]
[4,{"$f":"'Project Information'!B34","v":"Section_4"},{"$f":"IF('Project Information'!D34=0,\"\",'Project Information'!D34)","v":""},{"$f":"IF(ISBLANK('Project Information'!H34),\"\",'Project Information'!H34)","v":""}]
[5,{"$f":"'Project Information'!B35","v":"Section_5"},{"$f":"IF('Project Information'!D35=0,\"\",'Project Information'!D35)","v":""},{"$f":"IF(ISBLANK('Project Information'!H35),\"\",'Project Information'!H35)","v":""}]
[6,{"$f":"'Project Information'!B36","v":"Section_6"},{"$f":"IF('Project Information'!D36=0,\"\",'Project Information'!D36)","v":""},{"$f":"IF(ISBLANK('Project Information'!H36),\"\",'Project Information'!H36)","v":""}]
[7,{"$f":"'Project Information'!B37","v":"Section_7"},{"$f":"IF('Project Information'!D37=0,\"\",'Project Information'!D37)","v":""},{"$f":"IF(ISBLANK('Project Information'!H37),\"\",'Project Information'!H37)","v":""}]
[8,{"$f":"'Project Information'!B38","v":"Section_8"},{"$f":"IF('Project Information'!D38=0,\"\",'Project Information'!D38)","v":""},{"$f":"IF(ISBLANK('Project Information'!H38),\"\",'Project Information'!H38)","v":""}]
[9,{"$f":"'Project Information'!B39","v":"Section_9"},{"$f":"IF('Project Information'!D39=0,\"\",'Project Information'!D39)","v":""},{"$f":"IF(ISBLANK('Project Information'!H39),\"\",'Project Information'!H39)","v":""}]
[10,{"$f":"'Project Information'!B40","v":"Section_10"},{"$f":"IF('Project Information'!D40=0,\"\",'Project Information'!D40)","v":""},{"$f":"IF(ISBLANK('Project Information'!H40),\"\",'Project Information'!H40)","v":""}]
[11,{"$f":"'Project Information'!B41","v":"Section_11"},{"$f":"IF('Project Information'!D41=0,\"\",'Project Information'!D41)","v":""},{"$f":"IF(ISBLANK('Project Information'!H41),\"\",'Project Information'!H41)","v":""}]
[12,{"$f":"'Project Information'!B42","v":"Section_12"},{"$f":"IF('Project Information'!D42=0,\"\",'Project Information'!D42)","v":""},{"$f":"IF(ISBLANK('Project Information'!H42),\"\",'Project Information'!H42)","v":""}]
[13,{"$f":"'Project Information'!B43","v":"Section_13"},{"$f":"IF('Project Information'!D43=0,\"\",'Project Information'!D43)","v":""},{"$f":"IF(ISBLANK('Project Information'!H43),\"\",'Project Information'!H43)","v":""}]
[14,{"$f":"'Project Information'!B44","v":"Section_14"},{"$f":"IF('Project Information'!D44=0,\"\",'Project Information'!D44)","v":""},{"$f":"IF(ISBLANK('Project Information'!H44),\"\",'Project Information'!H44)","v":""}]
[15,{"$f":"'Project Information'!B45","v":"Section_15"},{"$f":"IF('Project Information'!D45=0,\"\",'Project Information'!D45)","v":""},{"$f":"IF(ISBLANK('Project Information'!H45),\"\",'Project Information'!H45)","v":""}]
[16,{"$f":"'Project Information'!B46","v":"Section_16"},{"$f":"IF('Project Information'!D46=0,\"\",'Project Information'!D46)","v":""},{"$f":"IF(ISBLANK('Project Information'!H46),\"\",'Project Information'!H46)","v":""}]
[17,{"$f":"'Project Information'!B47","v":"Section_17"},{"$f":"IF('Project Information'!D47=0,\"\",'Project Information'!D47)","v":""},{"$f":"IF(ISBLANK('Project Information'!H47),\"\",'Project Information'!H47)","v":""}]
[18,{"$f":"'Project Information'!B48","v":"Section_18"},{"$f":"IF('Project Information'!D48=0,\"\",'Project Information'!D48)","v":""},{"$f":"IF(ISBLANK('Project Information'!H48),\"\",'Project Information'!H48)","v":""}]
[19,{"$f":"'Project Information'!B49","v":"Section_19"},{"$f":"IF('Project Information'!D49=0,\"\",'Project Information'!D49)","v":""},{"$f":"IF(ISBLANK('Project Information'!H49),\"\",'Project Information'!H49)","v":""}]
[20,{"$f":"'Project Information'!B50","v":"Section_20"},{"$f":"IF('Project Information'!D50=0,\"\",'Project Information'!D50)","v":""},{"$f":"IF(ISBLANK('Project Information'!H50),\"\",'Project Information'!H50)","v":""}]
[21,{"$f":"'Project Information'!B51","v":"Section_21"},{"$f":"IF('Project Information'!D51=0,\"\",'Project Information'!D51)","v":""},{"$f":"IF(ISBLANK('Project Information'!H51),\"\",'Project Information'!H51)","v":""}]
[22,{"$f":"'Project Information'!B52","v":"Section_22"},{"$f":"IF('Project Information'!D52=0,\"\",'Project Information'!D52)","v":""},{"$f":"IF(ISBLANK('Project Information'!H52),\"\",'Project Information'!H52)","v":""}]
[23,{"$f":"'Project Information'!B53","v":"Section_23"},{"$f":"IF('Project Information'!D53=0,\"\",'Project Information'!D53)","v":""},{"$f":"IF(ISBLANK('Project Information'!H53),\"\",'Project Information'!H53)","v":""}]
[24,{"$f":"'Project Information'!B54","v":"Section_24"},{"$f":"IF('Project Information'!D54=0,\"\",'Project Information'!D54)","v":""},{"$f":"IF(ISBLANK('Project Information'!H54),\"\",'Project Information'!H54)","v":""}]
[25,{"$f":"'Project Information'!B55","v":"Section_25"},{"$f":"IF('Project Information'!D55=0,\"\",'Project Information'!D55)","v":""},{"$f":"IF(ISBLANK('Project Information'!H55),\"\",'Project Information'!H55)","v":""}]
[26,{"$f":"'Project Information'!B56","v":"Section_26"},{"$f":"IF('Project Information'!D56=0,\"\",'Project Information'!D56)","v":""},{"$f":"IF(ISBLANK('Project Information'!H56),\"\",'Project Information'!H56)","v":""}]
[27,{"$f":"'Project Information'!B57","v":"Section_27"},{"$f":"IF('Project Information'!D57=0,\"\",'Project Information'!D57)","v":""},{"$f":"IF(ISBLANK('Project Information'!H57),\"\",'Project Information'!H57)","v":""}]
[28,{"$f":"'Project Information'!B58","v":"Section_28"},{"$f":"IF('Project Information'!D58=0,\"\",'Project Information'!D58)","v":""},{"$f":"IF(ISBLANK('Project Information'!H58),\"\",'Project Information'!H58)","v":""}]
[29,{"$f":"'Project Information'!B59","v":"Section_29"},{"$f":"IF('Project Information'!D59=0,\"\",'Project Information'!D59)","v":""},{"$f":"IF(ISBLANK('Project Information'!H59),\"\",'Project Information'!H59)","v":""}]
[30,{"$f":"'Project Information'!B60","v":"Section_30"},{"$f":"IF('Project Information'!D60=0,\"\",'Project Information'!D60)","v":""},{"$f":"IF(ISBLANK('Project Information'!H60),\"\",'Project Information'!H60)","v":""}]
[31,{"$f":"'Project Information'!B61","v":"Section_31"},{"$f":"IF('Project Information'!D61=0,\"\",'Project Information'!D61)","v":""},{"$f":"IF(ISBLANK('Project Information'!H61),\"\",'Project Information'!H61)","v":""}]
[32,{"$f":"'Project Information'!B62","v":"Section_32"},{"$f":"IF('Project Information'!D62=0,\"\",'Project Information'!D62)","v":""},{"$f":"IF(ISBLANK('Project Information'!H62),\"\",'Project Information'!H62)","v":""}]
[33,{"$f":"'Project Information'!B63","v":"Section_33"},{"$f":"IF('Project Information'!D63=0,\"\",'Project Information'!D63)","v":""},{"$f":"IF(ISBLANK('Project Information'!H63),\"\",'Project Information'!H63)","v":""}]
[34,{"$f":"'Project Information'!B64","v":"Section_34"},{"$f":"IF('Project Information'!D64=0,\"\",'Project Information'!D64)","v":""},{"$f":"IF(ISBLANK('Project Information'!H64),\"\",'Project Information'!H64)","v":""}]
[35,{"$f":"'Project Information'!B65","v":"Section_35"},{"$f":"IF('Project Information'!D65=0,\"\",'Project Information'!D65)","v":""},{"$f":"IF(ISBLANK('Project Information'!H65),\"\",'Project Information'!H65)","v":""}]
[36,{"$f":"'Project Information'!B66","v":"Section_36"},{"$f":"IF('Project Information'!D66=0,\"\",'Project Information'!D66)","v":""},{"$f":"IF(ISBLANK('Project Information'!H66),\"\",'Project Information'!H66)","v":""}]
[37,{"$f":"'Project Information'!B67","v":"Section_37"},{"$f":"IF('Project Information'!D67=0,\"\",'Project Information'!D67)","v":""},{"$f":"IF(ISBLANK('Project Information'!H67),\"\",'Project Information'!H67)","v":""}]
[38,{"$f":"'Project Information'!B68","v":"Section_38"},{"$f":"IF('Project Information'!D68=0,\"\",'Project Information'!D68)","v":""},{"$f":"IF(ISBLANK('Project Information'!H68),\"\",'Project Information'!H68)","v":""}]
[39,{"$f":"'Project Information'!B69","v":"Section_39"},{"$f":"IF('Project Information'!D69=0,\"\",'Project Information'!D69)","v":""},{"$f":"IF(ISBLANK('Project Information'!H69),\"\",'Project Information'!H69)","v":""}]
[40,{"$f":"'Project Information'!B70","v":"Section_40"},{"$f":"IF('Project Information'!D70=0,\"\",'Project Information'!D70)","v":""},{"$f":"IF(ISBLANK('Project Information'!H70),\"\",'Project Information'!H70)","v":""}]
[41,{"$f":"'Project Information'!B71","v":"Section_41"},{"$f":"IF('Project Information'!D71=0,\"\",'Project Information'!D71)","v":""},{"$f":"IF(ISBLANK('Project Information'!H71),\"\",'Project Information'!H71)","v":""}]
[42,{"$f":"'Project Information'!B72","v":"Section_42"},{"$f":"IF('Project Information'!D72=0,\"\",'Project Information'!D72)","v":""},{"$f":"IF(ISBLANK('Project Information'!H72),\"\",'Project Information'!H72)","v":""}]
[43,{"$f":"'Project Information'!B73","v":"Section_43"},{"$f":"IF('Project Information'!D73=0,\"\",'Project Information'!D73)","v":""},{"$f":"IF(ISBLANK('Project Information'!H73),\"\",'Project Information'!H73)","v":""}]
[44,{"$f":"'Project Information'!B74","v":"Section_44"},{"$f":"IF('Project Information'!D74=0,\"\",'Project Information'!D74)","v":""},{"$f":"IF(ISBLANK('Project Information'!H74),\"\",'Project Information'!H74)","v":""}]
[45,{"$f":"'Project Information'!B75","v":"Section_45"},{"$f":"IF('Project Information'!D75=0,\"\",'Project Information'!D75)","v":""},{"$f":"IF(ISBLANK('Project Information'!H75),\"\",'Project Information'!H75)","v":""}]
[46,{"$f":"'Project Information'!B76","v":"Section_46"},{"$f":"IF('Project Information'!D76=0,\"\",'Project Information'!D76)","v":""},{"$f":"IF(ISBLANK('Project Information'!H76),\"\",'Project Information'!H76)","v":""}]
[47,{"$f":"'Project Information'!B77","v":"Section_47"},{"$f":"IF('Project Information'!D77=0,\"\",'Project Information'!D77)","v":""},{"$f":"IF(ISBLANK('Project Information'!H77),\"\",'Project Information'!H77)","v":""}]
[48,{"$f":"'Project Information'!B78","v":"Section_48"},{"$f":"IF('Project Information'!D78=0,\"\",'Project Information'!D78)","v":""},{"$f":"IF(ISBLANK('Project Information'!H78),\"\",'Project Information'!H78)","v":""}]
[49,{"$f":"'Project Information'!B79","v":"Section_49"},{"$f":"IF('Project Information'!D79=0,\"\",'Project Information'!D79)","v":""},{"$f":"IF(ISBLANK('Project Information'!H79),\"\",'Project Information'!H79)","v":""}]
[50,{"$f":"'Project Information'!B80","v":"Section_50"},{"$f":"IF('Project Information'!D80=0,\"\",'Project Information'!D80)","v":""},{"$f":"IF(ISBLANK('Project Information'!H80),\"\",'Project Information'!H80)","v":""}]
[51,{"$f":"'Project Information'!B81","v":"Section_51"},{"$f":"IF('Project Information'!D81=0,\"\",'Project Information'!D81)","v":""},{"$f":"IF(ISBLANK('Project Information'!H81),\"\",'Project Information'!H81)","v":""}]
[52,{"$f":"'Project Information'!B82","v":"Section_52"},{"$f":"IF('Project Information'!D82=0,\"\",'Project Information'!D82)","v":""},{"$f":"IF(ISBLANK('Project Information'!H82),\"\",'Project Information'!H82)","v":""}]
[53,{"$f":"'Project Information'!B83","v":"Section_53"},{"$f":"IF('Project Information'!D83=0,\"\",'Project Information'!D83)","v":""},{"$f":"IF(ISBLANK('Project Information'!H83),\"\",'Project Information'!H83)","v":""}]
[54,{"$f":"'Project Information'!B84","v":"Section_54"},{"$f":"IF('Project Information'!D84=0,\"\",'Project Information'!D84)","v":""},{"$f":"IF(ISBLANK('Project Information'!H84),\"\",'Project Information'!H84)","v":""}]
[55,{"$f":"'Project Information'!B85","v":"Section_55"},{"$f":"IF('Project Information'!D85=0,\"\",'Project Information'!D85)","v":""},{"$f":"IF(ISBLANK('Project Information'!H85),\"\",'Project Information'!H85)","v":""}]
[56,{"$f":"'Project Information'!B86","v":"Section_56"},{"$f":"IF('Project Information'!D86=0,\"\",'Project Information'!D86)","v":""},{"$f":"IF(ISBLANK('Project Information'!H86),\"\",'Project Information'!H86)","v":""}]
[57,{"$f":"'Project Information'!B87","v":"Section_57"},{"$f":"IF('Project Information'!D87=0,\"\",'Project Information'!D87)","v":""},{"$f":"IF(ISBLANK('Project Information'!H87),\"\",'Project Information'!H87)","v":""}]
[58,{"$f":"'Project Information'!B88","v":"Section_58"},{"$f":"IF('Project Information'!D88=0,\"\",'Project Information'!D88)","v":""},{"$f":"IF(ISBLANK('Project Information'!H88),\"\",'Project Information'!H88)","v":""}]
[59,{"$f":"'Project Information'!B89","v":"Section_59"},{"$f":"IF('Project Information'!D89=0,\"\",'Project Information'!D89)","v":""},{"$f":"IF(ISBLANK('Project Information'!H89),\"\",'Project Information'!H89)","v":""}]
[60,{"$f":"'Project Information'!B90","v":"Section_60"},{"$f":"IF('Project Information'!D90=0,\"\",'Project Information'!D90)","v":""},{"$f":"IF(ISBLANK('Project Information'!H90),\"\",'Project Information'!H90)","v":""}]
[61,{"$f":"'Project Information'!B91","v":"Section_61"},{"$f":"IF('Project Information'!D91=0,\"\",'Project Information'!D91)","v":""},{"$f":"IF(ISBLANK('Project Information'!H91),\"\",'Project Information'!H91)","v":""}]
[62,{"$f":"'Project Information'!B92","v":"Section_62"},{"$f":"IF('Project Information'!D92=0,\"\",'Project Information'!D92)","v":""},{"$f":"IF(ISBLANK('Project Information'!H92),\"\",'Project Information'!H92)","v":""}]
[63,{"$f":"'Project Information'!B93","v":"Section_63"},{"$f":"IF('Project Information'!D93=0,\"\",'Project Information'!D93)","v":""},{"$f":"IF(ISBLANK('Project Information'!H93),\"\",'Project Information'!H93)","v":""}]
[64,{"$f":"'Project Information'!B94","v":"Section_64"},{"$f":"IF('Project Information'!D94=0,\"\",'Project Information'!D94)","v":""},{"$f":"IF(ISBLANK('Project Information'!H94),\"\",'Project Information'!H94)","v":""}]
[65,{"$f":"'Project Information'!B95","v":"Section_65"},{"$f":"IF('Project Information'!D95=0,\"\",'Project Information'!D95)","v":""},{"$f":"IF(ISBLANK('Project Information'!H95),\"\",'Project Information'!H95)","v":""}]
[66,{"$f":"'Project Information'!B96","v":"Section_66"},{"$f":"IF('Project Information'!D96=0,\"\",'Project Information'!D96)","v":""},{"$f":"IF(ISBLANK('Project Information'!H96),\"\",'Project Information'!H96)","v":""}]
[67,{"$f":"'Project Information'!B97","v":"Section_67"},{"$f":"IF('Project Information'!D97=0,\"\",'Project Information'!D97)","v":""},{"$f":"IF(ISBLANK('Project Information'!H97),\"\",'Project Information'!H97)","v":""}]
[68,{"$f":"'Project Information'!B98","v":"Section_68"},{"$f":"IF('Project Information'!D98=0,\"\",'Project Information'!D98)","v":""},{"$f":"IF(ISBLANK('Project Information'!H98),\"\",'Project Information'!H98)","v":""}]
[69,{"$f":"'Project Information'!B99","v":"Section_69"},{"$f":"IF('Project Information'!D99=0,\"\",'Project Information'!D99)","v":""},{"$f":"IF(ISBLANK('Project Information'!H99),\"\",'Project Information'!H99)","v":""}]
[70,{"$f":"'Project Information'!B100","v":"Section_70"},{"$f":"IF('Project Information'!D100=0,\"\",'Project Information'!D100)","v":""},{"$f":"IF(ISBLANK('Project Information'!H100),\"\",'Project Information'!H100)","v":""}]
[71,{"$f":"'Project Information'!B101","v":"Section_71"},{"$f":"IF('Project Information'!D101=0,\"\",'Project Information'!D101)","v":""},{"$f":"IF(ISBLANK('Project Information'!H101),\"\",'Project Information'!H101)","v":""}]
[72,{"$f":"'Project Information'!B102","v":"Section_72"},{"$f":"IF('Project Information'!D102=0,\"\",'Project Information'!D102)","v":""},{"$f":"IF(ISBLANK('Project Information'!H102),\"\",'Project Information'!H102)","v":""}]
[73,{"$f":"'Project Information'!B103","v":"Section_73"},{"$f":"IF('Project Information'!D103=0,\"\",'Project Information'!D103)","v":""},{"$f":"IF(ISBLANK('Project Information'!H103),\"\",'Project Information'!H103)","v":""}]
[74,{"$f":"'Project Information'!B104","v":"Section_74"},{"$f":"IF('Project Information'!D104=0,\"\",'Project Information'!D104)","v":""},{"$f":"IF(ISBLANK('Project Information'!H104),\"\",'Project Information'!H104)","v":""}]
[75,{"$f":"'Project Information'!B105","v":"Section_75"},{"$f":"IF('Project Information'!D105=0,\"\",'Project Information'!D105)","v":""},{"$f":"IF(ISBLANK('Project Information'!H105),\"\",'Project Information'!H105)","v":""}]
[76,{"$f":"'Project Information'!B106","v":"Section_76"},{"$f":"IF('Project Information'!D106=0,\"\",'Project Information'!D106)","v":""},{"$f":"IF(ISBLANK('Project Information'!H106),\"\",'Project Information'!H106)","v":""}]
[77,{"$f":"'Project Information'!B107","v":"Section_77"},{"$f":"IF('Project Information'!D107=0,\"\",'Project Information'!D107)","v":""},{"$f":"IF(ISBLANK('Project Information'!H107),\"\",'Project Information'!H107)","v":""}]
[78,{"$f":"'Project Information'!B108","v":"Section_78"},{"$f":"IF('Project Information'!D108=0,\"\",'Project Information'!D108)","v":""},{"$f":"IF(ISBLANK('Project Information'!H108),\"\",'Project Information'!H108)","v":""}]
[79,{"$f":"'Project Information'!B109","v":"Section_79"},{"$f":"IF('Project Information'!D109=0,\"\",'Project Information'!D109)","v":""},{"$f":"IF(ISBLANK('Project Information'!H109),\"\",'Project Information'!H109)","v":""}]
[80,{"$f":"'Project Information'!B110","v":"Section_80"},{"$f":"IF('Project Information'!D110=0,\"\",'Project Information'!D110)","v":""},{"$f":"IF(ISBLANK('Project Information'!H110),\"\",'Project Information'!H110)","v":""}]
[81,{"$f":"'Project Information'!B111","v":"Section_81"},{"$f":"IF('Project Information'!D111=0,\"\",'Project Information'!D111)","v":""},{"$f":"IF(ISBLANK('Project Information'!H111),\"\",'Project Information'!H111)","v":""}]
[82,{"$f":"'Project Information'!B112","v":"Section_82"},{"$f":"IF('Project Information'!D112=0,\"\",'Project Information'!D112)","v":""},{"$f":"IF(ISBLANK('Project Information'!H112),\"\",'Project Information'!H112)","v":""}]
[83,{"$f":"'Project Information'!B113","v":"Section_83"},{"$f":"IF('Project Information'!D113=0,\"\",'Project Information'!D113)","v":""},{"$f":"IF(ISBLANK('Project Information'!H113),\"\",'Project Information'!H113)","v":""}]
[84,{"$f":"'Project Information'!B114","v":"Section_84"},{"$f":"IF('Project Information'!D114=0,\"\",'Project Information'!D114)","v":""},{"$f":"IF(ISBLANK('Project Information'!H114),\"\",'Project Information'!H114)","v":""}]
[85,{"$f":"'Project Information'!B115","v":"Section_85"},{"$f":"IF('Project Information'!D115=0,\"\",'Project Information'!D115)","v":""},{"$f":"IF(ISBLANK('Project Information'!H115),\"\",'Project Information'!H115)","v":""}]
[86,{"$f":"'Project Information'!B116","v":"Section_86"},{"$f":"IF('Project Information'!D116=0,\"\",'Project Information'!D116)","v":""},{"$f":"IF(ISBLANK('Project Information'!H116),\"\",'Project Information'!H116)","v":""}]
[87,{"$f":"'Project Information'!B117","v":"Section_87"},{"$f":"IF('Project Information'!D117=0,\"\",'Project Information'!D117)","v":""},{"$f":"IF(ISBLANK('Project Information'!H117),\"\",'Project Information'!H117)","v":""}]
[88,{"$f":"'Project Information'!B118","v":"Section_88"},{"$f":"IF('Project Information'!D118=0,\"\",'Project Information'!D118)","v":""},{"$f":"IF(ISBLANK('Project Information'!H118),\"\",'Project Information'!H118)","v":""}]
[89,{"$f":"'Project Information'!B119","v":"Section_89"},{"$f":"IF('Project Information'!D119=0,\"\",'Project Information'!D119)","v":""},{"$f":"IF(ISBLANK('Project Information'!H119),\"\",'Project Information'!H119)","v":""}]
[90,{"$f":"'Project Information'!B120","v":"Section_90"},{"$f":"IF('Project Information'!D120=0,\"\",'Project Information'!D120)","v":""},{"$f":"IF(ISBLANK('Project Information'!H120),\"\",'Project Information'!H120)","v":""}]
[91,{"$f":"'Project Information'!B121","v":"Section_91"},{"$f":"IF('Project Information'!D121=0,\"\",'Project Information'!D121)","v":""},{"$f":"IF(ISBLANK('Project Information'!H121),\"\",'Project Information'!H121)","v":""}]
[92,{"$f":"'Project Information'!B122","v":"Section_92"},{"$f":"IF('Project Information'!D122=0,\"\",'Project Information'!D122)","v":""},{"$f":"IF(ISBLANK('Project Information'!H122),\"\",'Project Information'!H122)","v":""}]
[93,{"$f":"'Project Information'!B123","v":"Section_93"},{"$f":"IF('Project Information'!D123=0,\"\",'Project Information'!D123)","v":""},{"$f":"IF(ISBLANK('Project Information'!H123),\"\",'Project Information'!H123)","v":""}]
[94,{"$f":"'Project Information'!B124","v":"Section_94"},{"$f":"IF('Project Information'!D124=0,\"\",'Project Information'!D124)","v":""},{"$f":"IF(ISBLANK('Project Information'!H124),\"\",'Project Information'!H124)","v":""}]
[95,{"$f":"'Project Information'!B125","v":"Section_95"},{"$f":"IF('Project Information'!D125=0,\"\",'Project Information'!D125)","v":""},{"$f":"IF(ISBLANK('Project Information'!H125),\"\",'Project Information'!H125)","v":""}]
[96,{"$f":"'Project Information'!B126","v":"Section_96"},{"$f":"IF('Project Information'!D126=0,\"\",'Project Information'!D126)","v":""},{"$f":"IF(ISBLANK('Project Information'!H126),\"\",'Project Information'!H126)","v":""}]
[97,{"$f":"'Project Information'!B127","v":"Section_97"},{"$f":"IF('Project Information'!D127=0,\"\",'Project Information'!D127)","v":""},{"$f":"IF(ISBLANK('Project Information'!H127),\"\",'Project Information'!H127)","v":""}]
[98,{"$f":"'Project Information'!B128","v":"Section_98"},{"$f":"IF('Project Information'!D128=0,\"\",'Project Information'!D128)","v":""},{"$f":"IF(ISBLANK('Project Information'!H128),\"\",'Project Information'!H128)","v":""}]
[99,{"$f":"'Project Information'!B129","v":"Section_99"},{"$f":"IF('Project Information'!D129=0,\"\",'Project Information'!D129)","v":""},{"$f":"IF(ISBLANK('Project Information'!H129),\"\",'Project Information'!H129)","v":""}]
[100,{"$f":"'Project Information'!B130","v":"Section_100"},{"$f":"IF('Project Information'!D130=0,\"\",'Project Information'!D130)","v":""},{"$f":"IF(ISBLANK('Project Information'!H130),\"\",'Project Information'!H130)","v":""}]

{"sheet":"Instructions","index":5,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":true,"merged":[[3,0,18,0],[20,0,35,0],[3,9,18,9],[20,9,35,9],[3,18,18,18]]}
[]
[]
[]
["1.",null,null,null,null,null,null,null,null,"2.",null,null,null,null,null,null,null,null,"3."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4.",null,null,null,null,null,null,null,null,"5."]

{"sheet":"Configurator","index":6,"n_rows":41,"n_cols":20,"rows_kept":41,"cut":false,"hidden":true,"merged":[[0,5,1,5]]}
[]
[]
[]
[null,{"$f":"IF(ISBLANK('Project Information'!$D$31),'Trunking Translation'!$B$26&\" - \" & 'Project Information'!$B$31,'Trunking Translation'!$B$26&\" - \" &'Project Information'!D31)","v":"OPPLE LED Trunking Configurator - Section_1"}]
[null,{"$f":"CONCATENATE('Project Information'!$C$9,\": \",'Project Information'!$F$9,\"               \",'Project Information'!$D$11,\": \",'Project Information'!$F$11,\"               \",'Project Information'!$D$13,\": \",'Project Information'!$F$13,\"               \",'Project Information'!$C$17,\": \",'Project Information'!$F$17)","v":"Project Name*:                Wholesaler:                Installer:                Representative*: "},null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Module Occupation per Line"]
[]
[null,{"$f":"'Trunking Translation'!$B$29","v":"LED Module"},null,null,{"$f":"'Trunking Translation'!$B$81","v":"ACCESSORY"},null,null,null,null,null,null,null,null,null,null,{"$f":"'Trunking Translation'!B52","v":"Full"}]
[null,{"$f":"'Trunking Translation'!$B$29","v":"LED Module"},"LEDTrunking Module L15-50W-4000-BW",null,{"$f":"'Trunking Translation'!$B$32","v":"Feed-in-box"},"Yes",null,null,null,"Mouting Method","Feed-in box?",null,null,null,null,{"$f":"'Trunking Translation'!B53","v":"Half"},null,null,null,"Probe L"]
[null,{"$f":"'Trunking Translation'!$B$78","v":"Dali Power Supply"},"No",null,{"$f":"'Trunking Translation'!$B$72","v":"Feed-out-box"},"No",null,null,null,{"$f":"'Trunking Translation'!B49","v":"Mounting Clip Chain"},{"$f":"'Trunking Translation'!B47","v":"Yes"},null,null,null,null,{"$f":"'Trunking Translation'!B54","v":"One-Third"},null,null,null,"Probe H"]
[null,null,null,null,{"$f":"'Trunking Translation'!$B$33","v":"Mounting Method"},"Cord 3m",null,null,null,{"$f":"'Trunking Translation'!B50","v":"Cord 3m"},{"$f":"'Trunking Translation'!B48","v":"No"},null,null,null,null,{"$f":"'Trunking Translation'!B55","v":"Custom"}]
[null,null,null,null,null,null,null,null,null,{"$f":"'Trunking Translation'!B51","v":"Mounting Clip"},{"$f":"'Trunking Translation'!$B$57","v":"Unknown"}]
[null,{"$f":"'Trunking Translation'!$B$80","v":"LIGHT LINE CONFIGURATION"},null,null,{"$f":"'Trunking Translation'!$B$82","v":"SENSOR"}]
[null,{"$f":"'Trunking Translation'!$B$30","v":"No. of Lines"},20,null,{"$f":"'Trunking Translation'!$B$73","v":"Sensor"},"No"]
[null,{"$f":"'Trunking Translation'!$B$31","v":"Length per line (m)"},19.5,null,{"$f":"'Trunking Translation'!$B$74","v":"Installation Height (m)"}]
[null,{"$f":"'Trunking Translation'!$B$34","v":"LED Module Occupation per Line"},"Full",null,{"$f":"'Trunking Translation'!$B$76","v":"Sensor Type"}]
[null,{"$f":"'Trunking Translation'!$B$36","v":"LED Modules per Line"},13,null,{"$f":"'Trunking Translation'!$B$75","v":"Sensor Occupation per Line"}]
[null,{"$f":"'Trunking Translation'!$B$35","v":"Custom Amount"},null,null,{"$f":"'Trunking Translation'!$B$77","v":"No. of Sensors per Line"},0]
[null,{"$f":"'Trunking Translation'!$B$37","v":"Line ends with LED Module?"},{"$f":"IF(ISBLANK(C15),\"\",IF(C15=$P$8,IF(RIGHT(C14/3-TRUNC(C14/3),1)=\"5\",'Trunking Translation'!$B$47,'Trunking Translation'!$B$48),IF(C15=$P$9,IF(RIGHT(C14/4.5-TRUNC(C14/4.5),1)=\"3\",'Trunking Translation'!$B$47,'Trunking Translation'!$B$48),IF(C15=$P$7,'Trunking Translation'!$B$47,'Trunking Translation'!$B$57))))","v":"Yes"},null,{"$f":"'Trunking Translation'!$B$35","v":"Custom Amount"}]
[]
[null,{"$f":"'Trunking Translation'!$B$38","v":"Article Code"},{"$f":"'Trunking Translation'!$B$39","v":"Article Description"},{"$f":"'Trunking Translation'!$B$40","v":"Number of products needed"},{"$f":"'Trunking Translation'!$B$41","v":"Unit Gross Price"},{"$f":"'Trunking Translation'!$B$42","v":"Total Gross Price"}]
[null,{"$f":"IF(ISBLANK(C8),\"\",INDEX('Art. List'!$C$6:$C$23,MATCH(C21,'Art. List'!$D$6:$D$23,0)))","v":542005006100},{"$f":"IF(ISBLANK(C8),\"\",C8)","v":"LEDTrunking Module L15-50W-4000-BW"},{"$f":"IF(ISBLANK(C8),0,C16*C13)","v":260},{"$f":"IF(ISBLANK(C8),\"\",INDEX('Art. List'!$E$6:$E$23,MATCH(Configurator!C21,'Art. List'!$D$6:$D$23,0)))","v":179},{"$f":"IF(ISBLANK(C8),\"\",INDEX('Art. List'!$E$6:$E$23,MATCH(Configurator!C21,'Art. List'!$D$6:$D$23,0))*D21)","v":46540}]
[null,542098001000,"LEDTrunking DALI Power Supply",{"$f":"IF(ISNUMBER(SEARCH(\"DALI\",C21)),1,0)*C13","v":0},{"$f":"VLOOKUP(B22,'Art. List'!C$6:E$41,3,0)","v":104},{"$f":"E22*D22","v":0}]
[null,542098002100,"LEDTrunking Trunk 8 L15",{"$f":"IF(F9=$K$9,IF(((C14-ROUNDDOWN(C14/3,0)*3)*C13)>0,1*C13,0),0)","v":0},{"$f":"VLOOKUP(B23,'Art. List'!C$6:E$41,3,0)","v":43.5},{"$f":"E23*D23","v":0}]
[null,542098002300,"LEDTrunking Trunk 8 L30",{"$f":"ROUNDDOWN(C14/3,0)*C13-D27","v":120},{"$f":"VLOOKUP(B24,'Art. List'!C$6:E$41,3,0)","v":88},{"$f":"D24*E24","v":10560}]
[null,542098001800,"LEDTrunking Cover L15",{"$f":"C13*((C14/1.5)-ROUNDUP(IF(C15=$P$7,C14/1.5,IF(C15=$P$8,C14/3,IF(C15=$P$9,C14/4.5,IF(C15=$P$10,C17,0)))),))-D39","v":0},{"$f":"VLOOKUP(B25,'Art. List'!C$6:E$41,3,0)","v":14.5},0]
[null,542098002200,"LEDTrunking Trunk 8 L15 End Part",{"$f":"IF(F9=$K$9,0,IF(((C14-ROUNDDOWN(C14/3,0)*3)/1.5*C13-D29)<0,0,C14-ROUNDDOWN(C14/3,0)*3)/1.5*C13)","v":20},{"$f":"VLOOKUP(B26,'Art. List'!C$6:E$41,3,0)","v":43.5},870]
[null,542098002400,"LEDTrunking Trunk 8 L30 End Part",{"$f":"IF(F9=$K$9,0,IF(IF((C14-ROUNDDOWN(C14/3,0)*3=0),1,0)*C13-D29<0,0,IF((C14-ROUNDDOWN(C14/3,0)*3=0),1,0)*C13))","v":0},{"$f":"VLOOKUP(B27,'Art. List'!C$6:E$41,3,0)","v":88},0]
[null,542098001300,"LEDTrunking Feed-in Box 8",{"$f":"IF(F8='Trunking Translation'!$B$47,1,0)*C13","v":20},{"$f":"VLOOKUP(B28,'Art. List'!C$6:E$41,3,0)","v":62},1240]
[null,542098011200,"LEDTrunking Feed-out Box 8",{"$f":"IF(F9='Trunking Translation'!$B$47,1,0)*C13","v":0},{"$f":"VLOOKUP(B29,'Art. List'!C$6:E$41,3,0)","v":62},0]
[null,542098001700,"LEDTrunking End Cap",{"$f":"IF(D28=0,2,1)*C13-D29-D31","v":20},{"$f":"VLOOKUP(B30,'Art. List'!C$6:E$41,3,0)","v":9.5},190]
[null,542098011000,"LEDTrunking Cover End Cap",{"$f":"IF(F9=$K$9,0,IF(C18=$K$9,0,IF(C18=$K$11,0,IF(C18='Trunking Translation'!$B$47,0,Configurator!C13))))","v":0},{"$f":"VLOOKUP(B31,'Art. List'!C$6:E$41,3,0)","v":9.5},0]
[null,542098003000,"LEDTrunking Cable Gland",{"$f":"IF(D30=2*C13,1,0)*C13","v":0},{"$f":"VLOOKUP(B32,'Art. List'!C$6:E$41,3,0)","v":7.9},0]
[null,542098001500,"LEDTrunking Feed-in Connector 8",{"$f":"D32","v":0},{"$f":"VLOOKUP(B33,'Art. List'!C$6:E$41,3,0)","v":20},{"$f":"E33*D33","v":0}]
[null,542098002900,"LEDTrunking Mounting Clip",{"$f":"IF(AND(C14=1.5,F10=$J$11),2*C13,IF(F10=$J$11,1,0)*C13*ROUNDUP((C14-2)/3+1,0))","v":0},{"$f":"VLOOKUP(B34,'Art. List'!C$6:E$41,3,0)","v":6.3},{"$f":"D34*E34","v":0}]
[null,542098001900,"LEDTrunking Mounting Clip Chain",{"$f":"IF(AND(C14=1.5,F10=$J$9),2*C13,IF(F10=$J$9,1,0)*C13*ROUNDUP((C14-2)/3+1,0))","v":0},{"$f":"VLOOKUP(B35,'Art. List'!C$6:E$41,3,0)","v":7.4},{"$f":"D35*E35","v":0}]
[null,542098002000,"LEDTrunking Cord-3m",{"$f":"IF(AND(C14=1.5,F10=$J$10),2*C13,IF(F10=$J$10,1,0)*C13*ROUNDUP((C14-2)/3+1,0))","v":140},{"$f":"VLOOKUP(B36,'Art. List'!C$6:E$41,3,0)","v":10.5},{"$f":"D36*E36","v":1470}]
[null,542098004600,"LEDTrunking Sensor Probe L",{"$f":"IF(F15=$T$8,F17,0)*C13","v":0},{"$f":"VLOOKUP(B37,'Art. List'!C$6:E$41,3,0)","v":314},{"$f":"D37*E37","v":0}]
[null,542098004700,"LEDTrunking Sensor Probe H",{"$f":"IF(F15=$T$9,F17,0)*C13","v":0},{"$f":"VLOOKUP(B38,'Art. List'!C$6:E$41,3,0)","v":471},{"$f":"D38*E38","v":0}]
[null,542098001100,"LEDTrunking Sensor Cover L15",{"$f":"IF(D37<>0,D37,IF(D38<>0,D38,0))","v":0},{"$f":"VLOOKUP(B39,'Art. List'!C$6:E$41,3,0)","v":51},0]
[null,null,null,null,null,{"$f":"SUM(F21:F39)","v":60870}]
[null,{"$f":"'Trunking Translation'!$B$43&\":\"","v":"Remarks:"}]

{"sheet":"Components","index":7,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":true,"merged":[[0,2,0,14]]}
[null,null,"OPPLE LED TRUNKING SYSTEM COMPONENTS"]
[]
[]
[]
[null,null,null,null,"Feed-in Box"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Trunk cover"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Feed-in connector"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LED Module"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cable Gland"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Normal Trunk"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Mounting clip chain",null,null,null,null,null,null,null,null,"End trunk"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Mounting clip"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Cord 3m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"End Cap"]

{"sheet":"Art. List","index":8,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,"Trunking Sensor Detection Area (100% Sensitivity)"]
[null,null,"Article code","Article Description","Gross Price","Power",null,null,"Installation Height (m)","Probe L (m)","Probe H (m)"]
[null,null,542005008200,"LEDTrunking Module L15-35W-4000-120",156,35,null,null,null,"L1","L1"]
[null,null,542005005800,"LEDTrunking Module L15-50W-4000-120",179,50,null,null,3,5,0]
[null,null,542005005900,"LEDTrunking Module L15-50W-4000-90",179,50,null,null,4,4.5,6.7]
[null,null,542005006000,"LEDTrunking Module L15-50W-4000-60",179,50,null,null,5,4,8.4]
[null,null,542005006100,"LEDTrunking Module L15-50W-4000-BW",179,50,null,null,6,0,10]
[null,null,542005006200,"LEDTrunking Module L15-70W-4000-120",257,70,null,null,7,0,9]
[null,null,542005006300,"LEDTrunking Module L15-70W-4000-90",257,70,null,null,8,0,8]
[null,null,542005006400,"LEDTrunking Module L15-70W-4000-60",257,70,null,null,9,0,7]
[null,null,542005006500,"LEDTrunking Module L15-70W-4000-BW",257,70,null,null,10,0,6]
[null,null,542005008600,"LEDTrunking Module L15-35W-4000-120-DALI",209,35,null,null,12.5,0,3.5]
[null,null,542005006600,"LEDTrunking Module L15-50W-4000-120-DALI",226,50]
[null,null,542005006700,"LEDTrunking Module L15-50W-4000-90-DALI",226,50]
[null,null,542005006800,"LEDTrunking Module L15-50W-4000-60-DALI",226,50]
[null,null,542005006900,"LEDTrunking Module L15-50W-4000-BW-DALI",226,50]
[null,null,542005007000,"LEDTrunking Module L15-70W-4000-120-DALI",305,70]
[null,null,542005007100,"LEDTrunking Module L15-70W-4000-90-DALI",305,70]
[null,null,542005007200,"LEDTrunking Module L15-70W-4000-60-DALI",305,70]
[null,null,542005007300,"LEDTrunking Module L15-70W-4000-BW-DALI",305,70]
[null,null,542098001000,"LEDTrunking DALI Power Supply",104]
[null,null,542098001100,"LEDTrunking Sensor Cover L15",51]
[null,null,542098004600,"LEDTrunking Sensor Probe L",314]
[null,null,542098004700,"LEDTrunking Sensor Probe H",471]
[null,null,542098001300,"LEDTrunking Feed-in Box 8",62]
[null,null,542098001500,"LEDTrunking Feed-in Connector 8",20]
[null,null,542098011200,"LEDTrunking Feed-out Box 8",62]
[null,null,542098001700,"LEDTrunking End Cap",9.5]
[null,null,542098011000,"LEDTrunking Cover End Cap",9.5]
[null,null,542098001800,"LEDTrunking Cover L15",14.5]
[null,null,542098001900,"LEDTrunking Mounting Clip Chain",7.4]
[null,null,542098002000,"LEDTrunking Cord-3m",10.5]
[null,null,542098002100,"LEDTrunking Trunk 8 L15",43.5]
[null,null,542098002200,"LEDTrunking Trunk 8 L15 End Part",43.5]
[null,null,542098002300,"LEDTrunking Trunk 8 L30",88]
[null,null,542098002400,"LEDTrunking Trunk 8 L30 End Part",88]
[null,null,542098002900,"LEDTrunking Mounting Clip",6.3]
["x",null,542098003000,"LEDTrunking Cable Gland",7.9]