{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Scope Sheet","Contacts"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Scope Sheet","index":0,"n_rows":86,"n_cols":3,"rows_kept":86,"cut":false,"hidden":false,"merged":[[0,0,0,3],[85,0,96,3],[28,1,28,3],[7,1,8,3],[43,1,43,2],[45,1,45,2],[47,1,47,2],[49,1,49,2],[51,1,51,2]]}
["Transportation Management Plan-Scope of Work"]
[]
["TIP #"]
["WBS #:"]
["Division:"]
["County:"]
["Route:"]
["Project Description:"]
[]
[]
["I. Project Information"]
["Length (in miles)"]
["ADT"]
["Number of -Y- Lines"]
["Bridges"]
["Culverts"]
["Overhead Signs"]
["Signalized Intersections"]
["Temporary Signals"]
["Portable Signals"]
["Temporary Shoring"]
["Positive Protection"]
["Temporary Pavement"]
["On-site Detours/Cross-overs"]
["Road Closures/Off-site Detours"]
["Staged Construction"]
["Pedestrian Accommodation"]
[]
["II. Overall Complexity"]
["Level of Significance"]
[]
["III. TMP Details","Simple Breakdown"]
["Total Phases with Detail Sheets",5]
[]
["IV. Simple Breakdown"]
["a) Estimated Number of Phases"]
["b) Estimated Details Per Phase"]
["c) Total Overview Sheets"]
["d) Title Sheet/Notes/Phasing"]
["e) Special Details"]
["Total Anticipated Sheets=",{"$f":" B36*B37 + B38 + SUM(B39:B40)","v":0}]
[]
["IV. Advanced Breadown"]
["Phase 1"]
["b) Detail Sheets for Phase 1"]
["Phase 2"]
["b) Detail Sheets for Phase 2"]
["Phase 3"]
["b) Detail Sheets for Phase 3"]
["Phase 4"]
["b) Detail Sheets for Phase 4"]
["Phase 5"]
["b) Detail Sheets for Phase 5"]
["c) Total Overview Sheets"]
["d) Title Sheet/Notes/Phasing"]
["e) Special Details"]
["Total Anticipated Sheets=",{"$f":" (B45)+(B47)+(B49)+(B51)+(B53)+B54+B55+B56","v":0}]
[]
["V. Submittals","Required","Schedule"]
["Initiate TMP (2TM2)"]
["Final TMP (3TM1)"]
["Total Invoice Submittals=",{"$f":"COUNTIF(B60:B61,\"Yes\")","v":0}]
[]
["VI. Required Meetings and Trips"]
["Final Design Field Inspection"]
["Constructability w/ Division"]
["Temporary Shoring Meeting"]
["Pre-Let Field Inspection"]
["Pre-construction Meeting"]
["Other"]
["Total Required Meetings =",{"$f":"COUNTIF(B65:B70,\"Yes\")","v":0}]
[]
["VII. Additional Trips"]
["Project Site"]
["Division Office"]
["NCDOT Design Offices"]
["Total Additional Trips =",{"$f":"SUM(B74:B76)","v":0}]
[]
["NCDOT Contacts"]
["Work Zone Traffic Control",null,"Project Engineer"]
["Work Zone Traffic Control",null,"Project Design Engr"]
[]
[]
[]
["Additional Comments"]
["**INCLUDE ADDITIONAL PROJECT NOTES TO EXPLAIN TMP APPROACH OR  PROJECT COMPLEXITY**"]

{"sheet":"Contacts","index":1,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Complexity"]
["Complex - Staged Construction with Multiple Issues"]
["Medium - Staged Construction with Multiple Traffic Shifts"]
["Standard - Some Required Details"]
["Off-site Detour"]
[]
["Work Zone Traffic Control Personnel","Role"]
["Kenneth Thornewell, PE","Project Engr"]
["Zachary Clark, PE","Project Engr"]
["Karmen Dais, PE","Project Design Engr"]
["Justin Beaver, PE","Project Design Engr"]
["Mike Steelman","Project Design Engr"]
["Alla Lyudmirskaya","Project Design Engr"]
["Sheena Green","Project Design Engr"]
["Tad Kelly","Design Engr"]
["Habib Lawandos","Design Engr"]
["Matthew Aklilu","Design Engr"]
["William Debrew","Design Engr"]
["Chris Howard","Design Engr"]
["Brendan Price","Design Engr"]