Help with air resistance in projectile motion

[AC-130U]

I need some help doing very basic mathematical analysis (what would be expected of a Calculus 1 and current Physics 1 student) for my project about tank projectiles, anything to calculate something about their air resistance/air drag, yet everything I have found has either been too simple (drag not proportional to velocity squared) or way too complex (involving wind tunnel test data, which I don't think I'm collecting anytime soon). Any equations or online ballistic calculation software will do, one of my teachers suggested this spreadsheet (http://galileo.phys.virginia.edu/classes/581/ProjectilesExcel.html, go to the bottom and click download the spreadsheet), which looked promising until I realized that the drag coefficient b was a pr-entered number. I don't have much numerical data about each projectile (here is an example http://www.imi-israel.com/vault/documents/105-mm%20hesh-t%20m156_en_draft-04.pdf ). Is there anything that any of you know of that can help me?
Thanks in advance for any assistance,
Andrew

 

[RandomGuy88]

You probably not be able to get the drag coefficient unless you have some wind tunnel or cfd data which doesn't seem like for tank munitions. Your best bet is to find something with a similar shape and use the drag coefficient of that shape as an approximation. So if someone has already developed a spreadsheet that will do what you need then you should probably use it.

 

[AC-130U]

You probably not be able to get the drag coefficient unless you have some wind tunnel or cfd data which doesn't seem like for tank munitions. Your best bet is to find something with a similar shape and use the drag coefficient of that shape as an approximation. So if someone has already developed a spreadsheet that will do what you need then you should probably use it.

In the spreadsheet I don't believe it makes any mention of the projectile shape though, and my project incorporates different styles of projectiles which probably have different drag coefficients. Thank you for your response though.

*update
Actually the calculus teacher just suggested that I play with the drag coefficient and try to edit in numbers until the x distance traveled is equal to the range that I gathered for that projectile type.