Secondary development of Microsoft project management software
Aviation Industry Corporation 625 Wang Shusen Abstract: This article is mainly to talk about the advanced function of the Microsoft Corporation project software, the report intuitive, and the schedule can automatically generate the advantages of time ruler by user requirements. In order to better play the advantages of Microsoft project management software in the enterprise, it is necessary to develop secondary development. The Microsoft Project Management Software obtained by the user has no source. In this case, it is difficult to develop, and how to deal with this problem. In the end, how to achieve objective requirements, and throw some experience to make everyone in Microsoft Project Management Software. It is given in secondary development. Key words: project management, planning, software, secondary development. Microsoft Project (hereinafter referred to as MS Project) is developed by different people and organizations in the early 20th century. After the Second World War, due to the large-scale large complexity and complexity of the military project, the US Secret of Defense and relevant contractors have made a lot of contributions. During the same period, the development of electronic computers has made a large number of calculations required for thousands of tasks and resource arrangements. With the rapid development of computer science and technology, world humanity has gradually moved to the era of information technology, and the application of project management tools is quite common. It is also applicable to large projects, but also for small projects, personal computer (PC) popularization All managers have the opportunity to contact the project management tool. Although project management technologies are always used in national defense and construction industries, it has been used in the production, service industry and government departments in recent decades. Due to the comprehensive deepening of my country's reform and opening up and the rapid development of the market economy, the application of project management tools has gradually promoted in all walks of life in China. I. MS Project4 Project Management Software Introduction MS Project4 is a Microsoft Project Management Software 4.0 version. It is a very good project management software launched by Microsoft in 1994. It recently launched a new version project98. MS Project4 is from the leading position of project management software from project management software regardless of the processing power of tasks or resources, or its chart intuitive, time, and friendly interface design. Project management includes all phases of the project --- From the planning phase until the end, the status of the status of each stage task is displayed to people, and various summary reports completed by the project; if your project goals It has been decided, you can use MS Project4 to perform the following project management work: establish a progress schedule: Once the project objective is determined, you can use MS Project4 to develop a progress plan for your project; to establish a project schedule, you need to do it. Tasks and them need time, and then clear the task needs to be completed before the start of the task. After entering the project information, the system automatically generates the progress period of the project (Duration). Allocate the resources and costs of the task: You can establish a progress schedule that does not have to add resources and costs to tasks, or all resources and costs can also be assigned to the corresponding task establishment schedule. Optimized Project Progress Schedule: When the project's task information is input, the resources and cost have been linked to the relevant tasks, the relevant personnel analyzes, evaluates, evaluates, all tasks and completion, and the entire project plan. Whether it is consistent with the purpose of the original goal, if the cost is often exceeded by the budget, the entire completion date is dragged, it is convenient to control the task, adjust the schedule, so that it achieves the ideal situation. The actual implementation of the monitoring project: Because the best plan will also appear in actual implementation, through the tracking schedule, you can find what tasks need to pay special attention, adjustment in time to make the project smoothly.
MS Project4 Project Management Software has the following features: Scheduled Gantt Chart can be easily established: ID number, task name, start time, completion time, completion amount, etc. The user can freely select the number of items as needed. Gantt Chart On Mission Editor: Task Items Conveniently, Insert, Move, Copy, Resection, Paste, Modification, Delete, Recovery, etc. Signs of key tasks and milestones: Key tasks are tasks that their delay causing delayed project delays, key tasks are marked on critical paths. Milestones are an important landmark, development or turning point in the project life; in general, use it to mark an important part of the project, it does not mean that it is doing a job, only indicates that this work has begun or has ended. Task relationships agreement: Microsoft Project Management provides four different task relationships (end to start FS, starting to start SS, starting to ending sf). Summarize a project: Summary is a way to organize tasks, which can see the structure of the project; a total task (Summary Task) Dimming processing, the subtask can be reduced to indent, you can see the details of the secondary task The same task can also be upgraded. Task and resource contacts and provide resource super-allocation: When resource is allocated, the resource name is displayed on the resource usage and displays it to be exceeded and exceeded. Schedule Gantt Chart has an intuitive time ruler: Time Rod has annual, quarter, month, week, day, hour, division and working day, users can choose freely. MS Project4 has a variety of views: Gantt Chart, Network Diagram (Pert), Resource Sheet, Resource USAGE, Resource Graph, etc.). MS Project4 and other applications can be communicated: can copy item information into ODBC database format, Microsoft Excel, Microsoft Word, Lotus1-2-3 and other data and charts to MS Project4, and vice versa. In view of the advanced nature of MS Project4 software and the practicality of multi-purpose, it has been used in more and more people at home and abroad. Second, the background of MS Project4 Secondary Development Although the Microsoft project management software is very strong, it is in the leading position in the project management software, but it can't be satisfied in any situation, it has its own limitations, this is the second development premise. Microsoft Project Management Software is managed on a single-stage scheduled project, regardless of the task item, how complicated projects, how many task resource allocation involves the relationship, it has shown superiority, improvement and convenience. If a large complex project is used to decompose a multi-level schedule control with a work decomposition structure (WBS: Work Breakdown Structure) method, the information step-by-step schedule is automatically summarized from the completion of the task from the lower level schedule. Track, until the top floor plan, the task is completed or not completed, using different colors, this level of schedule is clearly reflected in real implementation. According to the proportion of no completion, it is divided into a few-level alarms to show a warning, giving people how many days, dragging the task is less; in order to catch up with the progress to provide a control plan, prompt to increase how much work per day How much human and equipment. This multi-level scheduled automatic tracking, alarms, and control for MS Project4 is unable to implement automatic summary tracking, which is always in charge of several progress plans in the following level, and summary map cannot be changed. This is not a multi-level schedule of the WBS method we need.
The real multi-level schedule is that the higher-level scheduled task items are included in the lower level schedule, and the sub-level schedule task item can be more than the superior schedule task item, the superior schedule is summary, the lower level schedule is the superior schedule Decomposition. In short, this multi-level scheduled automatic tracking, alarm, and control of Microsoft project management software cannot be implemented. MS Project4 software can only give an orders from a single-generation network diagram (PERT map) and the single-generation PERT map and Gantt Chart, and many people in my country are used to the double code network map (PERT map), I hope to draw The double code network diagram and implements the double code number PERT map to the Gantt chart. In order to achieve the above requirements, MS Project4 software must be carried out secondary development. Maybe someone will ask if it can develop a project management software that meets the above requirements? The answer is definitely not! We have mentioned that Microsoft Project Management Software has a leading level in all aspects of processing capabilities of tasks and resources, and developing a high level of project management software is not a simple job. Although there are many two development. Difficulties, but it is easy to work relative to re-development. Third, the key technologies for the second development of MS Project4 software MS Project4 is the copyright software of Microsoft. Microsoft has modified and expanded to the software. It is easy to develop secondary development, not a matter of easy things. The passive program is to know the internal structure and mechanism of its software, and the technical gap that wants to open the secondary development of software, there is a few key technologies to be resolved. Through our practical experience of MS Project4 software, there are two key technologies mainly: 1. First Key Technology ---- Understanding this software information format (data format) information format is nothing more than software input, output and What is the nature of internal processing information, is a general file or a database, the file is the order file, random file, binary file, database, and the database is what database is; Of course, I only know that the nature of the information is still not enough for software, but also understand information. Internal specific representation, such as the field number, field name, field nature, field size in relational database records. If this step should be found in the information format of the software, it should be said that the second development has been initially found. In fact, there are many difficulties often do this step, and you need a lot of time to study and explore. This requires the specific process of software developers, such as MS Project4 software, does not give internal processing file (* .mpp) format, non-Microsoft's developer's specific format of Project4 * .MPP is quite difficult, but Project4 The software gives the specific format of the intermediate file (* .mpt), and gives the method of * .mpp and * .mpt file conversion, there is no need to make a lot of strength to study the software internal information format (*. MPP), just carefully analyze the meaning of each item of * .mpt file, how to use the * .mpt file. 2. Second Key Technology ---- Communication Interface (Information Call Interface) Talking about MS Project4 has given the * .mpt intermediate file format, which provides a means for secondary development. The Chinese Academy of Sciences has developed the MS Project4's Gantt chart to the DOS environment with this method. This method can also achieve our secondary development of MS Project4, but this method does not give full play to the ability of MS Project4 to exchange data with other applications, such as OLE technology. Through our analysis, it was found that the secondary development of the secondary development of the intermediate file (* .mpt) is complicated with the secondary development of communication interface technology. In addition, the integration of software and original software in this second development is loose integration, sometimes It is not necessary to ensure that it is necessary to integrate in the original software operation environment, in order to better integrate in the original software, it is also necessary to study the communication interface of the original software. The communication interface can be narrowly understood as an external interface called for the original software and other application software.
The method of studying the communication interface mechanism can master the method of processing information for the original software. With this method, you can develop a program that calls the internal information of the original software, it will again develop software integrated in the original software operation environment, will reach the original software The requirements for new features. Fortunately, MS Project4 provides technology that supports communication interface. Microsoft project management materials generally mention that MS Project4 can be exchanged with other applications, but here is the MS Project4 and Microsoft Word or Microsoft Excel. Document copy and paste; this information call method is too thick to the secondary development, and cannot be used directly. Also have more in-depth research information calling methods. It is mainly to use MS Project4 to support OLE technology, directly studying the specific agreement of the original software communication interface, so that Microsoft project management software can be used to develop secondary development. Understanding how the original software uses OLE technology, especially the communication interface, that is, the specific information call method is not a matter of easy things. This depends on the extent to which developers are familiar with Windows, MS Project4, OLE technology, VB, VBA, Visual C language; if you are more familiar with the above knowledge, you can open the secondary development of the communication interface. If the above knowledge is not familiar, there are a lot of difficulties to open this path, and to study greater energy. IV. The secondary development method and results of Microsoft Project Management Software have been introduced above. We use the information calling method of the communication interface to the MS Project4 twice, and the user's use requirements are completed, which should be said to MS Project4 software. Successfully expanded. 1. Secondary development method In the Windows environment, use OLE technology, database technology, Windows API functions, VB, and Visual C languages, which can be done well completed secondary development. For example, use VB language as an example, establish OLE Automation with the statement, open the Project file, and request it according to the required Project items, display or print. Specific methods How to establish OLE Automation, how to open the Project file, how to request each information of Project files, how to read and write a database, etc. The specific program details of how to read and write the database are not listed here; if an interest can refer to the example and macro of MS Project4, this The source program written in VB or VBA language is given in detail, and the established OLE automation is described in detail, open the Project file, etc. However, in the more detailed information used in secondary development and the above examples can be found, the project macro record function can be used to generate the macro you need, and the statement of these macros can meet your needs. It is also a point in which the borrowing macro's statement is best used for version programming of VB4 language or more. 2. Secondary development results Multi-level schedule planning, alarm and control of Gantt chart. The usage example of aircraft manufacturing schedule is given below. Supervisory unit and task name progress plan Name WBS number head office supervisor accesses the entire aircraft zero-level schedule First-level schedule of various aircraft production plans WBSII factory division of various workshop secondary progress plans to subordinate sections of the workshops The third-level schedule WBSIV above the above table lists a diagram of multi-level schedule controlled by aircraft production, such as a complex project, there are tens of thousands of people engaged in the same project from different locations outside a thousand miles, and it is difficult to use artificial methods. Implementing the true reflection of the lower level plan and effectively controls the high-level plan. The lower level plan is often added to the upper level plan, and the progress plan is not authentic, so that the higher leaders cannot find problems in time, so that the progress plan is not subject to time-control, often drags. In order to avoid the discretion of the progress plan, the second-development MS Project4 software can do the completion of the top three-level schedule to the zero-level scheduled scheduled schedule, and the real reflects the progress plan execution.
Since the secondary development software has alarm function, the tasks of the scheduled scheduled program are not completed, according to the requirements of the task, according to the importance of the task, determine the three-level rating factor (weighted coefficient) K, the task does not complete the percentage C% by the grade coefficient k, The three-level alarm threshold is determined in advance, gives a three-level alarm, and the three-level alarm is expressed in three different colors (yellow, purple, red) on the progress plan. And give additional alarm information (the unfinished task workload of the drag, how many days are dragged, and how much workload needs to be increased daily according to the original progress. At the same time, it is recommended to implement control measures, work overtime, diverted tasks, modification plans, and various control schemes shall be implemented by different level leaders. In this case, leaders will promptly grasp the implementation of the progress plans at all levels, timely control the progress plan, eliminate the true completion of the artificial modification schedule, reduce the human part, to ensure that the progress plan is completed on time and provides a strong means. The WBS number is given in the above table for contact between the scheduled schedules. ] Another important result of the second development of MS Project4, plotting the progress plan double code network diagram (PERT chart) in the Windows environment, and the user has a convenient drawing task item, editing task item, connection task relationship on the time scale view, Drag the task item, task Item Synthetic Task Group, Time Scale User You can use it as convenient as MS Project4 software, and the two-code network map can be used in English, Chinese or English. More importantly, the software implements Microsoft Project Management Software Schedule Gantti and Scheduling Double Code Network Map (PERT) Mutual conversion, and can be changed on the view after conversion. V. The application prospect of Microsoft Project Management Software Secondary Development This software has been used for the zero-level, first-level schedule of the private machine production, and the double code network drawing and progress plan double code network diagram and Gantt chart. Mutual conversion. Next year will be used in the production of zero, first-level, second-level schedules tracking, alarms, and control. It is also possible to promote tracking, alarms, and control of production schedules, engine, and auxiliary production schedules in the air enterprise in the future. The secondary development schedule tracking, alarm and control of Microsoft Project Management Software can be promoted to large project management of multi-level schedule control of enterprises and institutions, especially in producing companies with international cooperation, more showed the secondary development software. Superiority. The secondary development of the secondary development of Microsoft Project Management Software and the conversion of MS Project4 Gantt Chart can be widely used in the plan management of all walks of life with Microsoft project management software, convenient to the progress plan Gantt chart Double code network diagram, which is the same. Double code network drawing can also be independent of MS Project4 software, which is widely used to draw bidding and schedule control of the double code network diagram project. Since the use is simple and convenient, the function is relatively complete, especially like MS Project4, has a variable time scale as MS Project4; has a wide range of application prospects. Since Microsoft Project Management Software can control resources while controlling the progress plan, it provides a variety of views and a large number of intuitive reports, and the project management functions and many advantages, plus it in the leading position in project management software, We believe that large enterprise production management information system software can develop secondary development in the MS Project foundation. Enterprise production management information systems are not uniformly managed by the property of supply and marketing people, and the core of management is the control schedule and resource, and Microsoft project management software is providing this foundation. Management Information Systems, Production Program, Production Capacity Demand Plan, Material Demand Plan, Try Demand Program, Cost Accounting Management can be implemented secondary development on MS Project software. Manage information system process management, sales management, human demand management, property management, quality management, etc. can be developed in VB or Visual C languages based on the database. The development of these two parts is based on the database, and it can be integrated through its own development of communication interface. The integration of the management information system starts from the demand analysis, and the internal communication interface of each subsystem is determined, and the integration of each subsystem is always coordinated.
