<?xml version="1.0" encoding="utf-8"?>
<document caption="Формирование данных по требованиям Минфина России" version="1.0.7" CRC="3481825374" javascriptDocumentClassName="F05325.FDocument">
  <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="JSBaseDocument" sourceFile="MainLogic\BaseDocumentObject.js" />
    <import id="JSObasTableWithKeys" sourceFile="MainLogic\ObasTableWithKeys.js" />
    <import id="JSSingleSheet" sourceFile="MainLogic\SingleSheet.js" />
    <import id="JSGroupSheet" sourceFile="MainLogic\GroupSheet.js" />
    <import id="JSSubsidiesInterface" sourceFile="MainLogic\FSubsidiesSubventions\FSubsidiesSubvetionsSheet.js" />
    <import id="JSSubsidiesTable" sourceFile="MainLogic\FSubsidiesSubventions\FSubsidiesSubvetionsTable.js" />
    <import id="JSExport" sourceFile="Templates\Logic\Current\F05_325\F05_325_ExportRules.js" />
    <import id="JSInterface" sourceFile="Templates\Logic\Current\F05_325\F05_325_InterfaceRules.js" />
    <import id="JSTable" sourceFile="Templates\Logic\Current\F05_325\F05_325_TableRules.js" />
    <import id="JSUpdate" sourceFile="Templates\Logic\Current\F05_325\F05_325_UpdateRules.js" />
    <import id="JSDocument" sourceFile="Templates\Logic\Current\F05_325\F05_325_Document.js" />
  </rules>
  <tables>
    <!-- Справочники из файла Spr_Main.xml-->
    <linkedtable id="FOIV" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="FCR" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="CSR" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="Program" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="SubProgram" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="DirectionCost" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="VR" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="MainAction" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="OBAS_SPR" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="NPAType" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="KOSGU" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="RRO_OBAS_VERSIONS" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_DATA" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_Recvisits" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_SC" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_OBAS_Numbers" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="SecurityTypes" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="ChangeType" sourceFile="MainData\Spr_Ped.xml" />
    <linkedtable id="RRO_KU_Data" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="FileType" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="BuildParams" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="RRO_Expend_Shedule" 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="SELECTED_FOIV" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="tRRO_OBAS_VERSIONS" sourceFile="MainData\RRO_STAGE1.xml" />
    <linkedtable id="Files" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="dual" sourceFile="MainData\Spr_Main.xml" />
    <linkedtable id="SubjectName" sourceFile="MainData\Spr_Forms_STAGE1.xml" />
    <table id="MainParameters" readonly="true" caption="Основные параметры" canAdd="false" canClear="false" canDelete="false">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <sourcefield name="FOIV_ID" table="FOIV" tableKeyField="Key" tableFields="Code;Name" />
        <sourcefield name="FCR_ID" table="FCR" tableKeyField="Key" tableFields="Code;Name" />
        <sourcefield name="VR_ID" table="VR" tableKeyField="Key" tableFields="Code;Name" />
        <sourcefield name="CSR_ID" table="CSR" tableKeyField="Key" tableFields="Code;Name" />
        <sourcefield name="MainAction_ID" table="MainAction" tableKeyField="Key" tableFields="Code;Name" />
        <sourcefield name="RRO_OBAS_VERSIONS_ID" table="RRO_OBAS_VERSIONS" tableKeyField="Key" tableFields="Key" />
        <sourcefield name="FileType_ID" table="FileType" tableKeyField="Key" tableFields="Key" />
        <sourcefield name="Program_ID" table="Program" tableKeyField="Key" tableFields="Key" />
        <sourcefield name="SubProgram_ID" table="SubProgram" tableKeyField="Key" tableFields="Key" />
        <sourcefield name="DirectionCost_ID" table="DirectionCost" tableKeyField="Key" tableFields="Key" />
      </fields>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
        </row>
      </data>
    </table>
    <table id="FormParameters" caption="Параметры формы" readonly="true">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="FormSecretType" datatype="integer" caption="Признак гостайны" />
        <field name="TableNameWithTotals" datatype="string" size="50" />
        <field name="TableWithKOSGU" datatype="string" size="50" />
      </fields>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[0]]></el>
          <el><![CDATA[F05_325_P1_Values]]></el>
          <el><![CDATA[KOSGU_Data]]></el>
        </row>
      </data>
    </table>
    <table id="F05_325_P1_Rows" readonly="true">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="StrCode" datatype="string" size="3" />
        <field name="Name" datatype="string" size="500" caption="Наименование" />
      </fields>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[010]]></el>
          <el><![CDATA[Субвенция  бюджетам Республики Крым и города федерального значения Севастополя на осуществление части переданных полномочий Российской Федерации в области ветеринарного и фитосанитарного надзора]]></el>
        </row>
      </data>
    </table>
    <table id="F05_325_P1_Values" caption="1. Расходы на предоставление субвенции">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="StrKey" datatype="integer" syncKey="true" />
        <field name="IsTotal" datatype="integer" syncKey="true" />
        <field name="Y1" datatype="float" size="20" precision="2" />
        <field name="Y2" datatype="float" size="20" precision="2" />
        <field name="Y3" datatype="float" size="20" precision="2" />
        <field name="Y4" datatype="float" size="20" precision="2" />
      </fields>
      <rules>
        <rule name="%Doc%.CommonRules.SaveTotalTable" event="OnSave" />
      </rules>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[0]]></el>
          <el><![CDATA[0]]></el>
          <el><![CDATA[0]]></el>
          <el><![CDATA[0]]></el>
        </row>
      </data>
    </table>
    <table id="F05_325_P2_TopRows" readonly="true">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <field name="StrCode" datatype="string" size="3" />
        <field name="Name" datatype="string" size="500" caption="Наименование" />
      </fields>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[3]]></el>
          <el><![CDATA[700]]></el>
          <el><![CDATA[Распределяемый объем]]></el>
        </row>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[2]]></el>
          <el><![CDATA[800]]></el>
          <el><![CDATA[Нераспределенный резерв]]></el>
        </row>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[900]]></el>
          <el><![CDATA[Итого]]></el>
        </row>
      </data>
    </table>
    <table id="F05_325_Subjects">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <sourcefield name="SubjectName_ID" isNull="false" caption="Наименование субъекта РФ" table="SubjectName" tableKeyField="Key" tableFields="Name" isUnique="true" />
        <lookupfield name="SubjectName_Name" lookupTable="SubjectName" keys="SubjectName_ID" lookupKeys="Key" lookupFields="Name" />
        <field name="StrCode" datatype="string" size="3" />
      </fields>
    </table>
    <table id="F05_325_P3">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <sourcefield name="OwnerKey" table="F05_325_Subjects" syncKey="true" tableKeyField="Key" tableFields="Key">
          <rules>
            <rule name="%Doc%.P3DataTable.OwnerKey.InitEventHandler" event="OnInit" />
          </rules>
        </sourcefield>
        <field name="Pay_Y1" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Pay_Y2" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Pay_Y3" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Pay_Y4" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Count_Y1" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Count_Y2" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Count_Y3" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Count_Y4" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P3DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Y1" datatype="float" precision="2" />
        <field name="Y2" datatype="float" precision="2" />
        <field name="Y3" datatype="float" precision="2" />
        <field name="Y4" datatype="float" precision="2" />
      </fields>
    </table>
    <table id="F05_325_P4">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <sourcefield name="OwnerKey" table="F05_325_Subjects" uniqueLabel="1" tableKeyField="Key" tableFields="Key">
          <rules>
            <rule name="%Doc%.P4DataTable.OwnerKey.InitEventHandler" event="OnInit" />
          </rules>
        </sourcefield>
        <field name="Year" datatype="integer" uniqueLabel="1">
          <rules>
            <rule name="%Doc%.CommonRules.YearInitEventHandler" event="OnInit" />
          </rules>
        </field>
        <field name="AveragePayment" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="TotalCost" datatype="float" precision="2" />
        <field name="CommunicationCost" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="TransportCost" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="UtilitiesCost" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="TravelCost" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="InventoryCost" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="RentCost" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Total" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P4DataTable.TotalChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="IsCopied" datatype="boolean">
          <rules>
            <rule name="ObasHelper.GetFalse" event="OnInit" />
          </rules>
        </field>
      </fields>
      <rules>
        <rule name="%Doc%.P4DataTable.EditEventHandler" event="OnEdit" />
      </rules>
    </table>
    <table id="F05_325_P5">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <sourcefield name="OwnerKey" uniqueLabel="1" table="F05_325_Subjects" tableKeyField="Key" tableFields="Key">
          <rules>
            <rule name="%Doc%.P5DataTable.OwnerKey.InitEventHandler" event="OnInit" />
          </rules>
        </sourcefield>
        <field name="Year" datatype="integer" uniqueLabel="1">
          <rules>
            <rule name="%Doc%.CommonRules.YearInitEventHandler" event="OnInit" />
          </rules>
        </field>
        <field name="ControlCount" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P5DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="ControlTime" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P5DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="LicenseCount" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P5DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="LicenseTime" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P5DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="WorkTime" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P5DataTable.TotalPartsChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="Total" datatype="float" precision="2">
          <rules>
            <rule name="%Doc%.P5DataTable.TotalChangeEventHandler" event="OnChange" />
          </rules>
        </field>
        <field name="IsCopied" datatype="boolean">
          <rules>
            <rule name="ObasHelper.GetFalse" event="OnInit" />
          </rules>
        </field>
      </fields>
      <rules>
        <rule name="%Doc%.P5DataTable.EditEventHandler" event="OnEdit" />
      </rules>
    </table>
    <table id="KOSGU_Data">
      <fields>
        <field name="Id" datatype="guid" />
        <field name="Key" datatype="integer" />
        <sourcefield name="KOSGU_Id" table="KOSGU" tableKeyField="Key" tableFields="Key" syncKey="true" />
        <field name="SrcKey" datatype="integer" isDeltaValue="false" />
        <field name="Y1" datatype="float" precision="2" />
        <field name="Y2" datatype="float" precision="2" />
        <field name="Y3" datatype="float" precision="2" />
        <field name="Y4" datatype="float" precision="2" />
      </fields>
      <rules>
        <rule name="%Doc%.CommonRules.SaveKosguTable" event="OnSave" />
      </rules>
      <data>
        <row>
          <el><![CDATA[]]></el>
          <el><![CDATA[1]]></el>
          <el><![CDATA[27561076]]></el>
          <el><![CDATA[1]]></el>
        </row>
      </data>
    </table>
  </tables>
  <sheets>
    <gridsheet name="SHT_P1" title="Раздел 1" caption="1. Расходы на предоставление субвенции" isShowColumnNumbers="true">
      <view table="F05_325_P1_Rows" readonly="true">
        <col width="500" caption="Наименование показателя" name="Name" align="left" readonly="true" />
        <view table="F05_325_P1_Values" caption="Сумма" masterKeys="StrKey" detailKeys="Key" readonly="true">
          <template>
            <col width="100" name="Y{fieldName}" caption="на {caption} год" readonly="true" align="right" displayFormat=",0.00" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
              <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption" />
            </rules>
          </template>
        </view>
      </view>
      <rules>
        <rule name="%Doc%.P1Sheet.FormatEventHandler" event="OnGetFormat" />
      </rules>
    </gridsheet>
    <gridsheet name="SHT_P2" title="Раздел 2" caption="2. Расчет расходов  на предоставление субвенции между субъектами Российской Федерации" isShowColumnNumbers="true">
      <view table="F05_325_Subjects" readonly="true">
        <col width="250" name="SubjectName_Name" align="left" readonly="true" caption="Наименование субъекта Российской Федерации" />
        <col width="50" caption="Код строки" readonly="true" name="StrCode" align="center" />
        <view table="F05_325_P3" readonly="true" caption="Объем предоставляемой субвенции">
          <template>
            <col width="100" name="Y{fieldName}" caption="на {caption} год" align="right" displayFormat=",0.00" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
              <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption" />
            </rules>
          </template>
        </view>
      </view>
      <view table="F05_325_P2_TopRows" readonly="true">
        <col name="Name" columnName="SubjectName_Name" />
        <col name="StrCode" columnName="StrCode" />
        <view table="F05_325_P1_Values" readonly="false" masterKeys="StrKey" detailKeys="F05_325_P2_TopRows.Key">
          <template>
            <col name="Y{fieldName}" columnName="Y{columnName}" />
            <rules>
              <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
            </rules>
          </template>
        </view>
      </view>
      <rules>
        <rule name="%Doc%.P2Sheet.FormatEventHandler" event="OnGetFormat" />
        <rule name="%Doc%.P2Sheet.CalcEventHandler" event="OnCalc" />
        <rule name="ObasHelper.GetFalse" event="OnCanAdd" />
        <rule name="ObasHelper.GetFalse" event="OnCanDelete" />
      </rules>
    </gridsheet>
    <gridsheet name="SHT_P3" title="Раздел 3" caption="3. Расчет расходов на предоставление субвенции" isShowColumnNumbers="true">
      <view table="F05_325_Subjects" readonly="true">
        <col width="250" name="SubjectName_Name" align="left" readonly="true" caption="Наименование субъекта Российской Федерации" />
        <col width="50" caption="Код строки" readonly="true" name="StrCode" align="center" />
        <view table="F05_325_P3" readonly="true">
          <view caption="Затраты на содержание одного сотрудника органа государственной власти субъекта Российской Федерации,&#xA;руб&#xA;(гр. 11 подразделов 4.1 - 4.4)">
            <template>
              <col width="150" name="Pay_Y{fieldName}" caption="на {caption} год" align="right" displayFormat=",0.00" />
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption" />
              </rules>
            </template>
          </view>
          <view caption="Численность сотрудников органов государственной власти, чел&#xA;(гр. 8 подразделов 5.1 - 5.4)">
            <template>
              <col width="100" name="Count_Y{fieldName}" caption="на {caption} год" align="right" displayFormat=",0.00" />
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption" />
              </rules>
            </template>
          </view>
          <view caption="Сумма, руб.">
            <template>
              <col width="100" name="Y{fieldName}" caption="на {caption} год" align="right" displayFormat=",0.00" />
              <rules>
                <rule name="%Doc%.CommonRules.GetYearsFieldRangeEventHandler" event="OnGetFieldsRange" />
                <rule name="%Doc%.CommonRules.GetYearsCaptionEventHandler" event="OnGetCaption" />
              </rules>
            </template>
          </view>
        </view>
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P3Sheet.FormatEventHandler" event="OnGetFormat" />
        <rule name="%Doc%.P3Sheet.CalcEventHandler" event="OnCalc" />
      </rules>
    </gridsheet>
    <groupsheet name="P4_Group" caption="Раздел 4" />
    <gridsheet title="Раздел 4.#Index" name="SHT_P4_Y1" groupSheet="P4_Group" caption="4.#Index. Расчет затрат на содержание одного сотрудника органа государственной власти субъекта Российской Федерации, осуществляющего переданные полномочия, на #Year год" isShowColumnNumbers="true">
      <view table="F05_325_Subjects">
        <col width="250" name="SubjectName_Name" align="left" readonly="true" caption="Наименование субъекта Российской Федерации" />
        <col width="50" caption="Код строки" readonly="true" name="StrCode" align="center" />
        <view table="F05_325_P4">
          <col width="150" name="AveragePayment" align="right" displayFormat=",0.00" readonly="false" caption="Средний размер оплаты труда сотрудника органа государственной власти субъекта Российской Федерации, руб." />
          <view caption="Иные затраты на содержание одного сотрудника органа государственной власти субъекта Российской Федерации">
            <col width="150" name="TotalCost" align="right" displayFormat=",0.00" readonly="true" caption="всего,&#xA;(гр. 5 + гр. 6 + гр. 7 + гр. 8 + гр. 9 + гр. 10)" />
            <view caption="в том числе">
              <col width="150" name="CommunicationCost" align="right" displayFormat=",0.00" readonly="false" caption="расходы на оплату услуг связи" />
              <col width="150" name="TransportCost" align="right" displayFormat=",0.00" readonly="false" caption="расходы на оплату транспортных услуг" />
              <col width="150" name="UtilitiesCost" align="right" displayFormat=",0.00" readonly="false" caption="расходы на оплату коммунальных услуг" />
              <col width="150" name="TravelCost" align="right" displayFormat=",0.00" readonly="false" caption="командировочные расходы" />
              <col width="150" name="InventoryCost" align="right" displayFormat=",0.00" readonly="false" caption="расходы на приобретение основных средств и увеличение стоимости материальных запасов" />
              <col width="150" name="RentCost" align="right" displayFormat=",0.00" readonly="false" caption="расходы на оплату аренды (содержание) помещений" />
            </view>
          </view>
          <col width="150" name="Total" align="right" displayFormat=",0.00" readonly="true" caption="Затраты на содержание одного сотрудника,&#xA;руб.&#xA;(гр. 3 + гр. 4)" />
          <rules>
            <rule name="%Doc%.P4GroupSheet.ViewLoadEventHandler" event="OnLoad" />
          </rules>
        </view>
        <editors>
          <editor id="F05_325_Subject_Editor" canAdd="true" />
        </editors>
      </view>
      <rules>
        <rule name="%Doc%.P4GroupSheet.FormatEventHandler" event="OnGetFormat" />
        <rule name="%Doc%.P4GroupSheet.CalcEventHandler" event="OnCalc" />
        <rule name="%Doc%.P4GroupSheet.ActivateSheetEventHandler" event="OnActivateSheet" />
        <rule name="%Doc%.P4GroupSheet.CreateCaptionEventHandler" event="OnCreateTitle" />
        <rule name="%Doc%.P4GroupSheet.CreateCaptionEventHandler" event="OnCreateCaption" />
        <rule name="%Doc%.P4GroupSheet.ReadOnlyEventHandler" event="OnGetIsReadOnly" />
      </rules>
    </gridsheet>
    <generatedsheet name="SHT_P4_Y2" templateSheetName="SHT_P4_Y1" />
    <generatedsheet name="SHT_P4_Y3" templateSheetName="SHT_P4_Y1" />
    <groupsheet name="P5_Group" caption="Раздел 5" />
    <gridsheet title="Раздел 5.#Index" name="SHT_P5_Y1" groupSheet="P5_Group" caption="5.#Index. Расчет численности сотрудников органов государственной власти субъектов Российской Федерации, необходимой для осуществления переданных полномочий, на #Year год" isShowColumnNumbers="true">
      <view table="F05_325_Subjects" readonly="true">
        <col width="250" name="SubjectName_Name" align="left" readonly="true" caption="Наименование субъекта Российской Федерации" />
        <col width="50" caption="Код строки" readonly="true" name="StrCode" align="center" />
        <view table="F05_325_P5" readonly="false">
          <col width="350" name="ControlCount" align="right" displayFormat=",0.00" readonly="false" caption="Количество проверок, мероприятий по контролю и административных обследований объектов земельных отношений,&#xA;ед" />
          <col width="450" name="ControlTime" align="right" displayFormat=",0.00" readonly="false" caption="Среднее время, необходимое для осуществления одной проверки, одного мероприятия по контролю, одного административного обследования объектов земельных отношений одним сотрудником,&#xA;часов" />
          <col width="550" name="LicenseCount" align="right" displayFormat=",0.00" readonly="false" caption="Количество предоставленных, переоформленных, приостановленных, возобновленных, прекращенных или аннулированных лицензий на осуществление фармацевтической деятельности в сфере обращения лекарственных средств для ветеринарного  применения, а также сведений, внесенных в реестр лицензий в субъекте Российской Федерации, ед" />
          <col width="200" name="LicenseTime" align="right" displayFormat=",0.00" readonly="false" caption="Среднее время, необходимое одному сотруднику для осуществления функций,&#xA;часов" />
          <col width="150" name="WorkTime" align="right" displayFormat=",0.00" readonly="false" caption="Норматив рабочего времени в году, часов" />
          <col width="250" name="Total" align="right" displayFormat=",0.00" readonly="true" caption="Численность сотрудников органов государственной власти, чел.&#xA;(гр. 3 * гр. 4 / гр. 7) + (гр. 5 * гр. 6) / гр. 7)" />
          <rules>
            <rule name="%Doc%.P5GroupSheet.ViewLoadEventHandler" event="OnLoad" />
          </rules>
        </view>
      </view>
      <view table="dual" readonly="true" />
      <rules>
        <rule name="%Doc%.P5GroupSheet.FormatEventHandler" event="OnGetFormat" />
        <rule name="%Doc%.P5GroupSheet.CalcEventHandler" event="OnCalc" />
        <rule name="%Doc%.P5GroupSheet.ActivateSheetEventHandler" event="OnActivateSheet" />
        <rule name="%Doc%.P5GroupSheet.CreateCaptionEventHandler" event="OnCreateTitle" />
        <rule name="%Doc%.P5GroupSheet.CreateCaptionEventHandler" event="OnCreateCaption" />
        <rule name="%Doc%.P5GroupSheet.ReadOnlyEventHandler" event="OnGetIsReadOnly" />
        <rule name="ObasHelper.GetFalse" event="OnCanAdd" />
        <rule name="ObasHelper.GetFalse" event="OnCanDelete" />
      </rules>
    </gridsheet>
    <generatedsheet name="SHT_P5_Y2" templateSheetName="SHT_P5_Y1" />
    <generatedsheet name="SHT_P5_Y3" templateSheetName="SHT_P5_Y1" />
    <rules>
      <rule name="%Doc%.CommonRules.GetExcelFileName" event="OnGetExportFileName" />
      <rule name="%Doc%.CommonRules.GetExcelTemplateFileName" event="OnGetTemplateFileName" />
      <rule name="%Doc%.UpdateRules.UpdateTemplate" event="OnUpdateTemplate" />
      <rule name="%Doc%.CommonRules.CheckChangeType" event="OnBeforeDocumentSave" />
      <rule name="%Doc%.CommonRules.KosguDocumentSaveEventHandler" event="OnDocumentSave" />
      <rule name="%Doc%.CommonRules.GetExportDirectory" event="OnGetDefaultExportDirectory" />
    </rules>
  </sheets>
  <editors>
    <editor id="F05_325_Subject_Editor" caption="Cубъект Российской Федерации">
      <fieldssheet name="F05_325_Subject_Editor_1" table="F05_325_Subjects">
        <field name="SubjectName_ID" caption="Наименование" />
      </fieldssheet>
    </editor>
  </editors>
  <menu>
    <menu caption="Сервис">
      <menu caption="Выполнить пересчет данных">
        <rules>
          <rule name="%Doc%.InterfaceRules.RecalcDataMenuItemClickEventHandler" event="OnClick" />
        </rules>
      </menu>
    </menu>
    <menu caption="Разработчик">
      <menu caption="Выполнить сдвиг данных">
        <rules>
          <rule name="%Doc%.InterfaceRules.ShiftDataMenuItemClickEventHandler" event="OnClick" />
        </rules>
      </menu>
      <menu caption="Выполнить копирование данных">
        <rules>
          <rule name="%Doc%.InterfaceRules.CopyDataMenuItemClickEventHandler" event="OnClick" />
        </rules>
      </menu>
    </menu>
  </menu>
  <files />
</document>