Volkswagen ID Forum banner

ID.4 Self-reported trip database.. any interest?

655 Views 7 Replies 5 Participants Last post by  branden
This popped into my mind a few days ago while reading a thread about route planning.

I wanted to put this out there and gauge any interest in creating a self-reported route database of longer road trips. Basically what I am thinking is setting up a Google doc spreadsheet (or something similar) with various different data elements. The idea being anyone can access and see if anyone's entered a route or similar they're trying to plan and want some info from folks who've already driven it. I know there are planning apps, but they aren't perfect and often can't really account for real word conditions (I know some apps like ABRP have additional functionality, but it isn't free and I think requires additional hardware?)

Some thoughts ive had (these are just ideas, absolutely open to removing some and including others) about possible info to include:
  1. starting destination (at a minimum a city but I'm thinking a POI nearby, i.e., walmart)
  2. End destination
  3. charging stops used along the route(and addresses),
  4. weather (temp, time of year),
  5. road conditions,
  6. Traffic
  7. Speeds
  8. battery % when starting, at charging stops and ending,
  9. total miles driven,
  10. other context/considerations
  11. etc.,
I'm not sure if anything like this already exists, but just as an idea, it seems like it could be a useful tool for planning longer road trips in an ID.4. It obviously requires self reporting which has limitations, but it could at least help give folks a starting point.

Assuming there is interest, I definitely have no issues setting something like this up for public access.
1 - 3 of 8 Posts
It will require great amount of time and knowledge to make it work......and have it free for others to use...most difficult part is going to be obd2 dongle and integration and formulas to show the data that people are actually interested....and on top of that you will need specific PID addresses to pull this data.
For clarity, I wasn't suggesting to use OBD monitors and pulling data, it's literally just a self reporting guesstimate of whatever. I.e., I drove from DV to San Diego, I drove XXXX miles, I stopped at 123 Walmart st., it was roughly 65° and sunny. It wouldn't be anything that would require pulling anything just remembering and typing it in so that if someone is looking for info on a road trip and someone has done it there's something there to review.
Sounds like a great idea... but... but... but... :giggle:

The manual data entry overhead is much, much more daunting than you realize. I've done this very thing with several of my vehicles, mostly by keeping gas receipts and batching entries to a spreadsheet, with notations for exception conditions like very cold weather and so on. The amount of time this takes is huge.

I was doing this to track efficiency and cost of operation. What I discovered is that nearly everything I needed to know was documented in the first 10K of ownership, anything further was simply confirming the trend to two decimal places. The most eye-opening use of the information in one case was discovering that with two otherwise identical cars, one a MT, the other a hybrid, cost of operation of the hybrid was higher. Ain't that a kick in the head?

Anyway, there are a boatload of phone apps that do this for you, mostly for business expense documentation. Just find one that hits most of the points you need and tweak with manual notes whenever needed.
I've done similar things like this too, and do it a lot for work. I work in research and at times have to do a lot of manual data entry with a ton of data elements. At the end of the day it would just end up being however much someone wants to put into it and would serve as a reference to help people plan a longer trip the first time around. If someone's already entered a trip, i.e., Durham to Fairfax in my case, I don't think someone would need to re-enter the info, someone could just add to it if they wanted.

I've done a lot of traveling up/down I-95 because my Spouse has been up in Fairfax finishing a clinical (we live in Durham NC) and am very familiar with that route, where to stop, the road/weather conditions I've driven in etc. I am going to create a Google doc spreadsheet to test it out and post it and keep track of how long it takes to enter it. Anyone would be able to enter as much or as little as they want. The info like weather, traffic, road conditions, speed, elevation that's kinda the icing on the cake.

You are correct, there are a ton of apps, but that would only be useful to me. Whereas what I am suggesting, if I wanted to plan a trip from Durham to Boston, if someone's done it and entered some info, I could just quickly use that as a reference. For me personally, just having an anecdote from someone who's driven a specific route would be helpful to reduce things like range anxiety and worrying about if I will make it somewhere, the best place to stop etc.

Unrelated. Thats really bizarre to hear about operating costs of a hybrid relative to the MT. Any idea what made it higher?
See less See more
1 - 3 of 8 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.