1. Home
  2. Support Options
  3. On-line Support
  4. Using the Software
  5. Importing values from Excel

You can import values from Excel for a single statistic or for multiple statistics on a give day.

Importing values for a single statistic

  1. 1.

    In Excel, select a column of dates, values and notes (optional). Notes can be upto 1000 characters each. Then copy into the clipboard by pressing Ctrl-C.

  2. 2.

    Open the Statistic Entry panel in MBS 3 and click the Values by Statistic tab.

    Select the correct statistic.

  3. 3.

    Right click the mouse on the entry grid and click Paste.

  4. 4.

    Click the save button to the save values.

NEXT

Importing values for several statistics on a day

  1. 1.

    In Excel, select a column of stat names, values and notes (optional). Notes can be upto 1000 characters each. Then copy into the clipboard by pressing Ctrl-C.

    The stat name must match the stat name in MBS 3.

  2. 2.

    Open the Statistic Entry panel in MBS 3 and click the Values by Period tab.

    Select the correct date.

  3. 3.

    Right click the mouse on the entry grid and click Paste.

  4. 4.

    Click the save button to the save values.

BACK