HomeFactopediaBrainoffsRankingsCommunityLog In
You know 0 facts





Mon 13 Feb 17 #1 
FactaCupAdmin
Member


POT BLACK TOURNAMENT - THE BIG BOARD
Player  Red  Yellow  Green  Brown  Blue  Pink  Black  Tie Break TOTAL
Nemesis 5   3 4 5 6 7   30
shortbreadforme27 5 2 3 4 5 6   2 27
bertie 5 2 3 4 5 6   1 26
chooky 4   3 4 5 6     22
Java 4 2 3   5 6     20
Ruby Franks 5   3 4 5 6 -7   16
JMK 4     4 5 6 -7   12
Bob47 3   3 4         10
sally906 3   3 4         10
vepa1943 5   3     6 -7   7
Helen McKenzie 3       5 -6     2
Allan R. Matthes 2               2
tallyho 5     4 5 -6 -7   1
TABBYTOES 1               1

ALL SCORES FINAL as at Saturday, 18 February 2017, 21:17 hrs, UTC

jmaxg's comments: And the Pot Black tournament has been decided. Awards have been posted (see below).


Knows 101 facts
like | send message
2 people like this post


Mon 13 Feb 17 #2 
jmaxg
Contributor

First scores are up and so, it begins!

Congratulations to Helen McKenzie for posting the very first score in this tournament!

Yay!

:-)




Knows 33692 facts
like | send message
2 people like this post


Thu 16 Feb 17 #3 
FactaCupAdmin
Member

Tips and Tricks in Microsoft Excel 2013 and Above - Part 1

jmaxg here speaking under my tournament running pseudonym, FactaCupAdmin.

One of the things to look after in this particular tournament is the new condition that no player can repeat a coloured ball choice in all 5 days of play and according to the entry forum, it was stated that FactaCupadmin will monitor that on behalf of all players.

Now, on the face of it, that seems easy and it is. Monitoring the colour choices of 14 players over 5 days is not rocket science. BUT as I am a lazy SOB, I wondered if there was a method within Excel that would show me AT A GLANCE as opposed to me reviewing a small, but important tournament condition.

TA DAA! Here is Excel's "Conditional Formatting"!

This is a representation of the current (as at Day 3) Excel Pot Black overseeing workbook with "conditional formatting" applied to the "coloured ball monitoring" worksheet....

Player Day 1 Colour Day 2 Colour Day 3 Colour Day 4 Colour Day 5 Colour
Helen McKenzie Brown Blue Pink    
Nemesis Green Brown Blue    
JMK Pink Blue Black    
sally906 Pink Blue Brown    
Ruby Franks Pink Blue Brown    
tallyho Green Brown Blue    
Allan R. Matthes   Pink Blue    
vepa1943 Green Pink Blue    
chooky Green Brown Blue    
shortbreadforme27 Pink Blue Brown    
bertie Pink Blue Brown    
Bob47 Blue Pink Brown    
TABBYTOES   Pink Black    
Java Brown Blue Pink    

And this is the same area assuming a future coloured ball choice had been applied that had already been used.....

Player Day 1 Colour Day 2 Colour Day 3 Colour Day 4 Colour Day 5 Colour
Helen McKenzie Brown Blue Pink    
Nemesis Green Brown Blue Green  
JMK Pink Blue Black    
sally906 Pink Blue Brown    
Ruby Franks Pink Blue Brown    
tallyho Green Brown Blue    
Allan R. Matthes   Pink Blue    
vepa1943 Green Pink Blue    
chooky Green Brown Blue    
shortbreadforme27 Pink Blue Brown    
bertie Pink Blue Brown    
Bob47 Blue Pink Brown    
TABBYTOES   Pink Black    
Java Brown Blue Pink    

As you can see, ANY DUPLICATION is immediately made plain saving me the trouble of actually reviewing each cell.

To use this, you must be very specific as to the range of cells you want reviewed and the circumstances. But once you have pinned that down, do the following:

1. Go to the Home menu.
2. Choose "Conditional Formatting" (over to the right).
3. Choose "Highlight Cell Rules".
4. Choose (in this case) "Duplicate Values".
5. Define your choices and click "OK".

ANYTHING that involves me not having to make a decision when I know the computer or application can do it for me is ok in my book.

I hope this is useful for some.


Knows 101 facts
like | send message


Thu 16 Feb 17 #4 
JMK
Editor

No you're not.



Edit: This comment referred to the comment "Reserved" that was posted in the previous post prior to it being updated. Just in case anyone wonders :)


Knows 47318 facts
like | send message
2 people like this post


Thu 16 Feb 17 #5 
jmaxg
Contributor

Well, I can be. I was just making the point that I would rather spreadsheets (or Excel workbooks), or any application for that matter, make my job easier. The less my brain has to do with the process, the better.

Edit: Oh! Is that what you meant.

Edit: Edit: Reddit conventions seem to be taking over.

Not that it is a bad thing. It's just that in my case, edits might outsize the original post.

Edit: I just added that.

Edit: I just added that I just added that.

Is that two edits or just one? I am so confused!




Knows 33692 facts
like | send message


Thu 16 Feb 17 #6 
Helen McKenzie
Contributor

Very well done!




Knows 25291 facts
like | send message


Thu 16 Feb 17 #7 
jmaxg
Contributor

Thanks Helen. Much appreciated.




Knows 33692 facts
like | send message


Thu 16 Feb 17 #8 
FactaCupAdmin
Member

Tips and Tricks in Microsoft Excel 2013 and Above - Part 2

jmaxg here speaking under my tournament running pseudonym, FactaCupAdmin.

Believe it or not, this tournament rests on the shoulders of this one, itty-bitty table which, of course has it's own worksheet.....

      RANGE
Colour Points Greater than or equal to Less than or equal to
YELLOW 2 90 499
GREEN 3 600 899
BROWN 4 1000 1299
BLUE 5 1400 1699
PINK 6 1800 2099
BLACK 7 2200 2399

Table 1

Now, in the earliest versions of this tournament, I found myself flipping back and forth from the current day's play worksheet to the "Ranges" worksheet in order to confirm if any player's score was a "HIT", "MISS" or "PENALTY". The working area looked like this.....

Players Qualify? Colour Category RB Point Y G B B P B Status Challenge Score
                         
Helen McKenzie Y Pink Lang. 1         -6   PENALTY 1489
Nemesis Y Blue Lang. 1       5     HIT 1500
JMK Y Black Lang. 1           -7 PENALTY 1826
sally906 Y Brown Misc. 1     4       HIT 1252
Ruby Franks Y Brown Lang. 1     4       HIT 1248
tallyho Y Blue S&N 1       5     HIT 1551
Allan R. Matthes Y Blue Lang. 1             MISS 1867
vepa1943 Y Blue S&L 1                
chooky Y Blue Movies 1       5     HIT 1608
shortbreadforme27 Y Brown Movies 1     4       HIT 1125
bertie Y Brown H&M 1     4       HIT 1153
Bob47 Y Brown Geog. 1     4       HIT 1133
TABBYTOES Y Black A&L 1                
Java Y Pink Lang. 1         6   HIT 1999

What to do? My "clicking finger" was getting tired.

Then I remembered.....

TA DAAA! Excel's "VLOOKUP" function!

NOW, on any given day of play, my working area looks like this.....

Players Qualify? Colour Category RB Point Min Max Y G B B P B Status Challenge Score
                             
Helen McKenzie Y Pink Lang. 1 1800 2099         -6   PENALTY 1489
Nemesis Y Blue Lang. 1 1400 1699       5     HIT 1500
JMK Y Black Lang. 1 2200 2399           -7 PENALTY 1826
sally906 Y Brown Misc. 1 1000 1299     4       HIT 1252
Ruby Franks Y Brown Lang. 1 1000 1299     4       HIT 1248
tallyho Y Blue S&N 1 1400 1699       5     HIT 1551
Allan R. Matthes Y Blue Lang. 1 1400 1699             MISS 1867
vepa1943 Y Blue S&L 1 1400 1699                
chooky Y Blue Movies 1 1400 1699       5     HIT 1608
shortbreadforme27 Y Brown Movies 1 1000 1299     4       HIT 1125
bertie Y Brown H&M 1 1000 1299     4       HIT 1153
Bob47 Y Brown Geog. 1 1000 1299     4       HIT 1133
TABBYTOES Y Black A&L 1 2200 2399                
Java Y Pink Lang. 1 1800 2099         6   HIT 1999

So now I can immediately tell after posting a player's score if they fall in the range or outside WITHOUT flipping back and forth to the "Ranges" worksheet!

Remember, it's a formula so it can be tricky. But once you get it right, it's useful in a million different ways.

To use it, apply the following (assuming you want a vertical - up/down - and not a horizontal - left/right - ability):

1. Choose the range you want to be looked up and note the extent of the data range. For example, the necessary data within the colour range above (Table 1, excluding the "RANGE" and other column headings) expressed as an Excel range is "A8:D13".
2. Pick the cell you want that will contain the criteria you want looked up. In the above examples regarding colour, it is the "C" column and starting with player "Helen McKenzie" who is row 8. So the criteria cell is "C8".
3. Choose the column that contains the the value you want reflected. In the above "Ranges" (Table 1) example, you have four (4) columns. From left to right, you can consider them as 1, 2, 3 and 4.
4. Enter the formula in a chosen cell (using column 3 as an example) as follows and hit "Enter":
"=VLOOKUP(C8,A8:D13,3,FALSE)"
("FALSE" works if you want an exact match. "TRUE" is what you use if you want an approximate match - UPPERCASE vs lowercase, things like that. Also, obviously I used the above for the "Min" column. For "Max", it was the same except that I used "=VLOOKUP(C8,A8:D13, 4 ,FALSE)" instead of "=VLOOKUP(C8,A8:D13, 3 ,FALSE)")
5. Go and make yourself a sandwich because your spreadsheet if doing your work for you.

Please remember that correct entry has everything to do with this. If you spell "Brown" as "Bronw" you are going to get a nil result. Same for number values and entering numbers as text. You cannot compare a "5" to a 5. One is text, there other is a value. You have to be consistent.

If you REALLY want to be clever, add the Excel "IFERROR" function to avoid those annoying "N/A"s from showing up.

Anyway, I hope this is of help.


Knows 101 facts
like | send message


Thu 16 Feb 17 #9 
Ruby Franks
Contributor

A few of us seem to be shadowing but in reverse order. Day 5 could see a 5 or 6 way tie, some examples of cowardice, or utter carnage with an unexpected result.




Knows 135573 facts
like | send message


Thu 16 Feb 17 #10 
jmaxg
Contributor

I haven't seen any example of cowardice thus far in this tournament. If fact, I have seen bravery especially with JMK's early attempt at a Black which, if it worked, would've thrown the whole tournament into a flutter.

I think you all have it planned out. Just taking different roads.

But I noted the early big scores and the possible reason for it.

Nevertheless, you know the one to be worried about. He maybe 5th at the moment but he hasn't put a foot wrong.

But neither have you (Ruby Franks), shortbreadforme27, bertie and chooky.

Day 5 is looking VERY interesting.




Knows 33692 facts
like | send message
1 person likes this post


Sat 18 Feb 17 #11 
FactaCupAdmin
Member

jmaxg here speaking under my pseudonym of FactaCupAdmin.

It occurred to me that while we wait for an outcome, we may as well take the chance to reconcile what we know already.

By that, I mean I will post working areas from Day 1 to Day 4 and you guys, using your residual brainoff notifications can verify if I got it right or wrong.

The following are the Pot Black workbook working areas from Day 1 to Day 4:

Day 1                            
Players Qualify? Colour Category RB Point Min Max Y G B B P B Status Challenge Score
Helen McKenzie Y Brown Lang. 1 1000 1299             MISS 1389
Nemesis Y Green Lang. 1 600 899   3         HIT 750
JMK Y Pink Lang. 1 1800 2099         6   HIT 1927
sally906 Y Pink Geog.   1800 2099             PENALTY 1043
Ruby Franks Y Pink Lang. 1 1800 2099         6   HIT 1990
tallyho Y Green S&N 1 600 899             MISS 1082
Allan R. Matthes DNQ                          
vepa1943 Y Green Movies 1 600 899   3         HIT 718
chooky Y Green A&L 1 600 899   3         HIT 768
shortbreadforme27 Y Pink Movies 1 1800 2099         6   HIT 1936
bertie Y Pink S&N 1 1800 2099         6   HIT 1897
Bob47 Y Blue Lang.   1400 1699             MISS 1703
TABBYTOES DNQ                          
Java Y Brown S&L   1000 1299             PENALTY 967


Day 2                            
Players Qualify? Colour Category RB Point Min Max Y G B B P B Status Challenge Score
Helen McKenzie Y Blue Lang. 1 1400 1699       5     HIT 1619
Nemesis Y Brown Lang. 1 1000 1299     4       HIT 1140
JMK Y Blue Lang. 1 1400 1699       5     HIT 1423
sally906 Y Blue Misc. 1 1400 1699             MISS 1878
Ruby Franks Y Blue Lang. 1 1400 1699       5     HIT 1533
tallyho Y Brown S&N 1 1000 1299     4       HIT 1192
Allan R. Matthes Y Pink H&M   1800 2099             PENALTY 1334
vepa1943 Y Pink Misc. 1 1800 2099         6   HIT 1946
chooky Y Brown S&N 1 1000 1299     4       HIT 1115
shortbreadforme27 Y Blue Movies 1 1400 1699       5     HIT 1616
bertie Y Blue Lang. 1 1400 1699       5     HIT 1590
Bob47 Y Pink S&N   1800 2099             PENALTY 1242
TABBYTOES Y Pink A&L   1800 2099             PENALTY 940
Java Y Blue Movies 1 1400 1699       5     HIT 1559


Day 3                            
Players Qualify? Colour Category RB Point Min Max Y G B B P B Status Challenge Score
Helen McKenzie Y Pink Lang. 1 1800 2099         -6   PENALTY 1489
Nemesis Y Blue Lang. 1 1400 1699       5     HIT 1500
JMK Y Black Lang. 1 2200 2399           -7 PENALTY 1826
sally906 Y Brown Misc. 1 1000 1299     4       HIT 1252
Ruby Franks Y Brown Lang. 1 1000 1299     4       HIT 1248
tallyho Y Blue S&N 1 1400 1699       5     HIT 1551
Allan R. Matthes Y Blue Lang. 1 1400 1699             MISS 1867
vepa1943 Y Blue S&L 1 1400 1699               DNP
chooky Y Blue Movies 1 1400 1699       5     HIT 1608
shortbreadforme27 Y Brown Movies 1 1000 1299     4       HIT 1125
bertie Y Brown H&M 1 1000 1299     4       HIT 1153
Bob47 Y Brown Geog. 1 1000 1299     4       HIT 1133
TABBYTOES Y Black A&L 1 2200 2399               DNP
Java Y Pink Lang. 1 1800 2099         6   HIT 1999


Day 4                            
Players Qualify? Colour Category RB Point Min Max Y G B B P B Status Challenge Score
Helen McKenzie DNQ                          
Nemesis Y Pink Lang. 1 1800 2099         6   HIT 1861
JMK DNQ                          
sally906 DNQ                          
Ruby Franks Y Green Lang. 1 600 899   3         HIT 876
tallyho Y Pink S&N 1 1800 2099         -6   PENALTY 1298
Allan R. Matthes DNP                          
vepa1943 Y Black Geog. 1 2200 2399           -7 PENALTY 2000
chooky Y Pink Ent. 1 1800 2099         6   HIT 1915
shortbreadforme27 Y Green Movies 1 600 899   3         HIT 831
bertie Y Green S&L 1 600 899   3         HIT 698
Bob47 Y Green S&L 1 600 899   3         HIT 735
TABBYTOES DNP                          
Java Y Green A&L 1 600 899   3         HIT 868


Everybody feel free to reconcile, verify with their own residual brainoff records, or just plain disagree.

It is a hallmark of ALL my tournaments. EVERYTHING is verifiable.


Knows 101 facts
like | send message


Sat 18 Feb 17 #12 
FactaCupAdmin
Member

Colour monitoring as at the expiry of the Day 5 Red Ball Challenge:

Player Day 1 Colour Day 2 Colour Day 3 Colour Day 4 Colour Day 5 Colour
Helen McKenzie Brown Blue Pink    
Nemesis Green Brown Blue Pink Black
JMK Pink Blue Black   Brown
sally906 Pink Blue Brown   Green
Ruby Franks Pink Blue Brown Green Black
tallyho Green Brown Blue Pink Black
Allan R. Matthes   Pink Blue   Brown
vepa1943 Green Pink Blue Black Brown
chooky Green Brown Blue Pink  
shortbreadforme27 Pink Blue Brown Green Yellow
bertie Pink Blue Brown Green Yellow
Bob47 Blue Pink Brown Green Yellow
TABBYTOES   Pink Black    
Java Brown Blue Pink Green Yellow



Knows 101 facts
like | send message


Sat 18 Feb 17 #13 
FactaCupAdmin
Member

jmaxg here speaking under my pseudonym of FactaCupAdmin.

This is the Day 5 status while we wait.....

Day 5                            
Players Qualify? Colour Category RB Point Min Max Y G B B P B Status Challenge Score
Helen McKenzie DNQ                          
Nemesis y Black Lang. 1 2200 2399           7 HIT 2250
JMK Y Brown S&N 1 1000 1299     4       HIT 1057
sally906 Y Green Lang. 1 600 899   3         HIT 748
Ruby Franks y Black Lang. 1 2200 2399           -7 PENALTY 2103
tallyho Y Black S&N 1 2200 2399           -7 PENALTY 1853
Allan R. Matthes Y Brown H&M 1 1000 1299             MISS 1304
vepa1943 Y Brown H&M 1 1000 1299               DNP
chooky DNP                          
shortbreadforme27 Y Yellow Lang. 1 90 499 2           HIT 227
bertie Y Yellow Misc. 1 90 499 2           HIT 319
Bob47 Y Yellow Movies 1 90 499             MISS 1395
TABBYTOES DNP                          
Java Y Yellow S&N 1 90 499 2           HIT 250



Knows 101 facts
like | send message


Sat 18 Feb 17 #14 
Ruby Franks
Contributor

I've never thought of you as the reserved sort. :)




Knows 135573 facts
like | send message


Sat 18 Feb 17 #15 
jmaxg
Contributor

Ordinarily I'm not.

But I do have this thing for procedure that can be interpreted as paranoid.

Once a clerk, always a clerk I guess.

The logic is pretty hard to shake it seems.




Knows 33692 facts
like | send message
1 person likes this post


Sat 18 Feb 17 #16 
vepa1943
Member

I miss my 5th day challenge - brown history... :-(




Knows 50998 facts
like | send message


Sat 18 Feb 17 #17 
shortbreadforme27
Contributor

Mindbenders to the fore.




Knows 175750 facts
like | send message


Sat 18 Feb 17 #18 
FactaCupAdmin
Member

3RD POT BLACK TOURNAMENT - 13 TO 17 FEBRUARY 2017 - OFFICIAL RESULT

1ST PLACE - NEMESIS - FINAL SCORE: 30 POINTS

2ND PLACE - SHORTBREADFORME27 - FINAL SCORE: 27 POINTS

3RD PLACE - BERTIE - FINAL SCORE: 26 POINTS

MANY THANKS TO ALL TOURNAMENT PARTICIPANTS - LET'S SEE YOU ALL BACK FOR POT BLACK 4




Knows 101 facts
like | send message
1 person likes this post


Sun 19 Feb 17 #19 
Helen McKenzie
Contributor

Congrats to the podium winners!!




Knows 25291 facts
like | send message


Sun 19 Feb 17 #20 
Nemesis
Editor

Thanks Tin Man, and to all the players.  This is a tricky tournament to get right as it involves resisting the urge to click answers, and then watch them drain away.  Definitely unnatural!

 




Knows 72817 facts
like | send message


Sun 19 Feb 17 #21 
Nemesis
Editor

Now that you've mastered conditional formatting, the logical next step is to force players to choose a different category as well as a differently coloured ball.  That would seriously mix things up.




Knows 72817 facts
like | send message
1 person likes this post


Sun 19 Feb 17 #22 
Ruby Franks
Contributor

As always, congratulations to the Captain and other podium placed players.

I had thought that the twist this time was going to be choosing a different subject each shot. HOWEVER, my personal preference is that the choice of ball is up to the player so colours could be repeated, but hey, there are quite a few spins (see what I did there?) on this game, which is part of it's genius.

Many thanks jmaxg.




Knows 135573 facts
like | send message


Sun 19 Feb 17 #23 
Allan R. Matthes
Contributor

Having to keep a score down so as to get points on a particular color is crazy. And remembering what colors you haven't played yet is also unfun. I thought the Jive was hard. This tournament rivals the Jive for complexity. I liked Pot Black when we could repeatedly pick the color we liked and shoot for a score in that range.




Knows 75012 facts
like | send message


Sun 19 Feb 17 #24 
tallyho
Contributor

Another trivia game that I used to play had their final challenge like this, however you could only pick a category and a color once.   Think about it, most of us picked our best category the entire time but the real challenge is knowing that you can only pick it once.   Don't get me wrong this is fun, but by letting us stay with one category still allows those power players an advantage.  




Knows 26939 facts
like | send message


Mon 20 Feb 17 #25 
jmaxg
Contributor

Congratulations to Nemesis as overall tournament winner and a well done to the 2nd placegetter shortbreadforme27 and 3rd placegetter bertie as well as a great big thanks to all tournament participants.

I will review the comments above and consider the points made relative to future tournaments. Many thanks for the advice.

You're right Captain.......incorporating the monitoring of subject categories would not be difficult if it came to that.

But I shall take heed of the informed advice and make my adjudications in good time.

(gotta stop watchin' that Tom Hardy "Taboo" show. It's gettin' in me noggin')




Knows 33692 facts
like | send message


Mon 20 Feb 17 #26 
tallyho
Contributor

You are the best jmaxg!




Knows 26939 facts
like | send message


Mon 20 Feb 17 #27 
sally906
Contributor

congrats to the winners. And simple game that is cunningly complex. I love it. Think I've got it now - changing subject as well as colour would add a delicious element of tease to it all. Would vote for that!




Knows 26810 facts
like | send message
1 person likes this post


Mon 20 Feb 17 #28 
JMK
Editor

Congratulations to the winners, well played.



Thanks Tinman for all the organisation and programs.

 

Having to choose a different colour and subject each day would really add some strategy to the game.




Knows 47318 facts
like | send message


Mon 20 Feb 17 #29 
shortbreadforme27
Contributor

Just a point the second and third placegetters have names as well they are Shortie and Bertie - it would have nice to heave been referred to by this instead of placegetter.




Knows 175750 facts
like | send message


Mon 20 Feb 17 #30 
jmaxg
Contributor

Sorry 'bout that......was in a hurry back then. Fixed up now.




Knows 33692 facts
like | send message


Mon 20 Feb 17 #31 
shortbreadforme27
Contributor

An honorable man all the best to you.




Knows 175750 facts
like | send message


Tue 21 Feb 17 #32 
jmaxg
Contributor

Punctuation! Punctuation would be good here!

But thank you Shorty. And additional congratulations to you and bertie.

Your monumental performances resulted in pressure decisions by players other than you.

My favourite decision was that of JMK and her "Black" call on Day 3. That was REALLY brave and if she had succeeded, it would have thrown tournament players into an uproar strategically speaking. It may have changed the result. Then again, eh (in the Canadian context)!

But still, I love the balls of it.




Knows 33692 facts
like | send message


Tue 21 Feb 17 #33 
FactaCupAdmin
Member

This is what it looks like monitoring subject categories as well as colours using "conditional formatting" WEF the end of this tournament:

Coloured Ball & Subject Category Monitoring
Player Day 1 Day 2 Day 3 Day 4 Day 5
Helen McKenzie Brown Blue Pink    
  Lang. Lang. Lang.    
Nemesis Green Brown Blue Pink Black
  Lang. Lang. Lang. Lang. Lang.
JMK Pink Blue Black   Brown
  Lang. Lang. Lang.   S&N
sally906 Pink Blue Brown   Green
  Geog. Misc. Misc.   Lang.
Ruby Franks Pink Blue Brown Green Black
  Lang. Lang. Lang. Lang. Lang.
tallyho Green Brown Blue Pink Black
  S&N S&N S&N S&N S&N
Allan R. Matthes   Pink Blue   Brown
    H&M Lang.   H&M
vepa1943 Green Pink Blue Black Brown
  Movies Misc. S&L Geog. H&M
chooky Green Brown Blue Pink  
  A&L S&N Movies Ent.  
shortbreadforme27 Pink Blue Brown Green Yellow
  Movies Movies Movies Movies Lang.
bertie Pink Blue Brown Green Yellow
  S&N Lang. H&M S&L Misc.
Bob47 Blue Pink Brown Green Yellow
  Lang. S&N Geog. S&L Movies
TABBYTOES   Pink Black    
    A&L A&L    
Java Brown Blue Pink Green Yellow
  S&L Movies Lang. A&L S&N

As you can see, it's busy but still not rocket science. The Excel formatting does all the work.

But we DO see, quite obviously, that things might change if we rotate subject categories as well as colours.

EDIT: I simplified the above table a little bit.


Knows 101 facts
like | send message


Tue 21 Feb 17 #34 
FactaCupAdmin
Member

jmaxg here speaking on behalf of FactaCupAdmin.

We have another problem that was not seen originally BUT which may prove to be a strategic anomaly.

High scoring choices like Black, Pink or Blue might be a problem if you choose them in the Day 1 to Day 3 phase of any tournament. You may choose them, but according to current rules if you PENALTY, you might be reduced to zero and nothing more depending on the day of play and scores incurred.

That means an early PENALTY on a Black, Pink or Blue (or other colour for that matter) means a deduction of maybe ONE or TWO POINTS as opposed to the full penalty. Not exactly fair OR it could be manipulated unfairly.

My impromptu thoughts to get around this are as follows:

1. The scores go negative. Whatever penalty you incur WILL be reflected even if it results in a negative score. The Zero points baseline will be removed.

2. Keeping the zero baseline in place, but higher scoring colours like Blue, Pink and Black cannot be applied until Day 4.

If you think that going negative on scores is ok, then that is ok by me. Rigging a positive score has always been a structural problem and a headache anyway.

But if you think other matters must be taken into consideration then so be it too.

Your opinions will be appreciated.




Knows 101 facts
like | send message


Tue 21 Feb 17 #35 
jmaxg
Contributor

Java inspired. She saw it. I didn't.

#shepersisted




Knows 33692 facts
like | send message


Tue 21 Feb 17 #36 
JMK
Editor

Personally I would like to see either a negative score or everyone starting with a base score of 7. Restricting when you can choose certain colours interferes with game strategy.




Knows 47318 facts
like | send message


Wed 22 Feb 17 #37 
chooky
Contributor

We're being plagued by connectivity issues at the moment (I blame the media) so I missed the last red ball.  Wah.

Personally, I like the negative score idea. And no restriction on when colours can be nominated




Knows 167843 facts
like | send message


Wed 22 Feb 17 #38 
sally906
Contributor

Ummmm - yes :)  I think negative is a good idea if it makes life easier behind the scenes.

Now if you could just make the calories negative in this chocolate cake I am eating I would be really happy and more than a little impressed!!!




Knows 26810 facts
like | send message
2 people like this post


Thu 23 Feb 17 #39 
jmaxg
Contributor

LOL!

Mmmmmmmm...chocolate cake.




Knows 33692 facts
like | send message


Thu 23 Feb 17 #40 
jmaxg
Contributor

Keeping in mind this tournament and it's administrator are still working things out to the best of everyone's abilities, it is still technically a "work in progress".

But I think, with effect next tournament, we will have a go with the "cycle coloured balls/cycle subject categories" approach. It might not be the final form. But just one tournament run on that basis couldn't hurt.

Just to be obvious, WEF (with effect) the next tournament, no player will be allowed to choose the same coloured ball twice and neither will they be allowed to choose the same subject category twice. FactaCupAdmin will look after the monitoring of that condition.

I will also remove the zero baseline for all scores so if you PENALTY on Day 1, regardless of the colour, it will affect your OVERALL score and there is no more "the next day, start again". If you end up with a negative score, you will have to dig your way out as a player using planned and focused game play and good coloured ball/subject category selections as well as remembering you cannot use the same selections twice during all five days of play.

WOW! Day 1 will probably look different now!

Last Question:

Should negative scores show up on The Big Board?

I can do it either way showing only above zero scores on The Big Board but keeping track of all scores on my secondary score board. After Day 5 is declared final, I can post ALL scores if wanted.

Or, The Big Board can show negative scores all along.

Your opinions please.




Knows 33692 facts
like | send message


Thu 23 Feb 17 #41 
jmaxg
Contributor

Having a think about it, I have just answered my own question.........YES, OF COURSE negative scores must be reflected now the zero baseline has been removed!

Players only know as much as they are told. IF I kept negative scores off of The Big Board, then players would not know if they in a hole and worse, if they are in one, how deep. They have to know how to plan their way out.

My secondary board always shows it, but you players don't get to see that.

So YES, The Big Board will have to show scores relative to all players be they positive, zero or negative.




Knows 33692 facts
like | send message


Thu 23 Feb 17 #42 
jmaxg
Contributor

And yet ANOTHER thought to those just in case they asked the question......

Is it possible, given the new conditions relative to scoring (negative and positive scores included) to STILL not show up on The Big Board?

Yes. But it would be hard to do as an entrant. You would have to NOT QUALIFY on every Red Ball Challenge from Day 1 to Day 5.

You must at least score a "1" for a successful Red Ball Challenge to actually show relative to the tournament scores in any way.

It's not impossible, but still, it's not something that an entrant of any tournament would want to jump up and down about.

"I showed up and did not score in any way! Yay for me!"

"Really? Then why did you show up in the first place?"




Knows 33692 facts
like | send message


Thu 23 Feb 17 #43 
Helen McKenzie
Contributor

Well i shall have to find my shovel as i will be doing a lot of digging lol, but it all sounds like a good start. It is good to try different aspects of the game and find which one suits best.




Knows 25291 facts
like | send message


Thu 23 Feb 17 #44 
sally906
Contributor

I've bought a new shovel - it's all bright and shiny with a boomerang for a handle so it will come back if I throw it away in a 'poor bugger me' tantrum!




Knows 26810 facts
like | send message
1 person likes this post


Thu 23 Feb 17 #45 
jmaxg
Contributor

Remember to either buy or make yourself a periscope as well.

It is good to look above the hole even while sitting in it.

Just ask the ANZACs.




Knows 33692 facts
like | send message
1 person likes this post


Thu 23 Feb 17 #46 
FactaCupAdmin
Member

Relative to vepa1943's post (#16 above).....

It was not made clear whether or not you missed it because you were not able to play it in time (24 hr expiry) OR it didn't show up in your userID brainoff list.

All players please understand that such anomalies MUST be reported to either the tournament administrator (FactaCupAdmin), the tournament overseer (jmaxg) or our site Boss (JMK) in a timely manner so it can be addressed just as quickly and the problem assessed.

If it is because the brainoff was sent and just not played in time, then that is not a Factacular.com problem.

But if the brainoff was not received into a user's brainoff list, then that IS a Factacular.com problem.

When reporting problems such as that, you MUST be specific either way.

For the record, this is the coloured ball challenge sent to vepa1943 on Day 5.


Knows 101 facts
like | send message


Thu 23 Feb 17 #47 
Helen McKenzie
Contributor

I also have my goggles and snorkel......goggles so i can still see and snorkel so i can still breathe whilst in my hole, and ill take your advice for the periscope jmaxg.




Knows 25291 facts
like | send message
1 person likes this post


Thu 23 Feb 17 #48 
Helen McKenzie
Contributor

As ANZACs Sally and i know how to come prepared




Knows 25291 facts
like | send message
2 people like this post


Fri 24 Feb 17 #49 
sally906
Contributor

To true Helen - Dib dib dob dob - always prepared!!  Have bully beef and ANZAC biscuits as well - she'll be right!




Knows 26810 facts
like | send message
2 people like this post


Fri 24 Feb 17 #50 
Helen McKenzie
Contributor

Along side a good ole barby




Knows 25291 facts
like | send message


Fri 24 Feb 17 #51 
Ruby Franks
Contributor

I'm going with the flow, never prepared for anything; happy that there should be  no restriction on when players go for high scoring balls,there are some tactics in Pot Black even when they are only about geeing up opponents.

My preference is that choice restriction should be on subject only, but I suspect that could be because it might favour me.




Knows 135573 facts
like | send message


Sat 25 Feb 17 #52 
jmaxg
Contributor

And that is what is being looked at Ruby. Whether suggestions might be self ingratiating or not might not be known until you play them all out.

I am pretty sure that some of those who are making suggestions are not 100% sure of the outcome due to unseen dynamics but their suggestions might be subconciously beneficial.

But that's fine. As this is a new tournament worked out from the ground up, this type of response is helpful. A couple of further runs and we should have the finicky things worked out hopefully to everyone's satisfaction.

Then the last tweaking factor from tournament to tournament is left up to me. And that right is at my discretion and mine alone entirely.

Mmmwuahahahahaha...*cough....*cough...

(Hack! Ugh! I'm not very good at this villian stuff)

 

 




Knows 33692 facts
like | send message


Sat 25 Feb 17 #53 
jmaxg
Contributor

"Dib dib dob dob?"

Isn't that the Scouts?

*looks again.....

Ahhh...."always prepared"....got it.

Just mixed it up with the whole ANZAC thing and......ya know what? Never mind.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #54 
jmaxg
Contributor

Further on Ruby Franks' post above......

I would like to see how such a scenario - no cycling of coloured ball selection but cycling of subject category selection - plays out.

I am keeping it in mind for a future tournament. Not the next, but maybe the one after that.

Other posters have already made it clear that they prefer it. But still, one version at a time.

Thanks anyway Ruby.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #55 
jmaxg
Contributor

WAIT! Wait, wait wait.......

I think that the posters that think that being able to choose the coloured ball, even on multiple days, and having the subject category cycling IS THE ANSWER!

Look at it this way.....

After you pot a red ball, let's assume that the coloured ball choice is whatever you want......yellow, green, brown, blue, pink or black.

BUT the only thing you might not have control of is the angle with which to pot it. So what if the angle of the shot is replaced with a RANDOM subject category?

Yup! You don't even get to choose it. The tournament administrator allocates the subject category randomly and it's never repeated during all 5 days of play.

There is a "random" function within Excel that allows me to do that.

Oh, we GOTTA try this!

But please, give me your opinions.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #56 
Helen McKenzie
Contributor

Yes! i like that idea jmaxg, in my mind that doesnt give anyone any more advantage than anyone else, except on ball choice.




Knows 25291 facts
like | send message


Sat 25 Feb 17 #57 
jmaxg
Contributor

Current variations are as follows:

1.  Choosing coloured ball and subject category repeatedly. Result? Didn't work.

2.  Cycling coloured ball and choosing subject category. Result? Better, but still didn't work as well as we thought.

3.  Cycling coloured ball AND cycling subject category. Result? Unknown.

4.  Choosing coloured ball BUT cycling subject category. Result? Unknown.

5.  Choosing coloured ball BUT randomly selecting subject category. Result? Unknown.

Of the above, Options 3 to 5 are obviously the most dynamic and unpredictable.

Of Options 3 to 5, I think Option 5 would be the most unpredictable of that which should be unpredictable.

For your information.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #58 
jmaxg
Contributor

PLUS.....with a random subject category appointment rather than selection, it opens up the entire TEN (10) subject categories for application whether players like it or not.

They would not know of their subject category until they saw the title of their Coloured Ball Challenge.

And NOW I am thinking, to make the angle even more difficult, you don't even get to know of the subject category. You just see a title that is a coloured ball challenge and you don't know what subject category it might be.

Just like the Java Jive......you just play and keep your fingers crossed.

*evil thoughts popping up in my head




Knows 33692 facts
like | send message


Sat 25 Feb 17 #59 
jmaxg
Contributor

Just like the game of Snooker (and pool, billiards, etc.), the ball is selected by the player. But the angle might be difficult or, on occasion, random and must be overcome.

I think that a random subject category allocation would do just as well and, even better, the player doesn't actually know what angle (subject category) it is until they play it.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #60 
jmaxg
Contributor

I bet this is what Ruby Franks intended........just not as evil-ish.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #61 
JMK
Editor

3 would be my choice. I hate the idea of 5.




Knows 47318 facts
like | send message


Sat 25 Feb 17 #62 
jmaxg
Contributor

But FOR THE MOMENT and with respect to the next tournament, we still need to see how the dynamics of 5 days, 5 different coloured ball selections and 5 different subject category selections works out.

(along with the removal of the minimum score baseline)

Plus, I did the fancy, shmancy spreadsheet above. That took me a while so I wanna use it.




Knows 33692 facts
like | send message
1 person likes this post


Sat 25 Feb 17 #63 
Helen McKenzie
Contributor

Im liking the evil thoughts lol




Knows 25291 facts
like | send message


Sat 25 Feb 17 #64 
jmaxg
Contributor

So am I Helen. BUT, alas, and properly, it should be one step at a time.

We'll save the truly evil version for the last one if it comes to that.




Knows 33692 facts
like | send message
1 person likes this post


Sat 25 Feb 17 #65 
jmaxg
Contributor

Despite my posts above, we have to go through the development of this tournament step by step and 1 by 1.

There is a version above that will end up being the final tournament reality. But we won't know until we try out ALL versions.

I know I sounded excited when coming up with a different tournament version above. But the truth is we have to play this by the book in order for it to become the best tournament it can be. NOT the best Factacular tournament overall. I don't presume that. But after we get it right, I want it to be able to stand alone and be one of the most preferred, if not respected.




Knows 33692 facts
like | send message
1 person likes this post


Sat 25 Feb 17 #66 
Helen McKenzie
Contributor

I am sure you are already respected




Knows 25291 facts
like | send message


Sat 25 Feb 17 #67 
sally906
Contributor

I'm a bit worried about the sound of 5 - sounds disheartening - but willing to give it a try when you get that far. Haven't tried 3 yet - but is sounding good in theory 




Knows 26810 facts
like | send message


Sat 25 Feb 17 #68 
jmaxg
Contributor

With respect to the next tournament, I will be opening by paying respect to the players who have contributed to the overall structure and conditions of the competition.

I will list those names now and if you have a problem with being pointed out, let me know and I will remove you from the list.

The names are:

Allan R. Matthes
chooky
Helen McKenzie
Java
JMK
Nemesis
Ruby Franks
sally906
Seve
shortbreadforme27
tallyho
vepa1943

 

You will be listed as "contributors".

The list may expand based on future tournaments. But if you want out now, let me know.

Explanatory note: I have scanned the last three Pot Black tournaments in order to compile this list.




Knows 33692 facts
like | send message


Sat 25 Feb 17 #69 
jmaxg
Contributor

IF I have left someone out based on the above list, please let me know.

Due to a brain fart, I almost left Helen McKenzie off of the list and that would've been a tragedy.

She could not qualify a Red Ball Challenge worth a damn BUT, she gave great advice!

THAT is the important part.

Despite me saying I have scanned all three of the Pot Black tournaments, if you say I missed you, then I need to be told.




Knows 33692 facts
like | send message


Sun 26 Feb 17 #70 
Helen McKenzie
Contributor

Awww thanks jmaxg, I think I have got the hang of the tournament now


Knows 25291 facts
like | send message


Tue 28 Feb 17 #71 
jmaxg
Contributor

You're welcome Helen. You are one of the reasons this tournament is getting better and better.




Knows 33692 facts
like | send message
3 people like this post


Tue 28 Feb 17 #72 
Helen McKenzie
Contributor

Thanks for that jmaxg




Knows 25291 facts
like | send message


Tue 28 Feb 17 #73 
jmaxg
Contributor

Did I do something extraordinary? I think not.

Helen's help WILL result in a better game.

All I do is follow the trend.




Knows 33692 facts
like | send message
1 person likes this post


Tue 28 Feb 17 #74 
jmaxg
Contributor

Thank YOU Ms. Mckenzie.




Knows 33692 facts
like | send message
3 people like this post


Tue 28 Feb 17 #75 
jmaxg
Contributor

Looking back over my above posts.

I am so glad you guys agreed to showing negative scores and thus removing one of the aspects of this tournament that has been a pain-in-the-arse everytime I ran it.

Thanks for that. It's gonna make things a lot easier and a lot slicker.

Find yourself in a hole from Day 1? As the above posters indicated, find yourself a trustworthy shovel and dig your way out.

Your negative status will show on The Big Board so expect no relief there.

But if you come up from behind, as my Java did, then you will be noticed.

(admittedly she bounced back from a zero baseline after Day 1. But if you review the above, she got it, moved forward and ended up in fifth place)

That's all one should expect from a great example. Not terribly brave, just consistent.




Knows 33692 facts
like | send message
2 people like this post


Tue 28 Feb 17 #76 
Ruby Franks
Contributor

I find your post #57 almost as poetical as the haikus of Donald Rumsfeld.

Looking forward to the next PB.




Knows 135573 facts
like | send message


Tue 28 Feb 17 #77 
JMK
Editor

Pot Black Tournament

First  the red ball challenge shot

Then the coloured ball.




Knows 47318 facts
like | send message
2 people like this post


Thu 2 Mar 17 #78 
jmaxg
Contributor

1st line is 5 syllables.

2nd line is 7 syllables.

3rd line is again, 5 syllables.

Can confirm.....the above is a "Haiku".




Knows 33692 facts
like | send message


Thu 2 Mar 17 #79 
jmaxg
Contributor

A Haiku for those that don't know is a Japanese style of poetry based on strict syllambolic rules.

It should be based on A subject and not vary. But given the rigour of the conditions, some Haiku poems do vary.

But the rules of a Haiku are as follows:

1.  The first line should contain 5 syllables.

2.  The next should contain 7 syllables.

3.  The final line should again show only 5 syllables.

It is an exercise in discipline within a defined structure as well as creativity and imagination.

The point of a Haiku is that it can come from anywhere and at anytime and thus might be seen as free-ranging expression even given the retraints of the structure.

But it can be focused as well as JMK's above Haiku is an example. I even gave it my own shot.....

"To win is to smile.

To lose can be personal.

To wonder is life."

As you can see, not the best poem of all time. But IT IS Haiku specific.




Knows 33692 facts
like | send message


This topic is now closed.






   About - Terms - Privacy Log In