{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Composite Calculator"],"not_rendered":{"charts":0,"images":10,"macros":1,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Composite Calculator","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[17,0,20,6],[4,7,4,8]]}
["Composite Score Calculator"]
["Measure Description","Current Numerator","Denominator","Facility Composite  Percentage",null,"Recalculated Facility Composite Percentage","Percent of Change from Current Numerator to Desired Goal Numerator","Current Numerator Reduction Goal to Reach 6.00 Composite Score","Desired Goal Numerator Reduction  to Reach 6.00 Composite Score"]
["SR Mod/Severe Pain (L)",null,null,{"$f":"IFERROR(((B3/C3)),0)","v":0},null,{"$f":"IFERROR((E3/C3),0)","v":0},{"$f":"IFERROR(((F3-D3)/D3),0)","v":0},{"$f":"IF(B3:B15=\"\",\"\",B16-(ROUND((C16*0.06),1)))","v":""},{"$f":"IF(E3:E15=\"\",\"\",E16-(ROUND((C16*0.06),1)))","v":""}]
["Hi-risk Pres Ulcer (L)",null,null,{"$f":"IFERROR(((B4/C4)),0)","v":0},null,{"$f":"IFERROR((E4/C4),0)","v":0},{"$f":"IFERROR(((F4-D4)/D4),0)","v":0}]
["Phys Restraints (L)",null,null,0,null,0,0,"Color Coding Definitions"]
["Falls w/Maj Injury (L)",null,null,0,null,0,0,"Highlighted Color","Composite Range"]
["Antipsyc Med (L)",null,null,0,null,0,0,null,"0.00-6.00"]
["Depress Sx (L)",null,null,0,null,0,0,null,"6.01-7.00"]
["UTI (L)",null,null,0,null,0,0,null,"7.01 or higher"]
["Cath Insert/Left Bladder (L)",null,null,0,null,0,0]
["Lo-Risk Lose B/B Con (L)",null,null,0,null,0,0]
["Excess Wt Loss (L)",null,null,0,null,0,0]
["Incr ADL Help (L)",null,null,0,null,0,0]
["Influenza Vaccine^",null,null,0,null,0,0]
["Pneumococcal Vaccine^",null,null,0,null,0,0]
["Composite",{"$f":"SUM(B3:B15)","v":0},{"$f":"SUM(C3:C15)","v":0},{"$f":"IFERROR(((B16/C16)*100),0)","v":0},{"$f":"SUM(E3:E15)","v":0},{"$f":"IFERROR(((E16/C16)*100),0)","v":0},0]
["Updated 08/24/2015"]
["This material was prepared by the Great Plains Quality Innovation Network, the Medicare Quality Improvement Organization for Kansas, Nebraska, North Dakota and South Dakota, under contract with the Centers for Medicare & Medicaid Services (CMS), an agency of the U.S. Department of Health and Human Services. The contents presented do not necessarily reflect CMS policy. 11SOW-GPQIN-KS-C2-57/0815"]
[]
[]
[]
[]
["^Obtain the Influenza and the Pneumococcal vaccine information from your QIO contact."]
[]
["https://www.youtube.com/watch?v=ZLhVJEmzvuY&feature=youtu.be"]