Dear all I absolutely concur that this is a great database and has many features which capture data, flag up concerns and the work these guys are doing also is to how to present IPM data. We have experimented in the past with Access but again this is complex (and costly ) software Bear in mind also that Open office will take excel data 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: ado...@britishmuseum.org<mailto:ado...@britishmuseum.org> The British Museum Great Russell Street, London WC1B 3DG britishmuseum.org<http://www.britishmuseum.org/> The security classification for this message is OFFICIAL From: pestlist@googlegroups.com <pestlist@googlegroups.com> On Behalf Of Christian Baars Sent: Sunday, July 21, 2019 10:05 PM To: Museumpests <pestlist@googlegroups.com> Subject: Re: [Non-DoD Source] [pestlist] Bug tracking software/program 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. 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 [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 [https://lh6.googleusercontent.com/proxy/GfjKGKWq8w9o6OFSdoENgV9pVEK0-GXFy9COWs7uRXEfL8Hbytk9eWVv_LKS26mRWvqSdkK822BgauumLCabH1fs0jObVR72QDYpG3R_2qU3e4CqPaDZYsusQOaG1GcOieeHzUz2hrVPxLIUCfIsCY1oLb63jLnfEMzlvagKvoWq2Cj5Ytfg1HPvEqC6I--xVjY58R35B0Y_iL_-hw=w5000-h5000] On Thu, Jul 18, 2019 at 10:57 AM Alan P Van Dyke <apva...@utexas.edu<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<http://www.hrc.utexas.edu/> On Thu, Jul 18, 2019 at 9:11 AM 'Adrian Doyle' via Museumpests <pest...@googlegroups.com<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: ado...@britishmuseum.org<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: pest...@googlegroups.com<javascript:> <pest...@googlegroups.com<javascript:>> On Behalf Of Matthew Mickletz Sent: Thursday, July 18, 2019 1:00 PM To: pest...@googlegroups.com<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.) [https://groups.google.com/group/pestlist/attach/74516d7db2f04/image001.jpg?part=0.1&view=1&authuser=0] 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: pest...@googlegroups.com<javascript:> [mailto:...@googlegroups.com<javascript:>] On Behalf Of James Davis Sent: Wednesday, July 17, 2019 4:18 PM To: pest...@googlegroups.com<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 [https://lh6.googleusercontent.com/proxy/GfjKGKWq8w9o6OFSdoENgV9pVEK0-GXFy9COWs7uRXEfL8Hbytk9eWVv_LKS26mRWvqSdkK822BgauumLCabH1fs0jObVR72QDYpG3R_2qU3e4CqPaDZYsusQOaG1GcOieeHzUz2hrVPxLIUCfIsCY1oLb63jLnfEMzlvagKvoWq2Cj5Ytfg1HPvEqC6I--xVjY58R35B0Y_iL_-hw=w5000-h5000] On Wed, Jul 17, 2019 at 5:43 AM 'Adrian Doyle' via Museumpests <pest...@googlegroups.com<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: ado...@britishmuseum.org<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 <pest...@googlegroups.com<javascript:>> Sent: Wednesday, July 17, 2019 9:34 AM To: pest...@googlegroups.com<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 <pest...@googlegroups.com<javascript:>> Sent: 17 July 2019 09:24 To: pest...@googlegroups.com<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: ado...@britishmuseum.org<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: pest...@googlegroups.com<javascript:> <pest...@googlegroups.com<javascript:>> On Behalf Of Jablonski, Megan T CIV USN (US) Sent: Tuesday, July 16, 2019 5:29 PM To: pest...@googlegroups.com<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 megan.j...@navy.mil<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<http://www.PugetSoundNavyMuseum.org> www.history.navy.mil/PSNM<http://www.history.navy.mil/PSNM> www.facebook.com/pugetsoundnavymuseum<http://www.facebook.com/pugetsoundnavymuseum> From: pest...@googlegroups.com<javascript:> <pest...@googlegroups.com<javascript:>> On Behalf Of Heather L Parks Sent: Tuesday, July 16, 2019 9:11 AM To: pest...@googlegroups.com<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 hpa...@binghamton.edu<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pes...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pes...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pes...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pes...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pes...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pest...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pest...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pest...@googlegroups.com<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 pest...@googlegroups.com<javascript:>. To post to this group, send email to pest...@googlegroups.com<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 pestlist+unsubscr...@googlegroups.com<mailto:pestlist+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/pestlist/fc0622eb-24e0-41b1-bacf-1e94c7b6625e%40googlegroups.com<https://groups.google.com/d/msgid/pestlist/fc0622eb-24e0-41b1-bacf-1e94c7b6625e%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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 pestlist+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/pestlist/DB6PR0201MB238931FC0E05E65C429C65ECDDC40%40DB6PR0201MB2389.eurprd02.prod.outlook.com.