Real Experience Reports

AI automation
that truly works —
tested, documented,
ready to deploy.
Real solutions
for real problems —
measurable results,
from practice.
From idea
to finished system —
live AI solutions,
directly transferable.
AI in action
no theory —
documented, tested,
ready to use.
Practical examples
that convince —
eight case studies,
openly shared.
Automation
that convinces —
real results,
no promises.

Here I share my personal experiences from real AI projects — Excel VBA, n8n‑workflows, Ollama and RAG‑systems. No marketing, just real results.

Nine Projects. Real Insights.

All projects are based on real implementations. I share what worked — and what didn't. Free knowledge exchange without profit intent.

AI_Invoice – Voice-Controlled Invoice Creation
Excel & VBA
15 min → 2 min per invoice
Industry: Construction / Trades Case Study #1

AI_Invoice – Voice-Controlled Invoice Creation

Problem

Invoices were created manually in Excel — time-consuming and error-prone. XRechnung compliance for public clients was missing and had to be laboriously corrected.

Solution
  • Docker-based system with n8n workflows, Python API and Ollama LLM
  • Three input methods: voice input, camera scan, text entry
  • Fuzzy matching for customer and product recognition from natural language
  • Excel stays as backend — familiar interface, no retraining needed
  • Automatic XRechnung generation (EN 16931) for public-sector orders
  • Web interface for master data management (customers, products)
Result

Invoice creation reduced from 15 minutes to under 2 minutes. Full compliance with German e-invoicing standards (XRechnung) without additional software.

Docker n8n Python/Flask Ollama Excel/VBA XRechnung-XML
AI_Quote – Intelligent Quote Calculation
AI Agents
Hours → Minutes per quote
Industry: Construction / Trades Case Study #2

AI_Quote – Intelligent Quote Calculation

Problem

Creating quotes required manual price research, calculation and formatting. Quotes were inconsistent, error-prone and took several hours per job.

Solution
  • Template-based quote creation with stored product prices
  • Automatic price calculation based on quantities and service specifications
  • Consistent formatting for a professional appearance
  • Link to customer master data from AI_Invoice
  • Seamless workflow: Quote → Order → Invoice
Result

Quotes in minutes instead of hours. Consistent pricing, fewer calculation errors, seamless transition to the invoicing workflow.

Excel/VBA Python-API Web-Frontend n8n
AI_Photo – Mobile Document Capture with AI-OCR
AI Image Analysis
80% less processing time
Industry: Construction / Field Service Case Study #3

AI_Photo – Mobile Document Capture with AI-OCR

Problem

Handwritten notes and delivery slips from the construction site had to be typed manually. Information was lost or arrived late at the office.

Solution
  • Camera integration in the web interface for instant scanning
  • Google Cloud Vision API for handwriting recognition (DOCUMENT_TEXT_DETECTION)
  • n8n workflow for processing: Image → OCR → Structured Data
  • Automatic extraction of customer, quantity, product from scan
  • Direct forwarding to invoice or documentation
Result

Photograph a delivery slip — invoice created. No media breaks, no lost papers, no more manual typing.

Google Cloud Vision API n8n JavaScript/Base64 Python
AI_Jobsite – Digital Construction Site Management with Offline App
Construction
Chaos → Order digital site management
Industry: Construction / Project Management Case Study #4

AI_Jobsite – Digital Construction Site Management with Offline App

Problem

Construction site documentation was chaotic — documents scattered, no uniform filing, information unavailable on site. Every jobsite was its own information silo.

Solution
  • Web-based jobsite overview with automatic folder structure
  • 14 document types: contract, specs, appointments, correspondence, suppliers, minutes, invoices, accounts, plans, images, emails, daily reports, contacts, voice recordings
  • Chronological sorting of all files with one click
  • Progressive Web App (PWA) for mobile capture — works offline without installation
  • Automatic synchronization on network connection to correct folder paths
Result

Complete jobsite file always at hand. Field staff record on site, office has immediate access. No lost documents, no duplicate filing.

PWA/JavaScript Dateisystem-Integration automatische Sync-Logik responsive Web-UI
AI_RAG – Corporate Knowledge Base with Admin Panel
RAG System
100% local & GDPR-compliant
Industry: Cross-Industry / Knowledge Management Case Study #5

AI_RAG – Corporate Knowledge Base with Admin Panel

Problem

Company knowledge was scattered across documents, emails and people's heads. New employees needed weeks to get up to speed, experts were constantly interrupted with routine questions.

Solution
  • RAG system (Retrieval Augmented Generation) with ChromaDB as vector database
  • Automatic indexing of documents from network drives
  • Admin panel for system control: container management, indexing, cache, logs
  • Docker-based architecture for simple deployment
  • nginx reverse proxy with SSL for secure access
  • Live monitoring and health checks
Result

Employees ask the system instead of colleagues. Onboarding time drastically reduced, expert knowledge preserved and always accessible.

Docker ChromaDB Python/Flask nginx n8n Ollama/LLM
EV Charge Mgmt – Smart Electric Vehicle Charging Management
EV Charging
WhatsApp groups → System fair & transparent
Industry: Cross-Industry / EV Charging Infrastructure Case Study #6

EV Charge Mgmt – Smart Electric Vehicle Charging Management

Problem

EV charging was chaotic. Employees formed informal agreements and WhatsApp groups, leading to unfair charging availability. Vehicles with small batteries were disadvantaged.

Solution
  • EV charge management with ASP and Access database on virtual VM server
  • Simple time slot booking for all employees
  • Admin panel for quota management
  • Mobile-optimized user interface
  • Vehicle management and booking overview
  • Live monitoring with slot booking, occupancy overview and fleet manager function
Result

Employees use the system instead of WhatsApp groups. Availability inquiries and calls have drastically reduced. Fair, transparent allocation of charging spots.

ASP Access/SQL responsive Web-UI VM-Server
DeskSharing – Office Workspace Booking System
New Work / Office
Chaos → Transparency digital booking system
Industry: Cross-Industry / Hybrid Office Case Study #7

DeskSharing – Office Workspace Booking System

Problem

In hybrid working life, office occupancy was unpredictable. Employees arrived to find their preferred spot taken — or offices stood empty. Informal WhatsApp groups and email arrangements led to unfair desk allocation. A fair, transparent management solution without extra admin overhead was completely missing.

Solution
  • Complete web booking system for desks and meeting rooms
  • Interactive room plan with real-time availability at a glance
  • Quick booking: date, time, spot — confirmed in under 30 seconds
  • Employee search: Who is in the office when? Perfect for spontaneous meetings
  • Admin panel: room management, building maintenance, equipment features, blocked times
  • User role management (Admin/User) with separate admin cockpit
  • CSV import for rapid bulk creation of spots and users
  • Mobile-optimized interface for bookings on the go
Result

Transparent space utilization, fair desk allocation, end of WhatsApp groups. Facility management can control office space specifically. Employees book in seconds, the office always knows who is coming.

PHP/Web MySQL responsive UI PWA CSV-Import Rollenverwaltung
Construction Site Recording – Offline App with Automatic Filing
Construction / Offline App
0 manual transfers automatic filing
Industry: Construction / Trades Case Study #8

Construction Site Recording – Offline App with Automatic Filing

Problem

On construction sites without stable internet, employees had to record measurements, photos and notes on paper or locally and manually transfer them after returning to the office. Information was lost, incorrectly assigned or ended up in the wrong folder. The transfer cost valuable time every day.

Solution
  • Offline-capable app for complete construction site recording without internet connection
  • Measurements, photos, notes and status reports captured digitally on-site
  • Automatic synchronization when returning to the company network
  • Intelligent assignment of captured data to the correct construction site
  • Automatic filing into correct folders — no more manual transfer
  • Structured filing by project, date and document type
Result

No more manual transfers. All construction site data automatically ends up in the correct filing location. Employees save time daily, errors from incorrect assignment are a thing of the past.

Offline-App n8n automatische Synchronisierung Ordner-Automatisierung Smartphone
ERP/CRM System — Customers, Quotes, Invoices, Construction Sites and AI Tenders in One Application
ERP / CRM with AI
1 system instead of 6 tools end-to-end process chain
Industry: Trades / SMB Case Study #9

ERP/CRM System — Customers, Quotes, Invoices, Construction Sites and AI Tenders in One Application

Problem

In day-to-day operations, customer data, quotes, invoices, construction site documentation and tender research were spread across isolated tools: Excel lists, Word templates, photo folders on smartphones and manual searches on tender portals. Data was maintained twice, quotes were copied together from old Word files, site photos sat unsorted on phones and matching tenders were simply missed. A unified system connecting all processes was missing.

Solution
  • Stand-alone ERP/CRM system based on ASP.NET Core (C#) with a modular controller and view structure
  • Customer management, product catalog, quote and invoice creation in one continuous process chain
  • Construction site management including photo documentation directly within the system
  • AI-powered tender module: relevant tenders are loaded, analyzed and ranked by fit automatically
  • Integrated RAG module that makes company knowledge, past quotes and service descriptions usable for answers and new quotes
  • Role and rights management with dedicated admin area, user accounts and secure authentication
  • Deployment on IIS under Windows; clean publish folder with app-offline mechanism for zero-downtime deployments
Result

Six formerly isolated tools (Excel, Word, photo folders, tender portals, mail attachments, notes) were merged into a single system. Quotes and invoices are now produced at the click of a button from the customer database, site photos are automatically assigned to the right project, and matching tenders appear in the dashboard automatically — instead of being missed. Data maintenance is unambiguous, sales throughput is noticeably higher, and the entire company knowledge sits in one central place for the first time.

ASP.NET Core C# MVC Entity Framework IIS RAG KI-Ausschreibungen Bootstrap

AI‑Automation that pays off.

These figures come from real projects — no marketing, no extrapolation. I share my personal experiences using AI and Excel VBA in daily work.

80%

avg. time savings across projects

7+

different industries automated with AI

100%

of solutions locally deployable

0 €

cost for questions and experience exchange

This page is not a company.

All projects are experience reports from private hobby engagement. No commercial service, no fees, no liability.

No liability

No guarantees, no sales pressure. Please test any solution in your own environment first.

With passion

No profit motive, just joy of technology and AI‑workflows. This is a hobby, not a business.

100% free

Questions, experience exchange and tips are always free and non-binding.

AI Agents in Action

Real screenshots of our developed applications — from invoice creation to intelligent document search.

rechnungs-ki-agent.local
Rechnungs-KI-Agent
angebots-ki-agent.local
Angebots-KI-Agent
baustellen-ki-agent.local
Baustellen-KI-Agent
foto-ki-agent.local
Foto-KI-Agent
rag-ki-agent.local
RAG-KI-Agent
ev-lademanagement.local
EV-Lademanagement
desksharing.local
DeskSharing System
baustellen-erfassung.local
Baustellen-Erfassung
erp-crm.local
ERP/CRM-System

Do you have a similar task?

Ask your question about Excel VBA, n8n‑workflows, Ollama or RAG‑systems — I'll answer free of charge from the Fulda region.

Has this knowledge exchange helped you? Voluntary support via PayPal is very welcome — but never required.

💙 Support voluntarily via PayPal
⚠️
Important note: All AI‑projects, Excel VBA‑solutions and n8n‑workflows presented here are experience reports without warranty. Please test any solution in your own environment first. I assume no liability for damages.

Did this help you?

If a solution for Excel VBA, n8n workflows, or AI automation saved you time, you can voluntarily support me. No obligation, no pressure — just appreciation.

Support via PayPal

No obligation · No subscription · Just gratitude for useful content