Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: Re: Re: Data averages by time of day

by Anonymous Monk
on Feb 26, 2004 at 22:06 UTC ( [id://332113]=note: print w/replies, xml ) Need Help??


in reply to Re: Re: Data averages by time of day
in thread Data averages by time of day

Hi,
I've been a diabetic for 20 years but only decided to start serious monitoring 3 years ago. I've been testing my blood 20-25 times a day for 3 years. Over that time I've switched from meter to meter and I'm now using the One Touch Ultra. It has some statistical analysis on it, but it's still poor (in my opinion). A few years ago I started with an Excel spreadsheet and it has evolved to a point where I find it to be very effective. It tracks a 24 hour period and has a graph. The user enters the time of the test and the reading. The sheet will calculate the velocity, acceleration and the jerk (the rate of change of acceleration) and has things like the day's average, mean and standard deviation. I've found that my doctor isn't interested in these numbers, but he does like the 7, 14, 30, 60 and 90 day averages that my meter produces. Anyway, if anyone is interested in my spreadsheet, I'll send it...
Cheers,
Trevor Keppel-Jones.
tkjones@jetnet.ca

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://332113]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (5)
As of 2024-03-28 16:55 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found