The moderator tells me that binaries here are a bad idea, so I'm posting that spreadsheet on my firm's website. Home page is
http://www.technopatents.com/ and I'll put the Excel sheet at
http://www.technopatents.com/misc/recoil.xls. (I'm afraid I don't know whether your browsers will object to a naked .xls file, and I don't know if you'll be able to ftp the .xls or not.)
I also simplified the calculation slightly: kick energy is simply bullet energy times the ratio of the masses, so all you need to input is bullet energy, bullet weight, and rifle weight for any given load.
Just for fun I stuck in the numbers for a Russian antitank rifle, for a 20mm round which I think may have been chambered in the Latvi, and for the two-man Steyr anti-materiel rifle!
Member ECS, AVS, ACM, OSA, Sen.Mem.IEEE, Reg'd Patent Atty 'All men by nature desire knowledge.'