? Questions on filling in Spreadsheet…

Status
Not open for further replies.
JohnZ

JohnZ

Member Since 2015
I need to set up and start using a Spreadsheet for Derek and have some basic questions…

Looks like the Spreadsheet is set up to enter just 1 reading at just 1 hour intervals and only covers a 12 hour time frame between shots…

How do I handle (enter) those times when multiple readings need to be taken in a hour (for example- the hourly number is abnormally low and several readings need to be taken before the next hourly reading)?

How about (how to enter) when there’s more than 12 hours between shots… let’s say a +13, +13 1/3, +13 2/3 and a +14 (for example- the per-shot number is low, needs to be monitored and am looking for a rebound, before deciding to shot… this just happened yesterday)?

Thanks!
 
Last edited:
Thanks for that...

The cells don't seem to automatically chance color when entering more then one value... is that correct? Am I doing something wrong?
 
That's correct - the conditional formatting that colors the cell can only work if there's just one value entered. For cells where you have more than one result to enter, you have to color them manually by selecting the cell then clicking on the paint can icon at the top of the screen - then you just choose the color you need depending on the numbers you've got. I always used the color for the lowest of the numbers if there was a number from more than one range - so if one of the numbers is under 50 but the next one is just over, I would use the color for below 50 so that anyone looking at the sheet can see instantly that there was a low reading during that hour. :)
 
If you go past +12 occasionally, you just enter it in the next available cell (like +14 from AMPS would go in the PMPS +2 cell) and you can put something like "98 @ +14" in that cell and color code it yourself
 
Thanks! Great suggestions- now I need to take/find the time to a enter all my data.
 
Status
Not open for further replies.
Back
Top