Help needed for Price Quote Estimator Calculator

[savytoal]

Hello!

This is my first post on here and I'm looking for some help. I have no idea how to code or how it works, but I need some advanced help. I need a price quote estimator calculator for my website. I am building the website on Wix and they don't have a third party app advanced enough to do the job I need done. I went to online services to try to make my own, but still not advanced enough to calculate what I need calculates.

Basically the estimator quotes how much a custom ceramic piece would roughly cost. The company this is for is a big manufacturer of custom metal, wood and ceramic pieces for those who need them done.

The Standard Pricing Guide goes like this:

Overall Dimensions:
[INDENT]Length x
[INDENT]Width y
[INDENT]Height z
X*Y*Z = I Value

if I Value =
0-50 then divide I Value by 7
50-100 then divide I Value by 9
100-200 then divide I Value by 12
200-300 then divide I Value by 15
300 - up then Talk to Rep

Case Quantity (I value * Case Quantity then apply discount for higher quantities)
500 pieces = I value
1000 pieces = I value * .85
2500 pieces = I value * .80
5000 pieces = I value * .75

Additions:
- Do you require a hand painted design? Y or N = add 20% to overall order
- Do you want special gift/retail packaging? Y or N = add 25% to overall order

I want the form to have a name and email spot on there too.

Let me know if y'all can help me or send me somewhere in the right direction to help me out. I am completely lost when it comes to this kind of things. Thank you for reading! If you have any other questions let me know. Thanks
Sav

[dinge02]

Hope some expert would chime in! Curious too how to make this done.

[styxlawyer]

This is a job for PHP but, unfortunately, Wix doesn't support PHP files. You may have to move your site to Wordpress or Joomla.

[savytoal]

This is a job for PHP but, unfortunately, Wix doesn't support PHP files. You may have to move your site to Wordpress or Joomla.

I started creating an Excel file with the formulas and then I would upload it to a site called lead doubler, but when I upload it, the calculations don't work. I am not familiar with PHP, but I could probably figure it out. Is there a way that I would embed the PHP in Wix?

[styxlawyer]

.
Is there a way that I would embed the PHP in Wix?

No, Wix won't allow the execution of PHP files, however it may be possible to make a JavaScript page which does this.

[styxlawyer]

Try this JavaScript form:

estimator.zip