If you would like to paste task observations that were taken outside of Assembly Planner, please note the following rules. You need not create the tasks in the Tasks table prior to pasting observations; any new tasks will be automatically created when a new observation is manually entered for that task.
•Before pasting data, make sure that the order of the columns in your Excel file match the order of the columns in the Time Study Module.
•Use the right-click menu to Copy and Paste. (The Windows keyboard shortcuts do not work in this version of the application.)
Rules for each field
•Order – This is a system-generated field that simply keeps track of the order in which observations are recorded in Assembly Planner and cannot be edited.
•ID – A new or existing ID can be pasted into this field. If the ID needs to be changed, you must right-click on the cell and select ‘Reassign Observation to Different Task.’
•Description – A description can be pasted if associated to a new task ID. If the ID already exists in the Tasks table, the description on the new observation will match the description existing in the Tasks table. The description of any existing task must be edited in the Tasks table, and then will be reflected in the Observations table.
•Comments – This field can be edited at any time.
•Rating – This field will be populated to the default rating for the selected Operator, but can be changed at any time.
•Start – A start time of the task must be pasted by the user and can be edited at any time.
•End – An end time of the task must be pasted by the user and can be edited at any time.
•Ignore Time – An ignore time can be pasted, although it may not be valuable because there is no video associated with this observation.
•OT – This is a calculated field and cannot be edited. OT = Start – End – Ignore Time. If you paste a value in OT that does not match the calculation from those three columns, the value will be overwritten when you Save your study.
•NT – This is a calculated field and cannot be edited. NT = OT * Rating If you paste a value in NT that does not match the calculation from those two columns, the value will be overwritten when you Save your study.
•Operator – An existing operator name can be pasted into this field. If no operator is defined with the paste, or if the name pasted does not existing in the operator list, this field will be populated by default to the name displayed in the Operator drop-down list. If a new Operator is to be assigned to an observation, that Operator must be created through the Operator edit menu first.
•Vid File – This field will be populated by the default “-- Stopwatch Study --“, indicating that the observation was made outside of Assembly Planner.