Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-07-2012, 03:41 PM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Arrow A little help please :)

hey,
I'm stuck at D

I got this thing that i want to do:
A. I got 15000 points (this week maybe more /less next )
B. I have to give away 20% every week
C. out of A and - 20% (B), i got left X
D. Out of X I want to know thru a system that have 0-14000 rank points
E. the scale on how much points i will get is like this:
0-450.000 points
0-14.000 Rank points
The more points i get, the more rank points i get.
So its like if i get 450000 points, i do get 14000 rank points.
F. rank points gives rank (1-14)

rank 1 - x
rank 2 - 2000 RP
rank 3 - 5000 RP
rank 4 - 10000 RP
rank 5 - 15000
rank 6 - 20000 RP
rank 7 - 25000 RP
rank 8 - 30000 RP
rank 9 - 35000 RP
rank 10 - 40000 RP
rank 11 - 45000 RP
rank 12 - 50000 RP
rank 13 - 55000 RP
rank 14 - 60000 RP



I want to know WHAT rank i get and how many % away from next rank.

DONE

I wrote everything (I think) that I need and how its done.. anyone that can help me?
Reply With Quote
  #2  
Old 01-08-2012, 02:38 AM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

To calculate the rank for a value in A1:
=INT(A1/5000)+1+(A1>=2500)
If the above formula is in B1, then the next increment is found by:
=(B1-1)*5000+(B1=1)*2500
and the % shortfall from the next increment is thus given by:
=1-A1/((B1-1)*5000+(B1=1)*2500)
whilst the % increase required to reach the next increment is thus given by:
=((B1-1)*5000+(B1=1)*2500)/A1-1
(do note that the last formula will fail if the value in A1 is 0).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 01-08-2012, 03:29 AM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
To calculate the rank for a value in A1:
=INT(A1/5000)+1+(A1>=2500)
If the above formula is in B1, then the next increment is found by:
=(B1-1)*5000+(B1=1)*2500
and the % shortfall from the next increment is thus given by:
=1-A1/((B1-1)*5000+(B1=1)*2500)
whilst the % increase required to reach the next increment is thus given by:
=((B1-1)*5000+(B1=1)*2500)/A1-1
(do note that the last formula will fail if the value in A1 is 0).
I'm sorry but I dont understand how this can find out what Rank i get next week etc?
Reply With Quote
  #4  
Old 01-08-2012, 04:52 AM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

The only question you asked was:
Quote:
I want to know WHAT rank i get and how many % away from next rank.
The formulae I posted show how to calculate both. If you want help with something different, you need to state clearly what that is.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 01-08-2012, 04:58 AM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
The only question you asked was:

The formulae I posted show how to calculate both. If you want help with something different, you need to state clearly what that is.
hmm maybe your right but Out of my table that is 1400000 points max etc.. how do u calculate it like that ? but anyhow if u says its right i assume so.. any chance u can help me abit on how to set it up ? I'm not that advanced on excel.
Reply With Quote
  #6  
Old 01-08-2012, 02:29 PM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by hahaitwork View Post
hmm maybe your right but Out of my table that is 1400000 points max etc.. how do u calculate it like that ?
If the points are calculated the same way as in your original post, the formulae I gave you will work much the same, though with a 'max' value a little change might be needed if you think you're likely to reach that level.
Quote:
Originally Posted by hahaitwork View Post
but anyhow if u says its right i assume so.. any chance u can help me abit on how to set it up ? I'm not that advanced on excel.
Do you at least have an Excel workbook to use? If so, can you post a copy with some sample data?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 01-08-2012, 03:49 PM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
If the points are calculated the same way as in your original post, the formulae I gave you will work much the same, though with a 'max' value a little change might be needed if you think you're likely to reach that level.Do you at least have an Excel workbook to use? If so, can you post a copy with some sample data?
Here is a copy, i just translated much to english, hopefully u understand it.
Attached Files
File Type: xlsx Elemmy pvp regneark.xlsx (45.6 KB, 8 views)
Reply With Quote
  #8  
Old 01-08-2012, 06:01 PM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi,

Try the attached. I'm really not sure what it is you're trying to achieve, as there's nothing in the workbook relating to:
Quote:
how many % away from next rank
Attached Files
File Type: xlsx Tore.xlsx (46.7 KB, 11 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 01-09-2012, 01:10 AM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi,

Try the attached. I'm really not sure what it is you're trying to achieve, as there's nothing in the workbook relating to:
Well.. after you pass lets say 10000 you get into rank 1.
How far inside level 1 are you?
If rank 2 is 15k, and rank 1 is 1000 (random numbers).
How far (%) into level 1 are you if u got 10000 points.
You see where i want?
Reply With Quote
  #10  
Old 01-09-2012, 03:06 PM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by hahaitwork View Post
Well.. after you pass lets say 10000 you get into rank 1.
How far inside level 1 are you?
If rank 2 is 15k, and rank 1 is 1000 (random numbers).
How far (%) into level 1 are you if u got 10000 points.
You see where i want?
Have you looked at the workbook attached to my last post? Aren't those details what I've already provided? So far, the forum says the attachment has had "0 views"!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 01-10-2012, 12:54 AM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Have you looked at the workbook attached to my last post? Aren't those details what I've already provided? So far, the forum says the attachment has had "0 views"!
sry I ignored it as It didn't seem like you understood 100% what I looked for, sry about that.

Anyhow, I checked it out and it says my rank will be 5 and 35%,
the problem is that I'm 100% sure that i cant get rank 5 out of this few points, max rank 2.. so something is wrong
Reply With Quote
  #12  
Old 01-10-2012, 03:26 AM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, I wasn't 100% sure - because there is nothing in your workbook that fits your specification of "how many % away from next rank". How is anyone supposed to provide the solution for that when there is nowhere apparent for it to go?

According to your specifications, the 19161 rank points in F2 is greater than the 15000 rank points in B6 required to achieve rank 5 (A6). So I don't know how you can say:
Quote:
I'm 100% sure that i cant get rank 5 out of this few points, max rank 2
As for:
Quote:
I checked it out and it says my rank will be 5 and 35%
there is no 35% figure in the workbook I posted. There is a 28% figure in E2, representing the percentage by which the 19161 rank points in F2 exceeds the 15000 rank points in B6, and a 2% figure in L2, representing the percentage by which the 15238.8 rank points in H2 exceeds the 15000 rank points in B6.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #13  
Old 01-10-2012, 03:42 AM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Yes, I wasn't 100% sure - because there is nothing in your workbook that fits your specification of "how many % away from next rank". How is anyone supposed to provide the solution for that when there is nowhere apparent for it to go?

According to your specifications, the 19161 rank points in F2 is greater than the 15000 rank points in B6 required to achieve rank 5 (A6). So I don't know how you can say:

As for:

there is no 35% figure in the workbook I posted. There is a 28% figure in E2, representing the percentage by which the 19161 rank points in F2 exceeds the 15000 rank points in B6, and a 2% figure in L2, representing the percentage by which the 15238.8 rank points in H2 exceeds the 15000 rank points in B6.

The 19161 "rank points" are suppose to be only "points" ehm.. it was just a note for my self that i assume only i would understand sry about that.

"point = honor" so if you look at the imiage, u will notice that it wont get so high as rank 5.

you wont be able to see under 6000 rank points btw, only from 6000 RP and up to 14000 RP.
So if you look at the imiage you will have 7000 Rank points WHEN you got 50000 points/honor
Out of the 7000 Rank points you get, you will get Rank 3 and some % inside that rank.
hope that made a few things more clear?
Reply With Quote
  #14  
Old 01-10-2012, 05:37 AM
macropod's Avatar
macropod macropod is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You really do need to explain your problem more clearly. I gather you're now referring to the cells in G32:H41. If so, how do they relate to cells A2:B15 and your other data?

Until you can explain clearly what results you expect to see in every range, and how they relate to the data tables in your workbook, you can't expect to get the help you want.

So, in answer to your question: no you haven't made things clear.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #15  
Old 01-10-2012, 05:47 AM
hahaitwork hahaitwork is offline A little help please :) Windows 7 64bit A little help please :) Office 2010 64bit
Novice
A little help please :)
 
Join Date: Jan 2012
Posts: 8
hahaitwork is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
You really do need to explain your problem more clearly. I gather you're now referring to the cells in G32:H41. If so, how do they relate to cells A2:B15 and your other data?

Until you can explain clearly what results you expect to see in every range, and how they relate to the data tables in your workbook, you can't expect to get the help you want.

So, in answer to your question: no you haven't made things clear.
Honor = points
RP = rank points

1. My amound of honor is 100.000
2. If you follow the table (Image) it will say around how much RP that it will give me
3. out of that amound of rank points I wounder.. how many ranks do i earn and how far into this rank did I get

Your idea have made it so I get rank 5 and 28% into rank 5.
The problem is, when you read the table it says I will get like.. only get rank 2.

What is the part you dont understand?
Reply With Quote
Reply

Thread Tools
Display Modes


Other Forums: Access Forums

All times are GMT -7. The time now is 04:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft