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:text> </loext:text>
27 <loext:fill-character> </loext:fill-character>
28 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
29 <number:text> </number:text>
30 </number:number-style>
31 <number:number-style style:
name=
"N126P1" style:
volatile=
"true">
32 <loext:text> </loext:text>
33 <loext:fill-character> </loext:fill-character>
34 <number:text>(
</number:text>
35 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
36 <number:text>)
</number:text>
37 </number:number-style>
38 <number:number-style style:
name=
"N126P2" style:
volatile=
"true">
39 <loext:text> </loext:text>
40 <loext:fill-character> </loext:fill-character>
41 <number:text>-
</number:text>
42 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"0"/>
43 <number:text> </number:text>
44 </number:number-style>
45 <number:text-style style:
name=
"N126">
46 <number:text-content/>
47 <number:text> </number:text>
48 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N126P0"/>
49 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N126P1"/>
50 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N126P2"/>
52 <number:currency-style style:
name=
"N128P0" style:
volatile=
"true">
53 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
54 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
55 </number:currency-style>
56 <number:currency-style style:
name=
"N128">
57 <number:text>-
</number:text>
58 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
59 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
60 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N128P0"/>
61 </number:currency-style>
62 <number:currency-style style:
name=
"N130P0" style:
volatile=
"true">
63 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
64 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
65 </number:currency-style>
66 <number:currency-style style:
name=
"N130">
67 <number:text>-
</number:text>
68 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
69 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
70 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N130P0"/>
71 </number:currency-style>
72 <number:currency-style style:
name=
"N131P0" style:
volatile=
"true">
73 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
74 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
75 </number:currency-style>
76 <number:currency-style style:
name=
"N131">
77 <style:text-properties fo:
color=
"#ff0000"/>
78 <number:text>-
</number:text>
79 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
80 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
81 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N131P0"/>
82 </number:currency-style>
83 <number:currency-style style:
name=
"N132P0" style:
volatile=
"true">
84 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
85 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
86 </number:currency-style>
87 <number:currency-style style:
name=
"N132">
88 <style:text-properties fo:
color=
"#ff0000"/>
89 <number:text>-
</number:text>
90 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
91 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
92 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N132P0"/>
93 </number:currency-style>
94 <number:currency-style style:
name=
"N134P0" style:
volatile=
"true">
95 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
96 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
97 </number:currency-style>
98 <number:currency-style style:
name=
"N134">
99 <style:text-properties fo:
color=
"#ff0000"/>
100 <number:text>-
</number:text>
101 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
102 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
103 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N134P0"/>
104 </number:currency-style>
105 <number:number-style style:
name=
"N136P0" style:
volatile=
"true">
106 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
107 <number:text> </number:text>
108 </number:number-style>
109 <number:number-style style:
name=
"N136">
110 <number:text>(
</number:text>
111 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
112 <number:text>)
</number:text>
113 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N136P0"/>
114 </number:number-style>
115 <number:number-style style:
name=
"N138P0" style:
volatile=
"true">
116 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
117 <number:text> </number:text>
118 </number:number-style>
119 <number:number-style style:
name=
"N138">
120 <number:text>(
</number:text>
121 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
122 <number:text>)
</number:text>
123 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N138P0"/>
124 </number:number-style>
125 <number:currency-style style:
name=
"N140P0" style:
volatile=
"true">
126 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
127 <loext:fill-character> </loext:fill-character>
128 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
129 </number:currency-style>
130 <number:currency-style style:
name=
"N140">
131 <number:text>-
</number:text>
132 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
133 <loext:fill-character> </loext:fill-character>
134 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
135 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N140P0"/>
136 </number:currency-style>
137 <number:currency-style style:
name=
"N142P0" style:
volatile=
"true">
138 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
139 <loext:fill-character> </loext:fill-character>
140 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
141 </number:currency-style>
142 <number:currency-style style:
name=
"N142">
143 <number:text>-
</number:text>
144 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
145 <loext:fill-character> </loext:fill-character>
146 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
147 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N142P0"/>
148 </number:currency-style>
149 <number:currency-style style:
name=
"N144P0" style:
volatile=
"true">
150 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
151 <number:text> </number:text>
152 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
153 </number:currency-style>
154 <number:currency-style style:
name=
"N144">
155 <number:text>-
</number:text>
156 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
157 <number:text> </number:text>
158 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
159 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N144P0"/>
160 </number:currency-style>
161 <number:currency-style style:
name=
"N145P0" style:
volatile=
"true">
162 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
163 <number:text> </number:text>
164 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
165 </number:currency-style>
166 <number:currency-style style:
name=
"N145">
167 <number:text>-
</number:text>
168 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
169 <number:text> </number:text>
170 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
171 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N145P0"/>
172 </number:currency-style>
173 <number:currency-style style:
name=
"N146P0" style:
volatile=
"true">
174 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
175 <number:text> </number:text>
176 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
177 </number:currency-style>
178 <number:currency-style style:
name=
"N146">
179 <style:text-properties fo:
color=
"#ff0000"/>
180 <number:text>-
</number:text>
181 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
182 <number:text> </number:text>
183 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
184 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N146P0"/>
185 </number:currency-style>
186 <number:currency-style style:
name=
"N148P0" style:
volatile=
"true">
187 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
188 <number:text> </number:text>
189 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
190 </number:currency-style>
191 <number:currency-style style:
name=
"N148">
192 <style:text-properties fo:
color=
"#ff0000"/>
193 <number:text>-
</number:text>
194 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
195 <number:text> </number:text>
196 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
197 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N148P0"/>
198 </number:currency-style>
199 <number:number-style style:
name=
"N150">
200 <number:number number:
decimal-places=
"9" loext:
min-decimal-places=
"9" number:
min-integer-digits=
"1"/>
201 </number:number-style>
202 <number:number-style style:
name=
"N151">
203 <number:number number:
decimal-places=
"8" loext:
min-decimal-places=
"8" number:
min-integer-digits=
"1"/>
204 </number:number-style>
205 <number:number-style style:
name=
"N152">
206 <number:number number:
decimal-places=
"10" loext:
min-decimal-places=
"10" number:
min-integer-digits=
"1"/>
207 </number:number-style>
208 <number:number-style style:
name=
"N153">
209 <number:number number:
decimal-places=
"11" loext:
min-decimal-places=
"11" number:
min-integer-digits=
"1"/>
210 </number:number-style>
211 <number:number-style style:
name=
"N154">
212 <number:number number:
decimal-places=
"12" loext:
min-decimal-places=
"12" number:
min-integer-digits=
"1"/>
213 </number:number-style>
214 <number:number-style style:
name=
"N155">
215 <number:number number:
decimal-places=
"13" loext:
min-decimal-places=
"13" number:
min-integer-digits=
"1"/>
216 </number:number-style>
217 <number:number-style style:
name=
"N156">
218 <number:number number:
decimal-places=
"14" loext:
min-decimal-places=
"14" number:
min-integer-digits=
"1"/>
219 </number:number-style>
220 <number:number-style style:
name=
"N157">
221 <number:number number:
decimal-places=
"15" loext:
min-decimal-places=
"15" number:
min-integer-digits=
"1"/>
222 </number:number-style>
223 <number:number-style style:
name=
"N158">
224 <number:number number:
decimal-places=
"16" loext:
min-decimal-places=
"16" number:
min-integer-digits=
"1"/>
225 </number:number-style>
226 <number:number-style style:
name=
"N159">
227 <number:number number:
decimal-places=
"17" loext:
min-decimal-places=
"17" number:
min-integer-digits=
"1"/>
228 </number:number-style>
229 <number:number-style style:
name=
"N160">
230 <number:number number:
decimal-places=
"18" loext:
min-decimal-places=
"18" number:
min-integer-digits=
"1"/>
231 </number:number-style>
232 <number:number-style style:
name=
"N161">
233 <number:number number:
decimal-places=
"1" loext:
min-decimal-places=
"1" number:
min-integer-digits=
"1"/>
234 </number:number-style>
235 <number:number-style style:
name=
"N162">
236 <number:number number:
decimal-places=
"3" loext:
min-decimal-places=
"3" number:
min-integer-digits=
"1"/>
237 </number:number-style>
238 <number:number-style style:
name=
"N163">
239 <number:number number:
decimal-places=
"4" loext:
min-decimal-places=
"4" number:
min-integer-digits=
"1"/>
240 </number:number-style>
241 <number:number-style style:
name=
"N164">
242 <number:number number:
decimal-places=
"5" loext:
min-decimal-places=
"5" number:
min-integer-digits=
"1"/>
243 </number:number-style>
244 <number:number-style style:
name=
"N165">
245 <number:number number:
decimal-places=
"6" loext:
min-decimal-places=
"6" number:
min-integer-digits=
"1"/>
246 </number:number-style>
247 <number:number-style style:
name=
"N166">
248 <number:number number:
decimal-places=
"7" loext:
min-decimal-places=
"7" number:
min-integer-digits=
"1"/>
249 </number:number-style>
250 <number:currency-style style:
name=
"N168P0" style:
volatile=
"true">
251 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
252 <number:text> </number:text>
253 <number:currency-symbol number:
language=
"fr" number:
country=
"FR">€
</number:currency-symbol>
254 </number:currency-style>
255 <number:currency-style style:
name=
"N168">
256 <style:text-properties fo:
color=
"#ff0000"/>
257 <number:text>-
</number:text>
258 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
259 <number:text> </number:text>
260 <number:currency-symbol number:
language=
"fr" number:
country=
"FR">€
</number:currency-symbol>
261 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N168P0"/>
262 </number:currency-style>
263 <number:number-style style:
name=
"N170P0" style:
volatile=
"true">
265 </number:number-style>
266 <number:currency-style style:
name=
"N170">
267 <style:text-properties fo:
color=
"#ff0000"/>
268 <number:text>-
</number:text>
269 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
270 <number:text> </number:text>
271 <number:currency-symbol number:
language=
"fr" number:
country=
"FR">€
</number:currency-symbol>
272 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N170P0"/>
273 </number:currency-style>
274 <number:date-style style:
name=
"N171">
275 <number:day-of-week/>
276 <number:text> </number:text>
277 <number:day number:
style=
"long"/>
278 <number:text>/
</number:text>
279 <number:month number:
style=
"long"/>
280 <number:text>/
</number:text>
283 <number:date-style style:
name=
"N172">
284 <number:day-of-week number:
style=
"long"/>
285 <number:text> </number:text>
286 <number:day number:
style=
"long"/>
287 <number:text>/
</number:text>
288 <number:month number:
style=
"long"/>
289 <number:text>/
</number:text>
292 <number:currency-style style:
name=
"N174P0" style:
volatile=
"true">
293 <number:currency-symbol number:
language=
"de" number:
country=
"AT">€
</number:currency-symbol>
294 <number:text> </number:text>
295 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
296 </number:currency-style>
297 <number:currency-style style:
name=
"N174">
298 <style:text-properties fo:
color=
"#ff0000"/>
299 <number:text>-
</number:text>
300 <number:currency-symbol number:
language=
"de" number:
country=
"AT">€
</number:currency-symbol>
301 <number:text> </number:text>
302 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
303 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N174P0"/>
304 </number:currency-style>
305 <number:number-style style:
name=
"N176P0" style:
volatile=
"true">
306 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
307 <number:text> Kč
</number:text>
308 </number:number-style>
309 <number:number-style style:
name=
"N176">
310 <number:text>-
</number:text>
311 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
312 <number:text> Kč
</number:text>
313 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N176P0"/>
314 </number:number-style>
315 <number:number-style style:
name=
"N177P0" style:
volatile=
"true">
316 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
317 <number:text> Kč
</number:text>
318 </number:number-style>
319 <number:number-style style:
name=
"N177">
320 <style:text-properties fo:
color=
"#ff0000"/>
321 <number:text>-
</number:text>
322 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
323 <number:text> Kč
</number:text>
324 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N177P0"/>
325 </number:number-style>
326 <number:number-style style:
name=
"N179P0" style:
volatile=
"true">
327 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
328 <number:text> Kč
</number:text>
329 </number:number-style>
330 <number:number-style style:
name=
"N179">
331 <number:text>-
</number:text>
332 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
333 <number:text> Kč
</number:text>
334 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N179P0"/>
335 </number:number-style>
336 <number:number-style style:
name=
"N180P0" style:
volatile=
"true">
337 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
338 <number:text> Kč
</number:text>
339 </number:number-style>
340 <number:number-style style:
name=
"N180">
341 <style:text-properties fo:
color=
"#ff0000"/>
342 <number:text>-
</number:text>
343 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
344 <number:text> Kč
</number:text>
345 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N180P0"/>
346 </number:number-style>
347 <number:number-style style:
name=
"N181P0" style:
volatile=
"true">
348 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
349 </number:number-style>
350 <number:number-style style:
name=
"N181">
351 <number:text>-
</number:text>
352 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
353 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N181P0"/>
354 </number:number-style>
355 <number:number-style style:
name=
"N182P0" style:
volatile=
"true">
356 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
357 </number:number-style>
358 <number:number-style style:
name=
"N182">
359 <style:text-properties fo:
color=
"#ff0000"/>
360 <number:text>-
</number:text>
361 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
362 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N182P0"/>
363 </number:number-style>
364 <number:number-style style:
name=
"N183P0" style:
volatile=
"true">
365 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
366 </number:number-style>
367 <number:number-style style:
name=
"N183">
368 <number:text>-
</number:text>
369 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
370 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N183P0"/>
371 </number:number-style>
372 <number:number-style style:
name=
"N184P0" style:
volatile=
"true">
373 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
374 </number:number-style>
375 <number:number-style style:
name=
"N184">
376 <style:text-properties fo:
color=
"#ff0000"/>
377 <number:text>-
</number:text>
378 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
379 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N184P0"/>
380 </number:number-style>
381 <number:number-style style:
name=
"N188P0" style:
volatile=
"true">
382 <loext:text> </loext:text>
383 <loext:fill-character> </loext:fill-character>
384 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
385 <number:text> </number:text>
386 </number:number-style>
387 <number:number-style style:
name=
"N188P1" style:
volatile=
"true">
388 <loext:text>-
</loext:text>
389 <loext:fill-character> </loext:fill-character>
390 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
391 <number:text> </number:text>
392 </number:number-style>
393 <number:number-style style:
name=
"N188P2" style:
volatile=
"true">
394 <loext:text> </loext:text>
395 <loext:fill-character> </loext:fill-character>
396 <number:text>-
</number:text>
397 </number:number-style>
398 <number:text-style style:
name=
"N188">
399 <number:text-content/>
400 <number:text> </number:text>
401 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N188P0"/>
402 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N188P1"/>
403 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N188P2"/>
405 <number:number-style style:
name=
"N192P0" 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=
"N192P1" style:
volatile=
"true">
412 <loext:text>-
</loext:text>
413 <loext:fill-character> </loext:fill-character>
414 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
415 <number:text> Kč
</number:text>
416 </number:number-style>
417 <number:number-style style:
name=
"N192P2" style:
volatile=
"true">
418 <loext:text> </loext:text>
419 <loext:fill-character> </loext:fill-character>
420 <number:text>- Kč
</number:text>
421 </number:number-style>
422 <number:text-style style:
name=
"N192">
423 <number:text-content/>
424 <number:text> </number:text>
425 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N192P0"/>
426 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N192P1"/>
427 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N192P2"/>
429 <number:number-style style:
name=
"N196P0" style:
volatile=
"true">
430 <loext:text> </loext:text>
431 <loext:fill-character> </loext:fill-character>
432 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
433 <number:text> </number:text>
434 </number:number-style>
435 <number:number-style style:
name=
"N196P1" style:
volatile=
"true">
436 <loext:text>-
</loext:text>
437 <loext:fill-character> </loext:fill-character>
438 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
439 <number:text> </number:text>
440 </number:number-style>
441 <number:number-style style:
name=
"N196P2" style:
volatile=
"true">
442 <loext:text> </loext:text>
443 <loext:fill-character> </loext:fill-character>
444 <number:text>-
</number:text>
445 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"0"/>
446 <number:text> </number:text>
447 </number:number-style>
448 <number:text-style style:
name=
"N196">
449 <number:text-content/>
450 <number:text> </number:text>
451 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N196P0"/>
452 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N196P1"/>
453 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N196P2"/>
455 <number:number-style style:
name=
"N200P0" style:
volatile=
"true">
456 <loext:text> </loext:text>
457 <loext:fill-character> </loext:fill-character>
458 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
459 <number:text> Kč
</number:text>
460 </number:number-style>
461 <number:number-style style:
name=
"N200P1" style:
volatile=
"true">
462 <loext:text>-
</loext:text>
463 <loext:fill-character> </loext:fill-character>
464 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
465 <number:text> Kč
</number:text>
466 </number:number-style>
467 <number:number-style style:
name=
"N200P2" style:
volatile=
"true">
468 <loext:text> </loext:text>
469 <loext:fill-character> </loext:fill-character>
470 <number:text>-
</number:text>
471 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"0"/>
472 <number:text> Kč
</number:text>
473 </number:number-style>
474 <number:text-style style:
name=
"N200">
475 <number:text-content/>
476 <number:text> </number:text>
477 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N200P0"/>
478 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N200P1"/>
479 <style:map style:
condition=
"value()=0" style:
apply-style-name=
"N200P2"/>
481 <number:time-style style:
name=
"N201">
482 <number:minutes number:
style=
"long"/>
483 <number:text>:
</number:text>
484 <number:seconds number:
style=
"long"/>
486 <number:time-style style:
name=
"N202" number:
truncate-on-overflow=
"false">
488 <number:text>:
</number:text>
489 <number:minutes number:
style=
"long"/>
490 <number:text>:
</number:text>
491 <number:seconds number:
style=
"long"/>
493 <number:time-style style:
name=
"N203">
494 <number:minutes number:
style=
"long"/>
495 <number:text>:
</number:text>
496 <number:seconds number:
style=
"long" number:
decimal-places=
"1"/>
498 <number:number-style style:
name=
"N204">
499 <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"/>
500 </number:number-style>
501 <number:number-style style:
name=
"N206P0" style:
volatile=
"true">
502 <number:text>Yes
</number:text>
503 </number:number-style>
504 <number:number-style style:
name=
"N206P1" style:
volatile=
"true">
505 <number:text>Yes
</number:text>
506 </number:number-style>
507 <number:number-style style:
name=
"N206">
508 <number:text>No
</number:text>
509 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N206P0"/>
510 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N206P1"/>
511 </number:number-style>
512 <number:number-style style:
name=
"N208P0" style:
volatile=
"true">
513 <number:text>True
</number:text>
514 </number:number-style>
515 <number:number-style style:
name=
"N208P1" style:
volatile=
"true">
516 <number:text>True
</number:text>
517 </number:number-style>
518 <number:number-style style:
name=
"N208">
519 <number:text>False
</number:text>
520 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N208P0"/>
521 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N208P1"/>
522 </number:number-style>
523 <number:number-style style:
name=
"N210P0" style:
volatile=
"true">
524 <number:text>On
</number:text>
525 </number:number-style>
526 <number:number-style style:
name=
"N210P1" style:
volatile=
"true">
527 <number:text>On
</number:text>
528 </number:number-style>
529 <number:number-style style:
name=
"N210">
530 <number:text>Off
</number:text>
531 <style:map style:
condition=
"value()>0" style:
apply-style-name=
"N210P0"/>
532 <style:map style:
condition=
"value()<0" style:
apply-style-name=
"N210P1"/>
533 </number:number-style>
534 <number:currency-style style:
name=
"N212P0" style:
volatile=
"true">
535 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">¥€
</number:currency-symbol>
536 <number:text> </number:text>
537 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"3">
538 <number:embedded-text number:
position=
"5"> </number:embedded-text>
540 <number:text> </number:text>
541 </number:currency-style>
542 <number:currency-style style:
name=
"N212">
543 <style:text-properties fo:
color=
"#ff0000"/>
544 <number:text>(
</number:text>
545 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">€
</number:currency-symbol>
546 <number:text> </number:text>
547 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"3">
548 <number:embedded-text number:
position=
"5"> </number:embedded-text>
550 <number:text>)
</number:text>
551 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N212P0"/>
552 </number:currency-style>
553 <number:currency-style style:
name=
"N214P0" style:
volatile=
"true">
554 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
555 <number:text> </number:text>
556 <number:currency-symbol number:
language=
"de" number:
country=
"DE">€
</number:currency-symbol>
557 </number:currency-style>
558 <number:currency-style style:
name=
"N214">
559 <style:text-properties fo:
color=
"#ff0000"/>
560 <number:text>-
</number:text>
561 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
562 <number:text> </number:text>
563 <number:currency-symbol number:
language=
"de" number:
country=
"DE">€
</number:currency-symbol>
564 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N214P0"/>
565 </number:currency-style>
566 <style:style style:
name=
"Default" style:
family=
"table-cell">
567 <style:table-cell-properties fo:
padding=
"2.01pt" style:
rotation-align=
"none"/>
568 <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"/>
570 <style:style style:
name=
"Heading" style:
family=
"table-cell" style:
parent-style-name=
"Default">
571 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
572 <style:paragraph-properties fo:
text-align=
"center"/>
573 <style:text-properties fo:
font-size=
"16pt" fo:
font-style=
"italic" fo:
font-weight=
"bold"/>
575 <style:style style:
name=
"Heading_20_1" style:
display-name=
"Heading 1" style:
family=
"table-cell" style:
parent-style-name=
"Heading">
576 <style:text-properties fo:
color=
"#000000" fo:
font-size=
"18pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
578 <style:style style:
name=
"Heading_20_2" style:
display-name=
"Heading 2" style:
family=
"table-cell" style:
parent-style-name=
"Heading">
579 <style:text-properties fo:
color=
"#000000" fo:
font-size=
"12pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
581 <style:style style:
name=
"Text" style:
family=
"table-cell" style:
parent-style-name=
"Default"/>
582 <style:style style:
name=
"Note" style:
family=
"table-cell" style:
parent-style-name=
"Text">
583 <style:table-cell-properties fo:
background-color=
"#ffffcc" style:
diagonal-bl-tr=
"none" style:
diagonal-tl-br=
"none" fo:
border=
"0.74pt solid #808080"/>
584 <style:text-properties fo:
color=
"#333333" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
586 <style:style style:
name=
"Footnote" style:
family=
"table-cell" style:
parent-style-name=
"Text">
587 <style:text-properties fo:
color=
"#808080" fo:
font-size=
"10pt" fo:
font-style=
"italic" fo:
font-weight=
"normal"/>
589 <style:style style:
name=
"Status" style:
family=
"table-cell" style:
parent-style-name=
"Default"/>
590 <style:style style:
name=
"Good" style:
family=
"table-cell" style:
parent-style-name=
"Status">
591 <style:table-cell-properties fo:
background-color=
"#ccffcc"/>
592 <style:text-properties fo:
color=
"#006600" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
594 <style:style style:
name=
"Neutral" style:
family=
"table-cell" style:
parent-style-name=
"Status">
595 <style:table-cell-properties fo:
background-color=
"#ffffcc"/>
596 <style:text-properties fo:
color=
"#996600" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
598 <style:style style:
name=
"Bad" style:
family=
"table-cell" style:
parent-style-name=
"Status">
599 <style:table-cell-properties fo:
background-color=
"#ffcccc"/>
600 <style:text-properties fo:
color=
"#cc0000" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
602 <style:style style:
name=
"Warning" style:
family=
"table-cell" style:
parent-style-name=
"Status">
603 <style:text-properties fo:
color=
"#cc0000" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
605 <style:style style:
name=
"Error" style:
family=
"table-cell" style:
parent-style-name=
"Status">
606 <style:table-cell-properties fo:
background-color=
"#cc0000"/>
607 <style:text-properties fo:
color=
"#ffffff" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"bold"/>
609 <style:style style:
name=
"Accent" style:
family=
"table-cell" style:
parent-style-name=
"Default">
610 <style:text-properties fo:
color=
"#000000" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"bold"/>
612 <style:style style:
name=
"Accent_20_1" style:
display-name=
"Accent 1" style:
family=
"table-cell" style:
parent-style-name=
"Accent">
613 <style:table-cell-properties fo:
background-color=
"#000000"/>
614 <style:text-properties fo:
color=
"#ffffff" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
616 <style:style style:
name=
"Accent_20_2" style:
display-name=
"Accent 2" style:
family=
"table-cell" style:
parent-style-name=
"Accent">
617 <style:table-cell-properties fo:
background-color=
"#808080"/>
618 <style:text-properties fo:
color=
"#ffffff" fo:
font-size=
"10pt" fo:
font-style=
"normal" fo:
font-weight=
"normal"/>
620 <style:style style:
name=
"Accent_20_3" style:
display-name=
"Accent 3" style:
family=
"table-cell" style:
parent-style-name=
"Accent">
621 <style:table-cell-properties fo:
background-color=
"#dddddd"/>
623 <style:style style:
name=
"Result" style:
family=
"table-cell" style:
parent-style-name=
"Default">
624 <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"/>
626 <style:style style:
name=
"Result2" style:
family=
"table-cell" style:
parent-style-name=
"Result" style:
data-style-name=
"N122"/>
627 <style:style style:
name=
"Heading1" style:
family=
"table-cell" style:
parent-style-name=
"Heading">
628 <style:table-cell-properties style:
rotation-angle=
"90"/>
630 <style:style style:
name=
"Untitled1" style:
family=
"table-cell" style:
parent-style-name=
"Default">
631 <style:table-cell-properties fo:
background-color=
"#ff3333"/>
633 <style:style style:
name=
"Untitled2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
634 <style:table-cell-properties fo:
background-color=
"#99ff66"/>
636 <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">
637 <style:table-cell-properties fo:
padding=
"2.01pt"/>
639 <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">
640 <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"/>
641 <style:paragraph-properties css3t:
text-justify=
"auto" fo:
margin-left=
"0pt" style:
writing-mode=
"page"/>
642 <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"/>
644 <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">
645 <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"/>
646 <style:paragraph-properties css3t:
text-justify=
"auto" fo:
margin-left=
"0pt" style:
writing-mode=
"page"/>
647 <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"/>
650 <office:automatic-styles>
651 <style:style style:
name=
"co1" style:
family=
"table-column">
652 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"185.7pt"/>
654 <style:style style:
name=
"co2" style:
family=
"table-column">
655 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"252.51pt"/>
657 <style:style style:
name=
"co3" style:
family=
"table-column">
658 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"64.01pt"/>
660 <style:style style:
name=
"co4" style:
family=
"table-column">
661 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"142.44pt"/>
663 <style:style style:
name=
"co5" style:
family=
"table-column">
664 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"89.94pt"/>
666 <style:style style:
name=
"co6" style:
family=
"table-column">
667 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"74.21pt"/>
669 <style:style style:
name=
"co7" style:
family=
"table-column">
670 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"286.64pt"/>
672 <style:style style:
name=
"co8" style:
family=
"table-column">
673 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"140.94pt"/>
675 <style:style style:
name=
"co9" style:
family=
"table-column">
676 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"16.44pt"/>
678 <style:style style:
name=
"co10" style:
family=
"table-column">
679 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"46.46pt"/>
681 <style:style style:
name=
"co11" style:
family=
"table-column">
682 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"78.29pt"/>
684 <style:style style:
name=
"co12" style:
family=
"table-column">
685 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"71.21pt"/>
687 <style:style style:
name=
"ro1" style:
family=
"table-row">
688 <style:table-row-properties style:
row-height=
"24.46pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
690 <style:style style:
name=
"ro2" style:
family=
"table-row">
691 <style:table-row-properties style:
row-height=
"12.81pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
693 <style:style style:
name=
"ro3" style:
family=
"table-row">
694 <style:table-row-properties style:
row-height=
"17.35pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
696 <style:style style:
name=
"ro4" style:
family=
"table-row">
697 <style:table-row-properties style:
row-height=
"15pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
699 <style:style style:
name=
"ro5" style:
family=
"table-row">
700 <style:table-row-properties style:
row-height=
"13.21pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
702 <style:style style:
name=
"ro6" style:
family=
"table-row">
703 <style:table-row-properties style:
row-height=
"17.29pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
705 <style:style style:
name=
"ro7" style:
family=
"table-row">
706 <style:table-row-properties style:
row-height=
"30.76pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
708 <style:style style:
name=
"ro8" style:
family=
"table-row">
709 <style:table-row-properties style:
row-height=
"15.79pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
711 <style:style style:
name=
"ro9" style:
family=
"table-row">
712 <style:table-row-properties style:
row-height=
"145.64pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
714 <style:style style:
name=
"ro10" style:
family=
"table-row">
715 <style:table-row-properties style:
row-height=
"15.36pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
717 <style:style style:
name=
"ro11" style:
family=
"table-row">
718 <style:table-row-properties style:
row-height=
"24.01pt" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
720 <style:style style:
name=
"ta1" style:
family=
"table" style:
master-page-name=
"Default">
721 <style:table-properties table:
display=
"true" style:
writing-mode=
"lr-tb"/>
723 <number:percentage-style style:
name=
"N11">
724 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1"/>
725 <number:text>%
</number:text>
726 </number:percentage-style>
727 <number:date-style style:
name=
"N36" number:
automatic-order=
"true">
728 <number:month number:
style=
"long"/>
729 <number:text>/
</number:text>
730 <number:day number:
style=
"long"/>
731 <number:text>/
</number:text>
732 <number:year number:
style=
"long"/>
734 <number:boolean-style style:
name=
"N99">
736 </number:boolean-style>
737 <style:style style:
name=
"ce1" style:
family=
"table-cell" style:
parent-style-name=
"Default"/>
738 <style:style style:
name=
"ce2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
739 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
740 <style:paragraph-properties fo:
text-align=
"start" fo:
margin-left=
"0pt"/>
741 <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"/>
743 <style:style style:
name=
"ce3" style:
family=
"table-cell" style:
parent-style-name=
"Default">
744 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
745 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
746 <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"/>
748 <style:style style:
name=
"ce4" style:
family=
"table-cell" style:
parent-style-name=
"Default">
749 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
750 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
751 <style: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"/>
753 <style:style style:
name=
"ce5" style:
family=
"table-cell" style:
parent-style-name=
"Default">
754 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
755 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
757 <style:style style:
name=
"ce6" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
758 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
759 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
760 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B3"/>
761 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B3"/>
762 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B3"/>
764 <style:style style:
name=
"ce7" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
765 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
766 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
767 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B8"/>
768 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B8"/>
769 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B8"/>
771 <style:style style:
name=
"ce8" style:
family=
"table-cell" style:
parent-style-name=
"Default">
772 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
773 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
774 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B8"/>
775 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B8"/>
776 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B8"/>
778 <style:style style:
name=
"ce9" style:
family=
"table-cell" style:
parent-style-name=
"Default">
779 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
780 <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"/>
782 <style:style style:
name=
"ce10" style:
family=
"table-cell" style:
parent-style-name=
"Default">
783 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
784 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
785 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
787 <style:style style:
name=
"ce11" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N122"/>
788 <style:style style:
name=
"ce12" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N122">
789 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
790 <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"/>
792 <style:style style:
name=
"ce13" style:
family=
"table-cell" style:
parent-style-name=
"Normal_20_2">
793 <style:table-cell-properties fo:
padding=
"2.01pt"/>
795 <style:style style:
name=
"ce49" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
796 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
797 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
798 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
799 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
800 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
802 <style:style style:
name=
"ce15" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
803 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
804 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
805 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
806 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
807 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
809 <style:style style:
name=
"ce16" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
810 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
811 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
812 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C20"/>
813 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C20"/>
814 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C20"/>
816 <style:style style:
name=
"ce17" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
817 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
818 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
819 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C21"/>
820 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C21"/>
821 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C21"/>
823 <style:style style:
name=
"ce18" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
824 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
825 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
826 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C21"/>
827 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C21"/>
828 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C21"/>
830 <style:style style:
name=
"ce19" style:
family=
"table-cell" style:
parent-style-name=
"Default">
831 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
832 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
833 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C21"/>
834 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C21"/>
835 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C21"/>
837 <style:style style:
name=
"ce20" style:
family=
"table-cell" style:
parent-style-name=
"Default">
838 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
839 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
840 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
842 <style:style style:
name=
"ce21" style:
family=
"table-cell" style:
parent-style-name=
"Default">
843 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C21"/>
844 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C21"/>
845 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C21"/>
847 <style:style style:
name=
"ce57" style:
family=
"table-cell" style:
parent-style-name=
"Default">
848 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
849 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0pt"/>
850 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C21"/>
851 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C21"/>
852 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C21"/>
854 <style:style style:
name=
"ce23" style:
family=
"table-cell" style:
parent-style-name=
"Default">
855 <style:text-properties style:
font-name=
"Liberation Serif" style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal"/>
857 <style:style style:
name=
"ce24" style:
family=
"table-cell" style:
parent-style-name=
"Default">
858 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
859 <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"/>
861 <style:style style:
name=
"ce25" style:
family=
"table-cell" style:
parent-style-name=
"Default">
862 <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"/>
864 <style:style style:
name=
"ce26" style:
family=
"table-cell" style:
parent-style-name=
"Default">
865 <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"/>
867 <style:style style:
name=
"ce27" style:
family=
"table-cell" style:
parent-style-name=
"Default">
868 <style:text-properties style:
font-name=
"Arial" fo:
font-size=
"10pt" style:
font-name-asian=
"Times New Roman1" style:
font-size-asian=
"12pt" style:
language-asian=
"ar" style:
country-asian=
"SA" style:
font-name-complex=
"Mangal"/>
870 <style:style style:
name=
"ce28" style:
family=
"table-cell" style:
parent-style-name=
"Default">
871 <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"/>
873 <style:style style:
name=
"ce29" style:
family=
"table-cell" style:
parent-style-name=
"Default">
874 <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"/>
876 <style:style style:
name=
"ce30" style:
family=
"table-cell" style:
parent-style-name=
"Default">
877 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
878 <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"/>
880 <style:style style:
name=
"ce31" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N11">
881 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
882 <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"/>
884 <style:style style:
name=
"ce32" style:
family=
"table-cell" style:
parent-style-name=
"Default">
885 <style:table-cell-properties fo:
wrap-option=
"wrap"/>
886 <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"/>
888 <style:style style:
name=
"ce33" style:
family=
"table-cell" style:
parent-style-name=
"Default">
889 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
891 <style:style style:
name=
"ce34" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N36">
892 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
894 <style:style style:
name=
"ce35" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N36"/>
895 <style:style style:
name=
"ce36" style:
family=
"table-cell" style:
parent-style-name=
"Default">
896 <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"/>
898 <style:style style:
name=
"ce37" style:
family=
"table-cell" style:
parent-style-name=
"Default">
899 <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"/>
900 <style:paragraph-properties css3t:
text-justify=
"auto" fo:
margin-left=
"0pt" style:
writing-mode=
"page"/>
902 <style:style style:
name=
"ce38" style:
family=
"table-cell" style:
parent-style-name=
"Default">
903 <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"/>
904 <style:paragraph-properties css3t:
text-justify=
"auto" fo:
margin-left=
"0pt" style:
writing-mode=
"page"/>
905 <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"/>
907 <style:style style:
name=
"ta_extref" style:
family=
"table">
908 <style:table-properties table:
display=
"false"/>
910 <style:page-layout style:
name=
"pm1">
911 <style:page-layout-properties style:
first-page-number=
"continue" style:
writing-mode=
"lr-tb"/>
913 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"0pt" fo:
margin-right=
"0pt" fo:
margin-bottom=
"7.09pt"/>
914 </style:header-style>
916 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"0pt" fo:
margin-right=
"0pt" fo:
margin-top=
"7.09pt"/>
917 </style:footer-style>
919 <style:page-layout style:
name=
"pm2">
920 <style:page-layout-properties style:
writing-mode=
"lr-tb"/>
922 <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">
923 <style:background-image/>
924 </style:header-footer-properties>
925 </style:header-style>
927 <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">
928 <style:background-image/>
929 </style:header-footer-properties>
930 </style:footer-style>
932 <style:page-layout style:
name=
"pm3">
933 <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"/>
935 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"3.46pt" fo:
margin-right=
"3.46pt" fo:
margin-bottom=
"0pt"/>
936 </style:header-style>
938 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"3.46pt" fo:
margin-right=
"3.46pt" fo:
margin-top=
"0pt"/>
939 </style:footer-style>
941 <style:page-layout style:
name=
"pm4">
942 <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"/>
944 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"3.46pt" fo:
margin-right=
"3.46pt" fo:
margin-bottom=
"0pt"/>
945 </style:header-style>
947 <style:header-footer-properties fo:
min-height=
"21.26pt" fo:
margin-left=
"3.46pt" fo:
margin-right=
"3.46pt" fo:
margin-top=
"0pt"/>
948 </style:footer-style>
950 <style:style style:
name=
"T1" style:
family=
"text">
951 <style:text-properties fo:
color=
"#000099" style:
font-name=
"Arial" fo:
font-size=
"13pt" fo:
font-weight=
"bold" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman" style:
font-size-asian=
"13pt" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
953 <style:style style:
name=
"T2" style:
family=
"text">
954 <style:text-properties style:
font-name=
"Arial" fo:
font-size=
"10pt" fo:
font-weight=
"bold" fo:
language=
"none" fo:
country=
"none" style:
language-asian=
"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"/>
956 <style:style style:
name=
"T3" style:
family=
"text">
957 <style:text-properties style:
font-name=
"Arial" fo:
font-size=
"10pt" fo:
language=
"none" fo:
country=
"none" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman" style:
font-size-asian=
"12pt"/>
959 <style:style style:
name=
"T4" style:
family=
"text">
960 <style:text-properties 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" fo:
language=
"none" fo:
country=
"none" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman"/>
962 <style:style style:
name=
"T5" style:
family=
"text">
963 <style:text-properties style:
font-size-asian=
"12pt" style:
font-name=
"Arial" fo:
font-size=
"10pt" fo:
language=
"none" fo:
country=
"none" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman"/>
965 <style:style style:
name=
"T6" style:
family=
"text">
966 <style:text-properties style:
font-size-asian=
"12pt" style:
font-name=
"Arial" fo:
font-size=
"10pt" fo:
language=
"none" fo:
country=
"none" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman" style:
font-style-complex=
"italic" fo:
font-style=
"italic" style:
font-style-asian=
"italic"/>
968 <style:style style:
name=
"T7" style:
family=
"text">
969 <style:text-properties style:
font-size-asian=
"12pt" style:
font-name=
"Arial" fo:
font-size=
"10pt" fo:
language=
"none" fo:
country=
"none" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman" fo:
font-style=
"italic" style:
font-style-asian=
"italic" style:
font-style-complex=
"italic"/>
971 <style:style style:
name=
"T8" style:
family=
"text">
972 <style:text-properties style:
font-name=
"Arial" fo:
font-size=
"10pt" style:
language-asian=
"none" style:
country-asian=
"none" style:
font-name-asian=
"Times New Roman" style:
font-size-asian=
"12pt"/>
974 </office:automatic-styles>
975 <office:master-styles>
976 <style:master-page style:
name=
"Default" style:
page-layout-name=
"pm1">
978 <text:p><text:sheet-name>???
</text:sheet-name></text:p>
980 <style:header-left style:
display=
"false"/>
982 <text:p>Page
<text:page-number>1</text:page-number></text:p>
984 <style:footer-left style:
display=
"false"/>
986 <style:master-page style:
name=
"Report" style:
page-layout-name=
"pm2">
989 <text:p><text:sheet-name>???
</text:sheet-name> (
<text:title>???
</text:title>)
</text:p>
992 <text:p><text:date style:
data-style-name=
"N2" text:
date-value=
"2017-01-08">00/
00/
0000</text:date>,
<text:time style:
data-style-name=
"N2" text:
time-value=
"17:25:08.594614684">00:
00:
00</text:time></text:p>
993 </style:region-right>
995 <style:header-left style:
display=
"false"/>
997 <text:p>Page
<text:page-number>1</text:page-number> /
<text:page-count>99</text:page-count></text:p>
999 <style:footer-left style:
display=
"false"/>
1000 </style:master-page>
1001 <style:master-page style:
name=
"PageStyle_5f_Accrued_20_Interest_20_Calculation" style:
display-name=
"PageStyle_Accrued Interest Calculation" style:
page-layout-name=
"pm3">
1002 <style:header style:
display=
"false"/>
1003 <style:header-left style:
display=
"false"/>
1004 <style:footer style:
display=
"false"/>
1005 <style:footer-left style:
display=
"false"/>
1006 </style:master-page>
1007 <style:master-page style:
name=
"PageStyle_5f_List1" style:
display-name=
"PageStyle_List1" style:
page-layout-name=
"pm4">
1008 <style:header style:
display=
"false"/>
1009 <style:header-left style:
display=
"false"/>
1010 <style:footer style:
display=
"false"/>
1011 <style:footer-left style:
display=
"false"/>
1012 </style:master-page>
1013 </office:master-styles>
1015 <office:spreadsheet>
1016 <table:calculation-settings table:
automatic-find-labels=
"false"/>
1017 <table:table table:
name=
"Sheet1" table:
style-name=
"ta1">
1018 <office:forms form:
automatic-focus=
"false" form:
apply-design-mode=
"false"/>
1019 <table:table-column table:
style-name=
"co1" table:
default-cell-style-name=
"Default"/>
1020 <table:table-column table:
style-name=
"co1" table:
default-cell-style-name=
"ce5"/>
1021 <table:table-column table:
style-name=
"co2" table:
default-cell-style-name=
"Default"/>
1022 <table:table-row table:
style-name=
"ro1">
1023 <table:table-cell table:
style-name=
"ce2" office:
value-type=
"string" calcext:
value-type=
"string">
1024 <text:p>IPMT Function
</text:p>
1026 <table:table-cell table:
number-columns-repeated=
"2"/>
1028 <table:table-row table:
style-name=
"ro2">
1029 <table:table-cell table:
number-columns-repeated=
"3"/>
1031 <table:table-row table:
style-name=
"ro3">
1032 <table:table-cell table:
style-name=
"ce3" office:
value-type=
"string" calcext:
value-type=
"string">
1033 <text:p>Result
</text:p>
1035 <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">
1036 <text:p>TRUE
</text:p>
1040 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
1041 <table:table-cell table:
number-columns-repeated=
"3"/>
1043 <table:table-row table:
style-name=
"ro4">
1044 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
1045 <text:p>Sheet
</text:p>
1047 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
1048 <text:p>Result
</text:p>
1050 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
1051 <text:p>Description
</text:p>
1054 <table:table-row table:
style-name=
"ro5">
1055 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
1058 <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">
1059 <text:p>TRUE
</text:p>
1061 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1062 <text:p>Simple IPMT formulas with local references and values
</text:p>
1065 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
1067 <table:table-cell table:
style-name=
"ce8"/>
1070 <table:table-row table:
style-name=
"ro2">
1072 <table:table-cell table:
style-name=
"ce8"/>
1073 <table:table-cell table:
style-name=
"ce9"/>
1075 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"26">
1077 <table:table-cell table:
style-name=
"ce8"/>
1080 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048537">
1081 <table:table-cell table:
number-columns-repeated=
"3"/>
1083 <table:table-row table:
style-name=
"ro2">
1084 <table:table-cell table:
number-columns-repeated=
"3"/>
1086 <calcext:conditional-formats>
1087 <calcext:conditional-format calcext:
target-range-address=
"Sheet1.B8:Sheet1.B38">
1088 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet1.B8"/>
1089 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet1.B8"/>
1090 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet1.B8"/>
1091 </calcext:conditional-format>
1092 <calcext:conditional-format calcext:
target-range-address=
"Sheet1.B3:Sheet1.B3">
1093 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet1.B3"/>
1094 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet1.B3"/>
1095 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet1.B3"/>
1096 </calcext:conditional-format>
1097 </calcext:conditional-formats>
1099 <table:table table:
name=
"Sheet2" table:
style-name=
"ta1" table:
print=
"false">
1100 <office:forms form:
automatic-focus=
"false" form:
apply-design-mode=
"false"/>
1101 <table:table-column table:
style-name=
"co4" table:
default-cell-style-name=
"Default"/>
1102 <table:table-column table:
style-name=
"co5" table:
default-cell-style-name=
"Default"/>
1103 <table:table-column table:
style-name=
"co6" table:
default-cell-style-name=
"ce5"/>
1104 <table:table-column table:
style-name=
"co7" table:
default-cell-style-name=
"Default"/>
1105 <table:table-column table:
style-name=
"co8" table:
default-cell-style-name=
"Default"/>
1106 <table:table-column table:
style-name=
"co9" table:
default-cell-style-name=
"Default"/>
1107 <table:table-column table:
style-name=
"co10" table:
default-cell-style-name=
"Default"/>
1108 <table:table-column table:
style-name=
"co9" table:
default-cell-style-name=
"Default"/>
1109 <table:table-column table:
style-name=
"co11" table:
default-cell-style-name=
"Default"/>
1110 <table:table-column table:
style-name=
"co6" table:
default-cell-style-name=
"Default"/>
1111 <table:table-column table:
style-name=
"co12" table:
number-columns-repeated=
"2" table:
default-cell-style-name=
"Default"/>
1112 <table:table-column table:
style-name=
"co3" table:
number-columns-repeated=
"8" table:
default-cell-style-name=
"Default"/>
1113 <table:table-row table:
style-name=
"ro6">
1114 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1115 <text:p>Function
</text:p>
1117 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1118 <text:p>Expected
</text:p>
1120 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1121 <text:p>Correct
</text:p>
1123 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1124 <text:p>FunctionString
</text:p>
1126 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string">
1127 <text:p>Comment
</text:p>
1129 <table:table-cell table:
number-columns-repeated=
"3"/>
1130 <table:table-cell table:
style-name=
"ce30" office:
value-type=
"string" calcext:
value-type=
"string">
1131 <text:p>Data
</text:p>
1133 <table:table-cell table:
style-name=
"ce30" office:
value-type=
"string" calcext:
value-type=
"string">
1134 <text:p>Description
</text:p>
1136 <table:table-cell table:
style-name=
"ce36"/>
1137 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"2"/>
1138 <table:table-cell table:
style-name=
"ce36"/>
1139 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"2"/>
1140 <table:table-cell table:
style-name=
"ce36"/>
1141 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"2"/>
1142 <table:table-cell table:
style-name=
"ce36"/>
1144 <table:table-row table:
style-name=
"ro6">
1145 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;5;7;15000)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-352.973422514773" calcext:
value-type=
"currency">
1146 <text:p>-
352.97 Kč
</text:p>
1148 <table:table-cell office:
value-type=
"float" office:
value=
"-352.973422514773" calcext:
value-type=
"float">
1149 <text:p>-
352.973422514773</text:p>
1151 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A2]=[.B2]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1152 <text:p>TRUE
</text:p>
1154 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A2])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,5,7,15000)" calcext:
value-type=
"string">
1155 <text:p>=IPMT(
0.05,
5,
7,
15000)
</text:p>
1157 <table:table-cell table:
style-name=
"ce24"/>
1158 <table:table-cell table:
number-columns-repeated=
"3"/>
1159 <table:table-cell table:
style-name=
"ce31" office:
value-type=
"percentage" office:
value=
"0.1" calcext:
value-type=
"percentage">
1160 <text:p>10.00%
</text:p>
1162 <table:table-cell table:
style-name=
"ce32" office:
value-type=
"string" calcext:
value-type=
"string">
1163 <text:p>Annual interest
</text:p>
1165 <table:table-cell table:
style-name=
"ce36"/>
1166 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1167 <table:table-cell table:
style-name=
"ce36"/>
1168 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1169 <table:table-cell table:
style-name=
"ce36"/>
1170 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1171 <table:table-cell table:
style-name=
"ce36"/>
1173 <table:table-row table:
style-name=
"ro6">
1174 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.075/12; 8; 2*12; 5000)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-22.6129267839967" calcext:
value-type=
"currency">
1175 <text:p>-
22.61 Kč
</text:p>
1177 <table:table-cell office:
value-type=
"float" office:
value=
"-22.6129267839967" calcext:
value-type=
"float">
1178 <text:p>-
22.6129267839967</text:p>
1180 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A3]=[.B3]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1181 <text:p>TRUE
</text:p>
1183 <table:table-cell table:
formula=
"of:=FORMULA([.A3])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.075/12, 8, 2*12, 5000)" calcext:
value-type=
"string">
1184 <text:p>=IPMT(
0.075/
12,
8,
2*
12,
5000)
</text:p>
1186 <table:table-cell table:
style-name=
"ce24"/>
1187 <table:table-cell table:
number-columns-repeated=
"3"/>
1188 <table:table-cell table:
style-name=
"ce32" office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
1191 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1192 <text:p>Period for which you want to find the interest paid.
</text:p>
1195 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1196 <table:table-cell table:
style-name=
"ce36"/>
1197 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1198 <table:table-cell table:
style-name=
"ce36"/>
1199 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1200 <table:table-cell table:
style-name=
"ce36"/>
1202 <table:table-row table:
style-name=
"ro6">
1203 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.06/52; 30; 4*52; 8000; 0 ;1)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-8.06341136318208" calcext:
value-type=
"currency">
1204 <text:p>-
8.06 Kč
</text:p>
1206 <table:table-cell office:
value-type=
"float" office:
value=
"-8.06341136318208" calcext:
value-type=
"float">
1207 <text:p>-
8.06341136318208</text:p>
1209 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A4]=[.B4]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1210 <text:p>TRUE
</text:p>
1212 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A4])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.06/52, 30, 4*52, 8000, 0 ,1)" calcext:
value-type=
"string">
1213 <text:p>=IPMT(
0.06/
52,
30,
4*
52,
8000,
0 ,
1)
</text:p>
1215 <table:table-cell table:
number-columns-repeated=
"4"/>
1216 <table:table-cell table:
style-name=
"ce32" office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
1219 <table:table-cell table:
style-name=
"ce32" office:
value-type=
"string" calcext:
value-type=
"string">
1220 <text:p>Years of loan
</text:p>
1222 <table:table-cell table:
style-name=
"ce36"/>
1223 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1224 <table:table-cell table:
style-name=
"ce36"/>
1225 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1226 <table:table-cell table:
style-name=
"ce36"/>
1227 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1228 <table:table-cell table:
style-name=
"ce36"/>
1230 <table:table-row table:
style-name=
"ro7">
1231 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.0525/1; 4; 10*1; 6500)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-256.504747019891" calcext:
value-type=
"currency">
1232 <text:p>-
256.50 Kč
</text:p>
1234 <table:table-cell office:
value-type=
"float" office:
value=
"-256.504747019891" calcext:
value-type=
"float">
1235 <text:p>-
256.504747019891</text:p>
1237 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A5]=[.B5]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1238 <text:p>TRUE
</text:p>
1240 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A5])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.0525/1, 4, 10*1, 6500)" calcext:
value-type=
"string">
1241 <text:p>=IPMT(
0.0525/
1,
4,
10*
1,
6500)
</text:p>
1243 <table:table-cell table:
number-columns-repeated=
"4"/>
1244 <table:table-cell table:
style-name=
"ce32" office:
value-type=
"float" office:
value=
"8000" calcext:
value-type=
"float">
1245 <text:p>8000</text:p>
1247 <table:table-cell table:
style-name=
"ce32" office:
value-type=
"string" calcext:
value-type=
"string">
1248 <text:p>Present value of loan
</text:p>
1250 <table:table-cell table:
style-name=
"ce36"/>
1251 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"3"/>
1252 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1253 <table:table-cell table:
style-name=
"ce36"/>
1254 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1255 <table:table-cell table:
style-name=
"ce36"/>
1257 <table:table-row table:
style-name=
"ro6">
1258 <table:table-cell table:
style-name=
"ce12" table:
formula=
"of:=IPMT([.I2]/12; [.I3]; [.I4]*12;[.I5])" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-66.6666666666667" calcext:
value-type=
"currency">
1259 <text:p>-
66.67 Kč
</text:p>
1261 <table:table-cell office:
value-type=
"float" office:
value=
"-66.6666666666667" calcext:
value-type=
"float">
1262 <text:p>-
66.6666666666667</text:p>
1264 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A6]=[.B6]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1265 <text:p>TRUE
</text:p>
1267 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A6])" office:
value-type=
"string" office:
string-value=
"=IPMT(I2/12, I3, I4*12,I5)" calcext:
value-type=
"string">
1268 <text:p>=IPMT(I2/
12, I3, I4*
12,I5)
</text:p>
1270 <table:table-cell table:
number-columns-repeated=
"4"/>
1271 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"3"/>
1273 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1274 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"3"/>
1275 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1276 <table:table-cell table:
style-name=
"ce36"/>
1278 <table:table-row table:
style-name=
"ro6">
1279 <table:table-cell table:
style-name=
"ce12" table:
formula=
"of:=IPMT([.I2]; 3;[.I4]; [.I5])" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-292.447129909365" calcext:
value-type=
"currency">
1280 <text:p>-
292.45 Kč
</text:p>
1282 <table:table-cell office:
value-type=
"float" office:
value=
"-292.447129909365" calcext:
value-type=
"float">
1283 <text:p>-
292.447129909365</text:p>
1285 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A7]=[.B7]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1286 <text:p>TRUE
</text:p>
1288 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A7])" office:
value-type=
"string" office:
string-value=
"=IPMT(I2, 3,I4, I5)" calcext:
value-type=
"string">
1289 <text:p>=IPMT(I2,
3,I4, I5)
</text:p>
1291 <table:table-cell table:
number-columns-repeated=
"5"/>
1292 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1293 <table:table-cell table:
style-name=
"ce37" table:
number-columns-repeated=
"2"/>
1294 <table:table-cell table:
style-name=
"ce33"/>
1296 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1297 <table:table-cell table:
style-name=
"ce30" table:
number-columns-repeated=
"3"/>
1299 <table:table-row table:
style-name=
"ro6">
1300 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0;5;7;15000)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-0" calcext:
value-type=
"currency">
1301 <text:p>0.00 Kč
</text:p>
1303 <table:table-cell office:
value-type=
"float" office:
value=
"-0" calcext:
value-type=
"float">
1306 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=[.A8]=[.B8]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1307 <text:p>TRUE
</text:p>
1309 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A8])" office:
value-type=
"string" office:
string-value=
"=IPMT(0,5,7,15000)" calcext:
value-type=
"string">
1310 <text:p>=IPMT(
0,
5,
7,
15000)
</text:p>
1312 <table:table-cell table:
style-name=
"ce25"/>
1313 <table:table-cell table:
number-columns-repeated=
"4"/>
1314 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1315 <table:table-cell table:
style-name=
"ce37" table:
number-columns-repeated=
"2"/>
1316 <table:table-cell table:
number-columns-repeated=
"5"/>
1317 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1319 <table:table-row table:
style-name=
"ro6">
1320 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;0;7;15000)" office:
value-type=
"string" office:
string-value=
"" calcext:
value-type=
"error">
1321 <text:p>Err:
502</text:p>
1323 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1324 <text:p>error
</text:p>
1326 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=ISERROR([.A9])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1327 <text:p>TRUE
</text:p>
1329 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A9])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,0,7,15000)" calcext:
value-type=
"string">
1330 <text:p>=IPMT(
0.05,
0,
7,
15000)
</text:p>
1332 <table:table-cell table:
number-columns-repeated=
"5"/>
1333 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1334 <table:table-cell table:
style-name=
"ce38" table:
number-columns-repeated=
"2"/>
1335 <table:table-cell table:
number-columns-repeated=
"7"/>
1337 <table:table-row table:
style-name=
"ro6">
1338 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;5;0;15000)" office:
value-type=
"string" office:
string-value=
"" calcext:
value-type=
"error">
1339 <text:p>Err:
502</text:p>
1341 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1342 <text:p>error
</text:p>
1344 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=ISERROR([.A10])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1345 <text:p>TRUE
</text:p>
1347 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A10])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,5,0,15000)" calcext:
value-type=
"string">
1348 <text:p>=IPMT(
0.05,
5,
0,
15000)
</text:p>
1350 <table:table-cell table:
number-columns-repeated=
"5"/>
1351 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1353 <table:table-cell table:
style-name=
"ce37"/>
1354 <table:table-cell table:
style-name=
"ce33"/>
1355 <table:table-cell table:
number-columns-repeated=
"6"/>
1357 <table:table-row table:
style-name=
"ro6">
1358 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;5;7;0)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-0" calcext:
value-type=
"currency">
1359 <text:p>0.00 Kč
</text:p>
1361 <table:table-cell office:
value-type=
"float" office:
value=
"-0" calcext:
value-type=
"float">
1364 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=[.A11]=[.B11]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1365 <text:p>TRUE
</text:p>
1367 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A11])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,5,7,0)" calcext:
value-type=
"string">
1368 <text:p>=IPMT(
0.05,
5,
7,
0)
</text:p>
1370 <table:table-cell table:
number-columns-repeated=
"5"/>
1371 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1372 <table:table-cell table:
number-columns-repeated=
"9"/>
1374 <table:table-row table:
style-name=
"ro6">
1375 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;5;7;)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-0" calcext:
value-type=
"currency">
1376 <text:p>0.00 Kč
</text:p>
1378 <table:table-cell office:
value-type=
"float" office:
value=
"-0" calcext:
value-type=
"float">
1381 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=[.A12]=[.B12]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1382 <text:p>TRUE
</text:p>
1384 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A12])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,5,7,)" calcext:
value-type=
"string">
1385 <text:p>=IPMT(
0.05,
5,
7,)
</text:p>
1387 <table:table-cell table:
number-columns-repeated=
"5"/>
1388 <table:table-cell table:
style-name=
"ce32" table:
number-columns-repeated=
"2"/>
1389 <table:table-cell table:
number-columns-repeated=
"9"/>
1391 <table:table-row table:
style-name=
"ro6">
1392 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;5;7)" office:
value-type=
"string" office:
string-value=
"" calcext:
value-type=
"error">
1393 <text:p>Err:
511</text:p>
1395 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1396 <text:p>error
</text:p>
1398 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=ISERROR([.A13])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1399 <text:p>TRUE
</text:p>
1401 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A13])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,5,7)" calcext:
value-type=
"string">
1402 <text:p>=IPMT(
0.05,
5,
7)
</text:p>
1404 <table:table-cell table:
style-name=
"ce26"/>
1405 <table:table-cell table:
number-columns-repeated=
"4"/>
1406 <table:table-cell table:
style-name=
"ce33"/>
1407 <table:table-cell table:
style-name=
"ce35"/>
1408 <table:table-cell table:
style-name=
"ce33" table:
number-columns-repeated=
"3"/>
1409 <table:table-cell table:
number-columns-repeated=
"6"/>
1411 <table:table-row table:
style-name=
"ro6">
1412 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.05;5;;15000)" office:
value-type=
"string" office:
string-value=
"" calcext:
value-type=
"error">
1413 <text:p>Err:
502</text:p>
1415 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1416 <text:p>error
</text:p>
1418 <table:table-cell table:
style-name=
"ce49" table:
formula=
"of:=ISERROR([.A14])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1419 <text:p>TRUE
</text:p>
1421 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A14])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.05,5,,15000)" calcext:
value-type=
"string">
1422 <text:p>=IPMT(
0.05,
5,,
15000)
</text:p>
1424 <table:table-cell table:
number-columns-repeated=
"16"/>
1426 <table:table-row table:
style-name=
"ro6">
1427 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.06/52; 30; 4*52; 8000; ;1)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-8.06341136318208" calcext:
value-type=
"currency">
1428 <text:p>-
8.06 Kč
</text:p>
1430 <table:table-cell office:
value-type=
"float" office:
value=
"-8.06341136318208" calcext:
value-type=
"float">
1431 <text:p>-
8.06341136318208</text:p>
1433 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=[.A15]=[.B15]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1434 <text:p>TRUE
</text:p>
1436 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A15])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.06/52, 30, 4*52, 8000, ,1)" calcext:
value-type=
"string">
1437 <text:p>=IPMT(
0.06/
52,
30,
4*
52,
8000, ,
1)
</text:p>
1439 <table:table-cell table:
number-columns-repeated=
"6"/>
1440 <table:table-cell table:
style-name=
"ce35"/>
1441 <table:table-cell table:
number-columns-repeated=
"9"/>
1443 <table:table-row table:
style-name=
"ro6">
1444 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.06/52; 30; 4*52; 8000; 0 )" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-8.07271529937037" calcext:
value-type=
"currency">
1445 <text:p>-
8.07 Kč
</text:p>
1447 <table:table-cell office:
value-type=
"float" office:
value=
"-8.07271529937037" calcext:
value-type=
"float">
1448 <text:p>-
8.07271529937037</text:p>
1450 <table:table-cell table:
style-name=
"ce15" table:
formula=
"of:=[.A16]=[.B16]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
1451 <text:p>TRUE
</text:p>
1453 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A16])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.06/52, 30, 4*52, 8000, 0 )" calcext:
value-type=
"string">
1454 <text:p>=IPMT(
0.06/
52,
30,
4*
52,
8000,
0 )
</text:p>
1456 <table:table-cell table:
number-columns-repeated=
"5"/>
1457 <table:table-cell table:
style-name=
"ce34"/>
1458 <table:table-cell table:
style-name=
"ce35"/>
1459 <table:table-cell table:
style-name=
"ce33" table:
number-columns-repeated=
"3"/>
1460 <table:table-cell table:
number-columns-repeated=
"6"/>
1462 <table:table-row table:
style-name=
"ro8">
1463 <table:table-cell table:
number-columns-repeated=
"2"/>
1464 <table:table-cell table:
style-name=
"Default"/>
1465 <table:table-cell table:
number-columns-repeated=
"7"/>
1466 <table:table-cell table:
style-name=
"ce35"/>
1467 <table:table-cell table:
number-columns-repeated=
"9"/>
1469 <table:table-row table:
style-name=
"ro8">
1470 <table:table-cell table:
number-columns-repeated=
"2"/>
1471 <table:table-cell table:
style-name=
"Default"/>
1472 <table:table-cell table:
number-columns-repeated=
"17"/>
1474 <table:table-row table:
style-name=
"ro8">
1475 <table:table-cell table:
style-name=
"ce11"/>
1477 <table:table-cell table:
style-name=
"ce15"/>
1478 <table:table-cell table:
number-columns-repeated=
"17"/>
1480 <table:table-row table:
style-name=
"ro8">
1481 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.06/52; 30; 4*52; 8000; 0 ;2)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-8.06341136318208" calcext:
value-type=
"currency">
1482 <text:p>-
8.06 Kč
</text:p>
1484 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1485 <text:p>error
</text:p>
1487 <table:table-cell table:
style-name=
"ce16"/>
1488 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A20])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.06/52, 30, 4*52, 8000, 0 ,2)" calcext:
value-type=
"string">
1489 <text:p>=IPMT(
0.06/
52,
30,
4*
52,
8000,
0 ,
2)
</text:p>
1491 <table:table-cell table:
style-name=
"ce27" office:
value-type=
"string" calcext:
value-type=
"string">
1492 <text:p>Type parameter =
0 or
1</text:p>
1494 <table:table-cell table:
number-columns-repeated=
"15"/>
1496 <table:table-row table:
style-name=
"ro8">
1497 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=IPMT(0.06/52; 30; 4*52; 8000; 0 ;-2)" office:
value-type=
"currency" office:
currency=
"CZK" office:
value=
"-8.06341136318208" calcext:
value-type=
"currency">
1498 <text:p>-
8.06 Kč
</text:p>
1500 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1501 <text:p>error
</text:p>
1503 <table:table-cell table:
style-name=
"ce17"/>
1504 <table:table-cell table:
style-name=
"ce23" table:
formula=
"of:=FORMULA([.A21])" office:
value-type=
"string" office:
string-value=
"=IPMT(0.06/52, 30, 4*52, 8000, 0 ,-2)" calcext:
value-type=
"string">
1505 <text:p>=IPMT(
0.06/
52,
30,
4*
52,
8000,
0 ,-
2)
</text:p>
1507 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1508 <text:p>Tdf#
100650</text:p>
1510 <table:table-cell table:
number-columns-repeated=
"15"/>
1512 <table:table-row table:
style-name=
"ro8">
1513 <table:table-cell table:
number-columns-repeated=
"2"/>
1514 <table:table-cell table:
style-name=
"ce18"/>
1515 <table:table-cell table:
style-name=
"ce23"/>
1516 <table:table-cell table:
style-name=
"ce28"/>
1517 <table:table-cell table:
number-columns-repeated=
"15"/>
1519 <table:table-row table:
style-name=
"ro9">
1520 <table:table-cell table:
number-columns-repeated=
"2"/>
1521 <table:table-cell table:
style-name=
"ce18"/>
1523 <table:table-cell table:
style-name=
"ce23" office:
value-type=
"string" calcext:
value-type=
"string"><text:p><text:span text:
style-name=
"T1">IPMT
</text:span></text:p><text:p><text:span text:
style-name=
"T2">Summary:
</text:span><text:span text:
style-name=
"T3"> Returns the amount of an annuity payment going towards interest.
</text:span></text:p><text:p><text:span text:
style-name=
"T4">Syntax:
</text:span><text:span text:
style-name=
"T5"> IPMT(
</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"> Period ;
</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"> PV [ ;
</text:span><text:span text:
style-name=
"T7">Number
</text:span><text:span text:
style-name=
"T5"> FV =
0 [ ;
</text:span><text:span text:
style-name=
"T7">Number
</text:span><text:span text:
style-name=
"T5"> Type =
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 interest portion of an amortized payment for a constant interest rate and regular payments. The interest payment is the interest rate multiplied by the balance at the beginning of the period. The parameters are:
</text:span></text:p><text:p><text:span text:
style-name=
"T8">Rate: The periodic interest rate.
</text:span></text:p><text:p><text:span text:
style-name=
"T8">Period: The period for which the interest payment is computed.
</text:span></text:p><text:p><text:span text:
style-name=
"T8">Nper: The total number of periods for which the payments are made
</text:span></text:p><text:p><text:span text:
style-name=
"T8">PV: The present value (e.g. The initial loan amount).
</text:span></text:p><text:p><text:span text:
style-name=
"T8">FV: The future value (optional) at the end of the periods. Zero if omitted.
</text:span></text:p><text:p><text:span text:
style-name=
"T8">Type: the due date for the payments (optional). Zero if omitted. If type is
1, then payments are made at the beginning of each period. If type is
0, then payments are made at the end of each period.
</text:span></text:p>
1525 <table:table-cell table:
number-columns-repeated=
"15"/>
1527 <table:table-row table:
style-name=
"ro8">
1528 <table:table-cell table:
number-columns-repeated=
"2"/>
1529 <table:table-cell table:
style-name=
"ce18"/>
1530 <table:table-cell table:
style-name=
"ce23"/>
1531 <table:table-cell table:
style-name=
"ce29"/>
1532 <table:table-cell table:
number-columns-repeated=
"15"/>
1534 <table:table-row table:
style-name=
"ro8">
1535 <table:table-cell table:
number-columns-repeated=
"2"/>
1536 <table:table-cell table:
style-name=
"ce19"/>
1537 <table:table-cell table:
number-columns-repeated=
"17"/>
1539 <table:table-row table:
style-name=
"ro10">
1540 <table:table-cell table:
number-columns-repeated=
"2"/>
1541 <table:table-cell table:
style-name=
"ce19"/>
1542 <table:table-cell table:
number-columns-repeated=
"17"/>
1544 <table:table-row table:
style-name=
"ro8">
1545 <table:table-cell table:
number-columns-repeated=
"2"/>
1546 <table:table-cell table:
style-name=
"ce19"/>
1547 <table:table-cell table:
number-columns-repeated=
"6"/>
1548 <table:table-cell table:
style-name=
"ce35"/>
1549 <table:table-cell table:
number-columns-repeated=
"10"/>
1551 <table:table-row table:
style-name=
"ro8">
1552 <table:table-cell table:
number-columns-repeated=
"2"/>
1553 <table:table-cell table:
style-name=
"ce20"/>
1554 <table:table-cell table:
number-columns-repeated=
"17"/>
1556 <table:table-row table:
style-name=
"ro11">
1557 <table:table-cell table:
number-columns-repeated=
"2"/>
1558 <table:table-cell table:
style-name=
"ce21"/>
1559 <table:table-cell table:
number-columns-repeated=
"17"/>
1561 <table:table-row table:
style-name=
"ro8">
1563 <table:table-cell table:
style-name=
"ce13" table:
number-columns-repeated=
"4"/>
1564 <table:table-cell table:
style-name=
"Normal_20_2" table:
number-columns-repeated=
"2"/>
1565 <table:table-cell table:
number-columns-repeated=
"13"/>
1567 <table:table-row table:
style-name=
"ro8" table:
number-rows-repeated=
"10">
1568 <table:table-cell table:
style-name=
"ce13" table:
number-columns-repeated=
"5"/>
1569 <table:table-cell table:
number-columns-repeated=
"15"/>
1571 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"60">
1572 <table:table-cell table:
number-columns-repeated=
"2"/>
1573 <table:table-cell table:
style-name=
"ce57"/>
1574 <table:table-cell table:
number-columns-repeated=
"17"/>
1576 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048475">
1577 <table:table-cell table:
number-columns-repeated=
"20"/>
1579 <table:table-row table:
style-name=
"ro2">
1580 <table:table-cell table:
number-columns-repeated=
"20"/>
1582 <calcext:conditional-formats>
1583 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C41:Sheet2.C100 Sheet2.C29:Sheet2.C29 Sheet2.C21:Sheet2.C27">
1584 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C21"/>
1585 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C21"/>
1586 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C21"/>
1587 </calcext:conditional-format>
1588 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C22:Sheet2.C29 Sheet2.C2:Sheet2.C16 Sheet2.C19:Sheet2.C19">
1589 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C2"/>
1590 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C2"/>
1591 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C2"/>
1592 </calcext:conditional-format>
1593 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C19:Sheet2.C19 Sheet2.C9:Sheet2.C9 Sheet2.C11:Sheet2.C13 Sheet2.C15:Sheet2.C16">
1594 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C9"/>
1595 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C9"/>
1596 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C9"/>
1597 </calcext:conditional-format>
1598 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C19:Sheet2.C19 Sheet2.C9:Sheet2.C9 Sheet2.C11:Sheet2.C13 Sheet2.C15:Sheet2.C16">
1599 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C9"/>
1600 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C9"/>
1601 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C9"/>
1602 </calcext:conditional-format>
1603 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C19:Sheet2.C19 Sheet2.C9:Sheet2.C9 Sheet2.C11:Sheet2.C13 Sheet2.C15:Sheet2.C16">
1604 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C9"/>
1605 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C9"/>
1606 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C9"/>
1607 </calcext:conditional-format>
1608 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C20:Sheet2.C21">
1609 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C20"/>
1610 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C20"/>
1611 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C20"/>
1612 </calcext:conditional-format>
1613 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C20:Sheet2.C20">
1614 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C20"/>
1615 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C20"/>
1616 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C20"/>
1617 </calcext:conditional-format>
1618 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C20:Sheet2.C20">
1619 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C20"/>
1620 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C20"/>
1621 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C20"/>
1622 </calcext:conditional-format>
1623 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C20:Sheet2.C20">
1624 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C20"/>
1625 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C20"/>
1626 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C20"/>
1627 </calcext:conditional-format>
1628 </calcext:conditional-formats>
1630 <table:table table:
name=
"'file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/function_based_test_Example.fods/function_based_test_Example_reference.fods'#Sheet2" table:
print=
"false" table:
style-name=
"ta_extref">
1631 <table:table-source xlink:
type=
"simple" xlink:
href=
"../function_based_test_Example.fods/function_based_test_Example_reference.fods" table:
table-name=
"Sheet2" table:
mode=
"copy-results-only"/>
1632 <table:table-column table:
number-columns-repeated=
"8"/>
1633 <table:table-row table:
number-rows-repeated=
"2">
1634 <table:table-cell table:
number-columns-repeated=
"8"/>
1637 <table:table-cell table:
number-columns-repeated=
"7"/>
1638 <table:table-cell table:
style-name=
"ce1" office:
value-type=
"float" office:
value=
"4">
1643 <table:named-expressions>
1644 <table:named-range table:
name=
"day1" table:
base-cell-address=
"$Sheet2.$K$2" table:
cell-range-address=
"$Sheet2.$K$2"/>
1645 <table:named-range table:
name=
"day2" table:
base-cell-address=
"$Sheet2.$K$3" table:
cell-range-address=
"$Sheet2.$K$3"/>
1646 <table:named-range table:
name=
"days" table:
base-cell-address=
"$Sheet2.$K$4" table:
cell-range-address=
"$Sheet2.$K$4:.$K$6"/>
1647 <table:named-range table:
name=
"one" table:
base-cell-address=
"$Sheet2.$M$1" table:
cell-range-address=
"$Sheet2.$M$1"/>
1648 </table:named-expressions>
1649 </office:spreadsheet>