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.