Cancel
Showing results for 
Search instead for 
Did you mean: 

Import from Excel to show 3D

Creator
Creator

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

5 REPLIES

Re: Import from Excel to show 3D

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor
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
Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net

Re: Import from Excel to show 3D

Siemens Phenom Siemens Phenom
Siemens Phenom

Here is a small example.

Did you like the answer? Then click the Thumbs Up button.
Did the answer solve your problem? Then accept the answer as solution

Re: Import from Excel to show 3D

Creator
Creator

@Steffen_B

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

Re: Import from Excel to show 3D

Creator
Creator

@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.

Re: Import from Excel to show 3D

Siemens Phenom Siemens Phenom
Siemens Phenom

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.

Did you like the answer? Then click the Thumbs Up button.
Did the answer solve your problem? Then accept the answer as solution