Warning: INSERT command denied to user 'dbo290588255'@'' for table 'drplwatchdog' query: INSERT INTO drplwatchdog (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '%message in %file on line %line.', 'a:4:{s:6:\"%error\";s:7:\"warning\";s:8:\"%message\";s:40:\"Creating default object from empty value\";s:5:\"%file\";s:71:\"/homepages/25/d199835659/htdocs/PSN/modules/taxonomy/taxonomy.pages.inc\";s:5:\"%line\";i:33;}', 3, '', 'http://www.psnconsulting.com/calculations-spreadsheets/excel-structural-calculators', '', '', 1591339708) in /homepages/25/d199835659/htdocs/PSN/includes/database.mysql.inc on line 135
Excel Structural Calculators | My Drupal site

Excel Structural Calculators

warning: Creating default object from empty value in /homepages/25/d199835659/htdocs/PSN/modules/taxonomy/taxonomy.pages.inc on line 33.
Microsoft Excel Spreadsheets and Structural Engineering Calculators.

Excel Pages

Analysis Wood Concrete Steel Others
Wind Pressures (ASCE 7-10~ASCE 7-05) Wood Joist Concr. Beam Steel Beam Alum. Beam
Shear Wall

Concrete Beam

The concrete Beam Spreadsheet is useful to calculate reinforcements, as well as short and long term deflection check.
Fill the yellow cells as required.

Pole Foundation

Pole Foundation is based on Florida Building Code, Chapter 16.
You may change the confinement pull-down menu, if the top of foundation is confined by concrete slab.

Wall Footing

Spread footing and combined footing spreadsheets are provided here.
Fill the yellow cells as required.

Spread Footing

Spread footing and combined footing spreadsheets are provided here.
Fill the yellow cells as required.

Wood Joist

Wood rafters can be sized by using this spreadsheet. Fill the yellow fields, as required. C coefficient shall be used to modify the Fb allowable stress.
Flectural allowable stress ( Fb ) for Southern Pine #2 are 1500 Psi for 4" member, 1250 Psi for 6" member, 1200 Psi for 8" member, 1050 Psi for 10" member and 975 Psi for 12" member.
Those figure shall be simultaneously multiplied by Cm for moisture, Cr for reputation, etc.

See following documents of NDS
Sections Property

Window Pressures ASCE7-10 & ASCE7-05

The new code ASCE 7-10 has been enforced in Florida as of 3/15/2012.
You may find below the new spreadsheet for ASCE 7-10 for roof pressures, parapet, wall-window pressures.
Use Wind Velocity by CLICKING HERE

ASCE Comments(pdf)



Footing Spreadsheet

Spread or combined footings are the member sof structure to distribute the concentric column load over soil in a way that the allowable soil resistance (load carrying capacity) does not exceed.
The spread sheets given here is only for one-way moment applied footings.

Syndicate content