Jaguar V12 valve adjustment shim calculator

Document Sample
Jaguar V12 valve adjustment shim calculator Powered By Docstoc
					                                                                                                     Jaguar V12 valve adjustment shim calculator                                                                     Printed on 6/28/2012 at 9:28 PM




 Instructions:
               Step 1 Before removing the cams, measure the Current Clearance for all valves. Enter these numbers into the appropriate white cells. Ex, .0105
               Step 2 Once the cams are removed, record the Current shim Letter for each valve in the corresponding white cell. Ex, Q or W or R+
               Step 3 Enter your Preferred Clearances for the Intake and the Exhaust in the white cells in the upper right.
                      If you have a personal inventory of loose shims on the shelf (from previous valve adjustments), enter these quantities in the Inventory sheet.
                      The tool will recommend new shims for each valve, and build a purchase list for those not in your inventory.
                      For specific help tips, hover your mouse over cells that have a red triangle in the upper right corner.                    Have fun, Greg Meboe
                                                            Cylinder                                                                             greg@meboe.com
                             1A                2A             3A                4A                5A               6A               Preferred Clearances
                          E       I        e        I       e       I        I       e        I         e       I        e           Intake        Exhaust
Current Clearance      .0120 .0100 .0110 .0100 .0110 .0090 .0090 .0105 .0095 .0110 .0090 .0110                                        .0120         .0145
Current Letter             R+        T+    S+        U+      U        W      V+        U+      U        T+      U        T+
New Letter                 P       R+       P       S+      Q+       T        S+     Q+        R+       Q       R       Q
Resulting Clearance      .0145   .0120    .0145   .0120    .0145   .0120    .0120   .0145    .0120    .0145   .0120   .0145


                                1B              2B               3B               4B               5B               6B
                           E         I      e        I       e        I       I        e       I        e       I        e                     Vehicle Information
Current Clearance        .0100   .0095    .0110   .0090    .0110   .0100    .0095   .0110    .0110    .0110   .0100   .0110           Vehicle:
Current Letter             Q+      T        T+      V        S+      V+       W       R+       T+       R+      T       R+            Engine#
New Letter                 M      Q+        Q       S        P       T+       T+      O        S+       O       R       O             Date
Resulting Clearance      .0145   .0120    .0145   .0120    .0145   .0120    .0120   .0145    .0120    .0145   .0120   .0145

The following 16 shims will need to be purchased to complete this job:     1M, 3O, 3P, 3Q, 2Q+, 2R, 1S, 1S+,
The following 16 shims will be left over after this job is completed:      2R+, 1T, 3T+, 3U, 2U+, 1V, 2V+, 2W,




Notes:
This worksheet may be locked for your own protection. If you are comfortable with Excel and want to make changes to the structure, the password is jaguar . Please let me know of any additions/suggestions you have at greg@meboe.com
This tool can be extended to include more + size shims. Simply add shim columns to the Inventory table. Be sure to copy formulae in hidden rows, and to extend named ranges as appropriate.
Conversely, if you want to delete certain + size shims from the calculator, simply delete the entire column on the Inventory table. Be sure to select the whole column including all hidden cells, else subsequent calculations will be in error.
The 'B' bank data entry area is simply a mirror of the real hidden 'B' columns that can be found to the right of the 'A' bank.




                                                                                                                                                                                                            Questions/Comments? E-mail to greg@meboe.com
(--)    A      B     C     D     E     F     G     H     I     J     K     L     M     N     O
       .0846 .0856 .0866 .0876 .0886 .0896 .0906 .0916 .0926 .0936 .0946 .0956 .0966 .0976 .0986
       .0850 .0860 .0870 .0880 .0890 .0900 .0910 .0920 .0930 .0940 .0950 .0960 .0970 .0980 .0990

       0      0     0     0     0     0     0     0     0     0     0     0     0     0     0

       0      0     0     0     0     0     0     0     0     0     0     0      0    0      0
       0      0     0     0     0     0     0     0     0     0     0     0      1    0      3
       0      0     0     0     0     0     0     0     0     0     0     0     -1    0     -3
                                                                                 1           3



                                                                               1M,         3O,




             Click on the "Main" tab below to get back to t
      P     Q    Q+     R    R+     S     S+    T     T+    U    U+     V     V+    W     X     Y
    .0996 .1006 .1011 .1016 .1021 .1026 .1031 .1036 .1041 .1046 .1051 .1056 .1061 .1066 .1076 .1086
    .1000 .1010 .1015 .1020 .1025 .1030 .1035 .1040 .1045 .1050 .1055 .1060 .1065 .1070 .1080 .1090

     0     0     1      0     4      0     2      2     5      3     2      1     2      2    0   0

      0     0     1     0     4      0      2     2     5      3     2      1     2      2    0   0
      3     3     3     2     2      1      3     1     2      0     0      0     0      0    0   0
     -3    -3    -2    -2     2     -1     -1     1     3      3     2      1     2      2    0   0
      3     3     2     2            1      1
                              2                   1     3      3     2      1     2      2

    3P,   3Q,   2Q+,   2R,          1S,   1S+,
                             2R+,                1T,   3T+,   3U,   2U+,   1V,   2V+,   2W,




get back to the main worksheet
  Z Z+Shim_Letter
.1096 0 Shim_Minimum
.1100 0 Shim_Thickness

 0   0 Qty In Head
       Qty On Shelf
 0   0 Total Qty I have
 0   0 Qty Required
 0   0 Final Qty
       Total Purchase Qty   The following   16 shims will need to be purchased to complete this job:
       Total Leftover Qty   The following   16 shims will be left over after this job is completed:

       Need to Buy
       Qty Leftover

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:49
posted:6/29/2012
language:English
pages:4