Free Spreadsheet from triggertreat

[RONIN001]

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.

hmmm... and it it was unlocked? What file formate did you save at as?

[keithd]

Great job thanks!!

[Rat Sniper (AKA: PaulT58)]

I have a question, maybe I missed it and if so I apologize...  What value are you looking for in the field labeled Regulated cc? 

I'm assuming the Reservoir cc is the volume of the air cylinder, but I'm unclear on the other... 

I plugged in the numbers for my Gauntlet with the 13ci bottle and the 23ci bottle before and after adding a washer to the regulator and got some interesting results!  This is a great tool!  Thank you for sharing it...

[triggertreat]

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.

Thanks Robert and glad you like it.  I didn't really know Excel when I started this journey and still have much to learn about Excel.  Being a novice, it took a lot of time and YT videos to figure this all out, but I enjoy a challenge when it's fun stuff.


Thanks for your help with figuring out the Mac woes as I was helpless there.  Hopefully RONIN001 can get his going now.

[triggertreat]

Great job thanks!!

Thanks! Enjoy it

[triggertreat]

I have a question, maybe I missed it and if so I apologize...  What value are you looking for in the field labeled Regulated cc? 

I'm assuming the Reservoir cc is the volume of the air cylinder, but I'm unclear on the other... 

I plugged in the numbers for my Gauntlet with the 13ci bottle and the 23ci bottle before and after adding a washer to the regulator and got some interesting results!  This is a great tool!  Thank you for sharing it...

The regulated cc input refers to the regulated plenum space between the regulators output and the valves seat.  The more accurate the regulated cc, reservoir cc and PSI start and stop inputs are, the more accurate the efficiency data will be.  If no regulator then that input would be zero.


I like getting as accurate as I can with my numbers so I took fluid measurements of my plenum space and my remaining reservoir space to know what they are with my particular setup.  1ml is equal to 1cc so it's pretty easy to get a syringe with ml markings and measure these spaces with water.  It just takes a little time to do so.


Those strings in the spreadsheet are from another Marauder with an SS valve and are not my strings, but the res cc and reg cc inputs are mine and are the results of my fluid measurements which would be very close for any other Huma regulated Marauder with a stock reservoir that does not have a plenum extension of some sort.

[triggertreat]

One thing to keep in mind on the spreadsheet is the lbs/shot data and the PSI data per shot on the graph.  This data is the average pounds per shot data used over the full string.  We know that our guns are more efficient at the start with the higher pressures so if you're monitoring or jotting down your pressures as you shoot, you may be in disagreement with the lbs/shot data or the psi data showing on the graph for each shot which would be fair.  I am not sure how to calculate the data to match the changing efficiency of the air use throughout the shots but at least we have the average PSI use over the string to look at.

[Rat Sniper (AKA: PaulT58)]

Thank you for your answer!  I did a quick calculation from the cubic inch value of the tank to cubit centimeters, but I'm not to sure about the regulator cc measurement.  These tanks use the Ninja paintball regulators, so I'm sure some searching may result in some measurements some one else has already taken.  Thanks again for the spreadsheet, it gives a great visual of what the rifle is doing over the entire string!

[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.

hmmm... and it it was unlocked? What file formate did you save at as?

I saved it as a standard .xlsm file (I'm using Office 2016 on Mac). I closed the file I had open and opened the new copy, which was then read/write as it should be. Hope that helps.

[Wolverineshooter]

Thank you Keith for the great work!

[archellas]

Super job Keith! Really neat to see different strings and compare when tuning!

One issue .. when I go to save, I get an error message (from VB I think)

Just letting you know.

BTW, running Win7 with Excel 2013+

Cheers

[Wolverineshooter]

I have no issues in saving - I have Win10, Office 2013 

[triggertreat]

Super job Keith! Really neat to see different strings and compare when tuning!

One issue .. when I go to save, I get an error message (from VB I think)

Just letting you know.

BTW, running Win7 with Excel 2013+

Cheers

Thanks TJ!  Yes, being able to compare strings can come in handy and is why I put that in there.


The spreadsheet can handle a 186 shot string which I thought may be handy for most .177 strings, but the graphs may get a bit cluttered with that many shots.  At least we will still be able to see the important data though.


Never tried that mix.  Maybe try a save as and rename?

[triggertreat]

Thank you Keith for the great work!

Thanks Greg!  You are using the same versions I have and is what the spreadsheet was built on.  Enjoy!

[triggertreat]

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

Click here to download the free Rev 03 spreadsheet

[triggertreat]

Just checking the site and it appears all is still up and working.


It has been nearly a month and a little over 1300 views since the release of this spreadsheet.  I haven't heard much about issues so I trust all is well and at least some of you are getting some use out of it    Cheers!

[WeeHeavy]

I haven't shot any new strings over the chrony, but I have transferred old strings from my own rinky-dink spreadsheet to the one you posted. Nothing stands out as a problem as results seem to mirror the ones from my own. Of course it is much easier to identify where adjustments could/should be made with yours. It would seem that the initial error we saw when using Office on Macintosh was probably a gimme and does not appear to affect the calculations or visual representations provided by the spreadsheet. A simple open as read-only and Save As a new document gets that sorted nicely. Still loving the excellent work you've done there! Thanks again and Happy Holidays!

[Doveteck Outfitters]

Thanks for this triggertreat!!!! Looks great and definitely will be useful!!!!

[triggertreat]

Thanks for this triggertreat!!!! Looks great and definitely will be useful!!!!

Welcome to the forum!  Glad you were able to find it and you like it.  Post some strings with it once you get settled in.  We like to see strings and tunes here on the forum.

[Rambler]

What a great spreadsheet! Thanks for doing this, and making it available.