Steve Jackson Games Forums - View Single Post - Binary propellant and Standard TL 8 guns?

hal · 09-22-2017, 09:02 PM

I was able to download it as an XLSX file without a problem. The next step for me is to try and figure out what the formulas you are using are, what the numbers are used in the formula, and maybe recreate it sufficiently enough that I can write a VBA code or VB.NET code to do the same thing.

The good news is that I have Doug's updated balistics sheet, and I have yours, and that should keep me busy trying to understand what they're doing. My theory is that if your methodology and Doug's methodology show two different paths to the same goal, I can maybe use one method to check against the other. It may well be they're both enough alike to be the same for all intents and purposes. I don't know.

Thanks both of you for the spreadsheets. :)

09-22-2017, 09:02 PM	#33
hal Join Date: Aug 2004 Location: Buffalo, New York	Re: Binary propellant and Standard TL 8 guns? I was able to download it as an XLSX file without a problem. The next step for me is to try and figure out what the formulas you are using are, what the numbers are used in the formula, and maybe recreate it sufficiently enough that I can write a VBA code or VB.NET code to do the same thing. The good news is that I have Doug's updated balistics sheet, and I have yours, and that should keep me busy trying to understand what they're doing. My theory is that if your methodology and Doug's methodology show two different paths to the same goal, I can maybe use one method to check against the other. It may well be they're both enough alike to be the same for all intents and purposes. I don't know. Thanks both of you for the spreadsheets. :)