{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["RID","Instructions","Auto Fill Data"],"not_rendered":{"charts":0,"images":2,"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":"RID","index":0,"n_rows":98,"n_cols":17,"rows_kept":98,"cut":false,"hidden":false,"merged":[[1,0,1,16],[2,0,2,16],[10,1,10,12],[3,1,3,12],[4,1,4,12],[5,1,5,12],[6,1,6,12],[7,1,7,12],[8,1,8,12],[9,1,9,12]]}
[]
["Michigan Department of Transportation"]
["RID Review Checklist"]
[null,"Control Section(s):",null,null,null,null,null,null,null,null,null,null,null,null,"Version Date:","2018-01-17"]
[null,"Job Number(s):",null,null,null,null,null,null,null,null,null,null,null,null,"Version of Workspace Used:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Primary Project Description:"]
[null,"Design Unit (Consultant Firm):",null,null,null,null,null,null,null,null,null,null,null,null,"Project Mainline Lane Miles:"]
[null,"Design Team Lead (Consultant PM):"]
[null,"MDOT Project Manager:",null,null,null,null,null,null,null,null,null,null,null,null,"Comment Legend:","Design Team Comments"]
[null,"Model Reviewers:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Reviewer Comments"]
[null,"Milestone"]
[]
["Date:",null,null,null,null,null,null,null,null,null,null,null,null,"Approval:","Date:"]
[1,"Preliminary","Required Preliminary Files","Project Design Team Checked","Reviewer Checked","OEC","Required OEC Files","Project Design Team Checked","Reviewer Checked","RID","Required RID Files","Project Design Team Checked","Reviewer Checked","Item","Preliminary Comments","OEC Comments","RID Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Alignment Files"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"A-XXXXXX_Align.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"A-XXXXXX_Prof.dgn"]
[null,null,null,null,null,"X","X",null,null,"X","X",null,null,"A-XXXXXX_LandXML_Geometry.xml"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Does the profile match existing at the tie down points"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Do the beginning and end bearings on horizontal curves match the tangents"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Does the alignment labeling on the plans match the DGN files."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Design Files"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_Const.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_Light.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_Sign.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_Signal.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_ITS.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_Drain.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_ROW.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"D-XXXXXX_Topo.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"jobXXX.gpk"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"X-XXXXXX_XS.dgn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"U-XXXXXX_Utility.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"U-XXXXXX_Sanitary.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"U-XXXXXX_Water.dgn"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,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,null,null,null,"Environmental Files"]
[null,null,null,null,null,"X","X",null,null,"X","X",null,null,"E-XXXXXX_Envir.dgn"]
[null,null,null,null,null,"X",null,null,null,"X",null,null,null,"Proposed Environmental DGN Files not included in the plans or proposal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Geotechnical Files"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"G-XXXXXX_Geotech.dgn"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Geotechnical Files not included in the plans or proposal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Model Files"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"MDOT_01 Model Files"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrCompnt.dgn"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"MDOT_02 Model Files"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrCorridor.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrCorridor_CivilCells.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrCorridor_Super.dgn"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"MDOT_01 and MDOT_02 Model Output Files"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrLineString_Surf.dgn\n(Will be checked in Component or Corridor file at Plan Review and OEC)"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrLineString_SubSurf.dgn\n(Will be checked in Component or Corridor file at Plan Review and OEC)"]
[null,null,null,null,null,"X","X",null,null,"X","X",null,null,"M-XXXXXX_PrTriangle.dgn"]
[null,null,null,null,null,null,null,null,null,"X","X",null,null,"M-XXXXXX_LandXML_PrSurf.xml"]
[null,null,null,null,null,null,null,null,null,"X","X",null,null,"M-XXXXXX_LandXML_PrSubSurf.xml"]
[null,null,null,null,null,null,null,null,null,"X","X",null,null,"M-XXXXXX_LandXML_PrTriangle.xml"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Does the template match pavement design or typical section"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Do the detailed grades on the plans match the model for slope and elevation"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Do the cross slopes of the model match the cross slopes in the plans, for example (superelevated areas and transitions)"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Do the lane widths in the model match the plan data"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Do the lane and shoulder taper points match the stations and length on the plans"]
[null,"X",null,null,null,null,null,null,null,"X",null,null,null,"Do the modeled features match the plan labeling"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Are the gore and corridor merge areas modeled correctly"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Are there any significant gaps in the hard surface of the model"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Proposed tie in elevations match existing survey data"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Are the Civil Cells adjusted correctly (SS4 Only)"]
[null,"X",null,null,null,null,null,null,null,"X",null,null,null,"Template drop locations are coincident with key station points (Taper Points, grade transitions,…)"]
[null,null,null,null,null,"X",null,null,null,"X",null,null,null,"All other data files are overlaid on each other to make sure everything lines up"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Reports"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"R-XXXXXX_Drain_Report.pdf"]
[null,"X","X",null,null,null,"X",null,null,"X","X",null,null,"R-XXXXXX_Earth_Report.pdf"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"R-XXXXXX_Other_Report.pdf"]
[null,"X",null,null,null,null,null,null,null,"X",null,null,null,"Drainage Report attached showing all drainage calculations"]
[null,null,null,null,null,"X",null,null,null,"X",null,null,null,"Earthwork Reports generated containing all earthwork calculations"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Other Reports as needed for each roadway"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Survey Data:"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"S-XXXXXX_ControlPts.txt"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"S-XXXXXX_Survey_Info_Sheet.doc"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"S-XXXXXX_Align_ROW.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"S-XXXXXX_Align_LandXML.xml"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"S-XXXXXX_ExTriangle.xml"]
[null,"X","X",null,null,null,"X",null,null,"X","X",null,null,"S-XXXXXX_Survey_2D.dgn"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"S-XXXXXX_Survey_3D.dgn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Geospatial Data"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Data was created with the correct units applied and all files are exported with the same units as the original file.\n(Please make sure that the header on all xml files has linear units of 'foot')"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"International Feet"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Data was created with the correct Horizontal Datum"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"MI - SPC North Zone (2111)"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"MI - SPC Central Zone (2112)"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"MI - SPC South Zone (2113)"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"Data was created with the correct Vertical Datum"]
[null,"X","X",null,null,"X","X",null,null,"X","X",null,null,"NAVD 88"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction / Survey Data"]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Confirm any additional survey data is verified if applicable."]
[null,"X",null,null,null,"X",null,null,null,"X",null,null,null,"Template drop interval / frequency is spaced correctly for the construction application"]
[null,null,null,null,null,"X",null,null,null,"X",null,null,null,"LandXML Files are imported in to a new drawing to verify they have not been shifted or rotated"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Simulated ride quality value is within a value of 15"]

{"sheet":"Instructions","index":1,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
[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 \"√\" 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\nDiscipline Coordination Box:  The default for each box will be blank and the discipline lead will need to select \"√\" when they have included thier RID information and filled out the respective checklist items.  The Project Manager or person compiling the RID files for submittal should select \"N/A\" for the disciplines that do not have a separate lead person.  This box is intended to be used as a coordination tool between each discipline and the Project Manager to make sure the required RID files are included prior to submittal.\n\nVerification: Verify that all of the categories for your project are marked with an \"√\" 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 Review\", \"OEC Review\",  or \"RID Review\" 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.  This form will also display the files that are required at each milestone by pressing the \"Preliminary Files\", \"OEC Files\", or \"RID Files\" buttons.\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 R."]

{"sheet":"Auto Fill Data","index":2,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["MDOT01",null,null,null,null,null,null,null,null,null,null,null,null,"Road"]
["MDOT02",null,null,"ROAD - REHABILITATION AND RECONSTRUCTION",null,null,null,null,null,null,"√",null,"√","Bridge"]
[null,null,null,"ROAD - CAPITAL PREVENTIVE MAINTENANCE",null,null,null,null,null,null,"N/A",null,"N/A","Drainage"]
[null,null,null,"TRAFFIC & SAFETY - OVERHEAD SIGN STRUCTURES",null,null,null,null,null,null,null,null,null,"Traffic Signal"]
[null,null,null,"TRAFFIC & SAFETY - SIGNS",null,null,null,null,null,null,null,null,null,"Signing"]
[null,null,null,"TRAFFIC & SAFETY - PAVEMENT MARKINGS",null,null,null,null,null,null,null,null,null,"Utility"]
[null,null,null,"TRAFFIC & SAFETY - SIGNALS",null,null,null,null,null,null,null,null,null,"Lighting"]
[null,null,null,"TRAFFIC & SAFETY - IMPACT ATTENUATORS",null,null,null,null,null,null,null,null,null,"ITS"]
[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"]