In Lisbon ( Figure 1), the heterogeneous nature of urban space is the result of formal characteristics that are representative of the intersection of different eras and peoples, contextualized by its privileged situation in the territory. Through an initial systematization process reflects upon the formal attributes of vegetation and trees in particular, this research may contribute not only to the development of the discipline of urban morphology applied to the city of Lisbon but also to the acknowledgment of urban greenery as a contributor to the creation of specific, unique, and unrepeatable spaces within urban landscapes. The article focuses on the reading of the public component of three homogeneous areas in Lisbon-Alfama, Avenidas and Alvalade-and specifically on the role of urban greenery as a systemic element of the formal or informal composition of the city. Methodologically, this work uses the city of Lisbon to carry out a morphological characterization of different homogeneous areas based on a decomposition process of urban systems and elements. This essay aims to challenge the most common and stabilized morphological approaches in the city reading process, invoking vegetation and its role as an element of urban composition that is recurrently left out of it. You can remove the CELL() and use the calculated reference in a different way.In the academic context, especially in the fields of architecture, landscape architecture, and urbanism, urban form studies are assumed to be a vehicle for reflection on the built and unbuilt city. The formula in column I returns the parent of each cell as a true reference which is then examined by the CELL() function to show the address. The credit goes to because it is nothing more than a dynamic version of =INDEX(A:A,MAX((A:A"")*(ROW(A:A)))). Given that the hierarchy is contained in A1:G19: If I was to do that, I would start from Last non-empty cell in a column. If you want to avoid VBA completely, you have to find a way to convert End(xlUp) into a formula which may prove difficult because Excel lookups work from top to bottom and you want the other way round. To display the address of the parent of D4. Having put this in a module, you can use it from the sheet, e.g. Set GetParentCell = c.offset(0,-1).end(xlUp) In my case, I need to work from an outline (as shown) or by using a formula for Conditional formatting.Īccording to your rules, the parent of a cell is the first non-empty cell, bottom to top, in the column immediately to the left: public function GetParentCell(byval c as range) as range How to find parent in an indented hierarchy? Here is a similar question that manually provides "level" information. How to programmatically accomplish what was done manually in figure 3?įor each row (recorded in a column outside of the tree), print the location of the cell that is the parent of the cell. Then I am able to count the number of decimals in the outline in order to track level changes using this formula: =LEN(A2)-LEN(SUBSTITUTE(A2,".","")) Now I need to find the immediate ancestor (parent) of every cell (child) in the tree (with the exception of the first row that does not have a parent).įigure 3 (below) shows an example done manually:įurther, I can associate the tree with an outline. I am able to identify the leaf nodes of the tree, as shown in figure 2 below. Using conditional formatting, and this formula: =AND(A1"",OFFSET(A1,1,1)="") My structure is 1000+ rows and as deep as 27 levels.įor a "tree" as depicted above, how to identify the parent of a cell? I have a hierarchical structure similar to figure 1 below. Am running Excel 2013 on Windows 10 with 16 GB memory.
0 Comments
Leave a Reply. |