A new, simplified way of calculating pest activity was presented by Jane Henderson and I at the recent 2019 IPM Conference in Stockholm. The paper will be published in September as far as I am aware, but our template spreadsheet is already live and available for to download for free on this permalink *https://museum.wales/media/45874/Pest-Record-Datasheets-NMC-Template-2018.xlsx* <https://museum.wales/media/45874/Pest-Record-Datasheets-NMC-Template-2018.xlsx>.
The reason why we chose Excel as a vehicle for this is because Excel is widely available and does not incur any additional cost, such as specialised software like ZPest etc would, and also allows people with restrictive IT policies to access a dedicated yet easily modifiable programme for recording and analysing complex pest monitoring data. Caroline asked a question about the number of traps per room – of course the size of the room monitored and the number of traps deployed affects the number of pests caught but is not considered sufficiently during most monitoring programmes. Our template datasheet with embedded calculations does account specifically for this, allowing meaningful comparisons of pest activity between rooms, buildings and sites with different numbers of pest monitors and rooms/buildings of different size and use. Adrian talked about conditional formatting – this is an invaluable tool and our database template does that, too, in order to highlight areas of increased pest activity (using a simple traffic light colour coding system). Best regards Christian Dr Christian Baars AMA ACR Senior Preventive Conservator National Museum Cardiff [image: The Curation and Care of Museum Collections Banner] On Friday, July 19, 2019 at 5:08:24 PM UTC+1, jdavis wrote: > > Wonderful, Thank you everyone! > > James Davis > Director of the Bindery/Rare Book Conservator > (843) 723-9912 > > > > > On Thu, Jul 18, 2019 at 10:57 AM Alan P Van Dyke <[email protected] > <javascript:>> wrote: > >> Here's an example of the spreadsheet I use. It's just for a part of the >> building. There's a lot I plan to cut out of it when I revise it. >> >> Alan >> >> >> *Alan Van Dyke * >> Senior Preservation Technician >> Harry Ransom Center >> The University of Texas at Austin >> P.O. Drawer 7219 >> Austin, TX 78713-7219 >> P: 512-232-4614 >> www.hrc.utexas.edu >> >> >> On Thu, Jul 18, 2019 at 9:11 AM 'Adrian Doyle' via Museumpests < >> [email protected] <javascript:>> wrote: >> >>> Dear all >>> >>> This is our version (split into two) >>> >>> Adie Doyle >>> >>> >>> >>> Mr Adrian (Adie) Doyle >>> >>> Integrated Pest Management Manager >>> >>> British Museum >>> >>> Property & Facilities Management >>> >>> Great Russell Street, >>> >>> London WC1B 3DG >>> >>> >>> >>> Tel: 020 7323 8207 >>> >>> Mobile 07813 363292 >>> >>> Also available by Radio >>> >>> >>> >>> Email: [email protected] <javascript:> >>> >>> >>> >>> *The British Museum* >>> >>> Great Russell Street, London WC1B 3DG >>> >>> britishmuseum.org <http://www.britishmuseum.org/> >>> >>> >>> >>> *The security classification for this message is OFFICIAL* >>> >>> >>> >>> >>> >>> >>> >>> *Intentionally Blank* >>> >>> Monitoring Arrangement: R,E,M >>> >>> Active of Retired >>> >>> Monthly or Quarterly >>> >>> Monitoring Dept >>> >>> Collection Dept >>> >>> Collections Manager, Assistant collections manager, individual, division >>> or contractor >>> >>> Acces Contact (if required) >>> >>> Trap # >>> >>> Trap Type >>> >>> Room Type: G, S, L, SR, NCA >>> >>> Ambient, Case, Undercase, cupboard Underfloor, riser, plant room, >>> >>> events location Y/N >>> >>> Fire Sector >>> >>> Floor >>> >>> Room Number >>> >>> Unique Room ID >>> >>> *Environmental Monitoring Y/N* >>> >>> Room Name >>> >>> *Detailed Trap Location* >>> >>> Insect Risk Rating >>> >>> Rodent Risk Rating >>> >>> Trap Number >>> >>> >>> >>> *intentionally blank* >>> >>> Missing / inaccessible / not collected >>> >>> *intentionally blank* >>> >>> Trap Clear (Mark Yes as 1) >>> >>> Varied carpet beetle ADULT >>> >>> Guernsey carpet beetle ADULT >>> >>> Biscuit beetle >>> >>> Vodka beetle ADULT >>> >>> Anthrenus Larva >>> >>> Attagenus Larve >>> >>> webbing clothes moth >>> >>> Case-bearing clothes moth >>> >>> Monopis moth >>> >>> unidentified Moth LARVA >>> >>> Booklice >>> >>> Silverfish/Firebrat >>> >>> Other pest (note the pest in the remarks column >>> >>> April 2019 Remarks >>> (trap Missing / inaccessible / not collected, trap damaged, trap left in >>> place for another quarter, lots of any particular non-pest species, >>> anything else unusual).* Note Grey Silverfish* >>> >>> >>> >>> >>> >>> *From:* [email protected] <javascript:> <[email protected] >>> <javascript:>> *On Behalf Of *Matthew Mickletz >>> *Sent:* Thursday, July 18, 2019 1:00 PM >>> *To:* [email protected] <javascript:> >>> *Subject:* RE: [Non-DoD Source] [pestlist] Bug tracking software/program >>> >>> >>> >>> >>> >>> Hi James, >>> >>> >>> >>> We currently use a spreadsheet, however I’d like to try out ZPest soon! >>> >>> >>> >>> Here’s a screen shot (Hope this goes through OK, if not I’ll try again >>> with an attachment.) >>> >>> >>> >>> >>> >>> >>> >>> Notes: >>> >>> >>> >>> - It’s set up this way in terms of the “Condition 1 and Condition 2” >>> Columns so we could potentially send the data into another program >>> someday; >>> we were hoping Emu, but the funds fell away. >>> - “Species” and “Group” columns are pull downs to help eliminate >>> spelling errors primarily, and limit choices so we don’t have >>> off-the-wall >>> entries of “new” pests and any new species must be confirmed by me >>> before >>> adding to the list. >>> >>> >>> >>> Happy to explain any other details. >>> >>> >>> >>> Matt >>> >>> >>> >>> >>> >>> *Matthew A. Mickletz* >>> >>> Manager Preventive Conservation >>> >>> Winterthur Museum, Garden & Library >>> >>> Direct 302.888.4752 >>> >>> 5105 Kennett Pike >>> >>> Winterthur, DE 19735 >>> >>> Winterthur.org <http://www.winterthur.org/> >>> >>> >>> >>> >>> >>> *From:* [email protected] <javascript:> [ >>> mailto:[email protected] <javascript:>] *On Behalf Of *James Davis >>> *Sent:* Wednesday, July 17, 2019 4:18 PM >>> *To:* [email protected] <javascript:> >>> *Subject:* Re: [Non-DoD Source] [pestlist] Bug tracking software/program >>> >>> >>> >>> It would be very helpful if someone had an excel/google sheets template >>> that could be shared as an example. I know OP asked for alternatives to >>> spreadsheets, but I'd be glad just to have that! >>> >>> >>> James Davis >>> Director of the Bindery/Rare Book Conservator >>> (843) 723-9912 >>> >>> >>> >>> >>> >>> >>> >>> On Wed, Jul 17, 2019 at 5:43 AM 'Adrian Doyle' via Museumpests < >>> [email protected] <javascript:>> wrote: >>> >>> Dear all >>> >>> We have a standard for the type of collection and the decision on the >>> number of traps is based on this >>> >>> Regarding room size, we are still working on this as a concept as it >>> also needs to take into account the shape of the store >>> >>> For a category A room minimum of 2 floor / blunder traps and a minimum >>> of 1 AF (webbing clothes moth trap). We are woking on standards for >>> different room categories ( especially category A ) for example these >>> category stores are monitored for humidity and temperature with our >>> environmental monitoring system, have an annual clean etc >>> >>> I will sort out a clean sample of our database as soon as I can >>> >>> Adie >>> >>> >>> >>> >>> >>> Mr Adrian (Adie) Doyle >>> >>> Integrated Pest Management Manager >>> >>> British Museum >>> >>> Property & Facilities Management >>> >>> Great Russell Street, >>> >>> London WC1B 3DG >>> >>> >>> >>> Tel: 020 7323 8207 >>> >>> Mobile 07813 363292 >>> >>> Also available by Radio >>> >>> >>> >>> Email: [email protected] <javascript:> >>> >>> >>> >>> *The British Museum* >>> >>> Great Russell Street, London WC1B 3DG >>> >>> britishmuseum.org <http://www.britishmuseum.org/> >>> >>> >>> >>> *The security classification for this message is OFFICIAL* >>> >>> >>> >>> >>> >>> >>> >>> *From:* 'De Stefani, Caroline' via Museumpests <[email protected] >>> <javascript:>> >>> *Sent:* Wednesday, July 17, 2019 9:34 AM >>> *To:* [email protected] <javascript:> >>> *Subject:* RE: [Non-DoD Source] [pestlist] Bug tracking software/program >>> >>> >>> >>> Hi All, >>> >>> I also would be interested in seeing the database, please can you send >>> me a sample? >>> >>> Can I ask how you decide the number of traps to place in a strong room? >>> Is it related to the size of the room? >>> >>> Thanks >>> >>> Caroline >>> >>> >>> >>> *From:* 'Adrian Doyle' via Museumpests <[email protected] >>> <javascript:>> >>> *Sent:* 17 July 2019 09:24 >>> *To:* [email protected] <javascript:> >>> *Subject:* RE: [Non-DoD Source] [pestlist] Bug tracking software/program >>> >>> >>> >>> Dear all >>> >>> Have you considered using conditional formatting (CF) in an excel >>> spreadsheet based on the threat level (ie IPM risk) verses the catch number >>> >>> Eg we have a spreadsheet which has the IPM risk A (highly munchable) to >>> D – Low risk colour coded >>> >>> For the High risk the Cf is set at 5 catches for Webbing clothes moth >>> whereas in a low risk area D- the CF level is set at 10 >>> >>> When the data is input, the colour changes >>> >>> The National Trust have a very effective IPM database and like Megan, I >>> can send a sample of our database for you to play with >>> >>> Adie Doyle >>> >>> >>> >>> Mr Adrian (Adie) Doyle >>> >>> Integrated Pest Management Manager >>> >>> British Museum >>> >>> Property & Facilities Management >>> >>> Great Russell Street, >>> >>> London WC1B 3DG >>> >>> >>> >>> Tel: 020 7323 8207 >>> >>> Mobile 07813 363292 >>> >>> Also available by Radio >>> >>> >>> >>> Email: [email protected] <javascript:> >>> >>> >>> >>> *The British Museum* >>> >>> Great Russell Street, London WC1B 3DG >>> >>> britishmuseum.org <http://www.britishmuseum.org/> >>> >>> >>> >>> *The security classification for this message is OFFICIAL* >>> >>> >>> >>> >>> >>> *From:* [email protected] <javascript:> <[email protected] >>> <javascript:>> *On Behalf Of *Jablonski, Megan T CIV USN (US) >>> *Sent:* Tuesday, July 16, 2019 5:29 PM >>> *To:* [email protected] <javascript:> >>> *Subject:* RE: [Non-DoD Source] [pestlist] Bug tracking software/program >>> >>> >>> >>> We’re not allowed to download programs onto our computers, so I’ve had >>> to make do with an Access database that I put together myself. I designed >>> the database to help me track pests based on their threat level to >>> collections. I then use the report feature to summarize the problem areas >>> of our museum as well as the quantity and type of moderate and high risk >>> pests. I would be happy to share the database with you if you’re interested! >>> >>> >>> >>> You can email me at [email protected] <javascript:> if you’d like me >>> to send you a copy. >>> >>> >>> >>> Megan Jablonski >>> >>> Collections Manager >>> >>> Puget Sound Navy Museum >>> >>> Naval History & Heritage Command >>> >>> 251 1st Street >>> >>> Bremerton, WA 98337 >>> >>> p. (360) 627-2288 >>> >>> f. (360) 627-2273 >>> >>> >>> >>> www.PugetSoundNavyMuseum.org >>> >>> www.history.navy.mil/PSNM >>> >>> www.facebook.com/pugetsoundnavymuseum >>> >>> >>> >>> >>> >>> >>> >>> *From:* [email protected] <javascript:> <[email protected] >>> <javascript:>> *On Behalf Of *Heather L Parks >>> *Sent:* Tuesday, July 16, 2019 9:11 AM >>> *To:* [email protected] <javascript:> >>> *Subject:* [Non-DoD Source] [pestlist] Bug tracking software/program >>> >>> >>> >>> Hello, >>> >>> >>> >>> Over the course of 2019 Binghamton University has been tracking the bugs >>> in our 4 library buildings. We initially used a basic Google spreadsheet, >>> but as data is coming in every week, the spreadsheet isn't as wonderful an >>> option as I initially thought mainly due to it's size. A program that >>> might help us identify trends would be ideal, but as of now, the >>> spreadsheet is so unwieldy that that process will be incredibly time >>> consuming. Do any of you use or know of other options we might use to track >>> our creepy crawlies? >>> >>> >>> >>> Thanks, >>> >>> -- >>> >>> Heather Parks >>> >>> Head of Preservation >>> >>> Binghamton University Libraries >>> >>> 607-777-6207 >>> >>> [email protected] <javascript:> >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/CAG7-LDT933Tr39%3DyxTL-3q3vcFat_CX%3DhCQyib1qwQbCd2xNNA%40mail.gmail.com >>> >>> <https://groups.google.com/d/msgid/pestlist/CAG7-LDT933Tr39%3DyxTL-3q3vcFat_CX%3DhCQyib1qwQbCd2xNNA%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/40CEEC56A9AF9C448154CC0865F933C979887C1A%40NAWESDNIXM06V.nadsuswe.nads.navy.mil >>> >>> <https://groups.google.com/d/msgid/pestlist/40CEEC56A9AF9C448154CC0865F933C979887C1A%40NAWESDNIXM06V.nadsuswe.nads.navy.mil?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/DB6PR0201MB2389BCDC5F159597E246906CDDC90%40DB6PR0201MB2389.eurprd02.prod.outlook.com >>> >>> <https://groups.google.com/d/msgid/pestlist/DB6PR0201MB2389BCDC5F159597E246906CDDC90%40DB6PR0201MB2389.eurprd02.prod.outlook.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> THIS E-MAIL AND ANY ATTACHED FILES ARE CONFIDENTIAL AND MAY BE LEGALLY >>> PRIVILEGED. If you are not the addressee, any disclosure, reproduction, >>> copying, distribution or other dissemination or use of this communication >>> is strictly prohibited. If you have received this transmission in error >>> please notify the sender immediately and then delete this e-mail. Opinions, >>> advice or facts included in this message are given without any warranties >>> or intention to enter into a contractual relationship with the City of >>> London unless specifically indicated otherwise by agreement, letter or >>> facsimile signed by a City of London authorised signatory. Any part of this >>> e-mail which is purely personal in nature is not authorised by the City of >>> London. All e-mail through the City of London's gateway is potentially the >>> subject of monitoring. All liability for errors and viruses is excluded. >>> Please note that in so far as the City of London falls within the scope of >>> the Freedom of Information Act 2000 or the Environmental Information >>> Regulations 2004, it may need to disclose this e-mail. Website: >>> http://www.cityoflondon.gov.uk >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/LO2P265MB09410A342A6C3BD71987C677C0C90%40LO2P265MB0941.GBRP265.PROD.OUTLOOK.COM >>> >>> <https://groups.google.com/d/msgid/pestlist/LO2P265MB09410A342A6C3BD71987C677C0C90%40LO2P265MB0941.GBRP265.PROD.OUTLOOK.COM?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/DB6PR0201MB2389F3AD4E9A25A8C918711EDDC90%40DB6PR0201MB2389.eurprd02.prod.outlook.com >>> >>> <https://groups.google.com/d/msgid/pestlist/DB6PR0201MB2389F3AD4E9A25A8C918711EDDC90%40DB6PR0201MB2389.eurprd02.prod.outlook.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/CA%2Br2yto-L6dc8i%2BVHK7_8jFDWwU-r_9MBrqOxQgOjctXpG_rFQ%40mail.gmail.com >>> >>> <https://groups.google.com/d/msgid/pestlist/CA%2Br2yto-L6dc8i%2BVHK7_8jFDWwU-r_9MBrqOxQgOjctXpG_rFQ%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> This message came from outside of Winterthur, and has been scanned for >>> viruses. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/ce4188a8444d4a58b63da2b0bf1b6107%40winterthur.org >>> >>> <https://groups.google.com/d/msgid/pestlist/ce4188a8444d4a58b63da2b0bf1b6107%40winterthur.org?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Museumpests" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected] <javascript:>. >>> To post to this group, send email to [email protected] >>> <javascript:>. >>> Visit this group at https://groups.google.com/group/pestlist. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/pestlist/DB6PR0201MB23894DCEE31202D7838AAD2DDDC80%40DB6PR0201MB2389.eurprd02.prod.outlook.com >>> >>> <https://groups.google.com/d/msgid/pestlist/DB6PR0201MB23894DCEE31202D7838AAD2DDDC80%40DB6PR0201MB2389.eurprd02.prod.outlook.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- >> You received this message because you are subscribed to the Google Groups >> "Museumpests" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected] >> <javascript:>. >> Visit this group at https://groups.google.com/group/pestlist. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/pestlist/CAHhLO3YUFzaKTa%3DNbSwdmvRP-8W4QqWQ6NJmfkx15H%3D%3Dy0rB8w%40mail.gmail.com >> >> <https://groups.google.com/d/msgid/pestlist/CAHhLO3YUFzaKTa%3DNbSwdmvRP-8W4QqWQ6NJmfkx15H%3D%3Dy0rB8w%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> For more options, visit https://groups.google.com/d/optout. >> > -- You received this message because you are subscribed to the Google Groups "Museumpests" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pestlist/fc0622eb-24e0-41b1-bacf-1e94c7b6625e%40googlegroups.com.
