I could use some help to creating a stacked column graph in Vensim OR data table that I could readily paste into excel. I am modeling the changes in the costs for 17 technologies for electric power generation over 100 years. I want to produce a column graph showing the technology cost (y-axis) vs. technology (x-axis) for a single time (e.g., t=1, 25, 50, OR 100). The column for each technology would break-out the cost components into categories such as capital, O&M, fuel, other.
In other words, I have the variable cost indexed by technology and cost component.
Example Cost Table:
Tech1 Tech2 ... TechN
Capital 5 10
O&M 2 3
Fuel 4 2
Other 2 1
I have not this issue addressed in the help files of Vensim DSS 5.11 nor in the forum. I searched for several permutations of custom graphs, tables and reports.
Based on what I read in Chapter 15 of the reference manual, customization and modification of the .vgd file is needed. Here are the issues and questions I have for the three approaches (graph, table, and report):
Custom Bar Graph - The examples in Ch 15 show unstacked bar graphs. Can the cost components be stacked? If so, how?
Custom Table - I can produce a single row of cost components over a column of technology types, but cannot generate a table with multiple rows indexed by a variable other than time.
Is it possible to index the table by a subscript instead of time?
Custom Report - This seems like a workable, but slightly unpleasant option. I have two issues with this option. First, I do not know how to continue long lines of code in a .vgd file onto the next line. Using the backslash "\" at the end of the line appears to comment out the line. Sample code below works for 2 technologies, but I have 17 and the report is only recognizing about 7 or 8 in a single line of text. Second, I get the following error with the code below: "Got zero 0 but expected 4 variable descriptors." The report code still works, but the fact that I am getting an error suggests that something is wrong.
:VAR capital portion[tech1]@10
:VAR fixed om portion[tech1]@10
:VAR capital portion[tech2]@10
:VAR fixed om portion[tech2]@10
Capital \real LCOE capital portion[tech1]/ \real LCOE capital portion[tech2]/
OM \real LCOE fixed om portion[tech1]/ \real LCOE fixed om portion[tech2]/
Capital 14.65 35.70
OM 1.931 3.918
Thanks for the help.