Arte SheetsLearn. Try. Understand.

Oncology Pharmacy & Clinical Pharmacokinetics

Calvert Carboplatin Research and Capped Inputs: A Spreadsheet Exercise

Understand the context of Calvert carboplatin research and practice a separate, fictional capped-input calculation.

Understand the clinical context

Calvert and colleagues studied the relationship between carboplatin clearance, kidney function and drug exposure. BC Cancer describes a commonly used adult Calvert expression as total dose in mg = target AUC × (GFR + 25), with kidney function in mL/min. Selection of target exposure and the method of assessing renal function depend on the clinical protocol and patient.

BC Cancer distinguishes measured kidney function from estimated GFR or calculated creatinine clearance, and specifies a 125 mL/min cap for those estimates when calculating the initial dose in its protocol. Do not assume a cap is applicable to every measurement or setting, or that the difference between capped and uncapped amounts proves toxicity was avoided. A trained oncology team must follow the applicable protocol and verify treatment decisions.

A separate fictional spreadsheet exercise

The following numbers and units are invented. This example demonstrates a spreadsheet cap; it is not a carboplatin dose, a vial calculation, or a clinical tool. Enter a multiplier in B2, an input in B3, a ceiling in B4 and an offset in B5. The formula requires four nonnegative numbers and caps the input using MIN.

With 8, 150, 120 and 20, the calculation is 8 × (120 + 20) = 1,120 fictional units. Changing the input to 100 gives 960. If an input is blank or text, the formula asks for numeric values instead of silently treating a missing value as zero.

InputCellExample value
MultiplierB28
InputB3150
CeilingB4120
OffsetB520
=IF(COUNT(B2:B5)<>4,"Enter four numeric values",IF(OR(B2<0,B3<0,B4<0,B5<0),"Enter nonnegative values",ROUND(B2*(MIN(B3,B4)+B5),2)))

How to use the references

For drug dosing and preparation, consult the current drug monograph and the protocol applicable to the individual patient. The worksheet below is intentionally limited to generic arithmetic; it cannot establish a safe dose or replace oncology pharmacy review.

Try the example

Use the original values or change them to test your understanding.

Further reading