Az - let me clarify - anything in yellow is just sample data, and is intended to be revised by the visitor. The percentages just display the relationship of whatever the input expense is to the input gross. I put in some fairly random figures as starter numbers only. The tax exemption, for example, assumed a high mortgage with deductible interest double the standard exemption.
Maybe I should start with zeros instead, if it is misleading. Maybe I'll do that this morning.
I will be adding lots of explanatory material before making it more widely public, including many of the comments here.
Some of your comments give me the chance to think out loud about stuff that I wrote long ago, and embedded in the worksheet, but didn't repeat here. Here is some of the thinking that will need to be clarified and explained in the worksheet:
The safety factor number is already buried in the annual amount available/annual amount needed figures, along with costs of groceries, haircuts, vacations, and however else people spend their money separate from the itemized entries. Working people don't (well, shouldn't) budget out their last penny for essentials, so there ought to be some "slop" in the amount available. That same amount will be in the postretirement amount needed. The idea I had discussed in the forum long ago, and I was trying to show here, was a side-by-side comparison of spending when the only difference was the job, without the countless "what ifs" that can always be added.
My diatribe from previous threads was essentially this: Even without looking at the calculations, it seems clear that the taxes, Social Security, and work-related expenses all add up to a good percentage of people's gross. The amount going into savings and investments alone are often a pretty large part of the total preretirement gross for anyone seriously planning on early retirement. (I think mine was 10% in 401k and 40-50% in regular investments and savings in my last couple of working years.)
Since these do not need to be replaced in your after-retirement spending, they grossly distort any rule of thumb based on gross income.
So... I was then arguing that you needed to base calculations not on gross income, but on gross spending for those items that would continue through retirement... and once you have that figured out, then start adding in what you want to have for your travel, hobbies, and whatever that you'll do after retirement.