{"id":1597,"date":"2020-01-25T16:43:37","date_gmt":"2020-01-25T21:43:37","guid":{"rendered":"https:\/\/www.foxquestsystems.net\/foxblog\/?p=1597"},"modified":"2020-02-19T17:00:09","modified_gmt":"2020-02-19T22:00:09","slug":"finish-analysis-profile","status":"publish","type":"post","link":"https:\/\/www.foxquestsystems.net\/foxblog\/2020\/01\/25\/finish-analysis-profile\/","title":{"rendered":"Finish Analysis Profile"},"content":{"rendered":"\n

A “Cash-flow S-Curve” is a very valuable tool that reveals much information about the characteristics of the scheduled Project. However, you may often come upon a schedule that is not Cost or Expense loaded. You can still produce an \u201cS-Type Curve\u201d by accumulating the Actual, Early, Late (and Mid) Finish Dates of the Tasks and Resource Dependent activities. <\/p>\n\n\n\n

Although this method may be a rough simulation of an actual Cost Load distribution, the resulting curve, in most cases can surprisingly provide a reasonable model of the Cash-flow as if the schedule was cost loaded. In the resulting curve, 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

Astute Z\u00fcmmer user, Stephen Paterson, notes that these curves can be useful on types of projects where the client does not want it’s costs published out to all and sundry.<\/strong><\/p>\n\n\n\n

Z\u00fcmmer\u2019s Finish Analysis Profile Report (Illustrated below), completes this tasks by:<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n
  1. Generating and Actual, Early, Late, and Mid Cumulative Finish Curves.<\/strong>

    a. The Actual Finish Curve distributes the Actual Finish date of each completed Task or Resource Dependent between the Start of the Project up to the Data Date.

    b. The Early Finish Curve distributes the Remaining Early<\/strong> Finish date of each Task or Resource Dependent activity between the Data Date and the latest Finish date in the Project.

    c. The Late Curve distributes the Remaining Late<\/strong> Finish date of each Task or Resource Dependent activity between the Data Date and the latest Finish date in the Project.

    d. The Mid Finish Curve calculates the midpoint<\/strong> daily value between the distributed Early and Late Finish Dates.

    e. The height of the Vertical Data Date line is defined by the Total Count of Tasks & Resource Dependent activities in the Project.

    f. The X Axis displays the Profile Date in which the range is bounded from the Earliest Project Start Date to the Latest Project Finish Date.

    g. The Y Axis displays to Cumulative Finish Count which is bounded from 0 to the Total Count of Tasks and Resource Dependent activities. This means that Level of Effort, WBS Summary, and Milestone activities are not included in the graph.

    h. The Total Task + Resource Dependent count is also displayed in the bottom of the report.
    <\/li><\/ol>\n\n\n\n

    2. Storing the graph and distribution data into a spreadsheet.<\/strong>

    a. In addition to generating a Finish Analysis Profile report, Z\u00fcmmer also generates an editable spreadsheet containing the actual chart appearing in the report along with the supporting daily and cumulative Actual, Early, Late, and Mid Finish distribution calculations.<\/p>\n\n\n\n

    When the Finish Analysis Profile Curve is selected for previewing or printing, in addition to the printed\/preview-able report, Z\u00fcmmer generates a spreadsheet supplemental file for the curve produced in the report.<\/p>\n\n\n\n

    The spreadsheet output file is stored in the Zummer\/Output folder. In the illustration below, the Project TST-BL1-UP02 was selected for printing with the file listed. Note the file structure prefix consists of \u201cFAP\u201d then the next filename segment consists of the Project ID, \u201cTST-BL1-UP02\u201d. The final filename segment, [97LLK], is a random computer system generated 5-digit suffix.<\/p>\n\n\n\n

    \"\"<\/figure><\/div>\n\n\n\n

    The \u201cFAP\u201d file in the \u201cChart1\u201d Tab\ncontains the \u201cFinish Analysis Profile\u201d Curves shown as below:<\/p>\n\n\n\n

    \"\"<\/figure><\/div>\n\n\n\n

    Since the file above is a generated spreadsheet, the visual content can be customized by the user and\/or Cut\/Copy & Pasted into another document.
    <\/strong><\/p>\n\n\n\n

    In the \u201cFAP\u201d file chart view above, shown below is a partial section of the ChartData tab and the raw data used to plot the curve shown above: (Note: Rows 3 thru 61 and 66 thru 404 are hidden for instructional purposes).<\/strong><\/p>\n\n\n\n

    \"\"<\/figure><\/div>\n\n\n\n

    Column A \u2013 \u201cProfile\nDate\u201d contains the series of dates from the earliest date in the selected\nProject listing daily down to the latest date in the selected Project.<\/p>\n\n\n\n

    Columns B, C and D\ncontain the cumulative Early, Late and Mid Finish Date Count Series\nrespectively for the Finish Analysis Profile curve on the graph displayed in\nthe Chart1 tab.<\/p>\n\n\n\n

    Column E contains\nthe cumulative Actual Finish Date Series for the Finish Analysis Profile curve\non the graph displayed in the Chart1 tab.<\/p>\n\n\n\n

    Column F contains\nthe Total number of Tasks and Resource Dependent activities used to generate\nthe vertical Data Date line in the graph. <\/p>\n\n\n\n

    Columns G, H, I and J contain the daily total Early, Late, Mid and Actual Count Series respectively used to calculate the cumulative values shown in Columns B, C, D and E respectively. <\/strong><\/p>\n\n\n\n

    Copyright \u00a92020 – FoxQuest Systems, Inc. – All Rights Reserved.<\/p>\n","protected":false},"excerpt":{"rendered":"

    How to produce an “S-Curve” type graph when a schedule is not cost loaded.<\/p>\n","protected":false},"author":2,"featured_media":1601,"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":[2],"tags":[],"class_list":["post-1597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-analysis"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.foxquestsystems.net\/foxblog\/wp-content\/uploads\/2020\/01\/Finish-Analysis-Profile-Feature-Image.jpg?fit=822%2C450&ssl=1","_links":{"self":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1597","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=1597"}],"version-history":[{"count":6,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1597\/revisions"}],"predecessor-version":[{"id":1715,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/posts\/1597\/revisions\/1715"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media\/1601"}],"wp:attachment":[{"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/media?parent=1597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/categories?post=1597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.foxquestsystems.net\/foxblog\/wp-json\/wp\/v2\/tags?post=1597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}