You can download the Bytebrothers Realworld certifier software CD including the Driver and the Excel sheet tool from this link
Watch the tutorial to use this :
Contents of the Download:
- Install_RWC_driver: The Driver
- Readme_33D: Readme Document
- RWC1000_REV33z: Excel sheet tool to generate printable certificates
Please feel free to comment below if you have any questions about using the bytebrothers realworls certifier tool
TRANSFERRING TEST RESULTS TO YOUR PC
The program on this CD (RWC1000.XLS) is used to transfer the test reports that have been stored on the RWC to the PC. To run this spreadsheet program, you must have Microsoft Excel versions 97 or above. Excel 97 users are limited in the number of readings that can be transferred (usually 30 readings). There is no limitation when using newer versions (Excel 2000 and above). Byte Brothers RWC1000.XLS software works with Excel on Windows XP, Vista and Windows 7 operating systems.
To check the version number of the Excel program you are using, open the Excel application and choose HELP, then select ABOUT> MICROSOFT EXCEL. The version of Excel will appear in the upper left-hand corner. For example, Excel 2008 will appear as “MICROSOFT EXCEL 2008”.
TROUBLESHOOTING COMMUNICATION BETWEEN THE PC AND THE RWC1000
When working correctly, communicating between the Excel spreadsheet and the RWC is a 6 step process:
STEP 1: INSTALL THE RWC DRIVER ON PC (ONE TIME ONLY): Run "Install_RWC_driver.exe" (found on this CD). This driver is needed for the PC to talk to the RWC (this driver must be installed even if another driver appeared to be automatically installed when you first connected the RWC to your computer). The RWC does not need to be connected to the PC for this driver to properly install.
STEP 2: CONNECT THE RWC TO THE PC: Connect the RWC to a USB port on your PC (with the included cable) and turn the RWC ON.
STEP 3: RUN THE "RWC1000.XLS" SPREADSHEET (found on this CD). RWC1000.xls is itself an Excel spreadsheet that uses Excel's built-in macros to transfer the test results to your PC. Run RWC1000.xls directly from the CD or copy it to your hard drive. The RWC’s LCD display will immediately display “TALKING TO PC, UNSAVED READINGS ARE ERASED” when the PC is initiating communication with the RWC.
STEP 4: EXCEL FINDS THE RWC: After an approximate ten second wait, Excel notifies you that “ONE NETWORK TESTER FOUND” indicating that communication is established.
STEP 5: IMPORT THE READING TO EXCEL: A) Press the IMPORT READINGS button on the Excel screen to transfer the readings from the RWC's Printer Memory to the PC. B) Once complete, press the EDIT REPORT button to list the names of the tests that you are about to turn into an Excel Workbook (containing the spreadsheets). This is the opportunity to change any NAMES that you created when you initially saved the test results in the RWC (you can wait until the names are in the spreadsheet but it is quicker here). C) When satisfied with the names, press Finish. The Excel workbook named "RWC1000.XLS" will commence importing the readings. One cable test reading occupies one spreadsheet. Note on naming tests: The RWC automatically assigns a sequential number (1-250) to each stored test. The name appears as "Reading: Cable#1, Reading: Cable#2", etc. on the spreadsheet along with any custom name that you created. The "Reading #" can only be modified in the spreadsheet (not in the tester). The RWC1000 allows duplicate custom names but when they are printed in Excel they will appear as "Jack A", "Jack A (2)", "Jack A (3)", etc. unless you change the name usine the “Name changing filter.”
STEP 6: SAVE THE EXCEL WORKBOOK: Your Excel Workbook now contains up to 250 spreadsheets. You can do anything with this workbook as would with any Excel workbook (save it under a different name, change the names in the cells, etc.). When you are ready to print, select FILE, PRINT and in the PRINT WHAT dialog box select ALL. All of the cable test readings will print (one per page). If you wish, print some or all of the tests (each test prints on a separate sheet). Or email the file to your customer as proof of test. Note on saving the Excel file: Save the file using Excel's File>"Save as" so you don’t write over the original spreadsheet.
If, however, Excel displays the message “NO NETWORK TESTERS FOUND”, troubleshooting is required.
TROUBLESHOOTING CONNECTION PROBLEMS:
If, when you use Excel to run the RWC1000.XLS program, Excel displays “NO NETWORK TESTERS FOUND”, it means that a connection is not being made between the PC and the RWC. QUESTION: Did the RWC’s LCD display “TALKING TO PC, UNSAVED READINGS ARE ERASED” from STEP 3 (above)?
If it did not display this message it means:
1) The driver is not installed. See “Installing the RWC driver” above.
2) The RWC is not connected and powered ON.
3) Excel’s macro language is not running because Excel’s macro security setting is too high (see ADJUSTING EXCEL’S MACRO SECURITY SETTING at the bottom of the page) or
4) The PC’s COM port assigned to the RWC’s USB port is not functioning correctly. Use Microsoft’s Device Manager to change the COM PORT number associated with the RWC. This usually solves the problem. See immediately below.
How to use Microsoft's Device Manager to change the RWC’s USB COM PORT number:
MICROSOFT XP USERS: To get to Window's XP Device Manager, first select CONTROL PANEL, then SYSTEM, then HARDWARE, then DEVICE MANAGER. Select COMMUNICATIONS PORT (COM #), then USB/serial converter. Press the right mouse button and select PROPERTY, then the PORT SETTINGS tab, then ADVANCED. Change the COM PORT to another port number. Any COM port from 1 to 9 is acceptable. Once a new number is selected, PRESS OK and exit the program. Now, make sure the RWC is ON and run the RWC1000.XLS spreadsheet again. MICROSOFT VISTA AND WINDOWS 7 USERS: Microsoft Vista and Windows 7 has a slightly different sequence to get to the Device Manager: First, select CONTROL PANEL, then HARDWARE AND SOUND, then DEVICES AND PRINTERS, then DEVICE MANAGER. Select PORTS(COM&LPT), USB serial port (Note: The “USB serial port” will not appear on the list of devices unless the RWC is connected to the USB port and is powered ON). Press the right mouse button and select PROPERTY, then PORT SETTINGS, then ADVANCED. Change the COM PORT to another port number. Any COM port from 1 to 9 is acceptable. Once a new number is selected, PRESS OK and exit the program. Turn the RWC OFF and ON and run the RWC1000.XLS spreadsheet again.
ADJUSTING EXCEL’S MACRO SECURITY SETTING: Byte Brother’s RWC1000.XLS program on this CD uses Microsoft Excel’s Macro Language to transfer the data from the RWC1000 to the PC. When you first start the RWC1000.XLS spreadsheet you will be asked by Excel to “enable macros”. Answer YES to this question. If you are not asked this question, it means that Excel’s macro security setting is locking out the execution of macros. If this is your situation, you must adjust Excel’s macro security setting (see the following paragraph).
How to adjust Excel’s Macro Security setting to allow the execution of macros:
MICROSOFT PRE OFFICE 2007 EXCEL USERS: In Excel, select TOOLS; MACROS; SECURITY and set to LOW. Then SAVE your settings. The new security setting will remain even when you exit Excel so check with your security administrator to see if this is a problem.
MICROSOFT OFFICE 2007 AND ABOVE EXCEL USERS: Press the MS Office button (earlier versions have an orange button, later versions have a blue button with a MS logo), then EXCEL OPTIONS, then TRUST CENTER, then MS EXCEL TRUST CENTER, the MACRO SETTINGS. Set to LOW. Then SAVE your readings. The new security setting will remain even when you exit Excel so check with your security administrator to see if this is a problem.
IF PROBLEMS STILL EXIST
If problems still exist, visit ww.bytebros.com/bb_tester/tech_support/RWC1000_tech_support.htm and view a short installation video. You will find it very helpful. If you are still experiencing problems, please contact Byte Brothers tech support at +1 425 917 8380 or email@example.com.
Microsoft, XP, Vista, Windows 7, Office and Excel are registered trademarks of the Microsoft Corporation.