{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Shipping","Aircraft","US_In_Uniform"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":29,"comments":0,"pivot_tables":4},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Shipping","index":0,"n_rows":189,"n_cols":20,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
["FROM:",null,"Mark Biegert"]
["SUBJECT:",null,"US versus Japan Ship Production in WW2"]
["DATE:",null,"2017-12-03"]
[]
["Data Sources"]
[null,null,"Link","US arms production during WW2"]
[null,null,"Link","Japan arms production during WW2"]
[]
["Comparision Tables"]
[]
[null,"Warship Production"]
[]
[null,"Ship Count","Weapon","Country"]
[null,null,"Aircraft carriers",null,null,"Battleships",null,null,"Cruisers",null,null,"Destroyers",null,null,"Escorts",null,null,"Submarines"]
[null,"Year","Japan","UK","US","Japan","UK","US","Japan","UK","US","Japan","UK","US","Japan","UK","US","Japan","UK","US"]
[null,1939,0,0,0,0,0,0,0,3,0,0,22,0,0,5,0,0,7,0]
[null,1940,0,2,0,0,1,0,0,7,0,0,27,0,0,109,0,0,15,0]
[null,1941,1,2,0,1,2,0,0,6,1,0,39,2,0,87,0,0,20,2]
[null,1942,6,0,18,1,2,4,4,6,8,10,73,82,0,71,0,61,33,34]
[null,1943,4,2,65,0,0,2,3,7,11,12,37,128,0,79,298,37,39,55]
[null,1944,5,4,45,0,0,2,2,2,14,24,31,74,0,55,194,39,39,81]
[null,1945,0,4,13,0,0,0,0,1,14,17,13,63,0,7,6,30,14,31]
[null,"Grand Total",16,14,141,2,5,8,9,32,48,63,242,349,0,413,498,167,167,203]
[]
[]
[null,"Merchant Production"]
[null,"Weapon","Merchant tonnage"]
[]
[null,"Merchant\nTonnage","Country"]
[null,"Year","US","UK","Japan"]
[null,"1939",376419,629705,320466,{"$f":"(D31+C31)/E31","v":3.1395655077293689}]
[null,"1940",528697,842910,293612,4.6714950342629047]
[null,"1941",1031974,1185894,210373,10.542550612483542]
[null,"1942",5479766,1270714,260059,25.957494260917716]
[null,"1943",11448360,1136804,769085,16.363814142780058]
[null,"1944",9288156,919357,1699203,6.007235745228793]
[null,"1945",5839858,393515,599563,10.396527137264975]
[null,"Grand Total",33993230,6378899,4152361,9.7226924633961254]
[]
["Combined Data Table"]
[]
[null,"Country","Weapon","Year","Value"]
[null,"UK","Aircraft carriers",1939,0]
[null,"UK","Aircraft carriers",1940,2]
[null,"UK","Aircraft carriers",1941,2]
[null,"UK","Aircraft carriers",1942,0,null,"Warship Count",null,"Country"]
[null,"UK","Aircraft carriers",1943,2,null,"Year","Weapon","Japan","UK","US",null,null,null,null,"Japan","UK","US"]
[null,"UK","Aircraft carriers",1944,4,null,1942,"Aircraft carriers",6,0,18,null,null,{"$f":"G48","v":1942},{"$f":"H48","v":"Aircraft carriers"},{"$f":"I48","v":6},{"$f":"J48","v":0},{"$f":"K48","v":18}]
[null,"UK","Aircraft carriers",1945,4,null,null,"Battleships",1,2,4,null,null,null,"Battleships",1,2,4]
[null,"UK","Battleships",1939,0,null,null,"Cruisers",4,6,8,null,null,null,"Cruisers",4,6,8]
[null,"UK","Battleships",1940,1,null,null,"Destroyers",10,73,82,null,null,null,"Destroyers",10,73,82]
[null,"UK","Battleships",1941,2,null,null,"Escorts",0,71,0,null,null,null,"Escorts",0,71,0]
[null,"UK","Battleships",1942,2,null,null,"Submarines",61,33,34,null,null,null,"Submarines",61,33,34]
[null,"UK","Battleships",1943,0,null,1943,"Aircraft carriers",4,2,65,null,null,1943,"Aircraft carriers",4,2,65]
[null,"UK","Battleships",1944,0,null,null,"Battleships",0,0,2,null,null,null,"Battleships",0,0,2]
[null,"UK","Battleships",1945,0,null,null,"Cruisers",3,7,11,null,null,null,"Cruisers",3,7,11]
[null,"UK","Cruisers",1939,3,null,null,"Destroyers",12,37,128,null,null,null,"Destroyers",12,37,128]
[null,"UK","Cruisers",1940,7,null,null,"Escorts",0,79,298,null,null,null,"Escorts",0,79,298]
[null,"UK","Cruisers",1941,6,null,null,"Submarines",37,39,55,null,null,null,"Submarines",37,39,55]
[null,"UK","Cruisers",1942,6,null,1944,"Aircraft carriers",5,4,45,null,null,1944,"Aircraft carriers",5,4,45]
[null,"UK","Cruisers",1943,7,null,null,"Battleships",0,0,2,null,null,null,"Battleships",0,0,2]
[null,"UK","Cruisers",1944,2,null,null,"Cruisers",2,2,14,null,null,null,"Cruisers",2,2,14]
[null,"UK","Cruisers",1945,1,null,null,"Destroyers",24,31,74,null,null,null,"Destroyers",24,31,74]
[null,"UK","Destroyers",1939,22,null,null,"Escorts",0,55,194,null,null,null,"Escorts",0,55,194]
[null,"UK","Destroyers",1940,27,null,null,"Submarines",39,39,81,null,null,null,"Submarines",39,39,81]
[null,"UK","Destroyers",1941,39,null,1945,"Aircraft carriers",0,4,13,null,null,1945,"Aircraft carriers",0,4,13]
[null,"UK","Destroyers",1942,73,null,null,"Battleships",0,0,0,null,null,null,"Battleships",0,0,0]
[null,"UK","Destroyers",1943,37,null,null,"Cruisers",0,1,14,null,null,null,"Cruisers",0,1,14]
[null,"UK","Destroyers",1944,31,null,null,"Destroyers",17,13,63,null,null,null,"Destroyers",17,13,63]
[null,"UK","Destroyers",1945,13,null,null,"Escorts",0,7,6,null,null,null,"Escorts",0,7,6]
[null,"UK","Escorts",1939,5,null,null,"Submarines",30,14,31,null,null,null,"Submarines",30,14,31]
[null,"UK","Escorts",1940,109,null,"Grand Total",null,255,519,1242]
[null,"UK","Escorts",1941,87]
[null,"UK","Escorts",1942,71]
[null,"UK","Escorts",1943,79]
[null,"UK","Escorts",1944,55]
[null,"UK","Escorts",1945,7]
[null,"UK","Submarines",1939,7]
[null,"UK","Submarines",1940,15]
[null,"UK","Submarines",1941,20]
[null,"UK","Submarines",1942,33]
[null,"UK","Submarines",1943,39]
[null,"UK","Submarines",1944,39]
[null,"UK","Submarines",1945,14]
[null,"UK","Merchant tonnage",1939,629705]
[null,"UK","Merchant tonnage",1940,842910]
[null,"UK","Merchant tonnage",1941,1185894]
[null,"UK","Merchant tonnage",1942,1270714]
[null,"UK","Merchant tonnage",1943,1136804]
[null,"UK","Merchant tonnage",1944,919357]
[null,"UK","Merchant tonnage",1945,393515]
[null,"US","Aircraft carriers",1939,0]
[null,"US","Aircraft carriers",1940,0]
[null,"US","Aircraft carriers",1941,0]
[null,"US","Aircraft carriers",1942,18]
[null,"US","Aircraft carriers",1943,65]
[null,"US","Aircraft carriers",1944,45]
[null,"US","Aircraft carriers",1945,13]
[null,"US","Battleships",1939,0,null,"Chart Title","Warships Produced Per Year By Combatant"]
[null,"US","Battleships",1940,0,null,"X Label","Year/Type"]
[null,"US","Battleships",1941,0,null,"Y Label","Count"]
[null,"US","Battleships",1942,4]
[null,"US","Battleships",1943,2]
[null,"US","Battleships",1944,2]
[null,"US","Battleships",1945,0]
[null,"US","Cruisers",1939,0]
[null,"US","Cruisers",1940,0]
[null,"US","Cruisers",1941,1]
[null,"US","Cruisers",1942,8]
[null,"US","Cruisers",1943,11]
[null,"US","Cruisers",1944,14]
[null,"US","Cruisers",1945,14]
[null,"US","Destroyers",1939,0]
[null,"US","Destroyers",1940,0]
[null,"US","Destroyers",1941,2]
[null,"US","Destroyers",1942,82]
[null,"US","Destroyers",1943,128]
[null,"US","Destroyers",1944,74]
[null,"US","Destroyers",1945,63]
[null,"US","Escorts",1939,0]
[null,"US","Escorts",1940,0]
[null,"US","Escorts",1941,0]
[null,"US","Escorts",1942,0]
[null,"US","Escorts",1943,298]
[null,"US","Escorts",1944,194]
[null,"US","Escorts",1945,6]
[null,"US","Submarines",1939,0]
[null,"US","Submarines",1940,0]
[null,"US","Submarines",1941,2]
[null,"US","Submarines",1942,34]
[null,"US","Submarines",1943,55]
[null,"US","Submarines",1944,81]
[null,"US","Submarines",1945,31]
[null,"US","Merchant tonnage",1939,376419]
[null,"US","Merchant tonnage",1940,528697]
[null,"US","Merchant tonnage",1941,1031974]
[null,"US","Merchant tonnage",1942,5479766]
[null,"US","Merchant tonnage",1943,11448360]
[null,"US","Merchant tonnage",1944,9288156]
[null,"US","Merchant tonnage",1945,5839858]
[null,"Japan","Escorts",1939,0]
[null,"Japan","Escorts",1940,0]
[null,"Japan","Escorts",1941,0]
[null,"Japan","Escorts",1942,0]
[null,"Japan","Escorts",1943,0]
[null,"Japan","Escorts",1944,0]
[null,"Japan","Escorts",1945,0]
[null,"Japan","Aircraft carriers",1939,0]
[null,"Japan","Aircraft carriers",1940,0]
[null,"Japan","Aircraft carriers",1941,1]
[null,"Japan","Aircraft carriers",1942,6]
[null,"Japan","Aircraft carriers",1943,4]
[null,"Japan","Aircraft carriers",1944,5]
[null,"Japan","Aircraft carriers",1945,0]
[null,"Japan","Battleships",1939,0]
[null,"Japan","Battleships",1940,0]
[null,"Japan","Battleships",1941,1]
[null,"Japan","Battleships",1942,1]
[null,"Japan","Battleships",1943,0]
[null,"Japan","Battleships",1944,0]
[null,"Japan","Battleships",1945,0]
[null,"Japan","Cruisers",1939,0]
[null,"Japan","Cruisers",1940,0]
[null,"Japan","Cruisers",1941,0]
[null,"Japan","Cruisers",1942,4]
[null,"Japan","Cruisers",1943,3]
[null,"Japan","Cruisers",1944,2]
[null,"Japan","Cruisers",1945,0]
[null,"Japan","Destroyers",1939,0]
[null,"Japan","Destroyers",1940,0]
[null,"Japan","Destroyers",1941,0]
[null,"Japan","Destroyers",1942,10]
[null,"Japan","Destroyers",1943,12]
[null,"Japan","Destroyers",1944,24]
[null,"Japan","Destroyers",1945,17]
[null,"Japan","Submarines",1939,0]
[null,"Japan","Submarines",1940,0]
[null,"Japan","Submarines",1941,0]
[null,"Japan","Submarines",1942,61]
[null,"Japan","Submarines",1943,37]
[null,"Japan","Submarines",1944,39]
[null,"Japan","Submarines",1945,30]
[null,"Japan","Merchant tonnage",1939,320466]
[null,"Japan","Merchant tonnage",1940,293612]
[null,"Japan","Merchant tonnage",1941,210373]
[null,"Japan","Merchant tonnage",1942,260059]
[null,"Japan","Merchant tonnage",1943,769085]
[null,"Japan","Merchant tonnage",1944,1699203]
[null,"Japan","Merchant tonnage",1945,599563]

{"sheet":"Aircraft","index":1,"n_rows":126,"n_cols":18,"rows_kept":126,"cut":false,"hidden":false,"merged":[]}
["FROM:","Mark Biegert"]
["SUBJECT:","Aircraft Production US, UK, Japan"]
["DATE:","2017-12-04"]
[]
["Pivot Table"]
[null,"The following table shows the production of four types of"]
[null,"aircraft during the years 1941 through 1945."]
[]
[null,"Weapon","Country","Sum of Value"]
[null,"Training planes","Japan",15201]
[null,null,"UK",31894]
[null,null,"US",57623]
[null,"Reconn planes","Japan",5654]
[null,null,"UK",3967]
[null,null,"US",3918]
[null,"Bomber planes","Japan",15117]
[null,null,"UK",34689]
[null,null,"US",35366]
[null,"Fighter planes","Japan",30447]
[null,null,"UK",49422]
[null,null,"US",99950]
[null,"Grand Total",null,383248]
[]
["Table for Plotting (I did not want a Pivot Chart)"]
[]
[null,"Type","Country","Value1"]
[null,{"$f":"IF(LEN(B10)=0,\"\",B10)","v":"Training planes"},{"$f":"C10","v":"Japan"},{"$f":"D10","v":15201}]
[null,"",{"$f":"C11","v":"UK"},31894]
[null,"",{"$f":"C12","v":"US"},57623]
[null,"Reconn planes",{"$f":"C13","v":"Japan"},5654]
[null,"",{"$f":"C14","v":"UK"},3967]
[null,"",{"$f":"C15","v":"US"},3918]
[null,"Bomber planes",{"$f":"C16","v":"Japan"},15117]
[null,"",{"$f":"C17","v":"UK"},34689]
[null,"",{"$f":"C18","v":"US"},35366]
[null,"Fighter planes",{"$f":"C19","v":"Japan"},30447]
[null,"",{"$f":"C20","v":"UK"},49422]
[null,"",{"$f":"C21","v":"US"},99950]
[]
["Cleaned Data"]
[]
["Country","Weapon","Year","Value"]
["UK","Fighter planes",1939,1324]
["UK","Fighter planes",1940,4283]
["UK","Fighter planes",1941,7064]
["UK","Fighter planes",1942,9849]
["UK","Fighter planes",1943,10727]
["UK","Fighter planes",1944,10730]
["UK","Fighter planes",1945,5445]
["UK","Bomber planes",1939,1837]
["UK","Bomber planes",1940,3488]
["UK","Bomber planes",1941,4668]
["UK","Bomber planes",1942,6253]
["UK","Bomber planes",1943,7728]
["UK","Bomber planes",1944,7903]
["UK","Bomber planes",1945,2812]
["UK","Reconnaissance planes",1939,61]
["UK","Reconnaissance planes",1940,387]
["UK","Reconnaissance planes",1941,196]
["UK","Reconnaissance planes",1942,546]
["UK","Reconnaissance planes",1943,1054]
["UK","Reconnaissance planes",1944,1123]
["UK","Reconnaissance planes",1945,600]
["UK","Training planes",1939,4209]
["UK","Training planes",1940,6415]
["UK","Training planes",1941,6934]
["UK","Training planes",1942,5942]
["UK","Training planes",1943,4825]
["UK","Training planes",1944,2877]
["UK","Training planes",1945,692]
["US","Fighter planes",1939,0]
["US","Fighter planes",1940,1162]
["US","Fighter planes",1941,4416]
["US","Fighter planes",1942,10769]
["US","Fighter planes",1943,23988]
["US","Fighter planes",1944,38873]
["US","Fighter planes",1945,20742]
["US","Bomber planes",1939,0]
["US","Bomber planes",1940,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"   "]
["US","Bomber planes",1941,0]
["US","Bomber planes",1942,2615]
["US","Bomber planes",1943,9615]
["US","Bomber planes",1944,16331]
["US","Bomber planes",1945,6805]
["US","Reconnaissance planes",1939,0]
["US","Reconnaissance planes",1940,63]
["US","Reconnaissance planes",1941,727]
["US","Reconnaissance planes",1942,1468]
["US","Reconnaissance planes",1943,734]
["US","Reconnaissance planes",1944,259]
["US","Reconnaissance planes",1945,667]
["US","Training planes",1939,0]
["US","Training planes",1940,1794]
["US","Training planes",1941,9373]
["US","Training planes",1942,17631]
["US","Training planes",1943,19939]
["US","Training planes",1944,7577]
["US","Training planes",1945,1309]
["Japan","Fighter planes",1939,0]
["Japan","Fighter planes",1940,0]
["Japan","Fighter planes",1941,1080]
["Japan","Fighter planes",1942,2935]
["Japan","Fighter planes",1943,7147]
["Japan","Fighter planes",1944,13811]
["Japan","Fighter planes",1945,5474]
["Japan","Bomber planes",1939,0]
["Japan","Bomber planes",1940,0]
["Japan","Bomber planes",1941,1461]
["Japan","Bomber planes",1942,2433]
["Japan","Bomber planes",1943,4189]
["Japan","Bomber planes",1944,5100]
["Japan","Bomber planes",1945,1934]
["Japan","Reconnaissance planes",1939,0]
["Japan","Reconnaissance planes",1940,0]
["Japan","Reconnaissance planes",1941,639]
["Japan","Reconnaissance planes",1942,967]
["Japan","Reconnaissance planes",1943,1046]
["Japan","Reconnaissance planes",1944,2147]
["Japan","Reconnaissance planes",1945,855]
["Japan","Training planes",1939,0]
["Japan","Training planes",1940,0]
["Japan","Training planes",1941,1489]
["Japan","Training planes",1942,2171]
["Japan","Training planes",1943,2871]
["Japan","Training planes",1944,6147]
["Japan","Training planes",1945,2523]

{"sheet":"US_In_Uniform","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"US MILITARY PERSONNEL (1939-1945): Running Totals"]
[]
[null,"Year","Army","Navy","Marines","Coast Guard*","Total"]
[null,1939,189839,125202,19432,0,{"$f":"(SUM(C5:F5))+0","v":334473}]
[null,1940,269023,160997,28345,0,458365]
[null,1941,1462315,284427,54359,0,1801101]
[null,1942,3075608,640570,142613,56716,3915507]
[null,1943,6994472,1741750,308523,151167,9195912]
[null,1944,7994750,2981365,475604,171749,11623468]
[null,1945,8267958,3380817,474680,85783,12209238]
[]
[null,"*Coast Guard listed only as wartime strength"]