Mar 01 2013

Exclude sensitive speed data in certain reports

A customer recently requested that we not include “Max Speed” in a summary report for them, where the recipient only wanted to see utilization, mileage, and idling information (etc.).

We added this account/user level permission here under user options:

Exclude Max Speed from summary reports

Exclude Max Speed from summary reports

When running a typical Summary Report:

Running a Summary Report with/without Max Speed

Running a Summary Report with/without Max Speed

With the Max Speed included:

Max Speed Included

Max Speed Included

And removing it by checking the “Suppress Max Speed” box, the entire column disappears from this and other reports (as well as scheduled versions of this and other reports):

Max Speed Column is removed

Max Speed Column is removed

Thankfully, customer requests such as this are easy for GPS Insight to accommodate given our flexible architecture.  We’re always happy to implement customer requirements as options which benefit our overall customer-base.

Thanks,

Rob.

 

Tags: , , , , ,


Nov 26 2012

New jobsite mileage GPS tracking report saves customer 4 hours a month

We have a new customer with a few hundred vehicles.  But they have 4 delivery vehicles whose miles need to be internally billed to each of their various job sites for accounting purposes.  It takes one of their employees about 4 hours each month to get this data out of the current stop detail report we provide.

They asked us if we would build them a custom GPS tracking report to help.

Here’s a depiction of how they assign mileage to job sites:

Delivery workflow & mileage calculation

Delivery workflow & mileage calculation

All mileage from the warehouse or another job site needs to be allocated to the NEXT job site reached, to include miles spent going to non-job sites (such as McDonald’s, above).

The mileage spent heading BACK to the warehouse needs to be assigned to the most recent job site serviced.

Rather than go through a stop/detail report, line by line, for hundreds or thousands of trips for a month, we created this consolidated GPS tracking report, called the “Delivery Vehicle Mileage” report:

New Custom Delivery Mileage Report

New Custom Delivery Mileage GPS Tracking Report

Here is the output with client specific information blurred out:

Easy totals for mileage to job sites

Easy totals for mileage to job sites

Note the red arrows illustrate mileage TO the job site, and a couple blue arrows show mileage FROM the job site deadheading back to the yard.

Any group of vehicles as well as starting/reset landmarks such as a warehouse and job site landmarks may be chosen and it can be run for 31 days at a time (and we can always increase that restriction if the number of vehicles/landmarks are reasonable and you need quarterly reports instead).

And the best part: Instead of it taking this customer 4 hours a month to tabulate through a mind-numbing stop detail report, they can now run it in about 2 seconds with this report we built for them (and any customers who may require it in the future):

2 seconds to do 4 hours work

2 seconds to do 4 hours work

As always, we appreciate customer requests, and accommodate them better than any other GPS Tracking provider out there.  Keep them coming — when we help our customers, we help the product as well!

Rob.

Tags: , , , , , , , , , , , , , , , , , , , , ,


Sep 11 2012

New Time Format Preference (17:00 vs. 5:00 PM)

We’ve been asked to add this capability for a long time, and finally went through the entire product and added the ability for customers to choose which time format they prefer — 12 or 24 hour (military).  We used to ONLY allow military time across the entire site.

Just open up user preferences, and choose your time format preference:

Change your Time Format user preference

Change your Time Format user preference

And all Reports, Administration, Alerts, Maps, etc. will show the proper time format moving forward:

GPS Insight Activity Alert with AM/PM time

GPS Insight Activity Alert with AM/PM time

AM/PM Time in Administration Screens

AM/PM Time in Administration Screens

And here are side-by-side alerts (different alerts), one with an account which chooses military time (the default) and one with 12 hour format AM/PM time:

2 different time formats in GPS Insight

2 different time formats in GPS Insight

This is probably the longest-standing customer request we had, and we finally took the time to make all the customers who wanted this feature happy.

Sorry it took so long, but now you can have your time format your way!

Thanks,
Rob.

 

Tags: , , , , , , , ,


Sep 04 2012

When idling really hits home

As someone who works daily in the GPS Fleet Tracking space, I’m all-too aware of how much fuel is wasted by vehicles regularly by idling.  Plus I’m very sensitive to it when walking around in the Phoenix area where I live.  Just like that kid in Sixth Sense saw dead people, I see idling people.  And GPS tracking generally helps them all.

I saw a TRULY DRAMATIC example of how much fuel is wasted while I was idling the other day — when trying to return a rental with a full tank after only having driven it for about 25 miles (from the airport to our office in Orange, with a side trip to the mall & back for lunch).

I used Google Earth to get a feel for how many miles it takes to move the needle on a full tank of gas on a rental car:

Computing mileage to & from the airport

Computing mileage to & from the airport

I was coming to the airport, & needed to fill up the tank to return the car.  But I could NOT find a gas station.  I was running late so I just brought the vehicle back, knowing it would cost me $9.65 per gallon if I didn’t fill it if and the fuel gauge fell below F, where it had been all day.

 

Fuel gauge moves when idling

Fuel gauge moves when idling

When I pulled into the garage it was still on “F” — I parked and left the vehicle running since I know they need to view the odometer & fuel before cashing me out for my receipt.

I literally sat there and watched for about 2 minutes while the needle dropped from F to 7/8th of a tank!  Right in front of my eyes.  Arggggg!

Of course, I realize that the needle isn’t 100% accurate, but idling for that 2 minutes was all that needle needed to drop back down to where it belonged — definitely not F after 25 miles in an SUV.

It was a Chevy Tahoe with a 26 gallon tank.  At $9.65 per gallon “refill” rate at the rental company, those 2 minutes idling was going to cost me over $30!

Luckily my attendant didn’t pay close enough attention and I got away without getting gouged for those 3 gallons of fuel.

Either way, it was a truly poignant way of visualizing the wasted fuel associated with idling.

Here is a graph I made of the # of gallons a fleet of close to 1000 vehicles wastes idling in a month, which considers the LENGTH of the idling:

Fuel wasted idling with idle stops of minimum durations

Fuel wasted idling with idle stops of minimum durations

Essentially, if this client could cut all idling to 15 minutes or less, they could save over $15,000 per month.  If they could cut out all idling > 5 minutes, the savings are nearly $28,000. (this is based on an average of $4 per gallon, as half their vehicles are diesel, and half are gasoline).

Interestingly, the WORST offenders of idling, in the 60+ minute category, account for less than $2,000 per month — it’s everyone idling 5 minutes (vs. 1) which really comprises the majority of the wasted fuel which can actually be cut out.

Not every fleet and vehicle function can eliminate idling.  PTO sensors help us to distinguish between “true idle” and “working idle” times.  But this is food for thought.  And a really simple way to pay back almost all of your GPS Tracking expense, if you can enact programs which meaningfully curb idling.

Here are some other articles about idling and how we help customers to reduce or eliminate it.

Thanks,

Rob.

Tags: , , , , , , ,


Aug 19 2012

2 REALLY POWERFUL new features coming soon

GPS Insight is about to launch two new highly powerful capabilities:

  • Hierarchy-based vehicle permissions
  • Custom Filters for Attribute and Category data

They may not sound like much, but for very large deployments, they’re CRITICAL to help avoid nightmarish administration tasks.

Here’s how they’ll work:

Hierarchy-based vehicle permissions:

First, you need a hierarchy (or 3, as shown in this example — one for geographic location, one for type of vehicle, and one for type of fuel):

Geographic "nodes" assigned to a user

Geographic "nodes" assigned to a user

Let’s say we want a new user (in this case, called “ar-atl”) to have access to Georgia (GA), Nevada (NV), as shown in green above, plus ALL THEIR CHILDREN.

We can assign ONLY these 2 nodes to that user, and specify how “far down” the tree we want to grant permission (e.g. maybe down to the city such as Reno, NV (REN), but NOT beyond that to the West Reno, East Reno, etc. levels, if they existed).

We can do that like this, as well as add all “Function: Delivery” and “Type of Fuel: Green” to this user.  This way they’ll get ALL the members of Delivery and Green (e.g. CNG, Electric, Hybrid, Volt, etc.), as shown below.  We can add multiple nodes to a user per hierarchy, such as BOTH GA and NV for the US (Geographic) hierarchy:

Assigning permissions on Hierarchy Nodes to users

Assigning permissions on Hierarchy Nodes to users

Hovering over the user now shows you the permissions assigned to that user:

Permissions assigned and inherited by users

Permissions assigned and inherited by users

This allows us to provide Hierarchy capabilities to ALL users — not just administrators, as it has previously been available.  PLEASE BEAR IN MIND that the hierarchy is available ONLY to large accounts (e.g. > 100 vehicles) as it is generally unnecessary for small fleets, since they can use vehicle groups to do the same thing.  If you are a large fleet customer of ours, and are not currently using the hierarchy, you can contact Sales or Support to ask for it to be turned on for  your account.  It is a HUGE time-saver in many ways, and you can click here for more information on the Hierarchy capabilities of GPS Insight.

Now onto Custom Filters for Attribute and Category data:

Initially they will be available on 2D mapping, shown here, by pressing the “Attributes and Categories” button (and I’ve already restricted the vehicles by choosing a Group when launching the map (All Vehicles) and choosing ONLY vehicles with the letter “e” in them, using the “Filter List:” box:

Accessing Filters in GPS Insight

Accessing Filters in GPS Insight

This opens up a screen which allows you to create a highly specific filter, based on any category and attribute data you may have specified for your vehicles.

Here, I’ll create a very loose filter which requires ANY (vs. ALL) of the 3 conditions to be met:

Filtering vehicles with custom categories and attributes

Filtering vehicles with custom categories and attributes

Since “Alena” has one of the “Compressor, Generator, Jackhammer & Winch” which are specified in the 2nd criteria, the vehicle shows up on the map:

Vehicle matches the filter

Vehicle matches the filter

If I change the filter to ALL (and some other changes), we get only the single vehicle which meets those criteria:

New, more restrictive filter

New, more restrictive filter

Fewer vehicles match this filter

Fewer vehicles match this filter

Fewer vehicles match this filter

Fewer vehicles match this filter

And note that you can SAVE your filters for future use:

Saving a custom filter in GPS Insight

Saving a custom filter in GPS Insight

And use them like this:

Using a previously saved filter

Using a previously saved filter

This will really help ALL our customers to better utilize and benefit from this functionality by filtering maps, and soon reports, dashlets, and alerts with HIGHLY custom data which they can assign to vehicles.  Filters will also eventually apply to OTHER areas of GPS Insight where categories and attributes are assigned — for instance running a report on only landmarks in the “Customers” group of landmarks which have a “to be serviced by” date in the next 7 days.  Or sending idle alerts for vehicles which don’t have the “ignore idle” attribute set to “yes.”

There’s no practical limit to how complicated you can make these filters — there is the ability to “nest” them within each other so you can say things like:

“Only show vehicles which are corporate unless they are both personal and have a winch, but exclude all of those whose registration expired before today.

Both custom filters and hierarchy based permissions will be available to all customers by the end of August, and as always, we will continue to add functionality as it is required by our customers.

Enjoy & Thanks!

Rob.

Tags: , , , , , , , , , , , , , , ,


Aug 06 2012

Choose which reports your users can run with new “Menu Permissions”

We have quite a few reports available now, and some of our customers don’t want to make them all available to all end-users.

Now you can choose which reports do & don’t show up for each user, at the user level.

You can launch this capability here:

New GPS Insight Report Permissions

New GPS Insight Report Permissions

This brings up a list of reports across the top and a list of users vertically, where you can choose which reports are available to each user by checking/unchecking each box appropriately — for instance we will take away all but the Activity Detail, the Diagnostic Reports, and a Custom report called “Loaner Vehicles” for the user ar-ant.

Restrict Reports for certain employees

Restrict Reports for certain employees

Notice the usability enhancements where we allow you to tab/space vertically OR horizontally to easily use the keyboard to make several changes quickly (space changes the selection of a checkbox and tab/alt-tab push you to the next/previous checkbox based on whether or not you have the “Tab Vertically” option chosen.  Also, when you make a change, a green “checkbox” is shown, and gradually it turns dim so that you can see which changes you made most recently, or since you opened up the page.

Now when we log in as that user, we ONLY see the reports which have been granted to us:

Restricted Report options

Restricted Report options

We wanted this functionality out there sooner rather than later for a particular customer, so as I document it, I see we’re missing a few “must haves” — specifically the ability to rapidly “toggle all” for a user, a report, or a group of reports, to make it less time consuming for large customers.  Additionally we need a “default reports” setting where the admin user can set what permissions a new user will receive without having to go in and change them.  Last, we will EVENTUALLY need to support user “roles” (e.g. maintenance, management, dispatch) so we can either “apply” those roles’ permissions easily to members of those roles or assign users to those roles to augment their  permissions.  This will be a while though, as we have roughly 10,000 users so far and we’ve only heard that request a few times (plus it will be a lot of work, but eventually necessary).

The first 2 will be there in the next day/week, and next we will allow the same type of user-granular permissions for dashboard dashlets, map options, and alerts over the next few weeks.  Happy restricting!

Rob.

Tags: , , , , , , , ,


Jun 30 2012

More expensive GPS System beats that of a low cost one by $70/month

There is a fantastic article written by Chris Wolski which was just published in Automotive Fleet which talks about Telematics adoption and ROI rates over the past several years (2008-2011). [based on a survey taken by ARI, Donlen, and PHH]

The article is here.

It states that the range of MONTHLY ROI for a telematics initiative in 2011 was $185 – $225 (up significantly from $80-150 in 2008):

GPS Initiative ROI 2008-2011

GPS Initiative ROI 2008-2011

What the article does NOT mention is service prices, and the fact that the range in monthly ROI is very likely attributable to the overall capabilities of the GPS tracking solution chosen (e.g. bare-bones vs. high-end).

Amortizing the survey’s stated cost of the hardware over 4 years makes a $3.13 monthly difference between low and high-end.

Today’s service prices tend to range between $25 and $33 per month per vehicle and correlate to hardware costs (e.g. higher priced hardware tends to have higher priced service and ultimately higher ABSOLUTE ROI).

I did some basic math in Excel and calculated the PERCENTAGE ROI (vs. the ABSOLUTE ROI of $185-$225 provided in Chris’s article).

I found the percentage ROI was 734% for the low end solution, and 733% for the high end solution.  The percentage ROI is the SAME between low and high end solutions!

ROI % for high end and low-end GPS are both ~733%!

ROI % for high end and low-end GPS are both ~733%!

Therefore, companies are going to save an EXTRA $70 per month, per vehicle, according to the survey (taken by ARI/Donlen/PHH), by purchasing a higher end gps fleet tracking solution.

Within 2 1/2 months, the extra cost of the better solution has paid off for the incremental $150 in hardware and $3.13 per month.

And over the next 45 1/2 months (assuming a 4 year life on the hardware), an extra $3,185 flows to the bottom line PER VEHICLE.

For 100 vehicles, that’s $318,500.  And that’s ON TOP OF THE LOW END ROI — a total ROI of $1,224,000!

Obviously your exact savings will differ, but if you trust ARI, Donlen, and PHH, 3 of the biggest fleet leasing companies in the space, the message is clear:

Buy a higher end GPS Tracking solution and SAVE MORE!

I always use the following analogy when talking about ROI between a low end and high end GPS tracking solution (e.g. one which has more reports, more adaptability, better alerts and maps, and more API’s, etc.):

If you can buy a bar of SILVER for $25, that’s a great deal, and will give you fantastic ROI.

If you can alternately buy a MORE EXPENSIVE bar of GOLD for $40, your ROI is VASTLY more than if you purchased the bar of silver.

Better ROI for paying extra for a bar of gold vs. silver

Better ROI for paying extra for a bar of gold vs. silver

The bar of gold costs more, but will yield significantly more ROI if you pay the small premium.

We hear this ALL THE TIME — “we went with the lower cost solution.”

Unfortunately it’s not about absolute cost — it’s about the OPPORTUNITY COST of not going with a solution that will really fit your costly business challenges in a way that a higher end (and slightly more costly) solution does.  And by the way, those customers usually cancel and go with higher end solutions later on once they determine this for themselves.  I hope this article helps companies from making the wrong “penny-wise, pound-foolish” decision.

Thanks again for the great article Chris.

Here is a link to the charts in that article.

Thanks,

Rob.

Tags: , , , , , , , , , , , , , , ,


Jun 24 2012

Powerful new capabilities for Custom Categories and Attributes

We recently added new custom categories and attributes to GPS Insight for any customer to add highly business specific data to their vehicles, drivers, users, landmarks, and hierarchy nodes.

There are some new ways to utilize this feature, as well as custom filtering coming soon to the 2D map screen.  These filters will eventually support report, alerts, API’s, etc.

For instance, you will be able to click the new “attributes and categories” button on 2D mapping (shown below) and add HIGHLY CUSTOM filters for which vehicles are shown:

New Attributes and Categories in GPS Insight 2D Mapping

New Attributes and Categories in GPS Insight 2D Mapping

In this example, I am filtering on only vehicles which EITHER are Route Number less than or equal to #15 (e.g. 1-15) OR BOTH a Corporate Vehicle with BOTH a Compressor AND Winch:

Highly Custom Filter in GPS Insight

Highly Custom Filter in GPS Insight

Once I save that filter, only some of the vehicles remain, and when I choose one (Andrew PNP) I can tab to the “Custom” tab in 2D mapping and see how that vehicle matches our filter:

Since it was EITHER [any] (not both), the fact that the route #8 is less than/equal to 15 which causes this vehicle to be chosen, not the Specialized Equipment, since it doesn’t have a Winch in addition to the Compressor and Corporate ownership.

Filter Vehicles in GPS Insight Mapping

Filter Vehicles in GPS Insight Mapping

Note that there is a convenient “Edit: Attributes” link which takes me to the proper screen where I can add that winch, or something appropriate:

Edit Categories and Attributes in GPS Insight

Edit Categories and Attributes in GPS Insight

You just need to click the “green check” between “Specialized Equipment” and the vehicle icon at top to bring up the options available.  Then edit the vehicle to include a Winch and next time you check, that data has changed:

New Category assigned to Andrew PNP

New Category assigned to Andrew PNP

I also went and changed the “Any” to “All” so now ALL 3 restrictions must be met.  Now very few (5) vehicles are shown, as the filter is much more restrictive:

GPS Insight map filter

GPS Insight map filter

Some of these capabilities exist already, and some will be released shortly.  Filters will eventually be something you can save, and use with reports and alerts.  We’ll keep you posted on when these capabilities make it to GPS Insight.

Thanks,

Rob.

 

Tags: , , , , , , , , , , , , , , , , , ,


Jun 04 2012

Nearly 100,000 database operations a minute at 3ms per! (we’re fast)

During peak hours, we see quite a bit of database activity.

Our customers’ vehicles are reporting every minute or two typically, and they are querying to see where they’re at using maps, reports, alerts, and API’s CONSTANTLY during peak hours.

On a very busy day, last Friday, 6/1/12 (the day all the monthly reports for May are generated), this is what our 2 busiest databases looked like:

GPS Insight database utilization through the day

GPS Insight database utilization through the day

Note that the top of this graph is only 50% of total utilization, and we have a sustained, average peak utilization of just 15% of capacity.  Click the graph for a VERY large version.

This is our second busiest database, with a little more detail on what the various “hills” in utilization mean (batch processing, monthly reports, etc.) — again, the top of the graph is only 50% of utilization:

GPS Insight database utilization through the day

GPS Insight database utilization through the day

We are barely scratching the surface of our database’s capacity.  The same is the case for all our other systems which comprise the GPS Insight product.

(By the way, green means disk utilization, and red means memory utilization)

So what does this mean to our customers?

I just took a quick look today at just how many, and just how fast the typical query comes back during peak hours (10:30 PST is a peak time for us across the US):

We have systems in place to capture literally all of the nearly 100,000 queries per minute which hit these two busiest databases — here I simply choose the last 5 minutes to see everything which ran and run reports/statistics on it:

Showing last 5 minutes worth of database activity

Showing last 5 minutes worth of database activity

The data is loaded in just a few seconds:

Loading hundreds of thousands of logged database statements in seconds

Loading hundreds of thousands of logged database statements in seconds

And among the various reports I can run, we see what is called “service level” — this is how quickly we typically return the nearly 100,000 database queries (SQL) per minute which we receive throughout our system:

~3 millisecond response times

~3 millisecond response times on our busiest database server

~3 millisecond response times

~3 millisecond response times on our 2nd busiest database server

For these two database servers, we processed over 465,000 commands in 5 minutes, with an average response time of roughly 3.3 milliseconds (ms = thousandth of a second).

99.8% were taken care of in less than 200 ms.

That is a lot of processing for our customers’ benefit, and very fast, as well.

We keep our systems as responsive as possible in order to ensure to you that your vehicles’ locations, your API calls, and your reports and alerts will always be very fast and always available to you.  Bear in mind each database server has at least one “twin” which is always in sync, should it ever experience a failure.

Also, please realize that we are processing 1550 operations per SECOND on these 2 servers at a 3 ms. average response time.  That’s FAST.

Hopefully this helps you to understand what we do behind the scenes to manage your data and make it very fast for you to retrieve to help run your business.

Thanks,

Rob.

Tags: , , , , , , , ,


May 17 2012

How Custom GPS Tracking Reports are made

We received a request today from a Government customer which I think is both a great idea, as well as something worth documenting in the blog.

At first glance, it’s a “simple” request:

“We want to report on driver take-home miles since that benefit is taxable to the driver.”

Here is a diagram of how “complicated” that request really is:

Personal Usage Report Complexity

Personal Usage Report Complexity

Here’s why it gets so complicated quickly:

  • Need to define work sites
  • Need to define homes
  • Need to assign homes to each vehicle
  • Need to specify what hours are “allowable” for work
  • Need to specify how long a vehicle must be at a work landmark for it to be part of the “workday”
  • Need to allow for automated or manual “personal or business” status for each trip
  • Need to Schedule on a semi-monthly basis to correspond to payroll for tax withholding to be made

Thankfully, we have all of these capabilities built already — just not 100% integrated for the purposes of this report.

Taking seemingly unrelated aspects of a GPS Tracking product and combining them is the way to succeed — both for our customers as well as for us against other products — and a core aspect of how we approach our product and custom requests.

Taking these separately:

  • Need to define work sites
  • Need to define homes

You can both import spreadsheets as well as organize landmarks into meaningful groups and hierarchical structures in GPS Insight:

Grouping and Import of Landmarks in GPS Insight

Grouping and Import of Landmarks in GPS Insight

  • Need to assign homes to each vehicle
  • Need to allow for automated or manual  “personal or business” status for each trip

We recently launched user-specified, highly customizable attributes and categories. All we need to do is add support for two things — a landmark to be assigned to a vehicle or driver, etc. to specify their “home” (and to keep it highly flexible, we will generically support any GPS Insight object of any sort, such as vehicle, group, hierarchy node, etc.), as well the ability to categorize trips and stops (currently announced, just not yet officially supported).

  • Need to specify what hours are “allowable” for work
  • Need to specify how long a vehicle must be at a work landmark for it to be part of the “workday”

These parts of this new report already exist in other standard report parameters, shown here in our Drive Time Summary Report and Begin/End of Day Reports, which already partially solve the problem this customer has:

Time Restriction on vehicle activity

Time Restriction on vehicle activity

Exclude first and last trip from payroll report based on stop time

Exclude first and last trip from payroll report based on stop time

  • Need to Schedule on a semi-monthly basis to correspond to payroll for tax withholding to be made

Our Schedule creation tool for Scheduled Reports allows you to be highly custom in the dates for which a custom report is run.  Plus you can always combine two separate schedules (e.g. the first Monday of every week plus every 15th and last date of the month) when scheduling a report:

Defining a custom report schedule within GPS Insight

Defining a custom report schedule within GPS Insight

So, the pieces are all there!  There is a little bit of new development necessary, and then a fair amount of integration in order to complete this report for production usage.  It is really helpful to be able to draw on prior capabilities in order to create highly custom reports which help not only this one customer’s needs, but many current and future customers’ needs.

I’ll keep you posted on the progress of this GPS tracking report, and aspects we develop for it will then become pieces of future development efforts.

Rob.

 

Tags: , , , , , , , , , , , , ,


Next Page »