This quick reference guide is a cheat sheet or Planning Key Users.

Running Weekly Adherence Report boils down to two things:

  • take a snapshot of the production schedule
  • upload it in the adherence report database

Step-by-step guide

  1. Take a snapshot of the production schedule:
    1. Find the Production Schedule in ADM
    2. make sure no filter is active:  if this function is greyed out, you are good. If it is not greyed out, press the button to clear your filter.

    3. export it as a spreadsheet

    4. in your spreadsheet, make sure that production quantities are without decimals. The google sheet may misinterpret decimals.

  2. Upload it in the Adherence report database
      1. find the SpP PA Sch Data Extract & Sparsing file
      2. open the PicasoImport sheet
      3. clear the data (important !)
      4. copy/paste from your spreadsheet (see previous step)
      5. make sure the other views (MonthView, RemainingMonthView, WeekView) display no #N/A or #ERROR

      6. in the menu, find the 'Key User Toolbox'

      7. choose 'Activate Weekly Schedule'. This will create the corresponding sheet the the SpP PA Sch Data Keep file. That will free you up from having to save the schedule snapshot at a specific time.