Dr. Tarek Hegazy: My FREE Educational Software
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.opteam.ca 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.
15.
Simple Bridge Management Spreadsheet
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.
SCH-LEVEL.mpp
Microsoft Project 98 file with macro "Scheduling_Leveling".
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.
TCT-GA.mpp
Microsoft Project 98 file with macro "TCT-View" to view optional
construction methods and macro "TCT-Optimize" to start a Genetic Algorithm
procedure for Time-Cost Trade-Off analysis.
8. Resource Allocation with Different Heuristic Rules
resource-scheduling.mpp
Microsoft Project File with Resource Allocation macro.
7. Predicting the Structural Behaviour of Concrete Slabs Using Neural Networks
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.
Slab.exe
Self-extracting file containing an Excel spreadsheet (Comp.xls) and
six support files. Read the note on first spreadsheet.
6. Parametric Cost Estimating for Highway Projects Using Neural Networks
Reference: Hegazy T., and Ayed, A., (1998) "A Neural Network Model
for Parametric Cost Estimation of Highway Projects," Journal of Construction
Engineering and Management, ASCE, Vol. 24, No. 3, pp. 210-218.
Amr-adpt.xls Excel
Spreadsheet with the Neural Network Model.
Amr-sens.xls Sensitivity
Analysis Excel Spreadsheet.
5.
Excel Sheet for Site Layout Planning
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.
4.
Excel Sheet for CPM
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.
3.
Excel Sheet for CPM with a Bar Chart
CPM-BarChart.xls This Excel worksheet shows a simple and powerful CPM
model. Try applying cash flow calculations on it.
2. BID: A program for bidding stategy models
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.
1. ProBID v. 3.0: Decision-Support Software for Construction Bidding
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.