To many long complicated functions use up Memory and swap.

[lesfrancoeurs]

To many long complicated functions use up Memory and swap, Open office freezes.

Is there a way that I can accomplish what I am trying too without so many formulas and sheets? Or, how can I free up some memory and swap to make it possible to keep working on this spreadsheet.

Hello. I've been working for two years on two spreadsheets that are supposed to:

1) Plantdata Spreadsheet: Store information about plants

2) Calendar Spreadsheet: Display a calendar to show everything that should/could be done in the garden on any particular day of the year.

So on the Calendar spreadsheet I have:

-one sheet that links to the data from the Plantdata Spreadsheet (600 rows+or- and about 30 columns for things like earlyest and latest sew dates and days to maturity). with calculations for predicted harvest dates...

-One sheet for making sure that the plantdata puts out “” rather than “0” when fields are blank.

-36 sheets that have 365 colums (one for every day of the year) and 600 rows+or- one for every plant. Using formulas like “=IF(AND(NOT(""=info.$DJ3),NOT(""=info.$DK3)),IF(OR(AND(K$1+7>info.$DJ3,K$1<info.$DK3),AND(K$1+7>info.$DJ3+365,K$1<info.$DK3+365),AND(K$1+7=info.$DK3,K$1=info.$DK3),AND(K$1+7=info.$DJ3+365,K$1=info.$DK3+365)),CONCATENATE("Harvest ",info.$A3,"? "),""),"")“ to display for example “Harvest Tomatoes” The other 35 sheets are for things like growing instructions, sewing times and transplanting times...

-one sheet to concatenate all 600 rows down into 50 rows for every 365 columns. I did this because I didn't know how to concatenate more than 30 cells at once.

One sheet to concatenate those 50 rows into two rows

One last sheet to concatenate those two rows into one row. This way I have the cultivation info for any day of the year about all of my plants in a cell directly beneath the cell that displays the coresponding date.

Now after doing all of that work I can't do anymore because the program freezes when I try to update the links to the Plantdata Spreadsheet from the Calendar Spreadsheet.


If you are willing to take this question on I thank you very much in advance.
_________________
JOnathan
Immersion is a great way to learn how to grow all our own food.

[soneiro]

Try use array formulas, even to link between files, or with the large comparation formula, I think this reduce the memory usage.
Also reduce one step for example verify if the cell is blank, verify if you need in the link formula.
Verify don't replicate the same datas several times.
_________________
soneiro