Ok so you have just purchased a Chronograph. Yah ok it read off the velocity to you for every shoot (Most of the time). What do you do with all that data? Sure you can buy expensive ballistics programs but if you have Microsoft Excel you can make your own with a little time that is cheap and easy to use. I will walk you through building a usable ballistics table that you can use for any of your reloading efforts. It may not show you drop and wind deflections but there are other ways of doing that like online calculators. 1. Set up your data fields. a. I like to use the following i. Date ii. Weather conditions iii. Bullet weight iv. Powder name v. Powder charge vi. Primer used vii. Case used viii. Shot # 1-10 ix. Velocity x. Deviations xi. Standard Deviation xii. Extreme Spread xiii. High velocity xiv. Low velocity xv. Average Velocity I like to set them up to look like the ones below. You can color code them however you like. 2. Now that you have that all set up we need to start inputting all your formulas. These have to be right so take your time and make it right I messed up once and didn’t know it I was getting some very crazy numbers like a 5000fps SD and extreme spread of 5 fps. a. First you are going to set your average velocity formula. i. Click in the box right below the average velocity header and enter the following into the F(x) (Function bar) Now the D8 and M8 are your cell numbers check and make sure that your cell reference is input correctly. 3. Now we are going to set the deviations. In the cell next to the Header Deviation click to select the cell. Now Input the following formula in to the cell =D8-$N$8 once again make sure your cell references are correct.