The Wiert Corner – irregular stream of stuff

• Email Subscription

Join 4,173 other subscribers

Archive for January, 2023

On my list of *n*x things to play with: script and ttyrec

Posted by jpluimers on 2023/01/26

–jeroen

Day of the Year in Microsoft Excel

Posted by jpluimers on 2023/01/25

Given cell `A1` is a valid date, I wanted to know the day of that date in that year.

My solution is =A1-DATE(YEAR(A1)-1,12,13)

I disliked the solution in [Wayback/Archive] Day of the Year in Microsoft Excel and [Archive] Day of the Year in Excel (In Easy Steps) (excluded from the WayBack machine), as it is unclear where the `+` comes from in their solution `=A1-DATE(YEAR(A1),1,1)+1`

So, here goes my solution, with explanation:

• `=YEAR(A1)` is the year of `A1`
• `=YEAR(A1)-1` is year before `A1`
• `=DATE(YEAR(A1)-1,12,13)` is the last day of year before `A1`
• `=A1-DATE(YEAR(A1)-1,12,13)` is the day of the year of `A1`

The last step works because subtracting two dates in Excel returns the number of days between those two dates (in a similar way, you can add a number to a date to get a new date number days in the future; similarly you can add time portions as fractions of a day).

• `=YEAR(A1)` is the year of `A1`
• `=DATE(YEAR(A1),1,1)` is the first day of the year of `A1`
• `=DATE(YEAR(A1),1,1)-1` is the last day of the year before `A1`
• `=A1-(DATE(YEAR(A1),1,1)-1)` is the day of the year of `A1`
• `=A1-DATE(YEAR(A1),1,1)+1` is a simplification of the day of the the year of `A1`

–jeroen

Some links I on Windows Memory Compression I want to check out

Posted by jpluimers on 2023/01/24

I’m not sure yet why sometimes my system is lagging with the combination of these four circumstances on a Windows 10 system with 32 gigabyte of memory:

1. Process Explorer showing low (less than 10%) CPU usage
2. Process explorer showing Memory Compression using more than 2 gigabytes of Working Set
3. System Commit being larger than 20 gigabyte
4. Lots of Chrome tabs open (no easy way to total memory usage, but likely 16 gigabyte or more)

Windows Compression was introduced in Windows 10 (back in 2015) and I’m still fairly new to it.

So here are some links I want to eventually dig into to make myself more familiar with it, and see if it affects Chrome runtime behaviour:

Thanks [Wayback/Archive] magicandre1981, [Wayback/Archive] peterh, [Wayback/Archive] Raymond Burkholder, and [Wayback/Archive] Falco Alexander for the above questions and answers.

From them, I learned that on a UAC elevated administrative command prompt, you can use these PowerShell for managing Memory Compression:

1. `Get-MMAgent` shows the current Memory Compression state
2. `Disable-MMAgent -mc` disables Memory Compression (requires a reboot)
3. `Enable-MMAgent -mc` enables Memory Compression (requires a reboot)

BTW:

–jeroen

Learning github actions by creating a repository with a dynamic README.md for your profile information

Posted by jpluimers on 2023/01/23

TL;DR:

1. Create a GitHub repository with the same name as your profile name
2. Add a `README.md` with Markdown describing your profile
3. In the `README.md`, add begin/end HTML comment markers `<!--` and `-->` for various types of dynamic content
4. In the Actions of this repository, add Workflows for each of the set comment markers that use them to refresh that part of the content using GitHub Actions learning some continuous integration/continuousc deployment (CI/CD) on the fly.

You can spice this up with all kinds of badges to make it look pretty.

Yes, it is indeed odd to have HTML comments in Markdown where you could just as easy use Markdown comments, but hey: I didn’t define the way this works.

A Markdown comment looks like this:

``````(empty line)
[comment]: # (This actually is the most platform independent comment)``````

For explanation on why/how this works, see the below two great StackOverflow answers in this order:

Howto

The below two videos (also embedded below the signature) show how to do this. Thanks [Archive] Jesse Hall 🦸‍♂️ #vsCodeHero (@codeSTACKr) | Twitter for creating them!

The description of the videos contain all sorts of links to sites and underlying repositories for:

• icons
• shields
• profile examples

You can see the effects at [Wayback/Archive] codeSTACKr/codeSTACKr in the [Wayback/Archive] raw README.md sources.

Enough to get you some experimentation (:

One of the drawbacks of mixing manual and automated changes to a repository, is that the automated changes can cause a lot of commits.

This is OK as long as the automated changes add value to the changed content.

In this regard, having stable RSS feeds is important, and YouTube is kind of bad at this when you look at [Wayback/Archive] History for README.md – codeSTACKr/codeSTACKr: videos changing order or popping in/out of the last 5 is kind of annoying.

–jeroen

Some more Compuserve memories

Posted by jpluimers on 2023/01/20

Some years ago, I wrote CompuServe’s forums, which still exist, are finally shutting down on 20171215.

Getting older and various people passing away made me relive some of the CompuServe memories where I used to be [Wayback/Archive] “100013,1443”.

Semi-offline access software like TapCIS and later OzCIS and OzWin helped lessening the bill of mainly getting to the CompuServe forums BPROGA that hosted Turbo Pascal (and later PASCAL for Borland Pascal plus Delphi), BORGMBH (Borland Germany)  and PCVENB (for Turbo Power Software: a back then – large supplier of tools and libraries – later acquired by a casino software company) learned to know a few TeamB members and other (now) oldies like Neil J. Rubenking.

TeamB members coming to mind: Pat Ritchey, Kurt B. Barthelmess, Rudy Velthuis, David Nottage, Steve Fischkoff, Nick Hodges, Steve Schafer, Paul A. LeBlanc and others (I wish someone had a full list of past members).