Home

Electronic Audiogram Program User Manual Part 3

image

Contents

1. Firms Test Subjects Classification Codes in New Codes Occupation Codes in New Codes from C WorkSafeBC Audiogram backup backup data 2009 09 21 12 33 5 dat completed You will see the following message if you have bypassed all the tabs to restore data WorkSafeBC Audiogram Session 1 Ed J No backup data restored 26 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Understanding Parameters in Parameters Tab Parameters tab contains all the parameters that control the audiogram program You can change any one of the parameter values to customize the audiogram program But before you change any of the parameters you should understand their purpose and the impact of your changes n Save Ctrl 5 je WorkSafeBC Audiogram File Path a ee 1 Session 1 2 Default Drive le WorkSafeBC Audiogr i c WorksafeBC Audiogramioutput 4 WorkSafeBC Audiogram File Name Form 5 Archived Data Unload File Path c WorkSafeBC Audiogram archive 6 Archived Data Unload File Name Audiogram 7 Backup Data File Path c WorkSafeBC Audiogram backup 2 Data Files Path c WorkSafeBC Audiogramidata 9 WorkSafeBC Audiogram Webpage File Path c WorkSafeBC Audiogram webpage 10 Audiogram Window Zoom 192 11 Audiogram Chart Zoom 90 12 Data Entry Validation Yes 13 Reset Noise History tab After Export Data Yes 14 Reset Noise Control tab After Export Data No 15 Res
2. Restore Archived Data to Data En ry Utilities d Unload Archived Data To File Backup All or Selected Data sheets tabs Load Archived Data From File Restore All or Selected Backup Data Sort Archived Data By Test Date About WorkSafeBC Audiogram ograms Report eegene D 7 of 60 Electronic Audiogram Program User Manual Part 3 of 3 When you see the next message box click OK to continue or Cancel to WorkSafeBC Audiogram Session 1 abort the archive process Archive exported audiogram data Next you will asked if you want to archive all the hearing tests inthe BE Audiogram Data Entry tab Click Yes to move all the hearing tests geg or No to only move the hearing tests that you have selected ge A At this point you can also click Cancel to abort the archive process You will see the following message if you click No and have selected an empty row in the Audiogram Data Entry tab Click OK to close the message window 0 records archived Either you are archiving all or only the selected hearing tests you will see the following message to confirm the number of hearing tests that have been archived Click OK to close the message window LD 3 records archived Restore to Data Entry Move to Long Term Audiogram working Data Archive Audiograms dre stored here after generation They can be retrieved to the Audiogram Data Entry sheetfor correction and r
3. 3 wippgm E OMFView SI laudiogramFirm dat My Recent Reports sudinnramFirm I dei hiii RMcMs EI WorkSafeBC Classification Code Sept 25 2009 dat RPM aw NEE yrunsheet EI WorkSafeBC Occupation Code Sept 25 2000 det Ruth fm SDR Service Delivery Reporting sortlib sortlibdec2bin sortlibin2dec mild Task Management Transaction Log 3 wageloss Winword File name Files of type pata Files dat WorkSafeBC Audiogram Session 1 AL You clicked Cancel in the file dialog box Click OK to continue You should see the follow message box WorkSafeBC Audiogram Session 1 A Click OK to close the message box 43 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Updating Occupation Codes Tab From time to time WorkSafeBC will send out an update file for the classification codes in the Occupation Codes tab An example of the file name is WorkSafeBC Occupation Code Sept 25 2009 dat This function will load the occupation codes and their descriptions into the Occupation Codes tab and also remove any occupation codes in the New Codes tab that exist in the updated Occupation Codes tab Here are the steps to load the occupation codes from the update file You should have received the occupation code update file in an email from WorkSafeBC Save the update file into a folder in your PC In our example we have saved the update file WorkSafeBC Occu
4. 1 files loaded Note the audiogram archived files used will NOT be deleted because this is a copy function You should see the loaded hearing tests in the Long Term Archive tab The load process also added the Load Date and Time CC CD GE GE CG This Record Load Has Been Create Date and Last Updated Date Sequence Location Test Subject First Name Generated Time and Time Load Date and Time Number 548380 Test Company 001 John Y 2010 03 08 07 42 17 2010 04 19 08 23 21 1 548380 Benny Construction Ltd 001 John Y 2009 09 11 08 00 27 2009 10 05 12 20 12 2010 04 19 08 23 21 2 548380 S amp A Excavating Ltd 001 Amy Y 2010 03 05 09 42 47 2010 04 19 08 23 21 3 19 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Doing a Full Backup of Data in the Audiogram Program Data from each of the tabs can be backed up into a backup file in just seconds We recommend regularly backing up the data in your EAP This backup allows recovery of all or part of the data as desired This function is also useful when you need to copy all the data in your current version of the EAP to a new version see Appendix F During the backup process you can choose to backup all the tabs or only backup the tabs you want Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Backup sub menu and then click on the Backup Data option
5. A Xx Q x B PO search IC rer Address Ej Desktop v Go H es Size Type Date Modified oy my Documents System Folder E E My Documents d My Computer System Folder D H My Computer Kl Network Places System Folder d hdireomoe yar anon Sp Bin ad P Bes CG Microsoft Office Outlook System Folder jp Add New Programs 1KB Shortcut 2008 08 19 8 40 AM BS adobe Reader 9 2KB Shortcut 2009 08 22 5 35 AM RCM 2KB Shortcut 2009 05 06 3 21 PM amp CMS Learning Site 1KB Internet Shortcut 2007 08 23 9 01 AM Efile 1KB Shortcut 2006 02 13 2 49 PM GAT RightFAX Faxutil 3KB Shortcut 2007 11 09 10 34PM Z Snagit 8 2KB Shortcut 2007 10 01 12 34PM WCB 2KB Shortcut 2002 06 27 9 54 AM S WES Procedures Manual 1KB Internet Shortcut 2009 04 30 12 31PM ZS Benny txt 1KB Shortcut 2007 10 02 12 46 PM ep Calculator 2KB Shortcut 2007 10 15 8 29 AM FY Command Prompt 2KB Shortcut 2009 01 29 8 21 AM a Control Center 2KB Shortcut 2007 10 01 12 33 PM E DB2 Command Editor 2KB Shortcut 2007 10 01 12 33 PM Gi File Shredder 1KB Shortcut 2008 09 08 7 35 AM EP Magnifier 2KB Shortcut 2009 04 16 11 05 AM ap Notepad 2KB Shortcut 2009 01 14 2 18 PM 8 Remote Desktop Connection 2KB Shortcut 2007 12 21 2 02 PM L lz viet erter Client 2KB Shortcut 2008 02 14 9 39 AM ED Shortcut to FE 6OCT 2KB Shortcut 2008 10 08 8 59 AM D TestTrack Client 1KB Shortcut 2008 12 19 11 29 AM WCB KM Share 1KB Shortcut 2003 06 23 12 36 PM ER Windows Explorer 2KB Shortcut 2009 09 15 8 56 AM
6. Click the sign besides My Computer to expand it 7a My Network Places Si Recyde Bin Select the C drive and click the File menu at the top of the Windows Explorer window Edit View Favorites Tools Help OQ O B Ze E Address DC 51 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Select the New item in the next popup window and then click on Folder as the new item E co view F E i as ete Briefcase Properties 3 Pl Microsoft Office Word Document WCB C P i Microsoft Office PowerPoint Presentation Close d AtTraceTool Trace Settings File a 1 E Text Document EF Microsoft Visio Drawing GA Wave Sound al Microsoft Office Excel Worksheet compressed zipped Folder Next you will see a new folder is created with the folder name as New Folder K Ref zz ms e ps mz zess em em eo e ess e E zb zm e rees GC File Folder 2009 09 15 9 09 AM Type Data as the name of the new folder and press the Enter key DEN oT oT e zem g meg em m mer mmm File Folder 2009 09 15 9 09 AM Now you have just created a new folder called Data in the C drive 52 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Appendix C Displaying the Developer Tab In EXCEL 2007 Click the Office button at the top of the EXCEL window Work Safe BC Audiogram Data Page Layout Formulas Review View
7. Help 4 EA i Bak A gt Si A Search E Folders EBk ai x Address E C Data Folders x Name E Desktop el er pian lw i My Documents EI d My Computer audiogramFirmCU zip El ge WCB C D EH apps audiogramFirmCU dat iA RSort audiogramFirm zip Select the audiogram program Select the File menu item at the top of the Windows Explorer window and click the Rename option SI Edit View Fave Open New Print save As Scan for Viruses Open With File Shredder Send To New H Create Shortcut 59 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Now you can change the name of the previous version of the audiogram program File Edit View Favorites Tools Help O Back kA a A Search E Folders Hab a x address EQ capata Folders x Name Ei Desktop H B My Documents E My Computer audiogramFirmCu zip EI ge WCB C R apps audiogramFirmCU dat I A B ret audiogramFirm zip Save the new version of audiogram program sent to you by WorkSafeBC in the same folder in your PC Open your previous version of audiogram program Backup data from all the tabs to the backup file See section Backup Data from the Audiogram Program for detail instructions Close your previous version of audiogram program Open the new version of audiogram program See section Start Audiogram Program for detail instructions on starting
8. SE backup data 2008 12 16 12 24 23 dat E backup data 2008 12 16 12 29 44 dat backup data 2008 12 16 12 35 12 dat backup data 2008 12 17 11 48 15 dat E backup data 2009 01 14 09 13 22 dat backup data 2009 01 23 12 22 32 dat E backup data 2009 04 24 08 17 13 dat E backup data 2009 04 24 08 51 25 dat E backup data 2009 06 12 10 32 48 dat E backup data 2009 06 12 10 35 13 dat backup data 2009 06 15 09 40 42 dat E backup data 2009 06 23 08 36 27 dat E backup data 2009 09 21 10 16 51 dat IE backup data 2009 09 21 11 11 10 dat File name Files of type Backup Files dat Tools k You will be asked if you want to restore data to each of the tabs that has backup data in the file you selected Click No to those tabs that you want to bypass restoring data You will see messages similar to this if there is backed up data for each type of data WorkSafeBC Audiogram Session 1 Restore Parameters tab 25 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Note If you click Yes the data in the Parameters tab will always be overwritten because you cannot append backup data to parameters You will see the next message to confirm which tabs were restored and the location and name of the backup file the data is restored from WorkSafeBC Audiogram Session 1 i Backup data restored to Parameters Audiogram Exported Data Audiogram Archived Data
9. Work Safe BC Audiogram Program x Insert Page Layout Formulas Data Review View Developer Generate Audiagram File Print Audiogram Print Audiogram Report b Charts CG Archive Exported Data Restore Archived Data Unload Archived Data To File Backup b About WorkSafeBC Audiogram Next you should see the next window for you to select the audiogram archive file you want to use Select the file you want to use and click the OK button to continue Please select one or more archive files to load 66 Audiogram form 1 2009 09 21 08 26 21 ar My Documents Ki My Network Places Tools 7 The following message box will be displayed to confirm the number of file and number of hearing tests that have been loaded into the Audiogram Data Archive tab 16 of 60 Electronic Audiogram Program User Manual Part 3 of 3 WorkSafeBC Audiogram Session 1 Eg All audiogram archived files that have been used will be deleted You should see the hearing tests that have been loaded back to the Audiogram Data Archive tab from the file The load process also added the date and time these hearing tests are loaded CC CD CE CF CG 1 This Record Load Firm Has Been Create Date and Last Updated Date Sequence 2 Number Location Test Subject First Name Generated Time and Time Load Date and Time Number 3 614069 Benny Construction Ltd 001 Jane Y 2009 09 10 13 43 39 4 614069 Be
10. data in the Audiogram Data Entry tab If it is set to No then no validation is done while you are entering data in the Audiogram Data Entry tab However all the fields in the Audiogram Data Entry tab are always validated before they are saved This parameter should be set to No for users that want to speed up the data entry of hearing tests into the Audiogram Data Entry tab This parameter should be set to Yes for first time users that want to get immediate feed back 31 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Reset Noise History tab After Exported Data Parameter 8 Reset Noise History tab After Export Data Yes This parameter control whether the fields in the Noise History tab in the Audiogram Form will be reset to blanks after the data is exported to the Audiogram Data Entry tab If this parameter is set to Yes then all the fields in the Noise History tab will be reset to blanks If this parameter is set to No then all the fields in the Noise History tab will not be reset to blanks WorkSafeBC Audiogram Session 1 bh ke S SAFE BC eae 110 WORKING TO MAKE A DIFFERENCE Firm Name Benny Construction Ltd Firm No 614069 Location No 001 am Test Subject First Name John Last Name Smith Age 37 Occupation Office Assistance sss sSSSSSS Search Test Subject Test Method Noise Control Test
11. size of the audiogram form window when it is first opened You can also control the window size once the window is opened with the Zoom control buttons The new zoom percentage is saved in this parameter each time you change the window size So the next time you open the audiogram form window it will be the same size when you close the window See section Change Audiogram Form Window Size in section Audiogram Form Mode Functions in Part 2 of the user manual for instructions to change the form window size WorkSafeBC Audiogram Session 1 MALLI SAFE BC zeen WORKING TO MAKE A DIFFERENCE Firm Name B amp B Automotive Ltd Firm No 235859 LocaionNo o1 Search Test Subject First Name John Last Name Doe Age 22 Occupation Technician Search Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen 1st Five Letters of Surname DOE Social Insurance No Gender Male Birth Date 1987 09 LEE YYYY MM Occupation Code 1116621 Search Safety Hygiene Inspection Officer Classification Code 764006 Search Auto Service Or Repair Years At That Occupation 5 Data Entry Validation Parameter 7 Data Entry Validation Yes This parameter controls whether validations are done on the fly while you are entering data in data entry mode If it is set to Yes then each field is validated while you are entering
12. using computers with screenshots for every step in the instructions and likely errors This manual is updated as new features are added 2 of 60 Electronic Audiogram Program User Manual Part 3 of 3 TABLE OF CONTENTS PREFACE EE 2 ELECTRONIC AUDIOGRAM PROGRAM OVERVIEW ccccceccccccccccccccccccccccccccccccccccccecccecceccccccecsccccccsccccccscccccceccccccecccccceccccccccsccccccscecs 2 SETTING UP FIRMS FOR ENTERING HEARING TESTS ccccceccccccccccccccccccccccsccccccsccccccsccccccsccccccecsccccececcccecsccccccsccccccscccccceccccccececeecs 5 E tee ONC ee TR et EE 5 Method Two Loading WorkSafeBC s Firm Data fie 5 ARCHIVING HEARING TESTS cbsiseiccacciccctesccececnccacsetencdicnancceecuetanecanevacesonaleiecuvesienasanatewec vec euceumetaneieveseadsewatebacevescuebenaloseceuebanesenetaceewabeness 6 RESTORING ARCHIVED HEARING TESTS ccccccscsecscscsccccsccccccsccccccscccsccscsccccscsccccccsccccccscccsccsccccccsccccccscsccccccsccccccscccsccscccsccsescccccescscses 9 MOVING ARCHIVED DATA TO A FILE AND THE LONG TERM ARCHIVE ccccccccccccccecccsccccccccccccccccccccccececsceccccccccccccccccecececececsccs 11 FILE LOCATION AND FILE NAME FOR AUDIOGRAM ARCHIVE EE 13 MOVING ARCHIVED DATA BACK FROM A FILE cccccccecccccccccccccsccccccsccccccsccccccacscccccceccccccsccccccscececcscccccceccccccececccceccccccecsccccccscecs 16 Kleng 17 COPYING ARCHIVED DATA INTO THE LONG TERM ARCHIVE cccccecececcccccc
13. 16 12 35 12 dat backup data 2008 12 17 11 48 15 dat backup data 2009 01 14 09 15 22 dat backup data 2009 01 23 13 23 23 dert backup data 2009 04 24 08 17 13 dat backup data 2009 04 24 08 51 25 dat backup data 2009 06 12 10 32 48 dat backup data 2009 06 12 10 35 13 dat backup data 2009 06 15 09 40 42 dat backup data 2009 06 23 08 36 27 dat backup data 2009 09 21 10 16 51 dat AVNVOMVVGYOVSVUUV3y 4 backup data 2009 09 21 11 11 10 dat File name Files of type pckup Files dat Electronic Audiogram Program User Manual Part 3 of 3 You will see a message like this for every item in the backup that contained data Click the Yes button to overwrite the existing data and continue WorkSafeBC Audiogram Session 1 Restore backup data to Audioagram Exported Data tab Overwrite existing data No Cancel Microsoft Excel CH Firm location 001001 is invalid Must be 3 digits with no space 24 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Restoring Data to Selected Tabs Click the No button when you are asked if you want to restore backup data to all tabs WorkSafeBC Audiogram Session 1 Select the backup file you want to use Click the OK button to continue Please select backup file to restore E backup data 2008 12 16 08 58 11 dat E backup data empty dat d backup data 2008 12 16 12 15 37 dat My Recent E backup data 2008 12 16 12 18 17 dat
14. 2 0 Object Library Click the File menu item at the top of the Microsoft Visual Basic window Select and click the Close and Return to Microsoft Excel option Eie Edit View Insert Format Debug Run Ga Save Work Safe BC Audiogram v112 xls Ctri S Import File Ctri M Export File Ctrl E Remove AudioPgm d i Print Ctri P e d Ze amer d F a 57 of 60 Electronic Audiogram Program User Manual Part 3 of 3 When you are returned to the Excel window Click the Office button at the top left corner of the EXCEL window Work Safe BC Audiogram vw112 xls Corr Page Layout Formulas Data Review View Developer Add Ins A Prepare F UT Publish a Ir D Di Wi F lc CH a S F Now your EXCEL program is setup to run the audiogram program Refer to the Start Audiogram Program section for instructions on how to start up the audiogram program 58 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Appendix F Moving to a New Version of the Electronic Audiogram Program When there are extensive changes in the new version of audiogram program you must move all your data from your old version to the new version of the audiogram program 1 Rename your previous version of audiogram program Open the Windows Explorer window and find the folder where you saved your audiogram program File Edit View Favorites Tools
15. 78 Products Ltd _ 060 ron Canadian Forest Select rows to restore 004378 __ Products Ltd 060 ken 5 Mat H Audiogram Data Enty Audiogram Data Archive Long Term Archive a ae WER i EK i Then click on the Restore to Data Entry Button WorkSafeBC Audiogram Session 1 Eg When you see this message box click OK to continue or Cancel to abort the Restore selected archived data Cancel restore process WorkSafeBC Audiogram Session 1 E This message confirms the number of hearing tests that have been restored Click OK to close the message window LD 1 archived records restored 9 of 60 Electronic Audiogram Program User Manual Part 3 of 3 You will see the following message if you have selected an empty row in the WorkSafeBC Audiogram Session 1 X Audiogram Data Archive tab Click OK to close the message window A No records to restore 10 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Moving Archived Data to a File and the Long Term Archive Over time hearing tests will accumulate in the Audiogram Data Archive tab It will become more difficult to find the hearing tests that you want A good way of keeping these older hearing tests is to backup the tests and then load them into the Long Term Archive We provide a button to do this as shown below Audiogram working Data Archive Audiograms are stored here after g Don They c
16. AAitelt enert ra This parameter makes up part of the name for the audiogram data file that will be generated See section Generate Audiogram Data File in Part 1 of the user manual for instructions on how this parameter is used ny V3 2012 05 22 15 54 09 dat 29 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Archived Data Unload File Path Parameter 4 Archived Data Unload File Path c WorkSafeBC Audiogram archive This parameter specifies the folder where the archived data unload file will be created See section Move Archived Data To A File in Part 3 of the user manual for instructions on how to unload archived data to a file The WorkSafeBC Audiogram and the archive folders will be created if they do not exist You can change the drive and folder names in this parameter and the new folders will be created the first time when they are used by the audiogram program Archived Data Unload File Name Parameter 5 Archived Data Unload File Name Audiogram This parameter makes up part of the name for the archive data file that will be created See section Move Archived Data To A File in Part 3 of the user manual for instructions on how this parameter is used n form 1 2009 09 21 08 26 31 arc 30 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Audiogram Window Zoom O Parameter x 6 Audiogram Window Zoom o 100 This parameter controls the
17. About WorkSafeBC Audiogram You will be asked if you want to backup data from all the tabs Click Yes to backup all the tabs in the audiogram program This message confirms which tabs were backed up and the location and name of the backup file created Backup data from Parameters Audiogram Data Entry Audiogram Data Archive Long Term Archive Firms Test Subjects Classification Code in New Codes Occupation Code in New Codes tabs to c WorkSafeBC Audiogram backup backup data 2012 06 05 Click the OK button to 16 31 13 dat completed close the window If you click the No button to select which tabs you want to backed up you will be asked about each one on turn 20 of 60 Electronic Audiogram Program User Manual Part 3 of 3 File Location and File Name for Backup File The folder location of the backup file is setup in the Parameters tab The c WorkSafeBC Audiogram backup folder will be created if it does not exist Follow these steps if you want to backup to a removable drive jump drive or flash drive 1 2 3 4 Plug in your removable drive to the computer Open Windows Explorer and check the drive name of your removable drive Change the Backup Data File Path parameter value to point to the removable drive Backup your data Of course you can also copy the backup file from the c WorkSafeBC Audiogram backup folder to your remov
18. Add Ins Click the Excel Options button at the bottom Recent Documents S 1 Work Safe BC Audiogram vll e I cS Open 2 Work Safe BC Audiogram Program Dec 08 Dee Led 3 Pilot Audio Lab xls e Danai 4 Work Safe BC Audiogram Program xls EI 5 Work Safe BC Audiogram vill se EI l 6 Work Safe BC Server Audiogram xls i l Bi ji 7 Alberta Sask xls D amp Scanned Audiogram Validation xls EI W are 9 RRSP Investments xls E audiogram file layout xls EI pop Print audiogram And Medical History Extract wink o Work Safe BC Audiogram vl06 xls EI A Prepare IAS DB SQL QueryVO4R1xls aI viewing list Sept 2009 xls E Send b Scanned Audiogram Validation vl0 xls EI RRSP Investments xlsx EI de Publish Extract All Firm and Classification wO lem Work Safe BC Audiogram Program xlsm E e y Dose Work Safe BC Audiogram v110 xls EI EI WCE Timesheet vu dem J Excel Options Exit Excel 53 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Select the Popular option at the left if it is not selected Check the Show Developer tab in the Ribbon checkbox then click the OK button to close the Excel Options window Excel Options E Change the most popular options in Excel Formulas Proofing Top options for working with Excel Save Show Mini Toolbar on selection 77 Advanced ial mg Customize Maan Glas Add Ins Color scheme Trust Center Screentip style Show feature descriptio
19. Audiogram Program User Manual Part 3 of 3 Audiogram Chart Zoom G Parameter 11 Audiogram Chart Zoom 90 This parameter controls the size of the audiogram charts You should adjust the size of the chart to fit the size of your computer monitor screen This parameter applies to all the different types of audiogram charts HE G D E E G H ES OO F a a John Doe Left Ear Audiogram Chart on 2009 09 2 3 4 Frequency in KHz Pitch 39 Frequency in KHz Pitch Test Subjects Audiogram Exported Data Audiogram Archived Data L amp R Ears Line Chart Audiogram E Medical History Reminder For Type Types of Baseline and 1st Time In Noisy Industry Parameter Medical History Reminder For Test Types of Baseline and 1st Time In 13 Noisy Industry Yes i Some audio labs have a policy of always entering medical history information for workers that are taking the hearing test the first time This parameter control whether a reminder message is displayed when the medical history fields are not entered for test types of Baseline or 1 Time In Noisy Industry 35 of 60 Electronic Audiogram Program User Manual Part 3 of 3 You will see the following message box if you set this parameter to Yes the test types is 1 Time In Noisy Industry and the all the medical history fields are blank This is just a reminder and you can still click the Yes button to save the
20. Electronic Audiogram Program User Manual Part 3 of 3 WORK BC WORKING TO MAKE A DIFFERENCE Electronic Audiogram Program User Manual Part 3 of 3 Created by Benny Yu Revised by Ken Rushton May 2012 1 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Preface This user manual is split into three word documents so they are of a manageable size Part 1 Introduction amp Getting Started how to enter hearing tests in the simpler Form Mode generating audiogram data files sending them securely to WorkSafeBC though our portal Part 2 Walks you through entering hearing tests in the traditional Data Entry Mode Part 3 Instructions on the maintenance and update of this audiogram program plus the appendix with technical instructions related to the audiogram program This volume Supported is the audiogram program running in Microsoft s Excel 2003 Excel 2007 and Excel 2010 This manual shows Excel 2007 examples Electronic Audiogram Program Overview The Electronic Audiogram Program EAP is a program embedded in a Microsoft Excel workbook It replaces the paper form and incorporates many features to assist in entering accurate error free audiograms in the field It also assists in sending in the information to WorkSafeBC Finally it includes a set of reporting functions that may assist you in your work This highly detailed manual is designed to assist audio labs that have little or no experience in
21. Results tory Medical History Hearing Medical History Gen A At a previous job B Off the job power tools rock music etc C In the armed forces Shooting History A Do you have you hunted B Shot trap skeet target not hand guns C Shot hand guns 32 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Reset Medical History Hearing tab After Export Data Parameter 9 Reset Medical History Hearing tab After Export Data Yes This parameter control whether the fields in the Medical History Hearing tab in the Audiogram Form will be reset to blanks after the data is exported to the Audiogram Data Entry tab If this parameter is set to Yes then all the fields in the Medical History Hearing tab will be reset to blanks If this parameter is set to No then all the fields in the Medical History Hearing tab will not be reset to blanks WorkSafeBC Audiogram Session 1 WORKING TO MAKE A DIFFERENCE Firm Name B amp B Automotive Ltd Firm No 285859 Location No 001 Test Subject First Name John Last Name Doe Age F Occupation Technician Search Test Subject Test Method Noise Control Test Results Noise History Have you ever had A A visit to an ear doctor in the last 5 years B A severe ear infection E Ear surgery F Dizziness or balance problems G A serious head injury H Expose to a loud blast or explosion A he
22. S Firm Test Subject Classification C 2 Number Firm Name Location First Name Code d Canadian Forest Products a 060 Mac 5 4 004378 Canadian Forest Products Ltd O60 03006 1 5 004378 Canadian PorestP Le 060 Mac 03008 1 y 20 LUG LO 9 fix ve Parameters y You can move a block of hearing tests by selecting them before starting the archive function or you can move all the hearing tests 6 of 60 Electronic Audiogram Program User Manual Part 3 of 3 You can select a block of or just one hearing tests by selecting the first column of the targeted rows Firm Firm Test Subject Test Subject 2 Number Firm Name Location FirstName LastName 3 4 614069 Benny Construction Ltd 001001 Jane Doe amp AExcavating Ltd 001 Jane Doe amp A Excavating Ltd 001 Don Jone amp A Excavating Ltd 001 Fatrick More nny Construction Ltd 001 Jane Doe anny Construction Ltd 001 Jane MacDonald anny Construction Ltd 001 John Smith Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Data Archive sub menu and then click on the Move Data Entry s option ca Home Insert Page Layout Formulas Data Review View Developer Add Ins A Loz ep r r a ireatejAudiogram Report By Class Reset Benerated Indicator on selected rows Long Term Archive
23. Session 2 xls and set the Session parameter to 2 See Appendix H in Part 3 of the user manual for details instructions on how to create special purpose audiogram programs When the technician is conducting the two hearing tests he opens both audiogram programs and opens the audiogram forms in each audiogram program It is not mandatory that you have to set the Session parameter for the second audiogram program to 2 But if you don t then it is not easy to distinguish between the two forms The audiogram form with Session set to 1 will have a normal audiogram form background color WorkSafeBC Audiogram Session 1 omg 100 WORKING TO MAKE A DIFFERENCE Firm Name 8 amp B Automotive Ltd Firm No 285859 Location No 001 Search Test Subject First Name John Last Name Doe Age 22 Occupation Technician Search Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen 1st Five Letters of Surname DOE Social Insurance No Gender Male x Birth Date 1987 09 Calendar YYYY MM Occupation Code 1116621 Search Safety Hygiene Inspection Officer Classification Code 764006 Search Auto Service Or Repair Years At That Occupation 5 The audiogram form with Session set to 2 will have a light yellow audiogram form background color 28 of 60 Electronic Audiogram Program User Manual Part 3 of 3 WorkSaf
24. Unload File Path c WorkSafeBC Audiogram archive A Archived Data Unload File Name Audiogram 7 Back b Data File Path Woroalebl AuUCOodramDacKUp 8 Data Files Path c WorkSafeBC Audiogram data 3 WorkSafeBC Audiogram Webpage File Path c WorkSafeBC Audiogram webpage 10 Audiogram Window Zoom 192 11 Audiogram Chart Zoom 90 12 Data Entry Validation Yes 13 Reset Noise History tab After Export Data Yes 14 Reset Noise Control tab After Export Data No 15 Reset Medical History Hearing tab After Export Data Yes 16 Reset Medical History Gen tab After Export Data Yes 17 Reset Test Subject After Export Data Yes 18 Reset Occupation After Export Data No Medical History Reminder For Test Types of Baseline and i 19 1st Time In Noisy Industry Yes 20 Save Workbook After Each Test Resultis Saved 0 21 IAT Business Number 66 22 Validate Firm Number and Classification Before Save Test Yes 23 Print Audiogram After Form Mode Save Yes 24 Firm name contains location details No 25 Batch File Size Limit 1100 26 Batch File Size Limit Warning Message 80 4 HI Audiogram Data Entry Audiogram Data Archive Long Term Archive Parameters H The file name of each audiogram archive file is comprised of six parts 066 Audiograml 2012 06 05 12 26 34 arc Part 1 is the IAB number udiograml 2012 06 05 12 26 34 arc Part 2 is the Archived Data Unload File Name from the Parameter
25. able drive i B 1 Session 1 2 Default Drive Je 3 WorkSafeBC Audiogram File Path c WorkSafeBC Audiogram outpurt 4 WorkSafeBC Audiogram File Name Form 5 Archived Data Unload File Path c WorkSafeBC Audiogram archive 6 Archived Data Unload File Name Audiogram Backup Data File Path Data Files Path 9 WorkSafeBC Audiogram Webpage File Path 0 Audiogram Window Zoom n k c WorkSafeBC Audiogram backup c WorkSafeBC Audiogramidata c WorkSafeBC Audiogram webpage Nk 11 Audiogram Chart Zoom 190 12 Data Entry Validation Yes 13 Reset Noise History tab After Export Data Yes 14 Reset Noise Control tab After Export Data No 15 Reset Medical History Hearing tab After Export Data Yes 16 Reset Medical History Gen tab After Export Data Yes 17 Reset Test Subject After Export Data Yes 18 Reset Occupation After Export Data No Medical History Reminder For Test Types of Baseline and i 19 Ist Time In Noisy Industry Yes 20 Save Workbook After Each Test Resultis Saved 0 21 IAT Business Number 66 22 Validate Firm Number and Classification Before Save Test Yes 23 Print Audiogram After Form Mode Save Yes 24 Firm name contains location details No 25 Batch File Size Limit 1100 26 Batch File Size Limit Warning Message 80 The file name of each backup file is comprised of four parts backup data 2009 09 21 11 11 10 dat 21 of 60 Electronic Audiogram Prog
26. age File Path Parameter WorkSafeBC Audiogram Webpage File Path c WorkSafeBC Audiogram webpage This parameter specifies the folder where the audiogram webpage files and audiogram report webpage files will be generated See section Save Audiogram Report As Web Page in Part 1 of the user manual for instructions on how to generate audiogram webpage file and section Print Audiogram Report For Saved Hearing Tests in Part 1 of the user manual for instructions on how to generate audiogram report webpage file The WorkSafeBC Audiogram and the webpage folders will be created if they do not exist You can change the drive and folder names in this parameter and the new folders will be created the first time when they are used by the audiogram program 4O of 60 Electronic Audiogram Program User Manual Part 3 of 3 Updating Classification Codes Tab From time to time WorkSafeBC will send out an update file for the classification codes in the Classification Codes tab An example of the file name is WorkSafeBC Classification Code Sept 25 2009 dat This function will load the classification codes and their descriptions into the Classification Codes tab and also remove any classification codes in the New Codes tab that exist in the updated Classification Codes tab Here are the steps to load the classification codes from the update file You should have received the classification code update file i
27. an be retrieved to the geg i Will be prosppted for correction and re generation a date range At year s end or whenever you prefer you can move these records to the Long Term Archive Test Subject Test Subj FirstName Middle Na Canadian Forest 3 004378 Products Lid 060 ron S Canadian Forest 4 0043 8 Products Lid 060 ken 5 5 H 4 H Audiogram Data Entry Audiogram Data Archive Long Term Archive I ee Fa i D The Move to Long Term option first moves the old hearing tests to an archive file them oads the archived data into the Long Term Archive tab B 1 FESS o ATOR 3 EEE EEE EE CC CD CE do you or This Record Firm Firm Has Been Create Date and Last Updated Date 2 Number Location Test Subject First Name Generated Time and Time Le 3 548380 S amp A Excavating Ltd 001 Patrick Y UUY UY 11 U u4 08 4 548380 S amp A Excavating Ltd 001 Don Y 2009 09 11 08 03 07 5 614069 Benny Construction Ltd 001 Jane Y 2009 09 11 07 48 08 6 614069 Benny Construction Ltd 001 Jane Y 2009 09 10 13 43 39 7 614069 Benny Construction Ltd 001 John Y 2009 09 11 08 00 27 a 61 4069 1 Benny ConstructionLtd 001001 Jane lt 10 Y 2009 09 17 13 01 55 9 10 The date ran selection is by Create Date and Time between the from and to dates you specify not by test date 11 of 60 Electronic Audiogram Program User Manual Part 3 of 3 First you should see the following input box f
28. aring aid now or inthe past J A relative with hearing loss before age 50 i d g z g gt z H Do you now have A Trouble understanding speech A B Ringing in your ears 33 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Reset Medical History Gen tab After Export Data Parameter KN 10 Reset Medical History Gen tab After Export Data Yes This parameter control whether the fields in the Medical History Gen tab in the Audiogram Form will be reset to blanks after the data is exported to the Audiogram Data Entry tab If this parameter is set to Yes then all the fields in the Medical History GenY tab will be reset to blanks If this parameter is set to No then all the fields in the Medical History GenY tab will not be reset to blanks WorkSafeBC Audiogram Session 1 Maelig SAFE BC TR 400 WORKING TO MAKE A DIFFERENCE Firm Name B amp BAutomovelid SS Firm No 285859 Location No 001 Search Test Subject First Name John Last Name Doe Age 22 Occupation Technician Search Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Have you ever had A Diabetes B Malaria or T B D Meningitis E Heart disease or heart attack F High blood pressure G A Stroke Smoking History A Do you smoke cigarettes now B Did you in the past 34 of 60 Electronic
29. cccccccccecscsccccccccccccccccccececececcccccccccccccccececscececccccccccees 18 DOING A FULL BACKUP OF DATA IN THE AUDIOGRAM PROGRAM nsesssssssssssssseessseesssersseeerssersesrsserersserrssrrrssereeerrrssrrrssrresserreorrrsorreesrereserreorereeeree 20 FILE POCATIONCAND FIFE NAMEFOR BACKUP FILE EE 21 RESTORING BACKUP DATA TO AN AUDIOGRAM PROGRAM cccccccccscccccccccccccccccccccccccccccsccccccscccsccecccccceccccccecsccccccsccccccsccccccececs 23 EE 25 UNDERSTANDING PARAMETERS IN PARAMETERS TAB cccccccccccececscsccccccccccccccccccecscscsceccccccccccccccccececscscsccccccccccccccecececscecsccecs 27 POSES SII aM ME erases ee EE 28 WORKSAFEBG AUDIOGRAM FILE PATH PARAMETER iiss ciccvodseren Lee ened sauelsGupceesenaanieasetunvaeuctacsauesiapieesewaaneensdueseluee ENE 29 AWORKSAFEBC AUDIOGRAM FILE NAME PARAMETER EE 29 ARCHIVED DATA UNLOAD FILE PATH PARAMETER ictecoticeacdasistbicohadaevaseceaeceavedensdact a eae tenia hewsdata a a eia an 30 ARVO DATA ON OAO FILE NAME PA A eet 30 AUDIOGRAM WINDOW ZOOM PARAMETER scsscscoccsceccscaccscccecscoucecoesecesscscecateecseeecseascssaesecassesassecnssecsseecseeecstaecesausscassecassecasaecasaecataess 31 DATA ENTRY VALIDATION EEGEN EE E EN RESET NOISE HISTORY TAB AFTER EXPORTED DATA PARAMETER eet De eege eege 32 RESET MEDICAL HISTORY HEARING TAB AFTER EXPORT DATA BARAMETER 33 RESET MEDICAL HISTORY GEN TAB AFTER EXPORT DATA PARAMETER sssscccc
30. csseccccecessccccecseccsseesecesseueeescsseeeeecesseeeeecesseueessesseeusesesseenessestenes 34 AUDIOGRAM CHART ZOOM A CAR AINE TE EE 35 MEDICAL HISTORY REMINDER FOR TYPE TYPES OF BASELINE AND LST TIME IN NOISY INDUSTRY PARAMETER nsssssssesesesesneseseseseserrerereseseseresreresese 35 ECKE GEREEST e 37 SAVE WORKBOOK AFTER EACH TEST RESULT IS SAVED BARBAMETER 37 RESET NOISE CONTROL TAB AFTER EXPORT DATA PARAMETER nessssssssesesesesesrerereseseseserverestststsrertrtsts trte re verts ts trte re rests ts tsere resestserorreeseserenereenene 38 CONTRACTOR NUMBER IN HOUSE NAME PARAMETER EE 39 AD aeei DEA same NETE A E S e EEPE One EET PEEN E E A deer d ebe 39 VALIDATE FIRM NUMBER AND CLASSIFICATION BEFORE SAVE TEST PARAMETER ccsceccccecccceccecececcecescscescscseecusescuseecseeecscassscasesceseecesaecususcssaees 40 WORKSAFEBC AUDIOGRAM WEBPAGE FILE PATH DARAMETER 40 UPDATING CLASSIFICATION CODES TAB EEN 41 UPDATING OCCUPATION CODES TAB ork aetteteeeIGSR Rae SSR ee ee ee 44 DISPLAYING THE AUDIOGRAM PROGRAM VERSION ccccccceccccccsccccccsccccccscccccccccccccccsccccccsccccccscececcecccccceccccccecsccccecccccccccccccccscecs 47 APPENDIX A OPENING WINDOWS EXPLORER cccccccececcccccsccccccsccccccsccccccscccccceccccccccscccccceccccccscecccceccccccececcccccsccccccscecccceccceecs 48 Electronic Audiogram Program User Manual Part 3 of 3 APPENDIX B CREATING A DATA FOLDER coc scccuiscsserscaiasstenendnntss
31. e generation At year s end or whenever you prefer records to the Long Term Archive You should see the hearing test that you have selected in the Audiogram Data Archive tab moved to Data Archive Firm bject Test 2 Number Firm Name s IL fame _ Middle f anadian Forestk roducts Ltd 060 ron S Canadian Forest 4004378 Products Ltd _ 060 ken S Eong Term Archive 8 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Restoring Archived Hearing Tests Each time you generate an audiogram data file for hearing tests that have been saved in the Audiogram Data Entry tab these hearing tests are archived to the Audiogram Data Archive tab after the file is generated If you want to make changes to the hearing tests in the Audiogram Data Archive tab you must move them back to the Audiogram Data Entry tab first You can also move hearing tests that have not been generated from the Audiogram Data Archive tab back to the Audiogram Data Entry tab so you can include them in the next generated audiogram data file correction and re geney At year s end or whenever you prefer you can move these records to the Long TermArchive You must select one hearing test or a block of hearing tests by selecting the first column of the Firm irt Test Subject Test Subj d i gt Number Firm Name cation FirstName Middle Na Canadian Fore 3 0043
32. eBC Audiogram Session 2 mmm zm WORKING TO MAKE A DIFFERENCE Firm Name B amp B Automotiveltd Firm No 235859 CLocationNo o Search Test Subject First Name John Last Name Doe Age 22 Occupation Technician Search Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen ist Five Letters of Surname DOE Social Insurance No Gender Male Birth Date 1987 09 Calnndar YYYY MM Occupation Code 1116621 Saach Safety Hygiene Inspection Officer Classification Code 764006 Search Auto Service Or Repair Years At That Occupation 5 WorkSafeBC Audiogram File Path Parameter 2 WorkSafeBC Audiogram File Path c WorkSafeBC Audogrammoufput This parameter specifies the folder where the audiogram data file will be generated See section Generate Audiogram Data File in Part 1 of the user manual for instructions on how to generate audiogram data file The WorkSafeBC Audiogram and the output folders will be created if they do not exist You can change the drive and folder names in this parameter and the new folders will be created the first time when they are used by the audiogram program WorkSafeBC Audiogram File Name Parameter J VYURA JdG Y AUT SIC Foie r ALNI LUI Ms Ac TELI S e FALRA TUOI curt WorkSafeBC Audiogram File Name Tromm D c o o Arahna Mata linliaaad Cila Dath ranr afa Ri
33. em mm k Fim Sa Window Help Select and click the References option Tools Add Ins Window Hel Macros Options VBAProject Properties Digital Signature 56 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Check each item in the References VBAProject window that has a check mark in the checkbox Uncheck checked items that begin with a Missing References VBAProject Available References Visual Basic For Applications Microsoft Excel 12 0 Object Library Microsoft Forms 2 0 Object Library Microsoft Office 12 0 Object Library Microsoft Visual Basic for Applications Extensibility 5 C IAS Helper COM Component 1 0 Type Library C IAS RADIUS Protocol 1 0 Type Library VideoSoft V5Spell 6 0 Control _ AccuSoft ImageGear ART component AccuSoft ImageGear 12 Activex C AccuSoft ImageGear 14 ABIC library AccuSoft ImageGear 14 Art library AccuSoft ImageGear 14 CAD library AccuiSoft TmaneGear 14 CGM lihrarv lt m gt Microsoft Visual Basic for Applications Extensibility 5 3 Location C Program Files Common Files Microsoft Shared WA WA WE Language Standard For example if there is a Missing in front of Microsoft Outlook 12 0 Object Library V Microsoft Outlook 12 0 Object Library Uncheck the checkbox and click the OK button to close the References VBAProject window C Microsoft Outlook 1
34. et Medical History Hearing tab After Export Data Yes 16 Reset Medical History Gen tab After Export Data Yes 17 Reset Test Subject After Export Data Yes 18 Reset Occupation After Export Data No Medical History Reminder For Test Types of Baseline and i 19 Ist Time In Noisy Industry Yes 20 Save Workbook After Each Test Resultis Saved o 21 IAT Business Number 66 22 Validate Firm Number and Classification Before Save Test Yes 23 Print Audiogram After Form Mode Save Yes 24 Firm name contains location details No 25 Batch File Size Limit 400 26 Batch File Size Limit Warning Message i OU HAH Audiogram Data Entry Audiogram Data Archive Long Term Archive Parameters Nw Codes Classification 27 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Session Parameter Kl Session 2 This parameter identifies the session number for the audiogram program In some test site the technician may need to conduct two hearing tests simultaneously If the technician is also entering the two hearing tests directly into the audiogram program using the form mode then the technician must create two audiogram programs one for each session The technician may creates one audiogram program called Work Safe BC Audiogram Program Session 1 xls and set the Session parameter to 1 And creates a second audiogram program called Work Safe BC Audiogram Program
35. gram folder see Appendix B in Part 3 of the user manual on how to create the c WorkSafeBC Audiogram Data folder Once the audiogramFirmCU dat file is saved to the c WorkSafeBC Audiogram Data folder you can search for any firm number firm location firm name and classification combinations in this file when you are entering a hearing test Detailed instructions on how to search a firm from the audiogramFirmCU dat file are in the section Entering Hearing Test Results In Data Entry Mode sub section Select Firm From The Firm Data File in Part 2 of this user manual 5 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Archiving Hearing Tests Each time you generate an audiogram data file the hearing tests saved in the Audiogram Data Entry tab are marked generated and moved to the Audiogram Data Archive tab You can also manually move hearing tests that have not been generated into an audiogram data file to the Audiogram Data Archive tab You might do this is when you have some hearing tests that are waiting for some information such as SIN or birth date Thus you can 1 Archive the hearing tests that are not ready to be sent to WorkSafeBC 2 Generate the audiogram data file for the other hearing tests that are ready 3 Restore the hearing tests that await additional information back from the Audiogram Data Archive tab back to the active Audiogram Data Entry tab Fim E
36. hearing test Or you can click the No button and enter data into the medical history fields WorkSafeBC Audiogram Session 1 Medical History for 1st Time in Noisy Industry test type should be entered Do you still want to save data Yes No 36 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Backup Data File Path Parameter 14 Backup Data File Path i c WorkSafeBC Audiogram backup This parameter specifies the folder where the backup file will be created See section Backup Data From The Audiogram Program in Part 3 of the user manual for instructions on how to backup data to a file The WorkSafeBC Audiogram and the backup folders will be created if they do not exist You can change the drive and folder names in this parameter and the new folders will be created the first time when they are used by the audiogram program Save Workbook After Each Test Result is Saved Parameter KN 15 Save Workbook After Each Test Result ts Saved Yes This parameter control whether the audiogram program Excel workbook is saved when the Save button in the Audiogram Data Entry tab is used to save a hearing test or when the Export Data button in the Audiogram Form is used to export a hearing test to the Audiogram Data Entry tab This parameter should be set to Yes for new users that are not familiar with Microsoft Excel or computer This eliminates the confusion
37. ing i sortib C sortlibdecz2bin My Documents i sortlibin2dec source salquery i ysalscript My Computer Task Management Transaction Log 3 wageloss 3 Winword File name Files of type pata Files e det Tools k You should see the follow confirmation message box WorkSafeBC Audiogram Session 1 A You clicked Cancel in the file dialog box Click OK to continue You should see the follow message box WorkSafeBC Audiogram Session 1 A Click OK to close the message box 46 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Displaying the Audiogram Program Version You can display the version number and version date of the audiogram program to verify what version of the audiogram program you are running You need to display the version date before and after you upgrade your audiogram program to verify the upgrade is run successfully See Appendix E in Part 3 of the user manual for instructions on how to upgrade your audiogram program code to a new version Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item and select the About WorkSafeBC Audiogram option Da cay Home Insert Page Layout Formulas Data Review View i j Menu Commands Developer Record Hearing Test Result Generate Audiogram File Print Audiagram Print Audiogram Report gt Note the opt
38. ion Log Files of type Data Files dat Tools The following message box is displayed to confirm the number of occupation code records that have been loaded Click the OK button to close the message box WorkSafeBC Audiogram Session 1 266 occupation code records loaded A B Occupation 1 Codes Occupation Descriptions 2 2155024 AERIAL ENGINEER PROFESSIONAL 3 7112269 AGRICULTURAL WORKER 4 6933 13 AIR CONDITIONING MECHANIC 5 6515024 AIRCRAFT ASSEMBLER 6 6962024 AIRCRAFT WORKER SROUND CREW 9173276 AMBULANCE DRIVER EMERGENCY VEHICLE a 7199847 ANIMAL CONTROL OFFICER 9 87 86028 ASBESTOS WORKER INSULATOR 10 8 136 5 ASPHALT WORKER 11 38333 26 ASSEMBLER 12 8513497 AUTO BODY SHOP WORKER 13 9315457 AUTOSTACKER OP GM HM 14 7511255 AVALANCHE CREW TRAIL CREW FOREST TECH 15 9317101 BAGGER WRAPPER TIEUP BUNDLER STRAP BALER 16 8213033 BAKER 17 2 92699 BAND TEACHER 18 4141129 BANK MACHINE OPERATOR 45 of 60 Electronic Audiogram Program User Manual Part 3 of 3 If you want to abort without loading the occupation update file click the Cancel button in the update file selection window Please select the occupation file for update Gm CC MX Precedence Rules wippam taudiogramFirm dat audiogramFirmCU dat B WorkSafeBC Classification Code Sept 25 2009 dat late r en TI we WorkSafeBC Occupation Code Sept 25 2009 dat spr Service Delivery Report
39. ions Charts L appear aS a pop up Data Entry d Archive d Utilities The version number and version date is displayed in the next message box Click the OK button to close the window 47 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Appendix A Opening Windows Explorer Click the start button at the lower left hand corner of your desktop tg Start Then click the All Programs option at the bottom of the next window Add New Magnifier Yu Benny Internet Fe My Recent Documents k Internet Explorer Gd EI My Computer ts E mail Microsoft Office Qutlook Ss My Reiwork Places My E Microsoft Visual Studio TEANS B Control Panel Le Notepad Ch Set Program Access and Defaults Visual Studio MET 2003 Frinters and Faxes Command Prompt Microsoft Visual Studio Help and Support 2005 Search LS Microsoft Office Excel 2007 2 Microsoft Office Word 2007 He ServiceCenter Client H Adobe Reader 9 E Calculator SnagIt 8 All Programs gt Pp Log Off ol Then select the Accessories option GH Set Program Access and Defaults 48 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Select the Windows Explorer item and click your right mouse button IN Accessibility e Communications H Entertainment TI Address Book E Calculator E Command Prompt e Notepad W Paint Al Program Compatibi
40. lity Wizard ey Synchronize Sp Windows Movie Maker e System Tools A Remote Desktop Connection Select the Send To item in the next popup window EH Accessibility H Communications m Entertainment QJ Address Book Calculator Command Prompt Notepad Paint A Program Compatibility Wizard Synchronize Tour Windows XP Run as Scan for Viruses Pin to Start menu File Shredder Copy Create Shortcut Delete Rename Sort by Name Properties 49 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Click on the Desktop create shortcut item in the next popup window Run as Scan for Viruses Pin to Start menu File Shredder ES Compressed zipped Folder 2 Desktop create shortcut KEE ACES Create Shortcut _ Mail Recipient Delete CH My Documents Rename a 4 DVD CD RW Drive D Sort by Name Properties You should see the Windows Explorer icon in your desktop Whenever you need to open the Windows Explorer window just double click click the left mouse button twice this icon Ten Windows Explorer 50 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Appendix B Creating a Data Folder Open the Windows Explorer program If you cannot find the Windows Explorer icon on your desktop see Appendix G on how to put the Windows Explorer icon on your desktop ar File Edit View Favorites Tools Help E
41. livery Reporting O sortlibdec2bin Task Management Sy Transaction Log O wageloss Winword The following message box is displayed to confirm the number of classification code records that have been loaded Click the OK button to close the message box WorkSafeBC Audiogram Session 1 6 3 classification code records loaded You should see the classification codes from the update file have been loaded into the Classification Codes tab 2 711001 Abattoir 3 762001 Accounting 4 713001 Acid Base Salt Chemical or Dye Manufacture not elsewhere specified 5 762002 Actuarial Services 6 766001 Acute Care 7 051800 Adjudication Errors Claims due to Misconduct or Costs Related to Injuries Aggravated Subsequent to Original Inju ER 762003 Administration of an Operation Conducted Outside BC 9 762004 Advertising or Public Relations Services 10 831003 Air Canada 11 763035 Air Navigation Support 12 741001 Aircraft and Aircraft Equipment Sales and Leasing 13 732002 Aircraft Fueling 14 732003 Aircraft Handling or Fueling 15 764001 Aircraft Maintenance or Repair 16 712001 Aircraft Automobile or Truck Assembly 42 of 60 Electronic Audiogram Program User Manual Part 3 of 3 If you want to abort without loading the classification update file click the Cancel button in the update file selection window Please select the classification file for update Precedence Rules
42. n an email from WorkSafeBC Save the update file into a folder in your PC In our example we have saved the update file WorkSafeBC Classification Code Sept 25 2009 dat in the c data folder Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Utilities sub menu and then click on the Update Classification Codes option Home Insert Page Layout Formulas Data Review View Generate Audiogram File Save Firms To File Print Audioagram Print Audiagram Report Load Firms From File Charts d Save Test Subjects To File Data Entry J Load Test Subjects From File Archive j Save New Codes To File Load New Codes From File Backup H WW pdate Classification Code About WorkSafeBC Audiogram The following window will be displayed for you to select the classification code update file In our example we have saved the update file WorkSafeBC Classification Code Sept 25 2009 dat in the c data folder Select the update file and click the OK button to continue 41 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Please select the classification file for update ESCHETTE Precedence Rules 3 wippam EI laudiogramFirm dat VS WorkSafeBc Classification Code Sept 25 2009 dat EI WorkSafeBC Occupation Code Sept 25 2000 det SDR Service De
43. ndicator on selected rows Backup All or Selected Data sheets tabs Clear Previous Audiogram Data Restore All or Selected Backup Data Print Previous Audiogram Data Report About WorkSafeBC Audiogram ioarams Report Next you should see the next window for you to select the audiogram archive file you want to use Select the file or files you want to use and click the OK button to continue fc Please select one or more archive files to load gt ys Ca Local Disk C Date moc 2012 06 C 7 e ProgramData 2012 06 C iene WAINA Organize s New folder dJi mvfslogs Name Date modified A New folder Eh 012 06 05 12 26 New folder 2 a ae nL 4U1 U5 5 13 54 47 arc 2012 05 25 1 54 PM J Perflogs WS ae Baon _ 999 Audiograml 2012 04 24 16 02 24 arc 2012 04 24 4 02 PM 18 of 60 Electronic Audiogram Program User Manual Part 3 of 3 The following message box lets you select either to append the test results to the Long Term Archive tab or clear the Long Term Archive before loading Click the Yes button to append or the No button to clear all the test results before loading WorkSafeBC Audiogram Session 1 Append Data To Existing Data The following message box will be displayed to confirm the number of file and number of hearing tests that have been loaded into the Long Term Archive tab 1 3 records in
44. nny Construction Ltd 001001 Jane Y e 5 548380 S amp A Excavating Ltd 001 Patrick Y 2009 09 11 08 04 08 2009 09 21 09 04 45 1 6 548380 S amp A Excavating Ltd 001 Don Y 2009 09 11 08 03 07 2009 09 21 09 04 45 2 7 614069 Benny Construction Ltd 001 Jane Y 2009 09 11 07 48 08 2009 09 21 09 0445 3 8 614069 IBenny Construction Ltd 001 John 7 2009 09 11 08 00 27 2009 09 21 09 04 45 4 9 Note You can select more than one audiogram archive file to load at the same time Select multiple files by selecting the first file by clicking on the first file then hold down the Shift key on your keyboard and click on the last file you want to select Click the OK button to process the files 17 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Copying Archived Data into the Long Term Archive You can load the hearing tests in an audiogram archived file to the Long Term Archive tab for use with Periodic hearing tests This allows you to easily compare the result of current and previous years Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Long Term Archive sub menu and then click on the Load Archived Data From File option EI Home Insert Page Layout Formulas Data Review View Developer Add Ins _CAudiogram D e a Create Audiogram Report By Class Reseq Generated I
45. ns in Screenvips Resources Create lists for use in sorts and fill sequences Edit Custom Lists When creating new workbooks Use this fant Font size 10 Default view for new sheets Normal View Include this many sheets 1 2 Personalize your copy of Microsoft Office Username by5s776 Choose the languages you want to use with Microsoft Office Language Settings Now you should see the Developer tab 54 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Appendix D Setup Your EXCEL Program to Run the Audiogram Program When you run the audiogram program in a computer the first time the EXCEL program in that computer might now setup to run the audiogram program Here are the instructions on how to setup your EXCEL program to run the audiogram program When you started the audiogram program if the Microsoft Visual Basic window is opened and a message box similar to the one below is displayed Then your EXCEL program is not setup to run the audiogram program yet fork Safe BC Audiogram Program xts running ThisWorkbook Code l Fi Edit View Insert Format Debug Run Tools Add Ins Window Help p gt tn 7 Col 11 i 7 it hul Z e SKS 3 ent Ze Project VBAProject x CS BEE IS p VBAProject Work Safe BC Audiogram Progra Private Sub Workbook Activate CN Microsoft Excel Objects is Chart Both Ears Bar Chart Audiogram Chart2 B
46. or the From Date beet eem SE Enter a date in the YYYYMMDD format and click the OK button to continue You can also select the Cancel button if you want to Enter From Date YYYYMMDD abort the unload process Next you should see the following input box for the To Date Wehr em Se Enter a date in the YYYYMMDD format and click the OK button to continue You can also select the Cancel button if you want to abort the unload process Enter To Date YYYYMMDD From Date 20120601 A message box will be displayed to show the number of archived records that have been unloaded and the file name and location of the file In our example the file name is G Audiogram form 1 2009 09 21 08 26 31 arc WorkSafeBC Audiogram Session 1 i l 4 archived record unloaded to c WorkSafeBC Audiogram archive 66 Audiogram form 1 2009 09 21 08 26 31 arc OK 12 of 60 Electronic Audiogram Program User Manual Part 3 of 3 File Location and File Name for Audiogram Archive File The folder location and file name of the audiogram archive file is setup in the Parameters tab The c WorkSafeBC Audiogram archive folder will be created if it does not exist EE Save Ctrl 5 je WorkSafeBC Audiogram File Path G O OO O o O 1 Session 1 2 Default Drive C WorkSafeBC Audiogram File Path L LI A a ol fe D DIOU EAF AE CAFE c WorkSafeBC Audiogram output Archived Data
47. oth Ears Line Chart Audiogram CH Sheet1 Dropdown Values Sheet 10 Default Data WI Sheeti1 Dropdown Data Mapping Wl Sheet 12 Dropdown Data Literal WI Sheet 13 Audiogram Data Sheet 14 Readme Sheet 15 Audiogram Archived Data HB Sheet 16 Occupation Codes WI Sheet 17 Classification Codes Loop GB Sheet 18 New Codes If Temp lt gt contractorNum Then Sheet 19 Help shtParm Cells 17 2 Temp cl Sheet2 menu End If gt a i ALA L tor Number his is the c pegib TitleName Click the OK button to close the message box Now you are in the Microsoft Visual Basic window with the audiogram program still running Next we will stop the audiogram program 55 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Click on the Run menu item at the top of the Microsoft Visual Basic window a Microsoft Visual Basic Work Safe BC Audiogram v112 xls ThisWorkbook Code d File Edit View Insert Format Debug Run Tools Add Ins Window Help Select and click the Reset option to stop the audiogram program Run tr Tools Add Ins Windc gt RunSub UserForm F5 H Break Ctri Break Design Mode Click the Tools menu item at the top of the Microsoft Visual Basic window a Microsoft Visual Basic Work Safe BC Audiogram v112 xls ThisWorkbook Code d File Edit View Insert Format Debug Run D W sse m
48. ovausdvnsnecsautenssessantdinpseeedsnatcestaautenseecdsunengeesuavonseeeendupestecdautunnnsescsuenees 51 APPENDIX C DISPLAYING THE DEVELOPER TAB IN EXCEL 2007 cccssccecccsccsccccccsccsscesccesceesesccssescecscescesseeseesonssessonsonssoesonss 53 APPENDIX D SETUP YOUR EXCEL PROGRAM TO RUN THE AUDIOGRAM PROGRAD cscssccecccsccsececccsscsscecccsssssesscsscnscessones 55 APPENDIX F MOVING TO A NEW VERSION OF THE ELECTRONIC AUDIOGRAM PROGRAM cssssccssccsecsecccccsccescecccsscesseesenes 59 4 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Setting up Firms for Entering Hearing Tests When you enter a hearing test result into the audiogram program you have to select a firm number firm location firm name and classification code combination for the hearing test There are two methods you can setup a firm number firm location firm name and classification code for use when you are entering data for a hearing test manual entry or loading our Firm master file Method One Manual Entry Enter the firm number firm location firm name and classification code in the Firms tab A B a A D Firm Firm 1 Numbers Locations Firm Names Classifications 2 123456 001 Benny Construction Ltd 421111 3 A Parameters New Codes Classification Codes Occupation Coded Firms T Subjects f The firm number and firm location fields in the Firms tab are mandatory Fi
49. pation Code Sept 25 2009 dat in the c data folder Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Utilities sub menu and then click on the Update Occupation Codes option Ba Work Safe BC Audiogram Progra Ciad Home Insert Fage Layout Formulas Data Review View Developer Add Ins Menu Commands Generate Audiogram File j Print Audiogram F save Firms To File Print Audiagram Report Load Firms From File Charts Save Test Subjects To File Data Entry i Load Test Subjects From File Archive d Save New Codes To File Load New Codes From File Backup Update Classification Codes About WorkSafeBC Audiogram The following window will be displayed for you to select the occupation code update file In our example we have saved the update file WorkSafeBC Occupation Code Sept 25 2009 dat in the c data folder Select the update file and click the OK button to continue 44 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Please select the occupation file for update wippam E laudiogramFirm dat SI audiogramFirmCU dat E WorkSafeBC Classification Code Sept 25 20009 dat E P a WorkSafeBC Occupation Code Sept 25 2009 dat SDR Service Delivery Reporting sortib sortlibdec2bin sortlibin2dec Task Management Transact
50. ram User Manual Part 3 of 3 Part 1 is always backup data Here is where on your C drive you will find the file 20 WorkSafeBC Audiogram 22 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Restoring Backup Data to an Audiogram Program Also useful when you need to migrate from your current version of the EAP to a new version During the restore process you can choose to restore data to all the tabs or only restore the tabs you want However you can only restore data to a tab if the backup file contains data from that tab Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Backup sub menu and then click on the Restore Backup Data option Home Insert Page Layout Formulas Data Review View Developer Tei About WorkSafeBC Audiogram i i e eo WAlarcleO afer Attert ene The expected message boxes will be displayed WorkSafeBC Audiogram Session 1 Restore backup data to all tabs Select the backup file Please select backup file to restore yon Wali Tose cic Lookin ERIC the OK button to A backup data 2008 12 16 08 58 11 dat backup data empty dat CO nti nue backup data 2008 12 16 12 15 37 dat My Recent backup data 2008 12 16 12 18 17 dat Documents backup data 2008 12 16 12 24 23 dat backup data 2008 12 16 12 29 44 dat backup data 2008 12
51. rect value H Default Drive Parameter Default Drive C This parameter specifies the drive name of the main hard drive in the computer where the audiogram program is running When the audiogram program is accessing the hard drive for any reasons this is the drive location it will use Occasionally a computer may be setup with another drive location other than c as the main hard drive Then you must change this parameter to the correct drive letter Not used now 39 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Validate Firm Number and Classification Before Save Test Parameter 4 Validate Firm Number and Classification Before Save Test No When a hearing test result is entered and the Save button in the Audiogram Data Entry tab or the Export Data button in the Audiogram Form is clicked to save the data to the Audiogram Data Entry tab The audiogram program has the option to check whether the firm number firm location and classification code combination entered is in the audiogramFirmCU dat file in the c data folder This parameter specifies whether the above validation will be performed Set this parameter to Yes if you want this validation to be performed every time you save a hearing test result Set this parameter to No if you want to suppress this validation to be performed every time you save a hearing test result WorkSafeBC Audiogram Webp
52. rm name can be any name you want to identify a firm number firm location and classification combination In fact you can even have two entries with the same firm number firm location and classification but with different firm names This is one way to separate hearing tests with the same firm number firm location and classification in the audiogram report This will be discussed in more details in the section Printing Audiogram Reports for Saved Hearing Tests in Part 1 of the user manual The Classifications field is optional because one may also search for the classification code when entering a hearing test Now this firm number firm location firm name and classification code entry can be selected when you are entering a hearing test Method Two Loading WorkSafeBC s Firm Data file A file with all the firm number firm location firm name and classification in the WorkSafeBC system is available to audio labs using the audiogram program This file is audiogramFirmCU dat and is available from us It is not sent out with the audiogram program initially If you wish to load it please request a copy from audiogram WorkSafeBC com It can be a considerable time saver To setup this file save or copy the audiogramFirmCU dat file to the c WorkSafeBC Audiogram Data folder If you cannot find the c WorkSafeBC Audiogram Data folder in your hard drive then just create a new folder called data on the c WorkSafeBC Audio
53. s tab A 2012 06 05 12 26 34 arc Part 3 is the Session number from the Parameters tab 13 of 60 _ Classification Code Electronic Audiogram Program User Manual Part 3 of 3 066 Audiograr l 2012 06 05 12 26 34 arc Part 4 is the date the archive file is created Part 6 is the file extension arc 066 Audiograml 2012 06 05 12 26 34 arc To find the file open your Windows Explorer see Appendix A on how to open Windows Explorer and click on the sign besides My Computer in the Folder panel on the left of the window to see the drives in your computer A X File Edt View Favorites Tools Help O O P O rh Folders Address Ei Desktop Folders AS Name Size Type Date Modified Ge Desktop 8 iLjmy Documents System Folder LE Aa Ring oman 4 My Computer System Folder E F My Computer tmy Network Places System Folder E gd My Network Places J Recyde Bin System Folder ai Recycle Bin internet Explorer System Folder Microsoft Office Outlool System Folder IS ft Office Outlook Id Click on the sign beside the C drive to expand the Deskto sub folders Here is a screen shot of my C drive H Yours will be different but you should see the C File Edit View Favorites Tools Help for your C drive A Q x gt P j Search py Folders Rn Address EI Desktop Folders S EI Desktop D VH My Documents E My Computer 78 Ze WER EH on
54. st Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen Noise Level dBA 93 956 Impact No Noise Contro C Hours Away Fom Noise Hours In Noise Before Do you regularly wear ear protectors gt 38 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Contractor Number In House Name Parameter KN 17 Contractor Number in House Name 66 This parameter makes up part of the name for the audiogram data file that will be generated See section Generate Audiogram Data File in Part 1 of the user manual for instructions on how this parameter is used It is very important that this parameter is setup properly because when a generated audiogram file is sent to WorkSafeBC this is the only information in the generated audiogram data file that identifies the origin of the file The first message box you see every time you open an audiogram program always ask you to confirm the contractor number or in house name in this parameter is correct The current Contractor Number In House Name Is setup as U Cancel Please validate this is the correct value KE When the new version of audiogram program is sent out this parameter is always set to 0 So the first time you open the new audiogram program you should enter your contractor number or in house name The current Contractor Number In House Name Is setup as Please validate this is the cor
55. that some users assume the Save button in the Audiogram Data Entry tab or the Export Data button in the Audiogram Form also save any changes they made in the audiogram program Excel workbook However this will slow down the data entry process because it usually takes a few seconds to save the Excel workbook This parameter should be set to Yes for users that prefer to control when the Excel workbook is saved This will soeed up the data entry process When a new audiogram program is sent out this parameter is default to Yes 37 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Reset Noise Control tab After Export Data Parameter 16 Reset Noise Control tab After Export Data No This parameter control whether the fields in the Noise Control tab in the Audiogram Form will be reset to blanks after the data is exported to the Audiogram Data Entry tab If this parameter is set to Yes then all the fields in the Noise Control tab will be reset to blanks If this parameter is set to No then all the fields in the Noise Control tab will not be reset to blanks WorkSafeBC Audiogram Session 1 haed S SAFE BC Seen 110 WOREING TO MARE A DIFFERENCE Firm Name Benny Construction Ltd Firm No 614069 Location No 001 search Test Subject First Name John Last Name Smith Age 37 Occupation Office Assistance search Test Subject Te
56. the sign to expand the sub folders i pus SECH ep WorkSaf Find the WorkSafeBC Audiogram folder and click BC Audiogram 14 of 60 Electronic Audiogram Program User Manual Part 3 of 3 You may only see the archive and output sub folders because the other folders are only created as needed Click on the archive folder CH Audiogram Reports CH backup CH output You should be able to find the file you have just unloaded on the right hand side panel 066 Audiograml 4012 06 05 12 26 34 arc You will need to remember the location of this file because this is the file you will select when you want to load these hearing tests back into the Audiogram Data Archive tab Note All hearing tests within the specified from and to date range will be moved even hearing tests that have not been sent to WorkSafeBC 15 of 60 Electronic Audiogram Program User Manual Part 3 of 3 Moving Archived Data Back from a File You can use this function to load the hearing tests from an audiogram archive file back to the Audiogram Data Archive tab Note that the audiogram archive file will be deleted to prevent the loading of duplicate data Click the Add Ins menu tab at the top of the Excel window to display the Audiogram menu command Click the Audiogram menu item select the Archive sub menu and then click on the Load Archived Data From File option
57. the audiogram program the first time Restore data from the backup file created in step 4 to all the tabs See section Restore Backup Data To an Audiogram Program for detail instructions Save the new version of audiogram program 60 of 60

Download Pdf Manuals

image

Related Search

Related Contents

船舶事故等調査報告書  RIDGID R3250 Instructions / Assembly  Operating Manual  Samsung CE137XAT-B User Manual  Untitled - GPS Standard  DG-Y03 取扱説明書  P alatray L - Heraeus Kulzer  Avaya T1 User's Manual  STON    

Copyright © All rights reserved.
Failed to retrieve file