CN108805420A - A kind of management method suitable for the progress monitoring of small design institute - Google Patents
A kind of management method suitable for the progress monitoring of small design institute Download PDFInfo
- Publication number
- CN108805420A CN108805420A CN201810498452.5A CN201810498452A CN108805420A CN 108805420 A CN108805420 A CN 108805420A CN 201810498452 A CN201810498452 A CN 201810498452A CN 108805420 A CN108805420 A CN 108805420A
- Authority
- CN
- China
- Prior art keywords
- excel file
- excel
- profession
- professional
- statistics
- 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
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/0631—Resource planning, allocation, distributing or scheduling for enterprises or organisations
- G06Q10/06311—Scheduling, planning or task assignment for a person or group
-
- 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/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- 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/10—Office automation; Time management
- G06Q10/109—Time management, e.g. calendars, reminders, meetings or time accounting
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Operations Research (AREA)
- Marketing (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Development Economics (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a kind of management methods suitable for the progress monitoring of small design institute, it is characterized in that, the technology major for including by designing institute, mechanical discipline, piping profession, instrument profession, electric specialty, Civil Specialities, general layout, water disappear profession be fabricated to technology major EXCEL file respectively, mechanical discipline EXCEL file, the professional EXCEL file of piping, instrument profession EXCEL file, electric specialty EXCEL file, Civil Specialities EXCEL file, general layout EXCEL file, water disappears professional EXCEL file, the total designing institute's EXCEL file of a designing institute is made simultaneously.The present invention, as tool software, is not necessarily to extra purchase and professional training using the office software EXCEL being widely used at present, and use cost is low, convenient for promoting, and it is with strong points, it is more suitable for management of the small design institute to progress monitoring.
Description
Technical field
The present invention relates to project management techniques fields, especially a kind of manager suitable for the progress monitoring of small design institute
Method.
Background technology
There are many existing Project Management Software, and such as external Project Management Software has：P3,Artemis Viewer, Open
The softwares such as WorkBench, OpenPlan, these softwares are suitble to large-scale, complicated project Project Management；Domestic project pipe
Reason software has：General China Tech skill (1992), Toone scientific and technological (2003), Newgrand (1993), wide connection reach (1998) etc., this
A little softwares are substantially to be developed on the basis of foreign Project Management Software.These be unsuitable for small design institute into
Degree control management, can not also be associated three-level plan with the designer of each profession, while shifting to an earlier date to each timing node
Early warning carries out working hour distribution to designer and summarizes.And no matter domestic, external software, it is tens of thousands of or even hundreds of thousands easily
Acquisition expenses allows small design institute to be even more to hang back.
Invention content
Place against the above deficiency, the purpose of the present invention is to provide a kind of pipes suitable for the progress monitoring of small design institute
Reason method mainly solves demand of the small design institute to progress monitoring management, while the software overhead for avoiding extraneous expense high.
To achieve the goals above, the technical solution adopted by the present invention is as follows：
A kind of management method suitable for the progress monitoring of small design institute, which is characterized in that the technique for including by designing institute
Profession, mechanical discipline, piping profession, instrument profession, electric specialty, Civil Specialities, general layout, water disappear professional to be fabricated to respectively
It is technology major EXCEL file, mechanical discipline EXCEL file, the professional EXCEL file of piping, instrument profession EXCEL file, electrical
Professional EXCEL file, Civil Specialities EXCEL file, general layout EXCEL file, water disappear professional EXCEL file, make simultaneously
The total designing institute's EXCEL file of one designing institute, wherein designing institute's EXCEL file includes that project completes information, delay
Rate statistics, general plan underlying table, the project completes information and retardation rate statistics is called the information of general plan underlying table and led to
The PivotTables function calculating for crossing EXCEL goes out result；A~I in the general plan underlying table is classified as project and starts initial stage volume
System 1 grade, 2 grades plan and the data by designing institute staff planners' external input,
Wherein, the technology major EXCEL file, mechanical discipline EXCEL file, piping profession EXCEL files, instrument
Professional EXCEL file, electric specialty EXCEL file, Civil Specialities EXCEL file, general layout EXCEL file, water disappear profession
EXCEL file includes project basis table, working hour distribution, monthly man-hour data statistics, designer's task count, check and correction task counts,
Audit task counts；A~I of project basis table is arranged corresponds to column data input by designing institute EXCEL, and J~N is arranged to be corresponded to by designing institute
Temporally progress inputs personnel；C is arranged in working hour allocation table carries out working hour distribution, F~Q row by professional manager to designers at different levels
It is voluntarily inputted by designers at different levels；When monthly man-hour data statistics are summarized designer labourer hired by the month at different levels by pivot table automatically；Design
People's task statistics, check and correction task statistics, audit task statistics are summarized the workload of designers at different levels by pivot table automatically.
Compared with prior art, the invention has the advantages that：
The present invention, as tool software, is not necessarily to extra purchase using the office software EXCEL being widely used at present
And professional training, use cost is low, convenient for promoting, and it is with strong points, it is more suitable for management of the small design institute to progress monitoring.
Specific implementation mode
With reference to embodiment, the invention will be further described, and embodiments of the present invention include but not limited to following reality
Apply example.
A kind of management method suitable for the progress monitoring of small design institute, the technology major for including by designing institute, equipment are special
Industry, piping profession, instrument profession, electric specialty, Civil Specialities, general layout, water disappear professional is fabricated to technology major respectively
EXCEL file, mechanical discipline EXCEL file, the professional EXCEL file of piping, instrument profession EXCEL file, electric specialty EXCEL
File, Civil Specialities EXCEL file, general layout EXCEL file, water disappear professional EXCEL file, while making a designing institute
Total designing institute's EXCEL file, wherein designing institute's EXCEL file includes that project is completed information, retardation rate statistics, amounted to
Underlying table is drawn, the project completes information and retardation rate statistics calls the information of general plan underlying table and the number by EXCEL
Go out result according to pivot table function calculating；A~I in the general plan underlying table is classified as 1 grade, 2 grades that project starts initial stage establishment
Plan and the data by designing institute staff planners' external input,
Wherein, the technology major EXCEL file, mechanical discipline EXCEL file, piping profession EXCEL files, instrument
Professional EXCEL file, electric specialty EXCEL file, Civil Specialities EXCEL file, general layout EXCEL file, water disappear profession
EXCEL file includes project basis table, working hour distribution, monthly man-hour data statistics, designer's task count, check and correction task counts,
Audit task counts；A~I of project basis table is arranged corresponds to column data input by designing institute EXCEL, and J~N is arranged to be corresponded to by designing institute
Temporally progress inputs personnel；C is arranged in working hour allocation table carries out working hour distribution, F~Q row by professional manager to designers at different levels
It is voluntarily inputted by designers at different levels；When monthly man-hour data statistics are summarized designer labourer hired by the month at different levels by pivot table automatically；Design
People's task statistics, check and correction task statistics, audit task statistics are summarized the workload of designers at different levels by pivot table automatically.
Specifically with designing institute：
Using the summary table of 8 professions and designing institute that EXCEL softwares include according to designing institute, 9 EXCEL texts are made altogether
Part.
" T001_ designing institutees " file, including 3 worksheets：It is " 1, project complete information " " 2, retardation rate statistics " respectively
" 3, project basis table ".Data in preceding 2 tables are all the specific datas called in " 3, project basis table ", pass through hind computation
It is going out as a result, using the pivot table function of EXECL.
In " 3, project basis table ", A~I row are that project starts 1 grade of initial stage establishment, 2 grades of plans, by the plan of designing institute
Personnel are responsible for filling in.J~Q row are formula and call the result of other files (data in each profession table).Master is to be used
It is the IF formula and VLOOKUP formula of EXCEL.Wherein " early warning " row are set as triggering prompt in 2 days before planned time node.
" T002_ technology majors " file, including 6 worksheets：It is " Process Plans underlying table " " working hour distribution " " moon respectively
Spend man-hour data statistics " " designer's task statistics " " check and correction task statistics " " audit task statistics ".
A~the I of " Process Plans underlying table " is arranged, and A~I row of " T001_ designing institutees " file are directly replicated by professional manager,
It needs to be screened according to profession before replicating.J~N is arranged, and personnel placement and professional time requirement, note are filled in by professional manager：
Professional time requirement cannot be later than the time requirement of designing institute.O is arranged fills in task completion time by designer, and Q~S is arranged, by
The formula automatic decision of EXCEL simultaneously shows result.T is classified as remarks row, records late reason, is responsible for filling in by designer.
C is arranged in " working hour distribution " table, and working hour distribution is carried out to designers at different levels by professional manager.F~Q is arranged, and is set by different levels
Meter people fills in the working hour of this month.
" monthly man-hour data statistics " table, when summarizing each labourer hired by the month of designers at different levels automatically by pivot table.
" designer's task statistics " " check and correction task statistics " " audit task statistics " 3 tables, are summarized each automatically by pivot table
The workload of grade designer.
" T003_ mechanical disciplines " " T004_ pipings profession " " T005_ instrument profession " " T006_ electric specialties " " T007_ soil
Build profession " " T008_ general layouts " " T009_ water disappear profession " similar with " T002_ technology majors " table.
Above-described embodiment is merely a preferred embodiment of the present invention, and it is not intended to limit the protection scope of the present invention, as long as using
The design principle of the present invention, and the non-creative variation worked and made is carried out on this basis, it should all belong to the present invention's
Within protection domain.
Claims (1)
1. a kind of management method suitable for the progress monitoring of small design institute, which is characterized in that the technique for including by designing institute is special
Industry, mechanical discipline, piping profession, instrument profession, electric specialty, Civil Specialities, general layout, water disappear professional is fabricated to work respectively
Skill profession EXCEL file, mechanical discipline EXCEL file, the professional EXCEL file of piping, instrument profession EXCEL file, it is electrical specially
Industry EXCEL file, Civil Specialities EXCEL file, general layout EXCEL file, water disappear professional EXCEL file, while making one
The total designing institute's EXCEL file of a designing institute, wherein designing institute's EXCEL file includes that project completes information, retardation rate system
Meter, general plan underlying table, the project completes information and retardation rate statistics is called the information of general plan underlying table and passed through
The PivotTables function calculating of EXCEL goes out result；A~I in the general plan underlying table is classified as project and starts initial stage establishment
1 grade, 2 grades plan and the data by designing institute staff planners' external input；
Wherein, the technology major EXCEL file, mechanical discipline EXCEL file, the professional EXCEL file of piping, instrument profession
EXCEL file, electric specialty EXCEL file, Civil Specialities EXCEL file, general layout EXCEL file, water disappear professional EXCEL
File includes project basis table, working hour distribution, monthly man-hour data statistics, designer's task statistics, check and correction task statistics, audits and appoint
Business statistics；A~I of project basis table is arranged corresponds to column data input by designing institute EXCEL, and J~N is arranged to be pressed by designing institute counterpart personnel
Time schedule inputs；C is arranged in working hour allocation table carries out working hour distribution by professional manager to designers at different levels, and F~Q is arranged by different levels
Designer voluntarily inputs；When monthly man-hour data statistics are summarized designer labourer hired by the month at different levels by pivot table automatically；Designer's task
Statistics, check and correction task statistics, audit task statistics are summarized the workload of designers at different levels by pivot table automatically.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810498452.5A CN108805420A (en) | 2018-05-23 | 2018-05-23 | A kind of management method suitable for the progress monitoring of small design institute |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810498452.5A CN108805420A (en) | 2018-05-23 | 2018-05-23 | A kind of management method suitable for the progress monitoring of small design institute |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108805420A true CN108805420A (en) | 2018-11-13 |
Family
ID=64091482
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810498452.5A Pending CN108805420A (en) | 2018-05-23 | 2018-05-23 | A kind of management method suitable for the progress monitoring of small design institute |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108805420A (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1855135A (en) * | 2005-04-18 | 2006-11-01 | 上华资讯科技股份有限公司 | Human resource salary management and computer system |
| US20090319312A1 (en) * | 2008-04-21 | 2009-12-24 | Computer Associates Think, Inc. | System and Method for Governance, Risk, and Compliance Management |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN102955982A (en) * | 2011-08-18 | 2013-03-06 | 大连博特软件科技有限公司 | System for managing construction project contracting |
| CN103714492A (en) * | 2014-01-02 | 2014-04-09 | 广西电网公司电力科学研究院 | Automatic report generating method capable of meeting power distribution network management specific data standards |
| CN205262429U (en) * | 2015-12-30 | 2016-05-25 | 中铁三局集团华东建设有限公司 | Job site earth volume survey system |
| CN107464038A (en) * | 2017-07-06 | 2017-12-12 | 甘肃省科学院自然能源研究所 | The design method and system of a kind of solar photo-voltaic power generation station |
| CN107818398A (en) * | 2017-09-28 | 2018-03-20 | 浙江盛达物联科技股份有限公司 | Form and tolerance tool management system in bearing manufacture process |
-
2018
- 2018-05-23 CN CN201810498452.5A patent/CN108805420A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1855135A (en) * | 2005-04-18 | 2006-11-01 | 上华资讯科技股份有限公司 | Human resource salary management and computer system |
| US20090319312A1 (en) * | 2008-04-21 | 2009-12-24 | Computer Associates Think, Inc. | System and Method for Governance, Risk, and Compliance Management |
| CN102955982A (en) * | 2011-08-18 | 2013-03-06 | 大连博特软件科技有限公司 | System for managing construction project contracting |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN103714492A (en) * | 2014-01-02 | 2014-04-09 | 广西电网公司电力科学研究院 | Automatic report generating method capable of meeting power distribution network management specific data standards |
| CN205262429U (en) * | 2015-12-30 | 2016-05-25 | 中铁三局集团华东建设有限公司 | Job site earth volume survey system |
| CN107464038A (en) * | 2017-07-06 | 2017-12-12 | 甘肃省科学院自然能源研究所 | The design method and system of a kind of solar photo-voltaic power generation station |
| CN107818398A (en) * | 2017-09-28 | 2018-03-20 | 浙江盛达物联科技股份有限公司 | Form and tolerance tool management system in bearing manufacture process |
Non-Patent Citations (3)
| Title |
|---|
| 王小远等: "EXCEL在综合布线工程进度控制中的应用", 《计算技术与自动化》 * |
| 秦继红: "Excel计划表在上海环球金融中心进度管理中的应用", 《施工技术》 * |
| 邱庆媛: "项目管理中EXCEL的应用", 《数字通信世界》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10788815B2 (en) | System and methods for managing process and attribute changes to a product in a manufacturing environment | |
| CN103246603B (en) | A kind of software deficiency report automatic distributing method of defect tracking system | |
| US10664783B2 (en) | System and methods for managing changes to a product in a manufacturing environment including conversion of an engineering bill of material to a manufacturing bill of material | |
| US10725453B2 (en) | System and methods for managing changes to a product in a manufacturing environment including a minor model relational design | |
| CN110532534A (en) | The method and apparatus for generating engineering value document | |
| CN110727983A (en) | BIM modeling method for public medical building | |
| CN104899401A (en) | Aircraft research & development process and adjoint acknowledge combined method | |
| Połoński | Application of the work breakdown structure in determining cost buffers in construction schedules | |
| CN108805420A (en) | A kind of management method suitable for the progress monitoring of small design institute | |
| CN103761604A (en) | Method and device for conforming completion of report data compilation | |
| CN107193559A (en) | A kind of complication system virtual Prototype method based on meta-model | |
| CN201936346U (en) | IT audit accessory system | |
| CN113706086A (en) | Bridge construction quality measurement change progress plan management data structure design | |
| RU103014U1 (en) | HARDWARE AND SOFTWARE COMPLEX OF THE AUTOMATED SYSTEM FOR THE DEVELOPMENT OF TECHNOLOGICAL PROCESSES | |
| US10162342B2 (en) | System and methods for managing changes to a product in a manufacturing environment including an anytime design check | |
| CN106022944B (en) | Data volume conversion method and device for conventional and streamline models in numerical reservoir simulation | |
| JP4383295B2 (en) | Evaluation method of hydraulic importance of pipeline | |
| Marichev et al. | Experience of implementing BIM technology in the company of the old and new sample | |
| Crawford et al. | Wastewater Information Management System: Flow Modeling and Sewer Connection Permit Applications | |
| DE102004020868A1 (en) | Method and apparatus for designing a computer system | |
| JP6121950B2 (en) | Disaster recovery plan creation method and creation device | |
| Chengmeng | An analysis of the cost of the application of ERP system | |
| CN109981620A (en) | A kind of back office interface management system | |
| CN105335461A (en) | System and method for quickly writing fact value of XBRL instance document | |
| Davis et al. | Developing a Computer Program for Distribution System Analysis |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181113 |