Results 1 to 17 of 17
  1. #1
    Join Date
    Dec 2008
    Location
    Solano, California, USA
    Posts
    1,301

    Question Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Anyone out there willing to share their "copies" of time and expense sheets used to manage "help" doing field work?

    Looking for ideas for layouts / categories other beeks use.

  2. #2
    Join Date
    May 2010
    Location
    Spokane, Washington, USA
    Posts
    712

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    hivetracks.com helps keep track of hives...

    I am thinking of getting an ipad and going with beetight.com. They have an option where you put a printable bar-code on each hive and scan with your smartphone or ipad...

  3. #3
    Join Date
    Dec 2005
    Location
    Brasher Falls, NY, USA
    Posts
    26,584

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    I'm probably behind the times, I know I'm disorganized and don't have employees, but, do Commercial Beekeepers use the things y'all are writing about? No one I know does. Honey-4-All, you must be running quite a few hives, I'm guessing.

    I don't see, in my mind, anyone keeping track of hives. Not indoiviodual hives. Unless they are selecting for queen rearing maybe.
    Mark Berninghausen "That which works, persists."

  4. #4
    Join Date
    Dec 2006
    Location
    St. Albans, Vermont
    Posts
    5,305

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Quote Originally Posted by sqkcrk View Post
    I don't see, in my mind, anyone keeping track of hives. Not indoiviodual hives. Unless they are selecting for queen rearing maybe.
    Bingo!

  5. #5
    Join Date
    Feb 2006
    Location
    Herrick, SD USA
    Posts
    4,308

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Quote Originally Posted by sqkcrk View Post
    I don't see, in my mind, anyone keeping track of hives. Not indoiviodual hives. Unless they are selecting for queen rearing maybe.
    I am with you on this as well. We do have our own set of hieroglyphics scribbled on the fronts of the hives that we use to mark potential breeders and any other hives that bear watching. A 5"x7" spiral notebook is my most indispensable record keeping tool for our spring cell raising and nucing operations. One such notebook with some handy bookmarks has plenty of room to write anything of note including a daily diary and is still small enough to fit in your back pocket. In it I keep track of everything from cells grafted/accepted to a running diary of everything done on a particular day, I also keep the previous years' handy as a reference. I feel I am a reasonably tech savvy kind of guy but I really can't imagine any electronic device that could be as useful and still be able to survive the beeswax, propolis, honey, syrup and bee poop that it would be exposed to. For summer honey production in the north we work off of a large poster board on the wall of the honey house with all the locations listed geographically where we record the date and activity for each location and is updated on a daily basis. Pretty simple, straightforward and large enough for several people to stand around and look at as we discuss what the highest priorities for the day are.
    "People will generally accept facts as truth only if the facts agree with what they already believe."- Andy Rooney

  6. #6
    Join Date
    Dec 2008
    Location
    Menomonee Falls, Wis.
    Posts
    2,652

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    SQKCRK wrote:

    I don't see, in my mind, anyone keeping track of hives. Not indoiviodual hives. Unless they are selecting for queen rearing maybe.

    Although we have been using lumber crayoons for 70? years to right on the roofs, in recent years we have increased the range of data recorded, and have found it to be of value. We have noted some minor patterns with the added data that where not noted before. I have spoken with Sheri on this subject, and believe for SOME, the value of the information might justify the cost of a more advanced system.

    Crazy Roland

  7. #7
    Join Date
    Dec 2005
    Location
    Brasher Falls, NY, USA
    Posts
    26,584

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Don't get me wrong. I'm sure that modern means of record keeping would be of some benefit to some beekeepers and it's the newer beekeepers who will and should blaze the way. I just don't keep those sorts of records.

    Theyu could be interesting to someone else in the future, if they could access them. There is no problem accessing the notebooks I have, which I no longer spend much time making notes in.
    Mark Berninghausen "That which works, persists."

  8. #8
    Join Date
    Nov 2008
    Location
    Grand Rapids, Ohio
    Posts
    860

    Cool Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    The scan and track would save time an money. No sence running hive in yard that under produce. Right now I do the paper work in the yard and then add it to computer when I get back to the shop. I do a 7 year honey tracking every few years to find out if I keep or close the yards.
    Just think if you could just increase honey production of just 5 lb a hive. WOW thats only another 2 ton. Even in a small operation like mine, I can see it paying for itself in just a season.

  9. #9
    Join Date
    Jan 2011
    Location
    Great Falls Montana
    Posts
    3,865

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    If you are operating commercially, I think the object is to make the colonies all alike, so that operations are performed on the same day in the same way, so individual recordkeeping wouldn't serve as much pupose that the lumber crayon can't take care of. I think yards that under perform are mentally noted every trip out until you have had enough and move off it. A good record of what your yards produce is the more important thing to track. Manage your make and break areas and decide if your machinery and its software are an affordable deductible and not an impulse buy like the ones I regularly fly into.

  10. #10
    Join Date
    Feb 2006
    Location
    Herrick, SD USA
    Posts
    4,308

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Quote Originally Posted by Vance G View Post
    If you are operating commercially, I think the object is to make the colonies all alike, so that operations are performed on the same day in the same way, so individual recordkeeping wouldn't serve as much pupose that the lumber crayon can't take care of. I think yards that under perform are mentally noted every trip out until you have had enough and move off it. A good record of what your yards produce is the more important thing to track. .
    You stole the words right off my keyboard
    "People will generally accept facts as truth only if the facts agree with what they already believe."- Andy Rooney

  11. #11
    Join Date
    Dec 2005
    Location
    Brasher Falls, NY, USA
    Posts
    26,584

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Psychic plagerism is not a crime. Yet.
    Mark Berninghausen "That which works, persists."

  12. #12
    Join Date
    Jan 2003
    Location
    Manitoba Canada
    Posts
    5,834

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    PM me with spicifics
    Ian Steppler >> Canadian Beekeeper's Blog
    www.stepplerfarms.com

  13. #13
    Join Date
    May 2010
    Location
    Spokane, Washington, USA
    Posts
    712

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    New Zealand (Blaycliff Apiaries) use electronic tracking.

    Very interesting... I use paper... Mainly to know which queens perform the best so I could breed from them.

    http://blaycliff.onlinenz.net/why%20...qualitycontrol

  14. #14
    Join Date
    Jun 2009
    Location
    Montgomery County, NY
    Posts
    1,687

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    I do think tracking with a computer comes in handy but not for day to day in the field use. In fact most these devices (smart phones, Ipads, whatever else they come up with next) are too sensative to actually be out in a bee yard with me all day long. They are too expense as well. My wife's Ipad just cost 700 bucks. I couldn't afford to run that over with the skidsteer cause if fell on the ground or have the screen ruined by forgetting it on a hive in the sun.

    However I am writing a database and application to help us track our inventory of bottles and how much we should plan for in the next delivery of honey to our stores to make sure that process runs smooth. When I am done we will also be able to utilize it to track our income based on honey sales for tax season. This will greatly expedite our efforts as well as track sales trends to possibly drop or pickup more stores in a specific geographic location depending on the cash flow that area produces for us.

    As far as the beeyards. I know which yards produce and dont produce. I also know which ones would be possible queen producing colonies with just simple scribbling on outisde of boxes along with a few paint spots here and there. Though I don't run very many.

  15. #15
    Join Date
    Jan 2011
    Location
    Great Falls Montana
    Posts
    3,865

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Sorry for the plagarism Mr. Lyon! Have you posted that thought before here? I am on heart meds that should be called lobotomy in a bottle and possibly I done you wrong by remembering your thoughts right! Does that make it a bad idea??? I must be going to the dark side:<}

  16. #16
    Join Date
    Feb 2006
    Location
    Herrick, SD USA
    Posts
    4,308

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Quote Originally Posted by Vance G View Post
    Sorry for the plagarism Mr. Lyon! Have you posted that thought before here? I am on heart meds that should be called lobotomy in a bottle and possibly I done you wrong by remembering your thoughts right! Does that make it a bad idea??? I must be going to the dark side:<}
    Too late the wheels of justice are already turning Actually it was a complement Vance but then I think you already knew that.
    "People will generally accept facts as truth only if the facts agree with what they already believe."- Andy Rooney

  17. #17
    Join Date
    Jan 2011
    Location
    Great Falls Montana
    Posts
    3,865

    Default Re: Excel "beekeeping" Spreadsheet for managing "help" time and field expenses?

    Thanks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Ads