{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["OUTPUT"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":110,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"OUTPUT","index":0,"n_rows":121,"n_cols":11,"rows_kept":121,"cut":false,"hidden":false,"merged":[]}
[]
["IRR 2022 Sch B-6A.Z26"]
["12/14/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION  OPERATION & MAINTENANCE EXPENSE AND PROJECT USE ENERGY COST"]
["BY FACILITY AND/OR COMPONENT FOR FY 2022"]
["2024 IRRIGATION WATER RATES"]
[]
["Category","A) Facility/Contractor\n<Ref>","Related Footnotes","B) Unpaid/(Credit) Previous Period","C) Estimated Project Use Energy Cost\nFY2022","D) True-Up\nFY2021","E) Total\nSUM(B:D)","F) Offset: % of Applied *","G) Direct Pumping\nDP Rate x AF","H) Charge Adjustment\nSee Sch B-1","I) Unpaid/ (Remaining)\nSUM(E:H)"]
["Storage (Based on Offset)","San Felipe Unit Contractors","2/",0,1452.77,-3.5219864769625082,1449.2480135230358,-1449.2480135230358,"-","-",0]
["Storage (Based on Offset)","All Others","-",0,4681339.6981495805,731.7447414274626,4682071.4428910082,-4682071.4428910082,"-","-",0]
["Total","Storage Total (Based on Offset)","-",0,4682792.4681495801,728.22275495050008,4683520.6909045316,-4683520.6909045316,"-","-",0]
["Direct Pumping (Based on Offset)","Corning WD","-",0,10805.1049,-13.5769,10791.527999999997,-10791.527999999997,"-","-",0]
["Direct Pumping (Based on Offset)","Cross Valley Canal Contractors (Dos Amigos & Banks)","-",0,0,-3.9699445213,-3.9699445212990905,3.9699445212990905,"-","-",0]
["Direct Pumping (Based on Offset)","Dunnigan WD","-",0,3485.4171000000001,-3.7404000000000002,3481.6766999999982,-3481.6766999999982,"-","-",0]
["Direct Pumping (Based on Offset)","Panoche WD","-",0,829.41449999999998,-0.30099999999999999,829.11349999999982,-829.11349999999982,"-","-",0]
["Direct Pumping (Based on Offset)","Proberta WD","-",0,504.18119999999999,-0.32590000000000002,503.85529999999989,-503.85529999999989,"-","-",0]
["Direct Pumping (Based on Offset)","Glenn Valley WD","-",0,0,0,0,0,"-","-",0]
["Direct Pumping (Based on Offset)","Westside WD","-",0,29899.397499999999,-9.7919999999999998,29889.605499999994,-29889.605499999994,"-","-",0]
["Direct Pumping (Based on Offset)","Wintu PP (Bella Vista WD)","-",0,520.2382602632,-13.9270697567,506.31119050649636,-506.31119050649636,"-","-",0]
["Total","Direct Pumping Total (Based on Offset)","-",0,46043.7534602632,-45.633214277999997,45998.120245985185,-45998.120245985185,"-","-",0]
["Direct Pumping (Direct Cost)","Colusa County WD","-",-0.6914925187593326,187003.13804256701,-165.28576029409999,186837.16078975415,"-",-221714.68,0,-34877.519210245839]
["Direct Pumping (Direct Cost)","Kanawha WD","-",-0.48485472299216781,0,-19.875877836099999,-20.360732559092167,"-",-15373.04,15393,-0.40073255909373984]
["Direct Pumping (Direct Cost)","Orland-Artois WD","-",-0.14862426821491681,16386.381099999999,-29.0183,16357.214175731784,"-",-28219.3,11862,-8.582426821521949E-2]
["Direct Pumping (Direct Cost)","San Benito County WD","1/, 3/",-211753.49317109367,49733.243564366399,-85.617388670988319,-162105.86699539828,"-",-30833.279999999999,0,-192939.14699539827]
["Direct Pumping (Direct Cost)","Santa Clara Valley WD","1/, 3/",-578275.35803482193,0,-62.55696529211167,-578337.91500011401,"-",0,578337,-0.91500011400785297]
["Direct Pumping (Direct Cost)","San Luis WD","-",0,736827.37244072999,-422.49196034929997,736404.8854654337,"-",-133419.14000000001,-602985,0.74546543369069695]
["Direct Pumping (Direct Cost)","Westlands WD","4/",-0.44141984172165394,2603510.4922214272,-1365.0855695482219,2602144.965232037,"-",-1212749.29,-1389395.67,5.2320370450615883E-3]
["Direct Pumping (Direct Cost)","Westlands WD DD #2","4/",9.5611369080415898E-2,0,-3.3663918249780718,-3.2707804558976559,"-",0,3,-0.27078045589765587]
["Total","Direct Pumping Total (Direct Cost)","-",-790030.51700084517,3593460.6273690904,-2153.2982138158,2801276.8121544295,0,-1642308.73,-1386785.67,-227817.58784557058]
["Grand Total","Grand Total","-",-790030.51700084505,8322296.8489789329,-1470.7086731432998,7530795.6233049463,-4729518.8111505164,-1642308.73,-1386785.67,-227817.58784557058]
[]
[]
["Needed based on Column F"]
[]
["Facility/Contractor","Total Cost FY2022"]
["Storage",4683520.6909045316]
["Direct Pumping",45998.120245985185]
["Storage & Direct Pumping Total",4729518.8111505164]
["Applied (offset/credit) **",4729518.8111505164]
[null," "]
[]
["Amount Applied to \"Other Cost is a Credit in Accounting for following Contractors; "]
[]
["Facility/Contractor","Available From Previous Period **","Rate x AF in FY 2022 for \"Other\" Cost","Total Available","Applied to \"Other\" Cost","Charge Adjustment","Remaining Available"]
["Westlands Water District",-0.24578706757165492,271137.33,271137.08421293244,451383.13853187335,-180246,-5.431894090725109E-2]
["Westlands Water District DD#2",0.26464384214614256,0,0.26464384214614256,0.440573329936849,0,-0.17592948779070644]
["Santa Clara Valley Water District",677025.38154730492,0,677025.38154730492,1127097.1747581603,0,-450071.79321085534]
["San Benito County Water District",364335.84762353211,8257.76,372593.60762353212,620285.75874904776,0,-247692.15112551564]
["Colusa County Water District",415928.55098321883,5454.9,421383.45098321885,701510.03202801605,0,-280126.5810447972]
["Kanawha Water Districit",14301.797315070617,0,14301.797315070617,23809.322053686748,-9507.7900000000009,0.26526138386907405]
["Orland-Artois Water Districit",97697.473867661785,1785.24,99482.713867661791,165616.66488966273,-66133,-0.95102200093970168]
["San Luis Water Districit",959646.93938933779,25358.85,985005.78938933776,1639816.2795667399,0,-654810.49017740216]
["Total",2528936.0095829004,311994.08,2840930.0895829005,4729518.8111505164,-255886.79,-1632701.9315676163]
[]
["**"]
["Project Use Energy O&M cost recoverable through water rates are for Storage and Direct Pumping.  Beginning March 2016, there are 8 contractors that pay the Project Use Energy O&M based on Rates times their Acre-Feet. "]
["These 8 contractors receive a credit to their O&M cost for paying WAPA on behalf of others for Storage and Direct Pumping Project Use Energy.  The credit is offset by allocating the credit to the contractors receiving the service.  "]
["Any shortages in payment of Project Use Energy O&M cost will be recoverable in the following year under a similar process (See schedule B-6A for a detail summary of the remaining cost)."]
[]
["Footnotes"]
[]
["1/"]
["Allocation of Gianelli, WR Pump Generator"]
[]
["Gianelli, WR Pump Generator Costs","Total","San Benito County WD","Santa Clara Valley WD"]
["2022 Storage Deliveries (Excludes 215 Water)",1616,1616,0]
["2022 Storage Deliveries (Excludes 215 Water): Ratios",1,1,0]
["2021 Storage Deliveries (for True-Up)",15999,9379,6620]
["2021 Storage Deliveries (for True-Up): Ratios",1,0.58621999999999996,0.41377999999999998]
[]
["Gianelli (2021 True-Up and 2022 Estimate)","Total","San Benito County WD","Santa Clara Valley WD","All Other Storage Contractors","Grand Total"]
["Gianelli, WR Pump Generator (2022 Estimate)",13551.35,13551.35,0,5512392.6733244201,5525944.0233244197]
["Gianelli, WR Pump Generator (2021 True-Up)",-8.2135985071000004,-4.8149757168321621,-3.3986227902678379,-693.2441583758,-701.45775688289996]
[]
["2/"]
["Allocation of Other PUE storage costs"]
[]
["Other PUE Storage Costs"," San Felipe Unit (Storage): Total"," San Felipe Unit (Storage): San Benito County WD"," San Felipe Unit (Storage): Santa Clara Valley WD","All Other Contractors","Grand Total"]
["2022 Storage Deliveries (Excludes 215 Water)",1616,1616,0,542831,544447]
["2022 Storage Deliveries (Excludes 215 Water): Ratios",2.97E-3,1,0,0.99702999999999997,1]
["2021 Storage Deliveries (for True-Up)",15999,9379,6620,737257,753256]
["2021 Storage Deliveries (for True-Up): Ratios",2.1239999999999998E-2,0.58621999999999996,0.41377999999999998,0.97875999999999996,1]
["Other PUE Offset Storage Cost (2022 Estimate)",1452.77,1452.77,0,487694.92,489147.69]
["Other PUE Offset Storage Cost (2021 True-Up)",-3.5219864769625082,-2.0646589125249615,-1.4573275644375467,-162.29658588473751,-165.81857236170001]
[]
["3/"]
["Allocation of Pacheco Pumping Plant costs - Allocation is based on same water delivery ratios as shown in 1/ above."]
[]
["Pacheco Pumping Plant Costs","Total","San Benito County WD","Santa Clara Valley WD"]
["Pacheco PP (2022 Estimate)",36181.893564366401,36181.893564366401,0]
["Pacheco PP (2021 True-Up)",-137.8363292862,-80.802412954156154,-57.03391633204383]
[]
["4/"]
["Allocation of Pleasant Valley PP, Pleasant Valley Relifts, & Westlands WD Relifts"]
[]
["Pleasant Valley PP, Pleasant Valley Relifts, & Westlands WD Relifts Costs","Total","Westlands WD DD ","Westlands WD DD #2"]
["2022 Storage Deliveries (Excludes 215 Water)",88103,88103,0]
["2022 Storage Deliveries (Excludes 215 Water): Ratios",1,1,0]
["2021 Storage Deliveries (for True-Up)",132595,132269,326]
["2021 Storage Deliveries (for True-Up): Ratios",1,0.99753999999999998,0]
["2022 Estimate Pleasant Valley PP",246833.126119197,246833.126119197,0]
["2022 Estimate Pleasant Valley Relifts",43930.155400000003,43930.155400000003,0]
["2022 Estimate Westlands WD Relifts",2312747.2107022302,2312747.2107022302,0]
["2022 Estimate: Total",2603510.4922214272,2603510.4922214272,0]
["2021 True-Up Pleasant Valley PP",-159.65482806879999,-159.26207719175073,-0.39275087704924794]
["2021 True-Up Pleasant Valley Relifts",-26.904800000000002,-26.838614192000001,-6.6185807999999999E-2]
["2021 True-Up Westlands WD Relifts",-1181.8923333043999,-1178.9848781644712,-2.9074551399288238]
["2021 True-Up: Total",-1368.4519613732,-1365.0855695482219,-3.3663918249780718]
[]
["Note:  Storage Expense Allocation"]
[]
["Storage Expense Allocation Costs","San Felipe Unit Contractors","All Other Contractors","Total"]
["2022 Estimate Gianelli, WR Pump Generator",0,5512392.6733244201,5512392.6733244201]
["2022 Estimate Other PUE Offset Storage Cost",1452.77,487694.92,489147.69]
["2022 Estimate Regeneration Credit for FY 2022",null,-1318747.89517484,-1318747.89517484]
["2022 Estimate PUE Offset Storage Cost: Total",1452.77,4681339.6981495805,4682792.4681495801]
["2021 True-Up Gianelli, WR Pump Generator",0,-693.2441583758,-693.2441583758]
["2021 True-Up Other PUE Offset Storage Cost",-3.5219864769625082,-162.29658588473751,-165.81857236170001]
["2021 True-Up Regeneration Credit for FY 2022",null,1587.2854856880001,1587.2854856880001]
["2021 True-Up PUE Offset Storage Cost: Total",-3.5219864769625082,731.7447414274626,728.22275495050008]