Screen Shots for Excel Manipulation

Document Sample
Screen Shots for Excel Manipulation Powered By Docstoc
					Screen Shots for Excel
    Manipulation
Presented by the UBO Program
          Manager
       September 2006
                Overview
• This is a hands on mini class so you can
  use these data
• If you aren’t good at manipulating Excel, if
  possible, call in from someone’s desk
  where you can open the Excel file you
  down loaded from the web
                 Objective
• With 10 minutes and these screen shots,
  you will be able to select just your facility,
  and be able to identify those outpatient
  clinics using ICD-9-CM codes that have
  changed, or have been deleted.
                     Get
          Facility   NPI
          Service    type       Facility Type
DMIS ID   Code       2?         Code          DMIS Facility Name               Facility Name            Installation Name
0001      A          yes    y   CLINIC       FOX AHC-REDSTONE ARSENAL          FOX ARMY HEALTH CENTER    REDSTONE ARSENAL
0003      A          yes    y   HOSP         LYSTER ACH-FT. RUCKER             LYSTER ACH                FT. RUCKER
0005      A          yes    y   HOSP         BASSETT ACH-FT. WAINWRIGHT        BASSETT ACH               FT. WAINWRIGHT
0008      A          yes    y   CLINIC       R W BLISS AHC-FT. HUACHUCA                                  FT.
                                                                               R W BLISS ARMY HEALTH CENTER HUACHUCA
0032      A          yes    y   HOSP         EVANS ACH-FT. CARSON              EVANS ACH                 FT. CARSON
0037      A          yes    y   HOSP         WALTER REED AMC-WASHINGTON DC                               WASHINGTON DC
                                                                               WALTER REED ARMY MEDICAL CENTER
0047      A          yes    y   HOSP         EISENHOWER AMC-FT. GORDON         EISENHOWER AMC            FT. GORDON
0048      A          yes    y   HOSP         MARTIN ACH-FT. BENNING            MARTIN ACH                FT. BENNING
0049      A          yes    y   HOSP         WINN ACH-FT. STEWART              WINN ACH                  FT. STEWART
0052      A          yes    y   HOSP         TRIPLER AMC-FT SHAFTER            TRIPLER AMC               FT. SHAFTER
0057      A          yes    y   HOSP         IRWIN ACH-FT. RILEY               IRWIN ACH                 FT. RILEY
0058      A          yes    y   CLINIC       MUNSON AHC-FT. LEAVENWORTH                                  FT.
                                                                               MUNSON ARMY HEALTH CENTER LEAVENWORTH
0060      A          yes    y   HOSP         BLANCHFIELD ACH-FT. CAMPBELL      BLANCHFIELD ACH           FT. CAMPBELL
0061      A          yes    y   HOSP         IRELAND ACH-FT. KNOX              IRELAND ACH               FT. KNOX
0064      A          yes    y   HOSP         BAYNE-JONES ACH-FT. POLK          BAYNE-JONES ACH           FT. POLK
0069      A          yes    y   CLINIC       KIMBROUGH AMB CAR CEN-FT MEADE                              FT. MEADE
                                                                               KIMBROUGH AMBULATORY CARE CENTER
0075      A          yes    y   HOSP         L. WOOD ACH-FT. LEONARD WOOD      L. WOOD ACH               FT. LEONARD WOOD
0081      A          yes    y   CLINIC       PATTERSON AHC-FT. MONMOUTH        PATTERSON AHC             FT. MONMOUTH
0086      A          yes    y   HOSP         KELLER ACH-WEST POINT             KELLER ACH                WEST POINT
0089      A          yes    y   HOSP         WOMACK AMC-FT. BRAGG              WOMACK AMC                FT. BRAGG
0098      A          yes    y   HOSP         REYNOLDS ACH-FT. SILL             REYNOLDS ACH              FT. SILL
0105      A          yes    y   HOSP         MONCRIEF ACH-FT. JACKSON          MONCRIEF ACH              FT. JACKSON
0108      A          yes    y   HOSP         WILLIAM BEAUMONT AMC-FT. BLISS    WILLIAM BEAUMONT AMC      FT. BLISS
0109      A          yes    y   HOSP         BROOKE AMC-FT. SAM HOUSTON        BROOKE AMC                FT. SAM HOUSTON
0110      A          yes    y   HOSP         DARNALL ACH-FT. HOOD              DARNALL ACH               FT. HOOD
0121      A          yes    y   HOSP         MCDONALD ACH-FT. EUSTIS           MCDONALD ACH              FT. EUSTIS
0122      A          yes    y   CLINIC       KENNER AHC-FT. LEE                KENNER AHC                FT. LEE
0123      A          yes    y   HOSP         DEWITT ACH-FT. BELVOIR            DEWITT ACH                FT. BELVOIR
0125      A          yes    y   HOSP         MADIGAN AMC-FT. LEWIS             MADIGAN AMC               FT. LEWIS
0131      A          yes    y   HOSP         WEED ACH-FT. IRWIN                WEED ACH                  FT. IRWIN
0204      A          yes        CLINIC       TMC FT. RICHARDSON                TMC FT. RICHARDSON        FT. RICHARDSON
0247      A          yes        CLINIC       MONTEREY AHC                      MONTEREY AHC              MONTEREY
0255      A          yes        CLINIC       MCNAIR AHC                        MCNAIR AHC                FT. MCNAIR
0256      A          yes        CLINIC       DILORENZO TRICARE HEALTH CLINIC                             PENTAGON
                                                                               DILORENZO TRICARE HEALTH CLINIC
0464      A          yes        CLINIC       AHC FT. STORY                     AHC FT. STORY             FT. STORY
0612      A          yes    y   HOSP         121st GEN HOSP-SEOUL              121st GENERAL HOSPITAL    SEOUL
                     Get
          Facility   NPI
          Service    type       Facility Type
DMIS ID   Code       2?         Code          DMIS Facility Name        Facility Name         Installation Name
0024      N          yes    y   HOSP         NH CAMP PENDLETON          NH CAMP PENDLETON     CAMP PENDLETON
0026      N          yes    y   CLINIC       NACC PORT HUENEME          NACC PORT HUENEME     PORT HUENEME
0028      N          yes    y   HOSP         NH LEMOORE                 NH LEMOORE            LEMOORE
0029      N          yes    y   HOSP         NMC SAN DIEGO              NMC SAN DIEGO         SAN DIEGO
0030      N          yes    y   HOSP         NH TWENTYNINE PALMS        NH TWENTYNINE PALMS   TWENTYNINE PALMS
0035      N          yes    y   CLINIC       NACC GROTON                NACC GROTON           GROTON
0038      N          yes    y   HOSP         NH PENSACOLA               NH PENSACOLA          PENSACOLA
0039      N          yes    y   HOSP         NH JACKSONVILLE            NH JACKSONVILLE       JACKSONVILLE
0056      N          yes    y   HOSP         NH GREAT LAKES             NH GREAT LAKES        GREAT LAKES
0067      N          yes    y   HOSP         NNMC BETHESDA              NNMC BETHESDA         BETHESDA
0068      N          yes    y   CLINIC       NMCL PATUXENT RIVER        NMCL PATUXENT RIVER   PATUXENT RIVER
0091      N          yes    y   HOSP         NH CAMP LEJEUNE            NH CAMP LEJEUNE       CAMP LEJEUNE
0092      N          yes    y   HOSP         NH CHERRY POINT            NH CHERRY POINT       CHERRY POINT
0100      N          yes    y   CLINIC       NACC NEWPORT               NACC NEWPORT          NEWPORT
0103      N          yes    y   HOSP         NH CHARLESTON              NH CHARLESTON         CHARLESTON
0104      N          yes    y   HOSP         NH BEAUFORT                NH BEAUFORT           BEAUFORT
0107      N          yes        CLINIC       BMC NSA MID-SOUTH          BMC NSA MID-SOUTH     MILLINGTON
0118      N          yes    y   HOSP         NH CORPUS CHRISTI          NH CORPUS CHRISTI     CORPUS CHRISTI
0124      N          yes    y   HOSP         NMC PORTSMOUTH             NMC PORTSMOUTH        PORTSMOUTH
0126      N          yes    y   HOSP         NH BREMERTON               NH BREMERTON          BREMERTON
0127      N          yes    y   HOSP         NH OAK HARBOR              NH OAK HARBOR         OAK HARBOR
0280      N          yes    y   CLINIC       NMCL PEARL HARBOR          NMCL PEARL HARBOR     PEARL HARBOR
0297      N          yes    y   CLINIC       NACC NEW ORLEANS           NACC NEW ORLEANS      NEW ORLEANS
0385      N          yes    y   CLINIC       NMCL QUANTICO              NMCL QUANTICO         QUANTICO
0615      N          yes    y   HOSP         NH GUANTANAMO BAY          NH GUANTANAMO BAY     GUANTANAMO BAY
0616      N          yes    y   HOSP         NH ROOSEVELT ROADS-CEIBA   NH ROOSEVELT ROADS    CEIBA
0617      N          yes    y   HOSP         NH NAPLES                  NH NAPLES             NAPLES
0618      N          yes    y   HOSP         NH ROTA                    NH ROTA               ROTA
0620      N          yes    y   HOSP         NH GUAM-AGANA              NH GUAM               AGANA
0621      N          yes    y   HOSP         NH OKINAWA                 NH OKINAWA            OKINAWA
0622      N          yes    y   HOSP         NH YOKOSUKA                NH YOKOSUKA           YOKOSUKA
0623      N          yes    y   HOSP         NH KEFLAVIK                NH KEFLAVIK           KEFLAVIK
0624      N          yes    y   HOSP         NH SIGONELLA               NH SIGONELLA          NAS SIGONELLA
                     Get
          Facility   NPI
          Service    type       Facility Type
DMIS ID   Code       2?         Code          DMIS Facility Name              Facility Name           Installation Name
0004      F          yes    y   CLINIC       42ND MEDICAL GROUP-MAXWELL       42ND MEDICAL GROUP       MAXWELL AFB
0006      F          yes    y   HOSP         3rd MED GRP-ELMENDORF            3rd MEDICAL GROUP        ELMENDORF AFB
0009      F          yes    y   HOSP         56th MED GRP-LUKE                56th MEDICAL GROUP       LUKE AFB
0010      F          yes    y   CLINIC       355th MED GRP-DAVIS MONTHAN      355th MEDICAL GROUP      DAVIS MONTHAN AFB
0013      F          yes    y   CLINIC       314th MED GRP-LITTLE ROCK        314th MEDICAL GROUP      LITTLE ROCK AFB
0014      F          yes    y   HOSP         60th MED GRP-TRAVIS              60th MEDICAL GROUP       TRAVIS AFB
0015      F          yes    y   CLINIC       9th MED GRP-BEALE                9th MEDICAL GROUP        BEALE AFB
0018      F          yes    y   CLINIC       30th MED GRP-VANDENBERG          30th MEDICAL GROUP       VANDENBERG AFB
0019      F          yes    y   CLINIC       95th MED GRP-EDWARDS             95th MEDICAL GROUP       EDWARDS AFB
0033      F          yes    y   HOSP         10th MED GROUP-USAF ACADEMY CO   10TH MEDICAL GROUP       USAF ACADEMY
0036      F          yes    y   CLINIC       436th MED GRP-DOVER              436th MEDICAL GROUP      DOVER AFB
0042      F          yes    y   HOSP         96th MED GRP-EGLIN               96th MEDICAL GROUP       EGLIN AFB
0043      F          yes    y   CLINIC       325th MED GRP-TYNDALL            325th MEDICAL GROUP      TYNDALL AFB
0045      F          yes    y   HOSP         6th MED GRP-MACDILL              6th MEDICAL GROUP        MACDILL AFB
0046      F          yes    y   CLINIC       45th MED GRP-PATRICK             45th MEDICAL GROUP       PATRICK AFB
0050      F          yes    y   CLINIC       347th MED GRP-MOODY              347th MEDICAL GROUP      MOODY AFB
0051      F          yes    y   CLINIC       78th MED GRP-ROBINS              78th MEDICAL GROUP       ROBINS AFB
0053      F          yes    y   HOSP         366th MED GRP-MOUNTAIN HOME      366th MEDICAL GROUP      MOUNTAIN HOME AFB
0055      F          yes    y   HOSP         375th MED GRP-SCOTT              375th MEDICAL GROUP      SCOTT AFB
0059      F          yes    y   CLINIC       22nd MED GRP-MCCONNELL           22nd MEDICAL GROUP       MCCONNELL AFB
0062      F          yes    y   CLINIC       2nd MED GRP-BARKSDALE            2nd MEDICAL GROUP        BARKSDALE AFB
0066      F          yes    y   HOSP         89th MED GRP-ANDREWS             89th MEDICAL GROUP       ANDREWS AFB
0073      F          yes    y   HOSP         81st MED GRP-KEESLER             81st MEDICAL GROUP       KEESLER AFB
0074      F          yes    y   CLINIC       14th MED GRP-COLUMBUS            14th MEDICAL GROUP       COLUMBUS AFB
0076      F          yes    y   CLINIC       509th MED GRP-WHITEMAN           509th MEDICAL GROUP      WHITEMAN AFB
0077      F          yes    y   CLINIC       341st MED GRP-MALMSTROM          341st MEDICAL GROUP      MALMSTROM AFB
0078      F          yes    y   HOSP         55th MED GRP-OFFUTT              55th MEDICAL GROUP       OFFUTT AFB
0079      F          yes    y   HOSP         99th MED GRP-O'CALLAGHAN HOSP                             NELLIS AFB
                                                                              MICHAEL O'CALLAGHAN FEDERAL HOSPITAL
0083      F          yes    y   CLINIC       377th MED GRP-KIRTLAND           377th MEDICAL GROUP      KIRTLAND AFB
0084      F          yes    y   CLINIC       49th MED GRP-HOLLOMAN            49th MEDICAL GROUP       HOLLOMAN AFB
0085      F          yes    y   CLINIC       27th MED GRP-CANNON              27th MEDICAL GROUP       CANNON AFB
0090      F          yes    y   CLINIC       4th MED GRP-SEYMOUR JOHNSON      4th MEDICAL GROUP        SEYMOUR JOHNSON AFB
0093      F          yes    y   CLINIC       319th MED GRP-GRAND FORKS        319th MEDICAL GROUP      GRAND FORKS AFB
0094      F          yes    y   CLINIC       5th MED GRP-MINOT                5th MEDICAL GROUP        MINOT AFB
0095      F          yes    y   HOSP         74th MED GRP-WRIGHT-PATTERSON    74th MEDICAL GROUP       WRIGHT-PATTERSON AFB
0096      F          yes    y   CLINIC       72nd MED GRP-TINKER              72nd MEDICAL GROUP       TINKER AFB
0097   F   yes   y CLINIC    97th MED GRP-ALTUS           97th MEDICAL GROUP       ALTUS AFB
0101   F   yes   y HOSP      20th MED GRP-SHAW            20th MEDICAL GROUP       SHAW AFB
0106   F   yes   y CLINIC    28th MED GRP-ELLSWORTH       28th MEDICAL GROUP       ELLSWORTH AFB
0112   F   yes   y CLINIC    7th MED GRP-DYESS            7th MEDICAL GROUP        DYESS AFB
0113   F   yes   y HOSP      82nd MED GRP-SHEPPARD        82nd MEDICAL GROUP       SHEPPARD AFB
0114   F   yes   y CLINIC    47th MED GRP-LAUGHLIN        47th MEDICAL GROUP       LAUGHLIN AFB
0117   F   yes   y HOSP      59th MED WING-LACKLAND       59th MEDICAL WING        LACKLAND AFB
0119   F   yes   y CLINIC    75th MED GRP-HILL            75th MEDICAL GROUP       HILL AFB
0120   F   yes   y HOSP      1st MED GRP-LANGLEY          1st MEDICAL GROUP        LANGLEY AFB
0128   F   yes   y CLINIC    92nd MED GRP-FAIRCHILD       92nd MEDICAL GROUP       FAIRCHILD AFB
0129   F   yes   y CLINIC    90th MED GRP-F.E. WARREN     90th MEDICAL GROUP       F.E. WARREN AFB
0203   F   yes   y CLINIC    354th MED GRP-EIELSON        354th MEDICAL GROUP      EIELSON AFB
0248   F   yes   y CLINIC    61st MED SQUAD-LOS ANGELES   61st MEDICAL SQUADRON    LOS ANGELES AFS
0252   F   yes      CLINIC
                 maybe       10th MED GRP-PETERSON        10th MEDICAL GROUP       PETERSON AFB
0287   F   yes   y CLINIC    15th MED GRP-HICKAM          15th MEDICAL GROUP       HICKAM AFB
0310   F   yes   y CLINIC    66th MED GRP-HANSCOM         66th MEDICAL GROUP       HANSCOM AFB
0326   F   yes   y CLINIC    305th MED GRP-MCGUIRE        305th MEDICAL GROUP      MCGUIRE AFB
0335   F   yes   y CLINIC    43RD MEDICAL GROUP-POPE      43RD MEDICAL GROUP       POPE AFB
0338   F   yes   y CLINIC    71st MED GRP-VANCE           71st MEDICAL GROUP       VANCE AFB
0356   F   yes   y CLINIC    437th MED GRP-CHARLESTON     437th MEDICAL GROUP      CHARLESTON AFB
0363   F   yes   y CLINIC    311TH MED SQUAD-BROOKS       311TH MEDICAL SQUADRON   BROOKS CITY-BASE
0364   F   yes   y CLINIC    17th MED GRP-GOODFELLOW      17th MEDICAL GROUP       GOODFELLOW AFB
0366   F   yes   y CLINIC    12th MED GRP-RANDOLPH        12th MEDICAL GROUP       RANDOLPH AFB
0395   F   yes   y CLINIC    62nd MED GRP-MCCHORD         62nd MEDICAL GROUP       MCCHORD AFB
0629   F   yes      CLINIC
                 maybe       65th MED GRP-LAJES           65th MEDICAL GROUP       LAJES FLD
0633   F   yes      HOSP
                 maybe       48th MED GRP-LAKENHEATH      48th MEDICAL GROUP       RAF LAKENHEATH
0635   F   yes      HOSP
                 maybe       39th MED GRP-INCIRLIK        39th MEDICAL GROUP       INCIRLIK AB
0637   F   yes      CLINIC
                 doubt       8th MED GRP-KUNSAN AB        8th MEDICAL GROUP        KUNSAN AB
0638   F   yes      HOSP
                 maybe       51st MED GRP-OSAN AB         51st MEDICAL GROUP       OSAN AB
0639   F   yes      HOSP
                 maybe       35th MED GRP-MISAWA          35th MEDICAL GROUP       MISAWA
0640   F   yes      HOSP
                 maybe       374th MED GRP-YOKOTA AB      374th MEDICAL GROUP      YOKOTA AB
0653   F   yes      CLINIC
                 maybe       422 ABS MED FLT-CROUGHTON    422 ABS MEDICAL FLIGHT   RAF CROUGHTON
0799   F   yes   y CLINIC    470 MED FLT-GEILENKIRCHEN    470 MEDICAL FLIGHT       GEILENKIRCHEN AB
0800   F   yes   y CLINIC    469th MED FLT-RHEIN MAIN     469th MEDICAL FLIGHT     RHEIN MAIN AB
0802   F   yes   y CLINIC    36th MED GRP-ANDERSEN        36th MEDICAL GROUP       ANDERSEN AFB
0804   F   yes   y CLINIC    18th MED GRP-KADENA AB       18th MEDICAL GROUP       KADENA AB
0805   F   yes   y HOSP      52nd MED GROUP-SPANGDAHLEM   52nd MEDICAL GROUP       SPANGDAHLEM AB
0629   F   yes      CLINIC
                 maybe       65th MED GRP-LAJES            65th MEDICAL GROUP       LAJES FLD
0633   F   yes      HOSP
                 maybe       48th MED GRP-LAKENHEATH       48th MEDICAL GROUP       RAF LAKENHEATH
0635   F   yes      HOSP
                 maybe       39th MED GRP-INCIRLIK         39th MEDICAL GROUP       INCIRLIK AB
0637   F   yes      CLINIC
                 doubt       8th MED GRP-KUNSAN AB         8th MEDICAL GROUP        KUNSAN AB
0638   F   yes      HOSP
                 maybe       51st MED GRP-OSAN AB          51st MEDICAL GROUP       OSAN AB
0639   F   yes      HOSP
                 maybe       35th MED GRP-MISAWA           35th MEDICAL GROUP       MISAWA
0640   F   yes      HOSP
                 maybe       374th MED GRP-YOKOTA AB       374th MEDICAL GROUP      YOKOTA AB
0653   F   yes      CLINIC
                 maybe       422 ABS MED FLT-CROUGHTON     422 ABS MEDICAL FLIGHT   RAF CROUGHTON
0799   F   yes   y CLINIC    470 MED FLT-GEILENKIRCHEN     470 MEDICAL FLIGHT       GEILENKIRCHEN AB
0800   F   yes   y CLINIC    469th MED FLT-RHEIN MAIN      469th MEDICAL FLIGHT     RHEIN MAIN AB
0802   F   yes   y CLINIC    36th MED GRP-ANDERSEN         36th MEDICAL GROUP       ANDERSEN AFB
0804   F   yes   y CLINIC    18th MED GRP-KADENA AB        18th MEDICAL GROUP       KADENA AB
0805   F   yes   y HOSP      52nd MED GROUP-SPANGDAHLEM    52nd MEDICAL GROUP       SPANGDAHLEM AB
0806   F   yes   y CLINIC    86th MED GRP-RAMSTEIN         86th MEDICAL GROUP       RAMSTEIN AB
0808   F   yes   y HOSP      31st MED GRP-AVIANO           31st MEDICAL GROUP       AVIANO AB
7139   F   yes   y CLINIC    16th MED GRP-HURLBURT FIELD   16th MEDICAL GROUP       HURLBURT FIELD
7200   F   yes   y CLINIC    460 MDS-BUCKLEY AFB           460 MDS-BUCKLEY AFB      BUCKLEY AFB
    2
1


    3   4
1
    1


        2
        3


4
1

    2
1


2

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:4
posted:7/30/2012
language:
pages:13