Spreadsheets

users
#1

Hi

I am trying to create a spreasheet that will track my budget. I want to
have a form that will insert a payment every four weeks or monthly by date.
Is this possible to do please?

Thanks

#2

Probably.

But might you not be better off with something like gnucash that's designed specifically for such jobs? (And as free as LO.)

#3

Hi Richard,

its in german and made for physicians, but it might give you an idea,
how to set up such a spreadsheet:

http://resmedicinae.sourceforge.net/manuals/EUR/eur.html
GNU Free Documentation License

Yours

Walther

#4

This spreadsheet documents the inability of spreadsheets to do anything
like this. Apart from this, it has a serious design flaw.

No IT professional would ever consider this as a valid solution.

#5

have a form that will insert a payment every four weeks or monthly by date.
Is this possible to do please?

As a spreadsheet?

If you are willing to write the appropriate macros, then yes.

As a database, using the spreadsheet as an interface?

Yes, but you'll still need to write the code to that task. It is much
simpler to write a python script that does that, than write the macro
for the spreadsheet.

This is yet another time when I really wish that LibO had SQLite as a
built in database engine. (Pity one can't just write SQLite as an
extension, and have it work properly.)

Nonetheless, your best option is to use a FLOSS accounting program.
GnuCash, SMBLedger, etc.

No IT professional would ever consider this as a valid solution.

Whilst that is true, that doesn't negate the fact that most corporate
databases started out as spreadsheets created by the user.