{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","MBE Prime Contractors","MBE Subcontractors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":55,"n_cols":1,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,0,2,12],[48,0,49,12],[41,0,42,12],[51,0,52,12],[4,0,7,12],[21,0,22,12],[24,0,27,12],[19,0,19,12],[46,0,46,12],[11,0,11,12],[37,0,37,12],[3,0,3,12]]}
[]
["FY22 Annual Report Instructions for Completing the \"MBE CONTRACTS INVENTORY\"\nformerly known as the Annual List of MBE Prime Contractors and Subcontractors"]
[]
["**New: A new column has been added to distinguish between credit card or direct voucher transactions and contract awards. This change only affects the MBE Prime Contractors tab, which now includes Column F where only Credit Card or Direct Voucher can be chosen from the drop down box and Column I which is now for contract numbers only."]
["Pursuant to Senate Bill 849, passed during the 2010 General Assembly session and effective October 1, 2010, the Governor's Office of Small, Minority & Women Business Affairs (formerly the Governor's Office of Minority Affairs) is required to include in its annual report certain information on contracts awarded to Minority Business Enterprise prime contractors and subcontractors."]
[]
[]
[]
[]
["MBE Prime Contractors spreadsheet"]
[]
["Number of Unique MBE Prime Contractors: Enter the total number of different MBEs that were awarded prime contracts by the reporting agency."]
[]
["Agency Name: Enter the name of the State Agency reporting data."]
[]
["MBE Prime Contractor Name: Enter the name of each MBE prime contractor awarded a contract by the agency."]
[]
["Prime Contractor MBE Cert. #: For each MBE prime contractor, enter the MDOT MBE certification number. (Format: 00-000)"]
[]
["Prime Contractor MBE Classification: For each MBE prime contractor, enter or select from the drop-down list the MBE classification. (African American, African American Woman,Asian American, Hispanic American, Native American, Woman, African American Woman, Asian Woman, Hispanic Woman, Native American Woman, Disabled, Disadvantaged)"]
[]
["Agency Contract #: For each MBE prime contractor, enter all prime contracts awarded.  *NEW*  To be consistent with SBR Reporting, DO include awards/payments made via corporate credit card or direct voucher.  Choose Credit Card or Direct Voucher from the drop down menu or enter the Agency Contract  #."]
[]
[]
["Contract Description (Procurement Category): For each MBE prime contract, credit card purchase or direct voucher payment, enter or select from the drop-down list the contract description.  For the purpose of this report, the contract description is the procurement category.  Enter the appropriate procurement category: Architectural, Engineering; Construction; Construction Related Service; Maintenance; Service; Supplies & Equipment; IT Service; IT Supplies & Equipment; Human, Cultural, Social, & Educational Service; "]
[]
[]
[]
[]
["Award Amount:  Enter dollar value of award"]
[]
["*NEW* Credit Card, Direct Voucher."]
[]
[]
[]
["MBE Subcontractors spreadsheet"]
[]
["Number of Unique MBE Subcontractors: Enter the total number of different MBEs that were listed as subcontractors on prime contracts awarded by the reporting agency."]
[]
["Agency Name: Enter the name or acronym of the State Agency reporting data."]
[]
["MBE Subcontractor Name: Enter the name of each MBE subcontractor on a prime contract awarded by the agency.  Include the names of MBE subcontractors on contracts awarded to Non-MBE and MBE prime contractors."]
[]
[]
["Subcontractor MBE Cert. #: For each MBE subcontractor, enter the MDOT MBE certification number. (Format: 00-000)"]
[]
["Subcontractor MBE Classification: For each MBE subcontractor, enter or select from the drop-down list the MBE classification. (African American, Asian, Hispanic, Native American, Woman, African American Woman, Asian Woman, Hispanic Woman, Native American Woman, Disabled, Disadvantaged)"]
[]
["Agency Prime Contract #: For each MBE subcontractor, enter the agency's prime contract number for all prime contracts awarded where there were one or more MBE subcontractors."]
[]
[]
["Prime Contract Description (Procurement Category): For each MBE subcontract, enter or select from the drop-down list the prime contract description, as indicated in the MBE Prime Contractors spreadsheet section above."]
[]
[]
["Award Amount:  Enter dollar value of award"]

{"sheet":"MBE Prime Contractors","index":1,"n_rows":23,"n_cols":24,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Minority Business Enterprise MBE Prime Contract Awards Report"]
["For Fiscal Year 2022"]
["Date Submitted:"]
[]
[null,"(List all MBE prime contracts awarded.)"]
["#","Agency Name","MBE Prime Contractor Name","Prime Contractor MBE Cert. #","Prime Contractor MBE Classification (Select from Dropdown)","Credit Card / Direct Voucher (Select ONLY from the Dropdown)","Contract Description  (Procurement Category) (Select from Dropdown)","Award Amount","Contract # \nONLY \n(Please list the contract #, do NOT include Credit Card or Direct Voucher on this line)",null,";;;;;;",null,null,null,null,null,null,null,null,"Dropdown",null,"Dropdown",null,"Dropdown"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"African American",null,"Architectural",null,"Credit Card"]
[{"$f":"+A7+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"African American Woman",null,"Engineering",null,"Direct Voucher"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asian American",null,"Construction"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asian Woman",null,"Construction Related Service"]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hispanic American",null,"Maintenance"]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hispanic Woman",null,"Service"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEMALE",null,null,null,null,"Native American",null,"Supplies & Equipment"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native American Woman",null,"IT Service"]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woman",null,"IT Supplies & Equipment"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disabled",null,"Human, Cultural, Social, & Educational Service"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disadvantaged"]
[12]
[13]
[14]
[15]
[16]
[17]

{"sheet":"MBE Subcontractors","index":2,"n_rows":23,"n_cols":21,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Minority Business Enterprise MBE Subcontract Awards Report"]
["For Fiscal Year 2022"]
["Date submitted:"]
[]
[null,"(List all MBE subcontracts awarded.)"]
["#","Agency Name","MBE Subcontractor Name","Subcontractor MBE Cert. #","Subcontractor MBE Classification (Select from Dropdown)","Agency Prime Contract #","Prime Contract Description (Procurement Category) (Select from Dropdown)","Award Amount",null,null,null,null,null,null,null,null,null,null,"Dropdown",null,"Dropdown"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"African American",null,"Architectural"]
[{"$f":"+A7+1","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"African American Woman",null,"Engineering"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Asian American",null,"Construction"]
[4,null,null,null,null,null,null,null,null,"female",null,null,null,null,null,null,null,null,"Asian Woman",null,"Construction Related Service"]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hispanic American",null,"Maintenance"]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hispanic Woman",null,"Service"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native American",null,"Supplies & Equipment"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native American Woman",null,"IT Service"]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Woman",null,"IT Supplies & Equipment"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disabled",null,"Human, Cultural, Social, & Educational Service"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disadvantaged"]
[12]
[13]
[14]
[15]
[16]
[17]