{"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":17,"n_cols":14,"rows_kept":17,"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","# buttons","# FMCP"]
["DCNM-DSL",3.6,"Watt",null,"DCNM-FMICB/FPRIOB",0.55000000000000004,"Watt",0,0,0]
["DCNM-DVT",3.7,"Watt",null,"DCNM-FMCP",0.2,"Watt",1,1,1]
["DCNM-D",3.1,"Watt",null,"DCNM-FLSP",1,"Watt",2,2,2]
["DCNM-IDESK",15,"Watt",null,null,null,null,null,3]
["DCNM-IDESKVID",18,"Watt",null,null,null,null,null,4]
["DCNM-FBD",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.08"]
["Date","2021-03-25"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Click the hyperlink of either meters or feet to enter the calculation sheet."]
["Enter the required cable length and the calculation will show you in red if the cable is too long."]
["Clearing the cable length cell will remove the complete line"]
["Have fun using this tool."]

{"sheet":"Calculate","index":2,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,3,0,5]]}
[null,null,null,"attached modules to FBD",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":"2021-09-21T15:25:46.670"}]
["Device","Cable length (m) between 2-99","Device type","FLSP","FMICB/FPRIOB","FMCP","m",3.2808399000000001,null,{"$f":"Data!$B$2","v":48},null,3,{"$f":"IFERROR(MATCH(1,M3:M43,0),)","v":41},{"$f":"IFERROR(MATCH(1,N3:N43,0),)","v":41},null,3,41,41]
[1,2,"DCNM-D",null,null,null,{"$f":"IF($G$2=\"m\",B3,INT(B3/3.2808399+0.5))","v":2},{"$f":"IF(ISBLANK(C3),\"\",VLOOKUP(C3,Data!$A$9:$B$17,2,FALSE)+IF(C3=\"DCNM-FBD\",D3*Data!$F$14+E3*Data!$F$12+F3*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G3)>0,COUNTBLANK(H3)>0),\"\",2*(Data!$B$7/1000)*G3+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(I3)>0,\"\",J2-(L2*I3))","v":47.603999999999999},{"$f":"IF(COUNTBLANK(J3)>0,\"\",(H3/J3)*1000)","v":65.12057810268044},{"$f":"IF(COUNTBLANK(K3)>0,\"\",L2-K2/1000)","v":3},{"$f":"IFERROR(IF(LEFT(C3,6)=\"DCNM-D\",IF((J3<35),1,0),IF((J3<31),1,0)),)","v":0},{"$f":"IFERROR(IF(L3<K3/1000,1,0),)","v":0},{"$f":"M3+N3","v":0},3,41,41]
[2,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C4),\"\",VLOOKUP(C4,Data!$A$9:$B$17,2,FALSE)+IF(C4=\"DCNM-FBD\",D4*Data!$F$14+E4*Data!$F$12+F4*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G4)>0,COUNTBLANK(H4)>0),\"\",2*(Data!$B$7/1000)*G4+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(I4)>0,\"\",J3-(L3*I4))","v":47.207999999999998},{"$f":"IF(COUNTBLANK(J4)>0,\"\",(H4/J4)*1000)","v":65.666836129469587},{"$f":"IF(COUNTBLANK(K4)>0,\"\",L3-K3/1000)","v":2.9348794218973198},0,{"$f":"IFERROR(IF(L4<K4/1000,1,0),)","v":0},{"$f":"M4+N4+SUM($O$3:O3)","v":0},3,41,41]
[3,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C5),\"\",VLOOKUP(C5,Data!$A$9:$B$17,2,FALSE)+IF(C5=\"DCNM-FBD\",D5*Data!$F$14+E5*Data!$F$12+F5*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G5)>0,COUNTBLANK(H5)>0),\"\",2*(Data!$B$7/1000)*G5+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(I5)>0,\"\",J4-(L4*I5))","v":46.82059591630955},{"$f":"IF(COUNTBLANK(J5)>0,\"\",(H5/J5)*1000)","v":66.210178220310553},{"$f":"IF(COUNTBLANK(K5)>0,\"\",L4-K4/1000)","v":2.8692125857678503},0,{"$f":"IFERROR(IF(L5<K5/1000,1,0),)","v":0},{"$f":"M5+N5+SUM($O$3:O4)","v":0}]
[4,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C6),\"\",VLOOKUP(C6,Data!$A$9:$B$17,2,FALSE)+IF(C6=\"DCNM-FBD\",D6*Data!$F$14+E6*Data!$F$12+F6*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G6)>0,COUNTBLANK(H6)>0),\"\",2*(Data!$B$7/1000)*G6+ 4*Data!$B$6/1000)","v":0.13200000000000001},46.441859854988195,66.75012606470878,2.8030024075475399,0,0,{"$f":"M6+N6+SUM($O$3:O5)","v":0}]
[5,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C7),\"\",VLOOKUP(C7,Data!$A$9:$B$17,2,FALSE)+IF(C7=\"DCNM-FBD\",D7*Data!$F$14+E7*Data!$F$12+F7*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G7)>0,COUNTBLANK(H7)>0),\"\",2*(Data!$B$7/1000)*G7+ 4*Data!$B$6/1000)","v":0.13200000000000001},46.071863537191916,67.286186448644472,2.7362522814828312,0,0,{"$f":"M7+N7+SUM($O$3:O6)","v":0}]
[6,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C8),\"\",VLOOKUP(C8,Data!$A$9:$B$17,2,FALSE)+IF(C8=\"DCNM-FBD\",D8*Data!$F$14+E8*Data!$F$12+F8*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G8)>0,COUNTBLANK(H8)>0),\"\",2*(Data!$B$7/1000)*G8+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.710678236036181,67.817851749924458,2.6689660950341869,0,0,{"$f":"M8+N8+SUM($O$3:O7)","v":0}]
[7,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C9),\"\",VLOOKUP(C9,Data!$A$9:$B$17,2,FALSE)+IF(C9=\"DCNM-FBD\",D9*Data!$F$14+E9*Data!$F$12+F9*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G9)>0,COUNTBLANK(H9)>0),\"\",2*(Data!$B$7/1000)*G9+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.35837471149167,68.344600522350873,2.6011482432842623,0,0,{"$f":"M9+N9+SUM($O$3:O8)","v":0}]
[8,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C10),\"\",VLOOKUP(C10,Data!$A$9:$B$17,2,FALSE)+IF(C10=\"DCNM-FBD\",D10*Data!$F$14+E10*Data!$F$12+F10*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G10)>0,COUNTBLANK(H10)>0),\"\",2*(Data!$B$7/1000)*G10+ 4*Data!$B$6/1000)","v":0.13200000000000001},45.015023143378144,68.86589817195329,2.5328036427619116,0,0,{"$f":"M10+N10+SUM($O$3:O9)","v":0}]
[9,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C11),\"\",VLOOKUP(C11,Data!$A$9:$B$17,2,FALSE)+IF(C11=\"DCNM-FBD\",D11*Data!$F$14+E11*Data!$F$12+F11*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G11)>0,COUNTBLANK(H11)>0),\"\",2*(Data!$B$7/1000)*G11+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.680693062533571,69.381197728095799,2.4639377445899582,0,0,{"$f":"M11+N11+SUM($O$3:O10)","v":0}]
[10,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C12),\"\",VLOOKUP(C12,Data!$A$9:$B$17,2,FALSE)+IF(C12=\"DCNM-FBD\",D12*Data!$F$14+E12*Data!$F$12+F12*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G12)>0,COUNTBLANK(H12)>0),\"\",2*(Data!$B$7/1000)*G12+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.355453280247694,69.88994071176559,2.3945565468618626,0,0,{"$f":"M12+N12+SUM($O$3:O11)","v":0}]
[11,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C13),\"\",VLOOKUP(C13,Data!$A$9:$B$17,2,FALSE)+IF(C13=\"DCNM-FBD\",D13*Data!$F$14+E13*Data!$F$12+F13*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G13)>0,COUNTBLANK(H13)>0),\"\",2*(Data!$B$7/1000)*G13+ 4*Data!$B$6/1000)","v":0.13200000000000001},44.03937181606193,70.391558102774198,2.3246666061500969,0,0,{"$f":"M13+N13+SUM($O$3:O12)","v":0}]
[12,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C14),\"\",VLOOKUP(C14,Data!$A$9:$B$17,2,FALSE)+IF(C14=\"DCNM-FBD\",D14*Data!$F$14+E14*Data!$F$12+F14*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G14)>0,COUNTBLANK(H14)>0),\"\",2*(Data!$B$7/1000)*G14+ 4*Data!$B$6/1000)","v":0.13200000000000001},43.732515824050118,70.885471406957009,2.2542750480473228,0,0,{"$f":"M14+N14+SUM($O$3:O13)","v":0}]
[13,5,"DCNM-D",null,null,null,5,{"$f":"IF(ISBLANK(C15),\"\",VLOOKUP(C15,Data!$A$9:$B$17,2,FALSE)+IF(C15=\"DCNM-FBD\",D15*Data!$F$14+E15*Data!$F$12+F15*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G15)>0,COUNTBLANK(H15)>0),\"\",2*(Data!$B$7/1000)*G15+ 4*Data!$B$6/1000)","v":0.26999999999999996},43.123861561077341,71.885955658432792,2.1833895766403657,0,0,{"$f":"M15+N15+SUM($O$3:O14)","v":0}]
[14,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C16),\"\",VLOOKUP(C16,Data!$A$9:$B$17,2,FALSE)+IF(C16=\"DCNM-FBD\",D16*Data!$F$14+E16*Data!$F$12+F16*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G16)>0,COUNTBLANK(H16)>0),\"\",2*(Data!$B$7/1000)*G16+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.835654136960812,72.369619711845601,2.1115036209819329,0,0,{"$f":"M16+N16+SUM($O$3:O15)","v":0}]
[15,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C17),\"\",VLOOKUP(C17,Data!$A$9:$B$17,2,FALSE)+IF(C17=\"DCNM-FBD\",D17*Data!$F$14+E17*Data!$F$12+F17*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G17)>0,COUNTBLANK(H17)>0),\"\",2*(Data!$B$7/1000)*G17+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.5569356589912,72.84359063914529,2.0391340012700874,0,0,{"$f":"M17+N17+SUM($O$3:O16)","v":0}]
[16,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C18),\"\",VLOOKUP(C18,Data!$A$9:$B$17,2,FALSE)+IF(C18=\"DCNM-FBD\",D18*Data!$F$14+E18*Data!$F$12+F18*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G18)>0,COUNTBLANK(H18)>0),\"\",2*(Data!$B$7/1000)*G18+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.287769970823547,73.307247039483173,1.966290410630942,0,0,{"$f":"M18+N18+SUM($O$3:O17)","v":0}]
[17,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C19),\"\",VLOOKUP(C19,Data!$A$9:$B$17,2,FALSE)+IF(C19=\"DCNM-FBD\",D19*Data!$F$14+E19*Data!$F$12+F19*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G19)>0,COUNTBLANK(H19)>0),\"\",2*(Data!$B$7/1000)*G19+ 4*Data!$B$6/1000)","v":0.13200000000000001},42.028219636620264,73.759964776116547,1.8929831635914589,0,0,{"$f":"M19+N19+SUM($O$3:O18)","v":0}]
[18,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C20),\"\",VLOOKUP(C20,Data!$A$9:$B$17,2,FALSE)+IF(C20=\"DCNM-FBD\",D20*Data!$F$14+E20*Data!$F$12+F20*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G20)>0,COUNTBLANK(H20)>0),\"\",2*(Data!$B$7/1000)*G20+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.778345859026189,74.201118695805107,1.8192231988153424,0,0,{"$f":"M20+N20+SUM($O$3:O19)","v":0}]
[19,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C21),\"\",VLOOKUP(C21,Data!$A$9:$B$17,2,FALSE)+IF(C21=\"DCNM-FBD\",D21*Data!$F$14+E21*Data!$F$12+F21*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G21)>0,COUNTBLANK(H21)>0),\"\",2*(Data!$B$7/1000)*G21+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.538208396782565,74.630084436672945,1.7450220801195373,0,0,{"$f":"M21+N21+SUM($O$3:O20)","v":0}]
[20,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C22),\"\",VLOOKUP(C22,Data!$A$9:$B$17,2,FALSE)+IF(C22=\"DCNM-FBD\",D22*Data!$F$14+E22*Data!$F$12+F22*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G22)>0,COUNTBLANK(H22)>0),\"\",2*(Data!$B$7/1000)*G22+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.307865482206786,75.046240317968341,1.6703919956828643,0,0,{"$f":"M22+N22+SUM($O$3:O21)","v":0}]
[21,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C23),\"\",VLOOKUP(C23,Data!$A$9:$B$17,2,FALSE)+IF(C23=\"DCNM-FBD\",D23*Data!$F$14+E23*Data!$F$12+F23*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G23)>0,COUNTBLANK(H23)>0),\"\",2*(Data!$B$7/1000)*G23+ 4*Data!$B$6/1000)","v":0.13200000000000001},41.087373738776648,75.448969304025923,1.595345755364896,0,0,{"$f":"M23+N23+SUM($O$3:O22)","v":0}]
[22,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C24),\"\",VLOOKUP(C24,Data!$A$9:$B$17,2,FALSE)+IF(C24=\"DCNM-FBD\",D24*Data!$F$14+E24*Data!$F$12+F24*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G24)>0,COUNTBLANK(H24)>0),\"\",2*(Data!$B$7/1000)*G24+ 4*Data!$B$6/1000)","v":0.13200000000000001},40.876788099068484,75.837661033613443,1.5198967860608701,0,0,{"$f":"M24+N24+SUM($O$3:O23)","v":0}]
[23,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C25),\"\",VLOOKUP(C25,Data!$A$9:$B$17,2,FALSE)+IF(C25=\"DCNM-FBD\",D25*Data!$F$14+E25*Data!$F$12+F25*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G25)>0,COUNTBLANK(H25)>0),\"\",2*(Data!$B$7/1000)*G25+ 4*Data!$B$6/1000)","v":0.13200000000000001},40.676161723308446,76.211713904746901,1.4440591250272568,0,0,{"$f":"M25+N25+SUM($O$3:O24)","v":0}]
[24,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C26),\"\",VLOOKUP(C26,Data!$A$9:$B$17,2,FALSE)+IF(C26=\"DCNM-FBD\",D26*Data!$F$14+E26*Data!$F$12+F26*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G26)>0,COUNTBLANK(H26)>0),\"\",2*(Data!$B$7/1000)*G26+ 4*Data!$B$6/1000)","v":0.13200000000000001},40.485545918804846,76.570537203997603,1.3678474111225098,0,0,{"$f":"M26+N26+SUM($O$3:O25)","v":0}]
[25,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C27),\"\",VLOOKUP(C27,Data!$A$9:$B$17,2,FALSE)+IF(C27=\"DCNM-FBD\",D27*Data!$F$14+E27*Data!$F$12+F27*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G27)>0,COUNTBLANK(H27)>0),\"\",2*(Data!$B$7/1000)*G27+ 4*Data!$B$6/1000)","v":0.13200000000000001},40.304990060536674,76.913553268315141,1.2912768739185123,0,0,{"$f":"M27+N27+SUM($O$3:O26)","v":0}]
[26,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C28),\"\",VLOOKUP(C28,Data!$A$9:$B$17,2,FALSE)+IF(C28=\"DCNM-FBD\",D28*Data!$F$14+E28*Data!$F$12+F28*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G28)>0,COUNTBLANK(H28)>0),\"\",2*(Data!$B$7/1000)*G28+ 4*Data!$B$6/1000)","v":0.13200000000000001},40.134541513179428,77.240199666464818,1.2143633206501971,0,0,{"$f":"M28+N28+SUM($O$3:O27)","v":0}]
[27,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C29),\"\",VLOOKUP(C29,Data!$A$9:$B$17,2,FALSE)+IF(C29=\"DCNM-FBD\",D29*Data!$F$14+E29*Data!$F$12+F29*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G29)>0,COUNTBLANK(H29)>0),\"\",2*(Data!$B$7/1000)*G29+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.974245554853603,77.549931386349911,1.1371231209837322,0,0,{"$f":"M29+N29+SUM($O$3:O28)","v":0}]
[28,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C30),\"\",VLOOKUP(C30,Data!$A$9:$B$17,2,FALSE)+IF(C30=\"DCNM-FBD\",D30*Data!$F$14+E30*Data!$F$12+F30*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G30)>0,COUNTBLANK(H30)>0),\"\",2*(Data!$B$7/1000)*G30+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.82414530288375,77.842223013773562,1.0595731895973823,0,0,{"$f":"M30+N30+SUM($O$3:O29)","v":0}]
[29,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C31),\"\",VLOOKUP(C31,Data!$A$9:$B$17,2,FALSE)+IF(C31=\"DCNM-FBD\",D31*Data!$F$14+E31*Data!$F$12+F31*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G31)>0,COUNTBLANK(H31)>0),\"\",2*(Data!$B$7/1000)*G31+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.684281641856899,78.116570887610138,0.98173096658360881,0,0,{"$f":"M31+N31+SUM($O$3:O30)","v":0}]
[30,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C32),\"\",VLOOKUP(C32,Data!$A$9:$B$17,2,FALSE)+IF(C32=\"DCNM-FBD\",D32*Data!$F$14+E32*Data!$F$12+F32*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G32)>0,COUNTBLANK(H32)>0),\"\",2*(Data!$B$7/1000)*G32+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.554693154267859,78.372495215918946,0.90361439569599866,0,0,{"$f":"M32+N32+SUM($O$3:O31)","v":0}]
[31,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C33),\"\",VLOOKUP(C33,Data!$A$9:$B$17,2,FALSE)+IF(C33=\"DCNM-FBD\",D33*Data!$F$14+E33*Data!$F$12+F33*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G33)>0,COUNTBLANK(H33)>0),\"\",2*(Data!$B$7/1000)*G33+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.43541605403599,78.609542137256923,0.82524190048007973,0,0,{"$f":"M33+N33+SUM($O$3:O32)","v":0}]
[32,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C34),\"\",VLOOKUP(C34,Data!$A$9:$B$17,2,FALSE)+IF(C34=\"DCNM-FBD\",D34*Data!$F$14+E34*Data!$F$12+F34*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G34)>0,COUNTBLANK(H34)>0),\"\",2*(Data!$B$7/1000)*G34+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.326484123172619,78.827285711344985,0.74663235834282282,0,0,{"$f":"M34+N34+SUM($O$3:O33)","v":0}]
[33,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C35),\"\",VLOOKUP(C35,Data!$A$9:$B$17,2,FALSE)+IF(C35=\"DCNM-FBD\",D35*Data!$F$14+E35*Data!$F$12+F35*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G35)>0,COUNTBLANK(H35)>0),\"\",2*(Data!$B$7/1000)*G35+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.227928651871366,79.025329823325123,0.66780507263147781,0,0,{"$f":"M35+N35+SUM($O$3:O34)","v":0}]
[34,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C36),\"\",VLOOKUP(C36,Data!$A$9:$B$17,2,FALSE)+IF(C36=\"DCNM-FBD\",D36*Data!$F$14+E36*Data!$F$12+F36*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G36)>0,COUNTBLANK(H36)>0),\"\",2*(Data!$B$7/1000)*G36+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(I36)>0,\"\",J35-(L35*I36))","v":39.139778382284014},{"$f":"IF(COUNTBLANK(J36)>0,\"\",(H36/J36)*1000)","v":79.203309986117972},{"$f":"IF(COUNTBLANK(K36)>0,\"\",L35-K35/1000)","v":0.58877974280815271},0,{"$f":"IFERROR(IF(L36<K36/1000,1,0),)","v":0},{"$f":"M36+N36+SUM($O$3:O35)","v":0}]
[35,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C37),\"\",VLOOKUP(C37,Data!$A$9:$B$17,2,FALSE)+IF(C37=\"DCNM-FBD\",D37*Data!$F$14+E37*Data!$F$12+F37*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G37)>0,COUNTBLANK(H37)>0),\"\",2*(Data!$B$7/1000)*G37+ 4*Data!$B$6/1000)","v":0.13200000000000001},39.062059456233335,79.360895025859094,0.50957643282203469,0,0,{"$f":"M37+N37+SUM($O$3:O36)","v":0}]
[36,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C38),\"\",VLOOKUP(C38,Data!$A$9:$B$17,2,FALSE)+IF(C38=\"DCNM-FBD\",D38*Data!$F$14+E38*Data!$F$12+F38*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G38)>0,COUNTBLANK(H38)>0),\"\",2*(Data!$B$7/1000)*G38+ 4*Data!$B$6/1000)","v":0.13200000000000001},38.994795367100828,79.497788636055049,0.43021553779617561,0,0,{"$f":"M38+N38+SUM($O$3:O37)","v":0}]
[37,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C39),\"\",VLOOKUP(C39,Data!$A$9:$B$17,2,FALSE)+IF(C39=\"DCNM-FBD\",D39*Data!$F$14+E39*Data!$F$12+F39*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G39)>0,COUNTBLANK(H39)>0),\"\",2*(Data!$B$7/1000)*G39+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(I39)>0,\"\",J38-(L38*I39))","v":38.938006916111732},{"$f":"IF(COUNTBLANK(J39)>0,\"\",(H39/J39)*1000)","v":79.613730786957291},{"$f":"IF(COUNTBLANK(K39)>0,\"\",L38-K38/1000)","v":0.35071774916012055},0,{"$f":"IFERROR(IF(L39<K39/1000,1,0),)","v":0},{"$f":"M39+N39+SUM($O$3:O38)","v":0}]
[38,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C40),\"\",VLOOKUP(C40,Data!$A$9:$B$17,2,FALSE)+IF(C40=\"DCNM-FBD\",D40*Data!$F$14+E40*Data!$F$12+F40*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G40)>0,COUNTBLANK(H40)>0),\"\",2*(Data!$B$7/1000)*G40+ 4*Data!$B$6/1000)","v":0.13200000000000001},38.891712173222594,79.708498977691889,0.27110401837316328,0,0,{"$f":"M40+N40+SUM($O$3:O39)","v":0}]
[39,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C41),\"\",VLOOKUP(C41,Data!$A$9:$B$17,2,FALSE)+IF(C41=\"DCNM-FBD\",D41*Data!$F$14+E41*Data!$F$12+F41*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G41)>0,COUNTBLANK(H41)>0),\"\",2*(Data!$B$7/1000)*G41+ 4*Data!$B$6/1000)","v":0.13200000000000001},38.855926442797333,79.78190931990099,0.19139551939547139,0,{"$f":"IFERROR(IF(L41<K41/1000,1,0),)","v":0},{"$f":"M41+N41+SUM($O$3:O40)","v":0}]
[40,2,"DCNM-D",null,null,null,2,{"$f":"IF(ISBLANK(C42),\"\",VLOOKUP(C42,Data!$A$9:$B$17,2,FALSE)+IF(C42=\"DCNM-FBD\",D42*Data!$F$14+E42*Data!$F$12+F42*Data!$F$13,0))","v":3.1},{"$f":"IF(OR(COUNTBLANK(G42)>0,COUNTBLANK(H42)>0),\"\",2*(Data!$B$7/1000)*G42+ 4*Data!$B$6/1000)","v":0.13200000000000001},{"$f":"IF(COUNTBLANK(I42)>0,\"\",J41-(L41*I42))","v":38.830662234237131},{"$f":"IF(COUNTBLANK(J42)>0,\"\",(H42/J42)*1000)","v":79.833817443028806},{"$f":"IF(COUNTBLANK(K42)>0,\"\",L41-K41/1000)","v":0.1116136100755704},0,{"$f":"IFERROR(IF(L42<K42/1000,1,0),)","v":0},{"$f":"M42+N42+SUM($O$3:O41)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,1,1]

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