Energy Calculation Formula

[Cranky CJ]

The thread on load data forms made me start putting my own together on an excel spread sheet.

I have the basics of it lined out but I want to add a cell that would allow me to plug the wt of the bullet, a chrono speed and calculate the bullet energy.

Anybody have that formula and how to plug it in on excel. This is my first experiment with excel and am learning as I go.

Thanks.

 

[NeuseRvrRat]

kinetic energy = 1/2*mass*velocity^2

watch your units

 

[jstein650]

An easy formula with common units is:

Bullet wt. (grains) x (velocity (fps)^2) / 450440 = ft. lbs. energy

 

[Reloadron]

In Excel assuming cell A1 is velocity in FPS and cell B1 is bullet weight in grains it would look like this:

=(A1)^2*(B1)/450240

The number in cell A1 is squared then multiplied by the number in cell B1 and divided by in this case 450240. So looking at this link if a 115 grain bullet traveling at 1300 fps = 431 ft. lbs. of muzzle energy. Actually 431.6586709 Lb Ft of energy. I doubt you want 7 places to the right of the decimal in your C1 block.

This link will cover how to round your answers up or down.

There are also other ways to have a cell only display for example two decimal places.

That what you are looking for?

Ron

 

[Cranky CJ]

yep. thanks ron. I'll plug it in when the wifey gets off the other computer and run some experiments.

thank you to everybody else as well.

 

[Reloadron]

Let us know how it goes or if you have any Excel problems. Should work using the formula as posted but play around with things.

Ron

 

[Cranky CJ]

Pluged in the formula you gave me ron and it works just fine, cross checked it against a couple other sources. thanks, ron

Now I'm going to have to figure out how to utilize it efficeintly. I'm good at keeping hand written note book notes, but records on a computer, not so much. Like anything DIY, you have to make it your own.

 

[Reloadron]

Good, glad that worked out. Something to consider is that Excel is pretty much a spreadsheet program. Using math functions with the cells gives quite a few possibles. However, while I haven't messed with it in years you may also want to look at the possibilities in Access. Access being more of a database type program rather than a spreadsheet program. The math functions are called "Expressions". Anyway, consider the possibilities and choose the software on what you want to get done.

Ron