How do I make a bar show a certain value when a another bar is a different value?

This will be a bit hard to explain.  I am making a relationship system where to get to rank 1. you need to have 10 points. I have tried to write this in google spreadsheet but it was a bit hard to set up something where i can add and subtract numbers. So I was wondering if there is any possibility where for example Green bar shows what rank you have. determined by the number the red bar is.  For example. If i type 5 points into the red bar. the green bar shows 0. While i type 12 in red bar. It shows 1 in the green bar? I think i know how to get the rest of the ranks if i just get some help with the start code ^^; There is 5 ranks in total Just to help to visualize a bit more: Points (Red Bar) Ranks (Green Bar) 0 - 9 Rank 0 10 - 19 Rank 1 20 - 49 Rank 2 50 - 99 Rank 3 100 - 129 Rank 4 130 Rank 5

Hi Noova-Art, You will need a Mod (API Script) , a Pro feature,  to automate this.  While a calculation can be set up to calculate the number of ranks based on the red bar that calculation cannot then push the result to a Token's Bar without help from a script. 

This might be handled by the Character Sheet, usually, in much the same way that adjusting a character’s level adjusts the HP in 13th Age games. Then the 2 Attributes can be linked to bars on the token.  Of course, development of a Character Sheet requires a Pro subscription too.