{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Confidea wired configurator","Sheet5"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":32,"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":"Confidea wired configurator","index":0,"n_rows":96,"n_cols":18,"rows_kept":96,"cut":false,"hidden":false,"merged":[[11,17,13,23],[3,14,5,15],[11,9,11,10],[13,9,13,10],[0,5,1,11],[3,9,3,10],[5,9,5,10],[7,9,7,10],[9,9,9,10],[7,14,9,15]]}
[null,null,null,null,null,"D-cerno calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,"# devices"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Branch 1",25,null,"Branch"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Branch 2",1]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Branch 3",16,null,"closed loop"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Branch 4",0]
[]
[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,1]
[]
[]
[]
[]
[]
[null,"Branch 1",null,null,null,"Branch 2",null,null,null,"Branch 3",null,null,"Branch4"]
[null,"Length (m)",null,0,null,"Length (m)",null,null,null,"Length (m)",null,null,"Length (m)"]
[]
[null,20,"#1",null,null,1,"#1",null,null,1,"#1",null,0,"#1"]
[]
[]
[null,2,"#2",null,null,0,"#2",null,null,1,"#2",null,0,"#2"]
[]
[]
[null,2,"#3",null,null,0,"#3",null,null,1,"#3",null,0,"#3"]
[]
[]
[null,2,"#4",null,null,0,"#4",null,null,1,"#4",null,0,"#4"]
[]
[]
[null,2,"#5",null,null,0,"#5",null,null,1,"#5",null,0,"#5"]
[]
[]
[null,2,"#6",null,null,0,"#6",null,null,1,"#6",null,0,"#6"]
[]
[]
[null,2,"#7",null,null,0,"#7",null,null,1,"#7",null,0,"#7"]
[]
[]
[null,2,"#8",null,null,0,"#8",null,null,1,"#8",null,0,"#8"]
[]
[]
[null,2,"#9",null,null,0,"#9",null,null,1,"#9",null,0,"#9"]
[]
[]
[null,2,"#10",null,null,0,"#10",null,null,1,"#10",null,0,"#10"]
[]
[]
[null,2,"#11",null,null,0,"#11",null,null,1,"#11",null,0,"#11"]
[]
[]
[null,2,"#12",null,null,0,"#12",null,null,1,"#12",null,0,"#12"]
[]
[]
[null,2,"#13",null,null,0,"#13",null,null,1,"#13",null,0,"#13"]
[]
[]
[null,2,"#14",null,null,0,"#14",null,null,1,"#14",null,0,"#14"]
[]
[]
[null,2,"#15",null,null,0,"#15",null,null,1,"#15",null,0,"#15"]
[]
[]
[null,2,"#16",null,null,0,"#16",null,null,1,"#16",null,0,"#16"]
[]
[]
[null,2,"#17",null,null,0,"#17",null,null,0,"#17",null,0,"#17"]
[]
[]
[null,2,"#18",null,null,0,"#18",null,null,0,"#18",null,0,"#18"]
[]
[]
[null,2,"#19",null,null,0,"#19",null,null,0,"#19",null,0,"#19"]
[]
[]
[null,2,"#20",null,null,0,"#20",null,null,0,"#20",null,0,"#20"]
[]
[]
[null,2,"#21",null,null,0,"#21",null,null,0,"#21",null,0,"#21"]
[]
[]
[null,2,"#22",null,null,0,"#22",null,null,0,"#22",null,0,"#22"]
[]
[]
[null,2,"#23",null,null,0,"#23",null,null,0,"#23",null,0,"#23"]
[]
[]
[null,2,"#24",null,null,0,"#24",null,null,0,"#24",null,0,"#24"]
[]
[]
[null,2,"#25",null,null,0,"#25",null,null,0,"#25",null,0,"#25"]

{"sheet":"Sheet5","index":1,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":true,"merged":[[31,12,31,14],[32,12,32,14],[31,18,31,20],[32,18,32,20],[31,0,31,2],[32,0,32,2],[31,6,31,8],[32,6,32,8],[5,2,5,3],[30,0,30,2],[18,2,18,3],[19,2,19,3],[20,2,20,3],[27,0,27,2],[28,0,28,2],[29,0,29,2],[26,0,26,2],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[12,8,12,9],[13,8,13,9],[17,2,17,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[0,8,0,9],[1,8,1,9],[2,8,2,9],[3,8,3,9],[4,8,4,9],[0,2,0,3],[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[15,8,15,9],[16,8,16,9],[17,8,17,9],[18,8,18,9],[19,8,19,9],[10,8,10,9],[11,8,11,9],[14,8,14,9],[5,8,5,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[9,8,9,9],[6,14,6,15],[7,14,7,15],[8,14,8,15],[9,14,9,15],[10,14,10,15],[11,14,11,15],[12,14,12,15],[13,14,13,15],[14,14,14,15],[0,20,0,21],[1,20,1,21],[2,20,2,21],[3,20,3,21],[4,20,4,21],[15,14,15,15],[16,14,16,15],[17,14,17,15],[18,14,18,15],[11,20,11,21],[12,20,12,21],[13,20,13,21],[14,20,14,21],[5,20,5,21],[6,20,6,21],[7,20,7,21],[8,20,8,21],[9,20,9,21],[0,14,0,15],[1,14,1,15],[2,14,2,15],[3,14,3,15],[4,14,4,15],[5,14,5,15],[29,12,29,14],[30,12,30,14],[26,6,26,8],[27,6,27,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[21,14,21,15],[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[18,32,18,33],[19,32,19,33],[15,20,15,21],[16,20,16,21],[17,20,17,21],[18,20,18,21],[19,20,19,21],[10,20,10,21],[19,14,19,15],[9,32,9,33],[10,32,10,33],[11,32,11,33],[12,32,12,33],[13,32,13,33],[14,32,14,33],[15,32,15,33],[16,32,16,33],[17,32,17,33],[0,32,0,33],[2,32,2,33],[1,32,1,33],[3,32,3,33],[4,32,4,33],[5,32,5,33],[6,32,6,33],[7,32,7,33],[8,32,8,33],[37,13,37,16],[26,30,26,32],[27,30,27,32],[20,32,20,33],[21,30,21,32],[22,30,22,32],[23,30,23,32],[24,30,24,32],[29,18,29,20],[30,18,30,20],[21,20,21,21],[22,20,22,21],[23,20,23,21],[24,20,24,21],[25,20,25,21],[20,20,20,21],[26,18,26,20],[27,18,27,20],[28,18,28,20],[25,30,25,32],[20,14,20,15],[26,12,26,14],[27,12,27,14],[28,12,28,14]]}
["Device","length","Voltage [v]",null,"Z[ohm]",null,"Device","length","Voltage [v]",null,"Z[ohm]",null,"Device","length","Voltage [v]",null,"Z[ohm]",null,"Device","length","Voltage [v]",null,"Z[ohm]"]
[1,{"$f":"IF('Confidea wired configurator'!B24>'Confidea wired configurator'!D22,'Confidea wired configurator'!B24,'Confidea wired configurator'!D22)","v":20},{"$f":"IF(A2<=$D$28,(48*(E2/(E2+($D$30*$B$2)))),0)","v":46.128210992418559},null,{"$f":"IF(A2<$D$28,($D$29*(($D$30*B2)+E3))/($D$29+(($D$30*B2)+E3)),$D$29)","v":39.430265531495053},{"$f":"IF(AND(C2<36,C2>0),1,0)","v":0},1,{"$f":"'Confidea wired configurator'!F24","v":1},{"$f":"IF(G2<=$J$28,(48*(K2/(K2+($J$30*H2)))),0)","v":47.995833694991752},null,{"$f":"IF(G2<$J$28,($J$29*(($J$30*H2)+K3))/($J$29+(($J$30*H2)+K3)),$J$29)","v":921.6},{"$f":"IF(AND(I2<36,I2>0),1,0)","v":0},1,{"$f":"IF('Confidea wired configurator'!J24>'Confidea wired configurator'!L15,'Confidea wired configurator'!J24,'Confidea wired configurator'!L15)","v":1},{"$f":"IF(M2<=$P$28,(48*(Q2/(Q2+($P$30*$N$2)))),0)","v":47.933869350172039},null,{"$f":"IF(M2<$P$28,($P$29*(($P$30*N2)+Q3))/($P$29+(($P$30*N2)+Q3)),$P$29)","v":57.986872320015671},{"$f":"IF(AND(O2<36,O2>0),1,0)","v":0},1,{"$f":"'Confidea wired configurator'!M24","v":0},{"$f":"IF(S2<=$V$28,(48*(W2/(W2+($V$30*$T$2)))),0)","v":0},null,{"$f":"IF(S2<$V$28,($V$29*(($V$30*T2)+W3))/($V$29+(($V$30*T2)+W3)),$V$29)","v":921.6},{"$f":"IF(AND(U2<36,U2>0),1,0)","v":0}]
[2,{"$f":"'Confidea wired configurator'!B27","v":2},{"$f":"IF(A3<=$D$28,(C2*(E3/(E3+($D$30*B3)))),0)","v":45.942550192656022},null,39.592676753663,{"$f":"IF(AND(C3<36,C3>0),1,0)","v":0},2,{"$f":"'Confidea wired configurator'!F27","v":0},{"$f":"IF(G3<=$J$28,(I2*(K3/(K3+($J$30*H3)))),0)","v":0},null,921.6,{"$f":"IF(AND(I3<36,I3>0),1,0)","v":0},2,{"$f":"'Confidea wired configurator'!J27","v":1},{"$f":"IF(M3<=$P$28,(O2*(Q3/(Q3+($P$30*N3)))),0)","v":47.871899626502945},null,61.800371913393533,{"$f":"IF(AND(O3<36,O3>0),1,0)","v":0},2,{"$f":"'Confidea wired configurator'!M27","v":0},{"$f":"IF(S3<=$V$28,(U2*(W3/(W3+($V$30*T3)))),0)","v":0},null,921.6,{"$f":"IF(AND(U3<36,U3>0),1,0)","v":0}]
[3,{"$f":"'Confidea wired configurator'!B30","v":2},45.764865530079703,null,41.2099636436974,0,3,{"$f":"'Confidea wired configurator'!F30","v":0},{"$f":"IF(G4<=$J$28,(I3*(K4/(K4+($J$30*H4)))),0)","v":0},null,921.6,0,3,{"$f":"'Confidea wired configurator'!J30","v":1},47.814085449676426,null,66.162437068891649,0,3,{"$f":"'Confidea wired configurator'!M30","v":0},0,null,921.6,0]
[4,{"$f":"'Confidea wired configurator'!B33","v":2},45.595126156657919,null,42.978950835037622,0,4,{"$f":"'Confidea wired configurator'!F33","v":0},0,null,921.6,0,4,{"$f":"'Confidea wired configurator'!J33","v":1},47.760421801100755,null,71.199663934515726,0,4,{"$f":"'Confidea wired configurator'!M33","v":0},0,null,921.6,0]
[5,{"$f":"'Confidea wired configurator'!B36","v":2},45.433302603749439,null,44.921325023131736,0,5,{"$f":"'Confidea wired configurator'!F36","v":0},0,null,921.6,0,5,{"$f":"'Confidea wired configurator'!J36","v":1},47.710904022473095,null,77.080847073085891,0,5,{"$f":"'Confidea wired configurator'!M36","v":0},0,null,921.6,0]
[6,{"$f":"'Confidea wired configurator'!B39","v":2},45.279366776987445,null,47.063109587341749,0,6,{"$f":"'Confidea wired configurator'!F39","v":0},0,null,921.6,0,6,{"$f":"'Confidea wired configurator'!J39","v":1},47.665527815375164,null,84.036160558769083,0,6,{"$f":"'Confidea wired configurator'!M39","v":0},0,null,921.6,0]
[7,{"$f":"'Confidea wired configurator'!B42","v":2},45.133291951402008,null,49.435805815839323,0,7,{"$f":"'Confidea wired configurator'!F42","v":0},0,null,921.6,0,7,{"$f":"'Confidea wired configurator'!J42","v":1},47.62428924090009,null,92.387847731618606,0,7,{"$f":"'Confidea wired configurator'!M42","v":0},0,null,921.6,0]
[8,{"$f":"'Confidea wired configurator'!B45","v":2},44.995052766780361,null,52.077914539125594,0,8,{"$f":"'Confidea wired configurator'!F45","v":0},0,null,921.6,0,8,{"$f":"'Confidea wired configurator'!J45","v":1},47.587184719310514,null,102.60137078857225,0,8,{"$f":"'Confidea wired configurator'!M45","v":0},0,null,921.6,0]
[9,{"$f":"'Confidea wired configurator'!B48","v":2},44.864625223264049,null,55.036994811028023,0,9,{"$f":"'Confidea wired configurator'!F48","v":0},0,null,921.6,0,9,{"$f":"'Confidea wired configurator'!J48","v":1},47.554211029727824,null,115.37492256781033,0,9,{"$f":"'Confidea wired configurator'!M48","v":0},0,null,921.6,0]
[10,{"$f":"'Confidea wired configurator'!B51","v":2},44.741986677182339,null,58.372494595453482,0,10,{"$f":"'Confidea wired configurator'!F51","v":0},0,null,921.6,0,10,{"$f":"'Confidea wired configurator'!J51","v":1},47.525365309852567,null,131.8056627198342,0,10,{"$f":"'Confidea wired configurator'!M51","v":0},0,null,921.6,0]
[11,{"$f":"'Confidea wired configurator'!B54","v":2},44.627115837120975,null,62.159713728258353,0,11,{"$f":"'Confidea wired configurator'!F54","v":0},0,null,921.6,0,11,{"$f":"'Confidea wired configurator'!J54","v":1},47.500645055716014,null,153.72219004977376,0,11,{"$f":"'Confidea wired configurator'!M54","v":0},0,null,921.6,0]
[12,{"$f":"'Confidea wired configurator'!B57","v":2},{"$f":"IF(A13<=$D$28,(C12*(E13/(E13+($D$30*B13)))),0)","v":44.519992760225776},null,66.495465291802532,0,12,{"$f":"'Confidea wired configurator'!F57","v":0},0,null,921.6,0,12,{"$f":"'Confidea wired configurator'!J57","v":1},47.480048121462772,null,184.41598167064438,0,12,{"$f":"'Confidea wired configurator'!M57","v":0},0,null,921.6,0]
[13,{"$f":"'Confidea wired configurator'!B60","v":2},44.420598848740333,null,71.50634993210231,0,13,{"$f":"'Confidea wired configurator'!F60","v":0},0,null,921.6,0,13,{"$f":"'Confidea wired configurator'!J60","v":1},47.463572719164517,null,230.46999088671629,0,13,{"$f":"'Confidea wired configurator'!M60","v":0},0,null,921.6,0]
[14,{"$f":"'Confidea wired configurator'!B63","v":2},44.32891684677724,null,77.361167335107112,0,14,{"$f":"'Confidea wired configurator'!F63","v":0},0,null,921.6,0,14,{"$f":"'Confidea wired configurator'!J63","v":1},47.451217418664811,null,307.2444408439265,0,14,{"$f":"'Confidea wired configurator'!M63","v":0},0,null,921.6,0]
[15,{"$f":"'Confidea wired configurator'!B66","v":2},44.244930837322272,null,84.290097599732846,0,15,{"$f":"'Confidea wired configurator'!F66","v":0},0,null,921.6,0,15,{"$f":"'Confidea wired configurator'!J66","v":1},47.442981147454915,null,460.81999913198212,0,15,{"$f":"'Confidea wired configurator'!M66","v":0},0,null,921.6,0]
[16,{"$f":"'Confidea wired configurator'!B69","v":2},44.168626239471003,null,92.615391435390961,0,16,{"$f":"'Confidea wired configurator'!F69","v":0},0,null,921.6,0,16,{"$f":"'Confidea wired configurator'!J69","v":1},47.438863190580733,null,921.6,0,16,{"$f":"'Confidea wired configurator'!M69","v":0},0,null,921.6,0]
[17,{"$f":"'Confidea wired configurator'!B72","v":2},44.099989805897422,null,102.802520491964,0,17,{"$f":"'Confidea wired configurator'!F72","v":0},0,null,921.6,0,17,{"$f":"'Confidea wired configurator'!J72","v":0},0,null,921.6,0,17,{"$f":"'Confidea wired configurator'!M72","v":0},0,null,921.6,0]
[18,{"$f":"'Confidea wired configurator'!B75","v":2},44.039009620554033,null,115.54969043812768,0,18,{"$f":"'Confidea wired configurator'!F75","v":0},0,null,921.6,0,18,{"$f":"'Confidea wired configurator'!J75","v":0},0,null,921.6,0,18,{"$f":"'Confidea wired configurator'!M75","v":0},0,null,921.6,0]
[19,{"$f":"'Confidea wired configurator'!B78","v":2},43.985675096603096,null,131.95407953637698,0,19,{"$f":"'Confidea wired configurator'!F78","v":0},0,null,921.6,0,19,{"$f":"'Confidea wired configurator'!J78","v":0},0,null,921.6,0,19,{"$f":"'Confidea wired configurator'!M78","v":0},0,null,921.6,0]
[20,{"$f":"'Confidea wired configurator'!B81","v":2},43.939976974578656,null,153.8443157942551,0,20,{"$f":"'Confidea wired configurator'!F81","v":0},0,null,921.6,0,20,{"$f":"'Confidea wired configurator'!J81","v":0},0,null,921.6,0,20,{"$f":"'Confidea wired configurator'!M81","v":0},0,null,921.6,0]
[21,{"$f":"'Confidea wired configurator'!B84","v":2},{"$f":"IF(A22<=$D$28,(C21*(E22/(E22+($D$30*B22)))),0)","v":43.901907320778967},null,{"$f":"IF(A22<$D$28,($D$29*(($D$30*B22)+E23))/($D$29+(($D$30*B22)+E23)),$D$29)","v":184.51192669848106},0,21,{"$f":"'Confidea wired configurator'!F84","v":0},{"$f":"IF(G22<=$J$28,(I21*(K22/(K22+($J$30*H22)))),0)","v":0},null,921.6,0,21,{"$f":"'Confidea wired configurator'!J84","v":0},{"$f":"IF(M22<=$P$28,(O21*(Q22/(Q22+($P$30*N22)))),0)","v":0},null,921.6,0,21,{"$f":"'Confidea wired configurator'!M84","v":0},{"$f":"IF(S22<=$V$28,(U21*(W22/(W22+($V$30*T22)))),0)","v":0},null,{"$f":"IF(S22<$V$28,($V$29*(($V$30*T22)+W23))/($V$29+(($V$30*T22)+W23)),$V$29)","v":921.6},0]
[22,{"$f":"'Confidea wired configurator'!B87","v":2},{"$f":"IF(A23<=$D$28,(C22*(E23/(E23+($D$30*B23)))),0)","v":43.871459525889136},null,{"$f":"IF(A23<$D$28,($D$29*(($D$30*B23)+E24))/($D$29+(($D$30*B23)+E24)),$D$29)","v":230.53996355206218},0,22,{"$f":"'Confidea wired configurator'!F87","v":0},{"$f":"IF(G23<=$J$28,(I22*(K23/(K23+($J$30*H23)))),0)","v":0},null,921.6,0,22,{"$f":"'Confidea wired configurator'!J87","v":0},{"$f":"IF(M23<=$P$28,(O22*(Q23/(Q23+($P$30*N23)))),0)","v":0},null,921.6,0,22,{"$f":"'Confidea wired configurator'!M87","v":0},{"$f":"IF(S23<=$V$28,(U22*(W23/(W23+($V$30*T23)))),0)","v":0},null,{"$f":"IF(S23<$V$28,($V$29*(($V$30*T23)+W24))/($V$29+(($V$30*T23)+W24)),$V$29)","v":921.6},0]
[23,{"$f":"'Confidea wired configurator'!B90","v":2},{"$f":"IF(A24<=$D$28,(C23*(E24/(E24+($D$30*B24)))),0)","v":43.848628303833664},null,{"$f":"IF(A24<$D$28,($D$29*(($D$30*B24)+E25))/($D$29+(($D$30*B24)+E25)),$D$29)","v":307.28887448803732},0,23,{"$f":"'Confidea wired configurator'!F90","v":0},{"$f":"IF(G24<=$J$28,(I23*(K24/(K24+($J$30*H24)))),0)","v":0},null,921.6,0,23,{"$f":"'Confidea wired configurator'!J90","v":0},{"$f":"IF(M24<=$P$28,(O23*(Q24/(Q24+($P$30*N24)))),0)","v":0},null,921.6,0,23,{"$f":"'Confidea wired configurator'!M90","v":0},{"$f":"IF(S24<=$V$28,(U23*(W24/(W24+($V$30*T24)))),0)","v":0},null,{"$f":"IF(S24<$V$28,($V$29*(($V$30*T24)+W25))/($V$29+(($V$30*T24)+W25)),$V$29)","v":921.6},0]
[24,{"$f":"'Confidea wired configurator'!B93","v":2},{"$f":"IF(A25<=$D$28,(C24*(E25/(E25+($D$30*B25)))),0)","v":43.833409690858716},null,{"$f":"IF(A25<$D$28,($D$29*(($D$30*B25)+E26))/($D$29+(($D$30*B25)+E26)),$D$29)","v":460.83999652807915},0,24,{"$f":"'Confidea wired configurator'!F93","v":0},{"$f":"IF(G25<=$J$28,(I24*(K25/(K25+($J$30*H25)))),0)","v":0},null,921.6,0,24,{"$f":"'Confidea wired configurator'!J93","v":0},{"$f":"IF(M25<=$P$28,(O24*(Q25/(Q25+($P$30*N25)))),0)","v":0},null,921.6,0,24,{"$f":"'Confidea wired configurator'!M93","v":0},{"$f":"IF(S25<=$V$28,(U24*(W25/(W25+($V$30*T25)))),0)","v":0},null,{"$f":"IF(S25<$V$28,($V$29*(($V$30*T25)+W26))/($V$29+(($V$30*T25)+W26)),$V$29)","v":921.6},0]
[25,{"$f":"'Confidea wired configurator'!B96","v":2},{"$f":"IF(A26<=$D$28,(C25*(E26/(E26+($D$30*B26)))),0)","v":43.825801044843992},null,{"$f":"IF(A26<$D$28,($D$29*(($D$30*B26)+E27))/($D$29+(($D$30*B26)+E27)),$D$29)","v":921.6},0,25,{"$f":"'Confidea wired configurator'!F96","v":0},{"$f":"IF(G26<=$J$28,(I25*(K26/(K26+($J$30*H26)))),0)","v":0},null,921.6,0,25,{"$f":"'Confidea wired configurator'!J96","v":0},{"$f":"IF(M26<=$P$28,(O25*(Q26/(Q26+($P$30*N26)))),0)","v":0},null,921.6,0,25,{"$f":"'Confidea wired configurator'!M96","v":0},{"$f":"IF(S26<=$V$28,(U25*(W26/(W26+($V$30*T26)))),0)","v":0},null,{"$f":"IF(S26<$V$28,($V$29*(($V$30*T26)+W27))/($V$29+(($V$30*T26)+W27)),$V$29)","v":921.6},0]
["Device power",null,null,2.5,null,null,"Device power",null,null,2.5,{"$f":"SUM(H2:H26)","v":1},null,"Device power",null,null,2.5,null,null,"Device power",null,null,2.5,{"$f":"SUM(T2:T26)","v":0}]
["Devices",null,null,{"$f":"IF('Confidea wired configurator'!M4=0,0,'Confidea wired configurator'!M4)","v":25},{"$f":"IF('Confidea wired configurator'!M4=0,1,'Confidea wired configurator'!M4)","v":25},null,"Devices",null,null,{"$f":"IF('Confidea wired configurator'!M6=0,0,'Confidea wired configurator'!M6)","v":1},null,null,"Devices",null,null,{"$f":"IF('Confidea wired configurator'!M8=0,0,'Confidea wired configurator'!M8)","v":16},{"$f":"IF('Confidea wired configurator'!M8=0,1,'Confidea wired configurator'!M8)","v":16},null,"Devices",null,null,{"$f":"IF('Confidea wired configurator'!M10=0,0,'Confidea wired configurator'!M10)","v":0}]
["Device resistance",null,null,{"$f":"(48^2)/D27","v":921.6},null,null,"Device resistance",null,null,{"$f":"(48^2)/J27","v":921.6},null,null,"Device resistance",null,null,{"$f":"(48^2)/P27","v":921.6},null,null,"Device resistance",null,null,{"$f":"(48^2)/V27","v":921.6}]
["Line resistance",null,null,0.08,null,null,"Line resistance",null,null,0.08,null,null,"Line resistance",null,null,0.08,null,null,"Line resistance",null,null,0.08]
["Final Voltage",null,null,{"$f":"INDEX(C2:C26,E28)","v":43.825801044843992},null,null,"Final Voltage",null,null,{"$f":"IF('Confidea wired configurator'!M6>0,INDEX(I2:I26,J28),1)","v":47.995833694991752},null,null,"Final Voltage",null,null,{"$f":"INDEX(O2:O26,Q28)","v":47.438863190580733},null,null,"Final Voltage",null,null,{"$f":"IF('Confidea wired configurator'!M10>0,INDEX(U2:U26,V28),1)","v":1}]
["Total Current",null,null,{"$f":"48/(E2+(D30*B2))","v":1.1698681297383986},null,null,"Total Current",null,null,{"$f":"48/(K2+(J30*H2))","v":5.2078812603072649E-2},null,null,"Total Current",null,null,{"$f":"48/(Q2+(P30*N2))","v":0.82663312284953883},null,null,"Total Current",null,null,{"$f":"48/(W2+(V30*T2))","v":5.2083333333333329E-2}]
["Total Branch Power",null,null,{"$f":"48*D32","v":56.153670227443129},null,null,"Total Branch Power",null,null,{"$f":"48*J32","v":2.4997830049474872},null,null,"Total Branch Power",null,null,{"$f":"48*P32","v":39.678389896777865},null,null,"Total Branch Power",null,null,{"$f":"48*V32","v":2.5}]
[0,0,0,0,1,{"$f":"IF(J35='Confidea wired configurator'!O4,0,1)","v":1},{"$f":"IF(J37='Confidea wired configurator'!O8,0,1)","v":0},{"$f":"IF($J$35='Confidea wired configurator'!$O$4,1,0)","v":0},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,1,0)","v":1},"Branch"]
[1,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,1)","v":1},1,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,1)","v":0},2,{"$f":"IF(J35='Confidea wired configurator'!O4,0,2)","v":2},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,2)","v":0},{"$f":"IF($J$35='Confidea wired configurator'!$O$4,2,0)","v":0},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,2,0)","v":2},"closed loop"]
[2,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,2)","v":2},2,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,2)","v":0},5,{"$f":"IF(J35='Confidea wired configurator'!O4,0,5)","v":5},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,5)","v":0},{"$f":"IF($J$35='Confidea wired configurator'!$O$4,5,0)","v":0},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,5,0)","v":5},"Branch",null,null,null,"som B1","somB2","somB3","somB4"]
[3,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,3)","v":3},3,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,3)","v":0},10,{"$f":"IF(J35='Confidea wired configurator'!O4,0,10)","v":10},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,10)","v":0},{"$f":"IF($J$35='Confidea wired configurator'!$O$4,10,0)","v":0},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,10,0)","v":10},"closed loop",null,null,null,{"$f":"SUM(Sheet5!B2:B26)","v":68},{"$f":"SUM(H2:H26)","v":1},{"$f":"SUM(N2:N26)","v":16},{"$f":"SUM(T2:T26)","v":0}]
[4,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,4)","v":4},4,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,4)","v":0},20,{"$f":"IF(J35='Confidea wired configurator'!O4,0,20)","v":20},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,20)","v":0},{"$f":"IF($J$35='Confidea wired configurator'!$O$4,20,0)","v":0},{"$f":"IF($J$37='Confidea wired configurator'!$O$8,20,0)","v":20},null,null,null,null,"total cable lengt: branch/loop"]
[5,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,5)","v":5},5,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,5)","v":0},null,null,null,null,null,{"$f":"('Confidea wired configurator'!M4+'Confidea wired configurator'!M6+'Confidea wired configurator'!M8+'Confidea wired configurator'!M10)","v":42}]
[6,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,6)","v":6},6,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,6)","v":0}]
[7,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,7)","v":7},7,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,7)","v":0}]
[8,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,8)","v":8},8,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,8)","v":0}]
[9,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,9)","v":9},9,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,9)","v":0}]
[10,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,10)","v":10},10,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,10)","v":0},null,"Branch/ loop 1"]
[11,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,11)","v":11},11,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,11)","v":0},null,"Branch2"]
[12,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,12)","v":12},12,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,12)","v":0},null,"Branch3/loop 2"]
[13,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,13)","v":13},13,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,13)","v":0},null,"Branch4"]
[14,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,14)","v":14},14,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,14)","v":0}]
[15,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,15)","v":15},15,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,15)","v":0}]
[16,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,16)","v":16},16,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,16)","v":0}]
[17,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,17)","v":17},17,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,17)","v":0},null,"extra lengte loop1"]
[18,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,18)","v":18},18,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,18)","v":0},null,"extra lengte loop2"]
[19,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,19)","v":19},19,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,19)","v":0},null,"aantal devices"]
[20,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,20)","v":20},20,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,20)","v":0}]
[21,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,21)","v":21},21,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,21)","v":0}]
[22,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,22)","v":22},22,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,22)","v":0}]
[23,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,23)","v":23},23,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,23)","v":0}]
[24,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,24)","v":24},24,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,24)","v":0}]
[25,{"$f":"IF($J$35='Confidea wired configurator'!$O$4,0,25)","v":25},25,{"$f":"IF($J$37='Confidea wired configurator'!$O$8,0,25)","v":0}]