1269 lines
126 KiB
XML
1269 lines
126 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<ReportCfg templateVersion="1.0">
|
|
<GlobalFilters/>
|
|
<RowConfigs>
|
|
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList/>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList/>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="建筑_项目划分" DataSourceName="建筑_项目划分" RowType="数据行" physicalRpt="项目划分" dsFilter="" varsFilter="[专业划分]=“建筑”" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(D4,D4)==0){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[存在数量不为0的消耗量]" LeftShowName="" RightValue="1" FormulaValue="" 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="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置项目划分输出的级别】=="最小级"){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
<rowConfig RowName="建筑_材机分析_配合比材料" DataSourceName="建筑_材机分析_配合比材料" RowType="数据行" physicalRpt="材机分析_材料" dsFilter="" varsFilter="[专业类型]=“建筑”" locateLabel="" datasetGroupExpression="" groupName="材机分析/建筑">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(B4==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="公式方式汇总" formula="GROUP("材机分析合并信息,增值税率","数量")" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D4==0 or D4==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="1" delRowContainRef="0" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D4==0 or D4==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="1" delRowContainRef="0" 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(COUNT(D9,D9)==0){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[存在数量不为0的消耗量]" LeftShowName="" RightValue="1" FormulaValue="" 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="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置项目划分输出的级别】=="最小级"){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
<rowConfig RowName="安装_材机分析_配合比材料" DataSourceName="安装_材机分析_配合比材料" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“安装”" locateLabel="" datasetGroupExpression="" groupName="材机分析/安装">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(B9==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="公式方式汇总" formula="GROUP("材机分析合并信息,增值税率","数量")" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D9==0 or D9==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D9==0 or D9==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList/>
|
|
<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(COUNT(D14,D14)==0){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[存在数量不为0的消耗量]" LeftShowName="" RightValue="1" FormulaValue="" 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="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【设置项目划分输出的级别】=="最小级"){1}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
<rowConfig RowName="拆除_材机分析_配合比材料" DataSourceName="拆除_材机分析_配合比材料" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“拆除”" locateLabel="" datasetGroupExpression="" groupName="材机分析/拆除">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(B14==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="公式方式汇总" formula="GROUP("材机分析合并信息,增值税率","数量")" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D14==0 or D14==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(D14==0 or D14==""){1}" ConditionName="过滤" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList/>
|
|
<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(I18+J18+K18==0 or I18+J18+K18==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(O18+P18+Q18==0 or O18+P18+Q18==""){1}" ConditionName="" 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="9" startCol="0">
|
|
<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="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>
|
|
</cells>
|
|
<cells rowNum="1" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="2" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="3" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="4" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="5" dataType="文本" text="预算价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="文本" text="市场价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<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>
|
|
</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="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>
|
|
</cells>
|
|
<cells rowNum="3" rowHeight="47" 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="if([拆分]==0){[预算价不含税]}" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[市场价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="if([拆分]==0){ if([类型]!="拆分人工"){[市场价不含税]} else if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价不含税]*(1+建筑_项目划分.[人工调差系数]/100)} else{[市场价不含税]} } }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="7" dataType="公式" text="" formual="=G4-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="8" dataType="公式" text="" formual="=D4*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="9" dataType="公式" text="" formual="=D4*G4" 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="=D4*H4" 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="if([拆分]==0){[预算价含税]}" 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="if([拆分]==0){ if([类型]!="拆分人工"){[市场价含税]} else if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价含税]*(1+建筑_项目划分.[人工调差系数]/100)} else{[市场价含税]} } }" 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="=D4*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="15" dataType="公式" text="" formual="=D4*M4" 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="=D4*N4" 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="if([集中配送]==1){ if([供货方]=="甲供" && [配送方式]=="省级"){P4*【甲供材料配送费费率_省级】/100} else if([供货方]=="甲供" && [配送方式]=="市级"){P4*【甲供材料配送费费率_市级】/100} else if([供货方]=="乙供" && [配送方式]=="省级"){P4*【乙供材料配送费费率_省级】/100} else if([供货方]=="乙供" && [配送方式]=="市级"){P4*【乙供材料配送费费率_市级】/100} }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="19" dataType="公式" text="" formual="=if([卸车]==1){if([供货方]=="甲供"){P4*【甲供材料卸车费费率】/100}else{0}}" formualNode="" fieldName="建筑_项目划分.[基础变量.取费甲供材料配送费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="true">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="20" dataType="公式" text="" formual="=if([保管]==1){if([供货方]=="甲供"){P4*【甲供材料保管费费率】/100}else{0}}" formualNode="" fieldName="建筑_项目划分.[基础变量.取费甲供材料配送费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="true">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="4" rowHeight="34" HideRowHeight="25" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="5" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="文本" text="小计:" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="8" dataType="公式" text="" formual="=SUM(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="9" dataType="公式" text="" formual="=SUM(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="10" dataType="公式" text="" formual="=SUM(K4)" 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="=SUM(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="15" dataType="公式" text="" formual="=SUM(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="16" dataType="公式" text="" formual="=SUM(Q4)" 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)" 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)" 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="=SUM(U4)" 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="6" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="18" dataType="数据字段" text="" formual="=S8-S" 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="=T8-S" 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="=U8-S" 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="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[序号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="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="=T9-S" 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="=U9-S" 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="8" rowHeight="47" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="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="if([拆分]==0){[预算价不含税]}" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[市场价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="if([拆分]==0){ if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价不含税]*(1+安装_项目划分.[人工调差系数]/100)} else{[市场价不含税]} } else if([类型]=="材料" or [类型]=="拆分材料"){ if(【安装材机调差方式】=="系数调差"){[预算价不含税]*(1+安装_项目划分.[材料调差系数]/100)} else{[市场价不含税]} } else if([类型]=="拆分机械"){ if(【安装材机调差方式】=="系数调差"){[预算价不含税]*(1+安装_项目划分.[机械调差系数]/100)} else{[市场价不含税]} } }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="7" dataType="公式" text="" formual="=G9-F9" 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="=D9*F9" 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="=D9*G9" 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="=D9*H9" 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="if([拆分]==0){[预算价含税]}" 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="if([拆分]==0){ if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价含税]*(1+安装_项目划分.[人工调差系数]/100)} else{[市场价含税]} } else if([类型]=="材料" or [类型]=="拆分材料"){ if(【安装材机调差方式】=="系数调差"){[预算价含税]*(1+安装_项目划分.[材料调差系数]/100)} else{[市场价含税]} } else if([类型]=="拆分机械"){ if(【安装材机调差方式】=="系数调差"){[预算价含税]*(1+安装_项目划分.[机械调差系数]/100)} else{[市场价含税]} } }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="13" dataType="公式" text="" formual="=M9-L9" 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="=D9*L9" 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="=D9*M9" 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="=D9*N9" 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="if([集中配送]==1){ if([供货方]=="甲供" && [配送方式]=="省级"){P9*【甲供材料配送费费率_省级】/100} else if([供货方]=="甲供" && [配送方式]=="市级"){P9*【甲供材料配送费费率_市级】/100} else if([供货方]=="乙供" && [配送方式]=="省级"){P9*【乙供材料配送费费率_省级】/100} else if([供货方]=="乙供" && [配送方式]=="市级"){P9*【乙供材料配送费费率_市级】/100} }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="19" dataType="公式" text="" formual="=if([卸车]==1){if([供货方]=="甲供"){P9*【甲供材料卸车费费率】/100}else{0}}" formualNode="" fieldName="建筑_项目划分.[基础变量.取费甲供材料配送费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="true">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="20" dataType="公式" text="" formual="=if([保管]==1){if([供货方]=="甲供"){P9*【甲供材料保管费费率】/100}else{0}}" formualNode="" fieldName="建筑_项目划分.[基础变量.取费甲供材料配送费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="true">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="9" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="10" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="文本" text="小计:" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="8" dataType="公式" text="" formual="=SUM(I9)" 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="=SUM(J9)" 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="=SUM(K9)" 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="=SUM(O9)" 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="=SUM(P9)" 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="=SUM(Q9)" 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(S9)" 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(T9)" 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="=SUM(U9)" 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="11" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
|
<cells rowNum="12" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[序号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="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>
|
|
</cells>
|
|
<cells rowNum="13" rowHeight="47" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="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="if([拆分]==0){[预算价不含税]}" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[市场价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="if([拆分]==0 and 拆除_项目划分.[专业划分]=="建筑拆除"){ if([类型]!="拆分人工"){[市场价不含税]} else if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价不含税]*(1+拆除_项目划分.[人工调差系数]/100)} else{[市场价不含税]} } } else if([拆分]==0 and 拆除_项目划分.[专业划分]=="安装拆除"){ if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价不含税]*(1+拆除_项目划分.[人工调差系数]/100)} else{[市场价不含税]} } else if([类型]=="材料" or [类型]=="拆分材料"){ if(【安装拆除材机调差方式】=="系数调差"){[预算价不含税]*(1+拆除_项目划分.[材料调差系数]/100)} else{[市场价不含税]} } else if([类型]=="拆分机械"){ if(【安装拆除材机调差方式】=="系数调差"){[预算价不含税]*(1+拆除_项目划分.[机械调差系数]/100)} else{[市场价不含税]} } }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="7" dataType="公式" text="" formual="=G14-F14" 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="=D14*F14" 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="=D14*G14" 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="=D14*H14" 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="if([拆分]==0){[预算价含税]}" 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="if([拆分]==0 and 拆除_项目划分.[专业划分]=="建筑拆除"){ if([类型]!="拆分人工"){[市场价含税]} else if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价含税]*(1+拆除_项目划分.[人工调差系数]/100)} else{[市场价含税]} } } else if([拆分]==0 and 拆除_项目划分.[专业划分]=="安装拆除"){ if([类型]=="拆分人工"){ if(【人工调差方式】=="系数调差"){[预算价含税]*(1+拆除_项目划分.[人工调差系数]/100)} else{[市场价含税]} } else if([类型]=="材料" or [类型]=="拆分材料"){ if(【安装拆除材机调差方式】=="系数调差"){[预算价含税]*(1+拆除_项目划分.[材料调差系数]/100)} else{[市场价含税]} } else if([类型]=="拆分机械"){ if(【安装拆除材机调差方式】=="系数调差"){[预算价含税]*(1+拆除_项目划分.[机械调差系数]/100)} else{[市场价含税]} } }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="13" dataType="公式" text="" formual="=M14-L14" 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="=D14*L14" 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="=D14*M14" 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="=D14*N14" 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="if([集中配送]==1){ if([供货方]=="甲供" && [配送方式]=="省级"){P14*【甲供材料配送费费率_省级】/100} else if([供货方]=="甲供" && [配送方式]=="市级"){P14*【甲供材料配送费费率_市级】/100} else if([供货方]=="乙供" && [配送方式]=="省级"){P14*【乙供材料配送费费率_省级】/100} else if([供货方]=="乙供" && [配送方式]=="市级"){P14*【乙供材料配送费费率_市级】/100} }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="19" dataType="公式" text="" formual="=if([卸车]==1){if([供货方]=="甲供"){P14*【甲供材料卸车费费率】/100}else{0}}" formualNode="" fieldName="建筑_项目划分.[基础变量.取费甲供材料配送费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="true">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="20" dataType="公式" text="" formual="=if([保管]==1){if([供货方]=="甲供"){P14*【甲供材料保管费费率】/100}else{0}}" formualNode="" fieldName="建筑_项目划分.[基础变量.取费甲供材料配送费]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="true">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="14" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="18" dataType="数据字段" text="" formual="=S16-S" 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="=T16-S" 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="=U16-S" 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="15" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="文本" text="小计:" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="8" dataType="公式" text="" formual="=SUM(I14)" 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="=SUM(J14)" 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="=SUM(K14)" 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="=SUM(O14)" 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="=SUM(P14)" 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="=SUM(Q14)" 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="=SUM(S18)" formual="=SUM(S14)" 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="=SUM(T18)" formual="=SUM(T14)" 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="=SUM(U18)" formual="=SUM(U14)" 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="16" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
|
<cells rowNum="17" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="1" dataType="文本" text="总计:" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="8" dataType="公式" text="" formual="=SUM(I6)+SUM(I11)+SUM(I16)" 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="=SUM(J6)+SUM(J11)+SUM(J16)" 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="=SUM(K6)+SUM(K11)+SUM(K16)" 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="=SUM(O6)+SUM(O11)+SUM(O16)" 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="=SUM(P6)+SUM(P11)+SUM(P16)" 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="=SUM(Q6)+SUM(Q11)+SUM(Q16)" 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(S6)+SUM(S11)+SUM(S16)" 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(T6)+SUM(T11)+SUM(T16)" 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="=SUM(U6)+SUM(U11)+SUM(U16)" 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="19" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
|
<cells rowNum="20" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="18" dataType="文本" text="" formual="=S22-S" 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="=T22-S" 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="=U22-S" 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="21" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
|
<cell col="18" dataType="文本" text="" formual="=S23-S" 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="=T23-S" 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="=U23-S" 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="23" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
|
</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="44" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="单位" Filed="单位"/>
|
|
<col colNum="3" colWidth="56" hideColWidth="0" colFormat="1" numberType="1" AdaptiveColWidth="1" checkRate="0" headerFiled="设计用量" Filed="设计用量"/>
|
|
<col colNum="4" colWidth="56" hideColWidth="70" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="供货方" Filed="供货方"/>
|
|
<col colNum="5" colWidth="96" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价" Filed="单价不含税.预算价"/>
|
|
<col colNum="6" colWidth="96" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价" Filed="单价不含税.市场价"/>
|
|
<col colNum="7" colWidth="70" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="单价不含税.价差"/>
|
|
<col colNum="8" colWidth="98" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="预算价" Filed="合价不含税.预算价"/>
|
|
<col colNum="9" colWidth="200" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="市场价" Filed="合价不含税.市场价"/>
|
|
<col colNum="10" colWidth="99" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="价差" Filed="合价不含税.价差"/>
|
|
<col colNum="11" colWidth="82" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="预算价" Filed="单价含税.预算价"/>
|
|
<col colNum="12" colWidth="82" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="市场价" Filed="单价含税.市场价"/>
|
|
<col colNum="13" colWidth="56" hideColWidth="0" colFormat="1" numberType="2" AdaptiveColWidth="1" checkRate="0" headerFiled="价差" Filed="单价含税.价差"/>
|
|
<col colNum="14" colWidth="229" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="预算价" Filed="合价含税.预算价"/>
|
|
<col colNum="15" colWidth="250" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="市场价" Filed="合价含税.市场价"/>
|
|
<col colNum="16" colWidth="264" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="价差" Filed="合价含税.价差"/>
|
|
<col colNum="17" colWidth="70" hideColWidth="80" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费用编码" Filed="费用编码"/>
|
|
<col colNum="18" colWidth="258" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="配送费" Filed="配送费"/>
|
|
<col colNum="19" colWidth="241" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="卸车费" Filed="卸车费"/>
|
|
<col colNum="20" colWidth="235" hideColWidth="-1" colFormat="1" numberType="3" AdaptiveColWidth="0" checkRate="0" headerFiled="保管费" Filed="保管费"/>
|
|
</cols>
|
|
<mergeCells>
|
|
<mergeCell startRow="0" endRow="1" startCol="17" endCol="17"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="0" endCol="0"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="1" endCol="1"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="2" endCol="2"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="3" endCol="3"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="4" endCol="4"/>
|
|
<mergeCell startRow="0" endRow="0" startCol="5" endCol="7"/>
|
|
<mergeCell startRow="0" endRow="0" startCol="8" endCol="10"/>
|
|
<mergeCell startRow="0" endRow="0" startCol="11" endCol="13"/>
|
|
<mergeCell startRow="0" endRow="0" startCol="14" endCol="16"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="18" endCol="18"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="19" endCol="19"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="20" endCol="20"/>
|
|
</mergeCells>
|
|
</ReportCfg>
|