{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INFORMATION","Input","Macro Input","Output","Footnotes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"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":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["2023 Full Cost Temporary M&I Water Rates Sch TR-2a.Z25.XLSM"]
["01/03/2023"]
["CENTRAL VALLEY PROJECT"]
["SCHEDULE OF M&I TEMPORARY FULL COST CONSTRUCTION COST (INCLUDING INTEREST) PER ACRE-FOOT"]
["2023 SPECIAL WATER RATES"]
[]
[null,null,"SPECIAL FILE INFORMATION"]
[]
[]
[null,null,"SOURCE DATA:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10/25/2022","rm","Updated file names, title, headings, and date. Updated input tab links"]
[null,null,"Updated Input tab links"]
[null,null,"Verified Sch TR-2a Output tab with Sch TR-2b Output tab"]
[null,null,"Ready for review"]
["01/03/2023","KJ","Review"]

{"sheet":"Input","index":1,"n_rows":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Construction Only","Interest"]
[]
[null,null,"Other Cost",{"$f":"[1]OUTPUT!$U$86","v":0.49},{"$f":"[1]OUTPUT!$W$86","v":0.39}]
[null,"Storage"]
[null,null,"Storge - All Others",{"$f":"[1]OUTPUT!$U$19","v":0.88},{"$f":"[1]OUTPUT!$W$19","v":0.71}]
[null,null,"Storge - San Felipe Unit",{"$f":"[1]OUTPUT!$U$18","v":0.57999999999999996},{"$f":"[1]OUTPUT!$W$18","v":0.46}]
[]
[null,"Conveyance"]
[null,null,"Conveyance",{"$f":"[1]OUTPUT!$U$26","v":0.82},{"$f":"[1]OUTPUT!$W$26","v":0.66}]
[]
[null,"Conveyance Pumping"]
[null,null,"Jones PP - All Others",{"$f":"[1]OUTPUT!$U$51","v":0.51},{"$f":"[1]OUTPUT!$W$51","v":0.41}]
[null,null,"Jones PP - FKC & MC",{"$f":"[1]OUTPUT!$U$46","v":0.62},{"$f":"[1]OUTPUT!$W$46","v":0.49}]
[]
[null,null,"O'Neill PP",{"$f":"[1]OUTPUT!$U$40","v":0.18},{"$f":"[1]OUTPUT!$W$40","v":0.14000000000000001}]
[]
[null,null,"Dos Amigos PP",{"$f":"[1]OUTPUT!$U$35","v":0.36},{"$f":"[1]OUTPUT!$W$35","v":0.29000000000000004}]
[]
[null,null,"Cross Valley Canal",{"$f":"[1]OUTPUT!$U$34","v":0.24},{"$f":"[1]OUTPUT!$W$34","v":0.19}]
[null,null,"   (State Delta Pumping Plant)"]
[]
[null,"Direct Pumping"]
[null,null,"Musco Olive & Tracy Golf & Country Club",{"$f":"[1]OUTPUT!$U$76","v":0.28999999999999998},{"$f":"[1]OUTPUT!$W$76","v":0.23}]
[null,null,"   (State Delta Pumping Plant)"]
[]
[null,null,"Coalinga Canal",{"$f":"[1]OUTPUT!$U$60+[1]OUTPUT!$U$61","v":0.24000000000000002},{"$f":"[1]OUTPUT!$W$60+[1]OUTPUT!$W$61","v":0.2}]
[null,null,"   (Pleasant Valley Pumping Plant)"]
[]
[null,null,"San Felipe Unit:"]
[null,null,"   San Benito (before Coyote Pumping Plant)",{"$f":"[1]OUTPUT!$U$65","v":0.61},{"$f":"[1]OUTPUT!$W$65","v":0.49}]
[null,null,"   Santa Clara (after Coyote Pumping Plant)",{"$f":"[1]OUTPUT!$U$72","v":0.92},{"$f":"[1]OUTPUT!$W$72","v":0.74}]
[]
[null,null,"Cross Valley Canal",{"$f":"[1]OUTPUT!$U$76","v":0.28999999999999998},{"$f":"[1]OUTPUT!$W$76","v":0.23}]
[null,null,"   (State Delta Pumping Plant)"]

{"sheet":"Macro Input","index":2,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"create a macro for this.  Pull output tab from TR-2b"]

{"sheet":"Output","index":3,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"INFORMATION!A1","v":"2023 Full Cost Temporary M&I Water Rates Sch TR-2a.Z25.XLSM"}]
[{"$f":"INFORMATION!A2","v":"01/03/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF M&I TEMPORARY FULL COST CONSTRUCTION COST (INCLUDING INTEREST) PER ACRE-FOOT"}]
[{"$f":"INFORMATION!A5","v":"2023 SPECIAL WATER RATES"}]
[]
[]
["Category","A) Service Area / Contractor","B) Other\nCosts\n<Sch TR-2b>","C) Storage\n<Sch TR-2b>","D) Conveyance\n<Sch TR-2b>","E) Conveyance Pumping  \nCorning\nPP\n<Sch TR-2b>","F) Conveyance Pumping  \nJones Pumping Plant Friant-Kern Madera\n<Sch TR-2b>","G) Conveyance Pumping  \nJones Pumping Plant All Others\n<Sch TR-2b>","H) Conveyance Pumping  \nO'Neill\nPGP\n<Sch TR-2b>","I) Conveyance Pumping  \nDos Amigos\nPP\n<Sch TR-2b>","J) Direct\nPumping\n<Sch TR-2b>","K) Total\nSUM(B:J)"]
["M&I Construction Cost per AF (including interest):","1. Sacramento, American, Stanislaus, San Joaquin Rivers & the Delta",{"$f":"+C23+C36","v":0.88},1.5899999999999999,"-","-","-","-","-","-","-",{"$f":"SUM(C10:K10)","v":2.4699999999999998}]
["M&I Construction Cost per AF (including interest):","2. Delta-Mendota Canal and Pool",0.88,1.5899999999999999,{"$f":"+E24+E37","v":1.48},"-","-",{"$f":"+H24+H37","v":0.91999999999999993},"-","-","-",{"$f":"SUM(C11:K11)","v":4.8699999999999992}]
["M&I Construction Cost per AF (including interest):","3. Folsom-South Canal, Toyon Pipeline and Tehama-Colusa Canal  ",0.88,1.5899999999999999,{"$f":"+E25+E38","v":1.48},"-","-","-","-","-","-",3.9499999999999997]
["M&I Construction Cost per AF (including interest):","4. Musco Olive & Tracy Golf & Country Club (State Delta Pumping Plant) 1/",0.88,1.5899999999999999,"-","-","-","-","-","-",{"$f":"+K26+K39","v":0.52},2.9899999999999998]
["M&I Construction Cost per AF (including interest):","5. Friant Dam",0.88,1.5899999999999999,"-","-",{"$f":"+G27+G40","v":1.1099999999999999},"-","-","-","-",3.5799999999999996]
["M&I Construction Cost per AF (including interest):","6. Friant-Kern & Madera Canals",0.88,1.5899999999999999,{"$f":"+E28+E41","v":1.48},null,{"$f":"+G28+G41","v":1.1099999999999999},"-","-","-","-",5.0599999999999996]
["M&I Construction Cost per AF (including interest):","7. San Luis Canal: Before Dos Amigos Pumping Plant",0.88,1.5899999999999999,1.48,"-","-",{"$f":"+H29+H42","v":0.91999999999999993},0.32,"-","-",5.1899999999999995]
["M&I Construction Cost per AF (including interest):","7. San Luis Canal: After Dos Amigos Pumping Plant",0.88,1.5899999999999999,1.48,"-","-",0.91999999999999993,0.32,{"$f":"+J30+J43","v":0.65},null,5.84]
["M&I Construction Cost per AF (including interest):","8. Coalinga Canal (Pleasant Valley Pumping Plant) 2/",0.88,1.5899999999999999,1.48,"-","-",0.91999999999999993,0.32,{"$f":"+J31+J44","v":0.65},{"$f":"+K31+K44","v":0.44000000000000006},6.28]
["M&I Construction Cost per AF (including interest):","9. San Felipe Unit: San Benito (before Coyote Pumping Plant) 3/",0.88,1.04,1.48,"-","-",0.91999999999999993,0.32,null,{"$f":"+K32+K45","v":1.1000000000000001},5.74]
["M&I Construction Cost per AF (including interest):","9. Santa Clara (after Coyote Pumping Plant) 4/",0.88,1.04,1.48,"-","-",0.91999999999999993,0.32,null,{"$f":"+K33+K46","v":1.6600000000000001},6.3000000000000007]
["M&I Construction Cost per AF (including interest):","10. M&I Construction Cost per AF (including interest): Cross Valley Canal (State Delta Pumping Plant) 5/",0.88,1.5899999999999999,"-","-","-","-","-",{"$f":"+J34+J47","v":0.43},{"$f":"+K34+K47","v":0.52},3.42]
["Total","-","-","-","-","-","-","-","-","-","-","-"]
["M&I Construction Rates (excluding interest):","1. Sacramento, American, Stanislaus, San Joaquin Rivers & the Delta.",{"$f":"Input!D10","v":0.49},{"$f":"Input!D12","v":0.88},"-","-","-","-","-","-","-",{"$f":"SUM(C23:K23)","v":1.37}]
["M&I Construction Rates (excluding interest):","2. Delta-Mendota Canal and Pool",{"$f":"$C$23","v":0.49},{"$f":"$D$23","v":0.88},{"$f":"Input!D16","v":0.82},"-","-",{"$f":"Input!D19","v":0.51},"-","-","-",2.7]
["M&I Construction Rates (excluding interest):","3. Folsom-South Canal , Toyon Pipeline and   Tehama-Colusa Canal",0.49,0.88,{"$f":"$E$24","v":0.82},"-","-","-","-","-","-",2.19]
["M&I Construction Rates (excluding interest):","4. Musco Olive & Tracy Golf & Country Club (State Delta Pumping Plant) 1/",0.49,0.88,"-","-","-","-","-","-",{"$f":"Input!D30","v":0.28999999999999998},1.6600000000000001]
["M&I Construction Rates (excluding interest):","5. Friant Dam",0.49,0.88,"-","-",{"$f":"Input!D20","v":0.62},"-","-","-","-",1.9900000000000002]
["M&I Construction Rates (excluding interest):","6. Friant-Kern & Madera Canals",0.49,0.88,{"$f":"$E$24","v":0.82},null,{"$f":"G27","v":0.62},"-","-","-","-",2.81]
["M&I Construction Rates (excluding interest):","7. San Luis Canal: Before Dos Amigos Pumping Plant",0.49,0.88,0.82,"-","-",{"$f":"$H$24","v":0.51},{"$f":"Input!D22","v":0.18},"-","-",2.8800000000000003]
["M&I Construction Rates (excluding interest):","7. San Luis Canal: After Dos Amigos Pumping Plant",0.49,0.88,0.82,"-","-",{"$f":"$H$24","v":0.51},{"$f":"$I$29","v":0.18},{"$f":"Input!D24","v":0.36},"-",3.24]
["M&I Construction Rates (excluding interest):","8. Coalinga Canal (Pleasant Valley Pumping Plant) 2/",0.49,0.88,0.82,"-","-",{"$f":"$H$24","v":0.51},{"$f":"$I$29","v":0.18},{"$f":"J30","v":0.36},{"$f":"Input!D33","v":0.24000000000000002},3.4800000000000004]
["M&I Construction Rates (excluding interest):","9. San Felipe Unit: San Benito (before Coyote Pumping Plant) 3/",0.49,{"$f":"Input!D13","v":0.57999999999999996},0.82,"-","-",{"$f":"$H$24","v":0.51},{"$f":"$I$29","v":0.18},null,{"$f":"Input!D37","v":0.61},3.1899999999999995]
["M&I Construction Rates (excluding interest):","9. San Felipe Unit: Santa Clara (after Coyote Pumping Plant) 4/",0.49,{"$f":"D32","v":0.57999999999999996},0.82,"-","-",{"$f":"$H$24","v":0.51},{"$f":"$I$29","v":0.18},null,{"$f":"Input!D38","v":0.92},3.4999999999999996]
["M&I Construction Rates (excluding interest):","10. Cross Valley Canal (State Delta Pumping Plant) 5/",0.49,{"$f":"$D$23","v":0.88},null,"-","-","-","-",{"$f":"Input!D26","v":0.24},{"$f":"Input!D40","v":0.28999999999999998},1.9000000000000001]
["Total","-","-","-","-","-","-","-","-","-","-","-"]
["M&I Construction Interest Cost/AF:","1. Sacramento, American, Stanislaus, San Joaquin Rivers & the Delta",{"$f":"Input!E10","v":0.39},{"$f":"Input!E12","v":0.71},"-","-","-","-","-","-","-",{"$f":"SUM(C36:K36)","v":1.1000000000000001}]
["M&I Construction Interest Cost/AF:","2. Delta-Mendota Canal and Pool",{"$f":"$C$36","v":0.39},{"$f":"$D$36","v":0.71},{"$f":"Input!E16","v":0.66},"-","-",{"$f":"Input!E19","v":0.41},"-","-",null,2.1700000000000004]
["M&I Construction Interest Cost/AF:","3. Folsom-South Canal , Toyon Pipeline and Tehama-Colusa Canal",0.39,0.71,{"$f":"$E$37","v":0.66},"-","-","-","-","-",null,1.7600000000000002]
["M&I Construction Interest Cost/AF:","4. Musco Olive & Tracy Golf & Country 1/ Club (State Delta Pumping Plant)",0.39,0.71,"-","-","-","-","-","-",{"$f":"Input!E30","v":0.23},1.33]
["M&I Construction Interest Cost/AF:","5. Friant Dam",0.39,0.71,"-","-",{"$f":"Input!E20","v":0.49},"-","-","-","-",1.59]
["M&I Construction Interest Cost/AF:","6. Friant-Kern & Madera Canals",0.39,0.71,{"$f":"$E$37","v":0.66},"-",{"$f":"G40","v":0.49},"-","-","-","-",2.25]
["M&I Construction Interest Cost/AF:","7. San Luis Canal: Before Dos Amigos Pumping Plant",0.39,0.71,0.66,"-","-",{"$f":"$H$37","v":0.41},{"$f":"Input!E22","v":0.14000000000000001},"-","-",2.3100000000000005]
["M&I Construction Interest Cost/AF:","7. San Luis Canal: After Dos Amigos Pumping Plant",0.39,0.71,0.66,"-","-",{"$f":"$H$37","v":0.41},{"$f":"$I$42","v":0.14000000000000001},{"$f":"Input!E24","v":0.29000000000000004},"-",2.6000000000000005]
["M&I Construction Interest Cost/AF:","8. Coalinga Canal (Pleasant Valley Pumping Plant) 2/",0.39,0.71,0.66,"-","-",{"$f":"$H$37","v":0.41},{"$f":"$I$42","v":0.14000000000000001},{"$f":"J43","v":0.29000000000000004},{"$f":"Input!E33","v":0.2},2.8000000000000007]
["M&I Construction Interest Cost/AF:","9. San Felipe Unit: San Benito (before Coyote Pumping Plant) 3/",0.39,{"$f":"Input!E13","v":0.46},0.66,"-","-",{"$f":"$H$37","v":0.41},{"$f":"$I$42","v":0.14000000000000001},"-",{"$f":"Input!E37","v":0.49},2.5499999999999998]
["M&I Construction Interest Cost/AF:","9. San Felipe Unit: Santa Clara (after Coyote Pumping Plant) 4/",0.39,{"$f":"D45","v":0.46},0.66,"-","-",{"$f":"$H$37","v":0.41},{"$f":"$I$42","v":0.14000000000000001},"-",{"$f":"Input!E38","v":0.74},2.8]
["M&I Construction Interest Cost/AF:","10. Cross Valley Canal (State Delta Pumping Plant) 5/",0.39,{"$f":"$D$36","v":0.71},"-","-","-","-","-",{"$f":"Input!E26","v":0.19},{"$f":"Input!E40","v":0.23},1.52]

{"sheet":"Footnotes","index":4,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"INFORMATION!A1","v":"2023 Full Cost Temporary M&I Water Rates Sch TR-2a.Z25.XLSM"}]
[{"$f":"INFORMATION!A2","v":"01/03/2023"}]
[{"$f":"INFORMATION!A3","v":"CENTRAL VALLEY PROJECT"}]
[{"$f":"INFORMATION!A4","v":"SCHEDULE OF M&I TEMPORARY FULL COST CONSTRUCTION COST (INCLUDING INTEREST) PER ACRE-FOOT"}]
[{"$f":"INFORMATION!A5","v":"2023 SPECIAL WATER RATES"}]
[]
["Footnotes:"]
[]
["1/ Storage and project use energy at State-Delta Pumping Plant"]
[]
["2/ Direct Pumping from Pleasant Valley Pumping Plant (City of Coalinga)."]
[]
["3/ Direct Pumping from Wm. R. Gianelli Pump/Generator and Pacheco PP "]
[]
["4/ Direct Pumping from W.R. Gianelli Pump/Generator, Pacheco PP, and Coyote PP "]
[]
["5/ Effective March 1, 1996, Cross Valley Canal contract water is pumped and delivered through the State and/or State's side of joint-use facilities.Therefore, (1) these contractors will no longer be allocated Conveyance costs; and (2) Conveyance Pumping and Direct Pumping costs will be limited to Project Use Energy only. "]