Great question, on the average day I depart 220am get to work by 4AM, work till about 1145am, driving home Noon to 2PM, and plugging in before I grab my bag and head inside, once a month i will wait to plug in to give the battery a chance to sit at a low percent. and on the weekends I only charge to 50% to give the car a rest from the extremes
I'd make sure your car sleeps at work (turn off sentry and make sure the contactors open). Does it? That way on your way home at least it has had a chance to re-estimate the charge level close to 50%.
What you see is pretty bad, and Tesla tries very hard to avoid it. It's likely quite unusual. (They have a 4.5% theoretical buffer for a reason!!!). It's very bad to have to rely on the BMS adjusting for a dead-reckoning error, since 100%-0% discharges without a break are quite common (and in fact getting close to 0% is probably more likely on a large continuous discharge). But anyway they have the buffer (yours seems to have disappeared). This ensures this sort of problem is rare.
If the car doesn't sleep, the evidence suggests that all Tesla can do is dead reckon the charge level. The BMS doesn't have a chance to make adjustments (see all the complaints elsewhere about how the car loses 2-3% in 15 minutes after it sleeps - this is BMS adjusting the remaining range to the correct value, as
@AAKEE has described elsewhere).
There may be situations where the BMS can adjust on the fly, but it's safest to just let the car sleep as much as possible, especially in the middle of a discharge, if you think that you'll be getting close to zero.
You can check the various energy screens to see whether you're seeing a negative adjustment - I'd expect you would, if your car was not previously sleeping at work, since you're having this problem.
I fully charged after the tow truck dropped me off in the driveway, I adjusted the amps to 28 so it would finish charge 30 mins before i have to leave for work.
I'd make sure the car sleeps before leaving. Probably doesn't matter much at 100%, but since you're having this problem, it might be worthwhile. It might be a wasted effort though, not sure.
I dont want to charge to 100% more than i need to, i usually reserve it for the worst of the worst cold or snowy days, or before a trip, or if extra errands are planned. while making sure it doesn't sit at 100 for more than 30 minutes.
I wouldn't worry about that at all. An hour or two each day at 100% isn't going to matter much, and your situation ensures that most of the time you're close to 50%, which is pretty much ideal.
Just charge to 100%, and see if you can get the car to sleep. Then leave for work.