Recording Chronograph Results in Excel



Author Topic: Recording Chronograph Results in Excel  (Read 147 times))

Offline Lt. Dan

  • Shooter
  • *
  • Posts: 34
  • yes
  • Real Name: Dan
Recording Chronograph Results in Excel
« on: January 23, 2019, 10:25:59 PM »
I was wondering if anyone has created an Excel sheet to record your chronograph results with functions included to automatically calculate the results including BC and energy that you would be willing to share?
  • Moselle, MS, USA

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 3374
  • ⊙ Aim high and shoot far ☆
  • Real Name: Keith
Re: Recording Chronograph Results in Excel
« Reply #1 on: January 23, 2019, 11:40:20 PM »
I was wondering if anyone has created an Excel sheet to record your chronograph results with functions included to automatically calculate the results including BC and energy that you would be willing to share?


I'm currently sharing a spreadsheet I created. You can click the link in my signature to go to the thread with the links to download it and the tutorial. You will need a Windows PC and Excel to run it.  It will do what you're asking for, except for BCs, but you can store BCs in it.
  • TN
Great are you Lord.  It's your breath in our lungs, so I'll follow and praise you only.

22 Marauder Unregulated. Tuned using JSB 18.13gr:
30 Shots @ 31.02 FPE Avg., 1.36% ES, 1.58 FPE/CI
JSAR MDS Hammer, TSS and LW Air Tube mods.  MMHF barrel
UTG compact SWAT 4-16x44 IR SFP
25 Marauder Regulated. Tuned using JSB MKIIs:
24 Shots @ 55.94 FPE Avg., 1.96% ES, 1.49 FPE/CI
JSAR SS Valve, MDS Hammer, TSS and LW Air Tube mods.
Falcon Menace 5.5-25x50 IR FFP
357 Slayer Unregulated. Tuned using NSA 142gr:
4 shots @ 275.60 FPE Avg., 2.33% ES, 1.23 FPE/CI
Falcon Menace 5.5-25x56 FFP
DonnyFL Emperor LDC

Air Venturi 4500 psi compressor
Stickman fill assembly
60 min & 30 min 4500 psi CF tanks

Click here to download a Free Spreadsheet App (New Rev 05 ver. 11-16-18)

Offline Lt. Dan

  • Shooter
  • *
  • Posts: 34
  • yes
  • Real Name: Dan
Re: Recording Chronograph Results in Excel
« Reply #2 on: January 24, 2019, 07:04:55 AM »
Awesome,  that's nice. I can't wait wait to try this. So much more than I had ever dreamed of.  Thanks.
This must have taken 50 - 100 hours or more of tweaking to perfect. Super job.
  • Moselle, MS, USA

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 3374
  • ⊙ Aim high and shoot far ☆
  • Real Name: Keith
Re: Recording Chronograph Results in Excel
« Reply #3 on: January 24, 2019, 10:37:54 AM »
Awesome,  that's nice. I can't wait wait to try this. So much more than I had ever dreamed of.  Thanks.
This must have taken 50 - 100 hours or more of tweaking to perfect. Super job.



Thanks!  It did take a lot of hours, but was a labor of love as now we have a spreadsheet with features for airgunners.  Enjoy!
  • TN
Great are you Lord.  It's your breath in our lungs, so I'll follow and praise you only.

22 Marauder Unregulated. Tuned using JSB 18.13gr:
30 Shots @ 31.02 FPE Avg., 1.36% ES, 1.58 FPE/CI
JSAR MDS Hammer, TSS and LW Air Tube mods.  MMHF barrel
UTG compact SWAT 4-16x44 IR SFP
25 Marauder Regulated. Tuned using JSB MKIIs:
24 Shots @ 55.94 FPE Avg., 1.96% ES, 1.49 FPE/CI
JSAR SS Valve, MDS Hammer, TSS and LW Air Tube mods.
Falcon Menace 5.5-25x50 IR FFP
357 Slayer Unregulated. Tuned using NSA 142gr:
4 shots @ 275.60 FPE Avg., 2.33% ES, 1.23 FPE/CI
Falcon Menace 5.5-25x56 FFP
DonnyFL Emperor LDC

Air Venturi 4500 psi compressor
Stickman fill assembly
60 min & 30 min 4500 psi CF tanks

Click here to download a Free Spreadsheet App (New Rev 05 ver. 11-16-18)

Offline P. O. I.

  • Sharp Shooter
  • ****
  • Posts: 772
  • yes
  • Real Name: P. O. I.
Re: Recording Chronograph Results in Excel
« Reply #4 on: January 24, 2019, 12:46:26 PM »
Got more than ya asked for there, huh Dan.


Great job Keith. Thanks from us all. I clicked this to send him to it.
  • USA New England
Considering everything that's happend everything is just as it should be.

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 3374
  • ⊙ Aim high and shoot far ☆
  • Real Name: Keith
Re: Recording Chronograph Results in Excel
« Reply #5 on: January 24, 2019, 01:16:58 PM »

You're welcome!

I do like seeing posted tuning results/strings...Hint, hint :) .  I temporarily reduce the spreadsheet down to around a 70% zoom level in Excel.  I then use the Windows Snipping tool to copy/capture the string I want to post.

Here are some sample strings to show this:


  • TN
Great are you Lord.  It's your breath in our lungs, so I'll follow and praise you only.

22 Marauder Unregulated. Tuned using JSB 18.13gr:
30 Shots @ 31.02 FPE Avg., 1.36% ES, 1.58 FPE/CI
JSAR MDS Hammer, TSS and LW Air Tube mods.  MMHF barrel
UTG compact SWAT 4-16x44 IR SFP
25 Marauder Regulated. Tuned using JSB MKIIs:
24 Shots @ 55.94 FPE Avg., 1.96% ES, 1.49 FPE/CI
JSAR SS Valve, MDS Hammer, TSS and LW Air Tube mods.
Falcon Menace 5.5-25x50 IR FFP
357 Slayer Unregulated. Tuned using NSA 142gr:
4 shots @ 275.60 FPE Avg., 2.33% ES, 1.23 FPE/CI
Falcon Menace 5.5-25x56 FFP
DonnyFL Emperor LDC

Air Venturi 4500 psi compressor
Stickman fill assembly
60 min & 30 min 4500 psi CF tanks

Click here to download a Free Spreadsheet App (New Rev 05 ver. 11-16-18)

GTA - What's been your success with air gun target practice?