作者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