Import from Excel to show 3D

[Harleens13]

Hello,

I'm a new user to Plant Simulation and in a dire need to understand whether it will be possible that if I have an excel file which contains lenght,breadth, position and name of the equipments/ machines in warehouse and after I import it in Plant Simulation(PS) and then it(PS) shows the things in 3D format?

Eg - I say I have a Belt conveyor - 2 quantities - 3,4 (length, breadth) 5,2(x,y position) and other with same dimension but at 9,2 (x,y position) and I have an input and output and some machines of different dimensions and position in a table format in Excel. I want that somehow if I import this table in PS, PS should show me this things automatically in a 3D format and then I can change the Simulation parameter later on.

If not, what's the other way around.

Thank you in advance

-Harleens13

[Steffen_B · Accepted solution]

For starting you may have a look in this example:

https://www.bangsow.eu/detail_en.php?id=671

the description you can find in my book on page 73

[PeterKomarek]

Here is a small example.

[Harleens13]

@Steffen_B

Thank you very much. I'll go through it.

[Harleens13]

@PeterKomarek

Thank you very much.

After looking at the table and programming in ' Method' I think I understand you. Thank you very much. But will you please tell me how can I now learn Programming in 'Method' now.
And secondly, to understand correctly what you did - 1. Made an excel table 2. Imported it in Plant Simulations 3. Then defined a method right? what if I want to get single proc and source and drain from the table itself.

[PeterKomarek]

I think, to learn programming in SimTalk, there are some routes you could follow.

First of all, having any sort of programming experience in an imperative programming language (if you have experience in a programming language and you do not know whether it is an imperative one it most probably is) is always helpful. This gives you already some understanding of functions/methods and of some basic control flow structures like loops or conditions.

Then, I think, Mr. Bangsow's book certainly is no bad advice either as it already targets the Plant Simulation user's tasks and explicitly shows how to do things in SimTalk.

Finally, I think, our documentation is also always worth mentioning. So feel free to have a look in there, too.