Sign Up

Join TheConstructor to ask questions, answer questions, write articles, and connect with other people. When you join you get additional benefits.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Log in to TheConstructor to ask questions, answer people’s questions, write articles & connect with other people. When you join you get additional benefits.

Sign Up Here

Join for free or log in to continue reading...


Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have a permission to ask a question, You must login to ask question. Get the paid membership

Join for free or log in to continue reading...


Forgot Password?

Don't have account, Sign Up Here
Get the paid membership

Sorry, you do not have a permission to ask a question, You must login to ask question. Get the paid membership

Join for free or log in to continue reading...


Forgot Password?

Don't have account, Sign Up Here
Get the paid membership
theconstructor.org Logo theconstructor.org Logo
Log inJoin

theconstructor.org

theconstructor.org Navigation

  • Articles
    • Recent Articles
    • Popular Articles
    • Write for us
  • Community
  • Categories
    • How To Guide
      • Material Testing Guide
    • Concrete
    • Building
      • Brick Masonry
      • Building Materials
      • Building Tips
    • Construction
      • Equipments
      • Management
    • Digital Construction
    • Geotechnical
      • Foundation
  • Case Studies
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Questions
  • Ask Questions
  • Write for us
  • Artificial Intelligence
  • Sustainability
  • Building
    • Brick Masonry
    • Building Materials
    • Building Tips
    • Formwork/Shuttering
  • Concrete
    • Concrete Admixtures
    • Cement
    • Concrete Cracks
    • Concrete Properties
  • Construction
    • Construction Equipments
    • Construction Management
    • Construction Project
    • Estimating & Costing
  • How To Guide
    • Material Estimation
    • Repair/Protection Guide
    • Material Testing Guide
    • Mix Design Guide
    • Rate Analysis
  • Geotechnical
    • Foundation Engineering
    • Ground Improvement
  • Structural Engineering
    • Strengthening of Structure
    • Structual Inspection
    • Structural Detailing
  • Surveying
  • Tips

KetanPurohit - Questions

Home/ KetanPurohit/Questions
Ask KetanPurohit

Do you need to remove the ads? Get the paid membership

  • About
  • Questions
  • Polls
  • Answers
  • Best Answers
  • Asked Questions
  • Followed Questions
  • Favorite Questions
  • Posts
  • Comments
  • Groups

Discy Latest Questions

Asked: May 15, 2020In: Construction

How to prepare a Gantt chart in Excel?

KetanPurohit
KetanPurohit

KetanPurohit

  • 1 Question
  • 0 Answers
  • 0 Best Answers
  • 10 Points
View Profile
KetanPurohit User

How to prepare a Gantt chart in Excel?

  1. aviratdhodare

    aviratdhodare

    • 37 Questions
    • 252 Answers
    • 0 Best Answers
    • 480 Points
    View Profile
    aviratdhodare
    Added an answer on October 15, 2020 at 9:44 pm

    Gantt chart enable the user(s) or a team to create and share a visual planning regarding a project or event you are managing to your colleagues or management. By doing this, you will increase the chance on finishing the project in a more efficient way, which will increase the companies effectivenessRead more

    Gantt chart enable the user(s) or a team to create and share a visual planning regarding a project or event you are managing to your colleagues or management. By doing this, you will increase the chance on finishing the project in a more efficient way, which will increase the companies effectiveness.

    Therefore, Gantt charts are seen as a very effective project management planning tools, especially when more than 1 person is involved in the success that follows after succeeding of a project. The total of all elementary project components can be called “the work breakdown structure of the project”.

    This is how it looks like in a Gantt chart:

    As you can see, the difference between the list of activities, and the Gantt chart that shows the work breakdown structure, are the following advantages:

    • Simplifying the complexity of a project;
    • Synergy effect among all team members, and making it more effective;
    • Every stakeholder is on the same page;
    • Determining milestones and deliverables according a fixed time schedule;
    • Creating team productivity;
    • Making everything visual and manageable.

    Advanced Gantt charts additionally demonstrate the reliance (i.e., priority) connections between deliverables (which shows a liability as well for all team members). Gantt charts can be applied to show current project status by informing the percentage of successful completion of the project, and a vertical “Today” line can be implemented here as well.

    Gantt charts allow you to schedule activities and resources and are helpful when you are planning and tracking various business processes. For example, you can have a list of activities on the left and a suitable time scale along the top in order to see the following at a glance:

    List of activities that are needed to be done

    • Beginning and ending of activity;
    • Time that is available per activity;
    • The liability between 2 ore more activities;
    • The whole project’s start and end dates.

    For example, here you can see a generic Event Gantt chart, which structures the following activities:

    1. Determine host event
    2. Pick a budget
    3. Pick a location
    4. Pick a date
    5. Make a guest list
    6. Choose a theme
    7. Send out invitations
    8. Order equipment
    9. Plan the food menu
    10. Line up extra hands
    11. Execute last minute orders
    12. Help with thank you notes
    13. Prepare some games
    14. Follow up RSVP stragglers
    15. Make the goody bags
    16. Plan take away gifts
    17. Assign photographer
    18. Clean up
    19. Prepare food
    20. Complete groceries
    21. Quick cleaning sweep
    22. Set up party space
    23. Pick up the cake
    24. Designate honoree

    See less
    • 12
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
      • Share on LinkedIn
      • Share on WhatsApp
  • 0
  • 4 4 Answers
  • 956 Views
  • 0 Followers

Sidebar

Explore

  • Questions
  • Ask Questions
  • Write for us
  • Artificial Intelligence
  • Sustainability
  • Building
    • Brick Masonry
    • Building Materials
    • Building Tips
    • Formwork/Shuttering
  • Concrete
    • Concrete Admixtures
    • Cement
    • Concrete Cracks
    • Concrete Properties
  • Construction
    • Construction Equipments
    • Construction Management
    • Construction Project
    • Estimating & Costing
  • How To Guide
    • Material Estimation
    • Repair/Protection Guide
    • Material Testing Guide
    • Mix Design Guide
    • Rate Analysis
  • Geotechnical
    • Foundation Engineering
    • Ground Improvement
  • Structural Engineering
    • Strengthening of Structure
    • Structual Inspection
    • Structural Detailing
  • Surveying
  • Tips

Footer

  • Ask Questions
  • Write for us
  • Popular Questions
  • Facebook
  • Instagram
  • Twitter
  • Telegram

© 2009-2021 The Constructor. All Rights Reserved.