Equipment

1
Equipment
BRIEF
Edited by COSCON BPS
2

• Using Excel file submit EQP Event

3
Using Excel file submit EQP Event
Besides using the above functions, user can
download a specially prepared excel file ( with
macro ) to submit EQP event to Sybase. The
download file can be assessed from the IEM main
menu too.
4
Using Excel file submit EQP Event

• User need to have the following minimum
• Hard/Software Requirement
• 1.PC connected to Internet
• 2.Window 95 or above
• 3.Excel 95 or above
• 4.Internet Explore 4.0 or above

5
Introduce Excel Marco File

• This is the excel file layout user will see.
• It is divided into 4 major part
• IEM pull down menu
• User logon details
• Row of input event
• Action buttons

2
4
3
3
6
Introduce IEM Pull Down Menu
7
IEM Event Table
8
Before submission, user need to input facility
code, login ID and password. For internal user,
user need to input his/her email ID. For submit
is by batch format of batch size of 20 event each
time. 2.Submission is done by clicking the
submit button. The status of the submitted
event(s) will change to successful in case of
successful submission. However, if the event fail
for data validation, a error message will be
returned. 3. So, user is advised to use Data
Validation first before Submission.
Using Excel file submit EQP Event ---Submit
event(s) to Sybase
2
1
3
9
4. User should be careful that not to mis-click
the clear button. After a confirmation window for
clear, all selected rows of event will be cleared
without Undo. In this case, user need to re-do
all event(s) again.5. User may also use the
Import File function for huge amount of events.
Details of input field specification please refer
to separate sheet.
Using Excel file submit EQP Event ---Submit
event(s) to Sybase
5
4
10
- END -