excel expert

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

2

>

Don't use plagiarized sources. Get Your Custom Essay on
excel expert
Just from $13/Page
Order Essay
Travel

Spend Graph

-NOV1

)

Travel Spend (APR

-NOV19)
Created by E.Badjeck on 01/08/20

Travel +

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

P2W

Travel Spend (APR

1 8 9
Created by E.Badjeck on 01/08/

20
18
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
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
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

54

56

41

12

66

32

44

36

37

27

31

17

20

51

85

43

32

41

50

14

Total

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
4,837 $ 991,590

Summary Policy Violations

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

Total

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
139 $ 42,354

Summary Boookings < 7 Days

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

GONZALEZ/MARCO ANTONIO MR 1 1 1 2 4 6 1 16 MAEDER/MICHAEL CHARLES MR 4 5 9

5 4 4 13 ZETTLEMOYER/ADRIAN F 4 5 9

1 3 1 4 1 1 11

2 2 2 6

HARPER SR/SEAN ALEXUS MR 2 2 1 3 2 10

3 3 6

3 3 2 1 1 10

2 3 1 6

THOMAS/JACE M 3 3 2 1 9 MYERS/RHONDA LEE MRS 4 1 5

1 1 2 2 1 1 8

4 4

40 45 45 58 37 48 43 32

31 41 40

Total 48 56 64 76 63 79 55 43 484 Total 66 74 57

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
ZETTLEMOYER/ADRIAN F
MYERS/RHONDA LEE MRS HARPER SR/SEAN ALEXUS MR
MOORE/KIMBERLY JEAN
SACHLEBEN/PATRICK CHRISTIAN MR THOMAS/JACE M
GILBERT/MATTHEW SCOTT CATANZARO/MICHAEL D
All Others (143) 348 All Others (65) 112
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

St Clair, Colin

St Clair, Colin

$ 8,923 $ 15,422 $ 12,654

Rembish, Michael James

$ 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

Total $ 528,962 $ 635,491 $ 481,646

TOP 10 TRAVELERS BY OVERALL SPENDING
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
$ – $ 8,211 $ 55 $ 7,653 $ 2,512 $ 55,430 Rembish, Michael James $ 9,839 $ 11,848 $ 4,186 $ 25,874
$ 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
$ 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

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

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Need a better grade?
We've got you covered.

Order your paper