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.
I transitioned from Excel to Python for running basic calculations and simulations a few months back. And it works great! Tons of great modules(matplotlib and numpy are a must) and more than anything its fast as hell. And by fast I mean 50 million points in a few secs and it can plot them without stuttering too!
True, it's not exactly a simulation tool, you've got to spend a little time thinking about how to run the simulation but once thats out of the way, it's all smooth sailing.
PS: I used PSoC Creator before and the line "which allows users to design their own Programmable System on a Chip and have it manufactured (that part costs)" is misleading. You can buy a generic PSoC 3/4/5 and program it with Creator i.e., it's all firmware(although that term actually encompasses a lot more when looking a PSoC) and no custom manufacturing is involved. The cool thing is you can always move stuff around and reprogram so it's pretty much like a custom SoC.