Veda2.0 Released!


Including rows with "zero" in VEDA BE Tables
#1
I have a quick question!

When I want to have a Table in VEDA BE, I select related Attributes, Commodities, etc. and then VEDA BE producing the Table. However, it dose not show the rows which all of the data are "zero". I want to export the data to an excel file and I want to have all of the combinations of the selected Attributes, Commodities, etc. in the Tables; even if the data is zero in all of the time-slices. 

How can I take care of this issue? Thank you for your help!
Reply
#2
See file times2veda.vdd in GAMS_Src folder. There is a line "not-0 ". This suppresses records with zero values for these variables to check the size of VD files. Commenting this line out should bring in the zeros that you are looking for.

But you could also manage this in Excel if you use formulas to populate a fixed structure that reads from a CSV dump out of VEDA-BE.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)