top of page
Color coding
Items in blue - inputs (editable)
Items in black - calculations (do not edit)
Items in purple - referencing another cell (do not edit)
Update information in cells C2:D7
Hit Data > Refresh all to see the numbers change in columns G:I
To review the queries, hit Data > Queries & Connections, and double click Profit_and_Loss query.
Instructions
bottom of page