chentianrui
1302 lines
137 KiB
XML
1302 lines
137 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
||
<ReportCfg BuildThreadCount="1" templateVersion="1.0" syncTableHeader="是">
|
||
<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="1" datasetGroupExpression="" groupName="工程量/拆除">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[存在消耗量]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[最小级]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="项目划分分页" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="0" PagingTag="1"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【按项目划分分页输出】==1){1}" ConditionName="项目划分分页" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="0" PagingTag="1"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(C4)==0){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="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="" ConditionName="" DataSrcFilter="1" ResultFilter="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="if(【输出数量为“0”的消耗量】==1) { if(C4=="" && [类型]!="注解"){1} } else if(【输出数量为“0”的消耗量】!=1) { if(F4=="" or F4==0) { if([类型]!="注解"){1} } }" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]=="拆分人工" or [类型]=="拆分材料" or [类型]=="拆分机械"){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第3组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]=="主材" and [拆分]==1){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(P5==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属项目划分id]" LeftShowName="" RightValue="拆除_项目划分.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("所属综合地形id","综合地形定额人工费,综合地形定额机械费")" 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(P6==0 or P6==""){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(P7==0 or P7==""){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(P8==0 or P8==""){true}" 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="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[集中配送]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(P9==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("配送费费率","分组合价")" 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(P10==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="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("配送费费率","分组合价")" 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(P11==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="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("","分组合价")" 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(P12==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="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="GROUP("","分组合价")" 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(P13+N13+O13==0){true}" 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/>
|
||
<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"/>
|
||
<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"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【输出取费表】==0){1}" ConditionName="过滤取费表" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="或者" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(P15==0 or P15==""){true}" 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(P16==0 or P16==""){true}" ConditionName="过滤取费表" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="或者" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【输出取费表】==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"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[最后一行]" LeftShowName="" RightValue="1" 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(【按项目划分分页输出】==1){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="1" delRowContainRef="0" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</rowConfig>
|
||
</rowConfig>
|
||
</RowConfigs>
|
||
<rows freezingRow="-1" freezingCol="-1" startRow="0" startCol="2">
|
||
<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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="文本" text="合价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="文本" text="建筑费合价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="文本" text="重量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="导入表三字段" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="金额" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="文本" text="其中：人工费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="文本" text="其中：材料费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="文本" text="其中：甲供材料费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="文本" text="其中：机械费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="文本" text="设备" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="文本" text="主材" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="文本" text="金额" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="文本" text="其中：人工费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="文本" text="其中：材料费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="文本" text="其中：甲供材料费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="文本" text="其中：机械费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="文本" text="单重" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="文本" text="总重" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="数据字段" text="" formual="" formualNode="" fieldName="[取费表变量.合计]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="数据字段" text="" formual="" formualNode="" fieldName="[导入表三字段]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="3" rowHeight="77" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="定额") { if(【显示定额调整系数】==1) { if([费用类型]=="取费") { [标记]&" "&[带标记编码] } else { [标记]&" "&[带标记编码]&" "&"不取费" } } else { if([费用类型]=="取费") { [标记]&" "&[编码] } else { [标记]&" "&[编码]&" "&"不取费" } } } else if([类型]=="主材" and [设备性材料]==0) { if(【输出主材编码】==1){if([供货方]=="甲供" and [费用类型]=="不取费"){[编码]&"不取费(甲)"} else if([供货方]=="甲供" and [费用类型]=="取费"){[编码]&"(甲)"} else if([供货方]=="乙供" and [费用类型]=="不取费"){[编码]&"不取费"} else{[编码]} } else { if([供货方]=="甲供" and [费用类型]=="不取费"){"不取费(甲)"} else if([供货方]=="甲供" and [费用类型]=="取费"){"(甲)"} else if([供货方]=="乙供" and [费用类型]=="不取费"){"不取费"} else{0} } } else if([设备性材料]==1) { if(【输出设备编码】==1) { if([供货方]=="甲供") { [编码]&"(甲设材)" } else { [编码]&"(乙设材)" } } else { if([供货方]=="甲供") { "(甲设材)" } else { "(乙设材)" } } } else if([类型]=="设备") { if(【输出设备编码】==1) { if([供货方]=="甲供") { [编码]&"(甲设)" } else { [编码]&"(乙设)" } } else { if([供货方]=="甲供") { "(甲设)" } else { "(乙设)" } } } else if([类型]=="一笔性费用") { [编码]&"(费)" } else if([类型]=="注解") { [编码] } else if([类型]=="材料") { if([供货方]=="甲供") { if(【输出人材机编码】==1){[编码]&"(甲材)"} else{"(甲材)"} } else if([供货方]=="乙供") { if(【输出人材机编码】==1){[编码]&"(乙材)"} else{"(乙材)"} } else { if(【输出人材机编码】==1){[编码]} else{""} } } else if([类型]=="人工" or [类型]=="机械"){ if(【输出人材机编码】==1){[编码]} else{""} }" 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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="主材" or [类型]=="注解" or [类型]=="设备" or [类型]=="一笔性费用") { [名称]&" "&[规格型号] } else { [名称] }" 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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([供货方]=="甲供"){[市场价含税]} else{[市场价不含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0">
|
||
<CellCustomFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[类型]" LeftShowName="" RightValue="设备" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<CellCustomFilter ConditionType="普通条件" ValueType="整型" JoinOperator="或者" GroupName="第1组" CompareOperator="等于" LeftProperty="[设备性材料]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</CellFilters>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([供货方]=="甲供") { [预算价含税] } else { [预算价不含税] }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0">
|
||
<CellCustomFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[类型]" LeftShowName="" RightValue="主材" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<CellCustomFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[设备性材料]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</CellFilters>
|
||
</cell>
|
||
<cell col="8" dataType="公式" text="" formual="=if([类型]=="定额"){J4+K4+M4} else if([类型]=="一笔性费用"){[单价含税]} else if([类型]=="人工"){J4} else if([类型]=="材料"){K4} else if([类型]=="机械"){M4}" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[人工费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="定额") { [人工费]*[人工系数]*[定额系数] } else if([类型]=="人工") { [预算价不含税] }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="[材料费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="定额") { [材料费]*[定额系数]*[材料系数] } else if([类型]=="材料") { [预算价不含税] }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="[甲供材料费不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="定额") { [甲供材料费不含税]*[材料系数]*[定额系数] } else if([类型]=="材料") { [甲供材料费不含税] }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[机械费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="定额") { [机械费]*[定额系数]*[机械系数] } else if([类型]=="机械") { [预算价不含税] }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="公式" text="" formual="=F4*G4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="公式" text="" formual="=F4*H4" formualNode="" fieldName="[id]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="F4*H4" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=F4*I4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="公式" text="" formual="=F4*J4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="公式" text="" formual="=F4*K4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="公式" text="" formual="=F4*L4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=F4*M4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="公式" text="" formual="=F4*U4*(1+[损耗]/100)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="数据字段" text="" formual="" formualNode="" fieldName="[导入表三字段]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="4" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="STRCAT("地形增加系数--",[所属特征段名称],"--",[名称],"")" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="STRCAT("地形增加系数--",[所属特征段名称],"--",[名称],"")" 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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="公式" text="" formual="=J5+M5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[综合地形定额人工费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[综合地形定额机械费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=Q5+T5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="公式" text="" formual="=J5*F5/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=M5*F5/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W15)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="5" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="混凝土施工调整费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=Q6+R6+T6" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.混凝土施工调整人工费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费混凝土施工调整人工费]+[基础变量.不取费混凝土施工调整人工费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.混凝土施工调整材料费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费混凝土施工调整材料费]+[基础变量.不取费混凝土施工调整材料费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.混凝土施工调整机械费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费混凝土施工调整机械费]+[基础变量.不取费混凝土施工调整机械费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="6" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="脚手架搭拆费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="公式" text="" formual="=5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="公式" text="" formual="=J7+K7+M7" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="公式" text="" formual="=Q7/F7*100" formualNode="" fieldName="[基础变量.脚手架人工费_单价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费脚手架人工费_单价]+[基础变量.不取费脚手架人工费_单价]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="公式" text="" formual="=R7/F7*100" formualNode="" fieldName="[基础变量.脚手架材料费_单价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费脚手架材料费_单价]+[基础变量.不取费脚手架材料费_单价]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="公式" text="" formual="=T7/F7*100" formualNode="" fieldName="[基础变量.脚手架机械费_单价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费脚手架机械费_单价]+[基础变量.不取费脚手架机械费_单价]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=Q7+R7+T7" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.取费脚手架人工费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费脚手架人工费]+[基础变量.不取费脚手架人工费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.取费脚手架材料费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费脚手架材料费]+[基础变量.不取费脚手架材料费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.取费脚手架机械费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费脚手架机械费]+[基础变量.不取费脚手架机械费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="7" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="小安装调试费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=Q8+R8+T8" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.调试人工费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费调试人工费]+[基础变量.不取费调试人工费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.调试材料费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费调试材料费]+[基础变量.不取费调试材料费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="数据字段" text="" formual="" formualNode="" fieldName="[基础变量.调试机械费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="[基础变量.取费调试机械费]+[基础变量.不取费调试机械费]" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="8" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="甲供消材配送费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([配送方式]=="省级"){【甲供材料配送费费率_省级】}else{【甲供材料配送费费率_市级】}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[分组合价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=STOF(F9)/100*I9" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="9" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="乙供消材配送费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([配送方式]=="省级"){【乙供材料配送费费率_省级】}else{【乙供材料配送费费率_市级】}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[分组合价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=STOF(F10)/100*I10" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="10" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="甲供消材卸车费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[分组合价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=F11/100*I11" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="11" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="甲供消材保管费：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[分组合价]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=F12/100*I12" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="12" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="小计：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="公式" text="" formual="=N4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="公式" text="" formual="=O4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="公式" text="" formual="=P4+P5+P6+P7+P8+P9+P10+P11+P12" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="公式" text="" formual="=Q4+Q5+Q6+Q7+Q8" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="公式" text="" formual="=R4+R6+R7+R8" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="公式" text="" formual="=SUM(S4)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=T4+T5+T6+T7+T8" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="小计" formual="=SUM(W17)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="true" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="13" rowHeight="34" 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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="14" rowHeight="27" HideRowHeight="0" 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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([费率]==100){0}else{"%"}" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([费率]==100){0}else{[费率]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="公式" text="" formual="=P15/F15*100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="数据字段" text="" formual="" formualNode="" fieldName="[合计]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="取费表" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="15" 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" mergeCell="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" mergeCell="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" mergeCell="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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([费率]==100){0}else{"%"}" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([费率]==100){0}else{[费率]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="公式" text="" formual="=P16/F16*100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="数据字段" text="" formual="" formualNode="" fieldName="[合计]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="取费表" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="16" rowHeight="34" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="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="序号" dynamicGenerate="否"/>
|
||
<col colNum="1" colWidth="56" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="编制依据" Filed="编制依据" dynamicGenerate="否"/>
|
||
<col colNum="2" colWidth="122" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="项目名称" Filed="项目名称" dynamicGenerate="否"/>
|
||
<col colNum="3" colWidth="122" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="项目名称及规格型号" Filed="项目名称及规格型号" dynamicGenerate="否"/>
|
||
<col colNum="4" colWidth="44" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="单位" Filed="单位" dynamicGenerate="否"/>
|
||
<col colNum="5" colWidth="154" hideColWidth="0" colFormat="1" numberType="1" AdaptiveColWidth="1" checkRate="0" headerFiled="数量" Filed="数量" dynamicGenerate="否"/>
|
||
<col colNum="6" colWidth="84" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="设备" Filed="单价.设备" dynamicGenerate="否"/>
|
||
<col colNum="7" colWidth="96" hideColWidth="80" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="主材" Filed="单价.主材" dynamicGenerate="否"/>
|
||
<col colNum="8" colWidth="280" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="金额" Filed="单价.金额" dynamicGenerate="否"/>
|
||
<col colNum="9" colWidth="136" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：人工费" Filed="单价.其中：人工费" dynamicGenerate="否"/>
|
||
<col colNum="10" colWidth="82" hideColWidth="80" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：材料费" Filed="单价.其中：材料费" dynamicGenerate="否"/>
|
||
<col colNum="11" colWidth="122" hideColWidth="80" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：甲供材料费" Filed="单价.其中：甲供材料费" dynamicGenerate="否"/>
|
||
<col colNum="12" colWidth="136" hideColWidth="80" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：机械费" Filed="单价.其中：机械费" dynamicGenerate="否"/>
|
||
<col colNum="13" colWidth="197" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="设备" Filed="合价.设备" dynamicGenerate="否"/>
|
||
<col colNum="14" colWidth="46" hideColWidth="80" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="主材" Filed="合价.主材" dynamicGenerate="否"/>
|
||
<col colNum="15" colWidth="214" hideColWidth="70" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="金额" Filed="合价.金额" dynamicGenerate="否"/>
|
||
<col colNum="16" colWidth="175" hideColWidth="70" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="其中：人工费" Filed="合价.其中：人工费" dynamicGenerate="否"/>
|
||
<col colNum="17" colWidth="208" hideColWidth="80" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：材料费" Filed="合价.其中：材料费" dynamicGenerate="否"/>
|
||
<col colNum="18" colWidth="108" hideColWidth="80" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：甲供材料费" Filed="合价.其中：甲供材料费" dynamicGenerate="否"/>
|
||
<col colNum="19" colWidth="208" hideColWidth="80" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="其中：机械费" Filed="合价.其中：机械费" dynamicGenerate="否"/>
|
||
<col colNum="20" colWidth="70" hideColWidth="80" colFormat="1" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="单重" Filed="重量.单重" dynamicGenerate="否"/>
|
||
<col colNum="21" colWidth="150" hideColWidth="80" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="总重" Filed="重量.总重" dynamicGenerate="否"/>
|
||
<col colNum="22" colWidth="116" hideColWidth="80" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="导入表三字段" Filed="导入表三字段" dynamicGenerate="否"/>
|
||
</cols>
|
||
<mergeCells>
|
||
<mergeCell startRow="0" endRow="1" startCol="0" endCol="0"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="1" endCol="1"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="2" endCol="2"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="4" endCol="4"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="5" endCol="5"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="20" endCol="21"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="3" endCol="3"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="6" endCol="12"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="13" endCol="19"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="22" endCol="22"/>
|
||
</mergeCells>
|
||
</ReportCfg>
|