Spreadsheet: 866319d1713275177-not-getting-specific-data-from-certain-year-test
Sheet: Countries

§ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FCQ1 202301 | FCQ1 202302 | FCQ1 202303 | FCQ1 202304 | FCQ1 202305 | FCQ1 202306 | FCQ1 202307 | FCQ1 202308 | FCQ1 202309 | FCQ1 202310 | FCQ1 202311 | FCQ1 202312 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actuals 202302 | Actuals 202303 | Actuals 202304 | Actuals 202305 | Actuals 202306
2
3
4 |  |  |  |  | April |  |  |  | April |  |  |  | May |  |  | May
5 |  |  |  |  |  | FCQ1 |  |  |  | FCQ1 |  |  |  | FCQ1 |  | Actuals | Budget | FCQ1 |  |  |  |  |  | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget |  | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 | FCQ1 |  | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 | FCQ2 |  | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 | FCQ3 |  | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals | Actuals
6 |  |  |  | 202304 | 202304 | 202304 |  | 202404 | 202404 | 202404 |  | 202305 | 202305 | 202305 |  | 202405 | 202405 | 202405 |  |  |  |  |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312 | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 |  | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 |  | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 |  | 202401 | 202402 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412 |  | 202301 | 202302 | 202303 | 202304 | 202305 | 202306 | 202307 | 202308 | 202309 | 202310 | 202311 | 202312 | 202401 | 202302 | 202403 | 202404 | 202405 | 202406 | 202407 | 202408 | 202409 | 202410 | 202411 | 202412
7 |  | Country |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  | USA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1203959 |  |  |  |  |  |  |  |  |  |  |  | 1308837.128486238 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1217369 | 1224307 | 1231614 | 1239945 | 1249531 | 1257416 | 1263572 | 1271058 | 1275921 | 1282999 | 1290754 | 1305498 | 1308489 | 1310920 | 1317328 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920
9 |  | Argentina |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14983 | 14456 | 17399.49126519432 | 16801.65836 | 18297.61792026588 | 18889.58852180465 | 19310.16353363554 | 20485.35078568866 | 21833.0983558601 | 22131.12145542798 | 24592.01994077847 | 23021.633585 | 17438 | 16227 | 19270 | 18582 | 21549 | 19950 | 20807 | 23118 | 24775 | 23956 | 24120 | 21291 |  |  |  |  | 25417 | 26067 | 25536 | 20807 | 23118 | 24775 | 24648 | 24798 | 22187 |  |  |  |  |  |  |  | 20807 | 23118 | 24775 | 23956 | 24120 | 21291 |  |  |  |  |  |  |  |  |  |  | 23956 | 24120 | 21291 |  | 25323 | 23656 | 24739 | 23124 | 22410 | 21380 | 22327 | 22013 | 25015 | 25067 | 33469 | 24325 | 23282 | 24345 | 22008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  | Australia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1239 | -1272 | -1466 | -1220 | -1261 | -1355 | -1308 | -1674 | -1608 | -1237 | -1308 | -1696 | -1686 | -2016 | -2285 | -1820 | -2276 | -1870 | -2021 | -2872 | -2379 | -1876 | -1598 | -1916 |  |  |  |  | -2490 | -2753 | -2394 | -2021 | -2872 | -2379 | -2568 | -2276 | -2812 |  |  |  |  |  |  |  | -2021 | -2872 | -2379 | -1876 | -1598 | -1916 |  |  |  |  |  |  |  |  |  |  | -1876 | -1598 | -1916 |  | -2448 | -2939 | -2934 | -2265 | -2367 | -2004 | -2169 | -2735 | -2402 | -2612 | -3072 | -3083 | -2816 | -3072 | -2905 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  | Japan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22875 | 20717 | 21805 | 20859 | 20043 | 19376 | 20158 | 19278 | 22613 | 22455 | 30397 | 21242 | 20466 | 21273 | 19103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  | Germany |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -14844.6511971218 | -13158.1497145242 | -14654.1723236238 | -11811.2421025911 | -13334.8307615307 | -12596.1249525843 | -13212.968508204 | -14154.2700791098 | -13091.0617872995 | -13667.8039608423 | -13492.3227417822 | -12505.519792344 | -14590.97513970733 | -13386.11075451425 | -13087.19348924734 | -13425.83272024428 | -14064.77418241697 | -12405.97352523139 | -15282.27976183279 | -14358.38453508416 | -13820.71455528832 | -15160.79144328039 | -14128.93802748078 | -14443.03190650672 |  |  |  |  | -14000 | -14065 | -12406 | -15282 | -14358 | -13821 | -14972.66666666667 | -15972.66666666667 | -17972.66666666667 |  |  |  |  |  |  |  | -15282.27976183279 | -14358.38453508416 | -13820.71455528832 | -15160.79144328039 | -14128.93802748078 | -14443.03190650672 |  |  |  |  |  |  |  |  |  |  | -15160.79144328039 | -14128.93802748078 | -14443.03190650672 |  | -15937 | -13410 | -13474 | -11273 | -12158 | -13220 | -12672 | -14415 | -15535 | -14700 | -15653 | -18251 | -18035 | -14865 | -14074 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  | Canada |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1224307 | 1231614 | 1239945 | 1249531 | 1257416 | 1263572 | 1271058 | 1275921 | 1282999 | 1290754 | 1305498 | 1308489 | 1310920 | 1317328 | 1322357 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920
14 |  | India |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6938 | 7307 | 8331 | 9586 | 7885 | 6156 | 7486 | 4863 | 7078 | 7755 | 14744 | 2991 | 2431 | 6408 | 5029 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  | UAE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1220838 | 1227960.5 | 1235779.5 | 1244738 | 1253473.5 | 1260494 | 1267315 | 1273489.5 | 1279460 | 1286876.5 | 1298126 | 1306993.5 | 1309704.5 | 1314124 | 1319842.5 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920 | 1310920
16
96
97 |  |  |  | Working for AC, BU and FCQ1 with 2023 |  |  |  | Working only for BU and not for AC or FCQ1 with 2024 |  |  |  | Working for AC, BU and FCQ1 with 2023 |  |  |  | Working only for BU and not for AC or FCQ1 with 2024
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112