Player 1

GO Free $220
? $220 $240 $200 $260 $260 $150 $280
Go To
Cannot Buy Houses Parking Kentucky Indiana Illinois B&O Atlantic Ventnor Water Marvin Jail
3
Avenue Chance Avenue Avenue Railroad Avenue Avenue Works Gardens
Houses: 0

New Y'rk Tenessee

Avenue
Avenue

Pacific
$200
2 4

N Carl'na
Avenue

Avenue
$180
n n n
Roll Dice
n n n
Comm

CC
Chest

CC
St James

Avenue
Penn'ia
Place
$180

Short Line
Railroad
Penn'ia
$200

Active Player: 1 Ready

Avenue
Virginia
$160

?
Avenue
States

Place
Park
$140

Luxury
Electric

$100
Comp
$150

Tax
St Chas

Board
Place
$140

walk
 St Chas

Board
Place
$140

walk
Conn'ticut Vermont Oriental Reading Baltic Med'ean
Jail Avenue Avenue
? Avenue Railroad Income Avenue
CC Avenue

Visting
Tax
$120 $100 $100 $200
$200 or
$80 $60 GO á
Comm
$1500 Just Chance 10% Chest

0
 Player 2

Go To GO
Property Table
P1 Stats
Jail 18hr 8m
na
###
GO
$300

go
###
###
$300

###
###
###
Comm
Chest
CC

###
just_visiting
Gameover
$320

###
whitehall
.
$200

###
bow_st
comm_chest_two
Chance
?

P2 stats
na
###
$350

GO
go
###
Luxury

$100
Tax

###
###
###
$400
 $400
###
###
picadilly
go_to_jail
GO á regent_st
edition
? ###
$
fenchurch_st_stn
chance_three
LAN
Move
GameID
Active
jail
###
###
###
Card Decks
###
###
xlMonopoly

Board
Official Rules
Instructions
Create New Board
FAQ
 An Excel game by charlie ja

OFFICIAL RULES AS LAID DOWN BY PARKER BROTHERS

OBJECT...The object of the game is to become the wealthiest player through buying, renting and selling property.
EQUIPMENT...The equipment consists of a board, 2 dice, tokens 32 houses and 12 hotels. There are Chance and Community Chest
cards, a Title Deed card forthe
PREPARATION...Place each property
board and play
on a table money.
and put the Chance and Community Chest cards face-down on their allotted spaces on th
board. Each player chooses one token to represent him
Each player is given £1500 divided as follows: 2 each of on£500's,
his travels around
£100's the board.
and £50's; 6-£20's; 5 each of £10's, £5's and £1's.
All remaining money and other equipment go to the Bank.
BANKER...Select as Banker a player who will also make a good Auctioneer. If the Banker plays in the game, he must keep his persona
funds separate from those
THE BANK...Besides theof the Bank.
Bank's money, When the more
Bank than holdsfive thepersons
Title Deed play,cards
the Banker
and houses mayand electhotels
to actprior
onlytoaspurchase
Banker and andAuctioneer.
use by the
players.
The Bank The Bank all
collects pays salaries
taxes, fines, and bonuses.
loans It sells and auctions
and interest, the price properties and hands
of all properties which outit their
sells proper Title Deed cards; it sells houses
and auctions.
and
The hotels
Bank never to the "goes
players and loans
broke". If themoney
Bank when runs out required
of money on mortgages.
it may issue as much more as may be needed by merely writing on any
ordinary
THE paper.Starting with the Banker, each player in turn throws the dice. The player with the highest total starts the play. He places
PLAY...
his token ontothe
According thecorner
space marked
which his "GO",
tokenthrows
reaches, thea2player
dice and maymoves his token
be entitled to buyin the
realdirection
estate or of the properties,
other arrow the number of spaces
-or be obliged to indicate
pay ren
by
pay the dice.
taxes, After
draw a he has
Chance completed
or Community his play,
Chest the turn
card, to
"Go play
to passes
Jail", to
etc. the left. The tokens
If a player throws doubles he moves his token as usual the sum of the two dice and is subject to any privileges or penalties pertaining remain on the spaces occupied and proceedto
from
the spacethat on
"GO"...Each pointwhichon the
time he player's
a player's next
tokenturn.
lands. Retaining lands Two
the onororhe
dice, more tokens
throws
passes may
again
over restmoves
and
"GO", on thehis
whether same
tokenspace
by throw atofthe
as before. thesame
Ifdice time.
a player
or bythrows
drawing doubles three
a card, thetimes
Banki
succession, he
pays him £200 salary.
However, moves his token immediately to the space marked "In Jail" (see JAIL).
is paid only once each time around the board. If a player, passing "GO" on the throw of the dice, lands 2 spaces beyond
on "Community
BUYING Chest", or 7 spaces beyond
PROPERTY...Whenever a playeritlands on "Chance",
on an unowned and draws the card
property "Advance
he may buy thatto GO",
property he collects
from the£200Bankforatpassing "GO"
its printed th
price
first
He
If time
doesand
hereceives nottheanother £200
TitletoDeed
wish buy the forproperty
card reaching
showingititownership
isthe
soldsecond andtime
at auction by
by instructions
places it face-up
the Banker in onfront
to thehighest
the card.
of him.bidder. The buyer pays to the Bank the amount
the
PAYINGbid in cash and receives
RENT...When the Title
a player Deed
lands on card for that
property ownedproperty. Any player,
by another including
player the owner the one who
collects rent declined
from himthe in option of buying
accordance it atl
with the
the printed
printed on price,
the TitlemayDeed bid. Bidding
card applyingmay start
to it. at any price.
If the property is mortgaged, no rent can be collected. When a property is mortgaged its Title Deed card is placed face-down in front of
theisowner.
It an advantage to hold all the Title Deeds in a color-group (i.e.: Park Lane and Mayfair, - or Bow St, Marlborough St and Vine St)
because
It is eventhe moreowner of an may then charge
advantage double
to have housesrentor forhotels
unimproved properties
on properties becausein that
rentscolor-group.
are much higher This rulethanapplies to unmortgaged
for unimproved properties.
properties
The ownereven may ifnot another
collectproperty
his rent in thatfails
if he color-group
to ask forisitmortgaged.
before the second player following throws the dice.
"CHANCE" and "COMMUNITY CHEST"...When a player lands on either of these spaces he takes the top card from the deck
indicated,
The "Get Out followsof JailtheFree"
instructions
card is heldand returns
until used the andcardthenface-down
returnedtotothe thebottom
bottomofofthe thedeck.
deck. If the player who draws it does not wish t
use it he mayTAX"...When
"INCOME sell it, at any time, a playerto another
lands player
on "Income at a price Tax" agreeable
he has to twoboth.
options: he may estimate his tax at £200 and pay the Ban
or heplayer
The may pay must10% decide of which
his total worth
option he towillthetake
Bank. beforeHishetotaladdsworth
up hisistotal
all his cash on hand, printed prices of mortgaged and
worth.
unmortgaged
JAIL...A player properties
lands in Jail andwhen.cost price
. . (1.)of hisalltoken
buildings
lands on he the
owns. space marked "Go to Jail"; (2.) he draws a card marked "Go to Jail"; (3
he throws
When doubles
a player three
is sent to times
Jail heincannot
succession.
collect £200 salary in that move since, regardless of where his token is on the board, he must
move it directly into Jail. A player's
If a player is not "sent to Jail" but in the ordinary turn ends when he isofsent
course playto lands
Jail. on that space, he is "Just Visiting", incurs no penalty, and moves
ahead in the usual manner on his next turn.
A player gets out of Jail by... (1.) throwing doubles on any of his next three turns. If he succeeds in doing this he immediately moves
forward
If the player the number
does notofthrow spaces shownby
doubles byhis histhird
doublesturnthrow.
he must Evenpaythough
the £50hefine.hasHe thrown
then doubles
gets out he doesand
of Jail notimmediately
take another moves
turn; (2.) using
forward
the
Even "Get
number
thoughOutofof Jail
is inFree"
hespaces shown
Jail, acardbyifhis
player hemay
hasbuy
throw. it; (3.) purchasing
or sell property,the buy"Get Out houses
or sell of Jail Free" card from
and hotels another
and collect player and playing it; (4.) paying
rents.
aFREE
fine ofPARKING...A
£50 before he rolls player thelanding
dice ononeither of his does
this space next not
tworeceive
turns any money, property or reward of any kind. This is just a "free"
resting place.
HOUSES...When a player owns all the properties in a color group he may buy houses from the Bank and erect them on those propertie
If he buys one house, he may put it on any one of those properties. The next house he buys must be erected on one of the unimproved
properties
The price he of must
this orpay anythe other
Bank complete
for eachcolor-group
house is shown he may own.
on his Title Deed card for the property on which he erects the house.
The owner can still collect double rent from an opponent who lands on the unimproved properties of his complete color-group.
Following the above rules, a player may buy and erect at any time as many houses as his judgment and financial standing will allow. Bu
he must
As a player build evenly
builds (i.e.: he
evenly, he cannot
must also erect moredown
break thanevenly
one house if heon anyhouses
sells one property
back tooftheany Bankcolor-group
(SEE SELLING untilPROPERTY).
he has built one house on
every property of that group. He may then begin on the second row
HOTELS...When a player has four houses on each property of a complete color-group, he may buy a hotel from of houses, and so on, up to a limit of four houses to a property.
the Bank and erectForit o
example,
any property he cannot
of that build three
color-group. houses
He on
returns one theproperty
four if
houseshe has
from only
that one house
property
BUILDING SHORTAGE...When the Bank has no houses to sell, players wishing to build must wait for some player to turn on
to another
the Bank property
and pays of
thethat group.).
price for the hotel as shown
back oron to
the
sell Title
SELLING Deed
his houses card.
to theOnly
PROPERTY... Bankone hotelbuilding.
before
Unimproved may beproperties,
erected
If there on any
areRailways one property.
a limited number
and of houses
utilities (but notand buildings)
hotels available,may be andsold
twotoorany
more players
player as wish
a t
buy
Housesmore
private andthan
transaction the Bank
hotels mayforbe has,
any the
amount
sold houses
back tothator hotels
the the
Bank atmust
owner anycanbe
timesoldforat
get. auction the
However,
one-half to
nothe highest
property
price bidder.
paid can be sold to another player if buildings are
for them.
standing
All housesononany oneproperties
color-groupofmust that becolor-group.
sold one byAny one,buildings
evenly, inso located
reverse of must be sold
the manner in back
whichtothey the were
Bankerected.
before the owner can se
any property of that color-group.
All hotels on one color-group may be sold at once. Or they may be sold one house at a time (one hotel equals five houses), evenly, in
reverse of the manner in which they
MORTGAGES...Unimproved were erected.
properties can be mortgaged through the Bank at any time. Before an improved property can be
mortgaged
No rent canall bethe buildings
collected on all the properties
on mortgaged propertiesoforitsutilities,
color-group must
but rent canbebesold back toonthe
collected Bank at halfproperties
unmortgaged price. Theinmortgage
the samevalue
group.is
printed
In orderonto each Title
lift the Deed card.
mortgage, the owner must pay the Bank the amount of the mortgage plus 10% interest. When all the properties of a
color-group
The player whoare no longer mortgaged
mortgages the owner
property retains may begin
possession of itto buy
and noback
otherhouses
playeratmay
fullsecure
price. it by lifting the mortgage from the Bank.
However, the owner may sell this mortgaged property to another player at any agreed price. The new owner may lift the mortgage at
once, if he wishes, by paying off the mortgage plus 10% interest to the Bank. If he does not lift the mortgage at once he must pay the
Bank 10% interest when he buys the property and if he lifts the mortgage later he must pay an additional 10% interest as well as the
BANKRUPTCY...A player is bankrupt when he owes more than he can pay either to another player or to the Bank. If his debt is to
another aplayer,
Should playerhe must
owe theturn
Bank,over to thatofplayer
instead allplayer,
another that hemore
has ofthan
value
he and
can retire from theofgame.
pay (because taxes In
or making thiseven
penalties) settlement, if he
by selling hisowns
houses or and
buildings hotels, he must return
mortgaging
MISCELLANEOUS...Money these
property,
can hetomust
only theloaned
be Bank in
toexchange
turn over aall forthe
his assets
player by money
toBank toand
thethen
the Bank. extent
In this
onlyof one-half
case,
by the amount
the Bank
mortgaging paidNo
immediately
property. for them
sells and
maythis
by auction
player allca
borrow
is given
property
from to the creditor.
so taken,
or lend money exceptIf he has mortgaged
buildings.
to another A bankrupt player must immediately retire from the game. The last player left in the game wins.pay
player. property he also turns this property over to his creditor but the new owner must at once
xlMonopoly
Instructions for the Excel version of the game
Board
Official Rules General Play
Instructions 1) Click New Game to begin a new game; otherwise state of play from the previous game will re
Create New Board immediately resumed
FAQ 2) Click Roll Dice to roll the dice for player 1 (you). The dice will be rolled and the counter (the bl
will move automatically.

3) Depending on the property landed upon, you may be asked if you want to buy the Property, o
player 2, take a card, pay a fine or go to Jail. If you have the cash available, Fines and Rent will
from your cash total in the bottom LH corner.

4) When ready, click the Roll Dice button again to roll the dice for player 2. Player 2's counter (lim
automatically. Upon landing on his destination, Player 2 will also make purchasing decisions or p
Player 2 will also consider house buying and mortgaging decisions.
5) Upon completion of Player 2's turn, control will return to you. You can again make any house
decisions. When ready, click the play button to roll the dice for your move.

Mortgaging Property
When Player 1 is active, you have the opportunity to mortgage any undeveloped property you ow
toolbar to display the mortgaging form

Select you property you wish to Mortgage from the drop-down box. The Mortgage value of that p
OK to complete the mortgage.
If you have any properties that have been mortgaged, you can choose to Unmortgage them. Clic
and select the property from the dropdown box. The cost of mortgaging is calculated at 110% of
property.

Buying Houses
Once you own a complete colour group, you can begin to develop properties in the group. Click
to display the Buy/Sell House form

Select the property you want to build on from the dropdown list. The cost of building the house is
build a house if the number of houses on that property is greater than the minimum number of ho
that group. You cannot buy a house if the cost exceeds your cash level; you will need to raise fu
selling first.
Click Buy to complete the house purchase. (If only it were that simple in real life!)
Occasionally, after a house purchase, some properties that were unimprovable when the form w
improveable. Click done and then Buy House again to re-load the form.

Deals
When Player 1 and Player 2 both own property, you can offer to swap a property you own for on
also either ask for or offer cash to even up the value of the deal. Click Offer Deal to show the De

Select the Player 2 property you want (St Charles Place in the example) from the top dropdown,
offering to swap for it in the bottom dropdown.

If the property you are bidding for is more valuable than the property you are offering, then you a
if you offer cash in addition. Enter the cash amount that you are offering to pay into the BOTTOM
offering to swap a property of higher value, then you can ask for cash from player 2 to even up t
Note that if a value is entered in one of the cash boxes, it must be cleared before you can enter
Create New Board
It's now possible to create new boards based around any place names or otherwise that you like
on the menu and get to this sheet:

5
6

Follow these steps to create a new board.

1) Enter a name and Currency for the board
2) Enter the full name of each property.
3) Click the 'Copy Names across' button. This will copy the full names to the display names cells
4) Adjust the display names so that the name fits the Property header box. Activate the cell and
tester, allowing you to check that the name is short enough
5) Click the 'Add sheet' button to create the new board. If you have not filled all the fields, and er
to do so.

6) Return to the Board via the hyperlink and play the game

Note. This feature has not been exhaustively test and it is likely that supplying names with speci
cause an error. Note for bored hackers: You've tried SQL injection - now try formula injection! En
names will give some strange results.

Notes
The card packs are shuffled randomly at the beginning of the game. Get out of jail free cards, if t
the pack. However, once used, they return to their original pack position and not to the bottom. T
than I felt the difference was worth
Income tax, as stated in the rules, can be either £200 or 10% of total assets. To simplify this, the
will automatically be deducted. Furthermore, total assets are calculated as the sale or mortgage
houses and property,
When purchasing not face
property, thevalue
playerasisstated in the
allowed rules.
to pay more for the property than their current c
more for the property, then the Debt decision screen appears, and the player sells assets (not in
purchased) to pay their debt. The computer opponent also has the ability to do this.
The computer opponent has no more information than the player. It does not anticipate the dice
community chest card values.

Note for the US edition:

The version I coded originally used London place names and Sterling (£) signs throughout the g
of tribute to the game's origins, I thought that I could make the whole game convertible to the Atl
Superficially, I achieved this by a little research into the US property names. Since the face value
identical to the UK version, I assumed all other prices were equal and applied no scaling factor -
for certain aspects.
 An Excel game by charlie jans

om the previous game will remain intact and can be

rolled and the counter (the blue highlighted property)

u want to buy the Property, or have to pay Rent to

vailable, Fines and Rent will be deducted automatically

ayer 2. Player 2's counter (lime green) will also move

ake purchasing decisions or pay rent etc. At this time,

u can again make any house, mortgaging or deal

move.

undeveloped property you own. Click Mortgage in the

The Mortgage value of that property is displayed. Click

ose to Unmortgage them. Click on the unmortgage tab,

ging is calculated at 110% of the mortgage value of the
properties in the group. Click Buy House in the toolbar

e cost of building the house is displayed. You cannot

an the minimum number of houses on any property on
evel; you will need to raise funds from mortgaging or

le in real life!)
nimprovable when the form was loaded become
orm.

ap a property you own for one Player 2 owns. You can

ck Offer Deal to show the Deal form:

mple) from the top dropdown, and the property you are

y you are offering, then you are more likely to succeed

ering to pay into the BOTTOM box. Similarly, if you are
sh from player 2 to even up then deal.
cleared before you can enter a value into the other.
mes or otherwise that you like. Click 'Create new board'

es to the display names cells.

er box. Activate the cell and the text will appear in the

not filled all the fields, and error message will ask you

t supplying names with special characters like " or ( will

- now try formula injection! Entering Excel formulae as

. Get out of jail free cards, if turned up, do not remain in

sition and not to the bottom. This saved more coding
al assets. To simplify this, the lower of these two sums
ated as the sale or mortgage value of all money,
e property than their current cash total. If the does pay
he player sells assets (not including the property being
ability to do this.
does not anticipate the dice total or chance or

ng (£) signs throughout the game. However, as a kind

e game convertible to the Atlantic city names.
y names. Since the face values of property were
nd applied no scaling factor - possible this is inaccurate
 Value of assets over time
12
10
Mortgageable Value

8
6 P1
### P2
4
2
0
1 2 3 4 5 6 7 8
Turn
Property Ownership

Still Available
0
xlMonopoly
xlMonopoly FAQ
Board
Official Rules Q: How long did the game take to build?
Instructions
A: The first version took about 4 weeks of coding. I didn't have a job at the time, so I was able to
Create New Board After that, I then got a job and the second version was put on significant hold. In all, I'd guess I'v
FAQ hours designing, testing and playing the game

Q: I've spotted a mistake / The game's given me an error message. What can I do?

A: Let me know about it. If you can email a description of the problem, and the error message if
can fix it of rthe next version. If you're a VBA programmer and want to fix it yourself, drop me a li
password. My email address is charles_jans@yahoo.co.uk

Q: Why do the colors of the property banner cells sometimes disappear?

A: No idea at all. The code never changes those cells, and there's no conditional formatting on a
a mystery why they sometimes lose their color.

Q: What will be in the next version?

A: If it happens, the ability to play other people over a LAN, multiple opponents, difficulty levels,
of. Realistically, this may be a while coming, if ever.

Q: Why did you decide to do this?

A: I was sitting in a backpackers hostel in Seattle, wondering what to do. I remembered how I lov
when I was younger, thinking that I'd like a game right now. This led me on to thinking that the g
excel, and I began to think how it might be done. The first version was sketched out in my notep
stayed roughly the same.

Q: How does the game work?

A: Roughly, there's a flow of events leading from the click of the roll dice button that is roughly su
below. Decisions such as Player 2 buying houses have their own separate and fairly detailed pro
the difficult calculation (such as working out rent) is done by worksheet formula. VBA takes care

Roll Dice

Auto
Auto? HB Roll dice Is double? 3rd time?
Dec

Check
In Jail Show Form
Card
Chang
e Pay fine
Play Money
card

Go to
Roll Double? 3 in a row?
Jail
 Auto
Auto? HB Roll dice Is double? 3rd time?
Dec

Check
In Jail Show Form
Card
Chang
e Pay fine
Play Money
card

Go to
Roll Double? 3 in a row?
Jail

Move
Available? Op owns? Tax?
Counter

Buy?

Calc
Auction Calc tax
Rent

Get P1
Price

Get P2
Price Sell Chang
Mort
Hous e
Prop
e Money

Buy
P1>P2?
Property
House/ Show
Form In debt?
Prop

Opp
Buys

Q: Who are you?

A: I'm an economics consultant currently living in Oxford, UK.
 An Excel game by charlie jans

b at the time, so I was able to spend a lot of time on it.

icant hold. In all, I'd guess I've spend north of 200

age. What can I do?

m, and the error message if there is one, then maybe I

to fix it yourself, drop me a line and I'll send you the

disappear?

no conditional formatting on any of them, so it's a bit of

opponents, difficulty levels, and anything else I think

o do. I remembered how I loved playing monopoly

d me on to thinking that the game could be done in
was sketched out in my notepad. The board design has

dice button that is roughly summarised in the flowchart

eparate and fairly detailed processes. The majority of
heet formula. VBA takes care of the flow and user input.

3rd time?

Pay fine
3rd time?

Pay fine

Op owns? Tax? Card? Jail?

Calc Display
Calc tax
Rent Card

Move?

Chang
e Cash? Jail
Money

Show Allocate
Form In debt? Card

Finish
xlMonopoly
Create Your Own Board
Board
Official Rules Field Insert New Value
Instructions
Create New Board Board name Famous Streets
FAQ Currency Symbol €

Board Spaces Full Name

eg North Carolina Avenue

GO Go
Old Kent Road Sunset Boulevard
Community Chest Community Chest
Whitechapel Road Broadway
Income Tax We're screwing you!
King's Cross Station Grand Central Station
The Angel, Islington Champs Elysee
Chance Chance
Euston Road Nathan Road
Pentonville Road Orchard Road
Just Visiting Vistors center
Pall Mall Pennsilvania Avenue
Electric Company 7-Eleven
Whitehall Ocean Drive
Northumberland Avenue Connaught Place
Marylebone Station Gare du Nord
Bow Street Pike Street
Community Chest
Marlborough Street
Vine Street
Free Parking
The Strand
Chance
Fleet Street
Trafalgar Square
Liverpool Street Station
Leicester Square
Coventry Street
Water Works
Picadilly
Go To Jail
Regent Street
Oxford Street
Community Chest
Bond Street
Fenchurch Street Station
Chance
Park Lane
Super Tax
Mayfair

Remaining fields: ###

3
 An Excel game by charlie jans

Add Board (3 left)

Abreviated name for display Tester (check name fits neatly in box)
eg N Carl'na Avenue

Go Gd Cntr'l
Sunset Boul'vard Station
Comm Chest
Broadw'y Copy Names
We're screwing you! Across

Gd Cntr'l Station
Champs Elysee
Chance
Nathan Road
Orchard Road
Vistors center
Pennsilvania Avenue
7-Eleven
Ocean Drive
Connaught Place
Gare du Nord
Pike Street