M
Manosh
Hi everybody,
I am looking for a simple way to resolve the following problem - don't
worry if it sounds too architectural, you don't have to be an
architect to solve this!
I have a table of assumptions organised like this:
Landuse Unit size Type 1 Type 2 Type
3............n
Apt - 2bed 100m2 10% 50% 50%
Apt - 1bed 60m2 20% 50%
Shop 40m2 70%
50%
.....
N
I'd like to sum the total number of units based on the Type in
another column (on another page) by dividing the built up area with
the unit size.
I would have hard coded this but i can have more than 3 types and many
landuses making a dynamic formula more useful.
Would appreciate your suggestions on how to tackle this!
Thanks in advance!
Manosh
I am looking for a simple way to resolve the following problem - don't
worry if it sounds too architectural, you don't have to be an
architect to solve this!
I have a table of assumptions organised like this:
Landuse Unit size Type 1 Type 2 Type
3............n
Apt - 2bed 100m2 10% 50% 50%
Apt - 1bed 60m2 20% 50%
Shop 40m2 70%
50%
.....
N
I'd like to sum the total number of units based on the Type in
another column (on another page) by dividing the built up area with
the unit size.
I would have hard coded this but i can have more than 3 types and many
landuses making a dynamic formula more useful.
Would appreciate your suggestions on how to tackle this!
Thanks in advance!
Manosh