Post Reply 
 
Thread Rating:
  • 3 Votes - 3.67 Average
  • 1
  • 2
  • 3
  • 4
  • 5
CB1100 forum miles
Author Message
Django Offline
Road Warrior

Germany
Posts: 1,571
Joined: Oct 2014
Post: #1
Information CB1100 forum miles
I extended the miles spreadsheet, to allow collection of monthly miles per bike and member.

Please have a look at: https://docs.google.com/spreadsheets/d/1...sp=sharing

Feel free to enter a line per bike of yours and fill in monthly miles.

If you're metric, you may want to enter your kilometers divided by mile, e.g. 580 km as: =580/1.609344 (which is 360 miles).

To keep the table simple, I reduced it to miles, as this forum is located in the USA. (Don't know, why they still have these weird units.)

Don't change colored fields, they are calculated.

Currently there are only 2 month columns: Feb and Jan. I will insert new monthly columns as year goes by. The idea is, to keep the new month at the left side, so we don't have to scroll too much to enter current data.

Please change your `Last Change' field to reflect, when you entered miles the last time.

Hope you like it. Please discuss here, if you've ideas to improve the table.

Enjoy. Beer

73 Django -- [url=http://www.ironbutt.com]IBA[/url] #59882 -- [url=https://djangotours.wordpress.com]Django Tours[/url] -- [url=http://1asw.de/~rsz/bilder/ES-I64/15-34-0832.jpg]Django on CB1100[/url]
This message was signaled with a flashlight into the end of a fiber.
(This post was last modified: 03-15-2017 08:46 AM by The ferret.)
02-02-2016 07:50 AM
Visit this user's website Find all posts by this user Quote this message in a reply
The ferret Offline
Forum Moderator

Ohio
Posts: 31,277
Joined: Apr 2013
Post: #2
RE: cb1100 forum miles 2016
cool..I plugged in my numbers for January, plugged in yesterdays (Feb 1) and it automatically added them for that bike...and added them to miles by user on left side. Missed the last change field first time around.

Good job Django :thumbsup

.
Defender of the Realm
2014 DLX (the pleasure horse)
2021 NC750X DCT (Angry Bird)
(This post was last modified: 02-02-2016 08:00 AM by The ferret.)
02-02-2016 07:55 AM
Find all posts by this user Quote this message in a reply
Bokobob Offline
1st Service Completed

Gastonia, NC
Posts: 108
Joined: Feb 2015
Post: #3
RE: cb1100 forum miles 2016
ok, struggled a bit but got 'r done. Nice work on the spreadsheet, Django. Thank you. I have three other bikes but won't be logging them for now...Maybe next year...Lots of "bookwork." Thanks

Grace + Peace................Bob
2014 CB1100 Standard - Sold...........
1994 Honda Magna VF750C V4 power cruiser
1995 BMW K75 standard
2009 Kawasaki Vulcan 500
I am a 1936 model
(This post was last modified: 02-02-2016 12:37 PM by Bokobob.)
02-02-2016 12:36 PM
Find all posts by this user Quote this message in a reply
Cormanus Offline
Moderator

Queensland, Australia
Posts: 20,659
Joined: Dec 2013
Post: #4
RE: cb1100 forum miles 2016
Oh, well, that's me out of the spreadsheet design business. Excellent work Django although forgive me I added a line. Simplicity nails complexity every day and we now know that MTC has ridden a complete circuit of his garage in the Chicago winter.

Thumbs Up Thanks

Miles or Kms, Fruno?
(This post was last modified: 02-02-2016 01:38 PM by Cormanus.)
02-02-2016 01:28 PM
Find all posts by this user Quote this message in a reply
EmptySea Offline
Lives On Two Wheels

Chicagoland, USA
Posts: 7,004
Joined: Jun 2013
Post: #5
RE: cb1100 forum miles 2016
The only way to improve the table is if you could arrange for it to teleport me and my bike to a warmer locale so that I can get some more miles.

MTC

"If you can’t go home again, at least you can enjoy the ride” — Peter Egan


2013 CB1100 non-abs
2013 CB1100 abs
02-02-2016 02:02 PM
Find all posts by this user Quote this message in a reply
Cormanus Offline
Moderator

Queensland, Australia
Posts: 20,659
Joined: Dec 2013
Post: #6
RE: cb1100 forum miles 2016
MTC

Open the spreadsheet.

1. Blink. Slowly.

2. Did that work?

3. No?

4. Go to 1.
02-02-2016 02:48 PM
Find all posts by this user Quote this message in a reply
fruno Offline
Break-In Period

Berlin, Germany
Posts: 35
Joined: Sep 2015
Post: #7
cb1100 forum miles 2016
Miles, rounded (240 km....only...well, for a january that's more than I expected)


Gesendet von iPhone mit Tapatalk
02-03-2016 12:18 AM
Find all posts by this user Quote this message in a reply
Riko Offline
High Mileage

Belgium
Posts: 1,024
Joined: Dec 2013
Post: #8
RE: cb1100 forum miles 2016
cuss, I only know the total from December till January, but I have no idea from December only and January only...
02-03-2016 07:20 AM
Find all posts by this user Quote this message in a reply
nvbobr Offline
1st Service Completed

Las Vegas NV
Posts: 77
Joined: Nov 2015
Post: #9
RE: cb1100 forum miles 2016
1511 January miles + 1534 December miles = 3045 since I purchased the bike on Dec. 2. I still love the CB.

My excuse for excessive motorcycle riding this winter, as I explain it to family members, is to improve my photography skills in Death Valley National Park, roughly once or twice a week.

Turning over 3,000 miles on the road

İmage

-- Bob

2012 Goldwing (blue)
2014 CB1100 Standard
IBA# 60507
02-03-2016 10:02 AM
Find all posts by this user Quote this message in a reply
EmptySea Offline
Lives On Two Wheels

Chicagoland, USA
Posts: 7,004
Joined: Jun 2013
Post: #10
RE: cb1100 forum miles 2016
(02-03-2016 07:20 AM)Riko Wrote:  cuss, I only know the total from December till January, but I have no idea from December only and January only...

So, take your best guess. Smile

MTC

"If you can’t go home again, at least you can enjoy the ride” — Peter Egan


2013 CB1100 non-abs
2013 CB1100 abs
02-03-2016 10:06 AM
Find all posts by this user Quote this message in a reply
Post Reply 


[-]
Forum Friends
Premium Exhausts & Unique Parts from Japan

[-]
Recent Posts
CB1100 Monthly Photo Challenge
That's cool, Tev! Somehow, when my p . . .peterbaron — 05:38 AM
CB1100 Monthly Photo Challenge
That's cool, Tev! Somehow, when my pho . . .Tev62 — 03:36 AM
Tire Options for our CB1100
You might like to play with the front pr . . .Tev62 — 03:09 AM
Todays weather
Partly sunny, cool, windy and 48 miles . . .GoldOxide — 07:46 PM
What did you do to/with your other bike?
... That looks like it was comforting, . . .pdedse — 05:17 PM
Todays weather
That’s the spirit, peterbaron! Keep th . . .Cormanus — 03:34 PM
What did you do to/with your other bike?
What a fun trip! Didn't know they made a . . .Gone in 60 — 03:16 PM
Todays weather
Partly sunny, cool, windy and 48 miles o . . .peterbaron — 03:12 PM

[-]
Statistics
» Members: 6,517
» Latest member: keedonald
» Forum threads: 15,975
» Forum posts: 329,753

Full Statistics

>
Forum Jump: