Hello Excel guru's! I have been tasked with a project that is above my comprehension of Excel and was hoping for some assistance. So, attached is a spreadsheet that includes a key and on the (Orange) tabs are examples I pulled from the internet based on the fact it is Prioritizing. The (Green) tabs are the "actual" categories that I need the formula for. The (Red) tab is a key to how the information is being weighted and used. I really do not know what else to put here or expand on as I really am lost in this.

Thanks to anyone who can offer some insight PrioritizationTemplate1.xlsx