...
"Simple Downloads"
Running this url -- http://mv.ezproxy.com.ezproxyberklee.flo.org/sc/download
-- forces an output file with the current counter value for each file. This is the counter value at the moment of the report. So you have to be careful to run it at specific times if you want a certain date range to be represented. The counter is an accumulator so you have to calculate the difference between now and the last time you ran the report to see how many downloads there were. The worksheet attached to this page automates much of this.
- run the url at monthly intervals to get a new list of files and counter values.
- paste the contents of that output file at the bottom of the New Data worksheet, add the date to the third column, imitating what's already there; copying the formulas in columns four and five down for all the rows.
- If there are filenames that resolve to "0" in the name lookup, copy the filename to the Lookup worksheet and assign a name; recalc and refresh pivot tables. (If you want to exclude it from counting (like a text file or misspelled url) skip it.)
- The Pivots worksheet shows the values per software title over time, and computes the difference from the first to the last in the table. (You can adjust the number of months shown in the pivot table to compute across a subset of months.)
Complex Downloads
Downloads.mit.edu is accessible only through VPN using SecureCRT/FX.
...