openoffice-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexandro Colorado <...@oooes.org>
Subject Re: Is Apache Open Office good for sales tax service spreadsheets?
Date Sun, 29 Sep 2013 17:58:39 GMT
I am writing a document on a Calc guide for accountants and financial
people. Tools such as "Validity", "Goal Seek" and formulas like
vlookup can help you work with many of the things you need to be done.

Validity: https://www.youtube.com/watch?v=N8YHWDTUshA
http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Validating_cell_contents

Goal Seek: https://www.youtube.com/watch?v=26gc9n8ZHdU
http://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/Goal_seek

On 9/29/13, James Plante <jimplante@me.com> wrote:
> Depends on how much data you intend to acquire. For a small shop, using AOO
> would be feasible. But as Tom Goldie said below, a database should be
> employed if you're acquiring lots of data. Spreadsheets do well on small
> data sets, but beyond a certain point they get unwieldly, then become
> unusable. You've got only 65,534 rows (records) to work with in a
> spreadsheet; many more records are possible in a database.
>
> Regards,
> Jim Plante
>
> On Sep 29, 2013, at 6:51 AM, Gabrielle Becker <becker_gabrielle@live.com>
> wrote:
>
>> hi,
>> I am just looking for a simple spreadsheet program where I can keep track
>> of who I charged what, plus what sales tax there was, plus address, time
>> and invoice number.It needs to be searchable.  Etc. Is Apache open office
>> good for this type of use? I would be getting cash or checks so no need
>> for keeping track of bank account or credit card numbers. 		 	   		
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
> For additional commands, e-mail: users-help@openoffice.apache.org
>
>


-- 
Alexandro Colorado
Apache OpenOffice Contributor
http://www.openoffice.org

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org


Mime
View raw message