Done working on this alone, leaving this here if anyone wants to work on/use it idc.
https://docs.google.com/spreadsheets...pnZVMD/pubhtml

The idea was to have an easy to use guild sheet to determine where to spend lp each day, but spending hours putting every lp conversion in alone then getting kicked from the guild without warning to spend prestige is enough for me.