anchor.diff:        sheet.activate();
   
         // All operations are complete.
  +      return context.sync();
  +    })).then(allowInterop((value) {
         populateCompleter.complete();
  -
  -      return context.sync();
       }));
   
       // Waits for population to be complete.
       await populateCompleter.future;
   
       // Conditionally format the budget column once the table is set.
  -    await _formatBudgetColumn(tableName);
  +    await _formatBudgetAndSpentColumns(tableName);
   
       // Highlight underpacing insertion orders if highlightUnderpacing is true.
  -    if (highlightUnderpacing) await _highlightUnderpacingRows(tableName);
  +    await _highlightUnderpacingRows(tableName);
     }
   
     static String _getExcelColumnReference(int offset) => String.fromCharCode(
         _resultTableColumnStartAddress.codeUnitAt(0) + offset);
   
  -  /// Conditionally formats the Budget column based on Budget Unit.
  -  static Future<void> _formatBudgetColumn(String tableName) async {
  +  /// Conditionally formats the Budget and Spent column based on Budget Unit.
  +  static Future<void> _formatBudgetAndSpentColumns(String tableName) async {
       final formatCompleter = Completer<void>();
       ExcelJS.run(allowInterop((context) {
         final table = context.workbook.tables.getItem(tableName);
  -      final budgetRange = table.columns.getItem('Budget').getRange();
  -      final format = budgetRange.conditionalFormats.add('Custom');
  -
  -      final formula = '''
  -      $_budgetUnitColumnHeaderAddress =
  -      "${InsertionOrder_Budget_BudgetUnit.BUDGET_UNIT_CURRENCY}"
  -      ''';
  -
  -      // remove all tabs, newlines, and whitespace from the formula.
  -      format.custom.rule.formula = formula.replaceAll(RegExp(r'\s+'), '');
  -
  -      format.custom.format.numberFormat = _currencyFormat;
  +
  +      final budgetRange = table.columns.getItem(_budgetColumnName).getRange();
  +      final spentRange = table.columns.getItem(_spentColumnName).getRange();
  +
  +      final budgetFormat = budgetRange.conditionalFormats.add('Custom');
  +      final spentFormat = spentRange.conditionalFormats.add('Custom');
  +
  +      final formula = '$_budgetUnitColumnAddress = '
  +          '"${InsertionOrder_Budget_BudgetUnit.BUDGET_UNIT_CURRENCY}"';
  +
  +      budgetFormat.custom.rule.formula = formula;
  +      spentFormat.custom.rule.formula = formula;
  +
  +      budgetFormat.custom.format.numberFormat = _currencyFormat;
  +      spentFormat.custom.format.numberFormat = _currencyFormat;
   
         // All operations are complete.
  +      return context.sync();
  +    })).then(allowInterop((value) {
         formatCompleter.complete();
  -
  -      return context.sync();
       }));
   
       return formatCompleter.future;
  
positive.code:   /// those specified in [_tableHeader].
    static List<String> _generateTableRow(InsertionOrder insertionOrder) {
      return [
        insertionOrder.insertionOrderId,
        insertionOrder.advertiserId,
        insertionOrder.campaignId,
        insertionOrder.displayName,
        insertionOrder.entityStatus.toString(),
        insertionOrder.updateTime,
        insertionOrder.pacing.pacingPeriod.toString(),
        insertionOrder.pacing.pacingType.toString(),
        _calculatePacingDailyMax(insertionOrder.pacing.dailyMaxMicros),
        insertionOrder.pacing.dailyMaxImpressions,
        insertionOrder.budget.budgetUnit.toString(),
        insertionOrder.budget.automationType.toString(),
        _calculateActiveBudgetAmount(
            insertionOrder.budget.activeBudgetSegment.budgetAmountMicros),
        insertionOrder.spent,
        _calculateCurrentPacingPercentage(),
        _calculateDate(
            insertionOrder.budget.activeBudgetSegment.dateRange.startDate),
        _calculateDate(
            insertionOrder.budget.activeBudgetSegment.dateRange.endDate),
      ];
    }
  
  
negative.code:   /// [highlightUnderpacing] resolves as true, and false otherwise.
    void populate(List<InsertionOrder> insertionOrderList,
        bool highlightUnderpacing) async {
      final uniqueId = DateTime.now().millisecondsSinceEpoch;
      final sheetName = 'Query_$uniqueId';
      final tableName = 'Query_$uniqueId\_Table';
  
      final populateCompleter = Completer<void>();
      ExcelJS.run(allowInterop((context) {
  