Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: Excel 2007
Alan M

posted on 3/7/12 at 11:17 AM Reply With Quote
Excel 2007

Hi All

I wonder if anyone can help?

I'm trying to put together a progress tracker for an NVQ qualification; for each learner I need a list of tasks band then want to tick them off as they are completed. I would then like this to show as a percentage of the whole qualification at the end of the sheet for each learner. I can achieve this if I use a 1 in place of a tick but for appearance sake would like to use a wingdings "tick"

Any ideas how this can be achieved?

All input gratefully received. Ta






View User's Profile View All Posts By User U2U Member
Agriv8

posted on 3/7/12 at 11:28 AM Reply With Quote
Alan.

I would tackle this by use of the Countif formula you can use this to count your wingding ticks ( or the letter that the tick is asigned to ) from the countig you can use your calulation to work out percentage of total.

if that does not make sense shout up and I will try and assist.


ATB Agriv8





Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a tree full of a*seholes .............


View User's Profile View All Posts By User U2U Member
Agriv8

posted on 3/7/12 at 11:33 AM Reply With Quote
PS you need Webdings 2 and "P" ( cpital is important ) on the line you want count the ticks on

=COUNTIF(A3:J3,"P" )

where A3:J3 = the cells containg the tick you are counting

Agriv8

[Edited on 3/7/12 by Agriv8]





Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a tree full of a*seholes .............


View User's Profile View All Posts By User U2U Member
RIE

posted on 3/7/12 at 11:36 AM Reply With Quote
Was going to say the same as Agriv8, but he got there before me while I was looking for the (tick) character!

code:
=COUNTIF(A2:T2,"" )/20


That's assuming each student has a row to themselves, and there are 20 stages. Change numbers and ranges as appropriate.

[Edited on 3/7/12 by RIE]

View User's Profile View All Posts By User U2U Member
Alan M

posted on 3/7/12 at 11:48 AM Reply With Quote
Great! Thanks very much guys






View User's Profile View All Posts By User U2U Member
kipper

posted on 3/7/12 at 12:49 PM Reply With Quote
codes

Here they go again, trying to confuse us old technophobes. I wonder what they are talking about? It's a whole new world.( Still trying to come to terms with the Fax machine)

good luck kids, Denis.





Where did that go?
<<<<

View User's Profile E-Mail User View All Posts By User U2U Member
Alan M

posted on 3/7/12 at 12:59 PM Reply With Quote
Brilliant! That works a treat. Now..............

If I want to add some test results for each student and then get the calculation to include them in the progress percentage?

e.g.

G1 G2 G3 G4 LT1 LT2 LT3 LT4 LT1 LT2 Total % 93 90 "P" 75 "P" 68 "P" "P" "P" 67 ?






View User's Profile View All Posts By User U2U Member
Alan M

posted on 3/7/12 at 01:29 PM Reply With Quote
quote:
Originally posted by Alan M
Brilliant! That works a treat. Now..............

If I want to add some test results for each student and then get the calculation to include them in the progress percentage?

e.g.

G1 G2 G3 G4 LT1 LT2 LT3 LT4 LT1 LT2 Total % 93 90 "P" 75 "P" 68 "P" "P" "P" 67 ?


Sorry should read:
G1 G2 G3 G4 LT1 LT2 LT3 Total %
75 "P" 68 "P" "P" "P" 67 ?






View User's Profile View All Posts By User U2U Member
Agriv8

posted on 3/7/12 at 03:54 PM Reply With Quote
Alan you lost me mate

do they have a Percentage ( how much of the asigment complete ) then a tick.

or in othether words a tick = 100% if its a percentage that how much they have done so far ?

Kipper dont worry computers are even more trouble and illogical than those Wimmin

ATB Agriv8

[Edited on 3/7/12 by Agriv8]





Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a tree full of a*seholes .............


View User's Profile View All Posts By User U2U Member
Alan M

posted on 3/7/12 at 04:08 PM Reply With Quote
Sorry, I knew I hadn't explained it well!

Basically they have certain tests and assignments to complete. The tests are marked with a percentage score. The practical assignments are just ticked when completed.

Any clearer?

Cheers, Alan
quote:
Originally posted by Agriv8
Alan you lost me mate

do they have a Percentage ( how much of the asigment complete ) then a tick.

or in othether words a tick = 100% if its a percentage that how much they have done so far ?

Kipper dont worry computers are even more trouble and illogical than those Wimmin

ATB Agriv8

[Edited on 3/7/12 by Agriv8]







View User's Profile View All Posts By User U2U Member
Agriv8

posted on 3/7/12 at 05:03 PM Reply With Quote
clear as Mud

U2U me your Email Address and I will send you a working Excell sheet when I get Home this eve.

ATB Agriv8





Taller than your average Guy !
Management is like a tree of monkeys. - Those at the top look down and see a tree full of smiling faces. BUT Those at the bottom look up and see a tree full of a*seholes .............


View User's Profile View All Posts By User U2U Member
RIE

posted on 3/7/12 at 09:02 PM Reply With Quote
Does each percentage score has the same weighting as a tick, i.e. that stage is completed?

=COUNTA(A2:G2)/7

This is following your example above of 7 modules. It will count anything entered in the cells, whether it's a number, tick character or a humourous limerick.




Or, is Total % adjusted by each percentage score? E.g. If student A has {75%, "P", 68%} and student B has {80%, "P", 74%} then student B has a higher Total % than student A.

=SUM(A8:G8,COUNTIF(A8:G8,"P" ))/7

This will count each tick as a 100% mark in that module, and add all module marks together, then divide by the number of modules. The percentage scores need to be entered as either 68% or 0.68. Entering 68 will give wrong answers.

[Edited on 3/7/12 by RIE]

View User's Profile View All Posts By User U2U Member
Alan M

posted on 1/8/12 at 09:28 AM Reply With Quote
Sorry! Only just noticed your post. This is exactly what I was looking for (and just been informed by a clever person at work)
Many thanks, Al

quote:
Originally posted by RIE
Does each percentage score has the same weighting as a tick, i.e. that stage is completed?

=COUNTA(A2:G2)/7

This is following your example above of 7 modules. It will count anything entered in the cells, whether it's a number, tick character or a humourous limerick.




Or, is Total % adjusted by each percentage score? E.g. If student A has {75%, "P", 68%} and student B has {80%, "P", 74%} then student B has a higher Total % than student A.

=SUM(A8:G8,COUNTIF(A8:G8,"P" ))/7

This will count each tick as a 100% mark in that module, and add all module marks together, then divide by the number of modules. The percentage scores need to be entered as either 68% or 0.68. Entering 68 will give wrong answers.

[Edited on 3/7/12 by RIE]







View User's Profile View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [ 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.