Let’s keep the discussion online, so that other users can profit from the exchange of thoughts.
Your stated hierarchy of Country < Region < Commodity is not completely right. You have to distinguish between the spatial and temporal boundaries of your model.
The spatial boundary encompasses all the processes (e.g. production) and flows (e.g. sold products) that you want to consider in your model. In your case, the country is represented by the main system, while the regions are represented by the subsystems inside of main system. The main system shows what is happening in your country without showing the details what is going on in your subsystems. However, the latter can be opened and displayed as individual regional systems.
Which numbers are shown in your flow graphs (main system or subsystems) is influenced by your choice of the respective layer (individual food commodities = layer of “subgoods”, sum of food commodities = layer of goods) and the period of time you were collecting/entering data for (e.g. 1 year, 1 month, …). The latter represents the temporal boundary of your model.
The angles and slices you can look at your model are limited to those elements mentioned above (main system, subsystem, different layers, different periods). Here, Excel might be more flexible. But the main advantage of STAN is that it can deal with uncertain data (using statistical tools like data reconciliation, gross error detection and error propagation). For more information about this topic have a look at our help videos under
www.stan2web.net/support/videos/ (especially video 3).