Extremely easy question about Time to check table look-ups



I am not sure about this, because making a table like this sounds
really stupid
i create a simple 100x100 table called A, with "switch" statements
***
switch(something){
switch(someotherthing){
switch(otherthng){
....}
....}
.....}
***
something really long like that till 100x100 cells are neatly
organized. But each of those cells when processed, again link to
another 100x100 table called B which i also create with "switch"
statements.
if I do a search in that table, I guess (a) my time complexity is O(1),
correct ? (b) I will know there will be other ways to make a table that
would save more memory if you are willing to tell me.Thanks

.



Relevant Pages

  • Re: Cells not updating
    ... | - calcs are set to auto and I have hit F9 a million times when i switch to ... | iterations, also there is no circularity). ... | When I save the file as a new version, the cells all update. ...
    (microsoft.public.excel.misc)
  • RE: Screen Refresh Problem
    ... Can catch you off guard if you don't switch between sheets to ... I am having very annoying screen refresh issues that occur in Excel: ... Scrolling to fix my problem ... The problem seems to be that only the the cells in the upper left corner are ...
    (microsoft.public.excel.crashesgpfs)
  • Re: Cells not updating
    ... | - calcs are set to auto and I have hit F9 a million times when i switch to ... | iterations, also there is no circularity). ... | When I save the file as a new version, the cells all update. ...
    (microsoft.public.excel.misc)
  • Re: Cells not updating
    ... | - calcs are set to auto and I have hit F9 a million times when i switch to ... | iterations, also there is no circularity). ... | When I save the file as a new version, the cells all update. ...
    (microsoft.public.excel.misc)
  • Re: Cells not updating
    ... - calcs are set to auto and I have hit F9 a million times when i switch to ... iterations, also there is no circularity). ... When I save the file as a new version, the cells all update. ...
    (microsoft.public.excel.misc)