{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Linear Multidrop","Fanout network"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Linear Multidrop","index":0,"n_rows":24,"n_cols":37,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
["Input Voltage",null,110,"Vdc"]
["Min node voltage",null,55,"Vdc"]
["Node self consumption",null,5,"W"]
["Node power efficiency",null,85,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Node power load [W]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Segment length [m]"]
["Cable","Cable type","Resistance","Resistance"]
["segment",null,"[Ω/km]"," [Ω]"]
["0-1","4x0.75 mm²",{"$f":"INDEX($B$22:$B$32, MATCH(B9, $A$22:$A$32, 0))","v":25.25},{"$f":"C9*I16/1000","v":0}]
["1-2","4x0.75 mm²",25.25,{"$f":"C10*M16/1000","v":0}]
["2-3","4x0.75 mm²",25.25,{"$f":"C11*Q16/1000","v":0}]
["3-4","4x0.75 mm²",25.25,{"$f":"C12*U16/1000","v":0}]
["4-5","4x0.75 mm²",25.25,{"$f":"C13*Y16/1000","v":0},null,null,"Total power need",null,null,{"$f":"G16*I17","v":0},"W"]
["5-6","4x0.75 mm²",25.25,{"$f":"C14*AC16/1000","v":0}]
["6-7","4x0.75 mm²",25.25,{"$f":"C15*AG16/1000","v":0}]
["7-8","4x0.75 mm²",25.25,{"$f":"C16*AJ20/1000","v":0},null,null,{"$f":"K16+I17*D9","v":109.9921875},null,0,null,{"$f":"O16+M17*D10","v":109.9921875},null,0,null,{"$f":"S16+Q17*D11","v":109.9921875},null,0,null,{"$f":"W16+U17*D12","v":109.9921875},null,0,null,{"$f":"AA16+Y17*D13","v":109.9921875},null,0,null,{"$f":"AE16+AC17*D14","v":109.9921875},null,0,null,{"$f":"AI16+AG17*D15","v":109.9921875},null,0,null,{"$f":"AI22+AK18*D16","v":109.9921875}]
["8-9","4x0.75 mm²",25.25,{"$f":"C17*AG22/1000","v":0},null,null,null,null,{"$f":"(100/$C$5)*(K18+IF(K18=0,0,$C$4))/K16+M17","v":0},null,null,null,{"$f":"(100/$C$5)*(O18+IF(O18=0,0,$C$4))/O16+Q17","v":0},null,null,null,{"$f":"(100/$C$5)*(S18+IF(S18=0,0,$C$4))/S16+U17","v":0},null,null,null,{"$f":"(100/$C$5)*(W18+IF(W18=0,0,$C$4))/W16+Y17","v":0},null,null,null,{"$f":"(100/$C$5)*(AA18+IF(AA18=0,0,$C$4))/AA16+AC17","v":0},null,null,null,{"$f":"(100/$C$5)*(AE18+IF(AE18=0,0,$C$4))/AE16+AG17","v":0},null,null,null,{"$f":"(100/$C$5)*(AI18+IF(AI18=0,0,$C$4))/AI16+AK18","v":0}]
["9-10","4x0.75 mm²",25.25,{"$f":"C18*AC22/1000","v":0},null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,{"$f":"(100/$C$5)*(AI24+IF(AI24=0,0,$C$4))/AI22+AG23","v":0}]
["10-11","4x0.75 mm²",25.25,{"$f":"C19*Y22/1000","v":0}]
["Cable types",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Name","Resistance [Ω/km]"]
["4x0.75 mm²",25.25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109.9921875,null,0,null,{"$f":"W22+Y23*D19","v":109.9921875},null,0,null,{"$f":"AA22+AC23*D18","v":109.9921875},null,0,null,{"$f":"AE22+AG23*D17","v":109.9921875}]
["4x1.50 mm²",12.62,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(W24+IF(W24=0,0,$C$4))/W22","v":0},null,null,null,{"$f":"(100/$C$5)*(AA24+IF(AA24=0,0,$C$4))/AA22+Y23","v":0},null,null,null,{"$f":"(100/$C$5)*(AE24+IF(AE24=0,0,$C$4))/AE22+AC23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0]

{"sheet":"Fanout network","index":1,"n_rows":33,"n_cols":37,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["Input Voltage",null,110,"Vdc"]
["Min node voltage",null,55,"Vdc"]
["Node self consumption",null,5,"W",null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
["Node power efficiency",null,85,"%",null,null,null,null,null,null,null,null,0,109.9921875,null,109.9921875,null,0,null,null,null,109.9921875,null,null,null,0,null,null,null,null,null,null,null,null,"Node power load [W]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,109.9921875,null,null,null,null,null,null,null,null,"Segment length [m]"]
["Cable","Cable type","Resistance","Resistance",null,null,null,null,null,null,null,null,null,null,null,0,null,109.9921875,null,null,null,0]
["segment",null,"[Ω/km]"," [Ω]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(P4+IF(P4=0,0,$C$4))/P5","v":0},null,{"$f":"(100/$C$5)*(R5+IF(R5=0,0,$C$4))/R7","v":0},null,109.9921875,null,{"$f":"(100/$C$5)*(W4+IF(W4=0,0,$C$4))/V5","v":0},null,null,{"$f":"(100/$C$5)*(Z5+IF(Z5=0,0,$C$4))/Z6","v":0}]
["0-1","4x0.75 mm²",{"$f":"INDEX($B$32:$B$44, MATCH(B9, $A$32:$A$44, 0))","v":25.25},{"$f":"C9*J16/1000","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,0]
["1-2","4x0.75 mm²",25.25,{"$f":"C10*P16/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["1-6","4x0.75 mm²",25.25,{"$f":"C11*N14/1000","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(M5+IF(M5=0,0,$C$4))/N5","v":0},null,null,null,null,null,{"$f":"(100/$C$5)*(T6+IF(T6=0,0,$C$4))/T8","v":0}]
["1-14","4x0.75 mm²",25.25,{"$f":"C12*N20/1000","v":0}]
["2-3","4x0.75 mm²",25.25,{"$f":"C13*V16/1000","v":0},null,null,"Total power need",null,null,{"$f":"G16*J17","v":0},"W",null,null,null,null,null,0,null,null,null,null,null,null,0]
["2-10","4x0.75 mm²",25.25,{"$f":"C14*U14/1000","v":0},null,null,null,null,null,null,null,null,null,0,null,{"$f":"MAX(N5+O11*D18,P5+P8*D19,R7+R8*D20)","v":109.9921875},null,null,null,null,0,null,null,{"$f":"MAX(T8+U11*D21,V5+V8*D22,Z6+Y8*D23)","v":109.9921875}]
["2-18","4x0.75 mm²",25.25,{"$f":"C15*U20/1000","v":0},null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(Q13+IF(Q13=0,0,$C$4))/P14+O11+P8+R8","v":0},null,null,null,null,null,null,{"$f":"(100/$C$5)*(X13+IF(X13=0,0,$C$4))/X14+U11+V8+Y8","v":0}]
["3-4","4x0.75 mm²",25.25,{"$f":"C16*AB16/1000","v":0},null,null,{"$f":"L16+J17*D9","v":109.9921875},null,null,0,null,{"$f":"MAX(P14+M15*D11,S16+P17*D10,O21+O19*D12)","v":109.9921875},null,null,null,0,null,null,{"$f":"MAX(X14+T15*D14,Y16+V17*D13,V21+V19*D15)","v":109.9921875},null,null,0,null,null,{"$f":"AE16+AB17*D16","v":109.9921875},null,null,0,null,null,{"$f":"AK16+AH17*D17","v":109.9921875},null,null,0,null,null,109.9921875]
["4-5","4x0.75 mm²",25.25,{"$f":"C17*AH16/1000","v":0},null,null,null,null,null,{"$f":"(100/$C$5)*(L18+IF(L18=0,0,$C$4))/L16+M15+P17+O19","v":0},null,null,null,null,null,{"$f":"(100/$C$5)*(S18+IF(S18=0,0,$C$4))/S16+T15+V17+V19","v":0},null,null,null,null,null,{"$f":"(100/$C$5)*(Y18+IF(Y18=0,0,$C$4))/Y16+AB17","v":0},null,null,null,null,null,{"$f":"(100/$C$5)*(AE18+IF(AE18=0,0,$C$4))/AE16+AH17","v":0},null,null,null,null,null,{"$f":"(100/$C$5)*(AK18+IF(AK18=0,0,$C$4))/AK16","v":0}]
["6-7","4x0.75 mm²",25.25,{"$f":"C18*N9/1000","v":0},null,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0,null,null,null,null,null,0]
["6-8","4x0.75 mm²",25.25,{"$f":"C19*P7/1000","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(Q21+IF(Q21=0,0,$C$4))/O21+O23+P25+R23","v":0},null,null,null,null,null,null,{"$f":"(100/$C$5)*(X21+IF(X21=0,0,$C$4))/V21+U24+V27+Y24","v":0}]
["6-9","4x0.75 mm²",25.25,{"$f":"C20*R9/1000","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
["10-11","4x0.75 mm²",25.25,{"$f":"C21*U10/1000","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(N28+O23*D24,P29+P25*D25,R25+R23*D26)","v":109.9921875},null,0,null,null,null,null,{"$f":"MAX(T26+U24*D27,V29+V27*D28,Y27+Y24*D29)","v":109.9921875},null,0]
["10-12","4x0.75 mm²",25.25,{"$f":"C22*V7/1000","v":0}]
["10-13","4x0.75 mm²",25.25,{"$f":"C23*Y9/1000","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(M28+IF(M28=0,0,$C$4))/N28","v":0},null,null,{"$f":"(100/$C$5)*(R27+IF(R27=0,0,$C$4))/R25","v":0},null,null,0]
["14-15","4x0.75 mm²",25.25,{"$f":"C24*N24/1000","v":0},null,null,null,null,null,null,null,null,null,0,null,null,null,0,null,null,{"$f":"(100/$C$5)*(T28+IF(T28=0,0,$C$4))/T26","v":0},null,null,null,{"$f":"(100/$C$5)*(Z28+IF(Z28=0,0,$C$4))/Y27","v":0}]
["14-16","4x0.75 mm²",25.25,{"$f":"C25*P26/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"(100/$C$5)*(Q30+IF(Q30=0,0,$C$4))/P29","v":0},null,109.9921875,null,null,null,null,null,0]
["14-17","4x0.75 mm²",25.25,{"$f":"C26*R24/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,109.9921875,null,0]
["18-19","4x0.75 mm²",25.25,{"$f":"C27*U23/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"(100/$C$5)*(W30+IF(W30=0,0,$C$4))/V29","v":0},null,null,109.9921875]
["18-20","4x0.75 mm²",25.25,{"$f":"C28*V26/1000","v":0},null,null,null,null,null,null,null,null,0,109.9921875,null,null,null,null,null,0,null,null,null,null,null,0]
["18-21","4x0.75 mm²",25.25,{"$f":"C29*X25/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,109.9921875,null,null,null,null,null,109.9921875]
["Cable types",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Name","Resistance [Ω/km]"]
["4x0.75 mm²",25.25]
["4x1.50 mm²",12.62]