{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Transmission","Resources"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":3187,"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":"Cover","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Integrated Resource Planning"]
[null,"CPUC Staff Project: Out-of-State Resource and Transmission Assessment"]
[]
[null,"2020-04-15"]
[]
[]
[null,"Table of Contents"]
[null,"Sheet name","Description"]
[null,"Transmission","Input data for transmission projects"]
[null,"Resources","Input data for resources being delivered by transmission projects. "]
[]
[]
[null,"Cell Color Scheme Legend"]
[null,"yellow:","User Input"]
[]
[null,"All costs expressed in 2020 dollars"]

{"sheet":"Transmission","index":1,"n_rows":101,"n_cols":10,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
[]
["Transmission Projects"]
[]
[]
[]
[null,"System Cost",null,"Notes",null,null,null,null,null,"Notes"]
[null,"Project Name","Tx_1",null,null,null,null,null,"Tx_2"]
[null,"Voltage (kV)"]
[null,"AC/DC"]
[null,"Project Transfer Capability (MW)"]
[null,"After CAISO authorization (for Reliability, policy, or economic projects)"]
[null,"Time to In-service Date, SOONEST POSSIBLE (# years)",null,null,"* If project comes online in stages, please indicate schedule "]
[null,"Time to In-service Date, MEDIUM (# years)",null,null,"* If project comes online in stages, please indicate schedule "]
[null,"Time to In-service Date, LAST POSSIBLE (# years)",null,null,"* If project comes online in stages, please indicate schedule "]
[null,"Developer Estimated Cost, LOW ($M)"]
[null,"Developer Estimated Cost, MEDIUM ($M)"]
[null,"Developer Estimated Cost, HIGH ($M)"]
[null,"After CAISO authorization (for Merchant projects (per ISO tariff) or interconnection to the ISO grid)"]
[null,"Time to In-service Date, SOONEST POSSIBLE (# years)",null,null,"* If project comes online in stages, please indicate schedule "]
[null,"Time to In-service Date, MEDIUM (# years)",null,null,"* If project comes online in stages, please indicate schedule "]
[null,"Time to In-service Date, LAST POSSIBLE (# years)",null,null,"* If project comes online in stages, please indicate schedule "]
[null,"Developer Estimated Cost, LOW ($M)"]
[null,"Developer Estimated Cost, MEDIUM ($M)"]
[null,"Developer Estimated Cost, HIGH ($M)"]
[null,"Length (Miles)"]
[null,"Permitting Status",null,null,"E.g., \"Final BLM EIS\", \"Partial BLM EIS\", \"ROD from BLM\""]
[null,"WECC Path Rating Process Status",null,null,"E.g., \"Not started\", \"Phase 2\", \"Phase 2b\" "]
[null,"Origin (Geographic; a planning region; or interconnection point - see \"interconnection details\" below)"]
[null,"Termination (See comment in row 28)"]
[null,"Proponent"]
[null,"Number of resources being delivered by this transmission project (if a mix of resources are being delivered) ",""]
[null,"If only 1 resource, fill in rows 33, 34. If more than 1 resource, fill in the following:"]
[null,"Name of resources developed/under development near origin (1)",null,null,"*Please add more details in \"Resources\" tab"]
[null,"Size of resource (MW)/Size of transmission project (MW) (1)",null,null,"*Resource MW size DIVIDED by transmission MW capacity"]
[null,"Name of resources developed/under development near origin (2)",null,null,"*Please add more details in \"Resources\" tab"]
[null,"Size of resource (MW)/Size of transmission project (MW) (2)",null,null,"*Resource MW size DIVIDED by transmission MW capacity"]
[null,"Name of resources developed/under development near origin (3)",null,null,"*Please add more details in \"Resources\" tab"]
[null,"Size of resource (MW)/Size of transmission project (MW) (3)",null,null,"*Resource MW size DIVIDED by transmission MW capacity"]
[]
[null,"Ownership Arrangement"]
[null,"Is the transmission line a single \"package\" with the resources connected to the line?","Yes/No"]
[null,"If yes, go directly to line 53. If no, then go to next line;"]
[null,"Is each resource paying for their share or portion of the line? If yes, complete lines directly below. If no, skip to line 53","Yes/No"]
[null,"Name of resource sharing cost (1)"]
[null,"Percentage of line cost share (%)"]
[null,"Value of the cost-share ($)"]
[null,"Name of resource sharing cost (1)"]
[null,"Percentage of line cost share (%)"]
[null,"Value of the cost-share ($)"]
[null,"Name of resource sharing cost (1)"]
[null,"Percentage of line cost share (%)"]
[null,"Value of the cost-share ($)"]
[null,"Provide information on ownership arrangements for the transmission line and for resources connecting to the line. (please fill this even if the line is not a single \"package\")"]
[]
[null,"Economic Lifetime"]
[null,"System Economic Life",40,null,null,null,null,null,37]
[]
[null,"Ongoing Costs"]
[null,"Fixed O&M Costs (%)",2.5000000000000001E-2,null,null,null,null,null,2.1000000000000001E-2]
[null,"Fixed O&M Costs Escalator (%/yr.)",0.02,null,null,null,null,null,1.7999999999999999E-2]
[null,"Property Tax",0,null,null,null,null,null,0]
[null,"Insurance",0,null,null,null,null,null,0]
[]
[null,"Income Tax Assumptions"]
[null,"Income Tax - Federal",0.21,null,null,null,null,null,0.21]
[null,"Income Tax - State",0,null,null,null,null,null,0]
[null,"Income Tax - Effective Tax Rate",0.21,null,null,null,null,null,0.21]
[null,"MACRS Term",15,null,null,null,null,null,15]
[null,"Levelization Escalation Rate",0,null,null,null,null,null,0]
[]
[null,"Financing"]
[null,"% Financed w/ equity",0.5,null,null,null,null,null,0.3]
[null,"% Financed w/ debt",0.5,null,null,null,null,null,0.7]
[null,"Debt Interest rate",0.05,null,null,null,null,null,5.5E-2]
[null,"Cost of Equity",0.1,null,null,null,null,null,0.1]
[]
[null,"Interconnection details"]
[null,"Delivers to CAISO directly?","Yes/No",null,null,null,null,null,"Yes/No"]
[null,"If yes, name of injection node in CAISO"]
[null,"If no, is intermediate transmission necessary?","Yes/No",null,null,null,null,null,"Yes/No"]
[null,"If yes, buy rights on existing transmission or build new transmission?"]
[null,"If buying rights on existing, please estimate:"]
[null,"MW of intermediate tx needed"]
[null,"Cost of rights on existing transmission ($/MW)"]
[null,"Final injection point into CAISO"]
[null,"If new intermediate tx needs to be built, please estimate:"]
[null,"MW of intermediate tx needed"]
[null,"Cost of new intermediate tx needed ($/MW)"]
[null,"Final injection point into CAISO"]
[]
[null,"Purported benefits of projects along with supporting references"]
[null,"Benefit","Reference",null,null,null,null,null,"Reference"]
[null,1]
[null,2]
[null,3]
[null,4]
[]
[]
[null,"Notes (Please add details here as needed)"]
[null,"Please add more details on the transmission project that are not captured "]
[null,"by the above quantitative metrics"]

{"sheet":"Resources","index":2,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
["Resources being delivered by the transmission projects"]
[null,null,"Each block is a combination of resourcea associated with one transmission project. If there is uncertainty about the resource combinations associated with any one transmission line,"]
[null,null,"please feel free to copy a block and add it to the right specifying the associated transmission project (eg., \"Tx_1\") with a different mix of resources and/or resource costs."]
[]
[null,"Name of transmission project ","Tx_1","Tx_1","Tx_1",null,"Tx_2","Tx_2","Tx_2"]
[null,"Name of resource","Tx_1_Resource_1","Tx_1_Resource_2","Tx_1_Resource_3",null,"Tx_2_Resource_1","Tx_2_Resource_2","Tx_2_Resource_3"]
[null,"Type of resource","Wind","Solar","Battery",null,"Wind","Solar","Battery"]
[null,"Percentage of the whole project (by nameplate capacity)",0,0.9,0.1,null,0,1,0]
[null,"State"]
[null,"County"]
[null,"Latitude/Longitude"]
[]
[]
[null,"System Cost"]
[null,"System Size (MW)"]
[null,"System Cost ($/kW)"]
[null,"Interconnection Cost ($/kW)"]
[]
[null,"Performance Inputs"]
[null,"Estimated Capacity Factor"]
[null,"Degradation Factor"]
[null,"System Economic Life (=PPA Term)"]
[null,"Hub height (if wind)"]
[null,"Inverter loading ratio (if solar)"]
[null,"Fixed/Tracking (If solar)"]
[null,"Battery Capacity (if battery) - MW"]
[null,"Duration (if battery)(in Hours) - Hours"]
[null,"Round-trip efficiency (if battery)"]
[null,"Is battery being charged solely from renewables? (if battery)"]
[]
[null,"Ongoing Costs"]
[null,"Fixed O&M Costs ($/kW-yr)"]
[null,"Fixed O&M Costs Escalator (%/yr)"]
[null,"Variable O&M Costs ($/MWh)"]
[null,"Variable O&M Costs Escalator (%/yr)"]
[]
[null,"Resource firming"]
[null,"If the resource will be firmed up, please give details on the right about the new","",null,null,null,""]
[null,"capacity factor and how the firming is being planned. What is the cost of "]
[null,"firming? Please elaborate"]
[]
[]
[]
[null,"Notes (Please add details here as needed)"]
[null,"Please add on the right any details describing the resources that are not ","",null,null,null,""]
[null,"captured in the quantitative metrics above"]