Create a New Tab and Setting Up

The next few pages are instructions on how to fill out the BOD ops flash.xlsx each month. This process should be done at the beginning of the month unless otherwise instructed.

 


Step 1

To create a new tab for a new month, simply duplicate the previous month’s tab by right clicking on the tab’s name and select Duplicate.

 


Step 2

Delete the numbers from the previous month except for the bolded items in the DS DigMS and the ARI DigMS rows. Items in these rows should be left alone because they are formulas adding up numbers in the rows below them.

You can also leave notes (indicated by a red triangle in upper-right corner of the cell) on the Dealer Spike and ARI rows alone, since you will be filling out these items later on. Just remember to clear them out before you begin working to avoid confusion.

image-20241104-195526.png

 

image-20241104-200150.png
These are the items we will be filling out.