{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["X Ward Bed Unavailable","Ward Bed Unavailable","Canc Ops"],"not_rendered":{"charts":3,"external_links":1,"defined_names":1},"unopened":[{"sheet":"X Ward Bed Unavailable","index":0,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Ward Bed Unavailable","index":1,"n_rows":25,"n_cols":18,"rows_kept":25}
["Month","Ward Bed Unavailable","UCL"," +2 Sigma"," +1 Sigma","Average"," -1 Sigma"," -2 Sigma","LCL","LastCell","Range","UCL"," +2 Sigma"," +1 Sigma","Average"," -1 Sigma"," -2 Sigma","LCL"]
["Apr-11",{"v":33,"d":"33."},{"$f":"F2+2.66*O2","v":{"v":48.38361111111111,"d":"48."}},{"$f":"F2+(2/3)*2.66*O2","v":{"v":40.29277777777778,"d":"40."}},{"$f":"F2+(1/3)*2.66*O2","v":{"v":32.20194444444444,"d":"32."}},{"$f":"AVERAGE($B$2:$B$10)","v":{"v":24.11111111111111,"d":"24."}},{"$f":"F2-(1/3)*2.66*O2","v":{"v":16.02027777777778,"d":"16."}},{"$f":"F2-(2/3)*2.66*O2","v":{"v":7.929444444444442,"d":"8."}},{"$f":"F2-2.66*O2","v":{"v":-0.16138888888889014,"d":"-0."}},{"$f":"B2","v":33},{"$nulls":4},{"$f":"AVERAGE($K$2:$K$10)","v":{"v":9.125,"d":"9."}}]
["May-11",{"v":18,"d":"18."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},{"$f":"IF(ISBLANK(B3),OFFSET(J3,-1,0,1,1),B3)","v":18},{"$f":"IF(OR(OFFSET(K3,-1,-9,1,1)=\"\",OFFSET(K3,0,-9,1,1)=\"\"),\"\",IF(ISERROR(ABS(B3-OFFSET(K3,-1,-1,1,1))),\"\",ABS(B3-OFFSET(K3,-1,-1,1,1))))","v":{"v":15,"d":"15."}},{"$f":"3.267*O3","v":{"v":29.811374999999998,"d":"30."}},{"$f":"(2/3)*(L3-O3)+O3","v":{"v":22.915916666666664,"d":"23."}},{"$f":"(1/3)*(L3-O3)+O3","v":{"v":16.02045833333333,"d":"16."}},{"v":9.125,"d":"9."},{"$f":"(MAX(O3-(1/3)*(L3-O3),0))","v":{"v":2.229541666666668,"d":"2."}},{"$f":"MAX(O3-(2/3)*(L3-O3),0)","v":{"v":0,"d":"0."}},{"v":0,"d":"0."}]
["Jun-11",{"v":16,"d":"16."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},16,{"v":2,"d":"2."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Jul-11",{"v":7,"d":"7."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},7,{"v":9,"d":"9."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Aug-11",{"v":2,"d":"2."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},2,{"v":5,"d":"5."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Sep-11",{"v":27,"d":"27."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},27,{"v":25,"d":"25."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Oct-11",{"v":35,"d":"35."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},35,{"v":8,"d":"8."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Nov-11",{"v":35,"d":"35."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},35,{"v":0,"d":"0."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Dec-11",{"v":44,"d":"44."},{"v":48.38361111111111,"d":"48."},{"v":40.29277777777778,"d":"40."},{"v":32.20194444444444,"d":"32."},{"v":24.11111111111111,"d":"24."},{"v":16.02027777777778,"d":"16."},{"v":7.929444444444442,"d":"8."},{"v":-0.16138888888889014,"d":"-0."},44,{"v":9,"d":"9."},{"v":29.811374999999998,"d":"30."},{"v":22.915916666666664,"d":"23."},{"v":16.02045833333333,"d":"16."},{"v":9.125,"d":"9."},{"v":2.229541666666668,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Jan-12",{"v":123,"d":"123."},{"v":99.54333333333334,"d":"100."},{"v":90.52888888888889,"d":"91."},{"v":81.51444444444445,"d":"82."},{"$f":"AVERAGE($B$11:$B$14)","v":{"v":72.5,"d":"73."}},{"v":63.48555555555556,"d":"63."},{"v":54.471111111111114,"d":"54."},{"v":45.45666666666666,"d":"45."},123,{"v":79,"d":"79."},{"v":33.214499999999994,"d":"33."},{"v":25.531888888888886,"d":"26."},{"v":17.849277777777775,"d":"18."},{"$f":"AVERAGE($K$13:$K$24)","v":{"v":10.166666666666666,"d":"10."}},{"v":2.484055555555557,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Feb-12",{"v":65,"d":"65."},{"v":99.54333333333334,"d":"100."},{"v":90.52888888888889,"d":"91."},{"v":81.51444444444445,"d":"82."},{"v":72.5,"d":"73."},{"v":63.48555555555556,"d":"63."},{"v":54.471111111111114,"d":"54."},{"v":45.45666666666666,"d":"45."},65,{"v":58,"d":"58."},{"v":33.214499999999994,"d":"33."},{"v":25.531888888888886,"d":"26."},{"v":17.849277777777775,"d":"18."},{"v":10.166666666666666,"d":"10."},{"v":2.484055555555557,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Mar-12",{"v":54,"d":"54."},{"v":95.11,"d":"95."},{"v":87.57333333333334,"d":"88."},{"v":80.03666666666666,"d":"80."},{"v":72.5,"d":"73."},{"v":64.96333333333334,"d":"65."},{"v":57.42666666666666,"d":"57."},{"v":49.89,"d":"50."},54,{"v":11,"d":"11."},{"v":27.7695,"d":"28."},{"v":21.346333333333334,"d":"21."},{"v":14.923166666666667,"d":"15."},{"$f":"AVERAGE($K$13:$K$14)","v":{"v":8.5,"d":"9."}},{"v":2.076833333333333,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Apr-12",{"v":48,"d":"48."},{"v":95.11,"d":"95."},{"v":87.57333333333334,"d":"88."},{"v":80.03666666666666,"d":"80."},{"v":72.5,"d":"73."},{"v":64.96333333333334,"d":"65."},{"v":57.42666666666666,"d":"57."},{"v":49.89,"d":"50."},48,{"v":6,"d":"6."},{"v":27.7695,"d":"28."},{"v":21.346333333333334,"d":"21."},{"v":14.923166666666667,"d":"15."},{"v":8.5,"d":"9."},{"v":2.076833333333333,"d":"2."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["May-12",{"v":9,"d":"9."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"$f":"AVERAGE($B$15:$B$24)","v":{"v":9.4,"d":"9."}},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},9,{"v":39,"d":"39."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"$f":"AVERAGE($K$15:$K$24)","v":{"v":10.5,"d":"11."}},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Jun-12",{"v":6,"d":"6."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},6,{"v":3,"d":"3."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Jul-12",{"v":15,"d":"15."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},15,{"v":9,"d":"9."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Aug-12",{"v":1,"d":"1."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},1,{"v":14,"d":"14."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Sep-12",{"v":5,"d":"5."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},5,{"v":4,"d":"4."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Oct-12",{"v":24,"d":"24."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},24,{"v":19,"d":"19."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Nov-12",{"v":11,"d":"11."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},11,{"v":13,"d":"13."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Dec-12",{"v":8,"d":"8."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},8,{"v":3,"d":"3."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Jan-13",{"v":8,"d":"8."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},8,{"v":0,"d":"0."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["Feb-13",{"v":7,"d":"7."},{"v":37.33,"d":"37."},{"v":28.020000000000003,"d":"28."},{"v":18.71,"d":"19."},{"v":9.4,"d":"9."},{"v":0.08999999999999986,"d":"0."},{"v":-9.22,"d":"-9."},{"v":0,"d":"0."},7,{"v":1,"d":"1."},{"v":34.3035,"d":"34."},{"v":26.369,"d":"26."},{"v":18.4345,"d":"18."},{"v":10.5,"d":"11."},{"v":2.5655,"d":"3."},{"v":0,"d":"0."},{"v":0,"d":"0."}]
["2013-03-01",{"v":10,"d":"10."},{"$f":"F25+2.66*O25","v":{"v":37.33,"d":"37."}},{"$f":"F25+(2/3)*2.66*O25","v":{"v":28.020000000000003,"d":"28."}},{"$f":"F25+(1/3)*2.66*O25","v":{"v":18.71,"d":"19."}},{"v":9.4,"d":"9."},{"$f":"F25-(1/3)*2.66*O25","v":{"v":0.08999999999999986,"d":"0."}},{"$f":"F25-(2/3)*2.66*O25","v":{"v":-9.22,"d":"-9."}},{"v":1,"d":"1."},{"$f":"IF(ISBLANK(B25),OFFSET(J25,-1,0,1,1),B25)","v":10},{"$f":"IF(OR(OFFSET(K25,-1,-9,1,1)=\"\",OFFSET(K25,0,-9,1,1)=\"\"),\"\",IF(ISERROR(ABS(B25-OFFSET(K25,-1,-1,1,1))),\"\",ABS(B25-OFFSET(K25,-1,-1,1,1))))","v":{"v":3,"d":"3."}},{"$f":"3.267*O25","v":{"v":34.3035,"d":"34."}},{"$f":"(2/3)*(L25-O25)+O25","v":{"v":26.369,"d":"26."}},{"$f":"(1/3)*(L25-O25)+O25","v":{"v":18.4345,"d":"18."}},{"v":10.5,"d":"11."},{"$f":"(MAX(O25-(1/3)*(L25-O25),0))","v":{"v":2.5655,"d":"3."}},{"$f":"MAX(O25-(2/3)*(L25-O25),0)","v":{"v":0,"d":"0."}},{"v":1,"d":"1."}]

{"sheet":"Canc Ops","index":2,"n_rows":28,"n_cols":3,"rows_kept":28}
["Reason","% of Operations cancelled (Total)","% of Operations cancelled  (on the day)"]
["Jan-11",{"v":0.08384374574656323,"d":"8.4%"},{"v":0.018783176806859942,"d":"1.88%"}]
["Feb-11",{"v":0.06114346214928534,"d":"6.1%"},{"v":0.019587083112758072,"d":"1.96%"}]
["Mar-11",{"v":0.06221906789685356,"d":"6.2%"},{"v":0.021764845043766263,"d":"2.18%"}]
["Apr-11",{"v":0.044178486997635935,"d":"4.4%"},{"v":0.012411347517730497,"d":"1.24%"}]
["May-11",{"v":0.04636205279378266,"d":"4.6%"},{"v":0.011925499129036581,"d":"1.19%"}]
["Jun-11",{"v":0.050012956724540036,"d":"5.0%"},{"v":0.012956724540036279,"d":"1.30%"}]
["Jul-11",{"v":0.062238986932507075,"d":"6.2%"},{"v":0.011989761551933181,"d":"1.20%"}]
["Aug-11",{"v":0.05292248169130855,"d":"5.3%"},{"v":0.013403343927041593,"d":"1.34%"}]
["Sep-11",{"v":0.06266141090118255,"d":"6.3%"},{"v":0.014543971727606362,"d":"1.45%"}]
["Oct-11",{"v":0.05730103806228374,"d":"5.7%"},{"v":0.01439446366782007,"d":"1.44%"}]
["Nov-11",{"v":0.06050995813776481,"d":"6.1%"},{"v":0.017252315108461244,"d":"1.73%"}]
["Dec-11",{"v":0.06125754675305552,"d":"6.1%"},{"v":0.016492416433514945,"d":"1.65%"}]
["Jan-12",{"v":0.09815710364658214,"d":"9.82%"},{"v":0.022088615867206902,"d":"2.21%"}]
["Feb-12",{"v":0.10895522388059702,"d":"10.90%"},{"v":0.015603799185888738,"d":"1.56%"}]
["Mar-12",{"v":0.09439124487004104,"d":"9.44%"},{"v":0.01678895659743813,"d":"1.68%"}]
["Apr-12",{"v":0.06794703913865852,"d":"6.79%"},{"v":0.015859159028080896,"d":"1.59%"}]
["May-12",{"v":0.03124630133743638,"d":"3.12%"},{"v":0.01219079180968162,"d":"1.22%"}]
["Jun-12",{"v":0.029735062006764373,"d":"2.97%"},{"v":0.010428410372040587,"d":"1.04%"}]
["Jul-12",{"v":0.0343374240733854,"d":"3.43%"},{"v":0.008677327383165985,"d":"0.87%"}]
["Aug-12",{"v":0.02451508620689655,"d":"2.45%"},{"v":0.007677801724137931,"d":"0.77%"}]
["Sep-12",{"v":0.023413788119670473,"d":"2.34%"},{"v":9.538950715421303E-3,"d":"0.95%"}]
["2012-10-01",{"v":0.028116907140214576,"d":"2.81%"},{"v":0.013318534961154272,"d":"1.33%"}]
["2012-11-01",{"v":0.029050574409084907,"d":"2.91%"},{"v":0.010299749108675559,"d":"1.03%"}]
["2012-12-01",{"v":0.02568602425015954,"d":"2.57%"},{"v":0.008774728781110403,"d":"0.88%"}]
["2013-01-01",{"v":0.027037773359840953,"d":"2.70%"},{"v":0.00781974817760106,"d":"0.78%"}]
["2013-02-01",{"v":0.030771453337185783,"d":"3.08%"},{"v":0.009534816527015313,"d":"0.95%"}]
["2013-03-01",{"v":0.02568905539202569,"d":"2.57%"},{"v":0.008295424137008296,"d":"0.83%"}]