|
-
To make evrything a little bit more clear:
I've created an Excel sheet which is already a full working price calculator.
Price are build from a number of multiple steps. Let say:
step 1 choose papertype
step 2 choose type of printing
Step 3 etc etc.
Than steps are existing out of options.
Step 1 choose paper type:
Option 1: thin paper
Option 2: Thicker paper
Option 3: coloured paper
etc etc.
Options are data string containing pricing info based on volume, so 1 piece = €1.00 and 100 = 0.80 etc etc (and some product info like max size, min size, etc etc)
At the moment i have a BIG BIG data sheet wich will Vlookup info based on the user requested input.
Than prices wil go to a "simple" formula to create the price.
At the moment with the excel sheet, i have to manully paste the options (thin paper, thick paper) into the excel.
Hope this helps!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|