{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["cover page","results","detail","Encounter and Claims"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"cover page","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"merged":[[12,0,12,9],[13,0,13,9],[15,0,15,9],[16,0,16,9],[25,0,25,9],[27,0,29,9],[31,0,31,9]]}
{"$rows_empty":12}
["City of Knoxville"]
["CIGNA Dental Network Disruption - DHMO Utilization Report"]
[]
["Report Prepared:"]
["5/24/2018"]
{"$rows_empty":8}
["1805-1402088"]
[]
["Confidential, unpublished property of CIGNA. Do not duplicate or distribute.\nUse and distribution limited solely to authorized personnel.\n © Copyright 2018 Cigna.\n"]

{"sheet":"results","index":1,"n_rows":38,"n_cols":5,"rows_kept":38,"merged":[[0,0,0,2],[0,3,1,4],[1,0,2,1],[1,2,2,2],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[9,0,9,4],[11,1,11,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2]]}
[{"$nulls":3},"Cigna DHMO Results"]
[null,null,"Submitted Info"]
[{"$nulls":3},"Matched Info","% Match"]
["# of Provider Access Points",null,26,23,{"$f":"D4/C4","v":{"v":0.8846153846153846,"d":"88%"}}]
["Encounter Procdr Count",null,490,418,{"$f":"D5/C5","v":{"v":0.8530612244897959,"d":"85%"}}]
["Encounter Member Count",null,102,93,{"$f":"D6/C6","v":{"v":0.9117647058823529,"d":"91%"}}]
["Patient Charge Amt Sum",null,{"v":14660,"d":"14,660"},{"v":11648,"d":"11,648"},{"$f":"D7/C7","v":{"v":0.7945429740791269,"d":"79%"}}]
["Calculated Total Payment Amt",null,{"v":9205.65,"d":"$9,206"},{"v":8184.65,"d":"$8,185"},{"$f":"D8/C8","v":{"v":0.8890898524275852,"d":"89%"}}]
[]
["Provider Access Point Match Criteria Results"]
[{"$nulls":4},"Cigna DPPO Network Results"]
["Pass #","Disruption Passes",null,"Cigna DHMO Results"]
[]
[1,"Name, Facility, Addr, City, State, Zip",null,17]
[2,"Name, Addr, City, State, Zip",null,1]
[3,"Lic Nbr, Addr, City, State, Zip",null,0]
[4,"NPI_prov, Addr, City, State, Zip",null,0]
[5,"TIN, Addr, City, State, Zip",null,2]
[6,"Name, Facility, City, State, Zip",null,0]
[7,"Facility, Addr, City, State, Zip",null,0]
[8,"NPI_ofc, Addr, City, State, Zip",null,0]
[9,"Name, Facility, City, State",null,0]
[10,"Name, City, State, Zip",null,0]
[11,"Facility, City, State, Zip",null,0]
[12,"Name, Facility, Zip",null,0]
[13,"Name, City, State",null,0]
[14,"Facility, City, State",null,3]
[15,"NPI_prov, Zip",null,0]
[16,"Lic Nbr, Zip",null,0]
[17,"NPI_ofc, Zip",null,0]
[18,"Lic Nbr, State",null,0]
[19,"TIN",null,0]
[null,"Total Matches",null,{"$f":"SUM(D14:D32)","v":23}]
[]
[]
["Methodology:"]
["Name (is based on First Name & Last Name; Limited First Name to 1 character)"]
["Facility (is Limited to the first 9 characters, and no Punctuation)"]

{"sheet":"detail","index":2,"n_rows":27,"n_cols":17,"rows_kept":27}
["Ofc Number","Ofc Name","Provider Specialty Description","Provider First Name","Provider Last Name","TIN","DO Address 1","DO City Name","DO State","DO Zip","Encounter Procdr Count","Encounter Member Count","Patient Charge Amt Sum","Calculated Total Payment Amt","Cigna DHMO","Cigna DHMO Pass","DHMO Recruited Date"]
[136474,"WILLIAM G HARRIS DDS MS","PEDIATRIC DENTISTRY","WILLIAM","HARRIS","621223231","108 TULSA RD","OAK RIDGE","TN","37830",13,3,{"v":158,"d":"158.00"},{"v":357,"d":"357.00"},"Y","1"]
[618467,"365 DENTISTRY PLLC","GENERAL DENTISTRY","KAIRAV","VYAS","813930128","5303 JACKSBORO PIKE","KNOXVILLE","TN","37918",60,7,{"v":2816,"d":"2,816.00"},{"v":9,"d":"9.00"},"N"]
[158576,"AMER FAMILY DENTISTRY/SEMOUR","GENERAL DENTISTRY","TURKER","GOKSEL","621827508","11618 CHAPMAN HWY","SEYMOUR","TN","37865",49,12,{"v":102,"d":"102.00"},{"v":1901,"d":"1,901.00"},"Y","1"]
[533414,"AMERICAN FAMILY DENTISTRY",{"$nulls":3},"621827508","7562 MOUNTAIN GROVE DR","KNOXVILLE","TN","37920",5,1,{"v":289,"d":"289.00"},{"v":161,"d":"161.00"},"Y","5"]
[580782,"AMERICAN FAMILY DENTISTRY",{"$nulls":3},"621827508","11125 PARKSIDE DR","KNOXVILLE","TN","37934",3,1,{"v":0,"d":"0.00"},{"v":111,"d":"111.00"},"Y","5","2015-08-01"]
[449351,"ASPEN DENTAL","GENERAL DENTISTRY","DHIREN","ZAVERI","822038244","7731 KINGSTON PIKE","KNOXVILLE","TN","37919",1,1,{"v":0,"d":"0.00"},null,"Y","1"]
[449351,"ASPEN DENTAL","GENERAL DENTISTRY","JOHN","NOTARIANNI","822038244","7731 KINGSTON PIKE","KNOXVILLE","TN","37919",5,3,{"v":64,"d":"64.00"},{"v":3,"d":"3.00"},"Y","1"]
[449351,"ASPEN DENTAL","GENERAL DENTISTRY","NAKUL","PATEL","822038244","7731 KINGSTON PIKE","KNOXVILLE","TN","37919",13,5,{"v":0,"d":"0.00"},{"v":9,"d":"9.00"},"Y","1"]
[595507,"ASPEN DENTAL","GENERAL DENTISTRY","LESLIE","TREHERNE-FAYTON","822038244","2964 MILLER PLACE WAY","KNOXVILLE","TN","37924",3,1,{"v":145,"d":"145.00"},null,"Y","1","2015-12-01"]
[276961,"CREEKSIDE DENTAL","GENERAL DENTISTRY","KENT","MELBOURNE","371493481","2606 GREENWAY DR","KNOXVILLE","TN","37918",132,29,{"v":2021,"d":"2,021.00"},{"v":3400,"d":"3,400.00"},"Y","1"]
[595801,"DAN H THOMPSON DDS PC","GENERAL DENTISTRY","DAN","THOMPSON","621097535","200 FORT SANDERS WEST BLVD","KNOXVILLE","TN","37922",11,2,{"v":0,"d":"0.00"},{"v":4.5,"d":"4.50"},"Y","1","2015-12-01"]
[104407,"DECATHLON DENTAL GROUP","GENERAL DENTISTRY","T FULTON","JOHNS","621073946","614 MABRY HOOD RD","KNOXVILLE","TN","37932",106,18,{"v":350,"d":"350.00"},{"v":45,"d":"45.00"},"Y","2"]
[213098,"DENTAL WORKS","GENERAL DENTISTRY","BARI","MCFARLANE","200384058","6727 CLINTON HWY","KNOXVILLE","TN","37912",23,4,{"v":1715,"d":"1,715.00"},{"v":6,"d":"6.00"},"Y","1","2016-09-01"]
[507015,"BEARDEN PEDIATRIC DENTISTRY PL","PEDIATRIC DENTISTRY","ELIZABETH","EVANS","453690173","601 CONCORD ST","KNOXVILLE","TN","37919",2,1,{"v":5,"d":"5.00"},{"v":114,"d":"114.00"},"N"]
[138934,"BRENT COLLINS DDS","ORTHODONTICS","BRENT","COLLINS","414984394","518 W BROADWAY AVE","MARYVILLE","TN","37801",4,1,{"v":654,"d":"654.00"},344.51,"Y","1"]
[486986,"CHILDRENS DENTISTRY","PEDIATRIC DENTISTRY","DARRYL","PHILLIPS","204168290","9229 WESTLAND DR","KNOXVILLE","TN","37922",10,1,{"v":191,"d":"191.00"},{"v":898,"d":"898.00"},"N"]
[155334,"DANIEL S READ DMD","ORAL SURGERY","DANIEL","READ","621706086","111 FOX RD","KNOXVILLE","TN","37922",9,1,{"v":1570,"d":"1,570.00"},{"v":30,"d":"30.00"},"Y","1"]
[282910,"D WAYNE HUGHART DDS MS","ENDODONTICS","DONALD","HUGHART","270091568","109 FOX RD","KNOXVILLE","TN","37922",4,1,{"v":385,"d":"385.00"},{"v":450,"d":"450.00"},"Y","1"]
[113616,"EAST TENNESSEE OMS","ORAL SURGERY","MARK","WIDLOSKI","620936164","3228 TAZEWELL PIKE","KNOXVILLE","TN","37918",5,1,{"v":480,"d":"480.00"},{"v":42,"d":"42.00"},"Y","1"]
[113659,"EAST TENNESSEE OMS","ORAL SURGERY","TROY","TRONDSON","620936164","161 CAPITOL DR","KNOXVILLE","TN","37922",8,1,{"v":696,"d":"696.00"},{"v":80,"d":"80.00"},"Y","1"]
[113672,"JOHN A DIDDLE DDS","ORTHODONTICS","JOHN","DIDDLE","621063528","9220 DUTCHTOWN RD","KNOXVILLE","TN","37923",10,1,{"v":1804,"d":"1,804.00"},338.64,"Y","1"]
[236137,"JORDAN ORAL SURGERY","ORAL SURGERY","ROBERT","JORDAN","943419479","109 S NORTHSHORE DR STE 404","KNOXVILLE","TN","37919",5,2,{"v":745,"d":"745.00"},{"v":33,"d":"33.00"},"Y","1"]
[448503,"KNOXVILLE PEDIATRIC DENTISTRY","PEDIATRIC DENTISTRY","JAMES","WOOD","472658949","705 GATE LN","KNOXVILLE","TN","37909",2,1,{"v":5,"d":"5.00"},{"v":76,"d":"76.00"},"Y","14","2017-12-01"]
[448503,"KNOXVILLE PEDIATRIC DENTISTRY","PEDIATRIC DENTISTRY","JOSEPH","TOWNSEND","472658949","705 GATE LN","KNOXVILLE","TN","37909",3,1,{"v":5,"d":"5.00"},{"v":98,"d":"98.00"},"Y","14","2017-12-01"]
[530315,"KNOXVILLE PEDIATRIC DENTISTRY","PEDIATRIC DENTISTRY","JARED","LEE","472658949","10910 KINGSTON PIKE","KNOXVILLE","TN","37934",1,1,{"v":5,"d":"5.00"},{"v":40,"d":"40.00"},"Y","14","2017-12-01"]
[500595,"NORTHSHORE ENDODONTICS","ENDODONTICS","JOHN","SULLIVAN JR","753026840","414 S NORTHSHORE DR","KNOXVILLE","TN","37919",3,2,{"v":455,"d":"455.00"},{"v":655,"d":"655.00"},"Y","1"]

{"sheet":"Encounter and Claims","index":3,"n_rows":53,"n_cols":4,"rows_kept":53,"merged":[[0,0,0,3]]}
["Cigna DHMO Encounter and Claims: 1/1/14 - 4/1/18"]
["Row Labels","Count of Utilization Visit Date","Sum of Copay Amount","Sum of CDH Payment"]
["2014-01-01",1,{"v":95,"d":"$95.00"},{"v":25.17,"d":"$25.17"}]
["2014-02-01",2,{"v":253,"d":"$253.00"},{"v":6,"d":"$6.00"}]
["2014-03-01",7,{"v":1261,"d":"$1,261.00"},{"v":0,"d":"$0.00"}]
["2014-04-01",2,{"v":108,"d":"$108.00"},{"v":52.17,"d":"$52.17"}]
["2014-05-01",2,{"v":198,"d":"$198.00"},{"v":31.17,"d":"$31.17"}]
["2014-06-01",12,{"v":351,"d":"$351.00"},{"v":533,"d":"$533.00"}]
["2014-07-01",3,{"v":698,"d":"$698.00"},{"v":144.34,"d":"$144.34"}]
["2014-08-01",7,{"v":629,"d":"$629.00"},{"v":1128,"d":"$1,128.00"}]
["2014-09-01",9,{"v":446,"d":"$446.00"},{"v":299,"d":"$299.00"}]
["2014-10-01",21,{"v":3198,"d":"$3,198.00"},{"v":1212.62,"d":"$1,212.62"}]
["2014-11-01",6,{"v":1274,"d":"$1,274.00"},{"v":135,"d":"$135.00"}]
["2014-12-01",11,{"v":618,"d":"$618.00"},{"v":359.34000000000003,"d":"$359.34"}]
["2015-01-01",7,{"v":701,"d":"$701.00"},{"v":264.26,"d":"$264.26"}]
["2015-02-01",7,{"v":819,"d":"$819.00"},{"v":270.26,"d":"$270.26"}]
["2015-03-01",9,{"v":418,"d":"$418.00"},{"v":718,"d":"$718.00"}]
["2015-04-01",15,{"v":1646,"d":"$1,646.00"},{"v":1110.3400000000001,"d":"$1,110.34"}]
["2015-05-01",14,{"v":1496,"d":"$1,496.00"},{"v":947.6,"d":"$947.60"}]
["2015-06-01",14,{"v":1130,"d":"$1,130.00"},{"v":1471.17,"d":"$1,471.17"}]
["2015-07-01",14,{"v":866,"d":"$866.00"},{"v":839.34,"d":"$839.34"}]
["2015-08-01",12,{"v":1665,"d":"$1,665.00"},{"v":516.0799999999999,"d":"$516.08"}]
["2015-09-01",8,{"v":346,"d":"$346.00"},{"v":208.5,"d":"$208.50"}]
["2015-10-01",6,{"v":314,"d":"$314.00"},{"v":125.51,"d":"$125.51"}]
["2015-11-01",9,{"v":216,"d":"$216.00"},{"v":425.34000000000003,"d":"$425.34"}]
["2015-12-01",4,{"v":1189,"d":"$1,189.00"},{"v":760.17,"d":"$760.17"}]
["2016-01-01",10,{"v":979,"d":"$979.00"},{"v":211.17000000000002,"d":"$211.17"}]
["2016-02-01",7,{"v":1089,"d":"$1,089.00"},{"v":1039.51,"d":"$1,039.51"}]
["2016-03-01",4,{"v":190,"d":"$190.00"},{"v":309,"d":"$309.00"}]
["2016-04-01",17,{"v":955,"d":"$955.00"},{"v":436,"d":"$436.00"}]
["2016-05-01",12,{"v":816,"d":"$816.00"},{"v":938.3399999999999,"d":"$938.34"}]
["2016-06-01",14,{"v":386,"d":"$386.00"},{"v":693,"d":"$693.00"}]
["2016-07-01",9,{"v":310,"d":"$310.00"},{"v":229,"d":"$229.00"}]
["2016-08-01",15,{"v":2015,"d":"$2,015.00"},{"v":247.34,"d":"$247.34"}]
["2016-09-01",8,{"v":190,"d":"$190.00"},{"v":402,"d":"$402.00"}]
["2016-10-01",11,{"v":618,"d":"$618.00"},{"v":310,"d":"$310.00"}]
["2016-11-01",5,{"v":361,"d":"$361.00"},{"v":110.34,"d":"$110.34"}]
["2016-12-01",7,{"v":15,"d":"$15.00"},{"v":321,"d":"$321.00"}]
["2017-01-01",5,{"v":5,"d":"$5.00"},{"v":192,"d":"$192.00"}]
["2017-02-01",10,{"v":906,"d":"$906.00"},{"v":543.34,"d":"$543.34"}]
["2017-03-01",5,{"v":591,"d":"$591.00"},{"v":29,"d":"$29.00"}]
["2017-04-01",10,{"v":639,"d":"$639.00"},{"v":341,"d":"$341.00"}]
["2017-05-01",7,{"v":1353,"d":"$1,353.00"},{"v":948.17,"d":"$948.17"}]
["2017-06-01",7,{"v":10,"d":"$10.00"},{"v":313,"d":"$313.00"}]
["2017-07-01",15,{"v":612,"d":"$612.00"},{"v":719,"d":"$719.00"}]
["2017-09-01",3,{"v":686,"d":"$686.00"},{"v":34.49,"d":"$34.49"}]
["2017-11-01",6,{"v":433,"d":"$433.00"},{"v":78,"d":"$78.00"}]
["2017-12-01",5,{"v":10,"d":"$10.00"},{"v":275,"d":"$275.00"}]
["2018-01-01",2,{"v":380,"d":"$380.00"},{"v":341,"d":"$341.00"}]
["2018-02-01",5,{"v":15,"d":"$15.00"},{"v":166,"d":"$166.00"}]
["2018-03-01",13,{"v":1692,"d":"$1,692.00"},{"v":502,"d":"$502.00"}]
["2018-04-01",2,{"v":206,"d":"$206.00"},{"v":59.18,"d":"$59.18"}]
["Grand Total",416,{"v":35397,"d":"$35,397.00"},{"v":21370.25999999999,"d":"$21,370.26"}]