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 Laws Base Export Rate (Export / Sec) 0.030  
2 Surgeons 2 Surgeons (can make hospitals) 100 200 2 1 30 200 Export Desired 100 TEAM Sumptuary Laws 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