need to do a spreadsheet for a sheep draw. there are 6 agents that sell with
different numbers each week. having trouble with pen allocations.

eg spreadsheet

agent, total head, number of pens, pen allocations
1 2,000 49
2 3,000 74
3 3,000 74
4 3,000 74
5 3,000 74
6 3,000 74
17,000 419

Total yarding = 17,000 that is 41 hd per pen. (using 419 pens)


need to allocate pens 1-443 (leaving out pens 116-124 and pens 153-167) nb
these pens are large pens and are used for delivery people.
Would appreciate any help