CN118014399A - Implementation method for automatically calculating DICT project benefit evaluation result - Google Patents
Implementation method for automatically calculating DICT project benefit evaluation result Download PDFInfo
- Publication number
- CN118014399A CN118014399A CN202410211229.3A CN202410211229A CN118014399A CN 118014399 A CN118014399 A CN 118014399A CN 202410211229 A CN202410211229 A CN 202410211229A CN 118014399 A CN118014399 A CN 118014399A
- Authority
- CN
- China
- Prior art keywords
- data
- project
- dict
- benefit
- excel
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 230000008901 benefit Effects 0.000 title claims abstract description 134
- 238000000034 method Methods 0.000 title claims abstract description 99
- 238000011156 evaluation Methods 0.000 title claims abstract description 83
- 238000004364 calculation method Methods 0.000 claims abstract description 88
- 230000008569 process Effects 0.000 claims abstract description 36
- 238000004140 cleaning Methods 0.000 claims abstract description 21
- 238000012545 processing Methods 0.000 claims abstract description 13
- 230000002159 abnormal effect Effects 0.000 claims abstract description 8
- 238000004458 analytical method Methods 0.000 claims description 9
- 238000004422 calculation algorithm Methods 0.000 claims description 9
- 230000006870 function Effects 0.000 claims description 9
- 230000003915 cell function Effects 0.000 claims description 5
- 238000013500 data storage Methods 0.000 claims description 5
- 238000012550 audit Methods 0.000 claims description 4
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 238000011084 recovery Methods 0.000 abstract description 18
- 230000009286 beneficial effect Effects 0.000 abstract description 2
- 238000010586 diagram Methods 0.000 description 14
- 238000007726 management method Methods 0.000 description 11
- 238000013210 evaluation model Methods 0.000 description 8
- 238000005516 engineering process Methods 0.000 description 6
- 230000003068 static effect Effects 0.000 description 6
- 230000001186 cumulative effect Effects 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 5
- 230000007547 defect Effects 0.000 description 4
- 230000010354 integration Effects 0.000 description 4
- 230000002776 aggregation Effects 0.000 description 3
- 238000004220 aggregation Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 230000003287 optical effect Effects 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000012854 evaluation process Methods 0.000 description 2
- 238000009434 installation Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 238000002360 preparation method Methods 0.000 description 2
- 238000006467 substitution reaction Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000005094 computer simulation Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
- 239000002071 nanotube Substances 0.000 description 1
- 238000010223 real-time analysis Methods 0.000 description 1
- 230000009467 reduction Effects 0.000 description 1
- 230000008439 repair process Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The implementation method for automatically calculating DICT project benefit evaluation results is beneficial to realizing the management and control of DICT project results from a standard process, so as to avoid the risks of low implementation benefit, long recovery period and abnormal cash flow of DICT project, and is characterized by comprising the following steps: step A, preparing an excel template with a formula; step B, obtaining an external data source, cleaning external source data, and converting the data into a data body identifiable by an excel template; step C, integrating the cleaned external source data into a parameter input area in the excel template, executing a POI method by utilizing a function calculation formula existing in a cell to realize automatic calculation of the model, and generating actual calculation result data of a result output area; and D, reading actual calculation result data of the result output area, processing and cleaning abnormal data to obtain a standardized data processing result, warehousing a result excel, and traversing a data table to obtain the current benefit data calculation result of the DICT items.
Description
Technical Field
The invention relates to the technical field of automatic real-time analysis and calculation of benefit results of DICT items in process management, in particular to a method for automatically calculating DICT item benefit evaluation results.
Background
The project benefit result is used as an important index in the project expense condition, project profit tracking and project management processes, and the implementation benefit evaluation methods of different types of projects are different. The DICT-class project service plays a vital role in the whole project development system of operators in the process of group customer service and the process of preempting markets, the DICT-class project service has the characteristics of cross departments, long flow, high service knowledge level requirement, high financial knowledge level, high dependence on the characteristics of industry and property fusion benefit assessment and the like in the operators, how to accurately control the benefit results of the project in each stage in the implementation process, know the benefit change condition of each node of the project, provide a guiding scheme for high-precision and multidimensional research and judgment on the balance benefit condition of the project in the continuous implementation process, and be a very complex topic.
At present, in the DICT-class project management process, the conditions of project cross departments, cross services, high requirement on multiple service levels, long project management flow and different expense data distribution in a plurality of different systems exist, so that the expense benefit data of each stage of the project cannot be timely and accurately estimated, only a manual multiparty query summary can be carried out, a rough-dimension benefit estimation result is given according to a simple benefit calculation formula, the benefit estimation process does not carry out integral nano-tubes on the data such as actual cash flow, amortization cost and project depreciation cost of the project, and the overall actual benefit estimation result of the project has larger deviation. The project expense condition cannot be effectively and integrally controlled. The expense condition of the project is uncontrollable, and the conditions such as loss are discovered even after the project is linked.
The conventional DICT project benefit evaluation means has the following defects:
1. The DICT project business financial data are distributed in a plurality of systems such as ICT, contract, account reporting, ERP, supply chain and the like for processing, the data of the plurality of systems are poor in coordination, and the evaluation process of each benefit stage needs to be manually and repeatedly filled in a line, so that the workload is high and the efficiency is low. The benefit result depends on manual evaluation, and the multi-system information is collected, so that the efficiency is low and the workload is high; the randomness of the evaluation is higher, the coverage area of the evaluation is insufficient, and the deviation of the benefit evaluation result is larger.
2. In the project implementation process, the benefit condition of each stage of the project cannot be rapidly and accurately evaluated in real time.
The existing technical mode needs a large amount of manpower to collect and comb manually, and under the current rapid development trend of DICT business, the requirements of project management on the accuracy and timeliness of project income conditions are difficult to meet, and real-time benefit evaluation condition data of each stage of the project cannot be rapidly and accurately given. Aiming at the information such as cost, income, profit margin and the like of DICT items, a means for intensive management and analysis is lacking. The invention aims to realize flexible, intelligent and timely function construction of a complex calculation formula of DCIT project benefits, comprehensively analyze and evaluate data collected by multiple systems, calculate real-time benefit evaluation results of the whole project in real time according to a cross-specialized complex formula algorithm, and solve the problems of low efficiency, large workload, inaccurate data, deviation in a calculation template transmission process and incapability of unifying calculation versions of manually calculating the project benefit data, thereby realizing accurate control of the project whole benefit evaluation data.
Disclosure of Invention
Aiming at the defects or defects in the prior art, the invention provides the implementation method for automatically calculating the DICT project benefit evaluation result, which is beneficial to realizing the management and control of the DICT project result from the standard process, so as to avoid the risks of low implementation income, long recovery period and abnormal cash flow of the DICT project.
The technical scheme of the invention is as follows:
The implementation method for automatically calculating DICT project benefit evaluation results is characterized by comprising the following steps:
step A, preparing an excel template with a formula, wherein the excel template comprises three data sets of a parameter input area, a calculation process area and a result output area;
step B, obtaining an external data source, cleaning external source data, and converting the data into a data body identifiable by an excel template;
Step C, integrating the cleaned external source data into a parameter input area in an excel template to obtain complete data of the whole excel calculation model, traversing all cells, executing a POI method by using a function calculation formula in the cells to realize automatic calculation of the model, and generating actual calculation result data of a result output area;
And D, reading actual calculation result data of the result output area, processing and cleaning abnormal data to obtain a standardized data processing result, warehousing a result excel, and traversing a data table to obtain the current benefit data calculation result of the DICT items.
The excel template in the step A comprises the following contents: the method comprises the steps of providing a user cell to be filled and a yellow cell mark; the method comprises the steps of providing a cell with a function calculation formula and a yellow cell mark; the other table head type cells are fixed, and white cells are identified.
The step A comprises the following steps:
Step A1, analyzing data indexes;
step A2, preparing a template excel.
The step B comprises the following steps:
step B1, obtaining a clutter data source, storing the data source for auditing use on one hand, cleaning clutter data on the other hand, and cleaning and formatting the data in a standard way;
step B2, obtaining a template yellow cell data body;
and step B3, storing the cleaned data so as to audit the use.
The step C comprises the following steps:
step C1, reading an excel template;
step C2, writing a template sheet into a stream filling yellow cell data body;
Step C3, obtaining complete data of the sheet to be filled;
step C4, traversing all the cells;
Step C5, if the cell exists in the formula, executing POI method automatic calculation;
Step C6, filling the current cell after calculating the cell function;
And C7, obtaining complete sheet data.
The step D comprises the following steps:
Step D1, analyzing excel full data;
And D2, data storage.
The POI method in the step C comprises the following steps:
step 1, starting an excel analysis flow and a POI algorithm;
step 2, decompressing XLSX files in the memory;
Step 3, reading the XML file in the memory by using the SAX mode;
step 3, performing model conversion in Workbook row cell;
and 4, returning the whole content to the caller.
The method comprises the steps of carrying out pre-benefit evaluation on a project approximation stage, carrying out subscription benefit evaluation on a project budget stage, carrying out process benefit evaluation on a project accounting stage, carrying out post-benefit evaluation on a project resolution stage, and further obtaining DICT project benefit evaluation result tables, wherein the DICT project benefit evaluation result tables comprise DICT project balance description tables and DICT financial value evaluation tables.
The invention has the following technical effects: according to the implementation method for automatically calculating the DICT project benefit evaluation result, the benefit evaluation calculation process is segmented and disassembled according to the four-step calculation flow, so that the benefit result process of each stage of the project is dynamically calculated by the convergence and integration method, rapid iteration of DICT project benefit calculation is realized, and a self-definable complex calculation model rapid output result is realized.
The invention makes up the defect that no automatic algorithm for evaluating the benefits of DICT items, which is complete and wide in coverage of business products and calculation results, unifies the system standard of dynamic calculation benefits evaluation of DICT items in each stage, standardizes the requirements of benefits evaluation of different data sources in a plurality of stages and a plurality of scenes, realizes management and control of the item results from the standardized process, and avoids the risks of low implementation benefits, long recovery period and abnormal cash flow of the items.
Drawings
Fig. 1 is a schematic diagram of four stages of calculating DICT project benefit according to the implementation method of automatically calculating DICT project benefit evaluation results of the present invention. DICT refers to big data technology DT, information technology IT, and communication technology CT. The method comprises four stages of project overview, project budget, project accounting and project resolution in fig. 1, including a pre-sale stage, an in-sale stage and an after-sale stage. The pre-sale link comprises creating a business machine, project decision-bidding management, formal stand-forward contract and forward contract analysis, project accounting, business acceptance, backward contract and backward contract analysis, wherein the project decision and bidding management belong to a project approximation stage, and the formal stand, the forward contract and the forward contract analysis belong to a project budget stage. The middle selling ring section comprises project delivery, project planning, project purchasing, project designing, project starting, project implementation, project finishing and project acceptance, wherein each item belongs to the project budget stage. The after-market link includes a project handoff-project junction, where each item belongs to the project resolution stage.
FIG. 2 is a schematic diagram of ICT project revenue and expenditure related to a method for automatically calculating DICT project benefit evaluation results according to the present invention. In FIG. 2, ICT project revenue payouts (tax, ten thousand yuan units) are related, and classification, project revenue aggregation, IT class revenue aggregation, 1. Communication and information service revenue, 1-1 system integrated revenue (information technology service), 1-2 system integrated revenue (installation service), 1-3 maintenance revenue (information technology service), 1-4 maintenance revenue (installation service), 1-5 software development service, 1-6 maintenance premium, maintenance/repair labor, 1-7 other (commission), 1-8 cloud computing maintenance premium, 1-9 cloud computing integrated fee, 1-10 cloud computing software development fee, 1-11IOT software development and service fee (IOT is Internet of things) are sequentially arranged from the left side to the top. The top side in fig. 2 is classified from left to right, and the tax rate is added (reference value is described below), the tax rate is added-calculated, the amount (including tax) is calculated, the input and output of the original project (the project needs to be filled in) are put into production in the current year and the years after.
FIG. 3 is a schematic diagram of ICT project cash flow data related to a method for automatically calculating DICT project benefit evaluation results according to the present invention. In fig. 3, the Information and Communication Technology (ICT) project cash flow data (ten thousand yuan) are sequentially indicated from the left side to the top, and the index value, the cash inflow total, the cost cash outflow, the investment cash outflow, the income tax payment, the cash outflow total, the net cash flow, and the accumulated net cash flow are sequentially indicated. The index value, the amount (including tax) and the input and output of the original project (the renewal project needs to be filled) are sequentially shown from left to right in the upper part of fig. 3, and the 0 th year, the 1 st year and the following years are all shown.
FIG. 4 is a schematic diagram of a method for automatically calculating DICT project benefit evaluation results according to the present invention. Fig. 4 relates to a depreciation and amortization auxiliary measuring meter (without tax, ten thousand yuan). The left side of the system is sequentially 1, the fixed asset catalogue is referred, the depreciation period of the platform equipment is 5 years, the transmission network equipment is 7 years, the optical cable pipeline is 10 years, and the software is 2-5 years from top to bottom in fig. 4; 2. the total investment is depreciated and amortized each year, and the sum of IT type investment and CT type investment in the income and expense detailed table is not consistent with the sum of tax; the total investment is depreciated and amortized every year; the investment of the platform equipment is accumulated and depreciated; depreciation years; the current year changes the month of the funding; the scale of the platform equipment transfer of each year; the first year invests in depreciation in each year; the next year invests in depreciation in each year; the third year invests in depreciation of each year; the fourth year invests in depreciation of each year; the fifth year invests in depreciation of each year; the sixth year invests in depreciation in each year. The upper side of the system is sequentially 1, a reference fixed asset catalogue, a platform equipment depreciation year of 5 years, a transmission network equipment of 7 years, an optical cable pipeline of 10 years and a software class of 2-5 years from left to right in the figure 4; 2. the total investment is depreciated and amortized each year, and the sum of IT type investment and CT type investment in the income and expense detailed table is not consistent with the sum of tax; totalizing; the current year and the years after the production.
Fig. 5 is a schematic diagram illustrating project expense involved in an implementation method for automatically calculating DICT project benefit evaluation results according to the present invention. The left side of fig. 5 is in turn from top to bottom the direct expenditure of items, IT costs, cost totals, IT investments, CT investments, investment totals, IT incomes, CT incomes, income totals, net profits, refund amount, payment amount. The top side in fig. 5 is the direct balance of the projects in turn from left to right, and the total is added up, and the production is put into operation in the current year and each year later.
FIG. 6 is a representation of the financial value assessment intent involved in a method of implementing the automatic calculation DICT of the project benefit assessment results of the present invention. The evaluation index, the cumulative net present value (ten thousand yuan), the cumulative net present value, the internal income ratio, the dynamic recovery period (year), the static recovery period, the static recovery rate, the IT partial profit ratio, the IT partial tax profit ratio, the project overall profit ratio, the IT project overall tax profit ratio, and the CT project overall tax profit ratio are sequentially shown from top to bottom in the figure 6. In fig. 6, the upper side is an evaluation index, an index value, a criterion, and an index specification are sequentially from left to right. The cumulative net present value is more than 0, the cumulative net present value rate is more than 0, the internal profit rate is more than or equal to 5.5%, the dynamic recovery period is less than or equal to the contract period, the static recovery rate is less than 1, the blank, the profit rate after IT part tax is more than 5%, the blank, the profit rate after IT type project integral tax is more than or equal to 10%, and the profit rate after CT type project integral tax is more than or equal to 8%.
FIG. 7 is a schematic diagram of a data calculation process according to an implementation method for automatically calculating DICT items of benefit evaluation results according to the present invention. Step a is included in fig. 7, preparing an excel template with formula (excel is microsoft spreadsheet software); step B, cleaning external source data; step C, integrating external data into an excel template; and D, warehousing a result excel. The excel template in the step A comprises the following contents: the method comprises the steps of providing a user cell to be filled and a yellow cell mark; the method comprises the steps of providing a cell with a function calculation formula and a yellow cell mark; the other table head type cells are fixed, and white cells are identified. The step A comprises the step A1 of analyzing data indexes; step A2, preparing a template excel. Step B1, obtaining a clutter data source, storing the data source for auditing use on one hand, and cleaning the clutter data on the other hand; step B2, obtaining a template yellow cell data body; and step B3, storing the cleaned data so as to audit the use. Step C comprises the step C1 of reading an excel template; step C2, writing a template sheet into a stream filling yellow cell data body; step C3, obtaining complete data of the sheet to be filled; step C4, traversing all the cells; step C5, if the cell exists in the formula, executing POI method automatic calculation (POI, interest point); step C6, filling the current cell after calculating the cell function; and C7, obtaining complete sheet data. Step D comprises a step D1 of analyzing excel full data; and D2, data storage.
Fig. 8 is a schematic diagram of a POI calculation process related to an implementation method for automatically calculating DICT item benefit evaluation results according to the present invention. Step 1 is included in fig. 8, an excel parsing flow and a POI algorithm are started; step 2, decompressing XLSX files in a memory (XLSX, marking the document format); step 3, reading the XML file in the memory by using SAX mode (SAX is a simple application program interface for XML, SIMPLE API for XML; XML document format mark); step 3, performing model conversion in Workbook row cell (thin row cells); and 4, returning the whole content to the caller.
Detailed Description
The invention is described below with reference to the figures (fig. 1-8) and examples.
Fig. 1 is a schematic diagram of four stages of calculating DICT project benefit according to the implementation method of automatically calculating DICT project benefit evaluation results of the present invention. FIG. 2 is a schematic diagram of ICT project revenue and expenditure related to a method for automatically calculating DICT project benefit evaluation results according to the present invention. FIG. 3 is a schematic diagram of ICT project cash flow data related to a method for automatically calculating DICT project benefit evaluation results according to the present invention. FIG. 4 is a schematic diagram of a method for automatically calculating DICT project benefit evaluation results according to the present invention. Fig. 5 is a schematic diagram illustrating project expense involved in an implementation method for automatically calculating DICT project benefit evaluation results according to the present invention. FIG. 6 is a representation of the financial value assessment intent involved in a method of implementing the automatic calculation DICT of the project benefit assessment results of the present invention. FIG. 7 is a schematic diagram of a data calculation process according to an implementation method for automatically calculating DICT items of benefit evaluation results according to the present invention. Fig. 8 is a schematic diagram of a POI calculation process related to an implementation method for automatically calculating DICT item benefit evaluation results according to the present invention. Referring to fig. 1 to 8, a method for automatically calculating DICT the benefit evaluation result of the item includes the following steps: step A, preparing an excel template with a formula, wherein the excel template comprises three data sets of a parameter input area, a calculation process area and a result output area; step B, obtaining an external data source, cleaning external source data, and converting the data into a data body identifiable by an excel template; step C, integrating the cleaned external source data into a parameter input area in an excel template to obtain complete data of the whole excel calculation model, traversing all cells, executing a POI method by using a function calculation formula in the cells to realize automatic calculation of the model, and generating actual calculation result data of a result output area; and D, reading actual calculation result data of the result output area, processing and cleaning abnormal data to obtain a standardized data processing result, warehousing a result excel, and traversing a data table to obtain the current benefit data calculation result of the DICT items.
The excel template in the step A comprises the following contents: the method comprises the steps of providing a user cell to be filled and a yellow cell mark; the method comprises the steps of providing a cell with a function calculation formula and a yellow cell mark; the other table head type cells are fixed, and white cells are identified. The step A comprises the following steps: step A1, analyzing data indexes; step A2, preparing a template excel. The step B comprises the following steps: step B1, obtaining a clutter data source, storing the data source for auditing use on one hand, cleaning clutter data on the other hand, and cleaning and formatting the data in a standard way; step B2, obtaining a template yellow cell data body; and step B3, storing the cleaned data so as to audit the use.
The step C comprises the following steps: step C1, reading an excel template; step C2, writing a template sheet into a stream filling yellow cell data body; step C3, obtaining complete data of the sheet to be filled; step C4, traversing all the cells; step C5, if the cell exists in the formula, executing POI method automatic calculation; step C6, filling the current cell after calculating the cell function; and C7, obtaining complete sheet data.
The step D comprises the following steps: step D1, analyzing excel full data; and D2, data storage.
The POI method in the step C comprises the following steps: step 1, starting an excel analysis flow and a POI algorithm; step 2, decompressing XLSX files in the memory; step 3, reading the XML file in the memory by using the SAX mode; step 3, performing model conversion in Workbook row cell; and 4, returning the whole content to the caller.
The method comprises the steps of carrying out pre-benefit evaluation on a project approximation stage, carrying out subscription benefit evaluation on a project budget stage, carrying out process benefit evaluation on a project accounting stage, carrying out post-benefit evaluation on a project resolution stage, and further obtaining DICT project benefit evaluation result tables, wherein the DICT project benefit evaluation result tables comprise DICT project balance description tables and DICT financial value evaluation tables.
Referring to fig. 1, the benefit calculation of the dic project is mainly divided into four phases: a project budget stage, a project approximation stage, a project accounting stage, and a project resolution stage.
Project overview phase-pre-benefit assessment:
The characteristics of the ICT project determine the necessity of 'pre-approval', namely project pre-evaluation, namely, when the project is carried out to a stage of presupposition, basic information and expense conditions of the project are analyzed before the actual development of the project so as to judge the feasibility of the project. The project manager who needs to require the ICT project can initiate a batch decision after manually filling in the benefit evaluation form, and the benefit evaluation form automatically calculates the benefit indexes such as IT cost, CT cost, IT class investment, CT class investment, IT class income, CT class income, net profit, refund amount, payment amount, accumulated net present value rate, internal benefit rate, dynamic recovery period, static recovery period, IT part benefit rate, recovery period, benefit rate and the like of the project.
Project budget phase-subscription benefit assessment:
And in the project budget stage, signing benefit assessment is carried out, signing benefit is automatically calculated mainly according to actual signing conditions of the project, after the project completes a formal project, the project is compared with the estimated benefit in time, and whether the condition of benefit reduction exists is checked. The evaluation model and the front evaluation model of the benefit keep consistent, the basic data of the cost and the income come from the front-back contract analysis result of the project, and the contents such as actual business composition, planning time, money and the like according to contract signing and contract analysis are substituted into the benefit evaluation model. The project manager of the ICT project can initiate batch decision after manually filling in the benefit evaluation table in the project formal project setting stage, and the benefit evaluation table automatically calculates benefit indexes such as net profit, return amount, payment amount, accumulated net present value rate, internal benefit rate, dynamic recovery period, static recovery period, IT part benefit rate, recovery period, benefit rate, project whole benefit rate, IT part benefit, CT part benefit and the like of the project.
Project accounting phase-process benefit assessment:
and in the implementation stage of the project sales, the project process benefit evaluation is carried out, and in the implementation process of the project sales, the project is combined with the actual contract signing data of the customer contract according to the actual expenditure condition of the backward contract, so that the project process benefit is automatically checked, and timely compared with the general calculation and the budget benefit, and whether the benefit is reduced or not is checked. The evaluation model of the process benefit evaluation is consistent with the earlier evaluation model, and the system can check the income, cost, expense and cash inflow and outflow item update of the past period (half year/one year) as actual occurrence values, compare the actual occurrence values with the data of the prediction period, check the difference reasons, realize the benefit evaluation in the process, acquire the contents such as the actual payment amount of the forward contract, the actual payment amount of the backward contract and the like, and realize the online dynamic automatic calculation benefit.
Project resolution stage-post-benefit assessment:
The execution benefit of the tracking item is automatically calculated through the data of the accounting stage. According to the data statistics of the accounting stage, the final actual account data and the final actual cash flow related data of the project are solidified into a unified mapping relation, indexes such as net present value rate, recovery period and the like of the project can be obtained through the acquisition of numbers from a collection list and a payment list, and indexes such as gross edge rate and the like of the project can be obtained through the acquisition of numbers from a income list and a cost list. The difference between the pre-evaluation and post-evaluation of the project was statistically analyzed. The junction stage benefit evaluation result mainly comprises: the method comprises the following steps of project total income, project equipment integrated income, project cost expenditure, project net present value (ten thousand), dynamic recovery period (year), net present value rate/project income rate (%), internal income rate and the like.
Referring to fig. 2, in the benefit evaluation table, a income and expense list is used as a first major basic data source of all benefit evaluation results, in the general calculation and budget stage, the income and expense list is input into a benefit evaluation model in a manual filling mode, and data such as IT plan income, CT plan income, IT plan expense, CT plan expense and the like of various products are input into the model for calculation according to the product conditions actually associated with the project. In the project accounting and resolution stage, relevant data such as IT actual income, CT actual income, IT actual expenditure, CT actual expenditure and the like of various products are obtained and substituted into a model for calculation mainly according to the product conditions actually associated with the project.
Referring to fig. 3, the cash flow statement is used as a second basic data source, and is used as a second large basic data entry of the benefit evaluation statement by manually filling or importing data, and the actual cash flow information of the main entry item in each year is focused on related data such as cost cash flows, investment cash flows and the like.
Referring to fig. 4, the depreciation and amortization auxiliary measuring and calculating table is a third basic data source entry table of the benefit evaluation model, and mainly obtains related data such as the annual platform equipment investment amortization amount, the optical cable and pipeline investment amortization amount, the software investment amortization amount, and other investment amortization amounts. After the data is acquired, the benefit model automatically regulates the equipment depreciation cost of each year according to the algorithm.
The benefit evaluation result table mainly comprises the following parts:
Referring to fig. 5, the project expense description is calculated according to the data source substitution model, and the project expense description includes the calculation of the cost of the IT/CT project and the investment of the IT/CT project according to the equipment depreciation cost and the actual cash outflow condition. And calculating data such as IT/CT type project income, net profit, refund amount, payment amount and the like according to the actual income amount.
Referring to fig. 6, a financial value evaluation table calculates the result of the associated benefits such as the cumulative net present value, the internal rate of return, the dynamic recovery period, the static recovery period, the IT profit margin, the overall profit margin of the item, etc.
Because the model of the whole project benefit evaluation process is complex, a large amount of ICT business knowledge is needed, the financial knowledge is fused to construct the whole benefit evaluation model, and partial special calculation functions are involved, such as financial special IRR algorithm is needed for calculating the yield, the whole calculation model is complex, the data of the complex model is calculated, the following scheme is adopted, the data entering model is automatically collected through software, the calculation process is placed in the data collection corresponding to the excel calculation model through automatically filling the result after analyzing the data, after the excel calculation, the corresponding calculation result in the table is analyzed and identified, and the quick, flexible and custom construction of the complex calculation model is realized. Refer to fig. 7.
The first step: computational model preparation
And constructing a mature calculation model by using excel, analyzing data indexes, and classifying various different data structures in the calculation model, wherein the calculation model mainly comprises three data sets of a parameter input area, a calculation process area and a result output area. The corresponding region is identified by software, a circulation framework is built for the next step of automatically bringing in a data source and automatically analyzing and acquiring a data calculation result, and data support preparation is made.
And a second step of: obtaining an external data source
The method comprises the steps of firstly storing and auditing data of a data source by acquiring corresponding input parameter data from an external system interface, cleaning and formatting the data according to a set algorithm rule aiming at the disordered data source in the auditing process, converting the data into a data body which can be identified by an excel template, and storing the data again.
And a third step of: external data source integration
According to the entry data area in the excel data model defined in the first step, acquiring the cleaned entry data set from an external system interface, writing the entry data set into the corresponding entry data area through a program, obtaining complete data of the whole excel calculation model, traversing all cells, and executing the POI method to realize automatic calculation of the model if the cells have formulas (refer to FIG. 8). And filling the corresponding result presentation area after calculating the cell function. And traversing all the data structure model tables, and reading actual calculation result data of the result output area.
Fourth step: results data source integration and warehousing
Reading actual calculation result data of the result output area, processing and cleaning abnormal data, obtaining standardized data processing results, and then warehousing and carrying out next operation processing.
In the ICT project management process, a method for automatically calculating the benefit evaluation results in different project stages is provided, the calculation process of the benefit evaluation is segmented and disassembled according to a four-step calculation flow, the benefit result processes of the project stages are dynamically calculated by an aggregation and integration method, rapid iteration of ICT project benefit calculation is realized, and a customizable complex calculation model rapid output result is realized.
The complex calculation model for ICT project benefit evaluation is classified according to different data sets, and the complex calculation model comprises a parameter input area, a calculation process area, a result output area and other data sets. And dynamically identifying the corresponding region by software, and realizing the dynamic modification effect of the benefit calculation model by a method of manually replacing the benefit calculation excel model.
And (3) performing data storage, auditing, cleaning and standard formatting on the acquired input parameter data, converting the data into a data body identifiable by an excel template, and storing the cleaned data.
Filling the cleaned parameter entering data set into a parameter entering data area corresponding to excel, traversing the cells after obtaining the complete data of the whole excel calculation model, and executing POI method automatic calculation on the cells with formulas. And traversing all the data structure model tables, and reading actual calculation result data of the result output area.
And reading the calculation result of the result output area, processing and cleaning the data, and traversing the data table after cleaning is completed to obtain the current benefit data calculation result of the ICT project.
What is not described in detail in the present specification belongs to the prior art known to those skilled in the art. It is noted that the above description is helpful for a person skilled in the art to understand the present invention, but does not limit the scope of the present invention. Any and all such equivalent substitutions, modifications and/or deletions as may be made without departing from the spirit and scope of the invention.
Claims (8)
1. The implementation method for automatically calculating DICT project benefit evaluation results is characterized by comprising the following steps:
step A, preparing an excel template with a formula, wherein the excel template comprises three data sets of a parameter input area, a calculation process area and a result output area;
step B, obtaining an external data source, cleaning external source data, and converting the data into a data body identifiable by an excel template;
Step C, integrating the cleaned external source data into a parameter input area in an excel template to obtain complete data of the whole excel calculation model, traversing all cells, executing a POI method by using a function calculation formula in the cells to realize automatic calculation of the model, and generating actual calculation result data of a result output area;
And D, reading actual calculation result data of the result output area, processing and cleaning abnormal data to obtain a standardized data processing result, warehousing a result excel, and traversing a data table to obtain the current benefit data calculation result of the DICT items.
2. The method for automatically calculating DICT the benefit evaluation result according to claim 1, wherein the excel template in step a includes the following contents: the method comprises the steps of providing a user cell to be filled and a yellow cell mark; the method comprises the steps of providing a cell with a function calculation formula and a yellow cell mark; the other table head type cells are fixed, and white cells are identified.
3. The method for automatically calculating DICT the benefit evaluation result according to claim 1, wherein the step a includes the steps of:
Step A1, analyzing data indexes;
step A2, preparing a template excel.
4. The method for automatically calculating DICT the benefit evaluation result according to claim 1, wherein the step B includes the steps of:
step B1, obtaining a clutter data source, storing the data source for auditing use on one hand, cleaning clutter data on the other hand, and cleaning and formatting the data in a standard way;
step B2, obtaining a template yellow cell data body;
and step B3, storing the cleaned data so as to audit the use.
5. The method for automatically calculating DICT the benefit evaluation result according to claim 1, wherein the step C includes the steps of:
step C1, reading an excel template;
step C2, writing a template sheet into a stream filling yellow cell data body;
Step C3, obtaining complete data of the sheet to be filled;
step C4, traversing all the cells;
Step C5, if the cell exists in the formula, executing POI method automatic calculation;
Step C6, filling the current cell after calculating the cell function;
And C7, obtaining complete sheet data.
6. The method for automatically calculating DICT the benefit evaluation result according to claim 1, wherein the step D includes the steps of:
Step D1, analyzing excel full data;
And D2, data storage.
7. The method for automatically calculating DICT the benefit evaluation result according to claim 1, wherein the POI method in step C includes the steps of:
step 1, starting an excel analysis flow and a POI algorithm;
step 2, decompressing XLSX files in the memory;
Step 3, reading the XML file in the memory by using the SAX mode;
step 3, performing model conversion in Workbook row cell;
and 4, returning the whole content to the caller.
8. The method of claim 1, comprising performing pre-benefit evaluation for a project estimation stage, performing subscription benefit evaluation for a project budget stage, performing process benefit evaluation for a project accounting stage, performing post-benefit evaluation for a project resolution stage, and obtaining DICT project benefit evaluation result table, wherein the DICT project benefit evaluation result table comprises a DICT project balance specification table and a DICT financial value evaluation table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410211229.3A CN118014399A (en) | 2024-02-26 | 2024-02-26 | Implementation method for automatically calculating DICT project benefit evaluation result |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202410211229.3A CN118014399A (en) | 2024-02-26 | 2024-02-26 | Implementation method for automatically calculating DICT project benefit evaluation result |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN118014399A true CN118014399A (en) | 2024-05-10 |
Family
ID=90942730
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202410211229.3A Pending CN118014399A (en) | 2024-02-26 | 2024-02-26 | Implementation method for automatically calculating DICT project benefit evaluation result |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN118014399A (en) |
-
2024
- 2024-02-26 CN CN202410211229.3A patent/CN118014399A/en active Pending
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Dietzenbacher et al. | The construction of world input–output tables in the WIOD project | |
| CN103679373B (en) | Produce the full chain budgetary data processing system and method for capital construction standard costs system | |
| CN103699966A (en) | Multidimensional overall-process data control system and control method based on user requirement | |
| CN113902535A (en) | Automatic accounting method and system for consumption tax | |
| CN102819774A (en) | Project cost management system and architecture thereof | |
| JP6049799B2 (en) | Management support program | |
| CN110728422A (en) | Building information model, method, device and settlement system for construction project | |
| CN112749846A (en) | Big data platform-based financial cloud picture construction analysis method for electric power system | |
| Luo et al. | An integrated strategic and tactical optimization model for forest supply chain planning | |
| CN115564482A (en) | Construction method of internal marketing management system based on complex equipment delivery problem | |
| CN113610595B (en) | Report and examination price informatization management method and system | |
| CN110516952A (en) | A kind of financial transaction assessment system based on big data | |
| CN111444248A (en) | Method for checking and analyzing enterprise operation data | |
| CN118014399A (en) | Implementation method for automatically calculating DICT project benefit evaluation result | |
| CN113934406B (en) | Power engineering audit system and method for developing intelligent flow based on iteration increment mode | |
| Bardazzi et al. | Towards a new INFORUM bilateral trade model: Data issues and modelling equations | |
| Delisle | The Canadian national tourism indicators: a dynamic picture of the satellite account | |
| CN112749986A (en) | Intelligent electricity price library for settlement sharing service of power system | |
| Chen et al. | Optimal staffing policy in commercial banks under seasonal demand variation | |
| CN116823145B (en) | Internal simulation market management system, control method, platform and terminal | |
| Erumban et al. | Slicing Up Global Value Chains: The Role of China | |
| Chunye | Research on Measuring Method of Function Size of Information System | |
| Djayeola et al. | Policies, Technology, and Quality Returns from the World Development Indicators. | |
| Wu et al. | Harvest evaluation model and system of fast-growing and high-yield poplar plantation | |
| CN113610594B (en) | Equipment review price data processing method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination |