Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-26-2018, 06:54 AM
p45cal's Avatar
p45cal p45cal is offline Format cell and add a comment based on another tab Windows 10 Format cell and add a comment based on another tab Office 2016
Expert
 
Join Date: Apr 2014
Posts: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

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
File Type: xlsx msofficeforums39829ReferenceSheet.xlsx (13.7 KB, 12 views)
Reply With Quote
  #2  
Old 07-28-2018, 09:19 PM
Catluvr Catluvr is offline Format cell and add a comment based on another tab Windows 7 64bit Format cell and add a comment based on another tab Office 2016
Novice
Format cell and add a comment based on another tab
 
Join Date: Jul 2018
Posts: 7
Catluvr is on a distinguished road
Default

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
Reply With Quote
  #3  
Old 07-29-2018, 11:05 AM
Catluvr Catluvr is offline Format cell and add a comment based on another tab Windows 7 64bit Format cell and add a comment based on another tab Office 2016
Novice
Format cell and add a comment based on another tab
 
Join Date: Jul 2018
Posts: 7
Catluvr is on a distinguished road
Default

Here is the Reference Sheet ...

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

Thanks!

Susie
Kansas
Attached Files
File Type: xlsx msofficeforums - ReferenceSheet.xlsx (14.1 KB, 9 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
can you create a comment on a text box like you can do with a cell in Excel ddavis5891 PowerPoint 1 09-06-2012 09:13 AM
Launching a form or comment box when a cell value turns to false cran29 Excel 0 10-25-2011 10:40 AM
comment format jibby Word 5 02-07-2010 06:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft