Simple PCP Performance Calculator

Jump to latest Follow Reply
Thanks. Its a work in progress that I will continually develop and add bits to, while trying to keep it simple in form, while rich with data/features.



I'd be more keen on a web based version. I don't mind phone/android apps but I believe web based apps are far superior because literally any device with Internet can access it, where as if you go the android route, you have to support multiple platforms, such as android, iphone, IOS, windows, and mac...its a lot easier to make a mobile friendly website than it is to cover 4+ platforms.

-Matt
 
Upvote 0
I'd be more keen on a web based version. I don't mind phone/android apps but I believe web based apps are far superior because literally any device with Internet can access it, where as if you go the android route, you have to support multiple platforms, such as android, iphone, IOS, windows, and mac...its a lot easier to make a mobile friendly website than it is to cover 4+ platforms.

-Matt
Click to expand...



Well said! I could not agree more :)
 
Upvote 0
Long time since I updated. Tons of features added, few bugs worked out and a tweak or two here and there. If this is of use to you, then enjoy!

View attachment 1582623709_6415437015e54ebdda7d035.35798523_New Bitmap Image - Copy.jpg

View attachment 1582623702_1615227255e54ebd623bd72.15757438_New Bitmap Image.jpg



download.png
View attachment 1582661574_16911322105e557fc676fd64.19514335_PCP_Performance_Calc.ods





This is a simplified version of my pcp performance/internal ballistic calculator. The enhanced version remains proprietary for now as its way to advanced for the avg joe and still a work in progress.





View attachment 1582406372_11298979425e519ae4ec85f9.21339961_pcpperf.jpg
 
Upvote 0
Well, the last 3 weeks this spreadsheet underwent a huge transformation, its not so simple anymore...With additions ranging to saving up to 10 tunes/strings, compare mode, an up to 100 shot string analyzer with custom ideal es range, can calculate loss from distance to chronograph and add it to the entire string automatically if desired, to a projectile database that calculates ideal twist rates, stability factor and bc, to dark/light mode, and much more shown below, the pictures will speak for themselves. Pictured below is whats to come, currently in beta testing by myself as this powerhouse of a spreadsheet runs on 100 pages of macros, where as the last sheet ran on 0 macros. I may update the simple version more to maintain a 0 macro aspect for easy portability, but this was a fun little project for me. I cannot promise a release date but I intend on having it polished/completed by the end of this month.

All the data the user needs is basic rifle information and air usage, the complicated data can be set to auto or be set by user!



*max size of sheet in compare mode with fps list shown on main sheet is 1880x1060, which was my goal to keep it under the 1920/1080 mark for 1080p users. There are 4 modes, advanced, slim, compare, and shot string graph on/off to make it easy to isolate a certain focal area.





View attachment 1584140308_8055451335e6c1014859325.64686784.jpg



View attachment 1584141068_3710122225e6c130c3983a3.21100875.jpg



View attachment 1584141080_20202514155e6c1318d94d28.73440005.jpg



View attachment 1584143877_14060290365e6c1e051beb42.59458144.jpg



View attachment 1584139211_16200662745e6c0bcbb53386.51613724.jpg



View attachment 1584139225_15730335175e6c0bd9a7d433.67944253.jpg


 
Upvote 0
New additions:



10 strings - 10 guns, that is 100 strings total that can be saved. I'll never need that many but to round things off well I decided on that number. Now I wish I used a database and sql to store/retrieve data but ah well.



Added trajectory mapping and comparison. Big work in progress, what you see below I threw together in a days work, everything from slope calculations, to wind angle / speed, to temp/altitude, to scope height, to spin drift is being considered here. The results I've come up with land me right in between sterlok pro and chairgun (both give different results), which I am pleased with. This is by no means meant to be a trajectory / external ballistics spreadsheet but I figured it be cool to add. Now the sheet covers everything from internal ballistics to external!



View attachment 1584663308_14741279125e740b0c4621a7.24383303.jpg



View attachment 1584663317_16306931835e740b15ea9097.53078031.jpg
 
Upvote 0
Upvote 0
FX impact ports are pretty well published but I don't recall them off hand. On the release of this I'd like to have some of the more popular guns data already loaded into the sheet. 



Current look of the mobile version. I just have to write a few scripts to load/save data dynamically so there isn't a messy 'list' to look at for the user and then its done. I will likely start that this week. The cool thing about the mobile version is you can access the sheet both online and offline in situations where you may not have internet access you can still plug some numbers! 





View attachment 1584813975_18962098835e765797b4e5a4.67551478.jpg View attachment 1584813985_1356004795e7657a18d87d0.35643222.jpg
 
Upvote 0
Mobile version (1.0 no scripts) Release. 

I opted against writing scripts (for now) as I am NOT savvy in google apps language so that will take me quite some time. This version has editable fields to add your ammo / gun data and then you can simply select them from the main screens without having to re-enter data. The later version would cut down the 2 extra menus and allow it all to be done on the 'main' screens.


The simple mobile version includes:

  • max fps based on gun/ammo parameters
  • efficiency calculation (fpe/ci, and other air usage data including thermal efficiency)
  • pressure gradient for tune and plateau
  • comparison charts for changes in a single gun parameter (plenum size, barrel length, port od, pressure, caliber)
  • trajectory calculation along with some additional trajectory data (currently done in MIL only, no plans on supporting moa)
  • bc calculator from far/near velocity and distance between two.



Here are this versions pictures and link to make your own copy (be advised, on edited copies you can edit formulas/fields that will change how the sheet works, I made the lay out pretty self explanatory as to what fields to edit and which to leave.)

View attachment 1584829449_1144797465e7694094b4eb3.65894740.jpg View attachment 1584835640_16126202625e76ac382dd432.56932218.jpg

View attachment 1584829593_15871637485e7694993896c8.02107992.jpg View attachment 1584833981_14028233275e76a5bd6335f5.28604099.jpg



https://docs.google.com/spreadsheets/d/1Y7Boso1AgFxWk1ZiNoCStnT1K8hDpS4r_m73gSsj96Q/copy



*the advanced version coming in a few weeks will have an incredible amount of more data, and functionality but will only be accessible via PC using open office, where as this version is quite simple, and universal being available on google sheets.


 
Upvote 0
the port size in the spread sheet.....which one should be put in here? Is this the barrel port, the transfer port, the exhaust valve port, smallest port in the system, largest port in the system....?
Click to expand...



It would be quite odd to add 3 port conditions and then have the sheet verify which one is the smallest, the answer is your port od. Port being the path from air to pellet. How would the largest port in the system be beneficial, say if you run .25 full bored valve and barrel port but with a .14 choked transfer port, how would one come to the conclusion that their overall porting is .25?

Obvious answer is smallest port od from air to pellet, be it valve,transfer, barrel or valve throat minus valve stem....
 
Upvote 0
ty. i realize having multiple port sizes would complicate the application. i just was looking for a bit of clarification on which was the proper one to use. i was basing mine off the gauntlet .25 which is mostly stock except my barrel port has been enlarged. and have aftermarket poppet in it. but i have my measurements for barrel port, receiver port, tp tube, valve exhaust. never measure my poppet which i should have done. i know it has a .078" stem.

But you answered my question on using my smallest port which is my barrel currently. and i thank you. nice work on this spead sheet again
 
Upvote 0
I must say that this is one impressive bit of work! I was actually doing the research to make a spreadsheet to simply try to develop some power and velocity curves to model the performance of my FX Crown with different pellet weights at varying reg pressures. This far surpasses what my original intentions were and I take my hat off to you!

Unfortunately I do have a problem though and that is that I am on my work computer and the security software has blocked me from editing and says that it may be unsafe for my computer. I am just wondering if it uses any macros and if this might be why Sophos is preventing editing? If it is, I may be able to work around it.

Cheers for that!
 
Upvote 0
I am having a play with the workbook but it appears that some of the features are not working, most likely due to Excel version differences. Which version of Excel did you use to make this? I am thinking that I have an older version that is not supporting some features. The sliders are not working for me. There may be other features not working as well, but that is what sticks out initially.

I am about to start doing some mods on my gun and it would be very cool to be able to test theoretical against observed data.

Very cool spread sheet! Well done!


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