Support Board

Date/Time: Sat, 04 May 2024 16:37:20 +0000

Post From: Spreadsheets and System Performance...last annoying question I promise:)

[2013-12-12 02:13:55] Link To Thread - Link To Post [Go To First Post]
enemyspy - Posts: 304
I have been scratching my head trying to figure out a way to give a spreadsheet system that is too demanding more rows so to speak without crashing my computer, and I am wondering if the Following scheme would work in theory...not can it be done but would it work in theory: -limit all of the spreadsheet studies to say 100 rows, -make a standalone spreadsheet that has a hypothetical autopopulate feature, where every 60 rows of time, it automatically copies the data from the 100 row spreadsheet study, stores it and arranges it all in order. the original 100 row spreadsheet study contains a provision in the formula of each cell that indexes matching time stamps to the standalone spreadsheet, where they exist, and references those values, and where they do not exist draws from the original study formulas. So that in theory if these 2 spreadsheets made a brain, the 100 row study would be the short term memory, that can call up information from the standalone study serving as the long term memory, and alleviate the burden on the ram/cpu? And the important thing here is freeing up memory so that it has to buffer less, that is what I am wonder this hypothetical scheme woule successfully achieve Last question for a while I promise Date Time Of Last Edit: 2013-12-12 02:21:45