sc/qa/unit/data/functions/financial/fods/mirr.fods

   1 <?xml version="1.0" encoding="UTF-8"?>
   2
   3 <office:document xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.spreadsheet">
   4  <office:styles>
   5   <style:default-style style:family="table-cell">
   6    <style:paragraph-properties style:tab-stop-distance="36pt"/>
   7    <style:text-properties style:font-name="Liberation Sans" fo:language="en" fo:country="US" style:font-name-asian="DejaVu Sans" style:language-asian="zh" style:country-asian="CN" style:font-name-complex="DejaVu Sans" style:language-complex="hi" style:country-complex="IN"/>
   8   </style:default-style>
   9   <number:number-style style:name="N0">
  10    <number:number number:min-integer-digits="1"/>
  11   </number:number-style>
  12   <number:currency-style style:name="N122P0" style:volatile="true">
  13    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  14    <number:text> </number:text>
  15    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
  16   </number:currency-style>
  17   <number:currency-style style:name="N122">
  18    <style:text-properties fo:color="#ff0000"/>
  19    <number:text>-</number:text>
  20    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  21    <number:text> </number:text>
  22    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
  23    <style:map style:condition="value()&gt;=0" style:apply-style-name="N122P0"/>
  24   </number:currency-style>
  25   <number:number-style style:name="N126P0" style:volatile="true">
  26    <loext:fill-character> </loext:fill-character>
  27    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  28    <number:text> </number:text>
  29   </number:number-style>
  30   <number:number-style style:name="N126P1" style:volatile="true">
  31    <loext:fill-character> </loext:fill-character>
  32    <number:text>(</number:text>
  33    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  34    <number:text>)</number:text>
  35   </number:number-style>
  36   <number:number-style style:name="N126P2" style:volatile="true">
  37    <loext:fill-character> </loext:fill-character>
  38    <number:text>-</number:text>
  39    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/>
  40    <number:text> </number:text>
  41   </number:number-style>
  42   <number:text-style style:name="N126">
  43    <number:text-content/>
  44    <number:text> </number:text>
  45    <style:map style:condition="value()&gt;0" style:apply-style-name="N126P0"/>
  46    <style:map style:condition="value()&lt;0" style:apply-style-name="N126P1"/>
  47    <style:map style:condition="value()=0" style:apply-style-name="N126P2"/>
  48   </number:text-style>
  49   <number:currency-style style:name="N128P0" style:volatile="true">
  50    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  51    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  52   </number:currency-style>
  53   <number:currency-style style:name="N128">
  54    <number:text>-</number:text>
  55    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  56    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  57    <style:map style:condition="value()&gt;=0" style:apply-style-name="N128P0"/>
  58   </number:currency-style>
  59   <number:currency-style style:name="N130P0" style:volatile="true">
  60    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  61    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  62   </number:currency-style>
  63   <number:currency-style style:name="N130">
  64    <number:text>-</number:text>
  65    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  66    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  67    <style:map style:condition="value()&gt;=0" style:apply-style-name="N130P0"/>
  68   </number:currency-style>
  69   <number:currency-style style:name="N131P0" style:volatile="true">
  70    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  71    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  72   </number:currency-style>
  73   <number:currency-style style:name="N131">
  74    <style:text-properties fo:color="#ff0000"/>
  75    <number:text>-</number:text>
  76    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  77    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
  78    <style:map style:condition="value()&gt;=0" style:apply-style-name="N131P0"/>
  79   </number:currency-style>
  80   <number:currency-style style:name="N132P0" style:volatile="true">
  81    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  82    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  83   </number:currency-style>
  84   <number:currency-style style:name="N132">
  85    <style:text-properties fo:color="#ff0000"/>
  86    <number:text>-</number:text>
  87    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  88    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
  89    <style:map style:condition="value()&gt;=0" style:apply-style-name="N132P0"/>
  90   </number:currency-style>
  91   <number:currency-style style:name="N134P0" style:volatile="true">
  92    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  93    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
  94   </number:currency-style>
  95   <number:currency-style style:name="N134">
  96    <style:text-properties fo:color="#ff0000"/>
  97    <number:text>-</number:text>
  98    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
  99    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 100    <style:map style:condition="value()&gt;=0" style:apply-style-name="N134P0"/>
 101   </number:currency-style>
 102   <number:number-style style:name="N136P0" style:volatile="true">
 103    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 104    <number:text> </number:text>
 105   </number:number-style>
 106   <number:number-style style:name="N136">
 107    <number:text>(</number:text>
 108    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 109    <number:text>)</number:text>
 110    <style:map style:condition="value()&gt;=0" style:apply-style-name="N136P0"/>
 111   </number:number-style>
 112   <number:number-style style:name="N138P0" style:volatile="true">
 113    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 114    <number:text> </number:text>
 115   </number:number-style>
 116   <number:number-style style:name="N138">
 117    <number:text>(</number:text>
 118    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 119    <number:text>)</number:text>
 120    <style:map style:condition="value()&gt;=0" style:apply-style-name="N138P0"/>
 121   </number:number-style>
 122   <number:currency-style style:name="N140P0" style:volatile="true">
 123    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 124    <loext:fill-character> </loext:fill-character>
 125    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 126   </number:currency-style>
 127   <number:currency-style style:name="N140">
 128    <number:text>-</number:text>
 129    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 130    <loext:fill-character> </loext:fill-character>
 131    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 132    <style:map style:condition="value()&gt;=0" style:apply-style-name="N140P0"/>
 133   </number:currency-style>
 134   <number:currency-style style:name="N142P0" style:volatile="true">
 135    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 136    <loext:fill-character> </loext:fill-character>
 137    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 138   </number:currency-style>
 139   <number:currency-style style:name="N142">
 140    <number:text>-</number:text>
 141    <number:currency-symbol number:language="en" number:country="GB">£</number:currency-symbol>
 142    <loext:fill-character> </loext:fill-character>
 143    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 144    <style:map style:condition="value()&gt;=0" style:apply-style-name="N142P0"/>
 145   </number:currency-style>
 146   <number:currency-style style:name="N144P0" style:volatile="true">
 147    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 148    <number:text> </number:text>
 149    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 150   </number:currency-style>
 151   <number:currency-style style:name="N144">
 152    <number:text>-</number:text>
 153    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 154    <number:text> </number:text>
 155    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 156    <style:map style:condition="value()&gt;=0" style:apply-style-name="N144P0"/>
 157   </number:currency-style>
 158   <number:currency-style style:name="N145P0" style:volatile="true">
 159    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 160    <number:text> </number:text>
 161    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 162   </number:currency-style>
 163   <number:currency-style style:name="N145">
 164    <number:text>-</number:text>
 165    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 166    <number:text> </number:text>
 167    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 168    <style:map style:condition="value()&gt;=0" style:apply-style-name="N145P0"/>
 169   </number:currency-style>
 170   <number:currency-style style:name="N146P0" style:volatile="true">
 171    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 172    <number:text> </number:text>
 173    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 174   </number:currency-style>
 175   <number:currency-style style:name="N146">
 176    <style:text-properties fo:color="#ff0000"/>
 177    <number:text>-</number:text>
 178    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 179    <number:text> </number:text>
 180    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 181    <style:map style:condition="value()&gt;=0" style:apply-style-name="N146P0"/>
 182   </number:currency-style>
 183   <number:currency-style style:name="N148P0" style:volatile="true">
 184    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 185    <number:text> </number:text>
 186    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 187   </number:currency-style>
 188   <number:currency-style style:name="N148">
 189    <style:text-properties fo:color="#ff0000"/>
 190    <number:text>-</number:text>
 191    <number:number number:decimal-places="2" loext:min-decimal-places="0" number:min-integer-digits="1" number:decimal-replacement="--" number:grouping="true"/>
 192    <number:text> </number:text>
 193    <number:currency-symbol number:language="cs" number:country="CZ">Kč</number:currency-symbol>
 194    <style:map style:condition="value()&gt;=0" style:apply-style-name="N148P0"/>
 195   </number:currency-style>
 196   <number:number-style style:name="N149">
 197    <number:number number:decimal-places="9" loext:min-decimal-places="9" number:min-integer-digits="1"/>
 198   </number:number-style>
 199   <number:number-style style:name="N150">
 200    <number:number number:decimal-places="8" loext:min-decimal-places="8" number:min-integer-digits="1"/>
 201   </number:number-style>
 202   <number:number-style style:name="N151">
 203    <number:number number:decimal-places="10" loext:min-decimal-places="10" number:min-integer-digits="1"/>
 204   </number:number-style>
 205   <number:number-style style:name="N152">
 206    <number:number number:decimal-places="11" loext:min-decimal-places="11" number:min-integer-digits="1"/>
 207   </number:number-style>
 208   <number:number-style style:name="N153">
 209    <number:number number:decimal-places="12" loext:min-decimal-places="12" number:min-integer-digits="1"/>
 210   </number:number-style>
 211   <number:number-style style:name="N154">
 212    <number:number number:decimal-places="13" loext:min-decimal-places="13" number:min-integer-digits="1"/>
 213   </number:number-style>
 214   <number:number-style style:name="N155">
 215    <number:number number:decimal-places="14" loext:min-decimal-places="14" number:min-integer-digits="1"/>
 216   </number:number-style>
 217   <number:number-style style:name="N156">
 218    <number:number number:decimal-places="15" loext:min-decimal-places="15" number:min-integer-digits="1"/>
 219   </number:number-style>
 220   <number:number-style style:name="N157">
 221    <number:number number:decimal-places="16" loext:min-decimal-places="16" number:min-integer-digits="1"/>
 222   </number:number-style>
 223   <number:number-style style:name="N158">
 224    <number:number number:decimal-places="17" loext:min-decimal-places="17" number:min-integer-digits="1"/>
 225   </number:number-style>
 226   <number:number-style style:name="N159">
 227    <number:number number:decimal-places="18" loext:min-decimal-places="18" number:min-integer-digits="1"/>
 228   </number:number-style>
 229   <number:number-style style:name="N160">
 230    <number:number number:decimal-places="1" loext:min-decimal-places="1" number:min-integer-digits="1"/>
 231   </number:number-style>
 232   <number:number-style style:name="N161">
 233    <number:number number:decimal-places="3" loext:min-decimal-places="3" number:min-integer-digits="1"/>
 234   </number:number-style>
 235   <number:number-style style:name="N162">
 236    <number:number number:decimal-places="4" loext:min-decimal-places="4" number:min-integer-digits="1"/>
 237   </number:number-style>
 238   <number:number-style style:name="N163">
 239    <number:number number:decimal-places="5" loext:min-decimal-places="5" number:min-integer-digits="1"/>
 240   </number:number-style>
 241   <number:number-style style:name="N164">
 242    <number:number number:decimal-places="6" loext:min-decimal-places="6" number:min-integer-digits="1"/>
 243   </number:number-style>
 244   <number:number-style style:name="N165">
 245    <number:number number:decimal-places="7" loext:min-decimal-places="7" number:min-integer-digits="1"/>
 246   </number:number-style>
 247   <number:currency-style style:name="N167P0" style:volatile="true">
 248    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 249    <number:text> </number:text>
 250    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 251   </number:currency-style>
 252   <number:currency-style style:name="N167">
 253    <style:text-properties fo:color="#ff0000"/>
 254    <number:text>-</number:text>
 255    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 256    <number:text> </number:text>
 257    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 258    <style:map style:condition="value()&gt;=0" style:apply-style-name="N167P0"/>
 259   </number:currency-style>
 260   <number:number-style style:name="N169P0" style:volatile="true">
 261    <number:text/>
 262   </number:number-style>
 263   <number:currency-style style:name="N169">
 264    <style:text-properties fo:color="#ff0000"/>
 265    <number:text>-</number:text>
 266    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 267    <number:text> </number:text>
 268    <number:currency-symbol number:language="fr" number:country="FR">€</number:currency-symbol>
 269    <style:map style:condition="value()&gt;=0" style:apply-style-name="N169P0"/>
 270   </number:currency-style>
 271   <number:date-style style:name="N170">
 272    <number:day-of-week/>
 273    <number:text> </number:text>
 274    <number:day number:style="long"/>
 275    <number:text>/</number:text>
 276    <number:month number:style="long"/>
 277    <number:text>/</number:text>
 278    <number:year/>
 279   </number:date-style>
 280   <number:date-style style:name="N171">
 281    <number:day-of-week number:style="long"/>
 282    <number:text>  </number:text>
 283    <number:day number:style="long"/>
 284    <number:text>/</number:text>
 285    <number:month number:style="long"/>
 286    <number:text>/</number:text>
 287    <number:year/>
 288   </number:date-style>
 289   <number:currency-style style:name="N173P0" style:volatile="true">
 290    <number:currency-symbol number:language="de" number:country="AT">€</number:currency-symbol>
 291    <number:text> </number:text>
 292    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 293   </number:currency-style>
 294   <number:currency-style style:name="N173">
 295    <style:text-properties fo:color="#ff0000"/>
 296    <number:text>-</number:text>
 297    <number:currency-symbol number:language="de" number:country="AT">€</number:currency-symbol>
 298    <number:text> </number:text>
 299    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 300    <style:map style:condition="value()&gt;=0" style:apply-style-name="N173P0"/>
 301   </number:currency-style>
 302   <number:number-style style:name="N175P0" style:volatile="true">
 303    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 304    <number:text> Kč</number:text>
 305   </number:number-style>
 306   <number:number-style style:name="N175">
 307    <number:text>-</number:text>
 308    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 309    <number:text> Kč</number:text>
 310    <style:map style:condition="value()&gt;=0" style:apply-style-name="N175P0"/>
 311   </number:number-style>
 312   <number:number-style style:name="N176P0" style:volatile="true">
 313    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 314    <number:text> Kč</number:text>
 315   </number:number-style>
 316   <number:number-style style:name="N176">
 317    <style:text-properties fo:color="#ff0000"/>
 318    <number:text>-</number:text>
 319    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 320    <number:text> Kč</number:text>
 321    <style:map style:condition="value()&gt;=0" style:apply-style-name="N176P0"/>
 322   </number:number-style>
 323   <number:number-style style:name="N178P0" style:volatile="true">
 324    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 325    <number:text> Kč</number:text>
 326   </number:number-style>
 327   <number:number-style style:name="N178">
 328    <number:text>-</number:text>
 329    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 330    <number:text> Kč</number:text>
 331    <style:map style:condition="value()&gt;=0" style:apply-style-name="N178P0"/>
 332   </number:number-style>
 333   <number:number-style style:name="N179P0" style:volatile="true">
 334    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 335    <number:text> Kč</number:text>
 336   </number:number-style>
 337   <number:number-style style:name="N179">
 338    <style:text-properties fo:color="#ff0000"/>
 339    <number:text>-</number:text>
 340    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 341    <number:text> Kč</number:text>
 342    <style:map style:condition="value()&gt;=0" style:apply-style-name="N179P0"/>
 343   </number:number-style>
 344   <number:number-style style:name="N180P0" style:volatile="true">
 345    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 346   </number:number-style>
 347   <number:number-style style:name="N180">
 348    <number:text>-</number:text>
 349    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 350    <style:map style:condition="value()&gt;=0" style:apply-style-name="N180P0"/>
 351   </number:number-style>
 352   <number:number-style style:name="N181P0" style:volatile="true">
 353    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 354   </number:number-style>
 355   <number:number-style style:name="N181">
 356    <style:text-properties fo:color="#ff0000"/>
 357    <number:text>-</number:text>
 358    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 359    <style:map style:condition="value()&gt;=0" style:apply-style-name="N181P0"/>
 360   </number:number-style>
 361   <number:number-style style:name="N182P0" style:volatile="true">
 362    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 363   </number:number-style>
 364   <number:number-style style:name="N182">
 365    <number:text>-</number:text>
 366    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 367    <style:map style:condition="value()&gt;=0" style:apply-style-name="N182P0"/>
 368   </number:number-style>
 369   <number:number-style style:name="N183P0" style:volatile="true">
 370    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 371   </number:number-style>
 372   <number:number-style style:name="N183">
 373    <style:text-properties fo:color="#ff0000"/>
 374    <number:text>-</number:text>
 375    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 376    <style:map style:condition="value()&gt;=0" style:apply-style-name="N183P0"/>
 377   </number:number-style>
 378   <number:number-style style:name="N187P0" style:volatile="true">
 379    <loext:fill-character> </loext:fill-character>
 380    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 381    <number:text>      </number:text>
 382   </number:number-style>
 383   <number:number-style style:name="N187P1" style:volatile="true">
 384    <loext:text>-</loext:text>
 385    <loext:fill-character> </loext:fill-character>
 386    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 387    <number:text>      </number:text>
 388   </number:number-style>
 389   <number:number-style style:name="N187P2" style:volatile="true">
 390    <loext:fill-character> </loext:fill-character>
 391    <number:text>-      </number:text>
 392   </number:number-style>
 393   <number:text-style style:name="N187">
 394    <number:text-content/>
 395    <number:text> </number:text>
 396    <style:map style:condition="value()&gt;0" style:apply-style-name="N187P0"/>
 397    <style:map style:condition="value()&lt;0" style:apply-style-name="N187P1"/>
 398    <style:map style:condition="value()=0" style:apply-style-name="N187P2"/>
 399   </number:text-style>
 400   <number:number-style style:name="N191P0" style:volatile="true">
 401    <loext:fill-character> </loext:fill-character>
 402    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 403    <number:text> Kč </number:text>
 404   </number:number-style>
 405   <number:number-style style:name="N191P1" style:volatile="true">
 406    <loext:text>-</loext:text>
 407    <loext:fill-character> </loext:fill-character>
 408    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
 409    <number:text> Kč </number:text>
 410   </number:number-style>
 411   <number:number-style style:name="N191P2" style:volatile="true">
 412    <loext:fill-character> </loext:fill-character>
 413    <number:text>- Kč </number:text>
 414   </number:number-style>
 415   <number:text-style style:name="N191">
 416    <number:text-content/>
 417    <number:text> </number:text>
 418    <style:map style:condition="value()&gt;0" style:apply-style-name="N191P0"/>
 419    <style:map style:condition="value()&lt;0" style:apply-style-name="N191P1"/>
 420    <style:map style:condition="value()=0" style:apply-style-name="N191P2"/>
 421   </number:text-style>
 422   <number:number-style style:name="N195P0" style:volatile="true">
 423    <loext:fill-character> </loext:fill-character>
 424    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 425    <number:text>      </number:text>
 426   </number:number-style>
 427   <number:number-style style:name="N195P1" style:volatile="true">
 428    <loext:text>-</loext:text>
 429    <loext:fill-character> </loext:fill-character>
 430    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 431    <number:text>      </number:text>
 432   </number:number-style>
 433   <number:number-style style:name="N195P2" style:volatile="true">
 434    <loext:fill-character> </loext:fill-character>
 435    <number:text>-</number:text>
 436    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/>
 437    <number:text>      </number:text>
 438   </number:number-style>
 439   <number:text-style style:name="N195">
 440    <number:text-content/>
 441    <number:text> </number:text>
 442    <style:map style:condition="value()&gt;0" style:apply-style-name="N195P0"/>
 443    <style:map style:condition="value()&lt;0" style:apply-style-name="N195P1"/>
 444    <style:map style:condition="value()=0" style:apply-style-name="N195P2"/>
 445   </number:text-style>
 446   <number:number-style style:name="N199P0" style:volatile="true">
 447    <loext:fill-character> </loext:fill-character>
 448    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 449    <number:text> Kč </number:text>
 450   </number:number-style>
 451   <number:number-style style:name="N199P1" style:volatile="true">
 452    <loext:text>-</loext:text>
 453    <loext:fill-character> </loext:fill-character>
 454    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 455    <number:text> Kč </number:text>
 456   </number:number-style>
 457   <number:number-style style:name="N199P2" style:volatile="true">
 458    <loext:fill-character> </loext:fill-character>
 459    <number:text>-</number:text>
 460    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/>
 461    <number:text> Kč </number:text>
 462   </number:number-style>
 463   <number:text-style style:name="N199">
 464    <number:text-content/>
 465    <number:text> </number:text>
 466    <style:map style:condition="value()&gt;0" style:apply-style-name="N199P0"/>
 467    <style:map style:condition="value()&lt;0" style:apply-style-name="N199P1"/>
 468    <style:map style:condition="value()=0" style:apply-style-name="N199P2"/>
 469   </number:text-style>
 470   <number:time-style style:name="N200">
 471    <number:minutes number:style="long"/>
 472    <number:text>:</number:text>
 473    <number:seconds number:style="long"/>
 474   </number:time-style>
 475   <number:time-style style:name="N201" number:truncate-on-overflow="false">
 476    <number:hours/>
 477    <number:text>:</number:text>
 478    <number:minutes number:style="long"/>
 479    <number:text>:</number:text>
 480    <number:seconds number:style="long"/>
 481   </number:time-style>
 482   <number:time-style style:name="N202">
 483    <number:minutes number:style="long"/>
 484    <number:text>:</number:text>
 485    <number:seconds number:style="long" number:decimal-places="1"/>
 486   </number:time-style>
 487   <number:number-style style:name="N203">
 488    <number:scientific-number number:decimal-places="1" loext:min-decimal-places="1" number:min-integer-digits="1" number:min-exponent-digits="1" loext:exponent-interval="3" loext:forced-exponent-sign="true"/>
 489   </number:number-style>
 490   <number:number-style style:name="N205P0" style:volatile="true">
 491    <number:text>Yes</number:text>
 492   </number:number-style>
 493   <number:number-style style:name="N205P1" style:volatile="true">
 494    <number:text>Yes</number:text>
 495   </number:number-style>
 496   <number:number-style style:name="N205">
 497    <number:text>No</number:text>
 498    <style:map style:condition="value()&gt;0" style:apply-style-name="N205P0"/>
 499    <style:map style:condition="value()&lt;0" style:apply-style-name="N205P1"/>
 500   </number:number-style>
 501   <number:number-style style:name="N207P0" style:volatile="true">
 502    <number:text>True</number:text>
 503   </number:number-style>
 504   <number:number-style style:name="N207P1" style:volatile="true">
 505    <number:text>True</number:text>
 506   </number:number-style>
 507   <number:number-style style:name="N207">
 508    <number:text>False</number:text>
 509    <style:map style:condition="value()&gt;0" style:apply-style-name="N207P0"/>
 510    <style:map style:condition="value()&lt;0" style:apply-style-name="N207P1"/>
 511   </number:number-style>
 512   <number:number-style style:name="N209P0" style:volatile="true">
 513    <number:text>On</number:text>
 514   </number:number-style>
 515   <number:number-style style:name="N209P1" style:volatile="true">
 516    <number:text>On</number:text>
 517   </number:number-style>
 518   <number:number-style style:name="N209">
 519    <number:text>Off</number:text>
 520    <style:map style:condition="value()&gt;0" style:apply-style-name="N209P0"/>
 521    <style:map style:condition="value()&lt;0" style:apply-style-name="N209P1"/>
 522   </number:number-style>
 523   <number:currency-style style:name="N211P0" style:volatile="true">
 524    <number:currency-symbol number:language="cs" number:country="CZ">¥€</number:currency-symbol>
 525    <number:text> </number:text>
 526    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="3">
 527     <number:embedded-text number:position="5"> </number:embedded-text>
 528    </number:number>
 529    <number:text> </number:text>
 530   </number:currency-style>
 531   <number:currency-style style:name="N211">
 532    <style:text-properties fo:color="#ff0000"/>
 533    <number:text>(</number:text>
 534    <number:currency-symbol number:language="cs" number:country="CZ">€</number:currency-symbol>
 535    <number:text> </number:text>
 536    <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="3">
 537     <number:embedded-text number:position="5"> </number:embedded-text>
 538    </number:number>
 539    <number:text>)</number:text>
 540    <style:map style:condition="value()&gt;=0" style:apply-style-name="N211P0"/>
 541   </number:currency-style>
 542   <number:currency-style style:name="N213P0" style:volatile="true">
 543    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 544    <number:text> </number:text>
 545    <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol>
 546   </number:currency-style>
 547   <number:currency-style style:name="N213">
 548    <style:text-properties fo:color="#ff0000"/>
 549    <number:text>-</number:text>
 550    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
 551    <number:text> </number:text>
 552    <number:currency-symbol number:language="de" number:country="DE">€</number:currency-symbol>
 553    <style:map style:condition="value()&gt;=0" style:apply-style-name="N213P0"/>
 554   </number:currency-style>
 555   <style:style style:name="Default" style:family="table-cell">
 556    <style:table-cell-properties fo:padding="2.01pt" style:rotation-align="none"/>
 557    <style:text-properties fo:color="#000000" style:font-name="Calibri" fo:font-family="Calibri" style:font-family-generic="swiss" style:font-pitch="variable" fo:font-size="11pt" style:font-name-asian="Droid Sans Fallback" style:font-family-asian="&apos;Droid Sans Fallback&apos;" style:font-family-generic-asian="system" style:font-pitch-asian="variable" style:font-size-asian="11pt" style:font-name-complex="Droid Sans Devanagari" style:font-family-complex="&apos;Droid Sans Devanagari&apos;" style:font-family-generic-complex="system" style:font-pitch-complex="variable" style:font-size-complex="11pt"/>
 558   </style:style>
 559   <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
 560    <style:text-properties fo:font-style="italic" style:text-underline-style="solid" style:text-underline-width="auto" style:text-underline-color="font-color" fo:font-weight="bold"/>
 561   </style:style>
 562   <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N122"/>
 563   <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
 564    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 565    <style:paragraph-properties fo:text-align="center"/>
 566    <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
 567   </style:style>
 568   <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
 569    <style:table-cell-properties style:rotation-angle="90"/>
 570   </style:style>
 571   <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
 572    <style:table-cell-properties fo:background-color="#ff3333"/>
 573   </style:style>
 574   <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
 575    <style:table-cell-properties fo:background-color="#99ff66"/>
 576   </style:style>
 577   <style:style style:name="Comma_20_2" style:display-name="Comma 2" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N126">
 578    <style:table-cell-properties fo:padding="2.01pt"/>
 579   </style:style>
 580   <style:style style:name="Normal_20_2" style:display-name="Normal 2" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0">
 581    <style:table-cell-properties style:glyph-orientation-vertical="0" style:cell-protect="protected" style:print-content="true" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" style:text-align-source="value-type" style:repeat-content="false" fo:background-color="transparent" fo:wrap-option="no-wrap" fo:border="none" style:direction="ltr" fo:padding="2.01pt" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="automatic" loext:vertical-justify="auto"/>
 582    <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
 583    <style:text-properties fo:color="#000000" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Times New Roman" fo:font-family="&apos;Times New Roman&apos;" style:font-family-generic="swiss" style:font-pitch="variable" fo:font-size="11pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="11pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman" style:font-family-complex="&apos;Times New Roman&apos;" style:font-family-generic-complex="swiss" style:font-pitch-complex="variable" style:font-size-complex="11pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
 584   </style:style>
 585   <style:style style:name="Normal_5f_Amortization_20_Schedule" style:display-name="Normal_Amortization Schedule" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N0">
 586    <style:table-cell-properties style:glyph-orientation-vertical="0" style:cell-protect="protected" style:print-content="true" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" style:text-align-source="value-type" style:repeat-content="false" fo:background-color="transparent" fo:wrap-option="no-wrap" fo:border="none" style:direction="ltr" fo:padding="2.01pt" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="automatic" loext:vertical-justify="auto"/>
 587    <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
 588    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Times New Roman1" fo:font-family="&apos;Times New Roman&apos;" style:font-family-generic="roman" style:font-pitch="variable" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman1" style:font-family-complex="&apos;Times New Roman&apos;" style:font-family-generic-complex="roman" style:font-pitch-complex="variable" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/>
 589   </style:style>
 590  </office:styles>
 591  <office:automatic-styles>
 592   <style:style style:name="co1" style:family="table-column">
 593    <style:table-column-properties fo:break-before="auto" style:column-width="185.7pt"/>
 594   </style:style>
 595   <style:style style:name="co2" style:family="table-column">
 596    <style:table-column-properties fo:break-before="auto" style:column-width="252.51pt"/>
 597   </style:style>
 598   <style:style style:name="co3" style:family="table-column">
 599    <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/>
 600   </style:style>
 601   <style:style style:name="co4" style:family="table-column">
 602    <style:table-column-properties fo:break-before="auto" style:column-width="142.44pt"/>
 603   </style:style>
 604   <style:style style:name="co5" style:family="table-column">
 605    <style:table-column-properties fo:break-before="auto" style:column-width="89.94pt"/>
 606   </style:style>
 607   <style:style style:name="co6" style:family="table-column">
 608    <style:table-column-properties fo:break-before="auto" style:column-width="74.21pt"/>
 609   </style:style>
 610   <style:style style:name="co7" style:family="table-column">
 611    <style:table-column-properties fo:break-before="auto" style:column-width="286.64pt"/>
 612   </style:style>
 613   <style:style style:name="co8" style:family="table-column">
 614    <style:table-column-properties fo:break-before="auto" style:column-width="140.94pt"/>
 615   </style:style>
 616   <style:style style:name="co9" style:family="table-column">
 617    <style:table-column-properties fo:break-before="auto" style:column-width="32.94pt"/>
 618   </style:style>
 619   <style:style style:name="co10" style:family="table-column">
 620    <style:table-column-properties fo:break-before="auto" style:column-width="46.46pt"/>
 621   </style:style>
 622   <style:style style:name="co11" style:family="table-column">
 623    <style:table-column-properties fo:break-before="auto" style:column-width="57.29pt"/>
 624   </style:style>
 625   <style:style style:name="co12" style:family="table-column">
 626    <style:table-column-properties fo:break-before="auto" style:column-width="78.29pt"/>
 627   </style:style>
 628   <style:style style:name="co13" style:family="table-column">
 629    <style:table-column-properties fo:break-before="auto" style:column-width="71.21pt"/>
 630   </style:style>
 631   <style:style style:name="ro1" style:family="table-row">
 632    <style:table-row-properties style:row-height="24.46pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 633   </style:style>
 634   <style:style style:name="ro2" style:family="table-row">
 635    <style:table-row-properties style:row-height="12.81pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 636   </style:style>
 637   <style:style style:name="ro3" style:family="table-row">
 638    <style:table-row-properties style:row-height="17.35pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 639   </style:style>
 640   <style:style style:name="ro4" style:family="table-row">
 641    <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 642   </style:style>
 643   <style:style style:name="ro5" style:family="table-row">
 644    <style:table-row-properties style:row-height="17.29pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 645   </style:style>
 646   <style:style style:name="ro6" style:family="table-row">
 647    <style:table-row-properties style:row-height="15.79pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
 648   </style:style>
 649   <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
 650    <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
 651   </style:style>
 652   <number:percentage-style style:name="N11">
 653    <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1"/>
 654    <number:text>%</number:text>
 655   </number:percentage-style>
 656   <number:date-style style:name="N36" number:automatic-order="true">
 657    <number:month number:style="long"/>
 658    <number:text>/</number:text>
 659    <number:day number:style="long"/>
 660    <number:text>/</number:text>
 661    <number:year number:style="long"/>
 662   </number:date-style>
 663   <number:boolean-style style:name="N99">
 664    <number:boolean/>
 665   </number:boolean-style>
 666   <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/>
 667   <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
 668    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 669    <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
 670    <style:text-properties fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/>
 671   </style:style>
 672   <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
 673    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 674    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 675    <style:text-properties fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/>
 676   </style:style>
 677   <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
 678    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 679    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 680    <style:text-properties fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/>
 681   </style:style>
 682   <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
 683    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 684    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 685   </style:style>
 686   <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 687    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 688    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 689    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
 690    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
 691    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
 692   </style:style>
 693   <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 694    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 695    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 696    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 697    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 698    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 699   </style:style>
 700   <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
 701    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 702    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 703    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
 704    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
 705    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
 706   </style:style>
 707   <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">
 708    <style:table-cell-properties fo:wrap-option="wrap"/>
 709    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 710   </style:style>
 711   <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
 712    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 713    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 714    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 715   </style:style>
 716   <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N11"/>
 717   <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Normal_20_2">
 718    <style:table-cell-properties fo:padding="2.01pt"/>
 719   </style:style>
 720   <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default">
 721    <style:text-properties style:use-window-font-color="true" style:font-name="Liberation Serif" fo:font-size="6.80000019073486pt" fo:language="en" fo:country="US" style:font-name-asian="Segoe UI" style:font-size-asian="6.80000019073486pt" style:language-asian="en" style:country-asian="US" style:font-name-complex="Tahoma" style:font-size-complex="6.80000019073486pt" style:language-complex="en" style:country-complex="US"/>
 722   </style:style>
 723   <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 724    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 725    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 726    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 727    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 728    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 729   </style:style>
 730   <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 731    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 732    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 733    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
 734    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
 735    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
 736   </style:style>
 737   <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 738    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 739    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 740    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C7"/>
 741    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C7"/>
 742    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C7"/>
 743   </style:style>
 744   <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 745    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 746    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 747   </style:style>
 748   <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 749    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 750    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 751    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C5"/>
 752    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C5"/>
 753    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C5"/>
 754   </style:style>
 755   <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 756    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 757    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 758    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C5"/>
 759    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C5"/>
 760    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C5"/>
 761   </style:style>
 762   <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 763    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 764    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 765    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
 766    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
 767    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
 768   </style:style>
 769   <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 770    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 771    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 772    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
 773    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
 774    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
 775   </style:style>
 776   <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default">
 777    <style:text-properties style:font-name="Liberation Serif" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
 778   </style:style>
 779   <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 780    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 781    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 782    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
 783    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
 784    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
 785   </style:style>
 786   <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
 787    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 788    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 789    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C29"/>
 790    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C29"/>
 791    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C29"/>
 792   </style:style>
 793   <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
 794    <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
 795    <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
 796    <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
 797    <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
 798    <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
 799   </style:style>
 800   <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default">
 801    <style:table-cell-properties fo:wrap-option="wrap"/>
 802    <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Liberation Mono" fo:font-size="10pt" fo:language="en" fo:country="US" fo:font-style="italic" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 803   </style:style>
 804   <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default">
 805    <style:text-properties fo:color="#000000" style:font-name="Arial" fo:font-size="10pt" style:font-name-asian="Times New Roman1" style:font-size-asian="12pt" style:language-asian="ar" style:country-asian="SA"/>
 806   </style:style>
 807   <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default">
 808    <style:text-properties style:font-name="Arial" fo:font-size="10pt" style:font-name-asian="Times New Roman1" style:font-size-asian="12pt" style:language-asian="ar" style:country-asian="SA" style:font-name-complex="Mangal"/>
 809   </style:style>
 810   <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default">
 811    <style:text-properties style:font-name="Arial" fo:font-size="10pt" style:font-name-asian="Times New Roman1" style:font-size-asian="12pt" style:language-asian="ar" style:country-asian="SA"/>
 812   </style:style>
 813   <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default">
 814    <style:table-cell-properties fo:wrap-option="wrap"/>
 815    <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 816   </style:style>
 817   <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default">
 818    <style:table-cell-properties fo:wrap-option="wrap"/>
 819    <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 820   </style:style>
 821   <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default">
 822    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 823   </style:style>
 824   <style:style style:name="ce33" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36">
 825    <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
 826   </style:style>
 827   <style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"/>
 828   <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default">
 829    <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/>
 830   </style:style>
 831   <style:style style:name="ce36" style:family="table-cell" style:parent-style-name="Default">
 832    <style:table-cell-properties style:glyph-orientation-vertical="0" style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" fo:padding="2.01pt" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="middle" loext:vertical-justify="auto"/>
 833    <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
 834    <style:text-properties fo:color="#000000" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Calibri" fo:font-size="11pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold" style:font-size-asian="11pt" style:font-style-asian="normal" style:font-weight-asian="bold" style:font-size-complex="11pt" style:font-style-complex="normal" style:font-weight-complex="bold"/>
 835   </style:style>
 836   <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default">
 837    <style:table-cell-properties style:glyph-orientation-vertical="0" style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" fo:padding="2.01pt" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="middle" loext:vertical-justify="auto"/>
 838    <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
 839   </style:style>
 840   <style:style style:name="ta_extref" style:family="table">
 841    <style:table-properties table:display="false"/>
 842   </style:style>
 843   <style:page-layout style:name="pm1">
 844    <style:page-layout-properties style:first-page-number="continue" style:writing-mode="lr-tb"/>
 845    <style:header-style>
 846     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
 847    </style:header-style>
 848    <style:footer-style>
 849     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
 850    </style:footer-style>
 851   </style:page-layout>
 852   <style:page-layout style:name="pm2">
 853    <style:page-layout-properties style:writing-mode="lr-tb"/>
 854    <style:header-style>
 855     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt" fo:border="2.49pt solid #000000" fo:padding="0.51pt" fo:background-color="#c0c0c0">
 856      <style:background-image/>
 857     </style:header-footer-properties>
 858    </style:header-style>
 859    <style:footer-style>
 860     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt" fo:border="2.49pt solid #000000" fo:padding="0.51pt" fo:background-color="#c0c0c0">
 861      <style:background-image/>
 862     </style:header-footer-properties>
 863    </style:footer-style>
 864   </style:page-layout>
 865   <style:page-layout style:name="pm3">
 866    <style:page-layout-properties fo:margin-top="54pt" fo:margin-bottom="54pt" fo:margin-left="50.4pt" fo:margin-right="50.4pt" style:first-page-number="continue" style:writing-mode="lr-tb"/>
 867    <style:header-style>
 868     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-bottom="0pt"/>
 869    </style:header-style>
 870    <style:footer-style>
 871     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-top="0pt"/>
 872    </style:footer-style>
 873   </style:page-layout>
 874   <style:page-layout style:name="pm4">
 875    <style:page-layout-properties fo:margin-top="56.69pt" fo:margin-bottom="56.69pt" fo:margin-left="50.4pt" fo:margin-right="50.4pt" style:first-page-number="continue" style:writing-mode="lr-tb"/>
 876    <style:header-style>
 877     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-bottom="0pt"/>
 878    </style:header-style>
 879    <style:footer-style>
 880     <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-top="0pt"/>
 881    </style:footer-style>
 882   </style:page-layout>
 883  </office:automatic-styles>
 884  <office:master-styles>
 885   <style:master-page style:name="Default" style:page-layout-name="pm1">
 886    <style:header>
 887     <text:p><text:sheet-name>???</text:sheet-name></text:p>
 888    </style:header>
 889    <style:header-left style:display="false"/>
 890    <style:footer>
 891     <text:p>Page <text:page-number>1</text:page-number></text:p>
 892    </style:footer>
 893    <style:footer-left style:display="false"/>
 894   </style:master-page>
 895   <style:master-page style:name="Report" style:page-layout-name="pm2">
 896    <style:header>
 897     <style:region-left>
 898      <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
 899     </style:region-left>
 900     <style:region-right>
 901      <text:p><text:date style:data-style-name="N2" text:date-value="2016-07-24">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="18:17:48.706504481">00:00:00</text:time></text:p>
 902     </style:region-right>
 903    </style:header>
 904    <style:header-left style:display="false"/>
 905    <style:footer>
 906     <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
 907    </style:footer>
 908    <style:footer-left style:display="false"/>
 909   </style:master-page>
 910   <style:master-page style:name="PageStyle_5f_Accrued_20_Interest_20_Calculation" style:display-name="PageStyle_Accrued Interest Calculation" style:page-layout-name="pm3">
 911    <style:header style:display="false"/>
 912    <style:header-left style:display="false"/>
 913    <style:footer style:display="false"/>
 914    <style:footer-left style:display="false"/>
 915   </style:master-page>
 916   <style:master-page style:name="PageStyle_5f_List1" style:display-name="PageStyle_List1" style:page-layout-name="pm4">
 917    <style:header style:display="false"/>
 918    <style:header-left style:display="false"/>
 919    <style:footer style:display="false"/>
 920    <style:footer-left style:display="false"/>
 921   </style:master-page>
 922  </office:master-styles>
 923  <office:body>
 924   <office:spreadsheet>
 925    <table:calculation-settings table:automatic-find-labels="false"/>
 926    <table:table table:name="Sheet1" table:style-name="ta1">
 927     <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
 928     <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
 929     <table:table-column table:style-name="co1" table:default-cell-style-name="ce5"/>
 930     <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
 931     <table:table-row table:style-name="ro1">
 932      <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string">
 933       <text:p>MIRR Function</text:p>
 934      </table:table-cell>
 935      <table:table-cell table:number-columns-repeated="2"/>
 936     </table:table-row>
 937     <table:table-row table:style-name="ro2">
 938      <table:table-cell table:number-columns-repeated="3"/>
 939     </table:table-row>
 940     <table:table-row table:style-name="ro3">
 941      <table:table-cell table:style-name="ce3" office:value-type="string" calcext:value-type="string">
 942       <text:p>Result</text:p>
 943      </table:table-cell>
 944      <table:table-cell table:style-name="ce6" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 945       <text:p>TRUE</text:p>
 946      </table:table-cell>
 947      <table:table-cell/>
 948     </table:table-row>
 949     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 950      <table:table-cell table:number-columns-repeated="3"/>
 951     </table:table-row>
 952     <table:table-row table:style-name="ro4">
 953      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 954       <text:p>Sheet</text:p>
 955      </table:table-cell>
 956      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 957       <text:p>Result</text:p>
 958      </table:table-cell>
 959      <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
 960       <text:p>Description</text:p>
 961      </table:table-cell>
 962     </table:table-row>
 963     <table:table-row table:style-name="ro5">
 964      <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
 965       <text:p>1</text:p>
 966      </table:table-cell>
 967      <table:table-cell table:style-name="ce7" table:formula="of:=AND([Sheet2.C2:.C49])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
 968       <text:p>TRUE</text:p>
 969      </table:table-cell>
 970      <table:table-cell office:value-type="string" calcext:value-type="string">
 971       <text:p>Simple MIRR formulas with local references and values</text:p>
 972      </table:table-cell>
 973     </table:table-row>
 974     <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
 975      <table:table-cell/>
 976      <table:table-cell table:style-name="ce8"/>
 977      <table:table-cell/>
 978     </table:table-row>
 979     <table:table-row table:style-name="ro2">
 980      <table:table-cell/>
 981      <table:table-cell table:style-name="ce8"/>
 982      <table:table-cell table:style-name="ce9"/>
 983     </table:table-row>
 984     <table:table-row table:style-name="ro2" table:number-rows-repeated="9">
 985      <table:table-cell/>
 986      <table:table-cell table:style-name="ce8"/>
 987      <table:table-cell/>
 988     </table:table-row>
 989     <table:table-row table:style-name="ro6">
 990      <table:table-cell/>
 991      <table:table-cell table:style-name="ce8"/>
 992      <table:table-cell/>
 993     </table:table-row>
 994     <table:table-row table:style-name="ro2" table:number-rows-repeated="16">
 995      <table:table-cell/>
 996      <table:table-cell table:style-name="ce8"/>
 997      <table:table-cell/>
 998     </table:table-row>
 999     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537">
1000      <table:table-cell table:number-columns-repeated="3"/>
1001     </table:table-row>
1002     <table:table-row table:style-name="ro2">
1003      <table:table-cell table:number-columns-repeated="3"/>
1004     </table:table-row>
1005     <calcext:conditional-formats>
1006      <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B38">
1007       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
1008       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
1009       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
1010      </calcext:conditional-format>
1011      <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
1012       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
1013       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
1014       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
1015      </calcext:conditional-format>
1016     </calcext:conditional-formats>
1017    </table:table>
1018    <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
1019     <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
1020     <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/>
1021     <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
1022     <table:table-column table:style-name="co6" table:default-cell-style-name="ce5"/>
1023     <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
1024     <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/>
1025     <table:table-column table:style-name="co9" table:default-cell-style-name="Default"/>
1026     <table:table-column table:style-name="co10" table:default-cell-style-name="Default"/>
1027     <table:table-column table:style-name="co11" table:default-cell-style-name="Default"/>
1028     <table:table-column table:style-name="co12" table:default-cell-style-name="Default"/>
1029     <table:table-column table:style-name="co6" table:default-cell-style-name="Default"/>
1030     <table:table-column table:style-name="co13" table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
1031     <table:table-column table:style-name="co3" table:number-columns-repeated="8" table:default-cell-style-name="Default"/>
1032     <table:table-row table:style-name="ro5">
1033      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1034       <text:p>Function</text:p>
1035      </table:table-cell>
1036      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1037       <text:p>Expected</text:p>
1038      </table:table-cell>
1039      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1040       <text:p>Correct</text:p>
1041      </table:table-cell>
1042      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1043       <text:p>FunctionString</text:p>
1044      </table:table-cell>
1045      <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1046       <text:p>Comment</text:p>
1047      </table:table-cell>
1048      <table:table-cell office:value-type="float" office:value="-5" calcext:value-type="float">
1049       <text:p>-5</text:p>
1050      </table:table-cell>
1051      <table:table-cell office:value-type="float" office:value="5" calcext:value-type="float">
1052       <text:p>5</text:p>
1053      </table:table-cell>
1054      <table:table-cell office:value-type="float" office:value="-5" calcext:value-type="float">
1055       <text:p>-5</text:p>
1056      </table:table-cell>
1057      <table:table-cell table:style-name="ce30" office:value-type="float" office:value="-7500" calcext:value-type="float">
1058       <text:p>-7500</text:p>
1059      </table:table-cell>
1060      <table:table-cell table:style-name="ce30" office:value-type="float" office:value="-10000" calcext:value-type="float">
1061       <text:p>-10000</text:p>
1062      </table:table-cell>
1063      <table:table-cell table:style-name="ce35"/>
1064      <table:table-cell table:style-name="ce30" table:number-columns-repeated="2"/>
1065      <table:table-cell table:style-name="ce35"/>
1066      <table:table-cell table:style-name="ce30" table:number-columns-repeated="2"/>
1067      <table:table-cell table:style-name="ce35"/>
1068      <table:table-cell table:style-name="ce30" table:number-columns-repeated="2"/>
1069      <table:table-cell table:style-name="ce35"/>
1070     </table:table-row>
1071     <table:table-row table:style-name="ro6">
1072      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.I1:.I5]; 0.05; 0.08)" office:value-type="percentage" office:value="0.187362250932837" calcext:value-type="percentage">
1073       <text:p>18.74%</text:p>
1074      </table:table-cell>
1075      <table:table-cell office:value-type="float" office:value="0.187362250932837" calcext:value-type="float">
1076       <text:p>0.187362250932837</text:p>
1077      </table:table-cell>
1078      <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A2];12)=ROUND([.B2];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1079       <text:p>TRUE</text:p>
1080      </table:table-cell>
1081      <table:table-cell table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=MIRR(I1:I5, 0.05, 0.08)" calcext:value-type="string">
1082       <text:p>=MIRR(I1:I5, 0.05, 0.08)</text:p>
1083      </table:table-cell>
1084      <table:table-cell table:style-name="ce26"/>
1085      <table:table-cell office:value-type="float" office:value="-10" calcext:value-type="float">
1086       <text:p>-10</text:p>
1087      </table:table-cell>
1088      <table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="10" calcext:value-type="float">
1089       <text:p>10</text:p>
1090      </table:table-cell>
1091      <table:table-cell office:value-type="float" office:value="3000" calcext:value-type="float">
1092       <text:p>3000</text:p>
1093      </table:table-cell>
1094      <table:table-cell office:value-type="float" office:value="3400" calcext:value-type="float">
1095       <text:p>3400</text:p>
1096      </table:table-cell>
1097      <table:table-cell table:style-name="ce35"/>
1098      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1099      <table:table-cell table:style-name="ce35"/>
1100      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1101      <table:table-cell table:style-name="ce35"/>
1102      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1103      <table:table-cell table:style-name="ce35"/>
1104     </table:table-row>
1105     <table:table-row table:style-name="ro6">
1106      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.J1:.J4]; 0.065; 0.1)" office:value-type="percentage" office:value="0.0703949396602768" calcext:value-type="percentage">
1107       <text:p>7.04%</text:p>
1108      </table:table-cell>
1109      <table:table-cell office:value-type="float" office:value="0.0703949396602768" calcext:value-type="float">
1110       <text:p>0.070394939660277</text:p>
1111      </table:table-cell>
1112      <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A3];12)=ROUND([.B3];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1113       <text:p>TRUE</text:p>
1114      </table:table-cell>
1115      <table:table-cell table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=MIRR(J1:J4, 0.065, 0.1)" calcext:value-type="string">
1116       <text:p>=MIRR(J1:J4, 0.065, 0.1)</text:p>
1117      </table:table-cell>
1118      <table:table-cell table:style-name="ce26"/>
1119      <table:table-cell office:value-type="float" office:value="-15" calcext:value-type="float">
1120       <text:p>-15</text:p>
1121      </table:table-cell>
1122      <table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="15" calcext:value-type="float">
1123       <text:p>15</text:p>
1124      </table:table-cell>
1125      <table:table-cell office:value-type="float" office:value="5000" calcext:value-type="float">
1126       <text:p>5000</text:p>
1127      </table:table-cell>
1128      <table:table-cell office:value-type="float" office:value="6500" calcext:value-type="float">
1129       <text:p>6500</text:p>
1130      </table:table-cell>
1131      <table:table-cell table:style-name="ce35"/>
1132      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1133      <table:table-cell table:style-name="ce35"/>
1134      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1135      <table:table-cell table:style-name="ce35"/>
1136      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1137      <table:table-cell table:style-name="ce35"/>
1138     </table:table-row>
1139     <table:table-row table:style-name="ro6">
1140      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.J1:.J4]; ; 0.1)" office:value-type="percentage" office:value="0.0703949396602768" calcext:value-type="percentage">
1141       <text:p>7.04%</text:p>
1142      </table:table-cell>
1143      <table:table-cell office:value-type="float" office:value="0.0703949396602768" calcext:value-type="float">
1144       <text:p>0.070394939660277</text:p>
1145      </table:table-cell>
1146      <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A4];12)=ROUND([.B4];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1147       <text:p>TRUE</text:p>
1148      </table:table-cell>
1149      <table:table-cell table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=MIRR(J1:J4, , 0.1)" calcext:value-type="string">
1150       <text:p>=MIRR(J1:J4, , 0.1)</text:p>
1151      </table:table-cell>
1152      <table:table-cell/>
1153      <table:table-cell office:value-type="float" office:value="-8" calcext:value-type="float">
1154       <text:p>-8</text:p>
1155      </table:table-cell>
1156      <table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="8" calcext:value-type="float">
1157       <text:p>8</text:p>
1158      </table:table-cell>
1159      <table:table-cell office:value-type="float" office:value="1200" calcext:value-type="float">
1160       <text:p>1200</text:p>
1161      </table:table-cell>
1162      <table:table-cell office:value-type="float" office:value="1000" calcext:value-type="float">
1163       <text:p>1000</text:p>
1164      </table:table-cell>
1165      <table:table-cell table:style-name="ce35"/>
1166      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1167      <table:table-cell/>
1168      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1169      <table:table-cell table:style-name="ce35"/>
1170      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1171      <table:table-cell table:style-name="ce35"/>
1172     </table:table-row>
1173     <table:table-row table:style-name="ro6">
1174      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.J1:.J4]; 0.065; )" office:value-type="percentage" office:value="0.0291424665715065" calcext:value-type="percentage">
1175       <text:p>2.91%</text:p>
1176      </table:table-cell>
1177      <table:table-cell office:value-type="float" office:value="0.0291424665715065" calcext:value-type="float">
1178       <text:p>0.029142466571507</text:p>
1179      </table:table-cell>
1180      <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A5];12)=ROUND([.B5];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1181       <text:p>TRUE</text:p>
1182      </table:table-cell>
1183      <table:table-cell table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=MIRR(J1:J4, 0.065, )" calcext:value-type="string">
1184       <text:p>=MIRR(J1:J4, 0.065, )</text:p>
1185      </table:table-cell>
1186      <table:table-cell table:number-columns-repeated="4"/>
1187      <table:table-cell office:value-type="float" office:value="4000" calcext:value-type="float">
1188       <text:p>4000</text:p>
1189      </table:table-cell>
1190      <table:table-cell/>
1191      <table:table-cell table:style-name="ce35"/>
1192      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1193      <table:table-cell table:style-name="ce35"/>
1194      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1195      <table:table-cell table:style-name="ce35"/>
1196      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1197      <table:table-cell table:style-name="ce35"/>
1198     </table:table-row>
1199     <table:table-row table:style-name="ro6">
1200      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.J1:.J4]; 0.065; [.F6])" office:value-type="percentage" office:value="0.0291424665715065" calcext:value-type="percentage">
1201       <text:p>2.91%</text:p>
1202      </table:table-cell>
1203      <table:table-cell office:value-type="float" office:value="0.0291424665715065" calcext:value-type="float">
1204       <text:p>0.029142466571507</text:p>
1205      </table:table-cell>
1206      <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A6];12)=ROUND([.B6];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1207       <text:p>TRUE</text:p>
1208      </table:table-cell>
1209      <table:table-cell table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=MIRR(J1:J4, 0.065, F6)" calcext:value-type="string">
1210       <text:p>=MIRR(J1:J4, 0.065, F6)</text:p>
1211      </table:table-cell>
1212      <table:table-cell table:number-columns-repeated="7"/>
1213      <table:table-cell table:style-name="ce30" table:number-columns-repeated="6"/>
1214      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1215      <table:table-cell table:style-name="ce35"/>
1216     </table:table-row>
1217     <table:table-row table:style-name="ro6">
1218      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.J1:.J4]; -0.065;0.1 )" office:value-type="percentage" office:value="0.0703949396602768" calcext:value-type="percentage">
1219       <text:p>7.04%</text:p>
1220      </table:table-cell>
1221      <table:table-cell office:value-type="float" office:value="0.0703949396602768" calcext:value-type="float">
1222       <text:p>0.070394939660277</text:p>
1223      </table:table-cell>
1224      <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A7];12)=ROUND([.B7];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1225       <text:p>TRUE</text:p>
1226      </table:table-cell>
1227      <table:table-cell table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=MIRR(J1:J4, -0.065,0.1 )" calcext:value-type="string">
1228       <text:p>=MIRR(J1:J4, -0.065,0.1 )</text:p>
1229      </table:table-cell>
1230      <table:table-cell table:number-columns-repeated="8"/>
1231      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1232      <table:table-cell/>
1233      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1234      <table:table-cell table:style-name="ce30" table:number-columns-repeated="3"/>
1235     </table:table-row>
1236     <table:table-row table:style-name="ro6">
1237      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.J1:.J4]; 0.065; -0.1)" office:value-type="percentage" office:value="-0.0133781775109151" calcext:value-type="percentage">
1238       <text:p>-1.34%</text:p>
1239      </table:table-cell>
1240      <table:table-cell office:value-type="float" office:value="-0.0133781775109151" calcext:value-type="float">
1241       <text:p>-0.013378177510915</text:p>
1242      </table:table-cell>
1243      <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A8];12)=ROUND([.B8];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1244       <text:p>TRUE</text:p>
1245      </table:table-cell>
1246      <table:table-cell table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=MIRR(J1:J4, 0.065, -0.1)" calcext:value-type="string">
1247       <text:p>=MIRR(J1:J4, 0.065, -0.1)</text:p>
1248      </table:table-cell>
1249      <table:table-cell table:style-name="ce27"/>
1250      <table:table-cell table:number-columns-repeated="5"/>
1251      <table:table-cell table:style-name="ce30"/>
1252      <table:table-cell/>
1253      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1254      <table:table-cell table:number-columns-repeated="4"/>
1255      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1256     </table:table-row>
1257     <table:table-row table:style-name="ro6">
1258      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.H1:.H4];0.5;0.1)" office:value-type="percentage" office:value="0.941647376706893" calcext:value-type="percentage">
1259       <text:p>94.16%</text:p>
1260      </table:table-cell>
1261      <table:table-cell office:value-type="float" office:value="0.941647376706893" calcext:value-type="float">
1262       <text:p>0.941647376706893</text:p>
1263      </table:table-cell>
1264      <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A9];12)=ROUND([.B9];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1265       <text:p>TRUE</text:p>
1266      </table:table-cell>
1267      <table:table-cell table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=MIRR(H1:H4,0.5,0.1)" calcext:value-type="string">
1268       <text:p>=MIRR(H1:H4,0.5,0.1)</text:p>
1269      </table:table-cell>
1270      <table:table-cell table:number-columns-repeated="6"/>
1271      <table:table-cell table:style-name="ce31"/>
1272      <table:table-cell table:style-name="ce36" table:number-columns-repeated="2"/>
1273      <table:table-cell table:number-columns-repeated="7"/>
1274     </table:table-row>
1275     <table:table-row table:style-name="ro6">
1276      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR(; 0.065; 0.1)" office:value-type="string" office:string-value="" calcext:value-type="error">
1277       <text:p>Err:504</text:p>
1278      </table:table-cell>
1279      <table:table-cell office:value-type="string" calcext:value-type="string">
1280       <text:p>error</text:p>
1281      </table:table-cell>
1282      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A10])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1283       <text:p>TRUE</text:p>
1284      </table:table-cell>
1285      <table:table-cell table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=MIRR(, 0.065, 0.1)" calcext:value-type="string">
1286       <text:p>=MIRR(, 0.065, 0.1)</text:p>
1287      </table:table-cell>
1288      <table:table-cell table:number-columns-repeated="5"/>
1289      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1290      <table:table-cell/>
1291      <table:table-cell table:style-name="ce37"/>
1292      <table:table-cell table:style-name="ce32"/>
1293      <table:table-cell table:number-columns-repeated="6"/>
1294     </table:table-row>
1295     <table:table-row table:style-name="ro6">
1296      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.H1:.H4])" office:value-type="string" office:string-value="" calcext:value-type="error">
1297       <text:p>Err:511</text:p>
1298      </table:table-cell>
1299      <table:table-cell office:value-type="string" calcext:value-type="string">
1300       <text:p>error</text:p>
1301      </table:table-cell>
1302      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A11])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1303       <text:p>TRUE</text:p>
1304      </table:table-cell>
1305      <table:table-cell table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=MIRR(H1:H4)" calcext:value-type="string">
1306       <text:p>=MIRR(H1:H4)</text:p>
1307      </table:table-cell>
1308      <table:table-cell table:number-columns-repeated="5"/>
1309      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1310      <table:table-cell table:number-columns-repeated="9"/>
1311     </table:table-row>
1312     <table:table-row table:style-name="ro6">
1313      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.H1:.H4];0.5)" office:value-type="string" office:string-value="" calcext:value-type="error">
1314       <text:p>Err:511</text:p>
1315      </table:table-cell>
1316      <table:table-cell office:value-type="string" calcext:value-type="string">
1317       <text:p>error</text:p>
1318      </table:table-cell>
1319      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A12])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1320       <text:p>TRUE</text:p>
1321      </table:table-cell>
1322      <table:table-cell table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=MIRR(H1:H4,0.5)" calcext:value-type="string">
1323       <text:p>=MIRR(H1:H4,0.5)</text:p>
1324      </table:table-cell>
1325      <table:table-cell table:number-columns-repeated="5"/>
1326      <table:table-cell table:style-name="ce31" table:number-columns-repeated="2"/>
1327      <table:table-cell table:number-columns-repeated="9"/>
1328     </table:table-row>
1329     <table:table-row table:style-name="ro6">
1330      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.G1:.G4];0.51;0.1)" office:value-type="string" office:string-value="" calcext:value-type="error">
1331       <text:p>Err:502</text:p>
1332      </table:table-cell>
1333      <table:table-cell office:value-type="string" calcext:value-type="string">
1334       <text:p>error</text:p>
1335      </table:table-cell>
1336      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A13])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1337       <text:p>TRUE</text:p>
1338      </table:table-cell>
1339      <table:table-cell table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=MIRR(G1:G4,0.51,0.1)" calcext:value-type="string">
1340       <text:p>=MIRR(G1:G4,0.51,0.1)</text:p>
1341      </table:table-cell>
1342      <table:table-cell office:value-type="string" calcext:value-type="string">
1343       <text:p>Values shall contain at least one positive value and at least one negative value.</text:p>
1344      </table:table-cell>
1345      <table:table-cell table:number-columns-repeated="4"/>
1346      <table:table-cell table:style-name="ce32"/>
1347      <table:table-cell table:style-name="ce34"/>
1348      <table:table-cell table:style-name="ce32" table:number-columns-repeated="3"/>
1349      <table:table-cell table:number-columns-repeated="6"/>
1350     </table:table-row>
1351     <table:table-row table:style-name="ro6">
1352      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR([.F1:.F4];0.51;0.1)" office:value-type="string" office:string-value="" calcext:value-type="error">
1353       <text:p>Err:502</text:p>
1354      </table:table-cell>
1355      <table:table-cell office:value-type="string" calcext:value-type="string">
1356       <text:p>error</text:p>
1357      </table:table-cell>
1358      <table:table-cell table:style-name="ce16" table:formula="of:=ISERROR([.A14])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1359       <text:p>TRUE</text:p>
1360      </table:table-cell>
1361      <table:table-cell table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=MIRR(F1:F4,0.51,0.1)" calcext:value-type="string">
1362       <text:p>=MIRR(F1:F4,0.51,0.1)</text:p>
1363      </table:table-cell>
1364      <table:table-cell office:value-type="string" calcext:value-type="string">
1365       <text:p>Tdf#100767 Values shall contain at least one positive value and at least one negative value.</text:p>
1366      </table:table-cell>
1367      <table:table-cell table:number-columns-repeated="15"/>
1368     </table:table-row>
1369     <table:table-row table:style-name="ro6">
1370      <table:table-cell table:style-name="ce11" table:formula="of:=MIRR({-10000|3400|6500|1000}; 0.065; 0.1)" office:value-type="percentage" office:value="0.0703949396602768" calcext:value-type="percentage">
1371       <text:p>7.04%</text:p>
1372      </table:table-cell>
1373      <table:table-cell office:value-type="float" office:value="0.0703949396602768" calcext:value-type="float">
1374       <text:p>0.070394939660277</text:p>
1375      </table:table-cell>
1376      <table:table-cell table:style-name="ce17" table:formula="of:=ROUND([.A15];12)=ROUND([.B15];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1377       <text:p>TRUE</text:p>
1378      </table:table-cell>
1379      <table:table-cell table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=MIRR({-10000;3400;6500;1000}, 0.065, 0.1)" calcext:value-type="string">
1380       <text:p>=MIRR({-10000;3400;6500;1000}, 0.065, 0.1)</text:p>
1381      </table:table-cell>
1382      <table:table-cell office:value-type="string" calcext:value-type="string">
1383       <text:p>Tdf#58585</text:p>
1384      </table:table-cell>
1385      <table:table-cell table:number-columns-repeated="5"/>
1386      <table:table-cell table:style-name="ce34"/>
1387      <table:table-cell table:number-columns-repeated="9"/>
1388     </table:table-row>
1389     <table:table-row table:style-name="ro6">
1390      <table:table-cell table:number-columns-repeated="2"/>
1391      <table:table-cell table:style-name="Default"/>
1392      <table:table-cell table:number-columns-repeated="6"/>
1393      <table:table-cell table:style-name="ce33"/>
1394      <table:table-cell table:style-name="ce34"/>
1395      <table:table-cell table:style-name="ce32" table:number-columns-repeated="3"/>
1396      <table:table-cell table:number-columns-repeated="6"/>
1397     </table:table-row>
1398     <table:table-row table:style-name="ro6">
1399      <table:table-cell table:number-columns-repeated="2"/>
1400      <table:table-cell table:style-name="ce18"/>
1401      <table:table-cell table:number-columns-repeated="7"/>
1402      <table:table-cell table:style-name="ce34"/>
1403      <table:table-cell table:number-columns-repeated="9"/>
1404     </table:table-row>
1405     <table:table-row table:style-name="ro6" table:number-rows-repeated="2">
1406      <table:table-cell table:number-columns-repeated="2"/>
1407      <table:table-cell table:style-name="ce19"/>
1408      <table:table-cell table:number-columns-repeated="17"/>
1409     </table:table-row>
1410     <table:table-row table:style-name="ro6">
1411      <table:table-cell table:number-columns-repeated="2"/>
1412      <table:table-cell table:style-name="ce20"/>
1413      <table:table-cell/>
1414      <table:table-cell table:style-name="ce28"/>
1415      <table:table-cell table:number-columns-repeated="15"/>
1416     </table:table-row>
1417     <table:table-row table:style-name="ro6">
1418      <table:table-cell table:number-columns-repeated="2"/>
1419      <table:table-cell table:style-name="ce21"/>
1420      <table:table-cell table:style-name="ce22"/>
1421      <table:table-cell table:number-columns-repeated="16"/>
1422     </table:table-row>
1423     <table:table-row table:style-name="ro6">
1424      <table:table-cell/>
1425      <table:table-cell table:style-name="ce13"/>
1426      <table:table-cell table:style-name="ce22"/>
1427      <table:table-cell table:number-columns-repeated="17"/>
1428     </table:table-row>
1429     <table:table-row table:style-name="ro6">
1430      <table:table-cell table:number-columns-repeated="2"/>
1431      <table:table-cell table:style-name="ce23"/>
1432      <table:table-cell table:style-name="ce22" table:number-columns-repeated="2"/>
1433      <table:table-cell table:number-columns-repeated="15"/>
1434     </table:table-row>
1435     <table:table-row table:style-name="ro6">
1436      <table:table-cell table:number-columns-repeated="2"/>
1437      <table:table-cell table:style-name="ce23"/>
1438      <table:table-cell table:style-name="ce22"/>
1439      <table:table-cell table:style-name="ce29"/>
1440      <table:table-cell table:number-columns-repeated="15"/>
1441     </table:table-row>
1442     <table:table-row table:style-name="ro6" table:number-rows-repeated="2">
1443      <table:table-cell table:number-columns-repeated="2"/>
1444      <table:table-cell table:style-name="ce23"/>
1445      <table:table-cell table:style-name="ce22"/>
1446      <table:table-cell table:number-columns-repeated="16"/>
1447     </table:table-row>
1448     <table:table-row table:style-name="ro6">
1449      <table:table-cell table:number-columns-repeated="2"/>
1450      <table:table-cell table:style-name="ce23"/>
1451      <table:table-cell table:style-name="ce22"/>
1452      <table:table-cell table:number-columns-repeated="5"/>
1453      <table:table-cell table:style-name="ce34"/>
1454      <table:table-cell table:number-columns-repeated="10"/>
1455     </table:table-row>
1456     <table:table-row table:style-name="ro6">
1457      <table:table-cell table:number-columns-repeated="2"/>
1458      <table:table-cell table:style-name="ce23"/>
1459      <table:table-cell table:style-name="ce22"/>
1460      <table:table-cell table:number-columns-repeated="16"/>
1461     </table:table-row>
1462     <table:table-row table:style-name="ro6">
1463      <table:table-cell table:number-columns-repeated="2"/>
1464      <table:table-cell table:style-name="ce24"/>
1465      <table:table-cell table:style-name="ce22"/>
1466      <table:table-cell table:number-columns-repeated="16"/>
1467     </table:table-row>
1468     <table:table-row table:style-name="ro6">
1469      <table:table-cell/>
1470      <table:table-cell table:style-name="Normal_20_2"/>
1471      <table:table-cell table:style-name="ce12" table:number-columns-repeated="3"/>
1472      <table:table-cell table:style-name="Normal_20_2" table:number-columns-repeated="2"/>
1473      <table:table-cell table:number-columns-repeated="13"/>
1474     </table:table-row>
1475     <table:table-row table:style-name="ro6">
1476      <table:table-cell table:style-name="Normal_20_2" table:number-columns-repeated="2"/>
1477      <table:table-cell table:style-name="ce12" table:number-columns-repeated="2"/>
1478      <table:table-cell table:number-columns-repeated="16"/>
1479     </table:table-row>
1480     <table:table-row table:style-name="ro6" table:number-rows-repeated="2">
1481      <table:table-cell table:style-name="ce12" table:number-columns-repeated="4"/>
1482      <table:table-cell table:number-columns-repeated="16"/>
1483     </table:table-row>
1484     <table:table-row table:style-name="ro6" table:number-rows-repeated="7">
1485      <table:table-cell table:style-name="ce12" table:number-columns-repeated="5"/>
1486      <table:table-cell table:number-columns-repeated="15"/>
1487     </table:table-row>
1488     <table:table-row table:style-name="ro6" table:number-rows-repeated="26">
1489      <table:table-cell table:number-columns-repeated="2"/>
1490      <table:table-cell table:style-name="ce25"/>
1491      <table:table-cell table:number-columns-repeated="17"/>
1492     </table:table-row>
1493     <table:table-row table:style-name="ro2" table:number-rows-repeated="34">
1494      <table:table-cell table:number-columns-repeated="2"/>
1495      <table:table-cell table:style-name="ce25"/>
1496      <table:table-cell table:number-columns-repeated="17"/>
1497     </table:table-row>
1498     <table:table-row table:style-name="ro2" table:number-rows-repeated="1048475">
1499      <table:table-cell table:number-columns-repeated="20"/>
1500     </table:table-row>
1501     <table:table-row table:style-name="ro2">
1502      <table:table-cell table:number-columns-repeated="20"/>
1503     </table:table-row>
1504     <calcext:conditional-formats>
1505      <calcext:conditional-format calcext:target-range-address="Sheet2.C41:Sheet2.C100 Sheet2.C23:Sheet2.C28 Sheet2.C20:Sheet2.C21">
1506       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C20"/>
1507       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C20"/>
1508       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C20"/>
1509      </calcext:conditional-format>
1510      <calcext:conditional-format calcext:target-range-address="Sheet2.C17:Sheet2.C21">
1511       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C5"/>
1512       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C5"/>
1513       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C5"/>
1514      </calcext:conditional-format>
1515      <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29">
1516       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C29"/>
1517       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/>
1518       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/>
1519      </calcext:conditional-format>
1520      <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29">
1521       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C29"/>
1522       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/>
1523       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/>
1524      </calcext:conditional-format>
1525      <calcext:conditional-format calcext:target-range-address="Sheet2.C23:Sheet2.C28 Sheet2.C17:Sheet2.C20 Sheet2.C2:Sheet2.C9">
1526       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C2"/>
1527       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
1528       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
1529      </calcext:conditional-format>
1530      <calcext:conditional-format calcext:target-range-address="Sheet2.C4:Sheet2.C14">
1531       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C7"/>
1532       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C7"/>
1533       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C7"/>
1534      </calcext:conditional-format>
1535      <calcext:conditional-format calcext:target-range-address="Sheet2.C17:Sheet2.C17">
1536       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C17"/>
1537       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C17"/>
1538       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C17"/>
1539      </calcext:conditional-format>
1540      <calcext:conditional-format calcext:target-range-address="Sheet2.C17:Sheet2.C17">
1541       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C17"/>
1542       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C17"/>
1543       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C17"/>
1544      </calcext:conditional-format>
1545      <calcext:conditional-format calcext:target-range-address="Sheet2.C17:Sheet2.C17">
1546       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C17"/>
1547       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C17"/>
1548       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C17"/>
1549      </calcext:conditional-format>
1550      <calcext:conditional-format calcext:target-range-address="Sheet2.C17:Sheet2.C17">
1551       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C17"/>
1552       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C17"/>
1553       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C17"/>
1554      </calcext:conditional-format>
1555      <calcext:conditional-format calcext:target-range-address="Sheet2.C17:Sheet2.C17">
1556       <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C17"/>
1557       <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C17"/>
1558       <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C17"/>
1559      </calcext:conditional-format>
1560     </calcext:conditional-formats>
1561    </table:table>
1562    <table:table table:name="&apos;file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/mirr.fods/mirr.fods/mirr.fods/mirr.fods/mirr.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods&apos;#Sheet2" table:print="false" table:style-name="ta_extref">
1563     <table:table-source xlink:type="simple" xlink:href="mirr.fods/mirr.fods/mirr.fods/mirr.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/>
1564     <table:table-column table:number-columns-repeated="8"/>
1565     <table:table-row table:number-rows-repeated="2">
1566      <table:table-cell table:number-columns-repeated="8"/>
1567     </table:table-row>
1568     <table:table-row>
1569      <table:table-cell table:number-columns-repeated="7"/>
1570      <table:table-cell table:style-name="ce1" office:value-type="float" office:value="4">
1571       <text:p>4</text:p>
1572      </table:table-cell>
1573     </table:table-row>
1574    </table:table>
1575    <table:named-expressions>
1576     <table:named-range table:name="day1" table:base-cell-address="$Sheet2.$K$2" table:cell-range-address="$Sheet2.$K$2"/>
1577     <table:named-range table:name="day2" table:base-cell-address="$Sheet2.$K$3" table:cell-range-address="$Sheet2.$K$3"/>
1578     <table:named-range table:name="days" table:base-cell-address="$Sheet2.$K$4" table:cell-range-address="$Sheet2.$K$4:.$K$6"/>
1579     <table:named-range table:name="one" table:base-cell-address="$Sheet2.$M$1" table:cell-range-address="$Sheet2.$M$1"/>
1580    </table:named-expressions>
1581   </office:spreadsheet>
1582  </office:body>
1583 </office:document>