User Manual
Contents
1. It is also possible to accent all operations belonging to a specific job Therefore please enable the checkbox Highlight Operations at the bottom of the Visualization window If enabled when moving over a specific operation all other operations belonging to the same job are highlighted all other operations are faded In order to get some information about the tightness of schedule which means you restricted operations are according to their preceding and following operations within the job please enable the checkbox Highlight Precedences at the bottom of the Visualization window If enabled when moving over a specific operation the directly preceding and following operation belonging to the same job are highlighted Arelion Production Planner User Manual Seite 16 22 ARELION GMBH In order to get some optimization statistics click on the chart symbol situated at the bottom left of the Visuali zation window a Visualization wx J HA a Hr HEEEEE TEETH EEEHIE TITAN J a ii l 4 6 8 10 12 14 l 13 20 2 24 26 28 30 32 34 36 38 40 42 00 00 January 2014 00 00 January 2014 PREPARA TIONDESK COATINGDESK I COATINGDESK2 c DRYSTORAGEAREA ASSEMBLYLINE m Ado p xor7 Bg XOI9 gg Ao02 fy 1029 pg Ao06 Bg AOI gy POIG m ll Highlight Precedences Bl Highlight Operations e 10 OS Afterwar2. license file e About Button Opens a dialog that shows information about Arelion GmbH and Arelion Production Planner 4 3 Sheets The Arelion Production Planner provides two sheets named Input and Output Please do not change the names of these sheets 4 3 Input Section Reference Time A B C D Input 02 9 a e D ARELION Production Planner 01 01 2014 00 00 00 Resources Operation Machine Machine 2 The reference time is the earliest date for starting an operation in the schedule In the example above it is set to New Year 2014 Section Input A B C D ARELION s Resources Operation Machine Machine 2 The Input section provides the jobs and operations The example above consists of 2 resources and job with two operations If an operation can be produced on a given machine it is expressed by setting a processing time in the corresponding resource column Consequently stepl can be produced on Machine and re quires therefore a processing time of 10 minutes and 54 seconds The size of the input section can be changed by dragging the lower right corner at the small triangle When its size is reduced content outside the Input section is deleted Only data inside the Input section is used for the optimization process The Input sheet does not allow editing outside the Input section Arelion Production Planner User Manual Seite 12 22 ARE
3. table or sheet over the Design tab leads to an inoperable Arelion Pro duction Planner workbook Table Tools Per Arelion Production Planner1 Microsoft Excel File Home Irsert Page Layout Formulas Data Review View Developer Load Test Arelion Team ey Properties Header Row ol First Column ua Open in Browser T Total Row Last Column Table Name 13 Summarize with PivotTable Fe InputTable gs Remove Duplicates Export Refresh T3 Resize Table E Convert to Range T z2 Unlink Banded Rows Banded Columns Properties Tools External Table Data Table Style Options 4 2 Arelion Ribbon elements description The Arelion Production Planner installs an Arelion menu ribbon Pusso At Run Settings Visualize Instructions License About Production Planner Help e Run Button starts the Flexible Job Shop Optimizer as separate process working on the input data as provided in the Input data sheet e Settings Button Opens the settings dialog that allows changing parameters for the optimization run e Visualize Button Opens a gantt chart that visualizes the current output of the visualization e Instructions Button Gives you a short introduction how to work with Arelion Production Planner Arelion Production Planner User Manual Seite II 22 ARELION GMBH e License Button Opens the license dialog that gives you information about your license state or the install a
4. 8 Running multiple instances of the optimizer usesssssessssssesesnsnennnnnnennnnnnennnnnnennnnnnennsnnnennsnnnenssnnnennsnnnennsnnnnnnnen 18 5 9 Sharing the 18 MA ciu m M 19 Arelion Production Planner User Manual Seite 3 22 ARELION GMBH 6 St lle Ae a ea e eee EEE ere ent ee 19 6 2 NV 19 Be MMC H M 2 7 KiC NNE PO Y TR TER 2 7 2 License TOO ee ee ee ee a ee 2 7 3 Licensing procedure after trial csssscssscsscscessscsssssscessosscssssssssssosscessssscessssscessasscessasscessasscessosscessassceseasacereas 21 8 22 ee 22 Arelion Production Planner User Manual Seite 4 22 ARELION GMBH Introduction l WHAT does this tool do The Arelion Production Planner is a novel tool for sequence optimization It combines the power and intelligence of th
5. ARELION PRODUCTION PLANNER USER MANUAL Version 30 4 2015 1 1 e ARELION GMBH Schaerdinger StraBe 4061 Pasching near Linz Austria TEL 43 720 37 05 88 FAX TEL 43 720 37 05 88 99 EMAIL office arelion com WEB www arelion com ARELION GMBH Warranty and End User License Agreement Please note that the software and all documents are subject to Arelion s EULA available for your review at our web site http www arelion com within the product information of Arelion Production Planner Arelion Production Planner User Manual Seite 2 22 ARELION GMBH Table of Contents I INES ON ee ee era 5 WHAT does EuE Kig 5 2 BE VV LOSS IE AS atest 5 1 3 What REQUIREMENTS are necessary to run it eessssessssssesnsenonnnnennnnnnnnnnnnnnnnnnnnennnnnnennnnnsennsnssennsnnsennsnnsennsnnnen 5 2 UNE Flexible JOD Shop Problem t 6 2 1 Flexible Job Shop nesen UH eme poses cop eR Ec DURER ERE 6 3 AIME MEAE MEME 7 3 VV VSS 7 3 2 How to verify the SCCUD EXC een 7 3 3 Installation BrO iS EE ran ener eer E E re weer rr or er ee re 7 A Pugincontent description een oo oo ro EE 7 4 Arelion Product
6. LION GMBH 4 32 Output The Output section shows the result of optimization runs A B C D E F ee ABELION Output Production Planner 1 2 3 Iv Operation Resource MJ Starting Date Duration KJ Completion Date IM 4 A001 stepl Machine 01 01 2014 00 00 00 0 10 54 01 01 2014 00 10 54 5 A001 step2 Machine 2 01 01 2014 00 10 54 20 00 00 01 01 2014 20 10 54 Each line presents the scheduling data of a specific operation e The parent job and operation name e The selected resource e The scheduled starting date e The duration processing time on the scheduled resource e The scheduled completion date All the columns of the Output section can be sorted and or filtered Please mention that the data within the Output section are refreshed after every optimization run 5 How to work with Arelion Production Planner 5 1 Entering Input data The input data have to be stated in the Input section It is possible to resize the Input section in order to add remove jobs operations or resources right bottom end of the section Input Reference Time 01 01 2014 00 00 00 ARELION Production Planner Resources Operation Machine Machine 2 step step2 20 00 EI An empty job column of an operation denotes that it belongs to the last stated job In the example above step2 belongs to A001 Furthermore step must be produced before step2 Consequently if you wan
7. This dialog appears if the first cell within the Input table is blank This dialog appears if job names are not unique within the Input table This dialog appears if any cell is blank in the operation names column within the Input table This dialog appears if all machine time cells are blank This dialog appears if the reference date is missing Seite 20 22 ARELION GMBH 7 Licensing 7 Licensing policy In order to use Arelion Production Planner you have to accept our end user license agreement EULA during the installation process Arelion grants a fully functional demo license for 30 days In order to get a license you have to provide a valid email address The license file is sent directly to the given email address and can be installed using the License Tool 7 2 License Tool The license tool is modeled as a wizard which leads you through the installation process It is directly called after the installation process of our software Also you can open the license tool by clicking onto the License Button within the Arelion Ribbon Arelion License Manager ARELION SMART OPTIMIZATION Production Planner for Microsoft Excel License Information License is valid Expiration date 2014 9 24 Close The image above shows the last step of the license tool wizard which shows you the state your license In the example above the installed license is valid until 2014 09 24 After that
8. Visualization w x l l January 2014 I PREPARATIONDESK RAWCUTTER ES NE FINECUTTER GRINDER COATINGDESK OE I COATINGDESK2 I a DRYSTORAGEAREA ASSEMBLYLINE E NN S Aol F XO Bp XOIS Bg ADOD 29 AOO6 B AOI POIs FM Highlight Precedences Highlight Operations Arelion Production Planner User Manual Seite 15 22 ARELION GMBH The Visualization window presents in the upper part of the window a time bar which allows you to select the current visible time slot The gray bar allows resizing the current visible window and the blue bars can be shifted on the time axis Visualization ww x PREPARA TIONDESK RAWCUTTER FINECUTTER GRINDER COATINGDESKI COATINGDESK DRYSTORAGEAREA ASSEMBLYLINE E 00 Gr Bg xol gg 029 pg A006 Bg AOl2 Jg POl3 Fm Highlight Precedences 88 Highlight Operations Below the time bar a bar for each resource is visualized Each bar contains the scheduled operations When moving with the mouse above an operation a tooltip gives you more information about the operation Opera tions within a job have similar coloring for a better detection of operations belonging to the same job At the bottom of the Visualization window you find colored squares Each square has a label on the right side The labels stand for job names Each square represents a job
9. You can open the Arelion Production Planner template by double clicking the template icon or by selecting the template icon and clicking on the OK button Personal Templates Arelion Production Preview Planner xltx Preview not available 4 1 1 3 Microsoft Excel 2013 Click on the label Personal Search for online templates Dp Excel Suggested searches Business Personal Industry Small Business Calculato Lists FEATURED PERSONAL Recent You haven t opened any workbooks recently To browse for a workbook start by clicking on Open Other Workbooks AC 8 r Open Other Workbooks L Take a tour Ze Welcome to Excel Arelion Production Planner User Manual Seite 10 22 ARELION GMBH e After clicking on the label Personal the Arelion Production Planner template should appear You can open the Arelion Production Planner template by clicking the template icon D X Sign in to get the most out of Office Excel Learn more R Search for online templates 2 Suggested searches Business Personal Industry Small Business Calculator Finance Accounting Lists You haven t opened any workbooks recently To browse for a workbook start by clicking on Open Other Workbooks FEATURED PERSONAL r Open Other Workbooks Arelion Production Planner k Arelion Production x Welcome to Excel L 4 1 2 Change Template design Keep in mind that the modification of any
10. ce of Microsoft Excel and Microsoft Windows Therefore the minimum system requirement is Microsoft Excel 2007 All other software is directly installed by our setup routine The plugin was tested using Microsoft Excel 2007 Microsoft Excel 2010 and Microsoft Excel 2013 Arelion Production Planner User Manual Seite 5 22 ARELION GMBH 2 The Flexible Job Shop Problem The flexible job shop problem is a specialization of the Job Shop problem The job shop problem consists of a set of resources or machines and a set of jobs tasks Each job consists of a list of operations or sub jobs which have to be produced scheduled in sequence This means that the first operation must be finished before the second operation can be started and so on Each operation requires a specific resource with a specific processing time The goal objective is to minimize the overall makespan i e produce the latest job in schedule as fast as possible The flexible job shop problem allows for each operation not just one specific resource but a set of resources with their specific processing times The set of resources given for a specific operation are alternatives from which the optimizer chooses one to reduce the overall makespan 2 1 Flexible Job Shop Example Resources Assume a workshop with 3 machines e Milling Machine e Milling Machine 2 e Drilling Jobs Assume the following Jobs which could be products or parts of a
11. date the license tool will show that the license is no longer valid 7 3 Licensing procedure after trial The optimizer only runs if a valid not expired license is provided If your trial license is out of date the license dialog will Show you more information how to get a new license Arelion Production Planner User Manual Seite 21 22 ARELION GMBH 8 About Arelion Arelion GmbH located in Pasching near Linz Austria develops and sells the Arelion Optimization Core that solves quantitative optimization problems for supply chain management tasks and other areas of industry Our customers benefit from our technology by improved efficiency in production logistics transportation warehousing and duty roster planning At the heart of the technology Arelion Optimization Core short AOC is an evolutionary optimization method that is capable of swiftly solving complex problems to an extremely high standard unlike other established approaches Arelion s software is particularly suited for applications with continously changing boundary conditions typically encountered in dynamic environments Arelion s technology originates from a long term research cooperation between the Johannes Kepler University Linz and Siemens Corporate Technology in Munich The aim of the collaboration is to devel op a new kind of optimization software which eliminates weaknesses of common tools The Arelion Optimiza tion Core can solve complex
12. ds a window appears which shows the date of the optimization the runtime of the optimization the overall makespan the objective value i e the makespan expressed in seconds and the invalidity SCHEDULE STATISTICS Optimization date 29 04 2015 15 30 35 Runtime 00 00 10 Makespan 03 14 54 Objective value 11694 Invalidity 0 Arelion Production Planner User Manual Seite 17 22 ARELION GMBH 5 Optimizer settings To change the optimizer settings please click onto the Settings Button within the Arelion Ribbon After wards the optimizer settings window opens OPTIMIZER SETTINGS Runtime 10 EX Set Default Currently only setting the optimizer runtime is allowed By default the value is set to 10 seconds which means that the optimizer runs for 10 seconds and returns the best result found between this runtime Given more runtime may improve the optimization result The values set in optimizer settings window are saved and re used in following Microsoft 9 Excel sessions 5 8 Running multiple instances of the optimizer You can open and work on different Arelion Production Planner workbooks at the same time You are also able to start and run optimization runs during the same time in different workbooks Nevertheless please keep in mind that optimization requires lots of resources CPU memory of your system Each optimizer currently grabs all available CPU cores for its purposes Therefore we
13. e Arelion Optimization Core Arelion s unique optimization technology with the simplicity of Microsoft Excel This innovative tool enables the user to solve and optimize flexible job shop tasks in a very short amount of time and a superior level of quality 1 2 HOW does it do it Arelion Production Planner installs itself directly into your Microsoft Excel instance So you can solve arbi trary flexible job shop tasks within your familiar environment Our plugin provides an Microsoft Excel template with which you can access its functionality This template is directly installed to your Microsoft Excel template directory So you are able to create multiple Microsoft Excel workbooks based on this template By default the template provides some default data which allows you to directly start with an optimization run The template contains two sheets e Input Here you have to provide all the input data e Output The optimizer fills this sheet after each optimization run Additionally the installation process creates a new menu tab called Arelion within your Microsoft Excel instance which allows you to e Start the optimization e Setup some optimization parameters e Open Close the Gantt visualization of the optimizer output e Show your license state 1 3 What REQUIREMENTS are necessary to run it Arelion Production Planner is a plugin for Microsoft Excel Consequently it requires a working instan
14. emplates My templates Mew from existing Microsoft Office Online Featured Agendas Arelion Production Planner User Manual Seite 8 22 ARELION GMBH e A new window with all available templates appears You can open the Arelion Production Planner template by double clicking the template icon or by selecting the template icon and clicking on the OK button My Templates ED Preview Arelion Production Planner xltx Preview not available 4 1 1 2 Microsoft Excel 2010 e Click on File at the menu bar File Home Insert Page Layout Formulas Data Review View Developer Load Test Arelian Team Cut rs r ci i amp Calibri 1 A a 8 Sr Sy Wrap Text General es Sa Copy A 0 00 C aste LU EET a Ri ow 0 C x3 Format Painter ET 9 c Merge amp Center BIB G0 o Clipboard F Font Ta Alignment Ta Number F e Details of this menu item appear click on New Em Home m Save Save As Open Close Info Recent Print Save amp Send Help i Options Exit Arelion Production Planner User Manual Seite 9 22 ARELION GMBH After clicking on New details of this menu item appear click on My templates Available Templates fal Home Blank Recent Sample New from workbook templates templates existing Office com Templates v A new tab window appears Select the tab labelled Personal Templates
15. found within the Custom section After creating a new Arelion Production Planner workbook it can be saved at an arbitrary place within your file system If you use the Arelion Production Planner on other systems please mention for a fully functional Arelion Production Planner workbook an installation of our software is required The data itself can be used on other computers just like normal excel data Arelion Production Planner User Manual Seite 7 22 ARELION GMBH 4 1 1 Template in different Microsoft Excel Versions This chapter illustrates how to find and open the Arelion Production Planner Template in Microsoft amp Excel 2007 Microsoft Excel 2010 and Microsoft Excel 2013 4 1 1 1 Microsoft Excel 2007 e Click on the Microsoft Office home button at the menu bar Wj u gt Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Arelion Team os Calibri ER i wrap Text General j E A HE EH Paste B I U A E zm E ES Rm 5 Merge amp Center 7 BED oj a 0D Conditional Format Cell a LIES B 28 E Formatting as Table Styles Clipboard Ta Font F Alignment Ta Number Ta Styles 5 Excel Options 2X Exit Excel e After clicking on New details of this menu item appear click on My templates Mew Workbook Installed T
16. he tool The current version of Arelion Production Planner can be downloaded at our website http www arelion com 3 2 How to verify the setup exe The setup exe file is signed with a trusted certificate In order to verify the authenticity of the setup file please check if it is correctly signed and the certificate shows Arelion GmbH as owner 3 3 Installation process Please execute setup exe and follow the instructions of the installation wizard In order to execute the optimi zation of the Arelion Production Planner a license is required Arelion provides a free fully functional 30 day trial license Consequently after installing Arelion Production Planner the license dialog opens which leads you through the process of acquiring your demo license Afterwards please start your Microsoft Excel and finally agree to add the Arelion Production Planner plugin 4 Plugin content description 4 Arelion Production Planner Template Depending on your Microsoft Excel version the Arelion Production Planner template is copied to your default user template folder Consequently it is now globally available in Microsoft Excel The template itself does not contain any code or scripts it just provides the necessary tables for the data You can start a new Arelion Production Planner workbook by selecting File New and selecting Arelion Production Planner within your templates Depending on the Microsoft Excel version it may be
17. ing the Optimizer The optimization starts when clicking on the Run Button in the Arelion tab The optimization runs for the within the Settings Dialog provided runtime default 10 seconds Afterwards the output of the optimization is transferred to the Output section Please note that during the optimization a high amount of CPU is required Consequently depending on your system other applications may work slower during the optimization process Arelion Production Planner User Manual Seite 14 22 5 5 ARELION GMBH Interpretation of output A B C D E F oe ARELION Output Production Planner 2 3 Iv Operation Resource MJ Starting Date Duration Completion Date Machine 01 01 2014 00 00 00 0 10 54 01 01 2014 00 10 54 5 Machine2 01 01 2014 00 10 54 20 00 00 01 01 2014 20 10 54 The example above shows that step of A001 is scheduled on Machine The operation starts at New Year 2014 and runs on Machine for 10 minutes and 54 seconds Consequently the operation is finished 10 minutes and 54 seconds after New Year 2014 5 6 Visualization A graphical representation of the result in form of a Gantt chart opens when clicking on Visualize in the Arelion tab The chart opens in a docked Microsoft Excel window This window can be set to a floated window resized and docked on every position within the possibility of Microsoft Excel
18. ion Re epos aiaiai eiai 7 4 1 1 Template in different Microsoft Excel Versions ssssssssscsssssssesssscsssesscsssssssessssscessasscessesscessnsscerees 8 4 1 1 1 SOU uic a 200 en 8 4 1 1 2 Microsoft Excel 2U 1 m 9 4 1 1 3 FAICFOSON BERGE DUB er ee 0 4 1 2 Change Template design cs a u NE ESEE EEEN SES aN ENEAS SAs 4 2 Arelion Ribbon elements description ou cessssscssssssecessesecessscesescsceccssscesessscesescscessssscesesscesesssceseesaceeeessceeeeeees 4 3 i e Y n 12 Bl A E E S a A EN AON EO AN 2 vu E 3 5 How to work with Arelion Production Planner eee eee esee sees tees te teet teen ete tn enenetntnenon 5 1155 INBUE data Ua nee 5 2 Changing Colunn Dames nenne een LLL 14 5 3 Necessary data consistency of input data eesnenesssnsneseoneneneonenennoneneneonenennonenennnenennsnenenssnenenssnenennsnenenesnenennnn 14 5 4 OBEN ZG End ne ae ee ee 14 5 5 OF 5 5 6 Visualization E ELLE 5 5 7 OBIM S ees o ticurt etie iut ee Eee Sie 18 5
19. larger product that need to be done on these 3 machines e Jl consists of the following sub jobs o JI_OPI requires Drilling for 10 sec o J2_OP2 requires Milling Machine for 20 sec or Milling Machine 2 for 30 sec e J2 consists of the following sub jobs o 12 requires Milling Machine for 35 sec or Milling Machine 2 for 23 sec o J2_OP2 requires Drilling for 20 sec o J2_OP3 requires Milling Machine for 10 sec The example shows two jobs and J2 JI has two operations OPI has to be scheduled produced first and afterwards 2 OP2 requires either Milling Machine or Milling Machine 2 Obviously the best choice for 2 OP2 may be Milling Machine because it requires only 20 seconds for the same operation But when looking on the operations of J2 that may change An optimization of the flexible job shop problem at hand has to consider e The objective minimize the overall makespan e The sequence when start which operation out of all e Select the best matching resource alternative for each operation For this trivial example a solution can even be found by simply inspecting or enumerating the possibilities However the number of such possible assignments grows factorially with the number of jobs and resources rendering a brute force approach useless Arelion Production Planner User Manual Seite 6 22 ARELION GMBH 3 Installation 3 1 Where to get t
20. optimization problems in the shortest possible time Visit our Website http www arelion com or contact our sales team mailto sales arelion com to find out what we can do for you 9 Credits Microsoft Excel and Windows are either registered trademarks or trademarks of Microsoft Corporation in the United States and or other countries Arelion Production Planner User Manual Seite 22 22
21. recommend running one optimization at the same time 5 9 Sharing the spreadsheet You can share Arelion Production Planner workbooks with arbitrary people If other people do not have Arelion Production Planner installed the workbook can only be used as normal Microsoft Excel workbook without the functionality of Arelion Production Planner Please note that Arelion Production Planner checks the consistency of Arelion Production Planner workbook So if you change workbooks content or formatting outside our plugin the workbook possibly won t work correctly Arelion Production Planner User Manual Seite 18 22 ARELION GMBH 6 Validation This section describes various validation checks and related error messages 6 1 Static Validation The static validation is done by Microsoft Excel This action is performed after entering a value in a cell e When the entered resource processing time value within the Input table has a wrong format 6 2 Dynamic Validation The dynamic validation is done by Arelion Production Planner This action is performed before starting the opti mization process This dialog appears if you try to remove any Arelion Production Planner table In this example the user tried to remove the Input table Arelion Production Planner User Manual Seite 19 22 A The first cell in the Job column must be non empty Arelion Production Planner User Manual ARELION GMBH
22. t to start a new job with its operations fill in the job column The names of the jobs operations can be chosen arbitrary but they have to be unique for the job names and for the concatenation of job and operation This means a job A002 can also have an operation stepl but A001 cannot have to stepl operations Arelion Production Planner User Manual Seite 13 22 ARELION GMBH 5 2 Changing column names You are able to change the names of the resources by just clicking in the corresponding cell and typing the new name of the resource Please note that the names of the resources must be unique 5 3 Necessary data consistency of input data Within the resource processing time cells only times are allowed If not empty the cell texts must be stated in the format lt a gt lt b gt lt c gt lt d gt lt a gt denotes the number of days lt b gt the number of hours c the number of minutes and lt d gt the number of seconds Examples for allowed inputs are e 1 00 10 56 I day 10 minutes and 56 seconds e 10 00 IO minutes e 23 00 00 23 hours Before starting an optimization run the following data consistency checks are done e here must be at least one job e Operation names must not be empty e Job names have to be unique e Job name operation name as key must be unique e Resource names must be unique e Operations must require at least one resource e Rows must not be empty 5 4 Runn
Download Pdf Manuals
Related Search