Gerald D
Fri 14 March 2008, 12:15
Hi All
I am looking for an Excel boffin who knows his macros . . .
We have a logger on a garbage truck that logs the gps position and time of every cart/bin pickup. Here (http://www.autotracker.co.za/RPTLifter.aspx?FromDate=2008-3-14 00:00:00&ToDate=2008-3-14 23:59:59&TheUnitID=238&TheUnitName=LIFTER4) is a report from this morning (a small number of those data lines are corrupt - those lines can be ignored) liftlogger (http://www.liftlogger.co.za/)
That daily CSV file needs to be processed to get:
Total bins L (left)
Total bins R (right)
Total bins (L+R) before an N in the Position column
(The N's represent extended driving/parking time when No bins are lifted for 15 minutes.)
Total bins in each "session" (beat) between the N's.
Time beat starts
Time beat ends
Duration of beat
Tempo of bins/hour during a beat.
Average bins per kilometer during a beat
Number of stopping points in the beat (a stopping point is when the gps location changes by less than 7 meters)
Average number of bins per stopping point for a beat.
Typical is 3 beats per day, of about 400 bins each.
Etc.
Etc.
I know Excel well enough to crunch the numbers without using macros, but the process needs serious automation. Soon there will be 14 of these loggers running every day . . . . .
Any volunteers?
Thanks
I am looking for an Excel boffin who knows his macros . . .
We have a logger on a garbage truck that logs the gps position and time of every cart/bin pickup. Here (http://www.autotracker.co.za/RPTLifter.aspx?FromDate=2008-3-14 00:00:00&ToDate=2008-3-14 23:59:59&TheUnitID=238&TheUnitName=LIFTER4) is a report from this morning (a small number of those data lines are corrupt - those lines can be ignored) liftlogger (http://www.liftlogger.co.za/)
That daily CSV file needs to be processed to get:
Total bins L (left)
Total bins R (right)
Total bins (L+R) before an N in the Position column
(The N's represent extended driving/parking time when No bins are lifted for 15 minutes.)
Total bins in each "session" (beat) between the N's.
Time beat starts
Time beat ends
Duration of beat
Tempo of bins/hour during a beat.
Average bins per kilometer during a beat
Number of stopping points in the beat (a stopping point is when the gps location changes by less than 7 meters)
Average number of bins per stopping point for a beat.
Typical is 3 beats per day, of about 400 bins each.
Etc.
Etc.
I know Excel well enough to crunch the numbers without using macros, but the process needs serious automation. Soon there will be 14 of these loggers running every day . . . . .
Any volunteers?
Thanks