Economic Report September 1st - 6th (in General)

http://spreadsheets.google.com/ccc?key=0ArC5tsbkFbxndFoxYmU4N19BdnBETDFtSHlWVUd3YXc&hl=en

There, my second Economic Report V1.05 is almost finished.
I will assemble the last bits and pieces this evening but this way you have the data already :)

Regards,


Dennis




p.s. let me know if there is anything missing or wrong in the Report

Won't be assembling the last bits and pieces tonight, will have to be done tomorrow.



Is there anyone willing to help getting a bit of the history together to import in this? (old threads are all available, just have to filter it out)

Updates:
• Item Metastats now displays coloured percentages correctly (i.e. +0.16%)
• All separate item pages now also display correct numbers (i.e. +2)

Things to do:
• Insert spells stats page in correct format
• Make all formulae in column C be positively absolute
• Think about making column C frozen also as well as A and B who already are. This would make the overall stats always visible while you'd be able to scroll back in time.
• Think about making a lookup set of fields in which you would be able to look up any stat of any time period put into the report

oh btw. nobody posts in here so I might as well post:

What I find remarkable is that we are losing Jigorokano Familiars in the game. In August 2008 we had 419 of them while now we have 6 less.

While not really shocking, it does mean that some people have converted their Jiggy in another tattoo.

Shade!

Thanks for picking up the Econ. Report. It's a big task, you should automate it like I did. Crunching numbers by hand was not fun at all. It's too bad Jon took away scripting in the forums, or else I would've kept at it. Loving what you're doing though! :)

How did you automate it then?

I could make a macro to insert the data from another file but the way I put it up, I have all the stats typed in (more like copy/paste) in half an hour or so.

The format I now have also makes me able to put in graphs later on :)

It depends on the system you're running on. If you're on Windows, you could do scripting to grab the web pages and then parse through the HTML. On Linux/Unix systems, you should be able to use "wget" to pull the pages.