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
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 2 |
>
Travel |
Spend Graph
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
| Travel Spend (APR
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 1 |
8 |
-NOV1
|
| 9 |
)
| Created by E.Badjeck on 01/08/
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
|
| 20 |
Travel Spend (APR
18 |
-NOV19)
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 |
Travel +
P2W |
Travel
|
|
|
|
|
|
|
| 5 |
8
7 |
,97
|
|
|
|
|
|
|
|
|
| 3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 4 |
87,1
1
|
|
|
|
| 6 |
| 52 |
0,
63 |
8
|
| 48 |
0,7
58 |
394,3
| 50 |
3
| 85 |
,5
17 |
|
| 45 |
0,385
|
| 37 |
1,
76 |
3
|
| 31 |
1,7
13 |
392,7
| 22 |
380,071 |
| 42 |
9,063
520,387 |
531,
| 79 |
4
|
| 56 |
1,659
5
| 12 |
,050
605,982 |
528,962 |
635,491 |
481,
| 64 |
6
9,
| 57 |
0,039
Air |
201,
|
|
|
|
| 10 |
2
1
| 27 |
,091
1
|
|
| 43 |
,952
128,308 |
72,938 |
101,396 |
109,207 |
79,637 |
| 51 |
,008
94,393 |
84,634 |
100,643 |
134,242 |
| 15 |
6,6
| 14 |
1
|
| 66 |
,477
130,789 |
1
| 21 |
,714
133,396 |
152,620 |
104,939 |
2,395,102 |
Hotel |
198,6
|
|
| 41 |
138,
| 44 |
1
| 16 |
5,230
148,860 |
149,389 |
126,9
| 74 |
146,746 |
1
|
|
| 32 |
,601
100,308 |
135,
| 36 |
6
1
|
| 40 |
,375
145,
| 54 |
1
213,104 |
180,
| 25 |
1
198,365 |
186,810 |
268,531 |
201,084 |
2
| 55 |
,982
199,588 |
3,432,187 |
Meals |
102,
|
| 11 |
1
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 |
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
484 |
.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
Not Using Concur Travel
Name |
# Transactions |
Total Expensed |
|
| St Clair, Colin |
54
$ 24,947 |
Cheung, Brian |
56
$ 17,934 |
Madgey, Christopher |
41
$ 15,326 |
Rammer, Chantel |
12
$ 13,394 |
Thomas, Jace |
66
$ 13,241 |
Scott, Bradley |
32
$ 12,675 |
Clark Jr, Bobby |
44
$ 12,097 |
Fleming, Rhett |
36
$ 11,279 |
Kessler, Jason |
37
$ 10,135 |
Stockwell, Christian |
27
$ 9,826 |
Wooley Jr, Joe |
31
$ 9,618 |
White, Ryan |
17
$ 9,518 |
Visser, Elizabeth |
20
$ 9,083 |
Cloninger, David |
51
$ 8,985 |
Larson, Brian |
85
$ 8,360 |
Ballard, Richard |
43
$ 8,240 |
Gilbert, Matthew |
32
$ 7,887 |
Catanzaro, Michael |
41
$ 7,748 |
Rembish, Michael |
50
$ 7,673 |
Wehner, Chad |
14
$ 7,345 |
All Others (445) |
4,048 |
$ 766,276 |
Total
4,837 |
$ 991,590 |
Summary Policy Violations
| SUMMARY POLICY VIOLATIONS |
SUMMARY POLICY VIOLATIONS
MAY – DEC 2019 |
SEP – NOV 2019 |
| Policy Violation Reasons |
| # of Tickets |
| Missed Savings |
Policy Violation Reasons # of Tickets Missed Savings
| Flight Time Declined |
58
$ 18,074 |
Flight Time Declined 22
$ 6,610 |
| Routing Declined – Stops/Connections |
42
$ 13,423 |
Routing Declined – Stops/Connections 16
$ 4,703 |
| Declined for Preferred Carrier |
25
$ 6,734 |
Declined for Preferred Carrier 10
$ 3,006 |
| Declined Alternate Carrier (Personal Preference) |
10
$ 3,040 |
Declined Alternate Carrier (Personal Preference) 3
$ 807 |
| Alternate Airport Declined |
2
$ 577 |
Alternate Airport Declined 1
$ 333 |
Equipment Declined-commuter flights |
1
$ 287 |
Total 52
$ 15,459 |
Declined Preferred Carrier |
1
$ 219 |
Total
139 |
$ 42,354 |
Summary Boookings < 7 Days
| Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance |
Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance
| Traveler Name |
| 19-May |
Jun-19 Jul-19 Aug-19 Sep-19
|
|
| 19-Oct |
|
|
| 19-Nov |
| 19-Dec |
Total Traveler Name Sep-19 19-Oct 19-Nov Total
| REMBISH/MICHAEL JAMES |
2 2 4 2 6 4 1 21 REMBISH/MICHAEL JAMES 10 4 1 15
| MAEDER/MICHAEL CHARLES MR |
1 2 4 4 4 4 1 20
| GONZALEZ/MARCO ANTONIO MR |
5 7 2 14
| ST CLAIR/COLIN MR |
1 3 4 5 4 1 18 ST CLAIR/COLIN MR 5 4 2 11
GONZALEZ/MARCO ANTONIO MR 1 1 1 2 4 6 1 16 MAEDER/MICHAEL CHARLES MR 4 5 9
| ZETTLEMOYER/ADRIAN F |
5 4 4 13 ZETTLEMOYER/ADRIAN F 4 5 9
| MYERS/RHONDA LEE MRS |
1 3 1 4 1 1 11
| HARPER SR/SEAN ALEXUS MR |
2 2 2 6
HARPER SR/SEAN ALEXUS MR 2 2 1 3 2 10
MOORE/KIMBERLY JEAN |
3 3 6
SACHLEBEN/PATRICK CHRISTIAN MR |
3 3 2 1 1 10
| THOMAS/JACE M |
2 3 1 6
THOMAS/JACE M 3 3 2 1 9 MYERS/RHONDA LEE MRS 4 1 5
GILBERT/MATTHEW SCOTT |
1 1 2 2 1 1 8
CATANZARO/MICHAEL D |
4 4
All Others (143) |
40 45 45 58 37 48 43 32
348 |
All Others (65) |
31 41 40
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 |
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 |
St Clair, Colin
| $ 8,923 |
| $ 15,422 |
| $ 12,654 |
$ 36,999 |
St Clair, Colin
| $ – |
$ 8,211 |
$ 55 |
$ 7,653 |
$ 8,923 $ 15,422 $ 12,654
$ 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 |
$ 9,839 $ 11,848 $ 4,186 $ –
$ 55,415 |
Cates, Brian L $ 7,368 $ 6,758 $ 7,330
$ 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 |
Madgey, Christopher Michael $ 3,561 $ 11,780 $ 3,645
$ 18,986 |
| Cloninger, David Andrew |
$ 7,594 |
$ 4,213 |
$ 1,026 |
$ 4,481 |
| $ 4,277 |
| $ 10,295 |
| $ 3,858 |
$ 3,992 |
$ 39,735 |
Cloninger, David Andrew $ 4,277 $ 10,295 $ 3,858
$ 18,429 |
| Scott, Bradley C |
$ 6,229 |
$ 3,655 |
$ 3,979 |
$ 4,785 |
| $ 7,349 |
| $ 6,797 |
| $ 3,107 |
$ 3,709 |
$ 39,609 |
Scott, Bradley C $ 7,349 $ 6,797 $ 3,107
$ 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 |
Total $ 528,962 $ 635,491 $ 481,646
$ 1,646,099 |
Dec 2019 transactions have not been submitted in their entirety |
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 – Sep to Nov
Outside Policy Air Travel Sep – Nov
Top 10 Travelers – May to Aug
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
2
Spend CategoryApr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Total
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
Turn in your highest-quality paper
Get a qualified writer to help you with
“ excel expert ”
Get high-quality paper
NEW! AI matching with writer