1/31/2024 0 Comments Cara membuat project planner excel![]() ![]() The program is easy to operate and adjustable to project nature. The program calculates the design mix, suppliers' material unit price list, the batch plant manpower rate, monthly manpower cost breakdown, material procurement schedule, material allocation schedule, major construction equipment to be insisted, and batching plant operational cost. The program assumes major construction equipment owned by the company, a 13-month project schedule, and a total concrete supply of 12,628 M3. I have developed a CASH FLOW BUDGET for concrete supply in oil and gas plants, consisting of 10 worksheets and a formula. If you liked it, make sure to subscribe for more! Enjoy watching this video until it is finished because it provides a comprehensive understanding of the template and its operation. #projectcontrols #projectplanning #projectcontroller #projectcontrollers #projectcontrol #projectscheduling #projectschedullers #projectplanning #projectplanners #projectmanagement #projectmanager #sitemanager #construction #projectmanagementprofessional #projectmanagementinstitute #projectleadership #contractor #pipeline #piping #pipelineengineering #pipingengineering #pipelineengineer #pipingengineer #pipelineengineers #pipingengineers #pipelinecontractors #pipingcontractors #pipelinecontractor #pipingcontractor #beginners #beginner #student #students #saudiarabia #gulf #fareast #dohaqatar #doha #abudhabi #unitedarabemirates #makkah #africa #malaysia #kualalumpur #selangor #petalingjaya #penang #maharashtra #mumbai #delhi #northsyunewzealand #lima #houston #milan #italy #orlando #florida #Massachusetts #boston #Pune #PimpriChinchwadĪlso, I have completed it by making a video. Please LIKE, SHARE, COMMENT, and then leave your email address to get the Excel template. All parts are integrated with the formulation inside, so as allowing all data to be filled automatically in each part, including the curve. The template simplifies reporting by filling in the yellow part. The template shows the progress of the pipeline divided into three spreads: spread 1 (KP 00 ~ KP 11), spread 2 (KP 11 ~ 23), and spread 3 (KP 23 ~ 34 + 250). These include daily welding progress and rejection rate, pipe stringing reports, visual inspection, radiography test, coating/wrapping, progress, and rejection rate percentage, weekly and monthly welding progress with a curve, pipe stringing, pipe trenching report, and pipe lowering-in progress report. I've created a Pipeline KPI Progress Report template consisting of five worksheets. EXCEL PIPING WORK SCHEDULE S CURVE (GANTT CHART) HOW TO CREATE WORK SCHEDULE AND PROGRESS S-CURVE-PIPELINE WORK Ģ. #projectmanagement #projectcontrols #projectplanning #projectscheduling #project #projectmanagers #projectcontroller #projectplanners #sitemanagement #sitemanager #student #students #beginner #beginners #epcprojects #pipeline #pipelines #saudiarabia #gulf #fareasthataradohaqabi #domakkahar #africa #malaysia #kualalumpur #selangor #petalingjaya #penang #maharashtra #mumbai #delhi #northsydney #australia #newzealand #peru #lima #houston #milan #italy #orlando #florida #Massachusetts #boston #Pune #PimpriChinchwadġ. What will the Gantt chart schedule for pipeline work look like? Enjoy watching this video until it's finished so you understand how to create the Gantt chart schedule. There is a contract price for this work, and the duration of each work (START and FINISH), UNIT, and QUANTITY of each work ![]() To make the discussion easier, I have prepared a WBS, a sequential pipeline work starting from SITE PREPARATION WORK to PRECOMMISSIONING WORK. Hopefully, this shall be useful for juniors or beginners and assist those who may be concerned with preparing the works schedule and S-curve sequential pipeline work. You only need to update the actual progress in the space provided, and then the actual progress curve with the variance curve will change automatically. It is reinforcement work with a tight schedule. This work schedule and S-curve are based on COST and SCHEDULE as weight factors of each activity. the WORK SCHEDULE S-CURVE, and the WEIGHT FACTOR PLAN table. The Schedule template consists of 2 worksheets, i.e. ![]() In this case, the scope of work is PIPELINE WORK, and the duration of this WORK is 67 days starting from 22 Feb and ending 29 Apr, or more and less 10 weeks. This time I would like to share how to create the S-curve schedule in Excel with a GANTT CHART which can change automatically, if any changes in the work duration (START and FINISH), so will the WEIGHT FACTOR inside the Gantt chart, and ultimately this will also affect the shape/ line of the S-curve which will also change automatically. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |