Define a specific location in a rack according to the item type

Question

question

benjamin.h asked May 30 2016 at 8:32 AM Brandon Peterson commented Nov 03 2016 at 12:28 PM

Define a specific location in a rack according to the item type

Hi,

I have about 38 references, each having a specific item type. I would like to define the location of the cell (of the rack) for each of my items.

So far I created a global table named 'location" with 3 columns (itemtype, bay, level)

In the rack option, i have put code in :

Place in Bay :

gettablecell("location",getitemtype(item),1)

Place in level :

gettablecell("location",getitemtype(item),2)

Nonetheless, FlexSim tells me that I have an error somewhere with this syntax. However, I don't know another way to do it.

Any help would be welcome :D

Software Version:

FlexSim 16.0.1

global table rack code flowitem

· 1

Answer 1 · 2016-05-30T08:56:54Z

benjamin.h answered May 30 2016 at 8:56 AM Ben Wilson edited May 30 2016 at 1:21 PM

I found a solution

For Place in Bay :

treenode item = param(1);
treenode current = ownerobject(c);
/**By Global Table Lookup*/
/** \nTable: */
string tablename = /**/"Placement"/**/; 
/** \nRow: */
int row = /**/1/**/; 
for(row; row <= gettablerows(tablename); row++) {
	if(gettablenum(tablename,row,1) == getitemtype(item)) {
		break;
	}
}
/** \nColumn: */
int col = /**/2/**/; // column of the Output port from the globaltable
return gettablenum(tablename,row,col);

For Place in level :

treenode item = param(1);
treenode current = ownerobject(c);
double baynumber = param(2);
/**By Global Table Lookup*/
/** \nTable: */
string tablename = /**/"Placement"/**/; 
/** \nRow: */
int row = /**/1/**/; 
for(row; row <= gettablerows(tablename); row++) {
	if(gettablenum(tablename,row,1) == getitemtype(item)) {
		break;
	}
}
/** \nColumn: */
int col = /**/3/**/; // column of the Output port from the globaltable
return gettablenum(tablename,row,col);

The problem was that my itemtypes weren't part of the global table, but of the legend of it.

· 1

Answer 2 · 2016-05-30T08:41:27Z

Marco Baccalaro answered May 30 2016 at 8:41 AM benjamin.h commented May 30 2016 at 8:57 AM

Hello, You have these problems:

you have to use gettablenum instead of gettablecell (otherwise you have a reference to the cell of the table instead of the number contained in it)
you have to search the bay and level in columns 2 and 3
finally you have to use an ordered table into the rows from 1 to n: the itemtype must correspond to the row number (otherwise you have to search the right row using an SQL query)

· 1

question