{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Compliance_Activity","Controls"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":22,"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":"Compliance_Activity","index":0,"n_rows":64,"n_cols":12,"rows_kept":64,"cut":false,"hidden":false,"merged":[[38,0,38,5],[27,0,27,8],[26,0,26,8],[63,5,63,9],[43,0,43,13],[46,5,46,8],[48,4,48,9],[53,2,53,13],[54,2,54,13],[55,2,55,13],[57,1,57,2],[33,0,33,1],[2,6,5,8],[21,0,21,8],[17,4,17,6],[18,7,18,8],[16,1,16,2],[16,4,16,6],[10,7,10,11],[16,7,16,8],[7,3,7,4],[7,1,7,2],[5,1,5,5],[6,1,6,5],[10,0,10,5],[18,3,18,6],[0,2,0,8],[39,0,39,1],[11,0,12,5],[11,6,12,8],[16,0,17,0],[14,0,14,13],[16,9,16,11],[17,9,17,11],[18,9,18,11],[19,9,19,11],[16,12,16,13],[15,1,15,2],[29,0,29,3],[19,4,19,6],[32,0,32,5],[1,6,1,8]]}
[null,null,"Contractor Compliance Activity Report"]
["2021 06 01 Ver 1",null,null,null,null,null,"**  COMPLIANCE ERRORS  **"]
[null,null,null,null,null,null,"The project is out of compliance with the goal(s) listed below. For any goal that remains out of compliance, submit documentation on how you attempted to reach that goal. CLICK ON AN ERROR MSG to see the details of that goal in the spreadsheet below."]
[]
["Development Number:"]
["Development Name:"]
["Development Address:"]
["Development County Area:",null,null,{"$f":"IF(Controls!B1=1,\"Greater MN\",IF(Controls!B1=2,\"Metropolitan Area\",\"\"))","v":""}]
["Total Construction Contract Amount:"]
[]
["The information is required to be provided for all contractors (i.e. generals and sub-contractors) who bid on the project."]
["Complete For All Contractors",null,null,null,null,null,"Black, Indigenous, and People of Color-owned Business Enterprise/ Women-owned Business Enterprise Information"]
[]
["Contractor Name & Address","Type of Business / Trade","General or Sub\n(G/S)\n","$ Amt. Of Bid","Contract Awarded\n(Yes/ No)\n","Date of Contract\nIf Awarded\n"," Women-owned Business Enterprise (Yes/No)\n","Black, Indigenous, and People of Color-owned Business Enterprise\n(Yes/No)","Black, Indigenous, and People of Color-owned Business Enterprise Racial/Ethnic Code"]
[]
["Total(s) Where Applicable","Total Bid Amt:",null,0]
["COMPLIANCE TOTALS:","Total Awarded Bid Amt:",null,0," Women-owned Business Enterprise Contract Award Amount:",null,null,0]
[null,null,null,null,"Women-owned Business Enterprise Percentage:",null,null,0]
[null,null,null,"Black, Indigenous, and People of Color-owned Business Enterprise Contract Award Amount:",null,null,null,0]
[null,null,null,null,"Black, Indigenous, and People of Color-owned Business Enterprise Percentage:",null,null,0]
[]
["(Click on CONTRACTOR NAME / ADDRESS to change info)"]
[]
[]
[]
[]
["If you did not meet Minnesota Housing’s Black, Indigenous, and People of Color-owned Business Enterprise and /or Women-owned Business Enterprise contracting goals, please explain your efforts to award contracts to and/or solicit bids from Black, Indigenous, People of Color-owned and/or Women-owned contractors and subcontractors."]
[]
[]
["I certify that this list is complete and accurate. "]
[]
[]
[]
["Owner’s Signature:",null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
["General Contractor’s Signature:",null,null,null,null,null,"Date"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"IMPORTANT CONTRACT COMPLIANCE INFORMATION AND DEFINITIONS"]
[]
[]
[null,"DEFINITIONS:"]
[]
[null,"•","Black, Indigenous, and People of Color-owned Business Enterprise/Women-owned Business Enterprise - Black, Indigenous, or person of color or woman-owned business enterprise (i.e., having 51% ownership in the actual work of the business)"]
[null,"•","Black, Indigenous, and People of Color - member of one of the following racial/ethnic groups:"]
[null,null,"BLACK/AFRICAN AMERICAN (non-Hispanic) - a person having origins in any of the black racial groups of Africa.\nAMERICAN INDIAN or ALASKA NATIVE - a person having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment.\nASIAN - a person having origins in any of the original peoples of the Far East, Southeast Asia, the Indian Subcontinent, for example: Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippines, Thailand and Vietnam.\nNATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER – a person having origins in any of the original peoples of Hawaii, Guam, Samoa or Pacific Islands.\nHISPANIC OR LATINO - a person of Cuban, Mexican, Puerto Rican, South or Central American or other Spanish culture or origin, regardless of race."]
[]
[null,"RACIAL/ETHNIC CODES:"]
[]
[null,null,1,"White",null,3,"American Indian or Alaska Native",null,null,5,null,"Native Hawaiian or Other Pacific Islander"]
[null,null,2,"Black / African American",null,4,"Asian",null,null,6,null,"Hispanic or Latino"]
[]
[]
[null,null,null,null,null," Equal Opportunity Housing/Equal Opportunity Employer  "]

{"sheet":"Controls","index":1,"n_rows":88,"n_cols":32,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
["Greater MN Counties",{"$f":"IFERROR(VLOOKUP(Compliance_Activity!B8,Counties,2,FALSE),\"\")","v":""},"Yes","Federally Funded?",15,"Trades Beg/End Row","Error Count","Error Listbox Selected","Highlighted Error Cell Add Row/Column",null,null,null,null,1,"White",null,null,null,null,null,null,null,null,null,null,null,null,null,"County List","Metro Area"]
["Twin Cities 7 Counties",null,"No",false,0,10,0,0,18,null,null,null,null,2,"Black/African American",null,null,null,null,null,null,null,null,null,"Initial Submittal",false,null,null,"Aitkin",1,null,{"$f":"Compliance_Activity!B8","v":0}]
[null,null,"General",null,null,56,null,null,8,null,null,null,null,3,"American Indian or Alaskan Native",null,null,null,null,null,null,null,null,null,"Final Submittal",false,null,null,"Anoka",2]
[null,null,"Sub",null,null,null,null,null,null,null,null,null,null,4,"Asian",null,null,null,null,null,null,null,null,null,null,null,null,null,"Becker",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Native Hawaiian or Other Pacific Islander",null,null,null,null,null,null,null,null,null,null,false,null,null,"Beltrami",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Hispanic or Latino",null,null,null,null,null,null,null,null,null,null,false,null,null,"Benton",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Big Stone",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blue Earth",1]
["TRADES","# of Bids","# of Sec 3","Low Bid Sec 3","Low Bid Awarded Amt","Sec 3 Awarded Low Bid","Row Number","Sec 3 Contract Row",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brown",1]
["Acoustic Ceiling Tile Installer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carlton",1]
["Asbestos Abatement Worker",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Carver",2]
["Boilermaker",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cass",1]
["Bricklayer, Blocklayer, and Stonemason",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chippewa",1]
["Cabinet Maker and Installer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Chisago",1]
["Carpenter",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clay",1]
["Carpet Layer ",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clearwater",1]
["Soft Floor Coverer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cook",1]
["Cement Finisher",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cottonwood",1]
["Drywall Taper",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Crow Wing",1]
["Electrician",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dakota",2]
["Low Voltage Electrician",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dodge",1]
["Elevator Constructor",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Douglas",1]
["Fence Erector",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faribault",1]
["Fire Sprinkler Fitter",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fillmore",1]
["Furnace Installer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Freeborn",1]
["Glazier",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goodhue",1]
["Heat and Frost Insulator",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grant",1]
["Heavy Equipment Operator",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hennepin",2]
["Insulator",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Houston",1]
["Ironworker",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hubbard",1]
["Laborer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Isanti",1]
["Landscaper",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Itasca",1]
["Lather",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jackson",1]
["Marble Finisher",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kanabec",1]
["Marble Mason",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kandiyohi",1]
["Metal Building Erector",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kittson",1]
["Millwright",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Koochiching",1]
["Overhead Door Installer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lac Qui Parle",1]
["Painter",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lake",1]
["Piledriver",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lake of the Woods",1]
["Plasterer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le Sueur",1]
["Plumber",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lincoln",1]
["Pump Installer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lyon",1]
["Refrigeration Mechanic",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mahnomen",1]
["Roofer and Waterproofer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marshall",1]
["Sheet Metal Worker",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Martin",1]
["Siding Installer",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"McLeod",1]
["Steamfitter",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meeker",1]
["Teledata Technician, Installer, and Wirepuller",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mille Lacs",1]
["Temperature Control Technician",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Morrison",1]
["Terrazo Finisher",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mower",1]
["Terrazzo Mechanic ",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Murray",1]
["Tile Finisher",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nicollet",1]
["Tile Setter ",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nobles",1]
["Truck Driver",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Norman",1]
["Tuckpointer, Caulker and Cleaner",0,0,0,0,"No",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Olmsted",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otter Tail",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pennington",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pine",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pipestone",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Polk",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pope",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ramsey",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Red Lake",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Redwood",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Renville",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rice",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rock",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Roseau",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saint Louis",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Scott",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sherburne",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sibley",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stearns",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steele",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stevens",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Swift",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Todd",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Traverse",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wabasha",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wadena",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Waseca",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Washington",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Watonwan",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wilkin",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winona",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wright",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yellow Medicine",1]