Want to keep up with all of the excitement surrounding the Presidential Election Race? Check out the Election Tracker app for Excel.
The Election Tracker app automatically updates with the latest polling data and predictions for both the Presidential and Senate Races using data from PredictWise.
The goal of this app is to bring the Presidential Election data to users so that they can use the power of Excel to organize and analyze the data.
Check out the Election Tracker app here and look out for some of our other great apps that are in the Office and SharePoint store now.
Russell Palmer, a Program Manager in the Office Team explains how the app works and how we went about building it. An app for Office that was built in around 2 weeks!
Russell here, from the apps for Office engineering team! I’d like to walk you through the steps we took to build this cool app for Excel.
I don’t know about you, but “election fever” has got a lot of the people here hooked on watching the exciting debates. We wanted to build an app that showed how things changed over time (especially in the swing states) when certain news stories broke, and after each debate.
What’s cool about having this app and all of this great data in Excel, is that now I can create my own mash-up of charts and predictive analysis to come up with my own conclusions on who might win! Excel is a great tool that lots of people are familiar with (to say the least) and has lots of great features around using data.
Next, we worked with a designer to add the header elements, which look great following the Microsoft Modern Design Language. We added a refresh button, and tabs to switch between Electoral College and Senate races on the map.
After that, we added a few tabs to the workbook (with patriotic color styling, of course ) and created separate tables where our app would write the data from the feed. We pre-filled the tables with the data we already had, so the workbook could start with something.
Next, we added some Excel charts on top of the data tables we created, for some extra analysis on all the historical data we had kept in Excel.
Finally, we added a JQuery slider control (on top of a custom dateline graphic from our designer) which would change the map coloring based on the date you’re currently viewing.
When we finished, we simply signed up for an Azure Web sites account and connected the blank Web site to our TFS app project, and with one click our latest version was published to production! Future updates and fixes got automatically published with each check-in (when we chose to), which made upkeep and updates simple for our developers.
I hope you found this blog post helpful and inspirational, and we encourage you to check out dev.office.com, as well as sign up for free trials of TFS and Azure Web sites, and see how easy it is to quickly build great apps for Office.
Thanks for reading!
Russell Palmer, and the Election Tracker app team
Ready to build an app for the Office and SharePoint Store? All the info you need is at dev.office.com where we will also be publishing a number of in-person app building events.