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)

Real Estate Essentials

Real Estate Essentials

Tap into the secrets of the top investors… Discover The Untold Real Estate Investing Secrets Used By The World’s Top Millionaires To Generate Massive Amounts Of Passive Incomes To Feed Their Families For Decades! Finally You Can Fully Equip Yourself With These “Must Have” Investing Tools For Creating Financial Freedom And Living A Life Of Luxury!

Get My Free Ebook


Post a comment