Dear Judy,
First of all thanks for your reply. Secondly, I attached to you another version of the model after I made some modifications. It can be seen in the model, I named a new server as Section 1 and added into it two tasks (Unloading and Leveling, they were servers in previous model) each has its resource (vehicle). I used only one entity for the two tasks.
Section 1 will have total Quantity by 2031.25m3 (Which means the total amount of material, since a truck will unload this material and a grader will level it on the surface). The total length of this server (Section 1) is 200 meters as in real life. For the first resource "Aggregate Tipper Truck", its total number is NumAggTr = 20, its rate per hour is named as QSTTRate (has random value), its total number of trips to finish works is TTS = 113 and quantity in each trip is named as QSTT (has also random value). While for the other resource "Grader", its total number is NumGr = 2, its rate per hour is named as QSTGRate (has random value), its total number of trips to finish works is GTS = 32 and quantity in each trip is named as QSTG (has also random value). Since the previous expressions will increase with acceleration, so I inserted Level With Acceleration for each of them to be used as state variable into Finish (Sink). Finally, PPCQSTT and PPCQSTG are the productivity of each task.
I have 5 inquiries and they are:
1- Why the resources did not make the appropriate distance travelling? For example, the number of "Aggregate Tipper Truck" is 20 and total number of trips are 113 so each should make about 6 trips (113/20), since the length of Section 1 is 200 meters, then each should make 1200 meters (200*6).
2- In table which named "Sub-Activity Schedule", if I change the value under "Scheduled Finish Date" column the value under Actual Finish Date will change. Why this occurred and why "Status" never be "Ahead" or "On Time"?
3- How can I calculate the values of PPCQSTT and PPCQSTG Daily or Weekly?
4- If I want to identify constraints into each task, how can I do that?
5- How can I apply the concept of Look-Ahead Planning (Daily or Weekly), to remove the added constraints?
Thank you again
Best regards,
Ahmed Elkherbawy
Model 1.spfx