{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Control","All Projects","Project Entry","Report Page","PDF Reporting"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":173,"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":"Control","index":0,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[19,2,20,3],[3,0,3,4]]}
[]
["WESTCONNECT TRANSMISSION PLAN PROJECT LIST (TPPL) WORKBOOK"]
[]
["The accuracy of the Project information entered is the responsibility of the individual Project Sponsor and will inform the WestConnect Base Transmission Plan.  \nDo not submit commercially sensitive information."]
[null,null,null,null,null,"Project Sponsor","Sponsor Code"]
[null,"Select Project Sponsor",null,null,null,"Select"]
[null,"Select",null,null,null,"American Transmission Company LLC","ATC"]
[null,null,null,null,null,"Arizona Electric Power Cooperative","AEPCO"]
[null,null,null,null,null,"Arizona Public Service","APS"]
[null,null,null,null,null,"Basin Electric Power Cooperative","BEPC"]
[null,null,null,null,null,"Black Hills Energy","BHCE"]
[null,null,null,null,null,"Black Hills Power","BHP"]
[null,"Email Address (last logged in)",null,null,null,"Cal-Mex TX","CMT"]
[null,null,null,null,null,"CATS Sub-Regional Planning Group Participants","CATS"]
[null,null,null,null,null,"Central Arizona Project","CAPAZ"]
[null,"Data Last sent by Sponsor",null,null,null,"Cheyenne Light Fuel and Power","CLFP"]
[null,null,null,null,null,"Clean Line Energy Partners","CLEP"]
[null,null,null,null,null,"Colorado Springs Utility","CSU"]
[null,null,null,null,null,"Deseret Power","DP"]
[null,"Last data saved by Sponsor",{"$f":"IF(LastSaved=\"\",\"\",IF(OR(TimeLastSent=\"\",LastSaved>TimeLastSent),\"Changes Not Sent to Energy Strategies\",\"All changes sent to Energy Strategies\"))","v":""},null,null,"Dine Power Authority","DPA"]
[null,null,null,null,null,"Duke-American Transmission Company","DATC"]
[null,null,null,null,null,"El Paso Electric Company","EPEC"]
[null,null,null,null,null,"Energy Capital Partners","ECP"]
[null,null,null,null,null,"EnviroMission Limited","EML"]
[null,"Selected Sponsor",null,null,null,"Great Basin Energy Development, LLC","GBED"]
[null,null,{"$f":"INDEX(G:G,MATCH(SelectedSponsor,F:F,0),1)","v":{"$error":"#N/A"}},null,null,"Great Basin Transmission, LLC","GBT"]
[null,null,null,null,null,"Imperial Irrigation District","IID"]
[null,"TimeStamp",null,null,null,"ITC Grid Development, LLC","ITC"]
[null,"2023-11-29T15:33:50",null,null,null,"Longview Energy Exchange, LLC","LEE"]
[null,null,null,null,null,"Los Angeles Department of Water and Power","LADWP"]
[null,"Energy Strategies Email Address",null,null,null,"Lucky Corridor, LLC","LCD"]
[null,{"$f":"HYPERLINK(\"mailto:bwalborn@energystrat.com\",\"Ben Walborn\")","v":"Ben Walborn"},null,null,null,"NV Energy","NVE"]
[null,null,null,null,null,"Platte River Power Authority","PRPA"]
[null,"Save (if MS Outlook not available) or Save and Email"," ",null,null,"Public Service Company of Colorado/ Xcel Energy","PSC"]
[null,"Save",null,null,null,"Public Service Company of New Mexico","PNM"]
[null,null,null,null,null,"Sacramento Municipal Utility District","SMUD"]
[null,null,null,null,null,"Salt River Project","SRP"]
[null,null,null,null,null,"San Luis River Colorado Project","SLRC"]
[null,null,null,null,null,"Southern California Edison","SCE"]
[null,null,null,null,null,"Southline Transmission, L.L.C.","SLT"]
[null,null,null,null,null,"Southwest Power Group II, LLC","SPG2"]
[null,null,null,null,null,"Southwest Public Power Resource Agency, Inc.","SPPA"]
[null,null,null,null,null,"Southwest Transmission Partners, LLC","STP"]
[null,null,null,null,null,"SunEdison","SE"]
[null,null,null,null,null,"SunZia Transmission, LLC","SZS"]
[null,null,null,null,null,"TC Energy","TCE"]
[null,null,null,null,null,"Trans-Elect Development Company","TEDC"]
[null,null,null,null,null,"Transmission Agency of Northern California","TANC"]
[null,null,null,null,null,"TransWest Express, LLC","TWE"]
[null,null,null,null,null,"Tres Amigas LLC","TRES"]
[null,null,null,null,null,"Tri-State Generation and Transmission Association","TSGT"]
[null,null,null,null,null,"Tucson Electric Power","TEP"]
[null,null,null,null,null,"Western Area Power Administration - DSW","WALC"]
[null,null,null,null,null,"Western Area Power Administration - RMR","WACM"]
[null,null,null,null,null,"Western Area Power Administration - SNR","WASN"]
[null,null,null,null,null,"Wyoming-Colorado Intertie, LLC","WCI"]
[null,null,null,null,null,"Xcel Energy Western Transmission Company, LLC","XEWT"]

{"sheet":"All Projects","index":1,"n_rows":1,"n_cols":69,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["projectid","Sponsor","ProjectName","Description","Purpose","Drivers","NeededForPublicPolicy_YorN","PublicPoliciesInvolved","FacilityType","Voltage","Rating","Development","Origin","Termination","InService","SubRegionalID_Name","Length","StateTraversed","Cost","WestConnect_TO_YorN","ContactName","Phone","Email","wcprojectID","Project_Map_URL","System_Impact_Study_YorN","All_Req_Infrastructure_Identifyied","Project_Inservice_for_Local_Planning_Process","Financing_Commitment","Financial_Arrangments","Construction_Commitments","Have_Project_Transmission_Service_Agreements","Transmission_Service_Agreement_Date","Federal_Permit_Required_YorN","Federal_Permit_ROD_YorN","State_Permit_Required_YorN","State_Permit_Obtained_YorN","Associated_Gen_YorN","Assoc_Gen_Cap","Assoc_Gen_Tech","Assoc_Gen_POI","Assoc_Gen_Sink","Assoc_Gen_TSA_YorN","Assoc_Gen_IA_YorN","Further_Details","Contact_Street_Address","Contact_City","Contact_Country","Contact_State_Province","Contact_Zip","Contact2_Name","Contact2_Email","Contact2_Street","Contact2_City","Contact2_Country","Contact2_State_Province","Contact2_Zip","Contact2_Phone","modifieddate","ChangeTime","POST_DATE","DateProjectEntered","ModEmail","ModFile",null,null,null,"Sort Levels:","projectid"]

{"sheet":"Project Entry","index":2,"n_rows":100,"n_cols":6,"rows_kept":100,"cut":false,"hidden":false,"merged":[[99,5,99,6],[1,0,1,2],[0,0,0,2],[96,5,96,6],[97,5,97,6],[98,5,98,6]]}
["The accuracy of the Project information entered is the responsibility of the individual Project Sponsor and will inform the WestConnect Base Transmission Plan.\nDo not submit commercially sensitive information."]
["WESTCONNECT PLAN PROJECT DATA SHEET"]
[null,"Top of ScanData"]
["WestConnect Project ID","wcprojectID",{"$f":"OFFSET(InService_FRM,0,2,1,1)&\"-\"&OFFSET(projectid_FRM,0,2,1,1)","v":"InService-projectid"},"Locked"]
["Project Name","ProjectName","ProjectName","Req"]
["Project Sponsor (Entity)","sponsor","Sponsor","Locked"]
[]
[]
["General Information"]
["Project Description","Description","Description","Req"]
["Project Purpose","Purpose","Purpose","Req"]
["Drivers of Project","Drivers","Drivers","Req"]
["If your company is a TOLSO, is this project needed to meet currently enacted public policy requirement(s)?\n(Put \"N/A\" if not a TOLSO)","NeededForPublicPolicy_YorN","NeededForPublicPolicy_YorN","Req"]
["If your company is a TOLSO, what specific enacted public policies would no longer be met without this project?\n(Put \"N/A\" if no associated public policies)","PublicPoliciesInvolved","PublicPoliciesInvolved","Req"]
["Facility Type","FacilityType","FacilityType","Req"]
["Primary Project Voltage","Voltage","Voltage","Req"]
["Estimated Transfer Capability/Rating (MW)","Rating","Rating","Req"]
["Project Development Status","Development","Development","Req","ITD Transmission Criterion 2"]
["Project Origin Point/Location","Origin","Origin","Req"]
["Project Termination Point","Termination","Termination","Req"]
["Project In-Service Year","InService","InService","Req"]
["Subregional Planning Group(s)","SubRegionalID_Name","SubRegionalID_Name","Req"]
[]
["Project Details"]
["Project Length (miles)\n(Put \"NA\" for non-transmission line projects)","Length","Length","Req"]
["State(s) Traversed","StateTraversed","StateTraversed","Req"]
["Project Estimated Cost ($)","Cost","Cost"]
[]
["Additional Information"]
["Is Sponsor a WestConnect TOLSO?","WestConnect_TO_YorN","WestConnect_TO_YorN","Req"]
["Project Contact Name","ContactName","ContactName","Req"]
["Project Contact Phone","Phone","Phone","Req"]
["Project Contact Email","Email","Email","Req"]
[]
["Date Last Modified","modifieddate","modifieddate","Locked"]
[]
["Additional Order 1000 Data - Required for Independent Transmission Developers (ITDs)"]
[]
["Information for Applying ITD Transmission Criteria"]
["Project Map URL","Project_Map_URL","Project_Map_URL"]
["Has a system impact study been completed which has been approved by all interconnecting system facility owner(s) and affected system owner(s)?","System_Impact_Study_YorN","System_Impact_Study_YorN",null,"ITD Transmission Criterion 1"]
["If the project has undergone a system impact study, does the project definition provided above include any and all infrastructure required to mitigate the surrounding system impact of the project in accordance with applicable NERC criteria?","All_Req_Infrastructure_Identifyied","All_Req_Infrastructure_Identifyied",null,"ITD Transmission Criterion 1"]
["Has the project been assumed in service for the purposes of a WestConnect TOLSO Member’s local planning process?  List all TOLSO Members that apply.","Project_Inservice_for_Local_Planning_Process","Project_Inservice_for_Local_Planning_Process",null,"ITD Transmission Criterion 3"]
["Has the project executed construction or EPC (Engineering, Procurement, Construction) contracts of at least 50% of the project’s total construction/EPC costs?","Financing_Commitment","Financing_Commitment",null,"ITD Transmission Criterion 4, Indicator 1"]
["If yes, describe the financial arrangements that enabled the project to execute the contracts.","Financial_Arrangments","Financial_Arrangments",null,"ITD Transmission Criterion 4, Indicator 1"]
["If yes, provide details regarding the construction commitments (e.g., contractor, start date).","Construction_Commitments","Construction_Commitments",null,"ITD Transmission Criterion 4, Indicator 1"]
["Does the project have executed binding transmission service agreements (TSAs) with credit-worthy counterparties that allow the project developer to recover at least 70%  of the revenue requirement of the project?","Have_Project_Transmission_Service_Agreements","Have_Project_Transmission_Service_Agreements",null,"ITD Transmission Criterion 4, Indicator 2"]
["If yes, and:\n▪ The project developer is FERC-jurisdictional, please provide the date(s) the TSAs were either filed with FERC or included in the developer’s Electric Quarterly Reports, as applicable\nOR\n▪ The project developer is not FERC-jurisdictional, provide the date(s) of when the TSAs were executed","Transmission_Service_Agreement_Date","Transmission_Service_Agreement_Date",null,"ITD Transmission Criterion 4, Indicator 2"]
["Is/are federal permit(s) required for the project?","Federal_Permit_Required_YorN","Federal_Permit_Required_YorN",null,"ITD Transmission Criterion 4, Indicator 3"]
["If yes, has a ROD been issued?","Federal_Permit_ROD_YorN","Federal_Permit_ROD_YorN",null,"ITD Transmission Criterion 4, Indicator 3"]
["Is/are state permit(s)  required for the project?","State_Permit_Required_YorN","State_Permit_Required_YorN",null,"ITD Transmission Criterion 4, Indicator 4"]
["If yes, has/have all necessary permits been obtained?","State_Permit_Obtained_YorN","State_Permit_Obtained_YorN",null,"ITD Transmission Criterion 4, Indicator 4"]
[]
["Information for Applying ITD Generation Criteria"]
["Does the non-TOLSO transmission project have associated generation that is requested to be modeled in the WestConnect base cases?","Associated_Gen_YorN","Associated_Gen_YorN",null,"ITD Generation Prerequisite Criterion"]
["Provide the generation capacity (MW)","Assoc_Gen_Cap","Assoc_Gen_Cap",null,"ITD Generation Prerequisite Criterion"]
["Provide the generation technology(ies)","Assoc_Gen_Tech","Assoc_Gen_Tech",null,"ITD Generation Prerequisite Criterion"]
["Provide the generation point-of-interconnection.","Assoc_Gen_POI","Assoc_Gen_POI",null,"ITD Generation Prerequisite Criterion"]
["Provide the sink of the generation (general area, not necessarily a specific load serving entity) to WestConnect, for modeling purposes.","Assoc_Gen_Sink","Assoc_Gen_Sink",null,"ITD Generation Prerequisite Criterion"]
["Does the generation have binding, FERC approved, transmission service agreements with all WestConnect member entities, as applicable, along the path from source to sink, or at least as far as the WestConnect planning region boundary, including with the non-TOLSO transmission project?","Assoc_Gen_TSA_YorN","Assoc_Gen_TSA_YorN",null,"ITD Generation Criterion 1"]
["Does the generator developer have an interconnection agreement with the interconnecting transmission provider, which is either executed or filed with FERC?","Assoc_Gen_IA_YorN","Assoc_Gen_IA_YorN",null,"ITD Generation Criterion 2"]
[]
["Additional Information"]
["Provide any further information or detail about the project for consideration in WestConnect’s Regional Transmission Planning Process. ","Further_Details","Further_Details"]
["Project Contact Street Address","Contact_Street_Address","Contact_Street_Address"]
["Project Contact City","Contact_City","Contact_City"]
["Project Contact Country","Contact_Country","Contact_Country"]
["Project Contact State/Province","Contact_State_Province","Contact_State_Province"]
["Project Contact Zip","Contact_Zip","Contact_Zip"]
["Project Contact Name (2)","Contact2_Name","Contact2_Name"]
["Project Contact Email (2)","Contact2_Email","Contact2_Email"]
["Project Contact Street Address (2)","Contact2_Street","Contact2_Street"]
["Project Contact City (2)","Contact2_City","Contact2_City"]
["Project Contact Country (2)","Contact2_Country","Contact2_Country"]
["Project Contact State/Province (2)","Contact2_State_Province","Contact2_State_Province"]
["Project Contact Zip (2)","Contact2_Zip","Contact2_Zip"]
["Project Contact Phone Number (2)","Contact2_Phone","Contact2_Phone"]
[]
["END OF FORM"]
[]
[]
[]
["Selected Project Row",null,1]
[]
[]
[]
[]
["projectid","projectid","projectid"]
[]
[]
["ChangeTime","ChangeTime","ChangeTime"]
["POST DATE","POST_DATE","POST_DATE"]
["DateProjectEntered","DateProjectEntered","DateProjectEntered"]
[]
["New Project?","NewProject",false]
[null,"End of ScanData"]
["Print Parameters for Manual Print",null,"Header","Range","Wide","Tall"]
["Print 890",null,"$2:$6","$A$7:$C$31",1,1]
["Print 1000",null,"$2:$6","$A$32:$C$74",1,4]
["Print Both",null,"$2:$6","$A$7:$C$74",1,5]

{"sheet":"Report Page","index":3,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,1,5,3],[1,1,1,3],[0,1,0,3]]}
[null,{"$f":"DGET('All Projects'!A:BK,\"Sponsor\",'Report Page'!$B$47:$B$48)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"DGET('All Projects'!$A:$BK,\"ProjectName\",'Report Page'!$B$47:$B$48)","v":{"$error":"#VALUE!"}}]
[]
[null,"Project Sponsor:",null,{"$f":"B1","v":{"$error":"#VALUE!"}}]
[null,"Project Description:",null,{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Description\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Description\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[null,null,"Voltage Class:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Voltage\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Voltage\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Point of Origin/Location:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Origin\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Origin\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Point of Termination:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Termination\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Termination\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Type of Project:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"FacilityType\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"FacilityType\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Development Status:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Development\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Development\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Subregional Planning Group:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"SubRegionalID_Name\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"SubRegionalID_Name\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[null,"Purpose of Project:",null,{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Purpose\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Purpose\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[null,null,"Project Drivers:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Drivers\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Drivers\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[null,"Schedule:"]
[null,null,"Planned In-Service Date:",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Inservice\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Inservice\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[null,"Contact Information:",null,{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"ContactName\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"ContactName\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Email",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Email\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Email\",'Report Page'!$B$47:$B$48))","v":""}]
[null,null,"Phone",{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"Phone\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"Phone\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[null,"WestConnect Project ID:",null,{"$f":"IF(ISERROR(DGET('All Projects'!$A:$BK,\"wcprojectid\",'Report Page'!$B$47:$B$48)),\"\",DGET('All Projects'!$A:$BK,\"wcprojectid\",'Report Page'!$B$47:$B$48))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"projectid",1]
[null,{"$f":"OFFSET(projectid,ReportRow-1,0,1,1)","v":"projectid"}]

{"sheet":"PDF Reporting","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}