{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["10-22-2015","10-25-2015"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"10-22-2015","index":0,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[4,0,4,21],[0,0,0,2],[1,0,1,2],[2,0,2,2],[5,21,7,21],[5,20,7,20],[5,0,7,0],[5,1,6,4],[22,0,22,3],[22,16,22,18],[5,16,6,19],[5,11,6,14],[22,11,22,13],[5,6,6,9],[22,6,22,8]]}
["Location:",null,null,"Shedd Rd and Newcomb Rd"]
["Date of Count:",null,null,"Thursday, October 22, 2015"]
["Weather:"]
[]
["Count Group-Amish Buggies"]
[null,"NB",null,null,null,null,"SB",null,null,null,null,"EB",null,null,null,null,"WB",null,null,null,null,"Intersection Totals"]
[]
[null,"Left","Through","Right","Total",null,"Left","Thru","Right","Total",null,"Left","Thru","Right","Total",null,"Left","Thru","Right","Total"]
["6-7 AM",null,null,null,{"$f":"SUM(B9:D9)","v":0},null,null,null,null,{"$f":"SUM(G9:I9)","v":0},null,null,null,null,{"$f":"SUM(L9:N9)","v":0},null,null,null,null,{"$f":"SUM(Q9:S9)","v":0},null,{"$f":"E9+J9+O9+T9","v":0}]
["7 - 8 AM",null,null,null,{"$f":"SUM(B10:D10)","v":0},null,null,null,4,{"$f":"SUM(G10:I10)","v":4},null,null,null,null,{"$f":"SUM(L10:N10)","v":0},null,null,10,null,{"$f":"SUM(Q10:S10)","v":10},null,{"$f":"E10+J10+O10+T10","v":14}]
["8 - 9 AM",1,null,null,1,null,null,null,1,1,null,null,null,null,0,null,null,null,1,1,null,{"$f":"E11+J11+O11+T11","v":3}]
["9 - 10 AM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,1,null,null,1,null,1]
["10 - 11 AM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["11 - 12 AM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["12 - 1 PM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["1 - 2 PM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["2 - 3 PM",null,1,null,1,null,1,null,1,2,null,2,3,null,5,null,null,1,1,2,null,10]
["3 - 4 PM",null,null,null,0,null,null,1,1,2,null,1,3,null,4,null,1,null,1,2,null,8]
["4 - 5 PM",null,4,1,5,null,1,4,7,12,null,3,2,null,5,null,1,1,3,5,null,27]
["5 - 6 PM",null,6,1,{"$f":"SUM(B20:D20)","v":7},null,3,null,null,{"$f":"SUM(G20:I20)","v":3},null,2,null,null,{"$f":"SUM(L20:N20)","v":2},null,null,1,1,{"$f":"SUM(Q20:S20)","v":2},null,{"$f":"E20+J20+O20+T20","v":14}]
["6-7 PM",null,null,null,0,null,1,null,1,2,null,null,null,null,0,null,null,2,null,2,null,4]
["Totals:",{"$f":"SUM(B9:B21)","v":1},{"$f":"SUM(C9:C21)","v":11},{"$f":"SUM(D9:D21)","v":2},{"$f":"SUM(E9:E21)","v":14},null,{"$f":"SUM(G9:G21)","v":6},5,15,26,null,{"$f":"SUM(L9:L21)","v":8},{"$f":"SUM(M9:M21)","v":8},{"$f":"SUM(N9:N21)","v":0},{"$f":"SUM(O9:O21)","v":16},null,{"$f":"SUM(Q9:Q21)","v":3},{"$f":"SUM(R9:R21)","v":15},{"$f":"SUM(S9:S21)","v":7},{"$f":"SUM(T9:T21)","v":25},null,{"$f":"SUM(V9:V21)","v":81}]
["Avg. Hourly Total",null,null,null,{"$f":"ROUND(AVERAGE(E10:E21),0)","v":1},null,"Avg. Hourly Total",null,null,{"$f":"ROUND(AVERAGE(J10:J21),0)","v":2},null,"Avg. Hourly Total",null,null,{"$f":"ROUND(AVERAGE(O10:O21),0)","v":1},null,"Avg. Hourly Total",null,null,{"$f":"ROUND(AVERAGE(T10:T21),0)","v":2},null,{"$f":"ROUND(AVERAGE(V10:V21),0)","v":7}]
[]
["Macro CTRL D will delete counts for new intersection"]

{"sheet":"10-25-2015","index":1,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[22,0,22,3],[22,6,22,8],[22,11,22,13],[22,16,22,18],[0,0,0,2],[1,0,1,2],[2,0,2,2],[4,0,4,21],[5,0,7,0],[5,1,6,4],[5,6,6,9],[5,11,6,14],[5,16,6,19],[5,20,7,20],[5,21,7,21]]}
["Location:",null,null,"Shedd Rd and Newcomb Rd"]
["Date of Count:",null,null,"Sunday, October 25, 2015"]
["Weather:"]
[]
["Count Group-Amish Buggies"]
[null,"NB",null,null,null,null,"SB",null,null,null,null,"EB",null,null,null,null,"WB",null,null,null,null,"Intersection Totals"]
[]
[null,"Left","Through","Right","Total",null,"Left","Thru","Right","Total",null,"Left","Thru","Right","Total",null,"Left","Thru","Right","Total"]
["6-7 AM",null,null,null,{"$f":"SUM(B9:D9)","v":0},null,null,null,null,{"$f":"SUM(G9:I9)","v":0},null,null,null,null,{"$f":"SUM(L9:N9)","v":0},null,null,null,null,{"$f":"SUM(Q9:S9)","v":0},null,{"$f":"E9+J9+O9+T9","v":0}]
["7 - 8 AM",null,null,null,{"$f":"SUM(B10:D10)","v":0},null,null,null,null,{"$f":"SUM(G10:I10)","v":0},null,null,null,null,{"$f":"SUM(L10:N10)","v":0},null,null,null,null,{"$f":"SUM(Q10:S10)","v":0},null,{"$f":"E10+J10+O10+T10","v":0}]
["8 - 9 AM",12,1,null,13,null,null,null,null,0,null,null,null,null,0,null,3,3,1,7,null,{"$f":"E11+J11+O11+T11","v":20}]
["9 - 10 AM",null,null,2,2,null,null,null,null,0,null,1,null,null,1,null,null,null,1,1,null,4]
["10 - 11 AM",null,null,null,0,null,null,null,null,0,null,null,2,null,2,null,null,null,null,0,null,2]
["11 - 12 AM",null,null,null,0,null,1,null,null,1,null,2,null,null,2,null,null,null,1,1,null,4]
["12 - 1 PM",null,1,1,2,null,2,null,null,2,null,3,2,4,9,null,null,null,null,0,null,13]
["1 - 2 PM",null,2,4,6,null,null,1,1,2,null,2,3,7,12,null,1,4,2,7,null,27]
["2 - 3 PM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["3 - 4 PM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["4 - 5 PM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["5 - 6 PM",null,null,null,{"$f":"SUM(B20:D20)","v":0},null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["6-7 PM",null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,null,0]
["Totals:",{"$f":"SUM(B9:B21)","v":12},{"$f":"SUM(C9:C21)","v":4},{"$f":"SUM(D9:D21)","v":7},{"$f":"SUM(E9:E21)","v":23},null,{"$f":"SUM(G9:G21)","v":3},1,1,5,null,{"$f":"SUM(L9:L21)","v":8},7,11,26,null,{"$f":"SUM(Q9:Q21)","v":4},7,5,16,null,{"$f":"SUM(V9:V21)","v":70}]
["Avg. Hourly Total",null,null,null,{"$f":"ROUND(AVERAGE(E10:E21),0)","v":2},null,"Avg. Hourly Total",null,null,{"$f":"ROUND(AVERAGE(J10:J21),0)","v":0},null,"Avg. Hourly Total",null,null,{"$f":"ROUND(AVERAGE(O10:O21),0)","v":2},null,"Avg. Hourly Total",null,null,{"$f":"ROUND(AVERAGE(T10:T21),0)","v":1},null,{"$f":"ROUND(AVERAGE(V10:V21),0)","v":6}]
[]
["Macro CTRL D will delete counts for new intersection"]