The database and report were subsequently designed in Excel to produce a user-friendly interface that the trust could continue working with.
Under the supervision of the volunteer analyst, the trust started adding new invoices to the database, also including a new item that was recently added to the portfolio of items gifted by the trust (“Holdall” bags).
The solution to the Harvey Hext Trust’s problem was twofold:
- A database in the form of an Excel
- A report in Excel, including summary tables and charts that refresh dynamically as the database is updated.
The Harvey Hext Trust used this project as the kick-off for a more structured data collection process as their activities expand. Their achievements and impact are now transparent and quantified, and they can be incorporated in grant applications, website content and general communication activities. Additionally, gaps in their current geographic coverage can be identified and proactively tackled.
For more information about Pro Bono OR, please contact [email protected]. We want to hear from you if you’re interested in volunteering, or if you have a charity in mind for a Pro Bono OR project.