{"id":1608,"date":"2020-01-30T22:08:22","date_gmt":"2020-01-31T03:08:22","guid":{"rendered":"https:\/\/www.foxquestsystems.net\/foxblog\/?p=1608"},"modified":"2020-02-19T17:01:06","modified_gmt":"2020-02-19T22:01:06","slug":"finish-comparison-profile","status":"publish","type":"post","link":"https:\/\/www.foxquestsystems.net\/foxblog\/2020\/01\/30\/finish-comparison-profile\/","title":{"rendered":"Finish Comparison Profile"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">A &#8220;Cash-flow S-Curve&#8221; is a very valuable tool that reveals much information about  the characteristics of the scheduled Project. However,  you may often come upon schedule updates that are not Cost or Expense loaded. You can still produce an \u201cS-Type Curve\u201d comparison by accumulating the Actual, Early, Late (and Mid) Finish Dates of the Tasks and  Resource Dependent activities for both project updates.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Although this method may be a rough simulation of an actual Cost Load distribution, the resulting curves, in most cases can surprisingly provide a reasonable model of the Cash-flow as if the schedules were cost loaded. In the resulting curves, instead of defining the Y-Axis as Cumulative Cost, the Y-Axis is defined as the Cumulative Finish Date count.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Astute Z\u00fcmmer user, Stephen Paterson, notes that these curves can be useful on types of projects where the client does not want it&#8217;s costs published out to all and sundry.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Z\u00fcmmer\u2019s Finish Comparison Profile Report (See illustration below) completes this task by:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"840\" height=\"658\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T489-Finish-Comparison-Profile-Basics-View.jpg?resize=840%2C658&#038;ssl=1\" alt=\"\" class=\"wp-image-1613\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T489-Finish-Comparison-Profile-Basics-View.jpg?w=950&amp;ssl=1 950w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T489-Finish-Comparison-Profile-Basics-View.jpg?resize=300%2C235&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T489-Finish-Comparison-Profile-Basics-View.jpg?resize=768%2C601&amp;ssl=1 768w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1) Generating and Early, Late, Mid and Actual Finish Curves comparing between 2 Projects.<\/strong><br><br> a. The Early Finish Curves distributes the Remaining Early Finish date of each Task or Resource Dependent activity between the Data Dates and the latest Finish dates in the 2 selected Projects. <br> b. The Late Curves distributes the Remaining Late Finish dates of each Task or Resource Dependent activity between the Data Dates and the latest Finish dates in the 2 selected Projects. <br> c. The Mid Finish Curves calculates the midpoint daily value between the distributed Early and Late Finish Dates.<br> d. The Actual Finish Curves distributes the Actual Finish date of each Task or Resource Dependent between the Start of the Projects up to the Data Dates respectively.<br> <br><strong> 2) Storing the graph and distribution data into a spreadsheet.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> a. In addition to generating the Finish Comparison Profile report, Z\u00fcmmer also generates an editable spreadsheet containing the actual chart appearing in the report along with the supporting daily and cumulative Early, Late, Mid and Actual Finish distribution calculations for the 2 selected Projects.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong> Finish Comparison Profile \u2013 Spreadsheet Output<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When the Finish Comparison\nProfile Curve is selected for previewing or printing, in addition to the\nprinted\/previewable report, Z\u00fcmmer generates a spreadsheet supplemental file\nfor the curve produced in the report.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The spreadsheet output file is stored in the Zummer\/Output folder. In the illustration below, the Project TST-BL1-UP02 and TST-BL1-UP14 was selected for printing with the file listed. Note the file structure prefix consists of \u201cFCP\u201d then the next filename segment consists of the Project ID, \u201cTST-BL1-UP14\u201d (the selected Modified Project\u2019s ID). The final filename segment is a 5-digit computer system generate suffix.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"478\" height=\"114\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T490-Finish-Comparison-Profile-Output-Folder.jpg?resize=478%2C114&#038;ssl=1\" alt=\"\" class=\"wp-image-1612\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T490-Finish-Comparison-Profile-Output-Folder.jpg?w=478&amp;ssl=1 478w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T490-Finish-Comparison-Profile-Output-Folder.jpg?resize=300%2C72&amp;ssl=1 300w\" sizes=\"auto, (max-width: 478px) 85vw, 478px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The \u201cFCP\u201d file in the \u201cChart1\u201d Tab contains the \u201cFinish Comparison Profile\u201d Curves shown as below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"840\" height=\"628\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T491-Finish-Comparison-Profile-Chart-1-View.jpg?resize=840%2C628&#038;ssl=1\" alt=\"\" class=\"wp-image-1611\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T491-Finish-Comparison-Profile-Chart-1-View.jpg?w=933&amp;ssl=1 933w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T491-Finish-Comparison-Profile-Chart-1-View.jpg?resize=300%2C224&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T491-Finish-Comparison-Profile-Chart-1-View.jpg?resize=768%2C574&amp;ssl=1 768w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Since the file above is generated by a spreadsheet, the visual content\ncan be customized by the user and\/or Cut\/Copy &amp; Pasted into another\ndocument.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the \u201cFCP\u201d file above, below is a partial section of the ChartData tab and the raw data used to plot the curve shown above: (Some Rows are hidden for instructional purposes).<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" width=\"840\" height=\"265\" loading=\"lazy\" src=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T492-Finish-Comparison-Profile-ChartData-View.jpg?resize=840%2C265&#038;ssl=1\" alt=\"\" class=\"wp-image-1610\" srcset=\"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T492-Finish-Comparison-Profile-ChartData-View.jpg?resize=1024%2C323&amp;ssl=1 1024w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T492-Finish-Comparison-Profile-ChartData-View.jpg?resize=300%2C95&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T492-Finish-Comparison-Profile-ChartData-View.jpg?resize=768%2C242&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T492-Finish-Comparison-Profile-ChartData-View.jpg?resize=1200%2C379&amp;ssl=1 1200w, https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/T492-Finish-Comparison-Profile-ChartData-View.jpg?w=1442&amp;ssl=1 1442w\" sizes=\"auto, (max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Column A \u2013 \u201cProfile\nDate\u201d contains the series of dates from the earliest date in the selected 2\nProjects listing daily down to the latest date in the selected 2 Projects.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Columns B, C and D\ncontain the cumulative Early, Late and Mid Finish Date Count Series respectively\nfor the Control Project\u2019s Finish Profile curve on the graph displayed in the\nChart1 tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Column E contains\nthe cumulative Actual Finish Date Series for the Control Project\u2019s Finish\nProfile curve on the graph displayed in the Chart1 tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Column F contains\nthe Total number of Tasks and Resource Dependent activities used to generate\nthe vertical Data Date line in the graph for the Control Project. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Columns G, H and I\ncontain the cumulative Early, Late and Mid Finish Date Count Series\nrespectively for the Modified Project\u2019s Finish Profile curve on the graph\ndisplayed in the Chart1 tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Column J contains\nthe cumulative Actual Finish Date Series for the Modified Project\u2019s Finish\nProfile curve on the graph displayed in the Chart1 tab.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Column K contains the Total number of Tasks and Resource Dependent activities used to generate the vertical Data Date line in the graph for the Modified Project.  <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Columns L, M, N and\nO contain the daily Control Project\u2019s total Early, Late, Mid and Actual Count\nSeries respectively used to calculate the cumulative values shown in Columns B,\nC, D and E respectively.<strong> <\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Columns P, Q, R and S contain the daily Modified Project\u2019s total Early, Late, Mid and Actual Count Series respectively used to calculate the cumulative values shown in Columns F, G, H and I respectively. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Copyright \u00a92020 FoxQuest Systems, Inc. &#8211; All Rights Reserved.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to Compare the Finish Profile between a baseline and update schedule.<\/p>\n","protected":false},"author":2,"featured_media":1609,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[3],"tags":[],"class_list":["post-1608","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-comparison"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/Feature-Screen-Finish-Analysis-Profile.jpg?fit=823%2C454&ssl=1","_links":{"self":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/comments?post=1608"}],"version-history":[{"count":7,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1608\/revisions"}],"predecessor-version":[{"id":1716,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1608\/revisions\/1716"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media\/1609"}],"wp:attachment":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media?parent=1608"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/categories?post=1608"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/tags?post=1608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}