WOW!

I did NOT expect you to do all this work!

I figured someone would point me in the right direction and I'd go from there.

To answer your questions:

1. As far as the layout ... I would assume so, although after speaking with the vet today, I'm adding a row for the UP/C ratio. I don't think there's anything else to add. But, if I see the VBA pattern, I can make adjustments.

2. The reason I was using the RGB codes was because I have two computers and one has Excel 2010 and the other has Excel 2016. I have found that using the "stock" colors ... like "Orange, Accent 2" gives me different results on each machine. I figured RGB would keep it consistent. (I know it has to do with the themes) If there is a better way, that's fine. Oh, and the colors are arbitrary ... I just picked something meaningful (depending on how many levels there were and the severity of each level).

3. The data on the Reference Sheet can be in any placement.

4. Thresholds is the way I wanted to go but I couldn't wrap my head around it. Unfortunately, most of the research I've done only gives the "normal" value and doesn't always say what an upper (or lower) limit is. I did get some more info today for some of the tests ... as far as how concerning a particular result is and how high (or low) can the results be.

But, for most of the tests, I just have to ball park it based on many different sites or my own knowledge ... for example, the specific gravity measures whether or not the kidneys are capable of concentrating urine.

The research I've seen says that normal is 1.035 to 1.060 and that from 1.061 to over 1.085 is "over concentrated" ... well, does that mean that 1.089 is unheard of? And that results of 1.008-1.012 indicate isothenuria and the kidneys are significantly affected. What about 1.007? I don't know, but I do know that the specific gravity of water is 1.0 and that would definitely be bad, so I made a range of 1.0 to 1.007 to account for that.

In some cases the research says that for a level over X, medication should be considered .... okay, but how far over X can the level get .... If it's X.2 is that bad? what if it's 2X? In many cases, I don't know ...

I will work on the spreadsheet tomorrow.

Thank you so much!

Susie