OOo Spreadsheet for Canadian Payroll Tax

[Michael D. Crawford]

I wrote:

> Another thing I'd like to know is if there is some way I can calculate a
> cell's address on the fly rather than hardwiring it.  That way I can key
> the TD1 exemptions and even the provincial calculations by employee
> number rather than hardwiring them by employee name as I do now. 

A little more poking around in OpenOffice's help turned up the 
appropriately named INDEX function:

INDEX(reference;row;column;range)

     A       B
     ----------
1 | 1       4
2 | 2       =INDEX(A1:A4;B1)
3 | 3	
4 | 4	

The above spreadsheet will result in the value "4" being displayed in 
cell B2.  Changing B1 to be any value from 1 to 4 will result in the 
same value being displayed in B2.  Entering 5 will result in "Err:504" 
being displayed.

One can assign a name to a range by selecting its cells and then 
selecting Define Range from the Data menu.  Data->Select Range will 
select a range by name.

I'm kind of enjoying finally getting around to getting a clue about 
spreadsheets!

Mike
-- 
Michael D. Crawford
GoingWare Inc. - Expert Software Development and Consulting
http://www.goingware.com
crawford at goingware.com

   Tilting at Windmills for a Better Tomorrow.

     "I give you this one rule of conduct. Do what you will, but speak
      out always. Be shunned, be hated, be ridiculed, be scared,
      be in doubt, but don't be gagged."
      -- John J. Chapman, "Make a Bonfire of Your Reputations"
         http://www.goingware.com/reputation/