An example of sensitivity analysis- Need Help

Hello,

I want to check the sensitivity of my proposed model. But i can't build my model on my mind to excel.

In the attached file

to find positive and negative solutions, co-co multiplied by product.

But I want to check the effect of criteria. To check it for C1 row, weight column rows' added and results is coming iteratively row by row.

For example

for c1, weights are iteratively inserted. firstly, .79 .46 .18 then .12 .82 .24... and it's going like this. After this positive and negative solutions is changing. And the ranks must be kept.

For every weight the algorithm runs same.

How can I do this? Can anyone give me some hints?

I don't understand your algorithm at all. the only formulas I see are the formulas in N5:O11 that compute the average of the previous columns and rank those averages (I would note that your 1/6*sum() function seems like it should be the equivalent of =AVERAGE()).

If I were performing this analysis, I would probably start in Q14. Enter formulas to perform the analysis across the row -- make sure all computations occur in row 14. If you pay proper attention to relative and absolute references, once you have the analysis programed into Q14:BQ14 (or however many cells it takes), then you can copy row 14 and paste into rows 15:25 and perform the same analysis for all 12 weight combinations. Highlight your desired "final" result cells and evaluate from there.

I'm not sure if I can clarify without a better understanding of your algorithm.

Perhaps this example will help: https://www.excelforum.com/tips-and-...l-problem.html This spreadsheet simulates the Monty Hall problem. If you look at how I structured the spreadsheet, you can see that all of the calculations, lookups, arithmetic, etc. for each scenario is spread across a single row, then copied down to perform the same calculation on other scenarios. Then, at the top of the spreadsheet, I have my summary calculations where I count wins and losses. That is the kind of overall spreadsheet structure I would probably use for your sensitivity analysis. Put your arithmetic and rank analysis in single rows to the right of the weight factors, then copy down.