AI-Assisted Review and Streamlining of a Programme Metrics Workbook
United Nations Volunteers (UNV) · UN agency
- Programme & Project Management
- United States of America
- Remote
The NBSAP Accelerator Partnership tracks country requests for technical and financial support in a digital platform. This data is imported into a Google Sheets workbook that calculates the figures used for donor reporting, public dashboards and internal analysis. As the partnership has grown, the workbook has accumulated legacy tabs, unused columns and formulas that depend on the position of columns. This makes the workbook harder to maintain and adapt. To this end, we are looking for one Online Volunteer to use AI tools to analyse the workbook's structure and formulas, and to design and test a streamlined version that produces identical results. This opportunity will give you a chance to contribute to a global biodiversity effort, gain experience in data architecture and spreadsheet design, and apply AI tools to a real analytical problem.
We are seeking an online volunteer to analyse and streamline the workbook. Working in a copy provided by the project team, the volunteer will be responsible for the following tasks:
1. Reviewing the current data streams
2. Mapping the workbook. The workbook currently contains 32 tabs: four tabs of imported data, 22 calculation and reporting tabs, four documentation tabs and two archived tabs.:
- how formulas depend on the imported data and on each other,
- tabs, columns and formulas that are unused or no longer needed, and
- documents and tools outside the workbook that draw on its data.
2. Proposing a streamlined structure that removes legacy elements and replaces column-position references with column-header references.
Proposed changes are to be sorted into two groups:
- changes that can be verified by testing, such as removing columns that feed no other formula and switching to column-header references, which may proceed without prior approval, and
- changes that require a decision by the project team, such as removing tabs that may still be in use, which are to be listed with supporting evidence for review.
3. Building the first group of changes, and any approved changes from the second group, in the copy, using AI tools to analyse, explain and rewrite formulas.
4. Reconciling results to confirm that every reporting figure in the streamlined copy matches the current workbook using the same data, and documenting and resolving any discrepancies.
5. Documenting the work, including a dependency map, a change log of what was removed, merged or rewritten and why, and a short maintenance guide for the new structure.
6. Attending meetings and training with the project team to discuss progress, exchange information and receive guidance.
AI tools are to be used in line with the data handling guidance provided by the project team at onboarding. The assignment runs from 1 December 2026 to 16 January 2027. Weekly hours may vary across the assignment by agreement with the project team. All deliverables are due by 16 January 2027 and will be reviewed at a handover meeting with the project team.
- UNDP Global Programme on Nature for Development
- -