User Profiles (Administrators only)

Navigation:  Security >

User Profiles (Administrators only)

Previous pageReturn to chapter overviewNext page

Preamble

QDV7 can work either connected or disconnected.

Each estimate or database is used by various users enrolled in implicit groups (the users that share a password) or NT groups of an active directory.

A profile, attached to the estimate or database, features each of their groups.

To use a profile, two identification types are offered depending on the kind of groups:

Implicit group: name and password stored with the estimate or database

NT group which uses Windows authentication.

The second option is safer as no password is handled. Refer to Cybersecurity.

 

NOTE  If the user belongs to more than one authorized NT group, a QDV7 dialog box calls for profile selection.

 

A profile includes:

General Settings: list of particular functions (mainly in Home, View and Automation bars) purposely available to a group

Permissions: lower-level capacity granted to the users group to view sheets (including free sets) or write to specific columns

To avoid defining a profile for each new estimate, assign the profile to a template estimate or include profiles in the import (refer to How to Import Data). Usually two administrators, with the same profile, are entitled to define profiles:

The IT manager (technical administrator) creates one or more estimates and declares them as templates using File>Tools>New Estimate Settings (refer to How to Create an Estimate); to handle this, s/he had better use ProMo+ or a management database

The project manager (executive administrator) tailors the rights to the project's needs.

 

Tool: bar Administration, group Configuration>Permissions

 

Configuration

 

Loading settings is subjected to specific restrictions (refer to How to Import Data) i.e. only an administrator can import profiles, and items mentioned in the following table, that sums up the rules:

Sheets (permissions)

WBS, Minutes

Overhead

Reports

Functions (general settings)

depending on general settings and permissions

Automation>Load settings

Header row color, rounding of selling price, layout: administrator only

Entire workbook & Currencies: administrator only

 

Administration

Administrator only

Free switchover to Edit mode

Administration>Permissions

Administrator only

 

Editing a Profile

From the list of profiles, whether you create a new profile (Add) or view/modify an existing or cloned profile (Edit or double click the row):

1.In the Profile info, enter/modify at least the Profile ID and Profile name; enter a password (that will be asked when such a user opens or saves the estimate) or double click the placeholder NT Group to select a group in the active directory

2.In the General settings list, delete the x of settings that are not desired, double click the cell where the setting is desired (not applicable to the administrator him/herself)

3.In Tabs & Sheets & Columns, delete the x of features that are not desired either on the sheet level (Overhead only) or on the column (or parent column) level; the Editable column is mainly intended for non administrator profiles, which have no Edit mode.

 

GENERAL SETTINGS

Some settings are set globally (cross-user settings), others are set on a per profile basis or a per user basis:

Stored in the estimate ...

Permission needed

No permission needed

Globally

Database (preferential and settings tabs)

Options (display, editing)

VAT rate and display

Overhead report page settings

Options (settings)

The default user profile on estimate opening

On a per profile basis

All the settings listed in next table except above settings

Zoom levels

Most View tab settings( except VAT)

Minutes view & Nomenclatures formatting

Report page settings (except Overhead)

Options in the Update rows (in whole estimate) dialog boxes

On a per user basis

All the other settings NOT listed in this table nor in the next one

 

These settings rule out the availability of some menus and controls:

Save password to user profile

by default, the user leaves his/her password (including the logged administrator!)

Breakdown

View>Breakdown

Summary

Links

Automation>Links

Numbering

Home>Navigate>Numbering

How to Number the Structural View

Prefix

Data>Databases>Set Prefixes Definitions

Prefixes

Scenario

Automation>Target Values

Target

Sharing

Automation>Sharing

Task Sharing

Technical documentation

Data>Word

Publishing

Editing of technical documentation

if denied, you can only see the selected template name

Publishing

Versions

View>Version index>Select Version>buttons

How to Manage the Versions

Forced selling in WBS/Minutes

box Home>Compute>Forced

Forced Prices

corresponding menu items Remove Forced Values and Force All Selling Prices

Set as option

box Home>Compute>Option

Bottom Area

Set as 'by total'

box Home>Compute>Total

Total Mode

Global variables

Automation>Formulas>Global variables (unavailable in Reports)

Global Variables

Push data to management database

Automation>Database Management

How to Update an Estimate

Run Macros

Automation>Macros

Macros

Edit Macros

 

Run Requests

Automation>Requests

Requests

Edit Requests

 

Edit Events

Automation>Events Management

Events Management

Excel Macros

Automation>Macros

Macros

Additional Features (Built-in Macros)

Automation>Macros>Additional Features

Built-in Function Button

Edit bottom panes (minutes et nomenclatures)

Risk: exposition of any field

How to Build the Bottom Panes

Partner Applications

Automation>Partner Applications

Comparison with a Top-Down Method, How to Import a Bill Of Materials

Export overhead with formulas

Data>Microsoft Excel>Excel>Export with Formulas

Export to Excel

Rounding

File>Options>Rounding

Rounding in Minutes, Rounding in WBS

 

 

 

Database settings stored in estimate

Those in Preferential and Setting tabs

How to Create an Empty Database of Sets

Display options

 

How to Change the WBS View

Editing options

 

Configuration

VAT rate and display

Possibility of display or not at the WBS bottom via View>Show

Bottom Area, Calculation Options

Create and Edit distribution curves

Possibility of creation, edition and deletion of distribution curves

Custom Distribution Curves

Store page settings for printing

Possibility of storing the page settings in a central manner (settings depend on the page to print)

Estimates

Import free overhead sheets

The imported sheets are editable and visible in the target estimate

How to Import Data

Allow editing analytical reports & data sources

Gives access to the whole menu View>Analytics (not only View Reports)

Analytical Reports

 

NOTES

- By default, the modification of rounding rules is NOT permitted

- Defining a profile without password makes sense when you want to work in a safe manner, i.e. with restrictions

 

TABS & SHEETS & COLUMNS

- A profile created by the button Add enjoys by default all the privileges

- The features that cannot be changed are grayed; in particular the Definitions (ID and Name columns) are mandatorily visible

- To grant access to Edit mode to non administrators, check the columns Editable on sheet level (BoQ) or tab level (Reports); the other tabs do not permit Edit mode

- Minutes: free columns are mentioned provided they are inserted into the Minutes view; a cell in the Visible, Editable and Formatting columns can be grayed regardless of the profile because of a Field Manager attribute  

- Overhead workbook:

some "columns" are in fact cells: 'default' refers to the default kind Id or to the Currency of the estimate  

the native editable columns show in green (the administrator may need to switch to edit mode and back to normal)

Definition = Name

a column Defining Return Values can be editable; it shows under the name of the user column in the section of the set of columns

in Summary sheet, where all data are calculated, the editability concerns the drop-down lists

in the planner data sheet, it has no use

for users sheets, it governs only the capacity to switch to Edit mode, hence the right to Edit in Excel. (Refer to Locking Cells in a User Overhead Sheet.)

 

- Reports: the invisible columns will show hatched; to prevent editing of the report profiles (refer to Reports), uncheck the cell in the column Editable

- The row handling (insertion, deletion, move in WBS and Minutes) is allowed on tab level, except for the Free Bottom Area of the Expanded WBS

- Formatting is detailed in Cell Format; column formatting permissions are stored on a per profile basis (and not user basis)

 

Permissions

 

Common to Minutes and Expanded WBS:

- Workbook column is always visible; if not editable, the workbook can still be opened (but not edited) ; however, cells which are not locked can still be edited. (By default all cells are locked.)

- Word document column is always visible; if not editable, the Word document can still be opened and edited in MS Word, but the edited document cannot be re-imported

warning By default, there is no password attached to the administrator.

warning For reports, refer to the warning in Locking Reports Profiles.

 

By reopening an estimate, an administrator can define the default profile thru a drop-down list.

 

More on this What Does the User Profile Include

 

NT Group

When a user belonging to an NT group attempts to open the estimate, s/he is automatically identified and the estimate opens with the corresponding profile. S/he doesn’t have to enter any password.

When two profiles belong to the same NT Group, QDV7 prompts the user to select a profile among allowed profiles for this NT Group.

When the user belongs to several NT Groups which are listed in the estimate, a similar message pops up.