Engineering Manual No. 51: Using Formulas in Templates with GEO5 Stratigraphy


This fifty-first manual in the GEO5 engineering series focuses on utilizing formulas within templates in the GEO5 Stratigraphy program. The manual demonstrates how to add formulas for automatic recalculations of test data, such as calculating the friction ratio in a CPT test, and integrating these formulas into output protocols. Available for download, this manual is essential for geotechnical engineers who need to customize and automate data processing in their field test reports.

Learning Objective:

The goal of this manual is to teach users how to use formulas within the GEO5 Stratigraphy program to automate calculations and modify output protocols. Users will learn how to create and integrate formulas into templates, ensuring that specific test data is automatically recalculated and displayed in field test reports.

Assignment Description:

In this assignment, users are tasked with modifying the “EN-Standard” CPT template to include a new “Friction ratio” column. The assignment involves creating a formula for this column, configuring the output log to display the calculated friction ratio, and saving the modified template set as “EM 51” for future use. The manual provides step-by-step instructions for editing templates, adding formulas, and customizing output protocols to reflect the newly calculated data.

Outcome:

Upon completing this assignment, users will be able to effectively use formulas in the GEO5 Stratigraphy program to automate data recalculations and customize field test reports. They will gain practical experience in modifying templates, creating and applying formulas, and ensuring that their output protocols meet specific project requirements.

Conclusions:

The manual concludes that using formulas in GEO5 Stratigraphy templates enhances the efficiency and accuracy of field test reports by automating calculations and customizing data presentation. By following the steps outlined in the manual, users can ensure that their templates are tailored to specific needs, improving the quality and clarity of their reports.


📥 Download LINK