Skip to content

A little — every day.

az-log: one row a day and the profile that locked my phone

6 min read

On this page
In short
az-log is a Google spreadsheet where one row is one day and the columns are split into four areas: faith, health, family and income. On the very first day the spreadsheet showed that I had missed all five prayers, and for four of them the reason was the same: my phone. After that I put a profile on my iPhone and iPad with Apple Configurator that removes entertainment apps and sites and can’t be removed.

Where the spreadsheet came from

My goals for the year are written in my notes, in four areas. The problem was that by the end of the month I couldn’t honestly say whether I had met them. There was a feeling of “seems fine”, and a feeling proves nothing.

So I decided to count. Not in a tracker app, but in an ordinary spreadsheet that I can restructure myself, compute with formulas, and not depend on someone else’s service. Every goal in my notes now ends with the words “by az-log”: if a goal can’t be checked against the spreadsheet, it has to be rewritten.

How it works

One row — one day. The columns are grouped by area, each with its own colour, and each group can be collapsed.

AreaWhat I record (column names)
Faithfajr … isha — status of each prayer, _min — how many minutes after the adhan, _why — reason, quran_pages
Healthmorning: bed_time, sleep_h, sleep_q, room_humidity; evening: mobility, strength, cardio_min, cold_shower_sec, vit_d, gargle; Saturday tests toe_floor_cm, chair_30s, grip_reps
Incomejava_book_min, pet_project_min, leetcode_solved
Familydishes, kindergarten_or_outdoor, cooked, cleaning

I fill it in twice: in the morning after fajr, the sleep part; in the evening after isha, everything else. It takes a couple of minutes.

A few rules without which the numbers quickly turn into garbage:

  • Empty ≠ 0. Zero means “definitely didn’t do it”. If I don’t remember, I leave the cell empty so it doesn’t spoil the average.
  • A prayer has three statuses. 2 — within 30 minutes of the adhan, 1 — later, but within its time, 0 — missed.
  • A reason is required for status 1 or 0, and only from a list: sleep, work, travel, forgot, phone, other. You can’t count free text, but you can count a list.
  • A separate stats sheet computes everything with formulas. I never type anything there by hand.

إِنَّ الصَّلَاةَ كَانَتْ عَلَى الْمُؤْمِنِينَ كِتَابًا مَّوْقُوتًا

Indeed, prayer has been decreed upon the believers a decree of specified times.
Quran Surah an-Nisa 4:103

That’s why I count not only “prayed or not” but also “on time or not”.

The first row

The first day in the spreadsheet was Thursday, 29 October. I copied it over from my old prayer log to test the format.

Result: 0 out of 5. I slept through fajr, and for dhuhr, asr, maghrib and isha the _why column had the same word: phone.

Until then I hadn’t thought my phone was taking so much from me. Suspecting it is one thing; seeing four identical cells in a row is another. It’s hard to argue with a spreadsheet you filled in yourself.

AZ-Way Lock

I decided not to rely on willpower and “just scroll less”, but to remove the choice itself. Using Apple Configurator, I built the configuration profile .mobileconfig and installed it on my iPhone and iPad. It has three parts.

1. DNS filter. All DNS goes through Cloudflare for Families over DNS-over-HTTPS. It blocks malicious sites and adult content. The ProhibitDisablement flag prevents turning it off in Settings.

2. Website filter. The built-in iOS web filter with a list of blocked addresses: video hosting, social networks, streaming, anime sites and online cinemas. The filter works both in the browser and in apps (FilterBrowsers, FilterSockets).

3. Restrictions. This is the strictest part:

  • A list of blocked apps by bundle ID: social networks, video, music services, a few games, and every browser except Safari, so the web filter can’t be bypassed.
  • Also on the list: VPN apps and anything that can “open a link somewhere else”.
  • Apple Music, Podcasts, News, iTunes Store, Game Center, Siri, internet results in Spotlight and iCloud Private Relay are turned off.
  • Installing other profiles, creating a VPN, erasing the device and connecting it to new computers are forbidden.
  • The profile itself is marked as non-removable.

A short fragment to show what it looks like:

<key>PayloadType</key>
<string>com.apple.applicationaccess</string>
<key>allowVPNCreation</key>
<false/>
<key>allowUIConfigurationProfileInstallation</key>
<false/>
<key>allowEraseContentAndSettings</key>
<false/>
<key>blacklistedAppBundleIDs</key>
<array>
    <string>com.google.ios.youtube</string>
    <string>com.burbn.instagram</string>
    <!-- … -->
</array>

Most of these restrictions only work on a supervised device, so I had to put the iPhone and iPad into supervised mode through Configurator. That means erasing them and setting them up again. It also left exactly one way out: the profile can only be removed from the Mac that supervises the device. You can’t do that in bed at night, and that’s the whole point.

Calls, messages, camera, maps, books and work apps stayed. The phone became a tool again.

How it’s going

So far the spreadsheet has 9 full days, from 29 October to 6 November, and 44 filled prayer cells.

StatusCells
On time (2)14
Later, but within its time (1)13
Missed (0)17

Reasons for being late or missing:

_whyTimes
work8
other7
sleep6
phone5
forgot2
travel1

What I see in this:

  • phone is no longer the main reason. Four of the five times fell on the first day. But 9 days is far too few to draw conclusions, so for now I just keep recording.
  • Fajr is the weakest spot. In 9 days it was missed 5 times, and every time the reason was sleep. It was on time only on the last two days.
  • The new leader is work. Dhuhr and the evening prayers on workdays suffer most. That’s no longer a question about the phone, but about how the workday is structured.
  • other is too vague. Seven times “other” means the list is missing a real reason. I’ll figure out what hides behind it and add a separate item.

I count the other areas the same way, but they’ll be more interesting to talk about in a month, when there is something to compare. I wrote about where vit_d, gargle and cold_shower_sec in the spreadsheet came from in immunity-cold-hardening.

What’s next

For December I have concrete goals, all checkable against the spreadsheet:

  • prayers: no more than 10 % missed, at least 60 % on time;
  • mobility exercise on at least 90 % of days;
  • dishes on at least 90 % of days, cleaning every Saturday, cooking at least twice a week.

At the end of the month I’ll count and write what came of it. If it didn’t work out, I’ll show the numbers too.