EXCEL IN ENGINEERING

Anyone who knows me from my teaching days and after I started working in the industry knows that I think combining VBA with Excel spreadsheets makes great engineering tools. After almost two decades of using it, I am still impressed with the things that can be done. Recently, I learned that Excel files with or without VBA code can be compiled into executable programs that, while they still need Excel to run, make it possible to provide a higher level of protection to programs developed for others to use. The program I ended up using is XCell Compiler, powered by DoneEx (www.DoneEx.com). Check it out!


Along these lines, below are some of the websites I frequent when I am looking for information on Excel/Engineering topics. They offer a lot of very useful material.


http://www.eng-tips.com/threadminder.cfm?pid=770

http://www.excelcalcs.com/

http://newtonexcelbach.wordpress.com/


For those who truly want to learn the ins and outs of Excel to optimize your programs, I recommend the Excel Hero Academy ( http://academy.excelhero.com/ ). I colleague of mine signed up and completed one of their sessions and I was amazed about all the things Excel has that most of us don’t know about. I strongly recommend it!

Of the many books on Excel and VBA for Excel, I prefer those written by John Walkenback, who is known as Mr. Spreadsheet. His website and links to PDF versions of his EXCEL 2010 BIBLE and EXCEL VBA PROGRAMMING FOR DUMMIES 3rd EDITION books are shown below.


http://spreadsheetpage.com

http://it-ebooks.info/book/1903/

http://it-ebooks.info/book/1106/

Recent Posts

See All

SELF ELEVATING UNITS – PART 2

This Part 2 of our writeup on self elevating units, focuses on a transition between modes of operation seldom addressed in design. This mode goes by different names such as “installation,” “pinning,”

SELF ELEVATING UNITS

This is Part 1 of a brief introduction to self-elevating units. There are many kinds of self-elevating units, many of which have been in continuous operation for over three decades. Depending on their

Grow Your Blog Community

With Wix Blog, you’re not only sharing your voice with the world, you can also grow an active online community. That’s why the Wix blog comes with a built-in members area - so that readers can easily

© 2018 by 3Dent Technology, LLC.