Originally Posted by Saskwatchian
Good start on the table, but your "total" section is not taking all factors into consideration.
I would consider adding a "weight" row to the chart to use as a modifier. That way a 10 for looks won't necessarily have the same weight as a 10 for reliability, or purchase cost. You choose what's important.
To factor in vehicle costs you can use a index function in a hidden column that will be worked into the total. You could use something like this:
=INDEX({10,9,8,7,6,5,4,3,2,1},MATCH(A2,{1,2000,400 0,6000,8000,10000,12000,14000,16000,18000},1))
The same thing can be used for MPG, running costs in $/10000 km, etc.
|