*tip-Highlight all the cells that deal with money and right click and choose format. Once you have each individual budget I like to make a cover sheet that gives me easy access to all the budget numbers. Once you create a new sheet just copy and paste the cells from the previous budget line. You can right click the tab in order to rename it or create a new sheet. If you click the taps you move to a new work sheet. To see a different worksheet go to the bottom of the page in Excel and there will be one to three tabs labeled Sheet 1, Sheet 2 and Sheet3. Once you get the budget line for the first show or budget line you can then copy and paste it on the sheet for multiple budgets or you can crest a worksheet for each one. *Tip– Highlight ever other row it make it easier to read the rows. The other method create the formula is to highlight the cell or cells you want to copy then put your cursor on the bottom right corner and wait for it to turn into a +, then drag Excel will recognize the pattern and shift the cells appropriately. You can copy the first cell then highlight the rest in that column and paste. You don’t need to enter the formula for every cell. This will give you a running total of this line. To figure the budget left column, take the cell above and subtract the cost of the item. So if in the example above it we want to add the cost of the item to what we have spent so far type in equals then click the cost cell then the cell above to get the new total spent. To get Excel to do any math start the cell with =. To start set up the columns you want to track leaving the last two columns for what was spent and what was left. I like to make a single budget line for each department and for each production or maintenance line.
#Bmi lightwright 6 how to#
Here are some tips on how to make a budget sheet but also how to make that information available in an easy to read format.įirst let’s start with tracking a single budget line and ask information do we want to track as we enter expenditures.
![bmi lightwright 6 bmi lightwright 6](https://scx2.b-cdn.net/gfx/news/2020/hiddenstruct.jpg)
One way to track multiple budgets is to use and excel spread sheet. I enjoy scheduling, solving problems and yes tracking budgets. One of my favorite jobs in theatre is as a production manager.