{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Information","OUTPUT","Linked Input"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":1,"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":"Information","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Stony Creek WD - 2023 M&I Water Rates Sch O-7.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 cost on Output tab"]
[null,null,"Updated Linked input tab"]
[null,null,"Awaiting for IRR 2023 FC to be completed"]
["10/27/2022",null,"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":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"+Information!A1","v":"Stony Creek WD - 2023 M&I Water Rates Sch O-7.Z25.xlsm"}]
[{"$f":"+Information!A2","v":"01/09/2023"}]
["CENTRAL VALLEY PROJECT"]
["STONY CREEK WATER DISTRICT"]
["BLACK BUTTE D & R"]
["CONTRACT NO. 2-07-20-W0261-P"]
["2023 M&I WATER RATES "]
["FOR TIERED PRICING PURPOSES"]
["Category","Component","Cost of Service\nRate per Acre-Foot\n<Sch S-2, A-8>","Full Cost\nRate per Acre-Foot\n<Sch S-2, A-8> "]
["Construction Costs per Acre-Foot","Storage",0,"TBD"]
["Construction Costs per Acre-Foot","Other Cost",0,"TBD"]
["Total","Total Capital",{"$f":"SUM(C11:C12)","v":0},{"$f":"SUM(D11:D12)","v":0}]
["O&M Cost Per Acre-Foot","Water Marketing",{"$f":"[1]OUTPUT!$E$161","v":15.52},"TBD"]
["O&M Cost Per Acre-Foot","Storage ",{"$f":"[1]OUTPUT!$G$169","v":17.23},"TBD"]
["Total","Total O&M",{"$f":"SUM(C14:C15)","v":32.75},{"$f":"SUM(D14:D15)","v":0}]
["Grand Total","-",{"$f":"+C13+C16","v":32.75},{"$f":"+D13+D16","v":0}]

{"sheet":"Linked Input","index":2,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+OUTPUT!A2","v":"Stony Creek WD - 2023 M&I Water Rates Sch O-7.Z25.xlsm"}]
[{"$f":"+Information!A2","v":"01/09/2023"}]
[]
[]
[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,"FY 2023",null,"Unpaid Construction Rate"]
[null,null,null,null,null,null,null,null,"Construction",null,"Annualized Cost",null,"Annual Interest @",null,"Projected ",null,"Construction"]
[null,null,null,null,null,null,null,null,"at 9/30/2021",null,"8 Remaining Years",null,{"$f":"+K22","v":8.0119999999999997E-2},null,"Deliveries",null,"only","Interest","Total"]
[]
[null,null,"Storage (All Other Contractors)",null,null,null,null,null,{"$f":"[2]OUTPUT!$M$19","v":2158285.299800545},null,{"$f":"+I11/8","v":269785.66247506812},null,{"$f":"+I11*M$9","v":172921.81822001966},null,{"$f":"[2]OUTPUT!$S$19","v":245181.57142857148},null,{"$f":"ROUND(+K11/O11,2)","v":1.1000000000000001},{"$f":"ROUND(+M11/O11,2)","v":0.71},{"$f":"+Q11+R11","v":1.81}]
[]
[null,null,"Other Costs",null,null,null,null,null,{"$f":"[2]OUTPUT!$M$89","v":1629023.4636188005},null,{"$f":"+I13/8","v":203627.93295235006},null,{"$f":"+I13*M$9","v":130517.35990513829},null,{"$f":"[2]OUTPUT!$S$89","v":331768.71428571432},null,{"$f":"ROUND(+K13/O13,2)","v":0.61},{"$f":"ROUND(+M13/O13,2)","v":0.39},{"$f":"+Q13+R13","v":1}]
[]
[]
[]
[]
[]
[]
[null,"I:\\WTRates\\Rates\\2023\\Full Cost\\FC\\IRR 2023 FC (FA&B-1I) GS Composite Interest Rate All Components"]
[]
[null,null,"FULL COST COMPOSITE INTEREST RATE FOR CAPITAL",null,null,null,null,null,null,null,8.0119999999999997E-2]