Monthly Archives: January 2017

The Workout App on the Apple Watch

The Workout app is somewhat similar to the Activity app, but instead of being designed for use at all times while you’re wearing the watch, this app allows you to collect and analyze data related to actual workouts.

To use this app, launch it from the Home screen of the Apple Watch (see Figure 5.23), and from the main menu, select the fitness-related activity you’re about to participate it. Options include Outdoor Walk, Outdoor Run, Outdoor Cycle, Indoor Run, Indoor Walk, Indoor Cycle, Elliptical, Rower, Stair Stepper, or Other.

When you’re ready to begin a workout, follow these steps to activate the Workout app on your watch:

  1. From any watch face you’ve selected to be displayed on the watch’s screen, press the Digital Crown to access the watch’s Home screen.
  2. Tap on the Workout app icon to launch the Workout app.
  3. When the main menu appears, tap on the type of workout you plan to engage in.
  4. Depending on the activity you select, a submenu screen enables you to Set Calories, Set Time, or Set Miles, or select Open (if you have no goal in mind, but simply want to track your workout-related data). If you select the Set Time screen, a timer appears, showing 0:00, with a negative sign (–) icon on the left and a plus sign (+) icon on the right. Tap the + icon to set the desired duration for your workout. Press the Start button, shown in Figure 5.24, to begin your workout.

 

Training Club App on iPhone or Apple Watch

The Nike+ Running app for the iPhone and Apple Watch has been a pioneer when it comes to using mobile technology as a fitness tool. If your fitness activities extend beyond running and are more exercise or workout oriented, the Nike+ Training Club app will probably be better suited to your needs. This free app offers a guided collection of exercises and workout routines that display on your iPhone in live-action video (see Figure 12.9).

Many of the more than 100 video-based workout routines available via this app are hosted by celebrity athletes and Nike Master Trainers. Beyond just providing workout videos to watch and follow along with, the app focuses on motivating you and serving as a virtual fitness coach that’s available to you whenever and wherever you can work out.

Whether you’re looking to tone up, lose weight, or enhance your strength, for example, the individual workouts offered by Nike+ Training Club can help you achieve specific goals. However, by grouping these workouts together into organized four-week programs, this single app can help you more systematically achieve your goals.

Nike+ Training Club is for people at all fitness levels, enabling users to design a fitness and workout routine that fits into their schedule and that’s for the home, outside, or at a gym. The app includes tools for gathering, tracking, and analyzing activity data, and for sharing the workout experience with others.

After you create a free online-based account, the Nike+ Training Club encourages you to select an initial workout based on a goal. Goal options include Get Lean, Get Toned, Get Strong, or Get Focused. Next, select an Experience Level.

Based on your overall goal and activity level, the app recommends various workouts, which range in length from 15 to 60 minutes each. After you select a workout, the iPhone downloads it from the Internet. The workout’s description lists its focus, duration, approximately how many calories you’ll burn, how much NikeFuel you’ll earn, and whether special equipment is required, such as a resistance band.

One nice feature of the app is that while you’re watching the workout videos, you can select your own music to play in the background. From any workout’s description screen, tap on the musical note icon, and then select a pre-created Playlist from the iPhone’s Music app, select an Album that’s stored on your iPhone, or choose songs from the Music app’s library.

Tap on the Customize icon to see an exercise-by-exercise list (see Figure 12.10) and how much time will be spent on each exercise during the selected workout. If you choose, from this screen, tap on the Edit icon to adjust this list and modify the workout by moving, adding, or removing exercises, or altering the amount of time you’ll spend on one or more of the listed exercises during that workout.

The Macro Recorder in VBA Programming

The macro recorder is a good introduction into the world of VBA programming, but it’s not meant to be your only teacher. It provides a simplistic approach to coding with Excel’s object model, but is by far not a teacher of advanced or efficient programming methods. You can even pick up some bad habits if you rely on it as your only means of learning VBA. Like many other programmers, I did start off with the recorder but eventually moved to the next level.

 

1. The Macro Recorder Is a Terrible Teacher, But You Can Learn from It.

I’m not saying to throw out the recorder and never use it again. In truth, most of the time I find it more useful then Microsoft’s help files when I need to look up an object or its properties and methods. Need the code for creating a pivot table? Then go ahead and record it so you can see the objects and steps involved. But then improve the code by using the advice below.

2. Declare Your Variables!

In the early days when RAM was so expensive, every byte counted. That was a major argument for declaring variables: Undeclared variables are of type variant, with a minimum size of 16 bytes, whereas if you declare a variable as type integer, you use only 2 bytes.

Now that high RAM is so common, some have thrown out the argument and don’t bother declaring variables. But then, they’ve forgotten the other reason for variable declaration, one which has saved me a lot of frustration: When you require variable declaration, Excel will point out unknown variables during compilation. And if you mix upper-and lowercase in your variable naming, you can spot mistakes right away, because Excel will keep the case the same for you as you are typing your code.

You have to manually turn on the variable declaration requirement: In the VBE, go to Tools, Options and check the box for Require Variable Declaration. Once that’s done, any new workbooks will have Option Explicit at the top of every module. For your older workbooks, you can type in Option Explicit at the top of a module, forcing variable declaration.