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

Notices

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

Active Threads
0 Thinking of a fall SE Ohio ride
Last Post: kkbii
Posted On: 5 Minutes Ago
Replies: 51
Views: 2,874
0 Adding electric start...was there one on here before?
Last Post: sportsterdoc
Posted On: 8 Minutes Ago
Replies: 1
Views: 15
0 TC88A makes me smile until WOT
Last Post: harley506d
Posted On: 24 Minutes Ago
Replies: 14
Views: 638
0 Food porn
Last Post: Graywolf
Posted On: 1 Hour Ago
Replies: 885
Views: 119,150
0 A Day in the Life...
Last Post: SLW210
Posted On: 1 Hour Ago
Replies: 590
Views: 56,237
0 Rumble strips
Last Post: r4fthrs
Posted On: 1 Hour Ago
Replies: 12
Views: 411
0 Dealer says, "Sportsters are just a Phase"
Last Post: r4fthrs
Posted On: 1 Hour Ago
Replies: 429
Views: 29,934
0 My take on the world ~ Photo by Trace
Last Post: r4fthrs
Posted On: 2 Hours Ago
Replies: 866
Views: 96,234
0 Official XL Forum Random Image Thread (NO NUDITY!)
Last Post: Stairman
Posted On: 2 Hours Ago
Replies: 41,821
Views: 6,448,367
0 Good 2 into 2 exhaust?
Last Post: mikeLI_77
Posted On: 2 Hours Ago
Replies: 2
Views: 71
0 Why I am leaving the forum!
Last Post: BWP 5p
Posted On: 2 Hours Ago
Replies: 96
Views: 16,228
0 Let's study the 77-85 oil pump, parts, and changes and when.
Last Post: DirtyCory
Posted On: 3 Hours Ago
Replies: 86
Views: 6,127
0 Hottie of the day, no nudity.
Last Post: Stairman
Posted On: 3 Hours Ago
Replies: 8,381
Views: 672,546
14 Firearms you wish you owned.
Last Post: Stairman
Posted On: 3 Hours Ago
Replies: 515
Views: 81,585
0 Roads I'd like to ride.
Last Post: Stairman
Posted On: 3 Hours Ago
Replies: 568
Views: 30,645
0 Shotgun Porn
Last Post: Stairman
Posted On: 3 Hours Ago
Replies: 841
Views: 119,169
0 Rubbermount Poll
Last Post: lkvisser
Posted On: 3 Hours Ago
Replies: 248
Views: 76,866
0 09 Buell XB12 crank
Last Post: Boudwood
Posted On: 3 Hours Ago
Replies: 3
Views: 103
0 Another ironhead roadracer
Last Post: Scott
Posted On: 4 Hours Ago
Replies: 25
Views: 1,027
0 Crusty's Travels
Last Post: SonWon
Posted On: 4 Hours Ago
Replies: 1,648
Views: 171,591
0 1986 1100 butterfly carb on going problems
Last Post: rokytnji
Posted On: 4 Hours Ago
Replies: 1
Views: 58
0 one sporty and $5000... What would you do?
Last Post: BKB
Posted On: 4 Hours Ago
Replies: 277
Views: 130,533
0 03 xlh 88"
Last Post: conv90
Posted On: 4 Hours Ago
Replies: 14
Views: 271
0 What did you do for your sporty Today?
Last Post: Sportycus
Posted On: 4 Hours Ago
Replies: 5,458
Views: 624,229
0 Does Synthetic Engine Oil cause Higher or Lower temps at the oil tank?
Last Post: Sportycus
Posted On: 5 Hours Ago
Replies: 91
Views: 16,843
0 Air cleaner backing plate screw size?
Last Post: Backmarker
Posted On: 8 Hours Ago
Replies: 4
Views: 89
5 Favourite grips?
Last Post: Glamazon
Posted On: 8 Hours Ago
Replies: 51
Views: 9,144
0 What Sort Of Sporty Have You Got?
Last Post: hammer6315
Posted On: 11 Hours Ago
Replies: 1,048
Views: 274,486
12 Lets see the "C's" XLC's that is. Pics Please!
Last Post: rocketmangb
Posted On: 12 Hours Ago
Replies: 1,182
Views: 421,431
0 What riding gear do you have/wear in good and/or poor weather?
Last Post: TheDinglepuss
Posted On: 13 Hours Ago
Replies: 104
Views: 32,452
More...
Members Birthdays
irvingjr (70), 909XR (61), Ghost_FL (59), mark R (58), TWISTED (45), spade (43), Drivethis29 (38), dodgetrucken (33)
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,253
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 10: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,253
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: 387
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 17:47.


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