CN113570219A - Method for converting prism G2 model data into EcoSys model data - Google Patents
Method for converting prism G2 model data into EcoSys model data Download PDFInfo
- Publication number
- CN113570219A CN113570219A CN202110794748.3A CN202110794748A CN113570219A CN 113570219 A CN113570219 A CN 113570219A CN 202110794748 A CN202110794748 A CN 202110794748A CN 113570219 A CN113570219 A CN 113570219A
- Authority
- CN
- China
- Prior art keywords
- wbs
- account
- ecosys
- prism
- platform
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000004364 calculation method Methods 0.000 claims abstract description 6
- 230000000694 effects Effects 0.000 claims description 51
- 238000006243 chemical reaction Methods 0.000 claims description 30
- 238000013507 mapping Methods 0.000 claims description 18
- 238000007726 management method Methods 0.000 abstract description 13
- 238000013499 data model Methods 0.000 abstract description 2
- 101000579423 Homo sapiens Regulator of nonsense transcripts 1 Proteins 0.000 abstract 1
- 102100028287 Regulator of nonsense transcripts 1 Human genes 0.000 abstract 1
- 238000012545 processing Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000003672 processing method Methods 0.000 description 1
- 239000002699 waste material Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/35—Clustering; Classification
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0283—Price estimation or determination
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Development Economics (AREA)
- Strategic Management (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Game Theory and Decision Science (AREA)
- General Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Educational Administration (AREA)
- Finance (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Stored Programmes (AREA)
Abstract
Compared with the prior art, the method has the advantages that the basic data model in PR I SMG2 is read, the WBS account of an EcoSys platform is automatically established according to an earned value calculation method, budget and engineering quantity are redistributed, and actual values and earned values are automatically converted. The work efficiency is improved, and human errors are avoided, so that the project informatization management level is integrally improved, and the purpose of the invention is realized.
Description
Technical Field
The invention relates to a processing method of a data architecture, in particular to a method for converting prism G2 model data into EcoSys model data.
Background
Prism g2 is an enterprise cost performance management software that oversees the entire project management lifecycle-forecasts that may be made, cost control, and performance metrics. Many enterprises and companies around the world use prism g2 software to manage projects, costs, and portfolios, which is characterized by an abundance of cost performance management tools.
EcoSys is an integrated management platform for projects that can capture all data for a project, including project progress, cost performance data, plans, and the like. The interactive operation setting and the powerful report engine can deeply understand all layers of each project, and the method is widely applied at home and abroad.
In the existing project, project cost control and performance measurement are performed by using prism G2 software in the early stage, and currently, the project management platform is gradually changed into an EcoSys project management platform for full-range project management, because the two pieces of software are independent software, the data architectures of the two pieces of software are inconsistent, account setting is incompatible, and data of the prism G2 software needs to be converted into data of the EcoSys platform.
Therefore, a method for converting prism 2 model data into EcoSys model data is particularly needed to solve the existing problems described above.
Disclosure of Invention
The invention aims to provide a method for converting prism G2 model data into EcoSys model data, aiming at the defects of the prior art, the method can automatically calculate and match, save the link of manual calculation, conversion and summarization, reduce the working intensity of personnel, improve the working efficiency, reduce manual errors and improve the data accuracy; the whole process is automatically finished, the operation is simple and convenient, and the production efficiency is high.
The technical problem solved by the invention can be realized by adopting the following technical scheme:
a method of converting prism g2 model data into EcoSys model data, comprising the steps of:
s1, downloading data from the prism G2 model data downloading module, wherein 6 data tables including Control Accounts, Budget Details, Budget costs elements, Control Accounts/Activity Cross-reference (relation table between Control Account and operation Activity), Schedule Activities and Control Account Time Phased data are stored in the memory;
s2, converting the control ACCOUNT of prism G2 into an EcoSys platform project WBS through a control ACCOUNT conversion module, and generating an ACCOUNT _ ID (control ACCOUNT code) of prism G2 and a WBS _ ID (WBS code) mapping table of EcoSys;
s3, converting the start time and the end time of the PrismG2 software job activity plan into the start time and the end time of the EcoSys platform project job activity plan through a job activity conversion module;
s4, calculating cost data and cost resources in the prism G2 software through an original budget conversion module to form cost data and resources corresponding to project original budgets in the EcoSys platform;
s5, converting the earned value and the actual value generated in the history period of the prism G2 software into the earned value and the actual value of the EcoSys platform through the earned value and actual value conversion module; and finishing all conversion.
In an embodiment of the present invention, the converting prism g2 control account into EcoSys platform project WBS includes the following steps:
s2.1, splitting the ACCOUNT _ ID in the Control Accounts table read in from the step S1 into different groups according to the separators, for example, splitting into groups of different categories such as stages, plants, systems and the like;
s2.2, according to the class group after being split in the step S2.1, according to the encoding sequence specified by the WBS, the classification and combination are carried out again to form a WBS _ ID which is in line with the WBS specification, and the attribute of the WBS is marked as a CA level;
s2.3, setting a winning value algorithm of the WBS _ ID according to a corresponding earning value calculation method in a Control Accounts table ACCOUNT _ ID;
s2.4, generating an ACCOUNT _ ID and WBS _ ID mapping table according to the step S2.2;
s2.5, circularly reading each WBS _ ID according to the WBS _ ID list formed in the step S2.2;
s2.6, removing the terminal class group according to the read WBS _ ID to form a new WBS _ ID, namely a parent node WBS _ ID of the node;
s2.7, judging whether the WBS _ ID is contained in the WBS _ ID list, if yes, entering the step S2.5, and if not, entering the step S2.8;
s2.8, adding the new WBS _ ID into a WBS _ ID list;
s2.9, judging whether the WBS _ ID only contains one category group, if so, setting the WBS _ ID category as Project, then entering step S2.5, if not, setting the WBS _ ID category as WBS, and entering step S2.6;
s2.10, circularly reading each entry ACCOUNT _ ID and Activity _ ID according to the read Control Account/Activity Cross-reference table, entering step S2.11, and entering step S2.14 if the reading is finished;
s2.11, finding the WBS _ ID corresponding to the ACCOUNT _ ID according to the ACCOUNT _ ID and WBS _ ID mapping table,
s2.12, adding child nodes to the WBS _ ID, wherein the last category group is Activity _ ID, and adding the newly generated WBS _ ID into a WBS _ ID list;
s2.13, setting the newly added WBS _ ID type as a Plan Package; returning to the step S2.10;
s2.14, completing the conversion from the prism G2 control account to an EcoSys platform project WBS; a complete tree-like WBS _ ID list is formed by steps S2.1 to S2.14.
In one embodiment of the invention, the converting the prism g2 software job plan start time and end time into the EcoSys platform project plan job plan start time and end time comprises the following steps:
s3.1, reading each WBS _ ID list data circularly and sequentially; if the reading is finished, the step S3.8 is carried out; otherwise, entering step S3.2;
s3.2, judging whether the WBS _ ID type is a Plan Package, and if so, entering the step S3.3; if not, entering step S3.1;
s3.3, acquiring the last category group (operation code) from the selected WBS _ ID, matching the selected WBS _ ID with the Activity _ ID in the Schedule Activities table read in the step S1, and assigning the starting time and the ending time in the Schedule Activities table to the planned starting time and the planned ending time of the WBS;
s3.4, removing the last category group from the WBS _ ID to obtain a father node of the WBS _ ID;
s3.5, finding out the corresponding ACCOUNT _ ID according to the parent node according to the ACCOUNT _ ID and WBS _ ID mapping table;
s3.6, according to the ACCOUNT _ ID, finding out the BASELINE _ CURVE _ ID attribute in the Control ACCOUNTs table read in through the step S1;
s3.7, assigning the BASELINE _ CURVE _ ID attribute to the time distribution mode attribute of the WBS _ ID, and returning to the step S3.1;
and S3.8, finishing the conversion of the planned starting time and the planned ending time of the two modules.
In an embodiment of the present invention, the calculating cost data and cost resources in prism g2 software to form cost data and resources corresponding to project original budgets in the EcoSys platform includes the following steps:
s4.1, merging the Budget tables read in the step S1, and summarizing according to the Budget _ ID to form a Budget table comprising ACCOUNT _ ID, Budget _ ID, engineering quantity, Cost and working hour;
s4.2, reading in the weight field quantity in the Control Account/Activity Cross-reference table according to the step S1, classifying according to the ACCOUNT _ ID, and calculating the percentage of each planned operation under the same ACCOUNT _ ID;
s4.3, obtaining the percentage of each planned operation under ACCOUNT _ ID according to the summary budget table in the step S4.2, and splitting the project amount, the cost and the working hours of the summary budget table formed in the step S4.1 into each operation;
and S4.4, matching the split engineering quantity, cost and working hour to WBS _ ID corresponding to ACCOUNT _ ID and Activity _ ID, and generating an original budget table under the EcoSys platform.
In an embodiment of the invention, the conversion of earned value and actual value of prism G2 software historical cycle occurrence to earned value and actual value of EcoSys platform comprises the following steps
S5.1, recording earning values, engineering quantities, working hours and completion percentages in a table into an EcoSys platform according to each period through the ACCOUNT _ ID in a read Control Account Time Phased Date table and a mapping table of the ACCOUNT _ ID and WBS _ ID;
s5.2, recording actual values in the table into the EcoSys platform according to each period according to the ACCOUNT _ ID and WBS _ ID mapping table through the ACCOUNT _ ID in the read Control Account Time Phased Date table.
Compared with the prior art, the method for converting the prism G2 model data into the EcoSys model data automatically establishes the WBS account of the EcoSys platform by reading the basic data model in the PRISM G2 and then according to the earned value calculation method, redistributes budget and engineering quantity and automatically converts the actual value and the earned value. The work efficiency is improved, and human errors are avoided, so that the project informatization management level is integrally improved, and the purpose of the invention is realized.
The features of the present invention will be apparent from the accompanying drawings and from the detailed description of the preferred embodiments which follows.
Drawings
FIG. 1 is a schematic structural diagram of the present invention for converting prism G2 model data into EcoSys model data;
FIG. 2 is a schematic flow chart of converting a prism G2 control account into an EcoSys platform project WBS according to the present invention;
FIG. 3 is a schematic flow chart of the present invention for converting the PrismG2 software job plan start time and end time to the EcoSys platform project plan job plan start time and end time;
fig. 4 is a schematic flow chart of the method for calculating cost data and cost resources in prism g2 software to form cost data and resources corresponding to the project original budget in the EcoSys platform according to the present invention.
Detailed Description
In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further explained below by combining the specific drawings.
Examples
As shown in fig. 1, the method for converting prism 2 model data into EcoSys model data of the present invention is implemented by the following system modules:
the system comprises a prism G2 model data downloading module, wherein the prism G2 model data downloading module is used for reading data stored in prism G2 software into a program memory, and improving subsequent processing and operation speed, and the downloaded data comprises 6 data tables in total, namely Control Accounts (Control Account list), Budget Details (original Budget engineering quantity list), Budget Details (original Budget Cost list), Control Accounts/Activity Cross-reference (Control Account and operation Activity relation list), Schedule Activities (operation Activity list) and Control Account Time Phased Date (Control Account historical data);
the control account conversion module is used for carrying out comparison conversion on the control accounts in the two pieces of software to form an EcoSys platform project WBS;
the system comprises an original budget conversion module, a data processing module and a data processing module, wherein the original budget conversion module is used for calculating cost data and cost resources in prism G2 software to form cost data and resources corresponding to project original budgets in an EcoSys platform;
a job activity conversion module for converting the prism g2 software job activity plan start time and end time into an EcoSys platform project plan job activity plan start time and end time; and
and the earned value and actual value conversion module is used for converting the earned values and actual values generated in the history period of the prism G2 software into the earned value and actual value module of the EcoSys platform.
The method for converting the prism G2 model data into the EcoSys model data comprises the following steps:
s1, downloading data from the prism G2 model data downloading module, wherein the data comprise 6 data tables in total, wherein the data tables comprise Control Accounts (Control Account list), Budget Details (original Budget engineering quantity list), Budget Details code Element (original Budget Cost list), Control Accounts/Activity Cross-reference (Control Account and operation Activity relation table), Schedule Activities (operation Activity list) and Control Account Time Phased Date (Control Account history data), and are stored in a memory;
s2, converting the control ACCOUNT of the prism G2 into an EcoSys platform project WBS through the control ACCOUNT conversion module, and generating a WBS _ ID (WBS code) mapping table of ACCOUNT _ ID (control ACCOUNT code) EcoSys of the prism G2;
as shown in fig. 2, the method for converting the prism g2 control account into the EcoSys platform project WBS comprises the following steps:
s2.1, splitting the ACCOUNT _ ID in the Control Accounts table read in from the step S1 into different groups according to the separators, for example, splitting into different groups such as stages, plants, systems and the like;
s2.2, according to the class group after being split in the step S2.1, according to the encoding sequence specified by the WBS, the classification and combination are carried out again to form a WBS _ ID which is in line with the WBS specification, and the attribute of the WBS is marked as a CA level;
s2.3, setting a winning value algorithm of the WBS _ ID according to a corresponding earning value calculation method in a Control Accounts table ACCOUNT _ ID;
s2.4, generating an ACCOUNT _ ID and WBS _ ID mapping table according to the step S2.2;
s2.5, circularly reading each WBS _ ID according to the WBS _ ID list formed in the step S2.2;
s2.6, removing the terminal class group according to the read WBS _ ID to form a new WBS _ ID, namely a parent node WBS _ ID of the node;
s2.7, judging whether the WBS _ ID is contained in the WBS _ ID list, if yes, entering the step S2.5, and if not, entering the step S2.8;
s2.8, adding the new WBS _ ID into a WBS _ ID list;
s2.9, judging whether the WBS _ ID only contains one category group, if so, setting the WBS _ ID category as Project, then entering step S2.5, if not, setting the WBS _ ID category as WBS, and entering step S2.6;
s2.10, circularly reading each entry ACCOUNT _ ID and Activity _ ID according to a read Control Account/Activity Cross-reference table, entering a step S2.11, and if the reading is finished, executing a step S2.14;
s2.11, finding the WBS _ ID corresponding to the ACCOUNT _ ID according to the ACCOUNT _ ID and WBS _ ID mapping table,
s2.12, adding child nodes to the WBS _ ID, wherein the last category group is Activity _ ID, and adding the newly generated WBS _ ID into a WBS _ ID list;
s2.13, setting the newly added WBS _ ID type as a Plan Package; returning to the step S2.10;
and S2.14, completing the conversion of the control account of the prism G2 to an EcoSys platform project WBS.
A complete tree-like WBS _ ID list is formed by steps S2.1 to S2.14.
S3, converting the start time and the end time of the PrismG2 software job activity plan into the start time and the end time of the EcoSys platform project job activity plan through a job activity conversion module;
as shown in fig. 3, converting the prism g2 software job plan start time and end time to the EcoSys platform project plan job plan start time and end time includes the following steps:
s3.1, reading each WBS _ ID list data circularly and sequentially; if the reading is finished, the step S3.8 is carried out; otherwise, entering step S3.2;
s3.2, judging whether the WBS _ ID type is a Plan Package, and if so, entering the step S3.3; if not, entering step S3.1;
s3.3, acquiring the last category group (operation code) from the selected WBS _ ID, matching the selected WBS _ ID with the Activity _ ID in the Schedule Activities table read in the step S1, and assigning the starting time and the ending time in the Schedule Activities table to the planned starting time and the planned ending time of the WBS;
s3.4, removing the last category group from the WBS _ ID to obtain a father node of the WBS _ ID;
s3.5, finding out the corresponding ACCOUNT _ ID according to the parent node according to the ACCOUNT _ ID and WBS _ ID mapping table;
s3.6, according to the ACCOUNT _ ID, finding out the BASELINE _ CURVE _ ID attribute in the Control ACCOUNTs table read in through the step S1;
s3.7, assigning the BASELINE _ CURVE _ ID attribute to the time distribution mode attribute of the WBS _ ID, and returning to the step S3.1;
and S3.8, finishing the conversion of the planned starting time and the planned ending time of the two modules.
S4, calculating cost data and cost resources in the prism G2 software through an original budget conversion module to form cost data and resources corresponding to project original budgets in the EcoSys platform;
as shown in fig. 4, the cost data and the cost resources in the prism g2 software are calculated to form the cost data and the resources corresponding to the project original budget in the EcoSys platform, which includes the following steps:
s4.1, merging the Budget tables read in the step S1, and summarizing according to the Budget _ ID to form a Budget table comprising ACCOUNT _ ID, Budget _ ID, engineering quantity, Cost and working hour;
s4.2, reading in the weight field quantity in the Control Account/Activity Cross-reference table according to the step S1, classifying according to the ACCOUNT _ ID, and calculating the percentage of each planned operation under the same ACCOUNT _ ID;
s4.3, obtaining the percentage of each planned operation under ACCOUNT _ ID according to the summary budget table in the step S4.2, and splitting the project amount, the cost and the working hours of the summary budget table formed in the step S4.1 into each operation;
and S4.4, matching the split engineering quantity, cost and working hour to WBS _ ID corresponding to ACCOUNT _ ID and Activity _ ID, and generating an original budget table under the EcoSys platform.
Thus, the planning reference data of the EcoSys platform is formed through the steps S1 to S4.
S5, converting the earned value and the actual value generated in the history period of the prism G2 software into the earned value and the actual value of the EcoSys platform through the earned value and actual value conversion module,
the method for converting the earned value and the actual value of the prism G2 software historical period into the earned value and the actual value of the EcoSys platform comprises the following steps
S5.1, recording earning values, engineering quantities, working hours and completion percentages in a table into an EcoSys platform according to each period through the ACCOUNT _ ID in a read Control Account Time Phased Date table and a mapping table of the ACCOUNT _ ID and WBS _ ID;
s5.2, recording actual values in the table into the EcoSys platform according to each period according to the ACCOUNT _ ID and WBS _ ID mapping table through the ACCOUNT _ ID in the read Control Account Time Phased Date table.
And finishing all conversion, and converting into the EcoSys platform project earned value and the actual value.
Compared with the prior art, the invention has the following beneficial effects:
1. according to the method for converting the prism G2 model data into the EcoSys model data, the labor waste caused by manual conversion is avoided, and the efficiency and the quality are greatly improved.
2. The method for converting the prism G2 model data into the EcoSys model data automatically imports the actual data and the earned data provided by the prism G2 software into the EcoSys platform, the whole process is completed automatically, manual intervention is not needed, the operation is simple and convenient, and the production efficiency is high.
3. The method for converting the prism G2 model data into the EcoSys model data can greatly improve the project management level, improve the working efficiency of project management personnel and promote the effective connection and cooperative matching of management teams; the method can be popularized and applied to the field of project management in China and industry, the integral improvement of the project management level of industry is promoted, and the international competitiveness of national and series nuclear power projects is improved.
The foregoing shows and describes the general principles and broad features of the present invention and advantages thereof. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are merely illustrative of the principles of the present invention, but that various changes and modifications may be made without departing from the spirit and scope of the invention, which is defined by the appended claims and their equivalents.
Claims (5)
1. A method of converting prism g2 model data into EcoSys model data, comprising the steps of:
s1, downloading data from the prism G2 model data downloading module, wherein 6 data tables including Control Accounts, Budget Details, Budget costs elements, Control Accounts/Activity Cross-reference (relation table between Control Account and operation Activity), Schedule Activities and Control Account Time Phased data are stored in the memory;
s2, converting the control ACCOUNT of prism G2 into an EcoSys platform project WBS through a control ACCOUNT conversion module, and generating an ACCOUNT _ ID (control ACCOUNT code) of prism G2 and a WBS _ ID (WBS code) mapping table of EcoSys;
s3, converting the start time and the end time of the PrismG2 software job activity plan into the start time and the end time of the EcoSys platform project job activity plan through a job activity conversion module;
s4, calculating cost data and cost resources in the prism G2 software through an original budget conversion module to form cost data and resources corresponding to project original budgets in the EcoSys platform;
s5, converting the earned value and the actual value generated in the history period of the prism G2 software into the earned value and the actual value of the EcoSys platform through the earned value and actual value conversion module; and finishing all conversion.
2. The method of converting prism g2 model data into EcoSys model data according to claim 1, wherein the converting prism g2 control account into EcoSys platform item WBS comprises the steps of:
s2.1, splitting the ACCOUNT _ ID in the Control Accounts table read in from the step S1 into different groups according to the separators, for example, splitting into groups of different categories such as stages, plants, systems and the like;
s2.2, according to the class group after being split in the step S2.1, according to the encoding sequence specified by the WBS, the classification and combination are carried out again to form a WBS _ ID which is in line with the WBS specification, and the attribute of the WBS is marked as a CA level;
s2.3, setting a winning value algorithm of the WBS _ ID according to a corresponding earning value calculation method in a Control Accounts table ACCOUNT _ ID;
s2.4, generating an ACCOUNT _ ID and WBS _ ID mapping table according to the step S2.2;
s2.5, circularly reading each WBS _ ID according to the WBS _ ID list formed in the step S2.2;
s2.6, removing the terminal class group according to the read WBS _ ID to form a new WBS _ ID, namely a parent node WBS _ ID of the node;
s2.7, judging whether the WBS _ ID is contained in the WBS _ ID list, if yes, entering the step S2.5, and if not, entering the step S2.8;
s2.8, adding the new WBS _ ID into a WBS _ ID list;
s2.9, judging whether the WBS _ ID only contains one category group, if so, setting the WBS _ ID category as Project, then entering step S2.5, if not, setting the WBS _ ID category as WBS, and entering step S2.6;
s2.10, circularly reading each entry ACCOUNT _ ID and Activity _ ID according to the read Control Account/Activity Cross-reference table, entering step S2.11, and entering step S2.14 if the reading is finished;
s2.11, finding the WBS _ ID corresponding to the ACCOUNT _ ID according to the ACCOUNT _ ID and WBS _ ID mapping table,
s2.12, adding child nodes to the WBS _ ID, wherein the last category group is Activity _ ID, and adding the newly generated WBS _ ID into a WBS _ ID list;
s2.13, setting the newly added WBS _ ID type as a Plan Package; returning to the step S2.10;
s2.14, completing the conversion from the prism G2 control account to an EcoSys platform project WBS; a complete tree-like WBS _ ID list is formed by steps S2.1 to S2.14.
3. The method of converting prism g2 model data into EcoSys model data according to claim 1, wherein converting prism g2 software job plan start time and end time into EcoSys platform project job plan start time and end time comprises the steps of:
s3.1, reading each WBS _ ID list data circularly and sequentially; if the reading is finished, the step S3.8 is carried out; otherwise, entering step S3.2;
s3.2, judging whether the WBS _ ID type is a Plan Package, and if so, entering the step S3.3; if not, entering step S3.1;
s3.3, acquiring the last category group (operation code) from the selected WBS _ ID, matching the selected WBS _ ID with the Activity _ ID in the Schedule Activities table read in the step S1, and assigning the starting time and the ending time in the Schedule Activities table to the planned starting time and the planned ending time of the WBS;
s3.4, removing the last category group from the WBS _ ID to obtain a father node of the WBS _ ID;
s3.5, finding out the corresponding ACCOUNT _ ID according to the parent node according to the ACCOUNT _ ID and WBS _ ID mapping table;
s3.6, according to the ACCOUNT _ ID, finding out the BASELINE _ CURVE _ ID attribute in the Control ACCOUNTs table read in through the step S1;
s3.7, assigning the BASELINE _ CURVE _ ID attribute to the time distribution mode attribute of the WBS _ ID, and returning to the step S3.1;
and S3.8, finishing the conversion of the planned starting time and the planned ending time of the two modules.
4. The method for converting prism g2 model data into EcoSys model data according to claim 1, wherein the cost data and cost resources in prism g2 software are calculated to form cost data and resources corresponding to project original budgets in the EcoSys platform, comprising the steps of:
s4.1, merging the Budget tables read in the step S1, and summarizing according to the Budget _ ID to form a Budget table comprising ACCOUNT _ ID, Budget _ ID, engineering quantity, Cost and working hour;
s4.2, reading in the weight field quantity in the Control Account/Activity Cross-reference table according to the step S1, classifying according to the ACCOUNT _ ID, and calculating the percentage of each planned operation under the same ACCOUNT _ ID;
s4.3, obtaining the percentage of each planned operation under ACCOUNT _ ID according to the summary budget table in the step S4.2, and splitting the project amount, the cost and the working hours of the summary budget table formed in the step S4.1 into each operation;
and S4.4, matching the split engineering quantity, cost and working hour to WBS _ ID corresponding to ACCOUNT _ ID and Activity _ ID, and generating an original budget table under the EcoSys platform.
5. The method for converting prism g2 model data into EcoSys model data according to claim 1, wherein the step of converting earned value and actual value of prism g2 software history cycle occurrence into earned value and actual value of EcoSys platform comprises the following steps
S5.1, recording earning values, engineering quantities, working hours and completion percentages in a table into an EcoSys platform according to each period through the ACCOUNT _ ID in a read Control Account Time Phased Date table and a mapping table of the ACCOUNT _ ID and WBS _ ID;
s5.2, recording actual values in the table into the EcoSys platform according to each period according to the ACCOUNT _ ID and WBS _ ID mapping table through the ACCOUNT _ ID in the read Control Account Time Phased Date table.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110794748.3A CN113570219B (en) | 2021-07-14 | 2021-07-14 | Method for converting PrismG model data into EcoSys model data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110794748.3A CN113570219B (en) | 2021-07-14 | 2021-07-14 | Method for converting PrismG model data into EcoSys model data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113570219A true CN113570219A (en) | 2021-10-29 |
| CN113570219B CN113570219B (en) | 2024-06-21 |
Family
ID=78164780
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110794748.3A Active CN113570219B (en) | 2021-07-14 | 2021-07-14 | Method for converting PrismG model data into EcoSys model data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113570219B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016131101A1 (en) * | 2015-02-17 | 2016-08-25 | Pimovation Pty Ltd | A web platform for preparing project management documents |
| JP2017091508A (en) * | 2015-11-05 | 2017-05-25 | 株式会社オービック | Project accounting management device, project accounting management method, and project accounting management program |
| CN110599125A (en) * | 2019-09-05 | 2019-12-20 | 广东牵引信息科技有限公司 | Dynamic list generation system and method for project management |
| CN111291994A (en) * | 2020-02-12 | 2020-06-16 | 普元信息技术股份有限公司 | Multi-project management system and method suitable for agile development mode in big data environment |
| CN111914417A (en) * | 2020-07-28 | 2020-11-10 | 上海核工程研究设计院有限公司 | Plan and budget simulation analysis system |
-
2021
- 2021-07-14 CN CN202110794748.3A patent/CN113570219B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2016131101A1 (en) * | 2015-02-17 | 2016-08-25 | Pimovation Pty Ltd | A web platform for preparing project management documents |
| JP2017091508A (en) * | 2015-11-05 | 2017-05-25 | 株式会社オービック | Project accounting management device, project accounting management method, and project accounting management program |
| CN110599125A (en) * | 2019-09-05 | 2019-12-20 | 广东牵引信息科技有限公司 | Dynamic list generation system and method for project management |
| CN111291994A (en) * | 2020-02-12 | 2020-06-16 | 普元信息技术股份有限公司 | Multi-project management system and method suitable for agile development mode in big data environment |
| CN111914417A (en) * | 2020-07-28 | 2020-11-10 | 上海核工程研究设计院有限公司 | Plan and budget simulation analysis system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113570219B (en) | 2024-06-21 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112001618B (en) | Method for integrating and optimizing construction period assignment, order acceptance and production scheduling | |
| CN103955754A (en) | Mold workshop scheduling method based on real-time production data collection | |
| CN105719126A (en) | System and method for internet big data task scheduling based on life cycle model | |
| CN112541749A (en) | Construction progress management system based on BIM technology | |
| Hosseini et al. | Flow production of construction processes through implementing lean construction principles and simulation | |
| CN110705823A (en) | Production process route configuration method | |
| CN111274680B (en) | Method for acquiring logistics transportation simulation path of digital factory | |
| CN112884455A (en) | Task plan processing system, method and device | |
| Chen et al. | Extension data mining method for improving product manufacturing quality | |
| CN115170034A (en) | Factory object full life cycle management method | |
| CN109033452B (en) | Intelligent construction loading method and system for data warehouse | |
| EP4418179A1 (en) | Microservices-architecture-based full-lifecycle management system for new-energy power generation devices | |
| CN113570219A (en) | Method for converting prism G2 model data into EcoSys model data | |
| CN104636610B (en) | A kind of manufacture system being applied under dynamic environment sends work Information revision method | |
| CN113313281B (en) | Thermal power enterprise multi-coal cost optimization method and system based on electric power market | |
| CN111311406B (en) | Power generator trading capacity control system and method based on concurrent trading of power market | |
| CN115048751A (en) | Data-driven three-dimensional assembly process variant design method and system | |
| CN101101551A (en) | Method for automatically establishing procedure body | |
| CN114897394A (en) | Power consumption monitoring system and method | |
| CN116151524A (en) | Accurate matching method applied to nuclear power plant work order task | |
| CN113642851A (en) | BIM-based highway bridge construction and maintenance integrated management system | |
| CN109032075A (en) | A kind of intelligence steel construction stock method and system | |
| CN113569542B (en) | Implementation method for automatically drawing and analyzing nuclear power engineering construction plan network diagram | |
| CN118505162B (en) | Method and system for automatically planning deep design task | |
| CN114139367B (en) | Automatic calculation method for standard embedded parts of nuclear power plant |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: No. 29 Hong Cao Road, Xuhui District, Shanghai Applicant after: Shanghai Nuclear Engineering Research and Design Institute Co.,Ltd. Address before: No. 29 Hong Cao Road, Xuhui District, Shanghai Applicant before: SHANGHAI NUCLEAR ENGINEERING RESEARCH & DESIGN INSTITUTE Co.,Ltd. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |