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 > Tips and Tricks
Downloads

Tips and Tricks Share helpful modeling ideas

  #1  
Old 04-04-2011
FlorianK's Avatar
FlorianK FlorianK is offline
Flexsim User
 
Join Date: Jan 2011
Location: Erfurt, Germany
Posts: 27
Downloads: 10
Uploads: 0
Thanks: 16
Thanked 3 Times in 3 Posts
Rep Power: 115
FlorianK is on a distinguished road
Default Number format of the state / summary report

Hello community,

after generating a state report, i have to "clean up" the excel table because of a weired number format (in most cases the real values are multiplied by 1.000.000).

I've heard there is a little trouble with number format between the german und american number formats in excel.

Could this be the reason? Is there a way to set the number format in FelxSim or do I have to work it through in Excel?

Greetings form germany,
FlorianK
  #2  
Old 04-04-2011
RalfGruber's Avatar
RalfGruber RalfGruber is offline
FlexSim Software Products
 
Join Date: Jul 2007
Location: Orem, UT, USA
Posts: 195
Downloads: 37
Uploads: 0
Thanks: 518
Thanked 294 Times in 124 Posts
Rep Power: 345
RalfGruber is a splendid one to beholdRalfGruber is a splendid one to beholdRalfGruber is a splendid one to beholdRalfGruber is a splendid one to beholdRalfGruber is a splendid one to beholdRalfGruber is a splendid one to beholdRalfGruber is a splendid one to behold
Default

Florian,

unfortunately this is a setting you will have to change in Excel.

Depending on what Excel version you are using you will find an "International" tab under "Options" where you can specify both, the decimal seperator and the thousands seperator (Office 2003).

In Office 2007 you have to got to "Excel-Optionen/Erweitert" (assuming you are using a German Excel).
You have to uncheck the box to use operating system settings for these two and have to specify them yourself.

Hope that helps

Good luck

Ralle
aka Ralf
Flexsim
The Following 2 Users Say Thank You to RalfGruber For This Useful Post:
Sebastian Hemmann (04-05-2011)


Thread Thread Starter Forum Replies Last Post
State report based on the operational time Simon Farsah Q&A 8 06-07-2011 01:42 AM
CAD's STEP format Kenny Macleod Q&A 4 03-09-2011 04:23 PM
How to change Table format from int to str Nischith Kashyap Q&A 4 03-03-2011 08:23 AM
how to get number of itemtype Vic Li Q&A 11 08-19-2009 11:20 PM
Object order in the summary report AlanZhang Q&A 4 10-16-2007 05:50 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.