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">
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"/>
9 <number:number-style style:
name=
"N0">
10 <number:number number:
min-integer-digits=
"1"/>
11 </number:number-style>
12 <number:currency-style style:
name=
"N122P0" style:
volatile=
"true">
13 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
14 <number:text> </number:text>
15 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
16 </number:currency-style>
17 <number:currency-style style:
name=
"N122">
18 <style:text-properties fo:
color=
"#ff0000"/>
19 <number:text>-
</number:text>
20 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
21 <number:text> </number:text>
22 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
23 <style:map style:
condition=
"value()>=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()>0" style:
apply-style-name=
"N126P0"/>
46 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N126P1"/>
47 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N126P2"/>
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()>=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()>=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()>=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()>=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()>=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()>=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()>=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()>=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()>=0" style:
apply-style-name=
"N142P0"/>
145 </number:currency-style>
146 <number:currency-style style:
name=
"N144P0" style:
volatile=
"true">
147 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
148 <number:text> </number:text>
149 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
150 </number:currency-style>
151 <number:currency-style style:
name=
"N144">
152 <number:text>-
</number:text>
153 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
154 <number:text> </number:text>
155 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
156 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N144P0"/>
157 </number:currency-style>
158 <number:currency-style style:
name=
"N145P0" style:
volatile=
"true">
159 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
160 <number:text> </number:text>
161 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
162 </number:currency-style>
163 <number:currency-style style:
name=
"N145">
164 <number:text>-
</number:text>
165 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
166 <number:text> </number:text>
167 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
168 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N145P0"/>
169 </number:currency-style>
170 <number:currency-style style:
name=
"N146P0" style:
volatile=
"true">
171 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
172 <number:text> </number:text>
173 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
174 </number:currency-style>
175 <number:currency-style style:
name=
"N146">
176 <style:text-properties fo:
color=
"#ff0000"/>
177 <number:text>-
</number:text>
178 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
179 <number:text> </number:text>
180 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
181 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N146P0"/>
182 </number:currency-style>
183 <number:currency-style style:
name=
"N148P0" style:
volatile=
"true">
184 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
185 <number:text> </number:text>
186 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
187 </number:currency-style>
188 <number:currency-style style:
name=
"N148">
189 <style:text-properties fo:
color=
"#ff0000"/>
190 <number:text>-
</number:text>
191 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
192 <number:text> </number:text>
193 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
194 <style:map style:
condition=
"value()>=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()>=0" style:
apply-style-name=
"N167P0"/>
259 </number:currency-style>
260 <number:number-style style:
name=
"N169P0" style:
volatile=
"true">
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()>=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>
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>
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()>=0" style:
apply-style-name=
"N173P0"/>
301 </number:currency-style>
302 <number:number-style style:
name=
"N175P0" style:
volatile=
"true">
303 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
304 <number:text> Kč
</number:text>
305 </number:number-style>
306 <number:number-style style:
name=
"N175">
307 <number:text>-
</number:text>
308 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
309 <number:text> Kč
</number:text>
310 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N175P0"/>
311 </number:number-style>
312 <number:number-style style:
name=
"N176P0" style:
volatile=
"true">
313 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
314 <number:text> Kč
</number:text>
315 </number:number-style>
316 <number:number-style style:
name=
"N176">
317 <style:text-properties fo:
color=
"#ff0000"/>
318 <number:text>-
</number:text>
319 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
320 <number:text> Kč
</number:text>
321 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N176P0"/>
322 </number:number-style>
323 <number:number-style style:
name=
"N178P0" style:
volatile=
"true">
324 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
325 <number:text> Kč
</number:text>
326 </number:number-style>
327 <number:number-style style:
name=
"N178">
328 <number:text>-
</number:text>
329 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
330 <number:text> Kč
</number:text>
331 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N178P0"/>
332 </number:number-style>
333 <number:number-style style:
name=
"N179P0" style:
volatile=
"true">
334 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
335 <number:text> Kč
</number:text>
336 </number:number-style>
337 <number:number-style style:
name=
"N179">
338 <style:text-properties fo:
color=
"#ff0000"/>
339 <number:text>-
</number:text>
340 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
341 <number:text> Kč
</number:text>
342 <style:map style:
condition=
"value()>=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()>=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()>=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()>=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()>=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()>0" style:
apply-style-name=
"N187P0"/>
397 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N187P1"/>
398 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N187P2"/>
400 <number:number-style style:
name=
"N191P0" style:
volatile=
"true">
401 <loext:fill-character> </loext:fill-character>
402 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
403 <number:text> Kč
</number:text>
404 </number:number-style>
405 <number:number-style style:
name=
"N191P1" style:
volatile=
"true">
406 <loext:text>-
</loext:text>
407 <loext:fill-character> </loext:fill-character>
408 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
409 <number:text> Kč
</number:text>
410 </number:number-style>
411 <number:number-style style:
name=
"N191P2" style:
volatile=
"true">
412 <loext:fill-character> </loext:fill-character>
413 <number:text>- Kč
</number:text>
414 </number:number-style>
415 <number:text-style style:
name=
"N191">
416 <number:text-content/>
417 <number:text> </number:text>
418 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N191P0"/>
419 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N191P1"/>
420 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N191P2"/>
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()>0" style:
apply-style-name=
"N195P0"/>
443 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N195P1"/>
444 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N195P2"/>
446 <number:number-style style:
name=
"N199P0" style:
volatile=
"true">
447 <loext:fill-character> </loext:fill-character>
448 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
449 <number:text> Kč
</number:text>
450 </number:number-style>
451 <number:number-style style:
name=
"N199P1" style:
volatile=
"true">
452 <loext:text>-
</loext:text>
453 <loext:fill-character> </loext:fill-character>
454 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
455 <number:text> Kč
</number:text>
456 </number:number-style>
457 <number:number-style style:
name=
"N199P2" style:
volatile=
"true">
458 <loext:fill-character> </loext:fill-character>
459 <number:text>-
</number:text>
460 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"0"/>
461 <number:text> Kč
</number:text>
462 </number:number-style>
463 <number:text-style style:
name=
"N199">
464 <number:text-content/>
465 <number:text> </number:text>
466 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N199P0"/>
467 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N199P1"/>
468 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N199P2"/>
470 <number:time-style style:
name=
"N200">
471 <number:minutes number:
style=
"long"/>
472 <number:text>:
</number:text>
473 <number:seconds number:
style=
"long"/>
475 <number:time-style style:
name=
"N201" number:
truncate-on-overflow=
"false">
477 <number:text>:
</number:text>
478 <number:minutes number:
style=
"long"/>
479 <number:text>:
</number:text>
480 <number:seconds number:
style=
"long"/>
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"/>
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()>0" style:
apply-style-name=
"N205P0"/>
499 <style:map style:
condition=
"value()<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()>0" style:
apply-style-name=
"N207P0"/>
510 <style:map style:
condition=
"value()<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()>0" style:
apply-style-name=
"N209P0"/>
521 <style:map style:
condition=
"value()<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>
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>
539 <number:text>)
</number:text>
540 <style:map style:
condition=
"value()>=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=
"'Droid Sans Fallback'" 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=
"'Droid Sans Devanagari'" style:
font-family-generic-complex=
"system" style:
font-pitch-complex=
"variable" style:
font-size-complex=
"11pt"/>
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"/>
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"/>
555 <style:style style:
name=
"Heading1" style:
family=
"table-cell" style:
parent-style-name=
"Heading">
556 <style:table-cell-properties style:
rotation-angle=
"90"/>
558 <style:style style:
name=
"Untitled1" style:
family=
"table-cell" style:
parent-style-name=
"Default">
559 <style:table-cell-properties fo:
background-color=
"#ff3333"/>
561 <style:style style:
name=
"Untitled2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
562 <style:table-cell-properties fo:
background-color=
"#99ff66"/>
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"/>
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=
"'Times New Roman'" 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=
"'Times New Roman'" 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"/>
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=
"'Times New Roman'" 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=
"'Times New Roman'" 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"/>
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"/>
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"/>
585 <style:style style:
name=
"co2" style:
family=
"table-column">
586 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"252.51pt"/>
588 <style:style style:
name=
"co3" style:
family=
"table-column">
589 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"64.01pt"/>
591 <style:style style:
name=
"co4" style:
family=
"table-column">
592 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"142.44pt"/>
594 <style:style style:
name=
"co5" style:
family=
"table-column">
595 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"89.94pt"/>
597 <style:style style:
name=
"co6" style:
family=
"table-column">
598 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"74.21pt"/>
600 <style:style style:
name=
"co7" style:
family=
"table-column">
601 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"345.8pt"/>
603 <style:style style:
name=
"co8" style:
family=
"table-column">
604 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"140.94pt"/>
606 <style:style style:
name=
"co9" style:
family=
"table-column">
607 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"16.44pt"/>
609 <style:style style:
name=
"co10" style:
family=
"table-column">
610 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"46.46pt"/>
612 <style:style style:
name=
"co11" style:
family=
"table-column">
613 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"78.29pt"/>
615 <style:style style:
name=
"co12" style:
family=
"table-column">
616 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"71.21pt"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
661 <number:boolean-style style:
name=
"N99">
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()>=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"/>
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"/>
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"/>
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"/>
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()=""" 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"/>
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()=""" 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"/>
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()=""" 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"/>
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"/>
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"/>
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"/>
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()=""" 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"/>
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()=""" 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"/>
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()=""" 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"/>
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()=""" 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"/>
758 <style:style style:
name=
"ce18" style:
family=
"table-cell" style:
parent-style-name=
"Default">
759 <style:map style:
condition=
"cell-content()=""" 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"/>
763 <style:style style:
name=
"ce19" style:
family=
"table-cell" style:
parent-style-name=
"Default">
764 <style:map style:
condition=
"cell-content()=""" 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"/>
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()=""" 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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
824 <style:style style:
name=
"ta_extref" style:
family=
"table">
825 <style:table-properties table:
display=
"false"/>
827 <style:page-layout style:
name=
"pm1">
828 <style:page-layout-properties style:
first-page-number=
"continue" style:
writing-mode=
"lr-tb"/>
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>
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>
836 <style:page-layout style:
name=
"pm2">
837 <style:page-layout-properties style:
writing-mode=
"lr-tb"/>
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>
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>
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"/>
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>
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>
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"/>
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>
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>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
891 </office:automatic-styles>
892 <office:master-styles>
893 <style:master-page style:
name=
"Default" style:
page-layout-name=
"pm1">
895 <text:p><text:sheet-name>???
</text:sheet-name></text:p>
897 <style:header-left style:
display=
"false"/>
899 <text:p>Page
<text:page-number>1</text:page-number></text:p>
901 <style:footer-left style:
display=
"false"/>
903 <style:master-page style:
name=
"Report" style:
page-layout-name=
"pm2">
906 <text:p><text:sheet-name>???
</text:sheet-name> (
<text:title>???
</text:title>)
</text:p>
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>
912 <style:header-left style:
display=
"false"/>
914 <text:p>Page
<text:page-number>1</text:page-number> /
<text:page-count>99</text:page-count></text:p>
916 <style:footer-left style:
display=
"false"/>
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"/>
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"/>
930 </office:master-styles>
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>
943 <table:table-cell table:
number-columns-repeated=
"2"/>
945 <table:table-row table:
style-name=
"ro2">
946 <table:table-cell table:
number-columns-repeated=
"3"/>
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>
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>
957 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
958 <table:table-cell table:
number-columns-repeated=
"3"/>
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>
964 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
965 <text:p>Result
</text:p>
967 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
968 <text:p>Description
</text:p>
971 <table:table-row table:
style-name=
"ro5">
972 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
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>
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>
982 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
984 <table:table-cell table:
style-name=
"ce8"/>
987 <table:table-row table:
style-name=
"ro2">
989 <table:table-cell table:
style-name=
"ce8"/>
990 <table:table-cell table:
style-name=
"ce9"/>
992 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"26">
994 <table:table-cell table:
style-name=
"ce8"/>
997 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048537">
998 <table:table-cell table:
number-columns-repeated=
"3"/>
1000 <table:table-row table:
style-name=
"ro2">
1001 <table:table-cell table:
number-columns-repeated=
"3"/>
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=
"=""" 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=
"=""" 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>
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>
1034 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1035 <text:p>Expected
</text:p>
1037 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1038 <text:p>Correct
</text:p>
1040 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1041 <text:p>FunctionString
</text:p>
1043 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1044 <text:p>Comment
</text:p>
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>
1050 <table:table-cell table:
style-name=
"ce28" office:
value-type=
"string" calcext:
value-type=
"string">
1051 <text:p>Description
</text:p>
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>
1057 <table:table-cell table:
style-name=
"ce28" office:
value-type=
"string" calcext:
value-type=
"string">
1058 <text:p>Description
</text:p>
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>
1064 <table:table-cell table:
style-name=
"ce28" office:
value-type=
"string" calcext:
value-type=
"string">
1065 <text:p>Description
</text:p>
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>
1071 <table:table-cell table:
style-name=
"ce28" office:
value-type=
"string" calcext:
value-type=
"string">
1072 <text:p>Description
</text:p>
1074 <table:table-cell table:
style-name=
"ce33"/>
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)<0.01" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1078 <text:p>TRUE
</text:p>
1080 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
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>
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)<0.01" calcext:
value-type=
"string">
1087 <text:p>=ABS(FV(
0.1,
12,-
100,
100)-
1824.59)
<0.01</text:p>
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>
1094 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1095 <text:p>Annual interest rate
</text:p>
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>
1101 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1102 <text:p>Annual interest rate
</text:p>
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>
1108 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1109 <text:p>Annual interest rate
</text:p>
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>
1115 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1116 <text:p>Annual interest rate
</text:p>
1118 <table:table-cell table:
style-name=
"ce33"/>
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>
1124 <table:table-cell office:
value-type=
"float" office:
value=
"-4234" calcext:
value-type=
"float">
1125 <text:p>-
4234</text:p>
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>
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>
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">
1138 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1139 <text:p>Number of payments
</text:p>
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">
1145 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1146 <text:p>Number of payments
</text:p>
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">
1152 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1153 <text:p>Number of payments
</text:p>
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">
1159 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1160 <text:p>Number of payments
</text:p>
1162 <table:table-cell table:
style-name=
"ce33"/>
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>
1168 <table:table-cell office:
value-type=
"float" office:
value=
"12298.4638198035" calcext:
value-type=
"float">
1169 <text:p>12298.4638198035</text:p>
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>
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>
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>
1182 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1183 <text:p>Amount of the payment
</text:p>
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>
1189 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1190 <text:p>Amount of the payment
</text:p>
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>
1196 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1197 <text:p>Amount of the payment
</text:p>
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>
1203 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1204 <text:p>Amount of the payment
</text:p>
1206 <table:table-cell table:
style-name=
"ce33"/>
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>
1212 <table:table-cell office:
value-type=
"float" office:
value=
"21915.0949710678" calcext:
value-type=
"float">
1213 <text:p>21915.0949710678</text:p>
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>
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>
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>
1225 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1226 <text:p>Present value
</text:p>
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">
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>
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>
1240 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1241 <text:p>Present value
</text:p>
1243 <table:table-cell table:
style-name=
"ce33"/>
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>
1249 <table:table-cell office:
value-type=
"float" office:
value=
"12115.1879428082" calcext:
value-type=
"float">
1250 <text:p>12115.1879428082</text:p>
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>
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>
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">
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>
1265 <table:table-cell table:
style-name=
"ce33"/>
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">
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>
1275 <table:table-cell table:
style-name=
"ce33"/>
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>
1281 <table:table-cell office:
value-type=
"float" office:
value=
"12181.9975443941" calcext:
value-type=
"float">
1282 <text:p>12181.9975443941</text:p>
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>
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>
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"/>
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"/>
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>
1302 <table:table-cell office:
value-type=
"float" office:
value=
"12181.9975443941" calcext:
value-type=
"float">
1303 <text:p>12181.9975443941</text:p>
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>
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>
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>
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"/>
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>
1324 <table:table-cell office:
value-type=
"float" office:
value=
"12181.9975443941" calcext:
value-type=
"float">
1325 <text:p>12181.9975443941</text:p>
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>
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>
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>
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"/>
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>
1344 <table:table-cell office:
value-type=
"float" office:
value=
"12115.1879428082" calcext:
value-type=
"float">
1345 <text:p>12115.1879428082</text:p>
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>
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>
1353 <table:table-cell table:
number-columns-repeated=
"5"/>
1354 <table:table-cell table:
style-name=
"ce29" table:
number-columns-repeated=
"2"/>
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"/>
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>
1364 <table:table-cell office:
value-type=
"float" office:
value=
"12115.1879428082" calcext:
value-type=
"float">
1365 <text:p>12115.1879428082</text:p>
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>
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>
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"/>
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>
1382 <table:table-cell office:
value-type=
"float" office:
value=
"1272.56383972991" calcext:
value-type=
"float">
1383 <text:p>1272.56383972991</text:p>
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>
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>
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"/>
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>
1399 <table:table-cell office:
value-type=
"float" office:
value=
"1272.56383972991" calcext:
value-type=
"float">
1400 <text:p>1272.56383972991</text:p>
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>
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>
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"/>
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>
1418 <table:table-cell office:
value-type=
"float" office:
value=
"1272.56383972991" calcext:
value-type=
"float">
1419 <text:p>1272.56383972991</text:p>
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>
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>
1427 <table:table-cell table:
number-columns-repeated=
"16"/>
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>
1433 <table:table-cell office:
value-type=
"float" office:
value=
"1272.56383972991" calcext:
value-type=
"float">
1434 <text:p>1272.56383972991</text:p>
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>
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>
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"/>
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>
1450 <table:table-cell office:
value-type=
"float" office:
value=
"2581.40337406014" calcext:
value-type=
"float">
1451 <text:p>2581.40337406014</text:p>
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>
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>
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"/>
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>
1469 <table:table-cell office:
value-type=
"float" office:
value=
"12682.503013197" calcext:
value-type=
"float">
1470 <text:p>12682.503013197</text:p>
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>
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>
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"/>
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>
1486 <table:table-cell office:
value-type=
"float" office:
value=
"82846.2463719006" calcext:
value-type=
"float">
1487 <text:p>82846.2463719006</text:p>
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>
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>
1495 <table:table-cell table:
number-columns-repeated=
"16"/>
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>
1501 <table:table-cell office:
value-type=
"float" office:
value=
"2301.40183034091" calcext:
value-type=
"float">
1502 <text:p>2301.40183034091</text:p>
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>
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>
1510 <table:table-cell table:
number-columns-repeated=
"16"/>
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>
1518 <table:table-cell table:
number-columns-repeated=
"15"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
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"/>
1567 <table:table-row table:
style-name=
"ro7">
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"/>
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"/>
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"/>
1582 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048475">
1583 <table:table-cell table:
number-columns-repeated=
"20"/>
1585 <table:table-row table:
style-name=
"ro2">
1586 <table:table-cell table:
number-columns-repeated=
"20"/>
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=
"=""" 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=
"=""" 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>
1601 <table:table table:
name=
"'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'#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"/>
1608 <table:table-cell table:
number-columns-repeated=
"7"/>
1609 <table:table-cell table:
style-name=
"ce1" office:
value-type=
"float" office:
value=
"4">
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>