LSU_ALPHA_LIST Report
In this topic you will learn how to run the LSU_ALPHA_LIST Report.
You will add a column to the existing query. On the Query tab, select record A: Job - EE Job History record and check the FTE option.
Click the Show Fields button for Record A Job - EE Job History.
Click the Select option for FTE - FTE.
FTE displays as a Record.Fieldname.
NOTE: Queries should always be run in HTML format first to ensure that all data is viewed.
Click the Download to Excel link.
This will open a new window.
NOTE: Employee names, NIDs, Monthly Rates and Hrly Rates have been removed for training purposes only.
Click the Page Layout tab.
Find and Replace
Click the Home tab.
Sort
Click the Data option.
Subtotal
Click the Subtotals button.
Add a Column
Click the G cell to highlight the entire column.
Right-click the highlighted area.
Formulas
You will multiply the number of hours worked in a year (2080) by the FTE and Hrly Rt to calculate the Yearly Rt.
In the G4 cell, press the left mouse button and drag the mouse down to highlight cells G4 thru G96.
Add Sheet
Click the Home button.
Click on cell A, press the left mouse button and drag the mouse to the right to highlight columns A thru M.
Right-click the highlighted area.
Click the G cell to highlight the entire column.
Right-click the highlighted area.
Unhide
Click the A cell, press the left mouse button and drag the mouse to the right to highlight all columns.
Right-click the highlighted area.
The following topics will be demonstrated in this topic:
• Find and Replace;
• Sort;
• Subtotal;
• Formulas;
• Add/Delete Sheet; and
• Add/Delete columns.
You may need to resize the columns so that the data will display properly.
Enter the desired information into the Constant field. Enter "5 - character Business Unit".
NOTE: In this example the EKLMC BU is used.
The page break is inserted above line 23 on the worksheet. The page break is designated by the dashed line.
LSU_ALPHA_LIST Report
This completes LSU_ALPHA_LIST Report.
Formulas
You will multiply the number of hours worked in a year (2080) by the FTE and Hrly Rt to calculate the Yearly Rt.
Enter the desired information into the Constant field. Enter a valid value e.g. "5 - character Business Unit".
NOTE: In this example the EKLMC BU is used.
Enter the desired information into the begins with field. Enter a valid value
e.g.
"LSU_ALPHA"
. Click the Search button.
Click the Edit link.
Click the Query tab.
Click the Show Fields button.
Click the Sort fields alphabetically button.
Click the Select option.
Click the Fields tab.
Click the Run tab.
Click the Download to Excel link.
Click the Open button.
Click the Page Layout tab.
Click the Print Titles button.
Click the Landscape option.
Click the Home tab.
Click the Find & Select button.
Enter the desired information into the Find what field. Enter a valid value
e.g.
"RN 2"
. Enter the desired information into the Replace with field. Enter a valid value
e.g.
"REG NURSE 2"
. Click the Replace All button.
Click the OK button.
Click the Close button.
Click the Data button.
Click the Sort... button.
Click the button to the right of the Sort by field.
Click the Dept ID list item.
Click the button to the right of the Then by field.
Click the Descr list item.
Click the OK button.
Click the Subtotals button.
Click the button to the right of the At each change in: field.
Click the DeptID list item.
Click the OK button.
Click the G cell.
Right-click the desired object.
Click the Insert list item.
Enter the desired information into the G2 field. Enter a valid value
e.g.
"Yearly Rt"
. Enter the desired information into the G3 field. Enter a valid value
e.g.
"=2080*"
. Click the L3 cell.
Press [Enter].
Right-click the G3 cell.
Click the Copy list item.
Press the left mouse button and drag the mouse to the desired location.
Right-click the desired object.
Click the Paste list item.
Click the Office button.
Point to the Print menu.
Click the Close Print Preview button.
Click the 23 cell.
Click the Breaks button.
Click the Insert Page Break list item.
Click the Home button.
Click the button to the right of the Insert field.
Click the sheet 1 horizontal tab.
Press the left mouse button and drag the mouse to the desired location.
Right-click the desired object.
Click the Copy list item.
Click the Sheet 2 horizontal tab.
Right-click the A1 cell.
Click the Paste list item.
Click the button to the right of the Delete field.
Click the Delete Sheet list item.
Click the Delete button.
Double-click the sheet 1 horizontal tab.
Enter the desired information into the sheet 1 field. Enter a valid value
e.g.
"ALPHA LIST"
. Click the G cell.
Right-click the desired object.
Click the Delete list item.
Press the left mouse button and drag the mouse to the desired location.
Right-click the desired object.
Click the Unhide list item.
Click the button to the right of the Paper size field.
Click the Legal list item.
Click the OK menu.
Click the View 100 link.
Click the Down button of the scrollbar.
Click the Add Criteria button.
Enter the desired information into the Constant field. Enter a valid value
e.g.
"Business Unit"
. Click the OK button.
Click the Replace... menu.
Click in the H3 field.
Click the Add Level button.
Enter the desired information into the field. Enter a valid value
e.g.
"*"
. Click the M3 cell.
Click the Print Preview menu.
Click the Insert Sheet list item.
DPIINFODIV
LSU_ALPHA_LIST Report