Training Plan for Administrators > Overhead Workbook

There are two ways to return values:

▪in the Minutes view, from a master column in the Set Sheets or List for Overhead

▪in the Overhead workbook, from Form Controls, which return different values for each position

How to implement in the overhead workbook columns which return values to the Minutes

Tips to avoid recursion

To avoid circular references that QDV7 cannot resolve, it is recommended:

•not to use a cost cell name in a formula for return factor (refer to Defining Return Values)

•when using a free field belonging to selling price, to select either mode Fixed Factors or Calculated Factors (refer to Details on Calculating Modes)

How to take a reference to another sheet: when use VLOOKUP

2nd way: use VLOOKUP to get the plain value from the cell link and WRITE A VARIABLE to create a variable usable in another sheet:

		CONTROL			VLOOKUP		WRITE A VARIABLE
Input range	→	Control	→	Cell link (digit)	→	Plain value	→	Variable
\|___________	______________	_______________	_____________________	_____________________	_________↑
See	Form Controls		Form Controls		Multi-languages sample		Consumption of Variables