Started by 375CT, September 22, 2014, 08:31:54 PM
Quote from: meccastreisand on September 22, 2014, 10:23:23 PMI think I have basically what you're looking for buried in some hidden tabs on my Ballistic_XLR workbook. you can download it at Ballisticxlr.com. If you need detailed info on it you can get in touch with me there too.
Quote from: admin on September 23, 2014, 01:21:22 PMI think I have missed this request.On my downloads page you can download a workbook, here a screen copy.http://www.bfxyz.nl/pics/bcfromvelocitysimplelarge.PNGIt uses velocity measurements at several distances, yet one can apply the same method to a single measurement.Yet the more measurements (at the same or different disatances) the better the results/ Alternatively you might post your data and I reply with an excel document that does the job.
Quote from: 375CT on September 23, 2014, 08:37:13 AMQuote from: meccastreisand on September 22, 2014, 10:23:23 PMI think I have basically what you're looking for buried in some hidden tabs on my Ballistic_XLR workbook. you can download it at Ballisticxlr.com. If you need detailed info on it you can get in touch with me there too.For some reason I cannot download your workbook. Google raised an error message, so please can you check?So, you say that from downrange velocities, you can calculate Cd (for any G function) ? Am I right?Thanks in advance for any help!
Quote from: meccastreisand on September 24, 2014, 11:49:10 PMWhen you click on the excel file at the download share it'll show you an image of the spreadsheet. At the top will be an open link and an arrow pointing downward that will download it for you.
Quote from: meccastreisand on October 02, 2014, 05:10:03 PMThere are 30 or so hidden tabs that have all the calculations. Find Ballistics Table 0
Quote from: meccastreisand on October 15, 2014, 04:40:54 PMunhide Ballistics Table 0 and find cell A23.
Quote from: mman on November 12, 2014, 05:59:51 AM375CT,I've been away for long time but if you haven't found a solution yet I have a suggestion. First just use Robert's spreadsheets to calculate BC from velocity measurements. Then use BC drag tables to find out Cd for velocity in question. As you know Cd for bullet is highly velocity depended and it doesn't make sense to calculate single average value for whole supersonic velocity range.