I need to create a hierarchical tree map of energy measurement in multiple buildings.
Watermeter #1 Bldg 1 [ Watermeter #2 Water [ Watermeter #21 Bldg 2 [ Watermeter #22 Electricity ....
I already have the table with the parent/children relationships recorded in MS EXCEL. The relationship is either defined :
With an integer field "relation to parent ID" ID is the incremental reference of my meters.
Framework: VBA but I'd rather not code something. Or anything else, but with a very clear step by step tutorial.
The point is : I want to spend less time doing it than drawing it in draw.io. (Maybe not for that particular case, but at least for the 2 or 3 next ones)
I've already tried MS treeview instruction from VBA but :
- it's a pain in the ... to use. You have to do a lot of code to be able to get all meters in the tree
- it's ugly
I've spent literally hours on Google trying to find an online service or a software, an couldn't come close to what I'm searching. But to me, this seems a quite useful functionality. It MUST exist somewhere!
I prefer Open/freeware, although my company won't hesitate to spend a couple $.