Yesterday late, coded the automation of the recon notes... as soon as the period close project fetch is executed, any difference is directly printed to the Notes 1 field, or OK if all is hunky dory. This way, a fully auto-scheduled period end procedure is getting closer to the possibles... whenever there's a minutes, look in, have a view of what has and has not happened in proper, and walk away (except, crunching addicts wont ;o)

Dunn and Dusted, yeah right, moved some script calls around, so now the graph axes are updated [when a test is passed], each time a Results fetch is done. Before, it only ran at period end, but with starting users, the graphing data has not found it's hi-low range yet, so now, in the test-case, the previous period hi was 130 result validated, but now we're not even done and already there are 137 valids. Up Y-Axis 1 went.

Just wondered, what feature is not in there (If you don't know, explore )

A little hackathon this morning as in Brexiteer land there's trouble with datemask conversions (Jean-Claude had a bloody difficult dinner with Theresa already, aligning the dates and objectives... like none ;), so instead of formula that 'compute' the screentips for the tool ribbon to say fetch: 281 @ 12:35:22 PM, and pray that the 'locale' set up is correctly knowing hh is hours and not uu or oo or ss the script now does the date translation internally, lets the datevalue loose on the appropriate screentip and whatever locale there is, it is in the way the user has setup the system language/locale, but since computers are in charge it will always be in the order of yymmdd hhmmss, for that is sortable from smallest to largest or the reverse

Thanks to the active tester who 'exposed' the weakness

BTW, the base work has been done to allow calls to translations, so your screentips/pop-up boxes can be swahili if you want to, but need translators to do it for me... just a matrix of 12 x 26 of short and medium long texts up to about 750 characters, but that only for 1x26 fields... the rest is plain short such as "Tasks Retrieval" or "In Progress fetching".

I know, goals of several bridges too far... not of the SMART type, but hey, moi can always daydream

edit: screenshot of the effect of direct injection... though all three procedures ran at 12:06:11 UTC, only the In Progress with the new method got the 'latest' timestamp, the others still waiting for the refresh to take effect... that's ribbon tech.

These are BTW the texts maximum sizes calling for translations into the home tongue.

No Rain today, instead a glorious sunset with wisps of cloud, the lining predicting bell tempo tomorrow... a handwash it was of the fossil fuel consuming wheels.

Concluded the conversion, and stumbled on what I stumbled on in past... VB you can format dates all you like, but the region/locale overrides the / by a -, so was again confirmed at http://stackoverflow.com/questions/8527723/formatsomedate-mm-dd-12-15-in-vba so guess, the GB occupants will be happy to have that piece knock into their submission.

buona serata

Sgt.Joe, Merriam-Webster okayed the 'Statuses' i.e. Results Status (as it appears on the WCG website) or Result's Status as in the Status' Result or Result Statuses and your possessive all are fine... not wanna be a purist today ;O) ...

For there was a hallelujah moment. The newest tester kept walking into the fail wall, and had noted that the scripts go up in smoke after the Statusbar, which gives detail progress information, got stuck somewhere after 'Computing the API tab' and there it was... as hard-coded semicolon, where other environments use the comma as list-separator. The solution, oh how beautiful, is the workbook opening script now reads what the decimal, thousand and formula separators are in the regional lingo settings and write them to some variables and make the script use these, to note, that if you change the Regionals, the scripts will just adapt, so users, feel free, change it to your hearts content.

A second issue was with dates/times... if the time is suffixed with AM/PM then the colon separators in 12:56:34 PM will be in a different spot from right to left or left to right then when having 1:56:34 ... a simple colonpos = InStr(1, timeinput, ":") stores where the first colon is and uses that to pick out the hours, minutes, seconds, always from the left as from that first colon everything else is at + 1, 2 long and + 4, 2 long and not stolper on :5 or :3 the catch the minutes and seconds.

Oh so simple (when you know)

:O)))... Merriam is not one to kid with.

Had good news from the last added testers, it's alive, things *seems* to work. Now the tool has these localizations to offer (with the Henry Ford rule applying to dates), list, formula, decimal, thousand separators will adapt to your system/office configuration.

Locale Code	HexDec.
Belgium (NL-BE)	0813
Danish (DK)	0406
Dutch (NL)	0413
French (F)	040C
German (D)	0407
Gr.Britain (GB)	0809
Greek (GR)	0408
Italian (IT)	0410
Norwegian-Bokmal (N)	0414
Portuguese (P)	0416
Spanish (E-trad)	0C0A
Swedish (S)	040D
US English (US-EN)	0409

Wannah try the latest greatest, and get your country added... PM me at the Berkeley forums.

TTYL