|
Spreadsheets
The real pro is Kirby Stone who is also a subscriber.
My original spreadsheet had the following columns:
A = dates
B = WBC
C = RBC
etc. with a heading on each column identifying it and the normal ranges.
Kirby showed me to add a column inbetween each of the above columns, filled in with the high or low value, whichever one is important in each case. When you highlight the entire spreadsheet to make a chart, those added columns are the norms that will show up as a straight line across the chart, in some neat bright color.
Later if you want to print out the chart without showing the norm columns, use "hide" on those columns.
Usually you're more interested in a high or a low, so it's usually unnecessary to put both in.
Also, when in putting the values in the charts, I change the font to bold and the color red when a value is not within the normal range.
Also, it just doesn't work to put all the various values in because some values you're looking at are very limited, such as WBC, RBC. If you put them on the same chart as platelets, nothing shows up very well.
I also use a trendline.
Before Kirby, I couldn't figure out how to get the dates running along the bottom of the chart. That was because I didn't highlight the dates. I'm not in Excel right now, but there's a code in the formating of the chart that will display those dates. Just remember to change the alinement to perpendicular if you have a lot of dates so you can read them.
That's all I can think of right now. Hope this helps!
|