Spreadsheet: 201704d1356084453-using-index-and-match-for-two-criteria-one-in-a-column-the-other-in-a-row-sample-workbook
Sheet: Agresso

 | <version1>
 | [NAME]
 | <period> |  | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period> | <period>
 | 201302 |  | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302 | 201302
 |  |  | <period1> | <period2> | <period3> | <period4> | <period5> | <period6> | <period7> | <period8> | <period9> | <period10> | <period11> | <period12> | <period1> | <period2> | <period3> | <period4> | <period5> | <period6> | <period7> | <period8> | <period9> | <period10> | <period11> | <period12> | <period1> | <period2> | <period3> | <period4> | <period5> | <period6> | <period7> | <period8> | <period9> | <period10> | <period11> | <period12> | <pryrperiod> | <period>
 |  |  | 201301 | 201302 | 201303 | 201304 | 201305 | 201306 | 201307 | 201308 | 201309 | 201310 | 201311 | 201312 | 201301 | 201302 | 201303 | 201304 | 201305 | 201306 | 201307 | 201308 | 201309 | 201310 | 201311 | 201312 | 201301 | 201302 | 201303 | 201304 | 201305 | 201306 | 201307 | 201308 | 201309 | 201310 | 201311 | 201312 | 201202 | 201302
 | <pd_end_date> |  | <pryr2period1> | <pryr2period2> | <pryr2period3> | <pryr2period4> | <pryr2period5> | <pryr2period6> | <pryr2period7> | <pryr2period8> | <pryr2period9> | <pryr2period10> | <pryr2period11> | <pryr2period12> | <pryrperiod1> | <pryrperiod2> | <pryrperiod3> | <pryrperiod4> | <pryrperiod5> | <pryrperiod6> | <pryrperiod7> | <pryrperiod8> | <pryrperiod9> | <pryrperiod10> | <pryrperiod11> | <pryrperiod12> | <period1> | <period2> | <period3> | <period4> | <period5> | <period6> | <period7> | <period8> | <period9> | <period10> | <period11> | <period12>
 | 2012-11-25 00:00:00 |  | 201101 | 201102 | 201103 | 201104 | 201105 | 201106 | 201107 | 201108 | 201109 | 201110 | 201111 | 201112 | 201201 | 201202 | 201203 | 201204 | 201205 | 201206 | 201207 | 201208 | 201209 | 201210 | 201211 | 201212 | 201301 | 201302 | 201303 | 201304 | 201305 | 201306 | 201307 | 201308 | 201309 | 201310 | 201311 | 201312
 | DAILY MAIL - OGSM DATA 2012/2013
 | 2013 Period 2 (Nov 2012)
 | Month Ending 25/11/2012
 |  |  | ACTUAL - 2 YEARS PRIOR - FINANCIAL YEAR 2011 |  |  |  |  |  |  |  |  |  |  |  | ACTUAL - PRIOR FINANCIAL YEAR 2012 |  |  |  |  |  |  |  |  |  |  |  | ACTUAL - FINANCIAL YEAR 2013 |  |  |  |  |  |  |  |  |  |  |  | 12 MNTH | 12 MNTH
 |  |  | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | PR YR | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | TO | TO
 |  |  | Oct 10 | Nov 10 | Dec 10 | Jan 11 | Feb 11 | [NAME] 11 | Apr 11 | May 11 | Jun 11 | Jul 11 | Aug 11 | Sep 11 | Oct 11 | Nov 11 | Dec 11 | Jan 12 | Feb 12 | [NAME] 12 | Apr 12 | May 12 | Jun 12 | Jul 12 | Aug 12 | Sep 12 | Oct 12 | Nov 12 | Dec 12 | Jan 13 | Feb 13 | [NAME] 13 | Apr 13 | May 13 | Jun 13 | Jul 13 | Aug 13 | Sep 13 | NOVEMBER 2011 | NOVEMBER 2012
 |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1 | value_1
 |  |  | <pryr2period1> | <pryr2period2> | <pryr2period3> | <pryr2period4> | <pryr2period5> | <pryr2period6> | <pryr2period7> | <pryr2period8> | <pryr2period9> | <pryr2period10> | <pryr2period11> | <pryr2period12> | <pryrperiod1> | <pryrperiod2> | <pryrperiod3> | <pryrperiod4> | <pryrperiod5> | <pryrperiod6> | <pryrperiod7> | <pryrperiod8> | <pryrperiod9> | <pryrperiod10> | <pryrperiod11> | <pryrperiod12> | <period1> | <period2> | <period3> | <period4> | <period5> | <period6> | <period7> | <period8> | <period9> | <period10> | <period11> | <period12>
 | NON-FINANCIALS
 | DM Headline Circulation - Mon-Fri Agresso |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | DM Headline Circulation - Sat Agresso |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | DM Headline Circulation - Mon-Sat Agresso |  | 900000 | 1000000 | 1100000 | 1200000 | 1300000 | 1400000 | 1500000 | 1600000 | 1700000 | 1800000 | 1900000 | 2000000 | 2100000 | 2200000 | 2300000 | 2400000 | 2500000 | 2600000 | 2700000 | 2800000 | 2900000 | 3000000 | 3100000 | 3200000 | 3300000 | 3400000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19800000 | 34200000
 | DM Headline Circulation - Mon-Fri |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | DM Headline Circulation - Sat |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | DM Headline Circulation - Mon-Sat |  | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400 | 2500 | 2600 | 2700 | 2800 | 2900 | 3000 | 3100 | 3200 | 3300 | 3400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19800 | 34200
 | Number of Issues - Mon-Fri |  | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 25 | 20 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 260 | 260
 | Number of Issues - Sat |  | 4 | 4 | 4 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 5 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51 | 52
 | Number of Issues - Mon-Sat |  | 24 | 24 | 29 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 311 | 312
 | Circulation Net Sale - UK Mon-Fri |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 25000000 | 25500000 | 26000000 | 26500000 | 27000000 | 27500000 | 28000000 | 28500000 | 29000000 | 29500000 | 30000000 | 30500000 | 31000000 | 31500000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 50500000 | 345000000
 | Circulation Net Sale - UK Sat |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9000000 | 9500000 | 10000000 | 10500000 | 11000000 | 11500000 | 12000000 | 12500000 | 13000000 | 13500000 | 14000000 | 14500000 | 15000000 | 15500000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18500000 | 153000000
 | Circulation Net Sale - UK Mon-Sat |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 34000000 | 35000000 | 36000000 | 37000000 | 38000000 | 39000000 | 40000000 | 41000000 | 42000000 | 43000000 | 44000000 | 45000000 | 46000000 | 47000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69000000 | 498000000
 | DM Headline Circulation Budget - Mon-Fri |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1250 | 1275 | 1040 | 1325 | 1350 | 1100 | 1400 | 1425 | 1160 | 1475 | 1500 | 1220 | 1550 | 1575 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 194.2307692307692 | 1326.923076923077
 | DM Headline Circulation Budget - Sat |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2250 | 2375 | 2000 | 2625 | 2750 | 2300 | 3000 | 3125 | 2600 | 3375 | 3500 | 2900 | 3750 | 3875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 362.7450980392157 | 2942.307692307692
 | DM Headline Circulation Budget - Mon-Sat |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1416.666666666667 | 1458.333333333333 | 1200 | 1541.666666666667 | 1583.333333333333 | 1300 | 1666.666666666667 | 1708.333333333333 | 1400 | 1791.666666666667 | 1833.333333333333 | 1500 | 1916.666666666667 | 1958.333333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 221.8649517684887 | 1596.153846153846
 | DM FTE |  | 500 | 501.5 | 503 | 504.5 | 506 | 507.5 | 509 | 510.5 | 512 | 513.5 | 515 | 516.5 | 518 | 519.5 | 521 | 522.5 | 524 | 525.5 | 527 | 528.5 | 530 | 531.5 | 533 | 534.5 | 536 | 537.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2200 | 3400
 | DM Ad Volume Pages Sold - Display |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 302.5 | 305 | 307.5 | 310 | 312.5 | 315 | 317.5 | 320 | 322.5 | 325 | 327.5 | 330 | 332.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 602.5 | 3825
 | DM Ad Volume Pages Sold - Classified |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 102.5 | 105 | 107.5 | 110 | 112.5 | 115 | 117.5 | 120 | 122.5 | 125 | 127.5 | 130 | 132.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 202.5 | 1425
 | Total Pagination - Uk Newspaper & Magazine |  | 1500 | 1510 | 1520 | 1530 | 1540 | 1550 | 1560 | 1570 | 1580 | 1590 | 1600 | 1610 | 1620 | 1630 | 1640 | 1650 | 1660 | 1670 | 1680 | 1690 | 1700 | 1710 | 1720 | 1730 | 1740 | 1750 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18900 | 20340
 | Number Of Issues - Uk Newspaper & Magazine |  | 24 | 24 | 29 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 30 | 24 | 24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 311 | 312
 | DM Average Daily Pagination - Month |  | 62.5 | 62.91666666666666 | 52.41379310344828 | 63.75 | 64.16666666666667 | 51.66666666666666 | 65 | 65.41666666666667 | 52.66666666666666 | 66.25 | 66.66666666666667 | 53.66666666666666 | 67.5 | 67.91666666666667 | 54.66666666666666 | 68.75 | 69.16666666666667 | 55.66666666666666 | 70 | 70.41666666666667 | 56.66666666666666 | 71.25 | 71.66666666666667 | 57.66666666666666 | 72.5 | 72.91666666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 60.77170418006431 | 65.1923076923077
 | DM Average Daily Pagination - YTD |  | 62.5 | 62.70833333333334 | 58.83116883116883 | 60 | 60.8 | 59.03225806451613 | 59.83240223463687 | 60.49261083743843 | 59.48497854077253 | 60.11673151750973 | 60.67615658362989 | 60 | 67.5 | 67.70833333333333 | 62.69230769230769 | 64.11764705882354 | 65.07936507936508 | 63.26923076923077 | 64.16666666666667 | 64.90196078431373 | 63.84615384615385 | 64.53488372093024 | 65.1418439716312 | 64.42307692307692 | 72.5 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 72.70833333333333 | 2375 | 3875
 | FINANCIALS
 | DM Advertising Revenue Agresso |  | 10000000 | 10100000 | 10200000 | 10300000 | 10400000 | 10500000 | 10600000 | 10700000 | 10800000 | 10900000 | 11000000 | 11100000 | 11200000 | 11300000 | 11400000 | 11500000 | 11600000 | 11700000 | 11800000 | 11900000 | 12000000 | 12100000 | 12200000 | 12300000 | 12400000 | 12500000 | 12600000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 129000000 | 143400000
 | DM Advertising Revenue |  | 10000 | 10100 | 10200 | 10300 | 10400 | 10500 | 10600 | 10700 | 10800 | 10900 | 11000 | 11100 | 11200 | 11300 | 11400 | 11500 | 11600 | 11700 | 11800 | 11900 | 12000 | 12100 | 12200 | 12300 | 12400 | 12500 | 12600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 129000 | 143400
 | DM Circulation Revenue Agresso |  | 11000000 | 11100000 | 11200000 | 11300000 | 11400000 | 11500000 | 11600000 | 11700000 | 11800000 | 11900000 | 12000000 | 12100000 | 12200000 | 12300000 | 12400000 | 12500000 | 12600000 | 12700000 | 12800000 | 12900000 | 13000000 | 13100000 | 13200000 | 13300000 | 13400000 | 13500000 | 13600000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 141000000 | 155400000
 | DM Circulation Revenue |  | 11000 | 11100 | 11200 | 11300 | 11400 | 11500 | 11600 | 11700 | 11800 | 11900 | 12000 | 12100 | 12200 | 12300 | 12400 | 12500 | 12600 | 12700 | 12800 | 12900 | 13000 | 13100 | 13200 | 13300 | 13400 | 13500 | 13600 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 141000 | 155400
 | Display Adv. Net Revenue - Newspaper |  | 9000000 | 9150000 | 9300000 | 9450000 | 9600000 | 9750000 | 9900000 | 10050000 | 10200000 | 10350000 | 10500000 | 10650000 | 10800000 | 10950000 | 11100000 | 11250000 | 11400000 | 11550000 | 11700000 | 11850000 | 12000000 | 12150000 | 12300000 | 12450000 | 12600000 | 12750000 | 12900000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 121500000 | 143100000
 | Display Adv. Net Revenue - Magazine |  | 500000 | 575000 | 650000 | 725000 | 800000 | 875000 | 950000 | 1025000 | 1100000 | 1175000 | 1250000 | 1325000 | 1400000 | 1475000 | 1550000 | 1625000 | 1700000 | 1775000 | 1850000 | 1925000 | 2000000 | 2075000 | 2150000 | 2225000 | 2300000 | 2375000 | 2450000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12750000 | 23550000
 | Combined Newspaper & Magazine Display Net Adv. Revenue |  | 9500000 | 9725000 | 9950000 | 10175000 | 10400000 | 10625000 | 10850000 | 11075000 | 11300000 | 11525000 | 11750000 | 11975000 | 12200000 | 12425000 | 12650000 | 12875000 | 13100000 | 13325000 | 13550000 | 13775000 | 14000000 | 14225000 | 14450000 | 14675000 | 14900000 | 15125000 | 15350000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 134250000 | 166650000
 | DM Net Ad Yield Per Page - Display |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40666.66666666666 | 41074.38016528926 | 41475.40983606558 | 41869.91869918699 | 42258.06451612903 | 42640 | 43015.87301587302 | 43385.82677165354 | 43750 | 44108.52713178295 | 44461.53846153846 | 44809.16030534351 | 45151.51515151515 | 45488.72180451127 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 222821.5767634855 | 43568.62745098039
 | Classified Adv. Net Revenue - Newspaper |  | 1500000 | 1600000 | 1700000 | 1800000 | 1900000 | 2000000 | 2100000 | 2200000 | 2300000 | 2400000 | 2500000 | 2600000 | 2700000 | 2800000 | 2900000 | 3000000 | 3100000 | 3200000 | 3300000 | 3400000 | 3500000 | 3600000 | 3700000 | 3800000 | 3900000 | 4000000 | 4100000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27000000 | 41400000
 | DM Net Ad Yield Per Page - Classified |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27000 | 27317.07317073171 | 27619.04761904762 | 27906.97674418605 | 28181.81818181818 | 28444.44444444445 | 28695.65217391304 | 28936.17021276596 | 29166.66666666667 | 29387.75510204082 | 29600 | 29803.92156862745 | 30000 | 30188.67924528302 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 133333.3333333333 | 29052.63157894737