A.I. Prediction Chart

Z

zan_laurin

Chieftain
Joined
Sep 8, 2011
Messages
50
I have made this quick selection chart inspired by Bilbor's spreadsheet.
It should give an accurate representation towards individual A.I. biases.

Help is welcome in explaining all the fields, and additional mechanics... if you can show me the math I will build it in :)

Why?
  • Simple to use
  • You may quickly Alt-Tab to check if that Montezuma fellow tends to be a loyal ally
  • Updated to data from Civilization V 1.0.1.383 New
  • Contains all DLC civilization packs up to date

Compatibility:
  • Office Excel 2010 or newer Yes (Recommended)
  • Office 2007 Yes - Compatible version included
  • Office 2003 Yes - Compatible version included, no drop-down feature
  • Google Docs No (sorry, interface is still rudimentary)
  • Open Office Format Yes - Compatible version included, a bit lo-fi but it works

Screenshoot v0.7:
ai_prediction_chart_0_7_76W.png


 
Looks sleek and thought through. Good job.

However, I personally would not use this, as I tend to like the element of surprise.
 
I'm currently planning a diplomacy overhaul mod. That's why I created this tool.
I'd like Diplomacy to be more immersive.

I feel that the current approach is not fun, I constantly feel like I'm playing against angry 14 year olds power gamers when:
  • Every game that I play I get the "Hates you for trying to win the game in the same manner"
  • After a civ is conquered completely I come marching in and liberate it along with 3 other cities. 5 turns later the leader hates me because "I'm trying to win the game" and because "You are a warmongering menace" for attacking his oppressors (instead of worshiping the ground I walk on).
  • If you're ahead mostly everyone hates you, because you see it's a game, you're not building a civilization just playing a game... and don't you forget it!

Warmongering is more fun in Civ V vs the older games because of the new mechanics. However there is barely any more fun left while trying a cultural or diplomatic victory. I presume there are others that agree with me.
 
I'd love to make this Google Docs compatible. It would require a lot of extra formulas, and a bit of creativity to use data filtering techniques.

I imagine it is possible... though it's like processing images in MS Paint instead of Photoshop at the moment.
 
Looks good. Opened in Excel 2007 and the first column (slicer) is evidently not supported. -- although it says it might work if version is greater than 2003.

So if you are limited to Office 2007, it may not work for you.

Thanks for the effort.
 
I will try to make a version without the slicer so that ppl with Office 2007 can use it. May not be as elegant though.

As we speak I'm working on this 2nd alternative:
Update: Done
 
I think it's great and as a 2007 user I'm really looking forward to it. Thank you TY TY for all your work.
 
the 2nd version is a bit better.

Though, maybe you could pull out 2-3 different charts from the 'domestic policy' chart.

- One for 'win type' approach.
- One for Expansion/growth what it builds
- One for Unit composition

and such.
 
@ MadDjinn

Thanks for the suggestion. Yes I've thought of that, I will try that once I'm done ironing out the current layout.
At the moment I focused on fitting it all in one screen without needing to scroll the page or switch tabs.

I could separate the Domestic policy (Radar chart) into 3 or more bar charts like the others. I chose to keep them like that because they are all A.I. build priorities, even if some are treated as victory paths by the AI.
 
Excel 2007 and 2003 versions are up, not as ergonomic I'm afraid but quite functional.

Requesting a sticky please?
Thank you
 
Good luck with your mod, zan_laurin.

I think this is definitely the one area of the game where many people would like to see some changes.

For myself, I don't dislike the competitiveness of the AI, as much as I dislike the fact that sometimes they don't see the forest for the trees (e.g. Ramses covets my land even though I have 5 more cities than him and he will never ever have a chance at taking me; at this stage, I can destroy him whenever I want, so he should stop being a petulant little b*** and start playing nice).

The two things that I would immediately try if I was you:
- Play around with Boldness, see if you can make sure they stop declaring ridiculous suicidal wars when they have no chance
- Decrease Deceptiveness across the board, maybe go as far as making a good number of the AIs 100% honest

I wonder how much can be done using only the tools that exist now... I'm afraid that most of what we want requires an intervention deeper in the code.
 
Looking good, these sheets. Sorry, I missed this thread first time around. I'm currently downloading something that can open these things. Have the figures for Deceptiveness not been adjusted yet to the 1.0.1.383 values? Ah, I'll see that when I can open it.
wannabewarlord said:
Looks sleek and thought through. Good job.

However, I personally would not use this, as I tend to like the element of surprise.
Click to expand...
Don't forget that a dice is roled at the start of each game that fools around with these data. Each number on a scale of 10 can be adjusted 1 or 2 notches up or down. Then each game has lots of other factors as well that'll determine a civ's behaviour. Unpredictability won't easily be lost, even if you know the flavours.

It is indeed strange that no mods have been made yet that just change the diplomacy flavours a bit. You would think with all the complaining there would at least be a dozen by now.
 
Optional said:
[snip] I'm currently downloading something that can open these things. [snip].
Click to expand...

There's a free version for reading ms excel docs available for the 2007 and 2011 for those that don't own a copy of MS Office.
Still having trouble converting this to Google Docs, sorry folks.

Optional said:
Have the figures for Deceptiveness not been adjusted yet to the 1.0.1.383 values?
Click to expand...
Is 1.0.1.383 out already? I'm on a vacation trip, I don't have the game or steam for that matter on my laptop, will update as soon as I'm home (if anything changed) :)

Alternatively if anyone wants to send me the relevant .xml I could do a quick check if anything changed and update in less than 30 min.
 
zan_laurin said:
Alternatively if anyone wants to send me the relevant .xml I could do a quick check if anything changed and update in less than 30 min.
Click to expand...
In the patch notes was written that the chance of backstabbing has been decreased slightly. When I checked the XML files a while ago I noticed some figures for 'deceptiveness' had been decreased slightly:

Alexander 4 > 4
Askia 4 > 3
Augustus 7 > 6
Bismarck 7 > 7
Catherine 7 > 7
Darius 5 > 5
Elizabeth 6 > 6
Gandhi 3 > 3
G Kahn 3 > 3
H Rashid 7 > 6
Hiawatha 7 > 5
Isabella 6 > 5
Kameham 4 > 4
Montezu 7 > 7
Napoleon 7 > 7
Oda 7 > 6
Pachacuti 7 > 6
Ramesses 6 > 6
Ramkham 7 > 6
Sejong 4 (new civ)
Suleiman 7 > 7
G Wash 7 > 5
Wu 7 > 7

Not a lot of change. People on the forums who complained about the backstabbing before are still complaining, unsurprisingly.
I just copy-pasted the above figures from a post I had made elsewhere. Perhaps you'll be interested in Sejong's file (Sejong = Korea), but I see it's not possible to directly attach an XML file. I'll see if I can download some zip program tomorrow so I can attach it.
 
Optional said:
Not a lot of change. People on the forums who complained about the backstabbing before are still complaining, unsurprisingly. [...]
I I'll see if I can download some zip program tomorrow so I can attach it.
Click to expand...

Oh tell me about it. Especialy that Washington fellow. During my gameplays I frequently border him. He ALWAYS goes offensive on my ass straight from "friendly" declaring more frequently than Napoleon :eek: Even when he has Warriors vs my Longswordsmen oftenly leading to what can be described as assisted suicide... silly AI enough said :)

That'd be great if you could send me some zipped xml thanks.
 
You must log in or register to reply here.

Similar threads

RedCourtJester
Jester's Final Prediction Thread
7 8 9
Replies
162
Views
12K
RedCourtJester
RedCourtJester
Praetyre
Praetyre's Ultimate Musical Experience (PUME) [Work In Progress]
Replies
1
Views
192
Praetyre
Praetyre
Recursive
  • Locked
New BETA Version - 4.17.8 (December 16, 2024)
5 6 7
Replies
131
Views
26K
Recursive
Recursive
Recursive
  • Locked
New Version - 3.10.14 (September 26, 2023)
6 7 8
Replies
141
Views
32K
Recursive
Recursive
Blake00
Heroes of Might and Magic 2 Scenario Mod (& HoMM1 Addon) - Release Thread
Replies
9
Views
6K
Blake00
Blake00
Back
Top Bottom