Capturing Observations in Excel EICR sheets

EDIS provides a feature to exporting distribution board circuit details and test details into an Microsoft Excel workbook.  The  workbook had three worksheets (tabs):

  • Boards – board details
  • Circuits – circuit details and test details
  • Circuit Observations – Observations relating to circuits

The user can edit the data, save and upload the workbooks into EDIS.

The Circuit Observations tab allows for capturing multiple observations per circuit.

There are multiple columns for observations:

  • Circuit number – valid entries should match a value is in the circuit list
  • Circuit Phase – valid entries should match a value is in the circuit list
  • Observation Group – this will be selectable if the user has entries in the Organisation data, You can only select from the observation group picklist. 
  • Observation –  enter or select an observation
  • Severity code – enter a valid code
  • Unique ID, (Deleting a record with a unique ID will result in a deleted record in EDIS Cloud) – this is a system field and should not be changed or edited

 

Predefined observations shown in the pick list

If you belong to an organisation on the EDIS system there will be predefined observations.  The predefined observations will appear in the Observation Group and Observation pick lists.  Here is more information about Organisation groups.

If you are not a member of an organisation, you will not see any options in the pick lists.   

Difference between Observation Groups and Observations

For example, RCD related observation may be grouped into the RCD group, Earthing observations may be grouped into the Earthing Group.

The grouping allows for easier management of large lists of observations.