The selected template is automatically generated in Excel and filled in with information from PlanningPME for the chosen month. You can then filter on the department you wish to run the query on before chosing the appropriate template in the drop-down list. In the window that appears, choose the month you wish to extract the information from. In PlanningPME, open the "Tools" menu and choose "Excel planning".
In this first sheet, insert the data of PlanningPME directly into your worksheet by using the following tags: The default installation folder is the Excel subfolder available in the application folder (…\Excel\GB). Once your template has been created, make sure you save it in the same directory as the one that contains the templates included by default in PlanningPME, otherwise it will not appear in the software. The first sheet of your workbook will be the template. To do so, you just have to create a new Excel workbook. PlanningPME offers a number of templates, but you can also create your own models and have them filled in automatically from the data contained in PlanningPME.
#Create a daily schedule in excel how to
How to create your Excel template for PlanningPME?