@davemcguire Thanks for the insight on R. But isn't it true that many of us try to use Excel for something it's not equipped to do because we are not aware of a good alternative? Or too lazy to learn. :-) Would love to know more about your history with R, how you learned about it, what types of things you use it for, wow I think I am proposing you write up a blog on it! :-)
I use Excel or its Libre Office equivalent occasionally. It can be a terrific way to present certain kinds of information, and also do a quick analysis. It's also nice that you don't have to use it every day to maintain proficiency.
Some of my uses:
1. I used it to help design an FPGA-based Baud Rate Generator. Excel was a great way to calculate divisors and prescaling for standard Baud rates, and calculate the frequency error.
2. It's a great way to work up an FPGA pinout. Xilinx provides generic pinouts for their parts and you can add your own signal names and notes. Xilinx Excel files show which pins are dedicated to power, ground, and pre-defined functions so you can avoid them for user I/Os.
It's a bit iffy to classify R as "an alternative to Excel". R is not a spreadsheet, it never has been and never will be...and Excel has nowhere near the data manipulation capabilities of R. There is very little overlap between their capabilities.
As a design engineer, I find Excel useful about once every three to four years, usually for things like BOMs, but I use R almost daily for REAL engineering work. R makes short work of anything that my trusty HP calculator can't easily handle. It was designed for statistical work (it traces its roots back to Bell Labs' 'S" language in the 1970s, and has seen a great deal of refinement over the years, but it's more properly presented (in my opinion) as a "mathematical Swiss Army knife".
While there are some great tools in this and the original list, I am left scratching my head as to why LTspice failed to make the list again. I use it very often and is at the top of my list of free tools.
Another nice tool is the free version of Mathcad. When you let the free 30 day trial lapse. You get a very stripped down version that is still quite useful as a math scratchpad that handles units. Very useful for free.
Finally, if you are going to included tools tied to vendor's parts like Cypress' PSoC Creator and TI's WEBENCH, you should included the free versions of Quartus from Altera and ISE WebPack from Xilinx.
You could add PARI/GP from France for advanced algebraic analyses, it's actively maintained, and also goes well beyond what I understand.
I have a question, though: in 2000, I was using a program that could fit a dataset to a function optimally ( least-squares, outlier reject etc.) by trying hundreds of algorithms, e.g. series, logs, ratios, trancentals, relations among them. Do you know the name of that program?
An alternative like this for excel is very good for the engineers. I always felt that engineers need more and should be able to upgrade it themsleves without calling any customer support or getting into copyright issues. I started using Ubuntu and in last three years it never crashed and so easy to operate and has so much flexibility.