Using the Collection Data Form - Revision history

GabiDroege: /* Opening Collection Data Form */

2020-06-23T07:54:15Z

Opening Collection Data Form

← Older revision		Revision as of 09:54, 23 June 2020
Line 1:		Line 1:
			=Sending the file through Email=
			'''Attention: for sending CDF through email you must rename it to e.g. ".abc" instead of ".xls", ".xlsx". Sending files that include macros through email is no longer possible.'''

	=Opening Collection Data Form=		=Opening Collection Data Form=

GabiDroege: /* DNA/Tissue */

2018-09-18T14:22:25Z

DNA/Tissue

← Older revision		Revision as of 16:22, 18 September 2018
Line 80:		Line 80:
	==DNA/Tissue==		==DNA/Tissue==
	[[File:CDF09.JPG\|700px]]		[[File:CDF09.JPG\|700px]]

	This part comprises information on DNA and tissue samples as well as lab data and INSDC numbers. If you collect plant samples in the fields for e.g. DNA analysis you must use Tissue Barcodes (B GT …) for your teabags and must fill out the column “Tissue ID” with these numbers. The barcode/ID of the accompanying herbarium specimen must be entered into the yellow column at the beginning of the sheet “Voucher ID”. For each sample accompanied by a voucher specimen you must provide the information whether the sample and the specimen are the same individual or the same population. You should also distinguish between ex situ (living collection) and in situ. The “Tissue type” describes the part of the organism sampled. Usually this is “leaf”. The column “DNA Sample ID” will be filled out by the DNA bank curator!		This part comprises information on DNA and tissue samples as well as lab data and INSDC numbers. If you collect plant samples in the fields for e.g. DNA analysis you must use Tissue Barcodes (B GT …) for your teabags and must fill out the column “Tissue ID” with these numbers. The barcode/ID of the accompanying herbarium specimen must be entered into the yellow column at the beginning of the sheet “Voucher ID”. For each sample accompanied by a voucher specimen you must provide the information whether the sample and the specimen are the same individual or the same population. You should also distinguish between ex situ (living collection) and in situ. The “Tissue type” describes the part of the organism sampled. Usually this is “leaf”. The column “DNA Sample ID” will be filled out by the DNA bank curator!

GabiDroege: /* DNA/Tissue */

2018-09-18T14:22:18Z

DNA/Tissue

← Older revision		Revision as of 16:22, 18 September 2018
Line 79:		Line 79:

	==DNA/Tissue==		==DNA/Tissue==
	This part comprises information on DNA and tissue samples as well as lab data and INSDC numbers. If you collect plant samples in the fields for e.g. DNA analysis you must use Tissue Barcodes (B GT …) for your teabags and must fill out the column “Tissue ID” with these numbers. The barcode/ID of the accompanying herbarium specimen must be entered into the yellow column at the beginning of the sheet “Voucher ID”. For each sample accompanied by a voucher specimen you must provide the information whether the sample and the specimen are the same individual or the same population. You should also distinguish between ex situ (living collection) and in situ. The “Tissue type” describes the part of the organism sampled. Usually this is “leaf”. The column “DNA Sample ID” will be filled out by the DNA bank curator!		[[File:CDF09.JPG\|700px]]
			This part comprises information on DNA and tissue samples as well as lab data and INSDC numbers. If you collect plant samples in the fields for e.g. DNA analysis you must use Tissue Barcodes (B GT …) for your teabags and must fill out the column “Tissue ID” with these numbers. The barcode/ID of the accompanying herbarium specimen must be entered into the yellow column at the beginning of the sheet “Voucher ID”. For each sample accompanied by a voucher specimen you must provide the information whether the sample and the specimen are the same individual or the same population. You should also distinguish between ex situ (living collection) and in situ. The “Tissue type” describes the part of the organism sampled. Usually this is “leaf”. The column “DNA Sample ID” will be filled out by the DNA bank curator!

	==Multimedia==		==Multimedia==

GabiDroege: /* Custom */

2018-09-18T12:12:50Z

Custom

← Older revision		Revision as of 14:12, 18 September 2018
Line 74:		Line 74:

	==Custom==		==Custom==
	All columns you have marked with X or x ~~(see Fig. 1)~~ will show up when selecting this view.		[[File:CDF08.JPG\|700px]]

			All columns you have marked with X or x will show up when selecting this view.

	==DNA/Tissue==		==DNA/Tissue==

GabiDroege: /* Label Print */

2018-09-18T11:10:50Z

Label Print

← Older revision		Revision as of 13:10, 18 September 2018
Line 107:		Line 107:

	Printed labels ready for cutting.		Printed labels ready for cutting.
			Labels MUST be printed on special long-term resistant paper! Please contact the herbarium team before printing!!

GabiDroege: /* Tissue/DNA from our living collection and related garden herbarium specimen */

2018-09-18T11:09:29Z

Tissue/DNA from our living collection and related garden herbarium specimen

← Older revision		Revision as of 13:09, 18 September 2018
Line 32:		Line 32:
	==Tissue/DNA from our living collection and related garden herbarium specimen==		==Tissue/DNA from our living collection and related garden herbarium specimen==

	~~exampels~~ coming soon...		example labels/data coming soon...

	==Voucher Data==		==Voucher Data==

GabiDroege: /* Herbarium specimens, related tissue and DNA sample information */

2018-09-18T11:09:17Z

Herbarium specimens, related tissue and DNA sample information

← Older revision		Revision as of 13:09, 18 September 2018
Line 28:		Line 28:
	==Herbarium specimens, related tissue and DNA sample information==		==Herbarium specimens, related tissue and DNA sample information==

	~~examples~~ coming soon...		example labels/data coming soon...

	==Tissue/DNA from our living collection and related garden herbarium specimen==		==Tissue/DNA from our living collection and related garden herbarium specimen==

GabiDroege: /* General Structure */

2018-09-18T11:08:56Z

General Structure

← Older revision		Revision as of 13:08, 18 September 2018
Line 19:		Line 19:
	[[File:CDF-General.JPG\|800px]]		[[File:CDF-General.JPG\|800px]]

	The CDF consists of more than 150 columns. Only a few are needed for the regular use cases at BGBM. On the top left there are clickable buttons to move easily between different (coloured) areas within the sheet. Also there is a button called “Custom”. All columns marked with an “x” (see columns D,E,G in example above) will be displayed in the “Custom” view. “Show all” will show you all columns of the CDF.		The CDF consists of more than 150 columns. Only a few are needed for the regular use cases at BGBM. On the top left there are clickable buttons to move easily between different (coloured) areas within the sheet. Also there is a button called “Custom”. All columns marked with an “x” (see columns AC,AD,AE in example above) will be displayed in the “Custom” view. “Show all” will show you all columns of the CDF.

	The Collector’s No and Voucher ID are fixed columns for a smooth navigation.		The Collector’s No and Voucher ID are fixed columns for a smooth navigation.

GabiDroege: /* Label Print */

2018-09-18T11:06:28Z

Label Print

← Older revision		Revision as of 13:06, 18 September 2018
Line 98:		Line 98:
	[[File:CDF-Label07.JPG\|700px]]		[[File:CDF-Label07.JPG\|700px]]

	Click on "Print Labels" for starting the print. You must save the workbook first. Second you can use the standard label template or choose another one.		Click on "Print Labels" for starting the print. You must save the workbook first. Second you can use the standard label template or choose another one. Preparing of the label word document starts now.

	[[File:CDF-Label01.JPG\|700px]]		[[File:CDF-Label01.JPG\|700px]]

	Final label word document ready for printing.		Final label word document ready for printing. Don't forget to save it!

	[[File:CDF-Label03.jpg\|300px]]		[[File:CDF-Label03.jpg\|300px]]

	Printed labels ready for cutting.		Printed labels ready for cutting.

GabiDroege: /* Label Print */

2018-09-18T11:05:21Z

Label Print

← Older revision		Revision as of 13:05, 18 September 2018
Line 89:		Line 89:

	Click on the "Label Data" sheet to check the label print preview. First of all you can enter a title for your labels (e.g. the herbarium name) and the accession date. Note, at BGBM this accession date is assigned by Katharina Rabe (k.rabe@bgbm.org). Please contact her BEFORE printing the labels!		Click on the "Label Data" sheet to check the label print preview. First of all you can enter a title for your labels (e.g. the herbarium name) and the accession date. Note, at BGBM this accession date is assigned by Katharina Rabe (k.rabe@bgbm.org). Please contact her BEFORE printing the labels!

			[[File:CDF-Label05.JPG\|700px]]

			Settings such as number of rows can be changed if needed.

			[[File:CDF-Label06.JPG\|\|700px]]

			[[File:CDF-Label07.JPG\|700px]]

			Click on "Print Labels" for starting the print. You must save the workbook first. Second you can use the standard label template or choose another one.

	[[File:CDF-Label01.JPG\|700px]]		[[File:CDF-Label01.JPG\|700px]]