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 > Flexsim Student Forum
Downloads

Flexsim Student Forum Forum for discussion for Flexsim Students using the Flexsim Textbook.

  #1  
Old 12-12-2011
Jack Lai Jack Lai is offline
Flexsim User
 
Join Date: Nov 2011
Posts: 32
Downloads: 17
Uploads: 0
Thanks: 22
Thanked 0 Times in 0 Posts
Rep Power: 106
Jack Lai is on a distinguished road
Default How to extract data??

I use the discrete model to simulate a barge operation in a container terminal. For each barge, two records will be collected as the time the barge entry and leave the queue. I record these two times in the labels [StartWaitTime] and [EndWaitTime].

After doing simulation, the result I need is the average waiting time at the queue, and I want to extract the [StartWaitTime] and [EndWaitTime] data of each barge record to do some manipulating works. How can I extract these data to a excel file? Thanks for any advice!
Attached Thumbnails
Click image for larger version
Name:	barge.jpg
Views:	228
Size:	43.8 KB
ID:	1595  
Attached Files
File Type: fsm barge.fsm (57.4 KB, 178 views)
  #2  
Old 12-13-2011
Lars-Olof Leven Lars-Olof Leven is offline
Flexsim Distributor
 
Join Date: Aug 2007
Location: Sweden, Borlnge
Posts: 312
Downloads: 278
Uploads: 2
Thanks: 300
Thanked 256 Times in 139 Posts
Rep Power: 330
Lars-Olof Leven is a splendid one to beholdLars-Olof Leven is a splendid one to beholdLars-Olof Leven is a splendid one to beholdLars-Olof Leven is a splendid one to beholdLars-Olof Leven is a splendid one to beholdLars-Olof Leven is a splendid one to beholdLars-Olof Leven is a splendid one to behold
Default

Hi,

I would write [StartWaitTime] and [EndWaitTime] to a global table and then export that table to Excel.

Look at the sink and in OnEntry trigger how to add rows dynamically.
You should look under Add Row and Data to GlobalTable
The Following 2 Users Say Thank You to Lars-Olof Leven For This Useful Post:
Jörg Vogel (12-13-2011)


Thread Thread Starter Forum Replies Last Post
how to set the data of the source west zhang Q&A 4 12-05-2011 01:14 AM
data display Alex Christensen User Development 3 10-06-2011 12:25 AM
Data integration Unregistered Pre-sales Questions 4 07-25-2010 12:14 AM
data from different objects bsantens Q&A 2 05-13-2009 09:31 AM
Input data Regarding shivrash Q&A 4 04-01-2008 07:02 PM


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.