| China | Activate HC Shipment "Good Faith Agreement"[1] | No | Actual In-Game tests vs. Mathematical Predictions | |||||||||||||||||||||||||||||||||||||||||||
| Ally | HC Lvl | Import | Effect | Estimated Cost (each) | Estimated Sub-Total | Age | Playable | Time (Sec) | Cost (export) | |||||||||||||||||||||||||||||||||||||
| Britain +10% Land unit hit points (to base value, not total like an aura) |
1 | British Expeditionary Company | 6 | Redcoat Musketeers | 67 | 400 | 2 | Unlimited | 20 | 400 | Number of Villagers | 99 | 0% | Villager Train Points (T) | 25 | Test Results with 25 vills (Constant work after all villagers created) | ||||||||||||||||||||||||||||||
| British Expeditionary Force | 8 | Redcoat Musketeers | 67 | 533 | 3 | Unlimited | 40 | 800 | Tricle Shipment? | None | 5% | Number of starting villagers (sv) | 5 | 5.8 | Resource Config | 100 export Time (sec) | Predicted 1[2] | Predicted 2[3] | Diff | % | With Team Sumptuary | Predicted 1[4] | Predicted 2[5] | Diff | % | With Sumptuary | Predicted 1[6] | Predicted 2[7] | Diff | % | ||||||||||||||||
| 1 | Falconet | 267 | 267 | Configure Reduction in Resource Gathering | 0% | 10% | Number of villagers created | 8 | 9.3 | |||||||||||||||||||||||||||||||||||||
| British Expeditionary Army | 6 | Life Guard Hussars | 133 | 800 | 4 | Unlimited | 60 | 1,600 | Effect of Reduction in Resource Gathering to Export Bonus | 0% | Yes | Villager Seconds Wasted[8] | 45 | 0% | 115 | 133 | 115 | 0.4 | -0.4% | 103 | 118 | 103 | 0.5 | -0.5% | 98 | 111 | 98 | 0.4 | -0.4% | |||||||||||||||||
| 3 | Falconets | 267 | 800 | Export Generated (Export / Sec)[9] | 3.43 | 2.97 | No | Total villagers | 13 | 5% | 88 | 99 | 86 | -2.5 | 2.8% | 82 | 90 | 79 | -3.2 | 3.9% | 78[10] | 86 | 76 | -2.2 | 2.8% | |||||||||||||||||||||
| British Brigade | 16 | Roger's Rangers | 67 | 1,067 | 5 | 1 | 90 | 2,400 | None | Time to create villagers (min) | 3.33[11] | 10% | 76 | 83 | 72 | -3.8 | 5.1% | 70 | 77 | 67 | -2.7 | 3.9% | 68[12] | 74 | 65 | -2.4 | 3.5% | |||||||||||||||||||
| 5 | Falconet | 267 | 1,333 | Export Villager Factor[13] | 15.5% | Sumptuary La | Base Export Rate (Export / Sec) | 0.030 | ||||||||||||||||||||||||||||||||||||||
| 2 Surgeons | 2 | Surgeons (can make hospitals) | 100 | 200 | 2 | 1 | 30 | 200 | Export Desired | 100 | TEAM Sumpt | Villager Seconds Available (an) | 1,755 | 2,284 | Test Results with 50 vills (Constant work after all villagers created) | |||||||||||||||||||||||||||||||
| 4 Spies | 4 | Spies | 75 | 300 | 2 | 1 | 30 | 300 | Approx Gather Time with constant villagers (Sec)[14] | 29 | 34 | Approx Export Passively Gathered | 53[15] | 69 | Resource Config | 100 export Time (sec) | Predicted 1[16] | Predicted 2[17] | Diff | % | With Team Sumptuary | Predicted 1[18] | Predicted 2[19] | Diff | % | With Sumptuary | Predicted 1[20] | Predicted 2[21] | Diff | % | ||||||||||||||||
| 5 Petards | 5 | Petards | 90 | 450 | 3 | 1 | 30 | 450 | ||||||||||||||||||||||||||||||||||||||
| Russia -10% Settler train time |
1 | Russian Expeditionary Company | 4 | Siberian Cossacks | 100 | 400 | 2 | Unlimited | 20 | 400 | Miscellaneous Notes: | 0% | 58 | 67 | 58 | -0.3 | 0.5% | 57 | 63 | 55 | -2.4 | 4.3% | 52 | 61 | 53 | 1.1 | -2.2% | |||||||||||||||||||
| Russian Expeditionary Force | 5 | Siberian Cossacks | 100 | 500 | 3 | Unlimited | 40 | 800 | 1 | The "+" grouping button at the top of the worksheet can be expanded or hidden to show the estimated cost of each unit (in export) & estimated group subtotal. | 5% | 44 | 49 | 43 | -1.2 | 2.8% | 45 | 47 | 41 | -4.0 | 8.9% | 42 | 46 | 40 | -1.8 | 4.3% | ||||||||||||||||||||
| 1 | Culverin | 300 | 300 | 10% | 38 | 42 | 36 | -1.9 | 5.1% | 38 | 40 | 35 | -3.2 | 8.4% | 36 | 39 | 34 | -1.8 | 4.9% | |||||||||||||||||||||||||||
| Russian Expeditionary Army | 7 | Kalmucks | 100 | 700 | 4 | Unlimited | 60 | 1,600 | 2 | Selecting "Yes" in the "Activate HC Shipment "Good Faith Agreement"" yellow highlighted cell will automatically adjust the export cost and shipment time from all of the consulate shipments for each civilization. | ||||||||||||||||||||||||||||||||||||
| 3 | Culverins | 300 | 900 | Test Results with 0 vills (only Sumptuary Laws) | ||||||||||||||||||||||||||||||||||||||||||
| Russian Brigade | 3 | Culverin | 300 | 900 | 5 | 1 | 90 | 2,400 | Resource Config | With Team Sumptuary | Predicted 1[22] | Predicted 2[23] | Diff | % | With Sumptuary | Predicted 1[24] | Predicted 2[25] | Diff | % | |||||||||||||||||||||||||||
| 15 | Baskhkir Pony | 100 | 1,500 | 3 | The "Export Generated (Export / Sec)" can be calculated by typing in the total number of villagers working in the "Number of Villagers" yellow input cell and the consulate configuration in the "Configure Reduction in Resource Gathering" yellow input cell. The "Time to Gather (Sec)" can be calculated in the same manner but also including the amount of "Export Desired" in the yellow input cell. | |||||||||||||||||||||||||||||||||||||||||
| Blockhouse Wagon | 1 | Blockhouse Wagon[26] | 200 | 200 | 2 | 1 | 30 | 200 | 0% | 1037[27] | 1000 | 1000 | -37.0 | 3.6% | 665 | 667 | 667 | 1.7 | -0.3% | |||||||||||||||||||||||||||
| Fort Wagon | 1 | Fort Wagon[28] | 600 | 600 | 3 | 1 | 30 | 600 | 5% | ---- | ---- | ---- | ---- | ---- | 668 | 667 | 667 | -1.3 | 0.2% | |||||||||||||||||||||||||||
| Factory Wagon | 1 | Factory Wagon | 800 | 800 | 4 | 1 | 30 | 800 | 10% | ---- | ---- | ---- | ---- | ---- | 667[29] | 667 | 667 | -0.3 | 0.0% | |||||||||||||||||||||||||||
| France 5% Gathering enhancement |
25 | French Expeditionary Company | 4 | Young Garde | 100 | 400 | 2 | Unlimited | 20 | 400 | 4 | Export is auto generated passively by villagers at a rate of 0.03 per second when tasked to a resource. They will not collect export if idle, constructing a building, or garrisoned. The Age the civilization is in (i.e. Discovery, Colonial, etc.) does not matter to the export collection rate. [30] | ||||||||||||||||||||||||||||||||||
| French Expeditionary Force | 3 | Young Garde | 100 | 300 | 3 | Unlimited | 40 | 800 | Test Results with 75 vills (Constant work after all villagers created) | |||||||||||||||||||||||||||||||||||||
| 3 | Gendarmes | 167 | 500 | Resource Config | 100 export Time (sec) | Predicted 1[31] | Predicted 2[32] | Diff | % | With Team Sumptuary | Predicted 1[33] | Predicted 2[34] | Diff | % | With Sumptuary | Predicted 1[35] | Predicted 2[36] | Diff | % | |||||||||||||||||||||||||||
| French Expeditionary Army | 5 | Gendarmes | 167 | 833 | 4 | Unlimited | 60 | 1,600 | 5 | After allying with a civilization, the consulate can be configured to generate additional export. A 5% reduction in all resource generation generates a 35% increase in export. A 10% reduction boosts export by 65%. Takes 2 seconds to configure resource penalty / export bonus at the consulate | ||||||||||||||||||||||||||||||||||||
| 2 | Horse Artillery | 383 | 767 | 0% | 39 | 44 | 38 | -0.5 | 1.3% | ---- | ---- | ---- | ---- | ---- | 36 | 42 | 36 | 0.4 | -1.1% | |||||||||||||||||||||||||||
| French Brigade | 15 | Gendarmes | 160 | 2,400 | 5 | 1 | 90 | 2,400 | 5% | 29 | 33 | 29 | -0.5 | 1.7% | ---- | ---- | ---- | ---- | ---- | 28 | 31 | 27 | -0.7 | 2.4% | ||||||||||||||||||||||
| 1 Huge Crates of Food | 500 | Food | 0.6 | 300 | 2 | 1 | 30 | 300 | 6 | A consulate building must be constructed in order to spend export. If consulate is destroyed while allied with one civilization, the same ally will exist when the consulate is rebuilt (do not need to pay relation cost again & no fast way to brake relations). | 10% | 25 | 28 | 24 | -0.9 | 3.8% | ---- | ---- | ---- | ---- | ---- | 24 | 27 | 23 | -0.8 | 3.3% | ||||||||||||||||||||
| 1 Huge Cords of Wood | 500 | Wood | 0.6 | 300 | 2 | 1 | 30 | 300 | ||||||||||||||||||||||||||||||||||||||
| 1 Huge Crates of Coin | 500 | Coin | 0.6 | 300 | 2 | 1 | 30 | 300 | Test Results with 99 vills (Constant work after all villagers created) | |||||||||||||||||||||||||||||||||||||
| Germany -30 to Banner army cost (-30 resources, not %) |
40 | German Expeditionary Company | 3 | Zweihanders | 133 | 400 | 2 | Unlimited | 20 | 400 | 7 | Consulate units are not the same as their European counterparts. All consulate units auto-upgrade opposed to paying to research their upgrades. In addition, the upgrade effects are different depending on the age the unit is spawned. The worksheet "Units - Consulate" has all the Consulate unit information. | Resource Config | 100 export Time (sec) | Predicted 1[37] | Predicted 2[38] | Diff | % | With Team Sumptuary | Predicted 1[39] | Predicted 2[40] | Diff | % | With Sumptuary | Predicted 1[41] | Predicted 2[42] | Diff | % | ||||||||||||||||||
| German Expeditionary Force | 3 | Zweihanders | 133 | 400 | 3 | Unlimited | 40 | 800 | ||||||||||||||||||||||||||||||||||||||
| 6 | Prussian Needle Guns | 67 | 400 | 0% | 29 | 34 | 29 | 0.2 | -0.5% | 28 | 33 | 28 | 0.3 | -1.2% | ---- | ---- | ---- | ---- | ---- | |||||||||||||||||||||||||||
| German Expeditionary Army | 11 | Prussian Needle Guns | 67 | 733 | 4 | Unlimited | 60 | 1,600 | 8 | In addition to auto upgrades, there are other differences. For example, the British surgeons cannot build hospitals for India but can for China, Russian blockhouses cannot build any units, Russian factory can spawn heavy cannon but cannot be upgraded to imperial, etc. | 5% | 22 | 25 | 22 | -0.4 | 1.8% | 22 | 24 | 21 | -0.9 | 3.9% | ---- | ---- | ---- | ---- | ---- | ||||||||||||||||||||
| 2 | Heavy Cannons | 433 | 867 | 10% | 19 | 21 | 18 | -0.8 | 4.1% | 19 | 21 | 18 | -1.1 | 5.8% | ---- | ---- | ---- | ---- | ---- | |||||||||||||||||||||||||||
| German Brigade | 19 | Czapaka Uhlans | 74 | 1,400 | 5 | 1 | 90 | 2,400 | ||||||||||||||||||||||||||||||||||||||
| 15 | Prussian Needle Guns | 67 | 1,000 | 9 | Takes 10 seconds and 100 export to make a relation. The HC shipment "Diplomatic Intrigue" decreases the export cost to ally with a civilization to 25 export. Takes 60 seconds and 0 export to break a relation. | Test Results with 1 vills (Constant work after all villagers created) | ||||||||||||||||||||||||||||||||||||||||
| Food Trickle | 1.50 | Food Trickle | 166.7 | 250 | 2 | 1 | 30 | 250 | Resource Config | 50 export Time (sec) | Predicted 1[43] | Predicted 2[44] | Diff | % | ||||||||||||||||||||||||||||||||
| Wood Trickle | 1.25 | Wood Trickle | 200.0 | 250 | 3 | 1 | 30 | 250 | ||||||||||||||||||||||||||||||||||||||
| Coin Trickle | 1.25 | Coin Trickle | 200.0 | 250 | 4 | 1 | 30 | 250 | 10 | XP is awarded for spawning consulate units but not per unit. Company grants 40XP, Force grants 80XP, and Armies grant 160XP. XP is awarded for Japan's isolation units as listed. Brigades are considered technologies and do not grant XP. | 0% | 1425 | 1,667 | 1,443 | 18.0 | -1.3% | ||||||||||||||||||||||||||||||
| 5% | 1104 | 1,235 | 1,069 | -35.1 | 3.2% | |||||||||||||||||||||||||||||||||||||||||
| 10% | 945 | 1,042 | 902 | -43.1 | 4.6% | |||||||||||||||||||||||||||||||||||||||||
| India | 11 | All army shipments, (shipped unlimited), arrive at the consulate. All technology and Brigade (shipped once only), arrive at your HC shipment drop off point. | ||||||||||||||||||||||||||||||||||||||||||||
| Ally | HC Lvl | Import | Effect | Estimated Cost (each) | Estimated Sub-Total | Age | Playable | Time (Sec) | Cost (export) | |||||||||||||||||||||||||||||||||||||
| Britain +10% Land unit hit points (to base value, not total like an aura) |
1 | British Expeditionary Company | 6 | Redcoat Musketeers | 67 | 400 | 2 | Unlimited | 20 | 400 | 12 | All consulate shipments can be kept after relations are broke, even trickle / Nanban Trade technologies (i.e. Germany / Spain). However, the base civilization bonus (i.e. +10% land unit hit points, etc.) is only kept when allied to that civilization. | ||||||||||||||||||||||||||||||||||
| British Expeditionary Force | 8 | Redcoat Musketeers | 67 | 533 | 3 | Unlimited | 40 | 800 | ||||||||||||||||||||||||||||||||||||||
| 1 | Falconet | 267 | 267 | |||||||||||||||||||||||||||||||||||||||||||
| British Expeditionary Army | 6 | Life Guard Hussars | 133 | 800 | 4 | Unlimited | 60 | 1,600 | 13 | When allied
with Portugal, all food and wood building costs are -15% (including the food
requirement of Wonders). The Age-up
costs are listed below: Colonial: 680 Food, Fortress: 1,020 Food + 1,000 Gold, Industrial: 1,700 Food + 1,200 Gold, and Imperial: 3,400 Food + 4,000 Gold |
||||||||||||||||||||||||||||||||||||
| 3 | Falconets | 267 | 800 | |||||||||||||||||||||||||||||||||||||||||||
| British Brigade | 16 | Roger's Rangers | 67 | 1,067 | 5 | 1 | 90 | 2,400 | ||||||||||||||||||||||||||||||||||||||
| 5 | Falconet | 267 | 1,333 | 14 | HC Shipments that effect the Consulate: | |||||||||||||||||||||||||||||||||||||||||
| 2 Surgeons | 2 | Surgeons (cannot make hospitals) | 100 | 200 | 2 | 1 | 30 | 200 | a.) | Diplomatic Intrigue | Age 2: Receive 300 Export & relations are -75% cheaper. Costs 25 export to make a new relation (opposed to 100). | |||||||||||||||||||||||||||||||||||
| 4 Spies | 4 | Spies | 75 | 300 | 2 | 1 | 30 | 300 | ||||||||||||||||||||||||||||||||||||||
| 5 Petards | 5 | Petards | 90 | 450 | 3 | 1 | 30 | 450 | b.) | Dowager Empress | Age 1: All Export is exchanged for a greater amount of Coin (x1.6). | |||||||||||||||||||||||||||||||||||
| Portuguese -15% Building non coin costs (wood / food) • Passive ability also decreases Wonder food costs |
1 | Portuguese Expeditionary Company | 7 | Besteiros | 57 | 400 | 2 | Unlimited | 20 | 400 | ||||||||||||||||||||||||||||||||||||