Hello everyone,

I’m developing a QA lab at a small craft brewery and trying to get better documentation.

We recently started keeping track of several parameters for the brands that we produce (ABV, Extract, pH, CO2, etc). We have a spec sheet that shows the lower and upper limit of each parameter that we test for every brand.

Right now, we manually highlight cells with out of spec values. I want to develop an excel sheet that automatically highlights a value that’s outside the acceptable range of a test parameter.

It gets tricky because each brand has different specs. ChatGPT suggested vlookup but I haven’t been able to get the function to work. I assume I’m doing something wrong. Any help will be greatly appreciated.

​Hello everyone,I’m developing a QA lab at a small craft brewery and trying to get better documentation.We recently started keeping track of several parameters for the brands that we produce (ABV, Extract, pH, CO2, etc). We have a spec sheet that shows the lower and upper limit of each parameter that we test for every brand.Right now, we manually highlight cells with out of spec values. I want to develop an excel sheet that automatically highlights a value that’s outside the acceptable range of a test parameter.It gets tricky because each brand has different specs. ChatGPT suggested vlookup but I haven’t been able to get the function to work. I assume I’m doing something wrong. Any help will be greatly appreciated.  Read More

​