Her Majesty Hierarchy. Classification and storage methods in MS Excel
How to apply it practically?
There are two modes of working with hierarchies: 1) you need to design a hierarchy in Excel 2) you were given a ready-made hierarchy and you need to work with it. In any case, you should:
Recall the classification of hierarchies. Define Hierarchy Class
Consider which sorting mode makes the most sense. Is it needed at all?
Decide if there are any restrictions on the homogeneity of children. Usually not.
It is important to decide where and how best to store such a hierarchy so that it is convenient to work with. Remember the 8 formats that we discussed above
Formulate controls and checks for the integrity of the hierarchy. Try to automate them.
Conclusion
What is this all for? I set myself several goals:
When working with complex systems, half of the problems arise due to the lack of common terminology. Having common terms is critical for solving practical problems with hierarchies
Problems with hierarchies arise every day, they need to be solved somehow using Excel, sometimes in conjunction with Python. The two most common problems are determining the optimal format for storing a hierarchy in Excel and interpreting hierarchies that someone has already created. I hope my classification and list of storage formats will simplify these processes.
A deep understanding of the hierarchy will allow you to control its integrity, automate checks in Excel and Python, analyze and convert formats
ps Digitalization of consulting
The systematization of approaches to working with hierarchies takes place as part of our first step towards digitalization. Its concept is as follows:
“All key data on the project must be in 1NF (flat table), or there must be an algorithm for their transfer to 1NF”
And below is a complete list of areas of digitalization in which we are moving forward:
Data, flat tables, relational databases
Algorithms, Python, VBA
Hierarchies
Counts
Mathematics, systems thinking, combinatorics, set theory
Neural networks
>>> here we publish a lot of interesting videos on these topics (YouTube)