W

wait time calculations. See queuing theory

Web pages, importing data from, 265–267

Web queries

creating, 266

dynamic, 267

editing, 267

refreshing, 266

for stock information, 267–268

WEEKDAY function, 42

for conditional formatting, 179–180

WEIBULL function.

See also Weibull random variable syntax of, 472

Weibull random variable. See also WEIBULL function

defined, 471

machine lifetime modeling with, 471–472

probability density function of, 472

Winter's method

equations for, 432

initializing, 432–433

smoothing constants, estimating, 433–434

Word documents

importing, 259–263

saving as text, 260

word problems, solving, 121–122

workbooks

consolidated data, creating from, 355–358

navigating, 301

viewing multiple on same screen, 356

WORKDAY function, 41–42

workdays.

See also dates

calculating number of between two dates, 42

calculating number of from certain date, 41–42

workforce scheduling, 231–233

worksheets

comments in. See comments

creating, 343

named ranges, applying to, 9

navigating, 301

protecting, 520–521

World Wide Web documents. See Web pages

worst-case scenarios. See Scenario Manager