tag:blogger.com,1999:blog-74326475662683956392017-08-06T04:29:02.905-07:00NOBITAStructural Anaysis &amp; Design Using Excel and OpenOfficeNobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.comBlogger15125tag:blogger.com,1999:blog-7432647566268395639.post-78444420284380150022010-02-06T18:55:00.000-08:002010-02-06T19:18:59.351-08:00FRP Strengthening of RC Structure - CSA A23.3Further to the development of the spreadsheet in CSA A23.3, I have developed the FRP strengthening of concrete structures based on the ISIS Concrete Educational Module. The resouces of ISIS are simply wonderful and fill with useful information.<br /><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 247px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5435331304736263682" border="0" alt="" src="http://4.bp.blogspot.com/_HL5CPyr73rQ/S24tBiddjgI/AAAAAAAAADg/rNoFd21rcN0/s320/ISIS+EC+Module+4+-+Notes11.jpg" /><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 247px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5435335231697722034" border="0" alt="" src="http://3.bp.blogspot.com/_HL5CPyr73rQ/S24wmHiCGrI/AAAAAAAAADw/lAPfYLOo0zU/s320/ISIS+EC+Module+4+-+Notes21.jpg" />The following is the screenshot of the spreadsheet and the results are compared with Example 1 and the Assignment example 1 in Appendix B of ISIS Concrete Education Module No. 4. As can be seen, the results match correctly for the neutral axis with slight difference of moment capacity of 1.96% only. This difference is inmaterial as it is due to rounding off in the manual calculation. <img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 247px; DISPLAY: block; HEIGHT: 320px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5435331048656962690" border="0" alt="" src="http://4.bp.blogspot.com/_HL5CPyr73rQ/S24syofZhII/AAAAAAAAADY/X20EF4_DRmg/s320/CSA-BSECT+FRP+(without+Initial+Strain)11.jpg" />The spreadsheet is only halfway done as I still need to include the shear portion. But this will be the easy task. I will publish the complete spreadsheet for all to download and test.<br /><br /><br />CSA A23.3 with FRP strengthening and with steel plate strengthening are almost completed and will be published in the couple of weeks time. Most of it already written in BS8110, TR55. I have not yet published them due to the limited examples for testing the spreadsheet. If anyone can direct me with websites that contain examples, I will be glad to verify the programs and publish them for testing.Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com20tag:blogger.com,1999:blog-7432647566268395639.post-47078359963760350382010-01-27T06:26:00.000-08:002010-01-27T06:44:49.761-08:00Continuous Beam Analysis and Design Using OpenOfficeAs mentioned in the earlier post, OpenOffice is free. My idea is to convert all my Excel spreadsheets with Macro to OpenOffice Calc programs. Remember the OpenOffice Calc is free and engineers are generally poor. If we don't have to pay for Excel, we could save quite a fair bit in our works. Well to cut it short, here it is :<br /><br />This is the screenshot of the similar Excel program that now is written in OpenOffice. The conversion from Excel to OpenOffice was actually simpler than I thought. At first, there are errors. But after closer look, I realise not all the formulas can be directly converted. It was not really the problem of OpenOffice as my codes actually contain very specific way of reading some information and this cannot be directly translated to OpenOffice. After some checking, the errors were corrected and the OpenOffice program output the same results as the Excel program (as expected). <div></div><div> </div><div>What is difficult is the macro for excel cannot be directly convert to OpenOffice macro. This is the painful part for me, as there are not many books and resources on writing Macro for OpenOffice and the process is also much more tedious than VBA. After 2 weeks of on and off writing, main part of the Macro was in shape but one crucial problem was bugging me, ie how to unload the menu after popping up. I decided to stop for a week and send the code to a friend who are familiar with OpenOffice to take a look. He is helpful but can't really give the solution. Then suddenly, I come across a website and briefly talk about the similar issue (not exactly but was along that line). I copy the idea and "hola", it solved. Now the macro works exactly like Excel program. </div><div></div><div>I am waiting for the release of OpenOffice 3.2 for testing the program further. </div><div> </div><div></div><div></div><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 404px; DISPLAY: block; HEIGHT: 250px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5431426315502819650" border="0" alt="" src="http://4.bp.blogspot.com/_HL5CPyr73rQ/S2BNdP9BGUI/AAAAAAAAADQ/x7MkdWZy7xI/s320/cont.bmp" /><br /><div></div><br /><div></div><br /><div></div>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com7tag:blogger.com,1999:blog-7432647566268395639.post-20710747462142862502010-01-27T06:15:00.000-08:002010-01-27T06:48:19.248-08:00Splice Joint Design to BS5959-2000This is the splice joint design screenshot. I have been very busy for the last few months and find very little time to update the blogs and reply to all the queries. I will try to find time to reply to all of you. <img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 406px; DISPLAY: block; HEIGHT: 275px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5431424285836648610" border="0" alt="" src="http://4.bp.blogspot.com/_HL5CPyr73rQ/S2BLnG25IKI/AAAAAAAAADI/30BsQJ7ZTOw/s320/splice.bmp" /><br /><div></div><div>Some of you have received my spreadsheets and given very valuable comments for my improvement. Most notably comments are from the Iran and India engineering community that have responded and tested the Excel spreadsheets and given positive feedback. So far there is no error found except some improvement suggested from the users. I am so busy with my current works that simply can't find time to update further. Well, hopefully, this year I will be able to incorporate all the comments and resend to all the reviewers. </div><div> </div><div>If you like my works, please send me a email or just post your comments. I really hope the Canadian Engineering communities can also read this and appreciate the works that I have done. </div><br /><div></div><br /><div></div>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com2tag:blogger.com,1999:blog-7432647566268395639.post-18068610632864416172010-01-27T05:57:00.000-08:002010-01-27T06:13:23.190-08:00Simple Cleat Bolt Design BS5950 - 2000This the screenshot of the simple cleat with bolted design. The design checks are very comprehensive. Not only the bolts are being check, the cleat, block shear, eccentric moment due to reaction etc are being checked. Currrently, the design is based on BS5950 -2000.<br />This program is thoroughly cross check with BSI design example and found to be accurate.<br /><br />The similiar program is also written in Canadian Code CAN/CSA-S16.1. But the program is not fully tested for accuracy yet. Till I find a suitable example for cross-checking, I will publish the results and screenshot.<br /><br /><a href="http://2.bp.blogspot.com/_HL5CPyr73rQ/S2BH-uwVBFI/AAAAAAAAADA/LZVvO8hYhr0/s1600-h/Simple.JPG"><img style="TEXT-ALIGN: center; MARGIN: 0px auto 10px; WIDTH: 420px; DISPLAY: block; HEIGHT: 298px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5431420293637014610" border="0" alt="" src="http://2.bp.blogspot.com/_HL5CPyr73rQ/S2BH-uwVBFI/AAAAAAAAADA/LZVvO8hYhr0/s320/Simple.JPG" /></a> <div><a href="http://1.bp.blogspot.com/_HL5CPyr73rQ/S2BGz98H4GI/AAAAAAAAAC4/xvm1tAF7-Ps/s1600-h/Simple1.jpg"></a></div><div></div><div><br /> </div><div><br /></div><br /><div></div><br /><div><br /></div><br /><div></div>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com41tag:blogger.com,1999:blog-7432647566268395639.post-86073469717074355072009-10-31T17:47:00.000-07:002009-10-31T17:51:54.753-07:00RC Concrete Design Using EC2After developing most of the spreadsheet in BS8110 and CSA, I have started converting some of the spreadsheet into EC2. Well, EC2 is somewhat similar to Bs8110 with some variants. But generally, the concept behind is similar.<br /><br />In the coming weeks, I hope I could post all the spreadsheets in my blogs.Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com6tag:blogger.com,1999:blog-7432647566268395639.post-49309930955347494482009-07-17T18:33:00.000-07:002009-07-17T18:46:31.260-07:00Beam Flexural & Shear Design to CSA A23.3-04<div align="left">Beam Flexural &amp; Shear Design (Excel &amp; Calc) - Reinforced concrete design in accordance to Canadian Concrete Code CSA A23.3-04. By inputing the moment and shear force, reinforcement required for the section can be design.</div><p align="center"><a href="http://2.bp.blogspot.com/_HL5CPyr73rQ/SmEnD4s_2UI/AAAAAAAAACw/LhHI0D7mlF0/s1600-h/CSA-1.JPG"><img style="WIDTH: 383px; HEIGHT: 223px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5359607979261811010" border="0" alt="" src="http://2.bp.blogspot.com/_HL5CPyr73rQ/SmEnD4s_2UI/AAAAAAAAACw/LhHI0D7mlF0/s320/CSA-1.JPG" /></a></p><p align="left">The program is easier to use than the commercial software as the input can be altered any time and the design check is clearly printed so that check can be carried out manually, if needed. The program was cross-checked with commercial software and found to be adequate. </p>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com3tag:blogger.com,1999:blog-7432647566268395639.post-61549925326986402182009-07-13T19:04:00.000-07:002009-07-13T19:31:01.142-07:00Composite Steel Column to EC4 Using Excel & CalcComposite Column Design to EC4 (Excel &amp; Calc) - The spreadsheet program can design and check the rectangular concrete column with steel I-section, Concrete filled circular section (CHS) and Concrete filled rectangular section (RHS &amp; SHS ).<br /><br />A screenshot of the rectangular concrete column with steel I-section is show below:<br /><br /><p align="center"><a href="http://1.bp.blogspot.com/_HL5CPyr73rQ/Slvp3v2BvKI/AAAAAAAAACg/_F8h9AR5Hm4/s1600-h/EC4-1.JPG"><img style="WIDTH: 401px; HEIGHT: 288px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5358133325632486562" border="0" alt="" src="http://1.bp.blogspot.com/_HL5CPyr73rQ/Slvp3v2BvKI/AAAAAAAAACg/_F8h9AR5Hm4/s320/EC4-1.JPG" /></a></p><p align="left">Reinforcement can also be added to the section. Moment capacity check and interaction ratio check according to EC4 will also be carried out. </p>Similarly, the program can also carried out concrete filled circular section CHS, rectangular section RHS and square section SHS.<br /><p align="center"><a href="http://2.bp.blogspot.com/_HL5CPyr73rQ/SlvrLLe0heI/AAAAAAAAACo/JQqyhLzwS9g/s1600-h/EC4-2.JPG"><img style="WIDTH: 427px; HEIGHT: 279px; CURSOR: hand" id="BLOGGER_PHOTO_ID_5358134758980486626" border="0" alt="" src="http://2.bp.blogspot.com/_HL5CPyr73rQ/SlvrLLe0heI/AAAAAAAAACo/JQqyhLzwS9g/s320/EC4-2.JPG" /></a></p><p align="left">The excel and calc spreadsheet were tested using examples and also compared with the EC4 capacity tables listed in the handbook. The results are exact and proved to be accurate.</p><p align="left">For the same Excel and Calc spreadsheet, section capacity check for steel section subject to axial force, bending moment and shear force are also included. The section check is applicable to UB or UC section with fully restraint or non-restraint conditions. User will need to input the restraint length to calculate the buckling moment capacity.</p>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com13tag:blogger.com,1999:blog-7432647566268395639.post-90167768856560158162009-07-13T06:25:00.000-07:002009-07-13T06:28:33.102-07:00Watermark @ Robertson Quay - Conservation of old facade and new construction of residential units<br /><div style="text-align: center;"><br /></div><div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_HL5CPyr73rQ/Sls2QyETUhI/AAAAAAAAAB4/aq9R2JeAU4A/s1600-h/DSCN0480.JPG"><img style="cursor: pointer; width: 389px; height: 291px;" src="http://4.bp.blogspot.com/_HL5CPyr73rQ/Sls2QyETUhI/AAAAAAAAAB4/aq9R2JeAU4A/s320/DSCN0480.JPG" alt="" id="BLOGGER_PHOTO_ID_5357935843632960018" border="0" /></a><br /></div>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com0tag:blogger.com,1999:blog-7432647566268395639.post-69572884312850850602009-07-13T05:52:00.000-07:002009-07-13T05:52:19.062-07:00Structural Analysis & Design: Structural Analysis Programs in Excel Spreadsheet<a href="http://structure-design.blogspot.com/2009/07/structural-analysis-programs-in-excel.html#links">Structural Analysis &amp; Design: Structural Analysis Programs in Excel Spreadsheet</a>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com0tag:blogger.com,1999:blog-7432647566268395639.post-78301725871664734642009-07-12T22:22:00.003-07:002009-07-12T22:22:36.042-07:00<div class="post-body entry-content"> Queens Condonminium - 3 Block of 39 Storeys Highrise Apartment Units at Queensway, Singapore. Analysis and design of the structure was carried out using ETABS and SAFE programs.<br /><p align="center"><a href="http://4.bp.blogspot.com/_pVG1ZoqgSLM/SllaRuLGCJI/AAAAAAAAAAw/xZyVUrwIfus/s1600-h/DSCN0944.JPG"><img style="width: 333px; height: 257px;" id="BLOGGER_PHOTO_ID_5357412492232755346" alt="" src="http://4.bp.blogspot.com/_pVG1ZoqgSLM/SllaRuLGCJI/AAAAAAAAAAw/xZyVUrwIfus/s320/DSCN0944.JPG" border="0" /></a></p>Flatplate with shearwalls system is use as the structural system. The design is very efficient and won the Construction Excellency Award and Buildable Award from Building Authority of Singapore (BCA). </div> <span class="post-author vcard"> Posted by <span class="fn">Structural Design</span> </span> <span class="post-timestamp"> at <a class="timestamp-link" href="http://structure-design.blogspot.com/2009/07/queens-condonminium-3-block-of-39.html" rel="bookmark" title="permanent link"><abbr class="published" title="2009-07-11T20:30:00-07:00">8:30 PM</abbr></a> </span> <span class="reaction-buttons"> </span> <span class="star-ratings"> </span> <span class="post-comment-link"> <a class="comment-link" href="https://www.blogger.com/comment.g?blogID=7523142737126409651&amp;postID=4130092211240928278&amp;isPopup=true" onclick="'javascript:window.open(this.href," toolbar="0,location="0,statusbar="1,menubar="0,scrollbars="yes,width="400,height="450">0 comments</a> </span> <span class="post-backlinks post-comment-link"> </span> <span class="post-icons"> <span class="item-action"> <a href="email-post.g?blogID=7523142737126409651&amp;postID=4130092211240928278" title="Email Post"> <img alt="" class="icon-action" src="img/icon18_email.gif" width="18" height="13" /></a><a href="email-post.g?blogID=7523142737126409651&amp;postID=4130092211240928278" title="Email Post"> </a> </span></span>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com0tag:blogger.com,1999:blog-7432647566268395639.post-7299573059954957422009-07-12T22:22:00.001-07:002009-07-12T22:22:16.772-07:00Orchard Central - 12 Storeys luxury shopping malls at Orchard Road. The structure is post-tensioned beams with composite steel columns.<br /><p align="center"><a href="http://2.bp.blogspot.com/_pVG1ZoqgSLM/SllbwY4dx4I/AAAAAAAAAA4/6ALu-VZn_mY/s1600-h/Orchard+Central.jpg"><img style="width: 320px; height: 271px;" id="BLOGGER_PHOTO_ID_5357414118605047682" alt="" src="http://2.bp.blogspot.com/_pVG1ZoqgSLM/SllbwY4dx4I/AAAAAAAAAA4/6ALu-VZn_mY/s320/Orchard+Central.jpg" border="0" /></a></p>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com0tag:blogger.com,1999:blog-7432647566268395639.post-10031674105941687342009-07-12T22:21:00.001-07:002009-07-13T06:25:10.517-07:00<p align="left">Cascadia - 13 Blocks of 10 Storeys luxury condonminium at Upper Bukit Timah Road</p><p align="center"><a href="http://3.bp.blogspot.com/_pVG1ZoqgSLM/SllejDnL17I/AAAAAAAAABA/0Z3Yt1jPUVQ/s1600-h/Cascadia.jpg"><img style="width: 320px; height: 290px;" id="BLOGGER_PHOTO_ID_5357417188092008370" alt="" src="http://3.bp.blogspot.com/_pVG1ZoqgSLM/SllejDnL17I/AAAAAAAAABA/0Z3Yt1jPUVQ/s320/Cascadia.jpg" border="0" /></a></p>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com1tag:blogger.com,1999:blog-7432647566268395639.post-81666951446099213942009-05-23T20:55:00.000-07:002009-05-23T21:01:42.077-07:00Structural Subframe Analysis Using OpenOfficeIn the previous post, I introduced my spreadsheet programs using excel. At the same time, I also developed and converted the Macro in the excel to OpenOffice Macro. The task is pretty daunting for someone like me who is not familiar with Open office.<br /><br />Slowing but painfully, the macro take shape and finally Subframe analysis and Design Program in BS8110 is available in OpenOffice Calc.<br /><br />In the next few post, I will demonstrate the screen shots of my program. I will like to collaborate with anyone that can incorporate the DXF drafting portion in the program.Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com1tag:blogger.com,1999:blog-7432647566268395639.post-46947355371241881132009-04-21T19:07:00.000-07:002009-07-13T06:23:49.707-07:00Subframe/ Continuous Beam using ExcelThis the sample page of the continuous spreadsheet program that I developed. The input is simple and straight forward. The beauty of using spreadsheet is that even if the input is enter incorrectly first time, you could amend it later without going through the entire input process. Output forces are directly printed beside each spans.<br /><div style="font-family: arial; text-align: justify;"><br /><div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_HL5CPyr73rQ/SlszsX0M1xI/AAAAAAAAABo/X47f8YRwIC8/s1600-h/Subframe+1.JPG"><img style="cursor: pointer; width: 408px; height: 254px;" src="http://3.bp.blogspot.com/_HL5CPyr73rQ/SlszsX0M1xI/AAAAAAAAABo/X47f8YRwIC8/s320/Subframe+1.JPG" alt="" id="BLOGGER_PHOTO_ID_5357933019087558418" border="0" /></a></div><br /></div><div style="text-align: justify;"> <span style="font-family:arial;">The are two buttons command, namely "Span Information" &amp; :Input Loa</span><span style="font-family:arial;">d Type". This is where all the macro will be invoked.</span><br /><br /><span style="font-family:arial;">Input :</span> <span style="font-family:arial;">1) By clicking the macro, the input screen would ask for number of span, support conditions, beams span lengths, beam and column sizes in a sequen</span><span style="font-family:arial;">tial way.</span><br /><br /><span style="font-family:arial;">2) Next step is to invoke the Input Load Type macro.</span><br /><br /><span style="font-family:arial;">3) You can input maximum 10 load cases for each spans. Uniformly distributed load, triangular load, point load, trapezoidal load and linear load are all the load cases.</span><br /><br /><span style="font-family:arial;">4) No analysis step is needed as analysis will be completed the moment the last load case is completed.</span><br /><br /><div style="text-align: justify;"><span style="font-family:arial;">5) The support reactions for Dead Load, Live Load and ultimate load &amp; column moment will also be computed and shown in the spreadsheet.</span> <span style="font-family:arial;"><br /><br /></span><div style="text-align: center;"><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://1.bp.blogspot.com/_HL5CPyr73rQ/Sls0xXlWnnI/AAAAAAAAABw/VaZGAHXlTMQ/s1600-h/Subframe+2.bmp"><img style="cursor: pointer; width: 396px; height: 247px;" src="http://1.bp.blogspot.com/_HL5CPyr73rQ/Sls0xXlWnnI/AAAAAAAAABw/VaZGAHXlTMQ/s320/Subframe+2.bmp" alt="" id="BLOGGER_PHOTO_ID_5357934204436258418" border="0" /></a><br /></div><br />Next post, I will illustrated the Subframe analysis spreadsheet usingn OpenOffice.<br /><br /></div></div>Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com1tag:blogger.com,1999:blog-7432647566268395639.post-11872078131997316112009-04-20T23:16:00.000-07:002009-07-13T06:13:13.861-07:00Develop spreadsheet program for Structural Analysis & DesignOver the years, I have developed a comprehensive suite of spreadsheet programs that can carry out reinforced concrete &amp; steel structure analysis and design. The programs generally are in accordance to British Code BS8110 (1985, 1997) and BS5950 (2000). Some of the programs are also available in CSA A23.3-04 code. At the same time, I am also developing all of programs into Canadian RC code CSA A23.3-04 as I intend to move to Vancouver and hopefully can land a job as a structural engineer there.<br /><br />If you find my spreadsheet programs relevant, you could help me by introducing my blogs to the Canadian engineering consulting firms. In the future few blogs, I will paste some of the screen shots of my programs. If you find my programs relevant and useful, please give me your comment. I would like to improve on them. If you are from the Canadian Civil and Structural Consulting community, I would appreciate you could recommend my blogs to them. It will help me to find job opportunity in the future.<br /><br /><div align="justify"> </div><div align="justify">In the next few blogs, I will give a list of the analysis and design programs that I developed and also how to use it. Screenshots of the programs will also be posted for viewers to understand the programs.<br /><br /></div><div align="justify"> </div><div align="justify">My spreadsheet programs were written from the perspective as a practicing engineer. They follow the sequence of design steps and output the results at important checks as per code requirements. Instead of the commercial programs that work like a black box, my programs will allow users to amend the formula so that each user can customize to their needs. At the sametime, some of the spreadsheet programs in the market can be to very detailed in the design calculation (which become too cumbersome to read), I output the key steps and results for manual checking, leaving the routine calculations hidden so that submisson become concise, simple and neat.</div><div align="justify"> </div><div align="justify">In the next few posts, you will find my programs as I explained further.</div><br /><br />Some of the programs are :<br /><br />1) Continuous &amp;Subframe Analysis and Design (Excel &amp; 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.<br /><br />The program is also writtten in OpenOffice and run perfectly well. In future post, I will denote as (Excel &amp; Calc) for Microsoft Excel format and OpenOffice Calc format.<br /><br />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.<br /><br />2) Reinforced Concrete Section Analysis (Rectangular Beams, Rectangular and Circular Column) - (Excel &amp; 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.<br /><br />Currently, the program is written in both BS8110 and CSA A23.3-04.<br /><br />3) Beam Design (Excel &amp; 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.<br /><br />The program can design in both BS8110 and CSA A23.3-04.<br /><br />4) Pilecap Design (Excel &amp; 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.<br /><br />5) Box Drain Design (Excel &amp; 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.<br /><br />6) Retaining wall Design (Excel &amp; 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.<br /><br />7) Corbel Design and Deep Beam Design (Excel &amp; Calc - Design corbel and deep beam using strut and tie model.<br /><br />8) One way and Two Way spanning slab analysis and design (Excel &amp; Calc)<br /><br />9) Pile Penetration Design (Excel &amp; Calc) - The concept of the pile design varies between different countries and regions. In this part of the world, the concept of Meyerhoff Method is used. The method depends on the SPT values to calculate the skin friction and endbearing capacity. The results have been proven to be reliable as instrumented load tests carried out in the pass 15 years in most project had correlate reasonably well.<br /><br />10) Steel section design (Excel &amp; Calc) - the program can check the capacity of the steel UB &amp; UC subjected to biaxial bending, axial force and shear.<br /><br />11) Street Strut Design (Excel &amp; Calc) - The program is use for the design of temporary steel strut to support sheetpile walls, Diaphragm wall and Contiguous Bored Pile wall. It had also taken into account of one-strut failure scenario with reduce factor of safety.<br /><br />12) Composite Steel Column Design to EC4 (Excel &amp; Calc) - The program can calculate the capacities of concrete encased rectangular and circular steel UB &amp; UC and concrete filled hollow section.<br /><br />13) Pad footing design (Excel &amp; Calc)- generally a single columns pad design program<br /><br />14) Eccentricities of piles in a group checking (Excel &amp; Calc) - After pile installation, the eccentricites of piles during installation will create eccentricities in the pilegroup. The program check the group eccentricities for both symmetric and asymmetric pile arrangement.<br /><br />15) Underground water sump capacities check and surface drain size calculation<br /><br />There are still many programs that I have not listed out. I the next blog, I will have some of the screenshots to share.Nobitahttp://www.blogger.com/profile/15880099369519200132noreply@blogger.com152