CTimeMS – Module SR Special Reports
It is a module which is widely used in the North African and South American markets where tenders are required to be presented with unit price breakdowns in Excel files with specific templates.
Preparation and export of Candy data
Prepare the budget worksheets according to the information objectives required in the report, namely at the level of the variables required (no. of workers, no. of machines, production coefficient, etc.).
To export from Candy the appropriate file(s) to the operation folder, respecting the structure of the export templates and the methodology defined in the manual.
Preparation of the specific report template
There is total freedom in the configuration of the report model according to the format required by the client.
The template can have a minimum number of lines in each group (we suggest 4), because the system will automatically insert the necessary lines.
Parameterisation of the operation
Registration of files with Candy data and report template in the [Parameters] tab.
Registration and activation of the variables to be captured and registered in the report in the [Variables] tab. (ex: nr. men/machines, production coefficient,…)
Registration of the groups of resources required in the report and respective indexing of the resources and variables in each group in the [Resources Groups] tab.
Registering the excel coordinates (row/column) of the fields to be registered in the report on tab [Coordinates 1] – Main Price Sheets and [Coordinates 2] – Auxiliary price sheets (complex resources), as well as other configuration fields.
Data processing and report printing
Process preparation for uploading the subcontracts registered in Candy. (Button 1)
The subcontracts to be processed can be selected in part (in the Subcontract Package field) or in full via button 2.
The automatic creation of Excel folders and maps for the selected subcontracts is done via button 3.