Now you got your requirement list based on your Heart & Mind. Now list all the requirements in the Excel as per the below pic.
Now the Maths begins.....
Rate your requirement on scale as 1,3,6 & 9.
9 - Very Much Important
6 - It's Important
3 - Less Important
1 - Not cared at all in column B
Now list all models preferred models by you and its competitor (like Car 1, Car 2, Car 3…) Now rate the car along with its particular variant against your requirement in column C. Then Calculate the DMN (Decision Making Number).
DMN = your requirement rating x Car rated by against the requirement (DMN D3 = B3*C3).
Its little bit TDS to divide the Rating. I will explain how to make the rating. In Budget:
My budget is say Rs 9 lacs
9 – well within your budget (within 9 lacs)
6 – Budget exceeds by 10% (9.1 to 9.9 Lacs)
3 – Budget exceeds by 20% (10.0 to 10.8 Lacs)
1 – Budget exceeds by more than 20%.(More than 10.8 lacs) Airbag:
My requirement is Driver & co-Driver Airbags.
9 – Driver, Co-Driver & Side Airbags (Fully Loaded Safety Feature)
6 – Driver & co-Driver Airbags available
3 – Only driver Airbag
1 – No Air bag Fuel Efficiency:
Like budget you can fix target. It is always better to consider ARAI for rating purpose. Because ARAI is inspected at standard condition for all cars. City & HW rating can be given based o Ownership reviews, Car reviews, Website reference, Auto magazines.
Pls find the link How ARAI is checked. ARAI Mileage Test Procedure Doesn't Show Real World Fuel Efficiency | MotorBeam – Indian Car Bike News & Reviews
So like this fix rating for each requirement on your list. In general
9 – Exceeding your requirement
6 – Satisfying your requirement
3 – barely meeting your requirement
1 – Not meeting at all.
Calculate DMN by adding all ratings. D18=Sum(D3:D17) for Mind requirement DMN.
Now Calculate Heart Requirement DMN for selected car with selected variant. And calculate the Mind requirement DMN. Repeat rating for all your preferred cars & competitor cars.
Now Look who scores more DMN in Mind & Heart. Finally now you have found your Car with its variant.
Based on this calculation, I will select Car 1 with variant B
Now you can doubly sure that you selected a perfect car for you. For doing this entire activity “research”
is very important.
And all those information you can get from TAI
. Once you made decision based on this, nobody can disturb you, No regrets in future too.
Still if you find difficult, write to me.