...
Create the Income Statement report by utilizing the data in the downloaded Excel file.
Let’ start by understanding the role of each sheet in this report.
Sheet V : V_ProfitAndLoss
When multiple sheets exist in Excel, the sheet to be displayed on the web must follow the format ‘V_(letters)’ or ‘V(number)’.
- Sheet D : D1
This sheet allows you to enter data or retrieve it by connecting to a database.
Sheet P : P1
Create variables to be used when querying data. You can define cell values as variables by using Excel’s ‘Name Manager’ feature.
In this exercise, we’ll use ‘Year’ as a variable to view the income statement by year.
참고사항 title Excel Sheet Naming Convention The naming convention for Excel sheet is as follows:
Step 3. Set variables and connect data to the V sheet
...