GTA

All Springer/NP/PCP Air Gun Discussion General => PCP/CO2/HPA Air Gun Gates "The Darkside" => Topic started by: triggertreat on August 09, 2018, 06:25:03 PM

Title: Free Spreadsheet from triggertreat Rev 05
Post by: triggertreat on August 09, 2018, 06:25:03 PM
Click here to download the free Rev 03 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

In Revision 03, I have updated the free spreadsheet to include some new additional features.  I think those of you that have downloaded the previous versions will really appreciate these new features.

Here are some of the new features in Rev 03:
The ability to view all three chart strings at once has remained unchanged from the previous versions as well as the ability to view those strings together on a single chart for analysis.

Feel free to download this free spreadsheet from the link above and check it out.  It is only going to be shared on the GTA.  It works great with Windows and Excel.  You are on your own with other platforms that will not run MS Excel fully.

Here are some snapshots of the spreadsheets:

This is the main chart (1 of 3) with string data.
(https://image.ibb.co/hBkyFp/001_Chart_String.jpg)

This is the main chart loaded with default data.
(https://image.ibb.co/gVTJFp/002_Default_chart_string.jpg)

This is the three charts viewed together.
(https://image.ibb.co/cH0vBU/003_String_1_2_3.jpg)

This is the charts compared on one chart.
(https://image.ibb.co/kFENrU/004_String_compare.jpg)

This is one of the saved strings sheets.
(https://image.ibb.co/j71JWU/005_Saved_Strings.jpg)

This is all the saved strings together.
(https://image.ibb.co/kEpBkp/006_Saved_Strings_Data.jpg)

This is the Caldwell chronograph sort and filter.
(https://image.ibb.co/eVS8D9/06_Caldwell_chrono.jpg)







 
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: CaptVideo on August 09, 2018, 10:17:13 PM
Thanks for all your work on this and for sharing it!

Gary
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: aceflier on August 09, 2018, 10:23:39 PM
Nice job man!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: cobalt327 on August 09, 2018, 10:24:09 PM
Outstanding!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: oldpro on August 09, 2018, 10:52:39 PM
For Us tech geeks this is great!!! Good work my friend.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 10, 2018, 12:04:08 AM

Thanks everyone!  It was a labor of love.  Hope you enjoy it.


I did find an error in one of the cells.  Please delete the file and redownload the file as the error has been fixed.  Sorry :-[ 8/10/18 01:00
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: mobilemail on August 10, 2018, 09:28:50 AM
Thank you sir!!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 12, 2018, 01:40:59 AM
Thank you sir!!



Oh, forgot to mention everyone but you....Just kidding :D ...Hope you like it.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 19, 2018, 07:06:54 PM
I have not heard of any problems yet, so I am assuming all is well with the spreadsheet.  Just let me know if you have any questions.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 27, 2018, 01:23:04 PM
Click here to download the free Rev 03 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

I have refined the Rev 03 spreadsheet a little more.  Although you could have easily sorted and filtered data in the "Data Sort table", I didn't like all of the clutter in the main "Saved Strings Data" sheet, which was showing all of the default string data from the two "Saved Strings" sheets, making it harder to view the actual string inputs.  I find this revised sheet much easier to view the actual saved strings and easier to compare them without all of the default data showing too.  I also made a few other minor tweaks in some other areas of the spreadsheet.

For those who have been using the spreadsheet, you can easily just copy and paste your stored strings over to this revised spreadsheet if desired.

Here is what the new revised "Saved Strings Data" sheet looks like.  You can see that all of the default string data is now blank in the cells and only actual string data are being displayed.  Once you add string data into one of the twenty saved string locations, that data will appear here on this sheet too.

(https://image.ibb.co/fObo2p/Revied_Spreadsheet.jpg)

Compared to the old spreadsheet:

(https://image.ibb.co/kEpBkp/006_Saved_Strings_Data.jpg)

Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Wolverineshooter on August 27, 2018, 01:56:35 PM
Thanks you Keith!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Tonycalves on August 27, 2018, 04:21:45 PM
Thank You Bro!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Thiel on August 28, 2018, 04:43:14 AM
hey,
thank you very much!
i would donate 1$ for such a great work :)
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: mcoulter on August 28, 2018, 02:16:51 PM
Hey, amazing work on this app!  (Sorry, calling it sheet would be doing it a disservice!)  Could you explain the Avg. lbs/Shot?  Is that referring to PSI used per shot?  I assume that it closely tied with your efficiency number.  Is a higher efficiency number better?  Sorry for noob questions and feel free to kick me if I missed these details in docs (i.e. RTFM).
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 28, 2018, 02:26:12 PM
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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 28, 2018, 02:41:06 PM
Hey, amazing work on this app!  (Sorry, calling it sheet would be doing it a disservice!)  Could you explain the Avg. lbs/Shot?  Is that referring to PSI used per shot?  I assume that it closely tied with your efficiency number.  Is a higher efficiency number better?  Sorry for noob questions and feel free to kick me if I missed these details in docs (i.e. RTFM).



Thank you!  The Avg. lbs/Shot is referring to psi per shot.  It's simply taking all shots and dividing them by the total air used.  I am unable to exactly calculate the air used per shot due to the efficiency of air use at the higher/beginning psi shots verses the mid to lower psi shots in an unregulated gun.  If regulated and using the same air per shot throughout the string, the calculation will be more accurate.


Yes, the higher the efficiency number, the better the tune.  The efficiency calculation takes into account the pellet weight, total air used and the shot count.


Thanks for your interest!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Marc In Iowa on August 28, 2018, 03:37:54 PM
Thank you for doing this (and sharing)!

I've often wished for a "goal seeking" spreadsheet where you could enter the shot string, a desired maximum ES and the sheet would find and highlight the area of the shot string that meets that goal.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on August 28, 2018, 05:02:29 PM
Thank you for doing this (and sharing)!

I've often wished for a "goal seeking" spreadsheet where you could enter the shot string, a desired maximum ES and the sheet would find and highlight the area of the shot string that meets that goal.



Thanks!  No, this spreadsheet cannot do that.  It does however come somewhat close in that it does highlight all shots within a 2.09% or a 4.09% ES within the chart tabs, which are the most commonly used ES goals in air gunning.  You can also look at the charts and easily see what your ES would be if you were to eliminate the highest ES and look at the next highest ES and so forth, being that every ES is listed for each shot, which I think is great to be able to see what could've been instead of a single view that a single ES search typically would provide.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 05, 2018, 12:52:56 PM

I have been going through the spreadsheet and feel pretty good about it now.  I did find one issue that I blamed on Excel.  I have fixed that issue, so be sure you have all the latest fixes.

To determine this, if you put in a starting pressure of 3000psi and a ending pressure of 2000psi in one of the "Saved Strings" (or anything that would result in 1000psi used), and your result in the PSI Used in the "Saved Strings Data" tab is showing a blank in that associated cell instead of 1000, then you don't have the latest fixes.


The latest fixes can be dowloaded from any of the links on this thread or here:  Click here to download the free Rev 03 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)



Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 07, 2018, 07:02:26 PM
Today I added a 1% ES column to the three charts that will highlight any shots within a 1.04% ES, just like the 2% and 4% columns do.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 24, 2018, 05:09:14 PM

Today I've added a few more enhancements and tweaks to the Free Spreadsheet app.  Click here to download the free Rev 03 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

I added an average FPS line to the three charts.  I like the visual view of the average FPS across the string.  This line will auto update with whatever string you throw at it.

I also added a string identifier cell.  This better identifies which saved string out of the 20 saved strings you are currently viewing, and is in all three charts, too.  It will auto update as well.  Both of these additions can be seen in the first image circled in red.

I also added a BAR to PSI and a PSI to BAR converter on the Caldwell Chrono sort tab which is circled in red in the second image.  I got tired of going online to convert BAR to PSI.  This one is quick and handy being it's right in the spreadsheet.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: oldpro on September 24, 2018, 08:44:54 PM
 SWEET!!!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Wolverineshooter on September 25, 2018, 03:02:13 AM
Appreciated!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Hobbyman2007 on September 25, 2018, 08:13:04 AM
Thanks so much for this awesome tool . Now all I need to do is figure out how to use it with an IPad. Iím sure thereís an app for that .
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Fred J on September 25, 2018, 10:12:47 AM
Thank you for sharing this!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on September 25, 2018, 12:29:18 PM
No Shot 28.

It skips from 27 to 29 in Chart 1...
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 25, 2018, 12:42:52 PM
No Shot 28.

It skips from 27 to 29 in Chart 1...



Thanks, I'll look at that. Check your PSI inputs.  Should be one start on the first shot and an ending PSI on the last shot.  Let me know.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on September 25, 2018, 12:49:19 PM
No Shot 28.

It skips from 27 to 29 in Chart 1...



Thanks, I'll look at that. Check your PSI inputs.  Should be one start on the first shot and an ending PSI on the last shot.  Let me know.

Yeah, I hadn't input the pressure data yet.

Edit to add. Still does it with accurate pressure data.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 25, 2018, 12:52:04 PM
No Shot 28.

It skips from 27 to 29 in Chart 1...



Thanks, I'll look at that. Check your PSI inputs.  Should be one start on the first shot and an ending PSI on the last shot.  Let me know.

Yeah, I hadn't input the pressure data yet.



Just looked at it.  It is skipping shot #28.  I'll fix it shortly.  Thanks! that was a great find.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 25, 2018, 02:41:21 PM

Ok, the error that BSJ found where shot# 28 was being skipped in chart 1 only has been fixed.  I found that row was hidden for some reason.  You can click on any previous posted links or here to get the fix.  Click here to download the free Rev 03 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

A big shoutout to BSJ for helping me out. Good call BSJ!  I didn't catch that.

Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on September 25, 2018, 03:35:22 PM
No problem.

Using stuff till it breaks is what I do...
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 26, 2018, 04:48:05 PM

 Click here to download the free Rev 03 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

Sorry guys and gals, one more update.  I added an average FPS line to the second graph in all three chart tabs like I did in the main charts yesterday.  Should've added them then.

I think this will be the last update unless me or someone else finds an issue somewhere.  Building this spreadsheet has been a long fun road and a challenge for me.  I started with a blank spreadsheet and built this one while learning Excel along the way because I didn't have a spreadsheet like I wanted.  I hope all enjoy using it that can.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Rallyshark on September 26, 2018, 11:02:15 PM
Thanks for that spreadsheet!!  I'm not an expert with Excel at all, but I can certainly change pellet weights and fps,lol!  I also changed the starting and ending psi, but the efficiency won't work for me.  What am I forgetting/missing?  Even without the efficiency, it is majorly helpful keeping tunes under 4% and 2%!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 27, 2018, 12:32:00 AM
Thanks for that spreadsheet!!  I'm not an expert with Excel at all, but I can certainly change pellet weights and fps,lol!  I also changed the starting and ending psi, but the efficiency won't work for me.  What am I forgetting/missing?  Even without the efficiency, it is majorly helpful keeping tunes under 4% and 2%!



Thanks for your interest, and glad you're getting some good use out of it.

You're almost there with getting the efficiency to work.  You need the pellet weight, PSI start and stop, and also the volume of air available.

So for the Res cc (reservoir cc volume) you will need to enter data there.  For example, a non regulated Marauder has a 215cc reservoir so you would enter 215 in the Res cc cell, or whatever cc capacity your gun reservoir has.  Many can be found on the PA website under specifications.

You will also need to fill in the Reg cc (regulated cc volume) and the Reg set point cells.  If not regulated, you want to put a zero in those two cells.

If regulated, you want to enter the reg set point and also the reg cc volume you have.  For example, a regulated Marauder typically has 34cc of regulated cc volume and 181cc of reservoir volume for a standard gun with a regulator installed.

Hope this helps.  There are a couple of example strings you can look at on the spreadsheet.  One is regulated and the other is not.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Rallyshark on September 27, 2018, 12:41:52 AM
That's what I did wrong, I didn't put a 0 in the reg section!  I did the cc, but didn't fill in the reg part, since the gun I was doing doesn't have a regulator  :-[  Thanks!! 

Again, AWESOME job on that spreadsheet Keith!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Rallyshark on September 27, 2018, 10:13:48 PM
Putting a zero in for the regulator section did the trick!  Now my efficiency is showing :D  Thanks again Keith!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: plinker81366 on September 27, 2018, 10:49:44 PM
how can we download the spread sheet to android phone?
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 27, 2018, 11:26:33 PM
Putting a zero in for the regulator section did the trick!  Now my efficiency is showing :D  Thanks again Keith!



Wow!  That's some nice power out a .22.


Tip,  go to view and uncheck formula and headings for more space for the charts.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 27, 2018, 11:30:03 PM
how can we download the spread sheet to android phone?



These small devices don't have the power to run full Excel with VBA/macros as far as I know.  Even Google can't handle it.  Need a PC with big screen to appreciate it.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Rallyshark on September 27, 2018, 11:58:10 PM
Putting a zero in for the regulator section did the trick!  Now my efficiency is showing :D  Thanks again Keith!



Wow!  That's some nice power out a .22.


Tip,  go to view and uncheck formula and headings for more space for the charts.

Oh the little Flash has more oomph in the little tank after I got my paws on it.  I call the one below, the piggy noggin tune,lol.  It does okay for a $200 gun with some elbow grease in it ;)   You're right, unchecking that formula in view helps too!  This spreadsheet is so great :D Very useful!!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 28, 2018, 12:01:53 AM
Putting a zero in for the regulator section did the trick!  Now my efficiency is showing :D  Thanks again Keith!



Wow!  That's some nice power out a .22.


Tip,  go to view and uncheck formula and headings for more space for the charts.

Oh the little Flash has more oomph in the little tank after I got my paws on it.  I call the one below, the piggy noggin tune,lol.  It does okay for a $200 gun with some elbow grease in it ;)   You're right, unchecking that formula in view helps too!  This spreadsheet is so great :D Very useful!!



Cool!  Now download the latest version of the spreadsheet for more features and fixes than the older version you have.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Rallyshark on September 28, 2018, 12:38:05 AM
I did a few minutes ago, and I'll be testing it with the regulator!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: plinker81366 on September 28, 2018, 09:01:59 AM
how can we download the spread sheet to android phone?



These small devices don't have the power to run full Excel with VBA/macros as far as I know.  Even Google can't handle it.  Need a PC with big screen to appreciate it.
thanks keith
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Wolverineshooter on September 29, 2018, 12:46:49 AM
Keith: Could you put the download link to your signature? I am sure a lot more people will learn about it. Thanks
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 29, 2018, 12:59:46 AM
Keith: Could you put the download link to your signature? I am sure a lot more people will learn about it. Thanks



Done.  Thanks!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Wolverineshooter on September 29, 2018, 08:59:25 AM
Great!
Title: Re: Free Spreadsheet from triggertreat Rev 04
Post by: triggertreat on September 29, 2018, 05:42:05 PM

Click here to download the free Rev 04 spreadsheet (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

Well, I thought I was done with the spreadsheet updates, and do believe I am now.  I added a kinetic energy conversion chart to the spreadsheet in version 04 dated 9/29/18.

You can now find FPE values by manipulating the FPS and pellet weights.  Or, find the FPS by manipulating the FPE and pellet weight.  Or, find the pellet weight needed for a given FPE and FPS.

No more going to ChairGun to do these conversions for me.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on September 29, 2018, 08:01:29 PM
Very cool!

Any chance you could add Joules to ft/lb to that tool?

My little chronograph only reads out Joules...

https://www.amazon.com/gp/product/B073WHPHR5/ref=oh_aui_search_detailpage?ie=UTF8&psc=1 (https://www.amazon.com/gp/product/B073WHPHR5/ref=oh_aui_search_detailpage?ie=UTF8&psc=1)
Title: Re: Free Spreadsheet from triggertreat Rev 04
Post by: triggertreat on September 30, 2018, 12:13:59 AM
Very cool!

Any chance you could add Joules to ft/lb to that tool?

My little chronograph only reads out Joules...

https://www.amazon.com/gp/product/B073WHPHR5/ref=oh_aui_search_detailpage?ie=UTF8&psc=1 (https://www.amazon.com/gp/product/B073WHPHR5/ref=oh_aui_search_detailpage?ie=UTF8&psc=1)



I put in a converter for you.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on September 30, 2018, 07:54:01 AM
You're the BEST!  ;D

Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on September 30, 2018, 10:11:05 AM
This is awesome!  Thank you!  I used this to compare shot strings for my new BullBoss.  I have 2 tanks, one regulated, one unregulated.  This gives me a very visual baseline for each.  Now to try and figure out where to go from here!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: P. O. I. on September 30, 2018, 08:36:03 PM
 It's down right humbling to see you AG rocket scientists go.   :o
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Nvreloader on September 30, 2018, 10:06:31 PM
I would love to down load this app,
have tried several times, with no such luck, which is par for me. 

Tia,
Don
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on September 30, 2018, 10:54:42 PM
I would love to down load this app,
have tried several times, with no such luck, which is par for me. 

Tia,
Don



I'm not sure of your process.  The google site doesn't show a preview, but you can still select download and then select save to download the file to your PC.  If trying to download to a phone or tablet, it's not going to work.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: mann on September 30, 2018, 11:30:28 PM
Darn I was hoping it would work on my phone
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 01, 2018, 02:06:20 PM

Call me crazy.  I added a few more features.  Click here to download the free Rev 04 spreadsheet updated 10-1-18 (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on October 01, 2018, 02:48:05 PM
That is pretty awesome and very thorough!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Nvreloader on October 01, 2018, 03:15:08 PM
Holy Snack Bar Keith,

That is an Outstanding app, Thank you,

Now do you have an app that will shoot the the AR with precision accuracy,   ;)  LOL

Still figuring/working out why,
I can not get your app to down load, using MS/Excell/Windows/Google on my plastic box etc.

Tia,
Don 
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Wolverineshooter on October 01, 2018, 03:18:14 PM
Don, when you click the link a download page will pop up, click on the appropriate button again to start download
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 01, 2018, 04:47:07 PM
Holy Snack Bar Keith,

That is an Outstanding app, Thank you,

Now do you have an app that will shoot the the AR with precision accuracy,   ;)  LOL

Still figuring/working out why,
I can not get your app to down load, using MS/Excell/Windows/Google on my plastic box etc.

Tia,
Don



That's weird  Maybe enable macros in the trust center first.


P.S.  I did update the file and the last posted image to correct some spelling just now.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 01, 2018, 07:21:00 PM
This is awesome!  Thank you!  I used this to compare shot strings for my new BullBoss.  I have 2 tanks, one regulated, one unregulated.  This gives me a very visual baseline for each.  Now to try and figure out where to go from here!



Thanks Paul!  Looks like that BullBoss has some great power.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 01, 2018, 07:24:20 PM
It's down right humbling to see you AG rocket scientists go.   :o



Lol, not a scientist by any stretch.  Just a useful tool I saw a need for and am happy to share.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on October 01, 2018, 11:53:30 PM
Keith, is there a way to adjust the scale of the axis that displays FPS in the charts?  Chart 1 is 100 to 1000 and shows a nice linear line graph, charts 2 & 3 are only about 100 points apart so he resulting graph appears to be all over the place even though the Standard Deviation is less than it is in chart 1.  It would be great if all 3 graphs used the same 100 to 1000 scale.

Also, under the conversions, could you add a cubic inch to cubic centimeter converter?  This is becoming a really awesome tool!  Thank you for sharing and continuing to update and improve it!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 02, 2018, 12:16:05 AM
Keith, is there a way to adjust the scale of the axis that displays FPS in the charts?  Chart 1 is 100 to 1000 and shows a nice linear line graph, charts 2 & 3 are only about 100 points apart so he resulting graph appears to be all over the place even though the Standard Deviation is less than it is in chart 1.  It would be great if all 3 graphs used the same 100 to 1000 scale.

Also, under the conversions, could you add a cubic inch to cubic centimeter converter?  This is becoming a really awesome tool!  Thank you for sharing and continuing to update and improve it!



Paul, there are pulldowns already on the main charts where you can adjust the chart axis.  There are minimums and maximums along with resets back to the Excel defaults  Yes, I can add that to the conversions.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on October 02, 2018, 10:06:57 AM
Keith, the drop down for the Chart Axis isn't working for me.  It may be because I'm using a Mac and the Mac version of Excel.  Is there a way you can set the default for all 3 charts to the same as Chart 1 when you do the next revision?  That may fix it for me since I probably won't change it from that setting anyway.  Thanks for adding the ci to cc converter!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 02, 2018, 10:35:18 AM
Keith, the drop down for the Chart Axis isn't working for me.  It may be because I'm using a Mac and the Mac version of Excel.  Is there a way you can set the default for all 3 charts to the same as Chart 1 when you do the next revision?  That may fix it for me since I probably won't change it from that setting anyway.  Thanks for adding the ci to cc converter!




What happens when you select "Reset Max" and then "Reset Min" from the dropdown?  These will reset the maximum and minimum axis back to Excel's auto default values for whatever it needs to display the strings.  You wouldn't want a fixed axis set in Excel (instead of auto) because some strings would not display depending on their values.


P.S.  The spreadsheet has been updated with the requested ci to cc converter.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on October 02, 2018, 01:59:48 PM
Are you referring to the "Chart Axis" dropdown (see below)?  If so, that's what's not working, when I click on it, it's treating it like it's an object not a dropdown (see second pic).  I even tried it on my work PC in Excel, and it's not working there either.  Not sure if anyone else is having this issue or not, it may have to do with the fact the spreadsheet is locked from changes.  It may work fine for you since you created it on your computer, but it's not working on another computer.  Just a thought...
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: BSJ on October 02, 2018, 02:13:34 PM
When I first open the sheet I get warnings asking me to 'Enable Editing' and then 'Enable Content'.

Once I click them, stuff works...
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on October 02, 2018, 03:21:29 PM
When I first open the sheet I get warnings asking me to 'Enable Editing' and then 'Enable Content'.

Once I click them, stuff works...

Hmmm, I may have to try downloading it again and pay more attention when it opens!  Thanks...

UPDATE: Well, downloaded it again and paid attention this time.  I only received one pop-up, and it said I had to open it as read-only due to compatibility issues!  I'm using version 16.16.2 of Excel for Mac.  I suspect it's the "for Mac" part that's causing the problem!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 02, 2018, 04:32:53 PM
When I first open the sheet I get warnings asking me to 'Enable Editing' and then 'Enable Content'.

Once I click them, stuff works...

Hmmm, I may have to try downloading it again and pay more attention when it opens!  Thanks...

UPDATE: Well, downloaded it again and paid attention this time.  I only received one pop-up, and it said I had to open it as read-only due to compatibility issues!  I'm using version 16.16.2 of Excel for Mac.  I suspect it's the "for Mac" part that's causing the problem!



Yes, that's a Mac thing not supporting macros.  Not much I can do for you there because if that's the case, there is a lot of unsupported code running in the background besides the chart pulldown.  I take it you are unable to send strings from the "Saved Strings" to the charts also?
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on October 02, 2018, 05:22:00 PM
Yes, that's a Mac thing not supporting macros.  Not much I can do for you there because if that's the case, there is a lot of unsupported code running in the background besides the chart pulldown.  I take it you are unable to send strings from the "Saved Strings" to the charts also?

Hmmm...  Probably not since I've been cutting and pasting them...  Dang Mac! 
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: WeeHeavy on October 02, 2018, 07:08:52 PM
I haven't had a chance to play with this version of the spreadsheet but in previous versions, I was able to open as read-only, save as a new document, then open the new document to get everything working in Excel on my Mac. Like I said, I have not tried it with this version yet so YMMV. Still worth a shot.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: PaulT58 on October 02, 2018, 09:12:51 PM
I haven't had a chance to play with this version of the spreadsheet but in previous versions, I was able to open as read-only, save as a new document, then open the new document to get everything working in Excel on my Mac. Like I said, I have not tried it with this version yet so YMMV. Still worth a shot.

I tried that too, it didn't work.  I may have an older version of Office on my Mac, I don't even know what the latest version is.  The one on my Mac is Ver 16.16.2.
Title: Re: Free Spreadsheet from triggertreat Rev 04
Post by: triggertreat on October 04, 2018, 07:35:47 PM

Click here to download the free Rev 04 spreadsheet updated 10-4-18 (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

I made some changes/improvements to the chart axis pulldown selections. I put in a lot more maximum and minimum axis selections in the pulldown for the three main charts to cover more types of string inputs.  This will allow for more manual fine tuning of the chart's axis when displaying the strings for those who to choose to alter Excel's default axis.  You don't have to change the axis, but it does come in handy at times.  I didn't like being limited to what Excel decides the axis should be and is why I put this pulldown in the charts.

I also added in an "Excel Auto" selection so you can easily return back to Excel's automatic axis selections for both the maximum and minimum axis.  It is a good idea to select the "Excel Auto" selection to reset the axis back to Excel's defaults when done with the manual selections so the next string will display correctly and not be off of the chart if it is not within the axis settings.  The "Reset Max" and "Reset Min" will only reset the respected axis back to Excel's auto selection depending on which one you select.

I also added in an additional string description heading for all three charts in the "String 1,2,3" tab.  These new string description will automictically update based on the strings sent to the charts from the "Saved String" tabs.  They will also update with any description you type into the charts "Saved String #" cell located in the notes section.

The below image is the new list of selections in the chart axis pulldown.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: titeuf007 on October 08, 2018, 06:11:49 PM
great software!! it  will  be perfect to have android apk like this..ive never use my laptop on bench and i have to admit  it s not userfriendly
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on October 09, 2018, 01:53:46 AM
great software!! it  will  be perfect to have android apk like this..ive never use my laptop on bench and i have to admit  it s not userfriendly



Thanks for the kind words!  I know the app wont work on every platform out there.  Not sure any app will.  I certainly do wish some apps would work on my PC so I understand the frustrations.  It is what it is and if I knew a way to make it better for everyone I would.  I'm not sure how it would work on these smaller platforms like cell phone and tablets.  There's a lot going on under the hood for this app to do what it does.  It's just an app I built for myself and decided to share if anyone was interested.  Not much else to it than that.  I do have at least one more upgrade coming at some point.  I don't like scrolling and will put in a few macros for easier navigation on some sheets so we can just simply click a button instead of scrolling.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: mobilehomer on October 09, 2018, 02:41:46 PM
great software!! it  will  be perfect to have android apk like this..ive never use my laptop on bench and i have to admit  it s not userfriendly
It works just fine if you install Microsoft Excel. It takes a few seconds to find everything, but it works great.
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: triggertreat on November 16, 2018, 03:14:38 PM

Click here to download the free Rev 05 spreadsheet updated 11-16-18 (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

 A new Rev. 05 version of the Free Spreadsheet App (Rev 05 11-16-18) is now available for downloading.

There are new chart features added like indicators showing Hi/low FPS, FPE and ES results in the charts.  Also, the "String Compare" tab has been revamped to better show comparison results between the three chart strings.  Many other tweaks throughout as well.

I'm going to attempt a video tutorial showing a how to on the many features of this Free Spreadsheet App coming up soon.

Here are some of the new features highlighted in red ovals:



 
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Wolverineshooter on November 16, 2018, 03:52:50 PM
Great work Keith. Lots attention to the details. Thanks. You are well on track going from a shooter to a developer. ;D
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on November 18, 2018, 01:06:50 PM
Great work Keith. Lots attention to the details. Thanks. You are well on track going from a shooter to a developer. ;D


Thanks, but always a shooter.  I am very detailed which frequently gets me in trouble dealing with those that aren't.

Not a developer by any stretch.  I couldn't find a spreadsheet that fit me, so I made my own and decided to share it.  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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: P. O. I. 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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat 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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Marc In Iowa 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!
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat 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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Marc In Iowa 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
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat on November 26, 2018, 02:12:35 AM
 Click here to download the free Rev 05 spreadsheet updated 11-16-18 (https://drive.google.com/file/d/1bp6ztFN7MqbnGLvh9dhwrka80fxTG0fT/view)

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 (https://drive.google.com/file/d/19zkqg807dQFquo-QvmjNyX1UW-SH0xWb/view?usp=sharing)
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: titeuf007 on February 06, 2019, 12:47:23 PM
great job
it will be great to have an adroid apk like that(paid version)
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: archellas on February 06, 2019, 01:46:18 PM
OUTSTANDING work Keith! Thank you for providing this for us.

Cheers
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat 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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: brisner on March 05, 2019, 04:11:46 PM
triggertreat, I got an error message in your spreadsheet today. See below photos.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat 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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: rgb1 on March 05, 2019, 04:48:36 PM
I have tried to download the spreadsheet/tutorial and
get a blank screen. Anybody.........??
       
                                                                  Ron
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: triggertreat 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.
Title: Re: Free Spreadsheet from triggertreat Rev 03
Post by: Hajimoto 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>
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: Gear_Junkie on March 07, 2019, 01:28:54 PM
This spreadsheet is fantastic - THANK YOU!
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: Jonnie 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!
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: triggertreat 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...
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: kenoman742 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
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: triggertreat 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.
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: kenoman742 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
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: kenoman742 on March 09, 2019, 01:40:33 AM
I updated to Office 2016 and the problem went away. It must have been compatibility with Excel 2007. Thanks again for sharing this excellent tool.

Ken
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: Fred J on March 10, 2019, 07:40:30 PM
I have a stupid question: What if I get one (or couple) chrony measurement that comes up as an error. How do I enter this into the spread sheet.

I ask this question because my chrony is somewhat temperamental.

Thank you!
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: triggertreat on March 10, 2019, 07:50:56 PM
I have a stupid question: What if I get one (or couple) chrony measurement that comes up as an error. How do I enter this into the spread sheet.

I ask this question because my chrony is somewhat temperamental.

Thank you!



What I do is enter the previous number again.  That way there is no advantage in the results.  Hopefully there aren't many of those.  The spreadsheet won't like any spaces or letters like Err as it is looking for a number.


Hope this helps  ;D
Title: Re: Free Spreadsheet from triggertreat Rev 05
Post by: Fred J on March 11, 2019, 08:01:48 AM
Thank you!