Project Management | Schedule, Gantt Chart, S-Curve | using googlesheet
FN Engineering FN Engineering
4K subscribers
6,941 views
0

 Published On Nov 28, 2022

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 : https://docs.google.com/spreadsheets/...


Spreadsheet link: http://bit.ly/FNEngineeringFile

List of Playlist:
- Full Video (First Edition) :    • Full Video (First Edition)  
- Pressure Vessel Basic Design :    • Pressure Vessel Basic Design  
- Pressure Vessels Series :    • Pressure Vessels Series  
- Shell and Tube Heat Exchangers :    • Shell and Tube Heat Exchangers  
- ASME B31.3 :    • ASME B31.3  
- Design of Material :    • Design of Material  
- Shell Calculation :    • Shell Calculation  
- External Pressure Design Calculation :    • External Pressure Design Calculation  
- Thickness Calculation :    • Thickness Calculation  
- Welded Joints, Radiograhy, Joint Efficiencies :    • Welded Joints, Radiography, Joint Eff...  
- Type of Pressure Design Calculation :    • Types of Pressures Design Calculation  
- Nozzles, Reinforcement, Flanges, and Fittings :    • Nozzles, Reinforcement, Flanges, and ...  
- Database Series :    • Database Series  
- Study Cases :    • Study Cases  
- Question and Answer :    • Question and Answer  


Tools Riset Keyword: https://www.tubebuddy.com/FNEngineering (affiliate)

** Affiliate disclaimer: some of the above links may be affiliate links, which may generate us a sales commission

show more

Share/Embed