Valve Adjust spreadsheet (Found on net but awesome)

[mcgyver74]

Was surfing around and came across this VERY detailed spreadsheet for mapping the valves on a C-14.  Has a tab that lists all the shim sizes and a tab for MM and a tab for INches

I cannot take credit for this as it was created by Kory on the ZZR forums....

 

[mcgyver74]

Dunno why it uploaded twice but you only need one of the files (They are exactly the same)

 

[Fred H.]

Thanks, that's a nice spreadsheet. I built a similar looking file a while back, but it wasn't done in excel. I like this new one better.

Here is my old shim map. It looks like they patterned it after it, but improved it and reversed the cylinder layout. I did mine a bit odd as I worked from the front of the bike cause I was filming it, and I wanted the map to match the way it looked from my perspective so I didn't get corn-fused.

 

[mcgyver74]

Yeah, Kory seems to have jazzed it up a bit (It will calculate the new size based on your original and new shim etc..) plus It has the handy shim size to shim number table.....  The more and more I review this, the more and more I think I will tackle this job myself when it's time (and save a grand)

 

[mcgyver74]

Ok, one of the fine folks on the "Forum who shall not be named" LOL  has jazzed this up even further.

With this version, all you need to do is enter the measuered clearance, and then select what the existing shim is from a drop down list and it calculates the rest for you...


Perhaps we could get this sticky-ed!!

 

[Fred H.]

I just loaded it and it works like a champ, thanks.

 

[FLY-DOG]

Thanks to Kory for the spreadsheet and thanks to Marc for sharing!!

 

[kawimick]

With this version, all you need to do is enter the measuered clearance, and then select what the existing shim is from a drop down list and it calculates the rest for you...
Perhaps we could get this sticky-ed!!

Marc,
  Can you instruct a total noob how to (enter the measured clearance), as you
describe above?  The spreadsheet opens OK but I never see any dropdowns.

Thanks,
Mick

 

[Fred H.]

With this version, all you need to do is enter the measuered clearance, and then select what the existing shim is from a drop down list and it calculates the rest for you...
Perhaps we could get this sticky-ed!!

Marc,
  Can you instruct a total noob how to (enter the measured clearance), as you
describe above?  The spreadsheet opens OK but I never see any dropdowns.

Thanks,
Mick

Click in the Clearance Box, and type in your clearance measurement. Then click on the number for the existing shim (the shim number to the left, not the box with the actual shim dimensions). The red shim number box should present you with a drop down size selection arrow to the right of the number. For example, on the Number One Exaust valve in the spreadsheet, click on the red 48 for the existing shim size, and you should get a drop downarrow next to it. Click on the arrow and the drop down selection will expand and let you select the size you want.

The only down side to this automatic calculation method is that it assumes all the shim are sized perfectly. If you have a shim that is off size a bit, you have to go to the formula bar and erase the formula in it and manually enter the actual measured size in it.

 

[kawimick]

[

Click in the Clearance Box, and type in your clearance measurement. Then click on the number for the existing shim (the shim number to the left, not the box with the actual shim dimensions). The red shim number box should present you with a drop down size selection arrow to the right of the number. For example, on the Number One Exaust valve in the spreadsheet, click on the red 48 for the existing shim size, and you should get a drop downarrow next to it. Click on the arrow and the drop down selection will expand and let you select the size you want.

The only down side to this automatic calculation method is that it assumes all the shim are sized perfectly. If you have a shim that is off size a bit, you have to go to the formula bar and erase the formula in it and manually enter the actual measured size in it.

Fred,
  Thanks for trying but when I click on the clearance box it just puts a bold
border around the word clearance.  If I enter a measurement (0.009) in
that box it just changes the word clearance to 0.009  ?????  I must be doing
something wrong because I never get the popup with shim sizes.  Oh well.

It took me 20 minutes to get the cylinders (1,2,3,4 circles) lined back up where
it references the valves correctly.

 

[Fred H.]

Fred,
  Thanks for trying but when I click on the clearance box it just puts a bold
border around the word clearance.  If I enter a measurement (0.009) in
that box it just changes the word clearance to 0.009  ?????  I must be doing
something wrong because I never get the popup with shim sizes.  Oh well.

It took me 20 minutes to get the cylinders (1,2,3,4 circles) lined back up where
it references the valves correctly.

Click on the Red # 48 in the upper left side of the spreadsheet for Cylinder # 1.

 

[Fred H.]

Oh, and by the way, make sure you downloaded the newest (updated) version that Marc loaded a few posts above this one. The first version he posted doesn't have the automatic calculation feature. I'm reattaching it to this post.

 

[kawimick]

Click on the Red # 48 in the upper left side of the spreadsheet for Cylinder # 1.

Thanks,
  Once I downloaded some format conversion file from Excel, it worked perfectly.  I guess
my Excel XP was too old for this fancy program. 

  I clicked on the shim number to the Right of the shim measurement and I saw the shim
numbers pop-up, next I changed the actual measurement from 0.007 to 0.009 and hit Enter.
The recommended shim changed from 43 to 48.  Success.  Hope this helps anyone else that has never entered XLSX data. 

Mick

 

[Fred H.]

In case someone else has the older Excel version, I converted it to the Excel 2003 format and have attached it to this post.

 

[kawimick]

Perfect Fred,
  Thanks!  I just installed OpenOffice and they both seem to work great.


Mick

 

[anthony2008]

what are the specs intake and exhaust shims

 

[mcgyver74]

what are the specs intake and exhaust shims

?????

 

[kawimick]

what are the specs intake and exhaust shims

The only 'spec' on the shims is that they are 9.5mm diameter shims.  Some suppliers
call them 9.48mm shims too.  Is that what you are asking?

Mick

 

[Fred H.]

They actually measure 9.48mm in diameter.