{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Intro","Calculate","Revision history","Simple Configurator for Install"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":4,"comments":1,"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":"Data","index":0,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":true,"merged":[[25,7,25,8]]}
[]
["U0",48,"V","Voltage power source",null,null,null,null,"U0","Io","Power output"]
["Io",3,"A","Current Power source",null,null,null,null,null,null,"Watt",null,null,"A maximum of 22 nodes can be daisy-chained in the system this inlcudes all switches"]
["Power",{"$f":"B2*B3","v":144},"Watt","Total available power",null,null,null,null,48,3,{"$f":"I4*J4","v":144}]
["PCF's",2,"m ","Standard Cable length per device"]
["Rcon",10,"mOhm","Contact Resistance per contact"]
["Rcable",23,"ohm/km","Cable resistance one way"]
[]
["DCNM-MMD",11.3,"Watt","Power per device"]
["DCNM-MMD2",12,"Watt"]
["DCNM-DE",5,"Watt",null,null,null,null,"#of FLSP/FMCP/FSLP","# FMICB/FIDP/FVP/FAI"]
["DCNM-DSL",3.6,"Watt",null,"DCNM-FMICB/FPRIOB",0.4,"Watt",0,0]
["DCNM-DVT",3.7,"Watt",null,"DCNM-FMCP",0.2,"Watt",1,1]
["DCNM-D",3.1,"Watt",null,"DCNM-FLSP",1,"Watt",2,2]
["DCNM-IDESK",15,"Watt",null,"DCNM-FIDP",0.5,"Watt",null,3]
["DCNM-IDESKVID",18,"Watt",null,"DCNM-FVP",0.5,"Watt",null,4]
["DCNM-FBD2",5,"Watt",null,"DCNM-FAI",0.5,"Watt"]
["INT-TXO",10,"Watt",null,"DCNM-FSLP",0.5,"Watt"]
["DCNM-ENCD",2,"Watt"]
["DCNM-ENCS",2,"Watt"]

{"sheet":"Intro","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DICENTIS Power Calculation Tool"]
["Version",213]
["Date","2025-06-25"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click the hyperlink of either meters or feet to enter the calculation sheet."]
["Enter the required cable length and the calculation will show you in red if the cable is too long."]
["Clearing the cable length cell will remove the complete line"]
["Have fun using this tool."]

{"sheet":"Calculate","index":2,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,3,0,9]]}
[null,null,null,"attached modules to FBD2 (total on both outputs)",null,null,null,null,null,null,"Length","P device W","CB resistance"," U device V","Iload (mA)","In (A)","V too low","I too low",null,null,{"$f":"NOW()","v":"2026-03-24T12:37:12.310"}]
["Device","Cable length (m) between 2-99","Device type","DCNM-FLSP","DCNM-FMICB / DCNM-FPRIOB","DCNM-FMCP","DCNM-FIDP","DCNM-FVP","DCNM- FSLP","DCNM-FAI","m",3.2808399000000001,null,{"$f":"Data!$B$2","v":48},null,3,{"$f":"IFERROR(MATCH(1,Q3:Q43,0),)","v":41},{"$f":"IFERROR(MATCH(1,R3:R43,0),)","v":31},null,3,41,41]
[1,2,"DCNM-DE",null,null,null,null,null,null,null,{"$f":"IF($K$2=\"m\",B3,INT(B3/3.2808399+0.5))","v":2},{"$f":"IF(ISBLANK(C3),\"\",VLOOKUP(C3,Data!$A$9:$B$20,2,FALSE)+IF(C3=\"DCNM-FBD2\",D3*Data!$F$14+E3*Data!$F$12+F3*Data!$F$13+G3*Data!$F$15+H3*Data!$F$16+I3*Data!$F$17+J3*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K3)>0,COUNTBLANK(L3)>0),\"\",2*(Data!$B$7/1000)*K3+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(M3)>0,\"\",N2-(P2*M3))","v":47.603999999999999},{"$f":"IF(COUNTBLANK(N3)>0,\"\",(L3/N3)*1000)","v":105.03319048819428},{"$f":"IF(COUNTBLANK(O3)>0,\"\",P2-O2/1000)","v":3},{"$f":"IFERROR(IF(LEFT(C3,6)=\"DCNM-D\",IF((N3<35),1,0),IF((N3<31),1,0)),)","v":0},{"$f":"IFERROR(IF(P3<O3/1000,1,0),)","v":0},{"$f":"Q3+R3","v":0},3,41,41]
[2,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C4),\"\",VLOOKUP(C4,Data!$A$9:$B$20,2,FALSE)+IF(C4=\"DCNM-FBD2\",D4*Data!$F$14+E4*Data!$F$12+F4*Data!$F$13+G4*Data!$F$15+H4*Data!$F$16+I4*Data!$F$17+J4*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K4)>0,COUNTBLANK(L4)>0),\"\",2*(Data!$B$7/1000)*K4+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(M4)>0,\"\",N3-(P3*M4))","v":47.207999999999998},{"$f":"IF(COUNTBLANK(N4)>0,\"\",(L4/N4)*1000)","v":105.91425182172513},{"$f":"IF(COUNTBLANK(O4)>0,\"\",P3-O3/1000)","v":2.8949668095118057},0,{"$f":"IFERROR(IF(P4<O4/1000,1,0),)","v":0},{"$f":"Q4+R4+SUM($S$3:S3)","v":0},3,41,41]
[3,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,Data!$A$9:$B$20,2,FALSE)+IF(C5=\"DCNM-FBD2\",D5*Data!$F$14+E5*Data!$F$12+F5*Data!$F$13+G5*Data!$F$15+H5*Data!$F$16+I5*Data!$F$17+J5*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K5)>0,COUNTBLANK(L5)>0),\"\",2*(Data!$B$7/1000)*K5+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(M5)>0,\"\",N4-(P4*M5))","v":46.825864381144441},{"$f":"IF(COUNTBLANK(N5)>0,\"\",(L5/N5)*1000)","v":106.77859482319283},{"$f":"IF(COUNTBLANK(O5)>0,\"\",P4-O4/1000)","v":2.7890525576900806},0,{"$f":"IFERROR(IF(P5<O5/1000,1,0),)","v":0},{"$f":"Q5+R5+SUM($S$3:S4)","v":0}]
[4,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C6),\"\",VLOOKUP(C6,Data!$A$9:$B$20,2,FALSE)+IF(C6=\"DCNM-FBD2\",D6*Data!$F$14+E6*Data!$F$12+F6*Data!$F$13+G6*Data!$F$15+H6*Data!$F$16+I6*Data!$F$17+J6*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K6)>0,COUNTBLANK(L6)>0),\"\",2*(Data!$B$7/1000)*K6+ 4*Data!$B$6/1000)","v":0.13200000000000001},46.457709443529353,107.6247636805607,2.6822739628668879,0,0,{"$f":"Q6+R6+SUM($S$3:S5)","v":0}]
[5,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C7),\"\",VLOOKUP(C7,Data!$A$9:$B$20,2,FALSE)+IF(C7=\"DCNM-FBD2\",D7*Data!$F$14+E7*Data!$F$12+F7*Data!$F$13+G7*Data!$F$15+H7*Data!$F$16+I7*Data!$F$17+J7*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K7)>0,COUNTBLANK(L7)>0),\"\",2*(Data!$B$7/1000)*K7+ 4*Data!$B$6/1000)","v":0.13200000000000001},46.103649280430922,108.45128483402488,2.5746491991863274,0,0,{"$f":"Q7+R7+SUM($S$3:S6)","v":0}]
[6,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C8),\"\",VLOOKUP(C8,Data!$A$9:$B$20,2,FALSE)+IF(C8=\"DCNM-FBD2\",D8*Data!$F$14+E8*Data!$F$12+F8*Data!$F$13+G8*Data!$F$15+H8*Data!$F$16+I8*Data!$F$17+J8*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K8)>0,COUNTBLANK(L8)>0),\"\",2*(Data!$B$7/1000)*K8+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.763795586138329,109.25667191631456,2.4661979143523025,0,0,{"$f":"Q8+R8+SUM($S$3:S7)","v":0}]
[7,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C9),\"\",VLOOKUP(C9,Data!$A$9:$B$20,2,FALSE)+IF(C9=\"DCNM-FBD2\",D9*Data!$F$14+E9*Data!$F$12+F9*Data!$F$13+G9*Data!$F$15+H9*Data!$F$16+I9*Data!$F$17+J9*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K9)>0,COUNTBLANK(L9)>0),\"\",2*(Data!$B$7/1000)*K9+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.438257461443825,110.03943107287289,2.3569412424359881,0,0,{"$f":"Q9+R9+SUM($S$3:S8)","v":0}]
[8,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(C10,Data!$A$9:$B$20,2,FALSE)+IF(C10=\"DCNM-FBD2\",D10*Data!$F$14+E10*Data!$F$12+F10*Data!$F$13+G10*Data!$F$15+H10*Data!$F$16+I10*Data!$F$17+J10*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K10)>0,COUNTBLANK(L10)>0),\"\",2*(Data!$B$7/1000)*K10+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.127141217442272,110.79806664259578,2.2469018113631152,0,0,{"$f":"Q10+R10+SUM($S$3:S9)","v":0}]
[9,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(C11,Data!$A$9:$B$20,2,FALSE)+IF(C11=\"DCNM-FBD2\",D11*Data!$F$14+E11*Data!$F$12+F11*Data!$F$13+G11*Data!$F$15+H11*Data!$F$16+I11*Data!$F$17+J11*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K11)>0,COUNTBLANK(L11)>0),\"\",2*(Data!$B$7/1000)*K11+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.830550178342342,111.5310871740205,2.1361037447205193,0,0,{"$f":"Q11+R11+SUM($S$3:S10)","v":0}]
[10,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(C12,Data!$A$9:$B$20,2,FALSE)+IF(C12=\"DCNM-FBD2\",D12*Data!$F$14+E12*Data!$F$12+F12*Data!$F$13+G12*Data!$F$15+H12*Data!$F$16+I12*Data!$F$17+J12*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K12)>0,COUNTBLANK(L12)>0),\"\",2*(Data!$B$7/1000)*K12+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.548584484039232,112.23701174593749,2.0245726575464991,0,0,{"$f":"Q12+R12+SUM($S$3:S11)","v":0}]
[11,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,Data!$A$9:$B$20,2,FALSE)+IF(C13=\"DCNM-FBD2\",D13*Data!$F$14+E13*Data!$F$12+F13*Data!$F$13+G13*Data!$F$15+H13*Data!$F$16+I13*Data!$F$17+J13*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K13)>0,COUNTBLANK(L13)>0),\"\",2*(Data!$B$7/1000)*K13+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.281340893243097,112.91437655545231,1.9123356458005616,0,0,{"$f":"Q13+R13+SUM($S$3:S12)","v":0}]
[12,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,Data!$A$9:$B$20,2,FALSE)+IF(C14=\"DCNM-FBD2\",D14*Data!$F$14+E14*Data!$F$12+F14*Data!$F$13+G14*Data!$F$15+H14*Data!$F$16+I14*Data!$F$17+J14*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K14)>0,COUNTBLANK(L14)>0),\"\",2*(Data!$B$7/1000)*K14+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.028912587997425,113.56174173066071,1.7994212692451093,0,0,{"$f":"Q14+R14+SUM($S$3:S13)","v":0}]
[13,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,Data!$A$9:$B$20,2,FALSE)+IF(C15=\"DCNM-FBD2\",D15*Data!$F$14+E15*Data!$F$12+F15*Data!$F$13+G15*Data!$F$15+H15*Data!$F$16+I15*Data!$F$17+J15*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K15)>0,COUNTBLANK(L15)>0),\"\",2*(Data!$B$7/1000)*K15+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.791388980457072,114.17769831944281,1.6858595275144486,0,0,{"$f":"Q15+R15+SUM($S$3:S14)","v":0}]
[14,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,Data!$A$9:$B$20,2,FALSE)+IF(C16=\"DCNM-FBD2\",D16*Data!$F$14+E16*Data!$F$12+F16*Data!$F$13+G16*Data!$F$15+H16*Data!$F$16+I16*Data!$F$17+J16*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K16)>0,COUNTBLANK(L16)>0),\"\",2*(Data!$B$7/1000)*K16+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.568855522825167,114.76087540056139,1.5716818291950057,0,0,{"$f":"Q16+R16+SUM($S$3:S15)","v":0}]
[15,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,Data!$A$9:$B$20,2,FALSE)+IF(C17=\"DCNM-FBD2\",D17*Data!$F$14+E17*Data!$F$12+F17*Data!$F$13+G17*Data!$F$15+H17*Data!$F$16+I17*Data!$F$17+J17*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K17)>0,COUNTBLANK(L17)>0),\"\",2*(Data!$B$7/1000)*K17+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.361393521371426,115.30994725839847,1.4569209537944443,0,0,{"$f":"Q17+R17+SUM($S$3:S16)","v":0}]
[16,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,Data!$A$9:$B$20,2,FALSE)+IF(C18=\"DCNM-FBD2\",D18*Data!$F$14+E18*Data!$F$12+F18*Data!$F$13+G18*Data!$F$15+H18*Data!$F$16+I18*Data!$F$17+J18*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K18)>0,COUNTBLANK(L18)>0),\"\",2*(Data!$B$7/1000)*K18+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.169079955470558,115.82364055841732,1.3416110065360458,0,0,{"$f":"Q18+R18+SUM($S$3:S17)","v":0}]
[17,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,Data!$A$9:$B$20,2,FALSE)+IF(C19=\"DCNM-FBD2\",D19*Data!$F$14+E19*Data!$F$12+F19*Data!$F$13+G19*Data!$F$15+H19*Data!$F$16+I19*Data!$F$17+J19*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K19)>0,COUNTBLANK(L19)>0),\"\",2*(Data!$B$7/1000)*K19+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.991987302607797,116.30074145692519,1.2257873659776286,0,0,{"$f":"Q19+R19+SUM($S$3:S18)","v":0}]
[18,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,Data!$A$9:$B$20,2,FALSE)+IF(C20=\"DCNM-FBD2\",D20*Data!$F$14+E20*Data!$F$12+F20*Data!$F$13+G20*Data!$F$15+H20*Data!$F$16+I20*Data!$F$17+J20*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K20)>0,COUNTBLANK(L20)>0),\"\",2*(Data!$B$7/1000)*K20+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.830183370298748,116.74010257605686,1.1094866245207033,0,0,{"$f":"Q20+R20+SUM($S$3:S19)","v":0}]
[19,2,"DCNM-DE",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,Data!$A$9:$B$20,2,FALSE)+IF(C21=\"DCNM-FBD2\",D21*Data!$F$14+E21*Data!$F$12+F21*Data!$F$13+G21*Data!$F$15+H21*Data!$F$16+I21*Data!$F$17+J21*Data!$F$18,0))","v":5},{"$f":"IF(OR(COUNTBLANK(K21)>0,COUNTBLANK(L21)>0),\"\",2*(Data!$B$7/1000)*K21+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.683731135862018,117.14064977321301,0.99274652194464652,0,0,{"$f":"Q21+R21+SUM($S$3:S20)","v":0}]
[20,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(C22,Data!$A$9:$B$20,2,FALSE)+IF(C22=\"DCNM-FBD2\",D22*Data!$F$14+E22*Data!$F$12+F22*Data!$F$13+G22*Data!$F$15+H22*Data!$F$16+I22*Data!$F$17+J22*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K22)>0,COUNTBLANK(L22)>0),\"\",2*(Data!$B$7/1000)*K22+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.552688594965325,72.850860952809001,0.87560587217143349,0,0,{"$f":"Q22+R22+SUM($S$3:S21)","v":0}]
[21,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(C23,Data!$A$9:$B$20,2,FALSE)+IF(C23=\"DCNM-FBD2\",D23*Data!$F$14+E23*Data!$F$12+F23*Data!$F$13+G23*Data!$F$15+H23*Data!$F$16+I23*Data!$F$17+J23*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K23)>0,COUNTBLANK(L23)>0),\"\",2*(Data!$B$7/1000)*K23+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.437108619838696,73.049274581133872,0.80275501121862447,0,0,{"$f":"Q23+R23+SUM($S$3:S22)","v":0}]
[22,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(C24,Data!$A$9:$B$20,2,FALSE)+IF(C24=\"DCNM-FBD2\",D24*Data!$F$14+E24*Data!$F$12+F24*Data!$F$13+G24*Data!$F$15+H24*Data!$F$16+I24*Data!$F$17+J24*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K24)>0,COUNTBLANK(L24)>0),\"\",2*(Data!$B$7/1000)*K24+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.331144958357839,73.232132110991671,0.72970573663749061,0,0,{"$f":"Q24+R24+SUM($S$3:S23)","v":0}]
[23,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(C25,Data!$A$9:$B$20,2,FALSE)+IF(C25=\"DCNM-FBD2\",D25*Data!$F$14+E25*Data!$F$12+F25*Data!$F$13+G25*Data!$F$15+H25*Data!$F$16+I25*Data!$F$17+J25*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K25)>0,COUNTBLANK(L25)>0),\"\",2*(Data!$B$7/1000)*K25+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.234823801121692,73.399146036396374,0.65647360452649894,0,0,{"$f":"Q25+R25+SUM($S$3:S24)","v":0}]
[24,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(C26,Data!$A$9:$B$20,2,FALSE)+IF(C26=\"DCNM-FBD2\",D26*Data!$F$14+E26*Data!$F$12+F26*Data!$F$13+G26*Data!$F$15+H26*Data!$F$16+I26*Data!$F$17+J26*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K26)>0,COUNTBLANK(L26)>0),\"\",2*(Data!$B$7/1000)*K26+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.148169285324194,73.550050988321487,0.58307445849010253,0,0,{"$f":"Q26+R26+SUM($S$3:S25)","v":0}]
[25,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(C27,Data!$A$9:$B$20,2,FALSE)+IF(C27=\"DCNM-FBD2\",D27*Data!$F$14+E27*Data!$F$12+F27*Data!$F$13+G27*Data!$F$15+H27*Data!$F$16+I27*Data!$F$17+J27*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K27)>0,COUNTBLANK(L27)>0),\"\",2*(Data!$B$7/1000)*K27+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.071203456803502,73.684604795841338,0.50952440750178107,0,0,{"$f":"Q27+R27+SUM($S$3:S26)","v":0}]
[26,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(C28,Data!$A$9:$B$20,2,FALSE)+IF(C28=\"DCNM-FBD2\",D28*Data!$F$14+E28*Data!$F$12+F28*Data!$F$13+G28*Data!$F$15+H28*Data!$F$16+I28*Data!$F$17+J28*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K28)>0,COUNTBLANK(L28)>0),\"\",2*(Data!$B$7/1000)*K28+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.003946235013267,73.802589467556516,0.43583980270593975,0,0,{"$f":"Q28+R28+SUM($S$3:S27)","v":0}]
[27,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C29),\"\",VLOOKUP(C29,Data!$A$9:$B$20,2,FALSE)+IF(C29=\"DCNM-FBD2\",D29*Data!$F$14+E29*Data!$F$12+F29*Data!$F$13+G29*Data!$F$15+H29*Data!$F$16+I29*Data!$F$17+J29*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K29)>0,COUNTBLANK(L29)>0),\"\",2*(Data!$B$7/1000)*K29+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.946415381056084,73.903812085931605,0.36203721323838323,0,0,{"$f":"Q29+R29+SUM($S$3:S28)","v":0}]
[28,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C30),\"\",VLOOKUP(C30,Data!$A$9:$B$20,2,FALSE)+IF(C30=\"DCNM-FBD2\",D30*Data!$F$14+E30*Data!$F$12+F30*Data!$F$13+G30*Data!$F$15+H30*Data!$F$16+I30*Data!$F$17+J30*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K30)>0,COUNTBLANK(L30)>0),\"\",2*(Data!$B$7/1000)*K30+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.898626468908617,73.988105607719447,0.28813340115245162,0,0,{"$f":"Q30+R30+SUM($S$3:S29)","v":0}]
[29,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C31),\"\",VLOOKUP(C31,Data!$A$9:$B$20,2,FALSE)+IF(C31=\"DCNM-FBD2\",D31*Data!$F$14+E31*Data!$F$12+F31*Data!$F$13+G31*Data!$F$15+H31*Data!$F$16+I31*Data!$F$17+J31*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K31)>0,COUNTBLANK(L31)>0),\"\",2*(Data!$B$7/1000)*K31+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.86059285995649,74.055329564274643,0.21414529554473216,0,0,{"$f":"Q31+R31+SUM($S$3:S30)","v":0}]
[30,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(C32,Data!$A$9:$B$20,2,FALSE)+IF(C32=\"DCNM-FBD2\",D32*Data!$F$14+E32*Data!$F$12+F32*Data!$F$13+G32*Data!$F$15+H32*Data!$F$16+I32*Data!$F$17+J32*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K32)>0,COUNTBLANK(L32)>0),\"\",2*(Data!$B$7/1000)*K32+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.832325680944585,74.105370656265194,0.14008996598045753,0,0,{"$f":"Q32+R32+SUM($S$3:S31)","v":0}]
[31,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(C33,Data!$A$9:$B$20,2,FALSE)+IF(C33=\"DCNM-FBD2\",D33*Data!$F$14+E33*Data!$F$12+F33*Data!$F$13+G33*Data!$F$15+H33*Data!$F$16+I33*Data!$F$17+J33*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K33)>0,COUNTBLANK(L33)>0),\"\",2*(Data!$B$7/1000)*K33+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.813833805435166,74.138143238065069,6.5984595324192333E-2,0,1,{"$f":"Q33+R33+SUM($S$3:S32)","v":1}]
[32,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(C34,Data!$A$9:$B$20,2,FALSE)+IF(C34=\"DCNM-FBD2\",D34*Data!$F$14+E34*Data!$F$12+F34*Data!$F$13+G34*Data!$F$15+H34*Data!$F$16+I34*Data!$F$17+J34*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K34)>0,COUNTBLANK(L34)>0),\"\",2*(Data!$B$7/1000)*K34+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.805123838852374,74.153589687945299,-8.1535479138727385E-3,0,1,{"$f":"Q34+R34+SUM($S$3:S33)","v":2}]
[33,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C35),\"\",VLOOKUP(C35,Data!$A$9:$B$20,2,FALSE)+IF(C35=\"DCNM-FBD2\",D35*Data!$F$14+E35*Data!$F$12+F35*Data!$F$13+G35*Data!$F$15+H35*Data!$F$16+I35*Data!$F$17+J35*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K35)>0,COUNTBLANK(L35)>0),\"\",2*(Data!$B$7/1000)*K35+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.806200107177006,74.151680661065697,-8.2307137601818042E-2,0,1,{"$f":"Q35+R35+SUM($S$3:S34)","v":4}]
[34,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C36),\"\",VLOOKUP(C36,Data!$A$9:$B$20,2,FALSE)+IF(C36=\"DCNM-FBD2\",D36*Data!$F$14+E36*Data!$F$12+F36*Data!$F$13+G36*Data!$F$15+H36*Data!$F$16+I36*Data!$F$17+J36*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K36)>0,COUNTBLANK(L36)>0),\"\",2*(Data!$B$7/1000)*K36+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(M36)>0,\"\",N35-(P35*M36))","v":41.817064649340445},{"$f":"IF(COUNTBLANK(N36)>0,\"\",(L36/N36)*1000)","v":74.132415223192737},{"$f":"IF(COUNTBLANK(O36)>0,\"\",P35-O35/1000)","v":-0.15645881826288374},0,{"$f":"IFERROR(IF(P36<O36/1000,1,0),)","v":1},{"$f":"Q36+R36+SUM($S$3:S35)","v":8}]
[35,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C37),\"\",VLOOKUP(C37,Data!$A$9:$B$20,2,FALSE)+IF(C37=\"DCNM-FBD2\",D37*Data!$F$14+E37*Data!$F$12+F37*Data!$F$13+G37*Data!$F$15+H37*Data!$F$16+I37*Data!$F$17+J37*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K37)>0,COUNTBLANK(L37)>0),\"\",2*(Data!$B$7/1000)*K37+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.837717213351148,74.095820864020183,-0.23059123348607646,0,1,{"$f":"Q37+R37+SUM($S$3:S36)","v":16}]
[36,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C38),\"\",VLOOKUP(C38,Data!$A$9:$B$20,2,FALSE)+IF(C38=\"DCNM-FBD2\",D38*Data!$F$14+E38*Data!$F$12+F38*Data!$F$13+G38*Data!$F$15+H38*Data!$F$16+I38*Data!$F$17+J38*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K38)>0,COUNTBLANK(L38)>0),\"\",2*(Data!$B$7/1000)*K38+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.868155256171313,74.041953389935031,-0.30468705435009663,0,1,{"$f":"Q38+R38+SUM($S$3:S37)","v":32}]
[37,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C39),\"\",VLOOKUP(C39,Data!$A$9:$B$20,2,FALSE)+IF(C39=\"DCNM-FBD2\",D39*Data!$F$14+E39*Data!$F$12+F39*Data!$F$13+G39*Data!$F$15+H39*Data!$F$16+I39*Data!$F$17+J39*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K39)>0,COUNTBLANK(L39)>0),\"\",2*(Data!$B$7/1000)*K39+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(M39)>0,\"\",N38-(P38*M39))","v":41.908373947345524},{"$f":"IF(COUNTBLANK(N39)>0,\"\",(L39/N39)*1000)","v":73.970896697039578},{"$f":"IF(COUNTBLANK(O39)>0,\"\",P38-O38/1000)","v":-0.37872900774003165},0,{"$f":"IFERROR(IF(P39<O39/1000,1,0),)","v":1},{"$f":"Q39+R39+SUM($S$3:S38)","v":64}]
[38,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C40),\"\",VLOOKUP(C40,Data!$A$9:$B$20,2,FALSE)+IF(C40=\"DCNM-FBD2\",D40*Data!$F$14+E40*Data!$F$12+F40*Data!$F$13+G40*Data!$F$15+H40*Data!$F$16+I40*Data!$F$17+J40*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K40)>0,COUNTBLANK(L40)>0),\"\",2*(Data!$B$7/1000)*K40+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.958366176367207,73.882762426198951,-0.4526999044370712,0,1,{"$f":"Q40+R40+SUM($S$3:S39)","v":128}]
[39,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C41),\"\",VLOOKUP(C41,Data!$A$9:$B$20,2,FALSE)+IF(C41=\"DCNM-FBD2\",D41*Data!$F$14+E41*Data!$F$12+F41*Data!$F$13+G41*Data!$F$15+H41*Data!$F$16+I41*Data!$F$17+J41*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K41)>0,COUNTBLANK(L41)>0),\"\",2*(Data!$B$7/1000)*K41+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.018122563752897,73.777689502820081,-0.52658266686327015,0,{"$f":"IFERROR(IF(P41<O41/1000,1,0),)","v":1},{"$f":"Q41+R41+SUM($S$3:S40)","v":256}]
[40,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C42),\"\",VLOOKUP(C42,Data!$A$9:$B$20,2,FALSE)+IF(C42=\"DCNM-FBD2\",D42*Data!$F$14+E42*Data!$F$12+F42*Data!$F$13+G42*Data!$F$15+H42*Data!$F$16+I42*Data!$F$17+J42*Data!$F$18,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(K42)>0,COUNTBLANK(L42)>0),\"\",2*(Data!$B$7/1000)*K42+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(M42)>0,\"\",N41-(P41*M42))","v":42.087631475778849},{"$f":"IF(COUNTBLANK(N42)>0,\"\",(L42/N42)*1000)","v":73.655843564968237},{"$f":"IF(COUNTBLANK(O42)>0,\"\",P41-O41/1000)","v":-0.6003603563660902},0,{"$f":"IFERROR(IF(P42<O42/1000,1,0),)","v":1},{"$f":"Q42+R42+SUM($S$3:S41)","v":512}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]

{"sheet":"Revision history","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
["Version","Date","Author","Comment"]
[1,"2014-06-16","Sjack Schellekens","Initial version"]
["1.01","2014-07-16","Jeroen de Graauw","Added revision history tab, and modified column width 'Calculate'B by splitting Cable Length over 2 lines"]
["1.02","2014-10-14","Derk-Jan Elshout","added Feet"]
["2.00","2016-03-10","Sjack Schellekens","Created master file with automatic protect feature"]
["2.01","2016-05-26","Sjack Schellekens","Change to Marco file version to handle different devices"]
["2.04","2018-04-21","Sjack Schellekens","Added interpreter desk"]
["2.05","2018-09-20","Sjack Schellekens","Improved initial state, so it will start with an empty list"]
["2.06","2019-10-24","Sjack Schellekens","Change data validation 2-99 for meters and 6-325 for feet, initial list changed to DCNM-D"]
["2.07","2020-04-09","Sjack Schellekens","Fixed maximum check for imperial measures"]
["2.08","2021-03-22","Tim Vriends","Added FBD + modules"]
["2.09","2022-10-10","Tim Vriends","Added flush ph2 and TXO"]
["2.10","2024-09-27","Tim Vriends","Correct errors wrt #of FAI and FVPs (changed from 2 to 4)"]
["2.11","2025-01-24","Tim Vriends","Added nameplates"]
["2.12","2025-03-07","Tim Vriends","resolved bug wrt meter/feet conversion"]
["2.13","2025-06-25","Derk-Jan Elshout","added FLS2 calculation page"]

{"sheet":"Simple Configurator for Install","index":4,"n_rows":138,"n_cols":34,"rows_kept":138,"cut":false,"hidden":false,"merged":[[62,15,62,16],[63,15,63,16],[68,7,68,9],[96,7,96,9],[96,10,96,11],[89,7,89,14],[91,7,91,9],[93,7,93,9],[94,7,94,9],[95,7,95,9],[95,10,95,11],[69,7,69,9],[13,0,13,2],[14,0,14,2],[49,7,52,7],[49,8,52,8],[53,7,56,7],[53,8,56,8],[57,7,60,7],[57,8,60,8],[8,0,8,2],[8,3,8,4],[0,0,0,4],[1,0,1,4],[5,0,5,2],[6,0,6,2],[7,0,7,2]]}
["Flush Language Selector 2",null,null,null,null,null,null,"Class","PClass\n[W]","PClass_PD [W]","VPSE_min\n[V]","VPSE_max\n[V]","Number of pairs","PCable_max\n[W]","Loss\n[%]","Rcable\n[Ω]","Icable\n[A]","Vcable\n[V]","VPD\n[V]"]
["Device number calculation tool",null,null,null,null,null,null,0,15.4,12.94,44,57,2,{"$f":"I2-J2","v":2.4600000000000009},{"$f":"N2/I2","v":0.15974025974025979},{"$f":"(N2*K2^2)/(N2^2+2*N2*J2+J2^2)","v":20.081632653061231},{"$f":"(K2-SQRT(K2^2-4*P2*J2))/(2*P2)","v":0.35},{"$f":"P2*Q2","v":7.0285714285714302},{"$f":"K2-R2","v":36.971428571428568}]
[null,null,null,null,null,null,null,1,4,3.84,44,57,2,0.16000000000000014,4.0000000000000036E-2,19.360000000000017,9.0909090909090912E-2,1.7600000000000016,42.239999999999995]
[null,null,null,null,null,null,null,2,7,6.49,44,57,2,0.50999999999999979,7.2857142857142829E-2,20.150204081632644,0.15909090909090901,3.2057142857142824,40.794285714285721]
["INPUT",null,null,null,null,null,null,3,15.4,12.95,44,57,2,2.4500000000000011,0.15909090909090914,20.000000000000004,0.35000000000000003,7.0000000000000018,37]
[null,null,null,"Value","Units",null,null,4,30,25.5,50,57,2,4.5,0.15,12.5,0.6,7.5,42.5]
["Cable length from PSE (PoE switch) to 1st device:",null,null,100,"m",null,null,5,45,40,50,57,4,5,0.1111111111111111,6.1728395061728394,0.89999999999999969,5.5555555555555536,44.444444444444443]
["Cable length between devices:",null,null,2,"m",null,null,6,60,51,50,57,4,9,0.15,6.25,1.2,7.5,42.5]
[null,null,null,"CAT6",null,null,null,7,75,62,50,57,4,13,0.17333333333333334,5.7777777777777777,1.5000000000000002,8.6666666666666679,41.333333333333329]
["Wire Gauge",null,null,22,"AWG","(22, …, 26)",null,8,90,71.3,52,57,4,18.700000000000003,0.20777777777777781,6.242567901234569,1.7307692307692311,10.804444444444448,41.195555555555551]
["PoE class",null,null,6,null,"(0, …, 6)"]
[]
["OUTPUT"]
["Maximum number of allowed devices:",null,null,{"$f":"'Simple Configurator for Install'!K132","v":18}]
["Total cable length required:",null,null,{"$f":"'Simple Configurator for Install'!K133","v":134},"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Material","Temperature [ºC]","Resistivity [Ωm]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper",20,1.6800000000000002E-8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper",25,{"$f":"U41+(U41*(T42-T41))*0.0038","v":1.71192E-8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper",30,{"$f":"U42+(U42*(T43-T42))*0.0038","v":1.74444648E-8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper",35,{"$f":"U43+(U43*(T44-T43))*0.0038","v":1.7775909631199999E-8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper",40,{"$f":"U44+(U44*(T45-T44))*0.0038","v":1.8113651914192801E-8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Copper",45,{"$f":"U45+(U45*(T46-T45))*0.0038","v":1.8457811300562463E-8}]
[null,null,null,null,null,null,null,"For reference","https://ethernetalliance.org/wp-content/uploads/2017/06/EA_Whitepaper_PoE_Cable_Losses_June.pdf"]
[]
[null,null,null,null,null,null,null,"CAT","AWG","AWG [in]","AWG [mm]","Cross Section 1 conductor [mm2]","Cross Section 2 conductor [mm2]","Cross Section 4 conductor [mm2]","Cross Section 8 conductor [mm2]","Length\n[m]","Material","Temperature [ºC]","Resistance 1 conductor\n[Ω]","Resistance 1 pair\n[Ω]","Resistance 2 pairs\n[Ω]","Resistance 4 pairs\n[Ω]","Temperature [ºC]","Resistance 1 conductor\n[Ω]","Resistance 1 pair\n[Ω]","Resistance 2 pairs\n[Ω]","Resistance 4 pairs\n[Ω]"]
[null,null,null,null,null,null,null,"CAT5",24,2.01E-2,{"$f":"J50*25.4","v":0.51053999999999999},{"$f":"PI()*(K50/2)^2","v":0.20471488863018006},{"$f":"2*L50","v":0.40942977726036012},{"$f":"2*M50","v":0.81885955452072023},{"$f":"2*N50","v":1.6377191090414405},1,"Copper",25,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P50/($L$50/1000000)","v":8.3624596699100107E-2},{"$f":"S50/2","v":4.1812298349550053E-2},2.0906149174775027E-2,1.0453074587387513E-2,45,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P50/($L$50/1000000)","v":9.0163502147158056E-2},{"$f":"X50/2","v":4.5081751073579028E-2},2.2540875536789514E-2,1.1270437768394757E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P51/($L$50/1000000)","v":0.83624596699100096},0.41812298349550048,0.20906149174775024,0.10453074587387512,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P51/($L$50/1000000)","v":0.90163502147158059},0.45081751073579029,0.22540875536789515,0.11270437768394757]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P52/($L$50/1000000)","v":8.3624596699100096},4.1812298349550048,2.0906149174775024,1.0453074587387512,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P52/($L$50/1000000)","v":9.016350214715807},4.5081751073579035,2.2540875536789517,1.1270437768394759]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P53/($L$50/1000000)","v":83.62459669910011},41.812298349550055,20.906149174775027,10.453074587387514,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P53/($L$50/1000000)","v":90.16350214715807},45.081751073579035,22.540875536789517,11.270437768394759]
[null,null,null,null,null,null,null,"CAT6",23,2.2599999999999999E-2,{"$f":"J54*25.4","v":0.57403999999999988},{"$f":"PI()*(K54/2)^2","v":0.25880591202383785},{"$f":"2*L54","v":0.51761182404767569},{"$f":"2*M54","v":1.0352236480953514},{"$f":"2*N54","v":2.0704472961907028},1,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P54/($L$54/1000000)","v":6.6146866067044091E-2},3.3073433033522046E-2,1.6536716516761023E-2,8.2683582583805114E-3,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P54/($L$54/1000000)","v":7.1319125425783808E-2},3.5659562712891904E-2,1.7829781356445952E-2,8.914890678222976E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P55/($L$54/1000000)","v":0.66146866067044097},0.33073433033522048,0.16536716516761024,8.2683582583805121E-2,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P55/($L$54/1000000)","v":0.71319125425783814},0.35659562712891907,0.17829781356445953,8.9148906782229767E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P56/($L$54/1000000)","v":6.6146866067044092},3.3073433033522046,1.6536716516761023,0.82683582583805115,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P56/($L$54/1000000)","v":7.1319125425783811},3.5659562712891906,1.7829781356445953,0.89148906782229764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P57/($L$54/1000000)","v":66.146866067044101},33.073433033522051,16.536716516761025,8.2683582583805126,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P57/($L$54/1000000)","v":71.31912542578381},35.659562712891905,17.829781356445952,8.9148906782229762]
[null,null,null,null,null,null,null,"CAT7",23,2.2599999999999999E-2,{"$f":"J58*25.4","v":0.57403999999999988},{"$f":"PI()*(K58/2)^2","v":0.25880591202383785},{"$f":"2*L58","v":0.51761182404767569},{"$f":"2*M58","v":1.0352236480953514},{"$f":"2*N58","v":2.0704472961907028},1,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P58/($L$58/1000000)","v":6.6146866067044091E-2},3.3073433033522046E-2,1.6536716516761023E-2,8.2683582583805114E-3,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P58/($L$58/1000000)","v":7.1319125425783808E-2},3.5659562712891904E-2,1.7829781356445952E-2,8.914890678222976E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P59/($L$58/1000000)","v":0.66146866067044097},0.33073433033522048,0.16536716516761024,8.2683582583805121E-2,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P59/($L$58/1000000)","v":0.71319125425783814},0.35659562712891907,0.17829781356445953,8.9148906782229767E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P60/($L$58/1000000)","v":6.6146866067044092},3.3073433033522046,1.6536716516761023,0.82683582583805115,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P60/($L$58/1000000)","v":7.1319125425783811},3.5659562712891906,1.7829781356445953,0.89148906782229764]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1000,null,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$R$50,$S$41:$S$46&$T$41:$T$46,0))*$P61/($L$58/1000000)","v":66.146866067044101},33.073433033522051,16.536716516761025,8.2683582583805126,null,{"$f":"INDEX($U$41:$U$46,MATCH($Q$50&$W$50,$S$41:$S$46&$T$41:$T$46,0))*$P61/($L$58/1000000)","v":71.31912542578381},35.659562712891905,17.829781356445952,8.9148906782229762]
[]
[null,null,null,null,null,null,null,null,"AWG\nChosen","AWG [in]","AWG [mm]","Cross Section 1 conductor [mm2]","Cross Section 2 conductor [mm2]","Cross Section 4 conductor [mm2]","Cross Section 8 conductor [mm2]","Cross Section based on PoE class\n[mm2]"]
[null,null,null,null,null,null,null,null,{"$f":"'Simple Configurator for Install'!D10","v":22},{"$f":"0.005*92^((36-I64)/39)","v":2.5346586554743283E-2},{"$f":"J64*25.4","v":0.64380329849047935},{"$f":"PI()*(K64/2)^2","v":0.3255339412454667},{"$f":"2*L64","v":0.65106788249093339},{"$f":"2*M64","v":1.3021357649818668},{"$f":"2*N64","v":2.6042715299637336},{"$f":"VLOOKUP(I64,I64:O64,7-(-0.5*L73+3),FALSE)","v":1.3021357649818668}]
[]
[]
[null,null,null,null,null,null,null,"User Interface data introduction restrictions"]
[]
[null,null,null,null,null,null,null,"Allowed Wire Gauge:",null,null,22,23,24,25,26]
[null,null,null,null,null,null,null,"Allowed PoE classes:",null,null,0,1,2,3,4,5,6]
[]
[null,null,null,null,null,null,null,"Chosen class","VPSE_min\n[V]","VPSE_max\n[V]","PClass\n[W]","Number of pairs"]
[null,null,null,null,null,null,null,{"$f":"'Simple Configurator for Install'!D11","v":6},{"$f":"VLOOKUP($H73,$H$2:$L$10,4,FALSE)","v":50},{"$f":"VLOOKUP($H73,$H$2:$M$10,5,FALSE)","v":57},{"$f":"VLOOKUP($H73,$H$2:$L$10,2,FALSE)","v":60},{"$f":"VLOOKUP($H73,$H$2:$M$10,6,FALSE)","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Daisy-chain topology represented in the schematic design above used to estimate the maximum number of\ndevices allowed to be powered in the same PoE branch."]
[]
[null,null,null,null,null,null,null,"Cable from Switch to 1st device",null,null,{"$f":"'Simple Configurator for Install'!D7","v":100},"m"]
[]
[null,null,null,null,null,null,null,"Insert Cable Length:",null,null,{"$f":"'Simple Configurator for Install'!D8","v":2},"m"]
[null,null,null,null,null,null,null,"Insert Temperature:",null,null,25,"ºC"]
[null,null,null,null,null,null,null,"Cable Conductor Material:",null,null,"Copper"]
[null,null,null,null,null,null,null,"Insert cable category:",null,null,{"$f":"'Simple Configurator for Install'!D9","v":"CAT6"}]
[]
[null,null,null,null,null,null,null,"# Devices","Vin\n[V]","LCable\n[m]","Rcable\n[Ω]","VDrop_Device\n[V]","PDevice\n[W]","Icable\n[A]","Vcable\n[V]","Pin\n[W]","PDiode\n[W]","PCable\n[W]","ILoad","Vout\n[V]",null,"# Devices","Vin\n[V]","LCable\n[m]","Rcable\n[Ω]","VDrop_Device\n[V]","PDevice\n[W]","Icable\n[A]","Vcable\n[V]","Pin\n[W]","PDiode\n[W]","PCable\n[W]","ILoad","Vout\n[V]"]
[null,null,null,null,null,null,null,1,{"$f":"I73","v":50},{"$f":"$K$94","v":2},{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J100/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,{"$f":"(I100-L100-SQRT((L100-I100)^2-4*K100*M100))/(2*K100)","v":6.0242880048658298E-2},{"$f":"K100*N100","v":1.5840282401633488E-3},{"$f":"N100*I100","v":3.0121440024329149},{"$f":"L100*N100","v":1.204857600973166E-2},{"$f":"O100*N100","v":9.5426423265847912E-5},{"$f":"N100","v":6.0242880048658298E-2},{"$f":"(P100-R100-Q100)/S100","v":49.798415971759837},null,1,{"$f":"I100","v":50},{"$f":"$K$92","v":100},{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X100/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,{"$f":"$M$100","v":3},{"$f":"(W100-Z100-SQRT((Z100-W100)^2-4*Y100*AA100))/(2*Y100)","v":6.0337073359725948E-2},{"$f":"Y100*AB100","v":7.9325248106844271E-2},{"$f":"AB100*W100","v":3.0168536679862976},{"$f":"Z100*AB100","v":1.2067414671945191E-2},{"$f":"AC100*AB100","v":4.7862533143011249E-3},{"$f":"AB100","v":6.0337073359725948E-2},{"$f":"(AD100-AF100-AE100)/AG100","v":49.720674751893156}]
[null,null,null,null,null,null,null,2,{"$f":"I100+L101+O101","v":50.203161670184457},2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J101/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,{"$f":"$M$100","v":3},{"$f":"N100+M101/I100","v":0.1202428800486583},3.161670184456775E-3,6.0365727467713892,2.4048576009731662E-2,3.8016832874305536E-4,{"$f":"N101-N100","v":0.06},{"$f":"(P101-P100-R101-Q101)/S101","v":49.999999999999993},null,2,{"$f":"I100+Z101+AC101","v":50.358083509222844},100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X101/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,{"$f":"N100+AA101/I100","v":0.1202428800486583},0.15808350922283873,6.0552009948798,2.4048576009731662E-2,1.9008416437152766E-2,{"$f":"AB101-N100","v":0.06},{"$f":"(AD101-P100-AF101-AE101)/AG101","v":50.000000000000014}]
[null,null,null,null,null,null,null,3,50.407894597927012,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J102/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.1800000726276606,4.7329277425543397E-3,9.0734246886343222,3.6000014525532122E-2,8.5192733740125086E-4,5.9757192579002305E-2,50.203161670184457,null,3,50.63980805731218,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X102/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.1800000726276606,0.23664638712771696,9.1151691281669844,3.6000014525532122E-2,4.2596366870062539E-2,5.9757192579002305E-2,50.203161670184478]
[null,null,null,null,null,null,null,4,50.614192401525699,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J103/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.23951455987076345,6.2978035986849248E-3,12.122836016265568,4.7902911974152695E-2,1.50841565709153E-3,5.9514487243102848E-2,50.407894597927033,null,4,50.92278477786126,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X103/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.23951455987076345,0.31489017993424617,12.196748383463053,4.7902911974152695E-2,7.5420782854576485E-2,5.9514487243102848E-2,50.407894597927033]
[null,null,null,null,null,null,null,5,50.822048702721048,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J104/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.298786472701078,7.8563011953450557E-3,15.184940667328419,5.9757294540215604E-2,2.347356522634412E-3,5.9271912830314549E-2,50.61419240152572,null,5,51.207007461292953,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X104/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.298786472701078,0.39281505976725278,15.299961136937505,5.9757294540215604E-2,0.1173678261317206,5.9271912830314549E-2,50.614192401525699]
[null,null,null,null,null,null,null,6,51.031457127438138,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J105/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.35781597026321343,9.4084247170882467E-3,18.259870345999857,7.1563194052642692E-2,3.3664846187933303E-3,5.9029497562135436E-2,50.822048702721077,null,6,51.492469938575461,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X105/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.35781597026321343,0.47042123585441226,18.42482809232073,7.1563194052642692E-2,0.1683242309396665,5.9029497562135436E-2,50.822048702721069]
[null,null,null,null,null,null,null,7,51.242411306512537,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J106/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.41660323930999493,1.0954179074399332E-2,21.347754540348234,8.3320647861998998E-2,4.563546486376524E-3,5.8787269046781498E-2,51.031457127438131,null,7,51.77916608115811,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X106/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.41660323930999493,0.54770895371996653,21.571368318180685,8.3320647861998998E-2,0.22817732431882615,5.8787269046781498E-2,51.031457127438166]
[null,null,null,null,null,null,null,8,51.454904876400199,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J107/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.47514849359272465,1.2493569887661978E-2,24.448720539978495,9.5029698718544942E-2,5.9363009117180147E-3,5.854525428272972E-2,51.242411306512501,null,8,52.067089800895637,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X107/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.47514849359272465,0.62467849438309886,24.73959928465268,9.5029698718544942E-2,0.29681504558590072,5.854525428272972E-2,51.24241130651253]
[null,null,null,null,null,null,null,9,51.668931479871432,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J108/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.5334519732552816,1.402660347122712E-2,27.562893453929352,0.10669039465105633,7.4825192997954896E-3,5.8303479662556945E-2,51.454904876400256,null,9,52.356235049961555,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X108/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.5334519732552816,0.70133017356135596,27.929536899619329,0.10669039465105633,0.37412596498977446,5.8303479662556945E-2,51.454904876400228]
[null,null,null,null,null,null,null,10,51.884484766689027,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J109/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.5915139442323416,1.5553286817589744E-2,30.690396228807071,0.11830278884646833,9.199986031249394E-3,5.8061970977060007E-2,51.668931479871503,null,10,52.646595820750925,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X109/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.5915139442323416,0.7776643408794871,31.141195544338292,0.11830278884646833,0.45999930156246965,5.8061970977060007E-2,51.66893147987151]
[null,null,null,null,null,null,null,11,52.101558394270711,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J110/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.64933469765198559,1.7073627581681041E-2,33.831349667141048,0.12986693953039713,1.1086498803573461E-2,5.7820753419643989E-2,51.88448476668912,null,11,52.938166145773081,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X110/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.64933469765198559,0.85368137908405206,34.374588108516143,0.12986693953039713,0.55432494017867306,5.7820753419643989E-2,51.884484766689042]
[null,null,null,null,null,null,null,12,52.320146028335998,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J111/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.70691454924294861,1.8587634065282608E-2,36.985872445946391,0.14138290984858973,1.3139868956752131E-2,5.7579851590963016E-2,52.101558394270725,null,12,53.230940097534841,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X111/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.70691454924294861,0.92938170326413017,37.629726024827242,0.14138290984858973,0.65699344783760638,5.7579851590963016E-2,52.101558394270668]
[null,null,null,null,null,null,null,13,52.540241343537566,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J112/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.76425383874675146,2.0095315201568993E-2,40.154081135479366,0.1528507677493503,1.5357921783625052E-2,5.7339289503802848E-2,52.320146028336005,null,13,53.52491178841445,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X112/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.76425383874675146,1.0047657600784494,40.90661930287699,0.1528507677493503,0.76789608918125241,5.7339289503802848E-2,52.320146028335955]
[null,null,null,null,null,null,null,14,52.761838024077356,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J113/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.82135292933494108,2.1596680539784623E-2,43.336090218171613,0.16427058586698823,1.7738496825263017E-2,5.7099090588189627E-2,52.540241343537524,null,14,53.820075370526801,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X113/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.82135292933494108,1.079834026989231,44.205276562609505,0.16427058586698823,0.88692484126315074,5.7099090588189627E-2,52.540241343537609]
[null,null,null,null,null,null,null,15,52.984929764307417,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J114/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.87821220703165404,2.3091740230060661E-2,46.532012107729592,0.17564244140633081,2.0279448151643207E-2,5.6859277696712951E-2,52.761838024077399,null,15,54.116425035580392,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X114/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.87821220703165404,1.1545870115030328,47.525705067160111,0.17564244140633081,1.0139724075821601,5.6859277696712951E-2,52.761838024077427]
[null,null,null,null,null,null,null,16,53.2095102693158,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J115/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.93483208014170405,2.45805050083771E-2,49.741957168385852,0.18696641602834083,2.297864462791474E-2,5.6619873110050012E-2,52.98492976430753,null,16,54.413955014726277,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X115/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.93483208014170405,1.2290252504188548,50.867910755153673,0.18696641602834083,1.1489322313957369,5.6619873110050012E-2,52.984929764307516]
[null,null,null,null,null,null,null,17,53.435573255497481,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J116/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,0.9912129786843844,2.6062986181675175E-2,52.966033734289283,0.19824259573687689,2.58339701665482E-2,5.6380898542680358E-2,53.209510269315864,null,17,54.71265957839956,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X116/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,0.9912129786843844,1.3031493090837587,54.231898272450145,0.19824259573687689,1.29169850832741,5.6380898542680358E-2,53.209510269315871]
[null,null,null,null,null,null,null,18,53.663112451110607,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J117/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.0473553538331597,2.7539195613124588E-2,56.204348129021589,0.20947107076663196,2.8843323965664702E-2,5.6142375148775292E-2,53.435573255497594,null,18,55.012533036153712,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X117/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.0473553538331597,1.3769597806562293,57.617671003339161,0.20947107076663196,1.442166198283235,5.6142375148775292E-2,53.435573255497623]
[null,null,null,null,null,null,null,19,53.892121596818157,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J118/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.1032596773614143,2.9009145707549994E-2,59.457004685227709,0.22065193547228287,3.200462073384186E-2,5.5904323528254585E-2,53.663112451110614,null,19,55.313569736488105,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X118/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.1032596773614143,1.4504572853774995,61.025231101185959,0.22065193547228287,1.6002310366920929,5.5904323528254585E-2,53.663112451110599]
[null,null,null,null,null,null,null,20,54.122594446215182,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J119/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.1589264410944109,3.0472849397020788E-2,62.724105764348288,0.2317852882188822,3.5315790901695267E-2,5.5666763732996616E-2,53.892121596818171,null,20,55.6157640666692,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X119/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.1589264410944109,1.5236424698510391,64.454579518531361,0.2317852882188822,1.7657895450847629,5.5666763732996616E-2,53.892121596818271]
[null,null,null,null,null,null,null,21,54.35452476634179,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J120/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.2143561563676002,3.1930320126607875E-2,66.005751776442352,0.24287123127352006,3.8774780820534566E-2,5.5429715273189295E-2,54.122594446215295,null,21,55.919110452545581,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X120/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.2143561563676002,1.5965160063303936,67.905716036648542,0.24287123127352006,1.938739041026728,5.5429715273189295E-2,54.122594446215231]
[null,null,null,null,null,null,null,22,54.587906338182101,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J121/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.2695493534914155,3.3381571840310979E-2,69.302041200089036,0.25390987069828314,4.2379552948394045E-2,5.5193197123815319E-2,54.354524766341832,null,22,56.223603358357344,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X121/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.2695493534914155,1.6690785920155489,71.378639294560344,0.25390987069828314,2.118977647419702,5.5193197123815319E-2,54.354524766341832]
[null,null,null,null,null,null,null,23,54.822732957149263,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J122/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.3245065812226724,3.4826618967159592E-2,72.613070602357297,0.2649013162445345,4.6128086023737226E-2,5.4957227731256886E-2,54.587906338181995,null,23,56.529237286540081,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X122/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.3245065812226724,1.7413309483579795,74.873346817520414,0.2649013162445345,2.3064043011868613,5.4957227731256886E-2,54.58790633818186]
[null,null,null,null,null,null,null,24,55.058998433556759,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J123/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.3792284062426849,3.6265476407490546E-2,75.938934658832977,0.27584568124853698,5.0018375227134877E-2,5.4721825020012549E-2,54.822732957149469,null,24,56.836006777523792,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X123/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.3792284062426849,1.8132738203745271,78.389835044962581,0.27584568124853698,2.5009187613567434,5.4721825020012549E-2,54.822732957149384]
[null,null,null,null,null,null,null,25,55.29669659307617,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J124/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.4337154126421983,3.7698159519404827E-2,79.279726173692637,0.28674308252843966,5.4048432331214903E-2,5.4487006399513316E-2,55.058998433556852,null,25,57.143906409527006,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X124/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.4337154126421983,1.884907975970241,81.928099357922164,0.28674308252843966,2.7024216165607449,5.4487006399513316E-2,55.058998433556795]
[null,null,null,null,null,null,null,26,55.535821277181576,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J125/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.4879682014132301,3.912468410540601E-2,82.635536099814459,0.29759364028264601,5.8216285839181772E-2,5.425278877103179E-2,55.296696593076156,null,26,57.452930798346472,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X125/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.4879682014132301,1.9562342052703003,85.488134105934364,0.29759364028264601,2.9108142919590883,5.425278877103179E-2,55.296696593076128]
[null,null,null,null,null,null,null,27,55.776366343580804,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J126/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.5419873899479035,4.0545066399222597E-2,86.006453558916249,0.30839747798958073,6.2519981112201695E-2,5.4019188534673468E-2,55.535821277181682,null,27,57.763074597142705,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X126/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.5419873899479035,2.0272533199611296,89.069932633414126,0.30839747798958073,3.1259990556100843,5.4019188534673468E-2,55.535821277181583]
[null,null,null,null,null,null,null,28,56.018325666633622,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J127/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.5957736115443426,4.1959323052815987E-2,89.392565861711077,0.31915472230886854,6.6957580485947965E-2,5.3786221596439088E-2,55.776366343580939,null,28,58.074332496221608,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X127/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.5957736115443426,2.0979661526407991,92.673487305522528,0.31915472230886854,3.3478790242973977,5.3786221596439088E-2,55.776366343580968]
[null,null,null,null,null,null,null,29,56.261693137757199,2,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*J128/'Simple Configurator for Install'!$P$64*1000000","v":2.6294032404890436E-2},0.2,3,1.6493275149196964,4.3367471123575911E-2,92.793958528071613,0.3298655029839393,7.1527163376599145E-2,5.3553903375353817E-2,56.018325666633586,null,29,58.386699222812418,100,{"$f":"INDEX('Simple Configurator for Install'!$U$41:$U$46,MATCH($K$96&$K$95,'Simple Configurator for Install'!$S$41:$S$46&'Simple Configurator for Install'!$T$41:$T$46,0))*X128/'Simple Configurator for Install'!$P$64*1000000","v":1.3147016202445216},0.2,3,1.6493275149196964,2.1683735561787953,96.298789533524982,0.3298655029839393,3.5763581688299575,5.3553903375353817E-2,56.018325666633778]
[null,null,null,null,null,null,null,"TOTALS",null,{"$f":"SUMIFS(J100:J128,$I$100:$I$128,\"<\"&'Simple Configurator for Install'!$K$69)","v":0},{"$f":"SUMIFS(K100:K128,$I$100:$I$128,\"<\"&'Simple Configurator for Install'!$K$69)","v":0},{"$f":"SUMIFS(L100:L128,$I$100:$I$128,\"<\"&'Simple Configurator for Install'!$K$69)","v":0},null,null,{"$f":"SUMIFS(O100:O128,$I$100:$I$128,\"<\"&'Simple Configurator for Install'!$K$69)","v":0},null,null,{"$f":"SUMIFS(R100:R128,$I$100:$I$128,\"<\"&'Simple Configurator for Install'!$K$69)","v":0}]
[]
[]
[null,null,null,null,null,null,null,"Maximum number of allowed devices:",null,null,{"$f":"MIN(COUNTIF(W100:W128,\"<\"&'Simple Configurator for Install'!$J$73),COUNTIF(AD100:AD128,\"<\"&'Simple Configurator for Install'!K$73))","v":18}]
[null,null,null,null,null,null,null,"Total cable length (meters):",null,null,{"$f":"(K132-1)*K94+K92","v":134},"m"]
[null,null,null,null,null,null,null,"Total diode voltage drop:",null,null,{"$f":"K132*L100","v":3.6},"V"]
[null,null,null,null,null,null,null,"Total cable voltage drop:",null,null,{"$f":"SUM(_xlfn.TAKE($O$100:$O$128,$K$132-1))+SUM(_xlfn.TAKE($AC$100:$AC$128,$K$132))-SUM(_xlfn.TAKE($AC$100:$AC$128,$K$132-1))","v":1.6141170643938292},"V"]
[null,null,null,null,null,null,null,"Total diode power dissipation:",null,null,{"$f":"SUM(_xlfn.TAKE($Q$100:$Q$128,$K$132-1))+SUM(_xlfn.TAKE($AE$100:$AE$128,$K$132))-SUM(_xlfn.TAKE($AE$100:$AE$128,$K$132-1))","v":2.0133578241235806},"W"]
[null,null,null,null,null,null,null,"Total cable power dissipation:",null,null,{"$f":"SUM(_xlfn.TAKE($R$100:$R$128,$K$132-1))+SUM(_xlfn.TAKE($AF$100:$AF$128,$K$132))-SUM(_xlfn.TAKE($AF$100:$AF$128,$K$132-1))","v":1.6043131792156249},"W"]
[null,null,null,null,null,null,null,"Total power delivered by the PSE:",null,null,{"$f":"INDEX(V100:AH128,K132,9)","v":57.617671003339161},"W"]