×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Engineering template for new engineers (avoid writing VBA)
2

Engineering template for new engineers (avoid writing VBA)

Engineering template for new engineers (avoid writing VBA)

2
(OP)
Inspired by the book "Excel for Scientists and Engineers: Numerical Methods" by E Joseph Billo, I created an open-source engineering template, once and for all. No prepackaged calcs here, just pure numerical functions (Newton, ODE, etc) to build upon.

Also, the template includes an interesting new concept, called SOLVEWITH. Instead of writing VBA for your numerical calc, you can solve one instance of your problem in Excel. Then you call SOLVEWITH(out, in, new_in) to tabulate additional results. Sound impossible? It almost was...I had to register and execute callbacks in VBA to make it possible. However, the result is something kind of magical yet still logical. Does SOLVEWITH replace VBA? Probably not, VBA is huge and extensive. But for common numerical purposes, it could.

propel.codeplex.com

Thanks. This is an early version, so I'd be happy to hear your feedback.

P.S. The template also includes an early beta, VBA-less method for graphics (limited to checkboxes, radios, arrows, buttons, etc). Just select the cell(s) and hit Ctrl-W. For tables with hundreds of these objects, it's definitely faster and already quite stable.

RE: Engineering template for new engineers (avoid writing VBA)

Sounds interesting, but why the desire to not use VBA?

Surely we should be using the best tools available, which if you are working with Excel is very often VBA.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Engineering template for new engineers (avoid writing VBA)

To be a bit less negative, there really is a lot of interesting stuff in there, and I'm sure I'll be using some of it in the near future, so thanks for making the code open-source.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Engineering template for new engineers (avoid writing VBA)

(OP)
I have nothing against VBA, actually. For those that use Excel day-to-day, they'll definitely gravitate towards VBA.

However, as a practicing Engineer with access to Matlab, I didn't use VBA too much (once every ~4mo as project required). Since VBA has a huge API, I personally found myself forgetting more of the API than I retained. Others in my office simply refused to use VBA (??), and created sloppy, intractable spreadsheets as a result. So, basically, Propel was an attempt to bridge that gap. It gave the engineers a small number of VBA functions, when combined with vanilla Excel, could accomplish a large number of tasks. Beyond that, users are expected to learn VBA.

RE: Engineering template for new engineers (avoid writing VBA)

chadspen - Fair enough, my first comment was really just a knee-jerk reaction to the thread title.

With much the same purpose of making it easier to make documented calculations on a spreadsheet you might be interested in:

Evaluation of functions entered as text:
http://newtonexcelbach.wordpress.com/2013/08/06/ev...

Unit aware evaluation of text functions:
http://newtonexcelbach.wordpress.com/2012/07/31/un...

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Engineering template for new engineers (avoid writing VBA)

i doubt you need a lot of ODE with your daily work...
thanks for the effort anyway.

RE: Engineering template for new engineers (avoid writing VBA)

Quote:

i doubt you need a lot of ODE with your daily work...

Surely that depends on what your daily work is.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: Engineering template for new engineers (avoid writing VBA)

solvewith looks like it could be handy.

=====================================
(2B)+(2B)' ?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources