Complex mathematical model computing method and system using combination of SAP and Microsoft Office

A mathematical model and mathematical calculation technology, applied in complex mathematical operations, program control devices, etc., can solve problems such as high cost, time-consuming, expensive, etc., and achieve the effect of improving efficiency and reducing costs

Active Publication Date: 2015-09-30
STATE GRID SHANDONG ELECTRIC POWER +1
View PDF2 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

According to the development function of the current SAP system, it is difficult to realize this complex mathematical model calculation function
According to the normal solution, it is necessary to purchase expensive additional specialized software for calculation
Using another mathematical model calculation software is not only costly and time-consuming, but on the other hand, the basic data of the new software calculation needs to be imported from SAP, which has a large amount of data, and there are risks in data security, and the processing is relatively cumbersome
It brings great risks to the implementation goals and implementation progress of the project

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
  • Complex mathematical model computing method and system using combination of SAP and Microsoft Office

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] The present invention is described in detail below in conjunction with accompanying drawing:

[0029] like figure 1 As shown, in order to make the present invention more comprehensible, an implementation example of a calculation model is described in detail as follows with accompanying drawings.

[0030] The present invention provides a kind of method based on SAP platform to realize complex mathematical calculation model, and its concrete steps are:

[0031] (1). The SAP side needs to participate in the preparation of basic data for calculation. The SAP system filters and extracts the corresponding data in the database according to the instructions entered by the end user, such as the material to be forecasted, the year, the quarter, and the type of material.

[0032] Specifically: the end user needs to forecast and understand the subsequent demand of a certain material in the SAP system in the current year, and enter the material code to be forecasted and the time i...

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 complex mathematical model computing method and system using combination of SAP (systems, applications and products in data processing) and Microsoft Office. The method includes the steps: an SAP system screens and extracts corresponding data in a database according to a command acquired by a data acquisition terminal; the SAP system sorts out the data and processes the data to a format required by computing of a mathematical calculating model; a macro of the mathematical calculating model is set in a VBA (visual basic for applications) code of the Microsoft Office; the SAP system reads the data of the specified position and outputs them. By combining the SAP with EXCEL in the Microsoft Office through a DOI (digital object unique identifier) technology, the defect that the existing SAP system is poor in complex mathematical model computing is well solved; thus, the problems are solved at the premise of lowering cost and improving efficiency.

Description

technical field [0001] The invention relates to a method and a system for realizing complex mathematical model operations by combining SAP with Microsoft Office. Background technique [0002] In the implementation process of a certain project of an enterprise, it is necessary to analyze and organize according to the purchase history list of the enterprise for many years, according to different material types and different time periods, and through different mathematical calculation models (multiple linear) according to different material properties and characteristics Regression calculation model and seasonal trend regression calculation model) to calculate the expected material purchase volume in the current year or the second year. According to the development function of the current SAP system, it is difficult to realize this complex mathematical model calculation function. According to the normal solution, it is necessary to purchase expensive additional special calcula...

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 Applications(China)
IPC IPC(8): G06F9/44G06F17/10
Inventor 孙宏志尹明杨慧颖王玉家曲晓白石鑫磊王茜严文涛严莉苏琦张勇刘润发王赛邢宏伟张建辉郑一王武贵
Owner STATE GRID SHANDONG ELECTRIC POWER
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap