{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary","Tablets","BWSD","BWDD","Vol","INFR-V","INFR-D","INFR-T","Con","Sol Str","Maths-DR"],"not_rendered":{"charts":0,"images":46,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Summary","index":0,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,4,19],[6,0,28,9],[18,11,19,11],[20,11,21,11],[22,11,23,11],[6,11,7,11],[8,11,9,11],[10,11,11,11],[12,11,13,11],[14,11,15,11],[16,11,17,11]]}
[null,null,"Nursing Drug Calculation Revision"]
[]
[]
[]
[]
[]
["Welcome to the revision and practice area for Nursing Drug Calculations.\n\nThis system has been carefully put together to guide you through the drug calculations.  It has been constructed so that you can tailor your revision to suit your needs by selecting the type of calculation you want to practice without having to go through those that you are good at.  \n\nThis is not intended as a substitute for the embedded lessons, but as an aid to further revision.\n\nTo navigate the system use the buttons on the right to go to the area you want to view.  Once at that area you will see some guidance notes and a set of questions to practice.  Enter your answers in the purple answer column then use the CHECK button to check your answers.  To see the correct answers use the ANSWER button and they will be displayed on the right.  Use the RESET button to clear everything and start again.  Use the HOME button to return to this page.\n\nIf you are in doubt about anything, or not sure, book a tutorial or come along to a workshop.  These can be booked online or contact numeracy@mdx.ac.uk",null,null,null,null,null,null,null,null,null,null,"Tablet Calculations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Body Weight Single Dose"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Body Weight TDD and Divided Doses"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Volumes For Injection"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Infusion Rates (Volume)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Infusion Rates (Drops)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Infusion Rates (Time)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Concentrations"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Solution Strength"]

{"sheet":"Tablets","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,12],[7,0,7,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[5,0,5,7],[6,0,6,3],[6,4,6,5]]}
[null,null,"Nursing Drug Calculations Revision"]
["Tablet Calculations",null,null,null,null,null,null,null,null,"Practice Questions:","Answer"]
["To calculate the number of tablets to give to the patient use the following formula:",null,null,null,null,null,null,null,null,"1) A patient has been prescribed 40 mg.  The stock tablets you have are 20 mg. How many tablets do you give the patient?"," "," "," "]
["Prescription for the Patient\nStock Strength Available",null,null,null,null,null,null,null,null,"2) A patient has been prescribed 0.06 mg.  The stock tablets you have are 30 mcg. How many tablets do you give the patient?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"3) The stock tablets you have are 600 mcg. A patient has been prescribed 1.2 mg.  How many tablets do you give the patient?"," "," "," "]
["Your patient has been prescribed 400mg of Ibuprofen.  The tablets available are 200mg.  How many tablets do you give the patient?",null,null,null,null,null,null,null,null,"4) A patient has been prescribed 750 mg TDD (total daily dose).  The stock tablets you have are 250 mg. How many tablets do you give the patient in a day?"," "," "," "]
["400mg\n200mg",null,null,null,"  = 2 Tablets",null,null,null,null,"5) A patient has been prescribed 750 mg TDD in 3 divided doses.  The stock tablets you have are 250 mg. How many tablets do you give the patient for a single dose?"," "," "," "]
["Note: Make sure the units in the prescription are the same as the units in the stock available.  If they are not you will have to convert one of them.",null,null,null,null,null,null,null,null,"6) A patient has been prescribed 200 mg every 4 hours.  The stock tablets you have are 100 mg. How many tablets do you give the patient in a day?"," "," "," "]
[null,null,null,null,null,null,null,null,null,null," "," "," "]

{"sheet":"BWSD","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,0,15],[9,0,12,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,7],[7,0,7,7],[8,0,8,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Body Weight Calculations (Single Dose)",null,null,null,null,null,null,null,null,"Practice Questions:","Answer"]
["To calculate the doseage based on the weight of the patient use the following formula:",null,null,null,null,null,null,null,null,"1) A patient has been prescribed Erythromycin, 4 mg/kg/dose. He weighs 74 kg. What is the dosage in mg?"," "," "," "]
["Dosage required = prescription  x  body weight",null,null,null,null,null,null,null,null,"2) A male patient weighs 90 kg and has been prescribed \n1.5 mg/kg/dose of drug X. How many mg will he need for a single dose?"," "," "," "]
["The prescription will have three parameters (or parts) as below:\n                  5mg/kg/dose",null,null,null,null,null,null,null,null,"3) Cloxacillin, 50 mg/kg/dose has been prescribed to a patient, whose weight is 45 kg.  How many grams are required per dose?"," "," "," "]
["The first parameter gives the prescribed amount.\nThe second says the prescription is for every Kg of body weight\nThe third parameter says how often to give the prescription",null,null,null,null,null,null,null,null,"4) A female patient has been prescribed Chloramphenicol, 40 mg/kg/dose. She weighs 78 kg. How many grams of the drug does she require for each dose?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"5) A patient weighs 60kg and requires 40 mcg/ kg of a drug.  How many mg will the patient require?"," "," "," "]
["Mrs B has been prescribed Ibuprofen 5mg/Kg/dose.  She weighs 60Kg.  Calculate how much Ibuprofen you will give her per dose.",null,null,null,null,null,null,null,null,"6) A patient who is 5 years old and weighs 20 kg has been prescribed 5 mcg per kilogram body weight of Digoxin elixir.\n    i)  How many micrograms does the patient require per dose?"," "," "," "]
["5mg  x  60 = 300mg",null,null,null,null,null,null,null,null,"    ii) The Digoxin elixir is available as 50 mcg per ml.  What volume will you give to the patient?"," "," "," "]
["The units for the final answer will be in mg as that is what the prescription has been given in and you have not been asked to convert."]

{"sheet":"BWDD","index":3,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,2,0,16],[10,0,11,7],[1,0,1,7],[2,4,4,7],[2,0,4,3],[5,0,5,7],[6,0,6,7],[7,0,9,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Body Weight Calculations (Divided Doses)",null,null,null,null,null,null,null,null,"Practice Questions:","Answer"]
["As in the sigle dose calculations the prescription has three parameters, but this time the third parameter must be looked at carefully.  Refer to the abbrieviations on the right.",null,null,null,"Terms Used:\n\nTDD - Total Daily Dose\nBD - Two times a day\nTDS - Three times a day\nQDS - Four times a day\n\nA day is always 24 hours.",null,null,null,null,"1. Mrs K has been prescribed Amoxicillin 4.5mg/kg/qds, she weighs 50kg.  Calculate her TDD."," "," "," "]
[null,null,null,null,null,null,null,null,null,"2. A patient whose weihjt is 67.5kg has been prescribed 10mg/kg/day in three divided doses.   Calculate how much to give for a single dose."," "," "," "]
[null,null,null,null,null,null,null,null,null,"3. A patient has been prescribed Capreomycin Sulphate 5mg/kg/bd.  He weighs 94.5Kg.  What is his TDD?"," "," "," "]
["For example, a prescription of 5mg/Kg/tds would mean for each Kg of body weight you need to give 5mg and you have to do that three times a day.",null,null,null,null,null,null,null,null,"4.  A patient has been prescribed Cephaloythin 20mcg/kg/tds, they weigh 67Kg.  How much will you give the patient in mg per dose?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"5.  A patient is prescribed Chloramphenicol 4.5mg/kg/day in 4 divided doses.  If she weighs 70Kg, what is her TDD?"," "," "," "]
["A patient is prescribed 5.5mg/kg/qds of a drug.  He weighs 60kg, calculate his TDD.",null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,null," "," "," "]
[]
["5.5 x 60 x 4 = 1320mg for the whole day."]

{"sheet":"Vol","index":4,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,2,0,14],[8,0,9,1],[10,0,13,7],[14,0,16,0],[14,1,16,1],[14,2,16,2],[14,4,17,7],[1,0,1,7],[2,0,3,7],[4,0,4,7],[5,0,6,7],[7,1,7,3],[7,4,7,5]]}
[null,null,"Nursing Drug Calculations Revision"]
["Volumes for Injection",null,null,null,null,null,null,null,null,"Practice Questions:","Answer"]
["To calculate the volume for injection you will need to know the prescription for the patient and you will need to know what stock is available.\nThe stock description comes in two parts; Stock Strength and Stock Volume.",null,null,null,null,null,null,null,null,"1. A patient has been prescribed 2mg of Pethidine.  The stock strength you have is 10mg/mL, how much do you give the patient?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"2. 40 units of Insulin has been prescribed.  It is dispensed as 100 units in 1mL.  How much do you give the patient?"," "," "," "]
["The stock strength is the solids. (Given in mg or mcg)\nThe stock volume is the liquid. (Given in mL)",null,null,null,null,null,null,null,null,"3. Ampules of Morphine contain 10mg in 2 mL.  What volume must be drawn up to give 8mg?"," "," "," "]
["So if your stock is given as 5mg/2ml then:\nThe stock strength is 5mg\nThe stock volume is 2mL\nTo calculate how much to give to the patient use the following formula:",null,null,null,null,null,null,null,null,"4. The patieng needs 250mcg of drug X.  Your stock contains 1mg in 1mL.  How much will you give?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"5. A patient requires 0.6mg of a drug.  Your stock is 0.4mg in 2mL, how much will you give the patient?"," "," "," "]
[null,"Prescription for the patient \nStock Strength",null,null,"x  Stock Volume",null,null,null,null,"6.  A doctor orders 0.25g of a drug to be given.  The stock on the ward is 500mg/5mL.  How much should you give the patient?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,null," "," "," "]
[]
["Your patient has been prescribed 50mg of Pethidine as injection.  The stock available to you is 100mg in 4mL.  What volume should be drawn up to give to the patient?"]
[]
[]
[]
["50mg\n100mg","x 4mL   =","1\n2",null,"Note: Make sure the prescription and the stock strength are given in the same units.  If not you will have to convert one of them."]
[null,null,null,"x  4 = 2mL"]

{"sheet":"INFR-V","index":5,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,2,0,17],[9,0,10,7],[11,0,13,0],[11,2,13,2],[11,4,13,4],[1,0,1,7],[2,0,3,7],[4,0,4,7],[5,0,6,7],[7,0,7,1],[8,0,8,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Infusion Rates",null,null,null,null,null,null,null,null,"Practice Questions:","Answers"]
["When calculating infusion rates the answer is always given as how many mL you will give the patient in one hour. (mL/hr)\nWhen calculating the rate you will need to know the prescription in mL and the time in hours.",null,null,null,null,null,null,null,null,"1.  800mL of fluid in a burette is to be infused over 2 hours.  At what rate will you set the pump?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"2.  A teenager is to receive 500mL of Hartmann's solution over 8 hours.  What is the infusion rate in mL/hr?"," "," "," "]
["To calculate the rate use the following formula:",null,null,null,null,null,null,null,null,"3.  Over a period of 16 hours a patient is to receive 2.4L of Dextrose 4%.  What is the infusion rate?"," "," "," "]
["Prescription for the patient (mL)\nTime (Hours)",null,null,null,null,null,null,null,null,"4.  A doctor requests 0.75L of Crystalloid X to be infused over 6 hours using a pump.  What is the infusion rate in mL/hr?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"5.  Half a litre of Dextrose is to be given over 4 hours.  What is the rate in mL/hr?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"6.  The doctor prescribes 1L of 5% Dextrose in normal saline to be infused over 6 hours.  How many mL/hr is this to one decimal place?"," "," "," "]
["A patient is to receive 4L of normal saline over the next 8 hours.  What is the infusion rate?",null,null,null,null,null,null,null,null,"7.  A patient receives 50mL of saline in half an hour.  What is the rate in mL/hr?"," "," "," "]
["First convert the 4L to mL. (4000mL)"]
[]
["4000mL\n8 Hr",null,"2000\n4",null,"1000\n2"]
[null,"=",null,"=",null,"=","500ml/hr"]

{"sheet":"INFR-D","index":6,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,0,15,4],[8,0,9,7],[10,0,10,4],[11,5,11,7],[12,5,14,5],[12,7,14,7],[15,5,17,5],[15,7,17,7],[11,0,13,0],[11,2,13,2],[16,0,17,4],[2,0,3,7],[4,0,5,7],[6,0,6,7],[7,0,7,1],[0,2,0,15],[1,0,1,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Infusion - Drop Rates",null,null,null,null,null,null,null,null,"Practice Questions:","Answers"]
["Drop rates are always measured as how many drops to give the patient in one minute.  To work this out we need to find the total number of drops the patient will receive and the total number of minutes the infusion is to last.\nTo get the number of minutes multiply the number of hours by 60.",null,null,null,null,null,null,null,null,"1. Half a Litre of fluid is to be given over 5 hours.  What is the infusion rate in drops/minute if the drop factor is 15?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"2.  A young woman is to be given 480mL of Metronidazole 500mg over 4 hours.  What is the infusion rate in drops per minute of the drop factor is 20?"," "," "," "]
["To get the total number of drops we first convert our presciption into mL, if its not in mL already.  We then multiply this by something called a Drop Factor.  The Drop Factor is the number of drops it takes your eqipment to deliver one mL.  It is 15 for bloods and 20 for clear fluids.",null,null,null,null,null,null,null,null,"3.  Over the next 15 hours a male patient is to receive 4L of Dextrose 5%.  What is the infusion rate if the drop factor is 20?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"4.  A patient is to receive 500mL of Dextrose 5% over two hours.  What is the infusion rate if the drop factor is 20?"," "," "," "]
["We then divide the number of mL by the number of minutes and get our Drop Rate in drops/min.",null,null,null,null,null,null,null,null,"5.  A female patient is to receive 2L of fluid over the next 10 hours.  What is the infusion rate if the drop factor is 15?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"6.  One unit of blood (500mL) is to be infused over 4 hours.  What is the flow rate if the drop factor is 15 drops/mL?"," "," "," "]
["A patient is to receive 1L of fluid over the next 4 hours.  What is the Drop Rate if the Drop Factor is 15?",null,null,null,null,null,null,null,null,null," "," "," "]
[]
["Convert 1L to 1000mL",null,null,null,null,"Note:"]
["1000mL\n4hours",null,"15\n60",null,null,"Drop Factor is 15 or 20"]
[null,"x",null,"= 62.5 drops/min",null,"15\n60",null,"1\n4"]
[null,null,null,null,null,null,"="]
["Always round to the nearest whole drop, so the answer is 63 drops/min"]
[null,null,null,null,null,"20\n60",null,"1\n3"]
[null,null,null,null,null,null,"="]

{"sheet":"INFR-T","index":7,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,2,0,16],[8,0,10,0],[8,2,10,2],[1,0,1,7],[2,0,3,7],[4,0,4,7],[5,0,5,7],[6,0,6,1],[7,0,7,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Infusion Rates (Time)",null,null,null,null,null,null,null,null,"Practice Questions:","Answers"]
["Previously we looked at calculating the rate of infusions, here we are told what the rate is and we are asked to calculate how long the infusion will take.",null,null,null,null,null,null,null,null,"1. A patient is to receive 800mL of blood at a rate of 160mL/hr.  How long will the infusion last?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"2.  Half a litre of solution is to be given at 125mL/hr.  How long will the infusion last?"," "," "," "]
["To calculate the time foir an infusion we need to know the amount of fluid the patient is to receive and the rate to administer the fluids.  Once we have these two bits of information this is what we do with them:",null,null,null,null,null,null,null,null,"3.  A litre of solution is to be infused at a rate of 80mL/hr.  How long will the infusion last?  Give your answer in hours and minutes."," "," "," "]
["Prescription for the patient (mL)\nRate of administration (mL/hr)",null,null,null,null,null,null,null,null,"4.  A patient receives 200mL at a rate of 400mL/hr.  What is the duration of the infusion?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"5.  An infusion of 1200mL Dextrose 5% is to be given at 100mL/hr.  If the infusion started at 10am what time will it finish?  Give your answer using the 24 hour clock."," "," "," "]
["A patient is to be given 2L of saline at a rate of 125ml/hr.  How long will the infusion take?",null,null,null,null,null,null,null,null,"6.  4 Litres of 0.9% Dextrose is administered at a rate of 400mL/hr.  After 5 hours the rate is changes to 250mL/hr.\ni.  How many more hours until the infusion is finished?"," "," "," "]
["2000\n125",null,"400\n25",null,null,null,null,null,null,"ii.  What is the total running time of the infusion?"," "," "," "]
[null,"=",null,"=","16hours"]

{"sheet":"Con","index":8,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,0,8,7],[0,2,0,17],[1,0,1,7],[2,0,4,7],[5,0,5,1],[6,0,6,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Concentration",null,null,null,null,null,null,null,null,"Practice Questions:","Answer"]
["When asked the concentration of a drug the answer is always foing to be how many mg there are of the active ingrediant in onemL.\nSo to work out the concentration you need to divide the number of mg by the number of mL.",null,null,null,null,null,null,null,null,"1.  The stock of a drug is 10mg/5mL, what is the concentration?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"2.  500mg or Amoxicillin powder is disolved in 25mL of water, what is the concentration?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"3.  A syringe contains 20mg of Morphine in 4mL, what is the concentration?"," "," "," "]
["Example:",null,null,null,null,null,null,null,null,"4.  You have 1g of a drug in 200mL, what is the concentration of the drug?"," "," "," "]
["A patient is prescribed 10mg of a drug that is available as 20mg in 8mL, what is the concentration?",null,null,null,null,null,null,null,null,"5. A patient is prescribed 8mg of a drug that is available as 10mg powder that needs to be reconstituted with 5mL of sterile water.  What is the concentration of the drug?"," "," "," "]
["All you need to look at is the stock - so 20mg ÷ 8mL = 2.5mg/mL\nNotice that the amount prescribed does not affect the concentration so it can be ignored.",null,null,null,null,null,null,null,null,"6.  If you have 12mg of a drug in 25mL of sterile water, what is the concentration?"," "," "," "]
[null,null,null,null,null,null,null,null,null,null," "," "," "]

{"sheet":"Sol Str","index":9,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,7],[0,2,0,17],[2,0,3,7],[4,0,7,7],[8,0,12,7]]}
[null,null,"Nursing Drug Calculations Revision"]
["Solution Strengths",null,null,null,null,null,null,null,null,"Practice Questions:"]
["Solution strengths are usually the type of calculations that give the most problems initially.  But once understood what the numbers mean it becomes a lot easier.",null,null,null,null,null,null,null,null,"1.  A patient requires 0.2mg of 1 in 10000 adrenaline, how many mL will you administer?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"2.  If you have a solution of 2 in 10000, what is the concentration?"," "," "," "]
["The strength is specified as two numbers, for example:\n                                1 in 10000\nThe first number is the number of grams, the second is the number of millilitres.\nIf you conver the number of grams to milligrams you get:\n                        1000mg in 10000mL\nCancel each by 1000 and we get 1mg/10mL - a more recognisable strength.  We can now use this value as our stock and continue with any calculations.",null,null,null,null,null,null,null,null,"3.  A patient is to receive 2mg over 3 hours of a drug that is dispensed in a 1 in 150000 solution.   At what rate will you set the infusion at in mL/hr?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"4.  Mrs Arnott requires 3mg of a drug as injection.  You have two solutions in stock:\n     A)  Solution strength 1 in 1000\n     B)  Solution strength 1 in 10000"," "," "," "]
[null,null,null,null,null,null,null,null,null,"i)  How much solution A would you need?"," "," "," "]
[null,null,null,null,null,null,null,null,null,"ii) How much solution B would you need?"," "," "," "]
["If you always do the above conversion first the calculations become much easier.  But be aware that the first number is not always 1, it can be a fraction, but it is still the number of grams.",null,null,null,null,null,null,null,null,null," "," "," "]
[null,null,null,null,null,null,null,null,null,null," "," "," "]

{"sheet":"Maths-DR","index":10,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,2,0,25]]}
[null,null,"Nursing Drug Calculations Revision"]