Adding multiple entries at once? - Fuelly Forums
Go Back   Fuelly Forums > Fuelly Community Support > Fuelly Web Support and Community News
Search Today's Posts Mark Forums Read
Thread Tools Display Modes
Old 10-30-2008, 04:15 PM   #1
Registered Member
Join Date: Nov 2008
Posts: 274
Country: United States
Adding multiple entries at once?

I've been logging my gas mileage in a spreadsheet for over a year now (about 100 entries for 2 cars) and I'd like to put it all online, but my time is at a premium right now and I don't really care to go through all of it at once. Is there any way to input a string of data or straight from a spreadsheet? This seems like a big investment to start an online gaslog if one has already been doing it independently.


BDC is offline   Reply With Quote
Old 10-30-2008, 04:44 PM   #2
Registered Member
theholycow's Avatar
Join Date: Apr 2008
Posts: 6,624
Country: United States
Send a message via ICQ to theholycow Send a message via AIM to theholycow Send a message via MSN to theholycow Send a message via Yahoo to theholycow
You could put summary entries in. Use your spreadsheet to add it up into groups of two or three months at a time. Then, later when you are not so busy, you could put in all your detailed data.

When you fill out a form in your web browser, the data is usually submitted as part of the URL that it retrieves. So, once you fill out the form and hit submit, instead of retrieving the page "", it might try to retrieve something like " =BlahBlahBlah". The server sees that and reads all the data that follows the '?' as your data.

It may be possible to generate the URLs from your spreadsheet. I think you could do something like:$B2&Gallons=$C2&Miles=$D2&Notes=$E2
where B2 is the cell with the date (properly formatted), C2 is the cell with the gallons, etc. I'm not a whiz with spreadsheets.

Ok, I just tried it. It's pretty messy.
The "uid" and "garage" fields are individual to the person and vehicle. The "month" field is obvious:
The '10' there is the month. Day and year work the same, as do distance, fuel, cost, and notes, for which I entered 1111, 22, 333, and "My Notes" respectively. You'll notice that the spaces in "My Notes" were replaced with a '+', which is somehwat uncommon for these forms. Anyway, if you can make the spreadsheet make strings like that one, it could work, and you could then just save the list of URLs as a text file and use wget for Windows as follows:
wget -l nameOfYourTextFile

See, piece of cake!

(It's either this, or do something more useful...and I'm one hell of a procrastinator.)

This sig may return, some day.
theholycow is offline   Reply With Quote
Old 10-30-2008, 08:30 PM   #3
Registered Member
GasSavers_BEEF's Avatar
Join Date: Apr 2008
Posts: 1,831
another concept is that if you have been keeping a personal gas log and you haven't implemented any of the techniques and modifications that are discussed here, you may want to simply add one or two tanks so that your average isn't killed by all of the miles traveled before you started on this site.

I didn't have a gas log before this site but I do remember waiting for those first two tanks to drop off of my 90 day average. it seemed like forever and my mileage stayed low for qite some time even after I heavily modified my car and started driving with the scangauge.

another idea is that you could enter them in, in reverse order. I don't think it cares in what order you do it. you could enter in a few at a time when you get time and at least you will have your most current ones in there.
Be the change you wish to see in the world
--Mahatma Gandhi

GasSavers_BEEF is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Total gallons per year? liquoredonlife Fuelly Web Support and Community News 1 10-01-2010 02:24 AM
CSV upload lordtaco Fuelly Web Support and Community News 4 08-07-2008 11:26 PM
Right lane roller roll call! Fourthbean General Fuel Topics 3 03-14-2008 02:05 PM
Guess I am "unstable..." unstable bob General Discussion (Off-Topic) 7 08-16-2007 09:35 PM
92 mpg, 180hp, 12.9s 1/4 mile non-hybrid petrol car DrivenByNothing General Fuel Topics 18 04-28-2007 05:14 PM

Powered by vBadvanced CMPS v3.2.3

All times are GMT -8. The time now is 01:13 PM.

Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2016, vBulletin Solutions, Inc.