Enhancement request for monthly stats

[beteljuice]

Sorry about that nitrx

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

May be time for a rethink / rebuild.

A few lines of code ...........

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

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 !!!

[RayProudfoot]

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.

[JennyLeez]

Looking good, do you need a hand....lol

[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