#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
The only question you asked was:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
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.
|
#6
|
||||
|
||||
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Quote:
|
#8
|
||||
|
||||
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:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#9
|
|||
|
|||
Quote:
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? |
#10
|
||||
|
||||
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] |
#11
|
|||
|
|||
Quote:
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 |
#12
|
||||
|
||||
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:
Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#13
|
|||
|
|||
Quote:
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? |
#14
|
||||
|
||||
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] |
#15
|
|||
|
|||
Quote:
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? |
Thread Tools | |
Display Modes | |
|