papanda925 - papanda925.com

How Do Filter Bubbles Form? — Running a Simple Model of “Narrowing Recommendations” in PowerShell

We explore the concept of filter bubbles through an educational model in PowerShell consisting of recommendation -> click -> interest estimate update -> candidate reduction.

2026.09.07

AI & Machine Learning

Saving UTF-8 Without Garbled Characters in VBA — Using ADODB.Stream Without Reference Settings

Call ADODB.Stream from VBA using Late Binding to save UTF-8 BOM-included text to a file. We also organize where and when to use Charset.

2026.09.07

VBA / Office

Catching the Exact Moment a File Arrives in a Folder — Change Monitoring with PowerShell + FileSystemWatcher

Use the .NET FileSystemWatcher from PowerShell to monitor creations, modifications, deletions, and renames in a folder as events.

2026.09.07

PowerShell

Do Not Put Secret Strings in Plaintext Files ― Calling Windows DPAPI from PowerShell

A minimal example of using .NET's ProtectedData from Windows PowerShell 5.1 to encrypt a secret string for the current user and save it to a file.

2026.09.07

Security

Clean Up Leading/Trailing and Full-Width Spaces in Excel: Fixing Inconsistencies with Office Scripts

Use Office Scripts to format only string values within an Excel table by cleaning up leading and trailing spaces, full-width spaces, and consecutive spaces while skipping formula cells.

2026.09.07

Microsoft 365 / Azure

Checking HTTPS Certificate Expiration with PowerShell — Directly Using .NET SslStream

Use .NET TcpClient and SslStream from PowerShell to check the server certificate, expiration date, and remaining days of an HTTPS site.

2026.09.07

Networking / RFC

Viewing JSON APIs on Ubuntu with curl + jq ― Extract Only the Required Fields in One Go

Combine curl and jq on Ubuntu to extract only the necessary fields from a JSON API response. We will use the GitHub public Repository API as an example.

2026.09.07

Linux / CLI / DevOps

Extracting IDs, Emails, and IPs from Logs Using Only Excel — Using REGEXEXTRACT / REGEXREPLACE

Using REGEXEXTRACT / REGEXREPLACE in Microsoft 365 Excel to extract IDs and IPs from log strings and easily mask email addresses.

2026.09.07

VBA / Office

What Does VBA DoEvents Actually Do? — Understanding Why Screens Freeze and How Event Processing Works

This article delves into why VBA's DoEvents can restore Excel's responsiveness, exploring event processing, reentrancy, and the differences from asynchronous processing. It is designed to prevent treating DoEvents as a universal asynchronous solution.

2026.09.07

VBA / Office

What Does an HTTPS Certificate Verify? — Viewing the Entry Point of a TLS Connection Through a Sequence Diagram

This article provides an in-depth, diagram-based explanation of what HTTPS server certificates are used to verify, covering TLS 1.3, certificate chains, service identity, and DNS name matching.

2026.09.07

Networking / RFC