|||

PTPL 085 · CalcCraft is the Obsidian Tables Plugin I Was Looking For!

Plus a wannabe replacement for the infamous Comic Sans

Did you know there’s a plugin for doing simple calculations in Markdown tables in Obsidian? And that there’s a serious contender for replacing Comic Sans?


Replacing Comic Sans, at last

Here’s a 22 minute video about the infamous Comic Sans. It’s a good history of how it became one of the most used and most hated fonts of all time.

If you’re scratching your head at what font choices have to do with productivity, try changing your notes app font to 8 point Alumni Sans Collegiate, and see how you get along!

Fonts are all about dressing your words in clothing that suits the occasion. You’re not going to wear a ball gown or tux to a football game (especially not if you’re playing), and a baggy t-shirt isn’t going to cut it for a night at the opera (especially if you’re singing).

Fonts are all about dressing your words in clothing that suits the occasion

Font choices absolutely affect my productivity.

You may enjoy the experience of seeing a handwritten-style font as the interface for your phone (Android allows this), while for me this would be akin to rubbing velvet up the wrong way or scratching my nails on a chalkboard every time I used the device.

Simplified formulas in Markdown tables!

A couple of weeks ago I wrote about my attempts to write simple formulas for my Markdown tables, to make tracking finances easier. Stowe Boyd kindly let me know in the comments about an Obsidian plugin I’d never heard of — CalcCraft. I’m pretty chuffed to have found it! Thanks, Stowe.

The documentation for this plugin gave me just enough information to be able to work out the formulas for what I’ve been wanting to do in my Markdown expense trackers: calculate the sum of a column of figures, and calculate the account balance after adding the Deposit and subtracting the Withdrawal from the previous row’s Balance.

I’m well aware it’d be easier in many ways to use a spreadsheet, but I’m far too comfortable with my Markdown-flavoured plain text life to want to give that up! Especially now that Obsidian Sync makes all the information quickly and reliably available on my phone.

CalcCraft adds numbers (1, 2, 3…) to rows, and letters (a, b, c…) to columns, so that formulas have a reference point.

These are the two formulas I’m using, which I’ve made into snippets in Keyboard Maestro for quick access:

=sum(+0c2:+0c-1r) 
Calculate the sum of all figures in the current row, from one row below the header to the row above the cell in which the formula lives

=(-0c-1r)+(-1c+0r)-(-2c+0r) 
Calculate the new balance by adding anything in the Deposit column, and subtracting anything in the Withdrawal column, all on the same row

Note that these formulas are relative. They refer to the first or second column from the column in which the formula sits, rather than specific table coordinates. In the Balance column below, you need to enter the balance figure once, on the first row. As expected, the formula takes care of the rest.


| Date | Transaction | Withdrawal | Deposit |                     Balance |  
|:----:| ----------- | ----------:| -------:| ---------------------------:|  
|  13  | 446.00      |            |   14.00 |                       14.00 |  
|  13  | 446.00      |       4.00 |         | =(-0c-1r)+(-1c+0r)-(-2c+0r) |  
|  13  | Stripe      |            |    3.07 | =(-0c-1r)+(-1c+0r)-(-2c+0r) |

The plugin’s documentation explains this and other, far more complicated formulas, in more detail. Check it out.


See also this warning about the CalcCraft plugin


Follow my RSS feed, or sign up to receive posts in your inbox

Up next PTPL 084: Getting Ready For 2024 With Nothing But Folders and Plain Text PTPL 086 · 4 Tough Questions For a Plain Text Advocate
Latest posts PTPL 129 · Live Out of Your Notes the Way Tom Lives Out of His Car Inktober 2024 PTPL 128 · Keep Your Content Separate From the Container in Which It Lives PTPL 127 · On Backing Up Paper, and Static Websites for Tiny Archives Efficient App Agnostic Tasks in a Single Plain Text File (Obsidian Optional) PTPL 126 · What the Dash-Plus System Looks Like in My OBTF and Analog Notes Word Puzzles (that aren’t Wordle) PTPL 125 · Choosing Between Digital and Analog, and a Plain Text Accounting Update How to Keep Your Wheels Turning Smoothly Despite the Automation Paradox PTPL 124 · Saving Safari tabs as Markdown links, and Mono Fonts in Obsidian Looking Through Windows (From the Outside In) PTPL 123 · ‘Analog Office’ Blog and Tomoe River Planner Recommendations Mastodon and the Fediverse — Social Media’s Brighter Future Celebrating Independent Indie Blogs PTPL 122 · Aligning Your Task List with Your (Changing) Values PTPL 121 · Getting Focused With a 4-Quadrant Weekly Planning Matrix PTPL 120 · Quick Add vs Text Expansion in Obsidian Touch Typing For Classic Book Fans Your Name in Landsat Psst — They Don't Know What You're Talking About PTPL 119 · Yes, You Can Be Plain-Text Enlightened and Still Use Apple’s Reminders! PTPL 118 · My Simple, Sensible Plain Text to Proprietary App Workflow PTPL 117 · Oh, You Like Making Notes! Why Not Use… ? PTPL 116 · Plain Text Accounting Level 1, Complete! PTPL 115 · There’s Something New at the Top of My One Big Text File PTPL 114 · Obsidian, Silver Bullet, and Org-Mode—3 Different Approaches to Working With Notes PTPL 113 · Some Free Tools Cost Too Much PTPL 112 · Organise Your Stuff— Alternatives to Bartender and Hazel PTPL 111 · You Only Need 2 Calendar Categories For Effective Time Management PTPL 110 · How to Easily Type  macOS ⌘ Modifier Keys PTPL 109 · Households With Written SOPs Are More Resilient Than Those Without
... ... ... ...