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]> 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] > > > > *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]> > > *Sent:* Wednesday, July 17, 2019 9:34 AM > *To:* [email protected] > *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]> > *Sent:* 17 July 2019 09:24 > *To:* [email protected] > *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] > > > > *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] 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] <[email protected]> *On Behalf > Of *Heather L Parks > *Sent:* Tuesday, July 16, 2019 9:11 AM > *To:* [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] <[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]. > 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/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]. > 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/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 > <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]. > 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/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]. > 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/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]. 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/CA%2Br2yto-L6dc8i%2BVHK7_8jFDWwU-r_9MBrqOxQgOjctXpG_rFQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
