Scribd
Upload
127 views5 pages

04 Data Transform

The document contains records of service requests including the date, vehicle details, service performed, and price. It shows that a total of $1,770 was charged across various services including oil/filter changes priced at $30-$95, tires for $200, brakes at $150, and AC repair at $75. The records are for requests made between January 2014 and September 2014 and include brands such as Honda, Toyota, Ford, Chevy and more.

Uploaded by

jerome ramos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
127 views5 pages

04 Data Transform

The document contains records of service requests including the date, vehicle details, service performed, and price. It shows that a total of $1,770 was charged across various services including oil/filter changes priced at $30-$95, tires for $200, brakes at $150, and AC repair at $75. The records are for requests made between January 2014 and September 2014 and include brands such as Honda, Toyota, Ford, Chevy and more.

Uploaded by

jerome ramos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Weekday Sum - Price

Sunday $ 55.00
Monday $ 55.00
Thursday $ 95.00
Friday $ 30.00
Saturday $ 1,185.00
01/20/14 09:11 AM $ 30.00
01/20/14 09:16 AM $ 30.00
01/20/14 10:06 AM $ 30.00
01/20/14 10:41 AM $ 95.00
01/21/14 09:13 AM $ 30.00
01/23/14 09:40 AM $ 75.00
01/30/14 04:44 PM $ 30.00
09/24/14 03:54 PM $ 30.00
(empty)
Total Result $ 1,770.00
Work Order # Requested On Weekday LIC PLATE Make Model
9980927 06/13/14 11:26 AM Friday AB12AC CHEVY CRUZE
9992953 01/02/14 09:40 AM Saturday 34BV23 TOYOTA 4 RUNNER
9992944 01/02/14 07:53 AM Saturday 56BBCA FORD F150
9992945 01/02/14 08:00 AM Saturday 776YTH FORD FUSION
9992946 01/02/14 08:02 AM Saturday 89KK6Y HYUNDAI SONATA
9992947 01/02/14 08:06 AM Saturday 776NHJ HONDA CR-V
9992949 01/02/14 08:29 AM Saturday 899HY4 HONDA ACCORD
9992950 01/02/14 08:31 AM Saturday 87JN33 TOYOTA TUNDRA
9992951 01/02/14 08:32 AM Saturday 89KK6Y HYUNDAI SONATA
9992952 01/02/14 08:34 AM Saturday 23RF65 NISSAN SENTRA
9992954 01/02/14 09:59 AM Saturday 899HY4 HONDA ACCORD
9992956 01/02/14 10:29 AM Saturday 56BBCA FORD F150
9992957 01/02/14 10:38 AM Saturday 887NHA CHEVY SPARK
9993017 01/05/14 07:08 AM Thursday 12RU76 NISSAN ROGUE
9993018 01/06/14 07:28 AM Sunday 23RF65 NISSAN SENTRA
9992948 01/02/14 08:28 AM Saturday 899HY4 HONDA ACCORD
9993019 01/06/14 07:29 AM Sunday 56BBCA FORD F150
9993504 01/20/14 09:11 AM 01/20/14 09:11 AM 12RU76 NISSAN ROGUE
#N/A #N/A
#N/A #N/A
9994620 01/20/14 10:06 AM 01/20/14 10:06 AM 887NHA CHEVY SPARK
9994621 01/20/14 10:41 AM 01/20/14 10:41 AM 90YT64 DODGE DART
9994801 01/21/14 09:13 AM 01/21/14 09:13 AM 34BV23 TOYOTA 4 RUNNER
9994802 01/20/14 09:16 AM 01/20/14 09:16 AM 22ETY8 VW PASSAT
9994809 01/23/14 09:40 AM 01/23/14 09:40 AM 43VB66 FIAT 500
10009194 09/24/14 03:54 PM 09/24/14 03:54 PM 23RF65 NISSAN SENTRA
10009195 01/30/14 04:44 PM 01/30/14 04:44 PM 34BV23 TOYOTA 4 RUNNER
10009196 02/06/14 04:51 PM Monday 23RF65 NISSAN SENTRA
10009197 07/07/14 04:59 PM Monday 89KK6Y HYUNDAI SONATA
SERVICE Price MERCH
OIL/FILTER $ 30.00 BL
OIL/FILTER $ 30.00 AL
TIRES $ 200.00 99
BRAKES $ 150.00 TV
OIL/FILTER $ 30.00 BL
AC $ 75.00 BL
OIL/FILTER $ 30.00 RB
BRAKES $ 150.00 AL
OIL/FILTER $ 30.00 RB
TIRES $ 200.00 99
OIL/FILTER $ 30.00 RB
TIRES $ 200.00 AL
OIL/FILTER $ 30.00 TV
TRANSMISSION $ 95.00 99
OIL/FILTER $ 30.00 BL
OIL/FILTER $ 30.00 TV
HEADLAMPS $ 25.00 99
OIL/FILTER $ 30.00 BL

OIL/FILTER $ 30.00 RB
TRANSMISSION $ 95.00 99
OIL/FILTER $ 30.00 AL
OIL/FILTER $ 30.00 TV
AC $ 75.00 RB
OIL/FILTER $ 30.00 BL
OIL/FILTER $ 30.00 TV
HEADLAMPS $ 25.00 AL
OIL/FILTER $ 30.00 BL
LICENCE PLATE MAKE MODEL
AB12AC CHEVY CRUZE
34BV23 TOYOTA 4 RUNNER
56BBCA FORD F150
776YTH FORD FUSION
89KK6Y HYUNDAI SONATA
776NHJ HONDA CR-V
899HY4 HONDA ACCORD
87JN33 TOYOTA TUNDRA
23RF65 NISSAN SENTRA
887NHA CHEVY SPARK
12RU76 NISSAN ROGUE
90YT64 DODGE DART
22ETY8 VW PASSAT
43VB66 FIAT 500
SERVICE PRICE
OIL/FILTER $ 30.00
TIRES $ 200.00
BRAKES $ 150.00
AC $ 75.00
TRANSMISSION $ 95.00
HEADLAMPS $ 25.00

You might also like