PROJECT CASES

Case studies and in-house tools

Every tool comes from a specific problem in real work. These pages focus on the problem, the solution and what was delivered.

CASE 01

APSIM Simulation Toolkit

APSIM GUI batch runner supporting parameter sweeps, scenario comparison and result organisation.

APSIMCrop modelsGUIBatch runsParameter sweeps

Problem

The APSIM model needed parameters changed again and again, many scenarios run in batches, and results filtered and summarised from large numbers of output files.

Solution

A Windows GUI that brings model generation, parameter sweeps, run monitoring and result organisation into one workflow.

Main deliverables

Batch runs from a GUI Parameter sweeps and scenario switching Result aggregation and comparison Windows executable
CASE 02

PDF Watermark Tool

Batch PDF watermarking tool supporting text and image watermarks.

PDFWatermarksBatch processingPython

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 deliverables

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

VBA Certificate Generator

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

ExcelVBAMacro securityCertificates

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 deliverables

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

Your project does not have to look like these cases

As long as the problem, the input and the expected result can be described clearly, we can first assess whether it suits automation or a prototype.

Discuss a similar project