chentianrui
1474 lines
146 KiB
XML
1474 lines
146 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
||
<ReportCfg templateVersion="1.0">
|
||
<GlobalFilters>
|
||
<globalFilter dataSrcName="安装_项目划分" ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[存在数量不为0的消耗量]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1"/>
|
||
<globalFilter dataSrcName="安装_主材" ConditionType="普通条件" ValueType="小数" JoinOperator="并且" GroupName="第1组" CompareOperator="不等于" LeftProperty="[数量]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1"/>
|
||
<globalFilter dataSrcName="安装_主材" ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[设备性材料]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1"/>
|
||
<globalFilter dataSrcName="安装_配合比主材子级" ConditionType="普通条件" ValueType="小数" JoinOperator="并且" GroupName="第1组" CompareOperator="不等于" LeftProperty="[数量]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1"/>
|
||
<globalFilter dataSrcName="安装_配合比主材子级" ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[设备性材料]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1"/>
|
||
</GlobalFilters>
|
||
<RowConfigs>
|
||
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList/>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList/>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="安装_项目划分" DataSourceName="安装_项目划分" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业划分]=“安装”" locateLabel="" datasetGroupExpression="" groupName="工程量/安装">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([基础变量.层级]<=设置项目划分输出的级别){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="或者" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置项目划分输出的级别】=="最小级"){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(F4,F5)==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="if(B4==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置消耗量按编码排序】==1){if([拆分子级]==0){1}}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="或者" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置消耗量按编码排序】==0){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]=="主材") { if(【显示价格为“0”的主材】==0) { if(([预算价不含税]+[预算价含税]+[市场价不含税]+[市场价含税])!=0){1} else{0} } else{1} }" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="if(【设置消耗量按编码排序】==1){SORT( GROUP("编码,名称,费用类型,规格型号,单重,单位,损耗,供货方,监造物料,市场价不含税,市场价含税,预算价不含税,预算价含税,集中配送,卸车,保管,合并信息,增值税率,配送方式","数量"),"编码","升序")}" 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(B5==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置消耗量按编码排序】==1 and [父级合并信息]==安装_主材.[合并信息]){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]=="主材") { if(【显示价格为“0”的主材】==0) { if(([预算价不含税]+[预算价含税]+[市场价不含税]+[市场价含税])!=0){1} else{0} } else{1} }" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="并且" GroupName="第3组" CompareOperator="等于" LeftProperty="[所属项目划分id]" LeftShowName="" RightValue="安装_项目划分.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="公式方式汇总" formula="if(【设置消耗量按编码排序】==1){SORT( GROUP("编码,名称,费用类型,规格型号,单重,单位,损耗,供货方,监造物料,市场价不含税,市场价含税,预算价不含税,预算价含税,集中配送,卸车,保管,增值税率,配送方式","数量"),"编码","升序") }" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</rowConfig>
|
||
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList/>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(M7==0 and S7==0 and AG7==0){1}" ConditionName="过滤合价、总重均为0" 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>
|
||
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(M9==0 and S9==0 and AG9==0){1}" ConditionName="过滤合计、总重均为0" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</RowConfigs>
|
||
<rows freezingRow="-1" freezingCol="-1" startRow="0" startCol="26">
|
||
<cells rowNum="0" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="文本" text="编码" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="文本" text="项目名称" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="文本" text="项目名称及规格型号" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="文本" text="规格型号" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="文本" text="单位" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="文本" text="设计用量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="文本" text="数量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="文本" text="供货方" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="单价不含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="文本" text="合价不含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="文本" text="合价不含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="文本" text="单价含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="文本" text="单价含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="文本" text="合价含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="文本" text="合价含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="文本" text="损耗费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="25" dataType="文本" text="配送费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="27" dataType="文本" text="卸车费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="29" dataType="文本" text="保管费" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="31" dataType="文本" text="重量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="32" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="33" dataType="文本" text="单价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="34" dataType="文本" text="合价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="35" dataType="文本" text="物料类型" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="36" dataType="文本" text="费用编码" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="37" dataType="文本" text="预算价合价（含损耗）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="38" dataType="文本" text="预算价合价（含损耗）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="39" dataType="文本" text="市场价合价（含损耗）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="40" dataType="文本" text="合价不含税汇总" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="41" dataType="文本" text="合价不含税（含损耗）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="42" dataType="文本" text="合价含税（含损耗）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="43" dataType="文本" text="合价含税汇总" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="44" dataType="文本" text="合价不含税汇总" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="1" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="预算价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="文本" text="市场价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="文本" text="价差" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="文本" text="预算价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="文本" text="市场价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="文本" text="价差" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="文本" text="预算价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="文本" text="市场价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="文本" text="价差" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="文本" text="预算价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="文本" text="市场价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="文本" text="价差" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="文本" text="损耗率（%）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="文本" text="预算价不含税合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="文本" text="预算价含税合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="23" dataType="文本" text="市场价不含税合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="24" dataType="文本" text="市场价含税合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="25" dataType="文本" text="配送费率（%）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="26" dataType="文本" text="合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="27" dataType="文本" text="卸车费率（%）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="28" dataType="文本" text="合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="29" dataType="文本" text="保管费率（%）" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="30" dataType="文本" text="合计" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="31" dataType="文本" text="单重" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="32" dataType="文本" text="总重" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="36" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="37" dataType="文本" text="含税价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="38" dataType="文本" text="不含税价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="39" dataType="文本" text="含税价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="40" dataType="文本" text="不含税价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="41" dataType="文本" text="价差" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="42" dataType="文本" text="价差" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="2" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[序号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="36" dataType="数据字段" text="" formual="" formualNode="" fieldName="[费用编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="3" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if(【输出主材编码】==1) { if([供货方]=="甲供" and [费用类型]=="不取费"){[编码]&"不取费（甲）"} else if([供货方]=="甲供" and [费用类型]=="取费"){[编码]&"（甲）"} else if([供货方]=="乙供" and [费用类型]=="不取费"){[编码]&"不取费"} else{[编码]} } else { if([供货方]=="甲供" and [费用类型]=="不取费"){"不取费（甲）"} else if([供货方]=="甲供" and [费用类型]=="取费"){"（甲）"} else if([供货方]=="乙供" and [费用类型]=="不取费"){"不取费"} else{""} } " commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="公式" text="" formual="=F4*(1+U4/100)" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[供货方]} else{0}" 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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[预算价不含税]} else{0}" 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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[市场价不含税]} else{0}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="公式" text="" formual="=J4-I4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="公式" text="" formual="=I4*F4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="公式" text="" formual="=F4*J4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="公式" text="" formual="=M4-L4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[预算价含税]} else{0}" 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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[市场价含税]} else{0}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="公式" text="" formual="=P4-O4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="公式" text="" formual="=O4*F4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="公式" text="" formual="=F4*P4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=S4-R4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[损耗]} else{0}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="公式" text="V13=" formual="=F4*(U4*0.01)*I4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="公式" text="V13=" formual="=F4*(U4*0.01)*O4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="23" dataType="公式" text="" formual="=F4*(U4*0.01)*J4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="24" dataType="公式" text="" formual="=F4*(U4*0.01)*P4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="25" dataType="数据字段" text="" formual="" formualNode="" fieldName="[集中配送]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([集中配送]==1){ if([供货方]=="甲供" && [配送方式]=="省级"){【甲供材料配送费费率_省级】} else if([供货方]=="甲供" && [配送方式]=="市级"){【甲供材料配送费费率_市级】} else if([供货方]=="乙供" && [配送方式]=="省级"){【乙供材料配送费费率_省级】} else if([供货方]=="乙供" && [配送方式]=="市级"){【乙供材料配送费费率_市级】} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="26" dataType="公式" text="" formual="=(S4+Y4)*STOF(Z4)/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="27" dataType="数据字段" text="" formual="" formualNode="" fieldName="[卸车]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([卸车]==1){ if([供货方]=="甲供"){甲供材料卸车费费率} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="28" dataType="公式" text="" formual="=(S4+Y4)*AB4/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="29" dataType="数据字段" text="" formual="" formualNode="" fieldName="[保管]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([保管]==1){ if([供货方]=="甲供"){甲供材料保管费费率} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="30" dataType="公式" text="" formual="=(S4+Y4)*AD4/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="31" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[单重]} else{0}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="32" dataType="公式" text="" formual="=F4*(1+U4*0.01)*AF4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="33" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){ if([供货方]=="甲供"){O4}else{I4} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="34" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){if([供货方]=="甲供"){R4+W4} else{L4+V4}}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="35" dataType="文本" text="主材" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="37" dataType="公式" text="" formual="=R4+W4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="38" dataType="公式" text="" formual="=L4+V4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="39" dataType="公式" text="" formual="=S4+Y4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="40" dataType="公式" text="" formual="=M4+X4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="41" dataType="公式" text="" formual="=N4+(X4-V4)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="42" dataType="公式" text="" formual="=T4+(Y4-W4)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="43" dataType="公式" text="" formual="=S4+Y4+AA4+AC4+AE4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="44" dataType="公式" text="" formual="=M4+X4+AA4+AC4+AE4" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="4" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if(【输出主材编码】==1){ if([供货方]=="甲供" and [费用类型]=="不取费"){[编码]&"不取费（甲）"} else if([供货方]=="甲供" and [费用类型]=="取费"){[编码]&"（甲）"} else if([供货方]=="乙供" and [费用类型]=="不取费"){[编码]&"不取费"} else{[编码]} } else{ if([供货方]=="甲供" and [费用类型]=="不取费"){"不取费（甲）"} else if([供货方]=="甲供" and [费用类型]=="取费"){"（甲）"} else if([供货方]=="乙供" and [费用类型]=="不取费"){"不取费"} else{""} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="公式" text="" formual="=F5*(1+U5/100)" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[市场价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="公式" text="" formual="=J5-I5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="公式" text="" formual="=I5*F5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="公式" text="" formual="=F5*J5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="公式" text="" formual="=M5-L5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="14" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="15" dataType="数据字段" text="" formual="" formualNode="" fieldName="[市场价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="16" dataType="公式" text="" formual="=P5-O5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="公式" text="" formual="=O5*F5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="公式" text="" formual="=F5*P5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=S5-R5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="20" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="公式" text="V13=" formual="=F5*(U5*0.01)*I5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="公式" text="V13=" formual="=F5*(U5*0.01)*O5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="23" dataType="公式" text="" formual="=F5*(U5*0.01)*J5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="24" dataType="公式" text="" formual="=F5*(U5*0.01)*P5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="25" dataType="数据字段" text="" formual="" formualNode="" fieldName="[集中配送]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([集中配送]==1){ if([供货方]=="甲供" && [配送方式]=="省级"){【甲供材料配送费费率_省级】} else if([供货方]=="甲供" && [配送方式]=="市级"){【甲供材料配送费费率_市级】} else if([供货方]=="乙供" && [配送方式]=="省级"){【乙供材料配送费费率_省级】} else if([供货方]=="乙供" && [配送方式]=="市级"){【乙供材料配送费费率_市级】} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="26" dataType="公式" text="" formual="=(S5+Y5)*STOF(Z5)/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="27" dataType="数据字段" text="" formual="" formualNode="" fieldName="[卸车]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([卸车]==1){ if([供货方]=="甲供"){甲供材料卸车费费率} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="28" dataType="公式" text="" formual="=(S5+Y5)*AB5/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="29" dataType="数据字段" text="" formual="" formualNode="" fieldName="[保管]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([保管]==1){ if([供货方]=="甲供"){甲供材料保管费费率} }" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="30" dataType="公式" text="" formual="=(S5+Y5)*AD5/100" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="31" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="32" dataType="公式" text="" formual="=F5*(1+U5*0.01)*AF5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="33" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([供货方]=="甲供"){O5} else{I5}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="34" dataType="数据字段" text="" formual="" formualNode="" fieldName="[预算价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([供货方]=="甲供"){R5+W5} else{L5+V5}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="35" dataType="文本" text="主材" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="37" dataType="公式" text="" formual="=R5+W5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="38" dataType="公式" text="" formual="=L5+V5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="39" dataType="公式" text="" formual="=S5+Y5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="40" dataType="公式" text="" formual="=M5+X5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="41" dataType="公式" text="" formual="=N5+(X5-V5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="42" dataType="公式" text="" formual="=T5+(Y5-W5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="43" dataType="公式" text="" formual="=S5+Y5+AA5+AC5+AE5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="44" dataType="公式" text="" formual="=M5+X5+AA5+AC5+AE5" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="5" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
||
<cells rowNum="6" 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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="文本" text="小计：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="公式" text="" formual="=SUM(L4+L5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="公式" text="" formual="=SUM(M4+M5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="公式" text="" formual="=SUM(N4+N5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="公式" text="" formual="=SUM(R4+R5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="公式" text="" formual="=SUM(S4+S5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=SUM(T4+T5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="公式" text="" formual="=SUM(V4+V5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="公式" text="" formual="=SUM(W4+W5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="23" dataType="公式" text="" formual="=SUM(X4+X5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="24" dataType="公式" text="" formual="=SUM(Y4+Y5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="26" dataType="公式" text="" formual="=SUM(AA4+AA5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="28" dataType="公式" text="" formual="=SUM(AC4+AC5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="30" dataType="公式" text="" formual="=SUM(AE4+AE5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="32" dataType="公式" text="" formual="=SUM(AG4+AG5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="34" dataType="公式" text="" formual="=SUM(AI4+AI5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="37" dataType="公式" text="" formual="=SUM(AL4+AL5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="38" dataType="公式" text="" formual="=SUM(AM4+AM5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="39" dataType="公式" text="" formual="=SUM(AN4+AN5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="40" dataType="公式" text="" formual="=SUM(AO4+AO5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="41" dataType="公式" text="" formual="=SUM(AP4+AP5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="42" dataType="公式" text="" formual="=SUM(AQ4+AQ5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="43" dataType="公式" text="" formual="=SUM(AR4+AR5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="44" dataType="公式" text="" formual="=SUM(AS4+AS5)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="7" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
||
<cells rowNum="8" 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">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="文本" text="合计：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="公式" text="" formual="=SUM(L7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="公式" text="" formual="=SUM(M7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="公式" text="" formual="=SUM(N7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="17" dataType="公式" text="" formual="=SUM(R7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="18" dataType="公式" text="" formual="=SUM(S7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="19" dataType="公式" text="" formual="=SUM(T7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="21" dataType="公式" text="" formual="=SUM(V7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="22" dataType="公式" text="" formual="=SUM(W7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="23" dataType="公式" text="" formual="=SUM(X7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="24" dataType="公式" text="" formual="=SUM(Y7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="26" dataType="公式" text="" formual="=SUM(AA7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="28" dataType="公式" text="" formual="=SUM(AC7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="30" dataType="公式" text="" formual="=SUM(AE7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="32" dataType="公式" text="" formual="=SUM(AG7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="34" dataType="公式" text="" formual="=SUM(AI7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="37" dataType="公式" text="" formual="=SUM(AL7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="38" dataType="公式" text="" formual="=SUM(AM7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="39" dataType="公式" text="" formual="=SUM(AN7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="40" dataType="公式" text="" formual="=SUM(AO7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="41" dataType="公式" text="" formual="=SUM(AP7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="42" dataType="公式" text="" formual="=SUM(AQ7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="43" dataType="公式" text="" formual="=SUM(AR7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="44" dataType="公式" text="" formual="=SUM(AS7)" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
</rows>
|
||
<cols>
|
||
<col colNum="0" colWidth="44" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="编码" Filed="编码"/>
|
||
<col colNum="1" colWidth="56" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="项目名称" Filed="项目名称"/>
|
||
<col colNum="2" colWidth="122" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="项目名称及规格型号" Filed="项目名称及规格型号"/>
|
||
<col colNum="3" colWidth="70" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="规格型号" Filed="规格型号"/>
|
||
<col colNum="4" colWidth="44" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="单位" Filed="单位"/>
|
||
<col colNum="5" colWidth="56" hideColWidth="0" colFormat="1" numberType="1" AdaptiveColWidth="1" checkRate="0" headerFiled="设计用量" Filed="设计用量"/>
|
||
<col colNum="6" colWidth="96" hideColWidth="-1" colFormat="1" numberType="1" AdaptiveColWidth="1" checkRate="0" headerFiled="数量" Filed="数量"/>
|
||
<col colNum="7" colWidth="56" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="供货方" Filed="供货方"/>
|
||
<col colNum="8" colWidth="96" hideColWidth="-1" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价" Filed="预算价"/>
|
||
<col colNum="9" colWidth="96" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价" Filed="单价不含税.市场价"/>
|
||
<col colNum="10" colWidth="70" hideColWidth="-1" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="单价不含税.价差"/>
|
||
<col colNum="11" colWidth="76" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价" Filed="预算价"/>
|
||
<col colNum="12" colWidth="76" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价" Filed="市场价"/>
|
||
<col colNum="13" colWidth="76" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="合价不含税.价差"/>
|
||
<col colNum="14" colWidth="82" hideColWidth="-1" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价" Filed="预算价"/>
|
||
<col colNum="15" colWidth="82" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价" Filed="市场价"/>
|
||
<col colNum="16" colWidth="56" hideColWidth="-1" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="单价含税.价差"/>
|
||
<col colNum="17" colWidth="76" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价" Filed="预算价"/>
|
||
<col colNum="18" colWidth="96" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="市场价" Filed="市场价"/>
|
||
<col colNum="19" colWidth="76" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="合价含税.价差"/>
|
||
<col colNum="20" colWidth="76" hideColWidth="-1" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="损耗率（%）" Filed="损耗费.损耗率（%）"/>
|
||
<col colNum="21" colWidth="108" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价不含税合计" Filed="损耗费.预算价不含税合计"/>
|
||
<col colNum="22" colWidth="108" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价含税合计" Filed="损耗费.预算价含税合计"/>
|
||
<col colNum="23" colWidth="108" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价不含税合计" Filed="损耗费.市场价不含税合计"/>
|
||
<col colNum="24" colWidth="108" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价含税合计" Filed="损耗费.市场价含税合计"/>
|
||
<col colNum="25" colWidth="90" hideColWidth="-1" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="配送费率（%）" Filed="配送费.配送费率（%）"/>
|
||
<col colNum="26" colWidth="142" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合计" Filed="配送费.合计"/>
|
||
<col colNum="27" colWidth="90" hideColWidth="-1" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="卸车费率（%）" Filed="卸车费.卸车费率（%）"/>
|
||
<col colNum="28" colWidth="108" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合计" Filed="卸车费.合计"/>
|
||
<col colNum="29" colWidth="90" hideColWidth="-1" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="保管费率（%）" Filed="保管费.保管费率（%）"/>
|
||
<col colNum="30" colWidth="108" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合计" Filed="保管费.合计"/>
|
||
<col colNum="31" colWidth="44" hideColWidth="80" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="单重" Filed="重量.单重"/>
|
||
<col colNum="32" colWidth="128" hideColWidth="0" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="总重" Filed="重量.总重"/>
|
||
<col colNum="33" colWidth="96" hideColWidth="-1" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="单价" Filed="单价"/>
|
||
<col colNum="34" colWidth="96" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合价" Filed="合价"/>
|
||
<col colNum="35" colWidth="56" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="物料类型" Filed="物料类型"/>
|
||
<col colNum="36" colWidth="70" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费用编码" Filed="费用编码"/>
|
||
<col colNum="37" colWidth="134" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="含税价" Filed="预算价合价（含损耗）.含税价"/>
|
||
<col colNum="38" colWidth="134" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="不含税价" Filed="预算价合价（含损耗）.不含税价"/>
|
||
<col colNum="39" colWidth="134" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="含税价" Filed="市场价合价（含损耗）.含税价"/>
|
||
<col colNum="40" colWidth="134" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="不含税价" Filed="市场价合价（含损耗）.不含税价"/>
|
||
<col colNum="41" colWidth="134" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="价差"/>
|
||
<col colNum="42" colWidth="122" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="价差"/>
|
||
<col colNum="43" colWidth="122" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合价含税汇总" Filed="合价含税汇总"/>
|
||
<col colNum="44" colWidth="122" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="合价不含税汇总" Filed="合价不含税汇总"/>
|
||
</cols>
|
||
<mergeCells>
|
||
<mergeCell startRow="0" endRow="0" startCol="31" endCol="32"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="12" endCol="12"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="15" endCol="15"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="18" endCol="18"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="36" endCol="36"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="0" endCol="0"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="1" endCol="1"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="4" endCol="4"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="5" endCol="5"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="7" endCol="7"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="2" endCol="2"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="3" endCol="3"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="20" endCol="24"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="27" endCol="28"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="29" endCol="30"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="33" endCol="33"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="34" endCol="34"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="35" endCol="35"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="39" endCol="40"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="43" endCol="43"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="44" endCol="44"/>
|
||
<mergeCell startRow="0" endRow="1" startCol="6" endCol="6"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="25" endCol="26"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="8" endCol="8"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="8" endCol="10"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="11" endCol="11"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="14" endCol="14"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="17" endCol="17"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="11" endCol="13"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="14" endCol="16"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="17" endCol="19"/>
|
||
<mergeCell startRow="0" endRow="0" startCol="37" endCol="38"/>
|
||
</mergeCells>
|
||
</ReportCfg>
|