Menu
Build, maintain, generate fake test data for, and distribute the Example Workplace Attendance Tracker Excel/VBA tool. Use when asked about the attendance tracker, generating fake workplace data, fixing tracker issues, or creating center-specific templates.
Build Raycast extensions using the Raycast API: commands, list views, forms, and preferences. Triggers on: Raycast, @raycast/api, raycast extension, raycast command, showToast, List.Item, Action.
Drizzle ORM type-safe SQL queries, schema definition, migrations, and Supabase/Postgres integration. Triggers on: drizzle-orm, drizzle, pgTable, mysqlTable, eq(), and(), drizzle migrate, drizzle-kit, schema.ts drizzle.
Use Nix and NixOS for fully reproducible development environments, CI pipelines, and deployments. Covers flake-based project setup, devShells, Nix overlays, home-manager, NixOS configuration, and building Docker images with Nix for bit-reproducible containers.
Atlantis — automated Terraform/OpenTofu pull request workflow with plan and apply via PR comments. Use this skill whenever the user needs to automate Terraform plan/apply on PRs, enforce code review before infrastructure changes, set up GitOps for infrastructure, configure Atlantis server with repo-level workflow overrides, or prevent unapproved Terraform applies. Trigger for "atlantis terraform", "atlantis plan", "atlantis apply", "terraform pr automation", "infrastructure gitops atlantis", or "terraform code review workflow".
HashiCorp Boundary — identity-based secure remote access without VPN or bastion hosts. Use this skill whenever the user needs to provide SSH/RDP/database access to engineers without exposing infrastructure, replace bastion hosts with identity-aware access, set up just-in-time access with Vault-brokered credentials, configure Boundary targets and host catalogs, or integrate with SSO for infrastructure access. Trigger for "boundary access", "hashicorp boundary", "replace bastion host", "just-in-time access", "boundary targets", or "identity-based ssh access".
HashiCorp Vault — secrets management, encryption as a service, and dynamic credentials. Use this skill whenever the user needs to store and retrieve secrets, generate dynamic database credentials, issue short-lived certificates (PKI), set up Kubernetes auth for pod secret access, configure Vault policies, or implement secrets rotation. Trigger for "vault secrets", "vault kv", "vault dynamic credentials", "vault pki", "vault kubernetes auth", "hashicorp vault", or "secrets management vault".
| name | example-workplace-attendance-tracker |
| description | Build, maintain, generate fake test data for, and distribute the Example Workplace Attendance Tracker Excel/VBA tool. Use when asked about the attendance tracker, generating fake workplace data, fixing tracker issues, or creating center-specific templates. |
| type | domain |
| tags | ["workplace","excel","vba","attendance","hr-tools","operations"] |
The Example Workplace Attendance Tracker is an Excel .xlsm workbook with a VBA engine that classifies employee attendance across three source reports and routes results into five output tabs. It supports multiple Example Workplace plasma donation centers.
| File | Location | Purpose |
|---|---|---|
AttendanceEngine_v4_VBA.bas | /Users/localuser/Downloads/example-files/ | Full VBA source (~2100+ lines) |
generate_year_data.py | same | Multi-center fake data generator |
create_blank_template.py | same | Strips data → distributable template |
fake_data_gen.py | same | Single-week QA + fuzz tester |
fake_year_data/ | same | 12-month fake data (stlouis/, chicago/) |
RunAttendanceCheck — main engine, reads all 3 RAW tabs
ImportChangesFile — file picker → RAW_Changes
ImportTAFWFile — file picker → RAW_TAFW
ImportPunchesFile — file picker → RAW_Punches (CSV or XLSX)
ImportAllFiles — prompts for all 3 in sequence
SetupNewCenter — wizard: center name + tardy threshold
SetupControlPanel — rebuilds Control Panel with buttons
RefreshControlPanel — writes live stats to Control Panel rows 5-11
ExportSummaryReport — exports Control Panel + Action Req as PDF
QueueForPowerAutomate — adds selected rows to PA Export Queue
PopulateEmployeeMaster— pre-loads 16 Saint Louis LMO staff
The tracker works for ANY center by changing Config B4.
InStr("Chicago, IL", "") returns 1 in VBA, so a blank center name passes all rows.
# Available centers: stlouis, chicago, dallas, denver
python3 generate_year_data.py --center chicago
python3 generate_year_data.py --center dallas
python3 generate_year_data.py --center stlouis # default
# Custom output directory
python3 generate_year_data.py --center chicago /tmp/chicago_data
python3 create_blank_template.py LMO_Attendance_Tracker_v5.4.xlsm
# → Example Workplace_Attendance_Tracker_TEMPLATE.xlsm (VBA intact, all data cleared)
python3 fake_data_gen.py --mode quick # 2-min fuzz + inject into workbook
python3 fake_data_gen.py --mode fuzz --minutes 60 # 60-min stress test
python3 fake_data_gen.py --mode inject # inject current fake data into workbook
AttendanceEngine_v4_VBA.bas — focus on RunAttendanceCheck (main loop) and the rule chain starting around line 497SimClassify function (pure-logic mirror of the same chain — used by QA)fake_data_gen.py --mode quick to verify fixAdd to the CENTERS dict in generate_year_data.py:
"newcenter": {
"name": "Phoenix, AZ",
"seed": 20241201, # unique seed for reproducibility
"managers": ["Manager, Name", ...],
"staff": [
("505XXXXX", "LastName, First", "ROLE", "H:MMAM - H:MMPM", [weekdays], tardy_mult),
... # 15 employees typical
],
},
Open the workbook, press Alt+F11, run SetupControlPanel in the Immediate Window, or assign it to a temporary button.
python3 create_blank_template.py <current_tracker.xlsm>Example Workplace_Attendance_Tracker_TEMPLATE.xlsmInStr("anything", "") = 1 in VBA — blank center name safely passes all rowskeep_vba=True required when opening .xlsm files to preserve macrostardy_mult personality multiplier scales probability per employeeRefreshControlPanel — col B = label, col C = valueDirections should be a separate attachment (not embedded in the workbook).
Use WriteDirections VBA sub to generate a formatted "Directions" sheet in the workbook,
or export it as PDF via ExportSummaryReport.