Lapua Ballistics tips: How to export trajectory tables to excel
A trajectory table in printed form can come in handy on many occasions, eg. when hunting or if you want to compare trajectory data on your computer. With Lapua Ballistics, you can export trajectory tables in a printable format. In this tip, we will tell you how to generate a table and export it to Excel.
A few tips for exporting a trajectory table to Excel:
- Consider the distances for which you want to create a trajectory table. We recommend creating a table including only the necessary data.
- Select the cartridge profile you are using.
- Update the weather conditions to match the conditions for which you want to generate the table.
- The trajectory table exported to Excel contains all the calculations made by Lapua Ballistics within the given distances. Note that your Excel views may look slightly different depending on version and operating system.
- The exported Excel file contains a considerable amount of calculated data. The visuality of the table and how to display the information is up to the user.
- NOTE! To be able to export the .csv file to your email, you need to have an email address registered to your phone’s own standard email app.
How to export trajectory tables to excel in Lapua Ballistics, step-by-step instruction
Step 1: Choosing the data you want to export
- First, pick the weapon/cartridge combo you want to use. In this example, we’re exporting a trajectory table for the profile FMJ 308 Win.
- Next, since you’re going to be taking into account the expected weather conditions, go to the Calculator view and tap “Get current weather”
- You know that the shortest possible shooting distance is 50 meters and the longest is 350 meters, and you want to generate a trajectory table in 25 meter increments. Swipe to the second to last calculator view “Trajectory table” and add the said distances. Tap “Calculate”.
Step 2: Share the trajectory table to your registered email
Step 3: Export the trajectory table from your email to your computer and open in Excel
Next, save the LapuaBallistics.csv file from your email to your own computer to a folder of your choice.
After that, open an empty workbook in Excel, and in the toolbar go to Data (→ Get External Data) → From Text. Choose the LapuaBallistics.csv file from the location you saved it to on your computer. Excel now opens the Text Import Wizard. Click Next, which takes you to Step 2 of 3. Choose ’Comma’ as your delimiter → click Next → Finish.
After this, your Lapua Ballistics calculation with the given distances will open in Excel. The trajectory table is at the top of the table, other properties can be seen at the bottom. You can pick the information you want and display it in the way you prefer.
…And you’re done!
Our next tip will feature the use of stability estimation. Stay tuned!