I am cleaning up my Balance History tab to try to improve sheet performance. Balance History is where everything starts and many other places pull from here.
Facts - Assume I have a linked checking account that has a $100 balance on every single day of the year. Thus, the Balance History tab has at least 365 rows for this checking account for the year. To keep things simple, assume that every day has just one $100 row in this tab. Lets say I delete 363 rows and leave just 01-01-xx and 12-31-xx.
Questions - Lets say I look at the net worth tabs for my net worth on 05-31-xx, what amount will show for the checking account? $100? 0? Something else? Maybe the account won’t show up at all? I am thinking the program logic says it sees the $100 from 01-01-xx and will assume that is the balance for every day into the future until the Balance History tab shows another value for a date into the future. I am not sure what happens when the system looks for weeks and months. I would like to delete most of these $100 rows in order to clean things up but am unsure how this will impact the rest of my sheet. This is a question for the Tiller folks who really understand the programming. I know I could experiment but would like more of a general understanding before proceeding. Any feedback would be greatly appreciated. Thanks, Blake