Excel spreadsheet for tracking expenses and income from chickens

[alachickenman]

Well tell her I said thank you! Gracias!

 

[raizin]

I had her sit down and read all the responses. She has been doing this for a while and the kudos are great. Glad it is working for everyone. raizin.

 

[Mehjr10]

Hi, This is a great sheet and allot of hard work has gone into it.. Thanks it has save me a bunch. One question have you done one for flock management?

That could be added to this?

I found one on another site but would be convenient to have them together.

Added as a tab.

Birds Band/ID Tag Breed Sex Hatch Date Wormed Date Spr Fall Other Meds Notes

1​

2​

3​

4​

5​

6​

Well that does not look as good as on the sheet.

Thanks

Mitch

 

[raizin]

We don't manage our flock like that. My tech expert says that would require database functionality. She's not doing it.

Raizin

 

[raizin]

I found some things I missed in the review of the revised spreadsheet. Ann Marie fixed it and added cost per dozen fields. New files are available at the links below.

Excel: https://docs.google.com/file/d/0B7DYHxGoNHhrX3RDN2E2NlBTVXc/edit?usp=sharing

Google Sheets: https://docs.google.com/spreadsheet/ccc?key=0ArDYHxGoNHhrdEotNC1ia0Z5NnNkOTZMRzQ4S24ySlE&usp=sharing

Sorry I didn't catch it earlier. I only update quarterly. For future reference the links are on my profile now.

Raizin

 

[Mehjr10]

We don't manage our flock like that. My tech expert says that would require database functionality. She's not doing it.

Raizin

No problem, Tell you tech expert great work !

 

[rocking chicks]

Hi;

I downloaded your wonderful spreadsheet and would like to know how do I install the updates.

Thank you very much!

MW

 

[raizin]

It is a new spreadsheet every year. So it is not updatable. I just save every years and compare them manually. You could cut and paste from previous years into the new years also, but you need to make sure the columns are aligned when you do it. Sorry, eventually I and my wife will quit thinking of things to add and it will be the same year to year. I think we are almost there. Annmarie thought up the feed cost/dozen eggs and total cost/dozen eggs this year! it is scary, very scary, but it does help when you are figuring out how much the chickens cost you and if you want to charge money for the eggs. Good luck, and happy egg collecting, Raizin.

 

[raizin]

I only input data on a quarterly basis so I was a little behind the times. If you just subscribe to this thread I post the new spreadsheets at the beginning of the year and you can just download the new one for the year. My wife also put the links on my profile so you can just go to my profile and download the google docs version or the excel version. It is a handy tool, and pretty much covers a broad spectrum of users now. You can use as little or most of the spreadsheet you want and it is easy to input data. Have fun.

 

[wlhtx]

I've just discovered this. May I just say that I think your wife is a genius. Who would have ever thought I would/could be so EXCITED about a spreadsheet?! This is he one question I'm running into though: regarding flock losses, I lost one layer last week and when I put the "1" in the appropriate cell (based on day of the month and cause of death), the Flock Loss Summary at the very bottom of the page does not update. The total (line 35) updates, but total summary (line 43) stays blank. Shouldn't cell K43 auto update to show my one? I've tried putting zeroes in the other cells to see if that was necessary (which it appears not to be).

UPDATE: Before posting this I decided to play with a different month. I was previously trying to record my loss in April (which wasn't working as I believe is intended), but May does work. I then flipped through all the cells and think that maybe May is the only month that is formulated correctly to show he summary totals. You may just want to double check this.

Thanks again!!!!