Getting Variable Data

Below is the example of using the GetMs operation to get variable data. The request contains an instance of opened modeling container and data getting pattern. The response contains the workbook that includes variable data.

SOAP request:

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<GetMs xmlns="http://www.prognoz.ru/PP.SOM.Som">
<tMs xmlns="">
  <id>ABDCEIPPHFNBFOAEENCEKLAHPHGOOLIEGJBPFILIJAJFBPCP!M!S!CKKCPMIPPHFNBFOAELEOCFGAMOCFDJCMEOJLDMHNONLNFNAMH</id>
  </tMs>
<tArg xmlns="">
<pattern>
  <obInst>true</obInst>
<item>
  <key>89669</key>
<problem>
<metamodel>
<visualControllerPattern>
<workbooks>
<types>
  <Item>Variable</Item>
  </types>
  <key>true</key>
<getWbkArg>
<pattern>
  <obInst>true</obInst>
  <useGridAutoAdjust>true</useGridAutoAdjust>
  <series>Get</series>
<cellsTable>
  <headers>true</headers>
<slots>
  <elementKey>true</elementKey>
  <elementName>true</elementName>
  </slots>
  <cells>true</cells>
  <emptyCells>false</emptyCells>
  <getCellDate>true</getCellDate>
  </cellsTable>
  </pattern>
  </getWbkArg>
<getEaxArg>
<pattern>
  <obInst>true</obInst>
  <dataEditState>true</dataEditState>
  <dataSources>Get</dataSources>
<gridStyle>
  <all>true</all>
<parts>
  <it>Table</it>
  </parts>
  </gridStyle>
  <grid>true</grid>
  <useGridAutoAdjust>true</useGridAutoAdjust>
  </pattern>
  </getEaxArg>
  </workbooks>
  <useSourceName>false</useSourceName>
  <levelFormat>Short</levelFormat>
  </visualControllerPattern>
  </metamodel>
  </problem>
  </item>
  </pattern>
<execParams>
  <scenarioKeys />
<execFillWithVariables>
<entryKeys>
  <l>2</l>
  </entryKeys>
<scenarioKeys>
  <l>-1</l>
  </scenarioKeys>
  </execFillWithVariables>
  </execParams>
  </tArg>
  </GetMs>
  </s:Body>
  </s:Envelope>

SOAP response:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">
<soapenv:Body>
<GetMsResult xmlns="http://www.prognoz.ru/PP.SOM.Som" xmlns:q1="http://www.prognoz.ru/PP.SOM.Som" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<id xmlns="">
  <id>ABDCEIPPHFNBFOAEENCEKLAHPHGOOLIEGJBPFILIJAJFBPCP!M!S!CKKCPMIPPHFNBFOAELEOCFGAMOCFDJCMEOJLDMHNONLNFNAMH</id>
  </id>
<meta xmlns="">
<obInst>
<obDesc isShortcut="0" isLink="0" fullUrl="http://v-shp-development.dev.fs.fsight.world/" ver="4" hf="0">
  <i>MODELSPACE</i>
  <n>Modeling container</n>
  <k>1581</k>
  <c>5121</c>
  <p>1580</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <isPermanent>1</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
  <dirty>0</dirty>
<item>
  <k>89669</k>
  <id>MODEL_NEW</id>
  <n>MODEL_NEW</n>
  <vis>1</vis>
  <type>Problem</type>
<problemMd>
<metamodel>
  <k>89670</k>
<visualController>
<workbooks>
<its>
<Item>
  <key>92066</key>
<getWbkResult>
<id>
  <id>ABDCEIPPHFNBFOAEENCEKLAHPHGOOLIEGJBPFILIJAJFBPCP!M!S!WNMLHEMPPHFNBFOAEDPJLALPEMIMEKMCEPICNJELKMOBDNFBH</id>
  </id>
<meta>
<obInst>
<obDesc isShortcut="0" isLink="0" fullUrl="http://v-shp-development.dev.fs.fsight.world/" ver="1" hf="0">
  <i>VARIABLESWB_89670</i>
  <n>VariablesWorkBook</n>
  <k>92066</k>
  <c>2827</c>
  <p>89669</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <isPermanent>0</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
  <dirty>1</dirty>
  <windowsPosition>Vertical</windowsPosition>
  <hasPivot>0</hasPivot>
  <hasLaner>1</hasLaner>
<series count="1">
<its>
<it>
  <k>1</k>
  <id>OBJ1</id>
  <n>MyOutputVavable|A</n>
  <vis>1</vis>
  <kind>Calculate</kind>
  <selectedUnit />
  <tag>2|-1</tag>
  <hasChildren>0</hasChildren>
  <index>0</index>
  <expanded>0</expanded>
  <level>Year</level>
  <childrenCount>0</childrenCount>
  <visibleChildrenCount>0</visibleChildrenCount>
  <flags>0</flags>
  </it>
  </its>
  <displayDataAs>SourceValues</displayDataAs>
  <autoRecalc>1</autoRecalc>
  <createDerivedSeries>Default</createDerivedSeries>
  <permanentData>0</permanentData>
  </series>
<cellsTable columnCount="31" rowCount="1">
<columns>
<dims>
<it>
  <k>0</k>
  <id>calendar</id>
  </it>
  </dims>
<slots>
<s date="1990-01-01">
<els>
<e>
  <k>YEARS:1990</k>
  <n>1990A1</n>
  </e>
  </els>
  </s>
<s date="1991-01-01">
<els>
<e>
  <k>YEARS:1991</k>
  <n>1991A1</n>
  </e>
  </els>
  </s>
<s date="1992-01-01">
<els>
<e>
  <k>YEARS:1992</k>
  <n>1992A1</n>
  </e>
  </els>
  </s>
<s date="1993-01-01">
<els>
<e>
  <k>YEARS:1993</k>
  <n>1993A1</n>
  </e>
  </els>
  </s>
<s date="1994-01-01">
<els>
<e>
  <k>YEARS:1994</k>
  <n>1994A1</n>
  </e>
  </els>
  </s>
<s date="1995-01-01">
<els>
<e>
  <k>YEARS:1995</k>
  <n>1995A1</n>
  </e>
  </els>
  </s>
<s date="1996-01-01">
<els>
<e>
  <k>YEARS:1996</k>
  <n>1996A1</n>
  </e>
  </els>
  </s>
<s date="1997-01-01">
<els>
<e>
  <k>YEARS:1997</k>
  <n>1997A1</n>
  </e>
  </els>
  </s>
<s date="1998-01-01">
<els>
<e>
  <k>YEARS:1998</k>
  <n>1998A1</n>
  </e>
  </els>
  </s>
<s date="1999-01-01">
<els>
<e>
  <k>YEARS:1999</k>
  <n>1999A1</n>
  </e>
  </els>
  </s>
<s date="2000-01-01">
<els>
<e>
  <k>YEARS:2000</k>
  <n>2000A1</n>
  </e>
  </els>
  </s>
<s date="2001-01-01">
<els>
<e>
  <k>YEARS:2001</k>
  <n>2001A1</n>
  </e>
  </els>
  </s>
<s date="2002-01-01">
<els>
<e>
  <k>YEARS:2002</k>
  <n>2002A1</n>
  </e>
  </els>
  </s>
<s date="2003-01-01">
<els>
<e>
  <k>YEARS:2003</k>
  <n>2003A1</n>
  </e>
  </els>
  </s>
<s date="2004-01-01">
<els>
<e>
  <k>YEARS:2004</k>
  <n>2004A1</n>
  </e>
  </els>
  </s>
<s date="2005-01-01">
<els>
<e>
  <k>YEARS:2005</k>
  <n>2005A1</n>
  </e>
  </els>
  </s>
<s date="2006-01-01">
<els>
<e>
  <k>YEARS:2006</k>
  <n>2006A1</n>
  </e>
  </els>
  </s>
<s date="2007-01-01">
<els>
<e>
  <k>YEARS:2007</k>
  <n>2007A1</n>
  </e>
  </els>
  </s>
<s date="2008-01-01">
<els>
<e>
  <k>YEARS:2008</k>
  <n>2008A1</n>
  </e>
  </els>
  </s>
<s date="2009-01-01">
<els>
<e>
  <k>YEARS:2009</k>
  <n>2009A1</n>
  </e>
  </els>
  </s>
<s date="2010-01-01">
<els>
<e>
  <k>YEARS:2010</k>
  <n>2010A1</n>
  </e>
  </els>
  </s>
<s date="2011-01-01">
<els>
<e>
  <k>YEARS:2011</k>
  <n>2011A1</n>
  </e>
  </els>
  </s>
<s date="2012-01-01">
<els>
<e>
  <k>YEARS:2012</k>
  <n>2012A1</n>
  </e>
  </els>
  </s>
<s date="2013-01-01">
<els>
<e>
  <k>YEARS:2013</k>
  <n>2013A1</n>
  </e>
  </els>
  </s>
<s date="2014-01-01">
<els>
<e>
  <k>YEARS:2014</k>
  <n>2014A1</n>
  </e>
  </els>
  </s>
<s date="2015-01-01">
<els>
<e>
  <k>YEARS:2015</k>
  <n>2015A1</n>
  </e>
  </els>
  </s>
<s date="2016-01-01">
<els>
<e>
  <k>YEARS:2016</k>
  <n>2016A1</n>
  </e>
  </els>
  </s>
<s date="2017-01-01">
<els>
<e>
  <k>YEARS:2017</k>
  <n>2017A1</n>
  </e>
  </els>
  </s>
<s date="2018-01-01">
<els>
<e>
  <k>YEARS:2018</k>
  <n>2018A1</n>
  </e>
  </els>
  </s>
<s date="2019-01-01">
<els>
<e>
  <k>YEARS:2019</k>
  <n>2019A1</n>
  </e>
  </els>
  </s>
<s date="2020-01-01">
<els>
<e>
  <k>YEARS:2020</k>
  <n>2020A1</n>
  </e>
  </els>
  </s>
  </slots>
  </columns>
<rows>
<dims>
<it>
  <k>0</k>
  <id>series</id>
  </it>
  </dims>
<slots>
<s>
<els>
<e>
  <k>MyOutputVavable|A</k>
  <n>MyOutputVavable|A</n>
  </e>
  </els>
  </s>
  </slots>
  </rows>
<cells>
  <c v="3" dt="3" row="0" column="0" date="1990-01-01" />
  <c v="7" dt="3" row="0" column="1" date="1991-01-01" />
  <c v="2" dt="3" row="0" column="2" date="1992-01-01" />
  <c v="6" dt="3" row="0" column="3" date="1993-01-01" />
  <c v="4" dt="3" row="0" column="4" date="1994-01-01" />
  <c v="1" dt="3" row="0" column="5" date="1995-01-01" />
  <c v="5" dt="3" row="0" column="6" date="1996-01-01" />
  <c v="3.42857143" dt="3" row="0" column="7" date="1997-01-01" />
  <c v="3.28571429" dt="3" row="0" column="8" date="1998-01-01" />
  <c v="3.14285714" dt="3" row="0" column="9" date="1999-01-01" />
  <c v="3" dt="3" row="0" column="10" date="2000-01-01" />
  <c v="2.85714286" dt="3" row="0" column="11" date="2001-01-01" />
  <c v="2.71428571" dt="3" row="0" column="12" date="2002-01-01" />
  <c v="2.57142857" dt="3" row="0" column="13" date="2003-01-01" />
  <c v="2.42857143" dt="3" row="0" column="14" date="2004-01-01" />
  <c v="2.28571429" dt="3" row="0" column="15" date="2005-01-01" />
  <c v="2.14285714" dt="3" row="0" column="16" date="2006-01-01" />
  <c v="2" dt="3" row="0" column="17" date="2007-01-01" />
  <c v="1.85714286" dt="3" row="0" column="18" date="2008-01-01" />
  <c v="1.71428571" dt="3" row="0" column="19" date="2009-01-01" />
  <c v="1.57142857" dt="3" row="0" column="20" date="2010-01-01" />
  <c v="1.42857143" dt="3" row="0" column="21" date="2011-01-01" />
  <c v="1.28571429" dt="3" row="0" column="22" date="2012-01-01" />
  <c v="1.14285714" dt="3" row="0" column="23" date="2013-01-01" />
  <c v="1" dt="3" row="0" column="24" date="2014-01-01" />
  <c v="0.85714286" dt="3" row="0" column="25" date="2015-01-01" />
  <c v="0.71428571" dt="3" row="0" column="26" date="2016-01-01" />
  <c v="0.57142857" dt="3" row="0" column="27" date="2017-01-01" />
  </cells>
  </cellsTable>
  </meta>
  </getWbkResult>
<getEaxResult>
<id>
  <id />
  </id>
<meta>
<obInst>
<obDesc isShortcut="0" isLink="0" fullUrl="http://v-shp-development.dev.fs.fsight.world/" ver="1" hf="0">
  <i>VARIABLESWB_89670</i>
  <n>VariablesWorkBook</n>
  <k>92066</k>
  <c>2827</c>
  <p>89669</p>
  <h>0</h>
  <hasPrv>0</hasPrv>
  <ic>0</ic>
  <isPermanent>0</isPermanent>
  <isTemp>0</isTemp>
  </obDesc>
  </obInst>
  <dirty>1</dirty>
<dataEditState>
  <readOnly>0</readOnly>
  <modified>0</modified>
  <modifiedSeries>0</modifiedSeries>
  </dataEditState>
<dataSources>
  <its />
  </dataSources>
<grid>
  <visible>1</visible>
  <active>1</active>
  <enabled>1</enabled>
  <viewScale>1</viewScale>
<viewSize>
  <width>-1</width>
  <height>-1</height>
  <units>DLU96</units>
  </viewSize>
  <sizeChanged>0</sizeChanged>
  <viewOrder>0</viewOrder>
  <available>1</available>
  <syncIndicators>0</syncIndicators>
<style>
<defaultStyle>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Font F="Arial" S="8" C="#000000" I="false" B="false" H="12" />
  <Borders />
  <Hyperlink />
  </defaultStyle>
<fixedCorner>
  <Text HA="-1" VA="1" WW="1" M="7px 6px 8px 6px" />
  <NumberFormat F="" FT="0" />
  <Borders />
  <Hyperlink />
  </fixedCorner>
<topHeader>
  <Text HA="2" VA="1" WW="1" M="7px 6px 8px 6px" />
  <NumberFormat F="" FT="0" />
  <Borders />
  <Hyperlink />
  </topHeader>
<leftHeader>
  <Text HA="1" VA="1" WW="0" M="7px 6px 8px 6px" />
  <NumberFormat F="" FT="0" />
  <Borders />
  <Hyperlink />
  </leftHeader>
<internals>
  <Text HA="0" VA="1" WW="1" M="7px 6px 8px 6px" />
  <NumberFormat F="#,##0.00" FT="1" />
  <Borders />
  <Hyperlink />
  </internals>
<ABC>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Borders />
  <Hyperlink />
  </ABC>
<ABCHeader>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Font B="true" />
  <Borders />
  <Hyperlink />
  </ABCHeader>
<ABCTop>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#20B8F2" />
  <Borders />
  <Hyperlink />
  </ABCTop>
<ABCBottom>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#FF8F45" />
  <Borders />
  <Hyperlink />
  </ABCBottom>
<highlightedCells>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Font C="#FF0000" B="true" />
  <Borders />
  <Hyperlink />
  </highlightedCells>
<changedCells>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Font B="true" />
  <Borders />
  <Hyperlink />
  </changedCells>
<virtualCells>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Borders />
  <Hyperlink />
  </virtualCells>
<valueChange>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <NumberFormat F="0.00%" FT="4" />
  <Borders />
  <Hyperlink />
  </valueChange>
<table>
  <Name>EAX table style</Name>
<Range>
  <left>0</left>
  <top>0</top>
  <width>0</width>
  <height>0</height>
  </Range>
<Corner>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#EEEEEE" />
  <Borders />
  <Hyperlink />
  </Corner>
<FirstRow>
  <Width>1</Width>
<Style>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#FFFFFF" />
  <Borders />
  <Hyperlink />
  </Style>
  </FirstRow>
<SecondRow>
  <Width>1</Width>
<Style>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#F3F3F3" />
  <Borders />
  <Hyperlink />
  </Style>
  </SecondRow>
<FirstColumn>
  <Width>1</Width>
  </FirstColumn>
<SecondColumn>
  <Width>1</Width>
  </SecondColumn>
<HeaderRow>
  <Width>0</Width>
<Style>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#EEEEEE" />
<Borders>
  <Border I="2" S="0" C="#BBBBBB" />
  <Border I="5" S="0" C="#BBBBBB" />
  <Border I="6" S="0" C="#FFFFFF" />
  <Border I="7" S="0" C="#FFFFFF" />
  </Borders>
  <Hyperlink />
  </Style>
  </HeaderRow>
<HeaderColumn>
  <Width>0</Width>
<Style>
  <Text HA="-1" VA="-1" WW="-1" M="-1 -1 -1 -1" />
  <Fill C="#EEEEEE" />
<Borders>
  <Border I="3" S="0" C="#BBBBBB" />
  <Border I="4" S="0" C="#BBBBBB" />
  <Border I="6" S="0" C="#FFFFFF" />
  <Border I="7" S="0" C="#FFFFFF" />
  </Borders>
  <Hyperlink />
  </Style>
  </HeaderColumn>
<FooterRow>
  <Width>0</Width>
  </FooterRow>
<FooterColumn>
  <Width>0</Width>
  </FooterColumn>
  <PredefinedStyle>ExtGreyStriped</PredefinedStyle>
  <IsEmpty>0</IsEmpty>
  </table>
  <calcs />
  <internalFormatConditions />
  <totalsFormatConditions />
  <ABCFormatConditions />
  <rangeFormatConditions />
  <rangeCellStyles />
  </style>
  <transposed>0</transposed>
  <displayLegend>0</displayLegend>
  <displayNumbers>0</displayNumbers>
  <displayGrid>0</displayGrid>
  <fixHeaders>1</fixHeaders>
  <fixHeadersOnPrint>1</fixHeadersOnPrint>
  <rowsHierarchical>1</rowsHierarchical>
  <columnsHierarchical>1</columnsHierarchical>
  <rowsHierarchyIndent>-1</rowsHierarchyIndent>
  <columnsHierarchyIndent>-1</columnsHierarchyIndent>
  <headerTitleType>None</headerTitleType>
  <headerTitleContentType>Dim</headerTitleContentType>
  <headerTitle />
<adjust>
  <mode>Simple</mode>
  <minVisibleDataColumns>1</minVisibleDataColumns>
  <maxRowsInCell>2</maxRowsInCell>
  </adjust>
  <isEnabledRowsGrowth>0</isEnabledRowsGrowth>
  <isEnabledColsGrowth>0</isEnabledColsGrowth>
  <canEnableRowsGrowth>1</canEnableRowsGrowth>
  <canEnableColsGrowth>1</canEnableColsGrowth>
  <dataDisplayMode>Interactive</dataDisplayMode>
  <rowsSparklines>0</rowsSparklines>
  <columnsSparklines>0</columnsSparklines>
  <totalsSparklines>0</totalsSparklines>
<legends>
<md>
<Legends>
<Legend0 ItemsOrder="LeftToRight" NoDataVisible="true" Visibility="Visible" Format="#,##0.00" HorizontalAlignment="Right" HoverMode="MouseOver" TextSpacing="3.00000" IsOuter="true" DoHighlight="false" NoDataPosition="After" Id="Legend0" TextHorizontalAlignment="Left" IncludeEquals="true" Margin="0.00000 0.00000 0.00000 0.00000" Type="Intervals" Marker="Custom" AutoColumnsCount="true" ColorApplying="Marker" CellSpacing="5.00000 5.00000" Mode="LessGreater" IsOverlap="false" ColumnCount="1" Padding="6.00000 6.00000 6.00000 6.00000" VerticalAlignment="Top" ContentAlignment="Center">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  <Background Color="#EFEFEF" Opacity="1.00000" PPType="PP.SolidColorBrush" />
  </Release>
  </Style>
  <EqualFormat IsAuto="true" />
  <MarkerImage ResourceId="TRANSPARENT" />
  <MarkerImageMask ResourceId="TEXTCOLORLEGENDICON" />
  <GreaterFormat IsAuto="true" />
  <LessFormat IsAuto="true" />
  <BetweenFormat IsAuto="true" />
  <NoDataText IsAuto="true" />
<Header NoDataText="" TextWrapping="WrapWithEllipsis" Margin="0.00000 0.00000 0.00000 11.00000" Padding="0.00000 0.00000 0.00000 0.00000" Alignment="Center" IsVisible="true">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  </Release>
  </Style>
  <MaskText IsAuto="true" />
  <NoDataText IsAuto="true" />
  <Text IsAuto="true" />
  </Header>
  </Legend0>
<Legend1 Margin="0.00000 0.00000 0.00000 0.00000" MinValue="0.00000" Type="Size" Marker="Custom" MaxValue="0.00000" Visibility="Visible" HorizontalAlignment="Right" Format="" TextSpacing="10.00000" IsOuter="true" Id="Legend1" IsOverlap="false" Padding="6.00000 6.00000 6.00000 6.00000" VerticalAlignment="Top">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  <Background Color="#EFEFEF" Opacity="1.00000" PPType="PP.SolidColorBrush" />
  </Release>
  </Style>
  <MaxValueFormat IsAuto="false" Value="{0:0.00}" />
  <MinValueFormat IsAuto="false" Value="{0:0.00}" />
  <MinMarkerImage Width="32" Height="32" Source="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAACHSURBVFhH7ZHBCYAwEASvBWvJX1DSQlqwBVuwBVuwJ1uwBd2Vi4gvQbzXDiwx62P0zoQQQogvtF2/IatfY4E4U47sSPI6DkhnZEIWnl7HASnHn5CBz17HAGGpUpwNwjXk82UEkHH8lN4TswaI+Mccf/GK3cjOr/9C8VOGe13D9VFCCCHEO8wOnREwX6ApumAAAAAASUVORK5CYII=" />
  <MaxMarkerImage Width="32" Height="32" Source="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAFQSURBVFhH7Zb9DYIwEMVZwRVcwf9NNK7ACqzACqzgCq7gCqzACqygv5KredaPtNCamPCSC3C9vgd37ZVqxYq/xP5wbLGbWG1DvwGCY/ACVxsqD8ROgbi3rYWUBUJnEdX71kLKAZEN5tN/xTQbvYWVAyKNCE5fzFXXw24KLAUELiI21ZxrJ75uCiwByF36vdAj3dxrGQZz5wfkuvefFhzPWoaTufMC4l5EnrYcz1qGs7nzwQmKwMtqx6dlcNnY2FAeQPgx/R74tQx5WzOEg5C/3Wr4tQwXcy8HZFHNJohzlqcMEOmXfW23jGsZ8rTmgDTFlrdmSOqANNWWnZAQaOuNSilx2i/ml4HJ2nqdRS0q4nTLzm/NTNaTL3pbERu++LzWzER33nuSxtxRIF5Ll35CMklbb3JrJV6zN5o7HkzS1Z98uDBH/5yc/eZ/ccUfoqru/Rsv7haParsAAAAASUVORK5CYII=" />
<Header NoDataText="" TextWrapping="WrapWithEllipsis" Margin="0.00000 0.00000 0.00000 11.00000" Padding="0.00000 0.00000 0.00000 0.00000" Alignment="Center" IsVisible="true">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  </Release>
  </Style>
  <MaskText IsAuto="true" />
  <NoDataText IsAuto="true" />
  <Text IsAuto="true" />
  </Header>
  </Legend1>
<Legend2 ItemsOrder="LeftToRight" NoDataVisible="true" Visibility="Visible" Format="" HorizontalAlignment="Right" HoverMode="MouseOver" TextSpacing="3.00000" IsOuter="true" DoHighlight="false" NoDataPosition="After" Id="Legend2" TextHorizontalAlignment="Left" IncludeEquals="true" Margin="0.00000 0.00000 0.00000 0.00000" Type="Intervals" Marker="Rectangle" AutoColumnsCount="true" ColorApplying="Marker" CellSpacing="5.00000 5.00000" Mode="LessGreater" IsOverlap="false" ColumnCount="1" Padding="6.00000 6.00000 6.00000 6.00000" VerticalAlignment="Top" ContentAlignment="Center">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  <Background Color="#EFEFEF" Opacity="1.00000" PPType="PP.SolidColorBrush" />
  </Release>
  </Style>
  <EqualFormat IsAuto="true" />
  <GreaterFormat IsAuto="true" />
  <LessFormat IsAuto="true" />
  <BetweenFormat IsAuto="true" />
  <NoDataText IsAuto="true" />
<Header NoDataText="" TextWrapping="WrapWithEllipsis" Margin="0.00000 0.00000 0.00000 11.00000" Padding="0.00000 0.00000 0.00000 0.00000" Alignment="Center" IsVisible="true">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  </Release>
  </Style>
  <MaskText IsAuto="true" />
  <NoDataText IsAuto="true" />
  <Text IsAuto="true" />
  </Header>
  </Legend2>
<Legend3 Margin="0.00000 0.00000 0.00000 0.00000" MinValue="6.00000" Type="Size" Marker="Custom" MaxValue="18.00000" Visibility="Visible" HorizontalAlignment="Center" Format="# ##0,00" TextSpacing="10.00000" IsOuter="true" Id="Legend3" IsOverlap="false" Padding="6.00000 6.00000 6.00000 6.00000" VerticalAlignment="Center">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  <Background Color="#EFEFEF" Opacity="1.00000" PPType="PP.SolidColorBrush" />
  </Release>
  </Style>
  <MaxValueFormat IsAuto="false" Value="18,00" />
  <MinValueFormat IsAuto="false" Value="6,00" />
  <MinMarkerImage Width="32" Height="32" Source="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAEBSURBVFhHxZMxD8FQFIX9PgmrsAqTRGIWk0FYxY4ZiwU7Ozs/oIOx4+W85MojZ6rnGL6092t77+ltWjKzv0KlEiqVUKmESiVUKqFSCZVKqFRCpRIqlVCphMqY5nBzf2IFubOeMVTGoFGe54XAs5/9PqEyxgMcjyc7Xy6WZZnNF0vb7Q/BxzWu4/x6u6UNgIblSjU0R5BavRGGeTCvcc90NrP+YJB+AxgO/I2brfbbBlB3e71X0KQBMATNAVbtA3FcrTevGsNH43HYQvINYNXAzxHKv7XXwO9JFqAz2YZGBfn+N/w1VCqhUgmVSqhUQqUSKpVQqYRKJVQqoVIJlTqs9AAV/Pr88/9WbQAAAABJRU5ErkJggg==" />
  <MaxMarkerImage Width="32" Height="32" Source="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAErSURBVFhH7ZWxTgJBFEX3E/wiEyxNoCXaEqxMTKgNFQXB1tCDtdrYKD320MMHbEG55ZP7zCRvhxuMJlwoLM7uzpk3M3dfNtnCzI4KlUqoVEKlEiqVUKmESiVUKqFSCZVKis7g9WzLZouJ2cQAVlWVFJzpAXD5D8ACTKZPdt64sNV67eP21bWPwfNLvT6fWyyXdtls+fiu16vVJvYGeP+Y+UJsEAPEmkg+h/Cd7o0/I0jaI/JjB7AoD4AxNsQbxtp8DsANRyMPE2sTvw6QQGfu+/2ay+fm80/vAALgXpblTu1BA+D+OB77wdgDgfLavQHwIWFhAi1Nz3gjhEJrcVA6JM7F9X/uwKE5rQC3D28uxHz/C3A5JlQqoVIJlUqoVEKlEiqVUKmESh1WfAE6KHMXvxr0twAAAABJRU5ErkJggg==" />
<Header NoDataText="" TextWrapping="WrapWithEllipsis" Margin="0.00000 0.00000 0.00000 11.00000" Padding="0.00000 0.00000 0.00000 0.00000" Alignment="Center" IsVisible="true">
<Style>
<Release>
  <Font Size="12.00000" IsBold="false" Color="#FF505050" FontFamily="Calibri" IsItalic="false" IsUnderline="false" />
  </Release>
  </Style>
  <MaskText IsAuto="true" />
  <NoDataText IsAuto="true" />
  <Text IsAuto="false" Value="Value: " />
  </Header>
  </Legend3>
  </Legends>
  </md>
<legendAssignment>
<it>
  <Key>Value</Key>
<Value>
  <index>3</index>
  <id>Legend3</id>
  </Value>
  </it>
<it>
  <Key>BackgroundColor</Key>
<Value>
  <index>2</index>
  <id>Legend2</id>
  </Value>
  </it>
<it>
  <Key>FontColor</Key>
<Value>
  <index>0</index>
  <id>Legend0</id>
  </Value>
  </it>
<it>
  <Key>FontSize</Key>
<Value>
  <index>1</index>
  <id>Legend1</id>
  </Value>
  </it>
  </legendAssignment>
  </legends>
  <hyperlinksAsText>0</hyperlinksAsText>
<footnotesOptions>
  <position>None</position>
  <percentWidth>-1</percentWidth>
  <percentHeight>-1</percentHeight>
  </footnotesOptions>
  <highlightEvaluatedCells>0</highlightEvaluatedCells>
  </grid>
  <windowsPosition>Vertical</windowsPosition>
  <hasPivot>0</hasPivot>
  </meta>
  </getEaxResult>
  </Item>
  </its>
  </workbooks>
  <userRPath />
  <isRExist>0</isRExist>
  </visualController>
<suppressEmptyFilter>
  <suppressEmpty>0</suppressEmpty>
  <suppressEmptyArea>SerieBounds</suppressEmptyArea>
  </suppressEmptyFilter>
  <readOnly>0</readOnly>
  <variableTestUseR>0</variableTestUseR>
  <calculateIdentOnFact>0</calculateIdentOnFact>
  </metamodel>
  <useScenarios>0</useScenarios>
  <readOnly>0</readOnly>
  </problemMd>
  </item>
  </meta>
  </GetMsResult>
  </soapenv:Body>
  </soapenv:Envelope>

JSON request:

{
 "GetMs" : 
  {
   "tMs" : 
    {
     "id" : "ABDCEIPPHFNBFOAEENCEKLAHPHGOOLIEGJBPFILIJAJFBPCP!M!S!CKKCPMIPPHFNBFOAELEOCFGAMOCFDJCMEOJLDMHNONLNFNAMH"
    },
   "tArg" : 
    {
     "pattern" : 
      {
       "obInst" : "true",
       "item" : 
        {
         "key" : "89669",
         "problem" : 
          {
           "metamodel" : 
            {
             "visualControllerPattern" : 
              {
               "workbooks" : 
                {
                 "types" : 
                  {
                   "Item" : "Variable"
                  },
                 "key" : "true",
                 "getWbkArg" : 
                  {
                   "pattern" : 
                    {
                     "obInst" : "true",
                     "useGridAutoAdjust" : "true",
                     "series" : "Get",
                     "cellsTable" : 
                      {
                       "headers" : "true",
                       "slots" : 
                        {
                         "elementKey" : "true",
                         "elementName" : "true"
                        },
                       "cells" : "true",
                       "emptyCells" : "false",
                       "getCellDate" : "true"
                      }
                    }
                  },
                 "getEaxArg" : 
                  {
                   "pattern" : 
                    {
                     "obInst" : "true",
                     "dataEditState" : "true",
                     "dataSources" : "Get",
                     "gridStyle" : 
                      {
                       "all" : "true",
                       "parts" : 
                        {
                         "it" : "Table"
                        }
                      },
                     "grid" : "true",
                     "useGridAutoAdjust" : "true"
                    }
                  }
                },
               "useSourceName" : "false",
               "levelFormat" : "Short"
              }
            }
          }
        }
      },
     "execParams" : 
      {
       "scenarioKeys" : "",
       "execFillWithVariables" : 
        {
         "entryKeys" : 
          {
           "l" : "2"
          },
         "scenarioKeys" : 
          {
           "l" : "-1"
          }
        }
      }
    }
  }
}

JSON response:

{
 "GetMsResult" : 
  {
   "id" : 
    {
     "id" : "ABDCEIPPHFNBFOAEENCEKLAHPHGOOLIEGJBPFILIJAJFBPCP!M!S!CKKCPMIPPHFNBFOAELEOCFGAMOCFDJCMEOJLDMHNONLNFNAMH"
    },
   "meta" : 
    {
     "obInst" : 
      {
       "obDesc" : 
        {
         "@fullUrl" : "http:\/\/v-shp-development.dev.fs.fsight.world\/",
         "@isShortcut" : "0",
         "@isLink" : "0",
         "@ver" : "4",
         "@hf" : "0",
         "i" : "MODELSPACE",
         "n" : "Modeling container",
         "k" : "1581",
         "c" : "5121",
         "p" : "1580",
         "h" : "0",
         "hasPrv" : "0",
         "ic" : "0",
         "isPermanent" : "1",
         "isTemp" : "0"
        }
      },
     "dirty" : "0",
     "item" : 
      {
       "k" : "89669",
       "id" : "MODEL_NEW",
       "n" : "MODEL_NEW",
       "vis" : "1",
       "type" : "Problem",
       "problemMd" : 
        {
         "metamodel" : 
          {
           "k" : "89670",
           "visualController" : 
            {
             "workbooks" : 
              {
               "its" : 
                {
                 "Item" : 
                  {
                   "key" : "92066",
                   "getWbkResult" : 
                    {
                     "id" : 
                      {
                       "id" : "ABDCEIPPHFNBFOAEENCEKLAHPHGOOLIEGJBPFILIJAJFBPCP!M!S!WNMLHEMPPHFNBFOAEDPJLALPEMIMEKMCEPICNJELKMOBDNFBH"
                      },
                     "meta" : 
                      {
                       "obInst" : 
                        {
                         "obDesc" : 
                          {
                           "@fullUrl" : "http:\/\/v-shp-development.dev.fs.fsight.world\/",
                           "@isShortcut" : "0",
                           "@isLink" : "0",
                           "@ver" : "1",
                           "@hf" : "0",
                           "i" : "VARIABLESWB_89670",
                           "n" : "VariablesWorkBook",
                           "k" : "92066",
                           "c" : "2827",
                           "p" : "89669",
                           "h" : "0",
                           "hasPrv" : "0",
                           "ic" : "0",
                           "isPermanent" : "0",
                           "isTemp" : "0"
                          }
                        },
                       "dirty" : "1",
                       "windowsPosition" : "Vertical",
                       "hasPivot" : "0",
                       "hasLaner" : "1",
                       "series" : 
                        {
                         "@count" : "1",
                         "its" : 
                          {
                           "it" : 
                            [
                              {
                               "k" : "1",
                               "id" : "OBJ1",
                               "n" : "MyOutputVavable|A",
                               "vis" : "1",
                               "kind" : "Calculate",
                               "selectedUnit" : "",
                               "tag" : "2|-1",
                               "hasChildren" : "0",
                               "index" : "0",
                               "expanded" : "0",
                               "level" : "Year",
                               "childrenCount" : "0",
                               "visibleChildrenCount" : "0",
                               "flags" : "0"
                              }
                            ]
                          },
                         "displayDataAs" : "SourceValues",
                         "autoRecalc" : "1",
                         "createDerivedSeries" : "Default",
                         "permanentData" : "0"
                        },
                       "cellsTable" : 
                        {
                         "@rowCount" : "1",
                         "@columnCount" : "31",
                         "columns" : 
                          {
                           "dims" : 
                            {
                             "it" : 
                              {
                               "k" : "0",
                               "id" : "calendar"
                              }
                            },
                           "slots" : 
                            {
                             "s" : 
                              [
                                {
                                 "@date" : "1990-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1990",
                                     "n" : "1990A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1991-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1991",
                                     "n" : "1991A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1992-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1992",
                                     "n" : "1992A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1993-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1993",
                                     "n" : "1993A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1994-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1994",
                                     "n" : "1994A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1995-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1995",
                                     "n" : "1995A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1996-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1996",
                                     "n" : "1996A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1997-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1997",
                                     "n" : "1997A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1998-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1998",
                                     "n" : "1998A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "1999-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:1999",
                                     "n" : "1999A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2000-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2000",
                                     "n" : "2000A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2001-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2001",
                                     "n" : "2001A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2002-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2002",
                                     "n" : "2002A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2003-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2003",
                                     "n" : "2003A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2004-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2004",
                                     "n" : "2004A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2005-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2005",
                                     "n" : "2005A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2006-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2006",
                                     "n" : "2006A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2007-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2007",
                                     "n" : "2007A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2008-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2008",
                                     "n" : "2008A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2009-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2009",
                                     "n" : "2009A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2010-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2010",
                                     "n" : "2010A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2011-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2011",
                                     "n" : "2011A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2012-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2012",
                                     "n" : "2012A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2013-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2013",
                                     "n" : "2013A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2014-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2014",
                                     "n" : "2014A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2015-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2015",
                                     "n" : "2015A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2016-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2016",
                                     "n" : "2016A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2017-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2017",
                                     "n" : "2017A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2018-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2018",
                                     "n" : "2018A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2019-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2019",
                                     "n" : "2019A1"
                                    }
                                  }
                                },
                                {
                                 "@date" : "2020-01-01",
                                 "els" : 
                                  {
                                   "e" : 
                                    {
                                     "k" : "YEARS:2020",
                                     "n" : "2020A1"
                                    }
                                  }
                                }
                              ]
                            }
                          },
                         "rows" : 
                          {
                           "dims" : 
                            {
                             "it" : 
                              {
                               "k" : "0",
                               "id" : "series"
                              }
                            },
                           "slots" : 
                            {
                             "s" : 
                              {
                               "els" : 
                                {
                                 "e" : 
                                  {
                                   "k" : "MyOutputVavable|A",
                                   "n" : "MyOutputVavable|A"
                                  }
                                }
                              }
                            }
                          },
                         "cells" : 
                          {
                           "c" : 
                            [
                              {
                               "@v" : "3",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "0",
                               "@date" : "1990-01-01"
                              },
                              {
                               "@v" : "7",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "1",
                               "@date" : "1991-01-01"
                              },
                              {
                               "@v" : "2",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "2",
                               "@date" : "1992-01-01"
                              },
                              {
                               "@v" : "6",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "3",
                               "@date" : "1993-01-01"
                              },
                              {
                               "@v" : "4",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "4",
                               "@date" : "1994-01-01"
                              },
                              {
                               "@v" : "1",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "5",
                               "@date" : "1995-01-01"
                              },
                              {
                               "@v" : "5",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "6",
                               "@date" : "1996-01-01"
                              },
                              {
                               "@v" : "3.42857143",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "7",
                               "@date" : "1997-01-01"
                              },
                              {
                               "@v" : "3.28571429",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "8",
                               "@date" : "1998-01-01"
                              },
                              {
                               "@v" : "3.14285714",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "9",
                               "@date" : "1999-01-01"
                              },
                              {
                               "@v" : "3",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "10",
                               "@date" : "2000-01-01"
                              },
                              {
                               "@v" : "2.85714286",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "11",
                               "@date" : "2001-01-01"
                              },
                              {
                               "@v" : "2.71428571",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "12",
                               "@date" : "2002-01-01"
                              },
                              {
                               "@v" : "2.57142857",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "13",
                               "@date" : "2003-01-01"
                              },
                              {
                               "@v" : "2.42857143",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "14",
                               "@date" : "2004-01-01"
                              },
                              {
                               "@v" : "2.28571429",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "15",
                               "@date" : "2005-01-01"
                              },
                              {
                               "@v" : "2.14285714",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "16",
                               "@date" : "2006-01-01"
                              },
                              {
                               "@v" : "2",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "17",
                               "@date" : "2007-01-01"
                              },
                              {
                               "@v" : "1.85714286",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "18",
                               "@date" : "2008-01-01"
                              },
                              {
                               "@v" : "1.71428571",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "19",
                               "@date" : "2009-01-01"
                              },
                              {
                               "@v" : "1.57142857",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "20",
                               "@date" : "2010-01-01"
                              },
                              {
                               "@v" : "1.42857143",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "21",
                               "@date" : "2011-01-01"
                              },
                              {
                               "@v" : "1.28571429",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "22",
                               "@date" : "2012-01-01"
                              },
                              {
                               "@v" : "1.14285714",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "23",
                               "@date" : "2013-01-01"
                              },
                              {
                               "@v" : "1",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "24",
                               "@date" : "2014-01-01"
                              },
                              {
                               "@v" : "0.85714286",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "25",
                               "@date" : "2015-01-01"
                              },
                              {
                               "@v" : "0.71428571",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "26",
                               "@date" : "2016-01-01"
                              },
                              {
                               "@v" : "0.57142857",
                               "@dt" : "3",
                               "@row" : "0",
                               "@column" : "27",
                               "@date" : "2017-01-01"
                              }
                            ]
                          }
                        }
                      }
                    },
                   "getEaxResult" : 
                    {
                     "id" : 
                      {
                       "id" : ""
                      },
                     "meta" : 
                      {
                       "obInst" : 
                        {
                         "obDesc" : 
                          {
                           "@fullUrl" : "http:\/\/v-shp-development.dev.fs.fsight.world\/",
                           "@isShortcut" : "0",
                           "@isLink" : "0",
                           "@ver" : "1",
                           "@hf" : "0",
                           "i" : "VARIABLESWB_89670",
                           "n" : "VariablesWorkBook",
                           "k" : "92066",
                           "c" : "2827",
                           "p" : "89669",
                           "h" : "0",
                           "hasPrv" : "0",
                           "ic" : "0",
                           "isPermanent" : "0",
                           "isTemp" : "0"
                          }
                        },
                       "dirty" : "1",
                       "dataEditState" : 
                        {
                         "readOnly" : "0",
                         "modified" : "0",
                         "modifiedSeries" : "0"
                        },
                       "dataSources" : 
                        {
                         "its" : ""
                        },
                       "grid" : 
                        {
                         "visible" : "1",
                         "active" : "1",
                         "enabled" : "1",
                         "viewScale" : "1",
                         "viewSize" : 
                          {
                           "width" : "-1",
                           "height" : "-1",
                           "units" : "DLU96"
                          },
                         "sizeChanged" : "0",
                         "viewOrder" : "0",
                         "available" : "1",
                         "syncIndicators" : "0",
                         "style" : 
                          {
                           "defaultStyle" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Font" : 
                              {
                               "@B" : "false",
                               "@S" : "8",
                               "@C" : "#000000",
                               "@F" : "Arial",
                               "@H" : "12",
                               "@I" : "false"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "fixedCorner" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "1",
                               "@HA" : "-1",
                               "@M" : "7px 6px 8px 6px",
                               "@WW" : "1"
                              },
                             "NumberFormat" : 
                              {
                               "@F" : "",
                               "@FT" : "0"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "topHeader" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "1",
                               "@HA" : "2",
                               "@M" : "7px 6px 8px 6px",
                               "@WW" : "1"
                              },
                             "NumberFormat" : 
                              {
                               "@F" : "",
                               "@FT" : "0"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "leftHeader" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "1",
                               "@HA" : "1",
                               "@M" : "7px 6px 8px 6px",
                               "@WW" : "0"
                              },
                             "NumberFormat" : 
                              {
                               "@F" : "",
                               "@FT" : "0"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "internals" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "1",
                               "@HA" : "0",
                               "@M" : "7px 6px 8px 6px",
                               "@WW" : "1"
                              },
                             "NumberFormat" : 
                              {
                               "@F" : "#,##0.00",
                               "@FT" : "1"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "ABC" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "ABCHeader" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Font" : 
                              {
                               "@B" : "true"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "ABCTop" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Fill" : 
                              {
                               "@C" : "#20B8F2"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "ABCBottom" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Fill" : 
                              {
                               "@C" : "#FF8F45"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "highlightedCells" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Font" : 
                              {
                               "@B" : "true",
                               "@C" : "#FF0000"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "changedCells" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Font" : 
                              {
                               "@B" : "true"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "virtualCells" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "valueChange" : 
                            {
                             "Text" : 
                              {
                               "@VA" : "-1",
                               "@HA" : "-1",
                               "@M" : "-1 -1 -1 -1",
                               "@WW" : "-1"
                              },
                             "NumberFormat" : 
                              {
                               "@F" : "0.00%",
                               "@FT" : "4"
                              },
                             "Borders" : "",
                             "Hyperlink" : ""
                            },
                           "table" : 
                            {
                             "Name" : "EAX table style",
                             "Range" : 
                              {
                               "left" : "0",
                               "top" : "0",
                               "width" : "0",
                               "height" : "0"
                              },
                             "Corner" : 
                              {
                               "Text" : 
                                {
                                 "@VA" : "-1",
                                 "@HA" : "-1",
                                 "@M" : "-1 -1 -1 -1",
                                 "@WW" : "-1"
                                },
                               "Fill" : 
                                {
                                 "@C" : "#EEEEEE"
                                },
                               "Borders" : "",
                               "Hyperlink" : ""
                              },
                             "FirstRow" : 
                              {
                               "Width" : "1",
                               "Style" : 
                                {
                                 "Text" : 
                                  {
                                   "@VA" : "-1",
                                   "@HA" : "-1",
                                   "@M" : "-1 -1 -1 -1",
                                   "@WW" : "-1"
                                  },
                                 "Fill" : 
                                  {
                                   "@C" : "#FFFFFF"
                                  },
                                 "Borders" : "",
                                 "Hyperlink" : ""
                                }
                              },
                             "SecondRow" : 
                              {
                               "Width" : "1",
                               "Style" : 
                                {
                                 "Text" : 
                                  {
                                   "@VA" : "-1",
                                   "@HA" : "-1",
                                   "@M" : "-1 -1 -1 -1",
                                   "@WW" : "-1"
                                  },
                                 "Fill" : 
                                  {
                                   "@C" : "#F3F3F3"
                                  },
                                 "Borders" : "",
                                 "Hyperlink" : ""
                                }
                              },
                             "FirstColumn" : 
                              {
                               "Width" : "1"
                              },
                             "SecondColumn" : 
                              {
                               "Width" : "1"
                              },
                             "HeaderRow" : 
                              {
                               "Width" : "0",
                               "Style" : 
                                {
                                 "Text" : 
                                  {
                                   "@VA" : "-1",
                                   "@HA" : "-1",
                                   "@M" : "-1 -1 -1 -1",
                                   "@WW" : "-1"
                                  },
                                 "Fill" : 
                                  {
                                   "@C" : "#EEEEEE"
                                  },
                                 "Borders" : 
                                  {
                                   "Border" : 
                                    [
                                      {
                                       "@S" : "0",
                                       "@C" : "#BBBBBB",
                                       "@I" : "2"
                                      },
                                      {
                                       "@S" : "0",
                                       "@C" : "#BBBBBB",
                                       "@I" : "5"
                                      },
                                      {
                                       "@S" : "0",
                                       "@C" : "#FFFFFF",
                                       "@I" : "6"
                                      },
                                      {
                                       "@S" : "0",
                                       "@C" : "#FFFFFF",
                                       "@I" : "7"
                                      }
                                    ]
                                  },
                                 "Hyperlink" : ""
                                }
                              },
                             "HeaderColumn" : 
                              {
                               "Width" : "0",
                               "Style" : 
                                {
                                 "Text" : 
                                  {
                                   "@VA" : "-1",
                                   "@HA" : "-1",
                                   "@M" : "-1 -1 -1 -1",
                                   "@WW" : "-1"
                                  },
                                 "Fill" : 
                                  {
                                   "@C" : "#EEEEEE"
                                  },
                                 "Borders" : 
                                  {
                                   "Border" : 
                                    [
                                      {
                                       "@S" : "0",
                                       "@C" : "#BBBBBB",
                                       "@I" : "3"
                                      },
                                      {
                                       "@S" : "0",
                                       "@C" : "#BBBBBB",
                                       "@I" : "4"
                                      },
                                      {
                                       "@S" : "0",
                                       "@C" : "#FFFFFF",
                                       "@I" : "6"
                                      },
                                      {
                                       "@S" : "0",
                                       "@C" : "#FFFFFF",
                                       "@I" : "7"
                                      }
                                    ]
                                  },
                                 "Hyperlink" : ""
                                }
                              },
                             "FooterRow" : 
                              {
                               "Width" : "0"
                              },
                             "FooterColumn" : 
                              {
                               "Width" : "0"
                              },
                             "PredefinedStyle" : "ExtGreyStriped",
                             "IsEmpty" : "0"
                            },
                           "calcs" : "",
                           "internalFormatConditions" : "",
                           "totalsFormatConditions" : "",
                           "ABCFormatConditions" : "",
                           "rangeFormatConditions" : "",
                           "rangeCellStyles" : ""
                          },
                         "transposed" : "0",
                         "displayLegend" : "0",
                         "displayNumbers" : "0",
                         "displayGrid" : "0",
                         "fixHeaders" : "1",
                         "fixHeadersOnPrint" : "1",
                         "rowsHierarchical" : "1",
                         "columnsHierarchical" : "1",
                         "rowsHierarchyIndent" : "-1",
                         "columnsHierarchyIndent" : "-1",
                         "headerTitleType" : "None",
                         "headerTitleContentType" : "Dim",
                         "headerTitle" : "",
                         "adjust" : 
                          {
                           "mode" : "Simple",
                           "minVisibleDataColumns" : "1",
                           "maxRowsInCell" : "2"
                          },
                         "isEnabledRowsGrowth" : "0",
                         "isEnabledColsGrowth" : "0",
                         "canEnableRowsGrowth" : "1",
                         "canEnableColsGrowth" : "1",
                         "dataDisplayMode" : "Interactive",
                         "rowsSparklines" : "0",
                         "columnsSparklines" : "0",
                         "totalsSparklines" : "0",
                         "legends" : 
                          {
                           "md" : 
                            {
                             "Legends" : 
                              {
                               "Legend0" : 
                                {
                                 "@Marker" : "Custom",
                                 "@Type" : "Intervals",
                                 "@AutoColumnsCount" : "true",
                                 "@ColorApplying" : "Marker",
                                 "@NoDataVisible" : "true",
                                 "@CellSpacing" : "5.00000 5.00000",
                                 "@Mode" : "LessGreater",
                                 "@Visibility" : "Visible",
                                 "@HoverMode" : "MouseOver",
                                 "@HorizontalAlignment" : "Right",
                                 "@Format" : "#,##0.00",
                                 "@TextSpacing" : "3.00000",
                                 "@DoHighlight" : "false",
                                 "@IsOuter" : "true",
                                 "@NoDataPosition" : "After",
                                 "@Id" : "Legend0",
                                 "@TextHorizontalAlignment" : "Left",
                                 "@IncludeEquals" : "true",
                                 "@IsOverlap" : "false",
                                 "@ColumnCount" : "1",
                                 "@Padding" : "6.00000 6.00000 6.00000 6.00000",
                                 "@VerticalAlignment" : "Top",
                                 "@ContentAlignment" : "Center",
                                 "@Margin" : "0.00000 0.00000 0.00000 0.00000",
                                 "@ItemsOrder" : "LeftToRight",
                                 "Style" : 
                                  {
                                   "Release" : 
                                    {
                                     "Font" : 
                                      {
                                       "@IsItalic" : "false",
                                       "@IsUnderline" : "false",
                                       "@FontFamily" : "Calibri",
                                       "@Size" : "12.00000",
                                       "@IsBold" : "false",
                                       "@Color" : "#FF505050"
                                      },
                                     "Background" : 
                                      {
                                       "@PPType" : "PP.SolidColorBrush",
                                       "@Opacity" : "1.00000",
                                       "@Color" : "#EFEFEF"
                                      }
                                    }
                                  },
                                 "EqualFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "MarkerImage" : 
                                  {
                                   "@ResourceId" : "TRANSPARENT"
                                  },
                                 "MarkerImageMask" : 
                                  {
                                   "@ResourceId" : "TEXTCOLORLEGENDICON"
                                  },
                                 "GreaterFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "LessFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "BetweenFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "NoDataText" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "Header" : 
                                  {
                                   "@Padding" : "0.00000 0.00000 0.00000 0.00000",
                                   "@IsVisible" : "true",
                                   "@NoDataText" : "",
                                   "@TextWrapping" : "WrapWithEllipsis",
                                   "@Margin" : "0.00000 0.00000 0.00000 11.00000",
                                   "@Alignment" : "Center",
                                   "Style" : 
                                    {
                                     "Release" : 
                                      {
                                       "Font" : 
                                        {
                                         "@IsItalic" : "false",
                                         "@IsUnderline" : "false",
                                         "@FontFamily" : "Calibri",
                                         "@Size" : "12.00000",
                                         "@IsBold" : "false",
                                         "@Color" : "#FF505050"
                                        }
                                      }
                                    },
                                   "MaskText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "NoDataText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "Text" : 
                                    {
                                     "@IsAuto" : "true"
                                    }
                                  }
                                },
                               "Legend1" : 
                                {
                                 "@MinValue" : "0.00000",
                                 "@Type" : "Size",
                                 "@Marker" : "Custom",
                                 "@MaxValue" : "0.00000",
                                 "@IsOverlap" : "false",
                                 "@Padding" : "6.00000 6.00000 6.00000 6.00000",
                                 "@Visibility" : "Visible",
                                 "@HorizontalAlignment" : "Right",
                                 "@Format" : "",
                                 "@VerticalAlignment" : "Top",
                                 "@TextSpacing" : "10.00000",
                                 "@IsOuter" : "true",
                                 "@Id" : "Legend1",
                                 "@Margin" : "0.00000 0.00000 0.00000 0.00000",
                                 "Style" : 
                                  {
                                   "Release" : 
                                    {
                                     "Font" : 
                                      {
                                       "@IsItalic" : "false",
                                       "@IsUnderline" : "false",
                                       "@FontFamily" : "Calibri",
                                       "@Size" : "12.00000",
                                       "@IsBold" : "false",
                                       "@Color" : "#FF505050"
                                      },
                                     "Background" : 
                                      {
                                       "@PPType" : "PP.SolidColorBrush",
                                       "@Opacity" : "1.00000",
                                       "@Color" : "#EFEFEF"
                                      }
                                    }
                                  },
                                 "MaxValueFormat" : 
                                  {
                                   "@IsAuto" : "false",
                                   "@Value" : "{0:0.00}"
                                  },
                                 "MinValueFormat" : 
                                  {
                                   "@IsAuto" : "false",
                                   "@Value" : "{0:0.00}"
                                  },
                                 "MinMarkerImage" : 
                                  {
                                   "@Width" : "32",
                                   "@Source" : "data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAACHSURBVFhH7ZHBCYAwEASvBWvJX1DSQlqwBVuwBVuwJ1uwBd2Vi4gvQbzXDiwx62P0zoQQQogvtF2\/IatfY4E4U47sSPI6DkhnZEIWnl7HASnHn5CBz17HAGGpUpwNwjXk82UEkHH8lN4TswaI+Mccf\/GK3cjOr\/9C8VOGe13D9VFCCCHEO8wOnREwX6ApumAAAAAASUVORK5CYII=",
                                   "@Height" : "32"
                                  },
                                 "MaxMarkerImage" : 
                                  {
                                   "@Width" : "32",
                                   "@Source" : "data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAFQSURBVFhH7Zb9DYIwEMVZwRVcwf9NNK7ACqzACqzgCq7gCqzACqygv5KredaPtNCamPCSC3C9vgd37ZVqxYq\/xP5wbLGbWG1DvwGCY\/ACVxsqD8ROgbi3rYWUBUJnEdX71kLKAZEN5tN\/xTQbvYWVAyKNCE5fzFXXw24KLAUELiI21ZxrJ75uCiwByF36vdAj3dxrGQZz5wfkuvefFhzPWoaTufMC4l5EnrYcz1qGs7nzwQmKwMtqx6dlcNnY2FAeQPgx\/R74tQx5WzOEg5C\/3Wr4tQwXcy8HZFHNJohzlqcMEOmXfW23jGsZ8rTmgDTFlrdmSOqANNWWnZAQaOuNSilx2i\/ml4HJ2nqdRS0q4nTLzm\/NTNaTL3pbERu++LzWzER33nuSxtxRIF5Ll35CMklbb3JrJV6zN5o7HkzS1Z98uDBH\/5yc\/eZ\/ccUfoqru\/Rsv7haParsAAAAASUVORK5CYII=",
                                   "@Height" : "32"
                                  },
                                 "Header" : 
                                  {
                                   "@Padding" : "0.00000 0.00000 0.00000 0.00000",
                                   "@IsVisible" : "true",
                                   "@NoDataText" : "",
                                   "@TextWrapping" : "WrapWithEllipsis",
                                   "@Margin" : "0.00000 0.00000 0.00000 11.00000",
                                   "@Alignment" : "Center",
                                   "Style" : 
                                    {
                                     "Release" : 
                                      {
                                       "Font" : 
                                        {
                                         "@IsItalic" : "false",
                                         "@IsUnderline" : "false",
                                         "@FontFamily" : "Calibri",
                                         "@Size" : "12.00000",
                                         "@IsBold" : "false",
                                         "@Color" : "#FF505050"
                                        }
                                      }
                                    },
                                   "MaskText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "NoDataText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "Text" : 
                                    {
                                     "@IsAuto" : "true"
                                    }
                                  }
                                },
                               "Legend2" : 
                                {
                                 "@Marker" : "Rectangle",
                                 "@Type" : "Intervals",
                                 "@AutoColumnsCount" : "true",
                                 "@ColorApplying" : "Marker",
                                 "@NoDataVisible" : "true",
                                 "@CellSpacing" : "5.00000 5.00000",
                                 "@Mode" : "LessGreater",
                                 "@Visibility" : "Visible",
                                 "@HoverMode" : "MouseOver",
                                 "@HorizontalAlignment" : "Right",
                                 "@Format" : "",
                                 "@TextSpacing" : "3.00000",
                                 "@DoHighlight" : "false",
                                 "@IsOuter" : "true",
                                 "@NoDataPosition" : "After",
                                 "@Id" : "Legend2",
                                 "@TextHorizontalAlignment" : "Left",
                                 "@IncludeEquals" : "true",
                                 "@IsOverlap" : "false",
                                 "@ColumnCount" : "1",
                                 "@Padding" : "6.00000 6.00000 6.00000 6.00000",
                                 "@VerticalAlignment" : "Top",
                                 "@ContentAlignment" : "Center",
                                 "@Margin" : "0.00000 0.00000 0.00000 0.00000",
                                 "@ItemsOrder" : "LeftToRight",
                                 "Style" : 
                                  {
                                   "Release" : 
                                    {
                                     "Font" : 
                                      {
                                       "@IsItalic" : "false",
                                       "@IsUnderline" : "false",
                                       "@FontFamily" : "Calibri",
                                       "@Size" : "12.00000",
                                       "@IsBold" : "false",
                                       "@Color" : "#FF505050"
                                      },
                                     "Background" : 
                                      {
                                       "@PPType" : "PP.SolidColorBrush",
                                       "@Opacity" : "1.00000",
                                       "@Color" : "#EFEFEF"
                                      }
                                    }
                                  },
                                 "EqualFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "GreaterFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "LessFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "BetweenFormat" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "NoDataText" : 
                                  {
                                   "@IsAuto" : "true"
                                  },
                                 "Header" : 
                                  {
                                   "@Padding" : "0.00000 0.00000 0.00000 0.00000",
                                   "@IsVisible" : "true",
                                   "@NoDataText" : "",
                                   "@TextWrapping" : "WrapWithEllipsis",
                                   "@Margin" : "0.00000 0.00000 0.00000 11.00000",
                                   "@Alignment" : "Center",
                                   "Style" : 
                                    {
                                     "Release" : 
                                      {
                                       "Font" : 
                                        {
                                         "@IsItalic" : "false",
                                         "@IsUnderline" : "false",
                                         "@FontFamily" : "Calibri",
                                         "@Size" : "12.00000",
                                         "@IsBold" : "false",
                                         "@Color" : "#FF505050"
                                        }
                                      }
                                    },
                                   "MaskText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "NoDataText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "Text" : 
                                    {
                                     "@IsAuto" : "true"
                                    }
                                  }
                                },
                               "Legend3" : 
                                {
                                 "@MinValue" : "6.00000",
                                 "@Type" : "Size",
                                 "@Marker" : "Custom",
                                 "@MaxValue" : "18.00000",
                                 "@IsOverlap" : "false",
                                 "@Padding" : "6.00000 6.00000 6.00000 6.00000",
                                 "@Visibility" : "Visible",
                                 "@HorizontalAlignment" : "Center",
                                 "@Format" : "# ##0,00",
                                 "@VerticalAlignment" : "Center",
                                 "@TextSpacing" : "10.00000",
                                 "@IsOuter" : "true",
                                 "@Id" : "Legend3",
                                 "@Margin" : "0.00000 0.00000 0.00000 0.00000",
                                 "Style" : 
                                  {
                                   "Release" : 
                                    {
                                     "Font" : 
                                      {
                                       "@IsItalic" : "false",
                                       "@IsUnderline" : "false",
                                       "@FontFamily" : "Calibri",
                                       "@Size" : "12.00000",
                                       "@IsBold" : "false",
                                       "@Color" : "#FF505050"
                                      },
                                     "Background" : 
                                      {
                                       "@PPType" : "PP.SolidColorBrush",
                                       "@Opacity" : "1.00000",
                                       "@Color" : "#EFEFEF"
                                      }
                                    }
                                  },
                                 "MaxValueFormat" : 
                                  {
                                   "@IsAuto" : "false",
                                   "@Value" : "18,00"
                                  },
                                 "MinValueFormat" : 
                                  {
                                   "@IsAuto" : "false",
                                   "@Value" : "6,00"
                                  },
                                 "MinMarkerImage" : 
                                  {
                                   "@Width" : "32",
                                   "@Source" : "data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAEBSURBVFhHxZMxD8FQFIX9PgmrsAqTRGIWk0FYxY4ZiwU7Ozs\/oIOx4+W85MojZ6rnGL6092t77+ltWjKzv0KlEiqVUKmESiVUKqFSCZVKqFRCpRIqlVCphMqY5nBzf2IFubOeMVTGoFGe54XAs5\/9PqEyxgMcjyc7Xy6WZZnNF0vb7Q\/BxzWu4\/x6u6UNgIblSjU0R5BavRGGeTCvcc90NrP+YJB+AxgO\/I2brfbbBlB3e71X0KQBMATNAVbtA3FcrTevGsNH43HYQvINYNXAzxHKv7XXwO9JFqAz2YZGBfn+N\/w1VCqhUgmVSqhUQqUSKpVQqYRKJVQqoVIJlTqs9AAV\/Pr88\/9WbQAAAABJRU5ErkJggg==",
                                   "@Height" : "32"
                                  },
                                 "MaxMarkerImage" : 
                                  {
                                   "@Width" : "32",
                                   "@Source" : "data:image\/png;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAErSURBVFhH7ZWxTgJBFEX3E\/wiEyxNoCXaEqxMTKgNFQXB1tCDtdrYKD320MMHbEG55ZP7zCRvhxuMJlwoLM7uzpk3M3dfNtnCzI4KlUqoVEKlEiqVUKmESiVUKqFSCZVKis7g9WzLZouJ2cQAVlWVFJzpAXD5D8ACTKZPdt64sNV67eP21bWPwfNLvT6fWyyXdtls+fiu16vVJvYGeP+Y+UJsEAPEmkg+h\/Cd7o0\/I0jaI\/JjB7AoD4AxNsQbxtp8DsANRyMPE2sTvw6QQGfu+\/2ay+fm80\/vAALgXpblTu1BA+D+OB77wdgDgfLavQHwIWFhAi1Nz3gjhEJrcVA6JM7F9X\/uwKE5rQC3D28uxHz\/C3A5JlQqoVIJlUqoVEKlEiqVUKmESh1WfAE6KHMXvxr0twAAAABJRU5ErkJggg==",
                                   "@Height" : "32"
                                  },
                                 "Header" : 
                                  {
                                   "@Padding" : "0.00000 0.00000 0.00000 0.00000",
                                   "@IsVisible" : "true",
                                   "@NoDataText" : "",
                                   "@TextWrapping" : "WrapWithEllipsis",
                                   "@Margin" : "0.00000 0.00000 0.00000 11.00000",
                                   "@Alignment" : "Center",
                                   "Style" : 
                                    {
                                     "Release" : 
                                      {
                                       "Font" : 
                                        {
                                         "@IsItalic" : "false",
                                         "@IsUnderline" : "false",
                                         "@FontFamily" : "Calibri",
                                         "@Size" : "12.00000",
                                         "@IsBold" : "false",
                                         "@Color" : "#FF505050"
                                        }
                                      }
                                    },
                                   "MaskText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "NoDataText" : 
                                    {
                                     "@IsAuto" : "true"
                                    },
                                   "Text" : 
                                    {
                                     "@IsAuto" : "false",
                                     "@Value" : "Value: "
                                    }
                                  }
                                }
                              }
                            },
                           "legendAssignment" : 
                            {
                             "it" : 
                              [
                                {
                                 "Key" : "Value",
                                 "Value" : 
                                  {
                                   "index" : "3",
                                   "id" : "Legend3"
                                  }
                                },
                                {
                                 "Key" : "BackgroundColor",
                                 "Value" : 
                                  {
                                   "index" : "2",
                                   "id" : "Legend2"
                                  }
                                },
                                {
                                 "Key" : "FontColor",
                                 "Value" : 
                                  {
                                   "index" : "0",
                                   "id" : "Legend0"
                                  }
                                },
                                {
                                 "Key" : "FontSize",
                                 "Value" : 
                                  {
                                   "index" : "1",
                                   "id" : "Legend1"
                                  }
                                }
                              ]
                            }
                          },
                         "hyperlinksAsText" : "0",
                         "footnotesOptions" : 
                          {
                           "position" : "None",
                           "percentWidth" : "-1",
                           "percentHeight" : "-1"
                          },
                         "highlightEvaluatedCells" : "0"
                        },
                       "windowsPosition" : "Vertical",
                       "hasPivot" : "0"
                      }
                    }
                  }
                }
              },
             "userRPath" : "",
             "isRExist" : "0"
            },
           "suppressEmptyFilter" : 
            {
             "suppressEmpty" : "0",
             "suppressEmptyArea" : "SerieBounds"
            },
           "readOnly" : "0",
           "variableTestUseR" : "0",
           "calculateIdentOnFact" : "0"
          },
         "useScenarios" : "0",
         "readOnly" : "0"
        }
      }
    }
  }
}
public static LnSerie GetMsOpenVar(MsId ms, uint modelKey, MsModel eq)
{
// Get input variable
MsFormulaTransformVariable inp = eq.transform.inputs.its.GetValue(0) as MsFormulaTransformVariable;
var getMsOp = new GetMs()
{
tMs = ms,
tArg = new GetMsArg()
{ // Set data extraction pattern
pattern = new MsMdPattern()
{
item = new MsItemPattern()
{ // Specify model key
key = modelKey,
problem = new MsProblemPattern()
{
metamodel = new MsMetaModelPattern()
{ // Set visual metamodel building pattern
visualControllerPattern = new MsMetaModelVisualControllerPattern()
{
levelFormat = MsLevelFormat.Short,
useSourceName = false,
workbooks = new MsWorkbookPattern()
{
key = true,
types = new MsWorkbookType[]
{
MsWorkbookType.Variable
},
// Set internal express view extraction pattern
getEaxArg = new GetEaxMdArg()
{
pattern = new EaxMdPattern()
{
dataEditState = true,
dataSources = ListOperation.Get,
grid = true,
gridStyle = new EaxGridStylePattern()
{
all = true,
parts = new EaxGridStylePart[]
{
EaxGridStylePart.Table
}
}
}
},
// Set internal workbook extraction pattern
getWbkArg = new GetWbkMdArg()
{
pattern = new WbkMdPattern()
{
cellsTable = new WbkCellsTablePattern()
{
headers = true,
slots = new PvtSlotPattern()
{
elementKey = true,
elementName = true
},
cells = true,
emptyCells = false,
},
series = ListOperation.Get
}
}
}
}
}
}
}
},
// Set operation execution parameters
execParams = new MsMdExecParams()
{
scenarioKeys = new long[] { },
//slice = model.metamodel.visualController.freeVariables.its.GetValue(0) as MsFormulaTransformSlice,
execFillWithVariables = new MsMdExecFillWithVariables()
{
entryKeys = new long[]
{
(long)inp.k
},
scenarioKeys = new long[]
{
-1
},
}
}
}
};
// Create a proxy object for operation execution
var somClient = new SomPortTypeClient();
// Open variable
GetMsResult getMsResult = somClient.GetMs(getMsOp);
MsMd k = getMsResult.meta;
// Display variable data
MsMetaModelVisualController metaVC = getMsResult.meta.item.problemMd.metamodel.visualController;
MsWorkbook wbk = metaVC.workbooks.its.GetValue(0) as MsWorkbook;
WbkMd meta = wbk.getWbkResult.meta;
LnSerie series = meta.series.its.GetValue(0) as LnSerie;
Console.WriteLine("Variable:" + series.n);
WbkCellsTable table = meta.cellsTable;
int ar = table.cells.Length;
Console.WriteLine("Date - Value");
for (int i = 0; i <= (ar - 1); i++) {
Console.Write((table.cells.GetValue(i) as PvtTableCell).date + " - ");
Console.WriteLine((table.cells.GetValue(i) as PvtTableCell).v);
};

return series;
}

See also:

GetMs: Operation