Business evaluation method and device based on macro language, storage medium and computer

Abstract

The invention discloses a business evaluation method and device based on a macro language, a storage medium and a computer. The method comprises the steps that an applicable scene of business evaluation is determined in response to selection operation, an evaluation table template corresponding to the applicable scene is determined, the evaluation table template comprises a plurality of evaluation field tables, and each evaluation field table corresponds to one evaluation field; each evaluation field table comprises evaluation items, scoring rules of the evaluation items and evaluation input cells; in response to the evaluation report generation operation, obtaining input information input into an evaluation input cell corresponding to the evaluation item, and determining a rating result of the evaluation item based on the input information and a rating rule corresponding to the evaluation item; and based on the rating result of the evaluation item corresponding to each evaluation field, determining a scoring result of the evaluation field, and based on the scoring result of each evaluation field and the rating result of each evaluation item, generating a business evaluation report file. According to the method, the service evaluation efficiency can be improved.

Description

Technical Field

[0001] This invention relates to the field of information technology, and in particular to a business evaluation method, apparatus, storage medium, and computer based on macro language. Background Technology

[0002] In the context of digital transformation, enterprises and organizations need to build indicator systems and conduct digital measurements based on their own development goals and business characteristics. This transforms complex business processes into quantifiable evaluation results to support quantitative management and data-driven decision-making. To achieve these goals, it is necessary to conduct business capability assessments of various systems within the enterprise. Based on the strengths and weaknesses of each business, rating information for each business should be determined to provide direction for improvement in subsequent production activities.

[0003] Current business assessment methods require assessors to use spreadsheet software such as Excel to list the assessment items included in the assessment system, fill in the corresponding business information for each assessment item, and manually analyze and process the data contained in the business information to obtain the assessment results for each assessment item and produce a business assessment report to complete the assessment work.

[0004] However, existing business assessment methods lack automated data analysis and processing capabilities, resulting in a high degree of reliance on manual labor for assessment implementation. This leads to a heavy workload for assessors, reduces their implementation efficiency, and consequently makes existing business assessment methods less efficient and unsuitable for large-scale assessment applications. Summary of the Invention

[0005] In view of this, this application provides a business evaluation method, apparatus, storage medium and computer based on macro language, the main purpose of which is to solve the technical problem of low evaluation efficiency in existing business evaluation methods.

[0006] According to a first aspect of the present invention, a macro-language-based business evaluation method is provided, applied to a computer, the method comprising:

[0007] In response to the selection of a business assessment scenario, the system determines the assessment scenario information and the corresponding assessment form template, and displays the assessment form template on the computer's display interface.

[0008] The evaluation form template includes multiple evaluation domain forms, each evaluation domain form corresponds to an evaluation domain, and each evaluation domain form includes at least one evaluation item, a scoring rule corresponding to the evaluation item, and an evaluation input cell.

[0009] In response to the evaluation report generation operation, the user input information entered into the evaluation input cell corresponding to the evaluation item is obtained, and the rating result of the evaluation item is determined based on the user input information and the scoring rules corresponding to the evaluation item;

[0010] Based on the rating results of the evaluation items corresponding to each evaluation area, the score results of the evaluation area are determined, and a business evaluation report file is generated based on the score results of each evaluation area and the rating results of each evaluation item.

[0011] In an optional embodiment, the display interface displays multiple scenario selection labels and a basic information input box; the step of determining the assessment scenario information of the object to be assessed in response to the selection operation of the business assessment scenario includes: determining the assessment basic information in the scenario selection label and the basic information input box corresponding to the selection operation, and determining the assessment scenario information based on the scenario selection label and the assessment basic information; the step of determining the assessment table template corresponding to the assessment scenario information includes: determining all preset assessment attributes corresponding to the assessment scenario information, and comparing each preset assessment attribute with a preset full set of assessment system indicators, wherein the full set of assessment system indicators includes multiple preset assessment domain tables and preset attribute information corresponding to each preset assessment domain table; determining preset attribute information that is the same as the preset assessment attribute in the full set of assessment system indicators, and determining the preset assessment domain table corresponding to the preset attribute information as the target assessment domain table; determining the target assessment domain table corresponding to each preset assessment attribute, and generating the assessment table template based on each target assessment domain table.

[0012] In an optional embodiment, the scoring rules include multiple numerical ranges, each numerical range corresponding to a preset evaluation level; determining the rating result of the evaluation item based on the user input information and the scoring rules corresponding to the evaluation item includes: determining the numerical range corresponding to the user input information, and determining the preset evaluation level corresponding to the numerical range as the rating result.

[0013] In an optional embodiment, the evaluation domain table further records at least one evaluation subdomain, each evaluation subdomain corresponding to at least one evaluation item; each evaluation item corresponds to a preset benchmark score, and each rating result corresponds to a preset scoring coefficient; determining the rating result of the evaluation domain based on the rating result of each evaluation item corresponding to the evaluation domain includes: determining the preset benchmark score corresponding to the evaluation item and the preset scoring coefficient corresponding to the rating result of the evaluation item, and determining the deduction value of the evaluation item based on the preset benchmark score and the preset scoring coefficient; determining the deduction values ​​of all evaluation items corresponding to the evaluation subdomain, and adding the deduction values ​​of each evaluation item to obtain the subdomain deduction value, and determining the evaluation subdomain capability score of the evaluation subdomain based on the subdomain deduction value; and performing a weighted summation of the evaluation subdomain capability scores of all evaluation subdomains corresponding to the evaluation domain to obtain the rating result of the evaluation domain.

[0014] In an optional embodiment, generating a business assessment report file for the object to be assessed based on the scoring results of each assessment domain and the rating results of each assessment item includes: obtaining a preset business assessment template; performing a weighted summation of the scoring results corresponding to each assessment domain to obtain an overall capability score, and setting the overall capability score and the scoring results of each assessment domain in a first position of the business assessment template; determining the assessment subdomain capability score of each assessment subdomain corresponding to all assessment domains, and arranging all assessment subdomain capability scores in ascending order to obtain an assessment subdomain queue; selecting the assessment subdomain ranked first in the assessment subdomain queue as the capability shortest. The business assessment template is divided into three parts: a risk assessment subdomain, a risk assessment area, a risk assessment subdomain, a risk assessment result, and a risk assessment report file. The assessment subdomains are then placed in the second position of the business assessment template. The rating result for each assessment item corresponding to all assessment areas is determined, and a preset risk capability level is obtained for each assessment item. It is then determined whether the rating result of the assessment item is the same as the preset risk capability level. If the rating result of the assessment item is the same as the preset risk capability level, the assessment item is identified as a risk assessment item, and the attention level of the risk assessment item is determined as a key attention level. Finally, the assessment area, the assessment subdomain, the rating result, and the attention level corresponding to the risk assessment item are placed in the third position of the business assessment template.

[0015] In an optional embodiment, the step of obtaining user input information input into the evaluation input cell corresponding to the evaluation item in response to the evaluation report generation operation includes: obtaining the evaluation form template in response to the evaluation report generation operation, and determining whether each evaluation input cell in the evaluation form template contains the user input information; issuing an alarm message when any evaluation input cell does not contain the user input information; and collecting the user input information input into the evaluation input cell corresponding to the evaluation item in the evaluation form template when each evaluation input cell in the evaluation form template contains the user input information.

[0016] In an optional embodiment, after generating the business assessment report file of the object to be assessed based on the scoring results of each of the assessment areas and the rating results of each of the assessment items, the method further includes: in response to a file storage operation, storing the assessment form template and the business assessment report file.

[0017] According to a second aspect of the present invention, a macro-language-based business evaluation apparatus is provided, the apparatus comprising:

[0018] An operation response module is used to respond to the selection operation of a business evaluation scenario, determine the evaluation scenario information of the business evaluation, determine the evaluation form template corresponding to the evaluation scenario information, and display the evaluation form template on the display interface of the computer. The evaluation form template includes multiple evaluation domain tables, each evaluation domain table corresponds to an evaluation domain, and each evaluation domain table includes at least one evaluation item, a scoring rule corresponding to the evaluation item, and an evaluation input cell.

[0019] The rating calculation module is used to respond to the evaluation report generation operation, obtain user input information input into the evaluation input cell corresponding to the evaluation item, and determine the rating result of the evaluation item based on the user input information and the scoring rules corresponding to the evaluation item;

[0020] The results output module is used to determine the score result of the assessment field based on the rating result of the assessment item corresponding to each assessment field, and to generate a business assessment report file based on the score result of each assessment field and the rating result of each assessment item.

[0021] According to a third aspect of the present invention, a storage medium is provided having a computer program stored thereon, which, when executed by a processor, implements the above-described macro-language-based business evaluation method.

[0022] According to a fourth aspect of the present invention, a computer is provided, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the above-described macro-language-based business evaluation method.

[0023] This invention provides a business evaluation method, apparatus, storage medium, and computer based on macro language. First, it receives a selection operation performed by a user on the computer, determines the evaluation scenario information of the selected business evaluation, and automatically generates an evaluation form template corresponding to the evaluation scenario information. The evaluation form template consists of multiple evaluation domain tables, each corresponding to an evaluation domain. Each evaluation domain table includes at least one evaluation item, a scoring rule corresponding to the evaluation item, and an evaluation input cell corresponding to the evaluation item, allowing the user to input user information, i.e., business information, into the evaluation input cell. Then, in response to the user's evaluation report generation operation on the computer, it obtains the user input information entered into the evaluation input cell corresponding to each evaluation item in the template, and determines the rating result of the evaluation item based on the user input information and the scoring rule corresponding to the evaluation item, thus obtaining the rating result for each evaluation item in the evaluation form template. Finally, based on the rating results of the evaluation items corresponding to each evaluation area, the rating results of the evaluation items belonging to the same evaluation area are calculated to determine the score result of the evaluation area. Based on the score results of each evaluation area and the rating results of each evaluation item contained in the evaluation form template, a business evaluation report file is generated to complete the business evaluation work. The technical solution provided in this application can generate a suitable evaluation form template according to the user's selection, allowing the user to input the required business information in the evaluation input cells of the template. It can also collect the information entered by the user in the evaluation input cells based on the user's evaluation report generation operation and complete the business evaluation work with one click based on preset calculation rules. Compared with the existing method of manually calculating business information and generating business evaluation report files entirely based on user input, this method can speed up the business evaluation process, quickly complete a large amount of evaluation work, and thus significantly enhance the efficiency of business evaluation.

[0024] The above description is only an overview of the technical solution of this application. In order to better understand the technical means of this application and to implement it in accordance with the contents of the specification, and to make the above and other objects, features and advantages of this application more obvious and understandable, the following are specific embodiments of this application. Attached Figure Description

[0025] The accompanying drawings, which are included to provide a further understanding of the invention and form part of this application, illustrate exemplary embodiments of the invention and, together with their description, serve to explain the invention and do not constitute an undue limitation thereof. In the drawings:

[0026] Figure 1 The diagram illustrates a flowchart of a macro-language-based business evaluation method provided by an embodiment of the present invention.

[0027] Figure 2 This diagram illustrates a form of an evaluation homepage provided by an embodiment of the present invention;

[0028] Figure 3 This diagram illustrates a business evaluation template provided by an embodiment of the present invention.

[0029] Figure 4 This diagram illustrates the structure of a macro-language-based business evaluation device according to an embodiment of the present invention.

[0030] Figure 5 The diagram shows a schematic of the structure of a computer that executes a macro-language-based business evaluation method according to an embodiment of the present invention. Detailed Implementation

[0031] The present invention will be described in detail below with reference to the accompanying drawings and embodiments. It should be noted that, unless otherwise specified, the embodiments and features described in the present application can be combined with each other.

[0032] Currently, existing business assessment methods lack automated data analysis and processing capabilities, resulting in a high degree of reliance on manual labor for assessment implementation. This leads to a heavy workload for assessors, low implementation efficiency, and susceptibility to human error, reducing the accuracy of the assessment. Consequently, existing business assessment methods are inefficient in conducting business assessments and are difficult to apply to large-scale assessment applications.

[0033] To address the above problems, in one embodiment, such as Figure 1 As shown, a business evaluation method based on macro language is provided. Taking the application of this method to a computer as an example, the evaluation criteria and quantitative scoring rules of this macro language-based business evaluation method can be embedded into the spreadsheet software through the automation processing module of the VBA (Visual Basic for Applications) program. The steps of the method provided in this application are implemented by designing an automated evaluation tool controlled by a VBA program.

[0034] Furthermore, the macro-language-based business evaluation method provided in this application includes the following steps:

[0035] 101. In response to the selection operation of the business evaluation scenario, determine the evaluation scenario information of the object to be evaluated, determine the evaluation form template corresponding to the evaluation scenario information, and display the evaluation form template on the display interface of the computer.

[0036] The evaluation form template includes multiple evaluation domain forms, each of which corresponds to an evaluation domain. Each evaluation domain form includes at least one evaluation item under that evaluation domain, as well as scoring rules and evaluation input cells corresponding to each evaluation item.

[0037] Here, the evaluation item can be a business metric used to evaluate the object being evaluated. As an example, an evaluation form template can be shown in Table 1:

[0038]

[0039] Table 1

[0040] The assessment areas can include "Operational Quality" and "Maintainability". The "Operational Quality" area includes assessment items such as "Time Off-Duty", "Planned Downtime", and "Number of Incidents". The multi-row table containing the assessment items "Time Off-Duty", "Planned Downtime", and "Number of Alarm Events" can be used as the assessment area table for the "Operational Quality" area. Similarly, the multi-row table containing the assessment items "Standard Emergency Response Capability" and "Emergency Plan Automation Rate" can be used as the assessment area table for the "Maintainability" area. The assessment area tables for "Operational Quality" and "Maintainability" can be combined to form an assessment table template. Furthermore, each evaluation item in the evaluation form template corresponds to an evaluation rule and an evaluation input cell. The evaluation rule and evaluation input cell for each evaluation item are located in the same row as that evaluation item. Additionally, the evaluation rules pre-record the rules for calculating the rating result of the evaluation item based on business information. Users can input the business information corresponding to the evaluation item into the evaluation input cell. For example, entering "6" in the evaluation input cell corresponding to the "fault operation time" evaluation item represents a fault operation time of 6 minutes, allowing the computer to calculate the rating result, i.e., the "initial level" rating, based on the evaluation rules.

[0041] Furthermore, the computer can be a mobile terminal, personal computer, or server, etc., equipped with a human-computer interaction interface to display information and receive user input and operations. Specifically, the computer can display the evaluation homepage, i.e., the interactive interface, on its monitor. Figure 2As shown, the evaluation homepage 100 is an interface generated by a VBA program executing a macro-based business evaluation method. It includes a basic information input box 110 and multiple scenario selection labels 120. Each scenario selection label 120 can be a clickable button on the interface, and each label corresponds to specific scenario information. Specifically, the scenario selection labels 120 may include a "Production System Evaluation" label, a "New System Evaluation" label, a "Import Historical Evaluation Data" label, and a "Evaluation Report Generation" label. The "Production System Evaluation" and "New System Evaluation" labels represent the production system scenario and the new system scenario, respectively, that require evaluation. Furthermore, the basic information input box 110 may include a system Chinese name input area, a system level input area, a development department / domain input area, and an operations and maintenance department / domain input area, allowing users to input the system's Chinese name, system level, development department / domain, and operations and maintenance department / domain of the object to be evaluated.

[0042] In actual operation, users can enter basic information in the basic information input box 110 and, depending on the applicable scenario to be evaluated, click the "Production System Evaluation" or "New System Evaluation" tab to indicate whether to evaluate the production system or the newly created system. This allows the computer executing this method to determine which preset evaluation form template to select based on the basic information and the scenario information of the clicked tab. When selecting the evaluation form template, a prompt will appear on the display asking whether to delete existing data and regenerate the evaluation form. After confirming the deletion, the user will be prompted with further explanations of the evaluation items. Once the user confirms the explanations, the evaluation form template will be generated and displayed on the interface for subsequent evaluation processes.

[0043] In addition, the data type and range of user input information that can be entered into the evaluation input cell can be preset; for enumerable rating results, the evaluation data can be defined as a "sequence" type and the evaluation result can be selected through a drop-down list; for numerical rating results, the numerical type and valid range of user input information can be set.

[0044] 102. In response to the evaluation report generation operation, obtain the user input information entered into the evaluation input cell corresponding to the evaluation item, and determine the rating result of the evaluation item based on the user input information and the scoring rules corresponding to the evaluation item.

[0045] Specifically, after entering user information in the evaluation input cells of the evaluation form template, the user can click the "Evaluation Report Generation" tab on the evaluation homepage to generate an evaluation report. Upon receiving the evaluation report generation operation, the computer executing the method of this embodiment obtains the user input information from the evaluation input cells of each evaluation item in the evaluation form template, and calculates the rating result of the evaluation item based on the scoring rules of the evaluation item. Here, for each evaluation item in the evaluation form template, the scoring rules corresponding to that evaluation item and the user input information from the evaluation input cells corresponding to that evaluation item can be obtained, and the rating result of the evaluation item can be obtained based on the scoring rules.

[0046] In addition, when a user clicks the "Generate Assessment Report" tab on the assessment homepage, the system can check the data integrity of each assessment indicator in the assessment form template item by item to determine if there is any missing data. If there is missing data, the system will determine that the template does not meet the conditions for generating an assessment report and will display an error message.

[0047] 103. Based on the rating results of each evaluation item corresponding to the evaluation domain, determine the score result of the evaluation domain, and based on the score results of each evaluation domain and the rating results of each evaluation item, generate a business evaluation report file for the object to be evaluated.

[0048] Specifically, for each assessment area, the score result of that assessment area can be calculated from the rating result of each assessment item in that assessment area, thus obtaining the score result of each assessment area; furthermore, based on the score result of each assessment area and the rating result of each assessment item contained in the assessment form template, a business assessment report file of the object to be assessed is generated, thus completing the business assessment of the object to be assessed.

[0049] The macro-language-based business evaluation method provided in this embodiment can generate a suitable evaluation form template according to the user's selection. The user can then input the required business information in the evaluation input cells of the template. Based on the user's evaluation report generation operation, the method can collect the information input by the user in the evaluation input cells through a VBA program and complete the business evaluation work with one click based on preset calculation rules. Compared with the existing method of manually calculating business information and generating business evaluation report files, this method can speed up the business evaluation process, quickly complete a large number of evaluation tasks, and thus significantly improve the efficiency of business evaluation.

[0050] In an optional embodiment, the method of obtaining user input information entered into the evaluation input cell corresponding to the evaluation item in response to the evaluation report generation operation includes:

[0051] First, in response to the evaluation report generation operation, the computer obtains the evaluation form template and determines whether each evaluation input cell in the evaluation form template contains the user input information. Specifically, after the user enters user input information into the evaluation input cell of each evaluation area table in the evaluation form template, they can click the "Evaluation Report Generation" tab on the evaluation homepage on the computer interface to generate the evaluation report. At this time, in response to the evaluation report generation operation, the computer obtains the evaluation form template with the user input information and uses a VBA program to check the integrity of the data in each evaluation input cell of the evaluation form template item by item to determine whether the user input information has been entered into each evaluation input cell.

[0052] Then, if any of the evaluation input cells does not contain the user input information, an alarm message is issued; specifically, if it is determined that any evaluation input cell has not been filled with user input information, an error message indicating that the evaluation table information is incomplete is displayed on the display interface.

[0053] Furthermore, when each evaluation input cell in the evaluation form template contains the user input information, the user input information entered into the evaluation input cell corresponding to the evaluation item is collected in the evaluation form template. Specifically, when user input information is entered into each evaluation input cell in the evaluation form template, the evaluation form template determines the evaluation input cell corresponding to each evaluation item, and collects the information in the evaluation input cell and maps it to the evaluation item for subsequent steps.

[0054] The technical solution provided in this application can perform a completeness check on the evaluation form template filled in by the user, determine whether there is any missing information in the evaluation form template, and issue a prompt message in a timely manner when there is missing information, so that the user can complete the evaluation form template, thereby improving the accuracy of business evaluation.

[0055] In an optional embodiment, the computer's display interface shows a basic information input box and multiple scene selection labels, each of which corresponds to preset identification information. Here, the computer can be programmed to display an evaluation homepage, along with the scene selection labels and the basic information input box on the evaluation homepage.

[0056] Furthermore, in response to the selection operation of the business evaluation scenario, determining the evaluation scenario information of the object to be evaluated includes: determining the scenario selection label corresponding to the selection operation, and the evaluation basic information in the basic information input box, and determining the evaluation scenario information based on the scenario selection label and the evaluation basic information.

[0057] Furthermore, when a user selects a business evaluation scenario, the system can verify the completeness of the basic evaluation information in the basic information input box to ensure that the basic evaluation information meets the subsequent evaluation implementation conditions. If the basic evaluation information does not meet the evaluation implementation conditions, an error message will be displayed. Specifically, the system can identify the clicked scenario selection label, determine the corresponding identifier information, and retrieve the basic evaluation information entered in the basic information input box. Then, the basic evaluation information and identifier information are compared with a preset applicable scenario lookup table to determine the preset scenario information that both the basic evaluation information and the identifier information correspond to. Here, the applicable scenario lookup table includes multiple preset scenario information entries, each with one preset information entry and one preset identifier information entry. The system can compare the basic evaluation information and identifier information with the preset information and preset identifier information of each preset scenario entry in the applicable scenario lookup table. If the preset information and preset identifier information corresponding to a certain preset scenario information entry are identical to the basic evaluation information and the identifier information, then that preset scenario information is determined as the evaluation scenario information. Each preset scenario information entry corresponds to at least one preset evaluation attribute.

[0058] Furthermore, determining the evaluation form template corresponding to the evaluation scenario information includes:

[0059] First, all preset evaluation attributes corresponding to the evaluation scenario information are determined, and each preset evaluation attribute is compared with the full set of preset evaluation system indicators. Here, the preset evaluation attributes corresponding to the preset scenario information that is determined to be evaluation scenario information can be identified as the preset evaluation attributes of the evaluation scenario information.

[0060] The evaluation system's full set of indicators includes multiple preset evaluation domain tables and preset attribute information corresponding to each preset evaluation domain table. Specifically, all preset attribute information in the full set of indicators can be determined, and these preset attribute information are compared with all preset evaluation attributes corresponding to the evaluation scenario information. Furthermore, each preset evaluation domain table includes multiple rows, each row pre-set with one evaluation item, and the row containing the evaluation item also includes the corresponding scoring rules and evaluation input cells.

[0061] Then, preset attribute information that is identical to the preset evaluation attribute is identified in the full set of indicators of the evaluation system, and the preset evaluation domain table corresponding to the preset attribute information is determined as the target evaluation domain table. Specifically, for each preset evaluation attribute corresponding to the evaluation scenario information, preset attribute information identical to that preset evaluation attribute can be screened in the full set of indicators of the evaluation system. When it is determined that there is a preset attribute information identical to the preset evaluation attribute, the preset evaluation domain table corresponding to that preset attribute information is determined as the target evaluation domain table.

[0062] Finally, the target evaluation domain table corresponding to each preset evaluation attribute is determined, and the evaluation table template is generated based on each target evaluation domain table. Specifically, the target evaluation domain tables corresponding to each preset evaluation attribute can be concatenated to obtain the evaluation table template.

[0063] Furthermore, filtering attributes can be set for each evaluation item under the evaluation domain. These attributes indicate whether the evaluation item is applicable to a scenario selection label. For example, scenario selection labels include "Production System Evaluation" and "New System Evaluation." An evaluation item is "Fault Operation Time." The filtering attribute for "Fault Operation Time" indicates that this evaluation item is not applicable to the "New System Evaluation" label. If a user clicks the "New System Evaluation" label when selecting a business evaluation scenario, the "Fault Operation Time" evaluation item will be hidden in the subsequently generated evaluation form template. Based on this, evaluation items that need to be retained can be filtered in the evaluation form template, and unnecessary evaluation items can be deleted to streamline the content displayed in the user evaluation form, allowing the program to set unnecessary evaluation item fields as hidden fields.

[0064] The technical solution provided in this application can determine the form of the evaluation form template to be generated based on the user's selection of the scene selection label on the display interface and the basic information entered in the basic information input box. This improves the pertinence of the evaluation work and the efficiency of template generation, thereby improving the efficiency of business evaluation.

[0065] In an optional embodiment, the scoring rule includes multiple numerical ranges, and each of the numerical ranges corresponds to a preset evaluation level; each preset evaluation level may correspond to an ability level and a scoring coefficient; here, the preset evaluation levels corresponding to the multiple numerical ranges may include "unevaluable level", "initial level", "control level", "mature level", "excellent level" and "outstanding level" in ascending order of the preset evaluation level. The higher the ability level of the preset evaluation level, the higher the scoring coefficient of the preset evaluation level. As an example, the scoring rule corresponding to the evaluation item of "planned shutdown time" may include an initial-level numerical range, a control-level numerical range, and a mature-level numerical range. The initial-level numerical range is "T≥120", the control-level numerical range is "5<T<120", and the mature-level numerical range is "T≤5", where T is the planned shutdown time. Further, the preset evaluation level corresponding to "T≥120" is "initial level", the preset evaluation level corresponding to "5<T<120" is "control level", and the preset evaluation level corresponding to "T≤5" is "mature level".

[0066] Further, determining the rating result of the evaluation item based on the user input information and the scoring rule corresponding to the evaluation item includes: determining the numerical range corresponding to the user input information, and determining the preset evaluation level corresponding to the numerical range as the rating result. Here, the user input information may be the business value of the business corresponding to the evaluation item; as an example, if the evaluation item is "planned shutdown time", the user may input the specific value of the planned shutdown time in the evaluation input cell corresponding to this evaluation item, which may be "6".

[0067] Specifically, the value corresponding to the user input information can be compared with each numerical range of the scoring rule to determine the numerical range where the user input information is located. As an example, if the planned shutdown time entered in the evaluation input cell corresponding to "planned shutdown time" is "6", the numerical range corresponding to "6" is "5<T<120", and the preset evaluation level of the numerical range corresponding to the user input information is "control level", and "control level" is determined as the rating result of this evaluation item. The embodiment provided in the present application can quickly determine the rating result of the evaluation item of the object to be evaluated based on the user input information of the evaluation item and the multiple numerical ranges preset by the scoring rule, improving the business evaluation efficiency of the object to be evaluated.

[0068] In an optional embodiment, the evaluation domain table includes an evaluation domain, at least one evaluation subdomain corresponding to the evaluation domain, and at least one evaluation item corresponding to each evaluation subdomain. The evaluation subdomains included in the evaluation domain table are subordinate subdomains of the evaluation domain, and the evaluation items corresponding to each evaluation subdomain are the evaluation items covered by that subdomain. For example, as shown in Table 2, the evaluation domain corresponding to the evaluation domain table is "Operational Quality." The evaluation subdomains under "Operational Quality" include "System Availability" and "Number of Events / Issues." The evaluation items under "System Availability" are "Outage Time" and "Planned Downtime," and the evaluation item under "Number of Events / Issues" is "Number of Alarm Events." Furthermore, each evaluation item corresponds to a preset benchmark score, and each rating result corresponds to a preset scoring coefficient.

[0069]

[0070] Table 2

[0071] Here, the number, format, and hierarchical relationship of the assessment areas, sub-areas, and assessment items in the assessment area table can be determined according to the actual situation. The preset benchmark score for each assessment item and the preset scoring coefficient for each rating result can also be determined according to the actual situation.

[0072] Furthermore, determining the scoring result for the assessment domain based on the rating result of each assessment item corresponding to the assessment domain includes:

[0073] First, determine the preset benchmark score corresponding to the evaluation item and the preset scoring coefficient corresponding to the rating result of the evaluation item, and then determine the deduction value of the evaluation item based on the preset benchmark score and the preset scoring coefficient. Specifically, the rating result of the evaluation item and the preset benchmark score of the evaluation item can be determined, and the preset scoring coefficient of the rating result of the evaluation item can be determined. Further, the difference between 100% and the preset scoring coefficient can be calculated, and the product of the preset benchmark score and the difference can be calculated.

[0074] As an example, if the preset benchmark score for a certain assessment item is 60 points, and the rating result for the assessment item is "Control Level", and the preset scoring coefficient for "Control Level" is 50%, then the difference between 100% and 50% can be calculated. Multiplying the preset benchmark score by the difference will give the deduction value of 30 for the assessment item.

[0075] Then, the deduction values ​​for all evaluation items corresponding to the evaluation subdomain are determined, and the deduction values ​​for each evaluation item are added together to obtain the subdomain deduction value. Based on the subdomain deduction value, the evaluation subdomain capability score is determined. Specifically, for each evaluation subdomain, the deduction value for each evaluation item under each evaluation subdomain is calculated in the above manner, and the evaluation subdomain capability score is calculated according to Formula 1.

[0076]

[0077] Where A is the assessment subdomain ability score, n is the number of assessment items in the assessment subdomain, and X is the assessment subdomain ability score. i This represents the deduction value for the evaluation items within the evaluation subdomain. Furthermore, the evaluation subdomain capability score for each evaluation subdomain corresponding to the evaluation domain can be calculated based on the above method.

[0078] Finally, the evaluation subdomain capability scores of all evaluation subdomains corresponding to the evaluation domain are weighted and summed to obtain the evaluation domain score. Each evaluation subdomain corresponds to a preset evaluation subdomain weight value. Specifically, for each evaluation subdomain, the evaluation subdomain capability score is multiplied by the evaluation subdomain weight value to obtain the evaluation subdomain weight score, and the evaluation subdomain weight scores of each evaluation subdomain are summed to obtain the evaluation domain score.

[0079] The technical solution provided in this application can determine the scoring result of the evaluation field based on the rating result of the evaluation item corresponding to the evaluation field, the preset benchmark score of each evaluation item, and the preset scoring coefficient of each rating result. The score represents the level of business capability of the evaluated object in each evaluation field, thereby improving the functionality of the business evaluation method based on macro language.

[0080] In an optional embodiment, generating a business assessment report file for the object to be assessed based on the scoring results of each of the assessment domains and the rating results of each of the assessment items includes:

[0081] First, obtain the preset business evaluation template; among which, such as Figure 3 As shown, the business assessment template 300 has multiple result display areas, including an overall assessment result area 310, a capability weakness analysis sub-area 320, and a problem and risk identification area 330. Specifically, the overall assessment result area 310 can be located in the first position in the business assessment template, the capability weakness analysis sub-area 320 can be located in the second position, and the problem and risk identification area 330 can be located in the third position.

[0082] Then, the score results corresponding to each of the assessment areas are weighted and summed to obtain the overall capability score. The overall capability score and the score results for each of the assessment areas are then placed in the first position of the business assessment template. Here, each assessment area involved in the business assessment corresponds to a preset assessment area weight value. Specifically, after obtaining the score results for each assessment area, the product of the score result for each assessment area in the assessment table template and the corresponding assessment area weight value can be calculated. These product values ​​are then summed to obtain the overall capability score of the object to be assessed. Further, the score results for each assessment area and the overall capability score can be jointly placed in the first position of the business assessment template, and an application operation capability radar chart can be generated in the first position of the business assessment template based on the score results for each assessment area.

[0083] Next, the evaluation subdomain capability score for each evaluation subdomain corresponding to all the evaluation domains is determined, and all the evaluation subdomain capability scores are arranged in ascending order of value to obtain the evaluation subdomain queue.

[0084] Furthermore, the evaluation subdomains ranked at the top of the evaluation subdomain queue are identified as capability weakness subdomains, and all capability weakness subdomains are placed in the second position of the business evaluation template; here, the value of the preset position can be 10. Specifically, based on the capability scores of the evaluation subdomains, the 10 evaluation subdomains with the lowest capability scores among all evaluation areas are identified as capability weakness subdomains. Based on the capability scores of the capability weakness subdomains, the capability scores are converted into "stars" according to a unified rule, displaying the capability scores of the capability weakness subdomains from 1 to 5 stars. The lower the capability score of a capability weakness subdomain, the lower its "stars". Furthermore, each capability weakness subdomain, along with its "stars", is placed in the second position of the business evaluation template.

[0085] Furthermore, the rating result of each assessment item corresponding to all the assessment areas is determined, and the preset risk capability level corresponding to each assessment item is obtained. It is then determined whether the rating result of the assessment item is the same as the preset risk capability level of the assessment item. Here, a preset risk capability level can be set in advance for each assessment item that can be involved in the assessment work. For example, the preset risk capability level of the assessment item can be one of "unassessable level", "initial level", "controlled level", "mature level", "excellent level" and "superior level".

[0086] Specifically, the assessment items corresponding to each assessment area in the assessment form template can be identified, and the rating results corresponding to each assessment item can be determined. Then, for each assessment item, it can be determined whether the rating result of the assessment item is the same as the preset risk capability level of the assessment item.

[0087] Furthermore, if the rating result of the assessment item is the same as the preset risk capability level of the assessment item, then the assessment item is identified as a risk assessment item, and the attention level of the risk assessment item is identified as a key attention level; as an example, if the rating result of an assessment item is "initial level" and the preset risk capability level of the assessment item is also "initial level", then the assessment item is identified as a risk assessment item, and the attention level of the risk assessment item is identified as a key attention level.

[0088] Finally, the assessment area, assessment sub-domain, rating result, and attention level corresponding to the risk assessment item are set in the third position of the business assessment template to obtain the business assessment report file.

[0089] Specifically, a table can be set up in the third position of the business assessment template. The assessment area, assessment sub-area, rating result, and score result corresponding to the risk assessment item can be placed in the same row of the table, and the "Key Concern Level" can be entered in the last cell of that row. Here, the cell containing the "Key Concern Level" can also be set to red. Furthermore, for each risk assessment item, it can be set up in the table in the third position in the same way to obtain the business assessment report document.

[0090] The embodiments provided in this application can set the overall capability score and application operation capability radar chart of the object to be evaluated in the overall evaluation result area of ​​the business evaluation template, set the evaluation sub-domain where the object to be evaluated has shortcomings in the capability shortcoming analysis sub-area, and set the risk assessment items that the object to be evaluated needs to pay attention to in the problem and risk identification area. This improves the richness of the content of the generated business evaluation report document and enhances the comprehensiveness of the business evaluation of the object to be evaluated.

[0091] In an optional embodiment, after obtaining the business assessment report file, the user can save the file by clicking the "Save Report by Format" tab set on the assessment homepage. This allows the computer executing the method described in this embodiment to respond to the file storage operation, mapping and storing the assessment form template and the business assessment report file, thereby saving and exiting the VBA program. The main function of this step is to generate a uniformly named assessment report file based on information such as the assessment system and assessment time, and then save and exit Excel the business assessment report file and the assessment form template containing user input information.

[0092] Furthermore, users can also select a saved business assessment report file via the "Import Historical Assessment Data" tab on the assessment homepage and fill in the assessment indicators based on the business assessment report file. Specifically, firstly, the computer executing the macro-based business assessment method can read the file and check whether the Excel spreadsheet opened by the user contains the fields "Business Assessment Report File" and "Assessment Homepage". It further checks whether the basic assessment information in the basic information input boxes of the "Assessment Homepage" sheet matches the preset field information. If the basic assessment information matches the field information, further processing is performed; if the basic assessment information does not match the field information, an error message is displayed on the interface. Then, the assessment form template mapped to the business assessment report file is retrieved, allowing users to fill in relevant information in the assessment form template to perform business assessments based on the assessment form template used in previous assessment work.

[0093] The macro-based business evaluation method provided in this embodiment fully leverages the inherent advantages and widespread use of spreadsheet software in data analysis and processing. Building upon this, it automates the evaluation process by adding VBA to solidify the evaluation criteria and quantitative scoring rules. Furthermore, by adding data validation, it standardizes and simplifies the input of evaluation information, improving the standardization of evaluation implementation. This effectively solves the prominent problems of high human involvement, heavy workload, and low efficiency caused by manually analyzing and processing data in business information to obtain evaluation results. It significantly improves the standardization and efficiency of evaluation, supporting broader implementation of evaluation work.

[0094] It should be noted that the user information (including but not limited to user device information, user personal information, etc.) and data (including but not limited to data used for analysis, stored data, displayed data, etc.) involved in this application are all information and data authorized by the user or fully authorized by all parties. Furthermore, the labels corresponding to each step in the above embodiments are only for identification purposes and are not intended to limit the order of execution of the steps. The order of execution of the steps in each embodiment can be set according to the actual situation.

[0095] Furthermore, as Figure 1 The specific implementation of the method shown in this embodiment provides a business evaluation device based on macro language, such as... Figure 4 As shown, the device includes: an operation response module 41, a rating calculation module 42, and a result output module 43.

[0096] The operation response module 41 can be used to respond to the selection operation of the business evaluation scenario, determine the evaluation scenario information of the object to be evaluated, determine the evaluation form template corresponding to the evaluation scenario information, and display the evaluation form template on the display interface of the computer. The evaluation form template includes multiple evaluation domain tables, each evaluation domain table corresponds to an evaluation domain, and each evaluation domain table includes at least one evaluation item and a scoring rule and evaluation input cell corresponding to the evaluation item.

[0097] The rating calculation module 42 can be used to respond to the evaluation report generation operation, obtain user input information input into the evaluation input cell corresponding to the evaluation item, and determine the rating result of the evaluation item based on the user input information and the scoring rules corresponding to the evaluation item;

[0098] The result output module 43 can be used to determine the score result of the evaluation field based on the rating result of each evaluation item corresponding to the evaluation field, and generate a business evaluation report file of the object to be evaluated based on the score result of each evaluation field and the rating result of each evaluation item.

[0099] In a specific application scenario, the display interface shows multiple scene selection labels and a basic information input box. The operation response module 41 can be used to determine the scene selection label corresponding to the selection operation and the evaluation basic information in the basic information input box, and determine the evaluation scene information based on the scene selection label and the evaluation basic information.

[0100] In a specific application scenario, the operation response module 41 can be used to determine all the preset evaluation attributes corresponding to the evaluation scenario information, and compare each preset evaluation attribute with a preset full set of evaluation system indicators. The full set of evaluation system indicators includes multiple preset evaluation domain tables and preset attribute information corresponding to each preset evaluation domain table. The module identifies preset attribute information that is the same as the preset evaluation attribute in the full set of evaluation system indicators, and determines the preset evaluation domain table corresponding to the preset attribute information as the target evaluation domain table. The module determines the target evaluation domain table corresponding to each preset evaluation attribute, and generates the evaluation table template based on each target evaluation domain table.

[0101] In specific application scenarios, the scoring rules include multiple numerical ranges, each numerical range corresponding to a preset evaluation level. The rating calculation module 42 can be used to determine the numerical range corresponding to the user input information and determine the preset evaluation level corresponding to the numerical range as the rating result.

[0102] In specific application scenarios, the evaluation domain table also records at least one evaluation subdomain, and each evaluation subdomain corresponds to at least one evaluation item; each evaluation item corresponds to a preset benchmark score, and each rating result corresponds to a preset scoring coefficient. The result output module 43 can be used to determine the preset benchmark score corresponding to the evaluation item and the preset scoring coefficient corresponding to the rating result of the evaluation item, and determine the deduction value of the evaluation item based on the preset benchmark score and the preset scoring coefficient; determine the deduction values ​​of all evaluation items corresponding to the evaluation subdomain, and add the deduction values ​​of each evaluation item to obtain the subdomain deduction value, and determine the evaluation subdomain capability score of the evaluation subdomain based on the subdomain deduction value; and perform a weighted summation of the evaluation subdomain capability scores of all evaluation subdomains corresponding to the evaluation domain to obtain the rating result of the evaluation domain.

[0103] In a specific application scenario, the result output module 43 can be used to obtain a preset business evaluation template; perform a weighted summation on the scoring results corresponding to each evaluation domain to obtain an overall capability score, and set the overall capability score and the scoring results of each evaluation domain in the first position of the business evaluation template; determine the evaluation subdomain capability score of each evaluation subdomain corresponding to all evaluation domains, and arrange all evaluation subdomain capability scores in ascending order to obtain an evaluation subdomain queue; select the evaluation subdomains ranked at the top preset position in the evaluation subdomain queue as capability weakness subdomains, and set all capability weakness subdomains in the first position of the business evaluation template. At the second position of the business assessment template; determine the rating result of each assessment item corresponding to all assessment areas, obtain the preset risk capability level corresponding to each assessment item, and determine whether the rating result of the assessment item is the same as the preset risk capability level of the assessment item; if the rating result of the assessment item is the same as the preset risk capability level of the assessment item, then the assessment item is determined as a risk assessment item, and the attention level of the risk assessment item is determined as a key attention level; set the assessment area, assessment sub-domain, rating result, and attention level corresponding to the risk assessment item at the third position of the business assessment template to obtain the business assessment report file.

[0104] In a specific application scenario, the rating calculation module 42 can be used to respond to the evaluation report generation operation, obtain the evaluation form template, and determine whether each evaluation input cell in the evaluation form template contains the user input information; when any evaluation input cell does not contain the user input information, an alarm prompt is issued; when each evaluation input cell in the evaluation form template contains the user input information, the user input information entered into the evaluation input cell corresponding to the evaluation item is collected in the evaluation form template.

[0105] In a specific application scenario, the result output module 43 can be used to store the evaluation form template and the business evaluation report file in response to a file storage operation.

[0106] It should be noted that other corresponding descriptions of the functional units involved in the macro-language-based business evaluation device provided in this embodiment can be found in [reference]. Figure 1 The corresponding description in [the document] will not be repeated here.

[0107] Based on the above, Figure 1 Accordingly, this embodiment also provides a storage medium storing a computer program that, when executed by a processor, implements the above-described method. Figure 1 The business evaluation method based on macro language is shown.

[0108] Based on this understanding, the technical solution of this application can be embodied in the form of a software product. The software product to be identified can be stored in a non-volatile storage medium (such as a CD-ROM, USB flash drive, or portable hard drive), including several instructions to cause a computer (such as a personal computer, server, or network device) to execute the methods described in the various implementation scenarios of this application.

[0109] Based on the above, Figure 1 The method shown, and Figure 4 The illustrated embodiment of the macro-language-based business evaluation device, in order to achieve the above objectives, such as... Figure 5 As shown, this embodiment also provides a computer for business evaluation based on macro language, which can be a personal computer, server, smartphone, tablet, smartwatch, or other network device, etc. The computer includes a storage medium and a processor; the storage medium is used to store computer programs and an operating system; the processor is used to execute the computer programs to implement the above-mentioned... Figure 1 The method shown.

[0110] Optionally, the computer may also include internal memory, a communication interface, a network interface, a camera, radio frequency (RF) circuitry, sensors, audio circuitry, a Wi-Fi module, a display screen, and input devices such as a keyboard. The communication interface may also include a USB interface, a card reader interface, etc. The network interface may optionally include a standard wired interface or a wireless interface (such as a Wi-Fi interface).

[0111] Those skilled in the art will understand that the computer structure for recognizing operational actions provided in this embodiment does not constitute a limitation on the computer, and may include more or fewer components, or combine certain components, or have different component arrangements.

[0112] The storage medium may also include an operating system and a network communication module. The operating system is a program that manages the aforementioned computer hardware and software resources to be identified, supporting the operation of information processing programs and other software and / or programs to be identified. The network communication module is used to enable communication between the various components within the storage medium, as well as communication with other hardware and software in the information processing computer.

[0113] Through the above description of the embodiments, those skilled in the art can clearly understand that this application can be implemented using software plus necessary general-purpose hardware platforms, or it can be implemented using hardware. By applying the technical solution of this application, firstly, in response to the selection operation of a business evaluation scenario, the evaluation scenario information of the object to be evaluated is determined, and an evaluation form template corresponding to the evaluation scenario information is determined. The evaluation form template is then displayed on the computer's display interface. The evaluation form template includes multiple evaluation domain tables, each corresponding to an evaluation domain, and each evaluation domain table includes at least one evaluation item and a scoring rule and evaluation input cell corresponding to the evaluation item. Then, in response to the evaluation report generation operation, user input information input into the evaluation input cell corresponding to the evaluation item is obtained, and based on the user input information and the scoring rule corresponding to the evaluation item, the rating result of the evaluation item is determined. Finally, based on the rating result of each evaluation item corresponding to the evaluation domain, the rating result of the evaluation domain is determined, and based on the rating result of each evaluation domain and the rating result of each evaluation item, a business evaluation report file of the object to be evaluated is generated. Compared with the prior art, this improves the efficiency of business evaluation.

[0114] Those skilled in the art will understand that the accompanying drawings are merely schematic diagrams of a preferred embodiment, and the modules or processes shown in the drawings are not necessarily essential for implementing this application. Those skilled in the art will understand that the modules in the apparatus of the embodiment can be distributed within the apparatus of the embodiment as described, or can be modified to be located in one or more apparatuses different from this embodiment. The modules of the above-described embodiment can be combined into one module, or further divided into multiple sub-modules.

[0115] The serial numbers in this application are for descriptive purposes only and do not represent the superiority or inferiority of any particular implementation scenario. The above disclosures are merely a few specific implementation scenarios of this application; however, this application is not limited thereto, and any variations conceived by those skilled in the art should fall within the protection scope of this application.

Claims

1. A business evaluation method based on macro language, applied to a computer, characterized in that, The method includes: In response to the selection of a business assessment scenario, the system determines the assessment scenario information of the object to be assessed, determines the assessment form template corresponding to the assessment scenario information, and displays the assessment form template on the computer's display interface. The evaluation form template includes multiple evaluation domain forms, each evaluation domain form corresponds to an evaluation domain, and each evaluation domain form includes at least one evaluation item and a scoring rule and evaluation input cell corresponding to the evaluation item; In response to the evaluation report generation operation, the user input information entered into the evaluation input cell corresponding to the evaluation item is obtained, and the rating result of the evaluation item is determined based on the user input information and the scoring rules corresponding to the evaluation item; Based on the rating results of each evaluation item corresponding to the evaluation domain, the score result of the evaluation domain is determined, and based on the score results of each evaluation domain and the rating results of each evaluation item, a business evaluation report file of the object to be evaluated is generated.

2. The method according to claim 1, characterized in that, The display interface shows multiple scenario selection labels and a basic information input box; in response to the selection operation of the business evaluation scenario, the evaluation scenario information of the object to be evaluated is determined, including: Determine the scene selection label corresponding to the selection operation, as well as the evaluation basic information in the basic information input box, and determine the evaluation scene information based on the scene selection label and the evaluation basic information; The process of determining the evaluation form template corresponding to the evaluation scenario information includes: Determine all the preset evaluation attributes corresponding to the evaluation scenario information, and compare each preset evaluation attribute with the preset full set of evaluation system indicators, wherein the full set of evaluation system indicators includes multiple preset evaluation domain tables and preset attribute information corresponding to each preset evaluation domain table; In the full set of indicators of the evaluation system, the preset attribute information that is the same as the preset evaluation attribute is determined, and the preset evaluation domain table corresponding to the preset attribute information is determined as the target evaluation domain table; Determine the target evaluation domain table corresponding to each of the preset evaluation attributes, and generate the evaluation table template based on each target evaluation domain table.

3. The method according to claim 1, characterized in that, The scoring rules include multiple numerical ranges, and each numerical range corresponds to a preset evaluation level; The step of determining the rating result of the evaluation item based on the user input information and the scoring rules corresponding to the evaluation item includes: Determine the numerical range corresponding to the user input information, and determine the preset evaluation level corresponding to the numerical range as the rating result.

4. The method according to claim 3, characterized in that, The evaluation domain table also records at least one evaluation subdomain, and each evaluation subdomain corresponds to at least one evaluation item; each evaluation item corresponds to a preset benchmark score, and each rating result corresponds to a preset rating coefficient; The step of determining the scoring result for the assessment domain based on the rating result of each assessment item corresponding to the assessment domain includes: Determine the preset benchmark score corresponding to the evaluation item, and the preset scoring coefficient corresponding to the rating result of the evaluation item, and determine the deduction value of the evaluation item based on the preset benchmark score and the preset scoring coefficient; Determine the deduction values ​​for all evaluation items corresponding to the evaluation subdomain, add up the deduction values ​​for each evaluation item to obtain the subdomain deduction value, and determine the evaluation subdomain capability score based on the subdomain deduction value; The evaluation subdomain capability scores of all evaluation subdomains corresponding to the evaluation domain are weighted and summed to obtain the evaluation domain score.

5. The method according to claim 4, characterized in that, The process of generating a business assessment report file for the object to be assessed based on the scoring results of each of the assessment areas and the rating results of each of the assessment items includes: Obtain the preset business assessment template; The scoring results corresponding to each of the assessment areas are weighted and summed to obtain the overall capability score, and the overall capability score and the scoring results of each of the assessment areas are set in the first position of the business assessment template; Determine the evaluation subdomain capability score for each of the evaluation subdomains corresponding to all the evaluation domains, and arrange all the evaluation subdomain capability scores in ascending order of value to obtain the evaluation subdomain queue; The evaluation subdomains that are ranked at the top of the evaluation subdomain queue are identified as capability weakness subdomains, and all capability weakness subdomains are set in the second position of the business evaluation template. Determine the rating result for each of the assessment items corresponding to all the assessment areas, obtain the preset risk capability level corresponding to each assessment item, and determine whether the rating result of the assessment item is the same as the preset risk capability level of the assessment item; If the rating result of the assessment item is the same as the preset risk capability level of the assessment item, then the assessment item is identified as a risk assessment item, and the attention level of the risk assessment item is identified as the key attention level. The assessment area, assessment sub-domain, rating result, and attention level corresponding to the risk assessment item are set in the third position of the business assessment template to obtain the business assessment report file.

6. The method according to claim 1, characterized in that, The step of responding to the evaluation report generation operation by obtaining user input information entered into the evaluation input cell corresponding to the evaluation item includes: In response to the evaluation report generation operation, the evaluation form template is obtained, and it is determined whether each of the evaluation input cells in the evaluation form template contains the user input information; If any of the evaluation input cells does not contain the user input information, an alarm message will be issued. When each evaluation input cell in the evaluation form template contains the user input information, the user input information entered into the evaluation input cell corresponding to the evaluation item is collected in the evaluation form template.

7. The method according to claim 1, characterized in that, After generating the business assessment report file for the object to be assessed based on the scoring results of each of the assessment areas and the rating results of each of the assessment items, the method further includes: In response to the file storage operation, the evaluation form template and the business evaluation report file are stored.

8. A business evaluation device based on macro language, characterized in that, The device includes: An operation response module is used to respond to the selection operation of a business evaluation scenario, determine the evaluation scenario information of the object to be evaluated, determine the evaluation form template corresponding to the evaluation scenario information, and display the evaluation form template on the display interface of the computer. The evaluation form template includes multiple evaluation domain tables, each evaluation domain table corresponds to an evaluation domain, and each evaluation domain table includes at least one evaluation item and a scoring rule and evaluation input cell corresponding to the evaluation item. The rating calculation module is used to respond to the evaluation report generation operation, obtain user input information input into the evaluation input cell corresponding to the evaluation item, and determine the rating result of the evaluation item based on the user input information and the scoring rules corresponding to the evaluation item; The result output module is used to determine the score result of the evaluation field based on the rating result of each evaluation item corresponding to the evaluation field, and to generate a business evaluation report file of the object to be evaluated based on the score result of each evaluation field and the rating result of each evaluation item.

9. A storage medium having a computer program stored thereon, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 7.

10. A computer, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the computer program is executed by a processor, it implements the steps of the method according to any one of claims 1 to 7.

Images