The Settlement Numbers App

I’ve always felt that Numbers (particularly on the iPad) is its very own sort-of developer platform. I’ve talked in the past about how I use custom spreadsheets to get things done. In the next Mac Power Users episode, airing Monday, I committed to sharing one of my Numbers “apps”. I know this post crosses the streams a bit into the legal end of my life but here is one I use all the time. It’s my settlement conference spreadsheet.

Sitting in a settlement conference with a client involves a lot of psychology. They are are getting sued (or doing the suing). In all likelihood, next to a life threatening illness, this is the most stressful event of their life. Moreover, quite often they are really angry at the other guy and here we are talking about peace in the middle of a war.

It is really difficult for anyone to think logically under these circumstances. Besides, the mediation process always has this false kumbaya vibe that doesn’t work for anyone.

When subjecting my client to all of this nonsense, I want to do everything I can to empower them, at least a little bit. They are in control, and they need to be reminded of the fact.

Technology to the rescue. The settlement spreadsheet is a series of sheets on iPad Numbers designed to objectively analyze a case and track the process of settlement.

The first thing I do is quantify exactly what it costs the client to go forward from that day. How much will it cost in attorney fees, jury fees, reporter fees, expert witnesses, and other costs from that moment until the verdict? I break this down by issue so if we settle a small piece of the case, we can adjust the math. I also put a value on the client’s time. If you are in business, how much money do you lose attending depositions and following me around the courthouse for two weeks? We build this calculation, brick by brick, together.


By the end, the client understands that a $10,000 offer today may have the same value to him as a $20,000 verdict in six months.

Next I apply some science. I’m not talking about the way Dr. Drang can dissect a stress fracture on a lawnower bolt. What I do is much more crude. I’d almost say it is just a level above spitballing but at least it provides some structure to the conversation and removes some of the emotion. I talk about the case honestly and we jointly come to estimates for a Big Win, a Normal Win, and a Loss at trial.

For each of those options we estimate what the percentage likelihood of the outcome is and what the award would be in that event. Then we do a simple calculation.

Chance x Verdict

So if there is a 20% chance of winning big for $100,000, that line has a value of $20,000.
I repeat this for each scenario: Win Big, Normal Win, Lose.


Then I add the numbers up. This gives us a ballpark. Sometimes, depending on the case, I also back out the go forward costs for a more realistic settlement number. There is an excellent argument to be made that this is not science at all but GIGO, garbage in, garbage out. However, I find that with cases that go to trial, my crude methodology is usually pretty close to the jury verdict. Either way, this stuff sure ain’t rocket science.

I also have a sheet that tracks offers and counter-offers throughout the day.

For years I ran this spreadsheet on a laptop. That worked fine but the client was always a bit detached from the spreadsheet sitting over on the attorney’s Mac. When the iPad arrived, I converted the sheet to be iPad friendly and started handing it to the client at the beginning of the mediation. What a huge difference this makes. Instead of fretting, my clients spend the day working through the numbers so they can make intelligent decisions. I empower them.

I’m certain there are a group of attorneys reading this right now who think I am completely unhinged, but this works for me and my clients. It has worked for years. It adds some context to settlement valuation and is much better than the blind dart-throwing I so often witness from opposing counsel. If you are interested, you can download the Sparkomatic Settlement Machine.

Download for Numbers

2012-07-26  – Follow Up

Since posting this, I’ve heard from many very sad lawyers that don’t have Macs or iPads. Shame on you. Here is an Excel version that isn’t very pretty but still gets the job done.

Download for Excel

RSS Sponsor: Text Expander

Many thanks to Smile, one of the very best Mac and iOS developers, for sponsoring the RSS feed this week.

The new TextExpander 4 from Smile dramatically increases the options for automating your work with advanced “fill-in” snippet types. They are great for creating form letter templates that can be personalized on the fly. Check out the video demo and see the new multi-line text fields, multiple choice popups, and optional text blocks in action.

Registered TextExpander users can upgrade for $15. (There’s no charge for the upgrade if you purchased after January 15, 2012.)

Still haven’t tried TextExpander? Download the free demo! There’s even a new Snippet Creation Snippet to get you started.

Sponsorship by The Syndicate

Capturing the Rest: The 7 Inch iPad

There’s a lot of talk lately about an upcoming 7 inch iPad from Apple. I think the pundits are having a hard time wrapping their minds around this because it doesn’t seem to have a place in the Apple product family. After all, Apple makes small phones and large tablets. They don’t make large phones and small tablets. I think the point is that the pundits are not the target audience for this device. If Apple were to make the 7 inch iPad – I think they will – it would be primarily for those people not willing to plunk down $500 for an iPad. There are a lot of those people and right now their only option is a competing operating system. Don’t you think a company so willing to jump into the meat grinder of patent litigation with its competitors to keep them out of the marketplace would also release a product that could be so much more effective at capturing market and mindshare?

I think a 7 inch iPad in the $250 price range, along with the app store and all the other great things that Apple has built, would be devastating to competing tablet manufacturers. Apple employed a similar strategy in the iPod market and the rest of the MP3 player market never recovered. I don’t know whether Apple calls it the next generation iPod touch or the iPad Mini but the result would be the same either way, a lot of units sold to customers that would otherwise have gone to Amazon, Samsung, and others.

Scanner Pro 4.1

In the running battle for iOS scanning supremacy, today Readdle released Scanner Pro 4.1. The interface overhaul is now complete and I like it. The grid lines in camera mode help me square the document and it runs its very own stability check when you snap the picture. Moreover, it now syncs everything between your devices with iCloud. With this update (along with the recent iPad optimized version), Scanner Pro has officially replaced JotNot in my life.