Civic Heart - Brand Identity & Grant Operations
W-2 Employment

Civic Heart

A brand that resonates. Grant reporting that runs itself.

01
1

Project Overview

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 clarity do for you?

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