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?

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]

I'm sorry but I dont understand how this can find out what Rank i get next week etc?

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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.

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?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Here is a copy, i just translated much to english, hopefully u understand it.

Attached Files

Elemmy pvp regneark.xlsx (45.6 KB, 10 views)

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:

Attached Files

Tore.xlsx (46.7 KB, 13 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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]

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

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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?

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]

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?