...For discussion, if we just use the default input values ($30,000 Withdrawal, 30 Years, 650,000 dollars, etc.) and looking at the spreadsheet created, the last totally complete period starts at 1971 (so it ends at 2001). For the row starting in 1972, the last year (2002) is empty. For the row starting in 1973, the last two years are empty, etc. etc. continuing up to the present.
So starting out in a bad year like 1973, for example, is missed, although 1973 is included as an intermediate or ending year of rows starting 30 or less years previous. But we know that starting out in a bad year should have a much more negative effect than having a bad year in the middle or the end.
When I put in 40 or 45 years, the effect grows.
Are there any suggestions of what I could do with the data of incomplete rows into the present? I can't really create future yearly data to complete them. But it seems I am just losing a lot of start and early years for data. For a 45 year period, the latest start row that completes is 1956.
Is there anything I can mine out of the incomplete rows?
I did have a horrible idea... If there was, say, five years incomplete on the end of a row, take the last useful cell's data from that row, then successively feed it into 1871 for 5 years on, then into 1872 for 5 years on, etc. etc. In effect, re-using existing data successively for the missing data. And on and on for all of the rows that did not complete. My gut feel is that the size of the thing would become monstrous
I'm interested in any and all comments!