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! I can provide an excel if you want!
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! I can provide an excel if you want!
Thanks in advance!
Manosh