[dba-Tech] finding the most consistent combination of 3 columns

[John Bartow]

Does my latest reply to Stuart help?

-----Original Message-----
From: dba-Tech <dba-tech-bounces+jbartow=winhaven.net at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Sunday, March 07, 2021 3:47 PM
To: Discussion of Hardware and Software issues <dba-tech at databaseadvisors.com>
Subject: Re: [dba-Tech] finding the most consistent combination of 3 columns

Can you define 'best balance' a little more?

r

On Sun, Mar 7, 2021 at 12:53 PM John Bartow <jbartow at winhaven.net> wrote:

> I'm going to try to clarify my goal in regards to my question.
>
> I have 3 columns of data which currently reside in Excel - but that 
> was just a convenient way to get them into digital format. They data 
> are all numerical and never less than zero.  They can have a maximum 
> of 2 decimal points.
>
> What I'm specifically looking for is a way to evaluate the three 
> columns of each row to find the best balance of numbers between the three columns.
> Having all 3 numbers be exactly the same is best. Having 2 numbers the 
> same and one number be plus or minus one would be next best, etc.
>
> I am thinking that this would be a solution of "standard deviation" 
> but I am not sure.
>
> Just trying to avoid going down a rabbit hole. So I turn to the people 
> I know have better brains than I.
> John B
> -----Original Message-----
> From: dba-Tech 
> <dba-tech-bounces+jbartow=winhaven.net at databaseadvisors.com>
> On Behalf Of John Bartow
> Sent: Sunday, March 07, 2021 1:22 PM
> To: Discussion of Hardware and Software issues < 
> dba-tech at databaseadvisors.com>
> Subject: Re: [dba-Tech] finding the most consistent combination of 3 
> columns
>
> 1,1,1
>
> -John
> -----Original Message-----
> From: dba-Tech 
> <dba-tech-bounces+jbartow=winhaven.net at databaseadvisors.com>
> On Behalf Of Gustav Brock via dba-Tech
> Sent: Sunday, March 07, 2021 1:54 AM
> To: Discussion of Hardware and Software issues < 
> dba-tech at databaseadvisors.com>
> Cc: Gustav Brock <gustav at cactus.dk>
> Subject: Re: [dba-Tech] finding the most consistent combination of 3 
> columns
>
> Hi John
>
> Which set would rank first: 1,1,1 or 3,1,1?
>
> /gustav
>
> ________________________________
> Fra: dba-Tech <dba-tech-bounces+gustav=cactus.dk at databaseadvisors.com> 
> på vegne af John Bartow <jbartow at winhaven.net>
> Sendt: 7. marts 2021 06:52
> Til: DBA-Tech (dba-tech at databaseadvisors.com) < 
> dba-tech at databaseadvisors.com>
> Emne: [dba-Tech] finding the most consistent combination of 3 columns
>
> Hi All,
> I am looking to find the best combination of 3 columns of numbers and 
> then sort by the highest ranking.
> For instance given the values below I want to find 5,5,5 and then 
> 4,4,4 and then 3,2,3 and then 3,2,2.
> 0,4,8
> 5,1,1
> 1,3,5
> 3,2,3
> 12,0,0
> 0,10,0
> 0,0,15
> 4,4,4
> 5,5,5
> 3,2,2
>
> Suggestions on how to proceed in Excel or Access.
>
> John B
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com 
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com