Need some help gathering stats

[Spacehead]

I could use a hand in making the BIONC stats i do easier/faster. Here's an example of the stats pages i get my info from.

What i've been doing is getting the numbers from each of the projects pages & converting it(manually) into a CSV file which then OpenOffice spreadsheet can read. Then i run the various formulas to get what i want.
What i'm wondering, is there an easier way to get the info from the stats pages converted into some format that OO spreadsheet can read?

Like covert this into a CSV file:
Also, all BOINC stats are available in XML if that would help too, but i'm quite lost with this sort of thing.

 

[Wolfsraider]

Sorry I am no help but you might pm CoolKid if he has some free time he might be able to do it. or Geoffs maybe. Bump

 

[Smoke]

Space,

Does OO have the DATA IMPORT function as found in EXCEL?

In EXCEL, you'd do a Data/Import External Data/New Web Query and paste in the proper web page. You select the data you wish to import by clicking on the check marks that include the stuff you want. After the initial import is setup all you need to do is REFRESH DATA making sure you are in the proper cell where the initial Web Query was first originated.

Using a little IF statement to help with the "..."s you can quickly get this:

Rnk ?? Members ?.. Total Credit ?? Team Name
1 .. ???... 665 ?? 19,651,020.1 ?.. L'Alliance Francophone
2 .. ???... 624 ?? 11,107,696.7 ?.. Czech National Team
3 .. ???... 666 ?? 10,140,915.0 ?.. Spread Firefox
4 .. ????.. 11 ?.?.. 9,404,094.3 ?.. Team Camelfoot
5 .. ???... 296 ?.?.. 8,552,813.0 ?.. United Kingdom
6 .. ???... 306 ?.?.. 8,282,171.6 ?.. Canada
7 .. ???... 561 ?.?.. 7,910,245.3 ?.. SETI.Germany
8 .. ???... 302 ?.?.. 7,682,703.8 ?.. BOINC Synergy
9 .. ???... 272 ?.?.. 6,994,257.2 ?.. USA
10 ???... 175 ?.?.. 6,196,038.0 ?.. Ars Technica - Team Baked Alaska
11 ???... 187 ?.?.. 6,063,014.1 ?.. Planet 3DNow!
12 ????.. 76 ?.?.. 4,516,443.2 ?.. UniBE.CH - SwissTeam.NET
13 ????.. 81 ?.?.. 4,433,456.8 ?.. Team MacNN
14 ???... 165 ?.?.. 4,386,538.3 ?.. OcUK - Overclockers UK
15 ????.. 67 ?.?.. 3,669,396.2 ?.. Phoenix Rising
16 ????.. 49 ?.?.. 3,662,798.9 ?.. The Final Front Ear
17 ????.. 68 ?.?.. 3,591,797.4 ?.. Picard
18 ???... 142 ?.?.. 3,305,277.0 ?.. The Knights Who Say Ni!
19 ???... 118 ?.?.. 3,290,929.3 ?.. US-Distributed
20 ????.. 67 ?.?.. 3,034,163.0 ?.. TeAm AnandTech

 

[CyGoR]

If time was on my hands, I could help create a (perl) script that fetches and ports the data to a CVS file..
So if you don't find a solution between now and the 1st of july, PM me and I'll fix it for you!

 

[Spacehead]

Originally posted by: Smoke
Space,

Does OO have the DATA IMPORT function as found in EXCEL?

In EXCEL, you'd do a Data/Import External Data/New Web Query and paste in the proper web page. You select the data you wish to import by clicking on the check marks that include the stuff you want. After the initial import is setup all you need to do is REFRESH DATA making sure you are in the proper cell where the initial Web Query was first originated.

OK, i looked around OO & found the import data/web query. I'm fiddling around with it now but i seem to be getting the entire page & not just the data i want. I'll explore some more.

Thanks Smoke

edit - OK, here's what i'm seeing.
I can get OO to query the webpage & then it has a list of "available tables/ranges". For that page it lists:
HTML_all
HTML_tables
HTML_1
HTML_2
HTML_3
HTML_4
HTML_5
HTML_6
HTML_7


Seems i can hi-lite whichever ones i want but no matter it always downloads the entire page, including the menu on the left hand side.
BTW, i'm using the CPDN link from my OP.

edit 2 - OK, looks like choosing "HTML_7" on the CPDN page gets me what i want but i'll need to experiment more for the other projects.
S@H only has:
HTML_all
HTML_tables
HTML_1
HTML_2
HTML_3
HTML_4
HTML_5

& 5 didn't do the trick.

I'll get the hang of this yet

 

[Spacehead]

Thanks Smoke, i got it figured out last night.

:beer:

 

[GeoffS]

I can give you a sample of PHP code that will parse out XML (LifeMapper stats were in XML), or I could put up a page for you that parses the data out into a format that you want... LMK via PM if I can help... my work can be found at www.tastats.com

 

[Spacehead]

Thanks for the offer Geoff & CyGoR, but i believe i got it figured out now. It least if i need more help i'll know where to look