Time table import from Excel

Question

question

Borja Lorenzo asked Jul 05 2024 at 10:01 AM Borja Lorenzo commented Jul 18 2024 at 4:39 AM

Time table import from Excel

Hello

I would like setting a time table from an excel sheet.

These dates don't have a structure or squence, so to load the openning and closing into a schedule, you select the schedule manaully.

Is there an automatic soluction to upload this types of dates without a patron?

How should schedule dates be prepared (type format dates, mesure time between openning and clossing or openning and clossing time) in Excel?

Thanks a lot in advance for your support.

Software Version:

FlexSim 24.1.0

excel import time table automatically irregular dates upload dates

· 13

Felix Möhlmann commented · Jul 05 2024 at 10:51 AM

Do you have an example of what the imported data looks like. As long as the time format is known, you should be able to generate a DateTime value from just about any date string with the DateTime constructor (see format options in the "toString" method directly above it in the documentation).

If the Excel data is formatted as a date and you import the raw number (number of days since 01. January 1900), you can use the convert() command to transform it into a FlexSim DateTime or Model Time value.

0 ·

Borja Lorenzo Felix Möhlmann commented · Jul 10 2024 at 1:29 PM

Hello @Felix Möhlmann

0 ·

1720618132788.png (83.0 KiB)

Borja Lorenzo commented · Jul 16 2024 at 11:41 AM

Hello Felix

Thanks for your answer.

I'm checking your propouse and I have several doubts.

How can I know the estructure of comand importTimeTable and search this type of funtions?, I can't find them in the manual

I would like adding other doubt about internal estruture of User Command.

What does it mean the param(1) / param (2) / param(3) / param (4) .

I found an entered in this forum but I don't understand it (What means about "param" - FlexSim Community)

0 ·

1721129582599.png (14.4 KiB)

1721129904101.png (10.9 KiB)

Felix Möhlmann Borja Lorenzo commented · Jul 16 2024 at 11:57 AM

It's a user command created by me. The example field just shows a possible input to the command, in this case using names from the example model.

"param(N)" is the Nth parameter that is passed into the command. The "Parameters" field defines which type each parameter needs to have, so FlexSim will show an error if too few, too many or the wrong types of data are entered as parameter when calling the function.

See the documention for user commands.

https://docs.flexsim.com/en/24.1/Reference/Tools/UserCommands/UserCommands.html

1 ·

Borja Lorenzo Felix Möhlmann commented · Jul 17 2024 at 6:25 AM

Hello
I've just tested the user command but i got an error.
Before that I changed the filepath.

The TimeTible was reseted but it shows in the System Console these messages

exception: Error Constructing DateTime: Value not valid date string.

exception: FlexScript exception: MODEL:/Tools/UserCommands/importTimeTable/code at line 39

It pointed to line 39 in the code.

What could it be happenning?

My current version is 24.1.1

Thanks in advance.

0 ·

1721197185599.png (161.6 KiB)

Show more comments

Answer 1 · 2024-07-11T08:27:58Z

Felix Möhlmann answered Jul 11 2024 at 8:27 AM Felix Möhlmann edited Jul 11 2024 at 8:34 AM

I built an example that imports data structured like the marked section from your screenshot into a time table.

The code assumes that the layout follows exactly what is shown in the screenshot (column 2-6 are default values for work days, following columns store values for days that differ from these). The user command in the attached model first parses through the excel file and stores the default schedule from monday to friday and any special schedules stored in further columns.

It then goes day by day, checks if there is a 'special' entry for that day or otherwise uses the default schedule and adds it for that day. The assumptions is that the time table and model start at midnight. The code currently goes up to the next specified stop time or a maximumm of 60 days.

import-schedule-example-fm.fsm

TestSchedule.xlsx

This model is meant as an example to showcase how to read data from excel, convert date strings into a FlexSim datetime and fill out a time table schedule.

Note: If date time conversion in the command uses the windows default weekday and month names. So as long as the naming in your excel file matches this, the code should also work with other languages.

1720686091365.png (156.3 KiB)

import-schedule-example-fm.fsm (107.9 KiB)

testschedule.xlsx (9.5 KiB)

question