{"id":7919,"date":"2013-05-24t15:36:35","date_gmt":"2013-05-24t19:36:35","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=1829"},"modified":"2019-10-09t13:53:54","modified_gmt":"2019-10-09t17:53:54","slug":"p6-resource-s-curve-excel","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/","title":{"rendered":"graphing a p6 resource s-curve in excel"},"content":{"rendered":"<p><span style=\"font-size: 14px; line-height: 1.5em;\">in my <\/span><a style=\"font-size: 14px; line-height: 1.5em;\" title=\"how to export resource assignment data to excel from p6\" href=\"\/\/www.deco-dalles.com\/primavera-p6-tutorials\/how-to-export-resource-assignment-dasta-to-excel-1812\/\">previous tutorial in this series<\/a><span style=\"font-size: 14px; line-height: 1.5em;\">, i described the procedure to <a href=\"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/\" rel=\"noopener noreferrer\" target=\"_blank\">export resource assignment data from p6 to excel<\/a>.\u00a0most of us have worked with excel charts in our job or during our study in college or university. what we all know is that they are really helpful when you want to demonstrate some analytical information without technical terms. in this tutorial, i am going to tell you how to develop a resource <a title=\"what in the world is an s-curve? [in under 100 words]\" href=\"\/\/www.deco-dalles.com\/s-curve-definition-under-100-words\/\">s-curve<\/a> in excel with p6 data.<\/span><\/p>\n<h2>tutorial files<\/h2>\n<ul>\n<li><strong>excel spreadsheet (excel 2007+):\u00a0<a href=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/p6-scurve-example.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\">p6_scurve_example.xlsx<\/a>\u00a0&#8211; 1.5mb<\/strong><\/li>\n<\/ul>\n<h2>step 1 &#8211; export primavera p6 resource assignments\u00a0to excel<\/h2>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 1 - export primavera p6 resource assignments\u00a0to excel\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0011.png\" alt=\"step 1 - export primavera p6 resource assignments\u00a0to excel\" width=\"610\" height=\"457\" \/><\/p>\n<p>following the steps from our previous tutoril, you now have all the 世界杯时间比赛时间
 and assignments in an excel sheet. you can modify the primary sheet for better graphical features.<\/p>\n<h2>step 2 &#8211; how to use the data<\/h2>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 2 - how to use the data\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0021.png\" alt=\"step 2 - how to use the data\" width=\"610\" height=\"457\" \/><\/p>\n<p>to draw resource curves, what we need is the two highlighted rows which are the cumulative total and the incremental total. they have the information needed for each month. so we just copy and paste these two rows and the date row to another sheet to have more space doing our job.<\/p>\n<h2>step 3 &#8211; copy and paste the needed data in separate sheet<\/h2>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 3 - copy and paste the needed data in separate sheet\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0031.png\" alt=\"step 3 - copy and paste the needed data in separate sheet\" width=\"610\" height=\"457\" \/><\/p>\n<p>copy the data to separate worksheet. now we have all the tools to paint a perfect picture of our project 世界杯时间比赛时间
. all we need is to use some formula to calculate the percentage progress for each month in our table.<\/p>\n<h2>step 4 &#8211; calculate the\u00a0progress\u00a0percentage<\/h2>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 4 - calculate the\u00a0progress\u00a0percentage\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0041.png\" alt=\"step 4 - calculate the\u00a0progress\u00a0percentage\" width=\"610\" height=\"457\" \/><\/p>\n<p>to calculate interval progress and cumulative progress, just divide the value for each month (man hour needed for each month) by the total value (the summation of all man hours).\u00a0 you can see the formula in the excel file attached to this tutorial.<\/p>\n<h2>step 5 &#8211; graphing the s-curves<\/h2>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 5 - graphing the s-curves\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0051.png\" alt=\"step 5 - graphing the s-curves\" width=\"610\" height=\"342\" \/><\/p>\n<p>to graph any curve we should go to insert section of excel and then choose a chart type in charts tab. for this tutorial purpose we\u2019ll select the <strong>line chart<\/strong>.<\/p>\n<h2>step 6 &#8211; defining the s-curve&#8217;s 世界杯时间比赛时间
<\/h2>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0061.png\" alt=\"step 6 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"342\" \/><\/p>\n<p>right-click on the curves that excel generated by default, which is not the curve that we want, and choose \u201cselect data\u201d.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6.1 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0071.png\" alt=\"step 6.1 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"457\" \/><\/p>\n<p>remove all the predefined sources and then hit the <strong>\u201cadd\u201d<\/strong> button.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6.2 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0081.png\" alt=\"step 6.2 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"457\" \/><\/p>\n<p>in this box define all the sources one by one. we should do it 3 times to define all the sources for our final s-curve. i define all the series below:<\/p>\n<p><span style=\"text-decoration: underline;\"><div class=\"table-responsive\"><table  style=\"width:100%; \"  class=\"easy-table easy-table-default \" >\n<tbody>\r\n<tr><td >series name<\/td>\n<td >series values<\/td>\n<td >formula<\/span><\/td>\n<\/tr>\n\r\n<tr><td ><p style=\"text-align: left;\">monthly man hour<\/td>\n<td >the row that shows interval man hour for each month<\/td>\n<td >=sheet5!$c$3:$x$3<\/td>\n<\/tr>\n\r\n<tr><td ><p style=\"text-align: left;\">cumulative progress<\/td>\n<td >the row that shows cum. % prog<\/td>\n<td >=sheet5!$c$4:$x$4<\/td>\n<\/tr>\n<\/tbody><\/table><\/div><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6.3 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0091.png\" alt=\"step 6.3 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"457\" \/><\/p>\n<p>\u00a0the last source definition is for the dates which result in our x axis. to do that on the \u201cselect source data\u201d box and under the \u201chorizontal axis label\u201d, hit the edit button and you will see a similar dialogue box as the above dialogue boxes:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6.4 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0101.png\" alt=\"step 6.4 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"457\" \/><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6.5 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0111.png\" alt=\"step 6.5 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"457\" \/><\/p>\n<p>select all the dates as the label range for the horizontal axis and hit \u201cok\u201d on dialogue box and then on the \u201cselect data source\u201d box. now you have the following chart<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 6.6 - defining the s-curve's 世界杯时间比赛时间
\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0121.png\" alt=\"step 6.6 - defining the s-curve's 世界杯时间比赛时间
\" width=\"610\" height=\"342\" \/><\/p>\n<p>now we should modify this s-curve, so we go step by step:<\/p>\n<h2>step 7 &#8211; select a primary and secondary s-curve<\/h2>\n<p>right-click on the curves and select \u201cformat data series\u201d. in the\u201d format data series\u201d box select the \u201ccum progress\u201d as the secondary curve (it means that this s-curve values are shown on the right hand axis)<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 7 - select a primary and secondary s-curve\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0131.png\" alt=\"step 7 - select a primary and secondary s-curve\" width=\"610\" height=\"342\" \/><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 7.1 - select a primary and secondary s-curve\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image0141.png\" alt=\"step 7.1 - select a primary and secondary s-curve\" width=\"610\" height=\"342\" \/><\/p>\n<h2>step 8 &#8211; change the data type to a \u201c2-d column\u201d chart<\/h2>\n<p>right-click on the monthly interval man hour curve (ie:the blue curve) and then select the \u201cchange series chart type\u201d. in the \u201cchange series chart type\u201d box, select \u201c2-d column\u201d chart.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 8 - change the data type to a \u201c2-d column\u201d chart\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image015.png\" alt=\"step 8 - change the data type to a \u201c2-d column\u201d chart\" width=\"610\" height=\"342\" \/><\/p>\n<h2>step 9 &#8211; adjust the right-hand vertical axis<\/h2>\n<p>right-click on the right-hand vertical axis and select \u201cformat axis\u201d in the dialogue box go to axis options and change the second value from the top of form to<strong> 1.00<\/strong>.<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 9 - adjust the right-hand vertical axis\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image018.png\" alt=\"step 9 - adjust the right-hand vertical axis\" width=\"610\" height=\"342\" \/><\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 9.1 - adjust the right-hand vertical axis\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image017.png\" alt=\"step 9.1 - adjust the right-hand vertical axis\" width=\"610\" height=\"342\" \/><\/p>\n<p>now you have a resource s-curve which still needs some modification:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 9.2 - adjust the right-hand vertical axis\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image019.png\" alt=\"step 9.2 - adjust the right-hand vertical axis\" width=\"610\" height=\"342\" \/><\/p>\n<h2>step 10 &#8211; the final touches<\/h2>\n<p>in excel 2007, when you select a chart, a \u201cchart tool\u201d tab will appear on the top right hand side of toolbar. in that chart you can change the color of curves, add title to curve, add table to curve. the following curve which is the final curve is the result of doing some exercises with those features:<\/p>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" class=\"tutorial_image aligncenter\" title=\"step 10 - the final touches\" src=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/image020.png\" alt=\"step 10 - the final touches\" width=\"610\" height=\"342\" \/><\/p>\n<h2>wrap up<\/h2>\n<p>with this new <a title=\"what in the world is an s-curve? [in under 100 words]\" href=\"\/\/www.deco-dalles.com\/s-curve-definition-under-100-words\/\">p6 resource s-curve<\/a>, now your project manager can easily tell you there is something wrong with resource assignment and some leveling should be done on 世界杯时间比赛时间
 to achieve a better distributed resource s-curve.<\/p>\n<p>there are different ways of developing s-curves in excel but this method works well in many project circumstances.<br \/>\n<!--hubspot call-to-action code --><br \/>\n<span id=\"hs-cta-wrapper-3aeba69a-3395-4c7d-bcf9-21c89d3da072\" class=\"hs-cta-wrapper\"><br \/>\n<span id=\"hs-cta-3aeba69a-3395-4c7d-bcf9-21c89d3da072\" class=\"hs-cta-node hs-cta-3aeba69a-3395-4c7d-bcf9-21c89d3da072\"><br \/>\n<!-- [if lte ie 8]>\n\n\n<div id=\"hs-cta-ie-element\"><\/div>\n\n\n<![endif]--><br \/>\n<a href=\"http:\/\/cta-redirect.hubspot.com\/cta\/redirect\/297539\/3aeba69a-3395-4c7d-bcf9-21c89d3da072\"><img decoding=\"async\" id=\"hs-cta-img-3aeba69a-3395-4c7d-bcf9-21c89d3da072\" class=\"hs-cta-img\" style=\"border-width: 0px;\" src=\"https:\/\/no-cache.hubspot.com\/cta\/default\/297539\/3aeba69a-3395-4c7d-bcf9-21c89d3da072.png\" alt=\"\" \/><\/a><br \/>\n<\/span><br \/>\n<script src=\"https:\/\/js.hscta.net\/cta\/current.js\" charset=\"utf-8\"><\/script><br \/>\n<script>\/\/ <![cdata[ hbspt.cta.load(297539, '3aeba69a-3395-4c7d-bcf9-21c89d3da072'); \/\/ ]]><\/script><br \/>\n<\/span><br \/>\n<!-- end hubspot call-to-action code --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>in my previous tutorial in this series, i described the procedure to export resource assignment data from p6 to excel.\u00a0most&#8230;<\/p>\n","protected":false},"author":47,"featured_media":8111,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[26,55,215],"tags":[],"content-topics":[],"class_list":["post-7919","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-primavera-p6-tutorials","category-resource-management"],"acf":[],"yoast_head":"<!-- this site is optimized with the yoast seo premium plugin v23.1 (yoast seo v23.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>graphing a p6 resource s-curve in excel<\/title>\n<meta name=\"description\" content=\"this primavera p6 tutorial will show how to use excel to graph a resource s-curve with data exported from a p6 project. this part 2 in a series on how to export and graph p6 data.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_us\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"graphing a p6 resource s-curve in excel\" \/>\n<meta property=\"og:description\" content=\"this primavera p6 tutorial will show how to use excel to graph a resource s-curve with data exported from a p6 project. this part 2 in a series on how to export and graph p6 data.\" \/>\n<meta property=\"og:url\" content=\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"世界杯2022亚洲比赛时间
\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/planacademy\" \/>\n<meta property=\"article:published_time\" content=\"2013-05-24t19:36:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-09t17:53:54+00:00\" \/>\n<meta property=\"og:image\" content=\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png\" \/>\n\t<meta property=\"og:image:width\" content=\"200\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"kazem salehiyan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@planacademy\" \/>\n<meta name=\"twitter:site\" content=\"@planacademy\" \/>\n<meta name=\"twitter:label1\" content=\"written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kazem salehiyan\" \/>\n\t<meta name=\"twitter:label2\" content=\"est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"article\",\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#article\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\"},\"author\":{\"name\":\"kazem salehiyan\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a\"},\"headline\":\"graphing a p6 resource s-curve in excel\",\"datepublished\":\"2013-05-24t19:36:35+00:00\",\"datemodified\":\"2019-10-09t17:53:54+00:00\",\"mainentityofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\"},\"wordcount\":775,\"commentcount\":6,\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png\",\"articlesection\":[\"excel\",\"primavera p6 tutorials\",\"resource management\"],\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"commentaction\",\"name\":\"comment\",\"target\":[\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#respond\"]}]},{\"@type\":\"webpage\",\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\",\"url\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\",\"name\":\"graphing a p6 resource s-curve in excel\",\"ispartof\":{\"@id\":\"\/\/www.deco-dalles.com\/#website\"},\"primaryimageofpage\":{\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage\"},\"thumbnailurl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png\",\"datepublished\":\"2013-05-24t19:36:35+00:00\",\"datemodified\":\"2019-10-09t17:53:54+00:00\",\"description\":\"this primavera p6 tutorial will show how to use excel to graph a resource s-curve with data exported from a p6 project. this part 2 in a series on how to export and graph p6 data.\",\"breadcrumb\":{\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#breadcrumb\"},\"inlanguage\":\"en-ca\",\"potentialaction\":[{\"@type\":\"readaction\",\"target\":[\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/\"]}]},{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png\",\"width\":200,\"height\":200,\"caption\":\"graphing a p6 resource s-curve in excel\"},{\"@type\":\"breadcrumblist\",\"@id\":\"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#breadcrumb\",\"itemlistelement\":[{\"@type\":\"listitem\",\"position\":1,\"name\":\"blog\",\"item\":\"\/\/www.deco-dalles.com\/\"},{\"@type\":\"listitem\",\"position\":2,\"name\":\"graphing a p6 resource s-curve in excel\"}]},{\"@type\":\"website\",\"@id\":\"\/\/www.deco-dalles.com\/#website\",\"url\":\"\/\/www.deco-dalles.com\/\",\"name\":\"世界杯2022亚洲比赛时间
\",\"description\":\"project controls training &amp; courses\",\"publisher\":{\"@id\":\"\/\/www.deco-dalles.com\/#organization\"},\"potentialaction\":[{\"@type\":\"searchaction\",\"target\":{\"@type\":\"entrypoint\",\"urltemplate\":\"\/\/www.deco-dalles.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inlanguage\":\"en-ca\"},{\"@type\":\"organization\",\"@id\":\"\/\/www.deco-dalles.com\/#organization\",\"name\":\"世界杯2022亚洲比赛时间
\",\"url\":\"\/\/www.deco-dalles.com\/\",\"logo\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\",\"url\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"contenturl\":\"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png\",\"width\":500,\"height\":159,\"caption\":\"世界杯2022亚洲比赛时间
\"},\"image\":{\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/\"},\"sameas\":[\"https:\/\/www.facebook.com\/planacademy\",\"https:\/\/x.com\/planacademy\",\"https:\/\/www.linkedin.com\/company\/plan-academy\",\"https:\/\/www.youtube.com\/planacademy\"]},{\"@type\":\"person\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a\",\"name\":\"kazem salehiyan\",\"image\":{\"@type\":\"imageobject\",\"inlanguage\":\"en-ca\",\"@id\":\"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg\",\"contenturl\":\"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg\",\"caption\":\"kazem salehiyan\"},\"description\":\"i started working as a scheduler 4 years ago. i have been working for different companies in different industries since then. i am writing tutorials because i believe knowledge and experience should be shared.i do like watching historical documentaries and reading novels.\",\"sameas\":[\"http:\/\/www.linkedin.com\/pub\/kazem-salehian\/45\/967\/8a5\"],\"url\":\"\/\/www.deco-dalles.com\/author\/ksalehiyan\/\"}]}<\/script>\n<!-- \/ yoast seo premium plugin. -->","yoast_head_json":{"title":"graphing a p6 resource s-curve in excel","description":"this primavera p6 tutorial will show how to use excel to graph a resource s-curve with data exported from a p6 project. this part 2 in a series on how to export and graph p6 data.","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":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/","og_locale":"en_us","og_type":"article","og_title":"graphing a p6 resource s-curve in excel","og_description":"this primavera p6 tutorial will show how to use excel to graph a resource s-curve with data exported from a p6 project. this part 2 in a series on how to export and graph p6 data.","og_url":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/","og_site_name":"世界杯2022亚洲比赛时间
","article_publisher":"https:\/\/www.facebook.com\/planacademy","article_published_time":"2013-05-24t19:36:35+00:00","article_modified_time":"2019-10-09t17:53:54+00:00","og_image":[{"width":200,"height":200,"url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png","type":"image\/png"}],"author":"kazem salehiyan","twitter_card":"summary_large_image","twitter_creator":"@planacademy","twitter_site":"@planacademy","twitter_misc":{"written by":"kazem salehiyan","est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"article","@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#article","ispartof":{"@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/"},"author":{"name":"kazem salehiyan","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a"},"headline":"graphing a p6 resource s-curve in excel","datepublished":"2013-05-24t19:36:35+00:00","datemodified":"2019-10-09t17:53:54+00:00","mainentityofpage":{"@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/"},"wordcount":775,"commentcount":6,"publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"image":{"@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png","articlesection":["excel","primavera p6 tutorials","resource management"],"inlanguage":"en-ca","potentialaction":[{"@type":"commentaction","name":"comment","target":["\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#respond"]}]},{"@type":"webpage","@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/","url":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/","name":"graphing a p6 resource s-curve in excel","ispartof":{"@id":"\/\/www.deco-dalles.com\/#website"},"primaryimageofpage":{"@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage"},"image":{"@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage"},"thumbnailurl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png","datepublished":"2013-05-24t19:36:35+00:00","datemodified":"2019-10-09t17:53:54+00:00","description":"this primavera p6 tutorial will show how to use excel to graph a resource s-curve with data exported from a p6 project. this part 2 in a series on how to export and graph p6 data.","breadcrumb":{"@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#breadcrumb"},"inlanguage":"en-ca","potentialaction":[{"@type":"readaction","target":["\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/"]}]},{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#primaryimage","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2013\/05\/featimageexcelresource11.png","width":200,"height":200,"caption":"graphing a p6 resource s-curve in excel"},{"@type":"breadcrumblist","@id":"\/\/www.deco-dalles.com\/p6-resource-s-curve-excel\/#breadcrumb","itemlistelement":[{"@type":"listitem","position":1,"name":"blog","item":"\/\/www.deco-dalles.com\/"},{"@type":"listitem","position":2,"name":"graphing a p6 resource s-curve in excel"}]},{"@type":"website","@id":"\/\/www.deco-dalles.com\/#website","url":"\/\/www.deco-dalles.com\/","name":"世界杯2022亚洲比赛时间
","description":"project controls training &amp; courses","publisher":{"@id":"\/\/www.deco-dalles.com\/#organization"},"potentialaction":[{"@type":"searchaction","target":{"@type":"entrypoint","urltemplate":"\/\/www.deco-dalles.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inlanguage":"en-ca"},{"@type":"organization","@id":"\/\/www.deco-dalles.com\/#organization","name":"世界杯2022亚洲比赛时间
","url":"\/\/www.deco-dalles.com\/","logo":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/","url":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","contenturl":"\/\/www.deco-dalles.com\/wp-content\/uploads\/2023\/11\/cropped-pa-logo-color.png","width":500,"height":159,"caption":"世界杯2022亚洲比赛时间
"},"image":{"@id":"\/\/www.deco-dalles.com\/#\/schema\/logo\/image\/"},"sameas":["https:\/\/www.facebook.com\/planacademy","https:\/\/x.com\/planacademy","https:\/\/www.linkedin.com\/company\/plan-academy","https:\/\/www.youtube.com\/planacademy"]},{"@type":"person","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/919f7169bc407959b37d46ef2d8fab2a","name":"kazem salehiyan","image":{"@type":"imageobject","inlanguage":"en-ca","@id":"\/\/www.deco-dalles.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg","contenturl":"https:\/\/secure.gravatar.com\/avatar\/1b749cc5038a918ef4f115106f1dec40?s=96&d=mm&r=pg","caption":"kazem salehiyan"},"description":"i started working as a scheduler 4 years ago. i have been working for different companies in different industries since then. i am writing tutorials because i believe knowledge and experience should be shared.i do like watching historical documentaries and reading novels.","sameas":["http:\/\/www.linkedin.com\/pub\/kazem-salehian\/45\/967\/8a5"],"url":"\/\/www.deco-dalles.com\/author\/ksalehiyan\/"}]}},"_links":{"self":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7919"}],"collection":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/users\/47"}],"replies":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/comments?post=7919"}],"version-history":[{"count":0,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/posts\/7919\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media\/8111"}],"wp:attachment":[{"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/media?parent=7919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/categories?post=7919"},{"taxonomy":"post_tag","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/tags?post=7919"},{"taxonomy":"content-topics","embeddable":true,"href":"\/\/www.deco-dalles.com\/wp-json\/wp\/v2\/content-topics?post=7919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}