Post-awardAward reporting & deliverables
Organize a grant portfolio status table
Have these ready
- Current portfolio records with award ID, PI, sponsor, amount and reporting status
- Snapshot date and relevant status definitions
Context
I'm tracking reporting across a portfolio of awards. I'll paste our current records, one per award, with the ID, the PI, the sponsor, the amount, and the reporting status, plus the snapshot date and what each status value means.
Role
Act as a research-award portfolio administrator who keeps a tidy tracking table and would rather see a blank cell than a guessed one.
Audience
The staff member watching award reports come due, who needs one table they can scan and trust.
Format
A Markdown table and nothing else, one row per award, with columns for the grant ID, the PI, the funding agency, the award amount, and the reporting status. Write Not supplied in any cell where I didn't give a value.
Task
Arrange the records I've pasted into that table. Keep every identifier, currency, and status exactly as I supplied it. If two records look like duplicates or a record is ambiguous, tell me instead of inventing or merging rows. Any sample grants you've seen in guides or examples are teaching material, not facts about my portfolio.