software

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 helpTyrone
Please consider that of all the people that visit these newsgroups, you
may well be the only person who knows anything about what you are talking
about, ie, the sheep business.
What is a quot;sheep drawquot;?
What do mean by quot;different numbersquot;? Different numbers of what?
What does quot;pen allocationsquot; mean? quot;Penquot; is understood, and quot;allocationsquot; is
understood, but explain quot;pen allocationsquot; in your context.
You say you are having trouble with quot;pen allocationsquot;. Explain how you
would do the task of quot;pen allocationsquot; manually without Excel.
What is quot;yardingquot;?
Please post back with a more generic explanation of what you need help with
and you will get lots of it. HTH Otto
quot;tyronequot; gt; wrote in message
...
gt; need to do a spreadsheet for a sheep draw. there are 6 agents that sell
gt; with
gt; different numbers each week. having trouble with pen allocations.
gt;
gt; eg spreadsheet
gt;
gt; agent, total head, number of pens, pen allocations
gt; 1 2,000 49
gt; 2 3,000 74
gt; 3 3,000 74
gt; 4 3,000 74
gt; 5 3,000 74
gt; 6 3,000 74
gt; 17,000 419
gt;
gt; Total yarding = 17,000 that is 41 hd per pen. (using 419 pens)
gt;
gt;
gt; need to allocate pens 1-443 (leaving out pens 116-124 and pens 153-167)
gt; nb
gt; these pens are large pens and are used for delivery people.
gt; Would appreciate any help
gt;
In addition to Otto's questions you say quot;(leaving out pens 116-124 and pens
153-167)quot; but do you want an Agent's sheep to be split over the excluded
pens? For example would you want 2,000 head of sheep (in 49 pens) to be
allocated to pens 100 - 115 and 125 - 158 or all allocated to only
consecutive pens?

--
Regards

Sandy
In Perth, the ancient capital of Scotland

with @tiscali.co.ukquot;Otto Moehrbachquot; gt; wrote in message
...
gt; Tyrone
gt; Please consider that of all the people that visit these newsgroups, you
gt; may well be the only person who knows anything about what you are talking
gt; about, ie, the sheep business.
gt; What is a quot;sheep drawquot;?
gt; What do mean by quot;different numbersquot;? Different numbers of what?
gt; What does quot;pen allocationsquot; mean? quot;Penquot; is understood, and quot;allocationsquot;
gt; is understood, but explain quot;pen allocationsquot; in your context.
gt; You say you are having trouble with quot;pen allocationsquot;. Explain how you
gt; would do the task of quot;pen allocationsquot; manually without Excel.
gt; What is quot;yardingquot;?
gt; Please post back with a more generic explanation of what you need help
gt; with and you will get lots of it. HTH Otto
gt; quot;tyronequot; gt; wrote in message
gt; ...
gt;gt; need to do a spreadsheet for a sheep draw. there are 6 agents that sell
gt;gt; with
gt;gt; different numbers each week. having trouble with pen allocations.
gt;gt;
gt;gt; eg spreadsheet
gt;gt;
gt;gt; agent, total head, number of pens, pen allocations
gt;gt; 1 2,000 49
gt;gt; 2 3,000 74
gt;gt; 3 3,000 74
gt;gt; 4 3,000 74
gt;gt; 5 3,000 74
gt;gt; 6 3,000 74
gt;gt; 17,000 419
gt;gt;
gt;gt; Total yarding = 17,000 that is 41 hd per pen. (using 419 pens)
gt;gt;
gt;gt;
gt;gt; need to allocate pens 1-443 (leaving out pens 116-124 and pens 153-167)
gt;gt; nb
gt;gt; these pens are large pens and are used for delivery people.
gt;gt; Would appreciate any help
gt;gt;
gt;
gt;