There is no tax reflected in the spreadsheet because nothing has been sold which means there is no tax payable on the capital gain yet and the dividends are fully franked, which essentially means the company has already paid tax (normally at 30%) on them so the tax on the dividends is minimal for most individuals but it is probably best to do a google search on fully franked dividends and see how it might affect you. This is another advantage of this sort of investing.
As for my other portfolios I just put aside 50% of the profits and then pay tax out of that when required.
There are a few other things from your earlier posts I will address as I get time.
which was what my understanding was until someone on another forum said otherwise. I am not putting in a cent until I have full tax advice anyway but thanks this makes more sense to me.