[PB67] Charriu promotes the arts

[Amicalola]

Lovely piece.

[Charriu]

Glad someone is enjoying the music.

[Charriu]

Since there isn't too much to write about in these early turns I have some time to show you my current iteration of the planning spreadsheets I'm using. Two things before I start showing you stuff:

- Feel free to copy each and every spreadsheet for your personal use. Every spreadsheet is independent of the others.
- You will find that I work with three important colors in these spreadsheets. Orange tinted cells are were calculations happen that. Basically don't change a value here. Green tinted cells are values that one can add. Yellow tinted cells do contain calculations like the orange ones, but sometimes you need to replace the calculation with a fixed value.

Calc


Here you will find different smaller calculations that didn't warrant a spreadsheet of their own. Among those:

- A distance calculator for distance between tiles
- A MaxPlotDistance calculator mainly for the important maintenance calculations
- A combat odds revertor, for when you want to know what the odds for the other side are
- Some simple max land tile calculations
- How many turns each improvement needs on each terrain

LongTermCost


I use this spreadsheet to pre-calculate how much maintenance I have to pay for my cities in the future. You put in some basic map information and the civics you are planning to run in the fields above. Then you put in all your cities with their pop and distance to the next government building in the fields in the middle. If you did that the spreadsheet will tell you how much total city and civic maintenance you will have to pay for these values. This is very useful once you have laid out a dotmap and you want to know how much commerce you will need to pay for this.
Be aware though this is trait independent meaning if you are AGG or ORG you need to make a few adjustments in this spreadsheet.

Naming
No screenshot this time to avoid spoilers for anybody. Very simple spreadsheet in which I just collect all the city and worker names. You can also test if your city name fits into the city name box.

Combat Calc


This isn't my own creation. I stole it somewhere and forgot where. Basically calculate the odds for a single fight.

Bulbs


Here you can find the bulb order of each great person. As you can see you if you provide the correct data in the fields left above, you will also see the actual tech cost. Now the interesting field is the Population field. If you put in your total population across your civilization here, the spreadsheet will tell you the maximum value each bulb from each person is worth and the tech cost will be color coded to easily see if the value is below, near or above the max bulb.

Corporation


This is a leftover from PB59. The idea was to see how much each corporation earns according to the resources at hand. You can then plan, which city should get which corporation.

Tech Track


This spread helps tracking the techs of one player. For multiple players just copy this spreadsheet for each player. As you can see in the upper part is a spreadsheet representation of the in-game tech tree. There are also 3 cells telling you how many techs, base beakers and modified beakers the player invested. In the lower section are some calculations and importantly some input fields. Here you just make an x for each tech the player definitely has and each tech the player can research. The idea behind this is to use the information from Alphabet and the tech info section in the foreign advisor to reverse engineer what techs the player has and present it in a visually more pleasing way.

CityPlan


With this spreadsheet you can pre-calculate how much yields a city generates and how much population it can support. As you can see there are 20 rows representing the 20 tiles of a city plus an extra row for the city tile itself. You write down each tile here and which improvement you want to use and then the spreadsheet will tell the yields and pops in the row below. Below that you can also activate certain civics/techs/etc. with an x.
I use this spreadsheet to compare cities during the dotmapping phase. For this I just copy the spreadsheet for each city I am planning to use.

Turn Planning


Last but not least the heart of my planning spreadsheets. A "simple" micro planning tool. To be fair there is a lot in it, which would take way more time to explain. Here a summary of what this spreadsheet can do:

- Plan your civics
- Plan your tech path according to your cities output
- Plan when to run the slider to which percent
- How much maintenance you have to pay including all the maintenance types
- Track how many units you have for the maintenance calculation
- Plan what your workers will do
- How much each cottage provides in commerce and when it grows after working it a certain time
- A section for each city. Basically copy these columns for each city
- The city section includes almost everything the city produces.
- You can assign each worker in a city

TL:DR I more or less reimplemented civilization 4 in a spreadsheet.

I use this spreadsheet heavily to do my microplanning. If used correctly I don't ever need to run a sim in-game. This is also why I started constructing this. Running the sims is nice, but it takes a lot of time and you have to document each thing while simming. With this spreadsheet I'm a lot faster, can do it from every PC without requiring the game itself and it also serves as a documentation of what and when to do. At the same time I don't need to any calculations myself. For example for these early turns I just assign

- the worked tiles
- what to produce in the city
- what to tech

and everything else is calculated in the spreadsheet. If I want to make another test or variation, I just copy the spreadsheet.

[Charriu]

The song



Music: RebeccaETripp - Final Fantasy XII 'Final Fantasy Forest Medley' OC ReMix

RebeccaETripp is a force of nature. I don't know how else to describe here. Her output of arrangements is astonishing and the quality only got better with each year. It's amazing.  This piece here is her debut on OC ReMix from 2015 and since then I think she produced 2-4 remixes each month or so!

Since my scout is traversing a bigger forest I found it fitting to find forest music for this turn report. In this piece you will find multiple forest themes from Final Fantasy games. And this isn't done in the standard medley way, where you have a song -> transition -> another song. No, Rebecca is jumping between all different themes without a lot of transitions and sometimes playing multiple themes together. And the amazing thing is it works. I won't spoil when and where each theme begins as it quite fun to recognize that yourself.

As for buying this piece, you don't have to. This music is from Overclocked Remix and if you haven't heard about them then boy have you a lot to catch up in terms of VGM. They are most certainly the biggest community around remixes of video game music in all kinds of different genres. They also frequently provide album projects around a single game. They worked with different game companies to do soundtracks like for example Capcom and composer of video game music frequently also do remixes on OC ReMix. You can be sure that you will here a lot more from OC ReMix here.[/url].

T17:

---

As you can see more land has been uncovered in the west. Looks like we have an ocean there too.

Meanwhile a neat little microplanning moment happens in my capitol. While planning I noticed that I'm 2 foodhammers short of getting the settler out one turn earlier. I noticed that if I delay the warrior by 1 turn I can overflow 1 hammer into the settler, when my capitol grows to 3 pop. Still short of 1 hammer I plan to work a plains forest next turn instead of the sugar forest tile. This allows me to overflow 2 hammers into the settler. At the same time the capitol still grows to pop 3 with then 0 food in the box. All in all this allows me to get the settler 1 turn earlier.

I also had some more interaction with Tarkeel.

Congratulations on being the first to AnimalHusbandry!
are you interested in sharing details about what kind of location the horses are in? I'll trade for knowledge of how copper is located once my BronzeWorking comes in

Yeah we can do that. But I haven't scouted your territory yet. When do you expect to research BW?

I haven't scouted yours yet either; I was thinking more a general description
Current microplan has it finishing T20, but that might change

Then let's exchange that info when you have BW. By that time I possibly know about other horse locations.

no rush at all ?
I can't even guarantee that I know where my own copper is at that time, but that would also be relevant info to trade

Tarkeel also told me that he is doing C&D. I think he doesn't know if I do it, but may expect I do from the way we talked about the other players. We also agreed to stop espionage at 42 if possible.

I was thinking about when we meet other players, and in what general area they are, so you can seek or avoid contact as you want

Oh yeah. We can totally do that. Just realized. Diplo is so much easier when you are in the same general timezone area

that, and when you can use chat instead of more formal messages
Good intentions also factor into it ?

As you can the first steps of working together have been made. And around T14 or so Tarkeel came back with this:

Mjmd just arrived at my capital from my SE, so he's probably to the E of you

OMG we are neighbors again? Haven't met anyone yet. Feel free to tell him where I am.

There's really only so many ways to place 6 players on a map, but I know the feeling

I had a great laugh about that. Can't wait to meet Mjmd. Also interesting that Tarkeel thinks I don't like neighboring Mjmd.

[Charriu]

Score increase from land tiles 1st ring came in and although I don't do C&D I found it somewhat interesting to see the difference in starting locations. Looks like we have quite different starts. Tarkeel and Mjmd seems to have land locked starts like I do, while Ginger & GKC and Bing started on the coast with at least 4 water tiles. Superdeath moved his settler.

[Miguelito]

Have you considered exchanging starting area pictures with Tarkeel?

[Charriu]

We haven't talked specifically about screenshots. We do plan to share more map knowledge when Tarkeel has BW, which he might have researched just now. We also may share screenshots around T25 with my additional border pop.

[Charriu]

The song



Music: Andrew Thompson, Fernando Valencia, Kristy Mezines - Chrono Trigger 'Elements of Time' OC ReMix

Andrew Thompson is another great name in the VGM remix scene. Just check out his Youtube Channel, where he rearranges a lot of the classical games. I stumbled across him when somebody on the internet mentioned that he would have done a much better Secret of Mana OST for the Playstation remake and I have to agree strongly here.

Unlike the last arrangment this medley is more in the classical medley style. It starts fairly conservative and close to the original, but Andrew got me already with the first transition beginning around 0:30 going from one of the most dramatic songs in Chrono Trigger 'Lavos Theme' to one of the most relaxed ones 'Secret of the Forest'. A simple transition but so effective. In the following parts Andrew shows what a good ear he has for the instrumentation of the pieces he covered. And even though this part is also very close to the original Andrew manages to add or emphize parts in the original, which makes this piece even better like the low piano at 1:56.

But my absolute favorite part of this arrangement is when he transitions to the next song 'Ocean Palace' at 2:20. Andrew manages to amp up the tension to eleven with the violins and piano. So much even that the following song feels a bit relaxing at first even though it's also dramatic. Love it. Andrew continues with some brilliant parts on the piano starting from 3:13 before we go into the next song 'Corridor of Time'. Andrew manages to tint this song with some hint of Latin America. Very beautiful too and an excellent piece for the end of the song.

This is another Overclocked Remix song so everything I said last time applies here too.

T21:

---

I uncovered more land to my south and the warrior is also contributing. It really looks like the white spot may be the best second city spot for now.

I still haven't contacted anybody else, which is a bit unfortunate both for KTB and because I have to investe more espionage into Tarkeel. Speaking of him we had some more diplo.

(Yeah, I couldn't be bothered to hide my initial dotmap notes)

As you can see I'm waiting for the T25 border pop in the north-west. I will send you an updated screenshot then free of charge. ?



that's a very green and riverine capital

That's not my fault. ?
The clam in your capital feels a bit evil by the mapmaker

yep, need a city on that lake asap

I have to say I don't like what I'm seeing there. Tarkeels position demands he expands east and more importantly south towards me. As he mentioned my capitol is greener then his which might make him a bit jealous. That's why I tried to give him as few info about my northern territory as possible. Better he thinks I'm further south then I may actually be.
I think he moved his scout initially SW, which would require at least 4 turns to move towards the cows in his screenshot. I know he met me in T8 with his scout on the desert hill moving there would have needed at least 1 move. That leaves 4 scout moves unattended between us.
We continued our diplo about trade opportunities.

Was hoping there might be some river connecting us for early trade, but it looks like there is none.

There is a river leading into the lake on the west edge, but that's within the sphere I'd like to settle ?
you probably want to settle the very narrow bridge NE

You mean the river west of our first meeting spot?

yes not sure how far that river goes

We could use that river for foreign trade. We would both need sailing obviously.

Only one would need sailing, and one writing

I think this might be a good trading opportunity. I could connect to the river via a road thanks to my CRE trait and from there trade could start. As you can see Tarkeel is already making a stake for the land between us, which makes me think we are closer then I would like.
Last but not least the river and the lake to my north now have official names.

We should give the river and the lake it is flowing into names, so we can reference them in the future.

The lake is obviously the mediterranean sea ? so the river is the nile ?

[Miguelito]

Only one would need sailing, and one writing

Is that correct though? Afaik only the one with Sailing gets routes. (both can trade resources)

[Charriu]

Yeah I'm not so sure either that it works that way, but I will test that