CN106842982A - One kind is based on many software collaboration analogue systems of VBA - Google Patents
One kind is based on many software collaboration analogue systems of VBA Download PDFInfo
- Publication number
- CN106842982A CN106842982A CN201611204548.3A CN201611204548A CN106842982A CN 106842982 A CN106842982 A CN 106842982A CN 201611204548 A CN201611204548 A CN 201611204548A CN 106842982 A CN106842982 A CN 106842982A
- Authority
- CN
- China
- Prior art keywords
- module
- many software
- interface
- vba
- report generation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B17/00—Systems involving the use of models or simulators of said systems
- G05B17/02—Systems involving the use of models or simulators of said systems electric
Abstract
The many software collaboration analogue systems of VBA are based on the invention discloses one kind, the system includes simulation kernel module, result output module, report generation module, many software interface modules and operation interface：Operation interface calls simulation kernel module, result output module, report generation module and many software interface modules by versatile interface, and as a result output module, report generation module and many software interface modules carry out command signal and be connected with simulation kernel module respectively.The innovative design that the present invention passes through Multifunctional Interface Module, realizes many software collaboration work and diversification operation.The present invention realizes the lightweight and facilitation of analogue system using the scheme based on VBA, with versatility is good, easily transmitted, small volume, it is easy to operate the features such as.
Description
Technical field
It is more particularly to a kind of to be based on many software collaboration analogue systems of VBA the present invention relates to Simulation Software Design technical field.
Background technology
At present in automatic control system design of Simulation field, Matlab softwares account for dominance status always.Then due to this
Software footprint and resource are more, are unfavorable for shared and propagate, particularly for linear system time domain response analysis, analysis of stability
Seem very too fat to move during the classical control theory applications such as analysis, dynamic and static state parameters calculating.And classical control theory whether teaching,
Or suffered from engineering design it is commonly used, therefore in the urgent need to a kind of light-weighted emulation platform
The content of the invention
The present invention is directed to above-mentioned problem, there is provided one kind is based on many software collaboration analogue systems of VBA, realizes imitative
The lightweight and facilitation of true system, with versatility is good, easily transmitted, small volume, it is easy to operate the features such as.
It is of the invention a kind of based on many software collaboration analogue systems of VBA, including simulation kernel module, result output module, report
Accuse generation module, many software interface modules and operation interface：Operation interface calls simulation kernel module, knot by versatile interface
Fruit output module, report generation module and many software interface modules, as a result output module, report generation module and many software interfaces
Module carries out command signal and is connected with simulation kernel module respectively.
Preferably, the logical process of described simulation kernel module includes |input paramete pretreatment, network analysis and data
Storage:Parameter pretreatment is that the normalization of |input paramete is checked, bomp and amending advice are given to parameter lack of standardization；System
System analysis is to carry out Treatment Analysis to input data and Controlling model；Data storage is that the data that system is input into and is processed are carried out
Storage.
Preferably, described output module automatic running after the analysis of simulation kernel module completion system, with performance parameter
Or the form of response curve is exported onto control interface.
Preferably, described report generation module need to call operation in operation interface, exported in word document form and be input into
The analysis report of data, Controlling model, performance parameter, response curve and necessary process data composition.
Preferably, described many software interface modules are that, by browser plug-in or special data protocol, and have
The third party software of HTTP linkage functions realizes collaborative simulation.
Preferably, described operation interface includes the interface sample of the third party software with HTTP linkage functions.
The present invention in overcoming that existing control system emulation platform is too fat to move, be unfavorable for the problem that uses and propagates, there is provided one kind
Many software systems analogue systems based on VBA, the analogue system be based on ExcelVBA platform developments, occupy little space, to operation
Environment is easy to use without particular/special requirement, can be run on all computers equipped with Microsoft Office, is a real light weight
Change, many software collaboration analogue systems.
Brief description of the drawings
Fig. 1 is structural representation of the invention；
Fig. 2 is many software interface module workflow diagrams.
Specific embodiment
Embodiments of the invention are described in detail below in conjunction with accompanying drawing.
As shown in figure 1, being structural representation of the invention, the present invention is a kind of to be based on many software collaboration analogue systems of VBA,
Including simulation kernel module, result output module, report generation module, many software interface modules and operation interface：Operation interface
Simulation kernel module, result output module, report generation module and many software interface modules are called by versatile interface, as a result
Output module, report generation module and many software interface modules carry out command signal and are connected with simulation kernel module respectively.
Wherein simulation kernel module realizes specific emulation logic, specifically includes |input paramete pretreatment, network analysis, number
According to functions such as storages.|input paramete pretreatment is main to be realized checking the normalization of |input paramete, as met parameter lack of standardization if enter
Row bomp simultaneously provides corrigendum suggestion；Network analysis completes corresponding analytic function according to customer parameter, is emulation content
Key component；Data storage section is completed to user input parameter, system model, analysis process data and analysis intermediate data etc.
The storage of information, so as to calling for result output module and analysis report generation module.
As a result output module automatic running after the completion of network analysis, the module calls the data for having stored as needed,
Network analysis result is fed back with user in forms such as performance parameter, response curves.
The function of report generation module completion system analysis report generation, after the completion of network analysis, if user passes through
Operation interface have invoked analysis report systematic function, then the module automatic running.The input ginseng of module meeting calling system storage
The contents such as number, Controlling model, performance parameter, response curve and necessary process data according to regulation form, with word document
Form output analysis report common user reference.
Many software interface modules realize analogue system and net by browser plug-in and special data exchange agreement
The collaborative work of the third party software such as page, animation, word, PPT.Reference picture 2, system can possess hair by the interface with all
Send the third party software collaborative simulation of HTTP link function.3rd software only need to send hyperlink request according to regulation form, you can
The function of calling emulation content to provide.
Operation interface is the window of analogue system and user mutual, and analogue system provides VB forms, webpage, animation word
The interface sample of the forms such as document.Other third party softwares can design interface according to demand, then entered by many software interfaces
Row collaborative simulation.
The above, the only present invention preferably specific embodiment, but protection scope of the present invention is not limited thereto,
All any modification, equivalent and improvement made within the spirit and principles in the present invention etc., should be included in of the invention
Within protection domain.
Claims (6)
- It is 1. a kind of to be based on many software collaboration analogue systems of VBA, it is characterised in that：Including simulation kernel module, result output module, Report generation module, many software interface modules and operation interface：Operation interface by versatile interface call simulation kernel module, As a result output module, report generation module and many software interface modules, as a result output module, report generation module and many softwares connect Mouth mold block carries out command signal and is connected with simulation kernel module respectively.
- 2. according to claim 1 a kind of based on many software collaboration analogue systems of VBA, it is characterised in that：Described emulation The logical process of kernel module includes |input paramete pretreatment, network analysis and data storage:Parameter pretreatment is that input is joined Several normative inspections, bomp and amending advice are given to parameter lack of standardization；Network analysis is to input data and control Model carries out Treatment Analysis；Data storage is that the data that system is input into and is processed are stored.
- 3. according to claim 1 a kind of based on many software collaboration analogue systems of VBA, it is characterised in that：Described output Module automatic running after the analysis of simulation kernel module completion system, control is arrived in output in the form of performance parameter or response curve On interface.
- 4. according to claim 1 a kind of based on many software collaboration analogue systems of VBA, it is characterised in that：Described report Generation module need to call operation in operation interface, with word document form input-output data, Controlling model, performance parameter, sound Answer the analysis report of curve and necessary process data.
- 5. according to claim 1 a kind of based on many software collaboration analogue systems of VBA, it is characterised in that：Described is how soft Part interface module is, by browser plug-in or special data protocol, to be realized with the third party software with HTTP linkage functions Collaborative simulation.
- 6. according to claim 1 a kind of based on many software collaboration analogue systems of VBA, it is characterised in that：Described operation Interface includes the interface sample of the third party software with HTTP linkage functions.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611204548.3A CN106842982A (en) | 2016-12-23 | 2016-12-23 | One kind is based on many software collaboration analogue systems of VBA |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611204548.3A CN106842982A (en) | 2016-12-23 | 2016-12-23 | One kind is based on many software collaboration analogue systems of VBA |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106842982A true CN106842982A (en) | 2017-06-13 |
Family
ID=59135117
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611204548.3A Pending CN106842982A (en) | 2016-12-23 | 2016-12-23 | One kind is based on many software collaboration analogue systems of VBA |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106842982A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628594A (en) * | 2017-11-08 | 2018-10-09 | 北京世冠金洋科技发展有限公司 | A kind of graphical user interface design method of system simulation model |
| CN111027153A (en) * | 2019-12-12 | 2020-04-17 | 雷沃工程机械集团有限公司 | Excavator working device performance simulation calculation method based on VBA system |
| CN112257347A (en) * | 2020-11-02 | 2021-01-22 | 特变电工京津冀智能科技有限公司 | Simulation system of power transformation equipment |
| CN112328214A (en) * | 2020-10-16 | 2021-02-05 | 山东师范大学 | VBA software programming framework system, method and electronic equipment |
| CN112346719A (en) * | 2020-10-16 | 2021-02-09 | 山东师范大学 | Framework construction method for realizing asynchronous speed animation interactive program in VBA |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104008680A (en) * | 2014-05-13 | 2014-08-27 | 北京交通大学 | Train control system teaching simulation system based on EXCEL |
| CN105447224A (en) * | 2015-11-09 | 2016-03-30 | 苏州同元软控信息技术有限公司 | Modelica model simulation analysis report automatic generation method |
-
2016
- 2016-12-23 CN CN201611204548.3A patent/CN106842982A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104008680A (en) * | 2014-05-13 | 2014-08-27 | 北京交通大学 | Train control system teaching simulation system based on EXCEL |
| CN105447224A (en) * | 2015-11-09 | 2016-03-30 | 苏州同元软控信息技术有限公司 | Modelica model simulation analysis report automatic generation method |
Non-Patent Citations (4)
| Title |
|---|
| ADRIANA M.ALVAREZ，ET AL.: "ENHANCING SIMULATION MODELS FOR EMERGENCY ROOMS USING VBA", 《PROCEEDINGS OF THE I999 WINTER SIMULATION CONFERENCE》 * |
| 伍银波等: "EXCEL VBA在自控原理辅助教学中的应用", 《广东技术师范学院学报（自然科学）》 * |
| 卢守峰等: "集成VISSIM、Excel VBA和MATLAB的仿真平台研究", 《交通运输系统工程与信息》 * |
| 彭小平等: "VBA虚拟模型实现泵性能仿真实验", 《计算机与应用化学》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108628594A (en) * | 2017-11-08 | 2018-10-09 | 北京世冠金洋科技发展有限公司 | A kind of graphical user interface design method of system simulation model |
| CN111027153A (en) * | 2019-12-12 | 2020-04-17 | 雷沃工程机械集团有限公司 | Excavator working device performance simulation calculation method based on VBA system |
| CN111027153B (en) * | 2019-12-12 | 2024-03-01 | 雷沃重工集团有限公司 | Performance simulation calculation method for excavator working device based on VBA system |
| CN112328214A (en) * | 2020-10-16 | 2021-02-05 | 山东师范大学 | VBA software programming framework system, method and electronic equipment |
| CN112346719A (en) * | 2020-10-16 | 2021-02-09 | 山东师范大学 | Framework construction method for realizing asynchronous speed animation interactive program in VBA |
| CN112257347A (en) * | 2020-11-02 | 2021-01-22 | 特变电工京津冀智能科技有限公司 | Simulation system of power transformation equipment |
| CN112257347B (en) * | 2020-11-02 | 2023-09-08 | 特变电工京津冀智能科技有限公司 | Simulation system of power transformation equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106842982A (en) | One kind is based on many software collaboration analogue systems of VBA | |
| CN103513992A (en) | Universal development platform for education and entertainment robot application software | |
| CN104484163B (en) | A kind of isomery model conversion method based on unified Modeling environment | |
| EP3923556A1 (en) | Method and apparatus for testing dialogue platform, and storage medium | |
| CN108038241A (en) | Integrated WEB visual workflows method, apparatus, readable storage medium storing program for executing and system | |
| CN109447276A (en) | A kind of machine learning method, system, equipment and application method | |
| CN104503737B (en) | A kind of unified Modeling platform | |
| Baresi et al. | Trends and challenges for software engineering in the mobile domain | |
| CN109840267B (en) | Data ETL system and method | |
| US10044591B2 (en) | Two-way remote communication system for testing a client device program | |
| CN101356503B (en) | Data processing system and data processing method | |
| CN114201156A (en) | Access method, device, electronic equipment and computer storage medium | |
| CN103324776B (en) | Based on the generation method of the linear hybrid system invariant of abstract interpretation | |
| CN103164776A (en) | Medicine tracing system, medicine tracing method and process monitoring method | |
| CN109002663B (en) | Simulation method and simulation platform | |
| Staines | A comparison of software analysis and design methods for real time systems | |
| JP2001014400A (en) | Integrated operation system | |
| CN111240972A (en) | Model verification device based on source code | |
| CN110275609A (en) | A kind of parking brake interactive system, method and device based on VR | |
| CN109597611A (en) | Front end data flow control Components Development system, method, equipment and storage medium | |
| Tignor | System engineering and system dynamics models | |
| CN103019709A (en) | Interaction method of external application system and MSC.Patran based on Windows message mechanism | |
| CN112558962A (en) | Be-One-stop enterprise development platform | |
| Holmes | Models at Runtime@ Google | |
| CN201489515U (en) | Automatic model layer and view layer data mapping system applicable to AJAX framework |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170613 |
|
| RJ01 | Rejection of invention patent application after publication |