{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","DKA 2 bag system","Roadmap Step 1--Enter data","Roadmap Step 2--Print","Roadmap Step3--Print"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"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":"Instructions","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[7,1,7,7],[1,0,1,8],[8,1,8,7],[4,1,4,7],[5,1,5,7],[6,1,6,7],[3,1,3,7],[2,0,2,8]]}
[]
["Estimated Insulin Calculator for a New Diabetic"]
["Created by David I. Crowley, MD, Pediatrics Residency Class of 2007"]
[null,"Instructions:"]
[null,"1. Pink indicates required fields. Physician must enter value in order to proceed to calculated results."]
[null,"2. Review the calculated results marked in yellow."]
[null,"3. After verifying the calculated results, you must enter your final values in the green boxes in order to proceed."]
[null,"4. Print only the \"road maps\", with copies for the attending, all residents, nursing staff, and patient's family."]
[null,"Click tabs below to begin"]

{"sheet":"DKA 2 bag system","index":1,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[19,9,19,10],[19,11,19,12]]}
["Two bag system for IV rehydration in DKA"]
[]
[null,null,null,null,"Rates for IV repletion",null,"Bag 1 - mL/hr",null,"Bag 2 - mL/hr"]
[null,null,null,null,"If blood glucose (mg/dL)",">350",{"$f":"B9","v":0},"(100%)",0,"(0%)"]
["Demographics",null,null,null,"If blood glucose (mg/dL)","301-350",{"$f":"G4*0.75","v":0},"(75%)",{"$f":"G4*0.25","v":0},"(25%)"]
[" Patient Weight",null,"kg",null,"If blood glucose (mg/dL)","251-300",{"$f":"G4*0.5","v":0},"(50%)",{"$f":"G4*0.5","v":0},"(50%)"]
[null,null,null,null,"If blood glucose (mg/dL)","201-250",{"$f":"G4*0.25","v":0},"(25%)",{"$f":"G4*0.75","v":0},"(75%)"]
[" Maintenance IVF rate",{"$f":"IF(B6>85,125,(IF(B6<10,4*B6,(IF((B6-10)<10,40+2*(B6-10),60+1*(B6-20))))))","v":0},"mL/hr",null,"If blood glucose (mg/dL)","60-200",0,"(0%)",{"$f":"G4","v":0},"(100%)"]
["1.5 x Maintenance",{"$f":"1.5*B8","v":0},"mL/hr",null,"If blood glucose (mg/dL)","<60",0,"(0%)",{"$f":"G4","v":0},"(100%)"]
[null,null,null,null,null,"Call resident immediately and hold insulin infusion"]
[]
[]
[null,"Components of the fluid"]
[]
[null,"Bag 1","Bag 2"]
["Dextrose","None","D10%","*Note components are different"]
[]
["Base","Normosol","Normosol"]
[null,"\"Multiple ","\"Multiple "]
[null,"Electrolytes\"","Electrolytes\""]
[]
[null,"+15 mmol/L","+15 mmol/L"]
["Additive 1","Potassium","Sodium","*Note components are different"]
[null,"Phosphate","Phosphate"]
[]
[null,"+10 mEq/L","+40 mEq/L","*Note quantity is different"]
["Additive 2","Potassium","Potassium"]
[null,"Chloride","Chloride"]

{"sheet":"Roadmap Step 1--Enter data","index":2,"n_rows":59,"n_cols":29,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,1,60,5],[2,0,2,5],[2,7,2,8],[3,0,3,5],[7,1,7,3],[43,0,43,5],[4,0,4,5],[47,12,48,14],[39,0,39,5],[11,10,12,12],[34,7,35,9],[6,0,6,5],[4,7,6,12],[0,0,0,8],[14,0,14,5],[25,0,25,5],[33,1,33,3],[32,0,32,5]]}
["Estimated Insulin Calculator for a New Diabetic",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,"Novolog","Lantus",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,"Aspart","Levemir",2]
["Pink = Physician must enter a value for new diabetic",null,null,null,null,null,null,"Hints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Humalog"]
["Yellow = Physician must review the calculated value",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,"U10 Novolog"]
["Green = Physician must enter the confirmed value",null,null,null,null,null,null,"To print out a new road map (e.g. for known diabetics): only a name, insulin names, and all green boxes are mandatory to print out a new \"road map\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U10 Humalog"]
[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,"U10 Aspart"]
["Patient Information:"]
["Name:"]
["Wt:",null,"kg"]
["Age:",null,"yrs",null,null,null,null,"Age","Units/kg/day"]
["Short-acting insulin:","Novolog",null,null,null,null,null,"<5 years","0.3-0.8",null,"(Use low end if small ketones)"]
["Long-acting insulin:","Lantus",null,"Dosed",null,"time(s)/day",null,"5-11 years","0.5-1.0",null,"(Use high end if mod-large ketones, pubertal, or post-DKA)"]
["Total insulin dose:",null,"U/kg/day",null,null,null,null,"12+ years","0.8-1.5"]
[]
["Actual insulin"]
["Total daily insulin given:",{"$f":"ROUND(B13*B9,1)","v":0},"units/day"]
[]
[null,"Estimated",null,null,"Actual"]
["Long-acting dose (40%):",{"$f":"ROUND(B16*0.4,1)","v":0},"units/day",null,6,"units/day"]
[]
["Short-acting dose (60%):",{"$f":"ROUND(B16*0.6,1)","v":0},"units/day"]
["Breakfast (short) (40%):",{"$f":"B16*0.6*0.4","v":0},"(calculated, not used)"]
["Lunch (short) (30%):",{"$f":"B16*0.6*0.3","v":0},"(calculated, not used)"]
[]
[]
["Nutrition"]
["Calories in ADA diet:",{"$f":"1000+(100*B10)","v":1000},"kcals",null,null,null,null,"Calories = 1000 + 100*age"]
["Calories from carbs",{"$f":"B27/2","v":500},"kcals",null,null,null,null,"(1/2 of total carbs)"]
["Grams of carbs",{"$f":"B28/4","v":125},"grams",null,null,null,null,"(4 cal / 1 gm carbs)"]
["Grams of carbs/meal",{"$f":"B29/4","v":31.25},"grams/meal",null,null,null,null,"(25% per meal)"]
[]
[]
["Carbohydrate coverage",null,null,null,null,null,null,"(i.e. 1 Unit / X carbs)"]
[null,"Estimated",null,null,"Actual"]
["carbs/unit (breakfast):",{"$f":"B30/B22","v":{"$error":"#DIV/0!"}},null,null,15,"carbs/unit",null,"(Calculated \"base doses\" above / Units insulin per meal above)"]
["carbs/unit (all other):",{"$f":"B30/B23","v":{"$error":"#DIV/0!"}},null,null,20,"carbs/unit"]
[null,null,null,{"$f":"\"+15gm free with certain snacks\"","v":"+15gm free with certain snacks"}]
[]
[]
["Blood sugar correction scale"]
["Estimated:",1,"Unit","per",{"$f":"IF(1500/B16>24, 1500/B16, 25)","v":{"$error":"#DIV/0!"}},"mg/dL",null,"1500/Total insulin per day"]
["Actual:",1,"Unit","per",100,"mg/dL",null,"(minimum 1U / 25)"]
[]
["Blood Glucose Target Range"]
[null,null,"Low",null,"High"]
["Daytime","Est",{"$f":"IF(B10<3,\"100\",\"80\")","v":"100"},"to",{"$f":"IF(B10<3,200,IF(B10>=8,150,180))","v":200},null,null,"Age","Low","High*","Treat below"]
[null,"Actual",80,"to",150,null,null,"<3 years old",100,">200",80]
[null,null,null,null,null,null,null,"3-7 yrs old",80,">180",70,null,"*50 points higher at night to avoid hypoglycemic coma"]
["Bedtime / 2-3 AM / AM snack","Est",{"$f":"C46","v":"100"},"to",{"$f":"E46+50","v":250},null,null,"8+ yrs old",80,">150",60]
[null,"Actual",80,"to",200]
[]
["Treat hypoglycemia below:",null,{"$f":"IF(B10<3,80,IF(B10>=8,60,70))","v":80},null,60]
[]
[]
[null,null,null,null,null,null,null,"(use only if unarousable or seizing)"]
["Glucagon dose:",null,{"$f":"IF(B9<20,0.5,1)","v":0.5},"mg",1,"mg IM",null,"<20 kg","0.5 mg"]
[null,null,null,null,null,null,null,">20 kg","1 mg"]
["Additional Comments:"]
["(if any)"]

{"sheet":"Roadmap Step 2--Print","index":3,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,1,0,10],[1,1,1,10],[16,1,16,4],[16,7,16,10],[5,6,7,10],[11,1,11,4],[8,6,9,10],[41,0,44,11],[20,1,20,3],[20,7,20,9],[17,1,17,4],[17,7,17,10],[18,1,18,4],[18,7,18,10]]}
[null,{"$f":"'Roadmap Step 1--Enter data'!B8 & \"'s Insulin Road Map\"","v":"'s Insulin Road Map"}]
[null,{"$f":"NOW()","v":"2020-09-14T09:39:01.960"}]
[]
[null,"My long-acting insulin is:",null,null,{"$f":"'Roadmap Step 1--Enter data'!B12","v":"Lantus"},null,{"$f":"IF('Roadmap Step 1--Enter data'!E12=2,\"I take \" & 'Roadmap Step 1--Enter data'!E19/2 & \" units \" & 'Roadmap Step 1--Enter data'!B12 & \" twice a day.\",\"I take \" & 'Roadmap Step 1--Enter data'!E19 & \" units \" & 'Roadmap Step 1--Enter data'!B12 & \" once a day.\")","v":"I take 6 units Lantus once a day."}]
[]
[null,"My short-acting insulin is:",null,null,{"$f":"'Roadmap Step 1--Enter data'!B11","v":"Novolog"},null,{"$f":"\"I take \" & 'Roadmap Step 1--Enter data'!B11 & \" before all meals and snacks. I use the scale below to help me decide how much to give.\"","v":"I take Novolog before all meals and snacks. I use the scale below to help me decide how much to give."}]
[]
[]
[null,null,null,null,null,null,{"$f":"\"If my blood sugar is ever under \" & 'Roadmap Step 1--Enter data'!C47 & \", I use the hypoglycemia road map instead.\"","v":"If my blood sugar is ever under 80, I use the hypoglycemia road map instead."}]
[]
[]
[null,"Carbohydrate coverage"]
[null,"Breakfast",null,null,{"$f":"\"1 Unit / \" & 'Roadmap Step 1--Enter data'!E35 & \" gm carbs\"","v":"1 Unit / 15 gm carbs"},null,null,{"$f":"IF('Roadmap Step 1--Enter data'!B10<10, \"AM Snack, 15gm free\", \"\")","v":"AM Snack, 15gm free"}]
[null,"All other meals/snacks",null,null,{"$f":"\"1 Unit / \" & 'Roadmap Step 1--Enter data'!E36 & \" gm carbs\"","v":"1 Unit / 20 gm carbs"},null,null,"Bedtime Snack, 15gm free"]
[]
[]
[null,"Daytime",null,null,null,null,null,"Nighttime"]
[null,{"$f":"\"Breakfast, Lunch, Afternoon Snack, and Dinner\"","v":"Breakfast, Lunch, Afternoon Snack, and Dinner"},null,null,null,null,null,{"$f":"IF('Roadmap Step 1--Enter data'!B10<10,\"AM Snack, \",\"\") & \"Bedtime Snack and nighttime\"","v":"AM Snack, Bedtime Snack and nighttime"}]
[null,{"$f":"\"Daytime Rule = \" & 'Roadmap Step 1--Enter data'!B42 & \" \" & 'Roadmap Step 1--Enter data'!C42 & \" \" & 'Roadmap Step 1--Enter data'!D42 & \" \" & 'Roadmap Step 1--Enter data'!E42 & \" >\" & 'Roadmap Step 1--Enter data'!E47","v":"Daytime Rule = 1 Unit per 100 >150"},null,null,null,null,null,{"$f":"\"Nighttime Rule = \" & 'Roadmap Step 1--Enter data'!B42 & \" \" & 'Roadmap Step 1--Enter data'!C42 & \" \" & 'Roadmap Step 1--Enter data'!D42 & \" \" & 'Roadmap Step 1--Enter data'!E42 & \" >\" & 'Roadmap Step 1--Enter data'!E50","v":"Nighttime Rule = 1 Unit per 100 >200"}]
[]
[null,"Blood Glucose",null,null,{"$f":"'Roadmap Step 1--Enter data'!B11","v":"Novolog"},null,null,"Blood Glucose",null,null,{"$f":"'Roadmap Step 1--Enter data'!B11","v":"Novolog"}]
[null,"Below",null,{"$f":"'Roadmap Step 1--Enter data'!C47","v":80},"See hypoglycemia road map",null,null,"Below",null,{"$f":"'Roadmap Step 1--Enter data'!C50","v":80},"See hypoglycemia road map"]
[null,{"$f":"D22","v":80},"to",{"$f":"B24-1","v":149},"Carb coverage dose only",null,null,{"$f":"J22","v":80},"to",{"$f":"H24-1","v":199},"Carb coverage dose only"]
[null,{"$f":"'Roadmap Step 1--Enter data'!E47","v":150},"to",{"$f":"IF(C24=\"+\", \"\", B24+'Roadmap Step 1--Enter data'!E42-1)","v":249},{"$f":"IF(B24=\"\", \"\", IF(B24>499,\"CALL MD\",\"+\" & 1*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+1 unit"},null,null,{"$f":"'Roadmap Step 1--Enter data'!E50","v":200},"to",{"$f":"IF(I24=\"+\", \"\", H24+'Roadmap Step 1--Enter data'!E42-1)","v":299},{"$f":"IF(H24=\"\", \"\", IF(H24>499,\"CALL MD\",\"+\" & 1*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+1 unit"}]
[null,{"$f":"IF(B24<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42,\"\")","v":250},{"$f":"IF(AND(B25<>\"\",B25>499), \"+\", IF(B25=\"\", \"\", \"to\"))","v":"to"},{"$f":"IF(C25=\"+\", \"\", IF(C25=\"to\", B25+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":349},{"$f":"IF(B25=\"\", \"\", IF(B25>499,\"CALL MD\",\"+\" & 2*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+2 unit"},null,null,{"$f":"IF(H24<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42,\"\")","v":300},{"$f":"IF(AND(H25<>\"\",H25>499), \"+\", IF(H25=\"\", \"\", \"to\"))","v":"to"},{"$f":"IF(I25=\"+\", \"\", IF(I25=\"to\", H25+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":399},{"$f":"IF(H25=\"\", \"\", IF(H25>499,\"CALL MD\",\"+\" & 2*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+2 unit"}]
[null,{"$f":"IF(B25<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*2,\"\")","v":350},"to",{"$f":"IF(C26=\"+\", \"\", IF(C26=\"to\", B26+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":449},{"$f":"IF(B26=\"\", \"\", IF(B26>499,\"CALL MD\",\"+\" & 3*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+3 unit"},null,null,{"$f":"IF(H25<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*2,\"\")","v":400},"to",{"$f":"IF(I26=\"+\", \"\", IF(I26=\"to\", H26+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":499},{"$f":"IF(H26=\"\", \"\", IF(H26>499,\"CALL MD\",\"+\" & 3*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+3 unit"}]
[null,{"$f":"IF(B26<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*3,\"\")","v":450},"to",{"$f":"IF(C27=\"+\", \"\", IF(C27=\"to\", B27+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":549},{"$f":"IF(B27=\"\", \"\", IF(B27>499,\"CALL MD\",\"+\" & 4*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"+4 unit"},null,null,{"$f":"IF(H26<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*3,\"\")","v":500},"+",{"$f":"IF(I27=\"+\", \"\", IF(I27=\"to\", H27+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H27=\"\", \"\", IF(H27>499,\"CALL MD\",\"+\" & 4*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"CALL MD"}]
[null,{"$f":"IF(B27<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*4,\"\")","v":550},"+",{"$f":"IF(C28=\"+\", \"\", IF(C28=\"to\", B28+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B28=\"\", \"\", IF(B28>499,\"CALL MD\",\"+\" & 5*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":"CALL MD"},null,null,{"$f":"IF(H27<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*4,\"\")","v":""},"",{"$f":"IF(I28=\"+\", \"\", IF(I28=\"to\", H28+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H28=\"\", \"\", IF(H28>499,\"CALL MD\",\"+\" & 5*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B28<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*5,\"\")","v":""},"",{"$f":"IF(C29=\"+\", \"\", IF(C29=\"to\", B29+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B29=\"\", \"\", IF(B29>499,\"CALL MD\",\"+\" & 6*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H28<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*5,\"\")","v":""},"",{"$f":"IF(I29=\"+\", \"\", IF(I29=\"to\", H29+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H29=\"\", \"\", IF(H29>499,\"CALL MD\",\"+\" & 6*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B29<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*6,\"\")","v":""},"",{"$f":"IF(C30=\"+\", \"\", IF(C30=\"to\", B30+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B30=\"\", \"\", IF(B30>499,\"CALL MD\",\"+\" & 7*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H29<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*6,\"\")","v":""},"",{"$f":"IF(I30=\"+\", \"\", IF(I30=\"to\", H30+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H30=\"\", \"\", IF(H30>499,\"CALL MD\",\"+\" & 7*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B30<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*7,\"\")","v":""},"",{"$f":"IF(C31=\"+\", \"\", IF(C31=\"to\", B31+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B31=\"\", \"\", IF(B31>499,\"CALL MD\",\"+\" & 8*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H30<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*7,\"\")","v":""},"",{"$f":"IF(I31=\"+\", \"\", IF(I31=\"to\", H31+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H31=\"\", \"\", IF(H31>499,\"CALL MD\",\"+\" & 8*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B31<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*8,\"\")","v":""},"",{"$f":"IF(C32=\"+\", \"\", IF(C32=\"to\", B32+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B32=\"\", \"\", IF(B32>499,\"CALL MD\",\"+\" & 9*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H31<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*8,\"\")","v":""},"",{"$f":"IF(I32=\"+\", \"\", IF(I32=\"to\", H32+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H32=\"\", \"\", IF(H32>499,\"CALL MD\",\"+\" & 9*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B32<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*9,\"\")","v":""},{"$f":"IF(AND(B33<>\"\",B33>499), \"+\",  IF(B33=\"\", \"\", \"to\"))","v":""},{"$f":"IF(C33=\"+\", \"\", IF(C33=\"to\", B33+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B33=\"\", \"\", IF(B33>499,\"CALL MD\",\"+\" & 10*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H32<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*9,\"\")","v":""},"",{"$f":"IF(I33=\"+\", \"\", IF(I33=\"to\", H33+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H33=\"\", \"\", IF(H33>499,\"CALL MD\",\"+\" & 10*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B33<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*10,\"\")","v":""},{"$f":"IF(AND(B34<>\"\",B34>499), \"+\",  IF(B34=\"\", \"\", \"to\"))","v":""},{"$f":"IF(C34=\"+\", \"\", IF(C34=\"to\", B34+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B34=\"\", \"\", IF(B34>499,\"CALL MD\",\"+\" & 11*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H33<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*10,\"\")","v":""},"",{"$f":"IF(I34=\"+\", \"\", IF(I34=\"to\", H34+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H34=\"\", \"\", IF(H34>499,\"CALL MD\",\"+\" & 11*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B34<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*11,\"\")","v":""},{"$f":"IF(AND(B35<>\"\",B35>499), \"+\", IF(B35=\"\", \"\", \"to\"))","v":""},{"$f":"IF(C35=\"+\", \"\", IF(C35=\"to\", B35+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B35=\"\", \"\", IF(B35>499,\"CALL MD\",\"+\" & 12*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H34<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*11,\"\")","v":""},"",{"$f":"IF(I35=\"+\", \"\", IF(I35=\"to\", H35+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H35=\"\", \"\", IF(H35>499,\"CALL MD\",\"+\" & 12*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B35<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*12,\"\")","v":""},{"$f":"IF(AND(B36<>\"\",B36>499), \"+\", IF(B36=\"\", \"\", \"to\"))","v":""},{"$f":"IF(C36=\"+\", \"\", IF(C36=\"to\", B36+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B36=\"\", \"\", IF(B36>499,\"CALL MD\",\"+\" & 13*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H35<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*12,\"\")","v":""},"",{"$f":"IF(I36=\"+\", \"\", IF(I36=\"to\", H36+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H36=\"\", \"\", IF(H36>499,\"CALL MD\",\"+\" & 13*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B36<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*13,\"\")","v":""},{"$f":"IF(AND(B37<>\"\",B37>499), \"+\",  IF(B37=\"\", \"\", \"to\"))","v":""},{"$f":"IF(C37=\"+\", \"\", IF(C37=\"to\", B37+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B37=\"\", \"\", IF(B37>499,\"CALL MD\",\"+\" & 14*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H36<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*13,\"\")","v":""},"",{"$f":"IF(I37=\"+\", \"\", IF(I37=\"to\", H37+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H37=\"\", \"\", IF(H37>499,\"CALL MD\",\"+\" & 14*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B37<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*14,\"\")","v":""},{"$f":"IF(AND(B38<>\"\",B38>499),\"+\", IF(B38=\"\", \"\", \"to\"))","v":""},{"$f":"IF(C38=\"+\", \"\", IF(C38=\"to\", B38+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(B38=\"\", \"\", IF(B38>499,\"CALL MD\",\"+\" & 15*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""},null,null,{"$f":"IF(H37<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*14,\"\")","v":""},"",{"$f":"IF(I38=\"+\", \"\", IF(I38=\"to\", H38+'Roadmap Step 1--Enter data'!E42-1,\"\"))","v":""},{"$f":"IF(H38=\"\", \"\", IF(H38>499,\"CALL MD\",\"+\" & 15*'Roadmap Step 1--Enter data'!B42 & \" unit\"))","v":""}]
[null,{"$f":"IF(B38<500,'Roadmap Step 1--Enter data'!E47+'Roadmap Step 1--Enter data'!E42*15,\"\")","v":""},{"$f":"IF(B39<>\"\", \"+\", \"\")","v":""},null,{"$f":"IF(B39=\"\", \"\", \"CALL MD\")","v":""},null,null,{"$f":"IF(H38<500,'Roadmap Step 1--Enter data'!E50+'Roadmap Step 1--Enter data'!E42*15,\"\")","v":""},{"$f":"IF(H39<>\"\", \"+\", \"\")","v":""},null,{"$f":"IF(H39=\"\", \"\", \"CALL MD\")","v":""}]
[]
[]
[{"$f":"\"Additional comments: \" & 'Roadmap Step 1--Enter data'!B58","v":"Additional comments: "}]
[]
[]
[]
[]
[null,"Time to Wait Between Shot and Eating ",null,null,null,null,null,"Check Urine for Ketones when:"]
[null,"Under 100",null,"0 minutes",null,null,"1. Blood sugar above 240"]
[null,"100 - 149",null,"5 minutes",null,null,"2. Every time your child goes to bathroom when sick"]
[null,"150 - 199",null,"10 minutes",null,null,"3. Call the Diabetes Center when your child has"]
[null,"200 - 249",null,"15 minutes",null,null,null,"moderate or large ketones"]
[null,"250 - 299",null,"20 minutes"]
[null,"300 or OVER",null,"25 minutes"]
[]
[]
[null,null,null,null,null,"Prepared by:"]

{"sheet":"Roadmap Step3--Print","index":4,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[22,2,22,3],[0,0,0,4],[1,0,1,4],[14,3,15,3],[6,0,10,0],[11,0,15,0],[9,1,10,1],[9,2,10,2],[11,3,13,3],[4,0,5,0],[11,1,13,1],[11,2,13,2],[9,3,10,3],[31,0,31,1],[14,1,15,1],[14,2,15,2],[17,1,17,3],[6,1,8,1],[6,2,8,2],[6,3,8,3],[26,2,26,3],[27,2,27,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3]]}
[{"$f":"'Roadmap Step 1--Enter data'!B8 & \"'s Hypoglycemia (low blood sugar) Road Map\"","v":"'s Hypoglycemia (low blood sugar) Road Map"}]
[{"$f":"NOW()","v":"2020-09-14T09:39:01.960"}]
[]
["Blood Sugar","Time of Test","Grams of carbs to eat","Retest Blood sugar in 15-20 minutes","What to do next"]
[{"$f":"'Roadmap Step 1--Enter data'!E52+1 & \" - \" & 'Roadmap Step 1--Enter data'!C50","v":"61 - 80"},"Before a meal or snack","No extra needed","No",{"$f":"\"Eat and give shot. Subtract \"& 'Roadmap Step 1--Enter data'!B42 & \" unit insulin for carb coverage.\"","v":"Eat and give shot. Subtract 1 unit insulin for carb coverage."}]
[null,"Between meals, before bedtime snack, or overnight","8 gm complex carbs","No","Nothing more needed."]
[{"$f":"\"46 - \" & 'Roadmap Step 1--Enter data'!E52","v":"46 - 60"},"Before a meal or snack","15 gm fast-acting carbs","Yes",{"$f":"\"If blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \" and shot time, give shot and eat meal.\"","v":"If blood sugar greater than 60 and shot time, give shot and eat meal."}]
[null,null,null,null,{"$f":"\"If blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \" and NOT shot time, eat meal meal only.\"","v":"If blood sugar greater than 60 and NOT shot time, eat meal meal only."}]
[null,null,null,null,{"$f":"\"If blood sugar less than \" & 'Roadmap Step 1--Enter data'!E52 & \", repeat \" & C7 & \" and retest in another 15-20 minutes. Once blood sugar is more than \" & 'Roadmap Step 1--Enter data'!E52 & \", eat and give shot if appropriate.\"","v":"If blood sugar less than 60, repeat 15 gm fast-acting carbs and retest in another 15-20 minutes. Once blood sugar is more than 60, eat and give shot if appropriate."}]
[null,"Between meals, before bedtime snack, or overnight","15 gm fast-acting carbs","Yes",{"$f":"\"If blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \", give 8 gm fast-acting carbs.\"","v":"If blood sugar greater than 60, give 8 gm fast-acting carbs."}]
[null,null,null,null,{"$f":"\"If blood sugar less than \" & 'Roadmap Step 1--Enter data'!E52 & \", give another \" & C10 & \" carbs, then retest in 15-20 minutes.\"","v":"If blood sugar less than 60, give another 15 gm fast-acting carbs carbs, then retest in 15-20 minutes."}]
["0 - 45","Before a meal or snack","22 gm fast-acting carbs","Yes",{"$f":"\"If blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \" and shot time, give shot and eat meal.\"","v":"If blood sugar greater than 60 and shot time, give shot and eat meal."}]
[null,null,null,null,{"$f":"\"If blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \" and NOT shot time, eat meal only.\"","v":"If blood sugar greater than 60 and NOT shot time, eat meal only."}]
[null,null,null,null,{"$f":"\"If blood sugar less than \" & 'Roadmap Step 1--Enter data'!E52 & \", give another 15-22 gm fast-acting carbs, then retest in 15-20 minutes. Once blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \", eat and give shot if appropriate.\"","v":"If blood sugar less than 60, give another 15-22 gm fast-acting carbs, then retest in 15-20 minutes. Once blood sugar greater than 60, eat and give shot if appropriate."}]
[null,"Between meals, before bedtime snack, or overnight","22 gm fast-acting carbs","Yes",{"$f":"\"If blood sugar greater than \" & 'Roadmap Step 1--Enter data'!E52 & \", give 8 gm fast-acting carbs.\"","v":"If blood sugar greater than 60, give 8 gm fast-acting carbs."}]
[null,null,null,null,{"$f":"\"If blood sugar less than \" & 'Roadmap Step 1--Enter data'!E52 & \", give another 15-22 gm fast-acting carbs, then retest in 15-20 minutes.\"","v":"If blood sugar less than 60, give another 15-22 gm fast-acting carbs, then retest in 15-20 minutes."}]
[]
[null,"Examples of fast-acting carbs to treat low blood sugar:",null,null,"Examples of complex carbs:"]
[null,"15 Grams (1 Carb)","22 Grams (1 and 1/2 Carb)",null,"8 gm (1/2 Carb)"]
[null,"4 oz apple or orange juice","6 oz apple or orange juice",null,"4 oz milk"]
[null,"3 oz grape juice","4 and 1/2 oz grape juice",null,"2 oz ice cream"]
[null,"4 teaspoons sugar","6 teaspoons sugar"]
[null,"1 tablespoon honey","1 and 1/2 tablespoon honey"]
[null,"4 tablets DEX 4","6 tablets DEX 4"]
[null,"3 BD Glucose tabs","4-5 BD Glucose tabs"]
[null,"5-6 oz regular soda","7-8 oz regular soda"]
[null,"1 tablespoon chocolate syrup (full strength)","1 and 1/2 tablespoon chocolate syrup (full strength)"]
[null,"1 tablespoon maple syrup (full strength)","1 and 1/2 tablespoon maple syrup (full strength)"]
[]
[]
[]
["If unarousable or seizures:",null,{"$f":"\"Give \" & 'Roadmap Step 1--Enter data'!E56 & \" mg GLUCAGON\"","v":"Give 1 mg GLUCAGON"}]