Excel Tips – 3 Ways To Protect Your Excel Formulas

In this article I want to share with you 3 ways to protect your Excel formulas.

So, you have spent a long time preparing your Excel spreadsheet solution, and I bet you do not want anyone to mess up those formulas you have so lovingly created. So, there are a few ways to protect some of those most vulnerable parts of your Excel spreadsheet.

My top 3 ways to protect your Excel Formulas !!

  1. Hide the Formulas.
  2. Lock The Cells That Contain Formulas.
  3. Hide The Formula Bar With Some Simple VBA.

1.Hide The Formulas.

This method will temporarily hide your formulas , but you will be able to use them again if you need to. It's simple and straight forward. Here we go.

Select all of the cells that contain formulas that you want to hide.

  • Home Tab – Cells Group – Format – Format Cells
  • Navigate to the Protection Tab
  • Check the Hidden option and hit OK

This does not in itself hide your formulas, you need to then protect your worksheet to ensure these settings work.

  • Select Review Tab
  • Changes Group
  • Select Protect Sheet
  • Enter a password and confirm password when prompted
  • That's all you need to do.

Try selecting the a cell that contains a formula. The formula will not be visible in the formula bar. If you want to see the formulas again simply unprotect your worksheet.

2. Lock The Cells That Contain Formulas.

The second method is to just lock the cells that contain formulas so they can not be selected or edited by users. By default all cells in a work book are locked, so you will need to unlock them all to start with.

  • Hit CTRL + A to select all of the cells on the worksheet
  • Home Tab – Cells Group -Format – Format Cells
  • Untick Locked, to unlock all of the cells on the worksheet
  • Hit OK

Now all we need to do find all of the cells that contain formulas …

  • Hit F5 to bring up the GoTo Dialog Box
  • Select Special – Formulas – Hit OK
  • All of the cells that contain formulas will be highlighted

Then we need to lock those highlighted cells …

  • Home Tab – Cells Group -Format – Format Cells
  • Navigate to the Protection Tab
  • Check the Locked option and hit OK

This does not in itself lock your formulas, you need to then protect your worksheet to ensure these settings work.

  • Select Review Tab
  • Changes Group
  • Select Protect Sheet
  • Enter a password and confrm password when prompted
  • That's all you need to do.

3. Hide The Formula Bar With Some Simple VBA

My third method of hiding your formulas is to actually hide the formula bar on the Excel worksheet. This is easily achieved by a very small piece of VBA coding or an Excel Macro.

This macro uses the Application Object and we are looking to use the DisplayFormulaBar property of it.

To use this small piece of coding, you need to insert it into a module in your Excel workbook.

  • Open Visual Basic – by hitting F11 or Developer Tab – Visual Basic – Click Modules, and Add New Module.

Here is the VBA code if you want to copy it. Just paste it into a module you have created as per the instructions above.

Sub HideFormulaBar ()

Application.DisplayFormulaBar = False

End Sub

Just as we have hidden the formula bar we can easily write some VBA to show the formula bar again

Sub ShowFormulaBar ()

Application.DisplayFormulaBar = True

End Sub

In this instance we set the Application.DisplayFormulaBar to TRUE to display the formula bar.

I use all of these methods in my Excel spreadsheets depending on which I feel is most appropriate for that project I am working on for example it maybe not always appropriate to hide the formula bar even if some calculations are still needed to be seen, so I would just hide the sensitive formulas in that case. if it is a purely visual Dashboard solution then hiding the formula bar not only gives room on the Excel display area, but it always makes for a very neat and tidy visual for the Dashboard presentation.

House-Training a Puppy – Top 10 Survival Tips

House-training a puppy does not have to be a difficult or time-consuming process when you have the key points covered. I find that many new dog owners approach house-training as if they were dealing with another person.

Let me assure you that this approach will not work. You actually need to appreciate and take advantage of differences between dogs and people. For any kind of dog training, the most important difference is that dogs are creatures of habit and not creatures of reason.

You can not simply appeal with a dog or punish him in order to make him understand what you expect from him. You must correct his bad behavior and praise his good behavior. Then do this over and over until your dog gets it. Once you realize this key to successful dog training, house-training will become much easier.

I'm about to give you 10 of the most important tips for house-training your puppy. These tips, which apply to both housebreaking and paper-training, cover all of the essential components of successful house-training.

  1. Visit your veterinarian . This is always a good first step because it will help to ensure that there are no medical reasons preventing or hindering your house-training efforts. Plus, it's always a good idea to have a new pet checked out as soon as they're introduced into the family unit.
  2. Start house-training your puppy early . As soon as your new puppy arrives in your home, start house-training him. But, do not expect too much from a very young puppy. They have almost no control over their bladder and bowels. So it's up to you to get them outside regularly.
  3. Decide what method of house-training is right for your situation . If you live in a high-rise apartment building or if you're disabled or handicapped, you might want to consider paper-training rather than housebreaking.
  4. Get your puppy on a schedule immediately . Do not miss the importance of this step. Puppies need to eliminate shortly after they eat, drink, play, and sleep. If you can schedule these events, you can get them outside (or onto papers) at the appropriate time. This can speed training considerably!
  5. Use confinement and supervision religiously . Never allow your puppy to wander around the house unsupervised. I can guarantee that he will have an accident. And, every accident that goes unaccompanied slows the training.
  6. Consider Crate Training to speed house-training . When done correctly crate training is very beneficial for any puppy. It provides a secure retreat for your puppy and it also helps him to learn to control his bowels and bladder. That's because dogs by nature do not like to eliminate where they sleep. So as long as you do not leave him in the crate for hours on end, your puppy will try to hold it until you let him out.
  7. Correct an accident only if you witness it . Without you see your puppy eliminating in the house, you can not do anything except clean it up and try to supervise him better next time. If you do catch him, do something to interrupt him (like saying "NO!" In a strong tone) and get him outside immediately. Never hit him or try to punish him after the fact! You'll only be teaching him to be afraid of you. This could backfire causing him to urinate every time he sees you.
  8. Praise every successful elimination . Never miss the opportunity to praise your puppy profusely when he goes where and when he should. Praise is the golden key to successful and quick house-training.
  9. Be patient . Try to be as patient with your young puppy as you would be with your child being toilet trained. Different children take to toilet training at different speeds. The same is true for puppies and house-training.
  10. Be consistent . I saved this for last because its probably the most important. If you're not consistent in all your training efforts, your puppy will find it hard to recognize exactly what you want him to do. And, failure is assured.

Remember, your puppy would like nothing better than to please you. As soon as he figures out what it is that will please you, he'll be eager to do it! And, the training will be pretty much complete.

Therefore, your task is to make it very clear to him exactly what you want and expect from him. And you do this by correcting mistakes WHILE they're happening and by seeing his successes.

If you do this consistently , you can not fail!

Is Good Posture Hurting Your Back?

Proper posture is supposed to help keep our backs healthy. Why, then, do some experience back pain when sitting or standing properly? If you are trying to relieve back pain by improving posture and experiencing more of it, don’t give up just yet.

Muscles learn behavior. Technically, “muscle memory” refers to the brain’s tendency to record repeated behaviors and make them automatic in the future. If your posture trains your muscles to be tense or lax, eventually the brain will send signals to those muscles that cause them to tense up or disengage automatically. This is why proper posture is difficult to perform; it is a retraining of your muscles and brain that takes time.

Slouching, characterized by stooped shoulders, rounded lower back and tucked pelvis, is the classic example of poor posture. Let’s analyze the ways in which this positioning and training affects muscles. Rounded, stooped shoulders cause muscles in the chest to tighten and shorten in length. The natural lumbar arch in the lower back is flattened out by slouching; this strains the lower back muscles. Muscles in the stomach are not allowed to engage in this position, causing further strain to the lower back muscles which must support the upper body by themselves. Muscles within the hip are shortened when sitting for prolonged periods of time, and if your pelvis is not neutral, they will become even tighter.

The many muscular changes that slouching causes do not simply go away when you sit up straight; the tight muscles in the chest and hips will resist lengthening while the overstretched, strained muscles in the back will not be sufficiently conditioned to perform their task. This is why, at first, good posture can actually cause back pain.

It is still important to correct posture; even if your back didn’t hurt before, poor posture will eventually cause pain. As the tug-of-war increases between imbalanced muscles, you may suffer chronic pain due to tenseness and strain. If the muscles of the back cannot sufficiently support the spine’s alignment, you run the risk of disc and vertebral problems. Finally, spinal joints will eventually be affected by poor posture. Correcting your alignment can prevent chronic pain conditions.

Helpful Tips

Though it is important to work through the pain, you should not simply force your muscles into new positions without a complementary plan. You will need to lengthen your tight muscles and build your weaker ones to make correct posture possible and, eventually, painless.

After stretching tense muscles, the exercises you do will focus on core strength. Developing the abdominal, lower back, hip and buttocks muscles will allow you to hold your spine up. See the Mayo Clinic’s slideshow of balanced core exercises at http://www.mayoclinic.com/health/core-strength/SM00047.

For some people, the damage done to the muscular system will require more than simple stretching and exercising. The help of a massage or physical therapist may be needed to relax tense muscles. Deep tissue massage or self-myofascial release can accomplish this. If postural dysfunction is severe, a physical therapist may need to guide you in exercise technique. Finally, if poor posture has caused your spine to become misaligned, you may require chiropractic care.

Another useful tip is to invest in a lumbar support cushion. While you work on developing a strong core, this type of cushion will help to support your upper body’s weight until your muscles are strong enough to do so without assistance.

If proper posture is causing you pain, this is a testament to the damage poor posture has done to your body. Your efforts can be assisted by stretching, exercising and using a lumbar cushion. If you are unable to correct your problem at home, don’t hesitate to seek out professional care. The future of your back may depend on it.

Pro Tools Optimization Guide For Audio Recording

Optimizing your Pro Tools system is yet another important part of having smooth and stable recording / mixing / mastering sessions and each particular process requires different configurations.

Optimizing for recording: When recording audio, latency is a big issue, you want the least latency possible so that there is no lag between the source and what you're capturing, latency issues can cause artifacts in the recording that are not very pretty !

(Assuming you're already inside PTD / LE) Go to the "System" Menu and select "Playback Engine." Here, you will see various options, the first one being H / W Buffer Size. This means: "Hardware Buffer size" which refers to the timing of latency between the hardware and the software. You will notice there are quite a few options in the dropdown menu:

  • 64
  • 128
  • 256
  • 512
  • 1024
  • 2048

As I said, you want the lowest option your system can perform, if your system can utilize 64 ms latency, fantastic, if not, do not stress yourself too much. If you can keep your buffer size between 64 and 256, you're doing well. If you're uncomfortable playing with these settings for now, that's fine! Those of you who fall into this category, just keep it at 512 samples.

The next option that you will see is: "Host Processors" This indicates to how many processors Pro Tools will use to allocate threads to. If you have a quad core CPU, you will be using four cores, if you have hyperthreading enabled in your BIOS settings, you will see 8 in this menu, if you have 8 physical cores (dual CPU) you will see 8 and if you 're using hyperthreading with 8 physical cores, you will see 16! If you're using 8 physical cores though, you will not have any need to enable hyperthreading. Basically, for this particular option, keep it as high as you can, the manual will say to use one less core, but I disagree.

The final setting under the "Settings" category is CPU usage limit, what this is, is basically a brickwall limiter for your CPU that works off of a percentage. When your system reaches a specified usage amount due to RTAS plug ins and Audiosuite rendering, etc, once it reaches the peak, it will go no further than that. A setting of 85% or 90% is acceptable here.

The next section you will see refer to the DAE playback buffer, which deals with disk latency and plugins / audio streaming. This is a very important setting for recording and mixing. Different from the H / W buffer in that this setting does not focus on the CPU or Digidesign hardware, but on your hard drive. You will see "size" and in the dropdown menu you will see levels 1-4, keep this on level 1 and if your system can handle it, put it on 0! For Cache size, leave this on normal without your system is really having a hard time, then switch it to large. (If you followed my recording PC guide, you will be just fine leaving this on normal!)

Lastly, you will see an option with a tick box that says: "ignore errors during playback / record" (may cause clicks and pops). This setting is debatable, if there is something wrong and you keep getting errors when mixing about the DAE engine and you just can not get it to go away, tick this box (especially with the 8.0.3 update) I hear no clicks or pops with or without it. I have not had this particular option enabled when tracking so I can not speak for this option in such an instance, only with mixing.

Try to keep it unchecked if possible, if you notice nothing wrong with tracking or mixing, leave it on, it is most likely doing no harm.

These steps should lead you in the right direction for a stable recording system with Pro Tools HD / LE!

Maintenance Tips For Commercial Carpeting

Commercial carpeting comes in all shapes and sizes, but making it last for the long haul depends on how well you take care of it. Commercial carpets are usually found in offices and commercial environments where there is heavy foot traffic. That means it's sooner to wear and tear than your average residence.

Believe it or not, if you can keep your carpets looking like new in even high traffic areas if you develop a system for maintaining the floors. You should clean commercial carpeting, for example, on a daily basis to extend its life. Vacuuming is a critical part of that maintenance.

Think of vacuuming your commercial carpeting as you would prevent maintenance on your car. It's important to how well it functions over the long haul. Your commercial carpeting is exposed to all sorts of potentially damaging elements, like dirt, grease, gum, or other debris that shortens its lifespan if not properly cleaned.

Depending on how heavy the traffic flow is through a facility, you may even need to vacuum your commercial carpeting more than once a day, or you may only need to vacuum certain areas more than once a day. The idea is to keep the elements from setting into the fiber of the commercial carpeting. Just because your carpet looks clean does not mean it is clean.

Your commercial carpet maintenance plan could even be broken up seasonally to take into consideration the different issues you face at different times of the year, like rain in the summer, snow in the winter, leaves and dirt in the autumn and so on.

Springtime is a good time to shampoo your commercial carpet, part of the spring cleaning ritual in your facility. Vacuuming daily is recommended, but it does not remove all the dirt and soil from the carpet. You will need to shampoo your commercial carpeting at least once a year, and springtime can be ideal.

Wintertime may only give you time for daily maintenance, especially if you are in the retail business. Summertime, by contrast, may be slower and could be a good time to restorative cleaning processes. It might even be the best time to replace your commercial carpeting with new carpet if it's visibly worn out.

You may even consider using a sweeper machine. A sweeper can be used on hard surfaces as well as commercial carpeting and can get the job done quicker. This may encourage your staff to stay on the preventive maintenance schedule.

Lessons in Baby Massage: 12 Most Frequently Asked Questions

At its most basic, a baby massage offers precious moments to emotionally connect with your infant, relaxing you and baby. Since touch is the most developed sense for an infant, it is not surprising that early massages have the ability to stimulate nerve centers and improve immune system function. There are overwhelming scientific evidence in support of baby massage that the negatives are difficult to find.

We have put together 12 most frequently asked questions (FAQ) on the subject and provided answers from qualified instructions.

QUESTIONS ON BABY MASSAGE

1: Will I hurt my baby?

Use firm, slow strokes. For guidance on how much pressure to place on infant, look at baby cues to help. Not too hard, but too light might be ticklish.

2: At what stage should you start a massage?

Massages start at the new-born stage, as soon as the mother feels comfortable performing the technique.

3: When is the ideal time to massage your baby?

When your baby is in the quiet alert state is a good time for a massage. Other suggestions are after a bath, and at least half an hour after a feed.

4: Should I massage an ill baby?

Do not massage an ill or disturbed baby. Always look for cues that indicate abnormal behavior.

5: Should I begin with a full head-to-toe massage?

No. Perform massages in limited sessions until baby can tolerate a full massage, both anteriorly (toward the front) and posteriorly (toward the back).

6: What type of oil should I use and how much?

Several types of oil may be used in generous amounts. Simply pour warm oil into the palm of the hand and rub them together for even distribution. Recommended oils are: Organic vegetable / nut oils (example-olive, sunflower, sweet almond, sesame). These are unscented, and will not interfere with phototherapy.

7: What if baby looks to always resist massage?

Hold your baby gently, but firmly (using containment holds), until they gradually relax and accept the massage.

8: Is baby massage helpful with a colicky baby?

Yes! Babies who have their tummies and legs rubbed along with knee pressing exercises (into the tummies) receive fantastic success rates. Rub their tummy in a circular clockwise direction.

9: Can a massage help with asthma and skin disorders?

Touch Research Institute conducted studies that show the benefits of massage for both these conditions. Parents can learn the technique from qualified instructors.

10: Do I need to learn technical strokes or can I just gently rub baby all over?

Massage strokes are specific in generating a scientific result. Once you learn the techniques you will begin to see the difference. The strokes incorporate Swedish, Indian and Reflexology components.

11: How often should baby be massaged?

Massages can be done more than once per day; some experts recommends up to 3 times a day. The ideal amount is very personal to your baby, you and family circumstances.

12: What should be the first steps before starting a massage?

Gather all needed supplies. Ensure that the room is warm. Begin the massage when your baby is comfortable. Start at one of the extremitudes, and remember not to overtire baby.

Baby massage is comforting and improves all-over circulation and encourages growth. Begin the habit of asking permission from your baby before starting a session, as this will become an essential part of the routine later on.

5 Ways To Build A Health Care Brand That Calls To Moms

In order to build a healthcare brand in this day and age, medical professionals have had to undergo a massive realignment to the way they do business. The old business model no longer works, and in order to survive the business of medicine, medicine has had to evolve with the changing times.

However, one thing that medical professionals have always had to do is make the right connection with their customer / patient. When it comes to appealing to mothers, the medical profession has been keenly aware of how important this segment of the population is to medicine. In terms of building a nursing health brand, moms are at the top of the list when it comes to building a brand that also grows. Ways to appeal to mothers include the following:

Base Your Approach with Kids in Mind – Today's family dynamic is different than in years past. Children are being given a chance to be influential in the decisions that surround their lives. A healthcare brand that keeps kids in the loop and a major focus stands a greater chance of being seen as evolved and patient-centric.

Be Mindful of Your Online Presence – The modern parent tends to be tuned in to their technology now more than ever. Any healthcare brand that wants to succeed with moms these days needs to be able to appeal to this "techie" side of things and have a solid website & social media presence. By being able to digest patient reviews, a list of services and amenities, and even make appointments online, a healthcare brand becomes accessible to the go-go mom of today in a way that was not possible just a few years ago.

Better Communication via 21st Century Means – At one point in time, a phone call with a human on the other end of the line was all we wanted in terms of customer service. Today, though, more and more moms are skewing toward engaging with their doctor in ways that are more personable while still maintaining use of the technology with which they are comfortable. Being able to send emails directly to their doctor can be appealing. Offices that send out messages regarding scheduling changes through social media (brand-specific Twitter and Facebook accounts) ties into activities that can engage the modern mom.

Better Rapport with Patients – Believe it or not, even the modern mom appreciates a good bedside manner. More often than not, medical professionals are seen as somewhat removed, rushed due to over-scheduling, and distanced from their patients with many complaining that their attending physician does not even look them in the eye during a visit. By taking the time to address scheduling issues & addressing the in-house staff on better interpersonal skills, a healthcare brand stands to win because word-of-mouth references are the gold standard of a business establishing itself in the community.

Keep It Simple – Sometimes the simplest approach is the best. Yes, a nice website & organized social media presence can be beneficial, but be sure the information you present is easy to digest. Certainly appealing to the modern parent that wants a fully online experience, but never shy away from the parent that still wanted to hear the calming effect of a human voice on the line. It can be easy to create a healthcare brand that is shiny and technologically fitted for the foreseeable future, but medicine is about people.

In the end, a successful healthcare brand is one that appeals to more than just moms; it appeals to the community at large. Success includes an evolved view at how society has changed while always maintaining a foothold on the purpose of medicine – to heal.

Advantages And Disadvantages Of On Site Landfill Leachate Treatment Versus Off Site

If there is a choice between On Site Landfill Leachate Treatment and off site at a sewage (municipal wastewater treatment) works or even at a commercially run industrial effluent treatment plant, which should you choose?

O.K. Here we go! On the one hand, there’s Pro; In Favor:

The principal point in support of on site landfill leachate treatment versus off site is that it is more efficient to treat leachate in a dedicated treatment plant which has been designed specifically for the high strength of a modern landfill leachate.

Your second supporting point shall be that the investment profile more closely matches a landfill business where a leachate plant built at the start can be paid for from the income (gate fee and landfill gas revenues) generated while the landfill is being actively filled. If someone else treats the leachate off site it will be on a per cubic metre treated basis for 30 to 50, or more, years. But, after the site has been closed the income drops, and soon there is only money put by for treatment to pay for it. So, it is much better to invest in the asset of a treatment plant on-site which will be in use for many years after the initial investment, so that only the running costs have to be paid for it once the landfill site closes and revenue from the landfill to pay for the leachate plant dries up.

The 3rd positive point is the owner of an on site leachate treatment plant has a much secure disposal route for their leachate than for an off site option treatment plant, because the provider of the external service can with little notice cease to accept the discharge.

A fourth big benefit is it is more efficient to treat leachate treatment in a dedicated plant optimized for the purpose, than in a sewage works or an industrial effluent plant where both are usually better suited to treating more dilute / lower strength effluents.

Lastly, the fifth point in support is going to be ((6))).

And conversely, for balance, the Con side, against:

The first point in contra for on site leachate treatment versus off site will be that site owners and environmental regulators (EA, EPA, Water Purification Board, River Management Authority) etc) are often concerned that an on site leachate treatment plant may fail and discharge polluting water into a river or stream. Although, this can be avoided with good design and training of the site staff in leachate treatment plant operation.

The second point in contra is going to be the landfill company may find it hard to finance the capital cost of an on site leachate treatment plant (although a rise in gate-fee to pay for it might be possible)

3rd point against will be there is a lack of space, which is unlikely on a large landfill.

4th point in contra will be the cost of bringing-in a power supply for the leachate treatment plant, although a supply line and electricity are usually available from the landfill gas (energy from waste) generators on site already.

Fifth and finally, last point in contra shall be a lack of landfill site forward planning to make the right decisions to save money on an on site leachate treatment plant over a long-term period.

Now both sides have been heard from and the Pros and Cons are stacked up, in favor and against.

So, who won? What could we conclude? Is on site landfill leachate treatment is more good than bad? or more bad than good?

We have a “Yes” response to both questions! on site landfill leachate treatment versus off site is a decision which will vary according to the circumstances of each landfill site, and the debate is a combination of good and bad… You, dear reader, will need to determine which side, the good or the bad, outweighs the other for your site.

The Importance of Regular Home Improvement

Home improvement, by definition, is making changes to one’s home by making improvements on the house’s looks. Home improvement is usually done by professional contractors, handymen, and even the house owner himself. Home improvement is important because real estate’s value appreciates more if a property is well-maintained. Home improvement is seen by many as unnecessary cost. However, losing value of a real estate is usually caused by neglect in a property’s maintenance. Therefore, in the long run, regular maintenance is crucial for the property’s value to appreciate.

Regular home improvement jobs and renovations will surely make your current living conditions more favorable. People do not easily notice that some areas of the house need improvement. In the long run, regular maintenance will reduce the serious structural damages to your property. It is also important to note that there are different maintenance schedules for different areas of your house. For instance, plumbing should be checked monthly. Ovens, heating systems, smoke detectors, and the like should also be checked monthly to prevent unfortunate disasters. The garden area should be maintained regularly and should undergo rigorous maintenance every four months. This is to prevent insects and termites infestation which can cause significant damage in infrastructure. The landscape of a house should also be in good appearance to help preserve your property’s value. Refrigerators should be checked every three to four months. Check for faulty or loose wiring and avoid energy overload. The roof, on the other hand, should be checked at least every six months. Check for shingles and leaks and take care of them right away. Watch out for blocked gutters as this can lead rainwater to go inside your house. If your house is made mainly of wood, have a regular termite exterminator team visit your house.

Aside from these standard areas in the house that need improvement, remodeling or renovating is also a good idea. It can also add value to real estate. Remodeling can be as simple as changing the paint color in your living room or laying a different color of carpet in your bedroom. Something this simple can make significant changes in your house’s ambience. Renovating can be as major as tearing down the common wall of two rooms to make them one big room. Tearing down walls creates a bigger space which can be used for many purposes. Additional extensions can also be done. Additional space that can be used as garage space is useful. Home improvement tasks that require massive construction should be done by professional contractors. Make a list on what you want changed inside your homes and consult with a team of contractors. This way, you will have an idea on the costs that will be incurred as well as the extent of the repairs and improvements you can do.

Home improvement is important because essentially, it is considered taking care of your home. Aside from the additional value it gives your property, preventive maintenance and remodeling is always good to decrease future damages in your property.

His Most Famous Painting (Portrait of Violette Heymann) – Odilon Redon

French Symbolist painter, printmaker, draughtsman, and pastellist Bertrand-Jean Redon or Odilon Redon (April 20, 1840 – July 06, 1916) was an eminent frontrunner of ‘Post-Impressionism’ and ‘Symbolism.’ He was only 10 when he won a drawing prize at school. Odilon began studying drawing formally at 15, but had to switch to architecture on his father’s insistence. He was back to painting, once he failed to pass the entrance for architecture, at École des Beaux-Arts, Paris. The creator of the “Portrait of Violette Heymann,” Redon, studied etching and lithography under Rodolphe Bresdin, until his artistic career again had to take a break when he joined army in the Franco-Prussian War, in 1870.

The year 1878 gained Odilon recognition, with his creations the ‘Guardian Spirit of the Waters’ and his first album of lithographs, ‘Dans le Rêve’ in 1879. In 1890s, he started using pastels and oils, which was heavily seen in his works for the rest of his life. He added a couple of etchings and lithographs catalogs to his count, later in life. Odilon’s works were hugely imaginative, which ranged right from a human headed spider to quaking ground. His popular works included ‘Spirit of the Forest’ (1880), ‘Cactus Man’ (1881), ‘The Crying Spider’ (1881), ‘The Buddha’ (1904), and the “Portrait of Violette Heymann.”

The “Portrait of Violette Heymann,” created during the last years of Redon’s life in 1910, was one an immensely imaginative work. Measuring 72 cm x 92 cm, this pastel work displays a young woman, Violette Heymann, surrounded by many, intensely colored, blooming, and somewhat unfinished flowers around. To match up with the theme ‘Violette,’ Odilon has made an ample use of violet color. Violette is shown sideways, sitting on a chair, which is supporting just her back, while her neck and head stay unsupported. She looks passive, owing to her expressionless flat face. Her dress is also quite simple without much elaboration and style. She is a wearing a white colored, high neck inner, with a greenish-blue upper having golden border. Her black hair is shoulder length and is pinned at her back.

Odilon Redon described his works as ambiguous and indefinable. He explains, “I have often, as an exercise and as sustenance, painted before an object down to the smallest accidents of its visual appearance; but the day left me sad and with an insatiate thirst. The next day I let the other source run, that of imagination, through the recollection of the forms and I was then reassured and appeased.” Reflecting his own thinking and psyche through his work, Redon tried to “place the visible at the service of the invisible.” The same ambiguity is reflected in Violette’s expression, owing to which Odilon’s this artwork always gathered mixed reactions. The “Portrait of Violette Heymann” is presently displayed at the Museum of Art at Cleveland, Ohio.

Views From Seats Around The Indianapolis Motor Speedway Track

In part 3 of this series we describe the various seating views on the outside of the south end of the Indianapolis Motor Speedway. The south end of the Brickyard covers slightly more than a mile of track and includes the Southwest Vista, the South Vista, Grandstand G and the Southeast Vista.

RESERVING YOUR SEATS: At the Brickyard 400 all seats are reserved. But if you want to reserve the same seat year after year, you must purchase your tickets from the Indianapolis Motor Speedway (IMS) directly. Getting on the renewal list requires you to not only purchase your tickets from the IMS, it also requires you to purchase your tickets each year right after the race. Once you get on the IMS ticket purchasing list you can also ask to be placed on the list to upgrade your tickets as better tickets become available.

It may take many years before you earn the right to purchase prime tickets, but if this is your goal, you better get started now. The IMS will allow you to reserve your seats for your lifetime and then they will allow you to pass your renewal rights to your children. They will not, however, allow your children to pass it down to their children.

GRANDSTAND INFORMATION: The Indianapolis Motor Speedway offers grandstands on the inside and the outside of the track. All grandstands on the inside of the track end with Terrace in its name. Grandstands on the outside of the track include Vistas, Paddock, Penthouse or a Grandstand with a letter in the name. The IMS has removed all infield grandstands in the turns. If your seating chart shows grandstands on the inside corner of the speedway, it is outdated. See the updated seating chart at the Brickyard 400 Seat Photos on this website for an updated seating chart. The following list provides detailed information about each grandstand at the speedway.

SOUTHWEST VISTA: The views from the Southwest Vista located at the end of turn 1 at the south end of the Indianapolis Motor Speedway provides a view of turn 1, the short chute and turn 2. The seating in this grandstand is bench style with no backs . There is no roof covering these grandstands. As with most other grandstands at the Brickyard, the best views are up high in the stands. You must have seats in the double letter rows in order to have a good view of the track. There is no view of the front straightaway from this grandstand. The closest parking to this grandand would be the Main Gate Lot and Lot 2.

SOUTH VISTA: Sitting on the outside of the track between turns 1 and 2 is the South Vista. This grandstand provides views of Turn 1, turn 2 and the short chute. No view of the front straightaway or the back stretch is possible from these seats. The seats are bench style with no backs. There is no roof structure covering this grandstand. The closet parking to this grandand would be Main Gate Lot and Lot 2. Double letter rows offer the best view of the track. Seating in the single letter rows have a somewhat less expansive view of the track and are partally constructed by the catch fence.

GRANDSTAND G: This grandstand sits on the outside of the track in the south short chute. The seats in this grandstand are bench style with no backs and there is no roof covering the seats. The Main Gate Lot and Lot 2 would probably be the closest parking lots. The best views are high into the grandstand. This grandstand is somewhat smaller, height wise, than the South, SW and SE Vista grandstands. From this grandstand you can see turns 1 and 2. Views from the seats in the single letter rows are more constructed by the catch fence.

SOUTHEAST VISTA: This grandstand sits in Turn 2 on the outside of the track. The seats in this section are bench style seats with no backs. There is no roof covering this grandstand. Best views of the track from this grandstand will be found in sections 17, 18, 19, and 20 high in the double letter rows. The Main Gate Lot and Lot 2 would probably be the closest designed IMS lot. Views from the single letter rows are somewhat obstructed by the catch fence.

The Many Benefits of a Retractable Cord Reel

If you’re tired of electrical power cords laying all over your home, garage, or office, it’s time you start shopping for a reliable, high-quality extension reel. While there are many types of extension reels available, among the most durable and convenient types to use are retractable reels. Outlined below are some of the most attractive benefits of retractable cord reels, and why these are highly useful for any home or office setting.

Organize electrical cords and extension wires

A retractable cords reel keeps electrical cords in place, especially when not in use. In general, it is used to wind cords, cables, and wires – especially electric cords and extension wires – in one place. There are several types of extension reels, including regular, hind wind, wall mounted, bucket, and retractable reels. There are other similar types as well. Since a retractable cord reel does the winding on its own, organizing all your cords and wires is almost effortless.

Self-stop or self lock features

Since retractable reels are self-winding it’s easy to assume that these are complicated to use. However there are features which keep the cords from winding themselves while you are using them. A self-stop mechanism automatically locks the cords in place so that you can use the wires conveniently and safely. After using the cord, one tug will send the cord winding on its own, keeping the electric wires in an easily accessible but organized place.

Ensure safety

Dangling or scattered electrical cords are a potential hazard, especially if you have small children in your home. Loose wires all over the floor may also cause stumbling accidents. A retractable electric reel that winds the cords and keeps them in place helps you ensure safety and orderliness around your home or office.

Versatile

Many retractable reels are designed to suit a variety of settings. These reels are always handy to have around the home and the office, but they may be useful in vehicles, boats, hospitals, and health care clinics as well. There are models specifically made for medical use, or those designed merely for use indoors. These retractable power cord reels may be mounted on different surfaces, from walls and floors to benches and ceilings.

Electrical cord reels can come in many different types but a retractable cord reel, such as the Coleman Cable Retractable Electrical Light/Power Cord Reel, makes keeping and winding your cords a simple and effortless task each and every time.

Studying for 1Z0-497: Oracle Database 12c: Essentials

Passing the Oracle Database 12c: Essentials exam (1Z0-497) will earn exam candidates the Oracle Database 12c Certified Implementation Specialist certification. It will also make them an OPN Certified Specialist in Oracle 12c if they are employed by a company that is part of the Oracle Partner Network (OPN). Partner companies with employees who are certified as OPN specialists gain a higher level of specialization in the OPN program. As such, this credential makes you a more attractive employee to companies that are part of the Oracle Partner Network.

The 1Z0-497 exam is a standardone test and is not part of any track. To earn the related certification requires only passing the exam. There is no required training or other pre-requisites. The 12c database will be Oracle's flagship product for several years to come and this exam will be a popular one for some time. This exam covers many of the same topics as the 12c database administrator track but does not require the same depth of knowledge. That said – it also does not provide the same level of prestige. While this certification generally would not be a direct stepping-stone to a position as a DBA, it may lead to a job with an OPN company that you can use in working towards employment as an Oracle DBA.

As with any Oracle certification exam, your first step should always be to visit the topics page on the Oracle University website. The OU topic lists are always complete and will provide you with a roadmap of exactly what you need to learn when studying for the test. The exam will never cover any material that is not in some way related to the subjects listed there. The 1Z0-497 exam has fifty-two topics broken into twelve different subject areas. The areas covered by the exam include the following:

  • Oracle Database Software
  • Administration & Configuration
  • Oracle Database 12c New Features
  • Maximum Availability Architecture
  • Backup and Recovery
  • Monitoring
  • Administering Users and Security
  • Software Installation and Maintenance
  • Oracle Data Structures
  • Oracle Database Instance Architecture
  • Oracle Multitenant Architecture
  • Oracle Network Architecture

The exam has eighty-five multiple-choice or multiple-answer questions. You will have a maximum of one-hundred and twenty minutes to answer all of the questions. The passing score is seventy percent. Oracle exams have no partial credit for multiple-answer questions, they are either right or wrong. Questions that are left unanswered are counted as incorrect. For this reason, you should always answer every question on the exam – even if that means picking an answer at random.

Available on the Oracle 12c documentation website is a 2-Day DBA manual. Reading this book would make a fairly good start in preparation for the exam. Much of the information in that book is on topics relevant to the test and the coverage level is similar to what you will be asked. The Oracle Learning Library has several interactive tutorials that go hand-in-hand with the 2-Day DBA manual that can also be useful in preparation for the exam. Candidates who know absolutely nothing about Oracle might want to read the Oracle Concepts manual first in order to get a firm grounding in the various elements that make up an Oracle database.

This exam covers a number of subject areas to a fairly shallow depth. The exam does not require candidates to have an extensive knowledge of any single objective. Once you have obtained the topics from the Oracle University website, use them as a checklist while you prepare. Focus on learning a reasonable amount of information about each topic rather than trying to become an expert on any single topic or group of topics. Only after you are comfortable that you understand them should you schedule the exam. Good luck on the test.

Magic Tricks Revealed – How to Design Your Own Magic Tricks

You know what separates a great magician like Chris Angel or David Blaine from an ordinary one? They take a basic magic effect and design it into a master illusion. Now you can be the next Chris Angel. All you need to understand is basic magic design.

Most people think that there are thousands of magic tricks out there. In reality there really are not that many. According to Dariel Fitzkee, author of The Trick Brain, there are only 19 basic effects which govern all magic tricks and illusions.

All nineteen of those basic effects rely on some form of magical apparatus. Sometimes the items are real but the majority of the time the items are tricked or faked to accomplish some magical effect.

It has been my experience that there are only three basics that govern how all 19 magical effects work. All magic tricks are made up of one or more of the following:

1. Camouflage
Every magic apparatus from the smallest to the largest illusion makes use of camouflage. This is the most important fundamental in magic. Perhaps you want to produce a big item from a box. You can use camouflage to make the box look smaller so as to suggest the big item does not fit. Maybe a piece of apparatus has a secret pocket to make things appear and disappear, camouflage can hide the secret pocket.

2) Secret Movement
You can also make things disappear or appear or even seem to come alive with a secret movement. You see an empty box, as the magician closes the door a screen on the inside drops and when the magician opens the door again, it appears a horse, bicycle, or even an elephant has appeared. Perhaps you've also seen the recently popular trick, The Floating Card. The magician spins a playing card around his body, or perhaps he floats it between his hands. The power for this comes from a small and practically invisible thread and the movement of the performers body. The whole feat loses its mystery if the audience were to suspect the actual means by which the effect is produced.

3) Mechanical Transformation
The final of the three is the mechanical design to produce a visible transformation. Perhaps you've seen a magician take a red scarf and pass it through something and it comes out blue. Sometimes a silk that changes into a cane. Torn and Restored effects also fall into this category. Perhaps you have even seen in a comedy show a clown or other performer pull out a gun and when fired a sign comes out the end that says "BANG". Tricks like Metamorphosis that are done under cover are usually governed by some sort of secret movement and are not transformations in the true sense.

By learning the three basic concepts of design, you'll be able to create and make a magical apparatus that is unique to your magic act.

New Wedding Trend: Wine and Cheese Reception

Brides are always on the lookout for interesting and stylish ideas for their weddings. One of the latest trends to come around is the wine and cheese wedding reception. Learn more about how to use this chic and affordable concept to plan your own wine and cheese wedding.

If you are not planning to have a formal laid wedding reception dinner, you need a great alternative. A wine and cheese reception could be just perfect. Everyone loves wine after all, and of course cheese (along with other foods) is always a hit. This is a fresh twist on the cocktail receptions which have been popular in recent years, and it is a terrific option for a late afternoon wedding. A wine and cheese reception is also reliably budget-friendly, as you will not need to serve a full meal, nor hire a big band.

The ideal time of day for a wine and cheese wedding reception is late afternoon. The ceremony can be held in the venue of your choosing, followed by the reception starting no later than 5pm. Alternately, you could start all of the festivals after dinner; just do not hold people captive over a meal time if you do not plan to feed them a full dinner. Let them know what to expect by saying "Please join us for wine and cheese after the ceremony", so that guests understand to make their own dinner plans.

A great space for this type of wedding reception would be a wine bar. Many have private rooms, or you may even be able to rent the whole space, particularly for an afternoon reception. No wine bar in your town? No problem; a chic restaurant, loft, or gallery space would make a terrific alternative venue. The seating should be comfortable and casual. Modern lounge spaces with low slung couches would be great. You can mix in a few tall cocktail tables with barstools as well. Be sure that you provide enough coffee tables and side tables for your guests to set down their drinks and little plates of appetizers.

The style of a wine and cheese wedding celebration will tend to be chic in a low key way. The bride would be charming in a short white lace dress with pearl custom bridal jewelry for an afternoon reception. A long slender column gown worn with custom vintage inspired bridal jewelry would be fabulous for the bride who likes a bit more drama. In either case, a handsome suit will be ideal for the groom. If you have bridesmaids, avoid the temptation to dress them identically, which is too old-fashioned for this modern wedding style. Allow each woman to select a dress in a color family, rather than asking each bridesmaid to wear the same dress.

Of course, the centerpiece of the reception will be the food. Set up stations with knowledgeable sommeliers who can inform guests about the wine selections being offered. Plan to serve a nice variety of red, white, sparkling, and dessert wines. It would be nice to set up food stations near the wine stations which feature the little bites which best complement the wine varieties. In addition to a broad selection of cheeses (soft, hard, goat, artisan, etc.), round out the food offerings with fresh fruit, bread, small hot bites like tartlets, and some tapas. Play light music in the background for ambiance, and you will have a wine and cheese wedding reception that all of your guests are sure to enjoy.