1181 lines
124 KiB
XML
1181 lines
124 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
||
<ReportCfg BuildThreadCount="1" templateVersion="1.0" syncTableHeader="是">
|
||
<GlobalFilters/>
|
||
<RowConfigs>
|
||
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
||
<commonFilterList/>
|
||
<conditionFilterList/>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="安装_项目划分" DataSourceName="安装_项目划分" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业划分]=“安装”" locateLabel="" datasetGroupExpression="" groupName="工程量/安装">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[存在消耗量]" 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"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第3组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【按组合件维度展现】==0){1}" ConditionName="按组合件维度展现" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(C3)==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="安装_消耗量" DataSourceName="安装_消耗量" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业划分]=“安装”" locateLabel="" datasetGroupExpression="" groupName="工程量/安装">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[拆分子级]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]!="注解") { if([数量]=="" or [数量]==0){1} } else{0}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="安装_计算明细" DataSourceName="安装_计算明细" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“安装”" locateLabel="" datasetGroupExpression="" groupName="工程量/安装">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属消耗量id]" LeftShowName="" RightValue="安装_消耗量.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【显示计算明细】==0){1}" ConditionName="显示计算明细" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(F4==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</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(C2==""){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="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"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第3组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【按组合件维度展现】==0){1}" ConditionName="按组合件维度展现" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(C7)==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="拆除_消耗量" DataSourceName="拆除_消耗量" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“拆除”" locateLabel="" datasetGroupExpression="" groupName="工程量/拆除">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[拆分子级]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]!="注解") { if([数量]=="" or [数量]==0){1} } else{0}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="拆除_计算明细" DataSourceName="拆除_计算明细" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“拆除”" locateLabel="" datasetGroupExpression="" groupName="工程量/拆除">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属消耗量id]" LeftShowName="" RightValue="拆除_消耗量.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【显示计算明细】==0){1}" ConditionName="显示计算明细" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(F8==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</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(C6==""){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="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"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第3组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【按组合件维度展现】==0){1}" ConditionName="按组合件维度展现" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(C11)==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="余物清理_消耗量" DataSourceName="余物清理_消耗量" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“余物清理”" locateLabel="" datasetGroupExpression="" groupName="工程量/余物清理">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[拆分子级]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]!="注解") { if([数量]=="" or [数量]==0){1} } else{0}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="余物清理_计算明细" DataSourceName="余物清理_计算明细" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="[专业类型]=“余物清理”" locateLabel="" datasetGroupExpression="" groupName="工程量/余物清理">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属消耗量id]" LeftShowName="" RightValue="余物清理_消耗量.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【显示计算明细】==0){1}" ConditionName="显示计算明细" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(F12==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</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(C10==""){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(【按组合件维度展现】==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(A15)==0){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(【按组合件维度展现】=="1"){1}" ConditionName="按组合件维度展现" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([数量]==0 or [数量]==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
<rowConfig RowName="组合件_计算明细" DataSourceName="组合件_计算明细" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="组合件">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【显示计算明细】==0){1}" ConditionName="显示计算明细" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(F16==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属组合件id]" LeftShowName="" RightValue="组合件_组合件.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属消耗量代理id]" LeftShowName="" RightValue="" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
<rowConfig RowName="组合件_消耗量" DataSourceName="组合件_消耗量" RowType="数据行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="组合件">
|
||
<commonFilterList/>
|
||
<conditionFilterList>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(C17==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="不等于" LeftProperty="[拆分子级]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]!="注解"){if([数量]!=0){1}else{0}}else{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(【显示计算明细】==0){1}" ConditionName="显示计算明细" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(F18==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属消耗量代理id]" LeftShowName="" RightValue="组合件_消耗量.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</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(【按组合件维度展现】==0){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(COUNT(A20)==0){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(C20==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(【按组合件维度展现】==1){1}" ConditionName="按组合件维度展现" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第2组" CompareOperator="不等于" LeftProperty="[拆分子级]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([类型]!="注解"){if([数量]!=0){1}else{0}}else{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(【显示计算明细】==0){1}" ConditionName="显示计算明细" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(F21==""){1}" ConditionName="" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
||
<conditionFilter ConditionType="普通条件" ValueType="数据列" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属消耗量代理id]" LeftShowName="" RightValue="组合件_其他工程量消耗量.[id]" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
||
</conditionFilterList>
|
||
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
||
<sorts/>
|
||
</rowConfig>
|
||
</rowConfig>
|
||
</RowConfigs>
|
||
<rows freezingRow="0" freezingCol="-1" startRow="0" startCol="0">
|
||
<cells rowNum="0" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="文本" text="编码" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="文本" text="项目名称" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="文本" text="规格型号" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="文本" text="单位" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="文本" text="计算式" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="文本" text="数量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="文本" text="单价不含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="文本" text="单价含税" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="文本" text="损耗率(%)" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="true" rightBorder="true" topBorder="true" bottomBorder="true" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="文本" text="运杂费率(%)" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="true" rightBorder="true" topBorder="true" bottomBorder="true" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="文本" text="单重(kg)" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="true" rightBorder="true" topBorder="true" bottomBorder="true" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="文本" text="供货方" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="true" rightBorder="true" topBorder="true" bottomBorder="true" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="文本" text="备注" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="true" rightBorder="true" topBorder="true" bottomBorder="true" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="1" rowHeight="27" HideRowHeight="-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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="2" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[类型]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[规格型号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价不含税]} else if([类型]=="一笔性费用" or [类型]=="应急措施费"){[单价不含税]} else if([类型]=="定额" ){[人工费]*[人工系数]*[定额系数]+[材料费]*[材料系数]*[定额系数]+[机械费]*[定额系数]*[机械系数]} else{[预算价不含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价含税]} else if([类型]=="一笔性费用" ){[单价含税]} else if([类型]=="定额" ){0} else{[预算价含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="[运杂费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[供货方]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="3" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="4" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
||
<cells rowNum="5" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="6" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[规格型号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价不含税]} else if([类型]=="一笔性费用" or [类型]=="应急措施费"){[单价不含税]} else if([类型]=="定额" ){[人工费]*[人工系数]*[定额系数]+[材料费]*[材料系数]*[定额系数]+[机械费]*[定额系数]*[机械系数]} else{[预算价不含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价含税]} else if([类型]=="一笔性费用" ){[单价含税]} else if([类型]=="定额" ){0} else{[预算价含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="[运杂费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[供货方]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="8" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
||
<cells rowNum="9" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[规格型号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价不含税]} else if([类型]=="一笔性费用" or [类型]=="应急措施费"){[单价不含税]} else if([类型]=="定额" ){[人工费]*[人工系数]*[定额系数]+[材料费]*[材料系数]*[定额系数]+[机械费]*[定额系数]*[机械系数]} else{[预算价不含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价含税]} else if([类型]=="一笔性费用" ){[单价含税]} else if([类型]=="定额" ){0} else{[预算价含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="[运杂费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([拆分]==0){[供货方]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="11" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="12" rowHeight="30" HideRowHeight="-1" AdaptiveRowHeight="true"/>
|
||
<cells rowNum="13" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="组合件列表" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[规格型号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="16" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[规格型号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价不含税]} else if([类型]=="一笔性费用" or [类型]=="人工" or [类型]=="材料" or [类型]=="机械"){[单价不含税]} else if([类型]=="定额" ){[人工费]*[人工系数]*[定额系数]+[材料费]*[材料系数]*[定额系数]+[机械费]*[定额系数]*[机械系数]} else if([类型]=="应急措施费"){[单价不含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价含税]} else if([类型]=="一笔性费用" or [类型]=="人工" or [类型]=="材料" or [类型]=="机械"){[单价含税]} else if([类型]=="定额" ){0}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="[运杂费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="17" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="18" rowHeight="27" HideRowHeight="-1" AdaptiveRowHeight="true">
|
||
<cell col="2" dataType="文本" text="其他工程量" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="19" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[规格型号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单位]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价不含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价不含税]} else if([类型]=="一笔性费用" or [类型]=="人工" or [类型]=="材料" or [类型]=="机械"){[单价不含税]} else if([类型]=="定额" ){[人工费]*[人工系数]*[定额系数]+[材料费]*[材料系数]*[定额系数]+[机械费]*[定额系数]*[机械系数]} else if([类型]=="应急措施费"){[单价不含税]}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="8" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单价含税]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="公式" formual="if([类型]=="设备" or [类型]=="主材"){[市场价含税]} else if([类型]=="一笔性费用" or [类型]=="人工" or [类型]=="材料" or [类型]=="机械"){[单价含税]} else if([类型]=="定额" ){0}" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="[损耗]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="[运杂费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="[单重]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="12" dataType="数据字段" text="" formual="" formualNode="" fieldName="[供货方]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="13" dataType="数据字段" text="" formual="" formualNode="" fieldName="[备注]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="20" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[计算式]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[数量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
<cells rowNum="21" 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" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="7" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="9" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="10" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
<cell col="11" dataType="数据字段" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false" mergeCell="false">
|
||
<CellDataSet CellDataSetType="默认" collectFunction="">
|
||
<CellShowData ShowType="常用" formual="" commonFuntionName="" commonFuntion=""/>
|
||
</CellDataSet>
|
||
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
||
</cell>
|
||
</cells>
|
||
</rows>
|
||
<cols>
|
||
<col colNum="0" colWidth="79" hideColWidth="35" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="类别" Filed="类别" dynamicGenerate="否"/>
|
||
<col colNum="1" colWidth="62" hideColWidth="175" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="编码" Filed="编码" dynamicGenerate="否"/>
|
||
<col colNum="2" colWidth="69" hideColWidth="70" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="项目名称" Filed="项目名称" dynamicGenerate="否"/>
|
||
<col colNum="3" colWidth="76" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="规格型号" Filed="规格型号" dynamicGenerate="否"/>
|
||
<col colNum="4" colWidth="67" hideColWidth="70" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="单位" Filed="单位" dynamicGenerate="否"/>
|
||
<col colNum="5" colWidth="62" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="计算式" Filed="计算式" dynamicGenerate="否"/>
|
||
<col colNum="6" colWidth="76" hideColWidth="70" colFormat="1" numberType="1" AdaptiveColWidth="0" checkRate="0" headerFiled="数量" Filed="数量" dynamicGenerate="否"/>
|
||
<col colNum="7" colWidth="100" hideColWidth="70" colFormat="1" numberType="2" AdaptiveColWidth="0" checkRate="0" headerFiled="单价不含税" Filed="单价不含税" dynamicGenerate="否"/>
|
||
<col colNum="8" colWidth="102" hideColWidth="-1" colFormat="1" numberType="2" AdaptiveColWidth="0" checkRate="0" headerFiled="单价含税" Filed="单价含税" dynamicGenerate="否"/>
|
||
<col colNum="9" colWidth="91" hideColWidth="70" colFormat="1" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="损耗率(%)" Filed="损耗率(%)" dynamicGenerate="否"/>
|
||
<col colNum="10" colWidth="112" hideColWidth="70" colFormat="1" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="运杂费率(%)" Filed="运杂费率(%)" dynamicGenerate="否"/>
|
||
<col colNum="11" colWidth="98" hideColWidth="-1" colFormat="1" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="单重(kg)" Filed="单重(kg)" dynamicGenerate="否"/>
|
||
<col colNum="12" colWidth="71" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="供货方" Filed="供货方" dynamicGenerate="否"/>
|
||
<col colNum="13" colWidth="72" hideColWidth="-1" colFormat="2" numberType="0" AdaptiveColWidth="0" checkRate="0" headerFiled="备注" Filed="备注" dynamicGenerate="否"/>
|
||
</cols>
|
||
<mergeCells/>
|
||
</ReportCfg>
|