Total : 0.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

× WooPrice Calculator PRO

# [SOLVED] Help with organising the Calculator

3 years 8 months ago #467 by Michel Cheret
Michel Cheret replied the topic: [SOLVED] Help with organising the Calculator
Hi Enrico/Colleague of Enrico,

Thanks for your help! We are going to look further into this.

Kind regards,
Michel

3 years 8 months ago #443 by Enrico
Enrico replied the topic: [SOLVED] Help with organising the Calculator
Hi Michel,

This is what my colleague reply:
===============================================
Hi Michel,
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
Bye
##### Attachments:

3 years 8 months ago - 3 years 8 months ago #437 by Enrico
Enrico replied the topic: [SOLVED] Help with organising the Calculator
Hi Michel,

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.

Kind regards,
Enrico
Last Edit: 3 years 8 months ago by Enrico.

3 years 8 months ago #435 by Michel Cheret
Michel Cheret replied the topic: [SOLVED] Help with organising the Calculator
Hi Enrico,

If you need extra information, please let me know.

Kind regards,

Michel

3 years 8 months ago #403 by Michel Cheret
Michel Cheret replied the topic: [SOLVED] Help with organising the Calculator
Hi Enrico,

Here are the different fields and values.

Thickness:
10 mm
20 mm
50 mm
Length:
2000 mm
Width:
1200 mm

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.

Kind regards,
Michel

3 years 8 months ago #395 by Enrico
Enrico replied the topic: [SOLVED] Help with organising the Calculator
Hi Michel,

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.

Best regards,
Enrico

3 years 8 months ago #388 by Michel Cheret
Michel Cheret replied the topic: [SOLVED] Help with organising the Calculator
Hi Enrico,

I didn't solve the problem, I still need some support from you.

Kind regards,
Michel Cheret

3 years 8 months ago #386 by Enrico
Enrico replied the topic: [SOLVED] Help with organising the Calculator
Hi Michel,

So did you solve the problem or do you need to find the old formula?

Best regards,
Enrico

3 years 8 months ago #376 by Michel Cheret
Michel Cheret replied the topic: [SOLVED] Help with organising the Calculator
Hi Enrico,

I think I deleted the old formula, that's why I cannot seem to find it anymore.
The link to the product is: deschuimspecialist.nl/winkel/zacht-schuim/dsse-103x-5h-rood/

Kind regards,
Michel

3 years 8 months ago #355 by Enrico
Enrico replied the topic: [SOLVED] Help with organising the Calculator
Hi Michel,

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?

Kind Regards,
Enrico

3 years 8 months ago #354 by Michel Cheret
Michel Cheret replied the topic: [SOLVED] Help with organising the Calculator
Hi Enrico,

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.

Thanks,
Michel

3 years 8 months ago #352 by Enrico
Enrico replied the topic: [SOLVED] Help with organising the Calculator
Hi Michel,

What do you mean with "I fill in the maxsize in the Excel sheet" and "calculates an price based on the output price".

Best regards,
Enrico

3 years 9 months ago #350 by Michel Cheret
Michel Cheret created the topic: [SOLVED] Help with organising the Calculator
Hi,

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?
##### Attachments:

Moderators: david
Time to create page: 0.200 seconds

Total : 0.00 €