Liquefaction

Rating:
26

Description


Liquefaction Induced Calculation During Earthquakes 
The purpose of this spreadsheet is to analyse liquefaction induced settlement during earthquakes
 
Calculation Reference 
"Soil Liqufaction During Earthquakes", EERI Monogram MNO-12, by I.M. Idriss and R.W. Boulanger, 2008.  
 
Calculation Validation
Appendix A and C: Example of SPT-based liquefaction trigering analysis for a single boring, "Soil Liqufaction During Earthquakes", EERI Monogram MNO-12, by I.M. Idriss and R.W. Boulanger, 2008.  
 
Input Parameters: 
Peak Ground Acceleration  = 
Earthquake Magnitude = 
Water Table Depth  = 
Average γ Above Water Table  = 
Average γ Below Water Table  = 
Borehole Diameter = 
Requires Correction for Sampler Liners (YES/NO): 
Rod Lenghts Assumed Equal to the Depth plus 1.5 m (for the above ground extension). 

Calculation Reference
Liquefaction Earthquake
Soil Liqufaction During Earthquakes
Earthquake Engineering

Calculation Preview

Submitted On:
29 Nov 2013
File Size:
259.16 Kb
Downloads:
134
File Version:
1.0
File Author:
pablo naranjo
Rating:
26

 
This download is for Registered Users Only.
Perhaps you need to login or register.
Comments: 7
gvkumar96 5 years ago
In the spread sheet, what is FC%. Is it material passing through No 4 sieve or fines passing through No 200 sieve
gvkumar96 5 years ago
Do you have spreadsheet with feet etc
pablonaranjo 9 years ago
The iterative and circular reference has to be done by each user as follows:
On Excel 2007
On the Formulas tab, in the Formula Auditing group, click the arrow on the Error Checking in-group button, point to Circular References, and then click the first cell listed in the submenu.
On Excel 2010
Make a circular reference work by changing the number of times Microsoft Excel iterates formulas
On the Tools menu, click Options, and then click the Calculation tab.
Select the Iteration check box.
To set the maximum number of times Microsoft Excel will recalculate, type the number of iterations in the Maximum iterations box. The higher the number of iterations, the more time Excel needs to calculate a worksheet.
To set the maximum amount of change you will accept between calculation results, type the amount in the Maximum change box. The smaller the number, the more accurate the result and the more time Excel needs to calculate a worksheet.
NBR1 9 years ago
I'm familiar with this spreadsheet from the Monograph.
I would suggest just enabling iterative calculation; in the formulas tab and it will work fine.
JohnDoyle[Admin] 9 years ago
pablonaranjo has been in touch saying:
JohnDoyle[Admin] 9 years ago
I have awarded a free 3 month XLC Pro subscription by way of thanks. I did notice a circular calculation warning. Does this need correcting?