![\"Workload](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_04.png?resize=525%2C225&ssl=1\")
<\/p>\nLet's take a look at how to calculate the workload when scheduling a project.<\/p>\n
As shown below, if the start date of the \u201cDesign database\u201d task is July 22 and the finish date is July 31, the working days(excluding nonworking days) are 8.<\/p>\n
<\/p>\n
<\/p>\n
![\"Workload](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_01.png?resize=308%2C343&ssl=1\")
<\/p>\n
\u203b Refer to the following link for setting nonworking days and calculating the workload.<\/span><\/p>\n Excel Gantt Chart - How to #11 \u2013 Calendar<\/a><\/p>\n <\/p>\n If only one person is assigned half a day or several people are assigned to the \u201cDesign database\u201d task, the workload should be calculated as follows.<\/p>\n For the above case, XLGantt provides the following two methods of calculating the workload.<\/p>\n In the ribbon menu \u201cXLGantt> Options> General> Workload Calculation\u201d, you can select the workload calculation method.<\/p>\n <\/p>\n \"Calculated by resource allocation ratio\" is a feature added from version 4.0.<\/p>\n If you enter \u201cElsa, Mike\u201d or \u201cElas[50%], Mike\" in the \"Resources\" column\u00a0of the Schedule sheet, the workload is calculated according to the percentage of the assigned personnel. If nothing is entered in the \"Resources\" column\u00a0or if only one name of the assigned personnel is entered, it is assumed that one person is assigned.<\/p>\n If nothing is entered in the \"Resources\" column, it is assumed that one person is assigned and the total workload is calculated as 8 days.<\/p>\n <\/p>\n if only one name of the assigned personnel is entered in the resources column, it is assumed that one person is assigned and the total workload is calculated as 8 days.<\/p>\n <\/p>\n \u203b The \u201cplanned work\u201d displayed on the right side of the \"total work\" is the workload to be carried out until today. The basic calculation method is the same as the \"total work\", except that it is calculated by the working days until today.<\/p>\n <\/p>\n If you enter \u201cElsa [50%]\u201d in the \"Resources\" column, only half will be calculated.<\/p>\n Total workload = number of working days excluding nonworking days\u00a0 * Number of entered people (Elsa [50%])<\/span> <\/p>\n If you enter multiple names in the resources column, the workload is calculated as follows.<\/p>\n Total workload = number of working days excluding nonworking days * Number of people entered (Elsa, Mike)<\/span> <\/p>\n The result is the same as above even if you enter \"Elsa[100%], Mike[100%]\" as follows.<\/p>\n <\/p>\n It can be calculated even if several people are assigned as follows or only a part of a specific person is assigned.<\/p>\n Total workload = Number of working days excluding nonworking days * Number of people entered (Elsa[50%], Mike)<\/span> <\/p>\n If you click \u201cProgresses by Resources\"(ribbon menu> XLGantt tab > Analysis group > Progresses by Resources), you can check the result as follows.<\/p>\n <\/p>\n If you enter \"Elsa [100%]\" in the \"Resources\" column, one person will be assigned full time (8 hours if a working condition is 8 hours a day), and if you enter \"Elsa [200%]\", Elsa will be assigned twice.<\/p>\n By adopting this feature, the workload can be calculated as follows.<\/p>\n If you don't know the names of the people assigned to the \u201cDesign database\u201d task, but 10 people are assigned, if you enter \u201cDesigner[10]\u201d, the workload is calculated as 10 designers are assigned to the task(designer[10] is the same as designer[1000%]).<\/p>\n Total workload = number of working days excluding nonworking days\u00a0 *\u00a0Number of entered persons (10 designers)<\/span> <\/p>\n The \"Calculated by weight\" feature was provided before the upgrade to XLGantt version 4.0.<\/p>\n This feature is provided for compatibility with the previous version, and calculation is possible when only part of the person is allocated or when multiple people are allocated, but it is not recommended because there is a problem that the allocation ratio of a specific person cannot be specified.<\/span><\/em><\/p>\n If nothing is entered in the \"Weight\" column or 1 is entered, the total workload is calculated as 8 days as one person is assigned.<\/p>\n <\/p>\n If you enter \u201c0.5\u201d in the \"Weight\" column, only half will be calculated.<\/p>\n Total workload = number of working days excluding nonworking days\u00a0*\u00a0weight<\/span> <\/p>\n If you enter 2 in the \"Weight\" column, it is calculated that two people are assigned.<\/p>\n Total workload = number of working days excluding nonworking days\u00a0*\u00a0weight<\/span> <\/p>\n The workload is calculated even if the name of the resource is not entered in the \"Resources\" column.<\/p>\n If 2 people's names are entered, the workload is calculated at a ratio of 100% (weight 2 \/ 2 people = 100%) for each person.<\/p>\n If 3 people's names are entered with the weight of 2, the workload is calculated at a ratio of 66.7% (weight 2\/3 people = 66.7%) for each person, but there is a problem that the allocation ratio of a specific person cannot be adjusted.<\/p>\n If you select the \"Calculated by resource allocation ratio\" option, you can adjust the allocation ratio of a specific person.<\/strong><\/p>\n <\/p>\n [ Using XLGantt(Excel Gantt) ]<\/strong><\/p>\n Let's take a look at how to calculate the workload when scheduling a project. As shown below, if the start date of the \u201cDesign database\u201d task is July 22 and the finish date is July 31, the working days(excluding nonworking days) are 8. \u203b […]<\/p>\n","protected":false},"author":2,"featured_media":21533,"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":[92,186,1023,1034],"class_list":["post-21506","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xlgantt_howto","tag-xlgantt-en","tag-gantt-chart-en","tag-excel-gantt-en","tag-workload"],"yoast_head":"\n\n
\n
![\"Workload](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_02.png?resize=557%2C575&ssl=1\")
<\/p>\n1. Calculated by resource allocation ratio<\/h2>\n
\nYou can check the workload assigned to each person in the \"Progresses by Resources\" and \"Workloads\" features(You can use the feature from the ribbon menu XLGantt tab> Analysis group).<\/p>\n1) When one person is assigned to one task<\/h3>\n
![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_05.png?resize=525%2C225&ssl=1\")
<\/p>\n![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_04-1.png?resize=525%2C225&ssl=1\")
<\/p>\n2) When a part of the resource is allocated to one task<\/h3>\n
\n4 days = 8 days * 50% (0.5 Elsa)<\/span><\/p>\n![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_06.png?resize=522%2C224&ssl=1\")
<\/p>\n3) When multiple people are assigned to a single task<\/h3>\n
\n16 days = 8 days * 2 people<\/span><\/p>\n![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_07.png?resize=521%2C225&ssl=1\")
<\/p>\n![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_08.png?resize=584%2C223&ssl=1\")
<\/p>\n
\n12 days = (8 days * 50% (0.5 Elsa)) + (8 days * 1 Mike)<\/span><\/p>\n![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_09-1.png?resize=583%2C223&ssl=1\")
<\/p>\n![\"When](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_10.png?resize=801%2C522&ssl=1\")
<\/p>\n4) Application<\/h3>\n
\n80 days = 8 days * 10 people<\/span><\/p>\n![\"designer[10]](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_11.png?resize=589%2C224&ssl=1\")
<\/p>\n2. Calculated by weight<\/h2>\n
1) When one person is assigned to one task<\/h3>\n
![\"Calculated](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_12.png?resize=628%2C223&ssl=1\")
<\/p>\n2) When a part of the resource is allocated to one task<\/h3>\n
\n4 days = 8 days * Weight 0.5<\/span><\/p>\n![\"Calculated](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_13.png?resize=633%2C223&ssl=1\")
<\/p>\n3) When multiple people are assigned to a single task<\/h3>\n
\n16 days = 8 days * Weight 2<\/span><\/p>\n![\"Calculated](\"https:\/\/i0.wp.com\/xlworks.net\/wp-content\/uploads\/2025\/05\/xlgantt_howto_14_en_14.png?resize=634%2C224&ssl=1\")
<\/p>\n\n