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

 |  | 2011 |  |  |  | 2012 |  |  |  | 2013
Company Name | Tier | Q1 | Q2 | Q3 | Q4 | Q2 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
M | 1 | 500000 | 500000 | 500000 | 500137 | 1500294.557387773 | 1500294.833708555 | 1500294.591788502 | 1500431.760868113
X | 1 | 706555 | 728418 | 757621 | 802952 | 1706849.222584808 | 1728712.244761832 | 1757915.984650357 | 1803246.69548072
Average |  | 603277.5 | 614209 | 628810.5 | 651544.5 | 1603571.88998629 | 1614503.539235194 | 1629105.28821943 | 1651839.228174417 |  |  |  |  | <-- all of the 'total' values should autopopulate
Company Name | Tier | Q1 | Q2 | Q3 | Q4 | Q2 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
C | 2 | 665404 | 704277 | 737202 | 764145 | 1665698.368586139 | 1704571.220230448 | 1737496.497232159 | 1764439.544538866
H | 2 | 684747 | 639285 | 760550 | 899370 | 1685041.440718237 | 1639579.665060158 | 1760844.61097073 | 1899664.622605926
I | 2 | 500000 | 500000 | 500000 | 507742 | 1500294.852322167 | 1500294.038881871 | 1500294.773202717 | 1508036.372111248
O | 2 | 1534362 | 1503998 | 1556809 | 1777998 | 2534656.430248072 | 2504292.842898706 | 2557103.783262123 | 2778292.94193279
R | 2 | 500000 | 500000 | 500513 | 503647 | 1500294.402841726 | 1500294.245432872 | 1500807.361373256 | 1503941.541241364
S | 2 | 719846 | 1088869 | 1250406 | 1444541 | 1720140.084642443 | 2089163.008057093 | 2250700.625979307 | 2444835.856739737
Average |  | 767393.1666666666 | 822738.1666666666 | 884246.6666666666 | 982907.1666666666 | 1767687.596559798 | 1823032.503426858 | 1884541.275336715 | 1983201.813194988 |  |  |  |  | <-- all of the 'total' values should autopopulate
Company Name | Tier | Q1 | Q2 | Q3 | Q4 | Q2 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4
A | 3 | 4110873 | 4439646 | 3961663 | 3622579 | 5111167.194138822 | 5439940.762151687 | 4961957.281307497 | 4622873.568335981
B | 3 | 514878 | 527959 | 530021 | 528465 | 1515172.230417429 | 1528253.317374853 | 1530315.507897164 | 1528759.038248438
D | 3 | 1850788 | 1770447 | 1811503 | 1877632 | 2851082.200277979 | 2770741.284079765 | 2811797.898706987 | 2877926.30518267
E | 3 | 746566 | 988080 | 3950297 | 1512901 | 1746860.433653103 | 1988374.260627719 | 4950591.092962857 | 2513195.769941078
F | 3 | 987129 | 1001647 | 1047901 | 1049495 | 1987423.722319397 | 2001941.566925684 | 2048195.748614528 | 2049789.1666215
G | 3 | 2079560 | 1934106 | 2146100 | 2061716 | 3079854.755428099 | 2934400.01242019 | 3146394.276795484 | 3062010.866857986
J | 3 | 1415681 | 1978772 | 2921475 | 3431909 | 2415975.200181268 | 2979066.187924396 | 3921769.554251643 | 4432203.354401466
K | 3 | 1087391 | 1037321 | 1193695 | 1073558 | 2087685.43255216 | 2037615.737481574 | 2193989.019368941 | 2073852.435413469
L | 3 | 1043230 | 1072654 | 1485437 | 1657045 | 2043524.762258868 | 2072948.959345737 | 2485731.161876943 | 2657339.478754403
N | 3 | 1223589 | 1257558 | 1399650 | 2576931 | 2223883.935383752 | 2257852.703597353 | 2399944.705142374 | 3577225.103403689
P | 3 | 720645 | 684779 | 700121 | 686641 | 1720939.065524864 | 1685073.181144071 | 1700415.07980948 | 1686935.170014782
Q | 3 | 1456248 | 2030727 | 2610987 | 4467113 | 2456542.253223594 | 3031021.194930346 | 3611281.294916937 | 5467407.585462349
T | 3 | 500000 | 500000 | 500000 | 500000 | 1500294.708250192 | 1500294.674440395 | 1500294.364607901 | 1500294.737307158
U | 3 | 1235715 | 1292868 | 1355267 | 1475968 | 2236009.37115912 | 2293162.743463756 | 2355561.725584149 | 2476262.292554274
V | 3 | 969710 | 1128229 | 1118100 | 1232625 | 1970004.135516868 | 2128523.113926433 | 2118394.001513381 | 2232919.775347514
W | 3 | 993449 | 1038205 | 1058590 | 1157269 | 1993743.965333954 | 2038499.53567145 | 2058884.734120372 | 2157563.295057884
Y | 3 | 2723982 | 2957087 | 3056647 | 2870712 | 3724276.657828966 | 3957381.646374862 | 4056941.06964872 | 3871006.369467926
Z | 3 | 1735844 | 1590223 | 1739663 | 1637785 | 2736138.876028194 | 2590517.603651558 | 2739957.290699368 | 2638079.390076335
Average |  | 25395278 | 27230308 | 32587117 | 33420344 | 43400578.89947663 | 45235608.48553182 | 50592415.80782472 | 51425643.7024489 | 60304521.57449646 | 60335322.67422722 | 73276833.71117344 | 67102089.28372777 | <-- all of the 'total' values should autopopulate
 |  |  |  |  |  |  |  |  |  | Yellow = insert projected values