案件状态：发包中 　发案人： 萧先生 联络方式1： [email protected] 有效时间： 徵到为止 专案说明： 程式的主要功用分析系统的相关数据并产生报表 - 相关资料已被建立在Excel或Access档案内 - 分析资料库功能，可依据不同需求产生资料的报表 - 以VBA撰写亦可 - 必须到公司来面试一趟 - 英文介面 Purpose The software tool is to help manage the maintenance activities and engineering work. Data input The software should be able to import the daily OCC alarm log into its database for analysis. Function description By priority For the alarm of priority 1 to 4 should be summarized according to date week and month. Additional flag of service impact will be appended to each alarm description to identify the events that affect the service quality. By subsystem The period of data coverage could be specified for analysis for the following functions. For wayside A pivot table of alarm v.s. location with the count of alarm occurrence in the field will be generated. For vehicle Additional information should be generated for analysis. It includes following information, train number, car designation, region/segment, subsystem and equipment. A pivot table of alarm v.s. vehicle with the count of alarm occurrence in the field will be generated. For the individual vehicle alarms there should be a function that can generate the pivot table of location v.s. region/segment with count of occurrence. For station platform door Additional information should be generated for analysis. It includes station berth and door set. A pivot table of alarm v.s. platform location with the count of alarm occurrence in the field will be generated. For PSD Additional information for station should be generated for analysis. A pivot table of equipment/alarm description v.s. location with the count of alarm occurrence in the field will be generated. For norming point reader A table of norming point ID and R/S/O data and count of alarm occurrence will be generated. For train control The alarm for the ATOTrainAlarms2 should be analyzed with R/S/O information and generate pivot table. Each alarm in the field should be able to generate the history trend by showing the occurrence v.s. date, week and month. 　　预算：面议 接案者要求：英文 　　附注： 　　　　(以下内容鼓励结案後填写,可以询问接案人愿不愿意暴光接案身份) 结案意见： 　接案人： 评价(0-10)： 　　说明： --

※ 发信站: 批踢踢实业坊(ptt.cc) ◆ From: 61.228.143.26 ※ 编辑: elvashaw 来自: 59.124.9.220 (11/20 15:53) ※ 编辑: elvashaw 来自: 59.124.9.220 (11/20 15:54) ※ 编辑: elvashaw 来自: 59.124.9.220 (11/20 15:54)