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

calculation is way to slow

More
1 week 1 day ago #1594 by DonQuichotte
DonQuichotte replied the topic: calculation is way to slow
ok, thank you very much, will have a look

best regards

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

More
1 week 2 days ago #1593 by david
david replied the topic: calculation is way to slow
hi DonQuichotte,
I think in your worksheet there are some mistakes and some optimization to do.
1. Look at the formula in CELL D7 where there is a reference on cell E9 without value.
2. It seems to me that you can use more powerful formulas like INDEX and MATCH instead of Nested IF (slower calculation)
3. Do not use Instructions like =SUM(E2:) if you can use simply =E2 (more fast)
4. Last point: try using a template like mine attached. That can help to design the algorithm logic and make easier the testing and the optimization.Tables could be placed in another worksheet
I hope these suggestions could be useful
David
at462

File Attachment:

File Name: at462-prei...t.b.xlsx
File Size:13 KB
Attachments:

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

More
1 week 6 days ago #1582 by david
david replied the topic: calculation is way to slow
Hi DonQuichotte
Maybe is possible!
But if you send to me your Excel worksheet let me try if I'm able to speed it up.
You can mail it directly to our mailbox hello@altoswebsolutions.com, if you like.
David
at462

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

More
1 week 6 days ago #1581 by DonQuichotte
DonQuichotte created the topic: calculation is way to slow
hello,

my spreadsheet is little bit complex and the calculation is pretty slow in the frontend.. i think customers are going away because of this.. how can i make it faster?

thanks

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

Moderators: davidEnnie
Time to create page: 0.190 seconds

Cart

Total : 0.00 €