Question: For this assignment, you are to clean some real data. Attached is an extract from one of my previous material category for Batteries. This file

For this assignment, you are to clean some real
For this assignment, you are to clean some real
For this assignment, you are to clean some real data. Attached is an extract from one of my previous material category for Batteries. This file is a hot mess and I need to find as many errors as possible. There are problems with the Vendor Name, Item Numbers, etc. Highlight them in the Excel file and submit it to the Dropbox folder before Sunday. Here's some file details that may help you in cleaning the data: Authorized vendor names: Unipower Corp., Jet Medical Electronics, Alpha Source, Item Numbers: start with a letter "A. B, C and ends in 5 numbers Item Description: must contain "battery" and a voltage xxV" and amperage "AH" UOM: each Rovd Qty: must be a number (or it wasn't received) Rcvd Line: must be currency Inv Paid: must be paid if line is Rcvd. Site Code: six digit number Facility must have a name including the phrase "MED CTR, HEALTH, HOSP, HOSPITAL See how many you can find 1x LATI 21A Loeng for trendemos IN NUMBER UNFOWER OT DISON 000010 14 VENDOR NAME D TEM NUM ITEM DESC UNIPOWER CORP UOM 2 UWE CORP OCH MATTERY M1792 fach 1011 UNIPOWER CON 12 VOLT BATTERY Each ET BATTERY V TAH POWER COND B000 BATINAH Each B0093 JET MEDICAL ELECTRONICS UFEPACKTOP LIFEPACK OP DERBULATOR POWER CON CNPOWER CON B00220 BATTERY 12V 12 Each Each BATTERY 12V POWER CON 00012 BATTERY 17 Each 11JEVO 01002 BAT Each POWER CORE 100 HATTERY ANAH Each UNIPOWER CORP DATTERY RAH Each SACO BATTERY 12V 2AH Each UNIOWTOONP 01000 BATTERY FOR WELCH ALLYN 12100 Tach UNPOWER CORP 2 BATTERY 1 Each MILWAUKE BATTERY Bach O CORP 6400 BATTERY IN Each POWER.COM 00330 MATERY VTIAH Eachi 20 OLOHUNDY JA LIGHT SOURCES Each DROPOWER CONp 11 Na Cach UPOWROOM B0254 BATTERY Lach UWCOM HURACED W80025 Each DONGA BURLY LAM WELCH ALLYN 00000 Farh DUPLY HO OVLAMP Cach m UNIOWE BATTERY W Each 1 KASTORNOSCO STADOCH Farh POWER CON 3106 ATT Force Each BUCHTINGARFLY 2014 VINORGE Cach 30 DOLING & SUPPLY BULB 1 NETWORK MEDIATIC ob 00 LIKOOL FOR UROWER COM 10020 BATTERY TV 2 E E 0 RCVO OTY RCVO LINE SAMT IW PAID SAMT 1 SITECODE FACILITY 1850 S 2 00000 SINO DRUNCH MOCH BOOS + 3 29162162209 SPRING BRANCH MEDCT 1246 BI 2 . SPRING BRANCH MENTA 1405 10 5 5 100 76112 COVENANT HEALTH SYSTEM P10140 0 1 NINTURA HOOPS MOC 10.00 10:46 OTTO COOL GAMITAN HOOP 25.50 2010 ARLINGTON MED CITA 11220 1122087220 SLOMSSM HOOR 1 13435 25700 COVENANT HEALTH SYSTEM 14 1 2130 P10 WATU WAREY MARLTON 101.203 2010 COLUMBIA UNASEHOOR A MOCN 12 COLUMBIA SUNROUPS MED CF 2 5 2015 2018219 NORTH TEXANDMINE 16.113 21901047 DO NOTUESIT NUR 3 4221 422151342 SARAH BRUSH INDONEALTH CENTER $ 17.00 5125 COCURA ALEXA GROTHERS S 040 1863 st25 COLUMNA ALESIANOTHERS 3 3675 3.750 GULF COAST HOP 18 24 00200 ORGANCH MOOTH 1 000 30.000 JOSE DIOR 20 1 246005 295.00 COLUMBONEROSA MEDC 3 1 21 UN 1 21 CAWOOD HORTAL/BAWAY INIMO 1 370 3740192070 COLUNA GONOMO 1 5 100 BATCHER TAMONLY 1 1306 150 DOANHEALTH + $ 195.00 ha ROU MIDOR 4 2000 13.10 O MOCR DOO WOOLITYCATWO 1 200 UNVESTY CHLORINHOS 110 OOS 10. GO 100 010 OF10- ch OM HO TITAN Lach

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!