Free Spreadsheet from triggertreat

[triggertreat]

Edit 9-6-18:  New Rev. 03 version.

Click here to download the free Rev 03 spreadsheet

[dmeguy]

I'm still amazed at the generosity of the members of GTA.


Thank you!

[Rat Sniper (AKA: PaulT58)]

This is amazing, thank you!  I have a simple spreadsheet I created that has 5 shot strings from each of my airguns with formulas that calculate FPE and average the FPS, but it's no where near as cool as this! 

[maraudinglizard]

Thank you for sharing, in need of a more updated one that was not in bar.

I'm still amazed at the generosity of the members of GTA.
Thank you!

This what GTA is all about, helping each other out for the love of the sport. 

[NutBuster]

Well Done! and Thank You!

[Ooops]

Thank you so much, that's really generous of you.

[triggertreat]

Thanks for the kudos!


I hope you find it useful.  It will calculate and display up to 186 shots for those with .177 bottled guns, but the graphs will be a little bunched up with those higher shot counts.  You can still use the data like ES, FPE and efficiency for those higher shot counts though.


Enjoy!


Keith

[ackuric]

Havent checked it out yet but kudos for the share

-Matt

[Geo]

I wonder if I can do an RS-232 or USB connx to take, or allow, a data query from a compatible chrono. Nice job, spreadsheets are definitely too much fun when youre into something like this!

[WeeHeavy]

I wonder if I can do an RS-232 or USB connx to take, or allow, a data query from a compatible chrono. Nice job, spreadsheets are definitely too much fun when youre into something like this!

I have a cable and software from Chrono Connect which allows me to collect the data right from my Shooting Chrony. There are tutorials for creating the cable and software to query the unit, but I saw no need to re-invent the wheel.

[BSJ]

Is this sheet still around?

[triggertreat]

No, I took it down.  It didn't seem like there was much interest in it and I found that the efficiency calculations in it were not very universal for regulated and nonregulated tunes.  I am however making one that I think is much better and more universal and will post it when completed.  I do have someone testing it for me right now.

[archellas]

No, I took it down.  It didn't seem like there was much interest in it and I found that the efficiency calculations in it were not very universal for regulated and nonregulated tunes.  I am however making one that I think is much better and more universal and will post it when completed.  I do have someone testing it for me right now.

Keith,

It looks excellent, I tried to get it , but alas .... I will wait for the new one unless you would be kind enough to repost this one, or email it to me?

Thanks

[oldpro]

 Very Generous Keith. What comes around goes around....Keep it up

[Nvreloader]

Keith
Being new to AR,
can you explain what is meant by regulated and non regulated, in ref to the efficiency calculations etc.

Thank you,
Don

I found that the efficiency calculations in it were not very universal for regulated and nonregulated tunes.

[triggertreat]

Very Generous Keith. What comes around goes around....Keep it up

Thanks Travis!  Glad to see you're back in the saddle again.


"What comes around goes around"  I don't know a whole lot and most of what I've learned came from kind folks like you on the forums.  I have also received free misc parts I needed for my Synrods from many folks on here like you, fuzzygrub, dairyboy, rocker1, synrodsteve and some I forget the name of right off.  So, creating and sharing my spreadsheets is one thing I can do as a thank you for the help I have received from the forums.  This new spreadsheet will look very similar to the one I have been posting with recently and think it's a little better than the first one I shared.  It won't be too much longer.

[triggertreat]

I wanted to thank whoever it was that gave me a star.  before your one star I had no stars and was starless, so thanks again!

[oldpro]

I wanted to thank whoever it was that gave me a star.  before your one star I had no stars and was starless, so thanks again!

I’d give you a star but don’t know what that is or even means.

[triggertreat]

I wanted to thank whoever it was that gave me a star.  before your one star I had no stars and was starless, so thanks again!

I’d give you a star but don’t know what that is or even means.

Thanks Travis!  It relates to the current rating system employed for the threads allowing members to rate them.  Although one star would typically represent disapproval by a member, I'm happy with the one star as it reminded me of the three wise men that were only given one star and it also coincidentally fits in with my current studies titled  ONE STAR.  So I view the one star rating differently than others and it meant much more than negativity to me.

[WesBob]

Sounds like a good study!
I don't see any star system, must only show up on certain browsers. I look forward to your new spreadsheet!