Off topic: That Bob Ross guy was amazing. Who would think you could paint the pictures he did with a 2 inch paint brush.

Back on topic. You paint quite an impressive picture of detail in that spreadsheet.

Cheers

Moving elements, the graph taken from top right to be big bold bottom left, overlaying the daily history which just slides underneath [isn't it great you can use the same space twice... having the cake and it eat ;>], v1.6i

Everything now has rounded corners **, comments too, which have shading as well to add to the abundance of gimmick. The comment shown in the latest screenshot points at the added feature of an added column with the per active project contributions to-date, including current validations. Today hit 0.99 years on Beta, so put the 2005 prosecco in the cooler for decorking very very soon, any reason for decorking a bottle will do anyway. 10 years to compute 1.

Having collected all the white space, moved that right top, for something to 'add' in the futura.

ToDo: Make all rounded corners [no 90 degrees left] to have the same radius. Drawn by hand, Office does not make it easy to scale them the same on different sized squares.

P.S. To top it off, the graph's results trendline is now accompanied by it's equation and the R-Squared, the slope, which is positive, albeit 0.0007 is not visible to the bare eye ;O)

Oh yes, the device table, bottom centre, had the platform code added, W/L/M/A speaking for itself. One day some analysis could get inserted. Running me own little WUProp soon, their data is timelimited I've got the impression.

As more than a few got franconized [or is it fraternized], 'Victoire'

The nightly ResultXML update ran apparently 3 times, yes the effect of hitting the scheduler button multiple times during testing. 00:16:11 UTC was the last time and all meshed perfectly after I, II, then hit III.

This morning 'enhanced' the ugly code, thunderstorms and heavy deluges cancelled our cycle tour, so had time for that and made the pink Scheduler button to also show when the next refresh is actually going to be setting off [Office does not tell you how many there are]. It became less gross, more done with less code lines.

Private Sub SchedResultXML()

    Dim NowTest As Long, WhenNext As Double
    NowTest = Hour(Now)
    If NowTest > 20 Then WhenNext = Range("SchedNight"): GoTo SetSched
    If NowTest > 9 And NowTest < 14 Then WhenNext = Range("SchedNoon"): GoTo SetSched
    GoTo Ending:
SetSched:
    Application.OnTime WhenNext, "RefreshXML1", Schedule:=True
    [WhenSched] = WhenNext 'Inserts 'Next time' into the Schedule ResultXML button on mainpage [for feedback]
    PlaySound "C:\windows\media\windows notify.wav", 0, 0
Ending:
    [WhenRun].Value = "TooL"
    Call TimeStamp

End Sub

Next up, 12:06:11 UTC

Finally found the backdoor to the backdoor to get the device statistics results/runtime to match up for android devices, or for that matter deals with any host name duplicates **. Once figured out, it's simple, that is, after some probabilistics, AND closest approach math [fuzzy logic search] due the incredible finding that time-stamps of 'last returned' results are earlier then those on the 'last received' timestamp of the same on the Result Status pages. Yes, more Quantum Monte Carlo states at WCG . To think, light travels at 292,792 km and some per second, could be here, could be there. At any rate, this little ditty does the thing... connect the Result Status page API extracts with the Device Statistics query data [no ?xml=true function], to get to the unique device ID of a device in the matrix, where there are no duplicates of moi.

=IF(ISTEXT([@[Rev.IdRaw]]);INDEX(ResultXml1[DeviceId];MATCH(ROUND(DATEVALUE(SUBSTITUTE(MID([@LastWUDevStats];4;3)&LEFT([@LastWUDevStats];2)&MID([@LastWUDevStats];6;5);"/";"-"))+TIMEVALUE(RIGHT([@LastWUDevStats];8))+SecDayFrac;10);ResultXml1[ReceivedTime];-1)+IF(ISTEXT([@[Rev.IdRaw]]);1;0));[@[Rev.IdRaw]])

** My Multi-boot device has the same host name be it in Windows or Linux, and my router has no issue with that either :D

Why all the song and dance? To arrive at cumulative device statistics through the last minute, including validated results of current period, and as always, tallying. See right top version 1.7a, the former white space section, printing too what platform the hosts run on.

P.S. Had a great opportunity with the website down and delayed stats, to see if the hunting tool would catch this, and yes it did latch on that the ran at 14:16:01 UTC, so morning stats summed through this time.