One for the mathmeticians

[Jaybe]

Here is the year list I based my 560 count on. It was produced to assist in keeping track of when trade (and other) agreements were made.

Filename is Treaty Years.doc; a 1-page MS Word document (don't forget to change the filename as you download it -- perhaps sometime the forum will stop messing with the filename).

Attachment Deleted (see corrected version below).

[Aeson]

It is 540.

For an Excel conversion from date to turn number: (has to be a valid Civ3 date, in column D in this case)

=IF($D:$D > 1950,$D:$D - 1950 + 440, IF($D:$D > 1750, (($D:$D - 1750) / 2) + 340, IF($D:$D > 1250, (($D:$D - 1250) / 5) + 240, IF($D:$D > 250, (($D:$D - 250) / 10) + 140, IF($D:$D > -750, (($D:$D +750) / 20) + 90, IF($D:$D > -1750, (($D:$D + 1750) / 25) + 50, IF($D:$D > -2750, (($D:$D + 2750) / 40) + 50, ($D:$D + 4000) / 50)))))))

Not very pretty, but it works.

[Aeson]

A table:

4000BC 1 turn, N/A years from previous turn
3950BC - 2750BC 25 turns, 50 years from previous turn
2710BC - 1750BC 25 turns, 40 years from previous turn
1725BC - 750BC 40 turns, 25 years from previous turn
730BC - 250AD 50 turns, 20 years from previous turn
260AD - 1250AD 100 turns, 10 years from previous turn
1255AD - 1750AD 100 turns, 5 years from previous turn
1752AD - 1950AD 100 turns, 2 years from previous turn
1951AD - 2050AD 100* turns, 1 year from previous turn

*2050AD is not a full turn, only a few automated events happen.

[Jaybe]

Thank you, Aeson.

The file I had posted has TWO duplicate columns in it. I thought I had deleted the one I had found earlier, but I hadn't (sorry). With Aeson's response I looked over it again and found the other duped column.

I post the corrected version for anyone who might be interested.

[alva]

Originally posted by Iotaq
P.S. Iotaq=Joony, so this ain't my first post

put this in your signature, so you don't have to post this every time

btw if you want to change your username, just ask one of the mods.

[zulu9812]

Originally posted by Iotaq
P.S. Iotaq=Joony, so this ain't my first post

So, you do in fact have a double log-in?

Ban him! Ban him now!

[Iotaq]

I didn't think there was anything wrong with that! Anyway i will NEVER log in as joony again, so you can take that off. Woops!