Create a Formula for the Front Collar Width
The front collar width is calculated as the sum of the lengths of the following segments:
As the lengths of the diagonal segments only are approximations to the lengths of the curves, they are multiplied additionally by a correction factor.[Collar Width] = x*2*Correction factor+[Cast-off Width at Front Neck]
The value of the correction factor is experience-based and is 1.1.[Collar Width] = x*2*1.1+[Cast-off Width at Front Neck]
-
Calculation of
x
:
x is calculated according to the theorem of Pythagoras.
x² = a²+b²
x = √(a²+b²)
a = [Neck Drop at the Front]
b = ([Neck Width]–[Cast-off Width at Front Neck])/2
x = √([Neck Drop at the Front]²+(([Neck Width]–[Cast-off Width at Front Neck])/2)²) -
Formula of the front collar width:
The final formula of the front collar width results when replacing the calculation of x in the original formula.[Collar Width] = √([Neck Drop at the Front]²+(([Neck Width]–[Cast-off Width at Front Neck])/2)²)*2*1.1+[Cast-off Width at Front Neck]
How to create the formula:
- The Dimensions tool window is open.
- Open the context menu of the Row No. column of the Formula table.
- Select .
- The pop-up window Formula Editor appears.
- Enter the text Front Collar Width as label.
- Click the √() button.
- The entry in the Calculation field is: Sqrt()
- Click the ()² button.
- The entry in the Calculation field is: Sqrt(Pow())
- Select the Neck Drop at the Front dimension in the list box.
- Sqrt(Pow([Neck Drop at the Front],2))
- Click the → button three times.
- The cursor in the Calculation field is positioned before the last ).
- Click the + button.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+)
- Click the ()² button.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(,2))
- Click the () button.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow((),2))
- Select the Neck Width dimension in the list box.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(([Neck Width]),2))
- Click the – button.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(([Neck Width]-),2))
- Select the dependent dimension Cast-off Width at Front Neck in the list box.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(([Neck Width]-[Cast-off Width at Front Neck]),2))
- Click the → button.
- The cursor in the Calculation field is positioned before the text ,2)).
- Click the / and 2 buttons.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(([Neck Width]-[Cast-off Width at Front Neck])/2,2))
- Click the → button enough times to position the cursor in the Calculation field after the last ).
- Click the *, 2, *, 1, . , 1 buttons.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(([Neck Width]-[Cast-off Width at Front Neck])/2,2))*2*1.1
- Click the + button.
- Click the button.
- The entry in the Calculation field is:
Sqrt(Pow([Neck Drop at the Front],2)+Pow(([Neck Width]-[Cast-off Width at Front Neck])/2,2))*2*1.1+[Cast-off Width at Front Neck]
- Confirm with .
- The Formula Editor closes.
- A row with the Front Collar Width formula is added at the bottom of the Formula table.
Additional Information