You are here: Home Cost Register Report
The Mandrel cost register is closest to what most people think of as a costing spreadsheet. The difference is that, with a simple spreadsheet the data and the report are one and the same, so it cannot easily be modified to show different aspects of the data. With a Mandrel cost register, the data is contained elsewhere in your datafile and the report is simply an extract from that data, so you have complete control over what is shown and how it is laid out.
A cost register consists of rows and columns of data. You can control what each row and column contains, as well as all aspects of formatting. You can optionally have a header block containing general information such as unit prices or tax rates. Mandrel's built-in conditional formatting can be used to highlight items of interest.
Each field, or column, in a Mandrel cost register is calculated independently of all the other fields (there are no spreadsheet formulas in it). If, for example, you have a right hand column showing the overall cost for each line item, its values will not be altered if you add or remove other fields.
Once you have created a report you can edit any of the data from which the report is derived simply by double-clicking on it. That section of the report will then be re-written to show the changes.
Cost register reports can show individual cost items or they can show rolled-up costs, i.e. costs combined into larger groupings. You can show costs rolled up to a particular level in the cost breakdown structure, or you can show them rolled up by some field that you have defined yourself, such as Task Manager or Responsible Organization.