← All prompts

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

The prompt

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 and say nothing about my portfolio.

Open in ChatGPTOpen in Claude
Was this prompt useful?
Suggest an edit

If something is wrong or the wording isn't how your office talks, tell us here. An edit we accept becomes a new version of this prompt.

Find another task