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

{"sheet":"Information","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Glide WD - 2023 M&I Water Rates Sch O-10.Z25.xlsm"]
["01/09/2023"]
[]
[]
[]
[]
[]
["1/26/2022","slf","removed construction rates since contractor converted to WIIN Act"]
[]
["10/26/2022","JH","Updated file names, title, headings, and date"]
[null,null,"Updated O&M costs & Linked input"]
[null,null,"Awaiting for schedule FC composite interest rate to be completed "]
["10/27/2022","JH","2023 FC (FA-1I) interest rate is the same as FY 2019, no update needed."]
["01/09/2023","KJ","Review"]

{"sheet":"OUTPUT","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"+Information!A1","v":"Glide WD - 2023 M&I Water Rates Sch O-10.Z25.xlsm"}]
[{"$f":"+Information!A2","v":"01/09/2023"}]
["CENTRAL VALLEY PROJECT"]
["GLIDE WATER DISTRICT"]
["TEHAMA -COLUSA CANAL"]
["CONTRACT NO. 07-07-20-W040-P"]
["2023 M&I WATER RATES "]
["FOR TIERED PRICING PURPOSES"]
["Category","Component","Cost of Service\nRate per Acre-Foot\n<Sch  S-2, A-2A>","Full Cost\nRate per Acre-Foot\n<Sch  S-2, A-2A>"]
["Construction Costs per Acre-Foot","Storage",0,"TBD"]
["Construction Costs per Acre-Foot","Other Cost",0,"TBD"]
["Construction Costs per Acre-Foot","Conveyance ",0,"TBD"]
["Total","Total Capital",{"$f":"SUM(C11:C13)","v":0},{"$f":"SUM(D11:D13)","v":0}]
["O&M Costs per Acre-Foot","Water Marketing",{"$f":"[1]OUTPUT!$E$161","v":15.52},"TBD"]
["O&M Costs per Acre-Foot","Conveyance",{"$f":"[1]OUTPUT!$I$161","v":0},"TBD"]
["O&M Costs per Acre-Foot","Storage ",{"$f":"[1]OUTPUT!$G$169","v":17.23},"TBD"]
["Total","Total O&M",{"$f":"SUM(C15:C17)","v":32.75},{"$f":"SUM(D15:D17)","v":0}]
["Grand Total","-",{"$f":"+C14+C18","v":32.75},{"$f":"+D14+D18","v":0}]

{"sheet":"Linked Input","index":2,"n_rows":32,"n_cols":19,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+OUTPUT!A2","v":"Glide WD - 2023 M&I Water Rates Sch O-10.Z25.xlsm"}]
[{"$f":"+OUTPUT!A3","v":"01/09/2023"}]
[]
[null,"Special Rates 2023 Sch S-1.Z25.XLSM"]
[]
[null,null,null,null,null,null,null,null,"Net Unpaid",null,"Unpaid Construction",null,"FY 2023",null,"Unpaid "]
[null,null,null,null,null,null,null,null,"Construction",null,"Annualized Costs",null,"Projected",null,"Construction Rate"]
[null,null,null,null,null,null,null,null,"at 9/30/2021",null,"8 Remaining Yrs",null,"Deliveries",null,"Per Acre Foot"]
[]
[null,"Direct Pumping"]
[null,null,"NO DIRECT PUMPING FOR THIS CONTRACT",null,null,null,null,null,null,null,{"$f":"+I11/8","v":0}]
[]
[null,"Special Rates 2023 Sch S-2.Z25.XLSM"]
[]
[null,null,null,null,null,null,null,null,"Net Unpaid",null,"Unpaid Construction",null,null,null,{"$f":"M6","v":"FY 2023"},null,"Unpaid Construction Rate"]
[null,null,null,null,null,null,null,null,"Construction",null,"Annulized Cost",null,"Annual Interest @",null,"Projected ",null,"Construction"]
[null,null,null,null,null,null,null,null,{"$f":"I8","v":"at 9/30/2021"},null,{"$f":"K8","v":"8 Remaining Yrs"},null,{"$f":"+K32","v":8.0119999999999997E-2},null,"Deliveries",null,"only","Interest","Total"]
[]
[null,null,"Storage",null,null,null,null,null,{"$f":"[2]OUTPUT!$M$19","v":2158285.299800545},null,{"$f":"+I19/8","v":269785.66247506812},null,{"$f":"+I19*M$17","v":172921.81822001966},null,{"$f":"[2]OUTPUT!$S$19","v":245181.57142857148},null,{"$f":"ROUND(+K19/O19,2)","v":1.1000000000000001},{"$f":"ROUND(+M19/O19,2)","v":0.71},{"$f":"+Q19+R19","v":1.81}]
[]
[null,null,"Conveyance",null,null,null,null,null,{"$f":"[2]OUTPUT!$M$26","v":1417022.4699999951},null,{"$f":"+I21/8","v":177127.80874999939},null,{"$f":"+I21*M$17","v":113531.8402963996},null,{"$f":"[2]OUTPUT!$S$26","v":172696.71428571426},null,{"$f":"ROUND(+K21/O21,2)","v":1.03},{"$f":"ROUND(+M21/O21,2)","v":0.66},{"$f":"+Q21+R21","v":1.69}]
[]
[null,null,"Other Costs",null,null,null,null,null,{"$f":"[2]OUTPUT!$M$89","v":1629023.4636188005},null,{"$f":"+I23/8","v":203627.93295235006},null,{"$f":"+I23*M$17","v":130517.35990513829},null,{"$f":"[2]OUTPUT!$S$89","v":331768.71428571432},null,{"$f":"ROUND(+K23/O23,2)","v":0.61},{"$f":"ROUND(+M23/O23,2)","v":0.39},{"$f":"+Q23+R23","v":1}]
[]
[]
[null,"M&I 2023 Sch A-13"]
[]
[null,null,"M&I COMPOSITE INTEREST RATE FOR CAPITAL",null,null,null,null,null,null,null,{"$f":"[3]Manual_Input!K7","v":2.3754608109186889E-2}]
[]
[null,"IRR 2023 FC (FA&B-1I) GS Composite Interest Rate All Components.xlsm"]
[]
[null,null,"M&I COMPOSITE INTEREST RATE FOR CAPITAL",null,null,null,null,null,null,null,8.0119999999999997E-2]