Thank you so much for sharing - I don't have the spreadsheet so forgive me if I may be misinterpreting - would not the total loss which already includes the forgone tax refund be subtracted from the distribution amount. It appears you did so with the full distribution in column 1 but not the other columns. That would make the difference in gain less significant.
