{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFORMATION","Flow Chart","INPUT","OUTPUT","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":33,"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":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Temporary 2023 IRR & M&I Rates Sch T-1.Z25.XLSM"]
["01/09/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF IRRIGATION AND M&I TEMPORARY "]
["COST-OF-SERVICE WATER RATES"]
["2023 SPECIAL WATER RATES"]
[]
[null,null,"SPECIAL FILE INFORMATION"]
[]
[]
[null,null,"SOURCE DATA:"]
[]
[null,"SEE FLOW CHART"]
[]
[]
[]
["10/25/2022","rm","Updated file names, title, headings, and date. Updated links on input tab. "]
[null,null,"Verified Sch T-1 Input tab with IRR Sch A-8 Output tab"]
[null,null,"Verified Sch T-1 Input tab with M & I Sch A-8 Output tab"]
[null,null,"Verified Sch T-1 Input tab with M & I Sch A-11 Output tab"]
[null,null,"Verified Sch T-1 Input tab with Sch T-2 Output tab"]
[null,null,"Verified Sch T-1 Input tab with Sch T-3 Output tab"]
[null,null,"Ready for review"]
["01/09/2023","KJ","Review"]

{"sheet":"Flow Chart","index":1,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[{"$f":"+INFORMATION!A1","v":"Temporary 2023 IRR & M&I Rates Sch T-1.Z25.XLSM"}]
[{"$f":"+INFORMATION!A2","v":"01/09/2023"}]
[{"$f":"+INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"+INFORMATION!A4","v":"SCHEDULE OF IRRIGATION AND M&I TEMPORARY "}]
[{"$f":"+INFORMATION!A5","v":"COST-OF-SERVICE WATER RATES"}]
[{"$f":"+INFORMATION!A6","v":"2023 SPECIAL WATER RATES"}]

{"sheet":"INPUT","index":2,"n_rows":91,"n_cols":11,"rows_kept":91,"cut":false,"hidden":true,"merged":[[15,2,16,2],[28,2,29,2],[2,2,3,2]]}
[]
["From IRR Sch A-8 (OUTPUT tab)"]
[null,null," Water                          Marketing","","",null,"","Conveyance Pumping"]
[null,null,null,"","Storage",null,"Conveyance","Corning","Jones","O'Neill ","Dos Amigos"]
[]
["Cost Per A/F",null,{"$f":"[1]OUTPUT!$G$320","v":22.77},"",null,null,{"$f":"[1]OUTPUT!$K$320","v":0},{"$f":"[1]OUTPUT!$M$320","v":0},{"$f":"[1]OUTPUT!$O$320","v":0},{"$f":"[1]OUTPUT!$Q$320","v":0},{"$f":"[1]OUTPUT!$S$320","v":0}]
[null,null,null,""]
["Cost Per A/F (Friant)",null,{"$f":"[1]OUTPUT!$G$322","v":19.77}]
[]
[null,"San Felipe Unit Cost Per A/F (Sch A-9)",null,null,{"$f":"[1]OUTPUT!$I$324","v":12.8}]
[]
[null,"All Other Contractors Cost Per A/F (Sch A-9)",null,null,{"$f":"[1]OUTPUT!$I$326","v":13.04}]
[]
[]
["From M&I Sch A-8 (OUTPUT tab)"]
[null,null," Water                          Marketing","","",null,"","Conveyance Pumping"]
[null,null,null,"","Storage",null,"Conveyance","N/A","Dos Amigos","O'Neill ","Jones"]
[]
["Cost Per A/F",null,{"$f":"[2]OUTPUT!$E$161","v":15.52},"",null,null,{"$f":"[2]OUTPUT!$I$161","v":0},null,{"$f":"[2]OUTPUT!$K$161","v":0},{"$f":"[2]OUTPUT!$M$161","v":0},{"$f":"[2]OUTPUT!$O$161","v":0}]
[null,null,null,""]
["Cost Per A/F (Friant)",null,{"$f":"[2]OUTPUT!$E$163","v":12.52}]
[]
[null,"San Felipe Unit Cost Per A/F (Sch A-9)",null,null,{"$f":"[2]OUTPUT!$G$167","v":16.98}]
[]
[null,"All Other Contractors Cost Per A/F (Sch A-9)",null,null,{"$f":"[2]OUTPUT!$G$169","v":17.23}]
[null,"Folsom South Canal",null,null,null,null,{"$f":"[2]OUTPUT!$I$165","v":6.47}]
[]
["From M&I Sch A-11 (OUTPUT tab)"]
[null,null,"Direct Pumping",""]
[null,null,null,""]
[]
["City of Coalinga",null,{"$f":"[3]OUTPUT!$H$59","v":32.409999999999997},""]
[]
["San Felipe Unit:"]
[null,"San Benito County WD",{"$f":"[3]OUTPUT!$D$87+[3]OUTPUT!$H$87","v":28.17}]
[null,"Santa Clara Valley WD",{"$f":"SUM([3]OUTPUT!$D$87:$H$87)","v":29.15}]
[]
["Cross Valley Canal",null,{"$f":"[3]OUTPUT!$F$59+[3]OUTPUT!$L$59","v":10.59}]
[]
[]
["From Sch T-2 (OUTPUT tab)"]
[]
["Irrigation Rates:",null,"  Total"]
[null,null,"Capital"]
[1,"Sacramento, American, Stanislaus,",{"$f":"[4]Output!$V$18","v":2.04}]
[null,"      San Joaquin Rivers & the Delta"]
[]
[2,"Delta-Mendota Canal and Pool",{"$f":"[4]Output!$V$21","v":5.32}]
[]
[3,"Folsom-South Canal  and",{"$f":"[4]Output!$V$23","v":4.4000000000000004}]
[null,"   Tehama-Colusa Canal"]
[]
[4,"Corning Canal",{"$f":"[4]Output!$V$26","v":8.14}]
[]
[5,"Kern Wildlife Refuge",{"$f":"[4]Output!$V$28","v":6.0200000000000005}]
[]
[6,"Kings County WD & Lakeside ID",{"$f":"[4]Output!$V$30","v":4.0599999999999996}]
[null,"  (State Delta Pumping Plant)"]
[]
[]
["From Sch T-3 (OUTPUT tab)"]
[null,null,"  Total"]
["M&I Capital Cost Per AF (including interest):",null,"Capital including Interest"]
[1,"Sacramento, American, Stanislaus,",{"$f":"[5]Output!$V$17","v":2.04}]
[null,"      San Joaquin Rivers & the Delta"]
[]
[2,"Delta-Mendota Canal and Pool",{"$f":"[5]Output!$V$20","v":4.01}]
[]
[3,"Folsom-South Canal, Toyon Pipeline and ",{"$f":"[5]Output!$V$22","v":3.26}]
[null,"   Tehama-Colusa Canal  "]
[]
[4,"Musco Olive & Tracy Golf & Country Club",{"$f":"[5]Output!$V$25","v":2.48}]
[null,"   (State Delta Pumping Plant)"]
[]
[5,"Friant Dam",{"$f":"[5]Output!$V$28","v":2.95}]
[]
[6,"Friant-Kern & Madera Canals",{"$f":"[5]Output!$V$30","v":4.17}]
[]
[7,"San Luis Canal:"]
[null,"   Before Dos Amigos Pumping Plant",{"$f":"[5]Output!$V$34","v":4.2699999999999996}]
[null,"   After Dos Amigos Pumping Plant",{"$f":"[5]Output!$V$35","v":4.8199999999999994}]
[]
[8,"Coalinga Canal",{"$f":"[5]Output!$V$37","v":5.18}]
[null,"   (Pleasant Valley Pumping Plant)"]
[]
[9,"San Felipe Unit:"]
[null,"   San Benito (before Coyote Pumping Plant)",{"$f":"[5]Output!$V$41","v":4.72}]
[null,"   Santa Clara (after Coyote Pumping Plant)",{"$f":"[5]Output!$V$42","v":5.1899999999999995}]
[]
[10,"Cross Valley Canal",{"$f":"[5]Output!$V$44","v":2.84}]
[null,"   (State Delta Pumping Plant)"]

{"sheet":"OUTPUT","index":3,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Bureau of Reclamation Logo"]
[{"$f":"INFORMATION!$A$1","v":"Temporary 2023 IRR & M&I Rates Sch T-1.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/09/2023"}]
[{"$f":"INFORMATION!$A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!$A4","v":"SCHEDULE OF IRRIGATION AND M&I TEMPORARY "}]
[{"$f":"INFORMATION!$A5","v":"COST-OF-SERVICE WATER RATES"}]
[{"$f":"INFORMATION!$A6","v":"2023 SPECIAL WATER RATES"}]
["Print button"]
[]
["Category","A) Service Area / Contractor","Related Footnotes","  B) Total\n Construction Cost\nPer Acre-Foot","C) O&M Costs Per Acre-Foot: Water\nMarketing\n<Sch A-8>","D) O&M Costs Per Acre-Foot: Storage\n<Sch A-8>","E) O&M Costs Per Acre-Foot: Conveyance\n1/ \n<Sch A-8>","F) O&M Costs Per Acre-Foot: Conveyance\nPumping  1/\n<Sch A-8>","G) O&M Costs Per Acre-Foot: Direct\nPumping\n<Sch A-11>","H) O&M Costs Per Acre-Foot: Total\nO&M Costs\nPer Acre-Foot\n(C+D+E+F+G)","I) Cost of\nService Rate\nPer Acre-Foot\n(B+H)"]
["Irrigation Costs per AF (Schedule T-2)","Sacramento, American, Stanislaus, San Joaquin Rivers & the Delta","-",2.57,22.77,13.04,0,0,"-",{"$f":"SUM(E11:I11)","v":35.81},{"$f":"D11+J11","v":38.380000000000003}]
["Irrigation Costs per AF (Schedule T-2)","Delta-Mendota Canal and Pool","-",6.71,22.77,13.04,0,0,"-",35.81,42.52]
["Irrigation Costs per AF (Schedule T-2)","Tehama-Colusa Canals","-",5.54,22.77,13.04,0,0,"2/",35.81,41.35]
["Irrigation Costs per AF (Schedule T-2)","Corning Canal ","-",10.27,22.77,13.04,0,0,"2/",35.81,46.08]
["Irrigation Costs per AF (Schedule T-2)","Friant-Kern Canal","3/",7.6,19.77,13.04,0,0,"-",32.81,40.410000000000004]
["Irrigation Costs per AF (Schedule T-2)","Friant-Kern Canal: Kings County WD & Lakeside ID ","3/",5.12,19.77,13.04,0,0,"2/",32.81,37.93]
["M&I Costs per AF (including interest) (Schedule T-3)","Sacramento, American, Stanislaus, San Joaquin Rivers & the Delta","-",2.04,15.52,17.23,0,0,"-",{"$f":"SUM(E17:I17)","v":32.75},{"$f":"D17+J17","v":34.79}]
["M&I Costs per AF (including interest) (Schedule T-3)","Delta-Mendota Canal and Pool","-",4.01,15.52,17.23,0,0,"-",32.75,36.76]
["M&I Costs per AF (including interest) (Schedule T-3)","Folsom-South Canal","-",3.26,15.52,17.23,6.47,0,"-",39.22,42.48]
["M&I Costs per AF (including interest) (Schedule T-3)","Musco Olive & Tracy Golf & Country Club","-",2.48,15.52,17.23,0,0,"-",32.75,35.229999999999997]
["M&I Costs per AF (including interest) (Schedule T-3)","Friant Dam","3/",2.95,12.52,17.23,0,0,"-",29.75,32.700000000000003]
["M&I Costs per AF (including interest) (Schedule T-3)","Friant-Kern & Madera Canals","3/",4.17,12.52,17.23,0,0,"-",29.75,33.92]
["M&I Costs per AF (including interest) (Schedule T-3)","San Luis Canal: Before Dos Amigos Pumping Plant","-",4.2699999999999996,15.52,17.23,0,0,"2/",32.75,37.019999999999996]
["M&I Costs per AF (including interest) (Schedule T-3)","San Luis Canal: After Dos Amigos Pumping Plant","-",4.8199999999999994,15.52,17.23,0,0,"2/",32.75,37.57]
["M&I Costs per AF (including interest) (Schedule T-3)","Coalinga Canal  ","-",5.18,15.52,17.23,0,0,"2/",32.75,37.93]
["M&I Costs per AF (including interest) (Schedule T-3)","San Felipe Unit: San Benito (before Coyote Pumping Plant)","-",4.72,15.52,16.98,0,0,"2/",32.5,37.22]
["M&I Costs per AF (including interest) (Schedule T-3)","San Felipe Unit: Santa Clara (after Coyote Pumping Plant)","-",5.1899999999999995,15.52,16.98,0,0,"2/",32.5,37.69]
["M&I Costs per AF (including interest) (Schedule T-3)","Cross Valley Canal   ","-",2.84,15.52,17.23,0,0,"2/",32.75,35.590000000000003]
["M&I Costs per AF (including interest) (Schedule T-3)","Toyon Pipeline and Tehama-Colusa Canal","-",3.26,15.52,17.23,0,0,"-",32.75,36.01]

{"sheet":"Footnotes","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INFORMATION!$A$1","v":"Temporary 2023 IRR & M&I Rates Sch T-1.Z25.XLSM"}]
[{"$f":"INFORMATION!$A$2","v":"01/09/2023"}]
[{"$f":"INFORMATION!$A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!$A4","v":"SCHEDULE OF IRRIGATION AND M&I TEMPORARY "}]
[{"$f":"INFORMATION!$A5","v":"COST-OF-SERVICE WATER RATES"}]
[{"$f":"INFORMATION!$A6","v":"2023 SPECIAL WATER RATES"}]
[]
["Footnotes:"]
["1/","Conveyance and Conveyance Pumping O&M costs are billed directly to the Authorities (except Folsom South Canal contractors)."]
["2/","Project Use Energy cost and Cost of Service Rate are paid in advance. Please see forward included in the long term irrigation and M&I water rates for more information."]
["3/","As per letter signed 10/21/19, and Public Law 111-11; Title X, Water Marketing for the Friant Division is being reduced by $3.00."]