Economic Evaluation of Positron Emission Tomography (PET) in Non Small Cell Lung Cancer (NSCLC), CHERE Working Paper 2007/6

Appendices

Appendix 1 Estimating the cost of Chemotherapy

Estimation of the Cost of Chemotherapy treat N	for a course of Cisplatin - Vinobrine to SCLC_____________________

Cost per cycle_________________________
Cisplatin__________________________________	3 x $A 61.05 (PBS)
In patient attendances_____________________	_________1 x $A 650 (Rosenthal)_________
Out Patient attendances__________________	_________3x A$ 303.8 Rosenthal_________

Cost Per Course_____________________
Number of Cycles	3
Vinolbrine	$A 3601.44 (PBS)
Drug preparation_______________________	$A 24.2 (Estimation based on HTBS)
Side Effects______________________________	$A 1,100 (Estimation based on HTBS)

Cost per cycle	$A 1,744.6
Cost per course_________________________	$A 9,784.0

Appendix 2: Macro for the 10,000 patient simulations.

Sub simulation_trial()

' simulation_trial Macro

Index = 0

Do While Index < 10000

Range("B5:I5").Select

Selection.Copy

Range("B6:I6").Select

ActiveCell.Offset(Index, 0).Range("A1").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks

:=False, Transpose:=False

Index = Index + 1

Loop

End Sub