Help a new newbe Please!!!

[Sand_in_my_Boots]

I need some help figuring out what formula, would best suite my needs and how to make it meet several criteria’s: Age group, Repetitions, Gender for example if a 21 year old male soldier does 42 sit ups then his raw score for push up would be 60 percent, and a female same age, would score 100 percent.
Thus when I enter the age, M/F (gender), Repetitions the excel sheet will auto configure the Raw scores for each event, then if the soldier scores less than 60 percent
In any event it will enter a Fail for that soldier, and a pass if the soldier scores greater than 60 percent.
This message was edited by Sand_in_my_Boots on 2002-10-14 03:32
This message was edited by Sand_in_my_Boots on 2002-10-14 03:33

 

[s-o-s]

On 2002-10-14 03:29, Sand_in_my_Boots wrote:
I need some help figuring out what formula, would best suite my needs and how to make it meet several criteria’s: Age group, Repetitions, Gender for example if a 21 year old male soldier does 42 sit ups then his raw score for push up would be 60 percent, and a female same age, would score 100 percent.
Thus when I enter the age, M/F (gender), Repetitions the excel sheet will auto configure the Raw scores for each event, then if the soldier scores less than 60 percent
In any event it will enter a Fail for that soldier, and a pass if the soldier scores greater than 60 percent.
This message was edited by Sand_in_my_Boots on 2002-10-14 03:32
This message was edited by Sand_in_my_Boots on 2002-10-14 03:33

Welcome to the board,

If you actually supply the relationships between these factors, how do you work out that Male 21 with 42 sit ups = 60%
and Female 21 with 42 sit ups = 100%

If you post up the drivers for how you score soldiers then several people on this board will be able to put these into a formula.

 

[Sand_in_my_Boots]

If you actually supply the relationships between these factors, how do you work out that Male 21 with 42 sit ups = 60%
and Female 21 with 42 sit ups = 100%

If you post up the drivers for how you score soldiers then several people on this board will be able to put these into a formula.

The relationship between male and female soldiers for the U.S. ARMY Physical Fitness Test i.e. APFT. Here is the Relationship http://www.benning.army.mil/usapfs/Training/APFT/
Underscoring standards, click on the Following hyperlinks: Push-Ups, Sit-Ups, and 2-Mile Run. Where I am at right now.
I have copied each standard to it’s own sheet in a workbook.
I have downloaded HtmlMaker2.32; I have failed to get it to work. I keep getting an error not located on this machine.
Purchased Excel for Dummies, the famous yellow know how books, my mistake! My son found it to be a very colorful by using the pages as a coloring book. Now covered in spaghetti and meat sauce With CHEESE! The book is useless to me.

 

[s-o-s]

Wow what a lot of data...

First, for Excel the table needs to be sorted the other way from lowest upwards.

Therefore I have entered the details of the 1st 5 rows (1-5) repetitions and have included 2 lookup tables that enables the correct column to be references.

You will just need to enter in the other columns.



Since this is big I hope it fits into the MrExcel limit for posts...

Training.xls
	A	B	C	D	E	F	G	H
1	Age		22				Age	Column
2	Male/female		female				15	2
3	Repitions		4				22	4
4	Column		5				27	6
5							32	8
6	Score		20				37	10
7							42	12
8							47	14
9							52	16
10
11		Male	Female	Male	Female	Male	Female	Male
12	Repetitions	17-21	17-21	22-26	22-26	27-31	27-31	32-36
13	1	2	4	2	5	2	5	3
14	2	4	8	4	10	4	10	6
Sheet1

This message was edited by s-o-s on 2002-10-14 06:53

 

[s-o-s]

I see the post did not work correctly (edit: 1st time a smaller area has now been posted) but the detail you need is in there...Just click the formulas in the column and score fields to be able to put into your own spreadsheet.

If you have real problems drop me an email and I will send through the file for you.


_________________
Hope This Helps.
Sean.<A HREF= "http://website.lineone.net/~s-o-s/Index.html">

Win98, XL2000
This message was edited by s-o-s on 2002-10-14 06:54