Electronic Audiogram Program User Manual Part 1
Contents
1. Trouble understanding speech location Medical History Hearing Ringing in your ears location Medical History Hearing Data not exported Switch to Data Entry Mode 50 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Medical History Gen Info Click the Medical History Gen tab to display all the fields for general medical history Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing i Medical History Gen Have you ever had A Diabetes B Malaria or T B yl D Meningitis E Heart disease or heart attack F High blood pressure G A Stroke a smoking History A Do you smoke cigareties now B Did you in the past You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Have you ever had A Diabetes ooo B Malaria or T B o o D Meningitis o o E Heart disease or heart attack F High blood pressure G A Stroke Have you ever had Diabetes A Diabetes B Malaria or T B D Meningitis Have you ever had B Malaria or T B y D Meningitis E Heart disease or heart attack 51 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A2. 20 35 15 5 H5 7 Right Ear You will see the charts for the current year and previous year hearing test results Don Jone Left Ear Audiogram Chart on 2003 08 Don Jone Right Ear Audiogram Chart on 2003 08 Frequency in KHz Pitch Frequency in KHz Pitch ees Laf Cura Year i Len Orevious Year amie Fight Curent Year Right Previous Year 61 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE You will also see the following message box displayed on top of the chart you can move the message box to one side when you review the chart Move the message box by placing the mouse pointer to the top of the box as shown in the following screen shot Then hold down the left mouse button and drag the box to the side WorkSafeBC Audiogram E W Eg J Close Chart When you have finished reviewing the chart click the OK button to close the chart window J Close Chart Next you will be asked if you want to hide the L amp R Ears Line Chart Audiogram tab which is the tab that displays the chart you have just reviewed Click Yes if you want to review or print the chart later Otherwise click No to hide the tab Microsoft Excel Do you want to hide the L amp R Ears Line Chart Audiogram tab See the next section Print Audiogram Chart In Form Mode in Part 2 of the user manual for detail instructions of printing the char
3. Audiogram Data Entry tab The Save Workbook A Se ener Eevee nee mais BC Audi File Path P WorkSafeBC Audi output 2 WorkSafeBC Audiogram File Pa c WorkSafe ucdiogram outp is Saved parameter Is 3 WorkSafeBC Audiogram File Name i Audiogram set to No by default 4 Archived Data Unload File Path c WorkSafeBC Audiogramiarchive 5 Archived Data Unload File Name Audiogram 6 Audiogram Window Zoom 410 7 Data Entry Validation Yes Reset Noise History tab After Export Data Yes Click the dropdown 9 Reset Medical History Hearing tab After Export Data Yes button on the right 10 Reset Medical History Gen tab After Export Data Yes hand side and select 11 Audiogram Chart Zoom 30 12 Construction Industry Firms Yes Yes from the Medical History Reminder For Type Types of Baseline and 1st Time In dropdown list 13 Noisy Industry Yes 14 Ee ee Daibh c WorkSafeBC Audiogram backup 111 Save Workbook After Each Test Result is Saved 160 Res ivi Gontro tan Atte marr TS WO 17 Contractor Number Iin House Name 66 18 4 DOaCKRUP Veale Cie rall 45 Save Workbook After Each Test Resultis Saved 16 Reset Noise Control tab After Export Data 17 Contractor Number In House Name 14 BACKUP Vata Fie ran 45 Save Workbook After Each Test Result is Saved 1R Raeat Mniss Control tah After Fynnrt Nata Now the Excel workbook that contains the audiogram program will be saved each time you click t
4. Gender Male 22 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Occupation Code Field fest Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen This field can be entered directly or select from the Select Occupation Code window Occupation Code Search Click on the Search button to bring up the Select TE Occupation Code window Occupation L Refer to the Select Occupation Code From The Occupation Codes Tab section under Data Entry Mode in Part 1 of the user manual for detail instructions on how to search an occupation code in the Select Occupation Code window Once you have found an occupation code for the hearing test in the Select Occupation Code window click the Select button Search By F Code C Description Occupation Code X Occupation Codes found 0 New Occupation Codes found 23 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE The Occupation Code field will be automatically filled in the audiogram form You will notice the description for the selected occupation code is displayed under the occupation code Airm Name Canadian Forest Products Ltd Firm No 004378 Location No og0 is Test Subject Name First Mac Mid Last Huff
5. A Wl ZI Select one of the valid values from the dropdown list for Type Worn Before Test Type Worn Before Test ud Note that there is an extra option None gt We find that this is a surprisingly common answer Type Worn Before Test None 7 Noise Control Note Unusual combinations of values are allowed as Hours Away From Noise we have found that some people are careless of their hearing Hours In Noise Before gt A Do you regularly wear ear protectors 35 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Test Results Info Click the Test Results tab to display all the fields in this tab Test Subject Test Method Noise Control Tet Results Poise History Medical History Hearing Medical History Gen Test Type TS Display Audiogram Charts Category of Test soe Rebay C __EREars Line Chart Frequency In kHz Pitch Reset ace I A a a a ar iwer Ta ar ar arara Ee Entering Test Type Field You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Test Type Baseline You can also type in the first character of each of the items in the dropdown list and the item will be automatically filled in for you 36 of 72 WORK BC Electronic Audiogram Program User Manua
6. Do you now have Ai Trouble nnderstandinna sneer h You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Do you now have A Trouble understanding speech B Ringing in your ears Do you now have Trouble understanding speech A Trouble understanding speech A Trouble understanding speech B Ringing in your ears Do you now have Ringing in your ears 49 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE B Ringing in your ears B Ringing in your ears Yes _ E Right ra Li If you have selected Yes for any of the above fields that have a related location field and you have not selected a value for the location You will see the following message box if you click the Finished Test button to save the hearing test The message will indicate which fields should be filled in WorkSafeBc Audiogram Session 1 The following fields must be entered A severe ear infection location Medical History Hearing Ear surgery location Medical History Hearing A serious head injury location Medical History Hearing Exposure to a loud blast or explosion location Medical History Hearing A hearing aid now or in the past location Medical History Hearing
7. Search By f FirstName Last Name Zoom 92 2 Huff Mac Occupation Geologist Last Name First Name 1 Test Subject found Cancel 18 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE The corresponding fields in the audiogram form will be automatically filled in The Age field will be calculated if the birth date field is filled in Arm Name Canadian Forest Products Ltd Eee aano nl 19 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Social Insurance No Field This field can be entered directly or selected as part of the test subject info from the Select Test Subject window It can be changed even after it is automatically filled in from the Select Test Subject window This field is a 9 digits social insurance number Social Insurance No WorkSafeBC Audiogram Session 1 You will see this error message if you enter a number less than 9 digits You will see this error if you try to enter a number with more than 9 digits or an invalid 9 digits SIN You will see this error message if you enter a non numeric character 20 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Birth Date Field This field can be entered directly or selected as part of the test subject info from the Select
8. Test Subject L amp R Ears Line Chart Audiogram yf a1 ee You will see the chart you would like to print FN a gt PY P lt Uj i John Doe Left Ear Audiogram Chart on 2009 09 ae a Oe PS OE fi a ee ae A ee ee ee co c0 4 op tn alwn a i jii TT Hi ATT AT EEE 42 i Frequency in KHz Pitch 43 Frequency in KHz Pitch AN 4 gt gt Test Subjects Audiogram Exported Data Audiogram Archived Data L amp R Ears Line Chart Audiogram 0 D Work Safe BC Audiogram Program xls Compat Home Insert Page Layout Formulas Data Review View Developer Add Ins AUdiogram Menu Commands 64 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Select the Print option to bring up the Print window Your printer name will be different because you will have a different printer setup my D ove E Printer XE Convert K A E Name gg VPRTPOIWPCP 16 v Properties Status Idle neas a2 ey Type Canon iR 5020 iR6020 PCL5e telltale NI Save s Preview and print the document Where RC21 iR6020 ISD Development Services a Print 10 2 112 249 Comment RC21 iR6020 ISD Development Services L Print to file 10 2 112 249 Print 2 Select a printer number of copies and other printing options before printing Print range Copies Publish F Igno
9. History Medical History Hearing Medical History Gen TestType Periodic Display Audiogram Charts Category of Test AC Reset 0 5 1 2 3 4 6 8 After you entered the previous year test results you can click on the Check Category button to calculate the Category of Test value 41 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Reset Test Results Function You can clear the test results for the left or right ears by clicking on the Left Ear or Right Ear reset button Frequency In kHz Pitch Ee 0 5 L 2 3 4 6 8 LetEar 20 z 30 40 45 20 15 Jo Right Ear 5 0 10 15 5 Jlo Jo x The test results for the left ear are cleared after clicking the Left Ear reset button Frequency In kHz Pitch Po 0 5 Pi 3 4 6 6 eter Al Al al ar ar al 4 RightEar 5 g o g 10 g 15 5 g o go 42 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Optional Fields The data fields in the Noise History Medical History Hearing and Medical History Gen tabs are all optional fields Test Subject Test Method Noise Control l Test Results Nose History Medical History Hearing Medical History Gen Entering Noise History Info Click the Noise History tab to display all the fields for noise history Test S
10. Occupation K Derrick Worker 1990 01 01 YYYYMM DD if Search 7 F Derrick Worker You will see this message if the occupation code contains non WorkSafeBC Audiogram Session 1 numeric characters You will see this error message if the occupation code is less than 7 digits or not found in the Occupation Codes and New Codes tabs If you see this message and you know the occupation code is valid then you should enter this occupation in the New Code tab for occupation code 24 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Years at That Occupation Field Enter a number in this field Years At That Occupation 10 WorkSafeBC Audiogram Session 1 You will see this error message if you enter a non numeric character You will see this error message if you enter a value greater than the test subject s age minus 12 because the earliest age for a worker is 12 31 12 19 25 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Test Method Info Click the Test Method tab to display all the fields in this tab sise Control Test Results Noise History Medical History Hearing Medical History Gen Defaults Test Booth eNe Type of Audiometer Date of Test Calendar YY YY MM DD Was your audiometer calibr
11. Yes and you have not selected a value for the additional fields You will see the following message box if you click the Finished Test button to save the hearing test The message will indicate which fields should be filled in 53 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE WorkSafeBC Audiogram Session 1 The following fields must be entered For how many years have you smoked Medical History Gen How many cigarettes per day do you or did you smoke Medical History Gen Data not exported 54 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Saving a Hearing Test Entered In Form Mode Once all the data for a hearing test is entered into the audiogram form You can save the hearing test result by clicking on the Finished Test button to save the data to the Audiogram Data Entry tab WoR K SAFE BC Toom gaip WORKING TO WAKE A DIFFERENCE Firm Name Canadian Forest Products Ltd Firm No 004378 Location No 060 Search Test Subject Name First Mac Mid Last Huff Age 99 Occupation Derrick Worker i 4 Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen Social Insurance No 473456789 Gender Male E Birth Date 4990 01 01 Calendar YYYY MM DD S
12. button saves all the audiogram data in the audiogram form that have been Save WLP J and then restore the session anytime and continue the data entry Load WLP Reloading saved Audiogram Data between Sessions The Load W I P button loads the data saved during the last time the Save W I P button was Clicked back into the audiogram form Tip you can use this to save a set of data like a template and load a prefilled set of WIP to Save yourself typing 67 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Saving Data and Exiting Audiogram Form The Save W I P Exit button will save all the audiogram data in the audiogram form that have been entered at that point into a temporary area before closing the audiogram form Resetting W LP in the Audiogram Form The Reset All button will clear all the WIP fields in the audiogram form Cancel The Cancel button will close the audiogram form without saving the data in the audiogram form that have been entered at that point into a temporary area Data that have been entered after the last time the Save All button was clicked will be lost Switch to Data Entry Mode 68 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Switching To Data Entry Mode Save WLP Load point Reset WLP The Data Entry Mode button will cl
13. from F No of years D Worn ear protectors while shooting E Shoulder shot from F No of years E Shoulder shot from i F No of years F No of years lt 10 10 20 21 44 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE If any one of the Shooting History field values is Yes and you have not selected a value for the additional fields You will see the following message box if you click the Finished Test button to save the hearing test The message will indicate which fields should be filled in WorkSafeBC Audiogram Session 1 The following fields must be entered Worn ear protectors while shooting Noise History Shoulder shot from Noise History No of years Noise History Data not exported Switch to Data Entry Mode 45 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Medical History Hearing Info Click the Medical History Hearing tab to display all the fields for hearing related medical history Test Subject Test Method Noise Control Test Results Noise Histor Have you ever had Medical History Gen A A visit fo an ear doctor in the last 5 years B A servere ear infection E Ear surgery F Dizziness or balance problems G A serious head injury H Expose to a loud blast or explos
14. in Part 2 of the user manual for detail instructions on how to search a firm in the Select Firm window After you have selected a firm in the dropdown box in the Select Firm window clicking the Select button to select the firm Fi Name Canadian Forest Products Ltd Location No The corresponding fields in the audiogram form will be automatically filled in The classification code is also filled in if the classification code is available in the selected firm in the dropdown list The description for the classification code is also displayed below the classification code E Classification Integrated Forest Management Classification Cod 703008 15 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering the Classification Code Field This field can be entered directly or selected from the Select Classification Code window even after it is automatically filled in when you selected a firm number firm location firm name and classification code from the Select Firm window Classification c Search Click on the Search button to bring up the Select Classification Code window Classification Code g Refer to the Select Classification Code From The Classification Codes Tab section under Data Entry Mode in Part 1 of the user manual for detail instructions on how to search a classification code
15. program if the Microsoft Visual Basic window is opened a lt i 2 and a message box similar to this Compile 3 Microsoft Excel Objects Chart1 Both Ears Bar Chart Audiogram Chart2 Both Ears Line Chart Audiogram Sheet1 Dropdown Values Sheet 10 Default Data not setup to run the audiogram program yet E sheets Dropdown Data Mapping Sheet12 Dropdown Data Literal B Sheet13 Audiogram Data Sheet14 Readme Sheet15 Audiogram Archived Data Sheet 16 Occupation Codes error sub or function not defined is X le error em Sie A Compie erro tcCutWorkbkName q lis i7 2 Microsoft Visual Basic displayed then your Microsoft Excel program is Sub or Function not defined If you see this message see Appendix D in Part 3 of the user manual for detailed instructions GB Sheet17 Classification Codes ace Sheet is New Codes If Temp lt gt contractorNum Then Sheet 19 Help shtParm Cells 17 2 Temp Sheet2 menu enh a os If you don t see a message box refer to Appendix D in Part 3 of the user manual for instructions on how to setup your Excel program to run the audiogram program 7 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Establishing Who You Are The EAP needs to know who you are in a business sense The Industrial Audiometric Bu
16. to hide the Microsoft Excel tab Do you want to hide the Both Ears Line Chart Audiogram tab See the section Print Audiogram Chart In Form Mode in Part 2 of the user manual for detail instructions of printing the chart in the Both Ears Bar Line Audiogram tab 59 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Displaying the L R Ears Line Chart Click on the LR Ears Line Chart button will display the test results for both ears in two separate line charts John Doe Left Ear Audiogram Chart on 2009 09 Frequency in KHz Pitch Frequency in KHz Pitch 60 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE If the test type is Periodic and the Previous Result fields are filled in Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen Test Type Periodice Display Audiogram Charts S pa Category of Test NC Check Category Both Ears Line Chart Reliability Good Previous Result Frequency In kHz Pitch 05 1 2 3 4 3 6 Reset LeftEar 10 7 25 7 30 x 10 20 15 gt 10 Left Ear Right Ear 19 7 0 25 10 25 10 10 Right Ear 5 L R Ears Line Chart 5 Previous Result letEar 5 m 30 25 15 15 10 RigtEar 5 10
17. DIFFERENCE Have you ever had D Meningitis E Heart disease or heart attack F High blood pressure Have you ever had E Heart disease or heart attack F High blood pressure G A Stroke Have you ever had Smokina History Have you ever had A Stroke G A Stroke Smoking History A Do you smoke cigarettes now You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Smoking History A Do you smoke cigarettes now she B Did you in the past Do you smoke cigarettes now B Did you in the past 52 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Did you in the past B Did you in the past If any one of the Smoking History field values is Yes you will see the following additional fields displayed smoking History A Do you smoke cigarettes now No B Did you in the past C For how many years have you smoked D How many cigarettes per day do you or did you smoke For how many years have you smoked How many cigarettes per day do you or did you smoke D How many cigarettes per day do you or did you smoke 10 20 Pad on If one or both of the first two Smoking History field values is
18. H EARS BAR CHART PRINTING AN AUDIOGRAM CHART FROM FORM MODE ssccccscscccccceccsccccccsccsscecscescsssesseescsssesseeees AUDIOGRAM FORM SPECIAL ACTIONS 3 scsscsssscccstesescocssvsnsocsscnssnsoceccsvsnssssscnvsnnscescuvassoocscntsnssocccnvansessccuvansse SAVING AUDIOGRAM DATA BETWEEN SESSIONS RELOADING SAVED AUDIOGRAM DATA BETWEEN SESSIONS SAVING DATA AND EXITING AUDIOGRAM FORM RESETTING W I P IN THE AUDIOGRAM FORM CANCEL SWITCHING TO DATA ENTRY MODE CHANGING AUDIOGRAM FORM WINDOW SIZE SAVING CHANGES IN THE AUDIOGRAM PROGRAM csccccscssccccccsccsscceccsscsscceccnscesceeccescesceesonscnsseesons SETTING A FULL SPREADSHEET SAVE AT EACH AUDIOGRAM SAVE 4 of 72 43 46 51 55 55 56 56 57 57 63 66 67 67 68 68 68 69 70 71 72 40 42 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Process Overview for recording and saving tests in the EAP and submitting them through the IAS CD n Ww Yy portal Step 1 One can enter data into the Electronic Audiogram Program EAP in two different ways A the slower but more understandable Form Mode or the quicker but less obvious Data Entry Mode If you are new to this use the Form mode This 2 Generated manual will help with this step Data e Step 2 Once you are through collecting data and gt entering it you will first export save the data as a dat
19. MAKE A DIFFERENCE The location field will be displayed only if you selected Yes E Ear surgery Yes zi F Dizziness or balance problems G A serious head injury l H Fzpose to a loud blast or exnlosion Have you ever had Dizziness or balance problems F Dizziness or balance problems A serious head injury H Expose to a loud blast or explosion Have you ever had A serious head injury G A serious head injury H Expose to a loud blast or explosion A hearing aid now or in the past G A serious head injury H Expose to a loud blast or explosion A hearing aid now or in the past WA rsele hnves uit heaesrina lase hafara anm A Have you ever had Expose to a loud blast or explosion H Expose to a loud blast or explosion A hearing aid now or in the past J A relative with hearing loss before age 50 H Expose to a loud blast or explosion l J A relative with hearing loss before age 50 Have you ever had A hearing aid now or in the past 48 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE A hearing aid now or in the past A hearing aid now or in the past J A relative with hearing loss before age 50 j EA Do you now have Have you ever had A relative with hearing loss before age 50 J A relative with hearing loss before age 50
20. OISE CONTROL INFO Entering Noise Level dBA Field Entering Impact Noise Field Entering Hours Away From Noise or Hours In Noise Before Test Field Entering Hours Away From Noise Field Entering Hours In Noise Before Test Field ENTERING TEST RESULTS INFO Entering Test Type Field Entering Reliability Field Entering Category of Test Field ENTERING HEARING TEST RESULT FIELDS CHECKING THE HEARING TEST RESULTS CATEGORY Looking up Previous Tests from the Long Term Archive Year to Year Comparisons 3 of 72 11 13 13 13 14 15 16 18 20 21 22 23 25 26 26 27 27 28 29 30 31 31 31 32 32 34 36 36 37 37 38 39 40 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Using Previous Year Hearing Test Result Fields Reset Test Results Function OPTIONAL FIELDS isissscsssincssssccdennsessacaanassdscnnannessesniunasssoanndeesds inn agedbessdstanasedgednnseuagsndaunpesenausssessencseeesoenetinnes ENTERING NOISE HISTORY INFO ENTERING MEDICAL HISTORY HEARING INFO ENTERING MEDICAL HISTORY GEN INFO SAVING A HEARING TEST ENTERED IN FORM MOODE cccscssccccccsccsscceccsscsscceccsscssceescsscesceesenssesseesons EFFECT OF CLICKING FINISHED TEST VALIDATIONS PERFORMED WHEN A HEARING TEST IS SAVED FIRM AND CLASSIFICATION CODE VALIDATION DISPLAYING AUDIOGRAM CHART IN FORM MODE DISPLAY BOT
21. Test Subject window It can be changed even after it is automatically filled in from the Select Test Subject window Enter the birth date in YYYY MM DD format Birth Date 1990 01 01 Calendar YYYY MM DD You will see the following error message if you enter a birth WorkSafeBC Audiogram Session 1 date in the wrong format X Birth Date invalid date format 1978 aa You will see the following error message if you enter a birth date that is not a valid date You can select the birth date from a Calendar window by Birth Date 4990 04 0 clicking on the Calendar button 1990 01 01 YYYYIMM DD 21 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Gender Field This field can be entered directly or selected as part of the test subject info from the Select Test Subject window It can be changed even after it is automatically filled in from the Select Test Subject window The gender field can be select from a dropdown list or by typing the first letter of Gender rT the items in the dropdown list If you type the letter m the Gender field will be automatically fill with the Male Gender Male item from the dropdown list You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list
22. UDIOGRAM PROGRAM OVERVIEW sssssssssssssssssssssssosossosossosossosossosossssossososssssoss GETTING STARTED QUICKLY TABLE OF CONTENTS cssssssssnnsesscuvsnssesssansinsessssnasenessoasennssdesensssondesessinabessenedenesseasunedesecenstedneuseatnedess PROCESS OVERVIEW STARTING AND USING THE ELECTRONIC AUDIOGRAM PROGRAM EAP ssssccccssssseeeccessseees Starting the program the EAP ESTABLISHING WHO YOU ARE Setting amp checking the Data Source the Industrial Audiometric Business number NAVIGATING DIFFERENT AREAS OF THE AUDIOGRAM PROGRAM AUDIOGRAM DATA ENTRY TAB RECENTLY ENTERED DATA ENTERING A HEARING TEST IN FORM MODE ccsscssccscccseccccccccsececccsscsececccsscessecscsscnssoesonss EXITING FORMS MODE AND GENERATING ENTERED FORMS SWITCHING TO DATA ENTRY MODE DIFFERENT AREAS OF THE AUDIOGRAM ENTRY FORM Entering Firm Information Entering the Classification Code Field ENTERING TEST SUBJECT INFO Entering Social Insurance No Field Entering Birth Date Field Entering Gender Field Entering Occupation Code Field Entering Years at That Occupation Field ENTERING TEST METHOD INFO Entering IAT Certification Number Field Entering the Test Booth Field Entering the Type of Audiometer Field Entering the Date of Test Entering Was your audiometer calibrated Field SAVING AND RESTORING THE TEST METHOD DATA ENTERING N
23. WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE WORK BC WORKING TO MAKE A DIFFERENCE Electronic Audiogram Program User Manual Part 1 of 3 Introduction amp Getting Started Created by Benny Yu September 24 2009 Revised by Ken Rushton March 2011 May 2012 1 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Preface This user manual is split into three word documents so they can be sent through email Part 1 This volume Introduction amp Getting Started An overview of how the Hearing test data is collected how to enter hearing tests in the simpler Form Mode generate audiogram data files and send them securely to WorkSafeBC though our portal Part 2 Data Entry Mode 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 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 The EAP supplements and replaces the paper audiogram form once used a simple paper form is also provided for those that need to capture a hearing
24. a file by clicking on the red fg teies Button 3 Sign IN Step3 4 Then sign onto the WorkSafeBC website 6 Feedback WORK BC H WORKING TO EA OLPPERENCE http www worksafebc com Employers Small Errors against y Business section and upload the data file to us The Data Base IAS user manuals will help with these steps Step 5 WorkSafeBC s system will then load it and analyze it If the tests loaded in the file are completely correct you are done If there are errors you are prompted Good Tests to fix the errors through the website Details of how to do this are in the Industrial Audiometrics User Manual see IAS User Manual Step 7 You may optionally create useful reports with the data Step 9 you will get paid for any Construction tests sent in 8 Files 5 of 72 Cross checks d A a eae by t s Daymantc v rayments _ WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Starting and using the Electronic Audiogram Program EAP When you first open the EAP you will always perform the following steps 1 Enable macros to run in Excel give the Audiogram Program s macros these are small programs permission to run There will be a message bar with the message Security Warning some active content has been disabled Options Click on the Options and then click on Enable this content A window will then pop up
25. arly wear ear protectors are displayed C Hours Away From Noise Do you regularly wear ear protectors You can select one of the valid values from the dropdown list for House In Noise Before Test by zl clicking on the dropdown button on the right hand side and then select one of the values in the Pepen Type Worn Before Test o You can select one of the valid values from the dropdown list for Do you regularly wear ear protectors by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Hours In Noise Before Test If you select No from the dropdown list the Type Do you regularly wear ear protectors Worn Regularly question will not be displayed But the Type Worn Before Test will be as the worker may have been in an unusually noisy situation for him her and have worn protection Type Worn Before Test If you select yes you can select one of the valid Do you regularly wear ear protectors values from the dropdown list for Type Worn Regularly by clicking on the dropdown button on Yes gt the right hand side and then select one of the values in the dropdown list Type Worn Regularly Type Worn Before Test A Muff B Muff A Plug B Plug Plug amp Muff 34 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE t ype Y YIT IEU UA Yy
26. as Data Review View Devel s rial j2 iRam Clipboard F Fo Alignment Security Warning bns You should see the Options button at d gt the top of the tab as seen in this screen a Security Warning Some active content has been disabled Options shot z Click the Options button you will see the Microsoft Office has identified a potential security concern next window pop up Warning It is not possible to determine that this content came gt Sometimes instead of the Option button from a trustworthy source You should leave this content disabled d unless the content provides critical functionality and you trust its you will see the following window popup If SOuUrcE you see the following window click the Enable Macros button to enable the Macros have been disabled Macros might contain viruses or other security ram program audiogram progra hazards Do not enable this content unless you trust the source of this file File Path LMAS Audiogram Program Work Safe BC Audiogram v158 xlsm More information Then Select the Enable this content option and click the OK button to enable the audiogram program Eae Moros Disable Macros eT Continued on next page m l YH Ei j Fie Edit View Insert Format Debug Run Tools Add Ins Window Help N 3 ied Wh Wa SP sy A A LELLIG fal Wem j Ln7 Col 11 When you first start the audiogram
27. asking for your company number Verify your Industrial Audiometric Business 1AB Number is correct and enter it Select the right spreadsheet tab go to the Audiogram Data Entry tab it is light green If you are new to this click on the green Forms Mode button and fill out the forms as instructed gt When finished filling out the form click the Switch to Data Entry mode button Generate the file s to send to WorkSafeBC using the red button gt Then connect to WorkSafeBC s website and upload the file securely WorkSafeBC will immediately analyze the file and let you know what if anything needs correcting You can correct errors interactively Please review the IAS User manual for more information See the Industrial Audiometric System User Manual and the Industrial Audiometric System Administrator manual available in www2 worksafebc com Topics HearingLossPrevention Home asp 6 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Starting the EAP program To start the program you just need to open it by double clicking on it Cia You should then see one of these Ca following Security Warning messages ec pop up The message varies per the 7 53 Copy version of Excel used as i mr te A dere lt 9 Format Painter B IE i gt i Home w Insert Page Layout Formul
28. ated within the past year by a service agency acceptable to WorksSafeBC Entering IAT Certification Number Field The IAT Certification Number of the person who conducted the test must be entered This field will be validated when the data is uploaded to WorkSafeBC You will see this error message if you TEPPI ETS EE y entered a contractor number with non numeric character or outside the range of allowed values 26 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering the Test Booth Field You can select one of the valid values from the dropdown list by clicking on the Test Booth dropdown button on the right hand side and then select one of the values in the eee E dropdown list Test Booth of Audiometer ae ee Test Booth Yes You can also type the letter y or n and Yes or No will be automatically filled in for you Entering the Type of Audiometer Field You can select one of the valid values from the dropdown list by clicking ee ee on the dropdown button on the right hand side and then select one of the a ea values in the dropdown list Type of Audiometer Date of Test Type of Audiometer ER You can also type the letter m s or mp and Manual S R or MPU will be automatically filled in for you 27 of 72 WORK BC Electronic Audiog
29. audiogram chart in the Test Results tab n IE 10 10 30 30 10 15 l Display Both Ears Bar Chart Click on the Both Ears Bar Chart button will display the test results for both ears side by side in the same bar chart John Doe Both Ears Bar Chart Audiogram on 2009 09 O E 0 5 13 st lll Cl Le Co s a gt C sE laO T Tr T z ee T pa m 45 _ i P Frequency in KHz Pitch i 2 x 4 6 rf iT fw Je Pa O e E gt gt ely IS P O i JI L E 57 of 72 Left 0 An Display Audiogram Charts WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE You will also see the following message box displayed on top of the chart NorkSafeBC Audiogran Session 1 fx you can move the message box to one side when you review the chart You can move the message box by placing the mouse pointer to the top of the e click box as shown in the following screen shot Then hold down the left mouse LD Close Chart mouse button and drag the box to the side here When you have finished reviewing the chart click the OK button to close the chart window Next you will be asked if you want to hide the Microsoft Excel Both Ears Bar Chart Audiogram tab which is the tab that contains the chart you have just reviewed Do you want to hide the Both Ears Bar Chart Audiogram tab C
30. ave W LP Occupation Code 7711565 Search Load W LP Derrick Worker i Save WIP Exit Classification Code 703008 Search Reset W LP Integrated Forest Management Cancel Years At That Occupation Switch to Data Entry Mode Effect of Clicking Finished Test When you click the Finished Test button all the data in the audiogram form is validated again If there is no error the hearing test result you have just entered is saved in the next empty row below row 3 of the Audiogram Data Entry and some of the fields in the audiogram form will be reset to blank so that you can start entering the next form Save Row 3 search Generate Test Firm Firm Test Subject Test Subject Test Subject Subj 2 Number Firm Name Location First Name Last Name Occupation Age 4 004378 Canadian Forest Products Lt O60 Mac JHuf Geologist 22 55 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Validations performed when a Hearing Test is saved These validations are performed before a hearing test result is saved Mandatory Field Validation WorkSafeBC Audiogram Session 1 You will see this error message if any mandatory l The following fields must be entered fields are not entered Test Booth Test Method Type of Audiometer Test Method Data not exported Firm and Classification Code Validation If the c WorkSafeBC Audiogram Data a
31. b recently entered data The Audiogram Data Entry tab spreadsheet is where tests are entered and contains hearing tests that have been saved before they are generated and moved to the Audiogram Data Archive tab Click on this tab to bring this spreadsheet forward Data entry can be done here in row three all other rows are protected against update While data entry can be done directly on Row 3 it is complex for the novice On the next page we describe how to enter the simpler Forms Mode A p C D E E E H J Wo a yy ee Seat Subject Mah Clear Row 3 Display Chart Both Ears Copy to Row 3 Display Chart L amp R Ears Save Row 3 Search Generate Empli ii Socia Firm Firm Test Subject Test Subject Test Subject Test Subject Insuri 2 Number Firm Name Location First Name Middle Name Last Name Occupation e No 4 004378 Canadian Forest Products Ltd a n S rushton Geologist 62 12344 to search X Long Term Archive Parameters New Codes iiiu The Audiogram Data Entry tab is where your active data resides Here you may quickly enter hearing test data or corrections in the light green row in the centre The rows below the green input row contain the data that you have entered and stored with the Save Row 3 command Audiogram Data Archive tab generated amp on hold data The Audiogram Data Archive tab contains hearing tests that have been g
32. c Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Saving Changes in the Audiogram Program You should save the changes you have made to the audiogram program from time to time The Save Row 3 button in the Audiogram Data Entry tab only saves the hearing test you have entered in row 3 to an empty row after row 3 It DOES NOT SAVE THE EXCEL WORKBOOK that contains your audiogram program Follow these steps to save the Excel workbook that contains the audiogram program Click the Office button at the top left corner of the Excel window Work Safe BC Audiogram v112 xls Corr Home Insert Page Layout Formulas Data Review View Developer Add Ins Click the Save option to save the Excel workbook that contains the audiogram program EF New ms Open Convert gt IW cu lt ro Tip you can also press CNTL S to save cae n Print b Z4 Prepare aa Send L F Publish gt as P Close 71 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Setting a full spreadsheet Save at each Audiogram Save If you are new in using Microsoft Excel you can setup the parameter in the Parameters tab so the Excel workbook that contains the audiogram program is saved each time you save a hearing test in the
33. edical History Hearing Medical History Gen Display Audiogram Charts 39 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Looking up Previous Tests from the Long Term Archive Year to Year Comparisons Note for this to work you must have your test subject s old test results stored in the Long Term Archive tab See the section Copying Archived Data To the Long Term Archive tab from a File in Part 3 of this user manual for instructions on loading previous year test results into the Long Term Archive tab Using Previous Year Hearing Test Result Fields If the Test Type is Periodic the Previous Result checkbox is displayed aat Results Noise History Medical History Hearing Medical History Gen Display Audiogram Charts Both Ears Bar Chart LR Ears Line Chart Test TYPE Periodic Category of Test AC Frequency In KHz Pitch 05 1 2 3 9 Reset ita 5 cll ods Alak 5 10 7 LeftEar Right Ear 5 z 10 z 10 z 30 z 30 z 10 z 15 z raa Previous Result You can display the test results dropdown boxes for previous year by checking the Previous Result checkbox The audiogram program will automatically search the Long Term Archive tab to locate a test with the following criteria and order 1 The first test with the same SIN and test year greater than test year of the current t
34. enerated into an audiogram data file or hearing tests that were intentionally archived before they have been generated A 5 G D E F G Em Soc Subject Inst al Test Subject Occupation Ai No 4 5 6 7 HM 4 Audiogram Data Entry _audioarz 11 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Long Term Archive tab Don t worry about this tab it is to hold last year s data for year on year comparisons Other Tabs Can be ignored for now 12 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering a Hearing Test in Form Mode To bring up the audiogram form i B a o on on 8 8s 8 oo o Foe ee OE click the Switch to Form Mode RRR E button in the Audiogram Data Entry tab Any data that you have already entered in row 3 of the Audiogram Data Entry tab will be loaded into the audiogram form Of course if row 3 is empty the audiogram form fields will also be empty Generate Firm Test Subject Te 2 Number Firm Name Location First Name __ Mi 3 S a UR 4 004378 Canadian Forest Products Ltd 060 ken S 5 save wap Load W P Exiting Forms mode and Generating entered forms Switching To Data Entry Mode The Data E
35. est or WorkSafe ee Audioi D test year equal test year of the current test and test month greater than the test month Previous test result with the same SIN is found in Long Term Archive Hon esejrljk tested on 2012 02 15 of the current test Do you want to use this previous result 3 Ifno matching SIN found then the first test with the same first name last name and birth _ year and birth month and test year greater than test year of the current test or test year equal test year of the current test and test month greater than the test month of the current test Finally if no matching test is found in the Long Term Archive tab and a non blank test in the Long Term Archive tab is selected you will be asked if you want to use the selected test in the Long Term Archive to compare with the current test No previous test result found Do you want to use the selected previous result for Jane Doe 40 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Click the OK button to continue and you will see the previous test results boxes filled in Previous Result Reset tetear 5 l 10 15 10 25 5 Jo Left Ear RintEar 0 vi lo vl 10 15 25 i0 fo Right Ear Click the No button and the previous results box will be displayed for you to fill in manually Test Subject Test Method Noise Control Test Results Noise
36. he Save button to save a hearing test in the Audiogram Data Entry tab 72 of 72
37. id values from the dropdown list by clicking x l Noise Level dBA on the dropdown button on the right hand side and then select one of the values in the dropdown list Noise Level dBA l fay Fom Noise Noise Before Test gr 99 100 102 You can also type in the number in this field the first value that matches what you typed will be automatically filled in for you Noise Level dBA lt 65 Entering Impact Noise Field You can select one of the valid values from the dropdown list by clicking on the dropdown aes button on the right hand side and then select one of the values in the dropdown list beh si ae Impact N lo gt Impact No You can also type the letter y or n and Yes or No will be automatically filled in for you Note that the term Impact Noise refers to noise of 140 dBC or greater 31 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Hours Away From Noise or Hours In Noise Before Test Field You must select either the Hours Away From Noise or Noise Control Hours In Noise Before Test option button C Hours Away Fom Noise C Hours In Noise Before Test Entering Hours Away From Noise Noise Control Field Hours Away From Noise sh As selections are made logical related options appear Select one of the valid values from the dropdown
38. in the Select Classification Code window Once you have found a classification code for the hearing test in the Select Classification Code window clicking the Select button to select the classification code Select Classification Code Search By C Code Description Zoom 100 Classification Code Description pre H 114017 Pre Hung Door Assembly 1 Classification Code 1 New Classification Codes found 16 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE The Classification Code field in the audiogram form will be automatically filled by the select classification code The description for the selected classification code is displayed under the classification code Firm Name Canadian Forest Products Ltd Firm No 004378 Location No og0 search Test Subject Name First Mac Mid Last Huf Age Occupation laborer Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen Social Insurance No Gender Birth Date Calendar YYY MM DD Occupation Code Search Classification Code Classification Integrated Forest Management Years At That Occupation Switch to Data Entry Mode ificati WorkSafeBC Audiogram Session 1 If you enter a classification code directly you will see the following prionen BIOS am JESTION erro
39. in this area to bring up the Select Test Subject window 3 Below the test subject area is the data area where different groups of data are separated into different form tabs You can move to a specific form tab by clicking on the tab name The Test Subject tab is always displayed when the audiogram form is first displayed There is a Search button in this area to bring up the Select Occupation Code window a Search button in this area to bring up the Select Classification Code window and a Calendar button in this area to bring up the Select Test Subject Birth Date window 4 On the right hand side is the command area where all the command buttons are located 14 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Firm Information The Name Firm No and Location No fields do not allow you to enter data directly You must select a firm number firm location and firm name combination from the Firms tab or from the firm data file by clicking on the Search button to bring up the Select Firm window aJi SAFE BC AA 92 WORKIAG TU PAKE A DIFFERENCE E Firm Name Firm No Location No Select Firm Search By Firm Number Firm Name C Search Fie Ete provided Loom 92 Firm Number 2 Firms found Camel Refer to the Entering Firm Info section under Data Entry Mode
40. ion D A hearing aid now or in the past J A relative with hearing loss before age 50 T _ BE BE _ EE BE EEE Do you now have A Trouble understanding speech she B Ringing in your ears 46 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Have you ever had A A visit to an ear doctor in the last 5 years B A servere ear infection E Ear surgery F Dizziness or balance problems G A serious head injury H Expose to a loud blast or explosion 1 A hearing aid now or in the past shahahehehalul J A relative with hearing loss before age 50 Have you ever had A visit to an ear doctor in the last 5 years A A visit to an ear doctor in the last 5 years B A servere ear infection E Ear surgery Have you ever had A severe ear infection B A servere ear infection E Ear surgery F Dizziness or balance problems B A servere ear infection E Ear surgery F Dizziness or balance problems Ai A eariniie haad inir Have you ever had Ear surgery E Ear surgery b F Dizziness or balance problems G A serious head injury 47 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO
41. l Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Reliability Field You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Reliability _ Q o ee i 6k kahili gt Reliability Good You can also type in the first character of each of the items in the dropdown list and the item will be automatically filled in for you Entering Category of Test Field You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Category of Test j Category of Test t a Reliability Ml A lip Category of Test N You can also type in the first character of each of the items in the dropdown list and the item will be automatically filled in for you 37 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Hearing Test Result Fields All the hearing test result fields for left and right ears have the same values in the dropdown list Here Left ear 05 KHZ is used as an example Frequency In kHz Fitch 0 5 1 2 3 4 6 8 Left Ear g H FF x E ii EI DI oi oi oi oi p You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand
42. lick Yes if you want to review or print chart later Otherwise click No to hide the tab See the section Print Audiogram Chart In Form Mode in Part 2 of the user manual for detail instructions of printing the chart in the Both Ears Bar Chart Audiogram tab 58 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Displaying the Both Ears Line Chart iis a dh aia Click on the Both Ears Line Chart button will display the test results for both ears in Both Ears Bar Chart the same line chart John Doe Both Ears Line Chart Audiogram on 2009 09 Frequency in KHz Pitch baat A RH aam T o Dizak i i AAAI AN AAA I You will also see the following message box displayed on top of the chart you can move the message box to one side when you review the chart You can move the message box by placing the mouse pointer to the top of the box as shown in the following screen shot Then hold down the left mouse button and drag the box to the side When you have finished reviewing the chart click the OK button to close the chart WorkSafeBC Audiogram Session 1 R window D Close Chart Next you will be asked if you want to hide the Both Ears Bar Chart Audiogram tab which is the tab that contains the chart you have just reviewed Click Yes if you want to review or print the chart later Otherwise click No
43. list for Hours Away From Noise by clicking on the ie Hours Away From Noise l G dropdown button on the right hand side and then k LJ a ae In h I Fh ime oO mc rn selecting one of the values in the dropdown list Nose Control Hours Away From Noise C Hours In Noise Before Norse Control gt Hours Away From Noise Likewise you can select one of the valid values from the dropdown list for Do you regularly wear ear protectors If you select No from the dropdown list the Type Worn Regularly dropdown box will not be displayed 32 of 72 WORK BC WORKING TO MAKE A DIFFERENCE As expected if you select Yes from the dropdown list the Type Worn Regularly dropdown box will display You can select one of the valid values from the dropdown list for Type Worn Regularly by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Electronic Audiogram Program User Manual Part 1 of 3 Do you regularly wear ear protectors ves Type Worn Regularly res 7 Type Worn Regularly 33 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Hours In Noise Before Test Field Noise CONTO Here we have selected House In Noise Before Test option and the dropdown boxes for House In Noise Before Test and Do you regul
44. n find the names of all the worksheets You can move to worksheets tabs that are not displayed at the bottom by moving the list of tab names to the left or right You can display the content of a tab by clicking on the name of that tab at the bottom 9 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Navigating to a worksheet tab At the bottom of the Excel window you will see the names of different worksheets which are also referred to as tabs tab and worksheet is the same thing in this manual You can display a tab by clicking on the tab name Clicking on the arrows at the left hand side will move the tab names at the bottom to the left or right n 4 Audioc lasdy moves to the left most tab EO moves one tab to the right These arrows only move the tab names at the bottom and do not affect which tab is being displayed moves one tab to the left moves to the right most tab You select any tab any data sheet by clicking on a tab name i e Audiogram Data Entry as above or Audiogram Data Archive Long term Archive parameters and so on 4 H Audiogram Data Entry Audiogram Data Archive Long Term Archive adv MJ Parameters New Coc 10 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Audiogram Data Entry ta
45. ntry Mode button will close the audiogram form and populate row 3 of the Audiogram Data Entry tab with all the data entered in the audiogram form up to that point Save VWIP Exit At this point if you have entered a form then you can generate it and send it to us at WorkSafeBC using our portal For details of how to do this see the Industrial Audiometric System User Manual and the Industrial Audiometric System Administrator manual available in www2 worksafebc com Topics HearingLossPrevention Home asp 13 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Different Areas of the Audiogram Entry Form The audiogram form is divided into four main areas WORK SAFE BC foom 92 Woe Airm 4 Jame Firm No Location No Search a eS ee First Mid Last Age Occupation Search Medical History Hearing Medical History Gen Fa Social Insurance No Gender Birth Date Calendar YYYYMWDD Occupation Code Search Classification Code Search Years At That Occupation 1 At the top is the firm area that contains the name firm number and location of a firm There is a Search button in this area to bring up the Select Firm window 2 Below the firm area is the test subject area which contains the first name last name age and occupation of a test subject There is a Search button
46. orkSafe BC pp Was your audiometer calibrated Yes within the past year by a service agency acceptable to the WorkSafe BC You can also type the letter y or n and Yes or No will be automatically filled in for you 29 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Saving and restoring the Test Method Data Since the data in the Test Method tab are generally the same for all the hearing tests You can click on the Save As button to save the current data in this tab for future use Test Booth Type of Audiometer Date of Test Was your audiometer calibrated within the past year by a service agency acceptable to WorkSafeBC When you completed and saved a hearing test all the fields in the Test Method fields are reset to blanks You can restore these default values in the Test Method tab by clicking on the Restore button 30 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Noise Control Info Click the Noise Control tab to display all the fields in this tab Test Subject Test Method Neise Control Wrest Resuts Noise History Medical History Hearing Medical History Gen x COD Norse Control C Hours Away From Noise C Hours In Noise Before Entering Noise Level dBA Field You can select one of the val
47. ose the audiogram form and populate row 3 of the Audiogram Data Entry tab with all the data entered in the audiogram form up to that W LP 69 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Changing Audiogram Form Window Size The Zoom button at the top of the audiogram form allows you to increase or decrease the size of the audiogram form window This is mainly for laptop users with small screens WotkSeieBC Audiogram Session 1 WORKIAG TO FAKE A DIFFERENCE Firm Name Canadian Forest Products Ltd Firm No 004378 Location No 060 Search Test Subject Name First ron Mid 5 Last esterlik Age 62 Occupation Geologist Test Subject Test Method Noise Control Test Results Noise History Medical History Hearing Medical History Gen Test Type C E Display Audiogram Charts oewos d E ee Reliability Good F Previous Result LREarsLineChart Frequency In KHz Pitch 05 1 2 3 4 6 8 pmen lw i lot Cre 10 I 14 a 15 14 a 4145 I 14 15 m ieee Each click on the will increase the window size by 5 Each click on the up arrow will increase the window size by 1 Each click on the down arrow will decrease the window size by 1 t Ut Each click on the will decrease the window size by 5 Clicking on the Zoom will reset the window size back to 100 70 of 72 WORK BC Electroni
48. r message if the classification code contains non numeric characters If you enter a classification code directly you will see the following error message if the classification code is less than 6 digits or not found in the Classification Codes and New Codes tabs If you see this message and you know the classification code is valid then you should enter this classification code in the New Code tab for classification code 17 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Test Subject Info You can enter the First Name Last Name and Occupation fields directly or you can search for a test subject that have been saved in the Test Subjects tab subjects are saved in the Test subjects Tab when their test is saved The Age field is calculated by the audiogram program from the Birth Date field Click on the Search button to bring up the Select Test Subject window to search for a test subject fest Subject Name First Mac Mid n Last Huff Age 29 Occupation Geologist Refer to the Entering Test Subject Info section under Data Entry Mode in Part 1 of the user manual for detail instructions on how to search a test subject in the Select Test Subject window After you have selected a test subject in the dropdown box click the Select button to select the test subject
49. ram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering the Date of Test The Date of Test must be a date in the YYYY MM format You can select the test date from the Calendar window by clicking on the Calendar Date of Test alenda button YYYY MM You can also enter the test date directly into the Date of Test field You will see the following error message if you enter non numeric characters for the year or month WorkSafeBC Audiogram Session 1 You will see the various error messages if you enter an invalid date f WorkSafeBC Audiogram Session 1 You will see the following warning message to remind ou that you have enter a test date that is not in the y y a Date of Test of 2009 08 is not the current month current month This is only a warning message and it will not stop you from entering an older test date 28 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Entering Was your audiometer calibrated Field You can select one of the valid values from the dropdown list by pire pecker calibrated E 5 is within the past year by a service clicking on the dropdown button on the right hand side and then select agency acceptable to the WorkSafe one of the values in the dropdown list BC Was your audiometer calibrated within the past year by a service agency acceptable to the W
50. re print areas P gm p end the workbook directly to the defau 7 7 is i printer without making changes Page s From E u E ae R A Print Preview Print what ip Ap Collate E h Preview and make changes to pages before Selection Entire workbook printing Active sheet s Table ay z p Click the OK button to print the audiogram chart Microsoft Excel When you move away from the L amp R Ears Line Chart Do you want to hide the L amp R Ears Line Chart Audiogram tab Audiogram tab by clicking on any other tab in the audiogram program you will be asked if you want to hide the L amp R Ears Line Chart Audiogram tab Click the Yes button to hide the L amp R Ears Line Chart Audiogram tab You would reply no only if you want to print it later 65 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Audiogram Form special actions There are six buttons on the audiogram form that help you save work in progress Name Canadian Forest Products Ltd Classification Code 7o30 Psese Integrated Forest Management Years At That Occupation 5 66 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Saving Audiogram Data between Sessions entered at that point into a temporary area This allows you to save the data in a session The Save W I P
51. reas of the Audiogram Program Before we learn how to use the audiogram program let s get to know the different areas of the Microsoft Excel window that contains the audiogram program There are three main areas in the Microsoft Excel window that contains the audiogram program 1 At the top of the Microsoft Excel window is the Excel menu items these menu items contain all the functions provided by Excel If you are familiar with Excel then these functions are available to you There are a few additional functions provided by the audiogram program accessible via the Add Ins menu tab 2 in the middle of the Microsoft Excel window is the worksheet tab work area each tab contains different information used in the audiogram program The main data tabs are Audiogram Data Entry Audiogram Data Archive and Long Term Data The Audiogram Data Entry tab is the main tab where you enter Hearing Tests Other tables are Parameters New Codes Classification Codes Occupation Codes Firms Test Subjects Work Safe BC Audiogram w158 xlsm Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Add Ins Load Test Print Audiogram Audiograms Report Display Chart Both Ears Display Chart L amp R Ears search E Firm Test Subject Left ear Location FirstName 05 KHZ 3 At the bottom of the Microsoft Excel window is where you ca
52. side and then select one of the values in the dropdown list Name bey Le irm No Left Ear est Subjec irst Name 0 5 Left Ear 20 Jccupation You can also type in the value for each of the boxes fee 38 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Checking the hearing test results Category Once all the test results for left and right ears are entered for Test Type of Baseline or 1 Time in Noisy Industry the Check Category button will be displayed Noise Control Test Results Noise History Medical History Hearing Medical History Gen Display Audiogram Charts Test Subject Test Type Category of Test AC Reliability Good l Previous Result Frequency In KHz Pitch 4 Click the Check Category button to calculate the Category of Test value based on the test D Test results indicate an Abnormal result results entered for the left and right ears The due to over the 25dB threshold at 0 5 KHz 1 KHz or 2 KHz result of the calculation will be displayed ina message box in the left ear at 1 KHz 30dB 2 KHz 40dB When you click the OK button of the message box the calculated value will be inserted into the Category of Test field You can still override the calculated value Test Subject Test Method Noise Control Test Results Noise History M
53. siness number Next you will see this message box It will be set to 0 and you will be required to enter your Industrial Audiometric Business number previously this has been referred to as a contractor number and click the OK button to continue This manual uses contractor number 66 in all the examples Note the IAB number must be correct for you to upload your data to us Save the spreadsheet by pressing the Cntl S implies Save File key combination y or clicking on the blue save icon in the top left corner and gt 4 vat a selecting the Save command When you next open the audiogram program you will see the following message box has the previously entered IAB number If it is set as you wish click on OK Your Industrial Audiometric Business Number formerly Contractor Number In House Name is setup as 66 Please insure this ts the correct value itis used to identity the files sent in Please insure this is the correct value pas Itis used to identify files sent in x Your Contractor Number In House Name is setup as OK g a Tip If you don t see this message box after you open the audiogram program it means you have not enabled macros Close the audiogram program and reopen it again this time enabling content macros 8 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Navigating Different A
54. t in the L amp R Ears Line Chart Audiogram tab 62 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 ee Display Audiogram Charts Printing an Audiogram Chart from Form Mode The steps to print each of the three types of audiogram chart in form mode are the same Here we will use the LR Ears Line Chart as an example Eoih Fars Line Chart Display the chart you want to print by clicking the L R Ears Line Chart button Close Chart Once you have confirmed it is the chart you want to print Click the OK button to close the chart then Click the No button when you are asked if you want to hide the L amp R Ears Line Chart Audiogram tab When you return to the audiogram form click the Data Entry Mode button to switch to the Audiogram Data Entry tab with all the data you have entered into the audiogram form Click on the Form Mode button to switch back to the audiogram form with all the data entered after you printed the audiogram chart 63 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Next display the L amp R Ears Line Chart Audiogram tab by clicking the L amp R Ears Line Chart Audiogram tab at the bottom of the EXCEL window Ld Audiogram Data Ent Audiogram Data Archive Long Term Archive Parameters New Codes Classification Codes Occupation Codes Firms
55. test away from the computer then bring it back to the office for entry This highly detailed manual is designed to assist audio labs that have little or no experience in using computers with screenshots for every step in the instructions and likely errors This manual is updated as new features are added Getting Started Quickly The EAP is not a difficult program to use don t judge it by these 3 volumes we just needed to explain carefully how it works to support the needs of the computer and Excel novice as well as the sophisticated expert We suggest reading just from here to page 13 Entering a Hearing Test in Form Mode then trying out the EAP to enter just a hearing test form or two in what we call Form Mode peeking at the manual only when needed and only generating that form or two Then signing on to www worksafebc com to upload the entered hearing test s This should give you a good introduction to the process 1 Use the rest of the manual as a handy if obsessively detailed reference guide t For this last step you will need to consult the manual located here http www2 worksafebc com pdfs hearing IAS User Manual pdf 2 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Table of Contents PREFACE scssscvsnctnstasscasecacesuanesnssaceonstabecencssassunsisuaseecssenasecasteaiwsanuseuassdepatennseensonnstansusnensaensteasaianusuens ELECTRONIC A
56. ubject Test Method Noise Control Test Result Moise History qedical History Hearing Medical History Gen Have you ever been exposed to loud noises 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 You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side and then select one of the values in the dropdown list Have you ever been exposed to loud noises A At a previous job B Off the job power tools rock music etc C In the armed forces B Off the job power tools rock music etc C In the armed forces C In the armed forces shooting History 43 of 72 WORK BC Electronic Audiogram Program User Manual Part 1 of 3 WORKING TO MAKE A DIFFERENCE Shooting History A Do you have you hunted B Shot trap skeet target not hand guns C Shot hand guns B Shot trap skeet target not hand guns C Shot hand guns C Shot hand guns If any one of the Shooting History field values is Yes you will see the following additional fields displayed shooting History A Do you have you hunted No v B Shot trap skeet target not hand guns C Shot hand guns D Worn ear protectors while shooting E Shoulder shot
57. udiogramfirmcu dat file that contains all the firm number firm location firm name and classification code combinations is present then the firm number firm location firm name and classification code combination in this hearing test will be checked against the file If the entered combination does not exist in the file the following warning message is displayed However you can still save the hearing test if you are sure the combination you entered is valid by clicking on the Yes button If the entered combination is incorrect then click on the No button to return to the Audiogram Data Entry tab without saving the hearing test and correct the incorrect data WorkSafeBC Audiogram Session 1 Firm number 614069 Firm Location 001 and Class Code 1401 ts not found in the c data audiogramfirmcu dat data file Do you still want to save data If you see a message like this check your sources If your sources are valid then let PDICON worksafebc com know to change our files If the c WorkSafeBC Audiogram Data audiogramfirmcu dat file is not setup then you will not see the above warning message and you are at risk of sending in invalid data having the AudiogramFirmCU can save you work 56 of 72 WORK BC WORKING TO MAKE A DIFFERENCE Electronic Audiogram Program User Manual Part 1 of 3 Displaying Audiogram Chart in Form Mode You can display the test results in three different types of
Download Pdf Manuals
Related Search