Mud Up Calendar Rotational Planner Sheet for Oilfield Personnel

My friend sent me the rotational planner sheet few day ago and I think this is really handy for someone who work as rotational schedule. It helps me save a lot of time trying to mark my working schedule on the calendar.

mud-up-calendar

How to Use This File?

1. Open the rotational planner sheet and enable Macro.

1 enable macro

You will see the excel sheet look like this.

2 first screen

 

2. At the top left of the sheet, select the year. This year is 2016 so I put 2016 in this box.

3 input 2016

3. Select time off. For example, if I am off the rig on 26-Jan-16, I select the 26 January 2016.

4 start date

4. Select work schedule. Each number means time on and time off. For example, 7 means work 7 days and off 7 days. For me, I select 28.

5. Your work schedule is ready. The green cell is when you start your time off and the red cell is time when you start working. Moreover, the blue-shaded cells are your time off and the white cells are your working time.

5 final

Note: this sheet works only for even time on and time off. You cannot use it if your schedule is not even. For instant, if your work schedule is 4 week on and 2 week off, you will not be able to use it.

Download the excel sheet here ->Rotational Planner Sheet for Oilfield Personnel

Thanks PeteHeff for creating this useful excel sheet.

Related Post

Noble Rig Jacking Mechanisms Failure At Jurong Sh... I got these photos from my friend. They are accident happened in Jurong Shipyard in Singapore on 3 Dec 2012. The rig is belong to Noble. I ...
Texas-Drilling Rig Hits Gas Pipeline Then Explodes November 14th, 2013 MILFORD, Texas -Hundreds of people in Ellis County were evacuated and others were asked to stay away from the area where a gas pip...
Another Way to Free Stuck Pipe You may sometimes are in a bad situation with stuck pipe. You may possibly try several method to free the pipe but NO SUCCESS. This is another meth...
Rig Drills a Water Well I've got these photos from my friends. It is about drilling water well using local drilling rig. It is pretty much the same set up as the oil rig but ...
Share the joy
  • 368
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
    368
    Shares
Tagged . Bookmark the permalink.

About DrillingFormulas.Com

Working in the oil field and loving to share knowledge.

18 Responses to Mud Up Calendar Rotational Planner Sheet for Oilfield Personnel

  1. Gary Hervig says:

    ok. nice.
    I can not use it – I’m 5 weeks on 5 weeks off. why not have a window you can input how many days you want ?

  2. Derrick Gillingham says:

    great calender

  3. Derrick Gillingham says:

    Use this calender alot

  4. Craig T. says:

    Rotational Planner Sheet for Oilfield Personnel Opens and allows me to enable editing but then the dialog box pops up stating the spreadsheet is protected and I must provide a password to un-protect it for editing. Can anyone provide the password?

  5. Buck Thomas says:

    Just wanted to say thanks for posting this, I have been rotating to many many years and use to have something similar but lost it last year.
    cheers
    BUck

  6. Ian Stradling says:

    Is there any way to get in touch with this PeteHuff fellow, who is the owner of the sheet? I’d like to talk to him about the calendar.

  7. John Ferrie says:

    Do you have a 2 on 3 off version of your rota

  8. Sherman Hollier says:

    Can you make a version that works on iphone? Thanks

  9. U Soe Myint says:

    Thanks.

  10. Richard Zhao says:

    very useful rota!!!

  11. Karim says:

    Great calendar,very useful .

    Thanks

  12. Amr says:

    Folks, we need a button for 35/35 rotation

Leave a Reply

Your email address will not be published. Required fields are marked *

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