[SOLVED] Help with organising the Calculator
July 7, 2017 at 3:47 am #8159
I’ve been using the wooprice calculator for a short while and I’m very pleased with it.
Since today I’ve upgraded to the proversion, but I need some help with the new calculator.
When I upload the Excelfile it works fine and it gives me the possibility to map the fields.
I have a webshop where I want that customers can fill in the fields what I have defined in the fields tab, I fill in the maxsize in the Excel sheet. And the Woo Price Calculator, calculates an price based on the output price. Am I doing something impossible here? Or does this still need some work?
Could you please help?July 17, 2017 at 9:55 am #8171
What do you mean with “I fill in the maxsize in the Excel sheet” and “calculates an price based on the output price”.
I want to best understand the problem to help you
EnricoJuly 17, 2017 at 10:41 am #8170
I understand your question.
What I want is to fill in the maximum size of the product. The maximum size given by the supplier is 2000mm, if I fill in this value (combined with size 1200mm and 50mm) the calculator should give the output of the max prize 9,85.
Otherwise I have to calculate every product and every size displayed. Like: 200mm + 300mm + 10mm = 3,50 for example. I don’t want to do this, because I have bought the calculator for this. So based on the maximum sizes as displayed in the screenshot, the calculator should give the outputprice based on the maximum sizes. Do you think that’s possible?
I have made a calculator before with a formula that displays the right price, but now I want to do this with the Excel calculator.
MichelJuly 18, 2017 at 2:55 pm #8169
If you can do the same calculator you did with formula using the Excel calculator would solve the problem?
What is the formula that you used for the formula calculator?
As I can see from your screenshot you have already made a Excel calculator, could you please send to me the URL of the product?
EnricoJuly 25, 2017 at 7:15 pm #8168
Sorry for my late reply.
I think I deleted the old formula, that’s why I cannot seem to find it anymore.
The link to the product is: http://deschuimspecialist.nl/winkel/zacht-schuim/dsse-103x-5h-rood/
MichelJuly 27, 2017 at 3:49 pm #8167
So did you solve the problem or do you need to find the old formula?
EnricoJuly 27, 2017 at 5:27 pm #8166
I didn’t solve the problem, I still need some support from you.
Michel CheretJuly 28, 2017 at 3:24 pm #8165
If you give me the list of the fields you want to show and an explanation of what kind of formula you are trying to do in Excel, I will try to write it for you.
EnricoJuly 30, 2017 at 6:43 pm #8164
Here are the different fields and values.
The maximum price (what I got from my supplier) are:
10 mm x 2000 mm x 1200 mm = € 9,86
20 mm x 2000 mm x 1200 mm = € 17,85
50 mm x 2000 mm x 1200 mm = € 42,02
For example a customer fills in the fields: 34 mm x 1500 mm x 800 mm = € ???
I don’t know how to calculate this to be honest and what baseprice I need to handle.
Thanks for your help!
MichelAugust 7, 2017 at 3:17 pm #8163
If you need extra information, please let me know.
MichelAugust 8, 2017 at 2:23 pm #8162
I gave the task to my colleague. He knows Spreadsheets more then me.
I will let you know, I know that he is working on it in these days.
EnricoAugust 8, 2017 at 3:33 pm #8161
This is what my colleague reply:
If you have a look on this attached excel worksheet, you discover that the price is non linearly parametric on the volume.
More material you buy, more discount you get.
In fact the supplier:
apply 9% of discount when you buy the 20 mm thickness of the material
apply 15% of discount when you buy the 50 mm thickness of the material
So I image that the discount applied for 34 mm x 1500 mm x 800 mm could make the price just about more or less 15,50 €!
So, is mandatory that your supplier have to give to you his excel worksheet or explain to you how he computes the price
ByeAugust 15, 2017 at 11:34 am #8160
Hi Enrico/Colleague of Enrico,
Thanks for your help! We are going to look further into this.
- You must be logged in to reply to this topic.