What spreadsheet do you use for plotting shot strings?

Diamondback · Jan 23, 2018

I remember seeing a nice spreadsheet program by The A Team, but haven't been able to find a copy.

I'd like to plot shot strings, now that I have a chrony

)

Anyone know where to get it, or know of another I can use?

dark1961 · Jan 23, 2018

no spreadsheet, just writing them down using a combro 625/4 chronograph

Oldpro · Jan 23, 2018

Here is a free spreadsheet that works great and I use something similar but this one is Free!!! https://drive.google.com/file/d/1EBm-pOyrzbe_7awzH0Piii4KYHhR8Fev/view?usp=sharing%3Cbr%20/%3E/ This was made by my good friend Keith aka triggertreat.

triggertreat · Jan 23, 2018

Sorry guys, I forgot about you over here.

Here is the link to the free spreadsheet I created:

Click here to download the spreadsheet

Diamondback · Jan 23, 2018

Thanks!
BTW...I found exactly the one I was looking for in this thread (about two-thirds down the page):
http://www.airgunnation.com/topic/looking-for-the-spread-sheet-by-jc-brown-werner-wicha/

Oldpro · Jan 23, 2018

Thanks Keith for getting these guys the link thats very gracious!!! This program is most useful and will aid anyone who is and avid shooter or into tuning or building a custom set up. I was going to say open a new thread with the SSA but you beat me to it.

Diamondback · Jan 23, 2018

Yes, Thank You!

triggertreat & Oldpro - I will check it out.

dark1961 - I got the chrony app to work with my phone, so I can email / export the strings as emails or spreadsheet files, so I can get a graphed visual of the string...if I get everything right.

Dirte · Jan 24, 2018

What chrono are you using? I use a Caldwell and drop it into Excel and have it plot.

Diamondback · Jan 24, 2018

Hi Dirte,
It's a Caldwell Ballistic Precision Chronograph.
I'm not too handy with using spreadsheets.
I notice the shot string data that it emails out reads from last shot to 1st (I'd really prefer the shot string to read from 1st shot to last), and has extra numbers / data that prevents me from simply copying & pasting the string into a spreadsheet to get the data in the correct cells (I think they call it populating cells?).

Maybe I need to use the "export as xls" or whatever the option is?

I notice triggertreat mentioned his spreadsheet strips out the shot string velocity readings, and inverts the shot string readings so they are in order from 1st shot to last, instead of from last shot to 1st.

How do you do it (set up the spreadsheet, get the data into the correct cells, etc)?

Dirte · Jan 25, 2018

"Diamondback"Hi Dirte,
It's a Caldwell Ballistic Precision Chronograph.
I'm not too handy with using spreadsheets.
I notice the shot string data that it emails out reads from last shot to 1st (I'd really prefer the shot string to read from 1st shot to last), and has extra numbers / data that prevents me from simply copying & pasting the string into a spreadsheet to get the data in the correct cells (I think they call it populating cells?).
Maybe I need to use the "export as xls" or whatever the option is?
I notice triggertreat mentioned his spreadsheet strips out the shot string velocity readings, and inverts the shot string readings so they are in order from 1st shot to last, instead of from last shot to 1st.
How do you do it (set up the spreadsheet, get the data into the correct cells, etc)?

So when you email your data from your Caldwell, it is in an excel file. When it opens in excel, you copy and paste into a graph format. It took me a little time playing around with it to get it how I wanted it. After that it was easy to do. The only thing I have to save is the choice of color and what the plots looks like. No manual entry of shots. If I did youtube videos it would be easy to reproduce. Kind of hard explaining in a few sentences. I am by no way an expert at excel.
Maybe someone will make a video on it.

triggertreat · Jan 25, 2018

"Diamondback"Hi Dirte,
It's a Caldwell Ballistic Precision Chronograph.
I'm not too handy with using spreadsheets.
I notice the shot string data that it emails out reads from last shot to 1st (I'd really prefer the shot string to read from 1st shot to last), and has extra numbers / data that prevents me from simply copying & pasting the string into a spreadsheet to get the data in the correct cells (I think they call it populating cells?).
Maybe I need to use the "export as xls" or whatever the option is?
I notice triggertreat mentioned his spreadsheet strips out the shot string velocity readings, and inverts the shot string readings so they are in order from 1st shot to last, instead of from last shot to 1st.
How do you do it (set up the spreadsheet, get the data into the correct cells, etc)?

In my free spreadsheet download, the instruction are included on how to do it.

Dirte · Jan 25, 2018

"triggertreat"

"Diamondback"Hi Dirte,
It's a Caldwell Ballistic Precision Chronograph.
I'm not too handy with using spreadsheets.
I notice the shot string data that it emails out reads from last shot to 1st (I'd really prefer the shot string to read from 1st shot to last), and has extra numbers / data that prevents me from simply copying & pasting the string into a spreadsheet to get the data in the correct cells (I think they call it populating cells?).
Maybe I need to use the "export as xls" or whatever the option is?
I notice triggertreat mentioned his spreadsheet strips out the shot string velocity readings, and inverts the shot string readings so they are in order from 1st shot to last, instead of from last shot to 1st.
How do you do it (set up the spreadsheet, get the data into the correct cells, etc)?
In my free spreadsheet download, the instruction are included on how to do it.

Click to expand...

Great!

Search

Search

What spreadsheet do you use for plotting shot strings?

Diamondback

Member

dark1961

Member

Oldpro

Member

triggertreat

Member

Diamondback

Member

Oldpro

Member

Diamondback

Member

Dirte

Member

Diamondback

Member

Dirte

Member

triggertreat

Member

Dirte

Member