Search the Community
Showing results for tags 'table'.
Found 4 results
Creating Excel Bindings in SIMIO Academic Version
Max E posted a topic in SI General DiscussionsI've been having issues with binding Excel files (XLSX and CSV format) into SIMIO. Every time I try to bind a file with SIMIO I get the same message of "Data has not been imported or is of an unknown age." Even when I create a table in SIMIO, save to CSV, and then try to reimport the exact same table by creating a CSV binding I get the same error. For further context I am using the Academic RPS version of SIMIO. All online tutorials I can find are using older/ different versions of SIMIO that don't have the same options as I do. Does anyone else have experience with this issue or is able to share some advice to help me get pass this error? Thank you
Batch State Operations
jrobinson posted a topic in SI General DiscussionsHi, We have a model where we have multiple entity states. This creates interface challenges in defining and populating these states or changing many of them at a time. My question is, can the UI be bypassed in some way using some kind of batch operations? For example suppose I want to assign 150 entity states using string construction and naming conventions easily set up in a spreadsheet. Is there a way to define all those states and import them from a file rather than hand editing each one in the Definitions UI? Another example is I want to set large numbers of these states at appropriate points in processing. Is there any way to do so by just importing name value pairs from a file rather than hand editing each one and copy pasting from a spreadsheet built up accordingly. Thanks Very Much, Jim
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 face "inwards", ie. the input and output nodes for the objects are facing the aisle. Originally I thought of rotating the Shelf object, but I ran into 2 issues: first, I discovered that I can't set the Shelf yaw orientation from the table, so that's not going to work. Second, I realized that even when I rotate the Shelf in the facility window, the nodes do not rotate with their parent object. I decided I would leave the Shelf in the same orientation as it is placed, but I would just re-locate the input/output nodes to the opposite edge of the Shelf objects on the far side of the aisle. For this I would need to make sure I can set locations for the input/output nodes in the same object reference table. When I added a row to the object reference table from within Simio (prior to binding to a spreadsheet), a drop down appeared, and I could select the input or output nodes for any object that already existed in the table, and then define the node's location in the cartesian coordinate columns. When creating a node this way, the node location is still relative to the object, ie. I can drag the object in the facility window and the node moves relative to the object, which is perfect. This input/output node creation and relative location definition via table is exactly what I am trying to automate, but this is where I started running into problems. In my spreadsheet I used formulas to generate names for the nodes to match the formatting of the input and output nodes in Simio (ex. "Input@..."/"Output@..."). I also added a formula to assign all input node object types to BasicNodes and all output nodes to TransferNodes and calculate the desired location coordinates for the nodes. The spreadsheet I made has the same format as the table in Simio where I tested manually creating and positioning the nodes. The issue is that when I bind the table and import the spreadsheet data to my model, the node names automatically change and are no longer formatted to reference the parent object. Because of this, these name-changed node objects are created in addition to the input and output nodes that are created for each Shelf object. However, if I remove the binding and add a new row, once again I can find the node name in the drop down list and assign the coordinates manually, and the input/output node that references the parent object will move to where I send it. My question is: how can I set the input/output node locations for the objects when creating objects from a table? There are over 500 Shelf objects in the table so I do not want to locate them manually, but the automated method is not working either. The only idea that I have is to make a new object "Shelf2" and define the external view to have the nodes on the opposite side, but that seems like a less-than-idea solution because then I would have 2 custom objects to update and maintain, that are otherwise identical. I am hoping that I don't have to do this hacky solution but I am interested to see if anyone else has dealt with this and has ideas. Thanks!
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