Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
BOEF.xls (1 viewing) (1) Guest
This area of the Forum is reserved for notes about the Version history of items in the repository. A link to the related repository item is always included at the top of each thread.
Go to bottom Favoured: 301
TOPIC: BOEF.xls
#564
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
BOEF.xls 10 Years, 4 Months ago Karma: 53  
This thread will track of the version history of the following download:
BOEF.xls
 
Logged Logged  
 
Last Edit: 2011/07/13 12:31 By JohnDoyle[Admin].
 
  The administrator has disabled public write access.
#753
wes616 (User)
Tadpole (Junior Boarder)
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Re:BOEF.xls 10 Years, 2 Months ago Karma: 1  
Any chance there is an unlocked version of this sheet available. I need to change the units from ft to inches and from kips to lbs.
 
Logged Logged  
  The administrator has disabled public write access.
#754
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Offline Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:BOEF.xls 10 Years, 2 Months ago Karma: 493  
Its only a low level security in place to prevent accidental editing. Use Excel's main Menu Tools>Protection>Unprotect worksheet. No passwords are required.
 
Logged Logged  
 
  The administrator has disabled public write access.
#1669
jacky89 (User)
Tadpole with legs (Senior Boarder)
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:BOEF.xls 8 Years, 5 Months ago Karma: 0  
Great spreadsheet.
One comment. Are the units for the Minimum thicknesses supposed to be in inches instead of feet? The minimum thicknesses would be ridiculously large if it was in feet.
 
Logged Logged  
  The administrator has disabled public write access.
#1671
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Re:BOEF.xls 8 Years, 5 Months ago Karma: 53  
No, the units of feet (not inches) for the minimum thicknesses that are determined off of the calculation page to the right are correct. What these seemingly overly large values reflect are what thickness it takes for the beam/footing to actually be considered "theoretically rigid". Engineers frequently assume rigidity in their calculations, but what this spreadsheet will do is help you determine just how rigid or how flexible your beam/footing really is.

Assuming a rigid beam/footing will usually over estimate the flexure (bending), so your rigid assumption for flexure is most always conservative as long as you don't over estimate the effective strip width. Where you can get into trouble is by assuming a rigid condition and if what you have is actually quite flexible, the maximum soil bearing pressure will be under estimated. For a very rigid beam/footing the bearing pressure diagram will be linear, while for a very flexible beam/footing the bearing pressure diagram will be "bulbed" directly under applied concentrated (point) loads. Keep in mind the scaling constraints of the MS-Excel plot for bearing pressure, when examining plots that should be a relatively straight line for a rigid condition.

Alex
 
Logged Logged  
 
Last Edit: 2009/06/02 03:57 By ATomanovich.
 
  The administrator has disabled public write access.
#1677
jacky89 (User)
Tadpole with legs (Senior Boarder)
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
Re:BOEF.xls 8 Years, 5 Months ago Karma: 0  
Thanks for the great explanation. Another question, if I am designing a slab on grade, should I input a width equal to the calculated estimated slab width on the right side of the screen? I'm assuming this is the effective width for supporting point loads.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
We have 8 guests and 44 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative