CN113570219B - Method for converting PrismG model data into EcoSys model data - Google Patents
Method for converting PrismG model data into EcoSys model data Download PDFInfo
- Publication number
- CN113570219B CN113570219B CN202110794748.3A CN202110794748A CN113570219B CN 113570219 B CN113570219 B CN 113570219B CN 202110794748 A CN202110794748 A CN 202110794748A CN 113570219 B CN113570219 B CN 113570219B
- Authority
- CN
- China
- Prior art keywords
- wbs
- account
- ecosys
- prismg
- budget
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 20
- 238000004364 calculation method Methods 0.000 claims abstract description 6
- 230000000694 effects Effects 0.000 claims description 38
- 238000006243 chemical reaction Methods 0.000 claims description 30
- 238000013507 mapping Methods 0.000 claims description 15
- 108091026890 Coding region Proteins 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims description 3
- 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
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012545 processing Methods 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
- 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
- 239000002699 waste material Substances 0.000 description 1
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 for converting Pr I smG model data into EcoSys model data automatically establishes a WBS account of a EcoSys platform according to a struggle value calculation method by reading a basic data model in PR I SMG2, reallocates budget and engineering quantity, and automatically converts an actual value and the struggle value. Not only improves the working efficiency and avoids human errors, but also integrally improves the project informatization management level and achieves the aim of the invention.
Description
Technical Field
The present invention relates to a method for processing a data structure, and in particular, to a method for converting PrismG model data into EcoSys model data.
Background
PrismG2 is an enterprise cost performance management software that oversees the overall project management lifecycle-predictions, cost control, and performance metrics that can be made. Many businesses and companies around the world use PrismG software to manage projects, costs, and portfolios, which is characterized by a rich cost performance management tool.
EcoSys is an integrated management platform for projects that can capture all of the project's data, including project progress, cost performance data, plans, and the like. The interactive operation setting and powerful report engine can be used for deeply knowing each layer of each project, and has wide application in China and abroad.
In the existing project, the project cost control and the performance measurement are carried out by using PrismG software in early stage, the project management platform is gradually changed into EcoSys project management platform to carry out full-range project management at present, and as the two software are independent software, the data structures of the two software are inconsistent, the account setting is also incompatible, and the data of the PrismG software need to be converted into the data of the EcoSys platform.
Therefore, there is a particular need for a method of converting PrismG model data to EcoSys model data that addresses the above-described existing problems.
Disclosure of Invention
The invention aims to provide a method for converting PrismG model data into EcoSys model data, which aims at overcoming the defects of the prior art, can automatically calculate and match, saves the link of manual calculation, conversion and summarization, reduces the working intensity of personnel, improves the working efficiency, reduces the manual errors and improves the data accuracy; the whole process is automatically completed, the operation is simple and convenient, and the production efficiency is high.
The technical problems solved by the invention can be realized by adopting the following technical scheme:
a method of converting PrismG model data to EcoSys model data, comprising the steps of:
s1, downloading data from a PrismG model data downloading module, wherein the data comprises 6 data tables including Control Accounts, a Budget Details list, budget Details Cost Element, control Account/Activity Cross-references list, schedule Activities and Control Account TIME PHASED DATE, and the 6 data tables are stored in a memory;
s2, converting PrismG a control account into EcoSys platform item WBS through a control account conversion module, and generating ACCOUNT _ID (control account code) of PrismG and WBS_ID (WBS code) mapping tables of EcoSys;
S3, converting PrismG software operation activity plan starting time and ending time into EcoSys platform project plan operation activity plan starting time and ending time through an operation activity conversion module;
S4, calculating cost data and cost resources in PrismG software through an original budget conversion module to form cost data and resources corresponding to the original budget of the project in the EcoSys platform;
S5, converting the struggle value and the actual value generated in the PrismG software history period into the struggle value and the actual value of the EcoSys platform through a struggle value and actual value conversion module; and finishing all the conversion and ending.
In one embodiment of the present invention, the step of converting PrismG a control account to EcoSys a platform item WBS comprises the steps of:
s2.1, separating ACCOUNT _ID into different groups according to separators in the Control records table ACCOUNT _ID read in the step S1, for example, separating the ACCOUNT _ID into groups of different types such as stages, factories and systems;
S2.2, splitting the class group according to the step S2.1, and carrying out sequencing combination again according to the coding sequence specified by the WBS to form WBS_ID which accords with the WBS specification, wherein the WBS attribute is marked as a CA level;
s2.3, setting a winning value algorithm of WBS_ID according to a corresponding earning value calculation method in a Control Account table ACCOUNT _ID;
S2.4, generating a 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 category group at the tail end according to the read WBS_ID to form a new WBS_ID, namely the WBS_ID of the father node of the node;
S2.7, judging whether the WBS_ID is contained in the WBS_ID list, if so, entering a step S2.5, and if not, entering a step S2.8;
s2.8, adding the new WBS_ID into the WBS_ID list;
S2.9, judging whether the WBS_ID only contains one class group, if so, setting the WBS_ID class as Project, then entering step S2.5, and if not, setting the WBS_ID class as WBS, and entering step S2.6;
S2.10, circularly reading each item ACCOUNT _ID and activity_ID according to a read Control Account/Activity Cross-reference table, entering step S2.11, and entering step S2.14 if the reading is finished;
S2.11, finding out the WBS_ID corresponding to ACCOUNT _ID according to the map of ACCOUNT _ID and WBS_ID,
S2.12, adding a child node 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 category to PLAN PACKAGE; returning to the step S2.10;
s2.14, completing PrismG the conversion from the control account to the 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 present invention, the converting PrismG software job activity plan start time and end time to EcoSys platform project plan job activity plan start time and end time includes the steps of:
s3.1, circularly and sequentially reading each WBS_ID list data; if the reading is finished, the step S3.8 is carried out; otherwise, entering a step S3.2;
S3.2, judging whether the WBS_ID class is PLAN PACKAGE, if so, entering a step S3.3; if not, entering step S3.1;
S3.3, acquiring the selected WBS_ID to obtain the last class group (job code), matching the last class group 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 WBS_ID from the last class group to obtain a father node of the WBS_ID;
s3.5, finding out a corresponding ACCOUNT _ID according to the parent node according to the ACCOUNT _ID and WBS_ID mapping table;
S3.6, finding out the BASELINE _CURVE_ID attribute in the Control errors table read in through the step S1 according to ACCOUNT _ID;
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;
S3.8, two modules plan the conversion of the starting time and the ending time.
In one embodiment of the present invention, the calculating the cost data and the cost resource in PrismG software to form the cost data and the cost resource corresponding to the project original budget in EcoSys platform includes the following steps:
S4.1, merging the data tables of the Budget Details read in the step S1 and Budget Details Cost Element, and summarizing to form a Budget table containing ACCOUNT _ID, budget_ID, engineering quantity, cost and working hours according to the Budget_ID;
S4.2, reading in the weight field number in the Control Account/Activity Cross-reference table according to the step S1, classifying according to ACCOUNT _ID, and calculating the percentage of each planned job under the same ACCOUNT _ID;
s4.3, obtaining the percentage of each planned operation under ACCOUNT _ID from the summarized budget table according to the step S4.2, and splitting the summarized budget table formed in the step S4.1 into the engineering quantity, the cost and the working time to each operation;
and S4.4, matching the split engineering quantity, cost and working hours to the WBS_ID corresponding to the ACCOUNT _ID and the activity_ID, and generating EcoSys an original budget table under the platform.
In one embodiment of the present invention, the conversion of the struggle and actual values of PrismG2 software history cycles to the struggle and actual values of EcoSys platform comprises the steps of
S5.1, inputting the struggle value, the engineering quantity, the working hours and the completion percentage in a table to a EcoSys platform according to each period through the ACCOUNT _ID in the read Control Account TIME PHASED DATE table and according to the ACCOUNT _ID and WBS_ID mapping table;
s5.2, inputting actual values in the table to the EcoSys platform according to each period according to the ACCOUNT _ID and WBS_ID mapping table by the ACCOUNT _ID in the read Control Account TIME PHASED DATE table.
Compared with the prior art, the method for converting PrismG model data into EcoSys model data automatically establishes EcoSys a WBS account of a platform according to the struggle value calculation method by reading a basic data model in PRISMG, reallocates budget and engineering quantity, and automatically converts an actual value and the struggle value. Not only improves the working efficiency and avoids human errors, but also integrally improves the project informatization management level and achieves the aim of the invention.
The features of the present invention will be apparent from the following detailed description of the preferred embodiments, taken in conjunction with the accompanying drawings.
Drawings
FIG. 1 is a schematic diagram of the structure of converting PrismG model data into EcoSys model data according to the present invention;
FIG. 2 is a schematic flow chart of the present invention for converting PrismG a control account to EcoSys a platform project WBS;
FIG. 3 is a flow chart of the present invention for converting PrismG a 2a software job campaign start time and end time to EcoSys a platform project plan job campaign start time and end time;
FIG. 4 is a flow chart of the present invention for calculating cost data and cost resources in PrismG software to form cost data and resources corresponding to the original budget of the project in EcoSys platform.
Detailed Description
The invention is further described with reference to the following detailed drawings in order to make the technical means, the creation characteristics, the achievement of the purpose and the effect of the implementation of the invention easy to understand.
Examples
As shown in fig. 1, the method for converting PrismG model data into EcoSys model data according to the present invention is implemented by using the following system modules:
A PrismG model data downloading module, wherein the PrismG model data downloading module is configured to read the data stored in the PrismG software into a program memory, so as to increase the subsequent processing and operation speed, and the downloaded data includes a total of 6 data tables including Control Accounts, budget Details, budget Details Cost Element, control Account/Activity Cross-reference, schedule Activities, and Control Account TIME PHASED DATE;
The control account conversion module is used for comparing and converting control accounts in the two software to form EcoSys platform projects WBS;
the original budget conversion module is used for calculating cost data and cost resources in PrismG software to form cost data and resources corresponding to the original budget of the project in the EcoSys platform;
A job activity conversion module for converting PrismG2 software job activity plan start time and end time into EcoSys platform project plan job activity plan start time and end time; and
And the earning value and actual value conversion module is used for converting the earning value and actual value generated in the PrismG software history period into the earning value and actual value module of the EcoSys platform.
The method for converting PrismG model data into EcoSys model data comprises the following steps:
S1, downloading data from a PrismG model data downloading module, wherein the data comprises 6 total data tables including Control Accounts, budget Details, budget Details Cost Element, control Account/Activity Cross-reference, schedule Activities and Control Account TIME PHASED DATE, and the total data tables are stored in a memory;
S2, converting PrismG a control account into EcoSys platform item WBS through a control account conversion module, and generating a WBS_ID (WBS code) mapping table of ACCOUNT _ID (control account code) EcoSys of PrismG;
as shown in fig. 2, the control account switching PrismG to EcoSys platform project WBS method comprises the steps of:
s2.1, separating ACCOUNT _ID into different groups according to separators in the Control records table ACCOUNT _ID read in step S1, for example, separating the ACCOUNT _ID into groups of different types such as stages, factories, systems and the like;
S2.2, splitting the class group according to the step S2.1, and carrying out sequencing combination again according to the coding sequence specified by the WBS to form WBS_ID which accords with the WBS specification, wherein the WBS attribute is marked as a CA level;
s2.3, setting a winning value algorithm of WBS_ID according to a corresponding earning value calculation method in a Control Account table ACCOUNT _ID;
S2.4, generating a 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 category group at the tail end according to the read WBS_ID to form a new WBS_ID, namely the WBS_ID of the father node of the node;
S2.7, judging whether the WBS_ID is contained in the WBS_ID list, if so, entering a step S2.5, and if not, entering a step S2.8;
s2.8, adding the new WBS_ID into the WBS_ID list;
S2.9, judging whether the WBS_ID only contains one class group, if yes, setting the WBS_ID class as Project, then entering step S2.5, if not, setting the WBS_ID class as WBS, and entering step S2.6;
S2.10, circularly reading each item ACCOUNT _ID and activity_ID according to a read Control Account/Activity Cross-reference table, entering into a step S2.11, and if the reading is finished, entering into a step S2.14;
S2.11, finding out the WBS_ID corresponding to ACCOUNT _ID according to the map of ACCOUNT _ID and WBS_ID,
S2.12, adding a child node 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 category to PLAN PACKAGE; returning to the step S2.10;
s2.14, completing PrismG the conversion from the control account to EcoSys platform project WBS.
A complete tree-like wbs_id list is formed by steps S2.1 to S2.14.
S3, converting PrismG software operation activity plan starting time and ending time into EcoSys platform project plan operation activity plan starting time and ending time through an operation activity conversion module;
As shown in fig. 3, converting PrismG a 2a software job campaign start time and end time to EcoSys a platform project plan job campaign start time and end time, comprising the steps of:
s3.1, circularly and sequentially reading each WBS_ID list data; if the reading is finished, the step S3.8 is carried out; otherwise, entering a step S3.2;
S3.2, judging whether the WBS_ID class is PLAN PACKAGE, if so, entering a step S3.3; if not, entering step S3.1;
S3.3, acquiring the selected WBS_ID to obtain the last class group (job code), matching the last class group 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 class group from the WBS_ID to obtain a father node of the WBS_ID;
s3.5, finding out a corresponding ACCOUNT _ID according to the parent node according to the ACCOUNT _ID and WBS_ID mapping table;
S3.6, finding out the BASELINE _CURVE_ID attribute in the Control errors table read in through the step S1 according to ACCOUNT _ID;
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;
S3.8, two modules plan the conversion of the starting time and the ending time.
S4, calculating cost data and cost resources in PrismG software through an original budget conversion module to form cost data and resources corresponding to the original budget of the project in the EcoSys platform;
As shown in fig. 4, the cost data and the cost resource in PrismG2 software are calculated to form cost data and resource corresponding to the project original budget in EcoSys platform, which includes the following steps:
S4.1, merging the data tables of the Budget Details read in the step S1 and Budget Details Cost Element, and summarizing to form a Budget table containing ACCOUNT _ID, budget_ID, engineering quantity, cost and working hours according to the Budget_ID;
S4.2, reading in the weight field number in the Control Account/Activity Cross-reference table according to the step S1, classifying according to ACCOUNT _ID, and calculating the percentage of each planned job under the same ACCOUNT _ID;
s4.3, obtaining the percentage of each planned operation under ACCOUNT _ID from the summarized budget table according to the step S4.2, and splitting the summarized budget table formed in the step S4.1 into the engineering quantity, the cost and the working time to each operation;
and S4.4, matching the split engineering quantity, cost and working hours to the WBS_ID corresponding to the ACCOUNT _ID and the activity_ID, and generating EcoSys an original budget table under the platform.
Thus, the planning reference data of EcoSys platforms are formed through the steps of step S1 to step S4.
S5, converting the struggle value and the actual value generated in PrismG software history period into the struggle value and the actual value of the EcoSys platform through a struggle value and actual value conversion module,
The conversion of the earned value and the actual value generated by PrismG software history period to the earned value and the actual value of EcoSys platform comprises the following steps of
S5.1, inputting the struggle value, the engineering quantity, the working hours and the completion percentage in a table to a EcoSys platform according to each period through the ACCOUNT _ID in the read Control Account TIME PHASED DATE table and according to the ACCOUNT _ID and WBS_ID mapping table;
s5.2, inputting actual values in the table to the EcoSys platform according to each period according to the ACCOUNT _ID and WBS_ID mapping table by the ACCOUNT _ID in the read Control Account TIME PHASED DATE table.
And finishing all conversion, finishing, and converting into EcoSys platform project struggling values and actual values.
Compared with the prior art, the invention has the following beneficial effects:
1. The method for converting PrismG model data into EcoSys model data avoids labor waste caused by manual conversion and greatly improves efficiency and quality.
2. According to the method for converting PrismG model data into EcoSys model data, according to actual data and struggle value data provided by PrismG software, the actual data and struggle value data are automatically imported into an Ecosys platform, the whole process is completed automatically, human intervention is not needed, the operation is simple and convenient, and the production efficiency is high.
3. The method for converting PrismG model data into EcoSys model data can greatly improve project management level, improve work efficiency of project management staff and promote effective engagement and collaborative cooperation of management teams; the method can be popularized and applied to the field of project management in China and industry, promotes the overall improvement of the project management level of the industry, and improves the international competitiveness of national and series nuclear power projects.
The foregoing has shown and described the basic principles and main features of the present invention and the advantages of the present invention. It will be understood by those skilled in the art that the present invention is not limited to the foregoing embodiments, which have been described in the foregoing embodiments and description merely illustrates the principles of the invention, and that various changes and modifications may be effected therein without departing from the spirit and scope of the invention as defined in the appended claims and their equivalents.
Claims (1)
1. A method of converting PrismG model data to EcoSys model data, comprising the steps of:
S1, downloading data from a PrismG model data downloading module, wherein the data comprises 6 data tables of a Control Account list Control Account, an original budget project amount list Budget Detai ls, an original budget cost list Budget Details Cost Element, a Control Account and job Activity relation table Control Account/Activity Cross-reference, a job Activity list Schedule Activities and Control Account history data Control Account TIME PHASED DATE which are stored in a memory;
s2, converting PrismG a control account into EcoSys platform item WBS through a control account conversion module, and generating WBS code WBS_ID mapping tables of control account codes ACCOUNT _ID and EcoSys of PrismG 2;
S3, converting PrismG software operation activity plan starting time and ending time into EcoSys platform project plan operation activity plan starting time and ending time through an operation activity conversion module;
S4, calculating cost data and cost resources in PrismG software through an original budget conversion module to form cost data and resources corresponding to the original budget of the project in the EcoSys platform;
S5, converting the struggle value and the actual value generated in the PrismG software history period into the struggle value and the actual value of the EcoSys platform through a struggle value and actual value conversion module; finishing all conversion and ending;
The step of converting PrismG a control account into EcoSys a platform project WBS comprises the following steps:
S2.1, separating ACCOUNT _ID into different groups according to the separator in ACCOUNT _ID in the Control records table read in step S1;
S2.2, splitting the class group according to the step S2.1, and carrying out sequencing combination again according to the coding sequence specified by the WBS to form WBS_ID which accords with the WBS specification, wherein the WBS attribute is marked as a CA level;
s2.3, setting a winning value algorithm of WBS_ID according to a corresponding earning value calculation method in a Control Account table ACCOUNT _ID;
S2.4, generating a 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 category group at the tail end according to the read WBS_ID to form a new WBS_ID, namely the WBS_ID of the father node of the node;
S2.7, judging whether the WBS_ID is contained in the WBS_ID list, if so, entering a step S2.5, and if not, entering a step S2.8;
s2.8, adding the new WBS_ID into the WBS_ID list;
S2.9, judging whether the WBS_ID only contains one class group, if so, setting the WBS_ID class as Project, then entering step S2.5, and if not, setting the WBS_ID class as WBS, and entering step S2.6;
S2.10, circularly reading each item ACCOUNT _ID and activity_ID according to a read Control Account/Activity Cross-reference table, entering step S2.11, and entering step S2.14 if the reading is finished;
S2.11, finding out the WBS_ID corresponding to ACCOUNT _ID according to the map of ACCOUNT _ID and WBS_ID,
S2.12, adding a child node 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 category to PLAN PACKAGE; returning to the step S2.10;
s2.14, completing PrismG the conversion from the control account to the EcoSys platform project WBS; forming a complete tree-shaped WBS_ID list through steps S2.1 to S2.14;
The converting PrismG the software job activity plan start time and end time into EcoSys platform project plan job activity plan start time and end time comprises the following steps:
s3.1, circularly and sequentially reading each WBS_ID list data; if the reading is finished, the step S3.8 is carried out; otherwise, entering a step S3.2;
S3.2, judging whether the WBS_ID class is PLAN PACKAGE, if so, entering a step S3.3; if not, entering step S3.1;
S3.3, acquiring the selected WBS_ID to obtain a last class group, matching the last class group with the activity_ID read in the ScheduleActivities table in the step S1, and assigning the start time and the end time in the Schedule Activities table to the planned start time and the planned end time of the WBS;
s3.4, removing the WBS_ID from the last class group to obtain a father node of the WBS_ID;
s3.5, finding out a corresponding ACCOUNT _ID according to the parent node according to the ACCOUNT _ID and WBS_ID mapping table;
S3.6, finding out the BASELINE _CURVE_ID attribute in the Control errors table read in through the step S1 according to ACCOUNT _ID;
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;
S3.8, two modules plan the conversion of the starting time and the ending time;
The cost data and cost resources in PrismG software are calculated to form cost data and resources corresponding to the project original budget in the EcoSys platform, and the method comprises the following steps:
S4.1, merging the data tables of the Budget Details read in the step S1 and Budget Details Cost Element, and summarizing to form a Budget table containing ACCOUNT _ID, budget_ID, engineering quantity, cost and working hours according to the Budget_ID;
S4.2, reading in the weight field number in the Control Account/Activity Cross-reference table according to the step S1, classifying according to ACCOUNT _ID, and calculating the percentage of each planned job under the same ACCOUNT _ID;
s4.3, obtaining the percentage of each planned operation under ACCOUNT _ID from the summarized budget table according to the step S4.2, and splitting the summarized budget table formed in the step S4.1 into the engineering quantity, the cost and the working time to each operation;
S4.4, matching the split engineering quantity, cost and working hours to the WBS_ID corresponding to the ACCOUNT _ID and the activity_ID to generate an original budget table under the EcoSys platform;
The conversion of the struggle value and the actual value generated by PrismG software history period to the struggle value and the actual value of EcoSys platform comprises the following steps:
S5.1, inputting the struggle value, the engineering quantity, the working hours and the completion percentage in a table to a EcoSys platform according to each period through the ACCOUNT _ID in the read Control Account TIME PHASED DATE table and according to the ACCOUNT _ID and WBS_ID mapping table;
s5.2, inputting actual values in the table to the EcoSys platform according to each period according to the ACCOUNT _ID and WBS_ID mapping table by 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 CN113570219A (en) | 2021-10-29 |
| CN113570219B true 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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Family Cites Families (3)
| 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 |
| JP6881930B2 (en) * | 2015-11-05 | 2021-06-02 | 株式会社オービック | Project accounting management device, project accounting management method, and project accounting management program |
| 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 (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113570219A (en) | 2021-10-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112001618B (en) | Method for integrating and optimizing construction period assignment, order acceptance and production scheduling | |
| CN111538731B (en) | Automatic report generation system for industrial data | |
| CN105354239A (en) | Configuration data processing model based processing center data stream processing method | |
| CN111612428A (en) | Project progress visualization method and system based on work structure decomposition | |
| CN112884455A (en) | Task plan processing system, method and device | |
| CN113570219B (en) | Method for converting PrismG model data into EcoSys model data | |
| CN107563089A (en) | The method and computing device of PC components generation task list based on BIM | |
| CN114707948A (en) | Management method, device and storage medium for large surveying and mapping production project | |
| CN105488271B (en) | A kind of oil gas module shaped steel automatic matching method | |
| CN100465888C (en) | Method for automatically establishing procedure body | |
| CN110765747A (en) | Project construction project service declaration and tabulation method | |
| CN108170989B (en) | Engineering construction model derivation method based on BIM technology | |
| CN113536422B (en) | BIM platform based on multiple selection sets and use method | |
| CN111950903B (en) | Method and device for generating railway engineering quota and engineering quantity based on template | |
| CN114896677A (en) | Construction simulation method and system based on BIM model | |
| CN111078664B (en) | Model-based system engineering data acquisition method and system | |
| Ding | A pairwise interchange solution procedure for a scheduling problem with production of components at a single facility | |
| CN114329896A (en) | Design change driven simulation change fast iteration method and device | |
| CN113065819A (en) | Digital twinning-based automatic capital transfer method and device for power distribution network engineering | |
| CN102662980B (en) | Automatic generation method for tender documents of power station | |
| CN109582710A (en) | A kind of method and system for realizing fixed point lookup to server by station number | |
| CN108763805B (en) | BIM-based plan management system and method | |
| CN118505162B (en) | Method and system for automatically planning deep design task | |
| CN118364783B (en) | BIM model and planning task automatic hooking method and system | |
| CN114048975A (en) | Performance assessment method, system, equipment and storage medium |
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 | ||
| 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. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |