Free Spreadsheet from triggertreat Rev 05



Author Topic: Free Spreadsheet from triggertreat Rev 05  (Read 3508 times - 5 votes) 
)

Offline P. O. I.

  • Sharp Shooter
  • ****
  • Posts: 780
  • yes
  • Real Name: P. O. I.
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
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: 3546
  • ⊙ 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.
  • 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 Marc In Iowa

  • Expert
  • *****
  • Posts: 1162
  • 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 (20-82 yds):
- Discovery 22, HPA w/GTOs <- best HPA
- GAMO Urban 22, HPA w/GTOs <- goto plinker
- Hammerli 850 177, COČ w/GTOs <- accurate!
- Walther Terrus 177, springer w/GTOs <- fun!
Hunter Field Target (10-55 yds)
- Bantam 177, HPA w/10.65, 8.44, GTOs

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 3546
  • ⊙ 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.
  • 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 Marc In Iowa

  • Expert
  • *****
  • Posts: 1162
  • 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 (20-82 yds):
- Discovery 22, HPA w/GTOs <- best HPA
- GAMO Urban 22, HPA w/GTOs <- goto plinker
- Hammerli 850 177, COČ w/GTOs <- accurate!
- Walther Terrus 177, springer w/GTOs <- fun!
Hunter Field Target (10-55 yds)
- Bantam 177, HPA w/10.65, 8.44, GTOs

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 3546
  • ⊙ 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 »
  • 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 titeuf007

  • Shooter
  • *
  • Posts: 62
  • 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: 1428
  • 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 Tuned
Gamo URBAN .22 10x44 SWIR
Hatsan Bullboss .22  3-12x40 SWAT  (Regulated!)
Prod .22 Custom, Bottled, Bstaley, UTG 3-12x32 SW
Crosman Crusher .22 CP 4-16x40 AOIR

Offline triggertreat

  • 2017 GTA Fun Shoot Winner (PCP class)
  • GTA Senior Contributor
  • ******
  • Posts: 3546
  • ⊙ 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.
  • 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 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: 3546
  • ⊙ 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.
  • 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 rgb1

  • Plinker
  • **
  • Posts: 137
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: 3546
  • ⊙ 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.
  • 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 Hajimoto

  • Tweak Geek Shooter'er
  • Expert
  • *****
  • Posts: 1137
  • 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

  • Expert
  • *****
  • Posts: 1888
  • 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 Regal XL & Hawke Airmax 30 SF 6-24x50
.177 TX200 MkIII HC & Hawke Airmax 30 SF 6-24x50
.177 HW50S & UTG Compact 3-12x44

Offline Jonnie

  • Plinker
  • **
  • Posts: 105
  • 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: 3546
  • ⊙ 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...
  • 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 kenoman742

  • Shooter
  • *
  • Posts: 24
  • 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: 3546
  • ⊙ 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.
  • 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 kenoman742

  • Shooter
  • *
  • Posts: 24
  • 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

GTA - The best place for discussion about Air Guns.
 

Sponsored Ad: