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

 | [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 | 1100 | 143.3693056449522 | 640.8033229290248 | 671.9205977818532 | 224.2873403967318 | 161.7935137282753 | 83.55292041512273 | 129.0328597342457 | 234.9804161343971 | 803.1856742171419 | 862.412489396973 | 1003.33973525286 | 1501 |  | 403.7850801837374 | 1055.121665336294 | 876.9478993636111 | 116.0686537479964 | 615.3961948399341 | 96.7552563539132 | 280.9168997274967 | 560.1948054561143 | 370.9986494448834 | 380.4919087546746 | 946.9397556659573 |  | 1502 | 1097.636109917079 | 541.4998080333231 | 10.42664868831631 | 1069.698753289455 | 918.3579792982041 | 29.62135506303292 | 711.0523766663334 | 1501 | 407.7144339274993 | 945.176988095035 | 676.4633646187958 |  | 867.7552820909023 | 676.8110530117613 | 280.1108982693031 |  | 1042.715450968408 | 610.3658159112339 | 162.4748764789783
A2 | 977.8961422851746 | 954.9172660726096 | 312.4257261140546 | 846.8914026197725 | 790.4507297201677 | 707.265001692222 | 126.7537134121857 | 437.5861757326225 | 995.7386498074261 | 695.9163756128535 | 162.1590857057445 | 587.6379995459762 | 63.8868682831248 |  | 503.7369921841612 | 23.62577548653766 | 140.6508102641164 | 514.4157795704728 | 586.5407919201978 | 951.7961458607703 | 50.88037211490064 | 58.62887606884097 | 898.9412503307593 | 1021.490959091164 | 393.7027422498836 |  | 501.6513452165406 | 244.2386429224994 | 169.3818632110192 | 111.6375809146078 | 77.16156167960335 | 47.2177504841929 | 59.92066158135256 | 33.7679934036526 | 776.6682730835842 | 188.3513854120739 | 51.43976859503154 | 225.1440498379473 |  | 1039.619539221572 | 99.45084039840373 | 320.9027807082245 |  | 23.75571014420881 | 1054.703842179796 | 727.2616285303861
A3 | 962.0405206537836 | 1031.757630413599 | 1094.06661820132 | 203.5059092711888 | 1009.899036243309 | 998.9564047474596 | 51.72673689682266 | 223.6864534627572 | 552.1179370301927 | 708.864307626172 | 490.9627246142641 | 397.1567917654113 | 222.5457041969468 |  | 204.2513487726807 | 837.3807859807354 | 554.3935378117392 | 84.56928880282537 | 387.514454867386 | 1021.196907697828 | 562.6594236118182 | 780.9473934245989 | 497.474559801133 | 1088.091208017201 | 778.604735730402 |  | 919.5469064272146 | 118.015037446166 | 721.8420375182228 | 268.4027335666314 | 36.21205109515646 | 13.59161633060881 | 451.9077359211876 | 905.734489365114 | 218.7774636017818 | 1053.40728507479 | 197.0753505432987 | 216.6519361396859 |  | 492.6811886202938 | 390.7790702354371 | 842.8765674504156 |  | 728.9865388818353 | 263.7288324605879 | 543.5658705461092
A4 | 717.0636606950463 | 900.0515424069973 | 64.945431080046 | 314.3303410178085 | 76.68420885668546 | 531.3915029542283 | 131.318103390604 | 209.3165740792758 | 915.0750668485566 | 102.8225229771571 | 1029.576547744968 | 748.9044774931903 | 829.9941795892328 |  | 138.5315880244919 | 285.3539018386631 | 414.8071106072057 | 1035.611089484186 | 26.38111873899427 | 506.5843499880546 | 905.0321886451991 | 963.9840172855683 | 275.4716020598527 | 292.4666939376375 | 322.4181806249615 |  | 249.8600818674584 | 622.9471882709043 | 336.0380046786462 | 803.2515240937922 | 127.3488295807788 | 713.579973831298 | 620.1123635945653 | 448.3761286927552 | 764.2230407294063 | 838.0498087647165 | 538.285269135675 | 125.3809689957292 |  | 576.4477092319842 | 835.8459112324153 | 326.9699735786058 |  | 792.7737523537959 | 870.4837677276065 | 65.9753327739688
A5 | 823.8033770489415 | 180.2088880579738 | 340.7916030129341 | 760.4556005478885 | 443.0977330813465 | 538.8457815175952 | 890.1769706674671 | 434.5908432719582 | 200.3919803575118 | 377.6096547488779 | 877.1141730432787 | 395.5675811473394 | 376.9067282313638 |  | 586.4911432686941 | 43.64318462777887 | 1025.727219735961 | 15.46141375143468 | 92.20763977800081 | 405.2963856386517 | 572.2747397234349 | 969.0291295542806 | 82.19798572574291 | 698.4906047173429 | 571.2372504769055 |  | 340.6275303890391 | 999.2232016777575 | 51.67542918219947 | 838.4052897652521 | 841.6884133401167 | 393.4631656087286 | 812.1567225533867 | 253.9106248276437 | 698.4941032815467 | 881.2871441253835 | 518.1942156611285 | 1065.027827346988 |  | 964.1622067596328 | 730.4359341808071 | 927.0400912983455 |  | 463.3790173603601 | 404.1082657940189 | 1002.496309966978
A6 | 1092.860486646746 | 788.4805947282847 | 972.258245656621 | 519.4122790286024 | 842.2991500295196 | 548.8391248229623 | 781.9180464491909 | 1078.518117004288 | 413.0827982899472 | 721.1589067063608 | 840.7758721269022 | 586.0438135412344 | 342.8649580999994 |  | 35.95492258059458 | 713.3289291804784 | 319.8945421435154 | 899.6561402585397 | 799.1134224744462 | 701.4921760816835 | 1097.095414940661 | 896.881030979653 | 859.1473432989616 | 287.6681433704765 | 549.2192754720593 |  | 482.6051868637754 | 813.3606190512988 | 319.7015245216139 | 621.1779151030607 | 806.8079459667784 | 1049.037552268873 | 1087.982655426877 | 788.1785768901856 | 537.3217338567378 | 348.0585277329874 | 913.9192439524912 | 30.76207947497882 |  | 967.2671876792008 | 367.0332665564836 | 301.8960114546969 |  | 115.1289768085985 | 521.7152934343744 | 877.1847547799323
A7 | 242.7576913344886 | 631.5820357286461 | 895.2481664591364 | 577.1578129229821 | 1089.07391766402 | 659.6275740172864 | 234.9790529731449 | 799.0003986714189 | 546.0830303893291 | 14.17672887079227 | 911.8991842959651 | 385.461306602492 | 491.8230589783442 |  | 1077.497142467417 | 205.8161228120586 | 116.0901871909864 | 849.976336010586 | 198.440886391072 | 449.7712798755187 | 1059.071025678657 | 441.8432435080832 | 488.7129573663574 | 534.3615905410237 | 819.621997403972 |  | 496.5126812282719 | 485.7717998573492 | 458.453922909636 | 693.6963152693993 | 640.8555947992465 | 877.4617236163482 | 966.741285795837 | 913.0478725404954 | 1000.092807949357 | 38.71791646899965 | 185.2985970599002 | 867.4321684213967 |  | 970.6482572665418 | 345.9249413731823 | 253.86753279021 |  | 597.5492527248803 | 1046.842667822849 | 550.0585864308473
A8 | 963.6011790014729 | 100.6789596751869 | 381.7782289795956 | 190.0955324652817 | 30.47086685985345 | 240.6023816811538 | 964.1653728842789 | 414.8297383697386 | 568.1130798275434 | 967.1133217873088 | 172.1476922540757 | 92.48589788210329 | 1003.067975209631 |  | 131.145260352452 | 147.9664343421586 | 42.33636472109832 | 642.7077429863357 | 1099.080105579491 | 971.6486992665913 | 419.1359937869983 | 771.043895512305 | 619.168604929852 | 517.0362457152377 | 918.1006160601978 |  | 333.0717623565004 | 157.6835734389944 | 654.7232835397083 | 991.262115809392 | 1025.102778553437 | 99.34745185313432 | 386.4405743641955 | 929.4604303053748 | 926.6468541810152 | 153.7399355636462 | 262.4877500774337 | 1005.873660365614 |  | 860.0946703363618 | 847.1322872116958 | 249.4232882431335 |  | 135.3907066504714 | 418.5113306890862 | 580.9826890248577
A9 | 326.94482744341 | 225.5476926728464 | 427.191946463241 | 924.761113076358 | 131.30152044048 | 180.3525144217465 | 304.832600800202 | 96.67597041509195 | 264.6840728936738 | 205.2685173269457 | 267.2147993614862 | 776.8933761375321 | 474.8993289550755 |  | 679.2309629923215 | 605.5332145029573 | 1023.998790136583 | 84.31755309068589 | 222.0547397072041 | 458.0033759886222 | 474.6997165598464 | 57.97175223781479 | 55.73399489794972 | 1089.616705266 | 444.1852012712977 |  | 262.1190982671998 | 530.8038729829912 | 955.2051628269161 | 585.8376801228496 | 171.9514406379582 | 456.4733631427351 | 389.2485489762061 | 801.4594804642999 | 414.3875376394298 | 331.3829546504367 | 316.5522461657761 | 1093.222495386075 |  | 984.8830217384832 | 740.6304363049803 | 147.5392876183508 |  | 1033.752683000298 | 625.770548372879 | 1029.683242886911
A10 | 66.41965923450476 | 175.1629894640341 | 632.145644458154 | 53.78297771740268 | 2.622016923716219 | 679.3654648022534 | 110.3819838068363 | 701.5730685197515 | 871.4586857975625 | 21.16120732517457 | 944.697975958433 | 793.8272015242707 | 124.4054844938516 |  | 422.5249526499605 | 445.3557834434263 | 191.7233119538479 | 624.4276838751389 | 550.6749122703565 | 74.8110630377715 | 659.5089035284875 | 12.95170625550897 | 601.5216650441904 | 1045.752784476672 | 895.0483910635805 |  | 148.2530666875787 | 119.0585506019114 | 372.1327025121248 | 752.0943562800035 | 194.4658377387854 | 343.8534824214798 | 499.4773358296729 | 158.7387979397456 | 691.2882378131826 | 727.0612214857149 | 824.5396997373487 | 61.81515684735337 |  | 989.5748575065545 | 580.5937026889392 | 339.2460096422938 |  | 392.2149171971701 | 832.3460714347729 | 1054.817198827946