Spreadsheet: 52032d1251726389-any-automation-formula-to-update-monthly-report-simple-linking
Sheet: Product A

 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Y2010 |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan |  | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Aug | Aug | Aug |  | Aug | Aug | Aug
 | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD |  | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD |  | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD |  | MTD | MTD | MTD |  | YTD | YTD | YTD
code | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Budget |  | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget | Budget |  | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast |  | Actual | Budget | Forecast |  | Actual | Budget | Forecast
A1 | 1500 | 732.4217336660001 | 467.9171701182922 | 145.4521411302128 | 154.7302226667289 | 484.60491225044 | 467.3415054070208 | 1356.362046345687 | 68.46580934508084 | 788.8374031169354 | 1039.223909485869 | 448.5153357017037 | 1501 |  | 1077.853878994561 | 553.3870946563833 | 1065.827688064903 | 38.0237193426658 | 496.6891793056341 | 1.177778576709754 | 510.7726875516061 | 531.6133953603064 | 822.1281859464708 | 1181.430983633774 | 1012.594974311173 |  | 1502 | 1169.689969235372 | 970.764477876501 | 1398.867715192782 | 1246.738326969158 | 29.66650670973348 | 4.096600333733047 | 553.7323835913181 | 1501 | 1276.897864384694 | 1031.879921209071 | 1318.853181889905 |  | 64.31512354395741 | 346.2404904966987 | 1242.01201755849 |  | 1251.53896993333 | 627.3316644124689 | 903.17760305558
A2 | 722.8893388826527 | 1296.628574825972 | 1073.693196589084 | 919.6099525278565 | 1211.297018898848 | 218.5054137085887 | 292.8171591530648 | 674.3173937749307 | 1074.252719222437 | 371.6653411936028 | 1290.202633643187 | 836.1205307611947 | 505.6090313313853 |  | 1368.45755962874 | 983.1706598182728 | 194.3325135711766 | 132.971349794023 | 1371.886755065406 | 545.9981868178447 | 1370.748537824634 | 51.80432733860041 | 1472.921571786464 | 201.2379327056787 | 507.6944936228358 |  | 1427.548397361732 | 810.9258081717843 | 957.3104219322411 | 301.6313049580779 | 276.5966939369502 | 116.237351116775 | 1127.746992957909 | 429.0226888387848 | 1339.25692427127 | 309.7149906561589 | 439.7167822471015 | 1269.044130737224 |  | 35.39558634345453 | 93.17145374553616 | 562.409498184734 |  | 52.74522718806119 | 413.9694149353704 | 895.4522176983705
A3 | 398.052665970666 | 1005.662438418767 | 1051.347619902064 | 268.4389234086173 | 346.3815880652783 | 1181.820257638832 | 423.6967455709224 | 112.3109357047154 | 1252.765321782137 | 1258.97481993303 | 784.0923115059825 | 1489.06874780241 | 685.5726240070109 |  | 108.7151809591315 | 777.9915007250723 | 160.006010619711 | 1495.574695921071 | 1057.866142988642 | 401.2224835713138 | 1241.40721461168 | 1033.413615353913 | 256.4849635444837 | 196.9176025189694 | 172.1589283493668 |  | 258.7208273195758 | 1123.437685194234 | 437.4326360062349 | 752.4752420158962 | 66.6012781422487 | 1264.353556289718 | 367.712490151322 | 505.6285379248715 | 28.81435124851572 | 349.519759236589 | 95.57903669386548 | 1161.124511418313 |  | 1346.418307277066 | 1143.042325438908 | 270.2025683531164 |  | 1482.935016103439 | 36.83700547310242 | 1171.209757206034
A4 | 1289.786969027309 | 1316.303823631565 | 1225.426610861761 | 1029.994924695883 | 1308.601494622882 | 124.1574949682513 | 97.94887152392629 | 1082.135554540104 | 168.9440252168072 | 18.48709368594514 | 1455.720748436251 | 477.6264789988902 | 275.0470066715529 |  | 241.0275874659401 | 630.8780009061336 | 1180.796218349358 | 121.2885879754926 | 1081.595155449309 | 1446.583771829896 | 863.9412699779075 | 1448.168684047064 | 837.9924951556776 | 575.6011136756629 | 1421.290375639322 |  | 1210.674596709271 | 734.8498955125553 | 1435.729700806393 | 1083.439760910117 | 840.1937102022328 | 783.5585029284773 | 1380.354561852306 | 1372.38885368007 | 317.3806421735366 | 1036.271374663202 | 1172.433270091921 | 1383.218497849706 |  | 175.0819700336601 | 1.216648396481945 | 1032.582657559924 |  | 98.64080087845295 | 927.6871616849993 | 1327.250724962374
A5 | 209.3155288950981 | 1105.992789897948 | 1166.725581834732 | 1412.97799036583 | 1395.005124526532 | 1108.255008235148 | 108.5634682955639 | 844.7778006432158 | 1440.195641938278 | 1043.242077500082 | 579.2695474224186 | 384.3479631677524 | 1260.807235015235 |  | 897.0160400563509 | 331.3400419684678 | 438.2606747662523 | 1351.09918533904 | 1113.363378658734 | 1126.773070857796 | 20.24922052796352 | 1197.43497402364 | 1498.841104382119 | 1485.176144780205 | 713.6445215098341 |  | 1310.622370642405 | 198.9991276479255 | 593.2768190344848 | 1488.95080533905 | 367.0432112301746 | 104.8384958529705 | 744.5054466508852 | 862.7876907413425 | 951.2967598748626 | 174.6535302505357 | 1327.984259492913 | 1410.586273734267 |  | 1155.88550044975 | 589.6135875011809 | 592.3196493643657 |  | 1226.35674268978 | 1090.717040853898 | 775.1280433819159
A6 | 1039.615474936342 | 1034.724009437585 | 711.4917071290956 | 1158.556846747269 | 6.13148596080626 | 491.7017244974207 | 326.3549753120434 | 1293.551934411337 | 939.2225397336747 | 1187.286879495632 | 1312.691207451646 | 468.2883917289806 | 1116.489589064645 |  | 1182.097621618041 | 507.7330123759816 | 127.4608255999721 | 1302.45208496156 | 346.2938897255801 | 53.13554223278505 | 1004.392941800147 | 1032.818144247562 | 1226.377034817605 | 328.3952174398173 | 624.7986012546955 |  | 874.2063332476499 | 1379.623105554564 | 574.507537163047 | 305.1620797846919 | 845.8427965840531 | 1299.285467844903 | 1494.732358198903 | 1265.588042539195 | 994.3603320284702 | 435.8244586999443 | 54.48797826985663 | 632.0081648410376 |  | 1355.262009102044 | 996.9565671785294 | 1109.018892385369 |  | 1041.614654747987 | 1084.698810138668 | 1213.41498598689
A7 | 436.1828960168021 | 112.2123478915479 | 62.2687509105394 | 1483.814987657707 | 823.3807997937074 | 179.5743918018915 | 219.2209814673407 | 680.2501674055628 | 1336.769904146148 | 1357.633029901707 | 657.7937048349955 | 101.2262944005234 | 251.9341803825299 |  | 1041.357648845888 | 47.87656504924609 | 1078.01522138859 | 98.34299601655827 | 729.2703621602808 | 1268.273656587279 | 249.4609568460466 | 930.9593926568617 | 1424.655657074872 | 677.9263111109323 | 976.7645889489256 |  | 624.948473344199 | 372.108325795983 | 377.0610546288335 | 61.00343865814884 | 1341.993455249528 | 999.6501992584496 | 614.383100825234 | 457.388205356942 | 1202.579267927432 | 991.3475222007859 | 1248.659341668483 | 434.2111764214325 |  | 390.9142640225674 | 1048.385098978032 | 1163.4143162366 |  | 857.0976769800538 | 59.58419960819783 | 1319.115929403534
A8 | 1301.004008791391 | 43.61174292549319 | 889.6012493084094 | 253.0094919904244 | 831.4225244226137 | 764.101666439317 | 533.9149562980275 | 873.3399200783664 | 1060.01297187764 | 256.6976684184559 | 799.189807639854 | 678.8925284129981 | 345.0273766192789 |  | 1428.23666794009 | 1052.548033117806 | 1123.361929098895 | 817.6194404759673 | 503.0452111421653 | 282.8622226444564 | 834.1202579275508 | 1471.347272811197 | 683.5473411170758 | 1263.830962720366 | 479.159512357782 |  | 227.5845325331889 | 758.1214579214754 | 4.877628932236533 | 581.6964552926512 | 1249.054229559433 | 53.350783474583 | 1045.302144462588 | 482.8323941594297 | 1334.311249990471 | 1047.449142536823 | 1466.405693725826 | 314.9581874081501 |  | 1134.175247933156 | 1460.467543129477 | 164.6204541810055 |  | 888.4945908462785 | 1451.652819821743 | 409.0315635572501
A9 | 979.407797752572 | 787.5127227719032 | 962.8626400721012 | 284.2911555305691 | 172.2056832132997 | 428.5621988750972 | 345.801140705429 | 400.075001264312 | 1063.114964231564 | 1139.693343626805 | 466.1666222688696 | 325.4844953495226 | 589.0847733417658 |  | 1065.727541902606 | 438.8739465244487 | 64.87914658671868 | 1221.031210823417 | 884.109441634668 | 858.605110463154 | 138.7607379746342 | 768.6122405204804 | 492.2959512836349 | 665.4545204274303 | 1183.854259299435 |  | 592.8593759066167 | 616.7641460463823 | 4.353434456379812 | 389.698386535501 | 1342.411688627053 | 838.503526158095 | 116.5651187274811 | 1082.433544621772 | 844.3865883543529 | 920.2371760356006 | 69.81272862689481 | 1493.602283536531 |  | 235.4999673451745 | 141.8017340573314 | 325.0195060381889 |  | 1369.707622806132 | 1062.522611868496 | 1032.672095141133
A10 | 975.8421673477486 | 1285.786413210172 | 1010.581369251914 | 598.7460715480565 | 680.8090572091303 | 554.6470268470433 | 536.7458167303857 | 410.2245878924901 | 271.6188654696206 | 342.9511567632661 | 135.6188654908586 | 1.840049983060421 | 432.3281600375095 |  | 742.2469185469714 | 1377.195512483874 | 404.4182774728043 | 1397.571789696867 | 799.0005646492167 | 228.2202220597602 | 1084.500553252228 | 1382.115704636436 | 1245.064482737635 | 366.7346211381782 | 698.3694176730052 |  | 675.319246821225 | 834.6822606222192 | 878.5712893827349 | 467.6283354662432 | 1155.345441204804 | 1205.023195153207 | 833.258870317978 | 609.5859274706763 | 1067.473118559775 | 725.3488979154445 | 67.46495092169424 | 781.8478412693653 |  | 1186.664795390646 | 1349.339668660647 | 251.494893355904 |  | 480.8659737925594 | 41.98241909802414 | 234.5750601378673