RE: Three Dimensional Array Question

These are only general comments, PCs vary with regard to both available
memory and processor speed:

1. Checking for zero in the x-loop will both add code and possibly slow the
code.
2. The same is true for dynamic allocation of memory. If your computer has
the memory, then allocate the array and don't redim.
3. I haven't gotten an array to index from a string variable, but it may
still be possible.
--
Gary's Student


"Tornados" wrote:

>
> Advice on three dimensional array (difficult?)
> (posted earlier in programming .. no reply yet)
> --------------------------------------------------------------------------------
>
> Hello, with two dimensions i seem to be able to do everything i want..
> yet when they become three, things get more complicated. Please adivce
> on the following matters:
>
> I have an array that contains two kinds of values , these values occur
> often and for each row i want the third dimension to act...so:
>
> array(0 to 999, 0 to 1, 0 to 10) ' for example 11 rows, 1000 hits and 2
> fields
>
> then everytime something changes in column A from one of the 10 rows i
> want to add this number to the array in the right dimension and
> accordingly show the average of all values that have changed in the
> column A of the specific row.
>
> 1st i would like to know what the memory wise best way is to do this...
> it could be that there are 10 changes in row 1 (dimension 1) and 4
> changes in row 2 (dimension 2).. How do i find the no of entries in the
> dimensions? if i understand correctly all dimension will have the same
> amount of elements .. so how do i get a correct average of these? I
> made it to work with two dimensions and to check which row it is yet i
> want it in 3 dimensions.
>
>
> ie:
> For x = 0 To ubound(array,1)
> SUM = SUM + array(x, 2, row)
> Next x
> ' will it be best then to check everytime whether an element has a
> value and then only add it?
>
> 2nd is it best to reserve memory in advance for an estimated amount of
> hits (999) in the example or make a dynamic one and redim each time an
> update occurs.
>
> 3rd and finally, is it only possible to refer to a dimension with a
> number or can it be text.. if for example i want to convert a text to a
> number can the array handle for example dimension 1500 when the rest is
> empty?
>
> Tx! tornado
>
>
> --
> Tornados
> ------------------------------------------------------------------------
> Tornados's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4178
> View this thread: http://www.excelforum.com/showthread.php?threadid=380406
>
>
.

Relevant Pages

  • out of memory with reasonables sizes
    ... I`m dealing with 'out of memory' problems at the moment, ... The array is allocated and filled ... call an m-file I wrote, which updates the probabilty array, I get a ... dimension or else. ...
    (comp.soft-sys.matlab)
  • Size of Largest Array?
    ... Can anybody tell me the size of the largest array I can dimension? ... I get the idea that I can only use 2 gigs of memory. ...
    (comp.lang.fortran)
  • RE: Cube process does not find dimension key
    ... this problem usually occurs because a dimension key was added ... I once saw similar issues when there are memory issues on AS server. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.olap)
  • Re: Question about 2D VB arrays
    ... "So if you want to have the same memory layout in both languages, ... more inefficient when accessing the array. ... same result (same memory layout) if you change the meaning of dimensions. ... you thought that the first dimension is a row and the second is a column, ...
    (microsoft.public.vb.general.discussion)
  • Re: Process problem
    ... for things like turning on the system-wide processing log file, ... > Maybe you have a very large dimension that fills your memory. ... > analysis-service). ...
    (microsoft.public.sqlserver.olap)