Spreadsheet: 800390d1665647733-sumifs-if-the-right-contitions-are-meet-test-formular
Sheet: Forecast_lager

Tekst | Select | Lagerbeholdning | Material Number | Product Desc | Location plant | Location ID | Summen af W42 2022 | Summen af W43 2022 | Summen af W44 2022 | Summen af W45 2022 | Summen af W46 2022 | Summen af W47 2022 | Summen af [NAME] 2022 | Summen af W49 2022 | Summen af W50 2022 | Summen af W51 2022 | Summen af W52 2022
Behov | Egen Produktion |  | 5650009819 | Test1 | 5650 | 5650CSD | 184.702348 | 163.89594 | 174.291422 | 522.610605 | 182.469941 | 185.384234 | 86.35733999999998 | 0 | 0 | 0 | 0.000336
Lager | Egen Produktion | 504 | 5650009819 | Test1 | 5650 | 5650CSD | 819.297652 | 655.401712 | 481.11029 | -41.50031499999994 | -223.9702559999999 | -409.3544899999999 | -495.7118299999999 | -495.7118299999999 | -495.7118299999999 | -495.7118299999999 | -495.7121659999999
Produktion | Egen Produktion |  | 5650009819 | Test1 | 5650 | 5650CSD | 500
Behov | Egen Produktion |  | 5650009819 | Test1 | 5660 | 5660CSD | 184.70234 | 163.895933 | 174.291391 | 522.6103939999999 | 182.469916 | 185.384206 | 86.35724299999998 | 0 | 0 | 0 | 0.000336
Lager | Egen Produktion | 0 | 5650009819 | Test1 | 5660 | 5660CSD | 315.29766 | 151.401727 | -22.88966400000001 | -545.500058 | -727.969974 | -913.35418 | -999.711423 | -999.711423 | -999.711423 | -999.711423 | -999.7117589999999
Produktion | Egen Produktion |  | 5650009819 | Test1 | 5660 | 5660CSD | 500
Behov | Egen Produktion |  | 5650007826 | Test2 | 5600 | 5600CSD | 104.233704 | 105.714534 | 104.091413 | 106.286886 | 105.867295 | 106.80651 | 105.186744 | 104.429881 | 104.152055 | 114.180326 | 117.594965
Lager | Egen Produktion | 96 | 5650007826 | Test2 | 5600 | 5600CSD | -8.233703999999989 | -113.948238 | -218.039651 | -324.326537 | -430.193832 | -537.000342 | -642.187086 | -746.616967 | -850.7690220000001 | -964.9493480000001 | -1082.544313
Produktion | Egen Produktion |  | 5650007826 | Test2 | 5600 | 5600CSD
Behov | Egen Produktion |  | 5650007826 | Test2 | 5650 | 5650CSD | 467.796341 | 536.664588 | 547.640946 | 621.059199 | 531.935194 | 706.706675 | 553.314942 | 578.345492 | 677.4692929999999 | 1088.746346 | 761.0476319999999
Lager | Egen Produktion | 2096 | 5650007826 | Test2 | 5650 | 5650CSD | 1628.203659 | 1091.539071 | 543.8981250000002 | -77.16107399999987 | -609.0962679999999 | -1315.802943 | -1869.117885 | -2447.463377 | -3124.93267 | -4213.679016 | -4974.726648
Produktion | Egen Produktion |  | 5650007826 | Test2 | 5650 | 5650CSD
Behov | Egen Produktion |  | 5650007826 | Test2 | 5660 | 5660CSD | 1258.480295 | 1306.201049 | 1508.467034 | 1453.696498 | 1390.172282 | 2248.689042 | 1511.89227 | 1552.584275 | 1840.736263 | 2866.672621000001 | 1808.881531
Lager | Egen Produktion | 4464 | 5650007826 | Test2 | 5660 | 5660CSD | 3205.519705 | 1899.318656 | 390.8516219999997 | -1062.844876000001 | -2453.017158000001 | -4701.706200000001 | -6213.598470000001 | -7766.182745000001 | -9606.919008 | -12473.591629 | -14282.47316
Produktion | Egen Produktion |  | 5650007826 | Test2 | 5660 | 5660CSD
Behov | Egen Produktion |  | 5650007833 | Test3 | 5600 | 5600CSD | 2404.117945 | 2404.117944 | 2408.267931 | 2408.959598 | 2402.2404 | 2402.240397 | 2405.380173 | 2407.73501 | 2407.735009 | 2407.735009 | 2395.134245
Lager | Egen Produktion | 218 | 5650007833 | Test3 | 5600 | 5600CSD | -2186.117945 | -4590.235889 | -6998.50382 | -9407.463418 | -11809.703818 | -14211.944215 | -16617.324388 | -19025.059398 | -21432.794407 | -23840.529416 | -26235.663661
Produktion | Egen Produktion |  | 5650007833 | Test3 | 5600 | 5600CSD
Behov | Egen Produktion |  | 5650007833 | Test3 | 5650 | 5650CSD | 7598.329350999999 | 7621.633621999999 | 7592.745993999999 | 8106.490285000001 | 7639.904975 | 7900.254835999999 | 7696.448200000001 | 7706.117093000001 | 7817.247665000001 | 8655.220071 | 8166.583583000001
Lager | Egen Produktion | 1583 | 5650007833 | Test3 | 5650 | 5650CSD | -6015.329350999999 | -13636.962973 | -21229.708967 | -29336.199252 | -36976.104227 | -44876.359063 | -52572.807263 | -60278.924356 | -68096.17202099999 | -76751.392092 | -84917.975675
Produktion | Egen Produktion |  | 5650007833 | Test3 | 5650 | 5650CSD