In inputs, how would I enter the square footage to model townhomes if there were garages on the ground floor, living and kitchen on the second, and two beds on the third floor?

My suggestion would be to use just one “floor”. So you’d delete all values in cells B29:B41 except for one, then name the floor “1”.

Then under the ‘Units’ section next to the Floor value, enter the number of units by number of bedrooms. If all four units have two bedroom, then you’d delete all values in cells C29:F41 and then enter a 4 below the ‘2 Beds’ column in the same row as the “1” floor value.

Finally, under the SF section enter the total SF for the four townhomes, excluding garage SF, under the SSF column. So if each townhome is 1,000 SF you’d enter 4,000 under column H on the same row as the “1” floor value. Under parking you’d enter the total SF of the garages. And then under the GSF column, enter the sum of the SSF and Parking SF.