Resource Constrained Project Schedule Optimization Demo

Copyright (c) Benny Raphael, 2022
This demo version is provided to illustrate the application of PGSL to schedule optimization. To know more about schedule optimization see my publications in this area. The application is provided here with no warranty whatsoever. The program execution is limited to small problem sizes to limit the load on the server. The program is hosted on a server which does not have a security certificate. So you might get a security warning when you click on the "Verify data" button below. But it is safe to proceed, if you are not inputting any sensitive data. Contact me if you are interested in a commercial version hosted on a secure server.

Input data

You can prepare the data in Excel and copy paste it into the textbox below. Read about the data format in the section below

Data format

Data consists of tab separated columns that you can copy and paste from Excel. There should be a minimum of 7 columns (resources are optional). The first line should be header - the header should have exactly the same fields as in the first row of the table given below:
ID Name Description Duration Quantity Precedents Productivity Output Resource1 FixedCost Unitcost
Unique Identifier of the Activity - should consist of only alphabets and numbers. Should not contain special characters Name of the activity that will be displayed in the output Description (ignored) Maximum Time Of Activity. 0 indicates no constraint on time. Amount of Work to be carried out Identifiers of predecessor activities separated by coma. Leave empty if there are no precedence relationsips for this activity Amount of Work that can be done Per Unit Quantity of Resource Entities produced by the activity Unique Identifier of the Resource needed for the activity Fixed component of the cost of the activity (One time cost at the start of the activity) Cost per unit time of execution of the activity
A1 Site Preparation All prelim works 0 102.3 50 worker 0 100
A2 Excavation Excavate soil to 1.2 m depth 0 1.2 A1 0.6 earthwork JCB 5000 100

In the above table, the first row is the header and should be exactly the same in your data file. The second row is provided for describing the fields. It should NOT be in your data file. The third and fourth rows are examples for illustration. Use your own data for all the rows starting from 2.
The last three columns should be repeated for each resource, if any activity requires more than one resource. Some activities can have multiple columns for resources, while others may not have any columns for resources at all.