Comprehensive budgeting method based on EXCEL

A budgetary and comprehensive technology, applied in computing, special data processing applications, instruments, etc., can solve problems such as complex budgeting, impact on customer experience, impact on loading performance, etc., to improve computing performance, enhance user experience, and reduce implementation effect of difficulty

Inactive Publication Date: 2018-10-09
SHANDONG INSPUR GENESOFT INFORMATION TECH CO LTD
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] Comprehensive budget preparation has certain complexity. In the existing comprehensive budget product system, the preparation module includes nearly 30 functions such as document, save, calculation, inspection, summary, and comment, as well as right-click data composition, joint query details, addition and deletion of rows , drop-down selection and other operation methods, and because the report preparation control integrates the open source GSCELL control, which is developed based on the old version of office, many operation methods are different from the existing version of office, resulting in the actual During the preparation process, many methods of daily use of EXCEL cannot be used in the budget preparation process, resulting in many usability problems
Moreover, due to the limitations of GSCELL itself, when users compile large reports, the loading performance will also be greatly affected
With the continuous improvement of customer informatization level, users' requirements for the usability and performance of products are also constantly improving. According to the current status of products, it will greatly affect customer experience

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
  • Comprehensive budgeting method based on EXCEL
  • Comprehensive budgeting method based on EXCEL
  • Comprehensive budgeting method based on EXCEL

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0023] Below according to accompanying drawing of description, in conjunction with specific embodiment, content of the present invention is elaborated in more detail:

[0024] 1. Server-side cache structure:

[0025] 1) Cache in EXCEL format: budget preparation activities are used as cache group folders, and folder names are activity internal codes (such as HD01 and HD02). In each folder, different EXCEL cache forms are established according to reports, and report internal codes are used (such as BB01 and BB02) are used as the name of the cached form. In each form, different sheet pages are established according to different organizations, and the internal code of the organization (such as ZZ01 and ZZ02) is used as the name of the sheet page. In each sheet, the {A1:B20} area is used for recording EXCEL format information and mapping with database cache information, not as a compilation area.

[0026] 2) Database information cache: Each budget preparation report is divided int...

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 provides a comprehensive budgeting method based on an EXCEL. In the method, a GS platform login simulating plug-in is integrated in the EXCEL, a system automatically loads the organization and report needing to be compiled by a current user according to user login information and corresponding authority after the user logs into the plug-in through a GS account to form a compiling task list, and the user downloads a corresponding compiling task according to needs. Compared with GS comprehensive budgeting, the implementation difficulty is reduced, the compiling performance and product usability are improved, and user experience is enhanced.

Description

technical field [0001] The invention relates to the technical field of computer budgeting, in particular to an excel-based comprehensive budgeting method. Background technique [0002] Comprehensive budget preparation has certain complexity. In the existing comprehensive budget product system, the preparation module includes nearly 30 functions such as document, save, calculation, inspection, summary, and comment, as well as right-click data composition, joint query details, addition and deletion of rows , drop-down selection and other operation methods, and because the report preparation control integrates the open source GSCELL control, which is developed based on the old version of office, many operation methods are different from the existing version of office, resulting in the actual During the preparation process, many methods of daily use of EXCEL cannot be used in the budget preparation process, resulting in many usability problems. Moreover, due to the limitations ...

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
Inventor 武鹏
Owner SHANDONG INSPUR GENESOFT 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

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