<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<div class="moz-cite-prefix">Hi Sarah,</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">we developed a standardised Excel-sheet
for consumptive tissue sampling that also collect extraction and
DNA data, or consumption of DNA samples, respectively. These
support workflows for picking samples directly i.e., via simple
print-outs with key data such as tube number, tube position on
extraction plate, etc. that are conveyed from of the long Excel
table with formulas to a second tab, which is supported by
additional fields for required database updates to be done.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Import schemes for our database are
matching to respective field on the first tab containing all data,
and thus, by running different import schemes over the same excel
sheet, we can easily update database entries after tubes have been
picked, DNA has been extracted, and DNA aliquots to be added to
tissue tube entries after extraction.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">This made life a lot easier. Similar
systems might be useful for other sorts of destructive sampling as
well.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">For removal of jars, we started to add
placeholder cards to shelves similar to those John suggested,
however, we didn't standardise them so far, which resulted in that
sort of "individualism" John mentioned and that you definitely
want to avoid.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Our bottleneck to record how many
specimens were used is the returning of jars, when we record
number of jars and included individuals, which are used for our
annual report.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Hope this helps</div>
<div class="moz-cite-prefix">Dirk<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Am 28.01.2022 um 18:05 schrieb Sarah K.
Huber:<br>
</div>
<blockquote type="cite"
cite="mid:BN9PR03MB60749514545D6768BFE4F2C6D1229@BN9PR03MB6074.namprd03.prod.outlook.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">I would be curious how different
collections track in-house usage of specimens. I have tried
many different protocols for doing this in our collection, and
none have been completely successful. I would also be curious,
given your protocol, how compliant users are. (We do not have
our specimens bar-coded, so this is not an option for tracking
at this time.)
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I do record when specimens get re-shelved,
but without knowing when they left the collection, I am unable
to determine the amount of time (months, years, decades) that
they were used. Therefore, my annual reporting statistics
don’t necessarily reflect actual specimen usage. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Sarah<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif;color:black;background:white">Sarah
K. Huber, Ph.D.</span><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black;background:white"><br>
Curatorial Associate, VIMS Nunnally Ichthyology Collection<br>
Office 804.684.7104 | Collection 804.684.7285<br>
<a href="mailto:skhuber@vims.edu" target="_blank"
moz-do-not-send="true"><span style="color:blue">skhuber@vims.edu</span></a> |
<a
href="https://nam11.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.vims.edu%2Fresearch%2Ffacilities%2Ffishcollection%2Findex.php&data=04%7C01%7Cskhuber%40vims.edu%7C1063bb0e1daf4ab0024f08d897b1267f%7C8cbcddd9588d4e3b9c1e2367dbdf1740%7C0%7C0%7C637426134417674979%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=OEa%2F3y6PHz5lBFNRFMSFFSdxbyTq%2BBGC5PculkLg7nc%3D&reserved=0"
target="_blank" moz-do-not-send="true">
<span style="color:blue">http://www.vims.edu/research/facilities/fishcollection/index.php</span></a></span><span
style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:black"><br>
<span style="background:white">PO Box 1346 | 1370 Greate
Rd., Gloucester Pt., VA 23062</span><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Nhcoll-l mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Nhcoll-l@mailman.yale.edu">Nhcoll-l@mailman.yale.edu</a>
<a class="moz-txt-link-freetext" href="https://mailman.yale.edu/mailman/listinfo/nhcoll-l">https://mailman.yale.edu/mailman/listinfo/nhcoll-l</a>
_______________________________________________
NHCOLL-L is brought to you by the Society for the Preservation of
Natural History Collections (SPNHC), an international society whose
mission is to improve the preservation, conservation and management of
natural history collections to ensure their continuing value to
society. See <a class="moz-txt-link-freetext" href="http://www.spnhc.org">http://www.spnhc.org</a> for membership information.
Advertising on NH-COLL-L is inappropriate.
</pre>
</blockquote>
<p><br>
</p>
<div class="moz-signature">-- <br>
<p><img src="cid:part1.ffm7qh6m.KXrH0Oij@snsb.de" alt=""
width="152" height="59"></p>
<p><br>
Dirk Neumann<br>
<br>
Tel: 089 / 8107-111<br>
Fax: 089 / 8107-300<br>
neumann(a)snsb.de<br>
<br>
Postanschrift:<br>
<br>
Staatliche Naturwissenschaftliche Sammlungen Bayerns<br>
Zoologische Staatssammlung München<br>
Dirk Neumann, Sektion Ichthyologie / DNA-Storage<br>
Münchhausenstr. 21<br>
81247 München<br>
<br>
Besuchen Sie unsere Sammlung:<br>
<a class="moz-txt-link-freetext" href="http://www.zsm.mwn.de/sektion/ichthyologie-home/">http://www.zsm.mwn.de/sektion/ichthyologie-home/</a><br>
<br>
---------<br>
<br>
Dirk Neumann<br>
<br>
Tel: +49-89-8107-111<br>
Fax: +49-89-8107-300<br>
neumann(a)snsb.de<br>
<br>
postal address:<br>
<br>
Bavarian Natural History Collections<br>
The Bavarian State Collection of Zoology<br>
Dirk Neumann, Section Ichthyology / DNA-Storage<br>
Muenchhausenstr. 21<br>
81247 Munich (Germany)<br>
<br>
Visit our section at:<br>
<a class="moz-txt-link-freetext" href="http://www.zsm.mwn.de/sektion/ichthyologie-home/">http://www.zsm.mwn.de/sektion/ichthyologie-home/</a><br>
<br>
</p>
</div>
</body>
</html>