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 extraction pattern. The response contains the workbook that includes variable data.

SOAP

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>