I said I'd release this in May last year, just never said which year. Maybe its 2022? I built this all in 3-4 months during the beginning of the pandemic, but have kind of slept on it for the last year due to burning out on it, it is/was quite overwhelming. Its 98% complete and fully in beta testing. I cannot promise any release dates.
If I get enough interest I may put forth a bit of more time and energy into finalizing and releasing this sooner than later...otherwise this post is just a reminder this beast still exists.
This is a big project for a single individual, and I put a lot of my time, energy and heart into it, which is also hard to give away, even harder when its not complete.
List of 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 plataeu, 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 inputed data to desired setting
-Load Projectile Data directly from stored data
-Calculates ideal barrel twist rate, ballstic 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. Thats 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 anaylze whats going on while on/off reg and as a whole!
-Automatically finds the longest streak wtihin 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
-150+ presets from the most common available pellets
-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 incriment 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 perciptation) 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 seperate sheet for those hard of seeing or those that just want an exploded view from the projectileDB
If I get enough interest I may put forth a bit of more time and energy into finalizing and releasing this sooner than later...otherwise this post is just a reminder this beast still exists.
This is a big project for a single individual, and I put a lot of my time, energy and heart into it, which is also hard to give away, even harder when its not complete.
List of 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 plataeu, 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 inputed data to desired setting
-Load Projectile Data directly from stored data
-Calculates ideal barrel twist rate, ballstic 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. Thats 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 anaylze whats going on while on/off reg and as a whole!
-Automatically finds the longest streak wtihin 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
-150+ presets from the most common available pellets
-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 incriment 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 perciptation) 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 seperate sheet for those hard of seeing or those that just want an exploded view from the projectileDB