{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["How To Fix Error Message","Form Instructions","Data Entry","Printed Form"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"How To Fix Error Message","index":0,"n_rows":91,"n_cols":1,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["1.  If you received the below message, follow these instructions."]
[]
[]
[]
[]
[]
[]
["2.  Click \"Yes\""]
["3.  You may receive the below message.  If so, click \"Close\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4.  If you see the below message at the top of this form, follow the below instructions."]
[]
[]
["5.  You may want to print these directions as you will need to close Excel to complete the rest of the instructions."]
["6.  You will need to open \"File Explorer\""]
[]
[]
[]
["Or click on the Windows Icon in the lower left corner of your screen"]
[]
[]
[]
["Scroll down to \"Windows System\" and click the drop-down arrow on the right.  Click on \"File Explorer\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7.  Click on \"Downloads\" on the upper left side of the screen."]
[]
[]
[]
[]
[]
[]
[]
[]
["8.  Under the column \"Name\" right click on \"DBE Final Payment Form\""]
[]
[]
[]
[]
["9.  Click on \"Properties\" at the bottom of the drop-down box"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["10.  In the bottm right-hand corner, under the \"Advanced…\" button, click the box next to \"Unblock\" so that it has a check mark in it.  Then click \"OK\""]

{"sheet":"Form Instructions","index":1,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,0,32,15],[22,0,22,7],[25,0,25,9],[31,0,31,24],[0,0,0,17],[21,0,21,13],[11,0,11,10],[12,0,12,11],[13,0,13,11],[14,0,14,17],[15,0,15,6],[16,0,16,9],[17,0,17,8],[18,0,18,8],[19,0,19,13],[20,0,20,13],[29,0,29,21],[30,0,30,13],[28,0,28,17],[26,0,26,21],[23,0,23,21],[27,0,27,21]]}
["Instructions To Complete DBE Final Payment Form"]
[]
[]
["When you open the spreadsheet, click the \"Enable Content\" button at the top."]
[]
[]
[]
[]
[]
["You will only enter information into the blue sections of the form."]
[]
["1.  Prime Contractor:  Enter the company name of the Prime Contractor for this project."]
["2.  Address, City, State, Zip:  Enter the address of your company including City, State, & Zip Code."]
["3.  Contact Person:  Enter the first & last name of the person MoDOT should contact with questions."]
["4.  Phone:  Enter the phone number of the contact person. Type in phone number without any hyphens. (i.e. 5737514309 & cell will format for you)"]
["5.  Email:  Enter the email address of the contact person."]
["6.  Original Contract Amount:  Enter the total amount of the original contract."]
["7.  Final Contract Amount:  Enter the total amount of the final contract."]
["8.  Contract ID:  Enter the project's contract ID number. (i.e. 230109-D01)"]
["9. Job Number(s):  Enter ALL of the project's job numbers separated by a comma and a space. (i.e. J5S1234, J5S2345)"]
["10. Route(s):  Enter ALL of the routes of the project separated by a comma and a space. (i.e. Route U, Highway 50)"]
["11. County(s):  Enter ALL of the counties of the project separated by a comma and a space. (i.e. Cole, Callaway, Boone)"]
["12. Contract DBE Goal %: Enter the DBE goal listed in the contract"]
["13. DBE Company Name:  Enter the company name of the DBE subcontractor.  List each subcontractor individually. (i.e. One subcontractor per line.  You may enter the same DBE subcontractor twice if they were a manufacturer (100%) and a material supplier (60%)."]
["14. Description of Work Performed: Enter brief description of the work performed by the DBE subcontractor."]
["15. Total $ Amount Paid to DBE:  Enter the total dollar amount paid to the DBE."]
["16. % Applicaple to DBE Goal (100% or 60%):  Click the down arrow to choose from the drop-down box.  Choose 100% for DBE installers, haulers, and manufacurers.  Choose 60% for DBE material suppliers. "]
["17. If DBE Goal is not met, please provide reason below:  Enter a brief description of the reason as to why the DBE goal was not met.  Please add additional pages as needed."]
["18. Once all information is entered into the \"Data Entry\" tab, click on the button \"Go To Printed Form\" which is on the right-hand side of the form."]
["19. If information needs to be revised, click the button \"Return To Data Entry Form\", which is located on the righ-side of the form.  Revise the information needed, then go to Step 18."]
["20. After verifying all information is correct, click the button \"Print To PDF\", which is located on the right-hand side."]
["21.  Add electronic signature at the bottom of the form and save it to your computer.  The form should name the file for you with the contract number job number(s) and the name of the prime contractor."]
["22.  MoDOT RE needs to add their electronic signature if  they concur with the information submitted by the prime contractor."]

{"sheet":"Data Entry","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[10,2,10,3],[28,1,29,3],[28,0,29,0],[17,0,17,1],[27,0,27,5],[18,0,18,1],[19,0,19,1],[20,0,20,1],[23,3,23,4],[21,0,21,1],[22,0,22,1],[25,0,25,5],[31,0,32,0],[31,1,32,3],[0,0,0,5],[3,1,3,2],[4,1,4,2],[5,1,5,2],[7,1,7,2],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
["DBE Final Payment Form"]
["Today's Date",{"$f":"TODAY()","v":"2024-05-22"}]
[]
["Prime Contractor",null,null,"Contract ID"]
["Address, City, State, Zip",null,null,"Job Number(s)"]
["Contact Person",null,null,"Route(s)"]
["Phone",null,null,"County(s)"]
["Email"]
[]
["Original Contract Amt.",null,null,"Contract DBE Goal %"]
["Final Contract Amt.",null,"Final DBE Participation %",null,{"$f":"IFERROR(F24/B10,0)","v":0}]
[]
["DBE Company Name",null,"Description of                                 Work Performed","Total $ Amount                  Paid to DBE","% Applicable to DBE Goal           (100% OR 60%)","Total $ Amt. Applicable to DBE Goal"]
[null,null,null,null,null,{"$f":"D14*E14","v":0}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,"Total DBE Amount =",null,{"$f":"SUM(F14:F23)","v":0}]
["If DBE Goal is not met, please provide explanation below.  (If additional space is needed, please attach additional pages.)"]
[]
[]
["I certify, in accordance with the Disadvantaged Business Enterprise Contract Provisions, I have listed above the DBEs used on this project and the work they performed. The list also shows the actual dollar amount paid to each DBE that is applicable to the percentage participation set forth in the contract."]
["Prime Signature"]
[null,null,null,null,"Date",{"$f":"TODAY()","v":"2024-05-22"}]
[]
["MoDOT RE Signature"]
[null,null,null,null,"Date",{"$f":"TODAY()","v":"2024-05-22"}]
["Rev 05/24",null,null,null,null,"DBEFPF"]

{"sheet":"Printed Form","index":3,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,0,15,1],[0,0,0,5],[3,1,3,2],[3,4,3,5],[4,1,4,2],[4,4,4,5],[5,1,5,2],[5,4,5,5],[6,4,6,5],[7,1,7,2],[12,0,12,1],[13,0,13,1],[14,0,14,1],[10,2,10,3],[25,0,25,5],[21,0,21,1],[22,0,22,1],[23,3,23,4],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[31,0,32,0],[31,1,32,3],[28,1,29,3],[28,0,29,0],[27,0,27,5]]}
["DBE Final Payment Form"]
["Today's Date",{"$f":"TODAY()","v":"2024-05-22"}]
[]
["Prime Contractor",{"$f":"'Data Entry'!B4","v":0},null,"Contract ID",{"$f":"'Data Entry'!E4","v":0}]
["Address, City, State, Zip",{"$f":"'Data Entry'!B5","v":0},null,"Job Number(s)",{"$f":"'Data Entry'!E5","v":0}]
["Contact Person",{"$f":"'Data Entry'!B6","v":0},null,"Route(s)",{"$f":"'Data Entry'!E6","v":0}]
["Phone",{"$f":"'Data Entry'!B7","v":0},null,"County(s)",{"$f":"'Data Entry'!E7","v":0}]
["Email",{"$f":"'Data Entry'!B8","v":0}]
[]
["Original Contract Amt.",{"$f":"'Data Entry'!B10","v":0},null,"Contract DBE Goal %",{"$f":"'Data Entry'!E10","v":0}]
["Final Contract Amt.",{"$f":"'Data Entry'!B11","v":0},"Final DBE ParticIpation %",null,{"$f":"IFERROR(F24/B10,0)","v":0}]
[]
["DBE Company Name",null,"Description of                             Work Performed","Total $ Amount              Paid to DBE","% Applicable to DBE Goal           (100% OR 60%)","Total $ Amt. Applicable to DBE Goal"]
[{"$f":"'Data Entry'!A14","v":0},null,{"$f":"'Data Entry'!C14","v":0},{"$f":"'Data Entry'!D14","v":0},{"$f":"'Data Entry'!E14","v":0},{"$f":"D14*E14","v":0}]
[{"$f":"'Data Entry'!A15","v":0},null,{"$f":"'Data Entry'!C15","v":0},{"$f":"'Data Entry'!D15","v":0},{"$f":"'Data Entry'!E15","v":0},0]
[{"$f":"'Data Entry'!A16","v":0},null,{"$f":"'Data Entry'!C16","v":0},{"$f":"'Data Entry'!D16","v":0},{"$f":"'Data Entry'!E16","v":0},0]
[{"$f":"'Data Entry'!A17","v":0},null,{"$f":"'Data Entry'!C17","v":0},{"$f":"'Data Entry'!D17","v":0},{"$f":"'Data Entry'!E17","v":0},0]
[{"$f":"'Data Entry'!A18","v":0},null,{"$f":"'Data Entry'!C18","v":0},{"$f":"'Data Entry'!D18","v":0},{"$f":"'Data Entry'!E18","v":0},0]
[{"$f":"'Data Entry'!A19","v":0},null,{"$f":"'Data Entry'!C19","v":0},{"$f":"'Data Entry'!D19","v":0},{"$f":"'Data Entry'!E19","v":0},0]
[{"$f":"'Data Entry'!A20","v":0},null,{"$f":"'Data Entry'!C20","v":0},{"$f":"'Data Entry'!D20","v":0},{"$f":"'Data Entry'!E20","v":0},0]
[{"$f":"'Data Entry'!A21","v":0},null,{"$f":"'Data Entry'!C21","v":0},{"$f":"'Data Entry'!D21","v":0},{"$f":"'Data Entry'!E21","v":0},0]
[{"$f":"'Data Entry'!A22","v":0},null,{"$f":"'Data Entry'!C22","v":0},{"$f":"'Data Entry'!D22","v":0},{"$f":"'Data Entry'!E22","v":0},0]
[{"$f":"'Data Entry'!A23","v":0},null,{"$f":"'Data Entry'!C23","v":0},{"$f":"'Data Entry'!D23","v":0},{"$f":"'Data Entry'!E23","v":0},0]
[null,null,null,"Total DBE Amount =",null,{"$f":"SUM(F14:F23)","v":0}]
["If DBE Goal is not met, please provide explanation below.  (If additional space is needed, please attach additional pages.)"]
[{"$f":"'Data Entry'!A26","v":0}]
[]
["I certify, in accordance with the Disadvantaged Business Enterprise Contract Provisions, I have listed above the DBEs used on this project and the work they performed. The list also shows the actual dollar amount paid to each DBE that is applicable to the percentage participation set forth in the contract."]
["Prime Signature"]
[null,null,null,null,"Date",{"$f":"TODAY()","v":"2024-05-22"}]
[null,null,null,null,null,"DBEFPF"]
["MoDOT RE Signature"]
[null,null,null,null,"Date",{"$f":"TODAY()","v":"2024-05-22"}]
["Rev 05/24"]