17. EasyPlan Program for Integrated Project Management

A simple but powerful spreadsheet program for integrated project management.

 

Educational Version    

 

This is a complete system for estimating, scheduling, cash flow analysis, site layout planning, cost optimization, project control, and delay analysis. All the contractor needs for a competitive edge. Now has repetitive scheduling features.

 

More information in: www.opteam1.com under products. We customize EasyPlan to your training and professional needs.

 

16. BAL: Linear and Repetitive Schedulin on Microsoft Project Software

           A comprehensive program for repetitive scheduling for multi-site infrastructure networks.

BAL-1.exe     Version 1: Download and expand it into a separate directory.

                        After expanding the file, click on the "lob.bat" to setup some controls.

                        Make sure MS macro security is LOW to allow macros to work.

 

                        Run the Microsoft Project file (BAL-1.mpp) which activates the macro Auto_Open.

 

BAL-2.exe     Version 2 (TRB paper on Highway construction, 2005)

                        Download and expand it into a separate directory.  

                        After expanding the file, click on the "lob.bat" to setup some controls.

                        Make sure MS macro security is LOW to allow macros to work.

 

                        Run the Microsoft Project file (BAL-2.mpp) which activates the macro Auto_Open.

 

 

Check the professional version here: www.opteam1.com under products. We customize BAL to your professional needs.

 

                                        Simple Program for Bridge Management Decisions.

Bridge Management     Download and run from Excel.

14. GA for Dynamic Project Control

 Hegazy, T., and Petzold, K. (2003) "Genetic Optimization for Dynamic Project Control," Construction Engineering and Management, ASCE, Vol. 129, No. 4.

 EasyPlan-Control.zip      Unzip the excel file to a directory, then activate it.

13. Delay Analysis Using Daily Windows Analysis

 Delay-Analysis.xls

12. Decision-Making DEMO Software

 E-Choice.exe    Self expanding file. Try it on the college probelm.

11. Excel Sheets for Subcontractor MIS and Schedule Optimization

a) Hegazy, T., and Ersahin, T. (2001) "Simplified Spreadsheet Solutions: I. Subcontractor Information System," Construction Engineering and Management, ASCE, Vol. 127, No. 6, pp.461-468.

 Subcontractor-MIS.xls    Excel worksheet for the above paper.

 

b) Hegazy, T., and Ersahin, T. (2001) "Simplified Spreadsheet Solutions: I. Subcontractor Information System," Construction Engineering and Management, ASCE, Vol. 127, No. 6, pp.469-475.

 Schedule-Optimization.xls    Excel worksheet for the above paper.

10. Resource Allocation and Leveling Using Genetic Algorithms

Reference: Hegazy, T., (1999) "Optimization of Resource Allocation and Leveling Using Genetic Algorithms," Journal of Construction Engineering and Management, ASCE, Vol. 125, No. 3, pp.167-175.

9. Time-Cost Trade-Off Analysis Using Genetic Algorithms

Reference: Hegazy, T. (Dec. 1999) "Optimization of Construction Time-Cost Trade-Off Analysis using Genetic Algorithms," Canadian Journal of Civil Engineering, CSCE, Canada.

8. Resource Allocation with Different Heuristic Rules

Reference: Hegazy, T., Tully, S., and Marzouk, H., "A Neural Network Approach for Predicting the Structural Behaviour of Concrete Slabs," Canadian Journal of Civil Engineering, CSCE, Vol. 25, pp. 668-677.

Reference: Hegazy, T., and Elbeltagi, E., (2000) "Simplified Spreadsheet Solutions: Model for Site Layout Planning," Vol. 42, No. 1, Cost Engineering, AACE International, AACE.

Site-Layout.xls     Excel Spreadsheet with the Spreadsheet Model.

Reference: Hegazy, T., and Ayed, A. (1999) "Simplified Spreadsheet Solutions: Models for CPM and TCT Analyses," Cost Engineering, AACE International, AACE, Vol. 41, No. 7, pp.26-33.

 CPM.xls    This Excel worksheet shows a simple and powerful CPM model. Try it.

 CPM-BarChart.xls    This Excel worksheet shows a simple and powerful CPM model. Try applying cash flow calculations on it.

 

Reference: Moselhi, O. and Hegazy, T., (1990) "Optimum Markup Estimation: A Comparative Study," Proceedings of the 11th International Cost Engineering Congress, 6th AFITEP Annual meeting, Paris, France, pp. M.2.1-8.

Bidding.exe     Download and copy this self expanding file to a separate directory. Type BID to start. This is a DOS program.

Disk1.exe     Disk1 of ProBID

Disk2.exe     Disk2 of ProBID

Download the two files, copy them to a separate directory and expand them. Type PB to start. This is a DOS program requiring about 5 Meg of hard disk space after expansion.