Saturday, July 11, 2009

Structural Analysis Programs in Excel Spreadsheet

The followings described the Excel Spreadsheet Programs :

1) Continuous &Subframe Analysis and Design (Excel & Calc) - This program analyses and design continuous beams or subframe using moment distribution methods. Moments and shear forces envelope are based on BS8110 requirements but the programs can analyse more rigorous loading patterns if needed. The maximum number of span is 10 and can carry out analysis on cantilever ends, fixed ends etc. Excel macro is added to the programs to ease the input of spans and loadings. However, the programs can still work if the macro is disable, it will only be a more cumbersome input steps only. The program had been tested rigirously with commercial software such as SAP2000, Prokon Continuous Beams, TopCad Beam and some textbooks examples. All the results tally exactly.

The program is also writtten in OpenOffice and run perfectly well. In future post, I will denote as (Excel & Calc) for Microsoft Excel format and OpenOffice Calc format.

The design module is an add-on and can be carried out separately from the analysis portion. Currently the design is in BS8110 (1985, 1997). CSA A23.3-04 code is currently implementing.

2) Reinforced Concrete Section Analysis (Rectangular Beams, Rectangular and Circular Column) - (Excel & Calc) Every engineer writes a program to design moment and shear for RC sections once in their work life. I developed more than section design. This is a capacity check of rectangular beam and column and circular column. The analysis is carried out using first principle and reinforcement arrangement can be asymmetric. Macro is written to accelerate the iteration process but without the macro, the program will still work.

Currently, the program is written in both BS8110 and CSA A23.3-04.

3) Beam Design (Excel & Calc) - Design the reinforcement requirements of beam section for bending moment, shear force and torsional force. This is a typical beam design program that is used on daily basis.

The program can design in both BS8110 and CSA A23.3-04.

4) Pilecap Design (Excel & Calc) - Design of pilecap for pilegroup of 2 to 6 piles. The pile arrangement need to be regular in order for the program to work.

5) Box Drain Design (Excel & Calc) - Design of box culvert using coefficient given in Reynold Handbook. The program was tested using SAP2000 plane frame with numerous load patterns and cases. Results proved to be exactly.

6) Retaining wall Design (Excel & Calc) - Design of L shape retaining walls and checking of factor of safety for sliding, overturning and bearing pressure. The soil can be on the heel or toe of the retaining walls making the program very versatile to use.

7) Corbel Design and Deep Beam Design (Excel & Cal) - Design corbel and deep beam using strut and tie model.

There are other programs that I will list in my next few post.


Anonymous said...

show me more what your programme can do.

Unknown said...

Hi, Can I get a copy of this spreadsheet on my email "", thanks

Rania Harb said...

Hi Ann:
Could you please send me a copy of your spreadsheet. I am a structural engineer and have an interest of this kind of design for high rise buildings in Toronto,

Best regards,

Umesh Fernando said...

Hi Ann,

I am a structural Engineer recently pass out from University of Moratuwa, Sri Lanka. Could you please send me the copy of your spreadsheets. Currently we are using BS 8110, but i hope to migrate to Canada in near future.

Thank You.

Anonymous said...

Could you send me a copy of your spreadsheet?

Thank you very much!

My e-mail:


Anonymous said...

This is my first time pay a quick visit at here and i am actually pleassant to read everthing at single place.

Also visit my web site Click Url

Anonymous said...

Spot on with this write-up, I really think this website needs
a lot more attention. I'll probably be returning to read more, thanks for the info!

Also visit my page :: long Distance removals Cape Town

Anonymous said...

Ahaa, its nice dialogue concerning this piece of writing at
this place at this web site, I have read all that, so at this time me also commenting at
this place.

Also visit my web blog ultra sound South Africa

Anonymous said...

At this time I am going to do my breakfast, afterward
having my breakfast coming yet again to read more news.

my homepage; recycling Century City

Anonymous said...

Aw, this was a very good post. Taking the time and actual effort to make a top notch article…
but what can I say… I hesitate a whole lot and never seem to get anything done.

My website - balustrades Gauteng balustrades Gauteng

Anonymous said...

My coder is trying to convince me to move to .net from PHP.
I have always disliked the idea because of the costs. But
he's tryiong none the less. I've been using Movable-type on numerous
websites for about a year and am anxious about
switching to another platform. I have heard great things about blogengine.
net. Is there a way I can transfer all my wordpress
posts into it? Any kind of help would be really appreciated!

Also visit my page: dstv services

Anonymous said...

I loved as much as you'll receive carried out right here. The sketch is tasteful, your authored subject matter stylish. nonetheless, you command get bought an impatience over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly the same nearly very often inside case you shield this hike.

Feel free to surf to my site ... website

Anonymous said...

I visited several web sites but the audio feature for audio songs
present at this web page is really marvelous.

Here is my web site: More info

Anonymous said...

Thanks for one's marvelous posting! I seriously enjoyed reading it, you will be a great author.I will ensure that I bookmark your blog and will often come back later in life. I want to encourage you to ultimately continue your great posts, have a nice weekend!

My weblog ... click url

Anonymous said...

I blog quite often and I seriously appreciate your content.
The article has really peaked my interest.

I'm going to bookmark your website and keep checking for new details about once per week. I subscribed to your RSS feed as well.

Look into my web-site reservation software Durban

Anonymous said...

Howdy! Do you use Twitter? I'd like to follow you if that would be ok. I'm definitely enjoying your blog and
look forward to new posts.

my blog ... website design Cape Town

Anonymous said...

I think this is one of the most significant info for me.
And i am glad reading your article. But should remark on some general
things, The website style is ideal, the articles is really great
: D. Good job, cheers

my homepage :: boiler repairs Randburg

Anonymous said...

whoah this blog is great i like reading your articles.
Stay up the good work! You realize, many persons are
hunting round for this info, you could help them greatly.

Look into my web site; Delivery Flowers gauteng

Anonymous said...

I pay a visit day-to-day some websites and blogs to read posts, however this weblog gives quality based content.

Feel free to surf to my site - website link

Anonymous said...

Pretty! This was an extremely wonderful article. Many
thanks for supplying this information.

Feel free to visit my web page :: website link

Anonymous said...

Its such as you read my thoughts! You seem to understand so much about
this, like you wrote the guide in it or something. I feel that you simply can do
with a few percent to power the message home a little bit, but other than that, this
is wonderful blog. A fantastic read. I will certainly
be back.

My web page; toilet repairs Gauteng

Anonymous said...

I quite like looking through a post that can make people think.
Also, thanks for allowing me to comment!

my homepage Digital printing south africa

Anonymous said...

Hi, I would like to subscribe for this weblog to take
most recent updates, so where can i do it please help out.

Also visit my blog :: exclusive wedding cakes Johannesburg

Anonymous said...

Hi there, its pleasant paragraph on the topic of media print, we all understand media is a impressive source of facts.

Also visit my web site ... cosmetic jewelry KwaZulu Natal cosmetic jewelry KwaZulu Natal

Anonymous said...

I love your blog.. very nice colors & theme. Did you create this website yourself or did you hire someone to do it for you?

Plz answer back as I'm looking to create my own blog and would like to know where u got this from. cheers

my web site More info

Anonymous said...

Superb site you have here but I was wanting to know if you knew of
any message boards that cover the same topics talked about in this article?
I'd really love to be a part of online community where I can get advice from other experienced individuals that share the same interest. If you have any suggestions, please let me know. Thanks a lot!

my website ... events South Africa

Anonymous said...

I'd like to find out more? I'd like to find out some additional information.

Feel free to surf to my page: Hogroasts Norfolk

Anonymous said...

Hi! I'm at work browsing your blog from my new iphone 4! Just wanted to say I love reading through your blog and look forward to all your posts! Carry on the outstanding work!

Here is my blog solid edge technology Gauteng

Anonymous said...

Howdy, I think your site might be having web browser compatibility issues.
Whenever I take a look at your web site in Safari, it looks fine however when opening in I.
E., it has some overlapping issues. I merely wanted to give you a quick heads up!
Apart from that, great site!

Also visit my homepage ... website

Anonymous said...

What you said was actually very reasonable.
But, what about this? what if you wrote a catchier title?
I ain't suggesting your content isn't solid., but what if
you added a title that makes people desire more?

I mean "Structural Analysis Programs in Excel Spreadsheet" is a little boring.
You might glance at Yahoo's front page and note how they write article headlines to grab viewers interested. You might add a related video or a related picture or two to get readers excited about what you've
written. In my opinion, it could bring your website
a little livelier.

Anonymous said...

I every time spent my half an hour to read this website's content daily along with a cup of coffee.

Here is my blog :: scrap my car Bradford

Anonymous said...

Thanks for every other informative website. Where else may just I am getting that type of information written in such a
perfect way? I've a undertaking that I am simply now running on, and I've been at the look out for such information.

Also visit my weblog - gym equipment Johannesburg suppliers of gym equipment Johannesburg

Anonymous said...

No matter if some one searches for his required thing, thus
he/she wishes to be available that in detail, so that thing is maintained over here.

Also visit my page: Visit here

Anonymous said...

Good day I am so grateful I found your website, I really found you by accident, while I was browsing
on Digg for something else, Regardless I am here now and would just like to say cheers for a marvelous post and
a all round interesting blog (I also love the theme/design),
I don’t have time to read through it all at the moment but I have book-marked it and also added your RSS
feeds, so when I have time I will be back to read a lot more,
Please do keep up the awesome work.

my blog post: landscaping garden design Cape town

Anonymous said...

Hi, this weekend is nice in favor of me, because this moment i am reading this impressive educational piece of writing here at my residence.

my webpage: all Weather furniture Western Cape outdoor furniture Eastern Cape

Anonymous said...

Highly descriptive post, I loved that bit. Will there be a
part 2?

Here is my weblog ... click url

Anonymous said...

We stumbled over here from a different web page
and thought I might as well check things out. I like what I see so now i am following
you. Look forward to looking at your web page again.

Also visit my web blog Visit here

Anonymous said...

Very soon this site will be famous among all blogging viewers,
due to it's pleasant articles

My site website

Anonymous said...

Wow, this paragraph is nice, my sister is analyzing such things, therefore I am going to inform her.

my blog illustration Johannesburg

Anonymous said...

Asking questions are actually fastidious thing if you are not understanding anything
totally, but this post offers fastidious understanding even.

Feel free to surf to my weblog ... Conti Suits Johannesburg

Anonymous said...

Very nice article, totally what I needed.

My weblog; Office Planning And Layout

Anonymous said...

Thank you for some other informative blog. The place else could I get that type of info written in such an
ideal way? I've a mission that I'm just now operating
on, and I have been at the look out for such information.

Feel free to surf to my website :: property for sale

Anonymous said...

Great web site you have got here.. It's difficult to find good quality writing like yours these days. I truly appreciate people like you! Take care!!

Feel free to surf to my web blog - it support johannesburg

Anonymous said...

Having read this I thought it was really informative.

I appreciate you spending some time and energy to put this short article
together. I once again find myself spending a significant amount of time both reading and leaving comments.
But so what, it was still worth it!

my weblog ... Accountants on Mission

Anonymous said...

I like the valuable information you provide in your articles.
I will bookmark your weblog and check again here regularly.
I am quite certain I'll learn a lot of new stuff right here! Good luck for the next!

Stop by my page - how much should i weigh chart

Anonymous said...

I've been surfing online more than 2 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. Personally, if all webmasters and bloggers made good content as you did, the net will be much more useful than ever before.

My blog :: healthy Diet plans

Anonymous said...

I am in fact pleased to read this weblog posts which carries
plenty of useful facts, thanks for providing these information.

Visit my web page; More information

Anonymous said...

Hi, I am a structural engineer recently migrated to Canada. I am less familiar with CSA A23.3. Can you Please share your excel programs with me. My email is


Dave S said...

Hi...could u please email me this spreadsheet...Thank you so appreciate email is