| SolverRequire.xls | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | Line Item #. | Description | Item | Dia | Insulationthk (mm) | CladdingMaterial | Qty.LM/EA/M2 | Unit | Unit Price | Total Amount | ||
| 2 | 1.01.01.70 | REMOVE CLADDING | PIPE | 4" | ALM | 1.00 | LM | 0.06 | 0.06 | |||
| 3 | 1.01.01.80 | REMOVE CLADDING | PIPE | 6" | ALM | 2.00 | LM | 0.23 | 0.46 | |||
| 4 | 1.01.01.90 | REMOVE CLADDING | PIPE | 8" | ALM | 6.00 | LM | 0.10 | 0.60 | |||
| 5 | 1.01.01.110 | REMOVE CLADDING | PIPE | 12" | ALM | 2.00 | LM | 0.30 | 0.60 | |||
| 6 | 1.01.01.170 | REMOVE CLADDING | PIPE | 30" | ALM | 3.00 | LM | 0.10 | 0.30 | |||
| 7 | 1.01.01.320 | REMOVE CLADDING | ELBOW | 3" | ALM | 1.00 | EA | 0.01 | 0.01 | |||
| 8 | 1.01.01.330 | REMOVE CLADDING | ELBOW | 4" | ALM | 2.00 | EA | 0.14 | 0.28 | |||
| 9 | 1.01.01.340 | REMOVE CLADDING | ELBOW | 6" | ALM | 3.00 | EA | 0.30 | 0.90 | |||
| 10 | 1.01.01.350 | REMOVE CLADDING | ELBOW | 8" | ALM | 3.00 | EA | 0.10 | 0.30 | |||
| 11 | 1.01.01.580 | REMOVE CLADDING | FLANGE | 3" | ALM | 1.00 | EA | 0.01 | 0.01 | |||
| 12 | 1.01.01.590 | REMOVE CLADDING | FLANGE | 4" | ALM | 3.00 | EA | 0.17 | 0.51 | |||
| 13 | 1.01.01.600 | REMOVE CLADDING | FLANGE | 6" | ALM | 5.00 | EA | 0.34 | 1.70 | |||
| 14 | 1.01.01.610 | REMOVE CLADDING | FLANGE | 8" | ALM | 11.00 | EA | 0.10 | 1.10 | |||
| 15 | 1.01.01.680 | REMOVE CLADDING | FLANGE | 24" | ALM | 8.00 | EA | 0.10 | 0.80 | |||
| 16 | 1.01.01.830 | REMOVE CLADDING | VALVE | 2" | ALM | 3.00 | EA | 0.01 | 0.03 | |||
| 17 | 1.01.01.840 | REMOVE CLADDING | VALVE | 3" | ALM | 1.00 | EA | 0.01 | 0.01 | |||
| 18 | 1.01.01.850 | REMOVE CLADDING | VALVE | 4" | ALM | 2.00 | EA | 0.25 | 0.50 | |||
| 19 | 1.01.01.860 | REMOVE CLADDING | VALVE | 6" | ALM | 2.00 | EA | 0.65 | 1.30 | |||
| 20 | 1.01.01.870 | REMOVE CLADDING | VALVE | 8" | ALM | 4.00 | EA | 0.10 | 0.40 | |||
| 21 | 1.01.01.880 | REMOVE CLADDING | VALVE | 10" | ALM | 5.00 | EA | 0.25 | 1.25 | |||
| 22 | 1.01.01.890 | REMOVE CLADDING | VALVE | 12" | ALM | 4.00 | EA | 0.90 | 3.60 | |||
| 23 | 1.01.01.940 | REMOVE CLADDING | VALVE | 24" | ALM | 4.00 | EA | 0.10 | 0.40 | |||
| 24 | 1.01.01.950 | REMOVE CLADDING | VALVE | 30" | ALM | 3.00 | EA | 0.10 | 0.30 | |||
| 25 | 1.01.02.10 | REMOVE CLADDING | FLAT | ALM | 15.00 | SQM | 3.30 | 49.50 | ||||
| 26 | 2.01.01.70 | REMOVE INSULATION | PIPE | 4" | 1.00 | LM | 0.10 | 0.10 | ||||
| 27 | 2.01.01.80 | REMOVE INSULATION | PIPE | 6" | 2.00 | LM | 0.10 | 0.20 | ||||
| 28 | 2.01.01.90 | REMOVE INSULATION | PIPE | 8" | 6.00 | LM | 0.10 | 0.60 | ||||
| 29 | 2.01.01.110 | REMOVE INSULATION | PIPE | 12" | 2.00 | LM | 0.10 | 0.20 | ||||
| 30 | 2.01.01.170 | REMOVE INSULATION | PIPE | 30" | 3.00 | LM | 0.10 | 0.30 | ||||
| 31 | 2.01.01.320 | REMOVE INSULATION | ELBOW | 3" | 1.00 | EA | 0.10 | 0.10 | ||||
| 32 | 2.01.01.330 | REMOVE INSULATION | ELBOW | 4" | 2.00 | EA | 0.10 | 0.20 | ||||
| 33 | 2.01.01.340 | REMOVE INSULATION | ELBOW | 6" | 3.00 | EA | 0.10 | 0.30 | ||||
| 34 | 2.01.01.350 | REMOVE INSULATION | ELBOW | 8" | 3.00 | EA | 0.10 | 0.30 | ||||
| 35 | 2.01.01.580 | REMOVE INSULATION | FLANGE | 3" | 1.00 | EA | 0.10 | 0.10 | ||||
| 36 | 2.01.01.590 | REMOVE INSULATION | FLANGE | 4" | 3.00 | EA | 0.10 | 0.30 | ||||
| 37 | 2.01.01.600 | REMOVE INSULATION | FLANGE | 6" | 5.00 | EA | 0.10 | 0.50 | ||||
| 38 | 2.01.01.610 | REMOVE INSULATION | FLANGE | 8" | 11.00 | EA | 0.10 | 1.10 | ||||
| 39 | 2.01.01.680 | REMOVE INSULATION | FLANGE | 24" | 8.00 | EA | 0.10 | 0.80 | ||||
| 40 | 2.01.01.830 | REMOVE INSULATION | VALVE | 2" | 3.00 | EA | 0.10 | 0.30 | ||||
| 41 | 2.01.01.840 | REMOVE INSULATION | VALVE | 3" | 1.00 | EA | 0.10 | 0.10 | ||||
| 42 | 2.01.01.850 | REMOVE INSULATION | VALVE | 4" | 2.00 | EA | 0.10 | 0.20 | ||||
| 43 | 2.01.01.860 | REMOVE INSULATION | VALVE | 6" | 2.00 | EA | 0.10 | 0.20 | ||||
| 44 | 2.01.01.870 | REMOVE INSULATION | VALVE | 8" | 4.00 | EA | 0.10 | 0.40 | ||||
| 45 | 2.01.01.880 | REMOVE INSULATION | VALVE | 10" | 5.00 | EA | 0.10 | 0.50 | ||||
| 46 | 2.01.01.890 | REMOVE INSULATION | VALVE | 12" | 4.00 | EA | 0.10 | 0.40 | ||||
| 47 | 2.01.01.940 | REMOVE INSULATION | VALVE | 24" | 4.00 | EA | 0.10 | 0.40 | ||||
| 48 | 2.01.01.950 | REMOVE INSULATION | VALVE | 30" | 3.00 | EA | 0.10 | 0.30 | ||||
| 49 | 2.01.02.10 | REMOVE INSULATION | FLAT | 15.00 | SQM | 22.00 | 330.00 | |||||
| 50 | 2.01.02.10 | NEW INSULATION | PIPE | 4" | 75 | FG | 1.00 | LM | 5.00 | 5.00 | ||
| 51 | 2.01.02.10 | NEW INSULATION | PIPE | 6" | 75 | FG | 2.00 | LM | 2.00 | 4.00 | ||
| 52 | 2.01.02.10 | NEW INSULATION | PIPE | 8" | 75 | FG | 6.00 | LM | 6.00 | 36.00 | ||
| 53 | 2.01.02.10 | NEW INSULATION | PIPE | 12" | 75 | FG | 2.00 | LM | 8.00 | 16.00 | ||
| 54 | 2.01.02.10 | NEW INSULATION | PIPE | 30" | 75 | FG | 3.00 | LM | 45.00 | 135.00 | ||
| 55 | 2.01.02.10 | NEW INSULATION | ELBOW | 3" | 75 | FG | 1.00 | EA | 12.00 | 12.00 | ||
| 56 | 2.01.02.10 | NEW INSULATION | ELBOW | 4" | 75 | FG | 2.00 | EA | 75.00 | 150.00 | ||
| 57 | 2.01.02.10 | NEW INSULATION | ELBOW | 6" | 75 | FG | 3.00 | EA | 23.00 | 69.00 | ||
| 58 | 2.01.02.10 | NEW INSULATION | ELBOW | 8" | 75 | FG | 3.00 | EA | 45.00 | 135.00 | ||
| 59 | 2.01.02.10 | NEW INSULATION | FLANGE | 3" | 75 | FG | 1.00 | EA | 12.00 | 12.00 | ||
| 60 | 2.01.02.10 | NEW INSULATION | FLANGE | 4" | 75 | FG | 3.00 | EA | 14.00 | 42.00 | ||
| 61 | 2.01.02.10 | NEW INSULATION | FLANGE | 6" | 75 | FG | 5.00 | EA | 23.00 | 115.00 | ||
| 62 | 2.01.02.10 | NEW INSULATION | FLANGE | 8" | 75 | FG | 11.00 | EA | 10.50 | 115.50 | ||
| 63 | 2.01.02.10 | NEW INSULATION | FLANGE | 24" | 75 | FG | 8.00 | EA | 12.60 | 100.80 | ||
| 64 | 2.01.02.10 | NEW INSULATION | VALVE | 2" | 75 | FG | 3.00 | EA | 12.60 | 37.80 | ||
| 65 | 2.01.02.10 | NEW INSULATION | VALVE | 3" | 75 | FG | 1.00 | EA | 12.60 | 12.60 | ||
| 66 | 2.01.02.10 | NEW INSULATION | VALVE | 4" | 75 | FG | 2.00 | EA | 12.60 | 25.20 | ||
| 67 | 2.01.02.10 | NEW INSULATION | VALVE | 6" | 75 | FG | 2.00 | EA | 12.60 | 25.20 | ||
| 68 | 2.01.02.10 | NEW INSULATION | VALVE | 8" | 75 | FG | 4.00 | EA | 12.60 | 50.40 | ||
| 69 | 2.01.02.10 | NEW INSULATION | VALVE | 10" | 75 | FG | 5.00 | EA | 12.60 | 63.00 | ||
| 70 | 2.01.02.10 | NEW INSULATION | VALVE | 12" | 75 | FG | 4.00 | EA | 12.60 | 50.40 | ||
| 71 | 2.01.02.10 | NEW INSULATION | VALVE | 24" | 75 | FG | 4.00 | EA | 12.60 | 50.40 | ||
| 72 | 2.01.02.10 | NEW INSULATION | VALVE | 30" | 75 | FG | 3.00 | EA | 12.60 | 37.80 | ||
| 73 | 2.01.02.10 | NEW INSULATION | FLAT | 75 | FG | 15.00 | SQM | 12.60 | 189.00 | |||
| 74 | 1.03.01.70 | NEW CLADDING | PIPE | 4" | ALM | 1.00 | LM | 27.88 | 27.88 | |||
| 75 | 1.03.01.80 | NEW CLADDING | PIPE | 6" | ALM | 2.00 | LM | 39.36 | 78.72 | |||
| 76 | 1.03.01.90 | NEW CLADDING | PIPE | 8" | ALM | 6.00 | LM | 49.20 | 295.20 | |||
| 77 | 1.03.01.110 | NEW CLADDING | PIPE | 12" | ALM | 2.00 | LM | 59.04 | 118.08 | |||
| 78 | 1.03.01.170 | NEW CLADDING | PIPE | 30" | ALM | 3.00 | LM | 131.20 | 393.60 | |||
| 79 | 1.03.01.320 | NEW CLADDING | ELBOW | 3" | ALM | 1.00 | EA | 13.00 | 13.00 | |||
| 80 | 1.03.01.330 | NEW CLADDING | ELBOW | 4" | ALM | 2.00 | EA | 14.00 | 28.00 | |||
| 81 | 1.03.01.340 | NEW CLADDING | ELBOW | 6" | ALM | 3.00 | EA | 18.00 | 54.00 | |||
| 82 | 1.03.01.350 | NEW CLADDING | ELBOW | 8" | ALM | 3.00 | EA | 28.00 | 84.00 | |||
| 83 | 1.03.01.580 | NEW CLADDING | FLANGE | 3" | ALM | 1.00 | EA | 14.00 | 14.00 | |||
| 84 | 1.03.01.590 | NEW CLADDING | FLANGE | 4" | ALM | 3.00 | EA | 15.00 | 45.00 | |||
| 85 | 1.03.01.600 | NEW CLADDING | FLANGE | 6" | ALM | 5.00 | EA | 25.00 | 125.00 | |||
| 86 | 1.03.01.610 | NEW CLADDING | FLANGE | 8" | ALM | 11.00 | EA | 20.00 | 220.00 | |||
| 87 | 1.03.01.680 | NEW CLADDING | FLANGE | 24" | ALM | 8.00 | EA | 50.00 | 400.00 | |||
| 88 | 1.03.01.830 | NEW CLADDING | VALVE | 2" | ALM | 3.00 | EA | 32.00 | 96.00 | |||
| 89 | 1.03.01.840 | NEW CLADDING | VALVE | 3" | ALM | 1.00 | EA | 60.00 | 60.00 | |||
| 90 | 1.03.01.850 | NEW CLADDING | VALVE | 4" | ALM | 2.00 | EA | 80.00 | 160.00 | |||
| 91 | 1.03.01.860 | NEW CLADDING | VALVE | 6" | ALM | 2.00 | EA | 100.00 | 200.00 | |||
| 92 | 1.03.01.870 | NEW CLADDING | VALVE | 8" | ALM | 4.00 | EA | 140.00 | 560.00 | |||
| 93 | 1.03.01.880 | NEW CLADDING | VALVE | 10" | ALM | 5.00 | EA | 140.00 | 700.00 | |||
| 94 | 1.03.01.890 | NEW CLADDING | VALVE | 12" | ALM | 4.00 | EA | 143.00 | 572.00 | |||
| 95 | 1.03.01.940 | NEW CLADDING | VALVE | 24" | ALM | 4.00 | EA | 350.00 | 1,400.00 | |||
| 96 | 1.03.01.950 | NEW CLADDING | VALVE | 30" | ALM | 3.00 | EA | 510.00 | 1,530.00 | |||
| 97 | 1.03.02.10 | NEW CLADDING | FLAT | ALM | 15.00 | SQM | 87.00 | 1,305.00 | ||||
Solver | ||||||||||||
Dear all,
Greetings of the day!!!!!!!
I want to develop a simple solver(A mathematical Model.).The format is for your reference.
There are four kinds of Activity. Each activity consists of suppose 20 different items.
i.e Total four activity with total 80 Item.Each Item price is fixed on their respective column
based on job activity.
I have to play with quantity only.
i want a solver in such a way that if i feed total amount it will automatically update the
quantity and perform corresponding calculation and equate the total amount.
Suppose i enter 50000.00 amount in any cell then it automatically update the quantity and euate
the Total Amount.
Constraints. If remove cladding qty is updated randomly then for remove insulation the qty would
be remain same and for New Insulation it remain same and for new cladding it remain same.
Attachment sheet is for ur ref.
Please assist ?
Rgds,
Aligahk06
