{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["Cover","Credits-Deficits -->","Cred-Def Summary","Credits Generated","Fuel Consumption + Conversions","CI Targets and Inputs","Availability + Consumption -->","Summary Table ","Gasoline + Alts Forecast","Petroleum Availability","Ethanol Availability","Diesel + Alts Cons Forecast","Biodiesel Availability","Renewable Diesel Availability","Electricity Cons Forecast","Electricity Availability","Natural Gas + RNG Forecast","Natural Gas Availability","Renew Natural Gas Availability","Propane Consumption Forecast","Propane Availability","Data Sources-->","Gas & Diesel Forecast Data","Vehicle Stock Forecast","CNG Vehicle Registrations","Washington EV Data","Propane EIA Data"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":27,"comments":2,"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":"Cover","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Draft Clean Fuel Supply Forecast"]
[null,null,null,"BRG Work Product for the Washington State Department of Commerce"]
[null,null,null,"2022-09-02"]

{"sheet":"Credits-Deficits -->","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Cred-Def Summary","index":2,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Credits/Deficits/Bank Balance Summary Table"]
[]
[null,"Year","Fueling Related Credit Generation","Fueling Related Deficit Generation","Non-Fueling Capacity and Infrastructure Credits","Net Credit Generation","Bank Beginning Balance","Bank Ending Balance"]
[null,2023,{"$f":"SUMIF('Credits Generated'!$C6:$K6,\">0\")","v":1132779.1004977587},{"$f":"SUMIF('Credits Generated'!$C6:$K6,\"<0\")","v":-511620.39386572182},{"$f":"C5*(1/19)","v":59619.952657776768},{"$f":"SUM(C5:E5)","v":680778.65928981372},0,{"$f":"G5+F5","v":680778.65928981372}]
[null,2024,{"$f":"SUMIF('Credits Generated'!$C7:$K7,\">0\")","v":1289305.2925320109},{"$f":"SUMIF('Credits Generated'!$C7:$K7,\"<0\")","v":-725973.83589432284},{"$f":"C6*(1/19)","v":67858.17329115847},{"$f":"SUM(C6:E6)","v":631189.62992884661},{"$f":"H5","v":680778.65928981372},{"$f":"G6+F6","v":1311968.2892186604}]

{"sheet":"Credits Generated","index":3,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Credits Generation"]
[]
[null,"Credits Generated by Fuel Type"]
[null,"Year","Gasoline","Ethanol","Electricity","Diesel","Biodiesel","Renewable Diesel","Natural Gas","RNG","Propane","Total"]
[null,2023,{"$f":"(C11*'Fuel Consumption + Conversions'!C5)/(10^6)","v":-432009.35486521234},{"$f":"(D11*'Fuel Consumption + Conversions'!D5)/(10^6)","v":612841.50615928753},{"$f":"(E11*'Fuel Consumption + Conversions'!G5)/(10^6)","v":58629.673080015469},{"$f":"(F11*'Fuel Consumption + Conversions'!H5)/(10^6)","v":-79611.039000509467},{"$f":"(G11*'Fuel Consumption + Conversions'!I5)/(10^6)","v":243690.91138958541},{"$f":"(H11*'Fuel Consumption + Conversions'!J5)/(10^6)","v":211381.77937670477},{"$f":"(I11*'Fuel Consumption + Conversions'!K5)/(10^6)","v":60.392266250851875},{"$f":"(J11*'Fuel Consumption + Conversions'!L5)/(10^6)","v":358.49601401460319},{"$f":"(K11*'Fuel Consumption + Conversions'!M5)/(10^6)","v":5816.3422119000006},{"$f":"SUM(C6:K6)","v":621158.70663203683}]
[null,2024,{"$f":"(C12*'Fuel Consumption + Conversions'!C6)/(10^6)","v":-596262.76441498718},{"$f":"(D12*'Fuel Consumption + Conversions'!D6)/(10^6)","v":610577.25629149145},{"$f":"(E12*'Fuel Consumption + Conversions'!G6)/(10^6)","v":73103.805113086055},{"$f":"(F12*'Fuel Consumption + Conversions'!H6)/(10^6)","v":-129711.07147933566},{"$f":"(G12*'Fuel Consumption + Conversions'!I6)/(10^6)","v":288961.3271134547},{"$f":"(H12*'Fuel Consumption + Conversions'!J6)/(10^6)","v":310387.26014788024},{"$f":"(I12*'Fuel Consumption + Conversions'!K6)/(10^6)","v":34.921040344321284},{"$f":"(J12*'Fuel Consumption + Conversions'!L6)/(10^6)","v":392.15191118747452},{"$f":"(K12*'Fuel Consumption + Conversions'!M6)/(10^6)","v":5848.5709145666679},{"$f":"SUM(C7:K7)","v":563331.45663768798}]
[]
[null,"Fuel Substitute CI Differentials"]
[null,"Year","Gasoline","Ethanol","Electricity","Diesel","Biodiesel","Renewable Diesel","Natural Gas","RNG","Propane"]
[null,2023,{"$f":"'CI Targets and Inputs'!C7-'CI Targets and Inputs'!$C$13","v":-1.3878500000000003},{"$f":"'CI Targets and Inputs'!C7-'CI Targets and Inputs'!$C$14","v":25.922149999999988},{"$f":"'CI Targets and Inputs'!C7-'CI Targets and Inputs'!$C$21","v":81.575091176470579},{"$f":"'CI Targets and Inputs'!D7-'CI Targets and Inputs'!$C$15","v":-0.7646000000000015},{"$f":"'CI Targets and Inputs'!D7-'CI Targets and Inputs'!$C$16","v":45.085400000000007},{"$f":"'CI Targets and Inputs'!D7-'CI Targets and Inputs'!$C$17","v":49.335400000000007},{"$f":"'CI Targets and Inputs'!D7-'CI Targets and Inputs'!$C$18","v":22.565400000000011},{"$f":"'CI Targets and Inputs'!D7-'CI Targets and Inputs'!$C$19","v":35.895400000000009},{"$f":"'CI Targets and Inputs'!D7-'CI Targets and Inputs'!$C$20","v":24.305400000000006}]
[null,2024,{"$f":"'CI Targets and Inputs'!C8-'CI Targets and Inputs'!$C$13","v":-1.8856999999999999},{"$f":"'CI Targets and Inputs'!C8-'CI Targets and Inputs'!$C$14","v":25.424299999999988},{"$f":"'CI Targets and Inputs'!C8-'CI Targets and Inputs'!$C$21","v":81.077241176470579},{"$f":"'CI Targets and Inputs'!D8-'CI Targets and Inputs'!$C$15","v":-1.2692000000000121},{"$f":"'CI Targets and Inputs'!D8-'CI Targets and Inputs'!$C$16","v":44.580799999999996},{"$f":"'CI Targets and Inputs'!D8-'CI Targets and Inputs'!$C$17","v":48.830799999999996},{"$f":"'CI Targets and Inputs'!D8-'CI Targets and Inputs'!$C$18","v":22.0608},{"$f":"'CI Targets and Inputs'!D8-'CI Targets and Inputs'!$C$19","v":35.390799999999999},{"$f":"'CI Targets and Inputs'!D8-'CI Targets and Inputs'!$C$20","v":23.800799999999995}]

{"sheet":"Fuel Consumption + Conversions","index":4,"n_rows":22,"n_cols":13,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energy Consumption per Fuel (MJ)"]
[]
[null,"Year","Gasoline","Ethanol","Electricity (BEV)","Electricity (PHEV)","Total Electricity","Diesel","Biodiesel","Renewable Diesel","Natural Gas","Renewable Natural Gas (Landfill)","Propane"]
[null,2023,{"$f":"(('Summary Table '!H$5*(10^6))*$E$10)/(10^6)*$G$10","v":311279572623.27502},{"$f":"(('Summary Table '!H6*(10^6))*$E$11)/(10^6)*$G$11","v":23641615612.875004},{"$f":"('Summary Table '!H15*'Fuel Consumption + Conversions'!$E$18)/(10^6)*'Fuel Consumption + Conversions'!$G$18","v":625910253.65075159},{"$f":"('Summary Table '!H16*'Fuel Consumption + Conversions'!$E$18)/(10^6)*'Fuel Consumption + Conversions'!$G$18","v":92810035.036177129},{"$f":"SUM(Table812[[#This Row],[Electricity (BEV)]:[Electricity (PHEV)]])","v":718720288.68692875},{"$f":"('Summary Table '!H9*(10^6))*$E$12/(10^6)*$G$12","v":104121160084.37},{"$f":"(('Summary Table '!H$10*(10^6)*'Fuel Consumption + Conversions'!$E$13/(10^6))*'Fuel Consumption + Conversions'!$G$13)","v":5405095915.5199995},{"$f":"(('Summary Table '!H12*(10^6))*'Fuel Consumption + Conversions'!$E$14/(10^6))*'Fuel Consumption + Conversions'!$G$14","v":4284586308.75},{"$f":"('Summary Table '!H18*(10^6))*'Fuel Consumption + Conversions'!$E$12/(10^6)*'Fuel Consumption + Conversions'!$G$12","v":2676321.5476283091},{"$f":"('Summary Table '!H19*(10^6))*'Fuel Consumption + Conversions'!$E$12/(10^6)*'Fuel Consumption + Conversions'!$G$12","v":9987241.0953660663},{"$f":"('Summary Table '!H22*(10^6)*'Fuel Consumption + Conversions'!$E$17)/(10^6)*$G$17","v":239302468.25396824}]
[null,2024,{"$f":"(('Summary Table '!I$5*(10^6))*$E$10)/(10^6)*$G$10","v":316202346298.45001},{"$f":"(('Summary Table '!I6*(10^6))*$E$11)/(10^6)*$G$11","v":24015499199.25},{"$f":"('Summary Table '!I15*'Fuel Consumption + Conversions'!$E$18)/(10^6)*'Fuel Consumption + Conversions'!$G$18","v":796379644.11895132},{"$f":"('Summary Table '!I16*'Fuel Consumption + Conversions'!$E$18)/(10^6)*'Fuel Consumption + Conversions'!$G$18","v":105276653.65726741},{"$f":"SUM(Table812[[#This Row],[Electricity (BEV)]:[Electricity (PHEV)]])","v":901656297.77621877},{"$f":"('Summary Table '!I9*(10^6))*$E$12/(10^6)*$G$12","v":102199079325.035},{"$f":"(('Summary Table '!I$10*(10^6)*'Fuel Consumption + Conversions'!$E$13/(10^6))*'Fuel Consumption + Conversions'!$G$13)","v":6481743869.8600006},{"$f":"(('Summary Table '!I12*(10^6))*'Fuel Consumption + Conversions'!$E$14/(10^6))*'Fuel Consumption + Conversions'!$G$14","v":6356382859.75},{"$f":"('Summary Table '!I18*(10^6))*'Fuel Consumption + Conversions'!$E$12/(10^6)*'Fuel Consumption + Conversions'!$G$12","v":1582945.3303742965},{"$f":"('Summary Table '!I19*(10^6))*'Fuel Consumption + Conversions'!$E$12/(10^6)*'Fuel Consumption + Conversions'!$G$12","v":11080617.312620075},{"$f":"('Summary Table '!I22*(10^6)*'Fuel Consumption + Conversions'!$E$17)/(10^6)*$G$17","v":245730013.88888896}]
[]
[null,null,"Conversion Units"]
[null,null,"Fuel","Units >>","Energy Density to Btu","Units>>","Energy Density to MJ"]
[null,null,"Gasoline","Btu/Gal",120238,"MJ/MMBtu",1055]
[null,null,"Ethanol","Btu/Gal",84530,"MJ/MMBtu",1055]
[null,null,"Diesel","Btu/Gal",138490,"MJ/MMBtu",1055]
[null,null,"Biodiesel (Soybean)","Btu/Gal",127960,"MJ/MMBtu",1055]
[null,null,"Renewable Diesel (Soybean)","Btu/Gal",138490,"MJ/MMBtu",1055]
[null,null,"Natural Gas","Btu/Dge",138490,"MJ/MMBtu",1055]
[null,null,"Renewable Natural Gas (Landfill)","Btu/Dge",138490,"MJ/MMBtu",1055]
[null,null,"Propane","Btu/Gal",91420,"MJ/MMBtu",1055]
[null,null,"Electricity","Btu/GWh",{"$f":"3412*(10^6)","v":3412000000},"MJ/MMBtu",1055]
[null,null,"Electricity","KWh/GGE",33.700000000000003]
[]
[null,"Sources and Notes:"]
[null,"Conversions: Alternative Fuel Data Center, https://afdc.energy.gov/fuels/equivalency_methodology.html; U.S. Department of Energy, EERE, https://www.fueleconomy.gov/feg/noframes/43403.shtml"]

{"sheet":"CI Targets and Inputs","index":5,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CI Targets and Factor Inputs"]
[]
[null,"CI Targets"]
[null,"Year","Gasoline","Diesel","CI Target % Reduction"]
[null,null,null,null,"[1]"]
[null,2023,{"$f":"D13*(1-Table7[[#This Row],[CI Target % Reduction]])","v":99.072149999999993},{"$f":"D15*(1-Table7[[#This Row],[CI Target % Reduction]])","v":100.41540000000001},5.0000000000000001E-3]
[null,2024,{"$f":"D13*(1-Table7[[#This Row],[CI Target % Reduction]])","v":98.574299999999994},{"$f":"D15*(1-Table7[[#This Row],[CI Target % Reduction]])","v":99.910799999999995},0.01]
[]
[null,"CI Factor Inputs"]
[null,"Fuel","CI Input for Credit Calculations","Washington CI for Target Setting"]
[null,null,"[2]","[3]"]
[null,"Gasoline",100.46,99.57]
[null,"Ethanol",73.150000000000006,"NA"]
[null,"Diesel",101.18,100.92]
[null,"Biodiesel (Soybean)",55.33,"NA"]
[null,"Renewable Diesel (Soybean)",51.08,"NA"]
[null,"Natural Gas",77.849999999999994,"NA"]
[null,"Renewable Natural Gas (Landfill)",64.52,"NA"]
[null,"Propane",76.11,"NA"]
[null,"Electricity (Post-EER Adjustment)",{"$f":"59.49/C23","v":17.497058823529414},"NA"]
[]
[null,"Washington EER Adjustment",3.4]
[]
[null,"Sources and Notes:"]
[null,"[1]: Washington Clean Fuels Program, Chapter 70A.535 RCW, https://app.leg.wa.gov/RCW/default.aspx?cite=70A.535.025"]
[null,"[2]-[3]: CI Inputs from Washington-GREET model, from Department of Ecology, as created by Life Cycle Associates on July 15, 2022."]

{"sheet":"Availability + Consumption -->","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary Table ","index":7,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Summary Table of Fuel Consumption Forecasts"]
[]
[null,null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,null,"Fossil Gasoline","MM Gallons","[1]",{"$f":"'Gas & Diesel Forecast Data'!K$6-F$6","v":2250.835},{"$f":"'Gas & Diesel Forecast Data'!L$6-G$6","v":2399.7474999999999},{"$f":"'Gas & Diesel Forecast Data'!M$6-H$6","v":2453.8975},{"$f":"'Gas & Diesel Forecast Data'!N$6-I$6","v":2492.7049999999999}]
[null,null,"Ethanol","MM Gallons","[2]",{"$f":"'Gas & Diesel Forecast Data'!K$6*'Summary Table '!F$7","v":243.16500000000002},{"$f":"'Gas & Diesel Forecast Data'!L$6*'Summary Table '!G$7","v":259.2525},{"$f":"'Gas & Diesel Forecast Data'!M$6*'Summary Table '!H$7","v":265.10250000000002},{"$f":"'Gas & Diesel Forecast Data'!N$6*'Summary Table '!I$7","v":269.29500000000002}]
[null,null,"Ethanol Blend Rate","%","[3]",9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2]
[null,null,"Total Gasoline","MM Gallons","[4]",{"$f":"SUM(F5:F6)","v":2494},{"$f":"SUM(G5:G6)","v":2659},{"$f":"SUM(H5:H6)","v":2719},2762]
[null,null,"Fossil Diesel","MM Gallons","[5]",{"$f":"'Gas & Diesel Forecast Data'!K$10-SUM(F$10,F$12)","v":707.85},{"$f":"'Gas & Diesel Forecast Data'!L$10-SUM(G$10,G$12)","v":757.57500000000005},{"$f":"'Gas & Diesel Forecast Data'!M$10-SUM(H$10,H$12)","v":712.63660000000004},{"$f":"'Gas & Diesel Forecast Data'!N$10-SUM(I$10,I$12)","v":699.48130000000003}]
[null,null,"Biodiesel","MM Gallons","[6]",{"$f":"'Gas & Diesel Forecast Data'!K$10*'Summary Table '!F$11","v":18.150000000000002},{"$f":"'Gas & Diesel Forecast Data'!L$10*'Summary Table '!G$11","v":19.425000000000001},{"$f":"'Gas & Diesel Forecast Data'!M$10*'Summary Table '!H$11","v":40.038400000000003},{"$f":"'Gas & Diesel Forecast Data'!N$10*'Summary Table '!I$11","v":48.0137}]
[null,null,"Biodiesel Blend Rate","%","[7]",2.5000000000000001E-2,2.5000000000000001E-2,5.1200000000000002E-2,{"$f":"Table2[[#This Row],[2023]]+0.0095","v":6.0700000000000004E-2}]
[null,null,"Renewable Diesel","MM Gallons","[8]",{"$f":"'Gas & Diesel Forecast Data'!K$10*'Summary Table '!F$13","v":0},{"$f":"'Gas & Diesel Forecast Data'!L$10*'Summary Table '!G$13","v":0},{"$f":"'Gas & Diesel Forecast Data'!M$10*'Summary Table '!H$13","v":29.324999999999999},{"$f":"'Gas & Diesel Forecast Data'!N$10*'Summary Table '!I$13","v":43.505000000000003}]
[null,null,"Renewable Diesel Blend Rate","%","[9]",0,0,3.7499999999999999E-2,5.5E-2]
[null,null,"Total Diesel","MM Gallons","[10]",{"$f":"SUM(F9:F10,F12)","v":726},{"$f":"SUM(G9:G10,G12)","v":777},782.00000000000011,{"$f":"SUM(I9:I10,I12)","v":791}]
[null,null,"Electricity (BEVs)","GWh","[11]",{"$f":"('Vehicle Stock Forecast'!K$39*'Washington EV Data'!$F$7)/1000000","v":102.91895715626545},{"$f":"('Vehicle Stock Forecast'!L$39*'Washington EV Data'!$F$7)/1000000","v":130.37438407578921},{"$f":"('Vehicle Stock Forecast'!M$39*'Washington EV Data'!$F$7)/1000000","v":173.88038138345053},{"$f":"('Vehicle Stock Forecast'!N$39*'Washington EV Data'!$F$7)/1000000","v":221.23746246005214}]
[null,null,"Electricity (PHEVs)","GWh","[12]",{"$f":"('Vehicle Stock Forecast'!K$40*'Washington EV Data'!$F$15)/1000000","v":19.903889104677063},{"$f":"('Vehicle Stock Forecast'!L$40*'Washington EV Data'!$F$15)/1000000","v":22.202788296267265},{"$f":"('Vehicle Stock Forecast'!M$40*'Washington EV Data'!$F$15)/1000000","v":25.783000348971051},{"$f":"('Vehicle Stock Forecast'!N$40*'Washington EV Data'!$F$15)/1000000","v":29.246277053184858}]
[null,null,"Electricity","MM Gallons Gasoline Equivalent","[13]",{"$f":"(F15/'Fuel Consumption + Conversions'!$E$19)+(F16/'Fuel Consumption + Conversions'!$E$19)","v":3.6445948445383531},{"$f":"(G15/'Fuel Consumption + Conversions'!$E$19)+(G16/'Fuel Consumption + Conversions'!$E$19)","v":4.527512533295444},{"$f":"(H15/'Fuel Consumption + Conversions'!$E$19)+(H16/'Fuel Consumption + Conversions'!$E$19)","v":5.9247294282617675},{"$f":"(I15/'Fuel Consumption + Conversions'!$E$19)+(I16/'Fuel Consumption + Conversions'!$E$19)","v":7.4327519143393763}]
[null,null,"Natural Gas","MM Diesel Gallons Equivalent","[14]",{"$f":"F21-F19","v":8.6673239315408157E-2},{"$f":"G21-G19","v":8.6673239315408157E-2},{"$f":"H21-H19","v":1.831755127068431E-2},{"$f":"I21-I19","v":1.083415491442602E-2}]
[null,null,"Renewable Natural Gas","MM Diesel Gallons Equivalent","[15]",{"$f":"F21*F20","v":0},{"$f":"G21*G20","v":0},{"$f":"H21*H20","v":6.8355688044723847E-2},{"$f":"I21*I20","v":7.5839084400982137E-2}]
[null,null,"Renewable Natural Gas Blend Rate","%","[16]",0,0,0.78865966686642641,0.875]
[null,null,"Total Natural Gas","MM Diesel Gallons Equivalent","[17]",{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$10)/'Fuel Consumption + Conversions'!$E$15)/(10^6)","v":8.6673239315408157E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$10)/'Fuel Consumption + Conversions'!$E$15)/(10^6)","v":8.6673239315408157E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$10)/'Fuel Consumption + Conversions'!$E$15)/(10^6)","v":8.6673239315408157E-2},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$10)/'Fuel Consumption + Conversions'!$E$15)/(10^6)","v":8.6673239315408157E-2}]
[null,null,"Propane","MM Gallons","[18]",{"$f":"'Propane EIA Data'!F$5*'Propane EIA Data'!$F$9","v":1.9736442305355018},{"$f":"'Propane EIA Data'!G$5*'Propane EIA Data'!$F$9","v":2.2983129784158005},{"$f":"'Propane EIA Data'!H$5*'Propane EIA Data'!$F$9","v":2.4811527469589163},{"$f":"'Propane EIA Data'!I$5*'Propane EIA Data'!$F$9","v":2.547795279418557}]
[]
[]
[null,null,"Sources and Notes:"]
[null,null,"[1]: 'Gas & Diesel Forecast Data' less ethanol blend volume"]
[null,null,"[2]: 'Gas & Diesel Forecast Data' multiplied by Ethanol Blend Rate."]
[null,null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends"]
[null,null,"[5]: 'Gas & Diesel Forecast Data' less Biodiesel and Renewable Diesel blend volumes."]
[null,null,"[6]: 'Gas & Diesel Forecast Data' multiplied by Biodiesel Blend Rate."]
[null,null,"[7]: BRG analysis based on historical experience in Oregon and California and other market trends."]
[null,null,"[8]: 'Gas & Diesel Forecast Data' multiplied by Renewable Diesel Blend Rate."]
[null,null,"[9]: BRG analysis based on historical experience in Oregon and California and other market trends."]
[null,null,"[11]: 'Vehicle Stock Forecast' for BEVs times the average annual electricity consumption for BEVs in Washington."]
[null,null,"[12]: 'Vehicle Stock Forecast' for PHEVs times the average annual electricity consumption for PHEVs in Washington. 10% of PHEV vehicle miles traveled is assumed to be gasoline powered."]
[null,null,"[14]: Natural gas consumption less volume of Renewable Natural Gas consumption."]
[null,null,"[15]: Total Natural Gas consumption multiplied by the renewable natural gas blend rate."]
[null,null,"[16]: Renewable natural gas produced in Washington is typically exported to California or Oregon to take advantage of multiple incentive structures. With the implementation of a CFS the blendrate of RNG is assumed to the same rates projected in Oregon."]
[null,null,"[17]: 'CNG Vehicles Registrations' times average annual CNG consumption per vehicle. Converted into MM Diesel Gallons Equivalent."]
[null,null,"[18]: Using Washington's historical consumption BRG has allocated the projected propane consumption using the EIA AEO Pacific Consumption Forecast. Due to an identified data limitation BRG relied upon the average allocation to Washington from 2014 through 2019."]

{"sheet":"Gasoline + Alts Forecast","index":8,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Gasoline and Gasoline Alternatives Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Fossil Gasoline","MM Gallons","[1]",{"$f":"'Gas & Diesel Forecast Data'!K$6-E6","v":2250.835},{"$f":"'Gas & Diesel Forecast Data'!L$6-F6","v":2399.7474999999999},{"$f":"'Gas & Diesel Forecast Data'!M$6-G6","v":2453.8975},{"$f":"'Gas & Diesel Forecast Data'!N$6-H6","v":2492.7049999999999}]
[null,"Ethanol","MM Gallons","[2]",{"$f":"'Gas & Diesel Forecast Data'!K$6*E$7","v":243.16500000000002},{"$f":"'Gas & Diesel Forecast Data'!L$6*'Summary Table '!G$7","v":259.2525},{"$f":"'Gas & Diesel Forecast Data'!M$6*'Summary Table '!H$7","v":265.10250000000002},{"$f":"'Gas & Diesel Forecast Data'!N$6*'Summary Table '!I$7","v":269.29500000000002}]
[null,"Ethanol Blend Rate","%","[3]",9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2,9.7500000000000003E-2]
[null,"Total Gasoline","MM Gallons","[4]",{"$f":"SUM(E5:E6)","v":2494},{"$f":"SUM(F5:F6)","v":2659},{"$f":"SUM(G5:G6)","v":2719},{"$f":"SUM(H5:H6)","v":2762}]
[]
[null,"Sources & Notes:"]
[null,"[1]: 'Gas & Diesel Forecast Data' less Ethanol blend volume."]
[null,"[2]: 'Gas & Diesel Forecast Data' times Ethanol blend percentage."]
[null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends."]

{"sheet":"Petroleum Availability","index":9,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[[6,2,7,2]]}
[]
[null,"Petroleum Production and Available Capacity (2022)"]
[]
[null,"Conversion:","Barrels to Gallons",42]
[]
[null,"Product",null,"Gallons (EIA)","% of barrel"]
[null,"Finished motor gasoline","[1]",19.399999999999999,{"$f":"D7/D4","v":0.46190476190476187}]
[null,"Distillate fuel oil",null,13.44,{"$f":"D8/D4","v":0.32}]
[]
[null,null,"Crude Oil Distillation Operable Capacity ","Gasoline","Diesel"]
[null,"State","(MM Barrels per Calendar Day)","(MM gal/ year)","(MM gal/year)"]
[null,null,"[2]"]
[null,"East Coast (PADD 1)"]
[null,"Delaware",0.17100000000000001,{"$f":"(C14*365)*$D$4*$E$7","v":1210.8510000000001},{"$f":"(C14*365)*$D$4*$E$8","v":838.85760000000016}]
[null,"Florida",0,{"$f":"(C15*365)*$D$4*$E$7","v":0},{"$f":"(C15*365)*$D$4*$E$8","v":0}]
[null,"Georgia",0,0,0]
[null,"Maryland",0,0,0]
[null,"New Jersey",0.35849999999999999,2538.5384999999997,1758.6575999999998]
[null,"New York",0,0,0]
[null,"North Carolina",0,0,0]
[null,"Pennsylvania",0.26600000000000001,1883.546,1304.8896000000002]
[null,"Virginia",0,0,0]
[null,"West Virginia",2.23E-2,157.90629999999999,109.39488]
[null,"Midwest (PADD 2)"]
[null,"Illinois",1.040065,7364.7002649999995,5102.1428640000004]
[null,"Indiana",0.46729999999999999,3308.9513000000002,2292.3868800000005]
[null,"Kansas",0.4042,2862.1401999999998,1982.8435200000001]
[null,"Kentucky",0.29099999999999998,2060.5709999999999,1427.5295999999998]
[null,"Michigan",0.14000000000000001,991.34,686.78400000000011]
[null,"Minnesota",0.439,3108.5590000000002,2153.5584000000003]
[null,"Missouri ",0,0,0]
[null,"Nebraska",0,0,0]
[null,"North Dakota",7.0999999999999994E-2,502.75099999999998,348.29760000000005]
[null,"Ohio",0.60260000000000002,4267.0105999999996,2956.11456]
[null,"Oklahoma",0.52380000000000004,3709.0277999999998,2569.5532800000001]
[null,"Tennessee",0.18,1274.58,883.00800000000004]
[null,"Wisconsin",3.7999999999999999E-2,269.07799999999997,186.4128]
[null,"Gulf Coast (PADD 3)"]
[null,"Alabama",0.1411,999.12909999999999,692.18016]
[null,"Arkansas",9.0499999999999997E-2,640.83049999999992,443.95679999999999]
[null,"Louisiana",2.9225409999999998,20694.512820999997,14336.8171296]
[null,"Mississippi",0.39394000000000001,2789.4891400000001,1932.5120640000002]
[null,"New Mexico",0.11,778.91,539.61599999999999]
[null,"Texas",5.9485289999999997,42121.533848999992,29181.103862399999]
[null,"Rocky Mountain (PADD 4)"]
[null,"Colorado",0.10299999999999999,729.34299999999996,505.27680000000004]
[null,"Montana",0.2276,1611.6355999999998,1116.5145599999998]
[null,"Utah",0.20671400000000001,1463.7418339999999,1014.0561984]
[null,"Wyoming",0.12584999999999999,891.14384999999982,617.36975999999993]
[null,"West Coast (PADD 5)"]
[null,"Alaska",0.16420000000000001,1162.7002,805.49952000000008]
[null,"Arizona",0,0,0]
[null,"California",1.749871,12390.836550999999,8584.1671775999985]
[null,"Hawaii",9.35E-2,662.07349999999997,458.67360000000002]
[null,"Nevada",2E-3,14.161999999999999,9.8111999999999995]
[null,"Oregon",0,0,0]
[null,"Washington",0.64970000000000006,4600.5257000000001,3187.1683200000007]
[null,"PADD 1",{"$f":"SUM(C14:C23)","v":0.81779999999999997},{"$f":"SUM(D14:D23)","v":5790.8417999999992},{"$f":"SUM(E14:E23)","v":4011.7996800000001}]
[null,"PADD 2",{"$f":"SUM(C25:C37)","v":4.1969650000000005},{"$f":"SUM(D25:D37)","v":29718.709165},{"$f":"SUM(E25:E37)","v":20588.631504000001}]
[null,"PADD 3",{"$f":"SUM(C39:C44)","v":9.6066099999999999},{"$f":"SUM(D39:D44)","v":68024.405409999992},{"$f":"SUM(E39:E44)","v":47126.186016}]
[null,"PADD 4",{"$f":"SUM(C46:C49)","v":0.66316400000000009},{"$f":"SUM(D46:D49)","v":4695.8642839999993},{"$f":"SUM(E46:E49)","v":3253.2173183999998}]
[null,"PADD 5",{"$f":"SUM(C51:C57)","v":2.6592709999999999},{"$f":"SUM(D51:D57)","v":18830.297951},{"$f":"SUM(E51:E57)","v":13045.319817599999}]
[null,"U.S.",{"$f":"SUM(C58:C62)","v":17.943809999999999},{"$f":"SUM(D58:D62)","v":127060.11860999999},{"$f":"SUM(E58:E62)","v":88025.154336000007}]
[]
[null,"Sources:"]
[null,"Conversions: US Energy Information Administration, Units and Calculators, https://www.eia.gov/energyexplained/units-and-calculators/energy-conversion-calculators.php"]
[null,"[1] Petroleum products produced from one 42-gallon barrel of oil input at U.S. refineries, 2020, https://www.eia.gov/energyexplained/oil-and-petroleum-products/refining-crude-oil-inputs-and-outputs.php"]
[null,"[2] U.S. Energy Information Administration, Number and Capacity of Petroleum Refineries, accessed as of Sept. 2, 2022. https://www.eia.gov/dnav/pet/pet_pnp_cap1_dcu_nus_a.htm"]

{"sheet":"Ethanol Availability","index":10,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,3,3,4],[5,3,5,4]]}
[]
[null,"Ethanol Production (2022)"]
[]
[null,"State","Number of Producers","Production Capacity"]
[null,null,null," (MM gal/year)"," (Thousand Barrels/day)"]
[null,null,"[1]","[2]"]
[null,"East Coast (PADD 1)"]
[null,"New York",2,62,4.0443574690149999]
[null,"North Carolina",1,57,3.7181996086105675]
[null,"Pennsylvania",1,128,8.3496412263535547]
[null,"Midwest (PADD 2)"]
[null,"Illinois",13,1743,113.69863013698631]
[null,"Indiana",14,1315,85.779517286366612]
[null,"Iowa",41,4694,306.19699934768437]
[null,"Kansas",12,601,38.81278538812785]
[null,"Kentucky",2,53,3.131115459882583]
[null,"Michigan",5,387,25.244618395303323]
[null,"Minnesota",19,1424,92.889758643183299]
[null,"Missouri",6,331,21.591650358773645]
[null,"Nebraska",24,2244,146.37964774951075]
[null,"North Dakota",5,547,35.68166992824527]
[null,"Ohio",7,722,47.097195042400521]
[null,"South Dakota",16,1444,94.194390084801057]
[null,"Tennessee",3,236,15.329419439008479]
[null,"Wisconsin",9,587,38.290932811480751]
[null,"Gulf Coast (PADD 3)"]
[null,"Texas",3,380,24.787997390737118]
[null,"Rocky Mountains (PADD 4)"]
[null,"Colorado",3,140,9.1324200913242013]
[null,"Idaho",1,60,3.9138943248532287]
[null,"West Coast (PADD 5)"]
[null,"California",4,188,12.0678408349641]
[null,"Oregon",1,40,2.6092628832354858]
[null,"PADD 1",{"$f":"SUM(C8:C10)","v":4},{"$f":"SUM(D8:D10)","v":247},{"$f":"SUM(E8:E10)","v":16.11219830397912}]
[null,"PADD 2",{"$f":"SUM(C12:C25)","v":176},{"$f":"SUM(D12:D25)","v":16328},{"$f":"SUM(E12:E25)","v":1064.3183300717549}]
[null,"PADD 3",{"$f":"C27","v":3},{"$f":"D27","v":380},{"$f":"E27","v":24.787997390737118}]
[null,"PADD 4",{"$f":"SUM(C29:C30)","v":4},{"$f":"SUM(D29:D30)","v":200},{"$f":"SUM(E29:E30)","v":13.046314416177431}]
[null,"PADD 5",{"$f":"SUM(C32:C33)","v":5},{"$f":"SUM(D32:D33)","v":228},{"$f":"SUM(E32:E33)","v":14.677103718199586}]
[null,"US Total",{"$f":"SUM(C34:C38)","v":192},{"$f":"SUM(D34:D38)","v":17383},{"$f":"SUM(E34:E38)","v":1132.9419439008479}]
[]
[null,"Sources and Notes:"]
[null,"[1]-[2]: U.S. Energy Information Administration, U.S. Fuel Ethanol Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/petroleum/ethanolcapacity/"]

{"sheet":"Diesel + Alts Cons Forecast","index":11,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Diesel and Diesel Alternatives Volume Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Fossil Diesel","MM Gallons","[1]",{"$f":"'Gas & Diesel Forecast Data'!K$10-SUM(E$6,E$8)","v":707.85},{"$f":"'Gas & Diesel Forecast Data'!L$10-SUM(F$6,F$8)","v":757.57500000000005},{"$f":"'Gas & Diesel Forecast Data'!M$10-SUM(G$6,G$8)","v":712.63660000000004},{"$f":"'Gas & Diesel Forecast Data'!N$10-SUM(H$6,H$8)","v":699.48130000000003}]
[null,"Biodiesel","MM Gallons","[2]",{"$f":"'Gas & Diesel Forecast Data'!K$10*E$7","v":18.150000000000002},{"$f":"'Gas & Diesel Forecast Data'!L$10*F$7","v":19.425000000000001},{"$f":"'Gas & Diesel Forecast Data'!M$10*G$7","v":40.038400000000003},{"$f":"'Gas & Diesel Forecast Data'!N$10*H$7","v":48.0137}]
[null,"Biodiesel Blend Rate","%","[3]",2.5000000000000001E-2,2.5000000000000001E-2,5.1200000000000002E-2,{"$f":"G7+0.0095","v":6.0700000000000004E-2}]
[null,"Renewable Diesel","MM Gallons","[4]",{"$f":"'Gas & Diesel Forecast Data'!K$10*E$9","v":0},{"$f":"'Gas & Diesel Forecast Data'!L$10*F$9","v":0},{"$f":"'Gas & Diesel Forecast Data'!M$10*G$9","v":29.324999999999999},{"$f":"'Gas & Diesel Forecast Data'!N$10*H$9","v":43.505000000000003}]
[null,"Renewable Diesel Blend Rate","%","[5]",0,0,3.7499999999999999E-2,5.5E-2]
[null,"Total Diesel","MM Gallons","[6]",{"$f":"SUM(E5:E6,E8)","v":726},{"$f":"SUM(F5:F6,F8)","v":777},782.00000000000011,791]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'Gas & Diesel Forecast Data' less Biodiesel and Renewable Diesel blend volumes."]
[null,"[2]: 'Gas & Diesel Forecast Data' times Biodiesel blend percentage."]
[null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends."]
[null,"[4]: 'Gas & Diesel Forecast Data' times Renewable Diesel blend percentage."]
[null,"[5]: BRG analysis based on historical experience in Oregon and California and other market trends."]

{"sheet":"Biodiesel Availability","index":12,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,3,3,4],[5,3,5,4]]}
[]
[null,"Biodiesel Production (2022)"]
[]
[null,"State","Number of Producers","Production Capacity"]
[null,null,null," (MM gal/year)"," (Thousand Barrels/day)"]
[null,null,"[1]","[2]"]
[null,"East Coast PADD 1"]
[null,"Connecticut",1,35,2.2831050228310503]
[null,"Georgia",2,22,1.30463144161774]
[null,"Massachusetts",1,1,0]
[null,"Maine",1,1,0]
[null,"North Carolina",1,2,0]
[null,"New Hampshire",1,8,0.52185257664709717]
[null,"Pennsylvania",2,64,4.1748206131767773]
[null,"Rhode Island",1,8,0.5]
[null,"South Carolina",1,5,0]
[null,"Virginia",3,11,0]
[null,"Midwest (PADD 2)"]
[null,"Iowa",11,470,30.658838878016958]
[null,"Illinois",4,192,12.263535551206784]
[null,"Indiana",3,107,6.4579256360078281]
[null,"Kansas",1,90,5.8708414872798436]
[null,"Kentucky",2,56,3.5225048923679063]
[null,"Michigan",2,15,0.97847358121330719]
[null,"Minnesota",3,85,5.3489889106327464]
[null,"Missouri",6,238,15.198956294846704]
[null,"North Dakota",1,85,5.5446836268754076]
[null,"Oklahoma",1,38,2.478799739073712]
[null,"Tennessee",1,36,2.3483365949119372]
[null,"Wisconsin",2,33,1.8264840182648401]
[null,"Gulf Coast (PADD 3)"]
[null,"Alabama",1,20,1.3046314416177429]
[null,"Arkansas",3,115,7.5016307893020215]
[null,"Mississippi",2,29,1.8917155903457274]
[null,"Texas",6,291,18.982387475538161]
[null,"West Coast (PADD 5)"]
[null,"Alaska",1,0,0]
[null,"Arizona",1,2,0]
[null,"California",4,72,4.6966731898238745]
[null,"Hawaii",1,6,0]
[null,"Oregon",1,12,0.78277886497064575]
[null,"Washington",1,107,6.9797782126549244]
[null,"PADD 1",{"$f":"SUM(C8:C17)","v":14},{"$f":"SUM(D8:D17)","v":157},{"$f":"SUM(E8:E17)","v":8.7844096542726646}]
[null,"PADD 2",{"$f":"SUM(C19:C30)","v":37},{"$f":"SUM(D19:D30)","v":1445},{"$f":"SUM(E19:E30)","v":92.498369210697973}]
[null,"PADD 3",{"$f":"SUM(C32:C35)","v":12},{"$f":"SUM(D32:D35)","v":455},{"$f":"SUM(E32:E35)","v":29.68036529680365}]
[null,"PADD 4"]
[null,"PADD 5",{"$f":"SUM(C37:C42)","v":9},{"$f":"SUM(D37:D42)","v":199},{"$f":"SUM(E37:E42)","v":12.459230267449446}]
[null,"US Total",{"$f":"SUM(C43:C47)","v":72},{"$f":"SUM(D43:D47)","v":2256},{"$f":"SUM(E43:E47)","v":143.42237442922374}]
[]
[null,"Sources and Notes: "]
[null,"[1]: U.S. Energy Information Administration, U.S. Biodiesel Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/biofuels/biodiesel/capacity/"]
[null,"[2]: U.S. Energy Information Administration, U.S. Biodiesel Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/biofuels/biodiesel/capacity/"]

{"sheet":"Renewable Diesel Availability","index":13,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,3,3,4],[5,3,5,4]]}
[]
[null,"Renewable Diesel Availability (2023)"]
[]
[null,"State","Number of Producers","Production Capacity"]
[null,null,null," (MM gal/year)"," (Thousand Barrels/day)"]
[null,null,null,"[1]"]
[null,"Midwest (PADD 2)"]
[null,"Kansas",1,3,0]
[null,"North Dakota",1,192,12.524461839530332]
[null,"Gulf Coast (PADD 3)"]
[null,"Louisiana",2,1082,70.580560991519903]
[null,"Rocky Mountains (PADD 4)"]
[null,"Wyoming",2,209,13.6333985649054]
[null,"West Coast (PADD 5)"]
[null,"California",4,199,12.589693411611218]
[null,"Washington*",2,175,4.0071232876712326]
[null,"PADD 1"]
[null,"PADD 2",{"$f":"SUM(C8:C9)","v":2},{"$f":"SUM(D8:D9)","v":195},{"$f":"SUM(E8:E9)","v":12.524461839530332}]
[null,"PADD 3",{"$f":"C11","v":2},{"$f":"D11","v":1082},{"$f":"E11","v":70.580560991519903}]
[null,"PADD 4",{"$f":"C13","v":2},{"$f":"D13","v":209},{"$f":"E13","v":13.6333985649054}]
[null,"PADD 5",{"$f":"SUM(C15:C16)","v":6},{"$f":"SUM(D15:D16)","v":374},{"$f":"SUM(E15:E16)","v":16.596816699282449}]
[null,"US Total",{"$f":"SUM(C17:C21)","v":12},{"$f":"SUM(D17:D21)","v":1860},{"$f":"SUM(E17:E21)","v":113.33523809523808}]
[]
[null,"Sources and Notes:"]
[null,"[1]: U.S. Energy Information Administration, U.S. Renewable Diesel Fuel and Other Biofuels Plant Production Capacity, accessed as of Sept. 2, 2022. https://www.eia.gov/biofuels/renewable/capacity/"]
[null,"* Cherry Point Refinery is expected to be operational by 2023. BP, BP investing almost $270 million to improve efficiency, reduce emissions and grow renewable diesel production at Cherry Point Refinery, https://www.bp.com/en/global/corporate/news-and-insights/press-releases/bp-investing-almost-270m-to-improve-efficiency-reduce-emissions-and-grow-renewable-diesel-production-at-cherry-point-refinery.html"]

{"sheet":"Electricity Cons Forecast","index":14,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Electricity Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Electricity (BEVs)","GWh","[1]",{"$f":"('Vehicle Stock Forecast'!K$39*'Washington EV Data'!$F$7)/1000000","v":102.91895715626545},{"$f":"('Vehicle Stock Forecast'!L$39*'Washington EV Data'!$F$7)/1000000","v":130.37438407578921},{"$f":"('Vehicle Stock Forecast'!M$39*'Washington EV Data'!$F$7)/1000000","v":173.88038138345053},{"$f":"('Vehicle Stock Forecast'!N$39*'Washington EV Data'!$F$7)/1000000","v":221.23746246005214}]
[null,"Electricity (PHEVs)","GWh","[2]",{"$f":"('Vehicle Stock Forecast'!K$40*'Washington EV Data'!$F$15)/1000000","v":19.903889104677063},{"$f":"('Vehicle Stock Forecast'!L$40*'Washington EV Data'!$F$15)/1000000","v":22.202788296267265},{"$f":"('Vehicle Stock Forecast'!M$40*'Washington EV Data'!$F$15)/1000000","v":25.783000348971051},{"$f":"('Vehicle Stock Forecast'!N$40*'Washington EV Data'!$F$15)/1000000","v":29.246277053184858}]
[null,"Electricity","MM Gallons Gasoline Equivalent","[3]",{"$f":"(E5/'Fuel Consumption + Conversions'!$E$19)+(E6/'Fuel Consumption + Conversions'!$E$19)","v":3.6445948445383531},{"$f":"(F5/'Fuel Consumption + Conversions'!$E$19)+(F6/'Fuel Consumption + Conversions'!$E$19)","v":4.527512533295444},{"$f":"(G5/'Fuel Consumption + Conversions'!$E$19)+(G6/'Fuel Consumption + Conversions'!$E$19)","v":5.9247294282617675},{"$f":"(H5/'Fuel Consumption + Conversions'!$E$19)+(H6/'Fuel Consumption + Conversions'!$E$19)","v":7.4327519143393763}]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'Vehicle Stock Forecast' for BEVs times the average annual electricity consumption for BEVs in Washington."]
[null,"[2]: 'Vehicle Stock Forecast' for PHEVs times the average annual electricity consumption for PHEVs in Washington. 10% of PHEV vehicle miles traveled is assumed to be gasoline powered."]

{"sheet":"Electricity Availability","index":15,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Electricity Generation Availability (2020)"]
[]
[null,"Interconnection","State","Generation Available","Generation Available"]
[null,null,null,"(GWh/year)","MM GGE"]
[null,null,null,"[1]","[2]"]
[null,"WECC","AZ",109305.057,{"$f":"D7/'Fuel Consumption + Conversions'!$E$19","v":3243.4735014836792}]
[null,"WECC","CA",193074.93,{"$f":"D8/'Fuel Consumption + Conversions'!$E$19","v":5729.2264094955481}]
[null,"WECC","CO",54115.010999999999,{"$f":"D9/'Fuel Consumption + Conversions'!$E$19","v":1605.7866765578633}]
[null,"WECC","ID",17686.134999999998,{"$f":"D10/'Fuel Consumption + Conversions'!$E$19","v":524.81112759643906}]
[null,"WECC","NV",40424.745000000003,{"$f":"D11/'Fuel Consumption + Conversions'!$E$19","v":1199.5473293768546}]
[null,"WECC","OR",63624.781999999999,{"$f":"D12/'Fuel Consumption + Conversions'!$E$19","v":1887.9757270029672}]
[null,"WECC","UT",37087.309000000001,{"$f":"D13/'Fuel Consumption + Conversions'!$E$19","v":1100.5136201780415}]
[null,"WECC","WA",116114.46799999999,{"$f":"D14/'Fuel Consumption + Conversions'!$E$19","v":3445.5331750741834}]
[null,"Rest of WECC*",null,32407.458999999999,{"$f":"D15/'Fuel Consumption + Conversions'!$E$19","v":961.64566765578627}]
[null,"Total WECC",null,{"$f":"SUM(D7:D15)","v":663839.89599999995},{"$f":"D16/'Fuel Consumption + Conversions'!$E$19","v":19698.513234421363}]
[]
[null,"Sources and Notes:"]
[null,"[1]: U.S. Energy Information Administration, Generation Tables, accessed as of Sept. 2, 2022. https://www.eia.gov/electricity/annual/html/epa_03_07.html"]
[null,"* Rest of WECC: Balance of WECC generation not accounted for by state in the above. https://www.eia.gov/electricity/gridmonitor/dashboard/"]

{"sheet":"Natural Gas + RNG Forecast","index":16,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Natural Gas and Renewable Natural Gas Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Natural Gas","MM Diesel Gallons Equivalent","[1]",{"$f":"E8-E6","v":0.11498425381295413},{"$f":"F8-F6","v":0.11498425381295413},{"$f":"G8-G6","v":2.4300810505945111E-2},{"$f":"H8-H6","v":1.4373031726619273E-2}]
[null,"Renewable Natural Gas","MM Diesel Gallons Equivalent","[2]",{"$f":"E8*E7","v":0},{"$f":"F8*F7","v":0},{"$f":"G8*G7","v":9.0683443307009018E-2},{"$f":"H8*H7","v":0.10061122208633486}]
[null,"Renewable Natural Gas Blend Rate","%","[3]",0,0,0.78865966686642641,0.875]
[null,"Total Natural Gas","MM Diesel Gallons Equivalent","[4]",{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$15)/'Fuel Consumption + Conversions'!$E$10)/(10^6)","v":0.11498425381295413},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$15)/'Fuel Consumption + Conversions'!$E$10)/(10^6)","v":0.11498425381295413},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$15)/'Fuel Consumption + Conversions'!$E$10)/(10^6)","v":0.11498425381295413},{"$f":"((('CNG Vehicle Registrations'!$F$7*'CNG Vehicle Registrations'!$F$8)*'Fuel Consumption + Conversions'!$E$15)/'Fuel Consumption + Conversions'!$E$10)/(10^6)","v":0.11498425381295413}]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'CNG Vehicle Registrations' times average annual CNG consumption per vehicle. Converted into MMCF."]
[null,"[2]: Renewable natural gas produced in Washington is typically exported to California or Oregon to take advantage of multiple incentive structures. With the implementation of a CFS the blendrate of RNG is assumed to increase year over year."]
[null,"[3]: BRG analysis based on historical experience in Oregon and California and other market trends."]

{"sheet":"Natural Gas Availability","index":17,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[7,2,7,3]]}
[]
[null,"Natural Gas Production (2022)"]
[]
[null,"Conversion"]
[null,"cubic feet to Btu",1039]
[null,"cubic meter to cubic feet",35.335999999999999]
[]
[null,"State","Production Capacity"]
[null,null,"(Million cu ft)","(Million DGE)"]
[null,null,"[1]"]
[null,"East Coast (PADD 1)"]
[null,"Florida",698,{"$f":"(C12*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":5.2366380244060942}]
[null,"Maryland",10,{"$f":"(C13*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":7.5023467398368113E-2}]
[null,"New York",9692,{"$f":"(C14*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":72.712744602498375}]
[null,"Pennsylvania",7148295,{"$f":"(C15*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":53628.987688641777}]
[null,"Virginia",102824,{"$f":"(C16*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":771.42130117698025}]
[null,"West Virginia",2592319,{"$f":"(C17*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":19448.475998267022}]
[null,"Midwest (PADD 2)"]
[null,"Illinois",1843,{"$f":"(C19*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":13.826825041519243}]
[null,"Indiana",4197,{"$f":"(C20*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":31.487349267095098}]
[null,"Kansas",163356,{"$f":"(C21*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":1225.5533540327822}]
[null,"Kentucky",71018,{"$f":"(C22*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":532.80166076973069}]
[null,"Michigan",64911,{"$f":"(C23*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":486.98482922954724}]
[null,"Missouri",1,{"$f":"(C24*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":7.5023467398368116E-3}]
[null,"Nebraska",351,{"$f":"(C25*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":2.6333237056827206}]
[null,"North Dakota",882443,{"$f":"(C26*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":6620.3933641418153}]
[null,"Ohio",2378902,{"$f":"(C27*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":17847.34766409127}]
[null,"Oklahoma",2786366,{"$f":"(C28*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":20904.283876092137}]
[null,"South Dakota",407,{"$f":"(C29*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":3.053455123113582}]
[null,"Tennessee",2770,{"$f":"(C30*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":20.781500469347968}]
[null,"Gulf Coast (PADD 3)"]
[null,"Alabama",117028,{"$f":"(C32*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":877.98463426962235}]
[null,"Arkansas",480982,{"$f":"(C33*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":3608.493739620189}]
[null,"Louisiana",3206163,{"$f":"(C34*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":24053.746530435412}]
[null,"Mississippi",28134,{"$f":"(C35*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":211.07102317856885}]
[null,"New Mexico",1948168,{"$f":"(C36*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":14615.831843454402}]
[null,"Texas",9336110,{"$f":"(C37*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":70042.734421257846}]
[null,"Rocky Mountains (PADD 4)"]
[null,"Colorado",1990462,{"$f":"(C39*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":14933.136096469059}]
[null,"Montana",37963,{"$f":"(C40*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":284.81158928442488}]
[null,"Utah",241989,{"$f":"(C41*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":1815.4853852263702}]
[null,"Wyoming",1306368,{"$f":"(C42*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":9800.8257058271356}]
[null,"West Coast (PADD 5)"]
[null,"Alaska",338329,{"$f":"(C44*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":2538.2614701422485}]
[null,"Arizona",66,{"$f":"(C45*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":0.49515488482922954}]
[null,"California",170579,{"$f":"(C46*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":1279.7428045346235}]
[null,"Nevada",12,{"$f":"(C47*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":9.0028160878041733E-2}]
[null,"Oregon",320,{"$f":"(C48*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":2.4007509567477796}]
[null,"PADD 1",{"$f":"SUM(C12:C17)","v":9853838},{"$f":"SUM(D12:D17)","v":73926.909394180082}]
[null,"PADD 2",{"$f":"SUM(C19:C30)","v":6356565},{"$f":"SUM(D19:D30)","v":47689.154704310778}]
[null,"PADD 3",{"$f":"SUM(C32:C37)","v":15116585},{"$f":"SUM(D32:D37)","v":113409.86219221604}]
[null,"PADD 4",{"$f":"SUM(C39:C42)","v":3576782},{"$f":"SUM(D39:D42)","v":26834.258776806993}]
[null,"PADD 5",{"$f":"SUM(C44:C48)","v":509306},{"$f":"SUM(D44:D48)","v":3820.9902086793272}]
[null,"US Total",{"$f":"SUM(C49:C53)","v":35413076},{"$f":"SUM(D49:D53)","v":265681.17527619324}]
[null,"Alberta, CA2",{"$f":"104.009*$C$6*1000","v":3675262.0239999997},{"$f":"(C55*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":27573.09006380244}]
[null,"British Columbia, CA3",{"$f":"52.82*$C$6*1000","v":1866447.52},{"$f":"(C56*$C$5)/'Fuel Consumption + Conversions'!$E$15","v":14002.736466748502}]
[]
[null,"Sources and Notes:"]
[null,"Conversions: Alternative Fuel Data Center, https://afdc.energy.gov/fuels/equivalency_methodology.html. U.S. Energy Information Administration, Units and Calculators, https://www.eia.gov/energyexplained/units-and-calculators/energy-conversion-calculators.php"]
[null,"[1]: U.S. Energy Information Administration, Natural Gas Plant Field Production, accessed as of Sept. 2, 2022. https://www.eia.gov/state/rankings/?sid=MI#series/47"]
[null,"[2]: 104.009 bcm is the sum of 2021 Natural Gas Production numbers from Alberta, Economic Dashboard, https://economicdashboard.alberta.ca/NaturalGasProduction"]
[null,"[3]: 52.82 bcm is the sum of 2021 Natural Gas Production numbers from British Columbia, Natural Gas and Oil Statistics, https://www2.gov.bc.ca/gov/content/industry/natural-gas-oil/statistics"]

{"sheet":"Renew Natural Gas Availability","index":18,"n_rows":51,"n_cols":13,"rows_kept":51,"cut":false,"hidden":false,"merged":[[3,3,3,12],[6,3,6,6]]}
[]
[null,"Renewable Natural Gas Production Availability (2022)"]
[]
[null,"State","Total Number of Producers","Production Volume (2021)"]
[null,null,null,"Food Waste","Landfills","Livestock","Water Treatment Facility","Total","Food Waste","Landfills","Livestock","Water Treatment Facility","Total"]
[null,null,null,"MMBtu/year","Mmbtu/year","MMBtu/year","MMBtu/year","MMBtu/year","MM DGE/year","MM DGE/year","MM DGE/year","MM DGE/year","MM DGE/year"]
[null,null,null,"[1]"]
[null,"East Coast (PADD 1)"]
[null,"Georgia",1,"-",430006.5,"-","-",{"$f":"IF(SUM(D9:G9),SUM(D9:G9),\"-\")","v":430006.5},{"$f":"IFERROR((D9/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E9/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.1049642573471008},{"$f":"IFERROR((F9/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G9/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I9:L9),SUM(I9:L9),\"-\")","v":3.1049642573471008}]
[null,"New York",12,"-",1254635,448146.48879999999,591300,{"$f":"IF(SUM(D10:G10),SUM(D10:G10),\"-\")","v":2294081.4887999999},{"$f":"IFERROR((D10/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E10/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":9.0593905697162249},{"$f":"IFERROR((F10/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.2359483630587045},{"$f":"IFERROR((G10/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":4.2696223554047226},{"$f":"IF(SUM(I10:L10),SUM(I10:L10),\"-\")","v":16.564961288179653}]
[null,"North Carolina",2,"-","-",220000,"-",{"$f":"IF(SUM(D11:G11),SUM(D11:G11),\"-\")","v":220000},{"$f":"IFERROR((D11/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E11/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F11/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.5885623510722795},{"$f":"IFERROR((G11/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I11:L11),SUM(I11:L11),\"-\")","v":1.5885623510722795}]
[null,"Pennsylvania",9,"-",4047101.75,"-","-",{"$f":"IF(SUM(D12:G12),SUM(D12:G12),\"-\")","v":4047101.75},{"$f":"IFERROR((D12/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E12/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":29.223061231857894},{"$f":"IFERROR((F12/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G12/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I12:L12),SUM(I12:L12),\"-\")","v":29.223061231857894}]
[null,"West Virginia",1,"-",145000,"-","-",{"$f":"IF(SUM(D13:G13),SUM(D13:G13),\"-\")","v":145000},{"$f":"IFERROR((D13/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E13/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.0470070041158206},{"$f":"IFERROR((F13/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G13/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I13:L13),SUM(I13:L13),\"-\")","v":1.0470070041158206}]
[null,"Midwest (PADD 2)",null,null,null,null,null,null,{"$f":"IFERROR((D14/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((E14/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((F14/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((G14/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0}]
[null,"Illinois",1,"-",576000,"-","-",{"$f":"IF(SUM(D15:G15),SUM(D15:G15),\"-\")","v":576000},{"$f":"IFERROR((D15/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E15/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":4.159145064625605},{"$f":"IFERROR((F15/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G15/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I15:L15),SUM(I15:L15),\"-\")","v":4.159145064625605}]
[null,"Indiana",1,"-",897552,"-","-",897552,{"$f":"IFERROR((D16/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E16/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":6.4809877969528484},{"$f":"IFERROR((F16/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G16/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},6.4809877969528484]
[null,"Kansas",2,"-",1540000,"-","-",1540000,{"$f":"IFERROR((D17/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E17/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":11.119936457505958},{"$f":"IFERROR((F17/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G17/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},11.119936457505958]
[null,"Kentucky",2,"-",1382572.5,"-","-",1382572.5,{"$f":"IFERROR((D18/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E18/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":9.9831937323994513},{"$f":"IFERROR((F18/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G18/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},9.9831937323994513]
[null,"Michigan",6,"-",2442478.68481,"-",141912,2584390.68481,{"$f":"IFERROR((D19/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E19/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":17.636498554480468},{"$f":"IFERROR((F19/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G19/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.0247093652971333},18.661207919777603]
[null,"Minnesota",1,"-","-",430000,"-",430000,{"$f":"IFERROR((D20/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E20/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F20/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.1049173225503646},{"$f":"IFERROR((G20/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},3.1049173225503646]
[null,"Missouri",4,"-","-",195000,"-",195000,{"$f":"IFERROR((D21/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E21/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F21/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.4080439020867932},{"$f":"IFERROR((G21/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},1.4080439020867932]
[null,"Nebraska",6,190000,542577,"-",174990.258,907567.25800000003,{"$f":"IFERROR((D22/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.371940212289696},{"$f":"IFERROR((E22/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.9178063398079286},{"$f":"IFERROR((F22/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G22/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.2635587984692036},6.5533053505668279]
[null,"Ohio",9,213762.916,6215511.0999999996,"-","-",6429274.0159999998,{"$f":"IFERROR((D23/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.5435260018773918},{"$f":"IFERROR((E23/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":44.880576936962953},{"$f":"IFERROR((F23/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G23/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},46.424102938840342]
[null,"Oklahoma",5,219000,2108766.3300000005,"-","-",2327766.3300000005,{"$f":"IFERROR((D24/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.5813416131128601},{"$f":"IFERROR((E24/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":15.226849086576651},{"$f":"IFERROR((F24/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G24/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},16.808190699689511]
[null,"Tennessee",4,"-",2021314.15,"-","-",2021314.15,{"$f":"IFERROR((D25/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E25/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":14.595379810816665},{"$f":"IFERROR((F25/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G25/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},14.595379810816665]
[null,"Wisconsin",16,1332249,632707.42500000005,1920391.4,264.441258,3885612.2662580004,{"$f":"IFERROR((D26/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":9.6198209256986065},{"$f":"IFERROR((E26/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":4.5686145209040365},{"$f":"IFERROR((F26/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":13.866643078922666},{"$f":"IFERROR((G26/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.909461029677233E-3},28.056987986554986]
[null,"Gulf Coast (PADD 3)",null,null,null,null,null,null,{"$f":"IFERROR((D27/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((E27/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((F27/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((G27/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0}]
[null,"Arkansas",1,"-",534600,"-","-",{"$f":"IF(SUM(D28:G28),SUM(D28:G28),\"-\")","v":534600},{"$f":"IFERROR((D28/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E28/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.8602065131056396},{"$f":"IFERROR((F28/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G28/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I28:L28),SUM(I28:L28),\"-\")","v":3.8602065131056396}]
[null,"Louisiana",5,"-",3514659,"-","-",{"$f":"IF(SUM(D29:G29),SUM(D29:G29),\"-\")","v":3514659},{"$f":"IFERROR((D29/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E29/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":25.378431655715215},{"$f":"IFERROR((F29/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G29/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I29:L29),SUM(I29:L29),\"-\")","v":25.378431655715215}]
[null,"Mississippi",1,"-",497355,"-","-",{"$f":"IF(SUM(D30:G30),SUM(D30:G30),\"-\")","v":497355},{"$f":"IFERROR((D30/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E30/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.591270127807062},{"$f":"IFERROR((F30/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G30/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I30:L30),SUM(I30:L30),\"-\")","v":3.591270127807062}]
[null,"New Mexico",1,"-","-",18067.5,"-",{"$f":"IF(SUM(D31:G31),SUM(D31:G31),\"-\")","v":18067.5},{"$f":"IFERROR((D31/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E31/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F31/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0.13046068308181097},{"$f":"IFERROR((G31/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I31:L31),SUM(I31:L31),\"-\")","v":0.13046068308181097}]
[null,"Texas",21,"-",19687812.175000001,478145,260829,{"$f":"IF(SUM(D32:G32),SUM(D32:G32),\"-\")","v":20426786.175000001},{"$f":"IFERROR((D32/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E32/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":142.16053270994297},{"$f":"IFERROR((F32/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.4525597516066142},{"$f":"IFERROR((G32/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.8833778612174163},{"$f":"IF(SUM(I32:L32),SUM(I32:L32),\"-\")","v":147.49647032276698}]
[null,"Rocky Mountains (PADD 4)",null,null,null,null,null,null,{"$f":"IFERROR((D33/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((E33/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((F33/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((G33/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0}]
[null,"Idaho",3,"-","-",576545,"-",{"$f":"IF(SUM(D34:G34),SUM(D34:G34),\"-\")","v":576545},{"$f":"IFERROR((D34/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E34/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F34/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":4.1630803668134879},{"$f":"IFERROR((G34/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I34:L34),SUM(I34:L34),\"-\")","v":4.1630803668134879}]
[null,"Montana",1,"-",161704.12500000003,"-","-",{"$f":"IF(SUM(D35:G35),SUM(D35:G35),\"-\")","v":161704.12500000003},{"$f":"IFERROR((D35/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E35/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.1676231135822084},{"$f":"IFERROR((F35/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((G35/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I35:L35),SUM(I35:L35),\"-\")","v":1.1676231135822084}]
[null,"Utah",2,985500,"-",236000,"-",{"$f":"IF(SUM(D36:G36),SUM(D36:G36),\"-\")","v":1221500},{"$f":"IFERROR((D36/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":7.1160372590078707},{"$f":"IFERROR((E36/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F36/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.7040941584229907},{"$f":"IFERROR((G36/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IF(SUM(I36:L36),SUM(I36:L36),\"-\")","v":8.8201314174308614}]
[null,"West Coast (PADD 5)",null,null,null,null,null,null,{"$f":"IFERROR((D37/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((E37/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((F37/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0},{"$f":"IFERROR((G37/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0}]
[null,"Arizona",4,"-","-",1362110.4,752424,{"$f":"IF(SUM(D38:G38),SUM(D38:G38),\"-\")","v":2114534.3999999999},{"$f":"IFERROR((D38/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E38/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F38/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":9.8354422702000139},{"$f":"IFERROR((G38/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":5.4330565383782226},{"$f":"IF(SUM(I38:L38),SUM(I38:L38),\"-\")","v":15.268498808578236}]
[null,"California",72,927641.42999999993,200715.06599999999,3724829.0584327797,559184.77099999995,{"$f":"IF(SUM(D39:G39),SUM(D39:G39),\"-\")","v":5412370.3254327793},{"$f":"IFERROR((D39/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":6.6982556863311427},{"$f":"IFERROR((E39/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.4493108960935808},{"$f":"IFERROR((F39/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":26.896014574574192},{"$f":"IFERROR((G39/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":4.0377267022889738},{"$f":"IF(SUM(I39:L39),SUM(I39:L39),\"-\")","v":39.081307859287882}]
[null,"Oregon",3,"-","-",1587472,100000,{"$f":"IF(SUM(D40:G40),SUM(D40:G40),\"-\")","v":1687472},{"$f":"IFERROR((D40/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((E40/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":"-"},{"$f":"IFERROR((F40/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":11.462719329915517},{"$f":"IFERROR((G40/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":0.72207379594194532},{"$f":"IF(SUM(I40:L40),SUM(I40:L40),\"-\")","v":12.184793125857462}]
[null,"Washington",6,4237.6500000000005,3458831,160000,332304,{"$f":"IF(SUM(D41:G41),SUM(D41:G41),\"-\")","v":3955372.65},{"$f":"IFERROR((D41/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":3.0598960213733848E-2},{"$f":"IFERROR((E41/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":24.975312296916744},{"$f":"IFERROR((F41/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":1.1553180735071125},{"$f":"IFERROR((G41/'Fuel Consumption + Conversions'!$E$16),\"-\")","v":2.3994801068669216},{"$f":"IF(SUM(I41:L41),SUM(I41:L41),\"-\")","v":28.56070943750451}]
[null,"PADD 1",{"$f":"SUM(C9:C13)","v":25},{"$f":"SUM(D9:D13)","v":0},5876743.25,668146.48879999993,591300,7136189.7388000004,0,42.434423063037038,4.8245107141309838,4.2696223554047226,51.528556132572746]
[null,"PADD 2",{"$f":"SUM(C15:C26)","v":57},{"$f":"SUM(D15:D26)","v":1955011.916},18359479.18981,2545391.4,317166.69925800001,23177049.205068,14.116628752978555,132.56898830103256,18.379604303559823,2.2901776247960139,167.35539898236695]
[null,"PADD 3",{"$f":"SUM(C28:C32)","v":29},{"$f":"SUM(D28:D32)","v":0},24234426.175000001,496212.5,260829,24991467.675000001,0,174.9904410065709,3.5830204346884251,1.8833778612174163,180.45683930247671]
[null,"PADD 4",{"$f":"SUM(C34:C36)","v":6},{"$f":"SUM(D34:D36)","v":985500},161704.12500000003,812545,0,1959749.125,7.1160372590078707,1.1676231135822084,5.8671745252364786,0,{"$f":"SUM(M34:M36)","v":14.150834897826558}]
[null,"PADD 5",{"$f":"SUM(C38:C41)","v":85},{"$f":"SUM(D38:D41)","v":931879.08},3659546.0660000001,6834411.4584327796,1743912.7709999999,13169749.37543278,6.7288546465448764,26.424623193010326,49.349494248196834,12.592337143476062,{"$f":"SUM(M38:M41)","v":95.0953092312281}]
[null,"US Total",{"$f":"SUM(C42:C46)","v":202},3872390.9960000003,52291898.805810004,11356706.847232779,2913208.4702580003,70434205.119300783,27.961520658531299,377.58609867723305,82.003804225812544,21.035514984894213,508.58693854647106]
[]
[null,"Sources and Notes:"]
[null,"Conversions: Alternative Fuels Data Center, https://afdc.energy.gov/fuels/properties"]
[null,"[1]: Summation by state of the facilities' capacities listed in the Energy Vision Renewable Natural Gas Project Database, https://energy-vision.org/rng-project-database/. This represents a conservative estimate, as there are facilities listed without publicly available capacities."]

{"sheet":"Propane Consumption Forecast","index":19,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Propane Consumption Forecast"]
[]
[null,"Fuel Type","Unit","Citation Reference","2021","2022","2023","2024"]
[null,"Propane","MM Gallons","[1]",{"$f":"'Propane EIA Data'!F$5*'Propane EIA Data'!$F$9","v":1.9736442305355018},{"$f":"'Propane EIA Data'!G$5*'Propane EIA Data'!$F$9","v":2.2983129784158005},{"$f":"'Propane EIA Data'!H$5*'Propane EIA Data'!$F$9","v":2.4811527469589163},{"$f":"'Propane EIA Data'!I$5*'Propane EIA Data'!$F$9","v":2.547795279418557}]
[]
[null,"Sources and Notes:"]
[null,"[1]: 'Propane Consumption Forecast.' Using Washington's historical consumption BRG has allocated the projected propane consumption using the U.S. EIA AEO Pacific Consumption Forecast. Due to an identified data limitation BRG relied upon the average allocation to Washington from 2014 through 2019."]

{"sheet":"Propane Availability","index":20,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[5,2,5,4]]}
[]
[null,"Propane Production Availability (2022)"]
[]
[null,"Conversion","Barrels to Gallons",42]
[]
[null,"PADD","Production Volume"]
[null,null,"Natural Gas Field Plant Production","Refinery Production","Total "]
[null,null,"Thousand barrels/year","Thousand barrels/year","MM gal/year"]
[null,null,"[1]","[2]"]
[null,"East Coast (PADD 1)"]
[null,"East Coast",47,4667,{"$f":"(SUM(C11:D11)*$D$4)/1000","v":197.988}]
[null,"Appalachia",82504,294,3477.5160000000001]
[null,"Midwest (PADD 2)"]
[null,"IN, IL, and KY",24124,17488,1747.704]
[null,"MN, WI, ND, SD",50862,3328,{"$f":"(SUM(C15:D15)*$D$4)/1000","v":2275.98}]
[null,"OK, KS, MO",58178,5429,2671.4940000000001]
[null,"Gulf Coast (PADD 3)"]
[null,"TX Inland",277527,3231,11791.835999999999]
[null,"TX Gulf Coast",14152,27825,1763.0340000000001]
[null,"LA Gulf Coast",20583,24032,{"$f":"(SUM(C20:D20)*$D$4)/1000","v":1873.83}]
[null,"N. LA, AK",1708,142,77.7]
[null,"NM",36093,358,1530.942]
[null,"Rocky Mountains (PADD 4)",67943,2839,2972.8440000000001]
[null,"West Coast (PADD 5)",2993,11692,616.77]
[null,"PADD 1",{"$f":"SUM(C11:C12)","v":82551},{"$f":"SUM(D11:D12)","v":4961},{"$f":"SUM(E11:E12)","v":3675.5039999999999}]
[null,"PADD 2",{"$f":"SUM(C14:C16)","v":133164},{"$f":"SUM(D14:D16)","v":26245},{"$f":"SUM(E14:E16)","v":6695.1779999999999}]
[null,"PADD 3",{"$f":"SUM(C18:C22)","v":350063},{"$f":"SUM(D18:D22)","v":55588},{"$f":"SUM(E18:E22)","v":17037.342000000001}]
[null,"PADD 4",{"$f":"C23","v":67943},{"$f":"D23","v":2839},2972.8440000000001]
[null,"PADD 5",{"$f":"C24","v":2993},11692,616.77]
[null,"US",{"$f":"SUM(C10:C24)","v":636714},{"$f":"SUM(D10:D24)","v":101325},{"$f":"SUM(E10:E24)","v":30997.637999999999}]
[]
[null,"Sources and Notes"]
[null,"Conversions: U.S. Energy Information Administration, FAQ, https://www.eia.gov/energyexplained/units-and-calculators/"]
[null,"[1]: U.S. Energy Information Administration, Natural Gas Plant Field Production, accessed as of Sept. 2, 2022. https://www.eia.gov/dnav/pet/pet_pnp_gp_a_EPLLPA_FPF_mbbl_a.htm"]
[null,"[2]: U.S. Energy Information Administration, Refinery Net Production, accessed as of Sept. 2, 2022. https://www.eia.gov/dnav/pet/pet_pnp_refp2_a_EPLLPA_YPY_mbbl_a.htm"]

{"sheet":"Data Sources-->","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Gas & Diesel Forecast Data","index":22,"n_rows":22,"n_cols":21,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,2,1,12],[2,2,2,10]]}
[]
[null,null,"Transportation Revenue Forecast Council\nTable A. 1. Washington Motor Fuel Consumption Fiscal Year Forecast June 2022"]
[null,null,null,null,null,null,null,null,null,null,null,"Current\nBiennia"]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031]
[null,null,"Million Gallons"]
[null,null,"Gasoline (June 2022 Forecast)",2716,2757,2844,2887,2966,2905,2734,2494,2659,2719,2762,2795,2815,2834,2853,2871,2890,2909]
[null,null,"Annual Percentage Change",1.4999999999999999E-2,1.4999999999999999E-2,3.1E-2,1.4999999999999999E-2,2.8000000000000001E-2,-2.1000000000000001E-2,-5.8999999999999997E-2,-8.7999999999999995E-2,6.6000000000000003E-2,2.3E-2,1.6E-2,1.2E-2,7.0000000000000001E-3,7.0000000000000001E-3,7.0000000000000001E-3,6.0000000000000001E-3,7.0000000000000001E-3,6.0000000000000001E-3]
[null,null,"Gasoline (Feb. 2022 Forecast)",2716,2757,2844,2887,2966,2905,2734,2494,2659,2719,2762,2795,2815,2834,2853,2871,2890,2909]
[null,null,"Percentage Change,  June 2022  vs Feb. 2022",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Diesel (June 2022 Forecast)",656,663,676.2,675,678,689,710,726,777,782,791,803,816,829,841,854,860,866]
[null,null,"Annual Percentage Change",0.03,0.01,0.02,-2E-3,5.0000000000000001E-3,1.4999999999999999E-2,3.1E-2,2.1999999999999999E-2,7.0000000000000007E-2,7.0000000000000001E-3,1.0999999999999999E-2,1.6E-2,1.6E-2,1.6E-2,1.4999999999999999E-2,1.4999999999999999E-2,7.0000000000000001E-3,7.0000000000000001E-3]
[null,null,"Diesel (Feb. 2022 Forecast)",656,663,676.2,675,678,689,710,726,754,772,783,793,803,813,823,832,842,852]
[null,null,"Percentage Change,  June 2022  vs Feb. 2022",0,0,0,0,0,0,0,0,0.03,1.4E-2,0.01,1.2999999999999999E-2,1.6E-2,1.9E-2,2.1999999999999999E-2,2.5999999999999999E-2,2.1000000000000001E-2,1.6E-2]
[null,null,"Total Motor Fuel (June 2022 Forecast)",3373,3420,3520,3562,3645,3593,3444,3220,3435,3501,3552,3599,3631,3662,3694,3725,3750,3774]
[null,null,"Annual Percentage Change",1.7999999999999999E-2,1.4E-2,2.9000000000000001E-2,1.2E-2,2.3E-2,-1.4E-2,-4.2000000000000003E-2,-6.5000000000000002E-2,6.7000000000000004E-2,1.9E-2,1.4999999999999999E-2,1.2999999999999999E-2,8.9999999999999993E-3,8.9999999999999993E-3,8.9999999999999993E-3,8.0000000000000002E-3,7.0000000000000001E-3,6.0000000000000001E-3]
[null,null,"Total Motor Fuel (Feb. 2022 Forecast)",3373,3420,3520,3562,3645,3593,3444,3220,3413,3491,3545,3588,3618,3647,3676,3703,3732,3761]
[null,null,"Percentage Change,  June 2022  vs Feb. 2022",0,0,0,0,0,0,0,0,7.0000000000000001E-3,3.0000000000000001E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3,6.0000000000000001E-3,5.0000000000000001E-3,4.0000000000000001E-3]
[]
[]
[]
[null,null,"Source:"]
[null,null,"Washington Office of Financial Management, June 2022 Transportation Revenue Forecasts, https://ofm.wa.gov/budget/budget-related-information/transportation-revenue-information"]

{"sheet":"Vehicle Stock Forecast","index":23,"n_rows":48,"n_cols":21,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Washington Vehicle Stock Forecast"]
[null,null,null,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031]
[null,"Vehicles paying Basic License Fee ($30)"]
[null,null,"Passenger Car and Cabs",4529669,4707553,4908456,5060804,5187649,5204763,5102400,5519519,5400000,5433159,5548000,5662873,5777753,5891612,5968428,6044049,6120658,6196997]
[null,null,"Motorhomes",65975,66913,68720,69000,68917,67618,64100,74078,71000,71160,71320,71486,71651,71812,71970,72124,72278,72430]
[null,null,"Travel Trailers",126313,132569,142484,149700,159651,162387,160400,194295,190000,190222,190999,192917,194895,196852,198869,200866,202923,204960]
[null,null,"Motorcycles",229822,236384,236134,231400,235531,232369,221400,245409,225000,226125,227256,228392,229534,230682,231835,232994,234159,235330]
[null,null,"Other Trailers",107205,102538,115059,129900,120791,122369,128000,137650,150000,150175,150244,150991,151763,152518,153297,154059,154846,155617]
[null,null,"Tow Trucks",1390,1351,1389,1400,1359,1330,1300,1385,1400,1393,1386,1379,1372,1365,1359,1352,1345,1338]
[null,null,null,5060374,5247308,5472242,5642204,5773898,5790836,5677600,6172336,6037400,6072234,6189204,6308038,6426968,6544841,6625757,6705444,6786210,6866673]
[null,"Vehicles paying Weight-based Registration Fee (Trucks)"]
[null,null,"Trucks",1459229,1489331,1539232,1578707,1599439,1605565,1605500,1753701,1733000,1784145,1828749,1865324,1893303,1911925,1931657,1948349,1964983,1981700]
[null,null,"For Hire, Buses, Stages",3225,3591,3760,4100,4434,4148,3500,3484,3800,4249,4673,5047,5350,5561,5790,5990,6195,6406]
[null,null,"Comb. Lic. Fee Trailers",67337,70728,76964,84300,94277,97838,95000,106411,110000,114328,118139,121290,123716,125338,127063,128527,129990,131464]
[null,null,"Prorate Motor Vehicles",27662,28233,29179,28600,30801,25347,25300,25659,29000,29856,30602,31214,31683,31994,32324,32604,32882,33162]
[null,null,null,1557453,1591883,1649135,1695707,1728951,1732898,1729300,1889255,1875800,1932578,1982164,2022875,2054052,2074818,2096834,2115469,2134050,2152732]
[null,"Vehicles paying varying fees"]
[null,null,"Restored and Antiques",9631,10771,10769,20700,29089,26524,25700,32776,34000,34170,34341,34513,34685,34859,35033,35208,35384,35561]
[null,null,"Campers",24177,23513,23358,22600,22118,20783,19100,21293,19200,18816,18440,18071,17709,17355,17008,16668,16335,16008]
[null,null,"Mopeds",9040,8978,8671,7800,7391,6818,6200,6637,5850,5792,5734,5676,5619,5563,5508,5453,5398,5344]
[null,null,"Exempt",6404,8258,8542,9000,8334,9104,7700,7040,7200,7500,7500,7500,7500,7500,7500,7500,7500,7500]
[null,null,null,49252,51520,51340,60100,66932,63200,58700,67746,66250,66278,66014,65760,65514,65277,65049,64829,64617,64413]
[]
[null,"Personal Trailers",null,440741,454511,449369,439300,458925,449177,432400,490483,432000,435055,438125,442355,453880,465631,477778,490118,502878,515836]
[null,"Intermittent-Use Trailers",null,"      -","-","-",100,575,1788,2300,2943,3600,4200,4890,5680,6470,7110,7700,8130,8410,8550]
[]
[null,"Total Highway Vehicles",null,6667081,6890713,7622088,7837500,8029283,8037930,7900400,8812236,8415050,8510345,8680396,8844707,9006884,9157678,9273118,9383990,9496164,9608204]
[]
[null,"Off Road Vehicles",null,82244,83606,84783,91400,97909,95935,102300,115900,114100,115660,115420,115420,115420,115420,115420,115420,115420,115420]
[null,null,"Wheeled All Tertain Vehicles",906,3875,21327,37400,51048,49647,55400,66430,68800,70490,70750,70750,70750,70750,70750,70750,70750,70750]
[]
[null,"Snowmobiles",null,24688,20201,25148,25200,23268,22753,22500,25100,23190,23420,23420,23490,23490,23490,23490,23490,23490,23490]
[null,null,"Vintage Snowmobiles",286,266,373,300,219,220,200,220,211,200,210,210,210,210,210,210,210,210]
[null,null,"Regular Snowmobiles",24402,19935,24775,24900,23049,22533,22400,24880,22979,23220,23210,23280,23280,23280,23280,23280,23280,23280]
[null,"Total Registrations",null,6774013,6994520,7732019,7954100,8150460,8156618,8025300,8953000,8552340,8649425,8819236,8983617,9145794,9296588,9412028,9522900,9635074,9747114]
[]
[null,"Vehicles subject to additional renewal fees"]
[null,null,"BEV ( Battery Electric Vehicles)",4976,8047,11737,14500,20867,22700,30500,43000,54471,72648,92434,114623,138103,161456,184549,207273,229872,252866]
[null,null,"PHEV (Plug-in Hybrid Vehciles)",1055,1647,2130,2300,3051,5000,6500,8000,8924,10363,11755,13063,14341,15550,16684,17744,18745,19712]
[null,null,"HV (Hybrid or Alt. Fuel Vehicles)",0,0,0,0,0,0,85200,141000,158526,161700,164930,168230,171590,175020,178520,182090,185730,189440]
[null,null,"EM (Electric Motorcycles)","-","-","-","-","-","-","-","-","-",153,344,516,619,743,892,1070,1284,1541]
[null,"Private Motorized Vehicles",null,6335643,6553105,6806310,7002600,7164610,7174482,7055500,7852000,7503050,7590048,7752060,7905903,8050951,8185373,8283903,8378122,8473283,8568269]
[]
[]
[]
[null,"Source:"]
[null,"Washington Office of Financial Management, June 2022 Transportation Revenue Forecasts, https://ofm.wa.gov/budget/budget-related-information/transportation-revenue-information"]

{"sheet":"CNG Vehicle Registrations","index":24,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Washington CNG Vehicle Use Analysis"]
[]
[null,null,"CNG Vehicles"]
[null,null,null,"Weighted Average Fuel Economy (MPGe)","[1]",22.869565217391305]
[null,null,null,"Average Per Capita VMT in Washington (2017)","[2]",8272]
[null,null,null,"Washington Avg. Annual CNG Consumption/Vehicle (GGE)","[3]",361.70342205323198]
[null,null,null,"Total Number of CNG Vehicles","[4]",276]
[]
[null,null,"Sources:"]
[null,null,"[1]: BRG Calculation"]
[null,null,"[2] Eno Trans, VMT per Capita by State 1981-2017, https://www.enotrans.org/wp-content/uploads/2019/06/VMT-per-capita-by-state-1981-2017-1.pdf"]
[null,null,"[3]: BRG Calculation"]
[null,null,"[4] Washington Department of Licensing, Vehicle Registration Transactions Data, https://data.wa.gov/Transportation/Vehicle-Registration-Transactions-by-Department-of/brw6-jymh/data"]

{"sheet":"Washington EV Data","index":25,"n_rows":22,"n_cols":32,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Washington Electric Vehicle Use Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Average Fuel Economy (Kwh/100 miles)","Average Per Capita VMT in Washington (2017)","Washington Avg. Annual Electricity Consumption/BEV (Kwh)",null,"Weighted Average Fuel Economy (kWh/100 miles)","Weighted Average Fuel Economy (kWh/mile)","Weighted Average Electric Range (Miles)","Weighted Average Electric Range Used (Miles)","Estimated Electricity Use/Year/PHEV"]
[]
[null,null,"Battery Electric Vehicles (BEV)"]
[null,null,null,"Weighted Average Fuel Economy (Kwh/100 miles)","[1]",28.934527561812704]
[null,null,null,"Average Per Capita VMT in Washington (2017)","[2]",8272]
[null,null,null,"Washington Avg. Annual Electricity Consumption (kWh/BEV)","[3]",2393.4641199131502]
[]
[]
[null,null,"Plug-in Hybrid Electric Vehicles (PHEV)"]
[null,null,null,"Weighted Average Fuel Economy (kWh/100 miles)","[4]",33.41911318080583]
[null,null,null,"Weighted Average Fuel Economy (kWh/mile)","[5]",0.33419113180805832]
[null,null,null,"Weighted Average Electric Range (Miles)","[6]",30.815043531079166]
[null,null,null,"Estimated VMT Using Electricity","[7]",{"$f":"MIN($F$6*0.9,F13*365)","v":7444.8}]
[null,null,null,"Estimated Electricity Use/Year/PHEV (kWh/PHEV)","[8]",{"$f":"(F14/100)*F11","v":2487.9861380846328}]
[]
[]
[null,null,"Sources and Notes:"]
[null,null,"[1]: BRG analysis based on Washington Electric Vehicle Population Data, https://data.wa.gov/Transportation/Electric-Vehicle-Population-Data/f6w7-q2d2"]
[null,null,"[2] Eno Trans, VMT per Capita by State 1981-2017, https://www.enotrans.org/wp-content/uploads/2019/06/VMT-per-capita-by-state-1981-2017-1.pdf"]
[null,null,"[3]-[6]: BRG analysis based on Washington Electric Vehicle Population Data, https://data.wa.gov/Transportation/Electric-Vehicle-Population-Data/f6w7-q2d2"]
[null,null,"[8]: BRG analysis based on Washington Electric Vehicle Population Data, https://data.wa.gov/Transportation/Electric-Vehicle-Population-Data/f6w7-q2d2"]

{"sheet":"Propane EIA Data","index":26,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,5,7,7],[8,5,8,7]]}
[]
[null,null,"Pacific Transportation Sector Propane Consumption Forecast"]
[null,null,"Fuel Type","Units","Source",2021,2022,2023,2024]
[null,null,"Propane","Quads","[1]",1.155E-3,1.3450000000000001E-3,1.4519999999999999E-3,1.4909999999999999E-3]
[null,null,"Propane","MM Gallons",null,{"$f":"((F4*(10^15))/'Fuel Consumption + Conversions'!$E$17)/1000000","v":12.633996937212864},{"$f":"((G4*(10^15)/'Fuel Consumption + Conversions'!$E$17)/1000000)","v":14.712316779698096},{"$f":"((H4*(10^15)/'Fuel Consumption + Conversions'!$E$17)/1000000)","v":15.882739006781886},{"$f":"((I4*(10^15)/'Fuel Consumption + Conversions'!$E$17)/1000000)","v":16.309341500765697}]
[]
[null,null,"Washington Allocation of Transportation Sector Propane Consumption in the Pacific Region"]
[null,null,"Fuel Type","Units","Source","2014-2019 Consumption Average"]
[null,null,"Propane","%","[2]",0.15621693121693123]
[]
[]
[null,null,"Source: "]
[null,null,"[1]: U.S. Energy Information Administration, AEO 2022, https://www.eia.gov/outlooks/aeo/data/browser/#/?id=2-AEO2022&region=1-9&cases=ref2022&start=2020&end=2050&f=A&linechart=ref2022-d011222a.3-2-AEO2022.1-9&map=ref2022-d011222a.4-2-AEO2022.1-9&sourcekey=0https://www.eia.gov/outlooks/aeo/data/browser/#/?id=2-AEO2022&region=1-9&cases=ref2022&start=2020&end=2050&f=A&linechart=ref2022-d011222a.3-2-AEO2022.1-9&map=ref2022-d011222a.4-2-AEO2022.1-9&sourcekey=0"]
[null,null,"[3]: Washington consumption as a percentage of the Pacific Region's Propane Consumption, U.S. Energy Information Administration, Table CT7, Transportation Sector Energy Consumption Estimates, 1960-2020, Washington; https://www.eia.gov/state/seds/data.php?incfile=/state/seds/sep_use/tra/use_tra_WA.html&sid=WA "]