I need someone who can extract my data from excel and put in PowerPoint as soon as possible. I have a PowerPoint template that needs to be used. I need the chart to be extract from my excel spreadsheet and put on PP and the data below as well. Please see attached. I will give an extra $ if the work is done today
> Spend Graph
-NOV1 )
Travel Spend (APR -NOV19) Travel + 8
,97 87,1 0, 8
0,7 ,5 0,385
1, 3
1,7 9,063
4
1,659
,050
6
0,039
2
,091
,952
,008
6,6 ,477
,714
1
5,230
,601
6
,375
1
1
,982
1
Travel & P2W Expenses (April 2018-November2019)
587972.76999999979 487116.16999999969 520638.35000000021 480757.56999999948 394350.19 385516.54000000004 450385.07000000018 371762.63 311712.96000000002 392722.1300000003 380070.58999999968 429063.30999999994 520387.19000000018 531794 561659 512050 605982 528962 635491 481646 Travel Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 43635 43665 43696 43727 43757 43788
88 .859999999986 63816.539999999994 56774.020000000011 92475.599999999977 31617.780000000013 43248.819999999985 55602.639999999985 88320.160000000033 58191.73000000001 134345.77000000025 163501.95999999996 85523.370000000024 146314.63999999993 119047 162262 126694 84713 72146 73814 57176 P2W Apr -18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 43635 43665 43696 43727 43757 43788
676457.62999999977 550932.70999999973 577412.37000000023 573233.16999999946 425967.97000000003 428765.36000000004 505987.7100000002 460082.79000000004 369904.69000000006 527067.90000000061 543572.54999999958 514586.67999999993 666701.83000000007 650840.58000000007 723920.73999999987 638743.65999999992 690695.30999999994 601108.41 709305.30999999994 538821.61 Total Travel + P2W Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 43635 43665 43696 43727 43757 43788 Travel & P2W Expenses (April 2018-November2019)
Travel
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 43635 43665 43696 43727 43757 43788 587972.76999999979 487116.16999999969 520638.35000000021 480757.56999999948 394350.19 385516.54000000004 450385.07000000018 371762.63 311712.96000000002 392722.1300000003 380070.58999999968 429063.30999999994 520387.19000000018 531794 561659 512050 605982 528962 635491 481646 P2W
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 43635 43665 43696 43727 43757 43788 88484.859999999986 63816.539999999994 56774.020000000011 92475.599999999977 31617.780000000013 43248.819999999985 55602.639999999985 88320.160000000033 58191.73000000001 134345.77000000025 163501.95999999996 85523.370000000024 146314.63999999993 119047 162262 126694 84713 72146 73814 57176 Total Travel + P2W
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 43635 43665 43696 43727 43757 43788 676457.62999999977 550932.70999999973 577412.37000000023 573233.16999999946 425967.97000000003 428765.36000000004 505987.7100000002 460082.79000000004 369904.69000000006 527067.90000000061 543572.54999999958 514586.67999999993 666701.83000000007 650840.58000000007 723920.73999999987 638743.65999999992 690695.30999999994 601108.41 709305.30999999994 538821.61 54 56 41 12 66 32 44 36 37 27 31 17 20 51 85 43 32 41 50 14 SUMMARY POLICY VIOLATIONS Policy Violation Reasons # of Tickets Missed Savings 58 Flight Time Declined 22 42 Routing Declined – Stops/Connections 16 25 Declined for Preferred Carrier 10 10 Declined Alternate Carrier (Personal Preference) 3 2 Alternate Airport Declined 1 1 Total 52 1 Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance
Jun-19 Jul-19 Aug-19 Sep-19 Total Traveler Name Sep-19 19-Oct 19-Nov Total 2 2 4 2 6 4 1 21 REMBISH/MICHAEL JAMES 10 4 1 15 1 2 4 4 4 4 1 20 5 7 2 14 1 3 4 5 4 1 18 ST CLAIR/COLIN MR 5 4 2 11 5 4 4 13 ZETTLEMOYER/ADRIAN F 4 5 9 1 3 1 4 1 1 11 2 2 2 6 3 3 6 3 3 2 1 1 10 2 3 1 6 1 1 2 2 1 1 8 4 4 40 45 45 58 37 48 43 32 31 41 40 TOP 10 TRAVELERS BY OVERALL SPENDING St Clair, Colin $ 8,923 $ 15,422 $ 12,654 $ 9,839 $ 11,848 $ 4,186 $ – Cates, Brian L $ 7,368 $ 6,758 $ 7,330 Madgey, Christopher Michael $ 3,561 $ 11,780 $ 3,645 Cloninger, David Andrew $ 4,277 $ 10,295 $ 3,858 Scott, Bradley C $ 7,349 $ 6,797 $ 3,107 Total $ 528,962 $ 635,491 $ 481,646 Travel is Substantially Up 1 Travel & P2W Expenses (April 2018-Aug2019)
Travel
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 587972.76999999979 487116.16999999969 520638.35000000021 480757.56999999948 394350.19 385516.54000000004 450385.07000000018 371762.63 311712.96000000002 392722.1300000003 380070.58999999968 429063.30999999994 520387.19000000018 533706 551748 504864 563866 P2W
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 88484.859999999986 63816.539999999994 56774.020000000011 92475.599999999977 31617.780000000013 43248.819999999985 55602.639999999985 88320.160000000033 58191.73000000001 134345.77000000025 163501.95999999996 85523.370000000024 146314.63999999993 119047 162106 126133 73933 Total Travel + P2W
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 676457. 62999999977 550932.70999999973 577412.37000000023 573233.16999999946 425967.97000000003 428765.36000000004 505987.7100000002 460082.79000000004 369904.69000000006 527067.90000000061 543572.54999999958 514586.67999999993 666701.83000000007 652753 713854 630997 637799 Travel Reports Top 10 Travelers – May to Aug 2 Spend CategoryApr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Total
2
Travel
Travel Spend (APR
1
8
9
Created by E.Badjeck on 01/08/
20
18
Created by E.Badjeck on 01/08/20
Spend Category
Apr-18
May-18
Jun-18
Jul-18
Aug-18
Sep-18
Oct-18
Nov-18
Dec-18
Jan-19
Feb-19
Mar-19
Apr-19
May-19
Jun-19
Jul-19
Aug-19
Sep-19
Oct-19
Nov-19
Total
P2W
Travel
5
7
3
4
1
6
52
63
48
58
394,3
50
3
85
17
45
37
76
31
13
392,7
22
380,071
42
520,387
531,
79
56
5
12
605,982
528,962
635,491
481,
64
9,
57
Air
201,
10
1
27
1
43
128,308
72,938
101,396
109,207
79,637
51
94,393
84,634
100,643
134,242
15
14
1
66
130,789
1
21
133,396
152,620
104,939
2,395,102
Hotel
198,6
41
138,
44
16
148,860
149,389
126,9
74
146,746
1
32
100,308
135,
36
1
40
145,
54
213,104
180,
25
198,365
186,810
268,531
201,084
2
55
199,588
3,432,187
Meals
102,
11
120,534
117,178
115,513
89,060
88,204
109,592
84,548
97,736
99,944
87,894
107,223
98,211
100,511
110,065
108,600
119,867
113,116
138,833
102,144
2,110,883
Car Rental
28,925
21,355
28,060
26,097
22,961
16,909
21,225
19,335
14,868
12,667
14,996
18,271
14,324
21,334
15,768
21,028
22,149
18,903
19,750
17,529
396,455
Cabs/Tolls/Parking/Fuel
50,854
72,780
60,765
57,006
54,667
47,288
59,769
50,254
44,157
44,545
47,673
53,532
53,369
66,929
65,302
60,549
66,435
55,793
61,194
53,662
1,126,523
All Other Travel
6,340
6,916
5,454
4,974
5,335
4,745
3,844
5,389
3,635
5,807
4,498
3,852
7,137
6,154
5,682
4,272
7,286
6,670
7,114
3,783
108,888
P2W
88,485
63,817
56,774
92,476
31,618
43,249
55,603
88,320
58,192
134,346
163,502
85,523
146,315
119,047
162,262
126,694
84,713
72,146
73,814
57,176
1,804,070
Total Travel + P2W
676,458
550,933
577,412
573,233
425,968
428,765
505,988
460,083
369,905
527,068
543,573
514,587
666,702
650,841
723,921
638,744
690,695
601,108
709,305
538,822
11,374,109
Notes:
Travel spend includes all traveler types.
Nov numbers will not be final until all travel expenses transacted in Nov have been processed in the Concur Expense system.
Travel Spend Categories include the following expense types from Concur:
Air: Airfare, Airline Fees, Baggage Fees
Hotel: Hotel and Hotel Tax
Meals: Breakfast, Lunch, Dinner, Travel Meals, Apt Association Meals/Outings
Car Rental: Car Rental
Cabs/Tolls/Parking/Fuel: Car Rental, Parking, Tolls/Road Charges, Taxi, Fuel, Public Transport, Personal Car Mileage, Cabs/Tolls/Parking/Other Travel Exp
All Other Travel: Internet/Online Fees, Service Fee – Travel, Train, Travel Wifi, Tips/Gratuities
484
Not Using Concur Travel
Name
# Transactions
Total Expensed
St Clair, Colin
$ 24,947
Cheung, Brian
$ 17,934
Madgey, Christopher
$ 15,326
Rammer, Chantel
$ 13,394
Thomas, Jace
$ 13,241
Scott, Bradley
$ 12,675
Clark Jr, Bobby
$ 12,097
Fleming, Rhett
$ 11,279
Kessler, Jason
$ 10,135
Stockwell, Christian
$ 9,826
Wooley Jr, Joe
$ 9,618
White, Ryan
$ 9,518
Visser, Elizabeth
$ 9,083
Cloninger, David
$ 8,985
Larson, Brian
$ 8,360
Ballard, Richard
$ 8,240
Gilbert, Matthew
$ 7,887
Catanzaro, Michael
$ 7,748
Rembish, Michael
$ 7,673
Wehner, Chad
$ 7,345
All Others (445)
4,048
$ 766,276
Total
4,837
$ 991,590
Summary Policy Violations
SUMMARY POLICY VIOLATIONS
MAY – DEC 2019
SEP – NOV 2019
Policy Violation Reasons
# of Tickets
Missed Savings
Flight Time Declined
$ 18,074
$ 6,610
Routing Declined – Stops/Connections
$ 13,423
$ 4,703
Declined for Preferred Carrier
$ 6,734
$ 3,006
Declined Alternate Carrier (Personal Preference)
$ 3,040
$ 807
Alternate Airport Declined
$ 577
$ 333
Equipment Declined-commuter flights
$ 287
$ 15,459
Declined Preferred Carrier
$ 219
Total
139
$ 42,354
Summary Boookings < 7 Days
Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance
Traveler Name
19-May
19-Oct
19-Nov
19-Dec
REMBISH/MICHAEL JAMES
MAEDER/MICHAEL CHARLES MR
GONZALEZ/MARCO ANTONIO MR
ST CLAIR/COLIN MR
GONZALEZ/MARCO ANTONIO MR 1 1 1 2 4 6 1 16 MAEDER/MICHAEL CHARLES MR 4 5 9
ZETTLEMOYER/ADRIAN F
MYERS/RHONDA LEE MRS
HARPER SR/SEAN ALEXUS MR
HARPER SR/SEAN ALEXUS MR 2 2 1 3 2 10
MOORE/KIMBERLY JEAN
SACHLEBEN/PATRICK CHRISTIAN MR
THOMAS/JACE M
THOMAS/JACE M 3 3 2 1 9 MYERS/RHONDA LEE MRS 4 1 5
GILBERT/MATTHEW SCOTT
CATANZARO/MICHAEL D
All Others (143)
348
All Others (65)
112
Total 48 56 64 76 63 79 55 43 484 Total 66 74 57
197
Top 10 Traveler Expense
TOP 10 TRAVELERS BY OVERALL SPENDING
19-May Jun-19 Jul-19 Aug-19 Sep-19 19-Oct 19-Nov 19-Dec Total Sep-19 19-Oct 19-Nov Total
Cates, Brian L
$ 9,456
$ 8,526
$ 8,257
$ 7,262
$ 7,368
$ 6,758
$ 7,330
$ 4,801
$ 59,758
$ 8,923
$ 15,422
$ 12,654
$ 36,999
St Clair, Colin
$ –
$ 8,211
$ 55
$ 7,653
$ 2,512
$ 55,430
Rembish, Michael James
$ 9,839
$ 11,848
$ 4,186
$ 25,874
Rembish, Michael James
$ 6,022
$ 8,237
$ 5,409
$ 9,873
$ 55,415
$ 21,456
Madgey, Christopher Michael
$ 6,382
$ 6,839
$ 3,466
$ 10,302
$ 3,561
$ 11,780
$ 3,645
$ 1,480
$ 47,453
Cheung, Brian D
$ 2,901
$ 6,292
$ 10,762
$ 19,956
Fleming, Rhett S
$ 5,156
$ 4,725
$ 5,293
$ 5,102
$ 5,816
$ 4,567
$ 4,469
$ 5,139
$ 40,267
$ 18,986
Cloninger, David Andrew
$ 7,594
$ 4,213
$ 1,026
$ 4,481
$ 4,277
$ 10,295
$ 3,858
$ 3,992
$ 39,735
$ 18,429
Scott, Bradley C
$ 6,229
$ 3,655
$ 3,979
$ 4,785
$ 7,349
$ 6,797
$ 3,107
$ 3,709
$ 39,609
$ 17,253
Visser, Elizabeth Sokoly
$ 5,931
$ 5,958
$ 8,242
$ 4,899
$ 820
$ 2,752
$ 7,900
$ 894
$ 37,395
Clark Jr, Bobby Joe
$ 5,591
$ 9,766
$ 1,431
$ 16,788
Stockwell, Christian H
$ 4,015
$ 3,255
$ 1,085
$ 8,039
$ 5,194
$ 6,147
$ 3,108
$ 5,074
$ 35,917
Thomas, Jace M
$ 6,923
$ 5,723
$ 3,658
$ 16,304
Kessler, Jason Daniel
$ 5,440
$ 6,077
$ 3,943
$ 3,589
$ 5,623
$ 6,375
$ 1,896
$ 694
$ 33,635
Horan, Peter William
$ 7,173
$ 4,304
$ 3,514
$ 14,992
All Other Travelers (885)
$ 475,570
$ 501,964
$ 471,296
$ 539,998
$ 470,192
$ 552,752
$ 429,493
$ 253,197
$ 3,694,461
All Other Travelers (705)
$ 465,056
$ 546,508
$ 427,500
$ 1,439,063
Total
$ 531,794
$ 561,659
$ 512,050
$ 605,982
$ 528,962
$ 635,491
$ 481,646
$ 281,491
$ 4,139,075
$ 1,646,099
Dec 2019 transactions have not been submitted in their entirety
Top 10 Travelers – Sep to Nov
Outside Policy Air Travel Sep – Nov
Outside Policy Air Travel May – Aug
Top 20 Travelers not Booking with Concur Travel Sep – Nov
Need to:
Use Concur
Travel less
Comply with travel policy
Pick low rates of stay
Travel587,973487,116520,638480,758394,350385,517450,385371,763311,713392,722380,071429,063520,387533,706551,748504,864563,8667,866,639
Air201,102127,091143,952128,30872,938101,396109,20779,63751,00894,39384,634100,643134,242156,106164,597128,603115,2191,993,077
Hotel198,641138,441165,230148,860149,389126,974146,746132,601100,308135,366140,375145,541213,104178,883197,638185,696252,0482,755,842
Meals102,111120,534117,178115,51389,06088,204109,59284,54897,73699,94487,894107,22398,211114,971113,476117,087117,3011,780,582
Car Rental28,92521,35528,06026,09722,96116,90921,22519,33514,86812,66714,99618,27114,32421,33415,76820,12821,376338,600
Cabs/Tolls/Parking/Fuel50,85472,78060,76557,00654,66747,28859,76950,25444,15744,54547,67353,53253,36956,26154,58949,12151,614908,244
All Other Travel6,3406,9165,4544,9745,3354,7453,8445,3893,6355,8074,4983,8527,1376,1515,6804,2296,30890,295
P2W88,48563,81756,77492,47631,61843,24955,60388,32058,192134,346163,50285,523146,315119,047162,106126,13373,9331,589,437
Total Travel + P2W676,458550,933577,412573,233425,968428,765505,988460,083369,905527,068543,573514,587666,702652,753713,854630,997637,7999,456,076
NameMay-19Jun-19Jul-19Aug-19Grand Total
Cates, Brian L$9,456$8,526$8,257$7,262$33,500
Rembish, Michael James$6,022$8,237$5,409$9,873$29,541
Madgey, Christopher Michael$6,382$6,839$3,466$8,785$25,471
Visser, Elizabeth Sokoly$5,931$5,958$8,242$4,899$25,029
Gomez, Jesus$1,009$6,889$6,519$8,350$22,768
Rasmussen, Eric T$3,602$3,371$4,552$10,548$22,073
Fleming, Rhett S$5,156$4,725$5,293$5,102$20,275
Martella Jr, Richard Vincent$7,655$4,858$4,995$2,579$20,087
Kessler, Jason Daniel$5,440$6,077$3,943$3,589$19,048
Scott, Bradley C$6,229$3,655$3,979$4,437$18,300
All Other Travelers (761)$472,812$498,913$450,018$505,972$1,927,715
Grand Total$529,693$558,046$504,672$571,395$2,163,807
Traveler NameMayJunJulAugTotal
MAEDER/MICHAEL CHARLES MR1 2 4 4 11
SACHLEBEN/PATRICK CHRISTIAN MR3 2 2 1 8
CHUI/COLIN3 3 1 – 7
ST CLAIR/COLIN MR- 1 3 3 7
REMBISH/MICHAEL JAMES2 1 3 – 6
ROSADO/GILBERTO R MR2 1 3 – 6
OLIVENCIA SANCHEZ/MONICA2 – 3 – 5
WILLIAMSON/JACK W MR1 2 2 – 5
WOODS/JARVIS CORDELL MR- 1 3 1 5
CLONINGER/DAVID ANDREW- – – 4 4
ALL OTHERS (80)20 32 30 45 127
Grand Total34 45 54 58 191
Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance
Policy Violation Reasons# of TicketsMissed Savings
Flight Time Declined36$11,464
Routing Declined - Stops/Connections26$8,720
Declined for Preferred Carrier15$3,728
Declined Alternate Carrier7$2,233
Alternate Airport Declined1$244
Grand Total85$26,390
We provide professional writing services to help you score straight A’s by submitting custom written assignments that mirror your guidelines.
Get result-oriented writing and never worry about grades anymore. We follow the highest quality standards to make sure that you get perfect assignments.
Our writers have experience in dealing with papers of every educational level. You can surely rely on the expertise of our qualified professionals.
Your deadline is our threshold for success and we take it very seriously. We make sure you receive your papers before your predefined time.
Someone from our customer support team is always here to respond to your questions. So, hit us up if you have got any ambiguity or concern.
Sit back and relax while we help you out with writing your papers. We have an ultimate policy for keeping your personal and order-related details a secret.
We assure you that your document will be thoroughly checked for plagiarism and grammatical errors as we use highly authentic and licit sources.
Still reluctant about placing an order? Our 100% Moneyback Guarantee backs you up on rare occasions where you aren’t satisfied with the writing.
You don’t have to wait for an update for hours; you can track the progress of your order any time you want. We share the status after each step.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
Although you can leverage our expertise for any writing task, we have a knack for creating flawless papers for the following document types.
From brainstorming your paper's outline to perfecting its grammar, we perform every step carefully to make your paper worthy of A grade.
Hire your preferred writer anytime. Simply specify if you want your preferred expert to write your paper and we’ll make that happen.
Get an elaborate and authentic grammar check report with your work to have the grammar goodness sealed in your document.
You can purchase this feature if you want our writers to sum up your paper in the form of a concise and well-articulated summary.
You don’t have to worry about plagiarism anymore. Get a plagiarism report to certify the uniqueness of your work.
Join us for the best experience while seeking writing assistance in your college life. A good grade is all you need to boost up your academic excellence and we are all about it.
We create perfect papers according to the guidelines.
We seamlessly edit out errors from your papers.
We thoroughly read your final draft to identify errors.
Work with ultimate peace of mind because we ensure that your academic work is our responsibility and your grades are a top concern for us!
Dedication. Quality. Commitment. Punctuality
Here is what we have achieved so far. These numbers are evidence that we go the extra mile to make your college journey successful.
We have the most intuitive and minimalistic process so that you can easily place an order. Just follow a few steps to unlock success.
We understand your guidelines first before delivering any writing service. You can discuss your writing needs and we will have them evaluated by our dedicated team.
We write your papers in a standardized way. We complete your work in such a way that it turns out to be a perfect description of your guidelines.
We promise you excellent grades and academic excellence that you always longed for. Our writers stay in touch with you via email.