Data & Excel
Revenue Report in Excel: Six Months at a Glance
From 180 bookings of a bicycle workshop, this becomes an overview with monthly revenue, share by category, average receipt and a chart, all as traceable formulas.
Sample work
Finished samples from the areas I take on. Look, download, check.
Sample work (demo), not a client job. Built as a trial task with invented example data; the check figures below come from the automatic test run and are not polished.
Data & Excel
From 180 bookings of a bicycle workshop, this becomes an overview with monthly revenue, share by category, average receipt and a chart, all as traceable formulas.
Web Pages
A page that tells you on a phone within five seconds what the business does, where it works and how to request a quote. Fast, no page builder, no third-party scripts.
Text & SEO
A how-to article of about 450 words, written for owners with little time and built to answer one specific search question.
Presentations
Eight slides that explain a quote so that a decision becomes possible: starting point, goal, scope, process, timeline, price, what is not included, next step.
Code & Bugs
A Python script read “1.234,50” from a German till export as 1.2345. Here are the cause, the fix and the test that locks the bug down from now on.
Automation
Every Monday a workflow summarizes last week's responses to a feedback form and sends a short overview by email. Described with the result, without the workflow file.
Data & Scraping
Name, town, phone, website and opening hours of 40 car repair shops, read from a directory, cleaned and checked. With code, validation rules and the finished file.
Chatbots & AI
A small assistant that answers only from the practice's FAQ and passes on to the team anything it is not sure about. Try it right here.
Design & Print
A combination logo for a fictional company: icon and lettering as a vector file, a version for dark backgrounds, and the icon alone for favicon and app icon. Legibility and completeness are automatically checked.
Design & Print
A campaign visual for a fictional company in all common formats: Facebook/LinkedIn, Instagram, Story, and the standard display formats for Google Ads. Dimensions, file size, legibility, and contrast are automatically checked.
Video & Animation
A thumbnail made from archive material in two color variants for an A/B test. The headline is checked at the size viewers actually see, and the person can be isolated for custom layouts.
Video & Animation
A script for a short documentary video about the moon landing: introduction with the problem, one question per section, an ending that resolves the introduction. Every scene has visual, voiceover and overlay, every claim has a source. The corresponding video is on the GL Tools channel.
Video & Animation
An excerpt from a freely licensed interview becomes a 9:16 short: the framing follows the head, subtitles appear word by word, accompanied by a headline, name lower-third, source and clean audio.
Printing & Packaging
A label with bleed, the die-cut contour of a folding carton with separate cut and crease lines, and a product catalog generated from a table. Each file was automatically checked in the finished PDF: bleed, printing colors, image resolution, embedded fonts, and the dimensions of the contour.
Calculators & Tools
A browser-based calculator that computes a quote step by step. Every displayed amount was automatically checked against an independent recalculation, including half cents and volume tiers.
Games & Interactive
A small logic game in pure HTML and JavaScript. The computer plays a verified strategy, invalid moves are rejected, and the game state survives reloading the page.
Games & Interactive
A product in 3D directly on the website: rotate and zoom with the mouse or finger, choose color, tap hotspots. Built with Three.js and WebGL, automatically tested in the browser.
Data & Dashboards
Revenue, orders and order value at a glance, weekly trend, regions and sales channels. A single click on a filter recalculates everything. Runs in the browser, on mobile as well as on desktop.
Software & Web Apps
While scrolling, a camera flies from section to section through a miniature world without cuts. Each island represents a service, and the text appears accordingly. Runs on desktop and mobile.
Games & Interactive
Questions come from a spreadsheet, the quiz evaluates them and schedules reviews based on the flashcard principle. Import, export, and evaluation were automatically tested.
Maps & Locations
Locations from a table as markers on an OpenStreetMap map, with distance to the warehouse in the popup. The distance calculation was checked against known routes.
Email & Newsletter
An HTML email built with tables as required by email clients: columns stack on mobile, images have alternative text, and the layout does not break even if a program removes the styles.
Data & Excel
An appointment list from Excel or CSV becomes a calendar file for Outlook, Google, and Apple. Special characters, line breaks, time zones, and daylight saving time were checked during reading back.
Software & Web Apps
A small appointment API with time zones, cancellation via token, and a database that does not allow two bookings for the same slot, even with concurrent requests.
Software & Web Apps
A small inventory API with items, transactions, and reorder point. Even with many simultaneous stock-outs, the inventory never drops below zero.
Code & Bugs
An invoicing program read amounts incorrectly when thousands separators were present. First tests showing the error, then the smallest change, then all tests green. Report and change can be found here.
Code & Bugs
An old Python script with modules that are removed in newer Python versions was modernized. Tests before and after, identical outputs byte for byte.
Code & Bugs
Tests for the logic and HTTP interface of a small shop API. Whether they are any good is shown by mutation testing: intentionally introduced bugs must be detected.
Texts & Docs
Installation guide and API reference, generated from code and interface description. Every example in the documentation was executed, and a gap in the code was reported instead of being glossed over.
WordPress
A custom plugin with shortcode, dedicated table, settings page, and export. Security checks such as nonces, sanitization, and escaping were tested on a fresh WordPress installation.
WordPress
A small plugin that applies a discount to a product category starting from a specific quantity. Tested using real shopping carts on a local WooCommerce installation, accurate to the cent, with verification without the plugin.
AI & Automation
A customer service agent with tools for order search, refund, and tickets was run through a test suite. Built-in errors like duplicate refunds or foreign data had to be flagged, after which corrections were made and tested again.
AI & Automation
An MCP server connects a sample company database with an AI assistant. Reading and writing depend on roles, every call is logged, and inputs with special characters cause no harm.
AI & Automation
From the call log of a sample app, it was determined where the costs for language models originate: duplicate requests, retries, overly large models, long prompts, missing output limits. Every proposal was checked for equal quality.
Shop & Commerce
Two supplier price lists, one as PDF and one as CSV, were assigned to a shop's items. Safe matches go into the import file, uncertain ones into a review list instead of the shop.
AI & Automation
A workflow from order to email was intentionally disrupted: timeouts, server errors, duplicate deliveries, and hard crashes. The hardened version does not book anything twice and does not silently lose anything.
Shop & Commerce
Product pages with structured data, a merchant feed, a JSON feed for AI agents, and a read endpoint with current stock are generated from a catalog. Prices, offers, and availability were checked against the catalog.
Data & Documents
Three exports with different date formats and time zones were merged into an event log. This yields the process graph, waiting times per step and the biggest bottlenecks.
Data & Documents
From messy exports, product passports per model are created, validated against a custom JSON schema, featuring a webpage, QR code, and access levels. Built-in data errors land in the error report instead of the passport.
Construction & Engineering
A building model was checked against agreed information requirements: classes, properties, values, and assignments. Each defect is listed with its GlobalId, while correct components remain without notification.
Data & Documents
An operating manual was generated from a semantic source as a tagged PDF and post-processed: Headings, lists, table with header cells, images with alternative text, headers and footers as artifacts. veraPDF checked it against PDF/UA.
Construction & Engineering
Several DXF drawing sheets were compared with the bill of materials from the ERP: positions, quantities, designations, and standards. Every built-in discrepancy was found and marked in the drawing.
Shop & Retail
A custom insect screen configurator checks dimensions, exclusions and mandatory accessories, calculates tiered pricing, shipping and VAT, and provides a delivery date. Python core, JavaScript and UI verifiably calculate identically.
Data & Excel
Rooms with sloping ceilings and openings translate into materials, packages, working time, and offer. The Excel workbook calculates with real formulas and matches an independent recalculation down to the exact cent.
AI & Automation
An operating robot enters orders from a CSV file into a legacy application via the user interface. It recognizes dialogs and errors, waits when the database is locked, and resumes after a crash without duplicate data entry.
3D Printing
You describe the part: purpose, dimensions, how it is mounted. This results in a parametric model checked for watertightness and wall thickness, with studio images, STL files, and printing instructions. The models here are the same ones available for purchase on Cults3D.
3D Printing
From width, depth, height, panel thickness, and number of shelves, a cabinet carcase is created as a 3D model, along with a cutting list for the joinery and front and rear views. External dimensions, watertightness, and panel count are automatically checked against the model.
Video & Animation
An animated explainer video is created from a voiceover text and a few numbers: title, bar chart, key figures, before-and-after comparison and a concluding tip, with an AI voice and word-for-word subtitles.
Video & Animation
Two 3D clips in Full HD: A lettering spins into view with metal material and a moving highlight. A device made of eight parts moves apart and back together on a turntable, showing housing, circuit board, cover, button, and screws individually.
Video & Animation
A product image, a name, a price, and a sentence become a short promo clip: the image springs in, the name builds up letter by letter. Plus a title intro. Once for website and YouTube, once for Reels and Shorts.
Video & Animation
A static screenshot becomes a guided demonstration: the pointer moves to the menu, a click pulses, a frame highlights the area, a speech bubble explains. Followed by a terminal scene with typed command, English AI voice and subtitles.
Electronics
A small sensor board with ESP microcontroller, USB-C and I²C interface: schematic, two-layer layout and manufacturing data in KiCad. Electrical and design rule check without errors, Gerber files re-imported.
Electronics
For the same sensor board: order packages for JLCPCB and PCBWay, price and stock of every component row from public data with source and time, verified replacement parts for out-of-stock items, and a quotation sheet without estimated figures.
Graphics
A square social media template as a PSD: background area, two image layers and one text layer, each named and individually editable - opens in any PSD-compatible program.
Graphics
A two-page A4 newsletter as an IDML file, which opens in InDesign as an editable document, with paragraph styles, threaded text frames, and linked images, plus the PDF as a proof.
Video & Animation
A short script about the moon landing, illustrated with public domain recordings from the NASA archive: camera pans across images, chapter titles, voiceover and subtitles. Each file is listed with source and license.
Video & Animation
Two vector characters based on a description, a round bird and a mouse with a long tail. They wave, hop, wag, and blink, and each speaks its own line. Every frame is rendered individually, so nothing stutters.
Video & Animation
A short explainer video in whiteboard style. Each drawing is created stroke by stroke, a hand guides the pen, and a voiceover explains the problem, solution, and result.
Video & Animation
Three Lottie animations as for an app onboarding, as small JSON files. The colors come from a brand palette, the success checkmark is included in two color variants.
Code & Bugs
A small task API in Java using pure JDK libraries, tested end-to-end via HTTP, plus an off-by-one error: red before, green after the correction.
Code & Bugs
A contact form with storage and a vulnerable search page that I secured against SQL injection and XSS. The security test cases were red before, green afterwards.
Code & Bugs
A token and an escrow contract in Solidity, plus a vulnerable contract and its fix. Compiled without warnings, the reentrancy vulnerability is reported and no longer present in the fix.
Design & Print
Two sample logos, one as a blurry JPEG, one as a PNG with transparency, rebuilt as vectors. Measured by congruence, edge sharpness, and brand color fidelity.
Data & Excel
This is what a lead list of mine looks like: public business addresses, email from the business website, verification, sources, and reasoning per row. The file here contains only fictional sample companies.
Games & Interactive
A small 2D game in GDScript: obstacles fall, the player dodges, the speed increases with the score, and after a collision, a restart continues the game. The game logic is automatically tested.
Code & Errors
A task API with Spring Boot and Maven: create, read, update and delete, input validation with clear error messages. Tested with JUnit and real HTTP calls, plus a counter-test with broken versions.
Code & Errors
A small Laravel application with database table, controller, form validation, and view. Tested with Laravel tests and real HTTP calls, plus a cross-check with broken versions.
AI & Automation
A small neural network on sample data, measured against random guessing, logistic regression, and gradient boosting, with cross-validation. Plus delivery: model in three formats and a prediction script that produces identical results in a fresh process.
Software & Web Apps
A small app with list, form, check off, delete and local storage. Analysis without messages, unit and widget tests green, built as a web app and rendered in the browser.
Software & Web Apps
A small app with Docker image, Helm chart and CI file, deployed to a local Kubernetes cluster. The update ran under load without errors, as did the rollback. Plus a Terraform module, tested against an AWS replica.
Design & Print
A motif for light and dark shirts, as a vector and transparent print file, plus a screen printing version in a few spot colors and a mockup. Resolution, transparency, number of colors and contrast are measured.
Design & Print
An album cover for a fictional black metal band in a raw charcoal and ink style: 3000 x 3000 px for digital release, plus the cassette J-card as a print PDF with bleed, crop and fold marks. Dimensions, color profile, legibility of the text even as a small preview image, and the safety zones at the fold edges are measured.
Print & Packaging
A folding box as a print PDF: custom net shape layout, die-cut and crease lines as spot colors, bleed, CMYK colors, embedded fonts and a valid EAN-13 barcode. Dimensions have been verified by measurement.
Video & Animation
A Short for Reels and TikTok from raw audio: pauses cut out, hook at the beginning, word-for-word subtitles, cuts timed to the music, color grade and music ducked under the voice. Everything is measured.
Video & Animation
A finished character in layers is automatically rigged with joints and animated: breathing, blinking, waving, walking, and speaking. The drawing itself remains unchanged.
Video & Animation
A German video is recognized, translated sentence by sentence and delivered twice: with burned-in English subtitles and with an English AI voice aligned with the original sentences. The subtitle file is included.
Video & Animation
Continuous audio is recognized in short segments and displayed as subtitles, with the actual recognition latency. Technical terms come from a glossary list, and a word at the end of a segment is only shown when the next segment confirms it. Everything runs locally, without a cloud service.
Copywriting & SEO
For a fictional business: first access for AI search crawlers, then short answer first, FAQ with schema matching the visible text, author, date, and sources. Measured before and after using the same checklist.
Texts & SEO
Response to a fictional call for bids: every requirement answered, mandatory criteria never concealed, what we do not fulfill is stated openly. Price table, schedule with deadline and length are machine-checked.
Websites
For a fictional bakery: WordPress version and visible plugins checked against current versions, certificate and security headers verified, each finding with a traffic light and concrete measure.
Websites
Backed up files and database on a test page before each update, applied updates individually and checked them; a faulty plugin update was detected and restored from the backup.
Websites
For a fictional machinery dealer: accessories can only be added to the cart together with the matching machine, the rules come from a CSV file, and a bundle price applies starting from a certain number of matching parts.
Websites
For a fictional tool shop: logged-in customers download their price list as a PDF, dealers see their dealer prices, end customers see the regular ones. The PDF is created without a third-party library.
Texts & SEO
For a fictional bakery: Name, address, and phone number reconciled across multiple directories, discrepancies found and cleaned up, profile text, Q&A, review responses, and LocalBusiness schema without fake ratings.
Copy & SEO
A demo landing page with built-in vulnerabilities. The auditor finds them, sorts them by revenue impact (message to ad first) and the revised page passes without findings. Impact shown as a ranking only, not as a percentage.
Copywriting & SEO
Headline, about section and posts for a fictional person. Checked against LinkedIn character limits, the hook before the 'See more' button, a maximum of three hashtags, exactly one question and no empty buzzwords.
Email & Newsletter
A welcome series for a fictional business including trigger, goal, intervals, and exit condition. Each email is checked for subject line, preview text, length, exactly one call-to-action, placeholders with fallback values, and spam words; includes a CSV for import.
Texts & SEO
A demo page with typical errors: broken JSON, fabricated rating, price as text, question not in visible text. The validator finds them, the after-page carries Product, FAQPage, BreadcrumbList, and LocalBusiness without findings.
Texts & SEO
Technical check of a demo site: third-party scripts before consent, fonts from external servers, embeds without two-click solution, banners without reject option, missing privacy policy, outdated legal notice. No legal advice.
AI & Automation
For a fictional company: agents with roles, tools, inputs and outputs, handovers, error handling, and cost budgets. A validator identifies built-in design flaws, and a dry run with mocks demonstrates the path to human approval.
Software & Web Apps
For a fictional business: a normalized schema derived from requirements, including keys, foreign keys, indexes, and uniqueness. The initial schema contained standard errors; the final schema runs with demo data, revenue figures are correct, and the query plan utilizes the indexes.
Code & Errors
A small demo module with typical review findings: SQL from strings, mutable default argument, bare except, open file, eval, password in source code. Each finding includes line, severity, and suggestion; the correction is implemented and verified.
Software & Web Apps
A demo description in OpenAPI format with typical flaws: verbs in the path, lists without pagination, missing error responses, no authentication, dead references. The reviewer identifies them, the revised description passes.
Code & Bugs
A demo project with fictitious packages: unspecified versions, packages with vulnerabilities, a package with an incompatible license, an unknown package. Findings by severity with suggestions, the after-list exists.
Code & Bugs
A slow demo program: cProfile identifies the function where the time is spent, the fast version provides the same result value by value, and the time is measured repeatedly. An optimization with a different result is rejected.
Texts & Documentation
A changelog following 'Keep a Changelog' and a short version for customers are generated from the commits of a demo repository. Each commit appears exactly once, breaking changes are at the top, unclear items are visible, and the version number follows the rules.
Code & Bugs
A demo codebase with an overly long function, deep nesting, many parameters, copied blocks, and open tags. The register sorts by impact over effort; after reducing the top items, the number decreases measurably.
AI & Automation
A demo skill in both a suspicious and a clean version. The auditor reads all files and detects injection, download-and-execute, exfiltration of environment variables, access to key files, code from external text, invisible characters, and excessive permissions. Nothing is installed or executed.
Texts & Documentation
For a fictional company and a fictional position: weighted competencies, behavioral and work sample questions for each competency, evaluation scale with described anchors, workflow, and a form that calculates the score. Questions regarding age, family, or origin are excluded and verified.
Texts & Documentation
For a fictional operation: a runbook for a demo service with daily checks, every command with an expected result, backup including verification, recovery, and typical error patterns. An included checker rejects a vague runbook.
Code & Bugs
A demo repository with invented, intentionally fake credentials. The scanner finds them in multiple files, reports them without plain text, generates .gitignore and .env.example, and reports nothing when the code is clean. Real keys are not present in any part.
Texts & Documentation
For a fictional company: Severity levels with response times, a workflow with roles, templates for reporting to the team, customers, and authorities, as well as a no-blame debriefing. An auditor rejects a vague guide.
Software & Web Apps
For parallel development: a branching strategy, a script for separate working directories, and a template for pull requests. The script runs in a disposable repository; separate branches and safe cleanup are measured.
Software & Web Apps
For a fictional company: a pnpm workspace with two packages that use each other via workspace references, with shared TypeScript, ESLint, and Prettier configuration. Dependencies are checked for cycles; nothing is installed.
Research & Analysis
For a fictional online shop: several niches measured from an open source, ranked by conversation, purchase intent, and provider density. Every number in the report includes a source and date; a report with fabricated numbers will fail.
Construction & Engineering
A sheet metal housing cover as a bent 3D model (STEP), including the flat pattern as a DXF with bend lines and the workshop drawing as PDF and DXF. The flat pattern was verified against my own calculation according to DIN 6935.
Data & Documents
Two price lists in different formats (Excel and CSV) are compared item by item: new, removed, price, name. Additionally, a comparison of two text versions with the modified paragraphs. Every incorporated change was found, none invented.
Software & Web Apps
A small calculation program is packaged into a standalone Windows application that runs without Python, using an installation script without administrator rights. The package was freshly unpacked, started, and installed.
AI & Automation
Public websites are scraped and saved as clean Markdown with preserved links, for example as a knowledge base for a chatbot or for data analysis. Tested on three real, public pages.
WordPress
A ready-made redirect plugin is installed, activated, and configured on a fresh WordPress copy, with one fixed rule and one rule with a wildcard. Each rule was verified via request, including a control test without the plugin.