| Index | Recent Threads | Unanswered Threads | Who's Active | Guidelines | Search |
| World Community Grid Forums
|
| No member browsing this thread |
|
Thread Status: Active Total posts in this thread: 8
|
|
| Author |
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Hi: Is there a way to get the global stats into a spreadsheet?
|
||
|
|
jonnieb-uk
Ace Cruncher England Joined: Nov 30, 2011 Post Count: 6105 Status: Offline Project Badges:
|
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. |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
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] |
||
|
|
uplinger
Former World Community Grid Tech Joined: May 23, 2005 Post Count: 3952 Status: Offline Project Badges:
|
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 |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
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!
|
||
|
|
foxfire
Advanced Cruncher United States Joined: Sep 1, 2007 Post Count: 121 Status: Offline Project Badges:
|
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 ![]() |
||
|
|
Sgt.Joe
Ace Cruncher USA Joined: Jul 4, 2006 Post Count: 7846 Status: Offline Project Badges:
|
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* |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
yes - that is very helpful - thank you very much!
|
||
|
|
|