Ohlahlah, had to emergency implement some code, JIC, as it does happen that users do not have any completed result validating in a 12 hour stats period, at which point Step II and III of period end would not executed... why would they if there's no results to count

And since it's a topic of discussion, the umpteened time, why WCG can't set up merging the same way ONLY OF THE STATS like other BOINC projects [with the standard checks for clearly same device with install over install], continues to be a riddle (Techs, time to dump that UD era shell!), am designing, in me head, how to roll up the stats of devices with same name, user definable, meaning users tag all 'same devices' with the same alias, with some buts as Androids get this truncated name on the device stats history to all be called Android (a long standing puzle why that's not being fixed to show the same reference as is used on the Result Status pages). I'll find a bandaid for that idiosyncrasy too... I will, because I can

TTYL

This last, hot hour, succumbed to stepping out of another international agreement, and injected into the web-scrape routine near start that ',' is decimal separator and '.' is thousands separator, to then on seconds thoughts afterwards quickly reverse that cranial shortout, and put

.DecimalSeparator = .International(xlDecimalSeparator) 'add 04.06.2017
.ThousandsSeparator = .International(xlThousandsSeparator) 'add 04.06.2017

back, so everyone can look at the results in their own homey number format style.

Yesterday added a few new custom functions

=SecondsTime(cellref)
=DigitalTime(cellref)
=GetDevId(cellref)

Extremely simple to get times converted from 1:23:45:56 notation into seconds and seconds back into the more human comprehendable 1:23:45:56 and to extract the numeric and unique Device ID out of the URLs on the various, in html, scraped pages. No matter how often the same device name is used, the device id will, without fail, connect the latest stats and roll them up for all with the same device name... got mydesktoppowerhouse1 10 times installed... no problem, not to speak of the multiple 'Android' featuring on the device statistics history

One of the few active testers reported on a bug in Step II, the archiving of the last period results, then trying to run Step III, Update Histories (of the project contributions), which tests if step II ran and if not do it on the go [Yes/No?] msgbox, but was not so sure it did. To fill that 'where am I?' feeling, the tool's center main screen will show a new Icon, an orange tick mark with a II, indicating that archiving did complete.



There's no Step III completed icon, yet, as this step opens up the new period when done i.e. if the blue IP icon shows up, the project level histories were updated successfully (something WCG is not offering ;P). A little overkill, as when history was written correctly, the accompanying new period record opens with 0:00:00:00 runtime and the comment 'Prd in Progress'.

No, the tool is still not done, the export of the project histories is still on the most wanted list... just in case the tool crashes and a restore is needed to a previous copy.

The close shave, Mach 5 blade, vibrating type, batteries included, determining how much space is needed after the first fetch pass (ResultsAvailable field), then size the output table in one go to that number instead of sizing up by 250 records max per fetch call. 55 seconds instead of 66. Courtesy of the techs who've as yet not resumed deleting old validated records, my account grew to 5500 results, a new personal record , 23 pages, so can test a full pass reasonably quickly. Network suspended on the client, so we have a good static set to evenly compare from run to run (with a stable ISP at this time :0).

Please, Pleased Me, the last control run, full complement at the bottom

Per 62500 results, went from 74 minutes at start to 14:15 with the last re-ordering tweaks.

Boils down to 1 octo and 1800 active results, serverstate 5, done in under half a minute, computed at all, while crunching full out.

More