| Index | Recent Threads | Unanswered Threads | Who's Active | Guidelines | Search |
 |
World Community Grid Forums
Category: Community
Forum: Chat Room
Thread: Supplemental Charts Going Under Due It's Own Success |
| No member browsing this thread |
|
Thread Status: Active Total posts in this thread: 226
|
|
| Author |
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Oh and click stats on stats glossing, 7579 views this week with the shorted bit.ly redirects.
Some of these charts tell a 1000 words, but for some conjure up 1001 ;>) --//-- |
||
|
|
pramo
Veteran Cruncher USA Joined: Dec 14, 2005 Post Count: 715 Status: Offline Project Badges: 
|
RRPM is nice!
---------------------------------------- |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Thought so too. :O) ... Ctrl-F5 ... just upload a slightly smarter one, removing the print date and swapping HFCC and CEP2, also C4CW and HPF2.
... and played with the WCGYPM perspective and scales to create a more ''from top'' view and added the contemplated table. Better, me thinketh. --//-- |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
In a stroke of sheer genius... I Googled an old problem: How to exclude zero values to find the next closest minimum or exclude them from counts and averages, and hit gold-dust. All it needed was to type the formula into Excel, hold Ctrl+Shift and only then Enter to convert it to an array formula and voila, "in-cell" script processing each time the sheet is recalculated. The Dashboard showing them now without any complicated contortions in multi-line code. Read [one of many hits producing the same solution]:
----------------------------------------http://www.excelbanter.com/showthread.php?t=195642 The World is my Oyster [Frankie goes to Hollywood, ca 1984] --//-- edit: For the interested... Some expansion on the new discovered country in Excel: http://office.microsoft.com/en-us/excel-help/...in-excel-HA001087290.aspx [Edit 1 times, last edit by Former Member at Jun 24, 2011 8:18:54 PM] |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
Did I hit gold-dust last time with the array function, it was this previous week a nested "find.all/substitude" trick to replace the decimal comma with a point and the thousand point separator signs with a comma and voilá, no more wonky values showing at times in the various charts, that is, if the conversions have completed.
Meantime, a longer time rare sighting, but all project satellites are revolving again simultaneously around planet WCG. Rarer view, the Beta mini moon has not dropped below the baseline horizon, but it will be back for that hopefully final beta test on Project X(18). Till then, crunching on --//--  P.S. Some satellites obscure others in near full alignment. Can't do much about that even when there's some transparency on some. |
||
|
|
gb009761
Master Cruncher Scotland Joined: Apr 6, 2005 Post Count: 3010 Status: Offline Project Badges: 
|
SekeRob, is it me, or has the Active/Research dashboard chart not updated since the 31st of Jan 2012?
----------------------------------------I've cleared my cache and pulled down a fresh copy from this http://i137.photobucket.com/albums/q210/Sekerob/WCGYearsPi1Project.png address  |
||
|
|
Falconet
Master Cruncher Portugal Joined: Mar 9, 2009 Post Count: 3315 Status: Offline Project Badges: 
|
SekeRob, is it me, or has the Active/Research dashboard chart not updated since the 31st of Jan 2012? I've cleared my cache and pulled down a fresh copy from this http://i137.photobucket.com/albums/q210/Sekerob/WCGYearsPi1Project.png address I'm getting the same.  - AMD Ryzen 5 1600AF 6C/12T 3.2 GHz - 85W - AMD Ryzen 5 2500U 4C/8T 2.0 GHz - 28W - AMD Ryzen 7 7730U 8C/16T 3.0 GHz |
||
|
|
Former Member
Cruncher Joined: May 22, 2018 Post Count: 0 Status: Offline |
That's right., and sorry, but it's WIP without ETA. Till then the old abacus and/or advanced mental math needs to take over. Example:
HCMD2 remaining days January 31: 19 Days passed since: 5 HCMD2 remaining days on Feb 5: 14  --//-- |
||
|
|
gb009761
Master Cruncher Scotland Joined: Apr 6, 2005 Post Count: 3010 Status: Offline Project Badges:
|
ah, okay - just thought there might have been a glitch in the generation/uploading process.
----------------------------------------Looking forward to the new version  p.s., you wouldn't be hiding the fact that a new project launch is imminent would you  [Edit 1 times, last edit by gb009761 at Feb 5, 2012 7:26:31 PM] |
||
|
|
PecosRiverM
Veteran Cruncher The Great State of Texas Joined: Apr 27, 2007 Post Count: 1054 Status: Offline Project Badges:
|
p.s., you wouldn't be hiding the fact that a new project launch is imminent would you It makes you wonder...     |
||
|
|
|