{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Net12 (2)","Net11 (2)","Control","AUX2","Net42","Net41","Net32","Net31","Net22","Net21","Net12","Net11","AUX","specs"],"not_rendered":{"charts":0,"images":602,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Net12 (2)","index":0,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,7,0,11],[23,2,24,10],[26,12,27,12],[33,5,34,7]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M8","v":62.07209069101097},"U start, V",{"$f":"+O5*1","v":0.46686486483507195},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.368983542449413},{"$f":"G6+G5*G4","v":62.073517564065497},62.07209758170859,62.0720907242885,62.072090691171681,62.072090691011745,62.072090691010978,62.07209069101097,62.07209069101097,62.07209069101097]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.63900000000000001}]
[null,null,"span length,m","150",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.46462105076438959},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.46685402894048539},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.46686481250483425},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.46686486458235132},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.46686486483385142},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.46686486483506601},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.46686486483507189},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.46686486483507195},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.46686486483507195},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.46686486483507195}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":62.07209069101097},{"$f":"G9+G8*G7","v":61.775197839572527},61.773770966518001,61.773764075820381,61.773764042542851,61.77376404238214,61.773764042381366,61.773764042381359,61.773764042381359,61.773764042381359]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":62.07209069101097},{"$f":"G12+G11*G10","v":61.775197839572527},61.773770966518001,61.773764075820381,61.773764042542851,61.77376404238214,61.773764042381366,61.773764042381359,61.773764042381359,61.773764042381359]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":62.07209069101097},{"$f":"G15+G14*G13","v":61.775197839572527},61.773770966518001,61.773764075820381,61.773764042542851,61.77376404238214,61.773764042381366,61.773764042381359,61.773764042381359,61.773764042381359]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":62.07209069101097},{"$f":"G18+G17*G16","v":61.775197839572527},61.773770966518001,61.773764075820381,61.773764042542851,61.77376404238214,61.773764042381366,61.773764042381359,61.773764042381359,61.773764042381359]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":62.07209069101097},{"$f":"G21+G20*G19","v":61.775197839572527},61.773770966518001,61.773764075820381,61.773764042542851,61.77376404238214,61.773764042381366,61.773764042381359,61.773764042381359,61.773764042381359]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":62.07209069101097},{"$f":"F21-(F3-$B$2)","v":61.775197839572527},61.773770966518001,61.773764075820381,61.773764042542851,61.77376404238214,61.773764042381366,61.773764042381359,61.773764042381359,61.773764042381359]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch  Net12 (2)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.773764042381359}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net12"]

{"sheet":"Net11 (2)","index":1,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,7,0,11],[23,2,24,10],[26,12,27,12],[33,5,34,7]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M7","v":61.912316131629581},"U start, V",{"$f":"+O5*1","v":0.46646385843083038},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":61.997645053725925},{"$f":"G6+G5*G4","v":61.912433896141074},61.912316294383857,61.912316131854517,61.912316131629886,61.912316131629581,61.912316131629581,61.912316131629581,61.912316131629581,{"$f":"O6+O5*O4","v":61.912316131629581}]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.18317999999999998}]
[null,null,"span length,m","43",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.46582007913715096},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.46646296870750803},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.46646385720120231},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.46646385842913102},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.4664638584308281},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.46646385843083038},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.46646385843083038},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.46646385843083038},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.46646385843083038},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.46646385843083038}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":61.912316131629581},{"$f":"G9+G8*G7","v":61.826987209533236},61.826869445021742,61.826869282267467,61.82686928204253,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225,{"$f":"O9+O8*O7","v":61.826869282042225}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":61.912316131629581},{"$f":"G12+G11*G10","v":61.826987209533236},61.826869445021742,61.826869282267467,61.82686928204253,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225,{"$f":"O12+O11*O10","v":61.826869282042225}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":61.912316131629581},{"$f":"G15+G14*G13","v":61.826987209533236},61.826869445021742,61.826869282267467,61.82686928204253,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225,{"$f":"O15+O14*O13","v":61.826869282042225}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":61.912316131629581},{"$f":"G18+G17*G16","v":61.826987209533236},61.826869445021742,61.826869282267467,61.82686928204253,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225,{"$f":"O18+O17*O16","v":61.826869282042225}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":61.912316131629581},{"$f":"G21+G20*G19","v":61.826987209533236},61.826869445021742,61.826869282267467,61.82686928204253,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225,{"$f":"O21+O20*O19","v":61.826869282042225}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":61.912316131629581},{"$f":"F21-(F3-$B$2)","v":61.826987209533236},61.826869445021742,61.826869282267467,61.82686928204253,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225,61.826869282042225]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch  Net11 (2)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.826869282042225}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net11"]

{"sheet":"Control","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,"PS actual power"]
[null,null,null,null,"T-Former:  900 W"]
[null,null,null,"A","Ferro:  952 W"]

{"sheet":"AUX2","index":3,"n_rows":72,"n_cols":22,"rows_kept":72,"cut":false,"hidden":true,"merged":[[3,15,3,16],[47,0,51,17],[58,3,58,4],[58,5,58,6]]}
[{"$f":"'Net42'!B1+'Net41'!B1+'Net32'!B1+'Net31'!B1+'Net22'!B1+'Net21'!B1+'Net12'!B1+'Net11'!B1+SUM(A7:A18)+'Net11 (2)'!B1+'Net12 (2)'!B1","v":0},"Vtriac(vba)",1.5,{"$f":"+'Net11'!D1+'Net12'!D1+'Net21'!D1+'Net22'!D1+'Net31'!D1+'Net32'!D1+'Net41'!D1+'Net42'!D1","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"67V","V0",1]
[null,null,{"$f":"+C5*1","v":67},null,null,null,null,null,null,"m",null,null,null,null,null,null,null,null,62.072042423626179,"62,1V","V01",2]
[null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,55.106076858905354,null,"V02",3]
[null,null,null,"V","m","i temp","i","drop","k","dist","L","cable","Vinput",1E-4,null,null,null,null,55.106076858905354,"55,1V","V03",4]
["PS - Imax Vout",15,"67","V","-","A","A","V","-","m","km",null,"V","accuracy",null,null,null,null,59.800814281430533,"59,8V","V04",5]
["Vmin amp.",44,{"$f":"IF(C2=60,66,90)","v":90},59.800814281430533,null,null,null,null,null,null,null,null,null,{"$f":"ABS(SUM(N7:N14))","v":0},null,null,null,null,7.6355349922418689,"7,6A","I01",6]
[{"$f":"IF(D7<0,1,0)","v":0},7,11,{"$f":"+D15-H7","v":59.800814281430533},0,{"$f":"+'Net11'!D2","v":1.8752916801160993},{"$f":"+F7*E7","v":0},{"$f":"+G7*K7*VLOOKUP(L7,specs!$K$5:$L$19,2)","v":0},1,"20",{"$f":"+IF($J$5=\"m\",J7,(J7*0.3048))/1000*I7","v":0.02},"C565 ",61.912316131629581,{"$f":"E7*(+M7-D7)","v":0},null,null,null,null,11.852404500189802,"11,9A","I02",7]
[0,8,12,{"$f":"+D15-H8","v":59.800814281430533},0,{"$f":"+'Net12'!D2","v":3.6068103670064025},{"$f":"+F8*E8","v":0},{"$f":"+G8*K8*VLOOKUP(L8,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J8,(J8*0.3048))/1000*I8","v":0},"cable",62.07209069101097,{"$f":"E8*(+M8-D8)","v":0},null,null,null,null,11.852404500189802,"11,9A","I03",8]
[0,9,21,{"$f":"+D16-H9","v":59.800814281430533},0,{"$f":"+'Net21'!D2","v":2.7918127920573523},0,{"$f":"+G9*K9*VLOOKUP(L9,specs!$K$5:$L$19,2)","v":0},1,"54",5.3999999999999999E-2,"C565 ",54.463849124678767,0,null,null,null,null,12.679149095461177,"12,7A","I04",9]
[0,10,22,{"$f":"+D16-H10","v":59.800814281430533},0,{"$f":"+'Net22'!D2","v":1.4250567158905807},0,{"$f":"+G10*K10*VLOOKUP(L10,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",55.106076858905354,0,null,null,null,null,61.91231583986508,"61,9V","V11",10]
[0,11,31,{"$f":"+D17-H11","v":59.800814281430533},0,{"$f":"+'Net31'!D2","v":0},0,{"$f":"+G11*K11*VLOOKUP(L11,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",55.106076858905354,0,null,null,null,null,62.07209069101097,"62,1V","V12",11]
[0,12,32,{"$f":"+D17-H12","v":59.800814281430533},0,{"$f":"+'Net32'!D2","v":0},0,{"$f":"+G12*K12*VLOOKUP(L12,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",55.106076858905354,0,null,null,null,null,54.463848244220479,"54,5V","V21",12]
[0,13,41,{"$f":"+D18-H13","v":59.800814281430533},1,{"$f":"+'Net41'!D2","v":0.82674459527137578},0.82674459527137578,{"$f":"+G13*K13*VLOOKUP(L13,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",59.800814281430533,0,null,null,null,null,55.106076858905354,"55,1V","V22",13]
[0,14,42,{"$f":"+D18-H14","v":59.800814281430533},1,{"$f":"+'Net42'!D2","v":0},0,{"$f":"+G14*K14*VLOOKUP(L14,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",59.800814281430533,0,null,null,null,null,55.106076858905354,"55,1V","V31",14]
[{"$f":"IF(D15<0,1,0)","v":0},15,"01",{"$f":"+D16-H15","v":59.800814281430533},0,{"$f":"SUM(F7:F8)","v":5.4821020471225017},{"$f":"+F15*E15","v":0},{"$f":"+G15*K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0},1,"680",{"$f":"+IF($J$5=\"m\",J15,(J15*0.3048))/1000*I15","v":0.68},"QR860",{"$f":"K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":1.1560000000000001},null,null,null,null,null,55.106076858905354,"55,1V","V32",15]
[{"$f":"IF(D16<0,1,0)","v":0},16,"02",{"$f":"+D17-H16","v":59.800814281430533},0,{"$f":"SUM(F7:F10)","v":9.6989715550704343},{"$f":"+F16*E16","v":0},{"$f":"+G16*K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J16,(J16*0.3048))/1000*I16","v":0},"cable",{"$f":"K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,59.800814281430533,"59,8V","V41",16]
[{"$f":"IF(D17<0,1,0)","v":0},17,"03",{"$f":"+D18-H17","v":59.800814281430533},0,{"$f":"SUM(F7:F12)","v":9.6989715550704343},{"$f":"+F17*E17","v":0},{"$f":"+G17*K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},1,"233",{"$f":"+IF($J$5=\"m\",J17,(J17*0.3048))/1000*I17","v":0.23300000000000001},"QR860",{"$f":"K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0.39610000000000001},null,null,null,null,null,59.800814281430533,"59,8V","V42",17]
[{"$f":"IF(D18<0,1,0)","v":0},18,"04",{"$f":"+D6-H18","v":59.800814281430533},0,{"$f":"SUM(F7:F14)","v":10.525716150341809},{"$f":"+F18*E18","v":0},{"$f":"+G18*K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":0},1,"334",{"$f":"+IF($J$5=\"m\",J18,(J18*0.3048))/1000*I18","v":0.33400000000000002},"QR860",{"$f":"K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":0.56779999999999997},null,null,null,null,null,1.8752916801160993,"1,9A","I11",18]
[null,null,null,null,null,null,null,"D6:L18",null,null,null,null,null,null,null,null,null,null,3.6068103670064025,"3,6A","I12",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.7918127920573523,"2,8A","I21",20]
[null,"Booster Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4250567158905807,"1,4A","I22",21]
[null,null,"vba","vba","vba",null,null,null,null,null,null,null,null,null,null,null,null,null,0,"0A","I31",22]
["Vin","Ranges","Mcont","TrEff","Bgain","Vout","Pin","Iin","Final Gain ","Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,0,"0A","I32",23]
[62,"57.5-66",1,97,1.0329999999999999,{"$f":"A24*E24/C24-1.5","v":62.545999999999992},{"$f":"M24+L24+K24","v":204.99446979822852},{"$f":"G24/A24","v":3.3063624161004599},{"$f":"F24/A24","v":1.0088064516129032},{"$f":"M24/G24","v":0.97563607543586683},{"$f":"N24*1.5","v":4.7964697982285038},{"$f":"M24*(E24-1)*0.03","v":0.19799999999999951},200,{"$f":"M24/F24","v":3.1976465321523362},null,null,null,null,0.82674459527137578,"0,8A","I41",24]
[57.5,"49.9-57.5",1.0249999999999999,96.8,1.2110000000000001,{"$f":"A25*E25/C25-1.5","v":66.434146341463432},{"$f":"M25+L25+K25","v":205.86615005507014},{"$f":"G25/A25","v":3.5802808705229587},{"$f":"F25/A25","v":1.1553764581124075},{"$f":"M25/G25","v":0.97150502861446175},{"$f":"N25*1.5","v":4.5157500550701215},{"$f":"M25*(E25-1)*0.032","v":1.3504000000000005},200,{"$f":"M25/F25","v":3.0105000367134145},null,null,null,null,0,"0A","I42",25]
[49.9,"0-49.9",1.0249999999999999,96.5,1.4079999999999999,{"$f":"A26*E26/C26-1.5","v":67.04556097560976},{"$f":"M26+L26+K26","v":207.33056916810847},{"$f":"G26/A26","v":4.1549212258137969},{"$f":"F26/A26","v":1.3435984163448851},{"$f":"M26/G26","v":0.96464308568909263},{"$f":"N26*1.5","v":4.4745691681084718},{"$f":"M26*(E26-1)*0.035","v":2.8559999999999994},200,{"$f":"M26/F26","v":2.9830461120723148},null,null,null,null,61.102716682757936,"61,1V","Vend11",26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.069195016562048,"61,1V","Vend12",27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50.631397755720961,"50,6V","Vend21",28]
["Vin",null,null,null,null,"Vout","Pin","Iin",null,"Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,54.633837211890686,"54,6V","Vend22",29]
[83,"74.9-90",1,97,1.048,{"$f":"A30*E30/C30-1.5","v":85.484000000000009},{"$f":"M30+L30+K30","v":203.79742866501334},{"$f":"G30/A30","v":2.4553907068073895},{"$f":"F30/A30","v":1.0299277108433735},{"$f":"M30/G30","v":0.9813666507478106},{"$f":"N30*1.5","v":3.5094286650133357},{"$f":"M30*(E30-1)*0.03","v":0.28800000000000026},200,{"$f":"M30/F30","v":2.3396191100088903},null,null,null,null,55.106076858905354,"55,1V","Vend31",30]
[74.900000000000006,"62-74.9",1.0249999999999999,96.8,1.2789999999999999,{"$f":"A31*E31/C31-1.5","v":91.96058536585366},{"$f":"M31+L31+K31","v":205.04786718551742},{"$f":"G31/A31","v":2.737621724773263},{"$f":"F31/A31","v":1.2277781757790875},{"$f":"M31/G31","v":0.97538200589548019},{"$f":"N31*1.5","v":3.2622671855174432},{"$f":"M31*(E31-1)*0.032","v":1.7855999999999994},200,{"$f":"M31/F31","v":2.1748447903449621},null,null,null,null,55.106076858905354,"55,1V","Vend32",31]
[61.9,"0-61.9",1.0249999999999999,96.5,1.538,{"$f":"A32*E32/C32-1.5","v":91.380195121951232},{"$f":"M32+L32+K32","v":207.04898708051164},{"$f":"G32/A32","v":3.3448947832069731},{"$f":"F32/A32","v":1.4762551715985659},{"$f":"M32/G32","v":0.96595497915780382},{"$f":"N32*1.5","v":3.2829870805116546},{"$f":"M32*(E32-1)*0.035","v":3.7660000000000005},200,{"$f":"M32/F32","v":2.1886580536744362},null,null,null,null,59.800814281430533,"59,8V","Vend41",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59.800814281430533,"59,8V","Vend42",33]
["Pin = Pout + Ptriac + Pdelta-transformer, where",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46.279363270040363,"46,3V","PBVin",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62.072042423626179,"62,1V","PBVout",35]
["Pout =  Vout x Iout;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.6355349922418689,"7,6A","PBcurin",36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.4821020471225017,"5,5A","PBcurout",37]
["Ptriac = Vtriac * Iout  , where   Vtriac=1.5V;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3412466818403581,"1,34","Bgain",38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PB Location IV","STitleLocation",39]
["Pdelta-transformer = (100 - K) / 100 * (n – 1)  *  Pout  , where  K=96.5%  for range\"1.32\" , K=96.8% for range \"1.2\" and K=97% for range \"1\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V in","sTitleVin",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V out","sTitleVout",41]
["Then, assuming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I in","STitleIin",42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I out","sTitleIout",43]
["Vout = Vin * n / Mcont  –  Vtriac ,  where Mcont = 1 for range\"1\", Mcont=1.025 for other two ranges;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain","sTitleGain",44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",45]
["We get  finally the booster input current Iin, derived from above, as a function of the booster output current Iout and the booster input voltage Vin:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntext",46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"cntloc",47]
["Iin = Iout * n / Mcont * (1 + K / 100) * (n – 1) * [ 1 – Vtriac / (Vout + Vtriac) ]}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,null,"cntsum",48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"cntloc04",49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"cntsum04",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"cntloc03",51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"cntsum03",52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"cntloc02",53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"cntsum02",54]
[]
[]
[]
[]
[null,null,null,"Efficiency",null,"tangens alpha"]
[null,null,"Load,%","Super2M-90","T-former","Super2M-90","T-former","load span","SpanN"]
[null,"L0",4,36.55806621,62.083720929999998,{"$f":"(D62-D61)/($C62-$C61)","v":4.2606763124999993},{"$f":"+(E62-E61)/($C62-$C61)","v":3.4893378800000008},{"$f":"+C62-C61","v":4},1]
[null,"L1",8,53.600771459999997,76.041072450000001,{"$f":"(D63-D62)/($C63-$C62)","v":2.4445559925000016},{"$f":"+(E63-E62)/($C63-$C62)","v":1.5768140174999985},{"$f":"+C63-C62","v":4},2]
[null,"L2",12,63.378995430000003,82.348328519999995,{"$f":"(D64-D63)/($C64-$C63)","v":1.4451867049999993},{"$f":"+(E64-E63)/($C64-$C63)","v":0.7958163650000003},{"$f":"+C64-C63","v":8},3]
[null,"L3",20,74.940489069999998,88.714859439999998,{"$f":"(D65-D64)/($C65-$C64)","v":0.7155390490000002},{"$f":"+(E65-E64)/($C65-$C64)","v":0.27130518400000059},{"$f":"+C65-C64","v":10},4]
[null,"L4",30,82.09587956,91.427911280000004,{"$f":"(D66-D65)/($C66-$C65)","v":0.48487377400000042},{"$f":"+(E66-E65)/($C66-$C65)","v":0.12942325799999993},{"$f":"+C66-C65","v":10},5]
[null,"L5",40,86.944617300000004,92.722143860000003,{"$f":"(D67-D66)/($C67-$C66)","v":0.17963340999999958},{"$f":"+(E67-E66)/($C67-$C66)","v":0.11173976900000042},{"$f":"+C67-C66","v":10},6]
[null,"L6",50,88.7409514,93.839541550000007,{"$f":"(D68-D67)/($C68-$C67)","v":0.11277000900000048},{"$f":"+(E68-E67)/($C68-$C67)","v":3.6879177999999513E-2},{"$f":"+C68-C67","v":10},7]
[null,"L7",60,89.868651490000005,94.208333330000002,{"$f":"(D69-D68)/($C69-$C68)","v":8.9180478000000105E-2},{"$f":"+(E69-E68)/($C69-$C68)","v":3.8966666999999691E-2},{"$f":"+C69-C68","v":10},8]
[null,"L8",70,90.760456270000006,94.597999999999999,{"$f":"(D70-D69)/($C70-$C69)","v":5.1471151999999167E-2},{"$f":"+(E70-E69)/($C70-$C69)","v":-5.6377240000003324E-3},{"$f":"+C70-C69","v":10},9]
[null,"L9",80,91.275167789999998,94.541622759999996,{"$f":"(D71-D70)/($C71-$C70)","v":4.0063600000053159E-4},{"$f":"+(E71-E70)/($C71-$C70)","v":-3.8172269999999744E-2},{"$f":"+C71-C70","v":10},10]
[null,"L10",90,91.279174150000003,94.159900059999998,{"$f":"(D72-D71)/($C72-$C71)","v":3.6039225000000383E-2},{"$f":"+(E72-E71)/($C72-$C71)","v":-8.7130945999999196E-2},{"$f":"+C72-C71","v":10},11]
[null,"L11",100,91.639566400000007,93.288590600000006]

{"sheet":"Net42","index":4,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M14","v":59.800814281430533},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":59.800814281430533},{"$f":"G6+G5*G4","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":59.800814281430533},{"$f":"G9+G8*G7","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":59.800814281430533},{"$f":"G12+G11*G10","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":59.800814281430533},{"$f":"G15+G14*G13","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":59.800814281430533},{"$f":"G18+G17*G16","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":59.800814281430533},{"$f":"G21+G20*G19","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":59.800814281430533},{"$f":"F21-(F3-$B$2)","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":59.800814281430533}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net42"]

{"sheet":"Net41","index":5,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M13","v":59.800814281430533},"U start, V",{"$f":"+O5*1","v":0.82674459527137578},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":59.800814281430533},{"$f":"G6+G5*G4","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.82674459527137578},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.82674459527137578}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":59.800814281430533},{"$f":"G9+G8*G7","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":59.800814281430533},{"$f":"G12+G11*G10","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":59.800814281430533},{"$f":"G15+G14*G13","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":59.800814281430533},{"$f":"G18+G17*G16","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":59.800814281430533},{"$f":"G21+G20*G19","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":59.800814281430533},{"$f":"F21-(F3-$B$2)","v":59.800814281430533},59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533,59.800814281430533]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":59.800814281430533}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net41"]

{"sheet":"Net32","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"'AUX2'!M12","v":55.106076858905354},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":55.106076858905354},{"$f":"G6+G5*G4","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":55.106076858905354},{"$f":"G9+G8*G7","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":55.106076858905354},{"$f":"G12+G11*G10","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":55.106076858905354},{"$f":"G15+G14*G13","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":55.106076858905354},{"$f":"G18+G17*G16","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":55.106076858905354},{"$f":"G21+G20*G19","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":55.106076858905354},{"$f":"F21-(F3-$B$2)","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":55.106076858905354}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net32"]

{"sheet":"Net31","index":7,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M11","v":55.106076858905354},"U start, V",{"$f":"+O5*1","v":0},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":55.106076858905354},{"$f":"G6+G5*G4","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":55.106076858905354},{"$f":"G9+G8*G7","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":55.106076858905354},{"$f":"G12+G11*G10","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":55.106076858905354},{"$f":"G15+G14*G13","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":55.106076858905354},{"$f":"G18+G17*G16","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":55.106076858905354},{"$f":"G21+G20*G19","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":55.106076858905354},{"$f":"F21-(F3-$B$2)","v":55.106076858905354},55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":55.106076858905354}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net31"]

{"sheet":"Net22","index":8,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M10","v":55.106076858905354},"U start, V",{"$f":"+O5*1","v":1.4250567158905807},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":55.574269578667632},{"$f":"G6+G5*G4","v":55.11008880823853},55.106111534485386,55.106077158631201,55.106076861496099,55.106076858927743,55.106076858905553,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":1.4129745878636792},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":1.424952303391072},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":1.4250558133797138},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":1.4250567080895287},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":1.4250567158231506},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":1.425056715889998},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":1.4250567158905756},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":1.4250567158905807},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":1.4250567158905807},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":1.4250567158905807}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":55.574269578667632},{"$f":"G9+G8*G7","v":55.11008880823853},55.106111534485386,55.106077158631201,55.106076861496099,55.106076858927743,55.106076858905553,55.106076858905354,55.106076858905354,55.106076858905354]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.89459999999999995}]
[null,null,"span length,m","210",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0.52335425862092277},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0.52783888787777489},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0.52787764886595623},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0.52787798390490814},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0.52787798680089137},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0.52787798682592346},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0.52787798682613984},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0.52787798682614162},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0.52787798682614162},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0.52787798682614162}]
[null,null,"amplifier","DBLE","1",{"$f":"F12+F11*F10","v":55.106076858905354},{"$f":"G12+G11*G10","v":54.637884139143075},54.6338721898099,54.633837514229867,54.63383721450402,54.633837211913274,54.633837211890885,54.633837211890686,54.633837211890686,54.633837211890686]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":55.106076858905354},{"$f":"G15+G14*G13","v":54.637884139143075},54.6338721898099,54.633837514229867,54.63383721450402,54.633837211913274,54.633837211890885,54.633837211890686,54.633837211890686,54.633837211890686]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":55.106076858905354},{"$f":"G18+G17*G16","v":54.637884139143075},54.6338721898099,54.633837514229867,54.63383721450402,54.633837211913274,54.633837211890885,54.633837211890686,54.633837211890686,54.633837211890686]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":55.106076858905354},{"$f":"G21+G20*G19","v":54.637884139143075},54.6338721898099,54.633837514229867,54.63383721450402,54.633837211913274,54.633837211890885,54.633837211890686,54.633837211890686,54.633837211890686]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":55.106076858905354},{"$f":"F21-(F3-$B$2)","v":54.637884139143075},54.6338721898099,54.633837514229867,54.63383721450402,54.633837211913274,54.633837211890885,54.633837211890686,54.633837211890686,54.633837211890686]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":54.633837211890686}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net22"]

{"sheet":"Net21","index":9,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M9","v":54.463849124678767},"U start, V",{"$f":"+O5*1","v":2.7918127920573523},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":58.029531669891206},{"$f":"G6+G5*G4","v":54.71077049058492},54.482212872691449,54.465221879512342,54.463951782221372,54.463856801849076,54.463849698811636,54.463849167614981,54.463849127889723,54.463849124918902]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":2.6021001461508213},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":2.7777314968503557},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":2.7907603227524218},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":2.7917340870435643},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":2.7918069061772988},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":2.7918123518978804},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":2.7918127591530064},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":2.7918127896093576},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":2.7918127918870188},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":2.7918127920573523}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":58.029531669891206},{"$f":"G9+G8*G7","v":54.71077049058492},54.482212872691449,54.465221879512342,54.463951782221372,54.463856801849076,54.463849698811636,54.463849167614981,54.463849127889723,54.463849124918902]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.40154}]
[null,null,"span length,m","329",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":2.1051118167591554},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":2.2505958023354515},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":2.2614132481871798},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":2.2622218771456648},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":2.2622823480747369},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":2.2622868703491541},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":2.2622872085449068},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":2.2622872338366911},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":2.262287235728123},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":2.2622872358695725}]
[null,null,"amplifier","DBLE","2",{"$f":"F12+F11*F10","v":55.079133254230577},{"$f":"G12+G11*G10","v":51.556470449779695},51.312751748827189,51.294627429817609,51.293272580100705,51.293171261579921,51.293163684547608,51.293163117903504,51.293163075527332,51.293163072358261]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.46859999999999996}]
[null,null,"span length,m","110",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":1.0578912707537467},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":1.1318225524058403},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":1.1373261931342737},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":1.1377376399042696},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":1.1377684089431357},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":1.1377707099844701},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":1.1377708820665604},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":1.1377708949356253},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":1.137770895898031},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":1.1377708959700041}]
[null,null,"amplifier","DBLE","1",{"$f":"F15+F14*F13","v":54.583405404755368},{"$f":"G15+G14*G13","v":51.026098401722315},50.779800694724472,50.761483571758468,50.760114303669951,50.760011906881196,50.760004249211221,50.76000367653667,50.760003633709516,50.760003630506716]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.22578000000000001}]
[null,null,"span length,m","53",0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0.52952555619011443},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0.56662158851974875},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0.5693838301191273},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0.56959033665946546},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0.56960577976806948},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0.56960693467041501},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0.5696070210391424},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0.56960702749818015},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0.56960702798121576},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0.56960702801733931}]
[null,null,"amplifier","DBLE","1",{"$f":"F18+F17*F16","v":54.463849124678767},{"$f":"G18+G17*G16","v":50.898166579466327},50.651245213560173,50.632881465547491,50.631508710713916,50.631406053171311,50.631398376001002,50.631397801868133,50.631397758931918,50.631397755720961]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":54.463849124678767},{"$f":"G21+G20*G19","v":50.898166579466327},50.651245213560173,50.632881465547491,50.631508710713916,50.631406053171311,50.631398376001002,50.631397801868133,50.631397758931918,50.631397755720961]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":54.463849124678767},{"$f":"F21-(F3-$B$2)","v":50.898166579466327},50.651245213560173,50.632881465547491,50.631508710713916,50.631406053171311,50.631398376001002,50.631397801868133,50.631397758931918,50.631397755720961]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":50.631397755720961}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net21"]

{"sheet":"Net12","index":10,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)+'Net12 (2)'!D1","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M8","v":62.07209069101097},"U start, V",{"$f":"+O5*1+'Net12 (2)'!D2","v":3.6068103670064025},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":63.058876527148001},{"$f":"G6+G5*G4","v":62.087937608281919},62.072349319938532,62.072094913056489,62.072090759934994,62.072090692136136,62.072090691029338,62.072090691011276,62.07209069101097,62.07209069101097]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":3.0901725687449542},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":3.1391334401333935},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":3.1399322455520284},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":3.1399452857597909},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":3.1399454986384558},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":3.1399455021136564},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":3.1399455021703884},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":3.1399455021713143},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":3.1399455021713303},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":3.1399455021713303}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":63.058876527148001},{"$f":"G9+G8*G7","v":62.087937608281919},62.072349319938532,62.072094913056489,62.072090759934994,62.072090692136136,62.072090691029338,62.072090691011276,62.07209069101097,62.07209069101097]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":2.3061433769353732},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":2.3428435019505347},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":2.3434423343167992},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":2.3434521100541876},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":2.3434522696410607},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":2.3434522722462838},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":2.3434522722888134},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":2.3434522722895075},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":2.3434522722895195},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":2.3434522722895195}]
[null,null,"amplifier","DBLE","1",{"$f":"F12+F11*F10","v":63.058876527148001},{"$f":"G12+G11*G10","v":62.087937608281919},62.072349319938532,62.072094913056489,62.072090759934994,62.072090692136136,62.072090691029338,62.072090691011276,62.07209069101097,62.07209069101097]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.17039999999999997}]
[null,null,"span length,m","40",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":1.8487930150464509},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":1.8783410380105336},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":1.8788232194295817},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":1.8788310908925856},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":1.8788312193925802},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":1.8788312214903162},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":1.8788312215245613},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":1.8788312215251204},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":1.8788312215251297},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":1.8788312215251297}]
[null,null,"amplifier","DBLE","1",{"$f":"F15+F14*F13","v":62.743842197384083},{"$f":"G15+G14*G13","v":61.767868295404924},61.75219784334773,61.751942095168395,61.751937920150496,61.751937851994185,61.751937850881554,61.751937850863392,61.751937850863087,61.751937850863087]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.25559999999999999}]
[null,null,"span length,m","60",0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":1.3891463152273187},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":1.4114316108942755},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":1.4117953077565271},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":1.411801245004443},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":1.4118013419287814},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":1.4118013435110512},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":1.4118013435368815},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":1.4118013435373031},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":1.4118013435373102},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":1.4118013435373102}]
[null,null,"amplifier","DBLE","2",{"$f":"F18+F17*F16","v":62.388776399211977},{"$f":"G18+G17*G16","v":61.407106375660348},61.391342962685165,61.391085696945261,61.3910814971535,61.391081428592763,61.39108142747353,61.391081427455255,61.391081427454949,61.391081427454949]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0.68159999999999987}]
[null,null,"span length,m","160",0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0.46462105076438959},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0.47212664434626106},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0.47224915651727145},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0.47225115649916538},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0.47225118914845565},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0.47225118968144864},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0.47225118969014962},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0.47225118969029162},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0.472251189690294},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0.472251189690294}]
[null,null,"amplifier","DBLE","1",{"$f":"F21+F20*F19","v":62.07209069101097},{"$f":"G21+G20*G19","v":61.085304854873939},61.069457937602991,61.069199308675429,61.069195086629911,61.069195017705887,61.069195016580721,61.069195016562354,61.069195016562048,61.069195016562048]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":62.07209069101097},{"$f":"F21-(F3-$B$2)","v":61.085304854873939},61.069457937602991,61.069199308675429,61.069195086629911,61.069195017705887,61.069195016580721,61.069195016562354,61.069195016562048,61.069195016562048]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.069195016562048}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net12"]

{"sheet":"Net11","index":11,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,7,0,11],[23,2,24,10],[33,5,34,7],[26,12,27,12]]}
[null,{"$f":"SUM(F22:O22)","v":0},null,{"$f":"IF(O21<'AUX2'!B6,1,0)+'Net11 (2)'!D1","v":0},{"$f":"+'AUX2'!J5","v":"m"}]
[null,{"$f":"+'AUX2'!M7","v":61.912316131629581},"U start, V",{"$f":"+O5*1+'Net11 (2)'!D2","v":1.8752916801160993},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.711346910185448},{"$f":"G6+G5*G4","v":61.922745037295236},61.912454047657114,61.91231795580098,61.912316155757367,61.912316131948714,61.912316131633801,61.91231613162963,61.912316131629581,{"$f":"O6+O5*O4","v":61.912316131629581}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":1.3905863200002027},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":1.4085866264132991},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":1.4088246314787907},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":1.408827779489328},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":1.4088278211271552},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":1.4088278216778867},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":1.4088278216851711},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":1.4088278216852674},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":1.4088278216852688},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":1.4088278216852688}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":62.711346910185448},{"$f":"G9+G8*G7","v":61.922745037295236},61.912454047657114,61.91231795580098,61.912316155757367,61.912316131948714,61.912316131633801,61.91231613162963,61.912316131629581,{"$f":"O9+O8*O7","v":61.912316131629581}]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.72419999999999995}]
[null,null,"span length,m","170",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0.93070144396167087},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0.9428449997681938},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0.94300559000128104},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0.94300771407700101},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0.94300774217153849},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0.9430077425431368},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0.94300774254805186},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0.94300774254811692},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0.9430077425481177},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0.9430077425481177}]
[null,null,"amplifier","DBLE","1",{"$f":"F12+F11*F10","v":62.037332924468409},{"$f":"G12+G11*G10","v":61.239936688463111},61.229529399378187,61.229391769266414,61.229389948876737,61.229389924798973,61.2293899244805,61.229389924476287,61.229389924476237,{"$f":"O12+O11*O10","v":61.229389924476237}]
[null,null,"cable type","C565 ",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26838000000000001}]
[null,null,"span length,m","63",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0.46582007913715096},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0.47191048285787307},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0.47199102753605188},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0.47199209287535449},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0.47199210696629057},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0.47199210715266732},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0.47199210715513251},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0.4719921071551651},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0.47199210715516549},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0.47199210715516549}]
[null,null,"amplifier","DBLE","1",{"$f":"F15+F14*F13","v":61.912316131629581},{"$f":"G15+G14*G13","v":61.113285353073714},61.102856447408058,61.102718531380525,61.102716707209126,61.10271668308134,61.102716682762207,61.102716682757986,61.102716682757936,{"$f":"O15+O14*O13","v":61.102716682757936}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":61.912316131629581},{"$f":"G18+G17*G16","v":61.113285353073714},61.102856447408058,61.102718531380525,61.102716707209126,61.10271668308134,61.102716682762207,61.102716682757986,61.102716682757936,{"$f":"O18+O17*O16","v":61.102716682757936}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":61.912316131629581},{"$f":"G21+G20*G19","v":61.113285353073714},61.102856447408058,61.102718531380525,61.102716707209126,61.10271668308134,61.102716682762207,61.102716682757986,61.102716682757936,{"$f":"O21+O20*O19","v":61.102716682757936}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":61.912316131629581},{"$f":"F21-(F3-$B$2)","v":61.113285353073714},61.102856447408058,61.102718531380525,61.102716707209126,61.10271668308134,61.102716682762207,61.102716682757986,61.102716682757936,61.102716682757936]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.102716682757936}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net11"]

{"sheet":"AUX","index":12,"n_rows":13,"n_cols":27,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,3,1,5],[1,7,1,9]]}
[]
[null,null,null,"R,Ohm",null,null,null,"Vdrop,V"]
[null,"length,m","I,A",540,860,750,"3x10",540,860,750,"3x10","amp type","Inom,A","Vnom,V","Pnom,W","factor_i","cable","loop_res",null,null,null,null,null,null,null,null,"LIST"]
[1,null,null,{"$f":"B4*$R$4","v":0},{"$f":"B4*$R$5","v":0},{"$f":"B4*$R$6","v":0},{"$f":"+B4*$R$7","v":0},{"$f":"$C4*D4","v":0},{"$f":"$C4*E4","v":0},{"$f":"$C4*F4","v":0},{"$f":"$C4*G4","v":0},"HLN",1.4,60,84,{"$f":"M4/(O4/N4)","v":1},"QR540",{"$f":"S4/1000","v":5.28E-3},5.28,"C500",{"$f":"V4/1000","v":5.64E-3},5.64,null,null,null,null,"Net11"]
[2,null,null,0,0,0,{"$f":"+B5*$R$7","v":0},{"$f":"$C5*D5","v":0},{"$f":"$C5*E5","v":0},{"$f":"$C5*F5","v":0},{"$f":"$C5*G5","v":0},"TNA",1,60,60,{"$f":"M5/(O5/N5)","v":1},"QR860",{"$f":"S5/1000","v":2.3700000000000001E-3},2.37,"C625",{"$f":"V5/1000","v":3.6099999999999999E-3},3.61,null,null,null,null,"Net12"]
[3,null,null,0,0,0,{"$f":"+B6*$R$7","v":0},0,0,0,0,"LEX",0.5,60,36,{"$f":"M6/(O6/N6)","v":0.83333333333333337},"C750",{"$f":"S6/1000","v":2.49E-3},2.4900000000000002,null,null,null,null,null,null,null,"Net21"]
[4,null,null,0,0,0,0,0,0,0,0,"DBLE",0.6,60,24,{"$f":"M7/(O7/N7)","v":1.4999999999999998},"3x10",{"$f":"+S7/1000","v":2.5000000000000001E-3},2.5,null,null,null,null,null,null,null,"Net22"]
[5,null,null,0,0,0,0,{"$f":"$C8*D8","v":0},{"$f":"$C8*E8","v":0},0,0,"GNA",1,60,60,{"$f":"M8/(O8/N8)","v":1},"C500",{"$f":"S8/1000","v":5.64E-3},5.64,null,null,null,null,null,null,null,"Net31"]
[6,null,null,0,0,0,0,{"$f":"$C9*D9","v":0},{"$f":"$C9*E9","v":0},0,0,null,null,null,null,null,"C625",3.6099999999999999E-3,3.61,null,null,null,null,null,null,null,"Net32"]
[7,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"2x10",3.6600000000000001E-3,3.66,null,null,null,null,null,null,null,"Net41"]
[8,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"2x6",6.0000000000000001E-3,6,null,null,null,null,null,null,null,"Net42"]
[9,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"4x10",1.83E-3,1.83]
[10,null,null,0,0,0,0,0,0,0,0,null,null,null,null,null,"4x6",3.0000000000000001E-3,3]

{"sheet":"specs","index":13,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[19,10,20,13]]}
[]
[]
[null,null,null,1,2,3,4,5,null,null,1,2]
[null,null,"amp type","sorted","Inom,A","Vnom,V","Pnom,W",null,"original","cable","sorted","loop_res",null,null,"original"]
[null,null,"load","DBLE",null,60,28,1,30,"cable","2x10",3.66,"cable",1,3.66]
[null,null,"HLN","future1",null,60,0,1,0,"QR860","2x6",6,"QR860",2,6]
[null,null,"TNA","future2",null,60,0,1,0,"C750","3x10",2.5,"C750",3,2.5]
[null,null,"GNA","future3",null,60,0,1,0,"QR715 ","4x10",1.83,"QR715 ",4,1.83]
[null,null,"LEX","future4",null,60,0,1,0,"C625","4x6",3,"C625",5,3]
[null,null,"DBLE","future5",null,60,0,1,0,"C565 ","C500",5.64,"C565 ",6,5.64]
[null,null,"future1","future6",null,60,0,1,0,"QR540","C565 ",4.26,"QR540",7,4.26]
[null,null,"future2","future7",null,60,0,1,0,"C500","C625",3.61,"C500",8,3.61]
[null,null,"future3","GNA",null,60,48,1,48,"QR1125","C750",2.4900000000000002,"QR1125",9,2.4900000000000002]
[null,null,"future4","HLN",null,60,84,1,84,"3x10","cable",0,"2x10",10,0]
[null,null,"future5","LEX",null,60,24,1,24,"4x10","QR1125",1.3,"2x6",11,1.3]
[null,null,"future6","load",null,1,0,0,0,"2x10","QR540",5.28,"3x10",12,5.28]
[null,null,"future7","TNA",null,60,48,1,52,"2x6","QR715 ",3.27,"4x10",13,3.27]
[null,null,null,null,null,null,null,null,null,"4x6","QR860",1.7,"4x6",14,2.37]
[null,null,null,null,null,null,null,null,null,"type","spare",0,null,null,0]