Do you have an advanced example of an Spreadsheet Pricing Engine that includes various common types of options and calculations for print jobs?

 

This is an advanced Spreadsheet Pricing Engine example that incorporates many different options and calculations; Quantity up to 999, 1 or 2 Sides, a Markup up to 30%, Fixed Cost values and Variable Cost values for Costs Calculations embedded in the worksheet, options for Proofing, Fold and Crease, detailed options for Paper Type, Paper Size and Celloglazing options are all available in this example.

 

This example is similar to the example spreadsheet shown in Ch. 014. Creating a Spreadsheet Method Pricing Engine but it is different, and has more options and calculations used in the worksheet. 

 

 

The Excel file shown here can be downloaded here SpreadsheetCalculatorWebinarPresentation.xlsx, please review the presentation PDF file that talks about different concepts used in this spreadsheet example here SpreadsheetCalculatorWebinarPresentation.pdf, and the cell coordinates to use when setting up the pricing engine as used in the example spreadsheet are shown below, for your reference.

 

OUTPUT CELLS
F13
F15
F17


QTY PARAMETERS
B14,C14,N14
B15,C15,P19:P20
B22,C22,N21


OTHER PARAMETERS
B16,C16,V15:V32
B17,C17,W14:AC14
B18,C18,M37:M41
B19,C19,R19:R20
B20,C20,S25:S26
B21,C21,S29:S30