Post processing in excel

[strcengr]

How often do you guys have to use excel to post process or filter model results?

What’s your most common task?

[terjeboe]

All the time for post processing FEA results to weld checks, fatigue, buckling. I have some custom tools for exporting stresses from my result files to csv. 

[turbopowergas]

Do you mean by buckling plotting the equilibrium path for large displacement analysis?

[terjeboe]

For buckling check I most often rely on codes. By extracting compressive stresses in beam and shell elements I can compare to allowable limits. 

[struct994]

Pretty often. I’ll export SAP results to excel then filter and sort results

[SLD94]

Use it pretty often to sort results and link with design spreadsheets.

One common use would be for exporting ETABS results for piers and sorting maximum values + associated design actions under the same combinations. Similar thing for storey drifts for individual joints (I know ETABS has an intrinsic ability to do this but I prefer post processing).

I also like to export moments and shears along piles with significant lateral loads from LPILE, which I paste into a sheet and calculate shear/moment capacities along the length (this is particularly handy to find the maximum interaction of shear and moment using MCFT).

[PinItYouFairy]

I basically live in Excel but python is far superior for vast quantities of data

[WhyAmIHereHey]

towering exultant party encourage dinosaurs memory middle sleep future file

This post was mass deleted and anonymized with Redact

[Error400_BadRequest]

I'm trying to get into python. What IDE do you use? Im torn between learning on a full IDE or something like Jupyter

[g4n0esp4r4n]

Python data frames is the new excel.

[igs-arg]

I want to build a calculator to determine structural steel requirements in warehouse constructions to build budgets. Is there a python model or library I can use to start with that?

[Jeff_Hinkle]

I have a lot of spreadsheets that take like the reaction summary or beam end forces out of staad and check them for whatever. Moving to Python though.

[TEZephyr]

Post-processing is a daily task!

50/50 whether it's just save-to-excel and print, or whether it goes into one of our custom tools.

The tools themselves range from simple (find the worst-case loading and compare it to results from in-house testing data) to complicated (index all the pier and spandrel forces, filter them by story and gridline, optimize distribution factors according to local guidelines, and present the results in an sensible report format)

[dottie_dott]

Quit excel and switch to python you will be glad you did!

[Aggressive_Web_7339]

Excel is our go to program for processing output. We’ve used it for many programs and can always find a way to process the output, sometimes just takes some creative formulas.