Filters, and the impact associated with using them.

[sangoma123]

Hello Pab:

Not, I refer to any quantity of numbers. Also it is an example the quantity of "(2-3) or (0-4)" .All numbers and signs are examples.

Modal to the filter Frank's AC, it would be brilliant to have a small program to which we can introduce the combinations that we are going to play, and this program was saying to us the AC of every combination,this way we could to reject combinations with AC´s of 5 or less

I dont know if the program that you have done is for excel, or which program´s language is.

Can you help me about how to use this miniprogram that you have done?

Regards

 

[PAB]

Hi sangoma123,

Modal to the filter Frank's AC, it would be brilliant to have a small program to which we can introduce the combinations that we are going to play, and this program was saying to us the AC of every combination, this way we could to reject combinations with AC´s of 5 or less.

I dont know if the program that you have done is for excel, or which program´s language is.

Can you help me about how to use this miniprogram that you have done?

It is done in Excel.
If you give the cell references where your combinations to play are, I can give you the formulas to use that will calculate the AC value.

Can you help me about how to use this miniprogram that you have done?

What do you mean???
Do you want to know how to Run the program that Frank has posted???

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Pab, first, thank you very much for your interest in my doubts.

I don´t know very well in what cells of excel I must place my bets to say you. Though I have a few small notions of excel, I do not handle it often.

Third , yes, I was recounting me to since using it. I don´t know if some another program is necessary, though it of excel it me would be useful.

Thank you very much.

 

[PAB]

Hi sangoma123,

Third, yes, I was recounting me to since using it. I don't know if some another program is necessary, though it of excel it me would be useful.

OK, here are the Excel formulas to work out the AC's.
Put your combinations that you are going to play in cells B2:G2.

Put the following formulas in the appropriate cells:

Cell I2 =C2-B2
Cell J2 =D2-C2
Cell K2 =E2-D2
Cell L2 =F2-E2
Cell M2 =G2-F2
Cell N2 =D2-B2
Cell O2 =E2-C2
Cell P2 =F2-D2
Cell Q2 =G2-E2
Cell R2 =E2-B2
Cell S2 =F2-C2
Cell T2 =G2-D2
Cell U2 =F2-B2
Cell V2 =G2-C2
Cell W2 =G2-B2

Cell Y2 =SUM(IF(FREQUENCY(I2:W2,I2:W2)>0,1))-5

Then just copy ALL the formulas down as far as needed.

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Hello Pab:

Sorry, but everything me works well in the spreadsheet except the cell Y2.

I paste this in cell Y2:

=SUM (IF (FREQUENCY (I2:W2, I2:W2)> 0,1))-5

And a message of error appears in the formula. I dont know what can happen.

The other differences yes he calculates them well, but the final AC does not.

Do you know that I can be doing wrong?

Thank you

 

[PAB]

Hi sangoma123,

Sorry, but everything me works well in the spreadsheet except the cell Y2.

I paste this in cell Y2:

=SUM(IF(FREQUENCY(I2:W2,I2:W2)>0,1))-5

And a message of error appears in the formula. I dont know what can happen.

The other differences yes he calculates them well, but the final AC does not.

Do you know that I can be doing wrong?

(1) What language Excel is it???
(2) What version of Excel is it???
(3) What does the error message say???

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Pab, sorry for the inconveniences. I expect to explain well what happens:

1) Microsoft Excel 2002 (10.6871.6870) SP3


When I introduce the formula in Y2, there are no changes in the cell.

The formula remains there. I pulsate "Insert", "Function", and he says to me:

Arguments of function:

Frequency
I2:W2, I2:W2 =no validated

Please If you need more information,say me it.

Thanks again

 

[PAB]

Hi sangoma123,

When I introduce the formula in Y2, there are no changes in the cell.

The formula remains there. I pulsate "Insert", "Function", and he says to me:

Arguments of function:

Frequency
I2:W2, I2:W2 =no validated

Just a thought.
Can you check that there is NOT A SPACE before the = sign.
If that doesn't work it is probably the formula is not compatible with your version of Excel, and if that is the case I will come up with a compatible formula for you.

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Pab before not bothering doing again the formulas, I am going to try to install

-in the next days- a modern version of excel, and I will comment on you if it is

OK for me the current formulas.

Thanks

 

[PAB]

Hi sangoma123,

Pab before not bothering doing again the formulas, I am going to try to install.

-in the next days- a modern version of excel, and I will comment on you if it is OK for me the current formulas.

Did you try what I suggested???

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[PAB]

Hi sangoma123,

These should work in Excel2002.
They are ALL array entered, that is not just ENTER but Ctrl+Shift+Enter:

(1) =SUM(IF(LEN(B2:G2),1/COUNTIF(B2:G2,B2:G2)))
(2) =IF(LEN(B2:G2),SUMPRODUCT(1/COUNTIF(B2:G2,B2:G2)))
(3) =SUM(1/COUNTIF(B2:G2,B2:G2))

I would go for number (1) or number (2) because it doesn't give a #DIV/0! error if the cell is blank or empty.

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Hello:

Still I have not managed to introduce any of the formulas in the cell (Y2), but I am installing another more modern version of Excel, and wait to be able to do it soon.

I would like to do another question to you..

I have put the numbers (one to one) in the cells B2 to G2.

The question is :Is there any way of sticking the combinations in block (or group), so not to have to put the numbers of the combinations played in the cells one to one?.

Thank you very much again for your interest.

Regards

 

[PAB]

Hi sangoma123,

Still I have not managed to introduce any of the formulas in the cell (Y2), but I am installing another more modern version of Excel, and wait to be able to do it soon.

Don't understand that, those formulas should work .

I would like to do another question to you.

I have put the numbers (one to one) in the cells B2 to G2.

The question is: Is there any way of sticking the combinations in block (or group), so not to have to put the numbers of the combinations played in the cells one to one?

Do you mean like this???

=CONCATENATE(TEXT(B2,"00")," ",TEXT(C2,"00")," ",TEXT(D2,"00")," ",TEXT(E2,"00")," ",TEXT(F2,"00")," ",TEXT(G2,"00"))

I hope this helps!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Yes,I think that a formula like this is what I need.

This formula must be stuck in the cell B2?.

It can be the format of the combinations be anyone?

The format I use is like this:

02,03,19,20,29,37

Thanks Pab

 

[PAB]

Hi sangoma123,

This formula must be stuck in the cell B2?

I have just tried the formulas that I posted but with the cells B2:G2 formated as "00", and it makes NO difference.

I used the formula:

=SUM(IF(LEN(B2:G2),1/COUNTIF(B2:G2,B2:G2)))

...entered with Ctrl+Shift+Enter and NOT JUST ENTER in cell Y2 and it worked perfectly.
Without seeing your WorkBook I don't know what you are doing wrong!

BTW, I also used the formula:

=SUM(IF(FREQUENCY(I2:W2,I2:W2)>0,1))-5

...which also worked!

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Pab sorry for the inconveniences,I think the problem is my old version of Excel.

In my last post I was referring to this formula, not the others:

=CONCATENATE(TEXT(B2,"00")," ",TEXT(C2,"00")," ",TEXT(D2,"00")," ",TEXT(E2,"00")," ",TEXT(F2,"00")," ",TEXT(G2,"00"))

¿It must be patched in the cell B2 ?

Thanks

 

[PAB]

Hi sangoma123,

PAB, sorry for the inconveniences, I think the problem is my old version of Excel.

In my last post I was referring to this formula, not the others:

=CONCATENATE(TEXT(B2,"00")," ",TEXT(C2,"00")," ",TEXT(D2,"00")," ",TEXT(E2,"00")," ",TEXT(F2,"00")," ",TEXT(G2,"00"))

It must be patched in the cell B2?

Firstly, I don't think it has to do with the version of Excel you are using. Perhaps if you upload your WorkBook I can resolve the problem.

Secondly, what do you mean by "It must be patched in the cell B2"???

A couple of questions:
(1) Does the formula produce the results you were expecting, if not, why???
(2) Are you using cells B2:G2 for the numbers to be included in the combination???
(3) If not, what are the cell reference that your numbers are in???
(4) Where do you want the results to be output to???

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[PAB]

Hi sangoma123,

PAB, sorry for the inconveniences, I think the problem is my old version of Excel.

In my last post I was referring to this formula, not the others:

=CONCATENATE(TEXT(B2,"00")," ",TEXT(C2,"00")," ",TEXT(D2,"00")," ",TEXT(E2,"00")," ",TEXT(F2,"00")," ",TEXT(G2,"00"))

It must be patched in the cell B2?

Firstly, I don't think it has to do with the version of Excel you are using. Perhaps if you upload your WorkBook I can resolve the problem.

Secondly, what do you mean by "It must be patched in the cell B2"???

A couple of questions:

(1) Does the formula produce the results you were expecting, if not, why???
(2) Are you using cells B2:G2 for the numbers to be included in the combination???
(3) If not, what are the cell references that your numbers are in???
(4) Where do you want the results to be output to???

Regards,
PAB


-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
12:45, restate my assumptions.
(1) Mathematics is the language of nature.
(2) Everything around us can be represented and understood through numbers.
(3) If you graph the numbers of any system, patterns emerge. Therefore, there are patterns, everywhere in nature.

 

[sangoma123]

Pab, graces for your patience.

(I think all the good made to the others persons has reward in the life).

1) Simply I wanted to have everything prepared when it has the new version of excel.

2) Yes I use cell B2:G2 for the numbers. All works correctly except cell Y2.

3) -

4) I dont know where the output must be place.


I am not going to write new posts up to having the new version of excel.

Thank you very much.

 

[sangoma123]

Hello Pab:

Even I have not installed the new version of excel, but I would like to send you some information.

I have tried to send you a private message, but there appears a message that it says that I cannot: (Disabled by the administrator)

Is there any mail where I could order you a private message?

Thank you