The Sportster and Buell Motorcycle Forum - The XLFORUM®
 

Go Back   The Sportster and Buell Motorcycle Forum - The XLFORUM® > SPORTSTER MOTORCYCLE FORUM > Sportster Motorcycle General Discussion and Problems
XLF Blogs XLF Arcade XLF Disclaimer/Privacy Statement/Terms Of Use

Sportster Motorcycle General Discussion and Problems For discussing problems about your Sportster motorcycle that don't fit anywhere else.

Active Threads
10 New rider - XL1200S in Aus.
Last Post: Commando
Posted On: 5 Minutes Ago
Replies: 63
Views: 4,723
14 Iconic Parts that say it's a Harley!
Last Post: Toejam503
Posted On: 12 Minutes Ago
Replies: 10
Views: 495
0 stress killer
Last Post: Nibelungen
Posted On: 27 Minutes Ago
Replies: 280
Views: 43,837
0 starter block off plate
Last Post: thefrenchowl
Posted On: 36 Minutes Ago
Replies: 7
Views: 118
0 2019 East Coast Meet and Greet
Last Post: rokytnji
Posted On: 50 Minutes Ago
Replies: 12
Views: 176
0 You asked for it! "The Tess' Coffee Thread"
Last Post: rokytnji
Posted On: 59 Minutes Ago
Replies: 10,416
Views: 747,886
0 Sportster Rims
Last Post: neetch
Posted On: 1 Hour Ago
Replies: 8
Views: 719
0 What are you drinking tonight?
Last Post: rokytnji
Posted On: 1 Hour Ago
Replies: 1,926
Views: 115,086
0 Food porn
Last Post: sportytrace
Posted On: 1 Hour Ago
Replies: 991
Views: 142,933
0 Buell to Sportster wiring graft
Last Post: steveolds
Posted On: 1 Hour Ago
Replies: 4
Views: 178
0 Kr krtt xlr-tt xr...
Last Post: thefrenchowl
Posted On: 1 Hour Ago
Replies: 11
Views: 392
0 THE Trainspotting Thread
Last Post: Stairman
Posted On: 1 Hour Ago
Replies: 2,224
Views: 266,724
0 Official XL Forum Random Image Thread (NO NUDITY!)
Last Post: Stairman
Posted On: 1 Hour Ago
Replies: 42,233
Views: 6,543,660
0 Hottie of the day, no nudity.
Last Post: Stairman
Posted On: 2 Hours Ago
Replies: 9,192
Views: 754,819
0 Roads I'd like to ride.
Last Post: Stairman
Posted On: 2 Hours Ago
Replies: 808
Views: 52,094
0 ....1
Last Post: Graywolf
Posted On: 2 Hours Ago
Replies: 4,723
Views: 235,429
0 Hi from Tasmania
Last Post: DEEP DIVER
Posted On: 3 Hours Ago
Replies: 18
Views: 640
0 over drive
Last Post: Hippysmack
Posted On: 7 Hours Ago
Replies: 10
Views: 233
0 Understanding after market cam idle.
Last Post: thecarfarmer
Posted On: 7 Hours Ago
Replies: 12
Views: 528
0 Lets see your off season builds
Last Post: thecarfarmer
Posted On: 8 Hours Ago
Replies: 1,172
Views: 129,080
0 Really Hard to start XL1200 C
Last Post: Toejam503
Posted On: 9 Hours Ago
Replies: 3
Views: 127
0 VM38-9 Branch Backing Plate Tabs
Last Post: bustert
Posted On: 9 Hours Ago
Replies: 4
Views: 87
0 2016+ Roadster wheel PN
Last Post: Multihdrdr
Posted On: 9 Hours Ago
Replies: 26
Views: 5,796
0 Wheel Bearings Seals Changed?
Last Post: kuri77
Posted On: 11 Hours Ago
Replies: 5
Views: 304
0 95 1200 Sportster >>> roadworthy
Last Post: IXL2Relax
Posted On: 11 Hours Ago
Replies: 16
Views: 641
0 Crusty's Travels
Last Post: gravydog
Posted On: 11 Hours Ago
Replies: 1,764
Views: 191,825
0 Wish the brakes were better than the acceleration
Last Post: 1HD4CJM1X4K
Posted On: 11 Hours Ago
Replies: 34
Views: 993
4 What will 10 cents buy?
Last Post: Davo_137
Posted On: 11 Hours Ago
Replies: 73
Views: 20,643
0 Fork oil
Last Post: shanneba
Posted On: 12 Hours Ago
Replies: 9
Views: 242
0 New England 2018
Last Post: mick42
Posted On: 13 Hours Ago
Replies: 317
Views: 18,495
More...
Members Birthdays
kartooo (65), shotgun willy (49), jace (43), crosscut (41), 99fireredls1 (38)
Sponsored Links
Reply
 
Share Thread Tools Display Modes
  #1  
Old 4th April 2007
bplinson's Avatar
bplinson bplinson is offline
The XL Forum Host
 
Join Date: Nov 2004
Location: Somewhere in the woods, looking for a Geocache
Posts: 14,250
Sportster/Buell Model: 883>1250 Stage 2
Sportster/Buell Year: 2002
Other Motorcycle Model: Road Glide
Other Motorcycle Year: 2011
Reputation: 428684
bplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond repute
Default Bert's Fuel Economy / Mileage / L per 100 KM Calculator

I put this together a while ago and have been using it to track the fuel economy on my cars and bikes.

I figured I would share it with you so that you can also track you fuel economy if you want to.

The spreadsheet can be opened with Microsoft Excel or OpenOffice CALC (you can get OpenOffice for free at www.openoffice.org) and will automatically calculate your MPG or Liters per 100/KM.

The first sheet if for MPG calculations and the second sheet is for L per 100/KM. You can switch between sheets at the bottom of the workbook.

To start the calculations:

1. Fill your tank completely and reset your trip odometer
2. The next time you fill up write the miles or Kilometers from the trip odometer on your fuel reciept and reset your trip odometer. (also write down the total amount of fuel that it took to fill up if it is not on the reciept - take a mental note of the amount of fuel before you pay since some gas stations reset the pump right after payment and you may miss it if it is not put on the receipt by the cash register).
3. On the spreadsheet enter the Miles / KM ridden (you can also enter the TOTAL MILES / KM but it is not required)
4. On the spreadsheet enter the Fuel -Gallons or Fuel Liters

That's it!!

The spreadsheet will keep track of your total distance ridden since you started tracking it and the total avg fuel economy.

The spreadsheet is password protected. To unlock it the password is xlforum .

Attached Files
File Type: xls Berts-FE-TRACKER.xls (367.5 KB, 421 views)
__________________
Germany Bert - Site Admin - Author of the FAMOUS THREAD 13!

XLF on FACEBOOK - http://www.facebook.com/XLFORUM

AMA #961454

Last edited by bplinson; 18th April 2007 at 11:08..
Reply With Quote
  #2  
Old 4th April 2007
AZFlyingDiver's Avatar
AZFlyingDiver AZFlyingDiver is offline
The Horse is Un-Dead
 
Join Date: Apr 2005
Location: Valley of the Sun
Posts: 1,393
Sportster/Buell Model: XL 883 Custom (Stage 1)
Sportster/Buell Year: 2005
Reputation: 6200
AZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really niceAZFlyingDiver is just really nice
Default

Thanks, Bert! I kinda track this in my head every time I fill up ("hmmm, I got about 47 MPG this last tank...hmmmm"), but it might be interesting to save up the receipts and see how things go long term, after oil changes, during hot days vs. cold, "spirited" riding vs. leisurely... Then again, maybe I'll forget and just ride!


P.S. When ya coming back to visit the US of A?? The Indio, CA get-together a long while back was great.
__________________
'05 XL883C in Black Cherry (Stage 1, etc.)

'05 883C (living at 1100' above sea level near Phoenix, AZ)
S&S a/c, CS slash-cut slip-ons
45/175 jets, 2.75 turns out on the mixture screw, 1 needle shim
52.3HP, 46.2TQ

RIP Mr. Jimi and Johnny G...
Reply With Quote
  #3  
Old 4th April 2007
bplinson's Avatar
bplinson bplinson is offline
The XL Forum Host
 
Join Date: Nov 2004
Location: Somewhere in the woods, looking for a Geocache
Posts: 14,250
Sportster/Buell Model: 883>1250 Stage 2
Sportster/Buell Year: 2002
Other Motorcycle Model: Road Glide
Other Motorcycle Year: 2011
Reputation: 428684
bplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond reputebplinson has a reputation beyond repute
Default

Yeah, I track that way also but it is nice to have the exact numbers. I actully have a totally different spreadsheet for my tracking since I buy in liters but track MPG. If anyone one needs this spreadsheet let me know and I will post it also.

Probably will not get back to SoCal until next summer.
Reply With Quote
  #4  
Old 18th April 2007
davidcar's Avatar
davidcar davidcar is offline
Land Speed Record
 
Join Date: Jul 2006
Location: Australia-Ipswich
Posts: 756
Sportster/Buell Model: XLH 1200
Sportster/Buell Year: 2001
Reputation: 1250
davidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura aboutdavidcar has a spectacular aura about
Default

I got 42MPG but I ride pretty hard. Since doing my mods I picked up an extra 9miles to a tank before hitting reserve.
__________________
1200 XLH, "D" shaped exhaust port, SE 497 cams, 9.5:1 CR, 1.850 inlet & 1.615 exhaust valve, 48 primary & 190 main jet, NOKK needle no shim. 84TQ & 81HP
Reply With Quote
  #5  
Old 22nd June 2007
ditch68's Avatar
ditch68 ditch68 is offline
Biker
 
Join Date: Jan 2007
Posts: 79
Sportster/Buell Model: XLA Military! (sort of..)
Sportster/Buell Year: 1977
Reputation: 83
ditch68 is an unknown quantity at this point
Default

Great resource, thanks.

Jeff
Reply With Quote
  #6  
Old 31st July 2007
1Ray Hewett 1Ray Hewett is offline
Biker
 
Join Date: Apr 2007
Posts: 3
Sportster/Buell Model: 100th Anniversary
Sportster/Buell Year: 2003
Reputation: 10
1Ray Hewett is an unknown quantity at this point
Default

My mileage varies from 39 to 58 mpg. Strangely enough, the 58 occurred in the Colorado mountains.
Reply With Quote
  #7  
Old 31st July 2007
Quadcab666's Avatar
Quadcab666 Quadcab666 is offline
Biker
 
Join Date: Mar 2006
Posts: 40
Sportster/Buell Model: XL1200 Custom
Sportster/Buell Year: 2003
Reputation: 102
Quadcab666 is on a distinguished roadQuadcab666 is on a distinguished road
Default

Thanks for posting this.
__________________
'03 XL1200 Custom
K&N Filter
Rejetted 45/175
Cycle Shack Slip-ons
Reply With Quote
  #8  
Old 27th August 2007
donniej's Avatar
donniej donniej is offline
Flat Track Champion
 
Join Date: Jun 2007
Location: Philadelphia, PA
Posts: 648
Sportster/Buell Model: 883R
Sportster/Buell Year: 2007
Other Motorcycle Model: Suzuki SV650S
Other Motorcycle Year: 2003
Reputation: 1557
donniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura aboutdonniej has a spectacular aura about
Default

I have a 1964 XLH. It's pretty stock but has pretty free flowing exhaust (not drag pipes), K&N filter and a CV carb with big jets.... whatever the stock size is for a big twin. I don't know why I needed such big jets but that's where it runs right.

With spirited riding, I get 40MPG. I have gotten ~50MPG.
Reply With Quote
  #9  
Old 27th August 2007
JohnC88's Avatar
JohnC88 JohnC88 is offline
Harley Engineer
 
Join Date: Apr 2006
Location: Anaheim, CA
Posts: 326
Other Motorcycle Model: FLHR
Other Motorcycle Year: 07
Reputation: 258
JohnC88 is on a distinguished roadJohnC88 is on a distinguished roadJohnC88 is on a distinguished road
Default

Bert, I just saw this. I've got a spreadsheet that does the same thing. You'll be hearing from my lawyer shortly!

Also noticed a formula error in column E. 1st numerator has a typo.
__________________
John
Reply With Quote
Sponsored Links
  #10  
Old 29th February 2008
Fat Tony's Avatar
Fat Tony Fat Tony is offline
Drag Race Champion
 
Join Date: Aug 2007
Posts: 386
Sportster/Buell Model: 1200C
Sportster/Buell Year: 2008
Reputation: 120998
Fat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud ofFat Tony has much to be proud of
Default

Openoffice keeps opening this as a protected read-only document, how do you open it to be editable?
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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

Forum Jump



Sponsored Links
All times are GMT +1. The time now is 14:29.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2018, vBulletin Solutions Inc.
XL Forum® - Linson Media LLC