ExpertFit to create more than 5000 distributions!

Question

question

Omar Aguilera Rico asked May 16, '18 Julio R commented Jul 3, '18

ExpertFit to create more than 5000 distributions!

Hello boys! You can give me some ideas on how I can optimize the use of Experfit to read the data in columns of an Excel file, and the distributions according to the column I write it in a Global Table. Like all this is generated automatically, by means of a code. I have to generate a distribution for each timestamp for more than five thousand activities. If I do this manual, it will take several days to do this, so I ask you if there is any code that can read the Excel information according to each column, and each column would represent an activity, so I would have to write that information in a Global Table or an Excel file.

If you do not understand me, tell me and I try to expand a little more so that it is clear.

Thank you!

Software Version:

FlexSim 18.1.0

expertfit

5 |100000

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

Answer 1 · 2018-05-17T20:04:21Z

Phil BoBo answered May 17, '18 Julio R commented Jul 3, '18

To my knowledge, ExpertFit does not offer any mechanism for automate its inputs beyond what's in its user interface.

However, you can automate Windows UI interactions with programs like AutoIt.

You may be able to automate the steps you are performing manually to automate the input of all this data from Excel to ExpertFit.

· 2

5 |100000

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

Julio R commented · Jul 03, 2018 at 12:34 AM

With the batch mode inside Experfit this can be accomplished, but first you'll have to convert your Excel file into a .dat file so you don't have to register every data set manually.

2 ·

Omar Aguilera Rico commented · May 31, 2018 at 02:55 PM

Test first with the other software to see if I find what I'm looking for, and if not, I'll have to get your idea. Thank you!

0 ·

Answer 2 · 2018-05-17T19:59:07Z

Emily Hardy answered May 17, '18 Omar Aguilera Rico commented May 31, '18

Unfortunately there isn't a way to do this using ExpertFit, but you could try to use another distribution fitting software for this, such as Stat::Fit or the fitdistrplus package for R.

· 1

5 |100000

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

Omar Aguilera Rico commented · May 31, 2018 at 02:54 PM

Very well I will try if any of the other software can perform what I am looking for.

0 ·

question