Home Feedback Terms of Use Links Downloads Excel User Scale

Applications

 

Home
News
Consulting
Double XL
QuickBooks
Applications
Staff

Brandtrock Consulting is developing a number of applications that can make your work simpler.  The following groups are nearing release.  Keep your eye on this page or send us a note so we can let you know how to get more information on any of these applications.

Scheduling Related:

Client Lister is designed primarily for accounting practices or businesses that have a regular client list with regular work product that is produced in various timeframes.  The tracking of documents and work status is simplified through a date based grid that includes both active and inactive clients each month.

Work done for monthly clients shows as due each month while quarterly, semi-annual and annual clients will remain inactive until the appropriate time frame has passed.  Never worry about a client being overlooked!  The categories and time frames are completely adjustable at set up time.

Labor Percentage Tracking is designed primarily for labor intensive industries such as restaurant and retail.  Default industry standards or actual company data may be used when setting up the program.  Employee hours are tracked through the day and compared with projected labor usage.  

Daily reports break down the variance into controllable and uncontrollable components.  Learn which managers are your most efficient and effective in using labor to get the job done right!

Formula Related:

A Formula Resource for the Ages is an Add-in for Microsoft® Excel developed by Brandtrock Consulting that details the definition of 341 worksheet functions available in the standard installation and the Analysis ToolPak.

Each function is defined in text and in practice.  A live illustration of the function is given at the top of the page.  The syntax of the formula is shown, ambiguous arguments are explained.  Common usage is shown or described, as well as advanced usage for more powerful functions.

Beyond the simplified examples in Microsoft® Excel's Help files, A Formula Resource for the Ages provides guidance in using the following data types:

Strings; numbers; arrays; references to strings, numbers, or arrays; and results of formulas as arguments in the functions.

In addition to the individual definitions, 18 additional illustrations combine functions in realistic applications of formulas.  These illustrations deal with some of the most commonly asked about "How do I" issues asked on discussion forums. 

User Defined Functions are functions coded in Visual Basic for Applications that can make a great deal of difference in the efficiency and effectiveness of your spreadsheets.  UDF's do not run as quickly as resident functions, but they are necessary from time to time.

Wrestling related:

Training Tables sets up a schedule of weight training tables by day with the calculation of the lifts being directed by the individual wrestler's maximum lifts at the beginning of the program.  The cycles can be repeated for longer training programs, and are designed for a peak performance in the upcoming season.  The  diet tables are designed to help the athlete gain strength while maintaining a healthy body weight.

Tourney Kit sets up the seeding meeting, brackets, and meet results for eight, sixteen, thirty-two, and sixty-four man brackets.  Pig tail matches are supported with ease.  The real time display of meet results can be displayed with the use of a projector without interrupting the processing of results.  Tournament results can be posted to a client web site in real time or at tournament completion.

Match Tracker is an electronic scorebook.  Take this application mat side on a PC or notebook computer and keep score as the match is taking place!  At the end of each match the results are recorded in a database for reporting purposes.  Coaches can quickly and efficiently view reports showing areas of concern by team or by individual.  Reports can be generated for the year end banquet.  Brandtrock consulting also offers data entry services to help stock the archives with prior year data.

 

 

Home ] News ] Consulting ] Double XL ] QuickBooks ] [ Applications ] Staff ]

Send mail to brandtrock@brandtrock.com with questions or comments about this web site.
Last modified: March 27, 2007