United Kingdom 1900/H1

Started by snip, October 22, 2012, 09:46:04 PM

Previous topic - Next topic
Print
Go Down Pages1
User actions

snip

October 22, 2012, 09:46:04 PM Last Edit: October 22, 2012, 09:52:12 PM by snip

United Kingdom of Great Britain and Ireland                               
1900/H1                              
                              
Region   Population   IC   BP   Income                  
United Kingdom   38   118   52   $156.00                  
India   200   20   4   $76.00                  
Burma   9.606   5   1   $10.92                  
Canada (including Newfoundland)   5.73   19.5   12   $25.23                  
Australia (including Papua)   4.4   15   10   $19.40                  
Ceylon   3.7   3   0   $6.14                  
New Zealand   0.967   4   1   $4.97                  
Malay (incd Straits)   0.955   2   0   $2.96                  
Jamaca   0.82   1   0   $1.82                  
Hong Kong   0.325   5   1   $5.33                  
Trinidad and Tobago   0.32   1   0   $1.32                  
North Borneo   0.3   1   0   $1.30                  
British Guiana   0.3   1   0   $1.30                  
Cyprus   0.126   1   0   $1.13                  
Barbados   0.182   1   0   $1.18                  
Total   265.731   197.5   81   $314.99                  
                              
Total Revenue   $314.99                           
                              
   $   BP                        
Other Income   28.5   0   Country   Payment   Reason               
Industry profits         Italy   20   20 1900 Pattern TBDs               
Other civilian income         Ottoman   8.5   Two Vickers Armored cruisers               
                              
                              
Other military Income                              
                              
                              
Total Budget   $343.49   81                        
Army Construction:                              
Army Maintenance:   $26.66                           
Army Ammo Consumption   $0.00   0                        
Airship Hangars                              
Airship Construction/Repair                              
Airship Maintenance   $0.00                           
Airship Ammo   $0.00   0                        
Aircraft Infrastructure                              
Aircraft Construction/Repair                              
Aircraft Maintenance   $0.00                           
Ammo                              
Navy Construction&Repair   $101.85   75.08                        
Navy Maintenance:   $21.12                           
Research:   $0.00      Maximum   $27.00                  
Military Infrastructure               previous      total      remaining   
Roslyth Port (Class 0)   $5.00   0.5   5   0.5   0   0   5   0.5   0   0
Scapa Flow (Class 0)   $5.00   0.5   5   0.5   0   0   5   0.5   0   0
Plymouth (Clash 5)   $6.00   1   20   1   0   0   6   1   12   0
Chatham (Class 4)   $6.00   1   15   1   0   0   6   1   13   0
Railways                              
Emergency Reserve Fund                              
Other Expenses                              
                              
                              
                              
Military Budget   $171.63   78.08   Maximum   $171.74   Peacetime               
         Remaining   $0.12                  
Other expenditure                              
Economic Development   $171.86   0                        
   Investment      Current   Total Needed   Previous   Needed to Complete            
India IC #21   $32.07      20   $32.07   0   Completes            
Ceylon IC #4   $35.40      4   $35.40   0   Completes            
Burma IC #5   $33.07      5   $33.07   0   Completes            
United Kingdom IC #119   $21.32      118   $120.71   0   $99.39            
BP #82   $50.00      81   $505.00   0   $455.00            
                              
                              
                              
Remaining   0.00   0.00                        
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

snip

#1
October 22, 2012, 09:47:39 PM

Total      $      101.845                                       
      BP      75.08                                          
                                                         
               expenditures         previous status            new status               relative status      
Name   Construction Facility   Class   Ship Size   Build Time   $   BP      $   BP   Time      $   BP   Time      Type   $   BP   Time
Ottoman Armored Cruiser   Portsmouth Slipway #1   3   11313   4   3.54   3.54      0   0   0      10.6   10.6   3      W   25%   25%   25%
Formidable    Portsmouth Slipway #2   2   15000   4   3.75   3.75      0   0   0      11.25   11.25   3      W   25%   25%   25%
Redoubtable    Portsmouth Slipway #3   2   15000   4   3.75   3.75      0   0   0      11.25   11.25   3      W   25%   25%   25%
Black Prince   Portsmouth Slipway #4   2   12500   4   3.125   3.125      0   0   0      9.375   9.375   3      W   25%   25%   25%
Sapphire   Portsmouth Slipway #5   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Emerald   Portsmouth Slipway #6   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Ruby   Portsmouth Slipway #7   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Impregnable    Plymouth Slipway #1   2   15000   4   3.75   3.75      0   0   0      11.25   11.25   3      W   25%   25%   25%
Iron Duke   Plymouth Slipway #2   2   12500   4   3.125   3.125      0   0   0      9.375   9.375   3      W   25%   25%   25%
Diamond Princess   Plymouth Slipway #3   2   12500   4   3.125   3.125      0   0   0      9.375   9.375   3      W   25%   25%   25%
Apatite   Plymouth Slipway #4   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Obsidian   Plymouth Slipway #5   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Mail Garnet   Plymouth Slipway #6   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Arduous    Chatham Slipway #1   2   15000   4   3.75   3.75      0   0   0      11.25   11.25   3      W   25%   25%   25%
Pearl   Chatham Slipway #2   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Rhodonite   Chatham Slipway #3   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Fantastic   Chatham Slipway #4   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Florescent   Glasgow Slipway #1   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Fancy   Woolwich Slipway #1   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Flanker   Deptford Slipway #1   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Fortune   Belfast Slipway #1   1   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Flagrant   Belfast Slipway #2   1   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
A-1 Class Sub   Belfast Slipway #3   0   250   1   0.5   0.25      0   0   0      0   0   0      S   100%   100%   100%
Empress of India    Liverpool Slipway #1   2   12500   4   3.125   3.125      0   0   0      9.375   9.375   3      W   25%   25%   25%
Diamond   Liverpool Slipway #2   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Quartz   Liverpool Slipway #3   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
Flanagan   Liverpool Slipway #4   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Future   Liverpool Slipway #5   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Fabulous   Liverpool Slipway #6   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Fortitude   Cardiff Slipway #1   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Sunstone   Newcastle Slipway #1   1   3000   2   1.5   1.5      0   0   0      1.5   1.5   1      W   50   50   50
A-1 Class Sub   Newcastle Slipway #2   0   250   1   0.5   0.25      0   0   0      0   0   0      S   100%   100%   100%
Italian DD-1900   Madras Slipway #1   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Madras Slipway #2   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Madras Slipway #3   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
   Halifax Slipway #1   1   Upgrade   1   3   1      0   0   0      0   0   0      INF   100%   100%   100%
   Halifax Slipway #2   1   Upgrade   1   3   1      0   0   0      0   0   0      INF   100%   100%   100%
Fusileer   Halifax Slipway #3   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Fouler   Halifax Slipway #4   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Fissure   Halifax Slipway #5   0   500   1   0.625   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Aberdeen Slipway #1   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
   Edinburgh Slipway #1   1   Upgrade   1   3   1      0   0   0      0   0   0      INF   100%   100%   100%
   Edinburgh Slipway #2   1   Upgrade   1   3   1      0   0   0      0   0   0      INF   100%   100%   100%
A-1 Class Sub   Edinburgh Slipway #3   0   250   1   0.5   0.25      0   0   0      0   0   0      S   100%   100%   100%
A-1 Class Sub   Edinburgh Slipway #4   0   250   1   0.5   0.25      0   0   0      0   0   0      S   100%   100%   100%
A-1 Class Sub   Edinburgh Slipway #5   0   250   1   0.5   0.25      0   0   0      0   0   0      S   100%   100%   100%
A-1 Class Sub   Edinburgh Slipway #6   0   250   1   0.5   0.25      0   0   0      0   0   0      S   100%   100%   100%
   Sydney Slipway #1   0   Upgrade   1   6   1      0   0   0      0   0   0      INF   100%   100%   100%
   Sydney Slipway #2   0   Upgrade   1   6   1      0   0   0      0   0   0      INF   100%   100%   100%
   Hong Kong Slipway #1   0                                                   
   Hong Kong Slipway #2   0                                                   
   Hong Kong Slipway #3   0                                                   
   Hong Kong Slipway #4   0                                                   
   Singapore Slipway #1   1                                                   
   Singapore Slipway #2   1                                                   
   Singapore Slipway #3   0                                                   
   Singapore Slipway #4   0                                                   
Italian DD-1900   Larnaca Slipway #1   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Larnaca Slipway #2   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Valletta Slipway #1   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Valletta Slipway #2   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Valletta Slipway #3   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Valletta Slipway #4   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Gibraltar Slipway #1   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Gibraltar Slipway #2   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
   Port Stanley Slipway #1   0                                                   
   Port Stanley Slipway #2   0                                                   
Ottoman Armored Cruiser   Portsmouth Drydock #1   3   11313   4   3.54   3.54      0   0   0      10.6   10.6   3      W   25%   25%   25%
   Portsmouth Drydock #2   2                                                   
   Portsmouth Drydock #3   2                                                   
   Portsmouth Drydock #4   1                                                   
   Plymouth Drydock #1   2                                                   
   Plymouth Drydock #2   2                                                   
   Plymouth Drydock #3   1                                                   
   Chatham Drydock #1   1                                                   
   Chatham Drydock #2   1                                                   
   Chatham Drydock #3   0                                                   
   Glasgow Drydock #1   1                                                   
   Glasgow Drydock #2   0                                                   
   Woolwich Drydock #1   1                                                   
   Woolwich Drydock #2   0                                                   
   Deptford Drydock #1   1                                                   
   Deptford Drydock #2   0                                                   
   Larnaca Drydock #1   2                                                   
Italian DD-1900   Larnaca Drydock #2   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Larnaca Drydock #3   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
   Valletta Drydock #1   2                                                   
   Valletta Drydock #2   2                                                   
Italian DD-1900   Valletta Drydock #3   1   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Valletta Drydock #4   1   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Valletta Drydock #5   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Gibraltar Drydock #1   2   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Gibraltar Drydock #2   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
Italian DD-1900   Gibraltar Drydock #3   0   500   1   0.782   0.5      0   0   0      0   0   0      D   100%   100%   100%
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

snip

#2
October 22, 2012, 09:50:50 PM

#   Count   Name/Class   Disp   LD/Com/R.   v_Max   Range   Cruise   Bunker   Status   fighting   Upkeep [$]
   8   Illustrious   13,100   PreStart   16.39   7009   8   1471   a      3.14
   4   Albion   14,100   PreStart   17.98   7000   8   1506   a      1.72
   6   Remembrance   9,780   PreStart   17.96   7000   10   1995   a      2.00
   8   Ariadne   9,485   PreStart   20.45   7000   10   1990   a      2.77
   6   Cressy   10,980   PreStart   21.02   7000   10   2049   a      2.35
   12   Aphrodite    3,000   PreStart   19.91   4000   10   566   a      1.52
   12   Encounter   4,684   PreStart   20.3   7500   10   1334   a      2.21
   24   Pegasus   1,640   PreStart   18.69   7000   10   743   a      1.82
   40   Chamois   470   PreStart   24.04   3000   10   144   a      1.47
   40   Destructive   470   PreStart   24.04   3000   10   139   a      1.44
Total   160                              
      Tonnage:   530,808                        
                                 
Coastal Defenses   Count   Type   Defenses                  Status      Upkeep [$]
   4   12" Turret   MD                  a      0.13
   5   12" Turret   ED                  a      0.08
   16   12" Dissap. Carrage.   ND                  a      0.03
   6   9.2" Turret   ED                  a      0.18
   29   9.2" Casemate   ND                  a      0.07
   51   6" Turret   ND                  a      0.05
   65   6" Casemate   ND                  a      0.03
   975   6"Dissap. Carrage   ND                  r      0.10
Total   1151                              
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

snip

#3
October 22, 2012, 09:51:41 PM

Corp #   Name   Type      Motorized   Rating   Artillery   Strength   Morale   Value [$]   Status   Upkeep [$]   Ammo   Location
1   1st Infantry, Royal Guards   1895   INF      4   2   100%      8   a   0.4      England
2   2nd Infantry, Royal Welsh   1895   INF      4   2   100%      8   a   0.4      Wales
3   3rd Infantry, Royal Scots   1895   INF      4   2   100%      8   a   0.4      Scotland
4   4th Infantry, Royal Irish   1895   INF      4   2   100%      8   a   0.4      Ireland
5   5th Infantry, Raj Guards   1895   INF      4   2   100%      8   a   0.4      India
6   6th Infantry, Black Watch   1895   INF      4   2   100%      8   a   0.4      Canada
7   7th Infantry, Gaelic Guards   1895   INF      4   2   100%      8   a   0.4      Canal Zone
8   8th Infantry, Royal Fusiliers   1895   INF      4   2   100%      8   a   0.4      Hong Kong
9   9th Infantry, Queen's Rifles   1895   INF      4   2   100%      8   a   0.4      Gibraltar
10   10th Infantry, Royal ANZAC   1895   INF      4   2   100%      8   a   0.4      Australia
11   1st Royal Hussars   1895   CAV      4   1   100%      8   a   0.4      Home Islands
12   2nd Royal Hussars   1895   CAV      4   1   100%      8   a   0.4      Canal Zone
13   Royal Tigers   1895   JNG      4   1   100%      8   a   0.4      Mayala
14   Desert Rats   1895   DES      4   1   100%      8   a   0.4      Canal Zone
15   Royal Marines   1895   Mar      4   1   100%      8   a   0.4      Home Islands
16   1st Indian Regulars   1885   INF      3   1   100%      6   r   0.06      India
17   2nd Indian Regulars   1885   INF      3   1   100%      6   r   0.06      India
18   3rd Indian Regulars   1885   INF      3   1   100%      6   r   0.06      Canal Zone
19   11th Infantry   1885   INF      3   1   100%      6   r   0.06      Valletta
20   12th Infantry   1885   INF      3   1   100%      6   r   0.06      Singapore
21   13th Infantry   1885   INF      3   1   100%      6   r   0.06      Larnaca, Cyprus
22   Indian Reservists   1885   INF      3   1   100%      6   r   0.06      India
23   Indian Reservists   1885   INF      3   1   100%      6   r   0.06      India
24   Australian Reservists   1885   INF      3   1   100%      6   r   0.06      Australia
25   Canadian Reservists   1885   INF      3   1   100%      6   r   0.06      Canada
26   Royal Mounted Reserves   1885   CAV      3   0.5   100%      6   r   0.06      Canada
27   Australian Reservists   1885   CAV      3   0.5   100%      6   r   0.06      Australia
28   Indian Reservists   1885   CAV      3   0.5   100%      6   r   0.06      India
29   Far Eastern Reserves   1885   CAV      3   0.5   100%      6   r   0.06      Singapore
30   Home Reserves   1885   CAV      3   0.5   100%      6   r   0.06      Home Islands
1      1895   GAR      12   18   300%      48   a   2.4      Port Said
2      1895   GAR      12   18   300%      48   a   2.4      Suez
3      1895   GAR      8   12   200%      32   a   1.6      Madris
4      1895   GAR      8   12   200%      32   a   1.6      Hong Kong
5      1895   GAR      8   12   200%      32   a   1.6      Singapore
6      1895   GAR      8   12   200%      32   a   1.6      Gibraltar
7      1895   GAR      4   6   100%      16   a   0.8      Portsmouth
8      1895   GAR      4   6   100%      16   a   0.8      Valletta
9      1895   GAR      4   6   100%      16   a   0.8      Larnaca, Cyprus
10      1895   GAR      4   6   100%      16   a   0.8      Port Stanley
11      1895   GAR      4   6   100%      16   a   0.8      Plymouth
12      1895   GAR      4   6   100%      16   a   0.8      Sydney
13      1895   GAR      2   3   50%      8   a   0.4      Portsmouth
14      1895   GAR      2   3   50%      8   a   0.4      Gibraltar
15      1895   GAR      2   3   50%      8   a   0.4      Liverpool
16      1895   GAR      2   3   50%      8   a   0.4      Halifax
17      1880   GAR      6   6   200%      24   r   0.24      India
18      1880   GAR      6   6   200%      24   r   0.24      India
19      1880   GAR      6   6   200%      24   r   0.24      Canada
20      1880   GAR      6   6   200%      24   r   0.24      Canada
21      1880   GAR      6   6   200%      24   r   0.24      Australia
22      1880   GAR      6   6   200%      24   r   0.24      Australia
23      1880   GAR      3   3   100%      12   r   0.12      Ireland
24      1880   GAR      3   3   100%      12   r   0.12      Ireland
25      1880   GAR      3   3   100%      12   r   0.12      India
26      1880   GAR      3   3   100%      12   r   0.12      India
27      1880   GAR      1.5   1.5   50%      6   r   0.06      Gibraltar
28      1880   GAR      1.5   1.5   50%      6   r   0.06      Hong Kong
29      1880   GAR      1.5   1.5   50%      6   r   0.06      Singapore
30   Tower of London   1880   GAR      1.5   1.5   50%      6   r   0.06      London
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

Logi

#4
October 27, 2012, 04:44:44 AM
If you copied your post from your spreadsheet there's a problem with it that I've found. For the value given for a reserve unit in the army tab, the conditional you have is K11="_R",0.01,0 where K11 is just the cell of the Status. However since the input status is 'r' not '_R', you have the upkeep resulting in 0 instead of 0.08.

This adds up to $3.06 not counted in the UK budget.

Tanthalas

#5
October 27, 2012, 08:10:49 AM
Having just checked it in my spreadsheat you have aparently made changes in yours logi, because I get exactly the same numbers as Snip (infact it dosnt matter if I capitilise the R or not and if I use _R I get 0 for maintnence on my reserve units)

Quote from: Logi on October 27, 2012, 04:44:44 AM
If you copied your post from your spreadsheet there's a problem with it that I've found. For the value given for a reserve unit in the army tab, the conditional you have is K11="_R",0.01,0 where K11 is just the cell of the Status. However since the input status is 'r' not '_R', you have the upkeep resulting in 0 instead of 0.08.

This adds up to $3.06 not counted in the UK budget.
"He either fears his fate too much,
Or his desserts are small,
Who dares not put it to the touch,
To win or lose it all!"

James Graham, 5th Earl of Montrose
1612 to 1650
Royalist General during the English Civil War

snip

#6
October 27, 2012, 10:55:29 AM
on my copy (which is the same as uploaded) it is a lower-case r for that value [=IF(OR(K11="m";K11="f");0.1;IF(K11="a";0.05;IF(K11="r";0.01;0)))*J11], which is listed in the posted page. Out of curiosity, what program are you using to open the file? Seeing as I made it in Open Office, it might be an artifact of trying to open it elsewhere.
You smug-faced crowds with kindling eye
Who cheer when solider lads march by
Sneak home and pray that you'll never know
The hell where youth and laughter go.
-Siegfried Sassoon

Tanthalas

#7
October 27, 2012, 11:12:52 AM
I have MS Office, it makes absolutly no diferance, as my results are the same as yours.  I would post my report but im still trying to name all my corps and figure out whats Active/Mobalised/Reserve.

Quote from: snip on October 27, 2012, 10:55:29 AM
on my copy (which is the same as uploaded) it is a lower-case r for that value [=IF(OR(K11="m";K11="f");0.1;IF(K11="a";0.05;IF(K11="r";0.01;0)))*J11], which is listed in the posted page. Out of curiosity, what program are you using to open the file? Seeing as I made it in Open Office, it might be an artifact of trying to open it elsewhere.
"He either fears his fate too much,
Or his desserts are small,
Who dares not put it to the touch,
To win or lose it all!"

James Graham, 5th Earl of Montrose
1612 to 1650
Royalist General during the English Civil War

Logi

#8
October 27, 2012, 03:20:06 PM
Ah then it is probably an artifact from the conversion from open office spreadsheet to excel spreadsheet. I use an automatic converter. Looking now at your post, it would seem to be the case since you do indeed have the correct maintenance values.
Print
Go Up Pages1
User actions