1 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
3 %% This is the header of a LaTeX2e file exported from Gnumeric. %%
5 %% This file can be compiled as it stands or included in another %%
6 %% LaTeX document. The table is based on the longtable package so %%
7 %% the longtable options (headers, footers...) can be set in the %%
8 %% preamble section below (see PRAMBLE). %%
10 %% To include the file in another, the following two lines must be %%
11 %% in the including file: %%
12 %% \def\inputGnumericTable{} %%
13 %% at the beginning of the file and: %%
14 %% \input{name-of-this-file.tex} %%
15 %% where the table is to be placed. Note also that the including %%
16 %% file must use the following packages for the table to be %%
17 %% rendered correctly: %%
18 %% \usepackage[latin1]{inputenc} %%
19 %% \usepackage{color} %%
20 %% \usepackage{array} %%
21 %% \usepackage{longtable} %%
22 %% \usepackage{calc} %%
23 %% \usepackage{multirow} %%
24 %% \usepackage{hhline} %%
25 %% \usepackage{ifthen} %%
26 %% optionally (for landscape tables embedded in another document): %%
27 %% \usepackage{lscape} %%
29 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
33 %% This section checks if we are begin input into another file or %%
34 %% the file will be compiled alone. First use a macro taken from %%
35 %% the TeXbook ex 7.7 (suggestion of Han-Wen Nienhuys). %%
36 \def\ifundefined#1{\expandafter\ifx\csname#1\endcsname\relax}
39 %% Check for the \def token for inputed files. If it is not %%
40 %% defined, the file will be processed as a standalone and the %%
41 %% preamble will be used. %%
42 \ifundefined{inputGnumericTable}
44 %% We must be able to close or not the document at the end. %%
45 \def\gnumericTableEnd{\end{document}}
48 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
50 %% This is the PREAMBLE. Change these values to get the right %%
51 %% paper size and other niceties. %%
53 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
58 \usepackage[latin1]{inputenc}
62 \usepackage{longtable}
71 %% End of the preamble for the standalone. The next section is for %%
72 %% documents which are included into other LaTeX2e files. %%
75 %% We are not a stand alone document. For a regular table, we will %%
76 %% have no preamble and only define the closing to mean nothing. %%
77 \def\gnumericTableEnd{}
79 %% If we want landscape mode in an embedded document, comment out %%
80 %% the line above and uncomment the two below. The table will %%
81 %% begin on a new page and run in landscape mode. %%
82 % \def\gnumericTableEnd{\end{landscape}}
86 %% End of the else clause for this file being \input. %%
89 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
91 %% The rest is the gnumeric table, except for the closing %%
92 %% statement. Changes below will alter the table's appearance. %%
94 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
96 \providecommand{\gnumericmathit}[1]{#1}
97 %% Uncomment the next line if you would like your numbers to be in %%
98 %% italics if they are italizised in the gnumeric table. %%
99 %\renewcommand{\gnumericmathit}[1]{\mathit{#1}}
100 \providecommand{\gnumericPB}[1]%
101 {\let\gnumericTemp=\\#1\let\\=\gnumericTemp\hspace{0pt}}
102 \ifundefined{gnumericTableWidthDefined}
103 \newlength{\gnumericTableWidth}
104 \newlength{\gnumericTableWidthComplete}
105 \newlength{\gnumericMultiRowLength}
106 \global\def\gnumericTableWidthDefined{}
108 %% The following setting protects this code from babel shorthands. %%
109 \ifthenelse{\isundefined{\languageshorthands}}{}{\languageshorthands{english}}
110 %% The default table format retains the relative column widths of %%
111 %% gnumeric. They can easily be changed to c, r or l. In that case %%
112 %% you may want to comment out the next line and uncomment the one %%
114 \providecommand\gnumbox{\makebox[0pt]}
115 %%\providecommand\gnumbox[1][]{\makebox}
117 %% to adjust positions in multirow situations %%
118 \setlength{\bigstrutjot}{\jot}
119 \setlength{\extrarowheight}{\doublerulesep}
121 %% The \setlongtables command keeps column widths the same across %%
122 %% pages. Simply comment out next line for varying column widths. %%
125 \setlength\gnumericTableWidth{%
131 \def\gumericNumCols{4}
132 \setlength\gnumericTableWidthComplete{\gnumericTableWidth+%
133 \tabcolsep*\gumericNumCols*2+\arrayrulewidth*\gumericNumCols}
134 \ifthenelse{\lengthtest{\gnumericTableWidthComplete > \linewidth}}%
135 {\def\gnumericScale{\ratio{\linewidth-%
136 \tabcolsep*\gumericNumCols*2-%
137 \arrayrulewidth*\gumericNumCols}%
138 {\gnumericTableWidth}}}%
139 {\def\gnumericScale{1}}
141 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
143 %% The following are the widths of the various columns. We are %%
144 %% defining them here because then they are easier to change. %%
145 %% Depending on the cell formats we may use them more than once. %%
147 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
149 \ifthenelse{\isundefined{\gnumericColB}}{\newlength{\gnumericColB}}{}\settowidth{\gnumericColB}{\begin{tabular}{@{}p{100pt*\gnumericScale}@{}}x\end{tabular}}
150 \ifthenelse{\isundefined{\gnumericColC}}{\newlength{\gnumericColC}}{}\settowidth{\gnumericColC}{\begin{tabular}{@{}p{53pt*\gnumericScale}@{}}x\end{tabular}}
151 \ifthenelse{\isundefined{\gnumericColD}}{\newlength{\gnumericColD}}{}\settowidth{\gnumericColD}{\begin{tabular}{@{}p{40pt*\gnumericScale}@{}}x\end{tabular}}
152 \ifthenelse{\isundefined{\gnumericColE}}{\newlength{\gnumericColE}}{}\settowidth{\gnumericColE}{\begin{tabular}{@{}p{53pt*\gnumericScale}@{}}x\end{tabular}}
154 \begin{longtable}[c]{%
161 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
162 %% The longtable options. (Caption, headers... see Goosens, p.124) %%
163 % \caption{The Table Caption.} \\ %
164 % \hline % Across the top of the table.
165 %% The rest of these options are table rows which are placed on %%
166 %% the first, last or every page. Use \multicolumn if you want. %%
168 %% Header for the first page. %%
169 % \multicolumn{4}{c}{The First Header} \\ \hline
170 % \multicolumn{1}{c}{colTag} %Column 1
171 % &\multicolumn{1}{c}{colTag} %Column 2
172 % &\multicolumn{1}{c}{colTag} %Column 3
173 % &\multicolumn{1}{c}{colTag} \\ \hline %Last column
176 %% The running header definition. %%
178 % \multicolumn{4}{l}{\ldots\small\slshape continued} \\ \hline
179 % \multicolumn{1}{c}{colTag} %Column 1
180 % &\multicolumn{1}{c}{colTag} %Column 2
181 % &\multicolumn{1}{c}{colTag} %Column 3
182 % &\multicolumn{1}{c}{colTag} \\ \hline %Last column
185 %% The running footer definition. %%
187 % \multicolumn{4}{r}{\small\slshape continued\ldots} \\
190 %% The ending footer definition. %%
191 % \multicolumn{4}{c}{That's all folks} \\ \hline
193 %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
196 \multicolumn{4}{|p{ \gnumericColB+%
201 {\gnumericPB{\centering}\gnumbox{{\color[rgb]{1.00,0.00,0.00} Long spreadsheet for LyX import}}}
203 \multicolumn{4}{|p{ \gnumericColB+%
208 {\gnumericPB{\centering}\gnumbox{{\color[rgb]{1.00,0.00,0.00} \textit{longsheet.gnumeric}}}}
211 \multicolumn{1}{|p{\gnumericColB}|}%
212 {\gnumericPB{\raggedright}\gnumbox[l]{{\color[rgb]{0.00,0.00,0.50} \textbf{Item}}}}
213 &\multicolumn{1}{p{\gnumericColC}|}%
214 {\gnumericPB{\raggedleft}\gnumbox[r]{{\color[rgb]{0.00,0.00,0.50} \textbf{Price}}}}
215 &\multicolumn{1}{p{\gnumericColD}|}%
216 {\gnumericPB{\raggedleft}\gnumbox[r]{{\color[rgb]{0.00,0.00,0.50} \textbf{\#}}}}
217 &\multicolumn{1}{p{\gnumericColE}|}%
218 {\gnumericPB{\raggedleft}\gnumbox[r]{{\color[rgb]{0.00,0.00,0.50} \textbf{Total}}}}
221 \multicolumn{1}{|p{\gnumericColB}}%
222 {\gnumericPB{\raggedright}\gnumbox[l]{{\color[rgb]{0.00,0.50,0.00} \textit{Stuff}}}}
225 &\multicolumn{1}{p{\gnumericColE}|}%
228 \multicolumn{1}{|p{\gnumericColB}}%
229 {\gnumericPB{\raggedright}\gnumbox[l]{scissors}}
230 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
231 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
232 &\multicolumn{1}{p{\gnumericColE}|}%
233 {\gnumericPB{\raggedleft}\gnumbox[r]{240}}
235 \multicolumn{1}{|p{\gnumericColB}}%
236 {\gnumericPB{\raggedright}\gnumbox[l]{pens}}
237 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
238 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
239 &\multicolumn{1}{p{\gnumericColE}|}%
240 {\gnumericPB{\raggedleft}\gnumbox[r]{30}}
242 \multicolumn{1}{|p{\gnumericColB}}%
243 {\gnumericPB{\raggedright}\gnumbox[l]{pencils}}
244 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
245 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
246 &\multicolumn{1}{p{\gnumericColE}|}%
247 {\gnumericPB{\raggedleft}\gnumbox[r]{30}}
249 \multicolumn{1}{|p{\gnumericColB}}%
253 &\multicolumn{1}{p{\gnumericColE}|}%
256 \multicolumn{1}{|p{\gnumericColB}}%
257 {\gnumericPB{\raggedright}\gnumbox[l]{radio}}
258 &\gnumericPB{\raggedleft}\gnumbox[r]{105}
259 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
260 &\multicolumn{1}{p{\gnumericColE}|}%
261 {\gnumericPB{\raggedleft}\gnumbox[r]{105}}
263 \multicolumn{1}{|p{\gnumericColB}}%
264 {\gnumericPB{\raggedright}\gnumbox[l]{camera}}
265 &\gnumericPB{\raggedleft}\gnumbox[r]{1200}
266 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
267 &\multicolumn{1}{p{\gnumericColE}|}%
268 {\gnumericPB{\raggedleft}\gnumbox[r]{2400}}
270 \multicolumn{1}{|p{\gnumericColB}}%
271 {\gnumericPB{\raggedright}\gnumbox[l]{telephoto lens}}
272 &\gnumericPB{\raggedleft}\gnumbox[r]{2000}
273 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
274 &\multicolumn{1}{p{\gnumericColE}|}%
275 {\gnumericPB{\raggedleft}\gnumbox[r]{2000}}
277 \multicolumn{1}{|p{\gnumericColB}}%
278 {\gnumericPB{\raggedright}\gnumbox[l]{macro lens}}
279 &\gnumericPB{\raggedleft}\gnumbox[r]{300}
280 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
281 &\multicolumn{1}{p{\gnumericColE}|}%
282 {\gnumericPB{\raggedleft}\gnumbox[r]{600}}
284 \multicolumn{1}{|p{\gnumericColB}}%
285 {\gnumericPB{\raggedright}\gnumbox[l]{flash}}
286 &\gnumericPB{\raggedleft}\gnumbox[r]{150}
287 &\gnumericPB{\raggedleft}\gnumbox[r]{4}
288 &\multicolumn{1}{p{\gnumericColE}|}%
289 {\gnumericPB{\raggedleft}\gnumbox[r]{600}}
291 \multicolumn{1}{|p{\gnumericColB}}%
292 {\gnumericPB{\raggedright}\gnumbox[l]{memory card 8G}}
293 &\gnumericPB{\raggedleft}\gnumbox[r]{40}
294 &\gnumericPB{\raggedleft}\gnumbox[r]{16}
295 &\multicolumn{1}{p{\gnumericColE}|}%
296 {\gnumericPB{\raggedleft}\gnumbox[r]{640}}
298 \multicolumn{1}{|p{\gnumericColB}}%
302 &\multicolumn{1}{p{\gnumericColE}|}%
305 \multicolumn{1}{|p{\gnumericColB}}%
306 {\gnumericPB{\raggedright}\gnumbox[l]{computer}}
307 &\gnumericPB{\raggedleft}\gnumbox[r]{300}
308 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
309 &\multicolumn{1}{p{\gnumericColE}|}%
310 {\gnumericPB{\raggedleft}\gnumbox[r]{9000}}
312 \multicolumn{1}{|p{\gnumericColB}}%
313 {\gnumericPB{\raggedright}\gnumbox[l]{os}}
314 &\gnumericPB{\raggedleft}\gnumbox[r]{0}
315 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
316 &\multicolumn{1}{p{\gnumericColE}|}%
317 {\gnumericPB{\raggedleft}\gnumbox[r]{0}}
319 \multicolumn{1}{|p{\gnumericColB}}%
320 {\gnumericPB{\raggedright}\gnumbox[l]{sw packages}}
321 &\gnumericPB{\raggedleft}\gnumbox[r]{0}
322 &\gnumericPB{\raggedleft}\gnumbox[r]{2600}
323 &\multicolumn{1}{p{\gnumericColE}|}%
324 {\gnumericPB{\raggedleft}\gnumbox[r]{0}}
326 \multicolumn{1}{|p{\gnumericColB}}%
327 {\gnumericPB{\raggedright}\gnumbox[l]{sw docs}}
328 &\gnumericPB{\raggedleft}\gnumbox[r]{0}
329 &\gnumericPB{\raggedleft}\gnumbox[r]{2600}
330 &\multicolumn{1}{p{\gnumericColE}|}%
331 {\gnumericPB{\raggedleft}\gnumbox[r]{0}}
333 \multicolumn{1}{|p{\gnumericColB}}%
334 {\gnumericPB{\raggedright}\gnumbox[l]{license mgmt}}
335 &\gnumericPB{\raggedleft}\gnumbox[r]{0}
336 &\gnumericPB{\raggedleft}\gnumbox[r]{0}
337 &\multicolumn{1}{p{\gnumericColE}|}%
338 {\gnumericPB{\raggedleft}\gnumbox[r]{0}}
340 \multicolumn{1}{|p{\gnumericColB}}%
341 {\gnumericPB{\raggedright}\gnumbox[l]{sw upgrades}}
342 &\gnumericPB{\raggedleft}\gnumbox[r]{0}
343 &\gnumericPB{\raggedleft}\gnumbox[r]{2600}
344 &\multicolumn{1}{p{\gnumericColE}|}%
345 {\gnumericPB{\raggedleft}\gnumbox[r]{0}}
347 \multicolumn{1}{|p{\gnumericColB}}%
351 &\multicolumn{1}{p{\gnumericColE}|}%
354 \multicolumn{1}{|p{\gnumericColB}}%
355 {\gnumericPB{\raggedright}\gnumbox[l]{{\color[rgb]{0.00,0.50,0.00} \textit{Clothes}}}}
358 &\multicolumn{1}{p{\gnumericColE}|}%
361 \multicolumn{1}{|p{\gnumericColB}}%
362 {\gnumericPB{\raggedright}\gnumbox[l]{socks}}
363 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
364 &\gnumericPB{\raggedleft}\gnumbox[r]{14}
365 &\multicolumn{1}{p{\gnumericColE}|}%
366 {\gnumericPB{\raggedleft}\gnumbox[r]{14}}
368 \multicolumn{1}{|p{\gnumericColB}}%
369 {\gnumericPB{\raggedright}\gnumbox[l]{hats}}
370 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
371 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
372 &\multicolumn{1}{p{\gnumericColE}|}%
373 {\gnumericPB{\raggedleft}\gnumbox[r]{24}}
375 \multicolumn{1}{|p{\gnumericColB}}%
376 {\gnumericPB{\raggedright}\gnumbox[l]{jeans}}
377 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
378 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
379 &\multicolumn{1}{p{\gnumericColE}|}%
380 {\gnumericPB{\raggedleft}\gnumbox[r]{60}}
382 \multicolumn{1}{|p{\gnumericColB}}%
383 {\gnumericPB{\raggedright}\gnumbox[l]{black shoes}}
384 &\gnumericPB{\raggedleft}\gnumbox[r]{45}
385 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
386 &\multicolumn{1}{p{\gnumericColE}|}%
387 {\gnumericPB{\raggedleft}\gnumbox[r]{90}}
389 \multicolumn{1}{|p{\gnumericColB}}%
390 {\gnumericPB{\raggedright}\gnumbox[l]{brown shoes}}
391 &\gnumericPB{\raggedleft}\gnumbox[r]{42}
392 &\gnumericPB{\raggedleft}\gnumbox[r]{6}
393 &\multicolumn{1}{p{\gnumericColE}|}%
394 {\gnumericPB{\raggedleft}\gnumbox[r]{252}}
396 \multicolumn{1}{|p{\gnumericColB}}%
397 {\gnumericPB{\raggedright}\gnumbox[l]{jacket}}
398 &\gnumericPB{\raggedleft}\gnumbox[r]{50}
399 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
400 &\multicolumn{1}{p{\gnumericColE}|}%
401 {\gnumericPB{\raggedleft}\gnumbox[r]{50}}
403 \multicolumn{1}{|p{\gnumericColB}}%
404 {\gnumericPB{\raggedright}\gnumbox[l]{shirts}}
405 &\gnumericPB{\raggedleft}\gnumbox[r]{22}
406 &\gnumericPB{\raggedleft}\gnumbox[r]{14}
407 &\multicolumn{1}{p{\gnumericColE}|}%
408 {\gnumericPB{\raggedleft}\gnumbox[r]{308}}
410 \multicolumn{1}{|p{\gnumericColB}}%
411 {\gnumericPB{\raggedright}\gnumbox[l]{t-shirts}}
412 &\gnumericPB{\raggedleft}\gnumbox[r]{5}
413 &\gnumericPB{\raggedleft}\gnumbox[r]{6}
414 &\multicolumn{1}{p{\gnumericColE}|}%
415 {\gnumericPB{\raggedleft}\gnumbox[r]{30}}
417 \multicolumn{1}{|p{\gnumericColB}}%
418 {\gnumericPB{\raggedright}\gnumbox[l]{funny t-shirts}}
419 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
420 &\gnumericPB{\raggedleft}\gnumbox[r]{4}
421 &\multicolumn{1}{p{\gnumericColE}|}%
422 {\gnumericPB{\raggedleft}\gnumbox[r]{32}}
424 \multicolumn{1}{|p{\gnumericColB}}%
428 &\multicolumn{1}{p{\gnumericColE}|}%
431 \multicolumn{1}{|p{\gnumericColB}}%
435 &\multicolumn{1}{p{\gnumericColE}|}%
438 \multicolumn{1}{|p{\gnumericColB}}%
439 {\gnumericPB{\raggedright}\gnumbox[l]{{\color[rgb]{0.00,0.50,0.00} \textit{Food}}}}
442 &\multicolumn{1}{p{\gnumericColE}|}%
445 \multicolumn{1}{|p{\gnumericColB}}%
446 {\gnumericPB{\raggedright}\gnumbox[l]{cheese}}
447 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
448 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
449 &\multicolumn{1}{p{\gnumericColE}|}%
450 {\gnumericPB{\raggedleft}\gnumbox[r]{9}}
452 \multicolumn{1}{|p{\gnumericColB}}%
453 {\gnumericPB{\raggedright}\gnumbox[l]{beer}}
454 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
455 &\gnumericPB{\raggedleft}\gnumbox[r]{48}
456 &\multicolumn{1}{p{\gnumericColE}|}%
457 {\gnumericPB{\raggedleft}\gnumbox[r]{48}}
459 \multicolumn{1}{|p{\gnumericColB}}%
460 {\gnumericPB{\raggedright}\gnumbox[l]{bread}}
461 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
462 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
463 &\multicolumn{1}{p{\gnumericColE}|}%
464 {\gnumericPB{\raggedleft}\gnumbox[r]{3}}
466 \multicolumn{1}{|p{\gnumericColB}}%
467 {\gnumericPB{\raggedright}\gnumbox[l]{butter}}
468 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
469 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
470 &\multicolumn{1}{p{\gnumericColE}|}%
471 {\gnumericPB{\raggedleft}\gnumbox[r]{3}}
473 \multicolumn{1}{|p{\gnumericColB}}%
474 {\gnumericPB{\raggedright}\gnumbox[l]{garlic}}
475 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
476 &\gnumericPB{\raggedleft}\gnumbox[r]{5}
477 &\multicolumn{1}{p{\gnumericColE}|}%
478 {\gnumericPB{\raggedleft}\gnumbox[r]{10}}
480 \multicolumn{1}{|p{\gnumericColB}}%
481 {\gnumericPB{\raggedright}\gnumbox[l]{meatballs}}
482 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
483 &\gnumericPB{\raggedleft}\gnumbox[r]{50}
484 &\multicolumn{1}{p{\gnumericColE}|}%
485 {\gnumericPB{\raggedleft}\gnumbox[r]{50}}
487 \multicolumn{1}{|p{\gnumericColB}}%
488 {\gnumericPB{\raggedright}\gnumbox[l]{mustard}}
489 &\gnumericPB{\raggedleft}\gnumbox[r]{13}
490 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
491 &\multicolumn{1}{p{\gnumericColE}|}%
492 {\gnumericPB{\raggedleft}\gnumbox[r]{13}}
494 \multicolumn{1}{|p{\gnumericColB}}%
495 {\gnumericPB{\raggedright}\gnumbox[l]{ketchup}}
496 &\gnumericPB{\raggedleft}\gnumbox[r]{11}
497 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
498 &\multicolumn{1}{p{\gnumericColE}|}%
499 {\gnumericPB{\raggedleft}\gnumbox[r]{11}}
501 \multicolumn{1}{|p{\gnumericColB}}%
502 {\gnumericPB{\raggedright}\gnumbox[l]{salt}}
503 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
504 &\gnumericPB{\raggedleft}\gnumbox[r]{6}
505 &\multicolumn{1}{p{\gnumericColE}|}%
506 {\gnumericPB{\raggedleft}\gnumbox[r]{12}}
508 \multicolumn{1}{|p{\gnumericColB}}%
509 {\gnumericPB{\raggedright}\gnumbox[l]{pepper}}
510 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
511 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
512 &\multicolumn{1}{p{\gnumericColE}|}%
513 {\gnumericPB{\raggedleft}\gnumbox[r]{6}}
515 \multicolumn{1}{|p{\gnumericColB}}%
519 &\multicolumn{1}{p{\gnumericColE}|}%
522 \multicolumn{1}{|p{\gnumericColB}}%
523 {\gnumericPB{\raggedright}\gnumbox[l]{{\color[rgb]{0.00,0.50,0.00} \textit{Animals}}}}
526 &\multicolumn{1}{p{\gnumericColE}|}%
529 \multicolumn{1}{|p{\gnumericColB}}%
530 {\gnumericPB{\raggedright}\gnumbox[l]{cows}}
531 &\gnumericPB{\raggedleft}\gnumbox[r]{500}
532 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
533 &\multicolumn{1}{p{\gnumericColE}|}%
534 {\gnumericPB{\raggedleft}\gnumbox[r]{15000}}
536 \multicolumn{1}{|p{\gnumericColB}}%
537 {\gnumericPB{\raggedright}\gnumbox[l]{sheep}}
538 &\gnumericPB{\raggedleft}\gnumbox[r]{300}
539 &\gnumericPB{\raggedleft}\gnumbox[r]{800}
540 &\multicolumn{1}{p{\gnumericColE}|}%
541 {\gnumericPB{\raggedleft}\gnumbox[r]{240000}}
543 \multicolumn{1}{|p{\gnumericColB}}%
544 {\gnumericPB{\raggedright}\gnumbox[l]{dogs}}
545 &\gnumericPB{\raggedleft}\gnumbox[r]{250}
546 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
547 &\multicolumn{1}{p{\gnumericColE}|}%
548 {\gnumericPB{\raggedleft}\gnumbox[r]{2000}}
550 \multicolumn{1}{|p{\gnumericColB}}%
551 {\gnumericPB{\raggedright}\gnumbox[l]{cats}}
552 &\gnumericPB{\raggedleft}\gnumbox[r]{5}
553 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
554 &\multicolumn{1}{p{\gnumericColE}|}%
555 {\gnumericPB{\raggedleft}\gnumbox[r]{15}}
557 \multicolumn{1}{|p{\gnumericColB}}%
558 {\gnumericPB{\raggedright}\gnumbox[l]{goats}}
559 &\gnumericPB{\raggedleft}\gnumbox[r]{350}
560 &\gnumericPB{\raggedleft}\gnumbox[r]{60}
561 &\multicolumn{1}{p{\gnumericColE}|}%
562 {\gnumericPB{\raggedleft}\gnumbox[r]{21000}}
564 \multicolumn{1}{|p{\gnumericColB}}%
565 {\gnumericPB{\raggedright}\gnumbox[l]{horse}}
566 &\gnumericPB{\raggedleft}\gnumbox[r]{660}
567 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
568 &\multicolumn{1}{p{\gnumericColE}|}%
569 {\gnumericPB{\raggedleft}\gnumbox[r]{660}}
571 \multicolumn{1}{|p{\gnumericColB}}%
572 {\gnumericPB{\raggedright}\gnumbox[l]{pigs}}
573 &\gnumericPB{\raggedleft}\gnumbox[r]{400}
574 &\gnumericPB{\raggedleft}\gnumbox[r]{200}
575 &\multicolumn{1}{p{\gnumericColE}|}%
576 {\gnumericPB{\raggedleft}\gnumbox[r]{80000}}
578 \multicolumn{1}{|p{\gnumericColB}}%
579 {\gnumericPB{\raggedright}\gnumbox[l]{bears}}
580 &\gnumericPB{\raggedleft}\gnumbox[r]{1800}
581 &\gnumericPB{\raggedleft}\gnumbox[r]{4}
582 &\multicolumn{1}{p{\gnumericColE}|}%
583 {\gnumericPB{\raggedleft}\gnumbox[r]{7200}}
585 \multicolumn{1}{|p{\gnumericColB}}%
586 {\gnumericPB{\raggedright}\gnumbox[l]{bears (polar)}}
587 &\gnumericPB{\raggedleft}\gnumbox[r]{5000}
588 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
589 &\multicolumn{1}{p{\gnumericColE}|}%
590 {\gnumericPB{\raggedleft}\gnumbox[r]{10000}}
592 \multicolumn{1}{|p{\gnumericColB}}%
593 {\gnumericPB{\raggedright}\gnumbox[l]{giraffes}}
594 &\gnumericPB{\raggedleft}\gnumbox[r]{4500}
595 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
596 &\multicolumn{1}{p{\gnumericColE}|}%
597 {\gnumericPB{\raggedleft}\gnumbox[r]{9000}}
599 \multicolumn{1}{|p{\gnumericColB}}%
600 {\gnumericPB{\raggedright}\gnumbox[l]{hippos}}
601 &\gnumericPB{\raggedleft}\gnumbox[r]{12000}
602 &\gnumericPB{\raggedleft}\gnumbox[r]{16}
603 &\multicolumn{1}{p{\gnumericColE}|}%
604 {\gnumericPB{\raggedleft}\gnumbox[r]{192000}}
606 \multicolumn{1}{|p{\gnumericColB}}%
607 {\gnumericPB{\raggedright}\gnumbox[l]{camels}}
608 &\gnumericPB{\raggedleft}\gnumbox[r]{800}
609 &\gnumericPB{\raggedleft}\gnumbox[r]{12}
610 &\multicolumn{1}{p{\gnumericColE}|}%
611 {\gnumericPB{\raggedleft}\gnumbox[r]{9600}}
613 \multicolumn{1}{|p{\gnumericColB}}%
614 {\gnumericPB{\raggedright}\gnumbox[l]{squirrels}}
615 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
616 &\gnumericPB{\raggedleft}\gnumbox[r]{16}
617 &\multicolumn{1}{p{\gnumericColE}|}%
618 {\gnumericPB{\raggedleft}\gnumbox[r]{128}}
620 \multicolumn{1}{|p{\gnumericColB}}%
621 {\gnumericPB{\raggedright}\gnumbox[l]{mice}}
622 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
623 &\gnumericPB{\raggedleft}\gnumbox[r]{45}
624 &\multicolumn{1}{p{\gnumericColE}|}%
625 {\gnumericPB{\raggedleft}\gnumbox[r]{45}}
627 \multicolumn{1}{|p{\gnumericColB}}%
628 {\gnumericPB{\raggedright}\gnumbox[l]{mice (white)}}
629 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
630 &\gnumericPB{\raggedleft}\gnumbox[r]{133}
631 &\multicolumn{1}{p{\gnumericColE}|}%
632 {\gnumericPB{\raggedleft}\gnumbox[r]{266}}
634 \multicolumn{1}{|p{\gnumericColB}}%
635 {\gnumericPB{\raggedright}\gnumbox[l]{rats}}
636 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
637 &\gnumericPB{\raggedleft}\gnumbox[r]{20}
638 &\multicolumn{1}{p{\gnumericColE}|}%
639 {\gnumericPB{\raggedleft}\gnumbox[r]{40}}
641 \multicolumn{1}{|p{\gnumericColB}}%
642 {\gnumericPB{\raggedright}\gnumbox[l]{elephants}}
643 &\gnumericPB{\raggedleft}\gnumbox[r]{10000}
644 &\gnumericPB{\raggedleft}\gnumbox[r]{20}
645 &\multicolumn{1}{p{\gnumericColE}|}%
646 {\gnumericPB{\raggedleft}\gnumbox[r]{200000}}
648 \multicolumn{1}{|p{\gnumericColB}}%
649 {\gnumericPB{\raggedright}\gnumbox[l]{crocodile (s)}}
650 &\gnumericPB{\raggedleft}\gnumbox[r]{500}
651 &\gnumericPB{\raggedleft}\gnumbox[r]{18}
652 &\multicolumn{1}{p{\gnumericColE}|}%
653 {\gnumericPB{\raggedleft}\gnumbox[r]{9000}}
655 \multicolumn{1}{|p{\gnumericColB}}%
656 {\gnumericPB{\raggedright}\gnumbox[l]{crocodile (m)}}
657 &\gnumericPB{\raggedleft}\gnumbox[r]{1500}
658 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
659 &\multicolumn{1}{p{\gnumericColE}|}%
660 {\gnumericPB{\raggedleft}\gnumbox[r]{12000}}
662 \multicolumn{1}{|p{\gnumericColB}}%
663 {\gnumericPB{\raggedright}\gnumbox[l]{crocodile (l)}}
664 &\gnumericPB{\raggedleft}\gnumbox[r]{3500}
665 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
666 &\multicolumn{1}{p{\gnumericColE}|}%
667 {\gnumericPB{\raggedleft}\gnumbox[r]{7000}}
669 \multicolumn{1}{|p{\gnumericColB}}%
670 {\gnumericPB{\raggedright}\gnumbox[l]{crocodile (xl)}}
671 &\gnumericPB{\raggedleft}\gnumbox[r]{8000}
672 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
673 &\multicolumn{1}{p{\gnumericColE}|}%
674 {\gnumericPB{\raggedleft}\gnumbox[r]{8000}}
676 \multicolumn{1}{|p{\gnumericColB}}%
677 {\gnumericPB{\raggedright}\gnumbox[l]{gnu}}
678 &\gnumericPB{\raggedleft}\gnumbox[r]{655}
679 &\gnumericPB{\raggedleft}\gnumbox[r]{45}
680 &\multicolumn{1}{p{\gnumericColE}|}%
681 {\gnumericPB{\raggedleft}\gnumbox[r]{29475}}
683 \multicolumn{1}{|p{\gnumericColB}}%
684 {\gnumericPB{\raggedright}\gnumbox[l]{leopards}}
685 &\gnumericPB{\raggedleft}\gnumbox[r]{9600}
686 &\gnumericPB{\raggedleft}\gnumbox[r]{4}
687 &\multicolumn{1}{p{\gnumericColE}|}%
688 {\gnumericPB{\raggedleft}\gnumbox[r]{38400}}
690 \multicolumn{1}{|p{\gnumericColB}}%
691 {\gnumericPB{\raggedright}\gnumbox[l]{weasel}}
692 &\gnumericPB{\raggedleft}\gnumbox[r]{45}
693 &\gnumericPB{\raggedleft}\gnumbox[r]{12}
694 &\multicolumn{1}{p{\gnumericColE}|}%
695 {\gnumericPB{\raggedleft}\gnumbox[r]{540}}
697 \multicolumn{1}{|p{\gnumericColB}}%
698 {\gnumericPB{\raggedright}\gnumbox[l]{zebras}}
699 &\gnumericPB{\raggedleft}\gnumbox[r]{400}
700 &\gnumericPB{\raggedleft}\gnumbox[r]{12}
701 &\multicolumn{1}{p{\gnumericColE}|}%
702 {\gnumericPB{\raggedleft}\gnumbox[r]{4800}}
704 \multicolumn{1}{|p{\gnumericColB}}%
705 {\gnumericPB{\raggedright}\gnumbox[l]{ant eater}}
706 &\gnumericPB{\raggedleft}\gnumbox[r]{83}
707 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
708 &\multicolumn{1}{p{\gnumericColE}|}%
709 {\gnumericPB{\raggedleft}\gnumbox[r]{83}}
711 \multicolumn{1}{|p{\gnumericColB}}%
712 {\gnumericPB{\raggedright}\gnumbox[l]{ants}}
713 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
714 &\gnumericPB{\raggedleft}\gnumbox[r]{1300}
715 &\multicolumn{1}{p{\gnumericColE}|}%
716 {\gnumericPB{\raggedleft}\gnumbox[r]{1300}}
718 \multicolumn{1}{|p{\gnumericColB}}%
719 {\gnumericPB{\raggedright}\gnumbox[l]{gorillas}}
720 &\gnumericPB{\raggedleft}\gnumbox[r]{12000}
721 &\gnumericPB{\raggedleft}\gnumbox[r]{5}
722 &\multicolumn{1}{p{\gnumericColE}|}%
723 {\gnumericPB{\raggedleft}\gnumbox[r]{60000}}
725 \multicolumn{1}{|p{\gnumericColB}}%
726 {\gnumericPB{\raggedright}\gnumbox[l]{monkeys}}
727 &\gnumericPB{\raggedleft}\gnumbox[r]{300}
728 &\gnumericPB{\raggedleft}\gnumbox[r]{45}
729 &\multicolumn{1}{p{\gnumericColE}|}%
730 {\gnumericPB{\raggedleft}\gnumbox[r]{13500}}
732 \multicolumn{1}{|p{\gnumericColB}}%
733 {\gnumericPB{\raggedright}\gnumbox[l]{lions}}
734 &\gnumericPB{\raggedleft}\gnumbox[r]{8000}
735 &\gnumericPB{\raggedleft}\gnumbox[r]{6}
736 &\multicolumn{1}{p{\gnumericColE}|}%
737 {\gnumericPB{\raggedleft}\gnumbox[r]{48000}}
739 \multicolumn{1}{|p{\gnumericColB}}%
743 &\multicolumn{1}{p{\gnumericColE}|}%
746 \multicolumn{1}{|p{\gnumericColB}}%
750 &\multicolumn{1}{p{\gnumericColE}|}%
753 \multicolumn{1}{|p{\gnumericColB}}%
754 {\gnumericPB{\raggedright}\gnumbox[l]{{\color[rgb]{0.00,0.50,0.00} \textit{Furniture}}}}
757 &\multicolumn{1}{p{\gnumericColE}|}%
760 \multicolumn{1}{|p{\gnumericColB}}%
761 {\gnumericPB{\raggedright}\gnumbox[l]{chairs}}
762 &\gnumericPB{\raggedleft}\gnumbox[r]{12}
763 &\gnumericPB{\raggedleft}\gnumbox[r]{64}
764 &\multicolumn{1}{p{\gnumericColE}|}%
765 {\gnumericPB{\raggedleft}\gnumbox[r]{768}}
767 \multicolumn{1}{|p{\gnumericColB}}%
768 {\gnumericPB{\raggedright}\gnumbox[l]{tables}}
769 &\gnumericPB{\raggedleft}\gnumbox[r]{20}
770 &\gnumericPB{\raggedleft}\gnumbox[r]{6}
771 &\multicolumn{1}{p{\gnumericColE}|}%
772 {\gnumericPB{\raggedleft}\gnumbox[r]{120}}
774 \multicolumn{1}{|p{\gnumericColB}}%
775 {\gnumericPB{\raggedright}\gnumbox[l]{table (round)}}
776 &\gnumericPB{\raggedleft}\gnumbox[r]{33}
777 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
778 &\multicolumn{1}{p{\gnumericColE}|}%
779 {\gnumericPB{\raggedleft}\gnumbox[r]{33}}
781 \multicolumn{1}{|p{\gnumericColB}}%
782 {\gnumericPB{\raggedright}\gnumbox[l]{chairs (office)}}
783 &\gnumericPB{\raggedleft}\gnumbox[r]{16}
784 &\gnumericPB{\raggedleft}\gnumbox[r]{34}
785 &\multicolumn{1}{p{\gnumericColE}|}%
786 {\gnumericPB{\raggedleft}\gnumbox[r]{544}}
788 \multicolumn{1}{|p{\gnumericColB}}%
789 {\gnumericPB{\raggedright}\gnumbox[l]{desks}}
790 &\gnumericPB{\raggedleft}\gnumbox[r]{42}
791 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
792 &\multicolumn{1}{p{\gnumericColE}|}%
793 {\gnumericPB{\raggedleft}\gnumbox[r]{1260}}
795 \multicolumn{1}{|p{\gnumericColB}}%
796 {\gnumericPB{\raggedright}\gnumbox[l]{big desk}}
797 &\gnumericPB{\raggedleft}\gnumbox[r]{150}
798 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
799 &\multicolumn{1}{p{\gnumericColE}|}%
800 {\gnumericPB{\raggedleft}\gnumbox[r]{150}}
802 \multicolumn{1}{|p{\gnumericColB}}%
803 {\gnumericPB{\raggedright}\gnumbox[l]{boss chair}}
804 &\gnumericPB{\raggedleft}\gnumbox[r]{120}
805 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
806 &\multicolumn{1}{p{\gnumericColE}|}%
807 {\gnumericPB{\raggedleft}\gnumbox[r]{120}}
809 \multicolumn{1}{|p{\gnumericColB}}%
810 {\gnumericPB{\raggedright}\gnumbox[l]{desk lamps}}
811 &\gnumericPB{\raggedleft}\gnumbox[r]{8}
812 &\gnumericPB{\raggedleft}\gnumbox[r]{30}
813 &\multicolumn{1}{p{\gnumericColE}|}%
814 {\gnumericPB{\raggedleft}\gnumbox[r]{240}}
816 \multicolumn{1}{|p{\gnumericColB}}%
817 {\gnumericPB{\raggedright}\gnumbox[l]{wall lamps}}
818 &\gnumericPB{\raggedleft}\gnumbox[r]{4}
819 &\gnumericPB{\raggedleft}\gnumbox[r]{22}
820 &\multicolumn{1}{p{\gnumericColE}|}%
821 {\gnumericPB{\raggedleft}\gnumbox[r]{88}}
823 \multicolumn{1}{|p{\gnumericColB}}%
824 {\gnumericPB{\raggedright}\gnumbox[l]{standing lamps}}
825 &\gnumericPB{\raggedleft}\gnumbox[r]{11}
826 &\gnumericPB{\raggedleft}\gnumbox[r]{12}
827 &\multicolumn{1}{p{\gnumericColE}|}%
828 {\gnumericPB{\raggedleft}\gnumbox[r]{132}}
830 \multicolumn{1}{|p{\gnumericColB}}%
831 {\gnumericPB{\raggedright}\gnumbox[l]{water coolers}}
832 &\gnumericPB{\raggedleft}\gnumbox[r]{57}
833 &\gnumericPB{\raggedleft}\gnumbox[r]{5}
834 &\multicolumn{1}{p{\gnumericColE}|}%
835 {\gnumericPB{\raggedleft}\gnumbox[r]{285}}
837 \multicolumn{1}{|p{\gnumericColB}}%
838 {\gnumericPB{\raggedright}\gnumbox[l]{safe}}
839 &\gnumericPB{\raggedleft}\gnumbox[r]{6500}
840 &\gnumericPB{\raggedleft}\gnumbox[r]{2}
841 &\multicolumn{1}{p{\gnumericColE}|}%
842 {\gnumericPB{\raggedleft}\gnumbox[r]{13000}}
844 \multicolumn{1}{|p{\gnumericColB}}%
845 {\gnumericPB{\raggedright}\gnumbox[l]{bookshelf}}
846 &\gnumericPB{\raggedleft}\gnumbox[r]{19}
847 &\gnumericPB{\raggedleft}\gnumbox[r]{13}
848 &\multicolumn{1}{p{\gnumericColE}|}%
849 {\gnumericPB{\raggedleft}\gnumbox[r]{247}}
851 \multicolumn{1}{|p{\gnumericColB}}%
852 {\gnumericPB{\raggedright}\gnumbox[l]{world map}}
853 &\gnumericPB{\raggedleft}\gnumbox[r]{3}
854 &\gnumericPB{\raggedleft}\gnumbox[r]{1}
855 &\multicolumn{1}{p{\gnumericColE}|}%
856 {\gnumericPB{\raggedleft}\gnumbox[r]{3}}
858 \multicolumn{1}{|p{\gnumericColB}}%
862 &\multicolumn{1}{p{\gnumericColE}|}%
866 \multicolumn{1}{|p{\gnumericColB}}%
867 {\gnumericPB{\raggedright}\gnumbox[l]{\textit{Total sum for everything:}}}
870 &\multicolumn{1}{p{\gnumericColE}|}%
871 {\gnumericPB{\raggedleft}\gnumbox[r]{\textit{1052712}}}
876 \ifthenelse{\isundefined{\languageshorthands}}{}{\languageshorthands{\languagename}}