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 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: , , , , , , , ,


Jun 02 2012

New Hierarchy Editor available within GPS Insight

Our first Hierarchy Editor served us fine for large customers using our Hierarchy capabilities.  However, as customers got bigger, they had more requirements, and we just launched a brand new version of this editor today.

If you don’t already have the Hierarchy capability turned on within GPS Insight call support or your salesperson (if you are a large customer, it’s worthwhile, but it’s overkill if you don’t have a few hundred vehicles).

Here is how you launch it within the GPS Insight portal:

Launching GPS Insight's Hierarchy Editor

Launching GPS Insight's Hierarchy Editor

Then you will be taken to the new editor:

New GPS Insight Hierarchy Editor

New GPS Insight Hierarchy Editor

Some of the nice new and previously available capabilities include:

You are able to see ALL object types assigned to a node at once and expand them:

See all objects associated with a Hierarchy Node at once

See all objects associated with a Hierarchy Node at once

You can Minimize them easily with one click of the “minus’ at the top of any group:

Collapse a tree easily
Collapse a tree easily

And you can easily drag and drop any unassigned objects after filtering them (in this case, we entered “ba” to restrict to those vehicles containing “ba” and then selected two, and assigned them to the “BAK” branch which had been selected on the far left):

Drag and drop to assign vehicles, landmarks, etc.

Drag and drop to assign vehicles, landmarks, etc.

Additionally, the custom hierarchy group editor has this new look and feel:

Hierarchy Custom Group Editor

Hierarchy Custom Group Editor

One of the nicest capabilities is the ability to scroll should you expand the hierarchy tree taller than your window — that was always a restriction in the last version.

Please let us know if you are interested in using the hierarchy and we will work with you to ensure it is made available appropriately.

Thanks,

Rob.

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


May 02 2012

New “rapid edit” mode for tedious updates in GPS Insight

With some of our new capabilities (Categories and Attributes) coming soon, we have been making some major changes to the interface to ensure our customers (AND WE!) don’t spend too much time editing things “one at a time.”

One major internal area we needed improvement for was a set of vehicle-specific device options which our fulfillment and support staff use all the time.

They complained that whenever we need to update a large number of devices all at once (thankfully a problem for us — we’ve been selling a lot of large deployments lately), they need to edit the vehicles one at a time.

No more!  We have a new interface control which allows for quick and easy “all at once” editing — we launch it here (from our new “one click” list):

Open the GPS Insight "edit multiple vehicles" menu

Open the GPS Insight "edit multiple vehicles" menu

This allows us to rapidly edit ALL administrative options for vehicles:

Rapid edit tool for administration of vehicles (and more)

Rapid edit tool for administration of vehicles (and more)

(bear in mind the prior screen is for our internal account, which is why many “guinea pig” devices haven’t reported for a while — we don’t always clean these up right away…)

Note that the “tab vertically” option is set automatically and allows us to rapidly enter values or use the space bar to toggle options then tab to the next vehicle vertically.

Ghost "saved" icons show you what's been modified

Ghost "saved" icons show you what's been modified

And whenever you make a change, the green “checkbox” lights up to indicate that it’s been saved.  Then it fades to a light green checkbox, so you can see which values were changed overall.

That allows you to go back and ensure you changed the correct vehicles (and lets me go back and reverse my “for the blog” changes easily).

We will add this capability where appropriate.  Previously, if we wanted to edit all these vehicles, we would have to click on the pencil icon and then edit each one individually.

Thanks to everyone buying lots of devices to force us to streamline this for ourselves and our customers!

Rob.

 

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