{"text_format":"3","workbook":"xlsb","n_sheets":3,"sheets":["Housing Survey","Units","Macro Instructions"],"not_rendered":{"images":1,"macros":1,"defined_names":1},"read":"bin_skipped_in_rows","date_system":"1900","formulas":"cached_only","passed_over":{"ids":[37,38,1024],"n":330}}

{"sheet":"Housing Survey","index":0,"n_rows":77,"n_cols":22,"rows_kept":77,"merged":[[0,0,0,4],[1,0,1,4],[9,1,9,3],[10,0,10,3],[11,0,11,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,3],[20,0,20,3],[21,0,21,3],[22,0,22,3],[23,0,23,3],[25,0,25,4],[26,0,26,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[35,0,35,4],[38,0,38,4],[41,0,41,4],[42,0,42,4],[43,0,43,4],[44,0,44,4],[47,0,47,4],[51,0,51,4],[52,0,52,4],[55,0,55,4],[56,0,56,4],[69,0,71,0],[69,1,71,4],[69,5,71,5],[69,6,71,6],[69,7,71,7],[69,8,71,8],[69,9,71,9],[69,10,71,10],[69,11,71,11],[69,12,71,12],[69,13,71,13],[69,14,71,14],[69,15,71,15],[69,16,71,16],[69,17,71,17],[69,18,71,18],[69,19,71,19],[69,20,71,20],[69,21,71,21],[72,0,74,0],[72,1,74,4],[72,5,74,5],[72,6,74,6],[72,7,74,7],[72,8,74,8],[72,9,74,9],[72,10,74,10],[72,11,74,11],[72,12,74,12],[72,13,74,13],[72,14,74,14],[72,15,74,15],[72,16,74,16],[72,17,74,17],[72,18,74,18],[72,19,74,19],[72,20,74,20],[72,21,74,21]],"read":"bin_skipped_in_rows","flags":["formulas_cached_only","records_skipped"],"rows_in_doubt":{"n":0,"rows":[]},"rows_in_doubt_other":2}
["Consumer Price Index:  Housing Update Form "]
["PLEASE DELETE OR DESTROY AFTER USE"]
[null,"OMB No. 1220-0163"]
["BLS Contact:","<Data Collector's Name>"]
["Contact Phone:","<Data Collector's Phone #>"]
["Contact Fax:","<Data Collector's Fax #>"]
["Contact Email:","<Data Collector's Email>"]
["Please Return Form By:","<Date>"]
["Number of Units:",1]
["Address:",{"$nulls":3},"Unit:"]
[" "]
["Is this house/apartment occupied by the owner or is it rented?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["Is this house/apartment Public Housing?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["           If Yes, Is it owned or operated by a government agency?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["Is this house/apartment part of an assisted living program?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["           If Yes, Does the program provide ADL assistance to an occupant of this house/apartment?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["Is this house/apartment the primary residence of at least one of the occupants?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["Is anyone living in the household a relative of the landlord?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["How many bedrooms, baths, and other rooms are there?"]
["Bedrooms:",{"$nulls":4},"<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>"]
["Full Baths:",{"$nulls":4},"<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>"]
["Half Baths:",{"$nulls":4},"<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>"]
["Other Rooms (E.g., Kitchen, Living Room, Finished Basement, etc.):",{"$nulls":4},"<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>","<#>"]
["Total:",{"$nulls":4},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["In what year was this structure built? If the exact year is not known, the decade sufficient. ",{"$nulls":4},"<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>","<Enter Year>"]
[" Is this house/apartment under rent control?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["When did the person, who has lived in this house the longest, move in? ",{"$nulls":4},"<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>"]
["Do you/Does the tenant have a lease or other rental agreement?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["           If Yes, How long is the current lease agreement?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["           If Yes, and longer than month-to-month, in what month and year did the current lease start?",{"$nulls":4},"<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>","<Enter Month and Year>"]
["What is the tenant's name OR initials?",{"$nulls":4},"<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>","<Enter Name of Occupant>"]
["How much rent are you/is the tenant paying for this house now?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["What period of time does that rent cover?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["Is the rent lower because the Landlord receives a subsidy from a government program such as Section 8? ",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["          If Yes, how much was the subsidy?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["Is the rent lower because someone did work for the landlord?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["          If Yes, how much was the work reduction?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
[{"$nulls":3},"Total Rent:",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Does this rent include any optional extra charges?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["          If Yes, what is the amount of the extra charge?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["                    What is this extra charge for?",{"$nulls":4},"<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>","<Enter Name of Charge>"]
["Does the Landlord provide free off-street parking?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["Who pays for the water service?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["Who pays for the sewer service?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["Who pays for the electricity? ",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["          If this is paid by the Tenant, is the cost of electricity included in the rent you reported earlier?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["                    If Yes, how much is the charge for electricity for this house?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["What type of A/C equipment does this unit have?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["          If Thru-the-wall A/C, how many does this unit have?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["          If Window A/C, how many does this unit have?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["                    How many are provided by the Landlord?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["What is the primary type of heating fuel used by this unit?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["Who pays for the heating fuel?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["          If this is paid by the tenant, is the cost of heat fuel included in the rent you reported earlier?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["                    If Yes, how much is the charge for the heat fuel this house?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["What is the primary type of hot water fuel used by this unit?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["Who pays for the hot water fuel?",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["          If this is paid by the tenant, is the cost of hot water fuel included in the rent you reported earlier?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["                    If Yes, how much is the charge for the hot water fuel this house?",{"$nulls":4},"<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>","<Enter Amount>"]
["Please verify the house/apartment's structure type.",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["          If this is a multi unit structure, is there an elevator?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["For future data collection, would you prefer to be contacted by phone or email? ",{"$nulls":4},"<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>","<Select>"]
["          What is your preferred contact time? (E.g. weekdays between noon and 3:00PM)",{"$nulls":4},"<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>"]
["What is the best phone number or email address to contact you?",{"$nulls":4},"<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>"]
["Is there someone else that can answer these questions in the future, if you cannot be reached?",{"$nulls":4},"<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>","<Select Yes or No>"]
["          If Yes, what is this manager/authorized representative's name?",{"$nulls":4},"<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>","<Enter Manager/Rep.'s Name>"]
["                    What is this manager/authorized representative's phone number or email?",{"$nulls":4},"<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>","<Enter Phone or Email>"]
["                    What is this manager/authorized representative's preferred contact time?",{"$nulls":4},"<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>","<Enter Contact Time>"]
[]
["Additional Information:","The tenant's name is only used to denote occupancy changes, and is not required."]
[]
[]
["Respondent Comments:"]
[]
[]
[]
[{"$nulls":5},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17]

{"sheet":"Units","index":1,"n_rows":9,"n_cols":1,"rows_kept":9,"hidden":true,"flags":["formulas_cached_only"]}
["Number of Units "]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]

{"sheet":"Macro Instructions","index":2,"n_rows":33,"n_cols":2,"rows_kept":33,"hidden":true,"flags":["formulas_cached_only"]}
[]
["Here is the current Macro for the blank template:"]
["The only part that need to be changed are highlighted in red"]
[]
["Add Quote Macro:"]
["Sub AddQuotes()"]
[]
["    For x = 2 To Range(\"J1\") Step 1","Here \"J1\" refers to the cell where the \"number of quotes\" input is located. "]
["        Range(\"A6:H14\").Select","Here the range is the area of the shuttle form that you want copied (Be sure to always include a blank space after the last line so there is a break between quotes)"]
["        Selection.Copy"]
["        Range(\"A15\").Select","Here the range is refering to the spot where the next quote will start. In the blank template this would be A15."]
["        Selection.Insert Shift:=xlDown"]
["        Space (9)","Here 9 referes to the number of row each quote takes up;  simply imput the number of rows for each quote in the shuttle. This ensures that the macro knows how many row are needed when adding multiple quotes."]
["        "]
["    Next"]
[]
["    Range(\"I2\").Select"]
["    Selection.Delete"]
[]
["End Sub"]
[]
[]
["Delete Quote Macro:"]
["Sub DeleteQuote()"]
["'"]
["' DeleteQuote Macro"]
["'"]
[]
["'"]
["    Rows(\"14:22\").Select","Here insert the range that you would like to delete. In this case it would be the rows covered by the second quote. "]
["    Selection.Delete Shift:=xlUp"]
["    Range(\"A15\").Select","Here enter the cell for the start of the second quote"]
["End Sub"]