{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["devNotes","Instructions","FilesProcessed","Summary","DO NOT DELETE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"devNotes","index":0,"n_rows":17,"n_cols":33,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["\\\\s6000e\\6420only\\Tools\\AnalysisTools\\APM_Version_2\\Chapter_3_Transportation_System_Inventory\\OTMS\\DraftAPMChanges\\Count_Processor"]
["1 csv for each date span"]
["but want to combine into one file"]
["all the count files would be in one folder, processor would run for all the files in the directory",null,null,null,null,null,null,"\\\\WPDOTFILL12\\6420only\\County\\Yamhill\\McMinnvilleModel_V3\\ModelBuild\\07_Counts\\TubeCounts"]
[null,"but not smart enough to know if it was a directional file"]
[null,"in past ran  processor on each output file, then corrected errors related to two-way, manually apply D-Factor",null,null,null,null,null,null,null,null,null,"Sample Files"]
[null,"check that site id is in the listing",null,null,null,null,null,null,null,null,null,"empty","NoData_HourlyVolumesforMonth"]
["would combine into one file, each one as a different line",null,null,null,null,null,null,null,null,null,null,"needs to bhave direction factor applied manually","ShortTermSingleTube_HourlyVolumesforMonth"]
["get me an example of VISUm file",null,"CompletedCounts_20200818.xlsx",null,null,null,null,null,null,null,null,"normal file","2018_3664_HourlyVolumesforMonth"]
["logic needs to find underscore, characters to left\n\nthen code for VISUM direction\n",null,null,"col J","col J",null,null,"direction code","last row, for date","row for first hr,\ncol for date"]
["not from OTMS","AK14","P14",null,null,"=T","col E",null,null,"avg of days"]
["$COUNTLOCATION:NO","Direction","TCM_ID","StDate","EndDate","Code","HwyNo","Direction2","Vol_24","HR_1","HR_2","HR_3","HR_4","HR_5","HR_6","HR_7","HR_8","HR_9","HR_10","HR_11","HR_12","HR_13","HR_14","HR_15","HR_16","HR_17","HR_18","HR_19","HR_20","HR_21","HR_22","HR_23","HR_24"]
["010011","NB","01001_NB","11/1/2020",{"$f":"D13","v":"11/1/2020"},"T","AZ10",{"$f":"RIGHT(A13,1)","v":"1"},272,2]
[]
[]
["write name of each file, whether it was successful"]
["not just files that don't work"]

{"sheet":"Instructions","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Put all count files to be processed in a directory together, along with a copy of this file."]
[null,null,"It is usually best to make a copy of this directory, so that if there is an error, you will  not have to re-pull the counts."]
[]
[null,"On tab \"Summary\", click on button \"Clean ATR edits\""]
[null,null,"This will qqq"]
[null,null,"You will be prompted for the directory where the files are stored."]
[null,null,"After indicating directory, the cleaning will proceed."]
[]
[null,"On tab \"Summary\", click on button \"Summarize Data\""]
[null,null,"You will be prompted for the directory where the files are stored."]
[null,null,"After indicating directory, the claning will proceed."]

{"sheet":"FilesProcessed","index":2,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Filename","Location","Status"]

{"sheet":"Summary","index":3,"n_rows":2,"n_cols":33,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["$COUNTLOCATION:NO","Direction","TCM_ID","StDate","EndDate","Code","HwyNo","Direction2","Vol_24","HR_1","HR_2","HR_3","HR_4","HR_5","HR_6","HR_7","HR_8","HR_9","HR_10","HR_11","HR_12","HR_13","HR_14","HR_15","HR_16","HR_17","HR_18","HR_19","HR_20","HR_21","HR_22","HR_23","HR_24"]

{"sheet":"DO NOT DELETE","index":4,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,1]]}
[]
[]
["VISUM Directions"]
["EB",1]
["NB",1]
["NEB",1]
["NWB",1]
["SB",0]
["SEB",0]
["SWB",0]
["WB",0]