Need help with a solver problem Don't know how to use slover and identify constraints.

J

jdjames4

New Member
Joined
Nov 8, 2016
Messages
3
I'm learning how to use excel for real life project Scheduling. My work is giving me practice promblems and I'm basically on my own learning excel. I learn by baby steps. my job field is operations management I'm use to doing heuristic by hand and I'm an old dog learning how to use excell and solver to better my career. Here is the problem.
The purpose of this project is to design and construct an MS EXCEL spreadsheet that schedules a set of n activities each with at most k predecessors in the project scheduling environment for minimizing project completion time. The important features of this problem environment are as follows:
· The number of maximum predecessors per activity, k, is 5.
· The number of activities, n, may be allowed to vary from 5 and 25.
· The only acceptable activity processing times are non-negative integers.
the first tab displays inputs, intermediate calculations, and outputs for an acceptable instance of the problem. The specific inputs are (1) the number of activities, (2) the processing time of each activity, and (3) precedence relationships between activities. The necessary outputs are (1) a table of the activities and the corresponding ES, EF, LS, LF and slack times, (2) critical path of the project, and (3) Gantt Chart of the project. The second tab displays inputs and outputs of the three test instances given to you, and the intermediate calculations can be skipped here.
The requirements are that once all data are properly entered, the appropriate table is produced and the corresponding project completion time is presented. Some of the objectives in constructing the spreadsheet are that
· The spreadsheet computes the schedule correctly,
· The spreadsheet dynamically adapts to the inputs provided without producing errors in any of the cells
· The only cells that can be modified are those that contain inputs; all other cells should be protected from user abuse (i.e., inputs out of the specified ranges).

The three test promblems are:
[TABLE="width: 614"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [TABLE="width: 614"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Activity j[/TD]
[TD]Duration[/TD]
[TD]Immediate Predecessors[/TD]
[TD]Predecessor 1[/TD]
[TD]Predecessor 2[/TD]
[TD]Predecessor 3[/TD]
[TD]Predecessor 4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]5[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]7[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]11[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]3[/TD]
[TD]3,4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 614"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Activity j[/TD]
[TD]Duration[/TD]
[TD]Immediate Predecessors[/TD]
[TD]Predecessor 1[/TD]
[TD]Predecessor 2[/TD]
[TD]Predecessor 3[/TD]
[TD]Predecessor 4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]7[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]8[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]8[/TD]
[TD]3,4[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]11[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]5[/TD]
[TD]5,6[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]4[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]2[/TD]
[TD]7,8,9[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 614"]
<colgroup><col><col><col><col span="4"></colgroup><tbody>[TR]
[TD]Activity j[/TD]
[TD]Duration[/TD]
[TD]Immediate Predecessors[/TD]
[TD]Predecessor 1[/TD]
[TD]Predecessor 2[/TD]
[TD]Predecessor 3[/TD]
[TD]Predecessor 4[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]9[/TD]
[TD]-[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]12[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]11[/TD]
[TD]2,3[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]6[/TD]
[TD]5,6[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]6[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]12[/TD]
[TD]7[/TD]
[TD]7[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]2[/TD]
[TD]9[/TD]
[TD]9[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]5[/TD]
[TD]10,11,12[/TD]
[TD]10[/TD]
[TD]11[/TD]
[TD]12[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]9[/TD]
[TD]15[/TD]
[TD]15[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]6[/TD]
[TD]12[/TD]
[TD]12[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]11[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]7[/TD]
[TD]14[/TD]
[TD]14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]2[/TD]
[TD]16,17[/TD]
[TD]16[/TD]
[TD]17[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]8[/TD]
[TD]13[/TD]
[TD]13[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]4[/TD]
[TD]17[/TD]
[TD]17[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]5[/TD]
[TD]18,19[/TD]
[TD]18[/TD]
[TD]19[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]2[/TD]
[TD]20,21,22,23[/TD]
[TD]20[/TD]
[TD]21[/TD]
[TD]22[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]9[/TD]
[TD]24[/TD]
[TD]24[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
You must log in or register to reply here.

Similar threads

B
  • Question Question
Chart help - rainfall data
Replies
2
Views
183
JV0710
J
E
  • Question Question
If statement
Replies
4
Views
107
xlhelp15
xlhelp15
G
  • Solved
If Else Loop macro running slow, anyway to speed it up?
Replies
9
Views
258
Alex Blakenburg
A
D
  • Question Question
If formula with date & VLOOKUP
Replies
1
Views
254
etaf
etaf
B
  • Solved
Possible to pull apart 1st section of string for date & time
2 3
Replies
23
Views
437
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,214
Messages
6,170,771
Members
452,353
Latest member
strainu

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top