Documentation
New Perspectives Excel 2016 | Modules 5–8: SAM Capstone Project 1a
Wild Planet Conservation
DATA VALIDATION, ADVANCED FUNCTIONS, TABLES, AND PIVOTTABLES
Author: destiny santana
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Local Offices
Wild Planet Conservation
Local Field Offices
Office Manager City Phone Email
California Deb Friesen Sacramento (916) 555-1877
[email protected] Oregon Andy Wong Salem (503) 555-3002
[email protected] Washington Gina Mendoza Olympia (360) 555-4311
[email protected] Staff Information
California Fundraisers Event Totals
Type March May Total Type Total
Adopt an Animal $ 50,000 $ 37,500 $ 87,500 Adopt an Animal $ 227,750
Run for the Wild 21,750 34,600 56,350 Run for the Wild 158,900
Total $ 71,750 $ 72,100 $ 143,850 Total $ 386,650
Ali: This amount exceeded our goal this year!
Oregon Fundraisers Event Coordinators
Type March May Total Name Amanda Arnett
Adopt an Animal $ 32,000 $ 28,750 $ 60,750 WPC Office Oregon
Run for the Wild 20,500 30,550 51,050 March Date 3/12/19
Total $ 52,500 $ 59,300 $ 111,800 May Date 5/15/19
Event Run for the Wild
Washington Fundraisers
Type March May Total
Adopt an Animal $ 47,500 $ 32,000 $ 79,500
Run for the Wild 21,000 30,500 51,500
Total $ 68,500 $ 62,500 $ 131,000
mailto:
[email protected]:
[email protected]:
[email protected]California
Wild Planet Conservation
California Revenue - 2019
Jan Feb March Apr May Total
Patron $ 675 $ 350 $ 325 $ 375 $ 250 $ 1,975
Sponsor 1,525 650 3,350 4,250 2,500 12,275
Benefactor 6,900 5,250 9,750 2,500 1,500 25,900
Fundraisers - 0 - 0 71,750 - 0 72,100 143,850
Total $ 9,100 $ 6,250 $ 85,175 $ 7,125 $ 76,350 $ 184,000
Oregon
Wild Planet Conservation
Oregon Revenue - 2019
Jan Feb March Apr May Total
Patron $ 525 $ 300 $ 315 $ 355 $ 225 $ 1,720
Sponsor 1,025 625 3,150 4,000 2,100 10,900
Benefactor 5,100 4,250 8,150 2,700 2,500 22,700
Fundraisers - 0 - 0 52,500 - 0 59,300 111,800
Total $ 6,650 $ 5,175 $ 64,115 $ 7,055 $ 64,125 $ 147,120
Washington
Wild Planet Conservation
Washington Revenue - 2019
Jan Feb March Apr May Total
Patron $ 595 $ 550 $ 515 $ 555 $ 275 $ 2,490
Sponsor 1,525 825 3,050 4,200 2,700 12,300
Benefactor 5,800 4,950 8,000 2,950 3,500 25,200
Fundraisers - 0 -...