-
You could do that reasonably simply in a database. SQL (language used for querying databases) lends itself very well to this kind of "choose the best team subject to these constraints" problems.
Is it practical for you to run a database?
-
Round two, the spreadsheet takes over. Based on the scores of the first round, the teams are matched up with teams of most equal ability. For example, teams that won their first game, teams that lost their first game, teams with close goal differences. This continues for 6 rounds.
Can you give a precise definition of how to match up teams in round 2 and beyond?
-
Ok.
What's the problem with Array formulas then?
(Pivot tables do it better? I couldn't get a Pivot table to give me the median of the answer I wanted - it's not a supported function. What would have been better? I'm working with Bill Jelen books here, if there's better more efficient stuff I'd be happy to know)sits back, waits for more dunce cap handing out, red cheeks of shame and generally remembering what school was like
Use the "median()" function?
-
Array Formula, please.
Horatio - what is it you're trying to do?
-
Good on you y-s. Maybe Velocio can approve a sticky thread at the top of the forum for this? I will
PM him -
filth. try airbnb.com
-
Ah all cool then
-
For our return to London, I mean
-
Hoeflas post re the trains being out is a little worrying, no?
-
'normal' means nothing. On the flats of manchester I run 77.4 and can keep that at a decent RPM for 10+ miles easy, which is my commute one way and accelerate and skid with not much trouble. I do use 170mm cranks.
normal means what most people use on here around town.
-
80GI is too high for commuting IMO
high 60s is more normal -
stock wheels on the langster will be pretty much the same as those on the charge plug
-
Why do you want to switch from a langster to a plug? They're both entry level bikes.
-
I actually bought an arrospok from him, no joke
-
has anyone see this man lately?If so, please tell him to come home, because we miss him.
is that asm? what happened to him? changed his username?
-
yeah, Swype seems to stop working every time google push out an OS update. I guess they have to adjust some thing(s) manually each time in the code? Seems pretty crap. Still, it's beta, so what do you expect.
-
Got upgraded to gingerbread overnight on my nexus 1. UI's gone all dark. And has a CRT style "off" effect when you turn the display off.
Seems to have fixed a lot of the bugs from the last hotfix that was causing google maps (amongst other things) to crash constantly.
-
That code assumes that when you're talking about "fixed values A and B", they are in the same row as the value in col AM, in cols A and B. You can just replace those with integers if you prefer.
The reason for the 2nd nested "IF" is so that if AM1 contains something other than "outdoor" or "indoor", you will be able to catch it.
-
There is a problem - you can't have the contents of AM1 modified in an "if" statement.
Try this formula in any blank cell (eg. C1):
[code]
=if(X1="indoor",AM1*A1,if(x1="outdoor",AM1*B1,"Error"))
[/code]See what that does?
-
1.Skully
2.Skive- jayloo (maybe guapo, university paper depending)
- betty
- jcgarcia
- Damo. Maybe.
- jaygee
- middleofnowhere
- bikegang
- atticus
- Fox
- Stix
- Wicksie
- Mrs. Wicksie
- Blackfoot
- Upstart
- Shinigami
- murtz
- mattty
I'd love to do this. I am a chap though.
- jayloo (maybe guapo, university paper depending)
-
Very nice IWC, but I'd go for a metal bracelet myself. Kevlar is very cool though.
LFGSS
London Fixed Gear and Single-Speed is a community of fixed gear and single-speed cyclists.
Yeah sure, I can write the queries without too much bother.
How are you planning to access the DB? You could get someone to write you an android front end and access it from your phone at the polo court. Maybe it would make sense to develop it as an android solution? I don't really know anything about software development.
But yeah, I can write the queries, give me a shout when you're set.