FUEL AND OIL ISSUE SUMMARY

 

INSTRUCTIONS

 

 

Worksheet is in Microsoft Excel.

 

The following columns contain formulas for calculations.

1.    Regular Total

2.    Diesel Total

3.    Total

 

Enter information in all columns as needed.

 

Page Totals at the bottom of the page will automatically do calculations.

 

To sort:

1.    Click on Data, highlight Filter and click on AutoFilter

2.    In each column an arrow box will appear.

3.    Click on arrow box of column you want to filter, (e.g., Name column, click on arrow box, highlight name you wish to have totals) and that name will appear with their totals.

4.    To return to complete list, click on Data, highlight Filter and click on ShowAll.  The complete list will appear.

 

To put in alphabetic order:

1.    Highlight Name column.

2.    Click on AZ with the arrow pointing down.

 

To put in date order:

1.    Highlight Date column.

2.    Click on AZ with the arrow pointing down.