Because I could find in the information you gave , all I needed , I filled in my made calculator and made a picture of it to show here.
Its always adviced to use real weighed seperate wheelweights in the loading you drive with, second best is weighing per axle, but as long as you dont have that, we have to do with the GAWR's and use as much possible reserve that still gives acceptable comfort and gripp.
Then front 53 psi advice with only 5% reserve included because front seldomly gets over its GAWR. Rear as much possible reserve because rear overloading is more rule then exeption, and you could say the weights in use begin at GAWR.
Then advice Rear even 88 psi , wich is higher then the 80psi given on sidewall, but this is not the maximum pressure of such a tire.
Even stiffer TRA system Allows 10 psi above that cold pressure .
Also the rimms can have a maximum pressure given or maximumm load.
Then I asume this is also given for cold pressure .
My spreadsheet does not go from the lowest pressure as is done in lists , but the highest pressure with still acceptable comfort and gripp, to give as much possible reserve for things like , pressure-loss in time, misreadings of weight and pressure-scales, unequall loading R/L, etc.
Here the picture , and if you ever weigh I can fill in part 2 or even 3 for you to show.
