Ruud J.R. den Hartigh, Yannick Hill & Paul L.C. van Geert

1. Network Model Sport Specific with manual.xlsm

MICHAEL F. MASCOLO, PAUL VAN GEERT, HENDERIEN STEENBEEK, and KURT W. FISCHER

Webmaterials of the submitted chapter, 2015

Coodination-Dissociation - Excel file: click here.

If the files do not open or work on your PC or Mac, please mail Paul van Geert, paul@vangeert.nl

A do-it-yourself kit for constructing flexible observation software to study social interactions: The OBOB program (Observing By means Of Buttons)

M.D.Boelhouwer, W.E. Kupers & P.L.C van Geert

University of Groningen

Webmaterials of the submitted article, 2015

Action-reaction - Excel file: click here.

Behavior pattern - Excel : click here.

Example 1: The fundamentals of OBOB - Excel file : click here.

Example 2: Make an OBOB-program yourself - Excel file: click here.

The OBOB-macro: click here.

Transition and Frequency Matrix - Excel file: click here

If the files do not open or work on your PC or Mac, please mail Dr. Marieke Boelhouwer, M.D. Boelhouwer@rug.nl

Dynamic Modeling for Development and Education: From Concepts to Numbers

Webmaterials of the article to be published in MInd, Brain and Education, 2014

Figure 1: Excel file with a simple, random-walk model of changes in motivation: click here.

Figure 2: Excel file with a model of two connected growers, addition skill and motivation for addition tasks: click here.

Figure 3: Excel file with a model of dissociation and coordination in the context of psychosocial trauma, click here.

Figure 5: Excel files with models of the emergence of color preference in boys and girls. Model 1 is based on increasing sensitivity for gender-specific peeer influence, click here. Model 2 is based on children's perception and imitation of color choices made by same-sex peers, click here.

The models have been tested on 32-bit and 64-bit pc's, with Office 2010. They should also run on Mac's and newer versions of Office.

A dynamic developmental model of talent and excellence

Webmaterials of the article submitted to Psychological Review on January 22, 2013

Network Model 1 (Poptools)

Network Model 1 (Poptools) with Manual

Network Model 2

Network Model 2 with Manual

The Excel file with which you can run the simulations described in the article comes in 4 versions. 2 versions require the add-in for Excel called Poptools, which is freely downloadable from the website http://www.poptools.org/
Poptools, which uses a very good random number generator, has been used to run the simulations described in the article. Poptools is a 32-bit application, but it should also install on 64-bit computers (it shouldn't give any problem if you already have 32-bit applications installed on this computer).

Readers who do not want to install Poptools on their computers (although Poptools is a great and freely available statistical tool, including optimization routines and functions for random permutations) can use the versions that use the inbuilt randomization functions from Excel. These functions should provide good results if you're using a relatively recent the version of Excel.

The Poptools and non-Poptools version of the model come either with the Manual added, or without.
To start working with the model, it is best to open the version with the Manual added, and to 1st read the Manual which you can find under the worksheets with the colored tabs.

Note that the Excel file makes use of Visual Basic routines which contain the equations of the simulation model, and several other functions used to run the model or to calculate results. You must have Visual Basic for Applications installed in your version of Excel, but a standard PC installation of Excel also installs Visual Basic automatically.
To run the model, you must be able to run macros. Check your macro security settings (file/options/trust center/trust center settings/, then check the option disable all macros with notification. This means that if Excel wants to run a macro, it will ask for your permission to do so.

While opening the file enable all options (enable macros and content).
If you're asked to update links, click Continue. If the formula cells show an error message, click the keyboard button F9, which should recalculate all the values.

The worksheet Preparation of the Manual part of the Excel file describes all the preparatory steps in more detail).

Since the model is using a call to Visual Basic, it does not run on Mac computers.

If you want to check the code, you can do so by opening Visual Basic in the Excel from the Developer menu tab.

If you cannot use any of these files and the error messages remain, please email the 1st author at
paul@vangeert.nl

Distinguishing and Improving Mouse Behavior in ASD and ADHD children

Baukje Veenstra, Paul van Geert and Bieuwe van der Meulen

A dynamic systems model of friendship and risk behavior in adolescence

Supporting Materials

Excel simulation model