More on what I'd like you to do:
In the attached is a version of your Reference sheet.
I'd like you to fill in column B (colours too but I can probably work those out myself) and attach the file here.

You'll see I've made a stab at Phosphorous at B47, and added various formulae in column C.
To illustrate the sort of thing I'll do in code I've highlighted cell L47 in yellow where you can type in experimental values for Phosphorus, and see in M47 the kind of text that will appear in the comment box.




Would you want the functionality where if a reading is so far positive or negative that it's nigh on physiologically impossible, you could have comments to suggest checking the validity of the result?

Attached Files

msofficeforums39829ReferenceSheet.xlsx (13.7 KB, 12 views)

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

Here is the Reference Sheet ...

Some of the levels have been adjusted based on conversation with the doctor.

Thanks!

Susie
Kansas

Attached Files

msofficeforums - ReferenceSheet.xlsx (14.1 KB, 9 views)