Please note that using the Spreadsheet Pricing Engine requires advance knowledge of Excel and is included only in Pressero Enterprise Packages. Because of the technical nature of this method, we are unable to provide free technical support beyond what is already included in this article.
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.
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