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
0 Help to ID 1974 Sportster XLCH custom parts
Last Post: Glamazon
Posted On: 47 Minutes Ago
Replies: 5
Views: 89
0 Full face, Half or skull cap?
Last Post: Glamazon
Posted On: 52 Minutes Ago
Replies: 495
Views: 88,081
0 Service interval on all rubber brake components
Last Post: harley506d
Posted On: 2 Hours Ago
Replies: 1
Views: 29
10 New rider - XL1200S in Aus.
Last Post: jkinkade
Posted On: 4 Hours Ago
Replies: 85
Views: 6,803
0 Hard to shift
Last Post: rog
Posted On: 5 Hours Ago
Replies: 0
Views: 36
0 Original sealant from HD for case halves
Last Post: 11B40
Posted On: 5 Hours Ago
Replies: 27
Views: 807
0 The Armor Jacket Poll
Last Post: Nibelungen
Posted On: 5 Hours Ago
Replies: 166
Views: 43,148
0 What's your helmet?
Last Post: Nayra
Posted On: 5 Hours Ago
Replies: 84
Views: 8,031
0 How many helmets?
Last Post: Bama Lee XLC
Posted On: 6 Hours Ago
Replies: 207
Views: 36,883
0 What kind of saddle do you use on your sporty?
Last Post: Nayra
Posted On: 6 Hours Ago
Replies: 270
Views: 71,092
0 91-99 Lifter Pin Upgrade to 00-05 Lifter Pin Screws
Last Post: Hippysmack
Posted On: 7 Hours Ago
Replies: 12
Views: 228
0 Show your favorite pic of your bike. just one
Last Post: Lone Rider
Posted On: 7 Hours Ago
Replies: 4,700
Views: 1,778,752
0 Hottie of the day, no nudity.
Last Post: Stairman
Posted On: 7 Hours Ago
Replies: 9,973
Views: 877,278
0 Sportster Street Tracker GSXR Fork Swap!
Last Post: Greg_Wayne
Posted On: 8 Hours Ago
Replies: 16
Views: 3,019
0 Hot Rods, Rat Rods, and Customs.
Last Post: wedge
Posted On: 8 Hours Ago
Replies: 3,027
Views: 331,509
0 Tranny Question
Last Post: sltm1
Posted On: 8 Hours Ago
Replies: 8
Views: 117
0 Who's still riding???
Last Post: SHAKY DAVE
Posted On: 8 Hours Ago
Replies: 178
Views: 25,131
0 Is this 1200R worth $4500?
Last Post: 60Gunner
Posted On: 8 Hours Ago
Replies: 43
Views: 5,708
0 WTB: Factory Ironhead 2-1 Head Pipes
Last Post: wrkdWS6
Posted On: 9 Hours Ago
Replies: 3
Views: 4,870
0 How many miles do you have on your rubbermount?
Last Post: 60Gunner
Posted On: 9 Hours Ago
Replies: 410
Views: 79,848
4 1977 ironhead frame modification help
Last Post: ryder rick
Posted On: 9 Hours Ago
Replies: 5
Views: 158
0 Official XL Forum Random Image Thread (NO NUDITY!)
Last Post: Stairman
Posted On: 9 Hours Ago
Replies: 42,849
Views: 6,701,196
0 Andrews flowmaster carb on ebay
Last Post: brucstoudt
Posted On: 10 Hours Ago
Replies: 16
Views: 453
0 Motorcycle Events
Last Post: rhartlin
Posted On: 11 Hours Ago
Replies: 11
Views: 3,190
0 magnetos 101 questions
Last Post: brucstoudt
Posted On: 11 Hours Ago
Replies: 24
Views: 3,648
0 Are the 04s the red headed step child?
Last Post: 60Gunner
Posted On: 11 Hours Ago
Replies: 66
Views: 4,348
0 What did you do for your sporty Today?
Last Post: ChinCactus
Posted On: 11 Hours Ago
Replies: 5,680
Views: 694,346
0 New member from Santa Clarita, CA
Last Post: ChinCactus
Posted On: 11 Hours Ago
Replies: 11
Views: 389
0 ParrotHead's 2019 Winter/Spring maintenance
Last Post: ChinCactus
Posted On: 11 Hours Ago
Replies: 25
Views: 9,470
0 Bratstyle Japanese Influence Bike Photos
Last Post: harley506d
Posted On: 12 Hours Ago
Replies: 286
Views: 356,078
More...
Members Birthdays
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,256
Sportster/Buell Model: 883>1250 Stage 2
Sportster/Buell Year: 2002
Other Motorcycle Model: Road Glide
Other Motorcycle Year: 2011
Reputation: 538953
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, 423 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,256
Sportster/Buell Model: 883>1250 Stage 2
Sportster/Buell Year: 2002
Other Motorcycle Model: Road Glide
Other Motorcycle Year: 2011
Reputation: 538953
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 10:26.


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