Have you been reading my blogs? Short answer is yes I have been, but I don't always post everything, there is just too much, I try to just post what is relavent and can be applied within the TSP world. For me, it is really just another form of charting, but it's better. Formulas don't guess they have no grey, it's either yes or no, where charting is full of grey
I won't know until I re-merge & rebuild all the files, I had to seperate them last week because they were using too much resources. It will be better because it is taking the most direct path to the answer, it's also using less columns, less is more
Retired, 10G/90C_ BLOG: Stats for April, 2024 Stats
JTH
I don't know if this is true or not, but I was once told by an Excel consultant that when you save in Excel it doesn't just save the new information, it completly resaves the whole Excel spreadsheet. As a result, the more often you save an Excel spreadsheet the quicker the file will grow and eventually start to slow down and break. This is in addition to new data in the Excel spreadsheet.
Based on the discussion I had with this individual, I now use the Save As function insteads of Save when I notice my files starting to slow down and rename them something similar. I then close down Excel delete the old file and then rename the new file to the old files name.
Just a thought and as I said upfront, not sure if true or not but I do it.
100% G Fund COB 13 March 2020
Thanks, I do belive this is true, when I save the file, it shouldn't take 1 minute to dave something when you haven't made any changes.
Retired, 10G/90C_ BLOG: Stats for April, 2024 Stats
Don't know if this will help anyone, but just saw it:
11 Advanced Excel Tricks - Business Insider
Subscriber info: Intrepid Timer Premium Talk | System Signals posted here l FAQ about email alerts l
Rules:
- Trade what you see, not what you believe
- Don't put stuff in your signature that a Mod doesn't like
"Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle
Great Tools:
http://www.CreditKarma.com
http://www.Mint.com
http://www.SaveUp.com/r/nmJ
IDK if you are aware but there is a way to stop Excel from auto-calculating every time you change a cell. If you have issues where every time you hit enter or click on a cell the spreadsheet tries to update (can be intense if there are a lot of formulas dependent on other formulas) it might be a very good idea to change it to manual calculate.
Thanks for this thread. The formulas here tickled some long dead brain cells about some future projects.
Long dead brain cell memories - anyone remember using Lotus 123 and having to buy a math co-processor for the ol 8086 computer? Remember having to check all the math if using a Lotus spread sheet in a report due to rounding errors?
Off memory lane and back to the scheduled progamming.
Thanks again
PO
Rules:
- Trade what you see, not what you believe
- Don't put stuff in your signature that a Mod doesn't like
"Government exists to protect all people’s rights, not some people’s feelings." - A. Barton Hinkle
Great Tools:
http://www.CreditKarma.com
http://www.Mint.com
http://www.SaveUp.com/r/nmJ
Hehehe .... Lotus 123
100% G Fund COB 13 March 2020
S&P500 (C Fund) (delayed) (Stockcharts.com Real-time) |
DWCPF (S Fund) (delayed) (Stockcharts.com Real-time) |
EFA (I Fund) (delayed) (Stockcharts.com Real-time) |
BND (F Fund) (delayed) (Stockcharts.com Real-time) |
||
Yahoo Finance Realtime TSP Fund Tracking Index Quotes |
Bookmarks