User manual
Table Of Contents
- DOP eServer User Manual-cover.pdf
- DELTA_IA-HMI_DOP-eServer_UM_EN_20140707
- Table of Contents
- Publication History
- Chapter 1 Introduction
- Chapter 2 Software Installation
- Chapter 3 Before using eServer
- Chapter 4 Excel Sampling Setting
- Chapter 5 Writing Data in Microsoft Excel
- Chapter 6 ODBC Sampling Setting
- Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System
- Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7
- Chapter 9 Writing Data in MySQL
- Chapter 10 Writing Data in SQL Server 2005
- Chapter 11 Writing Data in Oracle
- Chapter 12 Recipe Access Setting
- Chapter 13 Recipe Access Example
- Appendix A Upload & Download via Ethernet
Chapter 5 Writing Data in Microsoft Excel
Revision March, 2014 5-7
The system will enable Excel automatically. Create a Excel template sheet as the
figure below and enter the following formulas into the cells of E3 ~ E20 in order.
Then, press Close button in the dialog box which appears at the bottom right of
Windows screen to go to next step.
Column
Formula
Column
Formula
E3
=AVERAGE(C3:D3)
E12
=AVERAGE(C12:D12)
E4
=AVERAGE(C4:D4)
E13
=AVERAGE(C13:D13)
E5
=AVERAGE(C5:D5)
E14
=AVERAGE(C14:D14)
E6
=AVERAGE(C6:D6)
E15
=AVERAGE(C15:D15)
E7
=AVERAGE(C7:D7)
E16
=AVERAGE(C16:D16)
E8
=AVERAGE(C8:D8)
E17
=AVERAGE(C17:D17)
E9
=AVERAGE(C9:D9)
E18
=AVERAGE(C18:D18)
E10
=AVERAGE(C10:D10)
E19
=AVERAGE(C19:D19)
E11
=AVERAGE(C11:D11)
E20
=AVERAGE(C20:D20)