{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["Home","Instructions","Simple_Payback","Cost_of_Waiting","Procrastination","Footcandles_Recom","Hi-Bay_Watts","Lumen_Comparison","ABV3_Hi-bay_Retrofit","ABV3_Hi-bay_Retrofit_(2-Option)","LED_Lamp_Chart","HID_Hi_Watt_to_LED_Lamp","HID_Low_Watt_to_LED_Lamp","Tube_System_Wattages","LED_Tube_Type-A","LED_Tube_Type-B","LED_Tube_Type-C","Fixture_Lumens","Fixture_vs_Tube","Generic_Payback_Tool","Generic_2-Option","Multiple_Systems","Simple_Layouts","Energy_Rates","Environmental","AC_Savings","Cost_Breakdown","Cost_of_Ownership","IES_file_generator","Rebates","Asset_Increase","Disclaimer"],"not_rendered":{"charts":17,"images":26,"macros":1,"external_links":8,"defined_names":116,"comments":12,"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":37,"n_cols":4,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,1,1,3],[8,1,8,2],[16,1,16,2],[23,1,23,2]]}
[]
[null,"\n"]
[null,"#","Version 2.0 October 2020","Type "]
[null,1,"Instructions","Reference"]
[null,2,"Simple LED Payback","Cost Calculator"]
[null,"3A","Simple Cost of Waiting Estimate","Qualification"]
[null,"3B","Cost of Procrastination","Qualification"]
[null,4,"Recommended Light Levels","Reference"]
[null,"Industrial/Warehouse"]
[null,5,"Reference Sheet for Hi Bay Wattages","Reference"]
[null,6,"System Lumen Comparison Tool","Chart"]
[null,7,"Albeo ABV3 Fixture Retrofit","Cost Calculator"]
[null,8,"Albeo ABV3 2-Option Comparison","Cost Calculator"]
[null,9,"HID-LED Lamp Replacement Chart","Reference"]
[null,10,"HID Replacement Lamp Calculator (Hi-watt)","Cost Calculator"]
[null,11,"HID Replacement Lamp Calculator (Low-watt)","Cost Calculator"]
[null,"Commercial/Office (Fluorescent)"]
[null,12,"Reference Sheet for Tube Wattages (offices)","Reference"]
[null,13,"LED Type A Tube Calculator","Cost Calculator"]
[null,14,"LED Type B Tube Calculator","Cost Calculator"]
[null,15,"LED Type C Tube Calculator","Cost Calculator"]
[null,16,"Fluorescent Fixture Lumens Calculator","Light Level Calculator"]
[null,17,"Fixture vs Tube Cost of Ownership","Cost Calculator"]
[null,"Supporting Calculators"]
[null,17,"Generic  Payback Tool","Cost Calculator"]
[null,16,"Generic 2-Option Comparison","Cost Calculator"]
[null,17,"Multiple Systems Calculator","Cost Calculator"]
[null,18,"Lighting System Cost Breakdown","Cost Calculator"]
[null,19,"Cost of Ownership Comparison","Cost Calculator"]
[null,20,"Simple Lighting Layouts","Lighting Layout Tool"]
[null,21,"Energy Rates By State","Reference"]
[null,22,"Environmental Impact Calculator","Environmental Impact"]
[null,23,"A/C Savings Calculator","HVAC Savings"]
[null,24,"IES File Generator for Directional Lamps","Tool"]
[null,25,"Rebate Lookup Tool","Link"]
[null,26,"Asset Value Increase","Benefit Tool"]
[null,null,"Full Disclaimer"]

{"sheet":"Instructions","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Below is usage help on the tools included here. It you wish some general help on navigation, etc. please click the link below"]

{"sheet":"Simple_Payback","index":2,"n_rows":41,"n_cols":4,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,1,38,2],[39,1,39,2],[40,1,40,3],[4,2,4,3],[5,3,7,3],[28,1,28,2],[35,1,35,3],[36,1,36,2],[37,1,37,2]]}
[]
[null,"Simple LED Payback\nCalculator","Put your company logo here"]
["Date","Opportunity Analysis prepared for\n","Your e-mail","Your phone #"]
[]
[null,"Site Name:"]
[null,"# Fixtures",240,"It is important to check that the proposed fixture provides similar lumens to the existing fixture."]
[null,"Burn hr. annual",6500]
[null,"Energy Rate $ per kWh",0.11]
[null,null,"Proposed","Existing"]
[null," Lamp/Fixture Description","ABV3 18T","MVR400/U"]
[null,"Fixture Watts",109,460]
[null,"Investment"]
[null,"Cost of proposed Lamp/Fixture",240]
[null,"Labor to install (per fixture)",50]
[null,"Rebate, if available (put in as negative $)",-100]
[null,"Cost to retrofit entire site",{"$f":"C6*(C13+C14+C15)","v":45600}]
[null,"Savings"]
[null,"Cost of Energy used (annual) EXISTING",{"$f":"C6*C7*C8*D11/1000","v":78936}]
[null,"Cost of Energy used (annual) PROPOSED",{"$f":"C6*C7*C8*C11/1000","v":18704.400000000001}]
[null,"Energy Saved (annual)",{"$f":"C18-C19","v":60231.6}]
[null,"ROI",{"$f":"C20/C16","v":1.3208684210526316}]
[null,"Payback (months)",{"$f":"12*C16/C20","v":9.0849321618552388}]
[null,"Controls",null,false]
[null,"Cost of Adding controls (per fixture)",50]
[null,"% energy savings from controls",0.4,{"$f":"IF(D23=FALSE,1,C25)","v":1}]
[null,"New Investment number (with controls)",{"$f":"IF(D23=FALSE,\"\",C6*(C13+C14+C15+C24))","v":""}]
[null,"New ROI with controls",{"$f":"IF(D23=FALSE,\"\",(C18-C19*C25)/C26)","v":""}]
[null,"New Payback with controls (months)",{"$f":"IF(D23=FALSE,\"\",12/C27)","v":""}]
[null,"Environmental Impact (USA, 2017 numbers)"]
[null,"kWh saved per year",{"$f":"C6*(C7*D11-C7*C11*D25)/1000","v":547560}]
[null,"Metric tons CO2 emission reduced  per year",{"$f":"C30*D37","v":384.93467999999996}]
[null,"lb. coal burning avoided per year",{"$f":"C31/D38","v":410816.09391675558}]
[null,"Metric tons coal burning avoided per year",{"$f":"C32/2205","v":186.31115370374403}]
[null,"Equivalent gallons of gasoline burning avoided",{"$f":"C31/D39","v":43299.739032620913}]
[null,"Equivalent acres of forest added",{"$f":"C31/D40","v":363.1459245283018}]
[null,"DOE Numbers for the US (2017) generating these calculations"]
[null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",null,7.0299999999999996E-4]
[null,"CO2 released metric tons. per per lb. of coal burned",null,9.3700000000000001E-4]
[null,"metric tons CO2 released per gallon of gasoline burned",null,8.8900000000000003E-3]
[null,"CO2 sequestration metric ton.per acre of forest per year",null,1.06]
[null," Link to EPA GHG Equivalencies Calculator (2017)"]

{"sheet":"Cost_of_Waiting","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[12,1,12,7],[3,1,6,7],[1,5,1,6],[1,2,1,4],[2,6,2,8],[8,1,8,7],[15,1,15,2],[16,1,16,2],[17,1,17,2],[19,1,19,2],[20,1,20,2]]}
[]
[null,null,"Cost of Waiting\nEstimator",null,null,"Put your company logo here"]
[]
[null,"This tool calculates the typical Cost of Waiting when traditional Fluorescent and HID lamps are not upgraded to LED lamps\nAssumptions: T8 lamps are 4 foot F32 or F28 on Normal ballast factor. Typicaly, 31% energy savings when converted to Type A LED tubes. 400W HID lamps, Type B LED lamps will take fixture wattage from 460 watts to 150 watts for a 67% energy reduction. Further savings result from maintenance reduction; based on typical numbers for average facilities, 20% for HID and 50% for LED Tubes.\nLED lamps require no maintenance till end of rated life; Fluorescent and HID lamps have a steady random failure rate."]
[]
[]
[]
[]
[null,"Typical Cost of Not Upgrading to LED Lamps"]
[null,"Fixture Type","Burn Hours\nper year","Number\n of Fixtures","Lamps\nper fixture","Energy rate\n$ per kWh","Cost of Waiting\nper year (typical)","Cost of Waiting\nper month (typical)"]
[null,null,null,400,1,0.1,{"$f":"B34*C34*F11*D11*E11/1000","v":96732.479999999996},{"$f":"G11/12","v":8061.04}]
[]
[null,"This calculation provides a basis for intiating a conversation about upgrading to LED lamps within the existing fixtures while maintaining similar light levels. More accurate estimates can be provided once the specific retrofit option has been identified. In some cases--especially if the site is retrofitted to LED fixtures rather than LED lamps--even larger savings can be realized."]
[]
[]
[null,"LED Type A Tubes -->",null,"Replace Fluorescent tubes in the same fixture, no ballast change"]
[null,"LED Type B Tubes -->",null,"Replace Fluorescent tubes in the same fixture, remove external ballast"]
[null,"LED Type C Tubes -->",null,"Replace Fluorescent tubes in the same fixture, replace ballast with LED driver"]
[]
[null,"HID to LED lamps Type A -->",null,"Replace HID lamps with LED lamps in the same fixture, no ballast change"]
[null,"HID to LED lamps Type B -->",null,"Replace HID lamps with LED lamps in the same fixture, remove external ballast"]
[]
[]
[]
[null,"Office Fluorescent T8","1-Shift 4500 hr."]
[null,"HID Hi-Bay 400W","2-Shift 6500 hr."]
[null,null,"24/7 op. 8760 hr."]
[]
[]
[]
[]
[]
[null,2,2]
[null,{"$f":"IF(B33=1,11.625,372.048)","v":372.048},{"$f":"IF(C33=1,4500,IF(C33=2,6500,8760))","v":6500}]

{"sheet":"Procrastination","index":4,"n_rows":55,"n_cols":23,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,1,51,1],[54,2,55,7],[53,1,54,1],[57,9,58,9],[44,1,45,1],[47,1,48,1],[47,2,48,7],[50,2,51,7],[41,1,42,1],[41,3,41,5],[33,1,33,4],[39,1,39,7],[15,5,15,7],[17,5,20,7],[23,5,25,7],[27,1,27,5],[31,1,31,5],[32,1,32,4],[28,6,32,7],[28,1,28,4],[29,1,29,4],[30,1,30,4],[1,1,1,8],[3,6,3,7],[5,6,5,7],[13,1,13,3],[5,9,6,9],[7,6,10,7],[11,1,11,5],[12,1,12,5],[13,4,13,7]]}
[]
[null,"Cost of Procrastinating"]
[]
[null,null,null,null,null,null,"Would you be okay with carrying a "]
[null,null,null,null,null,null,"credit card debt of ",{"$f":"F33","v":88000}]
[null,null,null,null,null,null,"and paying steady annual interest "]
[null,null,null,null,null,null,"at the rate of",{"$f":"F34","v":1.0075000000000001}]
[null,null,null,null,null,null,"Probably not. But that's what you are choosing to do by\nnot upgrading to LED lighting.  Let us explain below, how this is:  based on the lamps you are using and the extra money you are paying for energy every month and every year."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,6,1,3,{"$f":"IF(M11=1,4000,IF(M11=2,4500,IF(M11=3,6500,IF(M11=4,8760))))","v":6500},null,"W/lamp",null,"$ old","$ new","Savings","Comment",null,"$ per lmp"]
[null,"Also, your procrastinating is causing the unnecessary  annual emission of greenhouse gases in the amount of",null,null,null,null,{"$f":"N30","v":1249300},"lbs."]
[null,"Due to the extra energy consumed by lighting, the utilities have to burn coal every year in the extra amount of",null,null,null,null,{"$f":"N31","v":273.70819503324685},"tons"]
[null,"INPUT",null,null,"(based on DOE numbers for environmental impact, issued 2017.)"]
[null,"Existing lamp type",null,null,null,"Suggested LED upgrade",null,null,null,1,"Fluorescent 4 ft. T12",1,"Office 4000 hr.",4000,"LED Tube and driver (Type C)",38,15,{"$f":"$D$18*$L$11*P15*$N$11*$D$24/1000","v":10868},4290,{"$f":"R15-S15","v":6578},"4-foot glass \"Lumen Choice\" Type C tube can be operated on a driver at around 12 watts to provide equivalent light to a 4 foot T12 system.","Replacing the entire fixture with a brand new 2 X 4 LED fixture is a great solution but will cost a little more than the tube and driver replacement in the existing fixture.",20]
[null,null,null,null,null,{"$f":"VLOOKUP(K11,J15:Y22,6)","v":"LED Lamp Type B, remove ballast"},null,null,null,2,"Fluorescent 4 ft. T8",2,"Industrial 1 shift 4500 hr.",4500,"LED Tube (Type A) retain ballast",25,17,7150,4862,{"$f":"R16-S16","v":2288},"Typically, a 4 foot glass 15 W T8 LED Type A tube is a convenient choice and should operate on the existing ballast. The calculations assumes a \"N\" ballast factor ballast in the fixture.","Type B and Type C solutions are possible and also fixture replacement.",10]
[null,null,null,null,null,"Notes on recommended upgrade",null,null,null,3,"Fluoresent Hi Lumen Biax",3,"Industrial 2 shift 6500 hr.",6500,"LED biax replacement, retain ballast",38,20,10868,5720,5148,"The calculation assumes an F40/30 High Lumen Biax replaced with an LED plug-in alternative.","Typically these are 2 x 2 fixtures and can be replaced with a neww LED fixture.",15]
[null,"Number of fixtures",null,400,null,{"$f":"VLOOKUP(K11,J15:U22,12)","v":"This assumes a Type B 23,500 lumen LED lamp at 150 W replacing the 400 W HID lamp."},null,null,null,4,"Fluorescent 28W T5",4,"Industrial 24/7 shift 8760 hr.",8760,"LED Tube Type A, retain ballast",31,16,8866,4576,4290,"A Type A solution available from GE and is being considered here.","Type C systems are also available, as are fixture replacements.",12]
[null,"No. of lamps per fixture",null,null,null,null,null,null,null,5,"Fluorescent T5HO",5,null,null,"LED tube and driver Type C",57,29,16302,8294,8008,"GE's LED T5HO Type C tube replacement recommended here has an industry leading 4700 lumens. There are other Type A options available, both from GE and from other companies that only have 3300 to 3600 lumens. These will save even more energy but fail to deliver equivalent light levels.","For High Bay (industrial) applications, GE's Albeo ABV3 fixture will deliver significantly higher energy savings.",20]
[null,null,null,null,null,null,null,null,null,6,"HID 400W",6,null,null,"LED Lamp Type B, remove ballast",460,150,131560,42900,88660,"This assumes a Type B 23,500 lumen LED lamp at 150 W replacing the 400 W HID lamp.","18,000 lumen option at 115 watts is also possible. But an Albeo ABV3 fixture at 88 watts is even better.",220]
[null,"Approximate burn hr. per year",null,null,null,null,null,null,null,7,"HID 250W",null,null,null,"LED Lamp Type B, remove ballast",290,115,82940,32890,50050,"This assumes a Type B 18,000 lumen LED lamp at 115 W replacing the 250W HID lamp.","12,000 lumen option at 80 watts is also possible. But an Albeo ABV3 fixture at 61 watts is even better.",270]
[null,null,null,null,null,"Alternatives to recommended upgrade",null,null,null,8,"HID 175W",null,null,null,"LED Lamp Type B, remove ballast",210,90,60060,25740,34320,"This assumes a Type B 12,000 lumen LED lampat 80 W replacing the 175W HID lamp.","7500 lumen option at 50 watts is also possible. But an Albeo ABV3 fixture at 46 watts is even better.",140]
[]
[null,"Energy rate $/kWh",null,0.11,null,{"$f":"VLOOKUP(K11,J15:V22,13)","v":"18,000 lumen option at 115 watts is also possible. But an Albeo ABV3 fixture at 88 watts is even better."}]
[]
[null,"Estimated energy used currently",null,null,{"$f":"VLOOKUP(K11,J15:T22,9)","v":131560},null,null,null,null,null,null,null,"kWh saved",{"$f":"F30/D24","v":806000}]
[null,"Energy Savings available (annual)",null,null,{"$f":"VLOOKUP(K11,J15:T22,11)","v":88660},null,null,null,null,null,null,null,"ENVIRONMENTAL"]
[null,"Cost of Postponing the LED Upgrade",null,null,null,null,null,null,null,null,null,null,"lb. CO2 per kWh generated ",1.55]
[null,"Cost of Waiting (per month)",null,null,null,{"$f":"E27/12","v":7388.333333333333},"And when you add labor \nand maintenance savings--\nand potential rebates available--\nthe savings and rewards\nare even higher.",null,null,null,null,null,"CO2. per lb. of coal burned",2.0699999999999998]
[null,"Cost of Waiting (annual)",null,null,null,{"$f":"E27","v":88660},null,null,null,null,null,null,"CO2 emissions saved",{"$f":"N26*N28","v":1249300}]
[null,"Estimated cost to retrofit (rough)",null,null,null,{"$f":"$D$18*$L$11*VLOOKUP(K11,J15:Y22,14)","v":88000},null,null,null,null,null,null,"COAL burning avoided",{"$f":"N30/(2205*N29)","v":273.70819503324685},"tons"]
[null,"Refusing to do the LED retrofit right now is equivalent to "]
[null,"choosing to carry a credit card debt of ",null,null,null,{"$f":"F31","v":88000}]
[null,"while continuing to pay an interest rate of ",null,null,null,{"$f":"F30/F33","v":1.0075000000000001}]
[]
[]
[]
[]
[]
[null,"Documentation"]
[]
[null,"1)","Typical ",{"$f":"VLOOKUP(K11,J15:W22,2)","v":"HID 400W"},null,null,"lamps on normal ballasts"]
[null,null,"operate at about ",null,{"$f":"VLOOKUP(K11,J15:W22,7)","v":460},"watts per lamp, including ballast lossses."]
[]
[null,"2)","Typical LED replacement lamps in the same system operate at approximately"]
[null,null,{"$f":"VLOOKUP(K11,J15:W22,8)","v":150},"watts per lamp resulting in roughly",null,null,{"$f":"(E43-C46)/E43","v":0.67391304347826086},"energy savings"]
[]
[null,"3) ","Based on DOE 2017 numbers, 1.55 lb. of CO2 are emitted for each kWh of electricity generated."]
[]
[]
[null,"4)","Based on DOE 2017 numbers, 1 lb.of coal has burned when 2.07 lb. of CO2 are generated."]
[]
[]
[null,"5)","A very rough estimate of retrofit costs is provided assuming ",null,null,null,null,{"$f":"VLOOKUP(K11,J15:W22,14)","v":220}]
[null,null,"per lamp replaced. This number may change based on labor rates and lamp costs prevalent in your region. A better estimate can be created through a follow-up by a lighting professional."]

{"sheet":"Footcandles_Recom","index":5,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[8,1,8,3],[0,2,0,8],[0,9,0,12],[2,1,2,3],[2,5,2,7],[2,9,2,11],[29,9,31,11],[9,9,9,11],[15,1,15,3],[16,5,16,7],[16,9,16,11],[17,6,17,7],[18,6,18,7],[19,5,19,7],[20,9,20,11],[21,6,21,7],[22,5,22,7],[25,1,25,3],[18,2,18,3]]}
[null,null,"Typical Footcandles",null,null,null,null,null,null,"IMPORTANT NOTE:   Lighting Design cannot be based merely on footcandles These numbers provide rough guidelines that are satisfactory in a most cases, but substantial additional information must be considered."]
[null,null,"Hor","Vert",null,null,"Hor","Vert",null,null,"Hor","Vert"]
[null,"Offices ",null,null,null,"Industrial",null,null,null,"Residential"]
[null,"General, Open offices",50,null,null,"Basic Tasks (coarse)",10,null,null,"General Lighting",5]
[null,"Intensive Computer use",30,null,null,"Basic Tasks (medium)",30,null,null,"Grooming",30]
[null,"Lobby, Reception",10,null,null,"Basic Tasks (fine)",50,null,null,"Dining",5]
[null,"Conference Rooms",30,10,null,"Basic Tasks (very fine)",100,null,null,"Kitchen Counter",30]
[null,"Video Conferencing",50,30,null,"Machining (rough)",30,null,null,"Serious reading",50]
[null,"Shopping Malls/Retail",null,null,null,"Machining (fine)","300+",null,null,"Casual Reading",30]
[null,"Main Concourse",30,null,null,"Warehousing (inactive)",5,null,null,"Hotels"]
[null,"Restrooms",10,null,null,"Warehousing (large labels)",10,10,null,"Guest Rooms (general)",10]
[null,"General Retail",50,null,null,"Warehousing (small labels)",30,30,null,"Bathrooms",30]
[null,"Supermarkets",50,null,null,"Stairways, corridors",5,null,null,"Reading, Desk surface",30]
[null,"Feature Display",100,null,null,"Toilets and Wash rooms",10,null,null,"Corridors, stairs",5]
[null,"Show Window",300,null,null,"Shipping/Receiving",30,null,null,"Front Desk",50]
[null,"Hospitals",null,null,null,"Reception/Lobby",10,null,null,"Lobby",10]
[null,"Corridors",10,null,null,"Parking",null,null,null,"Restaurants"]
[null,"General (most areas)",30,null,null,"Outdoor Parking","0.5 to 2",null,null,"Intimate Dining",5]
[null,"Operating Table","1000+",null,null,"Indoor Parking","2 to 5",null,null,"Food Court/Casual Dining",30]
[null,"Inspection of supplies",100,null,null,"Outdoor",null,null,null,"Kitchen",50]
[null,"Waiting Areas (general)",10,null,null,"Building façade (flood)",null,"3-10",null,"Sports"]
[null,"Waiting Areas (reading)",30,null,null,"Roadway","0.3 to 1",null,null,"Baseball (Pro) infield",150]
[null,"Nursing Station (general)",30,null,null,"Casinos and Gaming",null,null,null,"Baseball (Pro) outfield",100]
[null,"Lobby",5,null,null,"Circulation (high activity)",30,null,null,"Baseball (recreational) infield",30]
[null,"Medical Records",50,10,null,"Circulation (medium activity)",10,null,null,"Baseball (recreational) outfield",20]
[null,"Schools and Universities",null,null,null,"Circulation (low activity)",5,null,null,"Tennis (Pro)",150]
[null,"Classrooms",50,null,null,"Baccarat, Bingo, Craps, Roulette",30,null,null,"Tennis (recreational)",50]
[null,"Gymnasiums (basketball)",100,30,null,"Poker, Blackjack",50,null,null,"Basketball (Pro)",125]
[null,"Gymnasiums (social events)",5,null,null,"Video and Slots",10,null,null,"Basketball (recreational)",30]
[null,"Corridors",null,30,null,null,null,null,null,"NOTE:  This represents what is needed by the players. Spectators and cameras may need more.  For example, Major League Baseball calls for 350 fc at Home Plate."]
[null,"Lecture Demonstraion",100,50]

{"sheet":"Hi-Bay_Watts","index":6,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[14,3,14,4],[8,3,8,4],[23,3,23,4],[27,5,28,5],[10,3,10,4],[26,1,26,5],[13,3,13,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[24,3,24,4],[18,3,18,4],[27,1,28,1],[27,2,27,4],[4,2,5,2],[4,5,5,5],[1,2,1,5],[21,1,25,1],[4,1,5,1],[4,4,5,4],[6,1,11,1],[12,1,15,1],[16,1,20,1],[6,2,11,2],[12,2,15,2],[16,2,20,2],[21,2,25,2],[25,3,25,4],[6,3,6,4],[7,3,7,4],[9,3,9,4],[11,3,11,4],[12,3,12,4]]}
[]
[null,null,"Hi-Bay Wattages for LED Retrofits\nReference Sheet"]
[]
[]
[null,"From","System Watts",null,"To","System Watts"]
[]
[null,"MVR400/U",460,"ABV3 18T (Std.)",null,109]
[null,null,null,"ABV3 18H (Hi Perf.)","ABV3 18H (Hi Perf.)",88]
[null,null,null,"ABC1 18 (Value) ",null,126]
[null,null,null,"LED HID Lamp Type A","LED HID Lamp Type A",165]
[null,null,null,"LED HID Lamp Type B","LED HID Lamp Type B","18000L =115W"]
[null,null,null,"LED HID Lamp Type B","LED HID Lamp Type B","24,000L = 150W"]
[null,"6 Lamp T8HL Hi bf",220,"ABV3 18T (Std.)","ABV3 18T (Std.)",109]
[null,null,null,"ABV3 18H (Hi Perf.)","ABV3 18H (Hi Perf.)",88]
[null,null,null,"ABC1 18 (Value) ",null,126]
[null,null,null,"LED T8 Type A 18W","LED T8 Type A 18W",174]
[null,"4 Lamp T5HO",234,"ABV3 18T (Std.)","ABV3 18T (Std.)",109]
[null,null,null,"ABV3 18H (Hi Perf.)","ABV3 18H (Hi Perf.)",88]
[null,null,null,"ABC1 18 (Value) ",null,126]
[null,null,null,"LED T5HO Type A","LED T5HO Type A",128]
[null,null,null,"LED T5HO Type C","LED T5HO Type C",144]
[null,"6 Lamp T5HO",351,"ABV3 24T (std.)","ABV3 24T (std.)",137]
[null,null,null,"ABV3 24H (Hi Perf.)","ABV3 24H (Hi Perf.)",122]
[null,null,null,"ABC1 24 (Value) ",null,161]
[null,null,null,"LED T5HO Type A","LED T5HO Type A",192]
[null,null,null,"LED T5HO Type C","LED T5HO Type C",216]
[null,"ABV3 / ABC1 Portfolios"]
[null,"Approx. Lumens","ABV3 Watts for different series",null,null,"ABC1"]
[null,null,"T (std.)","H (Hi Perf.)"]
[null,9000,50,46,null,"9,900L = 62W"]
[null,12000,68,61,null,"12,000L = 78W"]
[null,15000,92]
[null,18000,109,88,null,"18,000L = 126W"]
[null,24000,137,122,null,"24,000L = 161W"]
[null,30000,184]
[null,36000,221,190]
[null,48000,284,248]
[null,60000,360,314]

{"sheet":"Lumen_Comparison","index":7,"n_rows":74,"n_cols":23,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5],[1,6,1,8],[2,1,2,2],[11,2,11,7]]}
[]
[null,null,null,null,"Lighting System Lumen Comparison Tool",null,"Put your company logo here"]
[null,"# lamps /fixture",null,"Lamp","Rated Initial Lumens","Mean Lumens (%)","Life (hr.)","Ballast Factor","C U"]
[null,"System 1: ",1,"MVR400/U",36000,0.65,20000,1,0.85,null,null,{"$f":"E4*H4*C4*I4","v":30600}]
[null,"System 2: ",6,"T5HO/WM",5000,0.92,36000,1,0.9,null,null,27000]
[null,"System 3: ",6,"T8 HL Hi bf",3100,0.94,50000,1.18,0.9,null,null,19753.2]
[null,"System 4: ",4,"T5HO/WM",5000,0.92,36000,1,0.9,null,null,18000]
[null,"System 5: ",1,"Albeo ABV3 18",18000,0.85,100000,1,1,null,null,18000]
[null,"System 6: ",1,"Albeo ABv3 24",24000,0.85,100000,1,1,null,null,24000]
[null,"System 7: ",null,null,null,null,null,null,1,null,null,0]
[null,"System 8: ",null,null,null,null,null,null,1,null,null,0]
[null,null,"Note:  Mouseover the cells with red triangle in upper right corner for additional information.\nTo remove a system, type zero in the number of lamps cell"]
[]
[]
[]
[null,null,null,{"$f":"C4&\" \"&D4","v":"1 MVR400/U"}]
[null,null,null,"6 T5HO/WM"]
[null,null,null,"6 T8 HL Hi bf"]
[null,null,null,"4 T5HO/WM"]
[null,null,null,"1 Albeo ABV3 18"]
[null,null,null,"1 Albeo ABv3 24"]
[null,null,null," "]
[null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,0,1000,2000,3000,4000,5000,6000,7000,8000,9000,10000,11000,12000,13000,14000,15000,16000,17000,18000,19000,20000]
[null,"System1",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp1 hr",0,{"$f":"D36*$G$4","v":1000},2000,3000,4000,5000,6000,7000,8000,9000,10000,11000,12000,13000,14000,15000,16000,17000,18000,19000,20000]
[null,"Lmp1% Lum",{"$f":"EXP(-(C36/0.25)*(1-$F$4^0.75))+0.06*(C36^2)","v":1},0.94642897596482489,0.89604390035303783,0.84868973706002127,0.80421977867946093,0.76249519907714303,0.72338463000094599,0.68676376043577902,0.65251495748157984,0.62052690759813833,0.59069427712261335,0.56291739102439664,0.53710192891759545,0.51315863740403422,0.49100305786948611,0.47055526890296911,0.4517396425535416,0.43448461368123215,0.41872246169867378,0.40438910403780115,0.39142390071172828]
[null,"Lmp1 Lum",{"$f":"C38*$L$4","v":30600},28960.726664523641,27418.943350802958,25969.905954036651,24609.125227591503,23332.353091760575,22135.569678028947,21014.971069334839,19966.957698936341,18988.123372503032,18075.24487995197,17225.272165346538,16435.319024878419,15702.654304563448,15024.693570806276,14398.991228430856,13823.233062138373,13295.229178645704,12812.907327979417,12374.306583556716,11977.571361778886]
[]
[null,"System2",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp2 hr",0,{"$f":"D41*$G$5","v":1800},3600,5400,7200,9000,10800,12600,14400,16200,18000,19800,21600,23400,25200,27000,28800,30600,32400,34200,36000]
[null,"Lmp2% Lum",{"$f":"EXP(-(C41/0.25)*(1-$F$5^0.75))+0.06*(C41^2)","v":1},0.988099011929925,0.97664325017331521,0.9656309646095993,0.95506042620888865,0.94492992677781285,0.93523777870841929,0.92598231473009918,0.91716188766450146,0.90877487018340175,0.90081965456948909,0.89329465248003426,0.88619829471340739,0.87952903097840895,0.87328532966638006,0.8674656776260592,0.86206857994115305,0.85709255971058662,0.85253615783140202,0.848397932784274,0.84467646042160904]
[null,"Lmp2 Lum",{"$f":"C43*$L$5","v":27000},26678.673322107974,26369.367754679512,26072.036044459182,25786.631507639995,25513.108023000947,25251.420025127321,25001.522497712678,24763.37096694154,24536.921494951846,24322.130673376207,24118.955616960924,23927.353957261999,23747.283836417042,23578.703900992263,23421.5732959036,23275.851658411131,23141.49911218584,23018.476261447853,22906.744185175397,22806.264431383443]
[]
[null,"System3",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp3 hr",0,{"$f":"D46*$G$6","v":2500},5000,7500,10000,12500,15000,17500,20000,22500,25000,27500.000000000004,30000,32500,35000,37500,40000,42500,45000,47500,50000]
[null,"Lmp3% Lum",{"$f":"EXP(-(C46/0.25)*(1-$F$6^0.75))+0.06*(C46^2)","v":1},{"$f":"EXP(-(D46/0.25)*(1-$F$6^0.75))+0.06*(D46^2)","v":0.99112175480061016},0.98262501881260067,0.97450905615082495,0.9667731375738885,0.95941654042416658,0.95243854856836452,0.94583845233861497,0.93961554847410611,0.93376914006323686,0.92829853648629512,0.92320305335865294,0.91848201247447447,0.91413474175093268,0.91016057517292892,0.90655885273831216,0.90332892040359236,0.9004701300301452,0.89798183933090014,0.89586341181751206,0.89411421674800851]
[null,"Lmp3 Lum",{"$f":"C48*$L$6","v":19753.2},19577.826246927412,19409.988521609066,19249.672287958478,19096.863141124533,18951.546806306647,18813.709137580619,18683.336116735129,18560.413852118712,18444.928577497132,18336.866650921085,18236.214553604143,18142.95888881079,18057.086380754525,17978.583873505901,17907.43832991043,17843.63683051624,17787.166572511465,17738.014868671136,17696.169146313681,17661.616946266764]
[]
[null,"System4",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp4 hr",0,{"$f":"D51*$G$7","v":1800},3600,5400,7200,9000,10800,12600,14400,16200,18000,19800,21600,23400,25200,27000,28800,30600,32400,34200,36000]
[null,"Lmp4% Lum",{"$f":"EXP(-(C51/0.25)*(1-$F$7^0.75))+0.06*(C51^2)","v":1},{"$f":"EXP(-(D51/0.25)*(1-$F$7^0.75))+0.06*(D51^2)","v":0.988099011929925},0.97664325017331521,0.9656309646095993,0.95506042620888865,0.94492992677781285,0.93523777870841929,0.92598231473009918,0.91716188766450146,0.90877487018340175,0.90081965456948909,0.89329465248003426,0.88619829471340739,0.87952903097840895,0.87328532966638006,0.8674656776260592,0.86206857994115305,0.85709255971058662,0.85253615783140202,0.848397932784274,0.84467646042160904]
[null,"Lmp4 Lum",{"$f":"C53*$L$7","v":18000},17785.782214738651,17579.578503119676,17381.357362972787,17191.087671759997,17008.738682000632,16834.280016751549,16667.681665141787,16508.913977961027,16357.947663301231,16214.753782250804,16079.303744640616,15951.569304841332,15831.522557611361,15719.135933994841,15614.382197269066,15517.234438940755,15427.666074790559,15345.650840965236,15271.162790116932,15204.176287588964]
[]
[null,"System5",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp5 hr",0,{"$f":"D56*$G$8","v":5000},{"$f":"E56*$G$8","v":10000},15000,20000,25000,30000,35000,40000,45000,50000,55000.000000000007,60000,65000,70000,75000,80000,85000,90000,95000,100000]
[null,"Lmp5% Lum",{"$f":"EXP(-(C56/0.25)*(1-$F$8^0.75))+0.06*(C56^2)","v":1},{"$f":"EXP(-(D56/0.25)*(1-$F$8^0.75))+0.06*(D56^2)","v":0.9774606544084582},{"$f":"EXP(-(E56/0.25)*(1-$F$8^0.75))+0.06*(E56^2)","v":0.9557361152202889},0.93481470181509307,0.91468499859810493,0.89533584898693341,0.87675634953474069,0.85893584418676272,0.8418639186671445,0.82553039499313474,0.80992532611375079,0.79503899067008688,0.78086188787450916,0.767384732506038,0.75459845001928127,0.7424941717643434,0.73106323031519116,0.72029715490401613,0.71018766695918789,0.70072667574444913,0.69190627409705319]
[null,"Lmp5 Lum",{"$f":"C58*$L$8","v":18000},{"$f":"D58*$L$8","v":17594.291779352247},{"$f":"E58*$L$8","v":17203.250073965199},16826.664632671676,16464.329974765889,16116.045281764802,15781.614291625332,15460.84519536173,15153.550536008601,14859.547109876425,14578.655870047514,14310.701832061564,14055.513981741165,13812.925185108685,13582.772100347063,13364.895091758181,13159.138145673442,12965.348788272291,12783.378005265382,12613.080163400084,12454.312933746958]
[]
[null,"System6",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp6 hr",0,{"$f":"D61*$G$9","v":5000},{"$f":"E61*$G$9","v":10000},15000,20000,25000,30000,35000,40000,45000,50000,55000.000000000007,60000,65000,70000,75000,80000,85000,90000,95000,100000]
[null,"Lmp6% Lum",{"$f":"EXP(-(C61/0.25)*(1-$F$9^0.75))+0.06*(C61^2)","v":1},{"$f":"EXP(-(D61/0.25)*(1-$F$9^0.75))+0.06*(D61^2)","v":0.9774606544084582},0.9557361152202889,0.93481470181509307,0.91468499859810493,0.89533584898693341,0.87675634953474069,0.85893584418676272,0.8418639186671445,0.82553039499313474,0.80992532611375079,0.79503899067008688,0.78086188787450916,0.767384732506038,0.75459845001928127,0.7424941717643434,0.73106323031519116,0.72029715490401613,0.71018766695918789,0.70072667574444913,0.69190627409705319]
[null,"Lmp6 Lum",{"$f":"C63*$L$9","v":24000},{"$f":"D63*$L$9","v":23459.055705802995},22937.666765286933,22435.552843562233,21952.439966354519,21488.0603756864,21042.152388833776,20614.460260482305,20204.734048011469,19812.729479835234,19438.20782673002,19080.935776082086,18740.685308988221,18417.233580144912,18110.36280046275,17819.860122344242,17545.517527564589,17287.131717696386,17044.50400702051,16817.440217866781,16605.750578329276]
[]
[null,"System7",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp7 hr",0,{"$f":"D66*$G$10","v":0},{"$f":"E66*$G$10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lmp7% Lum",{"$f":"EXP(-(C66/0.25)*(1-$F$10^0.75))+0.06*(C66^2)","v":1},{"$f":"EXP(-(D66/0.25)*(1-$F$10^0.75))+0.06*(D66^2)","v":0.8188807530779818},0.67092004603563937,0.55016163609402635,0.45172896411722158,0.37162944117144231,0.30659421191220215,0.25394696394160649,0.21149651799465538,0.17744888822158653,0.15033528323661272,0.12895315836233387,0.11231795328941251,9.9623578214333874E-2,9.0210062625217968E-2,8.3537068367863954E-2,7.9162203978366208E-2,7.6723269960326079E-2,7.5923722447292563E-2,7.6520771856165598E-2,7.8315638888734176E-2]
[null,"Lmp7 Lum",{"$f":"C68*$L$10","v":0},{"$f":"D68*$L$10","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"System8",0,0.05,0.1,0.15,0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,0.85,0.9,0.95,1]
[null,"Lmp8 hr",0,{"$f":"D71*$G$11","v":0},{"$f":"E71*$G$11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Lmp8% Lum",{"$f":"EXP(-(C71/0.25)*(1-$F$11^0.75))+0.06*(C71^2)","v":1},{"$f":"EXP(-(D71/0.25)*(1-$F$11^0.75))+0.06*(D71^2)","v":0.8188807530779818},0.67092004603563937,0.55016163609402635,0.45172896411722158,0.37162944117144231,0.30659421191220215,0.25394696394160649,0.21149651799465538,0.17744888822158653,0.15033528323661272,0.12895315836233387,0.11231795328941251,9.9623578214333874E-2,9.0210062625217968E-2,8.3537068367863954E-2,7.9162203978366208E-2,7.6723269960326079E-2,7.5923722447292563E-2,7.6520771856165598E-2,7.8315638888734176E-2]
[null,"Lmp8 Lum",{"$f":"C73*$L$11","v":0},{"$f":"D73*$L$11","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"ABV3_Hi-bay_Retrofit","index":8,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[[11,5,11,6],[0,2,0,4],[1,5,1,6],[2,2,2,3],[3,2,3,3],[4,5,4,6],[42,2,43,3],[42,5,42,6],[26,2,26,3],[30,5,30,6],[34,2,34,3],[37,2,37,3],[37,5,37,6],[38,2,38,3]]}
[null,null,"                       LED Payback \n                              Calculator",null,null,"Put your company logo here"]
[null,null,null,null,null,"INSTRUCTIONS: (PLEASE READ!) First select the lamp/fixture currently used. This will automatically populate all the BLUE cells with value for the recommended Albeo fixture. Then, Enter information in GREEN  cells only; other cells are calculated values; do not write in them. Maintenance savings are projected assuming existing system has reached long-term (steady state.) If you need to change any of the blue cells, DO NOT WRITE IN THEM because it will destroy the formulas there and make this spread sheet unusable. Instead, go to the \"Generic Tool\" which allows you to put in custom values."]
[null,null,"Select the lamp/fixture currently used in the space",null,null,"Opportunity Analysis prepared for\nSIMCO Industries","Date"]
[null,null,"Manufacturing Area",null,null,"Your e-mail","Your phone #"]
[null,null,"Existing Lamp/Fixture Description",{"$f":"VLOOKUP(N6,O6:V11,2,FALSE)","v":"MVR400/U"},null,"Addition of Controls"]
[null,null,"# Fixtures",240,null,"Effect of Occupacy Sensor Controls",null,null,null,null,null,null,null,4,1,"6 lamp T5HO",351,"ABV3-24T",137,36000,6,60000]
[null,null,"Fixture Watts, Existing",{"$f":"VLOOKUP(N6,O6:S11,3,FALSE)","v":460},null,"Effect of Dimming Controls",null,null,null,null,null,null,null,null,2,"4-lamp T5HO",234,"ABV3 18T",109,36000,4,60000]
[null,null,"Burn hr. annual",6500,null,"Cost of adding controls ($ per fixture)",32,null,null,"Year","$",null,null,null,3,"6 lamp T8HL Hi bf",220,"ABV3-18T",109,30000,6,60000]
[null,null,"Energy Rate $ per kWh",0.1,null,"If Occ. sensors, burn hours reduced to (%) ",0.7,null,null,0,{"$f":"-D26","v":-69600},null,null,null,4,"MVR400/U",460,"ABV3 18T",109,20000,1,80000]
[null,null,"Annual Energy Use (Existing)",{"$f":"D6*D7*D8*D9/1000","v":71760},null,"If dimming, effective wattage reduced to (%) ",0.6,null,null,1,{"$f":"IF(K9+$D$21>$D$34,0,(K9+$D$21))","v":-14844},null,null,null,5,"MVR250/U",290,"ABV3-12T",68,10000,1,80000]
[null,null,"Proposed Fixture Description",{"$f":"VLOOKUP(N6,O6:V11,4,FALSE)","v":"ABV3 18T"},null,"Energy Consumption reduced to (% of full)",{"$f":"G9*G10","v":0.42},null,null,2,{"$f":"IF(K10=$D$34,0,IF(K10=0,0,IF(K10+$D$21<$D$34,K10+$D$21,$D$34)))","v":39912},null,null,null,6,"MVR175/U",210,"ABV3-09T",50,10000,1,80000]
[null,null,"Part Number (if you wish to specify)",null,null,"Maintenance Savings Calculation",null,null,null,3,94668]
[null,null,"LED Fixture Rated Life (hr.)",100000,null,"Maintenance Savings",null,null,null,4,149424]
[null,null,"LED Fixture Rated Life (years)",{"$f":"D13/D17","v":15.384615384615385},null,"Existing Lamp/Fixture Description",{"$f":"D5","v":"MVR400/U"},null,null,5,204180]
[null,null,"LED Fixture Watts",{"$f":"VLOOKUP(N6,O6:V11,5,FALSE)","v":109},null,"# Fixtures",{"$f":"D6","v":240},null,null,6,258936]
[null,null,"Effective Wattage with Controls",{"$f":"IF(E32=TRUE,D15*G10, D15)","v":109},null,"# lamps per fixture",{"$f":"VLOOKUP(N6,O6:V11,7,FALSE)","v":1},null,null,7,313692]
[null,null,"Annual Burn hr. (including controls)",{"$f":"IF(E31=TRUE,D8*G9, D8)","v":6500},null,"# ballasts per fixture (please correct if not 1)",1,null,null,8,368448]
[null,null,"Annual Energy Use (for proposed)",{"$f":"D6*D16*D17*D9/1000","v":17004},null,"Annual Burn hr.",{"$f":"D8","v":6500},null,null,9,423204]
[null,null,"Energy Savings",{"$f":"D10-D18","v":54756},null,"Lamp Life (best guess)",{"$f":"VLOOKUP(N6,O6:V11,6,FALSE)","v":20000},null,null,10,477960]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(E21=2,0,G30)","v":0},null,"Ballast Life (best guess)",{"$f":"VLOOKUP(N6,O6:V11,8,FALSE)","v":80000}]
[null,null,"Total Annual  Savings",{"$f":"D19+D20","v":54756},2,"Cost per lamp",25]
[null,null,"Cost of Proposed Fixture",340,null,"Cost per ballast",65]
[null,null,"Labor to Install per fixture",50,null,"Labor to replace one lamp",25]
[null,null,"Additional Cost of controls (per fixture)",{"$f":"IF(E31=TRUE, G8,(IF(E32=TRUE,G8,0)))","v":0},null,"Labor to replace one ballast",50]
[null,null,"Rebate per fixture (put in brackets)",-100,null,"Disposal Cost per lamp",0]
[null,null,"Total Investment Required",{"$f":"D6*(D22+D23+D24+D25)","v":69600},null,"Disposal Cost per ballast",0]
[null,null,"Summary of Benefits",null,null,"Disruption cost per event (lamp/ballast out)",50]
[null,null,"Investment per fixture to upgrade",{"$f":"SUM(D22:D25)","v":290},null,"Annual Maintenance cost of lamps",{"$f":"(G18/G19)*G15*G16*(G21+G23+G25+G27)","v":7800}]
[null,null,"Annual savings per fixture",{"$f":"D21/D6","v":228.15},null,"Annual Maintenance cost of ballasts",{"$f":"(G18/G20)*G15*G17*(G22+G24+G26+G27)","v":3217.5}]
[null,null,"Net Energy Savings per fixture over life",{"$f":"D19*D14/D6","v":3510},null,"TOTAL Annual Maintenance Cost (est.)",{"$f":"G28+G29","v":11017.5}]
[null,null,"Net cash generated by each fixture over life",{"$f":"D29*D14-D28","v":3220},false,"Environmental Impact (USA, 2017 numbers)"]
[null,null,"Simple ROI",{"$f":"D21/D26","v":0.78672413793103446},false,"kWh saved per year",{"$f":"D6*(D7*D8-D16*D17)/1000","v":547560}]
[null,null,"Payback (months)",{"$f":"12*D26/D21","v":15.253122945430638},null,"Metric tons CO2 emission reduced  per year",{"$f":"G32*G39","v":384.93467999999996}]
[null,null,"Net Positive Cash by end of fixture life",{"$f":"D21*D14-D26","v":772800},null,"lb. coal burning avoided per year",{"$f":"G33/G40","v":410816.09391675558}]
[null,null,"Cost of Waiting (doing nothing)",null,null,"Metric tons coal burning avoided per year",{"$f":"G34/2205","v":186.31115370374403}]
[null,null,"Cost of waiting per year",{"$f":"D21","v":54756},null,"Equivalent gallons of gasoline burning avoided",{"$f":"G33/G41","v":43299.739032620913}]
[null,null,"Cost of waiting each month",{"$f":"D36/12","v":4563},null,"Equivalent acres of forest added",{"$f":"G33/G42","v":363.1459245283018}]
[null,null,"Cost of waiting = energy/maintenance spending that could be avoided by upgrading",null,null,"DOE Numbers for the US (2017) generating these calculations"]
[null,null,"Net Present Value (NPV) Calculation",null,null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",7.0299999999999996E-4]
[null,null,"Discount rate for NPV calculation",0.05,null,"CO2 released metric tons. per per lb. of coal burned",9.3700000000000001E-4]
[null,null,"Net Present Value of Project (NPV) 5 years",{"$f":"NPV(D40,D21,D21,D21,D21,D21)-D26","v":167464.82457706114},null,"metric tons CO2 released per gallon of gasoline burned",8.8900000000000003E-3]
[null,null,"Net Present Value of Project (NPV) 10 years",{"$f":"NPV(D40,D21,D21,D21,D21,D21,D21,D21,D21,D21,D21)-D26","v":353211.31778244348},null,"CO2 sequestration metric ton.per acre of forest per year",1.06]
[null,null," NPV calculation assumes steady stream of savings over period. In practice, end-user may  replace the fixture earlier due to lumen depreciation and  incur an additional cost.",null,null," Link to EPA GHG Equivalencies Calculator (2017)"]

{"sheet":"ABV3_Hi-bay_Retrofit_(2-Option)","index":9,"n_rows":45,"n_cols":25,"rows_kept":45,"cut":false,"hidden":false,"merged":[[11,2,12,2],[0,2,0,5],[1,6,2,7],[3,2,3,4],[4,2,4,4],[5,3,5,4],[5,6,5,7],[12,6,12,7],[25,3,25,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[14,3,14,4],[15,3,15,4],[18,3,18,4],[21,3,21,4],[41,3,41,4],[43,6,43,7],[44,2,45,3],[28,2,28,4],[31,6,31,7],[36,2,36,4],[38,6,38,7],[39,2,39,3],[40,2,40,4]]}
[null,null,"                       LED Payback \n                              Calculator",null,null,null,"Put your company logo here"]
[null,null,null,null,"Click Here to go to\nAlbeo ABV3 Web page",null,"INSTRUCTIONS: (PLEASE READ!) First select the lamp/fixture currently used. This will automatically populate all the BLUE cells with value for the recommended ABV3 fixture. Then, Enter information in GREEN  cells only; other cells are calculated values and these cells are protected. If you need to change any of the blue cells, go to the \"Generic 2-fixture Tool\" which allows you to put in custom values. Maintenance savings are projected assuming the existing legacy system has reached long-term steady state and that lamps and ballasts are replaced as soon as they fail."]
[null,null,null,null,"Click Here to go to \nAlbeo ABV3 Spec Sheet"]
[null,null,"Select the lamp/fixture currently used in the space",null,null,null,"Opportunity Analysis prepared for\nSIMCO Industries","Date"]
[null,null,"Manufacturing Area",null,null,null,"Your e-mail","Your phone #",null," "]
[null,null,"Existing Lamp/Fixture Description",{"$f":"VLOOKUP(O7,P7:W12,2,FALSE)","v":"6 lamp T5HO"},null,null,"Addition of Controls"]
[null,null,"# Fixtures",240,null,null,"Effect of Occupacy Sensor Controls",null,null,null,null,null,null,null,1,1,"6 lamp T5HO",351,"ABV3-24T",137,36000,6,60000,"ABV3-24H",122]
[null,null,"Fixture Watts, Existing",{"$f":"VLOOKUP(O7,P7:T12,3,FALSE)","v":351},null,null,"Effect of Dimming Controls",null,null,null,null,"T","H",null,null,2,"4-lamp T5HO",234,"ABV3 18T",109,36000,4,60000,"ABV3 18H",88]
[null,null,"Burn hr. annual",6500,null,null,"Cost of adding controls ($ per fixture)",32,null,null,"Year","$",null,null,null,3,"6 lamp T8HL Hi bf",220,"ABV3-18T",109,30000,6,60000,"ABV3 18H",88]
[null,null,"Energy Rate $ per kWh",0.11,null,null,"If Occ. sensors, burn hours reduced to (%) ",0.7,null,null,0,{"$f":"-D28","v":-36000},{"$f":"-E28","v":-45600},null,null,4,"MVR400/U",460,"ABV3 18T",109,20000,1,80000,"ABV3 18H",88]
[null,null,"Annual Energy Use (Existing)",{"$f":"D7*D8*D9*D10/1000","v":60231.6},null,null,"If dimming, effective wattage reduced to (%) ",0.6,null,null,1,{"$f":"IF(L10+$D$23>$D$36,0,(L10+$D$23))","v":722.39999999999418},{"$f":"IF(M10+$E$23>$E$36,0,(M10+$E$23))","v":-6303.6000000000058},null,null,5,"MVR250/U",290,"ABV3-12T",68,10000,1,80000,"ABV3-12H",61]
[null,null,"Proposed Fixture Description","Standard \"T\"","Hi Performance \"H\"",null,"Energy Consumption reduced to (% of full)",{"$f":"H10*H11","v":0.42},null,null,2,{"$f":"IF(L11=$D$36,0,IF(L11=0,0,IF(L11+$D$23<$D$36,L11+$D$23,$D$36)))","v":37444.799999999988},{"$f":"IF(M11+$E$23>$E$36,0,(M11+$E$23))","v":32992.799999999988},null,null,6,"MVR175/U",210,"ABV3-09T",50,10000,1,80000,"ABV3-09H",46]
[null,null,null,{"$f":"VLOOKUP(O7,P7:W12,4,FALSE)","v":"ABV3-24T"},{"$f":"VLOOKUP(O7,P7:Z12,9,FALSE)","v":"ABV3-24H"},null,"Maintenance Savings Calculation",null,null,null,3,74167.199999999983,72289.199999999983]
[null,null,"Part Number (if you wish to specify)",null,null,null,"Maintenance Savings",null,null,null,4,110889.59999999998,111585.59999999998]
[null,null,"LED Fixture Rated Life (hr.)",100000,null,null,"Existing Lamp/Fixture Description",{"$f":"D6","v":"6 lamp T5HO"},null,null,5,147611.99999999997,150881.99999999997]
[null,null,"LED Fixture Rated Life (years)",{"$f":"D15/D19","v":15.384615384615385},null,null,"# Fixtures",{"$f":"D7","v":240},null,null,6,184334.39999999997,190178.39999999997]
[null,null,"LED Fixture Watts",{"$f":"VLOOKUP(O7,P7:W12,5,FALSE)","v":137},{"$f":"VLOOKUP(O7,P7:Z12,10,FALSE)","v":122},null,"# lamps per fixture",{"$f":"VLOOKUP(O7,P7:W12,7,FALSE)","v":6},null,null,7,221056.79999999996,229474.79999999996]
[null,null,"Effective Wattage with Controls",{"$f":"IF(F33=TRUE,D17*H11, D17)","v":137},{"$f":"IF(F33=TRUE,E17*H11, E17)","v":122},null,"# ballasts per fixture (please correct if not 1)",1,null,null,8,257779.19999999995,268771.19999999995]
[null,null,"Annual Burn hr. (including controls)",{"$f":"IF(F32=TRUE,D9*H10, D9)","v":6500},null,null,"Annual Burn hr.",{"$f":"D9","v":6500},null,null,9,294501.59999999998,308067.59999999998]
[null,null,"Annual Energy Use (for proposed)",{"$f":"D7*D18*D19*D10/1000","v":23509.200000000001},{"$f":"D7*E18*D19*D10/1000","v":20935.2},null,"Lamp Life (best guess)",{"$f":"VLOOKUP(O7,P7:W12,6,FALSE)","v":36000},null,null,10,331224,347364]
[null,null,"Energy Savings",{"$f":"D11-D20","v":36722.399999999994},{"$f":"D11-E20","v":39296.399999999994},null,"Ballast Life (best guess)",{"$f":"VLOOKUP(O7,P7:W12,8,FALSE)","v":60000}]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(F22=2,0,H31)","v":0},null,2,"Cost per lamp",25]
[null,null,"Total Annual  Savings",{"$f":"D21+D22","v":36722.399999999994},{"$f":"E21+D22","v":39296.399999999994},null,"Cost per ballast",65]
[null,null,"Cost of Proposed Fixture",200,240,null,"Labor to replace one lamp",25]
[null,null,"Labor to Install per fixture",50,50,null,"Labor to replace one ballast",50]
[null,null,"Additional Cost of controls (per fixture)",{"$f":"IF(F32=TRUE, H9,(IF(F33=TRUE,H9,0)))","v":0},null,null,"Disposal Cost per lamp",0]
[null,null,"Rebate per fixture (put in brackets)",-100,-100,null,"Disposal Cost per ballast",0]
[null,null,"Total Investment Required",{"$f":"D7*(D24+D25+D26+D27)","v":36000},{"$f":"D7*(E24+E25+E26+E27)","v":45600},null,"Disruption cost per event (lamp/ballast out)",50]
[null,null,"Summary of Benefits",null,null,null,"Annual Maintenance cost of lamps",{"$f":"(H19/H20)*H16*H17*(H22+H24+H26+H28)","v":26000}]
[null,null,"Investment per fixture to upgrade",{"$f":"SUM(D24:D27)","v":150},{"$f":"SUM(E24:E27)","v":190},null,"Annual Maintenance cost of ballasts",{"$f":"(H19/H21)*H16*H18*(H23+H25+H27+H28)","v":4290}]
[null,null,"Annual savings per fixture",{"$f":"D23/D7","v":153.00999999999996},{"$f":"E23/D7","v":163.73499999999999},null,"TOTAL Annual Maintenance Cost (est.)",{"$f":"H29+H30","v":30290}]
[null,null,"Net Energy Savings per fixture over life",{"$f":"D21*D16/D7","v":2353.9999999999995},{"$f":"E21*D16/D7","v":2518.9999999999995},false,"Environmental Impact (USA, 2017 numbers)"]
[null,null,"Net cash generated by each fixture over life",{"$f":"D31*D16-D30","v":2203.9999999999995},{"$f":"E31*D16-E30","v":2329},false,"kWh saved per year Std. \"T\" fixture",{"$f":"D7*(D8*D9-D18*D19)/1000","v":333840}]
[null,null,"Simple ROI",{"$f":"D23/D28","v":1.0200666666666665},{"$f":"E23/E28","v":0.86176315789473668},null,"Metric tons CO2 emission reduced  per year",{"$f":"H33*H40","v":234.68951999999999}]
[null,null,"Payback (months)",{"$f":"12*D28/D23","v":11.76393699758186},{"$f":"12*E28/E23","v":13.924939689131831},null,"lb. coal burning avoided per year",{"$f":"H34/H41","v":250469.07150480256}]
[null,null,"Net Positive Cash by end of fixture life",{"$f":"D23*D16-D28","v":528959.99999999988},{"$f":"E23*D16-E28","v":558959.99999999988},null,"Metric tons coal burning avoided per year",{"$f":"H35/2205","v":113.59141564843654}]
[null,null,"Cost of Waiting (doing nothing)",null,null,null,"Equivalent gallons of gasoline burning avoided",{"$f":"H34/H42","v":26399.271091113609}]
[null,null,"Cost of waiting per year",{"$f":"D23","v":36722.399999999994},{"$f":"E23","v":39296.399999999994},null,"Equivalent acres of forest added",{"$f":"H34/H43","v":221.40520754716979}]
[null,null,"Cost of waiting each month",{"$f":"D38/12","v":3060.1999999999994},{"$f":"E38/12","v":3274.6999999999994},null,"DOE Numbers for the US (2017) generating these calculations"]
[null,null,"Cost of waiting = energy/maintenance spending that could be avoided by upgrading",null,null,null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",7.0299999999999996E-4]
[null,null,"Net Present Value (NPV) Calculation",null,null,null,"CO2 released metric tons. per per lb. of coal burned",9.3700000000000001E-4]
[null,null,"Discount rate for NPV calculation",0.05,null,null,"metric tons CO2 released per gallon of gasoline burned",8.8900000000000003E-3]
[null,null,"Net Present Value of Project (NPV) 5 years",{"$f":"NPV(D42,D23,D23,D23,D23,D23)-D28","v":122988.77408957313},{"$f":"NPV(D42,E23,E23,E23,E23,E23)-E28","v":124532.84703977685},null,"CO2 sequestration metric ton.per acre of forest per year",1.06]
[null,null,"Net Present Value of Project (NPV) 10 years",{"$f":"NPV(D42,D23,D23,D23,D23,D23,D23,D23,D23,D23,D23)-D28","v":247560.63876349624},{"$f":"NPV(D42,E23,E23,E23,E23,E23,E23,E23,E23,E23,E23)-E28","v":257836.38447121793},null," Link to EPA GHG Equivalencies Calculator (2017)"]
[null,null," NPV calculation assumes steady stream of savings over period. In practice, end-user may  replace the fixture earlier due to lumen depreciation and  incur an additional cost."]

{"sheet":"LED_Lamp_Chart","index":10,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[38,2,39,4],[38,5,38,6],[38,7,39,10],[39,5,39,6],[41,8,41,10]]}
[]
[]
[]
[]
[]
[null,null,1,"MVR400/U --> Type A LED",460,"ABV3-24T",165,20000,1,50000]
[null,null,2,"MVR400/U --> Type B LED",460,"ABV3 18T",150,20000,1,50000]
[null,null,3,"MVR250/U --> Type A LED",290,"ABV3-18T",80,10000,1,50000]
[null,null,4,"MVR250/U --> Type B LED",290,"ABV3 18T",115,10000,1,50000]
[null,null,5,"MVR175/U --> Type A LED",210,"ABV3-12T",60,10000,1,50000]
[null,null,6,"MVR175/U --> Type B LED",210,"ABV3-09T",80,10000,1,50000]
[]
[]
[]
[null,null,null,null,"Lamp W","SYS Watts","Lumens","Sys. LPW "]
[null,null,null,"400 LED Type A",130,165,18500,{"$f":"G16/F16","v":112.12121212121212},460]
[null,null,null,"400 LED Type A (old)",165,195,20000,102.56410256410257,460]
[null,null,null,"400 LED Type B",null,150,23500,156.66666666666666,460]
[null,null,null,"250 LED Type A",80,112,11800,105.35714285714286,290]
[null,null,null,"250 LED Type B",null,115,18000,156.52173913043478,290]
[null,null,null,"175 LED Type A",60,88,8800,100,210]
[null,null,null,"175 LED Type B",null,80,12000,150,210]
[null,null,null,"100 LED Type B",50,50,7500,150,120]
[]
[]
[null,null,"Legend","HID --> LED Lamp","Lamp W","Sys W","Lumens","Sys LPW","HID W","Savings W","Savings %"]
[null,null,1,"400 -->  LED Type B",150,150,23500,{"$f":"G27/F27","v":156.66666666666666},460,{"$f":"I27-F27","v":310},{"$f":"J27/I27","v":0.67391304347826086}]
[null,null,2,"250 -->  LED Type B",115,115,18000,156.52173913043478,290,175,0.60344827586206895]
[null,null,3,"175 -->  LED Type B",80,80,12000,150,210,130,0.61904761904761907]
[null,null,4,"100 --> LED Type B",50,50,7500,150,120,70,0.58333333333333337]
[null,null,null,"70 --> LED Type B",35,35,5000,142.85714285714286,94,59,0.62765957446808507]
[null,null,null,"50 --> LED Type B",21,21,3000,142.85714285714286,67,46,0.68656716417910446]
[null,null,"Legend","LED Lamp","Lamp W","Sys W","Lumens","Sys LPW","HID W","Savings W","Savings %"]
[null,null,5,"400 -->  LED Type A",130,165,18500,{"$f":"G34/F34","v":112.12121212121212},460,{"$f":"I34-F34","v":295},{"$f":"J34/I34","v":0.64130434782608692}]
[null,null,6,"400 -->  old LED Type A",165,195,20000,{"$f":"G35/F35","v":102.56410256410257},460,{"$f":"I35-F35","v":265},{"$f":"J35/I35","v":0.57608695652173914}]
[null,null,7,"250  -->  LED Type A",80,112,11800,{"$f":"G36/F36","v":105.35714285714286},290,{"$f":"I36-F36","v":178},{"$f":"J36/I36","v":0.61379310344827587}]
[null,null,8,"175  -->  LED Type A",60,88,8800,{"$f":"G37/F37","v":100},210,{"$f":"I37-F37","v":122},{"$f":"J37/I37","v":0.580952380952381}]
[]
[null,null,"Link to Type B Spec Sheets on Web",null,null,"Checklist Type A",null,"Link to Type A Spec Sheets on Web"]
[null,null,null,null,null,"Checklist Type B"]

{"sheet":"HID_Hi_Watt_to_LED_Lamp","index":11,"n_rows":100,"n_cols":24,"rows_kept":100,"cut":false,"hidden":false,"merged":[[73,5,73,6],[35,2,35,3],[38,2,38,3],[39,2,39,3],[43,2,44,3],[45,2,45,3],[45,5,45,6],[33,5,33,6],[0,2,0,4],[1,5,1,6],[3,2,3,3],[4,2,4,3],[4,5,4,6],[6,5,8,6],[10,5,10,6],[11,5,11,6],[17,2,17,3],[26,5,27,6],[27,2,27,3],[0,5,0,6]]}
[null,null,"                       LED Payback \n                              Calculator",null,null,"Put your company logo here"]
[null,null,null,null,null,"Enter information in green cells; other cells are calculated values (Review -> Unprotect sheet if you want to make changes.) Maintenance savings are projected assuming existing system has reached long-term (steady state.)"]
[null,null,null,null,null,"Opportunity Analysis prepared for:","Date"]
[null,null,"Select the lamp retrofit suggested",null,null,"your email here","your phone # here"]
[null,null,"Manufacturing Area",null,null,"Ballast Compatiblity",null,null,null,null,null,null,null,null,1,"MVR400 --> LED Type A","MVR400",460,"LED130/2M400/750",88109,165,20000,"M59, M135, M155",18500]
[null,null,"Existing Lamp/Fixture Description",{"$f":"VLOOKUP(N6,O5:X14,3,FALSE)","v":"MVR400"},null,"Generally compatible with CWA ANSI Ballast type",{"$f":"VLOOKUP(N6,O5:X14,9,FALSE)","v":"bypass the ballast"},null,null,null,null,null,null,3,2,"MVR400 --> LED Type B","MVR400",460,"LED115ED28/750",22623,115,20000,"bypass the ballast",18000]
[null,null,"# Fixtures",100,null,"(most common metal halide ballasts, probe-start and pulse start.)  Type A not for use with reactor ballasts or electronic ballasts. Not for use with High Pressure Sodium ballasts. Not for use with any dimming systems.",null,null,null,null,null,null,null,null,3,"MVR400 -->  High Lumen Type B","MVR400",460,"LED150ED28/750",22613,150,20000,"bypass the ballast",23500]
[null,null,"Fixture Watts, Existing",{"$f":"VLOOKUP(N6,O5:X14,4,FALSE)","v":460},null,null,null,null,null,"Year","$",null,null,null,4,"MVR250 --> LED Type A","MVR250",290,"LED80/2M250/750",88099,112,10000,"M58, M138, M153",11800]
[null,null,"Burn hr. annual",6000,null,null,null,null,null,0,{"$f":"-D27","v":-20000},null,null,null,5,"MVR250 --> LED Type B","MVR250",290,"LED80ED23.5/750",22676,80,10000,"bypass the ballast",12000]
[null,null,"Energy Rate $ per kWh",0.11,null,"Clik here for Checklist Type A","Checklist Type B",null,null,1,{"$f":"IF(K9+$D$23>$D$35,0,(K9+$D$23))","v":4585},null,null,null,6,"MVR250 --> High Lumen Type B","MVR250",290,"LED115ED28/750",22623,115,10000,"bypass the ballast",18000]
[null,null,"Annual Energy Use (Existing)",{"$f":"D7*D8*D9*D10/1000","v":30360},null,"Click here for ballast compatibility list for Type A",null,null,null,2,{"$f":"IF(K10=$D$35,0,IF(K10=0,0,IF(K10+$D$23<$D$35,K10+$D$23,$D$35)))","v":29170},null,null,null,7,"MVR175 --> LED Type A","MVR175 (Mogul base)",210,"LED60/2M175/750",88107,88,10000,"M57, M137, M152",8800]
[null,null,"Proposed Lamp  Description (5000K if avail.) ",{"$f":"VLOOKUP(N6,O5:X14,5,FALSE)","v":"LED150ED28/750"},null,"Maintenance Savings Calculation",null,null,null,3,53755,null,null,null,8,"MVR175 --> LED Type B","MVR175 (Mogul base)",210,"LED50ED23.5/750",22739,50,10000,"bypass the ballast",7500]
[null,null,"Part Number",{"$f":"VLOOKUP(N6,O5:X14,6,FALSE)","v":22613},null,"Maintenance Savings",null,null,null,4,78340,null,null,null,9,"MVR175 -->High Lumen Type B","MVR175 (Mogul base)",210,"LED80ED23.5/750",22676,80,10000,"bypass the ballast",12000]
[null,null,"Lamp Initial Lumens",{"$f":"VLOOKUP(N6,O5:X14,10,FALSE)","v":23500},null,"Existing Lamp/Fixture Description",{"$f":"D6","v":"MVR400"},null,null,5,102925,null,null,null,10,"MVR175 Med Base --> LED Type B","MVR175 (Med. base)",210,"LED80ED23.5M/740",22768,80,10000,"bypass the ballast",12000]
[null,null,"LED Lamp Rated Life (hr.)",50000,null,"# Fixtures",{"$f":"D7","v":100},null,null,6,127510,null,null,null,null,{"$f":"VLOOKUP(N6,O5:X13,8,FALSE)","v":20000}]
[null,null,"LED Lamp Rated Life (years)",{"$f":"D15/D9","v":8.3333333333333339},null,"# lamps per fixture",1,null,null,7,152095,null,null,null,null,{"$f":"IF(D8=460,IF(E20=1,20000,15000),IF(E19=1,IF(E20=1, 10000,6000),IF(E20=1,15000,12000)))","v":20000}]
[null,null,"Fixture Watts with LED lamp",{"$f":"VLOOKUP(N6,O5:X14,7,FALSE)","v":150},null,"Annual Burn hr.",{"$f":"D9","v":6000},null,null,8,176680]
[null,null,"Costs-Benefits",null,null,"   HID lamp\n   Life hours",{"$f":"P16","v":20000},null,null,9,184875]
[null,null,"Annual Burn hr. (do not change here, go to D9)",{"$f":"D9","v":6000},1,"Cost per lamp (HID)",25,null,null,10,0]
[null,null,"Annual Energy Use (for proposed)",{"$f":"D7*D17*D19*D10/1000","v":9900},1,"Labor to replace one lamp",25]
[null,null,"Energy Savings",{"$f":"D11-D20","v":20460},1,"Disruption cost per event (lamp or ballast out)",50]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(E21=2,0,G33)","v":4125},null,"Estimated # annual lamps replaced (steady state)",{"$f":"(G17/G18)*G15*G16","v":30}]
[null,null,"Total Annual  Savings",{"$f":"D21+D22","v":24585},null,"Annual Cost of lamps replaced",{"$f":"G22*G19","v":750}]
[null,null,"Cost of Proposed Lamp",200,null,"Annual labor for lamps replaced",{"$f":"G22*G20","v":750}]
[null,null,"Labor to Install per fixture",50,null,"Annual disruption from lamps replaced",{"$f":"G22*G21","v":1500}]
[null,null,"Rebate per fixture (put in brackets)",-50,null,"Annual Maintenance cost of existing lamps",{"$f":"SUM(G23:G25)","v":3000}]
[null,null,"Total Investment Required",{"$f":"D7*(D24+D25+D26)","v":20000},null,"Maintenance costs associated with replacement of failed ballasts is not factored in for type A because it is the same for both systems. But for Type B there will be maintenance savings which are calculated below."]
[null,null,"Summary of Benefits"]
[null,null,"Investment per fixture to upgrade",{"$f":"SUM(D24:D26)","v":200},null,"Estimated # annual ballasts replaced (steady state)",{"$f":"(D9/80000)*D7","v":7.5}]
[null,null,"Annual savings per fixture",{"$f":"D23/D7","v":245.85},null,"Cost per ballast",65]
[null,null,"Net Energy Savings per lamp over life of lamp",{"$f":"D21*D16/D7","v":1705},false,"Labor to replace ballast",35]
[null,null,"Net cash generated by each lamp over life",{"$f":"D30*D16-D29","v":1848.75},false,"Annual Maintenance cost ballasts (Type B only)",{"$f":"G29*(G30+G31+G21)","v":1125}]
[null,null,"Simple ROI",{"$f":"D23/D27","v":1.22925},null,"Total Annual Maintenance Savings",{"$f":"IF(G6=\"Bypass the ballast\",G26+G32,G26)","v":4125}]
[null,null,"Payback (months)",{"$f":"12*D27/D23","v":9.7620500305064066},null,"Environmental Impact (USA, 2017 numbers)"]
[null,null,"Net Positive Cash by end of LED lamp life",{"$f":"D23*D16-D27","v":184875},null,"kWh saved per year",{"$f":"D7*(D8*D9-D17*D19)/1000","v":186000}]
[null,null,"Cost of Waiting (doing nothing)",null,null,"Metric tons CO2 emission reduced  per year",{"$f":"G35*G42","v":130.75799999999998}]
[null,null,"Cost of waiting per year",{"$f":"D23","v":24585},null,"lb. coal burning avoided per year",{"$f":"G36/G43","v":139549.6264674493}]
[null,null,"Cost of waiting each month",{"$f":"D37/12","v":2048.75},null,"Metric tons coal burning avoided per year",{"$f":"G37/2205","v":63.287812456893107}]
[null,null,"Cost of waiting = energy/maintenance spending that could be avoided by upgrading",null,null,"Equivalent gallons of gasoline burning avoided",{"$f":"G36/G44","v":14708.436445444317}]
[null,null,"Net Present Value (NPV) Calculation",null,null,"Equivalent acres of forest added",{"$f":"G36/G45","v":123.35660377358488}]
[null,null,"Discount rate for NPV calculation",0.08,null,"Numbers for these calculations","EPA Website link"]
[null,null,"Net Present Value of Project (NPV) 5 years",{"$f":"NPV(D41,D23,D23,D23,D23,D23)-D27","v":78160.776261564723},null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",7.0299999999999996E-4]
[null,null,"Net Present Value of Project (NPV) 10 years",{"$f":"IF(D16>=10,(NPV(D41,D23,D23,D23,D23,D23,D23,D23,D23,D23,D23)-D27),\"Not valid\")","v":"Not valid"},null,"CO2 released metric tons. per per lb. of coal burned",9.3700000000000001E-4]
[null,null," NPV calculation assumes steady stream of savings over period. In practice, end-user may  replace the fixture earlier due to lumen depreciation and  incur an additional cost.",null,null,"metric tons CO2 released per gallon of gasoline burned",8.8900000000000003E-3]
[null,null,null,null,null,"CO2 sequestration metric ton.per acre of forest per year",1.06]
[null,null,"Click here for Tool Documentation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Back to Tool"]

{"sheet":"HID_Low_Watt_to_LED_Lamp","index":12,"n_rows":100,"n_cols":25,"rows_kept":100,"cut":false,"hidden":false,"merged":[[73,5,73,6],[35,2,35,3],[38,2,38,3],[39,2,39,3],[43,2,44,3],[45,2,45,3],[33,5,33,6],[26,5,26,6],[27,2,27,3],[0,2,0,4],[1,5,1,6],[3,2,3,3],[4,2,4,3],[4,5,4,6],[5,5,5,6],[6,5,8,6],[9,5,9,6],[10,5,10,6],[17,2,17,3]]}
[null,null,"                       LED Payback \n                              Calculator",null,null,"Put your company logo here"]
[null,null,null,null,null,"Enter information in green cells; other cells are calculated values  Maintenance savings are projected assuming existing system has reached long-term (steady state.) If sheet is protected go to Review -> Unprotect sheet if you want to make changes (no password.)"]
[null,null,null,null,null,"Opportunity Analysis prepared for:","Date"]
[null,null,"Select the lamp retrofit suggested",null,null,"your email here","your phone # here",null,null,null,null,null,null,null,null,null,null,"HID sys W",null,null,"LED W","life",null,"Lumens","LED Life"]
[null,null,"Manufacturing Area",null,null,"Ballast Compatiblity",null,null,null,null,null,null,null,null,1,"MVR175 med base probe st.--> LED ","MVR175 (probe st.)",210,"LED80ED23.5M/740",22768,80,10000,"bypass the ballast",12000,50000]
[null,null,"Existing Lamp/Fixture Description",{"$f":"VLOOKUP(N6,Lamp_choices,3,FALSE)","v":"MVR175 (probe st.)"},null,"These are direct wired lamps, ballast is removed",null,null,null,null,null,null,null,1,2,"MVR 175 Pulse St. --> LED 4000K","MVR175 (pulse st.)",210,"LED80ED23.5M/740",22768,80,15000,"bypass the ballast",12000,50000]
[null,null,"# Fixtures",100,null,"NOTE: All medium base LED lamps are Type B (ballast bypass) and cover 50W - 175W metal halide replacements. Mogul base LED lamps are available in Type A or B and cover 175W - 400W metal halide replacements.",null,null,null,null,null,null,null,null,3,"MVR/MXR150 --> LED 4000K","MVR/MXR150PA",185,"LED80ED23.5M/740",22768,80,15000,"bypass the ballast",12000,50000]
[null,null,"Fixture Watts, Existing",{"$f":"VLOOKUP(N6,Lamp_choices,4,FALSE)","v":210},null,null,null,null,null,"Year","$",null,null,null,4,"MVR/MXR100 --> LED 4000K","MVR/MXR100",120,"LED50ED23.5M/740",22779,50,15000,"bypass the ballast",7500,50000]
[null,null,"Burn hr. annual",6000,null,null,null,null,null,0,{"$f":"-D27","v":-12000},null,null,null,5,"MVR/MXR70 --> LED 5000K","MVR/MXR70",88,"LED35ED17/750",27724,35,12000,"bypass the ballast",5000,50000]
[null,null,"Energy Rate $ per kWh",0.11,null,"Clik here for Checklist for Type B lamps",null,null,null,1,{"$f":"IF(K9+$D$23>$D$35,0,(K9+$D$23))","v":-3420},null,null,null,6,"MVR/MXR70 --> LED  4000K","MVR/MXR70",88,"LED35ED17/740",27602,35,12000,"M58, M138, M153",5000,50000]
[null,null,"Annual Energy Use (Existing)",{"$f":"D7*D8*D9*D10/1000","v":13860},null,"Type B lamps are not compatible with dimmers",null,null,null,2,{"$f":"IF(K10=$D$35,0,IF(K10=0,0,IF(K10+$D$23<$D$35,K10+$D$23,$D$35)))","v":5160},null,null,null,7,"MXR50 --> LED  5000K","MXR50",67,"LED21ED17/750",27732,21,10000,"bypass the ballast",3000,50000]
[null,null,"Proposed Lamp  Description (5000K if avail.) ",{"$f":"VLOOKUP(N6,Lamp_choices,5,FALSE)","v":"LED80ED23.5M/740"},null,"Maintenance Savings Calculation",null,null,null,3,13740,null,null,null,8,"MXR50 --> LED  4000K","MXR50",67,"LED21ED17/740",27729,21,10000,"bypass the ballast",3000,50000]
[null,null,"Part Number",{"$f":"VLOOKUP(N6,Lamp_choices,6,FALSE)","v":22768},null,"Maintenance Savings",null,null,null,4,22320]
[null,null,"LED Lamp Initial Lumens",{"$f":"VLOOKUP(N6,Lamp_choices,10,FALSE)","v":12000},null,"Existing Lamp/Fixture Description",{"$f":"D6","v":"MVR175 (probe st.)"},null,null,5,30900]
[null,null,"LED Lamp Rated Life (hr.)",{"$f":"VLOOKUP(N6,Lamp_choices,11,FALSE)","v":50000},null,"# Fixtures",{"$f":"D7","v":100},null,null,6,39480,null,null,null,null,{"$f":"VLOOKUP(N6,Lamp_choices,8,FALSE)","v":10000}]
[null,null,"LED Lamp Rated Life (years)",{"$f":"D15/D9","v":8.3333333333333339},null,"# lamps per fixture",1,null,null,7,48060,null,null,null,null,{"$f":"IF(N6=1,IF(E20=1,10000,6000),P15)","v":10000}]
[null,null,"Fixture Watts with LED lamp",{"$f":"VLOOKUP(N6,Lamp_choices,7,FALSE)","v":80},null,"Annual Burn hr.",{"$f":"D9","v":6000},null,null,8,56640]
[null,null,"Costs-Benefits",null,null,"    HID lamp\nrated life (hr.)",{"$f":"P16","v":10000},null,null,9,59500]
[null,null,"Annual Burn hr. (do not change here, go to D9)",{"$f":"D9","v":6000},1,"Cost per lamp (HID)",25,null,null,10,0]
[null,null,"Annual Energy Use (for proposed)",{"$f":"D7*D17*D19*D10/1000","v":5280},1,"Labor to replace one lamp",25]
[null,null,"Energy Savings",{"$f":"D11-D20","v":8580},2,"Disruption cost per event (lamp or ballast out)",50]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(E21=2,0,G33)","v":0},null,"Estimated # annual lamps replaced (steady state)",{"$f":"(G17/G18)*G15*G16","v":60}]
[null,null,"Total Annual  Savings",{"$f":"D21+D22","v":8580},null,"Annual Cost of lamps replaced",{"$f":"G22*G19","v":1500}]
[null,null,"Cost of Proposed Lamp",120,null,"Annual labor for lamps replaced",{"$f":"G22*G20","v":1500}]
[null,null,"Labor to Install per fixture",50,null,"Annual disruption from lamps replaced",{"$f":"G22*G21","v":3000}]
[null,null,"Rebate per fixture (put in brackets)",-50,null,"Annual Maintenance cost of existing lamps",{"$f":"SUM(G23:G25)","v":6000}]
[null,null,"Total Investment Required",{"$f":"D7*(D24+D25+D26)","v":12000},null,"This tool assumes that ballast life is 80,000 hours and estimates\nthe additional maintenance savings from avoiding\nballast replacements by going to a type B LED solution."]
[null,null,"Summary of Benefits"]
[null,null,"Investment per fixture to upgrade",{"$f":"SUM(D24:D26)","v":120},null,"Estimated # annual ballasts replaced (steady state)",{"$f":"(D9/80000)*D7","v":7.5}]
[null,null,"Annual savings per fixture",{"$f":"D23/D7","v":85.8},null,"Cost per ballast",65]
[null,null,"Net Energy Savings per lamp over life of lamp",{"$f":"D21*D16/D7","v":715},false,"Labor to replace ballast",35]
[null,null,"Net cash generated by each lamp over its life",{"$f":"D30*D16-D29","v":595},false,"Annual Maintenance cost ballasts",{"$f":"G29*(G30+G31+G21)","v":1125}]
[null,null,"Simple ROI",{"$f":"D23/D27","v":0.71499999999999997},null,"Total Annual Maintenance Savings",{"$f":"IF(G6=\"Bypass the ballast\",G26+G32,G26)","v":6000}]
[null,null,"Payback (months)",{"$f":"12*D27/D23","v":16.783216783216783},null,"Environmental Impact (USA, 2017 numbers)"]
[null,null,"Net Positive Cash by end of LED lamp life",{"$f":"D23*D16-D27","v":59500},null,"kWh saved per year",{"$f":"D7*(D8*D9-D17*D19)/1000","v":78000}]
[null,null,"Cost of Waiting (doing nothing)",null,null,"Metric tons CO2 emission reduced  per year",{"$f":"G35*G42","v":54.833999999999996}]
[null,null,"Cost of waiting per year",{"$f":"D23","v":8580},null,"lb. coal burning avoided per year",{"$f":"G36/G43","v":58520.811099252933}]
[null,null,"Cost of waiting each month",{"$f":"D37/12","v":715},null,"Metric tons coal burning avoided per year",{"$f":"G37/2205","v":26.540050385148721}]
[null,null,"Cost of waiting = energy/maintenance spending that could be avoided by upgrading now",null,null,"Equivalent gallons of gasoline burning avoided",{"$f":"G36/G44","v":6168.0539932508427}]
[null,null,"Net Present Value (NPV) Calculation",null,null,"Equivalent acres of forest added",{"$f":"G36/G45","v":51.730188679245273}]
[null,null,"Discount rate for NPV calculation",0.08,null,"Numbers for these calculations","EPA Website link"]
[null,null,"Net Present Value of Project (NPV) 5 years",{"$f":"NPV(D41,D23,D23,D23,D23,D23)-D27","v":22257.452118129971},null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",7.0299999999999996E-4]
[null,null,"Net Present Value of Project (NPV) 10 years",{"$f":"IF(D16>=10,(NPV(D41,D23,D23,D23,D23,D23,D23,D23,D23,D23,D23)-D27),\"Lamp life less than 10 yrs.\")","v":"Lamp life less than 10 yrs."},null,"CO2 released metric tons. per per lb. of coal burned",9.3700000000000001E-4]
[null,null," NPV calculation assumes steady stream of savings over period. In practice, end-user may  replace the fixture earlier due to lumen depreciation and  incur an additional cost.",null,null,"metric tons CO2 released per gallon of gasoline burned",8.8900000000000003E-3]
[null,null,null,null,null,"CO2 sequestration metric ton.per acre of forest per year",1.06]
[null,null,"Click here for Tool Documentation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Back to Tool"]

{"sheet":"Tube_System_Wattages","index":13,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,1,10,1],[8,11,10,11],[8,13,10,13],[8,14,10,14],[8,15,10,15],[8,12,10,12],[11,1,13,1],[11,11,13,11],[11,13,13,13],[11,14,13,14],[11,15,13,15],[11,12,13,12],[4,1,4,2],[5,1,7,1],[5,11,7,11],[5,13,7,13],[5,14,7,14],[5,12,7,12],[5,15,7,15],[1,3,3,5],[1,6,1,15],[2,6,2,10],[2,11,2,15],[3,6,3,10],[3,13,3,15],[3,11,3,12]]}
[]
[null,null,null,"Fixture Watts w/flourescent",null,null,"Fixture watts with LED Tubes"]
[null,null,null,null,null,null,"Existing Ballast",null,null,null,null,"Ballast Removed"]
[null,null,null,null,null,null,"Type A",null,null,null,null,"Type B",null,"Type C"]
[null,"Tube -->",null,"25W","28W","32W","10W","12W","13W","15W","18W","11W","14W","10W","13W","18W"]
[null,"2-lamp\nFixture","Low bf",40,43,50,21,24,29,30,34,22,28,24,30,42]
[null,null,"Normal bf",43,47,55,23,29,32,35,41]
[null,null,"High bf",60,64,76,32,42,44,48,54]
[null,"3-lamp\nFixture","Low bf",59,63,73,32,36,44,45,51,33,42,36,45,63]
[null,null,"Normal bf",65,66,80,35,44,48,53,62]
[null,null,"High bf",86,92,110,49,63,66,73,81]
[null,"4-lamp\nFixture","Low bf",77,85,98,42,48,58,60,68,44,56,48,60,84]
[null,null,"Normal bf",87,92,110,46,58,64,70,82]
[null,null,"High bf",116,121,143,65,84,88,96,108]

{"sheet":"LED_Tube_Type-A","index":14,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[13,1,13,2],[14,1,14,2],[7,1,7,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[1,5,1,6],[5,5,6,5],[0,2,0,4],[4,1,4,3],[5,1,5,2],[6,1,6,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[24,5,29,6],[26,1,26,2],[25,1,25,2],[28,1,28,2],[29,1,29,2],[27,1,27,2]]}
[null,null,"LED Type A Tube Simple Payback & ROI Calculator",null,null,"Put your company logo here"]
[null,null,null,null,null,"Enter information in green cells; white cells are calculated values. This calculator includes projected maintenance savings based on the assumption that the existing system has reached long-term (steady state) failure rates."]
[null,null,null,null,null,"Opportunity Analysis prepared for\nSIMCO Industries","Feb. 23, 2017"]
[null,null,null,null,null,"Your email address","Phone No."]
[null,"Name of Area",null,null,null,"Maintenance Savings"]
[null,"Existing Fluorescent Tube",null,"F32T8 Std",null,"Supporting Maintenance\nSavings Calculation"]
[null,"# Fixtures",null,5000]
[null,"# lamps per fixture",null,4,null,"Existing Fluorescent Tube",{"$f":"D6","v":"F32T8 Std"},null,null,"Year","$"]
[null,"Ballast Factor of ballast (L, N or H?)",null,null,null,"# Fixtures",{"$f":"D7","v":5000},null,null,0,{"$f":"-D27","v":-170000}]
[null,"Fixture Watts (Check System Wattage sheet)  *",null,110,null,"# lamps per fixture",{"$f":"D8","v":4},null,null,1,{"$f":"IF(K9+$D$23>$D$30,0,(K9+$D$23))","v":-7999.9999999999709}]
[null,"Burn hr. annual",null,6000,null,"Annual Burn hr.",{"$f":"D11","v":6000},null,null,2,{"$f":"IF(K10=$D$30,0,IF(K10=0,0,IF(K10+$D$23<$D$30,K10+$D$23,$D$30)))","v":154000.00000000006}]
[null,"Energy Rate",null,7.0000000000000007E-2,null,"Fluorescent Lamp Life (hr.)",30000,null,null,3,{"$f":"IF(K11=$D$30,0,IF(K11=0,0,IF(K11+$D$23<$D$30,K11+$D$23,$D$30)))","v":316000.00000000012}]
[null,"Annual Energy Use (Existing)",null,{"$f":"D7*D10*D11*D12/1000","v":231000.00000000003},null,"Cost per fluorescent lamp",4,null,null,4,478000.00000000012]
[null,"Proposed LED Tube ",null,"15W",null,"Labor to replace one lamp",10,null,null,5,640000.00000000012]
[null,"Part Number (optional)",null,null,null,"Disposal Cost per lamp",0.5,null,null,6,802000.00000000012]
[null,"Fixture Watts with LED Tube (Check)*",null,70,null,"Disruption cost per event",5,null,null,7,964000.00000000012]
[null,"Rated life of LED tube (hr.)",null,70000,null,"Estimated annual lamps replaced",{"$f":"(G11/G12)*G9*G10","v":4000},null,null,8,1126000.0000000002]
[null,"Rated life of LED tube (years)",null,{"$f":"D17/D11","v":11.666666666666666},null,"Annual Cost of lamps replaced",{"$f":"G17*G13","v":16000},null,null,9,1288000.0000000002]
[null,"Annual Burn hr.",null,{"$f":"D11","v":6000},null,"Annual labor for lamps replaced",{"$f":"G17*G14","v":40000},null,null,10,1450000.0000000002]
[null,"Annual Energy Use (Proposed)",null,{"$f":"D7*D16*D19*D12/1000","v":147000},null,"Annual disposal cost of lamps replaced",{"$f":"G17*G15","v":2000}]
[null,"Energy Savings",null,{"$f":"D13-D20","v":84000.000000000029},1,"Annual disruption from lamps replaced",{"$f":"G17*G16","v":20000}]
[null,"Maintenance Savings (estimated)",null,{"$f":"IF(E21=2,0,G23)","v":78000},null,"Annual Maintenance cost of lamps",{"$f":"(G11/G12)*G9*G10*(G13+G14+G15+G16)","v":78000}]
[null,"Total Annual Savings",null,{"$f":"D21+D22","v":162000.00000000003},null,"Annual Maintenance Savings (est.)",{"$f":"G22","v":78000}]
[null,"Cost of Proposed Lamps (per fixture)",null,40]
[null,"Labor to Install per fixture",null,10,null,"* Obtain intial and final wattage of fixture by going to the System Wattages Sheet (from the HOME page) and entering the appropriate wattage for the fixure with fluorescent tubes and with the selected LED tube.\nWe Recommended upgrade to maintain light levels\nFluorescent 32W Hight Lumen T8 to 18 W LED Tube\nFluorescent 32W std. or 28W T8 to 15W LED Tube\nFLuorescent 25W T8 to 10W (or 12W)  LED Tube"]
[null,"Additional Cost/rebate per fixture",null,-16]
[null,"Investment Required",null,{"$f":"D7*(D24+D25+D26)","v":170000}]
[null,"Simple ROI",null,{"$f":"D23/D27","v":0.9529411764705884}]
[null,"Payback (months)",null,{"$f":"12*D27/D23","v":12.59259259259259}]
[null,"Net Positive Cash by end of lamp life",null,{"$f":"D23*D18","v":1890000.0000000002}]

{"sheet":"LED_Tube_Type-B","index":15,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[1,5,1,6],[4,2,4,3],[5,5,6,5],[0,3,0,5]]}
[null,null,null,"LED Tube Type C Simple        Payback & ROI Calculator"]
[null,null,null,null,null,"Enter information in green cells; blue cells are calculated values. This calculator includes projected maintenance savings based on the assumption that the existing system has reached long-term (steady state) failure rates."]
[null,null,null,null,null,"Opportunity Analysis prepared:","2020-10-01"]
[null,null,null,null,null,"Your email address","Phone No."]
[null,null,"Manufacturing Area",null,null,"Maintenance Savings"]
[null,null,"Existing Fluorescent Tube","F28T8",null,"Supporting Maintenance\nSavings Calculation"]
[null,null,"# Fixtures",240]
[null,null,"# lamps per fixture",4,null,"Existing Fluorescent Tube",{"$f":"D6","v":"F28T8"},null,null,"year","$"]
[null,null,"Ballast Factor of ballast (L, N or H?)",null,null,"# Fixtures",{"$f":"D7","v":240},null,null,1,{"$f":"-D27","v":-16800}]
[null,null,"Fixture Watts (Check System Wattage sheet)  *",112,null,"# lamps per fixture",{"$f":"D8","v":4},null,null,2,{"$f":"IF(K9+$D$23>$D$30,0,(K9+$D$23))","v":2326.4000000000015}]
[null,null,"Burn hr. annual",8000,null,"Annual Burn hr.",{"$f":"D11","v":8000},null,null,3,{"$f":"IF(K10=$D$30,0,IF(K10=0,0,IF(K10+$D$23<$D$30,K10+$D$23,$D$30)))","v":21452.800000000003}]
[null,null,"Energy Rate",0.11,null,"Fluorescent Lamp Life (hr.)",30000,null,null,4,{"$f":"IF(K11=$D$30,0,IF(K11=0,0,IF(K11+$D$23<$D$30,K11+$D$23,$D$30)))","v":40579.200000000004}]
[null,null,"Annual Energy Use (Existing)",{"$f":"D7*D10*D11*D12/1000","v":23654.400000000001},null,"Cost per fluorescent lamp",4,null,null,5,59705.600000000006]
[null,null,"Proposed LED Tube ",null,null,"Labor to replace one lamp",10,null,null,6,78832]
[null,null,"Part Number",null,null,"Disposal Cost per lamp",0.5,null,null,7,97958.399999999994]
[null,null,"Fixture Watts with LED Tube**",60,null,"# ballasts per fixture",2,null,null,8,117084.79999999999]
[null,null,"Rated life of LED tube (hr.)",50000,null,"Ballast Life (hr.)",80000,null,null,9,119540.00000000001]
[null,null,"Rated life of LED tube (years)",{"$f":"D17/D11","v":6.25},null,"Cost per ballast",14,null,null,10,0]
[null,null,"Annual Burn hr.",{"$f":"D11","v":8000},null,"Labor to replace one ballast",15]
[null,null,"Annual Energy Use (Proposed)",{"$f":"D7*D16*D19*D12/1000","v":12672},null,"Disposal Cost per ballast",0]
[null,null,"Energy Savings",{"$f":"D13-D20","v":10982.400000000001},1,"Disruption cost per event",10]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(E21=2,0,G26)","v":8144},null,"Estimated annual lamps replaced",{"$f":"(G11/G12)*G9*G10","v":256}]
[null,null,"Total Annual Savings",{"$f":"D21+D22","v":19126.400000000001},null,"Estimated ballasts replaced annually",{"$f":"(G11/G17)*G9*G16","v":48}]
[null,null,"Cost of retrofit materials  (per fixture)",65,null,"Annual Maintenance cost of lamps",{"$f":"G22*(G13+G14+G15+G21)","v":6272}]
[null,null,"Labor to Install per fixture",25,null,"Annual Maintenance cost of ballasts",{"$f":"G23*(G18+G19+G20+G21)","v":1872}]
[null,null,"Additional Cost/(rebate) per fixture",-20,null,"Total annual maintenance costs",{"$f":"G24+G25","v":8144}]
[null,null,"Investment Required",{"$f":"D7*(D24+D25+D26)","v":16800}]
[null,null,"Simple ROI",{"$f":"D23/D27","v":1.1384761904761906}]
[null,null,"Payback (months)",{"$f":"12*D27/D23","v":10.540404885394009}]
[null,null,"Net Positive Cash by end of lamp life",{"$f":"D23*D18","v":119540.00000000001}]

{"sheet":"LED_Tube_Type-C","index":16,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,5,1,6],[4,2,4,3],[5,5,6,5],[0,3,0,5]]}
[null,null,null,"LED Simple Payback and ROI Calculator"]
[null,null,null,null,null,"Enter information in green cells; blue cells are calculated values. This calculator includes projected maintenance savings based on the assumption that the existing system has reached long-term (steady state) failure rates."]
[null,null,null,null,null,"Opportunity Analysis prepared for\nSIMCO Industries","2017-04-04"]
[null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,"Manufacturing Area",null,null,"Maintenance Savings"]
[null,null,"Existing Fluorescent Tube","F28T8",null,"Supporting Maintenance\nSavings Calculation"]
[null,null,"# Fixtures",240]
[null,null,"# lamps per fixture",4,null,"Existing Fluorescent Tube",{"$f":"D6","v":"F28T8"},null,null,null,"$"]
[null,null,"Fixture Watts (Check System Wattage sheet)  *",112,null,"# Fixtures",{"$f":"D7","v":240},null,null,1,{"$f":"-D26","v":-16800}]
[null,null,"Burn hr. annual",6880,null,"# lamps per fixture",{"$f":"D8","v":4},null,null,2,{"$f":"IF(K9+$D$22>$D$29,0,(K9+$D$22))","v":-3100.5439999999999}]
[null,null,"Energy Rate",0.11,null,"Annual Burn hr.",{"$f":"D10","v":6880},null,null,3,{"$f":"IF(K10=$D$29,0,IF(K10=0,0,IF(K10+$D$22<$D$29,K10+$D$22,$D$29)))","v":10598.912}]
[null,null,"Annual Energy Use (Existing)",{"$f":"D7*D9*D10*D11/1000","v":20342.784},null,"Fluorescent Lamp Life (hr.)",30000,null,null,4,{"$f":"IF(K11=$D$29,0,IF(K11=0,0,IF(K11+$D$22<$D$29,K11+$D$22,$D$29)))","v":24298.368000000002}]
[null,null,"Proposed LED Tube ",null,null,"Cost per fluorescent lamp",4,null,null,5,37997.824000000001]
[null,null," Part Number",null,null,"Labor to replace one lamp",10,null,null,6,51697.279999999999]
[null,null,"Fixture Watts with Current LED Tube**",84,null,"Disposal Cost per lamp",0.5,null,null,7,65396.735999999997]
[null,null,"Rated life of LED tube (hr.)",50000,null,"ballasts per fixture",2,null,null,8,79096.191999999995]
[null,null,"Rated life of LED tube (years)",{"$f":"D16/D10","v":7.2674418604651159},null,"# Ballast Life (hr.)",80000,null,null,9,92795.648000000001]
[null,null,"Annual Burn hr.",{"$f":"D10","v":6880},null,"Cost per ballast",14,null,null,10,99560]
[null,null,"Annual Energy Use (Proposed)",{"$f":"D7*D15*D18*D11/1000","v":15257.088},null,"Labor to replace one ballast",15,null,null,null,0]
[null,null,"Energy Savings",{"$f":"D12-D19","v":5085.6959999999999},null,"Disposal Cost per ballast",0]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(E21=2,0,G26)","v":8613.76},1,"Disruption cost per event",10]
[null,null,"Total Annual Savings",{"$f":"D20+D21","v":13699.456},null,"Estimated annual lamps replaced",{"$f":"(G11/G12)*G9*G10","v":220.16}]
[null,null,"Cost of materials  (per fixture)",65,null,"Estimated ballasts replaced annually",{"$f":"(G11/G17)*G9*G10","v":82.559999999999988}]
[null,null,"Labor to Install per fixture",25,null,"Annual Maintenance cost of lamps",{"$f":"G22*(G13+G14+G15+G21)","v":5393.92}]
[null,null,"Additional Cost/(rebate) per fixture",-20,null,"Annual Maintenance cost of ballasts",{"$f":"G23*(G18+G19+G20+G21)","v":3219.8399999999997}]
[null,null,"Investment Required",{"$f":"D7*(D23+D24+D25)","v":16800},null,"TOTAL Annual Maintenance Cost (est.)",{"$f":"G24+G25","v":8613.76}]
[null,null,"Simple ROI",{"$f":"D22/D26","v":0.81544380952380957}]
[null,null,"Payback (months)",{"$f":"12*D26/D22","v":14.715912807048689}]
[null,null,"Net Positive Cash by end of lamp life",{"$f":"D22*D17","v":99560}]

{"sheet":"Fixture_Lumens","index":17,"n_rows":28,"n_cols":26,"rows_kept":28,"cut":false,"hidden":false,"merged":[[20,3,20,4],[21,3,21,4],[14,1,14,2],[14,3,14,6],[16,1,16,2],[16,3,16,6],[18,1,18,2],[18,3,18,6],[1,3,1,6],[12,1,12,6],[2,1,2,6],[3,3,3,4],[3,5,3,6],[5,1,5,6],[6,1,6,2],[6,3,6,4],[6,5,7,6],[7,1,7,2],[7,3,7,4],[8,1,8,4],[8,5,9,6],[9,3,9,4],[10,3,10,4],[10,5,10,6]]}
[]
[null,null,null,"Fluorescent to LED: \nFixture Lumens and Watts"]
[null,"This tool provides estimates of fixture lumens and watts\n for multi-lamp T8 fixtures and T12 fixtures Put in values in green cells."]
[null,"Lamp Type","Initial Lumens","No. of Lamps",null,"Ballast factor"]
[null,null,{"$f":"VLOOKUP(P8,Q8:S17,3,FALSE)","v":2925},null,{"$f":"IF(S18=4,6,1+S18)","v":4},null,{"$f":"IF(P8=8, 0.86,VLOOKUP(T8,U8:W11,3,FALSE))","v":0.88}]
[null,{"$f":"IF(P8=4, \"*NOTE: F32T8SP lumens changed from 2800 to 2450 in 2012. Since the ceiling\n probably has a mix of these lamps, an in-between number is being used for lumens.\",IF(P8=8,\"Please make sure you select T12-Mag in the ballst factor drop-down box\",IF(T8=4, \"Please pick an appropriate ballast for your lamp\",\"\")))","v":""}]
[null,"Fixture Efficiency\nwith Fluorescent Tubes",null,"Temperature\nLosses**",null,"**NOTE: The temperature inside fluorescent fixtures is higher than 76F which is where the catalog lumens are measured.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BF"]
[null,0.8,null,0.05,null,null,null,null,null,null,null,null,null,null,null,3,1,"F32T8/HL",3100,2,1,"High",1.18,null,1,"A"]
[null,"Fluorescent Fixture Lumens",null,null,null,"Fluorescent Fixture Watts",null,null,null,null,null,null,null,null,null,null,2,"F32T8SPX",2950,4,2,"Normal",0.88,null,2,"A"]
[null,"Initial","Mean","End-of-Life",null,null,null,null,null,null,null,null,null,null,null,null,3,"F32T8SPP",2925,null,3,"Low",0.78,null,3,"A"]
[null,{"$f":"C5*E5*G5*B8*(1-D8)","v":7824.9600000000009},{"$f":"B11*U17","v":7355.4624000000003},{"$f":"B11*V17","v":7042.4640000000009},null,{"$f":"IF(R18=\"A\",R25,IF(R18=\"B\",R26,IF(R18=\"C\",R27,IF(R18 = \"D\", R28,\"HoHo\"))))","v":110},null,null,null,null,null,2,3,4,null,6,4,"F32T8SP*",2600,null,4,"T12-Mag",0.86,null,4,"A"]
[null,null,null,null,null,null,null,null,null,"A",1.18,76,110,143,null,219,5,"F28T8",2600,null,6,null,null,null,5,"B"]
[null,"LED Tube",null,null,null,null,null,null,null,"A",0.88,55,80,110,null,165,6,"F32T8/25W",2500,null,null,null,null,null,6,"C"]
[null,"Lumens on this ballast (initial)","Fixture Efficiency \nwtih LED","No. of Lamps","LED Fixture Lumens","LED Fixture Watts\n(lookup in System Wattages sheet)","Ratio of LED to Fluor.lumens"]
[null,"Selected LED Tube - 1",null,"15W Type A",null,null,null,null,null,"A",0.77,50,73,98,null,148,null,null,null,null,"Mean L","EOL lum",null,null,7]
[null,2500,0.9,4,{"$f":"B16*C16*D16","v":9000},null,{"$f":"E16/$B$11","v":1.1501656238498343}]
[null,"Selected LED Tube - 2",null,"Type B",null,null,null,null,null,"B",1.18,64,92,121,null,185,8,"F34T12/WM",2650,null,{"$f":"IF(P8=8,0.86, 0.94 )","v":0.94},{"$f":"IF(P8=8,0.74, 0.9 )","v":0.9},null,null,8,"D"]
[null,2350,0.9,4,{"$f":"B18*C18*D18","v":8460},null,{"$f":"E18/$B$11","v":1.0811556864188441},null,null,"B",0.88,47,66,92,null,139,null,{"$f":"VLOOKUP(P8,Y8:Z17,2,0)","v":"A"},3]
[null,"Selected LED Tube - 3",null,"18W Type A",null,null,null,null,null,"B",0.77,43,63,85,null,128]
[null,3200,0.9,2,{"$f":"B20*C20*D20","v":5760},null,{"$f":"E20/$B$11","v":0.73610599926389386},null,null,"C",1.18,60,86,116,null,166]
[null,null,null,null,null,null,null,null,null,"C",0.88,43,65,87,null,130,null,null,null,"K10:N12"]
[null,null,null,null,null,null,null,null,null,"C",0.77,40,59,77,null,117,null,null,null,"K13:N15"]
[null,null,null,null,null,null,null,null,null,"D",null,74,117,148,null,null,null,{"$f":"VLOOKUP(G5,K13:N17,E5:E58)","v":{"$error":"#VALUE!"}},null,"K16:N18"]
[null,null,null,null,null,null,null,null,null,"D",null,74,117,148]
[null,null,null,null,null,null,null,null,null,"D",null,74,117,148,null,null,null,{"$f":"INDEX(_F32,T8,E5)","v":110},null,null,"_F32"]
[null,null,null,null,null,null,null,null,null,"D",null,74,117,148,null,null,null,{"$f":"INDEX(_F28,T8,E5)","v":92},null,null,"_F28"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(_F25,T8,E5)","v":87},null,null,"_F25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(_F34,T8,E5)","v":148}]

{"sheet":"Fixture_vs_Tube","index":18,"n_rows":66,"n_cols":5,"rows_kept":66,"cut":false,"hidden":false,"merged":[[39,1,39,3],[0,1,0,7],[15,1,15,3],[21,1,21,3],[32,1,32,3],[33,2,33,4]]}
[null,"LFL / LED Tube vs. LED Fixture (Cost of Ownership)"]
[null,"Green cells require user input"]
[null,"Energy rate per kWh",7.0000000000000007E-2]
[null,"Burning hr. per yr.",8700]
[null,null,"LFL","LED Fixture","LED Tube A"]
[null,"No. of fixtures",1500,1500,1500]
[null,"LED tube watts (nominal)",null,null,17.5]
[null,"Fixture Watts including driver watts",100,45,70]
[null,null,"LFL LAMP","LED FIXTURE"]
[null,"No. of lamps/fixture",4,null,4]
[null,"Lamp Life",30000,null,50000]
[null,"Lamp Cost",4,null,8]
[null,"Lamp Replacement Labor (spot)",10,null,5]
[null,"Lamp Replacement Labor (group)",5,null,5]
[null,"Lamp Disposal Cost",1,null,0]
[null,"BALLAST / DRIVER (Type C)",null,null,1]
[null,"No. of ballasts/fixture",1,null,1]
[null,"Ballast / Driver (Type C) Life",60000,null,60000]
[null,"Ballast / Driver Cost",20,null,20]
[null,"Ballast / Driver Replacement Labor",25,null,25]
[null,"Ballast / Driver Disposal Cost",1]
[null,"FIXTURE"]
[null,"Fixture Life (Hours)",null,100000]
[null,"OR Fixture Life (Years) (estimated)",20,{"$f":"D23/C4","v":11.494252873563218},20]
[null,"Fixture Cost (initial cost)",0,160,{"$f":"E12*E10","v":32}]
[null,"Labor to Install Fixture or lamps",0,40,{"$f":"E10*E13","v":20}]
[null,"Annualized Fixture Cost (per fixture)",{"$f":"(C25+C26)/C24","v":0},{"$f":"(D25+D26)/D24","v":17.400000000000002},{"$f":"(E25+E26)/E24","v":2.6}]
[null,"Annualized Fixture Cost (all fixtures)",{"$f":"C27*C6","v":0},{"$f":"D27*D6","v":26100.000000000004},{"$f":"E27*E6","v":3900}]
[null,"Annualized Lamp cost",{"$f":"C53","v":30014.998499250083},0,0]
[null,"Annualized Ballast Cost",{"$f":"C60","v":9787.5},0,{"$f":"E60","v":26100}]
[null,"Annual Energy Cost",{"$f":"C6*C8*$C$4*$C$3/1000","v":91350.000000000015},{"$f":"D6*D8*C4*C3/1000","v":41107.500000000007},{"$f":"E6*E8*$C$4*$C$3/1000","v":63945.000000000007}]
[null,"Total Annualized Cost (excluding A/C)",{"$f":"C28+C29+C30+C31","v":131152.4984992501},{"$f":"D31+D28","v":67207.500000000015},{"$f":"E28+E29+E30+E31","v":93945}]
[null,"A/C Savings"]
[null,"Percentage of time A/C is on",0.3]
[null,"Annual Energy Savings prior to A/C",null,{"$f":"$C$31-D31","v":50242.500000000007}]
[null,"A/C Savings",null,{"$f":"(C34*0.34*0.9)*($C$31-D31)","v":4612.2615000000014},{"$f":"(C34*0.34*0.9)*($C$31-E31)","v":2515.7790000000009}]
[null,"Annual Energy Savings including A/C",null,{"$f":"D35+D36","v":54854.761500000008},{"$f":"E35+E36","v":2515.7790000000009}]
[null,"Total Annualized Savings (including A/C)",null,{"$f":"$C$32-D32+D36","v":68557.259999250091},{"$f":"$C$32-E32+E36","v":39723.2774992501}]
[null,"Total Savings over life of LED/LFL Fixtures",null,{"$f":"D37*D24","v":630514.5},{"$f":"E37*E24","v":50315.580000000016}]
[null,"Supporting Data and Calculations"]
[null,"LAMP AND LABOR COSTS"]
[null,"No. of lamps at site",{"$f":"C6*C10","v":6000},null,{"$f":"E6*E10","v":6000}]
[null,"Group Relamping at (hours)",{"$f":"0.6666667*C11","v":20000.000999999997}]
[null,"Group Relamping at (years)",{"$f":"C43/$C$4","v":2.2988506896551719}]
[null,"Cost of Group Relamping (Lamps)",{"$f":"C12*(C42)","v":24000},null,{"$f":"E12*(E42)","v":48000}]
[null,"Disposal Cost of Lamps",{"$f":"C42*C15","v":6000},null,{"$f":"E42*E15","v":0}]
[null,"Cost of Group Relamping (Labor)",{"$f":"C14*C42","v":30000},null,{"$f":"E14*E42","v":30000}]
[null,"Assume Group Relamping at 2/3rds of lamp life; \n10% of lamps replaced prior to group relamping","Spot and Group relamping",null,{"$f":"IF(E16=1, \"Spot and Group relamping\",IF(E16=2, \"Assume no Spot relamping, Group relamping only\"))","v":"Spot and Group relamping"}]
[null,"Cost of lamps replaced prior to grp relamp",{"$f":"0.1*C42*C12","v":2400},null,{"$f":"IF(E16=1,0.1*E42*E12, IF(E16=2,0))","v":4800}]
[null,"Disposal Cost of Lamps prior to grp relamp",{"$f":"0.1*C42*C15","v":600},null,{"$f":"IF(E16=1,0.1*E42*E15, IF(E16=2,0))","v":0}]
[null,"Labor cost of lamps replaced prior to grp relamp",{"$f":"0.1*C42*C13","v":6000},null,{"$f":"IF(E16=1,0.1*E42*E13, IF(E16=2,0))","v":3000}]
[null,"Total Lamp Replacement/Maintenance Costs \nover one group relamping period",{"$f":"SUM(C45:C51)","v":69000},null,{"$f":"SUM(E45:E51)","v":85800}]
[null,"Long term Annualized Lamp cost",{"$f":"C52/C44","v":30014.998499250083},"ZERO",{"$f":"E52/E44","v":{"$error":"#DIV/0!"}}]
[null,"BALLAST AND LABOR COSTS"]
[null,"No. of ballasts at site",{"$f":"C6*C17","v":1500},null,4000]
[null,"Life of ballast (years)",{"$f":"C18/$C$4","v":6.8965517241379306},null,{"$f":"E18/$C$4","v":6.8965517241379306}]
[null,"Replacement ballast costs over life",{"$f":"C55*C19","v":30000},null,{"$f":"E55*E19","v":80000}]
[null,"Replacement ballast labor over life",{"$f":"C55*C20","v":37500},null,{"$f":"E55*E20","v":100000}]
[null,"Total Ballast Cost over life",{"$f":"C57+C58","v":67500},null,{"$f":"E57+E58","v":180000}]
[null,"Long term Annualized Ballast Cost",{"$f":"C59/C56","v":9787.5},null,{"$f":"E59/E56","v":26100}]
[]
[null,"Annual Energy Costs",{"$f":"C31","v":91350.000000000015},{"$f":"D31","v":41107.500000000007},{"$f":"E31","v":63945.000000000007}]
[null,"Annualized Fixture Costs",{"$f":"C28","v":0},{"$f":"D28","v":26100.000000000004},{"$f":"E28","v":3900}]
[null,"Annualized Lamp Cost",{"$f":"C53","v":30014.998499250083},null,{"$f":"E53","v":{"$error":"#DIV/0!"}}]
[null,"Annualized Ballast Cost",{"$f":"C60","v":9787.5},null,{"$f":"E60","v":26100}]
[null,"A/C Savings",{"$f":"D36","v":4612.2615000000014},null,{"$f":"D36-E36","v":2096.4825000000005}]

{"sheet":"Generic_Payback_Tool","index":19,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,43,3],[42,5,42,6],[27,2,27,3],[30,5,30,6],[34,2,34,3],[37,2,37,3],[37,5,37,6],[38,2,38,3],[11,5,11,6],[1,2,1,6],[0,2,0,4],[3,2,3,3],[4,2,4,3],[4,5,4,6]]}
[null,null,"                       LED Payback \n                              Calculator",null,null,"Put your company logo here"]
[null,null,"INSTRUCTIONS: (PLEASE READ!) This tool is used for any fixture upgrade, with flexibility in specifying both \"from\" and \"to.\" Enter information in GREEN  cells only; other cells are calculated values; do not write in them. Maintenance savings are projected assuming existing system has reached long-term (steady state.) Do not change any of the entries in the white and blue cells because this will destroy the formulas and calculations and ruing the spreadsheet."]
[null,null,null,null,null,"Opportunity Analysis:  (insert name here)\n","Date"]
[null,null,"Select the lamp/fixture currently used in the space",null,null,"Your e-mail","Your phone #"]
[null,null,"Manufacturing Area",null,null,"Controls Savings (if included)"]
[null,null,"Existing Lamp/Fixture Description","MVR400",null,"Effect of Occupacy Sensor Controls"]
[null,null,"# Fixtures",240,null,"Effect of Dimming Controls"]
[null,null,"Fixture Watts, Existing",460,null,"Cost of adding controls ($ per fixture)",32]
[null,null,"Burn hr. annual",6500,null,"If Occ. sensors, burn hours reduced to (%) ",0.7]
[null,null,"Energy Rate $ per kWh",0.1,null,"If dimming, effective wattage reduced to (%) ",0.6]
[null,null,"Annual Energy Use (Existing)",{"$f":"D7*D8*D9*D10/1000","v":71760},null,"Energy Consumption reduced to (% of full)",{"$f":"G9*G10","v":0.42}]
[null,null,"Proposed Fixture Description","ABV3",null,"Maintenance Savings Calculation"]
[null,null,"Part# (optional)",null,null,"Maintenance Savings"]
[null,null,"LED Fixture Rated Life (hr.)",50000,null,"Existing Lamp/Fixture Description",{"$f":"D6","v":"MVR400"}]
[null,null,"LED Fixture Rated Life (years)",{"$f":"D14/D9","v":7.6923076923076925},null,"# Fixtures",{"$f":"D7","v":240}]
[null,null,"LED Fixture Watts",89,null,"# lamps per fixture",1]
[null,null,"Effective Wattage with Controls",{"$f":"IF(E32=TRUE,D16*G10, D16)","v":89},null,"# ballasts per fixture (please correct if not 1)",1,null,null,8,{"$f":"IF(K16=$D$34,0,IF(K16=0,0,IF(K16+$D$22<$D$34,K16+$D$22,$D$34)))","v":0}]
[null,null,"Annual Burn hr. (including controls)",{"$f":"IF(E31=TRUE,D9*G9, D9)","v":6500},null,"Annual Burn hr.",{"$f":"D9","v":6500},null,null,9,{"$f":"IF(K17=$D$34,0,IF(K17=0,0,IF(K17+$D$22<$D$34,K17+$D$22,$D$34)))","v":0}]
[null,null,"Annual Energy Use (for proposed)",{"$f":"D7*D17*D18*D10/1000","v":13884},null,"Lamp Life Hours (estimate)",20000,null,null,10,{"$f":"IF(K18=$D$34,0,IF(K18=0,0,IF(K18+$D$22<$D$34,K18+$D$22,$D$34)))","v":0}]
[null,null,"Energy Savings",{"$f":"D11-D19","v":57876},null,"Ballast Life Hours (estimate)",80000]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(E21=2,0,G30)","v":11017.5},1,"Cost per lamp",25]
[null,null,"Total Annual  Savings",{"$f":"D20+D21","v":68893.5},null,"Cost per ballast",65]
[null,null,"Cost of Proposed Fixture",340,null,"Labor to replace one lamp",25]
[null,null,"Labor to Install per fixture",50,null,"Labor to replace one ballast",50]
[null,null,"Additional Cost of controls (per fixture)",{"$f":"IF(E31=TRUE, G8,(IF(E32=TRUE,G8,0)))","v":0},null,"Disposal Cost per lamp",0]
[null,null,"Rebate per fixture (put in brackets)",-100,null,"Disposal Cost per ballast",0]
[null,null,"Total Investment Required",{"$f":"D7*(D23+D24+D25+D26)","v":69600},null,"Disruption cost per event (lamp/ballast out)",50]
[null,null,"Summary of Benefits",null,null,"Annual Maintenance cost of lamps",{"$f":"(G18/G19)*G15*G16*(G21+G23+G25+G27)","v":7800}]
[null,null,"Investment per fixture to upgrade",{"$f":"SUM(D23:D26)","v":290},null,"Annual Maintenance cost of ballasts",{"$f":"(G18/G20)*G15*G17*(G22+G24+G26+G27)","v":3217.5}]
[null,null,"Annual savings per fixture",{"$f":"D22/D7","v":287.05624999999998},null,"TOTAL Annual Maintenance Cost (est.)",{"$f":"G28+G29","v":11017.5}]
[null,null,"Net cash generated by each fixture over life",{"$f":"D30*D15-D29","v":1918.125},false,"Environmental Impact (USA, 2017 numbers)"]
[null,null,"Simple ROI",{"$f":"D22/D27","v":0.98984913793103446},false,"kWh saved per year",{"$f":"D7*(D8*D9-D17*D18)/1000","v":578760}]
[null,null,"Payback (months)",{"$f":"12*D27/D22","v":12.12305950488798},null,"Metric tons CO2 emission reduced  per year",{"$f":"G32*G39","v":406.86827999999997}]
[null,null,"Net Positive Cash by end of fixture life",{"$f":"D22*D15-D27","v":460350},null,"lb. coal burning avoided per year",{"$f":"G33/G40","v":434224.41835645674}]
[null,null,"Cost of Waiting (doing nothing)",null,null,"Metric tons coal burning avoided per year",{"$f":"G34/2205","v":196.9271738578035}]
[null,null,"Cost of waiting per year",{"$f":"D22","v":68893.5},null,"Equivalent gallons of gasoline burning avoided",{"$f":"G33/G41","v":45766.960629921254}]
[null,null,"Cost of waiting each month",{"$f":"D36/12","v":5741.125},null,"Equivalent acres of forest added",{"$f":"G33/G42","v":383.83799999999997}]
[null,null,"Cost of waiting = energy/maintenance spending that could be avoided by upgrading",null,null,"DOE Numbers for the US (2017) generating these calculations"]
[null,null,"Net Present Value (NPV) Calculation",null,null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",7.0299999999999996E-4]
[null,null,"Discount rate for NPV calculation",0.05,null,"CO2 released metric tons. per per lb. of coal burned",9.3700000000000001E-4]
[null,null,"Net Present Value of Project (NPV) 5 years",{"$f":"NPV(D40,D22,D22,D22,D22,D22)-D27","v":228672.80100810435},null,"metric tons CO2 released per gallon of gasoline burned",8.8900000000000003E-3]
[null,null,"Net Present Value of Project (NPV) 10 years",{"$f":"NPV(D40,D22,D22,D22,D22,D22,D22,D22,D22,D22,D22)-D27","v":462377.34534379374},null,"CO2 sequestration metric ton.per acre of forest per year",1.06]
[null,null," NPV calculation assumes steady stream of savings over period. In practice, end-user may  replace the fixture earlier due to lumen depreciation and  incur an additional cost.",null,null," Link to EPA GHG Equivalencies Calculator (2017)"]

{"sheet":"Generic_2-Option","index":20,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[[11,6,11,7],[0,2,0,5],[1,2,2,4],[3,2,3,4],[4,3,4,4],[4,6,4,7],[5,3,5,4],[27,2,27,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,2,11,2],[13,3,13,4],[14,3,14,4],[17,3,17,4],[20,3,20,4],[24,3,24,4],[42,6,42,7],[43,2,44,3],[30,6,30,7],[35,2,35,4],[37,6,37,7],[38,2,38,3],[39,2,39,4],[40,3,40,4]]}
[null,null,"LED 2-Option Comparison\nPayback Calculator",null,null,null,"Put your company logo here"]
[null,null,"INSTRUCTIONS: (PLEASE READ!) This tool allows you to compare two different options for an energy-saving upgrade. Enter information in GREEN  cells only; other cells are calculated values and these cells are protected. Maintenance savings are projected assuming the existing legacy system has reached long-term steady state and that lamps and ballasts are replaced as soon as they fail. You have the option of including or excluding projected maintenance savings with your calculations by checking the radio button, also the option of including or excluding dimming and occ sensor impact."]
[null,null,null,null,null,null,"Opportunity Analysis prepared for\nSIMCO Industries","Date"]
[null,null,"Area Name",null,null,null,"Your e-mail","Your phone #"]
[null,null,"Existing Lamp/Fixture Description","DH 445",null,null,"Addition of Controls"]
[null,null,"# Fixtures",240,null,null,"Effect of Occupacy Sensor Controls"]
[null,null,"Fixture Watts, Existing",180,null,null,"Effect of Dimming Controls",null,null,null,null,"T","H"]
[null,null,"Burn hr. annual",6500,null,null,"Cost of adding controls ($ per fixture)",32,null,null,"Year","$"]
[null,null,"Energy Rate $ per kWh",0.11,null,null,"If Occ. sensors, burn hours reduced to (%) ",0.7,null,null,0,{"$f":"-D27","v":-36000},{"$f":"-E27","v":-45600}]
[null,null,"Annual Energy Use (Existing)",{"$f":"D6*D7*D8*D9/1000","v":30888},null,null,"If dimming, effective wattage reduced to (%) ",0.6,null,null,1,{"$f":"IF(L9+$D$22>$D$35,0,(L9+$D$22))","v":-23816.400000000001},{"$f":"IF(M9+$E$22>$E$35,0,(M9+$E$22))","v":-29812.799999999999}]
[null,null,"Proposed Fixture Description","Option 1","Option 2",null,"Energy Consumption reduced to (% of full)",{"$f":"H9*H10","v":0.42},null,null,2,{"$f":"IF(L10=$D$35,0,IF(L10=0,0,IF(L10+$D$22<$D$35,L10+$D$22,$D$35)))","v":-11632.800000000003},{"$f":"IF(M10+$E$22>$E$35,0,(M10+$E$22))","v":-14025.599999999999}]
[null,null,null,null,null,null,"Maintenance Savings Calculation",null,null,null,3,550.79999999999563,1761.6000000000022]
[null,null,"Part Number (if you wish to specify)",null,null,null,"Maintenance Savings",null,null,null,4,12734.399999999994,17548.800000000003]
[null,null,"LED Fixture Rated Life (hr.)",100000,null,null,"Existing Lamp/Fixture Description",{"$f":"D5","v":"DH 445"},null,null,5,24917.999999999993,33336]
[null,null,"LED Fixture Rated Life (years)",{"$f":"D14/D18","v":15.384615384615385},null,null,"# Fixtures",{"$f":"D6","v":240},null,null,6,37101.599999999991,49123.199999999997]
[null,null,"LED Fixture Watts",109,88,null,"# lamps per fixture",1,null,null,7,49285.19999999999,64910.399999999994]
[null,null,"Effective Wattage with Controls",{"$f":"IF(F32=TRUE,D16*H10, D16)","v":109},{"$f":"IF(F32=TRUE,E16*H10, E16)","v":88},null,"# ballasts per fixture (please correct if not 1)",1,null,null,8,61468.799999999988,80697.599999999991]
[null,null,"Annual Burn hr. (including controls)",{"$f":"IF(F31=TRUE,D8*H9, D8)","v":6500},null,null,"Annual Burn hr.",{"$f":"D8","v":6500},null,null,9,73652.399999999994,96484.799999999988]
[null,null,"Annual Energy Use (for proposed)",{"$f":"D6*D17*D18*D9/1000","v":18704.400000000001},{"$f":"D6*E17*D18*D9/1000","v":15100.8},null,"Lamp Life (best guess)",30000,null,null,10,85836,112271.99999999999]
[null,null,"Energy Savings",{"$f":"D10-D19","v":12183.599999999999},{"$f":"D10-E19","v":15787.2},null,"Ballast Life (best guess)",80000]
[null,null,"Maintenance Savings (estimated)",{"$f":"IF(F21=2,0,H30)","v":0},null,2,"Cost per lamp",25]
[null,null,"Total Annual  Savings",{"$f":"D20+D21","v":12183.599999999999},{"$f":"E20+D21","v":15787.2},null,"Cost per ballast",65]
[null,null,"Cost of Proposed Fixture",200,240,null,"Labor to replace one lamp",25]
[null,null,"Labor to Install per fixture",50,50,null,"Labor to replace one ballast",50]
[null,null,"Additional Cost of controls (per fixture)",{"$f":"IF(F31=TRUE, H8,(IF(F32=TRUE,H8,0)))","v":0},null,null,"Disposal Cost per lamp",0]
[null,null,"Rebate per fixture (put in brackets)",-100,-100,null,"Disposal Cost per ballast",0]
[null,null,"Total Investment Required",{"$f":"D6*(D23+D24+D25+D26)","v":36000},{"$f":"D6*(E23+E24+E25+E26)","v":45600},null,"Disruption cost per event (lamp/ballast out)",50]
[null,null,"Summary of Benefits",null,null,null,"Annual Maintenance cost of lamps",{"$f":"(H18/H19)*H15*H16*(H21+H23+H25+H27)","v":5200}]
[null,null,"Investment per fixture to upgrade",{"$f":"SUM(D23:D26)","v":150},{"$f":"SUM(E23:E26)","v":190},null,"Annual Maintenance cost of ballasts",{"$f":"(H18/H20)*H15*H17*(H22+H24+H26+H27)","v":3217.5}]
[null,null,"Annual savings per fixture",{"$f":"D22/D6","v":50.764999999999993},{"$f":"E22/D6","v":65.78},null,"TOTAL Annual Maintenance Cost (est.)",{"$f":"H28+H29","v":8417.5}]
[null,null,"Net Energy Savings per fixture over life",{"$f":"D20*D15/D6","v":780.99999999999989},{"$f":"E20*D15/D6","v":1012.0000000000001},false,"Environmental Impact (USA, 2017 numbers)"]
[null,null,"Net cash generated by each fixture over life",{"$f":"D30*D15-D29","v":630.99999999999989},{"$f":"E30*D15-E29","v":822},false,"kWh saved per year Std. \"T\" fixture",{"$f":"D6*(D7*D8-D17*D18)/1000","v":110760}]
[null,null,"Simple ROI",{"$f":"D22/D27","v":0.33843333333333331},{"$f":"E22/E27","v":0.34621052631578947},null,"Metric tons CO2 emission reduced  per year",{"$f":"H32*H39","v":77.864279999999994}]
[null,null,"Payback (months)",{"$f":"12*D27/D22","v":35.457500246232648},{"$f":"12*E27/E22","v":34.660991182730314},null,"lb. coal burning avoided per year",{"$f":"H33/H40","v":83099.551760939154}]
[null,null,"Net Positive Cash by end of fixture life",{"$f":"D22*D15-D27","v":151439.99999999997},{"$f":"E22*D15-E27","v":197280.00000000003},null,"Metric tons coal burning avoided per year",{"$f":"H34/2205","v":37.686871546911178}]
[null,null,"Cost of Waiting (doing nothing)",null,null,null,"Equivalent gallons of gasoline burning avoided",{"$f":"H33/H41","v":8758.6366704161974}]
[null,null,"Cost of waiting per year",{"$f":"D22","v":12183.599999999999},{"$f":"E22","v":15787.2},null,"Equivalent acres of forest added",{"$f":"H33/H42","v":73.456867924528296}]
[null,null,"Cost of waiting each month",{"$f":"D37/12","v":1015.2999999999998},{"$f":"E37/12","v":1315.6000000000001},null,"DOE Numbers for the US (2017) generating these calculations"]
[null,null,"Cost of waiting = energy/maintenance spending that could be avoided by upgrading",null,null,null,"CO2 Emission factor (metric tons CO2 per kWh generated) ",7.0299999999999996E-4]
[null,null,"Net Present Value (NPV) Calculation",null,null,null,"CO2 released metric tons. per per lb. of coal burned",9.3700000000000001E-4]
[null,null,"Discount rate for NPV calculation",0.05,null,null,"metric tons CO2 released per gallon of gasoline burned",8.8900000000000003E-3]
[null,null,"Net Present Value of Project (NPV) 5 years",{"$f":"NPV(D41,D22,D22,D22,D22,D22)-D27","v":16748.611964297641},{"$f":"NPV(D41,E22,E22,E22,E22,E22)-E27","v":22750.314094582864},null,"CO2 sequestration metric ton.per acre of forest per year",1.06]
[null,null,"Net Present Value of Project (NPV) 10 years",{"$f":"NPV(D41,D22,D22,D22,D22,D22,D22,D22,D22,D22,D22)-D27","v":58078.529683216053},{"$f":"NPV(D41,E22,E22,E22,E22,E22,E22,E22,E22,E22,E22)-E27","v":76304.573674026455},null," Link to EPA GHG Equivalencies Calculator (2017)"]
[null,null," NPV calculation assumes steady stream of savings over period. In practice, end-user may  replace the fixture earlier due to lumen depreciation and  incur an additional cost."]

{"sheet":"Multiple_Systems","index":21,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,2,31,9],[34,2,34,3],[34,8,34,9],[28,3,28,5],[28,7,28,9],[29,3,29,5],[29,7,29,9],[30,2,30,6],[30,7,30,9],[25,1,26,5],[25,6,26,6],[25,7,26,9],[27,1,27,2],[27,3,27,6],[27,7,27,10],[20,1,20,10],[21,1,24,1],[21,2,21,3],[21,4,24,5],[21,7,22,9],[22,2,22,3],[23,2,23,3],[23,7,24,9],[24,2,24,3],[17,1,17,5],[17,7,17,9],[18,1,19,5],[18,7,19,7],[18,8,18,10],[19,8,19,10],[14,1,14,4],[14,6,14,9],[15,1,15,4],[15,6,15,9],[16,1,16,5],[16,7,16,9],[4,1,4,5],[4,6,4,10],[1,3,1,6],[2,1,2,9],[3,1,3,5],[3,6,3,8]]}
[]
[null,null,null,"Multiple Systems\nEnergy Estimator"]
[null,"Calculate the energy costs associated with existing and proposed lighting systems\nand (optional) show environmental impact.Click on the first green cell and tab to the other input cells."]
[null,"You can increase the # rows to accommodate more systems by right-clicking > insert on the row number",null,null,null,null,"Energy Rate ($ per kWh)",null,null,0.09]
[null,"Existing Systems",null,null,null,null,"Proposed System"]
[null,"Existing\nSystems","Fixture count","Watts/Fixture","Hr burn per year","Energy $ per yr.","Proposed\nSystems","Fixture count","Watts/Fixture","Hr burn per year","Energy $ per yr."]
[null,"60PAR/HIR/S/FL ",84,60,3224,{"$f":"IF(C7*D7*E7=0,\"\",C7*D7*E7*$J$4/1000)","v":1462.4063999999998},"LEDPAR30 10W",84,10,3224,{"$f":"IF(H7*I7*J7=0,\"\",H7*I7*J7*$J$4/1000)","v":243.73439999999999}]
[null,"F28T8 3 lamp",80,73,4000,2102.4,"LED Type A Tube",80,51,4000,1468.8]
[null,"50PAR30/H",56,50,3100,781.2,"LEDPAR30 10W",56,10,3100,156.24]
[null,null,null,null,null,"",null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,""]
[null,null,null,null,null,"",null,null,null,null,""]
[null,"Energy used per yr. (Existing System)",null,null,null,{"$f":"SUM(F7:F14)","v":4346.0064000000002},"Energy used per yr. (Proposed System)",null,null,null,{"$f":"SUM(K7:K14)","v":1868.7744}]
[null,"Electrical Load (kilo-watts) (Existing System)",null,null,null,{"$f":"(C7*D7+C8*D8+C9*D9+C10*D10+C11*D11+C12*D12+C13*D13+C14*D14)/1000","v":13.68},"Electrical Load (kilo-watts)  (Proposed System)",null,null,null,{"$f":"(H7*I7+H8*I8+H9*I9+H10*I10+H11*I11+H12*I12+H13*I13+H14*I14)/1000","v":5.48}]
[null,"Potential Energy Savings per year",null,null,null,null,{"$f":"F15-K15","v":2477.232},"kilo-Watt load reduction",null,null,{"$f":"F16-K16","v":8.1999999999999993}]
[null,"Estimated total cost for complete upgrade",null,null,null,null,6500,"Simple Payback (based on energy savings alone)",null,null,{"$f":"IF(G18=\"\",\"\",(ROUNDUP((G18*12/G17),0)))","v":32}]
[null,"Cost of Waiting\n(Cost of postponing the Lighting Upgrade)",null,null,null,null,{"$f":"G17/12","v":206.43600000000001},"or",{"$f":"G17","v":2477.232}]
[null,null,null,null,null,null,"per month",null,"per year"]
[null,"Environmental Impact of Lighting Upgrade\nChanging your lights can benefit the environment!"]
[null,"Annual Carbon Dioxide emission reduction ",{"$f":"C29*$G$17/J4","v":42663.44},null,"Coal burning avoided ",null,{"$f":"C22/G29","v":20610.357487922709},"Equivalent acres of forest added",null,null,{"$f":"C22/K29","v":18.255643988018829}]
[null,null,"lbs.",null,null,null,"lbs.  Or",null,null,null,"acres",null,null,"  "]
[null,null,{"$f":"C22/2205","v":19.348498866213152},null,null,null,{"$f":"IF(G22/2200<1,\"Less than 1\",G22/2200)","v":9.3683443126921411},"Equivalent urban trees added",null,null,{"$f":"C22/K30","v":496.08651162790699}]
[null,null,"metric tons",null,null,null,"metric tons",null,null,null,"trees"]
[null,"Numbers below  based on EPA GHG\nEquivalencies Calculator (2017)",null,null,null,null,"Click to open","Equivalent # cars removed from the road",null,null,{"$f":"C22/G30","v":4.0912389719984663}]
[null,null,null,null,null,null,null,null,null,null,"cars"]
[null,"Emission Factors: gases released per kWh of electricity generated (EPA 2007)\n\n",null,"Carbon dioxide released \nper lb. of coal burned (EPA 2007)\n(can vary based on type of coal)\n",null,null,null,"Annual carbon dioxide (lbs.)\nsequestration by forest and \nemission by cars  (EPA 2007)"]
[null," lbs. of CO2 released",1.55,"lbs. of CO2 generated",null,null,2.0699999999999998,"CO2 sequestration per acre",null,null,2337]
[null,null,null,"CO2 emission per average car",null,null,10428,"CO2 sequestration per urban tree per year",null,null,86]
[null,"Customer:","Bo Peep Industries",null,null,null,null,{"$f":"TODAY()","v":"2021-03-17"}]
[null,"Prepared by: "]

{"sheet":"Simple_Layouts","index":22,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[14,1,14,2],[19,1,19,2],[20,1,20,2],[24,1,25,2],[0,1,0,2],[1,1,2,2],[5,1,5,2],[6,1,6,2],[12,1,12,2],[13,1,13,2]]}
[null,"Simple Lighting Layout Estimators"]
[null,"These estimators provides a rough lighting layout for industrial (high ceiling area) or office (low ceiling area) assuming typical surface reflectances on walls and ceilings. More accurate layouts can be done with the indoor design tool link available on the web page for the chosen fixture, or by using a commercial lighting layout program."]
[]
[null,null,null,1]
[null,"Area to be lit (sq. ft.)",160000]
[null,"(1) FIXTURE QUANTITY ESTIMATOR"]
[null," # fixtures needed to achieve desired footcandles"]
[null,"Footcandles desired (initial)",50]
[null,"Initial lumens of selected fixture",18000]
[null,"Number of fixtures needed (approx.)",{"$f":"(C5*C8)/(C9*C27)","v":444.99982599129601}]
[null,"Fixture spacing (approx. ft., square grid)",{"$f":"(C5/C10)^0.5","v":18.961822232927666}]
[]
[null,"(2) FIXTURE LUMEN REQUIREMENT ESTIMATOR"]
[null,"Fixture lumens required to provide desired footcandles"]
[null,"Preferred fixture spacing (length and width)"]
[null,"Length (ft.)",18]
[null,"Width (ft.)",20]
[null,"Footcandles desired (initial)",50]
[null,"Approx. initial lumens needed for fixture to provide required light level initially",{"$f":"(C16*C17*C18)/(C27)","v":18022.492952647488}]
[null,"(3) FOOTCANDLE  ESTIMATOR"]
[null,"Footcandles generated by a certain number of fixtures"]
[null,"Number of fixtures",40]
[null,"Initial lumens of selected fixture",18000]
[null,"Approximate average footcandles",{"$f":"C23*C22*C27/C5","v":4.4943837799143749}]
[null,"METHOD: Based on the size of the room and assuming normal reflectances, the tool estimates a certain Fixure Coefficient of Utilization (FCU) which is the fraction of the fixture lumens that will reach the workplane (ball park figure.)"]
[]
[null,"With the dimension specified here, the estimated FCU is",{"$f":"0.6+0.4*EXP(-500*D4^4/C5)","v":0.99875195109208326}]

{"sheet":"Energy_Rates","index":23,"n_rows":27,"n_cols":12,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,1,11],[3,1,7,3]]}
[]
[null,"Energy Rates By Region and State"]
[]
[null,"Electric rates (in cents per kWh) listed separately by State for commercial markets and for industrial markets. Source: US Energy Information Administration (EIA) report of July 2018",null,null,null,"Region/State","Commercial","Industrial",null,"Region/State","Commercial","Industrial"]
[null,null,null,null,null,"West North Central",10.01,7.28,null,"West South Central",8.15,5.41]
[null,null,null,null,null,"Iowa",9.68,5.7,null,"Arkansas",7.54,5.23]
[null,null,null,null,null,"Kansas",10.39,7.92,null,"Louisiana",8.65,5.15]
[null,null,null,null,null,"Minnesota",10.6,8,null,"Oklahoma",7.52,5.14]
[null,null,null,null,null,"Missouri",10.050000000000001,7.55,null,"Texas",8.23,5.57]
[null,"Region/State","Commercial","Industrial",null,"Nebraska",9,7.33,null,"Mountain",9.92,6.44]
[null,"New England",15.89,12.61,null,"North Dakota",9.1999999999999993,8.4700000000000006,null,"Arizona",11.32,6.89]
[null,"Connecticut",16.55,12.59,null,"South Dakota",9.41,7.66,null,"Colorado",10.09,7.24]
[null,"Maine",12.18,8.94,null,"South Atlantic",9.24,6.26,null,"Idaho",8.16,6.95]
[null,"Massachusetts",16.13,14.3,null,"Delaware",9.6,7.08,null,"Montana",10.33,4.72]
[null,"New Hampshire",16.36,13.53,null,"District of Columbia",11.6,7.99,null,"Nevada",7.8,5.37]
[null,"Rhode Island",15.61,14.54,null,"Florida",9.2899999999999991,7.6,null,"New Mexico",9.69,5.62]
[null,"Vermont",15.29,10.210000000000001,null,"Georgia",9.6199999999999992,5.54,null,"Utah",9.11,6.13]
[null,"Middle Atlantic",12.04,6.88,null,"Maryland",10.3,8.15,null,"Wyoming",9.9600000000000009,6.95]
[null,"New Jersey",12.24,9.6199999999999992,null,"North Carolina",8.33,5.77,null,"Pacific Contiguous",13.64,9.2899999999999991]
[null,"New York",13.71,6.54,null,"South Carolina",10.09,5.89,null,"California",15.6,12.64]
[null,"Pennsylvania",9.02,6.59,null,"Virginia",8.33,6.85,null,"Oregon",9.07,6.06]
[null,"East North Central",10.199999999999999,6.94,null,"West Virginia",9.59,6.63,null,"Washington",8.6199999999999992,4.37]
[null,"Illinois",8.84,6.45,null,"East South Central",10.41,5.91,null,"Pacific Noncontiguous",24.55,23.45]
[null,"Indiana",10.199999999999999,7.06,null,"Alabama",11.23,6.24,null,"Alaska",18.899999999999999,17.510000000000002]
[null,"Michigan",11.45,7.29,null,"Kentucky",9.49,5.62,null,"Hawaii",29.35,25.7]
[null,"Ohio",10.09,6.66,null,"Mississippi",10.83,6.02]
[null,"Wisconsin",11.3,7.71,null,"Tennessee",10.220000000000001,5.63,null,"U.S. Total",10.51,6.82]

{"sheet":"Environmental","index":24,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,1,24,3],[24,5,24,8],[26,2,26,6],[26,7,26,8],[27,2,27,8],[23,1,23,3],[23,5,23,7],[16,1,17,4],[16,6,16,8],[18,1,18,4],[18,6,18,8],[19,1,19,4],[19,6,19,8],[20,1,20,4],[20,6,20,8],[21,1,21,7],[22,1,22,3],[22,5,22,7],[17,6,17,8],[10,1,11,4],[10,5,11,7],[10,8,11,8],[13,1,13,8],[14,1,15,4],[14,6,14,8],[15,6,15,8],[6,1,6,4],[6,5,6,8],[7,1,7,3],[7,5,7,7],[8,1,9,4],[8,5,8,7],[9,5,9,7],[1,2,1,5],[4,4,4,6],[4,7,4,8],[5,4,5,6],[5,7,5,8],[1,6,1,8]]}
[]
[null,null,"Environmental Impact\nEstimator 2017 (USA)"]
[]
[]
[null,null,null,null,"Opportunity Analysis prepared for\nSIMCO Industries",null,null,"2017-06-20"]
[null,null,null,null,null,null,null,{"$f":"[8]HOME!C5","v":"440 555 1212"}]
[null,"Direct Entry of kWh saved per year",null,null,null,"Calculation of kWh saved per year"]
[null,"kWh saved per year ",null,null,569250,"No. of Fixtures",null,null,500]
[null,"(or delete this cell to use \nthe calculated number on the right)",null,null,null,"Watts saved per fixture",null,null,{"$f":"465-126","v":339}]
[null,null,null,null,null,"Burning Hours per year",null,null,4000]
[null,"If you are using this number, please delete the green cells on the right so there is no confusion about which number is being used in the calculation.",null,null,null,{"$f":"IF(E8<>\"\",\"Delete Green Cell on the left if you wish to use this calculated number\",\"kWH saved per year (calculated)\")","v":"Delete Green Cell on the left if you wish to use this calculated number"},null,null,{"$f":"IF(E8=\"\",I8*I9*I10/1000,\"\")","v":""}]
[]
[]
[null,"ENVIRONMENTAL IMPACT (2017 numbers for US)"]
[null,"Carbon Dioxide emission reduction ",null,null,null,{"$f":"IF((E8=\"\"),I11*E23,E8*E23)","v":882337.5},"lb. CO2 per year"]
[null,null,null,null,null,{"$f":"F15/2205","v":400.15306122448982},"metric tons CO2 per year"]
[null,"Coal Burning Avoided",null,null,null,{"$f":"F15/(E24)","v":426250.00000000006},"lb. per year"]
[null,null,null,null,null,{"$f":"F17/2205","v":193.3106575963719},"metric tons per year"]
[null,"Equivalent  forestation",null,null,null,{"$f":"F15/I23","v":377.55134788189986},"acres of forest added"]
[null,"Equivalent urban trees",null,null,null,{"$f":"F15/I24","v":10259.738372093023},"trees planted and grown to full"]
[null,"Equivalent # cars removed from the road",null,null,null,{"$f":"F15/E25","v":84.612341772151893},"cars removed from the road"]
[null,"Numbers below  based on EPA GHG Equivalencies Calculator (2020)",null,null,null,null,null,null,"Click to open"]
[null,"CO2 Emission factor\nlb. CO2 per kWh generated ",null,null,1.55,"CO2  sequestration lb.per \nacre of forest per year",null,null,2337]
[null,"CO2 released lb. per\nper lb. of coal burned",null,null,2.0699999999999998,"CO2  sequestration lb.per \nurban tree per year",null,null,86]
[null,"Average CO2 emission lb. per \npassenger car per year",null,null,10428,"NOTE:  These numbers are representative.  They vary based on type of coal burned, kind of forest considered, size of car and percent of energy coming from coal burning."]

{"sheet":"AC_Savings","index":25,"n_rows":160,"n_cols":17,"rows_kept":160,"cut":false,"hidden":false,"merged":[[1,2,1,3],[2,1,2,4],[3,1,4,2],[5,1,5,2],[6,1,6,2],[6,3,6,4],[28,2,28,3],[29,2,29,4],[7,1,7,4],[10,1,10,4],[12,4,16,4],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[]
[null,null,"A/C Savings\nEstimator"]
[null,"This tool estimates the additional savings resulting from A/C load reduction in\nair-conditioned spaces when an energy-efficient lighting upgrade is carried out.",null,null,null,null,null,null,null,"State","City",null,null,"Coolng Wk","Fraction","Fraction*.9"]
[null,"Conversion or EER rating to COP\nEER = Energy Efficiency Rating;\nSEER = Seasonal EER (averaged over seasons)",null,"EER Rating","COP",null,null,"Alabama",null,"Alabama","Birmingham","Alamogordo","New_Mexico",33,{"$f":"N4/52","v":0.63461538461538458},{"$f":"O4*0.9","v":0.57115384615384612},{"$f":"P4/$D$6","v":0.16651715631307468}]
[null,null,null,11.7,{"$f":"D5/3.41","v":3.4310850439882694},null,null,"Arizona",null,null,"Montgomery","Albany","New_York",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,"COP value of A/C System",null,3.43,"Help",null,null,"Arkansas",null,null,"Huntsville","Albuquerque","New_Mexico",27,0.51923076923076927,0.46730769230769237,0.13624130971069748]
[null,"(COP = Coefficient of Performance)",null,"If in doubt, use 3.43 (conservative)",null,null,null,"California",null,null,"Mobile","Alexandria","Louisana",37,0.71153846153846156,0.64038461538461544,0.18670105404799284]
[null,"Select Location of Site (Use Drop-Down arrows that appear when you enter Green Cells)",null,null,null,null,null,"Colorado",null,"Arizona","Tuscon","Altus","Oklahoma",31,0.59615384615384615,0.53653846153846152,0.15642520744561558]
[null,"State","City","Cooling\nWeeks","A/C savings\nMultiplier",null,null,"DC",null,null,"Flagstaff","Amarillo","Texas",28,0.53846153846153844,0.48461538461538461,0.14128728414442698]
[null,"Delaware","San Diego",{"$f":"LOOKUP(C10,Cities,N4:N156)","v":30},{"$f":"LOOKUP(C10,Cities,Q4:Q156)","v":0.15137923301188605},null,null,"Delaware",null,null,"Phoenix","Atlanta","Georgia",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,"Energy Calculations",null,null,null,null,null,"Florida",null,"Arkansas","Blytheville","Augusta","Georgia",35,0.67307692307692313,0.60576923076923084,0.17660910518053377]
[null,"Burning hr. /yr.",5000,"Energy Rate $/kwWh",0.1,null,null,"Georgia",null,null,"Little Rock","Barstow","California",32,0.61538461538461542,0.55384615384615388,0.16147118187934514]
[null,null,"Existing","Proposed",null,null,null,"Idaho",null,null,"Fort Smith","Billings","Montana",18,0.34615384615384615,0.31153846153846154,9.0827539807131638E-2]
[null,"# fixtures",200,200,null,null,null,"Illinois",null,"California","Los Angeles","Biloxi","Mississippi",38,0.73076923076923073,0.65769230769230769,0.19174702848172234]
[null,"Watts per fixture",100,26,null,null,null,"Indiana",null,null,"San Diego","Birmingham","Alabama",33,0.63461538461538458,0.57115384615384612,0.16651715631307468]
[null,"kWh each year",{"$f":"C14*C15*$C$12/1000","v":100000},{"$f":"D14*D15*$C$12/1000","v":26000},null,null,null,"Iowa",null,null,"Santa Barbara","Bishop","California",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,"Annual Energy Cost",{"$f":"C16*$E$12","v":10000},{"$f":"D16*$E$12","v":2600},null,null,null,"Kansas",null,null,"Bishop","Bismarck","North_Dakota",18,0.34615384615384615,0.31153846153846154,9.0827539807131638E-2]
[null,"Savings Calculations",null,"kWh","Dollars",null,null,"Kentucky",null,null,"Barstow","Blytheville","Arkansas",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,"Energy Savings (lighting only)",null,{"$f":"C16-D16","v":74000},{"$f":"C17-D17","v":7400},null,null,"Louisana",null,null,"San Francisco","Boise","Idaho",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,"Energy Savings with A/C",null,{"$f":"D19*(1+E10)","v":85202.06324287958},{"$f":"E19*(1+E10)","v":8520.2063242879576},null,null,"Maine",null,null,"Sacramanto","Boston","Massachusetts",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,"Massachusetts",null,"Colorado","Denver","Buffalo","New_York",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,"Michigan",null,null,"Colorado Springs","Burlington","Vermont",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,"Minnesota",null,null,"Trinidad","Burns","Oregon",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,"Mississippi",null,null,"Grand Junction","Casper","Wyoming",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,"Missouri",null,"DC","Washington, DC","Champaign","Illinois",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,"Montana",null,"Delaware","Dover","Charleston, SC","South_Carolina",36,0.69230769230769229,0.62307692307692308,0.18165507961426328]
[null,"Mouseover Here","to understand how this A/C savings calculation is carried out",null,null,null,null,"Nebraska",null,null,"Wilmington, DE","Charleston, WV","West_Virginia",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,"Nevada",null,"Florida","Pensacola","Cheyenne","Wyoming",18,0.34615384615384615,0.31153846153846154,9.0827539807131638E-2]
[null,"Customer:","Perls Commerce Center",null,{"$f":"TODAY()","v":"2021-03-17"},null,null,"New_Hampshire",null,null,"Miami","Chicago","Illinois",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,"Prepared by: ",null,null,null,null,null,"New_Jersey",null,null,"Jacksonville","Cincinnati","Ohio",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,"New_Mexico",null,null,"Orlando","Clarksburg","West_Virginia",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,"New_York",null,null,"Tampa","Cleveland","Ohio",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,"North_Carolina",null,"Georgia","Atlanta","Clovis","New_Mexico",29,0.55769230769230771,0.50192307692307692,0.14633325857815652]
[null,null,null,null,null,null,null,"North_Dakota",null,null,"Augusta","Colorado Springs","Colorado",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,"Ohio",null,null,"Macon","Columbia, MO","Missouri",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,"Oklahoma",null,null,"Valdosta","Columbia, SC","South_Carolina",33,0.63461538461538458,0.57115384615384612,0.16651715631307468]
[null,null,null,null,null,null,null,"Oregon",null,null,"Savannah","Columbus, MS","Mississippi",34,0.65384615384615385,0.58846153846153848,0.17156313074680421]
[null,null,null,null,null,null,null,"Pennsylvania",null,"Idaho","Boise","Columbus, OH","Ohio",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,"Rhode_Island",null,null,"Pocatello","Corpus Christi","Texas",43,0.82692307692307687,0.74423076923076925,0.21697690065037004]
[null,null,null,null,null,null,null,"South_Carolina",null,null,"Lewiston","Council Bluffs","Iowa",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,"South_Dakota",null,"Illinois","Chicago","Covington","Kentucky",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,"Tennessee",null,null,"Champaign","Dallas","Texas",35,0.67307692307692313,0.60576923076923084,0.17660910518053377]
[null,null,null,null,null,null,null,"Texas",null,null,"Peoria","Dayton","Ohio",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,"Utah",null,null,"Rockford","Denver","Colorado",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,"Vermont",null,"Indiana","Fort Wayne","Detroit","Michigan",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,"Virginia",null,null,"South Bend","Dodge City","Kansas",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,"Washington",null,null,"Indianapolis","Dover","Delaware",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,"West_Virginia",null,null,"Terre Haute","Duluth","Minnesota",13,0.25,0.22500000000000001,6.5597667638483959E-2]
[null,null,null,null,null,null,null,"Wisconsin",null,"Iowa","Mason City","Ely","Nevada",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,"Wyoming",null,null,"Sioux City","Enid","Oklahoma",28,0.53846153846153844,0.48461538461538461,0.14128728414442698]
[null,null,null,null,null,null,null,null,null,null,"Council Bluffs","Eugene","Oregon",15,0.28846153846153844,0.25961538461538458,7.5689616505943025E-2]
[null,null,null,null,null,null,null,null,null,"Kansas","Dodge City","Fargo","North_Dakota",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,null,null,null,"Goodland","Flagstaff","Arizona",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,null,"Kansas City, KS","Fort Smith","Arkansas",31,0.59615384615384615,0.53653846153846152,0.15642520744561558]
[null,null,null,null,null,null,null,null,null,null,"Wichita","Fort Wayne","Indiana",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,null,null,"Kentucky","Louisville","Glasgow","Montana",18,0.34615384615384615,0.31153846153846154,9.0827539807131638E-2]
[null,null,null,null,null,null,null,null,null,null,"Covington","Goodland","Kansas",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,null,null,null,"Hopkinsville","Grand Forks","North_Dakota",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,null,null,"Louisana","New Orleans","Grand Island","Nebraska",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,null,null,null,"Alexandria","Grand Junction","Colorado",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,null,null,null,"Shreveport","Grand Rapids","Michigan",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,null,"Lake Charles","Great Falls","Montana",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,null,null,"Maine","Portland, ME","Green Bay","Wisconsin",18,0.34615384615384615,0.31153846153846154,9.0827539807131638E-2]
[null,null,null,null,null,null,null,null,null,"Massachusetts","Boston","Greensboro","North_Carolina",28,0.53846153846153844,0.48461538461538461,0.14128728414442698]
[null,null,null,null,null,null,null,null,null,null,"Springfield, MA","Helena","Montana",16,0.30769230769230771,0.27692307692307694,8.0735590939672572E-2]
[null,null,null,null,null,null,null,null,null,null,"Lansing","Hopkinsville","Kentucky",28,0.53846153846153844,0.48461538461538461,0.14128728414442698]
[null,null,null,null,null,null,null,null,null,"Michigan","Grand Rapids","Houston","Texas",42,0.80769230769230771,0.72692307692307701,0.2119309262166405]
[null,null,null,null,null,null,null,null,null,null,"Traverse City","Huntsville","Alabama",31,{"$f":"N68/52","v":0.59615384615384615},{"$f":"O68*0.9","v":0.53653846153846152},{"$f":"P68/$D$6","v":0.15642520744561558}]
[null,null,null,null,null,null,null,null,null,null,"Sault Sainte Marie","Huron","South_Dakota",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Detroit","Indianapolis","Indiana",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,null,null,"Minnesota","Duluth","International Falls","Minnesota",14,0.26923076923076922,0.24230769230769231,7.0643642072213492E-2]
[null,null,null,null,null,null,null,null,null,null,"International Falls","Jackson","Mississippi",35,0.67307692307692313,0.60576923076923084,0.17660910518053377]
[null,null,null,null,null,null,null,null,null,null,"Minneapolis","Jacksonville","Florida",42,0.80769230769230771,0.72692307692307701,0.2119309262166405]
[null,null,null,null,null,null,null,null,null,"Mississippi","Biloxi","Kansas City, KS","Kansas",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,null,null,null,"Jackson","Kansas City, MO","Missouri",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,null,null,null,"Columbus, MS","Knoxville","Tennessee",29,0.55769230769230771,0.50192307692307692,0.14633325857815652]
[null,null,null,null,null,null,null,null,null,"Missouri","Kansas City, MO","Lake Charles","Louisana",39,0.75,0.67500000000000004,0.1967930029154519]
[null,null,null,null,null,null,null,null,null,null,"Columbia, MO","Lansing","Michigan",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Springfield, MO","Las Vegas","Nevada",35,0.67307692307692313,0.60576923076923084,0.17660910518053377]
[null,null,null,null,null,null,null,null,null,null,"St. Louis","Lewiston","Idaho",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,"Montana","Billings","Little Rock","Arkansas",31,0.59615384615384615,0.53653846153846152,0.15642520744561558]
[null,null,null,null,null,null,null,null,null,null,"Glasgow","Los Angeles","California",33,0.63461538461538458,0.57115384615384612,0.16651715631307468]
[null,null,null,null,null,null,null,null,null,null,"Helena","Louisville","Kentucky",27,0.51923076923076927,0.46730769230769237,0.13624130971069748]
[null,null,null,null,null,null,null,null,null,null,"Great Falls","Lubbock","Texas",31,0.59615384615384615,0.53653846153846152,0.15642520744561558]
[null,null,null,null,null,null,null,null,null,"Nebraska","Omaha","Macon","Georgia",35,0.67307692307692313,0.60576923076923084,0.17660910518053377]
[null,null,null,null,null,null,null,null,null,null,"Grand Island","Madison","Wisconsin",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"North Platt","Manchester","New_Hampshire",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,"Nevada","Las Vegas","Mason City","Iowa",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Ely","Medford","Oregon",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,null,"Winnemucca","Memphis","Tennessee",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,null,null,null,null,null,null,null,null,null,"Reno","Miami","Florida",50,0.96153846153846156,0.86538461538461542,0.25229872168647677]
[null,null,null,null,null,null,null,null,null,"New_Hampshire","Manchester","Milwaukee","Wisconsin",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,"New_Jersey","Trenton","Minneapolis","Minnesota",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,"New_Mexico","Albuquerque","Minot","North_Dakota",16,0.30769230769230771,0.27692307692307694,8.0735590939672572E-2]
[null,null,null,null,null,null,null,null,null,null,"Alamogordo","Mobile","Alabama",38,0.73076923076923073,0.65769230769230769,0.19174702848172234]
[null,null,null,null,null,null,null,null,null,null,"Clovis","Montgomery","Alabama",35,0.67307692307692313,0.60576923076923084,0.17660910518053377]
[null,null,null,null,null,null,null,null,null,"New_York","Albany","Myrtle Beach","South_Carolina",32,0.61538461538461542,0.55384615384615388,0.16147118187934514]
[null,null,null,null,null,null,null,null,null,null,"Buffalo","Nashville","Tennessee",28,0.53846153846153844,0.48461538461538461,0.14128728414442698]
[null,null,null,null,null,null,null,null,null,null,"Syracuse","New Orleans","Louisana",40,0.76923076923076927,0.6923076923076924,0.20183897734918144]
[null,null,null,null,null,null,null,null,null,null,"New York City","New York City","New_York",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,"North_Carolina","Greensboro","North Platt","Nebraska",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,null,null,null,"Raleigh","Oklahoma City","Oklahoma",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,null,null,null,null,null,null,null,null,null,"Wilmington, NC","Omaha","Nebraska",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,null,null,"North_Dakota","Bismarck","Orlando","Florida",46,0.88461538461538458,0.7961538461538461,0.23211482395155861]
[null,null,null,null,null,null,null,null,null,null,"Grand Forks","Pendleton","Oregon",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Minot","Pensacola","Florida",38,0.73076923076923073,0.65769230769230769,0.19174702848172234]
[null,null,null,null,null,null,null,null,null,null,"Fargo","Peoria","Illinois",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,null,null,"Ohio","Cleveland","Philadelphia","Pennsylvania",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,null,null,null,"Dayton","Phoenix","Arizona",41,0.78846153846153844,0.70961538461538465,0.20688495178291097]
[null,null,null,null,null,null,null,null,null,null,"Columbus, OH","Pittsburgh","Pennsylvania",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,null,null,null,"Toledo","Pocatello","Idaho",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,null,"Cincinnati","Portland, ME","Maine",16,0.30769230769230771,0.27692307692307694,8.0735590939672572E-2]
[null,null,null,null,null,null,null,null,null,"Oklahoma","Altus","Portland, OR","Oregon",16,0.30769230769230771,0.27692307692307694,8.0735590939672572E-2]
[null,null,null,null,null,null,null,null,null,null,"Oklahoma City","Providence","Rhode_Island",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,null,"Tulsa","Raleigh","North_Carolina",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,null,null,null,null,null,null,null,null,null,"Enid","Rapid City","South_Dakota",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,"Oregon","Burns","Reno","Nevada",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,null,null,null,"Medford","Richmond","Virginia",27,0.51923076923076927,0.46730769230769237,0.13624130971069748]
[null,null,null,null,null,null,null,null,null,null,"Pendleton","Roanoke","Virginia",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,null,null,null,"Portland, OR","Rock Springs","Wyoming",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,null,null,null,"Eugene","Rockford","Illinois",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,"Pennsylvania","Pittsburgh","Sacramanto","California",28,0.53846153846153844,0.48461538461538461,0.14128728414442698]
[null,null,null,null,null,null,null,null,null,null,"Scranton","Salt Lake City","Utah",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Williamsport","San Antonio","Texas",41,0.78846153846153844,0.70961538461538465,0.20688495178291097]
[null,null,null,null,null,null,null,null,null,null,"Philadelphia","San Diego","California",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,null,null,null,null,null,null,null,null,"Rhode_Island","Providence","San Francisco","California",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,null,null,"South_Carolina","Charleston, SC","Santa Barbara","California",32,0.61538461538461542,0.55384615384615388,0.16147118187934514]
[null,null,null,null,null,null,null,null,null,null,"Columbia, SC","Sault Sainte Marie","Michigan",13,0.25,0.22500000000000001,6.5597667638483959E-2]
[null,null,null,null,null,null,null,null,null,null,"Myrtle Beach","Savannah","Georgia",38,0.73076923076923073,0.65769230769230769,0.19174702848172234]
[null,null,null,null,null,null,null,null,null,"South_Dakota","Rapid City","Scranton","Pennsylvania",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Huron","Seattle","Washington",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,null,"Sioux Falls","Shreveport","Louisana",35,{"$f":"N132/52","v":0.67307692307692313},{"$f":"O132*0.9","v":0.60576923076923084},{"$f":"P132/$D$6","v":0.17660910518053377}]
[null,null,null,null,null,null,null,null,null,"Tennessee","Memphis","Sioux City","Iowa",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,null,null,null,"Nashville","Sioux Falls","South_Dakota",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,null,"Knoxville","South Bend","Indiana",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,"Texas","Amarillo","Spokane","Washington",16,0.30769230769230771,0.27692307692307694,8.0735590939672572E-2]
[null,null,null,null,null,null,null,null,null,null,"Lubbock","Springfield, MA","Massachusetts",20,0.38461538461538464,0.3461538461538462,0.10091948867459072]
[null,null,null,null,null,null,null,null,null,null,"Dallas","Springfield, MO","Missouri",27,0.51923076923076927,0.46730769230769237,0.13624130971069748]
[null,null,null,null,null,null,null,null,null,null,"San Antonio","St. Louis","Missouri",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,null,null,null,"Corpus Christi","Syracuse","New_York",19,0.36538461538461536,0.32884615384615384,9.5873514240861171E-2]
[null,null,null,null,null,null,null,null,null,null,"Houston","Tampa","Florida",46,0.88461538461538458,0.7961538461538461,0.23211482395155861]
[null,null,null,null,null,null,null,null,null,"Utah","Salt Lake City","Terre Haute","Indiana",25,0.48076923076923078,0.43269230769230771,0.12614936084323838]
[null,null,null,null,null,null,null,null,null,null,"Wendover","Toledo","Ohio",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,"Vermont","Burlington","Traverse City","Michigan",17,0.32692307692307693,0.29423076923076924,8.5781565373402105E-2]
[null,null,null,null,null,null,null,null,null,"Virginia","Richmond","Trenton","New_Jersey",23,0.44230769230769229,0.39807692307692305,0.1160574119757793]
[null,null,null,null,null,null,null,null,null,null,"Roanoke","Trinidad","Colorado",25,0.48076923076923078,0.43269230769230771,0.12614936084323838]
[null,null,null,null,null,null,null,null,null,"Washington","Seattle","Tulsa","Oklahoma",30,0.57692307692307687,0.51923076923076916,0.15137923301188605]
[null,null,null,null,null,null,null,null,null,null,"Spokane","Tuscon","Arizona",40,0.76923076923076927,0.6923076923076924,0.20183897734918144]
[null,null,null,null,null,null,null,null,null,"West_Virginia","Charleston, WV","Valdosta","Georgia",39,0.75,0.67500000000000004,0.1967930029154519]
[null,null,null,null,null,null,null,null,null,null,"Clarksburg","Washington, DC","DC",26,0.5,0.45,0.13119533527696792]
[null,null,null,null,null,null,null,null,null,"Wisconsin","Madison","Wendover","Utah",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[null,null,null,null,null,null,null,null,null,null,"Green Bay","Wichita","Kansas",27,0.51923076923076927,0.46730769230769237,0.13624130971069748]
[null,null,null,null,null,null,null,null,null,null,"Milwaukee","Williamsport","Pennsylvania",21,0.40384615384615385,0.3634615384615385,0.10596546310832025]
[null,null,null,null,null,null,null,null,null,"Wyoming","Casper","Wilmington, DE","Delaware",24,0.46153846153846156,0.41538461538461541,0.12110338640950886]
[null,null,null,null,null,null,null,null,null,null,"Cheyenne","Wilmington, NC","North_Carolina",34,0.65384615384615385,0.58846153846153848,0.17156313074680421]
[null,null,null,null,null,null,null,null,null,null,"Rock Springs","Winnemucca","Nevada",22,0.42307692307692307,0.38076923076923075,0.11101143754204977]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N4:N156)","v":3955}]

{"sheet":"Cost_Breakdown","index":26,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,1,2,5],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[18,1,18,4],[7,1,7,4],[8,1,8,5],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[30,1,30,4],[19,1,19,4],[20,1,20,4],[21,1,21,5],[22,1,22,4],[23,1,23,4],[24,1,24,4],[37,1,37,4],[39,1,39,4],[41,1,41,3],[41,5,41,7],[1,2,1,6],[31,1,31,4],[32,1,32,4],[33,1,33,4],[34,1,34,5],[35,1,35,4],[36,1,36,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4]]}
[]
[null,null,"Lighting Cost\nBreakdown"]
[null,"Energy Costs"]
[null,"No. of fixtures",null,null,null,113]
[null,"Energy per fixture (watts)",null,null,null,460,null,"Energy"]
[null,"Energy rate per kWh",null,null,null,0.11,null,"Costs"]
[null,"Burning hours per year",null,null,null,5000]
[null,"Annual energy cost per year",null,null,null,{"$f":"F5*F4*F6*F7/1000","v":28589}]
[null,"Lamp Costs"]
[null,"No. of Lamps",null,null,null,113]
[null,"Lamp life",null,null,null,20000]
[null,"Burning hours per year",null,null,null,5000]
[null,"Fraction of lamps replaced every year",null,null,null,{"$f":"F12/F11","v":0.25}]
[null,"No. of lamps replaced each year",null,null,null,{"$f":"F13*F10","v":28.25}]
[null,"Cost per lamp",null,null,null,25]
[null,"Labor to replace 1 lamp",null,null,null,40]
[null,"Disposal cost per lamp",null,null,null,1,null,"Lamp"]
[null,"Annual lamp replacement (material)",null,null,null,{"$f":"F14*F15","v":706.25},null,"Replacement"]
[null,"Annual lamp replacement (labor)",null,null,null,{"$f":"F14*F16","v":1130},null,"Costs"]
[null,"Annual lamp disposal",null,null,null,{"$f":"F14*F17","v":28.25}]
[null,"Annualized lamp maintenance cost",null,null,null,{"$f":"F18+F19+F20","v":1864.5}]
[null,"Ballast Costs"]
[null,"No. of ballasts",null,null,null,113]
[null,"Ballast  life (use 84,000 for magnetic, 60,000 electronic)",null,null,null,84000]
[null,"Burning hours per year",null,null,null,5000]
[null,"Fraction of ballasts replaced every year",null,null,null,{"$f":"F25/F24","v":5.9523809523809521E-2}]
[null,"No. of ballasts replaced each year",null,null,null,{"$f":"F26*F23","v":6.7261904761904754}]
[null,"Cost per ballast",null,null,null,65]
[null,"Labor to replace 1 ballast",null,null,null,50]
[null,"Disposal cost per ballast",null,null,null,2]
[null,"Annual ballast replacement (material)",null,null,null,{"$f":"F27*F28","v":437.20238095238091},null,"Ballast"]
[null,"Annual ballast replacement (labor)",null,null,null,{"$f":"F27*F29","v":336.3095238095238},null,"Replacement"]
[null,"Annual ballast disposal",null,null,null,{"$f":"F27*F30","v":13.452380952380951},null,"Costs"]
[null,"Annualized ballast maintenance cost",null,null,null,{"$f":"F31+F32+F33","v":786.96428571428567}]
[null,"Facility Disruption Costs"]
[null,"Total number of events (lamp or ballast failures)",null,null,null,{"$f":"F14+F27","v":34.976190476190474},null,"Facility"]
[null,"Disruption cost per event",null,null,null,25,null,"Disruption"]
[null,"Annual disruption cost to facility",null,null,null,{"$f":"F36*F$37","v":874.40476190476181},null,"Costs"]
[]
[null,"Total energy and maintenance costs",null,null,null,{"$f":"F38+F34+F21+F8","v":32114.869047619046}]
[]
[null,"Breakdown 1",null,null,null,"Breakdown 2"]
[null,"Lamps",{"$f":"F21","v":1864.5},{"$f":"C43/C$48","v":5.8057219452938472E-2},null,"Materials",{"$f":"F18+F31","v":1143.452380952381},{"$f":"G43/G$48","v":3.5605076865077703E-2}]
[null,"Ballasts",{"$f":"F34","v":786.96428571428567},{"$f":"C44/C$48","v":2.4504670548318185E-2},null,"Labor",{"$f":"F19+F32","v":1466.3095238095239},4.5658275038746705E-2]
[null,"Disruption",{"$f":"F38","v":874.40476190476181},2.7227411720353537E-2,null,"Disposal",{"$f":"F20+F33","v":41.702380952380949},1.2985380974322456E-3]
[null,"Energy",{"$f":"F8","v":28589},0.89021069827838983,null,"Disruption",{"$f":"F38","v":874.40476190476181},2.7227411720353537E-2]
[null,null,null,null,null,"Energy",{"$f":"F8","v":28589},0.89021069827838983]
[null,"TOTAL",{"$f":"SUM(C43:C46)","v":32114.869047619046},1,null,"TOTAL",{"$f":"SUM(G43:G47)","v":32114.869047619046},1]

{"sheet":"Cost_of_Ownership","index":27,"n_rows":26,"n_cols":16,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,2,0,5],[3,6,3,8],[3,10,3,12],[3,13,3,15]]}
[null,null,"Cash Outlay versus Time"]
[null,null,"Green cells require user input"]
[null,null,"Energy rate per kWh",0.1,"Burning hr. per yr.",4000]
[null,null,null,"LED System 1","LED System 2","LED System 3",null,null,null,null,"Initial Cost and Ongoing Energy Costs plus replacement costs",null,null,"Replacement Costs\n(assuming no rebates)"]
[null,null,"Description",null,null,null,null,null,null,"year","System 1","System 2","System 3","Sys 1","Sys 2","Sys 3"]
[null,null,"No. of fixtures",140,140,200,null,null,null,0,{"$f":"D12","v":15400},{"$f":"E12","v":18200},34000,{"$f":"IF($J6>D$14,IF(($J6-1)<=D$14,D$15,0),0)+IF($J6>2*D$14,IF(($J6-1)<=2*D$14,D$15,0),0)+IF($J6>3*D$14,IF(($J6-1)<=3*D$14,D$15,0),0)","v":0},{"$f":"IF($J6>E$14,IF(($J6-1)<=E$14,E$15,0),0)+IF($J6>2*E$14,IF(($J6-1)<=2*E$14,E$15,0),0)+IF($J6>3*E$14,IF(($J6-1)<=3*E$14,E$15,0),0)","v":0},0]
[null,null,"Fixture Watts",76,46,38,null,null,null,1,{"$f":"K6+D$18+N7","v":19656},{"$f":"L6+E$18+O7","v":20776},{"$f":"M6+F$18+P7","v":37040},{"$f":"IF($J7>D$14,IF(($J7-1)<=D$14,D$15,0),0)+IF($J7>2*D$14,IF(($J7-1)<=2*D$14,D$15,0),0)+IF($J7>3*D$14,IF(($J7-1)<=3*D$14,D$15,0),0)","v":0},0,0]
[null,null,"Fixture Cost",120,150,200,null,null,null,2,{"$f":"K7+D$18+N8","v":23912},23352,40080,0,0,0]
[null,null,"Labor to Install Fixture",50,50,50,null,null,null,3,28168,25928,43120,0,0,0]
[null,null,"Rebate (put in brackets or use - sign) per fixture",-60,-70,-80,null,null,null,4,32424,28504,46160,0,0,0]
[null,null,"Investment to Install each fixture",{"$f":"SUM(D8:D10)","v":110},{"$f":"SUM(E8:E10)","v":130},170,null,null,null,5,36680,31080,49200,0,0,0]
[null,null,"Investment to Install entire site (all fixtures)",{"$f":"D6*(D8+D9+D10)","v":15400},{"$f":"E6*(E8+E9+E10)","v":18200},{"$f":"F6*(F8+F9+F10)","v":34000},null,null,null,6,40936,33656,52240,0,0,0]
[null,null,"Fixture Life (Hours)",30000,35000,50000,null,null,null,7,45192,36232,55280,0,0,0]
[null,null,"Fixture Life (Years, based on burn hr.)",{"$f":"D13/$F$3","v":7.5},{"$f":"E13/$F$3","v":8.75},{"$f":"F13/$F$3","v":12.5},null,null,null,8,73248,38808,58320,23800,0,0]
[null,null,"Cost to replace fixtures at end of life (no rebate)",{"$f":"D12-D10*D6","v":23800},{"$f":"E12-E10*E6","v":28000},50000,null,null,null,9,77504,69384,61360,0,28000,0]
[null,null,"Annualized Fixture Investment (per fixture)",{"$f":"D11/D14","v":14.666666666666666},{"$f":"E11/E14","v":14.857142857142858},13.6,null,null,null,10,81760,71960,64400,0,0,0]
[null,null,"Annualized Fixture Investment (all fixtures)",{"$f":"D12/D14","v":2053.3333333333335},{"$f":"E12/E14","v":2080},2720,null,null,null,11,86016,74536,67440,0,0,0]
[null,null,"Annual Energy Cost",{"$f":"D6*D7*$F$3*$D$3/1000","v":4256},{"$f":"E6*E7*$F$3*$D$3/1000","v":2576},{"$f":"F6*F7*$F$3*$D$3/1000","v":3040},null,null,null,12,90272,77112,70480,0,0,0]
[null,null,"Total Annualized Cost (excluding A/C)",{"$f":"D17+D18","v":6309.3333333333339},{"$f":"E17+E18","v":4656},5760,null,null,null,13,94528,79688,123520,0,0,50000]
[null,null,null,null,null,null,null,null,null,14,98784,82264,126560,0,0,0]
[null,null,null,null,null,null,null,null,null,15,103040,84840,129600,0,0,0]
[null,null,null,null,null,null,null,null,null,16,131096,87416,132640,23800,0,0]
[null,null,null,null,null,null,null,null,null,17,135352,89992,135680,0,0,0]
[null,null,null,null,null,null,null,null,null,18,{"$f":"K23+D$18+N24","v":139608},120568,138720,0,28000,0]
[null,null,null,null,null,null,null,null,null,19,143864,123144,141760,0,0,0]
[null,null,null,null,null,null,null,null,null,20,148120,125720,144800,0,0,0]

{"sheet":"IES_file_generator","index":28,"n_rows":52,"n_cols":44,"rows_kept":52,"cut":false,"hidden":false,"merged":[[7,1,7,3],[7,4,9,4],[1,3,1,4],[1,5,1,6],[4,1,4,3],[5,1,5,3],[6,1,6,3]]}
[]
[null,null,null,"Candela Curve and\nIES File Generator",null,"\n"]
[]
[]
[null,"Lamp Description",null,null,"LED18D38OW3840/25","Watts",18]
[null,"Product Code",null,null,93171,"CBCP (Candelas)",6500]
[null,"Life (optional) hr.",null,null,25000,"Beam Angle",25]
[null,"Cone Diagram Information",null,null,"Click here when \ndata entry complete"]
[null,"Distance","fc at","Beam"]
[null,"(feet)","center","diameter (ft)"]
[null,1,{"$f":"$G$6/(B11^2)","v":6500},{"$f":"B11*2*TAN(RADIANS($G$7/2))","v":0.44338932528587977},"Cone Diagram"]
[null,2,1625,0.88677865057175953]
[null,3,722.22222222222217,1.3301679758576392]
[null,4,406.25,1.7735573011435191,{"$f":"G7","v":25}]
[null,5,260,2.2169466264293987,"deg."]
[null,6,180.55555555555554,2.6603359517152785]
[null,7,132.65306122448979,3.1037252770011583]
[null,8,101.5625,3.5471146022870381]
[null,9,80.246913580246911,3.9905039275729179]
[null,10,65,4.4338932528587973]
[null,15,28.888888888888889,6.6508398792881964]
[null,20,16.25,8.8677865057175946]
[null,30,7.2222222222222223,13.301679758576393]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[null,null,null,null,null,null,null,null,null,"Generic Curve\n20 degree beam","Curve","Angle",0,1,2,3,4,5,6,7,8,10,12,14,16,18,20,22,24,28,32,36,40,44,48,52,56,60,64,68,72,76,80,90]
[null,null,null,null,null,null,null,null,null,"20 deg.","beam","Candelas",10000.000174950419,9932.0457492655478,9728.1824722109377,9405.3989502078039,8929.7179704137125,8352.105352092316,7587.6180631375264,6857.1079870251724,6177.56373017647,4988.3612806912424,3969.0448954181893,3153.5917871997472,2508.0247431934804,1930.412124872084,1420.7539322355576,1047.0045909687717,741.20967538685579,401.43754696250477,250,220,190,140,90,60,30,19,12,9,6,3,0,0]
[]
[null,null,null,null,null,null,null,null,"Specific","Scaling",{"$f":"G7/20","v":1.25},"Angle",{"$f":"$K$29*M26","v":0},{"$f":"IF(N25>=$K$32,90,$K$29*N26)","v":1.25},{"$f":"IF(O25>=$K$32,90,$K$29*O26)","v":2.5},3.75,5,6.25,7.5,8.75,10,12.5,15,17.5,20,22.5,25,27.5,30,35,40,45,50,55,60,65,70,75,80,85,90,90,90,90]
[null,null,null,null,null,null,null,null,"Curve",null,{"$f":"G6/10000","v":0.65},"Candelas",{"$f":"$K$30*M27","v":6500.0001137177724},{"$f":"$K$30*N27","v":6455.8297370226064},6323.3186069371095,6113.5093176350729,5804.3166807689131,5428.8684788600058,4931.9517410393919,4457.1201915663623,4015.4164246147056,3242.4348324493076,2579.879182021823,2049.8346616798358,1630.2160830757623,1254.7678811668545,923.49005595311246,680.5529841297016,481.78628900145628,260.93440552562811,162.5,143,123.5,91,58.5,39,19.5,12.35,7.8000000000000007,5.8500000000000005,3.9000000000000004,1.9500000000000002,0,0]
[null,null,null,null,null,null,null,null,null,null,"Rounded","Candelas",{"$f":"ROUND(M30,0)","v":6500},{"$f":"ROUND(N30,0)","v":6456},6323,6114,5804,5429,4932,4457,4015,3242,2580,2050,1630,1255,923,681,482,261,163,143,124,91,59,39,20,12,8,6,4,2,0,0]
[null,null,null,null,null,null,null,null,"Datapoints",null,{"$f":"VLOOKUP(G7,J35:K52,2,TRUE)","v":29}]
[null,null,null,null,null,null,null,null,null,"Beam","Data"]
[null,null,null,null,null,null,null,null,null,"angle","points"]
[null,null,null,null,null,null,null,null,null,1,32]
[null,null,null,null,null,null,null,null,20,20.100000000000001,31]
[null,null,null,null,null,null,null,null,null,22.5,30]
[null,null,null,null,null,null,null,null,null,23.7,29]
[null,null,null,null,null,null,null,null,25,25.1,28]
[null,null,null,null,null,null,null,null,null,26.5,27]
[null,null,null,null,null,null,null,null,null,28.2,26]
[null,null,null,null,null,null,null,null,30,30.1,25]
[null,null,null,null,null,null,null,null,32,32.1,24]
[null,null,null,null,null,null,null,null,null,34.700000000000003,23]
[null,null,null,null,null,null,null,null,null,37.6,22]
[null,null,null,null,null,null,null,null,41,41,21]
[null,null,null,null,null,null,null,null,45,45.1,20]
[null,null,null,null,null,null,null,null,50,50.1,19]
[null,null,null,null,null,null,null,null,null,56.3,18]
[null,null,null,null,null,null,null,null,null,64.3,17]
[null,null,null,null,null,null,null,null,75,75.099999999999994,16]
[null,null,null,null,null,null,null,null,null,90,15]

{"sheet":"Rebates","index":29,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Asset_Increase","index":30,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[23,1,23,2],[23,3,23,4],[1,1,1,4],[14,3,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,1,22,2],[22,3,22,4],[34,1,34,2],[24,1,24,2],[24,3,24,4],[25,1,25,2],[26,1,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,1,32,4],[33,1,33,2],[41,3,41,4],[35,1,35,4],[36,2,36,4],[37,3,37,4],[38,2,38,4],[39,3,39,4],[40,3,40,4]]}
[]
[null,"Asset Value Increase\nPayback including rental income"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Building A\nFluorescent","Building B\nLED"]
[null,"Area of Building (sq. ft.)",200000]
[null,"No of fixtures",2000]
[null,"Burn hours",4200]
[null,"Energy rate per kWh",0.11]
[null,"Type of fixture","Fluorescent","LED"]
[null,"Wattage of fixture",80,50]
[null,"Annual energy cost",{"$f":"C17*C21*C18*C19/1000","v":73920},{"$f":"C17*C18*C19*D21/1000","v":46200}]
[null,"Energy Savings",null,{"$f":"C22-D22","v":27720}]
[null,"Cost to upgrade per fixture",null,150]
[null,"Total Investment needed",null,{"$f":"C17*D24","v":300000}]
[null,"Simple Payback with energy only (years)",null,{"$f":"D25/D23","v":10.822510822510823},"years"]
[null,"Now let us include maintenance costs and rent increase benefits"]
[null,"Rent per sq. ft.",15,15]
[null,"Rent If fully occupied",{"$f":"C16*C28","v":3000000},{"$f":"C16*D28","v":3000000}]
[null,"Occupancy",0.84,0.88]
[null,"Rent with occupancy %",{"$f":"C29*C30","v":2520000},{"$f":"D29*D30","v":2640000}]
[null,"Increase in annual rent",null,{"$f":"D31-C31","v":120000}]
[null,"The numbers below might show that the real benefit of converting to LEDs \nis not merely energy or maintenance savings, but the building improvement \nleading to increase in rental income."]
[null,"Payback with energy + maintenance",null,{"$f":"D25/(D23+3000)","v":9.765625},"years"]
[null,"Payback with energy + maintenance + rent increase",null,{"$f":"D25/(D23+3000+D32)","v":1.9904458598726114},"years"]
[null,"Using a capitalization model and the numbers above, we can estimate the increase in asset value of the building from putting in the LED upgrade, or, alternately, the increase in effective CAP rate*. This calculation requires an estimate of net operating costs to arrive at net operating income.\n*CAP rate = net operating income/purchase price of building"]
[null,"Buiding purchase price",3000000]
[null,"Gross Income from rent",{"$f":"C31","v":2520000},{"$f":"D31","v":2640000}]
[null,"Building operating costs",2100000]
[null,"Net operating income",{"$f":"C38-C39","v":420000},{"$f":"D38-C39","v":540000}]
[null,"Effective increase in asset",null,{"$f":"(-1+D40/C40)*C37","v":857142.85714285739}]
[null,"Alternate: CAP rate increase",{"$f":"C40/C37","v":0.14000000000000001},{"$f":"D40/C37","v":0.18}]

{"sheet":"Disclaimer","index":31,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"\n"]