[Imperial Historian]

Gnaw, I wasn't planning to take the hex, just remove the ancient so Tatts and I could reach the GC. I'd be quite happy if you used an influence action to claim the discovery and kept the hex. We have to remove at least one of these so we can take the GC sometime. 108 is a preference because there are less hexes I need to pass through.

Anyway because this is taking too long to reach agreement, I'll switch my move order around and upgrade first.

So upgrade cruiser with 2 improved hull over electron computer and in the blank space, and one positron computer over the hull.

Upkeep -3 £0 S0 M9

[Gnaw]

Imperial Historian, on 12 November 2013 - 06:57 PM, said:

Gnaw, I wasn't planning to take the hex, just remove the ancient so Tatts and I could reach the GC. I'd be quite happy if you used an influence action to claim the discovery and kept the hex. We have to remove at least one of these so we can take the GC sometime. 108 is a preference because there are less hexes I need to pass through.

Oh. Okey. I like that idea.

It's your turn btw.

[Imperial Historian]

Just edited my order into previous post

[Tattersail_]

So is it now Morgoth? He has a provisional upgrade yes? So its Cfs go?

[Galactic Council]

Round 4 Action Phase



Turn 1


Tatts

• Research Improved Hull
• Upkeep -5
• Bank $4, S8, M14
• Production $15, S6, M4

Gnaw

• research neutron bombs -2 sci
• -5 upkeep. 0, Sci 7, Ma 13

Twelve

• Research plasma missiles convert 6 materials to science
• 1$, 0S, 13 M upkeep -3

Imperial Historian

• research advanced mining
  
• Convert 3 production to 1 science,
  
• Upkeep -2 £0 S=0 P=9

Morgoth

• Research - Fusion drive and Fusion Source for 7 science
• $ 2, S 3, M 7,
• Upkeep - 5

CF - RESEARCH - Advanced labs


Tapper .- Research Gauss Shield for 2 science, (middle track).

Khell

• RESEARCH Fusion Source for 6 Science.
• $0, S2, M13

D'rek - RESearch Neutron Bombs for my next action.





Turn 2


Tatts -

• Research Point Defense put it on middle track - 9 science convert 4 materials into 1 science to cover this.
• Upkeep -7
• Bank $4,S0,M10

Gnaw

• Research Cloaking Device -7 science put on middle track
• $0, Sc 0, Ma 13. -7 upkeep

Twelve -

• Gnaw stick with my original provisional
• Build two orbitals in 310 and 318. Colonize them both with science.
• (1$, 0S, 2M Upkeep-5)
• Exchange Ambassadors with IH. Both send monetary gifts.

Imperial Historian

• So upgrade cruiser with 2 improved hull over electron computer and in the blank space, and one positron computer over the hull.
• Upkeep -3 £0 S0 M9

Morgoth provisional Upgrade - Add fusion source and fusion drive to cruiser Over existing components?

CF - Upgrade starbases - Imp hull on blank spot and imp. hull over one regular hull.

Tapper


Turn 3

Spoiler

Tatts -



Gnaw


Twelve




Imperial Historian

Morgoth



CF

Tapper

This post has been edited by Galactic Council: 12 November 2013 - 08:10 PM

[cerveza_fiesta]

Upgrade starbases

Imp hull on blank spot and imp. hull over one regular hull.

[Galactic Council]

Twelve, you're an excel guru. Can you come up with one for the rep draw?

CF built a grid of them 10 rows and 4? columns. As a number was drawn, that tile was removed, the last one in the stack taking its place. The discards were added to the bottom row.

I tried doing it using bulleted lists. Awkward.

I've now went to the rows and columns. But as I removed a tile,, the others slide down to fill that spot. The discards are placed back at the end of the section they came from. A one would go back to the first two shifting the rest of the stack down one spot. More awkward.

My goal was to have a system that would be verifiable and allow a re-build in case of computer failure. (I'm in the process of migrating from rotational internal hard drives to SSD and Firewire external to Thunderbolt. Lots of chances for data loss)

[twelve]

I wouldn't call me an excel guru. There are things I'm very good at in excel but there is a shit ton the program can do that I have no clue about. What exactly are you looking for? Aren't you using random dot org to do the tiles? along with the tech draws?

I probably won't have time to play with it until later this week. I have to get something done for a meeting tomorrow but I'll play around for about 15 minutes to see if I can't easily find a way to do something. What are the breakdowns for the 1s, 2s, 3s & 4s for whatever number of players game? Isn't the numbers different between a 6 and smaller game and a 7 and up game?

[twelve]

Never mind I found the breakdowns in the rules for both the expansion and base game.

[twelve]

Yeah Excell isn't a great choice for rep draws. It has a formula called Randbetween where you can return a random value between a top and bottom value. But every time you go into any other cell the random value you draw changes so determining when you "draw" the tiles is important as you will need to do a paste special values so you can lock down what was actually drawn. Plus you also run into the problem of returning the same tile especially when the draw pile starts to get small. I could probably throw in an if formula as well to avoid that issue but that still doesn't stop you from having to relabel the draw pile as tiles are removed.

Then again I could use reference cells to adjust the new draw pile....

Hmmm.....

I have some ideas but it would be a lot of work. There could be a lot of reusablilty once it's set up though....

But it all would boild down to when you actually deside that once you enter all the necessary information it's time to grab the tiles as every time you do anything with the spreadsheet the numbers in the Randbetween formula changes. I'll keep you posted. Now I'm intrigued.

[Tapper]

Hmm.

Influence. Flip a colony ship for 1 science. Remove disc from Aldebaran. Turn that colony ship face-up.

[D'rek]

Tapper, I think my best choice now is research advanced mining so I can get some decent material production, but it makes it less likely you'll be able to research it next round. Did you want me to go for something else instead?

[Galactic Council]

twelve, on 12 November 2013 - 08:59 PM, said:

Yeah Excell isn't a great choice for rep draws. It has a formula called Randbetween where you can return a random value between a top and bottom value. But every time you go into any other cell the random value you draw changes so determining when you "draw" the tiles is important as you will need to do a paste special values so you can lock down what was actually drawn. Plus you also run into the problem of returning the same tile especially when the draw pile starts to get small. I could probably throw in an if formula as well to avoid that issue but that still doesn't stop you from having to relabel the draw pile as tiles are removed.

Then again I could use reference cells to adjust the new draw pile....

Hmmm.....

I have some ideas but it would be a lot of work. There could be a lot of reusablilty once it's set up though....

But it all would boild down to when you actually deside that once you enter all the necessary information it's time to grab the tiles as every time you do anything with the spreadsheet the numbers in the Randbetween formula changes. I'll keep you posted. Now I'm intrigued.

The difference between the rep and everything else is the returns. Player X draws 3 tiles. That means the available number goes down by one twice during his draw. Let's say a One, Two, and Three. He keeps the Three but returns a One that was on his board.

It's the returns that allow so much room for error.

[Galactic Council]

Round 4 Action Phase


Turn 1

Spoiler

Tatts

• Research Improved Hull
• Upkeep -5
• Bank $4, S8, M14
• Production $15, S6, M4

Gnaw

• research neutron bombs -2 sci
• -5 upkeep. 0, Sci 7, Ma 13

Twelve

• Research plasma missiles convert 6 materials to science
• 1$, 0S, 13 M upkeep -3

Imperial Historian

• research advanced mining
  
• Convert 3 production to 1 science,
  
• Upkeep -2 £0 S=0 P=9

Morgoth

• Research - Fusion drive and Fusion Source for 7 science
• $ 2, S 3, M 7,
• Upkeep - 5

CF - RESEARCH - Advanced labs


Tapper .- Research Gauss Shield for 2 science, (middle track).

Khell

• RESEARCH Fusion Source for 6 Science.
• $0, S2, M13

D'rek - RESearch Neutron Bombs for my next action.

Turn 2


Tatts -

• Research Point Defense put it on middle track - 9 science convert 4 materials into 1 science to cover this.
• Upkeep -7
• Bank $4,S0,M10

Gnaw

• Research Cloaking Device -7 science put on middle track
• $0, Sc 0, Ma 13. -7 upkeep

Twelve -

• Gnaw stick with my original provisional
• Build two orbitals in 310 and 318. Colonize them both with science.
• (1$, 0S, 2M Upkeep-5)
• Exchange Ambassadors with IH. Both send monetary gifts.

Imperial Historian

• So upgrade cruiser with 2 improved hull over electron computer and in the blank space, and one positron computer over the hull.
• Upkeep -3 £0 S0 M9

Morgoth provisional Upgrade - Add fusion source and fusion drive to cruiser Over existing components?

CF - Upgrade starbases - Imp hull on blank spot and imp. hull over one regular hull.

Tapper - Influence. Flip a colony ship for 1 science. Remove disc from Aldebaran. Turn that colony ship face-up.

Khell - ??

D'rek - Provisional: Research Advanced Mining (-9 science)

Turn 3


Tatts -Im upgrading. Will do it in the morning. Goodnight


Gnaw - Provisional Build. details to come.


Twelve


Imperial Historian


Morgoth


CF


Tapper

This post has been edited by Galactic Council: 12 November 2013 - 11:05 PM

[twelve]

Yeah Gnaw. To draw something up to streamline the process will require way more time than I can devote to it at the moment. I'd recommend just entering a list in random.org and taking the top X results as the tiles drawn. Then adjust the list for the selected tile and reenter the list in the website for the next draw. Like I said I have some ideas and I think they may work but every time I get so far I realize I have to do additional reference cells and have to redo formulas and it kept snowballing on me. Trying to figure out how to return values from a new list is something I'm struggling trying to figure out. I didn't even get to the part where the new list is dependent on the data that is inputed based on the outcome of the draws which I knew was going to be a tricky part as well.

[twelve]

Galactic Council, on 12 November 2013 - 09:34 PM, said:

twelve, on 12 November 2013 - 08:59 PM, said:

Yeah Excell isn't a great choice for rep draws. It has a formula called Randbetween where you can return a random value between a top and bottom value. But every time you go into any other cell the random value you draw changes so determining when you "draw" the tiles is important as you will need to do a paste special values so you can lock down what was actually drawn. Plus you also run into the problem of returning the same tile especially when the draw pile starts to get small. I could probably throw in an if formula as well to avoid that issue but that still doesn't stop you from having to relabel the draw pile as tiles are removed.

Then again I could use reference cells to adjust the new draw pile....

Hmmm.....

I have some ideas but it would be a lot of work. There could be a lot of reusablilty once it's set up though....

But it all would boild down to when you actually deside that once you enter all the necessary information it's time to grab the tiles as every time you do anything with the spreadsheet the numbers in the Randbetween formula changes. I'll keep you posted. Now I'm intrigued.

The difference between the rep and everything else is the returns. Player X draws 3 tiles. That means the available number goes down by one twice during his draw. Let's say a One, Two, and Three. He keeps the Three but returns a One that was on his board.

It's the returns that allow so much room for error.

And I didn't even consider this little problem. Yeah definately won't be figuring this out anytime soon.

[Gnaw]

Tapper, on 12 November 2013 - 09:27 PM, said:

Hmm.

Influence. Flip a colony ship for 1 science. Remove disc from Aldebaran. Turn that colony ship face-up.

crap

I'm psychic: Research AntiM cannon next turn right?

[D'rek]

Darn, Tapper disappeared after posting. Well then...

Provisional: Research Advanced Mining (-9 science)

[Tattersail_]

Im upgrading. Will do it in the morning. Goodnight

[twelve]

So are we penciling in an upgrade order for Tatts as official so we can continue?