Veda2.0 Released!


Zeros in tables
#1
Hi there,
Another simple question I'm sure. 
I can't get zeros to appear in tables generated by VEDA-BE.  For example I have a commodity which has activity from 2030 onwards, but no activity before that.  The generated table shows only 2030 onwards, but I want it to always show from 2000 onwards (with zeros where there's no data).
Is there any way to do this?
Thanks,
Adam
Reply
#2
I have a similar question. Is it possible to display the zeros for the flow variables for a process that is not used at all.
Reply
#3
Well, I am not quite sure if I understand correctly your question.

But anyway, if you mean that you would like to see in the VEDA-BE table all input/output flows, even if the flows are always zero, that has been possible for some time by using an undocumented TIMES reporting feature, which includes topology indicators in a VEDA-BE result attribute.  I have now made this feature more easy to use, as follows:
  • You can activate the feature by setting $SET RPT_TOP YES;
  • The topology indicators will then be available in the attribute PAR_Top, having IN/OUT in the UserConstraint dimension, and with zero values;
  • You can thus make all flows included in a table by including both VAR_Fin/VAR_Fout and the Par_Top attribute in the table (optionally filtering already in the Table Definition by UserConstraint=IN/OUT and activating "Include Null").
I think this should be a reasonably convenient method for forcing all flow/activity/capacity variables to be included in VEDA-BE tables. The new switch RPT_TOP will be available in TIMES v3.3.8 to be released very soon.
Reply
#4
Thank you for your response. This was exactly what I wanted to know Smile
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Autoformat options for VBE export tables JGlynn 2 4,895 26-04-2020, 08:23 PM
Last Post: JGlynn
  Importing predefined tables, existing predefined tables accidentally deleted [email protected] 5 7,939 10-07-2019, 11:30 AM
Last Post: Vikrant
  Including rows with "zero" in VEDA BE Tables HadiKyushu 1 4,962 24-10-2018, 01:43 PM
Last Post: AKanudia
  "Missing Tables" error message Giulia Realmonte 0 3,110 13-06-2018, 08:58 PM
Last Post: Giulia Realmonte
  VEDA-BE v4.9.9 always adds a "Scenario" row to tables pedodds 1 6,917 12-08-2017, 11:02 PM
Last Post: AKanudia
  Sets ignored when importing tables to VEDA-BE pedodds 2 8,151 08-02-2016, 05:54 AM
Last Post: pedodds
  Error mesage: Create map Tables Hilke Rosler 11 24,002 25-03-2011, 05:18 AM
Last Post: Kannan
  Buggy use of dates in Temp tables Antti-L 10 25,711 15-03-2011, 10:12 AM
Last Post: Kannan
  Exporting tables to Excel UCL_Will 15 33,727 14-02-2011, 07:33 AM
Last Post: UCL_Will

Forum Jump:


Users browsing this thread: 1 Guest(s)