Search the Community
Showing results for tags 'excel'.
To model shelves, I am trying to create a series of custom "Shelf" objects (subclass of servers) located in a grid pattern. I used a spreadsheet to automatically calculate the coordinate locations and generate a name (string) for each object based on its position within the grid. With just the Shelf object types in the spreadsheet, can bind the file to my object reference table no problem, import the data, and populate the facility window with my objects. That part works fine! Next, since I have an aisle running between the rows of objects, I wanted to set it up so that the objects all fa
I'm very new to Simio. I'm trying to figure out the impact on maintenance schedule/work load. I have excel file with 300 pieces of equipment and forecasted operating hours for the next 5 years by month. The operating hours varies from month to month. As the item gains time, there are different maintenance action that takes place, up to 5 different maintenance actions. The next problem is over the 5 years the number of equipment will double. How do I read the excel file? Each row is piece of equipment, the columns are projected hours of operation for that month. How do I
Dear all, I do have a table called machineProperties which describes properties of machines: Machine | ProcessingTime | ... machine1 | 2 |... machine2 | 1.5 | ... In my model I would like to assign the property "Processing time" to machineProperties(DisplayName;"ProcessingTime"). I guess Lookup tables might be working, but unfortunately I do not know how to link them to an Excel file. Does anyone know how to do this? Thank you! Best regards, Stefan