Product: Slide 5A SEAT use – Purpose: Provide data on SEAT activity by GACC and highlight SEATs flying >6 hours in day. Data Source: Daily SEAT Status- By GACC Report (provided by SEAT Detailer) Process: Review Daily SEAT Status report highlighting GACC, for “Committed”, “Totals GACC”, and Hrs” for SEATs that flew. “Daily Open excel spreadsheet: (slide may also we worked on directly) S:\WP\NMAC SUPPORT 2008\NMAC\Products\Briefing Powerpoints\supporting documents\seat.xlsx data in table from Daily SEAT Status report: = of Committed Seats” “Committed” “Number for GACC” = Flown” “Totals “Hrs Tabulate number of SEATS with Hrs” and input number into of “Daily “# Aircraft Reporting Hours Flown” Flown/Aircraft” will automatically calculate. “Avg/Hrs. Manually enter number of aircraft, based on Hrs”, that had hours >6 “Daily Cut and paste table from excel into PowerPoint slide. Send table to back (should be able to view text boxes). Based on totals in table, edit text box at the bottom of the slide. Highlight number of aircraft with 6 hours or greater flight time. Product: 6A Items of Interest –
Product: Slide 5A – SEAT use Purpose: Provide data on SEAT activity by GACC and highlight SEATs flying >6 hours in day. Data Source: Daily SEAT Status- By GACC Report (provided by SEAT Detailer) Process: Review Daily SEAT Status report highlighting GACC, “Committed”, “Totals for GACC”, and “Daily Hrs” for SEATs that flew. Open excel spreadsheet: (slide may also we worked on directly) S:\WP\NMAC SUPPORT 2008\NMAC\Products\Briefing Powerpoints\supporting documents\seat.xlsx data in table from Daily SEAT Status report: “Committed” = “Number of Committed Seats” “Totals for GACC” = “Hrs Flown” Tabulate number of SEATS with “Daily Hrs” and input number into “# of Aircraft Reporting Hours Flown” “Avg/Hrs. Flown/Aircraft” will automatically calculate. Manually enter number of aircraft, based on “Daily Hrs”, that had hours >6 Cut and paste table from excel into PowerPoint slide. Send table to back (should be able to view text boxes). Based on totals in table, edit text box at the bottom of the slide. Highlight number of aircraft with 6 hours or greater flight time. Product: 6A – Items of Interest