{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RID","Auto Fill Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"RID","index":0,"n_rows":101,"n_cols":18,"rows_kept":101,"cut":false,"hidden":false,"merged":[[67,10,67,11],[49,10,49,11],[1,0,1,14],[2,0,2,14],[25,10,25,11],[72,10,72,11],[47,10,47,11],[36,10,36,11],[37,10,37,11],[38,10,38,11],[39,10,39,11],[42,10,42,11],[46,10,46,11],[40,10,40,11],[41,10,41,11],[30,10,30,11],[31,10,31,11],[32,10,32,11],[69,10,69,11],[68,10,68,11],[71,10,71,11],[56,10,56,11],[10,1,10,9],[57,10,57,11],[73,10,73,11],[76,13,77,13],[76,14,77,14],[62,10,62,11],[63,10,63,11],[75,10,75,11],[70,10,70,11],[58,10,58,11],[59,10,59,11],[60,10,60,11],[61,10,61,11],[74,10,74,11],[35,10,35,11],[48,10,48,11],[14,10,14,11],[13,10,13,11],[19,10,19,11],[22,10,22,11],[65,10,65,11],[15,10,15,11],[33,10,33,11],[66,10,66,11],[78,13,81,13],[78,14,81,14],[76,10,76,11],[78,10,78,11],[78,12,81,12],[79,10,79,11],[80,10,80,11],[81,10,81,11],[76,12,77,12],[77,10,77,11],[82,13,83,13],[82,14,83,14],[100,10,100,11],[101,10,101,11],[97,10,97,11],[98,10,98,11],[99,10,99,11],[96,10,96,11],[85,10,85,11],[92,10,92,11],[93,10,93,11],[94,10,94,11],[95,10,95,11],[89,10,89,11],[90,10,90,11],[91,10,91,11],[82,10,82,11],[82,12,83,12],[83,10,83,11],[84,10,84,11],[88,10,88,11],[87,10,87,11],[86,10,86,11],[16,17,16,20],[1,17,14,20],[16,10,16,11],[17,10,17,11],[18,10,18,11],[64,10,64,11],[20,10,20,11],[21,10,21,11],[26,10,26,11],[27,10,27,11],[24,10,24,11],[28,10,28,11],[29,10,29,11],[43,10,43,11],[44,10,44,11],[45,10,45,11],[50,10,50,11],[51,10,51,11],[52,10,52,11],[53,10,53,11],[54,10,54,11],[55,10,55,11],[34,10,34,11],[23,10,23,11]]}
[]
["Michigan Department of Transportation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions: This worksheet is to be prepared by the Project Design Team and submitted at each milestone submittal.  The project Design Team should select \"YES\", \"NO\", or \"N/A\" for each category according to the project requirements.  \n\nNote: If \"N/A\" is selected for any category make sure to provide a note as to why the item is not included with the project submittal in the Preliminary Comments Column of the grey header.\n\nVerification: Verify that all of the categories for your project are marked with an \"X\" and note whether the information has been submitted with the milestone submittal.  \n\nFilter: This form will automatically filter by milestones.  Simply press the \"Preliminary\", \"OEC\". or \"RID\" buttons and the form will automatically hide the columns for the other milestone submittals and will also hide the rows that do not have an \"X\" in them at the milestone you have selected.\n\nPrinting: When this form is complete and filtered, perform a print preview. Modify the settings as necessary to show the information in a legible manner. Print on multiple sheets as necessary.  Do not print any content beyond Column O."]
["RID Review Checklist"]
[null,null,null,null,null,null,null,null,null,null,"Control Section(s):",null,"Revision Date:","2015-04-06"]
[null,null,null,null,null,null,null,null,null,null,"Job Number(s):"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Version of Software Used:","Select a Version"]
[null,null,null,null,null,null,null,null,null,null,"Consultant Firm:",null,"Primary Project Description:","Select a Project Description"]
[null,null,null,null,null,null,null,null,null,null,"Consultant Project Manager:"]
[null,null,null,null,null,null,null,null,null,null,"MDOT Project Manager:",null,"Comment Legend:","Design Team Comments"]
[null,null,null,null,null,null,null,null,null,null,"Model Reviewers:",null,null,"Reviewer Comments"]
[null,"Milestone"]
["Date:",null,null,null,null,null,null,null,null,null,"Approval:","Date:"]
[]
[null,"Preliminary","Project Design Team Checked","Reviewer Checked","OEC","Project Design Team Checked","Reviewer Checked","RID","Project Design Team Checked","Reviewer Checked","Item",null,"Preliminary Comments","OEC Comments","RID Comments"]
[null,null,null,null,null,null,null,null,null,null,"File Content"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are all of the files named correctly"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are all of the files in the correct format"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are all of the files present (See RID Project Data Summary and Design Submittal Requirements Document) "]
[null,null,"- - Select - -",null,null,"- - Select - -",null,"X","- - Select - -",null,"No files referenced into the drawing except for those called for in Chapter 3"]
[null,null,null,null,null,null,null,null,null,null,"Alignment Files"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Horizontal Alignment DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Vertical Alignment DGN File"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Alignment Land XML File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Alignment Reports from GEOPAK for each alignment within the project"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the side road profiles match the mainline profile at the correct station"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the profile elevations match existing at the tie down points"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the proposed slopes match the existing slopes at the tie down points"]
[null,null,null,null,null,null,null,null,null,null,"Design Files"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Construction DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Lighting Construction DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Signing Construction DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Signal Construction DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"ITS Construction DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Drainage DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Existing Topo DGN File"]
[null,null,null,null,null,null,null,null,null,null,"Models"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed 3D Components DGN File (SS2 Only)"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed 3D Corridor DGN File (SS3 Only)"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed 3D Line String Top Surface DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed 3D Line String Bottom Surface DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed 3D Line String Side Road Surface DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed 3D Line String Side Road SubSurface DGN File"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Triangles DGN File"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Top Surface LandXML File"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Bottom Surface LandXML File"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Roadway Top Surface LandXML File"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Roadway Bottom Surface LandXML File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are the model and the contract document (The Plans) exactly the same"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Does the template match pavement design or typical section"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the detailed grades on the plans match the model for slope and elevation"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the cross slopes of the  model match the cross slopes in the plans, for example (superelevated areas and transitions)"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the lane widths in the model match the plan data"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the modeled features match the plan labeling"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the modeled features represent the correct dimensions called for on the plans"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the lane and shoulder taper points match the stations and length on the plans"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are the gore and corridor merge areas modeled correctly"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are there any significant gaps in the hard surface of the model"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are the Civil Cells adjusted correctly (SS3 Only)"]
[null,null,null,null,null,null,null,null,null,null,"Drainage and SUE"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Make sure drainage structures line up with the appropriate 3D Lines (curb, ditches, etc.)"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Low Points are accounted for"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Are the ditches aligned at transition points"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Outfall ties to existing drainage patterns"]
[null,null,"N/A",null,null,"N/A",null,null,"N/A",null,"Clash Detection (If applicable)"]
[null,null,null,null,null,null,null,null,null,null,"Reports"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Do the beginning and end bearings on horizontal curves match the tangents"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Drainage Report attached showing all drainage calculations"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Earthwork Reports generated containing all earthwork calculations"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Other Reports as needed for each roadway"]
[null,null,null,null,null,null,null,null,null,null,"Environmental Files"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Environmental DGN Files not included in the plans or proposal"]
[null,null,null,null,null,null,null,null,null,null,"Geotechnical Files"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Geotechnical Files not included in the plans or proposal"]
[null,null,null,null,null,null,null,null,null,null,"Utilities"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed Utilities are submitted in a separate DGN File if not included in the Construction DGN File"]
[null,null,null,null,null,null,null,null,null,null,"Geospatial Data"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Data was created with the correct units applied"]
[null,"X","- - Select - -",null,null,"- - Select - -",null,"X","- - Select - -",null,"International Feet"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Data was created with the correct Horizontal Datum"]
[null,"X","- - Select - -",null,null,"- - Select - -",null,"X","- - Select - -",null,"MI - SPC North Zone (2111)"]
[null,"X","- - Select - -",null,null,"- - Select - -",null,"X","- - Select - -",null,"MI - SPC Central Zone (2112)"]
[null,"X","- - Select - -",null,null,"- - Select - -",null,"X","- - Select - -",null,"MI - SPC South Zone (2113)"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Data was created with the correct Vertical Datum"]
[null,"X","- - Select - -",null,null,"- - Select - -",null,"X","- - Select - -",null,"NAVD 88"]
[null,null,null,null,null,null,null,null,null,null,"Construction / Survey Data"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Survey 2D/3D DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Project Control is distributed uniformly throughout the job to result in a good site calibration"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Survey Alignment and ROW DGN File"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Survey Alignment File in LandXML Format"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"The survey data used for the design (Topo.dgn) is consistent with the files submitted by Survey."]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Control Points file format P,N,E,Z,D.txt"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Benchmark file format P,N,E,Z,D.txt"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Proposed tie in elevations match existing survey data"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Template drop interval / frequency is spaced correctly for the construction application"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Template drop locations are coincident with key station points (Taper Points, grade transitions,…)"]
[null,"X","- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Ex. Survey 3D line strings are on the correct level and drafting style"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Ex. Survey 3D line strings are exported in LandXML format"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"Ex. Triangle of top surface is exported in LandXML format for each roadway"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"LandXML Files are imported in to a new drawing to verify they have not been shifted or rotated"]
[null,null,"- - Select - -",null,"X","- - Select - -",null,"X","- - Select - -",null,"All other data files are overlaid on each other to make sure everything lines up"]
[null,null,"N/A",null,null,"N/A",null,null,"N/A",null,"Simulated ride quality value is within a value of 15",null,"Guidance forthcoming as possible methods are currently being investigated."]

{"sheet":"Auto Fill Data","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Select a Version",null,null,"Select a Project Description",null,null,null,null,null,null,"- - Select - -"]
["Power GEOPAK SS2",null,null,"ROAD - REHABILITATION AND RECONSTRUCTION",null,null,null,null,null,null,"Yes"]
["Power GEOPAK SS3",null,null,"ROAD - CAPITAL PREVENTIVE MAINTENANCE",null,null,null,null,null,null,"No"]
[null,null,null,"TRAFFIC & SAFETY - OVERHEAD SIGN STRUCTURES",null,null,null,null,null,null,"N/A"]
[null,null,null,"TRAFFIC & SAFETY - SIGNS"]
[null,null,null,"TRAFFIC & SAFETY - PAVEMENT MARKINGS"]
[null,null,null,"TRAFFIC & SAFETY - SIGNALS"]
[null,null,null,"TRAFFIC & SAFETY - IMPACT ATTENUATORS"]
[null,null,null,"TRAFFIC & SAFETY - GUARDRAILS"]
[null,null,null,"TRAFFIC & SAFETY - SAFETY PROGRAMS"]
[null,null,null,"CAPACITY IMPROVEMENT"]
[null,null,null,"NEW ROADS"]
[null,null,null,"NOISE ABATEMENT"]
[null,null,null,"REST AREAS"]
[null,null,null,"RAILROAD CROSSINGS TRUNKLINE"]
[null,null,null,"INTELLIGENT TRANSPORTATION SYSTEMS"]
[null,null,null,"CONGESTION MITIGATION AND AIR QUALITY"]
[null,null,null,"PASSING RELIEF LANES (PRL)"]
[null,null,null,"BRIDGE - REPLACEMENT AND REHAB"]
[null,null,null,"WETLAND PRE-MITIGATION"]
[null,null,null,"RECREATION TRAILS"]
[null,null,null,"STATE RAILROAD CROSSINGS PROGRAM"]
[null,null,null,"NON-FREEWAY RESURFACING PROGRAM"]
[null,null,null,"CARPOOL PARKING LOT PROGRAM"]
[null,null,null,"BRIDGE - PREVENTIVE MAINTENANCE"]
[null,null,null,"BRIDGE - SPECIAL NEEDS"]
[null,null,null,"BRIDGE - BIG BRIDGE PROGRAM"]
[null,null,null,"PUMP STATION REHABILITATION"]
[null,null,null,"FREEWAY LIGHTING"]
[null,null,null,"SAFE ROUTES TO SCHOOLS"]
[null,null,null,"TRUNKLINE MODERNIZATION"]
[null,null,null,"N/A"]