[SOLVED] Help with excel calculation
August 7, 2018 at 3:36 am #7306
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 ??August 7, 2018 at 7:26 am #7320
Yes, we can do it. You can send your access of your website and excel file to https://altoswebsolutions.com/contact-us.
AT575August 13, 2018 at 9:53 pm #7319
I sent the file and details last week and still waiting….August 14, 2018 at 4:18 am #7318davidParticipant
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.
at575August 15, 2018 at 9:03 am #7317August 15, 2018 at 3:41 pm #7316davidParticipant
Hi Ale Cas,
Received your info and we are working on it….
and compliments for your Excel worksheet: very clever design!
At575August 17, 2018 at 2:10 pm #7315
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.
AT575August 24, 2018 at 3:46 pm #7314
Sorry you said the calculator is done , but it does not calculate total price in both of the two original problems:
it suppose to add ( $0 , $19, $29, $45 or $89 ) depending in how fast the customer select to have it delivered
and it suppose to add the price of the “rolled tube” option depending if customer select
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 youAugust 28, 2018 at 8:34 pm #7313
Hello ? Hello ? Hello ? Hello ? Hello ? Hello ? Hello ? replied days ago…August 29, 2018 at 7:23 am #7312
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?
AT575August 30, 2018 at 6:44 am #7311
[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,
PD Product Custom Banner TEST PLUGIN altos web is set as draft instead of published to avoid customers to select that one.
Thank youAugust 30, 2018 at 6:45 am #7310
[attachment=306]2.JPG[/attachment]August 30, 2018 at 2:51 pm #7309
Can you check again?
I think it works now (see the attachment).
AT575August 30, 2018 at 6:16 pm #7308
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!August 31, 2018 at 9:10 am #7307
[li]what we did was:
[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]
[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:
[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]
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.
- You must be logged in to reply to this topic.