Official Release Simple PCP Calculator / Mobile

Simple PCP Calculator Mobile version Release. 



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 1584842705_6079582645e76c7d1a96c26.35742214.jpg View attachment 1584842711_1066357835e76c7d7a75469.26696610.jpg View attachment 1584842723_325979285e76c7e381b138.03037681.jpg View attachment 1584842737_11312755755e76c7f15866c8.72127619.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 and being sized to a mobile display. I will create another thread for the advanced PC version once its released and leave this thread for the mobile version. No major plans on making changes or updating unless I feel like learning google app scripts.
 
Hi akuric,

When you say "Simple PCP Calculator Mobile version Release " do you talk about IOS ou Android Version?

If Yes, what's the name of the apply?

Thanks for all.




This works for any mobile device that can access google sheets, so it should work fine on IOS/Android/Iphone. Its not a mobile app rather a spreadsheet thats layout is designed for mobile devices. Thanks for your inquiry and hope this helps.
 
Hope to be able to use the final app (or program) to estimate (within 1-2%) pellet velocity.



The simple version (already released and available in original (ods / open office) format and excel) and this version (google sheets) both calculate those estimations which generally end up within 1-2% of real world data provided you input the correct data from your rifle. The final spreadsheet will just have a TON of added features, such as fpe losses based on port size/barrel length/pressure drop (reg volume), hammer data (speed, lock time, energy and comparisons), shot string analyzer (10 per gun/10 guns) that has a function to determine loss from chrono distance and add to the string if desired, as well as custom acceptable ES (graph will give a good visualization of what is within and what is outside of said custom ES), comparison of strings,guns, and projectiles, max shot calculator, tank fills calculator, more enhanced external ballistic data, ability to run in both metric and imperial (across the board, even converts all current data to metric or imperial(optional)). The advanced version will basically take care of all the needs your average, and more advanced pcp user needs. I am always open to add more as well! Suggestions always welcome.



-Matt
 
ackuric,

thanks A LOT for writing this!

I have always been disappointed by the mobile version of ChairGun that did not allow me to calculate the BC from two velocities, and a host of other things (that the PC version does wonderfully... ✔️). 



Now, your ballistic calculator does a huge amount of calculations — and all in my pocket! 



Please, help me out, what is this thing you created really?

A spreadsheet? OK, but on what program does it run (I use M$Office Excel — which program or rather which app does your ballistic calculator use?)

Do I need to be in GoogleDocs to use it, or can I save the file to my phones external memory card?



Thanks again for all your effort. After the shutdown of ChairGun last year this seems like a huge step forward for us airgunner that like to shoot by the numbers! 😄



Matthias
 
Hope to be able to use the final app (or program) to estimate (within 1-2%) pellet velocity.



The simple version (already released and available in original (ods / open office) format and excel) and this version (google sheets) both calculate those estimations which generally end up within 1-2% of real world data provided you input the correct data from your rifle. The final spreadsheet will just have a TON of added features, such as fpe losses based on port size/barrel length/pressure drop (reg volume), hammer data (speed, lock time, energy and comparisons), shot string analyzer (10 per gun/10 guns) that has a function to determine loss from chrono distance and add to the string if desired, as well as custom acceptable ES (graph will give a good visualization of what is within and what is outside of said custom ES), comparison of strings,guns, and projectiles, max shot calculator, tank fills calculator, more enhanced external ballistic data, ability to run in both metric and imperial (across the board, even converts all current data to metric or imperial(optional)). The advanced version will basically take care of all the needs your average, and more advanced pcp user needs. I am always open to add more as well! Suggestions always welcome.



-Matt

Sounds good. As long as it's user friendly. Where would you be able to get the correct measurements? I assume that if your PCP is stock and not modified the data would be the same for everyone. Where would you get that data for the Impact 1st Gen .22 and .25 or the .22 FX Crown?

Never mind, just noticed your post: https://www.airgunnation.com/topic/popular-gun-specs-data-request/ Excellent!
 
mtnGhost, it's a Google Sheets spreadsheet. It exists in "the Cloud"--on a remote server (the author's Google Drive). As such, not really intended to be attached. Here are a couple of ways to create your copy:



Method 1 - This method makes a copy of the file/app in your Google Drive. You will also be able to make your copy "Available offline" for use in areas without Internet access. Using this method, you will be able to access your copy from any device.

  1. Download and install Google Sheets.
  2. Click the hyperlink provided by the OP: https://docs.google.com/spreadsheets/d/1Y7Boso1AgFxWk1ZiNoCStnT1K8hDpS4r_m73gSsj96Q/copy
  3. Do NOT edit this version of the file. CLOSE the file/app (back-arrow at top-left of the file).
  4. If necessary, open Google Sheets App on your phone.
  5. The file will be the very first (top-left) file in your "Last opened by me" list. Click the three vertical dots immediately to the right of the filename.
  6. Select "Make a copy".
  7. Choose the Google Drive folder where you want to store your copy or just click "OK" to save it in your Google Drive main directory (called "My Drive")
  8. If you want to be able to use the file in a location that does not have Internet access, click the three vertical dots in the upper-right corner of the spreadsheet and choose "Available offline".
    [/LIST=1]



    Method 2 - This method saves a local copy on your device. You will only be able to access this copy from the device you use to download the file.
    1. Download and install Google Sheets.
    2. LONG PRESS the hyperlink provided by the OP: https://docs.google.com/spreadsheets/d/1Y7Boso1AgFxWk1ZiNoCStnT1K8hDpS4r_m73gSsj96Q/copy
    3. Select "Download Link" from the menu.
      [/LIST=1]

      EDIT: Ignore Method 2. It gets kind of finicky and sometimes very slow after step 3, and it doesn't accomplish anything that you can't do with Method 1.
 
Thanks for your time and effort with the explanation Kirkb! Hope you find some use from this! 



Small update. Changed a few things around with the GUI, and added the ability to retrieve local weather data for wind/temp! Screenshot below of changes. Same link as in original post as any update I make will apply to that sheet, you just need to make a new copy and copy your data over which should be super easy with a copy+paste of your gun or ammo data. 


*Once your State/City data is entered ( on the GunDB sheet ) , the spreadsheet will update every 10 minutes* Currently only set to work for US states as I am too lazy to code for international atm, but later I likely will!



View attachment 1585353520_13130902945e7e93303480c2.24933640.jpg
 
mtnGhost, it's a Google Sheets spreadsheet. It exists in "the Cloud"--on a remote server (the author's Google Drive). As such, not really intended to be attached. Here are a couple of ways to create your copy:



Method 1 - This method makes a copy of the file/app in your Google Drive. You will also be able to make your copy "Available offline" for use in areas without Internet access. Using this method, you will be able to access your copy from any device.

  1. Download and install Google Sheets.
  2. Click the hyperlink provided by the OP: https://docs.google.com/spreadsheets/d/1Y7Boso1AgFxWk1ZiNoCStnT1K8hDpS4r_m73gSsj96Q/copy
  3. Do NOT edit this version of the file. CLOSE the file/app (back-arrow at top-left of the file).
  4. If necessary, open Google Sheets App on your phone.
  5. The file will be the very first (top-left) file in your "Last opened by me" list. Click the three vertical dots immediately to the right of the filename.
  6. Select "Make a copy".
  7. Choose the Google Drive folder where you want to store your copy or just click "OK" to save it in your Google Drive main directory (called "My Drive")
  8. If you want to be able to use the file in a location that does not have Internet access, click the three vertical dots in the upper-right corner of the spreadsheet and choose "Available offline".
    [/LIST=1]



    Method 2 - This method saves a local copy on your device. You will only be able to access this copy from the device you use to download the file.
    1. Download and install Google Sheets.
    2. LONG PRESS the hyperlink provided by the OP: https://docs.google.com/spreadsheets/d/1Y7Boso1AgFxWk1ZiNoCStnT1K8hDpS4r_m73gSsj96Q/copy
    3. Select "Download Link" from the menu.
      [/LIST=1]




    1. I'm a veteran dev/sec/cloud ops engineer 😂, reason I asked is because I manage a device policy that blocks google web requests, and I'm semi-off grid right now and wanted to get access to the file. 
 
Kirk, 😊

thank you for the excellent explanation -- I'm no software engineer, but with your detailed steps I can handle this. I appreciate the time you took to write this.



Matt (aka ackuric), 😊

Thanks again for the ballistic calculator. And that you are already updating it. To have something so powerful to carry around in my pocket means A LOT to me.



Both of you deserve a bunch of green praise dots (not sure why they are called "Accuracy" at AGN). Giving mine now!



Matthias


 
mtnGhost, it's a Google Sheets spreadsheet. .... As such, not really intended to be attached.

I'm a veteran dev/sec/cloud ops engineer...

In that case maybe you can provide the instructions on how to attach a Google Sheet to a post.



mtnGhost

...reason I asked is because I manage a device policy that blocks google web requests, and I'm semi-off grid right now and wanted to get access to the file.

You could have mentioned that in your first post. You'll get better results if you provide upfront the information someone would need in order to help you in your specific and unanticipatable situation.
 
Version 1.3 now released. Changes/Additions below:



  • Added port size as a variable to pressure loss within the bore to determine plateau fps (ultimately increased predicted plateau output by ~.5% and imo better represents the pressure loss within the bore. Increase you may ask? Why yes, previously I was using the port size difference from bore to subtract a loss from the energy output, as opposed to now where I include its differential as a variable to calculate average pressure which ultimately is a primary key in this calculation)
  • Regulator refresh rate included in pressure drop calculation during shot cycle which effects predicted plateau fps greatly
  • Valve optimization sheet (aids in determining optimal poppet/seat dimensions/sealing margins)
  • Valve optimizer also calculates the average angle your air turns into the valve passed the poppet, and tells you the force applied on your sealing margins + more
  • Pipe burst calculator using barlows formula
  • Fill calculator (hand pump calculation is purely estimated and more of a WAG, the tank fill is accurate minus the fill hose not being taken into account...for now)
  • Peak FPS now limited more with extraordinarily light projectiles, bringing them more within reason (only applies to the likes of 1-3 gr projectiles)
  • And other minor tweaks


Updates will always be available via the original link, which makes rolling these updates out really simple.



If you have any requests or anything you'd like to see changed, feel free to comment and I may consider.
 
v1.33



Change:
Added fps variance + spread visual on external ballistic sheet. Added temp/altitude variables, and a few other minor UI changes that got rid of what I found unnecessary back end data in exchange for more important shooter data (vertical and horizontal spread)



New Bitmap Image.1618289525.png

 
  • Like
Reactions: kirkb