What is preQ?

The preQ software tool is designed to streamline procurement processes within organizations. It allows for real-time monitoring of purchase requests, enabling users to track the progress of their requisitions as they happen. The tool also facilitates the direct addition of assets into the asset register, ensuring that new purchases are recorded accurately and efficiently. With preQ, converting purchase requisitions to purchase orders is simplified, and it is possible to create orders for multiple assets within a single request. The software supports a multi-level approval workflow for purchase requisitions, which can be customized according to different order sizes. Additionally, preQ provides users with a comprehensive view of all expenditures, enhancing financial oversight.

As a service, preQ is utilized for engineering and financial prequalification, particularly aimed at professional services for projects administered by ODOT. It streamlines the process of obtaining and maintaining prequalification for consultants by allowing them to submit financial and engineering/technical information for review. Targeted at companies offering a range of services from program management to architectural related services, preQ does not mandate a CPA-audited indirect cost rate unless the company already possesses one. Moreover, it informs consultants when their cost submittal has been reviewed and provides an approval certificate with an effective date for the new approved indirect cost rate from ODOT.

When referring to data, the PREQ stands for the Postgraduate Research Experience Questionnaire. It is part of a special AGS questionnaire and includes additional questions for research graduates in the GDS version. The PREQ contains a set of attitudinal statements, each with a corresponding five-point scale ranging from ‘strongly disagree’ to ‘strongly agree’. It maintains a consistent set of questions due to the small number of research graduates. The purpose of the PREQ is to gather data on the quality of the higher education research environment for PhD and masters research students. Although not analyzed at a national level, the PREQ provides constructive feedback at the institutional level, which many institutions use to improve the university experience for their students. The software package CEQuery is tailored to analyze the written comments from the open-ended questions of the PREQ.

preQ Plugins for Excel

Compatibility and Installation

preQ plugins for Excel are designed to be compatible with a range of Microsoft Excel versions, specifically 2010, 2013, 2016, 2019, and the Office 365 Excel Desktop Application. However, they do not support the Office 365 Excel Online version. Depending on the scope of the installation, different user privileges are required. Installing the plugin for all users necessitates administrator privileges, while installing it for the current user can be done without such privileges. Prior to installation, it is mandatory to have Microsoft Visual Studio 2010 Tools for Office Runtime and Visual C++ Redistributable for Visual Studio 2015, as they are prerequisites for the plugins' functionality.

Installation Issues and Solutions

Users might encounter a \"trusted publisher\" error, particularly on Windows 10 with Office 2013 32bit systems. This issue requires a specific update to be resolved. For any installation, it is crucial to download and install certain updates and tools from the provided Microsoft links. Moreover, to avoid \"untrusted publisher\" errors, it may be necessary to obtain a certificate from the publisher and install it in the \"Trusted Publishers\" store on the user's machine.

Language and Versioning

The plugins are available exclusively in English and are designed to cater to different Application Lifecycle Management (ALM) versions. Users must ensure that any previous versions of the plugin are uninstalled before installing a new version. Post-installation, instructions for enabling the add-in within Excel are provided, which may include steps for certificate installation or renewal.

Common Use Cases

• P

  
  Use case 1: Automatically updating Excel spreadsheets with data from Dynamics CRM using a Query Expression
• P

  
  Use case 2: Creating a custom button in Dynamics CRM to trigger data transfer to an Excel spreadsheet
• P

  
  Use case 3: Pasting data from CRM into an Excel spreadsheet column by column based on column names
• P

  
  Use case 4: Accessing and modifying an Excel file on a network in a Non-Isolated CRM On-Prem environment
• P

  
  Use case 5: Streamlining the testing process of Excel file manipulation by using a console application before plugin deployment

Frequently Asked Questions

What is the NielsenIQ Discover add-in for Excel?

The NielsenIQ Discover add-in allows current NielsenIQ Discover users to access NielsenIQ data, integrate data from various NielsenIQ Discover sources into one workbook or worksheet, reselect data for queries, and change the layout of their query directly from Excel.

Can I use the NielsenIQ Discover add-in on any operating system?

The NielsenIQ Discover add-in is compatible only with Microsoft Windows 10, 11 (32 & 64 bit) and Mac OS version 12.2.1+.

Is the NielsenIQ Discover add-in free?

The facts provided do not specify whether the NielsenIQ Discover add-in is free or not.

What capabilities does the NielsenIQ Discover add-in offer?

The NielsenIQ Discover add-in offers capabilities such as accessing NielsenIQ data, integrating data from different NielsenIQ sources, reselecting data for queries, and changing the layout of queries directly in Excel.

Do I need to be a NielsenIQ Discover user to use the NielsenIQ Discover add-in?

Yes, the NielsenIQ Discover add-in is for current NielsenIQ Discover users.