Grant Seeking by the Numbers: Funder Research, Fit Scores, Pipeline Value, Deadlines & Reporting Calendars
Find the right funders, size your asks, weight your pipeline and never miss a deadline or report, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
You run the grant seeking of a fictional literacy charity, one checked formula at a time. You score funders with weighted criteria and SUMPRODUCT, rank them and build a shortlist. You size each ask from the unfunded gap, the funder maximum and the typical award, then weight the pipeline by stage probabilities. You set internal draft dates with WORKDAY, flag deadlines with IFS and find the next one. Then you measure amount-won rates and average awards, close the funding gap in months covered, check funder concentration and renewal dates with EDATE, and build a reporting calendar with a pipeline chart.
Lessons
- Funder Research: Weighted Fit Scores, Ranking & the Shortlist Pro
- Sizing the Ask: Gap, Funder Maximum and the Typical Award Pro
- The Grant Pipeline: Stages, Probabilities and Weighted Value Pro
- The Deadline Calendar: Internal Draft Dates, Days Left & Flags Pro
- Success Rates: Amount Won by Funder Type, Average Awards & Large Asks Pro
- The Funding Gap: Confirmed, Weighted Pending and Months Covered Pro
- Funder Concentration & Renewals: Top-3 Share, Concentration Index and Renewal Dates Pro
- Reporting Calendar & Dashboard: Report Due Dates, Final Reports and the Pipeline Chart Pro