Technically, column C should also account for the lag between stocks going ex-dividend and the dividend payment, but this should not significantly effect the calculations unless the dividend in question is a significant part of the change in your portfolio value on any given day.
FORBES: Six Simple Steps to Protecting Your Portfolio With Put Options