question

Aldo P avatar image
0 Likes"
Aldo P asked Aldo P commented

how can I configure state reports to be readable in excel?

excel interface
· 1
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jeff Nordgren avatar image Jeff Nordgren commented ·
@Aldo P

Are you referring to Dashboard states or something else? Please be a little more specific.

Thanks.

0 Likes 0 ·

1 Answer

Kari Payton avatar image
2 Likes"
Kari Payton answered Aldo P commented
@Aldo P

You can use a dashboard to show the state of a resource.

1. Add new dashboard using the toolbar at the top of the program.

2. In the dashboard library, add a State Pie or State Gantt or State Analysis chart.

3. For each chart, add your resource to it.

4. After the model runs, on the dashboard properties click the save icon. Then you can save each dashboard as a CSV file.

save.png


state.png (32.1 KiB)
chart.png (17.7 KiB)
save.png (15.0 KiB)
· 2
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Aldo P avatar image Aldo P commented ·

When I click Statistics, then Reports and Statistics, then I select a specific attribute, and click "Generate Report", the output is an unreadable excel sheet, as if it were a text copied from Word and pasted in Excel, no Table to read

0 Likes 0 ·
Joerg Vogel avatar image Joerg Vogel Aldo P commented ·

@Aldo P

The file Extension is .csv: comma separated values. This is indeed a text file format, but it contains the text in a table that can excel import by a text filter and bind the content as a excel sheet in the excel file. Because the localization of excel differs in countries, you have to adjust the text import filter manually. You can set in this process which character is responsible for the columns or the decimal point. You can tell which columns you want to see in the excel sheet, too.

But this isn't a feature which Flexsim has to provide. This is common knowledge using excel. You can look for the keywords "importing text to excel as table data". Perhaps you find the procedure to initiate the import filter by using copy and paste.

1 Like 1 ·