Posts by allen71828

  • Bb code

    Hello everybody.


    Some guide how to use in the BB code the [et]111[/et], this et suposlly let me upload a image of my table, somebody know this step by step.
    I didn't know this. wow.

  • (programming process logic) how or where to ask

    where or how to really understand how to code in a very logical and natural way. I mean I was reading about variables, and many books I think asume and abuse asumming, when they talk about declaring variable talk about procedure level, project level, and after jump with example like Dim 1row as long end sub,
    how or what book really explaing from the problem to the pseudocode and how I figure out when to write those wierd as long = as long, if for example I want a code that ---generate a list of numbers with some conditions---- is a simple statement with the following words 1(generate), 2(a list of), 3(numbers) and 4(with some conditions) from this simple things how they deduce all those dims and so on. somebody can tell me what book explain this, and please if this is to ordinary for you, think this is a forum and the rules do not say nothing about to be a genius, otherwise why to be here.

  • combinations

    Re: combinations


    2003, so I am typing now letter by letter and in the part 1Row = 1Row + 1 in the second row, said end of the statements error, so I am working, but still is hard.

  • combinations

    Hi everybody, I will try to be clear, I apologize ahead of time if error occur. I know that taken 6 numbers from 26 there are 230.230 combinations, I am trying to refine that list by placing certain conditions. Ideally I would like to INPUT a sum with designated value and the amount of evens and odds numbers I want.
    DIRECTION: (1) NO IQUAL DIFFERENTS, what really means is, no concecutive or multiples, like 15-16-17-18-19 etc. or 16-18-20-22-etc. or 1-8-15-22-etc all of them you can see have iqual differents.
    DIRECTION: (2) NO REPEATING NUMBERS, the output list example can show you exactly what non-repeating numbers means: 1-13-18-24-40-53 / 3-11-24-29-35-51 / 4-7-20-23-38-48 / 14-24-29-30-51-53 / 12-17-19-21-33-37 /. thanks.

  • warehouse- sales problem -statistics.

    Re: warehouse- sales problem -statistics.


    Thank you, so much for your attention. With all respect, I would like to modify the code I am working, but I am stumped, days and days, and.... so I am sending what I need; and the workbook I rather by private message. (it's to long here).
    [TABLE="class: MsoNormalTable, width: 439"]

    [tr]


    [TD="width: 66, bgcolor: transparent"]numbers
    [/TD]
    [TD="width: 63, bgcolor: transparent, colspan: 2"]ranking
    [/TD]
    [TD="width: 91, bgcolor: transparent"]
    [/TD]
    [TD="width: 90, bgcolor: transparent"]
    [/TD]
    [TD="width: 75, bgcolor: transparent"]
    [/TD]
    [TD="width: 44, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    58

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    92

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 402, bgcolor: transparent, colspan: 6"]rank high from 67 to 100/ middle 34 to 66 and low 1 to 33
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    41

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    30

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]
    [/TD]
    [TD="width: 90, bgcolor: transparent"]
    [/TD]
    [TD="width: 75, bgcolor: transparent"]
    [/TD]
    [TD="width: 44, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    49

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    71

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 402, bgcolor: transparent, colspan: 6"]the code must generate the combinations of 6 numbers
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    24

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    65

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 354, bgcolor: transparent, colspan: 5"]with 2 high, 2middle, 2 low, and 3evens, 3 odds.
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    20

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    50

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]sum range
    [/TD]
    [TD="width: 164, bgcolor: transparent, colspan: 2"]from 141 to 247
    [/TD]
    [TD="width: 44, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    21

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    67

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 299, bgcolor: transparent, colspan: 4"]this range is part of the inputs also.
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    16

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    98

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]
    [/TD]
    [TD="width: 90, bgcolor: transparent"]
    [/TD]
    [TD="width: 75, bgcolor: transparent"]
    [/TD]
    [TD="width: 44, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    17

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    70

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 457, bgcolor: transparent, colspan: 7"] there are two high rank two middle rank and two low rank totals
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    19

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    20

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]

    12

    [/TD]
    [TD="width: 90, bgcolor: transparent"]

    16

    [/TD]
    [TD="width: 75, bgcolor: transparent"]

    20

    [/TD]
    [TD="width: 44, bgcolor: transparent"]

    17

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    25

    [/TD]
    [TD="width: 47, bgcolor: transparent"]

    51

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    141

    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    12

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    100

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]

    12

    [/TD]
    [TD="width: 90, bgcolor: transparent"]

    46

    [/TD]
    [TD="width: 75, bgcolor: transparent"]

    52

    [/TD]
    [TD="width: 44, bgcolor: transparent"]

    49

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    51

    [/TD]
    [TD="width: 47, bgcolor: transparent"]

    25

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    235

    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    23

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    67

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]

    46

    [/TD]
    [TD="width: 90, bgcolor: transparent"]

    58

    [/TD]
    [TD="width: 75, bgcolor: transparent"]

    52

    [/TD]
    [TD="width: 44, bgcolor: transparent"]

    21

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    51

    [/TD]
    [TD="width: 47, bgcolor: transparent"]

    19

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    247

    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    32

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    80

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]

    32

    [/TD]
    [TD="width: 90, bgcolor: transparent"]

    58

    [/TD]
    [TD="width: 75, bgcolor: transparent"]

    24

    [/TD]
    [TD="width: 44, bgcolor: transparent"]

    23

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    41

    [/TD]
    [TD="width: 47, bgcolor: transparent"]

    51

    [/TD]
    [TD="width: 55, bgcolor: transparent"]

    229

    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    25

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    1

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]
    [/TD]
    [TD="width: 90, bgcolor: transparent"]
    [/TD]
    [TD="width: 75, bgcolor: transparent"]
    [/TD]
    [TD="width: 44, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    52

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    60

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 402, bgcolor: transparent, colspan: 6"] there are 3 evens and three odds
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    51

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    10

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 91, bgcolor: transparent"]
    [/TD]
    [TD="width: 90, bgcolor: transparent"]
    [/TD]
    [TD="width: 75, bgcolor: transparent"]
    [/TD]
    [TD="width: 44, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [tr]


    [TD="width: 66, bgcolor: transparent"]

    46

    [/TD]
    [TD="width: 48, bgcolor: transparent"]

    90

    [/TD]
    [TD="width: 16, bgcolor: transparent"]
    [/TD]
    [TD="width: 255, bgcolor: transparent, colspan: 3"]the numbers and ranking I have to input manually.
    [/TD]
    [TD="width: 99, bgcolor: transparent, colspan: 2"]
    [/TD]
    [TD="width: 47, bgcolor: transparent"]
    [/TD]
    [TD="width: 55, bgcolor: transparent"]
    [/TD]

    [/tr]


    [/TABLE]
    sorry for any mistake. and thank you again for your time. You are the first person who respond.

  • warehouse- sales problem -statistics.

    There are 2 kind of things to sale and to srorage, of course, so the warehouse is divide in two sides, electronics (probills numbers are evens) and clothes (are odds). Some products have excellent sales rank (from 67% to 100), normal (34 to 66) and poor (1 to 33).
    Sales department problem. Show the list of numbers ( from 59), taken 6 at the time that have the rank and type, means two excellent, 2 normal, 2 poor, and 3odds, 3 evens, this list create balance sales. They have to sale everything not only the electronics (evens) or clothes (odds) and the excellents and poors.
    example:
    probill # 2 - 4- 6---3---5---7
    rank 67 100 34 66 1 33 easy first look 2 high,average,low rank
    and also odds and even. that' balance
    in the market. first I don't know how to write a vba code, and I post only here and here only nowhere-else.