2 Replies Latest reply: Nov 25, 2010 9:33 AM by alexaxo RSS

    Pivot table, offset, days stock coverage

      HI there,

      does anybody know how to solve the problem below?

      Desired Result 1: is the consumption of actual stock of code A. At a given time 24/11 you start with a stock of 1000 and I would like to know how the stock will evolve by fulfilling orders.

      Desired Result 2: I would like to know how many days of coverage I have before getting out of stock.

       

       

      ABCDEFGHI
      2id_code_dwlogdt_date_order24/11/201025/11/201026/11/201029/11/201030/11/201001/12/201002/12/2010
      3CODE ASTOCK1.0001.0001.0001.0001.0001.0001.000
      4CODE AORDERS200250200250200200200
      5CODE ASTOCK-ORDERS800600690810810630600
      6CODE ADESIRED RESULT 1800550350100-100-300-500
      7EXCEL FORMULA=D3-D4=D6-E4=E6-F4=F6-G4=G6-H4=H6-I4ETC... ETC….
      DESIRED RESULT 24321


       

      Thank in advance for any ideas or help.

      Axo