{"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":603,"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":47.098118955557091},"U start, V",{"$f":"+O5*1","v":0.61751222741480138},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":47.489403372189308},{"$f":"G6+G5*G4","v":47.10139692325091},47.098146648581867,47.098119189530685,47.098118957533899,47.098118955573788,47.098118955557233,47.098118955557091,47.098118955557091,47.098118955557091]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.61233868017561621},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.617468520072049},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.61751185813898302},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.61751222429485164},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.61751222738844147},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.61751222741457867},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.6175122274147995},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.61751222741480138},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.61751222741480138},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.61751222741480138}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":47.098118955557091},{"$f":"G9+G8*G7","v":46.706834538924873},46.703556571231054,46.703528878206278,46.703528644232684,46.703528642255876,46.703528642239178,46.703528642239036,46.703528642239036,46.703528642239036]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":47.098118955557091},{"$f":"G12+G11*G10","v":46.706834538924873},46.703556571231054,46.703528878206278,46.703528644232684,46.703528642255876,46.703528642239178,46.703528642239036,46.703528642239036,46.703528642239036]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":47.098118955557091},{"$f":"G15+G14*G13","v":46.706834538924873},46.703556571231054,46.703528878206278,46.703528644232684,46.703528642255876,46.703528642239178,46.703528642239036,46.703528642239036,46.703528642239036]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":47.098118955557091},{"$f":"G18+G17*G16","v":46.706834538924873},46.703556571231054,46.703528878206278,46.703528644232684,46.703528642255876,46.703528642239178,46.703528642239036,46.703528642239036,46.703528642239036]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":47.098118955557091},{"$f":"G21+G20*G19","v":46.706834538924873},46.703556571231054,46.703528878206278,46.703528644232684,46.703528642255876,46.703528642239178,46.703528642239036,46.703528642239036,46.703528642239036]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":47.098118955557091},{"$f":"F21-(F3-$B$2)","v":46.706834538924873},46.703556571231054,46.703528878206278,46.703528644232684,46.703528642255876,46.703528642239178,46.703528642239036,46.703528642239036,46.703528642239036]
[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":46.703528642239036}]
[]
[]
[]
[]
[]
[]
[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":46.886091518576471},"U start, V",{"$f":"+O5*1","v":0.61659314602795612},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":46.99876696301839},{"$f":"G6+G5*G4","v":46.886362949591046},46.886092174022778,46.886091520159241,46.886091518580294,46.886091518576478,46.886091518576471,46.886091518576471,46.886091518576471,{"$f":"O6+O5*O4","v":46.886091518576471}]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.61510778710512626},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.6165895592122117},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.6165931373665331},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.61659314600704052},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.61659314602790549},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.61659314602795601},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.61659314602795612},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.61659314602795612},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.61659314602795612},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.61659314602795612}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":46.886091518576471},{"$f":"G9+G8*G7","v":46.773416074134552},46.773144643119977,46.77314398767367,46.773143986090901,46.773143986087078,46.773143986087071,46.773143986087071,46.773143986087071,{"$f":"O9+O8*O7","v":46.773143986087071}]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":46.886091518576471},{"$f":"G12+G11*G10","v":46.773416074134552},46.773144643119977,46.77314398767367,46.773143986090901,46.773143986087078,46.773143986087071,46.773143986087071,46.773143986087071,{"$f":"O12+O11*O10","v":46.773143986087071}]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":46.886091518576471},{"$f":"G15+G14*G13","v":46.773416074134552},46.773144643119977,46.77314398767367,46.773143986090901,46.773143986087078,46.773143986087071,46.773143986087071,46.773143986087071,{"$f":"O15+O14*O13","v":46.773143986087071}]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":46.886091518576471},{"$f":"G18+G17*G16","v":46.773416074134552},46.773144643119977,46.77314398767367,46.773143986090901,46.773143986087078,46.773143986087071,46.773143986087071,46.773143986087071,{"$f":"O18+O17*O16","v":46.773143986087071}]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":46.886091518576471},{"$f":"G21+G20*G19","v":46.773416074134552},46.773144643119977,46.77314398767367,46.773143986090901,46.773143986087078,46.773143986087071,46.773143986087071,46.773143986087071,{"$f":"O21+O20*O19","v":46.773143986087071}]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)+F23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)+G23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)+H23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)+I23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)+J23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)+K23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)+L23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)+M23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)+N23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":46.886091518576471},{"$f":"F21-(F3-$B$2)","v":46.773416074134552},46.773144643119977,46.77314398767367,46.773143986090901,46.773143986087078,46.773143986087071,46.773143986087071,46.773143986087071,46.773143986087071]
[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":46.773143986087071}]
[]
[]
[]
[]
[]
[]
[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:  872 W"]
[null,null,null,null,"Ferro:  923 W"]

{"sheet":"AUX2","index":3,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":true,"merged":[[3,15,3,16],[47,0,52,11]]}
[{"$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,47.1,"47.1V","V01",2]
[null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,55.5,"55.5V","V02",3]
[null,null,null,"V","m","i temp","i","drop","k","dist","L","cable","Vinput",1E-4,null,null,null,null,55.5,"55.5V","V03",4]
["PS - Imax Vout",15,"67","V","-","A","A","V","-","m","km",null,"V","accuracy",null,null,null,null,60,"60V","V04",5]
["Vmin amp.",44,{"$f":"IF(C2=60,66,90)","v":90},67,null,null,null,null,null,null,null,null,null,{"$f":"ABS(SUM(N7:N14))","v":4.8145425523671292E-5},null,null,null,null,7.3,"7.3A","I01",6]
[{"$f":"IF(D7<0,1,0)","v":0},7,11,{"$f":"+D15-H7","v":46.886081190664058},1,{"$f":"+'Net11'!D2","v":2.4885864143147121},{"$f":"+F7*E7","v":2.4885864143147121},{"$f":"+G7*K7*VLOOKUP(L7,specs!$K$5:$L$19,2)","v":0.21202756249961344},1,"20",{"$f":"+IF($J$5=\"m\",J7,(J7*0.3048))/1000*I7","v":0.02},"C565 ",46.886091518576471,{"$f":"E7*(+M7-D7)","v":1.0327912413288232E-5},null,null,null,null,11.4,"11.4A","I02",7]
[0,8,12,{"$f":"+D15-H8","v":47.098108753163672},1,{"$f":"+'Net12'!D2","v":4.7763900651265967},{"$f":"+F8*E8","v":4.7763900651265967},{"$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",47.098118955557091,{"$f":"E8*(+M8-D8)","v":1.0202393418978772E-5},null,null,null,null,11.4,"11.4A","I03",8]
[0,9,21,{"$f":"+D16-H9","v":54.859364925634033},1,{"$f":"+'Net21'!D2","v":2.7693298459563307},2.7693298459563307,{"$f":"+G9*K9*VLOOKUP(L9,specs!$K$5:$L$19,2)","v":0.63705663776379429},1,"54",5.3999999999999999E-2,"C565 ",54.859370398788521,5.4731544878450222E-6,null,null,null,null,12.3,"12.3A","I04",9]
[0,10,22,{"$f":"+D16-H10","v":55.496421563397824},1,{"$f":"+'Net22'!D2","v":1.4149691215376619},1.4149691215376619,{"$f":"+G10*K10*VLOOKUP(L10,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",55.496426850253563,5.2868557389729176E-6,null,null,null,null,46.9,"46.9V","V11",10]
[0,11,31,{"$f":"+D17-H11","v":55.496421563397824},1,{"$f":"+'Net31'!D2","v":0},0,{"$f":"+G11*K11*VLOOKUP(L11,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",55.496426850253563,5.2868557389729176E-6,null,null,null,null,47.1,"47.1V","V12",11]
[0,12,32,{"$f":"+D17-H12","v":55.496421563397824},1,{"$f":"+'Net32'!D2","v":0},0,{"$f":"+G12*K12*VLOOKUP(L12,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",55.496426850253563,5.2868557389729176E-6,null,null,null,null,54.9,"54.9V","V21",12]
[0,13,41,{"$f":"+D18-H13","v":60.031479567928898},1,{"$f":"+'Net41'!D2","v":0.82356786421492723},0.82356786421492723,{"$f":"+G13*K13*VLOOKUP(L13,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60.031482708627891,3.1406989933202567E-6,null,null,null,null,55.5,"55.5V","V22",13]
[0,14,42,{"$f":"+D18-H14","v":60.031479567928898},1,{"$f":"+'Net42'!D2","v":0},0,{"$f":"+G14*K14*VLOOKUP(L14,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",60.031482708627891,3.1406989933202567E-6,null,null,null,null,55.5,"55.5V","V31",14]
[{"$f":"IF(D15<0,1,0)","v":0},15,"01",{"$f":"+D16-H15","v":47.098108753163672},1,{"$f":"SUM(F7:F8)","v":7.2649764794413088},{"$f":"+F15*E15","v":7.2649764794413088},{"$f":"+G15*K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":8.3983128102341542},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.5,"55.5V","V32",15]
[{"$f":"IF(D16<0,1,0)","v":0},16,"02",{"$f":"+D17-H16","v":55.496421563397824},1,{"$f":"SUM(F7:F10)","v":11.449275446935303},{"$f":"+F16*E16","v":11.449275446935303},{"$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,60,"60V","V41",16]
[{"$f":"IF(D17<0,1,0)","v":0},17,"03",{"$f":"+D18-H17","v":55.496421563397824},1,{"$f":"SUM(F7:F12)","v":11.449275446935303},{"$f":"+F17*E17","v":11.449275446935303},{"$f":"+G17*K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":4.5350580045310735},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,60,"60V","V42",17]
[{"$f":"IF(D18<0,1,0)","v":0},18,"04",{"$f":"+D6-H18","v":60.031479567928898},1,{"$f":"SUM(F7:F14)","v":12.272843311150231},{"$f":"+F18*E18","v":12.272843311150231},{"$f":"+G18*K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":6.9685204320711014},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,2.5,"2.5A","I11",18]
[null,null,null,null,null,null,null,"D6:L18",null,null,null,null,null,null,null,null,null,null,4.8,"4.8A","I12",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8,"2.8A","I21",20]
[null,"Booster Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4,"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.8,".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,45.8,"45.8V","Vend11",26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45.8,"45.8V","Vend12",27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.1,"51.1V","Vend21",28]
["Vin",null,null,null,null,"Vout","Pin","Iin",null,"Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,55,"55V","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.5,"55.5V","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.5,"55.5V","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,60,"60V","Vend41",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,"60V","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,0,null,"PBVin",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"PBVout",35]
["Pout =  Vout x Iout;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"PBcurin",36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,"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,0,null,"Bgain",38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,"sTitleVin",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sTitleVout",41]
["Then, assuming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STitleIin",42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,null,"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,14,null,"cntext",46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc",47]
["Iin = Iout * { Bgain / Mcont + (1 - TrEff / 100) * (Bgain – 1) * ( Bgain / Mcont – Vtriac*Mcont * (PBVout + Vtriac) / Bgain)}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum",48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc04",49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum04",50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc03",51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum03",52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntloc02",53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cntsum02",54]

{"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":60.031482708627891},"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":60.031482708627891},{"$f":"G6+G5*G4","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":60.031482708627891},{"$f":"G9+G8*G7","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60.031482708627891},{"$f":"G12+G11*G10","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60.031482708627891},{"$f":"G15+G14*G13","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60.031482708627891},{"$f":"G18+G17*G16","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60.031482708627891},{"$f":"G21+G20*G19","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60.031482708627891},{"$f":"F21-(F3-$B$2)","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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":60.031482708627891}]
[]
[]
[]
[]
[]
[]
[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":60.031482708627891},"U start, V",{"$f":"+O5*1","v":0.82356786421492723},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":60.031482708627891},{"$f":"G6+G5*G4","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0.82356786421492723},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0.82356786421492723}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":60.031482708627891},{"$f":"G9+G8*G7","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":60.031482708627891},{"$f":"G12+G11*G10","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":60.031482708627891},{"$f":"G15+G14*G13","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":60.031482708627891},{"$f":"G18+G17*G16","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":60.031482708627891},{"$f":"G21+G20*G19","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":60.031482708627891},{"$f":"F21-(F3-$B$2)","v":60.031482708627891},60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891,60.031482708627891]
[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":60.031482708627891}]
[]
[]
[]
[]
[]
[]
[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.496426850253563},"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.496426850253563},{"$f":"G6+G5*G4","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":55.496426850253563},{"$f":"G9+G8*G7","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":55.496426850253563},{"$f":"G12+G11*G10","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":55.496426850253563},{"$f":"G15+G14*G13","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":55.496426850253563},{"$f":"G18+G17*G16","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":55.496426850253563},{"$f":"G21+G20*G19","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":55.496426850253563},{"$f":"F21-(F3-$B$2)","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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.496426850253563}]
[]
[]
[]
[]
[]
[]
[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.496426850253563},"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.496426850253563},{"$f":"G6+G5*G4","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":0},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":0}]
[null,null,"amplifier","load",0,{"$f":"F9+F8*F7","v":55.496426850253563},{"$f":"G9+G8*G7","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":55.496426850253563},{"$f":"G12+G11*G10","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":55.496426850253563},{"$f":"G15+G14*G13","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":55.496426850253563},{"$f":"G18+G17*G16","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":55.496426850253563},{"$f":"G21+G20*G19","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":55.496426850253563},{"$f":"F21-(F3-$B$2)","v":55.496426850253563},55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563,55.496426850253563]
[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.496426850253563}]
[]
[]
[]
[]
[]
[]
[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.496426850253563},"U start, V",{"$f":"+O5*1","v":1.4149691215376619},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":55.961326402608833},{"$f":"G6+G5*G4","v":55.500354264308605},55.496460311237165,55.49642713535669,55.496426852682774,55.496426850274261,55.496426850253741,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":1.4031403620624512},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":1.4148683556290989},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":1.4149682629662856},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":1.4149691142222305},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":1.414969121475331},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":1.4149691215371307},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":1.4149691215376574},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":1.4149691215376619},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":1.4149691215376619},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":1.4149691215376619}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":55.961326402608833},{"$f":"G9+G8*G7","v":55.500354264308605},55.496460311237165,55.49642713535669,55.496426852682774,55.496426850274261,55.496426850253741,55.496426850253563,55.496426850253563,55.496426850253563]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":0.51967309675304307},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":0.52406323095273111},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":0.52410063424314024},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":0.52410095293654912},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":0.52410095565196679},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":0.5241009556751034},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":0.52410095567530046},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":0.52410095567530224},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":0.52410095567530224},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":0.52410095567530224}]
[null,null,"amplifier","DBLE","1",{"$f":"F12+F11*F10","v":55.496426850253563},{"$f":"G12+G11*G10","v":55.031527297898293},55.027599883843251,55.02756642285965,55.027566137756523,55.027566135327312,55.027566135306614,55.027566135306436,55.027566135306436,55.027566135306436]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":55.496426850253563},{"$f":"G15+G14*G13","v":55.031527297898293},55.027599883843251,55.02756642285965,55.027566137756523,55.027566135327312,55.027566135306614,55.027566135306436,55.027566135306436,55.027566135306436]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":55.496426850253563},{"$f":"G18+G17*G16","v":55.031527297898293},55.027599883843251,55.02756642285965,55.027566137756523,55.027566135327312,55.027566135306614,55.027566135306436,55.027566135306436,55.027566135306436]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":55.496426850253563},{"$f":"G21+G20*G19","v":55.031527297898293},55.027599883843251,55.02756642285965,55.027566137756523,55.027566135327312,55.027566135306614,55.027566135306436,55.027566135306436,55.027566135306436]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":55.496426850253563},{"$f":"F21-(F3-$B$2)","v":55.031527297898293},55.027599883843251,55.02756642285965,55.027566137756523,55.027566135327312,55.027566135306614,55.027566135306436,55.027566135306436,55.027566135306436]
[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.027566135306436}]
[]
[]
[]
[]
[]
[]
[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.859370398788521},"U start, V",{"$f":"+O5*1","v":2.7693298459563307},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":58.399609908544477},{"$f":"G6+G5*G4","v":55.100827618390497},54.877036972360941,54.860669444063511,54.859465954069499,54.859377427840471,54.859370915847002,54.859370436823447,54.859370401586382,54.859370398994329]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":2.5839566978496102},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":2.7557928327178893},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":2.7683345950998031},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":2.7692566379938919},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":2.769324460789341},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":2.7693294498331245},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":2.7693298168281686},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":2.7693298438244027},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":2.7693298458102507},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":2.7693298459563307}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":58.399609908544477},{"$f":"G9+G8*G7","v":55.100827618390497},54.877036972360941,54.860669444063511,54.859465954069499,54.859377427840471,54.859370915847002,54.859370436823447,54.859370401586382,54.859370398994329]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":2.0901177827410282},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":2.2323887161820002},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":2.2427960166498515},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":2.2435612665692766},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":2.2436175568222847},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":2.2436216975361751},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":2.2436220021279256},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":2.2436220245337601},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":2.2436220261819373},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":2.2436220263031781}]
[null,null,"amplifier","DBLE","2",{"$f":"F12+F11*F10","v":55.470226231321618},{"$f":"G12+G11*G10","v":51.972045537112777},51.73366864318551,51.71622858651601,51.714946203480793,51.714851873875617,51.714844934984626,51.7148444245584,51.714844387011347,51.714844384249375]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":1.0502806679713281},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":1.1225613194748374},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":1.1278547895386022},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":1.1282440522927717},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":1.1282726858627607},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":1.1282747921506111},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":1.1282749470895763},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":1.1282749584869198},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":1.1282749593253105},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":1.128274959386983}]
[null,null,"amplifier","DBLE","1",{"$f":"F15+F14*F13","v":54.978064710310257},{"$f":"G15+G14*G13","v":51.446013302806868},51.205155888807724,51.187533423611619,51.1862376228855,51.186142306273837,51.186135294778452,51.186134779011432,51.186134741071506,51.186134738280636]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0.5257078196551247},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0.56197366362966628},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0.5646302567859588},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0.56482561676610921},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0.56483998716592276},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0.56484104425386628},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0.56484112201347225},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0.56484112773348549},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0.5648411281542508},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0.56484112818520238}]
[null,null,"amplifier","DBLE","1",{"$f":"F18+F17*F16","v":54.859370398788521},{"$f":"G18+G17*G16","v":51.319130889032564},51.077673669430588,51.060007095858168,51.058708050583178,51.058612495302199,51.058605466250249,51.058604949191768,51.058604911156841,51.05860490835898]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":54.859370398788521},{"$f":"G21+G20*G19","v":51.319130889032564},51.077673669430588,51.060007095858168,51.058708050583178,51.058612495302199,51.058605466250249,51.058604949191768,51.058604911156841,51.05860490835898]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":54.859370398788521},{"$f":"F21-(F3-$B$2)","v":51.319130889032564},51.077673669430588,51.060007095858168,51.058708050583178,51.058612495302199,51.058605466250249,51.058604949191768,51.058604911156841,51.05860490835898]
[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":51.05860490835898}]
[]
[]
[]
[]
[]
[]
[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":47.098118955557091},"U start, V",{"$f":"+O5*1+'Net12 (2)'!D2","v":4.7763900651265967},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":48.395894984614685},{"$f":"G6+G5*G4","v":47.134512706219702},47.099168845620291,47.098149267271303,47.098119830716684,47.098118980824715,47.098118956286619,47.098118955578151,47.098118955557695,47.098118955557112]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":4.0448064020777217},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":4.1555901700490256},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":4.1587829209825111},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":4.1588750972788091},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":4.1588777585899841},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":4.1588778354273916},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":4.158877837645842},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":4.1588778377098938},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":4.1588778377117421},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":4.1588778377117954}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":48.395894984614685},{"$f":"G9+G8*G7","v":47.134512706219702},47.099168845620291,47.098149267271303,47.098119830716684,47.098118980824715,47.098118956286619,47.098118955578151,47.098118955557695,47.098118955557112]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":3.0232321545983183},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":3.1066772363745021},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":3.1090828686938523},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":3.1091523211366034},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":3.1091543263659238},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":3.1091543842609286},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":3.1091543859324737},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":3.1091543859807351},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":3.1091543859821282},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":3.1091543859821682}]
[null,null,"amplifier","DBLE","1",{"$f":"F12+F11*F10","v":48.395894984614685},{"$f":"G12+G11*G10","v":47.134512706219702},47.099168845620291,47.098149267271303,47.098119830716684,47.098118980824715,47.098118956286619,47.098118955578151,47.098118955557695,47.098118955557112]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":2.4273138435686659},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":2.4948113583976967},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":2.4967578381921345},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":2.4968140350536503},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":2.4968156575685554},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":2.4968157044138253},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":2.4968157057663425},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":2.4968157058053926},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":2.4968157058065201},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":2.4968157058065521}]
[null,null,"amplifier","DBLE","1",{"$f":"F15+F14*F13","v":47.982280705670583},{"$f":"G15+G14*G13","v":46.709396850748732},46.673721309992352,46.672692155698158,46.672662442667004,46.6726615847926,46.672661560024032,46.672661559308914,46.672661559288265,46.672661559287675]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":1.8262586295218757},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":1.8773767104583774},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":1.8788512477050876},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":1.8788938194425397},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":1.8788950485733595},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":1.8788950840608396},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":1.8788950850854347},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":1.8788950851150168},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":1.878895085115871},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":1.8788950851158952}]
[null,null,"amplifier","DBLE","2",{"$f":"F18+F17*F16","v":47.515488999964788},{"$f":"G18+G17*G16","v":46.229539363555574},46.19348693107893,46.192446895448647,46.192416868251655,46.192416001306647,46.192415976276195,46.192415975553516,46.192415975532647,46.19241597553205]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0.61233868017561621},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0.6296896083569179},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0.6301903686062863},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0.63020482640105568},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0.63020524382655851},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0.63020525587847287},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0.63020525622643597},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0.63020525623648227},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0.63020525623677237},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0.6302052562367807}]
[null,null,"amplifier","DBLE","1",{"$f":"F21+F20*F19","v":47.098118955557091},{"$f":"G21+G20*G19","v":45.800342926499496},45.763949175836885,45.762899285773685,45.762868974059472,45.762868098899879,45.762868073632255,45.762868072902727,45.762868072881666,45.762868072881062]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":47.098118955557091},{"$f":"F21-(F3-$B$2)","v":45.800342926499496},45.763949175836885,45.762899285773685,45.762868974059472,45.762868098899879,45.762868073632255,45.762868072902727,45.762868072881666,45.762868072881062]
[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":45.762868072881062}]
[]
[]
[]
[]
[]
[]
[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":46.886091518576471},"U start, V",{"$f":"+O5*1+'Net11 (2)'!D2","v":2.4885864143147121},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":47.940533331269584},{"$f":"G6+G5*G4","v":46.910276757361522},46.88665924615286,46.886104852658818,46.886091831754833,46.886091525932116,46.886091518749232,46.886091518580535,46.886091518576563,{"$f":"O6+O5*O4","v":46.886091518576471}]
[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)/IF(F6<67,(F6/1.03),65)*$E6+F8","v":1.8296360441229975},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(G6<67,(G6/1.03),65)*$E6+G8","v":1.8709994317003407},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(H6<67,(H6/1.03),65)*$E6+H8","v":1.8719699265404084},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(I6<67,(I6/1.03),65)*$E6+I8","v":1.8719927200579394},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(J6<67,(J6/1.03),65)*$E6+J8","v":1.8719932554104701},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(K6<67,(K6/1.03),65)*$E6+K8","v":1.8719932679843294},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(L6<67,(L6/1.03),65)*$E6+L8","v":1.8719932682796525},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(M6<67,(M6/1.03),65)*$E6+M8","v":1.8719932682865887},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(N6<67,(N6/1.03),65)*$E6+N8","v":1.8719932682867522},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/IF(O6<67,(O6/1.03),65)*$E6+O8","v":1.8719932682867557}]
[null,null,"amplifier","DBLE","1",{"$f":"F9+F8*F7","v":47.940533331269584},{"$f":"G9+G8*G7","v":46.910276757361522},46.88665924615286,46.886104852658818,46.886091831754833,46.886091525932116,46.886091518749232,46.886091518580535,46.886091518576563,{"$f":"O9+O8*O7","v":46.886091518576471}]
[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)/IF(F9<67,(F9/1.03),65)*$E9+F11","v":1.2280574216926774},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(G9<67,(G9/1.03),65)*$E9+G11","v":1.2562087718802788},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(H9<67,(H9/1.03),65)*$E9+H11","v":1.2568695874739952},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(I9<67,(I9/1.03),65)*$E9+I11","v":1.2568851078851926},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(J9<67,(J9/1.03),65)*$E9+J11","v":1.256885472413992},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(K9<67,(K9/1.03),65)*$E9+K11","v":1.2568854809757033},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(L9<67,(L9/1.03),65)*$E9+L11","v":1.2568854811767929},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(M9<67,(M9/1.03),65)*$E9+M11","v":1.2568854811815158},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(N9<67,(N9/1.03),65)*$E9+N11","v":1.256885481181627},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/IF(O9<67,(O9/1.03),65)*$E9+O11","v":1.2568854811816295}]
[null,null,"amplifier","DBLE","1",{"$f":"F12+F11*F10","v":47.051174146479745},{"$f":"G12+G11*G10","v":46.000530364765822},45.976434290904194,45.975868657528359,45.975855372632623,45.975855060609511,45.975855053281002,45.97585505310888,45.97585505310483,{"$f":"O12+O11*O10","v":45.975855053104738}]
[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)/IF(F12<67,(F12/1.03),65)*$E12+F14","v":0.61510778710512626},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(G12<67,(G12/1.03),65)*$E12+G14","v":0.62925947865886755},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(H12<67,(H12/1.03),65)*$E12+H14","v":0.62959171251913826},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(I12<67,(I12/1.03),65)*$E12+I14","v":0.62959951563619065},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(J12<67,(J12/1.03),65)*$E12+J14","v":0.6295996989084669},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(K12<67,(K12/1.03),65)*$E12+K14","v":0.62959970321299463},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(L12<67,(L12/1.03),65)*$E12+L14","v":0.62959970331409543},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(M12<67,(M12/1.03),65)*$E12+M14","v":0.62959970331646997},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(N12<67,(N12/1.03),65)*$E12+N14","v":0.62959970331652582},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/IF(O12<67,(O12/1.03),65)*$E12+O14","v":0.62959970331652715}]
[null,null,"amplifier","DBLE","1",{"$f":"F15+F14*F13","v":46.886091518576471},{"$f":"G15+G14*G13","v":45.831649705883358},45.807464467098306,45.806896739521918,45.806883405439571,45.806883092261209,45.806883084905564,45.806883084732803,45.806883084728739,{"$f":"O15+O14*O13","v":45.806883084728646}]
[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)/IF(F15<67,(F15/1.03),65)*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(G15<67,(G15/1.03),65)*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(H15<67,(H15/1.03),65)*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(I15<67,(I15/1.03),65)*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(J15<67,(J15/1.03),65)*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(K15<67,(K15/1.03),65)*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(L15<67,(L15/1.03),65)*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(M15<67,(M15/1.03),65)*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(N15<67,(N15/1.03),65)*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/IF(O15<67,(O15/1.03),65)*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":46.886091518576471},{"$f":"G18+G17*G16","v":45.831649705883358},45.807464467098306,45.806896739521918,45.806883405439571,45.806883092261209,45.806883084905564,45.806883084732803,45.806883084728739,{"$f":"O18+O17*O16","v":45.806883084728646}]
[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)/IF(F18<67,(F18/1.03),65)*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(G18<67,(G18/1.03),65)*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(H18<67,(H18/1.03),65)*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(I18<67,(I18/1.03),65)*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(J18<67,(J18/1.03),65)*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(K18<67,(K18/1.03),65)*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(L18<67,(L18/1.03),65)*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(M18<67,(M18/1.03),65)*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(N18<67,(N18/1.03),65)*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/IF(O18<67,(O18/1.03),65)*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":46.886091518576471},{"$f":"G21+G20*G19","v":45.831649705883358},45.807464467098306,45.806896739521918,45.806883405439571,45.806883092261209,45.806883084905564,45.806883084732803,45.806883084728739,{"$f":"O21+O20*O19","v":45.806883084728646}]
[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":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(F21<67,(F21/1.03),65)+F23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(G21<67,(G21/1.03),65)+G23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(H21<67,(H21/1.03),65)+H23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(I21<67,(I21/1.03),65)+I23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(J21<67,(J21/1.03),65)+J23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(K21<67,(K21/1.03),65)+K23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(L21<67,(L21/1.03),65)+L23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(M21<67,(M21/1.03),65)+M23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(N21<67,(N21/1.03),65)+N23","v":0},{"$f":"$E21*VLOOKUP($D21,specs!$D$5:$H$17,4)/IF(O21<67,(O21/1.03),65)+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":46.886091518576471},{"$f":"F21-(F3-$B$2)","v":45.831649705883358},45.807464467098306,45.806896739521918,45.806883405439571,45.806883092261209,45.806883084905564,45.806883084732803,45.806883084728739,45.806883084728646]
[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":45.806883084728646}]
[]
[]
[]
[]
[]
[]
[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":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[19,10,20,13],[21,3,21,4],[21,5,21,6]]}
[]
[]
[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,"Range $D$5:$H$17",null,null,null,"type","spare",0,null,null,0]
[]
[]
[null,null,null,"Efficiency",null,"tangens alpha",null,null,null,null,"Range $K$5:$L$19",null,"Cable \ntype","ρ (Ω/Km)"]
[null,null,"Load,%","Super2M-90","T-former","Super2M-90","T-former","load span","SpanN",null,null,null,"QR-540 ",5.28]
[null,"L0",4,36.55806621,62.083720929999998,{"$f":"(D25-D24)/($C25-$C24)","v":4.2606763124999993},{"$f":"+(E25-E24)/($C25-$C24)","v":3.4893378800000008},{"$f":"+C25-C24","v":4},1,null,null,null,"QR-715 ",3.27]
[null,"L1",8,53.600771459999997,76.041072450000001,{"$f":"(D26-D25)/($C26-$C25)","v":2.4445559925000016},1.5768140174999985,{"$f":"+C26-C25","v":4},2,null,null,null,"QR-860 ",2.37]
[null,"L2",12,63.378995430000003,82.348328519999995,1.4451867049999993,0.7958163650000003,8,3,null,null,null,"P3-500 ",5.64]
[null,"L3",20,74.940489069999998,88.714859439999998,0.7155390490000002,0.27130518400000059,10,4,null,null,null,"P3-565 ",4.26]
[null,"L4",30,82.09587956,91.427911280000004,0.48487377400000042,0.12942325799999993,10,5,null,null,null,"P3-625 ",3.61]
[null,"L5",40,86.944617300000004,92.722143860000003,0.17963340999999958,0.11173976900000042,10,6]
[null,"L6",50,88.7409514,93.839541550000007,0.11277000900000048,3.6879177999999513E-2,10,7]
[null,"L7",60,89.868651490000005,94.208333330000002,8.9180478000000105E-2,3.8966666999999691E-2,10,8]
[null,"L8",70,90.760456270000006,94.597999999999999,5.1471151999999167E-2,-5.6377240000003324E-3,10,9]
[null,"L9",80,91.275167789999998,94.541622759999996,4.0063600000053159E-4,-3.8172269999999744E-2,10,10]
[null,"L10",90,91.279174150000003,94.159900059999998,3.6039225000000383E-2,-8.7130945999999196E-2,10,11]
[null,"L11",100,91.639566400000007,93.288590600000006]