(v 3.1) Instruction Manuals by Hĺbkobot on Converting Koláčapka's CSV Reports into Obsedapka Color-Coded Tables

> [!attention] There is a **[[(v 4.0) Instruction Manual by Hĺbkobot on Converting Koláčapka's CSV Reports into Obsedapka Color-Coded Tables|more recent version]]** of this webpage. > [!success] **Courtesy of DeepSeek** > [!example] Nicknames Legend > * `Hĺbkobot` = **[DeepSeek](https://chat.deepseek.com)** > * `Koláčapka` = **[ATracker Pro](https://atracker.pro)** > * `Obsedapka` = **[Obsidian](https://obsidian.md)** ## Monday, 17 August 2026 ### Length of Day: 24 hours & 42 minutes <table> <thead> <tr> <th style="text-align: center;">Activity</th> <th style="text-align: center;">Description</th> <th style="text-align: center;">Start</th> <th style="text-align: center;">End</th> <th style="text-align: center;">Duration</th> <th style="text-align: center;">Note</th> <th style="text-align: center;">Category</th> </tr> </thead> <tbody> <tr> <td style="vertical-align: middle;">🌙 Sleep</td> <td style="vertical-align: middle;">preferred from 10 to 5</td> <td style="vertical-align: middle; text-align: center;">01:12</td> <td style="vertical-align: middle; text-align: center;">05:35</td> <td style="vertical-align: middle; text-align: center;">04:23</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Sleep</td> </tr> <tr> <td style="vertical-align: middle;">✉️ Online Comm</td> <td style="vertical-align: middle;">all types of it</td> <td style="vertical-align: middle; text-align: center;">05:35</td> <td style="vertical-align: middle; text-align: center;">05:50</td> <td style="vertical-align: middle; text-align: center;">00:15</td> <td style="vertical-align: middle; text-align: center;">nom</td> <td style="vertical-align: middle;">Altruism</td> </tr> <tr> <td style="vertical-align: middle;">📘 Vďibňík</td> <td style="vertical-align: middle;">Grail Diary entries or review</td> <td style="vertical-align: middle; text-align: center;">05:50</td> <td style="vertical-align: middle; text-align: center;">06:08</td> <td style="vertical-align: middle; text-align: center;">00:18</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Štúdium</td> </tr> <tr> <td style="vertical-align: middle;">🌞 Chores Morning</td> <td style="vertical-align: middle;">miscellanea at home & outside</td> <td style="vertical-align: middle; text-align: center;">06:08</td> <td style="vertical-align: middle; text-align: center;">06:15</td> <td style="vertical-align: middle; text-align: center;">00:07</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">🏗️ Prosto Intense</td> <td style="vertical-align: middle;">money-making projects with strict deadlihes</td> <td style="vertical-align: middle; text-align: center;">06:15</td> <td style="vertical-align: middle; text-align: center;">09:10</td> <td style="vertical-align: middle; text-align: center;">02:55</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">📘 Vďibňík</td> <td style="vertical-align: middle;">Grail Diary entries or review</td> <td style="vertical-align: middle; text-align: center;">09:10</td> <td style="vertical-align: middle; text-align: center;">10:40</td> <td style="vertical-align: middle; text-align: center;">01:30</td> <td style="vertical-align: middle; text-align: center;">e</td> <td style="vertical-align: middle;">Štúdium</td> </tr> <tr> <td style="vertical-align: middle;">✉️ Online Comm</td> <td style="vertical-align: middle;">all types of it</td> <td style="vertical-align: middle; text-align: center;">10:40</td> <td style="vertical-align: middle; text-align: center;">11:40</td> <td style="vertical-align: middle; text-align: center;">01:00</td> <td style="vertical-align: middle; text-align: center;">e</td> <td style="vertical-align: middle;">Altruism</td> </tr> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">11:40</td> <td style="vertical-align: middle; text-align: center;">13:10</td> <td style="vertical-align: middle; text-align: center;">01:30</td> <td style="vertical-align: middle; text-align: center;">e</td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🌞 Chores Morning</td> <td style="vertical-align: middle;">miscellanea at home & outside</td> <td style="vertical-align: middle; text-align: center;">13:10</td> <td style="vertical-align: middle; text-align: center;">14:46</td> <td style="vertical-align: middle; text-align: center;">01:36</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">🍴 Krmivo</td> <td style="vertical-align: middle;">mealtimes</td> <td style="vertical-align: middle; text-align: center;">14:47</td> <td style="vertical-align: middle; text-align: center;">15:56</td> <td style="vertical-align: middle; text-align: center;">01:09</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">🛏️ Nap</td> <td style="vertical-align: middle;">afternoon preferred</td> <td style="vertical-align: middle; text-align: center;">15:56</td> <td style="vertical-align: middle; text-align: center;">19:20</td> <td style="vertical-align: middle; text-align: center;">03:24</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Sleep</td> </tr> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">19:20</td> <td style="vertical-align: middle; text-align: center;">20:05</td> <td style="vertical-align: middle; text-align: center;">00:45</td> <td style="vertical-align: middle; text-align: center;">e</td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">✉️ Online Comm</td> <td style="vertical-align: middle;">all types of it</td> <td style="vertical-align: middle; text-align: center;">20:05</td> <td style="vertical-align: middle; text-align: center;">20:50</td> <td style="vertical-align: middle; text-align: center;">00:45</td> <td style="vertical-align: middle; text-align: center;">e</td> <td style="vertical-align: middle;">Altruism</td> </tr> <tr> <td style="vertical-align: middle;">📘 Vďibňík</td> <td style="vertical-align: middle;">Grail Diary entries or review</td> <td style="vertical-align: middle; text-align: center;">20:50</td> <td style="vertical-align: middle; text-align: center;">21:43</td> <td style="vertical-align: middle; text-align: center;">00:53</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Štúdium</td> </tr> <tr> <td style="vertical-align: middle;">🌐 News</td> <td style="vertical-align: middle;">newspaper proofreading night shift</td> <td style="vertical-align: middle; text-align: center;">21:43</td> <td style="vertical-align: middle; text-align: center;">22:02</td> <td style="vertical-align: middle; text-align: center;">00:19</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">22:02</td> <td style="vertical-align: middle; text-align: center;">22:17</td> <td style="vertical-align: middle; text-align: center;">00:15</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🌐 News</td> <td style="vertical-align: middle;">newspaper proofreading night shift</td> <td style="vertical-align: middle; text-align: center;">22:17</td> <td style="vertical-align: middle; text-align: center;">22:33</td> <td style="vertical-align: middle; text-align: center;">00:16</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">22:33</td> <td style="vertical-align: middle; text-align: center;">23:31</td> <td style="vertical-align: middle; text-align: center;">00:58</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🌐 News</td> <td style="vertical-align: middle;">newspaper proofreading night shift</td> <td style="vertical-align: middle; text-align: center;">23:31</td> <td style="vertical-align: middle; text-align: center;">23:46</td> <td style="vertical-align: middle; text-align: center;">00:15</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">23:46</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 00:35</td> <td style="vertical-align: middle; text-align: center;">00:49</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🌐 News</td> <td style="vertical-align: middle;">newspaper proofreading night shift</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 00:35</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 00:53</td> <td style="vertical-align: middle; text-align: center;">00:18</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🛋️ Chores Evening</td> <td style="vertical-align: middle;">miscellanea at home & outside</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 00:53</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:02</td> <td style="vertical-align: middle; text-align: center;">00:09</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">📘 Vďibňík</td> <td style="vertical-align: middle;">Grail Diary entries or review</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:02</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:22</td> <td style="vertical-align: middle; text-align: center;">00:20</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Štúdium</td> </tr> <tr> <td style="vertical-align: middle;">🛋️ Chores Evening</td> <td style="vertical-align: middle;">miscellanea at home & outside</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:22</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:28</td> <td style="vertical-align: middle; text-align: center;">00:06</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:28</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 01:54</td> <td style="vertical-align: middle; text-align: center;">00:25</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> </tbody> </table> > [!warning] Operational-day limitation > Unfortunately, ATracker forces every piechart report into a fixed 24-hour window. My operational days instead (as can be seen above) begin and end at manually chosen boundaries and may last less or more than 24 hours. The two piechart reports below therefore represent ATracker’s imposed artificial reporting window of exactly 24 hours from 10 p.m. to 10 p.m., but unlike the datatables, the piecharts do not accurately represent my lived day. ![[Kolacapka-20260817.webp]] <table> <thead> <tr> <th style="text-align: center;">Activity</th> <th style="text-align: center;">Description</th> <th style="text-align: center;">Duration</th> <th style="text-align: center;">Percentage</th> <th style="text-align: center;">Category</th> </tr> </thead> <tbody> <tr> <td style="vertical-align: middle;">✏️ Admin Chores</td> <td style="vertical-align: middle;">includes work preparation & organizing</td> <td style="vertical-align: middle; text-align: center;">04:42</td> <td style="vertical-align: middle; text-align: center;">19%</td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🌙 Sleep</td> <td style="vertical-align: middle;">preferred from 10 to 5</td> <td style="vertical-align: middle; text-align: center;">04:23</td> <td style="vertical-align: middle; text-align: center;">18%</td> <td style="vertical-align: middle;">Sleep</td> </tr> <tr> <td style="vertical-align: middle;">🛏️ Nap</td> <td style="vertical-align: middle;">afternoon preferred</td> <td style="vertical-align: middle; text-align: center;">03:24</td> <td style="vertical-align: middle; text-align: center;">14%</td> <td style="vertical-align: middle;">Sleep</td> </tr> <tr> <td style="vertical-align: middle;">📘 Vďibňík</td> <td style="vertical-align: middle;">Grail Diary entries or review</td> <td style="vertical-align: middle; text-align: center;">03:01</td> <td style="vertical-align: middle; text-align: center;">12%</td> <td style="vertical-align: middle;">Štúdium</td> </tr> <tr> <td style="vertical-align: middle;">🏗️ Prosto Intense</td> <td style="vertical-align: middle;">money-making projects with strict deadlihes</td> <td style="vertical-align: middle; text-align: center;">02:55</td> <td style="vertical-align: middle; text-align: center;">12%</td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">✉️ Online Comm</td> <td style="vertical-align: middle;">all types of it</td> <td style="vertical-align: middle; text-align: center;">02:00</td> <td style="vertical-align: middle; text-align: center;">8%</td> <td style="vertical-align: middle;">Altruism</td> </tr> <tr> <td style="vertical-align: middle;">🌞 Chores Morning</td> <td style="vertical-align: middle;">miscellanea at home & outside</td> <td style="vertical-align: middle; text-align: center;">01:43</td> <td style="vertical-align: middle; text-align: center;">7%</td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">🍴 Krmivo</td> <td style="vertical-align: middle;">mealtimes</td> <td style="vertical-align: middle; text-align: center;">01:09</td> <td style="vertical-align: middle; text-align: center;">5%</td> <td style="vertical-align: middle;">Chores</td> </tr> <tr> <td style="vertical-align: middle;">🌐 News</td> <td style="vertical-align: middle;">newspaper proofreading night shift</td> <td style="vertical-align: middle; text-align: center;">01:08</td> <td style="vertical-align: middle; text-align: center;">5%</td> <td style="vertical-align: middle;">Robota</td> </tr> <tr> <td style="vertical-align: middle;">🛋️ Chores Evening</td> <td style="vertical-align: middle;">miscellanea at home & outside</td> <td style="vertical-align: middle; text-align: center;">00:15</td> <td style="vertical-align: middle; text-align: center;">1%</td> <td style="vertical-align: middle;">Chores</td> </tr> </tbody> </table> ![[Kolacapka-categories-20260817.webp]] <table> <thead> <tr> <th style="text-align: center;">Category</th> <th style="text-align: center;">Duration</th> <th style="text-align: center;">Percentage</th> </tr> </thead> <tbody> <tr> <td style="vertical-align: middle;">Robota</td> <td style="vertical-align: middle; text-align: center;">08:45</td> <td style="vertical-align: middle; text-align: center;">35%</td> </tr> <tr> <td style="vertical-align: middle;">Sleep</td> <td style="vertical-align: middle; text-align: center;">07:47</td> <td style="vertical-align: middle; text-align: center;">31%</td> </tr> <tr> <td style="vertical-align: middle;">Chores</td> <td style="vertical-align: middle; text-align: center;">03:07</td> <td style="vertical-align: middle; text-align: center;">13%</td> </tr> <tr> <td style="vertical-align: middle;">Štúdium</td> <td style="vertical-align: middle; text-align: center;">03:01</td> <td style="vertical-align: middle; text-align: center;">12%</td> </tr> <tr> <td style="vertical-align: middle;">Altruism</td> <td style="vertical-align: middle; text-align: center;">02:00</td> <td style="vertical-align: middle; text-align: center;">8%</td> </tr> </tbody> </table> # Instruction Manuals # ATracker CSV → HTML Table — Minimal Conversion Guide **Version 3.1** ## Purpose Convert **one** semicolon-delimited CSV export from ATracker into a self-contained HTML table for Obsidian. This version covers only the **Detailed Activities** table. --- ## Input CSV ``` Task name; Task description; Start time; End time; Duration; Duration in hours; Note; Tag ``` --- ## General Output Rules - Reply with **only** the HTML table. - Do **not** wrap the HTML in triple backticks. - Do **not** add greetings, explanations, or commentary. - Escape ampersands: `&` → `&` - Delete the `Duration in hours` column entirely. - Truncate all seconds in Start, End, and Duration values. Example: `06:08:17` → `06:08` --- ## Header Transformation Rename headers as follows: | Original CSV Header | Final Table Header | |---|---| | `Task name` | `Activity` | | `Task description` | `Description` | | `Start time` | `Start` | | `End time` | `End` | | `Duration` | `Duration` | | `Note` | `Note` | | `Tag` | `Category` | --- ## Header Alignment All **seven** table headers must be **center-aligned**. Example: ```html <th style="text-align: center;">Activity</th> ``` --- ## Output Structure ```html <table> <thead> <tr> <th style="text-align: center;">Activity</th> <th style="text-align: center;">Description</th> <th style="text-align: center;">Start</th> <th style="text-align: center;">End</th> <th style="text-align: center;">Duration</th> <th style="text-align: center;">Note</th> <th style="text-align: center;">Category</th> </tr> </thead> <tbody> ... </tbody> </table> ``` --- ## Date Handling - Identify the **most frequently occurring date** in the Start and End columns. - For rows whose date is the most frequent date: **Do not show any day name.** Example: `17 Aug 2026 at 05:35:00` → `05:35` - For rows whose date is **not** the most frequent date: Prefix the time with the full English weekday name. Example: `18 Aug 2026 at 00:35:37` → `Tuesday at 00:35` - Always truncate seconds, including in the Duration column. --- ## Row Formatting ### Alignment Rules | Columns | Alignment | |---|---| | 1 — Activity | Left | | 2 — Description | Left | | 3 — Start | Center | | 4 — End | Center | | 5 — Duration | Center | | 6 — Note | Center | | 7 — Category | Left | ### Cell Formatting | Column | Format | |---|---| | Activity | `{icon} {name}` wrapped in `{icon} {name}` | | Description | `{description}` | | Start | `{start}` | | End | `{end}` | | Duration | `{duration}` | | Note | If empty: empty `<td>`. Otherwise: `{note}` | | Category | `{category}` | ### `<td>` Styles For left-aligned columns: ```html <td style="vertical-align: middle;">...</td> ``` For center-aligned columns: ```html <td style="vertical-align: middle; text-align: center;">...</td> ``` --- ## Activity Color Key | Icon + Activity | Color | |---|---| | 📘 Vďibňík | `rgb(179, 136, 255)` | | ✉️ Online Comm | `#00b050` | | 🎯 Pohib | `#5aa2cd` | | 🛏️ Nap | `#ba6e17` | | 🌙 Sleep | `rgb(165, 105, 60)` | | 🍴 Krmivo | `#d4b585` | | 🌴 Umeňie | `rgb(200, 60, 70)` | | 🐘 Veda | `rgb(90, 130, 180)` | | 💬 Foreign Language | `#fa4b5e` | | 🌞 Chores Morning | `#faaa4b` | | 🍽️ Chores Noon | `#f8941e` | | 🛋️ Chores Evening | `#b18756` | | ✏️ Admin Chores | `#8b8b8b` | | ⚒️ Robota Local | `rgb(120, 120, 120)` | | 🌐 News | `#b0a4c0` | | 💼 Robota Terén | `rgb(100, 100, 100)` | | 🏗️ Prosto Intense | `rgb(140, 110, 85)` | | 🎨 Tvorba | `rgb(200, 100, 200)` | | 🏛️ Breakfast Cycle | `rgb(255, 150, 150)` | | 🛕 Cycle Morning | `rgb(240, 100, 110)` | | 🏫 Lunch Cycle | `rgb(220, 80, 90)` | | 🏰 Cycle Noon | `rgb(190, 60, 75)` | | 🕊️ Dinner Cycle | `rgb(160, 45, 60)` | | 🕯️ Cycle Bedtime | `rgb(140, 40, 55)` | | 🍳 Admin Half-Hour | `#d6619b` | | 🏀 Games | `#8c51a1` | | 🧹 Clean-up | `#62dbe4` | | 💚 Robota Altruistic | `rgb(90, 140, 100)` | | 📞 Telefonát | `rgb(70, 150, 90)` | | ☯️ Real Life | `rgb(0, 150, 120)` | --- ## Category Color Key | Category | Color | |---|---| | Štúdium | `#c00000` | | Sleep | `#ff8c00` | | Chores | `#808080` | | Robota | `#d2b48c` | | Altruism | `#00b050` | --- ## Example Rows ### Regular row — no weekday shown, no seconds ```html <tr> <td style="vertical-align: middle;">✉️ Online Comm</td> <td style="vertical-align: middle;">all types of it</td> <td style="vertical-align: middle; text-align: center;">05:35</td> <td style="vertical-align: middle; text-align: center;">05:50</td> <td style="vertical-align: middle; text-align: center;">00:15</td> <td style="vertical-align: middle; text-align: center;">nom</td> <td style="vertical-align: middle;">Altruism</td> </tr> ``` ### Anomaly row — weekday shown, no seconds ```html <tr> <td style="vertical-align: middle;">🌐 News</td> <td style="vertical-align: middle;">newspaper proofreading night shift</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 00:35</td> <td style="vertical-align: middle; text-align: center;">Tuesday at 00:53</td> <td style="vertical-align: middle; text-align: center;">00:18</td> <td style="vertical-align: middle; text-align: center;"></td> <td style="vertical-align: middle;">Robota</td> </tr> ``` *** *** *** # Conversion Manual: Daily Activity Post-Processing ## What this workflow does You receive an HTML table containing a chronological list of activities from one operational day. You must produce: 1. A callout warning about ATracker’s 24-hour piechart limitation. 2. An embedded image placeholder for the activity piechart. 3. An aggregated **Activity Summary Table** in HTML. 4. An embedded image placeholder for the category piechart. 5. An aggregated **Category Summary Table** in HTML. The output must not include any commentary, headings, or triple backticks. Only the content described below. --- ## Input format The input is an HTML table with **seven columns**: | Activity | Description | Start | End | Duration | Note | Category | |---|---|---|---|---|---|---| | ... | ... | ... | ... | ... | ... | ... | - Times are in `HH:MM` format, no seconds. - Some Start/End values may include day labels such as `Monday at 01:12` or `Tuesday at 00:35`. - Activities may repeat multiple times. - Categories are one of: Robota, Sleep, Štúdium, Chores, Altruism (possibly fewer on some days). --- ## Processing rules ### 1. Calculate total operational-day duration - Find the earliest `Start` time and the latest `End` time in the input. - Respect day rollovers. Example: if the day starts at `Monday at 01:12` and ends at `Tuesday at 01:54`, the total span is **24 hours 42 minutes**. - This total span is the **denominator for all percentages**. - Do not use 24:00 as a fixed denominator. ### 2. Build the Activity Summary Table **Aggregation:** - Group rows by the exact `Activity` text, including emoji and wording. - Sum the `Duration` column for each activity. - Use the `Description` from the first occurrence of each activity. - Use the `Category` from the first occurrence of each activity. **Sorting:** - Sort the aggregated activities by total duration, **longest first**. - If two durations are equal, keep the activity that appeared first in the original input. **Percentage calculation:** - For each activity: ``` percentage = (activity_total_duration / total_operational_day_duration) × 100 ``` - Round to the nearest whole percentage using standard rounding: - `0–29` seconds → round down - `30–59` seconds → round up **Output columns:** - Activity - Description - Duration - Percentage - Category **Formatting:** - All header cells: `text-align: center;` and font color `rgb(0, 176, 240)`. - Activity cell: `vertical-align: middle;` with its original colored span. - Description cell: `vertical-align: middle;` with `` text. - Duration cell: `vertical-align: middle; text-align: center;` with pink font `rgb(200, 0, 255)`. - Percentage cell: `vertical-align: middle; text-align: center;` with white font `rgb(255, 255, 255)`. - Category cell: `vertical-align: middle;` with its original colored span. - Do not include Start, End, or Note columns in the output. ### 3. Build the Category Summary Table **Aggregation:** - Group rows by the `Category` text. - Sum the `Duration` column for each category. **Sorting:** - Sort by total duration, **longest first**. **Percentage calculation:** - Same as for activities: ``` percentage = (category_total_duration / total_operational_day_duration) × 100 ``` - Round to the nearest whole percentage. **Output columns:** - Category - Duration - Percentage **Formatting:** - All header cells: `text-align: center;` and font color `rgb(0, 176, 240)`. - Category cell: `vertical-align: middle;` with its original colored span. - Duration cell: `vertical-align: middle; text-align: center;` with pink font `rgb(200, 0, 255)`. - Percentage cell: `vertical-align: middle; text-align: center;` with white font `rgb(255, 255, 255)`. --- ## Output template The final output must follow this exact structure, with no additional text: > [!warning] Operational-day limitation > Unfortunately, ATracker forces every piechart report into a fixed 24-hour window. My operational days instead (as can be seen above) begin and end at manually chosen boundaries and may last less or more than 24 hours. The two piechart reports below therefore represent ATracker’s imposed artificial reporting window of exactly 24 hours from 10 p.m. to 10 p.m., but unlike the datatables, the piecharts do not accurately represent my lived day. ![[Kolacapka-202xxxxx.jpg]] `{Activity Summary Table HTML}` ![[Kolacapka-categories-202xxxxx.jpg]] `{Category Summary Table HTML}` - The image filenames contain `202xxxxx`. Keep the `202` and replace only the five `x` characters with the actual date when known. When unknown, leave as `xxxxx`. - Do not add triple backticks around the HTML tables. - Do not add any heading such as “Length of Day”. --- ## Important reminders - No seconds anywhere. - No extra commentary in the final output. - No fixed 24-hour assumption for percentages. - Percentages may add up to 99% or 101% due to rounding; this is fine. - Use the actual time span from earliest Start to latest End for all percentage calculations. *** #### Earlier Versions of This Page ➡️ [[Daily Koláčapka Report Example (for Saturday, 15 August 2026)]] ➡️ [[ATracker Tasks and Categories Color Shades and Icons for Obsidian]]