Feeds

OpenOffice 3.0 - the only option for masochistic Linux users

And linear optimizing Mactards

The next step in data security

The Feasible Region in my Loins

Shinyness aside, OpenOffice 3 does have at least one useful new feature: The Solver. The Solver is a new tool for Calc that helps you solve linear programming problems. Excel has had this for years, so it's nice to see the open source world throw their nuts out on the table. Mac users should feel especially gifted: Not only do they now have a version of OpenOffice that can run without X11, but they finally have a spreadsheet that can do linear optimization. Microsoft Office 2008 doesn't provide this for Mac users.

Linear programming is a way to optimize an equation given a bunch of constraints. You have limited capital resources and want to maximize your profit - that sort of thing. Previously, Linux users have been using the GNU Linear Programming Kit (GLPK) to solve these problems. GLPK works well, but it's a command line interface and you need to learn a special programming language to use it.

Doing optimization in a spreadsheet is much easier on the sanity than doing it in a special programming language. In ten minutes, I set up and solved a basic linear programming problem:

My woodcarving company can make toy soldiers and toy trains. Each has an associated materials cost and labor cost. Each takes a certain amount of time in both finishing and carpentry. How many soldiers and trains do I make so that I earn the most profit?

Put the variables into Calc and write the constraints into the Solver:

OpenOffice Solver

OpenOffice Solver

It will figure out how many of each to make, and fill in the spreadsheet:

OpenOffice Spreadsheet

OpenOffice spreadsheet via Solver

With so many “financial engineers” entering the job market now, it's likely that many of them will find work in operations research. Perhaps OpenOffice's Solver will get more intense use than what a Reg reporter who took that class in college can do.

We're Still Waiting For Google Docs To Find Market Share

OpenOffice 3.0 has some good new functionality, but it hasn't changed substantially from version 2. And it's not worth the effort to manually upgrade on Linux: Wait until it hits your distribution's auto-update.

In any case, it's easy to download now. The open source echo chamber has moved on to other things. ®

Ted Dziuba is a co-founder at Milo.com You can read his regular Reg column, Fail and You, every other Monday.

Security for virtualized datacentres

More from The Register

next story
New 'Cosmos' browser surfs the net by TXT alone
No data plan? No WiFi? No worries ... except sluggish download speed
'Windows 9' LEAK: Microsoft's playing catchup with Linux
Multiple desktops and live tiles in restored Start button star in new vids
iOS 8 release: WebGL now runs everywhere. Hurrah for 3D graphics!
HTML 5's pretty neat ... when your browser supports it
Mathematica hits the Web
Wolfram embraces the cloud, promies private cloud cut of its number-cruncher
Google extends app refund window to two hours
You now have 120 minutes to finish that game instead of 15
Mozilla shutters Labs, tells nobody it's been dead for five months
Staffer's blog reveals all as projects languish on GitHub
SUSE Linux owner Attachmate gobbled by Micro Focus for $2.3bn
Merger will lead to mainframe and COBOL powerhouse
iOS 8 Healthkit gets a bug SO Apple KILLS it. That's real healthcare!
Not fit for purpose on day of launch, says Cupertino
Profitless Twitter: We're looking to raise $1.5... yes, billion
We'll spend the dosh on transactions, biz stuff 'n' sh*t
prev story

Whitepapers

Secure remote control for conventional and virtual desktops
Balancing user privacy and privileged access, in accordance with compliance frameworks and legislation. Evaluating any potential remote control choice.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Intelligent flash storage arrays
Tegile Intelligent Storage Arrays with IntelliFlash helps IT boost storage utilization and effciency while delivering unmatched storage savings and performance.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Beginner's guide to SSL certificates
De-mystify the technology involved and give you the information you need to make the best decision when considering your online security options.