Spreadsheet: 250114d1373800998-automating-data-population-across-multiple-sheets-and-filtering-data-automating-analysis-sample-data
Sheet: Sheet1

 |  |  |  | Revenue 2011 |  |  |  | Revenue 2012 |  |  |  | Revenue 2013
Country | Pod | Company Name | Tier | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
DE | DACH | A | 3 | 4110873 | 4439646 | 3961663 | 3622579 | 5111167.194138822 | 5439940.762151687 | 4961957.281307497 | 4622873.568335981 | [projections go here]
SE | Benelux & Nordics | B | 3 | 514878 | 527959 | 530021 | 528465 | 1515172.230417429 | 1528253.317374853 | 1530315.507897164 | 1528759.038248438
GB | UK & Ireland | C | 2 | 665404 | 704277 | 737202 | 764145 | 1665698.368586139 | 1704571.220230448 | 1737496.497232159 | 1764439.544538866
SC | Emerging SEEMEA | D | 3 | 1850788 | 1770447 | 1811503 | 1877632 | 2851082.200277979 | 2770741.284079765 | 2811797.898706987 | 2877926.30518267
DE | DACH | E | 3 | 746566 | 988080 | 3950297 | 1512901 | 1746860.433653103 | 1988374.260627719 | 4950591.092962857 | 2513195.769941078
FR | FRITES | F | 3 | 987129 | 1001647 | 1047901 | 1049495 | 1987423.722319397 | 2001941.566925684 | 2048195.748614528 | 2049789.1666215
AE | Emerging SEEMEA | G | 3 | 2079560 | 1934106 | 2146100 | 2061716 | 3079854.755428099 | 2934400.01242019 | 3146394.276795484 | 3062010.866857986
GB | UK & Ireland | H | 2 | 684747 | 639285 | 760550 | 899370 | 1685041.440718237 | 1639579.665060158 | 1760844.61097073 | 1899664.622605926
FR | FRITES | I | 2 | 500000 | 500000 | 500000 | 507742 | 1500294.852322167 | 1500294.038881871 | 1500294.773202717 | 1508036.372111248
RU | Emerging SEEMEA | J | 3 | 1415681 | 1978772 | 2921475 | 3431909 | 2415975.200181268 | 2979066.187924396 | 3921769.554251643 | 4432203.354401466
RU | Emerging SEEMEA | K | 3 | 1087391 | 1037321 | 1193695 | 1073558 | 2087685.43255216 | 2037615.737481574 | 2193989.019368941 | 2073852.435413469
SK | Emerging SEEMEA | L | 3 | 1043230 | 1072654 | 1485437 | 1657045 | 2043524.762258868 | 2072948.959345737 | 2485731.161876943 | 2657339.478754403
GB | UK & Ireland | M | 1 | 500000 | 500000 | 500000 | 500137 | 1500294.557387773 | 1500294.833708555 | 1500294.591788502 | 1500431.760868113
GB | UK & Ireland | N | 3 | 1223589 | 1257558 | 1399650 | 2576931 | 2223883.935383752 | 2257852.703597353 | 2399944.705142374 | 3577225.103403689
FR | FRITES | O | 2 | 1534362 | 1503998 | 1556809 | 1777998 | 2534656.430248072 | 2504292.842898706 | 2557103.783262123 | 2778292.94193279
DE | DACH | P | 3 | 720645 | 684779 | 700121 | 686641 | 1720939.065524864 | 1685073.181144071 | 1700415.07980948 | 1686935.170014782
RU | Emerging SEEMEA | Q | 3 | 1456248 | 2030727 | 2610987 | 4467113 | 2456542.253223594 | 3031021.194930346 | 3611281.294916937 | 5467407.585462349
RU | Emerging SEEMEA | R | 2 | 500000 | 500000 | 500513 | 503647 | 1500294.402841726 | 1500294.245432872 | 1500807.361373256 | 1503941.541241364
GB | UK & Ireland | S | 2 | 719846 | 1088869 | 1250406 | 1444541 | 1720140.084642443 | 2089163.008057093 | 2250700.625979307 | 2444835.856739737
PL | Emerging SEEMEA | T | 3 | 500000 | 500000 | 500000 | 500000 | 1500294.708250192 | 1500294.674440395 | 1500294.364607901 | 1500294.737307158
GB | UK & Ireland | U | 3 | 1235715 | 1292868 | 1355267 | 1475968 | 2236009.37115912 | 2293162.743463756 | 2355561.725584149 | 2476262.292554274
CZ | Emerging SEEMEA | V | 3 | 969710 | 1128229 | 1118100 | 1232625 | 1970004.135516868 | 2128523.113926433 | 2118394.001513381 | 2232919.775347514
SE | Benelux & Nordics | W | 3 | 993449 | 1038205 | 1058590 | 1157269 | 1993743.965333954 | 2038499.53567145 | 2058884.734120372 | 2157563.295057884
GB | UK & Ireland | X | 1 | 706555 | 728418 | 757621 | 802952 | 1706849.222584808 | 1728712.244761832 | 1757915.984650357 | 1803246.69548072
GB | UK & Ireland | Y | 3 | 2723982 | 2957087 | 3056647 | 2870712 | 3724276.657828966 | 3957381.646374862 | 4056941.06964872 | 3871006.369467926
NL | Benelux & Nordics | Z | 3 | 1735844 | 1590223 | 1739663 | 1637785 | 2736138.876028194 | 2590517.603651558 | 2739957.290699368 | 2638079.390076335