METHOD OF JET-GROUTING
Description
Drilling is typically performed using rotary drilling techniques and an external water flush with special drill rods and bits. Upon completion of the advancement of the drill rods to the design depth, the jet grouting process commences. The grout is injected through radial nozzles at high pressure and velocity, destroying the soil matrix and forming structural elements.
Many structures and geometries can be achieved by altering the parameters of the jetting procedure. The illustrated procedure details the creation of a jet grout column by continuous rotation of the drill string and controlled pre-set lifting increments.
Calculation Reference
Jet Grouting
Calculation Preview
Submitted By:
Submitted On:
23 May 2014
File Size:
74.91 Kb
Downloads:
230
File Version:
1.1
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
The CK11 I think is not a VLook error, is something not well linked in the final version.
I finally unprotected the worksheet (sorry there) and translated it to spanish, as I needed to do a report, wanted to know what data were really introduced by the user and what was imposed by the application, and finally, because I had a romboid distribution for the jet-grouting columns. Now is working perfectly for me :).
The big question I need to solve right now is the one related to the technical support for this methodology.
Greetings
Sadly, when using MsOffice 2010-2013 (Spanish language versions both cases) I get systematically the following error with the XLC suite:
When opening it detects bad range Name pointing to "/xl/workbook.xml", the report error from Excel:
- error040120_01.xml Se han detectado errores en el archivo "C:\Program Files (x86)\XLC\XLC.xlam" - Registros quitados: Rango con nombre de /xl/workbook.xml parte (Libro)
Registers deleted: range with name /xl/Workbook.xml (Workbook)
Also, the error is reproduced with the Jet Grouting Analysis & Design Worksheet, the report error from Excel: - error040120_02.xml Se han detectado errores en el archivo "C:\Users\user\Downloads\JET_GROUT_ANALYSIS_&_DESIGN_1.1.xlsx" - Excel ha completado la validación y reparación en nivel de archivo. Puede que se hayan reparado o descartado algunas partes de este libro. - Registros quitados: Rango con nombre de /xl/workbook.xml parte (Libro)
In English something like:
Excel has completed validation and reparation in file level. Maybe it can be repaired or deleted some parts of this workbook.
Registers deleted: range with name /xl/Workbook.xml (Workbook)
Continuing with Jet Grouting Analysis & Design Worksheet there are some errors with range names (CTRL+F3):
A --> Seems to be "load area of a column" = Ai
Cn -->
g --> gravity?
L --> z?
qz -->
sbc -->
scoran -->
Sult -->
Ts -->
Yp -->
Everything went working if CK11 is defined as range name, I tried with Fsurface (F range name gives a conflict) and reformulated CK22 to be: "=62,14*N^0,219*H^0,23*Fsurface"
Sorry if my english is not right, but I think this should be:
O9 (Horizontal spacing)
AM19 (adhesion)
AM17 (cohesion)
The same for the report Sheet
If using not english regional settings, Data validation List will give an error in CK11, as they are defined with "." decimal separator inside the List allowed values. Better option, will be to leave a column in the sheet with this values, so Excel will modify them to satisfy new regional settings conf.
Last, and not the least, will be very valuable to have references to the calculation method, as this worksheet can't be used for a professional report if user just can't justify why some values are assumed. I could not find any references to bibliography or where this methodology come from. Please give me a hint so I can dig further.
Kind regards
Report page has been added.
Was added to the flowchart.
General improvements were made.
Report page has been added.
Was added to the flowchart.
General improvements were made.