Need a function for my teaching plans
 

Hi,
I have the following challenge:
In my teaching a have to count the number of hours students spend on their
extra curricular activities.
This is the table I have:

classwork|extrawork|1stterm|2ndterm|3rdterm
16 weeks 15 weeks 17 weeks (per
term)
Psychology 188 120 4 6 2 (num of hours
per week)

What I know from this table is that, for example in the 1st term I will have
4 hours per week (actually two lessons, each 2 hours) 16 weeks which makes 64
hours or 32 classes per term. The total number of classes I will have in 1-3
terms is 188/2
What I don't know from this table is the number of extra curricular hours
per term/week. I know that the total is 120 and that each number should be
divided by two.

Could you help me out with this,
Thank you in advance,
ArthurN

Need a function for my teaching plans
 

Is it just

=ROUND(D$3*$C$3/$B$3,2)

for the 16 weeker, and copy across.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ArthurN" wrote in message
...
Hi,
I have the following challenge:
In my teaching a have to count the number of hours students spend on their
extra curricular activities.
This is the table I have:

classwork|extrawork|1stterm|2ndterm|3rdterm
16 weeks 15 weeks 17 weeks (per
term)
Psychology 188 120 4 6 2 (num of hours
per week)

What I know from this table is that, for example in the 1st term I will
have
4 hours per week (actually two lessons, each 2 hours) 16 weeks which makes
64
hours or 32 classes per term. The total number of classes I will have in
1-3
terms is 188/2
What I don't know from this table is the number of extra curricular hours
per term/week. I know that the total is 120 and that each number should be
divided by two.

Could you help me out with this,
Thank you in advance,
ArthurN

Need a function for my teaching plans
 

Hi, and thank you,
I guess, I wanted something a bit different. I think my original post was
too ambiguous.
This is the table that I have:
A B C D E F
1 16 15 17
2 Psych 188 120 4 6 2
Whe
B:B lists the total num of class work hours
C:C lists the total num of extra curricular hours
D1 lists in line 1 the num of weeks per 1st term
E1 - the num of weeks per 2nd term
F1- the num of weeks per 3rd term
Then the table holds all the subjects, e.g.
I know that psychology has 4 hours (2 classes) x 16 weeks in the 1st term,
which is 64 hours/32 classes. The sum of all the hours in 3 terms = 188 (B2).
Now, the num of extra curricular hours (C2) should be distributed
proportionally between all the terms, and the num should be dividable by 2
(each class has 2 hours). The trouble is that making the num dividable by 2,
while it might break the proportion a bit, is more important.
Thanks,
Arthur N

Need a function for my teaching plans
 

On Apr 1, 8:02 pm, ArthurN wrote:
Hi, and thank you,
I guess, I wanted something a bit different. I think my original post was
too ambiguous.
This is the table that I have:
A B C D E F
1 16 15 17
2 Psych 188 120 4 6 2
Whe
B:B lists the total num of class work hours
C:C lists the total num of extra curricular hours
D1 lists in line 1 the num of weeks per 1st term
E1 - the num of weeks per 2nd term
F1- the num of weeks per 3rd term
Then the table holds all the subjects, e.g.
I know that psychology has 4 hours (2 classes) x 16 weeks in the 1st term,
which is 64 hours/32 classes. The sum of all the hours in 3 terms = 188 (B2).
Now, the num of extra curricular hours (C2) should be distributed
proportionally between all the terms, and the num should be dividable by 2
(each class has 2 hours). The trouble is that making the num dividable by 2,
while it might break the proportion a bit, is more important.
Thanks,
Arthur N

=ROUND(($C$3/2)*percent,0)*2
Where "percent" needs to be calculated on each term to get your split.
And C3 is the extracurricular hours. For 3 terms, you need 3 of these
formulas. Should work if only even numbers are entered for
extracurricular.

Need a function for my teaching plans
 

Thank you, Spiky,
And how do I calculate the percent for each term?
ArthurN

Need a function for my teaching plans
 

On Apr 2, 7:18 pm, ArthurN wrote:
Thank you,Spiky,
And how do I calculate the percent for each term?
ArthurN

Just normal math; Term 1 divided by the total of all 3 terms, and so
on. I suppose it starts getting a bit complex to read if you do all
these calcs in one formula, but you do already have the total in cell
B2...

Assuming your original picture above from your 2nd post, put this in
cell G2 for Term 1:
=ROUND(($C2/2)*(D$1*D2/$B2),0)*2

That should give you the breakdown of Term 1 extracurricular hours.
You should be able to copy that across to H2 and I2 to get terms 2 and
3 in those cells. And then you should be able to copy down so each
line can be it's own class. If I'm understanding what all you want.