The short way to do this is to open Excel, put down your tables, the columns and sizes, then estimated row counts. Add some percentage for indexes based on the index columns.
I don't have the XLS, but the resource kit isn't that expensive and not sure you still won't have to do this work.