Camhead Valve Shim Spreadsheet

Discussion in 'GS Boxers' started by PhotoBiker, Mar 21, 2011.

  1. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    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.

    <a href="http://www.flickr.com/photos/gsansoucie/5548998894/" title="Camhead Valve Shim Spreadsheet by DamnBeavers, on Flickr"><img src="http://farm6.static.flickr.com/5107/5548998894_da20d7b4bb.jpg" width="500" height="194" alt="Camhead Valve Shim Spreadsheet" /></a>

    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).
    #1
  2. MikeinSA

    MikeinSA Long timer

    Joined:
    May 12, 2009
    Oddometer:
    3,994
    Location:
    San Antonio, TX
    Awesome. Thanks for doing that, but the link isn't working. I'll PM you (before everyone else does :lol3), could you email me a copy?
    #2
  3. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    OK, got the linky working now.
    #3
  4. Refplusten

    Refplusten Relaxed...

    Joined:
    Jul 5, 2009
    Oddometer:
    199
    Location:
    Vancouver Island, BC
    Nice! Thanks.
    #4
  5. Scottly

    Scottly Been here awhile

    Joined:
    Dec 29, 2010
    Oddometer:
    128
    Location:
    Florida
    All I get is a menu for different HTML files when i click on it.
    #5
  6. JimVonBaden

    JimVonBaden "Cool" Aid!

    Joined:
    Feb 11, 2005
    Oddometer:
    55,199
    Location:
    Alexandria, VA
    Great idea! PM sent.

    Jim :brow
    #6
  7. DcnCan

    DcnCan Adventurer

    Joined:
    Oct 30, 2010
    Oddometer:
    33
    Location:
    East TN
    Thanks!!
    #7
  8. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    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.
    #8
  9. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    The results. . .

    [​IMG]
    #9
  10. MaineRunner

    MaineRunner Adventurer

    Joined:
    Oct 8, 2010
    Oddometer:
    93
    Location:
    Downeast, USA
    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. :eek1

    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.
    #10
  11. decka

    decka Adventurer

    Joined:
    Oct 28, 2009
    Oddometer:
    70
    Location:
    San Francisco, California
    Thanks, PhotoBiker! Just about to do the 6K service on my cam head (I think there's a 6k service right? :D) 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.
    #11
  12. monkeydad

    monkeydad Been here awhile

    Joined:
    Jan 15, 2012
    Oddometer:
    817
    Location:
    Melanoma Valley, Arizona
    Thanks dood:clap
    #12
  13. chrome bandit

    chrome bandit Wide footed adventurer

    Joined:
    Oct 3, 2009
    Oddometer:
    299
    Location:
    Seattle-ish
    ...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.

    <iframe width="700" height="220" frameborder="0" scrolling="no" src="https://r.office.microsoft.com/r/rlidExcelEmbed?su=68099805427695459&Fi=SDF1F06987CA7F63!1045&ak=t%3d0%26s%3d0%26v%3d!APwpZRqZFvxmGLU&kip=1&wdAllowInteractivity=False&AllowTyping=True&ActiveCell='Valve%20Shims'!D2&Item=Table1&wdHideGridlines=True&wdDownloadButton=True"></iframe>

    Thanks PhotoBiker!
    #13
  14. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    Oh, this is cool, I never realized you could embed a spreadsheet. . .
    #14
  15. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    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.
    #15
  16. erkmania

    erkmania Still Adventuring

    Joined:
    Mar 19, 2004
    Oddometer:
    996
    Location:
    San Diego, CA
    Excellent spread sheet. Thanks for sharing.:thumb

    As an aside, one has to admire BMW for selling milled ball bearings for more than $6 each. Not griping about it. My funny bone just felt the tug of irony.:norton
    #16
  17. chrome bandit

    chrome bandit Wide footed adventurer

    Joined:
    Oct 3, 2009
    Oddometer:
    299
    Location:
    Seattle-ish
    #17
  18. baloneyskin daddy

    baloneyskin daddy bikaholic

    Joined:
    Oct 21, 2009
    Oddometer:
    2,178
    Location:
    southcentral PA.
    I really find it hard to believe there were 3 tight valves at only 600 miles on any new motorcycle manufactured today. Were they actually tight or just at the low side of the tolerances?
    #18
  19. PhotoBiker

    PhotoBiker Please insert title here

    Joined:
    Sep 26, 2008
    Oddometer:
    1,442
    Location:
    Southern Maine
    And so did I. . .

    Well I was going to post a screen print of the spreadsheet for the 600 mile service, but I just realized that I didn't save the initial values[in the spreadsheet], only the final values that are all in spec. I get one of these "round tuits" I will have to put in some kind of audit trail to the spreadsheet. . .

    From my maintenance log, I have this:

    "Valve Check:
    Left Ex
    Top: .381 (In Spec)
    Bottom: .356 (In Spec)
    Left Int
    Top: .152 (In Spec)
    Bottom: .127 (In Spec - Tight)

    Right Ex
    Top: .381 (In Spec)
    Bottom: .356 (In Spec)
    Right Int:
    Top: .102 (Tight) Has 5450x Actual: 5.466mm (NEEDS: 5.416mm)
    Bottom: .102 (Tight) Has 5450X Actual: 5.445mm (NEEDS: 5.395mm)"

    So 2 of the 3 were out of spec (Right Int Top & Bottom) and one was In Spec, but at the low end (Left Int Bottom).

    While I have the logs up:

    6k Service
    Replaced two shims:
    Lt Ex Top: was .406 (5250X) replaced with 5300X now .356mm in spec
    Rt In Btm: was .240 marked xxx replaced with 5450 (should have been a 5400X) @ .130 (+) just in spec
    All Plugs OK
    Air Filter Good.
    TBS good (was out a bit).

    12k Service
    All Good. . .
    #19
  20. JimVonBaden

    JimVonBaden "Cool" Aid!

    Joined:
    Feb 11, 2005
    Oddometer:
    55,199
    Location:
    Alexandria, VA
    It is rare, but not unheard of.

    Jim :brow

    PS Great spreadsheet. Task should attach this to the FAQ!
    #20