<?xml version="1.0" encoding="utf-8" ?>
<document caption="Формирование данных по требованиям Минфина России" version="1.0.2" CRC="3481825374" javascriptDocumentClassName="FOutlay.FDocument2" guid="GDA0FA5E90E1B460A8CE49F19E1C92A43" isDefaultExportEnabled="false">
  <rules>
    <import id="JSHandlebars" sourceFile="Scripts\handlebars-v4.0.5.js" />
    <import id="JSStageSettings" sourceFile="MainLogic\ObasStageSettings.js" />
    <import id="JSTableFieldInfo" sourceFile="MainLogic\TableFieldInfo.js" />
    <import id="JSEvents" sourceFile="MainLogic\Events.js" />
    <import id="JSTableInfo" sourceFile="MainLogic\TableInfo.js" />
    <import id="JSRROTables" sourceFile="MainLogic\RROTables.js" />
    <import id="JSSprTables" sourceFile="MainLogic\SprTables.js" />
    <import id="JSObasTableCollection" sourceFile="MainLogic\ObasTableCollection.js" />
    <import id="JSHelper" sourceFile="MainLogic\ObasHelper.js" />
    <import id="JSFormatCollection" sourceFile="MainLogic\SheetFormatCollection.js" />
    <import id="JSCommon" sourceFile="MainLogic\CommonRules.js" />
    <import id="JSSettings" sourceFile="MainLogic\DocumentSettings.js" />
    <import id="JSGroupSheet" sourceFile="MainLogic\GroupSheet.js" />
    <import id="JSBaseDocument" sourceFile="MainLogic\BaseDocumentObject.js" />
    <import id="JSTable" sourceFile="MainLogic\FOutlay\FOutlay_TableRules.js" />
    <import id="JSInterface" sourceFile="MainLogic\FOutlay\FOutlay_InterfaceRules.js" />
    <import id="JSExport" sourceFile="MainLogic\FOutlay\FOutlay_ExportRules.js" />
    <import id="JSDocument" sourceFile="MainLogic\FOutlay\FOutlay_Document.js" />
  </rules>
  <tables>
    <linkedtable id="CSR" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="KOSGU" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="FCR" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="VR" sourceFile="MainData\Spr_Main.xml"/>
    <linkedtable id="AddAnalysisIndicator" sourceFile="MainData\Spr_Main_User.xml" />
    <linkedtable id="RRO_Outlays" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_DATA" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="SELECTED_FOIV" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_Recvisits" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OfficeChiefRecvisits" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_FinanceChiefRecvisits" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_ExecutorRecvisits" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_Numbers" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_VERSIONS" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_Outlay_KOSGU" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_AddAnalysisIndicator" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_Outlay_SumByAnalyticsFilter" sourceFile="MainData\RRO_STAGE1.xml"/>
    <linkedtable id="RRO_Outlay_SumByAnalyticsGroups" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_Outlay_SumByAnalytics" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_Outlay_SumByAnalyticsPart4" sourceFile="MainData\RRO_STAGE1.xml"/>
    <linkedtable id="RRO_Outlay_SumByAnalyticsPart5xx" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_Outlay_OrgPart5xx" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RateDollarActual" sourceFile="MainData\Spr_Forms_STAGE1.xml" />
    <linkedtable id="tRateDollarActual" sourceFile="MainData\Spr_Forms_STAGE1.xml" />
    <linkedtable id="ChangeType" sourceFile="MainData\Spr_Ped.xml"/>
    <linkedtable id="Files" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="dual" sourceFile="MainData\Spr_Main.xml" />
    <table id="MainParameters" caption="Основные параметры" canAdd="false" canClear="false" canDelete="false">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="ExcelTemplate" datatype="string" size="1000" />
        <field name="OutlayType" datatype="integer" />
      </fields>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[Outlay2.xls]]></el>
          <el><![CDATA[2]]></el>
        </row>
      </data>
    </table>
    <table id="FakeDataset" readonly="true">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="Fake_AnalyticCode" datatype="string" size="11" />
        <field name="Fake_AnalyticIndicatorName" datatype="string" size="11" />
        <field name="Fake_Y1" datatype="float" precision="2" />
        <field name="Fake_Y2" datatype="float" precision="2" />
        <field name="Fake_Y3" datatype="float" precision="2" />
        <field name="Fake_Y4" datatype="float" precision="2" />
        <field name="Fake_Usd_Y1" datatype="float" precision="5" />
        <field name="Fake_Usd_Y2" datatype="float" precision="5" />
        <field name="Fake_Usd_Y3" datatype="float" precision="5" />
        <field name="Fake_Usd_Y4" datatype="float" precision="5" />
        <field name="Fake_Y1_D" datatype="float" precision="2" />
        <field name="Fake_Y2_D" datatype="float" precision="2" />
        <field name="Fake_Y3_D" datatype="float" precision="2" />
        <field name="Fake_Y4_D" datatype="float" precision="2" />
        <field name="Fake_Usd_Y1_D" datatype="float" precision="5" />
        <field name="Fake_Usd_Y2_D" datatype="float" precision="5" />
        <field name="Fake_Usd_Y3_D" datatype="float" precision="5" />
        <field name="Fake_Usd_Y4_D" datatype="float" precision="5" />
        <field name="Fake_OKVCode_Y1" datatype="string" size="50" />
        <field name="Fake_OKVCode_Y2" datatype="string" size="50" />
        <field name="Fake_OKVCode_Y3" datatype="string" size="50" />
        <field name="Fake_OKVCode_Y4" datatype="string" size="50" />
      </fields>
    </table>
    <extendedtable id="Part1_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart1GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part1_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalytics" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Level" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
        <field name="AnalyticCode" />
        <field name="AnalyticIndicatorName" />
        <field name="OKV_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart1Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part2_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart2GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part2_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalytics" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Level" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
        <field name="AnalyticCode" />
        <field name="AnalyticIndicatorName" />
        <field name="OKV_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart2Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part3_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart3GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part3_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalytics" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Level" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
        <field name="AnalyticCode" />
        <field name="AnalyticIndicatorName" />
        <field name="OKV_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart3Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part4_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart4GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part4_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalyticsPart4" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Level" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
        <field name="AnalyticCode" />
        <field name="AnalyticIndicatorName" />
        <field name="OKV_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart4Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp1_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp1GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp1_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalytics" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Level" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
        <field name="AnalyticCode" />
        <field name="AnalyticIndicatorName" />
        <field name="OKV_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp1Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp2_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp2GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp2_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalytics" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Level" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
        <field name="AnalyticCode" />
        <field name="AnalyticIndicatorName" />
        <field name="OKV_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp2Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp3p1_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp3p1GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp3p1_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalyticsPart5xx" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp3p1Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp3p2_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp3p2GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp3p2_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalyticsPart5xx" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp3p2Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp3p3_Outlay_SumByAnalyticsGroups" tables="RRO_Outlay_SumByAnalyticsGroups" keys="Key">
    <fields>
      <field name="FCRCodeSection" datatype="string" size="2"/>
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp3p3GroupData" event="OnLoad"/>
      </rules>
    </extendedtable>
    <extendedtable id="Part5sp3p3_Outlay_SumByAnalytics" tables="RRO_Outlay_SumByAnalyticsPart5xx" keys="Key">
      <fields>
        <field name="FCRCodeSection" />
        <field name="Y1" />
        <field name="Y2" />
        <field name="Y3" />
        <field name="Y4" />
        <field name="Y1_D" />
        <field name="Y2_D" />
        <field name="Y3_D" />
        <field name="Y4_D" />
        <field name="FCR_CodeSection" />
        <field name="FCR_CodeSubSection" />
        <field name="CSR_Code" />
        <field name="VR_Code" />
      </fields>
      <rules>
        <rule name="%Doc%.TableRules.FilterPart5sp3p3Data" event="OnLoad"/>
      </rules>
    </extendedtable>
    <table id="DollarData" caption="Описание иностранной валюты" canAdd="false" canClear="false" canDelete="false">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="Name" datatype="string" size="100" />
        <field name="OKV_Code" datatype="string" size="3" />
      </fields>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[Доллар США]]></el>
          <el><![CDATA[840]]></el>
        </row>
      </data>
    </table>
  </tables>
  <sheets>
    <gridsheet title="Раздел 1" name="Sheet_R1" caption="Итоговые показатели бюджетной сметы" isShowColumnNumbers="true">
      <view table="Part1_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part1_Outlay_SumByAnalytics" readonly="true" masterKeys="FCRCodeSection" detailKeys="Part1_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" />
          </view>
          <view table="FakeDataset">
            <col width="110" readonly="true" caption="Код аналитического показателя (КОСГУ)" name="Fake_AnalyticCode" align="center" valign="center" />
            <template>
              <view caption="Сумма на {caption} год">
                <col width="120" readonly="true" caption="в рублях,&#xA;(в рублевом эквиваленте)" name="Fake_Y{fieldName}_D" align="right" valign="center" displayFormat=",0.00" />
                <col width="90" readonly="true" caption="в валюте" name="Fake_Usd_Y{fieldName}" align="right" valign="center" displayFormat=",0.00000" />
                <col width="90" readonly="true" caption="код валюты&#xA;по ОКВ" name="Fake_OKVCode_Y{fieldName}" align="center" valign="center" />
              </view>
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption"/>
              </rules>
            </template>
          </view>
          <template>
            <col name="AnalyticCode" columnName="Fake_AnalyticCode" readonly="true" />
            <col name="Y{fieldName}_D" columnName="Fake_Y{columnName}_D" readonly="true" />
            <col name="OKV_Code" columnName="Fake_OKVCode_Y{columnName}" readonly="true" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
            </rules>
          </template>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P1GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 2" name="Sheet_R2" caption="Расходы на обеспечение деятельности учреждения" isShowColumnNumbers="true">
      <view table="Part2_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part2_Outlay_SumByAnalytics" readonly="true" masterKeys="FCRCodeSection" detailKeys="Part2_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <col width="250" readonly="true" caption="Наименование показателя" name="AnalyticIndicatorName" align="left" valign="center" />
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" />
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" />
          </view>
          <view table="FakeDataset">
            <col width="110" readonly="true" caption="Код аналитического показателя (КОСГУ)" name="Fake_AnalyticCode" align="center" valign="center" />
            <template>
              <view caption="Сумма на {caption} год">
                <col width="120" readonly="true" caption="в рублях,&#xA;(в рублевом эквиваленте)" name="Fake_Y{fieldName}_D" align="right" valign="center" displayFormat=",0.00" />
                <col width="90" readonly="true" caption="в валюте" name="Fake_Usd_Y{fieldName}" align="right" valign="center" displayFormat=",0.00000" />
                <col width="90" readonly="true" caption="код валюты&#xA;по ОКВ" name="Fake_OKVCode_Y{fieldName}" align="center" valign="center" />
              </view>
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption"/>
              </rules>
            </template>
          </view>
          <template>
            <col name="AnalyticCode" columnName="Fake_AnalyticCode" readonly="true" />
            <col name="Y{fieldName}_D" columnName="Fake_Y{columnName}_D" readonly="true" />
            <col name="OKV_Code" columnName="Fake_OKVCode_Y{columnName}" readonly="true" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
            </rules>
          </template>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P2GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 3" name="Sheet_R3" caption="Расходы на предоставление бюджетных инвестиций, субсидий, субвенций и иных межбюджетных трансфертов" isShowColumnNumbers="true">
      <view table="Part3_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part3_Outlay_SumByAnalytics" readonly="true" masterKeys="FCRCodeSection" detailKeys="Part3_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <col width="250" readonly="true" caption="Наименование показателя" name="AnalyticIndicatorName" align="left" valign="center" />
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" />
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" />
          </view>
          <view table="FakeDataset">
            <col width="110" readonly="true" caption="Код аналитического показателя (КОСГУ)" name="Fake_AnalyticCode" align="center" valign="center" />
            <template>
              <view caption="Сумма на {caption} год">
                <col width="120" readonly="true" caption="в рублях,&#xA;(в рублевом эквиваленте)" name="Fake_Y{fieldName}_D" align="right" valign="center" displayFormat=",0.00" />
                <col width="90" readonly="true" caption="в валюте" name="Fake_Usd_Y{fieldName}" align="right" valign="center" displayFormat=",0.00000" />
                <col width="90" readonly="true" caption="код валюты&#xA;по ОКВ" name="Fake_OKVCode_Y{fieldName}" align="center" valign="center" />
              </view>
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption"/>
              </rules>
            </template>
          </view>
          <template>
            <col name="AnalyticCode" columnName="Fake_AnalyticCode" readonly="true" />
            <col name="Y{fieldName}_D" columnName="Fake_Y{columnName}_D" readonly="true" />
            <col name="OKV_Code" columnName="Fake_OKVCode_Y{columnName}" readonly="true" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
            </rules>
          </template>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P3GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 4" name="Sheet_R4" caption="Расходы на закупку в пользу третьих лиц" isShowColumnNumbers="true">
      <view table="Part4_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part4_Outlay_SumByAnalytics" readonly="true" masterKeys="FCRCodeSection" detailKeys="Part4_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <col width="250" readonly="true" caption="Наименование показателя" name="AnalyticIndicatorName" align="left" valign="center" />
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" />
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" />
          </view>
          <view table="FakeDataset">
            <col width="110" readonly="true" caption="Код аналитического показателя (КОСГУ)" name="Fake_AnalyticCode" align="center" valign="center" />
            <template>
              <view caption="Сумма на {caption} год">
                <col width="120" readonly="true" caption="в рублях,&#xA;(в рублевом эквиваленте)" name="Fake_Y{fieldName}_D" align="right" valign="center" displayFormat=",0.00" />
                <col width="90" readonly="true" caption="в валюте" name="Fake_Usd_Y{fieldName}" align="right" valign="center" displayFormat=",0.00000" />
                <col width="90" readonly="true" caption="код валюты&#xA;по ОКВ" name="Fake_OKVCode_Y{fieldName}" align="center" valign="center" />
              </view>
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption"/>
              </rules>
            </template>
          </view>
          <template>
            <col name="AnalyticCode" columnName="Fake_AnalyticCode" readonly="true" />
            <col name="Y{fieldName}_D" columnName="Fake_Y{columnName}_D" readonly="true" />
            <col name="OKV_Code" columnName="Fake_OKVCode_Y{columnName}" readonly="true" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
            </rules>
          </template>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true"/>
      <rules>
        <rule name="%Doc%.P4GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <groupsheet name="R5_Group" caption="Раздел 5" />
    <gridsheet title="Раздел 5.1" name="Sheet_R5_1" groupSheet="R5_Group" caption="5. Иные сведения о расходах учреждения&#xA;5.1. Планируемые расходы по дополнительному финансированию" isShowColumnNumbers="true">
      <view table="Part5sp1_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part5sp1_Outlay_SumByAnalytics" readonly="true" masterKeys="FCRCodeSection" detailKeys="Part5sp1_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <col width="250" readonly="true" caption="Наименование показателя" name="AnalyticIndicatorName" align="left" valign="center" />
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" />
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" />
          </view>
          <view table="FakeDataset">
            <col width="110" readonly="true" caption="Код аналитического показателя (КОСГУ)" name="Fake_AnalyticCode" align="center" valign="center" />
            <template>
              <view caption="Сумма на {caption} год">
                <col width="120" readonly="true" caption="в рублях,&#xA;(в рублевом эквиваленте)" name="Fake_Y{fieldName}_D" align="right" valign="center" displayFormat=",0.00" />
                <col width="90" readonly="true" caption="в валюте" name="Fake_Usd_Y{fieldName}" align="right" valign="center" displayFormat=",0.00000" />
                <col width="90" readonly="true" caption="код валюты&#xA;по ОКВ" name="Fake_OKVCode_Y{fieldName}" align="center" valign="center" />
              </view>
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption"/>
              </rules>
            </template>
          </view>
          <template>
            <col name="AnalyticCode" columnName="Fake_AnalyticCode" readonly="true" />
            <col name="Y{fieldName}_D" columnName="Fake_Y{columnName}_D" readonly="true" />
            <col name="OKV_Code" columnName="Fake_OKVCode_Y{columnName}" readonly="true" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
            </rules>
          </template>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <rules>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 5.2" name="Sheet_R5_2" groupSheet="R5_Group" caption="5. Иные сведения о расходах учреждения&#xA;5.2. Расходы учреждения по исполнению ПНО за счет БА" isShowColumnNumbers="true">
      <view table="Part5sp2_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part5sp2_Outlay_SumByAnalytics" readonly="true" masterKeys="FCRCodeSection" detailKeys="Part5sp2_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <col width="250" readonly="true" caption="Наименование показателя" name="AnalyticIndicatorName" align="left" valign="center" />
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" />
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" />
          </view>
          <view table="FakeDataset">
            <col width="110" readonly="true" caption="Код аналитического показателя (КОСГУ)" name="Fake_AnalyticCode" align="center" valign="center" />
            <template>
              <view caption="Сумма на {caption} год">
                <col width="120" readonly="true" caption="в рублях,&#xA;(в рублевом эквиваленте)" name="Fake_Y{fieldName}_D" align="right" valign="center" displayFormat=",0.00" />
                <col width="90" readonly="true" caption="в валюте" name="Fake_Usd_Y{fieldName}" align="right" valign="center" displayFormat=",0.00000" />
                <col width="90" readonly="true" caption="код валюты&#xA;по ОКВ" name="Fake_OKVCode_Y{fieldName}" align="center" valign="center" />
              </view>
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption"/>
              </rules>
            </template>
          </view>
          <template>
            <col name="AnalyticCode" columnName="Fake_AnalyticCode" readonly="true" />
            <col name="Y{fieldName}_D" columnName="Fake_Y{columnName}_D" readonly="true" />
            <col name="OKV_Code" columnName="Fake_OKVCode_Y{columnName}" readonly="true" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange"/>
            </rules>
          </template>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P5sp2GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 5.3.1" name="Sheet_R5_3_1" groupSheet="R5_Group" caption="5. Иные сведения о расходах учреждения&#xA;5.3.1. Расходы учреждения по исполнению ПО перед физ. лицом, полномочия по осуществлению которых переданы ФБУ/ФАУ" isShowColumnNumbers="true">
      <view table="Part5sp3p1_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part5sp3p1_Outlay_SumByAnalytics" masterKeys="FCRCodeSection" detailKeys="Part5sp3p1_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" isMergeCells="true" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" isMergeCells="true" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" isMergeCells="true" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" isMergeCells="true" />
          </view>
          <view caption="Сумма">
            <col width="120" name="Y1_D" caption="на 2019 год" align="right" displayFormat=",0.00" readonly="true" isMergeCells="true" />
            <col width="120" name="Y2_D" caption="на 2020 год" align="right" displayFormat=",0.00" readonly="true" isMergeCells="true" />
            <col width="120" name="Y3_D" caption="на 2021 год" align="right" displayFormat=",0.00" readonly="true" isMergeCells="true" />
          </view>
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" isMergeCells="true" />
          <view table="RRO_Outlay_SumByAnalyticsPart5xx" masterKeys="Key" detailKeys="Part5sp3p1_Outlay_SumByAnalytics.Key">
            <view table="RRO_Outlay_OrgPart5xx" masterKeys="OwnerKey" detailKeys="RRO_Outlay_SumByAnalyticsPart5xx.Key">
              <col width="300" readonly="true" caption="Наименование федерального бюджетного (автономного) учреждения" name="OrgName" align="left" valign="center" />
              <col width="120" readonly="true" caption="Код по Сводному Реестру" name="OrgCode" align="center" valign="center" />
              <view caption="Реквизиты документа о передаче бюджетных полномочий">
                <col width="110" readonly="true" caption="номер" name="DocNum" align="center" valign="center" />
                <col width="110" readonly="true" caption="дата" name="DocDate" align="center" valign="center" />
              </view>
            </view>
          </view>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P5sp3p1GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 5.3.2" name="Sheet_R5_3_2" groupSheet="R5_Group" caption="5. Иные сведения о расходах учреждения&#xA;5.3.2. Расходы на закупки" isShowColumnNumbers="true">
      <view table="Part5sp3p2_Outlay_SumByAnalyticsGroups" readonly="true">
        <view table="Part5sp3p2_Outlay_SumByAnalytics" masterKeys="FCRCodeSection" detailKeys="Part5sp3p2_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" isMergeCells="true" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" isMergeCells="true" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" isMergeCells="true" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" isMergeCells="true" />
          </view>
          <view caption="Сумма">
            <col width="120" name="Y1_D" caption="на 2019 год" align="right" displayFormat=",0.00" readonly="false" isMergeCells="true" />
            <col width="120" name="Y2_D" caption="на 2020 год" align="right" displayFormat=",0.00" readonly="false" isMergeCells="true" />
            <col width="120" name="Y3_D" caption="на 2021 год" align="right" displayFormat=",0.00" readonly="false" isMergeCells="true" />
          </view>
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" isMergeCells="true" />
          <view table="RRO_Outlay_SumByAnalyticsPart5xx" masterKeys="Key" detailKeys="Part5sp3p2_Outlay_SumByAnalytics.Key">
            <view table="RRO_Outlay_OrgPart5xx" masterKeys="OwnerKey" detailKeys="RRO_Outlay_SumByAnalyticsPart5xx.Key">
              <col width="300" readonly="true" caption="Наименование федерального бюджетного (автономного) учреждения" name="OrgName" align="left" valign="center" />
              <col width="120" readonly="true" caption="Код по Сводному Реестру" name="OrgCode" align="center" valign="center" />
              <view caption="Реквизиты документа о передаче бюджетных полномочий">
                <col width="110" readonly="true" caption="номер" name="DocNum" align="center" valign="center" />
                <col width="110" readonly="true" caption="дата" name="DocDate" align="center" valign="center" />
              </view>
            </view>
          </view>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P5sp3p2GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 5.3.3" name="Sheet_R5_3_3" groupSheet="R5_Group" caption="5. Иные сведения о расходах учреждения&#xA;5.3.3. Расходы по субсидиям" isShowColumnNumbers="true">
      <view table="Part5sp3p3_Outlay_SumByAnalyticsGroups">
        <view table="Part5sp3p3_Outlay_SumByAnalytics" masterKeys="FCRCodeSection" detailKeys="Part5sp3p3_Outlay_SumByAnalyticsGroups.FCRCodeSection">
          <view caption="Код по бюджетной классификации Российской Федерации">
            <col width="80" readonly="true" caption="раздела" name="FCR_CodeSection" align="center" valign="center" isMergeCells="true" />
            <col width="80" readonly="true" caption="подраздела" name="FCR_CodeSubSection" align="center" valign="center" isMergeCells="true" />
            <col width="150" readonly="true" caption="целевой статьи" name="CSR_Code" align="center" valign="center" isMergeCells="true" />
            <col width="100" readonly="true" caption="вида расходов" name="VR_CODE" align="center" valign="center" isMergeCells="true" />
          </view>
          <view caption="Сумма">
            <col width="120" name="Y1_D" caption="на 2019 год" align="right" displayFormat=",0.00" readonly="true" isMergeCells="true" />
            <col width="120" name="Y2_D" caption="на 2020 год" align="right" displayFormat=",0.00" readonly="true" isMergeCells="true" />
            <col width="120" name="Y3_D" caption="на 2021 год" align="right" displayFormat=",0.00" readonly="true" isMergeCells="true" />
          </view>
          <col width="60" readonly="true" caption="Код строки" name="FCRCodeSection" align="center" valign="center" isMergeCells="true" />
          <view table="RRO_Outlay_SumByAnalyticsPart5xx" masterKeys="Key" detailKeys="Part5sp3p3_Outlay_SumByAnalytics.Key">
            <view table="RRO_Outlay_OrgPart5xx" masterKeys="OwnerKey" detailKeys="RRO_Outlay_SumByAnalyticsPart5xx.Key">
              <col width="300" readonly="true" caption="Наименование территориального органа Федерального казначейства" name="OrgName" align="left" valign="center" />
              <col width="120" readonly="true" caption="Код ТОФК" name="OrgCode" align="center" valign="center" />
              <view caption="Реквизиты документа о передаче бюджетных полномочий">
                <col width="110" readonly="true" caption="номер" name="DocNum" align="center" valign="center" />
                <col width="110" readonly="true" caption="дата" name="DocDate" align="center" valign="center" />
              </view>
            </view>
          </view>
        </view>
        <view table="dual" readonly="true" />
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P5sp3p3GroupSheet.CalcEventHandler" event="OnCalc"/>
      </rules>
    </gridsheet>
    <gridsheet title="Раздел 6" name="Sheet_R6" caption="СПРАВОЧНО: Курс иностранной валюты к рублю Российской Федерации" isShowColumnNumbers="true">
      <view table="tRateDollarActual" readonly="true">
        <view table="DollarData" readonly="true">
          <view caption="Валюта">
            <col width="200" readonly="true" name="Name" caption="наименование" align="left" valign="center" />
            <col width="100" readonly="true" name="OKV_Code" caption="код по ОКВ" align="center" valign="center" />
          </view>
        </view>
        <template>
          <col width="150" name="Val{fieldName}" caption="на {caption} год" align="right" displayFormat=",0.00" readonly="true" />
          <rules>
            <rule name="%Doc%.CommonRules.GetDollarRateYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
            <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption" />
          </rules>
        </template>
      </view>
    </gridsheet>
    <rules>
    </rules>
  </sheets>
</document>