I have a HDI(Human Development Index) database from my country where it includes every city. In case you don't know, UNPD uses certain thresholds to rank countries between 0 and 1, ranking them like:
Very high human development 0,8 - 1
High human development 0,7 - 0,799
Medium human development 0,5 - 0,699
Low human development 0 - 0,499
The problem comes when I need to color rank these cities
Right now I have something like this:
Position City IDHM IDHM-R IDHM-L IDHM-E 1 º Cuiabá 0.785 0.800 0.834 0.726 2 º Sinop 0.754 0.755 0.832 0.682 ... ... .... ... .. ...
But I'll need to transfer this database to another software including the code to make each number have a different color according to each rank, where they would look like this:
1 º Cuiabá AAA0.785 ZZZ0.800 ZZZ0.834 AAA0.726 2 º Sinop AAA0.754 AAA0.755 ZZZ0.832 BBB0.682 ... ... .... ... .. ...
My question is, does anyone know if there is a quick way to add this info automatically instead of having to input it manually?
I apologize for my poor english and thank you for your attention.