please do not send any mail to us sir
INDISCHKA Boekhorststraat 14,
----- Original Message -----
From: "Dan" <elderdanle...@gmail.com>
To: <users@global.libreoffice.org>
Sent: Wednesday, July 18, 2012 2:57 PM
Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down listin
all cells in column?
And why isn't the bank statements in PDF files the "audit trail"?
The numbers in those files can be compared with the numbers in the
tables. The query structure will show whether the query will give the
correct results or not. If the input numbers are correct, and the
operations performed on those numbers are correct; it seems logical to
assume that the output would also be correct. When in doubt, the query
structure can also be checked by feeding it data with known
calculations. If the query output on this data matches the known
calculations, I would think the query can be trusted to give the correct
result on other data as long as that data can be verified first.
--Dan
Tom Davies wrote:
Hi :)
One problem with using a spreadsheet or database is that it is difficult
to set-up an "audit trail" and even if you do then it's unlikely to be
trusted by anyone else that might need to see your accounts. That is the
advantage with using proper software developed for the purpose or for
using pen&ink (ie so you can't rub-out entries without it being
noticeable) to keep proper records.
If you don't have an accountant or auditor or present the accounts to
anyone else then of course a database might be a LOT better than a
spreadsheet, if you are at all familiar with database programs.
Regards from
Tom :)
--- On Wed, 18/7/12, Dan <elderdanle...@gmail.com> wrote:
From: Dan <elderdanle...@gmail.com>
Subject: Re: [libreoffice-users] Re: [3.5.3.2/Calc] Display drop-down list
in all cells in column?
To: users@global.libreoffice.org
Date: Wednesday, 18 July, 2012, 12:38
Gilles wrote:
Johnny Rosenberg wrote
The easiest thing is probably to select one cell, select FOOD, hit
Ctrl+c,
select all the other cells in which you want the word FOOD (using Ctrl
or
Shift), hit Ctrl+v.
Thanks much for the tip. It's fast enough.
Tom wrote
How about using GnuCash?
Thanks for the idea. I know about GnuCash, but it's a bit too
feature-rich
just to compute how much money I spend on what, and besides my bank no
longer provides data in CSV but rather as PDF :-/
A database will also do what you want to do. Queries will provide
you with the information you need. I use such a database. One query tells
me the balance of all my financial accounts (9 of them). Two queries break
down my expenses into budget categories; one is for the present month, and
the second is for the previous month. This way I can compare expenses for
the two month by category. Both queries have a column for the budgeted
amounts for each category as well.
--Dan
--
View this message in context:
http://nabble.documentfoundation.org/3-5-3-2-Calc-Display-drop-down-list-in-all-cells-in-column-tp3996001p3996193.html
Sent from the Users mailing list archive at Nabble.com.
-- For unsubscribe instructions e-mail to:
users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
