# NOBITA

Structural Anaysis & Design Using Excel and OpenOffice

## Saturday, February 6, 2010

### FRP Strengthening of RC Structure - CSA A23.3

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. 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.

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.

## Wednesday, January 27, 2010

### Continuous Beam Analysis and Design Using OpenOffice

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).

### Splice Joint Design to BS5959-2000

### Simple Cleat Bolt Design BS5950 - 2000

This program is thoroughly cross check with BSI design example and found to be accurate.

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.

## Saturday, October 31, 2009

### RC Concrete Design Using EC2

In the coming weeks, I hope I could post all the spreadsheets in my blogs.

## Friday, July 17, 2009

### Beam Flexural & Shear Design to CSA A23.3-04

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.

## Monday, July 13, 2009

### Composite Steel Column to EC4 Using Excel & Calc

A screenshot of the rectangular concrete column with steel I-section is show below:

Reinforcement can also be added to the section. Moment capacity check and interaction ratio check according to EC4 will also be carried out.

Similarly, the program can also carried out concrete filled circular section CHS, rectangular section RHS and square section SHS.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.

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.