{"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":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[11,11,12,15],[1,1,1,3],[8,11,10,15],[3,11,3,15],[4,11,4,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,null,null,null,null,{"$f":"SUM(F6,1)","v":1}]
[null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,"Then, go to the Statistics sheet to view site and overall statistics or to ExtrapolationFactors to view the extrapolation factors calculated using your data."]
[]
[null,"Enter activities monitored:"]
[null,"Activities (up to 8)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter site names:"]
[null,"Site Names"]

{"sheet":"IncomingCount","index":2,"n_rows":4,"n_cols":39,"rows_kept":4,"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"]

{"sheet":"TopOfHourCount","index":3,"n_rows":4,"n_cols":22,"rows_kept":4,"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"]

{"sheet":"Statistics","index":4,"n_rows":16,"n_cols":23,"rows_kept":16,"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,"Overall People Per Car"]
[]
[null,null,null,null,null,null,null,null,"Total","People Per Car (Counted)","People Per Car (Estimated)"]

{"sheet":"ExtrapolationFactors","index":5,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Extrapolation Factors"]
[]
[null,"Time","Turnover Factor","Extrapolation Factor"]

{"sheet":"Admin","index":6,"n_rows":13,"n_cols":9,"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"]
[null,"5:00AM - 8:00PM",0,0,null,"Cars"]
[null,"9:00AM - 4:00PM",0.40072936894432498,0.39545487314262401,null,"People"]
[null,"12:00PM - 4:00PM",0.67294414399969804,0.62782324999199701]
[]
[null,"Average Total % Inside of Windows"]
[null,"Count Window","People","Cars"]
[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]