{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Directions for Use","TLED PAYBACK CALC","Pull-Down","TLED Info","Changes"],"not_rendered":{"charts":1,"images":5,"macros":1,"external_links":1,"defined_names":60,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

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

{"sheet":"Directions for Use","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[]
[null,"  Philips Energy Solutions Instant Energy and Environmental Impact Calculator for TLED"]

{"sheet":"TLED PAYBACK CALC","index":2,"n_rows":37,"n_cols":19,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,1,7,2],[2,6,2,9]]}
[null,null,null,null,null,null,"Calculations Prepared for:"]
[]
[null,null,null,null,null,null,"(enter customer name)"]
[]
[]
[]
[]
[null,"ENTER SYSTEM DATA BELOW",null,null,null,"Existing Lamp",{"$f":"B16","v":"25W 48\" T8"},null,null,null,null,null,"Payback Calc"]
[null,"Enter Fixture Quantity:",10,null,null,"Replacement Lamp (InstantFit)",{"$f":"B25","v":"453613 - 12T8/48-5000 IF - 5000K"},null,null,null,null,null,"Year",0,1,2,3,4,5]
[null,"Enter Lamps per Fixture:",2,null,null,{"$f":"\"Estimated Lighting Costs Using a \"&B16&\" Lamp\"","v":"Estimated Lighting Costs Using a 25W 48\" T8 Lamp"},null,null,null,null,null,null,"Cumulative Hours",0,{"$f":"$C$13*O9","v":4368},{"$f":"$C$13*P9","v":8736},13104,17472,21840]
[null,"Enter Operating Hours per Day:",12,null,null,"Existing System Wattage",{"$f":"LEFT(B16,2)*C20*C9*C10","v":440},null,null,null,null,null,"TL system Cost",{"$f":"G15","v":58},{"$f":"G14+G15","v":269.41120000000001},{"$f":"$G$14+O11","v":480.82240000000002},{"$f":"$G$14+P11","v":692.23360000000002},903.64480000000003,1115.056]
[null,"Enter Operating Days per Week:",7,null,null,"x Annual Operating Hours",{"$f":"C13","v":4368}]
[null,"Total Annual Burn Hours\n(Auto Calculated)",{"$f":"(C11*C12)*52","v":4368},null,null,"kWh used",{"$f":"G11*G12/1000","v":1921.92},null,null,null,null,null,"TLED System",{"$f":"G23","v":160},{"$f":"G22+G23","v":299.33920000000001},{"$f":"$G$22+O13","v":438.67840000000001},{"$f":"$G$22+P13","v":578.01760000000002},717.35680000000002,856.69600000000003]
[null,null,null,null,null,{"$f":"\"Existing System Energy Cost @ $\"&C21&\"/kWh\"","v":"Existing System Energy Cost @ $0.11/kWh"},{"$f":"G13*C21","v":211.41120000000001},null,null,null,null,null,"Difference",{"$f":"N11-N13","v":-102},-29.927999999999997,42.144000000000005,114.21600000000001,186.28800000000001,258.36]
[null,"Select Lamp to Replace","Cost Per Lamp",null,null,{"$f":"\"Lamp Cost (\"&C9&\" Fixtures*\"&C10&\" Lamps) @ $\"&C18&\"/Lamp\"","v":"Lamp Cost (10 Fixtures*2 Lamps) @ $2.9/Lamp"},{"$f":"C18*C9*C10","v":58}]
[null,"25W 48\" T8",2.5,null,null,"Total Energy + Lamp Cost",{"$f":"SUM(G14:G15)","v":269.41120000000001}]
[null,"Fluorsecent Lamp Disposal Cost",0.4]
[null,"Final TL Lamp Cost",{"$f":"SUM(C16:C17)","v":2.9},null,null,{"$f":"\"Estimated Lighting Costs Using a Philips \"&B25&\" TLED\"","v":"Estimated Lighting Costs Using a Philips 453613 - 12T8/48-5000 IF - 5000K TLED"}]
[null,null,null,null,null,"InstantFit System Wattage (Watts)",{"$f":"IFERROR(VLOOKUP($B$25,'Pull-Down'!$E$3:$I$29,F27,FALSE)*C9*C10, 500)","v":290}]
[null,"Select Ballast Factor",0.88,null,null,"x Annual Operating Hours",{"$f":"G12","v":4368},null,null,null,null,null,"Years Payback",{"$f":"(INTERCEPT(O13:S13,O9:S9)-INTERCEPT(O11:S11,O9:S9))/(SLOPE(O11:S11,O9:S9)-SLOPE(O13:S13,O9:S9))","v":1.4152514152514153}]
[null,"Select Energy Rate (per kWh)",0.11,null,null,"kWh used",{"$f":"G19*G20/1000","v":1266.72},null,null,null,null,null,"$ Spent befor payback",{"$f":"SLOPE(O11:S11,O9:S9)*N20+INTERCEPT(O11:S11,O9:S9)","v":357.20000000000005}]
[null,null,null,null,null,{"$f":"\"Existing System Energy Cost @ $\"&C21&\"/kWh\"","v":"Existing System Energy Cost @ $0.11/kWh"},{"$f":"G21*C21","v":139.33920000000001}]
[null,null,null,null,null,{"$f":"\"Lamp Cost (\"&C9&\" Fixtures*\"&C10&\" Lamps) @ $\"&C27&\"/Lamp\"","v":"Lamp Cost (10 Fixtures*2 Lamps) @ $8/Lamp"},{"$f":"C27*C9*C10","v":160}]
[null,"Select InstantFit TLED","Cost Per Lamp",null,null,"Total Energy + Lamp Cost",{"$f":"SUM(G22:G23)","v":299.33920000000001}]
[null,"453613 - 12T8/48-5000 IF - 5000K",8]
[null,"Utility Rebate",0,null,null,{"$f":"IFERROR(MID(B16,5,2)*1,MID(B16,5,1))","v":48}]
[null,"Final End User InstantFit Lamp Cost",{"$f":"C25-C26","v":8},null,null,{"$f":"IF(C20=0.77,3,IF(C20=0.88,4,5))","v":4}]
[]
[null,null,null,null,null,"PAYBACK ",{"$f":"N20","v":1.4152514152514153},"Yrs"]
[null,null,null,null,null,"Energy saved per year*",{"$f":"G13-G21","v":655.20000000000005},"kWh"]
[null,null,null,null,null,"Energy Cost Saved per year*",{"$f":"G14-G22","v":72.072000000000003}]
[]
[]
[]
[]
[]
[null,"*For esitmation purposes only.  Your results may vary based on application and equipment used."]

{"sheet":"Pull-Down","index":3,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":true,"merged":[[0,6,0,8],[0,1,0,3]]}
[null,"Linear Fluorescent System Watts",null,null,null,null,"TLED System Watts"]
[null,0.77,0.88,1.18]
["Lamp to replace","Low Ballast Wattage","Normal Ballast Wattage","High Ballast Wattage","Instant Start Lamps","Ballast Factor","Low Ballast Wattage (0.77)","Normal Ballast Wattage (0.88)","High Ballast Wattage (1.18)","Energy Rate"]
["32W 48\" T8",{"$f":"ROUND(LEFT($A4,2)*B$2,1)","v":24.6},{"$f":"ROUND(LEFT($A4,2)*C$2,1)","v":28.2},37.799999999999997,"434860 - 16.5T8/48-3000 IF - 3000K",0.77,17.5,19,25.5,0.04]
["28W 48\" T8",{"$f":"ROUND(LEFT($A5,2)*B$2,1)","v":21.6},24.6,33,"434878 - 16.5T8/48-3500 IF - 3500K",0.88,17.5,19,25.5,0.05]
["25W 48\" T8",19.3,22,29.5,"434886 - 16.5T8/48-4000 IF - 4000K",1.18,17.5,19,25.5,0.06]
["17W 24\" T8",13.1,15,20.100000000000001,"434894 - 16.5T8/48-5000 IF - 5000K",null,17.5,19,25.5,7.0000000000000007E-2]
["25W 36\" T8",19.3,22,29.5,"453589 - 12T8/48-3000 IF - 3000K",null,12.5,14.5,18.5,0.08]
["32W U-Bend",24.6,28.2,37.799999999999997,"453597 - 12T8/48-3500 IF - 3500K",null,12.5,14.5,18.5,0.09]
["40W PL-L",30.8,35.200000000000003,47.2,"453605 - 12T8/48-4000 IF - 4000K",null,12.5,14.5,18.5,0.1]
[null,null,null,null,"453613 - 12T8/48-5000 IF - 5000K",null,12.5,14.5,18.5,0.11]
[null,null,null,null,"456566 - 17T8/48-4000 IFG - 4000K",null,18,20,24,0.12]
[null,null,null,null,"456574 - 17T8/48-5000 IFG - 5000K",null,18,20,24,0.13]
[null,null,null,null,"456897 - 15T8/48-3000 IF DIM - 3000K",null,16,17.5,22,0.14000000000000001]
[null,null,null,null,"456905 - 15T8/48-3500 IF DIM - 3500K",null,16,17.5,22,0.15]
[null,null,null,null,"456913 - 15T8/48-4000 IF DIM - 4000K",null,16,17.5,22,0.16]
[null,null,null,null,"456921 - 15T8/48-5000 IF DIM - 5000K",null,16,17.5,22,0.17]
[null,null,null,null,"452052 - 10.5T8/36-3000 IF - 3000K",null,12.5,13,17,0.18]
[null,null,null,null,"452060 - 10.5T8/36-3500 IF - 3500K",null,12.5,13,17,0.19]
[null,null,null,null,"452078 - 10.5T8/36-4000 IF - 4000K",null,12.5,13,17,0.2]
[null,null,null,null,"452086 - 10.5T8/36-5000 IF - 5000K",null,12.5,13,17,0.21]
[null,null,null,null,"452011 - 8.5T8/24-3000 IF - 3000K",null,10,10.5,14.5,0.22]
[null,null,null,null,"452029 - 8.5T8/24-3500 IF - 3500K",null,10,10.5,14.5,0.23]
[null,null,null,null,"452037 - 8.5T8/24-4000 IF - 4000K",null,10,10.5,14.5,0.24]
[null,null,null,null,"452045 - 8.5T8/24-5000 IF - 5000K",null,10,10.5,14.5,0.25]
[null,null,null,null,"452664 - 16.5T8/22.5-3000 IF-6U - 3000K",null,17.5,19,25.5,0.26]
[null,null,null,null,"452672 - 16.5T8/22.5-3500 IF-6U - 3500K",null,17.5,19,25.5,0.27]
[null,null,null,null,"452680 - 16.5T8/22.5-4000 IF-6U - 4000K",null,17.5,19,25.5,0.28000000000000003]
[null,null,null,null,"452698 - 16.5T8/22.5-5000 IF-6U - 5000K",null,17.5,19,25.5,0.28999999999999998]
[null,null,null,null,"456632 - 16.5PL-LED/24-3000 IF - 3000K",null,17.5,19,25.5,0.3]
[null,null,null,null,"456640 - 16.5PL-LED/24-3500 IF - 3500K",null,17.5,19,25.5,0.31]
[null,null,null,null,"456657 - 16.5PL-LED/24-4000 IF - 4000K",null,17.5,19,25.5,0.32]
[null,null,null,null,null,null,null,null,null,0.33]
[null,null,null,null,null,null,null,null,null,0.34]
[null,null,null,null,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,0.36]
[null,null,null,null,null,null,null,null,null,0.37]
[null,null,null,null,null,null,null,null,null,0.38]
[null,null,null,null,null,null,null,null,null,0.39]
[null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,0.41]
[null,null,null,null,null,null,null,null,null,0.42]
[null,null,null,null,null,null,null,null,null,0.43]
[null,null,null,null,null,null,null,null,null,0.44]
[null,null,null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,0.47]
[null,null,null,null,null,null,null,null,null,0.48]
[null,null,null,null,null,null,null,null,null,0.49]
[null,null,null,null,null,null,null,null,null,0.5]

{"sheet":"TLED Info","index":4,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
["Lamp Type","Technology","PROF\n6NC","Ordering Code","Ballast Factor","Adjust System Power (Watts)","Lamp Power (watts)","System Power (watts)","Volts","Base","Rated Avg Life (Hrs)","CRI","Color Temp (K)","MOL (in)","Lumens","DLC Approved",null,null,"Estimated Lighting Costs Using an Incandescent 65W BR30 Lamp"]
["TLED","InstantFit",434860,"16.5T8/48-3000 IF 10/1",0.77,17.5,14,17.5,"120-277, 347","G13",50000,82,3000,48,1600,null,null,null,"System Wattage",65,"Watts"]
["TLED","InstantFit",434878,"16.5T8/48-3500 IF 10/1",0.77,17.5,14,17.5,"120-277, 347","G13",50000,82,3500,48,1600,null,null,null,"x Annual Operating Hours",3000,"Hours"]
["TLED","InstantFit",434886,"16.5T8/48-4000 IF 10/1",0.77,17.5,14,17.5,"120-277, 347","G13",50000,82,4000,48,1600,null,null,null,null,{"$f":"T3*T2","v":195000},"Watt-hours"]
["TLED","InstantFit",434894,"16.5T8/48-5000 IF 10/1",0.77,17.5,14,17.5,"120-277, 347","G13",50000,82,5000,48,1600,null,null,null,"Energy Used (kWh)",{"$f":"T4/1000","v":195},"kWh"]
["TLED","InstantFit",434860,"16.5T8/48-3000 IF 10/1",0.88,19,16.5,19,"120-277, 347","G13",50000,82,3000,48,1600,null,null,null,"x kWh Rate of $0.11",{"$f":"T5*0.11","v":21.45},"per year"]
["TLED","InstantFit",434878,"16.5T8/48-3500 IF 10/1",0.88,19,16.5,19,"120-277, 347","G13",50000,82,3500,48,1600,null,null,null,"x 100 lamps per space",{"$f":"T6*100","v":2145},"annual energy cost per space"]
["TLED","InstantFit",434886,"16.5T8/48-4000 IF 10/1",0.88,19,16.5,19,"120-277, 347","G13",50000,82,4000,48,1600]
["TLED","InstantFit",434894,"16.5T8/48-5000 IF 10/1",0.88,19,16.5,19,"120-277, 347","G13",50000,82,5000,48,1600,null,null,null,"Estimated Lighting Costs Using a Philips 10.5W LED BR30 Lamp"]
["TLED","InstantFit",434860,"16.5T8/48-3000 IF 10/1",1.18,25.5,21,25.5,"120-277, 347","G13",50000,82,3000,48,1600,null,null,null,"Present Wattage",10.5,"Watts"]
["TLED","InstantFit",434878,"16.5T8/48-3500 IF 10/1",1.18,25.5,21,25.5,"120-277, 347","G13",50000,82,3500,48,1600,null,null,null,"x Annual Operating Hours",{"$f":"T3","v":3000},"Hours"]
["TLED","InstantFit",434886,"16.5T8/48-4000 IF 10/1",1.18,25.5,21,25.5,"120-277, 347","G13",50000,82,4000,48,1600,null,null,null,null,{"$f":"T11*T10","v":31500},"Watt-hours"]
["TLED","InstantFit",434894,"16.5T8/48-5000 IF 10/1",1.18,25.5,21,25.5,"120-277, 347","G13",50000,82,5000,48,1600,null,null,null,"/1000",{"$f":"T12/1000","v":31.5},"kWh"]
["TLED","InstantFit",453589,"12T8/48-3000 IF 10/1",0.77,12.5,10.5,12.5,"120-277, 347","G13",50000,82,3000,48,1600]
["TLED","InstantFit",453597,"12T8/48-3500 IF 10/1",0.77,12.5,10.5,12.5,"120-277, 347","G13",50000,82,3500,48,1600]
["TLED","InstantFit",453605,"12T8/48-4000 IF 10/1",0.77,12.5,10.5,12.5,"120-277, 347","G13",50000,82,4000,48,1600]
["TLED","InstantFit",453613,"12T8/48-5000 IF 10/1",0.77,12.5,10.5,12.5,"120-277, 347","G13",50000,82,5000,48,1600]
["TLED","InstantFit",453589,"12T8/48-3000 IF 10/1",0.88,14.5,12,14.5,"120-277, 347","G13",50000,82,3000,48,1600]
["TLED","InstantFit",453597,"12T8/48-3500 IF 10/1",0.88,14.5,12,14.5,"120-277, 347","G13",50000,82,3500,48,1600]
["TLED","InstantFit",453605,"12T8/48-4000 IF 10/1",0.88,14.5,12,14.5,"120-277, 347","G13",50000,82,4000,48,1600]
["TLED","InstantFit",453613,"12T8/48-5000 IF 10/1",0.88,14.5,12,14.5,"120-277, 347","G13",50000,82,5000,48,1600]
["TLED","InstantFit",453589,"12T8/48-3000 IF 10/1",1.18,18.5,14.5,18.5,"120-277, 347","G13",50000,82,3000,48,1600]
["TLED","InstantFit",453597,"12T8/48-3500 IF 10/1",1.18,18.5,14.5,18.5,"120-277, 347","G13",50000,82,3500,48,1600]
["TLED","InstantFit",453605,"12T8/48-4000 IF 10/1",1.18,18.5,14.5,18.5,"120-277, 347","G13",50000,82,4000,48,1600]
["TLED","InstantFit",453613,"12T8/48-5000 IF 10/1",1.18,18.5,14.5,18.5,"120-277, 347","G13",50000,82,5000,48,1600]
["TLED","InstantFit"]
["TLED","InstantFit"]
["TLED","InstantFit"]
["TLED","InstantFit"]
["TLED","InstantFit"]
["TL","TL","25W T8 Instant Start",null,0.77,{"$f":"E31*G31","v":19.25},25,null,null,null,null,null,null,null,null,null,null,null,"x kWh Rate of $0.11",{"$f":"T13*0.11","v":3.4649999999999999},"per year"]
["TL","TL","28W T8 Instant Start",null,0.77,{"$f":"E32*G32","v":21.560000000000002},28,null,null,null,null,null,null,null,null,null,null,null,"x 100 lamps per space",{"$f":"T31*100","v":346.5},"annual energy cost per space"]
["TL","TL","32W T8 Instant Start",null,0.77,24.64,32]
["TL","TL","25W T8 Instant Start",null,0.88,22,25,null,null,null,null,null,null,null,null,null,null,null,"Total Estimated Annual Savings",{"$f":"T7-T32","v":1798.5}]
["TL","TL","28W T8 Instant Start",null,0.88,24.64,28]
["TL","TL","32W T8 Instant Start",null,0.88,28.16,32]
["TL","TL","25W T8 Instant Start",null,1.18,29.5,25]
["TL","TL","28W T8 Instant Start",null,1.18,33.04,28]
["TL","TL","32W T8 Instant Start",null,1.18,37.76,32]
[]
[]
[]
["Payback"]

{"sheet":"Changes","index":5,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Date","Description","Owner","Version"]
["2014-06-18","No change to ballast factor multiplier per email between Bo/Shane\nAdded U-bend, 2', 3', 4' (2100 lm) TLED options\nAdded 2', 3' & U-bend TL options\nLimited TLED selection based on TL Lamp selected\nAuto clear the rebate whenever a new TL Lamp is selected","Brian V",1.1000000000000001]
["2015-03-20","Updated product list.  Replaced 14.5W products with 12W products","Brian V",2.1]
["2015-03-20","Updated product list to include PLL (3 SKUs), Dimmable (4 SKUs), Glass (2 SKUs)","Brian V",3]