{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Assignment"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Assignment","index":0,"n_rows":39,"n_cols":28,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,2,1,6],[14,2,14,3],[15,2,15,3],[17,1,17,2]]}
[null,null,"TEAM AUCTION DATA:  Assignment"]
[]
[null,"          Records have been kept on 20 oil leases for tracts that are very similar to those on  "]
[null,"which your team will be bidding.  This historical lease data is exactly the same as that used in"]
[null,"the Class Project.  The eventual proven values of the leases and the values of the prior "]
[null,"geological estimates (signals) of their values are shown for the companies in your team's "]
[null,"project.  These proven values and signals represent the amounts needed to make fair and "]
[null,"reasonable profits on the oil that is extracted.  These would sustain the companies, neither  "]
[null,"weakening nor strengthening their circumstances.  All monetary amounts are given in   "]
[null,"millions of dollars."]
[null,"          Your team is representing Company 1."]
[]
[null,null,null,"Section: ",20]
[null,null,null,"Team: ",6]
[null,null,"Number of companies: ",null,24]
[null,null,"Company 1 Signal: ",null,277.2]
[]
[null,"Leases",null," Historical Signals"]
[null,"Number","Proven Value","Company 1 Signals","Company 2 Signals","Company 3 Signals","Company 4 Signals","Company 5 Signals","Company 6 Signals","Company 7 Signals","Company 8 Signals","Company 9 Signals","Company 10 Signals","Company 11 Signals","Company 12 Signals","Company 13 Signals","Company 14 Signals","Company 15 Signals","Company 16 Signals","Company 17 Signals","Company 18 Signals","Company 19 Signals","Company 20 Signals","Company 21 Signals","Company 22 Signals","Company 23 Signals","Company 24 Signals","Company 25 Signals"]
[null,1,237.2,226.89999999999998,247.6,249.39999999999998,241.5,228.79999999999998,217.5,246.6,252.2,239.6,258.09999999999997,242.5,240,239.39999999999998,229.29999999999998,222.79999999999998,237.6,253.1,241.2,222.79999999999998,245.29999999999998,214.7,245.5,252.2,234.7,""]
[null,2,196.8,202.5,198.10000000000002,218,192.10000000000002,186.3,202,193.60000000000002,192.4,194.5,196.60000000000002,204.9,187.60000000000002,190.60000000000002,199.5,207.70000000000002,212.9,181.20000000000002,189.8,194.3,202.3,209.5,208.20000000000002,199,189.10000000000002,""]
[null,3,154.9,157,178,138.6,169.1,161.9,155.30000000000001,146.4,147.30000000000001,176.20000000000002,147,153.9,160.5,147.1,144.20000000000002,160.30000000000001,158.6,160,170.20000000000002,147.70000000000002,151.4,175.8,154.30000000000001,156.6,181.4,""]
[null,4,262.60000000000002,264.10000000000002,266.5,272.20000000000005,238.8,264.5,265.70000000000005,262.8,268.60000000000002,259.5,270.90000000000003,269.40000000000003,263.20000000000005,253.8,237.8,257.10000000000002,265,245.90000000000003,280,266.40000000000003,258.8,270.40000000000003,261,255.20000000000002,249.20000000000002,""]
[null,5,229.4,240.70000000000002,236.70000000000002,238,219.20000000000002,228.6,223,225.8,229.5,228.20000000000002,230.4,225.6,222.3,237.4,215.9,225,215.70000000000002,229.3,243,236.8,229.3,236.1,232,242.3,228.3,""]
[null,6,192.4,200.5,190.1,207.6,193.3,210.4,208.5,194.4,202.6,209.20000000000002,194.20000000000002,179,197,192.6,183.9,193.1,205.5,194.5,196.8,200.1,208.6,167.3,185.20000000000002,203.3,205.6,""]
[null,7,209.1,225.5,223.29999999999998,180.2,203.6,210.9,205.6,191.2,192.9,203.1,222.9,221.9,211.29999999999998,192,200.6,221.5,214.9,213.5,202.5,203,223.7,212,186,218.5,203.2,""]
[null,8,236.7,242.79999999999998,240.5,233.2,238.1,230.1,233.29999999999998,252.6,229.2,219.79999999999998,241.6,240,234.1,242.1,243.6,234.89999999999998,230.6,248.39999999999998,231.39999999999998,230.2,233.89999999999998,224.29999999999998,232.5,251.79999999999998,239.29999999999998,""]
[null,9,245,252,242.2,239.5,250.3,248.3,243.8,242.9,246.4,241,237,232.5,240.4,242.3,258.7,257.39999999999998,230.3,239.2,248.8,245.1,247.8,247.4,233.5,257.5,256,""]
[null,10,259.2,254.5,242,269.89999999999998,251.6,270,260.2,235.79999999999998,272.09999999999997,256.39999999999998,254.89999999999998,244.79999999999998,245.7,260,265.5,252,270.59999999999997,261.59999999999997,253.89999999999998,250.6,278.09999999999997,249.2,263.39999999999998,251.7,245.29999999999998,""]
[null,11,189.9,187.9,162.70000000000002,191.3,196.8,189,199.6,186.5,176.4,211.9,189.70000000000002,191.20000000000002,191.3,183.6,199,175,189.5,180.9,196,189.70000000000002,172.8,201,193.1,194.70000000000002,184.1,""]
[null,12,173.9,175.70000000000002,162.9,173.6,162.6,176.9,173.8,177.4,156.4,173.1,161.1,166.3,191.1,181.4,156.20000000000002,169.8,172.70000000000002,190.9,180.70000000000002,185,171.9,180.1,191.70000000000002,176.1,172.8,""]
[null,13,226.5,221,225.7,213,219.3,221.9,227.9,247.1,238.7,218.1,215,218.4,237.9,224.5,213.5,213.1,217.6,210.5,216.5,213.9,229.2,227.1,219.8,223.4,241.2,""]
[null,14,269.60000000000002,272.40000000000003,265,282.5,291.20000000000005,282,258,268.10000000000002,284.60000000000002,275.5,269.90000000000003,260.20000000000005,286.40000000000003,261.8,281,261.90000000000003,262.90000000000003,257.40000000000003,282.8,300.40000000000003,258.90000000000003,277.60000000000002,257.20000000000005,249.50000000000003,264.5,""]
[null,15,234.7,233.7,228.89999999999998,210.79999999999998,247.7,222,229.39999999999998,234.1,232.6,211.79999999999998,226.89999999999998,227.5,228.2,237.89999999999998,236.1,260.39999999999998,234.7,240.6,237.79999999999998,228.79999999999998,236.29999999999998,243.6,226.79999999999998,242.2,221.89999999999998,""]
[null,16,209.4,197,212.8,208.20000000000002,220.3,204.1,211.8,219.3,221,208.70000000000002,231.70000000000002,217.9,219.8,231.3,190.9,207.8,221.8,214.8,193,214.8,202.4,191.5,210.3,196.9,209.4,""]
[null,17,290.5,290.89999999999998,289.89999999999998,282.10000000000002,301,288.39999999999998,300.2,274,299.89999999999998,275.8,288.5,278.89999999999998,285.3,285.60000000000002,308.89999999999998,301.60000000000002,271.8,278.89999999999998,294.5,283.3,281.8,277.3,294.7,291.10000000000002,294.8,""]
[null,18,299.5,275.39999999999998,310.8,301.10000000000002,278.3,297.10000000000002,306.39999999999998,309.2,294.10000000000002,291.8,292.3,289.3,303.2,278.2,305.39999999999998,309,287,307.2,312.7,298.5,293.10000000000002,304.89999999999998,293.7,296.10000000000002,296,""]
[null,19,206.2,206.79999999999998,219.6,210.29999999999998,193.79999999999998,196.89999999999998,219.5,216.29999999999998,222.6,199.29999999999998,206.89999999999998,219,204.39999999999998,209,211.7,185.7,186.2,226.2,204.2,181,217.5,205.1,190.1,202.6,210.5,""]
[null,20,272.8,272.10000000000002,271.2,281.90000000000003,282.90000000000003,267.3,263.60000000000002,274.40000000000003,278.2,280.7,285.40000000000003,276.7,292.60000000000002,276.8,268.3,270.90000000000003,270.2,274.5,268.10000000000002,267.5,293.90000000000003,248.5,292.10000000000002,268.60000000000002,266.10000000000002,""]