Civil Engineering Spreadsheet. "Matrix Calculation of Structures"

[toperos]

This is a spreadsheet I made because I am a civil engineer student and I needed something like this for the HP Prime. It serves for the "matrix stiffness method" of structural analysis.
I share it because for now there is no programs of structural analysis for the HP Prime, and maybe this spreadsheet could be useful for someone.
It is something I made for myself, that's why is not very elegant and maybe a little disordered.

There are 4 spreadsheets:
1. First for Articulated Structures
2. Second for Reticulated Structures with rigid nodes
3. Third for Structures Mixed, with nodes rigid and articulated
4. Fourth for Gratings when the forces are applied perpendicular to the beams, for example decks

Each spreadsheet calculates the stiffness matrix of the beams, the translation and rotation matrix, and you can assembly the stiffness matrix of the structure. There are instructions of how to use them.

To install the spreadsheet to your calculator you just have to select the three archives of each spreadsheet ( .hpapp, .hpappnote, .hpappprgm) and drag to your calculator in the Hp Connectivity Kit.

Ask me if you have some doubt.

Fernando. A