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

Rocky Smolin rockysmolin2 at gmail.com
Sun Mar 7 15:46:47 CST 2021

```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 <
> 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 <
> 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) <
> 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 mailing list