The Dark arts - C&D Master Thread

[kjn]

Yeah, the sheet should be fully updated now with the current demo screen.

CivFr has 4000 from techs now (Hunting, Mining) in both the tech sheet and the power sheet (value in red there, ie it pulls from the tech sheet).

[SevenSpirits]

Well they arn't actually saying much. This is the player in question. Just about the only time he posts it looks like is in the private forum (only 6 of his 268 posts are publicly viewable, and they're all about setting up the DG), so there's no way to find out how good he is at C&D. Maybe a Locke immitator?

He's one of the people we wouldn't let onto our team, remember? So he headed to CFC. He has an account here too.

[mostly_harmless]

... Anyway, this is only the first real attempt I've done at C&D myself, and no-one seems to have complained about my efforts so far. ...

No reasons to complain. You are doing a fantastic job on the C&D!

As for the building tracking: Sort it by Civ then City on the x-axis (ie. columns) and have a list of all city improvements on the y-axis (with the most common ones on top and with their soldier points assigned to them).
Then its just a matter of switching each field from 0 to 1 and feed each cities soldier sum into the power rating sheet.

mh

[kjn]

Another little tidbit: it was CFC who got the forest growth on T3.

Rival worst life expectancy is 62 now, and that is reached by 5 health / (3 unhealth + 5 health).

We know the Spanish and CFC started with 66, for 4 health / (2 unhealth + 4 health), and then one of them increased their values to 5 health / (2 unhealth + 5 health) or 71.

If the Spanish had got the forest growth, then rival worst would be 4 health / (3 unhealth + 4 health) or 57 once CFC grew to 2.

For that matter, since CivPlayers are rival best now, we know they have a 87 life expectancy. That means they have at least six forests in their BFC: 7 health / (1 unhealth + 7 health).

That comes from:

+2 difficulty
+2 fresh water
+3 from 6 or 7 forests
-1 1 pop

For comparison, we'd have gotten 8 forests in our BFC if we had settled 2N.

[kjn]

I've set up a Score breakdown C&D sheet now, similar to the Power sheet.

It pulls in values from the Pop, Tech, and Wonders sheets, and puts them together. The trouble is the Land sheet, and pulling the correct value (ie the most recent one) from that sheet.

I think we can do it using this method:

Enter the current turn number somewhere in the sheets. Score or demos, or somewhere else. Then refer to that turn number, and use that one to find the correct row in the Land tab, getting the score from land.

Is there anyone able and willing to set that up?

(I can also use that function to pull rival best, average, and worst values from the Demos sheet, which would be helpful.)

[kjn]

Apolyton, Univers, and the Spanish have ended their T18.

Updated demos:

Univers has left their 5F6H configuration, and are probably back on 8F3H or similar. I expect they will have a high food tile up on T21 or T22.

A team on the ball will note that we've left our capital unguarded by watching the approval rates.

[kjn]

CivFr has ended turn, and I think they've chosen an undiscounted tech from the GNP rankings.

[kjn]

I've managed to solve the dynamic cell reference problem, and could thus automate a bit more in the C&D sheets.

Some notes for those reading or updating the sheets:

Cell A2 in the Score sheet should always contain the current turn number.

The Power and Score breakdown sheets use the current turn number (in the above cell) to find the most recent data from the Demos and the Land sheets.

I've changed how the Score breakdown sheet works. The reported score has to be entered manually, then it fetches the integral values, and reports any difference as Unknown points.

The Power sheet needs some work - I'd like it to look a bit like the Land sheet, and give a tabulated breakdown between the reported values and those we have assigned, with any differences between the two clearly noted.

[kjn]

T19 - 3240 BC

Demos:

Cliff's Notes: Spanish and CivPlayers reached 2 pop, and the Germans researched The Wheel.

Three score increases this turn, two pop growths and one tech.

Spanish and CivPlayers are the last to grow their cities to size 2. GNP or production didn't move, but food did increase marginally.

Global soldiers rose 6000, of which 2000 was population.

I had expected rival worst in life expectancy to decrease to 57, but it has stayed put at 62. Maybe either the Spanish or the CFC has both received forests growth, or there is something else that has happened.

I expect WPC to have finished their worker this turn or maybe T18 (the last team to get one). I expect the Spanish and CFC to get their warrior next turn. The Germans, Apolyton, CivFr, Univers, and Apolyton has finished warriors recently.

That leaves it as tech only. I think the Germans have researched The Wheel, for the entire remaining 4000 increase in power. They could reach 108 beakers in 10 turns since they got 8 beakers in overflow from Hunting (which they got on T9). They will probably research Pottery next.

ETA: That also fits with us dropping from #3 to #4 in Power.

[Sullla]

Wheel is a logical tech for them to research. They already have Agriculture and Hunting, after which all of the teams have three options:

1) Wheel/Pottery
2) Mining/Bronze Working
3) Animal Husbandry

One of the neat things about this map is that all of these paths are fairly viable. There are cows at our start, and therefore likely there for everyone else too, making AH attractive. Mining/Bronze Working/Slavery will always be a strong path. And with the need for commerce on this map and floodplains at the start, Pottery/cottages become a more important tech. Interesting though that the German team (which is not Financial) wants to get those cottages going.

kjn, which path do you peg the other teams as going after? We are obviously on the Wheel/Pottery path. I can fill in a couple of them:

1) Wheel/Pottery: our team, German team
2) Mining/Bronze Working: Spanish Apolyton, CivFanatics
3) Animal Husbandry: We Play Civ

A lot of guesswork here, but having an idea of what the other teams are pursuing definitely helps.