Differences between Excel Calculation and FlexSim calculation

Question

question

Perrine D asked Mar 21, '19 Perrine D commented Mar 21, '19

Differences between Excel Calculation and FlexSim calculation

Hello,

I need a function for a simulation model that returns some values to me. I was able to determine this function thanks to Excel, as well as these values that I needed. However, I was surprised to notice that in Flexsim, the same function gave me the same results at the beginning, but it gradually diverged from the values calculated by Excel ! Does anyone know how to explain that?

(You can also see a screen in attachment)

Thank you for your answers !

Have a good day.

Software Version:

FlexSim HC 5.3.10

flexsim hc excel calculation function difference

problemefshc1.png (211.9 KiB)

problemefshc2.png (5.4 KiB)

Answer 1 · 2019-03-21T17:02:51Z

Matthew Gillespie answered Mar 21, '19 Perrine D commented Mar 21, '19

You have a typo in the FlexSim version. You wrote 0.0516 instead of 0.0519.

· 1

Perrine D commented · Mar 21, 2019 at 05:15 PM

Oh sorry for inconvenience, and thank you very much !

Have a good day.

0 ·

question