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

 | [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 | 1200 | 10.9427418882599 | 491.4856024440057 | 710.1542520654838 | 1143.28549091978 | 733.367636037676 | 150.3485397185194 | 986.7577596596689 | 166.8926805076335 | 680.8962550159777 | 998.9286656903062 | 798.9980546808763 | 1501 |  | 372.1268761382479 | 1028.420336154563 | 354.7207300447791 | 3.611983737882696 | 1121.410623689601 | 906.9694894292334 | 101.2931626316977 | 958.7873775398353 | 637.1853913493946 | 799.0211840484722 | 425.6317828983487 |  | 1502 | 207.5549471200843 | 730.3020940333034 | 465.6252715469062 | 488.2538696942358 | 164.3688952658751 | 143.0130315299511 | 771.1111428652737 | 1501 | 714.1687381466854 | 45.86384543301483 | 68.8444912861498 |  | 264.667076290549 | 548.3003379464204 | 430.4133557065567 |  | 713.7173785199072 | 270.640929675325 | 1185.200150083027
A2 | 715.8641269265817 | 362.8638925396124 | 443.3278517958726 | 565.230400316387 | 175.1931600993412 | 37.53159155497627 | 259.7917226764874 | 26.32031496230987 | 813.3242175713923 | 56.88012798336457 | 710.1494826786898 | 1060.828017876152 | 884.1608601206218 |  | 589.1387384981389 | 437.5247433403363 | 673.0970159330748 | 633.3795953803086 | 366.4907241254497 | 1141.352157669084 | 1198.791066232727 | 536.4703486999748 | 894.9720988256427 | 703.7000018339505 | 860.6525844158114 |  | 630.4259314932536 | 180.2165050965933 | 1143.456355925639 | 834.9795682334797 | 1131.997036637419 | 134.3157263619633 | 900.8823535942639 | 1007.692235448486 | 872.6687302957221 | 469.5918476564739 | 1133.572720216317 | 773.5694343964401 |  | 75.41613587404541 | 283.1821962477864 | 189.8754222478079 |  | 524.2950952853276 | 638.4454526076973 | 127.7707245315948
A3 | 1008.843509773617 | 474.921035013806 | 1167.214558836739 | 429.9772757060628 | 554.4614630929863 | 910.7148808498337 | 531.4722733158551 | 685.4370044031848 | 627.8794968718074 | 803.6697695435148 | 829.761371400717 | 905.1714889078185 | 1079.781805731387 |  | 702.4086699154985 | 182.4875263529176 | 569.7686457838846 | 524.8016713612391 | 911.7928969102937 | 148.3334237500139 | 996.2315408311678 | 862.3176398031048 | 334.4433808173047 | 460.6316479631767 | 128.9010298437279 |  | 798.7502848080762 | 14.17363128263602 | 396.8532184174121 | 669.8921382369532 | 151.3736907362773 | 116.9340931885902 | 849.7854770431263 | 809.837487406607 | 697.0069263553241 | 993.8671009496602 | 481.9156942429171 | 678.3830071069499 |  | 743.5925467929278 | 1113.616579713051 | 580.6666015786783 |  | 290.7237197620055 | 180.0161646674205 | 1169.204351145963
A4 | 1.193478979862661 | 80.97896576447958 | 515.0990879946271 | 74.23283567032044 | 394.2074361112894 | 1003.017876164424 | 585.9668290538 | 325.0185389784011 | 440.709168781763 | 269.3851639587137 | 497.2156228206213 | 9.613699358106853 | 822.2239909453123 |  | 342.2677122009144 | 1047.212438840412 | 364.941121675161 | 716.3066146732415 | 833.6897170192067 | 239.0047582010396 | 1037.203552052992 | 77.91758711940489 | 513.91930204985 | 1013.833755618786 | 940.4748656418292 |  | 7.726246944055859 | 147.1587303927591 | 327.3540375154972 | 90.19304593781037 | 1088.846585925874 | 835.1835037479169 | 611.8112272207145 | 303.6430450472046 | 929.9305473898289 | 1197.267645467405 | 139.0872313824442 | 1110.723216568475 |  | 441.1695855843366 | 294.0670154049815 | 549.2301129383154 |  | 1141.009943577469 | 38.97278793453047 | 619.339328986732
A5 | 1178.72512841846 | 996.3571907481249 | 1003.19646822331 | 139.0024432511424 | 763.0477120345226 | 109.3171049059656 | 545.0367707798963 | 579.61100879156 | 92.4527119709726 | 281.5666316756935 | 240.498808484595 | 511.3900016336362 | 94.23361470002192 |  | 434.2003467618072 | 953.4619929857434 | 865.0154826818962 | 1147.652019749542 | 325.1967047040923 | 24.48633195822865 | 273.6750111848728 | 1085.337909052937 | 749.0025436527808 | 454.5337779194062 | 666.9030272989875 |  | 342.913651812526 | 479.3767425183248 | 88.69674994460155 | 527.4841453138631 | 1119.289021920182 | 77.80499064175714 | 1183.454649474987 | 224.8861912807023 | 143.8583405856871 | 597.5968160472636 | 964.3457454936984 | 601.262872889453 |  | 643.428080846381 | 486.6783546991876 | 55.37756597426 |  | 319.8544676591815 | 1133.887344065969 | 1091.473741908784
A6 | 764.2740535487409 | 1028.761821960319 | 652.8689955866349 | 60.28984257384025 | 253.1463162087022 | 388.6729998085848 | 376.0829936988769 | 855.9286673965328 | 685.4384265012736 | 157.521291874534 | 437.4224661211805 | 1133.111984310651 | 997.2905727505414 |  | 481.0921005608832 | 96.34578975786958 | 299.9048360619439 | 822.6073836862904 | 325.9017196902811 | 1026.105795749582 | 1098.043195640924 | 61.54543916084627 | 808.3266472074687 | 743.7802044337556 | 748.1632882691041 |  | 316.9316525132722 | 467.279353957602 | 327.1959366670437 | 267.8816238279644 | 709.0322171565138 | 894.4652483911323 | 999.7689395420655 | 816.9651928022133 | 53.00282394911164 | 262.3691312238524 | 986.2422175055939 | 190.6913563976527 |  | 814.9572330598002 | 83.86869073073768 | 472.5365237359043 |  | 743.387310284902 | 506.1616276181173 | 1171.956114687132
A7 | 1169.189949370873 | 591.2021252383084 | 658.8185682705323 | 884.153821225376 | 1085.194419683567 | 374.1478442167657 | 1104.581325242759 | 551.3438485446133 | 794.290995251356 | 126.7133782838005 | 1075.653793091835 | 607.6795087475641 | 626.0535635303607 |  | 233.4462219789671 | 91.92487138433378 | 511.4585494261952 | 142.7409898796107 | 74.58466616015151 | 1139.688350963225 | 1123.689059563022 | 133.4974815844546 | 709.2131453611636 | 819.4756662730665 | 195.2635996627734 |  | 1025.555626857678 | 87.96197230545353 | 588.6979086616174 | 994.7220087537995 | 1049.748301523422 | 687.8354672266825 | 1078.959997148075 | 538.0000850265052 | 575.2869026966895 | 490.5372291086318 | 629.5859223509934 | 1123.471722502092 |  | 52.56334373659142 | 347.8214293231491 | 232.4333503818255 |  | 217.8962110321715 | 1116.009834170582 | 492.6761680723654
A8 | 548.0166086009291 | 618.9781878504466 | 632.5591451544386 | 247.2430368101918 | 488.8275806483289 | 610.703762499297 | 1093.291220347217 | 170.6448162040349 | 1187.285672775 | 229.6811917653198 | 363.1161778285694 | 470.0482234637661 | 1062.961840423898 |  | 951.4769497482512 | 708.9743486264555 | 216.0119379195787 | 513.812142485683 | 180.0213349096996 | 647.3920330213427 | 896.9178147772272 | 315.8994718624559 | 672.6953789456729 | 673.549448875773 | 366.4652775038334 |  | 638.2150412800015 | 224.1937385291703 | 9.26891613446692 | 668.951230890107 | 1152.441458724826 | 985.522037527287 | 1195.899254493496 | 309.926460063984 | 925.1415297425934 | 239.0628559675179 | 374.3411097354195 | 549.2154733327839 |  | 121.6367892048054 | 353.707087965881 | 1114.363660966094 |  | 790.9800994421893 | 1030.289617149706 | 72.44942215923018
A9 | 1166.95367609601 | 463.4762133949789 | 52.68552043001318 | 522.853841732553 | 541.6516816758991 | 720.7751497571514 | 1040.70699595702 | 1090.671984614625 | 5.79318260171533 | 847.901893988011 | 909.0640118401435 | 865.3831433543053 | 208.8792290832071 |  | 156.5810242627961 | 614.6295793418026 | 104.591936364892 | 116.7309939866708 | 92.47842303249989 | 110.4530850154603 | 626.3851055787892 | 591.8064300622129 | 191.2077886214398 | 307.3339208221281 | 553.9639538843951 |  | 5.404292338079042 | 757.886113928456 | 198.0635256555519 | 304.6474598381659 | 997.8820023214603 | 987.790822803989 | 177.7755176973741 | 1026.531587427561 | 998.6345236043892 | 919.8210822731251 | 62.27933708676083 | 1025.363220826599 |  | 497.6823092661426 | 502.1454834365645 | 500.1124463036397 |  | 315.6737768357466 | 382.9338869262774 | 270.8554020153429
A10 | 32.24652140502258 | 324.3565576496483 | 972.5351780256681 | 1148.848302895053 | 818.0161059100539 | 968.7890121337289 | 923.1007471824146 | 478.5656631111731 | 566.0215855846735 | 877.7100076395037 | 638.0467390467261 | 1125.511287273873 | 91.55851924053593 |  | 987.6017084173217 | 1151.718588159208 | 1031.290048864978 | 737.7800104622149 | 252.4035619192347 | 500.9589442619177 | 233.5931871669384 | 987.9950045867168 | 499.8781388099607 | 253.3762128174217 | 55.14517702444586 |  | 684.8603859701786 | 224.5542459269468 | 553.2235930144705 | 952.1584427004043 | 331.0475113201944 | 146.4454517614317 | 422.5818415426935 | 897.0981111691567 | 1193.437076937586 | 497.8545342331984 | 462.2089418757199 | 627.4788217072714 |  | 290.6193909556657 | 765.0226315615296 | 401.4211504454604 |  | 838.0170530798399 | 1165.798307687722 | 918.7830291275261