When I started with PiezoDN as a beta-tester going on 2 years ago, I only had Numbers too and wanted to use that. Walker kindly made me a Numbers version of the Smoother tool, but he also explained that the other tools used functions that Numbers does not support. In other words, Smoother is the only tool that can work in Numbers. I just gave it a try and it works fine. I could even copy/paste the entire data set after selecting only the top left green cell.
But I decided I wanted access to the full tool set so I bit the bullet and subscribed to MS Office 365 Personal which is $69.99/yr. I think you can also find the 2011 version of Office cheap on ebay. Either way is well worth it in my opinion. I don’t use Numbers or Pages at all anymore.
If you want to stick with Numbers, I don’t see any reason that won’t work. You just don’t have access to the other tools, but their use is optional anyway. Smoother is the only one that is necessary.
I use a spreadsheet of my own creation for keeping track of all my work. It doesn’t do any kind of calculations, but I can graph as many things as I want on the same graph to track linearization progress. I’ve shared it with several others and would be happy to share it with you too if you are interested.
The next version bump of PiezoDN will also be a significant upgrade to the existing toolset and this will actually require the new version of Excel.
In the interim I will make an OpenOffice version of the existing tool and upload it here. I think the most recent version of OpenOffice should suffice with a little bit of programming.
Walker, thanks for the .ods file. (I was away for a week and now am back at it…)
Please find attached the .ods file with the data from my exported SpyderPrint text file. I was able to paste the data into the Curve tab with no problem, and it populated the CGATS tab automatically.
I then followed the instructions in the DN Manual section E to linearize the quad. I dragged both the .txt file (created from the CGATS tab….text file attached) along with the 1430 Piezo-Master.quad (that I used to print the 129 step) over the QTR-Linearize quad app. The resulting “out” text file is attached…The note at the bottom says it can’t be linearized.
It works fine for me. For some reason your .txt document does not have tabs between the columns, only spaces. This is probably the issue. Whatever text editor you are using to copy to is creating spaces instead of tabs.
Open Office does not have a .txt file-type in the Save-As menu options, so I saved as a .csv and then saved it as a .txt from there, but maybe that was too many steps. I downloaded Sublime Text and copied>pasted the data from the CGATS tab into it and saved it as a .txt file.
How does this look?
If this is OK, how do I then create a .quad file from the .txt file?
Your should save the .txt and the .quad to the desktop before dragging and dropping them over the droplet (together) as they need to be in a folder with read/write access.