You might use this for a task that needs to start 5 days prior to the completion of some other task. The Start date is calculated to be the number of work days PRIOR to the End date you entered. What is happening when I enter End Date and Work Days as the inputs? If you enter a Start Date and an End Date AND the number of Work Days, then you won't know which of the 3 values were used to calculate the Start and End dates used in the chart. What happens if I enter more than two values to define task durations?Īvoid doing that. See the Gantt Chart Pro page for the most recent videos. Some older videos are still lingering on Youtube and elsewhere, and for the most part these older videos are still mostly applicable to the new version. Why are some videos still showing the older versions? However, the older versions will not be updated or supported. I don't think so, unless you are using an old version of Excel, or you prefer the older designs.
Is there any reason to use the older version(s)? For example, you might define a task by entering a Predecessor and a duration in Days, which means the inputs for Start date and End date are left blank. When printing or presenting, it is better to hide the input columns instead of the calculated columns, because the calculated columns show ALL dates and durations while the inputs may or may not be used. So, the calculated columns use formulas to calculate the dates based on which combination of inputs you choose, and the Gantt chart references these calculated columns. However, the Gantt chart needs to reference a single column for all Start Dates and a single column for all End Dates. The input columns allow you to quickly decide whether to enter dates and/or durations. Why are there two sets of Start/End dates? If you still can't find the answer to your question, you can contact me. If you have questions about Gantt Chart Pro, please first watch the videos available on the web page, then check the Help worksheet, and then check the FAQ post. Planned - but the spreadsheet also includes a way to make this work in Excel Online (see the help and labels and notes within the spreadsheet). The spreadsheet uses some features of Excel that are not available in Excel Online such as cross-hatching for displaying Actual vs. Many of the design aspects of Version 5.0 have to do with making the spreadsheet compatible with Excel Online and Excel Mobile without having to use different versions of the file for different versions of Excel. Compatibility with Desktop, Mobile and Excel Online Tip: In addition to hiding columns to condense the input section of the worksheet, you can use the Arial Narrow font and then make the columns narrower. However, after you are done defining your tasks, you could hide some or all of the columns you don't need to see. The downside to this new way of defining tasks is that there are quite a few input columns as well as the calculated columns. These calculated Start and End dates are what the spreadsheet uses to display the chart. The worksheet has separate columns for the calculated start & end dates. For example, this could be the Start date and End date, or the Start date and number of Work Days. Now, all you need to do is enter a combination of two inputs. You can arrive at those dates in a lot of different ways, depending on whether you want to enter dates manually, enter a duration instead of a date, or whether you want to create dependencies between tasks using Excel formulas. Ultimately, a task needs to have a start date and an end date. "This browser does not support the HTML5 video element" Instead of copying formulas from a set of template rows or cells to define tasks in different ways, you just enter your data in the appropriate input columns. The biggest change in version 4.0 had to do with how you define each task's start and end date. Multiple Ways to Define Task Dates and Durations Also, the indenting of the task description is controlled using Conditional Formatting and custom Number formats such as to format the text with leading spaces.
#WBS CHART PRO MEGA FREE#
Unlike the free version (and older pro versions), you will not need to copy and paste different WBS formulas for different WBS levels.įor fellow Excel fans: If you are curious about how the mega-formula for the WBS numbering works, you can learn some of the techniques via an article I wrote about various text manipulation formulas.
0 kommentar(er)
