Data Entry Guidelines and Instructions

Glossary

• A complete glossary of terms for both T&D and Customer Service.

Customer Service Guidelines

• A document that explains, at a high level, what we want for each category of questions in the Customer Service questionnaire.

Transmission & Distribution Guidelines

• A document that explains, at a high level, what we want for each category of questions in the Customer Service questionnaire.

Webex Webinar

• A fast and furious walk through of how to use the software.

​

• Data Entry Training 1:05 PM Eastern Wednesday, April 2, 2025

• Data Entry Training 11:05 AM Eastern Thursday, April 3, 2025

• Data UPLOAD Training 12:05 PM Eastern Thursday, April 10, 2025

• Data UPLOAD Training 11:05 AM Eastern Monday, April 14, 2025

Training Presentation

• A work at your own pace presentation on how to use the software.

Logging In and Navigation Overview

• Web address:  https://1qconsulting.intellimas.net/1qconsulting/login#/   

• User name/password:  Provided via email

• Top of Screen: Ignore except for “Home”, “Print”

• Left column: Ignore

• Center Screen Boxes:

  • [Company Name] T&D Questionnaire and/or

  • [Company Name] CS Questionnaire

  • Glossary

  • Data Entry Instruction Videos

  • Incomplete Questions – Pick a Company

  • Open Questions by Assignee

  • Upload Current Responses by Category

Getting Started

• Viewing this year’s questionnaire and Glossary

  • [Company Name] T&D Questionnaire and/or

  • [Company Name] CS Questionnaire

  • Glossary

• Searching

• Filtering

• What to do first: see Assigning Data Collectors

Views

• Grid View

• Question Form

• Saving your own view

Assigning Data Collectors

• Previous data collector information

• Updating/entering data collector information

• Once assignments are made you can distribute the questionnaire via Excel or Data Collectors can log in and search for their questions

Uploading Assignees

The video shows how to upload

• N/A 

• Who Assigned 

• Date Entered 

• Who Provided 

• Date Provided 

• Source / Comments

Distributing Questionnaires

Used for:

• Distributing a blank questionnaire

• Downloading a completed questionnaire

Distributing the Glossary

• Accessing the glossary

• Distributing a glossary via PDF

Entering New Data

• Accessing and finding questions for on-line data entry

• Entering new data

• Editing previous years or existing data

  • ​Note here – if they are not the assigned data collector, they should verify their edit as we cannot retrieve lost data

• Note: please report data entry issues (ASAP)

Formatting Questionnaires

• Questionnaires are exported out of Intellimas where all the cells are formatted as 'Text'.  This makes it impossible to perform calculations.

• You can quickly change the format to 'General' to allow calculations to sum up rows.

• Watch this video to find out how.

Uploading Data from Excel

• Uploading Current Responses by Category

• Uploading multiple Categories

• Uploading Historical Data

• Uploading Assignees, NA, etc.

Here's a link to a webinar recording of how to do this...

Recording

​

Data Stewarding

• Incomplete Questions – Pick a Category

• Open Questions by Assignee

• Reports to Excel