How much time can SharePoint 2013 save me?


We finished up a course not too long ago called Managing SharePoint 2013 with PowerShell for admins who are familiar with SharePoint, but not with PowerShell. While we were wrapping up the course, the TrainSignal gang and I were discussing the amount of time someone could actually save by doing different automatons in the course. So, let’s actually figure out how much time we could save by automating those tasks.

It’s time to do some very simple math to figure out how much time we can save:

TR= the time the repetitive task takes

WR= (Weekly Rate) repetitive task per week

Math: (TR*RW)

Let’s go do a test run of the actual math:

Example 1

example 1a

TR= 19

WR= 5

Math: (TR*RW) = 95

By automating the “Repetitive Task” we see we can actually save 95 minutes (1 hour, 35 minutes) per week. Now how about the actual automations done in the course?

In the course one of the things that the company Globomantics needs is to have site collections and webs created. This task should be done every Friday. Now none of us really wants to be at work after hours on a Friday, especially if there is a zombie movie marathon that weekend, but the task needs to be done.

Not only is site creation repetitive, it’s also done at an inconvenient time. It’s a never-ending repetitive cycle. It is a trifecta of evil repetitive tasks that we want to make sure no one has to endure, so we automated it.

Sure, we save pain and suffering when we automate this task, but more importantly, we save time. Let’s get back to our simple math from before, but this time in a real world scenario.

Example 2

example 2a

We are going to be nice and say that the SharePoint environment is relatively speedy. From the moment you click the create button, to the moment when SharePoint is fully done creating, you only spend four minutes. This is generous, especially when you’re creating webs in different site collections and have to browse and then create. We are also assuming that you’ll never make a typo ever.

We are also going to add another value for the year, as this task is on a continuous schedule.

TR= 4

WR= 20

(Week)Math: (TR*RW) = 80 minutes (1 hour and 20 minutes)

(Year)Math: (TR*RW)*52 = 4160 minutes (69 hours and 20 minutes)

SharePoint Service report

Our Service Manager needs to give an accurate report weekly on the SharePoint service with specific requirements. This is normally an arduous task where the SM gets data from different areas and compiles them all together for a weekly report, and they start this again the following week.

By using PowerShell we can get you all sorts of data quickly and easily, and also automate it on a schedule if needed, saving the poor SM from having to hunt and compile every week.

Example 3

example 3a

The task only needs to be done once a week but it’s a very large task. How did we do on saving time in this example? Let’s find out.

TR= 240

WR= 1

(Week)Math: (TR*RW) = 240 minutes (4 hours)

(Year)Math::(TR*RW)*52 = 12480 minutes (208 hours)

Not bad on the time saving on this one!

Daily backup of executive site

In the course we talk about how to automate specific types of backups in the SharePoint 2013 environment. If we had to back up the executive site every day due to the high business impact of the documents, we would be working every night after working hours. (Again, you don’t want to miss the zombie movie marathon.) Like the others before, we use automation to save us from this.

Example 4

example 4a

TR= 240

WR= 1

(Week)Math: (TR*RW) = 175 minutes (2 hours 55 minutes)

(Year)Math: (TR*RW)*52 = 9100 minutes (151 hours 40 minutes)

Once again, automation gives us back a good chunk of our time to focus on other things.

Total time savings in a nutshell

We have gone through three of the examples that could save us time, energy and sanity as we move forward in SharePoint 2013. What we’re going to do now is put all the values together and see how well Globomantics did in saving time in the course.

Example 5

example 5a

Math time again:

Create sites/webs = TR*WR = 80 minutes

SharePoint service report = TR*WR = 240 minutes

Daily backup = TR*WR = 155 minutes

Weekly total = 475 minutes per week = 7.91 hours per week saved

Yearly total = 24700 minutes per year = 411.66 hours per year saved

So three little things automated saves employees from having to do repetitive tasks, and it saves the company over 10 work weeks of time. I’m sure you can continue to build on that to save the company more money, as well as make employees happier by decreasing those horribly evil repetitive tasks we all hate so much.

Doing it PowerShell style

“As an added bonus in this limited time offer, we will add in this free PowerShell function if you call within the next 10 minutes.”

Please don’t actually call. I’ve placed the PowerShell function below just for fun. If you do call, I’m not answering because I have automated my work and am currently watching a zombie marathon.

Time saving functions:

# Run function with the following parameters

# Example:

# TimeSaved –TaskName “Create Sites” –TaskTime 4 –WeeklyRate 7

# Condensed Example:

# TimeSaved “Create Sites” 4 7


Function TimeSaved(){









$YearlyRate = $weeklyrate * 52

$WeekTotalTime = $tasktime * $weeklyrate

$YearTotalTime = ($tasktime * $weeklyrate)*52

$Percentage = ($WeekTotalTime/2400)*100

$PercentageSaved = [Math]::Round($Percentage,2)

$Report [email protected]

Task Name: $TaskName

Time Spent per: $TaskTime minutes

Weekly Rate: $WeeklyRate times

Yearly Rate: $YearlyRate times

Weekly Time Save: $WeekTotalTime minutes

Yearly Time Saved: $YearTotalTime minutes

Percentage of Work hours saved: $PercentageSaved %



Return $Report}

Want to learn more about SharePoint 2013? Check out Jeff’s on-demand webinar here.

TrainSignal Pluralsightl


This site uses Akismet to reduce spam. Learn how your comment data is processed.