Help Making an Egg Laying Spreadsheet

Discussion in 'Managing Your Flock' started by ArXane, Feb 4, 2016.

  1. ArXane

    ArXane Out Of The Brooder

    21
    0
    22
    Feb 4, 2016
    I have very basic spreadsheet skills, would like some help, or if somebody already has something setup like this?


    For the last 9 months we have been tracking total brown eggs, and total green eggs. Sometimes we skip a day.

    This is what we would like to have on the spreadsheet
    Day
    Total Brown
    Total Green
    Total Brown and Green
    Number of Laying Hens


    With this info, we want to be able to see a chart that shows averages per week or month. Average count per week day; ie, Mondays have the highest average.

    The information would change as we loose hens to predators/death or our hens start laying.


    Does anybody already have something like this?

    Thanks.
     
  2. aart

    aart Chicken Juggler! Premium Member

    35,765
    9,263
    656
    Nov 27, 2012
    SW Michigan
    My Coop
    I use a spreadsheet(s) that I cobbled together myself that tracks feed costs, daily eggs laid, eggs sales and also record a bunch of notes on other aspects of chicken keeping in the file. Some worksheets are linked, many are not.

    I say cobbled because I'm no excel expert myself, but not sure you can generate a 'chart' from a spreadsheet.

    I see you're new here, Welcome to BYC!
    Try the advanced search feature to search BYC for the info you are looking for, you'lll still have to do alot of reading to wade thru unhelpful info.

    I'l get you started:
    Advanced Search>Titles Only>spread sheet
    Click that link, there's a couple of threads about record keeping.
    Try some other search terms, like 'records'.....
    ...someone out there put up a rather involved spreadsheet that they shared freely,
    it was too complicated and did not contain what I wanted to track, so I made my own.
     
  3. ArXane

    ArXane Out Of The Brooder

    21
    0
    22
    Feb 4, 2016
    I dont really need all those, but ill do the search again. Thanks.
     
  4. chicklover 1998

    chicklover 1998 Chillin' With My Peeps

    1,615
    99
    118
    Sep 30, 2015
    Oskaloosa,Ia
    Welcome to BYC. Are you asking for help setting one up or.....
     
  5. ArXane

    ArXane Out Of The Brooder

    21
    0
    22
    Feb 4, 2016
  6. ArXane

    ArXane Out Of The Brooder

    21
    0
    22
    Feb 4, 2016
    Somehow my post just got deleted, I shared a link to my Google Sheet. But yes, I need help setting it up, or examples. Im looking through the searches, this forum search results are messy.
     
  7. chicklover 1998

    chicklover 1998 Chillin' With My Peeps

    1,615
    99
    118
    Sep 30, 2015
    Oskaloosa,Ia
    yes they are messy and I've had some of mine do that too but I just blame it on the computer. could you reshare that link?
     
  8. ArXane

    ArXane Out Of The Brooder

    21
    0
    22
    Feb 4, 2016
  9. ArXane

    ArXane Out Of The Brooder

    21
    0
    22
    Feb 4, 2016
    Nope, I dont have permission to post links apparently. Ill try to message it to you.
     
  10. aart

    aart Chicken Juggler! Premium Member

    35,765
    9,263
    656
    Nov 27, 2012
    SW Michigan
    My Coop
     

BackYard Chickens is proudly sponsored by