Skip to main content

Property Settlement Calculator

To aid division of assets under Australian Family Law.

There are many resources to aid understanding of the property division/settlement process, the SA Law Handbook comes to mind, but few help with the calculations or how they map onto various elements in the court forms.

As a result, parties risk negotiating without a clear idea of the assets in play, or how the division can be achieved. Closer to finalisation, the draft orders may be difficult to understand. After finalisation a poorly communicated division may lead parties to convince themselves that it was unfair. 

So here's a Google Sheet: Family Law - Property Division Calculator (AU) 

... to help people reconceptualize the negotiations.

It is, of course, free and you don't need to create a login (unlike some other online aids.)

Save your own copy if you want to play around with it, as it is read-only.

Previous versions let you edit online. That's how I realised that it was actually (sadly) more popular than I'd expected.

FYI, I am not getting, nor have I ever been, divorced.

Divorce and me go way back, though.

Thirty-plus years later, my parents still complain about how the other one shafted them in the split. They don't talk about neglect or abuse, thank goodness, but pigheadedness and greed. It's all about the money.

"I made her a millionaire." (yeah well, that kinda means you're a millionaire too.) 

"I capitulated and he took most of the assets." (... that you remember declaring.)

They don't have the docs to back up their side of the story so I grew up thinking that divorce meant that a random amount greater than 50% of your stuff went up in flames.

After practising law for a bit and reading orders, I have to say that the format - where numbers seem to materialise out of nowhere - don't help transparency. I think this is because orders must be expressed in linear, one-dimensional natural language.

Comp. Sci. (my second profession) to the rescue! Division is actually really easy to model two-dimensionally.

With spreadsheet functions, it's also possible to make sure everything adds up. It's also easy to see how to execute splits with least disruption. There may be no need to sell houses or pets. Best case scenario: it's a bank transfer.

Then you can get on with the rest of your life. 

I wish you both the best of luck.


Comments

Popular posts from this blog

Transcode to PSP using Handbrake

Source: Handbrake 0.9.9.5530 64-bit edition Target: (Phat) Playstation Portable PSP-1000 , System Software: 6.60 Many internet articles on how to transcode video to PSP using Handbrake have not worked for me. Even the most helpful are incomplete. I hope this post will help fill in the blanks. There is no longer any PSP preset for Handbrake, but from what I can gather, the preset had only limited success as the x264 encoder would change syntax and settings between versions. Other presets that may have worked before, like 'iPod' and 'Apple-Universal' now do not. Here is what worked for me, step by step:

Firefox History Statistics - Extracting from Places.sqlite

If you want to take a look at Firefox surfing activity, the about:me add-on is a good start. However, it presents only one view of data and is thus limited in its ability to present more detailed statistics. We will view that data in a different program. So let's first extract it from the browsing history stored in the Places.sqlite file into a CSV file using a Firefox add-on. Step 1 - Locate and copy Places.sqlite to a working location On Windows machines, Places.sqlite is found in a directory similar to: C:\Users\User1\AppData\Roaming\Mozilla\Firefox\Profiles\ .default\places.sqlite Copy the file to another location. The database will be locked while using Firefox, and the SQLite plugin we will use to open it.

Bloomberg JSON data into Libreoffice Calc

LibreOffice Calc has no inbuilt stock market functions, and a popular plugin which offered those has stopped working along with changes to Yahoo Finance. Luckily, we can get the latest quotes from Bloomberg. [2018-12-15] Bloomberg Finance is, understandably, blocking multiple simultaneous requests. A more flexible solution is using a Python Stock Scraper .