schwengle.com

Automation Library

Production-ready scripts, templates, and checklists. Download and deploy.

Templatesv1.5.0

Project Status Dashboard (Excel)

Excel template with dynamic status indicators, RAG (Red/Amber/Green) scoring, and a summary tab that auto-populates from project sheets. No macros required.

templatesproject-managementexcelreporting
Updated Feb 2026↓ Download
Pythonv1.0.0

Expense Report Extractor

Python script using openpyxl that reads raw expense exports, categorizes line items by keyword rules, and outputs a clean summary CSV ready for accounting.

pythonfinanceexcelautomation
Updated Feb 2026↓ Download
Bashv1.3.0

Server Health Monitor

Bash script for Linux servers that checks CPU, memory, disk, and service status on a schedule and sends an alert email when thresholds are crossed.

bashmonitoringlinuxalerts
Updated Feb 2026↓ Download
Pythonv0.9.0

Automated Standup Digest

Python script that collects standup updates from a Slack channel, groups them by team, and posts a daily digest to a management channel. Configurable via JSON.

pythonslackstandupautomation
Updated Feb 2026↓ Download
Templatesv2.0.0

Decision Log Template

Structured Markdown template for logging key decisions with context, options considered, assumptions made, and planned follow-up. Works in Obsidian, Notion, or any editor.

templatesdecisiondocumentationmarkdown
Updated Feb 2026↓ Download
Templatesv1.0.0

Vendor Renewal Tracker

Spreadsheet template to track contract renewal milestones, risk review steps, and escalation owners. Includes conditional formatting for 90/60/30-day alerts.

templatesprocurementcontractstracking
Updated Feb 2026↓ Download
PowerShellv1.2.0

User Onboarding Audit

PowerShell script that audits onboarding task completion for new hires across Active Directory and HR systems. Flags gaps and sends a summary to the manager.

powershellonboardingaudithr
Updated Feb 2026↓ Download
Pythonv1.1.0

Weekly KPI Digest

Python script that compiles KPI snapshots from multiple CSV sources into a single formatted report. Outputs HTML email or plain-text summary.

pythonreportingmetricsemail
Updated Feb 2026↓ Download
Templatesv1.0.0

Vendor Renewal Checklist

Template to track renewal milestones and risk review steps.

templatesprocurement
Updated Feb 2026↓ Download