when I processed the first files, even if I know that we are looking for mass information, I let the original unit of measure given by the statistical offices. Once the file are processed and uploaded in the platform, I realised that the different data are presented together and not sorted by unit. This cause a problem when, for example, you have on the same table data on energy consumption (in TJ or MWh) and CO2 emissions (in tons), because the number quantifying the emissions is much larger than the number quantifying energetic input making it almost irrelevant. Here you can see some examples in "Bilan des livraison d'énergie aux consommateurs finals.." or "Consommation de carburant à l'Aéroport...".
Then, if I want to transform energetic data in mass, they become really small and too close to zero. So, I was wondering what would you recommend me to do. I was thinking to split the excel table in two (for example one with energy consumption data, and the other with the related emissions data), but then I can upload just one processed file related to a registred document in the platform...
And.. which unit of measure is it better to use to quantify energy?
Thanks a lot!