This is actually very helpful, and difficult to find without a link. Can we have someone add this (or a link to it) to the "presenting a case study" sticky in the "ask a mustachian" area? Thanks!
This spreadsheet https://drive.google.com/file/d/0Bxe0EgraZFRBT2pGYjBEbG1qYlk/edit (https://drive.google.com/file/d/0B45krBaG0b6KTWZDeXEySVBHVXc/view?usp=sharing) can be downloaded and used to help organize your case study posting.
It includes income, expense, and investment categories that will cover most situations. For "not too complex" cases it will calculate IRS, SS, and Medicare taxes exactly, and state taxes approximately, helping one evaluate the after-tax effects of 401k, HSA, etc. There is also a simplified section to evaluate "how long to FI?".
See this post (http://forum.mrmoneymustache.com/ask-a-mustachian/how-to-write-a-%27case-study%27-topic/msg274228/#msg274228) and the spreadsheet itself for more details.
3. Copy from Excel & paste into the post. If you go this route, use any of:
a. Column G of the "Posting" tab. This is based on the idea given in http://forum.mrmoneymustache.com/journals/dandarc's-journal/msg367990/#msg367990. Nice idea from dandarc - any implementation errors are mine.
b. http://forum.mrmoneymustache.com/forum-information-faqs/how-to-formatting-a-table or
c. http://forum.mrmoneymustache.com/forum-information-faqs/how-to-simple-step-by-step-guide-for-posting-formatted-table
so your table will be both easy to read and easy to import back into a spreadsheet.
R1C1 | R1C2 | R1C3 |
R2C1 | R2C3 | |
R3C1 | R3C2 | R3C3 |
Can this functionality be restored? New bbcode that one now should use?
|
The trick here is my use of the "figure space" character, U+2007, which the new BBCode parser apparently does not strip out when used as whitespace in a table.Thanks, that works!
Can this functionality be restored? New bbcode that one now should use?
As this seems a Simple Machines bug, not a good new feature, I'll hold off revising all the automated posting cells in the case study spreadsheet in the hopes the bug will be fixed....
As this seems a Simple Machines bug, not a good new feature, I'll hold off revising all the automated posting cells in the case study spreadsheet in the hopes the bug will be fixed....I wouldn't count on that happening anytime soon, given it was almost exactly a year between previous forum updates (SMF 2.0.11 released Sept 18, 2015, SMF 2.0.12 released Sept 27, 2016).
Estimate of when this forum might be upgraded?
It appears the table formatting has changed (due to the recent forum software upgrade (http://forum.mrmoneymustache.com/off-topic/trump-voters-why/msg1275776/#msg1275776)?).
Previously,would have displayed R2C3 in the second row under the R1C3 in first row, just as a spreadsheet would do with a blank cell in R2C2.
R1C1 R1C2 R1C3 R2C1 R2C3 R3C1 R3C2 R3C3
Can this functionality be restored? New bbcode that one now should use?
ETA: Using the table - Online Manual (http://wiki.simplemachines.org/smf/Table) example itself.
R1C1 | R1C2 | R1C3 |
R2C1 | R2C3 | |
R3C1 | R3C2 | R3C3 |