Make an overview of all the spreadsheet templates

Created on Thursday 15 April 2021, 09:04

Back to task list
  • ID
  • Project
  • Status
  • Priority
  • Type
    Communication and engagement
  • Tags
    Data Hub Priority Plan 2021 General data hub improvements
  • Assigned to
    Carolin Bellstedt
  • Subscribers
    Carolin Bellstedt
    Paul Hoekman

You are not logged in

Log In Register

Please join us and let's build things, together!


As part of the learning / public documentation section, it would be nice to have an overview of all the different spreadsheet templates in one place. This task would be a matter of collecting the templates from the different processing sections/queues and uploading them as different tabs into ONE google spreadsheet.

We can also make an overview tab with filled examples around reference spaces, EMP codes and especially the one on segments, which can be confusing.

Discussion and updates

New task was created

Task was assigned to Carolin Bellstedt

Status change: Open → In Progress

Status update: I've made a document with 4 tabs, 1 for each of the 3 templates that we have so far (flows, stocks, demographics) and 1 overview tab, see here.

I still want to add some more examples in the overview tab, because I think it helps to see what data can look like with the different units, segments, material codes etc., in one place. The idea is that this eventually also becomes one of the manual/guide pages, in which case, we can simply reuse those example (tables).

I've added the Spanish format in an additional too and some more examples. In doing so, I noticed that we have a couple of datasets for which we cannot download the files. My guess is that it has to do with moving from MultipliCity to the Data Hub and having had a different format of data submission that we used previously, since these are mostly files on The Hague and Cape Town, which we worked on at that time.
It's a bit of a shame, because we don't have any other examples for which we have downloadable tables for population by sex, age etc. (though we realised that isn't actually that important from an urban metabolism perspective).

For record keeping, here the population files that I found with nice age and sex distributions, but that can't be downloaded:

As for the actual task, it is sufficiently done now in one place, so that people can see them in one place with examples.

Status change: In Progress → Completed

Thanks Carolin. Noted with the The Hague datasets. That must indeed be a migration oversight. We might be able to recover, but it would require looking at in more detail.

In terms of this particular task, I think what you set up is something we should definitely integrate in the system itself so it's not an external G Doc document only. I made a task here.

Right. Well for now, we don't need those overlooked files, as far as I can tell. No one has asked for them. But good to know that they could possibly be recovered.

Cool, yeah. I'm all for integration here :) The idea was to also make this part of the manual, in the Rawgraphs style, like this example. I remember discussing this with Guus already at some point and he said it is all doable not very complicated.

Cool cool cool, all noted!