F-105D Thunderchief G Stall Lines

Good afternoon,

Here are the G stall line numbers for the F-105D Thunderchief, obtained from the V-G diagram contained in the aircraft’s flight manual:

34,058 lbs, clean configuration, bomb bay empty

1G: 160 KCAS
2G: 220 KCAS
3G: 275 KCAS
4G: 320 KCAS
5G: 360 KCAS
6G: 400 KCAS
7G: 440 KCAS
8G: 470 KCAS
9G: 500 KCAS

As weight increases, these numbers will increase. As weight decreases, these numbers will decrease.

Is it possible to create an Excel spreadsheet that will change these numbers if you enter a different weight?

If someone could help me figure out how to do this I would appreciate it very much!

Thanks,

Delta Pilot