{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Control","AUX2","Net42","Net41","Net32","Net31","Net22","Net21","Net12","Net11","AUX","specs"],"not_rendered":{"charts":0,"images":554,"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":"Control","index":0,"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:  935 W"]
[null,null,null,null,"Ferro:  987 W"]

{"sheet":"AUX2","index":1,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":true,"merged":[[3,15,3,16],[47,0,51,17],[59,4,59,5],[59,6,59,7]]}
[{"$f":"'Net42'!B1+'Net41'!B1+'Net32'!B1+'Net31'!B1+'Net22'!B1+'Net21'!B1+'Net12'!B1+'Net11'!B1+SUM(A7:A18)","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,66,"66V","V0",1]
[null,null,{"$f":"+C5*1","v":66},null,null,null,null,null,null,"m",null,null,null,null,null,null,null,null,61.802129379414225,"61,8V","V01",2]
[null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,62.217145308323502,"62,2V","V02",3]
[null,null,null,"V","m","i temp","i","drop","k","dist","L","cable","Vinput",1E-4,null,null,null,null,63.091997970258099,"63,1V","V03",4]
["PS - Imax Vout",15,"66","V","-","A","A","V","-","m","km",null,"V","accuracy",null,null,null,null,63.091931522576296,"63,1V","V04",5]
["Vmin amp.",44,{"$f":"IF(C2=60,66,90)","v":90},63.091997970258099,null,null,null,null,null,null,null,null,null,{"$f":"ABS(SUM(N7:N14))","v":1.0724305994358474E-5},null,null,null,null,2.0154231201887813,"2A","I01",6]
[{"$f":"IF(D7<0,1,0)","v":0},7,11,{"$f":"+D15-H7","v":61.802129379414225},1,{"$f":"+'Net11'!D2","v":1.0055794994991896},{"$f":"+F7*E7","v":1.0055794994991896},{"$f":"+G7*K7*VLOOKUP(L7,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J7,(J7*0.3048))/1000*I7","v":0},"cable",61.802132578521636,{"$f":"E7*(+M7-D7)","v":3.1991074109782858E-6},null,null,null,null,3.0125780369648538,"3A","I02",7]
[0,8,12,{"$f":"+D15-H8","v":61.802129379414225},1,{"$f":"+'Net12'!D2","v":1.0098436206895918},{"$f":"+F8*E8","v":1.0098436206895918},{"$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",61.802132578521636,{"$f":"E8*(+M8-D8)","v":3.1991074109782858E-6},null,null,null,null,6.245397936236639,"6,2A","I03",8]
[0,9,21,{"$f":"+D16-H9","v":62.217145308323502},1,{"$f":"+'Net21'!D2","v":0.49869390543214021},0.49869390543214021,{"$f":"+G9*K9*VLOOKUP(L9,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",62.217147471369088,2.1630455862009512E-6,null,null,null,null,13.346114522079629,"13,3A","I04",9]
[0,10,22,{"$f":"+D16-H10","v":62.217145308323502},1,{"$f":"+'Net22'!D2","v":0.49846101134393234},0.49846101134393234,{"$f":"+G10*K10*VLOOKUP(L10,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",62.217147471369088,2.1630455862009512E-6,null,null,null,null,61.802129379414225,"61,8V","V11",10]
[0,11,31,{"$f":"+D17-H11","v":63.091997970258099},1,{"$f":"+'Net31'!D2","v":0.49699591284244499},0.49699591284244499,{"$f":"+G11*K11*VLOOKUP(L11,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.091997970258099,0,null,null,null,null,61.802129379414225,"61,8V","V12",11]
[0,12,32,{"$f":"+D17-H12","v":63.091997970258099},1,{"$f":"+'Net32'!D2","v":2.7358239864293399},2.7358239864293399,{"$f":"+G12*K12*VLOOKUP(L12,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.091997970258099,0,null,null,null,null,62.217145308323502,"62,2V","V21",12]
[0,13,41,{"$f":"+D18-H13","v":63.091997970258099},1,{"$f":"+'Net41'!D2","v":0.99606359520953225},0.99606359520953225,{"$f":"+G13*K13*VLOOKUP(L13,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.091997970258099,0,null,null,null,null,62.217145308323502,"62,2V","V22",13]
[0,14,42,{"$f":"+D18-H14","v":63.091997970258099},1,{"$f":"+'Net42'!D2","v":2.3406277280956131},2.3406277280956131,{"$f":"+G14*K14*VLOOKUP(L14,specs!$K$5:$L$19,2)","v":0},1,0,0,"cable",63.091997970258099,0,null,null,null,null,63.091997970258099,"63,1V","V31",14]
[{"$f":"IF(D15<0,1,0)","v":0},15,"01",{"$f":"+D16-H15","v":61.802129379414225},1,{"$f":"SUM(F7:F8)","v":2.0154231201887813},{"$f":"+F15*E15","v":2.0154231201887813},{"$f":"+G15*K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0.41501592890927391},1,"39",{"$f":"+IF($J$5=\"m\",J15,(J15*0.3048))/1000*I15","v":3.9E-2},"QR540",{"$f":"K15*VLOOKUP(L15,specs!$K$5:$L$19,2)","v":0.20592000000000002},null,null,null,null,null,63.091997970258099,"63,1V","V32",15]
[{"$f":"IF(D16<0,1,0)","v":0},16,"02",{"$f":"+D17-H16","v":62.217145308323502},1,{"$f":"SUM(F7:F10)","v":3.0125780369648538},{"$f":"+F16*E16","v":3.0125780369648538},{"$f":"+G16*K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0.87485266193459366},1,"55",{"$f":"+IF($J$5=\"m\",J16,(J16*0.3048))/1000*I16","v":5.5E-2},"QR540",{"$f":"K16*VLOOKUP(L16,specs!$K$5:$L$19,2)","v":0.29039999999999999},null,null,null,null,null,63.091997970258099,"63,1V","V41",16]
[{"$f":"IF(D17<0,1,0)","v":0},17,"03",{"$f":"+D18-H17","v":63.091997970258099},1,{"$f":"SUM(F7:F12)","v":6.245397936236639},{"$f":"+F17*E17","v":6.245397936236639},{"$f":"+G17*K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},1,0,{"$f":"+IF($J$5=\"m\",J17,(J17*0.3048))/1000*I17","v":0},"cable",{"$f":"K17*VLOOKUP(L17,specs!$K$5:$L$19,2)","v":0},null,null,null,null,null,63.091997970258099,"63,1V","V42",17]
[{"$f":"IF(D18<0,1,0)","v":0},18,"04",{"$f":"+D6-H18","v":63.091997970258099},0,{"$f":"SUM(F7:F14)","v":9.5820892595417853},{"$f":"+F18*E18","v":0},{"$f":"+G18*K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":0},1,"600",{"$f":"+IF($J$5=\"m\",J18,(J18*0.3048))/1000*I18","v":0.6},"QR860",{"$f":"K18*VLOOKUP(L18,specs!$K$5:$L$19,2)","v":1.4219999999999999},null,null,null,null,null,1.0055794994991896,"1A","I11",18]
[null,null,null,null,null,null,null,"D6:L18",null,null,null,null,null,null,null,null,null,null,1.0098436206895918,"1A","I12",19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49869390543214021,"0,5A","I21",20]
[null,"Booster Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.49846101134393234,"0,5A","I22",21]
[null,null,"vba","vba","vba",null,null,null,null,null,null,null,null,null,null,null,null,null,0.49699591284244499,"0,5A","I31",22]
["Vin","Ranges","Mcont","TrEff","Bgain","Vout","Pin","Iin","Final Gain ","Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,2.7358239864293399,"2,7A","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.99606359520953225,"1A","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,2.3406277280956131,"2,3A","I42",25]
[49.9,"0-49.9",1.0249999999999999,96.5,1.4079999999999999,{"$f":"A26*E26/C26-1.5","v":67.04556097560976},{"$f":"M26+L26+K26","v":207.33056916810847},{"$f":"G26/A26","v":4.1549212258137969},{"$f":"F26/A26","v":1.3435984163448851},{"$f":"M26/G26","v":0.96464308568909263},{"$f":"N26*1.5","v":4.4745691681084718},{"$f":"M26*(E26-1)*0.035","v":2.8559999999999994},200,{"$f":"M26/F26","v":2.9830461120723148},null,null,null,null,61.261979473855,"61,3V","Vend11",26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.052298619367157,"61,1V","Vend12",27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.961856087300269,"62V","Vend21",28]
["Vin",null,null,null,null,"Vout","Pin","Iin",null,"Efficiency","P-triac ","P-transformer ","Pout","Iout",null,null,null,null,61.990806295338032,"62V","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,62.173549523325264,"62,2V","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.998652457998524,"56V","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,61.76681317273291,"61,8V","Vend41",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61.850807256554667,"61,9V    ","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,47.021825149602769,"47V","PBVin",34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63.091931522576296,"63,1V","PBVout",35]
["Pout =  Vout x Iout;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.346114522079629,"13,3A","PBcurin",36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5820892595417853,"9,6A","PBcurout",37]
["Ptriac = Vtriac * Iout  , where   Vtriac=1.5V;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.3417584562454885,"1,34","Bgain",38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PB Location I","STitleLocation",39]
["Pdelta-transformer = (100 - K) / 100 * (n – 1)  *  Pout  , where  K=96.5%  for range\"1.32\" , K=96.8% for range \"1.2\" and K=97% for range \"1\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V in","sTitleVin",40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V out","sTitleVout",41]
["Then, assuming",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I in","STitleIin",42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I out","sTitleIout",43]
["Vout = Vin * n / Mcont  –  Vtriac ,  where Mcont = 1 for range\"1\", Mcont=1.025 for other two ranges;",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain","sTitleGain",44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"time",45]
["We get  finally the booster input current Iin, derived from above, as a function of the booster output current Iout and the booster input voltage Vin:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,"cntext",46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,"cntloc",47]
["Iin = Iout * n / Mcont * (1 + K / 100) * (n – 1) * [ 1 – Vtriac / (Vout + Vtriac) ]}",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,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]
[]
[]
[]
[]
[]
[null,null,null,null,"Efficiency",null,"tangens alpha"]
[null,null,null,"Load,%","Super2M-90","T-former","Super2M-90","T-former","load span","SpanN"]
[null,null,"L0",4,36.55806621,62.083720929999998,{"$f":"(E63-E62)/($D63-$D62)","v":4.2606763124999993},{"$f":"+(F63-F62)/($D63-$D62)","v":3.4893378800000008},{"$f":"+D63-D62","v":4},1]
[null,null,"L1",8,53.600771459999997,76.041072450000001,2.4445559925000016,1.5768140174999985,4,2]
[null,null,"L2",12,63.378995430000003,82.348328519999995,1.4451867049999993,0.7958163650000003,8,3]
[null,null,"L3",20,74.940489069999998,88.714859439999998,0.7155390490000002,0.27130518400000059,10,4]
[null,null,"L4",30,82.09587956,91.427911280000004,0.48487377400000042,0.12942325799999993,10,5]
[null,null,"L5",40,86.944617300000004,92.722143860000003,0.17963340999999958,0.11173976900000042,10,6]
[null,null,"L6",50,88.7409514,93.839541550000007,0.11277000900000048,3.6879177999999513E-2,10,7]
[null,null,"L7",60,89.868651490000005,94.208333330000002,8.9180478000000105E-2,3.8966666999999691E-2,10,8]
[null,null,"L8",70,90.760456270000006,94.597999999999999,5.1471151999999167E-2,-5.6377240000003324E-3,10,9]
[null,null,"L9",80,91.275167789999998,94.541622759999996,4.0063600000053159E-4,-3.8172269999999744E-2,10,10]
[null,null,"L10",90,91.279174150000003,94.159900059999998,3.6039225000000383E-2,-8.7130945999999196E-2,10,11]
[null,null,"L11",100,91.639566400000007,93.288590600000006]

{"sheet":"Net42","index":2,"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":63.091997970258099},"U start, V",{"$f":"+O5*1","v":2.3406277280956131},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":64.308917645817942},{"$f":"G6+G5*G4","v":63.115785148219771},63.092472180672154,63.092007427576306,63.09199815886965,63.091997974019662,63.091997970333118,63.091997970259598,63.09199797025812,63.091997970258106]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":2.2954851710424169},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":2.339728140739564},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":2.3406097875012293},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":2.3406273702983302},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":2.3406277209599002},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":2.3406277279533025},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":2.340627728092775},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":2.3406277280955567},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":2.3406277280956123},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":2.3406277280956131}]
[null,null,"amplifier","TNA","1",{"$f":"F9+F8*F7","v":64.308917645817942},{"$f":"G9+G8*G7","v":63.115785148219771},63.092472180672154,63.092007427576306,63.09199815886965,63.091997974019662,63.091997970333118,63.091997970259598,63.09199797025812,63.091997970258106]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.46992}]
[null,null,"span length,m","89",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":1.4626302271140759},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":1.4911290165391624},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":1.4916971019018264},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":1.4917084313743811},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":1.4917086573231373},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":1.4917086618293356},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":1.4917086619192046},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":1.4917086619209969},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":1.4917086619210327},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":1.4917086619210334}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":63.621598449492495},{"$f":"G12+G11*G10","v":62.415073800767686},62.391493878546449,62.391023801504858,62.391014426620359,62.391014239652819,62.391014235924047,62.391014235849681,62.391014235848189,62.391014235848175]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.20064000000000001}]
[null,null,"span length,m","38",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0.97694610799326054},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0.99605630223565178},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0.99643728234772078},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0.99644488034967904},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0.99644503188004929},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0.99644503490208802},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0.99644503496235781},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0.99644503496355985},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0.99644503496358383},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0.99644503496358428}]
[null,null,"amplifier","LEX","1",{"$f":"F15+F14*F13","v":63.42558398238473},{"$f":"G15+G14*G13","v":62.215225064287125},62.191568702216202,62.191097100711495,62.191087695423946,62.191087507850064,62.191087504109198,62.191087504034591,62.191087504033099,62.191087504033078]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.68112000000000006}]
[null,null,"span length,m","129",0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0.48976099971610382},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0.4993933074771989},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0.49958536745304338},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0.49958919777567778},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0.49958927416552962},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0.49958927568900702},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0.49958927571939038},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0.49958927571999634},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0.4995892757200085},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0.49958927572000866}]
[null,null,"amplifier","LEX","1",{"$f":"F18+F17*F16","v":63.091997970258099},{"$f":"G18+G17*G16","v":61.875078294698255},61.851291116736583,61.850816906322528,61.850807449004321,61.85080726039277,61.850807256631207,61.850807256556187,61.850807256554688,61.850807256554667]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.091997970258099},{"$f":"G21+G20*G19","v":61.875078294698255},61.851291116736583,61.850816906322528,61.850807449004321,61.85080726039277,61.850807256631207,61.850807256556187,61.850807256554688,61.850807256554667]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.091997970258099},{"$f":"F21-(F3-$B$2)","v":61.875078294698255},61.851291116736583,61.850816906322528,61.850807449004321,61.85080726039277,61.850807256631207,61.850807256556187,61.850807256554688,61.850807256554667]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.850807256554667}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net42"]

{"sheet":"Net41","index":3,"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":63.091997970258099},"U start, V",{"$f":"+O5*1","v":0.99606359520953225},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":64.389487713051949},{"$f":"G6+G5*G4","v":63.119102165420202},63.092576218657136,63.092010312255901,63.091998233685295,63.091997975880673,63.091997970378117,63.091997970260657,63.091997970258149,63.091997970258099]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.77088000000000001}]
[null,null,"span length,m","146",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.97532275870450624},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.99562115109806859},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.99605415180789936},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.99606339364988661},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.99606359090744889},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.99606359511770881},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.99606359520757226},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.9960635952094905},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.99606359520953136},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.99606359520953225}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":63.637630904821819},{"$f":"G9+G8*G7","v":62.35159773246172},62.324737994111466,62.324164963359074,62.32415273272656,62.324152471676335,62.324152466104501,62.324152465985563,62.324152465983026,62.324152465982976]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":1.1140800000000002}]
[null,null,"span length,m","211",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0.48976099971610382},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0.50004443576535584},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0.50026386059288497},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0.50026854396090348},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0.50026864392256454},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0.50026864605614341},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0.50026864610168242},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0.50026864610265454},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0.50026864610267519},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0.50026864610267563}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":63.091997970258099},{"$f":"G12+G11*G10","v":61.794508227464249},61.767404032302146,61.766825783903109,61.766813441905306,61.76681317847811,61.766813172855535,61.766813172735517,61.766813172732959,61.76681317273291]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":63.091997970258099},{"$f":"G15+G14*G13","v":61.794508227464249},61.767404032302146,61.766825783903109,61.766813441905306,61.76681317847811,61.766813172855535,61.766813172735517,61.766813172732959,61.76681317273291]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":63.091997970258099},{"$f":"G18+G17*G16","v":61.794508227464249},61.767404032302146,61.766825783903109,61.766813441905306,61.76681317847811,61.766813172855535,61.766813172735517,61.766813172732959,61.76681317273291]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.091997970258099},{"$f":"G21+G20*G19","v":61.794508227464249},61.767404032302146,61.766825783903109,61.766813441905306,61.76681317847811,61.766813172855535,61.766813172735517,61.766813172732959,61.76681317273291]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.091997970258099},{"$f":"F21-(F3-$B$2)","v":61.794508227464249},61.767404032302146,61.766825783903109,61.766813441905306,61.76681317847811,61.766813172855535,61.766813172735517,61.766813172732959,61.76681317273291]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.76681317273291}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net41"]

{"sheet":"Net32","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'!M12","v":63.091997970258099},"U start, V",{"$f":"+O5*1","v":2.7358239864293399},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":69.39778269765813},{"$f":"G6+G5*G4","v":63.782610184088441},63.176868516846625,63.102569098205684,63.093316861311827,63.092162553906533,63.092018509088057,63.092000533361457,63.091998290115711,63.09199801017413]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":2.1120000000000001}]
[null,null,"span length,m","400",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":2.4325412213116113},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":2.6984995469749102},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":2.7311741810753469},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":2.7352438494161824},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":2.7357515931855518},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":2.7358149541990038},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":2.7358228611873381},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":2.7358238479245625},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":2.7358239710625663},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":2.7358239864293399}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":64.260255638248012},{"$f":"G9+G8*G7","v":58.083379140877426},57.408628646415494,57.325734088238704,57.315409496503939,57.314121370638233,57.313960626260396,57.31394056654478,57.313938063231575,57.313937750835365]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.39072000000000001}]
[null,null,"span length,m","74",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":1.9516841239799259},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":2.1665057054139005},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":2.1929275667847379},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":2.1962189159990695},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":2.1966295617555085},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":2.1966808060860759},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":2.1966872010033152},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":2.1966879990445971},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":2.1966880986346484},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":2.1966881110627998}]
[null,null,"amplifier","LEX","2",{"$f":"F12+F11*F10","v":63.497693617326568},{"$f":"G12+G11*G10","v":57.236882031658105},56.551807987521364,56.467627433379548,56.457142394134827,56.455834246084279,56.455671003084383,56.455650631558072,56.455648089333046,56.455647772080908]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0.26928000000000002}]
[null,null,"span length,m","51",0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0.97842042762518644},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":1.0867823206596787},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":1.1001243090420907},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":1.1017865339601471},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":1.1019939252479791},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":1.1020198055839638},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":1.1020230352612477},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":1.1020234383025675},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":1.1020234885993463},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":1.1020234948760375}]
[null,null,"amplifier","LEX","1",{"$f":"F15+F14*F13","v":63.234224564575655},{"$f":"G15+G14*G13","v":56.944233288350866},56.255566513582508,56.170938355514757,56.160397469944051,56.159082352836627,56.158918240149234,56.158897760091953,56.158895204323017,56.15889488538069]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0.29040000000000005}]
[null,null,"span length,m","55",0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0.48976099971610382},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0.54414616216527267},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0.55084533248890966},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0.55168000370371784},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0.55178414411996846},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0.55179713980282985},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0.55179876156950625},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0.55179896395473971},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0.551798989211022},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0.55179899236283181}]
[null,null,"amplifier","LEX","1",{"$f":"F18+F17*F16","v":63.091997970258099},{"$f":"G18+G17*G16","v":56.786213242858068},56.095601029027726,56.0107304824392,56.000159354491615,55.998840463437887,55.998675879789452,55.998655340959495,55.998652777856137,55.998652457998524]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.091997970258099},{"$f":"G21+G20*G19","v":56.786213242858068},56.095601029027726,56.0107304824392,56.000159354491615,55.998840463437887,55.998675879789452,55.998655340959495,55.998652777856137,55.998652457998524]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.091997970258099},{"$f":"F21-(F3-$B$2)","v":56.786213242858068},56.095601029027726,56.0107304824392,56.000159354491615,55.998840463437887,55.998675879789452,55.998655340959495,55.998652777856137,55.998652457998524]
[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.998652457998524}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net32"]

{"sheet":"Net31","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'!M11","v":63.091997970258099},"U start, V",{"$f":"+O5*1","v":0.49699591284244499},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":63.997076297733457},{"$f":"G6+G5*G4","v":63.105170624307718},63.092192518650243,63.092000844182685,63.091998012712672,63.091997970885252,63.091997970267364,63.091997970258234,63.091997970258099,63.091997970258099]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":1.8480000000000001}]
[null,null,"span length,m","350",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.48976099971610382},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.49688905926676136},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.49699433437073653},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.49699588952473467},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.49699591249798802},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.49699591283735661},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.49699591284236988},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.49699591284244393},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.49699591284244499},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.49699591284244499}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":63.091997970258099},{"$f":"G9+G8*G7","v":62.18691964278274},62.173746988733122,62.173552440340977,62.173549566416391,62.173549523961817,62.173549523334664,62.173549523325399,62.173549523325264,62.173549523325264]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":63.091997970258099},{"$f":"G12+G11*G10","v":62.18691964278274},62.173746988733122,62.173552440340977,62.173549566416391,62.173549523961817,62.173549523334664,62.173549523325399,62.173549523325264,62.173549523325264]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":63.091997970258099},{"$f":"G15+G14*G13","v":62.18691964278274},62.173746988733122,62.173552440340977,62.173549566416391,62.173549523961817,62.173549523334664,62.173549523325399,62.173549523325264,62.173549523325264]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":63.091997970258099},{"$f":"G18+G17*G16","v":62.18691964278274},62.173746988733122,62.173552440340977,62.173549566416391,62.173549523961817,62.173549523334664,62.173549523325399,62.173549523325264,62.173549523325264]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":63.091997970258099},{"$f":"G21+G20*G19","v":62.18691964278274},62.173746988733122,62.173552440340977,62.173549566416391,62.173549523961817,62.173549523334664,62.173549523325399,62.173549523325264,62.173549523325264]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":63.091997970258099},{"$f":"F21-(F3-$B$2)","v":62.18691964278274},62.173746988733122,62.173552440340977,62.173549566416391,62.173549523961817,62.173549523334664,62.173549523325399,62.173549523325264,62.173549523325264]
[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":62.173549523325264}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net31"]

{"sheet":"Net22","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'!M10","v":62.217147471369088},"U start, V",{"$f":"+O5*1","v":0.49846101134393234},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.442665235687308},{"$f":"G6+G5*G4","v":62.21796787667644},62.21715046679757,62.217147482306011,62.217147471409021,62.217147471369231,62.217147471369096,62.217147471369088,62.217147471369088,62.217147471369088]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004}]
[null,null,"span length,m","86",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.49664764869233963},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.49845439047209733},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.4984609871697695},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.49846101125566744},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.49846101134361004},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.49846101134393112},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.49846101134393228},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.49846101134393234},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.49846101134393234},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.49846101134393234}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.217147471369088},{"$f":"G9+G8*G7","v":61.991629707050869},61.990809301743518,61.990806306315037,61.990806295378114,61.990806295338182,61.990806295338039,61.990806295338032,61.990806295338032,61.990806295338032]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":62.217147471369088},{"$f":"G12+G11*G10","v":61.991629707050869},61.990809301743518,61.990806306315037,61.990806295378114,61.990806295338182,61.990806295338039,61.990806295338032,61.990806295338032,61.990806295338032]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":62.217147471369088},{"$f":"G15+G14*G13","v":61.991629707050869},61.990809301743518,61.990806306315037,61.990806295378114,61.990806295338182,61.990806295338039,61.990806295338032,61.990806295338032,61.990806295338032]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":62.217147471369088},{"$f":"G18+G17*G16","v":61.991629707050869},61.990809301743518,61.990806306315037,61.990806295378114,61.990806295338182,61.990806295338039,61.990806295338032,61.990806295338032,61.990806295338032]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":62.217147471369088},{"$f":"G21+G20*G19","v":61.991629707050869},61.990809301743518,61.990806306315037,61.990806295378114,61.990806295338182,61.990806295338039,61.990806295338032,61.990806295338032,61.990806295338032]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":62.217147471369088},{"$f":"F21-(F3-$B$2)","v":61.991629707050869},61.990809301743518,61.990806306315037,61.990806295378114,61.990806295338182,61.990806295338039,61.990806295338032,61.990806295338032,61.990806295338032]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.990806295338032}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net22"]

{"sheet":"Net21","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'!M9","v":62.217147471369088},"U start, V",{"$f":"+O5*1","v":0.49869390543214021},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.47139133568767},{"$f":"G6+G5*G4","v":62.218190675266598},62.217151769439909,62.217147489077732,62.217147471442054,62.217147471369387,62.217147471369088,62.217147471369088,62.217147471369088,62.217147471369088]
[null,null,"cable type","QR860",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.51192000000000004}]
[null,null,"span length,m","216",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.49664764869233963},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":0.49868547471497149},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":0.49869387069642634},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":0.49869390528902424},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":0.49869390543155051},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":0.49869390543213782},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":0.49869390543214021},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":0.49869390543214021},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":0.49869390543214021},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":0.49869390543214021}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.217147471369088},{"$f":"G9+G8*G7","v":61.962903607050507},61.961860403152997,61.961856105082177,61.961856087373533,61.961856087300568,61.961856087300269,61.961856087300269,61.961856087300269,61.961856087300269]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0}]
[null,null,"amplifier","load",0,{"$f":"F12+F11*F10","v":62.217147471369088},{"$f":"G12+G11*G10","v":61.962903607050507},61.961860403152997,61.961856105082177,61.961856087373533,61.961856087300568,61.961856087300269,61.961856087300269,61.961856087300269,61.961856087300269]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":62.217147471369088},{"$f":"G15+G14*G13","v":61.962903607050507},61.961860403152997,61.961856105082177,61.961856087373533,61.961856087300568,61.961856087300269,61.961856087300269,61.961856087300269,61.961856087300269]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":62.217147471369088},{"$f":"G18+G17*G16","v":61.962903607050507},61.961860403152997,61.961856105082177,61.961856087373533,61.961856087300568,61.961856087300269,61.961856087300269,61.961856087300269,61.961856087300269]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":62.217147471369088},{"$f":"G21+G20*G19","v":61.962903607050507},61.961860403152997,61.961856105082177,61.961856087373533,61.961856087300568,61.961856087300269,61.961856087300269,61.961856087300269,61.961856087300269]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":62.217147471369088},{"$f":"F21-(F3-$B$2)","v":61.962903607050507},61.961860403152997,61.961856105082177,61.961856087373533,61.961856087300568,61.961856087300269,61.961856087300269,61.961856087300269,61.961856087300269]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.961856087300269}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net21"]

{"sheet":"Net12","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'!M8","v":61.802132578521636},"U start, V",{"$f":"+O5*1","v":1.0098436206895918},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.542894819686175},{"$f":"G6+G5*G4","v":61.811093218411415},61.802242296333993,61.802133922151022,61.802132594976051,61.802132578723146,61.802132578524102,61.802132578521665,61.802132578521636,61.802132578521636]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.45408000000000004}]
[null,null,"span length,m","86",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.99764836762253295},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":1.0096943015798467},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":1.0098417920943787},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":1.0098435982961569},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":1.0098436204153565},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":1.0098436206862336},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":1.0098436206895509},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":1.0098436206895913},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":1.0098436206895918},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":1.0098436206895918}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.089882648916138},{"$f":"G9+G8*G7","v":61.352611229950035},61.343693335379776,61.3435841410367,61.343582803817846,61.343582787441939,61.343582787241388,61.343582787238937,61.343582787238908,61.343582787238908]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.57552000000000003}]
[null,null,"span length,m","109",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0.49998274672383736},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0.50604825652095631},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0.50612252903888},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0.50612343859767939},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0.50612344973636447},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0.50612344987277147},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0.50612344987444202},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0.50612344987446245},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0.50612344987446267},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0.50612344987446267}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":61.802132578521636},{"$f":"G12+G11*G10","v":61.061370337357097},61.052409697467318,61.052299979654961,61.052298636025576,61.052298619571161,61.052298619369651,61.052298619367185,61.052298619367157,61.052298619367157]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":61.802132578521636},{"$f":"G15+G14*G13","v":61.061370337357097},61.052409697467318,61.052299979654961,61.052298636025576,61.052298619571161,61.052298619369651,61.052298619367185,61.052298619367157,61.052298619367157]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":61.802132578521636},{"$f":"G18+G17*G16","v":61.061370337357097},61.052409697467318,61.052299979654961,61.052298636025576,61.052298619571161,61.052298619369651,61.052298619367185,61.052298619367157,61.052298619367157]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":61.802132578521636},{"$f":"G21+G20*G19","v":61.061370337357097},61.052409697467318,61.052299979654961,61.052298636025576,61.052298619571161,61.052298619369651,61.052298619367185,61.052298619367157,61.052298619367157]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":61.802132578521636},{"$f":"F21-(F3-$B$2)","v":61.061370337357097},61.052409697467318,61.052299979654961,61.052298636025576,61.052298619571161,61.052298619369651,61.052298619367185,61.052298619367157,61.052298619367157]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.052298619367157}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net12"]

{"sheet":"Net11","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'!M7","v":61.802132578521636},"U start, V",{"$f":"+O5*1","v":1.0055794994991896},null,1,2,3,4,5,6,7,8,9,"iteration10"]
[null,null,null,null,"mult.",{"$f":"F6+F5*F4","v":62.337572841165034},{"$f":"G6+G5*G4","v":61.806803942509525},61.802173691478288,61.802132940387011,61.802132581706687,61.802132578549667,61.802132578521878,61.802132578521636,61.802132578521636,{"$f":"O6+O5*O4","v":61.802132578521636}]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784},{"$f":"VLOOKUP($D4,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D5,($D5*0.3048))/1000","v":0.14784}]
[null,null,"span length,m","28",0,{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/F6*1.03*$E6+F8","v":0.99684560299123615},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/G6*1.03*$E6+G8","v":1.0055026364636939},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/H6*1.03*$E6+H8","v":1.00557882297142},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/I6*1.03*$E6+I8","v":1.005579493544567},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/J6*1.03*$E6+J8","v":1.0055794994467786},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/K6*1.03*$E6+K8","v":1.0055794994987284},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/L6*1.03*$E6+L8","v":1.0055794994991856},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/M6*1.03*$E6+M8","v":1.0055794994991896},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/N6*1.03*$E6+N8","v":1.0055794994991896},{"$f":"VLOOKUP($D6,specs!$D$5:$H$17,4)/O6*1.03*$E6+O8","v":1.0055794994991896}]
[null,null,"amplifier","LEX","1",{"$f":"F9+F8*F7","v":62.190199187218809},{"$f":"G9+G8*G7","v":61.658150432734736},61.653508918290193,61.653468068061379,61.653467708508472,61.653467705343772,61.653467705315919,61.653467705315677,61.653467705315677,{"$f":"O9+O8*O7","v":61.653467705315677}]
[null,null,"cable type","QR540",0,{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007},{"$f":"VLOOKUP($D7,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D8,($D8*0.3048))/1000","v":0.77616000000000007}]
[null,null,"span length,m","147",0,{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/F9*1.03*$E9+F11","v":0.49998274672383736},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/G9*1.03*$E9+G11","v":0.50435234598084833},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/H9*1.03*$E9+H11","v":0.50439080395774183},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/I9*1.03*$E9+I11","v":0.50439114245475603},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/J9*1.03*$E9+J11","v":0.50439114543411934},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/K9*1.03*$E9+K11","v":0.50439114546034292},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/L9*1.03*$E9+L11","v":0.50439114546057373},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/M9*1.03*$E9+M11","v":0.50439114546057573},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/N9*1.03*$E9+N11","v":0.50439114546057573},{"$f":"VLOOKUP($D9,specs!$D$5:$H$17,4)/O9*1.03*$E9+O11","v":0.50439114546057573}]
[null,null,"amplifier","LEX","1",{"$f":"F12+F11*F10","v":61.802132578521636},{"$f":"G12+G11*G10","v":61.266692315878238},61.262020951890349,61.261979838933698,61.261979477068323,61.261979473883272,61.261979473855241,61.261979473855,61.261979473855,{"$f":"O12+O11*O10","v":61.261979473855}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0},{"$f":"VLOOKUP($D10,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D11,($D11*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/F12*1.03*$E12+F14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/G12*1.03*$E12+G14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/H12*1.03*$E12+H14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/I12*1.03*$E12+I14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/J12*1.03*$E12+J14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/K12*1.03*$E12+K14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/L12*1.03*$E12+L14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/M12*1.03*$E12+M14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/N12*1.03*$E12+N14","v":0},{"$f":"VLOOKUP($D12,specs!$D$5:$H$17,4)/O12*1.03*$E12+O14","v":0}]
[null,null,"amplifier","load",0,{"$f":"F15+F14*F13","v":61.802132578521636},{"$f":"G15+G14*G13","v":61.266692315878238},61.262020951890349,61.261979838933698,61.261979477068323,61.261979473883272,61.261979473855241,61.261979473855,61.261979473855,{"$f":"O15+O14*O13","v":61.261979473855}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0},{"$f":"VLOOKUP($D13,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D14,($D14*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/F15*1.03*$E15+F17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/G15*1.03*$E15+G17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/H15*1.03*$E15+H17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/I15*1.03*$E15+I17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/J15*1.03*$E15+J17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/K15*1.03*$E15+K17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/L15*1.03*$E15+L17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/M15*1.03*$E15+M17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/N15*1.03*$E15+N17","v":0},{"$f":"VLOOKUP($D15,specs!$D$5:$H$17,4)/O15*1.03*$E15+O17","v":0}]
[null,null,"amplifier","load",0,{"$f":"F18+F17*F16","v":61.802132578521636},{"$f":"G18+G17*G16","v":61.266692315878238},61.262020951890349,61.261979838933698,61.261979477068323,61.261979473883272,61.261979473855241,61.261979473855,61.261979473855,{"$f":"O18+O17*O16","v":61.261979473855}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0},{"$f":"VLOOKUP($D16,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D17,($D17*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/F18*1.03*$E18+F20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/G18*1.03*$E18+G20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/H18*1.03*$E18+H20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/I18*1.03*$E18+I20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/J18*1.03*$E18+J20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/K18*1.03*$E18+K20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/L18*1.03*$E18+L20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/M18*1.03*$E18+M20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/N18*1.03*$E18+N20","v":0},{"$f":"VLOOKUP($D18,specs!$D$5:$H$17,4)/O18*1.03*$E18+O20","v":0}]
[null,null,"amplifier","load",0,{"$f":"F21+F20*F19","v":61.802132578521636},{"$f":"G21+G20*G19","v":61.266692315878238},61.262020951890349,61.261979838933698,61.261979477068323,61.261979473883272,61.261979473855241,61.261979473855,61.261979473855,{"$f":"O21+O20*O19","v":61.261979473855}]
[null,null,"cable type","cable",0,{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0},{"$f":"VLOOKUP($D19,specs!$K$5:$L$19,2)*IF($E$1=\"m\",$D20,($D20*0.3048))/1000","v":0}]
[null,null,"span length,m",0,0,{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/F21*1.03*$E21+F23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/G21*1.03*$E21+G23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/H21*1.03*$E21+H23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/I21*1.03*$E21+I23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/J21*1.03*$E21+J23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/K21*1.03*$E21+K23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/L21*1.03*$E21+L23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/M21*1.03*$E21+M23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/N21*1.03*$E21+N23","v":0},{"$f":"VLOOKUP($D21,specs!$D$5:$H$17,4)/O21*1.03*$E21+O23","v":0}]
[null,null,"amplifier","load",0,{"$f":"B2","v":61.802132578521636},{"$f":"F21-(F3-$B$2)","v":61.266692315878238},61.262020951890349,61.261979838933698,61.261979477068323,61.261979473883272,61.261979473855241,61.261979473855,61.261979473855,61.261979473855]
[null,null,null,null,null,{"$f":"IF(F21<0,1,0)","v":0},{"$f":"IF(G21<0,1,0)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User added Branch"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O21","v":61.261979473855}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Main Branch Net11"]

{"sheet":"AUX","index":10,"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":11,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[19,10,20,13]]}
[]
[]
[null,null,null,1,2,3,4,5,null,null,1,2]
[null,null,"amp type","sorted","Inom,A","Vnom,V","Pnom,W",null,"original","cable","sorted","loop_res",null,null,"original"]
[null,null,"load","DBLE",null,60,30,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,30,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,52,1,52,"2x6","QR715 ",3.27,"4x10",13,3.27]
[null,null,null,null,null,null,null,null,null,"4x6","QR860",2.37,"4x6",14,2.37]
[null,null,null,null,null,null,null,null,null,"type","spare",0,null,null,0]