Return to index: [Subject] [Thread] [Date] [Author]

RE: VBA to Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]
In the distant past (10 yrs ago?), I had written vba macros that do matrix analysis of structures (continuous beams for sure, maybe frames).  Spreadsheets defined the members, connectivity, and loads, then a macro formed the element stiffness matrices and assembled the global stiffness matrix on its own sheet, and then Excel function minverse() and mmult() solved the equations and calculated nodal displacements.
It was fun, and I'm glad I did it, but it surely couldn't replace RISA or SAP when it came to getting serious about analyzing a structure.
I probably have the spreadsheet lying around somewhere, and you're welcome to it, but I'd hate to deprive you of the fun of doing it yourself:)
Brian McDonald

From: Jason Atwood [mailto:atwoodjason(--nospam--at)]
Sent: Friday, May 27, 2005 8:36 AM
To: seaint(--nospam--at)
Subject: VBA to Excel

I like Jake am interested in developing/improving an excel spreadsheet using VBA for beam analysis.I would like to do create an array with say 50 rows by 5 columns. The columns will contain x, q(x), V(x), M(x), and d(x) respectively. Where q(x)=m(x-a)+qa ( i.e. linear function somewhere on the beam starting at "a" with "m" as the slope from a to b and "qa" the intensity at "a") subsequent functions will be will be integrated using the trapezoidal rule (or something else). My question is this: what is a convenient way to add together several loadings together to create a single column for q(x) and then perform the integrations?

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around