Configurable cost distribution calculation method based on open source technology

A cost apportionment and calculation method technology, applied in the field of computer programs, can solve problems such as low work efficiency, achieve the effects of improving efficiency, using convenience, and improving calculation flexibility

Inactive Publication Date: 2015-01-07
中国南方航空股份有限公司 +1
View PDF4 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is to propose a configurable cost allocation calculation method based on open source technology, which can solve the problem of low work efficiency

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
  • Configurable cost distribution calculation method based on open source technology
  • Configurable cost distribution calculation method based on open source technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] In the following, the present invention will be further described in conjunction with the drawings and specific embodiments.

[0018] Such as figure 1 As shown, a configurable cost allocation calculation method based on open source technology, which includes the following steps:

[0019] Step S1. Synchronize all the fields in the data table of the specified database, and form corresponding metadata, the metadata includes at least one calculation parameter field and one calculation result field.

[0020] For example, add a data table New_Data to the database, and the fields of New_Data are shown in the following table.

[0021] column name

type of data

Null values ​​are allowed

factor_1

decimal(18,4)

√

factor_2

decimal(18,4)

√

result

decimal(18,4)

√

[0022] Then, the fields in the data table New_Data are synchronized to obtain corresponding metadata, and the data structure of the metadata is shown 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

A configurable cost distribution calculation method based on an open source technology includes the steps: synchronizing all fields in a data table of a designated database to form corresponding metadata including at least one calculating parameter field and at least one calculating result field; forming factor data according to the calculating parameter fields and the calculating result fields of the metadata; receiving configuration operations of a user, and operating calculating factors and result factors according to a calculating rule; receiving data assembly operations of an administrator, and assembling the calculating rule and the data table through an SQL (structured query language) to form a calculating model. The factor data include the calculating factors corresponding to the calculating parameter fields and the result factors corresponding to the calculating result fields. Data in the database are mapped into the factor data, so that the user does not need to contact with the bottom database and the obscure fields and can freely configure the calculating rule of the factor data, and calculating flexibility is improved.

Description

technical field [0001] The present invention relates to computer programs. Background technique [0002] At present, the operating costs of enterprises are calculated by entering data into EXCEL tables. First of all, data entry is done manually, which is inefficient and error-prone. Second, after data entry, it is necessary to write different calculation formulas to calculate the entered data according to different business types, which will inevitably consume a lot of manpower and time. Moreover, after the calculation formula is written and the data is solidified, the configuration is not flexible, such as If more business data needs to be calculated, other data can only be manually entered into EXCEL, and then calculation formulas are written, and then cost allocation calculations are performed based on data of different business types. Based on the above two reasons, the current cost allocation calculation efficiency is low. Contents of the invention [0003] The pur...

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): G06F17/30
CPCG06F16/30
Inventor 王轩钟盛翔
Owner 中国南方航空股份有限公司
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