Jun 05 2010

Quantify IRS Taxable Mileage now with GPS Insight!

Category: California,Ease of use,Reporting,Reportsrdonat @ 12:09 pm

We added some functionality to our product to help a customer with a recent IRS reality:

Personal usage of take-home vehicles is taxable as income.

Now it’s pretty easy to quantify just how much of that usage is taxable using GPS Insight.

We have a new way to choose which hours of the day for several reports, to include the drive time summary (down to 5 minute levels):

New Time Selection capability within GPS Insight Reports

New Time Selection capability within GPS Insight Reports

So when you run a month-long report with the default (00:00 through 00:00), which is what we used to allow (just a full day, not just certain hours of the day), you would get this:

Run a GPS Insight Drive Time Summary for All of May

Run a GPS Insight Drive Time Summary for All of May

This shows 193,887 TOTAL miles

This shows 193,887 TOTAL miles

Now run it for JUST personal hours (this would vary based on your company’s schedule of course):

Choose your exact hours for the report

Choose your exact hours for the report

The options allow you to specify the time “band” (e.g. 7PM until 5AM in this case) as well as whether to include or exclude trips which happen only partially within that time.  Also, you can apply this to EVERY day or just the start/ending days by clicking “Apply Each Day.”

We will soon have a 3rd “split trips” option which literally split activity in half at the exact time you specify — e.g. if you say 19:00 and a trip starts at 18:00 and ends at 21:00, it will only report 2, not 3 hours & the mileage of those 2 hours.

Additionally, there will be weekend support as well, which will help quantify personal usage (although we already do this in our odd-hours/weekends report.

Here is the result of that particular “personal hours” report:

Quickly determine how many miles need to be taxed

Quickly determine how many miles need to be taxed

The personal usage miles, based on the 7PM-5AM filter are 29,074 for May, 15% of total miles driven.

A) you may want to curb this usage, since it’s costing your company money for fuel & wear and tear

B) you need to report this as income if it fits the IRS’s definition, and avoid putting your employees in a bad position of owing taxes if/when you/they are audited.

The IRS just announced an audit of all State of California take-home vehicles, reported by Government Fleet Magazine:

IRS is auditing California take home vehicle usage

IRS is auditing California take home vehicle usage

Here is the link to that article.

Be prepared!  Start quantifying your vehicle usage.  Also, know that GPS Insight stores 3-5 years of your data, so an 18 month audit will take you no time at all to complete.  Good luck with most other GPS providers which only give you 3-6 months of data.  If you want that data, they will usually charge you thousands of dollars for archived data requests.  Not us though…

Rob.

Tags: , ,


Apr 20 2010

Why I hate Microsoft (or why resetting your Ford Sync GPS is a bad idea)

Obviously I am pretty dependent on GPS for just about everything when it comes to getting around [also for money...].

I have 3 GPS Navigation devices with me when I drive my car (factory installed, Garmin, & my iPhone) so I never print directions any more.

So, on the way out to Long Beach a couple weeks ago, my family and I took our 3 month old car with Ford’s/Microsoft’s “Sync” system (with GPS Navigation).  No directions, just our factory installed GPS navigation unit.

Just outside of town it crashed on us.  I figured out how to do a factory reset and get it back up & running.

Here’s the point:  AFTER RESETTING IT, I FORGOT TO TELL IT “FASTEST” & NOT “SHORTEST” when optimizing our route.  DOH!

We took the 10 out to LA area, but then it took me through some really sketchy, slow-moving areas.

On the way home, I thought about it, & realized I needed to change my GPS setting to FASTEST from SHORTEST.

I was curious how much longer it took me time-wise to get there than to get back, so I ran a 3D history report & saw very quickly that it was twice as long (60 vs. 30 minutes):

Run a week long history for our trip to/from Long Beach

Run a week long history for our trip to/from Long Beach

Slow, direct route vs. Fast, indirect route

Slow, direct route vs. Fast, indirect route

All I had to do is look at the 2 points where the route deviates then converges again, and compare times and distances:

Where I took a GPS dictated "dumb turn"

Where I took a GPS dictated "dumb turn"

The times/mileages are:

Going there: 17:47 & 4571.6 miles to 18:53 & 4602.5 miles

Coming back: 10:26 4618.8 miles & 10:58 & 4656.3 miles

Doing the quick math, it took 31 miles & 66 minutes there the “short” way, & 37.5 miles & 32 minutes (half as long) the “long way.”

So to save 6.5 miles, I wasted 34 minutes of my life, praying we didn’t get car-jacked.  At least if we did, I would know where the car went…

Anyway, I thought of this the other day & was curious just how much extra time it took us because of that one GPS setting on my (Factory Installed — not GPS Insight…) navigation device.

Because I track that vehicle, it took me about a minute to figure it out using GPS Insight.

Oddly enough, while I was writing this, my new Microsoft Windows 7 box crashed Google Earth as well.  It knew I was badmouthing Microsoft.  Sooner or later, all things Microsoft eventually crash.

I’m really glad we don’t run our systems on Microsoft products.

I just checked and our two “primary” servers which our customers rely upon (with lots of auxiliary and backup servers, of course) have been up for two years to two years & 3 months:

GPS Insight servers run for years without incident

GPS Insight servers run for years without incident

I’m glad most of our competitors run Microsoft though…

Rob.

Tags: , , , , ,


Mar 27 2010

Useful But Somewhat unknown SMS capability

We have an SMS query capability which allows you to see the driving distance between a vehicle & an address, a landmark, or another vehicle.

It is documented at http://support.gpsinsight.com/wiki/support/sms_query_documentation under “Driving Distance.”

You just text “gps [vehiclename] distance [address | landmark | vehicle name]

It just came in handy for me while my family & I were driving in California.  I mentioned we were close to our office and my wife asked how close it was [we drove right past...  We're going on vacation this week].

I didn’t know the exact name of the landmark we have for it (GPSI – LA) so I just SMS’d our 477-477 (GPS-GPS) short code with “gps nav2 distance gpsi” — nav2 is the vehicle we were in.  The return SMS told me the list of valid landmarks meeting “GPSI” — GPSI – LA was the one I needed so I sent it again, & it showed that I was 12.1 miles away, a 25 minute drive:

Use GPS Insight SMS Queries to see how far it will take you to drive somewhere

Use GPS Insight SMS Queries to see how far it will take you to drive somewhere

We got close — within 4 miles of the office.  But I’m on vacation, so we just kept on going…

Driving by close to the GPS Insight LA Office in City of Orange, CA

Driving by close to the GPS Insight LA Office in City of Orange, CA

So close:

Driving by the office on the way to vacation

Driving by the office on the way to vacation

Great way to show how useful SMS Queries are for our customers though — they are an optional, but highly useful capability.  We use them ALL THE TIME ourselves.

Click for more information on our GPS Vehicle Tracking Mobile Access.

Rob.

Tags: , , , , ,


Dec 19 2009

GPS Insight adds over 1,000 devices in one day

We will have a formal announcement about this after the holidays.

Just last Tuesday, we lit up exactly 1,000 new units on GPS Insight for a new customer.

They all came online at the exact same time, which is not typical, but this had an interesting and noticeable effect on our daily processing.

Here is a graph we get each day which is typically 100% bell curve shaped. This indicates driving activity, and peaks during the middle of the day when most of the drivers of our tracked delivery vehicles, service vehicles, and government vehicles are out doing their jobs.

GPS Insight turns on 1000 new units

GPS Insight turns on 1000 new units

It was very evident when these devices started reporting to GPS Insight, so I thought I would point out the nice “bump” we got to our overall vehicle installed base Tuesday.

It is interesting to note that even though we have vehicles in 4 different timezones (6 if you include Alaska and Hawaii), and in 100 different types of business, they all wind up “smoothing each other out” to a single bell curve.

The street sweepers and a number of over the road/long haul vehicles work at night typically, which keeps our nighttime activity from dipping too low, and the early morning service workers (Construction, typically) get things off in a hurry starting around 4 AM MST (here in AZ this time of year that means 6 AM New York Time). The longer tail at the end of the day is because of overtime — drivers get going according to a schedule, but don’t always finish on time.

Some drivers drive to a workplace once a day, then there is no more movement until they leave to go home, and some drive all day long (e.g. delivery vans). When you you put together tens of thousands of vehicles though, across over 1,000 customers, things balance out and become pretty predictable.

GPS Tracking histogram / Bell Curve

GPS Tracking histogram / Bell Curve

Here’s a daily “by hour” for the whole month. The only anomaly is a slight dip in the 11:00 hour — I’m pretty sure that’s lunch related. I bet if our customers check the street view on their vehicles locations, there would be a lot of this stuff going on:

This is our Scion 4000 on the way to take a couple salespeople to the airport to head home after a week in the office:

19 minute lunch stop into the 11:00 Hour

19 minute lunch stop into the 11:00 Hour

In-N-Out stop for Joe Vidmar

In-N-Out stop for Joe Vidmar

Our Chicago guys only get into Scottsdale occasionally, and needed their In-N-Out Burger fix before heading back on Friday. Them & several other thousand drivers being tracked by GPS Insight around lunchtime. And now 1,000 more.

Rob.

Tags: , , , ,


Nov 29 2009

Counting & Reconciling Tolls using GPS Insight fleet tracking

We have a customer in San Francisco who wanted to be able to reconcile the # of trips they make across the Bay Bridge (since they pay a toll when coming into the city).

Here is a picture of the landmark they defined (along with a nice 3D representation in Google Earth):

GPS Insight Landmark of the San Francisco Bay Bridge

GPS Insight Landmark of the San Francisco Bay Bridge

We added a “Passing Through” option to our standard landmark report to help with this requirement. Before this, the landmark visit would have required the vehicle to either stop or idle for a minute to register. If you click the “Passing Through” checkbox, it will count any activity through that “zone.”

GPS Insight landmark report adds "passing through" option

GPS Insight landmark report adds "passing through" option

Now when running the report (which took less than 3 seconds), you get each time a vehicle went through that area (I’ve blurred out the vehicle names for customer privacy).

GPS Insight vehicle tracking landmark report

GPS Insight vehicle tracking landmark report

This makes it easy to see that 7 vehicles went a total of 23 times across the Bay Bridge.

But how many tolls is that?

You only get charged on the way INTO the city. Exporting that report to Excel gives us some additional information such as heading (what direction the trip took through the landmark). So only Southwest trips should incur a toll. That shows 8 of them according to this Excel Screenshot:

How many tolls should we be charged across the Bay Bridge?

How many tolls should we be charged across the Bay Bridge?

We added Heading as well to the exported version of the report. Since space isn’t at a premium in Excel, we usually put all columns into the exported versions of the reports there.

This helps our customer, & I thought it would be worth detailing here in case other customers can think of a good use for this.

Thanks,
Rob.

Tags: , , , ,


Oct 31 2009

I’m guessing this is not authorized usage…

Funny, we saw this truck on its way home from Disneyland. I think I’ll have a salesperson call to see how they keep tabs on unauthorized usage on Monday:

Unauthorized usage of Company Vehicles

Unauthorized usage of Company Vehicles

GPS Insight prevents this! Not only will you prevent your drivers abusing/using their take home vehicles on weekends and at night, but you won’t have to worry about your drivers causing accidents when couches fall off of YOUR vehicles. Plus you won’t have to pay for the fuel to move their apartment.

Rob.


Oct 31 2009

Heading home from Disneyland, GPS tracking using “Customer Sites”

There is a feature our customers sometimes require, where they can show a subset of their vehicles’ location to THEIR customers.

We call it “Customer Sites” and here is a good example of how it works:

I created a site called www.gpsinsight.com/disney in about 30 seconds just by configuring the “disney” group to show up publicly:

Tracking our drive back from Disneyland using GPS Insight's Customer Sites

Tracking our drive back from Disneyland using GPS Insight's Customer Sites

This view only tells you current status & speed (or time stopped) but is useful, and worth mentioning here. It shows our vehicle (Navigator) as well as my 2 kids’ EZ-1000′s (Chip and Mickey).

It’s my wife’s turn to drive so I’m just catching up on email & thought I would check to see where we’re at using this site I set up so a few people could see where we were at in Disneyland over the past couple days.

Here’s a picture of Ryan with Goofy for good measure (note the GPS Insight pen for autographs!):

Goofy with Ryan at Disneyland

Goofy with Ryan at Disneyland

Rob.

Tags: , , ,


Oct 30 2009

Panic in Disneyland!

Category: Alerts,California,EZ-1000,New Features,Safetyrdonat @ 8:59 am

We added 10 second panic capabilities to our EZ-1000 devices yesterday. They have a “panic button” which can be pressed to send a message.

My boys have EZ-1000′s here in Disneyland so I thought I would configure an alert straight to my cell phone if they ever pressed the button (not that they ever were somewhere without us).

Within 20-30 seconds on average, it would “page” me that either “Mickey” or “Chip” (the 2 devices) had pressed the panic button.

This is NOT something we sell to people for their kids — but security firms do use them for their foot and bike/Segway mounted security guards.

Here is the alert:

Panic alert on a GPS Insight EZ-1000 GPS Tracking device

Panic alert on a GPS Insight EZ-1000 GPS Tracking device

And here was the SMS text message I got when “Chip” pressed the panic button:

Panic alert on a GPS Insight EZ-1000 GPS Tracking device

Panic alert on a GPS Insight EZ-1000 GPS Tracking device

Then a map shows you their location and using the iPhone, I can walk to them using the “blue” dot which is me (well, if you look at the time, I had actually done this earlier to figure out where they were at beforehand…):

GPS Tracking my kids on Tom Sawyer's Island

GPS Tracking my kids on Tom Sawyer's Island

This is what might happen to a kid at Disneyland if they get lost on Tom Sawyer’s Island without a Panic Alarm capable EZ-1000:

Jack in Tom Sawyer's jail at Disneyland

Jack in Tom Sawyer's jail at Disneyland

Rob.

Tags: , ,


Oct 28 2009

GPS Tracking at Disneyland

We headed to Disneyland today with the boys (Sarah got her own “Princess” trip with Mommy to Disney earlier in the year):

Jack & Ryan after riding the "California Screamin'" rollercoaster

Jack & Ryan after riding the "California Screamin'" rollercoaster

I put a couple EZ-1000′s in the boys’ pockets in case they got lost and to document our day.

Originally they were labeled Goofy & Dumbo but my boys took exception to that. I called Tech Support and within 2 minutes Adam had them changed to Chip and Mickey (per my kids’ wishes).

Here’s a picture of our first day at California Adventure, then Disneyland. (There’s a cool time lapse video of this at the end of the blog article):

GPS Tracking at Disneyland

GPS Tracking at Disneyland

They tracked like a charm for the entire trip from Scottsdale at 1 minute updates. No kids got lost or ran off with Goofy.

I decided it would be a good idea to walk home to the hotel. Apparently I was wrong, and had to carry Ryan on my shoulders most of the way (fun).

I got to measure it afterward — only .57 miles, but it felt like longer after walking all over Disneyland:

Walking home from Disneyland at the end of the day

Walking home from Disneyland at the end of the day

Here is a video of our walking around for the day:

disneyland

Rob.


May 06 2009

Using City Boundaries in Google Earth to categorize activity by city

So we sent a team to coordinate some installs in Santa Monica last week. Since Google Earth makes city boundaries available, it’s not hard to quantify when we were there, and how much time was spent in Santa Monica and what stops were made in neighboring cities. This takes no time at all in GPS Insight. Here’s how:

First, turn on City Boundaries, turn off roads (to make it easier to see the city boundary) and then “fly to” Santa Monica:

Santa Monica miles in GPS Insight

Then trace the outline using a Google Earth Polygon and name it “Santa Monica” and color it however you may like:

Create a Polygon in Google Earth

To be precise while tracing the city boundary, you can Zoom Down/Up, and pan around using the Pg Up/Pg Down and Arrow Keys ( Help -> Keyboard Shortcuts gives you this information) – just click all the defining points until you complete the polygon:

Create a Polygon in Google Earth

It’s up to you how accurate you want to be — 1 minute and you should be 99.9% accurate:

Create a Polygon in Google Earth

After clicking on “OK” you can then right-click/cut [or copy to be safer -- either is fine] the definition from Google Earth and paste it into “Quick Import” under Mapping -> Landmarks on the GPS Insight top navigation bar:

Import a Google Earth Polygon into GPS InsightT

Import a Google Earth Polygon into GPS Insight

Then click on “Import Now” and repeat for any bordering cities in question.

To find out which ones we need, grab the history for roughly the time that vehicle (Scion 4000) was out in California.

I forget when they were there so I’ll just grab 9 days or so toward the end of April:

Scion GPS history in Santa Monica

It looks like they spent some time driving through Venice, having breakfast in Playa Del Ray, and in WestWood, Sawtelle, Culver City, etc.

I’ll just add a couple other cities for the sake of this article, but if these were important county or city boundaries, you would only need to add them once, and if it was a LOT of data, we have ways of automating this for our customers — just ask! [sometimes that means we do it for you...]

Here are 3 I quickly traced (they’re not 100% — there are crazy in & out borders which are irrelevant for our purposes here):

CA coastal cities

Now we can group them as “CA Coastal Cities” under GPS Insight -> Mapping -> Landmark -> Groups:

Grouping 3 landmarks into one group

Click on “Create New Landmark Group”:

Group GPS Insight Landmarks

Then name it and save it:

GPS Insight CA Coastal Cities Landmark Group

Now here’s the timesaver:

Draw a quick “throw-away” polygon around all three in Google Earth and cut/paste it into “Filter by Polygon”:

Too many landmarks — filter them with a Google Earth Polygon

We quickly see only our 3 Coastal Cities — this is down from 966 landmarks we would otherwise need to look through to find all three and drag them into the new group we’ve created:

Too many landmarks — filter them with a Google Earth Polygon

Now shift-click between the top & bottom to select all 3, then drag onto our new “CA Coastal Cities” group:

Adding Landmarks to a GPS Insight Landmark Group

Now click on the “edit landmarks” icon to change if necessary or just verify the group is correct:

Adding Landmarks to a GPS Insight Landmark Group

OK, enough about grouping landmarks, but that’s necessary for the final report:

Make sure to refresh or hit F5 on your browser to pick up the new landmark group, and run a landmark report for Scion 4000 for ONLY the landmark group called “CA Coastal Cities” — make sure to click on the “Passing Through” checkbox to ensure you get driving activity which does not begin/end a stop as well.

Running a Landmark Reoprt in GPS Insight

And .6 seconds later, here is the answer:

103.8 hours in Santa Monica, 9 minutes passing through Venice, and 25 minutes in Playa Del Ray with 9 minutes stopped there for something (Breakfast? — too quick):

GPS Insight Landmark Report

Turning on the “Places of Interest” layer we see it’s a McDonald’s (which explains why it’s only 9 minutes):

McDonald’s stop during Santa Monica trip

You get the idea — this article has gotten long…

Hopefully it gives you a good example of how to use Google Earth, along with GPS Insight landmarks/landmark groups, and our landmark report.

One nice feature I’ll mention though is this — if you want to remove a particular landmark from a group because it doesn’t belong there, just click on the “minus” sign near the landmark name in the report:

Easy landmark removal from a group within the GPS Insight landmark report

You are given a chance to “OK” or cancel the deletion:

Easy landmark removal from a group within the GPS Insight landmark report

This is a great example of how our reports allow you to interact to create/delete/remove landmarks, pull up maps, etc. We are always trying to make the product more able to answer questions about your fleet, and the interface easier for you to do so efficiently.

It truly took me 3 minutes to get the answer to my initial question — but about an hour & 15 minutes to document it in this article. It’s a long one, thanks for reading it.

Thanks,
Rob.


Next Page »