The Excel test models common tasks when working with spreadsheets in Microsoft Excel.
The test design is similar to the PCMark 10 Spreadsheets workload.
The test covers two scenarios:
- Common use
- Power user
The Common use scenario uses a spreadsheet that is similar to the spreadsheet used in the PCMark 10 Spreadsheets Part 1 workload.
The Power user scenario uses the Building Design and Stock History spreadsheets from the PCMark 10 Spreadsheets Part 2 workload. These spreadsheets are available from the LibreOffice repository.
Common use scenario
The common use scenario simulates work with simple spreadsheets in Microsoft Excel. The workload performs the following tasks:
- Start Microsoft Excel
- Open the source and destination workbooks
- Stretch the application windows from an initial state
- Copy data from the source workbook into the destination workbook to cells that trigger formula evaluation
- Copy data from the source workbook to the destination workbook to cells that do not trigger formula evaluation
- Copy formulas from inside the destination workbook so that data evaluation for the data copied in task 5 is triggered
- Copy more data from the source workbook to the destination workbook to cells that trigger formula evaluation
- Plug specific values to three individual cells triggering formula evaluation.
- Save the destination workbook into a new file
The workload measures the time it takes to open the document, copy and compute, copy plain data, copy formulas, editing cells, and saving the document.
Power user scenario
The power user scenario simulates working with more complex spreadsheets in Microsoft Excel. The workload performs the following tasks:
- Load sheets with advanced formulas and big data sets.
- Recalculate data.
- Save the file.
The workload measures the time it takes to load the documents and recalculate the data.
The Microsoft Spreadsheets test score formula uses a geomean of the workload results to calculate the overall score.
Microsoft Excel score = K × 1 / geomean(R_1,R_2,R_3,R_4,R_5,R_6,R_7,R_8,R_9,R_10,R_11,R_12) Where: K= scoring coefficient = 7960
|R_1||Start application||s||0.3 - 0.7|
|R_2||Open document||s||1.2 - 4.0|
|R_3||Resize document||s||0.4 - 1.5|
|R_4||Copy data and compute||s||0.6 - 3.2|
|R_5||Copy plain data||s||0.1 - 0.5|
|R_6||Copy formulas||s||0.1 - 0.3|
|R_7||Copy data and compute 2||s||0.7 - 3.5|
|R_8||Edit cells||s||1.4 - 5.8|
|R_9||Save document||s||1.6 - 8.5|
|R_10||Recalculate Building design||s||0.5 - 7.5|
|R_11||Recalculate Stock history||s||1.1 - 12|
|R_12||Close workbook||s||0.1 - 0.4|