Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help needed on generating sequences
Hi all,
in a excel sheet i want to generate the following sequences for some array of numbers let us say starting from 0 and going to N-1 bits, the sequence is from the Hamming Code. For clarity reasons i want to put a formula in excel that can show me which bit is to be checked as follows: Position 1: check 1 bit, skip 1 bit, check 1 bit, skip 1 bit, etc. (1,3,5,7,9,11,13,15,...) Position 2: check 2 bits, skip 2 bits, check 2 bits, skip 2 bits, etc. (2,3,6,7,10,11,14,15,...) Position 4: check 4 bits, skip 4 bits, etc. (4,5,6,7,12,13,14,15,20,21,22,23,...) Position 8: check 8 bits, skip 8 bits, check 8 bits, skip 8 bits, etc. (8-15,24-31,40-47,...) Position 16: check 16 bits, skip 16 bits, check 16 bits, skip 16 bits, etc. (16-31,48-63,80-95,...) Position 32: check 32 bits, skip 32 bits, etc. (32-63,96-127,160-191,...)etc. how can i generate these sequences? using the position (1,2,4,8,16....) and an array from 0 - N-1, I tried with MOD but i think i messed it up. Any help would be appreciated and thanks in advance |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help needed on generating sequences
Totti,
I'm not sure how you want your information, or how you plan to use it, but, for example, put 1 2 3 4 ..... N (bit numbers) down column A, starting in A2. Then in row 1, starting in B, put 1, 2, 4, 8, 16, 32, etc. In cell B2, use the formula =MOD(INT($A2/B$1),2) and copy to match your column headers in row 1, and row labels in column A. Then the resulting table, 1s mean check, 0 means skip... HTH, Bernie MS Excel MVP "Totti" wrote in message ... Hi all, in a excel sheet i want to generate the following sequences for some array of numbers let us say starting from 0 and going to N-1 bits, the sequence is from the Hamming Code. For clarity reasons i want to put a formula in excel that can show me which bit is to be checked as follows: Position 1: check 1 bit, skip 1 bit, check 1 bit, skip 1 bit, etc. (1,3,5,7,9,11,13,15,...) Position 2: check 2 bits, skip 2 bits, check 2 bits, skip 2 bits, etc. (2,3,6,7,10,11,14,15,...) Position 4: check 4 bits, skip 4 bits, etc. (4,5,6,7,12,13,14,15,20,21,22,23,...) Position 8: check 8 bits, skip 8 bits, check 8 bits, skip 8 bits, etc. (8-15,24-31,40-47,...) Position 16: check 16 bits, skip 16 bits, check 16 bits, skip 16 bits, etc. (16-31,48-63,80-95,...) Position 32: check 32 bits, skip 32 bits, etc. (32-63,96-127,160-191,...)etc. how can i generate these sequences? using the position (1,2,4,8,16....) and an array from 0 - N-1, I tried with MOD but i think i messed it up. Any help would be appreciated and thanks in advance |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help needed on generating sequences
And if you want it in VBA, then the logic would be
Sub test() Dim Position As Variant Dim iBit As Integer Dim i As Integer Dim Check As String Position = Array(1, 2, 4, 8, 16, 32) Check = "" For i = LBound(Position) To UBound(Position) For iBit = 1 To 63 If iBit \ Position(i) Mod 2 = 1 Then Check = Check & "1" Else Check = Check & "0" End If Next iBit Check = Check & vbCrLf Next i MsgBox Check End Sub -- HTH, Bernie MS Excel MVP "Totti" wrote in message ... Hi all, in a excel sheet i want to generate the following sequences for some array of numbers let us say starting from 0 and going to N-1 bits, the sequence is from the Hamming Code. For clarity reasons i want to put a formula in excel that can show me which bit is to be checked as follows: Position 1: check 1 bit, skip 1 bit, check 1 bit, skip 1 bit, etc. (1,3,5,7,9,11,13,15,...) Position 2: check 2 bits, skip 2 bits, check 2 bits, skip 2 bits, etc. (2,3,6,7,10,11,14,15,...) Position 4: check 4 bits, skip 4 bits, etc. (4,5,6,7,12,13,14,15,20,21,22,23,...) Position 8: check 8 bits, skip 8 bits, check 8 bits, skip 8 bits, etc. (8-15,24-31,40-47,...) Position 16: check 16 bits, skip 16 bits, check 16 bits, skip 16 bits, etc. (16-31,48-63,80-95,...) Position 32: check 32 bits, skip 32 bits, etc. (32-63,96-127,160-191,...)etc. how can i generate these sequences? using the position (1,2,4,8,16....) and an array from 0 - N-1, I tried with MOD but i think i messed it up. Any help would be appreciated and thanks in advance |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help needed on generating sequences
Thank you both, i tried excel formulas it works terrific, then the VBA
as well for more practice and its just fine, Thanks again. Sincerely, Totti |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Restricted value sequences in rows | Excel Worksheet Functions | |||
Save as: sequences? | Excel Discussion (Misc queries) | |||
Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
multiple hits in random sequences | Excel Worksheet Functions | |||
paste sequences of different lengths | Excel Worksheet Functions |