This tool is developped based on a sample project.
All progress milestones and related % and functions of the progress calculation is to be modified according to nature of project.
Upon input of issuance and receipt of engineering deliverables, this tool output automatically
the graphical progress charts and progress ahead/delay percentage and duration.
Rev.2 Notes: User Defined functions of Ahead/Delay period, Calendar formulas were and Reference formulas of calendar dates modified with better algorithm.
Forecast date formulas were modified with better algorithm. Add drop down list for inputting Doc Status like "IFA", "IFI" or "IFC" that is
displayed by Validation list cascaded with value either of "FA" or "Fl" of DOC Class.
Download : Document Control & Progress Control_r2
This tool is developped based on a sample project.
All progress milestones and related % and functions of the progress calculation is to be modified according to nature of project.
Upon input of procurement status, this tool output automatically the graphical progress charts and progress ahead/delay percentage and duration.
Download : Procurement Progress Control
This Spreadsheet tool is like a commercial available scheduler.
Input start & finish dates and then schedule bar will be displayed in the right Gantchart.
Input progress percent and then actual progress bar will be displayed in the right Gantchart.
Zig-zag line can be drawn by Macro operation.
Copy actual progressed WT and paste those into a right side table and then another sheet display graphical progress chart.
Download : Daily Schedule Tool Weekly Schedule Tool Monthly Schedule Tool
Input start & finish dates and then schedule bar will be displayed in the right Gantchart.
Actual progress bar and Zig-zag line are not available.
Copy actual progressed WT and paste those into a right side table and then another sheet display graphical progress chart.
Download : Daily Schedule Tool Monthly Schedule Tool
Control Piping Welding & Progress.
Plan dates will be automatically generated based on duration, productivity and so on by formuls.
Display graphical plan and actual progress curves.
Download : Piping Welding & Progress Control Tool