When it began, the inspector asked me to show the condenser to ensure it was on a pad.

Thermal scan is the way to find exactly where the leak starts and then open up to see what's inside, A/C condensate line, plumbing drain, water supply...gutter overflow or even a roof leak running a rafter/truss...it could be any of those. 

Aloha,While associated fans may be multi-speed, the actual "cooling" mechanism- compressor, evaporator, condenser, coolant lines and controls, are not.

Actually, the condensation line was stopped up so the unit kept cutting off, but the technician told us we needed a new unit.

The Condensation drain line was plugged up and managed to leak through the ceiling onto the second floor on the home. 

Would really love some help understanding the spreadsheet I've recieved and how to navigate it (What columns I should be looking at, what qualifies one of these address' as a viable prospect, how to practically condense list, etc.).

Or would it be more cost-effective to replace just SEER condenser and evaporator coil for the AC?

We waited 3 weeks for a condenser motor and finally got them to give us permission to local purchase it - which could have been done on day with a local contractir.  

Condense everything said before @James Mc Ree and en capitalize it. 

Happy to have a look we are always buying props HVAC for 7k,Im assuming you mean the A/C condenser, and ducked work, NOT just the furnace, right ?