Programming Alarm Lock Trilogy Units

Using DL Windows

Using the DL Windows software is the best way to keep your Access Control system operating at peak performance. Unfortunately, sometimes working with this software is foreign to new users and may seem like a daunting task. The following, is a list of information and tips to help guide you along your way.

1. Create a shortcut on your desktop to open the DL Windows program, and double click.

2. You will be prompted for a username (default) and a password. If you have not created this information yet, just hit enter on your keyboard and you will be logged in.

3. The next step is to click on the “open” button, which is located in the top right corner.

4. This white window that extends down the right hand side, is “accounts section”

5. Select the account you wish you work with (usually your business name) and hit the (+) drop down to display the door selections.

6. If you are sending information to the lock, or receiving information from the lock (audit trail) select the door you wish to work with. If you are simply making changes to user information, then just double click any door.

7. The screen that has now opened is the screen you will use to send/receive information. If you notice, there is a button located in the bottom left on the new window that reads “send/receive,” this button is not needed at this time.

8. To make changes to users, including name, pin number, card numbers, access to specific doors, you will need to click on the “global” button located on the same bar that the “open” button was found.

9. The global screen is where you will always make changes to this information.

10. To add users, simply click a blank box in the name column (located on the left) and then switch to the middle of the window and manually type in the users first and last name, their pin number or enter their card information in the appropriate fields.

11. Once the information is entered and the blank box, located on the left hand side, has a name and pin/card information, you can grant access to this user with the numbered blocks in the right hand corner.

12. These blocks represent doors. By double clicking a white block, you will turn it green. If you double click again, the block will turn red. And if you double click one more time, it will turn back to white. The   Flying  Locksmiths recommend that you never turn any block white. Leave users either red or green.

13. Green grants the user access. Red denies access. White does not register anything, and will not show up during an audit trail, rendering it useless. AVOID WHITE BLOCKS.

14. Once you have entered all of the user names and turned them green/red, you can start grouping the users into time zones. If you are not using time zones, please go ahead and download our upload guide to load to information into the lock.

15. To create a time zone click “schedule” located in the same bar as “open” and “global”

16. This screen displays a “start time” and an “stop time” that can be changed by clicking in the box and typing your desired time of granting access and time of denying access. This timeframe will not be tied to everyone. Only the people you will set it too.

17. Once you have entered to desired times, navigate to the bottom portion of the screen and next to “event number 1” under “description” manually type the action that is going to take place during this time. This could be enable group, auto open, auto lock, etc.

18. Next, under “user or group ID”, set the group number you want to associate to this time zone. It’s recommended that you avoid group #2 to avoid complications with other setting later on. Or if you are not associating time zones to groups of people and you just wish to have the lock open and close at certain times, leave this field empty.

19. Next, under “event” click the box to bring up the drop down menu and select the action that you wish to take place during your time zone.

20. Finally, under “time zone” select the time zone you created above. Your time zone number is displayed in the top right corner of this window.

21. Once your time zone information is all set, click “Switch to Sched. View” which will save the information.

22. Close this screen and return to the global window. (If you are just working on a auto open and auto unlock than download our upload instructions and proceed.)

23. In the global window, select the people who are restricted within your newly created time zone, and and click “set group assignment” located under the prox card information.

24. Just like the door selection process, turn the white block to green for the group number you have associated with the time zone. (remembering to avoid group 2)

25. Once you have allocated your group to each individual, you are ready to send the information.

26. Click here for uploading instructions.

Add Another Lock Instructions

In DL Windows

To add another lock you existing database please follow these instructions.

1. Open the DL Windows program and click “open”

2. In the right hand pane, select the account you are adding a lock too and make sure the account name is highlighted.

3. Right click once and select “New Lock”

4. WARNING! MAKE SURE NOT TO CLICK “DELETE ACCOUNT” This will remove all information from the database and you will have to start from scratch.

5. Once you have click “New Lock” a window will open where you can enter the name of this lock (back door, front door, side, garage, etc.)

6. Under “Lock Type” select the model that is currently on your door. This information can be provided to you by calling The  Flying  Locksmiths at 1-800-649-KEYS.

7. Click “OK” and your new lock will be setup and ready to program.

Source by Brett McMenimon

Ten Tips on Formatting Your Book Manuscript

Unless you’re writing a screenplay, you don’t need fancy writing software to ensure that your book manuscript is properly formatted. As long as you abide by a few simple rules, agents and publishers won’t take one look at it and decide to find it a good, loving home in the circular file. I already gave you ten tips to help you hook an agent’s attention with a dy-no-mite query letter. Now that you’ve gotten that letter requesting your full manuscript (and finished weeping) I’ll get to the dos and the don’ts of submitting the pages. Follow my advice and any agent or editor who reads your work will judge it based on the strength of its words, not superficial–and avoidable–screw-ups. Some may seem obvious, but as a literary agent, I saw these mistakes made over and over. So they’re not obvious to everyone.

  1. Double space. That doesn’t mean 1.5 spaces. It doesn’t even mean 1.75. If your manuscript is too long and you want to lessen the page count, edit it. Don’t get tricky. Whomever you’re trying to trick won’t fall for it. And they won’t read it. Double-spaced text is easier to read and easier to edit.
  2. Page numbers. Leaving them out results from carelessness, not trickiness–unless you really think a reader won’t notice that your manuscript is 1000 pages long if you don’t number them. (It’ll still be just as heavy.) Why so important? Read on.
  3. No binding. Often more than one person at a literary agency or a publishing house will read the same manuscript, necessitating photocopying. Made difficult by staples, three-ring binders, and the dreaded spiral binding (shudder). Also, if the manuscript is bound together, Agent X can’t take home the first 50 pages to read tonight, and you will have annoyed Agent X already. Use rubber bands. That’s all. (Note: a lack of binding allows for the possibility of Agent X dropping the manuscript and watching a fan blow its pages throughout the office. Reason Tip #2 is important.)
  4. No double-sided copies. Again, makes photocopying complicated. And as in Tips #1 and #2, doing this to make your novel seem shorter won’t fly. In fact, nothing will. Most agents and publishers will ask for a word count. Also, it can affect readability, since type often shows through to the other side. And if it’s not bound, which it shouldn’t be, type on both sides can get confusing (Did I read this side yet?) The reading experience should be like a visit to the spa, not a stint on Survivor.
  5. 12-point type. This isn’t a hard-and-fast rule, since different fonts print at different sizes when set to 12-point size (am I the only one who doesn’t understand that?). Just think readability. And forgive me for my broken-recordness, but printing your manuscript in tiny type won’t fool anyone into thinking it’s shorter. It’ll only make them all squinty. Likewise, if you’ve written too few words, using 18-point Courier won’t make your characters more well-developed.
  6. Avoid shrink-wrap. I’ve never received a manuscript that’s been professionally shrink-wrapped and not thought of the writer as just a little weird. It’s annoying to have to find scissors and figure out how to un-mummify your manuscript. Two words: padded envelope. Don’t worry, it’ll be safe. A tiny tear might appear in the corner. That tear won’t keep it from getting published.
  7. Name and/or title on each page. Befriend the Header/Footer tool in Microsoft Word. Not necessary–and don’t make any header more than one line–but if a page gets adventurous and runs away to another part of the agent’s office, it’ll find its way home.
  8. Cover page. This one is necessary, and it must include your name (not only your nom de plume), mailing address, e-mail address, phone number, and, to protect yourself, a copyright date. Yes, your contact info should also be in your cover letter. But do you want an interested agent or publisher to not be able to contact you because they lost your cover letter?
  9. No pictures. Or colors. Or pictures. Your cover page should include the things mentioned in Tip #8, and only those things. Don’t ask your friend Stella, the amateur cartoonist/illustrator, to draw your protagonist. Don’t print your title in hot pink. Anything that isn’t a word is a distraction and will look amateurish.
  10. Return postage. Want your manuscript back? Fine. Want the agency to package it up and pay for the postage? Not gonna happen. And don’t assume it’s because they’re cheap bastards. Many agencies are very small operations, and they read a lot of manuscripts every week. Paying to send them all back would significantly impact their budgets. If you want it returned, enclose a padded envelope with stamps on it. (Don’t use a postage machine; they aren’t always accepted at a later date or in a different zip code.) Calling two weeks after you receive a rejection letter will prove less than fruitful: your manuscript will already have been recycled to make room for the next one.

Writing has no rules that can’t be broken if you’re good enough. But the presentation of your manuscript is about business, not writing, so don’t break these rules, no matter how beautiful your spiral binding (shudder again). Note, though, that fancy-schmancy formatting software may be worthwhile for other forms of writing, such as screenplays, the proper formatting of which can lead to insanity.

Source by Lisa Silverman

Compare DCC Systems Before Choosing Digital Command Control For Your Trains

A DCC controller system will create a major advantage for your model train system. Not only will you be able to control it with electricity, you will have complete control of the entire system, which is very impressive when you are dealing with model trains. Honestly, you can have a basic train set that goes around the track and occasionally switches tracks, but when you have a Digital Command Control system, you can make your scene really come to life!

You can actually create your own programs, and cause the trains to move realistically. This is great for train shows and public displays, and is a model train operator’s dream. There are a few different systems out there, some of them better than others, but since many people are just starting out with their DCC systems, so let’s do a DCC controller comparison, starting with the lowest end system out there.

Atlas Commander: For those who are novices in DCC operation, this will work great. Featuring eight function keys, this device can deal with seven cabs. You cannot program on the fly however, which will disappoint some people. Again though, this is for beginners and those who do not want to deal with a highly complicated system.

Zephyr: This is also a popular system, and quality is just what you will find in all Digitrax DCC decoders. It has two jump ports that allow DC power packs to be connected, which is something that many other DCC decoders lack. If you wish to use a computer, then you can connect it using LocoNet in conjunction with Locobuffer II.

Prodigy: The NCE Lite has a rating of 3.5 amps and has the ability to connect to another cab bus. Right now though you will only find one handheld controller for it. Luckily the system does have a cooling fan, unlike some. So let’s face it, we like building things, but needing to build a cooling fan for DCC is just irritating. This device comes with 19 functions keys.

To add to the realism it helps to have a DCC sound system. There are a few different types, some of which can include realistic sounds, and of course the standard train horn. Many of the sounds are recordings of trains in the real world, or even museum bound locomotives from ages past. If you are building a historical scene, there’s nothing better than having sounds reminiscent on a 1900’s locomotive barreling through town. Mind you if you are recreating a mid twentieth century setting, you may not have sound at all because citizens in Florida deemed the train horn to be a nuisance and without purpose. That however, is another story for another day, and an amusing one at that.

These are a few DCC systems available including Atlas Commander, Lenz systems, NCE Power Pro, Digitrax DCC systems, and you no doubt find one that suits your needs. Just remember to shop within your experience level, and of course keep your power requirements in mind. You can always upgrade later!

Source by Mike S Williams

Fire Hydrants & Home Water Damage – Home Safety

I was amazed to see what kind of damage a fire hydrant could do to a house, when broken. It was like spraying hundreds of garden hoses on the roof of a house and watching the water cascade off like a powerful waterfall. I was simply amazed and still can’t believe the damage I witnessed as the fire hydrant covered the entire house with water.

I might be getting a little carried away here but as a building contractor, I have seen the water damage a small leak, over a few years, concentrated on just one single part of the home can have. This fire hydrant broke in between two houses and was approximately 30 feet away from each home and was covering one of them with a blanket of water, while the other one looked like it was raining on the roof.

How can one home receive so much damage and the one next to it, located the same distance receive very little. I won’t ever be able to figure that one out.

There was a small car in the driveway and it was getting pummeled by water. There’s no way that this car couldn’t have been damaged on the inside, with the amount of water that was flowing over it. Now the damage to the home was a different story. It almost looked like a little Barbie house with a fake car in the driveway and someone spraying water directly over the home.

There was no way that anyone could come in and out of the home without getting physically hurt from the large amounts of water that were flying in every direction. Looking back at the water damage I’ve repaired over the years and watching this fire hydrant terrorized this house and everything in it, makes me a firm believer in the power of water.

The fire hydrant was broken because a car ran into it. Most fire hydrants have a ring that is known as a breakaway ring, just in case someone was to run into it with a vehicle. The ring can be replaced a lot easier than the pipes beneath it, if they were to become damaged. Whoever came up with this design has saved an ungodly amount of money over the years from accidents like this.

Hard to imagine the damage the fire hydrant can do to a home.

Source by Greg Vandenberge

Exercise Bikes – No Excuses, 30 Minutes A Day On A Bike Will Change Your Life

Exercise bikes are the ideal home exercise equipment. We are all advised to exercise for 30 minutes per day to stay healthy combined with a good balanced food intake. Most people complain of not having the time to go to the gym or prepare to out jogging etc but if it was for 30 minutes of TV I’d bet that time would be no problem. Why not combine the two, TV and exercise. Watching TV while exercising cuts out the boredom of being locked in a room looking at the four walls exercising. If you have a program you watch on a regular basis the time will only fly in.

What exercise bike will I buy?

Exercise bikes come in all wonderful styles from the basic stationary bike to built in programs for spinning and mountain courses. The best is what you can afford to pay, the main thing is that you are exercising regularly or intend to do so. The more basic exercise bike can cost anywhere from $80 upwards and generally has a few different gears available to make the exercise more intense as you proceed with fitness. I have to say if you can afford to spend $200 you will find exercise bikes that have pre tuned exercise programs that are easy to follow and are a great way to burn fat.

How to Start:

Starting can be daunting but after a week or so you will find your fitness level improving and overall health. You need to introduce the body into the exercise for the first couple of days, for many people buying exercise bikes it’s the first time they have done such an exercise in years. The first few days should be a slow introductory pace, if you go all out in the first day or so you will only end up with aching muscles and may even put you off exercising again. Remember that this is a marathon not a sprint.

Who are the main manufacturers of exercise bikes?

Weslo, Reebok,Tuntui, Stamina, Proform, Nordic Track and Fitnees Track have for many years manufactured some of the greatest exercise bikes we have ever seen and all are still doing so. There are foldable bikes available for those living in apartments or people who are simply tied for space. Many people are now trying to build a home gym with the essentials in exercise equipment; the exercise bike should be first on the shopping list. The exercise itself is an excellent aerobic exercise, easy to start with and works ideally as a cross trainer with most other fitness equipment.

Some exercise bikes have a dual function, exercise for the upper and lower body. Apart from the obvious leg exercise you will also find upper body levers on some, this is an ideal exercise for a total body workout and will burn fat more quickly than the standard exercise bike (the more muscle groups you exercise the more fat your burn and more quickly).

Why buy an exercise bike when I can get a treadmill?

The exercise bike has very low impact on the joints. If you have previous injuries or weak joints in general the exercise bike is an ideal gentle exercise. The treadmill is a much higher impacting exercise on the joints and people with weak knees or ankles should be aware. If you decide to get an exercise bike with dual exercise (upper and lower body) you will burn more fat than that of the treadmill as you have no upper body resistance with the treadmill. There are arguments on both sides of the fence as to what is better the bike or the treadmill but you should look at your goals and see what suits both your budget and your target weight loss or general fitness. At the moment the cardio benefits to you as the user lies greater with the exercise dual function bike to that of the treadmill.

In Brief:

The exercise bike is ideal for beginners to the more advanced groups; it offers a low impact, high calorie burning exercise that have an excellent cardio workout. Combined with a balanced diet the exercise bike used regularly will help you achieve your fitness goals.

Source by Declan Tobin

Alaska- The Call of the Wild

Alaska Facts

Land area: Alaska encompasses 586,412 square miles, which is about 365,000,000 acres, Alaska is the largest state in the union and; one-fifth the size of the lower 48 states.

Largest Parks: Alaska’s unique beauty and vast wilderness areas are among its greatest treasures. More than half the nation’s parklands are found here, located in every geographic area of the state.

Diameter: East to west, 2,400 miles; north to south, 1,420 miles.

Coastline: 6,640 miles, point to point; as measured on the most detailed maps available, including islands, Alaska has 33,904 miles of shoreline. Estimated tidal shoreline, including islands, inlets and shoreline to head of tidewater, is 47,300 miles.

Adjacent salt water: North Pacific Ocean, Bering Sea, Chukchi Sea, Arctic Ocean.

Tallest mountain: Mount McKinley, at 20,320 feet, is the tallest mountain in North America. Alaska has 39 mountain ranges.

Most populated City: Anchorage is less than 300,000. Over half of the states population lives here.

What Alaska has to offer

Alaska has some of the most incredible scenery to be found in the United States. In order to enjoy all Alaska has to offer, visitors must get out and experience it for themselves.


Of the 20 highest peaks in the United States, 17 are in Alaska. Mt. McKinley, the highest peak in North America, is 20,320 ft. above sea level. Denali, the Indian name for the peak, means “The Great One.”


Alaska has an estimated 100,000 glaciers, ranging from tiny cirque glaciers to huge valley glaciers. There are more active glaciers and ice fields in Alaska than in the rest of the inhabited world.


Alaska has 6,640 miles of coastline and, including islands, has 33,904 miles of shoreline.


In these magnificent settings, Alaska offers superb wildlife viewing opportunities. Moose, wolves, Bald eagles, caribou, and bears, driven away from other lands by the crush of modern development, roam wild and free.

Alaska is Bear country!

There are three types of bears found in Alaska: the black bear, brown/grizzly bear and polar bear. Alaska’s coastal brown/grizzly bear is the world’s largest carnivorous land mammal.

Alaska Guide to Alaska Activities & Alaska Tours


Alaska has much to offer from the Arctic of the north to the Rain Forest of the southeast. Alaska visitors have a multitude of Alaska activities to choose from. Your Alaska tour can be as exciting as you want to make it. Some of the most popular Alaska activities are listed below.

  Fly  fishing, Hiking, Camping, Alaska Cruises, Wildlife Viewing, Brown Bear Viewing, Snow Machining, Dog Sledding, Bird Watching, Hunting, Glacier Tours, Skiing, Flight Seeing, Canoeing & Kayaking and relaxing at rustic lodges, Alaska Railroad tours, Iditarod Dog Sledding tours, Viewing the Northern Lights (Aurora Borealis), or taking an Alaska cruise are the favorites among Alaskan Tourists.

Accommodations range from bed and breakfasts to rustic lodges to cabins, to luxury hotels in downtown Anchorage.

Fishing is one of the top if not the most favorite Alaska Tour. In Alaska,  fly  fishing is the norm. Alaska salmon fishing, and Alaska halibut fishing are the most popular among anglers. Fishing lodges abound throughout Alaska.

Hunting is another top Alaska Activity. Moose hunting, bear hunting, & caribou hunting are favorites. Like Fishing lodges, Hunting lodges also abound throughout Alaska.

Places of Interest

Anchorage, Fairbanks, Juneau, Kenai Fjords, Prince William Sound, Homer, Sitka, Kotzebue, Cordova, Dillingham, Valdez, Seward, Whittier, Kenai, Homer, Barrow, Ketchikan, Kodiak Island, Skagway, Barrow, Palmer & Wasilla in the Matanuska Susitna Valley (Mat-Su Valley), State Parks and National Parks such as Mt. McKinley otherwise known as Denali national park which encompasses breathtaking tundra views.

Ways to get to Alaska

Airline travel is one of the most inexpensive ways to reach Alaska. Alaska Airlines has flights throughout the U.S. The Alaska Highway often referred to as the “Alcan Highway” or simply the “Alcan” is another popular method of getting to Alaska. The Alaska Highway provides a great Alaska tour in itself. Opportunities for wildlife viewing abound. If you plan on driving the Alaska Highway, make sure to pick up a copy of the Alaska Milepost magazine. The Milepost offers a comprehensive guide on driving the Alcan. The Marine Highway, otherwise known as the Alaska Inside Passage provides a relaxing Alaska Cruise. There are many cruise ship providers such as Princess Cruises that also provide transportation to Alaska.

I have attempted to put together an online Alaskan vacation planner. The goal of this site is to provide you with the tools to plan your vacation yourself.

Source by Roger Sanders

Internet Marketing – How to Make Your First $100 Online

A recent Internet marketing questionnaire that surveyed 300 people showed some damning statistics. Among a fairly comprehensive list of questions was this: How much money are you making per month in your online business? The result was astounding…

A whopping 79.84% of the people who replied said they make less than $250.00 per month. And although I don’t have the breakdown of that I would envisage that a large percentage of that 79.84% have made nothing at all. Why?

Surely there are enough resources. In fact, there are far too many resources and most people seeking to make money online succumb to the dreaded information overload. Have you felt that yourself?

On top of that what can you believe? Even more importantly WHO can you believe? Who can you trust to tell you the truth? There are so many people professing to know all sorts of things about making money online when in actual fact they are complete virgins to the process themselves. Even worse are those scurrilous people who sell absolute garbage that promises the world but will only deliver an atlas.

Have you ever been tempted to buy a product that promises you things like the following:

  • Just spend 37 minutes a day

  • Three clicks and you will start making money on complete auto pilot
  • Copy and paste this code to see the money come flying into your account

Let me ask you this – have you ever fallen for one of those con jobs? Did it work? Have you ever known ANYBODY who has been able to make one of those so-called products work? I didn’t think so.

Seriously, look at the claims that some of these marketers are making. They are ludicrous. What are they appealing to? I’ll tell you – they are trying to convince people that they can make thousands of dollars for very little work and time spent.

The big name players on the Internet make it all sound so easy – and to them, it IS easy. Why? Because they have been online for years and years and they have the experience and the contacts (affiliate army) to make a lot of money on demand. Sadly, a lot of their products are very dubious but they can get away with it because they have the “name.”

Let me tell you this, there is a process to making money on the internet. You need two things:

1 – a determined attitude (ie a willingness not to give up) and

2 – a proper step-by-step process that actually works.

And when you make your first $100 you will know how to do it over and over again.

Source by Gary Simpson

Be Still, and Know That I Am God

God communicates with each of us in small ways from our waking moments each and every day; in fact, God is communicating to us before that, through our dreams if we will listen.


One of my reminders of late has been, “YOUR PANTS ARE GETTING UNCOMFORTABLE AROUND YOUR WAIST, STEVE.” “ARE YOU LOOKING AFTER THE BODY I HAVE GIVEN YOU?” I often respond, at this time of year, “It’s winter time; it’s time to sit and be lazy.”

All of this talk – this constant conversation with God – occurs almost unconsciously.

I can pretend that this conversation with God isn’t happening, as we all tend to do, but it won’t change my reality. My reality is my truth, and it does me no good at all to ignore it. I wake up with a certain sensation inside my stomach; it is not hunger – it is worse than hunger. My stomach stills feel full. Did I eat too much last night? Most of the time I don’t even get to ask such questions of myself. Most of the time such questions   fly  under the radar.

The still, small voice of God, in my everyday, is communicating to me through my mind – through my anxiety – through the things I am refusing to grapple with. A lot of these things are unconscious to me, most of the time, because I have repressed the still, small voice of God. This is what we do: repress God.

If I do nothing with these things, God will continue to communicate, but his voice will appear more silent and hardly audible at all.

I know that God has referred me to this quote, and it has many meanings:

“They who reach down into the depths of life where, in the stillness, the voice of God is heard, have the stabilizing power which carries them poised and serene through the hurricane of difficulties.”

~Spencer W. Kimball

One meaning it has in this context is really quite simple.

The depths of my life, at the mind level, are simple indeed. Cream is bad for me, whilst water is good. When I eat less I feel better. When I keep my mind free, as far as my responsibilities allow, I am more able to hear and appreciate the beauty in the still, small voice of God. When I exercise, or do some things, by activating my body, I feel a little better about myself.

The things of God are really so simple, but we miss them, most times, because our lives are so hurried and big with busyness.

That ancient phrase – “BE STILL, AND KNOW THAT I AM GOD” – resounds within us. Can we hear it, and, do we listen? It is about peace; but so much more than peace. God is not only seeking to communicate with us, he does communicate with us – but mostly in the tiniest of ways. If we master the art of listening we master our lives. It is up to us. Each day, each moment, is a fresh opportunity.

© 2012 S. J. Wickham.

Source by Steve Wickham

How Is Microsoft Office Used in Investment Banks


New graduates, seeking exciting high flying jobs in the city, often don’t know what to expect once they arrive in the slick new glass towers in the sky. University IT courses are often too bland to be of any use, or too specialist for the entry level roles that they begin with. For example, back in the day, my Microsoft Office training from academia included writing mock letters in Microsoft Word and generating double-order bookkeeping spreadsheets in Microsoft Excel. I did also study ER databases, but was taught Oracle rather than Microsoft Access.

Duties for entry level graduate positions will also be extremely varied, often involving Perl for parsing log files, Bash Scripting for automated tasks and a healthy dose of what is known a Spreadsheet Jockeying.

This article shall provide readers with some concrete examples of what graduates have had to perform in the early days of their careers. The year may be 2010, but new hires will still have to do the donkey work, as it’s always the monkeys at the bottom who have to do the boring stuff. Learning from their experiences should help future graduates prepare for their new jobs, making their first days a little easier, and gaining an edge over the competition. If you can produce a fancy PowerPoint presentation while your peers are struggling with the documentation, you’ll shine like a star already be one step ahead.


Report Generating

Mr N was the new boy at a bulge bracket bank a few years ago. He was placed in an IT Infrastructure Reporting team, and his job basically involved collecting data, tidying it up, and then aggregating it into a Powerpoint report.

Going into more details:

  • He copied a lot of data from website based reports into Microsoft Excel

    If you only want to paste the values, and none of the formatting information, you need to use the Paste Special option, and paste as text. To get there the fast way, enter the keyboard sequence Alt, E, S.

    If you can’t do sums on numbers that you’ve pasted, they are probably being stored as text. Try using the TRIM() function on them.
    He copied a lot of charts from Excel into Powerpoint

    To copy a chart as an images, you may need to use Paste Special again, in order to paste the charts as images rather than chart objects. This is because chart objects sometimes look a bit strange when printed.

  • He parsed a lot of text data in Excel VBA

    Data came from a variety of sources. Some is in the form of formatted text. To parse this, he had to use the regular expression functions in VBA.

    He made good use of Pivot Tables, VLOOKUP and HLOOKUP

  • He had to condense a lot of data into pretty tables. This was done with liberal use of Pivot Tables, and the vlookup and hlookup functions. So make sure you know how to use these well!

Model Analysis

Mr M was an entry level analyst at a hedge fund. Unfortunately, he was not supervised properly, and was told to do some model analysis in Microsoft Excel. While this is possible, and leads to easier visualisation, it does not tend to scale well and large spreadsheets are inherently unstable. For example, if you are trying to analyse inefficiencies in a 30 stock portfolio, modifying your spreadsheet to analyse a 50 stock portfolio might not be too easy.

Anyway, in order to do this work, Mr M needed to make good use pivot tables, vlookup functions (to line up the dates from multiple time series) and some Excel VBA. The VBA was for looping through parameters in the model. Computer scientists will know that this solution is sub optimal, but new boys are there to do what they’re told, not rock the IT boat.

Skills Required

To summarise, a fairly broad range Microsoft Office skills will be required by the new boys and girls in the city. If you are one of them, make sure you can:

– Copy and paste

Make sure you can do unformatted text, numbers, charts and images

– Manipulate data into tables with Pivot Tables, Vlookup and Hlookup.

– Use Visual Basic for Applications (VBA)


If you are one of the lucky few to get a job during this nasty recession, remember to be well prepared, but to not take things too seriously. Hopefully this article will help you to prepare for the IT side of things, but it’s only drawn from a small sample size, and the tasks that you’ll be set will be both varied and challenging.

If you don’t have the latest version of Microsoft Office 2010, please note that large organisations often run a few versions behind. This is because upgrading many computers is a slow process. And the IT support staff like to wait for a few service patches to ensure stability.

Source by Imran Patel

Controlling Pest Insects and Bugs – Natural Home Remedies

Are you looking for safe natural ways for controlling pest Insects and bugs? The truth of the matter is that in some cases you can avoid spending a lot of money on exterminators and other less desirable options to get rid of insects. You have more then a few choices when it comes to completely natural pest and insect control solutions. You may also be further pleased to know that you may just have the necessary ingredients ALREADY in your house! This article will focus on safe natural ways for controlling pest Insects and bugs.

Controlling Insects Inside

Tip #1

Vinegar is a household item that can be put to good use when it comes to getting rid of insects. We often use it to get rid of pesky fruit flies. This one is real easy to do too. Find an old jar and fill it up about halfway with apple cider vinegar. With the top off punch a few holes in it and then screw it back on. This quick to make contraption will trap the fruit flies inside.

Tip #2

Lets continue using ingredients you already have in the home. If you have pets then you already know that cat and dog food tend to attract ants and other crawly creatures. To prevent this you can create a baking soda border around the pet’s food dish. And of course the baking soda won’t be harmful to your pets.

Insect Control in the Garden

Tip #3

You can use readily available aluminum foil to keep slugs and other insects away from your garden. All you have to do is mix in thin strips of the foil with your garden mulch. This also serves to give your plants some more sunlight since the foil reflects sunlight.

Tip #4

It’s an amazing fact but were you aware that onions also serve as a natural pesticide? Probably not huh? Well here is a quick all natural mix you can create to use as a natural pesticide with the following steps:

1) Using a blender. In one quart of water puree 2 tablespoons of cayenne pepper, 2 cloves of garlic and 4 onions.

2) Dilute soap flakes. In 2 gallons of water dilute 2 tablespoon of soap flakes.

3) Pour all of this back into your blender and make sure it is mixed well.

These three steps will allow you to create a very environment friendly spray you can use like a pesticide for controlling pest Insects and bugs. So don’t just sit around hoping they leave or spend all of your money trying to make them leave. Use the information that was presented here to get it done safely. If all else fails a helpful compromise is to use a termidor termite treatment [] solution. In any case you need to act if you think their is an issue.

Source by James R