06 R&D • STUDIO LABORATORY

Experiments & Prototypes

We regularly explore new technologies and ideas before recommending them to clients. This playground demonstrates our technical curiosity and R&D across AI, automation, APIs, data tools, integrations, and web technologies.

EXP_01 AI AUTOMATION • OCR PIPELINE
STATUS: VERIFIED

Local LLM Document & Receipt Extractor

Running quantized lightweight vision and text models completely locally via Ollama. It extracts line items, tax components, vendor identifiers, and transaction dates from scanned paper receipts and invoices directly into structured JSON schemas — without leaking sensitive non-profit grant expenditure data to commercial third-party cloud APIs.

INPUT: Scanned Document

Physical vendor bills, field transit vouchers, grant receipts with degraded printing and stamps.

OUTPUT: Normalized JSON

{"vendor": "Store A", "amount": 1420.00, "date": "2026-03-12", "tax_id": "05AAACH2424..."}

EXP_02 WORKFLOW TOOL • DATA PIPELINES
STATUS: BENCHMARKED

Zero-Config Google Sheets REST API Bridge

A lightweight microservice built on Google Apps Script and PHP that transforms arbitrary client Google Sheets into authenticated CRUD REST endpoints. It supports rate-limiting, schema validation, and field-level permission tokens, allowing external applications to query spreadsheets as robust backends.

GET /api/sheets/{sheet_id}/records?status=approved LATENCY: ~140ms • CACHED
EXP_03 SECURITY • AUDIT TELEMETRY
STATUS: PRODUCTION

Lightweight Ingress & Server Telemetry Engine

A privacy-respecting, zero-cookie server audit engine that captures tamper-evident visitor telemetry, TLS headers, and method signatures without third-party tracking pixels or Google Analytics dependencies.

CAPTURED SIGNATURES: Timestamp • IP • Referrer • Route • TLS Protocol • Clean JSON log rotating
EXP_04 AI INTEGRATION • OPENROUTER API
LIVE PROTOTYPE

GET / POST AI Chatbot Prototype

A server-side cURL proxy communicating with OpenRouter's free-tier LLM endpoints via GET or POST requests. Use the live console below to test real model interactions:

SYSTEM // ASSISTANT Hello! Enter your message below to test our lightweight OpenRouter proxy.
METHOD: POST • ENDPOINT: api_ai_chat.php
EXP_05 DATA ARCHITECTURE • OFFLINE-FIRST
IN DEVELOPMENT

IndexedDB → MySQL Bi-Directional Sync Worker

Offline queue mechanism designed for remote field workers. Stores local records in IndexedDB with cryptographic conflict resolution and pushes deltas when cellular connectivity is re-established.

EXP_06 DOCUMENT AUTOMATION
PLANNED

Serverless Audit-Ready PDF Certificate & Voucher Stamping

Headless PDF generation script that stamps grant milestone IDs, timestamp verification hashes, and audit stamps onto supplier invoices automatically on upload.