Protection). The charts displayed in the JASSS article were based upon the iteration of 500 rows.
The selection of A or B depends upon the generation of a random number 0 or 1 with prob0 = prob1 = 1/2.
If random number = 0 then a type J agent gets to make the choice:
If [Aj +j*Sin(Pi/20*Na)] > [Bj + j*Sin(Pi/20*Nb)]If random number = 1 then a type K agent gets to make the choice:
then the J agent chooses A otherwise B.
If [Ak +k*Sin(Pi/20*Na)] > [Bk + k*Sin(Pi/20*Nb)]Cells in blue: B9, B10, D9, D10, F9 and F10 can be set to values chosen by the user.
then the K agent chooses A otherwise B.
Placing any character in cell A12 and pressing "Enter" reactivates the spreadsheet, generates new series and displays a new chart. The previous simulation and chart are lost and can never be recovered or replicated.
|Column A:||N||Shows total number of selections N = 1 to n.|
|Column B:||RAND||Generates random number 0 or 1.|
|Column C:||J test||Shows the selection A or B when a J agent selects.|
|Column D:||Na||Shows cumulative number of selections of good A by both types of agent and is displayed on Chart1 in dark blue.|
|Column E:||Nb||Shows cumulative number of selections of good B by both types of agent and is displayed on Chart1 in yellow.|
|Column F:||K test||Shows the selection A or B when a K agent selects.|
|Column G:||Ja||Shows 1 if J selects A otherwise 0.|
|Column H:||Jb||Shows 1 if J selects B otherwise 0.|
|Column I:||Ka||Shows 1 if K selects A otherwise 0.|
|Column J:||Kb||Shows 1 if K selects B otherwise 0.|
|Column K:||(Na - Nb)||Shows difference between the cumulative selections of A and B and is displayed on Chart1 in purple.|
|Chart1||Shows the series Na, Nb and (Na - Nb) as generated in columns D, E and K.|
Return to the main article
|| Home|||Current issue||| Information||| Search||| Notices||| Back issues||| Comments ||
© Copyright JASSS