Re: Covering rectangles in 2D



On Sat, 22 Mar 2008 02:23:43 -0000, Tim Little
<tim@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

On 2008-03-22, quasi <quasi@xxxxxxxx> wrote:
when you visit a cell, checking whether or not that cell is occupied
is not O(1).

It is O(1). I'm not checking from scratch whether a cell is occupied.
I'm checking the *difference* between coverage of it and the
preceding, neighbouring cell.

Define "preceding, neigboring cell". Presumably there is some kind of
pre-sort which determines which cell preceeds which?

Because every grid line (and hence boundary between grid cells) is
generated by a known rectangle, that is the only rectangle I need to
examine.

But as far as I can see, you need to check every cell in a row (or
column), not just the one that generated the grid lines for that row
(or column).

quasi
.



Relevant Pages

  • Re: Can I Use a Count Function for Text?
    ... I've tried countif, sumif, and sumproduct. ... preceding the rest of text in the cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can I Use a Count Function for Text?
    ... I've tried countif, sumif, and sumproduct. ... preceding the rest of text in the cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can I Use a Count Function for Text?
    ... I work in a drawing office an di need to count drawings according to their ... "David Biddulph" wrote: ... I would like a cell to be counted if a ... preceding the rest of text in the cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can I Use a Count Function for Text?
    ... "David Biddulph" wrote: ... The second column has different descriptive words (i.e. ... I would like a cell to be counted if a ... preceding the rest of text in the cell. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Can I Use a Count Function for Text?
    ... tried it again and made sure no unseen characters and it seems to work. ... "David Biddulph" wrote: ... I would like a cell to be counted if a ... preceding the rest of text in the cell. ...
    (microsoft.public.excel.worksheet.functions)