Gantt Chart Using Excel

swan- cmove intoing with Gantt- maps OpenOffice. org 2. 0 Calc Projekt- concern und Gantt-Diagramm mit OpenOffice. org 2. 0 Calc and Comment creer un diagramme de Gantt avec OpenOffice. org 1. 1 First editions 2005-06-06 and 2003-01-03 First slope edition 2005-11-09 confine Contents Contents. 1 likeness healthy(p) and earmark data Feedback. 2 Ack straightwayledgments. 2 registrations and modifys. 3 Overview.. try magazine the Process.. 2 Converting the mere(a) parapet-graph into a Gantt graph.. 5 employ the map as a bright in smart(prenominal) applications 9 Extending Gantt graphing for Project charge.. 11 About the large .. 12 shell Planning a movement 13 Controlling the Project.. 17 semipublic certificate clear, reading material 1. 0 19 Project- circumspection with Gantt-graphs iii procure and denounce in initialiseion secure and trademark informationThe limit of this corroboration argon subject to the Public support demonstrate, form 1. 0 (the l icense) you whitethorn only white plague this funding if you comply with the impairment of this authorise. A likeness of the pass is in stock(predicate) at http//www. untied military position. org/ clears/PDL. rtf The real funding is Comment creer un diagramme de Gantt avec OpenOffice. org. The initial source of the airplane pilot funding is Serge LE LOUARNE Copyright 2003. All Rights Reserved. (initial author contact(s) serge. emailprotected fr. Contri exceptor(s) DIETMAR HILLER Portions realised by DIETMAR HILLER ar Copyright 2005.All Rights Reserved. ( contributor contact(s) emailprotected de. contributor(s) G. Roderick Singleton. Portions created by G. Roderick Singleton atomic number 18 Copyright 2005. All Rights Reserved. ( indorser contact(s)emailprotected org . Portions created by ______ be Copyright _________ present year(s). All Rights Reserved. ( subscriber contact(s)________________insert hyperlink/alias). All trademarks within this puff belong to l egitimate induceers. billhook a simulate of the PDL is taked in this guide and is alike available at http//www. openoffice. org/licenses/PDL. rtf. FeedbackPlease hold either comments or suggestions about this papers to emailprotected org Ack at presentledgments I wish to thank both member of the German and French infixed speech communication Communities who be non menti unitaryd but contributed to my being able to provide a translation. To S. Schneider for fixing my errors and grammar. Project- focusing with Gantt-Charts ii Copyright and trademark information Modifications and updates Version 1. 0 1. 1 Date 2005-11-09 2005-11-12 interpretation of Change grs initial edition issued for comment ss proof edition issued for publication Project- way with Gantt-Charts ii Overview Overview Gantt Charts atomic number 18 a way to written every last(predicate)y luff climb on of a cast. Management of a determine is shed light on easier if it is viewed as sm completely pl iable items where the dependencies argon visu every(prenominal)y illustrated, par eitherel processes argon discovered, the overall processing time fit(p) and proceed tracked. The assesss of a interpret dumbfound up be quite complex and mutualist on to each one some former(a)(prenominal). With a project management tool, such(prenominal)(prenominal) as a Gantt chart,all sub projects of a confinement sack up be viewed graphically. In this document a motility-process to new(prenominal)(prenominal) city is used for all standards and is effectuate upon the accomp alling Calc usher, . jm_ pathfinder_english. ots which whitethorn be downloaded from http// keep. openoffice. org/HOW_TO/ resettlement DD to M House-hunting vacate a tell apartment DD Cancel verifyings parliamentary law sensitive leasing sign on take form re fixing Send out parvenue add togetherress Forwarding request relocation Registration office Furnish the at once Reregister car Open an ac find excise bank account Relocation stainless 01/04/05 01/05/05 31/05/05 01/07/05 31/07/05 31/08/05 30/09/05 Undone through Start good example 1 The finished example In illustration 1, the sub businesss of the relocation-process appear on the y- bloc, and the time aviation on the x-axis.The nix build when a task should burst out and when it go forrader be finished. Blue streaks show tasks which throw away been completed. Yellow bars show piece of work which dormant moldinessinessiness be done. Project-Management with Gantt-Charts 5 get-go the Process Starting the Process To chart a project, all the sub-tasks mustinessiness(prenominal) inaugural be undisturbed in a spreadsheet. In this round-eyed example there is the name of the task, the extend-date and the length in calendar years fable 2 working class list This simplified project consists of eight subtasks Task 1 to Task 8. Next, begin creating the chart by considering InsertChart exemplification 3 Create t he chartFrom the dialogue AutoFormat Chart define the selection range. Neither the low class (containing the chromatography tugboat label) nor the first column (containing the task name) should be included as data. Project-Management with Gantt-Charts 2 Starting the Process gossip Next , and require the Chart lineament congresswoman 4 Choose chart type Choose the plane bar-chart and jailhouse Columns to indicate that the data argon coherent in columnar form. Note This variety shows the appellation of the axis in OpenOffice. org Calc. without delay the horizontal axis is called Y and the vertical axis is called X. check Next and necessitate the variant Stacked allegory 5 Create chart with stacked bars Project-Management with Gantt-Charts 3 Starting the Process Click Next once again and enter chart and axis titles instance 6 Adapt chart labeling The first Gantt Chart appears as follows interpreter 7 barroom chart The task names are on the vertical axis (Task 1 to Task 8) and the time line is on the horizontal axis. Project-Management with Gantt-Charts 4 Converting the bare(a) bar-chart into a Gantt chart Converting the uncomplicated bar-chart into a Gantt chart In order to edit the properties of an element in the diagram,. double-click the chart to select it.Next, right-click to open the context plug-in and gain access to the chart properties congressman 8 Edit diagram properties Note Ensure that no element in the diagram is selected, because differently the axis-properties can non be edited Project-Management with Gantt-Charts 5 Converting the simple bar-chart into a Gantt chart Select the y-axis, which now is the horizontal time line. (One could also select the horizontal axis using a left-click accordingly(prenominal) right-click to open the context card and finally choose Object Properties to format this axis. ) Set the Minimum to the real instigate-date, In this example this is 01/01/05.Furtherto a greater extent the axis sh ould get the come out of the closet date, so check the checkbox Automatic in the line Axis at Illustration 9 Adjust the time line This produces a chart as follows Illustration 10 Gantt chart Project-Management with Gantt-Charts 6 Converting the simple bar-chart into a Gantt chart The orangeness bar symbolizes the time up to the start of the task. This bar should be nark invisible. For this select the orange bar with a left-click, and then open its Object Properties after a right click. Under the tab Borders choose demeanor Invisible, and down the stairs the tab Area choose Fill None.Now the chart presents itself as follows Illustration 11 The completed Gantt chart Project-Management with Gantt-Charts 7 Converting the simple bar-chart into a Gantt chart Project-Management with Gantt-Charts 8 victimization the chart as a graphic in other applications Using the chart as a graphic in other applications To use the Gantt-chart as a picture in another application, save the upstand ing Calc document as hypertext mark-up lecture. This generates not only the HTML- file cabinet away, but also a jpeg-file containing the chart which can then be included in other documents, such as anOpenOffice. org impress presentation.Remember to take for the graphic a more descriptive name than, the the name suggested when the document is exported to HTML so that it can be found easily afterward Project-Management with Gantt-Charts 9 Using the chart as a graphic in other applications Project-Management with Gantt-Charts 10 Extending Gantt charting for Project Management Extending Gantt charting for Project Management In order to manage a project, still more information is needed. The progress of whatever task should be tracked as a percentage of the task and displayed in the chart, and the dependencies of the subtasks should also be documented.Furthermore the start-date should be hardened automatically based on these dependencies. To be able to create such a plan easily, a template was made by the German Native Language Community ( http//de. openoffice. org/ ) called pjm_template. ots. Illustration 12 Calc template pjm_template. ots The circulating(prenominal) adaptation of Gantt. zip contains the example spreadsheet and the spreadsheet itself can be downloaded from http//documentation. openoffice. org/HOW_TO/spreadsheet/pjm_template. ots Note This template uses bigs and upon opening displays a security warning. therefore, macros must be enabled to use the file.The file, created from the template, contains the by-line columns info Information about the progress of the task No. unique number of the task. It is recommended to count in intervals of 100, to be able to add tasks later on Activity translation of the task Start start-date of the task season planned or actual period of the task in calendar days End end-date of the task. This gets calculated based on the start-date and term. Progress in percentage build up Durat ion * progress Undone evaluate time remaining Duration Done 11 Project-Management with Gantt-ChartsExtending Gantt charting for Project Management forerunner List of tasks, which have to be completed, beforehand this task can start. Separation is made by spaces. The column titles in the first row can be denominate freely, but the columns must not transfer their position. Some columns have a drab background gray these columns contain formulas, which are calculated automatically light dispirited these columns can be edited manually, they can possibly be changed by the macro. It is recommended to use the last row for the end of the project. therefrom new tasks, which are inserted above, are displayed in the chart automatically.About the macro The macro is named update and is written in OpenOffice. org BASIC. The way it whole kit follows this sequence ? ? Add distance and end-date, if they are missing For each row of the panel 1. Where the task has not yet started (Prog ress = 0) calculate for rows, whose number corresponds with the value in the column Predecessor. For those not familiar with project management damage, a predecessor is an performance that must be completed (or be partially completed) before a qualify activity can begin. ( See http//www. apm. org. uk/page. asp viper? categoryID=4=29=0 for definitions. a) order latest possible end-date of these rows b) Set the replacement start-date to this end-date ? ? Where the task is finished (Progress = 100%) 1. come up continuance from start-date and end-date Illustrate information of task ? The meaning of this list of maltreats is describe later on in this document. The macro expects that the first row contains the headlines, the tasks start in row 2 and the columns are in the same place as in the example. Additional columns (for comments or some other purpose) must be located at the end. Note The maximum number of predecessors is hold in to 9. Project-Management with Gantt-Charts 2 E xtending Gantt charting for Project Management Example Planning a relocation This partitioning describes the process of relocating from one city to another city and is based upon the template, pjm_template. ots. The first step is to create a list with all subtasks Illustration 13 List of subtasks In preparing the set of tasks, getting mail forwarded was missed. So we inserted the activity Forwarding request in row 8 after the fact. Therefore this activity has the number 650. Inserting a row does not automatically repeat each formulae, thus all the formulae must be copied to each cell in the new row manually.Project-Management with Gantt-Charts 13 Extending Gantt charting for Project Management Next insert the start-date for the not-dependent tasks, as well as duration and expected enddate Illustration 14 Insert start- and end-date House-hunting starts on 01/03 and should be finished by 31/08. For all the other tasks the duration is given. Now, define the dependencies of the tasks . The relocation (700) for example can not start before the new leasing thin is subscribe (400) and the relocation is organized (500). The tasks 300-9999 have no dependencies, thus there are no start-dates for these tasks.Illustration 15 Define dependencies Next insert the start-date for the not-dependent tasks, as well as duration and expected enddate Project-Management with Gantt-Charts 14 Extending Gantt charting for Project Management Illustration 16 Insert start- and end-date House-hunting starts on 01/03 and should be finished by 31/08. For all the other tasks the duration is given. Now define the dependencies of the tasks. For example, relocation (700) can not start before the new leasing contract is signed (400) and relocation is organized (500). The tasks 300-9999 have no dependencies, thus there are no start-dates for these tasks.Illustration 17 Define dependencies As 20% of house-hunting are already done, and the occurrent apartment is already canceled, the progress is 20% and 100% respectively. Project-Management with Gantt-Charts 15 Extending Gantt charting for Project Management Illustration 18 Calculated duration At this point call the macro by clicking on the button modify. The duration and end-dates are calculated, and the column start is completed. Illustration 19 The appropriate chart The organization of the relocation, the registration at the office and the opening of an account can be done simultaneously.On the other hand the bank account can not be moved immediately, because the current apartment is not yet relocated. Project-Management with Gantt-Charts 16 Extending Gantt charting for Project Management Controlling the Project During some(prenominal) project, start by implementing several subtasks. To begin a subtask, insert the start date in the column Start. Set the progress to a value greater than nought (1% e. g. ), so that Update go out no longer change this date. If a task is completed, insert the real End-date, delete the d uration and set the progress to 100%. When calling Update the next time, the required duration will be calculated.After each change in the table,invoke the macro Update to update the table fitly. The Info column shows the current status of the project Illustration 20 Table during project-controlling House-hunting has begun and is on schedule according to the progress The apartment has already been canceled, the task is completed. Cancelling the banks order is callable and not on schedule, this performer, that the end-date is prior to the current date. All the other tasks are not due yet, they are not marked. Project-Management with Gantt-Charts 17 Extending Gantt charting for Project Management Project-Management with Gantt-Charts 8 Public credentials certify, Version 1. 0 Public support indorse, Version 1. 0 1. 0 DEFINITIONS. 1. 1. commercial message physical exertion subject division distribution or otherwise making the backup available to a third party. 1. 2. reader means a person or entity who creates or contributes to the first appearance of Modifications. 1. 3. credential means the pilot program certification or Modifications or the combination of the airplane pilot documentation and Modifications, in each model including portions thereof. 1. 4. Electronic statistical distribution implement means a mechanism generally accepted for the electronic transfer of data. 1. 5. Initial writer means the individual or entity identify as the Initial writer in the broadsheet required by the Appendix. 1. 6. bigger naturalize means a work which combines living or portions thereof with documentation or other writings not governed by the price of this License. 1. 7. License means this document. 1. 8. Modifications means any do-gooder to or deletion from the substance or social organisation of either the pilot supporting or any forward Modifications, such as a translation, abridgment, condensation, or any other form in which the sea captai n supporting or previous Modifications whitethorn be recast, transformed or adapted.A work consisting of pillar revisions, annotations, elaborations, and other modifications which, as a whole represent an original work of authorship, is a Modification. For example, when sustenance is released as a series of documents, a Modification is A. all addition to or deletion from the contents of the Original musical accompaniment or previous Modifications. B. Any new documentation that contains any part of the Original accompaniment or previous Modifications. 1. 9. Original Documentation means documentation described as Original Documentation in the notice required by the Appendix, and which, at the time of its release on a lower floor this License is not already Documentation governed by this License. 1. 10. Editable Form means the preferable form of the Documentation for making Modifications to it. The Documentation can be in an electronic, flavorless or archival form, provided t he appropriate decompressing or de-archiving software is widely available for no charge. 1. 11. You (or Your) means an individual or a healthy entity exercising rights to a lower place, and complying with all of the terms of this License or a future edition of this License issued chthonian character 5. 0 (Versions of the License). For legal entities, You includes any entity which controls, is controlled by, or is under super C control with You. For purposes of this definition, control means (a) the power, have or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (b) monomania of more than fifty percent (50%) of the outstanding shares or beneficial monomania of such entity. . 0 LICENSE GRANTS. 2. 1 Initial generator Grant. The Initial writer hereby grants You a world-wide, royaltyfree, non-exclusive license to use, reproduce, prepare Modifications of, compile, in public perform, publically display, demonstrate, market, dis close and distribute the Documentation in any form, on any media or via any Electronic diffusion Mechanism or other system now known or later discovered, and to sublicense the earlier rights to third parties through dual tiers of sublicensees n accordance with the terms of this License. The license rights given(p) in this Section 2. 1 (Initial generator Grant) are efficient on the date Initial Writer first distributes Original Documentation under the terms of this License. 2. 2. Contributor Grant.Each Contributor hereby grants You a world-wide, royaltyfree, non-exclusive license to use, reproduce, prepare Modifications of, compile, publically perform, publicly display, demonstrate, market, disclose and distribute the Documentation in any form, on any media or via any Electronic Distribution Mechanism or other method now known or later discovered, and to sublicense the foregoing rights to third parties through multiple tiers of sublicensees in accordance with the terms of th is License. The license rights give in this Section 2. (Contributor Grant) are effective on the date Contributor first makes Commercial Use of the Documentation. 3. 0 DISTRIBUTION OBLIGATIONS. 3. 1. diligence of License. The Modifications which You create or to which You contribute are governed by the terms of this License, including without limitation Section 2. 2 (Contributor Grant). The Documentation may be distributed only under the terms of this License or a future version of this License released in accordance with Section 5. 0 (Versions of the License), and You must include a copy of this License with every copy of the Documentation You distribute.You may not offer or impose any terms that alter or restrict the applicable version of this License or the recipien ts rights hereunder. However, You may include an additive document offering the additional rights described in Section 3. 5 (Required Notices). 3. 2. Availability of Documentation. Any Modification which You creat e or to which You contribute must be made available publicly in Editable Form under the terms of this License via a fixed strength or an accepted Electronic Distribution Mechanism. 3. 3.Description of Modifications. All Documentation to which You contribute must identify the Document Title 19 Public Documentation License, Version 1. 0 changes You made to create that Documentation and the date of any change. You must include a prominent education that the Modification is derived, directly or indirectly, from Original Documentation provided by the Initial Writer and include the name of the Initial Writer in the Documentation or via an electronic link that describes the origin or ownership of the Documentation.The foregoing change documentation may be created by using an electronic program that automatically tracks changes to the Documentation, and such changes must be available publicly for at least five years following release of the changed Documentation. 3. 4. Intellectual Proper ty Matters. Contributor represents that Contributor believes that Contributors Modifications are Contributors original creation(s) and/or Contributor has sufficient rights to grant the rights conveyed by this License. . 5. Required Notices. You must duplicate the notice in the Appendix in each file of the Documentation. If it is not possible to put such notice in a limited Documentation file due to its structure, then You must include such notice in a location (such as a relevant directory) where a reader would be likely to air for such a notice, for example, via a hyperlink in each file of the Documentation that takes the reader to a page that describes the origin and ownership of the Documentation.If You created one or more Modification(s) You may add your name as a Contributor to the notice described in the Appendix. You must also duplicate this License in any Documentation file (or with a hyperlink in each file of the Documentation) where You describe recipients rights or own ership rights. You may choose to offer, and to charge a present for, warranty, support, policy or liability liabilitys to one or more recipients of Documentation. However, You may do so only on Your own behalf, and not on behalf of the Initial Writer or any Contributor.You must make it absolutely clear than any such warranty, support, indemnity or liability obligation is offered by You alone, and You hereby agree to pay off the Initial Writer and every Contributor for any liability incurred by the Initial Writer or such Contributor as a result of warranty, support, indemnity or liability terms You offer. 3. 6. large Works. You may create a bigger Work by combining Documentation with other documents not governed by the terms of this License and distribute the Larger Work as a single product. In such a case, You must make sure the requirements of this License are set up for the Documentation. . 0 APPLICATION OF THIS LICENSE. This License applies to Documentation to which the Ini tial Writer has attached this License and the notice in the Appendix. 5. 0 VERSIONS OF THE LICENSE. 5. 1. New Versions. Initial Writer may loose revised and/or new versions of the License from time to time. Each version will be given a distinguishing version number. 5. 2. Effect of New Versions. Once Documentation has been published under a particular version of the License, You may always keep to use it under the terms of that version.You may also choose to use such Documentation under the terms of any subsequent version of the License published by______________________ Insert name of the foundation, company, Initial Writer, or whoever may modify this License. No one other than ________________________Insert name of the foundation, company, Initial Writer, or whoever may modify this License has the right to modify the terms of this License. Filling in the name of the Initial Writer, Original Documentation or Contributor in the notice described in the Appendix shall not be deemed to be Modifications of this License. . 0 DISCLAIMER OF stock warrant. certification IS PROVIDED downstairs THIS LICENSE ON AN AS IS BASIS, WITHOUT WARRANTY OF any(prenominal) KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, WITHOUT limit, WARRANTIES THAT THE DOCUMENTATION IS FREE OF DEFECTS, MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE OR NON-INFRINGING. THE faultless RISK AS TO THE QUALITY, ACCURACY, AND PERFORMANCE OF THE DOCUMENTATION IS WITH YOU. SHOULD both DOCUMENTATION PROVE forged IN both RESPECT, YOU (NOT THE INITIAL author OR all OTHER CONTRIBUTOR) grab THE COST OF ANY NECESSARY SERVICING, refurbish OR CORRECTION.THIS DISCLAIMER OF WARRANTY CONSTITUTES AN substantive PART OF THIS LICENSE. NO USE OF ANY DOCUMENTATION IS AUTHORIZED HEREUNDER omit UNDER THIS DISCLAIMER. 7. 0 TERMINATION. This License and the rights granted hereunder will terminate automatically if You fail to comply with terms herein and fail to cure such prison-breaking within 30 days of fitting aware of the breach. All sublicenses to the Documentation which are properly granted shall survive any termination of this License. Provisions which, by their nature, must remain in effect beyond the termination of this License shall survive. 8. 0 LIMITATION OF LIABILITY.UNDER NO CIRCUMSTANCES AND UNDER NO LEGAL THEORY, WHETHER IN TORT (INCLUDING NEGLIGENCE), CONTRACT, OR OTHERWISE, SHALL THE INITIAL WRITER, ANY OTHER CONTRIBUTOR, OR ANY DISTRIBUTOR OF DOCUMENTATION, OR ANY SUPPLIER OF ANY OF much(prenominal) PARTIES, BE LIABLE TO ANY PERSON FOR ANY DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL restoration OF ANY CHARACTER INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF GOODWILL, lock STOPPAGE, COMPUTER FAILURE OR MALFUNCTION, OR ANY AND ALL OTHER DAMAGES OR LOSSES ARISING OUT OF OR RELATING TO THE USE OF THE DOCUMENTATION, EVEN IF SUCH political party SHALL HAVE BEEN INFORMED OF THE POSSIBILITY OF SUCH DAMAGES. Document Title 20 Public Documentation License, Versi on 1. 0 9. 0 U. S. establishment END USERS. If Documentation is being acquired by or on behalf of the U. S. Government or by a U. S. Government outpouring contractor or subcontractor (at any tier), then the Governments rights in Documentation will be only as set forth in this Agreement this is in accordance with 48 CFR 227. 7201 through 227. 7202-4 (for Department of self-denial (DOD) acquisitions) and with 48 CFR 2. 101 and 12. 212 (for non-DOD acquisitions). 10. 0 MISCELLANEOUS. This License represents the complete agreement concerning the subject matter hereof.If any provision of this License is held to be unenforceable, such provision shall be amend only to the extent necessary to make it enforceable. This License shall be governed by atomic number 20 law, excluding its conflict-of-law provisions. With respect to disputes or any judicial proceeding relating to this License, the losing party is responsible for be, including without limitation, court costs and reasonable att orneys fees and expenses. The application of the United Nations congregation on Contracts for the International Sale of Goods is expressly excluded.Any law or regulation which provides that the language of a contract shall be construed against the drafter shall not apply to this License. Appendix Public Documentation License Notice The contents of this Documentation are subject to the Public Documentation License Version 1. 0 (the License) you may only use this Documentation if you comply with the terms of this License. A copy of the License is available at http//www. openoffice. org/licenses/PDL. rtf. The Original Documentation is _________________. The Initial Writer of the Original Documentation is ______________________ (C) ____. All Rights Reserved. (Initial Writer