Spread Sheets and Testing Ammo

Greetings,

A fellow shooter introduced me to using a Spread Sheet to "forecast" velocity.

I recently tried it with some 45 ACP loads.

Bullets are H&G 130 cast of LinoType
Powder is Bullseye, Lot#669

Interesting to note that the FORECAST was within 6 FPS of the actual values.

Cheers,

Dave

The statistical term is linear regression.  If the data is more-or-less linear (a straight line), the predictions are close.  I've found that most handgun powders are more-or-less linear in the range we usually use them.