Data Entry India

Last 10 Posts


Creating Forms in Excel: Become A Master Craftsman



Entering large amounts of data into an Excel spreadsheet can be very time consuming. Using data entry forms makes your task easier. A data entry form is a dialog box that gives you a convenient way to enter a complete row of information at one time.

To use a data entry form to edit a list:
Click a cell in the labeled row you want to add the record to.
On the Data menu, click Form.
Click OK. A data entry dialog box appears, with field labels that correspond with the column labels in your list

To add a new record:
Click New.
Type the information for the new record.
When you finish typing data, press the ENTER key to add the record.
When you finish adding records, click Close to add the new record and close the data form.

Posted By: http://www.dataentryindia.com

Category: General
[Permalink] [Comments - 1] [Send Article] [Improper]

E-filing is easy, but wrong data will cause rejects



Author : Associated Press

According to H&R Block, rejections most commonly occur because of incorrect entries for a taxpayer’s adjusted gross income, date of birth or Social Security number for the taxpayer, spouse or children.

Most tax preparation software will not e-file a return in which it detects a major problem or error. The program may also reject returns with Social Security numbers not in the range of known numbers it has from the government.

To prepare and file a tax return electronically, you need:

A copy of last year’s tax return.
Social Security numbers for yourself, spouse and dependents.
W-2 forms from all employers for yourself and spouse.

 1099 forms showing interest, dividends, retirement or other
income paid to you during the year, including refunds, credits
and state and local taxes.
 Income receipts from rental real estate, royalties,partnerships,
corporations and trusts.
 Receipts and records for other income or expenses such as rental
real estate,partnerships, trusts and Social Security benefits.
 Receipts pertaining to your small business.
 Unemployment compensation records.

Those who itemize deductions on Schedule A may also need the following:

 Receipts for medical and dental expenses.
 Receipts from state and local taxes, real estate taxes, personal
property taxes.

Form 1098 for home mortgage interest and points.

 Receipts for charitable contributions and gifts.
 Casualty and theft losses.
 Job expenses.
 Taxpayers due a refund should have bank account and routing
numbers for direct deposit of refunds.

Those owing tax can pay electronically by charging it to a credit card, having it withdrawn from a bank account or enrolling in the U.S. Treasury’s Electronic Federal Tax Payment System. See http://eftps.gov or the IRS Web site at http://www.irs.gov for more information.

Tax preparation programs like TurboTax or TaxCut can e-file a return, as can online tax preparers and tax professionals. The IRS can also find an e-filer for you if you enter your ZIP code in the e-file locator box on the IRS Web site.

The return is transmitted via a modem to an electronic return transmitter, which converts the file to a format that meets IRS specifications and forwards it to the IRS for processing. Within 48 hours the IRS confirms whether the return has been accepted or rejected.

Taxpayers who file electronically create a personal identification number, which serves as their electronic signature and requires knowing their 2004 adjusted gross income. Taxpayers who don’t create a PIN can still file electronically but will also have to mail Form 8453-OL to the appropriate IRS service center after they have received IRS confirmation that the e-filed return was accepted.

Posted By : DATA ENTRY INDIA

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Legislator suggests penalties for data-entry errors



Author : Aaron Sadler

A longtime state legislator Wednesday proposed penalties for school employees who make repeated errors when entering information into a statewide school accounting system.

Data-entry errors consistently plague the Arkansas Public School Computer Network. He thinks the error-prone should be forced to undergo new training about how to enter information into the network.

Lawmakers have often criticized the system for producing inaccurate or unusable reports because of data-entry errors at the school district level.

Currently, there are no penalties for schools or their employees who make data errors.

"I've heard enough from legislators to know that this drives them nuts, thinking that we've got this information, but it's wrong, with a high error rate," Mahony said at a meeting of the Legislature's Joint Committee on Advanced Communications and Information Technology.

Monetary penalties would not be a good idea because they would take money from schools and may directly hurt students. Refusing to allow a school employee to re-enter the APSCN system until the employee completes new training is a more logical penalty.

Murry proposed that the state Department of Education compile a list of common data-entry mistakes and incorporate them into the training already required of APSCN users.

Posted By : DATA ENTRY INDIA

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Be Prepared to Duel with Data Quality



Author : Rick Sherman

Plenty of business intelligence (BI) or data warehouse projects have been blindsided by complications related to data quality. Sometimes these issues aren't apparent until business users start testing the systems just before going live with the projects. What causes BI project teams to get caught off guard by data quality issues? Why do these problems surface so late in the projects?

There are two common pitfalls: Defining data quality too narrowly and assuming data quality is the responsibility of the source systems.

People often assume that data quality simply means eliminating bad data - data that is missing, inaccurate or incorrect. Bad data is certainly a problem, but it isn't the only problem. Good data quality programs also ensure that data is comprehensive, consistent, relevant and timely.

Posted By :
DATA ENTRY INDIA


Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

The competence of IT outsourcing



Author : John Carroll

Outsourcing is a solution to internal incompetence at either, or both, the business and IT levels. Thus it's quite true that very few CEOs or CFOs credit any part of their organization's competitive advantage to IT, but that says a lot about them and nothing at all about whether IT should be handled internally or externally.

“Passing information control to a third party is a lot like putting somebody else in charge of regulating your heart beat: useful in the short term if your heart is failing, but not a recipe for Olympic success.”

IT outsourcing isn't a sign of incompetence. It's a sign of competence, and deciding where to concentrate limited resources. CEOs can spend their time doing the things CEOs do, or they can type up their own meeting reports, perform data entrytasks, and do other things which are better OUTSOURCED (or just offloaded) to someone else. In fact, "offloading" may be a better word than "outsourcing" given the hackles it raises among IT professionals convinced that Indian programmers will eat their lunch (they won't, but that's a subject for another blog).

That isn't to say that in sourcing doesn't make sense in certain situations. It would be fairly ridiculous for Microsoft not to maintain most of their own sites, as doing so gives them lots of flexibility not to mention real-world experience with their own products. On the other hand, Microsoft didn't build its own fabrication plants for the creation of the XBox. They outsourced that work to fabrication companies that act as hired guns for the creation of custom hardware.

Posted By : Data Entry India

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Control Data Entry in Excel



There's no question that you're better off preventing invalid data from being entered into a spreadsheet (and messing up your calculations) in the first place than finding and correcting the data later on.

In this article we'll look at some of the tools Microsoft Excel provides for preventing data from being entered where it shouldn't be and for limiting the kind of data that can be entered.

As an aside, we'll also explore how you can create a selection list from which users can pick entries. We'll consider two different ways of controlling data entry in Excel, using the program's built-in tools. Cell protection prevents data entry in specified cells, and the Validation tool limits the type of data that can be entered.

Protecting a Worksheet Validating Data at the Entry Point Preventing Duplicate Entries Adding a Selection List Provisos

Data Entry India

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Call Center Scheduler Eliminates Manual Data Entry



Call Center Scheduler announced that its latest software release, Call Center Scheduler 4.1.1, automatically imports ACD data without requiring connectivity.

The ACD calls offered and average handle time data is used to create call arrival patterns critical to forecasting call volumes and creating effective workforce schedules.

"Customers no longer need to key in data, but true to our philosophy, we retain the customers' ability to review ACD data before it's imported into the workforce management system," said Wayne Shaw, President. "Additionally, our approach of using ACD Auto-Download rather than direct connectivity enables us to offer a robust workforce management system at a price any call center can afford."

To take advantage of the feature, customers schedule their ACD to run a call arrival pattern report each day and save it as a file.

Daily, or as often as appropriate, the workforce manager opens a new call arrival pattern in Call Center Scheduler and downloads the historical data automatically.

Because ACD data often includes anomalies that can distort forecasting and scheduling, a safeguard is put in place to enable the customer to review the historical data prior to saving it into the Call Center Scheduler workforce management system.

Shaw added, "The ACD Auto-Download was requested by our customers and tested by them to ensure that our workforce management process reliably collects data that will allow them to continue building powerful schedules for their work groups."


http://www.dataentryindia.com

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Industrial Pocket PCs for Remote Data Entry



The one compromise we've had to make was in data input. While the Pocket PC's touch screen is great for selecting items from menus, it is less than ideal for inputting more random information such as inventory quantities, new customer names, and other alpha numeric data. Good handheld computing application design attempts to minimize such input by providing the user with a list of current customers and inventory items, but there are certain situations where numeric or text input can't be avoided.

Fortunately for the developers of applications that require such user input in the field, there are a few new industrial Pocket PCs now available that address the problem. Here's a look at two of them.

Symbol PDT 8000 series for numeric data entry

Symbol has been a leader in industrial handheld computers and barcode readers for many years. With the PDT 8000 Series they've combined the two in an industrial Pocket PC that includes a 23-key keypad for numeric entry in addition to the normal touch screen.

In addition to the ten number keys, the keypad includes cursor navigation keys and three keys that can be used for custom applications.

Other features of the Symbol PDT 8000 include a 400 MHz Intel XScale processor, 128 MB of RAM, and 64 MB of flash ROM. This large amount of memory allows complex enterprise applications to be stored in non-volatile flash memory and large databases in the built-in RAM without the need for an additional storage card. But storage should not be a problem since there is a CF slot available as well as built-in wireless capability. The PDT 8000 can be configured with a Bluetooth, Wi-Fi, or GSM/GPRS wireless adapter—all this in a handheld designed to withstand multiple drops from five feet onto concrete.

Industrial Pocket PC with a full keyboard

If your application requires the user to enter more than just numbers and menu selections, then you may find that the pop-up software keyboard (known as SIP, for Soft Input Panel) is a limiting factor. In this case, you will be pleased to see the new CF-P1 from Panasonic.

While you might be familiar with Panasonic as a maker of consumer electronics, the company has been producing ruggedized laptop and handheld computers under the Tough book brand for quite some time. The CF-P1 is unique in that it includes a "thumb keyboard" with a joystick button and three application function buttons.

The keyboard makes the CF-P1 an ideal choice for applications such as law enforcement in which random text, such as names or notes, must be entered.

Another unique feature of the CF-P1 is the battery. While the user documentation admonishes you to use only the specified battery pack, the battery is the same as that used by many portable video camcorders. This not only allows for inexpensive replacement batteries but also external chargers. The battery is large enough to provide 8 to 24 hours of operating time, depending on the accessories used and backlight usage. Along with this lithium-ion main battery, there is an internal rechargeable lithium backup battery.

The CF-P1 uses the older-generation 206 MHz Intel StrongARM processor and 64 MB of RAM and 32 MB of flash ROM. This means that if you want to use non-volatile storage, you will need to insert a flash card in the SD memory card slot.

The SD card slot, DC adapter connector and headphone jack are all covered with rubber moisture seals. Personally, I dislike these rubber flaps since they always seem to stay open after being used a few times.

According to the documentation, there is a CF card slot in addition to the SD slot. However, the CF slot is not accessible by the user. The top of the CF-P1 is removable to allow for what are listed as "built-in cards" such as barcode scanners or RF modules. But the screws that hold this top in place are tamper-resistant Torx heads and the documentation clearly states: "These cards cannot be changed." While I can understand Panasonic's desire to maintain the integrity of the environmental seals, I would prefer a solution that allows customer access to the CF slot.

The Panasonic CF-P1 has a few other strange quirks. For example, the keyboard lacks a Tab or Control key. But keeping in mind that the primary use for this machine is with custom applications, this may not be an issue. That's because the programmers can take the keyboard limitations into account when designing the user interface.

So if your application needs both a rugged device and the ability to enter lots of numbers or text, one of these two industrial Pocket PCs should fit the bill.

http://www.dataentryindia.com

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Opening Doors With Data Entry



You might follow the lead of MIT and the Soros Foundation. Both are clients of Digital Divide Data, a nonprofit based in New York and Phnom Penh, Cambodia. The company hires skilled, unemployed, often disabled workers in Cambodia and Laos and pays them $75 a month--not bad in places where the average annual income is just $400. Meanwhile, its clients get a competitively priced data-entry service and the assurance that workers are being treated fairly. "We want to build tech sectors in Cambodia and Laos," says Digital Divide CEO Jeremy Hockenstein. "And we want to show that it can be done in a way that's both profitable and socially responsible."

Hockenstein and his partners founded the company in 2001 after traveling to Cambodia and observing a wide gap between trained workers and job opportunities. With a $25,000 grant and $25,000 from the founders, Digital Divide hired 20 employees, most of them war refugees. By 2004 the workforce had swelled to 200, and last year the company rang up $400,000 in sales. Its revenue covers Digital Divide's operating costs, but the company still solicits donations--about $250,000 last year--so it can offer six-hour workdays and tuition subsidies to help staffers move into better jobs. One alum, 24-year-old Naleak Eng, recently moved from Cambodia to Boston to pursue a high school diploma. No small feat, considering that Eng, born with three fingers on each hand, was destitute four years ago. "Being disabled, I was so shy until Jeremy gave me the challenge of doing this job," she says. Maybe outsourcing isn't so bad after all.

http://www.dataentryindia.com

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]

Easier Variable Data Print Without Data Conversion



Users can use native XML data to design, produce and distribute variable data documents, without any modification to the data stream. Many of today's standard enterprise applications output XML as their default format and, just as importantly, most web-based applications use the XML format to transfer and process data streams.

Since these applications are so widely used, it was critical for our customers that Planetpress be XML-enabled.' The patent-pending xml2print PostScript-based XML interpreter, is claimed to allow native XML streams to be sent to any PostScript printer as easily as any of the other currently supported data streams.

VDP systems require output to be pre-processed through a PC-based interpreter that usually remaps the original XML stream in to another 2D format.That only adds complexity and delays the production workflow. However, the company said that the XML-enabled Planet press 5 documents can read and interpret the logical XML structure, as if it were a common database or CSV file, resulting in a more streamlined and integrated process.

Planetpress Image can now create Autostore compatible files for integration in to their electronic management system.

http://www.dataentryindia.com

Category: General
[Permalink] [Comments - 0] [Send Article] [Improper]