This is the conclusion I came to with the idea of having self sustained colony, but having new people coming in to the planet all the time, but a single colony drop could be isolated and thrive...
002 General practitioner (Doctor)
002 Mechanical Engineer
002 Electrical Engineer
002 Civil Engineer
002 Chemical Engineer
002 Mining Engineers
002 Aerospace Engineer
002 Biomedical Engineer
002 Software Engineer
004 Trauma surgeons
020 Construction Worker
112 Miscelaneous Workers
Needed things on the ship
166 housing units
+34 crew units
Liesure area = ?
Housing area = 1500m × 1500m
food storage = 49m × 49m
material storage = 49m × 49m
reactor = 5m × 5m × 17m
The different doctors are overlapping because it is assumed they can work in general fields, but it is best to have specialties for all the things.
Children are there because you want to start with people that are known to be fertile and in a relationship.
Teachers and professors you need to teach people
Administrators... you need people to govern the society and that be their job. You want to have this established before getting to the colony so there is no problems.
Farmers, Workers, contruction workers, hunters, guards can be used interchangeably, but each are needed for their specific knowledge in their fields and you want to have lots of back ups and people that know what they're doing here or have muscle to fill the role.
And all these are needed no matter how automated the system is because you'll be encountering new things or needing new things developed or having to building thing with materials or in ways you're not accustomed to.
Since this was not built to be a 1 and done thing, just possible to be, but even then you could still theoretically get trade. This would be the minimum I'd think you'd send for that. If you're going to send a colony to make sure it succeeds and self-sustains you're going to want 2 to 5 times more redundancy, just to make sure, but supposing this could land you can easily create viable colony. You could in fact create 2 to 3 tribes/villages at hunter-gathers and perhaps an agrarian level society with this, but i assume you don't want to live like that, but rather in a society you're more used to. I'd say this is likely the minimum for that.
Edit: I just want to be clear with a few things...
Firstly, I came up with this when designing the program for a world I am/was working on so there are a few things that are different or might to be reconsidered.
The ship compartment numbers assume 3 to 4 occupants. 1 adult male, 1 adult female and 1 to 2 children.
The "Reactor" is based on a type of warp drive for the world, with a very loose understanding of nuclear reactor dimensions. That should be looked at when coming up with specs for that.
Food Storage is based on the Titanic's food storage + Fungal growth cultivation foods or whatever they're called + a journey of about a year if I remember right that had to be provided for.
Material storage, technically all you would need is plastic and various types of metal and you should be good with that. Everything else can be forgotten more or less. You'd also probably have a seed bank for corn here if you want to try to farm bio-plastics when you get to the colony
The ship was designed to drop the housing units, storage, and workshops in a circle with cabling and such spooling out so that the housing units are on the outside of the circle and the storage and workshop on the inside. This would make the colony be perfectly set up upon being dropped off. IF you can land the ship, all the more easier.
Though it's not stated here we're also assuming that everyone is carrying at least 1 tablet style PC and there are at least 2 server PC they can interact with. Further each of these tablets have the maximum processing power physically possible as that will likely be achieved by 2050 and each of them are carrying pretty much all books written up to that point as well as whatever else they brought along on their personal devices. And the server PCs each have a Crystal Hologram of the internet as it was before they left, each with at least 1 back up copy in case something happens to it (Basically they downloaded the internet and etched it into a crystal. This is real technology and it is perfect for storage where you only want to read, but not hard drives where you need to read and write) Upon landing it would be planned that at least 2 physical versions of the most essential of texts, enough to rebuild a civilization were printed and stored in separate/safe places.
Before being sent landing spots were surveyed so the colonists would be by water and places where metal is likely easy to get. The goal after this point would be to start building a farm and find metal deposits as soon as possible and start mining.
Another thing to consider with this is that because this was supposed to be an either or thing there is a lot of stuff that isn't going to be needed more of if you scale up. Farming experts and astronomers for example aren't really needed more than a few of and so those slots get taken by general laborers or police. Doctors are 1 for every 22 patients scaling if i remember right and while it's nice have specialties, more general practitioners are more important with with larger groups so you can cut out specialists in favor of other specialists or general practitioners where it is more reasonable, such as scaled to 10k, 10 dentists seems a bit too much for me because assuming you treat people every day of a year each dentist will only have 2 patients a day. That seems low to me. So you can reduce this number a little. Likewise 10 cardiologist per 10,000 people isn't needed. So a lot of these groups when scaled can be changed to a less specialized group.
Hope this long explanation of the miscelaneous tangetial stuff helps explain why it is there and why it is the way it is on there, and helps you come up with whatever you need for your own thing.