RHSEOS Japanese Bomber Utility

[el cid again]

This is a very complex spreadsheet - due to the need to rate bombers in different roles. This version is for EOS family scenarios. A similar one
probably will be done for CVO and BBO families - called Standard. An Allied one is not coming soon: it would take a lot of work, and it has less utility because there is no need to make Allied production decisions - but maybe someday. Only the ratings and notes are reproduced here: the actual spreadsheet has comprehensive data for each aircraft.

Notes Air Combat SR Bmr LR Bmr Nav Bmr LR NavBmr Combined Cost/Eff Designation
Note 6 3 2 0 2 0 1 0.3 B5N2-Q
Note 7 4 20 4 19 2 11 2.0 G4M3M34-Q
Note 1 4 6 2 4 1 3 0.9 D3A2
Note 21 9 29 10 19 6 16 4.5 D4Y2
Note 3 1 2 0 2 0 1 0.3 B4Y1
Note 3 3 4 1 4 0 2 0.7 B5M/B5N/Ki-47
Note 3 6 10 2 9 1 6 1.6 B6N2
Note 3 10 34 7 33 3 19 5.3 B7A2
Note 3 2 10 2 10 1 6 1.1 G3M2/Ki-43
Note 3 3 17 3 16 2 10 1.8 G4M1/Ki-50
Note 3 3 22 4 21 2 12 2.3 G4M2m22
Note 8 3 15 3 47 1 16 3.0 G4M2e&Okha
2 51 10 26 5 23 2.5 G5N3/Ki-68
Note 9 4 87 24 52 15 45 4.9 G5N4/Ki-85
Note 17 6 42 8 68 4 30 5.6 G7M1/Ki-124
6 369 74 184 37 166 18.4 G8N1/Ki-90
Note 10 1 5 1 3 1 2 0.3 H6K4
Note 11 4 49 10 25 5 22 2.5 H8K2
Note 21 2 22 5 14 3 11 2.0 Ju-88A4/D4J4
Note 12 3 4 0 7 0 31 5.7 Ju-88C6/D4J6
3 14 3 7 1 6 1.1 Ki-21 II
4 12 2 6 1 5 1.5 Ki-32/30
Note 13 3 1 1 1 0 1 0.2 Ki-36
Note 15 2 7 3 3 2 4 0.7 Ki-48 I
3 16 4 8 2 7 1.4 Ki-49 I
Note 18 4 22 4 21 2 13 2.3 Ki-49 IIQ
Note 14 5 3 1 2 1 2 0.5 Ki-51
Note 16 4 28 6 14 3 13 2.3 Ki-67
3 57 12 29 6 26 4.8 Ki-74/C7T1
Note 3 5 27 5 25 3 15 2.8 P1Y1
Note 19 1 0 0 0 0 0 0.0 Vichy P63.11
1 2 0 1 0 1 0.2 RTAF B-10
Note 19 2 0 0 0 0 0 0.0 RTAF V-935

[el cid again]

Note: RHS Firepower = the sum of the product of Effect and Penetration fields for all guns facing forward.
Note 1: The Val dive bomber sank more ships than any other bomber in history.
Note 2: The "Operational Ceiling" is an RHS concept: it is approximately halfway between Service Ceiling and Optimum Operating Altitude. It is defined as 80% of Service Ceiling for normal piston engines; 90% of Service Ceiling for turbosupercharged piston engines;
and as 95% of Service Ceiling for jet engines or rocket engines.
Note 3: Carries 1 x 800 kg torpedo with a 240 kg warhead vs naval targets to normal range. Note 4: The value of rockets is not evaluated in ratings. They may work in both air v air and air v ground combat.
Note 5: Cost / Effectiveness is in terms of combined value / HI points. Note 6: Carries 1 x 250 kg bomb and 2 DC vs submarine targets. Equipped with MAD and radar.
Note 7: Carries 2x250 kg bombs & 2xDC vs submarine targets. Equipped with MAD and Radar. Note 8: Carries 1xOhha Anti-shipping missile with 802 kg warhead vs naval targets to normal range.
Note 9: Carries 2xHS-293 PGM plus 8x250 kg bombs to normal range and 2xHS-293 PGM plus 4x250 kg bombs to extended range. Each HS-293 has a 325 kg warhead.
Note 10: Carries 8 x 60 kg bombs or DC to normal range. Carries 4 x 60 kg bombs or DC to extended range.
Note 11: Carries 16 x 60 kg bombs or DC to normal range. Carries 8 x 60 kg bombs or DC to extended range. Late war units equipped with MAD and radar.
Note 12: Night Fighter/Night Intruder. Mid war units arrive with "Schrage Musik" (2x upward firing 20 mm guns). Does not carry bombs to extended range. Does not make daylight naval attacks. Night fighter air combat value = 10 (15 with Schrage Musik).
Night Fighter CAP value = 16. Night Fighter Escort value = 15. Combined value includes these ratings.
Note 13: Shown with default armament of 3 x 100 lb ICB clusters (= 3 x 15 kg bombs). This is carried to extended range. Some units carry 6x 25kg Uji BW bombs. Value as BW bombers no evaluated (probably 1). Dive bomber (really).
Note 14: Carries 4x100 lb ICB clusters (= 3 x 15 kg bombs). Dive bomber.
Note 15: Carries 8x100 lb ICB clusters (= 3 x 15 kg bombs).
Note 16: Selected units carry 1 x 800 kg torpedo with a 240 kg warhead vs naval targets to normal range. In this form NR Naval Bomber rating = 16.
Note 17: Carries 1 x 1669 kg torpedo with a 406 kg warhead vs naval targets to normal range.
Note 18: Carries 4 x 250 kg bombs and 4 x DC vs submarine targets. Equipped with MAD and radar.
Note 19: This observation aircraft is properly shown as a virtually worthless bomber.
Note 20: Short range bomber rating: the ability to carry 500 kg of bombs to 5 hexes; Long range bomber rating: the abilty to carry 500 kg of bombs to 10 hexes; Naval bomber rating: normal range anti-ship value; Long range Naval bomber rating: extended range anti-ship value.
Note 21: Dive bomber.