Regarding stat caps and the affixal of materia to gear

[Mijin]

I have a question regarding stat caps and the affixal of materia to gear that hopefully some kind person can help me with.

As most of you probably know, there is a cap for every(?) stat that can be added to gear through the melding of materia. If you have an item and materia in question already in your possession you can test to see if it will allow it, and how much it will allow through the meld menu, however this obviously isn't the most efficient method imaginable for the purposes of min-maxing as endgame materia and meldable gear can be very time consuming and/or expensive to obtain.

My question is, are there any other means to determine what the caps of any given stat would be on meldable gear? Is there a formula? Is there some other in-game way of determining this that I've just overlooked? If not, are there any community works that cover this, such as a spreadsheet, or post somewhere?