This Spreadsheet contains 5 tabs ( HZ NJ, MDH, UHC Medicaid, UHC Medicare) the fifth tab is the comparison tab, where i would need the common codes and its description between the 4 main sheets put in the comparison tab and their corresponding auth values for each market from 4 main sheets displayed in the comparison tab as well, it would be great if a formula is also provided along with the solution AutoSave Off H Code Comparsion Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 A A ab Wrap Text General Paste BI U 1 Merge Center $ Clipboard Font Alignment Number A1 X fic Code B D E Total Auths 106 54 4 85 1 1 1 98 81 35 47 1 1 Code 2 D0120 3 D0140 4 D0145 5 DO150 6 D0170 7 D0171 8 D0180 9 D0210 10 D0220 11 D0230 12 D0240 13 D0250 14 D0270 15 D0272 16 D0274 17 D0320 18 D0321 19 D0322 20 D0330 21 D0340 22 D0350 23 D0351 24 D0364 25 D0365 26 D0366 27 D0367 Description Periodic Oral Evaluation Established Patient Limited Oral Evaluation Problem Focused Oral Evaluation, Patient Under Three Comprehensive Oral Evaluation New Or Established Patient Re Evaluation Limited, Problem Focused Re Evaluation Post Operative Office Visit Comprehensive Periodontal Evaluation New Or Established Patient Intraoral Complete Series of Radiographic Images Intraoral Periapical First Radiographic Image Intraoral Periapical Each Additional Image Intraoral Occlusal Radiographic Image Extraoral 2D Projection Radiographic image Bitewing Single Radiographic Image Bitewings Two Radiographic Images Bitewings Four Radiographic Images Temporomandibular Joint Arthrogram, Including Injection Other Temporomandibular Joint Radiographic Images, By Report Tomographic Survey Panoramic Radiographic Image 2D Cephalometric Radiographic Image Oral Facial Photographic Images Oral Facial Photographic Images Cone Beam Less Than One Whole Jaw Cone Beam One Full Dental Arch Mandible Cone Beam One Full Dental Arch Maxilla Cone Beam Both Jaws Comparsion HZ NJ MDH UHC Medicare 6 66 41 3 2 5 66 34 36 1 389 91 104 145 TI UHC Medicaid AutoSave Off Code Comparsion Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 1 A A ab Wrap Text General Paste U 1 A Merge Center 6 0 00 Clipboard Font Alignment Number B13 X fic Bitewings Four Radiographic Images B D E Total Auths 120 5 2 15 3 6 30 3 3 55 100 16 A 1 Code 2 D0120 3 D0140 4 D0145 5 DO150 6 D0170 7 D0180 8 DO210 9 DO220 10 DO230 11 D0240 12 D0272 13 D0274 14 D0320 15 D0330 16 D0340 17 D0350 18 D0351 19 D0364 20 D0365 21 D0366 22 D0367 23 D0380 24 D0383 25 D0391 26 D0414 27 D0431 Description Periodic Oral Evaluation Established Patient Limited Oral Evaluation Problem Focused Oral Evaluation, Patient Under Three Comprehensive Oral Evaluation New Or Established Patient Re Evaluation Limited, Problem Focused Comprehensive Periodontal Evaluation New Or Established Patient Intraoral Complete Series of Radiographic Images Intraoral Periapical First Radiographic Image Intraoral Periapical Each Additional Image Intraoral Occlusal Radiographic Image Bitewings Two Radiographic Images Bitewings Four Radiographic Images Temporomandibular Joint Arthrogram, Including Injection Panoramic Radiographic Image 2D Cephalometric Radiographic Image Oral Facial Photographic Images Oral Facial Photographic Images Cone Beam Less Than One Whole Jaw Cone Beam One Full Dental Arch Mandible Cone Beam One Full Dental Arch Maxilla Cone Beam Both Jaws Cone Beam Less Than One Whole Jaw Cone Beam Both Jaws Interpretation Of Diagnostic Image Laboratory processing of microbial specimen Adjunctive Pre Diagnostic Test That Aids In Detection Of Mucosal Abnormalities 1 160 780 62 6 6 2 6 13 1 5 1 1 15 Comparsion HZ NJ MDH UHC Medicaid UHC Medicare AutoSave Off Code Comparsion Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 A A ab Wrap Text General Paste BI U 1 Merge Center Clipboard Font Alignment Num B15 X Removal of Impacted Tooth Partially Bony D E C Total Auths 19854 19848 19082 18870 18752 18750 18592 18209 16870 15900 15605 A B 1 Code Description 2 D3320 Endodontic Therapy Premolar Tooth (Excluding Final Restoration) 3 D2751 Crown Porcelain Fused To Predominantly Base Metal 4 D2740 Crown Porcelain Ceramic 5 D2954 Prefabricated Post And Core In Addition To Crown 6 D2750 Crown Porcelain Fused To High Noble Metal 7 DO140 Limited Oral Evaluation Problem Focused 8 D9223 Deep Sedation General Anesthesia Each subsequent 15 Minute Increment 9 D3330 Endodontic Therapy, Molar tooth (Excluding Final Restoration) 10 D8080 Comprehensive Orthodontic Treatment Of The Adolescent Dentition 11 D4341 Periodontal Scaling And Root Planing Four Or More Teeth Per Quadrant 12 D9222 Deep Sedation General Anesthesia First 15 Minutes 13 D9230 Inhalation Of Nitrous Analgesia, Anxiolysis 14 D3310 Endodontic Therapy, Anterior Tooth (Excluding Final Restoration) 15 D7230 Removal Of Impacted Tooth Partially Bony 16 D5110 Complete Denture Maxillary 17 D5214 Mandibular Partial Denture Cast Metal Framework With Resin Denture Bases 18 D7140 Extraction, Erupted Tooth Or Exposed Root 19 D2930 Prefabricated Stainless Steel Crown Primary Tooth 20 D7210 Extraction, Erupted Tooth 21 D2950 Core Buildup, Including Any Pins When Required 22 D9999 Unspecified Adjunctive Procedure, By Report 23 D2392 Resin Based Composite Two Surfaces, Posterior 24 D2752 Crown Porcelain Fused To Noble Metal 25 D5120 Complete Denture Mandibular 26 D7240 Removal Of Impacted Tooth Completely Bony 27 D8670 Periodic Orthodontic Treatment Visit 15202 9478 9601 9497 9479 9302 9193 9108 9070 8606 8553 8371 8093 5928 7213 2010 Comparsion HZ NJ MDH UHC Medicaid UHC Medicare AutoSave Off Code Comparsion Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 ab Wrap Text General Paste Merge Center $ Clipboard Font Alignment Num B13 Endodontic Therapy Premolar Tooth (Excluding Final Restoration) D E A B 1 Code Description 2 D2950 Core Buildup, Including Any Pins When Required 3 D2740 Crown Porcelain Ceramic 4 D4341 Periodontal Scaling And Root Planing Four Or More Teeth Per Quadrant 5 D5110 Complete Denture Maxillary 6 D5214 mandibular partial denture cast metal framework with resin denture bases 7 D5120 Complete Denture Mandibular 8 D2750 Crown Porcelain Fused To High Noble Metal 9 D4342 Periodontal Scaling And Root Planing One To Three Teeth Per Quadrant 10 D5213 maxillary partial denture cast metal framework with resin denture bases 11 D5130 Immediate Denture Maxillary 12 D3310 Endodontic Therapy, Anterior Tooth (Excluding Final Restoration) 13 D3320 Endodontic Therapy Premolar Tooth (Excluding Final Restoration) 14 D5214 mandibular partial denture cast metal framework with resin denture bases (incl 15 D5212 Mandibular Partial Denture Resin Base 16 D2954 Prefabricated Post And Core In Addition To Crown 17 D2751 Crown Porcelain Fused To Predominantly Base Metal 18 D3330 Endodontic Therapy, Molar tooth (Excluding Final Restoration) 19 D5211 Maxillary Partial Denture Resin Base 20 D5213 maxillary partial denture cast metal framework with resin denture bases (inclu 21 D6240 Pontic Porcelain Fused To High Noble Metal 22 D7250 Removal Of Residual Tooth (Cutting Procedure) 23 D5140 Immediate Denture Mandibular 24 D7210 Extraction, Erupted Tooth 25 D6750 Retainer Crown Porcelain Fused To High Noble Metal 26 D6010 Surgical Placement Of Implant Body Endosteal Implant 27 D9223 Deep Sedation General Anesthesia Each subsequent 15 Minute Increment Comparsion 9 HZ Nj MDH UHC Medicaid UHC Medicare Total Auths 15818 15374 12884 12872 10290 10091 5548 5332 5052 4703 4605 4515 4316 4183 4009 3862 3737 3580 3452 3068 2500 2276 2268 2252 2072 1583 AutoSave Off H File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 A A ce Wrap Text ab Paste B 1 U Merge CE Clipboard Font Alignment G15 3 X D E F G H B Code Description 1 HZ NJ MDH UHC Medicaid UHC Medicare 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 Comparsion HZ NJ MDH UHC Medicaid UHC Medicare

Question

This Spreadsheet contains 5 tabs  ( HZ NJ, MDH, UHC Medicaid, UHC Medicare) the fifth tab is the comparison tab, where i would need the common codes and its description between the 4 main sheets put in the comparison tab and their corresponding auth values for each market from 4 main sheets displayed in the comparison tab as well, it would be great if a formula is also provided along with the solution AutoSave Off H Code Comparsion   Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 A A ab Wrap Text General Paste BI U   1 Merge   Center $     Clipboard Font Alignment Number A1 X fic Code B D E Total Auths 106 54 4 85 1 1 1 98 81 35 47 1 1 Code 2 D0120 3 D0140 4 D0145 5 DO150 6 D0170 7 D0171 8 D0180 9 D0210 10 D0220 11 D0230 12 D0240 13 D0250 14 D0270 15 D0272 16 D0274 17 D0320 18 D0321 19 D0322 20 D0330 21 D0340 22 D0350 23 D0351 24 D0364 25 D0365 26 D0366 27 D0367 Description Periodic Oral Evaluation   Established Patient Limited Oral Evaluation   Problem Focused Oral Evaluation, Patient Under Three Comprehensive Oral Evaluation   New Or Established Patient Re Evaluation   Limited, Problem Focused Re Evaluation   Post Operative Office Visit Comprehensive Periodontal Evaluation   New Or Established Patient Intraoral   Complete Series of Radiographic Images Intraoral   Periapical First Radiographic Image Intraoral   Periapical Each Additional Image Intraoral   Occlusal Radiographic Image Extraoral   2D Projection Radiographic image Bitewing   Single Radiographic Image Bitewings   Two Radiographic Images Bitewings   Four Radiographic Images Temporomandibular Joint Arthrogram, Including Injection Other Temporomandibular Joint Radiographic Images, By Report Tomographic Survey Panoramic Radiographic Image 2D Cephalometric Radiographic Image Oral Facial Photographic Images Oral Facial Photographic Images Cone Beam   Less Than One Whole Jaw Cone Beam   One Full Dental Arch   Mandible Cone Beam   One Full Dental Arch   Maxilla Cone Beam   Both Jaws Comparsion HZ NJ MDH UHC Medicare 6 66 41 3 2 5 66 34 36 1 389 91 104 145 TI  UHC Medicaid   AutoSave Off Code Comparsion   Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 1   A A ab Wrap Text General Paste U   1   A Merge   Center   6 0  00 Clipboard Font Alignment Number B13 X fic Bitewings   Four Radiographic Images B D E Total Auths 120 5 2 15 3 6 30 3 3 55 100 16 A 1 Code 2 D0120 3 D0140 4 D0145 5 DO150 6 D0170 7 D0180 8 DO210 9 DO220 10 DO230 11 D0240 12 D0272 13 D0274 14 D0320 15 D0330 16 D0340 17 D0350 18 D0351 19 D0364 20 D0365 21 D0366 22 D0367 23 D0380 24 D0383 25 D0391 26 D0414 27 D0431 Description Periodic Oral Evaluation   Established Patient Limited Oral Evaluation   Problem Focused Oral Evaluation, Patient Under Three Comprehensive Oral Evaluation   New Or Established Patient Re Evaluation   Limited, Problem Focused Comprehensive Periodontal Evaluation   New Or Established Patient Intraoral   Complete Series of Radiographic Images Intraoral   Periapical First Radiographic Image Intraoral   Periapical Each Additional Image Intraoral   Occlusal Radiographic Image Bitewings   Two Radiographic Images Bitewings   Four Radiographic Images Temporomandibular Joint Arthrogram, Including Injection Panoramic Radiographic Image 2D Cephalometric Radiographic Image Oral Facial Photographic Images Oral Facial Photographic Images Cone Beam   Less Than One Whole Jaw Cone Beam   One Full Dental Arch   Mandible Cone Beam   One Full Dental Arch   Maxilla Cone Beam   Both Jaws Cone Beam   Less Than One Whole Jaw Cone Beam   Both Jaws Interpretation Of Diagnostic Image Laboratory processing of microbial specimen Adjunctive Pre Diagnostic Test That Aids In Detection Of Mucosal Abnormalities 1 160 780 62 6 6 2 6 13 1 5 1 1 15 Comparsion HZ NJ MDH UHC Medicaid UHC Medicare   AutoSave Off Code Comparsion   Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 A A ab Wrap Text General Paste BI U   1 Merge   Center   Clipboard Font Alignment Num B15 X Removal of Impacted Tooth   Partially Bony D E C Total Auths 19854 19848 19082 18870 18752 18750 18592 18209 16870 15900 15605 A B 1 Code Description 2 D3320 Endodontic Therapy Premolar Tooth (Excluding Final Restoration) 3 D2751 Crown   Porcelain Fused To Predominantly Base Metal 4 D2740 Crown   Porcelain Ceramic 5 D2954 Prefabricated Post And Core In Addition To Crown 6 D2750 Crown   Porcelain Fused To High Noble Metal 7 DO140 Limited Oral Evaluation   Problem Focused 8 D9223 Deep Sedation   General Anesthesia   Each subsequent 15 Minute Increment 9 D3330 Endodontic Therapy, Molar tooth (Excluding Final Restoration) 10 D8080 Comprehensive Orthodontic Treatment Of The Adolescent Dentition 11 D4341 Periodontal Scaling And Root Planing   Four Or More Teeth Per Quadrant 12 D9222 Deep Sedation General Anesthesia   First 15 Minutes 13 D9230 Inhalation Of Nitrous Analgesia, Anxiolysis 14 D3310 Endodontic Therapy, Anterior Tooth (Excluding Final Restoration) 15 D7230 Removal Of Impacted Tooth   Partially Bony 16 D5110 Complete Denture   Maxillary 17 D5214 Mandibular Partial Denture   Cast Metal Framework With Resin Denture Bases 18 D7140 Extraction, Erupted Tooth Or Exposed Root 19 D2930 Prefabricated Stainless Steel Crown   Primary Tooth 20 D7210 Extraction, Erupted Tooth 21 D2950 Core Buildup, Including Any Pins When Required 22 D9999 Unspecified Adjunctive Procedure, By Report 23 D2392 Resin Based Composite   Two Surfaces, Posterior 24 D2752 Crown   Porcelain Fused To Noble Metal 25 D5120 Complete Denture   Mandibular 26 D7240 Removal Of Impacted Tooth   Completely Bony 27 D8670 Periodic Orthodontic Treatment Visit 15202 9478 9601 9497 9479 9302 9193 9108 9070 8606 8553 8371 8093 5928 7213 2010 Comparsion HZ NJ MDH UHC Medicaid UHC Medicare   AutoSave Off Code Comparsion   Excel File Home Insert Page Layout Formulas Data Review View Help Search Calibri   11   ab Wrap Text General Paste Merge   Center $     Clipboard Font Alignment Num  B13 Endodontic Therapy Premolar Tooth (Excluding Final Restoration) D E A B 1 Code Description 2 D2950 Core Buildup, Including Any Pins When Required 3 D2740 Crown   Porcelain Ceramic 4 D4341 Periodontal Scaling And Root Planing   Four Or More Teeth Per Quadrant 5 D5110 Complete Denture   Maxillary 6 D5214 mandibular partial denture   cast metal framework with resin denture bases 7 D5120 Complete Denture   Mandibular 8 D2750 Crown   Porcelain Fused To High Noble Metal 9 D4342 Periodontal Scaling And Root Planing   One To Three Teeth Per Quadrant 10 D5213 maxillary partial denture   cast metal framework with resin denture bases 11 D5130 Immediate Denture   Maxillary 12 D3310 Endodontic Therapy, Anterior Tooth (Excluding Final Restoration) 13 D3320 Endodontic Therapy Premolar Tooth (Excluding Final Restoration) 14 D5214 mandibular partial denture   cast metal framework with resin denture bases (incl 15 D5212 Mandibular Partial Denture   Resin Base 16 D2954 Prefabricated Post And Core In Addition To Crown 17 D2751 Crown   Porcelain Fused To Predominantly Base Metal 18 D3330 Endodontic Therapy, Molar tooth (Excluding Final Restoration) 19 D5211 Maxillary Partial Denture   Resin Base 20 D5213 maxillary partial denture   cast metal framework with resin denture bases (inclu 21 D6240 Pontic   Porcelain Fused To High Noble Metal 22 D7250 Removal Of Residual Tooth (Cutting Procedure) 23 D5140 Immediate Denture   Mandibular 24 D7210 Extraction, Erupted Tooth 25 D6750 Retainer Crown   Porcelain Fused To High Noble Metal 26 D6010 Surgical Placement Of Implant Body  Endosteal Implant 27 D9223 Deep Sedation   General Anesthesia   Each subsequent 15 Minute Increment Comparsion 9 HZ Nj MDH UHC Medicaid UHC Medicare   Total Auths 15818 15374 12884 12872 10290 10091 5548 5332 5052 4703 4605 4515 4316 4183 4009 3862 3737 3580 3452 3068 2500 2276 2268 2252 2072 1583 AutoSave Off H File Home Insert Page Layout Formulas Data Review View Help Search Calibri 11 A A ce Wrap Text ab Paste B 1 U Merge   CE Clipboard Font Alignment G15 3 X D E F G H B Code Description 1 HZ NJ MDH UHC Medicaid UHC Medicare 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 20 Comparsion HZ NJ MDH UHC Medicaid UHC Medicare

Accepted Answer

The Answer is in the image, click to view ...

Question

This Spreadsheet contains 5 tabs: ( HZ NJ, MDH, UHC Medicaid, UHC Medicare) the fifth tab is the comparison tab, where i would need the

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Concepts of Database Management

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question