I have a spreadsheet question.

[Ptah]

I have been tracking my expenses for several years using Open Office Calc.
I believe it is similar to Excel.
I have a separate sheet for each month.
I would like to create a chart or sheet that shows the expenses for a particular line item.
For example, what are the costs over the years for the account TEP?

Thanks in advance for any suggestions.

[usonian]

1. Unix junkie here.

I'd export each one as CSV (I use CSV for all my bank statements, from their sites)

Then I'd grep on TEP and merge the files, and then do whatever. (open in Calc. It's an excel clone)

grep TEP * >> TEP.csv

Use the parent directory in case TSV.csv decides to grow endlessly.

Simple enough for grep and cat.


=============
If not, perl will do lots and lots.

Luv my command line.

I used to use a relational database known as /rdb, written entirely in perl that used flat data files.

https://github.com/ironsmith58/RDB

[Ptah]

2. Export each monthly sheet as a CSV?

That would leave me with more that 30 files.
I thought there might be a way to do this within Calc.
Can I define a range and search that range?

[usonian]

4. "Separate Sheet for each month"

If they are all in the same file, as opposed to each in its own file (I can't tell) then something internal is possible, but that's beyond me.

1. If they are all in the same file as "separate sheets" then export it one CSV and see.

2. Otherwise, some internal operation might work.

I am better at the former than the latter. Most people are the opposite.

Good luck.

[JoseBalow]

3. You can create a Lookup Table

https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_LOOKUP_function

[Ptah]

5. Thanks, JoseBalow.

I appreciate the simple explanation on how to use Calc. search.

[rampartd]

6. excel uses macros in visual basic

if calc does not, import your data into excel .

[Ptah]

7. I don't want to purchase (rent) Excel.

[rampartd]

8. understand fully

i got used to it when i was working, but these new versions in win 11, well. i'm glad i retired.

[Ptah]

9. What macro would you use in excel to create a sheet or chart?

excel uses macros in visual basic

[rampartd]

10. it wouldn't be much

actually, i just came back from the new xcel version. they no longer do it that way. but there s a screen to "automate" and it looks like they will walk you through a "script." i'm going to do a little of that late tonight or tomorrow night.