Proceedings of the 3rd Annual International Conference on Mechanics and Mechanical Engineering (MME 2016)

The Generation of Data Report of Roller Automatic Production Line Detection Unit

Authors
Yuan Liang, Jian-Ye Sun, Cheng-Feng Wei
Corresponding Author
Yuan Liang
Available Online December 2016.
DOI
10.2991/mme-16.2017.93How to use a DOI?
Keywords
WinCC, Data Reporting, Roller automatic production line.
Abstract

The detecting unit of the roller automatic production line detects the key parameters of each roller and archive them, to analyze whether the roller product performance standards according to the detecting information. The detecting data was stored into SQL database using the VBS of the WinCC software in the host computer. The data in the database were read out to report forms using the VBA in EXCEL for producer to analysis. To solve practical problems and good results have been achieved.

Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Download article (PDF)

Volume Title
Proceedings of the 3rd Annual International Conference on Mechanics and Mechanical Engineering (MME 2016)
Series
Advances in Engineering Research
Publication Date
December 2016
ISBN
10.2991/mme-16.2017.93
ISSN
2352-5401
DOI
10.2991/mme-16.2017.93How to use a DOI?
Copyright
© 2017, the Authors. Published by Atlantis Press.
Open Access
This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).

Cite this article

TY  - CONF
AU  - Yuan Liang
AU  - Jian-Ye Sun
AU  - Cheng-Feng Wei
PY  - 2016/12
DA  - 2016/12
TI  - The Generation of Data Report of Roller Automatic Production Line Detection Unit
BT  - Proceedings of the 3rd Annual International Conference on Mechanics and Mechanical Engineering (MME 2016)
PB  - Atlantis Press
SP  - 674
EP  - 679
SN  - 2352-5401
UR  - https://doi.org/10.2991/mme-16.2017.93
DO  - 10.2991/mme-16.2017.93
ID  - Liang2016/12
ER  -