{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Excel VBA Monopoly","Property Details","Version"],"not_rendered":{"images":26,"macros":1,"defined_names":390},"read":"whole","date_system":"1900"}

{"sheet":"Excel VBA Monopoly","index":0,"n_rows":242,"n_cols":57,"rows_kept":242,"merged":[[2,1,4,5],[2,43,4,45],[3,6,4,9],[3,10,5,13],[3,14,4,17],[3,18,4,21],[3,22,5,25],[3,26,4,29],[3,30,4,33],[3,34,5,37],[3,38,4,41],[6,1,8,4],[6,43,8,46],[6,49,6,50],[7,49,7,50],[8,49,8,50],[9,49,9,50],[10,1,12,4],[10,43,12,46],[11,49,11,50],[12,49,12,50],[13,49,13,50],[14,1,16,5],[14,42,16,46],[14,49,14,50],[16,49,16,50],[17,49,17,50],[18,1,20,4],[18,43,20,46],[18,49,18,50],[19,49,19,50],[21,49,21,50],[22,1,24,5],[22,8,25,40],[22,42,24,46],[22,49,22,50],[23,49,23,50],[24,49,24,50],[26,1,28,4],[26,8,29,40],[26,42,28,46],[30,1,32,4],[30,43,32,46],[34,1,36,5],[34,42,36,46],[38,1,40,4],[38,43,40,46],[42,14,44,17],[42,22,44,25],[42,26,44,29],[42,34,44,37],[42,42,42,46],[43,1,44,1],[43,3,44,4],[43,6,44,9],[43,10,44,13],[43,18,44,21],[43,30,44,33],[43,38,44,41],[43,43,45,45],[46,2,46,4],[159,22,159,23],[159,32,159,33],[159,42,159,43]]}
[]
[]
[null,"FREE PARKING",{"$nulls":41},"GO TO\nJAIL"]
[{"$nulls":6},{"$f":"IF(ISBLANK('Property Details'!D17),'Property Details'!C17,'Property Details'!D17)","v":"STRAND"},{"$nulls":3},"CHANCE\n?",{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D18),'Property Details'!C18,'Property Details'!D18)","v":"FLEET STREET"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D19),'Property Details'!C19,'Property Details'!D19)","v":"TRAFALGAR SQUARE"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D32),'Property Details'!C32,'Property Details'!D32)","v":"FENCHURCH ST STATION"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D20),'Property Details'!C20,'Property Details'!D20)","v":"LEICESTER SQUARE"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D21),'Property Details'!C21,'Property Details'!D21)","v":"COVENTRY STREET"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D37),'Property Details'!C37,'Property Details'!D37)","v":"WATER WORKS"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D22),'Property Details'!C22,'Property Details'!D22)","v":"PICCADILLY"},{"$nulls":10},"Player","Moves"]
[]
[]
[null,{"$f":"IF(ISBLANK('Property Details'!D16),'Property Details'!C16,'Property Details'!D16)","v":"VINE STREET"},{"$nulls":41},{"$f":"IF(ISBLANK('Property Details'!D23),'Property Details'!C23,'Property Details'!D23)","v":"REGENT STREET"},{"$nulls":5},"Player 1:"]
[{"$nulls":49},"Avatar:"]
[{"$nulls":49},"Cash:"]
[{"$nulls":49},"Get Out of Jail Free:"]
[null,{"$f":"IF(ISBLANK('Property Details'!D15),'Property Details'!C15,'Property Details'!D15)","v":"MARLBOROUGH STREET"},{"$nulls":41},{"$f":"IF(ISBLANK('Property Details'!D24),'Property Details'!C24,'Property Details'!D24)","v":"OXFORD STREET"}]
[{"$nulls":49},"Player 2:"]
[{"$nulls":49},"Avatar:"]
[{"$nulls":49},"Cash:"]
[null,"COMMUNITY CHEST",{"$nulls":40},"COMMUNITY CHEST",{"$nulls":6},"Get Out of Jail Free:"]
[]
[{"$nulls":49},"Player 3:"]
[{"$nulls":49},"Avatar:"]
[null,{"$f":"IF(ISBLANK('Property Details'!D14),'Property Details'!C14,'Property Details'!D14)","v":"BOW STREET"},{"$nulls":41},{"$f":"IF(ISBLANK('Property Details'!D25),'Property Details'!C25,'Property Details'!D25)","v":"BOND STREET"},{"$nulls":5},"Cash:"]
[{"$nulls":49},"Get Out of Jail Free:"]
[]
[{"$nulls":49},"Player 4:"]
[null,{"$f":"IF(ISBLANK('Property Details'!D31),'Property Details'!C31,'Property Details'!D31)","v":"MARYLEBONE STATION"},{"$nulls":6},{"$f":"'Property Details'!D2","v":"EXCEL VBA MONOPOLY"},{"$nulls":33},{"$f":"IF(ISBLANK('Property Details'!D33),'Property Details'!C33,'Property Details'!D33)","v":"LIVERPOOL ST STATION"},{"$nulls":6},"Avatar:"]
[{"$nulls":49},"Cash:"]
[{"$nulls":49},"Get Out of Jail Free:"]
[]
[null,{"$f":"IF(ISBLANK('Property Details'!D13),'Property Details'!C13,'Property Details'!D13)","v":"NORTHUMBERLAND AVENUE"},{"$nulls":6},{"$f":"'Property Details'!D3","v":"CLASSIC EDITION"},{"$nulls":33},"CHANCE\n?"]
[]
[]
[]
[null,{"$f":"IF(ISBLANK('Property Details'!D12),'Property Details'!C12,'Property Details'!D12)","v":"WHITEHALL"},{"$nulls":41},{"$f":"IF(ISBLANK('Property Details'!D26),'Property Details'!C26,'Property Details'!D26)","v":"PARK LANE"}]
[]
[{"$nulls":21},"Dice 1",{"$nulls":4},"Dice 2"]
[]
[null,{"$f":"IF(ISBLANK('Property Details'!D36),'Property Details'!C36,'Property Details'!D36)","v":"ELECTRIC COMPANY"},{"$nulls":40},"SUPER TAX\nPAY\n£100"]
[]
[]
[]
[null,{"$f":"IF(ISBLANK('Property Details'!D11),'Property Details'!C11,'Property Details'!D11)","v":"PALL MALL"},{"$nulls":41},{"$f":"IF(ISBLANK('Property Details'!D27),'Property Details'!C27,'Property Details'!D27)","v":"MAYFAIR"}]
[]
[]
[]
[{"$nulls":14},"CHANCE\n?",{"$nulls":7},{"$f":"IF(ISBLANK('Property Details'!D30),'Property Details'!C30,'Property Details'!D30)","v":"KINGS CROSS STATION"},{"$nulls":3},"INCOME TAX\nPAY \n£200",{"$nulls":7},"COMMUNITY CHEST",{"$nulls":7},"COLLECT £200"]
[null,"JUST",null,"IN JAIL",null,null,{"$f":"IF(ISBLANK('Property Details'!D10),'Property Details'!C10,'Property Details'!D10)","v":"PENTONVILLE ROAD"},{"$nulls":3},{"$f":"IF(ISBLANK('Property Details'!D9),'Property Details'!C9,'Property Details'!D9)","v":"EUSTON ROAD"},{"$nulls":7},{"$f":"IF(ISBLANK('Property Details'!D8),'Property Details'!C8,'Property Details'!D8)","v":"THE ANGEL ISLINGTON"},{"$nulls":11},{"$f":"IF(ISBLANK('Property Details'!D7),'Property Details'!C7,'Property Details'!D7)","v":"WHITECHAPEL ROAD"},{"$nulls":7},{"$f":"IF(ISBLANK('Property Details'!D6),'Property Details'!C6,'Property Details'!D6)","v":"OLD KENT ROAD"},{"$nulls":4},"GO!"]
[]
[]
[null,null,"VISITING"]
{"$rows_empty":56}
[null,"PLAYERS",{"$nulls":8},"BANKRUPTCY STATUS"]
[]
[{"$nulls":10},"P1","P2","P3","P4"]
[{"$nulls":10},0,0,0,0]
[]
[null,"PIECE ROSTER",{"$nulls":23},"PIECE REGISTER",{"$nulls":10},"F = Free",{"$nulls":3},"U = Used",{"$nulls":7},"PIECE LOCATION"]
[]
[null,null,1,null,2,null,3,null,4,null,5,null,6,null,7,null,8,null,9,{"$nulls":12},"PIECE NAME","F","U",null,null,"PIECE SELECTION PICKUP",{"$nulls":11},"P","LOC","INDEX","TURNS TO EXIT JAIL"]
[{"$nulls":25},1,{"$nulls":5},"Battleship",1,0,null,null,{"$f":"IFERROR(INDEX($AF$112:$AF$120,SMALL(IF($AG$112:$AG$120=1,ROW($AG$112:$AG$120)-ROW(INDEX($AG$112:$AG$120,1,1))+1),Z112:Z120)),\"\")","v":"Battleship"},{"$nulls":11},1,null,{"$f":"IFERROR(VLOOKUP(_xlfn.NUMBERVALUE(RIGHT(LEFT(AX112,LEN(AX112)-2),2)),$B$165:$C$204,2,FALSE),\"\")","v":""}]
[{"$nulls":25},2,{"$nulls":5},"Boot",1,0,null,null,"Boot",{"$nulls":11},2,null,{"$f":"IFERROR(VLOOKUP(_xlfn.NUMBERVALUE(RIGHT(LEFT(AX113,LEN(AX113)-2),2)),$B$165:$C$204,2,FALSE),\"\")","v":""}]
[{"$nulls":25},3,{"$nulls":5},"Cat",1,0,null,null,"Cat",{"$nulls":11},3,null,""]
[null,"DICE ROSTER",{"$nulls":23},4,{"$nulls":5},"Iron",1,0,null,null,"Iron",{"$nulls":11},4,null,""]
[{"$nulls":25},5,{"$nulls":5},"Racecar",1,0,null,null,"Racecar"]
[null,null,1,null,2,null,3,null,4,null,5,null,6,{"$nulls":12},6,{"$nulls":5},"Scottie Dog",1,0,null,null,"Scottie Dog"]
[null,"D1",{"$nulls":23},7,{"$nulls":5},"Top Hat",1,0,null,null,"Top Hat"]
[null,null,1,null,2,null,3,null,4,null,5,null,6,{"$nulls":12},8,{"$nulls":5},"T-Rex",1,0,null,null,"T-Rex"]
[null,"D2",{"$nulls":23},9,{"$nulls":5},"Wheelbarrow",1,0,null,null,"Wheelbarrow"]
[]
[null,"HOUSE & HOTEL ROSTER"]
[]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32]
[null,"HS"]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"HT"]
[]
[null,"PROPERTY REGISTER",{"$nulls":12},"MO = Mortgaged",{"$nulls":7},"HS = House",{"$nulls":5},"HT = Hotel"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19]
[{"$nulls":13},"P1","P2","P3","P4","MO","HS","HT",null,null,"P1",{"$nulls":9},"P2",{"$nulls":9},"P3",{"$nulls":8},"P4",{"$nulls":4},"Current Player"]
[null,1,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D6),'Property Details'!C6,'Property Details'!D6)","v":"OLD KENT ROAD"},0,0,0,0,0,0,0,null,1,{"$f":"IFERROR(INDEX($M$132:$M$159,SMALL(IF($N$132:$N$159=1,ROW($N$132:$N$159)-ROW(INDEX($N$132:$N$159,1,1))+1),B132:B159)),\"\")","v":""},{"$nulls":9},{"$f":"IFERROR(INDEX($M$132:$M$159,SMALL(IF($O$132:$O$159=1,ROW($O$132:$O$159)-ROW(INDEX($O$132:$O$159,1,1))+1),B132:B159)),\"\")","v":""},{"$nulls":9},{"$f":"IFERROR(INDEX($M$132:$M$159,SMALL(IF($P$132:$P$159=1,ROW($P$132:$P$159)-ROW(INDEX($P$132:$P$159,1,1))+1),B132:B159)),\"\")","v":""},{"$nulls":8},{"$f":"IFERROR(INDEX($M$132:$M$159,SMALL(IF($Q$132:$Q$159=1,ROW($Q$132:$Q$159)-ROW(INDEX($Q$132:$Q$159,1,1))+1),B132:B159)),\"\")","v":""},{"$nulls":4},{"$f":"IF(Player=1,W132,IF(Player=2,AG132,IF(Player=3,AQ132,AZ132)))","v":""}]
[null,2,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D7),'Property Details'!C7,'Property Details'!D7)","v":"WHITECHAPEL ROAD"},0,0,0,0,0,0,0,null,2,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,3,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D8),'Property Details'!C8,'Property Details'!D8)","v":"THE ANGEL ISLINGTON"},0,0,0,0,0,0,0,null,3,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,4,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D9),'Property Details'!C9,'Property Details'!D9)","v":"EUSTON ROAD"},0,0,0,0,0,0,0,null,4,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,5,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D10),'Property Details'!C10,'Property Details'!D10)","v":"PENTONVILLE ROAD"},0,0,0,0,0,0,0,null,5,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,6,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D11),'Property Details'!C11,'Property Details'!D11)","v":"PALL MALL"},0,0,0,0,0,0,0,null,6,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,7,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D12),'Property Details'!C12,'Property Details'!D12)","v":"WHITEHALL"},0,0,0,0,0,0,0,null,7,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,8,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D13),'Property Details'!C13,'Property Details'!D13)","v":"NORTHUMBERLAND AVENUE"},0,0,0,0,0,0,0,null,8,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,9,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D14),'Property Details'!C14,'Property Details'!D14)","v":"BOW STREET"},0,0,0,0,0,0,0,null,9,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,10,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D15),'Property Details'!C15,'Property Details'!D15)","v":"MARLBOROUGH STREET"},0,0,0,0,0,0,0,null,10,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,11,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D16),'Property Details'!C16,'Property Details'!D16)","v":"VINE STREET"},0,0,0,0,0,0,0,null,11,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,12,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D17),'Property Details'!C17,'Property Details'!D17)","v":"STRAND"},0,0,0,0,0,0,0,null,12,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,13,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D18),'Property Details'!C18,'Property Details'!D18)","v":"FLEET STREET"},0,0,0,0,0,0,0,null,13,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,14,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D19),'Property Details'!C19,'Property Details'!D19)","v":"TRAFALGAR SQUARE"},0,0,0,0,0,0,0,null,14,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,15,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D20),'Property Details'!C20,'Property Details'!D20)","v":"LEICESTER SQUARE"},0,0,0,0,0,0,0,null,15,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,16,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D21),'Property Details'!C21,'Property Details'!D21)","v":"COVENTRY STREET"},0,0,0,0,0,0,0,null,16,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,17,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D22),'Property Details'!C22,'Property Details'!D22)","v":"PICCADILLY"},0,0,0,0,0,0,0,null,17,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,18,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D23),'Property Details'!C23,'Property Details'!D23)","v":"REGENT STREET"},0,0,0,0,0,0,0,null,18,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,19,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D24),'Property Details'!C24,'Property Details'!D24)","v":"OXFORD STREET"},0,0,0,0,0,0,0,null,19,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,20,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D25),'Property Details'!C25,'Property Details'!D25)","v":"BOND STREET"},0,0,0,0,0,0,0,null,20,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,21,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D26),'Property Details'!C26,'Property Details'!D26)","v":"PARK LANE"},0,0,0,0,0,0,0,null,21,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,22,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D27),'Property Details'!C27,'Property Details'!D27)","v":"MAYFAIR"},0,0,0,0,0,0,0,null,22,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,23,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D30),'Property Details'!C30,'Property Details'!D30)","v":"KINGS CROSS STATION"},0,0,0,0,0,0,0,null,23,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,24,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D31),'Property Details'!C31,'Property Details'!D31)","v":"MARYLEBONE STATION"},0,0,0,0,0,0,0,null,24,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,25,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D32),'Property Details'!C32,'Property Details'!D32)","v":"FENCHURCH ST STATION"},0,0,0,0,0,0,0,null,25,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,26,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D33),'Property Details'!C33,'Property Details'!D33)","v":"LIVERPOOL ST STATION"},0,0,0,0,0,0,0,null,26,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,27,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D36),'Property Details'!C36,'Property Details'!D36)","v":"ELECTRIC COMPANY"},0,0,0,0,0,0,0,null,27,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[null,28,{"$nulls":10},{"$f":"IF(ISBLANK('Property Details'!D37),'Property Details'!C37,'Property Details'!D37)","v":"WATER WORKS"},0,0,0,0,0,0,0,null,28,"",{"$nulls":9},"",{"$nulls":9},"",{"$nulls":8},"",{"$nulls":4},""]
[{"$nulls":12},"TOTAL",{"$f":"SUM(N132:N159)","v":0},{"$f":"SUM(O132:O159)","v":0},0,0,0,0,0,null,null,{"$f":"COUNTA(W132:W159)-COUNTBLANK(W132:W159)","v":0},{"$nulls":9},{"$f":"COUNTA(AG132:AG159)-COUNTBLANK(AG132:AG159)","v":0},{"$nulls":9},{"$f":"COUNTA(AQ132:AQ159)-COUNTBLANK(AQ132:AQ159)","v":0},{"$nulls":8},{"$f":"COUNTA(AZ132:AZ159)-COUNTBLANK(AZ132:AZ159)","v":0},{"$nulls":4},{"$f":"COUNTA(BE132:BE159)-COUNTBLANK(BE132:BE159)","v":0}]
[]
[null,"LOCATION LOOKUP",{"$nulls":10},"PROPERTY SUMMARY"]
[]
[null,"SQ","INDEX",{"$nulls":10},"P1","P2","P3","P4"]
[null,1,"GO",{"$nulls":9},"HS",{"$f":"SUMIFS($S$132:$S$159,N132:N159,\"=1\")","v":0},{"$f":"SUMIFS($S$132:$S$159,O132:O159,\"=1\")","v":0},{"$f":"SUMIFS($S$132:$S$159,P132:P159,\"=1\")","v":0},0]
[null,2,1,{"$nulls":9},"HT",{"$f":"SUMIFS($T$132:$T$159,N132:N159,\"=1\")","v":0},{"$f":"SUMIFS($T$132:$T$159,O132:O159,\"=1\")","v":0},0,0]
[null,3,"CC"]
[null,4,2]
[null,5,"IT"]
[null,6,23]
[null,7,3]
[null,8,"CH"]
[null,9,4]
[null,10,5]
[null,11,"JAIL"]
[null,12,6]
[null,13,27]
[null,14,7]
[null,15,8]
[null,16,24]
[null,17,9]
[null,18,"CC"]
[null,19,10]
[null,20,11]
[null,21,"FP"]
[null,22,12]
[null,23,"CH"]
[null,24,13]
[null,25,14]
[null,26,25]
[null,27,15]
[null,28,16]
[null,29,28]
[null,30,17]
[null,31,"GTJ"]
[null,32,18]
[null,33,19]
[null,34,"CC"]
[null,35,20]
[null,36,26]
[null,37,"CH"]
[null,38,21]
[null,39,"ST"]
[null,40,22]
[]
[null,"CHANCE CARDS"]
[null,"Index","Ord","Description"]
[null,1,8,"Advance to Go"]
[null,2,9,"Go to jail. Move directly to jail. Do not pass Go. Do not collect £200"]
[null,3,3,{"$f":"\"Advance to \"&PROPER($M$137)&\". If you pass Go collection £200\"","v":"Advance to Pall Mall. If you pass Go collection £200"}]
[null,4,15,{"$f":"\"Take a trip to \"&PROPER($M$155)&\" and if you pass Go collect £200\"","v":"Take a trip to Marylebone Station and if you pass Go collect £200"}]
[null,5,4,{"$f":"\"Advance to \"&PROPER($M$145)&\". If you pass Go collect £200\"","v":"Advance to Trafalgar Square. If you pass Go collect £200"}]
[null,6,7,{"$f":"\"Advance to \"&PROPER($M$153)","v":"Advance to Mayfair"}]
[null,7,14,"Go back three spaces"]
[null,8,1,"Make general repairs on all of your houses. For each house pay £25. For each hotel pay £100"]
[null,9,12,"You are assessed for street repairs: £40 per house, £115 per hotel"]
[null,10,5,"Pay school fees of £150"]
[null,11,6,"Drunk in charge fine £20"]
[null,12,10,"Speeding fine £15"]
[null,13,2,"Your building loan matures. Receive £150"]
[null,14,11,"You have won a crossword competition. Collect £100"]
[null,15,13,"Bank pays you dividend of £50"]
[null,16,16,"Get out of jail free. This card may be kept until needed or sold"]
[]
[null,"COMMUNITY CHEST CARDS"]
[null,"Index","Ord","Description"]
[null,1,7,"Advance to Go. Collect £200"]
[null,2,16,"Go back to Old Kent Road"]
[null,3,1,"Go to jail. Move directly to jail. Do not pass Go. Do not collect £200"]
[null,4,6,"Pay hospital £100"]
[null,5,10,"Doctor's fee. Pay £50"]
[null,6,9,"Pay your insurance premium £50"]
[null,7,4,"Bank error in your favour. Collect £200"]
[null,8,14,"Annuity matures. Collect £100"]
[null,9,2,"You inherit £100"]
[null,10,5,"From sale of stock you get £50"]
[null,11,12,"Receive interest on 7% preference shares: £25"]
[null,12,8,"Income tax refund. Collect £20"]
[null,13,13,"You have won second prize in a beauty contest. Collect £10"]
[null,14,15,"It is your birthday. Collect £10 from each player"]
[null,15,3,"Get out of jail free. This card may be kept until needed or sold"]
[null,16,11,"Pay a £10 fine or take a Chance"]

{"sheet":"Property Details","index":1,"n_rows":37,"n_cols":17,"rows_kept":37}
[]
[null,null,"Game Name:","EXCEL VBA MONOPOLY",null,null,"Key:"]
[null,null,"Edition:","CLASSIC EDITION",null,null,"User data entry"]
[]
[null,"Index","Title Deed","Enter Alternative Name","Owner ","Player Name","Mortgaged","Price","Rent","With 1 House","With 2 Houses","With 3 Houses","With 4 Houses","With Hotel","Mortgage Value","House Cost","Hotel Cost"]
[null,1,"OLD KENT ROAD",null,{"$f":"IF(VLOOKUP(B6,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B6,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B6,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B6,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E6=1,P1_Name,IF(E6=2,P2_Name,IF(E6=3,P3_Name,IF(E6=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B6,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":60,"d":"£60"},{"v":2,"d":"£2"},{"v":10,"d":"£10"},{"v":30,"d":"£30"},{"v":90,"d":"£90"},{"v":160,"d":"£160"},{"v":250,"d":"£250"},{"v":50,"d":"£50"},{"v":30,"d":"£30"},{"v":30,"d":"£30"}]
[null,2,"WHITECHAPEL ROAD",null,{"$f":"IF(VLOOKUP(B7,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B7,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B7,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B7,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B7,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":60,"d":"£60"},{"v":4,"d":"£4"},{"v":20,"d":"£20"},{"v":60,"d":"£60"},{"v":180,"d":"£180"},{"v":360,"d":"£360"},{"v":450,"d":"£450"},{"v":50,"d":"£50"},{"v":30,"d":"£30"},{"v":30,"d":"£30"}]
[null,3,"THE ANGEL ISLINGTON",null,{"$f":"IF(VLOOKUP(B8,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B8,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B8,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B8,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B8,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":100,"d":"£100"},{"v":6,"d":"£6"},{"v":30,"d":"£30"},{"v":90,"d":"£90"},{"v":270,"d":"£270"},{"v":400,"d":"£400"},{"v":550,"d":"£550"},{"v":50,"d":"£50"},{"v":50,"d":"£50"},{"v":50,"d":"£50"}]
[null,4,"EUSTON ROAD",null,{"$f":"IF(VLOOKUP(B9,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B9,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B9,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B9,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B9,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":100,"d":"£100"},{"v":6,"d":"£6"},{"v":30,"d":"£30"},{"v":90,"d":"£90"},{"v":270,"d":"£270"},{"v":400,"d":"£400"},{"v":550,"d":"£550"},{"v":50,"d":"£50"},{"v":50,"d":"£50"},{"v":50,"d":"£50"}]
[null,5,"PENTONVILLE ROAD",null,{"$f":"IF(VLOOKUP(B10,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B10,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B10,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B10,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B10,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":120,"d":"£120"},{"v":8,"d":"£8"},{"v":40,"d":"£40"},{"v":100,"d":"£100"},{"v":300,"d":"£300"},{"v":450,"d":"£450"},{"v":600,"d":"£600"},{"v":60,"d":"£60"},{"v":50,"d":"£50"},{"v":50,"d":"£50"}]
[null,6,"PALL MALL",null,{"$f":"IF(VLOOKUP(B11,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B11,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B11,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B11,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B11,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":140,"d":"£140"},{"v":10,"d":"£10"},{"v":50,"d":"£50"},{"v":150,"d":"£150"},{"v":450,"d":"£450"},{"v":625,"d":"£625"},{"v":750,"d":"£750"},{"v":70,"d":"£70"},{"v":100,"d":"£100"},{"v":100,"d":"£100"}]
[null,7,"WHITEHALL",null,{"$f":"IF(VLOOKUP(B12,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B12,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B12,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B12,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B12,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":140,"d":"£140"},{"v":10,"d":"£10"},{"v":50,"d":"£50"},{"v":150,"d":"£150"},{"v":450,"d":"£450"},{"v":625,"d":"£625"},{"v":750,"d":"£750"},{"v":70,"d":"£70"},{"v":100,"d":"£100"},{"v":100,"d":"£100"}]
[null,8,"NORTHUMBERLAND AVENUE",null,{"$f":"IF(VLOOKUP(B13,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B13,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B13,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B13,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B13,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":160,"d":"£160"},{"v":12,"d":"£12"},{"v":60,"d":"£60"},{"v":180,"d":"£180"},{"v":500,"d":"£500"},{"v":700,"d":"£700"},{"v":900,"d":"£900"},{"v":80,"d":"£80"},{"v":100,"d":"£100"},{"v":100,"d":"£100"}]
[null,9,"BOW STREET",null,{"$f":"IF(VLOOKUP(B14,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B14,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B14,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B14,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B14,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":180,"d":"£180"},{"v":14,"d":"£14"},{"v":70,"d":"£70"},{"v":200,"d":"£200"},{"v":550,"d":"£550"},{"v":750,"d":"£750"},{"v":950,"d":"£950"},{"v":90,"d":"£90"},{"v":100,"d":"£100"},{"v":100,"d":"£100"}]
[null,10,"MARLBOROUGH STREET",null,{"$f":"IF(VLOOKUP(B15,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B15,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B15,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B15,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B15,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":180,"d":"£180"},{"v":14,"d":"£14"},{"v":70,"d":"£70"},{"v":200,"d":"£200"},{"v":550,"d":"£550"},{"v":750,"d":"£750"},{"v":950,"d":"£950"},{"v":90,"d":"£90"},{"v":100,"d":"£100"},{"v":100,"d":"£100"}]
[null,11,"VINE STREET",null,{"$f":"IF(VLOOKUP(B16,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B16,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B16,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B16,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B16,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":200,"d":"£200"},{"v":16,"d":"£16"},{"v":80,"d":"£80"},{"v":220,"d":"£220"},{"v":600,"d":"£600"},{"v":800,"d":"£800"},{"v":1000,"d":"£1,000"},{"v":100,"d":"£100"},{"v":100,"d":"£100"},{"v":100,"d":"£100"}]
[null,12,"STRAND",null,{"$f":"IF(VLOOKUP(B17,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B17,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B17,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B17,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B17,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":220,"d":"£220"},{"v":18,"d":"£18"},{"v":90,"d":"£90"},{"v":250,"d":"£250"},{"v":700,"d":"£700"},{"v":875,"d":"£875"},{"v":1050,"d":"£1,050"},{"v":110,"d":"£110"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,13,"FLEET STREET",null,{"$f":"IF(VLOOKUP(B18,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B18,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B18,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B18,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B18,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":220,"d":"£220"},{"v":18,"d":"£18"},{"v":90,"d":"£90"},{"v":250,"d":"£250"},{"v":700,"d":"£700"},{"v":875,"d":"£875"},{"v":1050,"d":"£1,050"},{"v":110,"d":"£110"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,14,"TRAFALGAR SQUARE",null,{"$f":"IF(VLOOKUP(B19,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B19,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B19,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B19,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B19,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":240,"d":"£240"},{"v":20,"d":"£20"},{"v":100,"d":"£100"},{"v":300,"d":"£300"},{"v":750,"d":"£750"},{"v":925,"d":"£925"},{"v":1100,"d":"£1,100"},{"v":120,"d":"£120"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,15,"LEICESTER SQUARE",null,{"$f":"IF(VLOOKUP(B20,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B20,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B20,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B20,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B20,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":260,"d":"£260"},{"v":22,"d":"£22"},{"v":110,"d":"£110"},{"v":330,"d":"£330"},{"v":800,"d":"£800"},{"v":975,"d":"£975"},{"v":1150,"d":"£1,150"},{"v":130,"d":"£130"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,16,"COVENTRY STREET",null,{"$f":"IF(VLOOKUP(B21,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B21,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B21,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B21,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B21,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":260,"d":"£260"},{"v":22,"d":"£22"},{"v":110,"d":"£110"},{"v":330,"d":"£330"},{"v":800,"d":"£800"},{"v":975,"d":"£975"},{"v":1150,"d":"£1,150"},{"v":130,"d":"£130"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,17,"PICCADILLY",null,{"$f":"IF(VLOOKUP(B22,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B22,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B22,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B22,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B22,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":280,"d":"£280"},{"v":22,"d":"£22"},{"v":120,"d":"£120"},{"v":360,"d":"£360"},{"v":850,"d":"£850"},{"v":1025,"d":"£1,025"},{"v":1200,"d":"£1,200"},{"v":140,"d":"£140"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,18,"REGENT STREET",null,{"$f":"IF(VLOOKUP(B23,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B23,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B23,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B23,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B23,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":300,"d":"£300"},{"v":26,"d":"£26"},{"v":130,"d":"£130"},{"v":390,"d":"£390"},{"v":900,"d":"£900"},{"v":1100,"d":"£1,100"},{"v":1275,"d":"£1,275"},{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,19,"OXFORD STREET",null,{"$f":"IF(VLOOKUP(B24,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B24,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B24,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B24,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B24,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":300,"d":"£300"},{"v":26,"d":"£26"},{"v":130,"d":"£130"},{"v":390,"d":"£390"},{"v":900,"d":"£900"},{"v":1100,"d":"£1,100"},{"v":1275,"d":"£1,275"},{"v":200,"d":"£200"},{"v":150,"d":"£150"},{"v":150,"d":"£150"}]
[null,20,"BOND STREET",null,{"$f":"IF(VLOOKUP(B25,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B25,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B25,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B25,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B25,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":320,"d":"£320"},{"v":28,"d":"£28"},{"v":150,"d":"£150"},{"v":450,"d":"£450"},{"v":1000,"d":"£1,000"},{"v":1200,"d":"£1,200"},{"v":1400,"d":"£1,400"},{"v":200,"d":"£200"},{"v":160,"d":"£160"},{"v":160,"d":"£160"}]
[null,21,"PARK LANE",null,{"$f":"IF(VLOOKUP(B26,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B26,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B26,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B26,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B26,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":350,"d":"£350"},{"v":35,"d":"£35"},{"v":175,"d":"£175"},{"v":500,"d":"£500"},{"v":1100,"d":"£1,100"},{"v":1300,"d":"£1,300"},{"v":1500,"d":"£1,500"},{"v":175,"d":"£175"},{"v":200,"d":"£200"},{"v":200,"d":"£200"}]
[null,22,"MAYFAIR",null,{"$f":"IF(VLOOKUP(B27,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B27,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B27,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B27,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},"",{"$f":"IF(VLOOKUP(B27,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":400,"d":"£400"},{"v":50,"d":"£50"},{"v":200,"d":"£200"},{"v":600,"d":"£600"},{"v":1400,"d":"£1,400"},{"v":1700,"d":"£1,700"},{"v":2000,"d":"£2,000"},{"v":200,"d":"£200"},{"v":200,"d":"£200"},{"v":200,"d":"£200"}]
[]
[null,"Index","Title Deed","Enter Alternative Name","Owner ","Player Name","Mortgaged","Price","1 Station","2 Stations","3 Stations","4 Stations","Mortgage Value"]
[null,23,"KINGS CROSS STATION",null,{"$f":"IF(VLOOKUP(B30,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B30,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B30,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B30,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E30=1,P1_Name,IF(E30=2,P2_Name,IF(E30=3,P3_Name,IF(E30=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B30,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":200,"d":"£200"},{"v":25,"d":"£25"},{"v":50,"d":"£50"},{"v":100,"d":"£100"},{"v":200,"d":"£200"},{"v":100,"d":"£100"}]
[null,24,"MARYLEBONE STATION",null,{"$f":"IF(VLOOKUP(B31,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B31,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B31,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B31,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E31=1,P1_Name,IF(E31=2,P2_Name,IF(E31=3,P3_Name,IF(E31=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B31,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":200,"d":"£200"},{"v":25,"d":"£25"},{"v":50,"d":"£50"},{"v":100,"d":"£100"},{"v":200,"d":"£200"},{"v":100,"d":"£100"}]
[null,25,"FENCHURCH ST STATION",null,{"$f":"IF(VLOOKUP(B32,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B32,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B32,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B32,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E32=1,P1_Name,IF(E32=2,P2_Name,IF(E32=3,P3_Name,IF(E32=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B32,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":200,"d":"£200"},{"v":25,"d":"£25"},{"v":50,"d":"£50"},{"v":100,"d":"£100"},{"v":200,"d":"£200"},{"v":100,"d":"£100"}]
[null,26,"LIVERPOOL ST STATION",null,{"$f":"IF(VLOOKUP(B33,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B33,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B33,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B33,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E33=1,P1_Name,IF(E33=2,P2_Name,IF(E33=3,P3_Name,IF(E33=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B33,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":200,"d":"£200"},{"v":25,"d":"£25"},{"v":50,"d":"£50"},{"v":100,"d":"£100"},{"v":200,"d":"£200"},{"v":100,"d":"£100"}]
[]
[null,"Index","Title Deed","Enter Alternative Name","Owner ","Player Name","Mortgaged","Price","1 Title","2 Titles","Mortgage Value"]
[null,27,"ELECTRIC COMPANY",null,{"$f":"IF(VLOOKUP(B36,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B36,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B36,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B36,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E36=1,P1_Name,IF(E36=2,P2_Name,IF(E36=3,P3_Name,IF(E36=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B36,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":150,"d":"£150"},"4x Dice","10x Dice",{"v":75,"d":"£75"}]
[null,28,"WATER WORKS",null,{"$f":"IF(VLOOKUP(B37,'Excel VBA Monopoly'!$B$132:$Q$159,13,FALSE)>0,1,IF(VLOOKUP(B37,'Excel VBA Monopoly'!$B$132:$Q$159,14,FALSE)>0,2,IF(VLOOKUP(B37,'Excel VBA Monopoly'!$B$132:$Q$159,15,FALSE)>0,3,IF(VLOOKUP(B37,'Excel VBA Monopoly'!$B$132:$Q$159,16,FALSE)>0,4,\"\"))))","v":""},{"$f":"IF(E37=1,P1_Name,IF(E37=2,P2_Name,IF(E37=3,P3_Name,IF(E37=4,P4_Name,\"\"))))","v":""},{"$f":"IF(VLOOKUP(B37,'Excel VBA Monopoly'!$B$132:$R$159,17,FALSE)>0,\"Yes\",\"\")","v":""},{"v":150,"d":"£150"},"4x Dice","10x Dice",{"v":75,"d":"£75"}]

{"sheet":"Version","index":2,"n_rows":30,"n_cols":4,"rows_kept":30}
[]
[null,"Version","Date","Description"]
[null,{"v":0.1,"d":"0.10"},"2019-12-28","Development. Initial Board setup. Piece, Dice, House & Hotel shape import."]
[null,0.15,"2019-12-29","Development. Reset piece sub introduced. Named ranges added for board. Property Details tab added."]
[null,{"v":0.2,"d":"0.20"},"2020-01-04","Development. Userforms added for start game player number selection and name entry. Reset board functionality added."]
[null,0.23,"2020-01-05","Development. Userform added for Avatar selection. Piece Register added."]
[null,0.25,"2020-01-19","Development. Avatar placement and dice roll added. Movement of pieces and location storage."]
[null,0.28,"2020-02-02","Development. Avatar passing Go! handled. Multiple Avatars landing on same square handled. Jail scenarios: 3 doubles rolled, land on Go To Jail square."]
[null,{"v":0.3,"d":"0.30"},"2020-02-03","Development. Options of how to get out of Jail created on Userform (£50 fine, use GOJF card, buy GOJF card from another player, roll double)."]
[null,0.32,"2020-02-04","Development. Jail £50 fine and use own GOJF card options implemented. Userform created to buy GOJF card from another player."]
[null,0.34,"2020-04-18","Development. Alteration to allow network play/save & exit: 'Players' global variable changed to named range. Buy GOJF card from another player implemented."]
[null,0.35,"2020-04-19","Development. Wait 3 turns for Jail exit or throw a double for exit implemented."]
[null,0.37,"2020-04-28","Development. Chance and Community Chest cards- shuffle decks."]
[null,0.39,"2020-05-03","Development. Determine what happens when a player lands on Community Chest and Chance spaces handled."]
[null,0.41,"2020-05-10","Development. Determine what happens when a player lands on a property (sites, stations or utilities). Buy property option if not owned. If owned pay rent on property according to:\nSites: full set (x2 rent), House count and Hotel count.\nStations: numbers owned. \nUtilities: numbers owned and dice roll multiplier."]
[null,0.52,"2020-05-17","Development. Buying Houses and Hotels. Placement of House and Hotel shapes. Removal of House shapes when Hotel bought."]
[null,0.55,"2020-05-25","Development. Selling Houses and Hotels. Removal of Houses. When Hotel removed replaced with 4 Houses."]
[null,0.58,"2020-05-31","Development. Mortgaging a property. Rent cannot be collected on mortgaged property. Cannot build houses on colour group with mortgaged property. Cannot mortgage property more than once. Unmortgaging a property."]
[null,0.62,"2020-06-20","Development. Selling properties to other players- selling implemented."]
[null,0.65,"2020-06-21","Development. Buying properties from other players- buying implemented. Swapping between players implemented."]
[null,0.72,"2020-06-27","Development. Dealing with bankruptcy to another player- redistribution of property and selling of any houses/hotels. Return of houses & hotels to roster and piece to roster."]
[null,0.75,"2020-06-28","Development. Dealing with bankruptcy to the bank- redistribution of property and selling of any houses/hotels. Return of houses & hotels to roster and piece to roster."]
[null,0.78,"2020-06-28","Development. Skipping turns for bankrupt players. Declaring a winner when only one player left."]
[null,0.81,"2020-06-29","Bug fix. Bug in Bankruptcy scenario- variable \"PlayerCashStr\" not defined."]
[null,0.84,"2020-07-10","Bug fix. Bug in GOJF and Jail reset turns. "]
[null,{"v":1,"d":"1.00"},"2020-09-13","Bug fix. Errors when pressing buttons prior to beginning game.\nFinal Version."]
[null,1.01,"2021-03-09","Bug fix. Error with buying property from another player- addition/subtraction the wrong way round.\nFinal Version."]
[null,1.02,"2021-03-09","Bug fix. Error with initiation of number of turns to get out of Jail when landing on \"Go to Jail\".\nFinal Version."]
[]
[null,"Contact:","tomhedge1981@gmail.com"]