Design Con 2015
Breaking News
Newest First | Oldest First | Threaded View
<<   <   Page 3 / 4   >   >>
User Rank
Re: don't pigeonhole R
kfield   6/23/2014 3:59:40 PM
@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! :-)

User Rank
Re: don't pigeonhole R
betajet   6/23/2014 3:56:31 PM
antedeluvian wrote nice things about Excel

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.

3.  Client invoices.


User Rank
Re: don't pigeonhole R
Wnderer   6/23/2014 3:43:44 PM
I use Excel for analysis all the time. If you are looking for an alternative to Excel, you might want to check out pyspread.

I haven't tried it, because the team uses Excel and I'm not going to switch to something different, but I like the idea of using Python to program a spreadsheet rather than Vbasic.

User Rank
Re: don't pigeonhole R
antedeluvian   6/23/2014 3:31:41 PM

I know there are many engineers who share your view on Excel. However I have made a bit of a career about writing about the use of Excel in Electronic Engineering.

If you prepared to enetertain the idea that Excel can be used for more than just part lists you may want to work through my blogs on the subject in Planet Analog (

User Rank
don't pigeonhole R
DaveMcGuire   6/23/2014 3:08:50 PM
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".

                    -Dave McGuire


User Rank
No LTspice???
Howman   6/23/2014 12:17:23 PM
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.

User Rank
Pari/GP; other apps; Question
Hoyt_Stearns   6/23/2014 12:06:44 PM
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?


User Rank
LT Spice IV should be listed
Tonkabot   6/23/2014 11:53:45 AM
Best free spice out there, I am surprised it was missed in this list.


I went to iCircuit , and it wants 4.99 for the android app, so it is not free.  Maybe there is a limited version for free.

User Rank
Another great mathematical tool : Scilabs
pschirrer   6/23/2014 11:46:16 AM
I have used SciLabs with much success to do some mathematical work (it is a nice alternative to Mathlab) : check it out.



User Rank
Re: Python works too!
Sheetal.Pandey   6/23/2014 2:54:23 AM
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.

<<   <   Page 3 / 4   >   >>

Top Comments of the Week
Flash Poll
Like Us on Facebook Parts Search

185 million searchable parts
(please enter a part number or hit search to begin)
EE Life
Frankenstein's Fix, Teardowns, Sideshows, Design Contests, Reader Content & More
<b><a href=Betajet">

The Circle – The Future's Imperfect in the Present Tense
The Circle, a satirical, dystopian novel published in 2013 by San Francisco-based writer Dave Eggers, is about a large, very powerful technology company that combines aspects of Google, ...

Max Maxfield

Recommended Reads From the Engineer's Bookshelf
Max Maxfield
I'm not sure if I read more than most folks or not, but I do I know that I spend quite a lot of time reading. I hate to be idle, so I always have a book or two somewhere about my person -- ...

Martin Rowe

Make This Engineering Museum a Reality
Martin Rowe
Post a comment
Vincent Valentine is a man on a mission. He wants to make the first house to ever have a telephone into a telephone museum. Without help, it may not happen.

Rich Quinnell

Making the Grade in Industrial Design
Rich Quinnell
As every developer knows, there are the paper specifications for a product design, and then there are the real requirements. The paper specs are dry, bland, and rigidly numeric, making ...

Special Video Section
The LT8640 is a 42V, 5A synchronous step-down regulator ...
The LTC2000 high-speed DAC has low noise and excellent ...
How do you protect the load and ensure output continues to ...
General-purpose DACs have applications in instrumentation, ...
Linear Technology demonstrates its latest measurement ...
Demos from Maxim Integrated at Electronica 2014 show ...
Bosch CEO Stefan Finkbeiner shows off latest combo and ...
STMicroelectronics demoed this simple gesture control ...
Keysight shows you what signals lurk in real-time at 510MHz ...
TE Connectivity's clear-plastic, full-size model car shows ...
Why culture makes Linear Tech a winner.
Recently formed Architects of Modern Power consortium ...
Specially modified Corvette C7 Stingray responds to ex Indy ...
Avago’s ACPL-K30T is the first solid-state driver qualified ...
NXP launches its line of multi-gate, multifunction, ...
Doug Bailey, VP of marketing at Power Integrations, gives a ...
See how to ease software bring-up with DesignWare IP ...
DesignWare IP Prototyping Kits enable fast software ...
This video explores the LT3086, a new member of our LDO+ ...
In today’s modern electronic systems, the need for power ...