B08_Att_(7)_HAVO_326181_Construction_Phasing_Calcs.xlsx

210 KB Posted

Attached to
HAVO 326181 Rehabilitate Rainshed&Water Treatment
Solicitation number
140P2026R0091
Issued by

About this file

Written by GovTribe AI ·

This is a technical attachment containing construction phasing calculations and water balance analysis for the Hawaii Volcanoes National Park (HAVO) water system rehabilitation project. The document presents detailed hydrological modeling across two scenarios spanning six years, analyzing rainfall accumulation, water demand, and reservoir storage capacity during the construction of three key improvements: Ground Catchment 1 (GC1), Building 241, and Building 43. The analysis assumes drought conditions with 20% increased water consumption during construction and models phasing to start improvements at the end of the rainy period when reservoirs are most full. Maximum storage capacity is 4.67 million gallons, with expanded capacity reaching 5.58 million gallons after GC1 improvements.

The document includes comprehensive water balance calculations tracking monthly precipitation (measured in inches), rainfall accumulation (in gallons), water demand, and cumulative water balance through 2022 historical data. Critical technical information includes catchment area specifications for two reservoirs and four rain sheds (ranging from 30,834 to 77,604 gallons per inch of rainfall), evapotranspiration (ET) rates modeled by the University of Hawai'i using the Penman-Monteith equation, and storage volume calculations derived from Civil 3D construction drawings. The spreadsheet demonstrates reservoir capacity management during various precipitation scenarios, with detailed stage-elevation contours and incremental storage calculations for both reservoirs. The modeling indicates that with proper phasing, the system can maintain adequate water supply even during drought conditions, with reservoir levels reaching critical lows (31% capacity) during Year 1-2 construction periods before stabilizing above 80% capacity post-construction.

View the file

Other files

File Type Posted
Sol_140P2026R0091_Amd_0002.pdf PDF
B09_Att_(15)_HAVO_326181_-_Site_Walk_Requirements_30JUL2026_0001.pdf PDF
Sol_140P2026R0091_Amd_0001.pdf PDF
B08_Att_(13)_HAVO_326181_Final_CD_Basis_of_Design_Product_Files.pdf PDF
B08_Att_(2)_HAVO_326181_26_0908_Final_CD_Drawing_Set.pdf PDF
B08_Att_(3)_2024_08_26_-_Geotechnical_Data_Report_-_HAVO_Rainsheds_Shear_Wave_Velocity_Survey.pdf PDF
B08_Att_(14)_Hazardous_Material_Survey_HAVO_Rainshed_Enviroquest_May2025.pdf PDF
Sol_140P2026R0091.pdf PDF
B08_Att_(9)_Redwood_Water_Tanks_Trip_Rpt_and_Prelim_Treat_Recs__2018.pdf PDF
B08_Att_(10)_Davis-Bacon_Act_WD__HI20260001.pdf PDF
B08_Att_(12)_GenRefs.docx DOCX document
B08_Att_(1)_HAVO_326181_26-0908_Project_Specifications.pdf PDF
B08_Att_(5)_HAER_Drawings_HAVO_Rainshed.pdf PDF
B08_Att_(11)_Solit_PSP_Vol_II_SubKPlan.docx DOCX document
B08_Att_(4)_2025_01_02_-_Geotechnical_Report_HAVO_Rehabilitate_Water_Treatment_System.pdf PDF
B08_Att_(6)_HAER_HAVO_Water_Collection_System_HI-76__Final_report.pdf PDF
B08_Att_(8)_HAVO_326181_Construction_Phasing_Memo.pdf PDF
Show all 17

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.

Scenario 1 Hawaii Volcano National Park

Summary of Phasing Order: Assumes average rainfall and consumption for the year before construction starts (reservoirs full at start of calendar year). Assumes drought conditions and 20% increased consumption once construction starts.

Start construction at the end of the rainy period, when reservoirs are the most full.

Order of improvements: Ground Catchment 1, Building 241, Building 43. Overlap GC1 and Bldg 241 construction.

YearMonthINPUT Precipitation (in)Rainfall Accumulation (gal)INPUT Water Demand (gal/month)Individual Month Water Balance (gal)Cumulative Water Balance (gal) - starts at 0 gal, no storage limitsActual Water Balance (gal) - starts at 0 gal, storage limited to 4.67MGReservoir Percent FullGC 1 StatusBuilding 241 StatusBuilding 43 StatusMax Volume (gal)
Assumed average rainfall and water consumptionYear 0January6.22997,543544,875436,906ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
February8.001,283,831475,674792,394ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
March8.731,401,053524,703860,587ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
April9.271,487,190447,1231,024,305ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
May5.81932,665387,990528,913ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
June4.53725,997540,999169,235ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
July5.37861,870477,634368,474ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
August7.391,184,859512,764656,332ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
September5.78927,952426,191485,999ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
October8.531,369,166421,981931,422ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
November9.481,520,281443,3891,061,129ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
December12.201,957,885475,0331,467,089ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 1January1.11178,090653,850-491,522ERROR:#REF!4,180,19289%OnlineOnlineOnline4,671,715Start Improvements
February1.59131,711570,809-454,861ERROR:#REF!3,725,33192%OfflineOnlineOnline4,043,156GC 1 offline
March7.20596,426629,644-48,981ERROR:#REF!3,676,35091%OfflineOnlineOnline4,043,156GC 1 offline
April7.61630,389536,54778,079ERROR:#REF!3,754,42993%OfflineOnlineOnline4,043,156GC 1 offline
May1.3775,882465,587-405,468ERROR:#REF!3,348,96183%OfflineOfflineOnline4,043,156GC 1 and Bldg 241 offline
June2.74151,763649,199-513,198ERROR:#REF!2,835,76270%OfflineOfflineOnline4,043,156GC 1 and Bldg 241 offline
July2.75152,317573,160-436,605ERROR:#REF!2,399,15759%OfflineOfflineOnline4,043,156GC 1 and Bldg 241 offline
August2.07275,294615,317-355,785ERROR:#REF!2,043,37337%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
September1.55206,138511,429-321,053ERROR:#REF!1,722,31931%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
October7.45990,794506,378468,654ERROR:#REF!2,190,97339%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
November7.681,021,382532,067473,553ERROR:#REF!2,664,52648%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
December9.501,263,429570,040677,626ERROR:#REF!3,342,15260%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 2January1.11147,622653,850-521,990ERROR:#REF!2,820,16251%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
February1.59211,458570,809-375,114ERROR:#REF!2,445,04844%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
March7.20957,546629,644312,139ERROR:#REF!2,757,18749%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
April7.611,012,073536,547459,763ERROR:#REF!3,216,95058%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
May1.37186,166465,587-295,184ERROR:#REF!2,921,76652%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
June2.74372,332649,199-292,630ERROR:#REF!2,629,13747%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
July2.75373,691573,160-215,232ERROR:#REF!2,413,90443%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
August2.07281,287615,317-349,792ERROR:#REF!2,064,11337%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
September1.55210,626511,429-316,566ERROR:#REF!1,747,54731%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
October7.451,012,362506,378490,222ERROR:#REF!2,237,76840%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
November7.681,043,616532,067495,786ERROR:#REF!2,733,55549%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
December9.501,290,931570,040705,129ERROR:#REF!3,438,68362%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 3January1.11150,835653,850-518,777ERROR:#REF!2,919,90652%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
February1.59216,061570,809-370,511ERROR:#REF!2,549,39646%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
March7.20978,390629,644332,983ERROR:#REF!2,882,37952%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
April7.611,034,104536,547481,794ERROR:#REF!3,364,17360%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
May1.37219,805465,587-261,545ERROR:#REF!3,102,62856%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559All improvements finished
June2.74439,609649,199-225,353ERROR:#REF!2,877,27552%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!2,729,56649%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!2,430,60044%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!2,152,09239%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!2,825,24051%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!3,509,59963%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!4,447,98880%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 4January1.11178,090653,850-491,522ERROR:#REF!3,956,46671%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
February1.59255,102570,809-331,470ERROR:#REF!3,624,99665%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
March7.201,155,177629,644509,770ERROR:#REF!4,134,76674%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
April7.611,220,958536,547668,648ERROR:#REF!4,803,41486%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
May1.37219,805465,587-261,545ERROR:#REF!4,541,86981%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
June2.74439,609649,199-225,353ERROR:#REF!4,316,51677%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!4,168,80775%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!3,869,84169%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!3,591,33364%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!4,264,48176%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!4,948,84089%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 5January1.11178,090653,850-491,522ERROR:#REF!5,089,03791%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
February1.59255,102570,809-331,470ERROR:#REF!4,757,56685%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
March7.201,155,177629,644509,770ERROR:#REF!5,267,33794%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
April7.611,220,958536,547668,648ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
May1.37219,805465,587-261,545ERROR:#REF!5,319,01395%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
June2.74439,609649,199-225,353ERROR:#REF!5,093,66191%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!4,945,95289%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!4,646,98683%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!4,368,47878%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!5,041,62690%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 6January1.11178,090653,850-491,522ERROR:#REF!5,089,03791%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
February1.59255,102570,809-331,470ERROR:#REF!4,757,56685%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
March7.201,155,177629,644509,770ERROR:#REF!5,267,33794%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
April7.611,220,958536,547668,648ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
May1.37219,805465,587-261,545ERROR:#REF!5,319,01395%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
June2.74439,609649,199-225,353ERROR:#REF!5,093,66191%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!4,945,95289%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!4,646,98683%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!4,368,47878%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!5,041,62690%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559

Percent Capacity January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 1 1 1 1 1 1 1 1 1 1 1 1 0.89478758785465606 0.92139186943467355 0.90927730283232644 0.9285886210639468 0.82830354663833339 0.70137347869296074 0.59338719596933731 0.36615911738990264 0.30862845115838478 0.3926082267681702 0.47746578095226855 0.59889200775852069 0.50535469684482492 0.43813677502543208 0.49407013648091896 0.5764566845622342 0.52356161140463298 0.47112424778187922 0.43255604618065108 0.3698756000218949 0.31314901992450306 0.40099359663057149 0.48983526791795223 0.61618976457852503 0.52322828308991298 0.45683519801455902 0.51650366925437319 0.60283802087162319 0.55597077366190562 0.51558906193491927 0.48912051095900499 0.43554780181639419 0.38564102479872464 0.50626465501700713 0.62889735059617347 0.79705064032601258 0.70897301781707267 0.6495757307396276 0.74092328725299084 0.86074067205520033 0.81387342484548264 0.77349171311849629 0.74702316214258202 0.69345045299997121 0.64354367598230167 0.76416730620058415 0.8868000017797506 1 0.91192237749106009 0.85252509041361491 0.94387264692697814 1 0.95313275279028231 0.91275104106329596 0.88628249008738169 0.83270978094477088 0.78280300392710134 0.90342663414538382 1 1 0.91192237749106009 0.85252509041361491 0.94387264692697814 1 0.95313275279028231 0.91275104106329596 0.88628249008738169 0.83270978094477088 0.78280300392710134 0.90342663414538382 1 1

Actual Volume

Actual Volume January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4180192.1933400007 3725331.1804300006 3676350.0962700006 3754428.7708600005 3348960.5579500007 2835762.4762900011 2399157.0758800013 2043372.5067200013 1722319.2375600014 2190973.3184000016 2664525.8942400017 3342152.1000800016 2820161.6309200018 2445048.0617600018 2757187.4776000017 3216950.4584400016 2921766.3892800016 2629136.5951200016 2413904.4759600018 2064112.556800002 1747546.5376400021 2237768.368480002 2733554.5443200022 3438683.2501600021 2919906.231000002 2549395.7118400019 2882379.1276800018 3364173.0585200018 3102627.6268600021 2877275.1077000024 2729565.8010400026 2430600.1443800027 2152092.4377200026 2825239.7060600026 3509598.6819000025 4447988.0127400029 3956465.6560800029 3624995.5994200031 4134766.015260003 4803413.9836000027 4541868.5519400025 4316516.0327800028 4168806.726120003 3869841.0694600032 3591333.362800003 4264480.631140003 4948839.6069800034 5580558.8600000003 5089036.5033400003 4757566.4466800001 5267336.86252 5580558.8600000003 5319013.4283400001 5093660.9091800004 4945951.6025200002 4646985.9458600003 4368478.2392000007 5041625.5075400006 5580558.8600000003 5580558.8600000003 5089036.5033400003 4757566.4466800001 5267336.86252 5580558.8600000003 5319013.4283400001 5093660.9091800004 4945951.6025200002 4646985.9458600003 4368478.2392000007 5041625.5075400006 5580558.8600000003 5580558.8600000003

Scenario 2 Hawaii Volcano National Park

Summary of Phasing Order: Assumes average rainfall and consumption for the year before construction starts (reservoirs full at start of calendar year). Assumes drought conditions and 20% increased consumption once construction starts.

Start construction at the end of the rainy period, when reservoirs are the most full.

Order of improvements: Ground Catchment 1, Building 241, Building 43. Overlap GC1 and Bldg 241 construction.

YearMonthINPUT Precipitation (in)Rainfall Accumulation (gal)INPUT Water Demand (gal/month)Individual Month Water Balance (gal)Cumulative Water Balance (gal) - starts at 0 gal, no storage limitsActual Water Balance (gal) - starts at 0 gal, storage limited to 4.67MGReservoir Percent FullGC 1 StatusBuilding 241 StatusBuilding 43 StatusMax Volume (gal)
Drought Conditions and 20% increase in water consumptionYear 0January6.22997,543544,875436,906ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
February8.001,283,831475,674792,394ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
March8.731,401,053524,703860,587ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
April9.271,487,190447,1231,024,305ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
May5.81932,665387,990528,913ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
June4.53725,997540,999169,235ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
July5.37861,870477,634368,474ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
August7.391,184,859512,764656,332ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
September5.78927,952426,191485,999ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
October8.531,369,166421,981931,422ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
November9.481,520,281443,3891,061,129ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
December12.201,957,885475,0331,467,089ERROR:#REF!4,671,715100%OnlineOnlineOnline4,671,715
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 1January1.11178,090653,850-491,522ERROR:#REF!4,180,19289%OnlineOnlineOnline4,671,715Start Improvements
February1.59131,711570,809-454,861ERROR:#REF!3,725,33192%OfflineOnlineOnline4,043,156GC 1 offline
March7.20596,426629,644-48,981ERROR:#REF!3,676,35091%OfflineOnlineOnline4,043,156GC 1 offline
April7.61630,389536,54778,079ERROR:#REF!3,754,42993%OfflineOnlineOnline4,043,156GC 1 offline
May1.3775,882465,587-405,468ERROR:#REF!3,348,96183%OfflineOfflineOnline4,043,156GC 1 and Bldg 241 offline
June2.74151,763649,199-513,198ERROR:#REF!2,835,76270%OfflineOfflineOnline4,043,156GC 1 and Bldg 241 offline
July2.75152,317573,160-436,605ERROR:#REF!2,399,15759%OfflineOfflineOnline4,043,156GC 1 and Bldg 241 offline
August2.07275,294615,317-355,785ERROR:#REF!2,043,37337%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
September1.55206,138511,429-321,053ERROR:#REF!1,722,31931%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
October7.45990,794506,378468,654ERROR:#REF!2,190,97339%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
November7.681,021,382532,067473,553ERROR:#REF!2,664,52648%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
December9.501,263,429570,040677,626ERROR:#REF!3,342,15260%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 2January1.11147,622653,850-521,990ERROR:#REF!2,820,16251%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
February1.59211,458570,809-375,114ERROR:#REF!2,445,04844%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
March7.20957,546629,644312,139ERROR:#REF!2,757,18749%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
April7.611,012,073536,547459,763ERROR:#REF!3,216,95058%Post-ImprovementsOfflineOnline5,580,559Building 241 offline
May1.37186,166465,587-295,184ERROR:#REF!2,921,76652%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
June2.74372,332649,199-292,630ERROR:#REF!2,629,13747%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
July2.75373,691573,160-215,232ERROR:#REF!2,413,90443%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
August2.07281,287615,317-349,792ERROR:#REF!2,064,11337%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
September1.55210,626511,429-316,566ERROR:#REF!1,747,54731%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
October7.451,012,362506,378490,222ERROR:#REF!2,237,76840%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
November7.681,043,616532,067495,786ERROR:#REF!2,733,55549%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
December9.501,290,931570,040705,129ERROR:#REF!3,438,68362%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 3January1.11150,835653,850-518,777ERROR:#REF!2,919,90652%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
February1.59216,061570,809-370,511ERROR:#REF!2,549,39646%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
March7.20978,390629,644332,983ERROR:#REF!2,882,37952%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
April7.611,034,104536,547481,794ERROR:#REF!3,364,17360%Post-ImprovementsPost-ImprovementsOffline5,580,559Building 43 offline
May1.37219,805465,587-261,545ERROR:#REF!3,102,62856%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559All improvements finished
June2.74439,609649,199-225,353ERROR:#REF!2,877,27552%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!2,729,56649%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!2,430,60044%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!2,152,09239%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!2,825,24051%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!3,509,59963%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!4,447,98880%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 4January1.11178,090653,850-491,522ERROR:#REF!3,956,46671%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
February1.59255,102570,809-331,470ERROR:#REF!3,624,99665%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
March7.201,155,177629,644509,770ERROR:#REF!4,134,76674%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
April7.611,220,958536,547668,648ERROR:#REF!4,803,41486%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
May1.37219,805465,587-261,545ERROR:#REF!4,541,86981%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
June2.74439,609649,199-225,353ERROR:#REF!4,316,51677%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!4,168,80775%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!3,869,84169%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!3,591,33364%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!4,264,48176%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!4,948,84089%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 5January1.11178,090653,850-491,522ERROR:#REF!5,089,03791%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
February1.59255,102570,809-331,470ERROR:#REF!4,757,56685%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
March7.201,155,177629,644509,770ERROR:#REF!5,267,33794%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
April7.611,220,958536,547668,648ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
May1.37219,805465,587-261,545ERROR:#REF!5,319,01395%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
June2.74439,609649,199-225,353ERROR:#REF!5,093,66191%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!4,945,95289%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!4,646,98683%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!4,368,47878%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!5,041,62690%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
Conservative estimate
(drought conditions, 20% increase in average water consumption)Year 6January1.11178,090653,850-491,522ERROR:#REF!5,089,03791%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
February1.59255,102570,809-331,470ERROR:#REF!4,757,56685%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
March7.201,155,177629,644509,770ERROR:#REF!5,267,33794%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
April7.611,220,958536,547668,648ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
May1.37219,805465,587-261,545ERROR:#REF!5,319,01395%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
June2.74439,609649,199-225,353ERROR:#REF!5,093,66191%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
July2.75441,213573,160-147,709ERROR:#REF!4,945,95289%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
August2.07332,113615,317-298,966ERROR:#REF!4,646,98683%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
September1.55248,684511,429-278,508ERROR:#REF!4,368,47878%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
October7.451,195,287506,378673,147ERROR:#REF!5,041,62690%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
November7.681,232,189532,067684,359ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559
December9.501,524,192570,040938,389ERROR:#REF!5,580,559100%Post-ImprovementsPost-ImprovementsPost-Improvements5,580,559

Percent Capacity January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 1 1 1 1 1 1 1 1 1 1 1 1 0.89478758785465606 0.92139186943467355 0.90927730283232644 0.9285886210639468 0.82830354663833339 0.70137347869296074 0.59338719596933731 0.36615911738990264 0.30862845115838478 0.3926082267681702 0.47746578095226855 0.59889200775852069 0.50535469684482492 0.43813677502543208 0.49407013648091896 0.5764566845622342 0.52356161140463298 0.47112424778187922 0.43255604618065108 0.3698756000218949 0.31314901992450306 0.40099359663057149 0.48983526791795223 0.61618976457852503 0.52322828308991298 0.45683519801455902 0.51650366925437319 0.60283802087162319 0.55597077366190562 0.51558906193491927 0.48912051095900499 0.43554780181639419 0.38564102479872464 0.50626465501700713 0.62889735059617347 0.79705064032601258 0.70897301781707267 0.6495757307396276 0.74092328725299084 0.86074067205520033 0.81387342484548264 0.77349171311849629 0.74702316214258202 0.69345045299997121 0.64354367598230167 0.76416730620058415 0.8868000017797506 1 0.91192237749106009 0.85252509041361491 0.94387264692697814 1 0.95313275279028231 0.91275104106329596 0.88628249008738169 0.83270978094477088 0.78280300392710134 0.90342663414538382 1 1 0.91192237749106009 0.85252509041361491 0.94387264692697814 1 0.95313275279028231 0.91275104106329596 0.88628249008738169 0.83270978094477088 0.78280300392710134 0.90342663414538382 1 1

Actual Volume

Actual Volume January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4671714.5500000007 4180192.1933400007 3725331.1804300006 3676350.0962700006 3754428.7708600005 3348960.5579500007 2835762.4762900011 2399157.0758800013 2043372.5067200013 1722319.2375600014 2190973.3184000016 2664525.8942400017 3342152.1000800016 2820161.6309200018 2445048.0617600018 2757187.4776000017 3216950.4584400016 2921766.3892800016 2629136.5951200016 2413904.4759600018 2064112.556800002 1747546.5376400021 2237768.368480002 2733554.5443200022 3438683.2501600021 2919906.231000002 2549395.7118400019 2882379.1276800018 3364173.0585200018 3102627.6268600021 2877275.1077000024 2729565.8010400026 2430600.1443800027 2152092.4377200026 2825239.7060600026 3509598.6819000025 4447988.0127400029 3956465.6560800029 3624995.5994200031 4134766.015260003 4803413.9836000027 4541868.5519400025 4316516.0327800028 4168806.726120003 3869841.0694600032 3591333.362800003 4264480.631140003 4948839.6069800034 5580558.8600000003 5089036.5033400003 4757566.4466800001 5267336.86252 5580558.8600000003 5319013.4283400001 5093660.9091800004 4945951.6025200002 4646985.9458600003 4368478.2392000007 5041625.5075400006 5580558.8600000003 5580558.8600000003 5089036.5033400003 4757566.4466800001 5267336.86252 5580558.8600000003 5319013.4283400001 5093660.9091800004 4945951.6025200002 4646985.9458600003 4368478.2392000007 5041625.5075400006 5580558.8600000003 5580558.8600000003

Water Balance Calculations

Hawaii Volcano National Park
Water Balance Calculations
Prepare Date: 11/27/2023
Catchment Areas
Catchment area is the surface area being used to collect rainwater for storage. The catchment area for both reservoirs is larger than their active water surfaces due to limits on water storage from spillways. Catchment areas were determined using the 2008 HAVO HAER process digrams.

Rain shed rain capture rates estimated in accordance with the "Guidelines on Rainwater Catchment System for Hawai'i". Rain capture was assumed to be slightly higher in the reservoirs due to their layout limiting losses. Rain capture is not affected by climatological effects.

Rain capture rate is measured in gallons per inch of rainwater per square foot of capture area (i.e., rooftop)

Catchment Area (sf) Rain Capture Rate (gal/in. rain/sf) Structure Rain Capture (gal/in. rain)

Reservoir 1124,1670.62577,604
Reservoir 249,3350.62530,834
Rain Shed Building 4339,2860.62524,554
Rain Shed Building 24143,9180.62527,449
EvapotranspirationEvapotranspiration
Evapotranspiration (ET) rates were modelled by the University of Hawai'i as part of the 2014 Evapotranspriation of Hawai'I model. Modeling was done using the widely accepted Penmen-Monteith Equation, applied to 720'x820' areas. At the time of this report, there was no evaporation data collected from the site (i.e., pan evaporation studies).

Ground cover at the HAVO water catchment area was assumed to be Developed-High Intensity due to usage and tree cover at the site.

ET rates were reported in in/month and apply on a square in. scale (1 in./month/sq. in.). The ET rate was applied only at the active water surface of the reservoirs, as calculated in the Storage Volume Calculations tab. Evapotranspiration (ET) rates were modelled by the University of Hawai'i as part of the 2014 Evapotranspriation of Hawai'I model. Modeling was done using the widely accepted Penmen-Monteith Equation, applied to 720'x820' areas. At the time of this report, there was no evaporation data collected from the site (i.e., pan evaporation studies).

Ground cover at the HAVO water catchment area was assumed to be Developed-High Intensity due to usage and tree cover at the site.

ET rates were reported in in/month and apply on a square in. scale (1 in./month/sq. in.). The ET rate was applied only at the active water surface of the reservoirs, as calculated in the Storage Volume Calculations tab.

Penman-Monteith Potential ET
(in/month/sq. in)Penman-Monteith Potential ET
(ft/month/sq. in)Total ET (ft3/month)Total ET (gal/month)Penman-Monteith Potential ET
(in/month/sq. in)Penman-Monteith Potential ET
(ft/month/sq. in)Total ET (ft3/month)Total ET (gal/month)
Percent Increase----Percent Increase----
January0.31020.0262,10715,763January0.31020.0262,40117,962
February0.29950.0252,03515,219February0.29950.0252,31917,343
March0.34490.0292,34317,526March0.34490.0292,67019,972
April0.34050.0282,31317,302April0.34050.0282,63619,717
May0.39230.0332,66519,934May0.39230.0333,03722,716
June0.37650.0312,55819,132June0.37650.0312,91521,802
July0.4310.0362,92821,901July0.4310.0363,33724,957
August0.43680.0362,96722,196August0.43680.0363,38125,293
September0.37370.0312,53918,989September0.37370.0312,89321,639
October0.33760.0282,29317,155October0.33760.0282,61419,549
November0.30040.0252,04115,265November0.30040.0252,32617,395
December0.3060.0262,07915,549December0.3060.0262,36917,719
Total4.250.35428,868215,930Total4.250.35432,896246,065
Water ConsumptionRainfall Data
MonthAverage Water Consumption
(gallons/months)20% Increase Water Consumption
(gallons/month)MonthAverage Rainfall (2007-2022)Minimum Rainfall Year (2010)
January544,875653,850January6.221.11
February475,674570,809February8.001.59
March524,703629,644March8.737.20
April447,123536,547April9.277.61
May387,990465,587May5.811.37
June540,999649,199June4.532.74
July477,634573,160July5.372.75
August512,764615,317August7.392.07
September426,191511,429September5.781.55
October421,981506,378October8.537.45
November443,389532,067November9.487.68
December475,033570,040December12.209.50
Total5,678,3566,814,027Annual Total91.3152.62

Average Year

Water Consumption January February March April May June July August September October November December 544874.66666666674 475674.25 524703.3666666667 447122.83333333337 387989.5 540999.16666666663 477633.5 512763.74999999994 426190.91666666663 421981.25 443389.4 475033.33333333337 Rainfall Data January February March April May June July August September October November December 6.2175000000000002 8.0018750000000001 8.7325000000000017 9.2693750000000001 5.8131250000000003 4.5249999999999995 5.3718750000000002 7.3850000000000007 5.7837500000000004 8.5337499999999995 9.4756250000000009 12.203124999999996 Water Consumption (gal)

Rainfall (in)

Drought and Increased Consumption Year

Water Consumption January February March April May June July August September October November December 653849.60000000009 570809.1 629644.04 536547.4 465587.39999999997 649198.99999999988 573160.19999999995 615316.49999999988 511429.09999999992 506377.5 532067.28 570040 Rainfall Data January February March April May June July August September October November December 1.1100000000000001 1.59 7.2 7.61 1.37 2.74 2.75 2.0699999999999998 1.55 7.45 7.68 9.5 Water Consumption (gal)

Rainfall (in)

Storage Volume Calculations

Hawaii Volcano National Park
Storage Volume Calculation
Prepare Date: 10/10/23
Raw Water Storage
LocationVolume (gal)Data Source
Reservoir 1628,558Storage volume calculated using Civil 3D and construction drawings (see below)
Reservoir 21,043,156Storage volume calculated using Civil 3D and construction drawings (see below)
Reservoir 1 Improved1,537,403Storage volume calculated using Civil 3D and plan drawings (see below)
Tank 3500,000Storage volume found in HAER Drawings (2008) Process Schematic
Tank 4500,000Storage volume found in HAER Drawings (2008) Process Schematic
Tank 5500,000Storage volume found in HAER Drawings (2008) Process Schematic
Tank 18750,000Storage volume found in HAER Drawings (2008) Process Schematic
Tank 19750,000Storage volume found in HAER Drawings (2008) Process Schematic
Total4,671,715Current Capacity
4,043,156Capacity without Reservoir 1
5,580,559Expanded Capacity
Reservoir CalculationsReservoir Calculations
Reservoir #1Reservoir #1 (GC1) Improvements
StageElevationContour AreaIncremental StorageTotal StorageSurface Comparison from Civil 3DStageElevationContour AreaIncremental StorageTotal Storage
(ft)(ft)(sf)(cf)(cf)(gal)Cut/Fill Factor2D AreaNet(ft)(ft)(sf)(cf)(cf)(gal)
INTAKE0.003,981.50169000(acre)(cy)(gal)INTAKE0.003,981.50510000
0.253,981.751,4942082081,55510.953,108.0627,735.30.253,981.752,3263553552,652
0.503,982.004,2587199276,9330.503,982.005,5099791,3349,977
0.753,982.255,3391,2002,12715,906Ave End Vs Surface Calc.823.2gallons0.753,982.259,9531,9333,26724,434
1.003,982.506,5541,4873,61327,026Ave End Vs Surface Calc.0.13%Difference1.003,982.5015,7693,2156,48248,484
1.253,982.757,9031,8075,42040,5431.253,982.7522,9574,84111,32384,693
1.503,983.009,3882,1617,58256,7111.503,983.0031,5176,80918,132135,626
1.753,983.2511,0482,55510,13675,8181.753,983.2541,4639,12327,254203,863
2.003,983.5012,8752,99013,12798,1862.003,983.5042,27110,46737,721282,154
2.253,983.7514,8683,46816,594124,1262.253,983.7543,06710,66748,388361,945
2.503,984.0017,0273,98720,581153,9482.503,984.0043,86910,86759,255443,230
2.753,984.2519,1164,51825,099187,7412.753,984.2544,67711,06870,324526,021
3.003,984.5021,3565,05930,158225,5833.003,984.5045,49111,27181,595610,328
3.253,984.7523,7465,63835,796267,7533.253,984.7546,31211,47593,070696,164
3.503,985.0026,2876,25442,050314,5343.503,985.0047,13811,681104,751783,539
3.753,985.2529,0586,91848,968366,2823.753,985.2547,97111,889116,640872,466
4.003,985.5031,9617,62756,596423,3344.003,985.5048,81012,098128,738962,957
4.253,985.7534,9958,37064,965485,9384.253,985.7549,65412,308141,0461,055,020
4.503,986.0038,1619,14574,110554,3394.503,986.0050,50512,520153,5651,148,669
SPILLWAY4.753,986.2541,2189,92284,032628,5584.753,986.2551,36112,733166,2991,243,914
5.003,986.5052,14312,938179,2371,340,690
Reservoir #25.253,986.7552,82513,121192,3581,438,835
StageElevationContour AreaIncremental StorageTotal StorageSurface Comparison from Civil 3DSPILLWAY5.503,987.0052,59513,178205,5351,537,403
(ft)(ft)(sf)(cf)(cf)(gal)Cut/Fill Factor2D AreaNet
INTAKE0.003,980.00119000(acre)(cy)(gal)
0.253,980.25313545440410.935,160.01,042,186.0
0.503,980.506741231771,327
0.753,980.751,2002344123,079Ave End Vs Surface Calc.970.2gallons
1.003,981.001,8943877985,972Ave End Vs Surface Calc.0.09%Difference
1.253,981.253,8327161,51411,326
1.503,981.506,6341,3082,82221,111
1.753,981.7510,2992,1174,93936,944
2.003,982.0014,8263,1418,08060,436
2.253,982.2516,5533,92212,00289,775
2.503,982.5018,4424,37416,376122,495
2.753,982.7520,5784,87821,254158,979
3.003,983.0022,9605,44226,696199,687
3.253,983.2525,3026,03332,729244,812
3.503,983.5028,0516,66939,398294,697
3.753,983.7531,2097,40846,806350,105
4.003,984.0034,7768,24855,054411,801
4.253,984.2535,3748,76963,822477,391
4.503,984.5035,9768,91972,741544,104
4.753,984.7536,5829,07081,811611,945
5.003,985.0037,1929,22291,033680,924
5.253,985.2537,8079,375100,408751,048
5.503,985.5038,4269,529109,937822,326
5.753,985.7539,0509,685119,621894,766
6.003,986.0039,6779,841129,462968,376
SPILLWAY6.253,986.2540,3029,997139,4591,043,156*Elevation to match Reservoir #1 for equalization between the two reservoirs.

Past Data

Input monthly precipitation (inches) and monthly water demand (gallons), which are both highlighted in light gray. All other cells are self-calculating. Months with a negative individual month water balance are highlighted in red. Highlighting is automatic based on conditional formatting. The predicted actual water volume for the month is the Actual Water Balance, highlighted in green.

Newly entered data does not automatically populate into the Water Balance graphs, but the data selection can be updated to include new data. Outdated data can be hidden or unchecked in the data selection to focus the graphs on specific data Data input is carried through 2030. If further data tracking is desired, copy and paste by year and input the new data. Caculation cells will not require any updates.

The tabs "Storage Volume Calculations" and "Water Balance Calculations" are requried and should not be deleted.

YearMonthINPUT Precipitation (in)Rainfall Accumulation (gal)INPUT Water Demand (gal/month)Individual Month Water Balance (gal)Cumulative Water Balance (gal) - starts at 0 gal, no storage limitsActual Water Balance (gal) - starts at 0 gal, storage limited to 4.67MGReservoir Percent Full
2018January9.421,511,357867,962627,632627,632627,63213%
February19.413,114,165731,4502,367,4962,995,1282,995,12864%
March10.031,609,226768,569823,1313,818,2593,818,25982%
April19.253,088,494849,0032,222,1896,040,4484,671,715100%
May5.94953,021933,0876,973,5344,671,715100%
June4.45713,964694,8327,668,3664,671,715100%
July3.76603,259581,3588,249,7254,671,715100%
August34.285,499,9265,477,73013,727,4554,671,715100%
September8.351,339,684414,055906,64014,634,0954,671,715100%
October26.244,209,978276,1473,916,67718,550,7724,671,715100%
November4.67749,261354,619379,37718,930,1494,671,715100%
December4.94792,580777,03119,707,1794,671,715100%
2019January1.67267,937765,732-513,55819,193,6224,158,15789%
February13.672,193,232400,2191,777,79420,971,4164,671,715100%
March3.04487,741456,01214,20420,985,6194,671,715100%
April10.881,745,601399,6801,328,61922,314,2384,671,715100%
May4.18670,644424,522226,18822,540,4264,671,715100%
June4.16667,436513,158135,14622,675,5724,671,715100%
July9.061,453,598531,282900,41523,575,9874,671,715100%
August8.201,315,618578,941714,48224,290,4694,671,715100%
September4.53726,799358,446349,36424,639,8324,671,715100%
October8.841,418,301482,974918,17225,558,0044,671,715100%
November7.791,249,837423,911810,66226,368,6664,671,715100%
December9.151,468,037559,161893,32727,261,9934,671,715100%
2020January27.954,484,333533,7443,934,82631,196,8204,671,715100%
February6.261,004,362552,348436,79531,633,6154,671,715100%
March16.972,722,688391,4422,313,72033,947,3354,671,715100%
April8.221,318,82764,9201,236,60535,183,9404,671,715100%
May3.38542,29187,833434,52435,618,4644,671,715100%
June2.99479,719167,923292,66535,911,1294,671,715100%
July3.01482,928149,100311,92736,223,0564,671,715100%
August2.67428,37864,897341,28636,564,3424,671,715100%
September6.471,038,05572,260946,80637,511,1474,671,715100%
October5.12821,45956,060748,24438,259,3924,671,715100%
November14.632,347,255150,7392,181,25240,440,6444,671,715100%
December7.671,230,584134,8161,080,21941,520,8634,671,715100%
2021January18.452,960,141185,9802,758,39944,279,2614,671,715100%
February8.971,439,158311,1511,112,78845,392,0504,671,715100%
March23.793,816,897493,2543,306,11848,698,1674,671,715100%
April6.411,028,428465,830545,29649,243,4634,671,715100%
May5.31851,943447,309384,70049,628,1634,671,715100%
June2.49399,499646,235-265,86849,362,2954,405,84794%
July4.24680,271610,20748,16349,410,4584,454,01095%
August4.58734,821515,828196,79749,607,2554,650,807100%
September4.54728,403520,409189,00549,796,2604,671,715100%
October7.151,147,155386,523743,47750,539,7384,671,715100%
November3.54567,962592,231-39,53450,500,2044,632,18199%
December25.204,043,120475,1783,552,39254,052,5964,671,715100%
2022January1.29206,969534,934-343,72753,708,8694,327,98793%
February2.60417,147518,460-116,53253,592,3374,211,45690%
March4.37701,128746,566-62,96453,529,3744,148,49289%
April10.191,634,896524,2841,093,31054,622,6844,671,715100%
May6.421,030,033553,286456,81255,079,4974,671,715100%
June3.90625,721795,328-188,73954,890,7584,482,97696%
July4.01643,369525,55495,91554,986,6724,578,89098%
August2.06330,509806,005-497,69254,488,9814,081,19987%
September3.20513,412628,043-133,62054,355,3613,947,57984%
October2.07332,113777,832-462,87353,892,4873,484,70575%
November6.621,062,121650,208396,64954,289,1363,881,35483%
December8.981,440,762693,242731,97155,021,1074,613,32599%

Percent Storage Capacity January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December January February March April May June July August September October November December 2018 2019 2020 2021 2022 0.13434725604970874 0.64111962071969197 0.81731423494613975 1 1 1 1 1 1 1 1 1 0.89007083991037084 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0.94308988576795649 0.95339937878553249 0.99552466479214441 1 1 0.99153768060308112 1 0.92642372987878729 0.90147965812822761 0.88800205126402687 1 1 0.9595997049520073 0.98013060854356637 0.87359763588152739 0.84499566540654047 0.74591566833922529 0.83081993744673455 0.98750144963373243

Input monthly precipitation (inches) and monthly water demand (gallons), which are both highlighted in light gray. All other cells are self-calculating. Months with a negative individual month water balance are highlighted in red.

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. Updated .