{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Arkusz1","Arkusz9"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Arkusz1","index":0,"n_rows":47,"n_cols":23,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Alternatives","Concerts","Royalities","Singings","Songs","Ranks",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P1:R1)","v":0},{"$f":"SUM(Q1:S1)","v":0},{"$f":"SUM(R1:T1)","v":0},{"$f":"SUM(S1:U1)","v":0},{"$f":"SUM(T1:V1)","v":0}]
["A220",8,10,1,1,100]
["A221",8,10,2,1,97]
["A223",8,20,1,1,94]
["A222",8,10,3,1,93]
["A160",7,10,1,1,91]
["A217",8,30,1,1,90]
["A232",8,10,1,2,90]
["A208",8,10,1,3,85]
["A226",8,40,1,1,82]
["A100",6,10,1,1,80]
["A196",8,10,1,4,75]
["A184",8,10,1,5,65]
["A040",5,10,1,1,60]
["alfa",4,4,3,5]
["monoton.","max","min","min","min"]
[]
[]
["UTASTAR results:"]
["[g1_, g1^] = [5, 6, 7, 8]"]
["[g2_, g2^] = [40, 30, 20, 10]"]
["[g3_, g3^] = [3, 2, 1]"]
["[g4_, g4^] = [5, 4, 3, 2, 1]"]
[]
["UTASTAR LP initial model results:"]
["min(z)","w(1,1)","w(1,2)","w(1,3)","w(2,1)","w(2,2)","w(2,3)","w(3,1)","w(3,2)","w(4,1)","w(4,2)","w(4,3)","w(4,4)"]
[0.5,3.999999999999998E-2,0.24,0.06,0.12,0.12,0,0,0,0.06,0.18,0.06,0.12]
[]
["Option ratings:"]
["g_i(j)","g1(5)","g1(6)","g1(7)","g1(8)","g2(40)","g2(30)","g2(20)","g2(10)","g3(3)","g3(2)","g3(1)","g4(5)","g4(4)","g4(3)","g4(2)","g4(1)"]
["u(g_i(j))",0,3.999999999999998E-2,0.27999999999999997,0.33999999999999997,0,0.12,0.24,0.24,0,0,0,0,0.06,0.24,0.3,0.42]
[]
["Alternatives ratings:"]
[null,"Concerts","Royalities","Singings","Songs","u(g(a))"]
["A220",0.33999999999999997,0.24,0,0.42,{"$f":"SUM(B35:E35)","v":1}]
["A221",0.33999999999999997,0.24,0,0.42,1]
["A223",0.33999999999999997,0.24,0,0.42,1]
["A222",0.33999999999999997,0.24,0,0.42,1]
["A160",0.27999999999999997,0.24,0,0.42,0.94]
["A217",0.33999999999999997,0.12,0,0.42,0.87999999999999989]
["A232",0.33999999999999997,0.24,0,0.3,0.87999999999999989]
["A208",0.33999999999999997,0.24,0,0.24,0.82]
["A226",0.33999999999999997,0,0,0.42,0.76]
["A100",3.999999999999998E-2,0.24,0,0.42,0.7]
["A196",0.33999999999999997,0.24,0,0.06,0.6399999999999999]
["A184",0.33999999999999997,0.24,0,0,0.57999999999999996]
["A040",0,0.24,0,0.42,0.65999999999999992]

{"sheet":"Arkusz9","index":1,"n_rows":94,"n_cols":18,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
["offer","concerts","songs","royalties","contract","Ranks","Ranks2"]
[12,8,1,2,125000,96,{"$f":"VLOOKUP(A2,$A$82:$F$94,6,FALSE)","v":0.98}]
[13,8,1,4,125000,88,0.84149999999999991]
[11,7,1,4,125000,68,0.64650000000000007]
[8,7,3,1,150000,62,0.62650000000000006]
[9,7,3,1,200000,57,0.57050000000000001]
[10,7,3,2,200000,53,0.55049999999999999]
[3,5,2,3,125000,36,0.53049999999999997]
[6,6,4,1,150000,34,0.50550000000000006]
[4,5,2,3,150000,33,0.45450000000000002]
[7,6,3,2,200000,33,0.45450000000000002]
[5,6,4,3,150000,30,0.34700000000000003]
[2,5,4,3,150000,20,0.32700000000000001]
[1,5,5,3,125000,16,0.13200000000000009]
["alfa",4,5,4,4]
["monoton","max","min","min","min"]
[]
[]
["UTASTAR results:"]
["[g1_, g1^] = [5, 6, 7, 8]"]
["[g2_, g2^] = [5, 4, 3, 2, 1]"]
["[g3_, g3^] = [4, 3, 2, 1]"]
["[g4_, g4^] = [200000, 175000, 150000, 125000]"]
[]
["u(12) = 1u1(8) + 1u2(1) + 1u3(2) + 1u4(125000)"]
["u(13) = 1u1(8) + 1u2(1) + 1u3(4) + 1u4(125000)"]
["u(11) = 1u1(7) + 1u2(1) + 1u3(4) + 1u4(125000)"]
["u(8) = 1u1(7) + 1u2(3) + 1u3(1) + 1u4(150000)"]
["u(9) = 1u1(7) + 1u2(3) + 1u3(1) + 1u4(200000)"]
["u(10) = 1u1(7) + 1u2(3) + 1u3(2) + 1u4(200000)"]
["u(3) = 1u1(5) + 1u2(2) + 1u3(3) + 1u4(125000)"]
["u(6) = 1u1(6) + 1u2(4) + 1u3(1) + 1u4(150000)"]
["u(4) = 1u1(5) + 1u2(2) + 1u3(3) + 1u4(150000)"]
["u(7) = 1u1(6) + 1u2(3) + 1u3(2) + 1u4(200000)"]
["u(5) = 1u1(6) + 1u2(4) + 1u3(3) + 1u4(150000)"]
["u(2) = 1u1(5) + 1u2(4) + 1u3(3) + 1u4(150000)"]
["u(1) = 1u1(5) + 1u2(5) + 1u3(3) + 1u4(125000)"]
[]
["u(12) = 1w(1,1) + 1w(1,2) + 1w(1,3) + 1w(2,1) + 1w(2,2) + 1w(2,3) + 1w(2,4) + 1w(3,1) + 1w(3,2) + 1w(4,1) + 1w(4,2) + 1w(4,3)"]
["u(13) = 1w(1,1) + 1w(1,2) + 1w(1,3) + 1w(2,1) + 1w(2,2) + 1w(2,3) + 1w(2,4) + 1w(4,1) + 1w(4,2) + 1w(4,3)"]
["u(11) = 1w(1,1) + 1w(1,2) + 1w(2,1) + 1w(2,2) + 1w(2,3) + 1w(2,4) + 1w(4,1) + 1w(4,2) + 1w(4,3)"]
["u(8) = 1w(1,1) + 1w(1,2) + 1w(2,1) + 1w(2,2) + 1w(3,1) + 1w(3,2) + 1w(3,3) + 1w(4,1) + 1w(4,2)"]
["u(9) = 1w(1,1) + 1w(1,2) + 1w(2,1) + 1w(2,2) + 1w(3,1) + 1w(3,2) + 1w(3,3)"]
["u(10) = 1w(1,1) + 1w(1,2) + 1w(2,1) + 1w(2,2) + 1w(3,1) + 1w(3,2)"]
["u(3) = 1w(2,1) + 1w(2,2) + 1w(2,3) + 1w(3,1) + 1w(4,1) + 1w(4,2) + 1w(4,3)"]
["u(6) = 1w(1,1) + 1w(2,1) + 1w(3,1) + 1w(3,2) + 1w(3,3) + 1w(4,1) + 1w(4,2)"]
["u(4) = 1w(2,1) + 1w(2,2) + 1w(2,3) + 1w(3,1) + 1w(4,1) + 1w(4,2)"]
["u(7) = 1w(1,1) + 1w(2,1) + 1w(2,2) + 1w(3,1) + 1w(3,2)"]
["u(5) = 1w(1,1) + 1w(2,1) + 1w(3,1) + 1w(4,1) + 1w(4,2)"]
["u(2) = 1w(2,1) + 1w(3,1) + 1w(4,1) + 1w(4,2)"]
["u(1) = 1w(3,1) + 1w(4,1) + 1w(4,2) + 1w(4,3)"]
[]
["delta(12, 13) = 1w(3,1) + 1w(3,2)"]
["delta(13, 11) = 1w(1,3)"]
["delta(11, 8) = 1w(2,3) + 1w(2,4) + -1w(3,1) + -1w(3,2) + -1w(3,3) + 1w(4,3)"]
["delta(8, 9) = 1w(4,1) + 1w(4,2)"]
["delta(9, 10) = 1w(3,3)"]
["delta(10, 3) = 1w(1,1) + 1w(1,2) + -1w(2,3) + 1w(3,2) + -1w(4,1) + -1w(4,2) + -1w(4,3)"]
["delta(3, 6) = -1w(1,1) + 1w(2,2) + 1w(2,3) + -1w(3,2) + -1w(3,3) + 1w(4,3)"]
["delta(6, 4) = 1w(1,1) + -1w(2,2) + -1w(2,3) + 1w(3,2) + 1w(3,3)"]
["delta(4, 7) = -1w(1,1) + 1w(2,3) + -1w(3,2) + 1w(4,1) + 1w(4,2)"]
["delta(7, 5) = 1w(2,2) + 1w(3,2) + -1w(4,1) + -1w(4,2)"]
["delta(5, 2) = 1w(1,1)"]
["delta(2, 1) = 1w(2,1) + -1w(4,3)"]
[]
["UTASTAR LP initial model results:"]
["min(z)","w(1,1)","w(1,2)","w(1,3)","w(2,1)","w(2,2)","w(2,3)","w(2,4)","w(3,1)","w(3,2)","w(3,3)","w(4,1)","w(4,2)","w(4,3)"]
[0,2.0000000000000046E-2,0.28666666666666657,0.02,0.28666666666666657,4.0000000000000008E-2,0,0,0,0.02,0.02,4.0000000000000036E-2,0,0.26666666666666661]
[]
["Objective function z=0 for UTASTAR LP initial model --> post-optimality algorithm executed. Results:"]
[null,"w(1,1)","w(1,2)","w(1,3)","w(2,1)","w(2,2)","w(2,3)","w(2,4)","w(3,1)","w(3,2)","w(3,3)","w(4,1)","w(4,2)","w(4,3)"]
["max[g1^]",0.02,6.0000000000000026E-2,0.71999999999999964,6.0000000000000026E-2,2.0000000000000018E-2,1.9999999999999962E-2,0,5.5511151231257827E-17,2.0000000000000018E-2,0.02,2.0000000000000073E-2,0,4.0000000000000036E-2]
["max[g2^]",0.02,0.06,0.02,0.75999999999999979,2.0000000000000018E-2,1.999999999999999E-2,0,0,2.0000000000000018E-2,0.02,2.0000000000000046E-2,0,0.04]
["max[g3^]",0.02,0.06,0.02,0.06,2.0000000000000018E-2,0.36999999999999988,0,2.7755575615628914E-17,0.36999999999999988,0.02,2.0000000000000046E-2,0,0.04]
["max[g4^]",0.02,0.20399999999999996,0.02,0.20399999999999996,3.999999999999998E-2,0,0,0,0.14399999999999999,0.02,0.16400000000000001,0,0.18399999999999997]
["avg.",{"$f":"AVERAGE(B72:B75)","v":0.02},9.6000000000000002E-2,0.19499999999999992,0.27099999999999996,2.5000000000000008E-2,0.10249999999999995,0,2.0816681711721685E-17,0.13849999999999998,0.02,5.6000000000000043E-2,0,7.6000000000000012E-2]
[]
["g_i(j)","g1(5)","g1(6)","g1(7)","g1(8)","g2(5)","g2(4)","g2(3)","g2(2)","g2(1)","g3(4)","g3(3)","g3(2)","g3(1)","g4(200000)","g4(175000)","g4(150000)","g4(125000)"]
["u(g_i(j))",0,0.02,0.11600000000000001,0.31099999999999994,0,0.27099999999999996,0.29599999999999999,0.39849999999999997,0.39849999999999997,0,2.0816681711721685E-17,0.13850000000000001,0.1585,0,5.6000000000000043E-2,5.6000000000000043E-2,0.13200000000000006]
[]
[null,"concerts","songs","royalties","contract","u(g(a))"]
[12,0.31099999999999994,0.39849999999999997,0.13850000000000001,0.13200000000000006,{"$f":"SUM(B82:E82)","v":0.98}]
[13,0.31099999999999994,0.39849999999999997,0,0.13200000000000006,0.84149999999999991]
[11,0.11600000000000001,0.39849999999999997,0,0.13200000000000006,0.64650000000000007]
[8,0.11600000000000001,0.29599999999999999,0.1585,5.6000000000000043E-2,0.62650000000000006]
[9,0.11600000000000001,0.29599999999999999,0.1585,0,0.57050000000000001]
[10,0.11600000000000001,0.29599999999999999,0.13850000000000001,0,0.55049999999999999]
[3,0,0.39849999999999997,2.0816681711721685E-17,0.13200000000000006,0.53049999999999997]
[6,0.02,0.27099999999999996,0.1585,5.6000000000000043E-2,0.50550000000000006]
[4,0,0.39849999999999997,2.0816681711721685E-17,5.6000000000000043E-2,0.45450000000000002]
[7,0.02,0.29599999999999999,0.13850000000000001,0,0.45450000000000002]
[5,0.02,0.27099999999999996,2.0816681711721685E-17,5.6000000000000043E-2,0.34700000000000003]
[2,0,0.27099999999999996,2.0816681711721685E-17,5.6000000000000043E-2,0.32700000000000001]
[1,0,0,2.0816681711721685E-17,0.13200000000000006,0.13200000000000009]