• Get Current Guidance
  • Downloads then current value guidance data from the Global Database Warehouse and overwrites the existing file. A value guidance file is routinely downloaded weekly.
• Export Charge Rates/Costs
  • Opens a command specification form for input of criteria to be used to automatically produce a report for export of current Charge Rates or Forecast Cost values to third-party systems.

Export Charge Rates/Cost #

This command is used to produce and export a report in Excel workbook format of either the charge rates or the total cost for the Rate Period for all Machine Records in the active Estimate. Those two reports are used to load job cost estimating and equipment cost accounting systems respectively. Report election is made using the respective radio buttons in the form. The current results are reported in the CR Report sheet and Cost Report sheets. Exported Excel workbooks are stored in the “Reports” folder in the Ironworks ECM folder. The workbooks are password protected with the password set by the subscriber during the subscription process.

The layout and content of the elected report are specified using the form’s two selection panels.

The left panel enables the selection of Machine Record properties for grouping reported values. The order of the value grouping is set by the order of selection, i.e., the first property selected is the first group, the second property selected is the second group, and so forth. Properties are selected or de-selected by clicking on them in the list.

The right panel enables the selection of the CBS values reported. The order of the values is set by the order of selection, i.e., the first property selected is the first value in the report to the right of the selected machine properties, the second property selected is the second value to the right, and so forth. Values are selected or de-selected by [Control-clicking] on them in the list.