Prayers Tracker in Excel for Muslims

Dear Muslim Brothers and Sisters,

Ideally speaking, we, the Muslims, should not maintain such trackers as 5 times prayers is compulsory on us and we should be performing each prayer on time without any reminder. However, being too weak in our Imaan (Faith) we miss a lot of prayers on daily basis. 

Hence, I created this "Prayers Tracker"  and I personally experienced it helping me remind myself again and again to pray on time, perform the missing prayers (Qaza) and improve my stats (as shown in the automatic Summary Sheets). This is why I want to share this excel file with you as well.

The only thing you have to do is to enter your prayer in the first sheet. Rest of the graphs are created automatically.

Sheet-1: Enter Your Prayers:

Summary-1 Sheet: This automatic sheet will show total numbers of prayers (performed and remaining) for each day and each month

Summary-2 Sheet: This sheet shows Performed and remaining prayers for different months. Chose the month and graph will be displayed automatically.

Summary-3 Sheet: This sheet shows percentage of prayers performed and remaining. This sheet is also automatic.

Summary-4 Sheet: This sheet shows Prayer-specific statistics for each month. Chose the prayer and the graph will be displayed automatically.

Summary-4 Sheet: This sheet shows high-level numbers/stats. (Automatic)

If you want to get a copy of this excel file, please drop me an email at mjunaidtahir@gmail.com and I shall respond back within 48 hours insha-Allah.

Note: please let me know if you want me to send you an A4 printing pdf file which you can print and distribute to your family members, friends and colleagues. Please help spread this message as it will act as Sadqa-e-Jaria for you, insha-Allah.