Dashboard

Instructions

The blank one is for your use, just fill out the pale yellow data-blocks on the “Questions” tab and the sheet does the rest.

The second one is preloaded with data from the last 3 years LCT Factbook’s so you can see what the output looks like in the reporting sections.

The reporting is on the tabs marked:

  • Combination
  • Financial
  • Operations
  • Fleet

The other two tabs hold the math engines.

All tabs are protected except the Questions tab to prevent accidents.

To take off the protections, simply go to the Excel menu Review and click “unprotect sheet”.

It should take 30-90 minutes to locate the information requested.

Most people will use their dispatch software for the “Fleet Activity” section and QuickBooks for the “All Expenses” section.

The “Fleet Makeup” section data may come from a couple of different sources.

Enter what you know, the more you put in the more you get out.