Skip to main content

Technical demos and development notes

How the author built tools for real problems: what the problem was, how it was handled and which features resulted. Demos come with files you can run yourself.

Verifiable technical demos

Each demo states its input, process, output, how it was checked and its limits, with files you can re-run yourself.

PDF Watermark Tool

Batch PDF watermarking tool supporting text and image watermarks.

Problem

Large numbers of lab reports and internal PDFs needed the same text or image watermark added again and again; doing it by hand was slow and things got missed.

Solution

A batch PDF watermark tool with folder processing, automatic naming and visual settings.

Main features

  • Text and image watermarks
  • Batch processing of folders
  • Automatic output naming
  • Graphical interface

VBA Certificate Generator

Generates self-signed code signing certificates for Excel / Word VBA macro projects.

Problem

Distributing Excel and Word VBA tools to internal computers required self-signed certificates, but the command-line steps were not intuitive.

Solution

The certificate steps wrapped in a Windows GUI, making testing and internal signing easier.

Main features

  • Self-signed certificate generation
  • Parameter input and error messages
  • Windows GUI
  • User instructions

Facing a similar problem?

If you have similar repetitive work in research or the office, feel free to share ideas or recommend a tool worth listing.

Leave a message