{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Cover","Introduction","Chemotherapy Pathway","Treatment Plan","Pharmacy Capacity","Nurse Capacity","Chair Capacity","drug regimen","Pathway Results","Results Table","Local Assumptions","Pharmacy References","Activity Tariffs","Tariff Information"],"not_rendered":{"charts":0,"images":101,"macros":1,"external_links":0,"defined_names":20,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"This tool was developed by the NECN and GSK on behalf of the Pharmaceutical Industry Partnership Group (PIPG)"]

{"sheet":"Introduction","index":1,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,2,23,10],[14,3,15,13],[1,3,1,9],[7,3,7,9],[17,2,17,10],[18,2,18,10],[19,2,19,10],[20,2,20,10]]}
[]
[null,null,null,"New Drug Capacity Calculator"]
[]
[]
[]
[]
[]
[null,null,null,"Click on the blue buttons below to navigate to the specific page of the New Drug Capacity Calculator."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"The draft NHS standard specification template for adult systemic anti-cancer therapy services (December 2012)1 specifies that the pathway of care for any chemotherapy patient will need to ensure that the provider services have capacity (in terms of oncology pharmacists and technical pharmacy staff and chairs) for checking prescriptions, reconstitution, and deliver of chemotherapy drugs."]
[null,null,"1Draft NHS Standard specification template for adult systemic anti-cancer therapy services, December 2012"]
[null,null,"https://www.engage.england.nhs.uk/consultation/ssc-area-b/supporting_documents/b3lservicespec.pdf"]
[null,null,"Accessed January 2015"]
[]
[]
[null,null,"Costs and savings figures used in the model are for illustrative purposes only and the user's attention is drawn to the fact that outputs from the model are subject to a) the assumptions described within the model and b) the data that the user selects or decides to input into the model. GSK and NHS England accept no liability for losses arising, directly or indirectly, from the use of the model or its output.  GSK and NHS England make no representation or warranty as to the suitability of the output of the model for any particular purpose."]

{"sheet":"Chemotherapy Pathway","index":2,"n_rows":64,"n_cols":30,"rows_kept":64,"cut":false,"hidden":false,"merged":[[51,4,51,15],[53,4,53,16],[5,3,7,32],[1,1,1,7],[42,29,42,33],[3,1,3,12],[42,3,44,9],[41,20,41,27],[42,20,42,27],[41,4,41,8],[41,29,41,33],[63,2,63,21],[57,2,57,26],[58,2,58,21],[59,2,59,21],[61,2,61,21],[62,2,62,21]]}
[]
[null,"CHEMOTHERAPY PATHWAY*"]
[]
[null,"For information only, no data input required on this sheet"]
[]
[null,null,null,"The New Drug Capacity Calculator estimates pharmacy capacity (staff  and isolator time), oncology nurse capacity and oncology chair time associated with treating a cohort of patients with a new regimen of cancer drugs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Calculate pharmacy capacity\n (isolator time and WTE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate oncology nurse capacity",null,null,null,null,null,null,null,null,"Calculate oncology chair time"]
[]
[]
[]
[]
[null,null,"WTE = Whole Time Equivalent"]
[]
[null,null,"Key"]
[]
[null,null,null,null,"Areas of the pathway where capacity will be calculated"]
[]
[null,null,null,null,"Areas of the pathway that will NOT be included in the capacity calculations"]
[]
[]
[]
[null,"*","Sample pathway as described in the draft NHS standard specification template for adult systemic anti-cancer therapy services, December 2012."]
[null,null,"https://www.engage.england.nhs.uk/consultation/ssc-area-b/supporting_documents/b3lservicespec.pdf"]
[null,null,"Accessed January 2015"]
[]
[null,null,"For current service specification  refer to NHS England Chemotherapy CRG webpage. "]
[null,null,"http://www.england.nhs.uk/commissioning/spec-services/npc-crg/group-b/b15/  "]
[null,null,"Acessed January 2015"]

{"sheet":"Treatment Plan","index":3,"n_rows":44,"n_cols":49,"rows_kept":44,"cut":false,"hidden":false,"merged":[[5,5,5,11],[6,5,6,11],[3,7,3,10],[7,34,7,36],[7,43,7,48],[7,7,8,11],[9,29,9,30],[40,5,40,11],[41,7,41,8],[36,7,36,8],[36,5,36,6],[36,9,36,10],[41,9,41,10],[35,9,35,10],[28,7,28,8],[42,7,43,8],[42,5,43,6],[7,2,7,3],[11,3,17,3],[20,3,26,3],[28,2,28,3],[34,5,34,11],[42,9,42,10],[43,9,43,10]]}
[]
[null,null,null,"CALCULATE CHEMOTHERAPY DELIVERY TIME FOR COHORT OF PATIENTS FOR ONE YEAR"]
[]
[null,null,null,null,null,null,null,"Detailed treatment plan (per patient)"]
[]
[null,null,null,null,null,"Step 1: Select, drug type, route, infusion type and times using the drop-down buttons"]
[]
[null,null,"Is Cycle 1 different?",null,null,null,null,"If Cycle 1 is different from subsequent cycles select \"Yes\" and complete Tables 1a and 1b.  \nIf Cycle 1 is the same as subsequent cycles select \"No\" and  complete Table 1b only.\nSelect \"No\" to set the  totals  in Table 1a to zero.\n",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To be hidden in final version",null,null,null,null,null,null,null,null,"LINKED CELLS"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To be hidden in final version"]
[null,null,null,null,null,"Table 1a","Drug type","Route","Infusion type","Infusion \ntime (mins)","Observation \ntime (mins)","Administrations \nper cycle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infusion Time","Observation time",null,null,null,"Cycle","Drug Type","Route","Infusion Type","Infusion Time","Observation Time",null,null,null,"Cycle","Drug Type","Route","Infusion Type","Infusion Time","Observation Time"]
[null,null,null,"First Cycle",null,"Drug 1",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS12=\"Oral\",AV12*0,IF(AS12=\"None\",AV12*0,IF(AS12=\"Select type\",AV12*0,IF(AT12=\"Oral\",AV12*0,IF(AT12=\"None\",AV12*0,IF(AT12=\"Select route\",AV12*0,IF(AU12=\"None\",AV12*0,IF(AU12=\"Select type\",AV12*0,IF(AU12=\"Not Applicable\",AV12*0,AV12)))))))))","v":"60"},{"$f":"IF(AS12=\"None\",AW12*0,IF(AS12=\"Select type\",AW12*0,IF(AT12=\"None\",AW12*0,IF(AT12=\"Select route\",AW12*0,IF(AU12=\"None\",AW12*0,IF(AU12=\"Select type\",AW12*0,AW12))))))","v":"30"},null,null,null,"Yes","Select type","Select route","Select type",0,0,null,null,null,"Yes","MAB","IV Infusion","Infusion bag","60","30"]
[null,null,null,null,null,"Drug 2",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS13=\"Oral\",AV13*0,IF(AS13=\"None\",AV13*0,IF(AS13=\"Select type\",AV13*0,IF(AT13=\"Oral\",AV13*0,IF(AT13=\"None\",AV13*0,IF(AT13=\"Select route\",AV13*0,IF(AU13=\"None\",AV13*0,IF(AU13=\"Select type\",AV13*0,IF(AU13=\"Not Applicable\",AV13*0,AV13)))))))))","v":"90"},{"$f":"IF(AS13=\"None\",AW13*0,IF(AS13=\"Select type\",AW13*0,IF(AT13=\"None\",AW13*0,IF(AT13=\"Select route\",AW13*0,IF(AU13=\"None\",AW13*0,IF(AU13=\"Select type\",AW13*0,AW13))))))","v":"30"},null,null,null,"No","None","None","None",5,15,null,null,null,"Yes","MAB","IV Infusion","Infusion bag","90","30"]
[null,null,null,null,null,"Drug 3",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,"MAB","Oral","Infusion bag",10,30,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Drug 4",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,"Oral","Sub-cut","Ready made infusion bag",15,45,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Drug 5",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,"IV","IV Bolus","Syringe",30,60,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Drug 6",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,"IV Infusion","Ready made syringe",45,90,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Time for first cycle",null,null,null,{"$f":"AD19","v":150},{"$f":"AE19","v":60},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AD12*L12)+(AD13*L13)+(AD14*L14)+(AD15*L15)+(AD16*L16)+(AD17*L17)","v":150},{"$f":"(AE12*L12)+(AE13*L13)+(AE14*L14)+(AE15*L15)+(AE16*L16)+(AE17*L17)","v":60},null,null,null,null,null,"Intrathecal","Not Applicable",60,120]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR12 =\"No\", AD18*0, AD18)","v":150},{"$f":"IF(AR12=\"No\",AE18*0,AE18)","v":60},null,null,null,null,null,"Intramuscular",null,90,150]
[null,null,null,null,null,"Table 1b",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,180]
[null,null,null,"All or\nSubsequent Cycles",null,"Drug 1",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AS21=\"Oral\",AV21*0,IF(AS21=\"None\",AV21*0,IF(AS21=\"Select type\",AV21*0,IF(AT21=\"Oral\",AV21*0,IF(AT21=\"None\",AV21*0,IF(AT21=\"Select route\",AV21*0,IF(AU21=\"None\",AV21*0,IF(AU21=\"Select type\",AV21*0,IF(AU21=\"Not Applicable\",AV21*0,AV21)))))))))","v":"60"},{"$f":"IF(AS21=\"None\",AW21*0,IF(AS21=\"Select type\",AW21*0,IF(AT21=\"None\",AW21*0,IF(AT21=\"Select route\",AW21*0,IF(AU21=\"None\",AW21*0,IF(AU21=\"Select type\",AW21*0,AW21))))))","v":"30"},null,null,null,null,null,null,null,150,240,null,null,null,null,"MAB","IV Infusion","Infusion bag","60","30"]
[null,null,null,null,null,"Drug 2",null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30","0",null,null,null,null,null,null,null,180,300,null,null,null,null,"MAB","IV Infusion","Infusion bag","30","0"]
[null,null,null,null,null,"Drug 3",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,240,360,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Drug 4",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,300,null,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Drug 5",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,360,null,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Drug 6",null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"None","None","None","0","0"]
[null,null,null,null,null,"Time per cycle for all/ subsequent cycles",null,null,null,{"$f":"AD28","v":90},{"$f":"AE28","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AD21*L21)+(AD22*L22)+(AD23*L23)+(AD24*L24)+(AD25*L25)+(AD26*L26)","v":90},{"$f":"(AE21*L21)+(AE22*L22)+(AE23*L23)+(AE24*L24)+(AE25*L25)+(AE26*L26)","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR13 =\"No\", AD27*0, AD27)","v":90},{"$f":"IF(AR13=\"No\",AE27*0,AE27)","v":30}]
[null,null,"Sum the values in table 1b?",null,null,null,null,"Select  \"No\" to  set the totals in Table 1b to zero.\n"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Step 2: Individualise treatment plan for one patient"]
[null,null,null,null,null,"Table 2",null,null,null,"Total time per patient (hours)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of cycles"]
[null,null,null,null,null,"Enter planned number of cycles",null,18,null,{"$f":"(AD37*(J27+K27)+(J18+K18))/60","v":37.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AR12=\"No\",planned_cycle,(planned_cycle-1))","v":17}]
[]
[]
[]
[null,null,null,null,null,"Step 3. Chemotherapy delivery time for cohort"]
[null,null,null,null,null,"Table 3",null,null,null,"Total time for cohort"]
[null,null,null,null,null,"Enter number of patients to be treated per year",null,25,null,{"$f":"H43*J37","v":937.5},null,"hours"]
[null,null,null,null,null,null,null,null,null,{"$f":"J43/'Local Assumptions'!D7","v":125},null,"days"]

{"sheet":"Pharmacy Capacity","index":4,"n_rows":40,"n_cols":37,"rows_kept":40,"cut":false,"hidden":false,"merged":[[3,1,3,8],[9,9,9,11],[36,1,36,5],[30,1,30,5],[35,1,35,5],[6,1,6,2],[24,1,24,2],[32,1,32,2],[16,1,16,2],[11,1,11,2],[6,4,6,8],[11,4,11,8],[16,4,16,8],[24,4,24,8],[32,4,32,8]]}
[]
[null,"CALCULATE PHARMACY CAPACITY"]
[]
[null,"Time in the white box for isolator cleaning time can be changed by overtyping, times in the \"Variable time\" column can be changed using the drop-down buttons. Fixed times and Whole Time Equivalent (WTE) times can be modified by clicking on the hyperlinks below. No other figures should be changed on this sheet."]
[]
[null,"Type of Item/activity","Number of cycles","Quantity for cohort","Fixed time/ item (min)","Variable time /item (min)","Total time \n(hours)","Staff time \n(WTE days)","Isolator time (days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To be Hidden in final model",null,null,null,"Column F "]
[null,"PRESCRIPTION VERIFICATION/REVIEW",null,null,"Step 1 - Select times for prescription verification/review",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Linked cells"]
[null,"Cycle 1 prescription verification/review",1,{"$f":"'Treatment Plan'!no_of_patients","v":25},"N/A",null,{"$f":"(D8*AK8)/60","v":6.25},{"$f":"G8/'Local Assumptions'!D31","v":1.1574074074074074},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15"]
[null,"Subsequent cycles prescription verification/review",{"$f":"'Treatment Plan'!planned_cycle-1","v":17},{"$f":"'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients-'Pharmacy Capacity'!D8","v":425},"N/A",null,{"$f":"(D9*AK9)/60","v":56.666666666666664},{"$f":"G9/'Local Assumptions'!D31","v":10.493827160493826},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prescription and checks","Manufacturing",null,null,null,"8"]
[null,"TOTAL TIME FOR PRESCRIPTION VERIFICATION/ REVIEW FOR THE COHORT",null,null,null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!G8:G9)))","v":62.916666666666664},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!H8:H9)))","v":11.651234567901234},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,5]
[null,"ADDITIONAL CHECKS",null,null,"Step 2 - Select time for additional checks",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,10]
[null,"Check blood tests",{"$f":"'Treatment Plan'!planned_cycle","v":18},{"$f":"'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients","v":450},"N/A",null,{"$f":"(D13*AK13)/60","v":0},{"$f":"G13/'Local Assumptions'!D31","v":0},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,15,null,null,null,"0"]
[null,"Other checks",{"$f":"'Treatment Plan'!planned_cycle","v":18},{"$f":"'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients","v":450},"N/A",null,{"$f":"(D14*AK14)/60","v":0},{"$f":"G14/'Local Assumptions'!D31","v":0},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,25,null,null,null,"0"]
[null,"TOTAL TIME FOR ADDITIONAL CHECKS FOR COHORT",null,null,null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!G13:G14)))","v":0},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!H13:H14)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,45]
[null,"MANUFACTURING - CYCLE 1",null,null,"Step 3 - Select time for manufacturing each item - Cycle 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,60]
[null,"Infusion bag",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle*0,1)","v":1},{"$f":"SUMIF('Treatment Plan'!$AU$12:$AU$17,\"Infusion bag\",'Treatment Plan'!$L$12:$L$17)*C18*'Treatment Plan'!no_of_patients","v":50},{"$f":"'Pharmacy References'!F13","v":34},null,{"$f":"(((E18+AK18)*D18)+(IF(D18<>0,($G$34*1/'Treatment Plan'!planned_cycle),0)))/60","v":53.334135802469142},{"$f":"G18/'Local Assumptions'!$D$31","v":9.8766918152720624},{"$f":"G18/7.5","v":7.111218106995886},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,75,null,null,null,"30"]
[null,"Syringe",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle*0,1)","v":1},{"$f":"SUMIF('Treatment Plan'!$AU$12:$AU$17,\"Syringe\",'Treatment Plan'!$L$12:$L$17)*C19*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F24","v":24},null,{"$f":"(((E19+AK19)*D19)+(IF(D19<>0,($G$34*1/'Treatment Plan'!planned_cycle),0)))/60","v":0},{"$f":"G19/'Local Assumptions'!$D$31","v":0},{"$f":"G19/7.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,90,null,null,null,"0"]
[null,"Ready made syringe",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle*0,1)","v":1},{"$f":"SUMIF('Treatment Plan'!$AU$12:$AU$17,\"Ready made syringe\",'Treatment Plan'!$L$12:$L$17)*C20*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F31","v":15},null,{"$f":"((E20+AK20)*D20)/60","v":0},{"$f":"G20/'Local Assumptions'!$D$31","v":0},{"$f":"G20/7.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,120,null,null,null,"0"]
[null,"Ready made infusion bag",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle*0,1)","v":1},{"$f":"SUMIF('Treatment Plan'!$AU$12:$AU$17,\"Ready made infusion bag\",'Treatment Plan'!$L$12:$L$17)*C21*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F31","v":15},null,{"$f":"((E21+AK21)*D21)/60","v":0},{"$f":"G21/'Local Assumptions'!$D$31","v":0},{"$f":"G21/7.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,null,null,null,"0"]
[null,"Oral",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle*0,1)","v":1},{"$f":"SUMIF('Treatment Plan'!AT12:AT17,\"Oral\",'Treatment Plan'!L12:L17)*C22*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F37","v":10},null,{"$f":"(((E22+AK22)*D22))/60","v":0},{"$f":"G22/'Local Assumptions'!$D$31","v":0},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,null,null,null,"0"]
[null,"TOTAL MANUFACTURING TIME FOR CYCLE 1 ",null,null,null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!G18:G22)))","v":53.334135802469142},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!H18:H22)))","v":9.8766918152720624},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!I18:I21)))","v":7.111218106995886}]
[]
[null,"MANUFACTURING - ALL/SUBSEQUENT CYCLES",null,null,"Step 4 - Select time for manufacturing each item  - all/subsequent cycles)"]
[null,"Infusion bag",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle,('Treatment Plan'!planned_cycle-1))","v":17},{"$f":"SUMIF('Treatment Plan'!$AU$21:$AU$26,\"Infusion bag\",'Treatment Plan'!$L$21:$L$26)*C26*'Treatment Plan'!no_of_patients","v":850},{"$f":"'Pharmacy References'!F13","v":34},null,{"$f":"(((E26+AK26)*D26)+(IF(D26<>0,($G$34*C26/'Treatment Plan'!planned_cycle),0)))/60","v":906.68030864197533},{"$f":"G26/'Local Assumptions'!$D$31","v":167.90376085962504},{"$f":"G26/7.5","v":120.89070781893004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30"]
[null,"Syringe",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle,('Treatment Plan'!planned_cycle-1))","v":17},{"$f":"SUMIF('Treatment Plan'!$AU$21:$AU$26,\"Syringe\",'Treatment Plan'!$L$21:$L$26)*C27*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F24","v":24},null,{"$f":"(((E27+AK27)*D27)+(IF(D27<>0,($G$34*C27/'Treatment Plan'!planned_cycle),0)))/60","v":0},{"$f":"G27/'Local Assumptions'!$D$31","v":0},{"$f":"G27/7.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Ready made syringe",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle,('Treatment Plan'!planned_cycle-1))","v":17},{"$f":"SUMIF('Treatment Plan'!$AU$21:$AU$26,\"Ready made syringe\",'Treatment Plan'!$L$21:$L$26)*C28*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F31","v":15},null,{"$f":"((E28+AK28)*D28)/60","v":0},{"$f":"G28/'Local Assumptions'!$D$31","v":0},{"$f":"G28/7.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Ready made infusion bag",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle,('Treatment Plan'!planned_cycle-1))","v":17},{"$f":"SUMIF('Treatment Plan'!$AU$21:$AU$26,\"Ready made infusion bag\",'Treatment Plan'!$L$21:$L$26)*C29*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F31","v":15},null,{"$f":"((E29+AK29)*D29)/60","v":0},{"$f":"G29/'Local Assumptions'!$D$31","v":0},{"$f":"G29/7.5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Oral",{"$f":"IF('Treatment Plan'!$AR$12=\"No\",'Treatment Plan'!planned_cycle,('Treatment Plan'!planned_cycle-1))","v":17},{"$f":"SUMIF('Treatment Plan'!AT21:AT26,\"Oral\",'Treatment Plan'!L21:L26)*C30*'Treatment Plan'!no_of_patients","v":0},{"$f":"'Pharmacy References'!F37","v":10},null,{"$f":"(((E30+AK30)*D30))/60","v":0},{"$f":"G30/'Local Assumptions'!$D$31","v":0},"N/A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"TOTAL MANUFACTURING TIME FOR ALL/SUBSEQUENT CYCLES",null,null,null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!G26:G30)))","v":906.68030864197533},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!H26:H30)))","v":167.90376085962504},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM('Pharmacy Capacity'!I26:I29)))","v":120.89070781893004}]
[]
[null,"ISOLATOR CLEANING ",null,null,"Step 5 - Review time assigned for cleaning isolator(s)*"]
[null,"Isolator cleaning time","N/A",1,{"$f":"'Pharmacy References'!F44","v":52},"N/A",{"$f":"(D34*E34)/60","v":0.8666666666666667},"N/A","N/A"]
[]
[null,"TOTAL PHARMACY RESOURCE REQUIREMENTS FOR THE COHORT",null,null,null,null,{"$f":"G10+G15+G23+G31","v":1022.9311111111111},{"$f":"H10+H15+H23+H31","v":189.43168724279832},{"$f":"I23+I31","v":128.00192592592592}]
[null,"*Isolator cleaning time is applied to infusion bags and syringes only."]
[]
[null,"N/A = Not Applicable"]
[null,"WTE = Whole Time Equivalent"]

{"sheet":"Nurse Capacity","index":5,"n_rows":40,"n_cols":37,"rows_kept":40,"cut":false,"hidden":false,"merged":[[44,1,44,3],[11,1,11,3],[13,1,13,2],[37,1,37,2],[38,1,38,3],[23,1,23,2],[23,3,23,5],[18,1,18,2],[18,3,18,5],[13,3,13,5],[28,7,28,9],[39,1,39,3],[43,1,43,3],[3,1,3,5],[36,1,36,5],[31,1,31,5],[32,3,32,5],[6,3,6,5],[21,1,21,2],[16,1,16,3],[6,1,6,2],[32,1,32,2]]}
[]
[null,"CALCULATE NURSE CAPACITY"]
[]
[null,"Times in the \"Time/cycle/patient\" column can be changed using the drop-down buttons.  Whole Time Equivalent  (WTE) times can be modified by clicking on the hyperlink below. No other figures should be changed on this sheet."]
[]
[null,"Type of Item/activity","Quantity/patient","Time /cycle/patient for regimen (min)","Total time for cohort (hours)","Staff resource\n (WTE days)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select type","Infusion bag","Syringe","Ready made syringes",null,"To be hidden in final version",null,null,null,null,"Column D"]
[null,"CLINICAL REVIEW (NOT INCLUDED IN CHAIR TIME)",null,"    Step 1  - Select times for the following clinical review activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checks and Prep times","Drug admin times",null,null,null,"Linked cells"]
[null,"Check blood tests","N/A",null,{"$f":"(AK8*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":37.5},{"$f":"E8/'Local Assumptions'!$D$31","v":6.9444444444444438},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,null,"5"]
[null,"Administrative tasks","N/A",null,{"$f":"(AK9*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":75},{"$f":"E9/'Local Assumptions'!$D$31","v":13.888888888888888},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,1,null,null,null,"10"]
[null,"Pre-chemo assessment","N/A",null,{"$f":"(AK10*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":75},{"$f":"E10/'Local Assumptions'!$D$31","v":13.888888888888888},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2,null,null,null,"10"]
[null,"Other clinical assessments","N/A",null,{"$f":"(AK11*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":37.5},{"$f":"E11/'Local Assumptions'!$D$31","v":6.9444444444444438},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,3,null,null,null,"5"]
[null,"Total times for clinical review ",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(E8:E11)))","v":225},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(F8:F11)))","v":41.666666666666664},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,5]
[null,"ADDITIONAL CHECKS/PREPARATION (NOT INCLUDED IN CHAIR TIME)",null,"    Step 2 - Select combined time for activities",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,6]
[null,"Cycle 1","N/A",null,{"$f":"IF('Treatment Plan'!$AR$12=\"No\",0,(AK15*'Treatment Plan'!no_of_patients)/60)","v":0},{"$f":"E15/'Local Assumptions'!D31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,8,null,null,null,"0"]
[null,"Subsequent cycles","N/A",null,{"$f":"IF('Treatment Plan'!$AR$12=\"No\", (AK16*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60,(AK16*('Treatment Plan'!planned_cycle-1)*'Treatment Plan'!no_of_patients)/60)","v":0},{"$f":"E16/'Local Assumptions'!D31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,10,null,null,null,"0"]
[null,"Total times for additional checks/preparations that do not use chair time",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(E15:E16)))","v":0},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(F15:F16)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,14]
[null,"PATIENT & EQUIPMENT CHECKS/PREPARATION (INCLUDED IN CHAIR TIME)\n",null,"    Step 3 - Select combined time for this type of activity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,15]
[null,"Cycle 1","N/A",null,{"$f":"IF('Treatment Plan'!$AR$12=\"No\",0,(AK20*'Treatment Plan'!no_of_patients)/60)","v":0},{"$f":"E20/'Local Assumptions'!D31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,20,null,null,null,"0"]
[null,"Subsequent cycles","N/A",null,{"$f":"IF('Treatment Plan'!$AR$12=\"No\", (AK21*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60,(AK21*('Treatment Plan'!planned_cycle-1)*'Treatment Plan'!no_of_patients)/60)","v":0},{"$f":"E21/'Local Assumptions'!D31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,25,null,null,null,"0"]
[null,"Total times for patient & equipment checks/preparation that use chair time",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(E20:E21)))","v":0},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(F20:F21)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[]
[null,"CHEMOTHERAPY DRUG ADMINISTRATION (INCLUDED IN CHAIR TIME)",null,"    Step 4  - Select times for drug administration"]
[null,"Oral",{"$f":"COUNTIF('Treatment Plan'!$AT$21:$AT$26,'Nurse Capacity'!B25)","v":0},null,{"$f":"(C25*AK25*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":0},{"$f":"E25/'Local Assumptions'!$D$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Sub-cut",{"$f":"COUNTIF('Treatment Plan'!$AT$21:$AT$26,'Nurse Capacity'!B26)","v":0},null,{"$f":"(C26*AK26*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":0},{"$f":"E26/'Local Assumptions'!$D$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Intramuscular",{"$f":"COUNTIF('Treatment Plan'!$AT$21:$AT$26,'Nurse Capacity'!B27)","v":0},null,{"$f":"(C27*AK27*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":0},{"$f":"E27/'Local Assumptions'!$D$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"IV bolus ",{"$f":"COUNTIF('Treatment Plan'!$AT$21:$AT$26,'Nurse Capacity'!B28)","v":0},null,{"$f":"(C28*AK28*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":0},{"$f":"E28/'Local Assumptions'!$D$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"IV infusion",{"$f":"COUNTIF('Treatment Plan'!$AT$21:$AT$26,'Nurse Capacity'!B29)","v":2},null,{"$f":"(C29*AK29*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":0},{"$f":"E29/'Local Assumptions'!$D$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Intrathecal",{"$f":"COUNTIF('Treatment Plan'!$AT$21:$AT$26,'Nurse Capacity'!B30)","v":0},null,{"$f":"(C30*AK30*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60","v":0},{"$f":"E30/'Local Assumptions'!$D$31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0"]
[null,"Total times for chemotherapy drug administration",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(E25:E30)))","v":0},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(F25:F30)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5"]
[]
[null,"TIME SPENT MONITORING PATIENT (INCLUDED IN CHAIR TIME)",null,"    Step 5 - Select time the nurse spends with patient",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Variable time",5,10,15,30]
[null,"Cycle 1","N/A",null,{"$f":"IF('Treatment Plan'!$AR$12=\"No\",0,(AK34*'Treatment Plan'!no_of_patients)/60)","v":12.5},{"$f":"E34/'Local Assumptions'!$D$31","v":2.3148148148148149},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30"]
[null,"Subsequent cycles","N/A",null,{"$f":"IF('Treatment Plan'!$AR$12=\"No\",(AK35*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients)/60,(AK35*('Treatment Plan'!planned_cycle-1)*'Treatment Plan'!no_of_patients)/60)","v":141.66666666666666},{"$f":"E35/'Local Assumptions'!$D$31","v":26.234567901234563},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20"]
[null,"Total time spent monitoring patients",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(E34:E35)))","v":154.16666666666666},{"$f":"IF('Treatment Plan'!$J$44=0,0,(SUM(F34:F35)))","v":28.549382716049379}]
[]
[null,"TOTALS FOR ACTIVITIES THAT REQUIRE CHAIR TIME",null,null,{"$f":"E22+E31+E36","v":154.16666666666666},{"$f":"F22+F31+F36","v":28.549382716049379}]
[null,"TOTAL NURSE RESOURCE REQUIREMENT FOR THE COHORT",null,null,{"$f":"E12+E17+E22+E31+E36","v":379.16666666666663},{"$f":"F12+F17+F22+F31+F36","v":70.216049382716051},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"60"]

{"sheet":"Chair Capacity","index":6,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,2,3,3],[18,2,18,3],[23,2,23,4]]}
[]
[null,null,"ESTIMATE OF CHAIR CAPACITY"]
[]
[null,null,"Summary of treatment plan "]
[null,null,"Drug Type","Items to administer"]
[null,null,"Oral",{"$f":"'Nurse Capacity'!C25","v":0}]
[null,null,"Sub-cut",{"$f":"'Nurse Capacity'!C26","v":0}]
[null,null,"Intramuscular",{"$f":"'Nurse Capacity'!C27","v":0}]
[null,null,"IV bolus",{"$f":"'Nurse Capacity'!C28","v":0}]
[null,null,"IV infusion",{"$f":"'Nurse Capacity'!C29","v":2}]
[null,null,"Intrathecal",{"$f":"'Nurse Capacity'!C30","v":0}]
[]
[null,null,"Number of patients",{"$f":"'Treatment Plan'!no_of_patients","v":25}]
[null,null,"Total time from treatment plan (hours)",{"$f":"'Treatment Plan'!J43","v":937.5}]
[null,null,"Nurse led activities (hours)*",{"$f":"'Nurse Capacity'!E22+'Nurse Capacity'!E31","v":0}]
[]
[]
[]
[null,null,"Total chair occupation time in chemotherapy delivery unit"]
[]
[null,null,"TOTAL CHAIR TIME REQUIRED FOR THE COHORT (days)",{"$f":"(D14+D15)/'Local Assumptions'!D7","v":125}]
[]
[]
[null,"*","The nurse monitoring time is omitted from the calculation of chair time. It is covered within the observation time recorded on the 'Treatment Plan' worksheet and hence is already captured in the \"Total time from treatment plan\" figure shown on this worksheet."]

{"sheet":"drug regimen","index":7,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":true,"merged":[[33,5,33,10],[41,5,41,10],[3,5,3,10],[12,5,12,10],[3,0,3,4]]}
[]
["Clinical Protocol:",null,null,null,"XELOX (Oxaliplatin and Capecitabine ) + Cetuximab (Oxaliplatin and Cetuximab - 2hr infusions and Capecitabine as oral) "]
[]
["SW: is 3 drugs typical? More?",null,null,null,null,"Choose Drugs: Route & Recommended Infusion Time"]
[]
[null,null,null,null,null,null,null,"Route","Infusion time or regimen","Route","Infusion Time"]
[null,null,null,null,null,"Drug 1","Cetuximab","oral","N/A","IV"]
[null,null,null,null,null,null,"(a mab)","IV bolus","N/A"]
[null,null,null,null,null,null,null,"IV subcut","N/A"]
[null,null,null,null,null,null,null,"IV","60 mins"]
[null,null,null,null,null,null,null,null,"120mins"]
[]
[]
[null,null,null,null,null,null,null,null,"180 mins"]
[null,null,null,null,null,null,null,null,"240 mins"]
[null,null,null,null,null,null,null,null,null,"Route ","Infusion Time"]
[null,null,null,null,null,"Drug 2","Oxaliplatin","oral","N/A","IV","60 mins"]
[null,null,null,null,null,null,"(an IV chemo)","IV bolus","N/A"]
[null,null,null,null,null,null,null,"IV subcut","N/A"]
[null,null,null,null,null,null,null,"IV","60 mins"]
[null,null,null,null,null,null,null,null,"120mins"]
[]
[null,null,null,null,null,null,null,null,"180 mins"]
[]
[null,null,null,null,null,null,null,null,"240 mins"]
[null,null,null,null,null,null,null,null,null,"Route ","Infusion Time"]
[null,null,null,null,null,"Drug 3","Capecitabine","oral","N/A","oral","N/A"]
[null,null,null,null,null,null,"(an oral chemo)","IV bolus","N/A"]
[null,null,null,null,null,null,null,"IV subcut","N/A"]
[null,null,null,null,null,null,null,"IV","60 mins"]
[null,null,null,null,null,null,null,null,"120mins"]
[null,null,null,null,null,null,null,null,"180 mins"]
[null,null,null,null,null,null,null,null,"240 mins"]
[null,null,null,null,null,"Choose observation periods"]
[null,null,null,null,null,null,null,null,null,"Units","Observation time"]
[null,null,null,null,null,"Observation time",null,null,"60 mins",1,"60 mins"]
[null,null,null,null,null,null,null,null,"120mins"]
[null,null,null,null,null,null,null,null,"180 mins"]
[null,null,null,null,null,null,null,null,"240 mins"]
[null,null,null,null,null,null,null,null,"240 mins or 4hours"]
[]
["Total protocol time",null,null,null,null,"Puts in Total Time here"]
[null,null,null,null,null,null,null,null,"put in number here"]
[]
[]
["Cycle length"]
["Number of days (SW to comment)"]

{"sheet":"Pathway Results","index":8,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[[54,3,54,14],[56,3,56,15],[44,3,44,7],[46,3,46,7],[44,29,44,32],[46,8,46,9],[45,8,45,9],[45,29,45,32],[4,3,6,32],[41,4,43,8],[40,26,40,27],[41,20,43,27],[44,8,44,9],[41,29,43,33],[40,29,40,33],[66,1,66,20],[60,1,60,26],[61,1,61,20],[62,1,62,20],[64,1,64,20],[65,1,65,20]]}
[]
[null,"CHEMOTHERAPY PATHWAY - CAPACITY REQUIRED*"]
[]
[]
[null,null,null,"This page presents the results of this capacity estimate (pharmacy capacity (WTE and isolator time), oncology nurse capacity and oncology chair time associated with delivery of the regimen you have detailed for the cohort of interest)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Calculate pharmacy capacity (Isolator time and WTE)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculate oncology nurse capacity",null,null,null,null,null,null,null,null,"Calculate oncology chair time"]
[]
[]
[null,null,null,"Staff Resource (WTE days)",null,null,null,null,{"$f":"'Pharmacy Capacity'!H36","v":189.43168724279832},null,null,null,null,null,null,null,null,null,null,null,null,"Staff Resource (WTE days)",null,null,null,null,{"$f":"'Nurse Capacity'!F39","v":70.216049382716051},null,null,"Chair time (days)",null,null,null,{"$f":"'Chair Capacity'!$D$21","v":125}]
[null,null,null,"Staff Resource (WTE Equivalent)",null,null,null,null,{"$f":"I45/365","v":0.51899092395287205},null,null,null,null,null,null,null,null,null,null,null,null,"Staff Resource (WTE Equivalent)",null,null,null,null,{"$f":"AA45/365","v":0.19237273803483851},null,null,"Chair time (per week)",null,null,null,{"$f":"'Chair Capacity'!$D$21","v":125}]
[null,null,null,"Isolator time (days)",null,null,null,null,{"$f":"'Pharmacy Capacity'!I36","v":128.00192592592592}]
[]
[]
[]
[null,null,"WTE = Whole Time Equivalent"]
[]
[null,"Key"]
[]
[null,null,null,"Areas of the pathway where capacity will be calculated"]
[]
[null,null,null,"Areas of the pathway that will NOT be included in the capacity calculations"]
[]
[]
[]
["*","Sample pathway as described in the draft NHS standard specification template for adult systemic anti-cancer therapy services, December 2012."]
[null,"https://www.engage.england.nhs.uk/consultation/ssc-area-b/supporting_documents/b3lservicespec.pdf"]
[null,"Accessed January 2015"]
[]
[null,"For current service specification refer to  NHS England Chemotherapy CRG webpage. "]
[null,"http://www.england.nhs.uk/commissioning/spec-services/npc-crg/group-b/b15/  "]
[null,"Acessed January 2015"]

{"sheet":"Results Table","index":9,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,2,6,7],[13,2,13,3]]}
[]
[]
[]
[null,"RESULTS TABLE"]
[]
[]
[null,null,"Enter the Title of the New Chemotherapy Regimen"]
[]
[null,null,null,"Staff Resource\n (WTE days)","Staff Resource          (WTE equivalent)","Isolator Time\n(days)","Chair Time\n(days)","Chair Time\nHours Per week"]
[null,null,"PHARMACY",{"$f":"'Pharmacy Capacity'!H36","v":189.43168724279832},{"$f":"D10/365","v":0.51899092395287205},{"$f":"'Pharmacy Capacity'!I36","v":128.00192592592592},"N/A","N/A"]
[null,null,"NURSE",{"$f":"'Nurse Capacity'!F39","v":70.216049382716051},{"$f":"D11/365","v":0.19237273803483851},"N/A","N/A","N/A"]
[null,null,"FACILITIES","N/A","N/A","N/A",{"$f":"'Chair Capacity'!D21","v":125},{"$f":"G12/52*7.5","v":18.028846153846153}]
[null,null,"TOTAL",{"$f":"SUM(D10:D12)","v":259.64773662551437},0.71136366198771062,{"$f":"SUM(F10:F12)","v":128.00192592592592},{"$f":"SUM(G12)","v":125},{"$f":"SUM(H12)","v":18.028846153846153}]
[null,null,"WTE = Whole Time Equivalent"]

{"sheet":"Local Assumptions","index":10,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[9,1,9,2],[30,4,30,6]]}
[]
[]
[null,"LOCAL ASSUMPTIONS "]
[]
[]
[null,null,null,"Available time (hours)"]
[null,"Average opening time for chemotherapy unit",null,7.5]
[]
[]
[null,"Average opening time for pharmacy unit",null,7.5]
[]
[]
[null,"Fixed time for pharmacy staff"]
[null,"Assistants",null,27.3]
[null,"Pharmacists",null,27.3]
[null,"Technicians",null,27.3]
[]
[null,"Fixed time for chemotherapy nursing staff"]
[null,"Chemotherapy-trained nurse",null,27.3]
[]
[null,"Fixed time for oncology clinic staff"]
[null,"Nurses ",null,27.3]
[null,"Oncologists",null,27.3]
[]
[null,"WTE calculations"]
[null,"1 whole time equivalent is 37.5 hours per week (or 2250 mins per week)"]
[null,"Deduct 40 mins per day (2X20 min breaks) (-200 mins/week)"]
[null,"Deduct 20% for holidays, sickness, training etc."]
[null,"1 WTE =27.3 hrs/week or 5.4 hours per day"]
[]
[null,"Change hours worked / day",null,5.4,"Whole Time Equivalent (WTE)"]

{"sheet":"Pharmacy References","index":11,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,1,1,5],[44,1,46,5]]}
[]
[null,"GUIDANCE ON FIXED TIMES FOR PHARMACY*"]
[]
[null,"Time taken per infusion (mins)"]
[null,"Task","Assistant","Technician","Pharmacist","Total"]
[null,"Clinical Check",null,null,5,{"$f":"SUM(C6:E6)","v":5}]
[null,"Workhseet & labels",null,10,null,{"$f":"SUM(C7:E7)","v":10}]
[null,"Setting Up",5,null,null,{"$f":"SUM(C8:E8)","v":5}]
[null,"Checking Ingredients",null,2,null,{"$f":"SUM(C9:E9)","v":2}]
[null,"Transfer",5,null,null,5]
[null,"Labelling, Final Check, Release",null,null,5,5]
[null,"Delivery",2,null,null,2]
[null,"TOTAL (mins)",{"$f":"SUM(C6:C12)","v":12},{"$f":"SUM(D6:D12)","v":12},{"$f":"SUM(E6:E12)","v":10},{"$f":"SUM(F6:F12)","v":34}]
[]
[null,"Time taken per syringe (mins)"]
[null,"Task","Assistant","Technician","Pharmacist","Total"]
[null,"Clinical Check",null,null,4,{"$f":"SUM(C17:E17)","v":4}]
[null,"Worksheet & labels",null,6,null,{"$f":"SUM(C18:E18)","v":6}]
[null,"Setting Up",4,null,null,4]
[null,"Checking Ingredients",null,2,null,2]
[null,"Transfer",4,null,null,4]
[null,"Labelling, Final Check, Release",null,null,2,2]
[null,"Delivery",2,null,null,2]
[null,"TOTAL (mins)",{"$f":"SUM(C17:C23)","v":10},{"$f":"SUM(D17:D23)","v":8},{"$f":"SUM(E17:E23)","v":6},{"$f":"SUM(F17:F23)","v":24}]
[]
[null,"Time taken per ready made item (mins)"]
[null,"Task","Assistant","Technician","Pharmacist","Total"]
[null,"Release",null,null,5,{"$f":"SUM(C28:E28)","v":5}]
[null,"Dispensing & labelling",5,null,null,5]
[null,"Final Check",null,null,5,5]
[null,"TOTAL (mins)",{"$f":"SUM(C28:C30)","v":5},{"$f":"SUM(D28:D30)","v":0},{"$f":"SUM(E28:E30)","v":10},{"$f":"SUM(F28:F30)","v":15}]
[]
[null,"Time taken per oral drug (mins)"]
[null,"Task","Assistant","Technician","Pharmacist","Total"]
[null,"Dispensing & Labelling",null,7,null,{"$f":"SUM(C35:E35)","v":7}]
[null,"Final Check",null,null,3,3]
[null,"TOTAL (mins)",{"$f":"SUM(C35:C36)","v":0},{"$f":"SUM(D35:D36)","v":7},{"$f":"SUM(E35:E36)","v":3},{"$f":"SUM(F35:F36)","v":10}]
[]
[null,"Isolator cleaning time (mins)"]
[null,"Task","Assistant","Technician","Pharmacist","Total"]
[null,"Initial Clean of Isolator",null,15,null,{"$f":"SUM(C41:E41)","v":15}]
[null,"Final Clean of Isolator",null,22,null,{"$f":"SUM(C42:E42)","v":22}]
[null,"Environmental Monitoring",15,null,null,15]
[null,"TOTAL (mins)",{"$f":"SUM(C41:C43)","v":15},{"$f":"SUM(D41:D43)","v":37},{"$f":"SUM(E41:E43)","v":0},{"$f":"SUM(F41:F43)","v":52}]
[null,"*The data shown above has been collated by Steve Williamson, Consultant Cancer Pharmacist , Northumbria Healthcare / Cumbria, Northumberland, Tyne & Wear Area Team, NHS England\n"]

{"sheet":"Activity Tariffs","index":12,"n_rows":45,"n_cols":34,"rows_kept":45,"cut":false,"hidden":false,"merged":[[29,0,32,0],[2,1,2,6],[42,1,42,3],[44,1,44,3],[32,1,32,3],[38,1,38,4],[40,1,40,3],[4,1,6,7],[34,1,34,3],[34,4,34,6],[35,1,35,3],[35,4,35,6]]}
[]
[]
[null,"UNBUNDLED HRGs FOR CHEMOTHERAPY DELIVERY FOR REGIMENS ON THE NATIONAL LIST*"]
[]
[null,"This sheet generates the likely tariff costs for delivering unbundled HRGs for chemotherapy delivery for regimens on the national list. If the chemotherapy regimen being delivered is not on the national list, this sheet will not apply and please use code SB17Z and local tariff information. "]
[]
[]
[]
[]
[null,"All oral regimen - Tariff for cohort"]
[null,null,null,"HRG4 Code ","Total tariff for cohort (£)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Selection",null,null,null,null,"Linked Cells"]
["Step 1","Is the  regimen exclusively oral chemotherapy?",null,{"$f":"IF(AF12=\"Yes\",\"SB11Z\",\"Go to Step 2\")","v":"Go to Step 2"},{"$f":"IF(AF12=\"Yes\",'Tariff Information'!D5*'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients,\"Go to Step 2\")","v":"Go to Step 2"},null,null,null,null,null,null,"PREVIOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,null,null,null,"No"]
[null,null,"If yes, the following steps do not apply",null,null,null,null,null,null,null,null,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Parenteral -Tariff for Cycle 1 cohort"]
[]
[null,"Please select only one Yes"]
[null,null,null,null,"Tariff for cycle one for cohort (£)"]
["Step 2","Is Cycle 1 simple parenteral chemotherapy?",null,{"$f":"IF(AF18=\"Yes\",\"SB12Z\",\"Go to Step 3\")","v":"Go to Step 3"},{"$f":"IF(AF18=\"Yes\",'Tariff Information'!D6*'Treatment Plan'!no_of_patients,\"Go to Step 3\")","v":"Go to Step 3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,{"$f":"IF(AF18=\"Yes\",E18,0)","v":0}]
[]
[]
[null,null,null,null,"Tariff for cycle one for cohort (£)"]
["Step 3","Is Cycle 1  complex parenteral chemotherapy?",null,{"$f":"IF(AF22=\"Yes\",\"SB13Z\",\"Go to Step 4\")","v":"SB13Z"},{"$f":"IF(AF22=\"Yes\",'Tariff Information'!D7*'Treatment Plan'!no_of_patients,\"Go to Step 4\")","v":7475},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,{"$f":"IF(AF22=\"Yes\",E22,0)","v":7475}]
[]
[]
[null,null,null,null,"Tariff for cycle one for cohort (£)"]
["Step 4","Is Cycle 1 complex parenteral chemotherapy, including prolonged infusion treatment at first attendance?",null,{"$f":"IF(AF26=\"Yes\",\"SB14Z\",\"Go to Results\")","v":"SB14Z"},{"$f":"IF(AF26=\"Yes\",'Tariff Information'!D8*'Treatment Plan'!no_of_patients,\"Go to Results\")","v":11225},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,{"$f":"IF(AF26=\"Yes\",E26,0)","v":11225}]
[]
[]
[null,"Parenteral -Tariff for subsequent cycles for cohort"]
["Results"]
[null,"Cost for delivering subsequent cycles of chemotherapy  (SB15Z)",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,IF(AF12=\"Yes\",0,('Tariff Information'!D9*('Treatment Plan'!planned_cycle-1)*'Treatment Plan'!no_of_patients)))","v":127075}]
[]
[null,"Total national activity tariff for cohort (all cycles)",null,null,{"$f":"IF('Treatment Plan'!$J$44=0,0,IF(AF12=\"Yes\",0,SUM(AH18:AH26,E31)))","v":145775}]
[]
[null,"*Reference 2017/18 and 2018/19 National Tariff Payment System, Available at \n\n"]
[null,"https://improvement.nhs.uk/resources/national-tariff-1719/"]
[null,"Last Accessed 16 April 2018"]
[]
[null,"VARIABLE TARIFF CALCULATOR"]
[]
[null,"Total cycles of chemotherapy for cohort",null,null,{"$f":"'Treatment Plan'!planned_cycle*'Treatment Plan'!no_of_patients","v":450}]
[]
[null,"Chemotherapy preparation tariff",null,null,0,null,null,null,null,"NEXT"]
[]
[null,"Total variable tariff for the cohort  (£)",null,null,{"$f":"E43*$E$41","v":0}]

{"sheet":"Tariff Information","index":13,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[12,1,12,3],[13,1,13,3],[14,1,14,3]]}
[]
[null,"DETAILS OF CHEMOTHERAPY COSTS (from the National tariff payment system 2018/19 - Annex A Spreadsheet Tab,  4c Unbundled prices 18.19)"]
[]
[null,"HRG code","HRG name","Tariff (£)"]
[null,"SB11Z","Deliver Exclusively Oral Chemotherapy",120]
[null,"SB12Z","Deliver Simple Parenteral Chemotherapy at first attendance",150]
[null,"SB13Z","Deliver more Complex Parenteral Chemotherapy at first attendance",299]
[null,"SB14Z","Deliver Complex Chemotherapy, including Prolonged Infusion Treatment at first attendance",449]
[null,"SB15Z","Deliver Subsequent Elements of a Chemotherapy Cycle",299]
[null,"SB17Z","Deliver Chemotherapy for Regimens not on the National List","-"]
[]
[]
[]
[null,"Reference 2017/18 and 2018/19 National Tariff Payment System, Available at \n\n"]
[null,"https://improvement.nhs.uk/resources/national-tariff-1719/"]
[null,"Last Accessed 16 April 2018"]