Miata Turbo Forum - Boost cars, acquire cats. - I made an excel calculator for valve lash shim selection, but need help.

Miata Turbo Forum - Boost cars, acquire cats. (https://www.miataturbo.net/)

- General Miata Chat (https://www.miataturbo.net/general-miata-chat-9/)

- - I made an excel calculator for valve lash shim selection, but need help. (https://www.miataturbo.net/general-miata-chat-9/i-made-excel-calculator-valve-lash-shim-selection-but-need-help-104803/)

c3hutson

03-08-2021 10:27 AM

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

1 Attachment(s)

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!

BarbyCar

03-08-2021 01:53 PM

2 Attachment(s)

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.

All times are GMT -4. The time now is 03:58 AM.