Hi,
I am building out a ranking of companies to try to establish their interest in donating to my nonprofit. The variables include Strong/Average/Weak connections to my organization (30%), the amount they have donated to us in the past (30%), the amount of giving to our general field (20%), and whether or not they've given to groups with our specific cause (20%). I want to formalize these into a template so that my coworkers can use it in the future, but I can't figure out how to fully automate the results.
For the moment I have just ranked the amount donated to us relative to the other companies in the chart, but then I have to divide each number by a specific amount to make the maximum value worth 3 points. Is there a way to do this so that the value automatically calculates the highest number to the specified value (in this case 3 or 2) and then adjusts the rest relative to that? Or something more elegant than that.
Bookmarks