{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cover","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
[]
[]
[null,null,{"$f":"Client_Name","v":"Excel at Monopoly #3"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Tim Heng"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple expected value calculation for Monopoly properties"]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"tim.heng@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Sheet1","index":1,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[1,8,1,11]]}
["Expected Values"]
[null,null,null,null,null,null,null,null,"Houses",null,null,null,"Hotels"]
[null,"UK version","US version","Property group",null,"Probability of landing","Rental","Own all properties",1,2,3,4,1,null,"EV (base rental)","EV (enhanced rental)","1 house","2 houses","3 houses","4 houses","1 Hotel"]
[null,"Old Kent Road","Mediterranean Avenue","Brown",null,2.11521E-2,2,{"$f":"G4*2","v":4},10,30,90,160,250,null,{"$f":"G4*$F4","v":4.23042E-2},{"$f":"H4*$F4","v":8.46084E-2},0.21152100000000001,0.63456299999999999,1.903689,3.3843360000000002,5.2880250000000002]
[null,"Whitechapel Road","Baltic Avenue","Brown",null,2.14471E-2,4,{"$f":"G5*2","v":8},20,60,180,320,450,null,{"$f":"G5*$F5","v":8.5788400000000001E-2},0.1715768,0.42894199999999999,1.286826,3.8604780000000001,6.8630719999999998,9.6511949999999995]
[null,"The Angel Islington","Oriental Avenue","Light blue",null,2.2384299999999999E-2,6,12,30,90,270,400,550,null,0.1343058,0.26861160000000001,0.67152899999999993,2.0145870000000001,6.0437609999999999,8.9537200000000006,12.311365]
[null,"Euston Road","Vermont Avenue","Light blue",null,2.2967000000000001E-2,6,12,30,90,270,400,550,null,0.13780200000000001,0.27560400000000002,0.68901000000000001,2.0670299999999999,6.2010900000000007,9.1867999999999999,12.63185]
[null,"Pentonville Road","Connecticut Avenue","Light blue",null,2.2793799999999999E-2,8,16,40,100,300,450,600,null,0.1823504,0.36470079999999999,0.91175200000000001,2.2793799999999997,6.8381400000000001,10.257210000000001,13.67628]
[null,"Pall Mall","St. Charles Place","Pink",null,2.2173499999999999E-2,10,20,50,150,450,625,750,null,0.22173499999999999,0.44346999999999998,1.1086749999999999,3.326025,9.9780749999999987,13.858437499999999,16.630125]
[null,"Whitehall","States Avenue","Pink",null,2.76776E-2,10,20,50,150,450,625,750,null,0.27677600000000002,0.55355200000000004,1.38388,4.1516400000000004,12.45492,17.298500000000001,20.758199999999999]
[null,"Northumberland Avenue","Virginia Avenue","Pink",null,2.5030199999999999E-2,12,24,60,180,500,700,900,null,0.30036239999999997,0.60072479999999995,1.5018119999999999,4.5054359999999996,12.5151,17.521139999999999,22.527179999999998]
[null,"Bow Street","St. James Place","Orange",null,2.79762E-2,14,28,70,200,550,750,950,null,0.39166679999999998,0.78333359999999996,1.958334,5.5952399999999995,15.38691,20.982150000000001,26.577390000000001]
[null,"Marlborough Street","Tennessee Avenue","Orange",null,2.9378700000000001E-2,14,28,70,200,550,750,950,null,0.4113018,0.82260359999999999,2.0565090000000001,5.8757400000000004,16.158284999999999,22.034025,27.909765]
[null,"Vine Street","New York Avenue","Orange",null,2.99169E-2,16,32,80,220,600,800,1000,null,0.4786704,0.95734079999999999,2.3933520000000001,6.5817179999999995,17.950140000000001,23.933520000000001,29.916899999999998]
[null,"The Strand","Kentucky Avenue","Red",null,2.7909099999999999E-2,18,36,90,250,700,875,1050,null,0.50236380000000003,1.0047276000000001,2.511819,6.9772749999999997,19.536369999999998,24.420462499999999,29.304555000000001]
[null,"Fleet Street","Indiana Avenue","Red",null,2.7187200000000002E-2,18,36,90,250,700,875,1050,null,0.48936960000000002,0.97873920000000003,2.4468480000000001,6.7968000000000002,19.031040000000001,23.788800000000002,28.546560000000003]
[null,"Trafalgar Square","Illinois Avenue","Red",null,3.1671400000000002E-2,20,40,100,300,750,925,1100,null,0.6334280000000001,1.2668560000000002,3.1671400000000003,9.5014200000000013,23.753550000000001,29.296045000000003,34.838540000000002]
[null,"Leicester Square","Atlantic Avenue","Yellow",null,2.6752499999999999E-2,22,44,110,330,800,975,1150,null,0.58855499999999994,1.1771099999999999,2.9427749999999997,8.8283249999999995,21.401999999999997,26.0836875,30.765374999999999]
[null,"Coventry Street","Ventnor Avenue","Yellow",null,2.6527599999999998E-2,22,44,110,330,800,975,1150,null,0.58360719999999999,1.1672144,2.9180359999999999,8.7541079999999987,21.222079999999998,25.864409999999999,30.506739999999997]
[null,"Piccadilly","Marvin Gardens","Yellow",null,2.5652700000000001E-2,24,48,120,360,850,1025,1200,null,0.61566480000000001,{"$f":"H20*$F20","v":1.2313296},{"$f":"I20*$F20","v":3.0783240000000003},{"$f":"J20*$F20","v":9.2349720000000008},{"$f":"K20*$F20","v":21.804795000000002},{"$f":"L20*$F20","v":26.294017499999999},{"$f":"M20*$F20","v":30.783239999999999}]
[null,"Regent Street","Pacific Avenue","Green",null,2.6563199999999999E-2,26,52,130,390,900,1100,1275,null,0.69064320000000001,1.3812864,3.4532159999999998,10.359648,23.906879999999997,29.219519999999999,33.868079999999999]
[null,"Oxford Street","North Carolina Avenue","Green",null,2.60507E-2,26,52,130,390,900,1100,1275,null,0.67731819999999998,1.3546364,3.3865910000000001,10.159772999999999,23.445630000000001,28.65577,33.214642499999997]
[null,"Bond Street","Pennsylvania Avenue","Green",null,2.4783300000000001E-2,28,56,150,450,1000,1200,1400,null,0.6939324,1.3878648,3.717495,11.152485,24.783300000000001,29.73996,34.696620000000003]
[null,"Park Lane","Park Place","Dark Blue",null,2.1678599999999999E-2,35,70,175,500,1100,1300,1500,null,0.75875099999999995,1.5175019999999999,3.793755,10.8393,23.84646,28.182179999999999,32.517899999999997]
[null,"Mayfair","Boardwalk","Dark Blue",null,2.60745E-2,50,100,200,600,1400,1700,2000,null,1.303725,2.60745,5.2149000000000001,15.6447,36.504300000000001,44.326650000000001,52.149000000000001]
[null,"King's Cross Station","Reading Railroad","Railroads",null,2.9391799999999999E-2,null,null,25,50,100,200,null,null,0,0,0.73479499999999998,1.46959,2.9391799999999999,5.8783599999999998,0]
[null,"Marylebone Station","Pennsylvania Railroad","Railroads",null,2.80497E-2,null,null,25,50,100,200,null,null,0,0,0.70124249999999999,1.402485,2.80497,5.6099399999999999,0]
[null,"Fenchurch St Station","B. & O. Railroad","Railroads",null,3.0413699999999998E-2,null,null,25,50,100,200,null,null,0,0,0.76034249999999992,1.5206849999999998,3.0413699999999997,6.0827399999999994,0]
[null,"Liverpool Street Station","Short Line","Railroads",null,2.4107199999999999E-2,null,null,25,50,100,200,null,null,0,0,0.60267999999999999,1.20536,2.41072,4.8214399999999999,0]
[null,"Electric Company","Electric Company","Utilities",null,2.6027700000000001E-2,14,70,null,null,null,null,null,null,0.36438780000000004,1.821939,0,0,0,0,0]
[null,"Water Works","Water Works","Utilities",null,2.7868299999999999E-2,14,70,null,null,null,null,null,null,0.39015619999999995,1.9507809999999999,0,0,0,0,0]
[]
[null,"Property groups"]
[null,null,null,null,null,"Probability of landing",null,"EV (rent all properties)","1 house","2 houses","3 houses","4 houses","1 Hotel"]
[null,"Brown",null,null,null,{"$f":"SUMIF($D$4:$D$31,$B35,$F$4:$F$31)","v":4.2599200000000004E-2},null,{"$f":"SUMIF($D$4:$D$31,$B35,P$4:P$31)","v":0.2561852},{"$f":"SUMIF($D$4:$D$31,$B35,Q$4:Q$31)","v":0.640463},1.921389,5.7641670000000005,10.247408,14.939219999999999]
[null,"Light blue",null,null,null,{"$f":"SUMIF($D$4:$D$31,$B36,$F$4:$F$31)","v":6.81451E-2},null,{"$f":"SUMIF($D$4:$D$31,$B36,P$4:P$31)","v":0.90891640000000007},2.2722910000000001,6.3609969999999993,19.082991,28.397730000000003,38.619495000000001]
[null,"Pink",null,null,null,7.4881299999999998E-2,null,1.5977467999999999,3.9943669999999996,11.983101,34.948094999999995,48.678077500000001,59.915504999999996]
[null,"Orange",null,null,null,8.7271799999999997E-2,null,2.5632779999999999,6.4081950000000001,18.052697999999999,49.495334999999997,66.949695000000006,84.404055]
[null,"Red",null,null,null,8.6767700000000003E-2,null,3.2503228000000002,8.125807,23.275494999999999,62.320959999999999,77.505307500000001,92.689655000000016]
[null,"Yellow",null,null,null,7.8932799999999997E-2,null,3.5756539999999997,8.9391350000000003,26.817405000000001,64.428874999999991,78.242114999999998,92.055354999999992]
[null,"Green",null,null,null,7.7397199999999999E-2,null,4.1237876,10.557302,31.671906,72.135809999999992,87.615250000000003,101.77934249999998]
[null,"Dark Blue",null,null,null,4.77531E-2,null,4.1249520000000004,9.008655000000001,26.484000000000002,60.350760000000001,72.508830000000003,84.666899999999998]
[null,"Railroads",null,null,null,0.11196239999999999,null,0,2.7990599999999994,5.5981199999999989,11.196239999999998,22.392479999999995,0]
[null,"Utilities",null,null,null,5.3895999999999999E-2,null,3.7727199999999996,0,0,0,0,0]