Week 3 ass 2

Ace your studies with our custom writing services! We've got your back for top grades and timely submissions, so you can say goodbye to the stress. Trust us to get you there!


Order a Similar Paper Order a Different Paper

 

Utilizing the Project Timeline Download Project Timelineand Gantt Chart Download Gantt Charttemplates, construct a Gantt chart and timeline for your Final Project. For the Gantt chart, there must be a minimum of nine tasks including Project Charter approval, site selection, lease/purchase completion, construction specifications, capital equipment and furniture specifications, construction, installation of equipment, final project closing, and two other tasks of your choice.

Example1

Example Project Timeline/Schedule
Using Excel’s Drawing Tools
Timeline Template by Vertex42.com © 2004-2011 Vertex42 LLC
Note: This timeline is an example of using the drawing tools and text boxes. It is not meant to be a automated template.
Company Name
Project Title
Project Schedule
May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May
2011 2012
To copy and paste into another program (like Word, PowerPoint, etc.)
1) Select the range of interest
2) Hold down shift AS you click on the edit menu
3) Select Copy Picture …
Limited Use Policy
You may make archival copies and customize this template (the “Software”) only for your personal use or use within your company or organization and not for resale or public sharing.

You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use, attribution, or other proprietary notices or marks within this template.

This template and any customized or modified version of this template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server.

Limited Private Sharing
Provided that you abide by the above terms, it may be permissible to share an edited version of this template privately with another individual or organization who requires access to it. See the following web page for examples of how this template, printed copies, or screenshots may be shared:
http://www.vertex42.com/licensing/EULA_privateuse.html

No Warranties
THE SOFTWARE AND ANY RELATED DOCUMENTATION ARE PROVIDED TO YOU “AS IS.” VERTEX42, LLC MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AND EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, ORAL OR WRITTEN, TERMS, CONDITIONS, AND WARRANTIES, INCLUDING BUT NOT LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT. WITHOUT LIMITING THE ABOVE YOU ACCEPT THAT THE SOFTWARE MAY NOT MEET YOUR REQUIREMENTS, OPERATE ERROR FREE, OR IDENTIFY ANY OR ALL ERRORS OR PROBLEMS, OR DO SO ACCURATELY. This Agreement does not affect any statutory rights you may have as a consumer.

Limitation of Liability
IN NO EVENT SHALL VERTEX42, LLC BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS, LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE (EVEN IF WE OR AN AUTHORIZED DEALER OR DISTRIBUTOR HAS BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), OR ANY MISTAKES AND NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY. THE ORGANIZATION, BUSINESS, OR PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE.

Some states do not allow the limitation or exclusion of liability for incidental or consequential damages, so the above limitation may not apply to you.

Project Start
First Symposium
Perform Research
Input From Industry
Sept. 22, 2011
Second Symposium
Feb. 15, 2012
Draft Reports
Apr. 30, 2012
Final Reports
March 2012
Advisory Panel Meetings
Dec. 2-3, 2011
Advisory Panel Meetings
Feb. 3-5, 2012 (tentative)
June 1, 2011

Example2

Example Project Timeline/Schedule
Using Drawing Tools and Formatting
Timeline Template by Vertex42.com © 2004-2011 Vertex42 LLC
Tips: Extend the timeline by copying the last cell.
Set the print area to scale the timeline to fit a page.
Hold down Alt as you create, move, or stretch drawing objects to snap to the cell grid.
To include a carriage return, or newline, in textboxes, press Alt+Enter.
Note: This is intended only as a project timeline example, not as an automated template.
Project Title Start Date
Project Schedule 4-Oct-11
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb
2011 0 0 2012 0 0 0 0 0 0 0 0 0 0 0 2012 0
To copy and paste into another program (like Word, PowerPoint, etc.)
1) Select the range of interest
2) Hold down shift AS you click on the edit menu
3) Select Copy Picture …
Limited Use Policy
You may make archival copies and customize this template (the “Software”) only for your personal use or use within your company or organization and not for resale or public sharing.

You may not remove or alter any logo, trademark, copyright, disclaimer, brand, terms of use, attribution, or other proprietary notices or marks within this template.

This template and any customized or modified version of this template may NOT be sold, distributed, published to an online gallery, hosted on a website, or placed on a public server.

Limited Private Sharing
Provided that you abide by the above terms, it may be permissible to share an edited version of this template privately with another individual or organization who requires access to it. See the following web page for examples of how this template, printed copies, or screenshots may be shared:
http://www.vertex42.com/licensing/EULA_privateuse.html

No Warranties
THE SOFTWARE AND ANY RELATED DOCUMENTATION ARE PROVIDED TO YOU “AS IS.” VERTEX42, LLC MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AND EXPRESSLY DISCLAIMS ALL REPRESENTATIONS, ORAL OR WRITTEN, TERMS, CONDITIONS, AND WARRANTIES, INCLUDING BUT NOT LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NONINFRINGEMENT. WITHOUT LIMITING THE ABOVE YOU ACCEPT THAT THE SOFTWARE MAY NOT MEET YOUR REQUIREMENTS, OPERATE ERROR FREE, OR IDENTIFY ANY OR ALL ERRORS OR PROBLEMS, OR DO SO ACCURATELY. This Agreement does not affect any statutory rights you may have as a consumer.

Limitation of Liability
IN NO EVENT SHALL VERTEX42, LLC BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS, LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE (EVEN IF WE OR AN AUTHORIZED DEALER OR DISTRIBUTOR HAS BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), OR ANY MISTAKES AND NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY. THE ORGANIZATION, BUSINESS, OR PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE.

Some states do not allow the limitation or exclusion of liability for incidental or consequential damages, so the above limitation may not apply to you.

Project Start
Deliverable
Due. Jan 1
Task 1
Event 2
Project Round 2
Task 2
Event 1
Final Task
Final Report(s)
Final Deliverable
Due. June 25

GanttChart

[Project Name] Project Schedule Gantt Chart Template © 2015 by Vertex42.com.
[Company Name]
Project Lead: [ John Doe ]
Project Start Date: 42086.0 3 / 23 / 15 3 / 24 / 15 3 / 25 / 15 3 / 26 / 15 3 / 27 / 15 3 / 28 / 15 3 / 29 / 15 3 / 30 / 15 3 / 31 / 15 4 / 1 / 15 4 / 2 / 15 4 / 3 / 15 4 / 4 / 15 4 / 5 / 15 4 / 6 / 15 4 / 7 / 15 4 / 8 / 15 4 / 9 / 15 4 / 10 / 15 4 / 11 / 15 4 / 12 / 15 4 / 13 / 15 4 / 14 / 15 4 / 15 / 15 4 / 16 / 15 4 / 17 / 15 4 / 18 / 15 4 / 19 / 15 4 / 20 / 15 4 / 21 / 15 4 / 22 / 15 4 / 23 / 15 4 / 24 / 15 4 / 25 / 15 4 / 26 / 15 4 / 27 / 15 4 / 28 / 15 4 / 29 / 15 4 / 30 / 15 5 / 1 / 15 5 / 2 / 15 5 / 3 / 15 5 / 4 / 15 5 / 5 / 15 5 / 6 / 15 5 / 7 / 15 5 / 8 / 15 5 / 9 / 15 5 / 10 / 15 5 / 11 / 15 5 / 12 / 15 5 / 13 / 15 5 / 14 / 15 5 / 15 / 15 5 / 16 / 15 5 / 17 / 15 5 / 18 / 15
Display Week: 1 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8
3 / 23 / 15 3 / 30 / 15 4 / 6 / 15 4 / 13 / 15 4 / 20 / 15 4 / 27 / 15 5 / 4 / 15 5 / 11 / 15
WBS

Vertex42: Work Breakdown Structure
Level 1: 1, 2, 3, …
Level 2: 1.1, 1.2, 1.3, …
Level 3: 1.1.1, 1.1.2, 1.1.3, …
The WBS uses a formula to control the numbering, but the formulas are different for different levels.
Task

Vertex42: Task
Enter the name of each task and sub-task. Use indents for sub-tasks.
Lead

Vertex42: Task Lead
Enter the name of the Task Lead in this column.
Prede
cessor

Vertex42: Predecessor Tasks:
You can use this column to enter the WBS of a predecessor for reference. The PRO version includes template rows that allow you to automatically calculate the Start Date based on the Predecessor.
Start

Vertex42: Task Start Date
You can manually enter the Start Date for each task or use a formula to create a dependency on a Predecessor. For example, you could enter =enddate+1 to set the Start date to the next calendar day, or =WORKDAY(enddate,1) to set the Start date to the next work day (excluding weekends), where enddate is the cell reference for the End date of the Predecessor task.
End Cal. Days

Vertex42: Duration (Calendar Days)
The duration is the number of calendar days for the given task. The duration is calculated as the End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day.
Note: The conditional formatting used to create the gantt chart references this column.
%
Done

Vertex42: Percent Complete
Update the status of this task by entering the percent complete (between 0% and 100%).
Work Days

Vertex42: Work Days
Counts the number of work days, excluding the weekends (Saturday and Sunday). In the PRO version, you can customize the work week and list specific non-working days like holidays. In the PRO version, the default input is the Work Days instead of the Calendar Days.
M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S M T W T F S S
1 [Task Category] [Name]
1.1 [Task] [Name] Mon 3/23/15 Fri 3/27/15 5 100% 5
1.2 [Task] Sat 3/28/15 Wed 4/01/15 5 50% 3
1.3 [Task] Thu 4/02/15 Sun 4/05/15 4 75% 2
1.4 [Task] Wed 3/25/15 Sat 3/28/15 4 50% 3
1.5 [Task] Sun 3/29/15 Mon 3/30/15 2 50% 1
1.6 [Task] Tue 3/24/15 Thu 3/26/15 3 50% 3
1.7 [Task] Fri 3/27/15 Tue 3/31/15 5 50% 3
1.8 [Task] Wed 4/01/15 Tue 4/07/15 7 50% 5
1.9 [Insert Rows above this one, then Hide or Delete this row]
2 [Task Category]
2.1 [Task] Mon 3/23/15 Mon 3/23/15 1 0% 1
2.2 [Task] Tue 3/24/15 Tue 3/24/15 1 0% 1
2.3 [Task] Wed 3/25/15 Wed 3/25/15 1 0% 1
2.4 [Task] Thu 3/26/15 Thu 3/26/15 1 0% 1
2.5 [Insert Rows above this one, then Hide or Delete this row]
3 [Task Category]
3.1 [Task] Mon 3/23/15 Mon 3/23/15 1 0% 1
3.2 [Task] Tue 3/24/15 Tue 3/24/15 1 0% 1
3.3 [Task] Wed 3/25/15 Wed 3/25/15 1 0% 1
3.4 [Task] Thu 3/26/15 Thu 3/26/15 1 0% 1
3.5 [Insert Rows above this one, then Hide or Delete this row]
4 [Task Category]
4.1 [Task] Mon 3/23/15 Mon 3/23/15 1 0% 1
4.2 [Task] Tue 3/24/15 Tue 3/24/15 1 0% 1
4.3 [Task] Wed 3/25/15 Wed 3/25/15 1 0% 1
4.4 [Task] Thu 3/26/15 Thu 3/26/15 1 0% 1
4.5 [Insert Rows above this one, then Hide or Delete this row]
TEMPLATE ROWS
See the Help worksheet to learn how to use these rows. You can hide these rows before printing.
CATEGORY ROWS and WBS NUMBERING
1 [ Task Category (label only) ]
1.1 [ Level 2 Task ]
1.1.1 . [ Level 3 Task ]
1.1.1.1 . . [ Level 4 Task ]
Examples of ways to define the Start, End, and Duration of tasks
1 [ Task Category (summary) ] Sun 3/01/15 Sun 3/01/15 1 0
2 Milestone Sun 3/01/15 Sun 3/01/15
2.1 [ Start Date and Calendar Days ] Sun 12/31/99 0
2.2 [ Start Date and End Date ] 0 0

GanttChartPro

Gantt Chart Template Pro
Gantt Chart Template Pro is similar to this free version, but
it is more feature-packed. It also comes with other bonus content.
Learn More About Gantt Chart Template Pro
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
The following link is a blog post that talks specifically about the
Pro version for Excel Online.
Gantt Chart Template Pro for Excel Online
Benefits and Features of Gantt Chart Template Pro
Daily, Weekly, or Monthly View
The Pro version includes a drop-down next to the Display Week that lets you choose to display
the columns in the chart area as days, weeks, or months.
Use Work Days as an Input
By default, the Pro version is set up to have you enter Work Days instead of Calendar Days.
The expanded set of template rows provides more options for defining the Start date, End date,
and Duration of tasks. Define a task based on …
– Start date and End date
– Start date and Work days
– Start date and Calendar days
Easily Create Task Dependencies
Though you can still use your own formulas for creating task dependencies,
the Pro version includes template rows that calculate the Start date based
on the WBS number that you enter in the Predecessor column.
Exclude Holidays from Work Days
List holidays and other specific non-working days that you want to exclude from work days.
Customize Your Work Week
The Pro version for Excel Online uses the WORKDAY.INTL() and NETWORKDAYS.INTL()
functions that allow you define the work week as something other than Monday-Friday.
Simple Color-Coding
The Pro version includes a column for specifying the color of bars in the chart. For example,
you could change the color based on urgency or task lead.
Learn More About Gantt Chart Template Pro

http://www.vertex42.com/Links/go.php?urlid=GanttChartPro
http://www.vertex42.com/Links/go.php?urlid=GanttChartPro
http://www.vertex42.com/blog/business/pm/new-gantt-chart-for-excel-online.html

Help

HELP
Version: Gantt Chart Template for Office 365 – FREE Version
Intro
This Gantt Chart spreadsheet is designed to to help you create a simple project schedule. You
only need to know some basic spreadsheet operations, such as how to insert, delete, copy and
and paste rows and cells. For more advanced uses, such as defining task dependencies, you
will need to know how to enter formulas.
Be sure to read the Getting Started Tips below. Watching the video demos for Gantt Chart Template Pro may also help you see how to use the spreadsheet.
Watch Demo Videos on Vertex42.com
Before sharing this spreadsheet, please read the license agreement in the TermsOfUse worksheet.
Getting Started Tips
– Input cells for defining the task dates and durations have a light green background. Input Cell
– [ Bracketed Text ] is meant to be edited, like the project title and task descriptions.
– Some of the labels include cell comments to provide extra help information. Label

Vertex42: This is an example comment.
– The Project Start Date determines the first week shown in the gantt chart.
– To adjust the range of dates shown in the gantt chart, change the Display Week.
– To insert a new task, insert a new row, then copy/paste a row from the selection of template
rows at the bottom of the worksheet, depending on how you want to define the task.
– If you see “#####” in a cell, widen the column to display the cell contents.
– Backup your file regularly to avoid losing data! Excel files get corrupted occasionally.
Using the Template Rows and Choosing a WBS Level
Inserting New Tasks.
1. Insert a new blank row where you want the new task to be.
2. Copy the entire row you want to use from the set of template rows.
3. Paste the row you copied on top of the new row you just inserted.
4. Copy and paste the WBS cell separately, based on the level (1, 1.2, 1.2.3, 1.2.3.4)
Important: When inserting new rows, you must copy and paste an entire row, because the cells of the Gantt chart area are formulas.
Changing the WBS Level in the WBS Column
– The WBS numbering uses a different formula for each level, but the formula does not reference any other cell in the row. So, you can copy and paste just the WBS cell that you want to use.
– If you leave a blank cell above a WBS number, the numbering will reset to 1.x.x. The formulas are meant for convenience, but you can manually enter them if you need to.
– You can indent the task description for sub-tasks by entering leading spaces or using the Indent feature in Excel.
Category Tasks
– You can use tasks that are just labels, but it may be useful for a category task to display the minimum Start date and maximum End date of its sub tasks. This can be done using =MIN(range_of_startdates) and =MAX(range_of_enddates).
Creating Task Dependencies
– You can enter the Start date manually, or define task dependecies using a formula. Below are the most common options for defining the Start date:
A. Enter the date manually (e.g. 1/3/2015)
B. Reference the Project Start Date (e.g. =$E$4 )
C. Set the Start date to the next Work Day after another task’s End date.
– Use the formula =WORKDAY(enddate,1) where enddate is the reference to the End date of a predecessor task.
– For multiple predecessors, the formula would be =MAX(WORKDAY(enddate1,1),WORKDAY(enddate2,1))
D. Set the Start date to the next Calendar Day after another task’s End date.
– This formula is very simple: =enddate+1
– For multiple predecessors, the formula would be =MAX(enddate1,enddate2,enddate3 )+1
E. Set the Start date to a number of days before or after another date.
– This formula is just like the one in C or D, except that in place of the “1” you enter the number of days, such as =WORKDAY(enddate,5) or =WORKDAY(startdate,-5)
E. Use the Predecessor column to start the day after another task
[ Template rows that use this feature are only in the PRO version ]
Changing the End Date Font to Red when Behind Schedule
[ This feature is only in the PRO version, but if you are familiar with conditional formatting, you could try doing this yourself. ]
Changing the Color of the Bars in the Gantt Chart
[ This feature is only in the PRO version. ]
FAQs
Q: How do I enter the Work Days instead of Calendar Days?
Entering work days instead of calendar days is one of the main features of the Pro version. If you want to figure it out on your own, use the WORKDAY() function to define the End Date and calculate the Calendar Days based on the Start and End dates.
Q: How do I calculate the %Complete for an entire category of tasks?
The %Complete for a category task can be calculated from its sub tasks using the formula below, where “workdays” is a reference to the range of work day values and “complete” is a reference to the %complete for each of the subtasks.
=SUMPRODUCT(workdays,complete)/SUM(workdays)
Example: =SUMPRODUCT(H9:H15,J9:J15)/SUM(H9:H15)
Let’s say you have 3 sub tasks that are 10 days, 12 days, and 14 days long, respectively. If the first subtask is 50% complete and the others are 25% complete, you could calculate the overall percent complete for the group as: =(10*50%+12*25%+14*25%)/(10+12+14).
Q: How do I change the Print Settings? (Excel 2010, 2013)
Select the entire range of cells you want to print and go to File > Print Area > Set Print Area.
Then go to File > Page Setup or File > Print Preview and adjust the Scaling, Marings, and
Page Orientation as desired.
Q: The Start date, End date, or %Complete for a Level 1 task is wrong. How do I fix it?
When using =MIN(), =MAX(), and =SUMPRODUCT(), it is easy for the references to get messed up if you move rows around or insert new rows. You should verify and fix these formulas if they are not referencing the correct ranges.
Example: The image below shows that the MIN() function is not referencing all of the sub tasks.
Q: I’ve messed up the chart area somehow. How do I fix it?
Find a row that works, then copy the cells that make up the gantt chart area from that row into the row that is messed up.
© 2015 Vertex42 LLC

http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html

TermsOfUse

Gantt Chart Template
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
By Vertex42.com
© 2006-2015 Vertex42 LLC
This spreadsheet, including all worksheets and associated content is a copyrighted work under the United States and other copyright laws.
Do not submit copies or modifications of this template to any website or online template gallery.
Please review the following license agreement to learn how you may or may not use this template. Thank you.
See License Agreement
http://www.vertex42.com/licensing/EULA_privateuse.html
Do not delete this worksheet. If necessary, you may hide it by right-clicking on the tab and selecting Hide.

http://www.vertex42.com/licensing/EULA_privateuse.html
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html

image1.png

image2.png

image3.png

Writerbay.net

Looking for top-notch essay writing services? We've got you covered! Connect with our writing experts today. Placing your order is easy, taking less than 5 minutes. Click below to get started.


Order a Similar Paper Order a Different Paper