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 CT > Container Terminal (CT) Library
Downloads

  #1  
Old 04-12-2011
zhang xin zhang xin is offline
Flexsim User
 
Join Date: Dec 2008
Location: China
Posts: 136
Downloads: 147
Uploads: 0
Thanks: 81
Thanked 6 Times in 6 Posts
Rep Power: 150
zhang xin is on a distinguished road
Default How to export model data to excel?

In CT, there is an option to import model data from excel.

I wonder is there an option to reverse it, i.e. export model data to excel.

If no, then can we do it by coding?

I know CT can export statistics to excel, but I mean model data.

thanks
  #2  
Old 04-14-2011
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

I think like regular Flexsim model, you can still turn Full History On under the Statistics menu, run the simulation, and then in Reports and Statistics, click Generate Report to export model data into a database and use Flexsim chart to check model data. The database is just a MS Access table. So you can use Excel to open it or you may use Microsoft Access to open and query it as a database.
__________________
Best,
Alan
  #3  
Old 04-15-2011
Anthony Johnson's Avatar
Anthony Johnson Anthony Johnson is offline
Manager of Product Development
 
Join Date: Jul 2007
Posts: 440
Downloads: 86
Uploads: 4
Thanks: 171
Thanked 899 Times in 288 Posts
Rep Power: 735
Anthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond reputeAnthony Johnson has a reputation beyond repute
Default

If you mean exporting model input data to excel so that you can change values and re-import later, no, right now there's no way to export model data into an excel file that's formatted the same as an excel import file.
The Following User Says Thank You to Anthony Johnson For This Useful Post:
zhang xin (04-16-2011)
  #4  
Old 04-16-2011
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

Yeah. I read the post again. This is perhaps what he means.
__________________
Best,
Alan


Thread Thread Starter Forum Replies Last Post
problem with excel export Congshi Wang Q&A 1 12-09-2010 09:24 AM
Excel Data Import Sung Kim Q&A 2 07-16-2010 10:41 AM
statistics cannot export to excel or csv zhang xin Container Terminal (CT) Library 2 03-12-2010 08:01 AM
Speeding up Excel Export Nico Zahn Tips and Tricks 0 01-06-2010 08:50 AM
Export of statistic data from Experimenter Matthias Hofmann Q&A 1 11-04-2008 09:05 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.