Enterprise performance automatic evaluation method and system based on ExcelVBA technology

An evaluation method, excel technology, applied in other database browsing/visualization, other database retrieval, data processing applications, etc., can solve the problems of lack of function development, and achieve the effect of easy promotion, saving time for checking data, and simple operation

Pending Publication Date: 2021-04-16
DALIAN MARITIME UNIVERSITY
View PDF7 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the function development based on VBA technology is relatively lacking at present.

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
  • Enterprise performance automatic evaluation method and system based on ExcelVBA technology
  • Enterprise performance automatic evaluation method and system based on ExcelVBA technology
  • Enterprise performance automatic evaluation method and system based on ExcelVBA technology

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0048] In order to enable those skilled in the art to better understand the solutions of the present invention, the following will clearly and completely describe the technical solutions in the embodiments of the present invention in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only It is an embodiment of a part of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts shall fall within the protection scope of the present invention.

[0049] It should be noted that the terms "first" and "second" in the description and claims of the present invention and the above drawings are used to distinguish similar objects, but not necessarily used to describe a specific sequence or sequence. It is to be understood that the data so used are interchangeable under appropriate ...

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 an enterprise performance automatic evaluation method based on ExcelVBA technology. The method comprises the following steps: establishing a performance evaluation index system; reading the original data stored in the plurality of Excel documents into a performance evaluation index system Excel document through a data reading module; processing the value of each index by adopting a min-max standardization method through a data processing module, and carrying out information aggregation through an evidence reasoning method to obtain the value of the total index, namely an enterprise performance evaluation result; through a data checking and marking module, checking the read and calculated data and marking abnormal values to prompt a user to pay attention; and displaying an evaluation result and a month-by-month/quarter/year change trend in the form of a broken line graph in the total index and the shell page of each index through a graphic expression and visualization module.

Description

technical field [0001] The present invention relates to the technical field of computer applications, in particular, to an automatic evaluation method and system for enterprise performance based on ExcelVBA technology. Background technique [0002] The business data of many enterprises are stored, processed, and displayed in the form of Excel documents. Due to different sources, different expression forms, and different purposes, various data and tables are often incompatible, resulting in a large amount of duplication of data extraction and processing in the performance evaluation work. Work. The traditional method is manual operation, which needs to extract data from different Excel documents separately, which has the problems of low efficiency and high error rate. As a powerful built-in programming language for Excel, VBA allows users to insert control buttons, custom functions and commands in Excel. It can better solve the problem of extracting and processing a large am...

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): G06Q10/06G06F16/904G06F16/906G06F40/18
Inventor 谢新连赵瑞嘉牛东翔黄帅于文璋张波菲
Owner DALIAN MARITIME UNIVERSITY
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