Project Management | Schedule, Gantt Chart, S-Curve | using googlesheet

Project Schedule - "Project Management" (Part 1)
Software project management
- Microsoft project
- Primavera
- ProjectLibre
- Microsoft Excel
- Google spreadsheet
Project Management
1. Project Schedule
2. Gantt Chart
3. Curve-S Planning
4. Curve-S Actual
Project Schedule consist of Process number, Work description, Duration process, Start process, Finish process, and Predecessor
Example Project
Level 1 Project Schedule
- Preparation
- Procurement
- Fabrication
- Testing
- Delivery
Level 2
- Preparation (Kick off meeting, site survey, approval)
- Procurement (Import material, local material, consumable, tools, services)
- Fabrication (Cutting, forming, machining, welding, assembling)
- Testing (Dimensional check, document review, factory acceptance test)
- Delivery (Finishing, packaging, shipment)
Project Gantt Chart Overview
- Create timeline date
- Create weekly timeline
- Create conditional formatting for highlight duration
- Consider weekend, if required
- Consider holiday, if required
S-Curve Overview
- Create percentage for each process
- Give percentage formula in the timeline
- Make summary percentage for daily and cumulative
- Create Graph or S-Curve
S Curve Planning vs Actual Overview
- Insert new row for actual process
- Make status process for each process
- Modify formula in the timeline
- Make summary percentage for daily and cumulative of actual progress
- Modify Graph or S-Curve
Condition for actual:
- Done : Process has completely finished
- Ongoing: Process has started but has not finish yet
- Progress: Process has not started yet
Project Management Example : docs.google.co...
Spreadsheet link: bit.ly/FNEngine...
List of Playlist:
- Full Video (First Edition) : • Full Video (First Edit...
- Pressure Vessel Basic Design : • Pressure Vessel Basic ...
- Pressure Vessels Series : • Pressure Vessels Series
- Shell and Tube Heat Exchangers : • Shell and Tube Heat Ex...
- ASME B31.3 : • ASME B31.3
- Design of Material : • Design of Material
- Shell Calculation : • Shell Calculation
- External Pressure Design Calculation : • External Pressure Desi...
- Thickness Calculation : • Thickness Calculation
- Welded Joints, Radiograhy, Joint Efficiencies : • Welded Joints, Radiogr...
- Type of Pressure Design Calculation : • Types of Pressures Des...
- Nozzles, Reinforcement, Flanges, and Fittings : • Nozzles, Reinforcement...
- Database Series : • Database Series
- Study Cases : • Study Cases
- Question and Answer : • Question and Answer
Tools Riset Keyword: www.tubebuddy.... (affiliate)
** Affiliate disclaimer: some of the above links may be affiliate links, which may generate us a sales commission