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]<mailto:[email protected]> 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] <[email protected]> On Behalf Of Jablonski, Megan T CIV USN (US) Sent: Tuesday, July 16, 2019 5:29 PM To: [email protected] 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]<mailto:[email protected]> 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: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Heather L Parks Sent: Tuesday, July 16, 2019 9:11 AM To: [email protected]<mailto:[email protected]> 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]<mailto:[email protected]> -- 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]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. 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]<mailto:[email protected]>. To post to this group, send email to [email protected]<mailto:[email protected]>. 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]. To post to this group, send email to [email protected]. 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. For more options, visit https://groups.google.com/d/optout.
