Search the Community
Showing results for tags 'excel'.
-
Attached is a Microsoft Excel 2003 spreadsheet that can be used as an aid in selecting replacement valve shims. This should work for 1983 through 2009 models, I did not see any variances in the sizing charts in the service manuals. 1st sheet in file is in Metric format. 2nd sheet in file is in Inch format. I expanded upon the valve clearance charts that are in the service manuals to include the shims that end in 2 and 8. The reason for this is that these shims can be reused in the bike if available. I don't believe you can readily buy the --2 and --8 sizes. Screen shot below shows cylinder 2 area. The only cells that are selectable are the "Shim in Now" & "Measured Clearance" data fields. The "Shim in Now" field will only accept valid shim sizes. There is a pull down menu for valid sizes or size can be keyed in. The only other value that is accepted as input is a zero. I included this to set chart to neutral setting. The "Measured Clearance" field has no error checking built in. Use millimeters on Metric sheet or inches on Inch sheet. The decimal point needs to be entered, the "mm" or "in" does not need to be entered. Below the "Measured Clearance" field is a calculated field for "Shim Needed". This field will display the correct shim size to set valve clearance to the high end of acceptable range. Next is "Expected Clearance" field. This is a calculated field to show what valve clearance should be with the shim size shown in "Shim Needed" field. Next is "2nd Choice Shim" field. This field will display the next larger size shim that will work. This shim may be selected due to "Shim Needed" is an odd size or not available. This shim willset valve clearance to the low end of acceptable range. Next is another "Expected Clearance" field. This is a calculated field to show what valve clearance should be with the shim size shown in "2nd Choice Shim" field. In the upper left hand example, the lower "Expected Clearance" field is highlighted in Red. This will happen when any of the calculated sizes fall outside of acceptable range. If value cannot be calculated, the "Shim Needed" field will be blank and error will display in "Second Choice Shim" field. This will happen if an out of range clearance value is entered. The two right hand charts in screen shot do not have data entered in so there are errors shown. This should print out on 8 1/2" x 11" paper very readable. This is just an aid for shim selection. Verify Clearances if you use this after shims are installed. Gary http://i1007.photobucket.com/albums/af193/gdingy101/valvechartclip1.jpg 39118.xls 39118.xls 39120.xls
-
Attached are the latest versions of our VRAssistance List. The purpose of this list is to give you a list of members who have signed up to offer assistance should you have problems while on the road or just wish to contact a member to say hello. There are two files attached. The XLS file is good if you wish to keep one on your computer as it can be sorted by username, state, country, etc. This is a Microsoft Excel format so if you do not have Microsoft Excel or another program that will open Excel files, it will not work for you. The other list is in .pdf format. It is sorted by state/province and is probably the best choice if you want a list that you can print out and take with you. If you are not on the list and wish to be, please go to your UserCP and "Edit Your Details". Scroll down on that page and you will see the section to add your information. Note that there is a new column now. The first column is the membership status of the people on the list. S = Supporting Member, E = Expired Member, R = Registered Member. A registered member is likely somebody in their trial period that just hasn't become a supporting member yet. These files were updated on September 19th, 2011.
-
Just in case you missed the post to the original thread, the VRAssistance list has been updated. The first column has been added to specify if the person is a supporting member, expired member, etc. It can be downloaded in .pdf or Excel format from the "sticky thread" at the top of the watering hole.
-
Don - A nice feature might be the ability to export the members list into Excel. That way a member could easily find all members in their area for M&E or group ride. Just a thought!