Index  | Recent Threads  | Unanswered Threads  | Who's Active  | Guidelines  | Search
 

Quick Go »
No member browsing this thread
Thread Status: Active
Total posts in this thread: 8
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 1718 times and has 7 replies Next Thread
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
? Global Stats into a spreadsheet ?

Hi: Is there a way to get the global stats into a spreadsheet?
[Feb 21, 2014 1:56:42 PM]   Link   Report threatening or abusive post: please login first  Go to top 
jonnieb-uk
Ace Cruncher
England
Joined: Nov 30, 2011
Post Count: 6105
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

Yes.

Most (but not all) of the publicly avalable stats are available in either XML/JSON/CSV format. Start here

For example the link for 30 days global output stats in xml format is:
http://www.worldcommunitygrid.org/stat/viewGl...dsPerPage=30&xml=true

If using Excel then under the data tab select From web and insert the link.

I'm not familiar with JSON but if you have any questions feel free to ask (probably best done by email rather than by forum post).

In addition to random posts such as those on WCG target forecasts I regularly produce stats for the UK team. Take a look at the team thread to see what's possible.

Note that "screenscraping" as a way to insert the data into a spreadsheet is best avoided because of the ongoing changes to website design.
----------------------------------------

To Join follow this link: Join the UK Team All Welcome! UK Team thread
[Feb 21, 2014 2:38:26 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

tried the link:

http://www.worldcommunitygrid.org/stat/viewGl...dsPerPage=30&xml=true

was told it doesn't exist

could you generate it (from day 1 to current) for me & export it as a csv file & email to mark.reiss@ymail.com

or as an xml file to be used in a 3rd party spreadsheet (I don't have MS Office (Excel) I use MS Works!
----------------------------------------
[Edit 1 times, last edit by Former Member at Feb 21, 2014 3:21:58 PM]
[Feb 21, 2014 3:19:42 PM]   Link   Report threatening or abusive post: please login first  Go to top 
uplinger
Former World Community Grid Tech
Joined: May 23, 2005
Post Count: 3952
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

http://www.worldcommunitygrid.org/stat/viewGl...Page=30000&format=csv

This will get you the stats from day one. Just click the link instead of trying to copy/paste the link as you did with johnny's post. The forum software shortens really long urls by adding ... in the middle.

Thanks,
-Uplinger
[Feb 21, 2014 4:15:11 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

Hi Uplinger: I can't get the csv file to work & it looks like the run time is way off! could you generate it as an excel file - let me try that!
[Feb 21, 2014 4:57:42 PM]   Link   Report threatening or abusive post: please login first  Go to top 
foxfire
Advanced Cruncher
United States
Joined: Sep 1, 2007
Post Count: 121
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

Hi Uplinger: I can't get the csv file to work & it looks like the run time is way off! could you generate it as an excel file - let me try that!


The run time in the .csv is in seconds. You have to convert it to y:ddd:hh:mm:ss.

Conversion is
1) years = RT secs / secs-in-yr
2) days = remainder of 1 / secs-in-day
3) hours = remainder of 2 / secs-in-hour
4) minutes = remainder of 3 / secs-in-min
5) seconds = remainder of 4

Where:
secs-in-yr = 31536000
secs-in-day = 86400
secs-in-hour = 3600
secs-in-min = 60
----------------------------------------

[Feb 21, 2014 5:38:57 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Sgt.Joe
Ace Cruncher
USA
Joined: Jul 4, 2006
Post Count: 7846
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

Mr. Reiss,
I have emailed you a CSV formatted spreadsheet of WCG statistics from day 1. Let me know if this meets your needs.
Cheers
----------------------------------------
Sgt. Joe
*Minnesota Crunchers*
[Feb 21, 2014 9:22:20 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: ? Global Stats into a spreadsheet ?

yes - that is very helpful - thank you very much!
[Feb 21, 2014 11:21:43 PM]   Link   Report threatening or abusive post: please login first  Go to top 
[ Jump to Last Post ]
Post new Thread