Unlock instant, AI-driven research and patent intelligence for your innovation.

System and method for generating dcs project data based on excel form association

A data generation and excel technology, applied in data processing applications, electrical digital data processing, special data processing applications, etc., can solve the problems of inability to associate data, affect the quality of project execution, and increase project costs, so as to reduce costs and improve projects. Effectiveness of Execution Efficiency and Project Execution Quality

Active Publication Date: 2016-02-17
SIEMENS FACTORY AUTOMATION ENG
View PDF1 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, the Excel file itself cannot recognize the association within the DCS project data, that is, the data in different forms cannot be associated
In this way, DCS engineers have to compile a large number of data codes for DCS project data in the DCS software system (such as the PCS-7 system of Siemens) for project data processing in order to complete the DCS The software programming of the project, which will greatly increase the project cost, reduce the efficiency of project execution, and ultimately affect the quality of project execution

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • System and method for generating dcs project data based on excel form association
  • System and method for generating dcs project data based on excel form association
  • System and method for generating dcs project data based on excel form association

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0024] In order to make the purpose, technical solution and advantages of the present invention clearer, the following examples are given to further describe the present invention in detail.

[0025] In order to obtain the required project report of the DCS project, the DCS project data is summarized in an Excel file. According to different data types, DCS project data are recorded in different Excel sheets, and there is a relationship between the data in different sheets. If the Excel software can identify and process these associations, it can use these interrelated forms as a basis to perform calculations on the project data in each form to generate a large number of intermediate and result forms required by the DCS project, so as to be realized in the Excel software environment Similar functions to programming in DCS software system.

[0026] The present invention just utilizes the VBA programming interface of Excel to develop a DCS project data generating system based on...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a DCS (Data Communication System) project data generating system and method based on Excel sheet association. The system comprises a sheet relation generation module, a formula definition module and a result sheet calculating module. According to the technical scheme disclosed by the invention, each type of DCS project data can be effectively associated under an Excel software environment and program data available to a DCS software system can be directly generated, so that DCS project cost is reduced, and the project executing efficiency and the project executing quality are improved.

Description

technical field [0001] The invention relates to the field of DCS control systems, in particular to a DCS project data generating tool based on Excel sheet association. Background technique [0002] Distributed Control System (Distributed Control System, DCS) is a comprehensive control system that emerged with the continuous rise of modern large-scale industrial production automation and the increasingly complex requirements of process control. DCS projects often use Excel files and their forms as project data carriers to generate a large number of reports required by the project. Since there are associations between various project data, for example, since a circuit is composed of several input / output points, then, the relationship between the circuit form recording circuit information in the Excel file and the input / output point form recording input / output point information are related. [0003] However, the Excel file itself cannot recognize the association within the DC...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/24G06Q10/06
Inventor 胡田田张波王勇尹磊卢刚
Owner SIEMENS FACTORY AUTOMATION ENG
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com