User Tools

Site Tools


ephys_pipeline:excel_table

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
ephys_pipeline:excel_table [2017/10/24 18:10] – [Automaticly created entries] lukas.schneiderephys_pipeline:excel_table [2022/01/11 13:22] (current) – removed lukas.schneider
Line 1: Line 1:
-====== Sorted neurons excel table ====== 
-Find/create the electrode depth file corresponding to your monkey in the following location: 
-C:\Users\username\Dropbox\DAG\phys\Monkey_phys_dpz\Mon_sorted_neurons.xlsx 
-(replace username with your username, Monkey with the monkey's name and Mon with the first three letters of the monkey's name).  
- 
-There are two main sheets in this excel file: 
-  * automatic_sorting 
-  * final_sorting 
-The idea is, that a large part of the information can be updated automatically (**see...**), while some information has to be added manually in the final_sorting sheet.  
-For both sheets, each line represents one unit recorded in one block (and run) AND/OR the corresponding LFP site 
- 
-===== Automatically created entries ===== 
-^Monkey ^Session ^Date ^Run ^Block ^Chan ^z ^Unit ^N_spk ^Neuron_ID ^Site_ID ^Times_same_unit ^ 
-| Lin | 1 | 2010508 | 3 |  1 | 1 |15000|a|15251|Lin_20150508_01|Lin_20150508_Site_01|1| 
-| Lin | 1 | 2010508 | 4 |  2 | 1 |15000|a|15251|Lin_20150508_01|Lin_20150508_Site_01|1| 
- 
-  * Monkey: monkey initials (first 3 letters) 
-  * Session: A session counter (irrelevant, but helpful for browsing) 
-  * Date: Date of recording 
-  * Run: Corresponding behavioral run 
-  * Block: ephys recording block 
-  * Chan: electrode number (channel) 
-  * z: Electrode depth (from guide tube tip) - taken from [[ephys_pipeline:electrode_depth_file|electrode depth file]] 
-  * Unit: sortcode assigned to this cell (a=first,b=second,...) 
-  * N_spk: Total spike count 
-  * Neuron_ID: Cell identifier (the [[ephys_pipeline:same_cells_file|same cell]] can be recorded in several blocks !) 
-  * Site_ID: LFP site identifier (Based on electrode depth, same site can be recorded in different blocks and at the same time with different units) 
-  * Times_same_unit: For identifying unique units 
- 
-===== Manually added entries ===== 
-^SNR_rank ^Single_rank ^Stability_rank ^Set ^Target ^Hemisphere ^Grid ^x ^y ^ 
-| 1 | 1 | 2 | 1 | dPul|left|22.5|-5|8| 
-| 1 | 2 | 1 | 1 | dPul|left|22.5|-5|8| 
- 
-The first three entries should be taken from your notes during sorting. For internal ranking conventions see **???** 
-  * SNR_rank: Signal to noise ratio assessment 
-  * Single_rank: Multiunit or single unit 
-  * Stability_rank: How stable were the features across time 
- 
-The other entries typically don't change within a session and can be taken from the log file 
-  * Set: Dataset, relevant for assigning to specific project (**see ...**) 
-  * Target: Area 
-  * Hemisphere: left/right 
-  * Grid: grid identifier (diameter.number) 
-  * x: grid hole coordinate x 
-  * y: grid hole coordinate y 
- 
-===== Other entries ??? ===== 
-^Difficult_sorting_or_unstable_ ^Other_potential_reasons_to_ignore_or_check ^Runcomplete ^Usable ^Comments ^ 
- 
-Last, but not least, there is another entry which is typically calculated inside the table using different approaches per experimenter: Electrode_travel. All remaining colums serve this purpose. 
-