Getting Started 

In this module we shall look at how one would go about opening the iTWO costX application, adding an iTWO costX Project and Building and explain the terminology differences between the two.

Introduction to Workbooks 

In this module we shall Introduce basic functionality of the workbook and focus on how the workbook is structured.

Import Workbook from Excel 

It is also possible to import data from a single Excel file to multiple levels of an iTWO costX workbook. This would typically be used when importing a Bill of Quantities received from another stakeholder, or when you are a new iTWO costX user and you’d like to import your existing excel templates into an iTWO costX workbook to ‘fast-track’ your workbook setup.

There are many ways data might be stored in an Excel file. Therefore, cleaning and organizing your data before importing will make the process easier and yield better results. For the purposes of this exercise, we shall use existing Bill of Quantities prepared in Excel spreadsheets which have already been cleaned up and organized for illustration purposes. If any further assistance is required, please Click the iTWO costX Help button or use the F1 key on the keyboard to open iTWO costX Help. Once iTWO costX Help is open, search for ‘Import Workbook from Excel’. This will display detailed information on this topic. In this case, formulas will not be maintained from the Excel spreadsheet.

Throughout this module, we will be covering three methods on how one could typically Import a Workbook from Excel. These methods are in no particular order of importance or ease of use. They are merely three different methods that one could use depending on the arrangement of the Excel spreadsheet that is used when importing the data.

Using Dimension Groups in a Workbook 

This module will demonstrate in more detail, various options on how Quantity cells and Quantity Build-up Sheets can be populated within a Workbook using Dimension Groups.

Workbook Tools 

In this module we shall look at some useful workbook tools and use a selection of them to identify and correct quality assurance issues within the workbook.

Workbook Exports 

Once a workbook has been generated or completed, iTWO costX provides the ability to export the Workbook data in various formats depending on the external requirement.

The Export options include the following:

∙ Export Trades to Excel

∙ Export Workbook to Buildsoft Job

∙ Export Workbook to CITE

∙ Export Workbook to DataBuild Bill

∙ Export Workbook to Excel

∙ Export Workbook to Primavera P6

∙ Export Workbook to Tender EXF

For the purpose of this exercise, we will be focusing on the Excel Export ouputs. However, if any of the other options are of interest or are a requirement, please Click the iTWO costX Help button or use the F1 key on the keyboard to open iTWO costX Help. Once iTWO costX Help is open, search for the Export option required. This will display detailed information for the corresponding export option.