For many companies, Microsoft Sharepoint has become an important way to communicate and collaborate on projects, including hardware and software development projects. It’s very simple with SharePoint’s custom lists to develop quick bug reporting solutions to meet your internal needs and test methodologies in just a few minutes. However, what most people don’t realize is that SharePoint can also be used in conjunction with Microsoft Excel to perform some rather informative analysis and graphing of your defect tracking data.
The key to everything is the ability of SharePoint to export data to Excel using web queries. You can export the data to Excel and, using the connector, update the data from SharePoint whenever you want (e.g., on opening the spreadsheet, after a set period of time, via a macro button, etc.). It’s incredibly handy and VERY powerful, especially if you’ve any familiarity with some of Excel’s conditional formulas – in particular, COUNTIF.