Add a New iWeb Page from Your MacBook

You can add new pages to your iWeb-created sites directly from your MacBook. For example, you can add Photo and About Me pages to the new site you’ve created. You also can edit these pages to personalize them.


If you have multiple sites in your Site Organizer list, click the top-level heading for the desired site to select it. You can add pages by



  • Clicking the Add Page button on the toolbar at the bottom of the iWeb window



  • Choosing File→New Page



  • Pressing Command+N



  • Control-clicking or right-clicking the site header in the Site Organizer and clicking New Page




Want to start with an existing page as a basis for a new page? Right-click that page entry in the Site Organizer and choose Duplicate. iWeb creates a new page with exactly the same contents and adds it to the site.


Pages are listed under the main site heading in outline format, making it easy to expand or collapse a site by clicking the familiar rotating triangle icon next to the site heading. (Apple calls these disclosure triangles. Wowzers!)


Deleting a page — or a whole site, for that matter — is easy in iWeb. Right-click the offending page or site heading in the Site Organizer and choose Delete Page/Delete Site. Note that iWeb doesn’t prompt you for confirmation here, so these aren’t commands to toy with.




dummies

Source:http://www.dummies.com/how-to/content/add-a-new-iweb-page-from-your-macbook.html

Feeding Your Pet Amphibian or Reptile

In the wild, reptiles and amphibians (collectively known as herps) tend to be wanderers, moving about during their active time. (Some herps are active at day, some at dawn and/or at dusk, and others during the night.) Herps are pretty basic creatures; when they wander, they're either looking for a spot to thermoregulate (warm up so they can have normal body function, or more rarely, where they can cool down because they're already just a bit too warm); to procreate (if it's breeding season); or to find food.



Reptiles and amphibians: Food preferences


The food that reptiles and amphibians prefer depends entirely on its type — carnivore, herbivore, or omnivore. These three commonly applied terms indicate the feeding preferences of animals and, in this case, of reptiles and amphibians. The terms give you some basic guidelines on what to feed your pet.



  • Carnivores eat flesh (or meat). Typical herp carnivores are all the snakes, tegu lizards, monitors, and crocodilians. Typical dietary items are mice, rats, birds' eggs, insects, and fish — all eaten raw, of course.

  • Herbivores consume only (or primarily) plant materials. Green iguanas and some tortoises are examples of the vegetarian herps. They eat foods such as chopped collard greens, romaine lettuce, chopped squash and bananas.

  • Omnivores consume both meat and plant material. Bearded dragons and many aquatic turtles are examples of omnivores. Typical food items include crickets, mealworms, earthworms, chopped veggies, and romaine lettuce.

Occasionally, you see more specific terms in place of carnivore or herbivore, including the following:



  • Folivore: An animal that eats leaves. Iguanas are good examples of folivores, and in the wild, they roam the treetops of the forest, noshing on whatever leaves look the most tempting.

  • Insectivore: An animal that eats insects. A chameleon is a good example of an insectivore, as is the anole. Their diets consist basically of crickets and mealworms.

  • Piscivore: An animal that eats fish. Crocodiles are piscivorous, although not exclusively. The matamata turtle, called by its original South American name, lies in wait until its fish prey swims by and then it inhales and slurps in dinner. For captive herps, bait-store minnows fill the bill (er, the mouth).


Before you bring home a reptile or amphibian, think about what kind of food you're willing to feed it. For example, someone who's squeamish about feeding rabbits to a snake shouldn't buy a Burmese python. Burmese pythons start out pretty and small and you may have to feed it mice or rats, but they don't stay small. As they grow, they need bigger and bigger food items.



Insectivorous herps need live insects, specifically crickets or mealworms. Most people are probably comfortable offering that menu. Piscivorous creatures eat fish, meaning bait minnows or perhaps goldfish. Again, serving those items probably wouldn't bother most people.



Carnivorous herps need to eat meat, and for snakes this generally means rodents (or birds, to a lesser degree). But you don't have to feed your snake or other herp live food. Tegus, snakes, turtles, and larger monitor lizards will thrive on a diet of prekilled mammals or birds. And you don't have to do the killing.



How much to feed reptiles and amphibians


The amount of food you offer will vary, based on the size of your pet and its natural feeding patterns.



  • For insectivorous herps, give as many insects as they'll consume in a half hour, repeated twice daily (for chameleons) or daily/every other day (for frogs and salamanders). The good news is that you don't have to stand there and watch your herp eat the crickets or mealworms — you can tip them in or put them in a small dish and put the dish in the cage. Of course, crickets will crawl all over the cage, but the herp will follow and slurp them up. When feeding earthworms, start with one earthworm, neatly nipped apart into head-sized pieces with your fingernails; when all of those pieces are gone, you may need to offer a second.

  • For herbivorous lizards, offer a pile of chopped veggies as long as the animal's body and twice as wide, and check later that day to see how much remains. Veggies don't have a lot of protein, so your herbivorous lizard will eat a lot.

  • For snakes, tegus, and other carnivorous herps, offer a prekilled mouse or food item no larger than the animal's head. If it's readily eaten, offer a second.


Feeding prekilled animals to reptiles and amphibians


What are the advantages of using prekilled rodents instead of live prey animals? Prekilled rodents are often more readily available, easier to store, easier to use, acceptable to almost all (yes, a very few snakes do still insist on live food) rodent-eating herps, and sometimes cheaper.



Using prekilled prey accomplishes several things, all of them good. The majority of herps readily feed on prekilled prey. Using prekilled prey removes the disgust that many people feel tossing in a live creature, only to have it devoured by another creature. No one enjoys seeing an animal in terminal distress. The prekilled animals available in your pet store are humanely killed and then frozen. They don't suffer, and neither will your herp.



The process of offering prekilled food is pretty simple and painless:



1. Thaw the mouse or rat (or rabbit, nutria, chicken, or quail) in warm water for half an hour or so.


The larger food items need longer to thaw, up to an hour with a water change every 20 minutes or so.


2. Blot it dry.


3. Put it in your pet's cage.


You may want to wear gloves when you do this, in case your herp lunges toward the food item.


By feeding your snake/tegu/herp prekilled food, you remove the risk that your pet will be injured by its intended prey.



Why is it important not to offer live food? Offering a live rodent to a captive snake in a small cage can be very different from a snake or a monitor ambushing and overcoming a rodent in the wild. In the latter case, the herp is already in an active hunting mode, is probably well camouflaged, and will be the one to pace its encounter with prey. In the cage, if the prey rodent (or bird) happens to turn the tables by darting toward and startling the supposed predator, the predator will probably shy away. And, following that, if the prey and predator are left alone for any length of time, the intended prey is apt to start chewing or pecking on the snake or lizard. Every veterinarian has had an instance where an owner has brought in a grisly remnant of what had been a perfectly healthy snake or lizard that now has no eyes, displays exposed ribs, or is missing a tail.



Can you feed live food to your snake? The answer is yes, but only if you check the snake every 15 minutes and then remove the food item if it isn't killed and eaten within 45 minutes. But you need to examine your motives here. Why would you want to feed your snake live food when a chance of injury to your pet exists?










dummies

Source:http://www.dummies.com/how-to/content/feeding-your-pet-amphibian-or-reptile.html

How to Install and Start Quicken 2012

You install Quicken 2012 the same way that you install any program in Windows. If you need help installing Quicken, here are the step-by-step instructions. Installing Quicken from a CD is as easy as one, two, three, four:



  1. Insert the CD into the CD-ROM drive.


    In a short amount of time, Quicken should display the Quicken 2012 install wizard window. The window just reads Welcome to Quicken 2012!.


    Note: If nothing happens when you put the CD into the CD-ROM drive, don’t panic! First, try removing the CD and then putting it in again. If Windows still doesn’t recognize the CD, you need to tell Windows that it should install your Quicken program.


    In many versions of Windows (but not necessarily with your version), you do this with the Windows Control Panel by using the Programs tool. To do this, refer to your Windows user guide.



  2. Click Next.


    Quicken then displays a window that asks you a couple of questions:



    • Whether you accept the Quicken license agreement.



    • Whether you're okay if Quicken sends anonymous usage statistics to Intuit.




    You can answer the install wizard's questions by checking the boxes in front of the questions.



  3. Click Next.


    Quicken displays the next window of the install wizard, which asks where you want to install Quicken. You should accept the installation’s program suggestion. (The installation program suggests a Quicken subfolder in your Program Files folder.)



  4. Click Next.


    Quicken displays yet another window of the install wizard that indicates the wizard needs to install the Quicken software and may need to update the software, too. Assuming you're okay with all this — and you should be — click the Install button.


    Quicken installs itself. This process takes a few minutes. Along the way, you may see other screenfuls of messages, including marketing information about the features new to Quicken and some progress reports on the installation itself.


    After the installation is complete, Quicken displays an installation complete message.



  5. Click Done.


    Congratulations. You’re done.




After installing the Quicken software, the installation program starts the Quicken program to finish the setup process.











dummies

Source:http://www.dummies.com/how-to/content/how-to-install-and-start-quicken-2012.html

Network Operating System Features - Support and File Sharing

All network operating systems (NOS), from the simplest to the most complex, must provide certain core functions. These include the ability to connect to other computers on the network, share files, etc.


Network support


A NOS must support a wide variety of networking protocols in order to meet the needs of its users. That’s because a large network typically consists of a mixture of various versions of Windows, as well as a few scattered Macintosh (mostly in the art department) and possibly some Linux computers. The computers often have distinct protocols.


Many servers have more than one network interface card installed. In that case, the NOS must be able to support multiple network connections. Ideally, the NOS should have the ability to balance the network load among its network interfaces. In addition, in the event that one of the connections fails, the NOS should be able to seamlessly switch to another connection.


Finally, most network operating systems include a built-in ability to function as a router that connects two networks. The NOS router functions should also include firewall features in order to keep unauthorized packets from entering the local network.


File-sharing services


One of the most important functions of a network operating system is its ability to share resources with other network users. The most common resource that’s shared is the server’s file system. A network server must be able to share some or all of its disk space with other users so that those users can treat the server’s disk space as an extension of their own computers' disk spaces.


The NOS allows the system administrator to determine which portions of the server’s file system to share. Although an entire hard drive can be shared, it isn't commonly done. Instead, individual directories or folders are shared. The administrator can control which users are allowed to access each shared folder.


Because file sharing is the reason many network servers exist, network operating systems have more sophisticated disk management features than are found in desktop operating systems. For example, most network operating systems have the ability to manage two or more hard drives as if they were a single drive. In addition, most can create mirrors, which automatically keep backup copies of drives on a second drive.




dummies

Source:http://www.dummies.com/how-to/content/network-operating-system-features-support-and-file.html

Fun Paper Crafts and Decorations for Christmas


1 of 8 in Series:
The Essentials of Christmas Crafts for Kids





If you like the idea of crafting Christmas items from paper, or if you just like to embellish the paper goods you already have, then invest in a good paper-crafting stash of items and create any of the following to decorate your home for a Christmas gathering:



  • Paper garlands: Using die-cut holiday motifs, cutouts, or combinations of individual letters, you can create your own holiday garland in just a few minutes time.


    Line up the cutouts side by side on a flat surface. Tape or connect them together with string and then hang them around doorways, on the front of buffet stations, across front porches, and so on.


    Cut out beautiful paper snowflakes and string them together for a one-of-a-kind garland. Use your own imagination, as well as current offerings at your local craft store, to piece your garland together.



  • Paper ribbons: Tape paper ribbons to the edges of open shelves, around cake plates, or to gift wrap.


    The easiest way to make paper ribbons is to cut 1-to-2-inch-wide strips of paper with a paper cutter and then follow these instructions: (1) Trim one edge of the paper strips with decorative-edged scissors. (2) Use a hole punch or craft punch to cut out designs every few inches. (3) Adhere double-sided tape to the back top edge of your paper ribbon, and join the edges of the lengths of ribbon together as needed.



  • Place cards: Place cards on your holiday table can be anything but boring. You can make your own place cards out of index cards or specialty paper. Make them so that they tent fold, or insert flat place cards into place card holders.



  • Notecards, greeting cards, and invitations: If you want to make your own stationery items, decide how detailed you want to get. Do you want to cut and score your cards yourself, or do you want to just embellish premade blanks?



  • Gift tags: You can make gift tags from scraps of your best paper, hang tags from an office supply store, or use metal foil cutouts!


    To create holiday motifs, trace the outline of a cookie cutter onto paper and then cut out the design and embellish it as desired. Punch a hole at the top of your design and string yarn or ribbon through it.



  • Pinpricking paper: Pinpricking paper is a technique that Victorians used to punch decorative designs into paper. By using a simple pattern and a pushpin, you can create pretty, impromptu paper chandelier shades that fit over your regular ones for the holidays.


    Pinpricking paper is quick and easy, and it looks best when wrapped around a light source. Try applying pinpricked paper to luminarias, glass votives, flameless candles, and window shades.






dummies

Source:http://www.dummies.com/how-to/content/fun-paper-crafts-and-decorations-for-christmas.navId-400688.html

Canning Spam with AOL 9.0



Figure 1: The Mail and Spam Controls window.

Focus your spam-fighting efforts on teaching the Advanced Spam Filter its job. The more messages that you kill with the Report Spam button (and save with the This Is Not Spam button), the sharper your filters get. Unless you really, really, really hate junk e-mail and don't mind deleting a few valid messages as the cost of your crusade, don't go overboard on the blocking settings in the dialog box. Instead, let the Advanced Spam Filter do its thing.



dummies

Source:http://www.dummies.com/how-to/content/canning-spam-with-aol-90.html

Emerging Markets in North and South America

North and South America are dominated by the country with the world’s largest economy, the United States. But that’s not saying much, because many of these countries are growing smartly in their own right. The hemisphere shares a common history of colonization and population migration. Today, almost every country in the Americas is ethnically diverse and often racially mixed.


Many countries on the continents produce illegal narcotics for export to the United States, which creates a strong criminal class that sometimes interferes with business and politics.


In general, countries in the Americas are rich in natural resources and human capital. They’re also plagued with government deficits and historic credit problems. Interest rates tend to be higher here than elsewhere in the world, which is attractive to bond investors but also a sign of risk and potential currency problems.


Chile



  • Type of government: Republic



  • Major industries: Fishing, mining (especially for copper), wine



  • Currency: Chilean peso



  • English-language newspaper: The Santiago Times




Chile gained its independence from Spain in 1817. After a military coup in 1973 tore the country apart, Chile has been peaceful and stable since 1990, although some political tension between the government and the military persists. The greatest test of the country’s stability was an earthquake in early 2010 that hit hard and damaged many cities and copper mines. Chile’s government and institutions proved strong enough to get relief aid to people who needed it and to begin rebuilding. The challenge to the country’s economy is continuing with reconstruction during a recession.


Colombia



  • Type of government: Republic



  • Major industries: Agriculture, metals, petroleum, textiles



  • Currency: Colombian peso



  • English-language newspaper: Colombia Reports




After a series of military coups in the middle of the 20th century, a new constitution was introduced to establish a presidency, a legislature, and a court system. Colombia is more stable now than it had been, but it still faces internal turmoil from drug traffickers and two political groups, FARC and ELN. As with many emerging markets, Colombia offers plenty of risk. At the same time, the country is rich in natural resources, so it presents some good opportunities and has potential for future growth.


Mexico



  • Type of government: Federal republic



  • Major industries: Food and beverages, iron and steel production, motor vehicle manufacturing



  • Currency: Mexican peso



  • English-language newspaper: The News




It’s not always clear that Mexico should still be lumped with the emerging markets, given that it has a stable government, strong economic growth, and a primary trading partner that’s the richest nation in the world. Mexico joined the North American Free Trade Agreement with the United States and Canada, which gave the country expanded trading opportunities.


Like many other countries, Mexico has problems with aggressive narcotics dealers and some corrupt politicians who are willing to cooperate with them. That has complicated life for legitimate business people and scared off tourists, who contribute mightily to the economy of cities in coastal areas. But an estimated 12 million Mexican citizens live in the United States, some legally and some illegally. These people contribute to Mexico’s wealth by sending money to their families back home, and they’ve helped build trading relationships between the two nations. Their presence also creates a lot of tension with the United States that could complicate trade relationships at some point.


Peru



  • Type of government: Constitutional republic



  • Major industries: Fishing, mining, textiles



  • Currency: Nuevo sol



  • English-language newspaper: Peruvian Times




Peru long had a military government, which led to periodic outbursts of rebellion and upheaval. A democracy was formed in 1980; it dissolved in 1992 but was restored in 2001. The country has some challenges, but it’s also in a better position to grow than it had been. It has some great natural resources. Some major infrastructure projects would make trade easier, including railway improvements, a planned dam at Inambari that would generate 2,000 megawatts of electricity, and a highway that would link coastal cities to one another and to the Brazilian city of Rio Branco.




dummies

Source:http://www.dummies.com/how-to/content/emerging-markets-in-north-and-south-america.html

Laying the Groundwork for a Family Reunion


Figure 1: A reunion survey solicits feedback from family members.

You can use your computer's mail-merge program to make preparing the survey envelopes a quick and painless task. Most computers come equipped with software that features some type of address book. All you have to do is select the addresses and click a button, and your computer prints the addresses on envelopes or labels. Printing addresses directly onto the envelopes is a bit more time-consuming than labels because you have to stand at the printer and feed the envelopes through one at a time. If you have a deal of envelopes to address, then use the label method.



In addition to asking for basic information — such as the number of people attending and their preferred dates — you should also ask the following questions:



  • What types of foods do they suggest?

  • What types of games and activities do they want?

  • Do they want to help plan the reunion?

  • Do they prefer a one-day or multiple-day reunion?

You'll get a wide range of answers to your survey. Choose the ones that have a majority following. Sometimes, this doesn't include your top choice, so be flexible. The goal is to make sure that as many people as possible can get together and enjoy themselves, including you.



When you decide on a date, stick to it. Don't change the date to accommodate anyone, because the new date will inconvenience several others who have already made arrangements. Remember the old adage: If it ain't broke, don't fix it!



Location is (almost) everything


Most small family reunions (20 people or so) tend to take place in the backyard of the family homestead or in a nearby park. Larger reunions tend to take place in rented halls, reserved park areas, and hotel facilities.



In fact, many factors go into determining your reunion location. For example:



  • The number of people planning to attend and where they're traveling from

  • The date and time of day of the reunion

  • Your reunion theme

  • How early you start searching for a location

  • Types of activities

  • Your budget

Finding a venue and taking the grand tour


Finding a venue — or a place to hold your reunion — is simple. You open the phone book and make phone calls, find out about fees, and visit the sites.



Before you decide on a reunion location, take a good look at the place. Ask for the grand tour and take notes. Keep track of all the information you gather on your location tours by using a location research log, as shown in Figure 2.



>



Figure 2: A location research log helps keep your information organized.

Check out the facilities thoroughly. Is everything clean or does it smell as if people have been cleaning fish in the main hall? Is there a kitchen that you can use, and does the facility supply small appliances, such as coffee makers? Is there a fee for using these appliances?



Where are the restrooms? Does the site have any recreational facilities? Is there access for disabled folks? Does the site allow for the serving of alcohol? What about insurance? Is adequate parking available? These are important issues that you need to clarify before you choose the site.



Reserve early or forever hold your peace


Reserving a spot at any public place, whether it's a park, campground, or hall, requires reservations up to a year in advance — or sometimes longer, if the spot is popular. No matter what site you choose, be sure to ask about the reservation requirements. Start with the following questions:



  • How far in advance do I need to make reservations?

  • What is the fee?

  • Do you require a security deposit? How much is it?

  • What is your cancellation policy?

Always start your planning early! Eighteen months is the minimum for a large reunion; a year in advance is average. But if you're a procrastinator, give yourself at least six months for planning and reserving the location. If you wait any longer than that, you're pushing the limits.



A busy clan is a happy clan


You want to have a variety of activities at your reunion so folks can get to know new faces as well as mingle with people they haven't seen in years. When selecting a location, check to see what types of activities are available because you may want to add them to your activities list. For example, some indoor facilities offer swimming pools, shuffleboard areas, volleyball courts, billiards, and other nifty activities.



Likewise, outdoor sites may feature tennis and basketball courts or areas for rousing games of softball or touch football. Beachside reunions can easily accommodate sandcastle contests, beach volleyball, and other beach games.



If you or a family member has a backyard with a swimming pool, consider having a pool-party reunion. Make sure that the backyard can accommodate the crowd. Most pools (except the blow-up, kiddie variety) take up a lot of space, leaving little room for people and barbecue equipment.



If you select a beachside location or a site with a pool, appoint a lifeguard to ensure everyone's safety. Family members will be busy reuniting and can be distracted very easily when they are supposed to be watching whoever is in the water.



The bottom line is that if you plan to have lots of activities for everyone, you can select just about any spot for your reunion. But if your list of activities is a little slim, be sure to choose a site that offers a wide range of things to do.









>
dummies

Source:http://www.dummies.com/how-to/content/laying-the-groundwork-for-a-family-reunion.html

How to Capture Screen Shots Using Windows Vista’s Snipping Tool









Windows Vista includes a neat tool — the Snipping Tool — that allows you to capture a screen shot of any object on your screen. Although capturing screen shots, or snipping, isn't a new concept, Windows Vista has made it easier and more functional with the snipping tool. Just follow these steps to see how easy snipping with the Snipping Tool in Windows Vista can be.


>


>


>

1

Choose Start.



>

Go to All Programs→Accessories→Snipping Tool.


>



>


>

>

Enlarge
>


>

2

Click the down-arrow on the New button.



>

Choose a snip mode from the drop-down list: Free Form Snip lets you draw any old kind of line you like, such as a triangle, to define what you want to snip; Rectangular Snip does what it says — when you click and drag over a region, it forms a rectangular snip; Window Snip allows you to select an active window to snip; and Full-Screen Snip takes the entire enchilada, capturing the whole screen in the wink of an eye.


>



>


>


>

3

Click and drag.



>

Only if you chose Free Form or Rectangular, you can click and drag on the desktop or in a document to form an area to snip.


>



>


>


>

4

Click on the window you want to snip.



>

Do this only if you chose Windows, but if you chose Full-Screen, the snip happens automatically.


>



>


>

>

Enlarge
>


>

5

Mark up with image with the Pen, Highlighter, and Eraser.



>

The mark-up window that appears allows you to choose from these tools to mark up the image.


>



>


>


>

6

Click the Save Snip button.



>

The Save Snip button looks like a computer disk and will display the Save As dialog box. The Save As dialog box is where you can enter a filename, specify the location to save the file to, and then click Save.


>



>
dummies


Source:http://www.dummies.com/how-to/content/how-to-capture-screen-shots-using-windows-vistas-s.html

Managing a Back or Neck Pain Attack

Suffering with back or neck problems can be extremely painful. Try some of the following tips to get your back and neck pain attack under control:



  • Go to bed but not for too long. Limit bed rest to two to three days to calm down your back and neck pain.



  • Use ice or heat. Both ice and heat can reduce muscle spasm and make you more comfortable.



  • Use anti-inflammatory medication. Unless you have a medical reason for not taking over-the-counter anti-inflammatory medication, Advil, Nurofen, Motrin, Brufen, and other medications work very well for pain. Try aspirin or paracetamol as a painkiller first, though.



  • Start moving around, even during the bed-rest phase. Gradually increase your activity as soon as you can – walking is one of the best and safest exercises.



  • Return to normal activity. Gradually increase your activities until you return to normal levels.




If this self-management approach to your back or neck pain doesn’t provide significant relief after about a week, see a doctor.









dummies

Source:http://www.dummies.com/how-to/content/managing-a-back-or-neck-pain-attack.html

How to Set Up User Preference Settings in Your iPad App

You can set preferences for iPad applications, which are application-specific settings used to configure the behavior or appearance of your iPad app. You can create and save preference settings in your app, but you can also use the supplied Settings app to display and set your app-specific preferences (the Settings app icon looks like a bunch of gears). Whatever separate settings feature you come up with has to function within the framework of the Settings app; in effect, the Settings app makes you color within the lines.


Here's a short summary of the guidelines that the iPad imposes for preference settings:



  • If you have preference settings that are typically configured once and then rarely changed: Leave the task of setting preferences to the Settings app. On an iPad, this applies to things such as enabling/disabling Wi-Fi access, setting wallpaper displays, setting up Mail accounts, and any other preference settings you would set and then leave in place for a while.



  • If you have preference settings that the user might want to change regularly: In this situation, you should consider having users set the options themselves in your app.




To save and read preference settings, you use a built-in, easy-to-use class called NSUserDefaults.


By the way, don't ask why the language experts put Defaults in the name rather than something to do with preference settings — fewer letters, maybe — but that's the way it is. Just don't let their naming idiosyncrasies confuse you.


Storing the data in the file system, rather than in memory, gives you an easy way to store application-specific information. With the help of NSUserDefaults, you can easily store the state the user was in when he or she quit the application — or store something simple like a text string.


Identifying preference settings for NSUserDefaults


It's really easy to both access and update a preference. NSUserDefaults is implemented as a singleton, meaning there's only one instance of NSUserDefaults running in your application. To access that one instance, you invoke the class method standardUserDefaults:


 [NSUserDefaults  standardUserDefaults]

standardUserDefaults returns the NSUserDefaults object. As soon as you have access to the standard user defaults, you can store data there and then get it back when you need it. To store data, you simply give it a key and tell it to save the data using that key.


The way you tell it to save something is by using the setObject:forKey: method. (In case your knowledge of Objective-C is a little rusty — or not there at all — that's the way any message that has two arguments is referred to):



  • The first argument, setObject:, is the object you want NSUserDefaults to save. This object must be NSData, NSString, NSNumber, NSDate, NSArray, or NSDictionary.



  • The second argument is forKey:. In order to get the data back, and in order for NSUserDefaults to know where to save it, you have to be able to identify it to NSUserDefaults. You can, after all, have a number of preferences stored in the NSUserDefaults database, and the key tells NSUserDefaults which one you're interested in.




Reading preferences into the app


To use the preference settings for the app's view, you link it up with the view controller. The best place to do that is viewDidLoad, which is invoked right after the view has been loaded from the nib file.


After you add the code to use the preference settings, you need to now decide how to enable the user to change these settings. One easy way for your app to offer the preference settings is in a modal dialog box, which the user can use to enter his or her preferences.











dummies

Source:http://www.dummies.com/how-to/content/how-to-set-up-user-preference-settings-in-your-ipa.html

How to Temper Chocolate for Making Candy

If you’re making candy, chocolate is pretty much a staple ingredient. It’s often the finishing coat for a collection of other sweet treats that you dip into it. The process for getting chocolate to the proper consistency for dipping is called tempering, and the following steps show you how to temper chocolate by hand:



  1. Place a block of chocolate on a cutting board and, using a heavy knife, shave it into small pieces.


    Each piece of chocolate should be the size of a fingernail. Place the chopped chocolate in a bowl.



  2. Microwave or use a double boiler to melt the chopped chocolate to at least 110 degrees.


    Using a chocolate thermometer, check the temperature of the chocolate; its temperature should never exceed 120 degrees.



  3. Pour 2/3 of the melted chocolate onto a marble slab and work the chocolate back and forth using an offset spatula and a trowel (like a sheetrock tool) until the chocolate reaches 82 degrees on a chocolate thermometer (84 degrees for dark chocolate).


    The chocolate becomes thicker as it cools.



  4. Add the chocolate from the slab into the chocolate in the bowl and stir the two together.


    The chocolate should now be in temper.






dummies

Source:http://www.dummies.com/how-to/content/how-to-temper-chocolate-for-making-candy.html

Radiation Therapy’s Side Effects on Sexuality and Fertility

Because radiation therapy involves focusing strong beams of radioactive energy directly on the cancerous tumor and not throughout the body, most side effects occur in the immediate area where the radiation was directed.


If your radiation is targeted to a cancer in your pelvis or sex organs, you’ll likely experience some changes in your sexuality and fertility. Some of these changes are temporary and will go away when your treatment ends, but some are permanent.


There are different types of radiation therapy. Some are administered from the outside and some are implanted inside the body. Also, the radioactive chemicals used can vary according to the treatment. Be sure to ask your doctor what type of side effects you can expect from your particular type of radiation therapy.


Sexuality changes following radiation therapy


Both men and woman who undergo radiation therapy in the pelvic area are at risk for experiencing some level of sexual dysfunction. If you’re a man, you may experience impotence. If you’re a woman, you may develop symptoms that mimic peri-menopause. These include hot flashes, vaginal dryness, and irregular periods. You may also experience a loss of vaginal elasticity, called stenosis.


Most sexual problems clear up when radiation therapy is done. In the meantime, men may find relief by taking an erectile dysfunction drug. Vaginal moisturizers and dilators can relieve discomfort for women. However, if you’ve developed stenosis, it will probably be with you for life.


Fertility challenges from cancer treatment


Radiation therapy and pregnancy don’t mix. Women shouldn’t get pregnant while going through treatments. Radiation can harm the fetus. If you’re pre-menopausal, your doctor can recommend an appropriate birth control method. Women who are pregnant need to tell their doctor before beginning therapy.


Radiation in the pelvic region can cause permanent infertility. If you hope to have children someday, but your doctor has told you your radiation treatments will leave you sterile, you should talk with her about harvesting your eggs or sperm.


If you’re still able to have children after your cancer treatment, your treatment shouldn’t have any effect on your child’s health.


Many cancer patients receive both chemotherapy and radiation. If you’re one of them, you also need to consider that you may experience additional side effects from the chemotherapy.











dummies

Source:http://www.dummies.com/how-to/content/radiation-therapys-side-effects-on-sexuality-and-f.html

An Overview of Costs Associated with M&A

Although the main cost in any M&A transaction is most likely the cost to acquire the company (or assets), both Buyers and Sellers incur other costs. These costs range from the retinue of advisors needed to close deals, paying off debt, adjustments made after the close, and, regrettably, taxes.


Advisors’ fees and other costs


M&A deal-makers can’t do the job alone. Any Buyer or Seller should retain a capital M&A advisor (investment banker), a lawyer, and an accountant. These people don’t work for free, so their charges are part of the expenses of doing a deal. Of course, advisor fees vary based on the deal and how much work the advisor does, but here are some very general guidelines:



  • A lawyer may charge anywhere from $25,000 to more than $100,000.



  • An accounting firm may charge anywhere from $25,000 to $75,000.



  • Investment banking fees vary, but in a very general sense, you should expect to pay roughly 3 percent to 10 percent of the transaction value.




Some deals involve other costs as well, including a real estate appraisal, an environmental testing, a database and IT examination, and a marketing analysis. Fees vary, of course, but all these functions likely cost anywhere from $10,000 to more than $100,000 apiece.


Nailing down the costs without knowing the deal is impossible. The best way to get a concrete estimate of a particular deal’s fees is to speak with advisors and ask them to ballpark their expenses.


If you’re worried about fees spiraling out of control, negotiate a flat fee, or a capped fee, from your advisors if possible. Not all will be willing to do this arrangement. If you get pushback, you can always agree that if the advisor does the work for a flat fee now, you’ll give him the ongoing legal or accounting work post-transaction.


Pay off debt


One of the areas that Sellers often overlook is the debt of the business. Unless stipulated, a Buyer doesn’t assume the debt. If a company has $5 million in long-term debt and the company is being sold for $20 million, the Seller needs to repay that debt, thus reducing the proceeds to $15 million.


Post-closing adjustments


Another area that Sellers often don’t think about is the adjustments made to the deal after closing. Most often this is in the form of a working capital adjustment, which occurs when the working capital (receivables and inventory minus payables) on the estimated balance sheet Seller provided at closing doesn’t match up with the actual balance sheet that the Buyer prepares at a later, agreed-upon date (usually 30 to 60 days after closing).


Buyer and Seller do a working capital adjustment to true up (reconcile) their accounts; this adjustment is typically (though not always) minor. If the actual working capital comes in lower than the estimate, Seller refunds a bit to Buyer (often by knocking some money off the purchase price). If the figure comes in higher than the estimate, Buyer cuts Seller a check.


Say Buyer agrees to pay $10 million for a business and that Buyer and Seller agree that working capital has averaged $2 million. If Seller’s estimated balance sheet shows working capital to be $1.5 million, Seller has to provide Buyer with $500,000. With a working capital adjustment, Buyer just pays Seller $9.5 million rather than $10 million.


Why take working capital adjustments? Simply put, working capital is an asset, and if less of that asset is delivered at closing, Buyer is due a discount from the agreed-upon purchase price (and vice versa). Without a working capital adjustment, Seller would have every incentive to collect all the receivables (even if done at deep discounts), sell off all the inventory, and stop paying bills, thus inflating payables.


Buyer would take possession of a business that has been severely hampered by the previous owner. Buyer then has to spend money to rebuild inventory and pay off the old bills and doesn’t have the benefit of receivables.


Capital gains taxes


Sellers often forget that they likely face capital gains tax on the business sale. That’s one reason Sellers generally prefer stock deals; a stock deal likely has a lower amount of tax. For many (but not all) Sellers, an asset deal exposes them to double taxation: The proceeds are taxed at the time of the sale at the company level, and then the owner pays again when the company transmits the proceeds to her.


Speak to your financial advisor about your specific tax situation.




dummies

Source:http://www.dummies.com/how-to/content/an-overview-of-costs-associated-with-ma.html

Working Out with Resistance Machines

Resistance machines come in many shapes, styles, and sizes. In some cases, several machines work the same muscle groups and perform the same basic exercises, but they put you in different positions (sitting, lying, or standing), so the machines may look different. Some equipment uses a series of cables to pull up different amounts of weight bars stacked on top of each other. Other equipment uses hydraulic resistance — air pressure — to provide the resistance that your muscles will move against. A few machines, such as the Pilates Reformer, use springs for resistance. Whatever the physics of the machine you use, they all operate on the same principle: They make your muscles produce extra force to overcome the resistance.



Weight machines are the best type to allow you to monitor your progression — you can be very specific when determining the amount of weight and the increases in overload that you choose.



Lat pulldown


Since most free weight exercises with dumbbells have you raise the weight up, this machine is useful because the resistance is in the opposite direction. You pull away from the resistance instead of bringing it toward you.



Muscles worked: Latissimus dorsi.



1. Choose your desired weight, and then grasp the handles of the pulldown bar and sit on the seat of the machine. Extend your arms fully in a V position. Face your palms forward, not up, and curl your thumbs around the bar.


2. Sit and lean back slightly, and then exhale and pull the bar down, lowering it to the front of your chest with your elbows pressed to your sides. You may need to lean your torso slightly back, but keep the spine straight and abdominals contracted. Keep your wrists straight, in line with your forearms.


3. Hold, and then inhale as you allow the bar to raise up slowly. Repeat.


Focus & Connect: Rather than concentrating on your hands pulling on the bar, think of squeezing your back and shoulder muscles first to move the bar.



Safety Tip: Although you'll still see people in the gym using this machine incorrectly, avoid pulling the bar behind your neck as the position puts extreme stress on the shoulder joint.



Cable row


This is another pulling exercise that is great for the entire back. Make sure to hold good posture throughout: Keep your ribs lifted and spine straight.



Muscles worked: Latissimus dorsi, rhomboids, and posterior deltoids.



1. Choose your desired weight, and then attach the appropriate bar. The cable machine has several differently shaped handles that allow you to move in different directions, and with one or two hands.


2. Hold onto one bar with each hand and stand facing the weight stack. Your legs are in a split stance, right leg in front of the left. Your arms should extend in front of you at thigh level with your palms facing in.


3. As you exhale, pull your elbows toward your rib cage, and then behind your back. Hold, and then return to the extended position and repeat.


Focus & Connect: Feel your shoulder blades come together as your arms pull back.



Safety Tip: Avoid slouching, hold your ribs lifted, and keep your spine straight.



Cable press


This pulling exercise targets your chest muscles.



Muscles worked: Pectorals, deltoids, and serratus anterior.



1. Select your desired weight and stand sideways, left side next to a cable machine. Hold onto the cable handle with your inside (left) hand. Walk away from the machine until your left arm is outstretched; keep your elbow soft. Let your palm face down. Soften your knees, and with a straight back, lean slightly forward.


2. As you exhale, pull on the cable to move your arm across the front of your body, stopping when your left hand reaches the right side of your body. Hold, and then move the arm to the left side again and repeat.


3. Switch sides.


Focus & Connect: Feel the chest area near the inner upper arm contract as you move the weight.



Safety Tip: Avoid rounding your upper back. Keep the spine straight and abs tight throughout.



Pull-up bar


At its simplest, a pull-up bar is just a stable horizontal bar above your head that you reach up and grab onto to pull your head above the bar (similar to the bars you'll find on the jungle gym at the playground). This is a very difficult exercise because you essentially have to raise all of your body weight up, which can be a lot if you haven't worked up to it. Some new assisted pull-up machines in the gym allow you to lift up a portion of your weight. This enables you to work up gradually to doing full unassisted pull-ups. You can also make the standard pull-up easier by placing a chair underneath so that you pull yourself up from a higher level to begin with.



Muscles worked: Trapezius, latissimus dorsi, biceps, and deltoids.



1. Stand just underneath, but slightly behind an overhead bar. Hold onto the bar with your hands spaced shoulder-width apart. Your palms should face forward, and your thumbs should curl under.


2. As you exhale, pull your body up so that your chin rises above the bar by bending your elbows and using your back muscles to draw the elbows close to your ribs. Hold, and then slowly lower and repeat.


Options: To target different areas of the muscle groups, switch grips. Try a wider grip, hands spaced about three inches away from each shoulder. Or try a reverse grip with the palms rotated inward so that they face your body when grasping the bar.



Focus & Connect: Tighten your abs and entire torso to keep your body stable throughout the lift.



Safety Tip: If this is too difficult at first, start from the top and work your way down. Step up onto a bench, hold yourself in a lifted position, and then lower down slowly. When you can successfully lower with control, remove the bench and go through both the lifting and lowering phases of the move. You can also try the assisted pull-up machines in the gym that allow you to adjust how much of your own body weight you lift during the exercise.



Triceps cable extension


You can work your triceps in a multitude of positions using free weights. Here's a variation on the cable machine.



Muscles worked: Triceps brachii and posterior deltoids.



1. Choose your desired weight, and stand in front of the cable machine. Grasp onto the bar with both hands (palms down) and lower it so that it is in front of your waist. Your elbows should be bent at 90 degrees, and fists should be in front of your elbows.


2. As you exhale, push your hands down so that your elbows straighten. Keep your elbows by your sides and upper arm stable throughout the move. Hold, and then slowly raise the weight to starting position and repeat.


Focus & Connect: Tighten your abs and stand up tall (ribs lifted, thighs straight) during the move.



Safety Tip: If your elbows feel strained, make sure your hands are spaced elbow-width apart on the bar and/or lighten your weight.



dummies

Source:http://www.dummies.com/how-to/content/working-out-with-resistance-machines.html

Escaping from Computer Hell on Your Mac

You know that frustrating, annoying, sometimes panicked feeling you get when your Mac isn’t doing what you expect? If an application freezes or your computer is generally misbehaving, try these tips to escape with minimal disruption.



  • Use Force Quit when an application is unresponsive. Choose Force Quit from the Apple menu or press Command+Option+Esc keys. Click the name of the deviant application (it probably has not responding next to its name). You typically won’t have to reboot.



  • Restart. If Force Quit doesn’t bail you out, try rebooting the computer. If a frozen Mac prevents you from clicking the Restart command on the Apple menu, hold down the power button for several seconds or press the Control+Command keys and then press the power button. If all else fails, pull the plug, but remember that powering down without logging out should be used only as a last resort.



  • Restart in Safe Mode. Press the power button to turn on your computer, and then press and hold the Shift key the instant you hear the welcome chime. Release Shift when the Apple logo appears. The words Safe Boot appear in OS X’s login window. In Safe mode, the Mac unleashes a series of troubleshooting steps designed to return the computer to good health. If Safe Boot resolved the issue, restart the Mac normally the next time.






dummies

Source:http://www.dummies.com/how-to/content/escaping-from-computer-hell-on-your-mac.html

How to Deal with Randomness in the Stock Market

Technical traders acknowledge that random events can and do cause a stock to have an occasional wild price departure from the norm, but the acknowledgement doesn’t alter the expectation that prices will behave normally. For example, you sometimes see a price spike so big that you don’t know how to interpret it. Often, you never find out why such a bizarre price occurred.


A price spike is the equivalent of a tornado in weather forecasting. You know the conditions that cause tornadoes — you just don’t know exactly when an actual tornado will develop.


Although nature may not be able to deliver a tornado in Alaska in January, the equivalent does happen in markets. Most market tornadoes, like Black Monday in 1987 (when the S&P 500 fell more than 20 percent in a single day), give plenty of technical warnings ahead of time. The problem is that traders often have those same warnings and don’t get a Black Monday. This is an inconvenient fact of life that you have to accept.


Spikes are both a problem and an opportunity:



  • If you know why a spike is occurring because you’re well informed about world events and market chatter in response to the world events, you may chose to ride it out.



  • To exit on fear of randomness is okay, too. You take no risk when you are out of the market. Nowhere is it written that you must have a position in the market at all times.






dummies

Source:http://www.dummies.com/how-to/content/how-to-deal-with-randomness-in-the-stock-market.html

Days of the Week in Italian

In Italian, the days of the week aren't capitalized. Eyeball this table of the days of the week in Italian (along with pronunciations and abbreviations) to ensure you get your days straight while in Italy.











































Italian/AbbreviationPronunciationTranslation
domenica/do.doh-meh-nee-kahSunday
lunedì/lun.looh-neh-deeMonday
martedì/mar.mahr-teh-deeTuesday
mercoledì/mer.mehr-koh-leh-deeWednesday
giovedì/gio.joh-veh-deeThursday
venerdì/ven.veh-nehr-deeFriday
sabato/sab.sah-bah-tohSaturday

You might also need to know how to say the following:



  • Oggi (ohj-jee) (today)



  • Domani (doh-mah-nee) (tomorrow)



  • Dopodomani (doh-poh-doh-mah-nee) (day after tomorrow)



  • Ieri (yeh-ree) (yesterday)






dummies

Source:http://www.dummies.com/how-to/content/days-of-the-week-in-italian.html

How to View a Digital Image in Windows XP’s Picture and Fax Viewer

You can use Picture and Fax Viewer For Windows XP to not only view your digital images, but also you can use Picture and Fax Viewer to make minor modifications to your digital images, such as rotating or deleting them. XP's Picture and Fax Viewer gives you a couple of options for viewing your images, and these easy-to-follow steps both get you to Picture and Fax Viewer as well as show you how to view and modify your digital images.



  1. Choose Start→All Programs→Accessories→Windows Explorer.


    Locate an image file on your hard drive, network, or storage media by using Windows Explorer.



  2. Right-click the filename or icon and choose Open With→Windows Picture and Fax Viewer.


    At the bottom of the resulting Windows Picture and Fax Viewer, you can use the following tools:



    • The Next Image and Previous Image icons move to a previous or following image in the same folder.



    • The Best Fit and Actual Size icons modify the display of the image in the Picture and Fax Viewer.



    • The Start Slide Show icon begins a full-screen slide show of images.



    • The Zoom In and Zoom Out icons enlarge or shrink the image display.



    • The Rotate Clockwise and Rotate Counterclockwise icons spin the image 90 degrees at a time.



    • Delete, Print, Copy To, and Close All do what their names say.





  3. Click the Close button.


    You can find the Close button in the top-right corner to close the Viewer when you finish viewing images.






dummies

Source:http://www.dummies.com/how-to/content/how-to-view-a-digital-image-in-windows-xps-picture.html

Network Verification: Pinging

A basic test that you can perform to ensure that your network is functioning is to use the ping command from a command prompt to make sure that the computers on the network can contact each other. The ping command simply sends a packet to another computer and requests that the second computer send a packet back in reply.


If the reply packet is received, ping displays a message indicating how long it took to hear from the other computer. If the reply packet isn't received, ping displays an error message indicating that the computer couldn't be reached.


You should try several ping tests. First, you can make sure that TCP/IP is up and running by having the computer try to ping itself. Open a command prompt and type ping 127.0.0.1. (127.0.0.1 is the standard loop-back address that a computer can use to refer to itself.) If you prefer, you can type ping localhost instead.


Next, have the computer ping itself by using the IP address displayed by the \ ipconfig command. For example, if Ipconfig says the computer’s IP address is 192.168.0.100, type ping 192.168.0.100 at the command prompt.


Now try to ping your servers. You’ll have to run ipconfig at each of the servers to determine their IP addresses. Or, you can just ping the computer’s name.


A final test is to make sure that you can ping the workstation from other computers on the network. You don’t have to try to ping every computer from every other computer on the network unless you’ve determined that you have a connectivity problem that you need to pinpoint.


However, you should try to ping each workstation from each of the servers, just to make sure the servers can see the workstations. Make a list of the IP addresses of the workstations as you test them and then take that list to the servers and ping each IP address on the list.




dummies

Source:http://www.dummies.com/how-to/content/network-verification-pinging.html

Items to Bring to a Film Shoot Location

Shooting a film on location keeps your filmmaking interesting, but it can also make your nerves frazzled. Before you head out on location, make sure you have everything you need — the items in the following list are crucial:































Map to the locationMasking tape, duct tape, rope
CameraTripod
Sound recorderActors' wardrobe
MicrophonesFilm, videostock, memory cards or hard drives (depending on
what format you're shooting with)
Extra batteriesStoryboards and the shot list
LightsCopy of the script
Extension cords








dummies

Source:http://www.dummies.com/how-to/content/items-to-bring-to-a-film-shoot-location.html

Excel VBA Programming For Dummies

The Visual Basic for Applications (VBA) programming language lets you automate many aspects of Excel by writing Sub and Function procedures (also known as macros). A good knowledge of VBA can save time and make you a much more productive Excel user.






>


>


Common VBA Statements for Excel VBA Programming


The following table provides a list of commonly used VBA statements that you might use when creating macros for Excel. For more information on a particular statement, consult Excel's Help system.



















































































































































































































































































































VBA StatementWhat It Does
AppActivateActivates an application window
BeepSounds a tone via the computer's speaker
CallTransfers control to another procedure
ChDirChanges the current directory
ChDriveChanges the current drive
CloseCloses a text file
ConstDeclares a constant value
DateSets the current system date
DeclareDeclares a reference to an external procedure in a Dynamic Link
Library (DLL)
DeleteSettingDeletes a section or key setting from an application's entry in
the Windows Registry
DimDeclares variables and (optionally) their data types
Do-LoopLoops through a set of instructions
EndUsed by itself, exits the program; also used to end a block of
statements that begin with If, With, Sub, Function, Property, Type,
or Select
EraseRe-initializes an array
ErrorSimulates a specific error condition
Exit DoExits a block of Do-Loop code
Exit ForExits a block of For-Next code
Exit FunctionExits a Function procedure
Exit PropertyExits a property procedure
Exit SubExits a subroutine procedure
FileCopyCopies a file
For Each-NextLoops through a set of instructions for each member of a
series
For-NextLoops through a set of instructions a specific number of
times
FunctionDeclares the name and arguments for a Function procedure
GetReads data from a text file
GoSub...ReturnBranches to and returns from a procedure
GoToBranches to a specified statement within a procedure
If-Then-ElseProcesses statements conditionally
Input #Reads data from a sequential text file
KillDeletes a file from a disk
LetAssigns the value of an expression to a variable or
property
Line Input #Reads a line of data from a sequential text file
LoadLoads an object but doesn't show it
Lock...UnlockControls access to a text file
MidReplaces characters in a string with other characters
MkDirCreates a new directory
NameRenames a file or directory
On ErrorGives specific instructions for what to do in the case of an
error
On...GoSubBranches, based on a condition
On...GoToBranches, based on a condition
OpenOpens a text file
Option BaseChanges the default lower limit for arrays
Option CompareDeclares the default comparison mode when comparing
strings
Option ExplicitForces declaration of all variables in a module
Option PrivateIndicates that an entire module is Private
Print #Writes data to a sequential file
PrivateDeclares a local array or variable
Property GetDeclares the name and arguments of a Property Get
procedure
Property LetDeclares the name and arguments of a Property Let
procedure
Property SetDeclares the name and arguments of a Property Set
procedure
PublicDeclares a public array or variable
PutWrites a variable to a text file
RaiseEventFires a user-defined event
RandomizeInitializes the random number generator
ReDimChanges the dimensions of an array
RemSpecifies a line of comments (same as an apostrophe ['])
ResetCloses all open text files
ResumeResumes execution when an error-handling routine finishes
RmDirRemoves an empty directory
SaveSettingSaves or creates an application entry in the Windows
Registry
SeekSets the position for the next access in a text file
Select CaseProcesses statements conditionally
SendKeysSends keystrokes to the active window
SetAssigns an object reference to a variable or property
SetAttrChanges attribute information for a file
StaticDeclares variables at the procedure level so that the variables
retain their values as long as the code is running
StopPauses the program
SubDeclares the name and arguments of a Sub procedure
TimeSets the system time
TypeDefines a custom data type
UnloadRemoves an object from memory
While...WendLoops through a set of instructions as long as a certain
condition remains true
Width #Sets the output line width of a text file
WithSets a series of properties for an object
Write #Writes data to a sequential text file




>



>


>


VBA Functions for Excel VBA Programming


The VBA language contains a number of functions that you can use to build code in Excel. The following table provides descriptions of the most useful functions. When writing code, type the word VBA followed by a period, and you'll see a drop-drop list of these functions. See Excel's Help system for more details.























































































































































































































































































































































































































































































VBA FunctionWhat It Does
AbsReturns the absolute value of a number
ArrayReturns a variant that contains an array
AscConverts the first character of string to its ASCII value
AtnReturns the arctangent of a number
CBoolConverts an expression to boolean
CByteConverts an expression to byte data type
CCurConverts an expression to currency data type
CDateConverts an expression to date data type
CDblConverts an expression to double data type
CDecConverts an expression to decimal data type
ChooseSelects and returns a value from a list of arguments
ChrConverts an ANSI value to a string
CIntConverts an expression to integer data type
CLngConverts an expression to long data type
CosReturns the cosine of a number
CreateObjectCreates an OLE Automation object
CSngConverts an expression to single data type
CStrConverts an expression to string data type
CurDirReturns the current path
CVarConverts an expression to variant data type
CVDateConverts an expression to date data type
CVErrReturns a user-defined error number
DateReturns the current system date
DateAddReturns a date with a specific date interval added to it
DateDiffReturns a date with a specific date interval subtracted from
it
DatePartReturns an integer containing a specific part of a date
DateSerialConverts a date to a serial number
DateValueConverts a string to date
DayReturns the day of the month of a date
DirReturns the name of a file or directory that matches a
pattern
DoEventsYields execution so the operating system can process other
events
EOFReturns True if the end of a text file has been reached
ErrorReturns the error message that corresponds to an error
number
ExpReturns the base of the natural logarithms (e) raised to
a power
FileAttrReturns the file mode for a text file
FileDateTimeReturns the date and time when a file was last modified
FileLenReturns the number of bytes in a file
FixReturns the integer portion of a number
FormatDisplays an expression in a particular format
Format CurrencyReturns a number as a string, formatted as currency
FormatDateTimeReturns a number as a string, formatted as a date and/or
time
Format NumberReturns a number as a formatted string
Format PercentReturns a number as a string, formatted as a percentage
FreeFileReturns the next file number available for use by the Open
statement
GetAllReturns a list of key settings and their values (originally
created with SaveSetting) from an application’s entry in the
Windows registry
GetAttrReturns a code representing a file attribute
GetObjectRetrieves an OLE Automation object from a file
GetSettingReturns a key setting value from an application’s entry
in the Windows registry
HexConverts from decimal to hexadecimal
HourReturns the hour of a time
IIfReturns one of two parts, depending on the evaluation of an
expression
InputReturns a specific number of characters from an open text
file
InputBoxDisplays a box to prompt a user for input
InStrReturns the position of a string within another string
InStrRevReturns the position of a string within another string,
beginning at the back end of the string
IntReturns the integer portion of a number
IsArrayReturns True if a variable is an array
IsDateReturns True if a variable is a date
IsEmptyReturns True if a variable has been initialized
IsErrorReturns True if an expression is an error value
IsMissingReturns True if an optional argument was not passed to a
Procedure
IsNullReturns True if an expression contains no valid data
IsNumericReturns True if an expression can be evaluated as a number
IsObjectReturns True if an expression references an OLE Automation
object
JoinReturns a string created by joining a number of substrings
contained in an array
LBoundReturns the lower bound of an array
LCaseReturns a string converted to lowercase
LeftReturns a specified number of characters from the left of a
string
LenReturns the length of a string, in characters
LocReturns the current read or write position of a text file
LOFReturns the number of bytes in an open text file
LogReturns the natural logarithm of a number
LTrimReturns a copy of a string with no leading spaces
MidReturns a specified number of characters from a string
MidBReturns a specified number of bytes from a string
MinuteReturns the minute of a time
MonthReturns the month of a date
MonthNameReturns a string indicating the specified month
MsgBoxDisplays a modal message box
NowReturns the current system date and time
OctConverts from decimal to octal
ReplaceReturns a string in which one substring is replaced with
another
RGBReturns a number representing an RGB color value
SpaceReturns a string with a specified number of spaces
SplitReturns an array consisting of a number of substrings
SqrReturns the square root of a number
StrReturns a string representation of a number
RightReturns a specified number of characters from the right of a
string
RndReturns a random number between 0 and 1
RoundRounds a number to a specific number of decimal places
RTrimReturns a copy of a string with no trailing spaces
SecondReturns the second of a time
SeekReturns the current position in a text file
SgnReturns an integer that indicates the sign of a number
ShellRuns an executable program
SinReturns the sin of a number
StrCompReturns a value indicating the result of a string
comparison
StrConvReturns a string variant converted as specified
StringReturns a repeating character or string
StrReverseReverses the character order of a string
SwitchEvaluates a list of expressions and returns a value associated
with the first expression in the list that is True
TabPositions output in an output stream
TanReturns the tangent of a number
TimeReturns the current system time
TimerReturns the number of seconds since midnight
TimeSerialReturns the time for a specified hour, minute, and second
TimeValueConverts a string to a time serial number
TrimReturns a string containing a copy of a specified string
without leading spaces and trailing spaces
TypeNameReturns a string that describes the data type of a
variable
UBoundReturns the upper bound of an array
UCaseConverts a string to uppercase
ValReturns the numbers contained in a string
VarTypeReturns a value indicating the subtype of a variable
WeekdayReturns a number representing a day of the week
Weekday NameReturns a string indicating the specified weekday
YearReturns the year of a date




>






>
dummies


Source:http://www.dummies.com/how-to/content/excel-vba-programming-for-dummies-cheat-sheet.html

Named Colors and Hex Values in HTML

The following table contains a list of named colors you can use in HTML and CSS code to create a more colorful Web site. The colors are given with their corresponding RGB hexcode values and a representative color swatch.








































































Name Hexcode
Aqua#00FFFF
Black#000000
Blue#0000FF
Fuchsia#FF00FF
Gray#808080
Green#008000
Lime#00FF00
Maroon#800000
Navy#000080
Olive#808000
Purple#800080
Red#FF0000
Silver#C0C0C0
Teal#008080
White#FFFFFF
Yellow#FFFF00


dummies

Source:http://www.dummies.com/how-to/content/named-colors-and-hex-values-in-html.html