36C24619R0069-004.xlsx

XLSX spreadsheet 976 KB Posted

Attached to
652-19-104 Expand Steam Distribution System (VA-19-00017584)
Solicitation number
36C24619R0069
Issued by

About this file

From the source

36C24619R0069 Attachment_J_FY18 Rmond Utility Report 171020.xlsx

View the file

Other files

File Type Posted
36C24619R0069-002.pdf PDF
36C24619R0069-005.pdf PDF
36C24619R0069-001.docx DOCX document
36C24619R0069-003.pdf PDF
36C24619R0069-000.docx DOCX document

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Quarterly Utilities Report

Fiscal Year
Heating Degree DaysCooling Degree DaysB500 Electricity (kWh)
Acct No. 9826392509B507 Electricity (kWh)
Acct No. 2182365003B509 Electricity (kWh)
Acct No. 9124909459B513 Electricity (kWh)
Acct No. 4196918785Emergency Trailer (kWh)
Acct No. 3612434021B508 Electricity (kWh)
Acct No. 5822576053B 512 Electricity (kWh)
Acct No. 6108064525B514 Electricity (kWh)

Acct No. 7416754831 Trailer Park Electricity (kWh) Acct No. 0334801925 (Established 3/23/2018) Electricity Total Usage (kWh) B500 Electricity Acct # 9826392509 ($$) B507 Electricity Acct # 2182365003 ($$) B509 Electricity Acct # 9124909459 ($$) B513 Electricity Acct # 4196918785 Csumption ($$) Emergency Trailer Electricity Acct # 3612434021 ($$) B508 Electricity Acct # 5822576053 ($$) B 512 Electricity Acct # 6108064525 ($$) B514 Electricity Acct # 7416754831 Trailer Park Electricity Acct No. 0334801925 (Established 3/23/2018) Electricity Total ($$) B500 Meter 15582027 Natural Gas

(CCF)

Acct. No. 251087-0131120 B501 Meter 0811524 Natural Gas

(CCF)

Acct. No. 251087-0131120 B501 NG Total

(CCF)

Acct. No. 251087-0131120B514 Natural Gas Acct # 251087-0204008 (CCF)
Meter No. 15018988 + Meter No. 01022027Natural Gas Total (CF)B501 LVS II ($$)
Acct No. 251087-0131120B501 WACCOG ($$)
Acct No. 251087-0131120B501 LVS II Demand ($$)
Acct No. 251087-0131120B501 LVS II Customer Charge ($$)
Acct No. 251087-0131120B501 Total Natural Gas Cost
Acct No. 251087-0131120B501 NG Tax Industrial ($$)
Acct No. 251087-0131120B514 Gas Comm. Distribution ($$)

Acct No. 251087-0204008 Meter No. 15018988 B514 Purchased Gas Cost ($$) Acct No. 251087-0204008 Meter No. 15018988 B514 Gas Comm. Distribution Base Fee ($$) Acct No. 251087-0204008 Meter No. 01022027 B514 Purchased Gas ($$) Acct No. 251087-0204008

Meter No. 01022027NG Total ($$)Water meter, # 31000033 (CCF)
Acct No.251087-0131120 (8984)Water meter, # 31000027 (CCF)
Acct No. 251087-0131120 (8985)Water Acct # 251087-0131120 Total (CCF)Water Acct # 251087-0131120 Total (GAL)Water Total (Thousands of Gallons)Water Meter # 31000033 ($$)

Acct No. 251087-0131120

Water Meter # 31000027 ($$)
Acct No. 251087-0131120Water Total ($$)
Acct No. 251087-0131120Waste Water ($$) Water Meter # 31000033
Broad RockWaste Water ($$) Water Meter # 31000027
HopkinsStorm Waste Surcharge Program (SWSP) ($)

Acct No. 251087-0131120 Nitrogen Concentrations Sewer Total ($$) Propane (Gal) Propane Cost per Gal ($$) Fuel Oil Total (Gal) Fuel Oil Cost per Gal ($$)

(Ask Heather) or https://www.eia.gov/petroleum/data.php#prices Fuel Oil Cost ($$) Gasoline Consumption VA Owned Veh--equip (Gal) Gasoline VA Owned Veh--Equip Cost per Gal ($$)

https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_r1z_m.htmGasoline Cost VA Owned Veh--Equip ($$)Diesel Fuel Quantity Equip (Gal)
[Generators]Diesel Fuel Quantity Equip ($$/Gal)
(Ask Heather)Diesel Fuel Cost Equip ($$)Laundry PoundsLaundry Electricity Usage (kWh)Laundry Estimated Steam Generated (lbs)Estimating FactorLaundry Natural Gas Usage (Cu ft)
Novitzki, Frank: Novitzki, Frank: Actual values computed from daily boiler logsLaundry Estimated Water Usage (Thousands of Gal)Campus Quarterly Stormwater Fee
($)Laundry Estimated Natural Gas Usage (MBTU)
MonthNational Climatic Data CenterNational Climatic Data CenterDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerDominion Virginia PowerCity of RichmondCity of RichmondCity of RichmondCity of RichmondCity of RichmondCity of RichmondCity of RichmondCity of Richmond
(CCF)Boiler natural gas
(CF)natural gas monthly total BTUfuel oil monthly total BTU.
OCT-17122843,093,44142,97214,0808,4802,51725,28015,84654,6403,257,256$ 200,469$ 3,569$ 1,175$ 763$ 236$ 1,665$ 1,481$ 3,754$ 213,112871,01071,0182,1257,314,300$ 4,474$ 20,362$ 5,818$ 645$ 31,299$ - 0$ 62$ 42$ 1,029$ 914$ 33,3468837,0757,9585,936,6685,937$ 4,090$ 29,417$ 33,507$ 6,784$ 34,288
NOV-1747662,607,81139,73613,6007,7605,21521,92013,41738,4002,747,859$ 171,949$ 3,516$ 1,110$ 715$ 446$ 1,609$ 1,258$ 3,077$ 183,67912108,110108,1223,49011,161,200$ 6,812$ 26,040$ 5,818$ 645$ 39,315$ 269$ 229$ 1,341$ 41,1546596,1256,7845,060,8645,061$ 3,185$ 25,579$ 28,764$ 5,213$ 37,388
DEC-1775802,472,33954,27515,3608,8808,36723,44012,97831,0402,626,679$ 171,979$ 4,420$ 1,252$ 821$ 691$ 1,625$ 1,218$ 2,607$ 184,61212117,890117,9023,96512,186,700$ 7,428$ 29,563$ 5,818$ 645$ 43,453$ 449$ 391$ 1,560$ 1,393$ 47,2476104,4115,0213,745,6663,746$ 2,987$ 18,654$ 21,642
Novitzki, Frank: Includes erroneous NITROGEN CONCENTRATIONS charge or $775.30.$ 4,869$ 31,237$ 6,167$ 36,106141$ - 0195$ 2.31$ 45112$ 2.60$ 30408,17744,899- 099.819,610460
8,631,794$ 581,40330,662,200$ 114,067$ 121,74714,744$ 83,913
JAN-1890602,467,91667,06919,20012,48012,99427,76012,22030,4002,650,039$ 173,991$ 5,203$ 1,518$ 1,180$ 1,054$ 2,048$ 1,151$ 2,669$ 188,81316166,960166,9765,97517,295,100$ 10,519$ 53,035$ 6,453$ 645$ 70,653$ 826$ 731$ 2,186$ 1,958$ 76,3537305,1615,8914,394,6864,395$ 3,472$ 5,711$ 9,183$ 5,711$ 35,866$ 6,167$ 41,5770
FEB-1848062,280,31051,27617,44010,0007,53722,0807,65529,2002,425,498$ 155,095$ 4,111$ 1,384$ 1,003$ 629$ 1,533$ 730$ 2,414$ 166,8999128,751128,7604,10913,286,900$ 8,112$ 36,380$ 6,453$ 645$ 51,590$ 405$ 410$ 1,467$ 1,527$ 55,3988524,9025,7544,292,4844,292$ 3,965$ 20,638$ 24,603$ 6,567$ 34,681$ 6,167$ 41,24899
MAR-18286192,511,16551,78516,2407,9206,80524,2409,99032,8002,660,945$ 176,612$ 4,244$ 1,361$ 774$ 572$ 1,803$ 947$ 2,876$ 189,1899120,190120,1993,68912,388,800$ 7,573$ 44,499$ 6,453$ 645$ 59,170$ 445$ 452$ 1,582$ 1,649$ 63,2971,3694,9166,2854,688,6104,689$ 6,054$ 20,695$ 26,748$ 10,193$ 34,779$ 6,167$ 44,97265
Frank Novitzki: Per Heather's emails 3/1/18 & 3/6/18$ 3.00$ 3,318337,19537,091- 099.81,790380$ 5,869.50
7,736,482$ 544,90142,970,800$ 181,412$ 195,04913,376$ 60,534$ 127,797164

APR-18 286 19 2,477,930 44,911 15,680 7,840 5,526 24,640 11,390 35,840 880 2,623,757 $ 171,179 $ 3,985 $ 1,261 $ 720 $ 472 $ 1,692 $ 1,066 $ 2,947 $ 108 $ 183,322 10 125,300 125,310 4,001 12,931,100 $ 7,895 $ 32,790 $ 6,453 $ 645 $ 47,782 $ 203 $ 151 $ 1,225 $ 970 $ 50,331 993 5,422 6,415 4,785,590 4,786 $ 4,535 $ 22,739 $ 27,273 $ 7,556 $ 38,328 $ 6,167 $ 45,884 76 $ 2.76 $ 210 0 $ 2.78 $ - 0 $ - 0 138,567 15,242 Novitzki, Frank: Estimated based on average #/kWH.

Actual values not available beccause VA advanced metering contract expired.- 099.830,040156$ 5,869.50
MAY-1852702,691,85836,26713,8407,3603,35224,48013,44048,8801,4402,839,477$ 182,317$ 3,262$ 1,103$ 302$ 1,633$ 1,245$ 1,245$ 3,774$ 153$ 194,882891,87091,8782,7619,463,900$ 5,788$ 25,130$ 6,453$ 645$ 38,017$ 54$ 15$ 44$ 113$ 38,2441,4375,4316,8685,123,5285,124$ 6,328$ 22,775$ 29,103$ 10,670$ 35,894$ 6,167

Novitzki, Frank: Estimated based on average #/kWH.

Actual values not available beccause VA advanced metering contract expired.

- 099.823,340178$ 5,869.50
JUN-1803553,362,33645,00116,7208,9602,99330,00018,33668,8802,0003,553,226$ 211,789$ 3,854$ 1,445$ 796$ 315$ 2,298$ 2,190$ 4,742$ 213$ 227,430880,65080,6582,5438,320,100$ 5,081$ 23,293$ 6,453$ 645$ 35,473$ 52$ 28$ 1,036$ 792$ 37,3811,5386,4447,9825,954,5725,955$ 6,214$ 26,034$ 32,247$ 11,378$ 37,466$ 6,167$ 48,844

Novitzki, Frank: Estimated based on average #/kWH.

Actual values not available beccause VA advanced metering contract expired.

- 099.820,180180$ 5,869.50
9,016,460$ 605,63430,715,100$ 121,272$ 125,95615,865$ 88,624$ 141,292216$ 597$ - 0150$ 44950,238--
JUL-1804123,495,51249,14616,0809,5203,91026,64020,55866,3201,4403,495,512$ 155,543$ 2,904$ 996$ 695$ 293$ 1,256$ 2,062$ 3,635$ 154$ 155,543769,86069,8672,0517,191,800$ 4,541$ 20,486$ 6,664$ 666$ 32,357$ 52$ 28$ 1,126$ 862$ 34,4271,7057,0068,7116,498,4066,498$ 7,962$ 31,177$ 39,139$ 12,709$ 40,363$ 6,167$ 53,072
AUG-1804543,330,51946,38414,3208,2403,41625,68017,74763,2004,0803,509,506$ 216,838$ 4,074$ 1,248$ 789$ 363$ 1,763$ 2,131$ 4,759$ 432$ 231,963772,39072,3972,2277,462,400$ 4,706$ 21,860$ 6,664$ 666$ 33,895$ 52$ 28$ 1,126$ 862$ 35,9641,7397,0988,8376,592,4026,592$ 8,109$ 31,573$ 39,682$ 12,947$ 39,311$ 5,911$ 52,259
SEP-1803493,747,22851,81514,2409,2003,53735,20021,42770,5604,4803,953,207$ 242,682$ 4,533$ 1,216$ 892$ 375$ 2,731$ 2,568$ 5,278$ 474$ 260,276872,77072,7782,4687,524,600$ 4,731$ 18,229$ 6,664$ 666$ 30,289$ 142$ 98$ 1,161$ 889$ 32,5791,7267,8229,5487,122,8087,123$ 8,053$ 34,694$ 42,746$ 12,856$ 55,240$ 5,911$ 68,096
10,958,225$ 647,78222,178,800$ 96,541$ 102,97020,213$ 121,567$ 173,427

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69

$ 10,163 SEP-MAY total 0.20 $ 2,549 $ 2,549 0.11 Frank Novitzki: Estimating factor copied from FY16 Rmond Utility Report 170203 (Autosaved).xlsx, BK34

Novitzki, Frank: FN estimate 5/19/15 Novitzki, Frank: Novitzki, Frank:

Add account CCFs within cell Novitzki, Frank: Estimated based on average #/kWH.

Actual values not available beccause VA advanced metering contract expired.

Novitzki, Frank: Estimated based on average #/kWH.

Actual values not available beccause VA advanced metering contract expired.

Novitzki, Frank: Estimated based on average #/kWH.

Actual values not available beccause VA advanced metering contract expired.

144.62 $ 508.17 5% of total $ 227 $ 70,929.96 43420 Diesel Fuel Quantity Equip (Gal) [Generators]

36,342,961326.91$ 1,400.00per unit cost166976126,526,900$ 1,90843434
6766.194# of units`TRUE43465
315.64$ 5,600.00total cost1-NOV-17
26.3111.0198258474simple paybackNOV-171-NOV-174304043040
631.294310043100
-2848.77129750
5078.6937,210434652017-Apr2.5052.5162.5222.5202.52
3735.382017-May2.5132.5072.4882.4792.5052.50
59615.3743420434202017-Jun2.4902.4592.4272.3962.44
12664.46
79385.47
1912.22
6484.46
411.28
3395.24
2323.51
3947.29
1291.99
468.2
3.35
186079.1

http://www.cpc.ncep.noaa.gov/products/analysis_monitoring/cdus/degree_days/http://www.cpc.ncep.noaa.gov/products/analysis_monitoring/cdus/degree_days/http://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_r10_w.htmhttp://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=pet&s=emd_epd2dxl0_pte_r10_dpg&f=mhttp://www.eia.gov/dnav/pet/pet_pri_wfr_a_EPD2F_PWR_dpgal_m.htmhttp://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_r1z_m.htmfile:///C:/Users/VHARICNovitF/0.3%20SAFETY%20SECTION/0.3%20GEMS/AIR%20EMISSION%20SPREADSHEET/Copy%20of%2050056%20McGuire%20VA%20Hospital%20Rolling%20Total%20Boilers%20and%20Generators%20160510.xlsx degree days & intensity calcs

ENERGY SF
Validate SF each quarter29443049.334
\\Vha06cd1en1ric2\deptdir$\vhariceng\Energy\Reports - Energy & Environmental\Quarterly Energy Report\fy 2010\Home - VISN 6 Energy Management.txtFALSE
2003 SF1,825,250
2007 SF1,774,2500.2082364975
2008 SF1,774,250
2009 SF1,779,250
2010 SF1,821,250
1st 3 Qtrs2011 SF1,841,536
4th Qtr2011 SF1,841,536
2012 SF1,841,536
1st 2 qtrs2013 SF1,837,307
beginning 3rd qtr2013 SF1,872,342FY 18Electricity Intensity kBTU/SFGas&Fuel Oil Intensity kBTU/SFTotal Energy Intensity kBTU/SFWater Intensity Gallons/SF
2014 SF1,872,342first quarter15.216.331.57.6
beginning Nov-2014
Novitzki, Frank: Includes 2M addition which began HVAC operations on 11/6/14.2015 SF1,900,055second quarter13.622.836.56.9
2016 SF1,900,967third quarter15.916.332.28.2
2017 SF1,904,829fourth quarter19.111.830.810.3
beginning Jan-20182018 SF1,936,281
beginning Jul-20182018 SF1,957,281
beginning Aug-20182018 SF1,959,409
National Climatic Data Center
Heating Degree Daysdeviation from monthly normmonthly norm% deviationCooling Degree Daysdeviation from monthly normmonthly norm% deviationtotal first quarter estimated gas/fuel oil kBTUs
first quarterconversion factorskBTUs$/kBTUOCT-17122-103225-46%845133155%
electricBTUs/kWh341129,443,049$ 0.019711473714NOV-1747664701%606***
natural gasBTUs/cu ft1,02831,520,742$ 0.003912527928DEC-17758107481%0-11-100%
#2 fuel oilBTUs/gal. #2 fuel oil138,50051,799$ - 0315207421356-871443%905040125%
61,015,590
17779363JAN-18906338734%000***
13658933FEB-18480-225705-32%651500%
second quarterconversion factorskBTUs$/kBTU12735686MAR-182863225413%19-1433-42%
electricBTUs/kWh3,41126,389,140$ 0.02061672-1601832-9%25-934-26%
natural gasBTUs/cu ft1,02844,173,982$ 0.0044
#2 fuel oilBTUs/gal. #2 fuel oil138,50022,714$ - 013293171APR-182863225413%19-1433-42%
70,585,8379728889MAY-185-7580-94%270163107152%
8553063JUN-180-88-100%3557827728%
291-51342-15%64422741754%
third quarterconversion factorskBTUs$/kBTU
electricBTUs/kWh3,41130,755,145$ 0.0197JUL-18000***412-3415-1%
natural gasBTUs/cu ft1,02831,575,123$ 0.00407393170AUG-180-11-100%4548736724%
#2 fuel oilBTUs/gal. #2 fuel oil138,50029,916$ 0.16827671347SEP-180-2727-100%34916218787%
62,360,18477352890-11-100%121524696925%
fourth quarterconversion factorskBTUs$/kBTU
electricBTUs/kWh3,41137,378,505$ 0.0173For 2010 Richmond's annual HDDs were 8% above the norm. Only December contributed to the cumulative increase.
natural gasBTUs/cu ft1,02822,799,806$ 0.0045HDDs, though only one of several factors effecting gas/fuel oil demand, is, by far, the dominant factor. Other contributing factors were: 1) all new electronic boiler controls, 2)many pneumatic VAV controls replaced with electronic and connected to the BMS, and 3) from the spring of 2009 through summer of 2010 two consecutive contracts have tuck pointed, caulked and sealed most of the largest building's windows. Closing gapping gaps where sun, wind, rain and snow previously entered lower heat demand. Considering these improvements, the estimated 18.3 kBTUs comes in line with past first quarter figures.
#2 fuel oilBTUs/gal. #2 fuel oil138,500269,326$ 0.0216
60,447,638
2950
bldg 500 public2D addition5145082B expansion
Frank Novitzki: 2B expansion --> 20,020 sf & 75% of 20,020 sf interstitial2M additionB 516 A, B & CB 516 D, E & FDialysis ExpansionExpand Medical Intensive Care UnitB 517 A, B, C, D, E, F, & GNew Parking Garage

FY 17

Bldg 518

160,000 SF

Begin reporting 1st quarter FY 19MRI ExpansionCancer CenterPolytrauma Integrative Rehabilitation ClinicNew Clinical Lab for Surgical ExpansionInformation Technology SpaceExpand and Renovate Community Living CenterNew Clinical Lab for Surgical ExpansionExpand Women's Health/Primary Care AdditionSCI Enhancement CenterNew EP Lab
Date10/1/099/1/117/3/117/4/124/1/1311/6/14Sep-163/1/171/2/187/8/188/1/189/18/2018FY 17FY 19

Frank Novitzki: Frank Novitzki:

construction award scheduled for FY 18. Add this space once the space is using HVAC. FY 20 Frank Novitzki: Frank Novitzki:

FY 18 DesignFY 20
bldg 500 public1,018,8238,94220,02017,98117,97312,00017,50018,00018,50014,00021,93912,00020,0001,200
bldg 500 public total (SF)1,018,8231,027,7651,027,7651,027,7651,047,7851,065,7661,065,7661,065,7661,083,7391,095,7391,095,7391,095,739
bldg 500 gross total (GSF)1,938,1791,956,0631,956,0631,956,0631,991,0982,027,0602,027,0602,027,0602,063,0062,087,0062,087,0062,087,006

interstitial addition 8,942 15,015 Frank Novitzki: This formula corrects the interstitial SF. It is less than the SF used in previous year reports.

17,98117,97312,000
interstitial total (GSF)919,356928,298928,298943,313961,294961,294961,294979,267991,267991,267991,267
75% of interstitial689,517696,224696,224707,485720,971720,971720,971734,450743,450743,450743,450
total Bldg 500 energy space (SF)1,708,3401,723,9891,723,9891,723,9891,755,2701,786,7371,786,7371,786,7371,818,1891,839,1891,839,1891,839,189
out bldgs. total (GSF)83,682103,968103,968113,318113,318113,318114,230118,092118,092118,092120,2208/8/13Added Bldg 508 --> 9,350 sf
Total campus energy space (GSF)1,792,0221,827,9571,827,9571,837,3071,868,5881,900,0551,900,9671,904,8291,936,2811,957,2811,959,409Sep-16Added 6 office trailers 516A - 516E -->1,824
Total campus space (GSF)2,021,8612,060,0312,060,0312,069,3812,104,4162,140,3782,141,2902,145,1522,181,0982,205,0982,207,226
Laundry space (GSF)11,83511,83511,83511,83511,835
Non-Laundry/Non-Interstitial Space1,168,1611,168,1611,189,9961,201,9961,204,124

Out Bldgs. 2008 2011 2012 2016 2017 2018 2018 2019 Year Built /Occupied 501 1984 501 Frank Novitzki: 85% not heated or cooled

17,40417,40417,40417,40417,40417,40420,354
Frank Novitzki: Added 5 0'x59' addition housing additional chillers.20,35420,354#Building NameGSFInterstitialMcGuire VA Medical Center Energy Audit March 1, 2013
5031984503

Frank Novitzki: not heated or cooled

2,4582,4582,4582,4582,4582,4582,4582,4582,458518Parking Garage1,600
Frank Novitzki: 2 mech rooms and 1 data room have split systems, 2 store rooms have vent fans.Sep-18McGuire VA Medical Center Building List
5051989505

Frank Novitzki: 85% not heated or cooled

2,4002,4002,4002,4002,4002,4002,4002,4002,400517-AOffice (trailer)304Aug-18Building/AdditionSquare FeetYr OccupiedFloors
507194250727,80027,80027,80027,80027,80027,80027,80027,80027,800517-BOffice (trailer)304Aug-18Utility Plant (501)17,40419841
50820125089,350N/AN?A9,3509,3509,3509,3509,3509,350517-COffice (trailer)304Aug-18Generator Bldg (503)2,45819841
50919855098,0008,0008,0008,0008,0008,0008,0008,0008,000517-DOffice (trailer)304Aug-18Office (Bldg 509)8,00019852
5101995510
Frank Novitzki: not heated or cooled960960960960960960960960960517-EOffice (trailer)304Aug-18Grounds Bldg (505)2,40019891
51119975117,4767,4767,4767,4767,4767,4767,4767,4767,476517-FOffice (trailer)304Aug-18Bldg 50727,80019421
512200851212,41212,41212,41212,41212,41212,41212,41212,41212,412517-GOffice (trailer)304Aug-18COOP (508)9,35020121
51320085134,7724,7724,7724,7724,7724,7724,7724,7724,772516-AOffice (trailer)304- 0Sep-16COOP (508)8,00019852
514201151420,286N/A20,28620,28620,28620,28620,28620,28620,286516-BOffice (trailer)304Sep-16COOP (508)96019951
516-A2016516-AN/AN/AN/A304304304304516-COffice (trailer)304Sep-16Primary Care Clinic (511)7,47619971
516-B2016516-BN/AN/AN/A304304304304516-DOffice (trailer)304Sep-16Fisher House (512)12,41220082
516-C2016516-CN/AN/AN/A304304304304516-EOffice (trailer)304Sep-16Sleep Lab (513)4,77220081
516-D2017516-DN/AN/AN/AN/A304304304516-FOffice (trailer)304Sep-16Polytrauma Transitional Rehab Clinic (514)20,28620111
516-E2017516-EN/AN/AN/AN/A304304304508COOP Management Building9,350- 02012Main Hospital19846
516-F2017516-FN/AN/AN/AN/A304304304514Polytrauma Transitional Rehab20,286- 02011
2018517-A304304513Modular Building4,772- 02008
2018517-B304304512Fisher House12,412- 02008
2018517-C304304511Primary Care Center7,476- 01997
2018517-D304304510Engineering Storage960- 01995
2018517-E304304505Grounds Bldg2,400- 01989
2018517-F304304509Office8,000- 01985
2018517-GN/AN/AN/AN/AN/A304304503Generator Bldg2,458- 01984Interstitial19845
20185181,600

Frank Novitzki: Parking Garage: 2 mech rooms and 1 data room have split systems, 2 store rooms have vent fans.

Include this square footage in 1st quarter FY 19.

Out Bldgs. Total (GSF) 83,682 103,968 113,318 113,318 114,230 118,092 120,220 Cath Lab Addition I 1,345 1985 1

L2Fredricksburg CBOC9,975
L3Charlottesville CBOC4,401
L4Emporia CBOC9,727
L5Fredericksburg CBOC II9,950
L6Charlottesville CBOC10,000
501Utility Plant17,404- 01984
500Main Hospital1,095,739991,2671984
Cath Lab Addition II1,39620071
Hospice Addition11,67319901
MRI Addition7,72119861
Linear Accelerator Addition9,58919871
FY 18 fuel cost comparison ($/kBTU)Polytrauma Addition Specialty Clinic Addition (2B)

Novitzki, Frank: 9/16/15, check this

Frank Novitzki: Frank Novitzki:

construction award scheduled for FY 18. Add this space once the space is using HVAC.

Frank Novitzki: Frank Novitzki:

FY 18 Design Frank Novitzki: 85% not heated or cooled

5,72920111
electricity $nat gas & oil $electricity kBTUnat gas & oil kBTUelectricity $/kBTUnat gas & oil $/kBTUPolytrauma Neuroscience Center of Excellence19,68720131
1st Quarter$ 581,403$ 121,747.2029,443,04931,572.54$ 0.02$ 3.86Campus Total178,458
2nd Quarter$ 544,901$ 195,048.6526,389,14044,196.70$ 0.02$ 4.41None of these buildings is historic.
3rd Quarter$ 605,634$ 126,552.8530,755,14531,605.04$ 0.02$ 4.00507Office27,800- 01942
4th Quarter$ 647,782$ 108,783.8937378.50547523,069.13$ 17.33$ 4.72Total Square Feet2,204,27617,973

GSF NUSF

Frank Novitzki: 2/9/17: Data from CAI Lease Report for VHA - North Atlantic VISN 6 Station 652 https://vaww.cai.va.gov/Reports.aspx

Frank Novitzki: not heated or cooled

Frank Novitzki: 85% not heated or cooled

Frank Novitzki: Parking Garage: 2 mech rooms and 1 data room have split systems, 2 store rooms have vent fans.

Include this square footage in 1st quarter FY 19.

Frank Novitzki: not heated or cooled Novitzki, Frank: Includes 2M addition which began HVAC operations on 11/6/14.

Frank Novitzki: Added 5 0'x59' addition housing additional chillers.

Frank Novitzki: 2 mech rooms and 1 data room have split systems, 2 store rooms have vent fans.

Frank Novitzki: 2B expansion --> 20,020 sf & 75% of 20,020 sf interstitial Frank Novitzki: This formula corrects the interstitial SF. It is less than the SF used in previous year reports.

L4Emporia CBOC9,7279,7272010
L3Charlottesville CBOC4,4015,1482007
L2Fredricksburg CBOC9,9759,9752001
L1Vet Center3,600- 01998
Dialysis Expansion

10/2/13: Construction project awarded for Mental Health Recov-ery Center – The design is complete to construct the 19,322 square feet of rooftop space for the outpa-tient mental health program.

10/2/13: Dialysis Expansion – The design is complete to construct 17,937 square feet of new dialysis treatment space.

VSSC square-footage
2003 SF1825250
2007 SF1774250
2008 SF1774250
2009 SF1779250
2010 SF1821250
2011 SF1841536
2012 SF1841536
electricity
metric tons CO2 /kBTU
BTU/kWhmetric tons CO2 / kWh0.0002020393
34130.00068956
natural gas
metric tons CO2/kBTU
BTU/thermmetric tons CO2/therm0.000005
10000000.005
0.0002020393
0.000005
0.0247476652
0.0247476652

file://///Vha06cd1en1ric2/deptdir$/vhariceng/Energy/Reports%20-%20Energy%20&%20Environmental/Quarterly%20Energy%20Report/fy%202010/Home%20-%20VISN%206%20Energy%20Management.txthttp://www.cpc.ncep.noaa.gov/products/analysis_monitoring/cdus/degree_days/ gen fuel & scratch

234567891011121314151617181920212223242526
ABCDEFGHIJKLMNOPQRSTUVWXYZ
FY
201717FY 17
201818FY 18
1JANOCT-171
2FEBNOV-172
3MARDEC-173
4APRJAN-184
5MAYFEB-185
6JUNMAR-186
7JULAPR-187
8AUGMAY-188
9SEPJUN-189
10OCTJUL-1810
11NOVAUG-1811
12DECSEP-1812
thousands constant
1000What are Mcf, Btu, and therms? How do I convert prices in Mcf to Btus and therms? - FAQ - U.S. Energy Information Administration (EIA)
Mcf — is the volume of 1,000 cubic feet (cf) of natural gas.
MMBtu — is 1,000,000 British thermal units (Btu). One Btu is the heat required to raise the temperature of one pound of water by one degree Fahrenheit.
8760Therm — One therm equals 100,000 Btu, or 0.10 MMBtu
1,023 Btu per cf; one Mcf = 1.023 MMBtu or 10.23 therms.
1,000 cubic feet (1 Mcf) = 1,027,000 Btu (1 MMBtu)
3.7680
3.9750
4.1090

CF MMBTU THERMS quatrerly cost/MMBTU quatrerly cost/CF quatrerly cost/THERM Ref.:

http://www1.eere.energy.gov/manufacturing/tech_deployment/pdfs/steam15_benchmark.pdf
13066220031,521315,2103.86241553250.00397059570.38624155331128BTU/pound of steamat150 psig Op Pressure100 F feedwater
24297080044,174441,7404.41546271560.00453909750.44154627161030000BTU/thousand cubic feetNatural Gas
33071510031,575315,7503.98910055420.00410077940.39891005541030BTU/cubic feet
42217880022,800228,0004.51622324560.00464271690.4516223246
FY 18 averqge16.27083828470.41958005120.81nominal boiler efficiency
Ref.:MMBTU to PPH - OnlineConversion Forums#5
Boiler Horsepower - BHP
The Boiler Horsepower (BHP) is the amount of energy required to produce 34.5 pounds of steam per hour at a pressure and temperature of 0 Psig and 212 ?F, with feedwater at 0 Psig and 212 ?F. An BHP is equivalent to 33,475 BTU/Hr or 8430 Kcal/Hr
Example:5000 lbs of steam / 34.5 = 145 hp boiler
McGuire ave. daily steam production =200000Lbs
ave. production rate =8333.3333333333lbs./hr.
ave. boiler horsepower =242
Ref.:Calculations and References | Clean Energy | US EPA
The average heat content of natural gas =0.1mmbtu/therm
Ref.:FY12, 1st Quarter - Boiler Steam Cost Calculator.pdf
Average 1st quarter total steam cost/quarter =423710.03
Average 1st quarter total steam cost/yr. =7563.4855849012not including delivery losses, or makeup water and chemical costs
Ref.:FY12, 2nd Quarter - Boiler Steam Cost Calculator.pdf
Average 1st quarter total steam cost/quarter =337398.72
Average 1st quarter total steam cost/yr. =6022.7754228148not including delivery losses, or makeup water and chemical costs
Ref.:FY12, 3rd Quarter - Boiler Steam Cost Calculator.pdf
Average 1st quarter total steam cost/quarter =447249.47
Average 1st quarter total steam cost/yr. =7983.6791194198not including delivery losses, or makeup water and chemical costs
Ref.:FY12, 4th Quarter - Boiler Steam Cost Calculator.pdf
Average 1st quarter total steam cost/quarter =502174.85
Average 1st quarter total steam cost/yr. =8964.1310569753not including delivery losses, or makeup water and chemical costs
McGuire total steam production =6804000lbs of steams
May laundry steam use =121455.6lbs of steams
laundry steam % of total steam =0.0178506173
EISA Sec. 431https://www.gpo.gov/fdsys/pkg/BILLS-110hr6enr/pdf/BILLS-110hr6enr.pdf
Energy Intensity Goal
20062%
20074%
20089%
200912%
201015%
201118%
201221%
201324%
201427%
201530%

http://www1.eere.energy.gov/manufacturing/tech_deployment/pdfs/steam15_benchmark.pdfhttp://forum.onlineconversion.com/showthread.php?t=8017http://www.epa.gov/cleanenergy/energy-resources/refs.htmlfile:///C:/Documents%20and%20Settings/Application%20Data/Microsoft/Excel/FY12,%201st%20Quarter%20-%20Boiler%20Steam%20Cost%20Calculator.pdffile:///C:/Documents%20and%20Settings/Application%20Data/Microsoft/Excel/FY12,%202nd%20Quarter%20-%20Boiler%20Steam%20Cost%20Calculator.pdffile:///C:/Documents%20and%20Settings/Application%20Data/Microsoft/Excel/FY12,%203rd%20Quarter%20-%20Boiler%20Steam%20Cost%20Calculator.pdffile:///C:/Documents%20and%20Settings/Application%20Data/Microsoft/Excel/FY12,%204th%20Quarter%20-%20Boiler%20Steam%20Cost%20Calculator.pdfhttp://www.eia.gov/tools/faqs/faq.cfm?id=45&t=7https://www.gpo.gov/fdsys/pkg/BILLS-110hr6enr/pdf/BILLS-110hr6enr.pdf per unit cost

Bldg 500
1236789
B500 Electricity Acct No. 9826392509
($/kWH)Natural Gas unit cost
($/CCF)Natural Gas unit cost
($/MBTU)Water unit cost
($/k Gal)Sewer unit cost

($/k Gal) Frank Novitzki: These numbers are incorrect because Bldg 500 water is not metered or billed separately. Water + Sewer unit cost ($/k Gal)

OCT-17-6$ 0.065$ 0.083$ 0.456$ 0.004435$ 5.640$ 6.920$ 12.56
NOV-17-5$ 0.066$ 0.082$ 0.369$ 0.003587$ 5.680$ 8.420$ 14.10
DEC-17-4$ 0.070$ 0.082$ 0.388$ 0.003771$ 5.780$ 9.640$ 15.42
JAN-18-3$ 0.071$ 0.079$ 0.441$ 0.004294$ 2.090$ 9.460$ 11.55
FEB-18-2$ 0.068$ 0.079$ 0.417$ 0.004056$ 5.730$ 9.610$ 15.34
MAR-18-1$ 0.070$ 0.084$ 0.511$ 0.004970$ 5.700$ 9.590$ 15.29
APR-180$ 0.069$ 0.080$ 0.389$ 0.003786$ 5.700$ 9.590$ 15.29
MAY-181$ 0.068$ 0.080$ 0.404$ 0.003931$ 5.680$ 9.090$ 14.77
JUN-182$ 0.063$ 0.086$ 0.449$ 0.004370$ 5.420$ 8.200$ 13.62
JUL-183$ 0.044$ 0.062$ 0.479$ 0.004657$ 6.020$ 8.170$ 14.19
AUG-184$ 0.065$ 0.087$ 0.482$ 0.004688$ 6.020$ 7.930$ 13.95
SEP-185$ 0.065$ 0.085$ 0.433$ 0.004212$ 6.000$ 9.560$ 15.56
averageaverageaverageaverageaverageaverageaverage
$ 0.068$ 0.081$ 0.422$ 0.004$ 5.250$ 9.040$ 14.290

Bldg 507 thermal data

Bldg 507 Electricity Decrease (Increase) Attributable to GSHP
MonthFY 11 & 12 average kWHFY 18
Frank Novitzki: BLDG 507 kWHmonthly kWh reduction or (increase)monthly ratemonthly electricity cost decrease or (increase)monthly MBTU reduction or (increase)

[enter into quarterly VSSC report]

OCT-1737,80042,972(5,172)$ 0.083$ (430)(17,642)
NOV-1757,22539,73617,489$ 0.088$ 1,54859,655
DEC-17106,05054,27551,775$ 0.081$ 4,216176,605
JAN-18130,20067,06963,131$ 0.078$ 4,897215,340
FEB-18112,35051,27661,074$ 0.080$ 4,896208,323
MAR-1867,20051,78515,415$ 0.082$ 1,26352,581
APR-1850,92544,9116,014$ 0.089$ 53420,514
MAY-1832,02536,267(4,242)$ 0.090$ (382)(14,469)
JUN-1846,20045,0011,199$ 0.086$ 1034,090
JUL-1852,67549,1463,529$ 0.059$ 20912,037
AUG-1856,70046,38410,316$ 0.088$ 90635,188
SEP-1843,75051,815(8,065)$ 0.087$ (706)(27,510)
$ 17,055annual savings
12345678
FY MonthB500 Electricity Acct No. 9826392509
($/kWH)B507 Electricity

Acct No. 2182365003

($/kWh)Blended Electricity
($/kWh)Blended Natural Gas unit cost
($/MBTU)Water unit cost
($/k Gal)Sewer unit cost

($/k Gal) Frank Novitzki: These numbers are incorrect because Bldg 500 water is not metered or billed separately. Water + Sewer unit cost ($/k Gal)

OCT-171$ 0.065$ 0.083$ 0.065$ 0.004435$ 5.640$ 6.920$ 12.560
NOV-172$ 0.066$ 0.088$ 0.067$ 0.003587$ 5.680$ 8.420$ 14.100
DEC-173$ 0.070$ 0.081$ 0.070$ 0.003771$ 5.780$ 9.640$ 15.420
JAN-184$ 0.071$ 0.078$ 0.071$ 0.004294$ 2.090$ 9.460$ 11.550
FEB-185$ 0.068$ 0.080$ 0.069$ 0.004056$ 5.730$ 9.610$ 15.340
MAR-186$ 0.070$ 0.082$ 0.071$ 0.004970$ 5.700$ 9.590$ 15.290
APR-187$ 0.069$ 0.089$ 0.070$ 0.003786$ 5.700$ 9.590$ 15.290
MAY-188$ 0.068$ 0.090$ 0.069$ 0.003931$ 5.680$ 9.090$ 14.770
JUN-189$ 0.063$ 0.086$ 0.064$ 0.004370$ 5.420$ 8.200$ 13.620
JUL-1810$ 0.044$ 0.059$ 0.044$ 0.004657$ 6.020$ 8.170$ 14.190
AUG-1811$ 0.065$ 0.088$ 0.066$ 0.004688$ 6.020$ 7.930$ 13.950
SEP-1812$ 0.065$ 0.087$ 0.066$ 0.004212$ 6.000$ 9.560$ 15.560

Bldg 508 PV & HVAC

Estimated cost based on FY14, 1st 5 months average rate
2 5-ton roof-mounted heat pumps =10tons total
Bldg 508 PV production (kWh)
8/6/1381,315Total kWH for 1 FYTotal kWH +5% for 1 FY
est. beginning date11/6/122- 05.7875FY1311 months257,920
101,315FY14OCT25,280
ave per month132total1 FY283,200297,3607,434
Bldg 508 - FY 15 Electricity
1156kWH$$$$/kWH
OCT-1725,280$ 235.810.0093
NOV-1721,920$ 445.710.0203
DEC-1723,440$ 690.920.0295
JAN-1827,760$ 1,053.890.0380
FEB-1822,080$ 629.380.0285
MAR-1824,240$ 572.130.0236
APR-1824,640$ 471.730.0191
MAY-1824,480$ 1,632.820.0667
JUN-1830,000$ 315.070.0105
JUL-1826,640$ 293.030.0110
AUG-1825,680$ 362.510.0141
SEP-1835,200$ 375.220.0107
totals120,480$ 3,055.710.025

Bldg 509 electric

Bldg 509 - FY 15 Electricity
kWH$$$$/kWH
OCT-1714,080$ 1,174.64$ 0.0834
NOV-1713,600$ 1,109.84$ 0.0816
DEC-1715,360$ 1,252.11$ 0.0815
JAN-1819,200$ 1,517.85$ 0.0791
FEB-1817,440$ 1,383.79$ 0.0793
MAR-1816,240$ 1,360.76$ 0.0838
APR-1815,680$ 1,261.21$ 0.0804
MAY-1813,840$ 1,103.30$ 0.0797
JUN-1816,720$ 1,444.97$ 0.0864
JUL-1816,080$ 995.82$ 0.0619
AUG-1814,320$ 1,247.72$ 0.0871
SEP-1814,240$ 1,216.31$ 0.0854
totals79,680$ 6,438.23$ 0.0808MONTHLY AVERAGE

(10 months)

$ 7,725.88Extrapolated 12 month total12.9(Yrs) SIR
$ 386.295% of annual total6.5(Yrs) SIR
4 Main Street Energy T7 filters$ 5,000.00($$) Capital cost

OACEMS conversion factors

Natural Gas - for VSSC Report - use throughout this workbookWhat are Ccf, Mcf, Btu, and therms?
100cf=1ccfC — equals one hundred (100).
1,000cf=1McfMBTU is occasionally used as a standard unit of measurement for natural gas and provides a convenient basis for comparing the energy content of various grades of natural gas and other fuels. One cubic foot of natural gas produces approximately 1,000 BTUs, so 1,000 cu.ft. of gas is comparable to 1 MBTU. MBTU is occasionally expressed as MMBTU, which is intended to represent a thousand thousand BTUs.
1,000,000cf=1MMcf
1cubic foot (cf)=1,028BTU=1.028MBTU
1ccf=102,800BTU=102.8MBTU
1Mcf=1,028,000BTU=1,028MBTU
1MMcf=1,028,000,000BTU1,028,000MBTU
100Mcf≈102,800,000BTU=1Therm
1MMcf≈1,028,000,000BTU=1decaterm
1billion (1,000,000,000 cubic feet (1 bcf)=1.028trillion Btu=
1trillion (1,000,000,000,000) cubic feet (1Tcf)=1.028quadrillion Btu=
Ref:S:\0.6 STANDARDS, GUIDES & REFERENCES\calculations\VA energy reporting\reporting references 140115
also see:What are Ccf, Mcf, Btu, and therms? How do I convert natural gas prices in dollars per Ccf, or Mcf to dollars per Btu or therm? - FAQ - U.S. Energy Information Administration (EIA)
Nat Gas
Energy TypeReporting UnitBTU/CF
ElectricitykWH=3411BTU/kWH10280.1336805556
Fuel Oil(Thousands of Gallons)=BTU/therm
Natural Gas(Thousand Cubic Feet)=100,000
LPG/
Propane(Thousands of Gallons)=
Coal(Short Ton)=CF/therm
Purchased Steam(Billion Btu)=1000Billion BTU/pound97.2762645914
Other(Billion Btu)=Billion BTU/pound
Liquid Volume=7.46gallons/CFCCF/therm
Liquid Volume=746gallons/CCF0.9727626459
Boiler Horsepower - BHPConvert Boiler Horse Power (BHP) to kBtu/hr
The Boiler Horsepower (BHP) is the amount of energy required to produce 34.5 pounds of steam per hour at a pressure and temperature of 0 Psig and 212 oF, with feedwater at 0 Psig and 212 oF
A BHP is equivalent to 33,475 BTU/Hr or 8430 Kcal/Hr and it should be noted that a boiler horsepower is 13.1547 times a normal horsepower
1 horsepower (boiler) = 33445.6 Btu (mean)/hr = 140671.6 calorie/min (thermo) = 140469.4 calorie (mean)/min = 140742.3 calorie (20oC)/min 9.8095x1010 erg/sec = 434107 foot-pound-force/min = 13.1548 horsepower (mech) = 13.1495 horsepower (electric) = 13.3372 horsepower (metric) = 13.1487 horsepower (water) = 9809.5 joule/sec = 9.8095 kilowatt
Horsepower (hp) can be converted into lbs of steam by multiplying hp with 34.5.
Example: 200 hp x 34.5 = 6900 lbs of steam per hour
1 BHP=33,479Btu/hr
Existing 650 BHP Nebraska boiler=65021,761,350Btu/hr
Existing 650 BHP Nebraska boiler=65022,425lbs/hr

http://www.eia.gov/tools/faqs/faq.cfm?id=45&t=8http://www.engineeringtoolbox.com/boiler-capacity-d_1115.html calcs for VSSC Qtrly Rpt

15
MonthNatural Gas Total (Cu Ft.)Natural Gas Total (MBTU.)Natural Gas Total Cost ($$)Btu/lb of laundry
1,326Month
OCT-177,314,3007,519,100$33,346
NOV-1711,161,20011,473,714$41,154
DEC-1712,186,70012,527,928$47,247
30,662,20031,520,742$121,747
- 0
JAN-1817,295,10017,779,363$76,353
FEB-1813,286,90013,658,933$55,398
MAR-1812,388,80012,735,686$63,297
42,970,80044,173,982$195,049
- 0
APR-1812,931,10013,293,171$50,331
MAY-189,463,9009,728,889$38,244
JUN-188,320,1008,553,063$37,381
30,715,10031,575,123$125,956
- 0
JUL-187,191,8007,393,170$34,427
AUG-187,462,4007,671,347$35,964
SEP-187,524,6007,735,289$32,579
22,178,80022,799,806$102,970
14
15Bldg 507 Electricity Decrease (Increase) Attributable to GSHP
Btu/lb of laundry

Novitzki, Frank: Novitzki, Frank:

Estimate from Joe Danes email sent Thu 5/29/2014 10:46 AM, Subject:RE: [EXTERNAL] Advanced meter data and bill sampleFY 11 & 12 averageMonthFY 18monthly kWh reduction or (increase)monthly ratemonthly electricity cost decrease or (increase)monthly MBTU reduction or (increase)
[enter into quarterly VSSC report]running total electricity cost decrease or (increase)running total MBTU reduction or (increase)

[enter into quarterly VSSC report]

1,326Month37,800OCT-1742,972(5,172)$ 4.665$ (24,128)(17,642)$ (24,128)(17,642)
57,225NOV-1739,73617,489$ 4.327$ 75,68059,655$ 51,55242,013
106,050DEC-1754,27551,775$ 3.169$ 164,057176,605$ 215,609218,618
130,200JAN-1867,06963,131$ 2.594$ 163,775215,340$ 379,384433,958
112,350FEB-1851,27661,074$ 3.025$ 184,731208,323$ 564,116642,281
67,200MAR-1851,78515,415$ 3.410$ 52,57352,581$ 616,688694,862
50,925APR-1844,9116,014$ 3.812$ 22,92320,514$ 639,611715,376
32,025MAY-1836,267(4,242)$ 5.027$ (21,325)(14,469)$ 618,286700,907
46,200JUN-1845,0011,199$ 4.706$ 5,6434,090$ 623,929704,997
52,675JUL-1849,1463,529$ 3.165$ 11,16912,037$ 635,098717,034
56,700AUG-1846,38410,316$ 4.675$ 48,22635,188$ 683,324752,222
43,750SEP-1851,815(8,065)$ 4.684$ (37,773)(27,510)$ 645,550724,712

VISN6 report

Richmond - 652
Quarterly Energy ReportNote: Baseline SF = 1,113,334 and the 2008 SF to date = 1,119,507
Electricity Intensity kBTU/SFGas/Fuel Oil Intensity kBTU/SFTotal Energy Intensity kBTU/SF2003 SF2003 SF
QuarterQuarterQuarter2007 SF
FY1st2nd3rd4thYr to Date1st2nd3rd4thYr to Date1st2nd3rd4thYr to Date2008 SF
Baseline14.012.515.916.458.819.720.315.317.472.733.732.831.233.8131.52009 SF
200814.713.917.017.463.018.720.816.612.468.533.434.733.629.8131.52010 SF↔ S:\Energy\Projects & Audit Info\Existing Floor Plans\vista SF data 100811.xlsx
200913.014.017.918.163.020.218.513.811.764.233.232.631.629.8127.22011 SF
201014.416.016.019.966.319.819.212.911.363.234.235.228.931.2129.52011 SF
201114.513.016.719.463.614.823.017.414.069.229.336.034.233.4132.9
201214.614.016.020.164.716.119.714.913.364.030.533.630.933.8128.8
201314.513.515.718.962.617.822.114.510.364.732.335.630.229.3127.4
201414.614.216.819.865.412.821.215.310.659.927.435.332.130.4125.2
201515.513.916.919.465.714.922.014.79.561.130.435.931.631.6129.5
201615.714.416.320.767.213.719.015.312.260.229.433.431.732.9127.4
201715.814.516.819.967.116.520.615.511.864.432.335.132.332.3132.0
201815.213.615.919.163.816.322.816.311.867.231.536.532.230.8131.0
14.714.016.619.115.131.7
1.20.50.30.80.40.6
8%4%2%4%3%2%
14.714.01.3
0.5-0.3
3%-2%
Reduce 2% annually potable water consumption intensity through FY 2020 or 26% by the end of FY2020 (baseline FY 2007 water consumption). [§2(d)(i)]Reduce water consumption intensity 2% annually through FY 2015 or 16% total reduction by the end of FY 2015 (baseline FY 2007). [§2(c)]
\\vharicmul23\g\vhariceng\0.6 STANDARDS, GUIDES & REFERENCES\Federal Laws & Requirements\EO_13693-comparison_to_earlier 160721.pdf
E.O. 13514E.O. 13423EO 13693
Water Intensity Gallons/SF26% Reduction by 2020 (target @ 2%/yr)36.1Continue 2% annually from FY07 to achieve 36% reduction by FY251st + 2nd quarter total1st, 2nd & 3rd quarter total
QuarterYr to Date0.90.469
FY1st2nd3rd4th

Frank Novitzki: Linear reduction series

Frank Novitzki: Regressive reduction series2007
Frank Novitzki: Baseline9.812.611.113.446.946.946.946.946.922.433.5
200810.18.811.912.643.446.046.046.046.03.518.930.8
200910.08.911.813.444.145.045.045.045.0-0.718.930.7
201010.08.911.813.444.144.144.144.144.10.018.930.7
20119.28.712.514.544.943.143.143.143.3-0.817.930.4
20128.89.810.013.141.742.242.242.242.43.218.628.6
201311.18.17.49.536.141.341.341.341.55.619.226.6
20146.16.28.310.831.440.340.340.340.74.712.320.6
20158.25.17.810.231.339.439.439.439.90.113.321.1
20166.86.68.410.532.338.538.539.1-1.013.921.9
20177.16.88.08.630.537.537.538.31.8N/AN/A
20187.66.98.210.333.036.636.637.6-2.514.522.7
20190.035.635.636.8N/AN/A
202034.734.736.1N/AN/A
202133.835.3
202232.834.6
202331.933.9
202431.033.3
202530.032.6
8.8
32.6
28.50.2907184196
58,095,432
03,834
15,153

file:///C:/Projects%20&%20Audit%20Info/Existing%20Floor%20Plans/vista%20SF%20data%20100811.xlsxfile:///C:/Users/VHARICNovitF/0.6%20STANDARDS,%20GUIDES%20&%20REFERENCES/Federal%20Laws%20&%20Requirements/EO_13693-comparison_to_earlier%20160721.pdf Rmond VISN Intensity Charts

kBTU/SF
3rd Quarter FY 18

Novitzki, Frank: Update comments each quarter

Evaporation from 4 new water towers, 40% larger than their predecessors, and one existing tower account for an increased water demand.
3rd Quarter FY 18

Novitzki, Frank: Update comments each quarter Energy intensity hit an all-time 3rd quarter low; 2.4% lower than the 2007 3rd quarter baseline.

Richmond Water Comparisons by Quarter Baseline

1st2nd3rd4thYr to Date9.800000000000000712.611.113.446.92008
1st2nd3rd4thYr to Date10.18.800000000000000711.912.643.32009
1st2nd3rd4thYr to Date108.91213.744.62010
1st2nd3rd4thYr to Date108.911.713.343.82011
1st2nd3rd4thYr to Date9.19999999999999938.612.414.544.72012
1st2nd3rd4thYr to Date8.78000000000000119.79000000000000099.970000000000000613.1141.652013
1st2nd3rd4thYr to Date11.18.17.49.536.12014
1st2nd3rd4thYr to Date6.16.28.300000000000000710.831.4000000000000022015
1st2nd3rd4thYr to Date8.19999999999999935.09999999999999967.810.19999999999999931.2999999999999972016
1st2nd3rd4thYr to Date6.86.68.410.532.2999999999999972017
7.16.888.630.52018
7.66.98.199999999999999310.333Quarter

Gal/SF

Richmond Total Energy Intensity Baseline

1st2nd3rd4thYr to Date33.6732.7531.2133.82131.449999999999992008
1st2nd3rd4thYr to Date33.37000000000000534.7133.61999999999999729.770000000000003131.470000000000032009
1st2nd3rd4thYr to Date33.20000000000000332.631.629.8127.22010
1st2nd3rd4thYr to Date34.20000000000000335.20000000000000328.931.2129.52011
1st2nd3rd4thYr to Date29.33634.20000000000000333.4132.92012
1st2nd3rd4thYr to Date30.533.630.933.799999999999997128.800000000000012013
1st2nd3rd4thYr to Date32.29999999999999735.630.229.3127.42014
1st2nd3rd4thYr to Date27.435.29999999999999732.12430255645137630.415075435223756125.239377991675132015
1st2nd3rd4thYr to Date30.435.931.59656792326643131.596567923266431129.493135846532852016
1st2nd3rd4thYr to Date29.433.431.732.9127.42017
1st2nd3rd4thYr to Date32.29999999999999735.132.29999999999999732.2999999999999971322018
31.536.532.20000000000000330.8131Quarter

kBTU/SF

H2O intensity goal

FYWater Intensity Gallons/SFFYPercent Reduction from 2007 Baseline
2007
Frank Novitzki: Baseline46.92007
Frank Novitzki: Baseline0.00%
200843.420087.46%7.46%
200944.12009-1.61%5.85%
201044.120100.00%5.85%
201144.92011-1.81%4.04%
201241.720127.13%11.16%
201336.1201313.43%24.59%
201431.4201413.02%37.61%
201531.320150.32%37.93%
201632.32016-3.19%34.73%
201730.520175.57%40.31%
2018332018-8.20%32.11%
201902019100.00%132.11%
20202020
20212021
20222022
20232023
20242024
20252025

Water Intensity Gallons/SF 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 46.9 43.4 44.1 44.1 44.9 41.7 36.1 31.400000000000002 31.299999999999997 32.299999999999997 30.5 33 0 0 0 0 0 0 0

Percent Reduction from 2007 Baseline 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 0 7.4626865671641798E-2 -1.6129032258064582E-2 0 -1.8140589569160932E-2 7.1269487750556706E-2 0.13429256594724223 0.13019390581717449 3.1847133757963364E-3 -3.1948881789137386E-2 5.5727554179566478E-2 -8.1967213114754092E-2 1 0 0 0 0 0 0 FY

% Reduction

H2O intensity details Ref: FEMP Federal Laws and Requirements Water Use Reduction

FY Quarterly Water Intensity (gal/SF) FY07 1st 2nd 3rd 4th 9.8000000000000007 12.6 11.1 13.4 FY08 1st 2nd 3rd 4th 10.1 8.8000000000000007 11.9 12.6 FY 09 1st 2nd 3rd 4th 10 8.9 11.8 13.4 FY10 1st 2nd 3rd 4th 10 8.9 11.8 13.4 FY11 1st 2nd 3rd 4th 9.1999999999999993 8.6999999999999993 12.5 14.5 FY12 1st 2nd 3rd 4th 8.8000000000000007 9.8000000000000007 10 13.1 FY13 1st 2nd 3rd 4th 11.1 8.1 7.4 9.5 FY14 1st 2nd 3rd 4th 6.1 6.2 8.3000000000000007 10.8 FY 15 1st 2nd 3rd 4th 8.1999999999999993 5.0999999999999996 7.8 10.199999999999999 FY 16 1st 2nd 3rd 4th 6.8 6.6 8.4 10.5 FY 17 1st 2nd 3rd 4th 7.1 6.8 8 8.6 FY 18 1st 2nd 3rd 4th 7.6 6.9 8.1999999999999993 10.3 FY Quarter Water Intensity (Gal/SF) https://www4.eere.energy.gov/femp/requirements/requirements_filtering/water_use_reduction for laundry manager

412659

MonthLaundry PoundsLaundry Electricity Usage (kWh)Laundry Natural Gas Usage
(MBTU)Laundry Estimated Water Usage (Thousands of Gallons)Laundry Electricity Cost ($/kWh)Laundry Natural Gas Cost ($/MBTU)Laundry Estimated Water & Sewer cost ($/kgal)
OCT-17412,65945,392(6,332)465$ 2,950$ (526)2,623
NOV-17399,82743,98110,105450$ 2,903$ 8292,556
DEC-17408,17744,89920,159460$ 3,143$ 1,6532,659
1,220,663134,272$ 7,838

Month Laundry Pounds Novitzki, Frank: Values copied from M14:M16.

Laundry Electricity Usage (kWh)Laundry Natural Gas Usage
(MBTU)Laundry Estimated Water Usage (Thousands of Gallons)Laundry Electricity Cost ($/kWh)Laundry Natural Gas Cost ($)Laundry Estimated Water & Sewer cost ($)
JAN-18418,77246,06538,252471$ 3,271$ 3,022984

Novitzki, Frank: On "Formula" tab select "calculation options", "manual"

Novitzki, Frank: Values copied from M14:M16.

FEB-18401,68944,18624,406452$ 3,005$ 1,9282,590
MAR-18337,19537,0911,840380$ 2,596$ 1552,166
1,157,656$ 5,740
MonthLaundry PoundsLaundry Electricity Usage (kWh)Laundry Natural Gas Usage
(MBTU)Laundry Estimated Water Usage (Thousands of Gallons)Laundry Electricity Cost ($/kWh)Laundry Natural Gas Cost ($)Laundry Estimated Water & Sewer cost ($)
APR-18138,56715,24230,881156$ 1,052$ 2,470889
MAY-18157,95617,37523,994178$ 1,182$ 1,9191,011
JUN-18160,19417,62120,745180$ 1,110$ 1,784976
456,71750,23875,620- 0$ 3,343$ 6,174$ 2,876
MonthLaundry PoundsLaundry Electricity Usage (kWh)Laundry Natural Gas Usage

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it.