[RESOLVED] Seemingly complex pattern.

I have observed a pattern, but cannot figure out a formula to determine X over Y steps.

See the images for the visualised pattern (cubes.gif), and how to create it in a spreadsheet(SS.gif).

I could also post some VB code that'd ouput the sequence, but im tired (3AM).

The formula in this code gives that pattern. Note the integer division.

VB Code:

Dim n As Long
 
For n = 1 To 10
  Debug.Print (n \ 3 + 1) ^ 2 * (n \ 3 + n Mod 3)
Next n

Also,
It looks like you can break it up into 2 controlling variables, with this formula:


Z = X³ + X²Y + XY(Y-1)/2

Yeah thanks guys, id just point out that your use of brackets is bad logophobic. Mightve worked in vb but not excel.

(((n \ 3) + 1) ^ 2) * ((n \ 3) + (n Mod 3))