Grant Seeking by the Numbers: Funder Research, Fit Scores, Pipeline Value, Deadlines & Reporting Calendars

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Score eight fictional funders on four weighted criteria, rank them and count how many pass both shortlist rules – the list you will actually write to.
• Size each ask as the smallest of the unfunded gap, the funder's maximum and a multiple of its typical award, round it down to a clean figure, name the limit that binds and show what share of the project it covers.
• Give every open opportunity a probability from its stage, calculate its weighted value, total the asks per stage and the weighted pipeline, and see how much of the headline total you can realistically expect.
• Set an internal draft deadline ten working days before each submission, flag every deadline as Overdue, Soon or OK, count the deadlines in the next 30 days and let a formula name the funder whose deadline comes next.
• Measure three years of application history: the share of the requested money actually won per funder type, the average award when a foundation says yes and how often large asks succeed.
• Split next year's programme income into confirmed and weighted pending money, work out the gap that is still open and translate the expected funding into months of programme covered.
• Measure how dependent Brightwater is on a few funders with the share of the largest three and a concentration index, and set the renewal application date for every multi-year grant with EDATE.
• Turn award dates and reporting cycles into due dates with EDATE, set the final report date after a grant ends, total the weighted pipeline for the dashboard and chart the asks by stage.