Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
1 of 51
Title
Reporting System Function Design Specification
SEMEN BATU RAJA REPORTING SYSTEM FUNCTION DESIGN SPECIFICATION
Approvals For Use Siemens
Role
M. Ali Jinnah. R Hasan Basri Client Eddy Juarsyah M. Beny
Lead Engineer Project Manager
M. Suherman
Project Manager
Revision History Rev Date
Role Automation System Engineer Production Reporting System Engineer
By
Check
Signature
Date
Signature
26-04-2011 26-04-2011 Date
Approve
Description
P A B
Preliminary For comment For comment
C
For Approval
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project
Upgrading of OS CEMAT V4 To V7 with PCS7 System
IS&ENG Indonesia
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
2 of 51
Title
Reporting System Function Design Specification
Revision Summary Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
P X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X
A
B
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project
Upgrading of OS CEMAT V4 To V7 with PCS7 System
IS&ENG Indonesia
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
3 of 51
Title
Reporting System Function Design Specification
Page 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98
P X X X
A
B
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
4 of 51
Title
Reporting System Function Design Specification
INDEX INDEX........................................................................................................................................................ 4 FIGURES................................................................................................................................................... 6 1
OVERVIEW ........................................................................................................................................ 7 1.1 INTRODUCTION .................................................................................................................................. 7 1.2 SCOPE .......................................................................................................................................... 8 1.3 USER REQUIREMENT SPECIFICATION ............................................................................................. 13
2
SYSTEM SPECIFICATION .............................................................................................................. 14 2.1 REPORTING SYSTEM DIAGRAM ..................................................................................................... 14 2.2 SYSTEM REQUIREMENTS .............................................................................................................. 16 3.3.2 PCS7 OS Servers (WinCC Servers)................................................................................... 16 2.2.2 Ms. Visual Basic 6 Program Applications............................................................................ 16 2.2.3 IIS, ASP.Net ....................................................................................................................... 16 2.2.4 Ms. SQL Server 2005 ......................................................................................................... 16 2.2.5 Ms. Excel 2003 ................................................................................................................... 16 2.2.6 Industrial Ethernet Network for System Bus ....................................................................... 16 2.3 REPORTING SYSTEM METHOD ...................................................................................................... 17
3
SYSTEM FUNCTION........................................................................................................................ 18 3.1 WINCC ....................................................................................................................................... 18 3.3.2 WinCC Recording Data ...................................................................................................... 18 3.1.2. WinCC Viewing Data .......................................................................................................... 19 3.2 VISUAL BASIC (VB) 6 PROGRAM APPLICATION ............................................................................... 20 3.2.1 VB6 MTBF.......................................................................................................................... 20 3.2.1.1
3.2.2 3.2.2.1
Operating Instructions......................................................................................................................... 21
VB6 Excel Exporter ............................................................................................................ 22 VB6 Excel Exporter Login Form ......................................................................................................... 24
3.3 WEB SERVER REPORTING SYSTEM ............................................................................................... 31 3.3.1 Web Server Viewing Data................................................................................................... 31 3.3.2 User Page .......................................................................................................................... 32 3.3.2.1 3.3.2.2 3.3.2.3
Default Login....................................................................................................................................... 32 Home Page ......................................................................................................................................... 33 Production Report ............................................................................................................................... 34
3.3.2.3.1 Cement Mill Hourly Report....................................................................................... 34 3.3.2.3.2 Coal Mill Hourly Report............................................................................................ 34 3.3.2.3.3 Kiln Hourly Report ................................................................................................... 35 3.3.2.3.4 Raw Mill Hourly Report ............................................................................................ 35 3.3.2.3.5 Cement Mill Daily Report ......................................................................................... 36 3.3.2.3.6 KCC (Kiln Coal Clinker) Daily Report....................................................................... 36 3.3.2.3.7 Raw Mill Daily Report .............................................................................................. 37 3.3.2.3.8 Packer Daily Report................................................................................................. 37 3.3.2.3.9 Daily Summary Production Report (“Harian Produksi”)............................................ 38 3.3.2.3.10 OEE Monthly Report.............................................................................................. 38 3.3.2.3.11 OEE Yearly Report ................................................................................................ 39 3.3.2.3.12 MTBF_MTTR Report ............................................................................................. 39 3.3.2.3.13 Energy Meter Report ............................................................................................. 40 3.3.3 Web Report Management................................................................................................... 41 3.3.3.1 3.3.3.2
Delete Report...................................................................................................................................... 41 Create Report ..................................................................................................................................... 42
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
5 of 51
Title
Reporting System Function Design Specification
3.3.3.3 3.3.3.4
Download Report ................................................................................................................................ 43 Search Report..................................................................................................................................... 44
3.3.3.4.1 Search Report By Date............................................................................................ 44 3.3.3.4.2 Search Per Equipment (MTBF_MTTR).................................................................... 45 3.3.3.4.3 Search Per Department (MTBF_MTTR) .................................................................. 45 3.3.4 User Management .............................................................................................................. 46 3.3.4.1 3.3.4.2
3.3.5 3.3.5.1 3.3.5.2
4
Register User (Viewer) ....................................................................................................................... 46 Change Password .............................................................................................................................. 47
Database Diagram.............................................................................................................. 48 Production Report Database Diagram ............................................................................................... 48 Web Report Database Diagram ......................................................................................................... 49
ATTACHMENT................................................................................................................................. 51
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
6 of 51
Title
Reporting System Function Design Specification
FIGURES Figure 1 Figure 2 Figure 3 Figure 4 Figure 5 Figure 6 Figure 7 Figure 8 Figure 9 Figure 10 Figure 11 Figure 12 Figure 13 Figure 14 Figure 15 Figure 16 Figure 17 Figure 18 Figure 19 Figure 20 Figure 21 Figure 22 Figure 23 Figure 24 Figure 25 Figure 26 Figure 27 Figure 28 Figure 29 Figure 30 Figure 31 Figure 32 Figure 33 Figure 34 Figure 35 Figure 36 Figure 37 Figure 38 Figure 39 Figure 40 Figure 41 Figure 42 Figure 43 Figure 44 Figure 45 Figure 46
Automation Architecture ........................................................................................................... 8 Function Block Diagram ......................................................................................................... 14 WinCC Recording Data .......................................................................................................... 18 WinCC Viewing Data.............................................................................................................. 19 VB6 MTBF Block Diagram ..................................................................................................... 20 VB6 MTBF Menu.................................................................................................................... 21 VB6 Excel Exporter Printing Data........................................................................................... 22 VB6 Excel Exporter Configuration file .................................................................................... 23 VB6 Excel Exporter Login Form ............................................................................................. 24 VB6 Excel Exporter Hourly Report Menu............................................................................ 25 VB6 Excel Exporter Daily Report Menu .............................................................................. 26 VB6 Excel Exporter “Rekap Harian Produksi Report” Menu ............................................... 27 VB6 Excel Exporter OEE Report Menu............................................................................... 28 VB6 Excel Exporter MTBF_MTTR Report Menu................................................................. 29 VB6 Excel Exporter Energy Meter Report Menu................................................................. 30 Web Server Viewing Data................................................................................................... 31 Default Login Page ............................................................................................................. 32 Home Page ........................................................................................................................ 33 Cement Mill Hourly Report.................................................................................................. 34 Coal Mill Hourly Report....................................................................................................... 34 Kiln Hourly Report .............................................................................................................. 35 Raw Mill Hourly Report ....................................................................................................... 35 Cement Mill Daily Report .................................................................................................... 36 KCC Daily Report ............................................................................................................... 36 Raw Mill Daily Report ......................................................................................................... 37 Packer Daily Report............................................................................................................ 37 “Harian Produksi” Report .................................................................................................... 38 OEE Monthly Report........................................................................................................... 38 OEE Yearly Report ............................................................................................................. 39 MTBF_MTTR Report .......................................................................................................... 39 Energy Meter Report .......................................................................................................... 40 Delete Report ..................................................................................................................... 41 Delete Report ..................................................................................................................... 41 Create Report ..................................................................................................................... 42 Report Created ................................................................................................................... 42 Download Report 1............................................................................................................. 43 Download Report 2............................................................................................................. 43 Search Report By Date 1.................................................................................................... 44 Search Report By Date 2.................................................................................................... 44 Search Report Per Equipment (MTBF_MTTR) ................................................................... 45 Search Report Per Department (MTBF_MTTR).................................................................. 45 Register User...................................................................................................................... 46 Change Password .............................................................................................................. 47 Production Report Database Diagram ................................................................................ 48 Web User Database Diagram ............................................................................................. 49 Report Database Diagram .................................................................................................. 50
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
7 of 51
Title
Reporting System Function Design Specification
1
OVERVIEW
1.1 Introduction This document defines how PT. Siemens Indonesia will meet all the elements of the User Requirements of the Reporting System described in the following documents: Document No.
CLIENT ENGINEERING DOCUMENTS Document of Reporting System Backup program of PCS7
Document No.
CLIENT ENGINEERING DRAWING
The Functional Design Specification together with the documents supplied by the customer, when agreed by Semen Baturaja and Siemens Indonesia, will become the main contractual document defining how Siemens intend to implement the project. It defines how the task will be carried out, the system and services to be supplied and the facilities to be made available.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
8 of 51
Title
Reporting System Function Design Specification
1.2
Scope
Figure 1
Automation Architecture
The Reporting System Area: a. b. c. d. e.
Raw Mill (R1R01) Coal Mill (K1R01) Kiln & Cooler (W1R01 & U1R01) Cement Mill (Z1R01) Packer (X1R01)
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
9 of 51
Title
Reporting System Function Design Specification
This document covers the design and construction of the Production Reporting System for PT. Semen Baturaja that consists of: A. Hourly Report A.1 A.2 A.3 A.4
Raw Mill Coal Mill Kiln Cement Mill
B. Daily Report Per Area (Dept) B.1 B.2 B.3 B.4
Raw Mill Kiln, Coal, & Cooler Mill Cement Mill Packer
C. Daily Summary Production Report (RHP) D. Effectiveness Production Report D.1. Overall Effectiveness Equipment (OEE) Per Area (Dept) D.1.1 OEE Kiln D.1.2 OEE Vertical Mill D.1.3 OEE Finish Mill PBR D.1.4 OEE Crusher Batu Kapur D.1.5 OEE Coal Mill D.1.6 OEE Crusher Tanah Liat D.1.7 OEE Finish Mill PPG D.1.8 OEE Finish Mill PPJ D.2. Daily Energy Meter D.3. Mean Time Base Failure, Mean Time To Repair (MTBF_MTTR) Raw Mill Department D.3.1 A1J13M1 Belt Conveyor Motor D.3.2 A1L11A1 Reclaimer Limestone D.3.3 C1J32M1 Belt Conveyor Motor D.3.4 C1L03A1 Reclaimer Clay D.3.5 E1A01A1 Dosimat Silica D.3.6 E1B01A1 Dosimat Iron Sand D.3.7 N1P10A1 Compressor Motor D.3.8 N1P20A1 Compressor Motor D.3.9 N1P30A1 Compressor Motor D.3.10 N1P40A1 Compressor Motor D.3.11 R1A01A1 Dosimat Limestone D.3.12 R1J01M1 Belt Conveyor Motor D.3.13 R1M03M1 Vertical Mill Motor D.3.14 R1S01M1 Classifier Motor Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
10 of 51
Title
Reporting System Function Design Specification
D.3.15 D.3.16 D.3.17
R1S05M1 R1U20M1 R1U21M1
Mill Fan Motor Belt Bucket Elevator Motor Air Sluice Motor
D.3.18 D.3.19 D.3.20 D.3.21 D.3.22 D.3.23 D.3.24 D.3.25 D.3.26 D.3.27 D.3.28 D.3.29 D.3.30 D.3.31 D.3.32 D.3.33 D.3.34 D.3.35 D.3.36 D.3.37 D.3.38 D.3.39 D.3.40 D.3.41 D.3.42 D.3.43 D.3.44 D.3.45 D.3.46 D.3.47 D.3.48
Kiln Feed Department H1H01A1 J1J01M1 J1J03M1 J1P11E1 J1P11E2 J1P11E3 J1P11E4 J1P11E5 J1P11E6 J1P11M1 J1P11M2 J1P11M3 J1P11M4 J1P11M5 J1P11M6 J1P12M1 J1U24M1 J1U26M1 W1A01A1 W1A05M1 W1A10M1 W1A15M1 W1A20M1 W1A23M1 W1V72A1 W1V73M1 W1V74M1 W1V82A1 W1V83M1 W1V84M1 W1W03M1
Cf Extraction ID Fan Motor ID Fan Motor Ep-Retifier 1 Ep-Retifier 2 Ep-Retifier 3 Ep-Retifier 4 Ep-Retifier 5 Ep-Retifier 6 Ep-Rapping Gear 1 Ep-Rapping Gear 2 Ep-Rapping Gear 3 Ep-Rapping Gear 4 Ep-Rapping Gear 5 Ep-Rapping Gear 6 Filter Fan Screw Conveyor Motor Screw Conveyor Motor Dld Feeder Rotary Blower Motor Belt Bucket Elevator Motor Belt Bucket Elevator Motor Fluxoslide Fan Fluxoslide Fan Pfister Feeder Rotary Blower Motor Rotary Blower Motor Pfister Feeder Rotary Blower Motor Rotary Blower Motor Kiln Drive Motor
D.3.49 D.3.50 D.3.51 D.3.52 D.3.53 D.3.54 D.3.55 D.3.56 D.3.57 D.3.58
Cooler Department U1J11M1 U1J12M1 W1K01A1-3 W1K01A1-4 W1K01A1-5 W1K08M1 W1K10M1 W1K11M1 W1K12M1 W1K13M1
Pan Conveyor Motor Pan Conveyor Motor Grate Drive No. 3 Grate Drive No. 2 Grate Drive No. 1 Drag Chain Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
11 of 51
Title
Reporting System Function Design Specification
D.3.59 D.3.60 D.3.61 D.3.62 D.3.63 D.3.64 D.3.65 D.3.66 D.3.67 D.3.68 D.3.69 D.3.70 D.3.71 D.3.72 D.3.73 D.3.74 D.3.75 D.3.76 D.3.77
D.3.78 D.3.79 D.3.80 D.3.81 D.3.82 D.3.83 D.3.84 D.3.85 D.3.86 D.3.87 D.3.88 D.3.89 D.3.90 D.3.91 D.3.92 D.3.93 D.3.94 D.3.95 D.3.96 D.3.97 D.3.98 D.3.99 D.3.100 D.3.101 Â
W1K14M1 W1K15M1 W1K16M1 W1K17M1 W1K18M1 W1K20M1 W1K21M1 W1K22M1 W1K26M1 W1K27M1 W1K50M1 W1M01M1 W1P11E1 W1P11E2 W1P11M1 W1P11M2 W1P15M1 W1P36M1 W1V91M1
Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Cooling Air Fan Motor Sealing Air Fan Motor Sealing Air Fan Motor Nose Ring Fan Motor Hammer Breaker Motor Esp-Retifier 1 Esp-Retifier 2 Esp-Rapping Gear 1 Esp-Rapping Gear 2 Esp Fan Motor Booster Fan Motor Primary Air Fan Motor
Cement Mill Department U1J43M1 Steel Plate Conveyor Motor U1J81M1 Bucket Elevator Motor Z1A01A1 Gypsum Feeder Z1A06M1 Belt Conveyor Motor Z1B01A1 Clinker Feeder Z1D01A1 Limestone Feeder Z1J02M1 Bucket Elevator Motor Z1J03M1 Belt Conveyor Motor Z1J10M1 Bucket Elevator Motor Z1J19M1 Bucket Elevator Motor Z1J19M2 Feed Screw Conveyor Motor Z1J28M1 Bucket Elevator Motor Z1M03M1 Finish Mill Motor Z1M23U1 Roller Press Motor Z1M27A1 Hydraulic Unit (Local Control Panel) Z1M29A1 Lubrication Unit (Local Control Panel) Z1P12M1 Screw Conveyor Motor Z1P13M1 Screw Conveyor Motor Z1P17M1 Sepax Fan Motor Z1P55M1 Filter Fan Motor Z1P57M1 Jet Pulse Fan Motor Z1S01M1 Sepax Separator Motor Z1S10M1 Grit Separator Motor Z1S14M1 Grit Separator Fan Motor
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
26/04/11
12 of 51
Title
Reporting System Function Design Specification
Coal Mill Department D.3.102 F1J41M1 D.3.103 F1L11A1 D.3.104 F1L21A1 D.3.105 K1A01M1 D.3.106 K1A02M1_1 D.3.107 K1J03M1_1 D.3.108 K1J03M1_2 D.3.109 K1M03M1 D.3.110 K1M05A1 D.3.111 K1M06M1 D.3.112 K1M07A1 D.3.113 K1M11A1 D.3.114 K1P12M1 D.3.115 K1P16M1 D.3.116 K1S01M1 D.3.117 K1T36M1
Bucket Elevator Motor Stacker Coal Reclaimer Coal Drag Chain Feeder Twin Paddle Forward Screw Conveyor Motor Screw Conveyor Motor Atox Mill Motor Gear Lubrication Unit (Local Control Panel) Sealing Air Fan Motor Hydraulic Unit (Local Control Panel) Roller Lubrication Unit (Local Control Panel) Screw Conveyor Motor Mill Fan Motor Separator Motor Booster Fan Motor
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
13 of 51
Title
Reporting System Function Design Specification
1.3
User Requirement Specification The User Requirement Specification (URS) for production reporting system: a. All the report must be in excel form for further processing. b. All the report can be seen either from CCR (Central Control Room) or intranet PT. Semen Baturaja. c. All the master report in excel files and e-mail correspondent that already received from PT. Semen Baturaja as the basis to develop the production reporting system. d. The Production Reporting System Data is taken from the controllers and manual entry form which is already specified from PT. Semen Baturaja. e. All the reporting system data will be kept until one year. f. The Production Reporting System Performance must not interrupt production operation activity.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
14 of 51
Title
Reporting System Function Design Specification
2
SYSTEM SPECIFICATION
2.1 Reporting System Diagram Figure 2 shows the boundary of the reporting system. It shows the data flows diagram.
Web Reporting System ASP.NET, IIS, VB6 (Excel Exporter), SQL Server 2005 C_DB_1294
Ind. Ethernet
HMI WinCC Server Redundancy, VB6 (MTBF), SQL Server 2005 C DB 1291, C DB 1292 Ind. Ethernet
AS (Controllers) S5 PLC S7 PLC
Profibus DP
I/O’s Figure 2
Function Block Diagram
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
15 of 51
Title
Reporting System Function Design Specification
Description: Automatic Data from Automation System (PLC and I/O’s) and Manual Data (Production data, MTTR data, etc) are recording continously using WinCC (Windows Control Centre) Redundancy Server as HMI (Human Machine Interface) and place the necessary data for reporting system into SQL Server 2005 database at C_DB_1294 computer. Visual Basic 6 Program Application is purposed for MTBF (Mean Time Base Failure) record which is takes the data from WinCC SQL Server 2005 database at C_DB_1291 or C_DB_1292 computer and processing this data, such as calculate failure duration time of equipment, before finally put the MTBF data into SQL Server 2005 database at C_DB_1294 computer. At C_DB_1294 computer, there has two program application: Visual Basic 6 Program Application Excel Exporter, Web Server using Dot Net Framework (IIS, ASP.Net, ADO.Net). Visual Basic 6 Program Application is purposed for creating report from SQL Server 2005 Database to excel files and HTML files both automatic and manual. Web Server is used for publish all HTML files into internet explorer. Here, all the Web Client can be seen production report, download production report file (excel file), and delete report file (only for specific user). The communication between computers are using ethernet communication to exchange the data.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
16 of 51
Title
Reporting System Function Design Specification
2.2 System Requirements 3.3.2 PCS7 OS Servers (WinCC Servers) The two physical PCS 7 OS Servers are configured as a redundant pair with a redundant synchronisation connection between them. Hadware and software requirements refer to PCS7 manual.
2.2.2 Ms. Visual Basic 6 Program Applications Ms. Visual Basic 6 Program Applications are configured as additional program in order to meet load sharing and performance of WinCC Servers.
2.2.3 IIS, ASP.Net IIS (Internet Information Service) V5 is configured as Web Server while ASP.Net is configured as Web Dynamization which is working at server side. The IIS and ASP.Net Platform based on Microsoft Net Framework V4. Internet Explorer (IE) V6 or higher is configured as default Web Browser.
2.2.4 Ms. SQL Server 2005 Ms. SQL Server 2005 is configured as database to store and view data using structure query languange. 2.2.5 Ms. Excel 2003 Ms. Excel 2003 is configured as default reporting form.
2.2.6 Industrial Ethernet Network for System Bus Siemens Scalance X205 and X005 industrial switches are connected via their ports to form a 100MB signal for AS to OS communications for process data.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
17 of 51
Title
Reporting System Function Design Specification
2.3 Reporting System Method The Reporting System is divided into 3 parts: a. Record Data b. View Data c. Print Data a. Record Data Recording Data of production report uses SQL Server 2005 as RDBMS Database which is integrate in WinCC Installation with instancing name “\WinCC” and also use WinCC features such as Global Script and Visual Basic 6 Program Application. The Basis Design is based on reporting format in excel file which is supplied from PT. Semen Baturaja. (Please see at attachment of The Master Report Form) Table Structure in Database is divided into 3 part: 1. Hourly Production Report Æ Area Department 2. Daily Production Report Æ Area Department, Summary Daily Report 3. Effectiveness Production Report Æ OEE, MTBF_MTTR, Energy Meter b. View Data Viewing Data of production report can be seen in WinCC Runtime using WinCC Object Web Browser Technology. c. Print Data Printing Data of production report uses excel and HTML. These features can be seen in Web Reporting System.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
18 of 51
Title
Reporting System Function Design Specification
3
SYSTEM FUNCTION
3.1 WinCC 3.3.2 WinCC Recording Data The WinCC Recording Data is based on Global Script with VBScript. Global Script has 3 tabs: Project Module, Standard Module, Action Script. The Correlation like this below:
Action Script (Trigger)
WinCC
Triggered By: Tag, Time
Project Module Function, Sub Procedure Error Script Logg in txt file
Use ADO (AxtiveX Data Object) (Object Connection and Object Recordset)
Database SQL Server
Figure 3
WinCC Recording Data
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
19 of 51
Title
Reporting System Function Design Specification
3.1.2. WinCC Viewing Data
Figure 4
WinCC Viewing Data
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
20 of 51
Title
Reporting System Function Design Specification
3.2
Visual Basic (VB) 6 Program Application
3.2.1 VB6 MTBF MTBF Generator is a VB-based application which is intended to provide information MTBF (Mean Time Between Failures), running hours and normal-stop hours. Those information are taken by performing alarm analysis of the events (equipment start events, equipment stop events and equipment failure events). The system block diagram is described by Figure 5
WinCC Runtime
WinCC OLEDB
VB 6.0 MTBF Generator
SQL Server 2005
Figure 5 •
VB6 MTBF Block Diagram
Running hours is measured by extracting the time difference between the equipment start time and equipment stop time. The stop events used for running hours measurement are all stop events (normal stop and fault stop).
•
Normal stop hours is measured by subtracting total stop hours and fault hours. Total stop hours is defined as total duration of all stop events (measured from equipment stop event including stop caused by failure to equipment start running event).
•
Fault hours is defined as the duration between equipment stop event time (caused by failure) and equipment start event time.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
21 of 51
Title
Reporting System Function Design Specification
3.2.1.1
Operating Instructions
The application will only be active when it detects the WinCC runtime on the local PC acts as a master, otherwise it will remain standby or inactive. For the operation modes, there are two modes which are: •
Automatic In automatic mode, the application will perform alarm logging analysis of WinCC runtime using WinCC OLEDB as its interface at 07:00. the time range of the alarm logging analysis is from 07:00 on the previous date up to 07:00 on the current date. After all information from the alarm logging are processed, the result will be stored to SQL Server 2005.
•
Manual In manual mode, operator must select the equipment first. After selecting the equipment operator is allowed to view the running hours, normal stop hours, failure hours and failure frequencies from 07:00 up to current time. The principle is the same as in automatic mode; the only difference is the time range of the alarm logging analysis.
MTBF Generator has no exit button command because it’s not intended to be closed to avoid the MTBF data not sent to SQL Server 2005 at 07:00. The main screen is shown in Figure 6.
Manual Viewer Button in Hour
Source
Events
Time of Event Appearance Equipment Box Selection
Figure 6
VB6 MTBF Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
in Hour
in Hour
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
22 of 51
Title
Reporting System Function Design Specification
3.2.2 VB6 Excel Exporter The VB6 Excel Exporter provides automatic (hourly and daily at 7.30 a.m.) and manual creation of the production report both in Excel file and HTML file also provides auto management data for reporting system, such as delete Excel, HTML files, database SQL Server 2005 older than one year at 7 a.m. Figure 5 illustrates the process of generating excel reports from SQL Server Database.
*.xls Template
File System Object
VB 6 Excel Exporter
Final *.xls Report
SQL Server Database ADODB
Figure 7
VB6 Excel Exporter Printing Data
1. The application makes a copy of excel report template using FSO object, and stores it as an excel file (*.xls) in the report destination folder. In the case where copying process does not succeed, the application logs error message in a txt file located in the application directory. 2. The application creates a new instance of Excel Application object, and then instructs it to open the copied excel file located in the destination folder. 3. The application creates a new instance of ADODB Connection object, and opens the connection with connection string. 4. The application uses SQL syntaxes to query all the necessary record from database into ADODB record set objects, and then writes the queried data into corresponding excel worksheets and cells. 5. Several data that are generated using Excel’s formula need to be stored back into SQL Server (e.g., from calculated daily data to monthly and yearly overview). In such cases, the application retrieves the data from Excel cells, and then uses INSERT or UPDATES SQL syntax to store the data back into corresponding table in SQL Server. 6. The reports are then being saved as both *.xls file and *.html file, and the application updates the report database in the SQL server.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
23 of 51
Title
Reporting System Function Design Specification
The VB6 Excel Exporter application comes with a configuration file (ExportConfig.ini) that must be placed in the same folder as the application. The file is used to set up all necessary settings to run the application. Figure 6 shows some example of configuration file contents.
Figure 8
VB6 Excel Exporter Configuration file
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
24 of 51
Title
Reporting System Function Design Specification
3.2.2.1
VB6 Excel Exporter Login Form
When the application starts, a login form shows up and prompts user to input password. This login is used to grant access to create manual reports. The login form is shown in Figure 7.
Figure 9
VB6 Excel Exporter Login Form
If the login succeeds, the main form shows up. The main form has four Tabs, each containing user interface menu for creating different reports. The menus are: 1. Hourly Report (Figure 8) 2. Daily Report (Figure 9) 3. “Rekap Harian Produksi” (Figure 10) 4. “Rekap Efektifitas Produksi”, which contains 3 sub menus as follows: a. OEE Report (Figure 11) b. MTBF_MTTR Report (Figure 12) c. Energy Meter Report (Figure 13)
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
25 of 51
Title
Reporting System Function Design Specification
Figure 10 VB6 Excel Exporter Hourly Report Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
26 of 51
Title
Reporting System Function Design Specification
Figure 11 VB6 Excel Exporter Daily Report Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
27 of 51
Title
Reporting System Function Design Specification
Figure 12 VB6 Excel Exporter “Rekap Harian Produksi Report� Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
28 of 51
Title
Reporting System Function Design Specification
Figure 13 VB6 Excel Exporter OEE Report Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
29 of 51
Title
Reporting System Function Design Specification
Figure 14 VB6 Excel Exporter MTBF_MTTR Report Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
30 of 51
Title
Reporting System Function Design Specification
Figure 15 VB6 Excel Exporter Energy Meter Report Menu
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
31 of 51
Title
Reporting System Function Design Specification
3.3 Web Server Reporting System 3.3.1 Web Server Viewing Data Web Server (C_DB_1294)
SQL Server 2005 Database
IIS
ASP.NET
Web Client (Internet Explorer)
Figure 16 Web Server Viewing Data
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
32 of 51
Title
Reporting System Function Design Specification
3.3.2 User Page 3.3.2.1
Default Login
Figure 17 Default Login Page On this login page, user should enter username and password that already registered and will be redirect into the main page. Only user known as an “Operator“ who will be redirect into an administrator page and have an authority to delete or create report files.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
33 of 51
Title
Reporting System Function Design Specification
3.3.2.2
Home Page
Figure 18 Home Page On this homepage, users can access any reports through the menu at the upper page and on every page. At the right corner page, users can click the “LogOut“ button to exit this page and refuse their session. And at the bottom, users can get a contact information of IS & ENG PT. Siemens Indonesia.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
34 of 51
Title
Reporting System Function Design Specification
3.3.2.3
Production Report
Users can view and download Cement Mill Hourly Report that already generated through this page. If they choose to view the report, it will be shown automatically in a new browser window. If they choose to download the files, they can save it in an excel file. They can search a specific report based on its date.
3.3.2.3.1
Cement Mill Hourly Report
Figure 19 Cement Mill Hourly Report
3.3.2.3.2
Coal Mill Hourly Report
Figure 20 Coal Mill Hourly Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
35 of 51
Title
Reporting System Function Design Specification
3.3.2.3.3
Kiln Hourly Report
Figure 21 Kiln Hourly Report
3.3.2.3.4
Raw Mill Hourly Report
Figure 22 Raw Mill Hourly Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
36 of 51
Title
Reporting System Function Design Specification
3.3.2.3.5
Cement Mill Daily Report
Figure 23 Cement Mill Daily Report
3.3.2.3.6
KCC (Kiln Coal Clinker) Daily Report
Figure 24 KCC Daily Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
37 of 51
Title
Reporting System Function Design Specification
3.3.2.3.7
Raw Mill Daily Report
Figure 25 Raw Mill Daily Report
3.3.2.3.8
Packer Daily Report
Figure 26 Packer Daily Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
38 of 51
Title
Reporting System Function Design Specification
3.3.2.3.9
Daily Summary Production Report (“Harian Produksi”)
Figure 27 “Harian Produksi” Report
3.3.2.3.10
OEE Monthly Report
Figure 28 OEE Monthly Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
39 of 51
Title
Reporting System Function Design Specification
3.3.2.3.11
OEE Yearly Report
Figure 29 OEE Yearly Report
3.3.2.3.12
MTBF_MTTR Report
Figure 30 MTBF_MTTR Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
40 of 51
Title
Reporting System Function Design Specification
3.3.2.3.13
Energy Meter Report
Figure 31 Energy Meter Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
41 of 51
Title
Reporting System Function Design Specification
3.3.3 Web Report Management 3.3.3.1
Delete Report
Figure 32 Delete Report User that has an authority to delete a specific list file in database SQL Server 2005 by clicking the delete button at selected report’s row.
Figure 33 Delete Report
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
42 of 51
Title
Reporting System Function Design Specification
3.3.3.2
Create Report
Figure 34 Create Report User that has an authority to generate back the list files into database SQL Server 2005 that already deleted by searching the file first using search engine and select the date report, then click the Create Report button.
Figure 35 Report Created
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
43 of 51
Title
Reporting System Function Design Specification
3.3.3.3
Download Report
Figure 36 Download Report 1 User can download any report by clicking the download button
Figure 37 Download Report 2
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
44 of 51
Title
Reporting System Function Design Specification
3.3.3.4
Search Report
3.3.3.4.1
Search Report By Date
Figure 38 Search Report By Date 1 User can search a specific file based on date report using search engine in every pages. This help user to find the report they want to see.
Figure 39 Search Report By Date 2 Selected report will show at the bottom of search engine.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
45 of 51
Title
Reporting System Function Design Specification
3.3.3.4.2
Search Per Equipment (MTBF_MTTR)
Figure 40 Search Report Per Equipment (MTBF_MTTR) User can sort the report by choosing the equipment then it will show the result automatically after they click the name.
3.3.3.4.3
Search Per Department (MTBF_MTTR)
Figure 41 Search Report Per Department (MTBF_MTTR) User can sort the report by choosing the department then it will show the result automatically after they click the name.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
46 of 51
Title
Reporting System Function Design Specification
3.3.4 User Management 3.3.4.1
Register User (Viewer)
Figure 42 Register User User should have a username and password first before accessing The Semen Baturaja Production Report system. They should use this page to register their username and password to the system.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
47 of 51
Title
Reporting System Function Design Specification
3.3.4.2
Change Password
Figure 43 Change Password User can change their password after they login to the system. They should insert the old password and replace it with a new one using this page.
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
48 of 51
Title
Reporting System Function Design Specification
3.3.5 Database Diagram 3.3.5.1
Production Report Database Diagram
Rekap Efektifitas Produksi Report
Rekap Harian Produksi Report
Daily Report
Hourly Report Figure 44 Production Report Database Diagram
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
49 of 51
Title
Reporting System Function Design Specification
3.3.5.2
Web Report Database Diagram
Figure 45 Web User Database Diagram
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
50 of 51
Title
Reporting System Function Design Specification
Figure 46 Report Database Diagram
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
Project IS&ENG Indonesia
Upgrading of OS CEMAT V4 To V7 with PCS7 System
Document No.
Rev
Date
Page
340P-80046.P
P
20/04/11
51 of 51
Title
Reporting System Function Design Specification
4
ATTACHMENT (MASTER REPORT)
Baturaja_Reporting System Functional Design Specification This document and the copyright is owned by Siemens A&C Indonesia. It may neither be copied nor submitted to third parties for copying without permission of the company
BAKU
KOREKSI
HOURS
LS
CL
I / II
I / II
SS
RAW MILL FEED ( COUNTER )
IS
LS
CL
SS
IS
R1A01A1
C1R02A1
E1A01A1
E1B01A1
VERTICAL MILL TEMPERATUR HYDRAULIC PRESSURE
POWER MOTOR
DIFF. PRESS
: 2 RD 2300-03
HALAMAN
: 1 dari 1 EP FAN
CLASSIFIER
HOPPER
VIBRASI
TOTAL FEED
STORAGE BAHAN
N0.DOKUMEN
MILL FAN
PRESS. INLET
TEMP. INLET
J1P11
(J1P11)
R.90u
R.200u
H2O
N3P01
N4T01
%
%
%
INLET
OUTLET
(R1M01)
(R1M01)
R1M08
R1M09
R1M01
R1M03
R1M01
R1S01
R1S05
R1S05
N3T01
N6T01
N1P01
N1P01
N1V01
M1J01
N5P01
D1S01
M1J01
N6P01
C
bar
bar
mm/s
kW
mbar
%
Kw
mbar
%
mbar
70-134
43-95
43-95
3-20
0-2630
44-125
0-100
0-2850
-15-10
0-100
0-12
S06
RESIDU ON
R1M01 I1 %
Ton
10-100
20-115
T/H
O
C
O
MOISTURE
REKAMAN MUTU PERFORMANCE OPERASI PENYIAPAN RAW MEAL
PT.SEMEN BATURAJA ( PERSERO ) SEKSI PENG.BAMEN
O
CF - SILO
Raw Mill Hourly Report
Level
%
C
08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 Std
-
-
MASALAH
0-450
0-100
0-35
0-25
210-500
183-434
ANALISA PENYEBAB
TINDAKAN
HASIL / KETERANGAN
0-250
Max.18 Max.1,5 Max.1
45-95
TGL OPERASI : T.TANGAN OPERATOR CCR
SHIFT I II III SHIFT
T.TANGAN KA.SI. PENGGILINGAN
I II III CATATAN :
1. Pengisian data harus Jelas, lengkap dan actual
2. Informasi harus dapat ditelusuri
3. Penyimpangan dari standart harus diberi penjelasan
Coal Mill Hourly Report REKAMAN PENGENDALIAN OPERASI COAL MILL
%
m3/min
Kw
65 s/d 75
60 s/d 78
STATUS ( Yes/ No )
70 s/d 100
C
o
R 90 U
240 s/d 400
C
STATUS ( Yes/ No )
110 s/d 140
o
SIEVING
% H 2O
0.7 s/d 3.0
C
FINE COAL CAL. BIN WEIGHT W1P82A1W01
12 s/d 20
o
: …………………………
BURNER BIN WEIGHT W1P72A1W01
3 s/d 10
C
C
Ton
Ton
%
Y/ N
%
Y/ N
Max. 90
Max. 90
30 s/d 65
30 s/d 65
Max. 9
Max. 9
Max. 20
Max. 20
STATUS
o
C
TEMP CAL BIN K1L12N1T01
60 s/d 80
o
: 2 RD 2301 - 06
Tanggal
SHIFT
%
TEMP BURNER BIN K1L11N1T01
KW
POWER MOTOR K1P16M1 J01
Bar
AIR FLOW K1P16N5 F01
mm/Sec
No. Dokumen
PFISTER BIN
LOUVRE DAMPER K1P15M1Z01
THROT DAMP. POS K1T37M1Z01
mBar
CHAMBER 2 TEMP. K1P11N2T02
KW MOTOR C M K1M03M1J01
mBar
CHAMBER 1 TEMP. K1P11N1T01
GRINDING PRESS M07A1P01
%
MILL FAN
JET PULSE OUT TEMP C MILL K1M01N5T01
C MILL VIBRATION M01N4V01
%
IN TEMP C MILL K1M01N1T01
C MILL PRESS M01N3P01
Ton
INLET PRESS M01N2P01
Ton
DRIYING
CLASIFIER SPEED S01M1S02
M
GRINDING
FEEDER A01M1I01
A
CLASIFIER
COUNTER BELT WAIHGER F1J51 A1
J
FEEDING RAW COAL SILO WEIGHT L01A1W01
BIRO PRODUKSI BATURAJA
o
WATER CONTAINT
+
PT. SEMEN BATURAJA ( PERSERO )
STANDARD PENGENDALIAN
08.00 09.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 01.00 02.00 03.00 04.00 05.00 06.00 07.00 Pengisian : Kumulatif :
Max. 260
65 s/d 75
PERMASALAHAN DAN TINDAKAN PENYELESAIAN M A S A L A H
TINDAKAN PENYELESAIAN
65 s/d 75
70 s/d 250
S/B
OP. CCR COAL MILL
Ka. SEKSI PEMBAKARAN
I II III Rekomendasi Kabag. Pembakaran :
Kiln Hourly Report
mg/ m3
%
%
%
%
%
%
%
%
%
Gr/ Lt
o
C
Y/N
PENYIMPANAN CLINKER SILO ( I / II / III / CCS / Int.Med.)
%
kcal/kg PRODUKSI, ton cli pershift
SPM mg/ m3 BAR BAR BAR U / D
STATUS
SPM
TEMPERATURE
SPM
LITER WEIGHT ( L/W )
mbar
FREE LIME
C
SILO-II LEVEL
o
SILO-I LEVEL
mBar
SILO-III LEVEL U1L11N1 L01
T/ J
INTER. SILO LEVEL U1L01N1L01
T/ Shift
PH B
CO B50A1 A03
T/ J
CLINKER PRODUCT
STORAGE SILO
O2 B50A1 A02
T/ Shift
CLINKER
2 RD 2301 - 02
O2 A50A1 A02
%
Emisi Dust J1S01A1DO1
%
Opacity J1S01A1OO1
C
Kiln Pos Up / Down
o
GRATE III W1K04A1 S03
5
mBar
PH A
GRATE II W1K03A1 S02
s/d
880
C
PH OUT GAS ANALYZER
HYD. PRESS
GRATE I W1K02A1 S01
s/d
380
o
EP Dust
Under Grate I Pressure W1K23N1 P01
s/d
870
C
COUNTER W1V82 A1 FLOW W1V82A1 F01
s/d
880
o
COUNTER W1V72 A1 FLOW W1V72A1 F01
3
s/d
380
C
SPEED J1J03M1
850
s/d
60
o
SPEED J1J01M1
40 s/d
90
C
Secukupnya
65 s/d
o
TEMP TAD W1B55N1 T01
Max. 85
C
OUT GAS W1B54N1 T01
%
OUT GAS T01
%
o
COOLER
SLC
GRATE III W1K04N1P01
KILN
: :
CO A50A1 A03
COAL FIRING
Secukupnya
PRESSURE TAD W1B55N2 P01
OUT MATERIAL W1A55N2 T01
%
OUT GAS W1A55N1 T01
TORQUE W1W01I1 I01
T/ J
OUT GAS W1A50N1 T01
SPEED W1W03M1 S01
COUNTER W1A01 A1
Current W1A10
M
B
STROKES
FLOW W1A01A1 F01
A
A
W1B50N1
J
IDF
SLC
GRATE I W1K02N6P01
Cy.1st Cy.4th
GRATE II W1K03N1P01
STR - B
Cy.4th
Emisi stack ESP W1S01A1 D01
STR - A Cy.1st
SEC. AIR TEMP. W1K01N2 T01
KILN
KILN HOOD PRESS W1K01N1 P01
KILN FEED
No. Dokumen Tanggal
HC,
REKAMAN PENGENDALIAN OPERASI KILN
BIRO PRODUKSI BATURAJA
( FCaO )
PT. SEMEN BATURAJA ( PERSERO )
08.00 09.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 01.00 02.00 03.00 04.00 05.00 06.00
………………...……..
ton
360
850
840
M A S A L A H
360
- 0,2 s/d
Max. 80
Max. Max. 20 80
Max. 0,20
Max. 0,20
Max. 1,5
- 0,8
PERMASALAHAN DAN TINDAKAN PENYELESAIAN TINDAKAN PENYELESAIAN
1100 s/d
1250
STATUS S/B
< 1,5 =Y > 1,5 = N
Produk ………...….…… t/h Kumulatif :
JUMLAH PEMAKAIAN LISTRIK KILN COAL MILL .........................
Kwh
.........................
Kwh
SHIFT
PENGENDALIAN
07.00
OP. CCR KILN
Ka. SEKSI PEMBAKARAN
I
..............................
................................
II
..............................
................................
III
..............................
................................
Rekomendasi Kabag. Pembakaran :
Cement Mill Hourly Report PT.SEMEN BATURAJA ( PERSERO ) SEKSI PENG.SEMEN
REKAMAN MUTU PERFORMANCE OPERASI CEMENT MILL
FEED
HOURS CLNK
GYP
Z1L02 Z1L01 %
%
FLY ASH SCREW
COUNTER
STOCK
HYDRAULIC ROLLER PRESS BELT SPEED
GRIT SEPARATOR
FINISH MILL
SEPAX SEPARATOR
N0.DOKUMEN
2 RD 2401-04
HALAMAN
1 dari 1
SEPARATOR FAN
KWALITAS PRODUK
STORAGE SEMEN LEVEL
Fly Ash
CLNK
GYP
Fly Ash
SPEED
POWER
GAP Z01
GAP Z02
GP
SPEED
DAMPER FAN
POWER
VENT.
TEMP. CMN OUT
SPEED
FRESH AIR
DAMP
SPEED
R.90u
R.45u
SO3
BLAINE
CEMENT FREE LIME
Z1L11
Z1B01A1
Z1A01A1
Z1J13A1
SPEED
RATE
Z1A06
SPEED
POWER
GAP
GAP
Z1M27
S10 S01
S13 I1
M03
P54
Z1M01N7 T01
S01 I1
Z1S02
P16 I1
P1711
R90U
R45U
SO3
BLNE
FCAO
Ton
Ton
Ton
Ton
%
Ton
%
M33 S01
M33 I01
MM
MM
Bar
%
%
KW
%
C
%
%
%
%
%
%
%
Cm2/g
%
15 - 100
1-8
22 - 100
69 - 94
37 - 100
8,1 - 35,8
12 - 32,7
110 - 150
40 - 90
60 - 100
80 - 120
49 - 78
69 - 100
82 - 94
Z1 J 19 M2
SILO I
SILO II
Z1L04N1L01 Z1L05N1L01
%
%
9 - 95
9 - 95
08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00
Std
16 - 92 11 - 94
0-235
MASALAH
ANALISA PENYEBAB
TINDAKAN
957 - 1350 15 - 45
HASIL / KETERANGAN
Max.10 Max.25
1,5-3,5* Min.3000* MAX. 4** Min.3150**
TGL. OPERASI : SHIFT
T. TANGAN OPERATOR CCR
I II III SHIFT
T. TANGAN KA.SI. PENGGILINGAN
I II III H20 Gypsum ( % )
1. Pengisian data harus Jelas, lengkap dan actual
2. Informasi harus dapat ditelusuri
Catatan : * untuk semen type I, dan ** untuk semen komposit
Fly Ash masuk ( Ton )
STEEL BIN
STEEL BIN
Z1L06 Z1L07 TON
TON
Raw Mill Daily Report PT.SEMEN BATURAJA (PERSERO) TARGET PRODUKSI R. MEAL SHIFT I = LIME STONE
TON CLAY
TARGET PRODUKSI R. MEAL SHIFT II = PASIR SILIKA
PASIR BESI
% H2O
Ton dry
Ton wet
% H2O
Ton dry
Ton wet
% H2O
Ton dry
Ton wet
% H2O
TON
RAW MEAL
SHIFT Ton wet
No. Dokumen Halaman Tanggal
LAPORAN HARIAN PENGGILINGAN BAHAN MENTAH
Ton dry % H2O Avg
TARGET PRODUKSI R. MEAL SHIFT III = FREK KEHALUSAN > STD
PRODUCT Raw Meal
: 2 RD 2400-04 : 1 dari 2 :
Kwh/ Ton
R+200u
Y/T
R+90u
Y/T
JAM OPERASI
TON JUMLAH % H2O>1
Y/T
% Silo≤45
Y/T
I
0
6.00
0.0
0
0.00
0.0
0
0.00
0.0
0
0.00
0.0
0.00
0.0
#DIV/0!
0
T
0
T
0
T
0
T
II
0
0.00
0.0
0
0.00
0.0
0
0.00
0.0
0
0.00
0.0
0.00
0.0
#DIV/0!
0
T
0
T
0
T
0
T
III
0
0.00
0.0
0
0.00
0.0
0
0.00
0.0
0
0.00
0.0
0.00
0.0
#DIV/0!
0
T
0
T
0
T
0
T
0.0
0.0
0.0
0.0
0.0
0.0
0.00 0.0
TOTAL
0.0 Standard / Shift
KOMENTAR : SHIFT I
KOMENTAR : SHIFT II
Power Mwh meter : : : :
Vm motor Mfan Rmtrafo Total
Kwh / shift 0.00 0.00 0.00 0.00
0.00
PARAF :
Power Mwh meter : : : :
INSTRUKSI : RENCANA PRODUKSI RAW MEAL =
LIME STONE
CLAY
PASIR
PASIR
( Ton )
(Ton)
BESI
SILIKA
C/T
C/T
I II Kwh / hari :
19.92
Max.1,5
Max.18
Max.1
Min.45
Max.1
Max.1
Max.1
Max.1
KOMENTAR : SHIFT III
Kwh / shift 0.00 0.00 0.00 0.00
0.00
PARAF :
STORAGE ( JAM 07:00 ) PILE
Vm motor Mfan Rmtrafo Total
0.98
Vm motor Mfan Rmtrafo Total
Power Mwh meter : : : :
Kwh / shift 0.00 0.00 0.00 0.00
PARAF : TON / HARI
Baturaja,
Ka Bagian Penggilingan Bta
0.00
KCC Daily Report REKAMAN HARIAN PERFORMANCE OPERASI PEMBAKARAN PABRIK BATURAJA
PT. SEMEN BATURAJA (PERSERO) BIRO PRODUKSI
SHIFT
Factor Clinker
Heat Comsump
%
(Kcal/Kg)
STOCK CLINKER
PRODUKSI Pemakaian Bahan & Produk, ton KilnFeed
FineCoal
Solar
Jam Operasi Kiln
Clinker
Jam Operasi Coal
Pemakaian Listrik Coal Mill
Pemakaian Listrik Kiln kWh
kWh/ ton
kWh
:
Halaman
:
STOCK COAL
2 RD 2301-02 2 dari 2 KUALITAS PRODUK
Intern.Silo
Silo I
Silo II
Silo III
Cover Storage
Open Storage
Raw Coal Silo
Fine Coal Burner Bin
Fine Coal Calciner Bin
%
%
%
%
%
Ton
Ton
Ton
Ton
kWh/ ton
No Dokumen
CLINKER % Fcao
Y/ T
COAL
Liter Weight
Y/ T
% H2O
Y/ T
% R90 U
Y/ T
I
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.50
Y
1,233.85
T
7.72
Y
19.00
Y
II
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.50
Y
1,233.85
T
7.72
Y
19.00
Y
III
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.50
Y
1,233.85
T
7.72
Y
19.00
Y
TOTAL
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Standard Per Shift
-
-
-
-
-
-
Max. 45
-
Max. 45
-
-
SHIFT I TARGET PRODUKSI CLINKER SHIFT I
-
-
-
-
-
-
-
Max 1,5
Y<=1,5
SHIFT II
=
TON
TARGET PRODUKSI CLINKER SHIFT II
Power MWh Meter
1100<LW<1250
Y<=1,5
Max. 9
Y<= 9
SHIFT III
=
TON
TARGET PRODUKSI CLINKER SHIFT III
Power MWh Meter
=
TON
Power MWh Meter
Kiln Drive Trafo
:
0.00
IDF - A Trafo
:
0.00
Kiln Drive Trafo
:
0.00
IDF - A Trafo
:
0.00
Kiln Drive Trafo
:
232323.00
IDF - A Trafo
:
23331.00
Kiln Aux. Trafo
:
0.00
IDF - B Trafo
:
0.00
Kiln Aux. Trafo
:
0.00
IDF - B Trafo
:
0.00
Kiln Aux. Trafo
:
132232.00
IDF - B Trafo
:
21231.00
Cooler Trafo 1
:
0.00
Boster Fan
:
0.00
Cooler Trafo 1
:
0.00
Boster Fan
:
0.00
Cooler Trafo 1
:
2321325.00
Boster Fan
:
0.00
Cooler Trafo 2
:
0.00
Filter Fan
:
0.00
Cooler Trafo 2
:
0.00
Filter Fan
:
0.00
Cooler Trafo 2
:
0.00
Filter Fan
:
13223.00
0.00
Coal Mill Drive Trafo
0.00
Coal Mill Drive Trafo
Total Coal Mill Drive Trafo ID Fan
:
:
0.00 0.00
:
Total Coal Mill Aux. Trafo
0.00 Total
:
ID Fan
: :
0.00
PARAF KEPALA SEKSI PEMBAKARAN :
:
0
0.00
0
0.00 Total
KOMENTAR : SHIFT I
PRODUKSI CLINKER KOMULATIF :
:
:
0.00
Total Coal Mill Aux. Trafo
:
ID Fan
:
132123.00
:
2743665.00 Coal Mill Aux. Trafo
:
13223.00
:
0.00
Total
KOMENTAR : SHIFT II
KOMENTAR : SHIFT III
PARAF KEPALA SEKSI PEMBAKARAN :
PARAF KEPALA SEKSI PEMBAKARAN :
:
148469.00
TON Baturaja,
22/01/2011
Kepala Bagian Pembakaran PBR Catatan :
3123.00
Max. 20
Y<= 20
Cement Mill Daily Report
REKAMAN HARIAN PERFORMANCE OPERASI CEMENT MILL PABRIK BATURAJA
PT. SEMEN BATURAJA (PERSERO) BIRO PRODUKSI
PRODUKSI SEMENT PORTLAND TIPE-I
MOISTURE
No Dokumen
:
2 RD 2300-04
Halaman
:
1
PRODUKSI SEMENT PORTLAND KOMPOSIT KUALITAS PRODUK STANDAR
SHIFT
Gypsum
Third
%
%
Pemakaian Bahan & Produk, ton Clinker
Gypsum
Third
Fly Ash
Cement
Jam Operasi
Pemakaian Bahan & Produk, ton
Pemakaian Listrik kWh
kWh/ ton
Clinker
Gypsum
Third
Fly Ash
Cement
Jam Operasi
Pemakaian Listrik kWh
kWh/ ton
% SO3
Residue 90µm
Y/ T
Y/ T
Blaine
Residue 45µm
Y/ T
Y/ T
I
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
T
0.00
T
0.00
T
0.00
T
II
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
T
0.00
T
0.00
T
0.00
T
III
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
T
0.00
T
0.00
T
0.00
T
0.00
TOTAL
0.00
0.00
Standard Per Shift
-
0.00
0.00
-
-
0.00 -
0.00 -
0.00 -
0.00
0.00 -
Max. 45
0.00
0.00
-
-
0
TON
TARGET PRODUKSI SEMEN SHIFT II
Roller Press Trafo
:
0.00
ID Fan Trafo
Mill Motor Trafo
:
0.00
Auxiliaries Trafo
-
0.00 -
0.00
1.5 - 3.5* Max 4**
Max 10
Max 1
Max 1
Max. 45
: :
TARGET PRODUKSI SEMEN SHIFT III
TON
Roller Press Trafo
:
0.00
ID Fan Trafo
0.00
Mill Motor Trafo
:
0.00
Auxiliaries Trafo Total
:
: :
=
PENERIMAAN FLY ASH :
PARAF KEPALA SEKSI PENGGILINGAN SEMEN :
TON/ HARI
Roller Press Trafo
:
0.00
ID Fan Trafo
0.00
Mill Motor Trafo
:
0.00
Auxiliaries Trafo Total
:
: :
0.00
KOMENTAR : SHIFT III
TON
PENERIMAAN FLY ASH :
PARAF KEPALA SEKSI PENGGILINGAN SEMEN :
PRODUKSI SEMEN KOMULATIF :
TON
0.00
0.00
KOMENTAR : SHIFT II
TON
Max 1
Max 1
Power MWh Meter
0.00
0.00
Max 25
SHIFT III
Power MWh Meter
KOMENTAR : SHIFT I
INSTRUKSI: RENCANA PRODUKSI SEMEN =
-
=
Power MWh Meter
PENERIMAAN FLY ASH :
-
0.00
0.00
SHIFT II
=
Total
0.00
-
SHIFT I TARGET PRODUKSI SEMEN SHIFT I
0.00
OPC Min 3000* PCC Min 3500**
TON
PARAF KEPALA SEKSI PENGGILINGAN SEMEN :
0.00
TON Baturaja,
Catatan : * Untuk Semen Portland Tipe I, Dan ** Untuk Semen Portland Komposit
Kepala Bagian Penggilingan PBR
0.00 0.00
Rekap Harian Produksi Report (RHP) PT. SEMEN BATURAJA (PERSERO)
No. Dokumen
REKAP HARIAN PRODUKSI
BIRO PTP
: 1 RD-2424-01 : 1 dari 1
Halaman Tanggal Operasi
PABRIK BATURAJA
:
I. PENGENDALIAN PROSES Kumulatif
Pengisian storage Limestone & Clay -
Lime stone - 2 , ton kumulatif
-
Clay - 1 , ton kumulatif
-
% H2O
Clay - 2 , ton kumulatif
-
% SO3
B a h a n
Clay
Harian
-
-
Gypsum Umpan C. Mill -
% H2O
Fine coal
-
Clinker Outlet Kiln
Kiln feed
Solar
-
% FCaO
-
-
-
% C3S
-
% SO3
-
% 200 u
-
-
% C2S
-
R+90 u
-
% 90 u
-
-
% C3A
-
R+45 u
-
-
% C4AF
-
% C 3S % C 2S
SM
-
LSF
AM
-
SM
% C 3A
AM
% C 4AF
% FCaO Terak Dispath & Kirim
-
Cement Outlet C.Mill
% FCaO
% H2O
LSF
B a k a r Raw coal
Raw meal
% RCO 3
% H2O
Lime stone - 1 , ton kumulatif
Parameter
Lime stone
% RCO 3
% 200 u
-
% FCaO
Harian
% 90 u
-
Dispath
-
-
-
Ke PPG
-
-
-
AM
Ke PPJ
-
-
-
Blaine cm2/gr
Ď , gram / ml NHV. Kcal/kg
-
Mingguan
Bulanan
L/W, gr/lt
-
Temp.oC
LSF SM -
II. PENGGILINGAN BAHAN MENTAH Performance operasi / Pemakaian Bahan Uraian Produksi Raw meal , ton
Harian
Stock bahan
Bulanan
0.0000
Bahan
Tahunan
0.0000
0.0000
Operasi Raw Mill , jam
Raw meal , CF silo
-
-
-
Tanah liat , ton
-
-
-
Clay storage 1
Pasir Silika , ton
-
-
-
Clay storage 2
Pasir Besi , ton
-
-
-
Pasir Silika
-
-
-
Kwh / ton Raw Meal
IDO Hot Gas Mill , klt
-
Crusher Bamen : -
Lime stone storage 2 Vertical Mill :
Pasir Besi
III . PEMBAKARAN
2636
Performance operasi / Pemakaian Bahan Uraian
ton
Lime stone storage 1
Batu kapur , ton
Mill power , Kwh
Hambatan operasi
%
Harian
Stock bahan
Bulanan
Produksi Terak, ton
0
Lokasi
Tahunan
-
-
%
Hambatan operasi ton
Kiln :
Terak silo 1
-
Operasi Kiln, jam
Terak silo 2
-
Operasi Coal Mill, jam
Terak silo 3
-
Heat Cons, kcal/kg terak
Terak Inter. Silo
-
Dumping Clinker D.Truck PBR
-
Coal Mill :
Umpan Kiln, ton
-
-
-
Terak Inter. Bin
Solar Kiln, klt
-
-
-
Terak Cover Storage, ton
Fine coal, ton
-
-
-
Raw coal, ton
-
Open St.
-
Solar Kiln, klt
Kiln power , Kwh Coal Mill power , Kwh
Tot. Persediaan Terak
Kum. DT
0 -
Angkutan Terak :
-
-
IDO, klt
-
-
Raw coal, ton Silo
Clinker Dispath , grb
Terak
Kirim Ke PPG , grb
PPG, %
Kirim Ke PPJ , grb
PPJ ,%
Semen 1
Semen 2
IV. PENGGILINGAN SEMEN & PENGANTONGAN Performance operasi / Pemakaian Bahan Uraian
Harian
Produksi Cement Mill , ton
-
Prod. Cmt. Packer , ton
-
Stock bahan
Bulanan
Tahunan
-
-
Lokasi Semen silo 1
0.00
Terak , ton
-
-
-
Gypsum , ton
-
-
-
Fly Ash, ton
-
-
-
Cement Mill PPG :
Gypsum, ton
PPG & PPJ Ton Cm.Mill, PPG
Kantong Semen, 3 ply , lbr
Ton Packer, PPG
Kantong Semen, 4 ply , lbr
Ton Cm.Mill, PPJ
Cement Mill power , Kwh
5 #DIV/0! Bulan ini
Produksi Terak, ton RKAP
98,600
% pencapaian prod. Terak
-
Real Prod. Terak ( - ) RKAP Prod. Tambang Harian :
-
Total Persediaan, ton
Kantong Semen, 2 ply , lbr
V. PENCAPAIAN RKAP :
Cement Mill PBR :
Semen Feed Bin
Operasi Cmt. Packer, jam
Kwh / ton Semen
Hambatan operasi ton
Semen silo 2
Operasi Cement Mill , jam
Cement Packer power, Kwh
%
Bulanan
Cement Mill PPJ :
Cement Packer :
Ton Packer, PPJ
74
74
217
217
Jam opr. Cm.Mill, PPJ
#DIV/0!
#DIV/0!
Penerimaan Batubara
Jam opr. Cm.Mill, PPG Ton / Hari
Ton / Bulan
Kumul.s/d bulan ini
Baturaja, 02-01-2010
279,400 -
(98,600) (279,400) 0 * Lime Stone * Clay
Harian
Ka Bag. Eng. Produksi
0
Note : 1. Dok. dianggap sah bila dibubuhi dg tanda tangan asli penanggung jawab dok. 2. Lap ini bukan data resmi utk kepentingan ext. prsh
No. Revisi : 01 Tgl. Revisi : 01-06-2003
Packer Daily Report
REKAMAN MUTU
PT SEMEN BATURAJA
PERFORMANCE OPERASI CEMENT PACKER
(PERSERO)
SHIFT / GRUP
PRODUKSI PACKER P1
P2
DO CURAH
PCC
B BAG
CPSL
TON
TON
DO
ZAK PECAH (PCS/JNS) JAM OPERASI
TON
ZAK
TON
ZAK
TON
TRM PNDG TON
DISTRIBUSI KANTONG
KAPASITAS 50 KG
P1 ZAK
No. Dokumen : 2.RD.2302 - 17 Halaman : 1 dari 1
P1
P2
T/J
T/J
2 PLY PCC
2 PLY OPC
P2
3PLY
40 KG
BBAG
DK
L +K
INTR
1 PLY
TON
PSTD
BGR
PSTD
BGR
PSTD
LP +
LK
JHT
LP
BTA
ME
BKL
I/
0
0.00
0
0.00
0
0.00
0.00
0.00
0.00
0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
II /
0
0.00
0
0.00
0
0.00
0.00
0.00
0.00
0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
III/
0
0.00
0
0.00
0
0.00
0.00
0.00
0.00
0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.00
0
0.00
0
0.00
0.00
0.00
0.00
0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL (ZAK) HARI INI =
0
ZAK
//
TOTAL (TON) HARI INI =
KUMULATIF BULAN INI =
0
ZAK
//
KUMULATIF (TON)
SEMEN TRANSIT PPJ (KA) TON
ZAK
PPG (KA)
TON
ZAK
PPG (TRUCK)
TON
ZAK
TON
VIA (KA) ZAK
//
TOTAL (TON ZAK + TON CURAH)
0 TON
//
KUMULATIF (TON ZAK + TON CURAH)
PNJ. LB LING
VIA (TRUCK)
TON
ZAK
TON
TOT
TOT
TOT
TOT
TOT
TOT
JENIS PEMAKAIAN KANTONG
JAM
ZAK
TON
ZAK
TOT
1 PLY
PSTD
BGR
PSTD
3 PLY
BGR
PSTD
40 KG
TON
SPT
PENYELESAIN
BBAG
JHT
I
0
0
0
0
0
0
0
0
0
II
0
0
0
0
0
0
0
0
0
III TOT
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
0 0
TANGGAL :
0 TON SAMPLE MONITORING BERAT / ZAK
TOT
MASALAH
=
1 2 3 4 5 6 7 8
BOBOT (KG) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
LAMA
AVG
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 GANGG OPRS (JAM) LIST. / INST
2 PLY PCC
2 PLY OPC
0 TON
VIA (KA)
50 KG SHIFT
=
PENJ. PENJW
PACKER I
ZAK
PPJ (TRUCK)
=
PENJUALAN KT BUMI
0 TON
22-January-2011
1. Harus di isi dengan data yang akurat
0.00 MEKANIK 0.00 OPERASI 0.00
2. Bila ada hambatan, kelainan (sample, penggantian kantong, dll) agar ditulis
SPT
1 2 3 4 5 6 7 8
PACKER II
TOT
BOBOT (KG)
AVG
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
PEMAKAIAN LISTRIK : :
KwH MTR I KwH MTR II
:
KwH / HARI KwH / TON SHIFT
0 0
: PRP OPR
I II III
3. Alasan pending, harus ditulis
0 (2,5 kw) PRP KA SIE
OEE Monthly Report PT SEMEN BATURAJA (PERSERO)
OEE KILN SYSTEM REPORT
Doc. No :
-
Page :
1
Area Department :
Kiln
Month OEE Report :
Tgl
Jam Operasi Sedia Realisasi
Hari Stop Bln
Produksi Bln
Kum
TCT
Kum
1
-
-
-
0.00556
2
-
-
-
0.00556
3
-
-
-
0.00556
4
-
-
-
0.00556
5
-
-
-
0.00556
6
-
-
-
0.00556
7
-
-
-
0.00556
8
-
-
-
0.00556
9
-
-
-
0.00556
10
-
-
-
0.00556
11
-
-
-
0.00556
12
-
-
-
0.00556
13
-
-
-
0.00556
14
-
-
-
0.00556
15
-
-
-
0.00556
16
-
-
-
0.00556
17
-
-
-
0.00556
18
-
-
-
0.00556
19
-
-
-
0.00556
20
-
-
-
0.00556
21
-
-
-
0.00556
22
-
-
-
0.00556
23
-
-
-
0.00556
24
-
-
-
0.00556
25
-
-
-
0.00556
26
-
-
-
0.00556
27
-
-
-
0.00556
28
-
-
-
0.00556
29
-
-
-
0.00556
30
-
-
-
0.00556
31
-
-
-
0.00556
-
0.00556
SUM/AVG
-
-
-
-
0
Availability
Performance Rate
Quality Rate
OEE
OEE Target
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100%
0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59% 59%
0.00%
0.00%
100.00%
0.00%
59.00%
OEE Yearly Report PT SEMEN BATURAJA (PERSERO)
OEE KILN SYSTEM REPORT
Doc. No :
-
Page :
1
Area Department :
Kiln
Year OEE Report :
Month
Jam Operasi Sedia Realisasi
Hari Stop Bln
Produksi Bln
Kum
TCT
Kum
Availability
Performance Rate
Quality Rate
OEE
OEE Target
January
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
February
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
March
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
April
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
May
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
June
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
July
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
August
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
September
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
October
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
November
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
December
-
-
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
-
0.00556
0.00%
0.00%
100.00%
0.00%
59.00%
SUM/AVG
-
-
-
-
-
MTBF_MTTR Monthly Report
MONTHLY MTBF& MTTR RAW MILL DEPARTMENT EQUIPMENT
PT SEMEN BATURAJA (PERSERO)
Doc. No :
‐
Page :
1
Equipment Name : Month Report :
Day
Normal
Stop Hours Failure
Failure Freq
Running Hours
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
SUM
MTBF
Repair Repair Hours
Repair Freq
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
0
0
January
MTTR 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
MTBF_MTTR Yearly Report
YEARLY MTBF& MTTR RAW MILL DEPARTMENT EQUIPMENT
PT SEMEN BATURAJA (PERSERO)
Month : January February March April May June July August September October November December
SUM
Normal
Stop Hours Failure
Failure Freq
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0
0
Running Hours
MTBF
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0
0
0
0
Doc. No : Page : Equipment Name : Year Report :
Repair Repair Hours Repair Freq 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0
0
MTTR 0 0 0 0 0 0 0 0 0 0 0 0
0
Daily Energy Meter
DAILY REPORT ENERGY METER
PT SEMEN BATURAJA (PERSERO)
No. Dokumen : Halaman : Tanggal :
DEPARTMENT AREA RAW MILL
CEMENT MILL
KILN
COAL MILL
COOLER
Vm Motor : Mfan : RMTrafo :
0.00 0.00 0.00
Kwh Kwh Kwh
Roller Press Trafo : Mill Motor Trafo : Auxiliaries Trafo : ID Fan Trafo :
0.00 0.00 0.00 0.00
Kwh Kwh Kwh Kwh
Kiln Drive Trafo : Kiln Aux Trafo : IDF-A Trafo : IDF-B Trafo : Booster Fan : Filter Fan :
0.00 0.00 0.00 0.00 0.00 0.00
Kwh Kwh Kwh Kwh Kwh Kwh
Coal M. Aux Trafo : K1TR02_J02 Mill Fan : Mill Motor :
0.00 0.00 0.00 0.00
Kwh Kwh Kwh Kwh
Cooler Trafo 1: Cooler Trafo 2: C1TR01_J02
0.00 0.00 0.00
Kwh Kwh Kwh
Total
0.00
Kwh
Total
0.00
Kwh
Total
0.00
Kwh
Total
0.00
Kwh
Total
0.00
Kwh
Comment :
Comment :
Comment :
Comment :
Comment :