Reverse engineer output of SUMPRODUCT equation

  • ON the left hand side if you input desired count and weekly offs’s the equation generates an output grid consumed shift planning equation.



    I wish to reverse the equation and enter the output grid and aquire the weekly schedules by reverse enginering the formulas used.



    Please help.

    Files

    • SAMPLE.xlsb

      (30.05 kB, downloaded 20 times, last: )

    Blessed are the pessimists for they shall have backups......