Camhead Valve Shim Spreadsheet

PhotoBiker · 03-21-2011, 07:18 PM

I did my 600 Mile Service this weekend and noticed that three of my intakes were too tight. So after figuring out the needed shims, I created a spreadsheet ;-)

I created it originally on Office 2007 for a PC and tweaked it on Office 2011 for Mac, either version will work with the file though.

I even copied the shim parts listing off the web and added a lookup sheet. All you have to do is enter the gap and then the actual shim size (if necessary), the spreadsheet will do the rest of the work.

I think I have uploaded the spreadsheet to:
Try this Link. << Should work now!

If that doesn't work, just ping me and I can send it to you via email (or I can try to figure out the comcast website management).

Curent version is v.10 (Can see in Properties).

MikeinSA · 03-21-2011, 07:50 PM

Awesome. Thanks for doing that, but the link isn't working. I'll PM you (before everyone else does

), could you email me a copy?

PhotoBiker · 03-21-2011, 08:16 PM

OK, got the linky working now.

Refplusten · 03-22-2011, 02:14 AM

Nice! Thanks.

Scottly · 03-22-2011, 06:04 AM

All I get is a menu for different HTML files when i click on it.

JimVonBaden · 03-22-2011, 06:34 AM

Great idea! PM sent.

Jim

DcnCan · 03-22-2011, 08:29 AM

Thanks!!

PhotoBiker · 03-26-2011, 02:56 PM

OK, first test completed. I installed the three new shims today that were called for by the spreadsheet and now everything is within spec.

FYI: The spreadsheet is set up as a "one time shot". It doesn't retain history. If you are anal about these things (like me) I suggest copying the specs before you update them and store them in your maintenance logs (I have another spreadsheet for maintenance). Then store a copy of the updated specs in your log as well. This way here you will have a running record of what has been done on your bike with some pretty decent details. Be sure to copy values only and not the underlying formulas.

PhotoBiker · 03-26-2011, 03:25 PM

The results. . .

[IMG]

[/IMG]

MaineRunner · 03-29-2011, 08:58 AM

PhotoBiker,

I recently bought a '11 R1200GSA and found your post interesting. From what I understand a valve check is not part of the 600 mile check. I assume you did it for peace of mind? But apparently it's a good thing you checked with the tight valves.

I wasn't going to bother to check mine until at least the 5000 mile mark based on other posts...but maybe it's a good thing the check sooner.

decka · 02-04-2012, 08:10 AM

Thanks, PhotoBiker! Just about to do the 6K service on my cam head (I think there's a 6k service right?

) This will be really helpful. This will be the first time I've looked at valves on a cam head with the semi-spheres. I've done an R75/6 and a hex-head, but this will be new. I took a peek at JVB's tutorial video as well. But your spreadsheet is awesome. I *hate* having to do little bits of math in the middle of something I'm trying not to f&$k up.

monkeydad · 02-04-2012, 09:58 AM

Thanks dood

chrome bandit · 02-04-2012, 10:31 AM

...I copied the spreadsheet to Skydrive and embedding the spreadsheet here so folks can play with it directly on the web. If you have Office 2007 or 2010, see the little Excel icon in the lower right hand corner to download it to your PC or Mac. The embedded viewer doesn't show the other sheet with the look up table in it, so you'll have to download the spreadsheet to check that out.

Thanks PhotoBiker!

PhotoBiker · 02-04-2012, 03:09 PM

Quote:

Originally Posted by chrome bandit

...I copied the spreadsheet to Skydrive and embedding the spreadsheet here so folks can play with it directly on the web. If you have Office 2007 or 2010, see the little Excel icon in the lower right hand corner to download it to your PC or Mac. The embedded viewer doesn't show the other sheet with the look up table in it, so you'll have to download the spreadsheet to check that out.

Thanks PhotoBiker!

Oh, this is cool, I never realized you could embed a spreadsheet. . .

PhotoBiker · 02-04-2012, 03:11 PM

Quote:

Originally Posted by MaineRunner

From what I understand a valve check is not part of the 600 mile check. I assume you did it for peace of mind? But apparently it's a good thing you checked with the tight valves.

.

I realized it after I started the 600 mile service, I did my planning from an older inspection checklist, once I fired up RepRom, I realized it wasn't needed but by that point I'd already created the spreadsheet and wanted to go ahead anyway.

03-21-2011, 07:18 PM	#1
PhotoBiker ^OP Please insert title here Joined: Sep 2008 Location: Southern Maine Oddometer: 1,435	Camhead Valve Shim Spreadsheet I did my 600 Mile Service this weekend and noticed that three of my intakes were too tight. So after figuring out the needed shims, I created a spreadsheet ;-) I created it originally on Office 2007 for a PC and tweaked it on Office 2011 for Mac, either version will work with the file though. I even copied the shim parts listing off the web and added a lookup sheet. All you have to do is enter the gap and then the actual shim size (if necessary), the spreadsheet will do the rest of the work. I think I have uploaded the spreadsheet to: Try this Link. << Should work now! If that doesn't work, just ping me and I can send it to you via email (or I can try to figure out the comcast website management). Curent version is v.10 (Can see in Properties). __________________ -=Glen=- [Current] '10 R1200GS '06 Ninja 250 Check out my Gallery PhotoBiker screwed with this post 03-21-2011 at 08:15 PM

03-21-2011, 08:16 PM	#3
PhotoBiker ^OP Please insert title here Joined: Sep 2008 Location: Southern Maine Oddometer: 1,435	OK, got the linky working now. __________________ -=Glen=- [Current] '10 R1200GS '06 Ninja 250 Check out my Gallery

03-22-2011, 02:14 AM	#4
Refplusten Relaxed... Joined: Jul 2009 Location: Vancouver Island, BC Oddometer: 196	Nice! Thanks. __________________ "Terrorism is the best political weapon for nothing drives people harder than a fear of sudden death." - Adolf Hitler (1889-1945)

03-22-2011, 06:34 AM	#6
JimVonBaden "Cool" Aid! Joined: Feb 2005 Location: Alexandria, VA Oddometer: 41,483	Great idea! PM sent. Jim __________________ Click here for BMW Maintenance and Repair DVDs and Corrections. "Combo-Order Discounts!"

03-26-2011, 02:56 PM	#8
PhotoBiker ^OP Please insert title here Joined: Sep 2008 Location: Southern Maine Oddometer: 1,435	OK, first test completed. I installed the three new shims today that were called for by the spreadsheet and now everything is within spec. FYI: The spreadsheet is set up as a "one time shot". It doesn't retain history. If you are anal about these things (like me) I suggest copying the specs before you update them and store them in your maintenance logs (I have another spreadsheet for maintenance). Then store a copy of the updated specs in your log as well. This way here you will have a running record of what has been done on your bike with some pretty decent details. Be sure to copy values only and not the underlying formulas. __________________ -=Glen=- [Current] '10 R1200GS '06 Ninja 250 Check out my Gallery

03-21-2011, 07:50 PM	#2
MikeinSA Flo's Ho Joined: May 2009 Location: San Antonio, TX Oddometer: 3,023	Awesome. Thanks for doing that, but the link isn't working. I'll PM you (before everyone else does ), could you email me a copy?

03-22-2011, 06:04 AM	#5
Scottly Gnarly Adventurer Joined: Dec 2010 Location: Florida Oddometer: 128	All I get is a menu for different HTML files when i click on it.

03-22-2011, 08:29 AM	#7
DcnCan Adventurer Joined: Oct 2010 Location: East TN Oddometer: 28	Thanks!!

03-26-2011, 03:25 PM	#9
PhotoBiker ^OP Please insert title here Joined: Sep 2008 Location: Southern Maine Oddometer: 1,435	The results. . . [IMG][/IMG] __________________ -=Glen=- [Current] '10 R1200GS '06 Ninja 250 Check out my Gallery

03-29-2011, 08:58 AM	#10
MaineRunner Adventurer Joined: Oct 2010 Location: Downeast, Maine Oddometer: 79	PhotoBiker, I recently bought a '11 R1200GSA and found your post interesting. From what I understand a valve check is not part of the 600 mile check. I assume you did it for peace of mind? But apparently it's a good thing you checked with the tight valves. I wasn't going to bother to check mine until at least the 5000 mile mark based on other posts...but maybe it's a good thing the check sooner.

02-04-2012, 08:10 AM	#11
decka Adventurer Joined: Oct 2009 Location: San Francisco, California Oddometer: 70	Thanks, PhotoBiker! Just about to do the 6K service on my cam head (I think there's a 6k service right? ) This will be really helpful. This will be the first time I've looked at valves on a cam head with the semi-spheres. I've done an R75/6 and a hex-head, but this will be new. I took a peek at JVB's tutorial video as well. But your spreadsheet is awesome. I hate having to do little bits of math in the middle of something I'm trying not to f&$k up.

02-04-2012, 09:58 AM	#12
monkeydad Gnarly Adventurer Joined: Jan 2012 Location: Melanoma Valley, Arizona Oddometer: 192	Thanks! Thanks dood

02-04-2012, 10:31 AM	#13
chrome bandit Wide footed adventurer Joined: Oct 2009 Location: Seattle-ish Oddometer: 254	As a public service... ...I copied the spreadsheet to Skydrive and embedding the spreadsheet here so folks can play with it directly on the web. If you have Office 2007 or 2010, see the little Excel icon in the lower right hand corner to download it to your PC or Mac. The embedded viewer doesn't show the other sheet with the look up table in it, so you'll have to download the spreadsheet to check that out. Thanks PhotoBiker! __________________ Seattle-Deadhorse-Homer-Inside Passage 2011 Hells Canyon 2012 WABDR 2012 How to embed Excel/PPT/Word docs in ADV Blog: http://terra.incognita.ws

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: .
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode