Databases Reference
In-Depth Information
Should you want to update the remaining expressions, their corresponding
definitions are shown in the following table.
Variable name
Expression
Description/Comment
eAirtime
(Sum ([# Air Time]) /
Sum ([# Ramp-To-Ramp
Time]))
Time spent flying versus
total ramp-to-ramp time
eEnplanedPassengers
(Sum ([# Transported
Passengers]) /
1000000)
Total enplaned
passengers in millions
eAvailableSeats
(Sum ([# Available
Seats]) / 1000000)
Total available seats in
millions
eDeparturesPerformed
(Sum ([# Departures
Performed]) / 1000)
Total departures
performed in thousands
eRevenuePassengerMiles
(Sum ([# Transported
Passengers] *
Distance) / 1000000)
The total number of
miles (in millions) that
all passengers were
transported
eAvailableSeatMiles
(Sum ([# Available
Seats] * Distance) /
1000000)
The total number of
miles (in millions) that
all seats, including
unoccupied seats, were
transported
Now that we've seen how we can create variables and how we can use them to re-
use expressions in our document, let's create the
Reports
sheet.
Copying sheets
While building the
Dashboard
sheet, we created a new sheet and copied linked
versions of all the relevant objects. Another approach is to copy an existing sheet and
remove all the unnecessary objects from it. We will take this approach to create our
initial
Reports
sheet:
1.
Go to the
Analysis
sheet.
2.
Right-click on an empty space on the worksheet and select
Copy Sheet
from
the context menu.
3.
Open the
Sheet Properties
window for the new copy of the
Analysis
sheet
by pressing
Ctrl
+
Alt
+
S
.
