Gh0st
Feb-10-2016, 22:36
Version: Microsoft Excel 2010.
The idea is to coordinate different bomber groups, interceptors and escorts and be able to navigate at low altitude.
Changes
1.2- Updated fuel consumption
v1.6-Updated TAS reconciled with Il2 JU88 TAS Chart
v1.7-Fixed coordinates table
v2-Gunnery and TAS data
v2.4-Added Wind Direction, Wind Speed, Ground Speed and Wind Correction Angle
Example: Bomber Flight Plan Mission Break
20592
Lat & Long precision is six decimal places which is extremely precise reducing the number of decimal places down to 3 or 4 is probably good enough to find the area. If I remember correctly 4 decimal places is 1Km.
Instructions:
1. Find your target on Google Maps
2. Click on a target to get the coordinates Latitude & Longitude
20560
3.Click on the "Coordinates" tab
4. Add waypoint to the end of the table by entering a name, latitude and longitude
5. Sort table by City
6. Copy and paste land marks and recon pics
How to use it:
1. Click on drop down and
2. Select Start point
3. Select End point
4. After that the next Start point will auto-populate
5. Do Not Clear Column C; only column D should be cleared in the "Bomber" tab.
6. Add additional worksheets for fighters or other groups
20559
I have been searching for fuel consumption ratings for the different German planes and found some, but
RAF low altitude navigation training video Part 1/2
https://www.youtube.com/watch?v=NQWZEVaoFKQ
RAF low altitude navigation training video Part 2/2
https://www.youtube.com/watch?v=C6oGa1bqe1U
I you have 1940 German fonts, it will look AWESOME!!
Salute!
Gh0st
Airport information:
Location
City: Bromley, Kent, England, United Kingdom
Name: London Biggin Hill
Old (Alt.): RAF Biggin Hill
ICAO / IATA: EGKB / BQH
Details
Type: Airport (Aerodrome, Airfield)
Use: Public/Civil, International (customs port of entry)
Latitude: 51°19'51"N (51.330833)
Longitude: 0°01'57"E (0.032500)
Elevation: 599 ft (183 m)
Variation: 0.63°W (WMM2015 magnetic declination)
0.15° annual change
Location
City: Le Havre, Haute-Normandie (Upper Normandy), France
Name: Octeville
ICAO / IATA: LFOH / LEH
Details
Type: Airport (Aerodrome, Airfield)
Use: Public/Civil
Latitude: 49°32'02"N (49.533889)
Longitude: 0°05'17"E (0.088056)
Elevation: 313 ft (95 m)
Variation: 0.42°W (WMM2015 magnetic declination)
0.14° annual change
The idea is to coordinate different bomber groups, interceptors and escorts and be able to navigate at low altitude.
Changes
1.2- Updated fuel consumption
v1.6-Updated TAS reconciled with Il2 JU88 TAS Chart
v1.7-Fixed coordinates table
v2-Gunnery and TAS data
v2.4-Added Wind Direction, Wind Speed, Ground Speed and Wind Correction Angle
Example: Bomber Flight Plan Mission Break
20592
Lat & Long precision is six decimal places which is extremely precise reducing the number of decimal places down to 3 or 4 is probably good enough to find the area. If I remember correctly 4 decimal places is 1Km.
Instructions:
1. Find your target on Google Maps
2. Click on a target to get the coordinates Latitude & Longitude
20560
3.Click on the "Coordinates" tab
4. Add waypoint to the end of the table by entering a name, latitude and longitude
5. Sort table by City
6. Copy and paste land marks and recon pics
How to use it:
1. Click on drop down and
2. Select Start point
3. Select End point
4. After that the next Start point will auto-populate
5. Do Not Clear Column C; only column D should be cleared in the "Bomber" tab.
6. Add additional worksheets for fighters or other groups
20559
I have been searching for fuel consumption ratings for the different German planes and found some, but
RAF low altitude navigation training video Part 1/2
https://www.youtube.com/watch?v=NQWZEVaoFKQ
RAF low altitude navigation training video Part 2/2
https://www.youtube.com/watch?v=C6oGa1bqe1U
I you have 1940 German fonts, it will look AWESOME!!
Salute!
Gh0st
Airport information:
Location
City: Bromley, Kent, England, United Kingdom
Name: London Biggin Hill
Old (Alt.): RAF Biggin Hill
ICAO / IATA: EGKB / BQH
Details
Type: Airport (Aerodrome, Airfield)
Use: Public/Civil, International (customs port of entry)
Latitude: 51°19'51"N (51.330833)
Longitude: 0°01'57"E (0.032500)
Elevation: 599 ft (183 m)
Variation: 0.63°W (WMM2015 magnetic declination)
0.15° annual change
Location
City: Le Havre, Haute-Normandie (Upper Normandy), France
Name: Octeville
ICAO / IATA: LFOH / LEH
Details
Type: Airport (Aerodrome, Airfield)
Use: Public/Civil
Latitude: 49°32'02"N (49.533889)
Longitude: 0°05'17"E (0.088056)
Elevation: 313 ft (95 m)
Variation: 0.42°W (WMM2015 magnetic declination)
0.14° annual change