. 2014 Feb;35(1):37–61.

Table 9.

cFT Monte Carlo simulation (Excel spreadsheet representation).

	A	B	C	D	E	F	G	H

1	Input quantities					Formula		Output

2		T nmol/L	SHBG (S) nmol/L	24.00314	0.04599			cFT pmol/L
3	Value	12.2	36.6	24.00314	0.04599	cFT = 24.00314 ^* T/log(S) − 0.04599 ^*T^2	→	180.5
4	Uncertainty	0.61	1.83	0.2400314	0.0004599
5
6		↓	↓	↓	↓			Trial results
7	Trial #							cFT
8	1	12.259	37.645	24.159836	0.045892	cFT = 24.00314 ^* T/log(S) − 0.04599 ^*T^2	→	181.07
9	2	13.001	35.048	23.765519	0.046060		→	192.24
10	3	12.209	34.061	23.982057	0.045990		→	184.24
11	4	11.421	35.472	23.935677	0.045469		→	170.45
12	5	11.938	37.221	23.981260	0.045930		→	175.72
13	6	12.261	37.897	23.979929	0.046228		→	179.30
14	7	12.068	34.934	23.905895	0.046410		→	180.18
15	8	12.577	38.482	23.873808	0.046113		→	182.12
16	9	12.878	36.382	24.227331	0.045721		→	192.31
17	10	12.249	36.656	23.514162	0.045899		→	177.26
	↓	↓	↓	↓	↓		↓	↓
10007	10000	11.896	34.608	24.165267	0.046522	cFT = 24.00314 ^* T/log(S) − 0.04599 ^*T^2	→	180.18

Spreadsheet representation showing 10,000 simulations of calculated free testosterone (cFT) in column H, for quantity values and uncertainty estimates as described in Table 8. The cFT simulations in column H are derived from the input variables in columns B, C, D and E, rows 8 to 10007:

Column B rows 8 to 10007; (NORMINV(RAND(),$B$3,$B$4)),
Column C rows 8 to 10007; (NORMINV(RAND(),$C$3,$C$4)),
Column D rows 8 to 10007; (NORMINV(RAND(),$D$3,$D$4)),
Column E rows 8 to 10007; (NORMINV(RAND(),$E$3,$E$4)).

The arrows (↓ and →) play no part in the calculations; they have been added to the table for illustrative purposes only.