Microsoft Excel
Microsoft Excel is the most frequent place where we encounter the built-in features of the product being underutilized. Oftentimes, there are many ways to seem to do approximately the same thing in Microsoft Excel. Simply setting up the spreadsheets in the most efficient manner is usually a big part of any Microsoft Excel project.
Recently, for Atlas Copco, an international supplier of assembly line tools and components, we developed a multi-user Microsoft Access 2003 database application that calculated component pricing based on continuously changing designs, as well as continuously changing pricing and suppliers of parts. This system then fed the current
catalog of parts and components into a stand-alone Microsoft Excel 2003 order quoting system. This system was commissioned by the North American division of Atlas Copco, but once it was implemented and demonstrated, Atlas Copco decided to roll it out worldwide.
We developed a set of custom Microsoft Excel spreadseets and applications that allow St. Johns - Bon Secours Nursing Home to convert data from their Unix-hosted SQL database into usable categories and totals for billing and budgetting purposes.
Temporal Linking!
Our technique of Temporal Linking allows cells in our spreadsheets to refer back to the previous value used for recurring line items. (Imagine a "magic function" that allows you to refer to last month's electric bill when estimating this month's one. With Temporal Linking, for spreadsheets with rows in chronological order, there are no hard-coded cell references used to add this functionality.)
Our Temporal Linking technique has also been used for matching buys and sells when computing Capital Gains.
What Can Compuvision Do For You?
Please note that this section is here to help connect Search Engines with this site. (Thus, all of the important keywords appear in a few short paragraphs.)
Compuvision is a technology consulting firm based in Southfield, Michigan. Compuvision is owned and managed by Steven Kovitz, a former Microsoft Employee. Compuvision specializes in desktop application development using Microsoft Office (including Microsoft Access, Microsoft Excel, Microsoft Word, Microsoft Project and Microsoft Outlook), VBA, Visual Basic .Net and SQL Server.
Our Consultants, Programmers, Experts, Gurus, Database Developers, Program Developers, DBAs, Project Managers, etc. can create custom Applications and/or help you get past any sort of Problems, Bugs and Errors that you may have encountered. We even have a Trainer on staff.
We can also help you with smaller issues that you may be experiencing with Worksheets, Formulas, Charts, Data Access, Macros / VBA (aka Visual Basic for Applications) and even linking to external databases (like SQL Server) via ODBC.
Compuvision’s customers have been located all over the United States, including Chicago, Minneapolis, New York City, Seattle, San Francisco, Los Angeles, Las Vegas and Dallas. Locally, we deal with customers all over Michigan, including many from Ann Arbor, Auburn Hills, Center Line, Dearborn, Detroit, Farmington Hills, Livonia, Novi, Southfield, Troy and Warren.