do you have the info to make a column next to it of the percentage earned? (i.e. 200K SPG and 600K UA earned would be corresponding percentages/proportions)
I'm not entirely sure what you mean. Do you mean have a column showing the number of XX miles earned as a percentage of the total amount earned?
I can provide that if so, but I'm not sure how meaningful it would be because, for instance, UR would show as a smaller percentage because most of my UR have been earned through MS, not signup bonuses.
That's not a conclusion you could draw just from looking at the table though- unless your stockpile of each type of points was equal. If not, it would be quite possible to use up 100% of the SPG points you've collected and only 1% of the UA points you collected and still have the same % in your table. You would get a lot more out of the analysis if you added a column showing used as a percent of collected for each type, and then you could start to draw conclusions about relative value and relative difficulty of accumulating.
You're exactly right; the problem is, I don't have data for how much I've collected beyond what I've earned from
signup bonuses, so if I provided added a column showing used as a percent of collected for each type, it wouldn't be very telling, as alluded to above.