{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["How To Setup Project","1 - Project Worksheet","2 - Manday Estimate Sheet"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":1,"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":"How To Setup Project","index":0,"n_rows":127,"n_cols":5,"rows_kept":127,"cut":false,"hidden":false,"merged":[[13,4,13,8],[1,1,1,27],[12,4,12,8],[5,3,5,8],[6,3,6,8],[8,4,8,8],[9,4,9,8],[10,4,10,8],[7,3,7,8],[11,4,11,8]]}
[]
[null,"How To Setup Project Manday Estimates"]
[]
[null,"Page Quick Links:"]
[]
[null,null,"ð","Basic Overview"]
[null,null,"ð","Project Worksheet Example"]
[null,null,"ð","Understanding the Project Worksheet"]
[null,null,null,"Ø","Group #"]
[null,null,null,"Ø","Corridor #"]
[null,null,null,"Ø","Alignment"]
[null,null,null,"Ø","Corridor Type"]
[null,null,null,"Ø","Begin & End Stationing"]
[null,null,null,"Ø","Templates / Roadway Template Library"]
[]
[null,"Basic Overview:"]
[]
[null,"1.)","Fill out Project Worksheet (Worksheet Tab:     1 - Project Worksheet)"]
[]
[null,"2.)","The sheet totals are automatically transferred from Project Worksheet to the Manday Estimate Worksheet (Worksheet Tab:     2 - Manday Estimate Sheet)"]
[]
[]
[null,"Project Worksheet Example:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Understanding the Project Worksheet:"]
[]
[null,"Group # :"]
[]
[null,"This can consist of one alignment (such as Mainline -L-) or a \"Group\" of alignments (such as an interchange).  See example below:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Corridor # :"]
[]
[null,"Each alignment represents a Corridor"]
[]
[null,"Alignment:"]
[]
[null,"Type in alignment name"]
[]
[null,"Corridor Type:"]
[]
[null,"Major Corridor - Mainline or Y-Line which meets these two criteria:"]
[null,null,"1) Divided Facility AND"]
[null,null,"2) Grade Separation Intersection with Mainline, such as part of an interchange"]
[null,"Note a bridge project with a mainline (-L-) is considered a Major Corridor."]
[]
[null,"Minor Corridor -  Y- Line, Ramp, Loop, Service Roads, Roundabouts, Driveways"]
[]
[null,"Detour Corridor - New Temporary Onsite Detour"]
[]
[null,"Begin & End Stationing:"]
[]
[null,"Type Begin and End Stationing (for each alignment)"]
[]
[null,"Typical Section/Template Type"]
[]
[null,"Select from the drop-down list of typical sections/template types to be used for each corridor.  "]

{"sheet":"1 - Project Worksheet","index":1,"n_rows":38,"n_cols":22,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,11,38,11],[1,4,3,4],[37,5,38,5],[37,10,38,10],[37,3,38,4],[1,9,3,9],[1,10,2,12],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[36,1,36,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[37,12,38,12],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[1,13,3,13],[37,1,38,1],[37,6,38,6],[1,8,3,8],[4,1,4,2],[5,1,5,2],[1,1,3,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[1,3,3,3],[10,1,10,2],[1,5,2,7],[37,7,38,7],[11,1,11,2]]}
[]
[null,"Group #",null,"Corridor #","Alignment","Corridor Type",null,null,"Begin Station","End Station","Corridor Length (Miles)",null,null,"Typical Section/Template Type"]
[]
[null,null,null,null,null,"Major","Minor","Detour",null,null,"Major","Minor","Detour"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(COUNTIF(F5,\"*\"),($J5-$I5)/5280,0),0)","v":0},{"$f":"IFERROR(IF(COUNTIF(G5,\"*\"),($J5-$I5)/5280,0),0)","v":0},{"$f":"IFERROR(IF(COUNTIF(H5,\"*\"),($J5-$I5)/5280,0),0)","v":0},null,null,null,null,null,null,null,null,"None or NA"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Undivided Facility  - Shoulder Section"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Undivided Facility  - Curb and Gutter Section"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Divided Facility - Median Ditch"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Divided Facility - Median Barrier"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Divided Facility - Raised Median"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Interchange - Ramp/Loop"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Roundabout"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Driveways"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Detour"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,"Customize"]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"IFERROR(IF(COUNTIF(G33,\"*\"),($J33-$I33)/5280,0),0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0]
[null,null,null,"Sheet Total:",null,{"$f":"COUNTIF(F5:F37,\"*\")","v":0},{"$f":"COUNTIF(G5:G37,\"*\")","v":0},{"$f":"COUNTIF(H5:H37,\"*\")","v":0},null,null,{"$f":"SUM(K5:K37)","v":0},{"$f":"SUM(L5:L37)","v":0},{"$f":"SUM(M5:M37)","v":0}]

{"sheet":"2 - Manday Estimate Sheet","index":2,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":false,"merged":[[31,11,32,11],[10,13,12,13],[27,13,28,13],[27,14,28,15],[31,13,32,13],[31,14,32,15],[36,11,37,11],[36,13,37,13],[36,14,37,15],[1,1,1,11],[51,1,51,8],[12,1,12,8],[24,1,24,8],[39,1,39,8],[43,1,43,8],[3,10,3,11],[3,1,3,8],[47,1,47,8],[8,2,8,4],[4,1,4,8],[4,10,4,11],[27,11,28,11]]}
[]
[null,"Corridor Modeling Manday Estimate"]
[]
[null,"Project Info "]
[null,"Project TIP:  "]
[]
[null,null,null,null,null,null,null,null,"Major Corridors: ",null,{"$f":"IFERROR('1 - Project Worksheet'!F38,0)","v":0},{"$f":"IFERROR('1 - Project Worksheet'!K38,0)","v":0},null,"Miles"]
[null,null,null,null,null,null,null,null,"Minor Corridors: ",null,{"$f":"IFERROR('1 - Project Worksheet'!G38,0)","v":0},{"$f":"IFERROR('1 - Project Worksheet'!L38,0)","v":0},null,"Miles"]
[null,null,null,null,null,null,null,null,"Onsite Detours: ",null,{"$f":"IFERROR('1 - Project Worksheet'!H38,0)","v":0},{"$f":"IFERROR('1 - Project Worksheet'!M38,0)","v":0},null,"Miles"]
[]
[null,null,null,null,null,null,null,null,null,null,"Manhours","Mandays",null,"Manhours Per Mile"]
[]
[null,"Setting Up Project  ",null,null,null,null,null,null,null,null,4,{"$f":"IF(SUM(K13/8)=0,\"\",SUM(K13/8))","v":0.5}]
[]
[null,"\u0098","Setting Up Corridor Modeling Preferences"]
[null,null,"\u009a","Geopak Job Number"]
[null,null,"\u009a","Preferences"]
[null,null,"\u009a","DTM (Existing Ground TIN to DTM)"]
[null,null,"\u009a","Geometry (GPK to ALG)"]
[null,null,"\u009a","Plan Graphics"]
[]
[null,"\u0098","Select Project Templates (Create Template Dialog)"]
[null,null,"\u009a","Template Library Organizer"]
[]
[null,"Corridor Management / Model Creation "]
[]
[null,"\u0098","Roadway Designer",null,null,null,null,null,"All Major Corridors:",null,null,{"$f":"K27/8","v":0}]
[null,null,"\u009a","Corridors - Mainline, Y Lines, etc.",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K27/L7,0)","v":0}]
[null,null,"\u009a","Create and Manage Corridors",null,null,"                     "]
[null,null,"\u009a","Template Drops"]
[null,null,"\u009a","Adding Superelevation",null,null,null,null,"All Minor Corridors:",null,null,{"$f":"K31/8","v":0}]
[null,null,"\u009a","Using Parametric Constraints",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K31/L8,0)","v":0}]
[null,null,"\u009a","Point Controls"]
[null,null,"\u009a","Create Surface (DTM, TIN)"]
[]
[null,"\u0098","New Temporary Onsite Detours",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K36/8)=0,\"\",SUM(K36/8))","v":""}]
[null,null,"\u009a","Project with New Temporary Onsite Detour",null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K36/L9,0)","v":0}]
[null,null,"\u009a","Temporary Detour Removal"]
[]
[null,"Create Cross Sections Sheets  ",null,null,null,null,null,null,null,null,4,{"$f":"IF(SUM(K40/8)=0,\"\",SUM(K40/8))","v":0.5}]
[]
[null,"\u0098","Draw Cross Sections from Surfaces (Includes Cross Section Labeling)"]
[]
[null,"Create Merged TIN  ",null,null,null,null,null,null,null,null,4,{"$f":"IF(SUM(K44/8)=0,\"\",SUM(K44/8))","v":0.5}]
[]
[null,"\u0098","Merge Existing and Proposed TIN File"]
[]
[null,"Hydraulics",null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(K48/8)=0,\"\",SUM(K48/8))","v":""}]
[]
[null,"\u0098","Incorporating Drainage Ditches into the Model"]
[null,null,null,null,null,null,null,null,null,null,null,null,"**"]
[null,"Custom Template  ",null,null,null,null,null,null,null,null,4,{"$f":"IF(SUM(K52/8)=0,\"\",SUM(K52/8))","v":0.5}]
[]
[null,"\u0098","Customizing and Adjusting of Templates"]
[]
[null,"    ** Please Note:  If more than one day is needed, please contact NCDOT"]
[null,"                                   Roadway Support for development of templates."]
[]
[null,"Rev. 2015.07.24",null,null,null,null,null,null,null,null,"Manday Estimate Totals  ",{"$f":"IF(SUM(L13,L27,L31,L36,L40,L44,L52)=0,\"\",SUM(L13,L27,L31,L36,L40,L44,L52,L48))","v":2}]
[null,null,null,null,null,null," "]