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: 226
Posts: 226   Pages: 23   [ Previous Page | 7 8 9 10 11 12 13 14 15 16 | Next Page ]
[ Jump to Last Post ]
Post new Thread
Author
Previous Thread This topic has been viewed 187656 times and has 225 replies Next Thread
Former Member
Cruncher
Joined: May 22, 2018
Post Count: 0
Status: Offline
Reply to this Post  Reply with Quote 
Re: Supplemental Charts Going Under Due It's Own Success

Project "Metro-ize, Phase I" has completed. All the blue framed graphs of the Charts-1 set have been updated to this new model, making them look lots more consistent, clean, AND automating the sort orders from largest/longest/biggest with clear color labeling background establishing "connecting" to the respective line/area/bar in the graphs. Most of these charts have now a current day and multi day summary list with values for the respective periods. Sample: http://bit.ly/WCGCPY

On to phase II.

--//--
[Mar 19, 2012 10:22:14 AM]   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: Supplemental Charts Going Under Due It's Own Success

So phase II was cleaning up the woodchips and slickify the execution and appearance... which IMNSHO has turned out to produce the cleanest charts, so far, such as http://bit.ly/WCGART and http://bit.ly/WCGCPY (The CPU reference will be phased out again, and Runtime put in place... the app.plan impact)

Thanks to some dirty VBA code [below], the color coded tables are always ranked from biggest to smallest, and in the referred example, showing where each science compares to the global averages... above/below/on the median... and 'on the go' applied some "Gestalt Law of Continuity" to the chart features... playing with your brain, and much more to come on that ;P

Next up, all the project labels text/numbers, like on the dashboard, will print red text when there's a record and blue when there's a milestone (if you had not already remembered that ;>). Will keep me busy for another week to figure that out and then clean up again for that 10 second wiz experience (on my side)... then when all is re-concatenated in a script... vacation.

--//--

A 10 minute chore reduced to a 10 seconds wiz.... just Ctrl-Shft-S and no time to fetch another cup of brew (Mokarabia).
Sub GlbSort()
'
' Sort Macro for Global Chart Tables
' Declare Variables
Dim glbchrt As String
'
Application.ScreenUpdating = False
Worksheets("Charts II").Calculate
Application.Goto Reference:="PicTab.TPDx1"
Range("PictureTable").Select
' Set Do loop to stop on first empty range cell.
Do While Not IsEmpty(ActiveCell) = True
glbchrt = ActiveCell.Offset(0, 0).Value
ActiveWorkbook.Worksheets("Charts II").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Charts II").Sort.SortFields.Add Key:=Range("PicTab." & glbchrt & "x1") _
, SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Charts II").Sort
.SetRange Range("PicTab." & glbchrt & "Rnk")
.Header = xlYes
.MatchCase = True
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
' Go down 1 row from last location.
ActiveCell.Offset(1, 0).Select
Loop
Worksheets("Charts II").Calculate
Application.ScreenUpdating = True
Application.Goto Reference:="PicTab.TPDx1"
End Sub


P.S. The *blue* stacked area charts are going to loose the bevel appearance. Sorry to those who just acquired a 3D display, but this is how it might all be looking across the board http://bit.ly/WCGTFL

P.P.S. Anyone notice the yellow blip in the WCGCPY chart? Need 1 or 2 more of those to make it to sapphire for that science biggrin
[Mar 26, 2012 6:52: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: Supplemental Charts Going Under Due It's Own Success

After a few days of hiatus on publishing the performance charts, here a slightly enhanced version. The stuff that always looked like gummed on is now inside the graphics area. New and old, pasted below to visualize the change: http://bit.ly/WCGSNS

Whilst looking at this, think I've dreamed up a way to get the current day labels to align to the cumulative data set below... Watch this space, should this one turn out to doable. biggrin

--//--

edit: That did not take long, the legend text and color identifier having an articulate link... vincitore dancing
----------------------------------------
[Edit 1 times, last edit by Former Member at Mar 28, 2012 4:52:50 PM]
[Mar 28, 2012 3:59:16 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Dataman
Ace Cruncher
Joined: Nov 16, 2004
Post Count: 4865
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Supplemental Charts Going Under Due It's Own Success

You are an artist, Seke. Thanks.

----------------------------------------


[Mar 28, 2012 4:09:52 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: Supplemental Charts Going Under Due It's Own Success

Thx... the only problem to overcome is same as with BOINC... they [Bill & Co.] don't give any good manuals to max out on the possibles ;>)

--//--
[Mar 28, 2012 4:59:39 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: Supplemental Charts Going Under Due It's Own Success

Seems to fill a need to 'see' [those pesky days left mostly] :
24,023 Clicks on Your bitly Links since Apr 25, 2012


14,000 are direct referral from the WCG forums and 10,000 from elsewhere links that sites and members maintain... and this is using the bit,ly shorts only. 60 to 90 thousand views monthly per my 'bucket' stats, the dark days of February showing most. smile

Crunch On

--//--
----------------------------------------
[Edit 2 times, last edit by Former Member at May 24, 2012 11:51:02 AM]
[May 24, 2012 11:45:18 AM]   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: Supplemental Charts Going Under Due It's Own Success

Questions for the chart viewing interestees:

1) Who *can't'* see the HD animation of the below image [what browser/version]? [Those with FF above 3.5 see this special png file format out of the box],
2) If you can't see the animation, is the image appearing sharp or blurred? [Those who can't see the animation would see only the latest date]
3) If you see the animation, is the 2FPS to high or too low? [with intend to stick more than 5 into an animation, when refreshed]
4) Are parts of the moving spheres not updating in any frame?

Thanks for your time


[Jul 16, 2012 8:11:19 AM]   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: Supplemental Charts Going Under Due It's Own Success

LOOK'S BLURRED TO ME ON 3 W7 64BIT OS's ALL USING IE9. Then again dosen't bother me; fore I only use the dashboard table.
[Jul 16, 2012 11:13:52 AM]   Link   Report threatening or abusive post: please login first  Go to top 
pramo
Veteran Cruncher
USA
Joined: Dec 14, 2005
Post Count: 716
Status: Offline
Project Badges:
Reply to this Post  Reply with Quote 
Re: Supplemental Charts Going Under Due It's Own Success

can see in FF 13.0.1
Seemed fast at first, it took me a but due to the project names bouncing around but when finally to able to get color to project stuck in my head it was better.
all parts moving in every frame for me.
The "mirrored" of project list bouncing around was a little distracting but i'm an old man:) Pretty cool animation, I like it!

No movement in IE8.. see the last frame and it's sharp
----------------------------------------

[Jul 16, 2012 12:09:49 PM]   Link   Report threatening or abusive post: please login first  Go to top 
wplachy
Senior Cruncher
Joined: Sep 4, 2007
Post Count: 423
Status: Offline
Reply to this Post  Reply with Quote 
Re: Supplemental Charts Going Under Due It's Own Success

1) Can see in FF 13 & 13.0.1 | cannot see in IE 8 & 9
2) In both FF & IE CEP2 + GFAM + CFCW have a ring of light fuzzy color around them (like eclipse of sun effect)
3) 2FPS looks about right to me
4) All parts updating in frame
----------------------------------------
Bill P

[Jul 16, 2012 2:56:03 PM]   Link   Report threatening or abusive post: please login first  Go to top 
Posts: 226   Pages: 23   [ Previous Page | 7 8 9 10 11 12 13 14 15 16 | Next Page ]
[ Jump to Last Post ]
Post new Thread