how do i set up a weighted factor model in excel?

[Guest]

I am trying to do a worksheet for project management. I have to set up a
weighted factor model and wanted to do it in excel. How would I set up the
formulas?

 

[bplumhoff]

Hi,

One possible solution (example in German but macro-free):
http://www.pulrisk.de/excel-beispiel/Nutzwertanalyse_XP.xls

HTH,
Bernd