# Adding time logs from a GPS device

1. ## Adding time logs from a GPS device

Hello,

Our company uses GPS data loggers to track workers in the field. our workers distribute flyers and are currently paid by the piece, soon to be paid by the hour. To be able to accurately pay them hourly, we need to be able to efficiently and accurately add up their total time worked and time not working (i.e. standing still) from start to finish. to achieve this, I was thinking that excel could count the total time between logs each day. Then, to calculate time not working within that total, excel could count time logs further apart than "XX" amount of seconds as time not working and provide us in the end with 3 totals. Total time per day working, total actual time working and total time not working. I've attached a sample of one of our GPS's logs in excel format. Is there any way of doing what we need with this data?

Thank you advance for your time and help.

2. Welcome to the forum.

All the times are exactly 30s apart; how does the sample data illustrate your narrative?

If you want help with Excel, please post workbooks, not pictures, PDFs, Word documents, ...

3. The GPS device can be set to log at any interval of time (i.e. 10 second, 20 seconds, 30 seconds etc...) Our problem is that if the device is turned off (i.e. if the person takes a break) or the speed column reads anything less than 1, we need to count that time as the person not working.

I attached the original sample excel file for you review.

I'm not sure what you mean by "how does the sample data illustrate your narrative?"

4. After the unit is turned off, the first speed will be 0?

5. good grief whatever happened to trust? and the work ethic.
apart from that tho! how does speed # less than 1 mean not working? i take it the flyer has to be put somewhere and the person stops to do it?
can you as requested put this in excel first?
oh i see it is sorry

6. Your data seems anomalous. In the first two lines, the carrier has moved 14km in 31s, yet the speed is shown as 0.017 km/hr.

To a rough (but not bad) approximation, distance = sqrt( (lat2 - lat1)^2 + (lon2-lon1)^2 * cos(lat1).

None of the calculated speeds are anywhere close to yours ...

7. i agree i get it as
14.1260 km in 31 seconds
bleeding fast that

8. for some reason, the distance feature does not work. Don't know why though, but it really does not matter as we do not use distance to verify any of the work done.

first off..."shg After the unit is turned off, the first speed will be 0? "

ANS: Yes the speed will be zero until the unit gets a fix and begins tracking which is annotated by the column labeled "Valid"

Second... "martindwilson apart from that tho! how does speed # less than 1 mean not working? i take it the flyer has to be put somewhere and the person stops to do it?"

ANS: since we are paying the distributor by the hour, motion (walking speed not driving) = work. Our distributors go door to door so I do understand what you are saying about having to stop to place a flyer on the door. we will most likely do some sort of percentage of stopped time and label that as "not distributing". Paying by the hour is still a new concept we are dealing with and thus need a lot of tweaking.

Please let me konw if you guys need any more info

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1