{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Step 1. Implementation Form","Step 2.Fact Sheet Form (if req)","Step 3.Deficiency Form (if req)","Reference (CMP Scoring Table)","Answer Key","Raw Data"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":11,"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":"Step 1. Implementation Form","index":0,"n_rows":142,"n_cols":16,"rows_kept":142,"cut":false,"hidden":false,"merged":[[132,10,132,15],[76,5,76,7],[70,12,70,14],[96,5,96,10],[66,5,66,6],[66,7,66,11],[67,5,67,6],[67,7,67,11],[131,11,131,12],[52,13,52,15],[53,13,53,15],[54,13,54,15],[55,13,55,15],[65,5,65,6],[65,7,65,11],[7,7,7,15],[35,5,35,10],[35,11,35,13],[34,11,34,14],[12,7,12,15],[13,7,13,15],[14,7,14,15],[18,5,25,17],[86,4,87,4],[88,4,89,4],[90,4,91,4],[41,7,41,11],[42,7,42,11],[43,7,43,11],[52,5,52,6],[52,7,52,11],[53,5,53,6],[53,7,53,11],[54,5,54,6],[54,7,54,11],[55,5,55,6],[55,7,55,11],[64,5,64,6],[64,7,64,11],[92,4,93,4],[58,5,58,11],[70,5,70,11],[0,4,0,19],[34,4,34,10],[10,4,10,19],[40,5,40,6],[41,5,41,6],[2,7,2,15],[3,7,3,15],[4,7,4,15],[5,7,5,15],[6,7,6,15],[42,5,42,6],[43,5,43,6],[40,7,40,11]]}
[null,null,null,null,"NCTCOG CMP\nPROJECT IMPLEMENTATION FORM"]
[]
[null,null,null,null,"Submitter Name:",null,null,"[Name]"]
[null,null,null,null,"Agency Name:",null,null,"[Name]"]
[null,null,null,null,"Agency Address:",null,null,"[Address]"]
[null,null,null,null,"Email:",null,null,"[Email]"]
[null,null,null,null,"Telephone Number:",null,null,"[Number]"]
[null,null,null,null,"Date:",null,null,"[Date]"]
[]
[]
[null,null,null,null,"Please answer the following questions"]
[]
[null,null,null,null,"Project Name",null,null,"[Name]"]
[null,null,null,null,"Project Limits (From)",null,null,"[Enter Here]"]
[null,null,null,null,"Project Limits (To)",null,null,"[Enter Here]"]
[null,null,null,null,"CSJ Number",null,null,"[Enter Here]"]
[null,null,null,null,"Project Description (Including Travel Demand Management or Transportation System Management & Operations components)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2. Does this project add roadway capacity? (IF NOT, THIS FORM IS NOT REQUIRED)"]
[]
[]
[]
[]
[null,null,null,null,"3. Are complementary Travel Demand Management (TDM) or Transportation System Management & Operations (TSM&O) projects within the corridor in the TIP?"]
[null,null,null,null,null,"If \"yes,\" enter the project name(s), TIP Code(s) and/or CSJ number(s) in table below."]
[null,null,null,null,"This information can be verified at the following link:",null,null,null,null,null,null,"Transportation Improvement Program Information System (TIPINS)"]
[null,null,null,null,null,"*For a list of TDM and TSM&O project types see:",null,null,null,null,null,"Appendix A - TDM and TSM&O Strategies"]
[]
[]
[]
[]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"TIP Code","[Enter Here]","CSJ#","[Enter Here]"]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"TIP Code","[Enter Here]","CSJ#","[Enter Here]"]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"TIP Code","[Enter Here]","CSJ#","[Enter Here]"]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"TIP Code","[Enter Here]","CSJ#","[Enter Here]"]
[]
[]
[null,null,null,null,null,"3b. Are there any other projects not included in the TIP that may complement the project?"]
[null,null,null,null,null,"If \"yes,\" enter the project name(s) and implementing agency in table below."]
[]
[]
[]
[]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"Implementing Agency","[Enter Here]"]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"Implementing Agency","[Enter Here]"]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"Implementing Agency","[Enter Here]"]
[null,null,null,null,null,"Project Name",null,"[Enter Here]",null,null,null,null,"Implementing Agency","[Enter Here]"]
[]
[null,null,null,null,"4. Are the project limits within a corridor included in the current Metropolitan Transportation Plan? "]
[null,null,null,null,null,"This information can be verified in the Mobility Options found here:",null,null,null,null,null,null,"Freeways / Tollways / RSA's",null,"Non RAS's"]
[null,null,null,null,null,"If \"yes,\" enter the MTP Reference #(s) in table below"]
[]
[]
[]
[]
[null,null,null,null,null,"MTP Reference #",null,"[Enter Here]"]
[null,null,null,null,null,"MTP Reference #",null,"[Enter Here]"]
[null,null,null,null,null,"MTP Reference #",null,"[Enter Here]"]
[null,null,null,null,null,"MTP Reference #",null,"[Enter Here]"]
[]
[null,null,null,null,"5. Are the project limits within a corridor included in the current CMP Corridor Analysis? "]
[null,null,null,null,null,"The complete inventory of corridor fact sheets can be found here:",null,null,null,null,null,null,"Appendix C - CMP Corridor Fact Sheet"]
[]
[]
[]
[null,null,null,null,null,"*If \"yes,\" please proceed to question six.  "]
[null,null,null,null,null,"*If \"no,\" please evaluate corridor to determine if improvements are needed by completing the Fact Sheet Form in Step 2 in the tab below, before proceeding to question six."]
[]
[null,null,null,null,"6. Is the corridor identified as deficient in any category?"]
[]
[]
[]
[null,null,null,null,null,"*If \"yes,\" please proceed to questions seven."]
[null,null,null,null,null,"*If \"no,\" please proceed to question 11."]
[]
[null,null,null,null,"7. Identify corridor deficiencies as specified in the current CMP Corridor Analysis or in the CMP Roadway Deficiency Form.  (Check all that apply)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"8. Review Appendix A of the current CMP or other available resources to identify possible congestion mitigation strategies to correct the deficiency.  (Check all that apply)"]
[null,null,null,null,null,"Appendix A - TDM and TSM&O Strategies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"9. Specify deficiency-correcting congestion mitigation strategy that will be implemented as part of the project."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"10. If not implementing a congestion mitigation strategy, please explain reason."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"11. Submit completed form to NCTCOG - CMP Team at:",null,null,null,null,null,null,"equintana@nctcog.org"]
[null,null,null,null,null,null,null,null,null,null,"*Submit button will auto generate email to NCTCOG  with completed excel document attached. \nPlease finalize step by sending the email."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"If you have questions, please contact Eric Quintana at equintana@nctcog.org  / 817-608-2381 or Natalie Bettger at nbettger@nctcog.org / 817-695-9280"]

{"sheet":"Step 2.Fact Sheet Form (if req)","index":1,"n_rows":125,"n_cols":16,"rows_kept":125,"cut":false,"hidden":false,"merged":[[21,6,21,10],[124,4,128,19],[56,15,59,17],[15,14,15,16],[16,14,16,16],[17,14,17,16],[18,14,18,16],[19,14,19,16],[20,14,20,16],[21,14,21,16],[17,4,17,5],[21,12,21,13],[21,4,21,5],[17,6,17,10],[14,11,21,11],[19,4,19,5],[20,12,20,13],[20,6,20,10],[16,4,16,5],[16,6,16,10],[18,4,18,5],[18,6,18,10],[20,4,20,5],[19,6,19,10],[16,12,16,13],[17,12,17,13],[18,12,18,13],[19,12,19,13],[1,4,1,19],[3,7,3,15],[4,7,4,15],[5,7,5,15],[7,7,7,15],[8,7,8,15],[15,4,15,5],[15,6,15,10],[14,12,14,13],[14,14,14,16],[15,12,15,13],[11,4,11,19],[14,4,14,5],[14,6,14,10]]}
[]
[null,null,null,null,"CMP CORRIDOR ANALYSIS - FACT SHEET"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Functional Class",null,"[ENTER HERE]\n",null,null,null,null,null,"Direct Connections",null,"[YES/NO]"]
[null,null,null,null,"HOV Lanes",null,"[YES/NO]",null,null,null,null,null,"Truck Lane Restriction",null,"[YES/NO]"]
[null,null,null,null,"Parrallel Freeways\n(within 5 miles)",null,"[YES/NO]",null,null,null,null,null,"Hazmat Route",null,"[YES/NO]"]
[null,null,null,null,"Shoulders",null,"[YES/NO]",null,null,null,null,null,"Population",null,"[ENTER HERE]\n"]
[null,null,null,null,"Frontage Roads",null,"[YES/NO]",null,null,null,null,null,"Number of Employees",null,"[ENTER HERE]\n"]
[null,null,null,null,"Bike Options",null,"[YES/NO]",null,null,null,null,null,"FIM Training Participants",null,"[ENTER HERE]\n"]
[null,null,null,null,"Available Transit",null,"[YES/NO]",null,null,null,null,null,"Crash Rate\n(Use Most Recent Year)",null,"[ENTER HERE]\n"]
[null,null,null,null,"Park and Ride",null,"[YES/NO]",null,null,null,null,null,"Construction Status",null,"[ENTER HERE]\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Step 3.Deficiency Form (if req)'!H88+'Step 3.Deficiency Form (if req)'!H67+'Step 3.Deficiency Form (if req)'!H29+'Step 3.Deficiency Form (if req)'!H48","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"DEFICIENCY FORM IS REQUIRED WITH THIS SHEET\nPLEASE COMPLETE BY GOING TO TAB 3 (STEP 3. DEFICIENCY FORM)\nCLICK HERE"]

{"sheet":"Step 3.Deficiency Form (if req)","index":2,"n_rows":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":false,"merged":[[35,0,35,5],[47,0,47,5],[49,0,49,5],[52,0,52,5],[89,0,89,5],[66,0,66,5],[68,0,68,5],[71,0,71,5],[73,0,73,5],[81,0,81,4],[87,0,87,5],[54,0,54,5],[14,0,14,5],[16,0,16,5],[28,0,28,5],[30,0,30,5],[33,0,33,5],[0,0,0,1],[0,2,0,4],[2,0,2,1],[2,2,2,4],[4,0,4,1],[4,2,4,4],[12,0,12,1],[12,2,12,3],[6,0,6,1],[6,2,6,3],[8,0,8,1],[8,2,8,3],[10,0,10,1],[10,2,10,3]]}
["Project Name:"]
[]
["Project Limits (From and To):"]
[]
["Agency Name:"]
[]
["Submitter Name:"]
[]
["Telephone:"]
[]
["Email:"]
[]
["Date Submitted:"]
[]
["Alternative Roadway Corridor Deficiency"]
[]
["The factors that influence alternative roadway infrastructure include the presence of parallel freeways, frontage roads, parallel arterials, and direct connections or interchanges."]
[]
[null,null,null,null,null,"Click Cell To Select Answer",null,"Score"]
[]
["1. Does the roadway facility have a parallel freeway or toll road within five miles?",null,null,null,null,"Please Select",null,{"$f":"IF(F21=\"Please Select\",0,IF(F21=\"Yes\",12,IF(F21=\"No\",0)))","v":0}]
[]
["2. Does the roadway facility include a frontage road system?",null,null,null,null,"Please Select",null,{"$f":"IF(F23=\"Please Select\",0,IF(F23=\"Yes, entire limits\",7,IF(F23=\"Yes, partial limits\",3,IF(F23=\"No\",0))))","v":0}]
[]
["3. Does the roadway facility have a parallel arterial within two miles?",null,null,null,null,"Please Select",null,{"$f":"IF(F25=\"Please Select\",0,IF(F25=\"Yes, both entire and partial limits\",4,IF(F25=\"Yes, entire limits\",3,IF(F25=\"Yes, partial limits\",1,IF(F25=\"No\",0)))))","v":0}]
[]
["4. Does the roadway network include a direct connection or non-signalized interchange to another highway?",null,null,null,null,"Please Select",null,{"$f":"IF(F27=\"Please Select\",0,IF(F27=\"Yes\",2,IF(F27=\"No\",0)))","v":0}]
[]
["Total Points Received in Alternative Roadway Infrastructure Category",null,null,null,null,null,null,{"$f":"H21+H23+H25+H27","v":0}]
[]
["If total score is 14 or below, then improvements are needed in this category. Please see Appendix A of the current CMP to identify possible congestion mitigation strategies to correct the deficiency."]
[]
[]
["Modal Options Deficiency"]
[]
["The factors that influence modal options include the presence of transit options (bus and/or rail), park-and-ride facilities, HOV/Managed Lanes, and bicycle/pedestrian options."]
[]
[null,null,null,null,null,"Click Cell To Select Answer",null,"Score"]
[]
["1. Does the roadway facility have established transit service?",null,null,null,null,"Please Select",null,{"$f":"IF(F40=\"Please Select\",0,IF(F40=\"Yes, both bus and rail\",10,IF(F40=\"Yes, rail only\",7,IF(F40=\"Yes, bus only\",5,IF(F40=\"No\",0)))))","v":0}]
[]
["2. Is a park-and-ride facility located along the roadway corridor?",null,null,null,null,"Please Select",null,{"$f":"IF(F42=\"Please Select\",0,IF(F42=\"Yes\",7,IF(F42=\"No\",0)))","v":0}]
[]
["3. Are HOV or Managed lanes available along the roadway corridor?",null,null,null,null,"Please Select",null,{"$f":"IF(F44=\"Please Select\",0,IF(F44=\"Yes\",5,IF(F44=\"No\",0)))","v":0}]
[]
["4. Are bike trails or other bike options available along the roadway corridor?",null,null,null,null,"Please Select",null,{"$f":"IF(F46=\"Please Select\",0,IF(F46=\"Yes, entire limits\",3,IF(F46=\"Yes, partial limits\",1,IF(F46=\"No\",0))))","v":0}]
[]
["Total Points Received in Modal Options Category",null,null,null,null,null,null,{"$f":"H40+H42+H44+H46","v":0}]
[]
["If total score is 14 or below, then improvements are needed in this category. Please see Appendix A of the current CMP to identify possible congestion mitigation strategies to correct the deficiency."]
[]
[]
["System Demand (Recurring) Deficiency"]
[]
["The factors that influence system demand include traffic volume, truck volume/percentage, number of employees along the roadway corridor block, and residential population."]
[]
[null,null,null,null,null,"Click Cell To Select Answer",null,"Score"]
[]
["1. Is the peak hour volume capacity above or below the current average Peak V/C of 0.692?",null,null,null,null,"Please Select",null,{"$f":"IF(F59=\"Please Select\",0,IF(F59=\"Below or equal to the Average\",10,IF(F59=\"Above the Average\",3,)))","v":0}]
[]
["2. Is the truck volume percentage along the corridor above or below the current average of 9%?",null,null,null,null,"Please Select",null,{"$f":"IF(F61=\"Please Select\",0,IF(F61=\"Below or equal to the Average\",7,IF(F61=\"Above the Average\",1,)))","v":0}]
[]
["3. Is the total number of employees along the corridor above or below the current average of 82,549 (by TSZ)?",null,null,null,null,"Please Select",null,{"$f":"IF(F63=\"Please Select\",0,IF(F63=\"Below or equal to the Average\",5,IF(F63=\"Above the Average\",1,)))","v":0}]
[]
["4. Is the population along the corridor above or below the current average of 74,611 (by TSZ)?",null,null,null,null,"Please Select",null,{"$f":"IF(F65=\"Please Select\",0,IF(F65=\"Below or equal to the Average\",3,IF(F65=\"Above the Average\",1,)))","v":0}]
[]
["Total Points Received in System Demand Category",null,null,null,null,null,null,{"$f":"H59+H61+H63+H65","v":0}]
[]
["If total score is 14 or below, then improvements are needed in this category. Please see Appendix A of the current CMP to identify possible congestion mitigation strategies to correct the deficiency."]
[]
[]
["System Reliability (Non-Recurring) Deficiency"]
[]
["The factors that influence system reliability include facility crash rates, agencies that participate in incident management training, truck lane restrictions, roadway shoulders, and the presence of Intelligent Transportation Systems (ITS) technology."]
[]
[null,null,null,null,null,"Click Cell To Select Answer",null,"Score"]
[]
["1. Is the crash rate for the corridor below or above the current crash rate average of 75.19?*",null,null,null,null,"Please Select",null,{"$f":"IF(F78=\"Please Select\",0,IF(F78=\"Below or equal to the Average\",10,IF(F78=\"Above the Average\",3,)))","v":0}]
[]
["2. Does the roadway facility have paved shoulders?",null,null,null,null,"Please Select",null,{"$f":"IF(F80=\"Please Select\",0,IF(F80=\"Yes, full outside and inside shoulders\",6,IF(F80=\"Yes, partial shoulders along the entire limits\",3,IF(F80=\"Yes, one shoulder\",1,IF(F80=\"No\",0)))))","v":0}]
[]
["3. Have emergency response agencies (police and fire) along the corridor participated in Freeway Incident Management (FIM) training?**",null,null,null,null,"Please Select",null,{"$f":"IF(F82=\"Please Select\",0,IF(F82=\"Yes, entire limits\",3,IF(F82=\"Yes, partial limits\",1,IF(F82=\"No\",0))))","v":0}]
[]
["4. Have truck lane restrictions been implemented along the corridor?",null,null,null,null,"Please Select",null,{"$f":"IF(F84=\"Please Select\",0,IF(F84=\"Yes, entire limits\",3,IF(F84=\"Yes, partial limits\",1,IF(F84=\"No\",0))))","v":0}]
[]
["5. Is Intelligent Transportation Systems (ITS) technology being utilized along the corridor?",null,null,null,null,"Please Select",null,{"$f":"IF(F86=\"Please Select\",0,IF(F86=\"Yes, entire limits\",3,IF(F86=\"Yes, partial limits\",1,IF(F86=\"No\",0))))","v":0}]
[]
["Total Points Received in System Reliability Category",null,null,null,null,null,null,{"$f":"H78+H80+H82+H84+H86","v":0}]
[]
["If total score is 14 or below, then improvements are needed in this category. Please see Appendix A of the current CMP to identify possible congestion mitigation strategies to correct the deficiency."]
[]
["Notes:"]
["*Please use most recent crash year if available."]
["**FIM attendance information is maintained by NCTCOG Safety staff. Please call 817-695-9245 to request information."]
["CMP 2013 - Appendix A"]

{"sheet":"Reference (CMP Scoring Table)","index":3,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[[55,0,74,0],[55,1,57,1],[55,4,74,4],[56,2,56,3],[59,1,62,1],[64,1,66,1],[68,1,70,1],[72,1,74,1],[39,0,53,0],[39,1,41,1],[39,4,53,4],[40,2,40,3],[43,1,45,1],[44,2,44,3],[47,1,49,1],[48,2,48,3],[51,1,53,1],[52,2,52,3],[24,0,37,0],[24,1,27,1],[24,4,37,4],[29,1,30,1],[32,1,33,1],[35,1,37,1],[9,0,22,0],[9,1,10,1],[9,4,22,4],[12,1,14,1],[16,1,19,1],[21,1,22,1],[0,0,0,4],[1,0,3,0],[1,1,3,1],[1,2,3,4],[5,0,6,0],[5,1,6,4]]}
["Screening Criteria"]
["Construction","Under Construction and \nFunded Future Construction","This will be used as a screening process when assigning points to a corridor. If the corridor is under/planned construction then it can be exempt from being scored since a solution is currently being proposed. "]
[]
[]
[]
["Points Description","The maximum number of points a corridor can receive is 100. This means that the corridor is functioning at a sufficient level based on the four scoring categories. If the corridor receives a low score, then improvements should be considered in the four scoring categories. "]
[]
[]
["Category","Inventory","Measure","Points","Max Number of Points"]
["Alternative Roadway Infrastructure (Services)","Parallel Freeway/Toll Roads¹ (5 mi)","Yes",12,25]
[null,null,"None",0]
[]
[null,"Frontage Roads¹","Entire Limits",7]
[null,null,"Partial Limits",3]
[null,null,"None",0]
[]
[null,"Parallel Arterials¹","Entire and Partial Limits",4]
[null,null,"Entire Limits",3]
[null,null,"Partial Limits",1]
[null,null,"None",0]
[]
[null,"Direct Connections (Interchanges)¹","Yes",2]
[null,null,"None",0]
[]
["Modal Options (Services)","Transit²","Bus and Rail",10,25]
[null,null,"Rail",7]
[null,null,"Bus",5]
[null,null,"None",0]
[]
[null,"Park-and-Ride³","Yes",7]
[null,null,"None",0]
[]
[null,"HOV Lanes¹","Yes",5]
[null,null,"None",0]
[]
[null,"Bike Options³","Entire Limits",3]
[null,null,"Partial Limits",1]
[null,null,"None",0]
[]
["System Demand (Recurring)","Peak V/C³","Below or Average",10,25]
[null,null,"Average - 0.692"]
[null,null,"Above",3]
[]
[null,"Truck Volume Percentage³","Below or Average",7]
[null,null,"Average - 9%"]
[null,null,"Above",1]
[]
[null,"Number of Employees (by TSZ)⁴","Below or Average",5]
[null,null,"Average - 82,549"]
[null,null,"Above",1]
[]
[null,"Population (by TSZ)⁴","Below or Average",3]
[null,null,"Average - 74,611"]
[null,null,"Above",1]
[]
["System Reliability (Non Recurring)","2012 Crash Rate³","Below or Average",10,25]
[null,null,"Regional Rate Average - 75.19"]
[null,null,"Above",3]
[]
[null,"Shoulders¹","Full Outside and Inside",6]
[null,null,"Partial Shoulders",3]
[null,null,"One Shoulder ",1]
[null,null,"None",0]
[]
[null,"FIM Attendance/Training³","Entire Limits",3]
[null,null,"Partial Limits",1]
[null,null,"None",0]
[]
[null,"Truck Lane Restrictions³","Entire Limits",3]
[null,null,"Partial Limits",1]
[null,null,"None",0]
[]
[null,"Intelligent Transportation Systems³","Entire Limits",3]
[null,null,"Partial Limits",1]
[null,null,"None",0]

{"sheet":"Answer Key","index":4,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[1,"Please Select","Yes","No"]
[]
[2,"Please Select","Yes, entire limits","Yes, partial limits","No"]
[]
[3,"Please Select","Yes, both entire and partial limits","Yes, entire limits","Yes, partial limits","No"]
[]
[4,"Please Select","Yes","No"]
[]
[1,"Please Select","Yes, both bus and rail","Yes, rail only","Yes, bus only","No"]
[]
[2,"Please Select","Yes","No"]
[]
[3,"Please Select","Yes","No"]
[]
[4,"Please Select","Yes, entire limits","Yes, partial limits","No"]
[]
[1,"Please Select","Below or Equal to the Average","Above the Average"]
[]
[2,"Please Select","Below or Equal to the Average","Above the Average"]
[]
[3,"Please Select","Below or Equal to the Average","Above the Average"]
[]
[4,"Please Select","Below or Equal to the Average","Above the Average"]
[]
[1,"Please Select","Below or Equal to the Average","Above the Average"]
[]
[2,"Please Select","Yes, full outside and inside shoulders","Yes, partial shoulders along the entire limits","Yes, one shoulder","No"]
[]
[3,"Please Select","Yes, entire limits","Yes, partial limits","No"]
[]
[4,"Please Select","Yes, entire limits","Yes, partial limits","No"]
[]
[5,"Please Select","Yes, entire limits","Yes, partial limits","No"]

{"sheet":"Raw Data","index":5,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Question 2","\"Select Dropdown\""]
[null,"PLEASE SELECT"]
[null,"YES"]
[null,"NO",null,null,null,"YES"]