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.

The following steps are excluded on MacOS Office Productivity and Office Productivity MP benchmark on Windows: 

  • Export to PDF 
  • Solve Equations 
  • Format Table 

Office Productivity Excel score and Excel MP 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
)
Excel MP score =  floor_to_thousands( 25 * 7900 / geometric mean ( 

OfficeProductivityExcelEditCells,
OfficeProductivityExcelSortColumn,
OfficeProductivityExcelVoterAnalysis,
OfficeProductivityExcelUniquePairs,
OfficeProductivityExcelPivotTable,
OfficeProductivityExcelCopyPaste,
OfficeProductivityExcelSave,
OfficeProductivityExcelLoad,
OfficeProductivityExcelLoadMortgage,
OfficeProductivityExcelModifyMortgage,
OfficeProductivityExcelVlookup,
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.


Note: solve_equations results are not available in MP runs so they are not included in the geomean.

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.