Is there an example of how suppressions can work in a Spreadsheet Pricing engine?

PRESSERO > *Pressero FAQs
Question :Is there an example of how suppressions can work in a Spreadsheet Pricing engine?
 
Answer: Using Spreadsheet Pricing method you can have a condition and based on the condition the other pricing parameter appears or else gets suppressed.
 
 
You can download the example spreadsheet from here: BasicSuppressionExample.xlsx
 
 
When creating the Spreadsheet Price Engine in your Pressero account under Preferences > Price Engines, you need to add the cell mapping for output cells, the cells with the quantity parameters, and any other parameters that match to the spreadsheet file that is going to be used by that price engine. A screenshot of how that will look, and the values used to map the cells on the example spreadsheet are shown below.
 
 
Output Cells:
I4
I5
 
Quantity Parameters:
B3,C3,G11:G17,
 
Other Parameters:
B4,C4,B11:B12,
B5,C5,D11:D12,D3
 
In the attached Spreadsheet you will see there are three Pricing option i.e 
 
i) Quantity
 
ii) What type of paper do you need ?
 
iii) The Color Option which will only appear if the value of the above condition is "Colored Paper"
 
Now you can notice that in the cell D3 there is an if else condition statement as indicated below:
 
=IF(OR(C4=B12),TRUE,FALSE)
 
And based on the above if "What type of paper do you need"="Colored Paper" then only return true or else false.
 
In D4 cell you will see there is another formula as stated below :
 
=IF(D3=TRUE,B5,FALSE)
 
This means if the above D3 condition is True then only shows the B5(Color option) or else do not show the option.
 
Hence using If else you can set a condition as stated above so that the following option only shows if the first condition is true or else suppress the option.
 
Note: This is a test sheet hence you can refer this and design your own spreadsheet for your products.
 
Related article :