Page 3 of 3

Re: Enhancement request for monthly stats

Posted: Wed 22 Feb 2012 12:11 am
by beteljuice
Sorry about that nitrx :oops:

I've been waiting for the reports 'suite' to standardized / updated / tweaked, but it seems to have fallen by the wayside a bit.

One of the 'problems' is the sheer volume of data now available / calculable :shock:

May be time for a rethink / rebuild.
A few lines of code ........... :bash:
eg. Month Alltimes

I 'finished' the 3rd column today, just to see if I could remember all the logic I created.
... that made me remember why I took a break from it :lol:

Currently 1,481 lines of code which escalates with each new data entry
eg. Let's say I was going to introduce T apparent.

Apart from the arrays that have to created to calculate
  • Max Hi
    Max Low
    Max Avg
    Min Hi
    Min Low
    Min Avg
    Max difference
    Min difference
all per month, additional arrays have to keep track of 'All Time' - all these arrays hold value, date and where applicable time.

Almost forgot, I also keep track of when that dataset was first recorded - Not all records begin at the year dot ;)

Then from that single dataset I would have 3 columns with 6 data cells and 6 mouseovers per month. ie. 36 data cells and 36 mouseovers in all.

The other reason I stopped was because I couldn't decide whether it was data for data sake or not !!!

Re: Enhancement request for monthly stats

Posted: Wed 22 Feb 2012 6:54 pm
by RayProudfoot
beteljuice wrote:Currently 1,481 lines of code which escalates with each new data entry
Whilst you have calculated more stats that feature on my Access screenshot further back in this thread I was curious how many lines of VBA were in my code to get those stats.

95 lines was all it took. Clearly PHP is very versatile but the amount of code required seems excessive.

Re: Enhancement request for monthly stats

Posted: Sat 25 Feb 2012 12:58 am
by JennyLeez
Looking good, do you need a hand....lol

Re: Enhancement request for monthly stats

Posted: Mon 27 Feb 2012 10:37 pm
by bigmac
Ooops, sorry beteljuice, I thought it was a mere distraction to while away a few idle moments, clearly it would be a rather large undertaking. I'll go back to gazing in wistful wonder :lol: