Quantcast

Inspection spreadsheet

Beekeeping Forum

Help Support Beekeeping Forum:

BigAshW 

New Bee
Joined
Oct 29, 2013
Messages
85
Reaction score
10
Location
Romford
Hive Type
commercial
Number of Hives
1
Had a quiet evening so thought I'd finally finish off this spreadsheet. It works through Google docs and so is linked to my Google drive. That means it automatically saves to the cloud every time it's changed.

The format is based around the bbka inspection record but I've created drop down menus for most of the columns barring date, honey production and notes.

This means that I can easily use a stylus on my tablet to quickly tap data in without getting the screen covered.

As it's a spreadsheet I can also harvest data from each colony to look at queen selection and apiary averages etc.

My records stay with the queen so the apiary and hive number are also drop down menus as well. IMG_20201024_184403.jpg
 

masterBK 

Queen Bee
Joined
Oct 20, 2009
Messages
2,133
Reaction score
57
Location
S Yorkshire
Hive Type
national
Number of Hives
wintering 30 + 2 polynucs
How do you keep the propolis etc off the tablet when using it in the apiary?
 

BigAshW 

New Bee
Joined
Oct 29, 2013
Messages
85
Reaction score
10
Location
Romford
Hive Type
commercial
Number of Hives
1
How do you keep the propolis etc off the tablet when using it in the apiary?
That's why I've adapted the spreadsheet to use a stylus. The hope is that keeping the tablet in a case and using a stylus will negate or substantially reduce any need to touch the screen.
 
Joined
Oct 16, 2012
Messages
11,207
Reaction score
1,004
Location
Fareham, Hampshire UK
Hive Type
14x12
Number of Hives
6
That's why I've adapted the spreadsheet to use a stylus. The hope is that keeping the tablet in a case and using a stylus will negate or substantially reduce any need to touch the screen.
Good luck with that ... I've found that propolis gets everywhere and the things it gravitates to most are phones and cameras .... I suppose that you can wash a stylus in a bucket of washing soda but I would worry about the tablet ....and its case.... and jts screen ...
 
Joined
May 17, 2010
Messages
1,374
Reaction score
71
Location
Aberdeenshire, Scotland
Hive Type
national
Number of Hives
45
I’ve mentioned this on a previous thread: I use an app on my phone. Any propolis on the phone can just be wiped off easily.
PS: The casing is plastic. I suppose a leather casing might be a bit more vulnerable.
 

elainemary 

House Bee
Joined
Jun 1, 2019
Messages
172
Reaction score
175
Location
Yorkshire
Hive Type
wbc
Number of Hives
10
I use a similar spreadsheet, find it invaluable. I have tabs for goals for the year, learning, honey yields, winter feeding summaries, queen rearing timetables across apiaries etc. I know a bit anal but I love analysis!
I take a small hardbacked notebook that I pre rule to fill in the data then transpose onto the spready on my Mac back home.

Know it means doing twice but I quickly fill in key numbers & keep some of the notes in my head then fill it in more thoroughly that evening. The notebook is covered in propolis & washing soda by the end of the year and my Mac stays in pukka condition!

Elaine
 

The Poot 

House Bee
Joined
Feb 15, 2015
Messages
197
Reaction score
132
Location
Dorset
Hive Type
national
Number of Hives
4
Had a quiet evening so thought I'd finally finish off this spreadsheet. It works through Google docs and so is linked to my Google drive. That means it automatically saves to the cloud every time it's changed.

The format is based around the bbka inspection record but I've created drop down menus for most of the columns barring date, honey production and notes.

This means that I can easily use a stylus on my tablet to quickly tap data in without getting the screen covered.

As it's a spreadsheet I can also harvest data from each colony to look at queen selection and apiary averages etc.

My records stay with the queen so the apiary and hive number are also drop down menus as well. View attachment 22723
I see the column headed “run” is for movement on the comb, not movement of the beekeeper!🤪
Impressive and I must do something similar for next year. Good one.
 

Murox 

Queen Bee
Joined
Aug 31, 2017
Messages
2,233
Reaction score
383
Location
Campbeltown Scotland
Hive Type
other
If I was inclined to write records onto a phone or computer at the hive side I would just find/buy a suitably plasticy cheap second hand model and use it expressly for that purpose. It hasn't got to run much in the way of apps. and if its capable of taking the odd photo then thats a bonus, as long as it can hold info and is able to talk/share to another machine thats it. Of course you can also get proper covers for tablets etc which are designed for use in odd "gunngy" situations.
 

BigAshW 

New Bee
Joined
Oct 29, 2013
Messages
85
Reaction score
10
Location
Romford
Hive Type
commercial
Number of Hives
1
This
If I was inclined to write records onto a phone or computer at the hive side I would just find/buy a suitably plasticy cheap second hand model and use it expressly for that purpose. It hasn't got to run much in the way of apps. and if its capable of taking the odd photo then thats a bonus, as long as it can hold info and is able to talk/share to another machine thats it. Of course you can also get proper covers for tablets etc which are designed for use in odd "gunngy" situations.
This is essentially what I plan to do. A cheap tablet that I can hotspot to my phone to upload to the cloud.
 

Erichalfbee 

Super Moderator
Staff member
Moderator
Joined
Jul 23, 2009
Messages
19,416
Reaction score
1,358
Location
Ceredigion
Hive Type
14x12
Number of Hives
7
I use my old phone when I upgrade.
 

RichardBeeW 

New Bee
Joined
Mar 28, 2020
Messages
63
Reaction score
32
Location
Mid-Wales
Hive Type
national
Number of Hives
Four but wishing to build to six with a number of nucs as support colonies
I use a similar spreadsheet, find it invaluable. I have tabs for goals for the year, learning, honey yields, winter feeding summaries, queen rearing timetables across apiaries etc. I know a bit anal but I love analysis!
I take a small hardbacked notebook that I pre rule to fill in the data then transpose onto the spready on my Mac back home.

Know it means doing twice but I quickly fill in key numbers & keep some of the notes in my head then fill it in more thoroughly that evening. The notebook is covered in propolis & washing soda by the end of the year and my Mac stays in pukka condition!

Elaine
@BigAshW and Elaine - I think you are both taking this too far! I also think I would fit right in with you both 😁😁😁 and will end up attempting (and probably failing) to produce something equally comprehensive. 😎😎😎
 

elainemary 

House Bee
Joined
Jun 1, 2019
Messages
172
Reaction score
175
Location
Yorkshire
Hive Type
wbc
Number of Hives
10
@BigAshW and Elaine - I think you are both taking this too far! I also think I would fit right in with you both 😁😁😁 and will end up attempting (and probably failing) to produce something equally comprehensive. 😎😎😎
Here’s shots of some of my spreadsheets, might expand further next season to take on board some of BigAsh headings
1.Overall summary of colony performance for the year
2.Example record card by colony. Won’t attempt to explain my abbreviations but you’ll get the gist
3.How I record and keep tabs on winter feeding
4.Queen rearing timetable With key dates & what to do when

What was that about needing a psychologist 🤣 Works for me🐝
 

Attachments

elainemary 

House Bee
Joined
Jun 1, 2019
Messages
172
Reaction score
175
Location
Yorkshire
Hive Type
wbc
Number of Hives
10
Here’s shots of some of my spreadsheets, might expand further next season to take on board some of BigAsh headings
1.Overall summary of colony performance for the year
2.Example record card by colony. Won’t attempt to explain my abbreviations but you’ll get the gist
3.How I record and keep tabs on winter feeding
4.Queen rearing timetable With key dates & what to do when

What was that about needing a psychologist 🤣 Works for me🐝
Plus example of a page from my trusty apiary notebook - note the propolis!
 

Attachments

Latest posts

Top