Please refer to
Example Excel File.xls while reading these instructions. The scenario in the example spreadsheet is of a brochure product where the customer can choose from the quantities 500, 1000, and 1500.
1) In the calculator engine setup area, enter your quantities as normal in the Quantity Parameters area. In the Calculator Parameters option, you'll have one parameter; in the example file, it is called "Brochures." It does not matter what you actually name it, because you will be hiding it from the customer. That parameter should have 1 option. In the example file, that option is "Yes." Again, it doesn't matter what you name it.
2) (At this point, it will be easier to refer to the sample file while you look at the instructions.) After downloading the Excel file, you'll add 2 identical rows of the "Brochures" parameter; just type "Brochures" as the parameter and "Yes" as the option, two times. Use the Min Qty and Max Qty columns to divide up the price based on the quantity they select. Here are the settings you should use for all the rows:
a) Show As Option: No
b) Applies to: Q1
c) Billing Type: Flat Rate
d) Min Qty/Max Qty: For both of those cells, use one of the quantity parameters you're using (eg. 500, 1000, or 1500 - a different one for each row)
e) Cost Per Billing Unit: Whatever price matches up with the quantity you entered in the Min Qty and Max Qty columns
3) Save the Excel file and upload it to your Calculator pricing engine. Your customer will now see a pricing engine that looks like this:
