The second annual "Ugliest" Grant Tracking Spreadsheet Contest received some truly impressive responses. Entries were judged based on a number of criteria that make grant tracking spreadsheets difficult to work with, including their complexity, susceptibility to error, duplication of information, and reliance on one person’s specific knowledge to navigate.
Without further ado, the winner is…StreetLightUSA!
StreetLightUSA is a nonprofit that helps adolescent girls transition from trauma to triumph by helping them get out of the sex trade.
StreetLightUSA will receive one year of free access to the PhilanTrack online grants management system to replace their "ugly" grant tracking spreadsheets with an online system that will help the organization streamline all of its grant-related activities.
There were a number of compelling submissions in this year's contest. Grantseekers are using Excel to manage everything from contact information to proposal status, and more.
Here are some of our favorites (note: some images have been modified slightly to minimize any identifying information):
In addition to some very illustrative visuals of challenging spreadsheets, there was one particularly impressive and detailed description of a grant tracking database (selection from the description included here):
ABOUT THE DATABASE TAB ORANGE field heading text means the column cells contain a function. A GREEN triangle in the upper left corner of a cell means there is a function in it that Excel thinks may be faulty. This is not the case, everything works fine. Ignore them. A RED triangle in the upper right corner of a field heading means there is a comment about the field there. Hover your cursor over the cell to see the comment. BLUE field heading text means the column is for the current year. Similar columns from past years are present, but hidden. Organization names in RED are ones of particular interest for research. A KEY to coded fields is in a sheet behind the Database. COLUMN / NAME / NOTES A / Organization Name / No organizations begin with "The". If there are people's name(s) in the organization title, the listing is by last name. Organizations may appear >once if there are >1 separate potential grants (see column B). B / Grant Name / The particular grant of interest given by the organization. C / Grant Range / Minimum and maximum theoretical amounts disbursed. D / Challenge Grant / Whether it is a challenge grant, yes or no. E / Match Grant / What matching ratio is required by the grant (usually X:1, grantor:X) F / Grantor Status / Whether it is a current, past, or future funder. See Key.
And it goes on. It includes at key at the end (edited slightly to minimize identifying information):
KEY TAB A / Grantor Status / C = Current, F = Future, P = Past B / FY Codes / 0 = Did not apply, 1 = Applied and pending, 2 = Applied and awarded, 3 = Applied and denied, C / Programs, / D / App Codes / FP = Full Proposal, LOI = Letter of Inquiry, NOM = Nomination, PP = Pre-Proposal E / App Formats / EM = Email, OL = Online, PC = Phone Call, SM = Snail Mail
Is your organization using an "ugly" grant tracking spreadsheet? Request a free online demonstration to learn how PhilanTrack can replace the spreadsheet and help your organization streamline its grantseeking efforts.