{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Notes","Data Entry Form","Input Values","Validation Rules","Entered Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes","index":0,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,2,41,15]]}
[]
[]
[]
[]
[null,null,"General Notes\n\nThis form provides a general data entry template consistent with the shoreline interview form as shown in Appendix D\n\nNote: the shoreline interview form does not include a Form Id number.  However, for the purpose of data entry it is likely that a unique id will be attached to each form and this data entry temple allows entry of a unique identifier in cell F3.\n\nTab \"Data Entry Form\" contains the data entry template\n          Column B describes the area on the form in which the required data is found\n          Column C provides a description of the variable\n          Column D provides a rudimentary description of the data to be entered\n          Column E provides a variable name that could be used in data analysis\n          Column F is the column in which data is entered  \n          Column G (Hidden) contains index values derived from pull down boxes when they are present.  \n          Column I contains validation rules.  The results of the validation rules are linked to conditional formatting rules that will highlight cells containing\n           invalid data\n                         Validation rules are not included for all variables\n                         Validation rules would need to be modified when additional values should be allowed (for instance if data entry protocol allows \n                         for codes designating missing data, response of \"Don't know\" or \"Refused\")\n          Column K (Hidden) temporarily contains data that will be written to the Entered Data tab.\n         Cell F68 will contain a value that depends on the evaluation of the validation rules\n                          It will read \"Check Data\"  if at least one data point does not pass the validation rules\n                               Review highlighted cells that contain suspect data and make changes if needed \n                               If after reviewing possible data errors, it is determined that the data is correct  \"Click on CRTL-A\" to copy data \n                          It will read \"Click on CRTL-A to copy data\" if the data is ready to be copied.  \n                                                CRTL-A invokes a macro that \n                                                (1) copies data from the Data Entry tab to the \"Entered Data\" tab and \n                                                (2) resets the \"Data Entry\" tab \n \nTab \"Input Values\" contains a number of values for variables that have known values and/or ranges. These include: \n          Field staff names\n          Site identifiers\n          State in which data was collected\n          Beginning and ending dates for sampling events\n          A list of names and abbreviations for US states and territories\n\nTab \"Entered Data\"  will contain data entered from each shoreline interview form"]

{"sheet":"Data Entry Form","index":1,"n_rows":68,"n_cols":190,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Data Source","Variable Description","Data Entry Notes","Variable Name","Enter Data in This Column",null,null,"Validation Rules"]
[null,null,"Unique Form ID",null,"formid",null,null,null,{"$f":"IF(F3=\"\",0,1)","v":0},null,{"$f":"IF(F3=\"\",\"\",F3)","v":""}]
[null,"Form Header","Name","Choose from pulldown","name",{"$f":"OFFSET('Input Values'!D2,'Data Entry Form'!G4,0)","v":"None Selected"},1,null,{"$f":"IF(OR(K4=\"\",K4=\"None Selected\"),0,1)","v":0},null,{"$f":"OFFSET('Input Values'!D2,'Data Entry Form'!G4,0)","v":"None Selected"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[null,"Form Header","Site Number and Name","Choose from pulldown","site",{"$f":"OFFSET('Input Values'!F2,'Data Entry Form'!G5,0)","v":"None Selected"},1,null,{"$f":"IF(OR(K5=\"\",K5=\"None Selected\"),0,1)","v":0},null,{"$f":"OFFSET('Input Values'!F2,'Data Entry Form'!G5,0)","v":"None Selected"}]
[null,"Form Header","Date","Enter date mm/dd/yyyy","date",null,null,null,{"$f":"IF(OR(AND(F6>='Input Values'!O3,F6<='Input Values'!O4),F6=\"\"),1,0)","v":1},null,{"$f":"IF(F6=\"\",\"\",F6)","v":""}]
[null,"Form Header","State","Choose from pulldown","state",null,1,null,{"$f":"IF(OR(K7=\"\",K7=\"None Selected\"),0,1)","v":0},null,{"$f":"OFFSET('Input Values'!H2,'Data Entry Form'!G7,0)","v":"None Selected"}]
[null,"Form Header","Nonresponse","1=Refusal - no questions answered\n2=Refusal - 1+ questions answered\n3=Ineligible due to age < 16\n4=Language barrier\n5=Respondent not approachable\n6=Other/Unclear reason","interviewendreason",null,null,null,{"$f":"IF(OR(AND(F8<=6,F8>=1),F8=\"\"),1,0)","v":1},null,{"$f":"IF(F8=\"\",\"\",F8)","v":""}]
[null,"Form Header","Nonresponse If Other Is Specified","Enter text from form","interviewendreasonother",null,null,null,null,null,""]
[null,"Form Header","Gender","1=male, 2=female","respgender",null,null,null,{"$f":"IF(OR(F10=1,F10=2,ISBLANK(F10)),1,0)","v":1},null,""]
[null,"Form Header","Interview Time",null,"time",null,null,null,{"$f":"IF(F11=\"\",1,    IF(LEFT(RIGHT(F11,3),1)<>\":\",0,         IF( OR( LEN(F11)<4,  LEN(F11)>5 ),0,    IF(  ISERROR( VALUE(RIGHT(F11,2)) ),0,    IF(  ISERROR(VALUE(LEFT(F11,FIND(\":\",F11)-1))),0,                        IF( VALUE(RIGHT(F11,2)) >60,0,1)                   )                           ) ) ))","v":1},null,""]
[null,"Form Header","AM or PM",null,"ampm",null,null,null,{"$f":"IF(OR(F12=\"am\",F12=\"pm\",F12=\"\"),1,0)","v":1},null,""]
[null,"Form Header","Interview Location Is Sandy Beach","0=no, 1=yes","intplacebeach",null,null,null,{"$f":"IF(OR(F13=0,F13=1,F13=\"\"),1,0)","v":1},null,""]
[null,"Form Header","Interview Location Is Pier","0=no, 1=yes","intplacepier",null,null,null,{"$f":"IF(OR(F14=0,F14=1,F14=\"\"),1,0)","v":1},null,""]
[null,"Form Header","Interview Location Is Pavement Area","0=no, 1=yes","intplacepave",null,null,null,{"$f":"IF(OR(F15=0,F15=1,F15=\"\"),1,0)","v":1},null,""]
[null,"Form Header","Interview Location Is Boardwalk","0=no, 1=yes","intplaceboard",null,null,null,1,null,""]
[null,"Form Header","Interview Location Is Other","0=no, 1=yes","intplaceother",null,null,null,1,null,""]
[null,"Form Header","Interview Location If Other Is Specified",null,"intplaceothertxt",null,null,null,null,null,""]
[null,"Form Header","Frequency At Which Interviews Are Conducted","1=Every\n2=every 3rd\n3=every 5th\n4=every 10th\n5=other","uiintfreq",null,null,null,{"$f":"IF(OR(F19=1,F19=2,F19=3,F19=4,F19=5,F19=\"\"),1,0)","v":1},null,""]
[null,"Form Header","Interview Frequency If Other Is Specified","Enter text from form","uiintfreqoth",null,null,null,null,null,""]
[null,"Q1_1","Sunbathing","1=yes, 0=no","sunbathing",null,null,null,{"$f":"IF(OR(F21=0,F21=1,F21=\"\"),1,0)","v":1},null,""]
[null,"Q1_2","Swimming","1=yes, 0=no","swimming",null,null,null,{"$f":"IF(OR(F22=0,F22=1,F22=\"\"),1,0)","v":1},null,""]
[null,"Q1_3","Walking","1=yes, 0=no","walking",null,null,null,1,null,""]
[null,"Q1_4","Sightseeing","1=yes, 0=no","sightseeing",null,null,null,1,null,""]
[null,"Q1_5","Wildlife Viewing","1=yes, 0=no","wildlife",null,null,null,1,null,""]
[null,"Q1_6","Hiking","1=yes, 0=no","hiking",null,null,null,1,null,""]
[null,"Q1_7","Picnic","1=yes, 0=no","picnic",null,null,null,1,null,""]
[null,"Q1_8","Canoe","1=yes, 0=no","canoe",null,null,null,1,null,""]
[null,"Q1_9","Fishing","1=yes, 0=no","fishing",null,null,null,1,null,""]
[null,"Q1_10","Shell Fishing","1=yes, 0=no","shellfishing",null,null,null,1,null,""]
[null,"Q1_11","Crabbing","1=yes, 0=no","crabbing",null,null,null,1,null,""]
[null,"Q1_12","Boating","1=yes, 0=no","boating",null,null,null,1,null,""]
[null,"Q1_13","Some Other Activity","1=yes, 0=no","actother",null,null,null,1,null,""]
[null,"Q1_13","If Some Other Activity, Then Description Of Other Activity","Enter text from form","actothertxt",null,null,null,null,null,""]
[null,"Q2","Time When Respondent Arrived At Site",null,"arrivetime",null,null,null,{"$f":"IF(F35=\"\",1,    IF(LEFT(RIGHT(F35,3),1)<>\":\",0,         IF( OR( LEN(F35)<4,  LEN(F35)>5 ),0,    IF(  ISERROR( VALUE(RIGHT(F35,2)) ),0,    IF(  ISERROR(VALUE(LEFT(F35,FIND(\":\",F35)-1))),0,                        IF( VALUE(RIGHT(F35,2)) >60,0,1)                   )                           ) ) ))","v":1},{"$f":"IF(F35=\"\",1,    IF(LEFT(RIGHT(F35,3),1)<>\":\",0,         IF( OR( LEN(F35)<4,  LEN(F35)>5 ),0,    IF(  ISERROR( VALUE(RIGHT(F35,2)) ),0,    IF(  ISERROR(VALUE(LEFT(F35,FIND(\":\",F35)-1))),0,1 )                           ) ) ))","v":1},""]
[null,"Q2","Am Or Pm",null,"atampm",null,null,null,{"$f":"IF(OR(F36=\"am\",F36=\"pm\",ISBLANK(F36)),1,0)","v":1},null,""]
[null,"Q2","Arrive Time Text If No Specific Time Is Written",null,"atcomment",null,null,null,null,null,""]
[null,"Q3","Number Of Hours Respondent Expects To Remain At Site",null,"durhrs",null,null,null,{"$f":"IF(F38=\"\",1,       IF(F38<0,0, 1    ) )","v":1},null,""]
[null,"Q3","Number Of Minutes Respondent Expects To Remain At Site",null,"durmins",null,null,null,{"$f":"IF(F39=\"\",1,       IF(F39<0,0, 1    ) )","v":1},null,""]
[null,"Q3","Duration Of Time Respondent Expects To Remain At Site If Specific Values Not Written (“Duration Comments”)",null,"duroth",null,null,null,null,null,""]
[null,"Q4","Will Trip Last More Than One Day? (Multi-Day Trip)","1=yes, 2=no","mdtrip",null,null,null,{"$f":"IF(OR(F41=1,F41=2,F41=\"\"),1,0)","v":1},null,""]
[null,"Q4a","How Many Days Will Multi-Day Trip Last In Total Or Low End Of Range",null,"mdtripdur",null,null,null,{"$f":"IF(F42<0,0,   IF(F42>365,0,    IF(F42=\"\",1,0)                      )                 )","v":1},null,""]
[null,"Q4a","Multi-Day Trip - High End Of Range If Present",null,"mdtripdurhigh",null,null,null,{"$f":"IF(F43=\"\",1,       IF(F43<=0,0,     IF(F43>365,0,1)         ) )","v":1},null,""]
[null,"Q4a","Multi-Day Trip - Low End Of Range If Present",null,"mdtripdurlow",null,null,null,{"$f":"IF(F44=\"\",1,       IF(F44<=0,0,     IF(F44>365,0,1)         ) )","v":1},null,""]
[null,"Q4a","Multi-Day Trip Duration Comment If Present (“Multi-Day Trip Duration Comment”)","Enter text from form","mdtripdurcom",null,null,null,null,null,""]
[null,"Q4b","Is Purpose Of Multi-Day Trip Recreation?","1=yes, 2=no","mdtriprec",null,null,null,{"$f":"IF(OR(F46=1,F46=2,F46=\"\"),1,0)","v":1},null,""]
[null,"Q5","Aware Of Oil Spill Before Today?","1=aware, 2=unaware","spillaware",null,null,null,{"$f":"IF(OR(F47=1,F47=2,F47=\"\"),1,0)","v":1},null,""]
[null,"Q6","Did Spill Affect Where You Decided To Go Today","1=did affect, 2=did not affect","spillloc",null,null,null,{"$f":"IF(OR(F48=1,F48=2,F48=\"\"),1,0)","v":1},null,""]
[null,"Q6a","Where Would Respondent Have Gone Had Spill Not Occurred","Enter text from form","slalt",null,null,null,null,null,""]
[null,"Q7","Did Spill Affect What Respondent Decided To Do On Trip","1=did affect, 2=did not affect","spillactivity",null,null,null,{"$f":"IF(OR(F50=1,F50=2,F50=\"\"),1,0)","v":1},null,""]
[null,"Q7a","How Did Spill Affect What Respondent Decided To Do","Enter text from form","saaffect",null,null,null,null,null,""]
[null,"Q8","Condition Of Beach Better, Worse, About The Same As Before","1=better\n2=worse\n3=same\n4=don't know","beachcond",null,null,null,{"$f":"IF(OR(F52=1,F52=2,F52=3,F52=4,F52=\"\"),1,0)","v":1},null,""]
[null,"Q9_1","Condition Worse: More Oil Or Tar Balls","1=yes, 0=no","condworse1",null,null,null,{"$f":"IF(OR(F53=0,F53=1,F53=\"\"),1,0)","v":1},null,""]
[null,"Q9_2","Condition Worse: Appearance Or Odor","1=yes, 0=no","condworse2",null,null,null,{"$f":"IF(OR(F54=0,F54=1,F54=\"\"),1,0)","v":1},null,""]
[null,"Q9_3","Condition Worse: Impact On Fishing Or Wildlife","1=yes, 0=no","condworse3",null,null,null,1,null,""]
[null,"Q9_4","Condition Worse: Lower Quality Recreation","1=yes, 0=no","condworse4",null,null,null,1,null,""]
[null,"Q9_5","Condition Worse: Human Health Impacts","1=yes, 0=no","condworse5",null,null,null,1,null,""]
[null,"Q9_6","Condition Worse: Other","1=yes, 0=no","condworse6",null,null,null,1,null,""]
[null,"Q9_6","If Condition Worse Is \"Other\" Than Description Of Other","Enter text from form","condworse6txt",null,null,null,null,null,""]
[null,"Q9_7","Condition Worse: Don't Know","1=yes, 0=no","condworse7",null,null,null,{"$f":"IF(OR(F60=0,F60=1,F60=\"\"),1,0)","v":1},null,""]
[null,"Q10","How Long Until The Beach Will Be The Same As Before Spill?","Enter number from form","conddur",null,null,null,{"$f":"IF(ISERROR(VALUE(F61)),0,1)","v":1},null,""]
[null,"Q10","Condition Duration Units","1=weeks\n2=months\n3=years","conddurunits",null,null,null,{"$f":"IF(OR(F62=1,F62=2,F62=3,F62=\"\"),1,0)","v":1},null,""]
[null,"Q10","Condition Duration Comment ","Enter text from form","conddurcomment",null,null,null,null,null,""]
[null,"Q11","Respondent Town","Enter text from form","resptown",null,null,null,null,null,""]
[null,"Q11","Respondent State","Use pulldown list","respstate",null,1,null,{"$f":"IF(OR(K65=\"\",K65=\"None Selected\"),0,1)","v":0},null,{"$f":"OFFSET('Input Values'!J2,'Data Entry Form'!G65,1)","v":"None Selected"}]
[null,"Q11","Respondent Country","Enter text from form","respcountry",null,null,null,null,null,{"$f":"IF(F66=\"\",\"\",F66)","v":""}]
[null,"Q11","Respondent Zip code","Enter text from form","resppostcode",null,null,null,null,null,""]
[null,null,null,null,null,{"$f":"IF(MIN(I4:I67)=0,\"CHECK DATA\",\"Click on CRTL-A to copy data\")","v":"CHECK DATA"}]

{"sheet":"Input Values","index":2,"n_rows":203,"n_cols":16,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Interview Names",null,"Site List",null,"States sampled",null,"States and Territories"]
[null,null,null,"None Selected",null,"None Selected",null,"None Selected",null,"None Selected","None Selected",null,null,null,"2017-03-01","Sampling Start Date"]
[null,null,null,"Interviewer 1",null,"Segment 1",null,"FL",null,"Alabama","AL",null,null,null,"2017-06-01","Sampling End Date"]
[null,null,null,"Interviewer 2",null,"Segment 2",null,"AL",null,"Alaska","AK"]
[null,null,null,"Interviewer 3",null,"Segment 3",null,"MS",null,"Arizona","AZ"]
[null,null,null,"Interviewer 4",null,"Segment 4",null,"LA",null,"Arkansas","AR"]
[null,null,null,"Interviewer 5",null,"Segment 5",null,"TX",null,"California","CA"]
[null,null,null,"Interviewer 6",null,"Segment 6",null,null,null,"Colorado","CO"]
[null,null,null,"Interviewer 7",null,"Segment 7",null,null,null,"Connecticut","CT"]
[null,null,null,"Interviewer 8",null,"Segment 8",null,null,null,"Delaware","DE"]
[null,null,null,"Interviewer 9",null,"Segment 9",null,null,null,"Florida","FL"]
[null,null,null,"Interviewer 10",null,"Segment 10",null,null,null,"Georgia","GA"]
[null,null,null,"Interviewer 11",null,"Segment 11",null,null,null,"Hawaii","HI"]
[null,null,null,"Interviewer 12",null,"Segment 12",null,null,null,"Idaho","ID"]
[null,null,null,"Interviewer 13",null,"Segment 13",null,null,null,"Illinois","IL"]
[null,null,null,"Interviewer 14",null,"Segment 14",null,null,null,"Indiana","IN"]
[null,null,null,"Interviewer 15",null,"Segment 15",null,null,null,"Iowa","IA"]
[null,null,null,"Interviewer 16",null,"Segment 16",null,null,null,"Kansas","KS"]
[null,null,null,"Interviewer 17",null,"Segment 17",null,null,null,"Kentucky","KY"]
[null,null,null,"Interviewer 18",null,"Segment 18",null,null,null,"Louisiana","LA"]
[null,null,null,"Interviewer 19",null,"Segment 19",null,null,null,"Maine","ME"]
[null,null,null,"Interviewer 20",null,"Segment 20",null,null,null,"Maryland","MD"]
[null,null,null,"Interviewer 21",null,"Segment 21",null,null,null,"Massachusetts","MA"]
[null,null,null,"Interviewer 22",null,"Segment 22",null,null,null,"Michigan","MI"]
[null,null,null,"Interviewer 23",null,"Segment 23",null,null,null,"Minnesota","MN"]
[null,null,null,"Interviewer 24",null,"Segment 24",null,null,null,"Mississippi","MS"]
[null,null,null,"Interviewer 25",null,"Segment 25",null,null,null,"Missouri","MO"]
[null,null,null,"Interviewer 26",null,"Segment 26",null,null,null,"Montana","MT"]
[null,null,null,"Interviewer 27",null,"Segment 27",null,null,null,"Nebraska","NE"]
[null,null,null,"Interviewer 28",null,"Segment 28",null,null,null,"Nevada","NV"]
[null,null,null,"Interviewer 29",null,"Segment 29",null,null,null,"New Hampshire","NH"]
[null,null,null,"Interviewer 30",null,"Segment 30",null,null,null,"New Jersey","NJ"]
[null,null,null,"Interviewer 31",null,"Segment 31",null,null,null,"New Mexico","NM"]
[null,null,null,"Interviewer 32",null,"Segment 32",null,null,null,"New York","NY"]
[null,null,null,"Interviewer 33",null,"Segment 33",null,null,null,"North Carolina","NC"]
[null,null,null,"Interviewer 34",null,"Segment 34",null,null,null,"North Dakota","ND"]
[null,null,null,"Interviewer 35",null,"Segment 35",null,null,null,"Ohio","OH"]
[null,null,null,"Interviewer 36",null,"Segment 36",null,null,null,"Oklahoma","OK"]
[null,null,null,"Interviewer 37",null,"Segment 37",null,null,null,"Oregon","OR"]
[null,null,null,"Interviewer 38",null,"Segment 38",null,null,null,"Pennsylvania","PA"]
[null,null,null,"Interviewer 39",null,"Segment 39",null,null,null,"Rhode Island","RI"]
[null,null,null,"Interviewer 40",null,"Segment 40",null,null,null,"South Carolina","SC"]
[null,null,null,"Interviewer 41",null,"Segment 41",null,null,null,"South Dakota","SD"]
[null,null,null,"Interviewer 42",null,"Segment 42",null,null,null,"Tennessee","TN"]
[null,null,null,"Interviewer 43",null,"Segment 43",null,null,null,"Texas","TX"]
[null,null,null,"Interviewer 44",null,"Segment 44",null,null,null,"Utah","UT"]
[null,null,null,"Interviewer 45",null,"Segment 45",null,null,null,"Vermont","VT"]
[null,null,null,"Interviewer 46",null,"Segment 46",null,null,null,"Virginia","VA"]
[null,null,null,"Interviewer 47",null,"Segment 47",null,null,null,"Washington","WA"]
[null,null,null,"Interviewer 48",null,"Segment 48",null,null,null,"West Virginia","WV"]
[null,null,null,"Interviewer 49",null,"Segment 49",null,null,null,"Wisconsin","WI"]
[null,null,null,"Interviewer 50",null,"Segment 50",null,null,null,"Wyoming","WY"]
[null,null,null,"Interviewer 51",null,"Segment 51",null,null,null,"Commonwealth/Territory:","Abbreviation:"]
[null,null,null,"Interviewer 52",null,"Segment 52",null,null,null,"American Samoa","AS"]
[null,null,null,"Interviewer 53",null,"Segment 53",null,null,null,"District of Columbia","DC"]
[null,null,null,"Interviewer 54",null,"Segment 54",null,null,null,"Federated States of Micronesia","FM"]
[null,null,null,"Interviewer 55",null,"Segment 55",null,null,null,"Guam","GU"]
[null,null,null,"Interviewer 56",null,"Segment 56",null,null,null,"Marshall Islands","MH"]
[null,null,null,"Interviewer 57",null,"Segment 57",null,null,null,"Northern Mariana Islands","MP"]
[null,null,null,"Interviewer 58",null,"Segment 58",null,null,null,"Palau","PW"]
[null,null,null,"Interviewer 59",null,"Segment 59",null,null,null,"Puerto Rico","PR"]
[null,null,null,"Interviewer 60",null,"Segment 60",null,null,null,"Virgin Islands","VI"]
[null,null,null,"Interviewer 61",null,"Segment 61"]
[null,null,null,"Interviewer 62",null,"Segment 62"]
[null,null,null,"Interviewer 63",null,"Segment 63"]
[null,null,null,"Interviewer 64",null,"Segment 64"]
[null,null,null,"Interviewer 65",null,"Segment 65"]
[null,null,null,"Interviewer 66",null,"Segment 66"]
[null,null,null,"Interviewer 67",null,"Segment 67"]
[null,null,null,"Interviewer 68",null,"Segment 68"]
[null,null,null,"Interviewer 69",null,"Segment 69"]
[null,null,null,"Interviewer 70",null,"Segment 70"]
[null,null,null,"Interviewer 71",null,"Segment 71"]
[null,null,null,"Interviewer 72",null,"Segment 72"]
[null,null,null,"Interviewer 73",null,"Segment 73"]
[null,null,null,"Interviewer 74",null,"Segment 74"]
[null,null,null,"Interviewer 75",null,"Segment 75"]
[null,null,null,"Interviewer 76",null,"Segment 76"]
[null,null,null,"Interviewer 77",null,"Segment 77"]
[null,null,null,"Interviewer 78",null,"Segment 78"]
[null,null,null,"Interviewer 79",null,"Segment 79"]
[null,null,null,"Interviewer 80",null,"Segment 80"]
[null,null,null,"Interviewer 81",null,"Segment 81"]
[null,null,null,"Interviewer 82",null,"Segment 82"]
[null,null,null,"Interviewer 83",null,"Segment 83"]
[null,null,null,"Interviewer 84",null,"Segment 84"]
[null,null,null,"Interviewer 85",null,"Segment 85"]
[null,null,null,"Interviewer 86",null,"Segment 86"]
[null,null,null,"Interviewer 87",null,"Segment 87"]
[null,null,null,"Interviewer 88",null,"Segment 88"]
[null,null,null,"Interviewer 89",null,"Segment 89"]
[null,null,null,"Interviewer 90",null,"Segment 90"]
[null,null,null,"Interviewer 91",null,"Segment 91"]
[null,null,null,"Interviewer 92",null,"Segment 92"]
[null,null,null,"Interviewer 93",null,"Segment 93"]
[null,null,null,"Interviewer 94",null,"Segment 94"]
[null,null,null,"Interviewer 95",null,"Segment 95"]
[null,null,null,"Interviewer 96",null,"Segment 96"]
[null,null,null,"Interviewer 97",null,"Segment 97"]
[null,null,null,"Interviewer 98",null,"Segment 98"]
[null,null,null,"Interviewer 99",null,"Segment 99"]
[null,null,null,"Interviewer 100",null,"Segment 100"]
[null,null,null,"Interviewer 101",null,"Segment 101"]
[null,null,null,"Interviewer 102",null,"Segment 102"]
[null,null,null,"Interviewer 103",null,"Segment 103"]
[null,null,null,"Interviewer 104",null,"Segment 104"]
[null,null,null,"Interviewer 105",null,"Segment 105"]
[null,null,null,"Interviewer 106",null,"Segment 106"]
[null,null,null,"Interviewer 107",null,"Segment 107"]
[null,null,null,"Interviewer 108",null,"Segment 108"]
[null,null,null,"Interviewer 109",null,"Segment 109"]
[null,null,null,"Interviewer 110",null,"Segment 110"]
[null,null,null,"Interviewer 111",null,"Segment 111"]
[null,null,null,"Interviewer 112",null,"Segment 112"]
[null,null,null,"Interviewer 113",null,"Segment 113"]
[null,null,null,"Interviewer 114",null,"Segment 114"]
[null,null,null,"Interviewer 115",null,"Segment 115"]
[null,null,null,"Interviewer 116",null,"Segment 116"]
[null,null,null,"Interviewer 117",null,"Segment 117"]
[null,null,null,"Interviewer 118",null,"Segment 118"]
[null,null,null,null,null,"Segment 119"]
[null,null,null,null,null,"Segment 120"]
[null,null,null,null,null,"Segment 121"]
[null,null,null,null,null,"Segment 122"]
[null,null,null,null,null,"Segment 123"]
[null,null,null,null,null,"Segment 124"]
[null,null,null,null,null,"Segment 125"]
[null,null,null,null,null,"Segment 126"]
[null,null,null,null,null,"Segment 127"]
[null,null,null,null,null,"Segment 128"]
[null,null,null,null,null,"Segment 129"]
[null,null,null,null,null,"Segment 130"]
[null,null,null,null,null,"Segment 131"]
[null,null,null,null,null,"Segment 132"]
[null,null,null,null,null,"Segment 133"]
[null,null,null,null,null,"Segment 134"]
[null,null,null,null,null,"Segment 135"]
[null,null,null,null,null,"Segment 136"]
[null,null,null,null,null,"Segment 137"]
[null,null,null,null,null,"Segment 138"]
[null,null,null,null,null,"Segment 139"]
[null,null,null,null,null,"Segment 140"]
[null,null,null,null,null,"Segment 141"]
[null,null,null,null,null,"Segment 142"]
[null,null,null,null,null,"Segment 143"]
[null,null,null,null,null,"Segment 144"]
[null,null,null,null,null,"Segment 145"]
[null,null,null,null,null,"Segment 146"]
[null,null,null,null,null,"Segment 147"]
[null,null,null,null,null,"Segment 148"]
[null,null,null,null,null,"Segment 149"]
[null,null,null,null,null,"Segment 150"]
[null,null,null,null,null,"Segment 151"]
[null,null,null,null,null,"Segment 152"]
[null,null,null,null,null,"Segment 153"]
[null,null,null,null,null,"Segment 154"]
[null,null,null,null,null,"Segment 155"]
[null,null,null,null,null,"Segment 156"]
[null,null,null,null,null,"Segment 157"]
[null,null,null,null,null,"Segment 158"]
[null,null,null,null,null,"Segment 159"]
[null,null,null,null,null,"Segment 160"]
[null,null,null,null,null,"Segment 161"]
[null,null,null,null,null,"Segment 162"]
[null,null,null,null,null,"Segment 163"]
[null,null,null,null,null,"Segment 164"]
[null,null,null,null,null,"Segment 165"]
[null,null,null,null,null,"Segment 166"]
[null,null,null,null,null,"Segment 167"]
[null,null,null,null,null,"Segment 168"]
[null,null,null,null,null,"Segment 169"]
[null,null,null,null,null,"Segment 170"]
[null,null,null,null,null,"Segment 171"]
[null,null,null,null,null,"Segment 172"]
[null,null,null,null,null,"Segment 173"]
[null,null,null,null,null,"Segment 174"]
[null,null,null,null,null,"Segment 175"]
[null,null,null,null,null,"Segment 176"]
[null,null,null,null,null,"Segment 177"]
[null,null,null,null,null,"Segment 178"]
[null,null,null,null,null,"Segment 179"]
[null,null,null,null,null,"Segment 180"]
[null,null,null,null,null,"Segment 181"]
[null,null,null,null,null,"Segment 182"]
[null,null,null,null,null,"Segment 183"]
[null,null,null,null,null,"Segment 184"]
[null,null,null,null,null,"Segment 185"]
[null,null,null,null,null,"Segment 186"]
[null,null,null,null,null,"Segment 187"]
[null,null,null,null,null,"Segment 188"]
[null,null,null,null,null,"Segment 189"]
[null,null,null,null,null,"Segment 190"]
[null,null,null,null,null,"Segment 191"]
[null,null,null,null,null,"Segment 192"]
[null,null,null,null,null,"Segment 193"]
[null,null,null,null,null,"Segment 194"]
[null,null,null,null,null,"Segment 195"]
[null,null,null,null,null,"Segment 196"]
[null,null,null,null,null,"Segment 197"]
[null,null,null,null,null,"Segment 198"]
[null,null,null,null,null,"Segment 199"]
[null,null,null,null,null,"Segment 200"]

{"sheet":"Validation Rules","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Entered Data","index":4,"n_rows":66,"n_cols":1,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
["Variable Name"]
["formid"]
["name"]
["site"]
["date"]
["state"]
["interviewendreason"]
["interviewendreasonother"]
["respgender"]
["time"]
["ampm"]
["intplacebeach"]
["intplacepier"]
["intplacepave"]
["intplaceboard"]
["intplaceother"]
["intplaceothertxt"]
["uiintfreq"]
["uiintfreqoth"]
["sunbathing"]
["swimming"]
["walking"]
["sightseeing"]
["wildlife"]
["hiking"]
["picnic"]
["canoe"]
["fishing"]
["shellfishing"]
["crabbing"]
["boating"]
["actother"]
["actothertxt"]
["arrivetime"]
["atampm"]
["atcomment"]
["durhrs"]
["durmins"]
["duroth"]
["mdtrip"]
["mdtripdur"]
["mdtripdurhigh"]
["mdtripdurlow"]
["mdtripdurcom"]
["mdtriprec"]
["spillaware"]
["spillloc"]
["slalt"]
["spillactivity"]
["saaffect"]
["beachcond"]
["condworse1"]
["condworse2"]
["condworse3"]
["condworse4"]
["condworse5"]
["condworse6"]
["condworse6txt"]
["condworse7"]
["conddur"]
["conddurunits"]
["conddurcomment"]
["resptown"]
["respstate"]
["respcountry"]
["resppostcode"]