Protected Names & Shortcuts |
  
|
Protected Names & Shortcuts |
|
Protected Names
Summary!O3 |
Calculation Modes |
Print_Area |
Printable range of cells in an overhead user sheet |
QDV_System_VisibleArea |
Visible range of cells in an overhead user sheet |
'<Sheet name>'!System_ShowHeader |
Flag indicating that the headers are visible in normal mode in this sheet |
'<Sheet name>'!System_ShowFormulaBar |
Flag indicating that the formula bar is visible in normal mode in this sheet |
QDV_NrSheets |
Count of extra pairs of columns in the List of Articles of a set |
CASH_DATA_Global_Range_... |
Range of the Cash Data sheet |
Throughput |
See Timed Machinery |
QDV_Names is a hidden sheet whose textual values can be referred to in headings when building sheets in the Overhead workbook:
- column A: Core Estimate, Overhead Task, Optional Area, TOTAL CORE ESTIMATE, OVERHEAD, OPTIONAL, ...
- column F: Liabilities, Total Liabilities, Outcome, Total Outcome, ...
- column L: Additional Outcome, Invoicing, Amount, Starting Period, Duration, ...
Do not use GANTT or WBS as the mnemonic of a set of fields.
<USER_NAME> refers to the Windows user name.
Shortcuts for Keyboard
|
ESTIMATE |
|
Shift F3 |
Insert task |
|
Shift F4 |
Insert sub task |
|
Shift F6 |
Delete task or branch |
|
Shift F10 |
Cut task or branch |
|
Shift F11 |
Copy task or branch |
|
Shift F12 |
Paste task or branch |
|
F2 |
Edit a formula without field in the WBS or Minutes view. It shows as a comment * |
How to Empower the Minutes with Quantity Calculation Capabilities |
F2 twice |
Open a window to edit a text cell of the WBS or Minutes view. |
|
F2 (or Alt +Enter) |
Wrap the cell content in WBSs, the view of Minutes and Nomenclatures |
|
Ctrl F |
Find |
|
F3 |
Scroll through matches |
|
F4 |
Condensed WBS-Minutes or Expanded WBS-Minutes or Planner-Minutes back and forth |
Does not work when the Overhead cost minute is used and a field is selected in the view |
|
In Overhead workbook: repeats the latest context selection Condensed WBS/Expanded WBS/BoQ |
|
|
Show minute |
|
|
Switch from absolute to relative referencing ($ in formula’s) |
|
F5 |
Compute Costs |
|
Shift F5 |
Refresh data |
|
Ctrl F5 |
Compute all |
|
F6 |
Group rows in the Minutes view |
|
F7 |
Ungroup rows in the Minutes view |
|
F10 |
Hide/Show group details in the Minutes view |
|
Ctrl F6 |
Create a set or increase its depth in the Minutes view |
|
Ctrl F7 |
Remove a set or decrease its depth the Minutes view |
|
Ctrl K |
Copy minutes to whole estimate |
|
F12 |
Summarize selection |
|
Ctrl F12 |
Summarize whole estimate |
|
Ctrl + Shift + |
Open ... |
|
F1 |
Condensed WBS |
|
F7 |
Planner |
|
F8 |
Reports |
|
Shift F8 |
Insert reference from estimate |
|
|
|
|
|
DATABASES |
|
Ctrl A |
Open database manager |
|
Ctrl G |
Open preferential database(s) |
|
Ctrl <ten>,release, <unit> |
Open a preferential database from a mini-index with more than 10 databases |
|
F7 |
Insertion above into the Minutes view from the articles viewer |
How to Insert an Article or a Set into a Section of Minutes, How to Replace Article Rows, Nested Sets |
F8 |
Insertion and replacement of an article selected in the articles viewer |
|
Ctrl W |
Update of article from database using a reference |
|
Ctrl P |
Update of article from database using a prefix + a reference |
|
|
|
|
F11 |
Glossary |
|
Ctrl+Shift F11 |
Add bookmark |
|
Ctrl F11 |
Open bookmark list |
|
* when you edit a cell with a double click or the F2 key, QDV7 evaluates the formula stored in the comment:
▪if the result equals the displayed figure, the formula is edited
▪else, the value is edited instead.
Shortcuts for Paths
In Settings, How to Create & Manage the Databases and Built-in Function Button, you can use these shortcuts: <PROFILE_PATH>, <TEMP_PATH>, <DESKTOP_PATH>, <MY_DOCUMENTS_PATH>, <INSTALL_PATH> or <CUSTOM_PATH>.
<CUSTOM_PATH> refers to the path in the first line of the CustomPathVariable.inf file, which must be located either in the installation folder or in the C:\Users\Home\AppData\Roaming\QDV path. Restart QDV7 for this path to be evaluated.