Popular Gun Specs/Data Request

Bumping this with request for a few more candidates prior to getting closer to the release. I will be entering in the Gauntlet details as one of the defaults as I feel its popular enough to earn a spot! Thanks dannya1a. If anyone with an impact or FX variant has the above information that would be greatly appreciated.



Here are photos of the sheet in its current state. There is a dark and light mode, pictured is dark mode. Cheers!

















Features:

-Sheet automatically saves/stores data when needed
-Sheet automatically resizes to fit the data on the sheet (on 100% zoom, this function will break at any other and you will have to manually resize, its better to use the zoom function via your operating system (windows) under display settings if you find text small), also the big shot string can be maximized up to 4k displays for FULL viewing potential on large strings.


Main:

• -Store data from up to 10 guns to be able to compare them or review them on the fly!
• -Customize gun names, ie: gun model
• -Copy a guns data to another guns data
• -Calculate peak fps/energy from a given combination of pressure/barrel length/port size/caliber/pellet weight/reg volume
• -Show pressure gradient from both tune and plateau, both are close approximations that give you an idea of whats happening internally, as well as residual muzzle pressure
• -Adjustable projectile friction
• -Adjustable valve close @ peak (nominal is 45-50%)
• -Calculate efficiency from a current tune/string
• -Tons of data including cc use per shot, fpe per gram of air, mg ejection, air density, pressure drop, ports max flow (mg/ms), and more.
• -Fpe losses from barrel length / port size / pressure drop caused by regulator
• -Hammer data including: Energy / Lock time / Velocity
• -Allows you to add a 'balanced valve' ratio which applies to hammer data only
• -Compare strings+tunes, rifles, projectiles, and hammer data + more!
• -Metric + Imperial input+outputs with option to convert current inputted data to desired setting
• -Load Projectile Data directly from stored data
• -Calculates ideal barrel twist rate, ballistic coefficient, sg factor, tank fills, max shot count (based on current air use + assumed fill range),wound depth, fps loss from creep, ideal pressure based on desired fps, and much more!
• -Calculates optimal Valve Throat OD based on current porting and your stem's OD in throat!
• -Light + dark mode
• -Hide advanced data, string graph, comparison and slim it down extra with a click of a button, there are 16 possible configurations total.

String shot analyzer:

• -10 guns, 10 strings per gun, 100 shots per string. That is 10,000 shots!
• -Ultra wide screen mode, can be displayed in 1080, 1440p, and 4k resolutions
• -Splatter target graph that shows your extreme spreads variation at whatever distance is set by the user. Two modes, randomized 5 shot group with fps within your string or 2 shot high/low from your string!
• -Compare any two strings from the same or different guns. side by side, including the splatter target!
• -Side by side or split graph mode when comparing two strings!
• -Calculate loss from chronograph distance and optionally add it to the entire string automatically!
• -Custom es range (graph will give a good visual of what is within and what is outside of said custom es)
• -fps high, fps low, fps within, fps outside and longest sequence of shots within es% graph markers, and an option to turn them off
• -Shows the % below your setpoint achieved
• -Calculates shots on/off regulator for you
• -Dynamic FPS list that is created upon user request, no more staring at a bunch of strings while trying to enter data for just one
• -Add fps simply one by one by looking at the graph and using the provided textbox and add button, or one by one using the FPS list (sheet detects edits in that column/row set)!
• -Shows ES while on reg, ES while off reg, and ES from the entire string, to help analyze whats going on while on/off reg and as a whole!
• -Automatically finds the longest streak within your custom ES and tells you the shot #'s + streak count
• -Shows the most duplicated fps in a string and the amount of times it was duplicated.
• -Save custom notes (string dependent)
• -Copy string data straight to clipboard to share in the following format!

Marauder
Date: Temp: 60
Chronograph distance: 0ft
Loss from Chrono Distance: 0 fps
Chrono Loss Added: No

Projectile Mass: 33.95 - Ratio to Air: 71.5% / 28.5%
Psi Start: 3100 - Psi End: 1700 - Airuse: 1400 psi
Psi / Shot: 46.7 - CC / Shot: 5.04 - Fpe / Psi: 0.34
Res Vol: 190cc - Reg Vol: 53cc - Setpoint: 1925psi
Shots On Reg: 25 - Shots Off Reg: 5 - Total Shots: 30

Efficiency: 1.45 fpe/ci
Valve Close @: 29%

ES: 19 fps ( 2.16%) - Std Dev: 4

Total Energy: 1709 - Fpe Per in/Barrel: 2.99

Total Shots < 1% ES: [22/30] best streak: [10] shots [#12-21]

Fps/Fpe High Fps/Fpe Avg Fps/Fpe Low
879 - 58 869 - 57 860 - 56

(1-10) 877 - 872 - 872 - 866 - 873 - 875 - 879 - 868 - 873 - 868
(11-20) 877 - 865 - 869 - 868 - 870 - 864 - 866 - 868 - 869 - 870
(21-30) 863 - 872 - 867 - 864 - 868 - 868 - 872 - 868 - 865 - 860

Most repeated: [868] Duplicates: [7]




ProjectileDB

• -Store up to 20 projectiles, and their needed data
• -APMR MIL Reticle with a visualization of where the shot placement should be! (used due to popularity and its clarity in producing a good visual)
• -Displays units in CLICKS/MIL/MRAD
• -Extreme spread markers, reticle will display two fine lines showing spread in MIL from fps variation.
• -Graph that shows projectile drop in absolute inches, poi inches, MIL drop, retained energy, and penetration with custom start/end and increment ranges
• -Applies wind speed, wind angle, shot slope, scope height, and bullet spin into trajectory calculations (also temp + altitude, bc, ect..)
• -Calculates ideal twist rate, projectile sg, hits number, wind drift per mph @ a common range set by user, retained fpe/fps at target, wound depth into flesh, projectile rpm, and more!
• -Calculates optimal zero based on height of projectile path
• -bc calculator (near/far velocity + the difference in distance between the two)
• -Compare 2 projectiles side by side
• -3 size configuration, full size, minimized list, and hide graph+reticle to help reduce clutter when focusing on one area!
• -Save custom notes (projectile dependent)
• -Current Local Weather based on your City/State (conditions/temp/rh/wind/uv index/ change of precipitation) and elevation query!
• -Show a table with all the data you need for a custom range card, can add/remove whatever units you desire!

Extras:

• -Calculate optimal balanced valve specs, such as vent OD, chamber volume (cc), and balance % + poppet OD, as well as current o-ring squeeze for a dynamic o-ring!
• -Extra large graph for fps/fpe gains based on one parameters, and also pressure gradients / valve dwell model
• -Extra large shot string graph that can edit string data just like the main page, with splatter target showing extreme spread for strings
• -Extra large reticle display on separate sheet for those hard of seeing or those that just want an exploded view from the projectileDB

Here is the data I put in from danny's Gauntlet, I had to bump up the reg pressure to 1775-1800 for it to make sense to me, either that or the reg volume / port size could be slightly off, or the calculation my spreadsheet is running...either way you're definitely operating a bit close to the plateau and would benefit greatly from backing the velocity down to 860-870~.



If you read this danny and can confirm the possibility of the set point difference or another possible slight difference, or if you're 100% positive on the set point, let me know so I can try to work out some adjustments on my end to compensate!