## Calculation Presentation/Formatting

## Calculation Presentation/Formatting

(OP)

Hello,

I have attached a pdf of some calculations from a precast manufacturer. Does anybody know what program they may have used to these? I don't care about the calculations, but the presentation format is nice and I'd like to look into using a similar type of software. I don't like some of the restrictions you run into when using Excel.

Thank you.

I have attached a pdf of some calculations from a precast manufacturer. Does anybody know what program they may have used to these? I don't care about the calculations, but the presentation format is nice and I'd like to look into using a similar type of software. I don't like some of the restrictions you run into when using Excel.

Thank you.

## RE: Calculation Presentation/Formatting

## RE: Calculation Presentation/Formatting

## RE: Calculation Presentation/Formatting

## RE: Calculation Presentation/Formatting

> insertion of image, either bitmap or something similar

> possibly conditional formatting to add the "OK" column

> possibly some concatenations for a few instances of "RE = blah"

> possibly some indexed lookup for the reinforcement

TTFN (ta ta for now)

I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg

FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm

## RE: Calculation Presentation/Formatting

In any event, if I was doing these calculations, I would use Mathcad or SMath Studio. Mathcad and SMath calculations are easier to understand and the math is easier to check because the live equations are visible and are not hidden like with Excel. It's these hidden equations in Excel that make me cautious about trusting spreadsheets produced by others.* Heck, that even applies to spreadsheets I produce myself. The only advantage I see here for Excel is that spreadsheets are virtually always more compact than Mathcad and SMath worksheets. For example, I have a spreadsheet for asphalt pavement design using the Caltrans (California DOT) method that includes a one-page pavement design calculation tab and a one-page traffic index calculation tab. The equivalent Mathcad calculations take about 5-1/2 pages, not including the far more elaborate annotations that I typically include in my Mathcad worksheets.

* Several times in my career I have received a spreadsheet from someone else (both co-workers and clients, all engineers) where the supposed results of a calculation were actually just numbers entered into a cell, while the actual calculations were done outside of the spreadsheet. Sadly, these doofuses used Excel only to create a nice table.

============

"Is it the only lesson of history that mankind is unteachable?"

--Winston S. Churchill

## RE: Calculation Presentation/Formatting

## RE: Calculation Presentation/Formatting

Clyde Hancock

Design & analysis of electric motors and generators

www.motorconsultants.com

## RE: Calculation Presentation/Formatting

No named ranges needed for the macro to find what cells have the values for 'L', 'W', or 'H'. And all values update as you change the inputs.

The top bunch of lines is before I run the macro, and the following lines are after I run it.

## RE: Calculation Presentation/Formatting

Clyde Hancock

Design & analysis of electric motors and generators

www.motorconsultants.com

## RE: Calculation Presentation/Formatting

https://newtonexcelbach.com/2020/12/29/units4excel...

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: Calculation Presentation/Formatting

## RE: Calculation Presentation/Formatting

## RE: Calculation Presentation/Formatting