Conclusions

1. The concept of linear programming with negotiable constraints constitutes a powerful tool to address the combinatory explosion problem in architecture and urban planning.

2. The concept can be extended to multi-criteria optimisation.

Figure 1.8 Screenshot solved model (maximising the number of affordable houses)
II] File Edit View Insert Format Tools Data Window WB! Help Type a question for help • _ S X

% £ -

51 il i

■é m - & =

; Arial - 10

- B

u ■

i|ï S3

$ %

tdS

W if

-Ä-A-I

WBMAX

| =SUMPRODUCT(BJ2:F12,B4:F4]

A

B

c

D

E

F

G

H

1

J

K

1

Endogenous variables

N A

N C

N L

N M

N TOT

2

78

0

130

52

260

3

4

Objective function

11250

13750

15000

11250

3412500

5

6

Min. houses

1

260

>-

200

7

Max. houses

1

260

-<-

260

8

Min. houses A

1

-0.2

2G

> =

0

9

Max. houses A

1

-0.3

0

=<=

0

10

Min. houses M

1

-0.15

13

>-

0

11

Max. houses M

1

-0.2

0

-<-

0

12

Total houses

-1

-1

-1

-1

1

0

-

0

13

14

Min. afford, houses

1

1

130

=>=

130

15

16

17

18

19

20

21

22

23

24

►ir

H ■

► H |\ WB! Status XSheetl / Shee

2 X Sheet:

y

Al

1

Ready

IOpenOffice.org 2.0Quickstarterl

IMUM

Figure 1.9 Screenshot solved model (maximising the project developer's fee)

Best Investment Tips and Ideas

Best Investment Tips and Ideas

The dynamics of investing can be very emotional and stressful if not properly managed. When you are aware of what is all involved you give yourself the power to avoid those situations or at least manage them effectively. That will make your investments more exciting, rewarding, and enjoyable. Those positive factors will only lead to greater success in all that achieve with investments and life.

Get My Free Ebook


Post a comment