I pulled together this Excel mashup example to demonstrate how the Excel mashup functionality for the web works. This is a simple HTML table that shows the North American sales of MINI automobiles. You know, the ones that put GP on some of their cars.
I added some basic HTML code to allow users to put some intelligence to the numbers in an online mashup. Click the Excel Interactive View link to analyze this data in the web browser. I don’t have a concrete use case for this for GP data…yet…but it’s both cool and easy.
[excel-interactive-view title=”MINI Sales North America”]
| Model | 2013-09 | 2012-09 | Month % | YTD 2013-09 | Ytd 2012-09 | YTD % |
|---|---|---|---|---|---|---|
| Cooper /S Hardtop | 1,789 | 1,796 | -0.4% | 20,553 | 21,343 | -3.7% |
| Cooper /S Convertible | 486 | 306 | 58.8% | 3,663 | 3,792 | -3.4% |
| Cooper /S Clubman | 338 | 417 | -18.9% | 3,499 | 4,249 | -17.7% |
| Coupe | 660 | 184 | 258.7% | 2,241 | 2,206 | 1.6% |
| Roadster | 363 | 194 | 87.1% | 2,418 | 1,596 | 51.5% |
| Countryman | 1,191 | 2,002 | -40.5% | 15,596 | 15,345 | 1.6% |
| Paceman | 479 | 0 | 0.0% | 1,665 | 0 | 0.0% |
| MINI Brand | 5,306 | 4,899 | 8.3% | 49,635 | 48,531 | 2.3% |
Information source: BMW of North America, Inc.