The Importance Of Excel In The Workplace

Excel is perhaps the most important computer software program used in the workplace today. That’s why so many workers and prospective employees are required to learn Excel in order to enter or remain in the workplace.

From the viewpoint of the employer, particularly those in the field of information systems, the use of Excel as an end-user computing tool is essential. Not only are many business professionals using Excel to perform everyday functional tasks in the workplace, an increasing number of employers rely on Excel for decision support.

In general, Excel dominates the spreadsheet product industry with a market share estimated at 90 percent. Excel 2007 has the capacity for spreadsheets of up to a million rows by 16,000 columns, enabling the user to import and work with massive amounts of data and achieve faster calculation performance than ever before.

Outside the workplace, Excel is in broad use for everyday problem solving.

Let’s say you have a home office. You can use Excel to calculate sales tax on a purchase, calculate the cost of a trip by car, create a temperature converter, calculate the price of pizza per square inch and do analysis of inputted data. You can track your debt, income and assets, determine your debt to income ratio, calculate your net worth, and use this information to prepare for the process of applying for a mortgage on a new house. The personal uses for Excel are almost as endless as the business uses for this software – and an Excel tutorial delves into the practical uses of the program for personal and business use.

The use of spreadsheets on computers is not new. Spreadsheets, in electronic form, have been in existence since before the introduction of the personal computer. Forerunners to Excel and Lotus 1-2-3 were packages such as VisiCalc, developed and modeled on the accountant’s financial ledger. Since 1987, spreadsheet programs have been impacting the business world. Along the way, computerized spreadsheets have become a pervasive and increasingly effective tool for comparative data analysis throughout the world.

Today, end users employ Excel to create and modify spreadsheets as well as to author web pages with links and complex formatting specifications. They create macros and scripts. While some of these programs are small, one-shot calculations, many are much more critical and affect significant financial decisions and business transactions.

Widely used by businesses, service agencies, volunteer groups, private sector organizations, scientists, students, educators, trainers, researchers, journalists, accountants and others, Microsoft Excel has become a staple of end users and business professionals.

The beauty of Excel is that it can be used as a receiver of workplace or business data, or as a calculator, a decision support tool, a data converter or even a display spreadsheet for information interpretation. Excel can create a chart or graph, operate in conjunction with Mail Merge functions, import data from the Internet, create a concept map and sequentially rank information by importance.

Excel offers new data analysis and visualization tools that assist in analyzing information, spotting trends and accessing information more easily than in the past. Using conditional formatting with rich data display schemes, you can evaluate and illustrate important trends and highlight exceptions with colored gradients, data bars and icons.

Indeed, Excel can be customized to perform such a wide variety of functions that many businesses can’t operate without it. Excel training has become mandatory in many workplaces; in fact, computer software training is a must for any workplace trying to keep up with the times.

Let’s say you’re an employer with 97 workers, 17 of whom called in sick today, and you want to know the percentage represented by absentees. Excel can do that. You can learn Excel and use it to determine the ratio of male to female employees, the percentage of minorities on the payroll, and the ranking of each worker by compensation package amount, including the percentages of that package according to pay and benefits. You can use Excel to keep track of production by department, information that may assist you in future development plans. You can create additional spreadsheets to track data on vendors and customers while maintaining an ongoing inventory of product stock.

Let’s say you want to know your business production versus cost. You don’t have to be a math wiz – you just have to learn Excel. Excel allows you to input all of the data, analyze it, sort it according to your customized format, and display the results with color, shading, backgrounds, icons and other gimmicks that offer time-saving assistance in later locating precisely the information desired. If this spreadsheet is for presentation purposes, Excel helps you put it together in such a visually appealing way that the data may seem to pop and sparkle.

The single most important thing an employer may do is learn Excel – it is one of the most essential tools of the workplace.

Excel and Microsoft are trademarks of Microsoft Corporation, registered in the U.S. and other countries. Lotus is a registered trademark of International Business Machines Corporation in the U.S. and/or other countries.

Posted in general | Comments Off on The Importance Of Excel In The Workplace

How To Spot a Fake Jimmy Choo Handbag

  • Label: The Jimmy Choo label is generally a lilac colored metal face fastened to a leather backing, and stitched to the interior of the handbag. Many fakes have the incorrect shade of lilac, either going to light or too dark in the purple spectrum. The label should read in either gold or silver. However, even if the colors are correct, the label may still not be in the clear. Because it often times the font details that are singular to authentic Jimmy Choo that many of fake handbags get wrong, and this is one of the best places to look when trying to identify a phony J. Choo.
  • Font: Always check out the "H" in Choo. On an authentic handbag, the horizontal cross-bar in the H should not be in the center of the letter, the way it is intended to be with regards to most standard fonts. Instead, the Jimmy Choo H should have the cross-bar closer to the top, about 75-80% of the way up the H, if measuring from the bottom of the letter. If the handbag has the correct H, move to the letters "O" in Choo. On an authentic handbag, the O will have a slightly bent look. This means that the "O" will appear as if someone snapped down on the top of the letter, giving the O an oval shape rather than a perfect circle. Spotting a fake Jimmy Choo handbag often times comes down to the subtleties in the font.
  • Hardware: Any screws located on handbag hardware will always be a flat head (-) screw. Jimmy Choo will never use any Philips head (+) screws in any of their handbags.
  • Dustbag: Fake Jimmy Choo handbags will often be accompanied by a dustbag that is an incorrect color or format. An authentic dustbag should have the logo: "JIMMY CHOO," with "LONDON" centered perfectly under the logo. The font should be an embossed gray, while the dustbag itself will be the famous lilac color. Many fakes will have incorrect font colors on the dustbag, as well as the incorrect dustbag color ie the wrong shades of purple etc. Good luck and safe shopping!
Posted in general | Comments Off on How To Spot a Fake Jimmy Choo Handbag

How to Change the MPI Node Address For a Siemens S7-300 PLC

I have seven Siemens S7-300 PLCs connected together using the MPI (Multi Point Interface) interface. The Siemens MPI protocol is used by Siemens PLCs to communicate with external devices. I want to rename each of the seven PLCs. Here are the steps to accomplish that task.

First, connect your MPI cable to the first PLC. I will be connecting my laptop to each PLC individually. Power up the PLC and open Simatic Manager. The "New Project" Wizard window will open. Just click Cancel to close the window. Now click the Accessible Nodes icon on the toolbar. A window will open showing the identification of the PLC you are connected to. My window is showing MPI = 2 (directly). Make a note of this address and close the window.

Next we need to download a hardware configuration to the PLC. This is where we will rename the PLC node address. There are probably a couple of different ways to do this – following is how I accomplish this. All seven of my PLCs are the same model; Therefore, I am using the same hardware configuration. For the obvious reasons, I want to give each a different MPI node address. I have a project file that contains all seven of my PLC programs and one hardware configuration file. I open the one hardware configuration file, and then double click Hardware in the right hand window. This will open the HW Configuration window. In this window you should see your PLC with its MPI address given.

Remember when we clicked the Accessible Nodes icon and saw MPI = 2 (directly)? My Hardware Configuration Window is showing a MPI address of 7. Place your mouse cursor on the 7 and double click. Your CPU Properties window will open. It should open to the General tab. Look down and you will see Interface Type MPI with an address of 7. Click Properties and the MPI interface Properties window will open. Using the pull down menu, choose your MPI node address and make sure the MPI (1) 187.5kbps is highlighted and click OK. You are now back on the CPU Properties window where you will see your address has changed. Click OK and you will go back to the Hard Ware window where you can verify your MPI node address has changed.

You will now click the Save and Compile icon and then click the download icon. The Select Target Module window will open. Click OK and the Select Node Address window will open. Here you will see the MPI node address you assigned earlier. You will need to click the View button right below this. You will see the current node address appear, this should be the same as what you saw earlier when you clicked the Accessible Nodes icon. Simply click on this number and you will see it appear in the MPI address slot under the Enter connection to target station. Click OK and the Download to Module window will open. Click OK and the Stop Target Modules window will open. Click OK and the "Do you want to start the module?" Window will open. Click Yes.

Now go back to the SIMATIC Manager window and click the accessible nodes icon. You will see your new MPI node address. You can see this same article with pictures at http://www.morerobototics.com .

Posted in general | Comments Off on How to Change the MPI Node Address For a Siemens S7-300 PLC

The 4 Elements That Makes Up A Personal Computer System

There are 4 elements that make up a personal computer system: the user, software, hardware and the electricity all working together for the whole system. Each of these elements is essential to the system itself.

The user is the person's who perform the task using the computer system. The nature of the task depends upon the application program or software that is needed to perform the task. The software that the user used requires certain hardware components to function properly.

The hardwares of the personal computer system are made up of its equipment that are usually connected (the computer, monitor, printer and so on). It is defined as hardwares because you can physically touch these components. The programs are called softwares since their function can only be used when the computer is turn ON. Software is a set of coded instructions that the computer uses in order to carry out the user's tasks.

The user can only use the computer when it is turned ON. Without any electrical power to run through the personal computer system, it will not function. The ability of the personal computer system to control its components is through a series of on / off signals.

Here is how it works, when a user tries to type a document or a letter using his / her personal computer. The first thing the user do is to turn ON the power for the computer. Choosing a Word Processor software in order to write the document. The user uses the hardware such as the keyboard to write the content of the document; The typed document is then displayed onto the monitor screen. After the user finished writing his / her document. The user will use the software to instruct the printer to print the document. The software works together with the hardware components (the keyboard, monitor and printer) to accomplish the task that the user requested.

All of the four elements: the electrical power, hardware, software and the user work together to make up a personal computer system.

Posted in general | Comments Off on The 4 Elements That Makes Up A Personal Computer System

How to Watch Satellite TV Online Without Any Satellite Dish

Anyone can watch satellite TV online without any satellite dish system nowdays. In case you do not know, this article would show you one time-tested and another new revolutionary way to watch satellite TV on the internet without having to set up a satellite dish.

Many of the older generation grew up in an era of satellite dishes, especially for those who live in the rural areas where cable do not exist. The dishes are transmitters and together with receivers are conduits for TV signals to be displayed as visual images and pictures on our TV screens. However, they are not always pleasant. Set up can be tough and definitely not for those who are not good with their hands or have poor technical skills. Satellite dishes have grown smaller in recent years but they used to be larger than 6 foot monsters in earlier days. If that irks you, you would be relieved to know that you can watch satellite TV online just like many others without satellite dish system.

What are the hardware and PC requirements you need to set up your 'satellite-dish less' PC satellite online TV?

1. A Good PCTV Card

A PCTV card can be installed onto your computer to make your computer work like a satellite television set. Such cards come in the form of internal or external hardware. If you are familiar with the inside of a computer, then an internal card could be a good choice since they tend to be cheaper and more affordable. However, do not bother yourself when you find it too troublesome to fix it internally because there are external cards that work more like plug-and-play gadgets. They cost more and can set you back easily by a few hundreds. As long as your PC has a spare USB port, this option to watch satellite TV online is open to you.

2. PC Requirements

I would suggest you check your systems configuration before you start shopping for a PCTV card. Most cards require a minimum Pentium 3 333MHz system to run well but remember to note down the specifications like RAM, hard disk space, Operating System, etc before you head to the stores.

3. Ready Internet Connection

PCTV cards work well with both dial-up and broadband connections. However, I have a word of advice here. Dial-up transmission runs like a snail and is a really serious party spoiler. You can end up more frustrated than glad that you are watching the program. Go for broadband connection if you can afford to.

Okay, now that we have discussed about the older commonly accepted method to watch satellite TV online, we will look at another new revolutionary technique. This requires the usage of PC satellite TV software which can be downloaded easily. The setup is simple and all it takes is downloading the software and clicking a few buttons before you are ready to watch satellite TV online from more than 3000 channels. Awesome is not it?

For more information on this PC satellite TV software, do a read up at my satellite TV blog.

This article may be freely reprinted or distributed in its entity in any ezine, newsletter, blog or website. The author's name, bio and website links must remain intact and be included with every reproduction.

Posted in general | Comments Off on How to Watch Satellite TV Online Without Any Satellite Dish

Corel DRAW – Best Desktop Publishing Software

Corel DRAW is a supreme supplier of graphics software, including the popular Corel DRAW program. Corel DRAW has tools that allow the user to both create and edit images. The type of desktop publishing tools that you use will depend on the type of project. For more information and assistance, use the Corel website.

Corel DRAW is the best Desktop publishing software that empowers users to create illustrations containing graphics, text and photographs. Corel has an extensive range of tools which enable the user to edit any shape or character with ease and precision, fit text to curves and create custom color separations. It is developed and marketed by Corporation of Ottawa. This tool can open files: Adobe PageMaker, Microsoft Publisher and Word, and other programs can print documents to Adobe PDF using the Writer printer driver, which such software can then open and edit every aspect of the original layout and design.

Several innovations to vector-based illustration originated with Corel: a node-edit tool that operates differently on different objects, fit text-to-path, stroke-before-fill, quick fill/stroke color selection palettes, perspective projections, mesh fills and complex gradient fills.

One of this software’s many strengths is the huge range of over 1,000 fonts that it comes with, provided in both TrueType and Postscript Type 1 format. Corel differentiates itself from its opponent in a number of ways: The first is its positioning as a graphics suite, rather than just a vector graphics program. A full range of editing tools allow the user to adjust contrast, color balance, change the format from RGB to CMYK, add special effects such as vignettes and special borders to bitmaps. Bitmaps can also be edited more extensively using Corel PhotoPaint, opening the bitmap directly from Corel and returning to the program after saving. It also allows a laser to cut out any drawings.

Expert believed it was the first of the Windows-based drawing programs and has built on this early start to become far-and-away the dominant drawing package on the PC. Its biggest strength – and its biggest potential limitation – is its all-encompassing approach. In the past this has led to accusations of unfocused bloating, but with version 7.0 Corel has addressed the criticisms with a far tighter and better rationalized program. Even so, there’s a huge range of functionality to cover.

Corel DRAW Download was originally developed for Microsoft Windows and currently runs on Windows XP, Windows Vista, and Windows 7. The current version, X5, was released on 23 February 2010.

Posted in general | Comments Off on Corel DRAW – Best Desktop Publishing Software

Schedule Slippage – Root Causes

“The single most important task of a project: setting realistic expectations. Unrealistic expectations based on inaccurate estimates are the single largest cause of software failure.”- Futrell, Shafer

Introduction

With global and competitive market, it is very important to launch a product or service in the market on time, ahead of competitors. Definitely, timely launch depends on on-time-completion of the product development projects. Project planning has lots of challenges to overcome in order to finish the project on time – right from schedule predictability, envisioning future/possible risks and coming up with mitigation plans.

This article talks about some of the challenges, often faced in the Software Product Development industry that causes the schedule slippage.

Schedule slippage: Delay in the project completion from its initial estimated date of completion.

Each project plan will have a planned completion date (NRA, RA), and a bounding box or upper limit in schedule. Nowadays, it is a common practice to have three dates associated with any project plan:

  • Non-Risk Adjusted (NRA) date: Project completion date assuming no hurdles – Ideal conditions.
  • Risk Adjusted (RA) date: Project completion date assuming some risks will come on the way and will need extra time to attend to them.
  • Bounding Box (BB) or upper limit: The upper limit on the project plan before which the project has to be finished under any circumstances – Generally decided by the top management based on product/services roadmap and launch in the market.

Under ideal circumstances, any project is scheduled to complete by NRA date. Considering some risks that may come on the way and would eat some time off the schedule, the project should be over by RA date. If the risks were not envisioned and hence not planned well, then project may get delayed and would complete after RA date. Project completion crossing the RA or upper limit is neither good nor expected out of a well-planned project.

Root Causes

As we always plan for a project to get over before RA date, seldom is the case it happens as expected. There are multiples reasons for schedule slippage, right from improper planning, lack of resources to unplanned requirements and rework that eat away vital time off the planned schedule.

A typical project development process – Each project will have a team (development, testing and other functions) that will work through a process (requirement analysis, schedule estimation, design, implementation and testing) to deliver a product to the customer/end user. Each entity that participate in the project – directly or indirectly affect the schedule.

From the development process, we can identify the items that can cause delay in the execution of the project – for example, misinterpreted or unclear requirement adds up to completion time, unavailability of development tools or resources can prolong the project duration. Various processes like schedule estimation, detailed design and product development if not executed skillfully, may significantly blow up the project cycle.

For better understanding all these possible causes that may result in schedule slippage are categorized .

Let’s have a detailed look at the root causes of schedule slippage category wise.

1) Schedule Estimation: “The key is not to prioritize what’s on your schedule, but to schedule your priorities.” – Stephen Covey

For a project to be executed on time, it is very important to have it planned very well. Any mistake in project schedule estimation reflects as delay in the project completion from its deadline. There are several factors that contribute to improper schedule estimation:

· Underestimation of technical complexities: At the start of the project, many of the team members may not have thorough knowledge of technical complexities and hence their estimation would be incorrect. Sometimes it may so happen that the person giving estimates for a particular task is having no idea about the technical challenges involved in carrying out that particular task. You might hear, towards the mid/end of the project life cycle when the task is not finished on time – “Oh, I didn’t know that this feature also requires 5 more tasks to be done!” or “I was thinking this task to be so simple, but I under estimated it!”. · Lack of Design/Big picture: It is important to have a bigger picture / overview of the complete project to understand how a particular module/feature would fit in to complete project. Product or system level design helps in understanding the interfaces among other modules and the required coordination for product assembly and hence, a better insight into the work involved. Often, estimates without focus on detailed design tend to deviate more from the actual time taken for finishing the job. · Integration Testing: While making a project plan, testing also needs to be accommodated in the schedule. At times, the unit testing or testing done by individual contributors on their module is taken into account but not the system level testing. Toward the release, when all the individually tested modules are brought together, a system level or integration testing is a must. Having the time for integration testing not accounted in the overall project schedule will cause delay in the project completion.

· Unplanned dependencies: Project planning is not only about breaking the project into minute tasks and managing them. A well-planned project schedule also needs to consider certain unplanned dependencies. Some of these are:

o People: Optimum utilization of human resources calls for same set of people working in multiple projects. A person may not be available to work for currently planned/assigned project due to extended/unplanned work in another parallel project. Another issue related to people could be unplanned/unexpected attrition that will affect the project plan. Time is also lost in mentoring of new member by a senior (more experienced) person which goes unaccounted if not planned.

o Tools & Equipments: Project can be delayed if team is waiting for release of upgrade or procurement of any vital tool (hardware or software being used in the project) or if the equipments required for development and testing are not available. “We had a 3-months project for validating our existing solution on new product platform using customer DUT (device under test). We had to wait for the DUT for nearly 1.5 months as it got stuck in customs. After getting the DUT, we realized that it’s been damaged partially during transportation. As a result we had to ask for another DUT and whole project took more than 5 months to get finished.” – I am sure that such cases will be quite familiar to many organizations. Other reason for timely unavailability of tools / equipments is that they are shared among various projects to reduce the operating cost. Any unplanned dependency on their usage or wrong assumption about availability of these shared resources would cause delay in the program. Team members might have to work on shifts to optimize the usage of shared resources which can cause reduced work hours and/or productivity loss and results to schedule slippage.

“I was waiting for Matlab license to be released by another person in the team but he left the office without doing so and I lost 3 hours figuring out what to do?” – is it something you faced before?

o Other programs: If multiple programs have deliverable dependencies, then delay in one project will have cascaded effect on other projects, which directly or indirectly depend on its deliverable. “We got delayed because we had to wait for a critical UI component from the framework project team” or “We didn’t plan for bug fixes for a component which was supposed to be delivered defect free for our usage” are the common scenarios for delays in program which are dependent on other program deliverables. Parallel programs may affect the schedule of your program in a different way as well – Sometimes, management changes the priority of the programs running in parallel. If your project is considered as a low priority one then there might be lack of resources assigned to your project that may result in schedule slippage.

· Beta releases: How many times we seek feedback on our product during development? And how often we allocate time for it? It’s important to plan beta releases if we desire to have our product validated by expert users or lighthouse customers during development. Getting feedback from beta customers becomes important especially when their requirements echo that of a mass customer base. Process of giving workable releases to customers, collecting their experience, having their feedback analyzed, and then incorporating in the final product version takes significant time.

· Risk mitigation and plan B: Every project will have some or the other risks. These risks can be of varying severity and probabilities. While making project plan, it is important to treat the risk individually based on their severity and probability of occurrence. If high probable risks with higher severity are not planned with their mitigation plan (or plan B), they will have huge impact on schedule deviation from planned one. As in one of the previous examples quoted, getting a DUT on time for validation was a risk. Had there been a mitigate plan (plan B) like – Validate with other DUT or if DUT is not available here, let one developer travel to customer’s place and finish the validation on time, the schedule slippage would have been avoided.

2) People: Ultimately, projects are executed by people who may not be skilled or talented. Hence, looking for perfection in projects involving human beings may not be a feasible thought. Certain unpredictable and hence unavoidable issues under this category are:

· Poor leadership: Before thinking of project execution, it is project planning that actually would set the platform of success. Execution of the project depends on its team while planning is taken care by the project leader. The project leader is expected to have enough technical know-how to understand the project goals and to the details of the tasks involved. Poor leadership and superficial knowledge of assignments often results in invalid effort estimation and ad hoc task delegation causing stress and possible delay in project execution. People leading the team are also responsible for keeping the team spirit and motivation level upbeat. Poor personal commitment due to lack of motivation results in loss of productivity and may cause schedule to slip. Another reason that adds up to delay in projects is inability of leadership team to track the schedule progress and take the correction action.

· Attrition: If the project duration is large and job market is hot, it may be difficult to retain people in the project till its completion. Attrition may further delay the completion especially if the person leaving the job was in critical path. A person leaving the organization would leave a gap in the project that a new person may not fill immediately, which in turn causes sudden reduction in the task force.

· Learning curve: When ever a new person or team member is included in the project, he or she may require some time to understand the project to keep in pace with other members. Learning curve is needed for new team members, joining the team either due to attrition or due to any specific technical competency requirement. · Context switching: In smaller organization or groups where people work on multiple projects simultaneously, it is important to have some buffer for context switching. A person planned to work in project ‘A’ for two hours after a gap of two weeks, would take more than scheduled time to complete that task. Gap of two weeks and the fact that he or she was involved in other project would require some time for the member to get back to the context of current project. · Global development teams: In an era of globalization and outsourcing, it is common these days to have development team distributed over different geographical regions. Project plan needs to account for different time zones and working culture. You might expect an input for your task on Monday morning your time but it may be Sunday late evening for that person and finally when the input arrives, you might be on your way to home after work.

Sometimes schedule estimation might go completely wrong if you have not understood the work culture of the region your teammate belongs to – “In my previous work, I was given a task to be completed with a heads up that its very critical task and needs immediate attention’. When I asked my project lead how many days/hours I have for it, I had been time for 2 weeks for high priority and ‘immediate-attention’ work.” Definition of ‘urgent’, ‘high priority tasks’ changes with culture and region.

· Communication Issues: People communicate differently. If important issues are not brought to the notice of the team members, or are not escalated on time, the entire project may suffer. Often fear of embarrassment stops team members from reporting issues faced during execution leading to more time being spent on that task that can easily be executed additional help.

3) Customer Involvement: These issues are quite serious if customer or end users of the product are involved in the development phase. Understanding customer’s priorities, defining your expectation from their involvement needs to be clear and in agreement with both the parties.

· Expert user testing: In the beginning of the project, expert user testing cycle needs to be planned. Process of giving builds or releases for testing and collecting their feedback, analyzing and incorporating them in your product takes significant time which, if not planned, can delay your program. · Timely feedback: “I got feedback from customers for features, delivered in development milestone-1, after milestone-5 towards the release. These feedbacks are critical but now I am worried how to incorporate them without affecting the schedule.” It sounds like a common problem. Incorporation of feedback from customers needs to be planned well taking a commitment from the customer. · Product requirement specification review: Having a product requirement review planned and executed will keep you on right track throughout the project. Reviewing the requirement specification will avoid requirement related defects fixing which otherwise would have delayed, the project.

4) Ambiguous Project Requirement: For any project to be initiated, the first thing is to have requirements for it. In the product development life cycle, requirement phase acts like a foundation. Clear requirement or vision for the project navigates the team to success. However, requirements may not be clear at the time of estimation and may result in delay in the project completion. Issues related:

· Evolving specs: If you are making a product based on a standard which is not yet matured or still evolving, you are more prone to have this risk. Frequency changes in the specs will change the requirement for the project during different stages of product development and team will continue to work on something that is not yet evolved. This results in rework that would delay the project if time for dealing with these changes is not accommodated in the schedule. “We developed an algorithm and hence measurement that was based on certain industry standard. Towards the release of the product, the specs changed and our measurement was no more valid. We had to redo the algorithm to reflect the changes in the specs. This caused our product release delayed by 2 months.” · New requirements: Sometimes new requirements are added as the project evolves towards completion. Implementation of new requirements is not planned at the beginning of the project and hence is not accounted in schedule. Adding new feature without revising the schedule may result in delay.

· Untold expectation: Requirements from the customers may be of two types – implicit or explicit. It is important to have the requirements well documented. Implicit requirements needs to be better defined and documented to avoid any confusion towards the end of the project. Customers may not describe their requirements related to system performance, memory issues, user interface quality and usability but they are very keen on providing feedback in those aspects once the product is given for expert user testing. If we are not clear about such requirements, out design might not address them. Addressing them towards the end of the project may call for design changes and extra work that would delay the project.

5) Unplanned Tasks / Reworks: Bounding box for the project is set by higher management and often lack buffer for unplanned task(s). Having more of unplanned task that creep up at different phases of project can cause schedule slippage. The unplanned tasks or rework may arise due to:

· Sustaining work: In smaller organizations, some of the project team may also be responsible for sustaining / customer support of existing products. These unplanned tasks, which come on event basis, related to customer support are always of high priority. Excess or prolonged sustaining work may take resource out of the planned project causing a potential threat for schedule slippage. · Defect fixes: Defects are bad as they degrade the product quality and consume extra time/effort to fix them. It is good to have testing of the intermediate releases of the project to find and fix defects sooner in the development life cycle. If the fixing-cycle for such internal-milestone defects is not planned, then either the project is either going to slip or product is going to be of poorer quality. Poor programming skill of the team, not adapting to modern programming practices and having ad hoc development processes may lead to higher number of defects which would take more time to fix then planned and cause slippage.

· Task spillover from previous milestone: Tasks that are not completed in previous milestone, due to whatever reason (inefficiency, vacation of the team member, resource crunch etc), will have to be completed in the next milestone thereby increasing the load on the team. If adequate buffer is not planned, these tasks spilled from previous milestone over to next, can delay the project. · Requirement change / refinement: Requirement changes during the product development will result in rework of what has been previously done with first version of requirement(s). Addressing changes in the requirements needs extra time and effort and may cause schedule slippage. In some cases, the requirement from customer is misunderstood resulting in wrong system design and implementation. Additional, unplanned time is lost in correcting the design/implementation which causes schedule slippage.

Conclusion

On time delivery is the challenge software development companies are facing globally. To have a complete control over estimated schedule, it is very important to identify the elements in the development cycle that cause schedule slippage. This article uncovers and explains the root causes of delay in programs using examples from real world. Having an insight to the root causes will help the program managers to make good decisions to avoid future schedule slippage.

Posted in general | Comments Off on Schedule Slippage – Root Causes

Top 25 Terms All Computer Students Should Know

The following basic terminologies are considered the top 25 terms all computer students should know before they even begin their studies:

1. Bit: Binary data storage unit valued at either 1 or 0.

2. Byte: Eight data bits valued between zero and 255.

3. Word: Two data bytes or 16 data bits between zero zero and 16,535.

4. CD-ROM: A storage disk with approximately 640 megabytes of capacity.

5. CD-ROM Drive: Hardware used for reading and writing to CD-ROMs.

6. Storage Media: Magnetic devices that permanently store computer data.

7. File: Permanent storage structure for data kept on a hard drive or other permanent place.

8. Virus: Unauthorized programs that infect files or send themselves via email.

9. Vulnerability: When unauthorized access can be gained due to software errors.

10. Security Flaw: When attackers gain unauthorized system access due to a software bug.

11. Worm: Unwanted programs accessing computers via application / system vulnerabilities.

12. Hardware: Physical parts of computer (case, disk drive, monitor, microprocessor, etc.).

13. Software: Programs that run on a computer system.

14. Firmware: Software that has been permanently written into a computer.

15. ISP: Internet Service Provider.

16. BIOS: The basic input / output system computers use to interface with devices.

17. MIME: Multipurpose Internet Mail Extension.

18. Boot: What happens when a computer is turned on and beginning to run.

19. Crash: When computer software errors occur and programs fail to respond.

20. Driver: Program that understands interfaced devices like printers and video cards.

21. Network: Cables and other electrical components carrying data between computers.

22. Operating System: A computer's core software component.

23. Parallel: Sending data over more than one line simultaniously.

24. Serial: Sending data over a single line one bit at a time.

25. Protocols: Communication methods and other standard Internet / networking functions.

These are the top 25 terms all computer students should know before they even begin their technical training. Most computer students know much more. In fact, everyone who uses a computer these days should understand these terms so they can be better informed about the important tool that is so integral to our daily lives.

Posted in general | Comments Off on Top 25 Terms All Computer Students Should Know

Automated Real Estate Software – The New Trend in Investing

The value of real estate has appreciated in the last few years. It also shows great potential for growth. Hence, now might be the best time to look at an investment in property. However, if you’ve spoken to someone who already has his knees deep in real estate investing, you will realize that a lot of things are easier said than done.

It requires skill and experience to scour the market for high value properties.

Then comes landing good buyers.

Finally, there’s a humongous amount of paper work to handle.

This is where real estate investing softwares might lend a hand. They automate the entire process of real estate investing. If you would like to know more about such applications, here’s a low down on some of the common features they offer.

Lead generation –

At the click of a single button you are able to find a comprehensive list of buyers and sellers scattered across the country. The information elicited includes names and mail addresses of buyers, owners of properties, the type of property (bank owned, foreclosed, low and high equity, absentee owner etc.) and amount of cash paid.

Website creation –

Every business needs a website, especially if you do not have a physical location from which operate. Not all of us know the technicalities of writing HTML codes and designing a website. The real estate softwares can help you create targeted and user-friendly websites that you can use to showcase your business.

Direct mail generator –

Marketing is the soul of a real estate business. The more you network the more leads you can generate. The direct mail generator feature helps you setup a highly productive and efficient mailing system. You can send out emails, newsletters, posters and flyers.

There are a range of pre-made email templates you can use to send out messages to your leads. Autoresponders make sure you can keep in touch with sellers and buyers even when you are not physically present to answer their queries.

This feature is a highlight feature of most real estate software given that the savings in time and money are large.

Investing tips –

This is a section that most newbies can benefit from. Most applications include a resource library with info on the basic aspects of the trade. An open community of members can also give you an opportunity to interact and build your resource with real-time knowledge about making, building and closing a deal.

Diverse user base –

Modern-day automated real estate investing software applications cater to a varied group of investors. It includes those who buy, fix and flip properties. If you are a landlord, it can increase the convenience of managing your properties including finding tenants and repairing and renovating properties between subsequent deals. There are also features that rehabbers and builders of new constructions can use.

Contracts and paperwork –

Real estate investment also means a lot of paperwork. Most applications offer tools to generate contracts. Features such as auto-fill enable you to fill personal details into letters, contracts and other property-related documents. You can sign them online, and then email or fax them free of charge.

There is one thing – you need to be realistic. Real estate softwares are tools you can use to streamline your business. You should have a real estate business to start with and some basic know-how on investing.

Posted in general | Comments Off on Automated Real Estate Software – The New Trend in Investing

Determining the Best Type of Fastener to Use For Outdoor Furniture Construction

If you want to learn about selecting hardware for your next outdoor furniture project, then you'll want to read this article. Specifically, I'll be telling you about what type of hardware will perform best, why the type of metal used for fasteners and the finish used are important considerations, and how properly protecting or limiting exposure of your furniture to wet and winter conditions can increase Life span. After you're done with this article you will understand that the best choice of hardware for your outdoor furniture project is dependent on furniture style, material used for construction, selected location for the furniture and budget.

Selecting proper hardware for your furniture will help ensure a long life span, as well as improve the overall appearance of your furniture. Part of the problem is knowing what hardware to select when there are so many options available at the hardware store. The typical Lowes or Home Depot carries a huge selection of stainless steel, hot dipped galvanized, bright galvanized, plain steel, coated steel and brass bolts, nuts, washers and screws. Each type of fastener is suitable for certain applications, but not all are ideal for outdoor furniture applications.

In fact, choosing the wrong fasteners can greatly shorten the lifespan of your furniture, contribute to rot of wood furniture, cause unsightly staining, and even make your furniture unsafe to use.

One thing that needs to be noted right up front is, do not ever use unprotected steel fasteners for outdoor furniture, they will rust very quickly, and the steel will react with the tannic acid in the wood causing streaks and staining. The tannic acid actually speeds up the corrosion of the fasteners. Have you ever seen a wooden fence with black streaks running down the boards from the nails? This fence was installed with the wrong type of fasteners. The same thing will happen to your furniture. Even worse, as the fasteners rust, they will speed up the decay process of the wood around the rusted fasteners, ruining your furniture and making it potentially unsafe to use.

Hot Dipped Galvanized

Screws and bolts treated by hot dipped galvanizing are specifically designed for use outdoors. Electroplated galvanized or bright galvanized fasteners will very well not hold up as well as the hot dipped galvanized hardware. Zinc is used as a coating in both methods, and acts as a barrier against the elements and the tannic acids in the wood.

I strongly recommend only using screws or bolts in the construction of outdoor furniture, however. The galvanized finish on nails, either electroplated or hot dipped, can easily become damaged while hammering them in, exposing the nail head to the elements and allowing them to begin rusting quickly.

Adequate care must be taken when installing galvanized screws. Drill pilot holes in hardwoods, and be sure to use a bit that is not worn and intolerable to skipping in the screw head. For whatever reason, the galvanized screws seem to not be as well tempered as other steel fasteners, and are more likely to either snap off or have the heads strip out while installing them. Due to the permission required for the hot dipped coating, galvanized bolts do not have as tight of tolerance on the threads, and are more likely to strip if over tightened.

Hot dipped galvanized fasteners are a fine choice for many outdoor furniture applications, including Adirondack Chairs, but are not the best choice for use in woods, such as teak.

Stainless steel

Stainless steel is the best choice for use in woods with higher levels of tannic acid, such as teak. Stainless steel is an alloy or blend of steel, nickel and chrome. The ratio of the other metals with the steel determine the weather and corrosion resistance of stainless steel. Because the steel is mixed with other softer metals, the stainless steel is not as strong, so predrilling of screw holes is highly recommended in all applications, and essential in hardwoods such as teak and mahogany. The added corrosion resistance more than outweighs any shortcomings that the metal may have, especially in outdoor furniture applications.

While stainless steel fasteners are the most rust resistant, they are also the most expensive of the options we are discussing. However, using stainless steel fasteners will add years of life to your furniture. In the respect, they are an investment that will pay out for years to come.

Brass

I have seen brass used in some commercially produced outdoor furniture, but do not recommend it. While brass does not form red rust, and is well suited for many wet applications such as toilets and sinks, it does tarnish and corrode. It is also very susceptible to the tannic acids in wood, which will cause it to fail more quickly. Brass screws in particular Do not have sufficient strength for outdoor furniture applications.

Outdoor or deck screws

In the past several years a number of manufacturers have introduced outdoor fastening products specifically marketed for deck building. These will typically be green, gray, tan or brown. These screws are either ceramic or plastic coated to delay the metal reacting with the wood acids. The specific coating methods are proprietary to each manufacturer, and can be a combination of electroplated galvanizing and plastic, or a baked on ceramic.

I have used these fasteners in furniture applications and they perform just fine. Unfortunately, I have not come across bolts with this type of finish. The brand of screw I used was Deck Mate, and they were available in tan and brown, so that the color can be selected to better match the wood being used. These screws are ceramic covered, and the manufacturer provided a coated bit for installation, which was designed to not damage the ceramic coating at the screw head. If you choose this type of fastener, be sure to compare the cost with stainless steel, as the price will vary. If the stainless steel is reasonably comparable in cost, it would be the recommended fastener.

Always be sure to read the manufacturers specifications on the box to be sure that the screws are suitable for your application.

Other Considerations

If you are building furniture that will be located on a covered porch or patio where it will be protected from the elements, the concern will be the interaction between the wood and the fasteners, much more so than the weather. Furniture that will be exposed to the elements all year, such as a garden bench, or an adirondack chair in the corner of your garden, will have to be constructed with much more care and concern to ensure that they hold up more than just one or Two winters.

Additional considerations must be made beyond just the choice of what type of fastener to use, though this is very important. For example, fasteners should not be located where water where collect and sit on the fasteners for an extended period of time. The screws that attach the seat slats to an Adirondack chair are a prime example- typically these screws will be countersunk below the surface of the wood. This will allow water to collect in the screw holes, shortening the life span of all but stainless steel fasteners, and prolonging the exposure of the wood to water, which will increase the rate of decay. In applications where the furniture will be exposed to the elements year round the screw heads should be driven flush with the surface of the surrounding wood.

Construction and design of the furniture are also important considerations. Are the horizontal surfaces of the furniture constructed in such a way that will allow them to shed water, rather than collect it? Think of a picnic table with a slatted or board top. The gaps between the boards allow water a way to run off the top and not pool up.

Conclusion

Stainless steel is usually the best choice for outdoor furniture applications, although the cost may be prohibitive for some. There are other less expensive fastener options available that will perform acceptably. Do not use unprotected steel fasteners for outdoor furniture applications under any circumstances. Know where and how you intend to use your furniture and design it for the conditions it will be subjected to.

Posted in general | Comments Off on Determining the Best Type of Fastener to Use For Outdoor Furniture Construction