## Vertex42 The Excel Nexus

#### Vertex42 The Excel Nexus Summary

Rating: 4.6 stars out of 11 votes

Contents: Excel Templates
Official Website: www.vertex42.com
Price: \$29.00

Access Now

#### My Vertex42 The Excel Nexus Review

Vertex42 The Excel Nexus is a highly configurable piece of software. Installing and using is quite easy, even for the novice users but if you find yourself in trouble, there's always the Help system that's very useful when needed. From my experience with it so far it works seamlessly, so why not give it a go.

There is also a full money-back guarantee, so it's totally risk-free.I can't think of a single reason not to buy Vertex42 The Excel Nexus as soon as possible. Great work. Highly Recommended.

## Calculating feedback models

The thermostat feedback system modeled by the Excel worksheet FEEDLAB.XLS (see page 87) isn't really practical to work by hand. The amount of calculation required to simulate one day is such that you'll almost certainly give up before gaining the intuitive understanding of feedback that comes from changing parameters and seeing the computer immediately simulate the consequences. Nonetheless, here is the mathematical basis of the model. From these equations you can implement the simulation in another spreadsheet or as a standalone program. The parameters that control the model are identified by their labels on the FEEDLAB control panel.

## Exploring moving averages

The charts of Marvin's diet in this chapter were generated from an Excel worksheet that's included to allow you to experiment further on your own and get a better feel for how moving averages identify the overall trend among data that subject to large short-term variations.

## Calculating best fit trends

To calculate the rate of weight loss or gain and the calorie shortfall or excess responsible for it from the moving average trend line, the Excel spreadsheet finds the straight line trend that best fits the curve traced out by the moving average by the method of least squares. The process of finding a line that accurately represents the trend of a collection of data points is called linear regression, and the least squares method is the most frequently used approach to the problem.

The tools are all spreadsheets based on Microsoft Excel. Please refer to the README .DOC file which accompanies the tools for information about the hardware and software they require. In addition to the spreadsheets that let you plan, track, and chart your weight loss, many of the tables in this book are also supplied as Excel files so you can experiment with them and incorporate them into other health management tools. Each table in the text supplied in Excel form specifies the file name in computer type (for example, WEIGHT.XLS) at the top of the table. making the techniques accessible to those without proper computers, these sections also explain how the spreadsheets work and are worth reading if you're interested in modifying them.

Your manual is EXACTLY what I needed. I got more from your manual than from any personal trainer. The most valuable part to me is the diet nutrition information and the excel templates. Just seeing the graphs which tracks my improvement is incentive enough to stay consistent and work hard. Thank you again

## Log daily weight

Even if you're using the Excel worksheet as your permanent log, it makes sense to record your weight on paper. At the end of the month, you can spend 5 minutes entering the data into the spreadsheet from the paper log. You can, if you like, enter your weight into the computer every day but unless you're obsessed with tracking day-by-day results, it's much quicker to scribble the number on the paper sheet and enter a whole month's data in one swell foop. (Besides, people like me shouldn't consider touching a computer right after getting up operating complicated machinery when possessed of the cognitive powers of a sea slug and the disposition of a polar bear with a toothache is most unwise.)

## Every month

If you've recorded exercise rung numbers in the Rung column of the log, transcribe them to the Excel worksheet in the same manner, except there's no problem with leaving missing entries in the Rung column, or the entire column, blank. Finally, if you're recording some other event relevant to your weight participation in some sport or exercise program, days you skipped lunch, or whatever (see page 154), for every day you've flagged with a check mark to the right of the Rung column on the logsheet, enter a 1 in the Flag column of the worksheet leave flag cells for unchecked days blank. Flag cells you mark with a 1 will display a check-off mark rather than the number 1 to make the function of the field clear. to the Excel worksheet, save the worksheet to disc with File Save. Next, print a permanent logsheet containing the calculated trend with File Print. Enter the number of the month (1 for January, 2 for February, etc.) in both the From and To page boxes in the print dialogue, then...

## Fun with feedback

To experiment with this model, load the Excel worksheet FEEDLAB.XLS. Depending on the display board and monitor your computer is equipped with, you may have to resize the window in order to see the entire worksheet as shown below. The temperature data used by the charts in this chapter are included in the FEEDLAB spreadsheet. If you enter 1 in the Book cell, the book data are used rather than randomly generated temperatures. To return to using random data, enter 0 in this cell.