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,862 other subscribers

Archive for the ‘Power User’ Category

« Previous Entries
Next Entries »

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 »

Excel 2011/2010: Conditional formatting of TRUE / FALSE values in an Excel range

Posted by jpluimers on 2024/02/13

The conditional formatting feature in Excel is so cool!

If you use FALSE and TRUE expressions to check validity, you can easily make these red and green.

[Wayback/Archive] Conditional formatting of TRUE / FALSE values in an Excel 2010 range – Super User (thanks [Wayback/Archive] tbone for asking and [Wayback/Archive] digitxp for answering):

Read the rest of this entry »

Posted in Apple, Excel, Mac, Mac OS X / OS X / MacOS, Office, Office 2010, Office 2011 for Mac, Power User, Windows | Leave a Comment »

The death of ESXi finally confirmed by Broadcom

Posted by jpluimers on 2024/02/12

Quite a few people already bumped into this the last two days (will add those links later), so today’s confirmation by Broadcom – who have a similar modus operandi as companies like Computer Associates and Symantec were and Idera is now – as of the ESXi death does not come as a surprise.

Read the rest of this entry »

Posted in Internet, InternetArchive, Power User, Virtualization, VMware, VMware ESXi, WayBack machine | Leave a Comment »

Reminder that the Fritz!Box IKE error 0x1C is still barely documented: crucial places like the built-in help page point to non-existing URLs

Posted by jpluimers on 2024/02/12

A while ago, I had to redo all of the existing Fritz!Box LAN2LAN VPN connections.

It was a pain for many reasons, reminding me of the pain

This is why it was so painful:

Read the rest of this entry »

Posted in Fritz!, Fritz!Box, Hardware, Network-and-equipment, Power User | Leave a Comment »

jilles.com on Twitter: “Question for Dutch HAM radio amateurs, what frequencies are interesting to monitor for digital data? EG IoT/SSTV/Pocsag”

Posted by jpluimers on 2024/02/08

Some links around a question that Jilles posted in 2022: [Wayback/Archive] jilles.com on Twitter: “Question for Dutch HAM radio amateurs, what frequencies are interesting to monitor for digital data? EG IoT/SSTV/Pocsag”

Read the rest of this entry »

Posted in ADS-B receivers, Development, Hardware, Power User, Software Development, USB | Leave a Comment »

Walls and Ladders when pasting e-mail on account sign-up forms: Paste It – Chrome Web Store

Posted by jpluimers on 2024/02/06

In a game of Walls and Ladders (similar to Arms Race), the Ladders usually win, see the references at the end of the post.

The actual “game” in this case is more and more sites trying to build walls prevent pasting credential related information like user IDs (often e-mail addresses) or passwords often citing “more safety” or “less security risks”, and users get taller ladders wanting to do just that because of their own security concerns:

[Wayback/Archive] Stef 🎈 on Twitter: “Dear mobile/web-apps, please never never disable copy and paste “due to security reasons”. -everybody with a password manager.”

The walls will always loose so it is better to invest the money for the walls into other security measures.

Given that most of the risks are web-sites getting that information exfiltrated, I wish they put more energy into bolting down that side of the security risk side than the hampering legitimate users entering that information in the first place.

Since so many of these sites have leaked my information in the past, any email address I use for activating an account is like 50 characters long. Something I am not going to type once (because of typing mistakes) and definitely not twice (to confirm I did not make typing mistakes).

Read the rest of this entry »

Posted in Authentication, Chrome, Clipboard, Development, Google, HTML, JavaScript/ECMAScript, Power User, Scripting, Security, Software Development, Web Development | Leave a Comment »

Some links on BMW E61 5-series roof related things: repairing broken cables, panorama roof repair, etc

Posted by jpluimers on 2024/02/05

Repairing the cabling is a long job but doable if one is careful:

The panorama roof looks a lot harder to me:

--jeroen

Posted in cars, E61 530xd touring, LifeHacker, Power User | Leave a Comment »

Today is the day that video identification died.

Posted by jpluimers on 2024/02/04

[Wayback/Archive] Finance worker pays out $25 million after video call with deepfake ‘chief financial officer’ | CNN

Via:

--jeroen

Posted in Power User, Security | Leave a Comment »

Preventing to eject/unmount a MacOS drive (opposite of figuring out what prevents the unmount)

Posted by jpluimers on 2024/02/01

Not long after Figuring out which processes are preventing to eject/unmount my MacOS Time Machine backup USB drive, I wanted to do the opposite: prevent /Volumes/Sandisk1TB from being ejected, as this is the “built-in” MicroSD card I use to store large or infrequently used files on (ISO and other disk images, drivers, hardware and software documentation, stuff to be installed on a fresh machine).

The opposite is straightforward: have a process keep at least one handle open on the Volume as per [Wayback] macos – How do I not accidentally eject external drives? – Ask Different (thanks [Wayback] kLy, [Wayback] dan and [Wayback] gerlos):

If your important external drive is mounted on the following mount point:

/Volumes/important_disk

Then you can protect it against an accidental removal by locking this mount point as opened. For this one very simple method consists in opening Terminal and doing this basic command:

$ cd /Volumes/important_disk

To get rid of this locking, you might type within the same Terminal window:

$ cd /

or you might as well just close this Terminal window ($ exit, or ⌃+D, or ⌘+W).

…

An even more elegant way to do it is open a screen session (just type screen in Terminal) and open the mount point from that session. This way you can even close Terminal, since the session will keep running in the background, until you reattach it and stop it (so there’s no need to keep a window open if you don’t need it). I guess you can even create an Automator action for it. For tips on screen see: [Wayback] kinnetica.com/2011/05/29/using-screen-on-mac-os-x

–jeroen

Posted in *nix, *nix-tools, Apple, Mac OS X / OS X / MacOS, Power User, screen, Terminal | Leave a Comment »

Julia Evans (b0rk on Twitter) does not just make cool zines (like the DNS one) but also cool sites (the DNS lookup one). It’ is better than Google Toolbox, IntoDNS and others

Posted by jpluimers on 2024/01/31

A while after writing notes on updating DNS info with bind DNS, b0rk (Julia Evans) posted about her DNS zine which got a reply about her DNS lookup tool. Below is part of that thread.

The reason I post is that – unlike the Google DNS ToolBox – you can bookmark her DNS tool link including the actual search part, which makes it far easier to do systems administration.

Examples:

There is a trace tool too:

The thread:

Read the rest of this entry »

Posted in Development, DNS, Go (golang), Internet, Power User, Software Development, Web Development | Leave a Comment »

« Previous Entries
Next Entries »