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 cs@bytebrothers.com.
Microsoft, XP, Vista, Windows 7, Office and Excel are
registered trademarks of the Microsoft Corporation.
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
DeleteI cannot get the Install_RWC_driver to install in window 10 pro. Any help here?
ReplyDeleteHi, Can you explain what is the error message you are getting?
DeleteOdd things about how the Office365 home doesn't like macros much.
ReplyDeleteI suspect I could modify the macro to Open Office or Libre. I don't understand the calls to retrieve the data from the RWC. I was hoping the reports were either comma delimited or freeform, accessible as would be a USB drive. Apparently not.
Any help?
Anyone rewritten the software for a different office suite - in Linux or MacOS or Windows?
Odd things about how the Office365 home doesn't like macros much.
ReplyDeleteI suspect I could modify the macro to Open Office or Libre. I don't understand the calls to retrieve the data from the RWC. I was hoping the reports were either comma delimited or freeform, accessible as would be a USB drive. Apparently not.
Any help?
Anyone rewritten the software for a different office suite - in Linux or MacOS or Windows?
Odd things about how the Office365 home doesn't like macros much.
ReplyDeleteI suspect I could modify the macro to Open Office or Libre. I don't understand the calls to retrieve the data from the RWC. I was hoping the reports were either comma delimited or freeform, accessible as would be a USB drive. Apparently not.
Any help?
Anyone rewritten the software for a different office suite - in Linux or MacOS or Windows?
USB requires the host equipment, working frameworks and peripherals to help three parts of the work. The current load up is for the most part used to help USB work control chipsets, motherboards are additionally furnished with USB interface attachment, and notwithstanding the backplane connector, the load up likewise put to the side a USB pin, you can associate the frame front As a USB interface for simple use (note that the wiring to the motherboard manual deliberately read the guide and press interface, don't pick some unacceptable leaving gear harm). micro pc usb
ReplyDelete