Excel spreadsheet for tracking expenses and income from chickens

[raizin]

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!!!!

 

[raizin]

My wife says that you have to collect one egg for the month to get it to work properly. It has something to do with me not wanting zeroes in the columns.

 

[wlhtx]

That makes sense! Since I've started filling in more and more info, it has all worked beautifully. This really is a great tool. Thanks again!

 

[dapplefoodie]

I would love a copy of Chicken tracker - Many Thanks, R. South Australia
rob dot p at internode dot on dot net

 

[raizin]

Go to my profile page, raizin, and the link is there.

 

[raizin]

The Free Chicken Tracker spreadsheets have been updated for 2014 and are available for your use. The links are on my public profile, but here they are for now.

If you use Excel, click on this link to download the Excel version: https://drive.google.com/file/d/0B7DYHxGoNHhrSm5RdHZLdENNQmc/edit?usp=sharing

If you do not have Excel or something that can open Excel spreadsheets, you can use Google Sheets for free. Click this link for the Google Sheets version: https://docs.google.com/spreadsheet/ccc?key=0ArDYHxGoNHhrdGZPbVVGMjl6N25OajUtOGNURGo3aVE&usp=sharing

As always if there are any questions, message me. Thank my wife for doing this.

Raizin

 

[PAJenn]

Would like to use your spreadsheets to start managing our coop. Your wife had done a wonderful job! I had started to create a few spreadsheets a week ago, as we want to manage our coop properly. However, I am not very skilled at creating spreadsheets. Numbers and formulas baffle me.

I have been taking a webinar series put on by the Ontario Ministry of Agriculture and Food. The webinars dealt with pest management, visitor access, food recalls etc. Really, they are all about traceability. Here in Ontario our farm has a traceability number (PPR).

Wondering about two additions to your wife's spreadsheet design? An 'Inventory Sheet' and a 'Pest Control Sheet'. The inventory sheet is valuable when filling out our Agricultural Census returns, and/or our Environmental Farm Plan. We are limited to 300 birds on the farm at any point in time, which doesn't cry out for a great deal of management. However, we are encouraged to know the source of our flock, where the birds end up, and where our eggs end up.

This is what I started with, but I lack the skills to integrate it into your wife's sheets.

Inventory Sheet
Bird ID - a number we give each bird with matching leg band
Sex
Breed
Description - physical attributes if they are a mixed breed (one of our 'projects')
Defects
Medical - information on the bird (if it was quarantined, cause of death etc)
Hatch - date if we hatched the bird on our farm
Death/Butchering - date
Processor - who processed the bird (abattoir, or on our farm)
Age at Purchase
Purchase Price
Date of Purchase
Farm / Breeder
Address
Premises Registration # (PPR) - if that farm has one
Venue - if bought at auction, where did the auction take place
Age at Sale
Sale Price
Date of Sale
Purchaser Name
Address
PPR #
Venue
Current Value of Bird - haven't worked out a formula for this yet. Should be a sliding scale for age of bird, input costs etc.

Pest Control Sheet
Date
Name and # of Device Used - i.e. rat traps, mouse traps and their location
Coop Observation - i.e. 1 rat trapped
Action Taken - i.e. emptied and reset trap and the method of disposal (we are told how this should be done by OMAFRA)
Initials - who did the task
Quarantine Observations - we maintain a separate quarantine area and thus it is treated as a separate location i.e. BLR chick has mites
Action Taken - Quarantine, dust bird and Ivermectin 4 drops, VetRx beak and legs
Initials

Do you think your wife would take a crack at adding the above? And figuring out how the numbers could work with her income and expense sheets?

PAJenn

 

[PAJenn]

One other thought about your wife's sheets. She hasn't added a column for damaged/discarded eggs with a comment to explain the loss. Maybe I missed where that data is entered? i.e. This morning I collect 2 eggs, which I tossed in the compost because 3 days ago we dusted our coop's deep bedding against mites (after inspecting birds and finding evidence). So, for the week to 10 days following treatment, I discard all of the eggs collected. Somehow that 'loss' should be calculated into the cost of producing a month's worth, and year's worth of eggs. No?

Could your wife work that into the spreadsheet?

PA Jenn

 

[JT_KROL]

Hi,
I know I'm coming in real late on this but is this spread sheet still available?

 

[Chickenlady2013]

thanks for the update, I have enjoyed this spreadsheet and find it vey useful.