Miata Turbo Forum - Boost cars, acquire cats.

General Miata Chat A place to talk about anything Miata

I made an excel calculator for valve lash shim selection, but need help.

Thread Tools
 
Search this Thread
 
Old 03-08-2021, 10:27 AM
  #1  
Junior Member
Thread Starter
iTrader: (2)
 
c3hutson's Avatar
 
Join Date: Oct 2019
Posts: 136
Total Cats: 17
Default I made an excel calculator for valve lash shim selection, but need help.
It's mostly done, but I wanted to make it so the "desired shim" values had a cell color based on if it the current shim is in the desired range. I'm not good enough with excel to figure that much out. Would love any help if anyone is able to do this!

Attached Files
File Type: xlsx
lash worksheet.xlsx (12.6 KB, 30 views)
c3hutson is offline  
Reply
Leave a poscat 0 Leave a negcat
Old 03-08-2021, 01:53 PM
  #2  
Junior Member
iTrader: (1)
 
BarbyCar's Avatar
 
Join Date: Apr 2007
Location: Toronto, Canada
Posts: 469
Total Cats: 25
Default
Some conditional formatting should help.

The two columns min and max tell you whether your shim is in range. Anything red is out of range.
Attached Files
File Type: xlsx
lash worksheet.xlsx (12.8 KB, 29 views)
BarbyCar is offline  
Reply
Leave a poscat 0 Leave a negcat
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
WTB: Valve Lash Shims for SUB
2manyhobyz
WTB
0
06-29-2018 11:48 AM
Valve Shims
kmo25
WTB
0
10-13-2017 12:03 PM
Shims are too thick after head work - safe to grind valve tips?
OSULemon
Engine Performance
7
02-28-2017 03:48 PM
Help! need a 0.160 thick x 1.06 dia. shim
05pearl
Engine Performance
13
05-31-2013 07:08 PM
2 valve stems???
blackna
Wheels and Tires
3
10-03-2010 11:18 AM
Back to Subforum
General Miata Chat
View Next Unread
Water inlet modification options




Advanced Search
Quick Reply: I made an excel calculator for valve lash shim selection, but need help.


Reply Closed Thread Share

All times are GMT -4. The time now is 10:00 AM.