作者alexsh (alexsh)
看板MRT
标题[转录][发案/询价]系统资料分析程式 - 急件
时间Thu Nov 19 23:56:28 2009
※ [本文转录自 CodeJob 看板]
作者: elvashaw (elva) 看板: CodeJob
标题: [发案/询价]系统资料分析程式 - 急件
时间: Thu Nov 19 20:40:10 2009
案件状态：发包中
发案人： 庞巴迪/萧先生
联络方式1： [email protected]
联络方式2： 02-27982808
有效时间： 徵到为止
专案说明： 程式的主要功用分析捷运系统的相关数据
需有输入/建立资料库功能，跑几项资料的报表
必须到公司来面试一趟
英文介面
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
1F：→ netburst:庞巴迪是不是搞捷运的啊 11/19 21:19
2F：→ dinoism:to:楼上 肯定@@! 11/19 21:24
3F：推 StubbornLin:好酷喔@@ 11/19 21:25
4F：→ StubbornLin:分析内捷出包率吗 XD? 11/19 21:25
5F：→ netburst:纸包不住火了吗? 11/19 21:27
6F：→ doser:靠，真high XD 11/19 23:19
7F：推 ledia:risk management 11/19 23:35
--
学习是一下子，使用是一辈子，不要为了一下子害了一辈子
by 呒虾米输入法发明人 刘重次
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 220.132.138.137
8F：推 ianqoo2000:这是......= =" 11/20 07:37
9F：推 seeback:有八卦板的fu......XD 11/20 09:36
10F：推 fluteofwind:XD 11/20 22:37
11F：→ alexsh:原po还修文删推文咧…还好有备份起来 11/21 02:40
12F：推 asklove:OCC的alarm data为什麽不用资料库要用LOG....奇怪的设计 11/21 09:37
13F：推 asklove:除非原先系统不是庞巴迪包的，不然没理由要从LOG转资料库 11/21 09:42
14F：→ asklove:话说回来 好像没看到说要用什麽程式写? java? 11/21 09:43
15F：推 asklove:喔...去codejob 板看到了，用Excel和VBA 11/21 09:45
16F：→ asklove:这东西我每天在写，可是庞巴迪这麽大没有写程式的工程师吗 11/21 09:46
17F：→ alexsh:要是能用csv或是非VB的话我就会想接，昨天刚结案一个用 11/21 11:14
18F：→ alexsh:Python存文字档抓资料的bot 11/21 11:14
19F：推 asklove:这个case比较麻烦的是图表 抽log资料进资料库倒还好 11/21 11:56