The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,860 other subscribers

Archive for February 14th, 2024

« The same people who say it’s too hard to write alt text are now suddenly “prompt engineers” who literally write alt text to generate images  » – Thomas Fuchs

Posted by jpluimers on 2024/02/14

As an alt-text advocate, I appreciate [Wayback/Archive] Thomas 🔭✨: “The same people who say it’s t…” – Hachyderm.io

The same people who say it’s too hard to write alt text are now suddenly “prompt engineers” who literally write alt text to generate images.

#inclusion #a11y #accessibility

In case you missed it, this is indeed a thing: Prompt engineer – Wikipedia.

--jeroen

Posted in accessibility (a11y), AI and ML; Artificial Intelligence & Machine Learning, ChatGPT, Development, GPT-3, HTML, Power User, SocialMedia, Software Development, Web Development | Leave a Comment »

For older Excel versions that do not have the =ISOWEEKNUM(date) function, use =WEEKNUM(date,21)

Posted by jpluimers on 2024/02/14

Calculating an ISO-8601 based WEEKNUM

From [Wayback/Archive] ISOWEEKNUM Function – How to Get the Week Number in Excel:

  • If we are using an older version of MS Excel, we can use the function WEEKNUM. By default, the WEEKNUM function uses an arrangement where Week 1 begins on January 1, and Week 2 begins on the next Sunday (when the return_type argument is omitted, or supplied as 1).
    However, with MS Excel 2010 for Windows and MS Excel 2011 for Mac, we can generate an ISO week number using 21 as the return_type: =WEEKNUM(date,21).
  • There is no built-in worksheet function for ISO weeks before MS Excel 2010.

I tested that ISO-8601 week number calculation in with Excel 2011 on MacOS and Excel 2010 on Windows: the workaround works well for the dates mentioned in ISO week date – Wikipedia.

Read the rest of this entry »

Posted in Excel, Office, Office 2010, Office 2011 for Mac, Power User | Leave a Comment »