Excel spreadsheet for tracking expenses and income from chickens

[raizin]

Marty,

I took a look and the problem seems to be that the monthly income calculation is based on the months in which you have egg production. Meaning that the calculation counts the months for which you have eggs. I based the whole thing on chickens that are already producing (unfortunately, I can't make your chicks actually lay *grin*).

If you want to start counting before your chicks start laying, enter the number of chicks in the Laying Hens column on the monthly tabs. Then, on the summary tab change the formula in cell G20 to read:

=IF(SUM(G4:G15)>0,SUMIF(G4:G15,">0",G4:G15)/COUNTIF(B4:B15,">0"),"")

and the formula in cell H20 to read:

=IF(SUM(H4:H15)>0,SUMIF(H4:H15,">0",H4:H15)/COUNTIF(B4:B15,">0"),"")

If you choose this, however, you'll have to go into the future months and break the link to the previous month by deleting the formula in the cell B4 to get an accurate number. This just means you'll have to enter the number of chickens you have at the beginning of each month.

At this point, we're not going to change the master, but the fix above should get you where you want to go.

Ann Marie

 

[k2chickens]

I am currently taking business classes and just finished a computer class on Mircrosoft Word my instructor gave me this website to improve my spreadsheets so I though I would share it with you!

http://office.microsoft.com/en-us/excel/FX100487621033.aspx

 

[PacsMan]

Quote:
*gasp* - I can't count my chickens (eggs) before they hatch?! argg..

So I guess my question is, will this income be counted later, when the chickens start laying in July?

 

[raizin]

It shows up in the annual total. So it is present for the year.
We did not answer the age old question of which came first the chicken or the egg

 

[Bigbear4x43]

me to i have excel 2007

 

[raizin]

Quote:
I thought I would edit this again and paste it here. I have been getting a bunch of messages that people want this. You can just go to the website and get it.
Good luck, let us know if you have any problems or ideas
Steve

 

[chicks for better health]

Quote:
i think you can also put a 0 in for the count on the earlier months and the formula will also work.

 

[Big C]

Steve,
Not an Excel guru on formulas so please bear with me.
Using the 3.1 xlxs version and my egg production costs are not carrying over to May.
When I try to download and open the 3.2 file I can't find the correct way to open and update the 3.1 file.
Please advise when you have time, and thank ya'll for what you do.

 

[raizin]

Big C,

The month sheets are independent from one another. The only place they interact is on the summary sheet at the very front of the workbook. That sheet shows and totals all activity for the year, so your costs will not carry over from month to month on the individual sheets.

The 3.2 file is a self-contained spreadsheet file. To update, you'll need to copy your data from your 3.1 file to the new 3.2 file. You should be able to cut and paste the data you entered from one file to the other. Then you can delete the old file and just work from the new one.

Ann Marie (Steve's wife).

 

[Swamp Dog]

I'm sure the spread sheet is great, but I am blown away by the farm rehab project! How cool is some of the stuff you've found?! Your great great greats would be very proud of the job you've done.

Ellen