[Ian]

I still can't figure out how to parse the WCG stats automatically to reduce the workload for compiling stats, so I wondered if an excel file that does most of the work would be any use?

I should be able to make it create the forum posts (ready to copy+paste) from the table on this page.

Would that be any use to you Mucks/Ady/V_R - or is it about the same as the spreadsheet that mucks uses at the moment?

[Adywebb]

An excel file would be of use to me as I'm not good at formating excel spreadsheets so have to do it manually at the moment

[Ian]

OK, I'll work on this tomorrow between work

[Adywebb]

Thanks Ian


...off to bed now - got to be up at 4.30am to do the stats before I leave for work

[Adywebb]

Ian - using the Free-DC stats is not going to work I think - yesterday they updated at 10.45 CDT which is 4.45pm our time, which is too late.

Is it possible to do a simple spreadsheet where I manually input the updated figures using the Points Generated stats at WCG with a column automatically calculating the points difference since the day before?? http://www.worldcommunitygrid.org/te...mId=3CJW57FQP1

Must go to work now Ian - see you this evening

[V_R]

Excel sheet would be cool.

Ian, Dunno if this will help, but Tom over at BBT has excel sheet that gets the data automatically, then he just takes a screen print and posts the pic....Have a look at this thread here Maybe it will help, i dunno but seems like a good way to do it.

Is that any help?

[muckshifter]

I have a spreadsheet, not Excel, I use OpenOffice ... it is a little basic but I don't need a calculator.

I have been looking at Google to store the database and allow access by certain parties ... Ady, V_R and whoever ... but it ain't ready for prime-time use ... BETA

Those that have 'access' can alter the data and others can be allowed to view only, still need to manually input the data.

Free-DC have been having problems and have been very spasmodic ... sorry to say but I wouldn't use their stats for any accuracy.

The problem with my database is if you miss a day, then all the stats are out for the next day, it has to be kept uptodate everyday ... Anybody want a coppy of my database just ask, OOo is free & if you want an Excell copy, I suppose I could export it to that format.

[Ian]

OK, I'll have to have a think on how best to do this then - I think I have an idea that can automate it almost completely in Excel (but would need a little new work with each new cruncher).

I'll see if I can get it finished sometime tonight once I'm back from work

[Ian]

This is as far as I've got with Excel - as I just can't figure out if it is possible to automatically create the points banding that is usually done in the 2nd post. Are there any Excel macro wizards that know if this is possible to do, as if it is I'll see if I can use the Excel router (otherwise I'll have to use PHP).

I'm guessing I might be able to use conditionals to say that if "user x" returned between 1000-2000 points to put their name in a certain cell, all the way up to 20k per day say. Is this possible to do?

I've uploaded the Excel file incase anyone wants to take a peek (its based on the BBT one V_R posted!) - it will connect to DC-Stats (for the moment, till I can figure out how to use WCG for daily returns). The WCG.xls.txt needs to be renamed to WCG.xls to work.

[Adywebb]

Looks good Ian


Can't help with the Excel macro's I'm afraid - I can barely input data into cells