<?xml version="1.0" encoding="UTF-8"?>
<WorkBook xmlVersion="20170720" releaseVersion="9.0.0">
<ElementCaseMobileAttr>
<ElementCaseMobileAttrProvider horizontal="1" vertical="1" zoom="true" refresh="false" isUseHTML="false" isMobileCanvasSize="false" appearRefresh="false" allowFullScreen="false"/>
</ElementCaseMobileAttr>
<Report class="com.fr.report.worksheet.WorkSheet" name="sheet1">
<ReportPageAttr>
<HR/>
<FR/>
<HC/>
<FC/>
</ReportPageAttr>
<ColumnPrivilegeControl/>
<RowPrivilegeControl/>
<RowHeight defaultValue="723900">
<![CDATA[876300,838200,723900,876300,838200,723900,723900,723900,723900,723900]]></RowHeight>
<ColumnWidth defaultValue="2743200">
<![CDATA[3600000,3600000,3600000,3600000,3600000,3600000,2743200]]></ColumnWidth>
<CellElementList>
<C c="0" r="0" s="0">
<O>
<![CDATA[完成数]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="1" r="0" s="0">
<O>
<![CDATA[计划数]]></O>
<PrivilegeControl/>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="2" r="0" s="1">
<O>
<![CDATA[结束日期]]></O>
<PrivilegeControl/>
<Expand dir="0" leftParentDefault="false" left="A1"/>
</C>
<C c="3" r="0" s="0">
<O>
<![CDATA[完成数]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="4" r="0" s="0">
<O>
<![CDATA[计划数]]></O>
<PrivilegeControl/>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="5" r="0" s="0">
<O>
<![CDATA[结束日期]]></O>
<PrivilegeControl/>
<Expand dir="0" leftParentDefault="false" left="A1"/>
</C>
<C c="0" r="1" s="0">
<O t="I">
<![CDATA[85]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="1" r="1" s="0">
<O t="I">
<![CDATA[100]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="2" r="1" s="1">
<O>
<![CDATA[2021-09-11]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="3" r="1" s="0">
<O t="I">
<![CDATA[20]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="4" r="1" s="0">
<O t="I">
<![CDATA[100]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="5" r="1" s="0">
<O>
<![CDATA[2020-09-11]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="0" r="2" cs="2" s="2">
<O t="Formula" class="Formula">
<Attributes>
<![CDATA[="<table  align='center' width='100%' border=0 cellspacing=0 cellpadding=0 height='10'><tr> <td bgcolor='" + if(C3 > 0.5, "#ff0000 ", if(C3 > 0.25, "ff9900", "#00ff00")) + "' width='" + C3 * 100 + "%'></td><td bgcolor='#D9E3F8' width='" + (100 - C3 * 100) + "%'></td></tr> </table>"]]></Attributes>
</O>
<PrivilegeControl/>
<CellGUIAttr showAsHTML="true"/>
<CellPageAttr/>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="2" r="2" s="3">
<O t="Formula" class="Formula">
<Attributes>
<![CDATA[=if(and(today()<=c2,a2>=b2),"100%",if(and(today()<=c2,a2<b2),round(a2/b2,2),"超期未完"))]]></Attributes>
</O>
<PrivilegeControl/>
<HighlightList>
<Highlight class="com.fr.report.cell.cellattr.highlight.DefaultHighlight">
<Name>
<![CDATA[条件属性1]]></Name>
<Condition class="com.fr.data.condition.ListCondition"/>
</Highlight>
</HighlightList>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="3" r="2" cs="2" s="0">
<O t="Formula" class="Formula">
<Attributes>
<![CDATA[="<table  align='center' width='100%' border=0 cellspacing=0 cellpadding=0 height='10'><tr> <td bgcolor='" + if(d2/e2 > 0.5, "#ff0000 ", if(d2/e2 > 0.25, "ff9900", "#00ff00")) + "' width='" + d2/e2 * 100 + "%'></td><td bgcolor='#D9E3F8' width='" + (100 - d2/e2 * 100) + "%'></td></tr> </table>"]]></Attributes>
</O>
<PrivilegeControl/>
<CellGUIAttr showAsHTML="true"/>
<CellPageAttr/>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="5" r="2" s="4">
<O t="Formula" class="Formula">
<Attributes>
<![CDATA[=if(and(today()<=f2,c2>=d2),"100%",if(and(today()<=f2,c2<d2),round(c2/d2,2),"超期未完"))]]></Attributes>
</O>
<PrivilegeControl/>
<HighlightList>
<Highlight class="com.fr.report.cell.cellattr.highlight.DefaultHighlight">
<Name>
<![CDATA[条件属性1]]></Name>
<Condition class="com.fr.data.condition.ListCondition"/>
</Highlight>
</HighlightList>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="0" r="3" s="0">
<O>
<![CDATA[完成数]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="1" r="3" s="0">
<O>
<![CDATA[计划数]]></O>
<PrivilegeControl/>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="2" r="3" s="0">
<O>
<![CDATA[结束日期]]></O>
<PrivilegeControl/>
<Expand dir="0" leftParentDefault="false" left="A1"/>
</C>
<C c="0" r="4" s="0">
<O t="I">
<![CDATA[105]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="1" r="4" s="0">
<O t="I">
<![CDATA[100]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="2" r="4" s="0">
<O>
<![CDATA[2021-09-11]]></O>
<PrivilegeControl/>
<Expand dir="0"/>
</C>
<C c="0" r="5" cs="2" s="0">
<O t="Formula" class="Formula">
<Attributes>
<![CDATA[="<table  align='center' width='100%' border=0 cellspacing=0 cellpadding=0 height='10'><tr> <td bgcolor='" + if(a5/b5 > 0.5, "#ff0000 ", if(a5/b5 > 0.25, "ff9900", "#00ff00")) + "' width='" + a5/b5 * 100 + "%'></td><td bgcolor='#D9E3F8' width='" + (100 - a5/b5 * 100) + "%'></td></tr> </table>"]]></Attributes>
</O>
<PrivilegeControl/>
<CellGUIAttr showAsHTML="true"/>
<CellPageAttr/>
<Expand leftParentDefault="false" left="A1"/>
</C>
<C c="2" r="5" s="4">
<O t="Formula" class="Formula">
<Attributes>
<![CDATA[=if(and(today()<=c5,a5>=b5),"100%",if(and(today()<=c5,a5<b5),round(a5/b5,2),"超期未完"))]]></Attributes>
</O>
<PrivilegeControl/>
<HighlightList>
<Highlight class="com.fr.report.cell.cellattr.highlight.DefaultHighlight">
<Name>
<![CDATA[条件属性1]]></Name>
<Condition class="com.fr.data.condition.ListCondition"/>
</Highlight>
</HighlightList>
<Expand leftParentDefault="false" left="A1"/>
</C>
</CellElementList>
<ReportAttrSet>
<ReportSettings headerHeight="0" footerHeight="0">
<PaperSetting>
<PaperSize width="42768000" height="60480000"/>
<Margin top="986400" left="2743200" bottom="986400" right="2743200"/>
</PaperSetting>
<Background name="ColorBackground" color="-1"/>
</ReportSettings>
<Header reportPageType="0">
<Background name="NullBackground"/>
<LeftList/>
<CenterList/>
<RightList/>
</Header>
<Footer reportPageType="0">
<Background name="NullBackground"/>
<LeftList/>
<CenterList/>
<RightList/>
</Footer>
</ReportAttrSet>
<PrivilegeControl/>
</Report>
<ReportParameterAttr>
<Attributes showWindow="true" delayPlaying="true" windowPosition="1" align="0" useParamsTemplate="true"/>
<PWTitle>
<![CDATA[参数]]></PWTitle>
</ReportParameterAttr>
<StyleList>
<Style horizontal_alignment="0" imageLayout="1">
<FRFont name="微软雅黑" style="0" size="96" foreground="-6710887"/>
<Background name="ColorBackground" color="-10066330"/>
<Border>
<Top color="-16777216"/>
<Bottom color="-16777216"/>
<Left color="-16777216"/>
<Right color="-16777216"/>
</Border>
</Style>
<Style horizontal_alignment="0" imageLayout="1">
<FRFont name="微软雅黑" style="0" size="96" foreground="-6710887"/>
<Background name="ColorBackground" color="-10066330"/>
<Border>
<Top color="-1"/>
<Bottom color="-1"/>
<Left color="-1"/>
<Right style="1" color="-1"/>
</Border>
</Style>
<Style horizontal_alignment="0" imageLayout="1">
<FRFont name="微软雅黑" style="0" size="96" foreground="-6710887"/>
<Background name="ColorBackground" color="-10066330"/>
<Border>
<Top color="-1"/>
<Bottom style="1" color="-1"/>
<Left color="-1"/>
<Right color="-1"/>
</Border>
</Style>
<Style horizontal_alignment="0" imageLayout="1">
<Format class="com.fr.base.CoreDecimalFormat">
<![CDATA[#0.00%]]></Format>
<FRFont name="微软雅黑" style="0" size="96" foreground="-6710887"/>
<Background name="ColorBackground" color="-10066330"/>
<Border>
<Top color="-1"/>
<Bottom style="1" color="-1"/>
<Left color="-1"/>
<Right style="1" color="-1"/>
</Border>
</Style>
<Style horizontal_alignment="0" imageLayout="1">
<Format class="com.fr.base.CoreDecimalFormat">
<![CDATA[#0.00%]]></Format>
<FRFont name="微软雅黑" style="0" size="96" foreground="-6710887"/>
<Background name="ColorBackground" color="-10066330"/>
<Border>
<Top color="-16777216"/>
<Bottom color="-16777216"/>
<Left color="-16777216"/>
<Right color="-16777216"/>
</Border>
</Style>
</StyleList>
<DesignerVersion DesignerVersion="JAA"/>
<PreviewType PreviewType="0"/>
<TemplateID TemplateID="e3e76d7b-17df-4bde-916b-e6d8c4ce2f94"/>
<TemplateIdAttMark class="com.fr.base.iofileattr.TemplateIdAttrMark">
<TemplateIdAttMark TemplateId="6bd841d9-03d8-4060-b5ee-b12ab095ca72"/>
</TemplateIdAttMark>
</WorkBook>
