Roster in Excel: The Best Work Scheduling Template

Advertisements

Hi! Like many, I work in a company with a group of colleagues to perform daily tasks according to our defined job roles and responsibilities. We have a manager or a team lead who manages our schedule to make sure enough resources are available in a given hour or day. For sure you also notice how difficult it is for your team lead to manage your work schedule. It is not easy and is time consuming. It can be annoying sometimes, too. There are even times when team leads spend the entire working day just to plan for the next week or next month’s work schedule. It is a bothering task especially when he or she has other tasks to do. Schedule management causes stress which could affect the whole team and its performance.

So I developed Roster in Excel to help managers, team leads, and individuals to manage a team work schedule more efficiently. And believe me, nobody yet has dedicated much time and skills to come up with a similar tool like this. You can watch free tutorials videos online on how to create a work schedule in Excel from scratch but nobody ever bothered to create an automated template that everybody can use. There are also other app-based and online based schedulers available that not only they are not very user friendly but also the costs are way too high that it’s not worth to purchase them.

Download the Demo File here!

Roster in Excel is Microsoft Excel-based so no need to download a software or anything since most of us have Microsoft Excel in our computers. You simply need to get a copy of the template and you can open it and start using it. You have an option to use Roster in Excel online on your laptop, tablet, or mobile phone too but the features and functionality will not be the same as managing it on your laptop or computer.

Since Roster in Excel is a template, you do not need to be an expert Microsoft Excel user to avail of it. It is very easy to use as there is very less effort from the end user to manage the schedule. I designed it in such a way that what you need to do is to assign a shift to each of the team members. The template will then tell you the number of hours or days plotted for a team member on the right side. On the bottom part of the tool, you will see clearly the number of resources or headcount per hour.

And this template is copied into the other 11 months so that you do not need to do extra repetitive work which really saves you a lot of your time. To move from one month to another, you can either click the month that you want or you can use the next and previous month buttons.

This tool can accommodate up to 100 team members. You just need to unhide the rows to allow more names in the list. The freeze dates and freeze names buttons are available to help you scroll more efficiently. I suggest you hide unused rows to make your schedule look better.

Advertisements

Download the demo file now so you can play with it and learn the tricks on how to easily manage the tool. And whenever you are ready, please support this initiative by getting your own copy with any amount you are comfortable giving. Send me an email to rosterinexcel@outlook.com.

But before you get a copy of Roster in Excel please take note of the ff:

  • There is no free support provided for this tool. I can respond to your emails in a best effort basis.
  • You have used Microsoft Excel before.
  • You have watched at least the introduction video OR have tried the demo file online or on your desktop and are familiar with how the tool works.
  • Your shifts are either 9 hours or 12 hours or both with 1 hour lunch break.
  • Your shifts start at an exact hour (example: 8:00 am and not 8:30 am).
  • Your shifts end at an exact hour (example: 5:00 am and not 5:30 am).
  • You have a team with less than 100 members.
Advertisements

Review: Truth & Life Dramatized Audio Bible App

Advertisements

This is my own review for the Truth & Life Dramatized Audio Bible: New TestamentBook by Carl Amari, Michael (PRD) Stark, and Raymond (PRD) Arroyo, an app you can download via your Android or IOS phone with a one-time minimal charge.

This app is one of the best gifts I gave to myself and I have been enjoying it ever since. I love it because I can play it anytime I want and listen to the Word of God effortlessly even while doing something else. There is no other audio bible app out there better than this one, I promise!

The free version lets you experience a dramatized audio (a chapter if I remember correctly) but you will not be able to download the audio of the entire New Testament. You may check the current price of the app via its website https://www.truthandlifeapp.com/purchase.html.

Advertisements

Here is a video clip of the actual app with the dramatized audio activated. Do raise the volume if needed.

Other contents included in the Truth & Life app:

  • Dramatized Daily Mass readings (New Testament only)
  • Pray the Rosary
  • Pray the Stations of the Cross
  • Pray the Chaplet of the Divine Mercy
  • Access the Catholic News Agency (CNA)
  • Listen or Watch live broadcast of EWTN
  • Access audio and video on demand from selected EWTN programs
  • Free Online Bible studies with Fr. James Mcilhone
  • Access Word of Fire articles, blog, homilies, and online videos

I strongly recommend this not only to those who are studying apologetics and theology but also to all Christians who want grow in faith through reading, listening, and studying the Scriptures. It’s an investment you wont regret!

Let us serve Christ and the Church in all circumstances!

Advertisements

11 Books That May Also Help Keep Your Faith Alive

Advertisements

The Holy Bible

For us Christians, the Sacred Scriptures contain the Word of God and, because they are inspired, they are truly the Word of God (DV24, CCC135). The Holy Bible is a product of the Sacred Tradition handed to us by the Holy Apostles and the first disciples of Jesus. It was compiled only in 380 A.D. by Pope Saint Damasus I. The Holy Bible is the only book that sold at least five billion copies. Bibles are everywhere; they are in houses, in schools, in offices, and in other establishments.

The version that I prefer is the Christian Community Bible: Catholic Pastoral Edition because of its easy to understand translation and commentaries. This is the book that I read almost every day. I cannot imagine life without the Bible.

The Catechism of the Catholic Church

The Bible has been read by billions of people before us and has been interpreted officially by that Church that Jesus built. Private interpretation is prohibited (2 Pt 1:19) to avoid a divided Christianity into different sects and cults. There is only one God and One Church. The church came up with catechisms to sum up the beliefs of the faithful. This copy of the official Catechism of the Catholic Church (one in Spanish) is a work of Cardinal Ratzinger during the pontificate of Pope Saint John Paul the Great.

The Starved and The Silent

A holy priest, now a Venerable Servant of God, went to Korea to carry out missionary works. The country, recovering from the devastating war was at one point one of the poorest countries in the world. Monsignor John Phillip Aloysius Schwartz or Father Al wrote his own account of his own struggles and the many kinds of suffering of the Korean people. The heartbreaking story of his young friend Michael Rhi is the highlight of the book.

YouCat or Youth Catechism of the Catholic Church

Created especially for the young ones, this abridge version of the Catechism of the Catholic Church comes in an easy to read question and answers form accompanied by tidbits of interesting trivia in the side notes – a must have for the youth. I love the layout, fonts styles, and the images in the book.

Las Cronicas de Narnia

This is Spanish for ‘The Chronicles of Narnia’. It’s one of C.S. Lewis’s best sellers that contains seven interrelated stories. Films were made for the three of those stories namely, The Lion, the Witch and the Wardrobe (2005), Prince Caspian (2008), and The Voyage of the Dawn Treader (2010). The fourth film The Silver Chair is on its way. Narnia is my first choice of all works of fiction out there because of its strong Christian messages.

The Sermons of the Cure of Ars

When I feel the need of something to boost my lukewarm soul I turn to the words of Saint John Marie Vianney, the Cure of Ars. His sermons are so striking one could imagine being admonished by God himself. Some would say his messages does not apply to our own times but for me personally they remind me of the God’s love for each of us.

The Liturgy of the Hours

I have this one volume set of the Liturgy of the Hours bought by my wife for my birthday. Other names for this is The Divine Office or The Breviary. They are mostly used by the religious and the ordained but the laity are also encouraged to pray it. I love praying and reading the Liturgy of the Hours especially the first readings of the day. I love the fact that old testimonies, letters, sermons of great saints of the Church are made available and accessible for us to read.

Handbook of Catholic Apologetics

Authored by Dr. Peter Kreeft and Fr. Ronald Tacelli this book is a must have for Catholics especially those who are doing studies in Apologetics, Philosophy, and Theology. I heard one time in the radio Trent Horn (Catholic Answers apologist) saying this is one of the books that has helped him in his studies in the past and would recommend it to everyone.

Diary of Saint Maria Faustina Kowalska: Divine Mercy in My Soul

Saint Faustina wrote in her diary her private conversations with Jesus. Her hand written account was converted to a book and this became the result. She wrote her life story from her childhood days until the time she received the message of the Divine Mercy and started to propagate the devotion.

Cries of Jesus from the Cross: A Fulton Sheen Anthology

I recently received this book from Catholic Answers. I was surprised to see and love its content. Our dear Venerable Fulton J Sheen links the seven last words of Jesus from the cross to the deadly sins of anger, envy, lust, gluttony, and pride. He counters these vices with the practice of virtues in order to overcome them.

Advertisements

Marcelino

I was fortunate to grab this 1960 copy of this book in a church book sale in Malaysia. It’s a story of a young orphan boy left (when he was infant) in a Franciscan monastery because of civil unrest in the nearby village. The boy became a joy of the entire community despite of his misbehavior. Things changed after an encounter with someone alive who has been staying for a while in the friary’s upper room. I wont go further :-).

I already knew about the story in a Spanish movie Marcelino: Pan y Vino prior to reading the book but I assure you I appreciated the story even more when I read it.

Let us serve Christ and the Church in all circumstances!

Advertisements

Villa Elma, a Good Alternative to the Crowded ‘Kamay Ni Hesus’

Advertisements

A used-to-be private property has opened its gates for public in the city of Lucban, Quezon. This beautiful site is located right at the slope of a mountain facing the peak of the mysterious Mount Banahaw and is just a 15 minutes ride from the town proper. Villa Elma is a family owned property with sculptures and statues like those of Kamay ni Hesus along the Lucban-Tayabas road. In fact, some of the figures in both locations look exactly the same.

The thing that I like most in Villa Elma is the serenity of the place. I could hear the birds of different kinds singing all day long. And since the whole place is filled with flowers and trees, countless butterflies and insects can be spotted. It’s really a perfect place to appreciate the beauty of God’s creation. I could also hear water running down the side of the mountain. Indeed a fitting place for prayer, meditation, and reflection.

The other feature of the place is the option to stay for a night. They have some rooms available at a reasonable rate and I can tell you, you will never be disappointed with the deal. The rooms are very spacious and some of them with terraces. I was told by their care taker that high-ranking Philippine Officials have stayed in the place for a retreat and for leisure.

They offer food orders during daytime and you can enjoy it served at your room or at their canteen. They offer local dishes like the Pancit Lucban and Longanisang Lucban which are the best sellers in the area.

The most memorable moment I had there was swimming in a natural non-tiled pool of spring water. The water is so fresh you can actually drink it. Only I dared to dip in the water while my wife and kids enjoyed a shower of spring water nearby.

We had an enjoyable experience at the place and so I am confident you will also have the same. Learn more about the place via their website http://www.villaelma.com.ph/store/c1/Featured_Products.html.

Let us serve Christ and the Church in all circumstances!

Advertisements

A Necklace Tag Designed for Catholics

Advertisements

After my conversion years ago, I have been wanting to wear something that is designed by myself, something of religious significance that is wearable in public. I also thought of having something unique that I could give as gift to my Catholic friends who are passionate about their faith. So I ended up with a simple dog tag design with features you see in the photos.

Thoughtfully designed for Catholics, this dog tag comes with a dose of apologetics and part of the creed we profess at Mass. So not only that I have important bible verses handy with me but I also can show the world the joy of being a member of this One, Holy, Catholic, and Apostolic Church.

The tag has the emblem of the papacy with the crossed keys that symbolizes the keys of Peter – our first pope. The three crowns in the emblem represent the power of the Pope as “father of kings”, “governor of the world” and “Vicar of Christ”. The gold cross on a globe surmounting the crown or tiara signifies the sovereignty of Jesus. You can read more about the emblem here.

These are the important Bible verses and Catechism paragraph numbers that are engraved in black at the back of the tag:

  • Matthew 16:18 – “Blessed are you, Simon son of Jonah. For flesh and blood has not revealed this to you, but my heavenly Father. And so I say to you, you are Peter, and upon this rock I will build my church, and the gates of the netherworld shall not prevail against it. I will give you the keys to the kingdom of heaven. Whatever you bind on earth shall be bound in heaven; and whatever you loose on earth shall be loosed in heaven.”
  • Matthew 28:18-20 – “All power in heaven and on earth has been given to me. Go, therefore, and make disciples of all nations, baptizing them in the name of the Father, and of the Son, and of the holy Spirit, teaching them to observe all that I have commanded you. And behold, I am with you always, until the end of the age.”
  • John 21:15 – When they had finished breakfast, Jesus said to Simon Peter, “Simon, son of John, do you love me more than these?” He said to him, “Yes, Lord, you know that I love you.” He said to him, “Feed my lambs.”
  • CCC 811-870 – The Catechism paragraphs that explain the Church in detail.

This dog tag is made of nickel plated stainless steel. The texts are engraved while the logo is printed directly on the tag. It comes with one stainless and one regular iron ball chains in its pouch.

You may message me if you like this design and you want to have one or if you want to give it to someone as a gift. It’s a perfect and a unique piece of gift you can give to anyone regardless of the occasion. Items are limited and are only available in few areas such as Singapore, Manila, and Lucena.

Let us serve Christ and the Church in all circumstances!

Advertisements