Data Laporan Petugas
     • Questions
         –Total animals of each species
         –Vitamin usage
             • Proportion treated with vitamins
             • Of those treated, proportion survived
             • Of those not treated, proportion survived
         –List the five most common diseases
             • Display on a graph
         –Seasonal pattern of disease
             • Chart of reported incidence by month
                   AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                   AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                        Data cleaning
     • Move all data into single worksheet
     • Remove all merged cells
     • Sort all data by date
        –Headers and empty fields go to bottom
        –Delete unneeded rows
        –Remove all lines
                  AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                  AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
         Separating species and number
     • Two approaches
         –Use of formula
             • A bit complex
             • Some manual correction needed
         –Use of “Text to Column function”
             • Faster, simpler
             • Some manual correction needed
                   AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                   AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
           Formulae that could be used
     • Search()
     • Trim()
     • Left()
     • Proper()
     • Mid()
     • Iserror()
     • As well as some manual error correction
                  AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                  AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                      Text to columns
     • Make empty column
     • Highligh Jenis & JML column
     • Click Text to Columns on Data tab
     • Delimited, then Next
     • Check space and other, then enter ‘-’ for other
     • Click Finish
                  AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES
                  AUSTRALIA INDONESIA PARTNERSHIP FOR EMERGING INFECTIOUS DISEASES