{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["CYP1A2","CYP3A4","CYP3A5","CYP2B6","CYP2C9","CYP2C19","CYP2D6","DPYD","CYP4F2","CFTR","G6PD","HLA-A3101","HLA-B1502","HLA-B5701","HLA-B5801","SLC01B1","TPMT","NUDT15","UGT1A1","VKORC1"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"CYP1A2","index":0,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP1A2 Phenotype",null,null,"Variants tested: *1A, *1C, *1D, *1F, *1K, *1L, *1V, *1W"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[null,35962,"00000",null,null,33169,null,null,"PM","Little to no enzyme activity"]
[null,99185,"00021",null,null,37343,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[null,null,10461,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[null,null,10866,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[null,null,12279,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[null,null,12700,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,null,12815]
[null,null,13730,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,null,14075]
[null,null,15148]
[null,null,15871]
[null,null,16714]
[null,null,18811]
[null,null,20391]
[null,null,20563]
[null,null,21354]
[null,null,21566]
[null,null,21576]
[null,null,21687]
[null,null,21742]
[null,null,22937]
[null,null,23559]
[null,null,24007]
[null,null,25330]
[null,null,25634]
[null,null,25803]
[null,null,26066]
[null,null,27063]
[null,null,27522]
[null,null,28775]
[null,null,29929]
[null,null,31074]
[null,null,31169]
[null,null,31177]
[null,null,32703]
[null,null,33782]
[null,null,35168]
[null,null,36194]
[null,null,36223]
[null,null,37235]
[null,null,37712]
[null,null,38789]
[null,null,39012]
[null,null,41418]
[null,null,41443]
[null,null,42211]
[null,null,42488]
[null,null,42670]
[null,null,45794]
[null,null,46717]
[null,null,47610]
[null,null,48085]
[null,null,48162]
[null,null,49258]
[null,null,49946]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,72168]
[null,null,78945]
[null,null,97517]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[{"$f":"COUNT(A10:A65)","v":0},2,61,{"$f":"COUNT(D10:D65)","v":0},{"$f":"COUNT(E10:E65)","v":0},2,65]

{"sheet":"CYP3A4","index":1,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP3A4 Phenotype",null,null,"Variants tested: *1B, *2, *3, *12, *17, *22",null,null," "]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[null,27063,"00000",null,null,null,null,null,"PM","Little to no enzyme activity"]
[null,35168,"00021",null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[null,38789,10461,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[null,48162,10866,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[null,null,12279,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[null,null,12700,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,null,12815]
[null,null,13730,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,null,14075]
[null,null,15148]
[null,null,15871]
[null,null,16714]
[null,null,18811]
[null,null,20391]
[null,null,20563]
[null,null,21354]
[null,null,21566]
[null,null,21576]
[null,null,21687]
[null,null,21742]
[null,null,22937]
[null,null,23559]
[null,null,24007]
[null,null,25330]
[null,null,25634]
[null,null,25803]
[null,null,26066]
[null,null,27522]
[null,null,28775]
[null,null,29929]
[null,null,31074]
[null,null,31169]
[null,null,31177]
[null,null,32703]
[null,null,33169]
[null,null,33782]
[null,null,35962]
[null,null,36194]
[null,null,36223]
[null,null,37235]
[null,null,37343]
[null,null,37712]
[null,null,39012]
[null,null,41418]
[null,null,41443]
[null,null,42211]
[null,null,42488]
[null,null,42670]
[null,null,45794]
[null,null,46717]
[null,null,47610]
[null,null,48085]
[null,null,49258]
[null,null,49946]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,72168]
[null,null,78945]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[{"$f":"COUNT(A10:A65)","v":0},4,61,{"$f":"COUNT(D10:D65)","v":0},{"$f":"COUNT(E10:E65)","v":0},0,{"$f":"SUM(A67:F67)","v":65}]

{"sheet":"CYP3A5","index":2,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP3A5 Phenotype",null,null,"Variants tested:*1D, *2, *3, *3B, *3C, *6, *7, *8, *9"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
["00000","00021",33169,null,null,null,null,null,"PM","Little to no enzyme activity"]
[10866,10461,null,null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[12279,21354,null,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[12700,27522,null,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[12815,38789,null,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[13730,42211,null,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[14075,42670]
[15148,47610,null,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[15871,97517]
[16714]
[18811]
[20391]
[20563]
[21566]
[21576]
[21687]
[21742]
[22937]
[23559]
[24007]
[25330]
[25634]
[25803]
[26066]
[27063]
[28775]
[29929]
[31074]
[31169]
[31177]
[32703]
[33782]
[35168]
[35962]
[36194]
[36223]
[37235]
[37343]
[37712]
[39012]
[41418]
[41443]
[42488]
[45794]
[46717]
[48085]
[48162]
[49258]
[49946]
[51783]
[54592]
[69530]
[72168]
[78945]
[99185]
[]
["PM","IM","NM","RM","UM","Unknown ","Total"]
[55,9,1,{"$f":"COUNT(D4:D59)","v":0},{"$f":"COUNT(E4:E59)","v":0},0,{"$f":"SUM(A61:F61)","v":65}]

{"sheet":"CYP2B6","index":3,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP2B6 Phenotype",null,null,"Variants tested: *6, *9"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[12700,14075,"00000",null,null,null,null,null,"PM","Little to no enzyme activity"]
[38789,16714,"00021",null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[null,37712,10461,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[null,41418,10866,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[null,null,12279,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[null,null,12815,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,null,13730]
[null,null,15148,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,null,15871]
[null,null,18811]
[null,null,20391]
[null,null,20563]
[null,null,21354]
[null,null,21566]
[null,null,21576]
[null,null,21687]
[null,null,21742]
[null,null,22937]
[null,null,23559]
[null,null,24007]
[null,null,25330]
[null,null,25634]
[null,null,25803]
[null,null,26066]
[null,null,27063]
[null,null,27522]
[null,null,28775]
[null,null,29929]
[null,null,31074]
[null,null,31169]
[null,null,31177]
[null,null,32703]
[null,null,33169]
[null,null,33782]
[null,null,35168]
[null,null,35962]
[null,null,36194]
[null,null,36223]
[null,null,37235]
[null,null,37343]
[null,null,39012]
[null,null,41443]
[null,null,42211]
[null,null,42488]
[null,null,42670]
[null,null,45794]
[null,null,46717]
[null,null,47610]
[null,null,48085]
[null,null,48162]
[null,null,49258]
[null,null,49946]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,72168]
[null,null,78945]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[2,4,59,{"$f":"COUNT(D8:D63)","v":0},{"$f":"COUNT(E8:E63)","v":0},0,{"$f":"SUM(A65:F65)","v":65}]

{"sheet":"CYP2C9","index":4,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP2C9 Phenotype",null,null,"Variants tested:*2, *3, *4, *5, *6, *11"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[10866,12279,"00000",null,null,null,null,null,"PM","Little to no enzyme activity"]
[20391,12700,"00021",null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[42670,14075,10461,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[null,15871,12815,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[null,20563,13730,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[null,21576,15148,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,21687,16714]
[null,23559,18811,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,25634,21354]
[null,25803,21566]
[null,26066,21742]
[null,27063,22937]
[null,27522,24007]
[null,33782,25330]
[null,37343,28775]
[null,39012,29929]
[null,41418,31074]
[null,42488,31169]
[null,48162,31177]
[null,72168,32703]
[null,99185,33169]
[null,null,35168]
[null,null,35962]
[null,null,36194]
[null,null,36223]
[null,null,37235]
[null,null,37712]
[null,null,38789]
[null,null,41443]
[null,null,42211]
[null,null,45794]
[null,null,46717]
[null,null,47610]
[null,null,48085]
[null,null,49258]
[null,null,49946]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,78945]
[null,null,97517]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[3,21,41,{"$f":"COUNT(#REF!)","v":0},{"$f":"COUNT(#REF!)","v":0},0,{"$f":"SUM(A47:F47)","v":65}]

{"sheet":"CYP2C19","index":5,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP2C19 Phenotype",null,null,"Variants tested:*2, *3, *4, *4B, *5, *6, *7, *8, *9, *17"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[12815,"00000",10866,"'00021",29929,null,null,null,"PM","Little to no enzyme activity"]
[13730,10461,18811,12279,31074,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[15148,12700,20563,20391,31177,null,null,null,"NM","Fully functional enzyme activity"]
[21566,14075,21576,21354,49258,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[27522,15871,22937,21687,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[35168,16714,23559,21742,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,25634,25803,24007]
[null,31169,27063,25330,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,32703,28775,26066]
[null,33782,37235,33169]
[null,36223,37343,35962]
[null,42670,38789,36194]
[null,45794,39012,37712]
[null,46717,41443,41418]
[null,47610,42211,42488]
[null,48162,48085,78945]
[null,72168,49946,99185]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,97517]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[6,17,21,17,4,0,{"$f":"SUM(A27:F27)","v":65}]

{"sheet":"CYP2D6","index":6,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,2,0,7]]}
["CYP2D6 Phenotype",null,"Variants tested:*2, *3, *4, *4M, *6, *7, *8, *9, *10, *12, *14A, *14B, *17, *29, *35, *41\n"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown ",null,"Phenotype","Functional Definition per CPIC"]
[12279,"00000","'00021",null,27522,29929,null,"PM","Little to no enzyme activity"]
[13730,12700,10461,null,38789,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[24007,12815,10866,null,null,null,null,"NM","Fully functional enzyme activity"]
[25803,15148,14075,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[41418,21566,15871,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[41443,21576,16714,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[49258,21687,18811]
[null,22937,20391,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,25634,20563]
[null,32703,21354]
[null,33169,21742]
[null,35168,23559]
[null,37235,25330]
[null,46717,26066]
[null,69530,27063]
[null,72168,28775]
[null,null,31074]
[null,null,31169]
[null,null,31177]
[null,null,33782]
[null,null,35962]
[null,null,36194]
[null,null,36223]
[null,null,37343]
[null,null,37712]
[null,null,39012]
[null,null,42211]
[null,null,42488]
[null,null,42670]
[null,null,45794]
[null,null,47610]
[null,null,48085]
[null,null,48162]
[null,null,49946]
[null,null,51783]
[null,null,54592]
[null,null,78945]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown ","Total"]
[7,16,39,0,2,1,{"$f":"SUM(A45:F45)","v":65}]

{"sheet":"DPYD","index":7,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["DPYD Phenotype",null,null,"Variants tested: Numerous"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
["00000",16714,10461,null,null,null,null,null,"PM","Little to no enzyme activity"]
["'00021",18811,12279,null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[10866,20391,12700,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[14075,23559,12815,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[21566,26066,13730,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[31177,27063,15148,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[33782,31074,15871]
[41443,36194,20563,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[47610,36223,21354]
[49946,39012,21576]
[null,42488,21687]
[null,51783,21742]
[null,null,22937]
[null,null,24007]
[null,null,25330]
[null,null,25634]
[null,null,25803]
[null,null,27522]
[null,null,28775]
[null,null,29929]
[null,null,31169]
[null,null,32703]
[null,null,33169]
[null,null,35168]
[null,null,35962]
[null,null,37235]
[null,null,37343]
[null,null,37712]
[null,null,38789]
[null,null,41418]
[null,null,42211]
[null,null,42670]
[null,null,45794]
[null,null,46717]
[null,null,48085]
[null,null,48162]
[null,null,49258]
[null,null,54592]
[null,null,69530]
[null,null,72168]
[null,null,78945]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[10,12,43,0,0,0,{"$f":"SUM(A49:F49)","v":65}]

{"sheet":"CYP4F2","index":8,"n_rows":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CYP4F2 Phenotype",null,null,"Variants tested: *2, *3"]
["Report Number"]
["Normal Function","Decreased function"]
["00000",14075]
["00021",15148]
[10461,15871]
[10866,16714]
[12279,21687]
[12700,21742]
[12815,22937]
[13730]
[18811]
[20391]
[20563]
[21354]
[21566]
[21576]
[23559]
[24007]
[25330]
[25634]
[25803]
[26066]
[27063]
[27522]
[28775]
[29929]
[31074]
[31169]
[31177]
[32703]
[33169]
[33782]
[35168]
[35962]
[36194]
[36223]
[37235]
[37343]
[37712]
[38789]
[39012]
[41418]
[41443]
[42211]
[42488]
[42670]
[45794]
[46717]
[47610]
[48085]
[48162]
[49258]
[49946]
[51783]
[54592]
[69530]
[72168]
[78945]
[97517]
[99185]
[]
["Normal Function","Decreased function","Total"]
[58,7,{"$f":"SUM(A64:B64)","v":65}]

{"sheet":"CFTR","index":9,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["CFTR Phenotype",null,null,"Variants tested: Numerous"]
["Report Number"]
["Postive","Negatiave","Unknown "]
["00000","'00021"]
[10866,10461]
[13730,12279]
[14075,12700]
[16714,12815]
[18811,15148]
[25330,15871]
[26066,20391]
[27063,20563]
[32703,21354]
[36223,21566]
[41418,21576]
[42488,21687]
[42670,21742]
[49258,22937]
[49946,23559]
[51783,24007]
[null,25634]
[null,25803]
[null,27522]
[null,28775]
[null,29929]
[null,31074]
[null,31169]
[null,31177]
[null,33169]
[null,33782]
[null,35168]
[null,35962]
[null,36194]
[null,37235]
[null,37343]
[null,37712]
[null,38789]
[null,39012]
[null,41443]
[null,42211]
[null,47610]
[null,48085]
[null,48162]
[null,69530]
[null,72168]
[null,78945]
[null,97517]
[null,99185]
[null,45794]
[null,46717]
[null,54592]
[]
["Postive","Negative","Unknown","Total"]
[17,48,0,{"$f":"SUM(A54:C54)","v":65}]

{"sheet":"G6PD","index":10,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["G6PD Phenotype",null,null,"Variants tested: Numerous"]
["Report Number"]
["Deficient","Deficient with CNSHA","Normal","Deficient or Variable ",null,null,null,null,"Phenotype","Functional Definition per CPIC"]
["00000",15148,"00021",14075,null,null,null,null,"Deficient","<10-60% of normal enzyme activity "]
[10866,21566,10461,null,null,null,null,null,"Deficient with CNSHA","Severe enzyme deficiency (<10% activity) and associated with CNSHA"]
[12279,21576,12700,null,null,null,null,null,"Normal","Very mild or no enzyme deficiency ( >60% of normal enzyme levels)"]
[21687,23559,12815,null,null,null,null,null,"Deficient or Variable ","Normal or deficient enzyme activity "]
[25634,27522,13730,null,null,null,null,null,"Citation: Relling MV, McDonah EM, Chang T, et al. Clinical Pharmacogenetics Implementation Consortium (CPIC) Guidelines for Rasburicase Therapy in the Context of G6PD Deficiency Genotype. CPIC. 2014. Doi:10.1038/clpt.2014.97"]
[31169,35168,15871]
[33169,null,16714]
[37343,null,18811]
[42488,null,20391]
[45794,null,20563]
[46717,null,21354]
[49946,null,21742]
[51783,null,22937]
[54592,null,24007]
[69530,null,25330]
[99185,null,25803]
[null,null,26066]
[null,null,27063]
[null,null,28775]
[null,null,29929]
[null,null,31074]
[null,null,31177]
[null,null,32703]
[null,null,33782]
[null,null,35962]
[null,null,36194]
[null,null,36223]
[null,null,37235]
[null,null,37712]
[null,null,38789]
[null,null,39012]
[null,null,41418]
[null,null,41443]
[null,null,42211]
[null,null,42670]
[null,null,47610]
[null,null,48085]
[null,null,48162]
[null,null,49258]
[null,null,72168]
[null,null,78945]
[null,null,97517]
[]
["Deficient","Deficient with CNSHA","Normal","Deficient with Variable ","Total"]
[16,6,42,1,{"$f":"SUM(A48,B48,C48,D48)","v":65}]

{"sheet":"HLA-A3101","index":11,"n_rows":65,"n_cols":3,"rows_kept":65,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["HLA-A*31:01 Genotype"]
["Report Number"]
["Negative","Positive"]
["00000",12700]
["00021",18811]
[10461,24007]
[10866,35962]
[12279,45794]
[12815,48162]
[13730,69530]
[14075,97517]
[15148]
[15871]
[16714]
[20391]
[20563]
[21354]
[21566]
[21576]
[21687]
[21742]
[22937]
[23559]
[25330]
[25634]
[25803]
[26066]
[27063]
[27522]
[28775]
[29929]
[31074]
[31169]
[31177]
[32703]
[33169]
[33782]
[35168]
[36194]
[36223]
[37235]
[37343]
[37712]
[38789]
[39012]
[41418]
[41443]
[42211]
[42488]
[42670]
[46717]
[47610]
[48085]
[49258]
[49946]
[51783]
[54592]
[72168]
[78945]
[99185]
[]
[]
[]
["Negative","Positive","Total"]
[57,8,{"$f":"SUM(A65:B65)","v":65}]

{"sheet":"HLA-B1502","index":12,"n_rows":71,"n_cols":3,"rows_kept":71,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["HLA-B*15:02 Genotype"]
["Report Number"]
["Negative","Positive"]
["00000",12279]
["00021",21687]
[10461,28775]
[10866,32703]
[12700,37712]
[12815,51783]
[13730,54592]
[14075,99185]
[15148]
[15871]
[16714]
[18811]
[20391]
[20563]
[21354]
[21566]
[21576]
[21742]
[22937]
[23559]
[24007]
[25330]
[25634]
[25803]
[26066]
[27063]
[27522]
[29929]
[31074]
[31169]
[31177]
[33169]
[33782]
[35168]
[35962]
[36194]
[36223]
[37235]
[37343]
[38789]
[39012]
[41418]
[41443]
[42211]
[42488]
[42670]
[45794]
[46717]
[47610]
[48085]
[48162]
[49258]
[49946]
[69530]
[72168]
[78945]
[97517]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Negative","Positive","Total"]
[57,8,{"$f":"SUM(A71:B71)","v":65}]

{"sheet":"HLA-B5701","index":13,"n_rows":59,"n_cols":3,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["HLA-B*57:01 Genotype"]
["Report Number"]
["Negative","Positive"]
["00021","00000"]
[10461,12815]
[10866,20391]
[12279,22937]
[12700,26066]
[13730,27063]
[14075,27522]
[15148,28775]
[15871,29929]
[16714,31074]
[18811,31177]
[20563,32703]
[21354,33169]
[21566,33782]
[21576,35168]
[21687,35962]
[21742,36194]
[23559,36223]
[24007,37235]
[25330,37343]
[25634,37712]
[25803,38789]
[31169,39012]
[null,41418]
[null,41443]
[null,42211]
[null,42488]
[null,42670]
[null,45794]
[null,46717]
[null,47610]
[null,48085]
[null,48162]
[null,49258]
[null,49946]
[null,51783]
[null,54592]
[null,69530]
[null,72168]
[null,78945]
[null,97517]
[null,99185]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Negative","Positive","Total"]
[23,42,{"$f":"SUM(A59:B59)","v":65}]

{"sheet":"HLA-B5801","index":14,"n_rows":61,"n_cols":3,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["HLA-B*58:01 Genotype"]
["Report Number"]
["Negative","Positive"]
["00000",12279]
["00021",15871]
[10461,21566]
[10866,23559]
[12700,26066]
[12815,31169]
[13730,35168]
[14075,41418]
[15148,49258]
[16714,97517]
[18811]
[20391]
[20563]
[21354]
[21576]
[21687]
[21742]
[22937]
[24007]
[25330]
[25634]
[25803]
[27063]
[27522]
[28775]
[29929]
[31074]
[31177]
[32703]
[33169]
[33782]
[35962]
[36194]
[36223]
[37235]
[37343]
[37712]
[38789]
[39012]
[41443]
[42211]
[42488]
[42670]
[45794]
[46717]
[47610]
[48085]
[48162]
[49946]
[51783]
[54592]
[69530]
[72168]
[78945]
[99185]
[]
["Negative","Positive","Total"]
[55,{"$f":"COUNT(B4:B58)","v":10},{"$f":"SUM(A61:B61)","v":65}]

{"sheet":"SLC01B1","index":15,"n_rows":53,"n_cols":4,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,1,2]]}
["SLCO1B1 Phenotype",null,null,"Variants tested: 521T>C, 388A>G"]
["Report Number"]
["Normal Function","Decreased Function","Poor Function"]
[10461,"00000","'00021"]
[10866,18811,12700]
[12279,26066,20391]
[12815,29929,21354]
[13730,35962,23559]
[14075,36223,31177]
[15148,41443,97517]
[15871,45794]
[16714,49258]
[20563,72168]
[21566,78945]
[21576]
[21687]
[21742]
[22937]
[24007]
[25330]
[25634]
[25803]
[27063]
[27522]
[28775]
[31074]
[31169]
[32703]
[33169]
[33782]
[35168]
[36194]
[37235]
[37343]
[37712]
[38789]
[39012]
[41418]
[42211]
[42488]
[42670]
[46717]
[47610]
[48085]
[48162]
[49946]
[51783]
[54592]
[69530]
[99185]
[]
["Normal Function","Decreased Function","Poor Function","Total"]
[47,11,7,{"$f":"SUM(A53:C53)","v":65}]

{"sheet":"TPMT","index":16,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["TPMT Phenotype",null,null,"Variants tested: *2, *3A, *3B, *3C, *4"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[20563,"00000","'00021",null,null,null,null,null,"PM","Little to no enzyme activity"]
[23559,10461,12279,null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[42488,10866,12700,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[69530,15148,12815,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[72168,18811,13730,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[null,21354,14075,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,26066,15871]
[null,27063,16714,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,29929,20391]
[null,31169,21566]
[null,31177,21576]
[null,33782,21687]
[null,36223,21742]
[null,37712,22937]
[null,42211,24007]
[null,42670,25330]
[null,48162,25634]
[null,null,25803]
[null,null,27522]
[null,null,28775]
[null,null,31074]
[null,null,32703]
[null,null,33169]
[null,null,35168]
[null,null,35962]
[null,null,36194]
[null,null,37235]
[null,null,37343]
[null,null,38789]
[null,null,39012]
[null,null,41418]
[null,null,41443]
[null,null,45794]
[null,null,46717]
[null,null,47610]
[null,null,48085]
[null,null,49258]
[null,null,49946]
[null,null,51783]
[null,null,54592]
[null,null,78945]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[5,17,43,0,0,0,{"$f":"SUM(A49:F49)","v":65}]

{"sheet":"NUDT15","index":17,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["NUDT15 Phenotype",null,null,"Variants tested: *2, *3, *4, *5, *6, *7, *8, *9"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[35168,"00000","'00021",null,null,null,null,null,"PM","Little to no enzyme activity"]
[35962,13730,10461,null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[36223,16714,10866,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[null,21566,12279,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[null,25330,12700,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[null,31169,12815,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,31177,14075]
[null,32703,15148,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,39012,15871]
[null,42670,18811]
[null,45794,20391]
[null,46717,20563]
[null,49946,21354]
[null,72168,21576]
[null,null,21687]
[null,null,21742]
[null,null,22937]
[null,null,23559]
[null,null,24007]
[null,null,25634]
[null,null,25803]
[null,null,26066]
[null,null,27063]
[null,null,27522]
[null,null,28775]
[null,null,29929]
[null,null,31074]
[null,null,33169]
[null,null,33782]
[null,null,36194]
[null,null,37235]
[null,null,37343]
[null,null,37712]
[null,null,38789]
[null,null,41418]
[null,null,41443]
[null,null,42211]
[null,null,42488]
[null,null,47610]
[null,null,48085]
[null,null,48162]
[null,null,49258]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,78945]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[3,14,48,0,0,0,{"$f":"SUM(A54:F54)","v":65}]

{"sheet":"UGT1A1","index":18,"n_rows":56,"n_cols":10,"rows_kept":56,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["UGT1A1 Phenotype",null,null,"Variants tested: *6, *27, *28, *36, *37, *60, *80"]
["Report Number"]
["PM","IM","NM","RM","UM","Unknown",null,null,"Phenotype","Functional Definition per CPIC"]
[10461,"00000",10866,null,null,null,null,null,"PM","Little to no enzyme activity"]
[20563,"'00021",12279,null,null,null,null,null,"IM","Decreased enzyme activity (activity between normal and poor metabolizer)"]
[27522,21576,12700,null,null,null,null,null,"NM","Fully functional enzyme activity"]
[31074,24007,12815,null,null,null,null,null,"RM","Increased enzyme activity compared to normal metabolizers but less than ultrarapid metabolizers"]
[36194,25634,13730,null,null,null,null,null,"UM","Increased enzyme activity compared to rapid metabolizers"]
[49946,29929,14075,null,null,null,null,null,"Citation: Caudle KE, Dunnenberger HM, Freimuth RR, et al. Standardizing terms for clinical pharmacogenetic test results: consensus terms from the Clinical Pharmacogenetics Implementation Consortium (CPIC). Genet Med. 2017;19(2):215-223. doi:10.1038/gim.2016.87"]
[null,36223,15148]
[null,45794,15871,null,null,null,null,null,"Unknown","Sample collection or analytical issue prevented reporting of results"]
[null,78945,16714]
[null,null,18811]
[null,null,20391]
[null,null,21354]
[null,null,21566]
[null,null,21687]
[null,null,21742]
[null,null,22937]
[null,null,23559]
[null,null,25330]
[null,null,25803]
[null,null,26066]
[null,null,27063]
[null,null,28775]
[null,null,31169]
[null,null,31177]
[null,null,32703]
[null,null,33169]
[null,null,33782]
[null,null,35168]
[null,null,35962]
[null,null,37235]
[null,null,37343]
[null,null,37712]
[null,null,38789]
[null,null,39012]
[null,null,41418]
[null,null,41443]
[null,null,42211]
[null,null,42488]
[null,null,42670]
[null,null,46717]
[null,null,47610]
[null,null,48085]
[null,null,48162]
[null,null,49258]
[null,null,51783]
[null,null,54592]
[null,null,69530]
[null,null,72168]
[null,null,97517]
[null,null,99185]
[]
["PM","IM","NM","RM","UM","Unknown","Total"]
[6,9,50,0,0,0,{"$f":"SUM(A56:F56)","v":65}]

{"sheet":"VKORC1","index":19,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
["VKORC1 Phenotype",null,"Variants tested: -1639G>A"]
["Report Number"]
["Intermediate Warfarin Sensitivity","High Warfarin Sensitivity","Low Warfarin Sensitivity","Normal Warfarin Sensitivity"]
["00000","00021",10461,41443]
[12279,12815,10866]
[12700,20563,13730]
[14075,21354,16714]
[15148,21566,21576]
[15871,25634,21687]
[18811,32703,25330]
[20391,35962,27063]
[21742,36194,27522]
[22937,36223,28775]
[23559,37343,29929]
[24007,39012,31169]
[25803,42211,33169]
[26066,49258,33782]
[31074,null,35168]
[31177,null,37712]
[37235,null,38789]
[41418,null,42670]
[42488,null,46717]
[45794,null,48085]
[47610,null,51783]
[48162,null,54592]
[49946,null,69530]
[72168,null,78945]
[97517,null,99185]
[]
[]
["Intermediate Warfarin Sensitivity","High Warfarin Sensitivity","Low Warfarin Sensitivity","Normal Warfarin Sensitivity","Total"]
[25,14,25,1,{"$f":"SUM(A32:D32)","v":65}]