{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Plixus powered","Externally powered","devices","parameters","settings"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":7,"comments":3,"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":"Plixus powered","index":0,"n_rows":89,"n_cols":25,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
["Plixus power calculator - Plixus powered devices << Version 1.12 - VALID FROM 14/10/2022 UNTIL 01/06/2023 >>"]
[]
["Legend","user may enter any value"]
[null,"user must select a predefined value"]
[null,"user may not alter this value"]
[null,"calculated result"]
[null,"very important calculated result"]
[null,"result outside limits"]
[]
["Power supply voltage",null,null,null,48,"[V]",null,null,null,null,"Power supply power",null,null,275.15145614900911,"[W]"]
["Number of network extenders used",null,null,null,8,null,null,null,null,null,"Power supply current",null,null,5.7323220031043567,"[A]"]
[null,null,null,null,1]
["Network extender\nPower cabling",null,null,null,"Branch",null,"Device",null,null,"Cabling NE to first device\nPlixus cabling",null,null,null,"Cabling between devices\nPlixus cabling",null,null,null,"Calculated results"]
["Index","Cable","Length","Port","Name","Voltage","Type","Power","Number of","Length","AWG","Ohm/m","Wiring type","Length","AWG","Ohm/m","invalid","#iter","P device(s)","P branch","I start","U first device","U last device","Cable loss"]
["[-]","[mm2]","[m]","[-]",null,"[V]","[-]","[W]","[-]","[m]","[-]","[Ohm]","[-]","[m]","[-]","[Ohm]","[-]","[-]","[W]","[W]","[A]","[V]","[V]","[W]"]
[1,1.5,20,1,"loop 1a",45.431919742609246,"uniCOS T/MM10 2xUSB",{"$f":"VLOOKUP(G16,parameters!$D$4:$E$24,2,FALSE)","v":17.5},5,40,"24 STANDARD",{"$f":"VLOOKUP(K16,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,3,"24 STANDARD",{"$f":"VLOOKUP(O16,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},"invalid",19,87.5,108.36920773360993,2.38530989550005,37.397069245165873,36.32006611315375,20.869207733609926]
[null,null,null,2,"loop 2a",45.432701221126443,"Confidea FLEX",{"$f":"VLOOKUP(G17,parameters!$D$4:$E$24,2,FALSE)","v":6},0,30,"24 STANDARD",{"$f":"VLOOKUP(K17,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"26 PATCH",{"$f":"VLOOKUP(O17,parameters!$G$4:$H$15,2,FALSE)","v":0.13389999999999999}]
[null,"[Ohm/m]",null,3,"loop 3a",45.433757430469647,"Lingua ID / ID-MM",{"$f":"VLOOKUP(G18,parameters!$D$4:$E$24,2,FALSE)","v":11},5,25,"24 STANDARD",{"$f":"VLOOKUP(K18,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,3,"28",{"$f":"VLOOKUP(O18,parameters!$G$4:$H$15,2,FALSE)","v":0.21290000000000001},null,null,55,60.014299813888748,1.3209187002799117,42.65401437873038,41.132885480899766,5.0142998138887478]
[null,{"$f":"VLOOKUP(B16,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2},null,4,"loop 4a",45.435208702169732,"Lingua ID / ID-MM",{"$f":"VLOOKUP(G19,parameters!$D$4:$E$24,2,FALSE)","v":11},0,50,"24 STANDARD",{"$f":"VLOOKUP(K19,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,3,"24 STANDARD",{"$f":"VLOOKUP(O19,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[2,2.5,1,1,"loop 1b",45.41235276216063,"Confidea FLEX",{"$f":"VLOOKUP(G20,parameters!$D$4:$E$24,2,FALSE)","v":6},4,50,"24 STANDARD",{"$f":"VLOOKUP(K20,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O20,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,24,25.346561020393217,0.55814243215147785,43.064757505459887,42.9571308594168,1.3465610203932172]
[null,null,null,2,"loop 2b",45.415095287249763,"Confidea FLEX",{"$f":"VLOOKUP(G21,parameters!$D$4:$E$24,2,FALSE)","v":6},4,50,"24 STANDARD",{"$f":"VLOOKUP(K21,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O21,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,24,25.340545609126956,0.55797627306181796,43.069119053409352,42.967142443733508,1.3405456091269556]
[null,"[Ohm/m]",null,3,"loop 3b",45.418757139272671,"Confidea FLEX",{"$f":"VLOOKUP(G22,parameters!$D$4:$E$24,2,FALSE)","v":6},4,50,"24 STANDARD",{"$f":"VLOOKUP(K22,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O22,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,24,25.33173029064832,0.55773719683633727,43.074700838796929,42.982357735749027,1.3317302906483199]
[null,{"$f":"VLOOKUP(B20,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 4b",45.423332174674748,"Confidea FLEX",{"$f":"VLOOKUP(G23,parameters!$D$4:$E$24,2,FALSE)","v":6},0,50,"24 STANDARD",{"$f":"VLOOKUP(K23,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O23,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[3,2.5,null,1,"loop 5a",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G24,parameters!$D$4:$E$24,2,FALSE)","v":13.8},3,50,"24 STANDARD",{"$f":"VLOOKUP(K24,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O24,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 6a",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G25,parameters!$D$4:$E$24,2,FALSE)","v":13.8},3,50,"24 STANDARD",{"$f":"VLOOKUP(K25,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O25,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 7a",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G26,parameters!$D$4:$E$24,2,FALSE)","v":13.8},3,50,"24 STANDARD",{"$f":"VLOOKUP(K26,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O26,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B24,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 7b",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G27,parameters!$D$4:$E$24,2,FALSE)","v":13.8},4,50,"24 STANDARD",{"$f":"VLOOKUP(K27,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O27,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[4,2.5,null,1,"loop 5b",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G28,parameters!$D$4:$E$24,2,FALSE)","v":13.8},4,50,"24 STANDARD",{"$f":"VLOOKUP(K28,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O28,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 6b",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G29,parameters!$D$4:$E$24,2,FALSE)","v":13.8},4,50,"24 STANDARD",{"$f":"VLOOKUP(K29,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O29,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 7b",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G30,parameters!$D$4:$E$24,2,FALSE)","v":13.8},4,50,"24 STANDARD",{"$f":"VLOOKUP(K30,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O30,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B28,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 8b",null,"uniBOX 2xUSB",{"$f":"VLOOKUP(G31,parameters!$D$4:$E$24,2,FALSE)","v":13.8},2,50,"24 STANDARD",{"$f":"VLOOKUP(K31,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O31,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[5,2.5,null,1,"loop 9a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G32,parameters!$D$4:$E$24,2,FALSE)","v":4.8},5,20,"24 STANDARD",{"$f":"VLOOKUP(K32,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O32,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 10a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G33,parameters!$D$4:$E$24,2,FALSE)","v":4.8},5,20,"24 STANDARD",{"$f":"VLOOKUP(K33,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O33,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 11a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G34,parameters!$D$4:$E$24,2,FALSE)","v":4.8},5,20,"24 STANDARD",{"$f":"VLOOKUP(K34,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O34,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B32,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 12a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G35,parameters!$D$4:$E$24,2,FALSE)","v":4.8},5,20,"24 STANDARD",{"$f":"VLOOKUP(K35,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O35,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[6,2.5,null,1,"loop 9b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G36,parameters!$D$4:$E$24,2,FALSE)","v":4.8},5,20,"24 STANDARD",{"$f":"VLOOKUP(K36,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,2,"24 STANDARD",{"$f":"VLOOKUP(O36,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 10b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G37,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K37,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O37,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 11b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G38,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K38,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O38,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B36,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 12b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G39,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K39,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O39,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[7,2.5,null,1,"loop 13a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G40,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K40,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O40,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 14a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G41,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K41,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O41,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 15a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G42,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K42,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O42,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B40,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 16a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G43,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K43,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O43,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[8,2.5,null,1,"loop 13b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G44,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K44,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O44,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 14b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G45,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K45,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O45,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 15b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G46,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K46,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O46,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B44,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,4,"loop 16b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G47,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K47,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O47,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[9,1.5,null,1,"loop 17a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G48,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K48,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O48,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 18a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G49,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K49,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O49,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 19a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G50,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K50,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O50,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B48,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2},null,4,"loop 20a",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G51,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K51,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O51,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[10,1.5,null,1,"loop 17b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G52,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K52,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O52,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,null,2,"loop 18b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G53,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K53,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O53,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,"[Ohm/m]",null,3,"loop 19b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G54,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K54,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O54,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,{"$f":"VLOOKUP(B52,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2},null,4,"loop 20b",null,"Confidea F-DV/F-DI",{"$f":"VLOOKUP(G55,parameters!$D$4:$E$24,2,FALSE)","v":4.8},0,20,"24 STANDARD",{"$f":"VLOOKUP(K55,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2},null,null,"24 STANDARD",{"$f":"VLOOKUP(O55,parameters!$G$4:$H$15,2,FALSE)","v":8.4220000000000003E-2}]
[]
[]
["Results check"]
[]
[null,"Power consumed by interfaces",null,null,null,{"$f":"SUM(T16:T55)","v":244.40234446766718},"[W]"]
[]
[null,"Current drawn by network extender 1",null,null,null,{"$f":"SUM(U16:U19)","v":3.7062285957799617},"[A]","Input voltage network extender",null,null,{"$f":"F16","v":45.431919742609246},"[V]",null,"Network extender own current",null,null,null,{"$f":"IF((K62=0),0,settings!$B$6/'Plixus powered'!K62)","v":0.17608765038596944},"[A]","Total current",{"$f":"F62+R62","v":3.8823162461659311},"[A]"]
[null,"Current drawn by network extender 2",null,null,null,{"$f":"SUM(U20:U23)","v":1.6738559020496333},"[A]",null,null,null,{"$f":"F20","v":45.41235276216063},"[V]",null,null,null,null,null,{"$f":"IF((K63=0),0,settings!$B$6/'Plixus powered'!K63)","v":0.17616352189234988},"[A]",null,{"$f":"F63+R63","v":1.8500194239419832},"[A]"]
[null,"Current drawn by network extender 3",null,null,null,{"$f":"SUM(U24:U27)","v":0},"[A]",null,null,null,{"$f":"F24","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K64=0),0,settings!$B$6/'Plixus powered'!K64)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 4",null,null,null,{"$f":"SUM(U28:U31)","v":0},"[A]",null,null,null,{"$f":"F28","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K65=0),0,settings!$B$6/'Plixus powered'!K65)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 5",null,null,null,{"$f":"SUM(U32:U35)","v":0},"[A]",null,null,null,{"$f":"F32","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K66=0),0,settings!$B$6/'Plixus powered'!K66)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 6",null,null,null,{"$f":"SUM(U36:U39)","v":0},"[A]",null,null,null,{"$f":"F36","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K67=0),0,settings!$B$6/'Plixus powered'!K67)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 7",null,null,null,{"$f":"SUM(U40:U43)","v":0},"[A]",null,null,null,{"$f":"F40","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K68=0),0,settings!$B$6/'Plixus powered'!K68)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 8",null,null,null,{"$f":"SUM(U44:U47)","v":0},"[A]",null,null,null,{"$f":"F44","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K69=0),0,settings!$B$6/'Plixus powered'!K69)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 9",null,null,null,{"$f":"SUM(U48:U51)","v":0},"[A]",null,null,null,{"$f":"F48","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K70=0),0,settings!$B$6/'Plixus powered'!K70)","v":0},"[A]",null,0,"[A]"]
[null,"Current drawn by network extender 10",null,null,null,{"$f":"SUM(U52:U55)","v":0},"[A]",null,null,null,{"$f":"F52","v":0},"[V]",null,null,null,null,null,{"$f":"IF((K71=0),0,settings!$B$6/'Plixus powered'!K71)","v":0},"[A]",null,0,"[A]"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"length check [m]"]
[null,"Current to splitter 1",null,null,null,{"$f":"SUM(U62:U71)","v":5.732335670107914},"[A]","Voltage over line to splitter 1",null,null,{"$f":"E10-F16","v":2.5680802573907542},"[V]",null,"Cable power loss",null,null,null,{"$f":"F73*K73","v":14.721098063140934},"[W]","Resistance",{"$f":"IF(F73=0,0,K73/F73)","v":0.44799893188083467},"[Ohm]",{"$f":"U73/B19/2","v":19.99995231610869},"must be",{"$f":"C16","v":20}]
[null,"Current to splitter 2",null,null,null,{"$f":"SUM(U63:U71)","v":1.8500194239419832},"[A]","Voltage over line to splitter 2",null,null,{"$f":"F16-F20","v":1.9566980448615823E-2},"[V]",null,null,null,null,null,{"$f":"F74*K74","v":3.6199293897832288E-2},"[W]",null,{"$f":"IF(F74=0,0,K74/F74)","v":1.0576635139820805E-2},"[Ohm]",{"$f":"U74/B23/2","v":0.78695201933190506},null,{"$f":"C20","v":1}]
[null,"Current to splitter 3",null,null,null,{"$f":"SUM(U64:U71)","v":0},"[A]","Voltage over line to splitter 3",null,null,{"$f":"F20-F24","v":45.41235276216063},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U75/B27/2","v":0},null,{"$f":"C24","v":0}]
[null,"Current to splitter 4",null,null,null,{"$f":"SUM(U65:U71)","v":0},"[A]","Voltage over line to splitter 4",null,null,{"$f":"F24-F28","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U76/B31/2","v":0},null,{"$f":"C28","v":0}]
[null,"Current to splitter 5",null,null,null,{"$f":"SUM(U66:U71)","v":0},"[A]","Voltage over line to splitter 5",null,null,{"$f":"F28-F32","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U77/B35/2","v":0},null,{"$f":"C32","v":0}]
[null,"Current to splitter 6",null,null,null,{"$f":"SUM(U67:U71)","v":0},"[A]","Voltage over line to splitter 6",null,null,{"$f":"F32-F36","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U78/B39/2","v":0},null,{"$f":"C36","v":0}]
[null,"Current to splitter 7",null,null,null,{"$f":"SUM(U68:U71)","v":0},"[A]","Voltage over line to splitter 7",null,null,{"$f":"F36-F40","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U79/B43/2","v":0},null,{"$f":"C40","v":0}]
[null,"Current to splitter 8",null,null,null,{"$f":"SUM(U69:U71)","v":0},"[A]","Voltage over line to splitter 8",null,null,{"$f":"F40-F44","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U80/B47/2","v":0},null,{"$f":"C44","v":0}]
[null,"Current to splitter 9",null,null,null,{"$f":"SUM(U70:U71)","v":0},"[A]","Voltage over line to splitter 9",null,null,{"$f":"F44-F48","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U81/B51/2","v":0},null,{"$f":"C48","v":0}]
[null,"Current to splitter 10",null,null,null,{"$f":"SUM(U71)","v":0},"[A]","Voltage over line to splitter 10",null,null,{"$f":"F48-F52","v":0},"[V]",null,null,null,null,null,0,"[W]",null,0,"[Ohm]",{"$f":"U82/B55/2","v":0},null,{"$f":"C52","v":0}]
[]
[null,"Sum cable loss power distribution",null,null,null,{"$f":"SUM(R73:R82)","v":14.757297357038766},"[W]"]
[]
[null,"Power consumed by network extenders",null,null,null,{"$f":"settings!$B$6*'Plixus powered'!E11","v":64},"[W]"]
[]
[null,"Total power power supply verification",null,null,null,{"$f":"F60+F84+F86","v":323.15964182470594},"[W]"]
[null,"Total power power supply calculation",null,null,null,{"$f":"N10","v":275.15145614900911},"[W]"]

{"sheet":"Externally powered","index":1,"n_rows":21,"n_cols":24,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Plixus power calculator - Externally powered devices << Version 1.12 - VALID FROM 14/10/2022 UNTIL 01/06/2023 >>"]
[]
["Legend","user may enter any value"]
[null,"user must select a predefined value"]
[null,"user may not alter this value"]
[null,"calculated result"]
[null,"very important calculated result"]
[null,"result outside limits"]
[]
["Power supply voltage",null,null,null,48,"[V]",null,null,null,null,"Power supply power",null,null,511.39136506403156,"[W]"]
["Number of power branches",null,null,null,2,null,null,null,null,null,"Power supply current",null,null,10.653986772167324,"[A]"]
[]
["PS5500\nPower cabling",null,null,null,"Power branch",null,"Device",null,null,"Cabling PS5500 to first device\nPower cabling",null,null,null,"Cabling between devices\nPower cabling",null,null,null,"Calculated results"]
["Port",null,null,null,"Name","Voltage","Type","Power","Number of","Length","Cable","Ohm/m","Wiring type","Length","Section (mm²)","Ohm/m","invalid","#iter","P device(s)","P branch","I start","U first device","U last device","Cable loss"]
["[-]",null,null,null,null,"[V]","[-]","[W]","[-]","[m]","[-]","[Ohm]","[-]","[m]","[-]","[Ohm]","[-]","[-]","[W]","[W]","[A]","[V]","[V]","[W]"]
[1,null,null,null,"no name",{"$f":"E$10","v":48},"uniCOS F/MM7 1xUSB",{"$f":"VLOOKUP(G16,parameters!$R$4:$S$15,2,FALSE)","v":12},20,30,2.5,{"$f":"VLOOKUP(K16,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,2,2.5,{"$f":"VLOOKUP(O16,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},"invalid",21,240,255.69568253201578,5.3269933860836618,45.852156266731065,44.679310787906509,15.69568253201578]
[2,null,null,null,"no name",48,"uniCOS F/MM7 1xUSB",{"$f":"VLOOKUP(G17,parameters!$R$4:$S$15,2,FALSE)","v":12},20,30,2.5,{"$f":"VLOOKUP(K17,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,2,2.5,{"$f":"VLOOKUP(O17,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,null,240,255.69568253201578,5.3269933860836618,45.852156266731065,44.679310787906509,15.69568253201578]
[3,null,null,null,"no name",48,"uniCOS F/MM7 1xUSB",{"$f":"VLOOKUP(G18,parameters!$R$4:$S$15,2,FALSE)","v":12},null,null,2.5,{"$f":"VLOOKUP(K18,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,null,2.5,{"$f":"VLOOKUP(O18,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3}]
[4,null,null,null,"no name",48,"uniCOS F/MM7 1xUSB",{"$f":"VLOOKUP(G19,parameters!$R$4:$S$15,2,FALSE)","v":12},null,null,2.5,{"$f":"VLOOKUP(K19,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3},null,null,2.5,{"$f":"VLOOKUP(O19,parameters!$M$4:$N$15,2,FALSE)","v":6.7200000000000003E-3}]
[5,null,null,null,"no name",48,"uniCOS F/MM7 1xUSB",{"$f":"VLOOKUP(G20,parameters!$R$4:$S$15,2,FALSE)","v":12},null,null,1.5,{"$f":"VLOOKUP(K20,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2},null,null,1.5,{"$f":"VLOOKUP(O20,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2}]
[6,null,null,null,"no name",48,"uniCOS F/MM7 1xUSB",{"$f":"VLOOKUP(G21,parameters!$R$4:$S$15,2,FALSE)","v":12},null,null,1.5,{"$f":"VLOOKUP(K21,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2},null,null,1.5,{"$f":"VLOOKUP(O21,parameters!$M$4:$N$15,2,FALSE)","v":1.12E-2}]

{"sheet":"devices","index":2,"n_rows":56,"n_cols":23,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["Flush mount multimedia","FMM","71.98.2000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Flush mount audio","F-CM","71.98.0515",null,null,"F-CD","71.98.0511",null,null,"F-CV","71.98.0512",null,null,"F-CI","71.98.0513",null,null,"F-CIV","71.98.0514",null,null,"F-CS","71.98.0551"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"F-DM","71.98.0505",null,null,"F-DD","71.98.0501",null,null,"F-DV","71.98.0502",null,null,"F-DI","71.98.0503",null,null,"F-DIV","71.98.0504"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Table top audio",null,null,null,null,"T-CD","71.98.0115",null,null,"T-CV","71.98.0116",null,null,"T-CI","71.98.0117",null,null,"T-CIV","71.98.0118"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"T-DD","71.98.0105",null,null,"T-DV","71.98.0106",null,null,"T-DI","71.98.0107",null,null,"T-DIV","71.98.0108"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Interpreter desk","ID","71.98.2100"]

{"sheet":"parameters","index":3,"n_rows":40,"n_cols":21,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Device power consumption",null,null," Selectable devices",null,null,"Selectable wire",null,null,"Cabling",null,null,"Selectable power wire",null,null,"Number of network extenders",null," Selectable devices F/MM",null,null,"Number of network extenders"]
["Device type","Device power",null,"Device type","Device power",null,"AWG number","AWG resistance",null,"Wiring type",null,null,"Section","Resistance",null,null,null,"Device type","Device power"]
["[-]","[W]",null,"[-]","[W]",null,"[-]","[Ohm/1m]",null,"[-]",null,null,"[mm2]","[Ohm/1m]",null,null,null,"[-]","[W]"]
["F-CM",3.3,null,"Confidea F-DM",3,null,"21",4.2000000000000003E-2,null,null,null,null,0.75,{"$f":"settings!$B$7/(parameters!M4/1000000)","v":2.24E-2},null,1,null,"uniCOS F/MM7 1xUSB",12,null,1]
["F-DM",2.8,null,"Confidea F-DD",3.8,null,"22",5.296E-2,null,null,null,null,1,{"$f":"settings!$B$7/(parameters!M5/1000000)","v":1.6800000000000002E-2},null,2,null,"uniCOS F/MM7 2xUSB",14.5,null,2]
["F-CD",4.0999999999999996,null,"Confidea F-DV/F-DI",4.8,null,"23",6.6790000000000002E-2,null,null,null,null,1.5,{"$f":"settings!$B$7/(parameters!M6/1000000)","v":1.12E-2},null,3,null,"uniCOS F/MM10 1xUSB",15,null,3]
["F-DD",3.6,null,"Confidea F-DIV",5.3,null,"24 STANDARD",8.4220000000000003E-2,null,null,null,null,2.5,{"$f":"settings!$B$7/(parameters!M7/1000000)","v":6.7200000000000003E-3},null,4,null,"uniCOS F/MM10 2xUSB",17.5,null,4]
["F-CV",5,null,"Confidea F-CS",2.1,null,"25",0.1062,null,null,null,null,4,{"$f":"settings!$B$7/(parameters!M8/1000000)","v":4.2000000000000006E-3},null,5,null,"uniCOS T/MM10 1xUSB",15,null,5]
["F-DV",4.5,null,"Confidea T-DD/T-CD",3.7,null,"26 PATCH",0.13389999999999999,null,null,null,null,null,null,null,6,null,"uniCOS T/MM10 2xUSB",17.5,null,6]
["F-CI",4.5999999999999996,null,"Confidea FLEX",6,null,"27",0.16889999999999999,null,null,null,null,null,null,null,7,null,"uniBOX 1xUSB",11.3]
["F-DI",4,null,"Lingua ID / ID-MM",11,null,"28",0.21290000000000001,null,null,null,null,null,null,null,8,null,"uniBOX 2xUSB",13.8]
["F-CIV",5.5,null,"Plixus V-IN",6,null,null,null,null,null,null,null,null,null,null,9]
["F-DIV",5.0999999999999996,null,"Plixus V-OUT",5.5,null,null,null,null,null,null,null,null,null,null,10]
["F-CS",2.1,null,"WCAP G4",15]
["T-CD",3.7,null,"Plixus NP",5]
["T-DD",3.5,null,"uniCOS F/MM7 1xUSB",12]
["T-CV",5.4,null,"uniCOS F/MM7 2xUSB",14.5]
["T-DV",5.2,null,"uniCOS F/MM10 1xUSB",15]
["T-CI",3.8,null,"uniCOS F/MM10 2xUSB",17.5]
["T-DI",3.7,null,"uniCOS T/MM10 1xUSB",15]
["T-CIV",5.6,null,"uniCOS T/MM10 2xUSB",17.5]
["T-DIV",5.4,null,"uniBOX 1xUSB",11.3]
["FLEX",6,null,"uniBOX 2xUSB",13.8]
["ID",11,null,"F-BOX",5.3]
["ID-MM",11]
["FLEX",6]
["Plixus V-IN",6]
["Plixus V-OUT",5.5]
["Plixus NP",5]
["WCAP G3",10]
["WCAP G4",15]
["uniCOS F/MM7 1xUSB",12]
["uniCOS F/MM7 2xUSB",14.5]
["uniCOS F/MM10 1xUSB",15]
["uniCOS F/MM10 2xUSB",17.5]
["uniCOS T/MM10 1xUSB",15]
["uniCOS T/MM10 2xUSB",17.5]
["uniBOX 1xUSB",11.3]
["uniBOX 2xUSB",13.8]
["F-BOX",5]

{"sheet":"settings","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Maximum number of iterations",5000]
["Calculator precision",5.0000000000000001E-3]
["Voltage too low warning",36,"[V]"]
["Maximum branch current",2,"[A]"]
["Maximum length start cable",100,"[m]"]
["Splitter power consumption",8,"[W]","valid for version 2 of network extender"]
["Rho copper",1.6800000000000002E-8,"[Ohm.m]"]
[]
["Max power supply current per port",16.001000000000001,"[A]","limited by WAGO connector"]
["Max power supply power per port",{"$f":"B9*'Plixus powered'!E10","v":768.048},"[W]","limited by max current multiplied with power supply voltage"]
["Power supply voltage",{"$f":"'Plixus powered'!E10","v":48},"[V]","value defined in 'calculator' tab page, do not alter it here"]
[]
["Max power supply total current",21,"[A]"]
["Max power supply total power",{"$f":"48*B13","v":1008},"[W]"]
[]
["NE voltage too low warning",42,"[V]","power good issue when NEXT input voltage is lower than 41 V (read back FPGA, ports disabled)"]