Feeds

OpenOffice 3.0 - the only option for masochistic Linux users

And linear optimizing Mactards

Security for virtualized datacentres

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.

Website security in corporate America

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
'People have forgotten just how late the first iPhone arrived ...'
Plus: 'Google's IDEALISM is an injudicious justification for inappropriate biz practices'
Mathematica hits the Web
Wolfram embraces the cloud, promies private cloud cut of its number-cruncher
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
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
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.
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?
The next step in data security
With recent increased privacy concerns and computers becoming more powerful, the chance of hackers being able to crack smaller-sized RSA keys increases.