Who Invented Dell Computers?

The invention and the history of the Dell computer is quite interesting. First of all, it was in 1984 when Michael Dell, a student at the University of Texas at Austin, created the company PC's Limited. He only had a starting capital of $ 1,000. So what he did was started working out of his dorm room to build personal computers made from stock components. These computers were to be IBM compatible because that was the standard at that time. If a computer were to function with various pieces of hardware, it needed to be IMB compatible.

It is when Michael Dell figured that selling computers directly to customers to determine customer need that he dropped out of college. His family then extended him the $ 300,000 in expansion capital that he needed to make his business take off.

A success

It was in 1985 that the Turbo PC was developed and it sold for less than $ 800. It contained an Intel 8088 processor that ran at 8 MHz, which is significantly slower than the computers that we use today. Computers today are running in gigahertz, which are hundreds and even thousands of times faster than the 8 MHz processor that Michael Dell was installing in his computers at the time. But the truth is that this was the best that could be done in 1985. The technology was developing.

But there was an aspect of PC's Limited that was unique from the rest and continues to be this way today. It is the fact that customers could order their computers rather than buy a computer that was already assembled. This allowed individuals to receive computers at lower prices than what they could get with their competitors. This definitely worked because PC's Limited grossed $ 73 million in its first year of trading.

The beginning of Dell

It was in 1988 that PC's Limited became Dell. Prior to that, the company already had 11 international operations occurring, so the company was quite large. There were on site services set up to compensate for the lack of businesses acting as service centers for Dell computers. It was in 1990 that Dell attempted to sell through club houses, but had very little success with this. So it is then that Dell went right back to its direct to customer sales.

In 1996, Dell started selling computers on its website. An individual could go onto the website and custom design their computer so that it would be built to their specifications. From there, it would be shipped to the customer's home. Financing was made available so that individuals would be able to acquire their computers easily.

In 1999, Dell became the largest personal computer seller when they took over Compaq computers. Their revenue topped $ 25 billion in 2002. Also in 2002, Dell started selling televisions and other electronic items. They now have Dell brand printers, LCD TVs, and much more. Because of the expansion beyond computers, Dell was changed to Dell Inc. In 2003.

It is amazing that this billion dollar company started in a dorm room with $ 1000 in starting capital. And Michael Dell has always stood by the principles of letting individuals have the capability to design their own machine. Although there are Dell computers now sold in various retail outlets, a person can still go to the website and design the machine of their dreams. And Dell also offers a lot of assistance for individuals needing help with their computers. They offer on-site services and so much more for the computer user so that they can have the best experience possible.

Posted in general | Comments Off on Who Invented Dell Computers?

Review of Takeoff Software for Estimating Construction

So often people want to rush out and buy estimating software or takeoff software without first trying to define their internal estimating processes. Once the estimating process is clearly defined, then and only then, can you actually try to compartmentalize the process into segments. So often the segment is really quantity takeoff. Takeoff of what you may wonder? That is like the million dollar question. This article will speak about the takeoff software process which usually associated with estimating software processes. The takeoff software process can often be takeoff of materials for some folks, and to many others, the takeoff process of scoped systems to create estimates or proposals. This review or comparison will not try to explain the estimating software process but bring to you valid quantity takeoff thinking among estimators in a quest to find which product thinks the way you do. These are the opinions of the author.

I will review and compare 3 types of measuring takeoff products:

It is extremely important to note that these are ONLY measuring takeoff programs, NOT estimating programs.

1) Planswift

2) On-Screen Takeoff by On Center Software

3) Electronic Plan Takeoff Software

All three products have their strengths, however, Planswift and On-Screen Takeoff are stand-alone products and Electronic Plan Takeoff is actually dynamically integrated live with Microsoft Excel which means that it starts and finishes and saves in Excel. They all integrate with Excel, however, you will have to evaluate your thought process and decide which of the three products work-flow think along the lines of how you think. For instance, what is the first thing you do when you get a set of plans? Typically, you start flipping through the plans to see how involved the project is and what type of work do you see that is attractive for your company. Then when you decide you are going to estimate this job, more often than not, you start like 80% of companies in the world of construction estimating by opening your takeoff master template Excel spreadsheet. You rename your spreadsheet to the new job or project and off you go performing takeoff. This is where the differences are:

In Planswift, you decide what drawing you are on and then you perform the measuring of an item you want to perform takeoff on the plan. Unfortunately, that is not exactly how an estimator thinks. Planswift does give you the ability to add a type of takeoff item on the fly by naming it and then perform takeoff of it; somewhat of a very manual and slow process. They also provide you with the ability of applying a type of assembly to a takeoff to aggregate quantities of items in that assembly. Not quite the way an estimator thinks. It forces you to jump to different screens which slows down the process. Typically, the main start of anyone’s takeoff process, or some may think of it as a checklist approach, is to start with your own spreadsheet of YOUR items. Those items can be material items or can be scoped assembly system items. Either way, by starting with a master spreadsheet say in Excel for example, many estimators think of this as a risk reducer, not to forget things they normally takeoff. Being that Planswift is a stand-alone takeoff program, it typically saves your takeoff images in Planswift instead of your estimate in Excel, if Excel is your estimating system. If you are using Excel, you have to manually save your takeoff measurement numbers in Excel and your takeoff images in Planswift or elsewhere, just not in Excel where the takeoff quantity resides. Again, if you want to integrate with Excel, they force you to either export or import takeoff items from Excel rather than being dynamically integrated live to Excel. They do however have the ability to dump the measured quantity from Planswift into any Excel spreadsheet or Word document. The main purpose or the primary focus of this program is measuring, therefore it does a good job at that function. Most of the other functions require you to jump around different screens, and essentially, you loose your thought of where you are. There are some features that attempt to address the estimating process, however, there are many features that are missing for Planswift to be a full fledged estimating system; it is NOT one. Planswift does integrate with the leading estimating system Sage Timberline, but the integration is weak. Since Timberline’s power is in assembly takeoff and where most estimators reside in Timberline, Planswift does not give the estimator the ability to add quantities of miscellaneous Timberline items or one-time items that need to added on the fly to an assembly while they are in Planswift at the Timberline interview screen, and while being in the measuring phase. Planswift does allow the deleting of assembly generated items as well adjusting assembly item quantities in a different screen. Again, to perform all that, you are forced to jump around to different screens. No assembly is ever perfect in any estimating system since project conditions are always uniquely different, therefore, having to add items to an assembly is extremely important. That adding of items and associated quantities is an absolute requirement any estimator typically has to do during the takeoff measuring and estimating phase; something that Planswift struggles with as related to Timberline Estimating. Planswift does allow the direct send of measurements to Timberline Estimating items and assemblies while in Timberline Estimating, just as you would do with the old digitizer measuring boards. Training, support and maintenance are extra for Planswift. On-Screen Takeoff by On Center Software, and Planswift charge their annual maintenance and support fees per license (mandatory) which costs the end user more expense annually especially if a customer has more than one license.

On Center’s On-Screen Takeoff is the Grand Daddy of software takeoff products due to the fact that it has been around the longest. On Center recognizes that On-Screen Takeoff is primarily a measuring program. That is why they have a separate estimating program named QuickBid for those who want an estimating program. On Center does not try to trick you into thinking it is an estimating system. In On-Screen Takeoff, you also decide what drawing you are on and then you perform the measuring of the plan. BUT, before you start, you can load a master set styles of things you typically takeoff or measure from your own library. That process seems to be less complicated than that of Planswift. On-Screen Takeoff does give you the ability to add a type of takeoff item on the fly by naming it and then performing takeoff of it; somewhat of a manual and slow process as well. The program does come with many features that are primarily focused on simple measuring to advanced measuring issues all with attention to detail regarding easy navigation for the takeoff process. On Center does a very good job at that. However, there seems to be a disconnect of thought from an Excel spreadsheet items you may use for estimating and/or proposals. The integration to Microsoft Excel is not a dynamic live link, more like an after thought in my opinion. Yes, you can establish links to named styles to cells or ranges in Excel, somewhat rigid. But the question you will have to ask yourself, which will happen more often than not is: What do you do when you need to add things on the fly during takeoff and in an Excel spreadsheet? Again there will be manual associations you will have to establish with Excel which is another major slowdown. You have to manually save your takeoff measurement numbers in Excel and your takeoff images in On-Screen or anywhere you decide, except the takeoff images will not be saved in Excel where the takeoff quantity resides. This type of situation arises when a takeoff program is a stand-alone program. On Center’s On-Screen Takeoff has the best integration with the most widely used estimating system in the USA: Sage Timberline Estimating. It basically mimics the same interview process as you would do with the old digitizer measuring boards. By working directly with Timberline, On-Screen Takeoff allows the estimator to perform takeoff of a Timberline variable question and immediately returns back directly with the takeoff quantity in a Timberline assembly at the variable question. By virtue of this process, On-Screen Takeoff allows the estimator to continue his/her Timberline interview process in Sage Timberline Estimating by reviewing/massaging generated quantities, or adding items in a Timberline assembly as the estimator see fit. That workflow process gives full control to the estimator, good job On Center. Training, support and maintenance are extra for On-Screen Takeoff. On-Screen Takeoff by On Center Software, and Planswift charge their annual maintenance and support fees per license (mandatory) which costs the end user more expense annually especially if a customer has more than one license.

This next system is ONLY if your estimating system or proposal generator is Microsoft Excel. Electronic Plan Takeoff Software is a plug-in for Excel. You start your spreadsheet, you perform the measuring takeoff, you may even add some more items on the fly all the while you are in the measuring phase in the Electronic Plan Takeoff program. When you are done, even if you added items on the fly, they automatically appear in your Excel spreadsheet. Excel is the control of everything. Your project is started in Excel, your takeoff is saved in Excel, the estimate or proposal is/can be produced there in Excel; one program, one place. Many takeoff programs interface with Excel somehow, but only Electronic Plan Takeoff is live linked with Excel, meaning all your Excel spreadsheet descriptions appear in the measuring takeoff program so you always know where you are in Excel. That is a huge difference in comparison to Planswift and On-Screen Takeoff. You can even change a description of a takeoff item in Electronic Plan Takeoff and it is automatically changed live, in your Excel spreadsheet. When you talk about the estimating and takeoff phase you must keep processes cleans and easy and this program does just that. There is no getting lost in this program. Just like the other reviewed programs above, the central focus of this program is takeoff measuring, and it does a GREAT job at that. The navigation within the program is really simple and easy. It is not made to work with other estimating systems, but there is a version that allows the direct send of measurements to any Microsoft Windows program awaiting a keyboard entry, just as you would do with digitizer measuring boards. There is also a version that works with digitizer boards as well. If you use Microsoft Excel for estimating, or takeoffs, or proposals, then this Electronic Plan Takeoff program for Excel would be your best choice. The integration to Excel is unmatched in Electronic Plan Takeoff compared to Planswift or On-Screen Takeoff. What is quite different in Electronic Plan Takeoff is that training, support, and maintenance are INCLUDED with a purchase, whereas training, support and maintenance are extra for Planswift and On-Screen Takeoff. Moreover, annual support and maintenance for Electronic Plan Takeoff year two and beyond is a low fee per company per year, instead of per license. On-Screen Takeoff by On Center Software, and Planswift charge their annual maintenance and support fees per license (mandatory) which costs the end user more expense annually especially if a customer has more than one license.

Microsoft and Excel are registered trademarks of Microsoft Corporation. Planswift is the registered trademark of Tech Unlimited, Inc. On-Screen Takeoff and QuickBid are registered trademarks of On Center Software, Inc. Sage Timberline Office, Sage Timberline Estimating are registered trademarks of Sage Software, Inc.

Posted in general | Comments Off on Review of Takeoff Software for Estimating Construction

Why Computer Hardware Is Important

In this day and age, it is hard to deny the influence of technology in our lives. We live in an era where pretty much is automated and computerized. And amidst all the technological advancement that humankind has achieved, one important device has been created that will only sure to become more relevant to our lives as technology progresses, the computer. No one can deny that computers are now an essential part of our lives, the same way a cell phone and television does. It is safe to say that in this day and age, having no computer would be an inconvenience. Which is why it is important that we know the way our computer works so that we would be aware of the things that we should do in case it stops working. The hardware of the computer is considered to be the most important because without it, it will simply not work.

Simply put if you know how to handle the hardware of a computer and know each of their function for the unit, then you can easily determine what the problem is in case the unit stops functioning. In order to be familiar with basic computer troubleshooting, then you also need to be familiar with computer hardware. A good example of this is the memory of the computer (RAM). All programs and applications that are ran in a computer needs memory. Without RAM it simply will not function. Aside from that, even if you have a RAM but it does have the specifications to keep up with the programs that are being run, then the operation would have slowed down to a crawl. So when it comes to computer hardware, you have to make sure that it is not obsolete, so you need to upgrade depending on what sort of program that you are usually using.

When handling computer hardware, you have to keep in mind some safety measures so you can manipulate the unit safely. Before opening any computer cases, you have to make sure that the unit is unplugged or you might risk electrocution or shocks. While checking your hardware components, always check for damaged parts because that is most likely the one that is causing problems. When inserting components and parts, you have to remember that if it does not fit, then most likely you are inserting it on the wrong slot. If it does not fit, then do not force it or you will risk breaking the component. Before touching any parts inside the unit, make sure that you discharge yourself first by through a grounded metal object or you can use an anti-static wrist strap or mat which is sold in stores for cheap.

By knowing and analyzing every computer hardware part you will know about its importance and if it ever breaks down then you can perform the proper troubleshooting steps. Every hardware component is important for the computer's operation. The performance of your computer largely depends on how good your hardware is, so be sure that they are always in good working condition.

Posted in general | Comments Off on Why Computer Hardware Is Important

Advantages and Disadvantages of Biometric Time and Attendance Software

First of all let me ask you what you understand by time and attendance software? Have you ever been asked to log in as soon as you enter office and the main gate of the office has a Biometric machine that takes in your finger prints and allows you to enter the office premise? Yes, these are the time and attendance software being installed in a company.

Biometrics consists of methods for uniquely identifying a person (human being) by his/her physical or behavioral traits. There are many biometric software available in market for such purpose and their use is widely known. One such use is Biometric time and attendance management software.

Those days are gone when we had to punch in cards or sign into a register to tell the other person that we are present. Just as paper checking has been changed from manual to computerized, identifying a person and letting him in your office has been changed from manual to biometrics.

There are many benefits of having such methodology in your office. Such as:

• Accurate timing: When a person looks at his watch and enters the time there is a slight chance that he may see the wrong timing and write. Whereas with biometric time and attendance software there is no possibility of such mistake. The user does not need to see or check the time, it automatically gets logged in.

• Less error: There is no scope of human error here.

• Profit to company: If it’s accurate and correct the company will definitely gain from it.

As everything has a good and bad side this too has its disadvantages, such as:

• Extra cost to company: Biometric software and machine cost a lot more, so installing such software need a good investment money wise.

• Extra management: Remember when every employee is logging his own timing when he comes or leaves; there is no extra management here. But, if you are putting a machine there has to be taken some care of it.

Biometrics time and management software is really helpful when creating payrolls for employees. Once a definite timing has been registered you don’t need to think twice before creating the employees pay.

Many homes are also using such kind of software to have a safe and secure home. Biometric software is really helpful when you need security in your home as well as in office. There are many companies all over the world providing such biometric time and attendance software. You just need to keep an eye on the technologies and websites that are providing you these.

Posted in general | Comments Off on Advantages and Disadvantages of Biometric Time and Attendance Software

Application Software in Business Activities

Business is any activity undertaken by an individual or a group of person with an intention to make profits. A business engages in various activities like planning of resource, scheduling of activities, coordinating and other managerial activities. All these have to be completed in time in order to generate maximum profit in the production. Prospective entrepreneurs should adhere to these objectives.

Much of business time is put waste when it handles its tasks through the use manual system. This necessitates to the use of the software, an automated means which is efficient-oriented. Examples of the software in business application include the Decision Support System, Transaction Processing system and Management Information System. They can be largely used in resource planning where an enterprise defines way to achievement.

Collaborative resource planning software provides the business people with adequate and reliable information. Marketing information and bureaucracy of the enterprise is unambiguous. Previous methods that contributed to the failures can be fully noted. This enables the enterprise to opt to use other successful means in use elsewhere. An efficient resource planning software helps you to generate and retrieve information about resource allocation in form of detailed niche reports. As a result, time as a resource is much conserved and can be used in other productive areas.

Boundaries are clearing defined by the software. The business is expected to work towards the laid limits by the legal authority, operational, technical, economic and social feasibility. Beyond the predetermined extents, no productive operation can be encountered.

Scheduling of activities is best in practice via use of the software. The order and the way in which operation is accurately developed by use of the program, this results into application of qualitative business techniques, where there is matching of skills and jobs to done. The enterprise standards of performance are maintained. Cases of underemployment or over employment are eradicated. In turn, employees’ are encouraged to exercise creativity and innovation in right of their propelling positions, and hence works towards achievement of objectives of the business.

Planning software makes efficient forecasting of resources. Unknown future is determined prior. Situations like inflation, competition increases government provision of subsidies and technological changes can be adequately known. The fallout is to relay strategies to deal with upcoming challenging matters.

Top echelons (management) benefits significantly in software application. Executives’ unstructured decisions are accurately established. They rapidly derive information from the software. For example, decisions on where to establish a new firm or a branch, whether there is funds to finance multiple projects.

Management need to store information in reliable source (in software). This is used for swift evaluation of business performance. They can decide to reward the best performing employees based on the results retrieved from the software. This motivates employees to work zeal and confidence. Their individuals objectives are harmonized to entire business objectives.

Managers use software to control the progress of activities. Those deviating from the predetermined plans can be precisely noted. Management can also rely on software for marketing of its products. Research on business competition like advertisement and efficient market penetration means is done in detail.

In conclusion, software suitable for effective planning of the business operations, scheduling of activities and other managerial activities. Without use of software, a business is considered to be running behind technology and operating at obsolete level.

Posted in general | Comments Off on Application Software in Business Activities

How to Repair DBF Files by Using DBF Recovery Software

As a computer user you must have heard about a DBF file or some of you have used it. DBF is a database file format used by various database software programs, such as: Visual FoxPro, Clipper, dbFast, CodeBase, MultiBase, dbXL, Arago and similar database programs. A database file is a collection of data organized in a tabular form. A DBF file can be easily opened, edited and saved by any of these database programs therefore, this file format is very popular among computer users.

The most common use of a database file is to store a large amount of data and information. The file is widely used in almost every sector, such as: corporate and educational sectors to store the data and information. It has become an essential file format for an individual and an organization.

Where this file format is very useful for users on the other hand, it may create some serious problems as well. Sometimes a DBF file may become inaccessible or invalid due to corruption. DBF is not immune to corruption; in fact, this file format is prone to corruption due to its large size and complex file structure. It might be easily corrupted due to various reasons, such as: virus attacks, malfunction in database application, hard disk drive failure, software collision, unexpected cancellation of DBF, human errors and many more. These are some common reasons which can play an important role in database file corruption.

While opening a corrupt DBF file you may receive some error messages something like these:

  • “File .dbf does not exist”.
  • “The fields in table did not match the entries in the database”.
  • “Access to table disabled due to previous error”.
  • “Database file appears corrupt: Page is of wrong type.
  • “Corrupt table”/ “index header”.
  • “Filename .dbf has become corrupted”.

These are some common errors which frequently take place at the time of corruption. For example: you are working on your DBF file, everything is fine. But all of a sudden your database application (Visual FoxPro or other) starts hanging. You have no other option other than restarting the system. But when you restart your system and open the same DBF file, in which you were working earlier, it does not open or you get an error message saying the file is corrupted or damaged. This must be very frustrating situation for any user since all the hard work will go into the vain. All the data and information stored in the file might be lost forever. You have to re-create the file, which might not be possible in some cases.

In such critical state a BKF file will definitely help you. If you have backed up the database file (which is now corrupted), then you can easily restore it from the BKF file. But sometimes the BKF file may not be available or corrupted or invalid. In this situation you can use third-party DBF recovery software. This is one of the most efficient and effective solutions to fix corrupt DBF files. The DBF recovery software is designed to repair an extremely corrupted DBF file and to restore maximum data from it. It is highly capable to resolve or fix all the errors from corrupted DBF files. The software supports all popular database applications, such as: dBase III, dBase IV, dBase V, Visual FoxPro, Clipper, dBFast, CodeBase, MultiBase, dBXL and Arago. The best feature of the software is its self-describing user interface. It requires no technical knowledge or skills to use this software. Any tech savvy and a novice user can easily and comfortably use this software to repair corrupted DBF files. The DBF Recovery software is available with free demo version. Users can download the demo version before buying the full software. This helps users to examine the features and performance.

Posted in general | Comments Off on How to Repair DBF Files by Using DBF Recovery Software

How to Resolve “Memory Card Error” From Canon IXUS 130

Canon IXUS 130 is a sophisticated digital camera that has a resolution of 14.1 megapixels. The camera is inbuilt with almost all advanced features, including fully wide-angle 4x zoom lens and motion blur technology. The IXUS camera is compatible with SDHC (Secure Digital High Capacity) and SDXC (Secure Digital Extreme Capacity) cards, with storage capacity as high as 2TB.

Since the storage memory of the cards is huge, data loss from these cards is simultaneously huge. One of the main reasons for data loss from cards is corruption of these cards. In most cases, you receive an error message after your card gets corrupted. However, an updated backup allows you to overcome card corruption. It allows you to restore data. But in case of unavailability of backup, you can use recovery software to recover data from a corrupted card.

As a practical case, you view the below error message on Canon IXUS 130 while attempting to view some previously stored photos on your SDHC card:

“Memory Card Error”

Every single photo saved in the memory card becomes inaccessible after the above error message appears. In addition, no more photo can be saved on card. In short, the card can not be read or written upon.

Cause:

The above error message that makes all the photos inaccessible is primarily caused due to corruption of card. Few reasons that are accountable for the above error message are virus infection, interrupted read/write operation, and human errors.

Resolution:

The resolution for the above error message is formatting of memory card in the camera itself. The process deletes all the previously saved data and allows you to save new data. While formatting proves a good resolution for users who do not require the old data, it becomes fatal for users, like photographers, detective agents, etc, who save critical data in their memory card. However, recovering formatted data now-a-days is an easy process. To do so, you need to use an advanced third-party Photo Recovery Software. A Image Recovery tool is readily available on the Internet by just one single click.

Posted in general | Comments Off on How to Resolve “Memory Card Error” From Canon IXUS 130

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

Introduction to Silk Test Architecture

Normal use of an application consists of a person manipulating a keyboard and mouse to initiate application operations. The person is said to be interacting with the GUI (Graphical User Interface). During Silk Test testing, Silk Test interacts with the GUI to submit operations to the application automatically.

Thus Silk Test can simulate the actions of a person who is exercising all the capabilities of an application and verifying the results of each operation. The simulated user (Silk test) is said to be driving the application. The application under test reacts to the simulated user exactly as it would react to a human rest. Silk Test consists of two distinct software components that execute in separate processes:

The Silk Test host software

The 4Test Agent software

Silk Test host software

The Silk Test host software is the program you use to develop, edit, compile, run and debug your 4Test scripts and test plans. This manual refers to the system that runs this program as the host machine or the Silk Test machine.

The Agent

The 4Test Agent is the software process that translates the commands in your 4Test scripts into GUI-specific commands. In order words, it is the Agent that actually drives and monitors the application you are testing. One Agent can run locally on the host machine. In a networked environment, any number of Agents can run on remote machines. This manual refers to the systems that run remote Agents as target machines. This manual refers to the systems that run remote Agents as target machines. In a client/server environment, Silk Test drives the client application by means of an Agent process running on each application’s machine. The application then drives the server just as it always does. Silk Test is also capable of driving the GUI belonging to a server or of directly driving a server database by running scripts that submit SQL statements to the database. These methods o directly manipulating the server application are intended to support testing in which the client application drives the server.

Posted in general | Comments Off on Introduction to Silk Test Architecture

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