Home » Opinion » Targeting Spreadsheet Data
Have you ever needed to analyze a specific group or range of data in a complex spreadsheet with many rows and columns? For example, you may want to review a depreciation schedule to determine whether your current-year asset additions were assigned the appropriate tax life. If you have numerous prior-year assets commingled with your current-year additions, it may take you hours scrolling through the depreciation schedule and searching for current-year asset additions—a tedious chore that may lead to inaccurate results.

Targeting Spreadsheet Data

Have you ever needed to analyze a specific group or range of data in a complex spreadsheet with many rows and columns? For example, you may want to review a depreciation schedule to determine whether your current-year asset additions were assigned the appropriate tax life. If you have numerous prior-year assets commingled with your current-year additions, it may take you hours scrolling through the depreciation schedule and searching for current-year asset additions—a tedious chore that may lead to inaccurate results. Excel provides a useful tool that will enable you—with minimal effort—to narrow your search and then gather all the targeted material together.

For demonstration purposes, set up a simple depreciation schedule as shown in exhibit 1.

EXHIBIT 1: ABC Co. and Subsidiaries

2000 Tax Depreciation Schedule

Company Account Description Placed
in
Service
Life Cost Beginning
Accum.
Deprec.
Current
Year Deprec.
Ending
Accum.
Deprec.
Net Basis
Able Co.1200Waco Software1/1/99345,000.0014,998.5020,002.5035,001.009,999.00
Bradley Co.1200Pineville Software3/1/99325,000.00 8,332.5011,112.5019,445.005,555.00
Bradley Co.1200Houston Software7/1/99310,000.003,333.004,445.007,778.002,222.00
Bradley Co.1200Lufkin Software5/1/00380,000.0026,664.0026,664.0053,336.00
Bradley Co.1200Dallas Software8/1/0035,000.001,666.501,666.503,333.50
Laura Inc.1200Ruston Software2/1/98323,000.00 17,889.403,406.3021,295.701,704.30
Laura Inc.1200Monroe Software3/1/99318,000.005,999.408,001.0014,000.403,999.60

Leave a Reply