Tutorial 4

profileyeny.r
np_excel2013_t8_p1a__1.xlsx

Documentation

New Perspectives Excel 2013
Tutorial 8: SAM Project 1a
Spring Software
ADVANCED FUNCTIONS AND CONDITIONAL FORMATTING
Author: john Due
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.

CustomerList

Current Year 2017
Spring Software-Active Customer Database (Nashua) Customer Details
Customer ID Customer First Order Tenure (Yrs) 2014 Sales 2015 Sales 2016 Sales 2-Year Sales Growth 2-year Growth Percentage Discount Y/N Discount Priority Customer ID 1119
1001 Quantum Engineering 2010 $ 700,000 $ 720,000 $ 720,000 $ - 0 Customer Name ERROR:#N/A
1002 Lakeside Café 2014 $ 20,002 $ 20,002 $ 21,002 $ 1,000 2016 Sales ERROR:#N/A
1003 B&W Lumber 2015 $ - 0 $ 27,500 $ 29,500 $ 2,000 Discount
1004 Surfside Pool & Patio 2014 $ 140,000 $ 142,000 $ 145,000 $ 3,000 Customer Incentives
1005 Whitefield School System 2013 $ 95,000 $ 96,000 $ 97,000 $ 1,000
1006 Grapevine Consulting Grp 2012 $ 323,000 $ 350,000 $ 500,000 $ 150,000 Customer Incentives
1007 Fairfield Asset Management 2011 $ 317,000 $ 355,000 $ 410,000 $ 55,000 Yearly Sales $0 $75,000 $150,000 $400,000
1008 Whitehead Financial 2010 $ 247,000 $ 256,000 $ 301,000 $ 45,000 Free Service None Onsite Training Weekend Tech Support Dedicated Tech Support
1009 Funstop Toys 2016 $ - 0 $ - 0 $ 43,000 N/A
1010 Anna's Boutiques 2013 $ 15,300 $ 15,400 $ 15,500 $ 100
1011 Sunnyside Stores 2009 $ 183,000 $ 187,000 $ 172,000 $ (15,000)
1012 Bedfordshire School System 2011 $ 65,000 $ 124,000 $ 125,000 $ 1,000
1013 Westview Tutors 2014 $ 105,000 $ 125,000 $ 140,000 $ 15,000
1014 BWM Partners 2016 $ - 0 $ - 0 $ 233,000 N/A
1012 Firehouse Partners LLC 2012 $ 75,000 $ 161,000 $ 200,600 $ 39,600
1016 Forest Construction LLC 2015 $ - 0 $ 257,000 $ 301,000 $ 44,000
1017 Farmington Strategy Group 2013 $ 250,000 $ 275,000 $ 301,000 $ 26,000
1018 Diamond School District 2010 $ 183,000 $ 191,000 $ 193,000 $ 2,000
1019 Granite State Communications 2009 $ 245,000 $ 251,000 $ 302,000 $ 51,000
1020 Green Mountain Publishing 2014 $ 377,500 $ 379,500 $ 381,000 $ 1,500
1021 Atlantic Learning Group 2013 $ 235,000 $ 246,000 $ 250,000 $ 4,000
1022 Fontas Convenience 2010 $ 79,000 $ 88,450 $ 77,000 $ (11,450)
1022 Applewild Learning Center 2009 $ 133,000 $ 138,000 $ 142,000 $ 4,000
1024 Acme Printing 2013 $ 99,000 $ 101,000 $ 100,000 $ (1,000)
1025 Pinnacle Publications 2015 $ - 0 $ 157,000 $ 184,010 $ 27,010
1026 Fox Graphics 2015 $ - 0 $ 233,000 $ 256,000 $ 23,000
1027 Brookfield Regional Schools 2016 $ - 0 $ - 0 $ 98,000 N/A
1028 Ludlow Pharmacy Group 2014 $ 58,550 $ 75,650 $ 98,000 $ 22,350
1029 Wayside Public 2008 $ 75,000 $ 112,000 $ 117,000 $ 5,000

CustomerAnalysis

Customer Analysis - Nashua
All Customers High Priority Customers
Number of Customers
2016 Sales
Percent of 2016 Sales
Average Tenure
Average Sales/Customer