Transform the data in accordance with the AICPA Base Standard, except as noted:

-For this transformation, you should import all of the data from each of the six files into a single repository. That means, regardless of the agency to which the data pertains, you should combine it into a single file.

-Because of this stipulation, the quantity of data is more than Excel can handle in a single sheet (i.e., there will be more than 1,048,576 lines of data). Thus, you should use Microsoft Access to database that lists all data in a single table.

As you prepare Microsoft Access database, here are some important tips to keep in mind:

-Although the AICPA data standards suggest pipe-delimited files (that is, files that use a vertical line delimiter instead of a comma or other delimiter), use a comma-delimited or .csv file for all parts of this case.

-You should only use a single table for the data import.

-For the TransactionDate and PostedDate, use the format MM/DD/YYYY to make importing into Access easier. For example, May 4, 2002, would be formatted as 05/04/2002 (it is OK if the zeros preceding the month and date do not show up in Access).

-Not all fields are labeled as discussed in Task 2. Relabel data in all files using the labels that described the information in Task 2, but remove the spaces between the words (e.g., Agency Number should be AgencyNumber). Perform this step in Excel before importing the information into Access.

-Data might look different from year to year. You need to make it consistent across time.

-If data is missing for a particular field, leave it blank in your database.

When you finish the transformation, answer the following questions:

-How many rows of data are contained in your final file?

-What is the total of the amount column?

Upload a copy of your Access file for your professor for grading.

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