L.2.2.5 Supporting Features
L.2.2.5 Supporting Features
The supporting feature definitions follow the cell table data:
<sheetProtection objects="0" scenarios="0"/>
<autoFilter ref="D5:H11">
<filterColumn colId="0">
<filters>
<filter val="A"/>
</filters>
</filterColumn>
<filterColumn colId="1">
<customFilters and="1">
<customFilter operator="greaterThan" val="0"/>
<customFilter operator="lessThan" val="0.7"/>
</customFilters>
</filterColumn>
</autoFilter>
<mergeCells>
<mergeCell ref="D13:H14"/>
</mergeCells>
<conditionalFormatting sqref="H6:H11">
<cfRule type="dataBar" priority="3" stopIfTrue="0">
<formula>MAX(IF(ISBLANK(H6:H11), "", IF(ISERROR(H6:H11), "",
H6:H11)))</formula>
<formula>MIN(IF(ISBLANK(H6:H11), "", IF(ISERROR(H6:H11), "",
H6:H11)))</formula>
<dataBar minLength="10" maxLength="90" showValue="1">
<cfvo type="min" val="0"/>
<cfvo type="max" val="0"/>
<color rgb="FF63C384"/>
</dataBar>
</cfRule>
</conditionalFormatting>
<conditionalFormatting sqref="G6:G11">
<cfRule type="cellIs" dxfId="0" priority="1" stopIfTrue="0"
operator="greaterThan">
<formula>0.5</formula>
</cfRule>
</conditionalFormatting>
<printOptions/>
<pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75"
header="0.3" footer="0.3"/>
<pageSetup orientation="portrait" horizontalDpi="300" verticalDpi="300"/>
<headerFooter/>
These elements are discussed in more detail in the following subclauses.
Last updated on