[SOLVED] Help with excel calculation

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED] Help with excel calculation

Viewing 15 posts - 1 through 15 (of 15 total)
  • Author
    Posts
  • #5486
    Ale Cas
    Participant

    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 ??

    #5500
    Paul
    Participant

    Hello

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

    Best Regards
    Paul
    AT575

    #5499
    Ale Cas
    Participant

    I sent the file and details last week and still waiting….

    #5498
    david
    Participant

    Hello Ale Cas
    Sorry for not answering to you but no email – safely connected to you – arrived to our email box https://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

    #5497
    Ale Cas
    Participant

    Just send it again to https://altoswebsolutions.com/contact-us, thank you

    #5496
    david
    Participant

    Hi Ale Cas,
    Received your info and we are working on it….
    and compliments for your Excel worksheet: very clever design!
    David
    At575

    #5495
    Paul
    Participant

    Hello

    Your calculator is done here: https://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

    #5494
    Ale Cas
    Participant

    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

    #5493
    Ale Cas
    Participant

    Hello ? Hello ? Hello ? Hello ? Hello ? Hello ? Hello ? replied days ago…

    #5492
    Paul
    Participant

    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

    #5491
    Ale Cas
    Participant

    [attachment=303]3.JPG[/attachment]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

    #5490
    Ale Cas
    Participant

    [attachment=306]2.JPG[/attachment]

    #5489
    Paul
    Participant

    Hello

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

    Best Regards
    Paul
    AT575

    #5488
    Ale Cas
    Participant

    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!

    #5487
    Paul
    Participant

    Hello

    [ol]
    [li]what we did was:
    [ul]
    [li]Create the the input fields.[/li]
    [li] 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.[/li]
    [li] Remove the IF functions in the subtotals and use more performance functions as MATCH and INDEX.[/li]
    [/ul]
    [/li]
    [li]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:
    [ul]
    [li]Rename label (as example): “numbers of days from today” [/li]
    [li]Set field as output and of type numeric[/li]
    [li]Use excel functions to calculate the numbers of days[/li]
    [li]Map the cell excel with your output field[/li]
    [/ul]
    [/li]
    [/ol]
    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

Viewing 15 posts - 1 through 15 (of 15 total)
  • You must be logged in to reply to this topic.