| Index | Recent Threads | Unanswered Threads | Who's Active | Guidelines | Search |
 |
World Community Grid Forums
Category: Support
Forum: Website Support
Thread: Contribution statistics wrong? |
| No member browsing this thread |
|
Thread Status: Active Total posts in this thread: 7
|
|
| Author |
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Please, have a look to the link below which refers to a screenshot!
----------------------------------------I used Excel to sum up all Project Points generated with the value shown in the contribution table above. For some reason I do not understand those values are diffrent (red line). Is this a bug or something else? On the other hand, when I compare "Results compared" (green line) the values are the same. Screenshot [Edit 1 times, last edit by Former Member at Apr 13, 2016 12:20:07 PM] |
||
|
|
SekeRob
Master Cruncher Joined: Jan 7, 2013 Post Count: 2741 Status: Offline |
A quick eyeball suggests your sum of 615,943 points is incorrect. Please recheck.
----------------------------------------edit: The 256 value is suspect... probably it has to be 0,256 [Edit 1 times, last edit by SekeRob* at Apr 13, 2016 12:26:48 PM] |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Nope. 256 is correct concerning the second Screenshot:
----------------------------------------Screentshot 2 But you are right. It must be 0,256. When changend to this value the sum is correct. So what we have here ist a display bug regarding values lower than 1. [Edit 1 times, last edit by Former Member at Apr 13, 2016 12:45:49 PM] |
||
|
|
SekeRob
Master Cruncher Joined: Jan 7, 2013 Post Count: 2741 Status: Offline |
When you look at the US website, thousand signs is comma, so 2 results is worth 256 points, but in your spreadsheet where the , is used as decimal sign, there is no comma i.e. your spreadsheet imported the value incorrectly as were it 256,000. Anyway, knock yourself out, or try my suggestion to prefix the number so it reads as 0,256, then see how it totals.
 --//-- |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
I just edited my last post. And corrected the value to 0,256. As I mentioned before you are right. At least we have a display bug which causes this question ;-)
----------------------------------------[Edit 1 times, last edit by Former Member at Apr 13, 2016 12:50:27 PM] |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Thank you for your support!
|
||
|
|
adriverhoef
Master Cruncher The Netherlands Joined: Apr 3, 2009 Post Count: 2346 Status: Offline Project Badges: 
|
Here's what I would do: select the lines from the My Contribution page (selecting all project names with all their columns (Project, Points Generated, Results Returned, Total Run Time, even Badges Earned)), copy all that (ctrl-C), then go to your spreadsheet, paste (ctrl-V), and everything should be in order: numbers with comma's should be converted to comma-less numbers (maybe you should tell your spreadsheet that you are importing English numbers). Hope this is of some help.
|
||
|
|
|