Thread: Using the returns spreadsheet

ehopper302 wrote:

I went to use the excell spreadsheet provided on this site to track my returns and I can't get it to work right. When I put in my changes for that day (ie. fund price and my percent allocation) and then closed out the sheet it asked if I wanted to save the changes I made. I clicked yes and then went back to it and none of my changes were there. Am I missing something? How do I get this to save my changes so I can track my TSP returns? Is there a way I can do this without going to the return section of this site? Basically, how do I get this to save to my desktop so I can pull it up and do it without loggin on after I get the daily changes to the funds? Thanks for any help

PS. I'm an excell spreadsheet newbie!

When you open up the spreadsheet, go under "file" and click "save as". Then go to "desktop" and save it as whatever you want to call it. Should work then. You can't save anything to the actually spreadsheet that Tom has posted here. You may have saved it "somewhere" on your puter. You can try a search too if you want.

Good luck.

Welcome, ehopper!

Yes, your original spreadsheet is probably in your temp folder or your browser's cache. Do a search for files called "*.xls" and sort by date, you should find it and "Save As..." like Mike suggested. That way, you will not have lost any work.

Thanks for tips. I'll give them a try.

OKay, Heres one, I get the numbers to input okay, but they stop on cell 12 and I cannot figure out how to extend the worksheet (i.e move the functions down so I can keep using the spreadsheet) Do I have to cut and paste all functions and modify them for new cells? or is there a simpler way?

Thanks for help

Anthony

I was looking at that today and wondering how I would do that also.

Some basic instructions on the TSP spreadsheet would be helpful. I've tried to figure it out several time ,got frustrated and gave up. I and several others havenever used a spreadsheet before.

Basic instructions would include.

1. How to input changes in allocation.
2. What date? The C.O.B. date or opening date?
3. How to drop down the spreadsheet.

Sorry I don't know the "basic's". I'm learning alot here!

See todays (29Nov04) Market Comments.

Thanks for the new spreadsheet and great instructions.


Anthony

OK, once I get to line 12 it stops totaling the funds for me. How do I move down the my return vs g fund etc. block and make it keep working.

ehopper302 wrote:

OK, once I get to line 12 it stops totaling the funds for me. How do I move down the my return vs g fund etc. block and make it keep working.

Go to http://www.tsptalk.com/utilities.html to get the new spreadsheet. It gives you 30 lines now so you won't have to add any until... February

If you are still messing with the old one, I cut and paste the last line and "insert new cells". Then you have to do some editing of the formulas to match the others. It's a pain, I know.

tsptalk wrote:

Go to http://www.tsptalk.com/utilities.html to get the new spreadsheet. It gives you 30 lines now so you won't have to add any until... February

If you are still messing with the old one, I cut and paste the last line and "insert new cells". Then you have to do some editing of the formulas to match the others. It's a pain, I know.

Thanks Tom, cya in Feb........:shock: Would be nice if I only needed like 3-4 lines for the whole year!!!!!!!!