Kamis, 17 September 2009

Menampilkan Game tersembunyi dalam Excel

Untuk menghilangkan Stress pada saat bekerja dengan Excel, anda dapat bermain Games, dengan Syarat pekerjaan yang anda lakukan telah selesai, atau pada saat jam istrahat. adapun caranya Welly akan mengajarkan anda sbb :
Untuk memunculkan Trik Games dalam Microsoft Excel, langkah pertama adalah buka sebuah lembar kerja Excel yang masih kosong, kemudian simpan lembar kerja tersebut dengan memilih menu File | "Save As Web Page". sebelum mengklik tombol "Save", anda harus mengaktifkan dahulu pilihan "selection:Sheet" dan "Add interactivity". dengan memilih pilihan ini makan File tsb disimpan dalam format HTM. langkah selanjutnya buka file tersebut dalam Browser atau Internet Explorer. atau Klik saja File tsb. pada tampilan Excel yang muncul, tandai atau Blok baris 2000. menggunakan tombol Tab, kemudian pindah ke sel "WC" jika anda telah berada pada sel tsb, tekanlah kombinasi tombol (Ctrl+Shift+Alt) sambil mengklik Icon Office yang berada pada sudut kiri atas. sekarang anda bisa menyaksikan apa yang tampil pada layar Monitor anda. sebuah Game Microsoft Excel yang tersembunyi... dilain kesempatan saya juga akan mengajarkan cara membuat Game2 yang lainnya...



Rabu, 16 September 2009

Mengkalkulasi Umur dalam Excel

Pernahkan anda menghitung Umur Pegawai dalam Microsoft Excel... jika belum maka saya akan memberikan Contoh kalkulasi umur pada Microsoft Excel. dengan cara ini anda dapat dengan cepat menghitung umur seseorang.
Contoh : masukkan tanggal, Bulan, tahun kelahiran. pada sel A1, perlu anda ketahui format penulisan didahului dengan bulan. dilanjutkan dengan tanggal dan tahun. jadi format penulisan akan seperti ini "10/27/1980" (tanpa tanda kutip). selanjutnya pada sel A2 tuliskan formula seperti ini : =DATEDIF(A1,TODAY(),"y") Setelah itu tekan ENTER.

Keterangan gambar

Kalkulasi lebih teliti

Perkalian, Pembagian, Pengurangan, Penambahan. merupakan formula
yang sering anda gunakan dalam kalkulasi angka di Excel. didalam Excel
dikenal istilah "Precedent" dan "Dependent" . Dimana "Precedent"
merupakan jumlah sel Asal data, sedangkan "Dependent" merupakan jumlah sel Hasil data.

Contoh : pada sel B3 anda masukkan angka 10, dan pada sel B4 anda
memasukkan angka 44, dan anda ingin agar hasil perkalian berada pada sel B5,
maka sel B3 dan B4 merupakan "Precedent" sedangkan sel B5 merupakan "Dependent"
apabila anda ingin megetahui sudah ada berapa banyak Precedent dan Dependent
didalam lembar kerja anda, dapat menggunakan trik dibawah ini :

Pertama Buka menu "Tools|Macro|Visual Basic Editor". kemudian masuk ke menu
"Insert Modul" kemudian salin perintah macro dibawah ini , setelah itu jalankan proses

"Compile" dari menu "Debug" simpan Macro setelah itu keluar dari menu VB Editor.



setelah anda melakukan proses tsb diatas, kini dalam lembar kerja, buka "Customize"
dari menu "Options" pada tab "Commands" bagian "Categories" pilih "Macros".
dibagian "Commands" sebelah kanan, lakukan Drag & Drop "Custom Button"
kedalam toolbar diatas. Klik kanan Toolbar baru, dan masuk kebagian "AsSign Macro".
klik ganda pada pilihan "Dependents-Precedents".

Bekerja Dalam Excel dalam secara bersamaan

Bekerja dalam satu tim memang dapat memudahkan pekerjaan yang sedang anda lakukan. sangat menyenangkan bila laporan dikerjakan bersamaan, sehingga masing2 anggota dapat mengetahui tiap perubahan yang terjadi. langkah pertama yang harus anda lakukan yaitu mengaktifkan fungsi "Share" pada Menu "Tools |Share workbook", untuk menampilkan kotak dialog Share. pada kotak tersebut pilih tab "Editing" dan beri tanda centang pada kotak cek " Allow changes by more than user at the time same"
sedangkan untuk megatur konfigurasinya klik tab "Advance" disana anda akan melihat beberapa konfigurasi yang ada "Track changes" untuk megatur berapa lama data History harus disimpan. "Update Changes" untuk mengatur perubahan Update. secara Default Update akan dilakukan setelah masing2 anggota menyimpan hasil pekerjaannya.. SAVE.

Keterangan Gambar

Jaringan Komputer

JARINGAN WORKGROUP, LAN & WAN

Penggabungan teknologi komputer dan komunikasi berpengaruh sekali terhadap bentuk organisasi sistem komputer. Dewasa ini, konsep "pusat komputer", dalam sebuah ruangan yang berisi sebuah komputer besar, tempat dimana semua pengguna mengolah pekerjaannya, merupakan konsep yang sudah ketinggalan jaman. Model komputer tunggal yang melayani seluruh tugas-tugas komputasi suatu organisasi telah diganti oleh sekumpulan komputer berjumlah banyak yang terpisah-pisah tetapi saling berhubungan dalam melaksanakan tugasnya. Sistem seperti ini disebut sebagai Jaringan Komputer (Computer Network) .

Apa jaringan komputer itu dan apa manfaatnya?

Jaringan Komputer dapat diartikan sebagai suatu himpunan interkoneksi sejumlah komputer otonom. Dua buah komputer dikatakan membentuk suatu network bila keduanya dapat saling bertukar informasi. Pembatasan istilah otonom disini adalah untuk membedakan dengan sistem master/slave. Bila sebuah komputer dapat membuat komputer lainnya aktif atau tidak aktif dan mengontrolnya, maka komputer komputer tersebut tidak otonom. Sebuah sistem dengan unit pengendali (control unit) dan sejumlah komputer lain yang merupakan slave bukanlah suatu jaringan; komputer besar dengan remote printer dan terminalpun bukanlah suatu jaringan.

Manfaat Jaringan

Secara umum, jaringan mempunyai beberapa manfaat yang lebih dibandingkan dengan komputer yang berdiri sendiri dan dunia usaha telah pula mengakui bahwa akses ke teknologi informasi modern selalu memiliki keunggulan kompetitif dibandingkan pesaing yang terbatas dalam bidang teknologi.

Jaringan memungkinkan manajemen sumber daya lebih efisien. Misalnya, banyak pengguna dapat saling berbagi printer tunggal dengan kualitas tinggi, dibandingkan memakai printer kualitas rendah di masing-masing meja kerja. Selain itu, lisensi perangkat lunak jaringan dapat lebih murah dibandingkan lisensi stand-alone terpisah untuk jumlah pengguna sama.

Jaringan membantu mempertahankan informasi agar tetap andal dan up-to-date. Sistem penyimpanan data terpusat yang dikelola dengan baik memungkinkan banyak pengguna mengaskses data dari berbagai lokasi yang berbeda, dan membatasi akses ke data sewaktu sedang diproses.

Jaringan membantu mempercepat proses berbagi data (data sharing). Transfer data pada jaringan selalu lebih cepat dibandingkan sarana berbagi data lainnya yang bukan jaringan.

Jaringan memungkinkan kelompok-kerja berkomunikasi dengan lebih efisien. Surat dan penyampaian pesan elektronik merupakan substansi sebagian besar sistem jaringan, disamping sistem penjadwalan, pemantauan proyek, konferensi online dan groupware, dimana semuanya membantu team bekerja lebih produktif.

Jaringan membantu usaha dalam melayani klien mereka secara lebih efektif. Akses jarak-jauh ke data terpusat memungkinkan karyawan dapat melayani klien di lapangan dan klien dapat langsung berkomunikasi dengan pemasok.

Ada tiga tipe jaringan yang umum yang digunakan antara lain :

- Jaringan WorkGroup,

- Janringan Lan, dan

- Jaringan Wan

Jaringan Workgroup

Jaringan ini terdiri dari beberapa unit komputer yang dihubungkan dengan menggunakan Network Interface Card atau yang biasa disebut dengan Local Area Network Card, serta dengan menggunakan kabel BNC maupun UTP. Semua unit komputer yang terhubung dapat mengakses data dari unit komputer lainnya dan juga dapat melakukan print document pada printer yang terhubung dengan unit komputer lainnya.

Keuntungan Jaringan Workgroup.

· Pertukaran file dapat dilakukan dengan mudah (File Sharing).

· Pemakaian printer dapat dilakukan oleh semua unit komputer (Printer Sharing).

· Akses data dari/ke unit komputer lain dapat di batasi dengan tingkat sekuritas pada password yang diberikan.

· Komunikasi antar karyawan dapat dilakukan dengan menggunakan E-Mail & Chat.

· Bila salah satu unit komputer terhubung dengan modem, maka semua atau sebagian unit komputer pada jaringan ini dapat mengakses ke jaringan Internet atau mengirimkan fax melalui 1 modem.

Jaringan LAN

LAN (Local Area Network) adalah suatu kumpulan komputer, dimana terdapat beberapa unit komputer (client) dan 1 unit komputer untuk bank data (server). Antara masing-masing client maupun antara client dan server dapat saling bertukar file maupun saling menggunakan printer yang terhubung pada unit-unit komputer yang terhubung pada jaringan LAN.

Berdasarkan kabel yang digunakan ,ada dua cara membuat jaringan LAN, yaitu dengan kabel BNC dan kabel UTP.



Keuntungan Jaringan LAN.

· Pertukaran file dapat dilakukan dengan mudah (File Sharing).

· Pemakaian printer dapat dilakukan oleh semua client (Printer Sharing).

· File-file data dapat disimpan pada server, sehingga data dapat diakses dari semua client menurut otorisasi sekuritas dari semua karyawan, yang dapat dibuat berdasarkan struktur organisasi perusahaan sehingga keamanan data terjamin.

· File data yang keluar/masuk dari/ke server dapat di kontrol.

· Proses backup data menjadi lebih mudah dan cepat.

· Resiko kehilangan data oleh virus komputer menjadi sangat kecil sekali.

· Komunikasi antar karyawan dapat dilakukan dengan menggunakan E-Mail & Chat.


Bila salah satu client/server terhubung dengan modem, maka semua atau sebagian komputer pada jaringan LAN dapat mengakses ke jaringan Internet atau mengirimkan fax melalui 1 modem.



Jaringan WAN

WAN (Wide Area Network) adalah kumpulan dari LAN dan/atau Workgroup yang dihubungkan dengan menggunakan alat komunikasi modem dan jaringan Internet, dari/ke kantor pusat dan kantor cabang, maupun antar kantor cabang. Dengan sistem jaringan ini, pertukaran data antar kantor dapat dilakukan dengan cepat serta dengan biaya yang relatif murah. Sistem jaringan ini dapat menggunakan jaringan Internet yang sudah ada, untuk menghubungkan antara kantor pusat dan kantor cabang atau dengan PC Stand Alone/Notebook yang berada di lain kota ataupun negara.

Keuntungan Jaringan WAN.

· Server kantor pusat dapat berfungsi sebagai bank data dari kantor cabang.

· Komunikasi antar kantor dapat menggunakan E-Mail & Chat.

· Dokumen/File yang biasanya dikirimkan melalui fax ataupun paket pos, dapat dikirim melalui E-mail dan Transfer file dari/ke kantor pusat dan kantor cabang dengan biaya yang relatif murah dan dalam jangka waktu yang sangat cepat.

· Pooling Data dan Updating Data antar kantor dapat dilakukan setiap hari pada waktu yang ditentukan.



Cara Penggunaan Printer EPSON LQ-1170

Product Controls: EPSON LQ-1170

Reset - ALT + PAUSE + Power-On, until printer beeps once

Printer's Self-Test - LOAD/EJECT + Power-On (Draft) or LF/FF + Power-On (LQ)

Demo Page - TEAR OFF/BIN 1/BIN 2 + Power-On

Hex Dump Mode - LF/FF + LOAD/EJECT + Power-On

Paper Park- Press LOAD/EJECT button until continuous paper feeds backward to the paper park position

Microfeed Forward - Press ALT + LOAD/EJECT buttons to move the paper forward

Microfeed Backward - Press ALT + LF/FF buttons to move the paper backward

DIP Switches

The printers have two sets of DIP (Dual In-line Package) switches located on the front panel. These switches control certain printer functions and default settings, the details of which are listed below.

Switch No. Function On Off
SW1-1 Character Set See Character Tables
SW1-2 Character Set See Character Tables
SW1-3 Character Set See Character Tables
SW1-4 Code Table Graphic Italic
SW1-5 Graphics Print Direction Uni-directional Bi-directional
SW1-6 10cpi Draft Font Normal High Speed
SW1-7 Select Buffer Capacity 0KB 8KB
SW1-8 1" Skip-over perforation Valid Invalid
SW2-1 Page Length See Page Length Table
SW2-2 Page Length See Page Length Table
SW2-3 Tear-off Mode Valid Invalid
SW2-4 Auto-line feed Auto LF No LF

Character Table

The following table shows the international character sets that can be selected with these DIP switches when DIP switch SW1-4 is off.

Character Set SW1-1 SW1-2 SW1-3
USA ON ON ON
France ON ON OFF
Germany ON OFF ON
UK ON OFF OFF
Denmark OFF ON ON
Sweden OFF ON OFF
Italy OFF OFF ON
Spain OFF OFF OFF

The following table shows the graphics character sets that can be selected with these DIP switches when DIP switch SW1-4 is on.

Graphics Set SW1-1 SW1-2 SW1-3
USA (PC437) ON ON ON
Multi (PC850) ON ON OFF
Portugal (PC860) ON OFF ON
Can-Fra (PC863) ON OFF ON
Norway (PC865) OFF ON ON

Page Length Table

Page Length SW2-1 SW2-2
11" OFF OFF
12" ON OFF
8.5" OFF ON
11.7" OFF OFF

What is SmartPark?

SmartPark is an advanced paper handling feature. SmartPark allows consecutive use of continuous paper and single sheets without having to remove the continuous tractor paper. It parks the current paper choice out of the way, while positioning another for printing. The SmartPark feature is not available when using the printer in pull tractor position.

What is paper parking?

Paper parking allows the use of a single sheet or a cut-sheet feeder without having to remove the continuous forms. This feature is selected via the printer's control panel buttons.

What is short form tear-off for?

The short form tear-off feature automatically feeds the perforation of continuous paper to the tear-off position of the top cover when printing is complete. When printing, the paper feeds back to the top-of-form loading position.

My printer prints fine from MS-DOS. Why am I getting garbage only in Windows?

If you have already reconnected the cable on the computer and the printer, changed to another cable, and are positive you are using a fully-shielded parallel cable, chances are that you are having a conflict in Windows. The Print Manager or the printer driver usually causes the conflict in Windows. Save your work, then exit Windows (this will clear the Print Manager of any pending print jobs). Go back into Windows and verify the printer driver that has been selected is correct. To verify the driver in Windows 3.x, go to the Control Panel and choose Printers. For Windows 95 or 98, click on Start, go to Settings, choose Printers. Make sure that the driver you have selected as your default printer is compatible. Try printing again. If you are still getting garbage, disable the Windows Print Manager. In Windows 3.x, go to the Control Panel, choose Printers, and remove the "x" from the box in front of Use Print Manager, then click Close. For Windows 95 or 98, click Start, go to Settings, choose Printers, point to the default printer then right click once on your mouse. Select Properties, go to the Details tab, click on the Spool Settings button, and choose the option "Print directly to the printer." Click OK to exit the Properties window, click OK again to save the new setting, exit the Printers window, then restart Windows 95 or 98. Try printing again. If this does not resolve your problem, take the cable and printer to another computer to determine if the problem is hardware related. If the printer prints fine from another computer, have your computer's port tested.

Can I connect this printer to IBM mainframe (IBM 3270) and IBM minicomputer (AS/400 or System 3X) environments?

Yes, you can. For IBM mainframe environments, you can purchase an optional Type-B Coax interface card (C823141) which allows direct connectivity and emulates IBM printer models: 3287, 3268, 4214-1, and 4224 (non IPDS). For direct connectivity to IBM minicomputer environments emulating IBM printer models: 4210, 4214, 5225, 5224, 5256, 5219, and 3812, you will need the optional Type-B Twinax interface card (C823151).

Can I connect this to an Apple Macintosh computer?

You may be able to connect the parallel port of the printer to an Apple Macintosh using a "Grappler" or "PowerPrint." Grappler is manufactured by Orange Micro, Inc. PowerPrint is manufactured by GDT Softworks, Inc.

What are scalable fonts and why do I need them?

Typically, dot matrix printers have fixed sized fonts which are about 10 points. Scalable fonts are typefaces which, through special software located in the printer, can generate different size characters on the fly. EPSON is the first company to incorporate scalable fonts for laser-like printing in a dot matrix printer.

What does enhanced graphics mean?

Previously it took two passes of the print head to print at 360 dpi. With enhanced graphics it only takes a single pass to print true 360 dpi. This improvement allows for better quality text and graphics when printed with programs such as Microsoft Windows and other graphic environments.

What is the purpose of the Data light on the front panel?

The printer processes data in a band buffer. The data light will be on if there is data in the buffer which has not been printed.

Will this printer emulate an IBM Proprinter?

No, the printer does not support IBM emulation.

When I turn my printer on, the paper feeds through about one and a half pages, then stops. I hit the LOAD/EJECT button and it feeds more paper instead of ejecting backwards. Why won't it go to the right top-of-form position?

Check the front panel to see if the Bin 1 or Bin 2 light is on. If it is, turn the printer OFF and manually eject the continuous feed paper. Remove the paper from the tractor unit. Move the paper release lever on the right side of the printer all the forward, then all the way to the back. Move the lever forward and backward five times, then move it into the middle position. Hold down the ALT + PAUSE on the front of the printer. Keep holding these buttons down as you power-on the printer. Release the buttons after the printer emits one long beep. The printer should initialize properly and the Bin light should not be on. Reload the paper onto the tractor unit and try to print. If you are still having problems, repeat the above steps. If the problem still persists, have the printer taken in to be serviced.

My printer beeps five times and then shuts off. It won't even do a self-test anymore. How can I get my printer to work again?

Turn the printer off and remove the ribbon cartridge. Once the cartridge is removed, slide the print head all the way to the rightside of the printer carriage. Look into the printer, on the bottom left side you should see a small white lever. Push down on the lever to make sure it is still connected, then gently move the lever from side to side a few times. Next, take a hold of the print head and move it all the way to the left, then back to the right. Move the print head left to right five times, then position the printhead into the middle of the printer. Hold down the ALT + PAUSE on the front of the printer. Keep holding these buttons down as you power-on the printer. Release the buttons after the printer emits one long beep. The printer should initialize properly. If you are still having problems, repeat the above steps. If the problem still persists, have the printer taken in to be serviced.

When printing from MS-DOS applications, I'm getting characters instead of lines.

To print lines instead of characters, the printer needs to be in graphics mode. Select a graphics character table (PC437). To switch to PC437, make sure dip switch 1, 2, 3 and 4 on bank 1 are all ON. Turn the printer OFF to save the setting. Turn the printer back ON and try printing again.

Why is there no online/offline button on the LQ-1170?

To make the printers easier to operate, we have renamed the online/offline button to "PAUSE." The function of the switch is the same as online on previous EPSON models.

What is micro-adjustment used for?

The micro-adjustment feature allows you to make fine top-of-form adjustments and short form tear-off position adjustments in increments of 1/180th of an inch. The printer remembers adjustments made to continuous paper, even after the printer is turned off. When micro-adjust reaches the minimum or maximum adjustment point, the printer will begin to beep continuously.

When printing a multiple page document on single sheets, the first page prints correctly, but the pages after start printing too low.

The difference in print position is usually caused by the page length setting in the software application program. Most applications have a default page length of 66 lines per page when using 11" continuous paper. When using single sheets, the LQ-1170 automatically provides a small top and bottom margin. Since the top and bottom margins are non-printable areas, the maximum number of lines per page is reduced from 66 to 61 lines per page. Most software applications have an option to change to number of lines per page. You should change the number of lines per page to 61. If the program offers a selection for "cut-sheet feeder," change the paper type to cut-sheet feeder.

I'm trying to print a 3.5-inch wide by 1-inch long label. I set the printer up for a User Defined page size and it prints the first label, then the paper advances about a page and a half and prints the next label. How can I set the printer up to print one label after another from Windows?

If you are in Windows 3.1x using an ESC/P2 printer driver, you will not be able to choose a User Defined page size. The ESC/P2 drivers do not support User Defined page sizes. To use a User Defined page size, you will need to change your printer driver to an ESC/P printer driver such as the LQ-850/1050, LQ-510/550/1010, LQ-200, LQ-500, LQ-860+/1060+, LQ-2550, LQ-800/1000, or LQ-1500. If you are in Windows 95 or 98, you can use Microsoft's LQ-570, LQ-570+, LQ-870, LQ-1070, LQ-1070+, LQ-1170 and LQ-2170 ESC/P2 printer driver. The Windows 95 ESC/P2 drivers do support User Defined sizes. The above procedures apply any time you specify a User Defined page size such as checks, small envelopes, or sheet fed labels, to name a few.

What are the default dip switch settings for the LQ-1170?

The printer has two sets of dip switches. From the factory, dip switch 1-1/2/3 are ON, 1-4/5/6/7/8 are OFF. For the second set, dip switch 2-1/2/3/4 are all OFF. For more information on setting dip switches, please see Chapter 3 page 6 of your User's Guide.

I'm replacing my LQ-1050 with the LQ-1170. Can I use the same serial interface that I used on the LQ-1050, with the LQ-1170?

No, they cannot be interchanged. The LQ-1050 uses a Type-A interface and the LQ-1170 uses a Type-B interface. You can purchase an additional serial interface from EPSON Accessories.

Does the LQ-1170 support Apple EtherTalk?

Yes, with the optional Ethernet/EtherTalk interface card available through EPSON Accessories.

The printer starts printing too far down the page. Is there any way I can adjust the starting point of the print job?

There is a feature called Microfeed that allows you to adjust the top-of-form (TOF) position in increments of 1/180th of an inch. To use this feature, load the paper into the printer. Hold down the ALT and the LF/FF buttons to Microfeed the paper backward or the ALT and the LOAD/EJECT buttons to Microfeed the paper forward. Once you have the TOF position set where you want it, send a print job. The printer will remember the TOF setting and will position the print head accordingly for the next page. For more information on adjusting the page setting, please see your User's Manual.

What driver should I choose in my MS-DOS program?

Choose from any of the following printer drivers: LQ-2170, LQ-2070, LQ-570+/LQ-1070+, Action Printer 5000+, Action Printer 5000, LQ-870/1170, LQ-850+/1050+, LQ-850/1050, LQ-510/550/1010, LQ-670, LQ-200, LQ-500, LQ-860+, LQ-2550, LQ-2500, LQ-800/1000, LQ-1500.

Can I use the platen knob to load and adjust paper?

No, the platen knob is not to be used to load or adjust paper. The knob should only be used to clear paper jams after the printer has been turned off. Use the Load/Eject button to load or remove paper and the Microfeed feature to adjust the top-of-form position of the paper.

Draft is not on the list of fonts. Can I access the printer's front panel fonts from Windows?

You can access the Draft and resident printer panel fonts from Windows if you are using the LQ-570+, LQ-1070+ LQ-870 or LQ-1170 Scalable font drivers. Drivers can be downloaded from the EPSON Website.

How do I install the printer driver in Windows 3.1?

Insert the disk into the appropriate disk drive. Open the Control Panel and double-click on the Printers icon. In the Printers dialog box, click on the Add button. Select "Install Unlisted or Updated Printer," then click on Install. An Install Driver dialog box will appear on your screen. If the driver disk is in drive A: click on the "Browse" button and select the directory MSWIN. Click OK two times to get back to the Install Driver dialog box, then click OK again to see a list of printers. Choose the LQ-1170 ESC/P2 driver and click OK to begin installing the driver. When the installation is complete, the LQ-1170 ESC/P2 should appear in the Installed Printers box. Make sure the printer is on LPT1 or whichever LPT port you are using, then click on the Set as Default Printer button. Click on Close and you are done installing the printer driver.

My printer will not power-on at all when I connect the parallel cable. What should I do?

Disconnect the cable from the back of the printer and see if the power comes on. If the printer turns on after disconnecting the cable, you probably have a cable problem. Try a different cable, making sure that it is fully-shielded and preferably six-feet or less in length. If a different cable still has the same problem, try "masking" pin 31 on the cable connector that attaches to the printer. If you decide to mask pin 31, use masking or electrical tape.

Why does my printer print garbage from MS-DOS and Windows?

When a printer prints garbage, it usually indicates a faulty cable or a loose connection. Power OFF your printer and computer. Disconnect and reconnect the cable on the printer and computer. Once the cable has been reconnected, power the printer and computer back ON. Try printing from MS-DOS. If you are still getting garbage, change the cable. We recommend getting a fully shielded cable, preferably 6 feet or less in length. If you are still experiencing problems after changing your cable, you may have a computer or printer port issue. If you take the cable and printer to another computer and it works fine, have your computer's port checked by an authorized dealer. If it still gives you garbage from another computer, have the printer taken in to be serviced.

Why won't the printer print serially from my PC?

If you are using a straight through modem cable, change the cable to a null modem cable (pins 2 and 3 are reversed). If you are already using a null modem cable, ensure that the Default Settings for the serial port on the printer match the settings on your computer. There is always the possibility of a loose connection or a bad cable. Disconnect and reconnect the cable on the PC and the printer and try printing again. If you are still experiencing difficulty, try a different cable or take the printer to another computer to see if the computer's port is malfunctioning.

What is the recommended duty cycle for the printer?

The specification recommended is 25 percent. Epson's definition of a 25 percent duty cycle stands for the printer printing (not idle) for two hours per day based on an eight hour day at 22 days per month.

Why does the printer stop or pause in the middle of a print job?

The printer has a built-in sensor that monitors the temperature of the print head. When the print head begins to get too hot, the printer may pause or slow down the speed of the print head unit to ensure that the print head does not overheat. If the print head begins to overheat, the thermistor will stop the print head completely until it has cooled down. Once the print head has sufficiently cooled down, the printer will resume the print job. Another reason for the printer to pause or stop can be that the printer is waiting for more data or is in the middle of processing data already received.

What are the most commonly used escape codes?

Some commonly used escape codes include (in decimal values) - Reset (27, 64); Set page length in lines (27, 67, n - where n is a number from 1 to 127); Carriage return (13); Line feed (10); Form feed (12); Select 1/8-inch line spacing (27, 48); 10 cpi (27, 80); 12 cpi (27, 77); Select bold font (27, 69); Cancel bold font (27, 70); Select italic font (27, 52); Cancel italic font (27, 53); Turn underline on/off (27, 45, n - where n equals 49=ON or 48=OFF); Select condensed print (15); Cancel condensed print (18). For more escape codes, please refer to the Command Summary of your User's Manual.

When printing a multiple page document on single sheets, the first page prints correctly, but the pages after start printing too low.

The difference in print position is usually caused by the page length setting in the software application program. Most applications have a default page length of 66 lines per page when using 11" continuous paper. When using single sheets, the printer automatically provides a small top and bottom margin. Since the top and bottom margins are non-printable areas, the maximum number of lines per page is reduced from 66 to 61 lines per page. Many applications have an option to change the number of lines per page. You should change the number of lines per page to 61. If the program offers a selection for "cut-sheet feeder," change the paper type to cut-sheet feeder.

I'm printing serial, my baud rate is at 9600, and intermittently the printer will lose data. What can I do to correct this?

If you are using a non-buffered serial interface board and XON/XOFF is enabled, the XOFF signal may not reach the printer in time to delay data transmission that would result in an overflow and loss of data. If you can use a DTR setting, change XON/XOFF to DTR. If you must use XON/XOFF, try decreasing the baud rate. Another option would be to purchase a 32KB buffered serial interface card (C823071). The buffered serial interface has a flag reset timing, which sets aside additional buffer space to "catch" the data overflow. The flag reset timing feature settings are selectable through dip switches on the serial interface card.

I was printing labels and one of the labels peeled off. Now my paper won't feed. Can I remove the platen to get the label out?

No, you cannot remove the platen from the printer. If you press the LF/FF button and the label does not appear on the platen for you to remove, you will need to take the printer in to be serviced. When printing labels, it is recommended that you only print with a pull tractor. Labels have a tendency to curl and peel off underneath the platen when being fed through the rear push tractor.

There is paper loaded on the tractor unit. Why won't the printer load paper?

Make sure the paper release lever is set to the tractor position. Facing the back of the printer, make sure the paper is loaded over to the left side of the printer. The paper sensor is located on the left side of the printer. If the sensor does not sense that there is paper loaded, the printer will not operate properly.


Fungsi Control Keyboard dalam Microsoft EXCEL

Ctrl+Z Undo
Ctrl+C

Enter,
Ctrl+V
Ctrl+X
Copy,

Paste,
Multiple Paste,
Cut
Ctrl+F,
Ctrl+H
Find,
Find&Replace
Ctrl+P,
Ctrl+S, Ctrl+F4, Alt+F4
Print,
Save, Close,
Close
Excel
Ctrl+Arrow Move to edge of region
Ctrl+*
Select current region
Ctrl+A Select all cells
Ctrl+Home
Ctrl+End
Select
A1,
Select
last cell in used range
Ctrl+Shift+End Select from active cell to last cell in used range.
Ctrl+Shift+Home Select from active cell to A1
Ctrl+Page
Down
Ctrl+Page
Up
Move
to the next sheet,
Move
to the previous sheet
Ctrl+Tab Move to next open workbook
Ctrl+N Open new workbook
Shift+F11 Insert new worksheet
Shift+F3 Paste function window
=+FunctionName+Ctrl+A Insert new function
Alt+F11 Open VBE
Ctrl+Shift+Enter Array formula
Ctrl+F3,

F3

Define name,

Paste name

Ctrl+Spacebar

Shift+Spacebar

Select columns,

Select rows

Ctrl+1,
Ctrl+B, Ctrl+U
Format cells, Bold, Underline
Ctrl+;
, Ctrl+shift+:
Current date, Current time