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([概算单价]&gt;[计费价格]){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
                <conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(B2==&quot;&quot;){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
            </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(G3==0 or G3==&quot;&quot;){1}" ConditionName="过滤合计为0" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
            </conditionFilterList>
            <summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
            <sorts/>
        </rowConfig>
    </RowConfigs>
    <rows freezingRow="-1" freezingCol="-1" startRow="-1" startCol="-1">
        <cells rowNum="0" rowHeight="27" HideRowHeight="25" 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>
            <cell col="6" 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="7" 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="25" AdaptiveRowHeight="true">
            <cell col="0" dataType="公式" text="" formual="=SEQ(&quot;自增序号&quot;,1)" 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>
            <cell col="6" dataType="公式" text="" formual="=(E2-D2)*F2" 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="7" 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="27" HideRowHeight="25" 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>
            <cell col="6" dataType="公式" text="" formual="=SUM(G2)" 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="122" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="序号" Filed="序号"/>
        <col colNum="1" colWidth="44" hideColWidth="200" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="名称" Filed="名称"/>
        <col colNum="2" colWidth="44" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="单位" Filed="单位"/>
        <col colNum="3" colWidth="70" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="计费价格" Filed="计费价格"/>
        <col colNum="4" colWidth="70" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="概算单价" Filed="概算单价"/>
        <col colNum="5" colWidth="44" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="数量" Filed="数量"/>
        <col colNum="6" colWidth="76" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="调整额合计" Filed="调整额合计"/>
        <col colNum="7" colWidth="44" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="备注" Filed="备注"/>
    </cols>
    <mergeCells/>
</ReportCfg>