The One-Answer Question Thread [closed]

[Michael Womack]

Do I have to enter each in a separate box? Or can they all be in one, just separated by commas?

First time in box A1 second time A2 and so on

 

[ThomasJE]

Do I have to enter each in a separate box? Or can they all be in one, just separated by commas?

They would have to be separated. For Ao50, if you put the times in cells B1:B50, the formula on C50 for the Ao50 would be:
=(SUM(B1:B50)-MIN(B1:B50,1)-MIN(B1:B50,50))/48
And that assumes that you don't have two or more DNF's. To get the DNF averages, use this formula:
=IF(COUNTIF(B1:B50,"DNF")>1,"DNF",(SUM(B1:B50)-MIN(B1:B50,1)-MIN(B1:B50,50))/48)
That should work. If there's any problem, just post again or PM me.

 

[Cubetastic]

I'm averaging 18 seconds with cfop right now. Should I consider learning the oll's now?

 

[bluecloe45]

I'm averaging 18 seconds with cfop right now. Should I consider learning the oll's now?

If you have already learned Full Pll and 2 look OLL go right ahead.

 

[Ickathu]

First time in box A1 second time A2 and so on

They would have to be separated. For Ao50, if you put the times in cells B1:B50, the formula on C50 for the Ao50 would be:
=(SUM(B1:B50)-MIN(B1:B50,1)-MIN(B1:B50,50))/48
And that assumes that you don't have two or more DNF's. To get the DNF averages, use this formula:
=IF(COUNTIF(B1:B50,"DNF")>1,"DNF",(SUM(B1:B50)-MIN(B1:B50,1)-MIN(B1:B50,50))/48)
That should work. If there's any problem, just post again or PM me.

Well darn. I'm not manually entering 1000 times Thanks anyway though. I'll type them in as I go for my 10k marathon, if I remember.

 

[ThomasJE]

Well darn. I'm not manually entering 1000 times Thanks anyway though. I'll type them in as I go for my 10k marathon, if I remember.

Put a post-it note by your cubes, so whenever you grab your cube, you see the note.

 

[drewsopchak]

K. Your "CLLEP" as you described would be more than ollcp

CLLEF is worth learning if you are using CLL/ELL IMO because it take out the horrible possibility you grt a 4 flip case. +more algs is always good and its only 42

And for CFOP? I think it's worth it because the algs a pretty much aren't any longer than the regular olls for the cases.

 

[uberCuber]

Not really, it's only for 3 OLLs, two of which are super fast, and the other is the rarest OLL which has horrible OLLCP algs for some of the cases.

Lolwat. It is more than 3 OLLs, seeing as there are 8 possible corner orientations.

 

[5BLD]

Well darn. I'm not manually entering 1000 times Thanks anyway though. I'll type them in as I go for my 10k marathon, if I remember.

Text to columns, transpose

And for CFOP? I think it's worth it because the algs a pretty much aren't any longer than the regular olls for the cases.

It's only 42 algs, go ahead.

 

[antoineccantin]

Is it a +2 if a small part of a puzzle/magic is on the timer after you finish the solve?

 

[cubernya]

Is it a +2 if a small part of a puzzle/magic is on the timer after you finish the solve?

Only if it's over 45 degrees

 

[sneaklyfox]

I don't get it. What is 45 degrees of the puzzle on the timer?

 

[antoineccantin]

I don't get it. What is 45 degrees of the puzzle on the timer?

I think he means that its a +2 if there is a 45 degree misalignment on the puzzle because it landed on the timer.

 

[cubernya]

I don't get it. What is 45 degrees of the puzzle on the timer?

Only if the angle of the tiles is over 45

 

[ThomasJE]

They would have to be separated. For Ao50, if you put the times in cells B1:B50, the formula on C50 for the Ao50 would be:
=(SUM(B1:B50)-MIN(B1:B50,1)-MIN(B1:B50,50))/48
And that assumes that you don't have two or more DNF's. To get the DNF averages, use this formula:
=IF(COUNTIF(B1:B50,"DNF")>1,"DNF",(SUM(B1:B50)-MIN(B1:B50,1)-MIN(B1:B50,50))/48)
That should work. If there's any problem, just post again or PM me.

Sorry, the MIN should be replaced with SMALL. So, the formulas should be:
=(SUM(B1:B50)-SMALL(B1:B50,1)-SMALL(B1:B50,50))/48
=IF(COUNTIF(B1:B50,"DNF")>1,"DNF",(SUM(B1:B50)-SMALL(B1:B50,1)-SMALL(B1:B50,50))/48)

 

[hcfong]

At a recent competition I had this situation:

I started my inspection when after just 3 seconds, the judge called '12 seconds!'. I was taken by surprise by this, so I put the cube down and started the timer without a proper inspection. Only after the solve did I realise that he was a first time competitor and didn't know the correct procedure. The '12 seconds' that he called was to indicate I had 12 seconds left. As a result, I hardly had any chance to inspect the cube and to plan the cross, which did affect my time.

Could I have gone to the delegate and asked for an extra attempt on the grounds that the judge used the wrong procedure for inspection and would I have been granted an extra attempt? Not that it really matters, but I just wanted to know for future reference.

 

[robosariobo777]

I know this is something that is probably frequently answered, but the stickers on the F-II are bad quality right? Because mine are very faded and scratched? This is a common thing with this cube right?

 

[RubiXer]

Yessir

 

[Michael Womack]

I know this is something that is probably frequently answered, but the stickers on the F-II are bad quality right? Because mine are very faded and scratched? This is a common thing with this cube right?

Very true

 

[PandaCuber]

How much wood would a woodchuck chuck if a woodchuck could chuck wood?