Spreadsheet S1 - Rapid Golgi Analysis Method for Efficient and Unbiased Classification of Dendritic Spines

This spreadsheet contains all of the required formulas that are needed to run the rapid Golgi spine analysis technique. As shown in Figure 6, identifying information (red) allows the user to specify each analyzed dendrite according to their own conventions. The ‘DEN ID’ column must be unique to each dendrite in a data set for the proper working of the included formulas. Values imported from RECONSTRUCT (blue) are obtained from Export Lists A & B. “By Spine” formulas (gold), including ‘LWR’, or length-to-width ratio, and ‘Type’, which classifies spines according to a custom hierarchical formula, should be dragged down and repeated for each row (i.e. spine) of the data set. “By Dendrite” formulas (green), which measure average protrusion width, length, LWR, and protrusion density, should be copied and pasted only onto the first line of each new DEN ID value. The spreadsheet is filled with measurements from the supplied “Tutorial Set” to familiarize new users with the process of completing their own data set. (XLSX)