For some reason the Forum post I put up on the TLH Spreadsheet Bug Fix will not permit users to scroll and see all the message. So I will just post a blog showing this fix.
This morning I picked up an important message from Jon Dockins as he spotted a major error in the calculations of VTSMX and VGTSX. Here is the fix and I’m asking Jon to chime in if I miss something. Before you make any changes, SAVE your ORIGINAL using a DIFFERENT NAME.
It is difficult to identify the rows as they depend on what entries are used in the spreadsheet.
1. Go to the Mosaic worksheet. The errors reside in columns R, T, W, and Y.
2. We will first fix the VTSMX section. Scroll down to the rows listed BELOW the line that says to Leave the row blank! This will be near the bottom of the Mosaic worksheet of the TLH Spreadsheet.
3. In rows R and T, replace VFINX with VTSMX. Do this in the top row and then paste through the rest of the column, but not below the row identified by the 06/25/2015 date. Column R will now look like this.
Column T will look like this. Again, replace VFINX with VTSMX and then copy the change and paste through the necessary rows.
4. Now we need to fix VGTSX. First repair column W. Note the second place where you replace VFINX, not with VGTSX, but with VGTSX_1. That is an important difference. The syntax is shown below.
The syntax for these cells is
Now move to column Y and here you simply replace VFINX with VGTSX. The syntax is shown below.
Let me know if you have problems with this important fix.