question

Perrine D avatar image
0 Likes"
Perrine D asked Perrine D commented

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.

FlexSim HC 5.3.10
flexsim hcexcelcalculationfunctiondifference
problemefshc1.png (211.9 KiB)
problemefshc2.png (5.4 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Matthew Gillespie avatar image
2 Likes"
Matthew Gillespie answered Perrine D commented

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

· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Perrine D avatar image Perrine D commented ·

Oh sorry for inconvenience, and thank you very much !

Have a good day.

0 Likes 0 ·