Note: It is recommended that you do not download a xlgantt file on sites other than xlworks homepage because the file may be changed or may contain a virus.<\/em><\/span><\/p>\n <\/p>\n After downloading the XLGantt file, when the \"PROTECTED VIEW\" appears as below, click the \"Enable Editing\" button.<\/p>\n If you see the \"SECURITY WARNING\" related to using macros, click the \u201cEnable Content\u201d button.<\/p>\n <\/p>\n You can modify the task entered as an example, or delete all the example tasks and enter new tasks.<\/p>\n For the start and finish dates, just enter the dates of the sub tasks and press \u201cUpdate Schedule\u201d on the ribbon to automatically enter the summary task's date.<\/p>\n If you enter only the dates of the subtasks and click \"Update Schedule\" on the ribbon, the dates of the summary tasks are entered automatically.<\/p>\n <\/p>\n You can enter the start and finish dates for a task, or choose from a calendar. <\/p>\n Click \"Pick a Date\" and the calendar will appear.\u00a0If you double-click the date you want to enter, the date is entered in the cell.<\/p>\n <\/p>\n To indent or outdent a task, select the task (multiple tasks can be selected) and click \u201cIndent Task\u201d, \u201cOutdent Task\u201d on the ribbon.<\/p>\n Let's indent \"Design\" and \"Development\" tasks as follows.<\/p>\n \u2460 Select tasks to indent<\/p>\n <\/p>\n \u2461 Indent Task (Ribbon menu > XLGantt)<\/p>\n <\/p>\n \u2462 All tasks from row 11 to row 16 have been indented.<\/p>\n <\/p>\n Milestones are significant events such as the completion of a phase of work or system open. Because the milestone itself doesn\u2019t normally include any work, milestones are represented as tasks with zero workload.<\/p>\n In Excel Gantt, milestones are marked as follows. <\/p>\n \u2461 On the \"Edit a Task\" pop-up window, check \"Mark task as a milestone\" and click the Save button.<\/p>\n <\/p>\n \u2462 The total workload and planned workload of the \"Confirm Scope\" task are calculated as 0(zero). On the Gantt chart, the milestone appears as a diamond.<\/p>\n <\/p>\n Enter tasks and go to Ribbon > XLGantt tab, click the \"Update Schedule\".<\/p>\n <\/p>\n As shown in the illustration below, the workloads of the subtasks, the workloads of the summary tasks, and the dates of summary tasks are automatically calculated.<\/p>\n Group rows are displayed on the left side of the task, and the Gantt charts are automatically displayed on the right side.<\/p>\n <\/p>\n Let's look at the above features one by one.<\/p>\n Go to the ribbon menu> XLGantt tab > Options > Appearance tab. <\/p>\n Is automatically calculated using the dates of the subtasks.<\/p>\n \u2022 Start date of summary task: The earliest date among the start dates of the subtasks. In the example below, the start date and finish date of the \"Design\" task are automatically calculated using the start date of the \"Design Database\" task and the finish date of the \"Design UI\" task.<\/p>\n <\/p>\n The workload of the summary task is automatically calculated using the workloads of the subtasks.<\/p>\n Workload of the summary task: The sum of the workloads of the subtasks. <\/p>\n The \"planned work\" displayed to the right of the \"total work\" is the workload to be done by the current date and is automatically calculated. The calculation method that adds up to the parent workload is the same as the calculation method of \"total work\".<\/p>\n <\/p>\n The total workload from 7\/27\/2020 to 8\/11\/2020 for the \u201cDesign UI\" task above is 12 days, but the total workload from 7\/27\/2020 to today(as of 8\/8\/2020) is 10 days.<\/p>\n <\/p>\n Until now, the total workload and the planned workload were calculated by the number of working days excluding non-working days, it is assumed that one person is fully assigned to a single task.<\/p>\n If several people are assigned to a single task or only some resources of one person (eg 50%) are assigned, how should the workload be calculated?<\/p>\n * It is assumed that the workload calculation method is selected as \u201cby Resource Allocation ratio\u201d (Ribbon Menu> XLGantt > Options > General)<\/em><\/span><\/p>\n <\/p>\n If nothing is entered in the resource column, the total workload and planned workload are calculated as the number of working days excluding non-working days,<\/p>\n <\/p>\n but if you enter the name of the person in charge in the resource column, the total workload and planned workload are calculated using the following formula.<\/p>\n Total workload = Number of working days excluding non-working days\u00a0 * Number of people entered (John, Elsa)<\/p>\n 24 days = 12 days * 2 people<\/p>\n <\/p>\n Total workload = number of working days excluding non-working days\u00a0 * Number of entered people (John[50%])<\/p>\n 6 days = 12 days * 50% (0.5 John)<\/p>\n <\/p>\n Total workload = number of working days excluding non-working days * Number of entered people (John[50%], Elsa)<\/p>\n 18 days = (12 days * 50% (0.5 John)) + (12 days * 1 Elsa)<\/p>\n <\/p>\n The workload described above calculates the amount of work. If two people are assigned to a task, the workload is doubled, and the workload of the summary task is calculated by adding up the workload of the subtasks.<\/p>\n However, the total duration and the planned duration are not the amount of work but the duration. This is the value you need when you are wondering about the duration between the start date and the finish date rather than the amount of work.<\/p>\n <\/p>\n Planned %Work Complete is the planned progress that must be performed until today. It is the planned workload divided by the total workload (= planned workload\/total workload).<\/p>\n <\/p>\n Although I explained above, let's take a look at the meaning of \u201cPlanned %Work Complete\u201d and \u201d %Work Complete\u201d for better understanding.<\/p>\n So today is January 7th, but if you only perform 6 days' worth of tasks, the \"%Work Complete\" for this task is 60%, with a 10% delay.<\/p>\n <\/p>\n Once you enter a task, it can be rescheduled or changed. If there is any change in the entered contents, modify it directly.<\/p>\n Go to the ribbon menu> XLGantt tab > Options> General> \"Project Information\", change the project name to display the changed project name in the upper left of the Schedule sheet.<\/p>\n The Start-Finish date can be set in two ways.<\/p>\n The Planned %Work Complete of the task is automatically calculated based on the current date, but since the %Work Complete is only known to the person who has performed the task, the %Work Complete of the task is checked and entered directly.<\/p>\n As shown in the image below, you can enter 80% of the %Work Complete for the \u201cDesign UI\u201d task.<\/p>\n <\/p>\n Since all necessary items have been entered, if you click \"Update Schedule\" on the ribbon menu, you can see that the %Work Complete of subtasks (Design Database, Design UI) is added up to the upper level \"Design\" task and the %Work Complete is automatically calculated to 86.15%.<\/p>\n According to the entered %Work Complete, the progress bar (blue bar) is drawn on the Gantt chart.<\/p>\n <\/p>\n [ Using XLGantt(Excel Gantt) ]<\/strong><\/p>\n XLGantt(Excel Gantt) is a program designed to enable project scheduling in Microsoft Excel. It is composed of the following features. You don\u2019t need to install this program because it is an Excel macro file. You just download this file, save it to a folder, and […]<\/p>\n","protected":false},"author":2,"featured_media":21199,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[984],"tags":[997,998,90,92,184,186],"class_list":{"0":"post-21174","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","6":"hentry","7":"category-xlgantt_howto","8":"tag--en","11":"tag-xlgantt-en","12":"tag-excel-en","13":"tag-gantt-chart-en"},"yoast_head":"\n2. Security Settings<\/h2>\n
![\"xlgantt](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_protected_view.png?resize=626%2C36&ssl=1\")
<\/p>\n![\"VBA](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_security.png?resize=626%2C30&ssl=1\")
<\/p>\n3. Enter tasks<\/h2>\n
\n
![\"Excel](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_01-2.png?resize=664%2C306&ssl=1\")
<\/p>\n1) Enter the date<\/h3>\n
\nRight-click on the cell where you want to enter the date and pick a date.<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_02.png?resize=513%2C187&ssl=1\")
<\/p>\n![\"Excel](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_03.png?resize=308%2C343&ssl=1\")
<\/p>\n2) Indent or outdent Task<\/h3>\n
![\"Indent](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_task_indent.png?resize=304%2C260&ssl=1\")
<\/p>\n![\"Indent](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_task_indent_button.png?resize=171%2C134&ssl=1\")
<\/p>\n![\"Indent](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_task_indented.png?resize=313%2C259&ssl=1\")
<\/p>\n3) Mark tasks as milestones<\/h3>\n
\n\u2460 Select the task to be marked as a milestone with a mouse and click the right mouse button to display a menu. Click \"Edit a Task\" from the menu.<\/p>\n![\"Mark](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_04.png?resize=376%2C196&ssl=1\")
<\/p>\n![\"Mark](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_05.png?resize=395%2C569&ssl=1\")
<\/p>\n![\"Mark](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_06.png?resize=783%2C131&ssl=1\")
<\/p>\n4. Update Schedule<\/h2>\n
![\"Update](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_update_schedule-1.png?resize=171%2C134&ssl=1\")
<\/p>\n![\"Update](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_07-1.png?resize=1243%2C354&ssl=1\")
<\/p>\n1) Group rows<\/h3>\n
\nIf \"Group rows(Max 8 Levels)\" is checked, row groups are always displayed.<\/p>\n![\"Group](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_08.png?resize=557%2C199&ssl=1\")
<\/p>\n2) The date of the summary task<\/h3>\n
\n\u2022 Finish date of the summary task: the latest date among the finish dates of the subtasks.<\/p>\n![\"Group](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_10-1.png?resize=418%2C180&ssl=1\")
<\/p>\n3) Total work<\/h3>\n
\nIn the example below, the workload of the \"Design\" task is automatically calculated as the sum of the subtasks (8 + 12 = 20 days).
\n\u2013 Design Database(8 days)
\n\u2013 Design UI (12 days)<\/p>\n![\"Total](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_11.png?resize=447%2C164&ssl=1\")
<\/p>\n4) Planned work(Planned workload)<\/h3>\n
![\"Planned](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_12.png?resize=534%2C135&ssl=1\")
<\/p>\n![\"Planned](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_13.png?resize=308%2C343&ssl=1\")
<\/p>\n\u203b Workload calculation<\/strong><\/h3>\n
![\"Workload](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_14.png?resize=557%2C575&ssl=1\")
<\/p>\nExample 1 - Two people are assigned to the \"Design UI\" task<\/h4>\n
![\"Example](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_15.png?resize=591%2C130&ssl=1\")
<\/p>\n![\"Example](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_16.png?resize=597%2C129&ssl=1\")
<\/p>\nExample 2 - Only some resources of one person (eg 50%) are assigned to the \"Design UI\" task.<\/h4>\n
![\"Example](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_17.png?resize=596%2C131&ssl=1\")
<\/p>\n![\"Example](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_18.png?resize=614%2C132&ssl=1\")
<\/p>\n5)Total Duration, Planned Duration<\/h3>\n
\n
\n![\"Total](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_16-2.png?resize=597%2C129&ssl=1\")
<\/li>\n<\/ul>\n6) Planned %Work Complete, %Work Complete<\/h3>\n
\n
![\"Planned](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_19.png?resize=1089%2C133&ssl=1\")
<\/p>\n\n
![\"Planned](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_workcomplete2.png?resize=663%2C192&ssl=1\")
<\/p>\n5. Update Schedule after modifying tasks<\/h2>\n
1) Change project name, project start date, finish date<\/h3>\n
![\"Change](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_20.png?resize=557%2C182&ssl=1\")
<\/p>\n\n
<\/h3>\n
2) Enter \"%Work Complete\"<\/h3>\n
![\"%Work](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_02_en_new_21.png?resize=998%2C133&ssl=1\")
<\/p>\n\n