Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default Bowling: Handicap between Teams

hi!

What i am trying to do is to make a formulas on the master sheet that will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league, therefore
the formuilas need to check the Teams average on the teams page and then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other teams....This
can change weekly, Team or Handicap..

Thx you!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default Bowling: Handicap between Teams

Let's say the different teams averages are stored on worksheet Sheet2 in
cells A1:A10.

Calculate the Team handicap (and store B1:B10) as the following:

=max(A$1:A$10)-A1

Copy down to B10.

HTH,
Barb Reinhardt

"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league, therefore
the formuilas need to check the Teams average on the teams page and then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other teams....This
can change weekly, Team or Handicap..

Thx you!

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,355
Default Bowling: Handicap between Teams

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league, therefore
the formuilas need to check the Teams average on the teams page and then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other teams....This
can change weekly, Team or Handicap..

Thx you!

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default Bowling: Handicap between Teams

That does not work, cause you are saying to find the mx number in a colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league, therefore
the formuilas need to check the Teams average on the teams page and then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other teams....This
can change weekly, Team or Handicap..

Thx you!

  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Bowling: Handicap between Teams

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...


...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!





  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default Bowling: Handicap between Teams

OK! but my question is

That if in A1 the value is 500,
Therefore with the formulas, i am asking find the Maximum number in rows
A1:A10 witch equal to 500 and substract the same value, multuiply by 80%...

so basically, is 500-500*80%=0

"T. Valko" wrote:

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...


...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!




  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default Bowling: Handicap between Teams

Maybe, i am not understanding exactly, but i have try that formulas and comes
with 0 value!

I need to find the max in colums and subsract the actual Highest - Minest *
80%

So, like Team 1 equal 900, minus Team 2 = 750 *80% and so on!

"T. Valko" wrote:

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...


...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!




  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default Bowling: Handicap between Teams

Sorry! My mistake, it is working...Thx a Lot....!

Biff and Barb

"Yan" wrote:

Maybe, i am not understanding exactly, but i have try that formulas and comes
with 0 value!

I need to find the max in colums and subsract the actual Highest - Minest *
80%

So, like Team 1 equal 900, minus Team 2 = 750 *80% and so on!

"T. Valko" wrote:

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...


...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2 gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!




  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default Bowling: Handicap between Teams

Well, now I'm not following you.

If you change A1 to 500, A1 is no longer the max value in the range and the
results would be:

...........A..........B
1.......500......280
2.......750... ..80
3.......600.... .200
4.......850..........0

It would help if you could should show us an example with the desired
results.

Biff

"Yan" wrote in message
...
OK! but my question is

That if in A1 the value is 500,
Therefore with the formulas, i am asking find the Maximum number in rows
A1:A10 witch equal to 500 and substract the same value, multuiply by
80%...

so basically, is 500-500*80%=0

"T. Valko" wrote:

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...


...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a
colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet
that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2
gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!






  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Yan Yan is offline
external usenet poster
 
Posts: 33
Default Bowling: Handicap between Teams


Sorry it is working my mistake.....BIll!
"T. Valko" wrote:

Well, now I'm not following you.

If you change A1 to 500, A1 is no longer the max value in the range and the
results would be:

...........A..........B
1.......500......280
2.......750... ..80
3.......600.... .200
4.......850..........0

It would help if you could should show us an example with the desired
results.

Biff

"Yan" wrote in message
...
OK! but my question is

That if in A1 the value is 500,
Therefore with the formulas, i am asking find the Maximum number in rows
A1:A10 witch equal to 500 and substract the same value, multuiply by
80%...

so basically, is 500-500*80%=0

"T. Valko" wrote:

Barb's formula produces these results which is what you asked for:

Team 2 gets 120pins Handicap
team 3 shoiuld have 240pins handicap and so on...

...........A..........B
1.......900.........0
2.......750.....120
3.......600.....240
4.......850.......40

Biff

"Yan" wrote in message
...
That does not work, cause you are saying to find the mx number in a
colums
and susbstarct that same number....

I tried it!

"Barb Reinhardt" wrote:

Correction

=(MAX(A$1:A$10)-A1)*0.8


"Yan" wrote:

hi!

What i am trying to do is to make a formulas on the master sheet
that
will
change weekly the Handicap of the teams...

Ex: T1 avergae is 900 and T2 is 750 = 150pts different now i need to
take
that different at a 80% value and giev it to team 2 score....

But, the problem i have is that, their is 10 Teams in the league,
therefore
the formuilas need to check the Teams average on the teams page and
then
assign the correct Handicap to each team in the master sheets...

Ex: T1 = 900 ave.
t2 = 750
T3=600
T4= 850

Ok, now team 1 and Team 2 are 150pins different at 80%, so Team 2
gets
120pins Handicap

Team 1 and Team 3 ahve 300 pins different at 80%, so team 3 shoiuld
have
240pins handicap and so on...

Basically, the Highest average Team, gives Handicap to other
teams....This
can change weekly, Team or Handicap..

Thx you!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Does any one have a Golf Tournament spreadsheet for teams? Susan G Excel Discussion (Misc queries) 1 May 7th 07 08:03 PM
transfering numbers into teams Claude Laframboise Excel Worksheet Functions 2 July 13th 05 04:31 AM
I AM TRYING TO PLAN A FIXTURES TABLE INVOLVING 12 TEAMS BRIAN MURPHY Charts and Charting in Excel 2 May 30th 05 05:50 PM
how do I compute bowling league handicap using excel [email protected] Excel Discussion (Misc queries) 3 November 30th 04 02:46 PM
how to compute bowling league handicap using excel olddogg Excel Discussion (Misc queries) 0 November 28th 04 02:53 AM


All times are GMT +1. The time now is 12:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"