4th Economics 101

[mmartin798]

Originally Posted by ArmySGT.

So what if I change it to turkeys and geese? Meat, feathers, grease.

10*50kg per person... 500kg of meat.

2.5*500 = 1250 kg grain to feed *10 (only 10% of the flock is consumed)= 12500kg of corn consumed as animal feed. 12500/1300= 9.6 hectares /2 = 4.8 hectares cultivated as corn for animal feed. 4.8*40 (hectares * TL D labor hours) = 192 labor hours.

10*500/115=43.8 hectares of range land. 43.8*40 (hectares*TL D hours)=1739 labor hours

192+1739 = 1931 labor hours for 500 kg of poultry.

This matches my calculations. Less work, less land, birds win for the small land squatter. Now on to the extraction part of my spreadsheet......

[mmartin798]

Sgt, just did a quick experiment for you. You could raise beef and poultry to give your ranch some variety. The numbers are not too bad. (see attached)

[ArmySGT.]

Originally Posted by mmartin798

This matches my calculations. Less work, less land, birds win for the small land squatter. Now on to the extraction part of my spreadsheet......

Have you done anything with mixing up the sources of meat?

Pigs and birds, Cows and birds?

[mmartin798]

Love it when great minds think alike....

Darn it, the calculations were not copied down. Here is the revised data. Not quite as pretty.

[mmartin798]

Took the ranch one step further and diversified the vegetables for the people and added some luxury items that can be used for fun and trade.

[ArmySGT.]

Originally Posted by mmartin798

Took the ranch one step further and diversified the vegetables for the people and added some luxury items that can be used for fun and trade.

That is pretty awesome! Are you going to autosum the tables? Let the spreadsheet take care of the tallies?

[mmartin798]

Yes, I already have that happening in the Labor and Land summary on the second page. So far my spreadsheet modifies the labor pool numbers with the attributes and does the agriculture calculations. I should be able to get the extraction numbers working by tomorrow. Once done, I will release this as a tool to the group.

I am not making a click a button and generate a settlement tool. But it should let you easily figure out what your group can and cannot do with the people they have.

I do what opinions. When I do the calculations and come up with fractional workers, like the 1.38 in the last example, should it round up to 2 or would there be someone who would spend half their time helping on the farm? It would be easy enough to not round and assume there are people that have other chores.

[ArmySGT.]

Originally Posted by mmartin798

Yes, I already have that happening in the Labor and Land summary on the second page. So far my spreadsheet modifies the labor pool numbers with the attributes and does the agriculture calculations. I should be able to get the extraction numbers working by tomorrow. Once done, I will release this as a tool to the group.

I am not making a click a button and generate a settlement tool. But it should let you easily figure out what your group can and cannot do with the people they have.

I do what opinions. When I do the calculations and come up with fractional workers, like the 1.38 in the last example, should it round up to 2 or would there be someone who would spend half their time helping on the farm? It would be easy enough to not round and assume there are people that have other chores.

I have so far been rounding fractional number up to a whole. I can't help thinking that the task is necessary.