{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["DCKV-Tool","Calcs","Weather Data","EFLH Lookup","HELP","Application","Application NEW","Lookups","Tariffs and Rates","Change Log"],"not_rendered":{"charts":2,"images":18,"macros":1,"external_links":0,"defined_names":158,"comments":1,"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":"DCKV-Tool","index":0,"n_rows":42,"n_cols":76,"rows_kept":42,"cut":false,"hidden":false,"merged":[[27,2,29,6],[31,17,31,20],[30,2,32,6],[31,21,31,23],[20,2,20,4],[20,5,20,11],[20,13,20,14],[25,2,25,4],[20,15,20,23],[21,2,21,4],[21,5,21,6],[21,7,21,9],[21,10,21,11],[21,13,21,14],[21,15,21,19],[21,20,21,21],[21,22,21,23],[17,20,17,23],[18,2,18,4],[18,13,18,14],[18,15,18,23],[19,2,19,5],[19,6,19,11],[19,13,19,14],[19,15,19,19],[19,20,19,23],[17,2,17,4],[17,5,17,11],[17,13,17,19],[14,7,14,8],[14,9,14,11],[15,2,15,4],[15,5,15,6],[15,7,15,11],[16,13,16,19],[11,2,11,6],[11,13,15,23],[12,2,12,4],[12,5,12,11],[13,2,13,4],[13,5,13,11],[14,2,14,4],[16,2,16,4],[16,5,16,6],[16,7,16,11],[2,2,3,11],[4,2,4,4],[4,7,4,8],[4,9,4,11],[5,7,5,8],[5,9,5,11],[5,20,5,21],[6,2,6,6],[6,7,6,8],[6,9,6,11],[6,16,6,22],[7,2,7,4],[7,5,7,8],[7,9,7,11],[7,13,7,14],[7,17,7,22],[8,2,8,4],[8,5,8,11],[8,13,8,14],[26,5,26,6],[26,2,26,4],[25,8,25,13],[26,8,26,13],[25,14,25,15],[26,14,26,15],[8,17,8,22],[9,2,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,11],[9,13,9,14],[10,2,10,4],[10,5,10,11],[10,17,10,22],[14,5,14,6],[34,5,34,6],[34,2,34,4],[34,8,34,13],[34,14,34,15],[28,17,29,20],[28,21,29,23],[25,17,26,20],[25,21,26,23],[23,2,24,6],[23,8,24,15],[23,17,24,23],[25,5,25,6],[28,8,28,13],[29,8,29,13],[30,8,30,13],[28,14,28,15],[30,14,30,15],[29,14,29,15],[31,8,31,13],[31,14,31,15],[34,17,34,20],[33,21,33,23],[34,21,34,23],[33,17,33,20]]}
[]
[]
[null,null,"DCKV Calculator Tool"]
[]
[null,null,{"$f":"\"Version: \" & INDEX(CurrentVersion_List,MATCH(\"a\",CurrentVersionSelected_List,0))","v":"Version: 030117.1"},null,null,null,null,"Application Date"]
[null,null,null,null,null,null,null,"Invoice/Install Date",null,"2025-04-21",null,null,null,null,{"$f":"TODAY()","v":"2025-05-05"}]
[null,null,"Project Information",null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions"]
[null,null,"Project Name/Type",null,null,null,null,null,null,null,null,null,null,null,null,"User Input Fields",null,"1 - Complete all yellow fields",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,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,"Installation Address",null,null,null,null,null,null,null,null,null,null,null,null,"Completed Fields",null,"2 - Save a copy of this HVAC tool",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,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"City/State/Zip",null,null,null,null,null,null,null,null,null,null,null,null,"Calculated Fields",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,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,"Contractor/Dealer Name",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - Follow the instructions on the incentive application"]
[null,null,"Participant Information",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(InstallState=\"\",InstallDate=\"\"),\"\",IF(OR(InstallState=\"\",InstallDate=\"\"),\"Please enter an install date and select a state in the Project Information section.\",\"Calculator results are in accordance with \" & INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0)) &\" Tariff \" & VLOOKUP(InstallState,ApplicableTariff,3) & \", effective \"& VLOOKUP(InstallState,ApplicableTariff,2) & \", and are estimates only. Actual energy savings and incentives paid will be determined based on the results of a post-installation inspection and review of project invoices.\"&\" Calculator results are valid only for equipment purchased and installed on or after the effective tariff date.\"))","v":"Please enter an install date and select a state in the Project Information section."}]
[null,null,"Business Name"]
[null,null,"Address"]
[null,null,"City/State/Zip"]
[null,null,"Contact Person/Title"]
[null,null,"Phone/Email",null,null,null,null,null,null,null,null,null,null,"Incentive Payee Information"]
[null,null,"Business Type",null,null,null,null,null,null,null,null,null,null,"Select where the incentive will be paid in the drop down selector >>"]
[null,null,"Participant is >>",null,null,null,null,null,null,null,null,null,null,"Business Name"]
[null,null,"Account Information",null,null,null,{"$f":"IF(OR(InstallState=\"\",RateSchedule=\"\"),\"\",\"Rate Schedule \" & RateSchedule & \" effective \" & TEXT(INDEX('Tariffs and Rates'!I10:I14,MATCH(InstallState,'Tariffs and Rates'!H10:H14,0)),\"mm/dd/yyyy\"))","v":""},null,null,null,null,null,null,"Contact Name/Phone"]
[null,null,"Account Name",null,null,null,null,null,null,null,null,null,null,"Address"]
[null,null,"Account/Meter/Rate",null,null,null,null,null,null,null,null,null,null,"City/State/Zip"]
[]
[null,null,"Facility Information",null,null,null,null,null,"Equipment Information",null,null,null,null,null,null,null,null,"Savings & Incentives Calculations"]
[]
[null,null,"Facility Type",null,null,null,null,null,"Total hp of make-up air fan motors",null,null,null,null,null,null,null,null,"Energy Savings (Annual)",null,null,null,{"$f":"IF(AND(kWhSavings>0,kWhSavings<>\"\"),kWhSavings,\"Missing Inputs\")","v":"Missing Inputs"}]
[null,null,"# of Weeks closed per Year",null,null,null,null,null,"Total hp of exhuast fan motors"]
[null,null,"Cooking Load Profile (Select the meal time(s) that best apply.)",null,null,null,null,{"$f":"IF(AND(CookingBreakfast=FALSE,CookingLunch=FALSE,CookingDinner=FALSE,Cooking24_7=FALSE),\"\",TRUE)","v":""}]
[null,null,null,null,null,null,null,null,"Existing fans have variable speed drives",null,null,null,null,null,null,null,null,"Incentive",null,null,null,{"$f":"IF(AND(Incentive_Value>0,Incentive_Value<>\"\"),Incentive_Value,\"Missing Inputs\")","v":"Missing Inputs"}]
[null,null,null,null,null,null,null,null,"Fans run continuously during open hours"]
[null,null,"Weekly Profile (Select the operating schedule(s) that best apply.)",null,null,null,null,{"$f":"IF(AND(OpenWeekdays=FALSE,OpenSaturday=FALSE,OpenSunday=FALSE),\"\",TRUE)","v":""},"Heat recovery is used with make-up air"]
[null,null,null,null,null,null,null,null,"Electric heat used for heating makeup air",null,null,null,null,null,null,null,null,"Cost Savings (Annual)",null,null,null,{"$f":"IF(RateSchedule=\"\",\"Select Rate\",ElectricCostSavings)","v":"Select Rate"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simple Payback (Before Incentives)",null,null,null,{"$f":"IF(EquipmentCost=\"\",\"Enter Equipment Cost\",SPB)","v":"Enter Equipment Cost"}]
[null,null,"Nearest Weather Location",null,null,null,null,null,"Equipment Cost",null,null,null,null,null,null,null,null,"Simple Payback (After Incentives)",null,null,null,{"$f":"IF(EquipmentCost=\"\",\"Enter Equipment Cost\",IF(Incentive=\"\",\"Missing Info\",SPBWithIncentive))","v":"Enter Equipment Cost"}]
[]
[]
[]
[null,null,null,false,false]
[null,null,null,false,false]
[null,null,null,false,false]
[null,null,null,false]

{"sheet":"Calcs","index":1,"n_rows":60,"n_cols":32,"rows_kept":60,"cut":false,"hidden":true,"merged":[[48,12,48,14]]}
[]
["Demand Control Ventilation for Commercial Kitchens using automatic VFD control of both supply and MUA fans, based on cooking load "]
[]
["tool external inputs"]
[{"$f":"'DCKV-Tool'!D39","v":false},"Does the facility serve breakfast?"]
[{"$f":"'DCKV-Tool'!D40","v":false},"Does the facility serve lunch?"]
[{"$f":"'DCKV-Tool'!D41","v":false},"Does the facility serve dinner?"]
[{"$f":"'DCKV-Tool'!D42","v":false},"Is the facility open 24 hrs/day"]
[{"$f":"'DCKV-Tool'!E39","v":false},"Is the facility open Monday -Friday?"]
[{"$f":"'DCKV-Tool'!E40","v":false},"Is the facility open Saturday",null,null,null,null,null,null,null,null,null,"tool internal inputs"]
[{"$f":"'DCKV-Tool'!E41","v":false},"Is the facility open Sunday?",null,null,null,null,null,null,null,null,null,2.5,"= speed exponent for power determination"]
[{"$f":"WeeksClosedPerYear","v":0},"How many weeks per year is the business closed?",null,null,null,null,null,null,null,null,null,0.75,"= motor load factor (dirty filters tend to lower this)"]
[{"$f":"MakeUpFanHP","v":0},"What is the total horsepower of all make-up air fan motors that will be retrofitted?",null,null,null,null,null,null,null,null,null,0.1,"= mimimum VFD motor power"]
[{"$f":"ExhaustFanHP","v":0},"What is the total horsepower of exhaust fan motors that will be retrofitted?"]
[{"$f":"IF('DCKV-Tool'!O29=\"Yes\",TRUE,FALSE)","v":false},"Do existing fans have variable speed drives? (if yes, savings will be decreased by 70%) "]
[{"$f":"IF('DCKV-Tool'!O30=\"Yes\",TRUE,FALSE)","v":false},"Do the fans run continuously during facility open hours? (if not, assume they run 2/3 the time)"]
[{"$f":"IF('DCKV-Tool'!O31=\"Yes\",TRUE,FALSE)","v":false},"Is MUA heat recovery used? (if yes, electric heat savings reduced by HR effectiveness %)"]
[{"$f":"NA()","v":{"$error":"#N/A"}},"Is DX cooling used to cool makeup air? (if yes, this should be retrofitted to evaporative, savings here are  based on evaporative cooling used)"]
[{"$f":"IF('DCKV-Tool'!O32=\"Yes\",TRUE,FALSE)","v":false},"Is electric heat used for heating make-up air? "]
[null,null,null,null,null,null,"note: tool does not accompany different daily schedules"]
["based on the above:",null,null,null,null,null,"ie; any day open is assumed to have the same schedule"]
[{"$f":"+SUM((IF(TRIM($A$9)=\"TRUE\",5,0)+IF(TRIM($A$10)=\"TRUE\",1,0)+IF(TRIM($A$11)=\"TRUE\",1,0)))","v":0},"= weekly day count",null,null,null,null,"this should cover 80% of businesses of this type"]
[{"$f":"52-$A$12","v":52},"= annual week count",null,null,null,null,null,null,{"$f":"+L50","v":0},"test inputs"]
[{"$f":"+A23*A22","v":0},"= annual day count"]
[]
["daily energy use profile:"]
[null,null,"hour of the day","cooking load profile","VFD Power multiplier","24 hr baseline daily energy use, kwh","24 hr proposed daily energy use","B-L-D filter","Actual baseline daily energy use, kwh","Actual proposed daily energy use",null,"fan energy savings"]
[null,null,1,0.2,{"$f":"+MAX($L$13,(D28^$L$11))","v":0.1},{"$f":"+(+$A$14+$A$13)*$L$12*0.754","v":0},{"$f":"+F28*E28","v":0},{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},{"$f":"+H28*F28","v":0},{"$f":"+H28*G28","v":0},null,{"$f":"+$A$24*I52","v":0},"= kwh, actual baseline annual energy use"]
[null,null,2,0.2,0.1,0,{"$f":"+F29*E29","v":0},{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},{"$f":"+H29*F29","v":0},{"$f":"+H29*G29","v":0},null,{"$f":"+$A$24*$J$52","v":0},"= kwh, proposed annual energy use"]
[null,null,3,0.2,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},0,0,null,{"$f":"+L28-L29","v":0},"= kwh, annual energy savings, before corrections",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cell L35","Cell L37",{"$f":"COUNTIF(Z31:Z56,InstallState)","v":0},"Location List"]
[null,null,4,0.2,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(AA31,2)","v":"CA"},"CA1","Crecscent City",50.325832583258325,2222,1,{"$f":"IF(InstallState<>\"\",VLOOKUP(InstallState&AE31,$AA$31:$AB$56,2,FALSE))","v":false}]
[null,null,5,0.2,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},0,0,null,"electric heat savings",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(AA32,2)","v":"ID"},"ID1","Idaho Falls",33.190039318479684,2289,2,false]
[null,null,6,0.3,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$5)=\"TRUE\",1,0))","v":0},0,0,null,0.8,"= makeup heat recovery factor (% HR saves)",null,null,null,null,null,null,null,null,null,null,null,null,"ID","ID2","Malad City",37.078369905956116,2233,3,false]
[null,null,7,0.6,0.27885480092693404,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$5)=\"TRUE\",1,0))","v":0},0,0,null,55,"= make-up air delivery temperature",null,null,null,null,null,null,null,null,null,null,null,null,"ID","ID3","Pocatello",34.806155259531465,2177,4,false]
[null,"breakfast",8,0.9,0.76843347142091623,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$5)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"VLOOKUP(NearestWeatherCity,Calcs!AB31:AD58,2,FALSE)","v":{"$error":"#N/A"}},"= average winter temperature, between 8am and 7 pm, October - April, when OAT<55",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT1","Blanding",39.452812645281263,2151,5,false]
[null,null,9,1,1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$5)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"28-$A$12","v":28},"= total winter weeks",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT10","Salt Lake City",39.87282662692499,2013,6,false]
[null,null,10,0.6,0.27885480092693404,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$5)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"IF(AND(TRIM(A17)=\"TRUE\",TRIM(A19)=\"TRUE\"),MIN(COUNTIF(F28:F51,\">0\")*(A24/2),VLOOKUP(NearestWeatherCity,Calcs!AB31:AD58,3,FALSE)),0)","v":0},"= total winter hours (lesser of operational hours and bin hours< 55 F, Oct-Apr, 8a-7p)",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT11","St George",46.415785764622974,1419,7,false]
[null,null,11,0.3,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$6)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"+U47","v":4.2358522534733983E-4},"= assumed bhp/cfm for MUA unit",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT12","Vernal",36.527544351073765,2142,8,false]
[null,null,12,0.9,0.76843347142091623,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$6)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"+$A$13/L38","v":0},"= cfm, MUA, baseline",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT13","Wendover",38.349673202614376,2142,9,false]
[null,"lunch",13,1,1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$6)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"+AVERAGEIF(H28:H51,\"=1\",D28:D51)","v":{"$error":"#DIV/0!"}},"= average % cfm when on, proposed",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT2","Bryce Canyon",32.667665952890793,2335,10,false]
[null,null,14,0.7,0.40996341300169697,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$6)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"++L39*L40","v":{"$error":"#DIV/0!"}},"= average cfm, MUA, proposed",null,null,null,null,null,null,null,null,null,null,null,null,"UT","UT3","Cedar City",38.769510926118627,1922,11,false]
[null,null,15,0.3,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$6)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"+IF(TRIM($A$19)=\"TRUE\",((((L39-L41)*60*0.84*0.075*0.24*(L34-L35))/3413)*L37),0)","v":0},"= potential electric heat savings",null,null,null,null,null,null,null,"typical bhp/cfm",null,null,null,null,"UT","UT4","Delta",39.670072992700732,2055,12,false]
[null,null,16,0.3,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,IF(TRIM($A$7)=\"TRUE\",1,0))","v":0},0,0,null,{"$f":"+IF(TRIM($A$17)=\"TRUE\",L42*(1-L33),L42)","v":0},"= actual electric heat savings (accounts for heat recovery if present)",null,null,null,null,null,null,null,1000,"= cfm",null,null,null,"UT","UT5","Hanksville",40.771514846502264,1987,13,false]
[null,null,17,0.6,0.27885480092693404,0,0,0,0,0,null,null,null,null,null,null,null,null,"correction",null,1.75,"= iWC, TSP",null,null,null,{"$f":"LEFT(AA44,2)","v":"UT"},"UT6","Moab",41.141025641025642,1950]
[null,null,18,0.9,0.76843347142091623,0,0,0,0,0,null,"corrections",null,null,null,null,null,null,"input factor",null,0.65,"= fan efficiency",null,null,null,"UT","UT7","Ogden Hill AFB",37.244010647737355,2254]
[null,"dinner",19,1,1,0,0,0,0,0,null,{"$f":"+IF(TRIM($A$16)=\"FALSE\",S46,1)","v":0.66},"= non continuous baseline operation factor (if applicable)",null,null,null,null,null,0.66,null,{"$f":"+(U43*U44)/(6356*U45)","v":0.42358522534733983},"= bhp",null,null,null,"UT","UT8","Ogden Hinckley Airport",38.027817745803354,2085]
[null,null,20,0.7,0.40996341300169697,0,0,0,0,0,null,{"$f":"+IF(TRIM($A$15)=\"TRUE\",S47,1)","v":1},"= existing VFDs savings penalty factor",null,null,null,null,null,0.3,null,{"$f":"+U46/U43","v":4.2358522534733983E-4},"= bhp/cfm",null,null,null,"UT","UT9","Provo",39.107208872458408,2164]
[null,null,21,0.3,0.1,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WA","WA1","Walla Walla City",42.541789577187807,2034]
[null,null,22,0.2,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},0,0,null,0.15,"= incentive rate",null,null,null,null,null,null,null,null,null,null,null,null,"WA","WA2","Yakima",39.111825828797627,2021]
[null,null,23,0.2,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},0,0,null,{"$f":"+(L30+L43)*L46*L47","v":0},"= kWh, grand total savings ",null,null,null,null,null,null,null,null,null,null,null,null,"WY","WY1","Casper",33.7041530564629,2143]
[null,null,24,0.2,0.1,0,0,{"$f":"+IF(TRIM($A$8)=\"TRUE\",1,0)","v":0},0,0,null,{"$f":"kWhSavings*IncentiveRate","v":0},"= incentive",null,null,null,null,null,null,null,null,null,null,null,null,"WY","WY2","Cheyenne",35.803167420814482,2210]
[null,"totals",null,null,null,null,null,null,{"$f":"+SUM(I28:I51)","v":0},{"$f":"+SUM(J28:J51)","v":0},"kwh/day",{"$f":"+L51/A14","v":{"$error":"#DIV/0!"}},"= incentive normalized to $/ exhaust fan hp",null,null,null,null,null,null,null,null,null,null,null,null,"WY","WY3","Evanston",31.170578373847444,2386]
[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,"WY","WY4","Lander",33.096788581623549,2242]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Tariffs and Rates'!E8","v":"Enter State and Rate Schedule Into Yellow Cells Above"},"=electric rate $/kWh",null,null,null,null,null,null,null,null,null,null,null,null,"WY","WY5","Laramie",34.121671258034894,2178]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ElectricRate*kWhSavings","v":{"$error":"#VALUE!"}},"=electric cost savings",null,null,null,null,null,null,null,null,null,null,null,null,"WY","WY6","Riverton",32.845155709342563,2312]
[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,"WY","WY7","Worland",34.092694063926942,2190]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"EquipmentCost/ElectricCostSavings","v":{"$error":"#VALUE!"}},"=SPB (years)",null,null,null,null,null,null,null,null,null,null,null,null,null,"OR","Klamath Falls",39.220331588132638,2292]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(EquipmentCost-Incentive)/ElectricCostSavings","v":{"$error":"#VALUE!"}},"=SPB w/ Incentives (years)",null,null,null,null,null,null,null,null,null,null,null,null,null,"OR","Medford",44.099792099792097,1924]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"EquipmentCost-Incentive","v":{"$error":"#VALUE!"}}]

{"sheet":"Weather Data","index":2,"n_rows":590,"n_cols":20,"rows_kept":590,"cut":false,"hidden":true,"merged":[]}
[null,"Complete List",null,null,null,null,null,null,null,"UT","Selected Service Territory",null,null,null,null,null,null,"State","# of Weather Locations"]
[null,"State","Ref","State-Ref","City","Weather COOP Site Name","ID","CDD (65°F)",null,null,"State","Ref","State-Ref","City","Weather COOP Site Name","ID","CDD (65°F)",null,"California",{"$f":"COUNTIF($B$3:$B$461,\"CA\")","v":64}]
[null,"CA",1,{"$f":"CONCATENATE(B3,\"-\",C3)","v":"CA-1"},"Adin Ranger Stn","Adin Ranger Stn",40029,246,null,null,{"$f":"IF(L3<>\"\",$J$1,\"\")","v":"UT"},1,"UT-1","ALLEN'S RANCH",{"$f":"N3","v":"ALLEN'S RANCH"},420050,479,null,"Idaho",{"$f":"COUNTIF($B$3:$B$461,\"ID\")","v":84}]
[null,"CA",2,{"$f":"CONCATENATE(B4,\"-\",C4)","v":"CA-2"},"Adlerpoint","Adlerpoint",40088,630,null,null,{"$f":"IF(L4<>\"\",$J$1,\"\")","v":"UT"},2,"UT-2","ALPINE",{"$f":"N4","v":"ALPINE"},420061,666,null,"Utah",{"$f":"COUNTIF($B$3:$B$461,\"UT\")","v":246}]
[null,"CA",3,"CA-3","Alturas Ranger Station","Alturas Ranger Station",40161,175,null,null,"UT",3,"UT-3","ALTA","ALTA",420072,28,null,"Washington",{"$f":"COUNTIF($B$3:$B$461,\"WA\")","v":65}]
[null,"CA",4,"CA-4","Big Bar Ranger Station","Big Bar Ranger Station",40738,932,null,null,"UT",4,"UT-4","ALTAMONT","ALTAMONT",420074,243,null,"Wyoming",{"$f":"COUNTIF($B$3:$B$590,\"WY\")","v":129}]
[null,"CA",5,"CA-5","Burney","Burney",41214,181,null,null,"UT",5,"UT-5","ALTON","ALTON",420086,190]
[null,"CA",6,"CA-6","Callahan","Callahan",41316,323,null,null,"UT",6,"UT-6","ANETH PLANT","ANETH PLANT",420157,1464]
[null,"CA",7,"CA-7","Canby Ranger Station","Canby Ranger Station",41476,212,null,null,"UT",7,"UT-7","ANGLE","ANGLE",420168,131]
[null,"CA",8,"CA-8","Canyon Dam","Canyon Dam",41497,177,null,null,"UT",8,"UT-8","ARCHES NP HQS","ARCHES NP HQS",420336,1706]
[null,"CA",9,"CA-9","Cecilville 1 SE","Cecilville 1 SE",41606,485,null,null,"UT",9,"UT-9","BEAVER","BEAVER",420519,405]
[null,"CA",10,"CA-10","Cedarville","Cedarville",41614,484,null,null,"UT",10,"UT-10","BIG WATER","BIG WATER",420688,1673]
[null,"CA",11,"CA-11","Chester","Chester",41700,123,null,null,"UT",11,"UT-11","BIRDSEYE","BIRDSEYE",420716,171]
[null,"CA",12,"CA-12","China Flat","China Flat",41731,621,null,null,"UT",12,"UT-12","BLACK ROCK","BLACK ROCK",420730,532]
[null,"CA",13,"CA-13","Crescent City 1 N","Crescent City 1 N",42147,8,null,null,"UT",13,"UT-13","BLANDING","BLANDING",420738,921]
[null,"CA",14,"CA-14","Dunsmuir Treatment Plant","Dunsmuir Treatment Plant",42574,590,null,null,"UT",14,"UT-14","BLOWHARD MTN RA","BLOWHARD MTN RA",420757,9]
[null,"CA",15,"CA-15","Elk Valley","Elk Valley",42749,201,null,null,"UT",15,"UT-15","BLUFF","BLUFF",420788,1059]
[null,"CA",16,"CA-16","Eureka WSO City","Eureka WSO City",42910,2,null,null,"UT",16,"UT-16","BOUNTIFUL-VAL V","BOUNTIFUL-VAL V",420820,861]
[null,"CA",17,"CA-17","Fall River Mills Intake","Fall River Mills Intake",42964,276,null,null,"UT",17,"UT-17","BOULDER","BOULDER",420849,539]
[null,"CA",18,"CA-18","Ferndale 2 NW","Ferndale 2 NW",43030,3,null,null,"UT",18,"UT-18","BRIGHAM CITY WA","BRIGHAM CITY WA",420928,649]
[null,"CA",19,"CA-19","Fleming Fish & Game","Fleming Fish & Game",43087,337,null,null,"UT",19,"UT-19","BRYCE CANYON NA","BRYCE CANYON NA",421008,39]
[null,"CA",20,"CA-20","Forest Glen","Forest Glen",43130,379,null,null,"UT",20,"UT-20","BULLFROG BASIN","BULLFROG BASIN",421020,2031]
[null,"CA",21,"CA-21","Fort Bidwell","Fort Bidwell",43157,243,null,null,"UT",21,"UT-21","CALLAO","CALLAO",421144,670]
[null,"CA",22,"CA-22","Fort Jones Ranger Stn","Fort Jones Ranger Stn",43182,374,null,null,"UT",22,"UT-22","CANYONLANDS THE","CANYONLANDS THE",421163,1143]
[null,"CA",23,"CA-23","Grizzly Creek State Park","Grizzly Creek State Park",43647,37,null,null,"UT",23,"UT-23","CANYONLANDS THE","CANYONLANDS THE",421168,1073]
[null,"CA",24,"CA-24","Happy Camp Ranger Stn","Happy Camp Ranger Stn",43761,735,null,null,"UT",24,"UT-24","CAPITOL REEF NA","CAPITOL REEF NA",421171,1028]
[null,"CA",25,"CA-25","Hat Creek PH 1","Hat Creek PH 1",43824,333,null,null,"UT",25,"UT-25","CASTLE DALE","CASTLE DALE",421214,429]
[null,"CA",26,"CA-26","Hayfork Ranger Station","Hayfork Ranger Station",43859,391,null,null,"UT",26,"UT-26","CASTLE VALLEY I","CASTLE VALLEY I",421241,1174]
[null,"CA",27,"CA-27","Hilts Slash Disposal","Hilts Slash Disposal",43987,394,null,null,"UT",27,"UT-27","CEDAR CITY AP   CDC","CEDAR CITY AP   CDC",421267,704]
[null,"CA",28,"CA-28","Hoopa","Hoopa",44082,683,null,null,"UT",28,"UT-28","CEDAR POINT","CEDAR POINT",421308,359]
[null,"CA",29,"CA-29","Jess Valley","Jess Valley",44374,132,null,null,"UT",29,"UT-29","CIRCLEVILLE","CIRCLEVILLE",421432,328]
[null,"CA",30,"CA-30","Klamath","Klamath",44577,9,null,null,"UT",30,"UT-30","COALVILLE","COALVILLE",421588,178]
[null,"CA",31,"CA-31","Lake City","Lake City",44675,404,null,null,"UT",31,"UT-31","COALVILLE 13 E","COALVILLE 13 E",421590,83]
[null,"CA",32,"CA-32","Lakeshore 2","Lakeshore 2",44709,1179,null,null,"UT",32,"UT-32","CORINNE","CORINNE",421731,676]
[null,"CA",33,"CA-33","Lava Beds Nat Monument","Lava Beds Nat Monument",44838,338,null,null,"UT",33,"UT-33","COTTONWOOD WEIR","COTTONWOOD WEIR",421759,1197]
[null,"CA",34,"CA-34","Manzanita Lake","Manzanita Lake",45311,75,null,null,"UT",34,"UT-34","CUTLER DAM UTAH","CUTLER DAM UTAH",421918,787]
[null,"CA",35,"CA-35","Mc Cloud","Mc Cloud",45449,303,null,null,"UT",35,"UT-35","DEER CREEK DAM","DEER CREEK DAM",422057,163]
[null,"CA",36,"CA-36","Mineral","Mineral",45679,64,null,null,"UT",36,"UT-36","DELTA","DELTA",422090,809]
[null,"CA",37,"CA-37","Mount Hebron Rng Stn","Mount Hebron Rng Stn",45941,88,null,null,"UT",37,"UT-37","DESERET","DESERET",422101,799]
[null,"CA",38,"CA-38","Mount Shasta","Mount Shasta",45983,273,null,null,"UT",38,"UT-38","DEWEY","DEWEY",422150,1289]
[null,"CA",39,"CA-39","Orick Prairie Creek Pk","Orick Prairie Creek Pk",46498,9,null,null,"UT",39,"UT-39","DINOSAUR NM QUA","DINOSAUR NM QUA",422173,702]
[null,"CA",40,"CA-40","Orleans","Orleans",46508,793,null,null,"UT",40,"UT-40","DRAPER POINT OF","DRAPER POINT OF",422235,1172]
[null,"CA",41,"CA-41","Platina","Platina",46975,813,null,null,"UT",41,"UT-41","DUCHESNE","DUCHESNE",422253,420]
[null,"CA",42,"CA-42","Red Bluff FSS","Red Bluff FSS",47292,1850,null,null,"UT",42,"UT-42","DUGWAY","DUGWAY",422257,1038]
[null,"CA",43,"CA-43","Redding","Redding",47296,2076,null,null,"UT",43,"UT-43","ECHO DAM","ECHO DAM",422385,255]
[null,"CA",44,"CA-44","Redding Fire Stn 4","Redding Fire Stn 4",47300,1552,null,null,"UT",44,"UT-44","ELBERTA","ELBERTA",422418,815]
[null,"CA",45,"CA-45","Redding WSO","Redding WSO",47304,1850,null,null,"UT",45,"UT-45","ELECTRIC LAKE U","ELECTRIC LAKE U",422424,1]
[null,"CA",46,"CA-46","Richardson Grove St Pk","Richardson Grove St Pk",47404,484,null,null,"UT",46,"UT-46","ENTERPRISE BERY","ENTERPRISE BERY",422561,377]
[null,"CA",47,"CA-47","Salyer Ranger Stn","Salyer Ranger Stn",47698,778,null,null,"UT",47,"UT-47","EPHRAIM SORENSE","EPHRAIM SORENSE",422578,592]
[null,"CA",48,"CA-48","Sawyers Bar Rngr Stn","Sawyers Bar Rngr Stn",48025,635,null,null,"UT",48,"UT-48","ESCALANTE","ESCALANTE",422592,607]
[null,"CA",49,"CA-49","Scotia","Scotia",48045,34,null,null,"UT",49,"UT-49","ESKDALE","ESKDALE",422607,831]
[null,"CA",50,"CA-50","Shasta Dam","Shasta Dam",48135,1832,null,null,"UT",50,"UT-50","FAIRFIELD","FAIRFIELD",422696,391]
[null,"CA",51,"CA-51","Shelter Cove","Shelter Cove",48162,45,null,null,"UT",51,"UT-51","FARMINGTON COUR","FARMINGTON COUR",422726,886]
[null,"CA",52,"CA-52","Shelter Cove Aviation","Shelter Cove Aviation",48463,122,null,null,"UT",52,"UT-52","FERRON","FERRON",422798,624]
[null,"CA",53,"CA-53","Susanville Airport","Susanville Airport",48702,389,null,null,"UT",53,"UT-53","FILLMORE","FILLMORE",422828,748]
[null,"CA",54,"CA-54","Termo 1 E","Termo 1 E",48873,105,null,null,"UT",54,"UT-54","FISH SPRINGS RE","FISH SPRINGS RE",422852,1183]
[null,"CA",55,"CA-55","Trinity Dam Vista Point","Trinity Dam Vista Point",49024,633,null,null,"UT",55,"UT-55","FLAMING GORGE","FLAMING GORGE",422864,241]
[null,"CA",56,"CA-56","Trinity River Hatchery","Trinity River Hatchery",49026,659,null,null,"UT",56,"UT-56","FORT DUCHESNE","FORT DUCHESNE",422996,614]
[null,"CA",57,"CA-57","Tulelake","Tulelake",49053,139,null,null,"UT",57,"UT-57","FREMONT INDIAN","FREMONT INDIAN",423012,437]
[null,"CA",58,"CA-58","Turntable Creek","Turntable Creek",49083,1627,null,null,"UT",58,"UT-58","GARFIELD","GARFIELD",423097,1300]
[null,"CA",59,"CA-59","Volta Power House","Volta Power House",49390,1272,null,null,"UT",59,"UT-59","GARRISON","GARRISON",423138,724]
[null,"CA",60,"CA-60","Weaverville Ranger Stn","Weaverville Ranger Stn",49490,592,null,null,"UT",60,"UT-60","GREEN RIVER AVI","GREEN RIVER AVI",423418,1292]
[null,"CA",61,"CA-61","Weed Fire Dept","Weed Fire Dept",49499,244,null,null,"UT",61,"UT-61","GROUSE CREEK","GROUSE CREEK",423486,300]
[null,"CA",62,"CA-62","Whiskeytown Reservoir","Whiskeytown Reservoir",49621,1599,null,null,"UT",62,"UT-62","GUNNISON","GUNNISON",423514,561]
[null,"CA",63,"CA-63","Willow Creek 1 NW","Willow Creek 1 NW",49694,826,null,null,"UT",63,"UT-63","HANS FLAT RANGE","HANS FLAT RANGE",423600,869]
[null,"CA",64,"CA-64","Yreka","Yreka",49866,575,null,null,"UT",64,"UT-64","HANKSVILLE","HANKSVILLE",423611,1278]
[null,"ID",1,"ID-1","Aberdeen Experiment Stn","Aberdeen Experiment Stn",100010,285,null,null,"UT",65,"UT-65","HANNA","HANNA",423624,137]
[null,"ID",2,{"$f":"CONCATENATE(B68,\"-\",C68)","v":"ID-2"},"American Falls 1 SW","American Falls 1 SW",100227,449,null,null,{"$f":"IF(L68<>\"\",$J$1,\"\")","v":"UT"},66,"UT-66","HARDWARE RANCH",{"$f":"N68","v":"HARDWARE RANCH"},423671,93]
[null,"ID",3,"ID-3","Arbon 2 NW","Arbon 2 NW",100347,262,null,null,"UT",67,"UT-67","HEBER","HEBER",423809,344]
[null,"ID",4,"ID-4","Arco 3 SW","Arco 3 SW",100375,218,null,null,"UT",68,"UT-68","HIAWATHA","HIAWATHA",423896,257]
[null,"ID",5,"ID-5","Ashton","Ashton",100470,94,null,null,"UT",69,"UT-69","HITE RANGER STA","HITE RANGER STA",423980,2117]
[null,"ID",6,"ID-6","Bern","Bern",100803,112,null,null,"UT",70,"UT-70","HOVENWEEP NM","HOVENWEEP NM",424100,871]
[null,"ID",7,"ID-7","Blackfoot 2 SSW","Blackfoot 2 SSW",100915,366,null,null,"UT",71,"UT-71","HUNTSVILLE MONA","HUNTSVILLE MONA",424135,251]
[null,"ID",8,"ID-8","Burley","Burley",101288,690,null,null,"UT",72,"UT-72","IBAPAH","IBAPAH",424174,327]
[null,"ID",9,"ID-9","Burley FAA Airport","Burley FAA Airport",101303,442,null,null,"UT",73,"UT-73","JENSEN","JENSEN",424342,524]
[null,"ID",10,"ID-10","Burley Factory","Burley Factory",101298,398,null,null,"UT",74,"UT-74","JOHNSON PASS","JOHNSON PASS",424362,776]
[null,"ID",11,"ID-11","Challis","Challis",101663,273,null,null,"UT",75,"UT-75","KAMAS","KAMAS",424467,191]
[null,"ID",12,"ID-12","Chilly Barton Flat","Chilly Barton Flat",101671,52,null,null,"UT",76,"UT-76","KANAB","KANAB",424508,742]
[null,"ID",13,"ID-13","Cobalt","Cobalt",101932,61,null,null,"UT",77,"UT-77","KANOSH","KANOSH",424527,969]
[null,"ID",14,"ID-14","Cobalt Blackbird Mine","Cobalt Blackbird Mine",101938,10,null,null,"UT",78,"UT-78","KNOLLS 10 NE","KNOLLS 10 NE",424748,897]
[null,"ID",15,"ID-15","Conda","Conda",102071,89,null,null,"UT",79,"UT-79","KODACHROME BASI","KODACHROME BASI",424755,490]
[null,"ID",16,"ID-16","Craters of the Moon NM","Craters of the Moon NM",102260,295,null,null,"UT",80,"UT-80","KOOSHAREM","KOOSHAREM",424764,126]
[null,"ID",17,"ID-17","Driggs","Driggs",102676,74,null,null,"UT",81,"UT-81","LAKETOWN","LAKETOWN",424856,145]
[null,"ID",18,"ID-18","Dubois Experiment Stn","Dubois Experiment Stn",102707,304,null,null,"UT",82,"UT-82","LA SAL 1 SW","LA SAL 1 SW",424947,394]
[null,"ID",19,"ID-19","Dubois FAA Airport","Dubois FAA Airport",102717,325,null,null,"UT",83,"UT-83","LA VERKIN","LA VERKIN",424968,1865]
[null,"ID",20,"ID-20","Fort Hall Indian Agency","Fort Hall Indian Agency",103297,336,null,null,"UT",84,"UT-84","LEVAN","LEVAN",425065,731]
[null,"ID",21,"ID-21","Galena","Galena",103417,1,null,null,"UT",85,"UT-85","LITTLE SAHARA D","LITTLE SAHARA D",425138,662]
[null,"ID",22,"ID-22","Gibbonsville","Gibbonsville",103554,129,null,null,"UT",86,"UT-86","LOA","LOA",425148,119]
[null,"ID",23,"ID-23","Grace","Grace",103732,165,null,null,"UT",87,"UT-87","LOGAN RADIO KVN","LOGAN RADIO KVN",425182,522]
[null,"ID",24,"ID-24","Gray","Gray",103825,73,null,null,"UT",88,"UT-88","LOGAN UTAH STAT LGU","LOGAN UTAH STAT LGU",425186,684]
[null,"ID",25,"ID-25","Grouse","Grouse",103882,15,null,null,"UT",89,"UT-89","LOGAN 5 SW EXP","LOGAN 5 SW EXP",425194,374]
[null,"ID",26,"ID-26","Hailey 3 NNW","Hailey 3 NNW",103942,214,null,null,"UT",90,"UT-90","LYTLE RANCH","LYTLE RANCH",425252,1666]
[null,"ID",27,"ID-27","Hazelton","Hazelton",104140,510,null,null,"UT",91,"UT-91","MAESER 9 NW","MAESER 9 NW",425268,324]
[null,"ID",28,"ID-28","Henry","Henry",104230,41,null,null,"UT",92,"UT-92","MANILA","MANILA",425377,338]
[null,"ID",29,"ID-29","Hollister","Hollister",104295,435,null,null,"UT",93,"UT-93","MANTI","MANTI",425402,386]
[null,"ID",30,"ID-30","Howe","Howe",104384,289,null,null,"UT",94,"UT-94","MARYSVALE","MARYSVALE",425477,383]
[null,"ID",31,"ID-31","Idaho Falls 16 SE","Idaho Falls 16 SE",104456,79,null,null,"UT",95,"UT-95","MEXICAN HAT","MEXICAN HAT",425582,1515]
[null,"ID",32,"ID-32","Idaho Falls 2 ESE","Idaho Falls 2 ESE",104455,354,null,null,"UT",96,"UT-96","MILFORD         MLF","MILFORD         MLF",425654,715]
[null,"ID",33,"ID-33","Idaho Falls 43 NW WB","Idaho Falls 43 NW WB",104459,271,null,null,"UT",97,"UT-97","MOAB","MOAB",425733,1743]
[null,"ID",34,"ID-34","Idaho Falls 46 W","Idaho Falls 46 W",104460,273,null,null,"UT",98,"UT-98","MODENA","MODENA",425752,547]
[null,"ID",35,"ID-35","Idaho Falls FAA Airport","Idaho Falls FAA Airport",104457,269,null,null,"UT",99,"UT-99","MONTICELLO","MONTICELLO",425805,257]
[null,"ID",36,"ID-36","Irwin 2 SE","Irwin 2 SE",104588,147,null,null,"UT",100,"UT-100","MONUMENT VLY MI","MONUMENT VLY MI",425812,1600]
[null,"ID",37,"ID-37","Island Park","Island Park",104598,25,null,null,"UT",101,"UT-101","MORGAN POWER AN","MORGAN POWER AN",425826,358]
[null,"ID",38,"ID-38","Jerome","Jerome",104670,665,null,null,"UT",102,"UT-102","MORONI","MORONI",425837,292]
[null,"ID",39,"ID-39","Ketchum Ranger Stn","Ketchum Ranger Stn",104845,44,null,null,"UT",103,"UT-103","MOUNTAIN DELL D","MOUNTAIN DELL D",425892,392]
[null,"ID",40,"ID-40","Kilgore","Kilgore",104908,5,null,null,"UT",104,"UT-104","MYTON","MYTON",425969,525]
[null,"ID",41,"ID-41","Leadore 2","Leadore 2",105177,53,null,null,"UT",105,"UT-105","NATURAL BRIDGES","NATURAL BRIDGES",426053,645]
[null,"ID",42,"ID-42","Lifton Pumping Stn","Lifton Pumping Stn",105275,138,null,null,"UT",106,"UT-106","NEOLA","NEOLA",426123,352]
[null,"ID",43,"ID-43","Mackay 4 NW","Mackay 4 NW",105466,142,null,null,"UT",107,"UT-107","NEPHI","NEPHI",426135,811]
[null,"ID",44,"ID-44","Mackay Ranger Stn","Mackay Ranger Stn",105462,164,null,null,"UT",108,"UT-108","NEW HARMONY","NEW HARMONY",426181,631]
[null,"ID",45,"ID-45","Magic Lake Resort","Magic Lake Resort",105510,450,null,null,"UT",109,"UT-109","OAK CITY","OAK CITY",426357,1153]
[null,"ID",46,"ID-46","Malad ","Malad ",105544,400,null,null,"UT",110,"UT-110","OGDEN PIONEER P","OGDEN PIONEER P",426404,980]
[null,"ID",47,"ID-47","Malad City","Malad City",105559,334,null,null,"UT",111,"UT-111","OGDEN SUGAR FAC","OGDEN SUGAR FAC",426414,909]
[null,"ID",48,"ID-48","Malta 2 E","Malta 2 E",105563,351,null,null,"UT",112,"UT-112","OLMSTEAD P H","OLMSTEAD P H",426455,893]
[null,"ID",49,"ID-49","Malta Aviation","Malta Aviation",105567,382,null,null,"UT",113,"UT-113","ORDERVILLE","ORDERVILLE",426534,712]
[null,"ID",50,"ID-50","Massacre Rocks ST PK","Massacre Rocks ST PK",105678,592,null,null,"UT",114,"UT-114","OREM TREATMENT","OREM TREATMENT",426538,1016]
[null,"ID",51,"ID-51","May","May",105685,146,null,null,"UT",115,"UT-115","OURAY 4 NE","OURAY 4 NE",426568,817]
[null,"ID",52,"ID-52","Mccammon","Mccammon",105716,315,null,null,"UT",116,"UT-116","PANGUITCH","PANGUITCH",426601,211]
[null,"ID",53,"ID-53","Minidoka 10 WNW","Minidoka 10 WNW",105972,264,null,null,"UT",117,"UT-117","PARK VALLEY","PARK VALLEY",426658,428]
[null,"ID",54,"ID-54","Minidoka Dam","Minidoka Dam",105980,531,null,null,"UT",118,"UT-118","PAROWAN POWER P","PAROWAN POWER P",426686,481]
[null,"ID",55,"ID-55","Montpelier Ranger Stn","Montpelier Ranger Stn",106053,151,null,null,"UT",119,"UT-119","PARTOUN","PARTOUN",426708,783]
[null,"ID",56,"ID-56","Oakley","Oakley",106542,443,null,null,"UT",120,"UT-120","PINE VIEW DAM","PINE VIEW DAM",426869,238]
[null,"ID",57,"ID-57","Palisades","Palisades",106764,212,null,null,"UT",121,"UT-121","PLEASANT GROVE","PLEASANT GROVE",426919,796]
[null,"ID",58,"ID-58","Paul 1 ENE","Paul 1 ENE",106877,423,null,null,"UT",122,"UT-122","PROVO BYU","PROVO BYU",427064,1028]
[null,"ID",59,"ID-59","Picabo","Picabo",107040,214,null,null,"UT",123,"UT-123","RANDOLPH","RANDOLPH",427165,56]
[null,"ID",60,"ID-60","Pocatello 2","Pocatello 2",107208,597,null,null,"UT",124,"UT-124","RICHFIELD RADIO","RICHFIELD RADIO",427260,418]
[null,"ID",61,"ID-61","Pocatello WSO Airport","Pocatello WSO Airport",107211,429,null,null,"UT",125,"UT-125","RICHMOND","RICHMOND",427271,578]
[null,"ID",62,"ID-62","Preston","Preston",107346,353,null,null,"UT",126,"UT-126","RIVERDALE","RIVERDALE",427318,746]
[null,"ID",63,"ID-63","Preston Sugar Factory 2","Preston Sugar Factory 2",104353,356,null,null,"UT",127,"UT-127","ROOSEVELT RADIO","ROOSEVELT RADIO",427395,483]
[null,"ID",64,"ID-64","Rexburg Ricks College","Rexburg Ricks College",107644,205,null,null,"UT",128,"UT-128","ROSETTE","ROSETTE",427408,422]
[null,"ID",65,"ID-65","Richfield","Richfield",107673,381,null,null,"UT",129,"UT-129","ST GEORGE","ST GEORGE",427516,2471]
[null,"ID",66,{"$f":"CONCATENATE(B132,\"-\",C132)","v":"ID-66"},"Rupert 3 WSW","Rupert 3 WSW",107968,452,null,null,{"$f":"IF(L132<>\"\",$J$1,\"\")","v":"UT"},130,"UT-130","SALINA",{"$f":"N132","v":"SALINA"},427557,543]
[null,"ID",67,"ID-67","Salmon Airport","Salmon Airport",108076,228,null,null,{"$f":"IF(L133<>\"\",$J$1,\"\")","v":"UT"},131,"UT-131","SALINA 24 E","SALINA 24 E",427559,87]
[null,"ID",68,"ID-68","Salmon KSRA","Salmon KSRA",108080,352,null,null,"UT",132,"UT-132","SALTAIR SALT PL","SALTAIR SALT PL",427578,971]
[null,"ID",69,"ID-69","Shoshone 1 WNW","Shoshone 1 WNW",108380,675,null,null,"UT",133,"UT-133","SALT LAKE CITY  SLC","SALT LAKE CITY  SLC",427598,1066]
[null,"ID",70,"ID-70","Shoup","Shoup",108395,433,null,null,"UT",134,"UT-134","SALT LAKE TRIAD","SALT LAKE TRIAD",427606,1190]
[null,"ID",71,"ID-71","Soda Springs Airport","Soda Springs Airport",108535,116,null,null,"UT",135,"UT-135","SANTAQUIN CHLOR","SANTAQUIN CHLOR",427686,826]
[null,"ID",72,"ID-72","Spencer Ranger Stn","Spencer Ranger Stn",108604,45,null,null,"UT",136,"UT-136","SCIPIO","SCIPIO",427714,525]
[null,"ID",73,"ID-73","Springfield","Springfield",108626,269,null,null,"UT",137,"UT-137","SCOFIELD DAM","SCOFIELD DAM",427724,25]
[null,"ID",74,"ID-74","St Anthony 1 WNW","St Anthony 1 WNW",108022,120,null,null,"UT",138,"UT-138","SCOFIELD-SKYLAN","SCOFIELD-SKYLAN",427729,22]
[null,"ID",75,"ID-75","Strevell","Strevell",108786,370,null,null,"UT",139,"UT-139","SILVER LAKE BRI","SILVER LAKE BRI",427846,13]
[null,"ID",76,"ID-76","Sugar","Sugar",108818,126,null,null,"UT",140,"UT-140","SNAKE CREEK POW","SNAKE CREEK POW",427909,161]
[null,"ID",77,"ID-77","Sun Valley","Sun Valley",108906,26,null,null,"UT",141,"UT-141","SNOWVILLE","SNOWVILLE",427931,450]
[null,"ID",78,"ID-78","Swan Valley 2 E","Swan Valley 2 E",108937,116,null,null,"UT",142,"UT-142","SOLDIER SUMMIT","SOLDIER SUMMIT",427959,13]
[null,"ID",79,"ID-79","Tetonia Experiment Stn","Tetonia Experiment Stn",109065,55,null,null,"UT",143,"UT-143","SPANISH FORK PW","SPANISH FORK PW",428119,907]
[null,"ID",80,"ID-80","Twin Falls 2 NNE","Twin Falls 2 NNE",109294,499,null,null,"UT",144,"UT-144","SUNNYSIDE","SUNNYSIDE",428474,315]
[null,"ID",81,"ID-81","Twin Falls 3 SE","Twin Falls 3 SE",109299,513,null,null,"UT",145,"UT-145","SUNNYSIDE CITY","SUNNYSIDE CITY",428478,509]
[null,"ID",82,"ID-82","Twin Falls Kmvt","Twin Falls Kmvt",109293,604,null,null,"UT",146,"UT-146","THIOKOL PLANT 7","THIOKOL PLANT 7",428668,646]
[null,"ID",83,"ID-83","Twin Falls WSO","Twin Falls WSO",109303,372,null,null,"UT",147,"UT-147","THOMPSON","THOMPSON",428705,1234]
[null,"ID",84,"ID-84","Wayan 1 N","Wayan 1 N",109601,42,null,null,"UT",148,"UT-148","TIMPANOGOS CAVE","TIMPANOGOS CAVE",428733,774]
[null,"UT",1,"UT-1","Allen's Ranch","Allen's Ranch",420050,389,null,null,"UT",149,"UT-149","TOOELE","TOOELE",428771,988]
[null,"UT",2,"UT-2","Alpine","Alpine",420061,637,null,null,"UT",150,"UT-150","TREMONTON","TREMONTON",428817,730]
[null,"UT",3,"UT-3","Alta","Alta",420072,17,null,null,"UT",151,"UT-151","TRENTON","TRENTON",428828,323]
[null,"UT",4,"UT-4","Altamont","Altamont",420074,220,null,null,"UT",152,"UT-152","TROPIC","TROPIC",428847,376]
[null,"UT",5,"UT-5","Alton","Alton",420086,133,null,null,"UT",153,"UT-153","UTAH LAKE LEHI","UTAH LAKE LEHI",428973,610]
[null,"UT",6,"UT-6","Aneth Plant","Aneth Plant",420157,1391,null,null,"UT",154,"UT-154","VERNAL AP       VEL","VERNAL AP       VEL",429111,499]
[null,"UT",7,"UT-7","Angle","Angle",420168,127,null,null,"UT",155,"UT-155","VERNON","VERNON",429133,553]
[null,"UT",8,"UT-8","Antelope Island","Antelope Island",420194,1063,null,null,"UT",156,"UT-156","VEYO POWERHOUSE","VEYO POWERHOUSE",429136,1077]
[null,"UT",9,"UT-9","Antimony","Antimony",420201,136,null,null,"UT",157,"UT-157","WAH WAH RANCH","WAH WAH RANCH",429152,899]
[null,"UT",10,"UT-10","Arches Natl Park HQ","Arches Natl Park HQ",420336,1782,null,null,"UT",158,"UT-158","WANSHIP DAM","WANSHIP DAM",429165,239]
[null,"UT",11,"UT-11","ASR Research Lab","ASR Research Lab",420302,650,null,null,"UT",159,"UT-159","WENDOVER","WENDOVER",429382,1088]
[null,"UT",12,"UT-12","ASTR Research Lab","ASTR Research Lab",427608,919,null,null,"UT",160,"UT-160","WOODRUFF","WOODRUFF",429595,60]
[null,"UT",13,"UT-13","Bauer","Bauer",420478,751,null,null,"UT",161,"","","","",""]
[null,"UT",14,"UT-14","Bear Lake State Park","Bear Lake State Park",420487,235,null,null,"UT",162,"","","","",""]
[null,"UT",15,"UT-15","Bear River Bay","Bear River Bay",420490,1041,null,null,"UT",163,"","","","",""]
[null,"UT",16,"UT-16","Bear River Refuge","Bear River Refuge",420506,824,null,null,"UT",164,"","","","",""]
[null,"UT",17,"UT-17","Beaver","Beaver",420519,290,null,null,"UT",165,"","","","",""]
[null,"UT",18,"UT-18","Beaver Canyon PH","Beaver Canyon PH",420527,200,null,null,"UT",166,"","","","",""]
[null,"UT",19,"UT-19","Big Water","Big Water",420688,1787,null,null,"UT",167,"","","","",""]
[null,"UT",20,"UT-20","Bingham Canyon","Bingham Canyon",420699,532,null,null,"UT",168,"","","","",""]
[null,"UT",21,"UT-21","Bingham Canyon 2 NE","Bingham Canyon 2 NE",420700,775,null,null,"UT",169,"","","","",""]
[null,"UT",22,"UT-22","Birdseye","Birdseye",420716,110,null,null,"UT",170,"","","","",""]
[null,"UT",23,"UT-23","Black Rock","Black Rock",420730,588,null,null,"UT",171,"","","","",""]
[null,"UT",24,"UT-24","Blanding","Blanding",420738,632,null,null,"UT",172,"","","","",""]
[null,"UT",25,"UT-25","Blowhard Mtn Radar","Blowhard Mtn Radar",420757,4,null,null,"UT",173,"","","","",""]
[null,"UT",26,"UT-26","Bluff","Bluff",420788,1231,null,null,"UT",174,"","","","",""]
[null,"UT",27,"UT-27","Bonanza","Bonanza",420802,746,null,null,"UT",175,"","","","",""]
[null,"UT",28,"UT-28","Bonanza Pumping Stn","Bonanza Pumping Stn",420810,818,null,null,"UT",176,"","","","",""]
[null,"UT",29,"UT-29","Boulder","Boulder",420849,482,null,null,"UT",177,"","","","",""]
[null,"UT",30,"UT-30","Bountiful-Val Verda","Bountiful-Val Verda",420820,966,null,null,"UT",178,"","","","",""]
[null,"UT",31,"UT-31","Brian Head","Brian Head",420900,0,null,null,"UT",179,"","","","",""]
[null,"UT",32,"UT-32","Brigham City","Brigham City",420924,968,null,null,"UT",180,"","","","",""]
[null,"UT",33,"UT-33","Brigham City Waste Plt","Brigham City Waste Plt",420928,675,null,null,"UT",181,"","","","",""]
[null,"UT",34,"UT-34","Bryce Canyon FAA Airport","Bryce Canyon FAA Airport",421002,17,null,null,"UT",182,"","","","",""]
[null,"UT",35,"UT-35","Bryce Canyon Natl Pk HQ","Bryce Canyon Natl Pk HQ",421008,42,null,null,"UT",183,"","","","",""]
[null,"UT",36,"UT-36","Bryce Canyon Nat'l Prk","Bryce Canyon Nat'l Prk",421006,9,null,null,"UT",184,"","","","",""]
[null,"UT",37,"UT-37","Bryce Canyon Nat'l Prk","Bryce Canyon Nat'l Prk",421007,34,null,null,"UT",185,"","","","",""]
[null,"UT",38,"UT-38","Bullfrog Basin","Bullfrog Basin",421020,2030,null,null,"UT",186,"","","","",""]
[null,"UT",39,"UT-39","Callao","Callao",421144,692,null,null,"UT",187,"","","","",""]
[null,"UT",40,"UT-40","Callister Ranch","Callister Ranch",421149,836,null,null,"UT",188,"","","","",""]
[null,"UT",41,"UT-41","Canyonlands The Neck","Canyonlands The Neck",421163,1158,null,null,"UT",189,"","","","",""]
[null,"UT",42,"UT-42","Canyonlands The Needle","Canyonlands The Needle",421168,1189,null,null,"UT",190,"","","","",""]
[null,"UT",43,"UT-43","Capitol Reef Natl Park","Capitol Reef Natl Park",421171,1144,null,null,"UT",191,"","","","",""]
[null,"UT",44,"UT-44","Castle Dale","Castle Dale",421214,430,null,null,"UT",192,"","","","",""]
[null,"UT",45,"UT-45","Castle Valley Inst","Castle Valley Inst",421241,1262,null,null,"UT",193,"","","","",""]
[null,"UT",46,{"$f":"CONCATENATE(B196,\"-\",C196)","v":"UT-46"},"Castleton","Castleton",421230,823,null,null,"UT",194,"","",{"$f":"N196","v":""},"",""]
[null,"UT",47,"UT-47","Cedar City 5 E","Cedar City 5 E",421260,426,null,null,{"$f":"IF(L197<>\"\",$J$1,\"\")","v":"UT"},195,"","","","",""]
[null,"UT",48,"UT-48","Cedar City FAA Airport","Cedar City FAA Airport",421267,671,null,null,"UT",196,"","","","",""]
[null,"UT",49,"UT-49","Cedar City Powerhouse","Cedar City Powerhouse",421272,664,null,null,"UT",197,"","","","",""]
[null,"UT",50,"UT-50","Cedar City Steam Plant","Cedar City Steam Plant",421273,717,null,null,"UT",198,"","","","",""]
[null,"UT",51,"UT-51","Cedar Point","Cedar Point",421308,355,null,null,"UT",199,"","","","",""]
[null,"UT",52,"UT-52","Church Wells","Church Wells",421418,1417,null,null,"UT",200,"","","","",""]
[null,"UT",53,"UT-53","Circleville","Circleville",421432,365,null,null,"UT",201,"","","","",""]
[null,"UT",54,"UT-54","Cisco","Cisco",421440,1178,null,null,"UT",202,"","","","",""]
[null,"UT",55,"UT-55","City Creek Water Plant","City Creek Water Plant",421446,619,null,null,"UT",203,"","","","",""]
[null,"UT",56,"UT-56","Clear Creek","Clear Creek",421427,2,null,null,"UT",204,"","","","",""]
[null,"UT",57,"UT-57","Clear Lake Refuge","Clear Lake Refuge",421500,806,null,null,"UT",205,"","","","",""]
[null,"UT",58,"UT-58","Coalville","Coalville",421588,141,null,null,"UT",206,"","","","",""]
[null,"UT",59,"UT-59","Coalville 13 E","Coalville 13 E",421590,62,null,null,"UT",207,"","","","",""]
[null,"UT",60,"UT-60","Corinne","Corinne",421731,692,null,null,"UT",208,"","","","",""]
[null,"UT",61,"UT-61","Cottonwood Weir","Cottonwood Weir",421759,1253,null,null,"UT",209,"","","","",""]
[null,"UT",62,"UT-62","Cove Fort","Cove Fort",421792,489,null,null,"UT",210,"","","","",""]
[null,"UT",63,"UT-63","Currant Creek Junction","Currant Creek Junction",421907,191,null,null,"UT",211,"","","","",""]
[null,"UT",64,"UT-64","Cutler Dam Utah P&L Co","Cutler Dam Utah P&L Co",421918,874,null,null,"UT",212,"","","","",""]
[null,"UT",65,"UT-65","Deer Creek Dam","Deer Creek Dam",422057,161,null,null,"UT",213,"","","","",""]
[null,"UT",66,"UT-66","Delta","Delta",422090,818,null,null,"UT",214,"","","","",""]
[null,"UT",67,"UT-67","Deseret","Deseret",422101,669,null,null,"UT",215,"","","","",""]
[null,"UT",68,"UT-68","Desert Exp Range","Desert Exp Range",422116,621,null,null,"UT",216,"","","","",""]
[null,"UT",69,"UT-69","Dewey","Dewey",422150,1276,null,null,"UT",217,"","","","",""]
[null,"UT",70,"UT-70","Dinosaur National Monum","Dinosaur National Monum",422172,953,null,null,"UT",218,"","","","",""]
[null,"UT",71,"UT-71","Dinosaur NM Quarry Area","Dinosaur NM Quarry Area",422173,756,null,null,"UT",219,"","","","",""]
[null,"UT",72,"UT-72","Draper Point of the Mtn","Draper Point of the Mtn",422235,1199,null,null,"UT",220,"","","","",""]
[null,"UT",73,"UT-73","Duchesne","Duchesne",422253,327,null,null,"UT",221,"","","","",""]
[null,"UT",74,"UT-74","Duchesne Airport","Duchesne Airport",422252,479,null,null,"UT",222,"","","","",""]
[null,"UT",75,"UT-75","Dugway","Dugway",422257,1039,null,null,"UT",223,"","","","",""]
[null,"UT",76,"UT-76","Echo Dam","Echo Dam",422385,241,null,null,"UT",224,"","","","",""]
[null,"UT",77,"UT-77","Elberta","Elberta",422418,788,null,null,"UT",225,"","","","",""]
[null,"UT",78,"UT-78","Electric Lake UP&L","Electric Lake UP&L",422424,2,null,null,"UT",226,"","","","",""]
[null,"UT",79,"UT-79","Emery","Emery",422484,227,null,null,"UT",227,"","","","",""]
[null,"UT",80,"UT-80","Emery 15 SW","Emery 15 SW",422488,33,null,null,"UT",228,"","","","",""]
[null,"UT",81,"UT-81","Enterprise Beryl Jct","Enterprise Beryl Jct",422561,379,null,null,"UT",229,"","","","",""]
[null,"UT",82,"UT-82","Ephraim Sorensens FLD","Ephraim Sorensens FLD",422578,481,null,null,"UT",230,"","","","",""]
[null,"UT",83,"UT-83","Escalante","Escalante",422592,461,null,null,"UT",231,"","","","",""]
[null,"UT",84,"UT-84","Eskdale","Eskdale",422607,795,null,null,"UT",232,"","","","",""]
[null,"UT",85,"UT-85","Eureka","Eureka",422625,355,null,null,"UT",233,"","","","",""]
[null,"UT",86,"UT-86","Fairfield","Fairfield",422696,363,null,null,"UT",234,"","","","",""]
[null,"UT",87,"UT-87","Fairview 8 N","Fairview 8 N",422702,108,null,null,"UT",235,"","","","",""]
[null,"UT",88,"UT-88","Farmington","Farmington",422721,894,null,null,"UT",236,"","","","",""]
[null,"UT",89,"UT-89","Farmington USU Fld Stn","Farmington USU Fld Stn",422726,925,null,null,"UT",237,"","","","",""]
[null,"UT",90,"UT-90","Ferron","Ferron",422798,595,null,null,"UT",238,"","","","",""]
[null,"UT",91,"UT-91","Fillmore","Fillmore",422828,918,null,null,"UT",239,"","","","",""]
[null,"UT",92,"UT-92","Fish Springs Refuge","Fish Springs Refuge",422852,1264,null,null,"UT",240,"","","","",""]
[null,"UT",93,"UT-93","Flaming Gorge","Flaming Gorge",422864,224,null,null,"UT",241,"","","","",""]
[null,"UT",94,"UT-94","Fort Duchesne","Fort Duchesne",422996,439,null,null,"UT",242,"","","","",""]
[null,"UT",95,"UT-95","Fremont Indian SP","Fremont Indian SP",423012,455,null,null,"UT",243,"","","","",""]
[null,"UT",96,"UT-96","Fruita","Fruita",423046,974,null,null,"UT",244,"","","","",""]
[null,"UT",97,"UT-97","Garfield","Garfield",423097,1328,null,null,"UT",245,"","","","",""]
[null,"UT",98,"UT-98","Garland 1 NW","Garland 1 NW",423122,611,null,null,"UT",246,"","","","",""]
[null,"UT",99,"UT-99","Garrison","Garrison",423138,758,null,null,"UT",247,"","","","",""]
[null,"UT",100,"UT-100","Geneva Steel","Geneva Steel",423182,1004,null,null,"UT",248,"","","","",""]
[null,"UT",101,"UT-101","Geneva Steel 2","Geneva Steel 2",423183,994,null,null,"UT",249,"","","","",""]
[null,"UT",102,"UT-102","Glen Canyon City","Glen Canyon City",423232,1598,null,null,"UT",250,"","","","",""]
[null,"UT",103,"UT-103","Gold Hill","Gold Hill",423260,1026,null,null,"UT",251,"","","","",""]
[null,"UT",104,"UT-104","Grantsville","Grantsville",423348,1130,null,null,"UT",252,"","","","",""]
[null,"UT",105,"UT-105","Green River Aviation","Green River Aviation",423418,1178,null,null,"UT",253,"","","","",""]
[null,"UT",106,"UT-106","Grouse Creek","Grouse Creek",423486,310,null,null,"UT",254,"","","","",""]
[null,"UT",107,"UT-107","Gunnison","Gunnison",423514,458,null,null,"UT",255,"","","","",""]
[null,"UT",108,"UT-108","Hanksville","Hanksville",423611,1313,null,null,"UT",256,"","","","",""]
[null,"UT",109,"UT-109","Hanna","Hanna",423624,87,null,null,"UT",257,"","","","",""]
[null,"UT",110,{"$f":"CONCATENATE(B260,\"-\",C260)","v":"UT-110"},"Hans Flat Ranger Stn","Hans Flat Ranger Stn",423600,919,null,null,"UT",258,"","",{"$f":"N260","v":""},"",""]
[null,"UT",111,"UT-111","Hardware Ranch","Hardware Ranch",423671,53,null,null,{"$f":"IF(L261<>\"\",$J$1,\"\")","v":"UT"},259,"","","","",""]
[null,"UT",112,"UT-112","Heber","Heber",423809,187,null,null,"UT",260,"","","","",""]
[null,"UT",113,"UT-113","Henrieville","Henrieville",423847,342,null,null,"UT",261,"","","","",""]
[null,"UT",114,"UT-114","Hiawatha","Hiawatha",423896,275,null,null,"UT",262,"","","","",""]
[null,"UT",115,"UT-115","Hite","Hite",423968,2179,null,null,"UT",263,"","","","",""]
[null,"UT",116,"UT-116","Hite Marina","Hite Marina",423976,2278,null,null,"UT",264,"","","","",""]
[null,"UT",117,"UT-117","Hite Ranger Stn","Hite Ranger Stn",423980,2289,null,null,"UT",265,"","","","",""]
[null,"UT",118,"UT-118","Hovenweep NM","Hovenweep NM",424100,885,null,null,"UT",266,"","","","",""]
[null,"UT",119,"UT-119","Huntsville Monastery","Huntsville Monastery",424135,230,null,null,"UT",267,"","","","",""]
[null,"UT",120,"UT-120","Ibapah","Ibapah",424174,303,null,null,"UT",268,"","","","",""]
[null,"UT",121,"UT-121","Iosepa South Ranch","Iosepa South Ranch",424233,669,null,null,"UT",269,"","","","",""]
[null,"UT",122,"UT-122","Jensen","Jensen",424342,493,null,null,"UT",270,"","","","",""]
[null,"UT",123,"UT-123","Johnson Pass","Johnson Pass",424362,764,null,null,"UT",271,"","","","",""]
[null,"UT",124,"UT-124","Kamas 3 NW","Kamas 3 NW",424467,156,null,null,"UT",272,"","","","",""]
[null,"UT",125,"UT-125","Kanab","Kanab",424508,872,null,null,"UT",273,"","","","",""]
[null,"UT",126,"UT-126","Kanosh","Kanosh",424527,1070,null,null,"UT",274,"","","","",""]
[null,"UT",127,"UT-127","Knolls 10 NE","Knolls 10 NE",424748,992,null,null,"UT",275,"","","","",""]
[null,"UT",128,"UT-128","Kodachrome Basin Park","Kodachrome Basin Park",424755,482,null,null,"UT",276,"","","","",""]
[null,"UT",129,"UT-129","Koosharem","Koosharem",424764,97,null,null,"UT",277,"","","","",""]
[null,"UT",130,"UT-130","La Sal","La Sal",424946,296,null,null,"UT",278,"","","","",""]
[null,"UT",131,"UT-131","La Sal 2 NE","La Sal 2 NE",424947,384,null,null,"UT",279,"","","","",""]
[null,"UT",132,"UT-132","La Verkin","La Verkin",424968,1730,null,null,"UT",280,"","","","",""]
[null,"UT",133,"UT-133","Lakeside","Lakeside",424846,1229,null,null,"UT",281,"","","","",""]
[null,"UT",134,"UT-134","Laketown","Laketown",424856,112,null,null,"UT",282,"","","","",""]
[null,"UT",135,"UT-135","Levan","Levan",425065,567,null,null,"UT",283,"","","","",""]
[null,"UT",136,"UT-136","Lewiston","Lewiston",425082,316,null,null,"UT",284,"","","","",""]
[null,"UT",137,"UT-137","Little Sahara Dunes","Little Sahara Dunes",425138,691,null,null,"UT",285,"","","","",""]
[null,"UT",138,"UT-138","Loa","Loa",425148,60,null,null,"UT",286,"","","","",""]
[null,"UT",139,"UT-139","Logan 5 SW Exp Farm","Logan 5 SW Exp Farm",425194,373,null,null,"UT",287,"","","","",""]
[null,"UT",140,"UT-140","Logan Radio KVNU","Logan Radio KVNU",425182,493,null,null,"UT",288,"","","","",""]
[null,"UT",141,"UT-141","Logan USU Exp Stn","Logan USU Exp Stn",425190,475,null,null,"UT",289,"","","","",""]
[null,"UT",142,"UT-142","Logan Utah State Univ","Logan Utah State Univ",425186,615,null,null,"UT",290,"","","","",""]
[null,"UT",143,"UT-143","Lower American Fork Pow","Lower American Fork Pow",425219,958,null,null,"UT",291,"","","","",""]
[null,"UT",144,"UT-144","Lucin","Lucin",425239,744,null,null,"UT",292,"","","","",""]
[null,"UT",145,"UT-145","Lund","Lund",425247,574,null,null,"UT",293,"","","","",""]
[null,"UT",146,"UT-146","Lytle Ranch","Lytle Ranch",425252,1718,null,null,"UT",294,"","","","",""]
[null,"UT",147,"UT-147","Maeser 9 NW","Maeser 9 NW",425268,349,null,null,"UT",295,"","","","",""]
[null,"UT",148,"UT-148","Magna Asarco Farm","Magna Asarco Farm",425330,872,null,null,"UT",296,"","","","",""]
[null,"UT",149,"UT-149","Manila","Manila",425377,282,null,null,"UT",297,"","","","",""]
[null,"UT",150,"UT-150","Manti ","Manti ",425402,374,null,null,"UT",298,"","","","",""]
[null,"UT",151,"UT-151","Marysvale","Marysvale",425477,328,null,null,"UT",299,"","","","",""]
[null,"UT",152,"UT-152","Mexican Hat","Mexican Hat",425582,1594,null,null,"UT",300,"","","","",""]
[null,"UT",153,"UT-153","Midlake","Midlake",425607,1113,null,null,"UT",301,"","","","",""]
[null,"UT",154,"UT-154","Midvale","Midvale",425610,881,null,null,"UT",302,"","","","",""]
[null,"UT",155,"UT-155","Milford","Milford",425654,645,null,null,"UT",303,"","","","",""]
[null,"UT",156,"UT-156","Moab","Moab",425733,1446,null,null,"UT",304,"","","","",""]
[null,"UT",157,"UT-157","Modena","Modena",425752,528,null,null,"UT",305,"","","","",""]
[null,"UT",158,"UT-158","Montezuma Creek","Montezuma Creek",425795,366,null,null,"UT",306,"","","","",""]
[null,"UT",159,"UT-159","Monticello","Monticello",425805,243,null,null,"UT",307,"","","","",""]
[null,"UT",160,"UT-160","Monument Vyl Mission","Monument Vyl Mission",425812,1427,null,null,"UT",308,"","","","",""]
[null,"UT",161,"UT-161","Morgan","Morgan",425826,331,null,null,"UT",309,"","","","",""]
[null,"UT",162,"UT-162","Moroni","Moroni",425837,318,null,null,"UT",310,"","","","",""]
[null,"UT",163,"UT-163","Mountain Dell Dam","Mountain Dell Dam",425892,356,null,null,"UT",311,"","","","",""]
[null,"UT",164,"UT-164","Myton","Myton",425969,507,null,null,"UT",312,"","","","",""]
[null,"UT",165,"UT-165","Natural Bridges Natl Mo","Natural Bridges Natl Mo",426053,721,null,null,"UT",313,"","","","",""]
[null,"UT",166,"UT-166","Navajo Mountain","Navajo Mountain",426076,641,null,null,"UT",314,"","","","",""]
[null,"UT",167,"UT-167","Neola","Neola",426123,318,null,null,"UT",315,"","","","",""]
[null,"UT",168,"UT-168","Nephi","Nephi",426135,825,null,null,"UT",316,"","","","",""]
[null,"UT",169,"UT-169","New Harmony","New Harmony",426181,676,null,null,"UT",317,"","","","",""]
[null,"UT",170,"UT-170","Nutters Ranch","Nutters Ranch",426340,376,null,null,"UT",318,"","","","",""]
[null,"UT",171,"UT-171","Oak City","Oak City",426357,1131,null,null,"UT",319,"","","","",""]
[null,"UT",172,"UT-172","Ogden Pioneer PH","Ogden Pioneer PH",426404,895,null,null,"UT",320,"","","","",""]
[null,"UT",173,"UT-173","Ogden Sugar Factory","Ogden Sugar Factory",426414,859,null,null,"UT",321,"","","","",""]
[null,"UT",174,{"$f":"CONCATENATE(B324,\"-\",C324)","v":"UT-174"},"Olmstead Powerhouse","Olmstead Powerhouse",426455,896,null,null,"UT",322,"","",{"$f":"N324","v":""},"",""]
[null,"UT",175,"UT-175","Orderville","Orderville",426534,611,null,null,{"$f":"IF(L325<>\"\",$J$1,\"\")","v":"UT"},323,"","","","",""]
[null,"UT",176,"UT-176","Orem Treatment Plant","Orem Treatment Plant",426538,1051,null,null,"UT",324,"","","","",""]
[null,"UT",177,"UT-177","Ouray 4 NE","Ouray 4 NE",426568,786,null,null,"UT",325,"","","","",""]
[null,"UT",178,"UT-178","Panguitch","Panguitch",426601,94,null,null,"UT",326,"","","","",""]
[null,"UT",179,"UT-179","Park City Fire Station 31","Park City Fire Station 31",426644,115,null,null,"UT",327,"","","","",""]
[null,"UT",180,"UT-180","Park City Radio","Park City Radio",426648,154,null,null,"UT",328,"","","","",""]
[null,"UT",181,"UT-181","Park City Summit House","Park City Summit House",426652,18,null,null,"UT",329,"","","","",""]
[null,"UT",182,"UT-182","Park Valley","Park Valley",426658,450,null,null,"UT",330,"","","","",""]
[null,"UT",183,"UT-183","Park Valley Muddy Ranch","Park Valley Muddy Ranch",426660,474,null,null,"UT",331,"","","","",""]
[null,"UT",184,"UT-184","Parowan Power Plant","Parowan Power Plant",426686,460,null,null,"UT",332,"","","","",""]
[null,"UT",185,"UT-185","Partoun","Partoun",426708,788,null,null,"UT",333,"","","","",""]
[null,"UT",186,"UT-186","Pine View Dam","Pine View Dam",426869,269,null,null,"UT",334,"","","","",""]
[null,"UT",187,"UT-187","Piute Dam","Piute Dam",426897,467,null,null,"UT",335,"","","","",""]
[null,"UT",188,"UT-188","Pleasant Creek Powerhouse","Pleasant Creek Powerhouse",426915,72,null,null,"UT",336,"","","","",""]
[null,"UT",189,"UT-189","Pleasant Grove","Pleasant Grove",426919,765,null,null,"UT",337,"","","","",""]
[null,"UT",190,"UT-190","Price Game Farm","Price Game Farm",427015,624,null,null,"UT",338,"","","","",""]
[null,"UT",191,"UT-191","Price Warehouses","Price Warehouses",427026,753,null,null,"UT",339,"","","","",""]
[null,"UT",192,"UT-192","Provo Airport","Provo Airport",427061,626,null,null,"UT",340,"","","","",""]
[null,"UT",193,"UT-193","Provo BYU","Provo BYU",427064,1038,null,null,"UT",341,"","","","",""]
[null,"UT",194,"UT-194","Provo Radio KAYK","Provo Radio KAYK",427068,526,null,null,"UT",342,"","","","",""]
[null,"UT",195,"UT-195","Randolph","Randolph",427165,35,null,null,"UT",343,"","","","",""]
[null,"UT",196,"UT-196","Richfield Radio KSVC","Richfield Radio KSVC",427260,423,null,null,"UT",344,"","","","",""]
[null,"UT",197,"UT-197","Richmond","Richmond",427271,518,null,null,"UT",345,"","","","",""]
[null,"UT",198,"UT-198","Riverdale","Riverdale",427318,774,null,null,"UT",346,"","","","",""]
[null,"UT",199,"UT-199","Roosevelt Radio","Roosevelt Radio",427395,557,null,null,"UT",347,"","","","",""]
[null,"UT",200,"UT-200","Rosette","Rosette",427408,507,null,null,"UT",348,"","","","",""]
[null,"UT",201,"UT-201","Salina","Salina",427557,582,null,null,"UT",349,"","","","",""]
[null,"UT",202,"UT-202","Salina 24 SE","Salina 24 SE",427559,108,null,null,"UT",350,"","","","",""]
[null,"UT",203,"UT-203","Salt Lake City","Salt Lake City",427603,1105,null,null,"UT",351,"","","","",""]
[null,"UT",204,"UT-204","Salt Lake City NWSFO","Salt Lake City NWSFO",427598,1056,null,null,"UT",352,"","","","",""]
[null,"UT",205,"UT-205","Salt Lake City Zoo","Salt Lake City Zoo",427655,998,null,null,"UT",353,"","","","",""]
[null,"UT",206,"UT-206","Salt Lake Triad Center","Salt Lake Triad Center",427606,1278,null,null,"UT",354,"","","","",""]
[null,"UT",207,"UT-207","Saltair Salt Plant","Saltair Salt Plant",427578,936,null,null,"UT",355,"","","","",""]
[null,"UT",208,"UT-208","Sandy Ranch","Sandy Ranch",427661,742,null,null,"UT",356,"","","","",""]
[null,"UT",209,"UT-209","Santaquin Chlorinator","Santaquin Chlorinator",427686,824,null,null,"UT",357,"","","","",""]
[null,"UT",210,"UT-210","Scipio","Scipio",427714,507,null,null,"UT",358,"","","","",""]
[null,"UT",211,"UT-211","Scofield","Scofield",427720,1,null,null,"UT",359,"","","","",""]
[null,"UT",212,"UT-212","Scofield Dam","Scofield Dam",427724,10,null,null,"UT",360,"","","","",""]
[null,"UT",213,"UT-213","Scofield-Skyland Mine","Scofield-Skyland Mine",427729,20,null,null,"UT",361,"","","","",""]
[null,"UT",214,"UT-214","Sevier Dry Lake","Sevier Dry Lake",427747,998,null,null,"UT",362,"","","","",""]
[null,"UT",215,"UT-215","Sigurd UP&L","Sigurd UP&L",427800,589,null,null,"UT",363,"","","","",""]
[null,"UT",216,"UT-216","Silver Lake Brighton","Silver Lake Brighton",427846,4,null,null,"UT",364,"","","","",""]
[null,"UT",217,"UT-217","Snake Creek Powerhouse","Snake Creek Powerhouse",427909,109,null,null,"UT",365,"","","","",""]
[null,"UT",218,"UT-218","Snowville","Snowville",427931,381,null,null,"UT",366,"","","","",""]
[null,"UT",219,"UT-219","Snyderville","Snyderville",427942,30,null,null,"UT",367,"","","","",""]
[null,"UT",220,"UT-220","Soldier Summit","Soldier Summit",427959,10,null,null,"UT",368,"","","","",""]
[null,"UT",221,"UT-221","Spanish Fork 1 S","Spanish Fork 1 S",428114,843,null,null,"UT",369,"","","","",""]
[null,"UT",222,"UT-222","Spanish Fork Powerhouse","Spanish Fork Powerhouse",428119,925]
[null,"UT",223,"UT-223","St George","St George",427516,2022]
[null,"UT",224,"UT-224","St George CAA Airport","St George CAA Airport",427510,2225]
[null,"UT",225,"UT-225","Sunnyside","Sunnyside",428474,354]
[null,"UT",226,"UT-226","Sunnyside City Center","Sunnyside City Center",428478,536]
[null,"UT",227,"UT-227","Thiokol Plant 78","Thiokol Plant 78",428668,588]
[null,"UT",228,"UT-228","Thompson","Thompson",428705,1160]
[null,"UT",229,"UT-229","Timpanogos Cave","Timpanogos Cave",428733,678]
[null,"UT",230,"UT-230","Toole","Toole",428771,862]
[null,"UT",231,"UT-231","Trementon","Trementon",428817,800]
[null,"UT",232,"UT-232","Trenton","Trenton",428828,307]
[null,"UT",233,"UT-233","Tropic","Tropic",428847,264]
[null,"UT",234,"UT-234","Uintalands","Uintalands",428900,1]
[null,"UT",235,"UT-235","University of Utah","University of Utah",428922,1081]
[null,"UT",236,"UT-236","Utah Lake Lehi","Utah Lake Lehi",428973,553]
[null,"UT",237,"UT-237","Utah Test Range","Utah Test Range",428978,927]
[null,"UT",238,{"$f":"CONCATENATE(B388,\"-\",C388)","v":"UT-238"},"Vernal Arpt","Vernal Arpt",429111,391]
[null,"UT",239,"UT-239","Vernon","Vernon",429133,505]
[null,"UT",240,"UT-240","Veyo Powerhouse","Veyo Powerhouse",429136,1003]
[null,"UT",241,"UT-241","Wah Wah Ranch","Wah Wah Ranch",429152,898]
[null,"UT",242,"UT-242","Wanship Dam","Wanship Dam",429165,169]
[null,"UT",243,"UT-243","Wendover WSO Airport","Wendover WSO Airport",429382,1211]
[null,"UT",244,"UT-244","Woodruff","Woodruff",429595,35]
[null,"UT",245,"UT-245","Woodside","Woodside",429629,924]
[null,"UT",246,"UT-246","Zion National Park","Zion National Park",429717,2073]
[null,"WA",1,{"$f":"CONCATENATE(B397,\"-\",C397)","v":"WA-1"},"Anatone 2 S","Anatone 2 S",450184,162]
[null,"WA",2,"WA-2","Benton City 2 NW","Benton City 2 NW",450628,624]
[null,"WA",3,"WA-3","Bickleton 3 ESE","Bickleton 3 ESE",450668,345]
[null,"WA",4,"WA-4","Cheney","Cheney",451362,319]
[null,"WA",5,"WA-5","Clarkston Heights","Clarkston Heights",451474,470]
[null,"WA",6,"WA-6","Colfax 1 NW","Colfax 1 NW",451586,278]
[null,"WA",7,"WA-7","Connell 1 W","Connell 1 W",451690,627]
[null,"WA",8,"WA-8","Dayton 1 WSW","Dayton 1 WSW",452030,523]
[null,"WA",9,"WA-9","Ellensburg","Ellensburg",452505,340]
[null,"WA",10,"WA-10","Ellensburg FAA Airport","Ellensburg FAA Airport",452508,338]
[null,"WA",11,"WA-11","Eltopia 5 W","Eltopia 5 W",452540,585]
[null,"WA",12,"WA-12","Eltopia 8 WSW","Eltopia 8 WSW",452542,467]
[null,"WA",13,"WA-13","Ephrata","Ephrata",452609,946]
[null,"WA",14,"WA-14","Ephrata Airport FCWOS","Ephrata Airport FCWOS",452614,861]
[null,"WA",15,"WA-15","Harrington 1 N","Harrington 1 N",453512,217]
[null,"WA",16,"WA-16","Harrington 2 S","Harrington 2 S",453513,479]
[null,"WA",17,"WA-17","Harrington 4 ENE","Harrington 4 ENE",453515,249]
[null,"WA",18,"WA-18","Hatton 9 SE","Hatton 9 SE",453546,623]
[null,"WA",19,"WA-19","Ice Harbor Dam","Ice Harbor Dam",453883,822]
[null,"WA",20,"WA-20","John Day Dam","John Day Dam",454035,932]
[null,"WA",21,"WA-21","Kennewick","Kennewick",454154,867]
[null,"WA",22,"WA-22","Kennewick 10 SW","Kennewick 10 SW",454459,757]
[null,"WA",23,"WA-23","La Crosse","La Crosse",454338,443]
[null,"WA",24,"WA-24","Leavenworth 3 S","Leavenworth 3 S",454572,416]
[null,"WA",25,"WA-25","Lind 3 NE Exp Stn","Lind 3 NE Exp Stn",454679,534]
[null,"WA",26,"WA-26","Little Goose Dam","Little Goose Dam",454702,948]
[null,"WA",27,"WA-27","Lower Granite Dam","Lower Granite Dam",454835,1106]
[null,"WA",28,"WA-28","Lower Monumental Dam","Lower Monumental Dam",454841,1005]
[null,"WA",29,"WA-29","Mc Nary Dam","Mc Nary Dam",455231,852]
[null,"WA",30,"WA-30","Moses Lake","Moses Lake",455608,442]
[null,"WA",31,"WA-31","Moses Lake 3","Moses Lake 3",455613,459]
[null,"WA",32,"WA-32","Moxee City 10 E","Moxee City 10 E",455688,385]
[null,"WA",33,"WA-33","Odessa","Odessa",456039,459]
[null,"WA",34,"WA-34","Othello 6 ESE","Othello 6 ESE",456215,538]
[null,"WA",35,"WA-35","Pleasant View","Pleasant View",456553,768]
[null,"WA",36,"WA-36","Pomeroy","Pomeroy",456610,501]
[null,"WA",37,"WA-37","Priest Rapids Dam","Priest Rapids Dam",456747,1190]
[null,"WA",38,"WA-38","Prosser","Prosser",456763,628]
[null,"WA",39,"WA-39","Prosser 4 NE","Prosser 4 NE",456768,548]
[null,"WA",40,"WA-40","Pullman 2 NW","Pullman 2 NW",456789,249]
[null,"WA",41,"WA-41","Pullman Exp Stn","Pullman Exp Stn",456784,314]
[null,"WA",42,"WA-42","Quincy 1 S","Quincy 1 S",456880,617]
[null,"WA",43,"WA-43","Richland","Richland",457015,881]
[null,"WA",44,"WA-44","Ritzville","Ritzville",457059,452]
[null,"WA",45,"WA-45","Rosalia","Rosalia",457180,278]
[null,"WA",46,"WA-46","Ruff 3 SW","Ruff 3 SW",457223,494]
[null,"WA",47,"WA-47","Saint John","Saint John",457267,309]
[null,"WA",48,"WA-48","Satus Pass","Satus Pass",457340,325]
[null,"WA",49,"WA-49","Satus Pass 2 SSW","Satus Pass 2 SSW",457342,169]
[null,"WA",50,"WA-50","Smyrna","Smyrna",457727,836]
[null,"WA",51,"WA-51","Sprague","Sprague",457956,369]
[null,"WA",52,"WA-52","Sunnyside","Sunnyside",458207,685]
[null,"WA",53,"WA-53","Trinidad 2 SSE","Trinidad 2 SSE",458579,1085]
[null,"WA",54,"WA-54","Walla Walla 3 Ent La","Walla Walla 3 Ent La",458926,723]
[null,"WA",55,"WA-55","Walla Walla FAA Airport","Walla Walla FAA Airport",458928,847]
[null,"WA",56,{"$f":"CONCATENATE(B452,\"-\",C452)","v":"WA-56"},"Walla Walla WB City","Walla Walla WB City",458931,873]
[null,"WA",57,"WA-57","Wapato","Wapato",458959,804]
[null,"WA",58,"WA-58","Wawawai","Wawawai",459024,797]
[null,"WA",59,"WA-59","Wenatchee","Wenatchee",459074,751]
[null,"WA",60,"WA-60","Wenatchee Exp Stn","Wenatchee Exp Stn",459079,571]
[null,"WA",61,"WA-61","Wenatchee FAA Airport","Wenatchee FAA Airport",459082,753]
[null,"WA",62,"WA-62","White Swan","White Swan",459191,419]
[null,"WA",63,"WA-63","Whitman Mission","Whitman Mission",459200,529]
[null,"WA",64,"WA-64","Wilson Creek","Wilson Creek",459327,513]
[null,"WA",65,"WA-65","Yakima WSO Ap","Yakima WSO Ap",459465,467]
[null,"WY",1,"WY-1","AFTON","AFTON",480027,9915]
[null,"WY",2,"WY-2","ALBIN","ALBIN",480080,6836]
[null,"WY",3,"WY-3","ALTA 1 NNW","ALTA 1 NNW",480140,9102]
[null,"WY",4,"WY-4","ARCHER","ARCHER",480270,7495]
[null,"WY",5,"WY-5","BAGGS","BAGGS",480484,8169]
[null,"WY",6,"WY-6","BASIN","BASIN",480540,7743]
[null,"WY",7,"WY-7","BATES CREEK NO","BATES CREEK NO",480552,8348]
[null,"WY",8,"WY-8","BEDFORD 3 SE","BEDFORD 3 SE",480603,10184]
[null,"WY",9,"WY-9","BIG PINEY       BPI","BIG PINEY       BPI",480695,10669]
[null,"WY",10,"WY-10","BILLY CREEK","BILLY CREEK",480740,8200]
[null,"WY",11,"WY-11","BITTER CREEK 4","BITTER CREEK 4",480761,8685]
[null,"WY",12,"WY-12","BLACK MOUNTAIN","BLACK MOUNTAIN",480778,7522]
[null,"WY",13,"WY-13","BONDURANT","BONDURANT",480865,11782]
[null,"WY",14,"WY-14","BORDER 3 N","BORDER 3 N",480915,9493]
[null,"WY",15,"WY-15","BOULDER REARING","BOULDER REARING",480951,10784]
[null,"WY",16,"WY-16","BOYSEN DAM","BOYSEN DAM",481000,7804]
[null,"WY",17,"WY-17","BUFFALO","BUFFALO",481165,7879]
[null,"WY",18,"WY-18","BUFFALO BILL DA","BUFFALO BILL DA",481175,7188]
[null,"WY",19,"WY-19","BURGESS JUNCTIO","BURGESS JUNCTIO",481220,11713]
[null,"WY",20,"WY-20","BURRIS","BURRIS",481284,8394]
[null,"WY",21,"WY-21","CARPENTER","CARPENTER",481547,7012]
[null,"WY",22,"WY-22","CASPER NATRONA  CPR","CASPER NATRONA  CPR",481570,7571]
[null,"WY",23,"WY-23","CENTENNIAL 1 N","CENTENNIAL 1 N",481610,9120]
[null,"WY",24,"WY-24","CHEYENNE MUNICI CYS","CHEYENNE MUNICI CYS",481675,7388]
[null,"WY",25,"WY-25","CHUGWATER","CHUGWATER",481730,7561]
[null,"WY",26,"WY-26","CHURCH BUTTES G","CHURCH BUTTES G",481736,8957]
[null,"WY",27,"WY-27","CLARK 3 NE","CLARK 3 NE",481775,7992]
[null,"WY",28,"WY-28","CLEARMONT 5 SW","CLEARMONT 5 SW",481816,8509]
[null,"WY",29,"WY-29","CODY","CODY",481840,7243]
[null,"WY",30,"WY-30","CODY 12 SE","CODY 12 SE",481850,7937]
[null,"WY",31,"WY-31","CODY 21 SW","CODY 21 SW",481855,7870]
[null,"WY",32,"WY-32","COLONY","COLONY",481905,7250]
[null,"WY",33,"WY-33","CORA","CORA",482054,10917]
[null,"WY",34,"WY-34","DANIEL FISH HAT","DANIEL FISH HAT",482242,11404]
[null,"WY",35,"WY-35","DARWIN RANCH","DARWIN RANCH",482375,12809]
[null,"WY",36,"WY-36","DEAD HORSE CREE","DEAD HORSE CREE",482410,8123]
[null,"WY",37,"WY-37","DEAVER","DEAVER",482415,8096]
[null,"WY",38,"WY-38","DEVILS TOWER 2","DEVILS TOWER 2",482466,8308]
[null,"WY",39,"WY-39","DILLINGER","DILLINGER",482580,8034]
[null,"WY",40,"WY-40","DIVERSION DAM","DIVERSION DAM",482595,8335]
[null,"WY",41,"WY-41","DOUBLE FOUR RAN","DOUBLE FOUR RAN",482680,8197]
[null,"WY",42,"WY-42","DOUGLAS AVIATIO","DOUGLAS AVIATIO",482693,7433]
[null,"WY",43,"WY-43","DUBOIS","DUBOIS",482715,9245]
[null,"WY",44,"WY-44","DULL CENTER 1 S","DULL CENTER 1 S",482725,7284]
[null,"WY",45,"WY-45","ECHETA 2 NW","ECHETA 2 NW",482881,7841]
[null,"WY",46,"WY-46","ELK MOUNTAIN","ELK MOUNTAIN",482995,8738]
[null,"WY",47,"WY-47","EMBLEM","EMBLEM",483031,7708]
[null,"WY",48,"WY-48","ENCAMPMENT 10 E","ENCAMPMENT 10 E",483045,8858]
[null,"WY",49,"WY-49","EVANSTON 1 E","EVANSTON 1 E",483100,9054]
[null,"WY",50,"WY-50","FARSON 5 N","FARSON 5 N",483170,10347]
[null,"WY",51,"WY-51","FONTENELLE DAM","FONTENELLE DAM",483396,10505]
[null,"WY",52,"WY-52","GAS HILLS 4 E","GAS HILLS 4 E",483801,8619]
[null,"WY",53,"WY-53","GILLETTE 6 SE   GCC","GILLETTE 6 SE   GCC",483855,8034]
[null,"WY",54,"WY-54","GLENROCK 5 ESE","GLENROCK 5 ESE",483950,6835]
[null,"WY",55,{"$f":"CONCATENATE(B516,\"-\",C516)","v":"WY-55"},"GLENROCK 14 SSE","GLENROCK 14 SSE",483960,8406]
[null,"WY",56,"WY-56","GRASS CREEK","GRASS CREEK",484036,7945]
[null,"WY",57,"WY-57","GREEN RIVER","GREEN RIVER",484065,8183]
[null,"WY",58,"WY-58","GREYBULL","GREYBULL",484080,7966]
[null,"WY",59,"WY-59","HEART MOUNTAIN","HEART MOUNTAIN",484411,7421]
[null,"WY",60,"WY-60","HULETT","HULETT",484760,7899]
[null,"WY",61,"WY-61","JACKSON","JACKSON",484910,9529]
[null,"WY",62,"WY-62","JEFFREY CITY","JEFFREY CITY",484925,8750]
[null,"WY",63,"WY-63","KAYCEE","KAYCEE",485055,7896]
[null,"WY",64,"WY-64","KEELINE 3 W","KEELINE 3 W",485085,7640]
[null,"WY",65,"WY-65","KEELINE 7 SW","KEELINE 7 SW",485088,7646]
[null,"WY",66,"WY-66","KEMMERER 2 N","KEMMERER 2 N",485105,9767]
[null,"WY",67,"WY-67","LA BARGE","LA BARGE",485252,10026]
[null,"WY",68,"WY-68","LA GRANGE","LA GRANGE",485260,6461]
[null,"WY",69,"WY-69","LAKE YELLOWSTON P60","LAKE YELLOWSTON P60",485345,12223]
[null,"WY",70,"WY-70","LANDER AP       LND","LANDER AP       LND",485390,7790]
[null,"WY",71,"WY-71","LARAMIE RGNL AP LAR","LARAMIE RGNL AP LAR",485415,9038]
[null,"WY",72,"WY-72","LARAMIE 2 NW","LARAMIE 2 NW",485435,9233]
[null,"WY",73,"WY-73","LEITER 9 N","LEITER 9 N",485506,7398]
[null,"WY",74,"WY-74","LOVELL","LOVELL",485770,7932]
[null,"WY",75,"WY-75","LUSK 2 SW","LUSK 2 SW",485830,7991]
[null,"WY",76,"WY-76","MEDICINE BOW","MEDICINE BOW",486120,8338]
[null,"WY",77,"WY-77","MERNA","MERNA",486165,10959]
[null,"WY",78,"WY-78","MIDWEST","MIDWEST",486195,7537]
[null,"WY",79,"WY-79","MOORCROFT 3 S","MOORCROFT 3 S",486395,8360]
[null,"WY",80,"WY-80","MOOSE","MOOSE",486428,10296]
[null,"WY",81,"WY-81","MORAN 5 WNW","MORAN 5 WNW",486440,10210]
[null,"WY",82,"WY-82","MOUNTAIN VIEW","MOUNTAIN VIEW",486555,8364]
[null,"WY",83,"WY-83","MUDDY GAP","MUDDY GAP",486595,7681]
[null,"WY",84,"WY-84","NEWCASTLE","NEWCASTLE",486660,7426]
[null,"WY",85,"WY-85","OLD FAITHFUL","OLD FAITHFUL",486845,11468]
[null,"WY",86,"WY-86","OLD FORT LARAMI","OLD FORT LARAMI",486852,7030]
[null,"WY",87,"WY-87","PATHFINDER DAM","PATHFINDER DAM",487105,7369]
[null,"WY",88,"WY-88","PAVILLION","PAVILLION",487115,7784]
[null,"WY",89,"WY-89","PHILLIPS","PHILLIPS",487200,6944]
[null,"WY",90,"WY-90","PINE BLUFFS","PINE BLUFFS",487235,7123]
[null,"WY",91,"WY-91","PINE BLUFFS 5 W","PINE BLUFFS 5 W",487240,7398]
[null,"WY",92,"WY-92","PINEDALE","PINEDALE",487260,10634]
[null,"WY",93,"WY-93","POWDER RIVER NO","POWDER RIVER NO",487376,7925]
[null,"WY",94,"WY-94","POWELL FIELD ST","POWELL FIELD ST",487388,8122]
[null,"WY",95,"WY-95","RAWLINS AP      RWL","RAWLINS AP      RWL",487533,7885]
[null,"WY",96,"WY-96","RECLUSE 11 NNW","RECLUSE 11 NNW",487548,8941]
[null,"WY",97,"WY-97","REDBIRD","REDBIRD",487555,7316]
[null,"WY",98,"WY-98","RIVERTON","RIVERTON",487760,8365]
[null,"WY",99,"WY-99","ROCHELLE 3 E","ROCHELLE 3 E",487810,8123]
[null,"WY",100,"WY-100","ROCK SPRINGS AP","ROCK SPRINGS AP",487845,8670]
[null,"WY",101,"WY-101","SAGE 4 NNW","SAGE 4 NNW",487955,9717]
[null,"WY",102,"WY-102","SARATOGA","SARATOGA",487990,8107]
[null,"WY",103,"WY-103","SEMINOE DAM","SEMINOE DAM",488070,8020]
[null,"WY",104,"WY-104","SHELL","SHELL",488124,8075]
[null,"WY",105,"WY-105","SHERIDAN AP     SHR","SHERIDAN AP     SHR",488155,7721]
[null,"WY",106,"WY-106","SHERIDAN FIELD","SHERIDAN FIELD",488160,7827]
[null,"WY",107,"WY-107","SHIRLEY BASIN","SHIRLEY BASIN",488192,10847]
[null,"WY",108,"WY-108","SNAKE RIVER","SNAKE RIVER",488315,11565]
[null,"WY",109,"WY-109","SOUTH PASS CITY","SOUTH PASS CITY",488385,11547]
[null,"WY",110,"WY-110","SUNDANCE","SUNDANCE",488705,8166]
[null,"WY",111,"WY-111","SUNSHINE 3 NE","SUNSHINE 3 NE",488758,9401]
[null,"WY",112,"WY-112","SYBILLE RESEARC","SYBILLE RESEARC",488808,7754]
[null,"WY",113,"WY-113","TEN SLEEP 4 NE","TEN SLEEP 4 NE",488852,6748]
[null,"WY",114,"WY-114","TEN SLEEP 16 SS","TEN SLEEP 16 SS",488858,8654]
[null,"WY",115,"WY-115","THERMOPOLIS","THERMOPOLIS",488875,6877]
[null,"WY",116,"WY-116","THERMOPOLIS 2","THERMOPOLIS 2",488880,7502]
[null,"WY",117,"WY-117","THERMOPOLIS 25","THERMOPOLIS 25",488888,8323]
[null,"WY",118,"WY-118","TORRINGTON EXP","TORRINGTON EXP",488995,6908]
[null,"WY",119,{"$f":"CONCATENATE(B580,\"-\",C580)","v":"WY-119"},"TOWER FALLS","TOWER FALLS",489025,10726]
[null,"WY",120,"WY-120","UPTON","UPTON",489205,7952]
[null,"WY",121,"WY-121","WAMSUTTER","WAMSUTTER",489459,8998]
[null,"WY",122,"WY-122","WAPITI 1 NE","WAPITI 1 NE",489467,7882]
[null,"WY",123,"WY-123","WESTON 1 E","WESTON 1 E",489580,7332]
[null,"WY",124,"WY-124","WHALEN DAM (USB","WHALEN DAM (USB",489604,6389]
[null,"WY",125,"WY-125","WHEATLAND 4 N","WHEATLAND 4 N",489615,6321]
[null,"WY",126,"WY-126","WORLAND","WORLAND",489770,7928]
[null,"WY",127,"WY-127","WORLAND MUNICIP WRL","WORLAND MUNICIP WRL",489785,7426]
[null,"WY",128,"WY-128","YELLOWSTONE PAR","YELLOWSTONE PAR",489905,9488]
[null,"WY",129,"WY-129","YODER 2 WSW","YODER 2 WSW",489925,6695]

{"sheet":"EFLH Lookup","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Building Type","A","b","CDD","Default if  < 75","EFLH"]
[null,"Education - Community College",327.83,-0.88349999999999995,2471,300,{"$f":"IF(E3>=75,C3*(E3^D3)*E3,F3)","v":814.55116385156464}]
[null,"Education - Secondary School",240.98,-0.91739999999999999,{"$f":"E3","v":2471},183,{"$f":"IF(E4>=75,C4*(E4^D4)*E4,F4)","v":459.44368736709924}]
[null,"Education - University",512.11,-0.91479999999999995,{"$f":"E4","v":2471},464,{"$f":"IF(E5>=75,C5*(E5^D5)*E5,F5)","v":996.40526646230285}]
[null,"Health/Medical - Clinic",313.54000000000002,-0.84370000000000001,2471,480,1063.1608216289599]
[null,"Health/Medical - Hospital",730.76,-0.88360000000000005,2471,857,1814.2835158337223]
[null,"Lodging",589.61,-0.875,2471,782,1565.5752027351584]
[null,"Office",657.91,-0.94369999999999998,2471,493,1021.374999128893]
[null,"Retail",404,-0.86450000000000005,2471,493,1164.4359956548894]

{"sheet":"HELP","index":4,"n_rows":71,"n_cols":6,"rows_kept":71,"cut":false,"hidden":false,"merged":[[16,2,16,17],[19,2,19,17],[68,2,68,17],[70,2,70,17],[66,5,66,17],[66,3,66,4],[65,2,65,4],[60,3,60,17],[58,2,58,17],[61,2,61,17],[63,3,63,17],[64,4,64,17],[20,2,20,17],[21,2,21,17],[22,2,22,17],[24,2,24,17],[9,4,9,17],[10,4,10,17],[11,4,11,17],[12,4,12,17],[13,4,13,17],[1,1,2,12],[1,13,2,18],[6,2,6,17],[4,2,5,17],[8,4,8,17],[25,2,25,17],[27,2,27,17],[28,2,28,17],[29,2,29,17],[30,2,30,17],[31,2,31,17],[37,2,37,17],[38,2,38,17],[40,2,40,17],[41,2,41,17],[32,2,32,17],[33,2,33,17],[34,2,34,17],[35,2,35,17],[36,2,36,17],[42,2,42,17],[43,2,43,17],[44,2,44,17],[45,2,45,17],[46,2,46,17],[47,2,47,17],[48,2,48,17],[49,2,49,17],[50,2,50,17],[51,2,51,17],[55,2,55,17],[56,2,56,17],[52,2,52,17],[53,2,53,17],[54,2,54,17]]}
[]
[null,"DCKV Calculator Tool Help"]
[]
[]
[null,null,{"$f":"\"Note:  This Demand Controlled Kitchen Ventilation (DKCV) calculator is provided for the express use of \"&IF(InstallState=\"\",\"Rocky Mountain Power/Pacific Power approved EEA participants only. \",IF(OR(InstallState=\"ID\",InstallState=\"UT\",InstallState=\"WA\"),INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0))&\" approved wattsmart Business vendors only. \",INDEX(Program_Name,MATCH(InstallState,StateAbrev_List,0))&\" approved EEA participants only. \"))&\"Any other use of this DKCV calculator tool is unauthorized unless specifically approved otherwise by \"&IF(InstallState=\"\",\"\",\"the \"&INDEX(Program_Name,MATCH(InstallState,StateAbrev_List,0))&\" Program Administrator or \")&IF(InstallState=\"\",\"Rocky Mountain Power/Pacific Power\",INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)))&\".\"","v":"Note:  This Demand Controlled Kitchen Ventilation (DKCV) calculator is provided for the express use of Rocky Mountain Power/Pacific Power approved EEA participants only. Any other use of this DKCV calculator tool is unauthorized unless specifically approved otherwise by Rocky Mountain Power/Pacific Power."}]
[]
[null,null,"How to Apply for Qualifying DCKV system Incentives"]
[]
[null,null,null,"1.",{"$f":"\"Verify that the facility for the proposed DCKV system is served by \" & IF(InstallState=\"\",\"Rocky Mountain Power/Pacific Power\",INDEX(Lookups!$E$2:$E$6,MATCH(InstallState,Lookups!$D$2:$D$6,0))) & \" under one of the rate schedules eligible as listed in the applicable tariff. (\" & IF(InstallState=\"\",\"\",InstallState &\"-\"& VLOOKUP(InstallState,ApplicableTariff,3,FALSE))&\")\"","v":"Verify that the facility for the proposed DCKV system is served by Rocky Mountain Power/Pacific Power under one of the rate schedules eligible as listed in the applicable tariff. ()"}]
[null,null,null,"2.","Fill out the yellow cells in the DCKV calculator with all the requested information."]
[null,null,null,"3.","If the DCKV system qualifies for incentives, present and explain the estimate to the customer for review/acceptance/installation."]
[null,null,null,"4.","Retain a copy of the DCKV calculator for your files."]
[null,null,null,"5.","Install the qualifying DCKV for the customer."]
[null,null,null,"6.","Create an application by clicking the 'Create Incentive Application' button."]
[null,null,null,"7.","Submitt application by following the instructions found in the application."]
[]
[null,null,"Filling Out the DCKV Calculator Tool"]
[null,null,"Below is guidance for answering the questions required to calculate DCKV incentives"]
[null,"Facility Operations"]
[null,null,"Does the facility serve breakfast?"]
[null,null,"Does the facility serve lunch?"]
[null,null,"Does the facility serve dinner?"]
[null,null,"Answer yes or no to the above questions based on whether that meal is actually served, not based on facility operating hours"]
[]
[null,null,"Is the facility open 24 hrs/day"]
[null,null,"Answer yes if the facility serves food 22 or more hours per day, otherwise no"]
[]
[null,null,"Is the facility open Monday -Friday?"]
[null,null,"Answer yes if the facilty is open 4 or more weekedays, see note below"]
[]
[null,null,"Is the facility open Saturday"]
[null,null,"Answer yes if the facilty is open on Saturday, otherwise no"]
[]
[null,null,"Is the facility open Sunday?"]
[null,null,"Answer yes if the facilty is open on Sunday, otherwise no"]
[null,null,"NOTE:  Select the option that best indicates number of open days per week.\n               ie: For odd situations, such as open Saturday through Wednesday (5 days), input M-F = yes (= 5 days)"]
[]
[null,null,"How many weeks per year is the business closed?"]
[null,null,"Enter the numeric value for number of weeks (rounded to the nearest week) the facility is closed for Holidays, Maintenance, Vactions, etc."]
[null,"Equipment Details"]
[null,null,"What is the total horsepower of all make-up air fan motors that will be retrofitted with new varaible speed drives?"]
[null,null,"Add all the fan motor horsepowers together (if there is more than one make-up air unit).  Do not included fans in roof top units that are for general heating and cooling of the facility."]
[]
[null,null,"What is the total horsepower of exhaust fan motors that will be retrofitted?"]
[null,null,"Add all the fan motor horsepowers together (if there is more than one exhaust hood).  Do not included fans in roof top units that are for general heating and cooling of the facility."]
[]
[null,null,"Do existing fans have variable speed drives? "]
[null,null,"Answer yes if any of the fan motors you inventoried above already have variable frequency drives installed on them, otherwise no."]
[]
[null,null,"Do the fans run continuously during facility open hours? "]
[null,null,"Answer yes if the exhaust systems are typically turned on when the facility opens and turned off when the facility closes. If the exhaust systems are turned on/off as needed during the day, answer no."]
[]
[null,null,"Is MUA heat recovery used? "]
[null,null,"Answer yes if there is a dedicated system for recovering heat from the hood exhaust airstream and transfering it the incoming make-up air stream, otherwise no."]
[]
[null,null,"Is electric heat used for heating make-up air? "]
[null,null,"Enter yes if there is an electric resistance heating coil mounted in the make-up air unit air stream for the purpose of heating outdoor air, otherwise enter no"]
[]
[null,null,"Rate Schedule"]
[]
[null,null,null,{"$f":"\"The rate schedule is required to estimate paybacks.  The correct rate schedule found on the customer's current \" &  IF(InstallState=\"\",\"Rocky Mountain Power/Pacific Power\",INDEX(Lookups!$E$2:$E$6,MATCH(InstallState,Lookups!$D$2:$D$6,0))) & \" bill or call your EEA Coordinator at 1-866-415-9800 and request it.\"","v":"The rate schedule is required to estimate paybacks.  The correct rate schedule found on the customer's current Rocky Mountain Power/Pacific Power bill or call your EEA Coordinator at 1-866-415-9800 and request it."}]
[null,null,"Select Nearest Weather Station"]
[]
[null,null,null,"The closer the weather station to your project location, the more accurate your estimates will be.  A map of the weather stations is available at the link below.  Click the state where the DCKV system is to be installed and hover over the weather station name on the left hand pane to see it's location on the map.  The location is highlighted."]
[null,null,null,null,"http://www.wrcc.dri.edu/summary/"]
[]
[null,null,null,"CAUTION:",null,{"$f":"\"A nearby weather station does not guarantee customer is served by \" & IF(InstallState=\"\",\"Rocky Mountain Power/Pacific Power\",INDEX(Lookups!$E$2:$E$6,MATCH(InstallState,Lookups!$D$2:$D$6,0))) & \".\"","v":"A nearby weather station does not guarantee customer is served by Rocky Mountain Power/Pacific Power."}]
[]
[null,null,"Additional Help"]
[]
[null,null,"Contact your EEA Coordinator at 1-866-415-9800 with any questions you may have."]

{"sheet":"Application","index":5,"n_rows":132,"n_cols":45,"rows_kept":132,"cut":false,"hidden":true,"merged":[[72,5,73,48],[130,5,130,22],[130,24,131,28],[130,30,130,48],[131,5,131,22],[131,30,131,48],[76,33,76,47],[77,33,77,47],[68,6,68,20],[68,22,68,36],[68,38,68,47],[70,5,70,22],[70,24,71,28],[70,30,70,48],[71,5,71,22],[71,30,71,48],[76,5,78,31],[78,33,82,47],[80,7,80,31],[82,7,82,31],[83,33,84,47],[84,7,84,31],[86,7,86,31],[62,5,62,48],[63,5,63,48],[64,5,64,48],[65,5,65,48],[66,5,66,48],[67,5,67,48],[55,5,56,48],[57,5,57,48],[58,5,58,48],[59,5,59,48],[60,5,60,48],[61,5,61,48],[47,6,47,47],[48,9,48,47],[49,9,49,47],[50,9,50,47],[53,5,53,22],[53,24,54,28],[53,30,53,48],[54,5,54,22],[54,30,54,48],[42,5,42,48],[43,6,43,20],[43,22,43,36],[43,38,43,47],[44,6,44,20],[44,22,44,36],[44,38,44,47],[40,5,40,28],[40,29,40,38],[40,39,40,43],[40,44,40,48],[41,5,41,28],[41,29,41,38],[41,39,41,43],[41,44,41,48],[36,5,36,48],[37,5,37,48],[38,5,38,28],[38,29,38,38],[38,39,38,48],[39,5,39,28],[39,29,39,38],[39,39,39,48],[32,5,32,48],[33,7,33,15],[33,17,33,24],[33,26,33,30],[33,32,33,36],[33,38,33,42],[33,44,33,48],[21,5,21,16],[21,17,21,28],[21,29,21,48],[22,5,22,48],[23,5,23,26],[23,27,23,48],[19,5,19,28],[19,29,19,38],[19,39,19,43],[19,44,19,48],[20,5,20,16],[20,17,20,28],[20,29,20,48],[28,5,28,24],[28,25,28,38],[28,39,28,48],[30,5,30,48],[31,5,31,28],[31,29,31,48],[24,5,24,26],[24,27,24,48],[26,5,26,28],[26,29,26,38],[26,39,26,43],[26,44,26,48],[18,5,18,28],[18,29,18,38],[18,39,18,43],[18,44,18,48],[5,32,5,48],[6,32,6,48],[8,5,9,48],[10,5,10,48],[12,5,12,48],[13,5,13,48],[17,5,17,28],[17,29,17,38],[17,39,17,48],[14,5,14,23],[14,25,14,29],[14,32,14,36],[14,39,14,46],[16,5,16,28],[16,29,16,38],[16,39,16,48]]}
[]
[]
[]
[]
[]
[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,{"$f":"INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0)) & \" wattsmart® Business\"","v":{"$error":"#N/A"}}]
[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,{"$f":"INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" Incentive Application/Agreement\"","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,"Submit This Page for Processing"]
[]
[null,null,null,null,null,{"$f":"\"IMPORTANT: Please be sure to send the COMPLETED Application/Agreement (3 pages) along with copies of the required supporting documentation. Equipment must be purchased and installed at a qualifying facility within the state of \" & INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0)) & \" prior to submitting an incentive application (except for custom measures).\" & \" Please allow 6 weeks for incentive processing. Please be sure to follow all eligibility requirements stated in the Incentive Catalogs. Incentives will not be paid for ineligible or incomplete applications. \"","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,"WATTSMART BUSINESS PARTICIPANT INFORMATION"]
[null,null,null,null,null,"(Check will be issued to the business name and address listed below unless the payment release section below has been filled out and signed)"]
[null,null,null,null,null,"wattsmart Business participant is (check all that apply)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CheckBoxLink_AccountHolder=TRUE,\"X\",\"\")","v":""},"Account Holder",null,null,null,null,null,{"$f":"IF(CheckBoxLink_FacilityOwner=TRUE,\"X\",\"\")","v":""},"Facility Owner",null,null,null,null,null,{"$f":"IF(CheckBoxLink_ElectricityUser=TRUE,\"X\",\"\")","v":""},"Electricity user"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"[0]!CheckBoxLink_AccountHolder","v":false},null,null,null,null,null,null,{"$f":"[0]!CheckBoxLink_FacilityOwner","v":false},null,null,null,null,null,null,{"$f":"[0]!CheckBoxLink_ElectricityUser","v":false}]
[null,null,null,null,null,"Participant business name (As shown on income tax return):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact name:",null,null,null,null,null,null,null,null,null,"Contact title:"]
[null,null,null,null,null,{"$f":"CustomerBusinessName","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CustomerContactName","v":0},null,null,null,null,null,null,null,null,null,{"$f":"CustomerContactTitle","v":0}]
[null,null,null,null,null,"Mailing address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,null,null,null,null,{"$f":"CustomerAddress","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CustomerCity","v":0},null,null,null,null,null,null,null,null,null,{"$f":"CustomerState","v":0},null,null,null,null,{"$f":"CustomerZip","v":0}]
[null,null,null,null,null,"Contact telephone number:",null,null,null,null,null,null,null,null,null,null,null,"Contact fax number:",null,null,null,null,null,null,null,null,null,null,null,"Contact email address:"]
[null,null,null,null,null,{"$f":"CustomerContactPhone","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CustomerContactEmail","v":0}]
[null,null,null,null,null,"PROJECT SITE INFORMATION (WHERE EQUIPMENT IS INSTALLED)"]
[null,null,null,null,null,"Facility/Project name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" Account name (as it appears on \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" bill):\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"ProjectName","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AccountName","v":0}]
[null,null,null,null,null,"Facility address (where equipment is installed):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,null,null,null,null,{"$f":"InstallAddress","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InstallCity","v":0},null,null,null,null,null,null,null,null,null,{"$f":"InstallState","v":0},null,null,null,null,{"$f":"InstallZip","v":0}]
[null,null,null,null,null,"Commercial/Industrial electric account number (where equipment is installed)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric meter number (seven or eight digits):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate schedule:"]
[null,null,null,null,null,{"$f":"AccountNumber","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MeterNumber","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RateSchedule","v":0}]
[]
[null,null,null,null,null,"REQUEST FOR TAXPAYER IDENTIFICATION (ENTER FINANSWER EXPRESS PARTICIPANT INFORMATION)"]
[null,null,null,null,null,"wattsmart Business participant Federal taxpayer ID number (EIN) or SS#:"]
[null,null,null,null,null,"Please check the appropriate box:"]
[null,null,null,null,null,null,null,"Individual or Sole Proprietor",null,null,null,null,null,null,null,null,null,"LLC, LLP, or Partnership",null,null,null,null,null,null,null,null,"C Corporation",null,null,null,null,null,"S Corporation",null,null,null,null,null,"Trust/Estate",null,null,null,null,null,"Exempt Payee"]
[]
[]
[null,null,null,null,null,"INCENTIVE RELEASE INFORMATION (THIRD-PARTY INCENTIVE ASSIGNMENT)"]
[null,null,null,null,null,"NOTE: Complete this section only if incentive payment is to be directed to someone other than the wattsmart Business participant as indicated above."]
[null,null,null,null,null,"Check should be made out to the payee below:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact name:",null,null,null,null,null,null,null,null,null,"Contact Phone:"]
[null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeBusinessName)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeContactName)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeContactPhone)","v":0}]
[null,null,null,null,null,"Payee mailing address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeAddress)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeCity)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeState)","v":0},null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeZip)","v":0}]
[null,null,null,null,null,{"$f":"\"I am authorizing this incentive payment to the third party named above and I understand that I will not be receiving the incentive payment check from \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \".  I also understand that my release of payment to the third party does not exempt me from the incentive requirements outlined in the application.\" & \" FinAnswer Express participant may be responsible for the tax reporting to the IRS of any incentive payments directed to third parties.\"","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,"Authorized by (please print name & title)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature of authorized",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[]
[null,null,null,null,null,null,"For more information about the wattsmart Business program, eligibility requirements, incentive levels or other general inquires:"]
[null,null,null,null,null,null,null,null," ▪",{"$f":"\"Visit our website at \" & INDEX(UtilityWebsite_List,MATCH(InstallState,StateAbrev_List,0)) & \" and submit your inquiry online\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null," ▪",{"$f":"\"Email us at \" & INDEX(NLApplicationEmail_List,MATCH(InstallState,StateAbrev_List,0)) & \" or \"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null," ▪",{"$f":"\"Call \" & INDEX(FXHotline_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,{"$f":"\"FinAnswer Express – \" & INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 3",null,null,null,null,null,{"$f":"INDEX(UtilityWebsite_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" NL Incentive Application/ Agreement\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(ApplicationVersionNmber_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Submit This Page for Processing"]
[]
[null,null,null,null,null,"TERMS & CONDITIONS"]
[null,null,null,null,null,{"$f":"\"QUALIFYING PARTICIPANTS:  Eligible participants include commercial and industrial facility owners and electric customers whose facilities are within the state of \" & INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0)) & \" and who purchase their electricity from \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" on one of the following retail general service schedules: \" &  INDEX(RateSchedule_List,MATCH(InstallState,StateAbrev_List,0)) &\".  Participants (other than electrical account holders) are responsible to provide documentation of ownership or of electricity usage at the eligible facility.\" & \" Facility owner is defined as the person who has both legal and beneficial title to the real property, and is the mortgager under a duly recorded mortgage of real property, the trust or under a duly recorded deed of trust.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"ELIGIBLE DATES:  This \" & INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" Incentive Application covers qualifying equipment purchased between January 1, \" & INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" and December 31, \" & INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \".  Incentive applications for \" & INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" installations must be postmarked by January 31, \" & INDEX(YearPlusOne_List,MATCH(InstallState,StateAbrev_List,0)) & \".  Applications received after this date may not be processed.  Equipment must be purchased and installed prior to submitting an incentive application. For \" & INDEX(YearPlusOne_List,MATCH(InstallState,StateAbrev_List,0)) & \" installations, visit our website at \" & INDEX(UtilityWebsite_List,MATCH(InstallState,StateAbrev_List,0)) & \".\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"TAX LIABILITY: Neither \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" nor its Program Administrator is responsible for any tax liability which may be imposed on the Participant as a result of any incentive payment.\" & \" Participant may be responsible for the tax reporting to the IRS of any incentive payments directed to third parties.  Neither \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" nor its Program Administrator is providing tax advice, and any communications to such parties is not intended to be used, and cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"INCENTIVE LIMITATIONS & LIMITATIONS OF DAMAGES: \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" does not warrant the performance of qualifying/installed equipment and does not warrant that the qualifying/installed equipment will deliver any specified amount of energy or cost savings.\" & \" Customer shall independently evaluate the qualifying equipment. In no event will \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" be liable for the failure of the Customer to achieve its expected amount of energy savings, for harm to Customer’s facilities of any kind,\" & \" or for any incidental or consequential damages of any kind in connection with installation of this qualifying equipment.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"TRANSFER OF ENVIRONMENTAL ATTRIBUTES: Customer hereby transfers to \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" all 'Environmental Attributes' attributable to the installation of the qualifying equipment or its operation.\" & \" Environmental Attributes include any and all credits, benefits, emissions reductions, offsets and allowances, howsoever entitled, resulting from the avoidance of the emission of any substance to the air, \" & \" soil or water at or by PacifiCorp generating facilities, through reduced generation of energy or other savings or offsets on account of the qualifying equipment.\" & \" Customer will not claim ownership of any Environmental Attributes.  As long as Customer at the same time states the installation of the qualifying equipment was made possible with funding from \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \", Customer may claim that it is facilitating the production of the Environmental Attributes attributable to the qualifying equipment.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"ADDITIONAL DETAILS: Incentive qualifications and amounts are subject to change and termination at any time and are available per the applicable Tariff Schedule \" & IF(InstallState=\"CA\", \"A-115\", \"115\") & \" available on \"  & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \".net/regulation. Visit the program’s website, review the Incentive Catalogs or contact your local equipment dealer or \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" for current program information. \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" reserves the right to conduct random inspections to verify information provided on the application.  After incentive payment, \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" reserves the right to inspect qualifying equipment, which may include a telephone survey, site visit,\" & \" and/or the installation of temporary monitoring equipment at any time up to 36 months after installation for quality control of the application or program performance evaluations.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":" INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" issues FinAnswer Express incentives in the form of checks, not utility bill credits. \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" is not responsible if your dealer provides inaccurate information about the amount and/or conditions of the actual incentive and \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" will not pay incentives for equipment that is mislabeled or misrepresented by dealers regarding incentive qualifications.\" & \" Qualifying equipment receiving incentives under the FinAnswer Express program may not receive purchase and installation incentives or credits under other \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" programs.  Please allow six weeks for your incentive check to arrive.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"ACCEPTANCE OF TERMS"]
[null,null,null,null,null,{"$f":"\"By my signature below, I hereby certify that all information provided is accurate, including claims of customer and equipment information, and that the equipment associated with this incentive application has been purchased and installed.\" & \" I have read the TERMS & CONDITIONS and agree to be bound by them and agree that \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" may verify all the information provided. My signature below authorizes \" &  INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" to provide my electric account information to contractors associated with the FinAnswer Express program. \"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"CERTIFICATION OF TAXPAYER IDENTIFICATION: Under penalties of perjury, I hereby certify that: 1) The number shown on page 2 of this form is my correct taxpayer identification number, and 2) I am not subject to backup withholding because: (a) I am exempt from backup withholding, or (b) I have not been notified by the Internal Revenue Service (IRS) that I am subject to backup withholding as a result of a failure to report all interest or dividends, or (c) the IRS has notified me that I am no longer subject to backup withholding, and 3) I am a U.S. citizen, resident alien or other U.S. person."]
[]
[null,null,null,null,null,null,"Authorized by (please print name & title)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Signature of authorized",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,{"$f":"\"FinAnswer Express – \" & INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 2 of 3",null,null,null,null,null,{"$f":"INDEX(UtilityWebsite_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" NL Incentive Application/ Agreement\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(ApplicationVersionNmber_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Submit This Page for Processing"]
[]
[]
[]
[null,null,null,null,null,"To apply for FinAnswer Express incentives, complete this application and sent it to the address to the right. Please review and confirm each of the qualifying criteria below, as applicable. For additional information or assistance, please call 1-866-415-9800.",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,"Send completed application by email, mail, or fax to:"]
[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,{"$f":"INDEX(HVACEmail_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[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,{"$f":"\"FinAnswer Express\n\" &\nINDEX(MailAddress1_List,MATCH(InstallState,StateAbrev_List,0)) & \"\n\" &\nINDEX(MailCity_List,MATCH(InstallState,StateAbrev_List,0)) & \", \" & INDEX(MailState,MATCH(InstallState,StateAbrev_List,0)) & \"  \" & INDEX(MailZip_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,"Equipment is installed and operating at the site listed on the general application."]
[]
[null,null,null,null,null,null,null,"The dated sales receipt or invoice is included with labor and material costs itemized."]
[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,{"$f":"INDEX(ApplyToFaxNL_List,MATCH(InstallState,StateAbrev_List,0)) & \" - fax\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Manufacturer’s specification sheet for each installed equipment model is included."]
[]
[null,null,null,null,null,null,null,"Completed application is submitted within six months of project completion."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"\"FinAnswer Express – \" & INDEX(StateName_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page 3 of 3",null,null,null,null,null,{"$f":"INDEX(UtilityWebsite_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"INDEX(Year_List,MATCH(InstallState,StateAbrev_List,0)) & \" NL Incentive Application/ Agreement\"","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(ApplicationVersionNmber_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]

{"sheet":"Application NEW","index":6,"n_rows":109,"n_cols":48,"rows_kept":109,"cut":false,"hidden":true,"merged":[[22,5,22,48],[105,33,106,47],[106,7,106,31],[108,7,108,31],[108,33,109,47],[94,5,94,24],[95,5,95,24],[96,5,96,24],[98,5,100,31],[98,33,98,47],[99,33,99,47],[100,33,104,47],[102,7,102,31],[104,7,104,31],[86,7,86,25],[87,7,87,25],[88,5,88,25],[89,5,91,25],[90,28,90,48],[91,28,93,48],[92,5,92,25],[93,5,93,25],[78,6,79,6],[78,7,79,25],[79,28,83,48],[80,7,80,25],[81,5,81,25],[82,7,82,25],[83,6,84,6],[83,7,84,25],[84,28,89,48],[85,7,85,25],[74,5,74,25],[75,7,75,25],[76,7,76,25],[77,7,77,25],[62,6,62,20],[62,22,62,36],[62,38,62,47],[65,5,65,48],[67,5,67,25],[67,28,78,48],[68,5,68,25],[69,7,69,25],[70,7,70,25],[71,7,71,25],[72,7,73,25],[56,5,56,28],[56,29,56,48],[58,5,58,48],[59,5,59,48],[60,5,60,48],[61,6,61,20],[61,22,61,36],[61,38,61,47],[54,5,54,28],[54,29,54,38],[54,39,54,43],[54,44,54,48],[55,5,55,28],[55,29,55,48],[51,5,51,48],[52,5,52,48],[53,5,53,28],[53,29,53,38],[53,39,53,43],[53,44,53,48],[40,20,47,47],[41,7,41,18],[43,7,43,18],[45,7,45,18],[47,7,47,18],[50,5,50,48],[35,5,36,15],[35,16,36,28],[35,29,35,48],[36,29,36,48],[37,5,37,48],[39,7,39,18],[39,20,39,47],[32,5,32,28],[32,29,32,38],[32,39,32,43],[32,44,32,48],[33,5,34,15],[33,16,34,38],[33,39,34,43],[33,44,34,48],[28,5,28,48],[29,5,29,48],[30,5,30,48],[31,5,31,28],[31,29,31,38],[31,39,31,43],[31,44,31,48],[23,5,23,30],[23,31,23,48],[24,5,24,48],[25,7,25,15],[25,17,25,24],[25,26,25,30],[25,32,25,36],[25,38,25,42],[25,44,25,48],[18,5,18,28],[18,29,18,48],[19,5,19,16],[19,17,19,27],[19,29,19,48],[20,5,20,16],[20,17,20,28],[20,29,20,48],[16,5,16,28],[16,29,16,38],[16,39,16,43],[16,44,16,48],[17,5,17,28],[17,29,17,48],[9,5,9,48],[10,5,10,48],[11,5,11,17],[13,5,13,48],[14,5,14,48],[15,5,15,28],[15,29,15,38],[15,39,15,43],[15,44,15,48]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"General Application"]
[]
[]
[]
[null,null,null,null,null,"PARTICIPANT INFORMATION"]
[null,null,null,null,null,"(Check will be issued to the business name and address listed below unless the payment release section below has been filled out)"]
[null,null,null,null,null,"Participant is (check all that apply)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CheckBoxLink_AccountHolder=TRUE,\"X\",\"\")","v":""},"Customer",null,null,null,null,null,{"$f":"IF(CheckBoxLink_FacilityOwner=TRUE,\"X\",\"\")","v":""},"Facility Owner",null,null,null,null,null,{"$f":"IF(CheckBoxLink_ElectricityUser=TRUE,\"X\",\"\")","v":""},"Tenant/Electricity user"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,false,null,null,null,null,null,null,false]
[null,null,null,null,null,"Participant business name (As shown on income tax return):"]
[null,null,null,null,null,{"$f":"CustomerBusinessName","v":0}]
[null,null,null,null,null,"Mailing address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,null,null,null,null,{"$f":"CustomerAddress","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CustomerCity","v":0},null,null,null,null,null,null,null,null,null,{"$f":"CustomerState","v":0},null,null,null,null,{"$f":"CustomerZip","v":0}]
[null,null,null,null,null,"Contact name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact title:"]
[null,null,null,null,null,{"$f":"CustomerContactName","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CustomerContactTitle","v":0}]
[null,null,null,null,null,"Contact telephone number:",null,null,null,null,null,null,null,null,null,null,null,"Cell number:",null,null,null,null,null,null,null,null,null,null,false,"Contact email address:"]
[null,null,null,null,null,{"$f":"IF(CheckboxLink_CellPhone=FALSE,CustomerContactPhone,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CheckboxLink_CellPhone=TRUE,CustomerContactPhone,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"CustomerContactEmail","v":0}]
[]
[null,null,null,null,null,"TAXPAYER IDENTIFICATION (Must be complete in order to receive an incentive)"]
[null,null,null,null,null," Participant Federal taxpayer ID number (EIN) or SS#:",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,"Please check the appropriate box:"]
[null,null,null,null,null,null,null,"Individual or Sole Proprietor",null,null,null,null,null,null,null,null,null,"LLC, LLP, or Partnership",null,null,null,null,null,null,null,null,"C Corporation",null,null,null,null,null,"S Corporation",null,null,null,null,null,"Trust/Estate",null,null,null,null,null,"Exempt Payee"]
[]
[]
[null,null,null,null,null,"PROJECT SITE INFORMATION"]
[null,null,null,null,null,"Facility/Project name:"]
[null,null,null,null,null,{"$f":"ProjectName","v":0}]
[null,null,null,null,null,"Facility address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,null,null,null,null,{"$f":"InstallAddress","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"InstallCity","v":0},null,null,null,null,null,null,null,null,null,{"$f":"InstallState","v":0},null,null,null,null,{"$f":"InstallZip","v":0}]
[null,null,null,null,null,"Commercial/Industrial electric account #:",null,null,null,null,null,null,null,null,null,null,{"$f":"AccountNumber","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate Schedule:",null,null,null,null,{"$f":"RateSchedule","v":0}]
[]
[null,null,null,null,null,"Electric meter number – seven or eight digits: (If multiple meters at site only enter one)",null,null,null,null,null,null,null,null,null,null,{"$f":"MeterNumber","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Customer name: (As shown on bill)"]
[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,{"$f":"AccountName","v":0}]
[null,null,null,null,null,"Please provide a description of your project so we may better help you: "]
[]
[null,null,null,null,null,null,null,"Lighting Retrofit",null,null,null,null,null,null,null,null,null,null,null,null,"Additional project information: (scope and schedule)"]
[]
[null,null,null,null,null,null,"X","Listed Equipment Incentives"]
[]
[null,null,null,null,null,null,{"$f":"IF(OR(ProjectType=\"New Construction\",ProjectType=\"Major Renovation\"),\"X\",\"\")","v":""},"New Construction"]
[]
[null,null,null,null,null,null,null,"Custom or Energy Management Incentives"]
[]
[null,null,null,null,null,null,null,"Other:________________________________"]
[]
[]
[null,null,null,null,null,"INCENTIVE ASSIGNMENT (Complete only if incentive is to be assigned to someone other than participant above)"]
[null,null,null,null,null,"Check should be made out to:"]
[null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeBusinessName)","v":0}]
[null,null,null,null,null,"Mailing address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City:",null,null,null,null,null,null,null,null,null,"State:",null,null,null,null,"Zip:"]
[null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeAddress)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeCity)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeState)","v":0},null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeZip)","v":0}]
[null,null,null,null,null,"Contact name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact telephone:"]
[null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeContactName)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(IncentivePayeeSelector=\"Participant Business Address\",IncentivePayeeSelector=\"Project Address\"),\"n/a\",PayeeContactPhone)","v":0}]
[]
[null,null,null,null,null,"APPLICATION ACKNOWLEDGEMENT"]
[null,null,null,null,null,{"$f":"\"By my signature below, I certify that all information provided for participation will be accurate including but not limited to supplemental material and claims of \" & \"participant and equipment information. I confirm I have read, understand and agree with the TERMS AND CONDITIONS and agree to be bound by them. I authorize \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" to provide my electric account information to consultants associated with the wattsmart Business program.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"                                                                            Under penalties of perjury, I certify that: 1) The taxpayer identification number is correct, and 2) I am not subject to backup withholding due to failure to report interest and dividend income, and 3) I am a U.S. citizen, resident alien or other U.S. person. The Internal Revenue Service does not require your consent to any provision of this document other than the certifications required to avoid backup withholding."]
[]
[null,null,null,null,null,null,"Signatory name & title (please print)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Participant signature",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,{"$f":"\"Effective \" & VLOOKUP(InstallState,'Tariffs and Rates'!#REF!,7,FALSE) & \"    v12/23/2013\"","v":{"$error":"#REF!"}},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,"wattsmart is registered in U.S. Patent and Trademark Office."]
[]
[null,null,null,null,null,"TERMS & CONDITIONS"]
[]
[null,null,null,null,null,"How to participate:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" does not warrant the performance of qualifying installed equipment/energy management measures and does not warrant that the qualifying installed equipment/energy management measures will deliver any specified amount of energy or cost savings. \" & \"Participant shall independently evaluate any advice or direction given by \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" or its consultants related to the estimates of electricity savings or the cost, selection or installation of qualifying equipment/energy management measures. \" & \"In no event will \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" or its consultants be liable for the failure of the participant to achieve its expected amount of energy savings, for any personal injury or harm to participant’s facilities of any kind, \" & \"or for any incidental or consequential damages of any kind including hazardous material identification in connection with installation or inspection of qualifying equipment and energy management measures. \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" is not responsible if a third party provides inaccurate information about the amount and/or conditions of the actual incentive and \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" will not pay incentives for equipment that is mislabeled or misrepresented by third parties regarding incentive qualifications.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Typical incentives:"]
[null,null,null,null,null,null,"1.","Pre-qualification is recommended but not required."]
[null,null,null,null,null,null,"2.","Purchase and install qualifying equipment."]
[null,null,null,null,null,null,"3.","Complete general application and technology-specific supplemental equipment form(s)."]
[null,null,null,null,null,null,"4.","Submit application and all required supplemental forms as directed on supplemental form(s)."]
[]
[null,null,null,null,null,"Lighting retrofit incentives: "]
[null,null,null,null,null,null,"1.","Pre-qualification is required prior to equipment purchase. Submit general application to your assigned Project Manager or one of our wattsmart Business vendors."]
[null,null,null,null,null,null,"2.","Participate in inspections prior to the installation or removal of any equipment."]
[null,null,null,null,null,null,"3.","Incentive offer will be provided to eligible participants. \nReturn signed incentive offer."]
[null,null,null,null,null,null,"4.","Complete project and notify your assigned Project Manager or wattsmart Vendor."]
[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,{"$f":"\"                             \" & \"The incentive offer is an estimate. The final incentive will be based on actual electric savings and approved actual project costs incurred by the participant for implemented approved energy efficiency measures. \" & \"Participant agrees to provide any reasonable documentation to allow \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" to determine electric savings and actual costs incurred. To the extent that \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" determines (at its sole discretion) that any of the recommended measures have not been installed and commissioned in a satisfactory manner, \" & \"participant shall receive a reduced incentive, if any, based on the inspection and verification of installed and commissioned measures.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"5.","Provide all required documentation and participate in any required inspections."]
[null,null,null,null,null,"Custom and energy management incentives: "]
[null,null,null,null,null,null,"1.","Pre-qualification is required prior to equipment purchase/project implementation. Submit general application."]
[null,null,null,null,null,null,"2.","Participate in project scoping meeting(s), inspections and engineering analysis(s) prior to installation or removal of equipment. Provide additional supplemental applications or information as needed."]
[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,{"$f":"\"                                                                       \" & \"Participant hereby transfers to \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" all \"\"Environmental Attributes\"\" attributable to the installation of the qualifying equipment or its operation. \" & \"Environmental Attributes include any and all credits, benefits, emissions reductions, offsets and allowances, howsoever entitled, resulting from the avoidance of the emission of any substance to the air, \" & \"soil or water at or by the company’s generating facilities, through reduced generation of energy or other savings or offsets on account of the qualifying equipment.  \" & \"Participant will not claim ownership of any Environmental Attributes.  \" & \"As long as participant at the same time states the installation of the qualifying equipment was made possible with funding from \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \", participant may claim that it is facilitating the production of the Environmental Attributes attributable to the qualifying equipment.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"3.","Incentive offer(s) will be provided to eligible participants. Return signed incentive offer."]
[null,null,null,null,null,null,"4.","Complete project and provide completion notification to your assigned Project Manager."]
[null,null,null,null,null,null,"5.","Provide all required documentation and participate in any required inspections."]
[null,null,null,null,null,{"$f":"\"                                                                     \" & \"In the event that \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" does not pay the incentive as a result of the participant’s failure to comply with the terms and conditions, the assignee’s sole recourse shall be against participant.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"                                               \" & \"Participant agrees to cooperate with \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" and its consultants to conduct energy analysis and inspections at the participant's site. \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" reserves the right to inspect qualifying equipment/energy management measures, which may include a telephone survey, site visit, \" & \"and/or the installation of temporary monitoring equipment at any time up to 36 months after installation for quality control or program performance evaluations.\"","v":{"$error":"#N/A"}}]
[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,{"$f":"\"                                   \" & \"Incentive qualifications and amounts are subject to change and termination. \" & \"Visit the program’s website or contact a wattsmart Business vendor or \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" for current program information.\"","v":{"$error":"#N/A"}}]
[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,{"$f":"\"                                                \" & \"Confidential information provided to \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" or consultants shall not be disclosed to any third party. Confidential information shall mean data disclosed during the course of the energy analysis, \" & \"and identified by the participant in writing as confidential. The obligation to protect confidential information will remain in force for two (2) years from the date the energy analysis is performed.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"                         \" & \"Neither \" & INDEX(UtilityName_List,MATCH(InstallState,StateAbrev_List,0)) & \" nor its Program Administrator is providing tax advice or responsible for any tax liability which may be imposed on the participant as a result of any incentive payment. \" & \"Participant may be responsible for the tax reporting to the IRS of any incentive payments directed to third parties.\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,{"$f":"\"                                                                                        \" & \"Participants may not receive custom incentives in lieu of typical (listed) incentives. \" & \"Participants are responsible for ensuring that equipment installed for this program meets all applicable codes, standards, environmental regulations and regulatory requirements.\"","v":"                                                                                        Participants may not receive custom incentives in lieu of typical (listed) incentives. Participants are responsible for ensuring that equipment installed for this program meets all applicable codes, standards, environmental regulations and regulatory requirements."}]
[]
[null,null,null,null,null,"Application Supplemental"]
[null,null,null,null,null,"Demand Control Kitchen Ventilation"]
[]
[null,null,null,null,null,"To apply for wattsmart Business incentives, complete this application supplement and send it with the general incentive application to the address to the right. Please review and confirm each of the qualifying criteria below, as applicable.",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,"Send completed application by email, mail, or fax to:"]
[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,{"$f":"INDEX(HVACEmail_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[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,{"$f":"\"wattsmart Business\n\" &\nINDEX(MailAddress1_List,MATCH(InstallState,StateAbrev_List,0)) & \"\n\" &\nINDEX(MailCity_List,MATCH(InstallState,StateAbrev_List,0)) & \", \" & INDEX(MailState,MATCH(InstallState,StateAbrev_List,0)) & \"  \" & INDEX(MailZip_List,MATCH(InstallState,StateAbrev_List,0))","v":{"$error":"#N/A"}}]
[]
[null,null,null,null,null,null,null,"Equipment is installed and operating at the site listed on the general application."]
[]
[null,null,null,null,null,null,null,"The dated sales receipt or invoice is included with labor and material costs itemized."]
[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,{"$f":"INDEX(ApplyToFaxNL_List,MATCH(InstallState,StateAbrev_List,0)) & \" - fax\"","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"Manufacturer’s specification sheet for each installed equipment model is included."]
[]
[null,null,null,null,null,null,null,"Completed application is submitted within six months of project completion.",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,"For additional information or assistance,\nplease call 1-866-415-9800"]

{"sheet":"Lookups","index":7,"n_rows":75,"n_cols":88,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["Year","YearPlusOne","StateName","StateAbrev","UtilityName","UtilityWebsite","AllianceWebsite","UtilityHotline","FXHotline","UtilityEmail","UtilityFax","VersionNmbr","ApplicationVersionNmber","EffectiveDate","CustInct","CustCap","HVACEmail","MotorsEmail","FoodServiceEmail","IrrigationEmail","BldgEnvEmail","LightingEmail","CompAirEmail","FarmDairyEmail","OtherEmail","NLApplicationEmail","RateSchedule","MailAddress1","MailAddress2","MailCity","MailState","MailZip","States","OtherUtilityName","State1","State2","State3","State1Abb","State2Abb","State3Abb","ST1_RT_Schedule","ST2_RT_Schedule","ST3_RT_Schedule","ST1_CRD Name","ST1_CRD Info","ST1_CRD Number","ST1_CRD Email","ST2_CRD Name","ST2_CRD Number","ST2_CRD Info","ST2_CRD Email","ST3_CRD Name","ST3_CRD Number","ST3_CRD Info","ST3_CRD Email","Costpercentage","Purchase Directions","Purchase Directions","NC/MR Pre Purchase Directions","Letter of intent Note","Retrofit Directions","IA Retrofit Directions","Other Utility Directions","St1RetroLightingProcess","St1NCMRLightingProcess","St1NonlightProcess","St1CustomProcess","St2RetroLightingProcess","St2NCMRLightingProcess","St2NonlightProcess","St2CustomProcess","St3RetroLightingProcess","St3NCMRLightingProcess","St3NonlightProcess","St3CustomProcess","HESWebsite","ST1FinAnswerWebsite","ST2FinAnswerWebsite","ST3FinAnswerWebsite","BSTWebsite","EmailSuffix","EnergyCodeBaseline","CodeEffDate","AbbreviatedCode","Tariff #","ApplyToFaxNL","ApplyToFaxLtg","Program name"]
[2014,{"$f":"A2+1","v":2015},"Utah","UT","Rocky Mountain Power","wattsmart.com","rockymountainpower.net/alliance","1-800-222-4335","1-866-415-9800","energy.expert@rockymountainpower.net","801-233-0883","V 11/14/12","V 07/01/13","2013-07-01",0.1,50,"ut.hvacr@rockymountainpower.net","ut.motors@rockymountainpower.net","ut.foodservice@rockymountainpower.net","ut.irrigation@rockymountainpower.net","ut.bldgenvelope@rockymountainpower.net","ut.lighting@rockymountainpower.net","ut.compair@rockymountainpower.net","ut.farmdairy@rockymountainpower.net","ut.othertech@rockymountainpower.net","ut.finanswerexpress@rockymountainpower.net","6, 6A, 6B, 8, 9, 9A, 10, 12, 15, 21, 23, Supplementary service under Schedule 31","2223 S Highland Drive #E6-333",null,"Salt Lake City","UT",84106,"Utah, Wyoming and Idaho","Pacific Power","Utah","Wyoming","Idaho","UT","WY","ID","6, 6A, 6B, 8, 9, 9A, 10, 12, 15, 21, 23, Supplementary service under Schedule 31","25, 28, 33, 40, 46, 48, 54, 58, 210, 212, 213","6, 6A, 8, 9, 12, 19, 23, 23A, 24, 35, 35A","Mark Clary",null,"801.233.0882","ut.lighting@rockymountainpower.net","Jim Soukup","307.235.0438",null,"wy.lighting@rockymountainpower.net","William Gatchel","541.727.5386",null,"id.lighting@rockymountainpower.net",50,"Lighting retrofits must have a signed incentive agreement prior to purchase of equipment",null,null,null,null,null,null,"Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","www.homeenergysavings.net","www.rockymountainpower.net/bus/se/epi/utah/ilc/ef.html","www.rockymountainpower.net/bus/se/epi/wyoming/ilc/ef.html","www.rockymountainpower.net/bus/se/epi/idaho/ilc/ef.html","www.rockymountainpower.net/bus/bst.html","@rockymountainpower.net","International Energy Conservation Code 2009","2010-07-01","IECC 2009",140,"1-801-266-4786","1-801-233-0883","wattsmart Business"]
[2014,{"$f":"A3+1","v":2015},"Wyoming","WY","Rocky Mountain Power","rockymountainpower.net/wattsmart","rockymountainpower.net/alliance","1-800-222-4335","1-866-415-9800","energy.expert@rockymountainpower.net","307-333-4952","V 10/01/11","V 01/01/13","2011-10-01",0.1,70,"wy.hvacr@rockymountainpower.net","wy.motors@rockymountainpower.net","wy.foodservice@rockymountainpower.net","wy.irrigation@rockymountainpower.net","wy.bldgenvelope@rockymountainpower.net","wy.lighting@rockymountainpower.net","wy.compair@rockymountainpower.net","wy.farmdairy@rockymountainpower.net","wy.othertech@rockymountainpower.net","wy.finanswerexpress@rockymountainpower.net","25, 28, 33, 40, 46, 48T, 54, 58, 210, 212, 213","2223 S Highland Drive #E6-333",null,"Salt Lake City","UT",84106,"Utah, Wyoming and Idaho","Pacific Power","Utah","Wyoming","Idaho","UT","WY","ID","6, 6A, 6B, 8, 9, 9A, 10, 12, 15, 21, 23, Supplementary service under Schedule 31","25, 28, 33, 40, 46, 48, 54, 58, 210, 212, 213","6, 6A, 8, 9, 12, 19, 23, 23A, 24, 35, 35A","Mark Clary",null,"801.233.0882","ut.lighting@rockymountainpower.net","Jim Soukup","307.235.0438",null,"wy.lighting@rockymountainpower.net","William Gatchel","541.727.5386",null,"id.lighting@rockymountainpower.net",50,null,null,null,null,null,null,null,"Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","www.homeenergysavings.net","www.rockymountainpower.net/bus/se/epi/utah/ilc/ef.html","www.rockymountainpower.net/bus/se/epi/wyoming/ilc/ef.html","www.rockymountainpower.net/bus/se/epi/idaho/ilc/ef.html","www.rockymountainpower.net/bus/bst.html","@rockymountainpower.net","International Energy Conservation Code 2009","December 1, 2014 (as determined by Rocky Mountain Power)","IECC 2009",140,"1-801-266-4787","1-541-376-8446","wattsmart Business"]
[2014,2015,"Idaho","ID","Rocky Mountain Power","rockymountainpower.net/wattsmart","rockymountainpower.net/alliance","1-800-222-4335","1-866-415-9800","energy.expert@rockymountainpower.net","541-376-8446","V 07/14/12","V 01/01/13","2012-07-14",0.1,50,"id.hvacr@rockymountainpower.net","id.motors@rockymountainpower.net","id.foodservice@rockymountainpower.net","id.irrigation@rockymountainpower.net","id.bldgenvelope@rockymountainpower.net","id.lighting@rockymountainpower.net","id.compair@rockymountainpower.net","id.farmdairy@rockymountainpower.net","id.othertech@rockymountainpower.net","id.finanswerexpress@rockymountainpower.net","6, 6A, 7, 7A, 9, 12, 19, 23, 23A, 24, 35, 35A","2223 S Highland Drive #E6-333",null,"Salt Lake City","UT",84106,"Utah, Wyoming and Idaho","Pacific Power","Utah","Wyoming","Idaho","UT","WY","ID","6, 6A, 6B, 8, 9, 9A, 10, 12, 15, 21, 23, Supplementary service under Schedule 31","25, 28, 33, 40, 46, 48, 54, 58, 210, 212, 213","6, 6A, 7, 7A, 9, 12, 19, 23, 23A, 24, 35, 35A","Mark Clary",null,"801.233.0882","ut.lighting@rockymountainpower.net","Jim Soukup","307.235.0438",null,"wy.lighting@rockymountainpower.net","William Gatchel","541.727.5386",null,"id.lighting@rockymountainpower.net",50,null,null,null,null,null,null,null,"Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","www.homeenergysavings.net","www.rockymountainpower.net/bus/se/epi/utah/ilc/ef.html","www.rockymountainpower.net/bus/se/epi/wyoming/ilc/ef.html","www.rockymountainpower.net/bus/se/epi/idaho/ilc/ef.html","www.rockymountainpower.net/bus/bst.html","@rockymountainpower.net","International Energy Conservation Code 2009","2011-01-01","IECC 2009",140,"1-801-266-4788","1-503-482-7447","wattsmart Business"]
[2014,{"$f":"A5+1","v":2015},"California","CA","Pacific Power","pacificpower.net/wattsmart","pacificpower.net/alliance","1-800-222-4335","1-866-415-9800","energy.expert@pacificpower.net","(541) 770-2731","V 01/19/12","V 01/01/13","2012-01-19",0.1,70,"ca.hvacr@pacificpower.net","ca.motors@pacificpower.net","ca.foodservice@pacificpower.net","ca.irrigation@pacificpower.net","ca.bldgenvelope@pacificpower.net","ca.lighting@pacificpower.net","ca.compair@pacificpower.net","ca.farmdairy@pacificpower.net","ca.othertech@pacificpower.net","ca.finanswerexpress@pacificpower.net","A-25, A-32, A-33, A-36, AT-47, AT-48, LS-53, LS-58, OL-42, PA-20","6312 SW Capitol Way #1023",null,"Portland","OR",97239,"California and Washington","Rocky Mountain Power","California","Washington",null,"CA","WA",null,"A-25, A-32, A-33, A-36, AT-47, AT-48, AWH-31, LS-53, LS-58, OL-42, PA-20, PA-40","24, 33, 36, 40, 47T, 48T, 54",null,"Bob Greeley",null,"541.601.8088","ca.lighting@pacificpower.net","Lori Sanders","509.727.0394","- Yakima","wa.lighting@pacificpower.net","William Gatchel","541.377.7943","- Walla Walla","wa.lighting@pacificpower.net",60,"Lighting retrofits in Washington must have a signed incentive agreement prior to purchase of equipment.   Lighting retrofits in California may be done post-purchase, but pre-approval is recommended.",null,"Note that pre-purchase incentive agreements are only required in Washington for retrofit projects. Incentive Agreements and Letters of Intent are NOT required for any projects in California or for any New Construction/Major Renovation projects","Note: Letter of Intent is only required for retrofit projects in California.","For Washington retrofit projects, instruct customer not to purchase equipment until an incentive agreement is executed.","For retrofit projects (except in California), the incentive agreement must be signed BEFORE the customer signs purchase orders or installation contracts for the project.","For information on Rocky Mountain Power customer incentives in Oregon, contact the Energy Trust of Oregon at www.energytrust.org. ","Post-purchase Application","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement",null,null,null,null,"www.homeenergysavings.net","www.pacificpower.net/bus/se/epi/california/ilc/ef.html","www.pacificpower.net/bus/se/epi/washington/ilc/ef.html",null,"www.pacificpower.net/bus/bst/index.html","@pacificpower.net","2008 Building Efficiency Standards","2010-01-01","Title 24 2008","A-115","1-503-482-7447","1-503-482-7447","FinAnswer Express"]
[2014,{"$f":"A6+1","v":2015},"Washington","WA","Pacific Power","bewattsmart.com","pacificpower.net/alliance","1-800-222-4335","1-866-415-9800","energy.expert@pacificpower.net","(541) 376-8446","V 01/01/14","V 01/01/14","2014-01-01",0.1,70,"wa.hvacr@pacificpower.net","wa.motors@pacificpower.net","wa.foodservice@pacificpower.net",null,"wa.bldgenvelope@pacificpower.net","wa.lighting@pacificpower.net","wa.compair@pacificpower.net","wa.farmdairy@pacificpower.net","wa.othertech@pacificpower.net","wa.finanswerexpress@pacificpower.net","24, 33, 36, 40, 47T, 48T, 53, 54","6312 SW Capitol Way #1023",null,"Portland","OR",97239,"California and Washington","Rocky Mountain Power","California","Washington",null,"CA","WA",null,"A-25, A-32, A-33, A-36, AT-47, AT-48, AWH-31, LS-53, LS-58, OL-42, PA-20, PA-40","24, 33, 36, 40, 47T, 48T, 54",null,"Bob Greeley",null,"541.601.8088","ca.lighting@pacificpower.net","Lori Sanders","509.727.0394","- Yakima","wa.lighting@pacificpower.net","William Gatchel","541.377.7943","- Walla Walla","wa.lighting@pacificpower.net",60,null,null,null,null,null,null,null,"Post-purchase Application","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement","Pre-purchase Agreement","Post-purchase Application","Post-purchase Application","Pre-purchase Agreement",null,null,null,null,"www.homeenergysavings.net","www.pacificpower.net/bus/se/epi/california/ilc/ef.html","www.pacificpower.net/bus/se/epi/washington/ilc/ef.html",null,"www.pacificpower.net/bus/bst/index.html","@pacificpower.net","Washington State Energy Code 2012","2013-07-01","WSEC 2012",140,"1-503-482-7447","1-503-482-7447","wattsmart Business"]
[]
[]
[]
[]
[]
["Business Type List",null,"Install States",null,"Rate Schedules","Rate Schedules(truncated)",null,"Incentive Recipient List"]
["Agriculture - Dairy",null,"CA",null,{"$f":"IF('Tariffs and Rates'!D10=\"\",\"\",'Tariffs and Rates'!D10)","v":"WY 212"},{"$f":"RIGHT(E13,LEN(E13)-3)","v":"212"}]
["Agriculture - Livestock",null,"ID",null,{"$f":"IF('Tariffs and Rates'!D11=\"\",\"\",'Tariffs and Rates'!D11)","v":"WY 210"},{"$f":"RIGHT(E14,LEN(E14)-3)","v":"210"},null,"Project Address"]
["Agriculture - Poultry",null,"UT",null,{"$f":"IF('Tariffs and Rates'!D12=\"\",\"\",'Tariffs and Rates'!D12)","v":"WY 58"},"58",null,"Participant Business Address"]
["Agriculture - Sod",null,"WA",null,{"$f":"IF('Tariffs and Rates'!D13=\"\",\"\",'Tariffs and Rates'!D13)","v":"WY 54"},"54",null,"Other 3rd Party (enter below)"]
["Apartment",null,"WY",null,{"$f":"IF('Tariffs and Rates'!D14=\"\",\"\",'Tariffs and Rates'!D14)","v":"WY 48T"},"48T"]
["Auditorium",null,null,null,{"$f":"IF('Tariffs and Rates'!D15=\"\",\"\",'Tariffs and Rates'!D15)","v":"WY 46"},"46"]
["Auto Repair",null,null,null,{"$f":"IF('Tariffs and Rates'!D16=\"\",\"\",'Tariffs and Rates'!D16)","v":"WY 40"},"40"]
["Automotive facility",null,null,null,{"$f":"IF('Tariffs and Rates'!D17=\"\",\"\",'Tariffs and Rates'!D17)","v":"WY 33"},"33"]
["Common areas, corridors, restrooms, elevators, lobbies",null,null,null,{"$f":"IF('Tariffs and Rates'!D18=\"\",\"\",'Tariffs and Rates'!D18)","v":"WY 28"},"28"]
["Condominium",null,null,null,{"$f":"IF('Tariffs and Rates'!D19=\"\",\"\",'Tariffs and Rates'!D19)","v":"WY 25"},"25"]
["Convenience store",null,null,null,{"$f":"IF('Tariffs and Rates'!D20=\"\",\"\",'Tariffs and Rates'!D20)","v":"WA 48T"},"48T",null,"Facility Type","Note: These facillity types were taken from DCKV Calclulator Tool 3.2 and are used for Equipment Information: Facility Type on the DCKV-Tool Tab"]
["Convention Center",null,null,null,{"$f":"IF('Tariffs and Rates'!D21=\"\",\"\",'Tariffs and Rates'!D21)","v":"WA 40"},"40",null,"Education - Community College"]
["Courthouse",null,null,null,{"$f":"IF('Tariffs and Rates'!D22=\"\",\"\",'Tariffs and Rates'!D22)","v":"WA 36"},"36",null,"Education - Secondary School"]
["Data Center",null,null,null,{"$f":"IF('Tariffs and Rates'!D23=\"\",\"\",'Tariffs and Rates'!D23)","v":"WA 24"},"24",null,"Education - University"]
["Dining - Bar Lounge / Leisure",null,null,null,{"$f":"IF('Tariffs and Rates'!D24=\"\",\"\",'Tariffs and Rates'!D24)","v":"UT 23"},"23",null,"Health/Medical - Clinic"]
["Dining - Cafeteria / Fast Food",null,null,null,{"$f":"IF('Tariffs and Rates'!D25=\"\",\"\",'Tariffs and Rates'!D25)","v":"UT 10"},"10",null,"Health/Medical - Hospital"]
["Dining - Restaurant",null,null,null,{"$f":"IF('Tariffs and Rates'!D26=\"\",\"\",'Tariffs and Rates'!D26)","v":"UT 9"},"9",null,"Lodging/Hospitality"]
["Dormitory",null,null,null,{"$f":"IF('Tariffs and Rates'!D27=\"\",\"\",'Tariffs and Rates'!D27)","v":"UT 9A"},"9A",null,"Office"]
["Duplex",null,null,null,{"$f":"IF('Tariffs and Rates'!D28=\"\",\"\",'Tariffs and Rates'!D28)","v":"UT 8"},"8",null,"Restaurant/Retail"]
["Exercise Center/Gymnasium",null,null,null,{"$f":"IF('Tariffs and Rates'!D29=\"\",\"\",'Tariffs and Rates'!D29)","v":"UT 6"},"6"]
["Financial Institution",null,null,null,{"$f":"IF('Tariffs and Rates'!D30=\"\",\"\",'Tariffs and Rates'!D30)","v":"OR 48"},"48"]
["General commercial/industrial work buildings",null,null,null,{"$f":"IF('Tariffs and Rates'!D31=\"\",\"\",'Tariffs and Rates'!D31)","v":"OR 30"},"30"]
["Grocery Stores",null,null,null,{"$f":"IF('Tariffs and Rates'!D32=\"\",\"\",'Tariffs and Rates'!D32)","v":"OR 28"},"28"]
["Healthcare - Hospital",null,null,null,{"$f":"IF('Tariffs and Rates'!D33=\"\",\"\",'Tariffs and Rates'!D33)","v":"ID 35"},"35"]
["Healthcare - Medical buildings and clinics",null,null,null,{"$f":"IF('Tariffs and Rates'!D34=\"\",\"\",'Tariffs and Rates'!D34)","v":"ID 23"},"23"]
["Healthcare - Nursing homes",null,null,null,{"$f":"IF('Tariffs and Rates'!D35=\"\",\"\",'Tariffs and Rates'!D35)","v":"ID 10"},"10"]
["Healthcare - other",null,null,null,{"$f":"IF('Tariffs and Rates'!D36=\"\",\"\",'Tariffs and Rates'!D36)","v":"ID 9"},"9"]
["Hotel banquet/conference/exhibition hall",null,null,null,{"$f":"IF('Tariffs and Rates'!D37=\"\",\"\",'Tariffs and Rates'!D37)","v":"ID 6"},"6"]
["Hotel/motel",null,null,null,{"$f":"IF('Tariffs and Rates'!D38=\"\",\"\",'Tariffs and Rates'!D38)","v":"ID 6A"},"6A"]
["Industrial",null,null,null,"CA 48",{"$f":"RIGHT(E42,LEN(E42)-3)","v":"48"}]
["Irrigation",null,null,null,"CA 36",{"$f":"RIGHT(E43,LEN(E43)-3)","v":"36"}]
["Laboratory spaces",null,null,null,"CA 32","32"]
["Laboratory/Scientific",null,null,null,"CA 25","25"]
["Laundries",null,null,null,"CA PA20","PA20"]
["Library"]
["Mall"]
["Manufactured Home"]
["Manufacturing Facility"]
["Mixed use"]
["Mobile Home"]
["Multi-Family"]
["Museum/exhibit"]
["Office building, office/administrative areas"]
["Other"]
["Parking Garage"]
["Penitentiary"]
["Police/Fire Station"]
["Post Office"]
["Recreation"]
["Religious Building"]
["Retail/wholesale store"]
["School"]
["School - University"]
["School preK-12 - buildings/classrooms/daycare centers"]
["Service"]
["Single Dwelling"]
["Sports Arena"]
["Theater - motion picture"]
["Theater - performing arts"]
["Town Hall"]
["Transportation"]
["Tree fruit storage"]
["Warehouse - storage areas"]

{"sheet":"Tariffs and Rates","index":8,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":true,"merged":[[2,10,4,12],[14,7,14,8],[7,0,7,2],[0,0,6,2],[0,3,3,5],[9,6,45,6],[0,6,8,6],[4,3,5,5],[6,3,8,3],[6,4,6,5]]}
["Rate Lookups",null,null,"Simplified Rate Table"]
[]
[null,null,null,null,null,null,null,null,null,null,"Tariff Tables"]
[]
[null,null,null,"\nAverage Secondary except where noted\n"]
[null,null,null,null,null,null,null,null,null,null,"State","Effective Date","Tariff"]
[null,null,null,"State","Cost",null,null,null,null,null,"CA","May 1, 2015","A-140"]
["Selected",null,null,null,{"$f":"IF(OR($B$9=0,$C$9=0),\"Enter State and Rate Schedule Into Yellow Cells Above\",VLOOKUP($B$9&\" \"&$C$9,$D$10:$F$43,2,0))","v":"Enter State and Rate Schedule Into Yellow Cells Above"},{"$f":"IF(OR($B$9=0,$C$9=0),\"Enter State and Rate Schedule Into Yellow Cells Above\",VLOOKUP($B$9&\" \"&$C$9,$D$10:$F$46,3,0))","v":"Enter State and Rate Schedule Into Yellow Cells Above"},null,"Updated 05/22/2015",null,null,"ID","April 15, 2016",140]
[null,{"$f":"InstallState","v":0},{"$f":"RateSchedule","v":0},null,"kWh","Demand",null,"Rates Effective as of:",null,null,"UT","March 10, 2016",140]
[1,{"$f":"IF(ISERROR(MID(VLOOKUP(LARGE($C$10:$C$46,A10),$C$10:$D$46,2,),4,5)),\"\",MID(VLOOKUP(LARGE($C$10:$C$46,A10),$C$10:$D$46,2,),4,5))","v":""},{"$f":"IF(LEFT(D10,2)=$B$9,A10,\"\")","v":""},"WY 212",6.6309999999999994E-2,null,"Update Rates Here","CA","2015-08-26",null,"WA","July 11, 2016",140]
[2,{"$f":"IF(ISERROR(MID(VLOOKUP(LARGE($C$10:$C$46,A11),$C$10:$D$46,2,),4,5)),\"\",MID(VLOOKUP(LARGE($C$10:$C$46,A11),$C$10:$D$46,2,),4,5))","v":""},{"$f":"IF(LEFT(D11,2)=$B$9,A11,\"\")","v":""},"WY 210",3.2439999999999997E-2,15.964,null,"ID","2016-04-01",null,"WY","January 1, 2016",140]
[3,"","","WY 58",6.3240000000000005E-2,null,null,"UT","2016-06-01"]
[4,"","","WY 54",6.9940000000000002E-2,null,null,"WA","2016-03-26"]
[5,"","","WY 48T",3.1199999999999999E-2,17.579999999999998,null,"WY","2015-05-15"]
[6,"","","WY 46",3.286E-2,20.440999999999999,null,"Rates for Software 1-1-2016"]
[7,"","","WY 40",5.2060000000000002E-2,7.8250000000000002]
[8,"","","WY 33",3.1620000000000002E-2]
[9,"","","WY 28",3.6760000000000001E-2,16.923999999999999]
[10,"","","WY 25",7.6499999999999999E-2]
[11,"","","WA 48T",4.9200000000000001E-2,8.875]
[12,"","","WA 40",7.2620000000000004E-2,1.4830000000000001]
[13,"",{"$f":"IF(LEFT(D22,2)=$B$9,A22,\"\")","v":""},"WA 36",5.5079999999999997E-2,6.81]
[14,"","","WA 24",6.5769999999999995E-2,4.6399999999999997]
[15,"","","UT 23",6.7500000000000004E-2,9.2149999999999999]
[16,"","","UT 10",5.7630000000000001E-2,7.7949999999999999]
[17,"","","UT 9",4.367E-2,14.808]
[18,"","","UT 9A",9.2310000000000003E-2]
[19,"","","UT 8",4.8140000000000002E-2,19.181999999999999]
[20,"","","UT 6",3.925E-2,13.573]
[21,"","","OR 48",0,0]
[22,"","","OR 30",0,0]
[23,"","","OR 28",0,0]
[24,"","","ID 35",5.833E-2,16.893999999999998]
[25,"","","ID 23",9.5689999999999997E-2]
[26,"","","ID 10",5.568E-2,6.141]
[27,"","","ID 9",4.7460000000000002E-2,9.2430000000000003]
[28,"","","ID 6",4.5679999999999998E-2,13.438000000000001]
[29,"","","ID 6A",4.5679999999999998E-2,13.438000000000001]
[30,"","","CA 48",9.819E-2,7.15]
[31,"","","CA 36",0.11493,8.51]
[32,"","","CA 32",0.14724000000000001,3.8]
[33,"","","CA 25",0.16464999999999999]
[34,"","","CA PA20",0.13489999999999999,3.9460000000000002]
[35,"","","","",""]
[36,"","","","",""]
[37,"","","","",""]

{"sheet":"Change Log","index":9,"n_rows":411,"n_cols":6,"rows_kept":411,"cut":false,"hidden":true,"merged":[]}
["Date","Change Description","Name","Previous Revision #","New Revision #","Current Revision\n(click to check)"]
["2015-02-27","Creation DCKV tool using Chiller Tool template","Jake DeMann",null,"Beta 022715.1"]
["2016-05-19","Linked Checkboxes to savings tab, adjusted weekly day count formula so that it would work, linked # weeks closed per year to savings tab, added Facility Type and Weather Data tabs to use for drop down arrows in Equipment Information section (DCKV-Tool tab)","Jaedine Stoddard",9.3000000000000007,30.1]
["2016-06-01","updated application population and output code, updated missing info notification code, continued work on linking inputs/outputs to calc sheet, user worksheet formatting, updated tariff information, updated rate information","Troy Williams",{"$f":"IF(A4=\"\",\"\",E3)","v":30.1},{"$f":"IF(A4=\"\",\"\",\"Beta \"&TEXT(A4,\"mmddyy\"))","v":"Beta 060116"}]
["2016-06-03","Corrected cell protection issues causing errors when clicking checkboxes and for other fields with workbook and sheets locked. Fixed rate schedule lookup ranges by state.","Troy Williams","Beta 060116","Beta 060316"]
["2016-06-10","Removed code that removes the formula bar; corrected account number formatting; corrected protection setting on various cells","Troy Williams",{"$f":"IF(A6=\"\",\"\",E5)","v":"Beta 060316"},{"$f":"IF(A6=\"\",\"\",\"Beta \"&TEXT(A6,\"mmddyy\"))","v":"Beta 061016"}]
["2016-11-09","Updated rate schedules, updated Cell L37 in \"calcs\" with electric heating hours formula, Updated numbering and formatting on \"help\" tab.","Jarom Taylor",{"$f":"IF(A7=\"\",\"\",E6)","v":"Beta 061016"},{"$f":"IF(A7=\"\",\"\",\"Beta \"&TEXT(A7,\"mmddyy\"))","v":"Beta 110916"}]
["2017-03-01","Finalization, Facility type changes","Jake DeMann","Beta 110916","030117.1","a"]
[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,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,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,"",""]
[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,null,null,"",""]
[null,null,null,{"$f":"IF(A71=\"\",\"\",E70)","v":""},{"$f":"IF(A71=\"\",\"\",\"Beta \"&TEXT(A71,\"mmddyy\"))","v":""}]
[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,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,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,"",""]
[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,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(A135=\"\",\"\",E134)","v":""},{"$f":"IF(A135=\"\",\"\",\"Beta \"&TEXT(A135,\"mmddyy\"))","v":""}]
[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,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,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,"",""]
[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,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(A199=\"\",\"\",E198)","v":""},{"$f":"IF(A199=\"\",\"\",\"Beta \"&TEXT(A199,\"mmddyy\"))","v":""}]
[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,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,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,"",""]
[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,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(A263=\"\",\"\",E262)","v":""},{"$f":"IF(A263=\"\",\"\",\"Beta \"&TEXT(A263,\"mmddyy\"))","v":""}]
[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,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,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,"",""]
[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,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(A327=\"\",\"\",E326)","v":""},{"$f":"IF(A327=\"\",\"\",\"Beta \"&TEXT(A327,\"mmddyy\"))","v":""}]
[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,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,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,"",""]
[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,null,null,"",""]
[null,null,null,"",""]
[null,null,null,{"$f":"IF(A391=\"\",\"\",E390)","v":""},{"$f":"IF(A391=\"\",\"\",\"Beta \"&TEXT(A391,\"mmddyy\"))","v":""}]
[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,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]
[null,null,null,"",""]