{"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":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":18,"n_cols":14,"rows_kept":18,"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"]

{"sheet":"Intro","index":1,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DICENTIS Power Calculation Tool"]
["Version","2.10"]
["Date","2024-09-27"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":"2024-09-27T16:45:20.550"}]
["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":41},null,3,41,27]
[1,2,"DCNM-D",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$18,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":3.1},{"$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":65.12057810268044},{"$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,27]
[2,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C4),\"\",VLOOKUP(C4,Data!$A$9:$B$18,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":3.1},{"$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":65.666836129469587},{"$f":"IF(COUNTBLANK(O4)>0,\"\",P3-O3/1000)","v":2.9348794218973198},0,{"$f":"IFERROR(IF(P4<O4/1000,1,0),)","v":0},{"$f":"Q4+R4+SUM($S$3:S3)","v":0},3,41,27]
[3,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,Data!$A$9:$B$18,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":3.1},{"$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.82059591630955},{"$f":"IF(COUNTBLANK(N5)>0,\"\",(L5/N5)*1000)","v":66.210178220310553},{"$f":"IF(COUNTBLANK(O5)>0,\"\",P4-O4/1000)","v":2.8692125857678503},0,{"$f":"IFERROR(IF(P5<O5/1000,1,0),)","v":0},{"$f":"Q5+R5+SUM($S$3:S4)","v":0}]
[4,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C6),\"\",VLOOKUP(C6,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K6)>0,COUNTBLANK(L6)>0),\"\",2*(Data!$B$7/1000)*K6+ 4*Data!$B$6/1000)","v":0.13200000000000001},46.441859854988195,66.75012606470878,2.8030024075475399,0,0,{"$f":"Q6+R6+SUM($S$3:S5)","v":0}]
[5,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C7),\"\",VLOOKUP(C7,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K7)>0,COUNTBLANK(L7)>0),\"\",2*(Data!$B$7/1000)*K7+ 4*Data!$B$6/1000)","v":0.13200000000000001},46.071863537191916,67.286186448644472,2.7362522814828312,0,0,{"$f":"Q7+R7+SUM($S$3:S6)","v":0}]
[6,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C8),\"\",VLOOKUP(C8,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K8)>0,COUNTBLANK(L8)>0),\"\",2*(Data!$B$7/1000)*K8+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.710678236036181,67.817851749924458,2.6689660950341869,0,0,{"$f":"Q8+R8+SUM($S$3:S7)","v":0}]
[7,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C9),\"\",VLOOKUP(C9,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K9)>0,COUNTBLANK(L9)>0),\"\",2*(Data!$B$7/1000)*K9+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.35837471149167,68.344600522350873,2.6011482432842623,0,0,{"$f":"Q9+R9+SUM($S$3:S8)","v":0}]
[8,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(C10,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K10)>0,COUNTBLANK(L10)>0),\"\",2*(Data!$B$7/1000)*K10+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.015023143378144,68.86589817195329,2.5328036427619116,0,0,{"$f":"Q10+R10+SUM($S$3:S9)","v":0}]
[9,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(C11,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K11)>0,COUNTBLANK(L11)>0),\"\",2*(Data!$B$7/1000)*K11+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.680693062533571,69.381197728095799,2.4639377445899582,0,0,{"$f":"Q11+R11+SUM($S$3:S10)","v":0}]
[10,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(C12,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K12)>0,COUNTBLANK(L12)>0),\"\",2*(Data!$B$7/1000)*K12+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.355453280247694,69.88994071176559,2.3945565468618626,0,0,{"$f":"Q12+R12+SUM($S$3:S11)","v":0}]
[11,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K13)>0,COUNTBLANK(L13)>0),\"\",2*(Data!$B$7/1000)*K13+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.03937181606193,70.391558102774198,2.3246666061500969,0,0,{"$f":"Q13+R13+SUM($S$3:S12)","v":0}]
[12,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K14)>0,COUNTBLANK(L14)>0),\"\",2*(Data!$B$7/1000)*K14+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.732515824050118,70.885471406957009,2.2542750480473228,0,0,{"$f":"Q14+R14+SUM($S$3:S13)","v":0}]
[13,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K15)>0,COUNTBLANK(L15)>0),\"\",2*(Data!$B$7/1000)*K15+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.434951517707873,71.371093823741703,2.1833895766403657,0,0,{"$f":"Q15+R15+SUM($S$3:S14)","v":0}]
[14,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K16)>0,COUNTBLANK(L16)>0),\"\",2*(Data!$B$7/1000)*K16+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.146744093591344,71.847831513674933,2.112018482816624,0,0,{"$f":"Q16+R16+SUM($S$3:S15)","v":0}]
[15,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K17)>0,COUNTBLANK(L17)>0),\"\",2*(Data!$B$7/1000)*K17+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.867957653859548,72.315084964652996,2.0401706513029492,0,0,{"$f":"Q17+R17+SUM($S$3:S16)","v":0}]
[16,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K18)>0,COUNTBLANK(L18)>0),\"\",2*(Data!$B$7/1000)*K18+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.598655127887561,72.772250454699446,1.9678555663382962,0,0,{"$f":"Q18+R18+SUM($S$3:S17)","v":0}]
[17,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K19)>0,COUNTBLANK(L19)>0),\"\",2*(Data!$B$7/1000)*K19+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.338898193130909,73.21872160818171,1.8950833158835967,0,0,{"$f":"Q19+R19+SUM($S$3:S18)","v":0}]
[18,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K20)>0,COUNTBLANK(L20)>0),\"\",2*(Data!$B$7/1000)*K20+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.088747195434273,73.653891041363266,1.821864594275415,0,0,{"$f":"Q20+R20+SUM($S$3:S19)","v":0}]
[19,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,Data!$A$9:$B$18,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":3.1},{"$f":"IF(OR(COUNTBLANK(K21)>0,COUNTBLANK(L21)>0),\"\",2*(Data!$B$7/1000)*K21+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.84826106898992,74.077152092160375,1.7482107032340517,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$18,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},41.617497256163027,74.487900627924688,1.6741335511418913,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$18,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},41.396511627412295,74.885536924015,1.5996456505139667,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$18,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},41.185358401544448,75.26946760486976,1.5247601135899518,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$18,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},40.984090066550571,75.639107638260953,1.449490645985082,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$18,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},40.792757301280538,75.993882372415328,1.3738515383468211,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$18,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},40.611408898218755,76.333229604747061,1.2978576559744057,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$18,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},40.440091687630137,76.656601670075645,1.2215244263696587,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$18,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},40.278850463349343,76.963467535419412,1.1448678246995831,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$18,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},40.127727910489,77.2533148877759,1.0679043571641638,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$18,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},39.986764535343333,77.525652200742201,0.99065104227638789,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$18,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},39.855998597762849,77.78001076540599,0.91312539007564575,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$18,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},39.735466046272862,78.015946670663922,0.83534537931023978,0,0,{"$f":"Q33+R33+SUM($S$3:S32)","v":0}]
[32,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(C34,Data!$A$9:$B$18,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},39.625200456203913,78.233042718012271,0.75732943263957586,0,0,{"$f":"Q34+R34+SUM($S$3:S33)","v":0}]
[33,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C35),\"\",VLOOKUP(C35,Data!$A$9:$B$18,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},39.525232971095491,78.430910255911897,0.67909638992156363,0,0,{"$f":"Q35+R35+SUM($S$3:S34)","v":0}]
[34,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C36),\"\",VLOOKUP(C36,Data!$A$9:$B$18,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":39.435592247625841},{"$f":"IF(COUNTBLANK(N36)>0,\"\",(L36/N36)*1000)","v":78.609190919064517},{"$f":"IF(COUNTBLANK(O36)>0,\"\",P35-O35/1000)","v":0.60066547966565176},0,{"$f":"IFERROR(IF(P36<O36/1000,1,0),)","v":0},{"$f":"Q36+R36+SUM($S$3:S35)","v":0}]
[35,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C37),\"\",VLOOKUP(C37,Data!$A$9:$B$18,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},39.356304404309974,78.767558258354001,0.52205628874658727,0,0,{"$f":"Q37+R37+SUM($S$3:S36)","v":0}]
[36,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C38),\"\",VLOOKUP(C38,Data!$A$9:$B$18,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},39.287392974195427,78.905719247803702,0.44328873048823325,0,0,{"$f":"Q38+R38+SUM($S$3:S37)","v":0}]
[37,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C39),\"\",VLOOKUP(C39,Data!$A$9:$B$18,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":39.22887886177098},{"$f":"IF(COUNTBLANK(N39)>0,\"\",(L39/N39)*1000)","v":79.023415655678804},{"$f":"IF(COUNTBLANK(O39)>0,\"\",P38-O38/1000)","v":0.36438301124042954},0,{"$f":"IFERROR(IF(P39<O39/1000,1,0),)","v":0},{"$f":"Q39+R39+SUM($S$3:S38)","v":0}]
[38,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C40),\"\",VLOOKUP(C40,Data!$A$9:$B$18,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},39.180780304287246,79.120425267814056,0.28535959558475077,0,0,{"$f":"Q40+R40+SUM($S$3:S39)","v":0}]
[39,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C41),\"\",VLOOKUP(C41,Data!$A$9:$B$18,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},39.14311283767006,79.196562952363379,0.20623917031693673,0,{"$f":"IFERROR(IF(P41<O41/1000,1,0),)","v":0},{"$f":"Q41+R41+SUM($S$3:S40)","v":0}]
[40,2,"DCNM-D",null,null,null,null,null,null,null,2,{"$f":"IF(ISBLANK(C42),\"\",VLOOKUP(C42,Data!$A$9:$B$18,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":39.115889267188223},{"$f":"IF(COUNTBLANK(N42)>0,\"\",(L42/N42)*1000)","v":79.251681556435656},{"$f":"IF(COUNTBLANK(O42)>0,\"\",P41-O41/1000)","v":0.12704260736457335},0,{"$f":"IFERROR(IF(P42<O42/1000,1,0),)","v":0},{"$f":"Q42+R42+SUM($S$3:S41)","v":0}]
[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":14,"n_cols":4,"rows_kept":14,"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)"]