Task

Create a new sheet in LibreOffice Calc with 4 headers (“Year”, “CA changes”, “FA changes”, “OA changes”), then calculate the annual changes for each asset column by referencing data on Sheet1 and format the results as percentages.

This recording was made on a Windows VM as part of the Windows Agent Arena benchmark evaluation.

Recording

OpenAdapt Recording LibreOffice Calc Annual Changes
21 steps windows
1 Right-click on the "Sheet1" tab at the bottom and select "Insert Sheet" or "New Sheet"
Step 1: Right-click on the "Sheet1" tab at the bottom and select "Insert Sheet" or "New Sheet"
2 Click cell A1 and type "Year"
Step 2: Click cell A1 and type "Year"
3 Press Tab and type "CA changes"
Step 3: Press Tab and type "CA changes"
4 Press Tab and type "FA changes"
Step 4: Press Tab and type "FA changes"
5 Press Tab and type "OA changes"
Step 5: Press Tab and type "OA changes"
6 Click cell A2 and type "2015"
Step 6: Click cell A2 and type "2015"
7 Press Enter and type "2016"
Step 7: Press Enter and type "2016"
8 Press Enter and type "2017"
Step 8: Press Enter and type "2017"
9 Press Enter and type "2018"
Step 9: Press Enter and type "2018"
10 Press Enter and type "2019"
Step 10: Press Enter and type "2019"
11 Click cell B2 and type "=(Sheet1.B3-Sheet1.B2)/Sheet1.B2"
Step 11: Click cell B2 and type "=(Sheet1.B3-Sheet1.B2)/Sheet1.B2"
12 Press Enter
Step 12: Press Enter
13 Click cell B2, then drag the fill handle down to B6
Step 13: Click cell B2, then drag the fill handle down to B6
14 Click cell C2 and type "=(Sheet1.C3-Sheet1.C2)/Sheet1.C2"
Step 14: Click cell C2 and type "=(Sheet1.C3-Sheet1.C2)/Sheet1.C2"
15 Press Enter
Step 15: Press Enter
16 Click cell C2, then drag the fill handle down to C6
Step 16: Click cell C2, then drag the fill handle down to C6
17 Click cell D2 and type "=(Sheet1.D3-Sheet1.D2)/Sheet1.D2"
Step 17: Click cell D2 and type "=(Sheet1.D3-Sheet1.D2)/Sheet1.D2"
18 Press Enter
Step 18: Press Enter
19 Click cell D2, then drag the fill handle down to D6
Step 19: Click cell D2, then drag the fill handle down to D6
20 Click and drag to select cells B2:D6
Step 20: Click and drag to select cells B2:D6
21 Click the % button in the toolbar (or press Ctrl+Shift+5)
Step 21: Click the % button in the toolbar (or press Ctrl+Shift+5)
Download Recording

Steps

  1. Right-click on the “Sheet1” tab at the bottom and select “Insert Sheet” or “New Sheet”
  2. Click cell A1 and type “Year”
  3. Press Tab and type “CA changes”
  4. Press Tab and type “FA changes”
  5. Press Tab and type “OA changes”
  6. Click cell A2 and type “2015”
  7. Press Enter and type “2016”
  8. Press Enter and type “2017”
  9. Press Enter and type “2018”
  10. Press Enter and type “2019”
  11. Click cell B2 and type “=(Sheet1.B3-Sheet1.B2)/Sheet1.B2”
  12. Press Enter
  13. Click cell B2, then drag the fill handle down to B6
  14. Click cell C2 and type “=(Sheet1.C3-Sheet1.C2)/Sheet1.C2”
  15. Press Enter
  16. Click cell C2, then drag the fill handle down to C6
  17. Click cell D2 and type “=(Sheet1.D3-Sheet1.D2)/Sheet1.D2”
  18. Press Enter
  19. Click cell D2, then drag the fill handle down to D6
  20. Click and drag to select cells B2:D6
  21. Click the % button in the toolbar (or press Ctrl+Shift+5)