Primoz Kvaternik, Grsoft Structural Engineeri Engineering calculations using microsoft excel: learn how to write your own customized calculations in minutes, paperback/farzaneh farshad

• 4 stele, bazat pe 1 voturi

As every Engineer needs to do many daily calculations especially using modern standards like EUROCODES, the need to write custom software solutions is more and more real.

Especially if standards include many complex formulas which are hardly calculated using pocket computers as it was 30 years ago.

Then it came programmable pocket computers, I clearly remember as I had SHARP programmable computer, where it was possible to write a complex software, but you couldn't print the results as it is possible now.

So today it is possible just by using Microsoft Excel and its programming abilities to write real software which can solve all daily engineering calculations with ease.

What does an engineer need? So what does an engineer need when creating calculations? First there are input parameters, which should be entered on a very simple and a quick way, then a simple sketch as a graphical representation of the basis of calculation with annotations of input parameters.

After that engineer needs to define the mathematical procedure which could be very simple, but it should also enable him, to write also more complex formulas or iterations.

This is very easy to do with Excel.

In this book I will show you that you do not need to be a software developer to create your own customized engineering calculations in minutes.

What is maybe the most important, you can update formulas in your calculation any time you want.

This is the solution that every engineer needs, because it offers open-source solution with powerful programmable tools, but on the other side simple enough to be done instantly.

We will learn the following topics: - How to create cells where input parameters should be entered - How to create a sketch with annotations of input parameters - How to prepare cells where results of calculation will be written - How to create a push button, where you will trigger start of the calculation - How to write code to perform calculation - How to write code to display the results of.