- Posts: 13
- Thank you received: 0
×
WooPrice Calculator PRO
[SOLVED] calculation is way to slow
- DonQuichotte
-
Topic Author
- Offline
Less
More
2 years 6 months ago #1594
by DonQuichotte
DonQuichotte replied the topic: calculation is way to slow
ok, thank you very much, will have a look
best regards
best regards
Please Log in or Create an account to join the conversation.
- david
-
- Offline
Less
More
- Posts: 98
- Thank you received: 1
2 years 6 months 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
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
Please Log in or Create an account to join the conversation.
- david
-
- Offline
Less
More
- Posts: 98
- Thank you received: 1
2 years 6 months 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 altoswebsolutions.com/contact-us , if you like.
David
at462
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 altoswebsolutions.com/contact-us , if you like.
David
at462
Please Log in or Create an account to join the conversation.
- DonQuichotte
-
Topic Author
- Offline
Less
More
- Posts: 13
- Thank you received: 0
2 years 6 months 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
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: david
Time to create page: 0.211 seconds