Our Work

Lumber Inventory & Trade Management in Excel

Our Excel consultants developed an Excel spreadsheet that holds the weekly report of the inventory and trade, such as the quantity of items and their cost.

In this worksheet, we developed a macro which,

  • Determines the difference of weekly report of the inventory
  • Calculates the percentage difference
  • Has the ability to insert new inventory items on the report sheet.

Problems Addressed in the Excel Project

The problems solved in this Excel workbook, at a glance, are
  • Time limitation in inserting formulas in a large number of ranges
  • The risk of human error in entering a large number of formulas

Working on large worksheets and tables in Excel is a bit complicated. In the first place, a small mistake in one of the formulas can affect the whole file, and on the other hand, it is difficult to find the problem among several tables and the abundance of cells. In this case, there were three general categories of tables in Excel Worksheet, each containing two types of tables with different structures. The middle category contains the formulas associated with the first and last Category. Adding or dropping each table or their columns would make it difficult for users to work on the file.

Applied Excel Solutions

Instead of manually inserting formulas, our Excel Macro development team wrote a VBA code which automatically inserts formulas. We've designed a macro in Excel that can identify these tables and automatically generate the required formulas in the middle table. The macro allows you to add or reduce the number of table columns. Also, regardless of whether the tables are changed from their location, the program has the ability to recognize them.

Client:

Olympic Industries

Tags:

  • Excel Excel
  • Inventory
  • Advanced Formulas

Related Link:

Features

  • Save the business time
  • Eliminates human error
  • Make changes without worrying about the formulas

BSUPERIOR's Clients

Contact

Contact us today at (888) 359-1841 and speak with our specialist.

About Us

BSUPERIOR SYSTEM LTD. provides custom software and technology solutions to small and medium sized businesses. We have been helping businesses to operate more efficiently, reduce money and time spend on redundant repetitive daily tasks.

Master Links

Our Contacts

1455 Crown St Ste A,
North Vancouver, BC V7J 1G4
Canada

(888) 359-1841