Tier 2 definitions

[arschat]

Epic of all bionetworks' Tier 2 definitions

Tier 2: folder, cross bionetwork summary spreadsheet
Initial communication tracker: document
Tier 1: folder, definitions, mapping

Templates

• Generic Tier 2/ GDT template: spreadsheet
• File manifest: spreadsheet

Bionetwork	#ticket	State	Folder	Definitions/ Mapping	Template	Correspondence
Lung	#1235	Finalised	lung	def / map	template
Oral and Craniofacial	#1280	Finalised	oral	def / map	template
Genetic Diversity	#1245	Finalising	genetic_diversity	doc/ sheet	generic	doc
Gut	#1287	In progress	gut	recs/ kyle's		doc
Musculoskeletal	#1285	In progress	musculoskeletal	recs	template	doc
Immune		1st call soon	immune	recs		doc
Liver		1st call soon	liver	recs
Eye			eye	recs		doc
Pancreas			pancreas	recs
Heart			heart	recs
Kidney			kidney	recs
Adipose			adipose	recs
Skin
Organoid
Reproduction
Breast
Development
Nervous System

[arschat]

To update Tier 2 bionetworks summary:

• conf_pull_data: drag and drop the importrange function until it imports all the fields from corresponding spreadsheet, and make sure it doesn't overlap with other bionetworks' fields. edit existing importrange range to include new field(s)
• conf_map_dcp: if there is a new map, paste the T2 field in column A, and the mapped dcp field in column B
• conf_similar_fields:
  • if field already exists with other name, paste in columns C, D, E, F
  • if field is a novel field, add a new row in appropriate group (column G) and fill column A and G accordingly