*********************************************************************** Price point calculator for the Austrian multiband auction Version 1.0 (c) 2006-2014 DotEcon Ltd (www.dotecon.com) ---------------------------------------------------------------- DATA IMPORT Using default lot structure Reading from bids file: data\multibandauction_bids.csv ---------------------------------------------------------------- LOT STRUCTURE Categories: Category A1 contains 1 item - reserve 32000000- eligibility 1 Category A2 contains 4 items - reserve 32000000- eligibility 1 Category A3 contains 1 item - reserve 32000000- eligibility 1 Category B1 contains 1 item - reserve 23400000- eligibility 1 Category B2 contains 5 items - reserve 29900000- eligibility 1 Category B3 contains 1 item - reserve 23400000- eligibility 1 Category C1 contains 2 items - reserve 14600000- eligibility 1 Category C2 contains 8 items - reserve 8800000- eligibility 1 Category C3 contains 5 items - reserve 11400000- eligibility 1 Summary of bids loaded: --------------------------------------- Read from file successful: 3 bidders found. Bid data read (zero bids will be automatically added if not present in the bids file): A1TelekomAustriaAktiengesellschaft (ID = 1) XXXX bids read. T-MobileAustriaGmbH (ID = 2) XXXX bids read. HutchisonDreiAustriaGmbH (ID = 3) XXXX bids read. ---------------------------------------------------------------- PROCESSING OF LOADED DATA ---------------------------------------------------------------- PRINCIPAL STAGE RESULTS Reading principal stage results from file: data\multibandauction_results.csv Winning outcome: Bidder A1 A2 A3 B1 B2 B3 C1 C2 C3 Bid amount Base price A1TelekomAustriaAktiengesellschaft 1 2 1 0 2 1 2 3 2 XXXXXX 1029895738 T-MobileAustriaGmbH 0 2 0 1 2 0 0 4 0 XXXXXX 653998071 HutchisonDreiAustriaGmbH 0 0 0 0 1 0 0 1 3 XXXXXX 329031581 Unallocated lots: /0/0/0/0/0/0/0/0/0/ Value of winning bids: xxxxxxx Unallocated lots value: 0 Total value: xxxxxxxxxxxx Minimum revenue core: 2012925390 ---------------------------------------------------------------- DETERMINATION OF PRICE POINTS ACCORDING TO LINEAR REFERENCE PRICING METHODOLOGY Number of sold categories relevant in ALP determination: 9 ---------------------------------------------------------------- MINIMISATION OF EXCURSIONS Setting up constraints for minimisation -------------------------------------- Setting up epsilon constraints Adding minimum revenue constraint. Prices of all sold lots need to sum to 2012925390.000 Adding reserve price constraints Results of minimisation: ------------------------ LP completed with return code = 0 Intermediate results of maximum deviations: Maximum deviation for A1TelekomAustriaAktiengesellschaft: 3644394.562 Maximum deviation for T-MobileAustriaGmbH: 52527629.667 Maximum deviation for HutchisonDreiAustriaGmbH: 33163208.469 Minimum sum of excursions: 89335232.698 Intermediate linear prices: Intermediate linear price for A1: 84807959.042 Intermediate linear price for A2: 95732664.042 Intermediate linear price for A3: 71944183.042 Intermediate linear price for B1: 68057242.698 Intermediate linear price for B2: 104507353.615 Intermediate linear price for B3: 99060480.792 Intermediate linear price for C1: 57371045.229 Intermediate linear price for C2: 49748847.948 Intermediate linear price for C3: 54171045.229 ---------------------------------------------------------------- ALIGNMENT OF REFERENCE PRICES WITH RESERVE PRICES Lambda set to 3.694. Number of initial inequality constraints: 9 Iterations of quadratic programme (deferred constraint generation): ------------------------------------------------------------------ Iteration number 1 - total number of inequality constraints = 9 Return value QP solver: -3717992866.312 Sum of maximum deviations for intermediate solution: 397926428.130 Iteration number 2 - total number of inequality constraints = 10 Return value QP solver: -3616371724.978 Sum of maximum deviations for intermediate solution: 192658378.375 Iteration number 3 - total number of inequality constraints = 11 Return value QP solver: -3596629485.662 Sum of maximum deviations for intermediate solution: 200505287.647 Iteration number 4 - total number of inequality constraints = 12 Return value QP solver: -3581080865.386 Sum of maximum deviations for intermediate solution: 130667073.566 Iteration number 5 - total number of inequality constraints = 13 Return value QP solver: -3563103363.283 Sum of maximum deviations for intermediate solution: 154034372.735 Iteration number 6 - total number of inequality constraints = 14 Return value QP solver: -3548873450.484 Sum of maximum deviations for intermediate solution: 126887955.474 Iteration number 7 - total number of inequality constraints = 15 Return value QP solver: -3544749170.938 Sum of maximum deviations for intermediate solution: 110497466.144 Iteration number 8 - total number of inequality constraints = 16 Return value QP solver: -3540663991.765 Sum of maximum deviations for intermediate solution: 118930269.522 Iteration number 9 - total number of inequality constraints = 17 Return value QP solver: -3530389270.279 Sum of maximum deviations for intermediate solution: 124050116.247 Iteration number 10 - total number of inequality constraints = 18 Return value QP solver: -3524235705.177 Sum of maximum deviations for intermediate solution: 112994313.540 Iteration number 11 - total number of inequality constraints = 19 Return value QP solver: -3503088900.913 Sum of maximum deviations for intermediate solution: 101794326.091 Iteration number 12 - total number of inequality constraints = 20 Return value QP solver: -3495249698.988 Sum of maximum deviations for intermediate solution: 108774364.392 Iteration number 13 - total number of inequality constraints = 21 Return value QP solver: -3493806685.685 Sum of maximum deviations for intermediate solution: 100841338.628 Iteration number 14 - total number of inequality constraints = 22 Return value QP solver: -3487806934.831 Sum of maximum deviations for intermediate solution: 103372706.552 Iteration number 15 - total number of inequality constraints = 23 Return value QP solver: -3469944622.496 Sum of maximum deviations for intermediate solution: 107772676.489 Iteration number 16 - total number of inequality constraints = 24 Return value QP solver: -3464913263.726 Sum of maximum deviations for intermediate solution: 96565285.196 Iteration number 17 - total number of inequality constraints = 25 Return value QP solver: -3462045524.008 Sum of maximum deviations for intermediate solution: 94173598.364 Iteration number 18 - total number of inequality constraints = 26 Return value QP solver: -3461351703.162 Sum of maximum deviations for intermediate solution: 91800442.459 Iteration number 19 - total number of inequality constraints = 27 Return value QP solver: -3458342043.631 Sum of maximum deviations for intermediate solution: 92379218.898 Iteration number 20 - total number of inequality constraints = 28 Return value QP solver: -3457468441.916 Sum of maximum deviations for intermediate solution: 89770527.166 Iteration number 21 - total number of inequality constraints = 29 Return value QP solver: -3455395484.576 Sum of maximum deviations for intermediate solution: 89885444.265 Iteration number 22 - total number of inequality constraints = 30 Return value QP solver: -3455160700.881 Sum of maximum deviations for intermediate solution: 89872708.872 Iteration number 23 - total number of inequality constraints = 31 Return value QP solver: -3454899585.912 Sum of maximum deviations for intermediate solution: 89802448.760 Iteration number 24 - total number of inequality constraints = 32 Return value QP solver: inf [WARN] QP solver returned with inf. Sum of maximum deviations for intermediate solution: 89335232.698 At the minimum sum: 89335232.698. Finished Iterations for QP. Solution (rounded down to nearest whole amounts): -------------------------------------------------- ALP for A1: 84807959.042 (84807959) ALP for A2: 95732664.042 (95732664) ALP for A3: 71944183.042 (71944183) ALP for B1: 68057242.698 (68057242) ALP for B2: 104507353.615 (104507353) ALP for B3: 99060480.792 (99060480) ALP for C1: 57371045.229 (57371045) ALP for C2: 49748847.948 (49748847) ALP for C3: 54171045.229 (54171045) Lambda: 3.694 Excursions: ----------- A1TelekomAustriaAktiengesellschaft: 3644394.562 T-MobileAustriaGmbH: 52527629.667 HutchisonDreiAustriaGmbH: 33163208.469 ---------------------------------------------------------------- EXPORTING RESULTS Printing results to data\basic.csv ---------------------------------------------------------------- DONE - EXITING.