Appendices
Appendix 1 Estimating the cost of Chemotherapy
|
Estimation of the Cost of Chemotherapy |
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
30