{"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":88,"n_cols":6,"rows_kept":88,"cut":false,"hidden":false,"merged":[[22,1,22,2],[22,5,22,7],[23,5,23,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 acess 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"]
[null,"2018-07-02","E. Greenwich","boat ramp","1-2  PM",8]
[null,"2018-07-25","E. Greenwich","boat ramp","1-2  PM",7]
[null,"2018-08-15","E. Greenwich","boat ramp","8-9  AM",2]
[null,"2018-07-17","Goddard","park","10-11  AM",20]
[null,"2018-07-23","Goddard","park","2-3  PM",9]
[null,"2018-08-14","Goddard","park","8-9  AM",17]
[null,"2018-06-21","Salter","landing","1-2  PM",2]
[null,"2018-07-17","Salter","landing","8-9  AM",9]
[null,"2018-08-06","Salter","landing","1-2  PM",3]
[null,"2018-08-24","Salter","landing","8-9  AM",4]
[null,"2018-06-30","Barrington","beach","9-10  AM",20]
[null,"2018-07-05","Barrington","beach","9-10  AM",10]
[null,"2018-08-29","Barrington","beach","1-2  PM",30]
[null,"2018-07-15","Bristol","beach","1-2  PM",50]
[null,"2018-08-02","Bristol","beach","1-2  PM",50]
[null,"2018-06-23","Warren","beach","10-11  AM",3]
[null,"2018-07-11","Warren","beach","9-10  AM",20]
[null,"2018-07-15","Warren","beach","3-4  PM",40]
[null,"2018-08-02","Warren","beach","2-3  PM",25]
[null,"2018-07-23","B Tuft","park","1-2  PM",1]
[null,"2018-08-14","B Tuft","park","1-2  PM",8]
[null,"2018-06-20","Rocky Point","park","1-2  PM",30]
[null,"2018-08-14","Rocky Point","park","8-9  AM",11]
[null,"2018-08-19","Rocky Point","park","1-2  PM",15]
[null,"2018-07-02","Oakland","beach","3-4  PM",40]
[null,"2018-07-25","Oakland","beach","2-3  PM",30]
[null,"2018-08-15","Oakland","beach","9-10  AM",15]
[null,"2018-08-14","Conimicut","park","9-10  AM",15]
[null,"2018-08-19","Conimicut","park","3-4  PM",100]
[null,"2018-07-17","Passeonkquis","fishing access","2-3  PM",2]
[null,"2018-06-30","Fort Adams","park","12-1  PM",20]
[null,"2018-07-05","Fort Adams","park","1-2  PM",20]
[null,"2018-08-02","Fort Adams","park","8-9  AM",10]
[null,"2018-06-30","Brenton","park","2-3  PM",40]
[null,"2018-07-05","Brenton","park","3-4  PM",40]
[null,"2018-08-02","Brenton","park","9-10  AM",10]
[null,"2018-08-18","Eastons","beach","8-9  AM",11]
[null,"2018-06-29","Eastons","beach","1-2  PM",120]
[null,"2018-07-11","Eastons","beach","1-2  PM",75]
[null,"2018-08-29","Eastons","beach","8-9  AM",11]
[null,"2018-06-30","Beach Rd","path","8-9  AM",4]
[null,"2018-07-05","Beach Rd","path","8-9  AM",3]
[null,"2018-07-25","India Pt","park","8-9  AM",9]
[null,"2018-08-24","India Pt","park","3-4  PM",51]
[null,"2018-06-20","Narragansett","beach","8-9  AM",15]
[null,"2018-08-15","Narragansett","beach","1-2  PM",200]
[null,"2018-06-21","N Kingstown TB","beach","1-2  PM",20]
[null,"2018-07-23","N Kingstown TB","beach","8-9  AM",4]
[null,"2018-06-21","Wickford MW","wharf","4-5  PM",5]
[null,"2018-07-23","Wickford MW","wharf","9-10  AM",7]

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

{"sheet":"Results","index":3,"n_rows":160,"n_cols":34,"rows_kept":160,"cut":false,"hidden":false,"merged":[[104,1,104,7],[105,1,106,8],[103,1,103,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,"June",334.11566504859661,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,"weekday",347.54147497780673,null,"Barrington","June",439.56282542484632,null,null,"June","weekday",401.98480837267658,null,"July",265.33308677690826,null,null,"beach",509.11107720675699,339.38723978546813,null,"Sunday",386.43800158552745]
[null,null,null,null,null,null,null,null,null,null,null,null,"weekend",302.24016835370344,null,null,"July",219.78141271242316,null,null,null,"weekend",252.67269305970072,null,"August",420.39094411582533,null,null,"boat ramp",74.800590750040598,null,null,"Monday",245.73624649963313]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",340.62752808997254,null,null,"June Total",null,334.11566504859661,null,"Grand Total",339.38723978546813,null,null,"landing",102.08582700376076,null,null,"Tuesday",235.57710553953538]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Barrington Total",null,333.32392207574736,null,null,"July","weekday",239.87008304592052,null,null,null,null,null,"park",318.73510137551358,null,null,"Wednesday",496.03541085209628]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bristol","July",567.71254681662094,null,null,null,"weekend",494.500120355798,null,null,null,null,null,"path",94.654014358987183,null,null,"Thursday",242.46625001203256]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",567.71254681662094,null,null,"July Total",null,265.33308677690826,null,null,null,null,null,"fishing access",20.690894848821248,null,null,"Friday",669.27597949541826]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bristol Total",null,567.71254681662094,null,null,"August","weekday",442.3311840604382,null,null,null,null,null,"wharf",103.58230827353174,null,null,"Saturday",260.14125173779149]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren","June",45.19643686540865,null,null,null,"weekend",233.89890458661583]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",430.42525965991069,null,null,"August Total",null,420.39094411582528]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",258.63618561026561]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Warren Total",null,291.17078544887391]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Tuft","July",11.354250936332418]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",90.834007490659346]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Tuft Total",null,51.094129213495883]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E. Greenwich","July",85.156882022493136]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",54.08800820513553]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E. Greenwich Total",null,74.800590750040598]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goddard","July",197.20930296120997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",459.74806974365208]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Goddard Total",null,284.72222522202401]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salter","June",22.708501872664836]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",243.3960369231099]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",71.119384609634153]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salter Total",null,102.08582700376076]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rocky Point","June",340.62752808997254]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",233.89890458661583]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rocky Point Total",null,269.4751124210681]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakland","July",365.82555831364687]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",329.67211906863469]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oakland Total",null,353.77441189864277]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conimicut","August",691.4456769030362]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Conimicut Total",null,691.4456769030362]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passeonkquis","July",20.690894848821248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passeonkquis Total",null,20.690894848821248]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Adams","June",256.61028962155251]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",227.08501872664837]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",270.44004102567766]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fort Adams Total",null,251.37844979129287]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brenton","June",413.81789697642495]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",421.28769389497512]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",219.78141271242316]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Brenton Total",null,351.62900119460772]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastons","June",1362.5101123598902]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",851.56882022493141]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",297.48404512824538]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eastons Total",null,702.26175571032809]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beach Rd","June",108.17601641027106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",81.132012307703306]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Beach Rd Total",null,94.654014358987183]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"India Pt","July",243.3960369231099]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",537.14180971609335]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"India Pt Total",null,390.26892331960164]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narragansett","June",405.66006153851646]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August",2270.8501872664838]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Narragansett Total",null,1338.2551244025001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N Kingstown TB","June",227.08501872664837]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",108.17601641027106]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N Kingstown TB Total",null,167.63051756845971]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wickford MW","June",53.317627648367271]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July",153.8469888986962]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wickford MW Total",null,103.58230827353174]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total estimated visits for the season (June, July, August) for all selected sites",null,null,null,null,null,null,{"$f":"TotalVisits","v":30448.440250753727}]
[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":""}]
[]
[]
[]
[null,"Date (m/d/yy)","Site Name","Site type: ","Year","Month","Day type","Day of Week","Estimated Visits"]
[null,"2018-07-02","E. Greenwich","boat ramp",2018,"July","weekday","Monday",90.834007490659346]
[null,"2018-07-25","E. Greenwich","boat ramp",2018,"July","weekday","Wednesday",79.479756554326926]
[null,"2018-08-15","E. Greenwich","boat ramp",2018,"August","weekday","Wednesday",54.08800820513553]
[null,"2018-07-17","Goddard","park",2018,"July","weekday","Tuesday",301.30957910272434]
[null,"2018-07-23","Goddard","park",2018,"July","weekday","Monday",93.109026819695615]
[null,"2018-08-14","Goddard","park",2018,"August","weekday","Tuesday",459.74806974365208]
[null,"2018-06-21","Salter","landing",2018,"June","weekday","Thursday",22.708501872664836]
[null,"2018-07-17","Salter","landing",2018,"July","weekday","Tuesday",243.3960369231099]
[null,"2018-08-06","Salter","landing",2018,"August","weekday","Monday",34.062752808997253]
[null,"2018-08-24","Salter","landing",2018,"August","weekday","Friday",108.17601641027106]
[null,"2018-06-30","Barrington","beach",2018,"June","weekend","Saturday",439.56282542484632]
[null,"2018-07-05","Barrington","beach",2018,"July","weekday","Thursday",219.78141271242316]
[null,"2019-08-29","Barrington","beach",2019,"August","weekday","Thursday",340.62752808997254]
[null,"2018-07-15","Bristol","beach",2018,"July","weekend","Sunday",567.71254681662094]
[null,"2018-08-02","Bristol","beach",2018,"August","weekday","Thursday",567.71254681662094]
[null,"2018-06-23","Warren","beach",2018,"June","weekend","Saturday",45.19643686540865]
[null,"2018-07-11","Warren","beach",2018,"July","weekday","Wednesday",439.56282542484632]
[null,"2018-07-15","Warren","beach",2018,"July","weekend","Sunday",421.28769389497512]
[null,"2018-08-02","Warren","beach",2018,"August","weekday","Thursday",258.63618561026561]
[null,"2018-07-23","B Tuft","park",2018,"July","weekday","Monday",11.354250936332418]
[null,"2018-08-14","B Tuft","park",2018,"August","weekday","Tuesday",90.834007490659346]
[null,"2018-06-20","Rocky Point","park",2018,"June","weekday","Wednesday",340.62752808997254]
[null,"2018-08-14","Rocky Point","park",2018,"August","weekday","Tuesday",297.48404512824538]
[null,"2018-08-19","Rocky Point","park",2018,"August","weekend","Sunday",170.31376404498627]
[null,"2018-07-02","Oakland","beach",2018,"July","weekday","Monday",421.28769389497512]
[null,"2018-07-25","Oakland","beach",2018,"July","weekday","Wednesday",310.36342273231867]
[null,"2018-08-15","Oakland","beach",2018,"August","weekday","Wednesday",329.67211906863469]
[null,"2019-08-14","Conimicut","park",2019,"August","weekday","Wednesday",329.67211906863469]
[null,"2019-08-19","Conimicut","park",2019,"August","weekday","Monday",1053.2192347374378]
[null,"2018-07-17","Passeonkquis","fishing access",2018,"July","weekday","Tuesday",20.690894848821248]
[null,"2018-06-30","Fort Adams","park",2018,"June","weekend","Saturday",256.61028962155251]
[null,"2018-07-05","Fort Adams","park",2018,"July","weekday","Thursday",227.08501872664837]
[null,"2018-08-02","Fort Adams","park",2018,"August","weekday","Thursday",270.44004102567766]
[null,"2018-06-30","Brenton","park",2018,"June","weekend","Saturday",413.81789697642495]
[null,"2018-07-05","Brenton","park",2018,"July","weekday","Thursday",421.28769389497512]
[null,"2018-08-02","Brenton","park",2018,"August","weekday","Thursday",219.78141271242316]
[null,"2018-08-18","Eastons","beach",2018,"August","weekend","Saturday",297.48404512824538]
[null,"2018-06-29","Eastons","beach",2018,"June","weekday","Friday",1362.5101123598902]
[null,"2018-07-11","Eastons","beach",2018,"July","weekday","Wednesday",851.56882022493141]
[null,"2018-08-29","Eastons","beach",2018,"August","weekday","Wednesday",297.48404512824538]
[null,"2018-06-30","Beach Rd","path",2018,"June","weekend","Saturday",108.17601641027106]
[null,"2018-07-05","Beach Rd","path",2018,"July","weekday","Thursday",81.132012307703306]
[null,"2018-07-25","India Pt","park",2018,"July","weekday","Wednesday",243.3960369231099]
[null,"2018-08-24","India Pt","park",2018,"August","weekday","Friday",537.14180971609335]
[null,"2018-06-20","Narragansett","beach",2018,"June","weekday","Wednesday",405.66006153851646]
[null,"2018-08-15","Narragansett","beach",2018,"August","weekday","Wednesday",2270.8501872664838]
[null,"2018-06-21","N Kingstown TB","beach",2018,"June","weekday","Thursday",227.08501872664837]
[null,"2018-07-23","N Kingstown TB","beach",2018,"July","weekday","Monday",108.17601641027106]
[null,"2018-06-21","Wickford MW","wharf",2018,"June","weekday","Thursday",53.317627648367271]
[null,"2018-07-23","Wickford MW","wharf",2018,"July","weekday","Monday",153.8469888986962]

{"sheet":"EstimatedDailyVisits","index":4,"n_rows":54,"n_cols":12,"rows_kept":54,"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"]
[null,"2018-07-02","E. Greenwich","boat ramp","1-2  PM",8,1.67,90.834007490659346,2018,"July","weekday","Monday"]
[null,"2018-07-25","E. Greenwich","boat ramp","1-2  PM",7,1.67,79.479756554326926,2018,"July","weekday","Wednesday"]
[null,"2018-08-15","E. Greenwich","boat ramp","8-9  AM",2,1.67,54.08800820513553,2018,"August","weekday","Wednesday"]
[null,"2018-07-17","Goddard","park","10-11  AM",20,1.67,301.30957910272434,2018,"July","weekday","Tuesday"]
[null,"2018-07-23","Goddard","park","2-3  PM",9,1.67,93.109026819695615,2018,"July","weekday","Monday"]
[null,"2018-08-14","Goddard","park","8-9  AM",17,1.67,459.74806974365208,2018,"August","weekday","Tuesday"]
[null,"2018-06-21","Salter","landing","1-2  PM",2,1.67,22.708501872664836,2018,"June","weekday","Thursday"]
[null,"2018-07-17","Salter","landing","8-9  AM",9,1.67,243.3960369231099,2018,"July","weekday","Tuesday"]
[null,"2018-08-06","Salter","landing","1-2  PM",3,1.67,34.062752808997253,2018,"August","weekday","Monday"]
[null,"2018-08-24","Salter","landing","8-9  AM",4,1.67,108.17601641027106,2018,"August","weekday","Friday"]
[null,"2018-06-30","Barrington","beach","9-10  AM",20,1.67,439.56282542484632,2018,"June","weekend","Saturday"]
[null,"2018-07-05","Barrington","beach","9-10  AM",10,1.67,219.78141271242316,2018,"July","weekday","Thursday"]
[null,"2019-08-29","Barrington","beach","1-2  PM",30,1.67,340.62752808997254,2019,"August","weekday","Thursday"]
[null,"2018-07-15","Bristol","beach","1-2  PM",50,1.67,567.71254681662094,2018,"July","weekend","Sunday"]
[null,"2018-08-02","Bristol","beach","1-2  PM",50,1.67,567.71254681662094,2018,"August","weekday","Thursday"]
[null,"2018-06-23","Warren","beach","10-11  AM",3,1.67,45.19643686540865,2018,"June","weekend","Saturday"]
[null,"2018-07-11","Warren","beach","9-10  AM",20,1.67,439.56282542484632,2018,"July","weekday","Wednesday"]
[null,"2018-07-15","Warren","beach","3-4  PM",40,1.67,421.28769389497512,2018,"July","weekend","Sunday"]
[null,"2018-08-02","Warren","beach","2-3  PM",25,1.67,258.63618561026561,2018,"August","weekday","Thursday"]
[null,"2018-07-23","B Tuft","park","1-2  PM",1,1.67,11.354250936332418,2018,"July","weekday","Monday"]
[null,"2018-08-14","B Tuft","park","1-2  PM",8,1.67,90.834007490659346,2018,"August","weekday","Tuesday"]
[null,"2018-06-20","Rocky Point","park","1-2  PM",30,1.67,340.62752808997254,2018,"June","weekday","Wednesday"]
[null,"2018-08-14","Rocky Point","park","8-9  AM",11,1.67,297.48404512824538,2018,"August","weekday","Tuesday"]
[null,"2018-08-19","Rocky Point","park","1-2  PM",15,1.67,170.31376404498627,2018,"August","weekend","Sunday"]
[null,"2018-07-02","Oakland","beach","3-4  PM",40,1.67,421.28769389497512,2018,"July","weekday","Monday"]
[null,"2018-07-25","Oakland","beach","2-3  PM",30,1.67,310.36342273231867,2018,"July","weekday","Wednesday"]
[null,"2018-08-15","Oakland","beach","9-10  AM",15,1.67,329.67211906863469,2018,"August","weekday","Wednesday"]
[null,"2019-08-14","Conimicut","park","9-10  AM",15,1.67,329.67211906863469,2019,"August","weekday","Wednesday"]
[null,"2019-08-19","Conimicut","park","3-4  PM",100,1.67,1053.2192347374378,2019,"August","weekday","Monday"]
[null,"2018-07-17","Passeonkquis","fishing access","2-3  PM",2,1.67,20.690894848821248,2018,"July","weekday","Tuesday"]
[null,"2018-06-30","Fort Adams","park","12-1  PM",20,1.67,256.61028962155251,2018,"June","weekend","Saturday"]
[null,"2018-07-05","Fort Adams","park","1-2  PM",20,1.67,227.08501872664837,2018,"July","weekday","Thursday"]
[null,"2018-08-02","Fort Adams","park","8-9  AM",10,1.67,270.44004102567766,2018,"August","weekday","Thursday"]
[null,"2018-06-30","Brenton","park","2-3  PM",40,1.67,413.81789697642495,2018,"June","weekend","Saturday"]
[null,"2018-07-05","Brenton","park","3-4  PM",40,1.67,421.28769389497512,2018,"July","weekday","Thursday"]
[null,"2018-08-02","Brenton","park","9-10  AM",10,1.67,219.78141271242316,2018,"August","weekday","Thursday"]
[null,"2018-08-18","Eastons","beach","8-9  AM",11,1.67,297.48404512824538,2018,"August","weekend","Saturday"]
[null,"2018-06-29","Eastons","beach","1-2  PM",120,1.67,1362.5101123598902,2018,"June","weekday","Friday"]
[null,"2018-07-11","Eastons","beach","1-2  PM",75,1.67,851.56882022493141,2018,"July","weekday","Wednesday"]
[null,"2018-08-29","Eastons","beach","8-9  AM",11,1.67,297.48404512824538,2018,"August","weekday","Wednesday"]
[null,"2018-06-30","Beach Rd","path","8-9  AM",4,1.67,108.17601641027106,2018,"June","weekend","Saturday"]
[null,"2018-07-05","Beach Rd","path","8-9  AM",3,1.67,81.132012307703306,2018,"July","weekday","Thursday"]
[null,"2018-07-25","India Pt","park","8-9  AM",9,1.67,243.3960369231099,2018,"July","weekday","Wednesday"]
[null,"2018-08-24","India Pt","park","3-4  PM",51,1.67,537.14180971609335,2018,"August","weekday","Friday"]
[null,"2018-06-20","Narragansett","beach","8-9  AM",15,1.67,405.66006153851646,2018,"June","weekday","Wednesday"]
[null,"2018-08-15","Narragansett","beach","1-2  PM",200,1.67,2270.8501872664838,2018,"August","weekday","Wednesday"]
[null,"2018-06-21","N Kingstown TB","beach","1-2  PM",20,1.67,227.08501872664837,2018,"June","weekday","Thursday"]
[null,"2018-07-23","N Kingstown TB","beach","8-9  AM",4,1.67,108.17601641027106,2018,"July","weekday","Monday"]
[null,"2018-06-21","Wickford MW","wharf","4-5  PM",5,1.67,53.317627648367271,2018,"June","weekday","Thursday"]
[null,"2018-07-23","Wickford MW","wharf","9-10  AM",7,1.67,153.8469888986962,2018,"July","weekday","Monday"]

{"sheet":"admin","index":5,"n_rows":34,"n_cols":11,"rows_kept":34,"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(H31,6,1)","v":"2018-06-01"},"Weekdays",{"$f":"NETWORKDAYS(H32,H33)-H34","v":65},{"$f":"+$J$32*GETPIVOTDATA(\"Estimated Visits\",Results!$M$1,\"Day type\",\"weekday\")","v":22590.195873557437}]
[null,null,null,null,null,null,"season end:",{"$f":"DATE(H31,8,31)","v":"2018-08-31"},"weekend days + holiday",{"$f":"_xlfn.DAYS(H33,H32)-J32","v":26},{"$f":"+J33*GETPIVOTDATA(\"Estimated Visits\",Results!$M$1,\"Day type\",\"weekend\")","v":7858.2443771962899}]
[null,null,null,null,null,null,"number of holidays:",{"$f":"DataEntry!D27","v":1},"Totals",{"$f":"+J32+J33","v":91},{"$f":"+K32+K33","v":30448.440250753727}]