Laptop / Tablet Hybrid - Searching for Goldilocks Device

I got a new job as a commercial construction manager several months ago.

I am currently using a B&N Nook HD+ tablet that was given to me for free from a relative when I got my new job.
Wow, what a crappy tablet you say? You would be correct. I'm in suck city right now.

So I've been searching in vain for something that will work for me; hence why I am here now.

Needs (in order of importance):
1) USB port to allow thumb drive use
2) Physical keyboard (either native or add on, prefer non BT keyboards)
3) Snappy performance (quick loads, no bogging down when switching apps/uses)
4) Ability to communicate with and xfer files between my phones - Note 4 and GS5
5) Ability to draw on pictures (MSPaint style) and send out to engineers/clients
6) Ability to view PDF's, Excel, and Word. Ability to edit Excel and Word
7) Ability to charge in the field (I have a 300W power inverter so a standard plug would be OK)

I don't want to buy another data plan for this device as I have a good amount of data already for my phones so I can phone hotspot or xfer from device to phone and send out.

My price point is somewhere in the $200 - $500 range.

No apple products at all
Prefer to stay away from windows OS as I would have to buy another Office license (or at least I think I would have to)
Android OS preferred
Less well known brands don't scare me. I just want performance and function.

Used devices doesn't scare me either.
If a high dollar/high performance device was made a year or two ago and it now can be picked up used in my price range that would work.

Durability of device isn't too much of a factor. It will mostly be used in my truck (out of elements and little drop risk)

Thanks for any help/guidance you may provide.