The 9/21 Founding Campaign$921 by 9/21Contribute →
← Back to Work

Systems & Operations

Civic Heart

Systems & OperationsW-2 Employment

A brand that resonates. Grant reporting that runs itself.

Civic Heart

Context

Led a visual refresh including a fresh look and event photography — captured events for use in marketing and collateral. Also built an Excel VBA Macro system that dynamically generates Time & Effort sheets based on employee grant selections, with a description generator for repeated entries, automated PDF/Excel export with auto-naming, and comprehensive training materials.

What We Built

4 Deliverables

Brand Identity Refresh

Branding

Brand Identity Refresh

A fresh visual look plus event photography — captured events for use in marketing and collateral.

Time & Effort Reporting - Dynamic Sheet Generator

Automation

Time & Effort Reporting - Dynamic Sheet Generator

VBA-powered system that creates Time & Effort sheets based on # of grants and grant selection — no more manual updates when grants change.

Time & Effort Reporting - Description Generator

Automation

Time & Effort Reporting - Description Generator

Save and import repeated effort descriptions across pay periods. No more retyping the same entries.

Time & Effort Reporting - Training Materials

Training

Time & Effort Reporting - Training Materials

Comprehensive documentation and micro-trainings that moved 50 staff to 100% on-time submission in two pay cycles.

What would stronger systems do for your mission?

Every partnership starts with a Clarity Call. Let's talk about what you're building.