I need to develop an EFAS table

G

Gary's Student

Just use the first 4 columns:
Factor
Weight
Rating
Weighted Score

Format the printout to look reasonable and add a small section explaining
the weighting
 
L

Leandra

Okay, Got that Thank you so much
I should have been more specific, I need help with the formulas, I'm not all
that great in Excel and the simple addition takes time for me. Would you be
able to help me with that/
Many Thanks,
Leandra
 
G

Gary's Student

You need to define the criteria for weight and rating. The weighted score
could be the product of these two factors. For example if weighted score is
in column D, the formula would be
=C1*B1

A really good source of information on using Excel to model busines
situations is:

Microsoft Excel Data Analysis and Business Modeling
by Wayne L. Winston

It might be available, used, at your local university bookstore
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incone & Expenses Statement 0
Query Question / 4
Creating a Chart on form from selected data in query. 0
Invoicing and customer database 0
List ConnectionString of linked, external Excel file 2
Macro to count words in a section, excluding footnotes and end notes 1
Repeated Requests for GSuite password when first Accessing Outlook 365 after system start 0
2010 - Setting Progress Line to Baseline in Tacking Gantt 0

Top