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

Help with excel calculation

More
1 month 2 weeks ago #1722 by Paul
Paul replied the topic: Help with excel calculation
Hello
  1. what we did was:
    • Create the the input fields.
    • Set the values in the list fields as it was required in the excel file. So I looked in your file excel and see the input values you use it in it.
    • Remove the IF functions in the subtotals and use more performance functions as MATCH and INDEX.
  2. If you want only to show a number of days I guess you can do it. Because actually the output fields can be only numeric.
    you can write:
    • Rename label (as example): "numbers of days from today"
    • Set field as output and of type numeric
    • Use excel functions to calculate the numbers of days
    • Map the cell excel with your output field
You can do the other option too, I mean set the date as input field. By this way in your order will be shown the date the user chose. So maybe it's better for you.

If you instead want to show output fields different from numeric ones, it would be necessary a quote.

Let us know if you have more questions.

Best Regards
Paul
AT575

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #1721 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
That is great , I guess it works, I just need to some tweeks and I hope it will still working, what did you changed ??
(just to be sure I can do it in the future)

2.- Is there a way it show X days from today when selecting the Printing speed ?
I am trying to show today date and today date + X days not sure if that is possible
or if is better to let customer to select date from calendar and calculate the service speed needed based in that.
this will be this plug in an amazing tool and all I was praying for.

thank you very much!

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #1719 by Paul
Paul replied the topic: Help with excel calculation
Hello

Can you check again?
I think it works now (see the attachment).


Best Regards
Paul
AT575
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #1714 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #1713 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
Please check attachments, you said it work but only calculation is width x height x price as in your examples,
1) when I select for example the service turn around, (printing speed), " like in 72 hours for extra $89" in the last box, it does not add $89 to the total banner price
2) when I select for example: Rolled in a tube (instead in a box) it should calculate the price of the tube and ADD $X.yy to the Total banner price,
calculator still doing only widht x height like your plug in samples but never the two last options change the price ( Turn around or Printing Speed)

just change anything in the last two dropdown menus it does not do anything,

please help.

PD Product Custom Banner TEST PLUGIN altos web is set as draft instead of published to avoid customers to select that one.

Thank you
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #1710 by Paul
Paul replied the topic: Help with excel calculation
Hello

Well, we checked the calculations and It looks all well. We used your file excel to check the calculations of the plug-in.
Could you give us an example of values in input and the output you expect to see?

The excel is the same you had it. It's possible to download it from the calculator (see the attachment).
Could you check again?

Best Regards
Paul
AT575
Attachments:

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #1708 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
Hello ? Hello ? Hello ? Hello ? Hello ? Hello ? Hello ? replied days ago...

Please Log in or Create an account to join the conversation.

More
1 month 3 weeks ago #1698 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
Sorry you said the calculator is done , but it does not calculate total price in both of the two original problems:

A)
it suppose to add ( $0 , $19, $29, $45 or $89 ) depending in how fast the customer select to have it delivered
B)
and it suppose to add the price of the "rolled tube" option depending if customer select
Folded= $0
or Rolled =$ calculated value

I am not sure if the calculator still use the excell file I made or you modified something as I cant download the excell file

please help me to resolve, it still does not do anything, still doing to the point I've reached by miself.

thank you

Please Log in or Create an account to join the conversation.

More
1 month 4 weeks ago #1669 by Paul
Paul replied the topic: Help with excel calculation
Hello

Your calculator is done here: www.allmybanners.com/product/test-2018-altosweb/
There is only a problem with the date in output. Our output fields work only with numeric type actually.
So you have 2 options for that problem.

1: you decide to not use the date information in output.
2: you can ask a quote to us for develop this function.

Let us know what you prefer.

Best Regards,
Paul
AT575

Please Log in or Create an account to join the conversation.

More
2 months 1 day ago #1658 by david
david replied the topic: Help with excel calculation 575
Hi Ale Cas,
Received your info and we are working on it....
and compliments for your Excel worksheet: very clever design!
David
At575

Please Log in or Create an account to join the conversation.

More
2 months 2 days ago #1656 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
Just send it again to altoswebsolutions.com/contact-us , thank you

Please Log in or Create an account to join the conversation.

More
2 months 3 days ago #1653 by david
david replied the topic: Help with excel calculation
Hello Ale Cas
Sorry for not answering to you but no email - safely connected to you - arrived to our email box altoswebsolutions.com/contact-us .
Maybe was signed by different name/nick name and/or different object.
So please resend again info we asked for and be sure to sign the email with same nick name (ale cas) or - preferably - add our unique ticket reference number AT575.
Thank you
David
at575

Please Log in or Create an account to join the conversation.

More
2 months 3 days ago #1652 by Ale Cas
Ale Cas replied the topic: Help with excel calculation
I sent the file and details last week and still waiting....

Please Log in or Create an account to join the conversation.

More
2 months 1 week ago #1646 by Paul
Paul replied the topic: Help with excel calculation
Hello

Yes, we can do it. You can send your access of your website and excel file to altoswebsolutions.com/contact-us .

Best Regards
Paul
AT575

Please Log in or Create an account to join the conversation.

More
2 months 1 week ago #1645 by Ale Cas
Ale Cas created the topic: Help with excel calculation
I hope youcan help me, I uploaded my excell sheet for some reason some of the calculations are not being made and upgrade to the product are not being added to the price,
can you please take a look to my excel file and website fields please ??

Please Log in or Create an account to join the conversation.

Moderators: david
Time to create page: 0.232 seconds

Cart

Total : 0.00 €