Hi Rick
yes I can add more columns at the end which will be bx8 onwards as many as
you think I need. Student a is row 8 and not 7 as I have stated sorry.

"Rick Rothstein" wrote:

Having the elements the student plans to do in a location other than the
worksheet (namely, the student's folder) does not help (I can't write a
formula to look into that folder<g). Can you add a column to your worksheet
and put the total number of elements the student plans to do in it? If so, I
should be able to give you the formula for the percentage complete that you
want; if you can't add this column, the you will not be able to do what you
want.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in message
...
Hi Rick.
well as i Have them in my work sheet already all 68 elements of them. I
know
the elements the student is doing via his/her learning plan in their
folder,
which we do at the start of the course. I then fill them in as the student
completes each element.
I put a X into the cells(elements) they are NOT doing and that leaves
blanks
where I will input the dates as they are completed.

"Rick Rothstein" wrote:

Then I need to ask again... how do you know in advance (that means,
BEFORE
they complete ALL of the elements they intend to do) BY LOOKING AT YOUR
WORKSHEET how many elements the student told you they were going to do? I
repeat... in order to calculate the percentage that you want, you MUST
know
the number of elements the student will ultimately do so you can divide
by
it. If that number is not on your worksheet, or cannot be counted in some
way BEFORE the student completes ALL of his/her elements, then you cannot
get the percentage complete figure you asked for.

Perhaps if I state my question in a different way, you will see what I am
looking for. Pretend its the beginning of the school year. You ask your
students how many elements they plan to do. The next day (second day of
the
school year), I come up to you while you are looking at the worksheet and
ask... how many elements did "Student A" tell you they were going to do?
What would you tell me? Assuming you give me a number... where did you
get
that number from? That number is what I need to know in order to
calculate
the percentage complete.

--
Rick (MVP - Excel)


"CelticCharmer" wrote in
message
...
Hi Rick,
I put the dates in as the student completes each element in the same
row
as
the student is on.

"Rick Rothstein" wrote:

Do you put those dates into the cells when the student tells you what
elements he/she is going to do (sort of like target dates) and then do
you
put the actual completion dates in a different row as the student
completes
the element?

--
Rick (MVP - Excel)


"CelticCharmer" wrote in
message
...
Hi Rick
I have all possible elements on my excel sheet from cell columns h6
to
bw6.
Then the students names go into the cell rows numbers 7, 8, etc...
So
the
first date input for student 1 will be made in cell h7 and the last
possible
input will be in cell bw7
I have to have all 68 possible elements because some students may
want
to
different ones.
Maybe I'm trying the impossible?
Thanks for you time,
Celtic Charmer


"Rick Rothstein" wrote:

I know from day one what elements the student will be doing
because they tell me.

And my question is... after they tell you how many elements they
will
be
doing at day one, do you put that information into your worksheet
anywhere?
If so, tell me where. If not, you will have to; otherwise, you will
never
be
able to divide by the correct number in order to get a meaningful
percentage
complete. You can't just use 28 as the divisor for all
situations...
if
the
actually are going to do 34 elements, then when they complete 29 of
them,
using 28 as the divisor would generate a completion percentage of
more
than
100%.

--
Rick (MVP - Excel)