Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.

I think you will need to describe your layout to us (what data is in what columns and/or rows).

--
Rick (MVP - Excel)


"CelticCharmer" wrote in message ...
Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.

Specifically how do you determine what percentage each element is worth of
the whole? If there are two elements do they automatically get 50% each or
can one be worth 25% the other 75%?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CelticCharmer" wrote:

Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.

Hi and thank you both for your replies.

From cell H8 to BW7 (68 elements) I input dates as they complete each
element (21/01/09)
Students do not do all 68 elements this ranges from 28 to 34 elements this
will be the 100%.
I want to put in the progression percentage in cell BX8 so I show how much
is completed out of 100%

The cells I use range from H7 to BW7 as you can see I dont use them all and
it depends which elements the student use.
Student 1 = I input dates (over a six month span) into cells H7 to K7, L7 to
O7, V7 to Y7, Z7 to AC7, AH7 to AK7, AP7 to AS7 and BN7 to BQ7. Thats 28
cells which will equal 100%.
I want to see what percentage has been completed in cell BX7.
I hope this makes it easier for you
Celtic charmer




"Shane Devenshire" wrote:

Specifically how do you determine what percentage each element is worth of
the whole? If there are two elements do they automatically get 50% each or
can one be worth 25% the other 75%?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CelticCharmer" wrote:

Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.

If the number of elements a student completes can vary between 28 and 34, do you know **in advance** which number of elements they will ultimately complete? If not, then there is no way to give a meaningful percentage progress report. What would you divide by to get that percent... 28, 29, 30, 31, 32, 33 or 34? The problem, for example, when a student has completed 27 elements, they are 96.4% complete if they will be doing 28 elements, but only 79.4% complete if they will be doing 34 elements. On the other hand, if you do know what the ultimate number of elements they will complete are, then what column is that value located at in?

--
Rick (MVP - Excel)


"CelticCharmer" wrote in message ...
Hi and thank you both for your replies.

From cell H8 to BW7 (68 elements) I input dates as they complete each
element (21/01/09)
Students do not do all 68 elements this ranges from 28 to 34 elements this
will be the 100%.
I want to put in the progression percentage in cell BX8 so I show how much
is completed out of 100%

The cells I use range from H7 to BW7 as you can see I dont use them all and
it depends which elements the student use.
Student 1 = I input dates (over a six month span) into cells H7 to K7, L7 to
O7, V7 to Y7, Z7 to AC7, AH7 to AK7, AP7 to AS7 and BN7 to BQ7. Thats 28
cells which will equal 100%.
I want to see what percentage has been completed in cell BX7.
I hope this makes it easier for you
Celtic charmer




"Shane Devenshire" wrote:

Specifically how do you determine what percentage each element is worth of
the whole? If there are two elements do they automatically get 50% each or
can one be worth 25% the other 75%?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CelticCharmer" wrote:

Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.

Hi,
The student tells me at the start what elements they will do. The example I
gave is the most common elements they pick and it's the cell numbers I also
use.
The cells I use range from H7 to BW7 as you can see I dont use them all and
it depends which elements the student use.
Student 1 = I input dates (over a six month span) into cells H7 to K7, L7 to
O7, V7 to Y7, Z7 to AC7, AH7 to AK7, AP7 to AS7 and BN7 to BQ7. Thats 28
cells which will equal 100%.
I want to see what percentage has been completed in cell BX7.
Is there a way you can see what I am working on? If thats any help.
Thank you for your time
Celtic Charmer.


"Rick Rothstein" wrote:

If the number of elements a student completes can vary between 28 and 34, do you know **in advance** which number of elements they will ultimately complete? If not, then there is no way to give a meaningful percentage progress report. What would you divide by to get that percent... 28, 29, 30, 31, 32, 33 or 34? The problem, for example, when a student has completed 27 elements, they are 96.4% complete if they will be doing 28 elements, but only 79.4% complete if they will be doing 34 elements. On the other hand, if you do know what the ultimate number of elements they will complete are, then what column is that value located at in?

--
Rick (MVP - Excel)


"CelticCharmer" wrote in message ...
Hi and thank you both for your replies.

From cell H8 to BW7 (68 elements) I input dates as they complete each
element (21/01/09)
Students do not do all 68 elements this ranges from 28 to 34 elements this
will be the 100%.
I want to put in the progression percentage in cell BX8 so I show how much
is completed out of 100%

The cells I use range from H7 to BW7 as you can see I dont use them all and
it depends which elements the student use.
Student 1 = I input dates (over a six month span) into cells H7 to K7, L7 to
O7, V7 to Y7, Z7 to AC7, AH7 to AK7, AP7 to AS7 and BN7 to BQ7. Thats 28
cells which will equal 100%.
I want to see what percentage has been completed in cell BX7.
I hope this makes it easier for you
Celtic charmer




"Shane Devenshire" wrote:

Specifically how do you determine what percentage each element is worth of
the whole? If there are two elements do they automatically get 50% each or
can one be worth 25% the other 75%?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CelticCharmer" wrote:

Hi,
I was wondering if you could help me out. I train students and when a
student completes an element of their course work I input a completed date
into a cell. What I want to do is as soon as I input the completed date I
want excel to work out the percentage as they complete the course e.g. 6%,
15%, 75%, etc until they are finished 100%.
The amount of elements the students do changes from student to student from
28 to 34. What formula I can use? Do I have to change the formula from
student to student to get 100%?
If you need any more information please ask.

The student tells me at the start what elements they will do.

And where is that information encoded at on the worksheet? I need either the count of those elements or an indicator of some kind for the elements each student plans to do so I can count them. In order to get a percent complete, you have to divide by that count and you haven't told us, yet, how to read that count from your worksheet.

--
Rick (MVP - Excel)