I've been enjoying the awesomeness of the spreadsheet!But I'm wondering if there is a way to input the shot velocities in meters per second and then toggle the whole string over to fps.My new Chinese wifi enabled barrel mounted chrony can only display the data in m/s, on the wifi device. https://www.aliexpress.com/item/32872171216.html?spm=a2g0s.9042311.0.0.27424c4dXTsOf3 The data can be displayed on the Chrony in fps, but that defeats the usefulness of viewing the data on my tablet along with the spreadsheet.
Duh. I can just make my own sheet easy enough! [=3.28084*A2]Anybody. know of a way to force the data copied from the output field to round to the nearest single decimal place? I can make my own sheet display one decimal, but the copied data goes to five places when I paste it to Triggertreat's sheet.
Ah Rev. 6! That's the ticket! Where can we get that!? Could you make it a good deal longer than 20 rows too? I don't think I'd ever shoot that many but my Chrony can record 120 entries...I just discovered Paste Special -> Values and Number Formatting That's carries over the format of the cell in the sheet I created myself. I was using Paste Special -> Values which was pulling over the whole calculated conversion to several decimal places regardless of the formatting of the cell.
After years of use, let it be known this Spread sheet is the bombness, the most dopest, the most bestest, the most off the chainest tool ever developed let alone freely shared!THANK YOU TRIGGERTREAT!<We now return you to your regularly scheduled programming in progress>
Quote from: BSJ on March 02, 2020, 09:39:42 PMAh Rev. 6! That's the ticket! Where can we get that!? Could you make it a good deal longer than 20 rows too? I don't think I'd ever shoot that many but my Chrony can record 120 entries...I just discovered Paste Special -> Values and Number Formatting That's carries over the format of the cell in the sheet I created myself. I was using Paste Special -> Values which was pulling over the whole calculated conversion to several decimal places regardless of the formatting of the cell.I'll post it up once finished. It will support 185 shots just like the rest of the spreadsheet.
So the numbers display correctly in the Saved String cells. But they don't once they get sent to the Chart.And I don't get the option to paste as Text when I choose Paste Special...
I'm copying the text from the conversion chart. With Right click + Copy.Then I Right Click, Paste Special -> Values and Number Formats into one of the Saved Strings. It looks fine in the Saved String. No decimal numbers visible. Then I click a colored block and the data gets sent to the corresponding Chart and it updates. The suppressed decimal numbers are now visible in the graphs.I'm running a new Win 10 PC with Microsoft Office 365 ProPlus.Are you able to see the attachments from my earlier post?
PERFECT! Did you have to suppress the decimals in the graphs?
i get 2 error messages when opening or loading the sheet in Libre Office.The following external file could not be loaded. Data linked from this file did not get updated.file:///C:/Backups/Air Gun/Shot String Analyzer v30.5.xlsmusing the latest spreadsheet 6-3-3-2020And also something about: Warning loading document Free Spreadsheet Rev 06 3-3-2020.xlsm:The data could not be loaded completely because the maximum number of columns per sheet was exceeded.
Thank you so very much for that spreadsheet. That is one of the most useful tool I have seen.Thank you