InControl Community

Hi panda_mic2000, There unfortunately is not an option to link Excel directly to the User Events atom. I think it is best to read in the Excel table into ED on reset and store it in a table. These settings can be found on the tab "Tables" of the ExcelActiveX atom. The function "Cell()...

Hi panda_mic2000,

Thanks for the further explanation. I was just commenting on your other post. As also stating there, maybe the "User Events" atom could prove useful. I will be happy to help you further if you run into any problems.

Kind regards,
Gabe-Hein

Hi panda_mic2000, Nice to hear that you are using Enterprise Dynamics for your thesis! A possible solution could be using a "Table" atom in combination with a "User Events" atom. The User Events atom is a bit more advanced. Its main purpose is to repeatedly execute code according...

Hi Marcus, Thank you for providing clarification. To create a model without user-defined functions, I recommend adding six queues: One for products that need to go through servers 1, 2, and 3. One for products that need to go through servers 1 and 2. Etc. I suggest using the Label function to track ...

Hi Marcus,

Welcome to the community!

Before answering your question, first some clarification: Must products in your model go through the servers in a particular order? Or do you want the sequence to depend on the availability of the servers?

Kind regards,
Gabe-Hein

Hi Mads, I think you are already quite close to the correct code. Two remarks: A string should be placed between closed brackets, hence [DueDate] instead of "DueDate". Instead of GetLabel , I would recommend using Label . See the Help for more information. I hope this helps! Kind regards, ...

Hi Max, It is always nice to help, so no worries. :D As mentioned before, "i" cannot be used on the SendTo. Why this is the case has a quite technical answer, but I will try my best to keep it simple. In Enterprise Dynamics everything revolves around events and event handlers. Event handle...

Hi Max, Welcome back to the forum! The problem lies in the consecutive if-functions in your SendTo. The results from the previous if-statements are overwritten later on. From the help: "Syntax: If(e1, e2 {, e3}) Parameter 1 (e1) is the test statement. If this test statement returns 1 (True) par...

Hi Max, I have discovered what causes your error. The problem has occurred before and was subsequently solved in the latest beta. However, as you are not running on that version, you do not have the solution yet. I will send you a pm containing the updated ground storage atom which will solve your p...

Hi Max, Thank you for sharing the model. Whenever I run the model, I do not get any errors. There also is nothing placed on the exittrigger of the ground storage. Are you certain this is the model you are getting errors with? If so, can you send me your Enterprise Dynamics version so I can replicate...