{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Start_Here","Central_Control","GEN_Q","UNIT_Q","G","G_Sort","U","U_Sort","PrintGQs","PrintUQs","GData0","UData0","Question_Macros"],"not_rendered":{"macros":1,"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Start_Here","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"merged":[[1,0,1,4],[3,1,3,4],[4,0,4,4],[5,1,5,4],[6,0,6,4],[7,1,7,4],[8,0,8,4],[9,1,9,4],[10,0,10,4],[11,1,11,4],[12,0,12,4],[13,1,13,4],[14,0,14,4],[15,1,15,4]]}
[null,"OHLHB0477-10","<-Grant No.","Questionnaire Completion Status->",{"$f":"Central_Control!H1","v":"Not Completed"}]
["INSTRUCTIONS FOR QUESTIONNAIRE"]
["To: Grantees receiving Lead Hazard Control funding"]
[null,"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.\nOMB Control No. xxxx-xxxx.  "]
["Software Requirements"]
[null,"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"]
[null,"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.\nTwo 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.\nAll 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.\nThis 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.\n"]
["Before You Start"]
[null,"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"]
[null,"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"]
[null,"Attach the completed workbook to an email and email it to Gary Dewalt at fgdewalt@quantech.com"]
["Preparing for Answering Questions"]
[null,"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":"Central_Control","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"merged":[[0,4,0,6],[3,1,3,7],[5,1,5,7],[6,1,6,7],[7,1,7,7],[7,12,7,13],[11,1,11,5],[11,6,12,6],[11,7,12,7]]}
[null,"OHLHB0477-10","<-Grant No.",null,"Questionnaire Completion Status->",null,null,{"$f":"IF(J1=200,\"Completed\",IF(J1=0,\"Not Completed\",\"Partially Completed\"))","v":"Not Completed"},null,{"$f":"J5+J3","v":0},"<--combined  % of general and unit specific questions"]
[]
["ANSWER GENERAL QUESTIONS..........",null,null,{"$f":"IF(J3=100,\"Completed\",IF(J3=0,\"Not Completed\",\"Partially Completed\"))","v":"Not Completed"},"<-Current Status",{"$nulls":4},{"$f":"GEN_Q!J5","v":0},"<--% of general questions completed"]
[null,"Click the button to the right answer the general questions-------------------->"]
["ANSWER UNIT-SPECIFIC QUESTIONS....",null,null,{"$f":"IF(J5=100,\"Completed\",IF(J5=0,\"Not Completed\",\"Partially Completed\"))","v":"Not Completed"},"<-Current Status",{"$nulls":3},{"$f":"SUM(I14:I33)","v":0},{"$f":"ROUND(100*(I5/L12),0)","v":0},"<--% of unit-specific questions completed"]
[null,"Please provide answers to unit-specific questions on the units listed below."]
[null,"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."]
[null,"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."]
[]
[]
[]
[null,"Units Selected for Survey",{"$nulls":4},"Questionnaire\nAccess Control","Question Completion Status","Complete","%",null,{"$f":"SUM(L14:L33)","v":20},"<-total units in list","Keep This Col!"]
[null,"Address","Apt#","City","State","Zip",null,null,"flag","Complete","UnitID","Unit in List Flag","Displayed Address [block below named UNITS]"]
[null,"621 Pasadena Place",null,"Youngstown","OH",44502,null,{"$f":"IF(J14=0,\"- not entered -\",IF(J14=100,\"Completed\",J14&\" % Completed\"))","v":"- not entered -"},{"$f":"IF(H14=\"Completed\",1,0)","v":0},{"$f":"UData0!D5","v":0},1,{"$f":"IF(TRIM(B14)=\"\",0,1)","v":1},{"$f":"IF(C14=\"\",TRIM(B14)&\", \"&TRIM(D14)&\", \"&TRIM(E14)&\" ,\"&TRIM(F14),TRIM(B14)&\", \"&TRIM(C14)&\", \"&TRIM(D14)&\", \"&TRIM(E14)&\" ,\"&TRIM(F14))","v":"621 Pasadena Place, Youngstown, OH ,44502"},{"$f":"K14","v":1}]
[null,"123 Alabama Lane",null,"Youngstown","OH",44502,null,{"$f":"IF(J15=0,\"- not entered -\",IF(J15=100,\"Completed\",J15&\" % Completed\"))","v":"- not entered -"},{"$f":"IF(H15=\"Completed\",1,0)","v":0},{"$f":"UData0!E5","v":0},2,{"$f":"IF(TRIM(B15)=\"\",0,1)","v":1},{"$f":"IF(C15=\"\",TRIM(B15)&\", \"&TRIM(D15)&\", \"&TRIM(E15)&\" ,\"&TRIM(F15),TRIM(B15)&\", \"&TRIM(C15)&\", \"&TRIM(D15)&\", \"&TRIM(E15)&\" ,\"&TRIM(F15))","v":"123 Alabama Lane, Youngstown, OH ,44502"},{"$f":"K15","v":2}]
[null,"33 Georgia Avenue","3B","Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!F5","v":0},3,1,"33 Georgia Avenue, 3B, Youngstown, OH ,44502",3]
[null,"33 Georgia Avenue","4A","Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!G5","v":0},4,1,"33 Georgia Avenue, 4A, Youngstown, OH ,44502",4]
[null,"275 Maryland Place",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!H5","v":0},5,1,"275 Maryland Place, Youngstown, OH ,44502",5]
[null,"99 Sprint Avenue",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!I5","v":0},6,1,"99 Sprint Avenue, Youngstown, OH ,44502",6]
[null,"1313 Developer Lane",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!J5","v":0},7,1,"1313 Developer Lane, Youngstown, OH ,44502",7]
[null,"911 Airport Rd",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!K5","v":0},8,1,"911 Airport Rd, Youngstown, OH ,44502",8]
[null,"14 Colorado Blvd",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!L5","v":0},9,1,"14 Colorado Blvd, Youngstown, OH ,44502",9]
[null,"747 Hanger Street",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!M5","v":0},10,1,"747 Hanger Street, Youngstown, OH ,44502",10]
[null,"86 Deep Creek Lane",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!N5","v":0},11,1,"86 Deep Creek Lane, Youngstown, OH ,44502",11]
[null,"2155 Park Place",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!O5","v":0},12,1,"2155 Park Place, Youngstown, OH ,44502",12]
[null,"1 Canary Place",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!P5","v":0},13,1,"1 Canary Place, Youngstown, OH ,44502",13]
[null,"9 Catalina Lane",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!Q5","v":0},14,1,"9 Catalina Lane, Youngstown, OH ,44502",14]
[null,"101 Spotted Dog Rd",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!R5","v":0},15,1,"101 Spotted Dog Rd, Youngstown, OH ,44502",15]
[null,"1 Picture Street",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!S5","v":0},16,1,"1 Picture Street, Youngstown, OH ,44502",16]
[null,"44 Gunsmoke Rd",null,"Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!T5","v":0},17,1,"44 Gunsmoke Rd, Youngstown, OH ,44502",17]
[null,"38 Caliber Street","2A","Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!U5","v":0},18,1,"38 Caliber Street, 2A, Youngstown, OH ,44502",18]
[null,"38 Caliber Street","4A","Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!V5","v":0},19,1,"38 Caliber Street, 4A, Youngstown, OH ,44502",19]
[null,"38 Caliber Street","6A","Youngstown","OH",44502,null,"- not entered -",0,{"$f":"UData0!W5","v":0},20,1,"38 Caliber Street, 6A, Youngstown, OH ,44502",20]

{"sheet":"GEN_Q","index":2,"n_rows":120,"n_cols":11,"rows_kept":120,"hidden":true,"merged":[[8,1,8,4],[9,3,9,4],[10,3,10,4],[13,3,13,4],[21,1,30,1],[21,2,30,2],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,1,40,1],[31,2,40,2],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4]]}
[null,"This sheet contains the General Questions",{"$nulls":4},"Admin Use Only Columns (to be hidden from grantees)"]
[]
[null,null,"Completion status of entire questionnaire ->",{"$f":"Central_Control!H1","v":"Not Completed"},null,null,0]
[]
[null,null,"Completion status of general questions ->",{"$f":"IF(G5=18,\"Completed\",J5&\" % completed\")","v":"0 % completed"},null,null,{"$f":"SUM(G11:G43)","v":0},"<--count of 1 flgs",null,{"$f":"ROUND(100*(G5/6),0)","v":0},"<--% of general questions completed"]
[]
[]
[]
[null,"General Questions About Your Lead Hazard Control Grant",{"$nulls":4},"Complete Flgs"]
["Q",null,"Question Topic Area","Your Data Entry"]
[1,{"$f":"\"Question \"&A11","v":"Question 1"},{"$f":"VLOOKUP(A11,GEN,3,FALSE)","v":"Regarding this HUD Lead Hazard Control grant, please indicate your organization type:"},"- not entered -",null,null,{"$f":"IF(D11=\"- not entered -\",0,1)","v":0}]
[{"$nulls":3},"- not entered -"]
[{"$nulls":3},"- not entered -"]
[2,{"$f":"\"Question \"&A14","v":"Question 2"},{"$f":"VLOOKUP(A14,GEN,3,FALSE)","v":"Please indicate the category that best describes your organization:"},"- not entered -",null,null,{"$f":"IF(D14=\"- not entered -\",0,1)","v":0}]
[null,null,{"$f":"VLOOKUP(A15,GEN,3,FALSE)","v":0},"- not entered -"]
[null,null,0,"- not entered -"]
[null,null,0,"- not entered -"]
[null,null,0,"- not entered -"]
[null,null,0,"- not entered -"]
[null,null,0,"- not entered -"]
[null,null,0,"- not entered -"]
[3,{"$f":"\"Question \"&A22","v":"Question 3"},"What triggers recruitment of homes into the grant? ",{"$f":"IF(G_Sort!B22=\"z\",\"- not entered -\",G_Sort!B22)","v":"- not entered -"},null,null,{"$f":"IF(D22=\"- not entered -\",0,1)","v":0}]
[{"$f":"A22+0.02","v":3.02},null,null,{"$f":"IF(G_Sort!B23=\"z\",\"\",G_Sort!B23)","v":""}]
[{"$f":"A23+0.01","v":3.03},null,null,{"$f":"IF(G_Sort!B24=\"z\",\"\",G_Sort!B24)","v":""}]
[{"$f":"A24+0.01","v":{"v":3.0399999999999996,"d":"3.04"}},null,null,{"$f":"IF(G_Sort!B25=\"z\",\"\",G_Sort!B25)","v":""}]
[{"v":3.0499999999999994,"d":"3.05"},null,null,{"$f":"IF(G_Sort!B26=\"z\",\"\",G_Sort!B26)","v":""}]
[{"v":3.059999999999999,"d":"3.06"},null,null,{"$f":"IF(G_Sort!B27=\"z\",\"\",G_Sort!B27)","v":""}]
[{"v":3.069999999999999,"d":"3.07"},null,null,{"$f":"IF(G_Sort!B28=\"z\",\"\",G_Sort!B28)","v":""}]
[{"v":3.0799999999999987,"d":"3.08"},null,null,{"$f":"IF(G_Sort!B29=\"z\",\"\",G_Sort!B29)","v":""}]
[{"v":3.0899999999999985,"d":"3.09"},null,null,{"$f":"IF(G_Sort!B30=\"z\",\"\",G_Sort!B30)","v":""}]
[{"v":3.0999999999999983,"d":"3.10"},null,null,{"$f":"IF(G_Sort!B31=\"z\",\"\",G_Sort!B31)","v":""}]
[4,"Question 4",{"$f":"VLOOKUP(A32,GEN,3,FALSE)","v":"Please rank unit recruitment triggers by frequency with most frequent at the top of the list."},{"$f":"IF(G_Sort!B32=\"z\",\"- not entered -\",G_Sort!B32)","v":"- not entered -"},null,null,{"$f":"IF(D32=\"- not entered -\",0,1)","v":0}]
[{"$f":"A32+0.02","v":4.02},null,null,{"$f":"IF(G_Sort!B33=\"z\",\"\",G_Sort!B33)","v":""}]
[{"$f":"A33+0.01","v":{"v":4.029999999999999,"d":"4.03"}},null,null,{"$f":"IF(G_Sort!B34=\"z\",\"\",G_Sort!B34)","v":""}]
[{"$f":"A34+0.01","v":{"v":4.039999999999999,"d":"4.04"}},null,null,{"$f":"IF(G_Sort!B35=\"z\",\"\",G_Sort!B35)","v":""}]
[{"v":4.049999999999999,"d":"4.05"},null,null,{"$f":"IF(G_Sort!B36=\"z\",\"\",G_Sort!B36)","v":""}]
[{"v":4.059999999999999,"d":"4.06"},null,null,{"$f":"IF(G_Sort!B37=\"z\",\"\",G_Sort!B37)","v":""}]
[{"v":4.0699999999999985,"d":"4.07"},null,null,{"$f":"IF(G_Sort!B38=\"z\",\"\",G_Sort!B38)","v":""}]
[{"v":4.079999999999998,"d":"4.08"},null,null,{"$f":"IF(G_Sort!B39=\"z\",\"\",G_Sort!B39)","v":""}]
[{"v":4.089999999999998,"d":"4.09"},null,null,{"$f":"IF(G_Sort!B40=\"z\",\"\",G_Sort!B40)","v":""},{"$nulls":4},0]
[{"v":4.099999999999998,"d":"4.10"},null,null,{"$f":"IF(G_Sort!B41=\"z\",\"\",G_Sort!B41)","v":""}]
[5,{"$f":"\"Question \"&A42","v":"Question 5"},{"$f":"VLOOKUP(A42,GEN,3,FALSE)","v":"On how many dwelling units have you performed lead hazard control work and clearance testing in the past 12 months?"},"- not entered -",null,null,{"$f":"IF(D42=\"- not entered -\",0,1)","v":0}]
[6,{"$f":"\"Question \"&A43","v":"Question 6"},{"$f":"VLOOKUP(A43,GEN,3,FALSE)","v":"What is the reporting limit of your laboratory for floor lead dust wipe samples in µg/ft² (generally indicated by a less-than sign (<) preceding the laboratory reported result)? "},"- not entered -",null,null,{"$f":"IF(D43=\"- not entered -\",0,1)","v":0}]
{"$rows_empty":32}
[{"$nulls":3},"- not entered -"]
[{"$nulls":3},"- not entered -"]
[]
[]
[]
[]
[{"$nulls":3},"- not entered -"]
{"$rows_empty":30}
[{"$nulls":3},"- not entered -"]
[{"$nulls":3},"- not entered -"]
[]
[]
[]
[]
[]
[{"$nulls":3},"- not entered -"]

{"sheet":"UNIT_Q","index":3,"n_rows":150,"n_cols":11,"rows_kept":150,"merged":[[8,1,8,4],[9,3,9,4],[10,1,16,1],[10,2,16,2],[10,3,16,4],[17,1,23,1],[17,2,23,2],[17,3,23,4],[24,1,36,1],[24,2,36,2],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,1,43,1],[39,2,43,2],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,1,74,1],[45,2,74,2],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,1,80,1],[77,2,80,2],[77,3,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[82,1,111,1],[82,2,111,2],[82,3,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[89,3,89,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[113,3,113,4],[114,1,118,1],[114,2,118,2],[114,3,114,4],[115,3,115,4],[116,3,116,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[120,1,149,1],[120,2,149,2],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[134,3,134,4],[135,3,135,4],[136,3,136,4],[137,3,137,4],[138,3,138,4],[139,3,139,4],[140,3,140,4],[141,3,141,4],[142,3,142,4],[143,3,143,4],[144,3,144,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[148,3,148,4],[149,3,149,4]]}
[null,"This sheet contains questions for the unit shown below",{"$nulls":4},"Admin Use Only Columns (to be hidden from grantees)"]
[]
[null,null,"Completion status of entire questionnaire ->",{"$f":"Central_Control!H1","v":"Not Completed"},{"$nulls":3},"621 Pasadena Place, Youngstown, OH ,44502"]
[]
[null,null,"Completion status of questions for this unit ->",{"$f":"IF(G5=18,\"Completed\",J5&\" % completed\")","v":"0 % completed"},null,null,{"$f":"COUNTIF(G11:G159,1)","v":0},"<--count of 1 flgs",null,{"$f":"ROUND(100*(G5/18),0)","v":0},"<--% of questions completed for this unit"]
[]
[]
[]
[1,{"$f":"\"Questions for: \"&H3","v":"Questions for: 621 Pasadena Place, Youngstown, OH ,44502"},{"$nulls":4},"Complete Flg"]
[null,null,"Question Topic Area","Your Data Entry"]
[1,{"$f":"\"Question \"&A11","v":"Question 1"},{"$f":"VLOOKUP(A11,Uni,3,FALSE)","v":"Please identify the type of dwelling:"},"- not entered -",null,null,{"$f":"IF(D11=\"- not entered -\",0,1)","v":0}]
[{"$f":"A11+0.02","v":1.02},{"$nulls":8},"UnitID=",{"$f":"A9","v":1}]
[{"$f":"A12+0.01","v":1.03}]
[{"$f":"A13+0.01","v":1.04}]
[{"$f":"A14+0.01","v":1.05}]
[{"$f":"A15+0.01","v":1.06}]
[{"$f":"A16+0.01","v":1.07}]
[2,{"$f":"\"Question \"&A18","v":"Question 2"},{"$f":"VLOOKUP(A18,Uni,3,FALSE)","v":"Please identify the construction date of this unit:"},"- not entered -",null,null,{"$f":"IF(D18=\"- not entered -\",0,1)","v":0}]
[{"$f":"A18+0.02","v":2.02}]
[{"$f":"A19+0.01","v":2.03}]
[{"$f":"A20+0.01","v":{"v":2.0399999999999996,"d":"2.04"}}]
[{"$f":"A21+0.01","v":{"v":2.0499999999999994,"d":"2.05"}}]
[{"$f":"A22+0.01","v":{"v":2.059999999999999,"d":"2.06"}}]
[{"$f":"A23+0.01","v":{"v":2.069999999999999,"d":"2.07"}}]
[3,{"$f":"\"Question \"&A25","v":"Question 3"},{"$f":"VLOOKUP(A25,Uni,3,FALSE)","v":"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 ?"},{"$f":"IF(U_Sort!B25=\"z\",\"- not entered -\",U_Sort!B25)","v":"- not entered -"},null,null,{"$f":"IF(D25=\"- not entered -\",0,1)","v":0}]
[{"$f":"A25+0.02","v":3.02},null,null,{"$f":"IF(U_Sort!B26=\"z\",\"\",U_Sort!B26)","v":""}]
[{"$f":"A26+0.01","v":3.03},null,null,{"$f":"IF(U_Sort!B27=\"z\",\"\",U_Sort!B27)","v":""}]
[{"v":3.0399999999999996,"d":"3.04"},null,null,{"$f":"IF(U_Sort!B28=\"z\",\"\",U_Sort!B28)","v":""}]
[{"v":3.0499999999999994,"d":"3.05"},null,null,{"$f":"IF(U_Sort!B29=\"z\",\"\",U_Sort!B29)","v":""}]
[{"v":3.059999999999999,"d":"3.06"},null,null,{"$f":"IF(U_Sort!B30=\"z\",\"\",U_Sort!B30)","v":""}]
[{"v":3.069999999999999,"d":"3.07"},null,null,{"$f":"IF(U_Sort!B31=\"z\",\"\",U_Sort!B31)","v":""}]
[{"v":3.0799999999999987,"d":"3.08"},null,null,{"$f":"IF(U_Sort!B32=\"z\",\"\",U_Sort!B32)","v":""}]
[{"v":3.0899999999999985,"d":"3.09"},null,null,{"$f":"IF(U_Sort!B33=\"z\",\"\",U_Sort!B33)","v":""}]
[{"v":3.0999999999999983,"d":"3.10"},null,null,{"$f":"IF(U_Sort!B34=\"z\",\"\",U_Sort!B34)","v":""}]
[{"v":3.109999999999998,"d":"3.11"},null,null,{"$f":"IF(U_Sort!B35=\"z\",\"\",U_Sort!B35)","v":""}]
[{"v":3.119999999999998,"d":"3.12"},null,null,{"$f":"IF(U_Sort!B36=\"z\",\"\",U_Sort!B36)","v":""}]
[{"v":3.1299999999999977,"d":"3.13"},null,null,{"$f":"IF(U_Sort!B37=\"z\",\"\",U_Sort!B37)","v":""}]
[4,{"$f":"\"Question \"&A38","v":"Question 4"},{"$f":"VLOOKUP(A38,Uni,3,FALSE)","v":"Did this unit pass clearance on floors on the FIRST TRY?"},"- not entered -",null,null,{"$f":"IF(D38=\"- not entered -\",0,1)","v":0}]
[5,{"$f":"\"Question \"&A39","v":"Question 5"},{"$f":"VLOOKUP(A39,Uni,3,FALSE)","v":"Did this unit pass clearance on floors on the SECOND TRY?"},"- not entered -",null,null,{"$f":"IF(D39=\"- not entered -\",0,1)","v":0}]
[6,{"$f":"\"Question \"&A40","v":"Question 6"},{"$f":"VLOOKUP(A40,Uni,3,FALSE)","v":"Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​:"},{"$f":"IF(I40=1,\"- not applicable -\",IF(U_Sort!B40=\"z\",\"- not entered -\",U_Sort!B40))","v":"- not entered -"},null,null,{"$f":"IF(D40=\"- not entered -\",0,1)","v":0},null,0,"<---This cell used to mark display as not applicable"]
[{"$f":"A40+0.02","v":6.02},null,null,{"$f":"IF(U_Sort!B41=\"z\",\"\",U_Sort!B41)","v":""}]
[{"$f":"A41+0.01","v":{"v":6.029999999999999,"d":"6.03"}},null,null,{"$f":"IF(U_Sort!B42=\"z\",\"\",U_Sort!B42)","v":""}]
[{"$f":"A42+0.01","v":6.039999999999999},null,null,{"$f":"IF(U_Sort!B43=\"z\",\"\",U_Sort!B43)","v":""}]
[{"$f":"A43+0.01","v":6.049999999999999},null,null,{"$f":"IF(U_Sort!B44=\"z\",\"\",U_Sort!B44)","v":""}]
[7,{"$f":"\"Question \"&A45","v":"Question 7"},{"$f":"VLOOKUP(A45,Uni,3,FALSE)","v":"Please identify the number of FINAL floor dust wipe clearance samples that were collected in this unit:"},"- not entered -",null,null,{"$f":"IF(D45=\"- not entered -\",0,1)","v":0}]
[8,{"$f":"\"Question \"&A46","v":"Question 8"},{"$f":"VLOOKUP(A46,Uni,3,FALSE)","v":"Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples:"},{"$f":"IF(U_Sort!B46=\"z\",\"- not entered -\",U_Sort!C46 & \" = \"&U_Sort!B46)","v":"- not entered -"},null,null,{"$f":"IF(D46=\"- not entered -\",0,1)","v":0}]
[{"$f":"A46+0.02","v":8.02},null,null,{"$f":"IF(U_Sort!B47=\"z\",\"\",U_Sort!C47 & \" = \"&U_Sort!B47)","v":""}]
[{"$f":"A47+0.01","v":8.03},null,null,{"$f":"IF(U_Sort!B48=\"z\",\"\",U_Sort!C48 & \" = \"&U_Sort!B48)","v":""}]
[8.04,null,null,{"$f":"IF(U_Sort!B49=\"z\",\"\",U_Sort!C49 & \" = \"&U_Sort!B49)","v":""}]
[8.049999999999999,null,null,{"$f":"IF(U_Sort!B50=\"z\",\"\",U_Sort!C50 & \" = \"&U_Sort!B50)","v":""}]
[8.059999999999999,null,null,{"$f":"IF(U_Sort!B51=\"z\",\"\",U_Sort!C51 & \" = \"&U_Sort!B51)","v":""}]
[8.069999999999999,null,null,{"$f":"IF(U_Sort!B52=\"z\",\"\",U_Sort!C52 & \" = \"&U_Sort!B52)","v":""}]
[8.079999999999998,null,null,{"$f":"IF(U_Sort!B53=\"z\",\"\",U_Sort!C53 & \" = \"&U_Sort!B53)","v":""}]
[8.089999999999998,null,null,{"$f":"IF(U_Sort!B54=\"z\",\"\",U_Sort!C54 & \" = \"&U_Sort!B54)","v":""}]
[{"v":8.099999999999998,"d":"8.10"},null,null,{"$f":"IF(U_Sort!B55=\"z\",\"\",U_Sort!C55 & \" = \"&U_Sort!B55)","v":""}]
[8.109999999999998,null,null,{"$f":"IF(U_Sort!B56=\"z\",\"\",U_Sort!C56 & \" = \"&U_Sort!B56)","v":""}]
[8.119999999999997,null,null,{"$f":"IF(U_Sort!B57=\"z\",\"\",U_Sort!C57 & \" = \"&U_Sort!B57)","v":""}]
[8.129999999999997,null,null,{"$f":"IF(U_Sort!B58=\"z\",\"\",U_Sort!C58 & \" = \"&U_Sort!B58)","v":""}]
[8.139999999999997,null,null,{"$f":"IF(U_Sort!B59=\"z\",\"\",U_Sort!C59 & \" = \"&U_Sort!B59)","v":""}]
[8.149999999999997,null,null,{"$f":"IF(U_Sort!B60=\"z\",\"\",U_Sort!C60 & \" = \"&U_Sort!B60)","v":""}]
[8.159999999999997,null,null,{"$f":"IF(U_Sort!B61=\"z\",\"\",U_Sort!C61 & \" = \"&U_Sort!B61)","v":""}]
[8.169999999999996,null,null,{"$f":"IF(U_Sort!B62=\"z\",\"\",U_Sort!C62 & \" = \"&U_Sort!B62)","v":""}]
[8.179999999999996,null,null,{"$f":"IF(U_Sort!B63=\"z\",\"\",U_Sort!C63 & \" = \"&U_Sort!B63)","v":""}]
[8.189999999999996,null,null,{"$f":"IF(U_Sort!B64=\"z\",\"\",U_Sort!C64 & \" = \"&U_Sort!B64)","v":""}]
[{"v":8.199999999999996,"d":"8.20"},null,null,{"$f":"IF(U_Sort!B65=\"z\",\"\",U_Sort!C65 & \" = \"&U_Sort!B65)","v":""}]
[8.209999999999996,null,null,{"$f":"IF(U_Sort!B66=\"z\",\"\",U_Sort!C66 & \" = \"&U_Sort!B66)","v":""}]
[8.219999999999995,null,null,{"$f":"IF(U_Sort!B67=\"z\",\"\",U_Sort!C67 & \" = \"&U_Sort!B67)","v":""}]
[8.229999999999995,null,null,{"$f":"IF(U_Sort!B68=\"z\",\"\",U_Sort!C68 & \" = \"&U_Sort!B68)","v":""}]
[8.239999999999995,null,null,{"$f":"IF(U_Sort!B69=\"z\",\"\",U_Sort!C69 & \" = \"&U_Sort!B69)","v":""}]
[8.249999999999995,null,null,{"$f":"IF(U_Sort!B70=\"z\",\"\",U_Sort!C70 & \" = \"&U_Sort!B70)","v":""}]
[8.259999999999994,null,null,{"$f":"IF(U_Sort!B71=\"z\",\"\",U_Sort!C71 & \" = \"&U_Sort!B71)","v":""}]
[8.269999999999994,null,null,{"$f":"IF(U_Sort!B72=\"z\",\"\",U_Sort!C72 & \" = \"&U_Sort!B72)","v":""}]
[8.279999999999994,null,null,{"$f":"IF(U_Sort!B73=\"z\",\"\",U_Sort!C73 & \" = \"&U_Sort!B73)","v":""}]
[8.289999999999994,null,null,{"$f":"IF(U_Sort!B74=\"z\",\"\",U_Sort!C74 & \" = \"&U_Sort!B74)","v":""}]
[{"v":8.299999999999994,"d":"8.30"},null,null,{"$f":"IF(U_Sort!B75=\"z\",\"\",U_Sort!C75 & \" = \"&U_Sort!B75)","v":""}]
[9,{"$f":"\"Question \"&A76","v":"Question 9"},{"$f":"VLOOKUP(A76,Uni,3,FALSE)","v":"Did this unit pass clearance on windowsills on the FIRST TRY?"},"- not entered -",null,null,{"$f":"IF(D76=\"- not entered -\",0,1)","v":0}]
[10,{"$f":"\"Question \"&A77","v":"Question 10"},{"$f":"VLOOKUP(A77,Uni,3,FALSE)","v":"Did this unit pass clearance on windowsills on the SECOND TRY?"},"- not entered -",null,null,{"$f":"IF(D77=\"- not entered -\",0,1)","v":0}]
[11,{"$f":"\"Question \"&A78","v":"Question 11"},{"$f":"VLOOKUP(A78,Uni,3,FALSE)","v":"Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES: "},{"$f":"IF(I78=1,\"- not applicable -\",IF(U_Sort!B78=\"z\",\"- not entered -\",U_Sort!B78))","v":"- not entered -"},null,null,{"$f":"IF(D78=\"- not entered -\",0,1)","v":0},null,0,"<---This cell used to mark display as not applicable"]
[{"$f":"A78+0.02","v":11.02},null,null,{"$f":"IF(U_Sort!B79=\"z\",\"\",U_Sort!B79)","v":""}]
[{"$f":"A79+0.01","v":11.03},null,null,{"$f":"IF(U_Sort!B80=\"z\",\"\",U_Sort!B80)","v":""}]
[{"$f":"A80+0.01","v":11.04},null,null,{"$f":"IF(U_Sort!B81=\"z\",\"\",U_Sort!B81)","v":""}]
[12,{"$f":"\"Question \"&A82","v":"Question 12"},{"$f":"VLOOKUP(A82,Uni,3,FALSE)","v":"Identify the number of FINAL windowsill dust wipe clearance samples that were collected in this unit:"},"- not entered -",null,null,{"$f":"IF(D82=\"- not entered -\",0,1)","v":0}]
[13,{"$f":"\"Question \"&A83","v":"Question 13"},{"$f":"VLOOKUP(A83,Uni,3,FALSE)","v":"Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples:"},{"$f":"IF(U_Sort!B83=\"z\",\"- not entered -\",U_Sort!C83 & \" = \"&U_Sort!B83)","v":"- not entered -"},null,null,{"$f":"IF(D83=\"- not entered -\",0,1)","v":0}]
[{"$f":"A83+0.02","v":13.02},null,null,{"$f":"IF(U_Sort!B84=\"z\",\"\",U_Sort!C84 & \" = \"&U_Sort!B84)","v":""}]
[{"$f":"A84+0.01","v":13.03},null,null,{"$f":"IF(U_Sort!B85=\"z\",\"\",U_Sort!C85 & \" = \"&U_Sort!B85)","v":""}]
[13.04,null,null,{"$f":"IF(U_Sort!B86=\"z\",\"\",U_Sort!C86 & \" = \"&U_Sort!B86)","v":""}]
[{"v":13.049999999999999,"d":"13.05"},null,null,{"$f":"IF(U_Sort!B87=\"z\",\"\",U_Sort!C87 & \" = \"&U_Sort!B87)","v":""}]
[{"v":13.059999999999999,"d":"13.06"},null,null,{"$f":"IF(U_Sort!B88=\"z\",\"\",U_Sort!C88 & \" = \"&U_Sort!B88)","v":""}]
[{"v":13.069999999999999,"d":"13.07"},null,null,{"$f":"IF(U_Sort!B89=\"z\",\"\",U_Sort!C89 & \" = \"&U_Sort!B89)","v":""}]
[{"v":13.079999999999998,"d":"13.08"},null,null,{"$f":"IF(U_Sort!B90=\"z\",\"\",U_Sort!C90 & \" = \"&U_Sort!B90)","v":""}]
[{"v":13.089999999999998,"d":"13.09"},null,null,{"$f":"IF(U_Sort!B91=\"z\",\"\",U_Sort!C91 & \" = \"&U_Sort!B91)","v":""}]
[{"v":13.099999999999998,"d":"13.10"},null,null,{"$f":"IF(U_Sort!B92=\"z\",\"\",U_Sort!C92 & \" = \"&U_Sort!B92)","v":""}]
[{"v":13.109999999999998,"d":"13.11"},null,null,{"$f":"IF(U_Sort!B93=\"z\",\"\",U_Sort!C93 & \" = \"&U_Sort!B93)","v":""}]
[{"v":13.119999999999997,"d":"13.12"},null,null,{"$f":"IF(U_Sort!B94=\"z\",\"\",U_Sort!C94 & \" = \"&U_Sort!B94)","v":""}]
[{"v":13.129999999999997,"d":"13.13"},null,null,{"$f":"IF(U_Sort!B95=\"z\",\"\",U_Sort!C95 & \" = \"&U_Sort!B95)","v":""}]
[{"v":13.139999999999997,"d":"13.14"},null,null,{"$f":"IF(U_Sort!B96=\"z\",\"\",U_Sort!C96 & \" = \"&U_Sort!B96)","v":""}]
[{"v":13.149999999999997,"d":"13.15"},null,null,{"$f":"IF(U_Sort!B97=\"z\",\"\",U_Sort!C97 & \" = \"&U_Sort!B97)","v":""}]
[{"v":13.159999999999997,"d":"13.16"},null,null,{"$f":"IF(U_Sort!B98=\"z\",\"\",U_Sort!C98 & \" = \"&U_Sort!B98)","v":""}]
[{"v":13.169999999999996,"d":"13.17"},null,null,{"$f":"IF(U_Sort!B99=\"z\",\"\",U_Sort!C99 & \" = \"&U_Sort!B99)","v":""}]
[{"v":13.179999999999996,"d":"13.18"},null,null,{"$f":"IF(U_Sort!B100=\"z\",\"\",U_Sort!C100 & \" = \"&U_Sort!B100)","v":""}]
[{"v":13.189999999999996,"d":"13.19"},null,null,{"$f":"IF(U_Sort!B101=\"z\",\"\",U_Sort!C101 & \" = \"&U_Sort!B101)","v":""}]
[{"v":13.199999999999996,"d":"13.20"},null,null,{"$f":"IF(U_Sort!B102=\"z\",\"\",U_Sort!C102 & \" = \"&U_Sort!B102)","v":""}]
[{"v":13.209999999999996,"d":"13.21"},null,null,{"$f":"IF(U_Sort!B103=\"z\",\"\",U_Sort!C103 & \" = \"&U_Sort!B103)","v":""}]
[{"v":13.219999999999995,"d":"13.22"},null,null,{"$f":"IF(U_Sort!B104=\"z\",\"\",U_Sort!C104 & \" = \"&U_Sort!B104)","v":""}]
[{"v":13.229999999999995,"d":"13.23"},null,null,{"$f":"IF(U_Sort!B105=\"z\",\"\",U_Sort!C105 & \" = \"&U_Sort!B105)","v":""}]
[{"v":13.239999999999995,"d":"13.24"},null,null,{"$f":"IF(U_Sort!B106=\"z\",\"\",U_Sort!C106 & \" = \"&U_Sort!B106)","v":""}]
[{"v":13.249999999999995,"d":"13.25"},null,null,{"$f":"IF(U_Sort!B107=\"z\",\"\",U_Sort!C107 & \" = \"&U_Sort!B107)","v":""}]
[{"v":13.259999999999994,"d":"13.26"},null,null,{"$f":"IF(U_Sort!B108=\"z\",\"\",U_Sort!C108 & \" = \"&U_Sort!B108)","v":""}]
[{"v":13.269999999999994,"d":"13.27"},null,null,{"$f":"IF(U_Sort!B109=\"z\",\"\",U_Sort!C109 & \" = \"&U_Sort!B109)","v":""}]
[{"v":13.279999999999994,"d":"13.28"},null,null,{"$f":"IF(U_Sort!B110=\"z\",\"\",U_Sort!C110 & \" = \"&U_Sort!B110)","v":""}]
[{"v":13.289999999999994,"d":"13.29"},null,null,{"$f":"IF(U_Sort!B111=\"z\",\"\",U_Sort!C111 & \" = \"&U_Sort!B111)","v":""}]
[{"v":13.299999999999994,"d":"13.30"},null,null,{"$f":"IF(U_Sort!B112=\"z\",\"\",U_Sort!C112 & \" = \"&U_Sort!B112)","v":""}]
[14,{"$f":"\"Question \"&A113","v":"Question 14"},{"$f":"VLOOKUP(A113,Uni,3,FALSE)","v":"Did this unit pass clearance on window troughs on the FIRST TRY?"},"- not entered -",null,null,{"$f":"IF(D113=\"- not entered -\",0,1)","v":0}]
[15,{"$f":"\"Question \"&A114","v":"Question 15"},{"$f":"VLOOKUP(A114,Uni,3,FALSE)","v":"Did this unit pass clearance on window troughs on the SECOND TRY?"},"- not entered -",null,null,{"$f":"IF(D114=\"- not entered -\",0,1)","v":0}]
[16,{"$f":"\"Question \"&A115","v":"Question 16"},{"$f":"VLOOKUP(A115,Uni,3,FALSE)","v":"Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES: "},{"$f":"IF(I115=1,\"- not applicable -\",IF(U_Sort!B115=\"z\",\"- not entered -\",U_Sort!B115))","v":"- not entered -"},null,null,{"$f":"IF(D115=\"- not entered -\",0,1)","v":0},null,0,"<---This cell used to mark display as not applicable"]
[{"$f":"A115+0.02","v":16.02},null,null,{"$f":"IF(U_Sort!B116=\"z\",\"\",U_Sort!B116)","v":""}]
[{"$f":"A116+0.01","v":16.03},null,null,{"$f":"IF(U_Sort!B117=\"z\",\"\",U_Sort!B117)","v":""}]
[{"$f":"A117+0.01","v":{"v":16.040000000000003,"d":"16.04"}},null,null,{"$f":"IF(U_Sort!B118=\"z\",\"\",U_Sort!B118)","v":""}]
[{"$f":"A118+0.01","v":{"v":16.050000000000004,"d":"16.05"}},null,null,{"$f":"IF(U_Sort!B119=\"z\",\"\",U_Sort!B119)","v":""}]
[17,{"$f":"\"Question \"&A120","v":"Question 17"},{"$f":"VLOOKUP(A120,Uni,3,FALSE)","v":"How many FINAL window trough dust wipe clearance samples were collected in this unit ?"},"- not entered -",null,null,{"$f":"IF(D120=\"- not entered -\",0,1)","v":0}]
[18,{"$f":"\"Question \"&A121","v":"Question 18"},{"$f":"VLOOKUP(A121,Uni,3,FALSE)","v":"Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples:"},{"$f":"IF(U_Sort!B121=\"z\",\"- not entered -\",U_Sort!C121 & \" = \"&U_Sort!B121)","v":"- not entered -"},null,null,{"$f":"IF(D121=\"- not entered -\",0,1)","v":0}]
[{"$f":"A121+0.02","v":18.02},null,null,{"$f":"IF(U_Sort!B122=\"z\",\"\",U_Sort!C122 & \" = \"&U_Sort!B122)","v":""}]
[{"$f":"A122+0.01","v":18.03},null,null,{"$f":"IF(U_Sort!B123=\"z\",\"\",U_Sort!C123 & \" = \"&U_Sort!B123)","v":""}]
[{"v":18.040000000000003,"d":"18.04"},null,null,{"$f":"IF(U_Sort!B124=\"z\",\"\",U_Sort!C124 & \" = \"&U_Sort!B124)","v":""}]
[{"v":18.050000000000004,"d":"18.05"},null,null,{"$f":"IF(U_Sort!B125=\"z\",\"\",U_Sort!C125 & \" = \"&U_Sort!B125)","v":""}]
[{"v":18.060000000000006,"d":"18.06"},null,null,{"$f":"IF(U_Sort!B126=\"z\",\"\",U_Sort!C126 & \" = \"&U_Sort!B126)","v":""}]
[{"v":18.070000000000007,"d":"18.07"},null,null,{"$f":"IF(U_Sort!B127=\"z\",\"\",U_Sort!C127 & \" = \"&U_Sort!B127)","v":""}]
[{"v":18.08000000000001,"d":"18.08"},null,null,{"$f":"IF(U_Sort!B128=\"z\",\"\",U_Sort!C128 & \" = \"&U_Sort!B128)","v":""}]
[{"v":18.09000000000001,"d":"18.09"},null,null,{"$f":"IF(U_Sort!B129=\"z\",\"\",U_Sort!C129 & \" = \"&U_Sort!B129)","v":""}]
[{"v":18.100000000000012,"d":"18.10"},null,null,{"$f":"IF(U_Sort!B130=\"z\",\"\",U_Sort!C130 & \" = \"&U_Sort!B130)","v":""}]
[{"v":18.110000000000014,"d":"18.11"},null,null,{"$f":"IF(U_Sort!B131=\"z\",\"\",U_Sort!C131 & \" = \"&U_Sort!B131)","v":""}]
[{"v":18.120000000000015,"d":"18.12"},null,null,{"$f":"IF(U_Sort!B132=\"z\",\"\",U_Sort!C132 & \" = \"&U_Sort!B132)","v":""}]
[{"v":18.130000000000017,"d":"18.13"},null,null,{"$f":"IF(U_Sort!B133=\"z\",\"\",U_Sort!C133 & \" = \"&U_Sort!B133)","v":""}]
[{"v":18.14000000000002,"d":"18.14"},null,null,{"$f":"IF(U_Sort!B134=\"z\",\"\",U_Sort!C134 & \" = \"&U_Sort!B134)","v":""}]
[{"v":18.15000000000002,"d":"18.15"},null,null,{"$f":"IF(U_Sort!B135=\"z\",\"\",U_Sort!C135 & \" = \"&U_Sort!B135)","v":""}]
[{"v":18.16000000000002,"d":"18.16"},null,null,{"$f":"IF(U_Sort!B136=\"z\",\"\",U_Sort!C136 & \" = \"&U_Sort!B136)","v":""}]
[{"v":18.170000000000023,"d":"18.17"},null,null,{"$f":"IF(U_Sort!B137=\"z\",\"\",U_Sort!C137 & \" = \"&U_Sort!B137)","v":""}]
[{"v":18.180000000000025,"d":"18.18"},null,null,{"$f":"IF(U_Sort!B138=\"z\",\"\",U_Sort!C138 & \" = \"&U_Sort!B138)","v":""}]
[{"v":18.190000000000026,"d":"18.19"},null,null,{"$f":"IF(U_Sort!B139=\"z\",\"\",U_Sort!C139 & \" = \"&U_Sort!B139)","v":""}]
[{"v":18.200000000000028,"d":"18.20"},null,null,{"$f":"IF(U_Sort!B140=\"z\",\"\",U_Sort!C140 & \" = \"&U_Sort!B140)","v":""}]
[{"v":18.21000000000003,"d":"18.21"},null,null,{"$f":"IF(U_Sort!B141=\"z\",\"\",U_Sort!C141 & \" = \"&U_Sort!B141)","v":""}]
[{"v":18.22000000000003,"d":"18.22"},null,null,{"$f":"IF(U_Sort!B142=\"z\",\"\",U_Sort!C142 & \" = \"&U_Sort!B142)","v":""}]
[{"v":18.230000000000032,"d":"18.23"},null,null,{"$f":"IF(U_Sort!B143=\"z\",\"\",U_Sort!C143 & \" = \"&U_Sort!B143)","v":""}]
[{"v":18.240000000000034,"d":"18.24"},null,null,{"$f":"IF(U_Sort!B144=\"z\",\"\",U_Sort!C144 & \" = \"&U_Sort!B144)","v":""}]
[{"v":18.250000000000036,"d":"18.25"},null,null,{"$f":"IF(U_Sort!B145=\"z\",\"\",U_Sort!C145 & \" = \"&U_Sort!B145)","v":""}]
[{"v":18.260000000000037,"d":"18.26"},null,null,{"$f":"IF(U_Sort!B146=\"z\",\"\",U_Sort!C146 & \" = \"&U_Sort!B146)","v":""}]
[{"v":18.27000000000004,"d":"18.27"},null,null,{"$f":"IF(U_Sort!B147=\"z\",\"\",U_Sort!C147 & \" = \"&U_Sort!B147)","v":""}]
[{"v":18.28000000000004,"d":"18.28"},null,null,{"$f":"IF(U_Sort!B148=\"z\",\"\",U_Sort!C148 & \" = \"&U_Sort!B148)","v":""}]
[{"v":18.290000000000042,"d":"18.29"},null,null,{"$f":"IF(U_Sort!B149=\"z\",\"\",U_Sort!C149 & \" = \"&U_Sort!B149)","v":""}]
[{"$nulls":3},{"$f":"IF(U_Sort!B150=\"z\",\"\",U_Sort!C150 & \" = \"&U_Sort!B150)","v":""}]

{"sheet":"G","index":4,"n_rows":43,"n_cols":13,"rows_kept":43,"hidden":true}
["G.  This sheet holds the text for asking the general (non-unit specific) questions"]
["NOTE:  This sheet will be hidden from grantees"]
[]
[]
[]
[]
[]
["name=GEN"]
["Q #","Form Header Title","Slightly Worded Questions for use inside the \"Unit No.\" Sheet that holds the questions (The displayed entry Form uses the original question) ","Full Question","Pick List options","Code","Notes"]
[0,{"$nulls":5},"not currently used"]
[1,"Who Are You?","Regarding this HUD Lead Hazard Control grant, please indicate your organization type:","Regarding this HUD Lead Hazard Control grant, please indicate (check one) whether your organization is:","a. The grantee",1,{"$nulls":6},"Who Are You?"]
[1.1,{"$nulls":3},"b. A subgrantee",2]
[1.2,{"$nulls":3},"c. A contractor to the grantee or a subgrantee",3]
[2,"Identify Your Organization Type","Please indicate the category that best describes your organization:","Please indicate (check one) the category that best describes your organization:","a. State/local health department",1,{"$nulls":6},"Identify Your Organization Type"]
[2.1,{"$nulls":3},"b. State/local community development, or economic development department",2]
[2.2,{"$nulls":3},"c. State/local community buildings or housing development department",3]
[2.3,{"$nulls":3},"d. Non-governmental organization",4]
[2.4,{"$nulls":3},"e. Certified abatement contractor",5]
[2.5,{"$nulls":3},"f. Certified renovation firm",6]
[2.6,{"$nulls":3},"g. Risk assessment firm",7]
[2.7,{"$nulls":3},"h. Other",8]
[3,"Identify Unit Recruitment Triggers","What triggers recruitment of homes into the grant? ","What triggers recruitment of homes into the grant? (Please check all that apply)","a. Abatement order from a Health Department as a result of a child with an elevated blood lead level",1,{"$nulls":6},"Identify Unit Recruitment Triggers"]
[3.1,{"$nulls":3},"b. Notice from a Health Department of a child with an elevated blood lead level",2]
[3.2,{"$nulls":3},"c. Building code, housing code, or other code violation",3]
[3.3,{"$nulls":3},"d. Combining lead hazard control work with other rehabilitation or modernization work",4]
[3.4,{"$nulls":3},"e. Transfer of ownership or occupancy",5]
[3.5,{"$nulls":3},"f. Lead dust levels in the home are above the lead hazard standards",6]
[3.6,{"$nulls":3},"g. Presence of deteriorated lead-based paint in the home",7]
[3.7,{"$nulls":3},"h. Neighborhood characteristics",8]
[3.8,{"$nulls":3},"i. Outreach and recruiting drives.",9]
[3.9,{"$nulls":3},"j. Other ",10]
[4,"Rank Your Recruitment Triggers","Please rank unit recruitment triggers by frequency with most frequent at the top of the list.","The list below shows your selections on what triggers recruitment of homes. Please rank these triggers by frequency of occurance placing the most frequent trigger at the top and least frequent at the bottom of the list.  To move a trigger, click to highlight it and click the Move UP or Move Down buttons to move it within the List:",null,null,"If you selected more than one trigger in the previous question, please rank the (up to three) most frequent triggers (1 = most frequent trigger, for example, a, or b, or c, etc.).",{"$nulls":5},"Rank Your Recruitment Triggers"]
{"$rows_empty":9}
[5,"Total Numbers of Units Receiving Clearance Testing",{"$f":"D42","v":"On how many dwelling units have you performed lead hazard control work and clearance testing in the past 12 months?"},"On how many dwelling units have you performed lead hazard control work and clearance testing in the past 12 months?",{"$nulls":8},"Total Numbers of Units Receiving Clearance Testing"]
[6,"Identify Your Lab Reporting Limit for Floor Clearance Samples",{"$f":"D43","v":"What is the reporting limit of your laboratory for floor lead dust wipe samples in µg/ft² (generally indicated by a less-than sign (<) preceding the laboratory reported result)? "},"What is the reporting limit of your laboratory for floor lead dust wipe samples in µg/ft² (generally indicated by a less-than sign (<) preceding the laboratory reported result)? ",{"$nulls":8},"Identify Your Lab Reporting Limit for Floor Clearance Samples"]

{"sheet":"G_Sort","index":5,"n_rows":41,"n_cols":7,"rows_kept":41,"hidden":true,"merged":[[2,5,2,6]]}
["G_Sort.  This sheet holds the list of triggers for General question 3 &4; It is filled in by Macro "]
["NOTE:  This sheet will be hidden from grantees"]
[null,"Note : The number in the A col is the number of picks selected (used for storing the data)",{"$nulls":3},"LookupList for Pick Codes: Name=TrigCode"]
{"$rows_empty":9}
[null,"z"]
[null,"z"]
[null,"z"]
[null,"z"]
[null,"z"]
[null,"z"]
[null,"z"]
[null,"z"]
[null,"picks","Codes","1ST Char",null,"Left Char","code"]
[{"$f":"COUNTA(B22:B31)-COUNTIF(B22:B31,\"z\")","v":0},"z",{"$f":"VLOOKUP(D22,TrigCode,2,FALSE)","v":0},{"$f":"LEFT(B22,1)","v":"z"},null,"a",1]
[null,"z",0,"z",null,"b",2]
[null,"z",0,"z",null,"c",3]
[null,"z",0,"z",null,"d",4]
[null,"z",0,"z",null,"e",5]
[null,"z",0,"z",null,"f",6]
[null,"z",0,"z",null,"g",7]
[null,"z",0,"z",null,"h",8]
[null,"z",0,"z",null,"i",9]
[null,"z",0,"z",null,"j",10]
[null,"z",{"$f":"VLOOKUP(D32,TrigCode,2,FALSE)","v":0},{"$f":"LEFT(B32,1)","v":"z"},null,"z",0]
[null,"z",0,{"$f":"LEFT(B33,1)","v":"z"}]
[null,"z",0,"z"]
[null,"z",0,"z"]
[null,"z",0,"z"]
[null,"z",0,"z"]
[null,"z",0,"z"]
[null,"z",0,"z"]
[null,"z",0,"z"]
[null,"z",0,"z"]

{"sheet":"U","index":6,"n_rows":150,"n_cols":9,"rows_kept":150,"hidden":true}
["U.  This sheet holds the text for asking the Unit-specific questions"]
["NOTE:  This sheet will be hidden from grantees"]
[]
[]
[]
[]
[]
["name=Uni",null,"* Unit Address is used for title "]
["Q #","Form Header Title*","Slightly Worded Questions for use inside the \"Unit No.\" Sheet that holds the questions (The displayed entry Form uses the original question) ","Original Question","Pick List options","Code","Notes"]
[0,{"$nulls":5},"not currently used"]
[1,null,"Please identify the type of dwelling:","Please identify the type of dwelling (check one):","a. Detached Single Family House ",1]
[{"$f":"A11+0.02","v":1.02},{"$nulls":3},"b. Duplex/Triplex",2]
[{"$f":"A12+0.01","v":1.03},{"$nulls":3},"c. Row House/Town House",3]
[{"$f":"A13+0.01","v":1.04},{"$nulls":3},"d. Low Rise Apartment (1-3 Floors)",4]
[{"$f":"A14+0.01","v":1.05},{"$nulls":3},"e. High Rise Apartment (>3 Floors)",5]
[{"$f":"A15+0.01","v":1.06},{"$nulls":3},"f. Mobile/Manufactured Home",6]
[{"$f":"A16+0.01","v":1.07},{"$nulls":3},"g. Other",13]
[2,null,"Please identify the construction date of this unit:","Please identify the construction date of this unit (check one):","a. 1990 to Present",1]
[{"$f":"A18+0.02","v":2.02},{"$nulls":3},"b. Between 1978 and 1989",2]
[{"$f":"A19+0.01","v":2.03},{"$nulls":3},"c. Between 1960 and 1977",3]
[{"$f":"A20+0.01","v":{"v":2.0399999999999996,"d":"2.04"}},{"$nulls":3},"d. Between 1946 and 1959",4]
[{"$f":"A21+0.01","v":{"v":2.0499999999999994,"d":"2.05"}},{"$nulls":3},"e. Between 1940 and 1945",5]
[{"$f":"A22+0.01","v":{"v":2.059999999999999,"d":"2.06"}},{"$nulls":3},"f. 1939 or Before",6]
[{"$f":"A23+0.01","v":{"v":2.069999999999999,"d":"2.07"}},{"$nulls":3},"g. Don’t Know",7]
[3,null,"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 ?","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 (check all that apply)?\"","a. HEPA vacuuming",1]
[{"$f":"A25+0.02","v":3.02},{"$nulls":3},"b. HEPA/Wet wash/HEPA cycle",2]
[{"$f":"A26+0.01","v":3.03},{"$nulls":3},"c. Wet detergent wash using trisodium phosphate ",3]
[{"v":3.0399999999999996,"d":"3.04"},{"$nulls":3},"d. Wet detergent wash using a general purpose cleaner",4]
[{"v":3.0499999999999994,"d":"3.05"},{"$nulls":3},"e. Seal flooring",5]
[{"v":3.059999999999999,"d":"3.06"},{"$nulls":3},"f. Overlay flooring",6]
[{"v":3.069999999999999,"d":"3.07"},{"$nulls":3},"g. Replace flooring",7]
[{"v":3.0799999999999987,"d":"3.08"},{"$nulls":3},"h. Seal windowsills",8]
[{"v":3.0899999999999985,"d":"3.09"},{"$nulls":3},"i. Seal window troughs",9]
[{"v":3.0999999999999983,"d":"3.10"},{"$nulls":3},"j. Install window trough liners",10]
[{"v":3.109999999999998,"d":"3.11"},{"$nulls":3},"k. Other",11]
[{"v":3.119999999999998,"d":"3.12"}]
[{"v":3.1299999999999977,"d":"3.13"}]
[4,null,"Did this unit pass clearance on floors on the FIRST TRY?","Did this unit pass clearance on floors on the FIRST TRY?"]
[5,null,"Did this unit pass clearance on floors on the SECOND TRY?","Did this unit pass clearance on floors on the SECOND TRY?",null,null,"skip this Q if Q4=Yes"]
[6,null,"Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​:","Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​ (check all that apply)","a. Re-cleaning ",1,"Skip this Q if Q5=Yes","removed the \"only\" from (a)"]
[{"$f":"A40+0.02","v":6.02},{"$nulls":3},"b. Sealing ",2]
[{"$f":"A41+0.01","v":{"v":6.029999999999999,"d":"6.03"}},{"$nulls":3},"c. Replacement ",3]
[{"$f":"A42+0.01","v":6.039999999999999},{"$nulls":3},"d. Overlaying ",4]
[{"$f":"A43+0.01","v":6.049999999999999},{"$nulls":3},"e. Other ",13]
[7,null,"Please identify the number of FINAL floor dust wipe clearance samples that were collected in this unit:","How many FINAL floor dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?",null,null,"skip this if Q5=no"]
[8,null,"Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples:","Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples:",null,null,"Based on your answer to the previous question, a total of "," samples will need to be entered.  A separate entry box will appear for each sample.  These are numbered Sample 1 through ",".  Please Note that you must enter numbers!"]
[{"$f":"A46+0.02","v":8.02}]
[{"$f":"A47+0.01","v":8.03}]
[8.04]
[8.049999999999999]
[8.059999999999999]
[8.069999999999999]
[8.079999999999998]
[8.089999999999998]
[8.099999999999998]
[8.109999999999998]
[8.119999999999997]
[8.129999999999997]
[8.139999999999997]
[8.149999999999997]
[8.159999999999997]
[8.169999999999996]
[8.179999999999996]
[8.189999999999996]
[8.199999999999996]
[8.209999999999996]
[8.219999999999995]
[8.229999999999995]
[8.239999999999995]
[8.249999999999995]
[8.259999999999994]
[8.269999999999994]
[8.279999999999994]
[8.289999999999994]
[{"v":8.299999999999994,"d":"8.30"}]
[9,null,"Did this unit pass clearance on windowsills on the FIRST TRY?","Did this unit pass clearance on windowsills on the FIRST TRY?"]
[10,null,"Did this unit pass clearance on windowsills on the SECOND TRY?","Did this unit pass clearance on windowsills on the SECOND TRY?"]
[11,null,"Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES: ","Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES (check all that apply): ","a. Re-cleaning ",1,null,"removed the \"only\" from (a)"]
[{"$f":"A78+0.02","v":11.02},{"$nulls":3},"b. Sealing ",2]
[{"$f":"A79+0.01","v":11.03},{"$nulls":3},"c. Replacement ",3]
[{"$f":"A80+0.01","v":11.04},{"$nulls":3},"d. Other ",13]
[12,null,"Identify the number of FINAL windowsill dust wipe clearance samples that were collected in this unit:","How many FINAL windowsill dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"]
[13,null,"Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples:","Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples:",null,null,"Based on your answer to the previous question, a total of "," samples will need to be entered.  A separate entry box will appear for each sample.  These are numbered Sample 1 through ",".  Please Note that you must enter numbers!"]
[{"$f":"A83+0.02","v":13.02}]
[{"$f":"A84+0.01","v":13.03}]
[13.04]
[{"v":13.049999999999999,"d":"13.05"}]
[{"v":13.059999999999999,"d":"13.06"}]
[{"v":13.069999999999999,"d":"13.07"}]
[{"v":13.079999999999998,"d":"13.08"}]
[{"v":13.089999999999998,"d":"13.09"}]
[{"v":13.099999999999998,"d":"13.10"}]
[{"v":13.109999999999998,"d":"13.11"}]
[{"v":13.119999999999997,"d":"13.12"}]
[{"v":13.129999999999997,"d":"13.13"}]
[{"v":13.139999999999997,"d":"13.14"}]
[{"v":13.149999999999997,"d":"13.15"}]
[{"v":13.159999999999997,"d":"13.16"}]
[{"v":13.169999999999996,"d":"13.17"}]
[{"v":13.179999999999996,"d":"13.18"}]
[{"v":13.189999999999996,"d":"13.19"}]
[{"v":13.199999999999996,"d":"13.20"}]
[{"v":13.209999999999996,"d":"13.21"}]
[{"v":13.219999999999995,"d":"13.22"}]
[{"v":13.229999999999995,"d":"13.23"}]
[{"v":13.239999999999995,"d":"13.24"}]
[{"v":13.249999999999995,"d":"13.25"}]
[{"v":13.259999999999994,"d":"13.26"}]
[{"v":13.269999999999994,"d":"13.27"}]
[{"v":13.279999999999994,"d":"13.28"}]
[{"v":13.289999999999994,"d":"13.29"}]
[{"v":13.299999999999994,"d":"13.30"}]
[14,null,"Did this unit pass clearance on window troughs on the FIRST TRY?","Did this unit pass clearance on window troughs on the FIRST TRY?"]
[15,null,"Did this unit pass clearance on window troughs on the SECOND TRY?","Did this unit pass clearance on window troughs on the SECOND TRY?"]
[16,null,"Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES: ","Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES (check all that apply): ","a. Re-cleaning ",1,null,"removed the \"only\" from (a)"]
[{"$f":"A115+0.02","v":16.02},{"$nulls":3},"b. Sealing ",2]
[{"$f":"A116+0.01","v":16.03},{"$nulls":3},"c. Replacement ",3]
[{"$f":"A117+0.01","v":{"v":16.040000000000003,"d":"16.04"}},{"$nulls":3},"d. Install trough liner ",4]
[{"$f":"A118+0.01","v":{"v":16.050000000000004,"d":"16.05"}},{"$nulls":3},"e. Other",7]
[17,null,"How many FINAL window trough dust wipe clearance samples were collected in this unit ?","How many FINAL window trough dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"]
[18,null,"Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples:","Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples:",null,null,"Based on your answer to the previous question, a total of "," samples will need to be entered.  A separate entry box will appear for each sample.  These are numbered Sample 1 through ",".  Please Note that you must enter numbers!"]
[{"$f":"A121+0.02","v":18.02}]
[{"$f":"A122+0.01","v":18.03}]
[{"v":18.040000000000003,"d":"18.04"}]
[{"v":18.050000000000004,"d":"18.05"}]
[{"v":18.060000000000006,"d":"18.06"}]
[{"v":18.070000000000007,"d":"18.07"}]
[{"v":18.08000000000001,"d":"18.08"}]
[{"v":18.09000000000001,"d":"18.09"}]
[{"v":18.100000000000012,"d":"18.10"}]
[{"v":18.110000000000014,"d":"18.11"}]
[{"v":18.120000000000015,"d":"18.12"}]
[{"v":18.130000000000017,"d":"18.13"}]
[{"v":18.14000000000002,"d":"18.14"}]
[{"v":18.15000000000002,"d":"18.15"}]
[{"v":18.16000000000002,"d":"18.16"}]
[{"v":18.170000000000023,"d":"18.17"}]
[{"v":18.180000000000025,"d":"18.18"}]
[{"v":18.190000000000026,"d":"18.19"}]
[{"v":18.200000000000028,"d":"18.20"}]
[{"v":18.21000000000003,"d":"18.21"}]
[{"v":18.22000000000003,"d":"18.22"}]
[{"v":18.230000000000032,"d":"18.23"}]
[{"v":18.240000000000034,"d":"18.24"}]
[{"v":18.250000000000036,"d":"18.25"}]
[{"v":18.260000000000037,"d":"18.26"}]
[{"v":18.27000000000004,"d":"18.27"}]
[{"v":18.28000000000004,"d":"18.28"}]
[{"v":18.290000000000042,"d":"18.29"}]
[{"v":18.300000000000043,"d":"18.30"}]

{"sheet":"U_Sort","index":7,"n_rows":150,"n_cols":8,"rows_kept":150,"hidden":true,"merged":[[2,0,2,1]]}
["Unit_Sort.  This sheet holds the lists of picks for various multi-item questions so they can be sorted to remove display gaps and to be moved to long-term storage; It is filled in by Macro"]
["NOTE:  This sheet will be hidden from grantees"]
["Sheet is emptied by writing 'z' to cells in B column",{"$nulls":6},"temp"]
{"$rows_empty":18}
[null,"z"]
[null,"z"]
[null,"z","Labels","1ST Char",null,"Picks for Q3"]
[{"$f":"COUNTA(B25:B37)-COUNTIF(B25:B37,\"z\")","v":0},"z",null,{"$f":"LEFT(B25,1)","v":"z"},{"$nulls":3},{"$f":"COUNTA(I25:I37)-COUNTIF(I25:I37,\"z\")","v":0}]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z",null,"z"]
[null,"z"]
[null,"z",{"$nulls":3},"Picks for Q6"]
[{"$f":"COUNTA(B40:B44)-COUNTIF(B40:B44,\"z\")","v":0},"z",null,{"$f":"LEFT(B40,1)","v":"z"},{"$nulls":3},{"$f":"COUNTA(I40:I44)-COUNTIF(I40:I44,\"z\")","v":0}]
[null,"z",null,{"$f":"LEFT(B41,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B42,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B43,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B44,1)","v":"z"}]
[null,"z",{"$nulls":3},"Picks for Q8"]
[{"$f":"COUNTA(B46:B75)-COUNTIF(B46:B75,\"z\")","v":0},"z",{"$f":"\"FloorSample \"&E46","v":"FloorSample 1"},{"$f":"LEFT(B46,1)","v":"z"},1,null,null,{"$f":"COUNTA(I46:I75)-COUNTIF(I46:I75,\"z\")","v":0}]
[null,"z",{"$f":"\"FloorSample \"&E47","v":"FloorSample 2"},{"$f":"LEFT(B47,1)","v":"z"},{"$f":"E46+1","v":2}]
[null,"z","FloorSample 3","z",{"$f":"E47+1","v":3}]
[null,"z","FloorSample 4","z",4]
[null,"z","FloorSample 5","z",5]
[null,"z","FloorSample 6","z",6]
[null,"z","FloorSample 7","z",7]
[null,"z","FloorSample 8","z",8]
[null,"z","FloorSample 9","z",9]
[null,"z","FloorSample 10","z",10]
[null,"z","FloorSample 11","z",11]
[null,"z","FloorSample 12","z",12]
[null,"z","FloorSample 13","z",13]
[null,"z","FloorSample 14","z",14]
[null,"z","FloorSample 15","z",15]
[null,"z","FloorSample 16","z",16]
[null,"z","FloorSample 17","z",17]
[null,"z","FloorSample 18","z",18]
[null,"z","FloorSample 19","z",19]
[null,"z","FloorSample 20","z",20]
[null,"z","FloorSample 21","z",21]
[null,"z","FloorSample 22","z",22]
[null,"z","FloorSample 23","z",23]
[null,"z","FloorSample 24","z",24]
[null,"z","FloorSample 25","z",25]
[null,"z","FloorSample 26","z",26]
[null,"z","FloorSample 27","z",27]
[null,"z","FloorSample 28","z",28]
[null,"z","FloorSample 29","z",29]
[null,"z","FloorSample 30","z",30]
[null,"z"]
[null,"z",{"$nulls":3},"Picks for Q11"]
[{"$f":"COUNTA(B78:B81)-COUNTIF(B78:B81,\"z\")","v":0},"z",null,{"$f":"LEFT(B78,1)","v":"z"},{"$nulls":3},{"$f":"COUNTA(I78:I81)-COUNTIF(I78:I81,\"z\")","v":0}]
[null,"z",null,{"$f":"LEFT(B79,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B80,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B81,1)","v":"z"}]
[null,"z",{"$nulls":3},"Picks for Q13"]
[{"$f":"COUNTA(B83:B112)-COUNTIF(B83:B112,\"z\")","v":0},"z",{"$f":"\"WindowSillSample \"&E83","v":"WindowSillSample 1"},{"$f":"LEFT(B83,1)","v":"z"},1,null,null,{"$f":"COUNTA(I83:I112)-COUNTIF(I83:I112,\"z\")","v":0}]
[null,"z",{"$f":"\"WindowSillSample \"&E84","v":"WindowSillSample 2"},{"$f":"LEFT(B84,1)","v":"z"},{"$f":"E83+1","v":2}]
[null,"z","WindowSillSample 3","z",{"$f":"E84+1","v":3}]
[null,"z","WindowSillSample 4","z",4]
[null,"z","WindowSillSample 5","z",5]
[null,"z","WindowSillSample 6","z",6]
[null,"z","WindowSillSample 7","z",7]
[null,"z","WindowSillSample 8","z",8]
[null,"z","WindowSillSample 9","z",9]
[null,"z","WindowSillSample 10","z",10]
[null,"z","WindowSillSample 11","z",11]
[null,"z","WindowSillSample 12","z",12]
[null,"z","WindowSillSample 13","z",13]
[null,"z","WindowSillSample 14","z",14]
[null,"z","WindowSillSample 15","z",15]
[null,"z","WindowSillSample 16","z",16]
[null,"z","WindowSillSample 17","z",17]
[null,"z","WindowSillSample 18","z",18]
[null,"z","WindowSillSample 19","z",19]
[null,"z","WindowSillSample 20","z",20]
[null,"z","WindowSillSample 21","z",21]
[null,"z","WindowSillSample 22","z",22]
[null,"z","WindowSillSample 23","z",23]
[null,"z","WindowSillSample 24","z",24]
[null,"z","WindowSillSample 25","z",25]
[null,"z","WindowSillSample 26","z",26]
[null,"z","WindowSillSample 27","z",27]
[null,"z","WindowSillSample 28","z",28]
[null,"z","WindowSillSample 29","z",29]
[null,"z","WindowSillSample 30","z",30]
[null,"z"]
[null,"z",{"$nulls":3},"Picks for Q16"]
[{"$f":"COUNTA(B115:B119)-COUNTIF(B115:B119,\"z\")","v":0},"z",null,{"$f":"LEFT(B115,1)","v":"z"},{"$nulls":3},{"$f":"COUNTA(I115:I119)-COUNTIF(I115:I119,\"z\")","v":0}]
[null,"z",null,{"$f":"LEFT(B116,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B117,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B118,1)","v":"z"}]
[null,"z",null,{"$f":"LEFT(B119,1)","v":"z"}]
[null,"z",{"$nulls":3},"Picks for Q18"]
[{"$f":"COUNTA(B121:B150)-COUNTIF(B121:B150,\"z\")","v":0},"z",{"$f":"\"WindowTroughSample \"&E121","v":"WindowTroughSample 1"},{"$f":"LEFT(B121,1)","v":"z"},1,null,null,{"$f":"COUNTA(I121:I150)-COUNTIF(I121:I150,\"z\")","v":0}]
[null,"z",{"$f":"\"WindowTroughSample \"&E122","v":"WindowTroughSample 2"},{"$f":"LEFT(B122,1)","v":"z"},{"$f":"E121+1","v":2}]
[null,"z",{"$f":"\"WindowTroughSample \"&E123","v":"WindowTroughSample 3"},"z",{"$f":"E122+1","v":3}]
[null,"z","WindowTroughSample 4","z",4]
[null,"z","WindowTroughSample 5","z",5]
[null,"z","WindowTroughSample 6","z",6]
[null,"z","WindowTroughSample 7","z",7]
[null,"z","WindowTroughSample 8","z",8]
[null,"z","WindowTroughSample 9","z",9]
[null,"z","WindowTroughSample 10","z",10]
[null,"z","WindowTroughSample 11","z",11]
[null,"z","WindowTroughSample 12","z",12]
[null,"z","WindowTroughSample 13","z",13]
[null,"z","WindowTroughSample 14","z",14]
[null,"z","WindowTroughSample 15","z",15]
[null,"z","WindowTroughSample 16","z",16]
[null,"z","WindowTroughSample 17","z",17]
[null,"z","WindowTroughSample 18","z",18]
[null,"z","WindowTroughSample 19","z",19]
[null,"z","WindowTroughSample 20","z",20]
[null,"z","WindowTroughSample 21","z",21]
[null,"z","WindowTroughSample 22","z",22]
[null,"z","WindowTroughSample 23","z",23]
[null,"z","WindowTroughSample 24","z",24]
[null,"z","WindowTroughSample 25","z",25]
[null,"z","WindowTroughSample 26","z",26]
[null,"z","WindowTroughSample 27","z",27]
[null,"z","WindowTroughSample 28","z",28]
[null,"z","WindowTroughSample 29","z",29]
[null,"z","WindowTroughSample 30","z",30]

{"sheet":"PrintGQs","index":8,"n_rows":43,"n_cols":3,"rows_kept":43,"hidden":true,"merged":[[7,0,7,2],[8,0,8,2],[9,0,9,1],[10,0,12,0],[10,1,12,1],[13,0,20,0],[13,1,20,1],[21,0,30,0],[21,1,30,1],[31,0,40,0],[31,1,40,1]]}
["PrintGQs.  This sheet, used for printing, holds the text for asking the general (non-unit specific) questions"]
["NOTE:  This sheet will be hidden from grantees"]
[]
[]
[]
[]
[]
["LEAD CLEARANCE QUESTIONNAIRE: General Questions"]
["[For information only - NOT to be used to submit answers to QuanTech or HUD]"]
[" Question",null,"Pick List options"]
["Question 1",{"$f":"G!D11","v":"Regarding this HUD Lead Hazard Control grant, please indicate (check one) whether your organization is:"},"a. The grantee"]
[null,null,"b. A subgrantee"]
[null,null,"c. A contractor to the grantee or a subgrantee"]
["Question 2",{"$f":"G!D14","v":"Please indicate (check one) the category that best describes your organization:"},"a. State/local health department"]
[null,null,"b. State/local community development, or economic development department"]
[null,null,"c. State/local community buildings or housing development department"]
[null,null,"d. Non-governmental organization"]
[null,null,"e. Certified abatement contractor"]
[null,null,"f. Certified renovation firm"]
[null,null,"g. Risk assessment firm"]
[null,null,"h. Other"]
["Question 3",{"$f":"G!D22","v":"What triggers recruitment of homes into the grant? (Please check all that apply)"},"a. Abatement order from a Health Department as a result of a child with an elevated blood lead level"]
[null,null,"b. Notice from a Health Department of a child with an elevated blood lead level"]
[null,null,"c. Building code, housing code, or other code violation"]
[null,null,"d. Combining lead hazard control work with other rehabilitation or modernization work"]
[null,null,"e. Transfer of ownership or occupancy"]
[null,null,"f. Lead dust levels in the home are above the lead hazard standards"]
[null,null,"g. Presence of deteriorated lead-based paint in the home"]
[null,null,"h. Neighborhood characteristics"]
[null,null,"i. Outreach and recruiting drives."]
[null,null,"j. Other "]
["Question 4",{"$f":"G!D32","v":"The list below shows your selections on what triggers recruitment of homes. Please rank these triggers by frequency of occurance placing the most frequent trigger at the top and least frequent at the bottom of the list.  To move a trigger, click to highlight it and click the Move UP or Move Down buttons to move it within the List:"},"** Same pick list as Question 3 above**"]
{"$rows_empty":9}
["Question 5","On how many dwelling units have you performed lead hazard control work and clearance testing in the past 12 months?"]
["Question 6","What is the reporting limit of your laboratory for floor lead dust wipe samples in µg/ft² (generally indicated by a less-than sign (<) preceding the laboratory reported result)? "]

{"sheet":"PrintUQs","index":9,"n_rows":121,"n_cols":3,"rows_kept":121,"hidden":true,"merged":[[7,0,7,2],[8,0,8,2],[9,0,9,1],[10,0,16,0],[10,1,16,1],[17,0,23,0],[17,1,23,1],[24,0,36,0],[24,1,36,1],[39,0,43,0],[39,1,43,1],[77,0,80,0],[77,1,80,1],[114,0,118,0],[114,1,118,1]]}
["PrintUQs.  This sheet, used for printing, holds the text for asking the unit-specific questions"]
["NOTE:  This sheet will be hidden from grantees"]
[]
[]
[]
[]
[]
["LEAD CLEARANCE QUESTIONNAIRE:  Unit-Specific Questions"]
["[For information only - NOT to be used to submit answers to QuanTech or HUD]"]
[" Question",null,"Pick List options"]
["Question 1",{"$f":"U!D11","v":"Please identify the type of dwelling (check one):"},{"$f":"U!E11","v":"a. Detached Single Family House "}]
[null,null,{"$f":"U!E12","v":"b. Duplex/Triplex"}]
[null,null,{"$f":"U!E13","v":"c. Row House/Town House"}]
[null,null,{"$f":"U!E14","v":"d. Low Rise Apartment (1-3 Floors)"}]
[null,null,{"$f":"U!E15","v":"e. High Rise Apartment (>3 Floors)"}]
[null,null,{"$f":"U!E16","v":"f. Mobile/Manufactured Home"}]
[null,null,{"$f":"U!E17","v":"g. Other"}]
["Question 2",{"$f":"U!D18","v":"Please identify the construction date of this unit (check one):"},{"$f":"U!E18","v":"a. 1990 to Present"}]
[null,null,{"$f":"U!E19","v":"b. Between 1978 and 1989"}]
[null,null,{"$f":"U!E20","v":"c. Between 1960 and 1977"}]
[null,null,{"$f":"U!E21","v":"d. Between 1946 and 1959"}]
[null,null,{"$f":"U!E22","v":"e. Between 1940 and 1945"}]
[null,null,{"$f":"U!E23","v":"f. 1939 or Before"}]
[null,null,{"$f":"U!E24","v":"g. Don’t Know"}]
["Question 3",{"$f":"U!D25","v":"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 (check all that apply)?\""},{"$f":"U!E25","v":"a. HEPA vacuuming"}]
[null,null,{"$f":"U!E26","v":"b. HEPA/Wet wash/HEPA cycle"}]
[null,null,{"$f":"U!E27","v":"c. Wet detergent wash using trisodium phosphate "}]
[null,null,{"$f":"U!E28","v":"d. Wet detergent wash using a general purpose cleaner"}]
[null,null,{"$f":"U!E29","v":"e. Seal flooring"}]
[null,null,{"$f":"U!E30","v":"f. Overlay flooring"}]
[null,null,{"$f":"U!E31","v":"g. Replace flooring"}]
[null,null,{"$f":"U!E32","v":"h. Seal windowsills"}]
[null,null,{"$f":"U!E33","v":"i. Seal window troughs"}]
[null,null,{"$f":"U!E34","v":"j. Install window trough liners"}]
[null,null,{"$f":"U!E35","v":"k. Other"}]
[]
[]
["Question 4",{"$f":"U!D38","v":"Did this unit pass clearance on floors on the FIRST TRY?"}]
["Question 5",{"$f":"U!D39","v":"Did this unit pass clearance on floors on the SECOND TRY?"}]
["Question 6",{"$f":"U!D40","v":"Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​ (check all that apply)"},{"$f":"U!E40","v":"a. Re-cleaning "}]
[null,null,{"$f":"U!E41","v":"b. Sealing "}]
[null,null,{"$f":"U!E42","v":"c. Replacement "}]
[null,null,{"$f":"U!E43","v":"d. Overlaying "}]
[null,null,{"$f":"U!E44","v":"e. Other "}]
["Question 7",{"$f":"U!D45","v":"How many FINAL floor dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"}]
["Question 8",{"$f":"U!D46","v":"Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples:"}]
{"$rows_empty":29}
["Question 9",{"$f":"U!D76","v":"Did this unit pass clearance on windowsills on the FIRST TRY?"}]
["Question 10",{"$f":"U!D77","v":"Did this unit pass clearance on windowsills on the SECOND TRY?"}]
["Question 11",{"$f":"U!D78","v":"Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES (check all that apply): "},{"$f":"U!E78","v":"a. Re-cleaning "}]
[null,null,{"$f":"U!E79","v":"b. Sealing "}]
[null,null,{"$f":"U!E80","v":"c. Replacement "}]
[null,null,{"$f":"U!E81","v":"d. Other "}]
["Question 12",{"$f":"U!D82","v":"How many FINAL windowsill dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"}]
["Question 13",{"$f":"U!D83","v":"Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples:"}]
{"$rows_empty":29}
["Question 14",{"$f":"U!D113","v":"Did this unit pass clearance on window troughs on the FIRST TRY?"}]
["Question 15",{"$f":"U!D114","v":"Did this unit pass clearance on window troughs on the SECOND TRY?"}]
["Question 16",{"$f":"U!D115","v":"Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES (check all that apply): "},{"$f":"U!E115","v":"a. Re-cleaning "}]
[null,null,{"$f":"U!E116","v":"b. Sealing "}]
[null,null,{"$f":"U!E117","v":"c. Replacement "}]
[null,null,{"$f":"U!E118","v":"d. Install trough liner "}]
[null,null,{"$f":"U!E119","v":"e. Other"}]
["Question 17",{"$f":"U!D120","v":"How many FINAL window trough dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"}]
["Question 18",{"$f":"U!D121","v":"Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples:"}]

{"sheet":"GData0","index":10,"n_rows":43,"n_cols":4,"rows_kept":43,"hidden":true,"merged":[[10,1,12,1],[10,2,12,2],[13,1,20,1],[13,2,20,2],[21,1,30,1],[21,2,30,2],[31,1,40,1],[31,2,40,2]]}
["GData0.  Long-Term Storage of GEN_Q. This sheet holds all the answers to Unit Questions"]
[]
[]
[]
[null,null,"Completion Status (%)->"]
[null,null,"Count of Entries in Col->",{"$f":"COUNTA(D$11:D$43)-COUNTIF(D$11:D$43,\"- not entered -\")","v":0}]
[null,null,"Data Exists Flag->",{"$f":"IF(D6>0,1,0)","v":0}]
[null,null,"not Used"]
[null,null,"Grant Number->","OHLHB0477-10"]
["Q",null,"not Used"]
[1,{"$f":"\"Question \"&A11","v":"Question 1"},{"$f":"VLOOKUP(A11,GEN,3,FALSE)","v":"Regarding this HUD Lead Hazard Control grant, please indicate your organization type:"}]
[]
[]
[2,{"$f":"\"Question \"&A14","v":"Question 2"},{"$f":"VLOOKUP(A14,GEN,3,FALSE)","v":"Please indicate the category that best describes your organization:"}]
{"$rows_empty":7}
[3,null,{"$f":"VLOOKUP(A22,GEN,3,FALSE)","v":"What triggers recruitment of homes into the grant? "}]
[{"$f":"A22+0.02","v":3.02}]
[{"$f":"A23+0.01","v":3.03}]
[{"$f":"A24+0.01","v":{"v":3.0399999999999996,"d":"3.04"}}]
[{"v":3.0499999999999994,"d":"3.05"}]
[{"v":3.059999999999999,"d":"3.06"}]
[{"v":3.069999999999999,"d":"3.07"}]
[{"v":3.0799999999999987,"d":"3.08"}]
[{"v":3.0899999999999985,"d":"3.09"}]
[{"v":3.0999999999999983,"d":"3.10"}]
[4,null,{"$f":"VLOOKUP(A32,GEN,3,FALSE)","v":"Please rank unit recruitment triggers by frequency with most frequent at the top of the list."}]
[{"$f":"A32+0.02","v":4.02}]
[{"$f":"A33+0.01","v":{"v":4.029999999999999,"d":"4.03"}}]
[{"$f":"A34+0.01","v":{"v":4.039999999999999,"d":"4.04"}}]
[{"v":4.049999999999999,"d":"4.05"}]
[{"v":4.059999999999999,"d":"4.06"}]
[{"v":4.0699999999999985,"d":"4.07"}]
[{"v":4.079999999999998,"d":"4.08"}]
[{"v":4.089999999999998,"d":"4.09"}]
[{"v":4.099999999999998,"d":"4.10"}]
[5,{"$f":"\"Question \"&A42","v":"Question 5"},{"$f":"VLOOKUP(A42,GEN,3,FALSE)","v":"On how many dwelling units have you performed lead hazard control work and clearance testing in the past 12 months?"}]
[6,{"$f":"\"Question \"&A43","v":"Question 6"},{"$f":"VLOOKUP(A43,GEN,3,FALSE)","v":"What is the reporting limit of your laboratory for floor lead dust wipe samples in µg/ft² (generally indicated by a less-than sign (<) preceding the laboratory reported result)? "}]

{"sheet":"UData0","index":11,"n_rows":158,"n_cols":23,"rows_kept":158,"hidden":true,"merged":[[10,1,16,1],[17,1,23,1],[24,1,36,1],[39,1,43,1],[45,1,74,1],[77,1,80,1],[82,1,111,1],[114,1,118,1],[120,1,149,1],[150,0,150,2]]}
["UData0.  Long-Term Storage of UNIT_Q. This sheet holds all the answers to Unit Questions"]
[]
[]
[]
[null,null,"% Completion Status->",0,null,0,0,{"$nulls":3},0]
[null,null,"Count of Entries in Col->",{"$f":"COUNTA(D$11:D$121)-COUNTIF(D$11:D$121,\"- not entered -\")","v":0},{"$f":"COUNTA(E$11:E$121)-COUNTIF(E$11:E$121,\"- not entered -\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Data Exists Flag->",{"$f":"IF(D6>0,1,0)","v":0},{"$f":"IF(E6>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Unit ID->",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
[null,null,"Grant Number->",{"$f":"Central_Control!$B$1","v":"OHLHB0477-10"}]
["Q","Question",null,"621 Pasadena Place, Youngstown, OH ,44502",null,"33 Georgia Avenue, 3B, Youngstown, OH ,44502","33 Georgia Avenue, 4A, Youngstown, OH ,44502",{"$nulls":3},"911 Airport Rd, Youngstown, OH ,44502"]
[1,{"$f":"U!D11","v":"Please identify the type of dwelling (check one):"}]
[{"$f":"A11+0.02","v":1.02}]
[{"$f":"A12+0.01","v":1.03}]
[{"$f":"A13+0.01","v":1.04}]
[{"$f":"A14+0.01","v":1.05}]
[{"$f":"A15+0.01","v":1.06}]
[{"$f":"A16+0.01","v":1.07}]
[2,{"$f":"U!D18","v":"Please identify the construction date of this unit (check one):"}]
[{"$f":"A18+0.02","v":2.02}]
[{"$f":"A19+0.01","v":2.03}]
[{"$f":"A20+0.01","v":{"v":2.0399999999999996,"d":"2.04"}}]
[{"$f":"A21+0.01","v":{"v":2.0499999999999994,"d":"2.05"}}]
[{"$f":"A22+0.01","v":{"v":2.059999999999999,"d":"2.06"}}]
[{"$f":"A23+0.01","v":{"v":2.069999999999999,"d":"2.07"}}]
[3,{"$f":"U!D25","v":"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 (check all that apply)?\""}]
[{"$f":"A25+0.02","v":3.02}]
[{"$f":"A26+0.01","v":3.03}]
[{"v":3.0399999999999996,"d":"3.04"}]
[{"v":3.0499999999999994,"d":"3.05"}]
[{"v":3.059999999999999,"d":"3.06"}]
[{"v":3.069999999999999,"d":"3.07"}]
[{"v":3.0799999999999987,"d":"3.08"}]
[{"v":3.0899999999999985,"d":"3.09"}]
[{"v":3.0999999999999983,"d":"3.10"}]
[{"v":3.109999999999998,"d":"3.11"}]
[{"v":3.119999999999998,"d":"3.12"}]
[{"v":3.1299999999999977,"d":"3.13"}]
[4,{"$f":"U!D38","v":"Did this unit pass clearance on floors on the FIRST TRY?"}]
[5,{"$f":"U!D39","v":"Did this unit pass clearance on floors on the SECOND TRY?"}]
[6,{"$f":"U!D40","v":"Please identify the type of action taken to achieve clearance on floors in this unit AFTER ONE OR MORE CLEARANCE FAILURES​ (check all that apply)"}]
[{"$f":"A40+0.02","v":6.02}]
[{"$f":"A41+0.01","v":{"v":6.029999999999999,"d":"6.03"}}]
[{"$f":"A42+0.01","v":6.039999999999999}]
[{"$f":"A43+0.01","v":6.049999999999999}]
[7,{"$f":"U!D45","v":"How many FINAL floor dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"}]
[8,{"$f":"U!D46","v":"Please enter the loading levels (µg/ft²) for each of the FINAL floor dust wipe clearance samples:"},{"$f":"U_Sort!C46","v":"FloorSample 1"}]
[{"$f":"A46+0.02","v":8.02},null,{"$f":"U_Sort!C47","v":"FloorSample 2"}]
[{"$f":"A47+0.01","v":8.03},null,{"$f":"U_Sort!C48","v":"FloorSample 3"}]
[8.04,null,{"$f":"U_Sort!C49","v":"FloorSample 4"}]
[8.049999999999999,null,{"$f":"U_Sort!C50","v":"FloorSample 5"}]
[8.059999999999999,null,{"$f":"U_Sort!C51","v":"FloorSample 6"}]
[8.069999999999999,null,{"$f":"U_Sort!C52","v":"FloorSample 7"}]
[8.079999999999998,null,{"$f":"U_Sort!C53","v":"FloorSample 8"}]
[8.089999999999998,null,{"$f":"U_Sort!C54","v":"FloorSample 9"}]
[{"v":8.099999999999998,"d":"8.10"},null,{"$f":"U_Sort!C55","v":"FloorSample 10"}]
[8.109999999999998,null,{"$f":"U_Sort!C56","v":"FloorSample 11"}]
[8.119999999999997,null,{"$f":"U_Sort!C57","v":"FloorSample 12"}]
[8.129999999999997,null,{"$f":"U_Sort!C58","v":"FloorSample 13"}]
[8.139999999999997,null,{"$f":"U_Sort!C59","v":"FloorSample 14"}]
[8.149999999999997,null,{"$f":"U_Sort!C60","v":"FloorSample 15"}]
[8.159999999999997,null,{"$f":"U_Sort!C61","v":"FloorSample 16"}]
[8.169999999999996,null,{"$f":"U_Sort!C62","v":"FloorSample 17"}]
[8.179999999999996,null,{"$f":"U_Sort!C63","v":"FloorSample 18"}]
[8.189999999999996,null,{"$f":"U_Sort!C64","v":"FloorSample 19"}]
[{"v":8.199999999999996,"d":"8.20"},null,{"$f":"U_Sort!C65","v":"FloorSample 20"}]
[8.209999999999996,null,{"$f":"U_Sort!C66","v":"FloorSample 21"}]
[8.219999999999995,null,{"$f":"U_Sort!C67","v":"FloorSample 22"}]
[8.229999999999995,null,{"$f":"U_Sort!C68","v":"FloorSample 23"}]
[8.239999999999995,null,{"$f":"U_Sort!C69","v":"FloorSample 24"}]
[8.249999999999995,null,{"$f":"U_Sort!C70","v":"FloorSample 25"}]
[8.259999999999994,null,{"$f":"U_Sort!C71","v":"FloorSample 26"}]
[8.269999999999994,null,{"$f":"U_Sort!C72","v":"FloorSample 27"}]
[8.279999999999994,null,{"$f":"U_Sort!C73","v":"FloorSample 28"}]
[8.289999999999994,null,{"$f":"U_Sort!C74","v":"FloorSample 29"}]
[{"v":8.299999999999994,"d":"8.30"},null,{"$f":"U_Sort!C75","v":"FloorSample 30"}]
[9,{"$f":"U!D76","v":"Did this unit pass clearance on windowsills on the FIRST TRY?"}]
[10,{"$f":"U!D77","v":"Did this unit pass clearance on windowsills on the SECOND TRY?"}]
[11,{"$f":"U!D78","v":"Please identify the type of action taken to achieve clearance on windowsills in this unit AFTER ONE OR MORE CLEARANCE FAILURES (check all that apply): "}]
[{"$f":"A78+0.02","v":11.02}]
[{"$f":"A79+0.01","v":11.03}]
[{"$f":"A80+0.01","v":11.04}]
[12,{"$f":"U!D82","v":"How many FINAL windowsill dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"}]
[13,{"$f":"U!D83","v":"Please enter the loading levels (µg/ft²) for each of the FINAL windowsill dust wipe clearance samples:"},{"$f":"U_Sort!C83","v":"WindowSillSample 1"}]
[{"$f":"A83+0.02","v":13.02},null,{"$f":"U_Sort!C84","v":"WindowSillSample 2"}]
[{"$f":"A84+0.01","v":13.03},null,{"$f":"U_Sort!C85","v":"WindowSillSample 3"}]
[13.04,null,{"$f":"U_Sort!C86","v":"WindowSillSample 4"}]
[{"v":13.049999999999999,"d":"13.05"},null,{"$f":"U_Sort!C87","v":"WindowSillSample 5"}]
[{"v":13.059999999999999,"d":"13.06"},null,{"$f":"U_Sort!C88","v":"WindowSillSample 6"}]
[{"v":13.069999999999999,"d":"13.07"},null,{"$f":"U_Sort!C89","v":"WindowSillSample 7"}]
[{"v":13.079999999999998,"d":"13.08"},null,{"$f":"U_Sort!C90","v":"WindowSillSample 8"}]
[{"v":13.089999999999998,"d":"13.09"},null,{"$f":"U_Sort!C91","v":"WindowSillSample 9"}]
[{"v":13.099999999999998,"d":"13.10"},null,{"$f":"U_Sort!C92","v":"WindowSillSample 10"}]
[{"v":13.109999999999998,"d":"13.11"},null,{"$f":"U_Sort!C93","v":"WindowSillSample 11"}]
[{"v":13.119999999999997,"d":"13.12"},null,{"$f":"U_Sort!C94","v":"WindowSillSample 12"}]
[{"v":13.129999999999997,"d":"13.13"},null,{"$f":"U_Sort!C95","v":"WindowSillSample 13"}]
[{"v":13.139999999999997,"d":"13.14"},null,{"$f":"U_Sort!C96","v":"WindowSillSample 14"}]
[{"v":13.149999999999997,"d":"13.15"},null,{"$f":"U_Sort!C97","v":"WindowSillSample 15"}]
[{"v":13.159999999999997,"d":"13.16"},null,{"$f":"U_Sort!C98","v":"WindowSillSample 16"}]
[{"v":13.169999999999996,"d":"13.17"},null,{"$f":"U_Sort!C99","v":"WindowSillSample 17"}]
[{"v":13.179999999999996,"d":"13.18"},null,{"$f":"U_Sort!C100","v":"WindowSillSample 18"}]
[{"v":13.189999999999996,"d":"13.19"},null,{"$f":"U_Sort!C101","v":"WindowSillSample 19"}]
[{"v":13.199999999999996,"d":"13.20"},null,{"$f":"U_Sort!C102","v":"WindowSillSample 20"}]
[{"v":13.209999999999996,"d":"13.21"},null,{"$f":"U_Sort!C103","v":"WindowSillSample 21"}]
[{"v":13.219999999999995,"d":"13.22"},null,{"$f":"U_Sort!C104","v":"WindowSillSample 22"}]
[{"v":13.229999999999995,"d":"13.23"},null,{"$f":"U_Sort!C105","v":"WindowSillSample 23"}]
[{"v":13.239999999999995,"d":"13.24"},null,{"$f":"U_Sort!C106","v":"WindowSillSample 24"}]
[{"v":13.249999999999995,"d":"13.25"},null,{"$f":"U_Sort!C107","v":"WindowSillSample 25"}]
[{"v":13.259999999999994,"d":"13.26"},null,{"$f":"U_Sort!C108","v":"WindowSillSample 26"}]
[{"v":13.269999999999994,"d":"13.27"},null,{"$f":"U_Sort!C109","v":"WindowSillSample 27"}]
[{"v":13.279999999999994,"d":"13.28"},null,{"$f":"U_Sort!C110","v":"WindowSillSample 28"}]
[{"v":13.289999999999994,"d":"13.29"},null,{"$f":"U_Sort!C111","v":"WindowSillSample 29"}]
[{"v":13.299999999999994,"d":"13.30"},null,{"$f":"U_Sort!C112","v":"WindowSillSample 30"}]
[14,{"$f":"U!D113","v":"Did this unit pass clearance on window troughs on the FIRST TRY?"}]
[15,{"$f":"U!D114","v":"Did this unit pass clearance on window troughs on the SECOND TRY?"}]
[16,{"$f":"U!D115","v":"Please identify the type of action taken to achieve clearance on window troughs in this unit AFTER ONE OR MORE CLEARANCE FAILURES (check all that apply): "}]
[{"$f":"A115+0.02","v":16.02}]
[{"$f":"A116+0.01","v":16.03}]
[{"$f":"A117+0.01","v":{"v":16.040000000000003,"d":"16.04"}}]
[{"$f":"A118+0.01","v":{"v":16.050000000000004,"d":"16.05"}}]
[17,{"$f":"U!D120","v":"How many FINAL window trough dust wipe clearance samples were collected in this unit (\"FINAL\" means those passing clearance levels, not those failing to pass clearance)?"}]
[18,{"$f":"U!D121","v":"Please enter the loading levels (µg/ft²) for each of the FINAL window trough dust wipe clearance samples:"},{"$f":"U_Sort!C121","v":"WindowTroughSample 1"}]
[null,null,{"$f":"U_Sort!C122","v":"WindowTroughSample 2"}]
[null,null,{"$f":"U_Sort!C123","v":"WindowTroughSample 3"}]
[null,null,{"$f":"U_Sort!C124","v":"WindowTroughSample 4"}]
[null,null,{"$f":"U_Sort!C125","v":"WindowTroughSample 5"}]
[null,null,{"$f":"U_Sort!C126","v":"WindowTroughSample 6"}]
[null,null,{"$f":"U_Sort!C127","v":"WindowTroughSample 7"}]
[null,null,{"$f":"U_Sort!C128","v":"WindowTroughSample 8"}]
[null,null,{"$f":"U_Sort!C129","v":"WindowTroughSample 9"}]
[null,null,{"$f":"U_Sort!C130","v":"WindowTroughSample 10"}]
[null,null,{"$f":"U_Sort!C131","v":"WindowTroughSample 11"}]
[null,null,{"$f":"U_Sort!C132","v":"WindowTroughSample 12"}]
[null,null,{"$f":"U_Sort!C133","v":"WindowTroughSample 13"}]
[null,null,{"$f":"U_Sort!C134","v":"WindowTroughSample 14"}]
[null,null,{"$f":"U_Sort!C135","v":"WindowTroughSample 15"}]
[null,null,{"$f":"U_Sort!C136","v":"WindowTroughSample 16"}]
[null,null,{"$f":"U_Sort!C137","v":"WindowTroughSample 17"}]
[null,null,{"$f":"U_Sort!C138","v":"WindowTroughSample 18"}]
[null,null,{"$f":"U_Sort!C139","v":"WindowTroughSample 19"}]
[null,null,{"$f":"U_Sort!C140","v":"WindowTroughSample 20"}]
[null,null,{"$f":"U_Sort!C141","v":"WindowTroughSample 21"}]
[null,null,{"$f":"U_Sort!C142","v":"WindowTroughSample 22"}]
[null,null,{"$f":"U_Sort!C143","v":"WindowTroughSample 23"}]
[null,null,{"$f":"U_Sort!C144","v":"WindowTroughSample 24"}]
[null,null,{"$f":"U_Sort!C145","v":"WindowTroughSample 25"}]
[null,null,{"$f":"U_Sort!C146","v":"WindowTroughSample 26"}]
[null,null,{"$f":"U_Sort!C147","v":"WindowTroughSample 27"}]
[null,null,{"$f":"U_Sort!C148","v":"WindowTroughSample 28"}]
[null,null,{"$f":"U_Sort!C149","v":"WindowTroughSample 29"}]
[null,null,{"$f":"U_Sort!C150","v":"WindowTroughSample 30"}]
["COUNTS OF ITEMS PROCESSED IN SORT SHEETS"]
[null,null,"UQ3->",{"$f":"COUNTA(D25:D37)","v":0},{"$f":"COUNTA(E25:E37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"UQ6->",{"$f":"COUNTA(D40:D44)","v":0},{"$f":"COUNTA(E40:E44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"UQ8->",{"$f":"COUNTA(D46:D75)","v":0},{"$f":"COUNTA(E46:E75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"UQ11->",{"$f":"COUNTA(D78:D81)","v":0},{"$f":"COUNTA(E78:E81)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"UQ13->",{"$f":"COUNTA(D83:D112)","v":0},{"$f":"COUNTA(E83:E112)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"UQ16->",{"$f":"COUNTA(D115:D119)","v":0},{"$f":"COUNTA(E115:E119)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"UQ18->",{"$f":"COUNTA(D121:D150)","v":0},{"$f":"COUNTA(E121:E150)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Question_Macros","index":12,"n_rows":33,"n_cols":10,"rows_kept":33,"hidden":true,"merged":[[3,0,3,9],[4,0,5,0],[4,1,5,1],[4,2,4,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[6,0,6,9],[13,0,13,9],[32,0,32,9]]}
["Question_Macros.  Info for Creating Code for the UserForms"]
["This sheet will be hidden from User"]
[]
["Sub Routines for Question Button Controls (excludes Other-Specify TextBox)"]
["Q#","Call Macro Name","Sheet Rows for ",null,"Form #","Form Tool Type","Number of Pick Items (=tools in Form)","Number of possible answers","Y/N?","Other in Pick List?"]
[null,null,"Questions","Pick Lists"]
["General Question Macros: \"G\" & \"GEN_Q\" Sheets"]
[1,"GetGrantType",11,"11-13",1,"OptionButton",3,1]
[2,"GetGrantOrg",14,"14-21",2,"OptionButton",8,1]
[3,"GetGrantTrig",22,"22-31",3,"CheckBox",10,10]
[4,"MoveTrigs",32,null,4,"ListBox",10,10]
[5,"GetNumUnits",42,null,null,"InputBox",1,1]
[6,"GetLabLimit",43,null,null,"InputBox",1,1]
["Unit-Specific Question Macros: \"U\" & \"UNIT_Q Sheets"]
[1,"GetUnitType",11,"11-17",5,"OptionButton",7,1,null,"X"]
[2,"GetUnitAge",18,"18-24",6,"OptionButton",7,1]
[3,"GetUnitClean",25,"25-37",7,"CheckBox",13,13,null,"X"]
[4,"GetUnitFFail",38,null,null,"MsgBox",1,1,"X"]
[5,"GetUnitFFailAgain",39,null,null,"MsgBox",1,1,"X"]
[6,"GetUnitFAction",40,"40-44",8,"CheckBox",5,5,null,"X"]
[7,"GetUnitFCount",45,null,null,"InputBox",1,1]
[8,"GetUnitFLevels",46,"46-75",null,"InuptBox",1,30]
[9,"GetUnitWSFail",76,null,null,"MsgBox",1,1,"X"]
[10,"GetUnitWSFailAgain",77,null,null,"MsgBox",1,1,"X"]
[11,"GetUnitWSAction",78,"78-81",9,"CheckBox",4,4,null,"X"]
[12,"GetUnitWSCount",82,null,null,"InputBox",1,1]
[13,"GetUnitWSLevels",83,"83-112",null,"InuptBox",1,30]
[14,"GetUnitWTFail",113,null,null,"MsgBox",1,1,"X"]
[15,"GetUnitWSFailAgain",114,null,null,"MsgBox",1,1,"X"]
[16,"GetUnitWTAction",115,"115-119",10,"CheckBox",5,5,null,"X"]
[17,"GetUnitWTCount",120,null,null,"InputBox",1,1]
[18,"GetUnitWTLevels",121,"121-150",null,"InuptBox",1,30]
["Col B = used for Form captions; Col C = User displayed sheet questions (GEN-Q & UNIT_Q); Col D = Original questions used for Form prompt; Col E = picklists."]