Multi-Worksheet Export Mapping for Concurrent Field Data Filtering
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In industrial process control systems, extracting and filtering data from multiple sources is cumbersome and time-consuming, often resulting in unmanageable export files with duplicate information, as existing methods require manual manipulation and cannot handle concurrent data export from multiple sources efficiently.
Innovation Solution
A data processing system that receives sensor data from field devices, filters and maps data from multiple source files using configurable conditions, and exports organized data into multiple worksheets, allowing concurrent processing and efficient data export with intact associations.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If manual data extraction and filtering from multiple sources is performed, then data can be organized, but the process becomes cumbersome and time-consuming
Solution Approach 1:
The patent segments the data export process by generating multiple separate worksheets from different source files, with each worksheet containing data from a specific source filtered according to conditions. This automation eliminates manual data extraction and filtering operations.
Solution Approach 2:
The patent introduces an intermediary processing system that receives multiple source files, applies filtering conditions, and automatically generates organized worksheets. This intermediary automation resolves the contradiction by eliminating the need for manual manipulation while maintaining data organization.
2Productivity
If data from multiple sources is exported to a single file, then consolidation is achieved, but the file becomes unmanageable with duplicate information
Solution Approach 1:
Instead of consolidating all data into a single file, the patent segments the exported data into multiple separate worksheets, with each worksheet containing data from a specific source file. This segmentation maintains consolidation efficiency while avoiding the creation of unmanageable single files with duplicates.
Solution Approach 2:
The patent resolves the contradiction by changing the organizational dimension from horizontal (single file containing all data) to vertical (multiple worksheets stacked together). Each worksheet remains manageable in size while the collection of worksheets achieves comprehensive data consolidation.
3Ease of manufacture
If existing export methods are used, then simple data extraction is possible, but concurrent data export from multiple sources cannot be handled efficiently
Solution Approach 1:
The patent segments the export process to handle each source file independently, applying filtering conditions and generating worksheets concurrently from multiple sources. This segmented approach enables efficient parallel processing while maintaining simple export capabilities for each individual source.
Solution Approach 2:
The patent creates a universal export system that can simultaneously process multiple different source files with different data structures and filtering requirements. This multi-functional capability allows concurrent export operations without sacrificing the simplicity of individual data extraction processes.
Data Source
AI summary
A data processing system and method include processing circuitry configured to receive sensor data from a plurality of field devices and convert the sensor data to field data, receive a first source file having first field data exported from a first editor, receive a second source file having second field data exported from a second editor, filter the first and second field data according to one or more conditions, generate multiple worksheets based upon the one or more conditions of the filtered first and second field data, extract the filtered first and second field data from source fields of the first source file and the second source file and map the extracted first and second field data into related worksheet fields of the multiple worksheets, and export the multiple worksheets having the mapped and extracted first and second field data in an export file.