{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Project Signature Sheet"],"not_rendered":{"charts":0,"images":14,"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":"Instructions","index":0,"n_rows":136,"n_cols":3,"rows_kept":136,"cut":false,"hidden":false,"merged":[[99,2,101,14],[116,2,118,14],[135,2,137,14],[15,2,17,14],[33,2,34,14],[67,2,69,14],[84,2,86,14],[87,2,87,14],[88,2,88,14]]}
[]
[]
[null,"Instructions"]
[]
[null,1,"Upon opening the file - select Enable Content"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,2,"In the Project Signature Sheet tab, navigate to the Sheet Setup section and select required dropdowns.\nTypical values are shown in the following figure. If a Consultant needs to sign, select the number of required consultant signature blocks. Click the Update Sheet button when complete."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,3,"Fill in values for the Job Number, Project Manager and Construction Engineer. Fill out any required information in the Consultant Design Signatures as needed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,4,"In the file index, the File Name should exactly match the file name of the document in ProjectWise. Plan Set files are the only files that should be noted in the section - do not list the Proposal unless you are using this for a Log Project."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,5,"Input the files requiring a signature by a Consultant in the Consultant Design Signatures section. Each Consultant responsible for signatures should have their own section. If a Consultant is only responsible for partial design, they would denote the applicable page numbers they are signing for in the \"Notes\" section of their signature block. Consultants must sign with a DocuSign Digital Seal. In addition, Consultants also need to add their company logo to the left of their digital seal. Note: The Project Signature sheet may need to be unprotected to be able to add in any logo(s).  See the below links for further information.  "]
[]
[]
[null,null,"How to create a Digital Seal"]
[null,null,"MDOT Digital Signatures"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,6,"If you are utilizing this for a Log Job - note the Proposal but put a note that \"Signatures apply to Log of project\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,7,"Sign the applicable signature blocks by right clicking and selecting \"Sign\". Project Managers and Construction Engineers should sign after all Consultant signatures are obtained. Users must have a DocuSign account to sign this form."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,8,"This file is a Contract Document and must be placed in the 6-Letting Plans and Proposal folder in ProjectWise."]

{"sheet":"Project Signature Sheet","index":1,"n_rows":488,"n_cols":36,"rows_kept":488,"cut":false,"hidden":false,"merged":[[417,1,417,3],[55,1,55,3],[7,6,7,14],[7,1,7,3],[9,1,9,3],[10,1,10,3],[32,1,32,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Project Signature Sheet",null,null,null,null,"Sheet Setup"]
[null,null,null,null,null,null,"Number of Plan File Rows Shown",null,null,null,5]
[null,"Contract ID XXXXX-XXXXXX - File Index",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"N/A","N/A","Select","Yes"]
[null,"Plan Files",null,null,null,null,"Model Data Included in Contract?",null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,5,5,"No"]
[null,"File Name","Description","Notes",null,null,"Number of Model Data Rows if Yes",null,null,null,"N/A",null,null,null,null,null,null,null,"File Name","Description","Notes",null,null,null,null,null,null,null,null,null,null,3,2,10,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B13=\"\",\"\",MAX(R$12:R12)+1)","v":""},{"$f":"IFERROR(INDEX($B$13:$B$54,MATCH(ROW()-ROW($T$12),$R$13:$R$54,0)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S13,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S13,$B$13:$D$54,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,4,3,15,15]
[null,null,null,null,null,null,"Consultant Signature Block Required?",null,null,null,"No",null,null,null,null,null,null,{"$f":"IF(B14=\"\",\"\",MAX(R$12:R13)+1)","v":""},{"$f":"IFERROR(INDEX($B$13:$B$54,MATCH(ROW()-ROW($T$12),$R$13:$R$54,0)),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S14,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(S14,$B$13:$D$54,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,5,4,20,20]
[null,null,null,null,null,null,"Number of Consultant Signature Blocks if Yes",null,null,null,"N/A",null,null,null,null,null,null,{"$f":"IF(B15=\"\",\"\",MAX(R$12:R14)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,6,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",MAX(R$12:R15)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,7,6]
[null,null,null,null,null,null,"Number of Representative Signatures Required",null,null,null,2,null,null,null,null,null,null,{"$f":"IF(B17=\"\",\"\",MAX(R$12:R16)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,8,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=\"\",\"\",MAX(R$12:R17)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,9,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",MAX(R$12:R18)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,10,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B20=\"\",\"\",MAX(R$12:R19)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",MAX(R$12:R20)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B22=\"\",\"\",MAX(R$12:R21)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B23=\"\",\"\",MAX(R$12:R22)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B24=\"\",\"\",MAX(R$12:R23)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B25=\"\",\"\",MAX(R$12:R24)+1)","v":""},"","","",null,null,null,null,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B26=\"\",\"\",MAX(R$12:R25)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B27=\"\",\"\",MAX(R$12:R26)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",MAX(R$12:R27)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",MAX(R$12:R28)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",MAX(R$12:R29)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B31=\"\",\"\",MAX(R$12:R30)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B32=\"\",\"\",MAX(R$12:R31)+1)","v":""},"","",""]
[null,"Model Data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,"File Name","Description","Notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",MAX(R$12:R34)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B36=\"\",\"\",MAX(R$12:R35)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B37=\"\",\"\",MAX(R$12:R36)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B38=\"\",\"\",MAX(R$12:R37)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B39=\"\",\"\",MAX(R$12:R38)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"\",\"\",MAX(R$12:R39)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B41=\"\",\"\",MAX(R$12:R40)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",MAX(R$12:R41)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",MAX(R$12:R42)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",MAX(R$12:R43)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",MAX(R$12:R44)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",MAX(R$12:R45)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",MAX(R$12:R46)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",MAX(R$12:R47)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",MAX(R$12:R48)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",MAX(R$12:R49)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B51=\"\",\"\",MAX(R$12:R50)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B52=\"\",\"\",MAX(R$12:R51)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B53=\"\",\"\",MAX(R$12:R52)+1)","v":""},"","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B54=\"\",\"\",MAX(R$12:R53)+1)","v":""},"","",""]
[]
[null,"Consultant Design Signatures"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B59,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B59,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B59,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B60,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B60,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B60,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B83,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B83,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B83,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B84,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B84,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B84,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B107,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B107,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B107,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B108,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B108,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B108,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B131,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B131,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B131,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B132,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B132,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B132,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B155,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B155,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B155,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B156,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B156,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B156,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B179,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B179,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B179,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B180,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B180,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B180,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B203,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B203,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B203,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B204,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B204,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B204,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B227,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B227,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B227,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B228,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B228,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B228,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B251,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B251,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B251,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B252,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B252,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B252,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B275,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B275,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B275,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B276,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B276,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B276,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B299,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B299,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B299,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B300,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B300,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B300,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B323,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B323,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B323,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B324,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B324,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B324,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B347,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B347,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B347,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B348,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B348,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B348,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B371,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B371,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B371,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B372,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B372,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B372,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"File Name","Description","Notes"]
[null,null,{"$f":"IFERROR(VLOOKUP(B395,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B395,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B395,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,{"$f":"IFERROR(VLOOKUP(B396,$B$13:$D$54,2,FALSE),\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(VLOOKUP(B396,$B$13:$D$54,3,FALSE)),\"\",VLOOKUP(B396,$B$13:$D$54,3,FALSE)),\"\")","v":""}]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,null,"",""]
[null,"The listed files have been prepared for the Michigan Department of Transportation by:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[null,null,"Consultant"]
[null,null,"Address"]
[null,null,"Info"]
[]
[null,"Representative Signatures"]
[null,"The above documents are submitted for approval by:"]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Project Manager"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX, Construction Engineer"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]
[]
[]
[]
[]
[]
[]
[null,null,"XXXXXXXXXXXXXXXXXX"]