The Excel test simulates a financial officer performing calculations with several Excel worksheets. The workload features typical spreadsheet tasks like loading and saving, auto-calculation, inserting data, copy and paste, sorting, using a pivot table, exporting to CSV and PDF, and using common formulas. This test is available on both Windows PC and Apple Mac computers.
Not included in scoring on Mac as opposed to Windows:
- Export to PDF
- Solve Equations
- Format Table
Office Productivity Excel score
The Excel test produces an Office Productivity Excel score. A higher score indicates better performance. The scaling constant in the score formula is used to bring the score in line with the traditional range for UL benchmarks.
[dop] tag - corresponds to dbg_office_productivity
Excel score = 7900 / geometric mean of OfficeProductivityExcelEditCells, OfficeProductivityExcelSortColumn, OfficeProductivityExcelVoterAnalysis, OfficeProductivityExcelUniquePairs, OfficeProductivityExcelSolveEquations, OfficeProductivityExcelPivotTable, OfficeProductivityExcelCopyPaste, OfficeProductivityExcelSave, OfficeProductivityExcelLoad, OfficeProductivityExcelFormatTable, OfficeProductivityExcelLoadMortgage, OfficeProductivityExcelModifyMortgage, OfficeProductivityExcelVlookup, OfficeProductivityExcelExportToPdf, OfficeProductivityExcelSaveAsCsv
OfficeProductivityExcelEditCells
Measure how long it takes to make minor manual changes to the worksheet.
OfficeProductivityExcelSortColumn
Measures sorting the Excel sheet by one column that is not a numerical column. The worksheet has 150k rows.
OfficeProductivityExcelVoterAnalysis
Measures the time taken to fully recalculate the VoterAnalysis-complete worksheet that contains large amount of data and its analysis. The worksheet consists mostly of simple formulas. It has 400k rows.
OfficeProductivityExcelUniquePairs
Performs calculation on a sheet that involves 60’000 rows of IF(COUNTIFS(…)) formula.
OfficeProductivityExcelSolveEquations
The Evaluate workbook is tested by launching a linear optimization problem solver that is defined in the workbook’s macro. It solves the set of linear equations.
The solve process is first performed with 2 workbooks open in the background, This is repeated four times, with the first result dropped from the result calculation.
Then all background workbooks are closed and the solve process is performed again. This is repeated four times, with the first result dropped from the result calculation.
OfficeProductivityExcelPivotTable
A pivot table is defined and created from a datasheet with several dozen rows and coumns. The data entries for the pivot table are selected based on Excel’s suggestions.
OfficeProductivityExcelCopyPaste
Additional data is copied and pasted to the end of the open worksheet. After that, the workbook is saved, closed, then opened again. This cycle repeats 5 times, increasing the amount of data being appended. The worksheet has 400k rows.
OfficeProductivityExcelSave
This score measures how long it takes to save the file. The score is the geomean of 5 save iterations of a worksheet with 400k rows.
OfficeProductivityExcelLoad
This score measures how long it takes to load a large data file. The score is the geomean of 5 load iterations using a worksheet with 400k rows.
OfficeProductivityExcelFormatTable
Measuring the time taken to format 400k rows of plain data as a table with headings.
OfficeProductivityExcelLoadMortgage
Measures much time it takes to open and recalculate the cal_mortgage_30x.xlsm file. It contains a rather small amount of data (~1050 rows by ~200 columns) but involves a lot of complex formulas that calculate all the variables for a mortgage for every month based on the starting conditions.
OfficeProductivityExcelModifyMortgage
Performs copy-paste of data between Excel worksheets that results in reevaluating the formulas. The worksheet is ~1050 rows by ~200 columns.
OfficeProductivityExcelVlookup
Performs one million VLOOKUP operations on rows of data. The data is taken from one worksheet to another inside of a single workbook.
OfficeProductivityExcelExportToPdf
Measures how long it takes to export an Excel worksheet with charts to PDF format with common settings. The worksheet is not large and can fit on a single screen, but it is visually heavy, which results in a suitable load for the PDF renderer.
OfficeProductivityExcelSaveAsCsv
Measures how long it takes to export and save an Excel workbook with 400k rows and charts as CSV file.