Liquefaction
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:
Calculation Preview


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
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Soil Liqufaction During Earthquakes
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Earthquake Engineering
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
29 Nov 2013
Submitted By:
pablonaranjo
File Date:
29 Nov 2013
File Author:
pablo naranjo
File Version:
1.0
File Size:
259.16 Kb
File Type:
xlsx
Downloads:
88
Rating:
stars/4.gifTotal Votes:1
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#7 gvkumar96 2017-01-05 14:28
In the spread sheet, what is FC%. Is it material passing through No 4 sieve or fines passing through No 200 sieve
 
 
#6 JohnDoyle[Admin] 2017-01-02 07:34
 
 
#5 gvkumar96 2017-01-02 01:11
Do you have spreadsheet with feet etc
 
 
#4 pablonaranjo 2013-12-10 03:11
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.
 
 
#3 NBR1 2013-12-10 01:50
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.
 

Please sign in or register to add a comment.

We have 20 guests and 39 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