Data entry is still a work-in-progress. I have over 2,000 moth genitalia slides and still have over 1,000 to be entered into Excel.
Slides are stored in 100-capacity slide boxes in the order in which they were made; some since moved to home-made trays.
Once they are all catalogued they will be rearranged by species (and given a new location, col. 4), i.e., the same species-slides stored together.
The Excel data sheet is 7 columns:
1] Hodges' Checklist #
2] Genus
3] Pohl et al.2018 Checklist #, specific epithet etc., Canadian distribution by provinces
4] current location of slide
5] sex
6] date slide made, full data in note books
7] image location in BugGuide; typing the # in BG "search" will bring up the image.
1st 7 Excel entries attached
BG image 1855252 attached
437 Psyche Schrank, 1801 300008 casta (Pallas, 1767) (Phalaena)+ R -- -- -- -- BC -- -- -- ON QC -- -- NB NS -- C1 m 14vii20-1 1855252
600 Caloptilia Hübner, 1825 330122 cornusella (Ely, 1915) (Gracilaria) R -- -- -- -- BC AB SK MB ON QC -- NF NB NS - 4.30 m 26i18-2
601 Caloptilia Hübner, 1825 330123 coroniella (Clemens, 1864) (Gracilaria) R -- -- -- -- U AB -- -- ON QC -- NF -- NS -- 4.70 m 4v18-1 1516440
609 Caloptilia Hübner, 1825 330131 invariabilis (Braun, 1927) (Gracilaria) R -- -- -- -- BC AB SK MB ON QC -- NF NB NS 3.12 m 3v16-1
609 Caloptilia Hübner, 1825 330131 invariabilis (Braun, 1927) (Gracilaria) R -- -- -- -- BC AB SK MB ON QC -- NF NB NS 6.34 m 1vi20-3 1824696
639 Caloptilia Hübner, 1825 330161 stigmatella (Fabricius, 1781) (Tinea) R -- -- -- -- BC AB SK MB ON QC -- -- NB NS D56 m 2v16-1
639 Caloptilia Hübner, 1825 330161 stigmatella (Fabricius, 1781) (Tinea) R -- -- -- -- BC AB SK MB ON QC -- -- NB NS 3.39 m 30v16-2
https://bugguide.net/node/view/1855252