The excel file value-add-analysis.xlsx
can be used to derive quantitative analysis on any use case from: buying a car, selecting a new job, who on your team to give promotion/bonus/raise, etc.
- Download the
value-add-analysis.xlsx
- Replace "Categories" of your own evaulation critieria as seen in "Column A".
- Change the "weight" of each of your categories so totals to 100% in "Column B".
- Change the "Choice" to your choices (e.g., Tesla vs Hummer)
- Change the 1-10 score for each choice by evaluation criteria.
- Evaluate the "Weighted Total" and make your choice based on the highest number.