Great job on the spreadsheet! I was looking at writing a program to do all of this stuff, but now, I probably won't have to.
A few other things I've noticed, or questions I have:
1) I don't believe Spivey is supposed to count toward any traveler or consumption slots. She can fill a job roll, but doesn't use up any space or consumption resources. I assume this is why there is that checkbox to say if Spivey is with the group? My group has her as an NPC, not a PC. I'm not sure if you had something else intended for that checkbox.
2) What is your intention of the Spellcaster Job section on the Caravan Worksheet tab. It looks to assign all travelers of type Spellcaster to that specific job. Our crew has multiple spellcasters, but they do different things, 1 might be a guard, and 1 might be an entertainer. Would it be better to just assign them to that specific job instead of as a spellcaster? Another option is to list the job as Spellcaster - Guard, Spellcaster - Scout, Spellcaster - Entertainer, etc. and maybe just remove that section from the Caravan Worksheet section. I assume the Spellcaster chooses the job/role they are taking for a 24-hour period, and can't switch during the day.