{"id":18761,"date":"2026-04-17T10:30:00","date_gmt":"2026-04-17T10:30:00","guid":{"rendered":"https:\/\/archipad.com\/?p=18761"},"modified":"2026-04-07T13:57:07","modified_gmt":"2026-04-07T13:57:07","slug":"plan-de-charge-excel-calcul-methode-et-modele-a-telecharger","status":"publish","type":"post","link":"https:\/\/archipad.com\/fr\/plan-de-charge-excel-calcul-methode-et-modele-a-telecharger\/","title":{"rendered":"Plan de charge Excel : calcul, m\u00e9thode et mod\u00e8le \u00e0 t\u00e9l\u00e9charger"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"18761\" class=\"elementor elementor-18761\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5bec590 e-flex e-con-boxed e-con e-parent\" data-id=\"5bec590\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a519fce elementor-widget elementor-widget-heading\" data-id=\"a519fce\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\"><span id=\"docs-internal-guid-8999917d-7fff-797e-5ef0-9d81ca6a6592\"><h1 dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 20pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Plan de charge Excel : comment cr\u00e9er un fichier clair en 5 \u00e9tapes ?&nbsp;<\/span><\/h1><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Un plan de charge Excel permet de r\u00e9partir les charges de travail, de suivre les ressources disponibles et d\u2019organiser les projets sur une m\u00eame base.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Dans cet article, nous allons d\u00e9tailler les donn\u00e9es \u00e0 int\u00e9grer dans le fichier, la mani\u00e8re de le structurer et les \u00e9tapes pour le construire.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Un mod\u00e8le de plan de charge Excel est disponible en t\u00e9l\u00e9chargement pour vous guider dans sa cr\u00e9ation . Nous verrons aussi comment calculer la charge et le taux de charge pour suivre l\u2019activit\u00e9 dans le temps.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Pour aller plus loin, compl\u00e9tez votre plan de charge avec le <\/span><a href=\"https:\/\/archipad.com\/fr\/fonctionnalites\/planning\/\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">planning<\/span><\/a><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> Archipad.<\/span><\/p><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">En r\u00e9sum\u00e9<\/span><\/h2><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Un plan de charge Excel<\/span><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\"> permet de r\u00e9partir les charges de travail, de visualiser les ressources disponibles et de suivre la charge sur une p\u00e9riode donn\u00e9e.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Un fichier efficace<\/span><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\"> repose sur une structure simple : les ressources en lignes, les p\u00e9riodes en colonnes, puis des indicateurs comme la capacit\u00e9 disponible et le taux de charge.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Quelques calculs permettent d\u2019exploiter le plan de charge : charge pr\u00e9vue, capacit\u00e9 disponible, taux de charge et capacit\u00e9 restante.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Excel convient pour un suivi simple, mais quand les projets ou les chantiers se multiplient, un outil comme Archipad devient plus utile.<\/span><\/p><\/li><\/ul><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-70fae34 e-flex e-con-boxed e-con e-parent\" data-id=\"70fae34\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8e24ba4 elementor-widget elementor-widget-jet-listing-grid\" data-id=\"8e24ba4\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;columns&quot;:&quot;1&quot;}\" data-widget_type=\"jet-listing-grid.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"jet-listing-grid jet-listing\"><div class=\"jet-listing-grid__items grid-col-desk-1 grid-col-tablet-1 grid-col-mobile-1 jet-listing-grid--14487\" data-queried-id=\"18761|WP_Post\" data-nav=\"{&quot;enabled&quot;:false,&quot;type&quot;:null,&quot;more_el&quot;:null,&quot;query&quot;:[],&quot;widget_settings&quot;:{&quot;lisitng_id&quot;:14487,&quot;posts_num&quot;:1,&quot;columns&quot;:1,&quot;columns_tablet&quot;:1,&quot;columns_mobile&quot;:1,&quot;column_min_width&quot;:240,&quot;column_min_width_tablet&quot;:240,&quot;column_min_width_mobile&quot;:240,&quot;inline_columns_css&quot;:false,&quot;is_archive_template&quot;:&quot;&quot;,&quot;post_status&quot;:[&quot;publish&quot;],&quot;use_random_posts_num&quot;:&quot;&quot;,&quot;max_posts_num&quot;:9,&quot;not_found_message&quot;:&quot;No data was found&quot;,&quot;is_masonry&quot;:false,&quot;equal_columns_height&quot;:&quot;&quot;,&quot;use_load_more&quot;:&quot;&quot;,&quot;load_more_id&quot;:&quot;&quot;,&quot;load_more_type&quot;:&quot;click&quot;,&quot;load_more_offset&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:0,&quot;sizes&quot;:[]},&quot;use_custom_post_types&quot;:&quot;&quot;,&quot;custom_post_types&quot;:[],&quot;hide_widget_if&quot;:&quot;&quot;,&quot;carousel_enabled&quot;:&quot;&quot;,&quot;slides_to_scroll&quot;:&quot;1&quot;,&quot;arrows&quot;:&quot;true&quot;,&quot;arrow_icon&quot;:&quot;fa fa-angle-left&quot;,&quot;dots&quot;:&quot;&quot;,&quot;autoplay&quot;:&quot;true&quot;,&quot;pause_on_hover&quot;:&quot;true&quot;,&quot;autoplay_speed&quot;:5000,&quot;infinite&quot;:&quot;true&quot;,&quot;center_mode&quot;:&quot;&quot;,&quot;effect&quot;:&quot;slide&quot;,&quot;speed&quot;:500,&quot;inject_alternative_items&quot;:&quot;&quot;,&quot;injection_items&quot;:[],&quot;scroll_slider_enabled&quot;:&quot;&quot;,&quot;scroll_slider_on&quot;:[&quot;desktop&quot;,&quot;tablet&quot;,&quot;mobile&quot;],&quot;custom_query&quot;:false,&quot;custom_query_id&quot;:&quot;&quot;,&quot;_element_id&quot;:&quot;&quot;,&quot;collapse_first_last_gap&quot;:false,&quot;list_tag_selection&quot;:&quot;&quot;,&quot;list_items_wrapper_tag&quot;:&quot;div&quot;,&quot;list_item_tag&quot;:&quot;div&quot;,&quot;empty_items_wrapper_tag&quot;:&quot;div&quot;}}\" data-page=\"1\" data-pages=\"207\" data-listing-source=\"posts\" data-listing-id=\"14487\" data-query-id=\"\"><div class=\"jet-listing-grid__item jet-listing-dynamic-post-18845\" data-post-id=\"18845\"  ><div class=\"jet-engine-listing-overlay-wrap\" data-url=\"https:\/\/auth.archipad.com\/registration?return_to=https:\/\/archipad.com\/fr\/page-remerciement-inscription\" data-target=\"_blank\">\t\t<div data-elementor-type=\"jet-listing-items\" data-elementor-id=\"14487\" class=\"elementor elementor-14487\" data-elementor-post-type=\"jet-engine\">\n\t\t\t\t<div class=\"elementor-element elementor-element-131d650 e-con-full bannerintra e-flex e-con e-parent\" data-id=\"131d650\" data-element_type=\"container\" data-e-type=\"container\" id=\"bannerintra\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-67386eb e-con-full e-flex e-con e-child\" data-id=\"67386eb\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-6ea2823 e-con-full e-flex e-con e-child\" data-id=\"6ea2823\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[],&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2e071d8 elementor-widget elementor-widget-spacer\" data-id=\"2e071d8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"spacer.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-spacer\">\n\t\t\t<div class=\"elementor-spacer-inner\"><\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-edf4bdc e-con-full e-flex e-con e-child\" data-id=\"edf4bdc\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-9bf3882 e-con-full banner2 e-flex e-con e-child\" data-id=\"9bf3882\" data-element_type=\"container\" data-e-type=\"container\" id=\"banner2\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8690160 elementor-widget elementor-widget-heading\" data-id=\"8690160\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">Centralisez le suivi de vos chantiers <span style=\"color: #E33D2E\">en quelques clics<\/span><\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-23100f8 e-con-full e-flex e-con e-child\" data-id=\"23100f8\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-6a0b4a1 e-con-full e-flex e-con e-child\" data-id=\"6a0b4a1\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;,&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1ed6c4a elementor-widget elementor-widget-jet-inline-svg\" data-id=\"1ed6c4a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"jet-inline-svg.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-jet-inline-svg jet-elements\"><div class=\"jet-inline-svg__wrapper\"><div class=\"jet-inline-svg jet-inline-svg--custom-width\"><div class=\"jet-inline-svg__inner\"><?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"45\" height=\"45\" viewBox=\"0 0 45 45\" fill=\"none\">\n  <rect width=\"45\" height=\"45\" rx=\"22.5\" fill=\"#1A1A1A\"><\/rect>\n  <g clip-path=\"url(#clip0_607_293)\">\n    <path d=\"M12.4626 22.5H32.5376\" stroke=\"white\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><\/path>\n    <path d=\"M24.4543 30.5832L32.5377 22.5L24.4543 14.4168\" stroke=\"white\" stroke-width=\"2.5\" stroke-linecap=\"round\" stroke-linejoin=\"round\"><\/path>\n  <\/g>\n  <defs>\n    <clipPath id=\"clip0_607_293\">\n      <rect width=\"22.5621\" height=\"18.6535\" fill=\"white\" transform=\"translate(11.219 13.1732)\"><\/rect>\n    <\/clipPath>\n  <\/defs>\n<\/svg>\n<\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-6924f83 e-con-full e-flex e-con e-child\" data-id=\"6924f83\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0c0cacf elementor-widget elementor-widget-heading\" data-id=\"0c0cacf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\">Tester gratuitement<\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-535fc26 e-con-full e-flex e-con e-child\" data-id=\"535fc26\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-9cc2fad e-con-full e-flex e-con e-child\" data-id=\"9cc2fad\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d0ea718 elementor-widget elementor-widget-rating\" data-id=\"d0ea718\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"rating.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"e-rating\" itemtype=\"https:\/\/schema.org\/Rating\" itemscope=\"\" itemprop=\"reviewRating\">\n\t\t\t<meta itemprop=\"worstRating\" content=\"0\">\n\t\t\t<meta itemprop=\"bestRating\" content=\"5\">\n\t\t\t<div class=\"e-rating-wrapper\" itemprop=\"ratingValue\" content=\"4.5\" role=\"img\" aria-label=\"Not\u00e9 4.5 sur 5\">\n\t\t\t\t\t\t\t<div class=\"e-icon\">\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-marked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-unmarked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"e-icon\">\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-marked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-unmarked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"e-icon\">\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-marked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-unmarked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"e-icon\">\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-marked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-unmarked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"e-icon\">\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-marked\" style=\"--e-rating-icon-marked-width: 50%;\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t\t<div class=\"e-icon-wrapper e-icon-unmarked\">\n\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-eicon-star\" viewBox=\"0 0 1000 1000\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M450 75L338 312 88 350C46 354 25 417 58 450L238 633 196 896C188 942 238 975 275 954L500 837 725 954C767 975 813 942 804 896L763 633 942 450C975 417 954 358 913 350L663 312 550 75C529 33 471 33 450 75Z\"><\/path><\/svg>\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-97ea64f elementor-widget elementor-widget-heading\" data-id=\"97ea64f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">4,5<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5bdba5d elementor-widget elementor-widget-heading\" data-id=\"5bdba5d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<span class=\"elementor-heading-title elementor-size-default\">2,2 K notes<\/span>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-74124b0 e-con-full e-flex e-con e-child\" data-id=\"74124b0\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t<div class=\"elementor-element elementor-element-39e7f8d e-con-full e-flex e-con e-child\" data-id=\"39e7f8d\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f7ee0c8 elementor-position-inline-start elementor-mobile-position-inline-start elementor-view-default elementor-widget elementor-widget-icon-box\" data-id=\"f7ee0c8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<span  class=\"elementor-icon\">\n\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"28\" height=\"28\" viewBox=\"0 0 28 28\" fill=\"none\"><rect width=\"28\" height=\"28\" rx=\"14\" fill=\"#E33D2E\"><\/rect><mask id=\"mask0_607_300\" style=\"mask-type:alpha\" maskUnits=\"userSpaceOnUse\" x=\"2\" y=\"2\" width=\"24\" height=\"24\"><rect x=\"2\" y=\"2\" width=\"24\" height=\"24\" fill=\"#D9D9D9\"><\/rect><\/mask><g mask=\"url(#mask0_607_300)\"><path d=\"M8.69221 24.5V16.9098L5.35571 11.5L9.67296 4.5H18.327L22.6442 11.5L19.3077 16.9098V24.5L14 22.702L8.69221 24.5ZM10.1922 22.3788L14 21.1115L17.8077 22.3788V18.5H10.1922V22.3788ZM10.5095 6L7.10946 11.5L10.5095 17H17.4905L20.8905 11.5L17.4905 6H10.5095ZM12.95 15.2192L9.75571 12.05L10.825 10.9807L12.95 13.1058L17.175 8.85575L18.2442 9.9L12.95 15.2192Z\" fill=\"white\"><\/path><\/g><\/svg>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<span  >\n\t\t\t\t\t\t\tN\u00b01 du BTP\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\ten France\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-eae9292 e-con-full e-flex e-con e-child\" data-id=\"eae9292\" data-element_type=\"container\" data-e-type=\"container\" data-settings=\"{&quot;jet_parallax_layout_list&quot;:[]}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-978e3f1 elementor-position-inline-start elementor-mobile-position-inline-start elementor-view-default elementor-widget elementor-widget-icon-box\" data-id=\"978e3f1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-box-wrapper\">\n\n\t\t\t\t\t\t<div class=\"elementor-icon-box-icon\">\n\t\t\t\t<span  class=\"elementor-icon\">\n\t\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"28\" height=\"28\" viewBox=\"0 0 28 28\" fill=\"none\"><rect width=\"28\" height=\"28\" rx=\"14\" fill=\"#E33D2E\"><\/rect><mask id=\"mask0_607_298\" style=\"mask-type:alpha\" maskUnits=\"userSpaceOnUse\" x=\"2\" y=\"2\" width=\"24\" height=\"24\"><rect x=\"2\" y=\"2\" width=\"24\" height=\"24\" fill=\"#D9D9D9\"><\/rect><\/mask><g mask=\"url(#mask0_607_298)\"><path d=\"M8.023 19.2923C8.873 18.6616 9.799 18.1635 10.801 17.798C11.8028 17.4327 12.8692 17.25 14 17.25C15.1308 17.25 16.1972 17.4327 17.199 17.798C18.201 18.1635 19.127 18.6616 19.977 19.2923C20.5987 18.6089 21.0913 17.8179 21.4548 16.9192C21.8183 16.0206 22 15.0475 22 14C22 11.7833 21.2208 9.89583 19.6625 8.3375C18.1042 6.77917 16.2167 6 14 6C11.7833 6 9.89583 6.77917 8.3375 8.3375C6.77917 9.89583 6 11.7833 6 14C6 15.0475 6.18175 16.0206 6.54525 16.9192C6.90875 17.8179 7.40133 18.6089 8.023 19.2923ZM14.0003 14.75C13.0873 14.75 12.3173 14.4367 11.6905 13.81C11.0635 13.1832 10.75 12.4133 10.75 11.5003C10.75 10.5873 11.0633 9.81733 11.69 9.1905C12.3168 8.5635 13.0868 8.25 13.9998 8.25C14.9128 8.25 15.6827 8.56333 16.3095 9.19C16.9365 9.81683 17.25 10.5867 17.25 11.4997C17.25 12.4127 16.9367 13.1827 16.31 13.8095C15.6832 14.4365 14.9133 14.75 14.0003 14.75ZM14 23.5C12.6808 23.5 11.4433 23.2519 10.2875 22.7558C9.13167 22.2596 8.12625 21.5839 7.27125 20.7288C6.41608 19.8738 5.74042 18.8683 5.24425 17.7125C4.74808 16.5567 4.5 15.3192 4.5 14C4.5 12.6808 4.74808 11.4433 5.24425 10.2875C5.74042 9.13167 6.41608 8.12625 7.27125 7.27125C8.12625 6.41608 9.13167 5.74042 10.2875 5.24425C11.4433 4.74808 12.6808 4.5 14 4.5C15.3192 4.5 16.5567 4.74808 17.7125 5.24425C18.8683 5.74042 19.8738 6.41608 20.7288 7.27125C21.5839 8.12625 22.2596 9.13167 22.7558 10.2875C23.2519 11.4433 23.5 12.6808 23.5 14C23.5 15.3192 23.2519 16.5567 22.7558 17.7125C22.2596 18.8683 21.5839 19.8738 20.7288 20.7288C19.8738 21.5839 18.8683 22.2596 17.7125 22.7558C16.5567 23.2519 15.3192 23.5 14 23.5ZM14 22C14.9025 22 15.7727 21.8548 16.6105 21.5645C17.4483 21.274 18.1922 20.8679 18.8422 20.3462C18.1922 19.8436 17.458 19.4519 16.6395 19.1712C15.8208 18.8904 14.941 18.75 14 18.75C13.059 18.75 12.1776 18.8888 11.3558 19.1663C10.5339 19.4439 9.80125 19.8372 9.15775 20.3462C9.80775 20.8679 10.5517 21.274 11.3895 21.5645C12.2273 21.8548 13.0975 22 14 22ZM14 13.25C14.4975 13.25 14.9135 13.0827 15.248 12.748C15.5827 12.4135 15.75 11.9975 15.75 11.5C15.75 11.0025 15.5827 10.5865 15.248 10.252C14.9135 9.91733 14.4975 9.75 14 9.75C13.5025 9.75 13.0865 9.91733 12.752 10.252C12.4173 10.5865 12.25 11.0025 12.25 11.5C12.25 11.9975 12.4173 12.4135 12.752 12.748C13.0865 13.0827 13.5025 13.25 14 13.25Z\" fill=\"white\"><\/path><\/g><\/svg>\t\t\t\t<\/span>\n\t\t\t<\/div>\n\t\t\t\n\t\t\t\t\t\t<div class=\"elementor-icon-box-content\">\n\n\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-box-title\">\n\t\t\t\t\t\t<span  >\n\t\t\t\t\t\t\t+150 000\t\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<p class=\"elementor-icon-box-description\">\n\t\t\t\t\t\tUtilisateurs\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t<\/div>\n\t\t\t\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<a href=\"https:\/\/auth.archipad.com\/registration?return_to=https:\/\/archipad.com\/fr\/page-remerciement-inscription\" class=\"jet-engine-listing-overlay-link\" target=\"_blank\"><\/a><\/div><\/div><\/div><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d850a53 elementor-widget elementor-widget-heading\" data-id=\"d850a53\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-heading-title elementor-size-default\"><span id=\"docs-internal-guid-e36d8928-7fff-aca6-5f10-1b1fbfedfd98\"><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Qu\u2019est-ce qu\u2019un plan de charge Excel ?<\/span><\/h2><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Un plan de charge Excel est un tableau qui permet de rapprocher le travail \u00e0 r\u00e9aliser et les moyens disponibles pour le r\u00e9aliser. Il sert \u00e0 r\u00e9partir les charges de travail dans le temps, \u00e0 visualiser les ressources disponibles et \u00e0 organiser les affectations.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Le plan de charge Excel permet de suivre trois dimensions :<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">le travail \u00e0 r\u00e9aliser : projets, missions ou t\u00e2ches ;<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">les ressources mobilis\u00e9es : personnes, \u00e9quipes ou profils ;<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">la capacit\u00e9 et la charge par p\u00e9riode : jours, heures ou pourcentage.<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Le <\/span><a href=\"https:\/\/archipad.com\/fr\/plan-charge\/\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">plan de charge<\/span><\/a><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> ajoute une lecture de r\u00e9partition : il montre quelle ressource intervient, sur quel volume de travail et avec quel niveau de charge sur la p\u00e9riode.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Sur <\/span><a href=\"https:\/\/www.microsoft.com\/fr-fr\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Excel<\/span><\/a><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">, ce suivi prend la forme d\u2019un tableau organis\u00e9 par semaine ou par mois.&nbsp;<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Mod\u00e8le de plan de charge \u00e0 t\u00e9l\u00e9charger&nbsp;<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Voici un mod\u00e8le de plan de charge Excel con\u00e7u pour le BTP, \u00e0 adapter selon votre activit\u00e9.&nbsp;<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><a href=\"https:\/\/docs.google.com\/spreadsheets\/u\/0\/d\/1dPrxIwcsNTodgYuHKAfIoueyb9tkDP8bB6fZ4hkxbwU\/edit\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\" data-rich-links=\"{&quot;fple-t&quot;:&quot;Mod\u00e8le avec exemple de plan de charge \u00e0 t\u00e9l\u00e9charger &quot;,&quot;fple-u&quot;:&quot;https:\/\/docs.google.com\/spreadsheets\/u\/0\/d\/1dPrxIwcsNTodgYuHKAfIoueyb9tkDP8bB6fZ4hkxbwU\/edit&quot;,&quot;fple-mt&quot;:&quot;application\/vnd.google-apps.spreadsheet&quot;,&quot;type&quot;:&quot;first-party-link&quot;}\">Mod\u00e8le avec exemple de plan de charge \u00e0 t\u00e9l\u00e9charger <\/span><\/a><\/p><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Quelles donn\u00e9es doit contenir un plan de charge sur excel ?<\/span><\/h2><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Un plan de charge Excel rassemble les donn\u00e9es utiles au suivi de l\u2019activit\u00e9 : la charge pr\u00e9vue, la capacit\u00e9 disponible et la r\u00e9partition des affectations.&nbsp;<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Sa structure doit faciliter la saisie, la lecture et l\u2019analyse.&nbsp;<\/span><\/p><div dir=\"ltr\" style=\"margin-left:0pt\" align=\"center\"><table style=\"border: none\"><colgroup><col width=\"185\"><col width=\"220\"><col width=\"220\"><\/colgroup><tbody><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c9l\u00e9ment \u00e0 int\u00e9grer<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c0 quoi cela sert<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Exemples de donn\u00e9es \u00e0 renseigner<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Ressources disponibles<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Visualiser qui peut \u00eatre mobilis\u00e9<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">noms, \u00e9quipes, fonctions, capacit\u00e9 hebdomadaire<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Charges de travail<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Identifier le volume de travail \u00e0 r\u00e9partir<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">t\u00e2ches, projets, missions, lots, <\/span><a href=\"https:\/\/archipad.com\/fr\/les-10-meilleurs-logiciels-de-gestion-des-interventions-btp-2026\/\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">interventions<\/span><\/a><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">P\u00e9riode de suivi<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Organiser la lecture dans le temps<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">semaines, mois, dates de d\u00e9but et de fin<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Disponibilit\u00e9s r\u00e9elles<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Ajuster la capacit\u00e9 th\u00e9orique<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">cong\u00e9s, absences, formations, indisponibilit\u00e9s<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Unit\u00e9 de mesure<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Garder un calcul coh\u00e9rent<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">heures, jours, pourcentage de charge<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">R\u00e9partition par ressource<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Savoir qui fait quoi<\/span><\/p><\/td><td style=\"border-width: 0.5pt;vertical-align: middle;padding: 4.98898pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">charge affect\u00e9e par personne ou par \u00e9quipe<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Cette base permet ensuite de <\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">calculer automatiquement<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> la charge et ainsi de suivre le taux de charge avec une lecture plus structur\u00e9e.<\/span><\/p><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Comment cr\u00e9er et structurer un plan de charge sur Excel ?<\/span><\/h2><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Pour qu\u2019un plan de charge Excel soit optimal, il doit \u00eatre simple \u00e0 lire et rapide \u00e0 mettre \u00e0 jour. Le plus efficace consiste \u00e0 construire un tableau avec les ressources en lignes et les p\u00e9riodes en colonnes, puis \u00e0 y r\u00e9partir la charge pr\u00e9vue par projet.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c9tape 1 : d\u00e9finir la structure du fichier Excel<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Commencez par cr\u00e9er un fichier avec un onglet principal d\u00e9di\u00e9 au plan de charge. Vous pouvez aussi ajouter un onglet \u201cRessources\u201d et un onglet \u201cProjets\u201d si vous voulez mieux organiser vos donn\u00e9es.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Dans cet onglet, placez en g\u00e9n\u00e9ral :<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">les collaborateurs ou \u00e9quipes en lignes<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">les semaines ou les mois en colonnes<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Cette structure permet de voir rapidement qui est disponible, qui est charg\u00e9, et \u00e0 quel moment.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c9tape 2 : cr\u00e9er les bonnes colonnes<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Avant les colonnes de p\u00e9riodes, ajoutez quelques colonnes fixes pour identifier clairement chaque ressource. Par exemple :<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Nom de la ressource<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Fonction ou \u00e9quipe<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Capacit\u00e9 disponible<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Projet principal ou chantier<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">Priorit\u00e9 ou remarque<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Ensuite, cr\u00e9ez une colonne par semaine ou par mois selon votre besoin. Pour une entreprise du BTP, une lecture <\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">hebdomadaire<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> est souvent plus utile pour g\u00e9rer l\u2019activit\u00e9.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c9tape 3 : renseigner les lignes avec les ressources<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Chaque ligne doit correspondre \u00e0 une ressource \u00e0 suivre. Il peut s\u2019agir d\u2019un conducteur de travaux, d\u2019un chef de projet, d\u2019une \u00e9quipe terrain ou d\u2019un profil support.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Une ligne = une ressource. Vous pouvez aussi choisir une ligne par \u00e9quipe si vous pr\u00e9f\u00e9rez une vue plus synth\u00e9tique. Le bon niveau de d\u00e9tail d\u00e9pend du volume de projets \u00e0 suivre et du niveau de pilotage recherch\u00e9.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c9tape 4 : remplir la charge pr\u00e9vue par p\u00e9riode<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Dans les cellules du tableau, indiquez la charge pr\u00e9vue pour chaque ressource sur chaque p\u00e9riode. Cette charge peut \u00eatre exprim\u00e9e en heures, en jours ou en pourcentage.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Par exemple :<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">5 jours sur la semaine 18<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">50 % sur le mois de juin<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">14 heures sur une p\u00e9riode donn\u00e9e<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Vous pouvez aussi distinguer les projets avec un code couleur ou ajouter une note pour pr\u00e9ciser le chantier concern\u00e9. L\u2019objectif est de visualiser rapidement la r\u00e9partition des charges de travail pr\u00e9vues.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">\u00c9tape 5 : ajouter les indicateurs utiles<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Pour rendre le tableau vraiment exploitable, pr\u00e9voyez une ligne ou une colonne de synth\u00e8se avec les indicateurs cl\u00e9s :<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">charge pr\u00e9vue<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">capacit\u00e9 disponible<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">\u00e9cart<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">taux de charge<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Vous pouvez ensuite utiliser une mise en forme conditionnelle :<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">vert si la charge est \u00e9quilibr\u00e9e<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">orange si la charge approche de la limite<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">rouge en cas de surcharge<\/span><\/p><\/li><\/ul><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">C\u2019est ce qui permet de rep\u00e9rer d\u2019un coup d\u2019\u0153il les tensions, les ressources disponibles et les p\u00e9riodes \u00e0 arbitrer.<\/span><\/p><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Comment calculer la charge et le taux de charge dans Excel ?&nbsp;<\/span><\/h2><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Dans un plan de charge, quelques calculs permettent de suivre la r\u00e9partition du travail et le niveau d\u2019occupation des ressources : la charge pr\u00e9vue, la capacit\u00e9 disponible, le taux de charge et la capacit\u00e9 restante.<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"><br><br><\/span><\/p><div dir=\"ltr\" style=\"margin-left:0pt\" align=\"center\"><table style=\"border: none\"><colgroup><col width=\"123\"><col width=\"194\"><col width=\"166\"><col width=\"158\"><\/colgroup><tbody><tr style=\"height:0pt\"><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Calcul<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">D\u00e9finition<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Formule de calcul<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;text-align: center;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Exemple Formule Excel<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Charge pr\u00e9vue<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">La charge pr\u00e9vue correspond au volume de travail affect\u00e9 \u00e0 une ressource sur une p\u00e9riode donn\u00e9e.<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Charge pr\u00e9vue =<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> somme des temps affect\u00e9s sur la p\u00e9riode<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">=SOMME(B2:D2)<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Capacit\u00e9 disponible<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">La capacit\u00e9 disponible correspond au temps r\u00e9ellement mobilisable sur la p\u00e9riode.<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Capacit\u00e9 disponible =<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> capacit\u00e9 th\u00e9orique - absences - indisponibilit\u00e9s<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">=(5*2)-1<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Taux de charge<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Le taux de charge permet de comparer la charge pr\u00e9vue \u00e0 la capacit\u00e9 disponible.<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Taux de charge =<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> (charge pr\u00e9vue \/ capacit\u00e9 disponible) x 100<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">=F2\/G2<\/span><\/p><\/td><\/tr><tr style=\"height:0pt\"><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Capacit\u00e9 restante<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">La capacit\u00e9 restante permet de visualiser le volume encore mobilisable sur la p\u00e9riode.<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Capacit\u00e9 restante =<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> capacit\u00e9 disponible - charge pr\u00e9vue<\/span><\/p><\/td><td style=\"border-width: 1pt;vertical-align: middle;padding: 3.28819pt;overflow: hidden\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:6pt;margin-bottom:6pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">=G2-F2<\/span><\/p><\/td><\/tr><\/tbody><\/table><\/div><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Les erreurs fr\u00e9quentes avec un plan de charge Excel<\/span><\/h2><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Un fichier trop complexe : <\/span><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">trop d\u2019onglets ou de formules ralentissent la saisie et la lecture.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Des donn\u00e9es peu mises \u00e0 jour<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Une confusion entre capacit\u00e9 th\u00e9orique et r\u00e9elle : <\/span><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">les cong\u00e9s, absences ou indisponibilit\u00e9s doivent \u00eatre int\u00e9gr\u00e9s au calcul.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Une absence de vue globale :<\/span><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\"> une lecture par p\u00e9riode aide \u00e0 rep\u00e9rer plus vite les \u00e9carts de charge.<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;font-weight: 700;vertical-align: baseline\">Une charge sur Excel plus difficile \u00e0 suivre avec plusieurs projets : <\/span><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">quand les projets se multiplient, le tableau demande une structure tr\u00e8s claire pour rester exploitable.<\/span><\/p><\/li><\/ul><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Quand passer d\u2019Excel \u00e0 un outil de suivi plus adapt\u00e9<\/span><\/h2><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Excel atteint ses limites quand le suivi du plan de charge prend trop de temps ou ne permet plus d\u2019avoir une vision claire de l\u2019activit\u00e9. C\u2019est souvent le cas quand les chantiers sont nombreux et que les affectations varient.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Si le fichier devient difficile \u00e0 maintenir ou qu\u2019il ne permet plus d\u2019arbitrer rapidement, il est sans doute temps de passer \u00e0 un outil plus adapt\u00e9.&nbsp;<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">C\u2019est pr\u00e9cis\u00e9ment l\u00e0 qu\u2019un <\/span><a href=\"https:\/\/archipad.com\/fr\/logiciel-suivi-chantier\/\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">logiciel de suivi de chantier<\/span><\/a><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> comme <\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Archipad<\/span><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"> apporte une vraie valeur ajout\u00e9e. En centralisant le suivi de chantier dans un seul outil, Archipad facilite :&nbsp;<\/span><\/p><ul style=\"margin-top:0;margin-bottom:0;padding-inline-start:48px\"><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">la planification et le suivi des \u00e9tapes du chantier ;<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:0pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">la centralisation des plans, <\/span><a href=\"https:\/\/archipad.com\/fr\/fonctionnalites\/multi-photos-commentaires-dessins-croquis\/\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">photos<\/span><\/a><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">, <\/span><a href=\"https:\/\/archipad.com\/fr\/fonctionnalites\/logiciel-compte-rendu-de-chantier\/\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">comptes rendus<\/span><\/a><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\"> et t\u00e2ches ;<\/span><\/p><\/li><li dir=\"ltr\" style=\"list-style-type: disc;font-size: 11pt;font-family: Montserrat, sans-serif\"><p dir=\"ltr\" style=\"line-height:1.38;margin-top:0pt;margin-bottom:12pt\" role=\"presentation\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">le suivi collaboratif des observations, <\/span><a href=\"https:\/\/archipad.com\/fr\/reserves-apres-reception-des-travaux-suivi-delais-et-garanties\/\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">r\u00e9serves<\/span><\/a><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\"> et <\/span><a href=\"https:\/\/archipad.com\/fr\/rapport-dintervention-definition-methode-et-modele-a-telecharger\/\"><span style=\"font-size: 11pt;background-color: transparent;vertical-align: baseline\">rapports<\/span><\/a><\/p><\/li><\/ul><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">Conclusion<\/span><\/h2><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Le plan de charge Excel permet de poser une base simple pour r\u00e9partir le travail et suivre les ressources sur une p\u00e9riode donn\u00e9e.<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">&nbsp;Avec un fichier bien structur\u00e9, il devient alors plus facile de visualiser la charge, d\u2019anticiper les besoins et d\u2019ajuster les affectations.&nbsp;<\/span><\/p><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">En revanche, quand les projets deviennent plus nombreux, le suivi demande souvent un outil plus fluide et plus centralis\u00e9. C\u2019est pourquoi, adopter un logiciel comme Archipad peut apporter une r\u00e9elle plus-value dans l\u2019organisation de tous vos projets BTP.<\/span><\/p><h2 dir=\"ltr\" style=\"line-height:1.38;margin-top:18pt;margin-bottom:4pt\"><span style=\"font-size: 17pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">FAQ<\/span><\/h2><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">1. Qu\u2019est-ce qu\u2019un plan de charge Excel ?<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">C\u2019est un plan de charge sous forme de tableau excel, qui sert \u00e0 r\u00e9partir le travail, suivre les ressources disponibles et visualiser la charge sur une p\u00e9riode donn\u00e9e.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">2. Comment cr\u00e9er un plan de charge sur Excel ?<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Il faut d\u00e9finir une p\u00e9riode de suivi, lister les ressources, ajouter les t\u00e2ches, puis r\u00e9partir la charge dans un tableau organis\u00e9 par semaine ou par mois.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">3. Comment calculer le taux de charge sur Excel ?<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Le taux de charge se calcule avec la formule suivante : (charge pr\u00e9vue \/ capacit\u00e9 disponible) x 100.<\/span><\/p><h3 dir=\"ltr\" style=\"line-height:1.38;margin-top:14pt;margin-bottom:4pt\"><span style=\"font-size: 13pt;font-family: Montserrat, sans-serif;background-color: transparent;font-weight: 700;vertical-align: baseline\">4. Excel suffit-il pour g\u00e9rer plusieurs projets ou plusieurs chantiers ?<\/span><\/h3><p dir=\"ltr\" style=\"line-height:1.38;margin-top:12pt;margin-bottom:12pt\"><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\">Excel peut tr\u00e8s bien convenir pour un suivi simple. En revanche, quand les projets se multiplient, un outil d\u00e9di\u00e9 apporte un suivi plus fluide, plus complet et plus centralis\u00e9.<\/span><\/p><div><span style=\"font-size: 11pt;font-family: Montserrat, sans-serif;background-color: transparent;vertical-align: baseline\"><br><\/span><\/div><\/span><\/div>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Plan de charge Excel : comment cr\u00e9er un fichier clair en 5 \u00e9tapes ?&nbsp; Un plan de charge Excel permet de r\u00e9partir les charges de travail, de suivre les ressources disponibles et d\u2019organiser les projets sur une m\u00eame base. Dans cet article, nous allons d\u00e9tailler les donn\u00e9es \u00e0 int\u00e9grer dans le fichier, la mani\u00e8re de [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":18762,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jet_sm_ready_style":"","_jet_sm_style":"","_jet_sm_controls_values":"","_jet_sm_fonts_collection":"","_jet_sm_fonts_links":"","footnotes":""},"categories":[179],"tags":[],"class_list":["post-18761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-productivite-construction"],"_links":{"self":[{"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/posts\/18761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/comments?post=18761"}],"version-history":[{"count":5,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/posts\/18761\/revisions"}],"predecessor-version":[{"id":18771,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/posts\/18761\/revisions\/18771"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/media\/18762"}],"wp:attachment":[{"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/media?parent=18761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/categories?post=18761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/archipad.com\/fr\/wp-json\/wp\/v2\/tags?post=18761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}