Often I want to organize data into a tree-like structure. However, I would not know how to do this quickly. Here are two examples:
Example 1 I keep track of my spending, and I am interested in total amount spent in each (sub) category. For example categories like this: Leisure -> Sport -> Materials Leisure -> Sport -> Courses
Example 2 I also keep track of how I spend my time. In this case I want to add up the hours in different (sub) categories. For example categories like this: Hobby -> Computers -> Programming
It should be simple to add and remove both data and categories, and it would be good if it is possible to get a quick overview of the data. I think a spreadsheet would be ideal. However, I am not an export on spreadsheets.
I consulted the documentation of the open source spreadsheet Libre Office Calc, but I could not see how to do this without having to learn a great deal about spreadsheets and scripting.
Another drawback of a normal spreadsheet is that is not made for tree-like information. You could make a table with columns
value. An entry in this table could look like
$100. It is more natural to have a tree with categories, click on leisure, click on sports, click on materials and add an entry.
Question Does anyone know free software that does task I described here? Or example spreadsheets that are available on the web so I don't have to reinvent the wheel?
P.S. See also this question, which does not include adding up numbers for each level of the tree structure Hierarchy tree editor