Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
474 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

screenshot for Five Price Percentage Levels (Sales)

Detail

This is a variant of Five Price Levels (Sales, Amount) (c4012). It differs from the original version in that it uses percentage values in the price fields.

The five price fields in the original database definition are decimal (15, 6), which is enough for storing a percentage value. In this implementation, the first price custom field (Discount Price A) is used as the base price, and the other 4 prices (from Discount Price B to Discount Price E) are used to store discount percentage values.

For example, product "ABC-01" has five custom fields defined for prices, named from "Discount Price A" to "Discount Price E", and the values are 19.00, 0.11, 0.21, 0.31, and 0.41. If the discount level of a customer is 1 and he purchases the product "AB-01", the base price of 19.00 will be applied. If the customer's discount level is 3, the discount will be 0.21 (i.e., 21%), and the applied price will be calculated as follows:

19 * (1-0.21) = 15.01

Format and Specification

Template#c4014
Belongs to

Sales

Format (XLS or XLSX).xlsx
Columns4
Lines30
Line Height (Points)13.50
Print Area$H$3:$O$57
Papaer OrientationPortrait
Default Margins (Points)
Left18.00
Right18.00
Top73.70
Bottom73.70
PriceFree