Free Spreadsheet from triggertreat

[triggertreat]

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!

The rating stars I see in my browser are located at the top of each thread and on the main Darkside thread listings.


It's just another spreadsheet, but there are times when I see members looking for one to use so I decided to offer one up.  If you are in need of one this is one you will be able to download freely without any strings attached.


The spreadsheet is almost complete.  I corrected one error my tester found yesterday and am just waiting for him to run through it again before releasing it.


It does have what I think are some unique features like being able to view three different strings on three different graphs with all of the pertinent info.  It will highlight every shot that is within a 2.09% ES and also a 4.09% ES.  You will also be able to compare those three strings on one screen with just one mouse click.  In addition to that you will be able to compare any two of those three strings with each other on the same graph with one mouse click.  There is also a place to store additional strings that you can copy and past at will into one of the three graphs.


Another feature will allow you to flip your Caldwell strings around from ascending order to descending order and also strip the FPS column out of the data so you can just copy and past that part into the string graphs.


I didn't like being limited to just the Excel auto chart scaling so I added a feature to allow you to change the chart scaling to many different scales and I separated the min and max scale selections in a dropdown style menu which will change them very quickly and easily along with being able to reset them back to Excels defaults too.


The downloaded version will include all of these features mentioned and more, but is not my main master spreadsheet which is a little more complex and hard to share everything it does without some user issues.


None of my spreadsheets I've created compare to my prized spreadsheet I got from SynRodSteve called the Shot String Analyzer which he offers for sale via PM for a small fee.  Steve's spreadsheet is amazing and actually analyses multiple strings for you at once plus tons of other features to numerous to list, but I can't share that one for obvious reasons and is why I created one that I could share.  My spreadsheet doesn't even compare to his, but works fairly decent especially for free.

[Wolverineshooter]

Thanks Keith, looking forward for the new version!

[RONIN001]

I'm looking forward to seeing and playing with your spreadsheet.   I been putting one together off and on for the past year.  I really need to get familiarized with macro side of programing to get Excel to really do what I want.  (at least I believe)  haha

[triggertreat]

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

Click here to download the free Rev 03 spreadsheet

Play with it, have fun with it and familiarize yourself with it.  If you have questions, just ask.  It wouldn't be a bad idea to save a copy with a new filename when you have some strings stored in it for a backup.

The spreadsheet was designed on a 24" monitor in a 2013 version of Excel.  If you are using an older legacy version of Excel, some features may or may not work, but for 2010 and maybe even for 2007 versions it should work ok?

I am viewing the charts will my zoom level set to 80%.  You can use the zoom slider feature in Excel if you are using a smaller screen size for a better fit on your screen.

Hope you enjoy it!

Keith

[RONIN001]

'Read only' for Excel Mac version.   tried both 2016 and 2011 versions

[dan_house]

Keith, have you given thought to doing/redoing this in the Open Office spreadsheet?

ITs free, updates are reasonably frequent. Might open the audience a bit more for folks that dont have Excel.....

https://www.openoffice.org/download/

HTH

dan

[triggertreat]

Keith, have you given thought to doing/redoing this in the Open Office spreadsheet?

ITs free, updates are reasonably frequent. Might open the audience a bit more for folks that dont have Excel.....

https://www.openoffice.org/download/

HTH

dan

Dan, I am not interested in learning a new version of Excel and starting all over with building a spreadsheet, sorry.

[triggertreat]

'Read only' for Excel Mac version.   tried both 2016 and 2011 versions

Sorry Ron, I don't use Mac (too proprietary for my wallet) so I can't help you there.  I know in Windows it will ask you if you want to enable editing when you open the file and when you click yes, you can edit the data.

[SynRodSteve]

Great job Keith.  I haven't downloaded yet but have seen what you've done with your personal version and it's outstanding.  I do have to chuckle a bit at the 'Mac' comments.  I ran into the same thing with mine and like you, had no interest in learning the Mac version but it seems there is a 'need' for this sort of thing for the Mac.  The best answer I think, would be a web app that could be used by all platforms.  Anyway, I'm super impressed with what you've been able to accomplish with yours.

[triggertreat]

Great job Keith.  I haven't downloaded yet but have seen what you've done with your personal version and it's outstanding.  I do have to chuckle a bit at the 'Mac' comments.  I ran into the same thing with mine and like you, had no interest in learning the Mac version but it seems there is a 'need' for this sort of thing for the Mac.  The best answer I think, would be a web app that could be used by all platforms.  Anyway, I'm super impressed with what you've been able to accomplish with yours.

Thanks Steve!  It's not your SSA spreadsheet which I do cherish a copy of, but it was not meant to be either since I have your real deal that I already use.


I agree, having a universal version to please all would be great.  I know your Excel skills far exceed mine, and I would not be the best one to tackle that task.  It does take a lot of hours to build one of these as you well know.  Hopefully some will benefit from my offering which was my only goal.  I did not have a spreadsheet when I first got my PCP.  I worked my way up over time to create one and now I just feel like sharing it for those that are in the same boat as I was, that's all.

[FuzzyGrub]

Thx Keith,  I downloaded it and plugged in a couple of numbers just to see it recalculate.  I will use on my next string collection.  Thx for all the hard work.

[RONIN001]

'Read only' for Excel Mac version.   tried both 2016 and 2011 versions

Sorry Ron, I don't use Mac (too proprietary for my wallet) so I can't help you there.  I know in Windows it will ask you if you want to enable editing when you open the file and when you click yes, you can edit the data.

Me or my wife never had an issue with this before.  Us snobby Mac "commuters" will have to do with out then LOL

thanks for share either way! 

[triggertreat]

'Read only' for Excel Mac version.   tried both 2016 and 2011 versions

Sorry Ron, I don't use Mac (too proprietary for my wallet) so I can't help you there.  I know in Windows it will ask you if you want to enable editing when you open the file and when you click yes, you can edit the data.

Me or my wife never had an issue with this before.  Us snobby Mac "commuters" will have to do with out then LOL

thanks

I am curious if you have macros enabled which it does have.  This may be the issue if not enabled.

[RONIN001]

Im trying to update both versions so can not re-check to confirm.  Though, if I recall I believe it prompts you that it has Macro and if I wanted to enable or disable I tried both to no avail. 

back to the drawing board of getting my program up and running.  Like I said earlier I need to fine tune my macro skills and yes it is a lot of work as you stated.

[triggertreat]

Thx Keith,  I downloaded it and plugged in a couple of numbers just to see it recalculate.  I will use on my next string collection.  Thx for all the hard work.

Good deal and sounds like it is working for you.  I have been waiting to see someone confirm it's working for them besides me.  I did download it to another pc and it was fine on it.  My tester has some pc woes so I didn't really get a warm and fuzzy from him (no pun intended).

[RONIN001]

apperantly there is some sort of content not supported as stated in Excel:

 "This workbook contains content that isn't supported in this version of Excel." 

"To view the unsupported content in the file, you can open the workbook as read-only. However, if you change and then save the workbook, unsupported content will not be saved."

I can see all the worksheets but just all locked because of this mystery content thats not on Mac windows Excel. 

What a stinker... hoping to learn something

[triggertreat]

Well I hate that for you Ron.  Wished it would work for you.  There is no telling what Mac is rejecting.  It could be the macros, graphs, formulas, security,  etc.  In addition to all of the different formulas, there are a number of offset formulas too, so Idk.

[BSJ]

Works well for me in Excel 2013. Look forward to using it more extensively.

Minor complaint. The lowest maximum is kinda high for pistols.

[triggertreat]

Works well for me in Excel 2013. Look forward to using it more extensively.

Minor complaint. The lowest maximum is kinda high for pistols.

Good to know.  What additional maximums would you want?  FWIW, reset max and reset min are Excel's auto scale defaults which should scale better for you at the lower velocities.

[WeeHeavy]

Thank you, trigger, for the work you've done on this! It is very useful. I have been envying your spreadsheet for some time. 
I also had the same issue with the Mac version of Excel reported by RONIN001. The error states that there is unsupported content and the options are to abort opening the file or to open as read-only. The warning goes on the say that if opened as read-only, you can save a copy of the file but the unsupported content will not be saved if you do. I saved the read-only file as a new file and opened the new file. No error. No obvious change in function of the spreadsheet. Just thought I would pass that along.