tdf#130857 qt weld: Implement QtInstanceWidget::strip_mnemonic
[LibreOffice.git] / sc / qa / unit / data / functions / financial / fods / fv.fods
blob05685e05bfeeaeaac0b671d49861f58c8b99f136
1 <?xml version="1.0" encoding="UTF-8"?>
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"></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"></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"></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"></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"></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"></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"></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"></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"></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"></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></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></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></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></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></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></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></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></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></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></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></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></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></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 <style:style style:name="Default" style:family="table-cell">
543 <style:table-cell-properties fo:padding="2.01pt" style:rotation-align="none"/>
544 <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"/>
545 </style:style>
546 <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
547 <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"/>
548 </style:style>
549 <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result" style:data-style-name="N122"/>
550 <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
551 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
552 <style:paragraph-properties fo:text-align="center"/>
553 <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
554 </style:style>
555 <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
556 <style:table-cell-properties style:rotation-angle="90"/>
557 </style:style>
558 <style:style style:name="Untitled1" style:family="table-cell" style:parent-style-name="Default">
559 <style:table-cell-properties fo:background-color="#ff3333"/>
560 </style:style>
561 <style:style style:name="Untitled2" style:family="table-cell" style:parent-style-name="Default">
562 <style:table-cell-properties fo:background-color="#99ff66"/>
563 </style:style>
564 <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">
565 <style:table-cell-properties fo:padding="2.01pt"/>
566 </style:style>
567 <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">
568 <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"/>
569 <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
570 <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"/>
571 </style:style>
572 <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">
573 <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"/>
574 <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
575 <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"/>
576 </style:style>
577 <draw:marker draw:name="Arrowheads_20_1" draw:display-name="Arrowheads 1" svg:viewBox="0 0 200 200" svg:d="M200 100c0 18-4 34-13 50-10 16-21 27-37 37-16 9-32 13-50 13s-34-4-50-13c-16-10-27-21-37-37-9-16-13-32-13-50s4-34 13-50c10-16 21-27 37-37 16-9 32-13 50-13s34 4 50 13c16 10 27 21 37 37 9 16 13 32 13 50z"/>
578 <draw:marker draw:name="Arrowheads_20_2" draw:display-name="Arrowheads 2" svg:viewBox="0 0 20 30" svg:d="M10 0l-10 30h20z"/>
579 <draw:marker draw:name="Arrowheads_20_3" draw:display-name="Arrowheads 3" svg:viewBox="-100 -100 200 200" svg:d="M100 0c0 18-4 34-13 50-10 16-21 27-37 37-16 9-32 13-50 13s-34-4-50-13c-16-10-27-21-37-37-9-16-13-32-13-50s4-34 13-50c10-16 21-27 37-37 16-9 32-13 50-13s34 4 50 13c16 10 27 21 37 37 9 16 13 32 13 50z"/>
580 </office:styles>
581 <office:automatic-styles>
582 <style:style style:name="co1" style:family="table-column">
583 <style:table-column-properties fo:break-before="auto" style:column-width="185.7pt"/>
584 </style:style>
585 <style:style style:name="co2" style:family="table-column">
586 <style:table-column-properties fo:break-before="auto" style:column-width="252.51pt"/>
587 </style:style>
588 <style:style style:name="co3" style:family="table-column">
589 <style:table-column-properties fo:break-before="auto" style:column-width="64.01pt"/>
590 </style:style>
591 <style:style style:name="co4" style:family="table-column">
592 <style:table-column-properties fo:break-before="auto" style:column-width="142.44pt"/>
593 </style:style>
594 <style:style style:name="co5" style:family="table-column">
595 <style:table-column-properties fo:break-before="auto" style:column-width="89.94pt"/>
596 </style:style>
597 <style:style style:name="co6" style:family="table-column">
598 <style:table-column-properties fo:break-before="auto" style:column-width="74.21pt"/>
599 </style:style>
600 <style:style style:name="co7" style:family="table-column">
601 <style:table-column-properties fo:break-before="auto" style:column-width="345.8pt"/>
602 </style:style>
603 <style:style style:name="co8" style:family="table-column">
604 <style:table-column-properties fo:break-before="auto" style:column-width="140.94pt"/>
605 </style:style>
606 <style:style style:name="co9" style:family="table-column">
607 <style:table-column-properties fo:break-before="auto" style:column-width="16.44pt"/>
608 </style:style>
609 <style:style style:name="co10" style:family="table-column">
610 <style:table-column-properties fo:break-before="auto" style:column-width="46.46pt"/>
611 </style:style>
612 <style:style style:name="co11" style:family="table-column">
613 <style:table-column-properties fo:break-before="auto" style:column-width="78.29pt"/>
614 </style:style>
615 <style:style style:name="co12" style:family="table-column">
616 <style:table-column-properties fo:break-before="auto" style:column-width="71.21pt"/>
617 </style:style>
618 <style:style style:name="ro1" style:family="table-row">
619 <style:table-row-properties style:row-height="24.46pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
620 </style:style>
621 <style:style style:name="ro2" style:family="table-row">
622 <style:table-row-properties style:row-height="12.81pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
623 </style:style>
624 <style:style style:name="ro3" style:family="table-row">
625 <style:table-row-properties style:row-height="17.35pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
626 </style:style>
627 <style:style style:name="ro4" style:family="table-row">
628 <style:table-row-properties style:row-height="15pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
629 </style:style>
630 <style:style style:name="ro5" style:family="table-row">
631 <style:table-row-properties style:row-height="13.21pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
632 </style:style>
633 <style:style style:name="ro6" style:family="table-row">
634 <style:table-row-properties style:row-height="17.29pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
635 </style:style>
636 <style:style style:name="ro7" style:family="table-row">
637 <style:table-row-properties style:row-height="15.79pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
638 </style:style>
639 <style:style style:name="ro8" style:family="table-row">
640 <style:table-row-properties style:row-height="37.45pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
641 </style:style>
642 <style:style style:name="ro9" style:family="table-row">
643 <style:table-row-properties style:row-height="130pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
644 </style:style>
645 <style:style style:name="ro10" style:family="table-row">
646 <style:table-row-properties style:row-height="15.36pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
647 </style:style>
648 <style:style style:name="ro11" style:family="table-row">
649 <style:table-row-properties style:row-height="24.01pt" fo:break-before="auto" style:use-optimal-row-height="true"/>
650 </style:style>
651 <style:style style:name="ta1" style:family="table" style:master-page-name="Default">
652 <style:table-properties table:display="true" style:writing-mode="lr-tb"/>
653 </style:style>
654 <number:date-style style:name="N36" number:automatic-order="true">
655 <number:month number:style="long"/>
656 <number:text>/</number:text>
657 <number:day number:style="long"/>
658 <number:text>/</number:text>
659 <number:year number:style="long"/>
660 </number:date-style>
661 <number:boolean-style style:name="N99">
662 <number:boolean/>
663 </number:boolean-style>
664 <number:currency-style style:name="N104P0" style:volatile="true">
665 <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
666 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
667 </number:currency-style>
668 <number:currency-style style:name="N104">
669 <style:text-properties fo:color="#ff0000"/>
670 <number:text>-</number:text>
671 <number:currency-symbol number:language="en" number:country="US">$</number:currency-symbol>
672 <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
673 <style:map style:condition="value()&gt;=0" style:apply-style-name="N104P0"/>
674 </number:currency-style>
675 <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/>
676 <style:style style:name="ce2" style:family="table-cell" style:parent-style-name="Default">
677 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
678 <style:paragraph-properties fo:text-align="start" fo:margin-left="0pt"/>
679 <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"/>
680 </style:style>
681 <style:style style:name="ce3" style:family="table-cell" style:parent-style-name="Default">
682 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
683 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
684 <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"/>
685 </style:style>
686 <style:style style:name="ce4" style:family="table-cell" style:parent-style-name="Default">
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: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"/>
690 </style:style>
691 <style:style style:name="ce5" style:family="table-cell" style:parent-style-name="Default">
692 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
693 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
694 </style:style>
695 <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
696 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
697 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
698 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/>
699 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B3"/>
700 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/>
701 </style:style>
702 <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99">
703 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
704 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
705 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
706 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
707 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
708 </style:style>
709 <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default">
710 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
711 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
712 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/>
713 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/>
714 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/>
715 </style:style>
716 <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default">
717 <style:table-cell-properties fo:wrap-option="wrap"/>
718 <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"/>
719 </style:style>
720 <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default">
721 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
722 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
723 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
724 </style:style>
725 <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/>
726 <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N104"/>
727 <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Normal_20_2">
728 <style:table-cell-properties fo:padding="2.01pt"/>
729 </style:style>
730 <style:style style:name="ce14" 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="ce15" 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.C2"/>
741 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
742 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
743 </style:style>
744 <style:style style:name="ce16" 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:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
748 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
749 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
750 </style:style>
751 <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default">
752 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
753 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
754 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
755 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
756 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
757 </style:style>
758 <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default">
759 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/>
760 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/>
761 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/>
762 </style:style>
763 <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default">
764 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
765 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
766 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
767 </style:style>
768 <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default">
769 <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
770 <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/>
771 <style:map style:condition="cell-content()=&quot;&quot;" style:apply-style-name="Default" style:base-cell-address="Sheet2.C20"/>
772 <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C20"/>
773 <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C20"/>
774 </style:style>
775 <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default">
776 <style:text-properties style:font-name="Liberation Serif" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/>
777 </style:style>
778 <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N163">
779 <style:text-properties style:use-window-font-color="true" 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="Tahoma" style:font-size-complex="6.80000019073486pt" style:language-complex="en" style:country-complex="US"/>
780 </style:style>
781 <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default">
782 <style:table-cell-properties fo:wrap-option="wrap"/>
783 <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"/>
784 </style:style>
785 <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default">
786 <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"/>
787 </style:style>
788 <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default">
789 <style:text-properties style:use-window-font-color="true" 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="Tahoma" style:font-size-complex="6.80000019073486pt" style:language-complex="en" style:country-complex="US"/>
790 </style:style>
791 <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default">
792 <style:text-properties fo:color="#000000" style:font-name="Arial" fo:font-size="10pt" fo:language="en" fo:country="US" style:font-name-asian="Times New Roman1" style:font-size-asian="12pt" style:language-asian="ar" style:country-asian="SA"/>
793 </style:style>
794 <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default">
795 <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"/>
796 </style:style>
797 <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default">
798 <style:table-cell-properties fo:wrap-option="wrap"/>
799 <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"/>
800 </style:style>
801 <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default">
802 <style:table-cell-properties fo:wrap-option="wrap"/>
803 <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"/>
804 </style:style>
805 <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default">
806 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
807 </style:style>
808 <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36">
809 <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
810 </style:style>
811 <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"/>
812 <style:style style:name="ce33" style:family="table-cell" style:parent-style-name="Default">
813 <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"/>
814 </style:style>
815 <style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default">
816 <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"/>
817 <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
818 </style:style>
819 <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default">
820 <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"/>
821 <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/>
822 <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"/>
823 </style:style>
824 <style:style style:name="ta_extref" style:family="table">
825 <style:table-properties table:display="false"/>
826 </style:style>
827 <style:page-layout style:name="pm1">
828 <style:page-layout-properties style:first-page-number="continue" style:writing-mode="lr-tb"/>
829 <style:header-style>
830 <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-bottom="7.09pt"/>
831 </style:header-style>
832 <style:footer-style>
833 <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="0pt" fo:margin-right="0pt" fo:margin-top="7.09pt"/>
834 </style:footer-style>
835 </style:page-layout>
836 <style:page-layout style:name="pm2">
837 <style:page-layout-properties style:writing-mode="lr-tb"/>
838 <style:header-style>
839 <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">
840 <style:background-image/>
841 </style:header-footer-properties>
842 </style:header-style>
843 <style:footer-style>
844 <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">
845 <style:background-image/>
846 </style:header-footer-properties>
847 </style:footer-style>
848 </style:page-layout>
849 <style:page-layout style:name="pm3">
850 <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"/>
851 <style:header-style>
852 <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-bottom="0pt"/>
853 </style:header-style>
854 <style:footer-style>
855 <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-top="0pt"/>
856 </style:footer-style>
857 </style:page-layout>
858 <style:page-layout style:name="pm4">
859 <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"/>
860 <style:header-style>
861 <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-bottom="0pt"/>
862 </style:header-style>
863 <style:footer-style>
864 <style:header-footer-properties fo:min-height="21.26pt" fo:margin-left="3.46pt" fo:margin-right="3.46pt" fo:margin-top="0pt"/>
865 </style:footer-style>
866 </style:page-layout>
867 <style:style style:name="T1" style:family="text">
868 <style:text-properties fo:color="#000099" style:font-name="Arial" fo:font-size="9pt" fo:font-weight="bold" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="9pt" style:font-size-complex="9pt" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
869 </style:style>
870 <style:style style:name="T2" style:family="text">
871 <style:text-properties style:font-name="Arial" fo:font-size="10pt" fo:font-weight="bold" fo:country="none" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-weight-complex="bold"/>
872 </style:style>
873 <style:style style:name="T3" style:family="text">
874 <style:text-properties style:font-name="Arial" fo:font-size="10pt" fo:country="none" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt"/>
875 </style:style>
876 <style:style style:name="T4" style:family="text">
877 <style:text-properties fo:country="none" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-weight-complex="bold" style:font-name="Arial" fo:font-size="10pt" fo:font-weight="bold"/>
878 </style:style>
879 <style:style style:name="T5" style:family="text">
880 <style:text-properties fo:country="none" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt" style:font-name="Arial" fo:font-size="10pt"/>
881 </style:style>
882 <style:style style:name="T6" style:family="text">
883 <style:text-properties fo:country="none" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt" style:font-name="Arial" fo:font-size="10pt" style:font-style-complex="italic" fo:font-style="italic" style:font-style-asian="italic"/>
884 </style:style>
885 <style:style style:name="T7" style:family="text">
886 <style:text-properties fo:country="none" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt" style:font-name="Arial" fo:font-size="10pt" fo:font-style="italic" style:font-style-asian="italic" style:font-style-complex="italic"/>
887 </style:style>
888 <style:style style:name="T8" style:family="text">
889 <style:text-properties style:font-name="Arial" fo:font-size="10pt" style:country-asian="none" style:font-name-asian="Times New Roman" style:font-size-asian="12pt"/>
890 </style:style>
891 </office:automatic-styles>
892 <office:master-styles>
893 <style:master-page style:name="Default" style:page-layout-name="pm1">
894 <style:header>
895 <text:p><text:sheet-name>???</text:sheet-name></text:p>
896 </style:header>
897 <style:header-left style:display="false"/>
898 <style:footer>
899 <text:p>Page <text:page-number>1</text:page-number></text:p>
900 </style:footer>
901 <style:footer-left style:display="false"/>
902 </style:master-page>
903 <style:master-page style:name="Report" style:page-layout-name="pm2">
904 <style:header>
905 <style:region-left>
906 <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p>
907 </style:region-left>
908 <style:region-right>
909 <text:p><text:date style:data-style-name="N2" text:date-value="2016-07-21">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="17:26:13.558360840">00:00:00</text:time></text:p>
910 </style:region-right>
911 </style:header>
912 <style:header-left style:display="false"/>
913 <style:footer>
914 <text:p>Page <text:page-number>1</text:page-number> / <text:page-count>99</text:page-count></text:p>
915 </style:footer>
916 <style:footer-left style:display="false"/>
917 </style:master-page>
918 <style:master-page style:name="PageStyle_5f_Accrued_20_Interest_20_Calculation" style:display-name="PageStyle_Accrued Interest Calculation" style:page-layout-name="pm3">
919 <style:header style:display="false"/>
920 <style:header-left style:display="false"/>
921 <style:footer style:display="false"/>
922 <style:footer-left style:display="false"/>
923 </style:master-page>
924 <style:master-page style:name="PageStyle_5f_List1" style:display-name="PageStyle_List1" style:page-layout-name="pm4">
925 <style:header style:display="false"/>
926 <style:header-left style:display="false"/>
927 <style:footer style:display="false"/>
928 <style:footer-left style:display="false"/>
929 </style:master-page>
930 </office:master-styles>
931 <office:body>
932 <office:spreadsheet>
933 <table:calculation-settings table:automatic-find-labels="false"/>
934 <table:table table:name="Sheet1" table:style-name="ta1">
935 <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
936 <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/>
937 <table:table-column table:style-name="co1" table:default-cell-style-name="ce5"/>
938 <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/>
939 <table:table-row table:style-name="ro1">
940 <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string">
941 <text:p>FV Function</text:p>
942 </table:table-cell>
943 <table:table-cell table:number-columns-repeated="2"/>
944 </table:table-row>
945 <table:table-row table:style-name="ro2">
946 <table:table-cell table:number-columns-repeated="3"/>
947 </table:table-row>
948 <table:table-row table:style-name="ro3">
949 <table:table-cell table:style-name="ce3" office:value-type="string" calcext:value-type="string">
950 <text:p>Result</text:p>
951 </table:table-cell>
952 <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">
953 <text:p>TRUE</text:p>
954 </table:table-cell>
955 <table:table-cell/>
956 </table:table-row>
957 <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
958 <table:table-cell table:number-columns-repeated="3"/>
959 </table:table-row>
960 <table:table-row table:style-name="ro4">
961 <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
962 <text:p>Sheet</text:p>
963 </table:table-cell>
964 <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
965 <text:p>Result</text:p>
966 </table:table-cell>
967 <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string">
968 <text:p>Description</text:p>
969 </table:table-cell>
970 </table:table-row>
971 <table:table-row table:style-name="ro5">
972 <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
973 <text:p>1</text:p>
974 </table:table-cell>
975 <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">
976 <text:p>TRUE</text:p>
977 </table:table-cell>
978 <table:table-cell office:value-type="string" calcext:value-type="string">
979 <text:p>Simple FV formulas with local references and values</text:p>
980 </table:table-cell>
981 </table:table-row>
982 <table:table-row table:style-name="ro2" table:number-rows-repeated="3">
983 <table:table-cell/>
984 <table:table-cell table:style-name="ce8"/>
985 <table:table-cell/>
986 </table:table-row>
987 <table:table-row table:style-name="ro2">
988 <table:table-cell/>
989 <table:table-cell table:style-name="ce8"/>
990 <table:table-cell table:style-name="ce9"/>
991 </table:table-row>
992 <table:table-row table:style-name="ro2" table:number-rows-repeated="26">
993 <table:table-cell/>
994 <table:table-cell table:style-name="ce8"/>
995 <table:table-cell/>
996 </table:table-row>
997 <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537">
998 <table:table-cell table:number-columns-repeated="3"/>
999 </table:table-row>
1000 <table:table-row table:style-name="ro2">
1001 <table:table-cell table:number-columns-repeated="3"/>
1002 </table:table-row>
1003 <calcext:conditional-formats>
1004 <calcext:conditional-format calcext:target-range-address="Sheet1.B8:Sheet1.B38">
1005 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B8"/>
1006 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B8"/>
1007 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B8"/>
1008 </calcext:conditional-format>
1009 <calcext:conditional-format calcext:target-range-address="Sheet1.B3:Sheet1.B3">
1010 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet1.B3"/>
1011 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet1.B3"/>
1012 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet1.B3"/>
1013 </calcext:conditional-format>
1014 </calcext:conditional-formats>
1015 </table:table>
1016 <table:table table:name="Sheet2" table:style-name="ta1" table:print="false">
1017 <office:forms form:automatic-focus="false" form:apply-design-mode="false"/>
1018 <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/>
1019 <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/>
1020 <table:table-column table:style-name="co6" table:default-cell-style-name="ce5"/>
1021 <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/>
1022 <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/>
1023 <table:table-column table:style-name="co9" table:default-cell-style-name="Default"/>
1024 <table:table-column table:style-name="co10" 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="co11" table:default-cell-style-name="Default"/>
1027 <table:table-column table:style-name="co6" table:default-cell-style-name="Default"/>
1028 <table:table-column table:style-name="co12" table:number-columns-repeated="2" table:default-cell-style-name="Default"/>
1029 <table:table-column table:style-name="co3" table:number-columns-repeated="8" table:default-cell-style-name="Default"/>
1030 <table:table-row table:style-name="ro6">
1031 <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1032 <text:p>Function</text:p>
1033 </table:table-cell>
1034 <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1035 <text:p>Expected</text:p>
1036 </table:table-cell>
1037 <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1038 <text:p>Correct</text:p>
1039 </table:table-cell>
1040 <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1041 <text:p>FunctionString</text:p>
1042 </table:table-cell>
1043 <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string">
1044 <text:p>Comment</text:p>
1045 </table:table-cell>
1046 <table:table-cell table:number-columns-repeated="3"/>
1047 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1048 <text:p>Data </text:p>
1049 </table:table-cell>
1050 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1051 <text:p>Description </text:p>
1052 </table:table-cell>
1053 <table:table-cell table:style-name="ce33"/>
1054 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1055 <text:p>Data </text:p>
1056 </table:table-cell>
1057 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1058 <text:p>Description </text:p>
1059 </table:table-cell>
1060 <table:table-cell table:style-name="ce33"/>
1061 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1062 <text:p>Data </text:p>
1063 </table:table-cell>
1064 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1065 <text:p>Description </text:p>
1066 </table:table-cell>
1067 <table:table-cell table:style-name="ce33"/>
1068 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1069 <text:p>Data </text:p>
1070 </table:table-cell>
1071 <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string">
1072 <text:p>Description </text:p>
1073 </table:table-cell>
1074 <table:table-cell table:style-name="ce33"/>
1075 </table:table-row>
1076 <table:table-row table:style-name="ro7">
1077 <table:table-cell table:style-name="ce11" table:formula="of:=ABS(FV(0.1;12;-100;100)-1824.59)&lt;0.01" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1078 <text:p>TRUE</text:p>
1079 </table:table-cell>
1080 <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float">
1081 <text:p>1</text:p>
1082 </table:table-cell>
1083 <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A2];10)=ROUND([.B2];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1084 <text:p>TRUE</text:p>
1085 </table:table-cell>
1086 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=ABS(FV(0.1,12,-100,100)-1824.59)&lt;0.01" calcext:value-type="string">
1087 <text:p>=ABS(FV(0.1,12,-100,100)-1824.59)&lt;0.01</text:p>
1088 </table:table-cell>
1089 <table:table-cell table:style-name="ce23"/>
1090 <table:table-cell table:number-columns-repeated="3"/>
1091 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="0.06" calcext:value-type="float">
1092 <text:p>0.06</text:p>
1093 </table:table-cell>
1094 <table:table-cell office:value-type="string" calcext:value-type="string">
1095 <text:p>Annual interest rate</text:p>
1096 </table:table-cell>
1097 <table:table-cell table:style-name="ce33"/>
1098 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="0.12" calcext:value-type="float">
1099 <text:p>0.12</text:p>
1100 </table:table-cell>
1101 <table:table-cell office:value-type="string" calcext:value-type="string">
1102 <text:p>Annual interest rate</text:p>
1103 </table:table-cell>
1104 <table:table-cell table:style-name="ce33"/>
1105 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="0.11" calcext:value-type="float">
1106 <text:p>0.11</text:p>
1107 </table:table-cell>
1108 <table:table-cell office:value-type="string" calcext:value-type="string">
1109 <text:p>Annual interest rate</text:p>
1110 </table:table-cell>
1111 <table:table-cell table:style-name="ce33"/>
1112 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="0.06" calcext:value-type="float">
1113 <text:p>0.06</text:p>
1114 </table:table-cell>
1115 <table:table-cell office:value-type="string" calcext:value-type="string">
1116 <text:p>Annual interest rate</text:p>
1117 </table:table-cell>
1118 <table:table-cell table:style-name="ce33"/>
1119 </table:table-row>
1120 <table:table-row table:style-name="ro7">
1121 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.04;2;750;2500)" office:value-type="currency" office:currency="USD" office:value="-4234" calcext:value-type="currency">
1122 <text:p>-$4,234.00</text:p>
1123 </table:table-cell>
1124 <table:table-cell office:value-type="float" office:value="-4234" calcext:value-type="float">
1125 <text:p>-4234</text:p>
1126 </table:table-cell>
1127 <table:table-cell table:style-name="ce14" table:formula="of:=ROUND([.A3];10)=ROUND([.B3];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1128 <text:p>TRUE</text:p>
1129 </table:table-cell>
1130 <table:table-cell table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=FV(0.04,2,750,2500)" calcext:value-type="string">
1131 <text:p>=FV(0.04,2,750,2500)</text:p>
1132 </table:table-cell>
1133 <table:table-cell table:style-name="ce23"/>
1134 <table:table-cell table:number-columns-repeated="3"/>
1135 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="10" calcext:value-type="float">
1136 <text:p>10</text:p>
1137 </table:table-cell>
1138 <table:table-cell office:value-type="string" calcext:value-type="string">
1139 <text:p>Number of payments</text:p>
1140 </table:table-cell>
1141 <table:table-cell table:style-name="ce33"/>
1142 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="12" calcext:value-type="float">
1143 <text:p>12</text:p>
1144 </table:table-cell>
1145 <table:table-cell office:value-type="string" calcext:value-type="string">
1146 <text:p>Number of payments</text:p>
1147 </table:table-cell>
1148 <table:table-cell table:style-name="ce33"/>
1149 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="35" calcext:value-type="float">
1150 <text:p>35</text:p>
1151 </table:table-cell>
1152 <table:table-cell office:value-type="string" calcext:value-type="string">
1153 <text:p>Number of payments</text:p>
1154 </table:table-cell>
1155 <table:table-cell table:style-name="ce33"/>
1156 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="12" calcext:value-type="float">
1157 <text:p>12</text:p>
1158 </table:table-cell>
1159 <table:table-cell office:value-type="string" calcext:value-type="string">
1160 <text:p>Number of payments</text:p>
1161 </table:table-cell>
1162 <table:table-cell table:style-name="ce33"/>
1163 </table:table-row>
1164 <table:table-row table:style-name="ro7">
1165 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.075/12; 2*12; -250; -5000 ;1)" office:value-type="currency" office:currency="USD" office:value="12298.4638198035" calcext:value-type="currency">
1166 <text:p>$12,298.46</text:p>
1167 </table:table-cell>
1168 <table:table-cell office:value-type="float" office:value="12298.4638198035" calcext:value-type="float">
1169 <text:p>12298.4638198035</text:p>
1170 </table:table-cell>
1171 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A4];10)=ROUND([.B4];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1172 <text:p>TRUE</text:p>
1173 </table:table-cell>
1174 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=FV(0.075/12, 2*12, -250, -5000 ,1)" calcext:value-type="string">
1175 <text:p>=FV(0.075/12, 2*12, -250, -5000 ,1)</text:p>
1176 </table:table-cell>
1177 <table:table-cell table:style-name="ce23"/>
1178 <table:table-cell table:number-columns-repeated="3"/>
1179 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="-200" calcext:value-type="float">
1180 <text:p>-200</text:p>
1181 </table:table-cell>
1182 <table:table-cell office:value-type="string" calcext:value-type="string">
1183 <text:p>Amount of the payment</text:p>
1184 </table:table-cell>
1185 <table:table-cell table:style-name="ce33"/>
1186 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="-1000" calcext:value-type="float">
1187 <text:p>-1000</text:p>
1188 </table:table-cell>
1189 <table:table-cell office:value-type="string" calcext:value-type="string">
1190 <text:p>Amount of the payment</text:p>
1191 </table:table-cell>
1192 <table:table-cell table:style-name="ce33"/>
1193 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="-2000" calcext:value-type="float">
1194 <text:p>-2000</text:p>
1195 </table:table-cell>
1196 <table:table-cell office:value-type="string" calcext:value-type="string">
1197 <text:p>Amount of the payment</text:p>
1198 </table:table-cell>
1199 <table:table-cell table:style-name="ce33"/>
1200 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="-100" calcext:value-type="float">
1201 <text:p>-100</text:p>
1202 </table:table-cell>
1203 <table:table-cell office:value-type="string" calcext:value-type="string">
1204 <text:p>Amount of the payment</text:p>
1205 </table:table-cell>
1206 <table:table-cell table:style-name="ce33"/>
1207 </table:table-row>
1208 <table:table-row table:style-name="ro7">
1209 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.06/52; 4*52; -50; -8000; 0)" office:value-type="currency" office:currency="USD" office:value="21915.0949710678" calcext:value-type="currency">
1210 <text:p>$21,915.09</text:p>
1211 </table:table-cell>
1212 <table:table-cell office:value-type="float" office:value="21915.0949710678" calcext:value-type="float">
1213 <text:p>21915.0949710678</text:p>
1214 </table:table-cell>
1215 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A5];10)=ROUND([.B5];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1216 <text:p>TRUE</text:p>
1217 </table:table-cell>
1218 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=FV(0.06/52, 4*52, -50, -8000, 0)" calcext:value-type="string">
1219 <text:p>=FV(0.06/52, 4*52, -50, -8000, 0)</text:p>
1220 </table:table-cell>
1221 <table:table-cell table:number-columns-repeated="4"/>
1222 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="-500" calcext:value-type="float">
1223 <text:p>-500</text:p>
1224 </table:table-cell>
1225 <table:table-cell office:value-type="string" calcext:value-type="string">
1226 <text:p>Present value</text:p>
1227 </table:table-cell>
1228 <table:table-cell table:style-name="ce33"/>
1229 <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
1230 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="1" calcext:value-type="float">
1231 <text:p>1</text:p>
1232 </table:table-cell>
1233 <table:table-cell office:value-type="string" calcext:value-type="string">
1234 <text:p>Payment is due at the beginning of the year (0 indicates end of year)</text:p>
1235 </table:table-cell>
1236 <table:table-cell table:style-name="ce33"/>
1237 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="-1000" calcext:value-type="float">
1238 <text:p>-1000</text:p>
1239 </table:table-cell>
1240 <table:table-cell office:value-type="string" calcext:value-type="string">
1241 <text:p>Present value</text:p>
1242 </table:table-cell>
1243 <table:table-cell table:style-name="ce33"/>
1244 </table:table-row>
1245 <table:table-row table:style-name="ro7">
1246 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; -6500; 0)" office:value-type="currency" office:currency="USD" office:value="12115.1879428082" calcext:value-type="currency">
1247 <text:p>$12,115.19</text:p>
1248 </table:table-cell>
1249 <table:table-cell office:value-type="float" office:value="12115.1879428082" calcext:value-type="float">
1250 <text:p>12115.1879428082</text:p>
1251 </table:table-cell>
1252 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A6];10)=ROUND([.B6];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1253 <text:p>TRUE</text:p>
1254 </table:table-cell>
1255 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, -6500, 0)" calcext:value-type="string">
1256 <text:p>=FV(0.0525/1, 10*1, -100, -6500, 0)</text:p>
1257 </table:table-cell>
1258 <table:table-cell table:number-columns-repeated="4"/>
1259 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="1" calcext:value-type="float">
1260 <text:p>1</text:p>
1261 </table:table-cell>
1262 <table:table-cell office:value-type="string" calcext:value-type="string">
1263 <text:p>Payment is due at the beginning of the period (0 indicates payment is due at end of period)</text:p>
1264 </table:table-cell>
1265 <table:table-cell table:style-name="ce33"/>
1266 <table:table-cell/>
1267 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1268 <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
1269 <table:table-cell table:style-name="ce29" office:value-type="float" office:value="1" calcext:value-type="float">
1270 <text:p>1</text:p>
1271 </table:table-cell>
1272 <table:table-cell office:value-type="string" calcext:value-type="string">
1273 <text:p>Payment is due at the beginning of the year (0 indicates end of year)</text:p>
1274 </table:table-cell>
1275 <table:table-cell table:style-name="ce33"/>
1276 </table:table-row>
1277 <table:table-row table:style-name="ro7">
1278 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; -6500; 1)" office:value-type="currency" office:currency="USD" office:value="12181.9975443941" calcext:value-type="currency">
1279 <text:p>$12,182.00</text:p>
1280 </table:table-cell>
1281 <table:table-cell office:value-type="float" office:value="12181.9975443941" calcext:value-type="float">
1282 <text:p>12181.9975443941</text:p>
1283 </table:table-cell>
1284 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A7];10)=ROUND([.B7];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1285 <text:p>TRUE</text:p>
1286 </table:table-cell>
1287 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, -6500, 1)" calcext:value-type="string">
1288 <text:p>=FV(0.0525/1, 10*1, -100, -6500, 1)</text:p>
1289 </table:table-cell>
1290 <table:table-cell table:number-columns-repeated="4"/>
1291 <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
1292 <table:table-cell table:style-name="ce34" table:number-columns-repeated="2"/>
1293 <table:table-cell table:style-name="ce30"/>
1294 <table:table-cell/>
1295 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1296 <table:table-cell table:style-name="ce28" table:number-columns-repeated="3"/>
1297 </table:table-row>
1298 <table:table-row table:style-name="ro7">
1299 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; -6500; 2)" office:value-type="currency" office:currency="USD" office:value="12181.9975443941" calcext:value-type="currency">
1300 <text:p>$12,182.00</text:p>
1301 </table:table-cell>
1302 <table:table-cell office:value-type="float" office:value="12181.9975443941" calcext:value-type="float">
1303 <text:p>12181.9975443941</text:p>
1304 </table:table-cell>
1305 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A8];10)=ROUND([.B8];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1306 <text:p>TRUE</text:p>
1307 </table:table-cell>
1308 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, -6500, 2)" calcext:value-type="string">
1309 <text:p>=FV(0.0525/1, 10*1, -100, -6500, 2)</text:p>
1310 </table:table-cell>
1311 <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string">
1312 <text:p>PayType: the type of payment, defaults to 0. It is 0 if payments are due at the end of the period; 1 if they are due at the beginning of the period.</text:p>
1313 </table:table-cell>
1314 <table:table-cell table:number-columns-repeated="4"/>
1315 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1316 <table:table-cell table:style-name="ce34" table:number-columns-repeated="2"/>
1317 <table:table-cell table:number-columns-repeated="5"/>
1318 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1319 </table:table-row>
1320 <table:table-row table:style-name="ro8">
1321 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; -6500; -2)" office:value-type="currency" office:currency="USD" office:value="12181.9975443941" calcext:value-type="currency">
1322 <text:p>$12,182.00</text:p>
1323 </table:table-cell>
1324 <table:table-cell office:value-type="float" office:value="12181.9975443941" calcext:value-type="float">
1325 <text:p>12181.9975443941</text:p>
1326 </table:table-cell>
1327 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A9];10)=ROUND([.B9];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1328 <text:p>TRUE</text:p>
1329 </table:table-cell>
1330 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, -6500, -2)" calcext:value-type="string">
1331 <text:p>=FV(0.0525/1, 10*1, -100, -6500, -2)</text:p>
1332 </table:table-cell>
1333 <table:table-cell office:value-type="string" calcext:value-type="string"><text:p>PayType should be Logical, not Number. Excel and Gnumeric do the same.</text:p><text:p/><text:p><text:a xlink:href="https://lists.oasis-open.org/archives/office-comment/201607/msg00004.html" xlink:type="simple">https://lists.oasis-open.org/archives/office-comment/201607/msg00004.html</text:a></text:p>
1334 </table:table-cell>
1335 <table:table-cell table:number-columns-repeated="4"/>
1336 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1337 <table:table-cell table:style-name="ce35" table:number-columns-repeated="2"/>
1338 <table:table-cell table:number-columns-repeated="7"/>
1339 </table:table-row>
1340 <table:table-row table:style-name="ro7">
1341 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; -6500; )" office:value-type="currency" office:currency="USD" office:value="12115.1879428082" calcext:value-type="currency">
1342 <text:p>$12,115.19</text:p>
1343 </table:table-cell>
1344 <table:table-cell office:value-type="float" office:value="12115.1879428082" calcext:value-type="float">
1345 <text:p>12115.1879428082</text:p>
1346 </table:table-cell>
1347 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A10];10)=ROUND([.B10];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1348 <text:p>TRUE</text:p>
1349 </table:table-cell>
1350 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, -6500, )" calcext:value-type="string">
1351 <text:p>=FV(0.0525/1, 10*1, -100, -6500, )</text:p>
1352 </table:table-cell>
1353 <table:table-cell table:number-columns-repeated="5"/>
1354 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1355 <table:table-cell/>
1356 <table:table-cell table:style-name="ce34"/>
1357 <table:table-cell table:style-name="ce30"/>
1358 <table:table-cell table:number-columns-repeated="6"/>
1359 </table:table-row>
1360 <table:table-row table:style-name="ro7">
1361 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; -6500)" office:value-type="currency" office:currency="USD" office:value="12115.1879428082" calcext:value-type="currency">
1362 <text:p>$12,115.19</text:p>
1363 </table:table-cell>
1364 <table:table-cell office:value-type="float" office:value="12115.1879428082" calcext:value-type="float">
1365 <text:p>12115.1879428082</text:p>
1366 </table:table-cell>
1367 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A11];10)=ROUND([.B11];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1368 <text:p>TRUE</text:p>
1369 </table:table-cell>
1370 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, -6500)" calcext:value-type="string">
1371 <text:p>=FV(0.0525/1, 10*1, -100, -6500)</text:p>
1372 </table:table-cell>
1373 <table:table-cell table:style-name="ce25"/>
1374 <table:table-cell table:number-columns-repeated="4"/>
1375 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1376 <table:table-cell table:number-columns-repeated="9"/>
1377 </table:table-row>
1378 <table:table-row table:style-name="ro7">
1379 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; )" office:value-type="currency" office:currency="USD" office:value="1272.56383972991" calcext:value-type="currency">
1380 <text:p>$1,272.56</text:p>
1381 </table:table-cell>
1382 <table:table-cell office:value-type="float" office:value="1272.56383972991" calcext:value-type="float">
1383 <text:p>1272.56383972991</text:p>
1384 </table:table-cell>
1385 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A12];10)=ROUND([.B12];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1386 <text:p>TRUE</text:p>
1387 </table:table-cell>
1388 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, )" calcext:value-type="string">
1389 <text:p>=FV(0.0525/1, 10*1, -100, )</text:p>
1390 </table:table-cell>
1391 <table:table-cell table:number-columns-repeated="5"/>
1392 <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/>
1393 <table:table-cell table:number-columns-repeated="9"/>
1394 </table:table-row>
1395 <table:table-row table:style-name="ro7">
1396 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100;0;0 )" office:value-type="currency" office:currency="USD" office:value="1272.56383972991" calcext:value-type="currency">
1397 <text:p>$1,272.56</text:p>
1398 </table:table-cell>
1399 <table:table-cell office:value-type="float" office:value="1272.56383972991" calcext:value-type="float">
1400 <text:p>1272.56383972991</text:p>
1401 </table:table-cell>
1402 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A13];10)=ROUND([.B13];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1403 <text:p>TRUE</text:p>
1404 </table:table-cell>
1405 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100,0,0 )" calcext:value-type="string">
1406 <text:p>=FV(0.0525/1, 10*1, -100,0,0 )</text:p>
1407 </table:table-cell>
1408 <table:table-cell table:number-columns-repeated="5"/>
1409 <table:table-cell table:style-name="ce30"/>
1410 <table:table-cell table:style-name="ce32"/>
1411 <table:table-cell table:style-name="ce30" table:number-columns-repeated="3"/>
1412 <table:table-cell table:number-columns-repeated="6"/>
1413 </table:table-row>
1414 <table:table-row table:style-name="ro7">
1415 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100 )" office:value-type="currency" office:currency="USD" office:value="1272.56383972991" calcext:value-type="currency">
1416 <text:p>$1,272.56</text:p>
1417 </table:table-cell>
1418 <table:table-cell office:value-type="float" office:value="1272.56383972991" calcext:value-type="float">
1419 <text:p>1272.56383972991</text:p>
1420 </table:table-cell>
1421 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A14];10)=ROUND([.B14];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1422 <text:p>TRUE</text:p>
1423 </table:table-cell>
1424 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100 )" calcext:value-type="string">
1425 <text:p>=FV(0.0525/1, 10*1, -100 )</text:p>
1426 </table:table-cell>
1427 <table:table-cell table:number-columns-repeated="16"/>
1428 </table:table-row>
1429 <table:table-row table:style-name="ro7">
1430 <table:table-cell table:style-name="ce12" table:formula="of:=FV(0.0525/1; 10*1; -100; ; 0)" office:value-type="currency" office:currency="USD" office:value="1272.56383972991" calcext:value-type="currency">
1431 <text:p>$1,272.56</text:p>
1432 </table:table-cell>
1433 <table:table-cell office:value-type="float" office:value="1272.56383972991" calcext:value-type="float">
1434 <text:p>1272.56383972991</text:p>
1435 </table:table-cell>
1436 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A15];10)=ROUND([.B15];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1437 <text:p>TRUE</text:p>
1438 </table:table-cell>
1439 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=FV(0.0525/1, 10*1, -100, , 0)" calcext:value-type="string">
1440 <text:p>=FV(0.0525/1, 10*1, -100, , 0)</text:p>
1441 </table:table-cell>
1442 <table:table-cell table:number-columns-repeated="6"/>
1443 <table:table-cell table:style-name="ce32"/>
1444 <table:table-cell table:number-columns-repeated="9"/>
1445 </table:table-row>
1446 <table:table-row table:style-name="ro7">
1447 <table:table-cell table:style-name="ce12" table:formula="of:=FV([.I2]/12; [.I3]; [.I4]; [.I5]; [.I6])" office:value-type="currency" office:currency="USD" office:value="2581.40337406014" calcext:value-type="currency">
1448 <text:p>$2,581.40</text:p>
1449 </table:table-cell>
1450 <table:table-cell office:value-type="float" office:value="2581.40337406014" calcext:value-type="float">
1451 <text:p>2581.40337406014</text:p>
1452 </table:table-cell>
1453 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A16];10)=ROUND([.B16];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1454 <text:p>TRUE</text:p>
1455 </table:table-cell>
1456 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=FV(I2/12, I3, I4, I5, I6)" calcext:value-type="string">
1457 <text:p>=FV(I2/12, I3, I4, I5, I6)</text:p>
1458 </table:table-cell>
1459 <table:table-cell table:number-columns-repeated="5"/>
1460 <table:table-cell table:style-name="ce31"/>
1461 <table:table-cell table:style-name="ce32"/>
1462 <table:table-cell table:style-name="ce30" table:number-columns-repeated="3"/>
1463 <table:table-cell table:number-columns-repeated="6"/>
1464 </table:table-row>
1465 <table:table-row table:style-name="ro7">
1466 <table:table-cell table:style-name="ce12" table:formula="of:=FV([.L2]/12;[.L3]; [.L4])" office:value-type="currency" office:currency="USD" office:value="12682.503013197" calcext:value-type="currency">
1467 <text:p>$12,682.50</text:p>
1468 </table:table-cell>
1469 <table:table-cell office:value-type="float" office:value="12682.503013197" calcext:value-type="float">
1470 <text:p>12682.503013197</text:p>
1471 </table:table-cell>
1472 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A17];10)=ROUND([.B17];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1473 <text:p>TRUE</text:p>
1474 </table:table-cell>
1475 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=FV(L2/12,L3, L4)" calcext:value-type="string">
1476 <text:p>=FV(L2/12,L3, L4)</text:p>
1477 </table:table-cell>
1478 <table:table-cell table:number-columns-repeated="6"/>
1479 <table:table-cell table:style-name="ce32"/>
1480 <table:table-cell table:number-columns-repeated="9"/>
1481 </table:table-row>
1482 <table:table-row table:style-name="ro7">
1483 <table:table-cell table:style-name="ce12" table:formula="of:=FV([.O2]/12; [.O3]; [.O4];; [.O5])" office:value-type="currency" office:currency="USD" office:value="82846.2463719006" calcext:value-type="currency">
1484 <text:p>$82,846.25</text:p>
1485 </table:table-cell>
1486 <table:table-cell office:value-type="float" office:value="82846.2463719006" calcext:value-type="float">
1487 <text:p>82846.2463719006</text:p>
1488 </table:table-cell>
1489 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A18];10)=ROUND([.B18];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1490 <text:p>TRUE</text:p>
1491 </table:table-cell>
1492 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=FV(O2/12, O3, O4,, O5)" calcext:value-type="string">
1493 <text:p>=FV(O2/12, O3, O4,, O5)</text:p>
1494 </table:table-cell>
1495 <table:table-cell table:number-columns-repeated="16"/>
1496 </table:table-row>
1497 <table:table-row table:style-name="ro7">
1498 <table:table-cell table:style-name="ce12" table:formula="of:=FV([.R2]/12; [.R3]; [.R4]; [.R5]; [.R6])" office:value-type="currency" office:currency="USD" office:value="2301.40183034091" calcext:value-type="currency">
1499 <text:p>$2,301.40</text:p>
1500 </table:table-cell>
1501 <table:table-cell office:value-type="float" office:value="2301.40183034091" calcext:value-type="float">
1502 <text:p>2301.40183034091</text:p>
1503 </table:table-cell>
1504 <table:table-cell table:style-name="ce15" table:formula="of:=ROUND([.A19];10)=ROUND([.B19];10)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean">
1505 <text:p>TRUE</text:p>
1506 </table:table-cell>
1507 <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="=FV(R2/12, R3, R4, R5, R6)" calcext:value-type="string">
1508 <text:p>=FV(R2/12, R3, R4, R5, R6)</text:p>
1509 </table:table-cell>
1510 <table:table-cell table:number-columns-repeated="16"/>
1511 </table:table-row>
1512 <table:table-row table:style-name="ro9">
1513 <table:table-cell table:number-columns-repeated="2"/>
1514 <table:table-cell table:style-name="ce16"/>
1515 <table:table-cell table:style-name="ce22"/>
1516 <table:table-cell office:value-type="string" calcext:value-type="string"><text:p><text:span text:style-name="T1">FV</text:span></text:p><text:p><text:span text:style-name="T2">Summary:</text:span><text:span text:style-name="T3"> Compute the future value (FV) of an investment.</text:span></text:p><text:p><text:span text:style-name="T4">Syntax:</text:span><text:span text:style-name="T5"> FV( </text:span><text:span text:style-name="T6">Number</text:span><text:span text:style-name="T5"> Rate ; </text:span><text:span text:style-name="T7">Number</text:span><text:span text:style-name="T5"> Nper ; </text:span><text:span text:style-name="T7">Number</text:span><text:span text:style-name="T5"> Payment [ ; [ </text:span><text:span text:style-name="T7">Number</text:span><text:span text:style-name="T5"> Pv = 0 ] [ ; </text:span><text:span text:style-name="T7">Number</text:span><text:span text:style-name="T5"> PayType = 0 ] ] )</text:span></text:p><text:p><text:span text:style-name="T2">Returns:</text:span><text:span text:style-name="T3"> Currency</text:span></text:p><text:p><text:span text:style-name="T2">Constraints:</text:span><text:span text:style-name="T3"> None.</text:span></text:p><text:p><text:span text:style-name="T2">Semantics:</text:span><text:span text:style-name="T3"> Computes the future value of an investment. The parameters are:</text:span></text:p><text:p><text:span text:style-name="T8">Rate: the interest rate per period.</text:span></text:p><text:p><text:span text:style-name="T8">Nper: the total number of payment periods.</text:span></text:p><text:p><text:span text:style-name="T8">Payment: the payment made in each period.</text:span></text:p><text:p><text:span text:style-name="T8">Pv: the present value; default is 0.</text:span></text:p><text:p><text:span text:style-name="T8">PayType: the type of payment, defaults to 0. It is 0 if payments are due at the end of the period; 1 if they are due at the beginning of the period.</text:span></text:p>
1517 </table:table-cell>
1518 <table:table-cell table:number-columns-repeated="15"/>
1519 </table:table-row>
1520 <table:table-row table:style-name="ro7">
1521 <table:table-cell table:number-columns-repeated="2"/>
1522 <table:table-cell table:style-name="ce16"/>
1523 <table:table-cell table:style-name="ce21"/>
1524 <table:table-cell table:number-columns-repeated="16"/>
1525 </table:table-row>
1526 <table:table-row table:style-name="ro7">
1527 <table:table-cell table:number-columns-repeated="2"/>
1528 <table:table-cell table:style-name="ce16"/>
1529 <table:table-cell table:style-name="ce21"/>
1530 <table:table-cell table:style-name="ce26"/>
1531 <table:table-cell table:number-columns-repeated="15"/>
1532 </table:table-row>
1533 <table:table-row table:style-name="ro7" table:number-rows-repeated="2">
1534 <table:table-cell table:number-columns-repeated="2"/>
1535 <table:table-cell table:style-name="ce16"/>
1536 <table:table-cell table:style-name="ce21"/>
1537 <table:table-cell table:style-name="ce27"/>
1538 <table:table-cell table:number-columns-repeated="15"/>
1539 </table:table-row>
1540 <table:table-row table:style-name="ro7">
1541 <table:table-cell table:number-columns-repeated="2"/>
1542 <table:table-cell table:style-name="ce17"/>
1543 <table:table-cell table:number-columns-repeated="17"/>
1544 </table:table-row>
1545 <table:table-row table:style-name="ro10">
1546 <table:table-cell table:number-columns-repeated="2"/>
1547 <table:table-cell table:style-name="ce17"/>
1548 <table:table-cell table:number-columns-repeated="17"/>
1549 </table:table-row>
1550 <table:table-row table:style-name="ro7">
1551 <table:table-cell table:number-columns-repeated="2"/>
1552 <table:table-cell table:style-name="ce17"/>
1553 <table:table-cell table:number-columns-repeated="6"/>
1554 <table:table-cell table:style-name="ce32"/>
1555 <table:table-cell table:number-columns-repeated="10"/>
1556 </table:table-row>
1557 <table:table-row table:style-name="ro7">
1558 <table:table-cell table:number-columns-repeated="2"/>
1559 <table:table-cell table:style-name="ce18"/>
1560 <table:table-cell table:number-columns-repeated="17"/>
1561 </table:table-row>
1562 <table:table-row table:style-name="ro11">
1563 <table:table-cell table:number-columns-repeated="2"/>
1564 <table:table-cell table:style-name="ce19"/>
1565 <table:table-cell table:number-columns-repeated="17"/>
1566 </table:table-row>
1567 <table:table-row table:style-name="ro7">
1568 <table:table-cell/>
1569 <table:table-cell table:style-name="ce13" table:number-columns-repeated="4"/>
1570 <table:table-cell table:style-name="Normal_20_2" table:number-columns-repeated="2"/>
1571 <table:table-cell table:number-columns-repeated="13"/>
1572 </table:table-row>
1573 <table:table-row table:style-name="ro7" table:number-rows-repeated="10">
1574 <table:table-cell table:style-name="ce13" table:number-columns-repeated="5"/>
1575 <table:table-cell table:number-columns-repeated="15"/>
1576 </table:table-row>
1577 <table:table-row table:style-name="ro2" table:number-rows-repeated="60">
1578 <table:table-cell table:number-columns-repeated="2"/>
1579 <table:table-cell table:style-name="ce20"/>
1580 <table:table-cell table:number-columns-repeated="17"/>
1581 </table:table-row>
1582 <table:table-row table:style-name="ro2" table:number-rows-repeated="1048475">
1583 <table:table-cell table:number-columns-repeated="20"/>
1584 </table:table-row>
1585 <table:table-row table:style-name="ro2">
1586 <table:table-cell table:number-columns-repeated="20"/>
1587 </table:table-row>
1588 <calcext:conditional-formats>
1589 <calcext:conditional-format calcext:target-range-address="Sheet2.C41:Sheet2.C100 Sheet2.C29:Sheet2.C29 Sheet2.C20:Sheet2.C27">
1590 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C20"/>
1591 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C20"/>
1592 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C20"/>
1593 </calcext:conditional-format>
1594 <calcext:conditional-format calcext:target-range-address="Sheet2.C4:Sheet2.C29 Sheet2.C2:Sheet2.C19">
1595 <calcext:condition calcext:apply-style-name="Default" calcext:value="=&quot;&quot;" calcext:base-cell-address="Sheet2.C2"/>
1596 <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/>
1597 <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/>
1598 </calcext:conditional-format>
1599 </calcext:conditional-formats>
1600 </table:table>
1601 <table:table table:name="&apos;file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/fv.fods/fv.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods&apos;#Sheet2" table:print="false" table:style-name="ta_extref">
1602 <table:table-source xlink:type="simple" xlink:href="fv.fods/function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/>
1603 <table:table-column table:number-columns-repeated="8"/>
1604 <table:table-row table:number-rows-repeated="2">
1605 <table:table-cell table:number-columns-repeated="8"/>
1606 </table:table-row>
1607 <table:table-row>
1608 <table:table-cell table:number-columns-repeated="7"/>
1609 <table:table-cell table:style-name="ce1" office:value-type="float" office:value="4">
1610 <text:p>4</text:p>
1611 </table:table-cell>
1612 </table:table-row>
1613 </table:table>
1614 <table:named-expressions>
1615 <table:named-range table:name="day1" table:base-cell-address="$Sheet2.$K$2" table:cell-range-address="$Sheet2.$K$2"/>
1616 <table:named-range table:name="day2" table:base-cell-address="$Sheet2.$K$3" table:cell-range-address="$Sheet2.$K$3"/>
1617 <table:named-range table:name="days" table:base-cell-address="$Sheet2.$K$4" table:cell-range-address="$Sheet2.$K$4:.$K$6"/>
1618 <table:named-range table:name="one" table:base-cell-address="$Sheet2.$M$1" table:cell-range-address="$Sheet2.$M$1"/>
1619 </table:named-expressions>
1620 </office:spreadsheet>
1621 </office:body>
1622 </office:document>