I was browsing your BOTEC and wonder if I’ve found a bug or two in sheet 3 (but it’s possible I’m not understanding something about your methodology, I only took a quick look / haven’t read this post in detail).
On sheet 3, I think the weights are meant to basically represent how much money is being spent in each org + category, relative to the smallest org you look at? (W. M. Keck Foundation).
But it looks like you’re not dividing the total weight per org by the number of focus areas that org has. So i.e. here I think here the weights for Wellcome > AMR should be =round(223.45 / 5), since you list 5 focus areas for Wellcome on sheet 1. I might be misunderstanding something here (only took a cursory check).
Also it looks like you’re missing the Therapeutics category for Wellcome + Lab Readiness for Rockefeller, I think? (Maybe some others too).
I tried fixing this by making some changes (highlighted in green) here, mostly in sheet 3 (starting col L) and a bit in sheet 1. Happy to give you edit access if you request it.
Also sorry if this is too nitpicky, I just like auditing spreadsheets :) Thanks for publishing this!
This is interesting, thanks for sharing! :)
I was browsing your BOTEC and wonder if I’ve found a bug or two in sheet 3 (but it’s possible I’m not understanding something about your methodology, I only took a quick look / haven’t read this post in detail).
On sheet 3, I think the weights are meant to basically represent how much money is being spent in each org + category, relative to the smallest org you look at? (W. M. Keck Foundation).
But it looks like you’re not dividing the total weight per org by the number of focus areas that org has. So i.e. here I think here the weights for Wellcome > AMR should be =round(223.45 / 5), since you list 5 focus areas for Wellcome on sheet 1. I might be misunderstanding something here (only took a cursory check).
Also it looks like you’re missing the Therapeutics category for Wellcome + Lab Readiness for Rockefeller, I think? (Maybe some others too).
I tried fixing this by making some changes (highlighted in green) here, mostly in sheet 3 (starting col L) and a bit in sheet 1. Happy to give you edit access if you request it.
Also sorry if this is too nitpicky, I just like auditing spreadsheets :) Thanks for publishing this!
Really appreciate you picking this up! Edit access would be great—I’ve sent a request and will then incorporate the necessary fixes.
Granted :)