Scout333's TSP Contribution Spreadsheet

[Scout333]

Hello Tom, I saw your post re a spreadsheet which will let you put in bi-weekly contributions. I have one which will do that which I'm certainly willing to share as long as everyone realizes it is a work in progress. There are a few quirks- 1. When you put in the bi-weekly contributions in Col. E you need to put the daily shares prices in first (for the day the contribution is posted) then drop down one line, use the same date and share prices, and enter the contribution in Col. E for that line. The reason you have to do this is because the contributions are made after the share price changes for that day are implemented. 2. Every so often the total TSP balance will be off 1 cent up or down (haven't figured out why I just adjust to actual by using the contribution column). 3. When you open the spreadsheet you will get a circular formula message just cancel and keep on going. Feel free to modify to improve, etc. If you improve it please post here so others can benefit.

Current Version as of 12/02/08: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

[tsptalk]

Thanks Scout333! I added the link above.

[Scout333]

Just a quick tip for those who don't like the cluttered look of the split window- Select Window and the Remove Split option and it is much cleaner looking. I used it to show 12-31-2007 amounts for comparison purposes in my personal spreadsheet.

[Scout333]

Just a quick tip for those who don't like the cluttered look of the split window- Select Window and the Remove Split option and it is much cleaner looking. I used it to show 12-31-2007 amounts for comparison purposes in my personal spreadsheet.

Posted spreadsheet without the split window. Just cleaner. Thanks Tom!

[tsptalk]

Current Version Updated 9/29/08: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

[Scout333]

Current Version Updated 9/29/08: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

Hello fellow TSP'rs, Finally figured out how to eliminate the circular reference problem with the spreadsheet and Tom was kind enough to repost it. The link included in the quote above can be used to get the updated spreadsheet (without the circular reference). For those who want to fix their personal copy you can select Tools Options Calculation & Check the box by Iteration and change max number of iterations to 1 and maximum change amount to 1000. This should keep the circular reference from showing up. It was really annoying to me and probably many of you also. Happy investing!:)

[Show-me]

Scout333,
Many thanks for sharing.

[tsptalk]

Current Version as of 12/02/08: http://www.tsptalk.com/utilities/Scouts_Spreadsheet.xls

[Diesel]

Scout,

I love your layout and can't wait to give it a shot by importing my data. Thanks for sharing this information.