They want someone who can source deals, analyze them, negotiate them, and help them make more $. 

Quote from @Jonathan Dempsey: 10 Best Pocono HOAs for STRIntroduction to the PoconosThe Pocono market has long been a popular vacation rental market due to the area's many natural attractions and the region's proximity to major metros Philadelphia and New York City.

We are analyzing a potential property as a short to medium-term rental and are struggling to pick a vacancy rate figure.

@Mikelle Willis in our opinion, zip codes are too big to sue for investing.That's why we've spent a lot of resources analyzing Neighborhoods - and even then it's ALWAYS block-by-block:)Looking forward to our chat.

BP has various tools to help you analyze your deals (rentals, flips, wholesale, etc). : https://www.biggerpockets.com/investment-calculators7.

I always look at location first, then I analyze the property itself. 

I've been looking at opportunities from investment firms like Open Door Capital, et al, and I would like to know if anybody has a recommendation for a spreadsheet or tool for analyzing these deals?

Sounds like a follower of a recent popular Guru spreading very bad ideas. 

Different platforms are popular in different areas. 

To invest in real estate, set clear goals, consider your timeline and risk tolerance, learn about financing, analyze deals using rental property calculators, consider house hacking, network with investors, create a financial plan, stay educated on local market principles, and start small with a single-family rental or duplex.