DAO Ops Budget S14 2022

	A	B	C
1	Tab	Use	How To Update
2	DAO Ops Active P&L	Holisitic view of workstreams budget on a monthly level	1. This tab is all formulas built off Sumifs. If a new service or expense needs to be added, insert a line in the correct section and drag the formulas down from the row above. Formulas are anchored. If a new coumn needs to be added, insert the colum and drag the forumlas over from the column next to it. 2. If a new section needs to be added, insert rows, copy over the names of the expenses you want to track, then copy the forumulas from a previous row. You'll need to ensure you have the name if the workgroup filled in above the new section, and update the formulas to reference that workbook. If you double click in a formula it will show you what cells it is referencing. This is how you can check that your formula is pulling the correct cells. 3. This tab also pulls from the P&L forecast tab. If you add new columns in the Forecast tab to track more months, you will need to update the forumulas to ensure it's pulling the new data. Also make sure to delete out columns in the forecast tab one that column has passed.
3	DAO Ops Budget	Shows the budget for the Ops workstream in a list format by workstream name, initiative name, expense name, quarter, month, milestones, and dollar values. This is where the budget columns from in the Active P&L Tab, so make sure all naming conventions are the same.	Simply update with new budget numbers ensuring all columns are filled out and name conventions are the same. Columns with a "*" are required.
4	DAO Ops Actuals	Shows the actual spend for the Ops workstream in a list format by workstream name, initiative name, expense name, quarter, month, milestones, as well as dollar values. This is where the actuals columns pull from in the Active P&L Tab, so make sure all naming conventions are the same.	Add new expenses as needed making sure to follow the same naming convention. Columns with "*" are required.
5	DAO Ops P&L Forecast	This is the tab where you can forecast expenses on a monthly or weekly cadence. Each expense line item includes columns describing the workstream and initiative it is part of.	These are manually updated fields - add values in the column for which you anticipate spending money on that item. Similarly, if you decide you will not be making any expenditures for an item, delte the values where applicable. Once a month has passed, delete that column. As the Active P&L tab pulls from this sheet, it will ensure numbers are not being double counted. If you had more columns you will need to make sure to update the formulas in the Active P&L tab as well so that it is pulling the new data.
6	DAO Ops Summarized Financials	This tab shows the expense spend at a very summarized level - by workstream, by initiative compared to the budget.	It is linked to the Active P&L tab. In column B of this tab there is a mapping code which corresponds to column C in the Active P&L tab. It will update based on the information in the Active P&L tab, but if you add any rows in the Active P&L, you will need to make sure there is a corresponding mapping code. To ensure this tab and the Active P&L tab tie to eachother, row 19 has a check formula.
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100