603 - 5885 1250 (4 lines) info@mes100.com

Copy and Paste from and to Spread Input

In MiTS, you can find the properties of every entity in each module under the spread input table. These properties stated under the spread input table can be copied and pasted from and to excel or spreadsheet.

This will facilitate data porting between different projects 

Copy and paste from MiTS to excel/spreadsheet #

  1. Go to the spread input table
  2. Click on any cell in the spread input table
  3. Press “ctrl + A” and “ctrl +C” on your keyboard
  1. Open spreadsheet/excel, click on any cell
  2. Press “ctrl + V” on your keyboard
  3. Image below shows the output you will have in the spreadsheet/excel

Copy individually and paste from MiTS to excel/spreadsheet #

  1. Go to the spread input table
  2. Click at the cell in the first column which represents the entity you want to copy.
  3. Press “ctrl +C” on your keyboard
  1. Open spreadsheet/excel, click on any cell
  2. Press “ctrl + V” on your keyboard
  3. Image below shows the output you will have in the spreadsheet/excel

Note:
If you copy input from spread input by pressing “ctrl + A”, the header will also be copied and pasted in the excel/spreadsheet. If you copy the row by selecting it manually, the header of the table will not be copied and pasted in the excel/spreadsheet.

Copy and paste from excel/spreadsheet to MiTS #

When you make any changes or edit any value of your entity in excel/spreadsheet and want to copy and paste the value, you can do so.

  1. In the excel/spreadsheet, only select the content of the spread input
  2. Press “ctrl + C”
  1. Click at the second column, second row under the spread input table as shown per image below
  2. Press “ctrl + V”
  3. New values copied from excel/spreadsheet will be pasted accordingly in the spread input table