GTA

All Springer/NP/PCP Air Gun Discussion General => Air Gun Gate => Topic started by: Cathartes on February 05, 2017, 11:19:57 PM

Title: Simple Shot String Analyzer
Post by: Cathartes on February 05, 2017, 11:19:57 PM

I know there are some great Excel sheets floating around out there for shot string analysis, but I don't use Excel and most of them act a little odd when imported into Google Sheets and/or are difficult to paste a string into. I've created a no-frills shot string analyzer for us Google Sheets users. The shot string chart will appear when values are entered into the FPS column. You may want to adjust the range of the vertical axis of the chart to something that is sane for your FPS range. I tried to script the sheet to do this automatically, but that's apparently a little advanced for Google Sheets.  ::)

Click here (https://docs.google.com/spreadsheets/d/1nGjxycuIZPq_Ws_JXGYJkrUMYKKYMPk5Ex404dnIbgw/edit) to preview. You can make a copy from here, if you like.

Click here (https://docs.google.com/spreadsheets/d/1nGjxycuIZPq_Ws_JXGYJkrUMYKKYMPk5Ex404dnIbgw/copy) to automatically copy to your Google Docs. A Google account is required.

Hopefully this will give a good basic template. Style as you see fit!

Title: Re: Simple Shot String Analyzer
Post by: anti-squirrel on February 06, 2017, 08:22:53 PM

Thank you!

Title: Re: Simple Shot String Analyzer
Post by: Todd G on February 06, 2017, 10:09:39 PM

Will it work on android?

Title: Re: Simple Shot String Analyzer
Post by: Cathartes on February 06, 2017, 10:25:04 PM

No problem, hope it's helpful!

Yes, it works on Android nicely in the Google Sheets app.