{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Checklist","Financial Constraint","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":15,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Checklist","index":0,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[[22,0,23,0],[0,2,0,5],[53,1,53,2],[44,0,45,0],[1,0,1,1],[3,0,4,0],[1,2,1,5],[5,0,7,0],[8,0,13,0],[16,0,17,0],[30,0,39,0],[24,0,29,0],[42,0,43,0],[18,0,21,0],[47,0,50,0],[51,0,54,0],[55,1,55,5],[55,0,59,0],[56,1,56,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[54,1,54,2],[51,1,51,2],[53,3,53,5],[54,3,54,5],[51,3,51,5],[52,3,52,5],[52,1,52,2]]}
["Planning Partner:","SVATS MPO (Mercer County)","[Click Here to View Pop-Up Directions]"]
["Transportation Management Area:\n",null,"MPO/RPO to Provide Response\nOthers Check to Indicate Response Verified",{"$nulls":4},"CO Pre-Review"]
[null,"Information Items\nGreen highlighted items require documentation to be submitted.","Response","CPDM","FHWA","FTA",null,"Add initials if reviewed\n*Red if required for PCP*","Use tracked changes to review in the onedrive folder "]
["1.  Cover Letter:","Cover Letter which documents organization and date of TIP adoption","Yes / No"]
[null,"Date TIP adopted by Planning Partner:","Meeting Date"]
["2.  TIP Development:","TIP Development/Project Selection Process Documentation","Yes / No",{"$nulls":4},"waiting"]
[null,"MPO/RPO Specific TIP Development Timeline","Yes / No",{"$nulls":4},"waiting"]
[null,"Does the documentation explain the project selection process, roles, responsibilities and/or project evaluation criteria procedures?","Yes / No"]
["3.  Performance Based Planning and Programming (TPM Narrative Template):","PM1 Narrative Documentation (includes established targets and analysis of progress towards targets)","Yes / No",{"$nulls":4},"Waiting"]
[null,"HSIP SharePoint Application Submission Confirmation","Yes / No",{"$nulls":4},"Waiting"]
[null,"PM2 Narrative Documentation (includes established targets and analysis of progress towards targets)","Yes / No",{"$nulls":4},"Waiting"]
[null,"PM3 Narrative Documentation (includes established targets and analysis of progress towards targets)","Yes / No",{"$nulls":4},"Waiting"]
[null,"Transit Performance Measures Documentation","Yes/No/NA",{"$nulls":4},"Waiting"]
[null,"TAMP narrative documentation demonstrates consistency with the TYP/TIP","Yes / No",{"$nulls":4},"Waiting"]
["4.  Highway-Bridge Program Projects:","Highway and Bridge Listing with public narrative","Yes / No",{"$nulls":4},"CO will send","Susan"]
["5.  Public Transportation Program:","Public Transportation Listing with public narrative","Yes / No",{"$nulls":4},"CO will send","Susan"]
["6.  Interstate & Statewide Program Projects:","Regional Portion of Interstate TIP Listing with public narrative","Yes/No/NA",{"$nulls":4},"CO will send","Susan"]
[null,"Regional Portion of Statewide TIP Listing (Spike, TAP, RRX, HSIP, PROTECT other)","Yes/No/NA",{"$nulls":4},"CO will send","Susan"]
["7.  Financial Constraint:","Complete the tables in the Financial Constraint tab.","Yes / No"]
[null,"Is the TIP financially constrained, by year and by allocations?","Yes / No"]
[null,"Were the TIP projects screened against the federal/state funding program eligibility requirements?","Yes / No"]
[null,"Are estimated total costs to complete projects that extend beyond the TIP years shown in the TYP and LRTP?","Yes / No"]
["8.  Public Transportation:","Public Transportation Financial Capacity Analysis (MPO Only)","Yes/No/NA"]
[null,"Documentation of Transit Asset Management (TAM) Plan","Yes / No"]
["9.  Air Quality:","Air Quality Conformity Determination Report","Yes/No/NA",{"$nulls":4},"CO will send.\nin folder - Jgc"]
[null,"Air Quality Resolution","Yes/No/NA"]
[null,"Is the area in an AQ non-attainment or maintenance area?","Yes/No/NA"]
[null,"Have all projects been screened through an interagency consultation process?","Yes/No/NA"]
[null,"Most recent air quality conformity determination date:","Date/NA"]
[null,"Do projects contain sufficient detail for air quality analysis?","Yes/No/NA"]
["10.  Public Participation Documentation:","Public Comment Period Advertisement","Yes / No",{"$nulls":4},"Reviewed/Updated","Susan"]
[null,"Public comment period:","Date Range"]
[null,"Public meeting(s)-Date/Time/Location:","Date/Time/ Location"]
[null,"Public meeting notices contain contact information about ADA Accommodations?","Yes / No"]
[null,"Were LEP taglines included with TIP public comment documents?","Yes / No"]
[null,"Has Tribal Consultation/Outreach occurred?","Yes / No"]
[null,"STIP/TIP public involvement outreach activities consistent with Public Participation Plan?","Yes / No"]
[null,"Were any public comments (written or verbal) received?","Yes / No"]
[null,"Documentation of Public Comments received","Yes/No/NA"]
[null,"Were public comments addressed?","Yes/No/NA"]
["11.  Title VI:","Has the MPO included information regarding Title VI and its applicability to the TIP, including the protections against discrimination and the availability of the TIP document in alternative formats upon request?","Yes / No",{"$nulls":4},"Run by former BEO office\nJGC"]
["12.  TIP Revision Procedures (MOU):","MPO/RPO TIP Modification Procedures (MOU)","Yes / No",{"$nulls":4},"JGC"]
["13.  MPO Self-Certification Resolution:","Self-Certification Resolution (RPO Optional)","Yes/No/NA"]
[null,"For the Non-TMAs, does the self certification contain documentation to indicate compliance?","Yes/No/NA"]
["14.  Other Requirements:","List of regionally important projects from the previous TIP that were implemented, and projects impacted by significant delays.","Yes / No"]
[null,"Does the TIP contain amounts of state & local revenue sources beyond financial guidance?","Yes / No"]
["15.  PennDOT Connects:","Municipal outreach/PIF forms initiated for all TIP projects?","Yes / No"]
["16.  Long Range Transportation Plan:","Is the TIP consistent with the LRTP?","Yes / No"]
[null,"LRTP air quality conformity determination date:","Date/NA"]
[null,"LRTP end year:","Date"]
[null,"Anticipated MPO/RPO LRTP adoption date:","Date"]
["17.  Completed/ Reviewed by:","MPO/RPO:  ",null,"Date:  "]
[null,"PennDOT CPDM: ",null,"Date:  "]
[null,"FHWA: ",null,"Date:  "]
[null,"FTA:",null,"Date:  "]
["18.  Comments:","Note any noteworthy practices, issues or improvements that should be addressed by the next TIP update, or any other comments/questions here:  \n\n"]

{"sheet":"Financial Constraint","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,9],[2,9,3,9],[1,0,1,9],[17,0,17,9],[2,1,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[28,5,28,9],[18,5,18,9],[32,5,32,9],[31,5,31,9],[30,5,30,9],[19,5,19,9],[21,5,21,9],[22,5,22,9],[23,5,23,9],[24,5,24,9],[25,5,25,9],[29,5,29,9],[26,5,26,9],[27,5,27,9],[20,5,20,9]]}
["Financial Constraint Tables"]
["Compare the amount of funds programmed in each year of the TIP against Financial Guidance (FG) allocation, and explain any differences."]
[null,"FFY 2027",null,"FFY 2028",null,"FFY 2029",null,"FFY 2030",null,"Comments"]
["Fund Type","Financial Guidance","Programmed","Financial Guidance","Programmed","Financial Guidance","Programmed","Financial Guidance","Programmed"]
["NHPP",1487000,1487000,1344000,1344000,1344000,1344000,1344000,1344000]
["STP",3305000,3305000,3297000,3297000,3297000,3297000,3297000,3297000]
["State Highway (581)",4912000,4912000,4855000,4855000,5273000,5273000,5631000,5631000]
["State Bridge (185/183)",2584000,2584000,2522000,2522000,2461000,2461000,2469000,2469000]
["BOF",2601000,2601000,2601000,2601000,2601000,2601000,2601000,2601000]
["HSIP",1127000,1127000,1127000,1127000,1127000,1127000,1127000,1127000]
["CMAQ",0,0,0,0,0,0,0,0]
["TAU",0,0,0,0,0,0,0,0]
["STU",0,0,0,0,0,0,0,0]
["CRP/CRPU",472000,472000,472000,472000,472000,472000,472000,472000]
["BRIP",2479000,2479000,2479000,2479000,2479000,2479000,2479000,2479000]
["Total",{"$f":"SUM(B5:B15)","v":18967000},18967000,18697000,18697000,19054000,19054000,19420000,19420000]
[]
["Identify the TOTAL amount and TYPES of additional funds programmed above FG allocations (e.g. Spike funds, Earmarks, Local, TASA, PROTECT) by year:"]
["Additional Funding Type","FFY 2027","FFY 2028","FFY 2029","FFY 2030","Comments"]
["sHSIP",80625,null,null,null,"HSIP Set Aside Funding"]
["sHVRU",100000,null,null,null,"HSIP Set Aside Funding - HVRU"]
[407,330052,null,null,null,"Multimodal funding"]
["PROTECT",925000,null,null,null,"PROTECT Funding"]
{"$rows_empty":9}
["Total",{"$f":"SUM(B20:B32)","v":1435677},{"$f":"SUM(C20:C32)","v":0},{"$f":"SUM(D20:D32)","v":0},{"$f":"SUM(E20:E32)","v":0}]

{"sheet":"Sheet3","index":2,"n_rows":188,"n_cols":10,"rows_kept":188,"cut":false,"hidden":true,"merged":[]}
["2016-03-01","07:00:00","Jan",1,1,1,"Apr",2015,2000,"Adams MPO"]
["2016-03-02","07:30:00","Feb",2,2,2,"Jun",2016,2001,"Altoona MPO"]
["2016-03-03","08:00:00","Mar",3,3,3,"Sep",2017,2002,"Centre County MPO"]
["2016-03-04","08:30:00","Apr",4,4,4,"Nov",2018,2003,"Delaware Valley Regional Planning Commission"]
["2016-03-05","09:00:00","May",5,5,5,"Jan",2019,2004,"Erie MPO (EATS)"]
["2016-03-06","09:30:00","Jun",6,6,6,"Mar",2020,2005,"Franklin County MPO"]
["2016-03-07","10:00:00","Jul",7,7,7,"May",2021,2006,"Harrisburg MPO"]
["2016-03-08","10:30:00","Aug",8,8,8,"Jul",2022,2007,"Johnstown MPO"]
["2016-03-09","11:00:00","Sep",9,9,9,"Aug",2023,2008,"Lackawanna-Luzerne MPO (LLTS)"]
["2016-03-10","11:30:00","Oct",10,10,10,"Oct",2024,2009,"Lancaster MPO"]
["2016-03-11","12:00:00","Nov",11,11,11,null,2025,2010,"Lebanon County MPO"]
["2016-03-12","12:30:00","Dec",12,12,12,null,2026,2011,"Lehigh Valley (LVTS)"]
["2016-03-13","13:00:00",null,13,13,13,"Dec",2027,2012,"Northeastern Pennsylvania MPO (NEPA)"]
["2016-03-14","13:30:00",null,14,14,14,null,2028,2013,"North Central RPO"]
["2016-03-15","14:00:00",null,15,15,15,null,2029,2014,"Northern Tier RPO"]
["2016-03-16","14:30:00",null,16,16,16,null,2030,2015,"Northwest RPO"]
["2016-03-17","15:00:00",null,17,17,17,null,2031,2016,"Reading MPO (RATS)"]
["2016-03-18","15:30:00",null,18,18,18,null,2032,2017,"SEDA-COG MPO"]
["2016-03-19","16:00:00",null,19,19,19,null,2033,2018,"SVATS MPO (Mercer County)"]
["2016-03-20","16:30:00",null,20,20,20,null,2034,2019,"Southern Alleghenies RPO"]
["2016-03-21","17:00:00",null,21,21,21,null,2035,2020,"Southwestern Pennsylvania Commission (SPC)"]
["2016-03-22","17:30:00",null,22,22,22,null,2036,2021,"Wayne County - Independent"]
["2016-03-23","18:00:00",null,23,23,23,null,2037,2022,"Williamsport MPO (WATS)"]
["2016-03-24","18:30:00",null,24,24,24,null,2038,2023,"York MPO (YAMPO)"]
["2016-03-25","19:00:00",null,25,25,25,null,2039,2024]
["2016-03-25",null,null,25,25,25,null,2039,2024]
["2016-03-26",null,null,26,26,26,null,2040,2025]
["2016-03-26",null,null,26,26,26,null,2040,2025]
["2016-03-27",null,null,27,27,27,null,null,2026]
["2016-03-27",null,null,27,27,27,null,null,2026]
["2016-03-27",null,null,27,27,27,null,null,2026]
["2016-03-28",null,null,28,28,28,null,null,2027]
["2016-03-28",null,null,28,28,28,null,null,2027]
["2016-03-29",null,null,null,29,29,null,null,2028]
["2016-03-30",null,null,null,30,30,null,null,2029]
["2016-03-31",{"$nulls":4},31,null,null,2030]
["2016-04-01",{"$nulls":7},2031]
["2016-04-02",{"$nulls":7},2032]
["2016-04-03",{"$nulls":7},2033]
["2016-04-04",{"$nulls":7},2034]
["2016-04-05",{"$nulls":7},2035]
["2016-04-06",{"$nulls":7},2036]
["2016-04-07",{"$nulls":7},2037]
["2016-04-08",{"$nulls":7},2038]
["2016-04-09",{"$nulls":7},2039]
["2016-04-10",{"$nulls":7},2040]
["2016-04-11",{"$nulls":7},2041]
["2016-04-12",{"$nulls":7},2042]
["2016-04-15",{"$nulls":7},2043]
["2016-04-16",{"$nulls":7},2046]
["2016-04-17",{"$nulls":7},2047]
["2016-04-18",{"$nulls":7},2048]
["2016-04-19",{"$nulls":7},2049]
["2016-04-20",{"$nulls":7},2050]
["2016-04-21",{"$nulls":7},2051]
["2016-04-22",{"$nulls":7},2052]
["2016-04-23",{"$nulls":7},2053]
["2016-04-24",{"$nulls":7},2054]
["2016-04-24",{"$nulls":7},2055]
["2016-04-25",{"$nulls":7},2056]
["2016-04-26",{"$nulls":7},2057]
["2016-04-27",{"$nulls":7},2058]
["2016-04-28",{"$nulls":7},2059]
["2016-04-29",{"$nulls":7},2059]
["2016-04-30",{"$nulls":7},2060]
["2016-05-01"]
["2016-05-02"]
["2016-05-03"]
["2016-05-04"]
["2016-05-05"]
["2016-05-06"]
["2016-05-07"]
["2016-05-08"]
["2016-05-09"]
["2016-05-10"]
["2016-05-11"]
["2016-05-12"]
["2016-05-14"]
["2016-05-15"]
["2016-05-16"]
["2016-05-17"]
["2016-05-18"]
["2016-05-19"]
["2016-05-20"]
["2016-05-21"]
["2016-05-22"]
["2016-05-23"]
["2016-05-24"]
["2016-05-25"]
["2016-05-26"]
["2016-05-27"]
["2016-05-28"]
["2016-05-29"]
["2016-05-30"]
["2016-05-31"]
["2016-06-01"]
["2016-06-02"]
["2016-06-03"]
["2016-06-04"]
["2016-06-05"]
["2016-06-06"]
["2016-06-07"]
["2016-06-08"]
["2016-06-09"]
["2016-06-10"]
["2016-06-11"]
["2016-06-12"]
["2016-06-13"]
["2016-06-14"]
["2016-06-15"]
["2016-06-16"]
["2016-06-17"]
["2016-06-18"]
["2016-06-19"]
["2016-06-20"]
["2016-06-21"]
["2016-06-22"]
["2016-06-23"]
["2016-06-24"]
["2016-06-25"]
["2016-06-26"]
["2016-06-27"]
["2016-06-28"]
["2016-06-29"]
["2016-06-30"]
["2016-07-01"]
["2016-07-02"]
["2016-07-03"]
["2016-07-04"]
["2016-07-05"]
["2016-07-06"]
["2016-07-07"]
["2016-07-08"]
["2016-07-09"]
["2016-07-10"]
["2016-07-11"]
["2016-07-12"]
["2016-07-13"]
["2016-07-14"]
["2016-07-15"]
["2016-07-16"]
["2016-07-17"]
["2016-07-18"]
["2016-07-19"]
["2016-07-20"]
["2016-07-21"]
["2016-07-22"]
["2016-07-23"]
["2016-07-24"]
["2016-07-25"]
["2016-07-26"]
["2016-07-27"]
["2016-07-28"]
["2016-07-29"]
["2016-07-30"]
["2016-07-31"]
["2016-08-01"]
["2016-08-02"]
["2016-08-03"]
["2016-08-04"]
["2016-08-05"]
["2016-08-06"]
["2016-08-07"]
["2016-08-08"]
["2016-08-09"]
["2016-08-10"]
["2016-08-11"]
["2016-08-12"]
["2016-08-13"]
["2016-08-14"]
["2016-08-15"]
["2016-08-16"]
["2016-08-17"]
["2016-08-18"]
["2016-08-19"]
["2016-08-20"]
["2016-08-21"]
["2016-08-22"]
["2016-08-23"]
["2016-08-24"]
["2016-08-25"]
["2016-08-26"]
["2016-08-27"]
["2016-08-28"]
["2016-08-29"]
["2016-08-30"]
["2016-08-31"]
["2016-09-01"]