Built a new automated Grants Management system

Project Type: Data consultant

Client: Multi-service organization in Brooklyn

Key project goal: Support the Grants Manager in building automated tracking of all grants in the organization’s ecosystem.

Project duration: 3 months

Arensa Consulting helped the Grants Manger automate all grants reporting and unlock reporting/tracking flexibility all within Google Sheets. By speaking with the Grants Manager and learning the variables and intricacies of different grant statuses, configurations, and scenarios, we helped them build a holistic tracking system in Google Sheets that automated all required Grant Reporting and unlocked real-time visibility into funding horizons.

Project Impact: The Grants Manager increased their productivity by 80% and shifted the saved time in the week towards identifying new grants and expanding the revenue footprint of the organization.