papanda925 - papanda925.com

Making Monthly CSVs Resilient to Column Name Changes — Handling Column Variations with Power Query M

Standardize column name variations such as employee codes and IDs using Power Query M, and fill in missing columns with null. Inputs with ambiguous multiple candidate columns are safely stopped.

2026.09.20

VBA / Office

Checking the Contents of a ZIP Without Extracting It — Directly Using .NET's ZipFile from PowerShell

Use .NET's ZipFile.OpenRead from PowerShell to list file names, original sizes, and compressed sizes without extracting the ZIP.

2026.09.20

PowerShell

Sending Raw HTTP in PowerShell — Experiencing HTTP over TCP on localhost

Connect to localhost using TcpClient and send an HTTP/1.1 GET request as a string. Observe the differences between the HTTP and TCP layers on a single PC.

2026.09.20

Networking / RFC

10 Characters $neq$ 10 Bytes: Comparing UTF-8 and Shift_JIS Byte Counts in PowerShell

Character count, .NET String.Length, and the byte count after encoding are not the same concepts. We compare UTF-8 and code page 932, and use PowerShell to examine why discrepancies occur with fixed-length data and BOMs.

2026.09.20

Programming / Web Development

Do Not Construct URLs with String Concatenation ― Safely Building Japanese Queries with PowerShell + UriBuilder

Use .NET's UriBuilder and Uri.EscapeDataString from PowerShell to escape queries containing Japanese or spaces and safely construct URLs.

2026.09.20

Programming / Web Development

What’s the Difference Between Sync, Async, Callbacks, and Promises? — Separating “How to Wait” from “How to Receive Results”

Rather than treating synchronous, asynchronous, Callbacks, Promises, async/await, and VBA's DoEvents as the same concept, we organize them by separating "how to wait" from "how to receive results."

2026.09.20

Programming / Web Development

Part 4: Eyecatch Mass-Production Workflow Using Character Sheets – Aligning Article Images with the Same Papanda

We organize the operational flow for mass-producing blog eyecatches by using the papanda925 Character Sheet v1 as the master reference, keeping the facial features, body type, and color scheme fixed while changing only the background, props, and poses.

2026.09.20

Generative AI

Making LLM Responses Easier to Verify: Comparing Outputs by Changing a Single Format Setting

Using the same dummy meeting minutes, we compare how easy it is to review LLM responses before and after specifying the output format.

2026.09.20

Prompt & LLM Utilization

Making LLM Responses Easier to Verify: Comparing Output Formats by Changing a Single Parameter

We test a method to make LLM responses easier for humans to verify by using the same meeting notes while changing only the output format.

2026.09.20

Prompt & LLM Utilization

Making LLM Responses Easier to Verify: Comparing Outputs with "Evidence" and "Unknown"

By changing just one part of the prompt with the same input, we compare how easy it is to verify responses that explicitly state the evidence and points of uncertainty.

2026.09.20

Prompt & LLM Utilization