Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
POLEFDN.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: 523
TOPIC: POLEFDN.xls
#578
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
POLEFDN.xls 10 Years, 4 Months ago Karma: 53  
This thread will track of the version history of the following download:
Pre-Cast Column Connection Design.xls
 
Logged Logged  
 
Last Edit: 2011/08/25 12:54 By JohnDoyle[Admin].
 
  The administrator has disabled public write access.
#1737
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
POLEFDN.xls Update to Ver. 2.0 8 Years, 3 Months ago Karma: 53  
A "glitch" was discovered in the "Pole Fdn (Czerniak)" worksheet of the "POLEFDN.xls" workbook.

I was using a simple iterative approach to solve the polynomial equation for the theoretical embedment depth, "L". In Column V of the worksheet, I have what I term index numbers for each iterative evaluation of the expression to help isolate where the solution converges to zero. Problem was, I had an inadvertent small gap of numbers in the index numbers, and thus they were not completely sequential. One "lucky" gentleman had a design situation where his solution fell at that exact point where the gap in the index numbers occurred, and the solution crashed. Lucky for me he stumbled upon the problem.

This has now been corrected and this workbook is now version 2.0.
 
Logged Logged  
 
  The administrator has disabled public write access.
#2625
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Update to v2.1 6 Years, 3 Months ago Karma: 53  
In both the "Granular Soil (Teng)" and "Cohesive Soil (Teng)" worksheets of the "POLEFDN.xls" workbook, I added the calculations for the value and location of the maximum moment in the pole foundation.

This added information was obtained via another reference that I recently came across, AASTO Publication LTS-5 - "Standard Specifications for Structural Supports for Highway Signs, Luminaries, and Traffic Signals (Fifth Edition, 2009). The material in this reference was essentially the same as the original Teng & Associates reference, but included the additional equations for maximum moment and location.
 
Logged Logged  
 
  The administrator has disabled public write access.
#2758
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Update to v2.2 5 Years, 9 Months ago Karma: 53  
I recently updated the "POLEFDN.xls" workbook, where the "Pole Fdn (IBC)" worksheet now references and uses the IBC 2012 (Chapter 18).

Actually, in substance the IBC has not changed for embedded pole-type foundations since the 2006 version of the Code. Only the table and section designations have changed.

The version of this workbook is now 2.2.
 
Logged Logged  
 
  The administrator has disabled public write access.
#3267
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
POLEFDN.xls version 2.3 3 Years, 8 Months ago Karma: 53  
In the "POLEFDN.xls" spreadsheet workbook in the "Pole Fdn (Czerniak)" worksheet it was questioned that the formula shown and used to determine the embedment length (L) was slightly different that shown in the original Czerniak reference cited on the second page of the calculations. The formula that I was using was actually one from the PCA reference where the included coefficients/factors were rounded off to whole numbers as opposed to the unrounded values in Czerniak's original formulas. Since the Czerniak document is what the PCA document is actually based on and what I actually refer to, I made the minor change in the formula for the sake of consistency.

In the process, I also discovered that I had some inconsistency in the variable labeling that was used for the passive resistance parameter. I showed both "R" and "Pp" in different places, so I changed each occurrence of the variable to "R", as was used in the Czerniak reference.

The current version of this workbook is now version 2.3.
 
Logged Logged  
 
  The administrator has disabled public write access.
#3649
ATomanovich (User)
Frog Prince (Platinum Boarder)
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
POLEFDN.xls version 2.4 1 Year, 1 Month ago Karma: 53  
It was brought to my attention that in the "Pole Fnd (Czerniak)" worksheet of the "POLEFDN.xls" workbook that in the section where the plain concrete stresses are checked that I was using the average shear stress and not the maximum value of shear stress for a solid circular cross section. The maximum shear stress for a solid circular cross section is actually 1/3 greater than the average shear stress.

This has been corrected.
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 17 guests and 43 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