Template & download¶

To make preparing your experimental database straightforward, numgeo-ACT ships with a ready-to-fill Excel template. It contains one correctly positioned example sheet for each supported test type, so the only thing you need to do is replace the example numbers with your own measurements.

Downloads¶

What's in the template¶

The template workbook contains:

• a Read me sheet explaining how to fill it in, with the sheet-name tags, the units, and the most important rules;
• one example sheet per test type, each with:
  • the header cells (initial void ratio, consolidation stresses, amplitudes, etc.) filled with example values in the exact cells the reader expects;
  • the data columns labelled and populated with a few example rows (marked so you know to replace them);
  • inline notes in the non-read areas of the sheet.

Every sheet is positioned so that the reader interprets it correctly — the template is validated against the reader, so a database built from it will load without surprises.

How to use it¶

1. Download the template and open it in Excel (or any compatible spreadsheet program).
2. For each laboratory test you have, duplicate the matching example sheet and rename it with the next number — e.g. copy CD-1 to CD-2, CD-3, … Delete the example sheets for test types you do not have.
3. Fill in the header cells (initial void ratio, consolidation stresses, amplitudes, number of cycles, …) in the cells indicated.
4. Paste your measured data into the labelled columns, starting on the data row. Keep the units as specified (percent vs. fraction, kPa).
5. Save the workbook. If any columns are computed by formulas, make sure the evaluated values are stored.

6. Point the reader at the workbook:

   from ACT.utilities.excel import excel
   
   database = excel()
   database.collect("my-database.xlsx")