I'd suggest moving off google sheets and into some more automated with less risk of input error.

I am purchasing a 4plex tomorrow and will be moving into one of the units.

We'll just keep moving forward as best we can.  

I do not feel comfortable going back over there after how they acted during the inspection.Do you think they will have legal grounds to move forward with suing or rent escrow actions given the following circumstances 1) "as-is" language in the lease (pasted below); 2) nothing about smell is included on the pre-move-in inspection; and 3) the city inspector was already out and stated there was no violation?

of course you generally want to be around break even when you move out if you can. 

Once she moved out a couple years later, we hired a property manager and they have been great. 

Are you talking about permanent movers, or those on vacations of some sort, or people who are temporarily to be housed due to an emergency and then intend to move back to their old stomping grounds?

Get through a few deals and then pay the HELOC back and use the profits moving forward.Philly is my backyard, I grew up there.

Also, they move a lot and can use SCRA.

I need it to work as a quadplex so moving forward, I would appreciate not getting warning posts about zoning.Should I rent it as 2 units and put people on the same lease but keep their residences separate with a door that can just stay locked or something?