xml_to_json/ceshi0/报表附件/安装工程取费表.rptx

<?xml version="1.0" encoding="UTF-8"?>
<ReportCfg templateVersion="1.0">
    <GlobalFilters/>
    <RowConfigs>
        <rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
            <commonFilterList/>
            <conditionFilterList/>
            <summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
            <sorts/>
        </rowConfig>
        <rowConfig RowName="安装_项目划分" DataSourceName="安装_项目划分" RowType="数据行" physicalRpt="项目划分" dsFilter="" varsFilter="[专业划分]=“安装”" locateLabel="" datasetGroupExpression="" groupName="工程量/安装">
            <commonFilterList/>
            <conditionFilterList>
                <conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(B2==0 or B2==&quot;&quot;){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="1" delRowContainRef="0" PagingTag="0"/>
                <conditionFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="不等于" LeftProperty="[取费表]" LeftShowName="" RightValue="" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
                <conditionFilter ConditionType="普通条件" ValueType="小数" JoinOperator="并且" GroupName="第1组" CompareOperator="不等于" LeftProperty="[合价]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
            </conditionFilterList>
            <summary type="公式方式汇总" formula="GROUP(&quot;取费表&quot;,&quot;&quot;)" commSumName="" commSum=""/>
            <sorts/>
            <rowConfig RowName="取费表分类" DataSourceName="取费表分类" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="取费表">
                <commonFilterList/>
                <conditionFilterList>
                    <conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(B3==&quot;&quot;){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="1" delRowContainRef="0" PagingTag="0"/>
                    <conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[取费表名称]" LeftShowName="" RightValue="安装_项目划分.[取费表]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
                </conditionFilterList>
                <summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
                <sorts/>
                <rowConfig RowName="安装_项目划分取费" DataSourceName="安装_项目划分取费" RowType="单行" physicalRpt="取费表" dsFilter="" varsFilter="[专业划分]=“安装”" locateLabel="" datasetGroupExpression="" groupName="工程量/安装">
                    <commonFilterList/>
                    <conditionFilterList>
                        <conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【输出金额为“0”的费用项】==1){if(B4==&quot;&quot;){1}}&#10;else if(【输出金额为“0”的费用项】!=1){if(F4==&quot;&quot; or F4==0){1}}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
                        <conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[名称]" LeftShowName="" RightValue="取费表分类.[名称]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
                        <conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[取费表名称]" LeftShowName="" RightValue="取费表分类.[取费表名称]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
                    </conditionFilterList>
                    <summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
                    <sorts/>
                </rowConfig>
            </rowConfig>
            <rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
                <commonFilterList/>
                <conditionFilterList/>
                <summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
                <sorts/>
            </rowConfig>
        </rowConfig>
    </RowConfigs>
    <rows freezingRow="-1" freezingCol="-1" startRow="-1" startCol="-1">
        <cells rowNum="0" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
            <cell col="0" dataType="文本" text="序号" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="1" dataType="文本" text="费用名称" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="2" dataType="文本" text="取费基数" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="3" dataType="文本" text="计算说明" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="4" dataType="文本" text="费率" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="5" dataType="文本" text="总价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
        </cells>
        <cells rowNum="1" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
            <cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[取费表]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="if(【输出取费表名】==1){[取费表]}&#10;else{&quot;&quot;}" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="3" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
        </cells>
        <cells rowNum="2" rowHeight="0" HideRowHeight="30" AdaptiveRowHeight="false">
            <cell col="1" dataType="数据字段" text="mingcheng" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
        </cells>
        <cells rowNum="3" rowHeight="27" HideRowHeight="27" AdaptiveRowHeight="false">
            <cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[序号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[取费基数]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
            <cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[合计]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="COLLECTNUM([合计])" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
        </cells>
        <cells rowNum="4" rowHeight="34" HideRowHeight="-1" AdaptiveRowHeight="true">
            <cell col="1" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
                <CellDataSet CellDataSetType="默认" collectFunction="">
                    <CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
                </CellDataSet>
                <CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
            </cell>
        </cells>
    </rows>
    <cols>
        <col colNum="0" colWidth="44" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="序号" Filed="序号"/>
        <col colNum="1" colWidth="56" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费用名称" Filed="费用名称"/>
        <col colNum="2" colWidth="70" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="取费基数" Filed="取费基数"/>
        <col colNum="3" colWidth="56" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="计算说明" Filed="计算说明"/>
        <col colNum="4" colWidth="44" hideColWidth="0" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费率" Filed="费率"/>
        <col colNum="5" colWidth="44" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="总价" Filed="总价"/>
    </cols>
    <mergeCells/>
</ReportCfg>