{"id":2300,"date":"2021-01-25T15:54:26","date_gmt":"2021-01-25T15:54:26","guid":{"rendered":"https:\/\/pickedshares.com\/?p=2300"},"modified":"2021-04-23T13:16:04","modified_gmt":"2021-04-23T13:16:04","slug":"milestone-trend-analysis-incl-excel-template","status":"publish","type":"post","link":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/","title":{"rendered":"Milestone trend analysis (incl. Excel template)"},"content":{"rendered":"\n<p>The milestone trend analysis (MTA) is used in project management to keep an overview of the key dates of the project. It is updated regularly on the respective reporting dates.<\/p>\n\n\n\n<p>The prerequisite for the effective use of the MTA is, as the name suggests, the planning of milestones or <a href=\"https:\/\/en.wikipedia.org\/wiki\/Phase-gate_process\" target=\"_blank\" rel=\"noreferrer noopener\">stage gates (phase gates)<\/a> in the project as well as regular reporting.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"567\" src=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en-1024x567.png\" alt=\"Milestone trend analysis with Excel, without report data\" class=\"wp-image-2280\" srcset=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en-1024x567.png 1024w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en-300x166.png 300w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en-768x425.png 768w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en-400x221.png 400w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en-800x443.png 800w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_empty_en.png 1174w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>MTA with Excel, without report data<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How do you fill the MTA?<\/h2>\n\n\n\n<p>The figure below shows the top left corner of the MTA. The different input fields are highlighted in color.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"225\" src=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/howto_en.png\" alt=\"Exemplary completed milestone trend analysis\" class=\"wp-image-2276\"\/><figcaption>Exemplary completed MTA<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li>Yellow: the designation of the milestone, here referred as MS1<\/li><li>Green: the initial planned date of the milestone, here  01.05.2022<\/li><li>Blue: the reporting date on which the estimate of the milestone dates is submitted <\/li><li>Purple: the expected completion date for milestone MS1<\/li><\/ul>\n\n\n\n<p>The interpretation of the MTA is as follows:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">The project is going exactly as originally planned<\/h3>\n\n\n\n<p>The lines are all horizontal in this case. Each milestone has its own color in the following illustration.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"574\" src=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en-1024x574.png\" alt=\"Milestone trend analysis with Excel, ongoing project exactly as planned\" class=\"wp-image-2284\" srcset=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en-1024x574.png 1024w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en-300x168.png 300w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en-768x431.png 768w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en-400x224.png 400w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en-800x449.png 800w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_perfect_en.png 1168w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Milestone trend analysis with Excel, ongoing project exactly as planned<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">The expected dates fluctuate, but things are going better than planned<\/h3>\n\n\n\n<p>The lines leave their original horizontal paths, but they run downwards towards the finish line (black).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"570\" src=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en-1024x570.png\" alt=\"Milestone trend analysis with Excel, better than planned project\" class=\"wp-image-2282\" srcset=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en-1024x570.png 1024w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en-300x167.png 300w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en-768x427.png 768w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en-400x223.png 400w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en-800x445.png 800w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta_moving_better_en.png 1168w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Milestone trend analysis with Excel, better than planned project<\/figcaption><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">The expected dates vary, the project is taking longer than planned<\/h3>\n\n\n\n<p>The lines leave their horizontal path in an upward direction. A worst-case scenario is when the lines run upwards and move parallel to the finish line: in this case the project goal will not be achieved.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"565\" src=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en-1024x565.png\" alt=\"Milestone trend analysis with Excel, project running longer than planned\" class=\"wp-image-2278\" srcset=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en-1024x565.png 1024w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en-300x166.png 300w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en-768x424.png 768w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en-400x221.png 400w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en-800x441.png 800w, https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/mta-worse_en.png 1167w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Milestone trend analysis with Excel, project running longer than planned<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">The Excel template<\/h2>\n\n\n\n<p>Please support this site by registering for the newsletter - we will send you the download link for the excel template for the milestone trend analysis in exchange.<\/p>\n\n\n<!-- Begin Mailchimp Signup Form -->\r\n<link href=\"\/\/cdn-images.mailchimp.com\/embedcode\/classic-10_7.css\" rel=\"stylesheet\" type=\"text\/css\">\r\n<style type=\"text\/css\">\r\n\t#mc_embed_signup{background:#fff; clear:left; font:14px Helvetica,Arial,sans-serif;margin:3em; }\r\n\t@media only screen and (max-width: 1000px) { \r\n \t\t#mc_embed_signup {margin-left: 0.5em;margin-right: 0.5em;}\r\n\t}\r\n\t\/* Add your own Mailchimp form style overrides in your site stylesheet or in this style block.\r\n\t   We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. *\/\r\n<\/style>\r\n<style type=\"text\/css\">\r\n\t#mc-embedded-subscribe-form input[type=checkbox]{display: inline; width: auto;margin-right: 10px;}\r\n\t#mergeRow-gdpr {margin-top: 20px;}\r\n\t#mergeRow-gdpr fieldset label {font-weight: normal;}\r\n\t#mc-embedded-subscribe-form .mc_fieldset{border:none;min-height: 0px;padding-bottom:0px;}\r\n<\/style>\r\n<div id=\"mc_embed_signup\" style=\"padding:1em;border: 1px solid gray;border-radius:5px;\">\r\n<form action=\"https:\/\/pickedshares.us1.list-manage.com\/subscribe\/post?u=3746595e7f1527298204504e1&amp;id=3337a935fa&SIGNREASON=freebie2_en\" method=\"post\" id=\"mc-embedded-subscribe-form\" name=\"mc-embedded-subscribe-form\" class=\"validate\" target=\"_blank\" novalidate>\r\n    <div id=\"mc_embed_signup_scroll\">\r\n\t<h3>Subscribe<\/h3>\r\n<div class=\"indicates-required\"><span class=\"asterisk\">*<\/span> indicates required<\/div>\r\n<div class=\"mc-field-group\">\r\n\t<label for=\"mce-EMAIL\">E-mail-address  <span class=\"asterisk\">*<\/span>\r\n<\/label>\r\n\t<input type=\"email\" value=\"\" name=\"EMAIL\" class=\"required email\" id=\"mce-EMAIL\">\r\n<\/div>\r\n<div class=\"mc-field-group input-group\" style=\"padding-top:1em;\">\r\n    <span><strong>I'm interested in (voluntary information) <\/strong><\/span>\r\n    <ul style=\"list-style-type:none\"><li><input type=\"checkbox\" value=\"1\" name=\"group[379134][1]\" id=\"mce-group[379134]-379134-0\"><label for=\"mce-group[379134]-379134-0\">Project management<\/label><\/li>\r\n<li><input type=\"checkbox\" value=\"2\" name=\"group[379134][2]\" id=\"mce-group[379134]-379134-1\"><label for=\"mce-group[379134]-379134-1\">Engineering design<\/label><\/li>\r\n<li><input type=\"checkbox\" value=\"4\" name=\"group[379134][4]\" id=\"mce-group[379134]-379134-2\"><label for=\"mce-group[379134]-379134-2\">Exercises<\/label><\/li>\r\n<li><input type=\"checkbox\" value=\"8\" name=\"group[379134][8]\" id=\"mce-group[379134]-379134-3\"><label for=\"mce-group[379134]-379134-3\">Software\/Tools<\/label><\/li>\r\n<\/ul>\r\n<\/div>\r\n<div id=\"mergeRow-gdpr\" class=\"mergeRow gdpr-mergeRow content__gdprBlock mc-field-group\">\r\n    <div class=\"content__gdpr\">\r\n        <p><strong>Marketing permission<\/strong><\/p>\r\n        <p>Pickedshares.com sends out newsletters regularly (1-4 times per month) by email. These newsletters contain information about new content on pickedshares.com, thematically relevant information and advertising. If you would like to receive these emails, please select the following option:<\/p>\r\n        <fieldset class=\"mc_fieldset gdprRequired mc-field-group\" name=\"interestgroup_field\">\r\n\t\t<label class=\"checkbox subfield\" for=\"gdpr_43490\"><input type=\"checkbox\" id=\"gdpr_43490\" name=\"gdpr[43490]\" value=\"Y\" class=\"av-checkbox gdpr\"><span>E-mail (information and advertising)<\/span> <\/label>\r\n        <\/fieldset>\r\n        <p style=\"padding-top:1em;\">You can unsubscribe at any time by clicking the link in the footer of our emails. You can find information about our data protection practices on our website.<\/p>\r\n    <\/div>\r\n    <div class=\"content__gdprLegal\">\r\n        <p>We use Mailchimp as our marketing platform. By clicking below to subscribe, you confirm that your data will be transferred to Mailchimp for processing. <a href=\"https:\/\/mailchimp.com\/legal\/\" target=\"_blank\" rel=\"noopener\">Learn more about Mailchimp's privacy practices here.<\/a><\/p>\r\n    <\/div>\r\n<\/div>\r\n\t<div id=\"mce-responses\" class=\"clear\">\r\n\t\t<div class=\"response\" id=\"mce-error-response\" style=\"display:none\"><\/div>\r\n\t\t<div class=\"response\" id=\"mce-success-response\" style=\"display:none\"><\/div>\r\n\t<\/div>    <!-- real people should not fill this in and expect good things - do not remove this or risk form bot signups-->\r\n    <div style=\"position: absolute; left: -5000px;\" aria-hidden=\"true\"><input type=\"text\" name=\"b_3746595e7f1527298204504e1_3337a935fa\" tabindex=\"-1\" value=\"\"><\/div>\r\n    <div class=\"clear\"><input type=\"submit\" value=\"Subscribe now!\" name=\"subscribe\" id=\"mc-embedded-subscribe\" class=\"button\" style=\"background-color:DodgerBlue;\"><\/div>\r\n    <\/div>\r\n<\/form>\r\n<\/div>\r\n<script type='text\/javascript' src='\/\/s3.amazonaws.com\/downloads.mailchimp.com\/js\/mc-validate.js'><\/script><script type='text\/javascript'>(function($) {window.fnames = new Array(); window.ftypes = new Array();fnames[0]='EMAIL';ftypes[0]='email';fnames[1]='SIGNREASON';ftypes[1]='text'; \/*\r\n * Translated default messages for the $ validation plugin.\r\n * Locale: DE\r\n *\/\r\n$.extend($.validator.messages, {\r\n\trequired: \"This field is required.\",\r\n\tmaxlength: $.validator.format(\"Geben Sie bitte maximal {0} Zeichen ein.\"),\r\n\tminlength: $.validator.format(\"Geben Sie bitte mindestens {0} Zeichen ein.\"),\r\n\trangelength: $.validator.format(\"Geben Sie bitte mindestens {0} und maximal {1} Zeichen ein.\"),\r\n\temail: \"Please type in a valid E-mail-address.\",\r\n\turl: \"Geben Sie bitte eine g\u00fcltige URL ein.\",\r\n\tdate: \"Bitte geben Sie ein g\u00fcltiges Datum ein.\",\r\n\tnumber: \"Geben Sie bitte eine Nummer ein.\",\r\n\tdigits: \"Geben Sie bitte nur Ziffern ein.\",\r\n\tequalTo: \"Bitte denselben Wert wiederholen.\",\r\n\trange: $.validator.format(\"Geben Sie bitten einen Wert zwischen {0} und {1}.\"),\r\n\tmax: $.validator.format(\"Geben Sie bitte einen Wert kleiner oder gleich {0} ein.\"),\r\n\tmin: $.validator.format(\"Geben Sie bitte einen Wert gr\u00f6\u00dfer oder gleich {0} ein.\"),\r\n\tcreditcard: \"Geben Sie bitte ein g\u00fcltige Kreditkarten-Nummer ein.\"\r\n});}(jQuery));var $mcj = jQuery.noConflict(true);<\/script>\r\n<!--End mc_embed_signup-->\n\n\n\n<p><\/p>\n\n\n\n<p>If you don't want to support this site, you can download the excel template <a href=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/template-milestone-trend-analysis_v1.xlsx\">here<\/a>. <\/p>\n","protected":false},"excerpt":{"rendered":"<p> ... <a title=\"Milestone trend analysis (incl. Excel template)\" class=\"read-more\" href=\"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/\" aria-label=\"Read more about Milestone trend analysis (incl. Excel template)\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":2295,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[58,77],"tags":[],"class_list":["post-2300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to","category-project-management","infinite-scroll-item","masonry-post","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Milestone trend analysis (incl. Excel template) &#8226; pickedshares<\/title>\n<meta name=\"description\" content=\"This is a short overview how to apply the milestone trend analysis in your project and how to read it. Including excel template.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Milestone trend analysis (incl. Excel template) &#8226; pickedshares\" \/>\n<meta property=\"og:description\" content=\"This is a short overview how to apply the milestone trend analysis in your project and how to read it. Including excel template.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/\" \/>\n<meta property=\"og:site_name\" content=\"pickedshares\" \/>\n<meta property=\"article:published_time\" content=\"2021-01-25T15:54:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-23T13:16:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_twit_en.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1091\" \/>\n\t<meta property=\"og:image:height\" content=\"718\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_twit_en.png\" \/>\n<meta name=\"twitter:creator\" content=\"@pickedshares\" \/>\n<meta name=\"twitter:site\" content=\"@pickedshares\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#\\\/schema\\\/person\\\/6c617a6a61de9623da53f74a56810033\"},\"headline\":\"Milestone trend analysis (incl. Excel template)\",\"datePublished\":\"2021-01-25T15:54:26+00:00\",\"dateModified\":\"2021-04-23T13:16:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/\"},\"wordCount\":333,\"publisher\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pickedshares.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/post_mta_thumbnail_en.png\",\"articleSection\":[\"How-to\",\"Project Management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/\",\"url\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/\",\"name\":\"Milestone trend analysis (incl. Excel template) &#8226; pickedshares\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pickedshares.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/post_mta_thumbnail_en.png\",\"datePublished\":\"2021-01-25T15:54:26+00:00\",\"dateModified\":\"2021-04-23T13:16:04+00:00\",\"description\":\"This is a short overview how to apply the milestone trend analysis in your project and how to read it. Including excel template.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#primaryimage\",\"url\":\"https:\\\/\\\/pickedshares.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/post_mta_thumbnail_en.png\",\"contentUrl\":\"https:\\\/\\\/pickedshares.com\\\/wp-content\\\/uploads\\\/2021\\\/01\\\/post_mta_thumbnail_en.png\",\"width\":640,\"height\":384,\"caption\":\"Milestone trend analysis\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/milestone-trend-analysis-incl-excel-template\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Start\",\"item\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How-to\",\"item\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/category\\\/how-to\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Project Management\",\"item\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/category\\\/how-to\\\/project-management\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Milestone trend analysis (incl. Excel template)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/\",\"name\":\"pickedshares\",\"description\":\"Engineering Design, Project Management, Tools and Exercises\",\"publisher\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#organization\",\"name\":\"pickedshares.com\",\"url\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"pickedshares.com\"},\"image\":{\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/x.com\\\/pickedshares\",\"https:\\\/\\\/www.instagram.com\\\/pickedshares\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCSh8qo2-6dhtbZqSLStt3Rg\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pickedshares.com\\\/en\\\/#\\\/schema\\\/person\\\/6c617a6a61de9623da53f74a56810033\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/948d17e3c131a29d2f00c792d96bb1899342a69d8ccda0673ef9089a0988b3bd?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/948d17e3c131a29d2f00c792d96bb1899342a69d8ccda0673ef9089a0988b3bd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/948d17e3c131a29d2f00c792d96bb1899342a69d8ccda0673ef9089a0988b3bd?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\\\/\\\/pickedshares.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Milestone trend analysis (incl. Excel template) &#8226; pickedshares","description":"This is a short overview how to apply the milestone trend analysis in your project and how to read it. Including excel template.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/","og_locale":"en_US","og_type":"article","og_title":"Milestone trend analysis (incl. Excel template) &#8226; pickedshares","og_description":"This is a short overview how to apply the milestone trend analysis in your project and how to read it. Including excel template.","og_url":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/","og_site_name":"pickedshares","article_published_time":"2021-01-25T15:54:26+00:00","article_modified_time":"2021-04-23T13:16:04+00:00","og_image":[{"width":1091,"height":718,"url":"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_twit_en.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_image":"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_twit_en.png","twitter_creator":"@pickedshares","twitter_site":"@pickedshares","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#article","isPartOf":{"@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/"},"author":{"name":"admin","@id":"https:\/\/pickedshares.com\/en\/#\/schema\/person\/6c617a6a61de9623da53f74a56810033"},"headline":"Milestone trend analysis (incl. Excel template)","datePublished":"2021-01-25T15:54:26+00:00","dateModified":"2021-04-23T13:16:04+00:00","mainEntityOfPage":{"@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/"},"wordCount":333,"publisher":{"@id":"https:\/\/pickedshares.com\/en\/#organization"},"image":{"@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#primaryimage"},"thumbnailUrl":"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_thumbnail_en.png","articleSection":["How-to","Project Management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/","url":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/","name":"Milestone trend analysis (incl. Excel template) &#8226; pickedshares","isPartOf":{"@id":"https:\/\/pickedshares.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#primaryimage"},"image":{"@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#primaryimage"},"thumbnailUrl":"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_thumbnail_en.png","datePublished":"2021-01-25T15:54:26+00:00","dateModified":"2021-04-23T13:16:04+00:00","description":"This is a short overview how to apply the milestone trend analysis in your project and how to read it. Including excel template.","breadcrumb":{"@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#primaryimage","url":"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_thumbnail_en.png","contentUrl":"https:\/\/pickedshares.com\/wp-content\/uploads\/2021\/01\/post_mta_thumbnail_en.png","width":640,"height":384,"caption":"Milestone trend analysis"},{"@type":"BreadcrumbList","@id":"https:\/\/pickedshares.com\/en\/milestone-trend-analysis-incl-excel-template\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Start","item":"https:\/\/pickedshares.com\/en\/"},{"@type":"ListItem","position":2,"name":"How-to","item":"https:\/\/pickedshares.com\/en\/category\/how-to\/"},{"@type":"ListItem","position":3,"name":"Project Management","item":"https:\/\/pickedshares.com\/en\/category\/how-to\/project-management\/"},{"@type":"ListItem","position":4,"name":"Milestone trend analysis (incl. Excel template)"}]},{"@type":"WebSite","@id":"https:\/\/pickedshares.com\/en\/#website","url":"https:\/\/pickedshares.com\/en\/","name":"pickedshares","description":"Engineering Design, Project Management, Tools and Exercises","publisher":{"@id":"https:\/\/pickedshares.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pickedshares.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pickedshares.com\/en\/#organization","name":"pickedshares.com","url":"https:\/\/pickedshares.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pickedshares.com\/en\/#\/schema\/logo\/image\/","url":"","contentUrl":"","caption":"pickedshares.com"},"image":{"@id":"https:\/\/pickedshares.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/x.com\/pickedshares","https:\/\/www.instagram.com\/pickedshares\/","https:\/\/www.youtube.com\/channel\/UCSh8qo2-6dhtbZqSLStt3Rg"]},{"@type":"Person","@id":"https:\/\/pickedshares.com\/en\/#\/schema\/person\/6c617a6a61de9623da53f74a56810033","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/948d17e3c131a29d2f00c792d96bb1899342a69d8ccda0673ef9089a0988b3bd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/948d17e3c131a29d2f00c792d96bb1899342a69d8ccda0673ef9089a0988b3bd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/948d17e3c131a29d2f00c792d96bb1899342a69d8ccda0673ef9089a0988b3bd?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/pickedshares.com"]}]}},"_links":{"self":[{"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/posts\/2300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/comments?post=2300"}],"version-history":[{"count":7,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/posts\/2300\/revisions"}],"predecessor-version":[{"id":4753,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/posts\/2300\/revisions\/4753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/media\/2295"}],"wp:attachment":[{"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/media?parent=2300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/categories?post=2300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pickedshares.com\/en\/wp-json\/wp\/v2\/tags?post=2300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}