Free spreadsheet from Triggertreat

Jump to latest Follow Reply
triggertreat

triggertreat

Member
Oct 22, 2017
1,060
60
Pensacola, FL, United States
Here is a free spreadsheet anyone can download if in need of one: Click here to download the free Rev 05 spreadsheet updated 11-16-18 ​This free spreadsheet will give all of the typical data including the efficiency if the inputs are correct along with highlighting all shots that are within a 2% or 4% ES. It is geared towards storing up to three strings and comparing them. You can do a save as to store three more strings and so on. It also has a sort and flip section for the Caldwell chronograph data that will flip the string around from ascending order to descending order and strip out just the FPS data so you easily copy and paste into the chart string sections. There is also a tab you can paste additional strings in to for later analysis. Enjoy! Keith



Here is a video tutorial showing how to use the free spreadsheet app: Click here to download/view the Rev 05 spreadsheet tutorial
 
  • Like
Reactions: Diamondback
No YT video, but something to consider, sorry. The SSA is a lot more complex than this one for sure. This spreadsheet is fairly straightforward. Just input your FPS velocities into the FPS column and put in your start/stop PSI and pellet weight and that should give you most of the data. For the efficiency of your string, input your reservoir and plenum cc (if regulated) and it will give you the efficiency result. I will note that the Lbs/shot data is an average over the course of the string.

​I encourage everyone who uses it to play around with it. I don't think you can hurt it or screw it up because I have all of the formulas and graphs locked down to prevent that from happening. Plus, you can always download it again. If you can click on a cell, you can input data and if not it is locked to prevent issues.

​I will be happy to answer any questions one may have on its use. Just post them here.
 
Upvote 0
I don't quite get that except that they must have a fixed range. You shouldn't have that issue with this spreadsheet. The scaling or ranging of the charts are automated based on the input values. One thing I didn't mention is the custom manual chart scaling you can do. If you look on the main charts you will see a dropdown box with some different chart scaling selections once you click on it. "Reset max" and "Reset min" brings you back to Excel's defaults for the maximum velocities and minimum velocities so play around with some of the other manual selections I put in there. Just stay above your max velocity and don't go below the max for the upper scale selection. The "Chart scale" selection just returns the cursor back to the upper left corner cell of the sheet and just displays "Chart scale" on the dropdown window so don't expect the chart to change with that one. Again, "Reset max" and "Reset min" will bring you back to Excel's automatic scaling/range for that particular strings input values. You can reset the max or the min without resetting the other too if desired.
 
Upvote 0
I tried using the "flip your chrony string" section, but it doesn't seem to work for me.
Is there a command key or something I'm supposed to press to get the string to display in the very right hand column, stripped of all extra and unnecessary numbers?
I'm thinking maybe it's because my spreadsheet automatically opened your spreadsheet in "protected mode", yet even though I told it to enable all functions, it doesn't seem to work?
For example, if I go to your chrony string of 33 shots & delete one, I still have 33 shots displayed in the "stripped" shot string.
I'm using a full version of Excel 2016 i Windows 7.
 
Upvote 0
  • Like
Reactions: Crusher
Upvote 0
Not sure if you have this in your spreadsheet but its good data. I use a very sophisticated spreadsheet thats still under development and don't mind sharing bits here and there! If you already have this data then I apologize but you get a free thread bump out of it. Feel free to use it, tweak it, or leave it :D



Pressure Drop (PSI) (averaged for non regulated)

=If (RegV > 0, ROUNDUP((PsiStart-PsiEnd)/Shotcount * (HpaVolume/RegulatorVolume),2), ROUNDUP((PsiStart-PsiEnd)/Shotcount ,2))

(CC use per shot) (averaged for unregulated)

=if (RegV > 0, round(RegulatorVolume*PressureDrop/RegPSI,3), round(HpaVolume*regpdrop/((PsiStart+PsiEnd)/2),3))



Now that the above data is obtained you can get the Air Mass Ejected per shot, and pellet weight ratio..I am too lazy to write one for unregulated right now, but here is how I do it regulated.



I multiply by 1000 to get MG 

=round(round((RegVolume*RegulatorSetPoint) / (RegulattorSetpoint-PressureDrop) - RegVolume,2) * AirDensity,2) * 1000



Air density is found by this formula... (287.058 is the gas constant for dry air, and 14.5038 is a constant to convert Psi hpA) Answer is in g/cm3

=ROUND(((AvgPressure/14.5038 / (287.058 * TempKelvin))) * 100,6)



Temp in kelvin is found by this formula:

=(AmbientTempInF- 32) * 5/9 + 273.15



Now that you have Air mass ejected in MG, you can simply take the pellet weight and convert it to MG or take the MG weight of Air and convert to grains to obtain the air to pellet weight ratio. I know you like to keep adding stuff to your spreadsheet so, if you find this information helpful, enjoy!



-Matt
 
Upvote 0
can you input data manually,like from a master chrony--just off of the chrony printer, like fps-extreme spread,& ect? ? tks.

I'm not quite sure I understand your question fully, but yes you can input FPS data manually. The ES however is calculated within the spreadsheet and is not something you need to input or can input.
Click to expand...


 
Upvote 0
works great----after you watch the vid. & read the instructions,,of course that is the last thing i do.....thanks for all the hard work.



Thanks for your interest! I am glad it's working for you. Sorry for the less than stellar tutorial video. I just came off of an 8-hour drive and was jet lagged, but wanted to get something out there. I may do a redo.
Click to expand...


 
Upvote 0
Triggertreat,

I want to thank you for uploading this fine piece of work. I know how much work it takes to put something like this together and I want to thank you for sharing with us.

+1 for you.



Crusher

Thanks Crusher! It did take a good bit of time to work out the calculations and details. It's certainly a one of a kind. I built this for my needs, but then decided to share it with others who may be in need of a detailed spreadsheet like I was.
Click to expand...


 
Upvote 0
Not sure if you have this in your spreadsheet but its good data. I use a very sophisticated spreadsheet thats still under development and don't mind sharing bits here and there! If you already have this data then I apologize but you get a free thread bump out of it. Feel free to use it, tweak it, or leave it :D



Pressure Drop (PSI) (averaged for non regulated)

=If (RegV > 0, ROUNDUP((PsiStart-PsiEnd)/Shotcount * (HpaVolume/RegulatorVolume),2), ROUNDUP((PsiStart-PsiEnd)/Shotcount ,2))

(CC use per shot) (averaged for unregulated)

=if (RegV > 0, round(RegulatorVolume*PressureDrop/RegPSI,3), round(HpaVolume*regpdrop/((PsiStart+PsiEnd)/2),3))



Now that the above data is obtained you can get the Air Mass Ejected per shot, and pellet weight ratio..I am too lazy to write one for unregulated right now, but here is how I do it regulated.



I multiply by 1000 to get MG 

=round(round((RegVolume*RegulatorSetPoint) / (RegulattorSetpoint-PressureDrop) - RegVolume,2) * AirDensity,2) * 1000



Air density is found by this formula... (287.058 is the gas constant for dry air, and 14.5038 is a constant to convert Psi hpA) Answer is in g/cm3

=ROUND(((AvgPressure/14.5038 / (287.058 * TempKelvin))) * 100,6)



Temp in kelvin is found by this formula:

=(AmbientTempInF- 32) * 5/9 + 273.15



Now that you have Air mass ejected in MG, you can simply take the pellet weight and convert it to MG or take the MG weight of Air and convert to grains to obtain the air to pellet weight ratio. I know you like to keep adding stuff to your spreadsheet so, if you find this information helpful, enjoy!



-Matt



Thanks Matt! I do have an average PSI drop already in the spreadsheet, but will take a look at this to see if it's better, and if so will consider a revision.
Click to expand...


 
Upvote 0
You must log in or register to reply here.
Top Bottom
Back
Home
Forums
Resources
Menu