{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Energy","Financials","datasheet","InfoText","Formula Reference"],"not_rendered":{"charts":10,"images":10,"macros":1,"external_links":0,"defined_names":9,"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":"Home","index":0,"n_rows":65,"n_cols":14,"rows_kept":65,"cut":false,"hidden":false,"merged":[[38,3,38,4],[24,1,24,7],[25,1,25,7],[23,1,23,7],[16,1,16,7],[26,1,26,7],[35,1,35,2],[22,1,22,7],[34,7,34,9],[27,9,27,11],[26,9,26,11],[25,9,25,11],[24,9,24,11],[23,9,23,11],[32,9,32,11],[31,9,31,11],[34,11,34,13],[30,9,30,11],[29,9,29,11],[28,9,28,11],[20,1,20,7],[21,1,21,7],[36,11,36,12],[36,13,36,14],[37,11,37,12],[37,13,37,14],[35,9,35,10],[39,9,39,10],[39,7,39,8],[38,9,38,10],[38,7,38,8],[36,9,36,10],[37,9,37,10],[37,7,37,8],[35,7,35,8],[36,7,36,8],[10,5,10,13],[9,5,9,13],[12,5,12,13],[13,5,13,13],[19,9,19,11],[18,9,18,11],[17,9,17,11],[16,9,16,11],[15,9,15,11],[15,1,15,7],[9,1,9,3],[14,1,14,11],[10,1,10,3],[17,1,17,7],[19,1,19,7],[12,1,12,3],[11,1,11,3],[11,5,11,13],[22,9,22,11],[21,9,21,11],[20,9,20,11],[13,1,13,3],[60,1,63,13],[35,11,35,12],[58,1,58,9],[57,1,57,9],[56,1,56,9],[49,1,49,9],[48,1,48,9],[47,1,47,9],[53,1,53,5],[52,1,52,5],[51,1,51,5],[42,1,42,2],[43,1,43,2],[44,1,44,2],[38,11,38,12],[38,13,38,14],[39,11,39,12],[39,13,39,14],[37,5,37,6],[36,3,36,4],[35,3,35,4],[35,5,35,6],[36,5,36,6],[55,1,55,7],[42,7,42,8],[42,9,42,10],[43,7,43,8],[43,9,43,10],[44,7,44,8],[44,9,44,10],[42,3,42,4],[43,3,43,4],[44,3,44,4],[44,5,44,6],[43,5,43,6],[42,5,42,6],[39,5,39,6],[38,5,38,6],[37,1,37,2],[36,1,36,2],[37,3,37,4],[39,1,39,2],[38,1,38,2],[39,3,39,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project",null,null,null,"1224 Hospital Avenue, Danbury, CT"]
[null,"Sample Site",null,null,null,"Version 1.0 / Facility #1 / Suppy Air System"]
[null,"Company Name",null,null,null,"XYZ Mechanical Contractor "]
[null,"Company Address",null,null,null,"33 Turner Road, Danbury, CT 06810"]
[null,"Phone / Email",null,null,null,"203-749-3158, your.name@XYZ.Contracting.com"]
[]
[null,null,null,null,null,null,null,null,null,"Value",null,null,null,"Unit"]
[null,"Belimo Actuator",null,null,null,null,null,null,{"$f":"MATCH(Actuator,datasheet!A:A,0)","v":4},"AFB24-SR"]
[null,"Belimo Actuator Power Consumption (Running)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!B:B,ActuatorRow),\"\")","v":"5.5 W"},{"$f":"IFERROR(LEFT(I18,FIND(\" \",I18)-1)+0,I18)","v":5.5},null,null,null,{"$f":"IFERROR(MID(I18,FIND(\" \",I18)+1,100),I18)","v":"W"}]
[null,"Belimo Actuator Power Consumption (Holding)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!C:C,ActuatorRow),\"\")","v":"3 W"},3,null,null,null,{"$f":"IFERROR(MID(I19,FIND(\" \",I19)+1,100),I19)","v":"W"}]
[null,"Operating Hours / Day",null,null,null,null,null,null,null,18,null,null,null,"hours"]
[null,"Operating Days / Week",null,null,null,null,null,null,null,7,null,null,null,"days"]
[null,"Percentage of Time (Running)",null,null,null,null,null,null,null,30,null,null,null,"%"]
[null,"Percentage of Time (Holding)",null,null,null,null,null,null,null,{"$f":"100-J22","v":70},null,null,null,"%"]
[null,"Number of Actuators on Jobsite",null,null,null,null,null,null,null,110,null,null,null,"#"]
[null,"State",null,null,null,null,null,null,null,"Connecticut"]
[null,"Job Site",null,null,null,null,null,null,null,"Commercial"]
[null,"Electricity Cost (Average)",null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Energy!$E$10:$G$61,MATCH(J25,ListStates,0),MATCH(J26,Energy!E8:G8,0)),\"\")","v":14.92},null,null,null,"¢/kWh"]
[null,"Competitor 1 Actuator Power Consumption (Running)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!G:G,ActuatorRow),\"\")","v":"9.6 W"},{"$f":"IFERROR(LEFT(I28,FIND(\" \",I28)-1)+0,I28)","v":9.6},null,null,null,{"$f":"IFERROR(MID(I28,FIND(\" \",I28)+1,100),I28)","v":"W"}]
[null,"Competitor 1 Actuator Power Consumption (Holding)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!H:H,ActuatorRow),\"\")","v":"3 W"},{"$f":"IFERROR(LEFT(I29,FIND(\" \",I29)-1)+0,I29)","v":3},null,null,null,"W"]
[null,"Competitor 2 Actuator Power Consumption (Running)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!L:L,ActuatorRow),\"\")","v":"7 W"},7,null,null,null,"W"]
[null,"Competitor 2 Actuator Power Consumption (Holding)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!M:M,ActuatorRow),\"\")","v":"5 W"},5,null,null,null,"W"]
[null,"Competitor 3 Actuator Power Consumption (Running)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!Q:Q,ActuatorRow),\"\")","v":"9.3 W"},9.3000000000000007,null,null,null,"W"]
[null,"Competitor 3 Actuator Power Consumption (Holding)",null,null,null,null,null,null,{"$f":"IFERROR(INDEX(datasheet!R:R,ActuatorRow),\"\")","v":"4.62 W"},4.62,null,null,null,"W"]
[]
[null,null,null,null,null,null,null,"Single Actuator",null,null,null,"Job Site"]
[null,"Brand",null,"Part Number",null,"Rated Torque",null,"Cons. kWh",null,"Cost",null,"Cons. kWh",null,"Cost"]
[null,"Belimo",null,{"$f":"Actuator","v":"AFB24-SR"},null,{"$f":"IFERROR(INDEX(datasheet!D:D,ActuatorRow),\"\")","v":"180 in-lb "},null,{"$f":"IFERROR((J18*$J$22+J19*$J$23)/100*$J$20*$J$21*52/1000,0)","v":24.57},null,{"$f":"IFERROR(H37*$J$27/100,0)","v":3.6658440000000003},null,{"$f":"IFERROR(H37*$J$24,0)","v":2702.7},null,{"$f":"IFERROR(J37*$J$24,0)","v":403.24284000000006}]
[null,"Competitor 1",null,{"$f":"IFERROR(INDEX(datasheet!F:F,ActuatorRow),\"\")","v":"MS7**"},null,{"$f":"IFERROR(INDEX(datasheet!I:I,ActuatorRow),\"\")","v":"175 in-lb"},null,{"$f":"IFERROR((J28*$J$22+J29*$J$23)/100*$J$20*$J$21*52/1000,0)","v":32.628960000000006},null,{"$f":"IFERROR(H38*$J$27/100,0)","v":4.8682408320000006},null,{"$f":"IFERROR(H38*$J$24,0)","v":3589.1856000000007},null,{"$f":"IFERROR(J38*$J$24,0)","v":535.50649152000005}]
[null,"Competitor 2",null,{"$f":"IFERROR(INDEX(datasheet!K:K,ActuatorRow),\"\")","v":"GCA**"},null,{"$f":"IFERROR(INDEX(datasheet!N:N,ActuatorRow),\"\")","v":"160 in-lb"},null,{"$f":"IFERROR((J30*$J$22+J31*$J$23)/100*$J$20*$J$21*52/1000,0)","v":36.691200000000002},null,5.4743270400000004,null,4036.0320000000002,null,602.17597440000009]
[null,"Competitor 3",null,{"$f":"IFERROR(INDEX(datasheet!P:P,ActuatorRow),\"\")","v":"M92**"},null,{"$f":"IFERROR(INDEX(datasheet!S:S,ActuatorRow),\"\")","v":"177 in-lb"},null,{"$f":"IFERROR((J32*$J$22+J33*$J$23)/100*$J$20*$J$21*52/1000,0)","v":39.469248000000007},null,5.8888118016000011,null,4341.6172800000004,null,647.76929817600012]
[]
[null,null,null,null,"Annual Energy Savings",null,null,null,"Annual Cost Savings (Cash Flow)"]
[null,"Competitor 1",null,{"$f":"IF(L38=0,\"\",L38-L37)","v":886.48560000000089},null,"kWh",null,{"$f":"IF(N38=0,\"\",N38-N37)","v":132.26365152},null,"$"]
[null,"Competitor 2",null,{"$f":"IF(L39=0,\"\",L39-L37)","v":1333.3320000000003},null,"kWh",null,{"$f":"IF(N39=0,\"\",N39-N37)","v":198.93313440000003},null,"$"]
[null,"Competitor 3",null,{"$f":"IF(L40=0,\"\",L40-L37)","v":1638.9172800000006},null,"kWh",null,{"$f":"IF(N40=0,\"\",N40-N37)","v":244.52645817600006},null,"$"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Unit"]
[null,"Incremental Investment For Belimo Actuators",null,null,null,null,null,null,null,null,null,230,null,"$"]
[null,"Discount Rate (Interest Rate On Invested Capital)",null,null,null,null,null,null,null,null,null,10,null,"%"]
[null,"Annual Inflation Rate On Electricity Costs",null,null,null,null,null,null,null,null,null,2,null,"%"]
[]
[null,"Investment Horizon",null,null,null,null,null,"5 years",null,"10 years",null,"15 years",null,"20 years"]
[null,"Accounting Rate Of Return",null,null,null,null,null,{"$f":"-(SUM(Financials!$C$31:G31)/5/SUM(Financials!$B$23:G23))","v":0.59852639497245663},null,{"$f":"-(SUM(Financials!$C$31:L31)/10/SUM(Financials!$B$23:L23))","v":0.6296739489350236},null,{"$f":"-(SUM(Financials!$C$31:Q31)/15/SUM(Financials!$B$23:Q23))","v":0.66298274452034989},null,{"$f":"-(SUM(Financials!$C$31:V31)/20/SUM(Financials!$B$23:V23))","v":0.69862148955144043}]
[null,"Net Present Value (NPV)",null,null,null,null,null,{"$f":"+Financials!$G$40","v":289.88325751709624},null,{"$f":"+Financials!$L$40","v":646.28782782694088},null,{"$f":"+Financials!$Q$40","v":890.62002337483818},null,{"$f":"+Financials!$V$40","v":1058.1213035333853}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Value",null,"Unit"]
[null,"Annual Carbon Dioxide Avoided",null,null,null,null,null,null,null,null,null,{"$f":"D43*0.000703*2204.62","v":1373.9178100808172},null,"pounds"]
[null,"Pounds of Coal Saved",null,null,null,null,null,null,null,null,null,{"$f":"D43*0.000703*2204.62/2.06573","v":665.10038101824409},null,"pounds"]
[null,"Equivalent Energy Savings in Switching to LED Bulbs for One Year",null,null,null,null,null,null,null,null,null,{"$f":"D43/37.2","v":23.830258064516151},null,"bulbs"]
[]
[null,"Copyright by BELIMO Aircontrols (USA), Inc., Danbury, CT, 2016. This is an estimating tool. Results are dependent on the accuracy of input values and specific plant details. For more accurate results, additional plant data and complex modeling software is necessary.                                                                                                 Power Consumption figures determined from published data, subject to change. "]
[]
[]
[]
[null,"V.2016"]

{"sheet":"Energy","index":1,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[[7,5,8,5],[7,6,8,6],[8,1,8,3],[7,4,8,4],[61,1,61,3],[60,1,60,3]]}
[]
[]
[]
[]
[null,"Operating Hours / Day",null,{"$f":"Home!J20","v":18},"hours",null,"Editable Field"]
[null,"Operating Days / Week",null,{"$f":"Home!J21","v":7},"days",null,"Label"]
[null,"Annual Operating Hours",null,{"$f":"(D5*D6)/7*365","v":6570}]
[null,null,null,null,"Residential","Commercial","Industrial"]
[null,"Census Divisions and States"]
[null,"Alabama",null,null,11.9,10.98,6.82]
[null,"Alaska",null,null,21.27,18.66,15.48]
[null,"Arizona",null,null,12.83,11.48,6.97]
[null,"Arkansas",null,null,10.38,8.6,6.81]
[null,"California",null,null,18,18.309999999999999,13.3]
[null,"Colorado",null,null,12.6,10.26,7.42]
[null,"Connecticut",null,null,20.399999999999999,14.92,12.19]
[null,"Delaware",null,null,13.23,10.07,7.62]
[null,"District of Columbia",null,null,13.47,11.85,8.83]
[null,"Florida",null,null,11.94,9.56,8.58]
[null,"Georgia",null,null,13.28,11.31,7.94]
[null,"Hawaii",null,null,30.04,27.3,23.46]
[null,"Idaho",null,null,10.67,8.08,7.17]
[null,"Illinois",null,null,12.56,9,6.44]
[null,"Indiana",null,null,11.15,9.5,6.72]
[null,"Iowa",null,null,13.57,10.61,7.29]
[null,"Kansas",null,null,12.33,10.220000000000001,7.65]
[null,"Kentucky",null,null,9.9600000000000009,9.14,5.68]
[null,"Lousiana",null,null,9.24,8.34,5.2]
[null,"Maine",null,null,15.42,12.32,7.5]
[null,"Maryland",null,null,13.92,10.92,7.91]
[null,"Massachusetts",null,null,17.87,14.5,12.87]
[null,"Michigan",null,null,15.3,11.22,8.06]
[null,"Minnesota",null,null,13.07,10.16,7.69]
[null,"Mississippi",null,null,11.16,10.37,7.1]
[null,"Missouri",null,null,12.59,10.43,7.51]
[null,"Montana",null,null,11.42,10.16,5.85]
[null,"Nebraska",null,null,12.2,9.66,8.34]
[null,"Nevada",null,null,12.01,8.8000000000000007,9.2799999999999994]
[null,"New Hampshire",null,null,17.760000000000002,14.2,11.74]
[null,"New Jersey",null,null,16.739999999999998,13.89,11.38]
[null,"New Mexico",null,null,13.32,11.3,6.62]
[null,"New York",null,null,18.760000000000002,16.149999999999999,6.15]
[null,"North Carolina",null,null,11.47,8.9499999999999993,7.05]
[null,"North Dakota",null,null,11.16,9.27,8.4]
[null,"Ohio",null,null,13.28,10.14,7.29]
[null,"Oklahoma",null,null,9.98,8.14,5.72]
[null,"Oregon",null,null,11.06,8.94,6.41]
[null,"Pennsylvania",null,null,14.21,9.41,7.15]
[null,"Rhode Island",null,null,17.59,14,11.96]
[null,"South Carolina",null,null,12.49,10.18,6.29]
[null,"South Dakota",null,null,11.76,9.3000000000000007,7.56]
[null,"Tennessee",null,null,10.32,10.25,7.31]
[null,"Texas",null,null,11.58,7.73,5.65]
[null,"Utah",null,null,11.94,9.11,7.02]
[null,"Vermont",null,null,17.07,14.41,10.25]
[null,"Virginia",null,null,11.66,8.19,7]
[null,"Washington",null,null,9.34,8.16,4.6100000000000003]
[null,"West Virginia",null,null,10.71,8.67,6.18]
[null,"Wisconsin",null,null,14.62,11.29,8.18]
[null,"Wyoming",null,null,11.62,9.25,6.7]
[null,"Custom Location"]
[null,"U.S. Total",null,null,12.98,11.06,7.3]

{"sheet":"Financials","index":2,"n_rows":46,"n_cols":22,"rows_kept":46,"cut":false,"hidden":false,"merged":[[46,1,46,11],[37,2,37,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
["Discount Rate:",{"$f":"Home!L49/100","v":0.1}]
["Finance Rate:",0.1]
["Reinvestment Rate:",0.1]
["Inflation Rate",{"$f":"Home!L50/100","v":0.02}]
[]
[" ","Today","End of\nYear 1","End of\nYear 2","End of\nYear 3","End of\nYear 4","End of\nYear 5","End of\nYear 6","End of\nYear 7","End of\nYear 8","End of\nYear 9","End of\nYear 10","End of\nYear 11","End of\nYear 12","End of\nYear 13","End of\nYear 14","End of\nYear 15","End of\nYear 16","End of\nYear 17","End of\nYear 18","End of\nYear 19","End of\nYear 20"]
["Date:",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[]
[]
["Single Investment",{"$f":"Home!L48*-1","v":-230},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Phased Investment",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Financed Investment",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal",{"$f":"SUM(B18:B20)","v":-230},{"$f":"SUM(C18:C20)","v":0},0,0,0,0,{"$f":"SUM(H18:H20)","v":0},{"$f":"SUM(I18:I20)","v":0},{"$f":"SUM(J18:J20)","v":0},{"$f":"SUM(K18:K20)","v":0},{"$f":"SUM(L18:L20)","v":0},{"$f":"SUM(M18:M20)","v":0},0,0,0,0,0,0,0,0,0]
["Rebate/Incentive Rec'd at Date",0]
["Subtotal Outflows",{"$f":"SUM(B21:B22)","v":-230},{"$f":"SUM(C21:C22)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(M21:M22)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
["Energy savings",null,{"$f":"Home!H43","v":132.26365152},{"$f":"C26*(1+$B$12)","v":134.9089245504},137.60710304140801,140.35924510223617,143.1664300042809,146.02975860436652,148.95035377645385,151.92936085198292,154.96794806902258,158.06730703040304,{"$f":"L26*(1+$B$12)","v":161.2286531710111},164.45322623443133,167.74229075911995,171.09713657430237,174.51907930578841,178.00946089190418,181.56965010974227,185.20104311193711,188.90506397417585,192.68316525365935]
["Maintenance savings",null,0,{"$f":"C27*(1+$B$12)","v":0},0,0,0,0,0,0,0,0,{"$f":"L27*(1+$B$12)","v":0},0,0,0,0,0,0,0,0,0]
["Rebates/incentives rec'd after Date",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Subtotal Inflows",null,{"$f":"SUM(C26:C28)","v":132.26365152},{"$f":"SUM(D26:D28)","v":134.9089245504},137.60710304140801,140.35924510223617,143.1664300042809,146.02975860436652,148.95035377645385,151.92936085198292,154.96794806902258,{"$f":"SUM(L26:L28)","v":158.06730703040304},{"$f":"SUM(M26:M28)","v":161.2286531710111},164.45322623443133,167.74229075911995,171.09713657430237,174.51907930578841,178.00946089190418,181.56965010974227,185.20104311193711,188.90506397417585,192.68316525365935]
[]
["Annual Cash Flow",{"$f":"B23+B29","v":-230},{"$f":"C23+C29","v":132.26365152},{"$f":"D23+D29","v":134.9089245504},137.60710304140801,140.35924510223617,143.1664300042809,146.02975860436652,148.95035377645385,151.92936085198292,154.96794806902258,158.06730703040304,{"$f":"M23+M29","v":161.2286531710111},164.45322623443133,167.74229075911995,171.09713657430237,174.51907930578841,178.00946089190418,181.56965010974227,185.20104311193711,188.90506397417585,192.68316525365935]
[]
["PV of Outflows (for SIR calculation)",{"$f":"SUM(B23)/(1+$B$9)^B$15","v":-230},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(M23)/(1+$B$9)^M$15","v":0},0,0,0,0,0,0,0,0,0]
["PV of Inflows (for SIR calculation)",{"$f":"B29/(1+$B$9)^B$15","v":0},120.23968319999999,111.49497896727271,103.38625322419833,95.867252989711176,88.895089135913992,82.429991744211151,76.43508325372305,70.876168107997742,65.721537700143358,60.941789503769293,{"$f":"M29/(1+$B$9)^M$15","v":56.509659358040608},52.399865950183113,48.588966608351612,45.055223582289678,41.77848004903224,38.74004513637535,35.922587308275325,33.310035504037117,30.887487467379863,28.641124742479509]
["Cumulative Cash Flows",{"$f":"B31","v":-230},{"$f":"B35+C31","v":-97.736348480000004},{"$f":"C35+D31","v":37.172576070399998},174.77967911180801,315.13892421404421,458.30535421832508,604.3351128226916,753.28546659914548,905.21482745112837,1060.1827755201509,1218.250082550554,{"$f":"L35+M31","v":1379.478735721565},{"$f":"M35+N31","v":1543.9319619559965},{"$f":"N35+O31","v":1711.6742527151164},{"$f":"O35+P31","v":1882.7713892894187},{"$f":"P35+Q31","v":2057.2904685952071},{"$f":"Q35+R31","v":2235.2999294871115},{"$f":"R35+S31","v":2416.8695795968538},{"$f":"S35+T31","v":2602.0706227087908},{"$f":"T35+U31","v":2790.9756866829666},{"$f":"U35+V31","v":2983.658851936626}]
["Annual Present Value",{"$f":"B31/(1+$B$9)^B15","v":-230},120.23968319999999,111.49497896727271,103.38625322419833,95.867252989711176,88.895089135913992,82.429991744211151,76.43508325372305,70.876168107997742,65.721537700143358,60.941789503769293,{"$f":"M31/(1+$B$9)^M15","v":56.509659358040608},52.399865950183113,48.588966608351612,45.055223582289678,41.77848004903224,38.74004513637535,35.922587308275325,33.310035504037117,30.887487467379863,28.641124742479509]
["Cumulative Present Value",{"$f":"B36","v":-230},{"$f":"B37+C36","v":-109.76031680000001},{"$f":"C37+D36","v":1.7346621672727025},105.12091539147103,200.98816838118222,289.88325751709624,372.31324926130742,448.74833251503048,519.62450062302821,585.34603832317157,646.28782782694088,{"$f":"L37+M36","v":702.79748718498149},{"$f":"M37+N36","v":755.19735313516458},{"$f":"N37+O36","v":803.78631974351617},{"$f":"O37+P36","v":848.8415433258059},{"$f":"P37+Q36","v":890.62002337483818},{"$f":"Q37+R36","v":929.36006851121351},{"$f":"R37+S36","v":965.28265581948881},{"$f":"S37+T36","v":998.59269132352597},{"$f":"T37+U36","v":1029.4801787909059},{"$f":"U37+V36","v":1058.1213035333853}]
[null,null,"*Note: Certain Returns Vary Depending on the Length of the Analysis Term*"]
[null,"10 Year","1 Year","2 Year","3 Year","4 Year","5 Year","6 Year","7 Year","8 Year","9 Year","10 Year","11 Year","12 Year","13 Year","14 Year","15 Year","16 Year","17 Year","18 Year","19 Year","20 Year"]
["Net Present Value (NPV)",{"$f":"SUM(B36:L36)","v":646.28782782694088},{"$f":"$B$36+SUM($C$36:C36)","v":-109.76031680000001},{"$f":"$B$36+SUM($C$36:D36)","v":1.7346621672726883},{"$f":"$B$36+SUM($C$36:E36)","v":105.12091539147104},{"$f":"$B$36+SUM($C$36:F36)","v":200.98816838118222},{"$f":"$B$36+SUM($C$36:G36)","v":289.88325751709624},{"$f":"$B$36+SUM($C$36:H36)","v":372.31324926130742},{"$f":"$B$36+SUM($C$36:I36)","v":448.74833251503048},{"$f":"$B$36+SUM($C$36:J36)","v":519.62450062302821},{"$f":"$B$36+SUM($C$36:K36)","v":585.34603832317157},{"$f":"$B$36+SUM($C$36:L36)","v":646.28782782694088},{"$f":"$B$36+SUM($C$36:M36)","v":702.79748718498149},{"$f":"$B$36+SUM($C$36:N36)","v":755.19735313516458},{"$f":"$B$36+SUM($C$36:O36)","v":803.78631974351629},{"$f":"$B$36+SUM($C$36:P36)","v":848.84154332580601},{"$f":"$B$36+SUM($C$36:Q36)","v":890.62002337483818},{"$f":"$B$36+SUM($C$36:R36)","v":929.36006851121351},{"$f":"$B$36+SUM($C$36:S36)","v":965.28265581948881},{"$f":"$B$36+SUM($C$36:T36)","v":998.59269132352597},{"$f":"$B$36+SUM($C$36:U36)","v":1029.4801787909059},{"$f":"$B$36+SUM($C$36:V36)","v":1058.1213035333853}]
["Simple Payback Period (SPP)",{"$f":"-B31/C31","v":1.7389509313919176}]
["Return on Investment (ROI)",{"$f":"-C31/B31","v":0.57505935443478262}]
["Internal Rate of Return (IRR)",{"$f":"IRR($B$31:$L$31,0.1)","v":0.58819373700920652},{"$f":"IRR($B$31:$C$31,0.1)","v":-0.42494064556521738},{"$f":"IRR($B$31:$D$31,0.1)","v":0.10559682409721427},{"$f":"IRR($B$31:$E$31,0.1)","v":0.34328870690096047},{"$f":"IRR($B$31:$F$31,0.1)","v":0.45689277740824519},{"$f":"IRR($B$31:$G$31,0.1)","v":0.51568783195697243},{"$f":"IRR($B$31:$H$31,0.1)","v":0.54799443327640796},{"$f":"IRR($B$31:$I$31,0.1)","v":0.56652616625420316},{"$f":"IRR($B$31:$J$31,0.1)","v":0.5774888752872458},{"$f":"IRR($B$31:$K$31,0.1)","v":0.5841191987746257},{"$f":"IRR($B$31:$L$31,0.1)","v":0.58819373700920652},{"$f":"IRR($B$31:$I$31,0.1)","v":0.56652616625420316},{"$f":"IRR($B$31:$J$31,0.1)","v":0.5774888752872458},{"$f":"IRR($B$31:$K$31,0.1)","v":0.5841191987746257},{"$f":"IRR($B$31:$L$31,0.1)","v":0.58819373700920652},{"$f":"IRR($B$31:$I$31,0.1)","v":0.56652616625420316},{"$f":"IRR($B$31:$J$31,0.1)","v":0.5774888752872458},{"$f":"IRR($B$31:$K$31,0.1)","v":0.5841191987746257},{"$f":"IRR($B$31:$L$31,0.1)","v":0.58819373700920652},{"$f":"IRR($B$31:$I$31,0.1)","v":0.56652616625420316},{"$f":"IRR($B$31:$J$31,0.1)","v":0.5774888752872458}]
["Modified Internal Rate of Return (MIRR)",{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":0.25743220582134407},{"$f":"MIRR($B$31:$C$31,$B$10,$B$11)","v":-0.42494064556521738},{"$f":"MIRR($B$31:$D$31,$B$10,$B$11)","v":0.10414031327623352},{"$f":"MIRR($B$31:$E$31,$B$10,$B$11)","v":0.24705014643824619},{"$f":"MIRR($B$31:$F$31,$B$10,$B$11)","v":0.28699560297629434},{"$f":"MIRR($B$31:$G$31,$B$10,$B$11)","v":0.29487630645533081},{"$f":"MIRR($B$31:$H$31,$B$10,$B$11)","v":0.29144262125672937},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":0.28390479078056718},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":0.27506456698896975},{"$f":"MIRR($B$31:$K$31,$B$10,$B$11)","v":0.2660793393084171},{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":0.25743220582134407},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":0.28390479078056718},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":0.27506456698896975},{"$f":"MIRR($B$31:$K$31,$B$10,$B$11)","v":0.2660793393084171},{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":0.25743220582134407},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":0.28390479078056718},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":0.27506456698896975},{"$f":"MIRR($B$31:$K$31,$B$10,$B$11)","v":0.2660793393084171},{"$f":"MIRR($B$31:$L$31,$B$10,$B$11)","v":0.25743220582134407},{"$f":"MIRR($B$31:$I$31,$B$10,$B$11)","v":0.28390479078056718},{"$f":"MIRR($B$31:$J$31,$B$10,$B$11)","v":0.27506456698896975}]
["Savings-Investment Ratio (SIR)",{"$f":"SUM($B$34:$L$34)/(ABS(SUM(B33:L33)))","v":3.8099470775084385},{"$f":"SUM($B34:C34)/ABS(SUM($B33:C33))","v":0.52278123130434773},{"$f":"SUM($B34:D34)/ABS(SUM($B33:D33))","v":1.0075420094229248},{"$f":"SUM($B34:E34)/ABS(SUM($B33:E33))","v":1.4570474582237871},{"$f":"SUM($B34:F34)/ABS(SUM($B33:F33))","v":1.873861601657314},{"$f":"SUM($B34:G34)/ABS(SUM($B33:G33))","v":2.2603619892047662},{"$f":"SUM($B34:H34)/ABS(SUM($B33:H33))","v":2.6187532576578585},{"$f":"SUM($B34:I34)/ABS(SUM($B33:I33))","v":2.9510797065870888},{"$f":"SUM($B34:J34)/ABS(SUM($B33:J33))","v":3.2592369592305572},{"$f":"SUM($B34:K34)/ABS(SUM($B33:K33))","v":3.5449827753181373},{"$f":"SUM($B34:L34)/ABS(SUM($B33:L33))","v":3.8099470775084385},{"$f":"SUM($B34:M34)/ABS(SUM($B33:M33))","v":4.0556412486303541},{"$f":"SUM($B34:N34)/ABS(SUM($B33:N33))","v":4.2834667527615853},{"$f":"SUM($B34:O34)/ABS(SUM($B33:O33))","v":4.4947231293196364},{"$f":"SUM($B34:P34)/ABS(SUM($B33:P33))","v":4.6906154057643743},{"$f":"SUM($B34:Q34)/ABS(SUM($B33:Q33))","v":4.8722609711949483},{"$f":"SUM($B34:R34)/ABS(SUM($B33:R33))","v":5.0406959500487547},{"$f":"SUM($B34:S34)/ABS(SUM($B33:S33))","v":5.1968811122586471},{"$f":"SUM($B34:T34)/ABS(SUM($B33:T33))","v":5.3417073535805475},{"$f":"SUM($B34:U34)/ABS(SUM($B33:U33))","v":5.4760007773517652},{"$f":"SUM($B34:V34)/ABS(SUM($B33:V33))","v":5.6005274066668926}]
[null,{"$f":"+Home!B65","v":"V.2016"}]

{"sheet":"datasheet","index":3,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[0,4,0,8],[0,0,0,3],[0,14,0,18],[0,9,0,13]]}
["BELIMO",null,null,null,"Honeywell",null,null,null,null,"Siemens",null,null,null,null,"Johnson Controls"]
["Actuators","Running","Holding","Torque","Competitor 1","Part Number","Running","Holding","Torque","Competitor 2","Part Number","Running","Holding","Torque","Competitor 3","Part Number","Running","Holding","Torque"]
["AFB24","5 W","2.5 W","180 in-lb","MS8120A…","MS8**","24 W","4.8 W","175 in-lb","GCA121.1U","GCA**","7 W","5 W","160 in-lb","M9220-BGA-3","M92**","14.76 W","4.62 W","177 in-lb"]
["AFB24-SR","5.5 W","3 W","180 in-lb ","MS7120A…","MS7**","9.6 W","3 W","175 in-lb","GCA151.1U","GCA**","7 W","5 W","160 in-lb","M9220-GGA-3","M92**","9.3 W","4.62 W","177 in-lb"]
["AFB24-MFT","7.5 W","3 W","180 in-lb ","MS7520A…","MS7**","9.6 W","3 W","175 in-lb","GCA163.1U","GCA**","7 W","5 W","160 in-lb","M9220-HGA-3","M92**","9.3 W","4.62 W","177 in-lb"]
["AFBUP","7 W","3.5 W","180 in-lb ","MS4120A…","MS4**","36 W","7.8 W","175 in-lb","GCA221.1U","GCA**","8 W","6 W","160 in-lb","M9220-BAA-3","M92**","18 W","9.36 W","177 in-lb"]
["AHB24-3-100","2 W","0.5 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHB24-3-200","2 W","0.5 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHKX24-MFT-100","11 W","3 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHQB24-1-100","13 W","1.5 W","44 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHQB24-MFT-100","13 W","1.5 W","44 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHX120-3-300","2.5 W","0.5 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHX24-3-300","2 W","0.5 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHX24-MFT-100","3.5 W","1.3 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHX24-MFT-200","3.5 W","1.3 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AHX24-MFT-300","3.5 W","1.3 W","101 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["AMB24-3","2.5 W","0.5 W","180 in-lb ","MN6120A…","MN6**","6 W","2 W","175 in-lb","GBB171.1U","GBB**","7 W","1.1 W","177 in-lb","M9116-AGA-2","M91**","3.48 W","0.54 W","140 in-lb"]
["AMB24-SR","2.5 W","0.4 W","180 in-lb ","MN7220A","MN7**","6 W","2 W","175 in-lb","GBB166.1U","GBB**","8 W","1.1 W","177 in-lb","M9116-GGC-2","M91**","3.84 W","0.9 W","140 in-lb"]
["AMB24-MFT","3.5 W","1.3 W","180 in-lb ","M6184D…","M61**","9 W","2 W","150 in-lb","GBB163.1U","GBB**","8 W","1.1 W","177 in-lb","M9116-GGA-2","M91**","3.84 W","0.9 W","140 in-lb"]
["AMCX24-MFT","4 W","1.25 W","180 in-lb ","M6184D…","M61**","9 W","2 W","--","--","--","-- ","-- ","177 in-lb","--","--","--","--","--"]
["AMQB24-1","15 W","1.5 W","140 in-lb ","--","--","--","--","--","--","--","-- ","-- ","177 in-lb","--","--","--","--","--"]
["AMQB24-MFT","15 W","1.5 W","140 in-lb ","--","--","--","--","--","--","--","-- ","-- ","177 in-lb","--","--","--","--","--"]
["AMX120-3","3 W","0.6 W","180 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["CMB120-3","1.5 W","1 W","18 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["CMB24-3","1 W","0.2 W","18 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","M9102-AGA-2","M91**","1.26 W","0 W","18 in-lb"]
["CMB24-SR-R","1.5 W","0.5 W","18 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","M9102-GGA-2","M91**","2.16 W","0.6 W","18 in-lb"]
["EFB120","9.5 W","4.5 W","270 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["EFB24","9.5 W","4.5 W","270 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["EFB24-SR","8 W","4.5 W","270 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["EFB24-MFT","9.5 W","4.5 W","270 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["GKB24-3","12 W","3 W","360 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["GKX24-MFT","12 W","3 W","360 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["GMB24-3","4 W","2 W","360 in-lb ","MN6134A…","MN6**","9 W","2 W","300 in-lb","GIB171.1U","GIB**","7 W","1.1 W","310 in-lb","M9132-AGA-2","M91**","3.9 W","0.9 W","280 in-lb"]
["GMB24-SR","4.5 W","2 W","360 in-lb ","M7294A","M72**","9 W","2 W","300 in-lb","GIB166.1U","GIB**","8 W","1.1 W","310 in-lb","M9132-GGA-2","M91**","3.9 W","0.9 W","280 in-lb"]
["GMB24-MFT","4.5 W","1.5 W","360 in-lb ","--","--","--","--","--","GIB164.1U","GIB**","8 W","1.1 W","310 in-lb","M9132-HGA-2","M91**","3.9 W","0.9 W","280 in-lb"]
["GMX120-3","4 W","2 W","360 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LF120 US","5.5 W","3.5 W","35 in-lb ","MS4105A","MS4**","9 W","4.8 W","44 in-lb","GMA221.1U","GMA**","7 W","4 W","62 in-lb","M9208-BAA-3","M92**","3.6 W","2.16 W","70 in-lb"]
["LF230 US","5 W","3 W","35 in-lb ","MS4105A","MS4**","9 W","4.8 W","44 in-lb","GMA221.1U","GMA**","7 W","4 W","62 in-lb","M9208-BDA-3","M92**","5.52 W","4.14 W","70 in-lb"]
["LF24 US","5 W","2.5 W","35 in-lb ","MS8105A","MS8**","9 W","4.8 W","44 in-lb","GMA121.1U","GMA**","5 W","4 W","62 in-lb","M9208-BGA-3","M92**","3.66 W","0.72 W","70 in-lb"]
["LF24-3 US","2.5 W","1 W","35 in-lb ","MS7505A","MS7**","6 W","3 W","44 in-lb","GMA131.1U","GMA**","5 W","4 W","62 in-lb","M9208-AGA-2","M92**","4.74 W","3.3 W","70 in-lb"]
["LF24-SR US","2.5 W","1 W","35 in-lb ","MS7505A","MS7**","6 W","3 W","44 in-lb","GMA151.1U","GMA**","5 W","4 W","62 in-lb","M9208-GGA-2","M92**","4.74 W","3.3 W","70 in-lb"]
["LF24-MFT US","2.5 W","1 W","35 in-lb ","MS7505A","MS7**","6 W","3 W","44 in-lb","GMA163.1U","GMA**","5 W","4 W","62 in-lb","M9208-GGA-2","M92**","4.74 W","3.3 W","70 in-lb"]
["LHB24-3-100","1.5 W","0.5 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHB24-3-200","1.5 W","0.5 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHQB24-1-100","12 W","1.5 W","22 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHQB24-MFT-100","12 W","1.5 W","22 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX120-3-100","2.5 W","0.5 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX120-3-200","2.5 W","0.5 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX120-3-300","2.5 W","0.5 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX24-3-300","1.5 W","0.5 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX24-MFT-100","2.5 W","1.2 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX24-MFT-200","2.5 W","1.2 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LHX24-MFT-300","2.5 W","1.2 W","34 lbf ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LMB24-3","1.5 W","0.2 W","45 in-lb ","ML6161L","ML6**","1.08 W","0 W","35 in-lb","GEB131.1U","GEB**","2.3 W","1 W","44 in-lb","M9106-AGC-2","M91**","1.5 W","0 W","53 in-lb"]
["LMB24-SR","1.5 W","0.4 W","45 in-lb ","ML7161A","ML7**","3.24 W","0 W","35 in-lb","GDE161.1P","GDE**","3.3 W","1 W","44 in-lb","M9106-GGA-2","M91**","1.92 W","0.3 W","53 in-lb"]
["LMB24-MFT","2.5 W","1.2 W","45 in-lb ","M9164","M91**","6 W","0 W","35 in-lb","--","--","-- ","-- ","--","M9106-IGA-2","M91**","1.68 W","0.3 W","53 in-lb"]
["LMCB24-3","1.5 W","0.2 W","45 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LMQB24-1","13 W","1.5 W","35 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LMQB24-MFT","13 W","1.5 W","35 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LMX120-3","2 W","0.5 W","45 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LMX24-MFT","2.5 W","1.2 W","45 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LUB24-3","1 W","0.5 W","27 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LUX120-3","3 W","1.5 W","27 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["LUX24-MFT","2.5 W","1.2 W","27 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NFB24","6 W","2.5 W","90 in-lb ","MS8110A","MS8**","18 W","4.8 W","88 in-lb","GMA121.1U","GMA**","5 W","4 W","62 in-lb","M9210-BGA-3","M92**","10.62 W","3.06 W","89 in-lb"]
["NFB24-SR","3.5 W","2.5 W","90 in-lb ","MS7510A","MS7**","8.4 W","3 W","88 in-lb","GMA151.1U","GMA**","5 W","4 W","62 in-lb","M9210-CGA-3","M92**","5.76 W","3.6 W","89 in-lb"]
["NFB24-MFT","6.5 W","3 W","90 in-lb ","MS7510A","MS7**","8.4 W","3 W","88 in-lb","GMA163.1U","GMA**","5 W","4 W","62 in-lb","M9210-HGA-3","M92**","5.76 W","3.6 W","89 in-lb"]
["NFBUP","6 W","2.5 W","90 in-lb ","MS4110A","MS4**","27 W","7.8 W","88 in-lb","GMA221.1U","GMA**","7 W","4 W","62 in-lb","M9210-BDA-3","M92**","20.7 W","12.42 W","89 in-lb"]
["NKQB24-1","11 W","3 W","54 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NKQX24-MFT","11 W","3 W","54 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NMB24-3","2 W","0.2 W","90 in-lb ","ML6174B","ML6**","1.44 W","0 W","90 in-lb","GLB131.1P","GLB**","2.3 W","1 W","88 in-lb","M9109-AGA-2","M91**","1.5 W","0 W","80 in-lb"]
["NMB24-SR","2.5 W","0.4 W","90 in-lb ","ML7174A","ML7**","3.24 W","0 W","70 in-lb","GLB161.1P","GLB**","3.3 W","1 W","88 in-lb","M9109-GGA-2","M91**","1.92 W","0.3 W","80 in-lb"]
["NMB24-MFT","3.5 W","1.3 W","90 in-lb ","M9174","M91**","7.2 W","0 W","75 in-lb","GLB163.1P","GLB**","3.3 W","1 W","88 in-lb","M9108-HGA-2","M91**","1.92 W","0.3 W","80 in-lb"]
["NMCB24-3","2 W","0.2 W","90 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NMCX24-MFT","3.5 W","1.25 W","90 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NMQB24-1","13 W","1.5 W","70 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NMQB24-MFT","13 W","1.5 W","70 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["NMX120-3","3.5 W","0.6 W","90 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["TFB120","2.5 W","1.3 W","22 in-lb ","MS4103A","MS4**","8 W","2 W","27 in-lb","GQD221.1U","GQD**","10 W","7 W","20 in-lb","M9203-BUA-2","M92**","4.32 W","1.44 W","27 in-lb"]
["TFB24","2 W","1.3 W","22 in-lb ","MS8103A","MS8**","5.4 W","2 W","27 in-lb","GQD121.1P","GQD**","6.5 W","4 W","20 in-lb","M9203-BGA-2","M92**","3 W","1.5 W","27 in-lb"]
["TFB24-3","2.5 W","1 W","22 in-lb ","MS7503A","MS7**","5.4 W","2 W","27 in-lb","GQD131.1P","GQD**","4 W","3 W","20 in-lb","M9203-AGA-2","M92**","2.82 W","1.62 W","27 in-lb"]
["TFB24-SR","2 W","1 W","22 in-lb ","MS7503A","MS7**","5.4 W","2 W","27 in-lb","GQD151.1P","GQD**","4.5 W","3.5 W","20 in-lb","M9203-GGA-2","M92**","2.82 W","1.62 W","27 in-lb"]
["TFB24-MFT","2.5 W","1 W","22 in-lb ","MS7503A","MS7**","5.4 W","2 W","27 in-lb","GQD151.1P","GQD**","4.5 W","3.5 W","20 in-lb","M9203-GGA-2","M92**","2.82 W","1.62 W","27 in-lb"]
["FSAF120 US","9.5 W","3.5 W","133 in-lb ","MS4120F...","MS4**","35 W","10 W","180 in-lb","GGD221 series","GGD*","150 W","10 W","142 in-lb","--","--","--","--","--"]
["FSAF230 US","11 W","3.5 W","133 in-lb ","MS4620F…","MS4**","35 W","10 W","180 in-lb","GGD321 series","GGD*","150 W","10 W","142 in-lb","--","--","--","--","--"]
["FSAF24 US","7.5 W","2 W","133 in-lb ","MS8120F…","MS8**","45 W","10 W","180 in-lb","GGD221 series","GGD*","150 W","10 W","142 in-lb","--","--","--","--","--"]
["FSAF24-BAL US","6.5 W","3 W","133 in-lb ","--","--","--","--","--","--","--","-- ","-- ","--","--","--","--","--","--"]
["FSLF120 US","14 W","4.5 W","30 in-lb ","MS4104F…","MS4**","18 W","9 W","30 in-lb","GND221 series","GND**","20 W","9 W","53 in-lb","--","--","--","--","--"]
["FSLF230 US","14W","4 W","30 in-lb ","MS4604F…","MS4**","18 W","9 W","30 in-lb","GND321 series","GND**","20 W","9 W","53 in-lb","--","--","--","--","--"]
["FSLF24 US","14 W","2.5 W","30 in-lb ","MS8104F…","MS8**","9.6 W","4.8 W","30 in-lb","GND121 series","GND**","12 W","6 W","53 in-lb","--","--","--","--","--"]
["FSNF120 US","19 W","6 W","70 in-lb ","MS4109F…","MS4**","233 W","7 W","80 in-lb","GGD221 series","GGD*","150 W","10 W","142 in-lb","--","--","--","--","--"]
["FSNF230 US","20 W","6 W","70 in-lb ","MS4609F…","MS4**","23 W","7 W","80 in-lb","GGD321 series","GGD*","150 W","10 W","142 in-lb","--","--","--","--","--"]
["FSNF24 US","17 W","4 W","70 in-lb ","MS8109F…","MS8**","13.8 W","4.2 W","80 in-lb","GGD221 series","GGD*","150 W","10 W","142 in-lb","--","--","--","--","--"]
["FSTF120 US","2 W","1.5 W","18 in-lb ","MS4104F…","MS4**","18 W","9 W","30 in-lb","GND221 series","GND**","20 W","9 W","53 in-lb","--","--","--","--","--"]

{"sheet":"InfoText","index":4,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Sheet","Cell Address","Information Displayed"]
["Home","$H$36","Formula = J18*J22+J19*J23/100*J20*J21*52/1000"]
["Home","$J$36","Formula=H37*J27"]
["Home","$L$36","Formula=H37*J24"]
["Home","$N$36","Formula=J37*J24"]
["Home","$F$42","Formula=L38-L37"]
["Home","$L$42","Formula=N38-N37"]
["Home","$H$25","Visit the Energy Tab to create your own \"Custom Location\" by entering the data found at http://www.eia.gov/electricity"]
["Home","$F$53","The life-cycle savings of an energy improvement divided by the initial investment. (For every dollar invested in an energy improvement, how many dollars will be saved over the life of the improvement in today’s dollars)\n\n=+Financials!G45"]
["Home","$F$54","Net present value is the present value of net cash inflows generated by a project including salvage value, if any, less the initial investment on the project. It is one of the most reliable measures used in capital budgeting because it accounts for time value of money by using discounted cash inflows.\nBefore calculating NPV, a target rate of return is set which is used to discount the net cash inflows from a project. Net cash inflow equals total cash inflow during a period less the expenses directly incurred on generating the cash inflow.\n\nFormula =+Financials!$G$40"]
["Home","$H$27","check:\nhttp://www.eia.gov/electricity"]
["Home","$J$48","Enter the incremental costs for Belimo actuators over competetive actuators. If there are actuators installed in the plant that will be replaced by Belimo Actuators, the whole replacement costs have to be considered."]
["Home","$J$49","This depends on the finance instrument of the investment. If the project is financed by a mortgage with an interest rate of 4%, then enter 4. Alternatively, it could be financed by a bank loan or simply by cash that's on an organizations balance sheet. Some companies are using a so called internal Hurdle Rate. "]
["Home","$J$50","This is the inflation rate that is predicted for the cost of electricity. Some forecasts predict this to between 3 and 4% annually, over the next decade."]
["Home","$J$57","calculation according to EPA www.epa.gov"]
["Home","$J$58","calculation according to EPA www.epa.gov"]
["Home","$J$59","based on annual consumption of 12,258 kWh per home according to EPA www.epa.gov"]
["Energy","$D$61","check:  http://www.eia.gov/electricity"]
["Financials","$B$12","This is the inflation rate that is predicted for the cost of electricity. Some forecasts predict this to between 3 and 4% annually, over the next decade.\n\nFormula =Home!L50/100"]
["Financials","$B$18","Formula =Home!L48*-1"]
["Financials","$B$9","This depends on the finance instrument of the investment. If the project is financed by a mortgage with an interest rate of 4%, then enter 4. Alternatively, it could be financed by a bank loan or simply by cash that's on an organizations balance sheet. Some companies are using a so called internal Hurdle Rate. \n\nFormula  =Home!L49/100"]
["Financials","$C$26","Formula =Home!H43"]

{"sheet":"Formula Reference","index":5,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":true,"merged":[[1,1,1,9]]}
[]
[null,"COST COMPARISON"]
[]
[null,2," …POWER DRAW (W) RUNNING FSTF120 US"]
[null,1.5," …POWER DRAW (W) HOLDING FSTF120 US"]
[null,18," …POWER DRAW (W) RUNNING MS4104 Series "]
[null,9," … POWER DRAW (W) HOLDING MS4104 Series"]
[null,24," …AVERAGE HRS OF OPERATION PER DAY"]
[null,7," …AVG. DAYS OF OPERATION PER WEEK "]
[null,{"$f":"B9*B8","v":168}," ...HOURS/WK OF OCCUPANCY/OPERATION (HRSOCC)"]
[null,0.995," …PERCENTAGE OF TIME HOLDING"]
[null,5.0000000000000001E-3," …PERCENTAGE OF TIME RUNNING",null,null,null,null,null,"Soure (7/15/14):"]
[null,0.104,"...ELECTRICITY UNIT ($) COST/KWHR (NAT'L AVE. COMMERCIAL)",null,null,null,null,null,"http://www.eia.gov/electricity/monthly/epm_table_grapher.cfm?t=epmt_5_6_a "]
[null,52," ...WEEKS/YEAR OF BUILDING OPERATION (WPY)"]
[]
[null,"FSTF120 US COST OF OPERATION",null,null,null,null,null,"RUNNING","HOLDING"]
[null,"FSTF120 US KW - DEMAND=============================================",null,null,null,null,null,{"$f":"B4/1000","v":2E-3},{"$f":"B5/1000","v":1.5E-3},"KW"]
[null,"KW USED * ELECCOST =============================================",null,null,null,null,null,{"$f":"H17*B13","v":2.0799999999999999E-4},{"$f":"I17*B13","v":1.56E-4},"KW COST"]
[null,"FSTF120 US KWH USAGE - CONSUMPTION=============================================",null,null,null,null,null,{"$f":"((H17)*B10*B14)","v":17.472000000000001},{"$f":"(I17)*B10*B14","v":13.103999999999999},"KWH"]
[null,"KWH USED * ELECCOST =============================================",null,null,null,null,null,{"$f":"H19*B13*B12","v":9.0854400000000002E-3},{"$f":"I19*B13*B11","v":1.3560019199999997},"KWH COST"]
[null,"TOTAL COST ===============================================",null,null,null,null,null,{"$f":"H20+H18","v":9.29344E-3},{"$f":"I20+I218","v":1.3560019199999997},null,{"$f":"SUM(H21:I21)","v":1.3652953599999997}]
[]
[null,"MS4104.. Cost Of Operation"]
[null,"MS4104.. KW - DEMAND=============================================",null,null,null,null,null,{"$f":"B6/1000","v":1.7999999999999999E-2},{"$f":"(B7/1000)","v":8.9999999999999993E-3},"KW"]
[null,"KW USED * ELECCOST =============================================",null,null,null,null,null,{"$f":"H24*B13","v":1.8719999999999997E-3},{"$f":"I24*B13","v":9.3599999999999987E-4},"KW COST"]
[null,"MS4104.. USAGE - CONSUMPTION=============================================",null,null,null,null,null,{"$f":"H24*B10*B14","v":157.24799999999999},{"$f":"(I24)*B10*B14","v":78.623999999999995},"KWH"]
[null,"KWH USED * ELECCOST =============================================",null,null,null,null,null,{"$f":"H26*B13*B12","v":8.1768959999999988E-2},{"$f":"I26*B13*B11","v":8.1360115199999985},"KWH COST"]
[null,"TOTAL COST ===============================================",null,null,null,null,null,{"$f":"H27+H25","v":8.3640959999999986E-2},{"$f":"I27+I25","v":8.1369475199999979},null,{"$f":"SUM(H28:I28)","v":8.2205884799999982}]
[]
[null,"ENERGY SAVINGS PER ACTUATOR"]
[null,"KWH CONSUMPTION SAVINGS =========================================",null,null,null,null,null,{"$f":"H26-H19","v":139.77599999999998},{"$f":"I26-I19","v":65.52},"KWH"]
[null,"KW DEMAND SAVINGS ======================================",null,null,null,null,null,{"$f":"H24-H17","v":1.6E-2},{"$f":"I24-I17","v":7.4999999999999997E-3},"KW"]
[null,"TOTAL COST SAVINGS ====================================",null,null,null,null,null,{"$f":"H28-H21","v":7.4347519999999986E-2},{"$f":"I28-I21","v":6.7809455999999981},null,{"$f":"SUM(H33:I33)","v":6.855293119999998}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"1-(K21/K28)","v":0.83391756401361672}]
[null,"TOTAL ENERGY SAVINGS "]
[null,"SAVINGS PER ACTUATOR * 150 ACTUATORS ON JOBSITE =========",null,null,null,null,null,{"$f":"H33*150","v":11.152127999999998},{"$f":"I33*150","v":1017.1418399999998},"YEARLY SAVINGS (ENERGY COST)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"SUM(H36:I36)","v":1028.2939679999997},"TOTAL YEARLY SAVINGS (ENERGY COST)"]