{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["NOTES","Directions for Use","INSTANTFIT 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":"INSTANTFIT 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":"32W 48\" T8"},null,null,null,null,null,"Payback Calc"]
[null,"Enter Fixture Quantity:",1,null,null,"Replacement Lamp (InstantFit)",{"$f":"B25","v":"453605 - 12T8/48-4000 IF - 4000K"},null,null,null,null,null,"Year",0,1,2,3,4,5]
[null,"Enter Lamps per Fixture:",1,null,null,{"$f":"\"Estimated Lighting Costs Using a \"&B16&\" Lamp\"","v":"Estimated Lighting Costs Using a 32W 48\" T8 Lamp"},null,null,null,null,null,null,"Cumulative Hours",0,{"$f":"$C$13*O9","v":8736},{"$f":"$C$13*P9","v":17472},26208,34944,43680]
[null,"Enter Operating Hours per Day:",24,null,null,"Existing System Wattage",{"$f":"(LEFT(B16,2)*C20 + LEFT(B16,2)*C20*'Pull-Down'!C3 )*C9*C10","v":29.849599999999999},null,null,null,null,null,"Fluorescent system Cost",{"$f":"G15","v":2.9},{"$f":"G14+G15","v":39.407254784000003},{"$f":"$G$14+O11","v":75.914509568},{"$f":"$G$14+P11","v":112.421764352},148.92901913599999,185.43627391999999]
[null,"Enter Operating Days per Week:",7,null,null,"x Annual Operating Hours",{"$f":"C13","v":8736}]
[null,"Total Annual Burn Hours\n(Auto Calculated)",{"$f":"(C11*C12)*52","v":8736},null,null,"kWh used",{"$f":"G11*G12/1000","v":260.7661056},null,null,null,null,null,"InstantFit System Cost",{"$f":"G23","v":12},{"$f":"G22+G23","v":29.734080000000002},{"$f":"$G$22+O13","v":47.468160000000005},{"$f":"$G$22+P13","v":65.202240000000003},82.936320000000009,100.67040000000001]
[null,null,null,null,null,{"$f":"\"Existing System Energy Cost @ $\"&C21&\"/kWh\"","v":"Existing System Energy Cost @ $0.14/kWh"},{"$f":"G13*C21","v":36.507254784000004},null,null,null,null,null,"Difference",{"$f":"N11-N13","v":-9.1},9.6731747840000004,28.446349567999995,47.219524351999993,65.992699135999985,84.765873919999976]
[null,"Select Lamp to Replace","Cost Per Lamp",null,null,{"$f":"\"Lamp Cost (\"&C9&\" Fixtures*\"&C10&\" Lamps) @ $\"&C18&\"/Lamp\"","v":"Lamp Cost (1 Fixtures*1 Lamps) @ $2.9/Lamp"},{"$f":"C18*C9*C10","v":2.9}]
[null,"32W 48\" T8",2.5,null,null,"Total Energy + Lamp Cost",{"$f":"SUM(G14:G15)","v":39.407254784000003}]
[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 453605 - 12T8/48-4000 IF - 4000K TLED"}]
[null,null,null,null,null,"InstantFit System Wattage (Watts)",{"$f":"IFERROR(VLOOKUP($B$25,'Pull-Down'!$F$5:$K$40,F27,FALSE)*C9*C10, 500)","v":14.5}]
[null,"Select Ballast Factor",0.88,null,null,"x Annual Operating Hours",{"$f":"G12","v":8736},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":0.48473420743707901}]
[null,"Select Energy Rate (per kWh)",0.14000000000000001,null,null,"kWh used",{"$f":"G19*G20/1000","v":126.672},null,null,null,null,null,"$ Spent befor payback",{"$f":"SLOPE(O11:S11,O9:S9)*N20+INTERCEPT(O11:S11,O9:S9)","v":20.596315213425754}]
[null,null,null,null,null,{"$f":"\"Existing System Energy Cost @ $\"&C21&\"/kWh\"","v":"Existing System Energy Cost @ $0.14/kWh"},{"$f":"G21*C21","v":17.734080000000002}]
[null,null,null,null,null,{"$f":"\"Lamp Cost (\"&C9&\" Fixtures*\"&C10&\" Lamps) @ $\"&C27&\"/Lamp\"","v":"Lamp Cost (1 Fixtures*1 Lamps) @ $12/Lamp"},{"$f":"C27*C9*C10","v":12}]
[null,"Select InstantFit TLED","Cost Per Lamp",null,null,"Total Energy + Lamp Cost",{"$f":"SUM(G22:G23)","v":29.734080000000002}]
[null,"453605 - 12T8/48-4000 IF - 4000K",12]
[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":12},null,null,{"$f":"IF(C20=0.77,3,IF(C20=0.88,4,IF(C20=1.18,5,6)))","v":4}]
[]
[null,null,null,null,null,"PAYBACK ",{"$f":"N20","v":0.48473420743707901},"Yrs"]
[null,null,null,null,null,"Energy saved per year*",{"$f":"G13-G21","v":134.09410560000001},"kWh"]
[null,null,null,null,null,"Energy Cost Saved per year*",{"$f":"G14-G22","v":18.773174784000002}]
[]
[]
[]
[]
[]
[null,"*For esitmation purposes only.  Your results may vary based on application and equipment (e.g. ballast) used."]

{"sheet":"Pull-Down","index":3,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":true,"merged":[[0,7,0,9],[0,1,0,4]]}
[null,"Linear Fluorescent System Watts",null,null,null,null,null,"TLED System Watts"]
["BF",0.77,0.88,1.18,1]
["Ballast Loss",0.06,0.06,0.06,0.06]
["Lamp to replace","Low Ballast Wattage","Normal Ballast Wattage","High Ballast Wattage",null,"Instant Start Lamps","Ballast Factor","Low Ballast Wattage (0.77)","Normal Ballast Wattage (0.88)","High Ballast Wattage (1.18)","Unity Ballast Factor Wattage (1.0)","Energy Rate"]
["32W 48\" T8",{"$f":"ROUND(LEFT($A5,2)*B$2+LEFT($A5,2)*B$2*B$3,1)","v":26.1},{"$f":"ROUND(LEFT($A5,2)*C$2+LEFT($A5,2)*C$2*C$3,1)","v":29.8},{"$f":"ROUND(LEFT($A5,2)*D$2+LEFT($A5,2)*D$2*D$3,1)","v":40},{"$f":"ROUND(LEFT($A5,2)*E$2+LEFT($A5,2)*E$2*E$3,1)","v":33.9},"453589 - 12T8/48-3000 IF - 3000K",0.77,12.5,14.5,18.5,null,0.04]
["28W 48\" T8",{"$f":"ROUND(LEFT($A6,2)*B$2+LEFT($A6,2)*B$2*B$3,1)","v":22.9},26.1,35,29.7,"453597 - 12T8/48-3500 IF - 3500K",0.88,12.5,14.5,18.5,null,0.05]
["25W 48\" T8",20.399999999999999,23.3,31.3,26.5,"453605 - 12T8/48-4000 IF - 4000K",1.18,12.5,14.5,18.5,null,0.06]
["17W 24\" T8",13.9,15.9,21.3,18,"453613 - 12T8/48-5000 IF - 5000K",1,12.5,14.5,18.5,null,7.0000000000000007E-2]
["25W 36\" T8",20.399999999999999,23.3,31.3,26.5,"456566 - 17T8/48-4000 IFG - 4000K",null,18,20,24,null,0.08]
["32W U-Bend",26.1,29.8,40,33.9,"456574 - 17T8/48-5000 IFG - 5000K",null,18,20,24,null,0.09]
["40W Long Compact",32.6,37.299999999999997,50,42.4,"456897 - 15T8/48-3000 IF DIM - 3000K",null,16,18,26.5,null,0.1]
["26W CFL",21.2,{"$f":"ROUND(LEFT($A12,2)*C$2+LEFT($A12,2)*C$2*C$3,1)","v":24.3},32.5,27.6,"456905 - 15T8/48-3500 IF DIM - 3500K",null,16,18,26.5,null,0.11]
[null,null,null,null,null,"456913 - 15T8/48-4000 IF DIM - 4000K",null,16,18,26.5,null,0.12]
[null,null,null,null,null,"456921 - 15T8/48-5000 IF DIM - 5000K",null,16,18,26.5,null,0.13]
[null,null,null,null,null,"463133 - 16.5T8 LED/48-3500 IF 10/1 UHO",null,18,20,27,null,0.14000000000000001]
[null,null,null,null,null,"463141 - 16.5T8 LED/48-4000 IF 10/1 UHO",null,18,20,27,null,0.15]
[null,null,null,null,null,"463158 - 16.5T8 LED/48-5000 IF 10/1 UHO",null,18,20,27,null,0.16]
[null,null,null,null,null,"452052 - 10.5T8/36-3000 IF - 3000K",null,12.5,13,17,null,0.17]
[null,null,null,null,null,"452060 - 10.5T8/36-3500 IF - 3500K",null,12.5,13,17,null,0.18]
[null,null,null,null,null,"452078 - 10.5T8/36-4000 IF - 4000K",null,12.5,13,17,null,0.19]
[null,null,null,null,null,"452086 - 10.5T8/36-5000 IF - 5000K",null,12.5,13,17,null,0.2]
[null,null,null,null,null,"452011 - 8.5T8/24-3000 IF - 3000K",null,10,10.5,14.5,null,0.21]
[null,null,null,null,null,"452029 - 8.5T8/24-3500 IF - 3500K",null,10,10.5,14.5,null,0.22]
[null,null,null,null,null,"452037 - 8.5T8/24-4000 IF - 4000K",null,10,10.5,14.5,null,0.23]
[null,null,null,null,null,"452045 - 8.5T8/24-5000 IF - 5000K",null,10,10.5,14.5,null,0.24]
[null,null,null,null,null,"452664 - 16.5T8/22.5-3000 IF-6U - 3000K",null,17.5,19,25.5,null,0.25]
[null,null,null,null,null,"452672 - 16.5T8/22.5-3500 IF-6U - 3500K",null,17.5,19,25.5,null,0.26]
[null,null,null,null,null,"452680 - 16.5T8/22.5-4000 IF-6U - 4000K",null,17.5,19,25.5,null,0.27]
[null,null,null,null,null,"452698 - 16.5T8/22.5-5000 IF-6U - 5000K",null,17.5,19,25.5,null,0.28000000000000003]
[null,null,null,null,null,"456632 - 16.5PL-LED/24-3000 IF - 3000K",null,17.5,19,25.5,null,0.28999999999999998]
[null,null,null,null,null,"456640 - 16.5PL-LED/24-3500 IF - 3500K",null,17.5,19,25.5,null,0.3]
[null,null,null,null,null,"456657 - 16.5PL-LED/24-4000 IF - 4000K",null,17.5,19,25.5,null,0.31]
[null,null,null,null,null,"458364 - 8.5PL-C/T LED/26H-2700 IF 4P",null,null,null,null,10.5,0.32]
[null,null,null,null,null,"458372 - 8.5PL-C/T LED/26H-3000 IF 4P",null,null,null,null,10.5,0.33]
[null,null,null,null,null,"458380 - 8.5PL-C/T LED/26H-3500 IF 4P",null,null,null,null,10.5,0.34]
[null,null,null,null,null,"458398 - 8.5PL-C/T LED/26H-4000 IF 4P",null,null,null,null,10.5,0.35]
[null,null,null,null,null,"458406 - 10.5PL-C/T LED/26V-2700 IF 4P",null,null,null,null,14.5,0.36]
[null,null,null,null,null,"458414 - 10.5PL-C/T LED/26V-3000 IF 4P",null,null,null,null,14.5,0.37]
[null,null,null,null,null,"458422 - 10.5PL-C/T LED/26V-3500 IF 4P",null,null,null,null,14.5,0.38]
[null,null,null,null,null,"458430 - 10.5PL-C/T LED/26V-4000 IF 4P",null,null,null,null,14.5,0.39]
[null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,0.41]
[null,null,null,null,null,null,null,null,null,null,null,0.42]
[null,null,null,null,null,null,null,null,null,null,null,0.43]
[null,null,null,null,null,null,null,null,null,null,null,0.44]
[null,null,null,null,null,null,null,null,null,null,null,0.45]
[null,null,null,null,null,null,null,null,null,null,null,0.46]
[null,null,null,null,null,null,null,null,null,null,null,0.47]
[null,null,null,null,null,null,null,null,null,null,null,0.48]
[null,null,null,null,null,null,null,null,null,null,null,0.49]
[null,null,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":5,"n_cols":4,"rows_kept":5,"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]
["2016-02-22","Updated product list to inlcude 2500 lm 4ft (3 SKUs), also updated ballast loss and ballast factor for 4-pin lamps (typically just 1)","Shane D.",4]