AE Dashboard by linzhengnd

VIEWS: 3 PAGES: 8

									                                                             Visit www.aerovacworld.com for updates to this dashboard and
                                                             other AE stuff. Sign up for an account (it's free) and starting posting
                                                             to the community!



              The AE Dashboard: A consolidation of all the material covered in this spreadsheet. This is your one stop shop for
              planning missions. For more specific links look for the   arrow's down below. All white cells are input fields.

              There are over 10401 airports referenced here. Filter the data to find your airport or enter an ICAO code to see what
              airport it is. Also available, Military base search only.

              Need to look up a julian date for a certain day? You can find that here. Just enter the date and your JD will
              automatically pull up for you.

              Find out what time it is in another city/state/country. Cities are also hyperlinked to give you more information such
              as weather, dialing codes, coordinates, etc. Internet needed

              Only have the takeoff time? Need an alert/show time instead? NOTE: Enter time in the format as follows -
              01 Jan 13:00 This will allow your times to calculate properly.


              Click here to select airframe and find alert times, AE configurations, 02, electrical, PMCR, etc.


              PTLOX calculator & 02 cylindar conversion here.


              Find equipment AMPS, weights, PMI & power requirements here.


              Enter PT validation data here.


              Contact me for any questions or to report any errors. Enjoy!




                                                                                                                                       Front Page
C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx
                                                                   Front Page
C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx
                 Main           ICAO          Julian        Time       ETD Boxes
                 Menu           Codes         Date          Zones

                                                                                                                05 December 2011




                            TODAY'S JULIAN DATE JD 339                                 AE CONFIGURATIONS                            ELECTRICAL
                        SELECT AIRFRAME            Enter Alert Time

                       AE Crew Alert Times
                            Show Time
                     Scheduled Takeoff time                                                                                           OXYGEN
                          Max FDP (Basic)
                          Max CDT (Basic)                                          NOTE
                      Max FDP (Augmented)
                      Max CDT (Augmented)                                                                                          Additional Notes
                                 Max Alert/Takeoff Times
                    Latest Allowable Alert Time
                        Latest Takeoff Time                                           CCATT (Gear = 1200lbs)
                               POST MISSION CREW REST                            1 CCATT can handle max of 3 vents
                           Date Departed                                      No more than 6 patients total for one team
                           Date Returned
                         Total Hours of CR                                                          City
                                                                           INPUT
                       Date Return from CR                                                          State
                                                                           ICAO
                                                                                                   Country
                                 Time Zone Calculator                                             SEARCH ONLY MILITARY BASES HERE
                     Where are you at?        What time do you need?                                                                       ICAO CODE
                                                                            SELECT
                                                                             BASE




C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx                                                                               AE Mission Planning Dashboard
                 Main           ICAO          Julian        Time        ETD Boxes
                 Menu           Codes         Date          Zones

                                                                                                               05 December 2011




                                 PTLOX CALCULATOR                            GENERAL CONVERSION FOR O2 CYLINDARS               IV INFUSION FORMULA
                      Mission Time in Hours                                 Gauge Pressure                             # Total Amount (ML)
                           LOX Needed                0.00                   Cylindar Constant                          # Drop Factor
                Patient Name/Cite #    LPM        NOTE:                     Flow Rate in LPM                             Total Time in Minutes
                                                                            Minutes of O2 Available                      Drop/Minutes
                                                                            Hours of O2 Available
                                                                                                                                    PSP WEIGHTS
                                                                                          BURN FORMULAS
                                                                                                  LBS           KG
                                                                            Patient Weight                      0.00
                                                                            Percentage Burned                            PATIENT MOVEMENT
                                                                            Total fluid for 24 hours                      CLASSIFICATIONS
                                                                            1st half over first 8 hours
                                                                            2nd half over remaining 16 hours

                        SELECT EQUIPMENT               AMPS        WEIGHT     PMI               POWER REQUIREMENT




                                                                                                                               OXYGEN CONVERSION
                                                                                                                         Enter Cabin Altitude
                                                                                                                         Enter Sea Level O2 level
                                                                                                                         Desired O2%




                                                                             05 Dec 11 / 1557
                   ENTER CITE #          STATUS        TIME VALIDATED           EXPIRES               ELAPSED TIME       TIME DIFFERENCE CALCULATOR
                                                                                                                           Time Received/Validated PMR

                                                                                                                                  Time PT Departed

                                                                                                                                  Total Elapsed Time



C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx                                                                               AE Mission Planning Dashboard
                                                             ICAO = International Civil Aviation Organization




C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx                                                ICAO Prefix Codes
                       Find a Julian Date by entering date below   Find a date by entering a Julian Date

                          Enter Date            Julian Date        Enter Julian Date          Date
                           26-Mar-08               JD 086               08086              26-Mar-08


                                                                      Calculate an age of something
                                Find the week number
                                                                      Enter Date           26-Mar-79
                          Enter Date
                                                     13                  32 years 8 months 9 days
                           26-Mar-08




C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx                                           Julian Date Lookup
                                                                             Where are you                       What city do you want
                                                                             at right now?              to find the current time in as of now?
                                                                              Al Udeid AB                              St. Louis
                                                                       If time in Al Udeid AB is               Then time in St. Louis is
                                                                            05 Dec 11 15:57                         05 Dec 11 06:57

                                                                                -9 hrs Diff. between Al Udeid AB and St. Louis

                                                                                     Al Udeid AB is 3 Ahead of UTC (GMT)

                                                                                       St. Louis is -6 Behind UTC (GMT)


                                                                                             WORLD TIME CONVERTER
                                                                   Select a city & enter date & time     Select a city & your time will display


                                                                             If time in is                       Then time in will be




                                                                                                                                                  Time Zone Calculator
C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx
                     SELECT AIRFRAME                 Enter ETD              SELECT AIRFRAME                Enter ETD

                     AE Crew Alert Times                                    AE Crew Alert Times
                         Time Alerted                                           Time Alerted
                          Show Time                                              Show Time
                       Max FDP (Basic)                                        Max FDP (Basic)
                       Max CDT (Basic)                                        Max CDT (Basic)
             #      2 Hr Extension (CDT)                           ##      2 Hr Extension (CDT)
             #            Tactical Day                             ##            Tactical Day
                    Max FDP (Augmented)                                    Max FDP (Augmented)
                    Max CDT (Augmented)                                    Max CDT (Augmented)
                            AFI 11-2AE-V3 Chapter 3.11.2                           AFI 11-2AE-V3 Chapter 3.11.2
               Latest Allowed Alert                                   Latest Allowed Alert
               Latest Takeoff Time                                    Latest Takeoff Time




                     SELECT AIRFRAME                 Enter ETD              SELECT AIRFRAME                Enter ETD

                     AE Crew Alert Times                                    AE Crew Alert Times
                         Time Alerted                                           Time Alerted
                          Show Time                                              Show Time
                       Max FDP (Basic)                                        Max FDP (Basic)
                       Max CDT (Basic)                                        Max CDT (Basic)
             #      2 Hr Extension (CDT)                           ##      2 Hr Extension (CDT)
             #            Tactical Day                             ##            Tactical Day
                    Max FDP (Augmented)                                    Max FDP (Augmented)
                    Max CDT (Augmented)                                    Max CDT (Augmented)
                            AFI 11-2AE-V3 Chapter 3.11.2                           AFI 11-2AE-V3 Chapter 3.11.2
               Latest Allowed Alert                                   Latest Allowed Alert
               Latest Takeoff Time                                    Latest Takeoff Time




C:\Docstoc\Working\pdf\3fcdbf59-6d37-4535-a352-a430165138c5.xlsx                                                       ETD Boxes

								
To top