Friday's Coding Challenge

Slacker007

Chris Maunder wrote:

I was thinking about all the smart comments that would be made

Well Chris, you remember how the last challenge went. :)

"the meat from that butcher is just the dogs danglies, absolutely amazing cuts of beef." - DaveAuld (2011)
"No, that is just the earthly manifestation of the Great God Retardon." - Nagy Vilmos (2011) "It is the celestial scrotum of good luck!" - Nagy Vilmos (2011)

Dalek Dave

As an accountant I would suggest...

Range("A:A").Select
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Sheet1").Sort.SortFields.Add Key:=Range("A1"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Sheet1").Sort
    .SetRange Range("A:A")
    .Header = xlNo
    .MatchCase = False
    .Orientation = xlTopToBottom
    .SortMethod = xlPinYin
    .Apply
End With
Range("C1").Select
ActiveCell.FormulaR1C1 = "=RC\[-2\]"
Range("C2").Select
ActiveCell.FormulaR1C1 = "=COUNTIF(R\[-1\]C\[-2\]:R\[17\]C\[-2\],R\[-1\]C)"
Range("C3").Select

That that is accountants all over!

--------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] English League Tables - Live

Chris Maunder

My eyes! They burn!

cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

Nagy Vilmos

That's uglier than my photo!

Panic, Chaos, Destruction. My work here is done. Drink. Get drunk. Fall over - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett

Chris Maunder

Yes, like the weekly surveys, they are merely pedant fodder. :)

cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

Dalek Dave

I took you at your word...See Below :)

--------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] English League Tables - Live

Dalek Dave

Functional but ugly. I have dated some like that!

--------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] English League Tables - Live

Dalek Dave

If you don't feed the pedants, they will revolt!

--------------------------------- I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC Link[^] English League Tables - Live

wizardzz

Elephanting Sunshine! You expect us to do your homework?

"I have a theory that the truth is never told during the nine-to-five hours. " — Hunter S. Thompson

realJSOP

I assumed n was 1. :)

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997

Roger Wright

Is this somehow related to the curious error page I received this morning from Web04? The one featuring ravenous hamsters obviously recovering from a three day methamphetamine/ethanol binge?

Will Rogers never met me.

Bassam Abdul Baki

In English (again): :D Assume m = A*n + B. If m >> n, then it might be easier to first sort each of the A n-segments and B segment separately. Compare the first element of the A-1 lists and B to the last element of the first A list (or to the last element of the smallest starting A-list) and eliminate all the A segments that are greater than that. Then repeat the process again using n elements selected vertically.

Web - BM - RSS - Math - LinkedIn

NormDroid

Help my eyes, my poor eyes are bleeding :)

Software Kinetics Wear a hard hat it's under construction
Metro RSS

PIEBALDconsult

"The pedants are revolting!" (a la The Wizard of Id)

Chris Maunder

The hamsters have asked for an end to the rumours and baseless allegations of alleged behaviour during certain incidents. The hamsters involved are currently taking some time off to spend more time with their families.

cheers, Chris Maunder The Code Project | Co-founder Microsoft C++ MVP

leppie

Roger Wright wrote:

The one featuring ravenous hamsters obviously recovering from a three day methamphetamine/ethanol binge?

You read my mind ;p

IronScheme
((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

Mel Padden

Try this:

#generation of the list
import random
sample = []; n=10; m = 100;rnd = random.Random();
for it in range (1, m): sample.append(rnd.randint(1,n*m))

#then
sample.sort()
print sample[:n]
#boom

@Chris - When are you planning to start supporting Python in the forum syntax highlighter? :-O [Edit] Not that I'm claiming that my little snippet is beautiful; far from it. I'm still way off being a full-blown Pythonista. But it sure would be nice to have it supported.

Beautiful is better than ugly. Explicit is better than implicit. Simple is better than complex. Complex is better than complicated. Flat is better than nested. Sparse is better than dense. In the face of ambiguity, refuse the temptation to guess.

Simon_Whale

My only other alternative is using this List.Sort overloaded method[^] but it would involve a more complex object and writing your own Compare method Scrap that idea Leppie has a great answer in my opinion[^]

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

leppie

sample.OrderBy(x => x).Take(n)

IronScheme
((λ (x) `(,x ',x)) '(λ (x) `(,x ',x)))

realJSOP

//assumptions
// n = 2
int[] sample = new int[]{8,1,9,3,2};
int[] sample2 = new int[2];

//code
Array.Sort(sample);
sample2 = sample.Take(sample2.Length).ToArray();

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass." - Dale Earnhardt, 1997