I have been thinking about the current format I have for my spreadsheet, and I did notice a major flaw, that has been fixed just a few minutes ago. I still have a small problem when it comes to when the mother weans her pups. Since this isn't an exact science, she may have a visiting preggo female for a few days until I feed off her pups.
I've updated my version (again) just those few minutes ago to include:
3 weeks with the male,
1 week in limbo [when she should have birth]
4 full weeks with her pups.
She get 3 weeks off, and then back in with the male.
A full 8 week period.
This spreadsheet still includes 10 female, and 2 males, with each female having 3 full weeks of rest.
7 tubs total: 4 for nursing mothers, 2 for males, and 1 for Vacationing. One more can be added for weanlings. I didn't need it as my snakes should be able to finish off one litter a week.
It technically should also be able to switch to 5 females and 1 litter every 2 weeks, with the same 8 week period. Hopefully *crosses fingers*