Files
xml_to_json/ceshi0/报表附件/勘察费明细表_方法三.rptx
chentianrui 4459270336 上传文件
2025-10-21 11:34:54 +08:00

205 lines
18 KiB
XML

<?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/>
<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="" ConditionName="" DataSrcFilter="1" ResultFilter="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="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
</conditionFilterList>
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
<sorts/>
</rowConfig>
</RowConfigs>
<rows freezingRow="-1" freezingCol="-1" startRow="-1" startCol="0">
<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>
</cells>
<cells rowNum="1" 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>
</cells>
<cells rowNum="2" rowHeight="27" HideRowHeight="-1" 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="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>
</cells>
<cells rowNum="3" 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="if([名称]==&quot;设置勘察收费基价&quot;){0}else{[合价]}" commonFuntionName="" commonFuntion=""/>
</CellDataSet>
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
</cell>
</cells>
</rows>
<cols>
<col colNum="0" colWidth="44" hideColWidth="35" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="序号" Filed="序号"/>
<col colNum="1" colWidth="70" hideColWidth="175" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="项目名称" Filed="项目名称"/>
<col colNum="2" colWidth="82" hideColWidth="70" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="计算式" Filed="初步勘测.计算式"/>
<col colNum="3" colWidth="56" hideColWidth="70" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合价" Filed="初步勘测.合价"/>
<col colNum="4" colWidth="82" hideColWidth="70" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="计算式" Filed="施工图勘测.计算式"/>
<col colNum="5" colWidth="70" hideColWidth="70" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合价" Filed="施工图勘测.合价"/>
<col colNum="6" colWidth="44" hideColWidth="70" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合价" Filed="合价"/>
</cols>
<mergeCells>
<mergeCell startRow="0" endRow="1" startCol="6" endCol="6"/>
<mergeCell startRow="0" endRow="0" startCol="4" endCol="5"/>
<mergeCell startRow="0" endRow="0" startCol="2" endCol="3"/>
<mergeCell startRow="0" endRow="1" startCol="1" endCol="1"/>
<mergeCell startRow="0" endRow="1" startCol="0" endCol="0"/>
</mergeCells>
</ReportCfg>