19 EASY STEPS of EXCEL HW NEEDED!!
sseojk
excel.xlsmDocumentation
| New Perspectives Excel 2013 |
| Tutorial 7: SAM Project 1a |
| Spring Software |
| CUSTOMIZING WORKBOOKS USING MACROS AND DATA VALIDATION |
| Author: |
| 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. |
Consolidated
| Spring Software-Consolidated Sales | ||||||
| Product Revenues | ||||||
| Revenues | 2014 | 2015 | 2016 | Total | Trend | |
| Spring Groupware | ||||||
| Subscriptions | $ 5,372,865 | $ 5,390,853 | $ 5,803,769 | $ 16,567,488 | ||
| Site Licenses | $ 2,442,212 | $ 3,096,873 | $ 3,957,116 | $ 9,496,200 | ||
| Other | $ 1,953,769 | $ 2,982,174 | $ 3,429,500 | $ 8,365,443 | ||
| Groupware Total | $ 9,768,846 | $ 11,469,900 | $ 13,190,385 | $ 34,429,131 | ||
| Spring Mail | ||||||
| Subscriptions | $ 875,958 | $ 1,967,213 | $ 2,638,607 | $ 5,481,778 | ||
| Site Licenses | $ 1,112,703 | $ 2,866,510 | $ 4,397,679 | $ 8,376,892 | ||
| Other | $ 378,793 | $ 786,885 | $ 959,494 | $ 2,125,171 | ||
| Spring Mail Total | $ 2,367,454 | $ 5,620,608 | $ 7,995,780 | $ 15,983,842 | ||
| Spring Math Genius | ||||||
| Subscriptions Elaine: Version2 release delayed. Most Version1 subscriptions and licenses expired in 2015; contracts expected to renew in 2017 with Version2 release. | $ 249,523 | $ 316,785 | $ 150,450 | |||
| Site Licenses | $ 939,379 | $ 1,017,048 | $ 51,000 | |||
| Other | $ 278,878 | $ 333,458 | $ 53,550 | |||
| Math Genius Total | $ 1,467,780 | $ 1,667,292 | $ 255,000 | $ - 0 | ||
| Consulting Services | $ 13,734,300 | $ 15,810,000 | $ 19,125,000 | $ 48,669,300 | ||
| Total | $ 27,338,380 | $ 34,567,800 | $ 40,566,165 | $ 99,082,273 |
View Sparklines
Manchester
| Spring Software-Manchester Sales | ||||||
| Product Revenues | ||||||
| Revenues | 2014 | 2015 | 2016 | Total | Trend | |
| Spring Groupware | ||||||
| Subscriptions | $ 268,643 | $ 269,543 | $ 290,188 | $ 828,374 | ||
| Site Licenses | $ 122,111 | $ 154,844 | $ 197,856 | $ 474,810 | ||
| Other | $ 97,688 | $ 149,109 | $ 171,475 | $ 418,272 | ||
| Groupware Total | $ 488,442 | $ 573,495 | $ 659,519 | $ 1,721,457 | ||
| Spring Mail | ||||||
| Subscriptions | $ 87,596 | $ 196,721 | $ 263,861 | $ 548,178 | ||
| Site Licenses | $ 111,270 | $ 286,651 | $ 439,768 | $ 837,689 | ||
| Other | $ 37,879 | $ 78,689 | $ 95,949 | $ 212,517 | ||
| Spring Mail Total | $ 236,745 | $ 562,061 | $ 799,578 | $ 1,598,384 | ||
| Spring Math Genius | ||||||
| Subscriptions | $ 87,333 | $ 110,875 | $ 52,658 | $ 250,865 | ||
| Site Licenses | $ 328,783 | $ 355,967 | $ 17,850 | $ 702,600 | ||
| Other | $ 97,607 | $ 116,710 | $ 18,743 | $ 233,060 | ||
| Math Genius Total | $ 1,467,780 | $ 1,667,292 | $ 255,000 | $ 1,186,525 | ||
| Consulting Services | $ 6,180,435 | $ 7,114,500 | $ 8,606,250 | $ 48,669,300 | ||
| Total | $ 8,373,403 | $ 9,917,348 | $ 10,320,347 | $ 53,175,666 |
View Sparklines
Sales Data Entry Form
| Spring Software | ||
| Sales Data Entry Form | ||
| Product Name | ||
| Customer Name | ||
| Contract Type | ||
| Date of Sale | ||
| Total Sale | ||
| Spring Sales Contact | Rohan Mateev | |
Clear
