Collection of Information from HUD Lead Hazard Control Grantees

Collection of Information from HUD Lead Hazard Control Granteesto Support a Review of the Federal Dust-lead Standards

Copy_of_Copy_of_LeadClearanceSurvey_Prototype4_3Apr14.xlsm

Collection of Information from HUD Lead Hazard Control Grantees

OMB: 2539-0025

Document [xlsx]
Download: xlsx | pdf

Overview

Start_Here
Central_Control
UNIT_Q


Sheet 1: Start_Here


OHLHB0477-10 <-Grant No. Questionnaire Completion Status-> Not Completed

INSTRUCTIONS FOR QUESTIONNAIRE

To: Grantees receiving Lead Hazard Control funding






QuanTech has been tasked to obtain information about your experience conducting clearance testing on your Lead Hazard Control (LHC) grant. Please answer the questions provided in this Excel workbookbased on your organization’s experience during the last 12 months. If you have any questions, contact either Gary Dewalt, of QuanTech, the questionnaire contractor, at 610-255-5525 or Eugene Pinzer, of HUD’s Office of Healthy Homes and Lead Hazard Control, at 202-402-7685.
OMB Control No. xxxx-xxxx.


Software Requirements


This questionnaire contains a large number of macros and must be run using Excel 2007 or a more recent version of Excel. When the workbook (spreadsheet) is opened, you must give permission to allow the macros to be run if asked by your software. In addition, it is recommended that you do not have any other Excel workbooks open when using this spreadsheet!

General Information on How to Use this Questionnaire


This questionnaire is provided in an email to you and has been specifically configured for your Lead Hazard Control grant (number listed at the top left of this sheet). If the grant number shown is not one that you have, please contact Gary Dewalt for more instructions.
Two sets of questions are provided in this workbook. One set is a "general" question set containing 6 questions. The other set is a dwelling "unit-specific" set of 18 questions.
All questions are answered by clicking on buttons provided throughout this workbook. Direct entries into worksheet cells are not required nor reccomended. You can change the answer to any question by simply going back and clicking the entry button for that question. However, keep in mind that doing so will remove your previous entry for that specific question and the question must be re-answered even if you decided not to change it after your re-clicked an entry button that already had an answer. The workbook is setup to display your data entries as you make them, so you will know immediately if this happens.
This workbook has been pre-populated with up to a maximum of 20 dwelling unit addresses that you have reported as having been completed in OHHLHC's Quarterly Progress Report System. In addition to answering the set of 6 general questions, to complete the questionnaire you must answer the same unit-specific set of 18 questions for each of these unit addresses.


Before You Start


If you have not done so already, please save this questionnaire in a directory of your hard drive that is easily accessible to you and re-open it from that directory before answering any questions. We recommend not changing the name of the file as it has your grant ID embedded within the filename.

Saving the questionnaire


Buttons are provided to save a completed or partially completed questionnaire to your hard drive. These buttons will save the workbook in whatever directory the workbook was originally stored. When all the questions for all units have been answered, these save buttons will append a "_done" tag to the filename providing a clear indication that the file is ready to be emailed back to QuanTech.

Submitting a Completed Questionnaire


Attach the completed workbook to an email and email it to Gary Dewalt at [email protected]

Preparing for Answering Questions


In order to help you prepare to answer the unit specific questions, a "Click here to print question sets" button is provided below so that you can preview the questions you will be answering in this workbook. Clicking this button will print the 2 question sets (one for general questions and one for unit-specific questions) to your default printer. The printed question set is NOT to be used as a markup sheet to submit your answers to QuanTech or HUD. It is only being provided for you to understand the types of information you need to pull from your records to make data entries into this workbook.









Sheet 2: Central_Control


OHLHB0477-10 <-Grant No.
Questionnaire Completion Status-> Not Completed



ANSWER GENERAL QUESTIONS..........

Not Completed <-Current Status



Click the button to the right answer the general questions-------------------->
ANSWER UNIT-SPECIFIC QUESTIONS....

Not Completed <-Current Status



Please provide answers to unit-specific questions on the units listed below.

To print a list of these units, use the "Click here to print unit list" button. Clicking this button will print the address listing shown below to your default printer in a portrait format.

To answer the unit-specific questions for each unit listed in the table below, use the "Answer Unit Questions" button shown under "Questionnaire Access Control" in the row listing each unit address.









Units Selected for Survey Questionnaire
Access Control
Question Completion Status

Address Apt# City State Zip

621 Pasadena Place
Youngstown OH 44502
- not entered -

123 Alabama Lane
Youngstown OH 44502
- not entered -

33 Georgia Avenue 3B Youngstown OH 44502
- not entered -

33 Georgia Avenue 4A Youngstown OH 44502
- not entered -

275 Maryland Place
Youngstown OH 44502
- not entered -

99 Sprint Avenue
Youngstown OH 44502
- not entered -

1313 Developer Lane
Youngstown OH 44502
- not entered -

911 Airport Rd
Youngstown OH 44502
- not entered -

14 Colorado Blvd
Youngstown OH 44502
- not entered -

747 Hanger Street
Youngstown OH 44502
- not entered -

86 Deep Creek Lane
Youngstown OH 44502
- not entered -

2155 Park Place
Youngstown OH 44502
- not entered -

1 Canary Place
Youngstown OH 44502
- not entered -

9 Catalina Lane
Youngstown OH 44502
- not entered -

101 Spotted Dog Rd
Youngstown OH 44502
- not entered -

1 Picture Street
Youngstown OH 44502
- not entered -

44 Gunsmoke Rd
Youngstown OH 44502
- not entered -

38 Caliber Street 2A Youngstown OH 44502
- not entered -

38 Caliber Street 4A Youngstown OH 44502
- not entered -

38 Caliber Street 6A Youngstown OH 44502
- not entered -

Sheet 3: UNIT_Q

This sheet contains questions for the unit shown below




Completion status of entire questionnaire -> Not Completed





Completion status of questions for this unit -> 0 % completed





Questions for: 621 Pasadena Place, Youngstown, OH ,44502

Question Topic Area Your Data Entry
Question 1 Please identify the type of dwelling: - not entered -



Question 2 Please identify the construction date of this unit: - not entered -


Question 3 After conducting lead hazard control in this unit, what cleaning or other procedures did you use to reduce/eliminate remaining lead dust hazards before clearance testing ? - not entered -




















Question 4 Did this unit pass clearance on floors on the FIRST TRY? - not entered -
Question 5 Did this unit pass clearance on floors on the SECOND TRY? - not entered -
Question 6 Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​: - not entered -








Question 7 Please identify the number of FINAL floor dust wipe clearance samples that were collected in this unit: - not entered -
Question 8 Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples: - not entered -


















Question 9 Did this unit pass clearance on windowsills on the FIRST TRY? - not entered -
Question 10 Did this unit pass clearance on windowsills on the SECOND TRY? - not entered -
Question 11 Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES: - not entered -






Question 12 Identify the number of FINAL windowsill dust wipe clearance samples that were collected in this unit: - not entered -
Question 13 Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples: - not entered -


















Question 14 Did this unit pass clearance on window troughs on the FIRST TRY? - not entered -
Question 15 Did this unit pass clearance on window troughs on the SECOND TRY? - not entered -
Question 16 Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES: - not entered -








Question 17 How many FINAL window trough dust wipe clearance samples were collected in this unit ? - not entered -
Question 18 Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples: - not entered -


























File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy