{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions for Attach 11-2","Part A","Part B","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":32,"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 for Attach 11-2","index":0,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["This report is to be completed by grantees for reporting contract and subcontract activities.     "]
["All contracts/subcontracts must be included. Include only contracts executed during this reporting period. "]
["Submit this report to DOH along with the Attachment 11.1_Semi-Annual Report.   "]
["Enter the prime contractor's ID in item 7f. for all contracts and subcontracts. Include only contracts executed during this reporting period.   "]
["Community Development Block Grant Program"]
["Always start by entering Municipality information in tab \" Part A\", Complete all green highlighted cells "]
["1. Grantee: Enter the name of the unit of government submitting this report."]
["3. Contact Person: Enter name and phone of person responsible for maintaining and submitting contract/subcontract data."]
["7a. Grant Number: Enter the DOH Community Development Block Grant Number (with dashes). For example: B-32-MC-25-0034. "]
["7b. Amount of Contract/Subcontract: Enter the dollar amount rounded to the nearest dollar. If subcontractor ID number is provided in 7f, the dollar figure would be for the subcontract only and not for the prime contract."]
["7c. Type of Trade: Enter the numeric codes which best indicates the contractor's/subcontractor's service. If subcontractor ID number is provided in 7f., the type of trade code would be for the subcontractor only and not for the prime contractor. "]
["The \"other\" category includes supply, professional services and all other activities except construction and education/training activities."]
["7d. Business Racial/Ethnic/Gender Code: Enter the numeric code which indicates the racial/ethnic/gender character of the owner(s) and controller(s) of 51% of the business. "]
["When 51% or more is not owned and controlled by any single racial/ethnic/gender category, enter the code which seems most appropriate. If the subcontractor ID number is provided, the code would apply to the subcontractor and not to the prime contractor."]
["7e. Woman Owned Business: Enter 1=Yes or 2=No."]
["7f. Contractor Identification (ID) Number: Enter the Employer (IRS) Number of the Prime Contractor as the unique identifier for prime recipient of HUD funds. Note that the Employer (IRS) Number must be provided for each contract/subcontract awarded."]
["7g. Section 3 Contractor: Enter 1= Yes or 2=No"]
["7h. Subcontractor Identification (ID) Number: Enter the Employer (IRS) Number of the subcontractor as the unique identifier for each subcontract awarded from HUD funds. When the subcontractor ID Number is provided, the respective Prime Contractor ID Number must also be provided."]
["7i. Designated Small Business: Enter 1=Yes and 2=No for designated contractors."]
["7j. Contractor/Subcontractor Name and Address: Enter this information for each firm receiving contract/subcontract activity only one time on each report for each firm."]
[]
["Revised: "]
["2023-08-16"]

{"sheet":"Part A","index":1,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,12,11,18],[34,9,34,10],[30,3,30,6],[29,3,29,6],[32,3,32,4],[35,3,35,4],[34,3,34,4],[35,9,35,10],[33,9,33,10],[5,0,5,4],[8,0,8,4],[9,10,9,11],[10,10,10,11],[9,0,9,4],[31,9,31,10],[33,3,33,4],[32,9,32,10],[31,3,31,4],[29,9,29,10],[30,9,30,10],[0,2,0,14],[9,5,10,5],[9,8,10,8],[8,6,8,7],[8,9,8,11],[5,14,5,18],[8,16,8,18],[9,12,9,14],[7,0,7,4],[9,6,9,7],[1,0,2,3],[1,6,1,11],[2,9,2,10],[3,9,3,13]]}
[null,null,"Cumulative Contract and Subcontract Activity Report - From Assistance Agreement Executed Date  through This Period"]
["The information is used by DPOH to monitor and evaluate MBE/WBE activities against the total program activity and the designated minority and woman owned business enterprise (m/WBE) goals.  If the information is not collected DOH would not be able to establish meaningful M/WBE performance against these goals. "]
[null,null,null,null,null,null,"Part A                       Program Start Date",null,"to","Select Month/Date",null,"Select Year"]
[null,null,null,null,null,null,null,"*Always start from AA executed date",null,"*From Drop Down Menu, select the ending month and date; next cell select the  year  "]
["1. Grantee",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.  Location (City, State Zip  Code):"]
[]
["1a. Grant#/(SC#): "]
[]
["3a. Name of Contact Person",null,null,null,null,null,"3b. Phone Number (including Area Code) ",null,null,"4. Reporting Period",null,null,"5. Program Code (NA) see note below ",null,null,null,"6. Date Submitted to DOH "]
[null,null,null,null,null,null,null,null,null,null,"January 1 - June 30",null,"Program code is NOT Applicable for CDBG program.  See the explanation Below.  Use a separate sheet for each program code.  ",null,null,null,"Select Month ","Select Date","Select Year"]
[null,null,null,null,null,null,null,null,null,null,"July 1 - December 31"]
["Grant/Project Number or other identification of property, subdivision, dwelling unit, etc.             7a.",null,"Amount of Contract or Subcontact                   7b.","Type of Trade Code             (See below)     7c.","Contractor or Subcontractor Business Racial/Ethnic (See below)      7d.",null,"                                                                                                              Woman Owned Business                   1= Yes  2=No                                                                                                                                                   7e.","Prime Contractor Identification (ID) Number                                                       7f.",null,"Sec.  3   1=Yes  2=No         7g.","Subcontractor Identification (ID) Number                     7h","Small Business Designation   1=Yes  2=No              7i.","Contractor/Subcontractor Name and Address   7j."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,"Street",null,"City","State","Zip"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"7c: Type of Trade Codes:",null,null,null,null,null,"7d:  Racial/Ethnic Codes:"]
[null,null,null,"Housing/Public Housing:",null,null,null,null,null,"1 = White Americans"]
[null,null,null,"1 = New Construction",null,null,"6 = Professional",null,null,"2 = Black Americans"]
[null,null,null,"2 = Substantial Rehab.",null,null,"7 = Tenant Services",null,null,"3 = Native Americans"]
[null,null,null,"3 = Repair",null,null,"8 = Education/Training",null,null,"4 = Hispanic Americans"]
[null,null,null,"4 = Service",null,null,"9 = Arch./Engrg. Appraisal",null,null,"5 = Asian/Pacific Americans"]
[null,null,null,"5 = Project Mangt.",null,null,"0 = Other",null,null,"6 = Hasidic Jews"]
[]
["Revised: "]
[{"$f":"'Instructions for Attach 11-2'!A23","v":"2023-08-16"}]

{"sheet":"Part B","index":2,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[[8,16,8,18],[2,8,2,9],[5,0,5,4],[5,14,5,18],[9,10,9,11],[8,9,8,11],[7,0,7,4],[3,11,3,12],[34,3,34,4],[34,9,34,10],[35,3,35,4],[35,9,35,10],[30,3,30,6],[30,9,30,10],[31,3,31,4],[31,9,31,10],[32,3,32,4],[32,9,32,10],[1,6,1,11],[0,2,0,14],[33,3,33,4],[33,9,33,10],[1,0,2,4],[9,6,9,7],[8,0,8,2],[8,6,8,7],[9,12,9,14],[29,3,29,6],[29,9,29,10],[9,5,10,5],[9,8,10,8],[9,0,9,4],[10,10,10,11],[11,12,11,18]]}
[null,null,"Contract and Subcontract Activity Report - Program Year Start Date (7/1) through This Period"]
["The information is used by DOH to monitor and evaluate MBE/WBE activities against the total program activity and the designated minority and woman-owned business enterprise (M/WBE) goals.  If the information is not collected DOH would not be able to establish meaningful M/WBE goals nor evaluate M/WBE performances against these goals.  "]
[null,null,null,null,null,null,"Part B                       Program Year","7/1/","Select Year",null,"To: ",{"$f":"'Part A'!$J$3","v":"Select Month/Date"},{"$f":"'Part A'!$L$3","v":"Select Year"}]
[null,null,null,null,null,null,null,"*Always from 7/1",null,null,null,"* Use DropDown to select Month Date and Year "]
["1. Grantee Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,"2.  Location (City, State Zip  Code):"]
[{"$f":"IF(ISBLANK('Part A'!$A$6),\"\",'Part A'!$A$6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Part A'!$O$6),\"\",'Part A'!$O$6)","v":""}]
["1a. Grant#/(SC#): "]
[{"$f":"IF(ISBLANK('Part A'!$A$8),\"\",'Part A'!$A$8)","v":""}]
["3a. Name of Contact Person",null,null,null,null,null,"3b. Phone Number (including Area Code) ",null,null,"4. Reporting Period",null,null,"5. Program Code (NA) see note below ",null,null,6,"Date Submitted to DOH "]
[{"$f":"IF(ISBLANK('Part A'!$A$10),\"\",'Part A'!$A$10)","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK('Part A'!$G$10),\"\",'Part A'!$G$10)","v":""},null,null,null,"January 1 - June 30",null,"Program code is NOT Applicable for CDBG program.  See the explanation Below.  Use a separate sheet for each program code.  ",null,null,null,{"$f":"'Part A'!Q10","v":"Select Month "},{"$f":"'Part A'!R10","v":"Select Date"},{"$f":"'Part A'!S10","v":"Select Year"}]
[null,null,null,null,null,null,null,null,null,null,"July 1 - December 31"]
["Grant/Project Number or other identification of property, subdivision, dwelling unit, etc.             7a.",null,"Amount of Contract or Subcontact                   7b.","Type of Trade Code             (See below)     7c.","Contractor or Subcontractor Business Racial/Ethnic (See below)      7d.",null,"                                                                                                              Woman Owned Business                         1 = Yes   2=No                                                                                                                                                   7e.","Prime Contractor Identification (ID) Number                                                       7f.",null,"Sec.  3             1 = Yes   2=No         7g.","Subcontractor Identification (ID) Number                     7h","Small Business Designation        1 = Yes   2=No              7i.","Contractor/Subcontractor Name and Address   7j."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Name",null,"Street",null,"City","State","Zip"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"7c: Type of Trade Codes:",null,null,null,null,null,"7d:  Racial/Ethnic Codes:"]
[null,null,null,"Housing/Public Housing:",null,null,null,null,null,"1 = White Americans"]
[null,null,null,"1 = New Construction",null,null,"6 = Professional",null,null,"2 = Black Americans"]
[null,null,null,"2 = Substantial Rehab.",null,null,"7 = Tenant Services",null,null,"3 = Native Americans"]
[null,null,null,"3 = Repair",null,null,"8 = Education/Training",null,null,"4 = Hispanic Americans"]
[null,null,null,"4 = Service",null,null,"9 = Arch./Engrg. Appraisal",null,null,"5 = Asian/Pacific Americans"]
[null,null,null,"5 = Project Mangt.",null,null,"0 = Other",null,null,"6 = Hasidic Jews"]
[]
["Revised: "]
[{"$f":"'Instructions for Attach 11-2'!A23","v":"2023-08-16"}]

{"sheet":"Sheet1","index":3,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
["12/31/",null,null,"Select Year",null,"Select Month ",null,"Select Date"]
["6/30/",null,null,2018,null,"January ",null,1]
["Select Month/Date",null,null,2019,null,"February",null,2]
[null,null,null,2020,null,"March",null,3]
[null,null,null,2021,null,"April",null,4]
[null,null,null,2022,null,"May",null,5]
[null,null,null,2023,null,"June",null,6]
[null,null,null,2024,null,"July",null,7]
[null,null,null,2025,null,"August",null,8]
[null,null,null,2026,null,"September",null,9]
[null,null,null,2027,null,"October",null,10]
[null,null,null,2028,null,"November",null,11]
[null,null,null,2029,null,"December",null,12]
[null,null,null,2030,null,null,null,13]
[null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,31]