Question: One framework for understanding data is to consider the four Vs of data: variety, velocity, veracity and volume. Here are a few examples of important
One framework for understanding data is to consider the four Vs of data: variety, velocity, veracity and volume. Here are a few examples of important questions to consider when evaluating the four Vs of data.
?Variety - different forms and formats of the data
-Are all of the data set formats the same? Do they need to be the same for your analysis?
-all fields contain the same labels? Does the data with similarly titled labels contain the same type of data?
-Are all of the data formats the same? Do they need to be the same for your analysis?
-How are the files delimited? Are there any extra delimiters that may cause problems when importing? What strategies can you take to deal with any of these challenges?
-Are formats consistent for all entries in a field?
-Is the data structured or unstructured? What transformation would need to happen to any unstructured data to make it possible to analyze?
?Velocity - frequency of incoming data that needs processing.
Is your analysis performed on "live" data or only on historical data?






ACT557FilePCardTransactionsFY2010csv [Protected View] - Excel A kaylajcurtiss@gmail.com X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X v fx Agency Number B C D E F G H Document Recovery Agency Number Agency Name Last Name First Initial Item Description Amount Merchant Transaction Date Post Date Purchase Description 2000 OKLAHOMA AC GRAVES D AT&T SERVICE $289.89 ATTM *82787372 5-Aug-09 6-Aug-09 Excel has recovered the following files. Save W N 2000 OKLAHOMA AC GRAVES D GENERAL TRAN$79.95 APPLE STORE : 11-Aug-09 13-Aug-09 the ones you wish to keep. 2000 OKLAHOMA AC GRAVES D FOLDER HANGII $77.95 OFFICE DEPOT 11-Aug-09 13-Aug-09 2000 OKLAHOMA ACI GRAVES GENERAL TRAN$19.95 WALKER STAMI 13-Aug-09 14-Aug-09 ACT557CTOption1CloudyCo... LEE 2000 OKLAHOMA AC GRAVES GENERAL TRAN ($375.00) COUNCIL ON LIC 19-Sep-09 21-Sep-09 Version created last time the.. 7 10/25/2020 9:23 PM 2000 OKLAHOMA AC AUTIN C GENERAL TRAN $395.95 CALUMET CART 9-Nov-09 11-Nov-09 8 2000 OKLAHOMA AC AUTIN C GENERAL TRAN$188.14 ULINE *SHIP SU 5-Nov-09 5-Nov-09 9 2000 OKLAHOMA AC AUTIN GEFORCE 8400 $102.57 DMI* DELL K-12/ 19-Nov-09 19-Nov-09 10 2000 OKLAHOMA AC AUTIN C GENERAL TRAN $75.98 STAPLES 19-Nov-09 20-Nov-09 11 2000 OKLAHOMA AC AUTIN C GENERAL TRAN$14.99 DRI *WWW.ELEN 18-Nov-09 20-Nov-09 12 2000 OKLAHOMA AC AUTIN GENERAL TRAN$84.90 WAL-MART #280 16-Dec-09 17-Dec-09 13 2000 OKLAHOMA ACI AUTIN GENERAL TRAN ($6.56) WM SUPERCEN 16-Dec-09 17-Dec-09 14 2000 OKLAHOMA AC AUTIN C GENERAL TRAN$23.75 WALKER STAMI 11-Dec-09 14-Dec-09 15 2000 OKLAHOMA AC AUTIN BINDING PLAS . $56.33 STAPLESCONTF 29-Dec-09 31-Dec-09 16 2000 OKLAHOMA AC AUTIN GENERAL TRAN $20.40 SOUTH CENTRA 7-Jan-10 11-Jan-10 17 2000 OKLAHOMA AC AUTIN GENERAL TRAN $59.99 STAPLES 12-Jan-10 13-Jan-10 18 2000 OKLAHOMA ACI AUTIN BINDING CVR L1$93.72 STAPLESCONTF 30-Dec-09 4-Jan-10 19 2000 OKLAHOMA AC AUTIN GENERAL TRAN$184.00 THE JOURNAL F 13-Jan-10 14-Jan-10 20 2000 OKLAHOMA AC AUTIN C GCR2077311104 $368.00 STAPLESCONTF 7-Jan-10 11-Jan-10 21 2000 OKLAHOMA AC AUTIN C 256MB ATI RADE $80.29 DMI* DELL K-12/ 19-Jan-10 19-Jan-10 22 2000 OKLAHOMA AC AUTIN C GENERAL TRAN $109.00 SOURCEMEDIA 30-Dec-09 4-Jan-10 23 2000 OKLAHOMA AC AUTIN C GENERAL TRAN $200.20 STAPLES ADVA 13-Jan-10 14-Jan-10 4GB CF EXTREN $158.97 BEST BUY 1-Feb-10 2-Feb-10 ? Which file do I want to save? 24 2000 OKLAHOMA AC AUTIN 25 STAPLESCONTF 16-Feb-10 18-Feb-10 Close 2000 OKLAHOMA ACIAUTIN GCR2077311420 $396.00 ACT557_File_PCard_Transactions_ + + 100% 9:44 PM W TH 11/22/2020ACT557FilePCardTransactionsFY2011csv [Protected View] - Excel A kaylajcurtiss@gmail.com X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X v fx Agency Number A B C D E F G H K L M Agency Number Agency Name Cardholder Last | Cardholder First i Description Amount Vendor Transaction Date Posted Date Merchant Category Code (MCC) 1000 OKLAHOMA ST/KINDRED A GENERAL TRAN $246.75 FREEMAN - DAL 23-Sep-10 23-Sep-10 W N 1000 OKLAHOMA STAKINDRED A GENERAL TRAN$125.00 DALLAS CONVE 23-Sep-10 23-Sep-10 1000 OKLAHOMA STAKINDRED A GENERAL TRAN $293.56 ACT CONVENTION 23-Sep-10 23-Sep-10 1000 OKLAHOMA STAKINDRED A GENERAL TRAN $135.85 SYX*TIGERDIRE 23-Sep-10 23-Sep-10 1000 OKLAHOMA STAWEST B GENERAL TRAN $482.48 CENTRAL RURA 24-Sep-10 24-Sep-10 1000 OKLAHOMA ST/HOCKENBURY S GENERAL TRAN $232.00 STILLWATER TY 24-Sep-10 24-Sep-10 1000 OKLAHOMA STAHODGES N GENERAL TRAN $46.19 WWW.NEWEGO 24-Sep-10 24-Sep-10 1000 OKLAHOMA STAPOGUE C GENERAL TRAN $825.00 COUNCIL ON UN 24-Sep-10 24-Sep-10 10 1000 OKLAHOMA ST/KINDRED A GENERAL TRAN $719.60 NAYLOR.COM 24-Sep-10 24-Sep-10 11 1000 OKLAHOMA STAMCCLURG GENERAL TRAN ($39.53) QUILL CORPOR 24-Sep-10 24-Sep-10 12 1000 OKLAHOMA STA CONNER GENERAL TRAN$46.45 JAMECO-JIMPAI 27-Sep-10 27-Sep-10 13 1000 OKLAHOMA STAMCGUIRE K GENERAL TRAN $208.88 SOUTHERN LOC 27-Sep-10 27-Sep-10 14 1000 OKLAHOMA STAWARD K GENERAL TRAN$450.00 OKLAHOMA JAZ 27-Sep-10 27-Sep-10 15 1000 OKLAHOMA STAMCCLURG L GENERAL TRAN $127.88 STAPLES OC 27-Sep-10 27-Sep-10 16 1000 OKLAHOMA STASHELTON K GENERAL TRAN $96.98 FTD 27-Sep-10 27-Sep-10 17 1000 OKLAHOMA STAWICKSTED C GENERAL TRAN $140.00 LASER SOLUTIC 28-Sep-10 28-Sep-10 18 1000 OKLAHOMA STAWICKSTED C GENERAL TRAN $407.16 OKLAHOMAN-SI 28-Sep-10 28-Sep-10 19 1000 OKLAHOMA STAMEY GENERAL TRAN $106.00 WAL-MART #013 28-Sep-10 28-Sep-10 20 1000 OKLAHOMA STACONNER GENERAL TRAN $56.86 HOB*TOWER HO 29-Sep-10 29-Sep-10 CC 21 1000 OKLAHOMA STAKENNEDY GENERAL TRAN $129.97 THE CHRONICLE 29-Sep-10 29-Sep-10 22 1000 OKLAHOMA STAWICKSTED C GENERAL TRAN $91.70 WAL-MART #013 29-Sep-10 29-Sep-10 23 1000 OKLAHOMA STAWEST B GENERAL TRAN $320.00 LAB SAFETY S 30-Sep-10 30-Sep-10 24 1000 OKLAHOMA STAWEST GENERAL TRAN$1,470.52 STILLWATER BL 20-Sep-10 20-Sep-10 25 1000 OKLAHOMA STAVANDRUFF G GENERAL TRAN $295.00 PAYPAL 20-Sep-10 20-Sep-10 ACT557_File_PCard_Transactions_ + + 100% 9:45 PM TH 11/22/2020ACT557FilePCardTransactionsFY2012csv [Protected View] - Excel A kaylajcurtiss@gmail.com X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X v fx Agency Number A B C D E F G H K M Agency Number Agency Name Cardholder Last I Cardholder First | Description Amount Vendor Transaction Date Posted Date Merchant Category Code (MCC) 1000 OKLAHOMA STABELL D GENERAL PUR( $60.07 WM SUPERCEN 30-Jun-11 1-Jul-11 GROCERY STORES AND SUPERMARKETS W N 1000 OKLAHOMA STABELL GENERAL PUR( $41.29 WM SUPERCEN 30-Jun-11 1-Jul-11 GROCERY STORES AND SUPERMARKETS 1000 OKLAHOMA STABEROUSEK M GENERAL PUR( ($180.00) A.C.E. SUPPLY 30-Jun-11 1-Jul-11 STATIONERY OFFICE SUPPLIES PRINTING AND WRITING PAPER 1000 OKLAHOMA STAFOCHT R GENERAL PUR($9.36 NAPA AUTO PA 29-Jun-11 1-Jul-11 AUTOMOTIVE PARTS AND ACCESSORIES STORES 1000 OKLAHOMA STAFOCHT R GENERAL PUR( $16.86 NAPA AUTO PA 29-Jun-11 1-Jul-11 AUTOMOTIVE PARTS AND ACCESSORIES STORES 1000 OKLAHOMA STAFRANK D GENERAL PURC $1,998.00 STILLWATER BL 29-Jun-11 1-Jul-11 LUMBER AND BUILDING MATERIALS STORES 1000 OKLAHOMA STAFRANK D GENERAL PUR( $579.20 STILLWATER BU 29-Jun-11 1-Jul-11 LUMBER AND BUILDING MATERIALS STORES 1000 OKLAHOMA STAMARTIN GENERAL PUR( $43.94 SS ShopCaselH 30-Jun-11 1-Jul-11 DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE CLASS 10 1000 OKLAHOMA STAMARTIN M PRO PISTOL GR $53.93 AUTOZONE #05: 30-Jun-11 1-Jul-11 AUTOMOTIVE PARTS AND ACCESSORIES STORES 11 1000 OKLAHOMA STAMARTIN M GENERAL PUR( $109.99 SHARPE'S DEP 30-Jun-11 1-Jul-11 MEN'S AND WOMEN'S CLOTHING STORES 12 1000 OKLAHOMA STAMARTIN M DEWALT 18V B/$729.00 LOWES #01580 30-Jun-11 1-Jul-11 HOME SUPPLY WAREHOUSE STORES 13 1000 OKLAHOMA STAMASSEY J GENERAL PURC $110.00 PIONEER RENT, 29-Jun-11 1-Jul-11 HARDWARE STORES 14 1000 OKLAHOMA STAMATTS R Caspase-Glo(R) : $845.00 PROMEGA COR 29-Jun-11 1-Jul-11 DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP AND S 15 1000 OKLAHOMA STAMATTS R GENERAL PURC $3,235.00 PIERCE 030 29-Jun-11 1-Jul-11 CATALOG MERCHANTS 16 1000 OKLAHOMA STAMCAULIFF D MAGNUM 1-3/4 | $30.06 LOWES #00241 30-Jun-11 1-Jul-11 HOME SUPPLY WAREHOUSE STORES 17 1000 OKLAHOMA STAMCCALL C ROOM CHARGE ($224.00) HOLIDAY INN EX 28-Jun-11 1-Jul-11 HOLIDAY INNS 18 1000 OKLAHOMA STAMCCLURG GENERAL PUR( $37.07 LEVENGER CAT 30-Jun-11 1-Jul-11 DIRCT MARKETING/DIRCT MARKETERS-NOT ELSEWHERE CLASS 19 1000 OKLAHOMA STAMCMURRY GENERAL PUR( $39.73 TIMBERLINE FIS 1-Jul-11 1-Jul-11 DIRCT MARKETING/DIRCT MARKETERS-NOT ELSEWHERE CLASS 20 1000 OKLAHOMA STAMCREYNOLDS J GENERAL PUR($4,710.00 DISCOUNT MED 30-Jun-11 1-Jul-11 MISCELLANEOUS AND SPECIALTY RETAIL STORES 21 1000 OKLAHOMA STAMCREYNOLDS J GENERAL PUR( $99.00 WM SUPERCEN 30-Jun-11 1-Jul-11 GROCERY STORES AND SUPERMARKETS 22 1000 OKLAHOMA STAMEEK W GENERAL PUR($1, 185.91 PRIMUS STERIL 30-Jun-11 1-Jul-11 COMMERCIAL EQUIPMENT NOT ELSEWHERE CLASSIFIED 23 1000 OKLAHOMA STAMEEK W GENERAL PUR($17.80 FLECK BEARING 30-Jun-11 1-Jul-11 INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED 24 1000 OKLAHOMA STAMEEK W BRTHING TUBE $178.72 VWR INTERNAT 30-Jun-11 1-Jul-11 DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP AND S 25 1000 OKLAHOMA STAMEGEL A GENERAL PUR( $85.64 SAMPLEPREP 30-Jun-11 1-Jul-11 PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED ACT557_File_PCard_Transactions_ + + 1009% 9:45 PM TH AD ) 11/22/2020ACT557FilePCardTransactionsFY2013csv [Protected View] - Excel A kaylajcurtiss@gmail.com X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X G24 X v fx DEARINGER PRINTING & TROP A B C D E F G H K M Agency Number Agency Name Card Holder Last Card Holder First Description Amount Vendor Transaction Date Posted Date Merchant Category Code (MCC) 1000 OKLAHOMA STA SCHANZ B GENERAL PUR( $29.00 FERGUSON EN 24.07.2012 00:00 25.07.2012 00:00 PLUMBING AND HEATING EQUIPMENT AND SUPPLIES W N 1000 OKLAHOMA STA SCHANZ B GENERAL PUR( $119.80 DOC'S SAVAGE 23.07.2012 00:0025.07.2012 00:00 NURSERIES LAWN AND GARDEN SUPPLY STORES 1000 OKLAHOMA STA SCHIELACK V GENERAL PUR( $84.99 ATW OF CHICK/24.07.2012 00:0025.07.2012 00:00 MISCELLANEOUS AND SPECIALTY RETAIL STORES 1000 OKLAHOMA STA SEMTNER N M10-1.25 HSS 3 $9.63 FASTENAL COM24.07.2012 00:00 25.07.2012 00:00 HARDWARE STORES 1000 OKLAHOMA STA SHELTON C GENERAL PUR( $32.50 WM SUPERCEN 24.07.2012 00:0025.07.2012 00:00 GROCERY STORES AND SUPERMARKETS 1000 OKLAHOMA STA SHERRILL C GENERAL PUR( $51.90 WM SUPERCEN 24.07.2012 00:0025.07.2012 00:00 GROCERY STORES AND SUPERMARKETS 1000 OKLAHOMA STASHIVE P GENERAL PUR($757.00 LASER SOLUTIC 24.07.2012 00:0025.07.2012 00:00 RADIO TELEVISION AND STEREO REPAIR SHOPS 1000 OKLAHOMA STA SHUFRAN A GENERAL PUR( $330.23 ACORN NATURA 23.07.2012 00:00 25.07.2012 00:00 BOOK STORES 10 1000 OKLAHOMA STA SIMON A GENERAL PURC $66.60 CHEM CAN SER 24.07.2012 00:0025.07.2012 00:00 PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED 11 1000 OKLAHOMA STA SIMON A GENERAL PUR( $66.60 CHEM CAN SER 24.07.2012 00:0025.07.2012 00:00 PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED 12 1000 OKLAHOMA STA SIMON A GENERAL PUR($21.84 WOLVERINE BR 23.07.2012 00:0025.07.2012 00:00 HARDWARE STORES 13 1000 OKLAHOMA STA SIMON A PARTS SET $112.35 Fleck Bearing Co 23.07.2012 00:00 25.07.2012 00:00 INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED 14 1000 OKLAHOMA ST/ SIMON A PARTS SET $607.40 Fleck Bearing Co23.07.2012 00:0025.07.2012 00:00 INDUSTRIAL SUPPLIES NOT ELSEWHERE CLASSIFIED 15 1000 OKLAHOMA ST/SIMON A GENERAL PUR( $63.08 DUGMORE DUN 23.07.2012 00:00 25.07.2012 00:00 HARDWARE EQUIPMENT AND SUPPLIES 16 1000 OKLAHOMA STASIMON A GENERAL PUR( $264.00 GRIGSBY'S CAF 23.07.2012 00:0025.07.2012 00:00 FURNITURE HOME FURNISHINGS AND EQUIPMENT STORES 17 1000 OKLAHOMA ST/SIMON A GENERAL PURC $66.60 CHEM CAN SER 24.07.2012 00:0025.07.2012 00:00 PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED 18 1000 OKLAHOMA STASIMON A GENERAL PURC$0.01 CHEM CAN SER 24.07.2012 00:0025.07.2012 00:00 PROFESSIONAL SERVICES NOT ELSEWHERE CLASSIFIED 19 1000 OKLAHOMA ST/ SIMON A GENERAL PUR( $143.49 EEI FILTER DIVI: 23.07.2012 00:00 25.07.2012 00:00 HARDWARE EQUIPMENT AND SUPPLIES 20 1000 OKLAHOMA STA SIMON A GENERAL PUR( $1,486.19 BURK OIL CO IN 24.07.2012 00:0025.07.2012 00:00 SERVICE STATIONS (WITH OR WITHOUT ANCILLARY SERVICES 21 1000 OKLAHOMA STASISCO K GENERAL PUR( $60.80 FISHER'S CENTI 23.07.2012 00:00 25.07.2012 00:00 DRUG STORES AND PHARMACIES 22 1000 OKLAHOMA STADAVIS C GENERAL PUR( $13.72 LOCKE SUPPLY 23.07.2012 00:0025.07.2012 00:00 HARDWARE STORES 23 1000 OKLAHOMA STADAVIS K GENERAL PUR( $175.00 LASER SOURCE 23.07.2012 00:0025.07.2012 00:00 STATIONERY OFFICE AND SCHOOL SUPPLY STORES 24 1000 OKLAHOMA STADAWES C GENERAL PUR( $8.40 DEARINGER PR 23.07.2012 00:00 25.07.2012 00:00 MISCELLANEOUS AND SPECIALTY RETAIL STORES 25 1000 OKLAHOMA STADOBHAL GENERAL PURC $65.23 BIO RAD 24.07.2012 00:00 25.07.2012 00:00 DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP AND S ACT557_File_PCard_Transactions_ + 1 + 100% 9:46 PM 11/22/2020ACT557FilePCardTransactionsFY2014csv-1 [Protected View] - Excel A kaylajcurtiss@gmail.com X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A1 X v fx Agency Number A B C D E F G H K M Agency Number Agency Name Cardholder Last | Cardholder First | Description Amount Vendor Transaction Date Posted Date Merchant Category Code (MCC) 1000 OKLAHOMA ST/Mason C GENERAL PUR 890 NACAS 7/30/2013 0:00 7/31/2013 0:00 CHARITABLE AND SOCIAL SERVICE ORGANIZATIONS W N 1000 OKLAHOMA ST/Mason ROOM CHARGE 368.96 SHERATON HOT 7/30/2013 0:00 7/31/2013 0:00 SHERATON 1000 OKLAHOMA ST/Massey GENERAL PUR 165.82 SEARS.COM 93 7/29/2013 0:00 7/31/2013 0:00 DIRCT MARKETING/DIRCT MARKETERS--NOT ELSEWHERE CLASS 1000 OKLAHOMA ST/Massey GENERAL PUR 96.39 WAL-MART #013 7/30/2013 0:00 7/31/2013 0:00 GROCERY STORES,AND SUPERMARKETS 1000 OKLAHOMA ST/ Mauro-Herrera M HAMMERMILL C 125.96 STAPLES DIRE( 7/30/2013 0:00 7/31/2013 0:00 STATIONERY, OFFICE SUPPLIES, PRINTING AND WRITING PAPER 1000 OKLAHOMA ST/Mauro-Herrera M GENERAL PUR 394.28 KYOCERA DOCI 7/29/2013 0:00 7/31/2013 0:00 OFFICE, PHOTOGRAPHIC, PHOTOCOPY, AND MICROFILM EQUIPN 1000 OKLAHOMA ST/ Mays B GENERAL PUR 19.87 WAL-MART #013 7/30/2013 0:00 7/31/2013 0:00 GROCERY STORES,AND SUPERMARKETS 1000 OKLAHOMA ST/Mays B GENERAL PUR 10.1 DAYLIGHT DONI 7/29/2013 0:00 7/31/2013 0:00 FAST FOOD RESTAURANTS 10 1000 OKLAHOMA ST/Mccarthy GENERAL PUR 142.6 UFIRST LAUNDI 7/30/2013 0:00 7/31/2013 0:00 MENS, WOMENS AND CHILDRENS UNIFORMS AND COMMERCIAL 11 1000 OKLAHOMA ST/McClurg L AT&T SERVICE 29.99 AT&T DATA 7/30/2013 0:00 7/31/2013 0:00 TELECOMMUNICATION SERVICES 12 1000 OKLAHOMA ST/ McGowin R GENERAL PUR 278.23 RANDY'S FOOD 7/29/2013 0:00 7/31/2013 0:00 FREEZER AND LOCKER MEAT PROVISIONERS 13 1000 OKLAHOMA ST/Mckee P GENERAL PUR 127.8 DEARINGER PR 7/30/2013 0:00 7/31/2013 0:00 MISCELLANEOUS AND SPECIALTY RETAIL STORES 14 1000 OKLAHOMA ST/Mclemore A GENERAL PUR 572.27 GIDDINGS MACI 7/30/2013 0:00 7/31/2013 0:00 COMMERCIAL EQUIPMENT, NOT ELSEWHERE CLASSIFIED 15 1000 OKLAHOMA ST/McMurry S 50-LB PLAY SAN 12.9 LOWES #00241 7/30/2013 0:00 7/31/2013 0:00 HOME SUPPLY WAREHOUSE STORES 16 1000 OKLAHOMA ST/ Meints K GENERAL PUR 445 OK DEPT OF VC 7/30/2013 0:00 7/31/2013 0:00 GOVERNMENT SERVICES-NOT ELSEWHERE CLASSIFIED 17 1000 OKLAHOMA ST/ Mohiuddin A GENERAL PUR 452.91 TFS THERMOAS 7/31/2013 0:00 7/31/2013 0:00 DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP AND S 18 1000 OKLAHOMA ST/ Mohiuddin GENERAL PUR 2425 WESTERN EQU 7/29/2013 0:00 7/31/2013 0:00 HARDWARE STORES 19 1000 OKLAHOMA ST/Mohiuddin GENERAL PURC 2425 WESTERN EQU 7/29/2013 0:00 7/31/2013 0:00 HARDWARE STORES 20 1000 OKLAHOMA ST/Mollenhauer R GENERAL PUR 7.63 HOBBY-LOBBY 7/29/2013 0:00 7/31/2013 0:00 HOBBY,TOY,AND GAME STORES 21 1000 OKLAHOMA STAMONTGOMERY R GENERAL PUR 18.97 WAL-MART #012 7/30/2013 0:00 7/31/2013 0:00 GROCERY STORES,AND SUPERMARKETS 22 1000 OKLAHOMA ST/Morales D ROOM CHARGE 729.8 WESTIN DENVE 7/29/2013 0:00 7/31/2013 0:00 WESTIN HOTELS 23 1000 OKLAHOMA ST/Morales D ROOM CHARGE 729.8 WESTIN DENVE 7/29/2013 0:00 7/31/2013 0:00 WESTIN HOTELS 24 1000 OKLAHOMA ST/Fokar M GENERAL PUR 368 BIO RAD 7/26/2013 0:00 7/29/2013 0:00 DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP AND S 25 1000 OKLAHOMA ST/Forquer G GENERAL PUR 9.16 LOCKE SUPPLY 7/26/2013 0:00 7/29/2013 0:00 HARDWARE STORES ACT557_File_PCard_Transactions_ + + 100% 9:46 PM TH 11/22/2020ACT557FilePCardTransactionsFY2015csv [Protected View] - Excel A kaylajcurtiss@gmail.com X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X A16 X v fx 1000 A B C D E F G H K M Agency Number Agency Name Cardholder Last | Cardholder First | Description Amount Vendor Transaction Date Posted Date Merchant Category Code (MCC) N 1000 OKLAHOMA ST/ Clark K GENERAL PUR( $88.88 Discount School 7/23/2014 0:00 7/24/2014 0:00 STATIONERY, OFFICE AND SCHOOL SUPPLY STORES 1000 OKLAHOMA ST/Clark M GENERAL PUR( $425.00 BROONER'S FL( 7/23/2014 0:00 7/24/2014 0:00 FLOOR COVERING,RUG AND CARPET STORES 1000 OKLAHOMA ST/ Clark M NEWS ADV./SU $141.50 820 NEWS PRE: 7/23/2014 0:00 7/24/2014 0:00 CONTINUITY/SUBSCRIPTION MERCHANTS 1000 OKLAHOMA ST/ Clark M GENERAL PUR( $2,679.99 WWW.NEWEGO 7/23/2014 0:00 7/24/2014 0:00 ELECTRONICS STORES 1000 OKLAHOMA ST/ Clark P BH 3-INX7-IN SM $22.44 LOWES #00241 7/22/2014 0:00 7/24/2014 0:00 HOME SUPPLY WAREHOUSE STORES 1000 OKLAHOMA ST/Cobb GENERAL PURC $66.06 WALMART.COM 7/23/2014 0:00 7/24/2014 0:00 DISCOUNT STORES 1000 OKLAHOMA ST/ Coburn L IND POWDER-FI $122.26 ULINE SHIP SU 7/24/2014 0:00 7/24/2014 0:00 CATALOG MERCHANTS 1000 OKLAHOMA ST/ Collins M GENERAL PUR( $423.60 OOShirts 7/22/2014 0:00 7/24/2014 0:00 MISCELLANEOUS AND SPECIALTY RETAIL STORES 10 1000 OKLAHOMA ST/ Compton GENERAL PUR( $375.00 LYNDA.COM 7/23/2014 0:00 7/24/2014 0:00 SCHOOLS AND EDUCATIONAL SERVICES NOT ELSEWHERE CLA 11 1000 OKLAHOMA ST/ Conaghan CCO IPAD AIR ULTRA $97.97 BEST BUY 01 7/23/2014 0:00 7/24/2014 0:00 ELECTRONICS STORES 12 1000 OKLAHOMA ST/ Conner GENERAL PUR( $182.56 PASTERNACK E 7/22/2014 0:00 7/24/2014 0:00 ELECTRICAL PARTS AND EQUIPMENT 13 1000 OKLAHOMA ST/ Cruz-Rodz A GENERAL PUR( $10.99 PETSMART INC 7/23/2014 0:00 7/24/2014 0:00 PET SHOPS,PET FOOD AND SUPPLIES 14 1000 OKLAHOMA STACryer R MRTHN 2CT 10-1 $31.07 LOWES #01724 7/23/2014 0:00 7/24/2014 0:00 HOME SUPPLY WAREHOUSE STORES 15 1000 OKLAHOMA ST/ Dean V GENERAL PUR( $170.00 OK DEPT OF VO 7/23/2014 0:00 7/24/2014 0:00 GOVERNMENT SERVICES-NOT ELSEWHERE CLASSIFIED 16 1000OKLAHOMA ST/DeBow GENERAL PURC $444.96 NASCO MAIL OF 7/23/2014 0:00 7/24/2014 0:00 STATIONERY, OFFICE AND SCHOOL SUPPLY STORES 17 1000 OKLAHOMA ST/ Dillwith HOT START TAG $131.62 VWR INTERNAT 7/24/2014 0:00 7/24/2014 0:00 DENTAL/LABORATORY/MEDICAL/OPHTHALMIC HOSP EQIP AND S 18 1000 OKLAHOMA ST/Ducote CCCCO PLUG PACK - 30$18.98 AUTOZONE #05: 7/23/2014 0:00 7/24/2014 0:00 AUTOMOTIVE PARTS AND ACCESSORIES STORES 19 1000 OKLAHOMA ST/Ducote GENERAL PUR( $262.29 TMS PHILLIPS T 7/22/2014 0:00 7/24/2014 0:00 AUTOMOTIVE TOP AND BODY SHOPS 20 1000 OKLAHOMA STA DUNCAN GENERAL PUR( $739.82 GAYLORD BRO$ 7/23/2014 0:00 7/24/2014 0:00 CATALOG MERCHANTS 21 1000 OKLAHOMA ST/ Dyer C Individual Test Ki $163.88 AMAZON MKTPL 7/23/2014 0:00 7/24/2014 0:00 BOOK STORES 22 1000 OKLAHOMA ST/ Edwards W GENERAL PUR( $223.52 WAL-MART #013 7/23/2014 0:00 7/24/2014 0:00 GROCERY STORES,AND SUPERMARKETS 23 1000 OKLAHOMA ST/ Ephgrave GENERAL PUR( $2.75 VZWRLSS MY V 7/23/2014 0:00 7/24/2014 0:00 TELECOMMUNICATION SERVICES 4 + 24 1000 OKLAHOMA ST/ Ephgrave GENERAL PUR( $249.99 VZWRLSS S P1 7/23/2014 0:00 7/24/2014 0:00 TELECOMMUNICATION EQUIPMENT AND TELEPHONE SALES 25 1000 OKLAHOMA ST/Ephgrave GENERAL PUR( $818.67 VZWRLSS MY V 7/23/2014 0:00 7/24/2014 0:00 TELECOMMUNICATION SERVICES ACT557_File_PCard_Transactions_ + Ready + 100% 9:46 PM m 11/22/2020
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
