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=
"12.7mm"/>
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=
"N108P0" 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=
"N108">
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=
"N108P0"/>
24 </number:currency-style>
25 <number:currency-style style:
name=
"N110P0" style:
volatile=
"true">
26 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
27 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
28 </number:currency-style>
29 <number:currency-style style:
name=
"N110">
30 <number:text>-
</number:text>
31 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
32 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
33 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N110P0"/>
34 </number:currency-style>
35 <number:currency-style style:
name=
"N112P0" style:
volatile=
"true">
36 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
37 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
38 </number:currency-style>
39 <number:currency-style style:
name=
"N112">
40 <number:text>-
</number:text>
41 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
42 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
43 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N112P0"/>
44 </number:currency-style>
45 <number:currency-style style:
name=
"N113P0" style:
volatile=
"true">
46 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
47 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
48 </number:currency-style>
49 <number:currency-style style:
name=
"N113">
50 <style:text-properties fo:
color=
"#ff0000"/>
51 <number:text>-
</number:text>
52 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
53 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
54 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N113P0"/>
55 </number:currency-style>
56 <number:currency-style style:
name=
"N114P0" style:
volatile=
"true">
57 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
58 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
59 </number:currency-style>
60 <number:currency-style style:
name=
"N114">
61 <style:text-properties fo:
color=
"#ff0000"/>
62 <number:text>-
</number:text>
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 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N114P0"/>
66 </number:currency-style>
67 <number:currency-style style:
name=
"N116P0" style:
volatile=
"true">
68 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
69 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
70 </number:currency-style>
71 <number:currency-style style:
name=
"N116">
72 <style:text-properties fo:
color=
"#ff0000"/>
73 <number:text>-
</number:text>
74 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
75 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
76 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N116P0"/>
77 </number:currency-style>
78 <number:number-style style:
name=
"N118P0" style:
volatile=
"true">
79 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
80 <number:text> </number:text>
81 </number:number-style>
82 <number:number-style style:
name=
"N118">
83 <number:text>(
</number:text>
84 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
85 <number:text>)
</number:text>
86 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N118P0"/>
87 </number:number-style>
88 <number:number-style style:
name=
"N120P0" style:
volatile=
"true">
89 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
90 <number:text> </number:text>
91 </number:number-style>
92 <number:number-style style:
name=
"N120">
93 <number:text>(
</number:text>
94 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
95 <number:text>)
</number:text>
96 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N120P0"/>
97 </number:number-style>
98 <number:currency-style style:
name=
"N122P0" style:
volatile=
"true">
99 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
100 <loext:fill-character> </loext:fill-character>
101 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
102 </number:currency-style>
103 <number:currency-style style:
name=
"N122">
104 <number:text>-
</number:text>
105 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
106 <loext:fill-character> </loext:fill-character>
107 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
108 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N122P0"/>
109 </number:currency-style>
110 <number:currency-style style:
name=
"N124P0" style:
volatile=
"true">
111 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
112 <loext:fill-character> </loext:fill-character>
113 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
114 </number:currency-style>
115 <number:currency-style style:
name=
"N124">
116 <number:text>-
</number:text>
117 <number:currency-symbol number:
language=
"en" number:
country=
"GB">£
</number:currency-symbol>
118 <loext:fill-character> </loext:fill-character>
119 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
120 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N124P0"/>
121 </number:currency-style>
122 <number:currency-style style:
name=
"N126P0" style:
volatile=
"true">
123 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
124 <number:text> </number:text>
125 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
126 </number:currency-style>
127 <number:currency-style style:
name=
"N126">
128 <number:text>-
</number:text>
129 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
130 <number:text> </number:text>
131 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
132 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N126P0"/>
133 </number:currency-style>
134 <number:currency-style style:
name=
"N127P0" style:
volatile=
"true">
135 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
136 <number:text> </number:text>
137 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
138 </number:currency-style>
139 <number:currency-style style:
name=
"N127">
140 <number:text>-
</number:text>
141 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
142 <number:text> </number:text>
143 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
144 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N127P0"/>
145 </number:currency-style>
146 <number:currency-style style:
name=
"N128P0" style:
volatile=
"true">
147 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
148 <number:text> </number:text>
149 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
150 </number:currency-style>
151 <number:currency-style style:
name=
"N128">
152 <style:text-properties fo:
color=
"#ff0000"/>
153 <number:text>-
</number:text>
154 <number:number number:
decimal-places=
"0" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
155 <number:text> </number:text>
156 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
157 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N128P0"/>
158 </number:currency-style>
159 <number:currency-style style:
name=
"N130P0" style:
volatile=
"true">
160 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
161 <number:text> </number:text>
162 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
163 </number:currency-style>
164 <number:currency-style style:
name=
"N130">
165 <style:text-properties fo:
color=
"#ff0000"/>
166 <number:text>-
</number:text>
167 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"0" number:
min-integer-digits=
"1" number:
decimal-replacement=
"--" number:
grouping=
"true"/>
168 <number:text> </number:text>
169 <number:currency-symbol number:
language=
"cs" number:
country=
"CZ">Kč
</number:currency-symbol>
170 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N130P0"/>
171 </number:currency-style>
172 <number:currency-style style:
name=
"N132P0" style:
volatile=
"true">
173 <number:currency-symbol number:
language=
"en" number:
country=
"US">$
</number:currency-symbol>
174 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
175 </number:currency-style>
176 <number:currency-style style:
name=
"N132">
177 <style:text-properties fo:
color=
"#ff0000"/>
178 <number:text>-
</number:text>
179 <number:currency-symbol number:
language=
"en" number:
country=
"US">$
</number:currency-symbol>
180 <number:number number:
decimal-places=
"2" loext:
min-decimal-places=
"2" number:
min-integer-digits=
"1" number:
grouping=
"true"/>
181 <style:map style:
condition=
"value()>=0" style:
apply-style-name=
"N132P0"/>
182 </number:currency-style>
183 <number:number-style style:
name=
"N133">
184 <number:number number:
decimal-places=
"9" loext:
min-decimal-places=
"9" number:
min-integer-digits=
"1"/>
185 </number:number-style>
186 <number:number-style style:
name=
"N134">
187 <number:number number:
decimal-places=
"8" loext:
min-decimal-places=
"8" number:
min-integer-digits=
"1"/>
188 </number:number-style>
189 <number:number-style style:
name=
"N135">
190 <number:number number:
decimal-places=
"10" loext:
min-decimal-places=
"10" number:
min-integer-digits=
"1"/>
191 </number:number-style>
192 <number:number-style style:
name=
"N136">
193 <number:number number:
decimal-places=
"11" loext:
min-decimal-places=
"11" number:
min-integer-digits=
"1"/>
194 </number:number-style>
195 <number:number-style style:
name=
"N137">
196 <number:number number:
decimal-places=
"12" loext:
min-decimal-places=
"12" number:
min-integer-digits=
"1"/>
197 </number:number-style>
198 <number:number-style style:
name=
"N138">
199 <number:number number:
decimal-places=
"13" loext:
min-decimal-places=
"13" number:
min-integer-digits=
"1"/>
200 </number:number-style>
201 <number:number-style style:
name=
"N139">
202 <number:number number:
decimal-places=
"14" loext:
min-decimal-places=
"14" number:
min-integer-digits=
"1"/>
203 </number:number-style>
204 <number:number-style style:
name=
"N140">
205 <number:number number:
decimal-places=
"15" loext:
min-decimal-places=
"15" number:
min-integer-digits=
"1"/>
206 </number:number-style>
207 <number:number-style style:
name=
"N141">
208 <number:number number:
decimal-places=
"16" loext:
min-decimal-places=
"16" number:
min-integer-digits=
"1"/>
209 </number:number-style>
210 <number:number-style style:
name=
"N142">
211 <number:number number:
decimal-places=
"17" loext:
min-decimal-places=
"17" number:
min-integer-digits=
"1"/>
212 </number:number-style>
213 <number:number-style style:
name=
"N143">
214 <number:number number:
decimal-places=
"18" loext:
min-decimal-places=
"18" number:
min-integer-digits=
"1"/>
215 </number:number-style>
216 <style:style style:
name=
"Default" style:
family=
"table-cell">
217 <style:text-properties 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-name-complex=
"Droid Sans Devanagari" style:
font-family-complex=
"'Droid Sans Devanagari'" style:
font-family-generic-complex=
"system" style:
font-pitch-complex=
"variable"/>
219 <style:style style:
name=
"Result" style:
family=
"table-cell" style:
parent-style-name=
"Default">
220 <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"/>
222 <style:style style:
name=
"Result2" style:
family=
"table-cell" style:
parent-style-name=
"Result" style:
data-style-name=
"N108"/>
223 <style:style style:
name=
"Heading" style:
family=
"table-cell" style:
parent-style-name=
"Default">
224 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
225 <style:paragraph-properties fo:
text-align=
"center"/>
226 <style:text-properties fo:
font-size=
"16pt" fo:
font-style=
"italic" fo:
font-weight=
"bold"/>
228 <style:style style:
name=
"Heading1" style:
family=
"table-cell" style:
parent-style-name=
"Heading">
229 <style:table-cell-properties style:
rotation-angle=
"90"/>
231 <style:style style:
name=
"Untitled1" style:
family=
"table-cell" style:
parent-style-name=
"Default">
232 <style:table-cell-properties fo:
background-color=
"#ff3333"/>
234 <style:style style:
name=
"Untitled2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
235 <style:table-cell-properties fo:
background-color=
"#99ff66"/>
238 <office:automatic-styles>
239 <style:style style:
name=
"co1" style:
family=
"table-column">
240 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"65.51mm"/>
242 <style:style style:
name=
"co2" style:
family=
"table-column">
243 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"89.08mm"/>
245 <style:style style:
name=
"co3" style:
family=
"table-column">
246 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"22.58mm"/>
248 <style:style style:
name=
"co4" style:
family=
"table-column">
249 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"24.85mm"/>
251 <style:style style:
name=
"co5" style:
family=
"table-column">
252 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"25.65mm"/>
254 <style:style style:
name=
"co6" style:
family=
"table-column">
255 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"26.18mm"/>
257 <style:style style:
name=
"co7" style:
family=
"table-column">
258 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"62.95mm"/>
260 <style:style style:
name=
"co8" style:
family=
"table-column">
261 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"17.97mm"/>
263 <style:style style:
name=
"co9" style:
family=
"table-column">
264 <style:table-column-properties fo:
break-before=
"auto" style:
column-width=
"5.8mm"/>
266 <style:style style:
name=
"ro1" style:
family=
"table-row">
267 <style:table-row-properties style:
row-height=
"8.63mm" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
269 <style:style style:
name=
"ro2" style:
family=
"table-row">
270 <style:table-row-properties style:
row-height=
"4.52mm" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
272 <style:style style:
name=
"ro3" style:
family=
"table-row">
273 <style:table-row-properties style:
row-height=
"6.12mm" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
275 <style:style style:
name=
"ro4" style:
family=
"table-row">
276 <style:table-row-properties style:
row-height=
"5.29mm" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
278 <style:style style:
name=
"ro5" style:
family=
"table-row">
279 <style:table-row-properties style:
row-height=
"4.66mm" fo:
break-before=
"auto" style:
use-optimal-row-height=
"true"/>
281 <style:style style:
name=
"ta1" style:
family=
"table" style:
master-page-name=
"Default">
282 <style:table-properties table:
display=
"true" style:
writing-mode=
"lr-tb"/>
284 <number:boolean-style style:
name=
"N99">
286 </number:boolean-style>
287 <style:style style:
name=
"ce1" style:
family=
"table-cell" style:
parent-style-name=
"Default"/>
288 <style:style style:
name=
"ce2" style:
family=
"table-cell" style:
parent-style-name=
"Default">
289 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
290 <style:paragraph-properties fo:
text-align=
"start" fo:
margin-left=
"0mm"/>
291 <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"/>
293 <style:style style:
name=
"ce3" style:
family=
"table-cell" style:
parent-style-name=
"Default">
294 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
295 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
296 <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"/>
298 <style:style style:
name=
"ce4" style:
family=
"table-cell" style:
parent-style-name=
"Default">
299 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
300 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
301 <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"/>
303 <style:style style:
name=
"ce5" style:
family=
"table-cell" style:
parent-style-name=
"Default">
304 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
305 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
307 <style:style style:
name=
"ce6" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
308 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
309 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
310 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B3"/>
311 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B3"/>
312 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B3"/>
314 <style:style style:
name=
"ce7" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
315 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
316 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
317 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B8"/>
318 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B8"/>
319 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B8"/>
321 <style:style style:
name=
"ce8" style:
family=
"table-cell" style:
parent-style-name=
"Default">
322 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
323 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
324 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet1.B8"/>
325 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet1.B8"/>
326 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet1.B8"/>
328 <style:style style:
name=
"ce9" style:
family=
"table-cell" style:
parent-style-name=
"Default">
329 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
330 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
331 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
333 <style:style style:
name=
"ce10" style:
family=
"table-cell" style:
parent-style-name=
"Default">
334 <style:text-properties style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal"/>
336 <style:style style:
name=
"ce11" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
337 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
338 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
339 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
340 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
341 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
343 <style:style style:
name=
"ce12" style:
family=
"table-cell" style:
parent-style-name=
"Default" style:
data-style-name=
"N99">
344 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
345 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
346 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C6"/>
347 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C6"/>
348 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C6"/>
350 <style:style style:
name=
"ce13" style:
family=
"table-cell" style:
parent-style-name=
"Default">
351 <style:table-cell-properties style:
text-align-source=
"fix" style:
repeat-content=
"false"/>
352 <style:paragraph-properties fo:
text-align=
"center" fo:
margin-left=
"0mm"/>
353 <style:map style:
condition=
"cell-content()=""" style:
apply-style-name=
"Default" style:
base-cell-address=
"Sheet2.C2"/>
354 <style:map style:
condition=
"cell-content()=0" style:
apply-style-name=
"Untitled1" style:
base-cell-address=
"Sheet2.C2"/>
355 <style:map style:
condition=
"cell-content()=1" style:
apply-style-name=
"Untitled2" style:
base-cell-address=
"Sheet2.C2"/>
357 <style:style style:
name=
"ce14" style:
family=
"table-cell" style:
parent-style-name=
"Default">
358 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
360 <style:style style:
name=
"ce15" style:
family=
"table-cell" style:
parent-style-name=
"Default">
361 <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=
"Courier New" 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=
"en" style:
country-asian=
"US" style:
font-style-asian=
"normal" style:
font-weight-asian=
"normal" style:
font-size-complex=
"10pt" style:
language-complex=
"en" style:
country-complex=
"US" 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"/>
363 <style:style style:
name=
"ce16" style:
family=
"table-cell" style:
parent-style-name=
"Default">
364 <style:table-cell-properties fo:
background-color=
"#ffff00"/>
365 <style:text-properties fo:
font-weight=
"bold" style:
font-weight-asian=
"bold" style:
font-weight-complex=
"bold"/>
367 <style:style style:
name=
"ce17" style:
family=
"table-cell" style:
parent-style-name=
"Default">
368 <style:table-cell-properties fo:
background-color=
"#ffff00"/>
370 <style:style style:
name=
"ta_extref" style:
family=
"table">
371 <style:table-properties table:
display=
"false"/>
373 <style:page-layout style:
name=
"pm1">
374 <style:page-layout-properties style:
writing-mode=
"lr-tb"/>
376 <style:header-footer-properties fo:
min-height=
"7.5mm" fo:
margin-left=
"0mm" fo:
margin-right=
"0mm" fo:
margin-bottom=
"2.5mm"/>
377 </style:header-style>
379 <style:header-footer-properties fo:
min-height=
"7.5mm" fo:
margin-left=
"0mm" fo:
margin-right=
"0mm" fo:
margin-top=
"2.5mm"/>
380 </style:footer-style>
382 <style:page-layout style:
name=
"pm2">
383 <style:page-layout-properties style:
writing-mode=
"lr-tb"/>
385 <style:header-footer-properties fo:
min-height=
"7.5mm" fo:
margin-left=
"0mm" fo:
margin-right=
"0mm" fo:
margin-bottom=
"2.5mm" fo:
border=
"2.49pt solid #000000" fo:
padding=
"0.18mm" fo:
background-color=
"#c0c0c0">
386 <style:background-image/>
387 </style:header-footer-properties>
388 </style:header-style>
390 <style:header-footer-properties fo:
min-height=
"7.5mm" fo:
margin-left=
"0mm" fo:
margin-right=
"0mm" fo:
margin-top=
"2.5mm" fo:
border=
"2.49pt solid #000000" fo:
padding=
"0.18mm" fo:
background-color=
"#c0c0c0">
391 <style:background-image/>
392 </style:header-footer-properties>
393 </style:footer-style>
395 <style:style style:
name=
"T1" style:
family=
"text">
396 <style:text-properties style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal"/>
398 <style:style style:
name=
"T2" style:
family=
"text">
399 <style:text-properties style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal" fo:
color=
"#0000ff"/>
401 <style:style style:
name=
"T3" style:
family=
"text">
402 <style:text-properties style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal" fo:
color=
"#ff0000"/>
404 <style:style style:
name=
"T4" style:
family=
"text">
405 <style:text-properties fo:
color=
"#0000ff" style:
font-name-asian=
"Microsoft YaHei" style:
font-name-complex=
"Mangal"/>
407 <style:style style:
name=
"T5" style:
family=
"text">
408 <style:text-properties fo:
color=
"#0000ff"/>
410 <style:style style:
name=
"T6" style:
family=
"text">
411 <style:text-properties fo:
color=
"#ff0000"/>
413 </office:automatic-styles>
414 <office:master-styles>
415 <style:master-page style:
name=
"Default" style:
page-layout-name=
"pm1">
417 <text:p><text:sheet-name>???
</text:sheet-name></text:p>
419 <style:header-left style:
display=
"false"/>
421 <text:p>Page
<text:page-number>1</text:page-number></text:p>
423 <style:footer-left style:
display=
"false"/>
425 <style:master-page style:
name=
"Report" style:
page-layout-name=
"pm2">
428 <text:p><text:sheet-name>???
</text:sheet-name> (
<text:title>???
</text:title>)
</text:p>
431 <text:p><text:date style:
data-style-name=
"N2" text:
date-value=
"2016-05-20">00.00.0000</text:date>,
<text:time style:
data-style-name=
"N2" text:
time-value=
"15:18:12.687346294">00:
00:
00</text:time></text:p>
432 </style:region-right>
434 <style:header-left style:
display=
"false"/>
436 <text:p>Page
<text:page-number>1</text:page-number> /
<text:page-count>99</text:page-count></text:p>
438 <style:footer-left style:
display=
"false"/>
440 </office:master-styles>
443 <table:calculation-settings table:
automatic-find-labels=
"false"/>
444 <table:table table:
name=
"Sheet1" table:
style-name=
"ta1">
445 <table:table-column table:
style-name=
"co1" table:
default-cell-style-name=
"Default"/>
446 <table:table-column table:
style-name=
"co1" table:
default-cell-style-name=
"ce5"/>
447 <table:table-column table:
style-name=
"co2" table:
default-cell-style-name=
"Default"/>
448 <table:table-row table:
style-name=
"ro1">
449 <table:table-cell table:
style-name=
"ce2" office:
value-type=
"string" calcext:
value-type=
"string">
450 <text:p>DCOUNTA Function
</text:p>
452 <table:table-cell table:
number-columns-repeated=
"2"/>
454 <table:table-row table:
style-name=
"ro2">
455 <table:table-cell table:
number-columns-repeated=
"3"/>
457 <table:table-row table:
style-name=
"ro3">
458 <table:table-cell table:
style-name=
"ce3" office:
value-type=
"string" calcext:
value-type=
"string">
459 <text:p>Result
</text:p>
461 <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">
462 <text:p>PRAVDA
</text:p>
466 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"3">
467 <table:table-cell table:
number-columns-repeated=
"3"/>
469 <table:table-row table:
style-name=
"ro4">
470 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
471 <text:p>Sheet
</text:p>
473 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
474 <text:p>Result
</text:p>
476 <table:table-cell table:
style-name=
"ce4" office:
value-type=
"string" calcext:
value-type=
"string">
477 <text:p>Description
</text:p>
480 <table:table-row table:
style-name=
"ro2">
481 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
484 <table:table-cell table:
style-name=
"ce7" table:
formula=
"of:=AND([Sheet2.C2:.C100])" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
485 <text:p>PRAVDA
</text:p>
487 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
488 <text:p>Simple DCOUNTA formulas with local references and values
</text:p>
491 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"30">
493 <table:table-cell table:
style-name=
"ce8"/>
496 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048537">
497 <table:table-cell table:
number-columns-repeated=
"3"/>
499 <table:table-row table:
style-name=
"ro2">
500 <table:table-cell table:
number-columns-repeated=
"3"/>
502 <calcext:conditional-formats>
503 <calcext:conditional-format calcext:
target-range-address=
"Sheet1.B8:Sheet1.B38">
504 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet1.B8"/>
505 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet1.B8"/>
506 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet1.B8"/>
507 </calcext:conditional-format>
508 <calcext:conditional-format calcext:
target-range-address=
"Sheet1.B3:Sheet1.B3">
509 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet1.B3"/>
510 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet1.B3"/>
511 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet1.B3"/>
512 </calcext:conditional-format>
513 </calcext:conditional-formats>
515 <table:table table:
name=
"Sheet2" table:
style-name=
"ta1" table:
print=
"false">
516 <table:table-column table:
style-name=
"co4" table:
default-cell-style-name=
"Default"/>
517 <table:table-column table:
style-name=
"co5" table:
default-cell-style-name=
"Default"/>
518 <table:table-column table:
style-name=
"co6" table:
default-cell-style-name=
"ce5"/>
519 <table:table-column table:
style-name=
"co7" table:
default-cell-style-name=
"Default"/>
520 <table:table-column table:
style-name=
"co8" table:
default-cell-style-name=
"Default"/>
521 <table:table-column table:
style-name=
"co9" table:
number-columns-repeated=
"4" table:
default-cell-style-name=
"Default"/>
522 <table:table-column table:
style-name=
"co3" table:
number-columns-repeated=
"6" table:
default-cell-style-name=
"Default"/>
523 <table:table-row table:
style-name=
"ro2">
524 <table:table-cell table:
style-name=
"ce9" office:
value-type=
"string" calcext:
value-type=
"string">
525 <text:p>Function
</text:p>
527 <table:table-cell table:
style-name=
"ce9" office:
value-type=
"string" calcext:
value-type=
"string">
528 <text:p>Expected
</text:p>
530 <table:table-cell table:
style-name=
"ce9" office:
value-type=
"string" calcext:
value-type=
"string">
531 <text:p>Correct
</text:p>
533 <table:table-cell table:
style-name=
"ce9" office:
value-type=
"string" calcext:
value-type=
"string">
534 <text:p>FunctionString
</text:p>
536 <table:table-cell table:
style-name=
"ce9" office:
value-type=
"string" calcext:
value-type=
"string">
537 <text:p>Comment
</text:p>
539 <table:table-cell table:
number-columns-repeated=
"4"/>
540 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
541 <text:p>Name
</text:p>
543 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
544 <text:p>Grade
</text:p>
546 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
549 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
550 <text:p>Distance to School
</text:p>
552 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
553 <text:p>Weight
</text:p>
557 <table:table-row table:
style-name=
"ro5">
558 <table:table-cell table:
style-name=
"ce10" table:
formula=
"of:=DCOUNTA([.J1:.N10];"Weight";[.J44:.N45])" office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
561 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
564 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=[.A2]=[.B2]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
565 <text:p>PRAVDA
</text:p>
567 <table:table-cell table:
style-name=
"ce10" office:
value-type=
"string" calcext:
value-type=
"string"><text:p><text:span text:
style-name=
"T1">DCOUNTA(
</text:span><text:span text:
style-name=
"T2">J1:N10
</text:span><text:span text:
style-name=
"T1">;
"Weight
";
</text:span><text:span text:
style-name=
"T3">J44:N45
</text:span><text:span text:
style-name=
"T1">)
</text:span></text:p>
569 <table:table-cell table:
number-columns-repeated=
"5"/>
570 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
571 <text:p>Andy
</text:p>
573 <table:table-cell office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
576 <table:table-cell office:
value-type=
"float" office:
value=
"9" calcext:
value-type=
"float">
579 <table:table-cell office:
value-type=
"float" office:
value=
"150" calcext:
value-type=
"float">
582 <table:table-cell office:
value-type=
"float" office:
value=
"40" calcext:
value-type=
"float">
587 <table:table-row table:
style-name=
"ro5">
588 <table:table-cell table:
formula=
"of:=DCOUNTA([.J1:.N10];"Weight";[.J13:.N15])" office:
value-type=
"float" office:
value=
"4" calcext:
value-type=
"float">
591 <table:table-cell office:
value-type=
"float" office:
value=
"4" calcext:
value-type=
"float">
594 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=[.A3]=[.B3]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
595 <text:p>PRAVDA
</text:p>
597 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string"><text:p><text:span text:
style-name=
"T4">DCOUNTA(
</text:span><text:span text:
style-name=
"T5">J1:N10
</text:span>;
"Weight
";
<text:span text:
style-name=
"T6">J13:N15
</text:span>)
</text:p>
599 <table:table-cell table:
number-columns-repeated=
"5"/>
600 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
601 <text:p>Betty
</text:p>
603 <table:table-cell office:
value-type=
"float" office:
value=
"4" calcext:
value-type=
"float">
606 <table:table-cell office:
value-type=
"float" office:
value=
"10" calcext:
value-type=
"float">
609 <table:table-cell office:
value-type=
"float" office:
value=
"1000" calcext:
value-type=
"float">
610 <text:p>1000</text:p>
612 <table:table-cell office:
value-type=
"float" office:
value=
"42" calcext:
value-type=
"float">
617 <table:table-row table:
style-name=
"ro5">
618 <table:table-cell table:
formula=
"of:=DCOUNTA([.J1:.N10];"Weight";[.J17:.N18])" office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
621 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
624 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=[.A4]=[.B4]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
625 <text:p>PRAVDA
</text:p>
627 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string"><text:p><text:span text:
style-name=
"T1">DCOUNTA
</text:span>(
<text:span text:
style-name=
"T5">J1:N10
</text:span>;
"Weight
";
<text:span text:
style-name=
"T6">J17:N18
</text:span>)
</text:p>
629 <table:table-cell table:
number-columns-repeated=
"5"/>
630 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
631 <text:p>Clara
</text:p>
633 <table:table-cell office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
636 <table:table-cell office:
value-type=
"float" office:
value=
"10" calcext:
value-type=
"float">
639 <table:table-cell office:
value-type=
"float" office:
value=
"300" calcext:
value-type=
"float">
642 <table:table-cell office:
value-type=
"float" office:
value=
"51" calcext:
value-type=
"float">
647 <table:table-row table:
style-name=
"ro5">
648 <table:table-cell table:
formula=
"of:=DCOUNTA([.J1:.N10];"Weight";[.J20:.N21])" office:
value-type=
"float" office:
value=
"5" calcext:
value-type=
"float">
651 <table:table-cell office:
value-type=
"float" office:
value=
"5" calcext:
value-type=
"float">
654 <table:table-cell table:
style-name=
"ce11" table:
formula=
"of:=[.A5]=[.B5]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
655 <text:p>PRAVDA
</text:p>
657 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string"><text:p><text:span text:
style-name=
"T1">DCOUNTA
</text:span>(
<text:span text:
style-name=
"T5">J1:N10
</text:span>;
"Weight
";
<text:span text:
style-name=
"T6">J20:N21
</text:span>)
</text:p>
659 <table:table-cell table:
number-columns-repeated=
"5"/>
660 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
661 <text:p>Daniel
</text:p>
663 <table:table-cell office:
value-type=
"float" office:
value=
"5" calcext:
value-type=
"float">
666 <table:table-cell office:
value-type=
"float" office:
value=
"11" calcext:
value-type=
"float">
669 <table:table-cell office:
value-type=
"float" office:
value=
"1200" calcext:
value-type=
"float">
670 <text:p>1200</text:p>
672 <table:table-cell office:
value-type=
"float" office:
value=
"48" calcext:
value-type=
"float">
677 <table:table-row table:
style-name=
"ro5">
678 <table:table-cell table:
formula=
"of:=DCOUNTA([.J1:.N10];"Weight";[.J56:.N57])" office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
681 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
684 <table:table-cell table:
style-name=
"ce12" table:
formula=
"of:=[.A6]=[.B6]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
685 <text:p>PRAVDA
</text:p>
687 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string"><text:p><text:span text:
style-name=
"T1">DCOUNTA
</text:span>(J1:N10;
"Weight
";J56:N57)
</text:p>
689 <table:table-cell table:
number-columns-repeated=
"5"/>
690 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
693 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
696 <table:table-cell office:
value-type=
"float" office:
value=
"8" calcext:
value-type=
"float">
699 <table:table-cell office:
value-type=
"float" office:
value=
"650" calcext:
value-type=
"float">
702 <table:table-cell office:
value-type=
"float" office:
value=
"33" calcext:
value-type=
"float">
707 <table:table-row table:
style-name=
"ro5">
708 <table:table-cell table:
formula=
"of:=DCOUNTA(database;"Weight";criteria)" office:
value-type=
"float" office:
value=
"9" calcext:
value-type=
"float">
711 <table:table-cell office:
value-type=
"float" office:
value=
"9" calcext:
value-type=
"float">
714 <table:table-cell table:
style-name=
"ce12" table:
formula=
"of:=[.A7]=[.B7]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
715 <text:p>PRAVDA
</text:p>
717 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
718 <text:p>DCOUNTA(database;
"Weight
";criteria)
</text:p>
720 <table:table-cell table:
number-columns-repeated=
"5"/>
721 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
722 <text:p>Frank
</text:p>
724 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
727 <table:table-cell office:
value-type=
"float" office:
value=
"7" calcext:
value-type=
"float">
730 <table:table-cell office:
value-type=
"float" office:
value=
"300" calcext:
value-type=
"float">
733 <table:table-cell office:
value-type=
"float" office:
value=
"42" calcext:
value-type=
"float">
738 <table:table-row table:
style-name=
"ro2">
739 <table:table-cell table:
formula=
"of:=DCOUNTA([.J1:.N10];;[.J41:.N42])" office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
742 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
745 <table:table-cell table:
style-name=
"ce29" table:
formula=
"of:=[.A8]=[.B8]" office:
value-type=
"boolean" office:
boolean-value=
"true" calcext:
value-type=
"boolean">
746 <text:p>TRUE
</text:p>
748 <table:table-cell table:
formula=
"of:=FORMULA([.A8])" office:
value-type=
"string" office:
string-value=
"=DCOUNTA(J1:N10,,J41:N42)" calcext:
value-type=
"string">
749 <text:p>=DCOUNTA(J1:N10,,J41:N42)
</text:p>
751 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
752 <text:p>Tdf#
13353</text:p>
754 <table:table-cell table:
number-columns-repeated=
"4"/>
755 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
756 <text:p>Greta
</text:p>
758 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
761 <table:table-cell office:
value-type=
"float" office:
value=
"7" calcext:
value-type=
"float">
764 <table:table-cell office:
value-type=
"float" office:
value=
"200" calcext:
value-type=
"float">
767 <table:table-cell office:
value-type=
"float" office:
value=
"36" calcext:
value-type=
"float">
772 <table:table-row table:
style-name=
"ro2">
773 <table:table-cell table:
number-columns-repeated=
"2"/>
774 <table:table-cell table:
style-name=
"ce13"/>
775 <table:table-cell table:
number-columns-repeated=
"6"/>
776 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
777 <text:p>Harry
</text:p>
779 <table:table-cell office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
782 <table:table-cell office:
value-type=
"float" office:
value=
"9" calcext:
value-type=
"float">
785 <table:table-cell office:
value-type=
"float" office:
value=
"1200" calcext:
value-type=
"float">
786 <text:p>1200</text:p>
788 <table:table-cell office:
value-type=
"float" office:
value=
"44" calcext:
value-type=
"float">
793 <table:table-row table:
style-name=
"ro2">
794 <table:table-cell table:
number-columns-repeated=
"2"/>
795 <table:table-cell table:
style-name=
"ce13"/>
796 <table:table-cell table:
number-columns-repeated=
"6"/>
797 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
798 <text:p>Irene
</text:p>
800 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
803 <table:table-cell office:
value-type=
"float" office:
value=
"8" calcext:
value-type=
"float">
806 <table:table-cell office:
value-type=
"float" office:
value=
"1000" calcext:
value-type=
"float">
807 <text:p>1000</text:p>
809 <table:table-cell office:
value-type=
"float" office:
value=
"42" calcext:
value-type=
"float">
814 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"2">
815 <table:table-cell table:
number-columns-repeated=
"2"/>
816 <table:table-cell table:
style-name=
"ce13"/>
817 <table:table-cell table:
number-columns-repeated=
"12"/>
819 <table:table-row table:
style-name=
"ro2">
820 <table:table-cell table:
number-columns-repeated=
"2"/>
821 <table:table-cell table:
style-name=
"ce13"/>
822 <table:table-cell table:
number-columns-repeated=
"6"/>
823 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
824 <text:p>Name
</text:p>
826 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
827 <text:p>Grade
</text:p>
829 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
832 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
833 <text:p>Distance to School
</text:p>
835 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
836 <text:p>Weight
</text:p>
840 <table:table-row table:
style-name=
"ro2">
841 <table:table-cell table:
number-columns-repeated=
"2"/>
842 <table:table-cell table:
style-name=
"ce13"/>
843 <table:table-cell table:
number-columns-repeated=
"8"/>
844 <table:table-cell office:
value-type=
"float" office:
value=
"9" calcext:
value-type=
"float">
847 <table:table-cell table:
number-columns-repeated=
"3"/>
849 <table:table-row table:
style-name=
"ro2">
850 <table:table-cell table:
number-columns-repeated=
"2"/>
851 <table:table-cell table:
style-name=
"ce13"/>
852 <table:table-cell table:
number-columns-repeated=
"8"/>
853 <table:table-cell office:
value-type=
"float" office:
value=
"10" calcext:
value-type=
"float">
856 <table:table-cell table:
number-columns-repeated=
"3"/>
858 <table:table-row table:
style-name=
"ro2">
859 <table:table-cell table:
number-columns-repeated=
"2"/>
860 <table:table-cell table:
style-name=
"ce13"/>
861 <table:table-cell table:
number-columns-repeated=
"12"/>
863 <table:table-row table:
style-name=
"ro2">
864 <table:table-cell table:
number-columns-repeated=
"2"/>
865 <table:table-cell table:
style-name=
"ce13"/>
866 <table:table-cell table:
number-columns-repeated=
"6"/>
867 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
868 <text:p>Name
</text:p>
870 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
871 <text:p>Grade
</text:p>
873 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
876 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
877 <text:p>Distance to School
</text:p>
879 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
880 <text:p>Weight
</text:p>
884 <table:table-row table:
style-name=
"ro2">
885 <table:table-cell table:
number-columns-repeated=
"2"/>
886 <table:table-cell table:
style-name=
"ce13"/>
887 <table:table-cell table:
number-columns-repeated=
"7"/>
888 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
891 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
892 <text:p>>7</text:p>
894 <table:table-cell table:
number-columns-repeated=
"3"/>
896 <table:table-row table:
style-name=
"ro2">
897 <table:table-cell table:
number-columns-repeated=
"2"/>
898 <table:table-cell table:
style-name=
"ce13"/>
899 <table:table-cell table:
number-columns-repeated=
"12"/>
901 <table:table-row table:
style-name=
"ro2">
902 <table:table-cell table:
number-columns-repeated=
"2"/>
903 <table:table-cell table:
style-name=
"ce13"/>
904 <table:table-cell table:
number-columns-repeated=
"6"/>
905 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
906 <text:p>Name
</text:p>
908 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
909 <text:p>Grade
</text:p>
911 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
914 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
915 <text:p>Distance to School
</text:p>
917 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
918 <text:p>Weight
</text:p>
922 <table:table-row table:
style-name=
"ro2">
923 <table:table-cell table:
number-columns-repeated=
"2"/>
924 <table:table-cell table:
style-name=
"ce13"/>
925 <table:table-cell table:
number-columns-repeated=
"6"/>
926 <table:table-cell table:
style-name=
"ce15" office:
value-type=
"string" calcext:
value-type=
"string">
927 <text:p>>=E
</text:p>
929 <table:table-cell table:
number-columns-repeated=
"5"/>
931 <table:table-row table:
style-name=
"ro2">
932 <table:table-cell table:
number-columns-repeated=
"2"/>
933 <table:table-cell table:
style-name=
"ce13"/>
934 <table:table-cell table:
number-columns-repeated=
"12"/>
936 <table:table-row table:
style-name=
"ro2">
937 <table:table-cell table:
number-columns-repeated=
"2"/>
938 <table:table-cell table:
style-name=
"ce13"/>
939 <table:table-cell table:
number-columns-repeated=
"6"/>
940 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
941 <text:p>Name
</text:p>
943 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
944 <text:p>Grade
</text:p>
946 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
949 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
950 <text:p>Distance to School
</text:p>
952 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
953 <text:p>Weight
</text:p>
957 <table:table-row table:
style-name=
"ro2">
958 <table:table-cell table:
number-columns-repeated=
"2"/>
959 <table:table-cell table:
style-name=
"ce13"/>
960 <table:table-cell table:
number-columns-repeated=
"6"/>
961 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
962 <text:p>Frank
</text:p>
964 <table:table-cell table:
number-columns-repeated=
"5"/>
966 <table:table-row table:
style-name=
"ro2">
967 <table:table-cell table:
number-columns-repeated=
"2"/>
968 <table:table-cell table:
style-name=
"ce13"/>
969 <table:table-cell table:
number-columns-repeated=
"12"/>
971 <table:table-row table:
style-name=
"ro2">
972 <table:table-cell table:
number-columns-repeated=
"2"/>
973 <table:table-cell table:
style-name=
"ce13"/>
974 <table:table-cell table:
number-columns-repeated=
"6"/>
975 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
976 <text:p>Name
</text:p>
978 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
979 <text:p>Grade
</text:p>
981 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
984 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
985 <text:p>Distance to School
</text:p>
987 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
988 <text:p>Weight
</text:p>
992 <table:table-row table:
style-name=
"ro2">
993 <table:table-cell table:
number-columns-repeated=
"2"/>
994 <table:table-cell table:
style-name=
"ce13"/>
995 <table:table-cell table:
number-columns-repeated=
"7"/>
996 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
999 <table:table-cell table:
number-columns-repeated=
"4"/>
1001 <table:table-row table:
style-name=
"ro2">
1002 <table:table-cell table:
number-columns-repeated=
"2"/>
1003 <table:table-cell table:
style-name=
"ce13"/>
1004 <table:table-cell table:
number-columns-repeated=
"7"/>
1005 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
1008 <table:table-cell table:
number-columns-repeated=
"4"/>
1010 <table:table-row table:
style-name=
"ro2">
1011 <table:table-cell table:
number-columns-repeated=
"2"/>
1012 <table:table-cell table:
style-name=
"ce13"/>
1013 <table:table-cell table:
number-columns-repeated=
"7"/>
1014 <table:table-cell office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
1017 <table:table-cell table:
number-columns-repeated=
"4"/>
1019 <table:table-row table:
style-name=
"ro2">
1020 <table:table-cell table:
number-columns-repeated=
"2"/>
1021 <table:table-cell table:
style-name=
"ce13"/>
1022 <table:table-cell table:
number-columns-repeated=
"7"/>
1023 <table:table-cell office:
value-type=
"float" office:
value=
"4" calcext:
value-type=
"float">
1026 <table:table-cell table:
number-columns-repeated=
"4"/>
1028 <table:table-row table:
style-name=
"ro2">
1029 <table:table-cell table:
number-columns-repeated=
"2"/>
1030 <table:table-cell table:
style-name=
"ce13"/>
1031 <table:table-cell table:
number-columns-repeated=
"7"/>
1032 <table:table-cell office:
value-type=
"float" office:
value=
"5" calcext:
value-type=
"float">
1035 <table:table-cell table:
number-columns-repeated=
"4"/>
1037 <table:table-row table:
style-name=
"ro2">
1038 <table:table-cell table:
number-columns-repeated=
"2"/>
1039 <table:table-cell table:
style-name=
"ce13"/>
1040 <table:table-cell table:
number-columns-repeated=
"12"/>
1042 <table:table-row table:
style-name=
"ro2">
1043 <table:table-cell table:
number-columns-repeated=
"2"/>
1044 <table:table-cell table:
style-name=
"ce13"/>
1045 <table:table-cell table:
number-columns-repeated=
"6"/>
1046 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1047 <text:p>Name
</text:p>
1049 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1050 <text:p>Grade
</text:p>
1052 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1053 <text:p>Age
</text:p>
1055 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1056 <text:p>Distance to School
</text:p>
1058 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1059 <text:p>Weight
</text:p>
1063 <table:table-row table:
style-name=
"ro2">
1064 <table:table-cell table:
number-columns-repeated=
"2"/>
1065 <table:table-cell table:
style-name=
"ce13"/>
1066 <table:table-cell table:
number-columns-repeated=
"7"/>
1067 <table:table-cell office:
value-type=
"float" office:
value=
"1" calcext:
value-type=
"float">
1070 <table:table-cell table:
number-columns-repeated=
"4"/>
1072 <table:table-row table:
style-name=
"ro2">
1073 <table:table-cell table:
number-columns-repeated=
"2"/>
1074 <table:table-cell table:
style-name=
"ce13"/>
1075 <table:table-cell table:
number-columns-repeated=
"7"/>
1076 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
1079 <table:table-cell table:
number-columns-repeated=
"4"/>
1081 <table:table-row table:
style-name=
"ro2">
1082 <table:table-cell table:
number-columns-repeated=
"2"/>
1083 <table:table-cell table:
style-name=
"ce13"/>
1084 <table:table-cell table:
number-columns-repeated=
"7"/>
1085 <table:table-cell office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
1088 <table:table-cell table:
number-columns-repeated=
"4"/>
1090 <table:table-row table:
style-name=
"ro2">
1091 <table:table-cell table:
number-columns-repeated=
"2"/>
1092 <table:table-cell table:
style-name=
"ce13"/>
1093 <table:table-cell table:
number-columns-repeated=
"12"/>
1095 <table:table-row table:
style-name=
"ro2">
1096 <table:table-cell table:
number-columns-repeated=
"2"/>
1097 <table:table-cell table:
style-name=
"ce13"/>
1098 <table:table-cell table:
number-columns-repeated=
"6"/>
1099 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1100 <text:p>Name
</text:p>
1102 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1103 <text:p>Grade
</text:p>
1105 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1106 <text:p>Age
</text:p>
1108 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1109 <text:p>Distance to School
</text:p>
1111 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1112 <text:p>Weight
</text:p>
1116 <table:table-row table:
style-name=
"ro2">
1117 <table:table-cell table:
number-columns-repeated=
"2"/>
1118 <table:table-cell table:
style-name=
"ce13"/>
1119 <table:table-cell table:
number-columns-repeated=
"7"/>
1120 <table:table-cell office:
value-type=
"float" office:
value=
"3" calcext:
value-type=
"float">
1123 <table:table-cell table:
number-columns-repeated=
"4"/>
1125 <table:table-row table:
style-name=
"ro2">
1126 <table:table-cell table:
number-columns-repeated=
"2"/>
1127 <table:table-cell table:
style-name=
"ce13"/>
1128 <table:table-cell table:
number-columns-repeated=
"12"/>
1130 <table:table-row table:
style-name=
"ro2">
1131 <table:table-cell table:
number-columns-repeated=
"2"/>
1132 <table:table-cell table:
style-name=
"ce13"/>
1133 <table:table-cell table:
number-columns-repeated=
"6"/>
1134 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1135 <text:p>Name
</text:p>
1137 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1138 <text:p>Grade
</text:p>
1140 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1141 <text:p>Age
</text:p>
1143 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1144 <text:p>Distance to School
</text:p>
1146 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1147 <text:p>Weight
</text:p>
1151 <table:table-row table:
style-name=
"ro2">
1152 <table:table-cell table:
number-columns-repeated=
"2"/>
1153 <table:table-cell table:
style-name=
"ce13"/>
1154 <table:table-cell table:
number-columns-repeated=
"8"/>
1155 <table:table-cell office:
value-type=
"float" office:
value=
"10" calcext:
value-type=
"float">
1158 <table:table-cell table:
number-columns-repeated=
"3"/>
1160 <table:table-row table:
style-name=
"ro2">
1161 <table:table-cell table:
number-columns-repeated=
"15"/>
1163 <table:table-row table:
style-name=
"ro2">
1164 <table:table-cell table:
number-columns-repeated=
"9"/>
1165 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1166 <text:p>Name
</text:p>
1168 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1169 <text:p>Grade
</text:p>
1171 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1172 <text:p>Age
</text:p>
1174 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1175 <text:p>Distance to School
</text:p>
1177 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1178 <text:p>Weight
</text:p>
1182 <table:table-row table:
style-name=
"ro2">
1183 <table:table-cell table:
number-columns-repeated=
"11"/>
1184 <table:table-cell office:
value-type=
"float" office:
value=
"7" calcext:
value-type=
"float">
1187 <table:table-cell table:
number-columns-repeated=
"3"/>
1189 <table:table-row table:
style-name=
"ro2">
1190 <table:table-cell table:
number-columns-repeated=
"15"/>
1192 <table:table-row table:
style-name=
"ro2">
1193 <table:table-cell table:
number-columns-repeated=
"9"/>
1194 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1195 <text:p>Name
</text:p>
1197 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1198 <text:p>Grade
</text:p>
1200 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1201 <text:p>Age
</text:p>
1203 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1204 <text:p>Distance to School
</text:p>
1206 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1207 <text:p>Weight
</text:p>
1211 <table:table-row table:
style-name=
"ro2">
1212 <table:table-cell table:
number-columns-repeated=
"11"/>
1213 <table:table-cell office:
value-type=
"float" office:
value=
"8" calcext:
value-type=
"float">
1216 <table:table-cell table:
number-columns-repeated=
"3"/>
1218 <table:table-row table:
style-name=
"ro2">
1219 <table:table-cell table:
number-columns-repeated=
"15"/>
1221 <table:table-row table:
style-name=
"ro2">
1222 <table:table-cell table:
number-columns-repeated=
"9"/>
1223 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1224 <text:p>Name
</text:p>
1226 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1227 <text:p>Grade
</text:p>
1229 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1230 <text:p>Age
</text:p>
1232 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1233 <text:p>Distance to School
</text:p>
1235 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1236 <text:p>Weight
</text:p>
1240 <table:table-row table:
style-name=
"ro2">
1241 <table:table-cell table:
number-columns-repeated=
"10"/>
1242 <table:table-cell office:
value-type=
"float" office:
value=
"2" calcext:
value-type=
"float">
1245 <table:table-cell table:
number-columns-repeated=
"4"/>
1247 <table:table-row table:
style-name=
"ro2">
1248 <table:table-cell table:
number-columns-repeated=
"15"/>
1250 <table:table-row table:
style-name=
"ro2">
1251 <table:table-cell table:
number-columns-repeated=
"9"/>
1252 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1253 <text:p>Name
</text:p>
1255 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1256 <text:p>Grade
</text:p>
1258 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1259 <text:p>Age
</text:p>
1261 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1262 <text:p>Distance to School
</text:p>
1264 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1265 <text:p>Weight
</text:p>
1269 <table:table-row table:
style-name=
"ro2">
1270 <table:table-cell table:
number-columns-repeated=
"11"/>
1271 <table:table-cell office:
value-type=
"float" office:
value=
"9" calcext:
value-type=
"float">
1274 <table:table-cell table:
number-columns-repeated=
"3"/>
1276 <table:table-row table:
style-name=
"ro2">
1277 <table:table-cell table:
number-columns-repeated=
"15"/>
1279 <table:table-row table:
style-name=
"ro2">
1280 <table:table-cell table:
number-columns-repeated=
"9"/>
1281 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1282 <text:p>Name
</text:p>
1284 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1285 <text:p>Grade
</text:p>
1287 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1288 <text:p>Age
</text:p>
1290 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1291 <text:p>Distance to School
</text:p>
1293 <table:table-cell table:
style-name=
"ce14" office:
value-type=
"string" calcext:
value-type=
"string">
1294 <text:p>Weight
</text:p>
1298 <table:table-row table:
style-name=
"ro2">
1299 <table:table-cell table:
number-columns-repeated=
"9"/>
1300 <table:table-cell office:
value-type=
"string" calcext:
value-type=
"string">
1301 <text:p>[E-F].*
</text:p>
1303 <table:table-cell table:
number-columns-repeated=
"5"/>
1305 <table:table-row table:
style-name=
"ro2">
1306 <table:table-cell table:
number-columns-repeated=
"15"/>
1308 <table:table-row table:
style-name=
"ro2">
1309 <table:table-cell table:
number-columns-repeated=
"9"/>
1310 <table:table-cell table:
style-name=
"ce16" office:
value-type=
"string" calcext:
value-type=
"string">
1311 <text:p>Name
</text:p>
1313 <table:table-cell table:
style-name=
"ce16" office:
value-type=
"string" calcext:
value-type=
"string">
1314 <text:p>Grade
</text:p>
1316 <table:table-cell table:
style-name=
"ce16" office:
value-type=
"string" calcext:
value-type=
"string">
1317 <text:p>Age
</text:p>
1319 <table:table-cell table:
style-name=
"ce16" office:
value-type=
"string" calcext:
value-type=
"string">
1320 <text:p>Distance to School
</text:p>
1322 <table:table-cell table:
style-name=
"ce16" office:
value-type=
"string" calcext:
value-type=
"string">
1323 <text:p>Weight
</text:p>
1325 <table:table-cell table:
style-name=
"ce17" office:
value-type=
"string" calcext:
value-type=
"string">
1326 <text:p>Age
</text:p>
1329 <table:table-row table:
style-name=
"ro2">
1330 <table:table-cell table:
number-columns-repeated=
"9"/>
1331 <table:table-cell table:
style-name=
"ce17" table:
number-columns-repeated=
"2"/>
1332 <table:table-cell table:
style-name=
"ce17" office:
value-type=
"string" calcext:
value-type=
"string">
1333 <text:p>>0</text:p>
1335 <table:table-cell table:
style-name=
"ce17" table:
number-columns-repeated=
"3"/>
1337 <table:table-row table:
style-name=
"ro2">
1338 <table:table-cell table:
number-columns-repeated=
"9"/>
1339 <table:table-cell table:
style-name=
"ce17" table:
number-columns-repeated=
"6"/>
1341 <table:table-row table:
style-name=
"ro2" table:
number-rows-repeated=
"1048514">
1342 <table:table-cell table:
number-columns-repeated=
"15"/>
1344 <table:table-row table:
style-name=
"ro2">
1345 <table:table-cell table:
number-columns-repeated=
"15"/>
1347 <calcext:conditional-formats>
1348 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C8:Sheet2.C42 Sheet2.C2:Sheet2.C5">
1349 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C2"/>
1350 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C2"/>
1351 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C2"/>
1352 </calcext:conditional-format>
1353 <calcext:conditional-format calcext:
target-range-address=
"Sheet2.C6:Sheet2.C7">
1354 <calcext:condition calcext:
apply-style-name=
"Default" calcext:
value=
"=""" calcext:
base-cell-address=
"Sheet2.C6"/>
1355 <calcext:condition calcext:
apply-style-name=
"Untitled1" calcext:
value=
"=0" calcext:
base-cell-address=
"Sheet2.C6"/>
1356 <calcext:condition calcext:
apply-style-name=
"Untitled2" calcext:
value=
"=1" calcext:
base-cell-address=
"Sheet2.C6"/>
1357 </calcext:conditional-format>
1358 </calcext:conditional-formats>
1360 <table:table table:
name=
"'file:///home/zdenek/lodev/libreoffice/sc/qa/unit/data/functions/fods/function_based_test_Example.fods/function_based_test_Example_reference.fods'#Sheet2" table:
print=
"false" table:
style-name=
"ta_extref">
1361 <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"/>
1362 <table:table-column table:
number-columns-repeated=
"8"/>
1363 <table:table-row table:
number-rows-repeated=
"2">
1364 <table:table-cell table:
number-columns-repeated=
"8"/>
1367 <table:table-cell table:
number-columns-repeated=
"7"/>
1368 <table:table-cell table:
style-name=
"ce1" office:
value-type=
"float" office:
value=
"4">
1373 <table:named-expressions>
1374 <table:named-range table:
name=
"criteria" table:
base-cell-address=
"$Sheet2.$J$59" table:
cell-range-address=
"$Sheet2.$J$59:.$O$61"/>
1375 <table:named-range table:
name=
"database" table:
base-cell-address=
"$Sheet2.$J$1" table:
cell-range-address=
"$Sheet2.$J$1:.$N$10"/>
1376 </table:named-expressions>
1377 </office:spreadsheet>