A place to discuss Joel on Software. Now closed.
This community works best when people use their real names. Please register for a free account.
Joel on Software
Business of Software
Design of Software (CLOSED)
.NET Questions (CLOSED)
Fog Creek Copilot
The Old Forum
Albert D. Kallal
I just finished joel's nice article about Painless schedule and wanna to create a template like that. I have tree columns called: Current Estimate, Elapsed, Remain and it is obvious that Remain = Curr. Est - Elaps.
So my questions is that how could I declare this formula in Excell or OpenOffice SpreadSheet to automatically perform the operation whenever I insert data into Curr. Est and Elaps?
- Type the formular =a1+b1 in cell c1.
- Click on c1 so that the cursor is on it.
- Press Ctrl-C to copy the cell.
- Now mark all cells c2-cx with the mouse (click on the first and drag down with pressed button).
- Press Ctrl-V to insert the formular into all the marked cells. Indices will be changed automatically.
You could mark the complete column c, but I doubt you will need THAT much rows...
Personally, I hate those "Click here, click tha, click tralalah" descriptions, because they don't answer the "Why, and what I'm actually doing there with what unexpected side-effects?" questions. First learn and understand the tools that you wish to use for your productive work -- else you will be in serious trouble when something important suddenly doesn't work anymore.
Saturday, July 22, 2006
To my mind, this discussion highlights some of the more deep seated problems with Excel (and all traditional spredsheets):
* There is no obvious way of creating column or row level formulae.
* Formatting data cannot be easily altered in the cell (sorry, a "conditional formatting dialog box" doesn't cut it).
* Very poor integration between the macro and the formulae languages.
* =if(if(if(etc...) is incredibly ugly, and hard to debug.
I wish there was a modern version of Lotus Improv!
Saturday, July 22, 2006
"To my mind, this discussion highlights some of the more deep seated problems with Excel (and all traditional spredsheets):"
You might like Excel 2007 then. It lets you use column names in formulas. So in the example from this thread, in the first empty cell under the "Remain" column, you'd enter:
=[Current Estimate] - [Elapsed]
Excel automatically applies this to the full column -- no need for the user to expand the formula to other cells manually.
The conditional formatting features have also been improved considerably. It seems like one of their design goals for Excel 2007 was to eliminate a lot of the cases where you had to drop to VBA in prior versions to do fancier conditional formatting.
And I've seen some examples of new error handling features that should cut down on some of the need for "=if(if(if(" though I haven't played around with this yet.
I've been playing around with the beta for a week or two and older versions of Excel just feel dated and clunky to me now. Strangely, the one thing that I don't like so far is the ribbon.
This topic is archived. No further replies will be accepted.Other recent topics
Powered by FogBugz