#Office365Challenge In the previous post I shared a very simple custom list with you, which can be used as a Solutions Register. Today we’ll look at the detail as well as the ROI calculations.

Day: 209 of 365, 156 left
Tools:  SharePoint
Description: Solution Registers in SharePoint Part 2

Related posts:

Day 208 Solutions Registers in SharePoint Part 1

Below are the columns I used for the register:


  1. I build all apps / sites with a Short Acronym for a URL (in the case of Apps I then go rename it later).
  2. Date solution put into production is important, because I want to follow up 3 months later.
  3. Solution owner and Super User is rarely the same person – this detail is important for responsibility as well as the contact to follow up with.
  4. Complexity – here I have a multiple checkbox to identify any ‘complexity’ on the solution. Did we use InfoPath + SharePoint Designer Workflows or Nintex, any custom code added for styling etc.? This helps a lot when doing upgrades as well.
  5. ROI – now this is a very important part, even for users only building small solutions. Every bit adds up. Without this Super users will never get the true value they add AND the SharePoint Team will not be able to motivate for expenditure based on ROI.

Below is a simple example of determining ROI by only looking at minutes saved. You don’t need to know the actual salaries, get an average from HR. Saving a team of people 5 minutes a day doesn’t sound like much – but add that up over a year – WOW! (Calculation based on South African Rands – ZAR).


Please start documenting your solutions today. Even if only on this simple level. Do the ROI calculations. On days when you feel worthless – this helps to remind you.

Catch you tomorrow when I’ll start the journey around permission in SharePoint.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.