Develop MS excel sheet to support multiple decision criteria analysis
Budget: $10 – $30 AUD
I have an excel sheet with some decision criteria I want to use to help select a property. My requirements are as follows
1. I would like to enter details easily about multiple properties into the spreadsheet using a form / data validation and then excel helps to calculate the total score for each property based on criteria provided.
2. I would also like to be able to present the results in a table or similar which lists houses by total score and permits further analysis e.g. pivot table
3. I would like to be able to edit the existing criteria if required (e.g. adjust weighting or add additional criteria)
I use Excel for Mac (current version)
I have provided the spreadsheet with the criteria + one example entry.
1. I would like to enter details easily about multiple properties into the spreadsheet using a form / data validation and then excel helps to calculate the total score for each property based on criteria provided.
2. I would also like to be able to present the results in a table or similar which lists houses by total score and permits further analysis e.g. pivot table
3. I would like to be able to edit the existing criteria if required (e.g. adjust weighting or add additional criteria)
I use Excel for Mac (current version)
I have provided the spreadsheet with the criteria + one example entry.