How to Measure Throughput Gains in Document Generation Projects

Why this matters

Quantifying throughput lets you move from anecdotal praise to hard business evidence. When you can say “the new workflow produces 150 documents per hour versus 30 before,” you give finance and leadership a concrete metric to justify licensing, training, or further investment. Throughput also highlights hidden bottlenecks: if the rate stalls at a certain step, you know where to focus optimization effort. Finally, a documented improvement supports continuous‑improvement programs and provides a benchmark for future upgrades.

What goes wrong

Without a disciplined measurement approach, teams often rely on vague impressions of speed, missing the true impact of automation. Manual copying, ad‑hoc naming, and sporadic PDF exports introduce variability that obscures the real performance picture.

The difference is measurable, but without a systematic way to capture start/end times and document counts, the improvement remains anecdotal.

What the workflow looks like

A repeatable batch‑generation workflow consists of three core phases: data preparation, template processing, and output handling. Each phase can be timed and logged so you can calculate overall throughput and isolate slow steps.

A visual example

Simple visual illustration.

AI-generated illustration for article.

A grounded VBA example

The macro below implements the measurement steps described in the workflow. It opens the data workbook, generates each document, exports a PDF, and finally reports total documents, elapsed time, and calculated throughput.

Sub MeasureThroughput()
    Dim xlApp As Object, xlWb As Object, ws As Object
    Dim doc As Document
    Dim startTime As Double, endTime As Double
    Dim totalDocs As Long
    Dim outputFolder As String, pdfFolder As String
    Dim rowIdx As Long, lastRow As Long
    Dim templatePath As String, dataPath As String

    ' Set paths (adjust as needed)
    dataPath = ThisDocument.Path & "\Data.xlsx"
    templatePath = ThisDocument.Path & "\Template.docx"
    outputFolder = ThisDocument.Path & "\WORD"
    pdfFolder = ThisDocument.Path & "\PDF"

    ' Ensure output folders exist
    If Dir(outputFolder, vbDirectory) = "" Then MkDir outputFolder
    If Dir(pdfFolder, vbDirectory) = "" Then MkDir pdfFolder

    ' Open Excel workbook with source rows
    Set xlApp = CreateObject("Excel.Application")
    Set xlWb = xlApp.Workbooks.Open(dataPath, ReadOnly:=True)
    Set ws = xlWb.Sheets(1)

    lastRow = ws.Cells(ws.Rows.Count, "A").End(-4162).Row ' xlUp
    totalDocs = 0
    startTime = Timer

    For rowIdx = 2 To lastRow
        ' Read a key field that will become the filename
        Dim fileName As String
        fileName = ws.Cells(rowIdx, "A").Value
        If Len(Trim(fileName)) = 0 Then GoTo NextRow

        ' Create a new document from the template
        Set doc = Documents.Add(templatePath, Visible:=False)

        ' Simple placeholder replace – assume {{Name}} tag in template
        doc.Content.Find.Execute FindText:="{{Name}}", ReplaceWith:=ws.Cells(rowIdx, "B").Value, Replace:=2

        ' Save Word file
        Dim wordPath As String
        wordPath = outputFolder & "\" & fileName & ".docx"
        doc.SaveAs2 wordPath, FileFormat:=wdFormatXMLDocument

        ' Export to PDF
        Dim pdfPath As String
        pdfPath = pdfFolder & "\" & fileName & ".pdf"
        doc.ExportAsFixedFormat OutputFileName:=pdfPath, ExportFormat:=wdExportFormatPDF

        doc.Close SaveChanges:=False
        totalDocs = totalDocs + 1
NextRow:
    Next rowIdx

    endTime = Timer
    xlWb.Close False
    xlApp.Quit
    Set xlWb = Nothing: Set xlApp = Nothing

    Dim durationMinutes As Double
    durationMinutes = (endTime - startTime) / 60
    Dim throughput As Double
    If durationMinutes > 0 Then throughput = totalDocs / durationMinutes

    MsgBox "Generated " & totalDocs & " documents in " & Format(durationMinutes, "0.00") & " minutes." & vbCrLf & _
           "Throughput: " & Format(throughput, "0.00") & " docs per minute.", vbInformation, "Throughput Summary"
End Sub

Adjust the file‑path variables to match your folder layout, then run the macro on a representative data set to capture your baseline and post‑automation numbers.

Where VBA starts to strain

VBA is powerful for local automation, but it has practical limits when the volume of documents grows very large or when you need cross‑machine orchestration. Long loops can consume noticeable memory, and error handling becomes essential if any row contains a missing image or malformed data. Complex image processing (e.g., resizing or DPI conversion) is also outside VBA's sweet spot and may require a dedicated preprocessing step.

A calmer way to standardize the workflow

DocxForge Pro automates the same steps without requiring custom VBA, handling batch size, image resolution, and folder management out of the box. It provides built‑in logging of run time and document counts, so you get throughput metrics instantly.

Frequently asked questions

Common questions about measuring and improving document‑generation throughput