{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["RID Index","RID Changes_#","RID Additions_#","Auto Fill Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":169,"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","index":0,"n_rows":99,"n_cols":14,"rows_kept":99,"cut":false,"hidden":false,"merged":[[16,1,16,2],[103,9,103,12],[1,9,54,12],[1,1,1,7],[2,1,2,7],[55,9,55,12],[98,1,98,7],[56,9,56,12],[6,3,6,7],[7,3,7,7],[8,3,8,7],[10,3,10,7],[11,3,11,7],[12,3,12,7],[13,3,13,7],[14,3,14,7],[15,3,15,7],[16,3,16,7]]}
[]
[null,"Michigan Department of Transportation",null,null,null,null,null,null,null,"Instructions:  This worksheet is to be prepared by the Design Team and submitted with the RID Documents. \n\nPaste Filenames from ZIP Archive:  The filenames can be copied and pasted by right clicking on the ZIP file and selecting ZIP>Open Archive. Select the files, then press CTRL+C to copy. Paste using CTRL+V  in the area designated in column N. You may then organize by category in the index.\n\nAdd Rows:  Copy and insert a similar row above the blank row in the category to add files to the list.\n\nSort:  After the file names are added to the RID Index use the 'Sort All' Button to sort the file names in each category alphabetically.\n\nVerification: Verify that information contained on this worksheet includes the items identified in the Project Data Requirements Table.xlsx.\n\nFilter: When this form is complete, use the filter in column A to uncheck the \"blanks\" and the form will condense to only show rows with values (noted with a \"y\" in column A). If a row does not show properly, make sure a \"y\" is in column A for that row and apply the filter again.\n\nPrinting: In order to maintain the hyperlinks in this document use the Create PDF command to export a PDF file instead of printing to PDF.  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.\n\nFinal Submittal:  At the time of final turn-in to Specs & Estimates, drag and drop RID files as a ZIP file into the RID folder located under Region > TSC > JN folder > 6 – Letting Plans and Proposal > RID.  The maximum file size for any given ZIP file is 100 MB. If more than one Zip file is needed per package due to size, number sets sequentially. For example: \nXXXXXX _RID_Design1_20YY-MM-DD.zip \nXXXXXX _RID_Design2_20YY-MM-DD.zip\nor\nXXXXXX _RID_Design_20YY-MM-DD.zip\nXXXXXX _RID_Model_Roadway_20YY-MM-DD.zip\nIndicate which zip file the RID Category is located in next to each RID Category.  If multiple zip files are needed for a particular Category like the Models Category copy the Category named row under the Category, delete the Category name, and use the zip file name as a separator between the files that are included in each zip file.\nInclude a pdf copy of the RID_Index.xlsx separately in the RID folder.                                                                                              \n                                                                                                                                                                                                              RID Changes: If changes or updates are required to any of the files included in the RID after the initial publication (during advertisement or after project award), a project change index must be completed. The change index is located in the RID Changes tab and must include the original name as referenced in the initial index as well as the updated name and notes regarding the changes. A C- is placed in front of the original name, and the date is revised to the new upload date. Contact MDOT RID Support to publish these files. Copy & create a new RID Changes tab for each submitted change to the RID.    \n                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    \nRID Additions: If any files are required to be added into the RID after the initial publication (during advertisement or after project award), a RID Additions Index must be completed. The additions index is located in the RID Additions tab and must include the file type and name similar to the original RID Index. Contact RID Support to publish these files. Copy & create a new RID Additions tab for each submitted change to the RID.                                                                                                                                                                                                                             "]
[null,"RID Index"]
[]
[null,"Revision Date:","2020-02-03"]
[null,"Project Information"]
[null,"Region:",null,"Select_a_Region"]
[null,"TSC:",null,"Select_a_TSC"]
[null,"County:",null,"Select_a_County"]
[null,"Control Section:",null,"Select_a_Control_Section"]
[null,"Job Number(s):"]
[null,"Project Location:"]
[null,"Project Description:",null,"Select a Project Description"]
[null,"Design Engineer:"]
[null,"Design Team:"]
[null,"Version of Workspace Used:",null,"Select a Version"]
["Included"]
["y","Alignment Files (A)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip",null,null,null,null,null,null,null,null,null,"Paste Filenames from ZIP > Open Archive Below"]
["y","Horizontal Alignment DGN File:",null,"A-XXXXXX_Align_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"A-113259_Align_M-86_L.dgn"]
["y","Supplemental Horizontal Alignment DGN File:",null,"A-XXXXXX_Align_Roadway_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"A-113259_Align_M-86_NL.dgn"]
["y","Alignment  LandXML File:",null,"A-XXXXXX_LandXML_Geometry_20YY-MM-DD.xml",null,null,null,null,null,null,null,null,null,"A-113259_Profile_M-86_NL.dgn"]
["y","Vertical Alignment DGN File:",null,"A-XXXXXX_Prof_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"D-113259_Topo.dgn"]
["y","Supplemental Alignment Profile DGN File:",null,"A-XXXXXX_Prof_Roadway_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"E-113259_Wetland.dgn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"job259.gpk"]
["y","Bridge Files (B)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Proposed Structure DGN File:",null,"B-XXX_CS_Pr_20YY-MM-DD.dgn"]
["y","Existing Structure DGN File:",null,"B-XXX_CS_Ex_20YY-MM-DD.dgn"]
["y","Asbestos Survey Report:",null,"B-XXX_CS_XXXXXX_Asbestos Survey Report.pdf"]
["y","Existing Bridge Plans Zip File:",null,"B-XXXXXX_Existing Bridge Plans.zip"]
["y"]
["y","Design Files (D)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip",null,null,null,null,null,null,null,null,null,"M-113259_Pr.dtm"]
["y","Construction DGN File:",null,"D-XXXXXX_Const_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"M-113259_Pr.tin"]
["y","Proposed Drainage DGN File:",null,"D-XXXXXX_Drain_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"M-113259_PrCompnt.dgn"]
["y","ITS Construction DGN File:",null,"D-XXXXXX_ITS_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"M-113259_PrLineString_SubSurf_M-86.dgn"]
["y","Lighting Construction DGN File:",null,"D-XXXXXX_Light_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"M-113259_PrLineString_Surf_M-86.dgn"]
["y","Proposed ROW DGN File:",null,"D-XXXXXX_ROW_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"U-113259_Utility.dgn"]
["y","Signing Construction DGN File:",null,"D-XXXXXX_Sign_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"U-113259_Utility.dgn"]
["y","SignCAD Files:",null,"D-XXXXXX_SignCAD.zip"]
["y","Signal Construction DGN File:",null,"D-XXXXXX_Signal_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"X-113259 - XS - 2015-04-17.pdf"]
["y","Existing Topo DGN File:",null,"D-XXXXXX_Topo_20YY-MM-DD.dgn",null,null,null,null,null,null,null,null,null,"X-113259_XS_M-86.dgn"]
["y","GPK File:",null,"jobXXX.gpk",null,null,null,null,null,null,null,null,null,"X-113259_XS_M-86.dgn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"X-113259_XS_M-86_DrWays.dgn"]
["y","Environmental (E)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip",null,null,null,null,null,null,null,null,null,"X-113259_XS_M-86_DrWays.dgn"]
["y","Proposed Environmental DGN File:",null,"E-XXXXXX_Envir_20YY-MM-DD.dgn"]
[]
["y","Geotechnical Files (G)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Geotechnical information not provided in plans",null,"G-XXXXXX_Geotech_20YY-MM-DD.dgn"]
[]
["y","Images (I)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Bridge Pictures:",null,"Folder containing pictures named I-XXXXXX_Bridge"]
["y","Drainage Pictures:",null,"Folder containing pictures named I-XXXXXX_Drainage"]
["y","Roadway Pictures:",null,"Folder containing pictures named I-XXXXXX_Roadway"]
[]
["y","Models (M)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Proposed Roadway Bottom Surface LandXML:",null,"M-XXXXXX_LandXML_PrSubSurf_20YY-MM-DD.XML"]
["y","Proposed Roadway Top Surface LandXML:",null,"M-XXXXXX_LandXML_PrSurf_20YY-MM-DD.XML",null,null,null,null,null,"Website Links:"]
["y","Proposed Triangles LandXML:",null,"M-XXXXXX_LandXML_PrTriangle_20YY-MM-DD.XML",null,null,null,null,null,"Project Data Requirements Table.xlsx"]
["y","Proposed 3D Components: MDOT 01 ONLY",null,"M-XXXXXX_PrCompnt_20YY-MM-DD.dgn"]
["y","Proposed Corridor (All Corridors and Civil Cells)",null,"M-XXXXXX_PrCorridor_20YY-MM-DD.dgn"]
["y","Proposed Corridor Civil Cells:",null,"M-XXXXXX_PrCorridor_CivilCells_20YY-MM-DD.dgn"]
["y","Proposed Roadway Corridor:",null,"M-XXXXXX_PrCorridor_Roadway_20YY-MM-DD.dgn"]
["y","Proposed Roadway Corridor Superelevation:",null,"M-XXXXXX_PrCorridor_Roadway_Super_20YY-MM-DD.dgn"]
["y","Proposed 3D Lines (Top Surface):",null,"M-XXXXXX_PrLineString_Surf_20YY-MM-DD.dgn"]
["y","Proposed 3D Lines (Sub Surface):",null,"M-XXXXXX_PrLineString_SubSurf_20YY-MM-DD.dgn"]
[]
["y","KMZ Quantity Files (Q)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Removal Quantity KMZ File (Project PDF jobs Only)",null,"Q-XXXXXX_Quantities_Removal_20YY-MM-DD.kmz"]
["y","Construction Quantity KMZ File (Project PDF jobs Only)",null,"Q-XXXXXX_Quantities_Construction_20YY-MM-DD.kmz"]
[]
["y","Reports (R)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Alignment Reports",null,"R-XXXXXX_Alignment Name_Report_20YY-MM-DD.pdf"]
["y","Drainage Reports",null,"R-XXXXXX_Drain_Report_20YY-MM-DD.pdf"]
["y","Earthwork Reports",null,"R-XXXXXX_Earth_Report_20YY-MM-DD.pdf"]
[null,"Other Reports",null,"R-XXXXXX_Other_Report_20YY-MM-DD.pdf"]
[]
["y","Survey (S)",null,"XXXXXX_RID_Survey_20YY-MM-DD.zip"]
["y","Alignment DGN FIle:",null,"S-XXXXXX_Align_20YY-MM-DD.dgn"]
["y","Alignment LandXML File:",null,"S-XXXXXX_Align_LandXML_20YY-MM-DD.xml"]
["y","Control Points:",null,"S-XXXXXX_ControlPts_20YY-MM-DD.txt"]
["y","Existing Terrain DGN File:",null,"S-XXXXXX_ExTriangle_20YY-MM-DD.dgn"]
["y","Existing Terrain XML File:",null,"S-XXXXXX_ExTriangle_LandXML_20YY-MM-DD.xml"]
["y","Existing Survey 2D DGN File:",null,"S-XXXXXX_Survey_2D_20YY-MM-DD.dgn"]
["y","Existing Survey 3D DGN File:",null,"S-XXXXXX_Survey_3D_20YY-MM-DD.dgn"]
["y","Survey Info Sheet:",null,"S-XXXXXX_Survey_Info_Sheet_20YY-MM-DD.doc"]
[]
["y","Utilities (U)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Proposed Sanitary DGN File:",null,"U-XXXXXX_Sanitary_20YY-MM-DD.dgn"]
["y","Existing {and Proposed} Utilities DGN File:",null,"U-XXXXXX_Utility_20YY-MM-DD.dgn"]
["y","Proposed Water DGN File:",null,"U-XXXXXX_Water_20YY-MM-DD.dgn"]
[]
["y","Cross-Sections (X)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y","Cross Section DGN File:",null,"X-XXXXXX_XS_roadway_20YY-MM-DD.dgn"]
[]
["y","Miscellaneous (Z)",null,"XXXXXX_RID_Design_20YY-MM-DD.zip"]
["y"]
[]
[]
["y","Note:"]
["y","As stated in the Disclaimer upon entering the e-Proposal system, the Reference Information Documents (RID) are non-contractual items and MDOT does not claim liability with respect to their accuracy; the PDF files of the plans and proposal are the contract items.  The RID files are being provided in their given format only as a courtesy for contractors."]

{"sheet":"RID Changes_#","index":1,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[5,7,12,7],[15,1,15,2],[1,1,1,4],[2,1,2,4],[4,3,4,4],[5,1,5,4]]}
[]
[null,"Michigan Department of Transportation"]
[null,"RID Changes Index"]
[]
[null,"Revision Date:","2016-12-21"]
[null,"Project Information",null,null,null,null,null,"RID Changes: If changes or updates are required to any of the files included in the RID after the initial publication (during advertisement or after project award), a project change index must be completed. The index must include the original name as referenced in the initial index as well as the updated name and notes regarding the changes. A C- is placed in front of the original name, and the date is revised to the new upload date. Contact MDOT RID Support to publish these files. Copy & create a new RID Changes tab for each submitted change to the RID.   "]
[null,"Region:",null,{"$f":"'RID Index'!D7","v":"Select_a_Region"}]
[null,"TSC:",null,{"$f":"'RID Index'!D8","v":"Select_a_TSC"}]
[null,"County:",null,{"$f":"'RID Index'!D9","v":"Select_a_County"}]
[null,"Control Section",null,{"$f":"'RID Index'!D10","v":"Select_a_Control_Section"}]
[null,"Job Number(s):",null,{"$f":"IF(ISBLANK('RID Index'!D11),\" \",'RID Index'!D11)","v":" "}]
[null,"Project Location:",null,{"$f":"IF(ISBLANK('RID Index'!D12),\" \",'RID Index'!D12)","v":" "}]
[null,"Project Description:",null,{"$f":"'RID Index'!D13","v":"Select a Project Description"}]
[null,"Design Engineer:",null,{"$f":"IF(ISBLANK('RID Index'!D14),\" \",'RID Index'!D14)","v":" "}]
[null,"Design Team:",null,{"$f":"IF(ISBLANK('RID Index'!D15),\" \",'RID Index'!D15)","v":" "}]
["Included"]
["y","Changes Made After Advertisement",null,"XXXXXX_RID_Changes_20YY-MM-DD.zip","Comments"]
["n","Original Filename included in Index",null,"C-Insert Original File Name Excluding date_Insert new Date.xxx","Note regarding changes","Instructions"]
["n","D-123456_Const_2016-01-01.dgn",null,"C-D-123456_Const_2016-01-15.dgn","Updates based on addenda 1","Example"]

{"sheet":"RID Additions_#","index":2,"n_rows":89,"n_cols":10,"rows_kept":89,"cut":false,"hidden":false,"merged":[[1,9,6,12],[88,1,88,7],[15,3,15,7],[16,1,16,2],[16,3,16,7],[1,1,1,7],[2,1,2,7]]}
[]
[null,"Michigan Department of Transportation",null,null,null,null,null,null,null,"RID Additions: If any files are required to be added into the RID after the initial publication (during advertisement or after project award), a RID Additions Index must be completed. The additions index must include the file type and name similar to the original RID Index. Contact RID Support to publish these files. Copy & create a new RID Additions tab for each submitted addition to the RID.\n"]
[null,"RID Additions Index"]
[]
[null,"Revision Date:","2016-12-21"]
[null,"Project Information"]
[null,"Region:",null,{"$f":"'RID Index'!D7","v":"Select_a_Region"}]
[null,"TSC:",null,{"$f":"'RID Index'!D8","v":"Select_a_TSC"}]
[null,"County:",null,{"$f":"'RID Index'!D9","v":"Select_a_County"}]
[null,"Control Section:",null,{"$f":"'RID Index'!D10","v":"Select_a_Control_Section"}]
[null,"Job Number(s):",null,{"$f":"IF(ISBLANK('RID Index'!D11),\" \",'RID Index'!D11)","v":" "}]
[null,"Project Location:",null,{"$f":"IF(ISBLANK('RID Index'!D12),\" \",'RID Index'!D12)","v":" "}]
[null,"Project Description:",null,{"$f":"'RID Index'!D13","v":"Select a Project Description"}]
[null,"Design Engineer:",null,{"$f":"IF(ISBLANK('RID Index'!D14),\" \",'RID Index'!D14)","v":" "},{"$f":"IF(ISBLANK('RID Index'!E14),\" \",'RID Index'!E14)","v":" "},{"$f":"IF(ISBLANK('RID Index'!F14),\" \",'RID Index'!F14)","v":" "},{"$f":"IF(ISBLANK('RID Index'!G14),\" \",'RID Index'!G14)","v":" "},{"$f":"IF(ISBLANK('RID Index'!H14),\" \",'RID Index'!H14)","v":" "}]
[null,"Design Team:",null,{"$f":"IF(ISBLANK('RID Index'!D15),\" \",'RID Index'!D15)","v":" "},{"$f":"IF(ISBLANK('RID Index'!E15),\" \",'RID Index'!E15)","v":" "},{"$f":"IF(ISBLANK('RID Index'!F15),\" \",'RID Index'!F15)","v":" "},{"$f":"IF(ISBLANK('RID Index'!G15),\" \",'RID Index'!G15)","v":" "},{"$f":"IF(ISBLANK('RID Index'!H15),\" \",'RID Index'!H15)","v":" "}]
[null,"Version of Workspace Used:",null,{"$f":"'RID Index'!D16:H16","v":"Select a Version"}]
["Included"]
["y","Alignment Files (A)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Horizontal Alignment DGN File:",null,"A-XXXXXX_Align_20YY-MM-DD.dgn"]
["y","Supplemental Horizontal Alignment DGN File:",null,"A-XXXXXX_Align_Roadway_20YY-MM-DD.dgn"]
["y","Alignment  LandXML File:",null,"A-XXXXXX_LandXML_Geometry_20YY-MM-DD.xml"]
["y","Vertical Alignment DGN File:",null,"A-XXXXXX_Prof_20YY-MM-DD.dgn"]
["y","Supplemental Alignment Profile DGN File:",null,"A-XXXXXX_Prof_Roadway_20YY-MM-DD.dgn"]
[]
["y","Design Files (D)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Construction DGN File:",null,"D-XXXXXX_Const_20YY-MM-DD.dgn"]
["y","Proposed Drainage DGN File:",null,"D-XXXXXX_Drain_20YY-MM-DD.dgn"]
["y","ITS Construction DGN File:",null,"D-XXXXXX_ITS_20YY-MM-DD.dgn"]
["y","Lighting Construction DGN File:",null,"D-XXXXXX_Light_20YY-MM-DD.dgn"]
["y","Proposed ROW DGN File:",null,"D-XXXXXX_ROW_20YY-MM-DD.dgn"]
["y","Signing Construction DGN File:",null,"D-XXXXXX_Sign_20YY-MM-DD.dgn"]
["y","Signal Construction DGN File:",null,"D-XXXXXX_Signal_20YY-MM-DD.dgn"]
["y","Existing Topo DGN File:",null,"D-XXXXXX_Topo_20YY-MM-DD.dgn"]
["y","GPK File:",null,"jobXXX.gpk"]
[]
["y","Environmental (E)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Proposed Environmental DGN File:",null,"E-XXXXXX_Envir_20YY-MM-DD.dgn"]
[]
["y","Geotechnical Files (G)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Geotechnical information not provided in plans",null,"G-XXXXXX_Geotech_20YY-MM-DD.dgn"]
[]
["y","Images (I)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Bridge Pictures:",null,"Folder containing pictures named I-XXXXXX_Bridge"]
["y","Drainage Pictures:",null,"Folder containing pictures named I-XXXXXX_Drainage"]
["y","Roadway Pictures:",null,"Folder containing pictures named I-XXXXXX_Roadway"]
[]
["y","Models (M)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Proposed Roadway Bottom Surface LandXML:",null,"M-XXXXXX_LandXML_PrSubSurf_Roadway_20YY-MM-DD.XML"]
["y","Proposed Roadway Top Surface LandXML:",null,"M-XXXXXX_LandXML_PrSurf_Roadway_20YY-MM-DD.XML"]
["y","Proposed Triangles LandXML:",null,"M-XXXXXX_LandXML_PrTriangle_20YY-MM-DD.dgn"]
["y","Proposed 3D Components:",null,"M-XXXXXX_PrCompnt_20YY-MM-DD.dgn"]
["y","Proposed 2D Corridor:",null,"M-XXXXXX_PrCorridor_20YY-MM-DD.dgn"]
["y","Proposed 3D Corridor Civil Cells:",null,"M-XXXXXX_PrCorridor_CivilCells_20YY-MM-DD.dgn"]
["y","Proposed Roadway 3D Corridor:",null,"M-XXXXXX_PrCorridor_Roadway_20YY-MM-DD.dgn"]
["y","Proposed Roadway 3D Corridor Superelevation:",null,"M-XXXXXX_PrCorridor_Roadway_Super_20YY-MM-DD.dgn"]
["y","Proposed 3D Lines (Top Surface):",null,"M-XXXXXX_PrLineString_Surf_Roadway_20YY-MM-DD.dgn"]
["y","Proposed 3D Lines (Top Surface):",null,"M-XXXXXX_PrLineString_Surf_Roadway_20YY-MM-DD.dgn"]
["y","Proposed Triangles Drawing:",null,"M-XXXXXX_PrTriangle_20YY-MM-DD.dgn"]
[]
["y","Reports (R)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Alignment Reports",null,"R-XXXXXX_Alignment Name_Report_20YY-MM-DD.pdf"]
["y","Drainage Reports",null,"R-XXXXXX_Drain_Report_20YY-MM-DD.pdf"]
["y","Earthwork Reports",null,"R-XXXXXX_Earth_Report_20YY-MM-DD.pdf"]
[null,"Other Reports",null,"R-XXXXXX_Other_Report_20YY-MM-DD.pdf"]
[]
["y","Survey (S)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Alignment DGN FIle:",null,"S-XXXXXX_Align_20YY-MM-DD.dgn"]
["y","Alignment LandXML File:",null,"S-XXXXXX_Align_LandXML_20YY-MM-DD.xml"]
["y","Control Points:",null,"S-XXXXXX_ControlPts_20YY-MM-DD.txt"]
["y","Existing Triangles DGN File:",null,"S-XXXXXX_ExTriangle_20YY-MM-DD.dgn"]
["y","Existing Triangles XML File:",null,"S-XXXXXX_ExTriangle_LandXML_20YY-MM-DD.xml"]
["y","Existing Survey 2D DGN File:",null,"S-XXXXXX_Survey_2D_20YY-MM-DD.dgn"]
["y","Existing Survey 3D DGN File:",null,"S-XXXXXX_Survey_3D_20YY-MM-DD.dgn"]
["y","Survey Info Sheet:",null,"S-XXXXXX_Survey_Info_Sheet_20YY-MM-DD.doc"]
[]
["y","Utilities (U)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Proposed Sanitary DGN File:",null,"U-XXXXXX_Sanitary_20YY-MM-DD.dgn"]
["y","Existing {and Proposed} Utilities DGN File:",null,"U-XXXXXX_Utility_20YY-MM-DD.dgn"]
["y","Proposed Water DGN File:",null,"U-XXXXXX_Water_20YY-MM-DD.dgn"]
[]
["y","Cross-Sections (X)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y","Cross Section DGN File:",null,"X-XXXXXX_XS_roadway_20YY-MM-DD.dgn"]
[]
["y","Miscellaneous (Z)",null,"XXXXXX_RID_Additions_20YY-MM-DD.zip"]
["y"]
[]
[]
["y","Note:"]
["y","As stated in the Disclaimer upon entering the e-Proposal system, the Reference Information Documents (RID) are non-contractual items and MDOT does not claim liability with respect to their accuracy; the PDF files of the plans and proposal are the contract items.  The RID files are being provided in their given format only as a courtesy for contractors."]

{"sheet":"Auto Fill Data","index":3,"n_rows":79,"n_cols":84,"rows_kept":79,"cut":false,"hidden":true,"merged":[[88,2,88,3]]}
["Select_a_Region","_Superior_","_North_","_Bay_","_Grand_","_Southwest_","_University_","_Metro_"]
[]
["Select_a_TSC","Select a TSC","Select a TSC","Select a TSC","Select a TSC","Select a TSC","Select a TSC","Select a TSC"]
[null,"_Crystal_Falls","_Alpena","_Bay_City","_Cadillac","_Kalamazoo","_Brighton","_Detroit"]
[null,"_Escanaba","_Gaylord","_Davison","_Grand_Rapids","_Marshall","_Jackson","_Macomb"]
[null,"_Ishpeming","_Traverse_City","_Mt_Pleasant","_Muskegon",null,"_Lansing","_Oakland"]
[null,"_Newberry",null,"_Huron",null,null,null,"_Southfield"]
[null,null,null,null,null,null,null,"_Taylor"]
[]
[null,"Superior Region Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"North Region Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bay Region Counties",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand Region Counties",null,null,null,null,null,null,null,null,null,null,null,null,"Southwest Region Counties",null,null,null,null,null,null,"University Region Counties",null,null,null,null,null,null,null,null,"Metro Region Counties"]
[null,2,7,17,21,22,27,31,36,42,48,49,52,55,66,75,1,4,5,10,15,16,20,24,28,35,40,45,51,57,60,65,68,69,71,72,83,6,9,18,25,26,29,32,37,44,56,73,74,76,77,79,3,8,34,41,43,53,54,59,61,62,64,67,70,11,12,13,14,39,78,80,19,23,30,33,38,46,47,58,81,50,63,82]
["Select_a_County","Alger","Baraga","Chippewa","Delta","Dickinson","Gogebic","Houghton","Iron","Keweenaw","Luce","Mackinac","Marquette","Menominee","Ontonagon","Schoolcraft","Alcona","Alpena","Antrim","Benzie","Charlevoix","Cheboygan","Crawford","Emmet","Grand_Traverse","Iosco","Kalkaska","Leelanau","Manistee","Missaukee","Montmorency","Ogemaw","Oscoda","Otsego","Presque_Isle","Roscommon","Wexford","Arenac","Bay","Clare","Genesee","Gladwin","Gratiot","Huron","Isabella","Lapeer","Midland","Saginaw","Sanilac","Shiawassee","St_Clair","Tuscola","Allegan","Barry","Ionia","Kent","Lake","Mason","Mecosta","Montcalm","Muskegon","Newaygo","Oceana","Osceola","Ottawa","Berrien","Branch","Calhoun","Cass","Kalamazoo","St_Joseph","Van_Buren","Clinton","Eaton","Hillsdale","Ingham","Jackson","Lenawee","Livingston","Monroe","Washtenaw","Macomb","Oakland","Wayne"]
[]
["Select_a_Control_Section",2011,7011,17011,21011,22011,27011,31011,36011,42011,48032,49000,52011,55011,66011,75011,1011,4011,5011,10011,15011,16021,20012,24011,28011,35011,40011,45011,51011,57011,60011,65011,68011,69011,71011,72013,83011,6021,9011,18011,25011,26011,29011,32011,37011,44011,56011,73021,74011,76011,77011,79011,3021,8011,34011,41012,43011,53011,54011,59012,61012,62011,64012,67015,70013,11011,12012,13011,14011,39011,78011,80011,19011,23011,30011,33011,38011,46011,47013,58011,81011,50011,63022,82011]
[null,2021,7012,17012,21021,22012,27021,31012,36021,42012,48033,49021,52021,55012,66012,75021,1012,4012,5012,10012,15012,16022,20014,24012,28012,35012,40012,45012,51012,57012,60012,65021,68012,69013,71021,72014,83012,6031,9012,18021,25031,26012,29012,32012,37012,44012,56021,73031,74012,76012,77012,79031,3023,8012,34021,41013,43012,53021,54012,59021,61022,62014,64014,67016,70014,11012,12021,13012,14022,39013,78012,80012,19021,23012,30012,33014,38021,46012,47014,58021,81012,50012,63031,82021]
[null,2022,7013,17021,21022,22013,27022,31013,36022,42021,48034,49022,52022,55021,66013,75022,1021,4021,5021,10031,15031,16023,20015,24021,28013,35021,40022,45013,51021,57013,60021,65022,68041,69014,71031,72021,83013,6041,9021,18022,25032,26021,29014,32021,37013,44031,56023,73032,74022,76021,77023,79032,3024,8021,34031,41014,43021,53022,54013,59022,61023,62015,64015,67017,70016,11013,12022,13013,14031,39014,78013,80013,19022,23021,30031,33021,38051,46014,47021,58032,81013,50013,63041,82022]
[null,2031,7021,17022,21024,22021,27023,31021,36023,null,48041,49023,52031,55022,66021,75031,1022,4031,5022,10032,15051,16032,20016,24031,28021,35022,40023,45021,51031,57022,60022,65032,68042,69021,71051,72022,83021,6071,9031,18023,25042,26022,29015,32022,37014,44032,56031,73033,74023,76023,77024,79041,3032,8031,34032,41024,43022,53031,54014,59023,61072,62021,64016,67021,70021,11014,12031,13014,14032,39022,78014,80023,19031,23031,30032,33031,38061,46032,47041,58033,81031,50015,63042,82023]
[null,2041,7022,17023,21025,22022,27024,31031,36031,null,48042,49025,52032,55031,66022,75032,1023,4032,5031,10041,15071,16033,20021,24051,28031,35031,40031,45031,51041,57023,60031,65033,null,69022,71071,72023,83022,6072,9032,18024,25072,26031,29016,32031,37015,44043,56032,73051,74031,76024,77031,79042,3033,8032,34033,41025,null,53032,54021,59031,61073,62022,64022,67022,70023,11015,12033,13016,14033,39024,78015,80024,19032,23041,30033,33032,38071,46041,47061,58034,81032,50021,63043,82024]
[null,2042,7023,17032,21031,22023,27031,31041,36051,null,null,49026,52041,55041,66023,75051,1024,null,5051,10042,15091,16041,20022,24071,28041,35032,null,45041,null,57041,null,65041,null,69023,71072,72031,83031,6073,9033,18031,25073,26032,29021,32032,37021,44044,56044,73061,74032,76041,77032,79051,3034,8033,34043,41026,null,53033,54022,59032,61074,62031,64812,67031,70024,11016,12034,13017,14041,39025,78021,80031,19033,23042,30041,33033,38072,46051,47062,58041,81041,50022,63051,82025]
[null,2051,7041,17033,21032,22031,27032,31051,36052,null,null,49031,52042,null,66031,75052,1051,null,5071,null,null,16051,20031,24091,28042,null,null,45071,null,null,null,65051,null,null,71073,72041,83032,6091,9034,18032,25074,null,29022,32051,37022,44061,56045,73062,74061,76061,77033,79052,3035,8034,34044,41027,null,53034,54024,59041,61075,62032,64816,67032,70025,11017,12041,13021,14042,39031,78022,80032,19034,23051,30061,33034,38073,46061,47064,58042,81062,50023,63052,82051]
[null,null,null,17034,21041,22041,27041,31052,null,null,null,49041,52043,null,66032,75061,1052,null,5072,null,null,16081,20032,null,28051,null,null,45072,null,null,null,65052,null,null,71091,72051,83033,6111,9035,18033,25081,null,29031,32091,37031,44063,56051,73063,74062,76062,77041,79061,3041,8041,34061,41029,null,53041,54031,59042,61076,62041,64831,67051,70041,11018,12061,13022,14051,39032,78031,80033,19041,23052,30062,33035,38082,46062,47065,58051,81063,50031,63053,82052]
[null,null,null,17042,21051,22042,27051,null,null,null,null,49042,52055,null,66033,null,null,null,null,null,null,16091,20052,null,28052,null,null,45091,null,null,null,65832,null,null,null,72052,83041,null,9042,18034,25082,null,29041,32092,37032,null,null,73073,74071,null,77051,79062,3042,8042,34062,41031,null,null,54032,59043,61131,null,null,67062,70062,11019,null,13031,14061,39041,78041,80041,19042,23061,30071,33041,38083,46071,47066,58052,81072,50051,63054,82053]
[null,null,null,17043,null,22051,null,null,null,null,null,49071,52061,null,66041,null,null,null,null,null,null,16092,20072,null,28071,null,null,null,null,null,null,null,null,null,null,72061,83042,null,9051,18041,25084,null,29042,null,null,null,null,73075,74072,null,77052,79081,3051,8051,34081,41033,null,null,54041,59044,61151,null,null,67111,70063,11021,null,13032,14062,39042,78042,80042,19043,23063,30091,33042,38101,46072,47082,58053,81073,50052,63071,82061]
[null,null,null,17051,null,null,null,null,null,null,null,49111,52081,null,66042,null,null,null,null,null,null,16093,null,null,28091,null,null,null,null,null,null,null,null,null,null,72071,83051,null,9071,18042,25085,null,null,null,null,null,null,73081,74073,null,77071,79851,3071,8052,null,41042,null,null,null,59045,61152,null,null,67122,70064,11031,null,13033,14081,39051,78051,80051,19052,23064,30832,33043,38102,46074,47121,58071,81074,50061,63081,82062]
[null,null,null,17061,null,null,null,null,null,null,null,49131,52082,null,66051,null,null,null,null,null,null,16111,null,null,null,null,null,null,null,null,null,null,null,null,null,72093,83052,null,9081,null,25091,null,null,null,null,null,null,73091,74081,null,77091,null,3072,8071,null,41043,null,null,null,59051,61153,null,null,null,70081,11041,null,13042,14101,39052,78052,80071,19061,23071,30834,33044,38103,46081,null,58091,81075,50062,63082,82071]
[null,null,null,17062,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72823,83053,null,9091,null,25092,null,null,null,null,null,null,73101,null,null,77111,null,3111,8081,null,41051,null,null,null,59052,61171,null,null,null,70381,11051,null,13043,14121,39081,78054,80072,19062,23072,null,33045,38111,46082,null,58151,81076,50072,63091,82072]
[null,null,null,17063,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83061,null,9101,null,25101,null,null,null,null,null,null,73111,null,null,77112,null,3112,null,null,41061,null,null,null,null,null,null,null,null,70823,11052,null,13044,null,39082,78061,null,19081,23073,null,33051,38131,46101,null,58152,81081,50091,63101,82073]
[null,null,null,17071,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9111,null,25102,null,null,null,null,null,null,73112,null,null,77113,null,null,null,null,41062,null,null,null,null,null,null,null,null,70841,11053,null,13045,null,39102,78062,null,19132,23081,null,33061,38141,46161,null,58171,81082,50092,63102,82081]
[null,null,null,17072,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9811,null,25131,null,null,null,null,null,null,73121,null,null,77132,null,null,null,null,41063,null,null,null,null,null,null,null,null,null,11054,null,13051,null,39103,78081,null,19322,23091,null,33062,38171,null,null,58352,81083,50111,63103,82101]
[null,null,null,17081,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25132,null,null,null,null,null,null,73131,null,null,77191,null,null,null,null,41064,null,null,null,null,null,null,null,null,null,11056,null,13061,null,39121,78812,null,19841,23092,null,33071,38811,null,null,null,81101,50112,63111,82102]
[null,null,null,17082,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73151,null,null,77871,null,null,null,null,41071,null,null,null,null,null,null,null,null,null,11057,null,13062,null,null,78815,null,null,23111,null,33072,38851,null,null,null,81103,50351,63112,82103]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73171,null,null,null,null,null,null,null,41081,null,null,null,null,null,null,null,null,null,11062,null,13073,null,null,null,null,null,23131,null,33081,null,null,null,null,81104,null,63113,82104]
[null,null,null,null,null,null,null,"Select a Version",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73173,null,null,null,null,null,null,null,41101,null,null,null,null,null,null,null,null,null,11071,null,13074,null,null,null,null,null,23151,null,33082,null,null,null,null,81105,null,63131,82105]
[null,null,null,null,null,null,null,"MDOT01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41121,null,null,null,null,null,null,null,null,null,11072,null,13081,null,null,null,null,null,23152,null,33083,null,null,null,null,81121,null,63132,82111]
[null,"Select a Project Description",null,null,null,null,null,"MDOT02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41122,null,null,null,null,null,null,null,null,null,11074,null,13082,null,null,null,null,null,23812,null,33084,null,null,null,null,81132,null,63151,82112]
[null,"ROAD - REHABILITATION AND RECONSTRUCTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41131,null,null,null,null,null,null,null,null,null,11081,null,13083,null,null,null,null,null,null,null,33085,null,null,null,null,null,null,63152,82121]
[null,"ROAD - CAPITAL PREVENTIVE MAINTENANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41132,null,null,null,null,null,null,null,null,null,11091,null,13091,null,null,null,null,null,null,null,33091,null,null,null,null,null,null,63171,82122]
[null,"TRAFFIC & SAFETY - OVERHEAD SIGN STRUCTURES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41133,null,null,null,null,null,null,null,null,null,11101,null,13092,null,null,null,null,null,null,null,33092,null,null,null,null,null,null,63172,82123]
[null,"TRAFFIC & SAFETY - SIGNS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41814,null,null,null,null,null,null,null,null,null,11111,null,13093,null,null,null,null,null,null,null,33171,null,null,null,null,null,null,63173,82124]
[null,"TRAFFIC & SAFETY - PAVEMENT MARKINGS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41842,null,null,null,null,null,null,null,null,null,11112,null,13121,null,null,null,null,null,null,null,33172,null,null,null,null,null,null,63174,82125]
[null,"TRAFFIC & SAFETY - SIGNALS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41843,null,null,null,null,null,null,null,null,null,11113,null,13122,null,null,null,null,null,null,null,33183,null,null,null,null,null,null,63191,82131]
[null,"TRAFFIC & SAFETY - IMPACT ATTENUATORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13131,null,null,null,null,null,null,null,33817,null,null,null,null,null,null,63192,82132]
[null,"TRAFFIC & SAFETY - GUARDRAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13161,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63201,82141]
[null,"TRAFFIC & SAFETY - SAFETY PROGRAMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63821,82142]
[null,"CAPACITY IMPROVEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82143]
[null,"NEW ROADS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82144]
[null,"NOISE ABATEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82151]
[null,"REST AREAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82171]
[null,"RAILROAD CROSSINGS TRUNKLINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82181]
[null,"INTELLIGENT TRANSPORTATION SYSTEMS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82191]
[null,"CONGESTION MITIGATION AND AIR QUALITY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82192]
[null,"PASSING RELIEF LANES (PRL)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82193]
[null,"BRIDGE - REPLACEMENT AND REHAB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82194]
[null,"WETLAND PRE-MITIGATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82195]
[null,"RECREATION TRAILS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82196]
[null,"STATE RAILROAD CROSSINGS PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82211]
[null,"NON-FREEWAY RESURFACING PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82251]
[null,"CARPOOL PARKING LOT PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82252]
[null,"BRIDGE - PREVENTIVE MAINTENANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82271]
[null,"BRIDGE - SPECIAL NEEDS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82291]
[null,"BRIDGE - BIG BRIDGE PROGRAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82292]
[null,"PUMP STATION REHABILITATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82293]
[null,"FREEWAY LIGHTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82312]
[null,"SAFE ROUTES TO SCHOOLS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82371]
[null,"TRUNKLINE MODERNIZATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82394]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82700]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82701]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82702]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82703]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82704]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82705]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82706]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82707]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82708]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82709]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82710]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82711]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82712]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82871]