Kesten and Langevin Simulator

Hazan L, Ziv NE (2020) Activity dependent and independent determinants of synaptic size diversity. J Neuroscience

Microsoft Excel files containing code in Visual Basic for Application (VBA) for simulating synaptic size fluctuations and distributions as a Kesten Process or a corresponding non-linear Langevin process as explained in the aforementioned paper.

Four files are provided

The VBA code in each pair of files is identical.

Within each pair, the files differ in the parameters used for the simulation (obtained from control or silenced networks)
In the first pair, η is set to 1-ε.

In the second pair, η and ε are the values derived from the fits in Fig 6 A and B

All simulations are seeded with the experimentally obtained data for control and silenced networks (1922 and 2032 synapses, respectively)

The simulations in the first pair are set to run for 320 simulation steps, and in the second pair for 40 simulation steps. Apart from this, the VBA code in all files is identical.


Important Notes:

  1. The simulations take 1-2 minutes to run - during which the spreadsheet will be unresponsive.
  2. To run the simulations, Macros must be enabled (File->Options->Trust Center->Trust Center Settings->Macro Settings->Enable All Macros
    When a file is opened for the first time, Excel might present you with "Enable Editing" and then "Enable Content" buttons. Please enable by clicking the appropriate buttons.
  3. The VBA code uses the Microsoft Excel Analysis Toolpack - it is a standard Microsoft Excel Add-In (not a 3rd party one) but it is not enabled by default. To enable it, open a new Excel file and then go to
    At the bottom of the window, where the title is "Manage:", select "Excel Add-ins" and press the "Go..." button on the right. In the window that opens, select "Analysis ToolPak" and "Analysis ToolPak - VBA" as in the picture below.

    add-ins dialog box
    Press OK.
    If needed, additional info on installing the Add-Ins can be found here

    Here is an example spreadsheet (... Fig 6 control.xsm) loaded in excel: