{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["StartHere","DataEntry","ResultsInfo","Results","EstimatedDailyVisits","admin"],"not_rendered":{"charts":7,"images":1,"macros":1,"external_links":1,"defined_names":27,"comments":0,"pivot_tables":7},"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":"DataEntry","index":1,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,5,22,7],[27,5,27,7],[36,1,36,5],[25,1,25,2],[26,1,26,2]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If you would like to change the default number of people per car, enter it here:"]
[null,"Enter People per Car (default = 1.67):"]
[]
[null,"Enter year of data collection, and the number of summer holidays (e.g. July 4th):"]
[null,"Year of Data Collection",null,2018]
[null,"Number of Summer Holidays between 6/1 and 8/31",null,1]
[]
[null,"Example Entry:"]
[null,"Date (m/d/yy)","Site Name","Site type: ","Time","Number of Cars"]
[null,"2017-06-04","Bay St.","Boat Ramp","8-9  AM",2]
[null,"2017-06-05","Loop's Beach","Beach","11-12 AM",10]
[null,"2017-07-09","Bay St.","Boat Ramp","1-2 PM",5]
[]
[null,"Enter your car count data below. When you are ready to view results, click the \"Refresh Results\" button above."]
[null,"The \"Time\" column uses a drop-down list - click on the cell to access the drop-down."]
[null,"Data Entry Table (rows will be added automatically as you enter data)"]
[null,"Date (m/d/yy)","Site Name","Site type: ","Time (Click dropdown on cell)","Number of Cars"]

{"sheet":"ResultsInfo","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Results","index":3,"n_rows":110,"n_cols":34,"rows_kept":110,"cut":false,"hidden":false,"merged":[[103,1,103,7],[105,1,106,8],[104,1,104,7],[103,8,104,8]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Average of Estimated Visits",null,null,"Average of Estimated Visits",null,null,null,null,"Average of Estimated Visits",null,null,null,"Row Labels","Average of Estimated Visits",null,null,"Average of Estimated Visits",null,null,null,"Average of Estimated Visits"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Day type","Total",null,"Site Name","Month","Total",null,null,"Month","Day type","Total",null,"(blank)",null,null,null,"Site type: ","Total","Average of Estimated Visits",null,"Day of Week","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,null,"(blank)","(blank)",null,null,null,"(blank)","(blank)",null,null,"Grand Total",null,null,null,"(blank)",null,null,null,"(blank)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(blank) Total",null,null,null,null,"(blank) Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total estimated visits for the season (June, July, August) for all selected sites",null,null,null,null,null,null,{"$f":"TotalVisits","v":{"$error":"#REF!"}}]
[null,"using daily visits averaged over the selected sites:"]
[null,{"$f":"IF(ISERROR(I104),\"Your selection does not have enough data to estimate the total visits in the season.\nPlease change the slicer selection or ensure both weekday and weekend data is present.\",\"\")","v":"Your selection does not have enough data to estimate the total visits in the season.\nPlease change the slicer selection or ensure both weekday and weekend data is present."}]
[]
[]
[]
[null,"Date (m/d/yy)","Site Name","Site type: ","Year","Month","Day type","Day of Week","Estimated Visits"]

{"sheet":"EstimatedDailyVisits","index":4,"n_rows":4,"n_cols":12,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,1,2,11]]}
[]
[]
[null,"Data Used for Calculations (do not edit)"]
[null,"Date (m/d/yy)","Site Name","Site type: ","Time","Number of Cars","People Per Car","Estimated Visits","Year","Month","Day type","Day of Week"]

{"sheet":"admin","index":5,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,"This sheet contains data needed for calculations - DO NOT EDIT"]
[null,"The sheet is locked - use password \"unlock\" if you need to unlock the sheet."]
[]
[null,null,null,"default people per car"]
[null,null,"people_per_car",1.67]
[]
[]
[null,"named ranges for calculations"]
[]
[null,null,"Time Intervals (1 hour)"]
[null,"intervals","5-6  AM"]
[null,null,"6-7  AM",null,null,null,null,"time","extrapolation_factor"]
[null,null,"7-8  AM",null,null,null,"factors","5-6  AM",23.349019662661657]
[null,null,"8-9  AM",null,null,null,null,"6-7  AM",21.89890391964521]
[null,null,"9-10  AM",null,null,null,null,"7-8  AM",19.812413440353602]
[null,null,"10-11  AM",null,null,null,null,"8-9  AM",16.19401443267531]
[null,null,"11-Noon",null,null,null,null,"9-10  AM",13.160563635474441]
[null,null,"12-1  PM",null,null,null,null,"10-11  AM",9.0212448833151004]
[null,null,"1-2  PM",null,null,null,null,"11-Noon",8.963451537601884]
[null,null,"2-3  PM",null,null,null,null,"12-1  PM",7.6829428030404943]
[null,null,"3-4  PM",null,null,null,null,"1-2  PM",6.7989526564864784]
[null,null,"4-5  PM",null,null,null,null,"2-3  PM",6.1948786972518706]
[null,null,"5-6  PM",null,null,null,null,"3-4  PM",6.3067020044157953]
[null,null,"6-7  PM",null,null,null,null,"4-5  PM",6.3853446285469788]
[null,null,"7-8  PM",null,null,null,null,"5-6  PM",7.0866180023800496]
[null,null,"8-9  PM",null,null,null,null,"6-7  PM",7.4987420893117651]
[null,null,null,null,null,null,null,"7-8  PM",7.5412454988216338]
[null,null,null,null,null,null,null,"8-9  PM",7.5412454988216338]
[]
[]
[null,null,null,null,null,null,"calculate total days/season",null,"Estimate of visits per day type"]
[null,null,null,null,null,null,"season year:",{"$f":"+DataEntry!D26","v":2018},null,"days","visits"]
[null,null,null,null,null,null,"season start:",{"$f":"DATE(H32,6,1)","v":"2018-06-01"},"Weekdays",{"$f":"NETWORKDAYS(H33,H34)-H35","v":65},{"$f":"+$J$33*GETPIVOTDATA(\"Estimated Visits\",Results!$M$1,\"Day type\",\"weekday\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"season end:",{"$f":"DATE(H32,8,31)","v":"2018-08-31"},"weekend days + holiday",{"$f":"_xlfn.DAYS(H34,H33)-J33","v":26},{"$f":"+J34*GETPIVOTDATA(\"Estimated Visits\",Results!$M$1,\"Day type\",\"weekend\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"number of holidays:",{"$f":"+DataEntry!D27","v":1},"Totals",{"$f":"+J33+J34","v":91},{"$f":"+K33+K34","v":{"$error":"#REF!"}}]