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/d/1Fzu4z3aAsdLIP6N5iqiePAr5SEQP2wa6rJi5hTIDY2k/edit?usp=sharing
Spreadsheet link: http://bit.ly/FNEngineeringFile
List of Playlist:
- Full Video (First Edition) : https://youtube.com/playlist?list=PL8Boroy7Xr1ljIRymcc6jbNPM8At1oATi
- Pressure Vessel Basic Design : https://youtube.com/playlist?list=PL8Boroy7Xr1kYCDdeocvEScFJul3eGHJu
- Pressure Vessels Series : https://youtube.com/playlist?list=PL8Boroy7Xr1l9zoCHpCdBy93nZwIODZY7
- Shell and Tube Heat Exchangers : https://youtube.com/playlist?list=PL8Boroy7Xr1mIDVrtAImFiwGxYPKZMYrw
- ASME B31.3 : https://youtube.com/playlist?list=PL8Boroy7Xr1mS16IeRzd69P_TVM11fqur
- Design of Material : https://youtube.com/playlist?list=PL8Boroy7Xr1neeSLkmiLVSdWnzPISMv6I
- Shell Calculation : https://youtube.com/playlist?list=PL8Boroy7Xr1nrIj0ffbAaz6ZXSNclowdS
- External Pressure Design Calculation : https://youtube.com/playlist?list=PL8Boroy7Xr1lq81BJK5pA9Xj7LO1LWI1G
- Thickness Calculation : https://youtube.com/playlist?list=PL8Boroy7Xr1miYdr5K0pSPIOaIaSB33R8
- Welded Joints, Radiograhy, Joint Efficiencies : https://youtube.com/playlist?list=PL8Boroy7Xr1l32gwSh9Xl8eCA7OwR7one
- Type of Pressure Design Calculation : https://youtube.com/playlist?list=PL8Boroy7Xr1nCU6X5hoqE-i3cCTEBFqXg
- Nozzles, Reinforcement, Flanges, and Fittings : https://youtube.com/playlist?list=PL8Boroy7Xr1lW4bVEKozOVQsY7ehqFXeK
- Database Series : https://youtube.com/playlist?list=PL8Boroy7Xr1kHfoMKB2uq3KVMYzybENov
- Study Cases : https://youtube.com/playlist?list=PL8Boroy7Xr1nxdnarQezINL8tDKRupuMM
- Question and Answer : https://youtube.com/playlist?list=PL8Boroy7Xr1nWAhu3YurLtnRotOSzZSoT
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