ATTENTION

This FlexSim Community Forum is read-only. Please post any new questions, ideas, or discussions to our new community (we call it Answers) at https://answers.flexsim.com/. Our new Question & Answer site brings a modern, mobile-friendly interface and more focus on getting answers quickly. There are a few differences between how our new Q&A community works vs. a classic, threaded-conversation-style forum like the one below, so be sure to read our Answers Best Practices.


flexsim.com

Go Back   FlexSim Community Forum > FlexSim Software > Q&A
Downloads

Q&A Using Flexsim and building models

  #1  
Old 03-12-2008
qin tian qin tian is offline
Flexsim User
 
Join Date: Dec 2007
Location: Shanghai, China
Posts: 137
Downloads: 115
Uploads: 0
Thanks: 59
Thanked 3 Times in 3 Posts
Rep Power: 161
qin tian is on a distinguished road
Default how to import excel in source?

I want the arrival schedule of source to use a excel sheet.

how to do it?

thanks.
  #2  
Old 03-13-2008
Regan Blackett Regan Blackett is offline
Flexsim Consultant, Forum Moderator
 
Join Date: Jul 2007
Posts: 14
Downloads: 19
Uploads: 16
Thanks: 0
Thanked 14 Times in 6 Posts
Rep Power: 183
Regan Blackett will become famous soon enoughRegan Blackett will become famous soon enough
Default MTEI method

There's a couple of different ways to do this, either using the Single Table Import or the Multiple Table Excel Import (MTEI). The MTEI method uses fewer steps and is in my opinion more straight forward. Here are the steps I would follow:

1) Go to the parameters page of your source and select schedule from the Inter-Arrival style drop down menu. Push the button labeled "Add Table to MTEI" and then click "OK".

2) Click the Excel menu button to bring up the Excel import interface. Click the "edit" button beside the button "Multiple Table Import". That brings up the Automatic import Interface.

It should have one row and 11 columns. The first column will say "NEW" in it so the import knows to open a file browser for you to select what Excel work book you want to import. In the second column you need to input the name of the sheet your table data resides in. The third and fourth columns are for locating the table in the source, and should be properly formatted from pressing the MTEI button in the first step.

The next two columns, Headers and Data Distinction, are important and warrant some explanation. The Headers column must have a number between 0 and 3; 0 means do not import and header information, 1 means import only row headers, 2 means import only column headers, and 3 means import both row and column headers. Chose the correct number based on how you formatted your table.

The data distinction column refers to how the incoming data is interpreted. A value of 0 means no distinction, all data is assumed numeric. A value of 1 means automatic, data distinction is based on the first character in the cell. A value of 2 denotes Row; data is defined by the row above the first row of data in Excel. A value of 3 denotes Column; data is defined by the column before the first column of data in Excel. Automatic is a pretty safe choice unless you've set up your table in a special way.

Further information about the MTEI interface is available in the Users Manual, found under Help in Flexsim.

3) Once you have the MTEI interface configured, click "OK". Now, back at the Excel interface Window (reached by pushing the excel menu button at the top of Flexsim), Click the button marked Multiple Table Import.

4) Chose your Excel workbook from the file browser, and wait for the progress bars to finish.

You should know be able to see your table in the Source Inter-Arrival schedule!
The Following 4 Users Say Thank You to Regan Blackett For This Useful Post:
Sebastian Hemmann (01-12-2010)
  #3  
Old 03-14-2008
AlanZhang's Avatar
AlanZhang AlanZhang is offline
Flexsim Super Moderator
 
Join Date: Aug 2007
Location: CA
Posts: 289
Downloads: 64
Uploads: 0
Thanks: 88
Thanked 91 Times in 47 Posts
Rep Power: 225
AlanZhang is a jewel in the roughAlanZhang is a jewel in the roughAlanZhang is a jewel in the rough
Default

Thanks for letting us know this MTEI option. Never used before since I am used to write code to do it. But I see its potential. It is a good way to organize your import into an EXCEL spreadsheet and import here. And the 0 value option for Num_Rows and Num_Cols are really helpful.

One thing that I could not find the explanation in the help file is the last column, Main_Percent. What is it?
__________________
Best,
Alan
  #4  
Old 03-14-2008
qin tian qin tian is offline
Flexsim User
 
Join Date: Dec 2007
Location: Shanghai, China
Posts: 137
Downloads: 115
Uploads: 0
Thanks: 59
Thanked 3 Times in 3 Posts
Rep Power: 161
qin tian is on a distinguished road
Default

great,thanks
  #5  
Old 03-15-2008
Cliff King's Avatar
Cliff King Cliff King is offline
Vice President Technical Services
 
Join Date: Jul 2007
Location: Utah
Posts: 272
Downloads: 158
Uploads: 14
Thanks: 102
Thanked 304 Times in 110 Posts
Rep Power: 412
Cliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud ofCliff King has much to be proud of
Default

Alan, the column in the MTEI named Main Percent is related to the visual display of the progress bar that is shown during the import process. So if you had two rows (imports) defined in the MTEI table, and the first row represented 30 percent of the total number of imports for both rows, then you would put 30 in row 1, and 70 in row two. By leaving them 0, the main (total) progress bar would grow from 0 to 100 percent during the row 1 import, and then start over again growing from 0 to 100 percent during the row 2 import process.
  #6  
Old 01-11-2010
Rhonda MacIntyre Rhonda MacIntyre is offline
Flexsim User
 
Join Date: Sep 2008
Posts: 6
Downloads: 3
Uploads: 0
Thanks: 6
Thanked 0 Times in 0 Posts
Rep Power: 0
Rhonda MacIntyre is on a distinguished road
Default reading excel directly into schedule

Hi, I would like to read an excel sheet directly into the schedule of a source, without going through the MTEI or STEI. This is because I have a GUI controlling which input file is selected to be used as the schedule, so I do not know the filename in advance to use in the MTEI or STEI interface.

I seem to be having difficulty figuring out the exact syntax to use for the schedule table when reading the excel information directly into the schedule table. I've tried the following two statements, but it doesn't seem to work (although there are no compiler or run-time errors):

excelimporttable(node("/Source4/variables/schedule",model()),1,1,10,3);
excelimporttable("/Source4/variables/schedule",1,1,10,3);

Can you please tell me what syntax I should be using to indicate the schedule variable as the first argument in the excelimporttable() function?

thanks, Rhonda.
  #7  
Old 01-11-2010
Tom David's Avatar
Tom David Tom David is offline
Flexsim User
 
Join Date: Aug 2007
Location: Schwaebisch Gmuend, Germany
Posts: 430
Downloads: 157
Uploads: 47
Thanks: 486
Thanked 450 Times in 233 Posts
Rep Power: 520
Tom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant futureTom David has a brilliant future
Default

Rhonda,

I guess your problem is that your path in the node command is not correct:
Try to use
node("/Source4>variables/schedule",model())

You should use a “>” sign if you want to dive into the attribute tree of an object.

/ This symbol tells the traversal to go into the current node's sub-tree.
> This symbol tells the traversal to go into a object's attribute tree.

By the way, there is a user concept model which, I think, does what you are looking for:

http://www.flexsim.com/community/for...do=file&id=171
__________________
tom the (A)tom: "We have solved our problems ... now we have to fight the solutions."
The Following 6 Users Say Thank You to Tom David For This Useful Post:
Steven Hamoen (01-12-2010)


Thread Thread Starter Forum Replies Last Post
Excel Data Import Sung Kim Q&A 2 07-16-2010 10:41 AM
Excel Tutorial - Need Input! Brandon Peterson Q&A 4 03-12-2008 10:54 AM
How to prepare an AutoCAD drawing for Flexsim import. Regan Blackett Tips and Tricks 1 11-07-2007 07:08 PM
Excel and global tables Bill Nordgren Q&A 2 10-15-2007 04:36 AM
Display status of import progress tobias.biemueller Q&A 2 10-02-2007 06:27 AM


All times are GMT -6.
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Copyright 1993-2018 FlexSim Software Products, Inc.