{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Intro","Calculate","Revision history"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":true,"merged":[[20,7,20,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"]
["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"]
["DCNM-DSL",3.6,"Watt"]
["DCNM-DVT",3.7,"Watt"]
["DCNM-D",3.1,"Watt"]
["DCNM-IDESK",15,"Watt"]
["DCNM-IDESKVID",18,"Watt"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"A maximum of 22 nodes can be daisy-chained in the system this inlcudes all switches"]
[]
[]
[]
[]
["Node#","Cable length","meters","Cable resistance","Ohm",null,"V",null,"Watt",null,"Iload (mA)",null,"In (A)"]
[null,"L0",80,"R0",{"$f":"2*($B$7/1000)*C37+ 4*$B$6/1000","v":3.7199999999999998},"U0",{"$f":"B2-(B3*E37)","v":36.840000000000003},"P0",{"$f":"M37^2*E37","v":33.479999999999997},null,null,"I0",{"$f":"$B$3","v":3}]
[1,"L1",{"$f":"$B$5","v":2},"R1",0.13200000000000001,"U1",{"$f":"G37-(M37*E38)","v":36.444000000000003},"P1",{"$f":"$B$9","v":11.3},"Ip1",{"$f":"(I38/G38)*1000","v":310.06475688727915},"I1",{"$f":"$B$3","v":3}]
[2,"L2",2,"R2",0.13200000000000001,"U2",36.048000000000002,"P2",11.3,"Ip2",313.47092765201955,"I2",{"$f":"M38-K38/1000","v":2.6899352431127208}]
[3,"L3",2,"R3",0.13200000000000001,"U3",{"$f":"G39-(M39*E40)","v":35.692928547909119},"P3",11.3,"Ip3",316.58932062222033,"I3",2.3764643154607015]
[4,"L4",2,"R4",0.13200000000000001,"U4",35.379235258268309,"P4",11.3,"Ip4",319.39638936540132,"I4",2.0598749948384811]
[5,"L5",2,"R5",0.13200000000000001,"U5",35.107331758949627,"P5",11.3,"Ip5",321.87008906250423,"I5",1.7404786054730799]
[6,"L6",2,"R6",0.13200000000000001,"U6",34.877588583027183,"P6",11.3,"Ip6",323.99028886701842,"I6",1.4186085164105755]
[7,"L7",2,"R7",0.13200000000000001,"U7",34.690332258860984,"P7",11.3,"Ip7",325.73916893268239,"I7",1.094618227543557]
[8,"L8",2,"R8",0.13200000000000001,"U8",34.545842652825236,"P8",11.3,"Ip8",327.10158827391814,"I8",0.76887905861087458]
[9,"L9",2,"R9",0.13200000000000001,"U9",34.444350617088602,"P9",11.3,"Ip9",328.0654097857726,"I9",0.44177747033695641]
[10,"L10",2,"R10",0.13200000000000001,"U10",34.386035991004121,"P10",11.3,"Ip10",328.6217696903546,"I10",0.11371206055118382]
[11,"L11",2,"R11",0.13200000000000001,"U11",34.371025999011366,"P11",11.3,"Ip11",328.76528039416189,"I11",-0.21490970913917079]
[12,"L12",2,"R12",0.13200000000000001,"U12",34.399394080617739,"P12",11.3,"Ip12",328.49415816794755,"I12",-0.54367498953333271]
[13,"L13",2,"R13",0.13200000000000001,"U13",34.471159179236139,"P13",11.3,"Ip13",327.81027006502893,"I13",-0.87216914770128029]
[14,"L14",2,"R14",0.13200000000000001,"U14",34.586285506732708,"P14",11.3,"Ip14",326.71909788636589,"I14",-1.1999794177663092]
[15,"L15",2,"R15",0.13200000000000001,"U15",34.744682789877864,"P15",11.3,"Ip15",325.22962055339354,"I15",-1.5266985156526751]
[16,"L16",2,"R16",0.13200000000000001,"U16",34.946206993944017,"P16",11.3,"Ip16",323.3541197177201,"I16",-1.8519281362060687]
[17,"L17",2,"R17",0.13200000000000001,"U17",35.190661507923217,"P17",11.3,"Ip17",321.10791658337519,"I17",-2.175282255923789]
[18,"L18",2,"R18",0.13200000000000001,"U18",35.47779876570516,"P18",11.3,"Ip18",318.50905053678855,"I18",-2.496390172507164]
[19,"L19",2,"R19",0.13200000000000001,"U19",35.807322268476106,"P19",11.3,"Ip19",315.57791211738402,"I19",-2.8148992230439527]
[20,"L20",2,"R20",0.13200000000000001,"U20",36.178888965917906,"P20",11.3,"Ip20",312.33684402650101,"I20",-3.1304771351613367]

{"sheet":"Intro","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DICENTIS Power Calculation Tool"]
["Version","2.05"]
["Date","2018-09-20"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":14,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"P device W","CB resistance"," U device V","Iload (mA)","In (A)","V too low","I too low",null,null,{"$f":"NOW()","v":"2018-09-20T10:45:12.450"}]
["Device","Cable length (m) between 2-99","Device type",3.2808399000000001,null,{"$f":"Data!$B$2","v":48},null,3,{"$f":"IFERROR(MATCH(1,I3:I43,0),)","v":41},{"$f":"IFERROR(MATCH(1,J3:J43,0),)","v":41},null,3,41,41]
[1,2,null,{"$f":"IF(ISBLANK(C3),\"\",VLOOKUP(C3,Data!$A$9:$B$16,2,FALSE))","v":""},{"$f":"IF(OR(COUNTBLANK(B3)>0,COUNTBLANK(D3)>0),\"\",2*(Data!$B$7/1000)*B3+ 4*Data!$B$6/1000)","v":""},{"$f":"IF(COUNTBLANK(E3)>0,\"\",F2-(H2*E3))","v":""},{"$f":"IF(COUNTBLANK(F3)>0,\"\",(D3/F3)*1000)","v":""},{"$f":"IF(COUNTBLANK(G3)>0,\"\",H2-G2/1000)","v":""},{"$f":"IFERROR(IF(LEFT(C3,6)=\"DCNM-D\",IF((F3<35),1,0),IF((F3<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H3<G3/1000,1,0),)","v":0},{"$f":"I3+J3","v":0},3,41,41]
[2,2,"DCNM-MMD",{"$f":"IF(ISBLANK(C4),\"\",VLOOKUP(C4,Data!$A$9:$B$16,2,FALSE))","v":11.3},{"$f":"IF(OR(COUNTBLANK(B4)>0,COUNTBLANK(D4)>0),\"\",2*(Data!$B$7/1000)*B4+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(E4)>0,\"\",F3-(H3*E4))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(F4)>0,\"\",(D4/F4)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(G4)>0,\"\",H3-G3/1000)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(LEFT(C4,6)=\"DCNM-D\",IF((F4<35),1,0),IF((F4<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H4<G4/1000,1,0),)","v":0},{"$f":"I4+J4+SUM($K$3:K3)","v":0},3,41,41]
[3,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B5)>0,COUNTBLANK(D5)>0),\"\",2*(Data!$B$7/1000)*B5+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(E5)>0,\"\",F4-(H4*E5))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(F5)>0,\"\",(D5/F5)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(G5)>0,\"\",H4-G4/1000)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(LEFT(C5,6)=\"DCNM-D\",IF((F5<35),1,0),IF((F5<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H5<G5/1000,1,0),)","v":0},{"$f":"I5+J5+SUM($K$3:K4)","v":0}]
[4,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C6),\"\",VLOOKUP(C6,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B6)>0,COUNTBLANK(D6)>0),\"\",2*(Data!$B$7/1000)*B6+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I6+J6+SUM($K$3:K5)","v":0}]
[5,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C7),\"\",VLOOKUP(C7,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B7)>0,COUNTBLANK(D7)>0),\"\",2*(Data!$B$7/1000)*B7+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I7+J7+SUM($K$3:K6)","v":0}]
[6,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C8),\"\",VLOOKUP(C8,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B8)>0,COUNTBLANK(D8)>0),\"\",2*(Data!$B$7/1000)*B8+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I8+J8+SUM($K$3:K7)","v":0}]
[7,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C9),\"\",VLOOKUP(C9,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B9)>0,COUNTBLANK(D9)>0),\"\",2*(Data!$B$7/1000)*B9+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I9+J9+SUM($K$3:K8)","v":0}]
[8,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(C10,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B10)>0,COUNTBLANK(D10)>0),\"\",2*(Data!$B$7/1000)*B10+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I10+J10+SUM($K$3:K9)","v":0}]
[9,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(C11,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B11)>0,COUNTBLANK(D11)>0),\"\",2*(Data!$B$7/1000)*B11+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I11+J11+SUM($K$3:K10)","v":0}]
[10,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(C12,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B12)>0,COUNTBLANK(D12)>0),\"\",2*(Data!$B$7/1000)*B12+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I12+J12+SUM($K$3:K11)","v":0}]
[11,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B13)>0,COUNTBLANK(D13)>0),\"\",2*(Data!$B$7/1000)*B13+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I13+J13+SUM($K$3:K12)","v":0}]
[12,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B14)>0,COUNTBLANK(D14)>0),\"\",2*(Data!$B$7/1000)*B14+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I14+J14+SUM($K$3:K13)","v":0}]
[13,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B15)>0,COUNTBLANK(D15)>0),\"\",2*(Data!$B$7/1000)*B15+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I15+J15+SUM($K$3:K14)","v":0}]
[14,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B16)>0,COUNTBLANK(D16)>0),\"\",2*(Data!$B$7/1000)*B16+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I16+J16+SUM($K$3:K15)","v":0}]
[15,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B17)>0,COUNTBLANK(D17)>0),\"\",2*(Data!$B$7/1000)*B17+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I17+J17+SUM($K$3:K16)","v":0}]
[16,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B18)>0,COUNTBLANK(D18)>0),\"\",2*(Data!$B$7/1000)*B18+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I18+J18+SUM($K$3:K17)","v":0}]
[17,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B19)>0,COUNTBLANK(D19)>0),\"\",2*(Data!$B$7/1000)*B19+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I19+J19+SUM($K$3:K18)","v":0}]
[18,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B20)>0,COUNTBLANK(D20)>0),\"\",2*(Data!$B$7/1000)*B20+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I20+J20+SUM($K$3:K19)","v":0}]
[19,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B21)>0,COUNTBLANK(D21)>0),\"\",2*(Data!$B$7/1000)*B21+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I21+J21+SUM($K$3:K20)","v":0}]
[20,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(C22,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B22)>0,COUNTBLANK(D22)>0),\"\",2*(Data!$B$7/1000)*B22+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I22+J22+SUM($K$3:K21)","v":0}]
[21,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(C23,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B23)>0,COUNTBLANK(D23)>0),\"\",2*(Data!$B$7/1000)*B23+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I23+J23+SUM($K$3:K22)","v":0}]
[22,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(C24,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B24)>0,COUNTBLANK(D24)>0),\"\",2*(Data!$B$7/1000)*B24+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I24+J24+SUM($K$3:K23)","v":0}]
[23,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(C25,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B25)>0,COUNTBLANK(D25)>0),\"\",2*(Data!$B$7/1000)*B25+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I25+J25+SUM($K$3:K24)","v":0}]
[24,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(C26,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B26)>0,COUNTBLANK(D26)>0),\"\",2*(Data!$B$7/1000)*B26+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I26+J26+SUM($K$3:K25)","v":0}]
[25,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(C27,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B27)>0,COUNTBLANK(D27)>0),\"\",2*(Data!$B$7/1000)*B27+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I27+J27+SUM($K$3:K26)","v":0}]
[26,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(C28,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B28)>0,COUNTBLANK(D28)>0),\"\",2*(Data!$B$7/1000)*B28+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I28+J28+SUM($K$3:K27)","v":0}]
[27,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C29),\"\",VLOOKUP(C29,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B29)>0,COUNTBLANK(D29)>0),\"\",2*(Data!$B$7/1000)*B29+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I29+J29+SUM($K$3:K28)","v":0}]
[28,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C30),\"\",VLOOKUP(C30,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B30)>0,COUNTBLANK(D30)>0),\"\",2*(Data!$B$7/1000)*B30+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I30+J30+SUM($K$3:K29)","v":0}]
[29,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C31),\"\",VLOOKUP(C31,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B31)>0,COUNTBLANK(D31)>0),\"\",2*(Data!$B$7/1000)*B31+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I31+J31+SUM($K$3:K30)","v":0}]
[30,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(C32,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B32)>0,COUNTBLANK(D32)>0),\"\",2*(Data!$B$7/1000)*B32+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I32+J32+SUM($K$3:K31)","v":0}]
[31,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(C33,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B33)>0,COUNTBLANK(D33)>0),\"\",2*(Data!$B$7/1000)*B33+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I33+J33+SUM($K$3:K32)","v":0}]
[32,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(C34,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B34)>0,COUNTBLANK(D34)>0),\"\",2*(Data!$B$7/1000)*B34+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I34+J34+SUM($K$3:K33)","v":0}]
[33,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C35),\"\",VLOOKUP(C35,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B35)>0,COUNTBLANK(D35)>0),\"\",2*(Data!$B$7/1000)*B35+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I35+J35+SUM($K$3:K34)","v":0}]
[34,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C36),\"\",VLOOKUP(C36,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B36)>0,COUNTBLANK(D36)>0),\"\",2*(Data!$B$7/1000)*B36+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(E36)>0,\"\",F35-(H35*E36))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(F36)>0,\"\",(D36/F36)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(G36)>0,\"\",H35-G35/1000)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(LEFT(C36,6)=\"DCNM-D\",IF((F36<35),1,0),IF((F36<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H36<G36/1000,1,0),)","v":0},{"$f":"I36+J36+SUM($K$3:K35)","v":0}]
[35,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C37),\"\",VLOOKUP(C37,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B37)>0,COUNTBLANK(D37)>0),\"\",2*(Data!$B$7/1000)*B37+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I37+J37+SUM($K$3:K36)","v":0}]
[36,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C38),\"\",VLOOKUP(C38,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B38)>0,COUNTBLANK(D38)>0),\"\",2*(Data!$B$7/1000)*B38+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I38+J38+SUM($K$3:K37)","v":0}]
[37,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C39),\"\",VLOOKUP(C39,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B39)>0,COUNTBLANK(D39)>0),\"\",2*(Data!$B$7/1000)*B39+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(E39)>0,\"\",F38-(H38*E39))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(F39)>0,\"\",(D39/F39)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(G39)>0,\"\",H38-G38/1000)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(LEFT(C39,6)=\"DCNM-D\",IF((F39<35),1,0),IF((F39<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H39<G39/1000,1,0),)","v":0},{"$f":"I39+J39+SUM($K$3:K38)","v":0}]
[38,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C40),\"\",VLOOKUP(C40,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B40)>0,COUNTBLANK(D40)>0),\"\",2*(Data!$B$7/1000)*B40+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,0,{"$f":"I40+J40+SUM($K$3:K39)","v":0}]
[39,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C41),\"\",VLOOKUP(C41,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B41)>0,COUNTBLANK(D41)>0),\"\",2*(Data!$B$7/1000)*B41+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IFERROR(IF(LEFT(C41,6)=\"DCNM-D\",IF((F41<35),1,0),IF((F41<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H41<G41/1000,1,0),)","v":0},{"$f":"I41+J41+SUM($K$3:K40)","v":0}]
[40,2,"DCNM-IDESKVID",{"$f":"IF(ISBLANK(C42),\"\",VLOOKUP(C42,Data!$A$9:$B$16,2,FALSE))","v":18},{"$f":"IF(OR(COUNTBLANK(B42)>0,COUNTBLANK(D42)>0),\"\",2*(Data!$B$7/1000)*B42+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(E42)>0,\"\",F41-(H41*E42))","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(F42)>0,\"\",(D42/F42)*1000)","v":{"$error":"#VALUE!"}},{"$f":"IF(COUNTBLANK(G42)>0,\"\",H41-G41/1000)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(IF(LEFT(C42,6)=\"DCNM-D\",IF((F42<35),1,0),IF((F42<31),1,0)),)","v":0},{"$f":"IFERROR(IF(H42<G42/1000,1,0),)","v":0},{"$f":"I42+J42+SUM($K$3:K41)","v":0}]
[null,null,null,null,null,null,null,null,1,1]

{"sheet":"Revision history","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"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"]