Hi Tim,
This is great!
Now I can really sink my teeth into your analysis.
Thank again,
Bob

Thanks Tim for sharing your insight and formulae with us.


------------------
Keepin' the flame

Tim,

You have put alot of work in this, and I want to thank you for sharing.

Bob

Is it possible to get the spreadsheet in a form compatible with Excel 5.0? I don't have the lastest version of Excel. I bet you guessed this was coming, huh Tim? What a bummer.


------------------
Keepin' the flame

Thanks for sharing the fruit of your labors Tim. I plan to use the spreadsheet as a starting point for planning my future purchaces. I did one "what if" today. I added 5, 10, and 20 years to retirements. As expected, the smaller the issue, the higher it climbed. That takes care of the supply. Now if we can just get subjective criteria included in the calculations.

FWIW

AB in Ala-Bama

Just for you Lamar Wacko! Check the download page again. There's the version for Excel 5.0/Windows 95.

Thanks, JC for backwards compatibility. Works with Windows NT as well as 95/98.

Quick notes: If you're using Netscape Navigator, upon D/L the spreadsheet should launch Excel and load. If you don't see the spreadsheet, close the topmost sheet and it should be underneath.

Also, with this method, for some reason the header isn't staying fixed. Easy to correct: Highlight line 2 (click on the leftmost '2') then select 'Freeze Panes' under Excel's 'Window' menu. This'll keep the header in place as you scroll.

__
/im

[This message has been edited by JTimothyA (edited 01-21-99).]

Thanks St. John - I needed that. I've studied all the posts concerning this model and I'm planning on following it.

Lamarwacko

------------------
Keepin' the flame

I don't know how to do it. Can somebody help? I did the download thing, I think, but where is it? I can't see it. Don't know much about this puter stuff. Bought a Currituck today though, that was good right?

Sue

Thanks, Tim. As said above and before, this type of analysis is useful for all: newbies, wackos, and those who don't aspire to owning all HLs, but who wish to have an intelligent plan to follow for purchases. It's also encouraging for newer collectors to see that not all the "good" ones are gone or out of reach.

I give up! I simply cannot do this. Have been trying for 2 days. Seems to be there but I can't find it. Keep getting the message, "file format is not valid". Could somebody like just send it to me?

Last night I sent you an e-mail with some tips and just now e-mailed a copy of the Excel 97 version of the spreadsheet. If you don't have Excel 97 but the 95 version instead, you need to choose that from the download page. Good luck!

Rgds,
The Help Desk

The latest edition of the spreadsheet - the one with updated retirement numbers for Wind Point and Round Island, has some errors in it. I caused these when I made the edition size updates.

The errors are: Wind Point has Round Island's edition size, Bald Head has Wind Point's edition size, and Round Island shows 9500.

A corrected version was been sent to JC a few moments ago. If you need one ASAP, send me an e-mail and I'll mail you one.

Mea Culpa,
__
/im

Posted to bring this great one back into view for all our Newbies.

Ditto

Resurfacing this oldie.

Please note - the link to the explanation of spreadsheet formulas does not work from the download page link given in the first message of this thread.

Please Click Here to view it.

T

thanks for the explanations to the formulae. I calculated some of my information using a different formula and was surprised to see variations in some data and the same information in others. I need to figure out how to get my spreadsheets loaded to this forum.