• Jefferson State Airrifles
  • Air Gun Web - Expert Airgun Reviews
  • Hajimoto Productions
  • Airgun Angie - Backyard Shooting
  • Nielsen Specialty Ammo
  • Dynamic Air Rifles
  • FX Airguns
  • DonnyFL - When silence is a priority
  • Airgun Archery Fun
  • Pyramyd Air
  • Saber Tactical
  • New England Airgun
  • Umarex Airguns
  • Contact us
  • Utah Airguns
  • SEKHMET Airgun Accessories
  • Freedom Gun Targets
Jefferson State Airrifles
Air Gun Web - Expert Airgun Reviews
Hajimoto Productions
Airgun Angie - Backyard Shooting
Nielsen Specialty Ammo
Dynamic Air Rifles
FX Airguns
DonnyFL - When silence is a priority
Airgun Archery Fun
Pyramyd Air
Saber Tactical
New England Airgun
Umarex Airguns
Contact us
Utah Airguns
SEKHMET Airgun Accessories
Freedom Gun Targets


Author Topic: Free Spreadsheet from triggertreat Rev 05  (Read 13483 times - 7 votes) 
)

Offline Relentless Holiday

  • Expert
  • *****
  • Posts: 1035
  • yes
  • Real Name: Relentles Holiday
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #80 on: November 23, 2018, 02:10:12 PM »
....One thing for sure is that it is a one of a kind spreadsheet.  I'm embarrassed to share how long it took me to figure out Excel to make this.  I did start from scratch.  I'll just say it took awhile.

Holy crapoli Keith.  It sounded like this was your learning experience in Excel?!?!  Great job!!!!  ...and thanks for sharing.
  • USA New England
The member formerly known as P. O. I.

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #81 on: November 23, 2018, 11:17:51 PM »
....One thing for sure is that it is a one of a kind spreadsheet.  I'm embarrassed to share how long it took me to figure out Excel to make this.  I did start from scratch.  I'll just say it took awhile.

Holy crapoli Keith.  It sounded like this was your learning experience in Excel?!?!  Great job!!!!  ...and thanks for sharing.


Well as far as writing vba code and offset formulas.   I have used Excel before to view files.


P.S.  There's a delay in receiving a microphone I ordered to attempt a tutorial video which will be a first for that sorta thing also.  Hopefully it will arrive soon.
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline Marc In Iowa

  • Expert
  • *****
  • Posts: 1395
  • God bless us all, everyone
  • Real Name: Marc
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #82 on: November 24, 2018, 10:23:47 AM »
... I'm embarrassed to share how long it took me to figure out Excel to make this.  I did start from scratch.  I'll just say it took awhile.

Oh My Goodness!

Don't tell me that.

Now I'm going to feel like I have to develop that "goal seeking", "find the best part of the shot string" spreadsheet and I don't know what I need to know to do it!
  • USA, Iowa, Cedar Rapids
Until human nature changes, accurate shooting is needed. Please support the CMP mission.

Lead-free plinking (12-85 yds):
- 177 Hammerli 850, COČ w/GTOs
- UTG 10x 44mm

Other rifles:
-Discovery, Urban, Terrus, Bantam

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #83 on: November 24, 2018, 11:12:00 AM »
... I'm embarrassed to share how long it took me to figure out Excel to make this.  I did start from scratch.  I'll just say it took awhile.

Oh My Goodness!

Don't tell me that.

Now I'm going to feel like I have to develop that "goal seeking", "find the best part of the shot string" spreadsheet and I don't know what I need to know to do it!


Well I'm just a good ole country boy with more common sense than skills.  Someone with some smarts might not have the same lengthy learning curve.


The good news is that there's one already available that shows the best part of the string and it's free, but if you want to skin a cat a different way, I'll be interested.
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline Marc In Iowa

  • Expert
  • *****
  • Posts: 1395
  • God bless us all, everyone
  • Real Name: Marc
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #84 on: November 24, 2018, 11:52:09 AM »
The good news is that there's one already available that shows the best part of the string ...

I will try it with a recent string I "eyeballed" to find that part of the string.  :D
  • USA, Iowa, Cedar Rapids
Until human nature changes, accurate shooting is needed. Please support the CMP mission.

Lead-free plinking (12-85 yds):
- 177 Hammerli 850, COČ w/GTOs
- UTG 10x 44mm

Other rifles:
-Discovery, Urban, Terrus, Bantam

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #85 on: November 26, 2018, 02:12:35 AM »
 Click here to download the free Rev 05 spreadsheet updated 11-16-18

I created a tutorial video showing how to use the free rev 05 spreadsheet.  Don't laugh as it's my first time doing this sorta thing.  You can download the file or just play it from the linked site.

Hopefully it will answer some of the questions you may have on its use.

Click here to download/view the Rev 05 spreadsheet tutorial
« Last Edit: December 02, 2018, 02:10:24 PM by triggertreat »
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline titeuf007

  • Shooter
  • *
  • Posts: 97
  • yes
  • Real Name: loic
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #86 on: February 06, 2019, 12:47:23 PM »
great job
it will be great to have an adroid apk like that(paid version)
  • aix, France

Offline archellas

  • If it's about NOT knowing anything, then yes, I'm an
  • Expert
  • *****
  • Posts: 1675
  • Hmm.. how can I modify this gun ...
  • Real Name: TJ
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #87 on: February 06, 2019, 01:46:18 PM »
OUTSTANDING work Keith! Thank you for providing this for us.

Cheers
  • Land of Lincoln
Keep shooting straight ......

Gauntlet .22 4-16x44 SWIR Haj+JSA kits - Tuned
Gamo URBAN .22 10x44 SWIR Tuned, fully shrouded, CDT +
 KRAL .22 Puncher Breaker Silent 3-9x32 SW Troy Hammer tune + Custom work
Prod .22 Custom, Bottled, Bstaley, UTG 3-12x32 SW
Sig Sauer MPX .177 HPA, Customized, Red Dot

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #88 on: February 06, 2019, 05:59:46 PM »

Thanks fellas!  I appreciate the feedback!


loic, I do appreciate your input, but it would take rewriting code and recreating the spreadsheet for APK.  There is a lot of code running in the background along with some rudimentary tricks too, and I am not up for starting all over.  Excel for droid can't handle the VBA coding either so you'll just have to enjoy it as is or create your own with APK suites.  Besides, it is much better on the big screen as designed.
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline brisner

  • Shooter
  • *
  • Posts: 29
  • yes
  • Real Name: Bob
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #89 on: March 05, 2019, 04:11:46 PM »
triggertreat, I got an error message in your spreadsheet today. See below photos.
  • Florence, Alabama
Umarex Gauntlet 0.25
Umarex Gauntlet 0.22
Hatsan BT65 QE 0.25
Benjamin Marauder 0.25
Benjamin Maximus 0.117
Shoebox F10 Compressor
ProDigital Chrony

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #90 on: March 05, 2019, 04:24:46 PM »
triggertreat, I got an error message in your spreadsheet today. See below photos.



I can't tell much of what you're inputting from the pics.  That's a typical Excel error message when a formula can't calculate properly.  Make sure to check your inputs.  An O is not a zero or decimal points that shouldn't be etc. is most likely to cause.
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline rgb1

  • Plinker
  • **
  • Posts: 174
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #91 on: March 05, 2019, 04:48:36 PM »
I have tried to download the spreadsheet/tutorial and
get a blank screen. Anybody.........??
       
                                                                  Ron
  • IN

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #92 on: March 05, 2019, 06:23:51 PM »
I have tried to download the spreadsheet/tutorial and
get a blank screen. Anybody.........??
       
                                                                  Ron



Just for a test, I just downloaded them without an issue.  In Google, just click on the download arrow at the top and select save.  The app only works on a Windows based PC.
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline Hajimoto

  • Tweak Geek Shooter'er
  • GTA Moderator
  • Expert
  • *****
  • Posts: 1400
  • yes
  • Real Name: Haj
Re: Free Spreadsheet from triggertreat Rev 03
« Reply #93 on: March 07, 2019, 08:22:33 AM »
hey,
thank you very much!
i would donate 1$ for such a great work :)



Thank you very much!  I would much rather you give that donation to someone in need or place in a Church offering plate where it would do the most good.  The free spreadsheet is my way of giving back to the GTA which has given so much to me.

After years of use, let it be known this Spread sheet is the bombness, the most dopest, the most bestest, the most off the chainest tool ever developed let alone freely shared!
THANK YOU TRIGGERTREAT!


<We now return you to your regularly scheduled programming in progress>
  • Western Massachusetts, USA

Offline Gear_Junkie

  • GTA Senior Contributor
  • ******
  • Posts: 2336
  • Real Name: Zack
Re: Free Spreadsheet from triggertreat Rev 05
« Reply #94 on: March 07, 2019, 01:28:54 PM »
This spreadsheet is fantastic - THANK YOU!
  • Nevada City, CA
.177 Skyhawk & Ares BTR II 3-15x50
.22 Skyhawk & Ares BTR II 3-15x50
.177 HW50S & UTG 3-12x44

Offline Jonnie

  • Plinker
  • **
  • Posts: 165
  • yes
  • Real Name: Jon
Re: Free Spreadsheet from triggertreat Rev 05
« Reply #95 on: March 08, 2019, 11:15:45 AM »
triggertreat, your spreadsheet just cost me $149.95! ;D
I was trying to use it in LibreOffice and none of the functions worked.
Note to others here. LibreOffice, or any other MS Excel free application will not allow this fine spreadsheet to work!
Yes, I purchased MS Office just to use this excellent spreadsheet that you were so generous to share with this great community.

THANK YOU!
  • Point Pleasant, WV, USA

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 05
« Reply #96 on: March 08, 2019, 12:17:20 PM »
triggertreat, your spreadsheet just cost me $149.95! ;D
I was trying to use it in LibreOffice and none of the functions worked.
Note to others here. LibreOffice, or any other MS Excel free application will not allow this fine spreadsheet to work!
Yes, I purchased MS Office just to use this excellent spreadsheet that you were so generous to share with this great community.

THANK YOU!



LOL, that made me smile this morning!  Glad you like it and it's useful to you!


For future reference, I got MS Office 2016 Professional off of eBay for around $5-$8 a few years ago...
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline kenoman742

  • Shooter
  • *
  • Posts: 30
  • Real Name: Ken
Re: Free Spreadsheet from triggertreat Rev 05
« Reply #97 on: March 08, 2019, 01:27:24 PM »
triggertreat,

I downloaded your excellent spreadsheet yesterday. It works great with one exception. The average fps line on charts 2 and 3 don't show the average fps value. For the title on these lines I get "[CELLRANGE]". On chart 1 the value does show correctly. I am using Windows 10 and Excel 2007. Maybe a compatibility issue?

Ken
  • United States, NV, Henderson

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 5980
  • ☉ Aim high and shoot far ☆
  • Real Name: Keith
Re: Free Spreadsheet from triggertreat Rev 05
« Reply #98 on: March 08, 2019, 01:34:15 PM »
triggertreat,

I downloaded your excellent spreadsheet yesterday. It works great with one exception. The average fps line on charts 2 and 3 don't show the average fps value. For the title on these lines I get "[CELLRANGE]". On chart 1 the value does show correctly. I am using Windows 10 and Excel 2007. Maybe a compatibility issue?

Ken



Thanks!  Yes, there are some compatibility issues with the older Excel 2007 when running the compatibility checker.  You might try downloading it again though.  I don't know why that issue wouldn't show up in chart 1 also.  They are all the same.
  • USA
(John 3:16-18) If you love the Lord, live it out day-to-day to show the Lord and others that you do.  (Revelation 2:4) Try your very best not to slip back to your old ways and trust in the Lord to help you.

Offline kenoman742

  • Shooter
  • *
  • Posts: 30
  • Real Name: Ken
Re: Free Spreadsheet from triggertreat Rev 05
« Reply #99 on: March 08, 2019, 01:49:42 PM »
Thanks. I will try a new download. This is a great spreadsheet and this is a minor issue to me. I can see the value in many other places. Thanks for all the work you put into the spreadsheet.

Ken
  • United States, NV, Henderson