{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["StartHere","SamplingPlan","IncomingCount","TopOfHourCount","Statistics","ExtrapolationFactors","Admin"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":2},"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":"StartHere","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"SamplingPlan","index":1,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,3],[8,11,10,15],[11,11,12,15]]}
[]
[null,"There are 4 steps included on this page. Start with Step 1, below, and then scroll to the right for the other steps."]
[]
["Step 1: Start by entering parameters for sampling below:",null,null,null,null,"Step 2: Use the drop-down lists to enter your sampling plans below:",null,null,null,null,null,"Step 3: Click on the \"Generate Entry Forms\" button, to populate the data entry sheets."]
[null,"Enter distinct types of sites:",null,"Enter dates that sampling occurs:",null,"To add a new row, enter the next consecutive number under \"Sample Plan #\"",null,null,null,null,null,"Next, go to the IncomingCount and TopOfHourCount sheets to enter your counts."]
[null,"Site Types (up to 6)",null,"Sampling Dates (m/d/y)",null,"Sample Plan #","Site Name","Site Type","Sampling Date","Sampling Window"]
[null,"park",null,43299,null,{"$f":"SUM(F6,1)","v":1},"Salter Grove SP","park",43299,"12:00PM - 4:00PM"]
[null,"fishing access",null,43301,null,2,"Passeonkquis Cove","fishing access",43299,"12:00PM - 4:00PM"]
[null,"beach",null,43314,null,{"$f":"SUM(F8,1)","v":3},"NK Town Beach","beach",43301,"12:00PM - 4:00PM",null,"Step 4: After entering data in the IncomingCount and TopOfHourCount sheets, click the \"Refresh Calculations\" button below to recalculate."]
[null,null,null,null,null,{"$f":"SUM(F9,1)","v":4},"Fort Adams Beach","beach",43301,"12:00PM - 4:00PM"]
[null,null,null,null,null,{"$f":"SUM(F10,1)","v":5},"Oakland Beach","beach",43314,"12:00PM - 4:00PM"]
[null,null,null,null,null,null,null,null,null,null,null,"Then, go to the Statistics sheet to view site and overall statistics or to the ExtrapolationFactors sheet to view the extrapolation factors calculated using your data."]
[]
[null,"Enter activities monitored:"]
[null,"Activities (up to 8)"]
[null,"chilling"]
[null,"kayak/SUP/rowing"]
[null,"other boating"]
[null,"fishing from shore"]
[null,"fishing from boat"]
[null,"walk-by"]
[null,"other  "]
[]
[]
[null,"Enter site names:"]
[null,"Site Names"]
[null,"Salter Grove SP"]
[null,"Passeonkquis Cove"]
[null,"NK Town Beach"]
[null,"Fort Adams Beach"]
[null,"Oakland Beach"]

{"sheet":"IncomingCount","index":2,"n_rows":44,"n_cols":41,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Sample Plan #","Date","Site Name","Site Type","Count Type","Activity","Counting Range","Starting\nCount","5:00-5:29am","5:30-5:59am","6:00-6:29am","6:30-6:59am","7:00-7:29am","7:30-7:59am","8:00-8:29am","8:30-8:59am","9:00-9:29am","9:30-9:59am","10:00-10:29am","10:30-10:59am","11:00-11:29am","11:30-11:59am","Noon-12:29pm","12:30-12:59pm","1:00-1:29pm","1:30-1:59pm","2:00-2:29pm","2:30-2:59pm","3:00-3:29pm","3:30-3:59pm","4:00-4:29pm","4:30-4:59pm","5:00-5:29pm","5:30-5:59pm","6:00-6:29pm","6:30-6:59pm","7:00-7:29pm","7:30-7:59pm","Total In\nfor Activity"]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","chilling",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,3,1,7,6,5,4,4,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":43}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","kayak/SUP/rowing",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","other boating",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","fishing from shore",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":3}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","fishing from boat",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","walk-by",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People","other  ",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[1,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"Cars",null,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,6,6,7,10,7,5,8,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":55}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","chilling",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,1,0,1,0,0,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":3}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","kayak/SUP/rowing",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":1}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","other boating",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":1}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","fishing from shore",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","fishing from boat",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","walk-by",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People","other  ",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[2,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"Cars",null,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,5,2,0,1,9,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":18}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","chilling",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,28,16,27,34,41,22,48,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":314}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","kayak/SUP/rowing",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":3}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","other boating",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","fishing from shore",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","fishing from boat",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","walk-by",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","other  ",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[3,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"Cars",null,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,23,19,18,24,28,24,11,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":228}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","chilling",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},105,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,4,8,4,14,6,27,7,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":180}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","kayak/SUP/rowing",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":2}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","other boating",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","fishing from shore",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","fishing from boat",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","walk-by",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","other  ",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[4,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43301},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"Cars",null,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4,5,3,2,6,3,3,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":45},null,"Note: 1 schoolbus with camp kids"]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","chilling",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},{"$f":"19+47+76","v":142},null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"4+18+37","v":59},35,73,53,75,48,47,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":535}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","kayak/SUP/rowing",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","other boating",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","fishing from shore",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":4}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","fishing from boat",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","walk-by",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,6,5,3,2,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":18}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People","other  ",{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},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,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":0}]
[5,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),4,FALSE)","v":43314},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"Cars",null,{"$f":"VLOOKUP(IncomingCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},102,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,65,54,93,72,75,57,67,null,null,null,null,null,null,null,null,{"$f":"SUM(IncomingCount[[#This Row],[Starting\nCount]:[7:30-7:59pm]])","v":585}]

{"sheet":"TopOfHourCount","index":3,"n_rows":14,"n_cols":22,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Sample Plan #","Date","Site Name","Site Type","Count Type","Counting Range","5:00 AM","6:00 AM","7:00 AM","8:00 AM","9:00 AM","10:00 AM","11:00 AM","12:00 PM","1:00 PM","2:00 PM","3:00 PM","4:00 PM","5:00 PM","6:00 PM","7:00 PM","8:00 PM"]
[1,{"$f":"VLOOKUP(A5,INDIRECT(\"SamplePlan\"),4,FALSE)","v":43299},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"People",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,13,13,11,6]
[1,43299,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Salter Grove SP"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"park"},"Cars",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,9,7,5,4]
[2,43299,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"People",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,0,1,1,1]
[2,43299,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Passeonkquis Cove"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"fishing access"},"Cars",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,0,3,3,2]
[3,43301,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,78,93,89,110,94]
[3,43301,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"NK Town Beach"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"Cars",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,60,61,65,63,53]
[4,43301,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,112,31,22,40]
[4,43301,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Fort Adams Beach"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"Cars",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,22,21,20,19]
[5,43314,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"People",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,137,200,207,172]
[5,43314,{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),2,FALSE)","v":"Oakland Beach"},{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),3,FALSE)","v":"beach"},"Cars",{"$f":"VLOOKUP(TopOfHourCount[[#This Row],[Sample Plan '#]],INDIRECT(\"SamplePlan\"),5,FALSE)","v":"12:00PM - 4:00PM"},null,null,null,null,null,null,null,null,105,120,112,107]

{"sheet":"Statistics","index":4,"n_rows":39,"n_cols":23,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Overall Activity Statistic",null,null,null,null,"Site Activity Statistics",null,null,null,null,null,"Site People Per Car"]
[]
[null,null,null,null,null,null,null,null,"Row Labels","% People Doing Activity",null,null,null,"Date","Site Name","Activity","% People Doing Activity (Counted)",null,null,"Date","Site Name","People Per Car (Counted)","People Per Car (Estimated)"]
[null,null,null,null,null,null,null,null,"chilling",0.97109304426377596,null,null,null,43299,"Salter Grove SP","chilling",0.934782608695652,null,null,43299,"Salter Grove SP",0.83636363636363631,0.95174904927067261]
[null,null,null,null,null,null,null,null,"kayak/SUP/rowing",5.4200542005420098E-3,null,null,null,43299,"Salter Grove SP","kayak/SUP/rowing",0,null,null,43299,"Passeonkquis Cove",0.27777777777777779,0.31610022771670893]
[null,null,null,null,null,null,null,null,"other boating",9.0334236675700097E-4,null,null,null,43299,"Salter Grove SP","other boating",0,null,null,43301,"NK Town Beach",1.3903508771929824,1.5821648239925798]
[null,null,null,null,null,null,null,null,"fishing from shore",6.3233965672990101E-3,null,null,null,43299,"Salter Grove SP","fishing from shore",6.5217391304347797E-2,null,null,43301,"Fort Adams Beach",4.0444444444444443,4.6024193155552817]
[null,null,null,null,null,null,null,null,"fishing from boat",0,null,null,null,43299,"Salter Grove SP","fishing from boat",0,null,null,43314,"Oakland Beach",0.95213675213675208,1.08349431900435]
[null,null,null,null,null,null,null,null,"walk-by",1.6260162601626001E-2,null,null,null,43299,"Salter Grove SP","walk-by",0]
[null,null,null,null,null,null,null,null,"other  ",0,null,null,null,43299,"Salter Grove SP","other  ",0]
[null,null,null,null,null,null,null,null,"Grand Total",1,null,null,null,43299,"Passeonkquis Cove","chilling",0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43299,"Passeonkquis Cove","kayak/SUP/rowing",0.2]
[null,null,null,null,null,null,null,null,"Overall People Per Car",null,null,null,null,43299,"Passeonkquis Cove","other boating",0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43299,"Passeonkquis Cove","fishing from shore",0]
[null,null,null,null,null,null,null,null,"Total","People Per Car (Counted)","People Per Car (Estimated)",null,null,43299,"Passeonkquis Cove","fishing from boat",0]
[null,null,null,null,null,null,null,null,"Total",1.5002146975831185,1.7071855471079185,null,null,43299,"Passeonkquis Cove","walk-by",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43299,"Passeonkquis Cove","other  ",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","chilling",0.99053627760252405]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","kayak/SUP/rowing",9.4637223974763408E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","other boating",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","fishing from shore",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","fishing from boat",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","walk-by",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"NK Town Beach","other  ",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","chilling",0.98901098901098905]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","kayak/SUP/rowing",1.0989010989011E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","other boating",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","fishing from shore",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","fishing from boat",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","walk-by",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43301,"Fort Adams Beach","other  ",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","chilling",0.96050269299820501]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","kayak/SUP/rowing",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","other boating",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","fishing from shore",7.1813285457809697E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","fishing from boat",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","walk-by",3.2315978456014402E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43314,"Oakland Beach","other  ",0]

{"sheet":"ExtrapolationFactors","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Extrapolation Factors"]
[]
[null,"Time","Turnover Factor","Extrapolation Factor"]
[null,"5:00 AM",0,{"$error":"#NUM!"}]
[null,"6:00 AM",0,{"$error":"#NUM!"}]
[null,"7:00 AM",0,{"$error":"#NUM!"}]
[null,"8:00 AM",0,{"$error":"#NUM!"}]
[null,"9:00 AM",0,{"$error":"#NUM!"}]
[null,"10:00 AM",0,{"$error":"#NUM!"}]
[null,"11:00 AM",0,{"$error":"#NUM!"}]
[null,"12:00 PM",1.958825000042121E-2,51.051012723367165]
[null,"1:00 PM",8.1845857416289858E-2,12.218089364177997]
[null,"2:00 PM",9.3105372245591803E-2,10.740518789422984]
[null,"3:00 PM",8.7073652373667237E-2,11.484530311288738]
[null,"4:00 PM",7.6029958356335747E-2,13.152710084532984]
[null,"5:00 PM",0,{"$error":"#NUM!"}]
[null,"6:00 PM",0,{"$error":"#NUM!"}]
[null,"7:00 PM",0,{"$error":"#NUM!"}]
[null,"8:00 PM",0,{"$error":"#NUM!"}]

{"sheet":"Admin","index":6,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[8,1,8,3],[2,1,2,3]]}
[null,"This sheet contains data needed for calculations - DO NOT EDIT"]
[]
[null,"Average Total % Outside of Windows"]
[null,"Count Window","People","Cars",null,"Count Types",null,null,"Row Labels","Average of Cars","Average of People"]
[null,"5:00AM - 8:00PM",0,0,null,"Cars",null,null,"12:00 PM",60,78]
[null,"9:00AM - 4:00PM",0.40072936894432498,0.39545487314262401,null,"People",null,null,"1:00 PM",39.4,71]
[null,"12:00PM - 4:00PM",0.67294414399969804,0.62782324999199701,null,null,null,null,"2:00 PM",43.2,66.8]
[null,null,null,null,null,null,null,null,"3:00 PM",40.6,70.2]
[null,"Average Total % Inside of Windows",null,null,null,null,null,null,"4:00 PM",37,62.6]
[null,"Count Window","People","Cars",null,null,null,null,"Grand Total",41,68.142857142857139]
[null,"5:00AM - 8:00PM",1,1]
[null,"9:00AM - 4:00PM",0.59927063105567502,0.60454512685737605]
[null,"12:00PM - 4:00PM",0.32705585600030201,0.37217675000800299]