Any Mathematicians out there

I am fitting a G meter to the plane for testing and would like to predict mathematically if possible the expected results in a steady state balanced banked turn.

I have no idea on the theory behind the formula but using 1/cos(banked angle) seems to give incorrect results for the steeper angles which you may expect as it then becomes more of a sideways climb but subject to 1G side load.

So we move on to centrifugal load using G=F/mass*Velocity(squared) / turn radius ( thanks Adrian )

As I understand it , and please correct me , From level flight when going into a banked turn is the first formula but when you reach a 90 degree angle it is not banked anymore so all down to the centrifugal force plus the downward G load.

This suggests to me that the two values are interacting in different proportions throughout the angle changes.

Believe me if you explain the mathematical solutions there is a very good chance of completely losing me or giving me a mental breakdown so the ideal question is can I find a spread sheet were I could input the bank angle, static mass, speed and radius of turn and get the G loads expected between the bank angles of 0-90 degrees?

Somebody must have worked all this out !!!!

Hopefully what the predictions will give me is confidence in the G meter readout and also maybe tell me if it really is a balanced turn

Thanks