[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
  • #5548
    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

    #5551
    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

    #5550
    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]

    #5549
    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.