james.waller 0 Posted January 9, 2020 Share Posted January 9, 2020 Is it possible to import / tabulate work schedule patterns into Simio from another application such as Excel? (Example: I would like to take a work schedule in excel, create a binding to the excel work schedule, and finally have it automatically upload to Simio.) I can create a binding from excel for a normal table but not work schedules. Link to post Share on other sites
asneath 3 Posted January 10, 2020 Share Posted January 10, 2020 Yes! You will need to use a "Table Based Work Schedule" instead of a "Pattern Based Work Schedule". You can create a Table Based Work Schedule in the Data tab, Work Schedules view, Schedule ribbon (near the top left). The data table, which may be bound to an outside source like any Simio data table, should have two DateTime columns called something like 'StartTime' and 'EndTime' along with an Integer column called something like 'CapacityValue'. You may read more about the implementation in the Simio Reference Guide (Help via the Support ribbon) "Work Schedules" topic. Happy modeling! 1 Link to post Share on other sites
james.waller 0 Posted January 10, 2020 Author Share Posted January 10, 2020 Wow, that's an incredible help! Thank you so much! Link to post Share on other sites
Recommended Posts