{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data","Pivot","Temp","Summary"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":2},"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":"Data","index":0,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,5,1,6],[1,7,1,8]]}
[]
[null,null,null,"Acute",null,"PRC",null,"OP"]
[null,"Table1",null,"Hrs","Units","Hrs","Units","Hrs","Units"]
[null,"NName","DDate","Acute;Hrs","Acute;Units","PRC;Hrs","PRC;Units","OP;Hrs","OP;Units"]
[null,"James","2011-11-10","21:31:37.209",96,"05:00:02.528",75,"02:40:48.715",83]
[null,"James","2011-11-13","18:59:49.766",87,"09:33:47.950",59,"23:18:59.276",45]
[null,"James","2011-11-21","04:24:15.543",14,"20:15:36.925",27,"21:52:04.226",84]
[null,"James","2011-12-03","21:41:44.218",58,"17:51:53.151",70,"01:55:50.816",14]
[null,"James","2011-12-31","11:13:18.589",50,"02:12:42.340",65,"02:48:16.548",21]
[null,"James","2012-01-15","13:23:51.822",94,"13:52:11.278",57,"01:31:20.871",48]
[null,"James","2012-02-08","06:29:51.726",63,"17:32:44.976",72,"21:43:07.622",67]
[null,"James","2012-02-21","10:15:52.892",44,"14:18:17.666",45,"02:10:41.265",35]
[null,"John","2011-11-22","02:35:25.562",62,"14:34:01.567",78,"13:46:10.546",30]
[null,"John","2011-11-26","19:02:32.762",98,"08:29:22.093",13,"03:19:43.129",19]
[null,"John","2011-12-06","11:35:59.217",44,"06:11:02.624",68,"17:09:41.155",15]
[null,"John","2011-12-15","10:52:51.945",94,"02:52:01.917",10,"01:14:43.768",81]
[null,"John","2011-12-19","07:58:20.381",60,"22:13:58.325",20,"09:48:03.045",81]
[null,"John","2012-02-10","11:11:14.995",38,"13:09:49.627",95,"09:18:31.533",74]
[null,"John","2012-02-25","00:10:31.074",94,"19:03:38.045",95,"05:07:09.522",89]
[null,"Michael","2011-11-16","20:59:02.377",43,"04:13:32.106",74,"00:53:39.941",47]
[null,"Michael","2011-11-29","06:24:27.656",29,"11:48:28.629",90,"10:50:25.066",15]
[null,"Michael","2011-12-16","04:41:35.298",26,"18:45:49.529",14,"01:11:52.407",92]
[null,"Michael","2012-01-25","23:01:07.287",58,"13:12:58.287",32,"17:19:11.456",83]
[null,"Michael","2012-01-26","09:05:29.658",14,"13:52:42.840",78,"12:27:02.875",59]
[null,"Michael","2012-02-15","04:09:53.379",62,"16:53:30.426",33,"16:53:42.439",71]
[null,"Michael","2012-02-23","23:50:03.135",53,"15:42:07.913",94,"00:44:35.953",46]
[null,"Robert","2011-11-19","21:37:05.119",63,"18:34:52.256",22,"21:28:02.354",80]
[null,"Robert","2011-11-23","12:56:18.509",99,"21:19:26.208",64,"03:30:24.634",43]
[null,"Robert","2011-12-26","10:57:22.599",41,"14:36:08.730",49,"20:32:21.303",34]
[null,"Robert","2012-01-14","02:22:36.728",70,"17:38:38.457",47,"18:01:52.557",15]
[null,"Robert","2012-01-17","18:00:09.920",68,"16:07:07.894",16,"02:19:17.630",33]
[null,"Robert","2012-02-26","02:06:02.285",77,"15:42:39.846",21,"07:43:59.585",13]
[null,"William","2011-11-15","11:55:54.315",89,"14:37:39.162",25,"17:51:45.855",73]
[null,"William","2011-11-20","15:08:10.198",52,"07:35:13.791",60,"01:06:40.857",89]
[null,"William","2012-01-04","09:20:47.764",31,"09:26:16.312",84,"20:32:33.886",17]
[null,"William","2012-01-20","05:51:21.083",74,"01:10:46.887",23,"01:43:29.207",67]
[null,"William","2012-02-05","23:37:12.888",21,"21:49:47.993",64,"02:13:14.397",73]
[null,"William","2012-02-22","16:32:44.621",73,"09:26:22.086",28,"05:03:57.295",18]

{"sheet":"Pivot","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"PivotTable"]
[null,"Count of Value"]
[null,204]

{"sheet":"Temp","index":2,"n_rows":205,"n_cols":5,"rows_kept":205,"cut":false,"hidden":false,"merged":[]}
["NName","DDate","Type","Cat","Val"]
["James","2011-11-10","Acute","Hrs",0.89695601851851858]
["James","2011-11-10","Acute","Units",96]
["James","2011-11-10","PRC","Hrs",0.20836805555555557]
["James","2011-11-10","PRC","Units",75]
["James","2011-11-10","OP","Hrs",0.11167824074074074]
["James","2011-11-10","OP","Units",83]
["James","2011-11-13","Acute","Hrs",0.79155092592592602]
["James","2011-11-13","Acute","Units",87]
["James","2011-11-13","PRC","Hrs",0.39847222222222217]
["James","2011-11-13","PRC","Units",59]
["James","2011-11-13","OP","Hrs",0.97151620370370362]
["James","2011-11-13","OP","Units",45]
["James","2011-11-21","Acute","Hrs",0.18351851851851853]
["James","2011-11-21","Acute","Units",14]
["James","2011-11-21","PRC","Hrs",0.84417824074074066]
["James","2011-11-21","PRC","Units",27]
["James","2011-11-21","OP","Hrs",0.91115740740740747]
["James","2011-11-21","OP","Units",84]
["James","2011-12-03","Acute","Hrs",0.90398148148148139]
["James","2011-12-03","Acute","Units",58]
["James","2011-12-03","PRC","Hrs",0.74436342592592597]
["James","2011-12-03","PRC","Units",70]
["James","2011-12-03","OP","Hrs",8.0451388888888892E-2]
["James","2011-12-03","OP","Units",14]
["James","2011-12-31","Acute","Hrs",0.46758101851851852]
["James","2011-12-31","Acute","Units",50]
["James","2011-12-31","PRC","Hrs",9.2152777777777764E-2]
["James","2011-12-31","PRC","Units",65]
["James","2011-12-31","OP","Hrs",0.11686342592592593]
["James","2011-12-31","OP","Units",21]
["James","2012-01-15","Acute","Hrs",0.5582407407407407]
["James","2012-01-15","Acute","Units",94]
["James","2012-01-15","PRC","Hrs",0.5779050925925926]
["James","2012-01-15","PRC","Units",57]
["James","2012-01-15","OP","Hrs",6.3437499999999994E-2]
["James","2012-01-15","OP","Units",48]
["James","2012-02-08","Acute","Hrs",0.27074074074074073]
["James","2012-02-08","Acute","Units",63]
["James","2012-02-08","PRC","Hrs",0.73107638888888893]
["James","2012-02-08","PRC","Units",72]
["James","2012-02-08","OP","Hrs",0.90495370370370365]
["James","2012-02-08","OP","Units",67]
["James","2012-02-21","Acute","Hrs",0.42769675925925926]
["James","2012-02-21","Acute","Units",44]
["James","2012-02-21","PRC","Hrs",0.59604166666666669]
["James","2012-02-21","PRC","Units",45]
["James","2012-02-21","OP","Hrs",9.0752314814814813E-2]
["James","2012-02-21","OP","Units",35]
["John","2011-11-22","Acute","Hrs",0.10793981481481481]
["John","2011-11-22","Acute","Units",62]
["John","2011-11-22","PRC","Hrs",0.60696759259259259]
["John","2011-11-22","PRC","Units",78]
["John","2011-11-22","OP","Hrs",0.57373842592592594]
["John","2011-11-22","OP","Units",30]
["John","2011-11-26","Acute","Hrs",0.79343750000000002]
["John","2011-11-26","Acute","Units",98]
["John","2011-11-26","PRC","Hrs",0.35372685185185188]
["John","2011-11-26","PRC","Units",13]
["John","2011-11-26","OP","Hrs",0.13869212962962962]
["John","2011-11-26","OP","Units",19]
["John","2011-12-06","Acute","Hrs",0.4833217592592593]
["John","2011-12-06","Acute","Units",44]
["John","2011-12-06","PRC","Hrs",0.25767361111111114]
["John","2011-12-06","PRC","Units",68]
["John","2011-12-06","OP","Hrs",0.71505787037037039]
["John","2011-12-06","OP","Units",15]
["John","2011-12-15","Acute","Hrs",0.45337962962962958]
["John","2011-12-15","Acute","Units",94]
["John","2011-12-15","PRC","Hrs",0.1194675925925926]
["John","2011-12-15","PRC","Units",10]
["John","2011-12-15","OP","Hrs",5.1898148148148145E-2]
["John","2011-12-15","OP","Units",81]
["John","2011-12-19","Acute","Hrs",0.33217592592592593]
["John","2011-12-19","Acute","Units",60]
["John","2011-12-19","PRC","Hrs",0.92636574074074074]
["John","2011-12-19","PRC","Units",20]
["John","2011-12-19","OP","Hrs",0.40836805555555555]
["John","2011-12-19","OP","Units",81]
["John","2012-02-10","Acute","Hrs",0.46614583333333331]
["John","2012-02-10","Acute","Units",38]
["John","2012-02-10","PRC","Hrs",0.54849537037037044]
["John","2012-02-10","PRC","Units",95]
["John","2012-02-10","OP","Hrs",0.38787037037037037]
["John","2012-02-10","OP","Units",74]
["John","2012-02-25","Acute","Hrs",7.3032407407407412E-3]
["John","2012-02-25","Acute","Units",94]
["John","2012-02-25","PRC","Hrs",0.79418981481481488]
["John","2012-02-25","PRC","Units",95]
["John","2012-02-25","OP","Hrs",0.21331018518518519]
["John","2012-02-25","OP","Units",89]
["Michael","2011-11-16","Acute","Hrs",0.87432870370370364]
["Michael","2011-11-16","Acute","Units",43]
["Michael","2011-11-16","PRC","Hrs",0.17606481481481481]
["Michael","2011-11-16","PRC","Units",74]
["Michael","2011-11-16","OP","Hrs",3.7268518518518513E-2]
["Michael","2011-11-16","OP","Units",47]
["Michael","2011-11-29","Acute","Hrs",0.26699074074074075]
["Michael","2011-11-29","Acute","Units",29]
["Michael","2011-11-29","PRC","Hrs",0.49200231481481477]
["Michael","2011-11-29","PRC","Units",90]
["Michael","2011-11-29","OP","Hrs",0.45167824074074076]
["Michael","2011-11-29","OP","Units",15]
["Michael","2011-12-16","Acute","Hrs",0.19554398148148147]
["Michael","2011-12-16","Acute","Units",26]
["Michael","2011-12-16","PRC","Hrs",0.78182870370370372]
["Michael","2011-12-16","PRC","Units",14]
["Michael","2011-12-16","OP","Hrs",4.9907407407407407E-2]
["Michael","2011-12-16","OP","Units",92]
["Michael","2012-01-25","Acute","Hrs",0.9591087962962962]
["Michael","2012-01-25","Acute","Units",58]
["Michael","2012-01-25","PRC","Hrs",0.5506712962962963]
["Michael","2012-01-25","PRC","Units",32]
["Michael","2012-01-25","OP","Hrs",0.72165509259259253]
["Michael","2012-01-25","OP","Units",83]
["Michael","2012-01-26","Acute","Hrs",0.37881944444444443]
["Michael","2012-01-26","Acute","Units",14]
["Michael","2012-01-26","PRC","Hrs",0.57827546296296295]
["Michael","2012-01-26","PRC","Units",78]
["Michael","2012-01-26","OP","Hrs",0.51878472222222227]
["Michael","2012-01-26","OP","Units",59]
["Michael","2012-02-15","Acute","Hrs",0.17353009259259258]
["Michael","2012-02-15","Acute","Units",62]
["Michael","2012-02-15","PRC","Hrs",0.70381944444444444]
["Michael","2012-02-15","PRC","Units",33]
["Michael","2012-02-15","OP","Hrs",0.70395833333333335]
["Michael","2012-02-15","OP","Units",71]
["Michael","2012-02-23","Acute","Hrs",0.99309027777777781]
["Michael","2012-02-23","Acute","Units",53]
["Michael","2012-02-23","PRC","Hrs",0.65425925925925921]
["Michael","2012-02-23","PRC","Units",94]
["Michael","2012-02-23","OP","Hrs",3.0972222222222224E-2]
["Michael","2012-02-23","OP","Units",46]
["Robert","2011-11-19","Acute","Hrs",0.90075231481481488]
["Robert","2011-11-19","Acute","Units",63]
["Robert","2011-11-19","PRC","Hrs",0.77421296296296294]
["Robert","2011-11-19","PRC","Units",22]
["Robert","2011-11-19","OP","Hrs",0.89446759259259256]
["Robert","2011-11-19","OP","Units",80]
["Robert","2011-11-23","Acute","Hrs",0.53910879629629627]
["Robert","2011-11-23","Acute","Units",99]
["Robert","2011-11-23","PRC","Hrs",0.8884953703703703]
["Robert","2011-11-23","PRC","Units",64]
["Robert","2011-11-23","OP","Hrs",0.1461226851851852]
["Robert","2011-11-23","OP","Units",43]
["Robert","2011-12-26","Acute","Hrs",0.45651620370370366]
["Robert","2011-12-26","Acute","Units",41]
["Robert","2011-12-26","PRC","Hrs",0.60843749999999996]
["Robert","2011-12-26","PRC","Units",49]
["Robert","2011-12-26","OP","Hrs",0.85579861111111111]
["Robert","2011-12-26","OP","Units",34]
["Robert","2012-01-14","Acute","Hrs",9.9039351851851851E-2]
["Robert","2012-01-14","Acute","Units",70]
["Robert","2012-01-14","PRC","Hrs",0.73516203703703698]
["Robert","2012-01-14","PRC","Units",47]
["Robert","2012-01-14","OP","Hrs",0.75130787037037028]
["Robert","2012-01-14","OP","Units",15]
["Robert","2012-01-17","Acute","Hrs",0.75011574074074072]
["Robert","2012-01-17","Acute","Units",68]
["Robert","2012-01-17","PRC","Hrs",0.67162037037037037]
["Robert","2012-01-17","PRC","Units",16]
["Robert","2012-01-17","OP","Hrs",9.673611111111112E-2]
["Robert","2012-01-17","OP","Units",33]
["Robert","2012-02-26","Acute","Hrs",8.7523148148148155E-2]
["Robert","2012-02-26","Acute","Units",77]
["Robert","2012-02-26","PRC","Hrs",0.65462962962962956]
["Robert","2012-02-26","PRC","Units",21]
["Robert","2012-02-26","OP","Hrs",0.32222222222222224]
["Robert","2012-02-26","OP","Units",13]
["William","2011-11-15","Acute","Hrs",0.49715277777777778]
["William","2011-11-15","Acute","Units",89]
["William","2011-11-15","PRC","Hrs",0.60947916666666668]
["William","2011-11-15","PRC","Units",25]
["William","2011-11-15","OP","Hrs",0.74428240740740748]
["William","2011-11-15","OP","Units",73]
["William","2011-11-20","Acute","Hrs",0.63067129629629626]
["William","2011-11-20","Acute","Units",52]
["William","2011-11-20","PRC","Hrs",0.31613425925925925]
["William","2011-11-20","PRC","Units",60]
["William","2011-11-20","OP","Hrs",4.6307870370370374E-2]
["William","2011-11-20","OP","Units",89]
["William","2012-01-04","Acute","Hrs",0.38944444444444448]
["William","2012-01-04","Acute","Units",31]
["William","2012-01-04","PRC","Hrs",0.39324074074074072]
["William","2012-01-04","PRC","Units",84]
["William","2012-01-04","OP","Hrs",0.85594907407407417]
["William","2012-01-04","OP","Units",17]
["William","2012-01-20","Acute","Hrs",0.24399305555555553]
["William","2012-01-20","Acute","Units",74]
["William","2012-01-20","PRC","Hrs",4.9155092592592597E-2]
["William","2012-01-20","PRC","Units",23]
["William","2012-01-20","OP","Hrs",7.1863425925925928E-2]
["William","2012-01-20","OP","Units",67]
["William","2012-02-05","Acute","Hrs",0.98417824074074067]
["William","2012-02-05","Acute","Units",21]
["William","2012-02-05","PRC","Hrs",0.9095833333333333]
["William","2012-02-05","PRC","Units",64]
["William","2012-02-05","OP","Hrs",9.2523148148148146E-2]
["William","2012-02-05","OP","Units",73]
["William","2012-02-22","Acute","Hrs",0.6894097222222223]
["William","2012-02-22","Acute","Units",73]
["William","2012-02-22","PRC","Hrs",0.39331018518518518]
["William","2012-02-22","PRC","Units",28]
["William","2012-02-22","OP","Hrs",0.21107638888888888]
["William","2012-02-22","OP","Units",18]

{"sheet":"Summary","index":3,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"PivotTable",null,null,null,null,null,null,null,null,null,null,"PivotChart","Hours"]
[null,"Sum of Val",null,"Years","DDate","Cat"]
[null,null,null,"2011",null,null,null,"2012"]
[null,null,null,"Nov",null,"Dec",null,"Jan",null,"Feb"]
[null,"NName","Type","Hrs","Units","Hrs","Units","Hrs","Units","Hrs","Units"]
[null,"James",null,5.3173958333333333,570,2.4053935185185185,278,1.1995833333333334,199,3.0212615740740745,326]
[null,null,"Acute",1.8720254629629633,197,1.3715625,108,0.5582407407407407,94,0.69843750000000004,107]
[null,null,"OP",1.9943518518518517,212,0.19731481481481483,35,6.3437499999999994E-2,48,0.99570601851851848,102]
[null,null,"PRC",1.4510185185185183,161,0.83651620370370372,135,0.5779050925925926,57,1.3271180555555557,117]
[null,"John",null,2.574502314814815,300,3.7477083333333336,473,null,null,2.4173148148148149,485]
[null,null,"Acute",0.90137731481481487,160,1.2688773148148149,198,null,null,0.47344907407407405,132]
[null,null,"OP",0.71243055555555557,49,1.1753240740740742,177,null,null,0.60118055555555561,163]
[null,null,"PRC",0.96069444444444452,91,1.3035069444444445,98,null,null,1.3426851851851853,190]
[null,"Michael",null,2.2983333333333333,298,1.0272800925925927,132,3.707314814814815,324,3.2596296296296297,359]
[null,null,"Acute",1.1413194444444443,72,0.19554398148148147,26,1.3379282407407407,72,1.1666203703703704,115]
[null,null,"OP",0.48894675925925929,62,4.9907407407407407E-2,92,1.2404398148148148,142,0.73493055555555553,117]
[null,null,"PRC",0.66806712962962955,164,0.78182870370370372,14,1.1289467592592592,110,1.3580787037037036,127]
[null,"William",null,2.8440277777777778,388,null,null,2.0036458333333336,296,3.2800810185185183,277]
[null,null,"Acute",1.1278240740740739,141,null,null,0.63343749999999999,105,1.6735879629629631,94]
[null,null,"OP",0.79059027777777779,162,null,null,0.92781250000000015,84,0.30359953703703701,91]
[null,null,"PRC",0.92561342592592588,85,null,null,0.44239583333333332,107,1.3028935185185184,92]
[null,"Robert",null,4.1431597222222223,371,1.9207523148148147,124,3.1039814814814815,249,1.0643750000000001,111]
[null,null,"Acute",1.439861111111111,162,0.45651620370370366,41,0.84915509259259259,138,8.7523148148148155E-2,77]
[null,null,"OP",1.0405902777777778,123,0.85579861111111111,34,0.84804398148148141,48,0.32222222222222224,13]
[null,null,"PRC",1.6627083333333332,86,0.60843749999999996,49,1.4067824074074073,63,0.65462962962962956,21]
[null,"Grand Total",null,17.17741898148148,1927,9.1011342592592612,1007,10.014525462962963,1068,13.04266203703704,1558]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PivotChart","Units"]