[SOLVED] calculation is way to slow

Home – SaaS Forums Support questions WooPrice Calculator (Pro) [SOLVED] calculation is way to slow

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #7368
    DonQuichotte
    Participant

    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

    #7371
    david
    Participant

    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 https://altoswebsolutions.com/contact-us, if you like.
    David
    at462

    #7370
    david
    Participant

    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 [attachment=261]at462-preise-aktualisiert.b.xlsx[/attachment]

    #7369
    DonQuichotte
    Participant

    ok, thank you very much, will have a look

    best regards

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