{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["D-Cerno","Parameters","Settings D-Cerno"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"D-Cerno","index":0,"n_rows":60,"n_cols":22,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Legend"]
["User input from dropdown"]
["Number of units on a port"]
["Length input in meters"]
["Optional, free format"]
["Pre-defined, do not alter"]
["Calculated, do not alter"]
[]
["Total power at 48 V"]
[{"$f":"SUM(Q17:Q60)","v":161.40904632605495},"[W]"]
["Total number of devices"]
[{"$f":"SUM(F17:F60)","v":70}]
["Calculator iterations"]
[21,null,"Port","Name","Devices per port",null,null,"Cabling to first device",null,null,"Cabling between devices",null,null,"Power",null,null,null,"Current",null,"Voltage"]
[null,null,null,null,"Type","Number","Power","Type","Length","Resistance","Type","Length","Resistance","Devices","Cable","Total","Supply","Port","Supply","Port","First device","Last device"]
[null,null,null,null,"[]","[]","[W]","[AWG]","[m]","[Ohm/m]","[AWG]","[m]","[Ohm/m]","[W]","[W]","[W]","[W]","[A]","[A]","[V]","[V]","[V]"]
["CENTRAL UNIT",null,1,null,"D-Cerno SL",20,{"$f":"VLOOKUP(E17,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",10,{"$f":"VLOOKUP(H17,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K17,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},40,1.3852199329785364,41.385219932978536,{"$f":"IF(SUM(P17:P20)=0,\"\",SUM(P17:P20)+'Settings D-Cerno'!$C$7)","v":114.0907609026851},0.86219208193705288,{"$f":"IF(Q17=\"\",\"\",Q17/48)","v":2.3768908521392729},48,47.273861828592615,45.946427548856796]
[null,null,2,null,"D-Cerno SL",10,{"$f":"VLOOKUP(E18,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",10,{"$f":"VLOOKUP(H18,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K18,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},20,0.23518032323552163,20.235180323235522,null,0.42156625673407339,null,48,47.644956898578563,47.33211736387176]
[null,null,3,null,"D-Cerno SL",10,{"$f":"VLOOKUP(E19,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",10,{"$f":"VLOOKUP(H19,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K19,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},20,0.23518032323552163,20.235180323235522,null,0.42156625673407339,null,48,47.644956898578563,47.33211736387176]
[null,null,4,null,"D-Cerno SL",10,{"$f":"VLOOKUP(E20,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",10,{"$f":"VLOOKUP(H20,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K20,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},20,0.23518032323552163,20.235180323235522,null,0.42156625673407339,null,48,47.644956898578563,47.33211736387176]
["NETWORK EXTENDER",1,1,null,"D-Cerno SL",10,{"$f":"VLOOKUP(E21,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",5,{"$f":"VLOOKUP(H21,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K21,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},20,0.15914271168492178,20.159142711684922,{"$f":"IF(SUM(P21:P24)=0,\"\",SUM(P21:P24)+'Settings D-Cerno'!$C$8)","v":47.318285423369844},0.41998213982676924,{"$f":"IF(Q21=\"\",\"\",Q21/48)","v":0.98579761298687174},48,47.823145520918949,47.511469978423669]
[null,null,2,null,"D-Cerno SL",10,{"$f":"VLOOKUP(E22,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",5,{"$f":"VLOOKUP(H22,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K22,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},20,0.15914271168492178,20.159142711684922,null,0.41998213982676924,null,48,47.823145520918949,47.511469978423669]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E23,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H23,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K23,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E24,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H24,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K24,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",2,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E25,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H25,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K25,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P25:P28)=0,\"\",SUM(P25:P28)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q25=\"\",\"\",Q25/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E26,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H26,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K26,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E27,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H27,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K27,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E28,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H28,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K28,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",3,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E29,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H29,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K29,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P29:P32)=0,\"\",SUM(P29:P32)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q29=\"\",\"\",Q29/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E30,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H30,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K30,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E31,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H31,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K31,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E32,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H32,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K32,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",4,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E33,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H33,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K33,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P33:P36)=0,\"\",SUM(P33:P36)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q33=\"\",\"\",Q33/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E34,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H34,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K34,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E35,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H35,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K35,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E36,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H36,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K36,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",5,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E37,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H37,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K37,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P37:P40)=0,\"\",SUM(P37:P40)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q37=\"\",\"\",Q37/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E38,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H38,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K38,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E39,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H39,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K39,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E40,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H40,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K40,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",6,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E41,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H41,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K41,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P41:P44)=0,\"\",SUM(P41:P44)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q41=\"\",\"\",Q41/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E42,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H42,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K42,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E43,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H43,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K43,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E44,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H44,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K44,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",7,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E45,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H45,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K45,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P45:P48)=0,\"\",SUM(P45:P48)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q45=\"\",\"\",Q45/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E46,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H46,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K46,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E47,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H47,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K47,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E48,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H48,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K48,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",8,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E49,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H49,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K49,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P49:P52)=0,\"\",SUM(P49:P52)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q49=\"\",\"\",Q49/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E50,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H50,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K50,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E51,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H51,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K51,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E52,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H52,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K52,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",9,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E53,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H53,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K53,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P53:P56)=0,\"\",SUM(P53:P56)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q53=\"\",\"\",Q53/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E54,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H54,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K54,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E55,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H55,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K55,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E56,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H56,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K56,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
["NETWORK EXTENDER",10,1,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E57,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H57,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K57,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},null,null,null,{"$f":"IF(SUM(P57:P60)=0,\"\",SUM(P57:P60)+'Settings D-Cerno'!$C$8)","v":""},null,{"$f":"IF(Q57=\"\",\"\",Q57/48)","v":""}]
[null,null,2,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E58,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H58,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K58,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,3,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E59,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H59,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K59,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]
[null,null,4,null,"D-Cerno SL",0,{"$f":"VLOOKUP(E60,Parameters!$E$4:$F$7,2,FALSE)","v":2},"24 (standard)",2,{"$f":"VLOOKUP(H60,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2},"24 (standard)",2,{"$f":"VLOOKUP(K60,Parameters!$H$4:$I$15,2,FALSE)","v":8.4220000000000003E-2}]

{"sheet":"Parameters","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Device power consumption (from datasheet)",null,null,null," Selectable devices",null,null,"Selectable wire"]
["Part number","Device type","Device power",null,"Device type","Device power",null,"AWG number","AWG resistance"]
["[-]","[-]","[W]",null,"[-]","[W]",null,"[-]","[Ohm/1m]"]
["71.98.0306","D-Cerno D SL",2,null,"D-Cerno SL",2,null,"21",4.2000000000000003E-2]
["71.98.0307","D-Cerno C SL",2,null,"D-Cerno F-M",2,null,"22",5.296E-2]
["71.98.0311","D-Cerno F-DM",2,null,"D-Cerno F-D",2,null,"23",6.6790000000000002E-2]
["71.98.0312","D-Cerno F-CM",2,null,"D-Cerno DECIDE",3.6,null,"24 (standard)",8.4220000000000003E-2]
["71.98.0313","D-Cerno F-DD",2,null,null,null,null,"25",0.1062]
["71.98.0314","D-Cerno F-CD",2,null,null,null,null,"26 (patch)",0.13389999999999999]
[null,null,null,null,null,null,null,"27",0.16889999999999999]
[null,null,null,null,null,null,null,"28",0.21290000000000001]

{"sheet":"Settings D-Cerno","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Item","Sub item","Value","Unit","Reference"]
["calculator algorithm","maximum number of iterations",5000,"-"]
[null,"precision",5.0000000000000001E-3,"-"]
["power supply","voltage",48,"V","fixed 48 V from adapter"]
[null,"maximum current",4.4000000000000004,"A","specification adapter"]
[null,"maximum power",{"$f":"C4*C5","v":211.20000000000002},"W","calculated from voltage x current"]
["power consumption","central unit AE",12,"W","measured 5 Watt, further TBD by R&D"]
[null,"NEXT",7,"W","datasheet"]
["start cable length","minimum",1,"m","arbitrary minimum"]
[null,"maximum",80,"m","LVDS maximum length"]
["cable length between devices","minimum",1,"m","arbitrary minimum"]
[null,"maximum",80,"m","LVDS maximum length"]
["voltage limit","end of branch",36,"V","DC-DC converter and branch stability"]
["current limit","port limit",2,"A","connector and protection circuit"]
["number of devices","per port",25,"-","LVDS eye pattern"]
[null,"maximum in system",250,"-","software and sales"]