Home

Array in Array

%3CLINGO-SUB%20id%3D%22lingo-sub-404497%22%20slang%3D%22en-US%22%3EArray%20in%20Array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-404497%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20hit%20a%20wall%20with%20my%20file%20and%20I%20need%20help.%3C%2FP%3E%3CP%3ETried%20google....I%20would%20sit%20countless%20hours%20on%20it%20and%20%3CSTRONG%3Emaybe%3C%2FSTRONG%3E%20do%20it.....%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20implement%20a%20choice%20tree%20structure.%20B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDepending%20on%20the%20choice%20different%20result%20that%20could%20also%20be%20a%20choice.%3C%2FP%3E%3CP%3ESo%20a%20tree%20structure%20of%20%3A%3C%2FP%3E%3CP%3EA%20%3D%20%7BChoiceB%7BchoiceE%2C%20F%7D%20%2C%20C%20%2C%20ChoiceD%7BChoiceG%2CH%7D%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChoiceE%3D%7BChoiceI%2CJ%7D%3C%2FP%3E%3CP%3EChoiceG%3DK%3C%2FP%3E%3CP%3EChoiceI%20%3D%20%7BL%2C%20M%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20goes%3A%3C%2FP%3E%3CP%3EA1%20%3D%20A%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20B1%20%3D%20ChoiceB%20(choiceE)%26nbsp%3B%20%26nbsp%3BC1%3DC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BD1%20%3DChoiceD(ChoiceG)%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB2%20%3D%26nbsp%3B%20J%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20D2%20%3D%20K%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB3%20%3D%20ChoiceI%20(L)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomeone%20has%20idea%20on%20how%20to%20do%20it%3F%3C%2FP%3E%3CP%3ERight%20now%20I'm%20playing%20with%20VBA%20but%20...It%20goes%20very%20slowly.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-404497%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-407472%22%20slang%3D%22en-US%22%3ERe%3A%20Array%20in%20Array%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-407472%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315847%22%20target%3D%22_blank%22%3E%40andrzejbielecki%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20(the%20worksheet%2C%20not%20the%20picture)%20any%20use.%26nbsp%3B%20It%20was%20written%20in%202012%20and%2C%20unfortunately%2C%20I%20have%20largely%20forgotten%20it.%26nbsp%3B%20You%20appear%20to%20have%20multiple%20answer%20choices%20rather%20than%20simple%20Yes%2FNo%20but%2C%20on%20the%20other%20hand%2C%20your%20graphs%20seem%20to%20be%20proper%20trees%20rather%20than%20more%20general%20forms.%3C%2FP%3E%3CP%3EI%20also%20have%20versions%20that%20are%20visually%20more%20dramatic%20(picture)%20but%20at%20the%20moment%20they%20no%20longer%20appear%20to%20work%20consistently%20on%20my%20computer.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20603px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106106i2B4DA789AD822F1C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.JPG%22%20title%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
andrzejbielecki
Occasional Visitor

I have hit a wall with my file and I need help.

Tried google....I would sit countless hours on it and maybe do it.....

I am trying to implement a choice tree structure. B

 

Depending on the choice different result that could also be a choice.

So a tree structure of :

A = {ChoiceB{choiceE, F} , C , ChoiceD{ChoiceG,H}}

 

ChoiceE={ChoiceI,J}

ChoiceG=K

ChoiceI = {L, M}

 

And it goes:

A1 = A      B1 = ChoiceB (choiceE)   C1=C     D1 =ChoiceD(ChoiceG)

                 B2 =  J                                            D2 = K

                 B3 = ChoiceI (L)

 

 

Someone has idea on how to do it?

Right now I'm playing with VBA but ...It goes very slowly.               

 

 

 

1 Reply

@andrzejbielecki 

Is this (the worksheet, not the picture) any use.  It was written in 2012 and, unfortunately, I have largely forgotten it.  You appear to have multiple answer choices rather than simple Yes/No but, on the other hand, your graphs seem to be proper trees rather than more general forms.

I also have versions that are visually more dramatic (picture) but at the moment they no longer appear to work consistently on my computer.

Capture.JPG

Related Conversations