A Calculation Method of Group Financial Statements Based on Calculation Sequence Processing Front

A financial statement and calculation method technology, which is applied in the field of group financial statement calculation, can solve the problems of multiple resources and occupation, and achieve the effects of reducing calculation pressure, strong practicability, and prolonging effective use time

Active Publication Date: 2017-11-10
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF7 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] In the processing of financial statements, there are two types of access formulas: one is the business formula for obtaining data from the accounts, and the other is the report formula for obtaining data from other cells on the report. When the report formula is calculated, the formula between the formulas The processing of nested relationships takes up more resources

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
  • A Calculation Method of Group Financial Statements Based on Calculation Sequence Processing Front
  • A Calculation Method of Group Financial Statements Based on Calculation Sequence Processing Front

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0021] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments.

[0022] The present invention provides a group financial statement calculation method based on calculation sequence processing pre-processing, which changes the traditional method of processing nested relationship and arrangement order when calculating statement formulas into a method of processing nested relationship and arrangement order when defining statement formulas , can significantly disperse report calculation tasks, reasonably extend the effective utilization time of computing resources, reduce the pressure of month-end table calculation, and effectively improve report performance. The key steps of report calculation can be divided into two steps: 1. Identify the nested reference relationship of report formulas, and arrange the calculation order of the formulas; 2. Calculate the report formulas in order. By forwarding step 1 to the rep...

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 group financial statement calculating method based on advanced computation sequence processing. The method comprises the specific steps of processing the nest relation between a statement formula and other statement formulas when the statement formula is defined in a financial statement, calculating out a computation sequence of all statement formulas, storing the computation sequence in the a database as attributes of the statement formulas, taking out all formulas according to a computation range when the financial statement is calculated, ranking according to the stored computation sequence and calculating the statement formulas batch by batch. Compared with the prior art, the group financial statement calculating method based on the advanced computation sequence processing can obviously disperse statement calculating tasks, reasonably prolongs the effective utilizing time of computation resources, reduces the statement computing burden in the end of month, effectively improves statement performance and is high in practicability.

Description

technical field [0001] The invention relates to the technical field of computer software, in particular to a method for calculating group financial statements with strong practicability and preprocessing based on calculation sequence. Background technique [0002] The business time distribution of the financial statements of the group companies is uneven, and they are basically not done at ordinary times, and the statements are centralized at the end of the month. High concurrency leads to low performance of the reporting system. It is very important to be able to effectively decompose data processing tasks into multiple tasks, move pre-emptive tasks to periods when computing resources are idle, and improve the overall utilization of computing resources. [0003] In the processing of financial statements, there are two types of access formulas: one is the business formula for obtaining data from the accounts, and the other is the report formula for obtaining data from other ...

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): G06F9/44G06Q10/10
Inventor 王相成
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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