论文部分内容阅读
地铁运营部乘务室利用Excel表格对列车司机进行排班,为司机制定工作计划,所用表格包含排序表、出勤表等表格。排序表是按照排班规律安排列车司机工作内容的具体表格,包含每名司机每天所要值乘的出乘表表号、日期等要素;出勤表是司机查询一周值乘计划的表格,包含每名列车司机本周内每天所要值乘的出乘表和该出乘表对应的出勤时间、出勤地点等要素。本文通过排班经验的累积和制表技巧运用,同时利用Excel功能运算功能,研究排序表、考勤表的创新制作方法,实现给地铁司机合理、快速排班的目的。
The operation department of the MTRC uses the Excel form to schedule train drivers to work out a work plan for the driver. The form used includes a schedule of forms and attendance forms. Schedule is arranged in accordance with scheduling rules train drivers work specific forms, including each driver’s daily value to be multiplied by the table number, date and other elements; attendance table is the driver to check the weekly value of the schedule by the plan, including each name Train driver the value of the daily multiplied by the table by the week and the corresponding attendance time attendance, attendance and other elements. This article through the accumulation of watchmaking experience and tabulation skills, while using Excel function computing capabilities, research scheduling table, time and attendance table of innovative production methods to achieve the subway driver reasonable, fast scheduling shift purposes.