By using an Excel file (xlsx) to store and edit Quantifier Cost Data, it is easy to use common cost data across multiple SKP models. All of the cost data can be stored in the master Excel file and then imported into other SKP files as needed. The Excel cost data can also be driven by formulas that are linked to another worksheet.
Export SKP Cost Data to a New Excel File
Use this feature to create the base Excel template file that will contain all of the Quantifier Pro cost data. It is best to start out with a SKP file that already contains your standard Quantifier Pro cost data.
- Click the 'Report Settings' button on the main toolbar.
- Click the 'Export SKP cost data to Excel' button.
Save the Excel File
Save the file to the location of your choice.
Open the Excel File
Quantifier Pro will ask if you want to open the file you just exported.
Open the file. It contains all of the Quantifier Pro cost and weight data that was in the SKP model.
Comments
1 comment
when this feature is available for Mac users
Please sign in to leave a comment.