Two Plus Two Older Archives  

Go Back   Two Plus Two Older Archives > Other Topics > Science, Math, and Philosophy
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-27-2005, 04:51 PM
TomCollins TomCollins is offline
Senior Member
 
Join Date: Jul 2003
Location: Austin, TX
Posts: 172
Default Excel Deleting Problem

Suppose you have a block of cell's in a "triangle" you want to "delete". You can delete them by selecting a rectangle.

For example:

Here is a triangle of length 6.

XOOOOO
XXOOOO
XXXOOO
XXXXOO
XXXXXO
XXXXXX

And you want to delete the X's.

OOOOO
OOOO
OOO
OO
O



So one deletion could be:
OOOOO
XOOOO
XXOOO
XXXOO
XXXXO
XXXXX, since I can delete a rectangle of cells in the first column. I can delete multiple rows and columns, but must delete an entire rectangle.

So the question:
For a triangle of size n, what is the least number of deletions to get rid of all of the X's?

What is the algorithm for it?

This question may be interesting or extremely trivial, and I don't know the answer either.
Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.