Combination of Assessment for a final score

Hi,

I need help with the following query that I have.


Problem Background:
A student is appearing for an exam. He has to appear for 5 (A, B, C, D & E) subjects. The 5 subjects have a different weightage totalling up to 100%. An examiner can assess the student on these subject on a rating scale of 0-100% (in multiples of 10 only).

Problem Statement:
I need to find out how many different ways are there to assess a student from 0% to 100% & what are those.
For example (please refer the attachment), there is only one way to assess the student at 100% which is assessing him at 100% in all the 5 subjects. Similarly there is only one way in which he can assess the student at 99% i.e. giving 100% in first 4 subject & giving 90% in the last subject. For 98% there are 2 options, 100% for 1st 4 subject & 80% for the last one or 90% for subject C & 100% for the rest. For 97% there can be 3 combination....

Any help that anyone can offer in finding out the assessment combination for each % point in excel 2007 would be highly appreciated.

Thanks,
Vinod

Hi
Use solver to get combination

see attached sheet

Fix one subject points to get other combination
It is in the tools menu (Excel 2003)
If not install it as It is not installed by default

Regards

Thanks Mahju, this helps partially. What I was looking at is a way in which I can get all the possible combination of assessment for a final score of 1 to 100% without actually running the program for each % point.
Regards,
Vinod

Hi
I have created a macro to do your task

See attached sheet

Regards