Home

Electronic Audiogram Program User Manual Part 2

1. RESENDING GENERATED HEARING TESTS Cres SUMMARY PRINTING AUDIOGRAM FOR A SAVED HEARING tenete sese PRINTING AUDIOGRAM REPORTS FOR SAVED HEARING PRINTING AUDIOGRAM REPORT FOR A SPECIFIC FIRM NUMBER LOCATION AND NAME PRINTING AUDIOGRAM REPORT FOR ALL FIRM NUMBER LOCATION AND NAME SUMMARY SAVING AUDIOGRAM REPORT AS WEB eee eee eee eene eene senes esos sese sese sese sese se SAVING AUDIOGRAM AS WEB PAGE SEV SEN EOS AVES Qa TRAN E aO ERAS ES En FE 3 of 115 56 57 58 59 59 60 61 62 63 64 65 66 66 67 67 69 70 70 71 73 74 74 74 77 79 87 90 92 74 75 5 75 77 77 77 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE DISPLAYING AUDIOGRAM CHARTS FOR A SAVED HEARING TEST 99 DISPLAYING TEST RESULTS FOR BOTH EARS ON THE SAME BAR CHART 99 DISPLAYING TEST RESULTS FOR BOTH EARS ON THE SAME LINE CHART 100 DISPLAYING TEST RESULTS FOR BOTH EARS ON SEPARATE LINE CHARTS 102 ENTERING OPTIONAL FIELDS IN DATA ENTRY cccccccccccccccccccccccccccccccccccccccccc
2. E Test Subject Test Subject Test Subject Test Subject Select Test Subject Search By C First Zoom 10096 When the Select Test Subject window comes up the search by option will default to the Last Name option you have selected the last time you have searched a test subject Last Name First Name Select Test Subject Search By C First Name Last Name Zoom 10096 In this example have typed do in the Last Name Last Name field and there are two last 0 names that start with do The Last Name 2 Doe John Occupation Laborer or First Name search text field is not case u Last Name First Name sensitive Select Test Subject Search By C FirstName Last Name Zoom 10096 One can continue typing the rest of the last quu name to narrow down the number of test x subjects in the dropdown list or can select the test subject by clicking the test subject in the dropdown list Click on the dropdown button on the right hand side and click on Select Test Subject the test subject that you want to select Search By First Name 2 Doe John O ccupation Laborer LARA CA LEN n Office Assistance S Last Name Zoom 10096 Last Name do Oe Assn Doe Jane Occupation Office Assistance Last Name First Name Select 2 Test Subjects found WORK
3. In this example the hearing test saved on 2009 09 17 was already generated to a previous file and the hearing test saved on 2009 09 18 has not been generated to any file yet The generated hearing test with a Y was moved to the Audiogram Data Archive tab after the generation and moved back to the Audiogram Data Entry tab with the Restoring archive function see the Restoring Archived Data section in Part 3 of the user manual for instructions on how to restore hearing tests from the Audiogram Data Archive tab to the Audiogram Data Entry tab This Record Has Been Generated ul Last Updated Date and reate Date and Time Time 2009 09 17 13 01 55 2009 09 18 08 12 52 Separate processing Streams for SIN vs no SIN records There are two types of audiogram data file generated by the audiogram program 1 The first type contains hearing tests for both construction and non construction firms with SIN 2 The second type contains hearing tests for construction firms with no SIN SIN refusal You can mix both types of hearing tests in the Audiogram Data Entry tab When you generate the audiogram data file the audiogram program will separate them into two different data files 20 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Batches The program automatically sorts hearing tests by firm number and firm location before generation An uploaded
4. Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE 44 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Once you have the selected test subject displayed in the dropdown box as seen in the screen shot below you can click the Select button and the First Name Last Name Occupations Social Insurance No Birthdate and Gender fields will be filled in for you in the Audiogram Data Entry tab The Test Subject Age field is automatically calculated from the Employee Birth Date field hart L amp R Ears Employee Test 1st Five Social Test Subject Test Subject Subject Letters of Insurance Employee Employee O First Name Last TestSubjectOccupation Surname No Birth Date Gender Doe Assistance FUIL 2 The 1st Five Letters of Surname field is always extracted from the Test Subject Last Name field For last names that start with or Mac the Mc and Mac are treated as one letter and they will be shown as Mc Mac So for last name such as MacDonald the 1 Five Letters of Surname field will be displayed as Mc MacDONA See section Override 1 Five Letters of Surname Field in Part 1 of the user manual on how to override incorrectly extracted 1 Five Letters o
5. Printed on Fri Sep 11 2009 07 17 05 Excel 2003 12 Microsoft Excel Work Safe BC Audiogram Program xls Click the Close button to Har close the preview window e Print Preview c LEM E Next Page fe ta Excel 2007 Es T y Previous Page Print Page Zoom Clase Print i x Setup Show Margins Preview Click the Close Print Preview icon to close the preview window Print Zoom Preview d2 C6 8 Excel 2003 amp 2007 WorkSafeBC Audiogram Session 1 The following message will be displayed to confirm the audiogram web page files have been created successfully Click the OK JJ 1 audiogram has been saved as web page in c WorkSafeBC Audiogram webpage button to close the message box 98 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Displaying Audiogram Charts for a Saved Hearing Test You can display three different types of audiogram chart for a hearing test saved in the Audiogram Data Entry tab e Both left and right ears test results on the same bar chart e Both left and right ears test results on the same line chart e Left and right ears test results on two separate line charts This last chart can also display hearing tests of test type Periodic comparing the selected hearing test and the previous year test result in the Long Term Archive if loaded
6. Displaying test results for both ears on the same bar chart Select the hearing test that you want to display in the audiogram bar chart and click the Display Chart Both Ears button When you see the following message box click the OK button to continue or click the Cancel button to cancel the display chart process Next you will be asked to choose the type of chart to be displayed Click the Yes button to display a bar chart 4 Firm 2 Number gt Firm Name 3 5 amp Excavating Ltd 001 amp A Excavating Ltd 001 614069 Renny Construction Ltd 001 614069 Benny Construction Ltd 001 8 614069 Benny Construction Ltd 001 Select Chart Type 99 of 115 D Test Subject Test Subj Location First Name Nam Don Jone Patrick More Jane Doe Jane MacDonalc John smith WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Next you will see the audiogram bar chart with the test result for left and right ears side by side in the Both Ears Bar Chart Audiogram tab Patrick More Both Ears Bar Chart Audiogram on 2009 08 You will see the following message box when you click on 2 3 0 any other tab to 5 E 015 y 15 amp p Both Ears Bar Chart alex Audiogram tab 25 Frequency in KHz Pitch Right 0 0 5 Click if you wa
7. KHZ j Leftear 1 5105 KHz kHZ Select from the All the hearing test result fields for left dropdown list and right ears have the same valid values in the dropdown list We will use the Left ear 05 KHZ field as an example 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 You may also type the numbers on the keyboard Select from the dropdown list 67 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE 68 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE You will see the following error message if you enter an invalid Microsoft Excel value in the Left ear 05 KHZ field Entering Optional Fields The fields for Noise History Medical History Hearing and Medical History Gen are optional See section Entering Optional Fields In Data Entry Mode later in this user manual for detail instruction on how to enter these fields 69 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Audiogram Process Reports After you send the audiogram data files to WorkSafeBC you will receive two types of audiogram process report in the email The first type is for audiogram data files that
8. displays an audiogram chart with each ear in a separate chart Generate takes the data entered generates it to files and then archives the entered data The next section details how to use each button 6 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Saving a Hearing Test Result in Data Entry Mode Once all the data for a hearing test is entered into row 3 of the Audiogram Data Entry tab You can save the hearing test result by clicking on the Save Row 3 button Note this button only saves the single row of data not the whole spreadsheet unless the Save spreadsheet along with test results option is on LL Print Audiogram Dilete Selected Row s SwitchtoFormMode Clear Row 3 Display Chart Both Ears opy to Row 3 Display Chart L amp R Ears sen EE Firm Test Subject Location First Name 0043 8 Canadian Forest Products Ltd O60 ron Lg Audiograms Report Save Row 3 Once you click the Save button all the data in row 3 is validated again If there is no error you will see the following message to confirm the data is saved to the next empty row in the Audiogram Data Entry tab By default clicking the Save button does not save your Excel workbook that contains the audiogram program If you want to save changes in the Excel workbook see Part 3 of the user manual Parameter section subsection Save Workbook After
9. 060 ron S mouse button After you clicked the Clear button the following message WorkSafeBC Audiogram Session 1 box will be displayed All data in the data entry row will be lost Do you want to continue w Click Yes to confirm you want to clear the data in row 3 or No to cancel the clear action Next you will see the data in row 3 is cleared Clear Row 3 Display Chart Both Ears Copy to Row 3 Display Chart L amp R Ears Save Row 3 Search Generate Firm Firm Test ay ats Su pn Lan Su oa b umbsr irm Nam j i s 5 ii m n a Fnraed DHT ren 12 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Creating Templates in Data Entry Mode You may create Templates to save commonly used audiology test conditions for later use e You create as many templates as you want e Templates are always saved at the top of other hearing tests after row 3 e Templates can be copied to the data entry row row 3 the same way as a hearing test row e Templates can be deleted just like any hearing test rows e Templates are not included extracted in the generated audiogram data file they remain in place e Templates are included in the backup and restore process together with the other data in the Audiogram Data Entry tab e Templates cannot be moved to the Audiogram Data Archive tab by the archive function There a
10. Clicking the Show Hide Code Description button again will hide the occupation pir moni Years At That code description Occupation Co 18 J 5423 ane SSS Occupation The Show Hide Code Description button will toggle between showing fight mouse in to search and hiding the occupation code description Entering Classification Code Field You can either select the Classification Code field from the Classification Codes tab or enter the value directly Selecting Classification Code from the Classification Codes Tab All the valid classification codes 1 Codes 2 711001 Abattoir are stored in the 3 762001 Accounting if 4 713001 Acid Base Salt Chemical or Dye Manufacture not elsewhere specified Classification 5 762002 Actuarial Services Codes tab 6 766001 Acute Care 7 051800 Adjudication Errors Claims due to Misconduct or Costs Related to Injuries Aqqravated Subsequent to Original Inju 8 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 Test Subjects 7 Mew Codes Occupation Codes Firms Parameters Classification Codes New classification c codes that have n
11. Next Page audiogram i B Lap Previous Page Clase Print Show Margins Preview Preview ri t t H fe M If you only want to review the audiogram then you can click the Close Print E etm Preview icon to close the preview window Cu Print Preview n E Next Gen ta y Previous Print Page Zoom Close Print Setup Show Margins Preview Print Zoom Preview Excel 2003 amp 2007 If you click on the Print icon in the preview window or if you chose to skip the preview you will see the following Print window displayed Your printer inus name will be different because you will have a E orans proper alt Status Idle different printer setup Find Printer Where RC21 25020 ISD Development Services PED 10 2 112 249 Click the OK button to print the audiogram chart or ee aa Print to file click the Cancel button to abort the printing 10 2 112 249 Print range Copies all Number of copies Page s From B To Print what ye ye Selection Entire workbook Active sheet z _ Ignore print areas Preview WorkSafeBC Audiogram Session 1 You will see the following message to confirm the audiogram report has been processed 2 1 of 1 Audiogram Report printed 89 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRK
12. Search All Firms checkbox This file contains all the firm number firm location firm name and classification combinations in the WorkSafeBC system See section Setup Firms For Entering Hearing Tests in Part 1 of the user manual for instructions on how to setup the audiogramFirmCU dat file in your PC In this example have typed in benn in the firm name search field and we can see in the lower part of the window there are eight firm names that start with benn The search field text is not case sensitive can continue typing the rest of the firm name to narrow down the number of firms in the dropdown list or can select the firm by clicking the firm in the dropdown list Click on the dropdown button on the right hand side and click on the firm that you want to select Select Firm Search By C Firm Number Firm Name arch irm Zoom 10095 Firm Name Sorted in Firm Name order in 1 00 sec Select Firm search By C Firm Number Firm Name Search All Firms Zoom 100 Firm Name 268098 001 763015 Benner Forestry Ltd 8 Firms found Select Firm Search By C Firm Number Firm Name Search All Firms Zoom 10096 Firm Name benn 268098 001 763015 Benner Forestry Ltd 268098 001 763015 Benner Forestry Ltd 449393 001 721008 Benner s Refrigeration amp 286807 001 721031 Bennett Contracting Ltd 102641 001 721043 Bennett Sheet Metal 102641 0
13. Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM The report also shows the current price WorkSafeBC will pay for each hearing test the new price and effective date of the new price if there is a change in the price Contractor No Firm Name 66 Fours Sons Electric 66 Fred amp Company Inc 66 Pacesetter Developments 66 Pacesetter Developments 66 Pacesetter Developments 66 Pacesetter Developments 66 Mibroc Developments 66 Mibroc Developments 66 Adams General Contracting 66 PCL Constructors Westcoast 66 Surespan Construction Rate Name Test Date T Doesburg Danny 2009 07 Bergsma Fred 2009 04 new Hadikin D 2009 04 new Peterson B 2009 04 new Pierrot A 2009 04 new Schmaler Andreas 2009 04 new Simms J 2009 04 new Sudyko S 2009 04 new Boonstoppel Cylie 2009 07 new Steinke D 2009 01 new Ford M 2009 06 new 72 of 115 New Price Per 475444 483880 641298 641298 641298 641298 763563 763563 453431 650164 7226444 Firm Firm No gt Location CU 001 001 001 001 001 001 001 001 001 008 001 Contractors Su 721019 721027 721027 721027 721027 721027 721027 721027 721027 721028 722001 Contractors Summary WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE In this example the current H J _ unit price is 28 00 the new New New unit p
14. button to search When you select the Test Subject Last Name field you should see the message box that in e nup b Test Subject reminds you that you can enter the last name directly or search a test subject LastName Test lt Enter Last Mame or Click right mouse button to search The 1st Five Letters of Surname field are automatically extracted from the Test Subject Last Name field Test Subject Test Subject When you select the Test Subject Occupation field you should see the message box that reminds you that you can enter a description for the occupation directly or search a test subject ar Click right mouse button to search When you select the Employee Social Insurance No field you should see the message box that reminds you the valid format for this field naurange Employee Emplo Birth Date gt Employee Social Insurance Mo must be 9 digits 46 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE You will see the following error message if you entered a SIN that 7178 e SIM must be 9 digits is more or less than 9 digits You will see the following error message if you entered a SIN with non numeric character You will see the following error message if you entered an invalid SIN When you select the Employee Birth Date field you should see the message n Employee Empl
15. f 24 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE The file name of each A data file for E test with SIN is comprised of six parts 66 Audiogram c 1 2009 09 14 13 04 3 idat The file name of each audiogram data file for construction firm SIN refusal hearing test is comprised of seven parts SIN refusal 66 Audiogram form 1 2009 04 02 11 05 56 dat Part 1 is the prefix SIN refusal Part 5 is the date the file is generated 25 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE SIN refusal 66 Audiogram_form_ Part 6 is the time the file is generated Part 7 is the file extension dat SIN refusal 66 Audiogram form 1 2009 04 02 11 05 Open your Windows Explorer see Appendix A in Part 3 of the user manual 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 File Edit View Favorites Tools Help f n n JI Back P E pe Search lg Folders i2 x Address Ei Desktop Folders Size Date Modified Desktop 1 E Documents System Folder My Computer System Folder Network Places System Folder amp i My Network Places Recycle Bin System Folder 3x Recycle Bin internet Explorer S
16. firm location firm name and classification once they have been saved to the Firms tab 40 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Test Subject Info Test subject information consists of the first name last name occupation SIN birth date and gender of the worker being tested The column headings in the Audiogram Data Entry worksheet tab are shown below Test Subject Test Subject Test Subject Test Su bject The first name last name occupation social insurance number birth date and gender for the test subject are text fields that you can enter directly However each time an audiogram is saved in the Audiogram Data Entry tab test subjects that are not in the Test Subjects tab will be saved to the Test Subjects tab These test subjects are then available to be selected for future hearing tests Tip although you don t have to you can setup this information in the Test Subjects tab before entering data for a hearing test perhaps if you are given a list of subjects beforehand This enables you to pull in the test subject information when you are entering data for a hearing test and so the tests more quickly Setting up Test Subject in the Test Subjects Tab Type in the first name last name occupation SIN birth date in YYYY MM format and the gender Male or Female in the Test Subjects tab The Occupations field is
17. protectors mil 108 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Medical History Hearing Info 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 Hav ever had eve dizziness ase balance hea problems The following fields are related to a location field If Yes is selected then the location field must be filled in If No is selected then the location field will be blanked out even if you selected a value Have you A severe Have you A severe everhada Have you ever had ear ever had ear Ear surgery or b location head injury bla 7 location 109 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Have you ever had Exposure to e Exposure to eve exposure aloud blast a po a loud blast ah or explosion o ever had Trouble understanding Do you now have trou ble 110 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE 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 follo
18. tab will be automatically filled in with the selected firm information for you If the classification code is entered in the Firms tab for the selected firm the Classifications field in row 3 of the Audiogram Data Entry tab will also be automatically filled in too Here is an example of a elect irm x firm that has the classification code entered in the Firms tab in the screen shot below The classification code 721111 is shown enclosed in brackets 123456 001 721111 Benny Construction Ltd 1 Firm found search By C Firm Number Firm Name Search All Firms Zoom 10096 Firm Name b Select Firm Eg Search By Here is an example of a Firm Number Firm Name Search All Firms Zoom 100 firm that does not have the classification code Firm Name entered in the Firms tab in the screen shot below 654321 001 Sample Company 1 Firm found Here you can see the firm information is Firm Firm Test Subject Classification C filled in after you have 2 Number Firm Name Location First Name N clicked the Select Benny Construction Ltd button in the Select 4 click right Firm window po 38 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Selecting a Firm from the Firm Data File If you want to search the audiogramFirmCU dat file for a firm check the
19. Last Name E b o 4 IAC Lon sterlik 060 ron S 3 p 004378 0043 8 Canadian Forest Products Ltd O60 esterlik fal i Select any cells on the row you want to copy then click the Copy button In this example we have selected the cell for Firm Number in row 4 and clicked the Copy button WorkSafeBC Audiogram Session 1 You will see the following message box if there is already data in some of the fields in row 3 Click the Yes button will replace the Do you want to overwritten the existing data existing data in row 3 Click the No button will cancel the copy You can see the data in row 4 has been copied into row 3 of the Audiogram Data Entry tab Now you can make changes to any fields in row 3 Once you have finished your changes click the Save button to save the hearing test again as shown on the next page 15 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Display Chart Both Ears Copy to Row 3 Display Chart L amp R Ears Clear Row 3 save Row 3 Search Firm Firm Test Subject Test Su 2 Number Firm Name Location First Name w Middle S 4 0043 8 Canadian Forest Products Ltd 060 ron Enter First Name Once you click the Save WorkSafeBC Audiogram Session 1 button all the data in row 3 is validated again If there are no errors you will see this message to ask you to confi
20. Manufacture 712032 Precision Instrument Manufacture 721020 Pre engineered Steel Building Construction rit it Manufacture zi auiilud t Y MU i 714017 Pre Hung Door Assembly 714019 Pressed Board Manufacture not elsewhere specified 53 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Once you have the selected Select Classification Code classification code displayed Search By C Code Description Zoom 100 in the dropdown box as seen in the screen shot below you Classification Code Description can click the Select button and the Classification Code field will be automatically 714017 Pre Huna Door Assembly filled in for you 5 Classification Codes 0 New Classification Codes Cancel t Classification Entering Classification Code Field Directly When you select the Classification Code field you should see the message box that reminds you that you can enter a classification code directly or search for the classification code Classification Contrac Enter Classification Code ar Click right mouse button to search You will see the following error message if you entered a Microsoft Excel classification code that contains non numeric characters or has more or less than 6 digits You will see the following error message if you entered a classification code that is not in the C
21. This way you can force Do you want to use the selected previous result for Don Jone the audiogram program to use the test result from a test Yes that you know belong to the same person If you click the Yes button the test results for the current and previous years will be displayed in the same chart for comparison If you click the No button then since there is no previous test result the single year chart will be display You will see the following message box when you click 25 on any other tab to move away from the L amp R Ears Line 45 Chart Audiogram 30 tab Frequency in KHz Pitch Frequency in KHz Pitch S Cure Yer Leaf Previqus Year t Right Current Yaar Right Previous Year Click No if you want to review or print the chart later Click Yes if you want to hide the tab WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Optional Fields in Data Entry Mode The data fields for Noise History Medical History Hearing and Medical History Gen in the Audiogram Data Entry tab are all optional fields Occupation Codes Firms Test Subjects ta Audiogram Archived Data 2 44 Entering Noise History Info You can select one of the valid values from the dropdown list by clicking on the dropdown
22. a description field to further identify the test subject and it is not sent to WorkSafeBC A B c D c a FirstNames Last Names Occupations SIN Birthdate Gender John Doe Laborer 123456782 19 8 04 Male 41 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Va idatio n Microsoft Excel There is a check digit validation on the SIN field and you will see the following eo SIN 123456781 15 invalid error message if you type in an invalid SIN Microsoft Excel Birthdate 1978 13 is invalid Must be YYYY MM There is a validation on the Birthdate field and Microsoft Excel you will see the following error messages if you Birthdate 1978 04 is invalid Must be YYYY MM type in an invalid birthdates The first birth date has 13 as the month and the second birth date has a dash as a separator instead of the slash Microsoft Excel There is a validation on the Gender field too o Cons Uno E inel Must be Male or Femail 42 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Selecting a Test Subject from the Test Subjects Tab To select a test subject for a hearing test select any one of the Switch to Form cells in row 3 for Test Subject First Name Test Subject Last Name or Test Subject Occupations and click the Search button
23. contain hearing tests with SIN are processed on a daily basis The second type is sent whenever audiogram data files that contain hearing tests without SIN SIN refusal for construction firms is processed once a month WorkSafeBC does not process hearing tests with no SIN for non construction firms Audiogram Reports for Audiograms with Social Insurance Number After WorkSafeBC has received the audiogram data file or files that you have sent The files will be processed into our system once a work day Once the process is completed you will receive an email with the report Here is a sample of the report for contractor number 66 Application Work Safe BC Audiogrm amp Medical History Merged to output filename 1 IAS pcaudiogrm sdf Run date Wednesday September 09 2009 12 39 34 PM Batches merged 3 Tests merged 18 Files merged 3 Files merged from I IAS Audio File BACK UPs 2009 Electronic Records 09 2009 Sep Sept 9 2009V 66 Audiogram form 1 2009 09 08 15 51 48 dat 66 Audiogram form 1 2009 09 08 15 56 50 dat 66 Audiogram form 1 2009 09 08 15 59 48 dat End Batch Batch Firm Firm Form Count Numbers Locations Counts 1 178158 001 8 2 590376 001 5 3 590376 001 1 You should check the report for the followings 1 Ithasall the audiogram data files that you have sent 66 Audiogram form 1 2009 09 08 15 51 48 dat 66 Audiogram form 1 2009 09 08
24. file becomes a batch and is given a batch number for identification 21 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE If there are hearing tests for construction firms with no SIN in the Audiogram Data Entry tab you will see the following message box showing the file name and location of the generated audiogram data file Click OK to continue If there are hearing tests with SIN in the Audiogram Data Entry tab you will see the following message box showing the file name and location of the generated audiogram data file Click to continue WorkSafeBC Audiogram Session 1 Audiogram data file generated c WorkSafeBC Audiogram output SIN refusal 66 Audiogram form 1 2009 09 24 07 29 49 dat WorkSafeBC Audiogram Session 1 Audiogram data file generated c WorkSafeBC Audiogram output 66 Audiogram form 1 2009 09 24 07 29 49 dat Next you will see the following message box to confirm the number of hearing tests that have been generated into the audiogram file and the number of hearing tests that have been moved to the Audiogram Data Archive tab These two numbers will not be the same if there are hearing tests that have been generated before in the WorkSafeBC Audiogram Session 1 Audiogram Data Entry tab Because all hearing tests will be 5 records generated to audiogram data file archived to the Audiogram Dat
25. shown in the message At this point you can still click on the Cancel button to cancel the printing Next you will be asked if you want to preview the audiogram report before printing WorkSafeBC Audiogram Session 1 Click the Yes button to preview the audiogram report before directly to the printer Yes No Cancel At this point you can still click on the Cancel button to cancel the printing If you click the No button the audiogram report will be printed directly to the printer You will see the following message to confirm the audiogram report PLEET abtiss isiu has been processed 2 1 of 1 Audiogram Report printed If you click the Yes button to preview the printing you will see the audiogram report in the preview window Benny Construction Ltd 614069 001 Work Safe BC Audiogram Report Hours Hours in Type noise Wear ear Type wear P arri wear Office Pesistance Total Number Of Tug Tests 23 Excel 2003 Click the Print button at the top of the preview window to print the audiogram If you only want to review the audiogram then you can click the 88 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Close button to close the preview window Excel 2007 Click the Print icon at the top left corner of the preview window to print the
26. the Firms Tab Select Firm window When the Select Firm window comes up if you did not have the c WorkSafeBC Audiogram Data audiogramFirmCU dat file saved you will not see the Search All Firms checkbox and you can only search firms that are manually set up in the Firms tab Select Firm Search By ie Firm Number Firm Name Search Firm File provided Zoom 92 Firmi Number Only appears audiogramFirmCU dat Is present If you wish to have a complete set of firms to search see section Setting up Firms for Entering Hearing Tests in Part 1 of this manual for instructions on how to setup the audiogramFirmCU dat file 36 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE In our examples below we will use the screen shots with c WorkSafeBC Audiogram Data audiogramFirmCU dat file already setup The Search All Firms checkbox is unchecked by default in the Select Firm window As with all the options you may change this by checking the Search By Firm Number option and saving the spreadsheet To search by Firm number enter the firm number you want to search in the Firm Number field The search will narrow down the number of firms that match what you have typed so far In this example all firm Select Firm numbers start with 1 will be Search By retrieved If you type 12 Me Firm Number Fi
27. the data 34 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO DIFFERENCE Audiogram Data Entry This is done only in row 3 of the Audiogram Data Entry tab worksheet of the spreadsheet chive Parameters Test Firm Firm Test Subject Test Subject mum trm Ei ome aTa Subject Numbe UR TR 8 DAD 35 of 115 1 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Firm Info Firm number firm name firm location can only be selected from firms that you have setup in the Firms tab or selected from firms in the audiogramFirmCU dat file in the c WorkSafeBC Audiogram Data folder ao To ee ee ee ee ee EIE RUBENS s e e s s o 5 n c5 5 c5 To select a firm for a hearing test select any one of the cells for Or and then click the button Print Audiogram Audiograms Report Delete Selected Row s Clear Row 3 Copy to Row 3 Save Row 3 Highlight cell then Click oearch button or press right mouse button Tip Instead of clicking the Search button just click the right mouse button right click in Firm Number Firm Name or Firm Location to bring up the Firm Firm Test Subject Tes 27 Number Ler p a abr Selecting a Firm From
28. this Description Zoom 100 example all classification codes started Classihcalion Code with 72 will be retrieved into the dropdown list If you type 72102 then it will retrieve all the classification codes 721020 Pre enaineered Steel Building Construction start with 72102 One cannot type in a next number that does not have any matching classification codes For example since there is no classification 9 Classification Codes 0 New Classification Codes found code starts with 72109 in the Classification Codes tab then you will not be able to type 9 after the 7210 Search by description is the same except now you are entering the description of the classification code The search description text field is not case sensitive can continue typing the rest of the description until I find the classification code want or can select the classification code by clicking the classification code in the dropdown list Click on the dropdown button on the right hand side and click on the classification code that you want to select Select Classification Code Search By E C Code Description Zoom 10096 Classification Code Description 712032 Precision Instrument Manufacture 5 Classification Codes 0 New Classification Codes found Select Classification Code Search By C Code Description Zoom 10096 Classification Code Description pre 712032 Precision Instrument
29. 001 Jane Doe Office Assistance 31 DOE Benny Construction Ltd 001 Jane MacDonald Office Assistance 30 Mc MacDONA 614068 Benny Construction Ltd 001 John smith Office Assistance af SMITH Note You can only enter data into the cells in row 3 You will see the following error message if you try to enter data into a cell in any other rows Microsoft Excel The cell or chart that you are trying to change is protected and therefore read only AN To modify a protected cell or chart first remove protection using the Unprotect Sheet command Review tab Changes group You may be prompted for a password Making mass changes to data in Row 4 onwards If you really want to make a mass change to the spreadsheet e g to change the IAT Certification number incorrect firm number location etc you can unprotect the sheet and change data in any cell on row 4 on We suggest re protecting it after the needed change has been made Work Safe IAT o Show Ink 2012 05 2012 05 ommaents 32 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Data Validation Timing in Data Entry Mode The audiogram program is initially set up to perform validation as the hearing test data is entered in the Audiogram Data Entry tab By setting the Data Entry Validation parameter to Yes or No you can control whether validation for each field is performed as you are entering the data
30. 02 721043 Bennett Sheet Metal amp Heating Bennett Surveys Ltd 00637 00 RAD 582323 001 721028 Bennico 1997 Ltd 614069 001 721027 Benny ConstructionLtd J 39 of 115 WORK WORKING TO DIFFERENCE Once you have the selected firm displayed in the dropdown box as seen in the screen shot below you can click the Select button and the Firm Number Firm Name Firm Location and Classification fields in the Audiogram Data Entry tab will be filled in This method allows you to search for firms that have not been setup in the Firms tab Electronic Audiogram Program User Manual Part 2 of 3 Select Firm Search By C Firm Number Firm Name Search All Firms Zoom 100 Firm Name benn 614069 001 721027 Benny Construction Ltd 8 Firms found Cancel Firm Firm Test Subject Classification 2 Number Firm Name First Name gt Code un 614069 Benny Construction Ltd 001 721027 L Note each time you save a hearing test the program will save any firm number firm location firm name and classification combination in the Firms tab This means the next time you want to select that same firm number firm location firm name and classification combination for a hearing test you only need to search the Firms tab Tip you can make further changes to any firm number
31. 15 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Printing Audiogram for a Saved Hearing Test A full audiogram form or a summary audiogram of a hearing test can be printed The Print Audiogram button is used to print a paper form ofthe 1 audiogram for a saved hearing te test in the Audiogram Data Entry tab cear Form Mode Select a hearing test in the Delete Audiogram Data Entry tab and click the Print Audiogram Copy Display Chart Both Ears button Print Audiogram Report Save Display Chart L amp R Ears Firm Test Subject Test Subject 2 Number Firm Name Location First Name LastName 3 4 614069 Benny Construction Ltd 001 Jane MacDonald Of 5 You will see the following message if you selected row 3 TY AN Only saved data from row 4 onward can be printed You will see the following message if you selected an empty row No test result to print Please select a saved data row to print WorkSafeBC Audiogram Session 1 You will see the following message if you have selected a saved hearing test row Print Audiogram for selected data from Audiogram Exported Data tab Click the button to continue or the Cancel button to cancel the printing If you click the OK button you will see the following message to ask you if you want t
32. 15 56 50 dat 66 Audiogram form 1 2009 09 08 15 59 48 dat 70 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE In the example below there are 9 tests for firm number 590376 and location 001 in one file and 1 test for the same firm number 590376 and same location 001 in another file They are shown as two separate batches in the report Batch Firm Firm Form Count Numbers Locations Counts 1 178158 001 8 2 5903 6 001 9 3 5903 6 001 1 It has the correct number of tests Tests merged 18 You should contact WorkSafeBC if you find any discrepancies between the report and what you have sent in Audiogram Reports for Audiograms Without Social Insurance Number for Construction Firms After WorkSafeBC has received the SIN refusal audiogram data file or files that you have sent The files are not being processed immediately into our system All the SIN refusal audiogram data files are processed on the cutoff day of each month The cutoff date is the third Wednesday of each month Once the process is completed you will receive an email with the following report and an Excel workbook that contains more details of the payment Here is an example of the report for contractor number 66 WorkSafeBC Audiogram Version 1 0 Operations Log Application Work Safe BC Audiogrm amp Medical History SIN refusal audiogram extract and merge to worksheet Run date Wednesday
33. 41 SURNAME 455 508 OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM CODE CHANGE TYPE CATG DATE S I N NUMBER 011954 BAKER 711017 8215105 N B 072009 _ 255 001 101979 BAL 711017 9317422 N B N 072009 255 002 7 031957 BAQIS 711017 8215105 N NC 072009 255 003 061963 BENNE 711017 8215105 N B A 072009 255 004 bos 081946 BRISC 711017 8215105 N P NC 072000 255 005 031955 CHANT 711017 8215105 N B Ew 072009 255 006 091951 CHUNG 711017 8215105 N p NC 072000 255 007 111971 CUADR 711017 8215105 N P NC 072009 255 008 071979 CULL 711017 8215105 N NC 072009 255 009 NON MATCH DOB 041961 DAM 711017 8228458 N B N 072009 255 010 091958 DOUNG 711017 8228458 N P NC 072009 255 011 The BATCH NO is a sequence number assigned to each batch of hearing tests that is processed by WorkSafeBC When you call up WorkSafeBC to clarify a test in this report you will be asked for this number so we can find the hearing test in our system The BATCH DATE shows the date this batch is processed in our system This date might not be the date you send these tests to WorkSafeBC because they could be processed the next day But usually this date should be one or two days after you have sent the tests The FIRM LOC shows the firm number and location number of the batch The COMMENTS column shows the error message for each test Common Errors NON MATCH DOB Non Match Date
34. ANCE DRIVER EMERGENCY VEHICLE 7 7199847 ANIMAL CONTROL OFFICER not been updated to the 8786028 ASBESTOS WORKER INSULATOR Occupation Codes tab can be setup 9 8713675 ASPHALT WORKER in the New Codes tab temporary 10 8333726 ASSEMBLER 11 18513497 AUTO BODY SHOP WORKER 12 9315457 AUTOSTACKER OP SM PM 13 511255 AVALANCHE CREW TRAIL CREW FOREST TECH 14 19317101 BAGGER WRAPPER TIEUP BUNDLER STRAP BALER 15 8213033 BAKER D To select an occupation de for a hearing test m Tor a hearing test Codes Classification Description Occupation Descriptions 123456 Assistant Lab Technician Print Audiogram Print Audiogram Report select the cell for Occupation Code and Clear click the Search button Occupation Ye Delete on the Audiogram Data Entry tab Code Oc E Copy Display Chart L amp Ears Select Occupation Code When the Select Occupation Code Search By window comes up the search by Code Description Zoom 100 option defaults to the option selected the last time you have searched an occupation code Occupation Code 48 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Enter the occupation code you want to search The search narrows down the number of occupation codes In this example all occupation codes starting with 71 are retrieved int
35. BL Online Windows Internet Explorer provided by Worksaftebl File Edit View Favorites Tools Help ae Favorites WorkSafeBC Online z WORKING TO HAKE A DIFFERENCE Industrial Audiometric Business Centre Business centre WorkSa pdate profile Change password Welcome Ken Rushton ken rushton worksafebc com pdate access Account Dummy 2 215 Switch account Your last successful log on was May 31 2012 1 28PM Switch service 29 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Data Groups Row 1 Row 1 groups the headings into different categories reflecting the nature of the data you are entering e Firm Mandatory see picture above left e Test Subject Mandatory See picture above right e Test Method Mandatory e Noise Control Some Fields Are Mandatory e Test Result Mandatory e Frequency In kHz Pitch Mandatory e Noise History Optional e Medical History Hearing Optional e Medical History Gen Optional These are useful in navigation when entering the data 30 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE Special action buttons p At the top of the Audiogram Data Entry tab as part of row 2 are buttons for different functions you can perform Print Audiogram Audiograms Report Delete Selected Row s e Print an Audiogra
36. Construction Ltd 614069 001 Work Safe BC Audiogram Report Hours Hours away noise Wear ear Type Wear Birth from before eco wear before Test Date noise test Lz L3 Total Humbe Cf Hearing Tests 3 Excel 2003 Click the Print button at the top of the preview window to print the audiogram If you only want to review the audiogram then you can click the Close button to close the preview window Excel 2007 Click the Print icon at the top left corner of the preview window to print the S PrintPreview audiogram report Q ye y Previous Zoom Close Print Show Margins Preview Zoom Preview 9 If you only want to review the audiogram then you can click the Close Print Preview icon to close the preview window cay Print Preview B Close Frint 5 T Q _ Next Page LA Previous Page Print Page Zoom Setup show Margins Preview Print Zoom Previti j 91 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Excel 2003 amp 2007 You will see the following Print window Printer displayed if you click on the Print icon in the L Name ya 1 16 Properties preview window or if you chose to skip the d Status Tali preview Your printer name will be different re Canon iRS020 R6020 PCLSe Find Printer because
37. E R DIFFERENCE Printing Audiogram Report for all Firm Number Location and Name Here are the steps to print audiogram reports for all the hearing tests that have been saved in the Audiogram Data Entry tab The hearing tests for each firm location and firm name combination will be printed in a separate audiogram report Here is the sequence of windows that you will see if you have selected a Firm Number cell in any non empty row as in the following screen shot when you click the Print Audiogram Report button After you clicked the Print Audiogram Report button you will see the following message box Click the OK button to continue or the Cancel button to cancel the printing D Save Firm 2 Number Firm Name 2 4 548380 5 amp A Excavating Ltd 001 5 5 amp Excavating Ltd 001 Ber ny Construction Ltd 001 Berny Construction Ltd 001 Benny Construction Ltd 001 Location First Name Display Chart Both Ears Display Chart L amp R Ears Test Subject Don Patrick Jane Jane John Test Subject Last Name Jone More Doe MacDonald Smith Test Subject Occupe Office Assistance Office Assistance Office Assistance Office Assistance Office Assistance WorkSafeBC Audiogram Session 1 ES Print Audiogram Report Cancel Next you will be asked if you want to print audiogram reports for each firm and location with h
38. Each Test Result is Saved Now the hearing test result you have just entered is saved in the next empty row below row 3 of the Audiogram Data Entry tab Notice row 3 is cleared so you can enter the next hearing test result Clear Row 3 Dis Copy to Row 3 Dis WorkSafeBC Audiogram Sessio Emm Save Row 3 Test Firm Subject Test Subject Test Subject Subj 2 Number Firm Name ifle Name Last Name Occupation 4 004378 Canadian Fores c or 060 5 004378 Canadian Forest mouse button 060 ron S esterlik Geologist 62 7 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Move to column CD of the Audiogram Data ec FCD CE Entry tab by clicking on the scroll bar at the bottom of the Excel window as seen in the screen shot below You will find the date and time when you saved this hearing test in the Create Date and How Time field on column CD a i cigarettes TE per day The following sections are the validations that do you or This Record are performed before a hearing test result is did you Been Last Updated Date and smoke Generated Create Date and Time Time 2009 09 09 09 40 59 WorkSafeBC Audiogram Session 1 Mandatory Field Validation The following fields cannot be blank Test Booth of Audiometer You will see the following error message if any mandatory fields are n
39. Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE New Codes tab The New Codes tab is for classification codes and occupation codes that have not yet been added to the Classification Codes and Occupation Codes tabs New classification codes and occupation codes are setup in this tab temporarily so they can be used for a hearing test until they are updated to the Classification Codes or Occupation Codes tabs See section Update Classification Codes Tab in Part 3 of the user manual for instructions to update the Classification Codes tab and section Update Occupation Codes Tab in Part 3 of the user manual for instructions to update the Occupation Codes tab codes Classification Description Occupation Descriptions 2 654321 Computer Program 123456 Assistant Lab Technician 3 4 36 MH 4 Readme Parameters Ne Classification Codes 7 Occupation Codes Firms Test Subjects Classification Codes The Classification Codes tab contains valid classification codes for all the firms See section Update Classification Codes Tab in Part 3 of the user manual for instructions to update the Classification Codes tab 711004 Abattoir 762001 Accounting 713001 Acid Base Salt Chemical or Dye Manufacture not elsewhere specified 162002 Actuarial Services 766001 Acute Care IE A odo dli mmh a Meen
40. ING TEST BOOTH FIELD ENTERING TYPE OF AUDIOMETER FIELD ENTERING WAS YOUR AUDIOMETER CALIBRATED FIELD ENTERING NOISE LEVEL DBA FIELD ENTERING NOISE LEVEL IMPACT FIELD ENTERING HOURS AWAY FROM NOISE OR Hours IN NOISE BEFORE TEST FIELD ENTERING DO YOU REGULARLY WEAR EAR PROTECTORS AND TYPE OF EAR PROTECTOR WORN REGULARLY FIELDS ENTERING TYPE OF EAR PROTECTOR WORN BEFORE TEST FIELD ENTERING THE TEST TYPE FIELD ENTERING THE CATEGORY OF TEST FIELD ENTERING RELIABILITY FIELD ENTERING HEARING TEST RESULT FIELDS ENTERING OPTIONAL FIELDS AUDIOGRAM PROCESS REPORTS cesisecssesacasanssssesaseansasccannnssseedenesansensnsmnanssvennesnsessanninniseesanraaasesscasmneseseaasenneas AUDIOGRAM REPORTS FOR AUDIOGRAMS WITH SOCIAL INSURANCE NUMBER AUDIOGRAM REPORTS FOR AUDIOGRAMS WITHOUT SOCIAL INSURANCE NUMBER FOR CONSTRUCTION FIRMS SUMMARY WORK SAFE BC AUDIOGRAM ERROR How READ THE ERROR REPORT COMMON ERRORS NON MATCH DOB Non Match Date of Birth NON MATCH NAME INVALID TECH S I N Invalid Contractor Number or Technician SIN INVALID CLS SUB INDY Invalid Classification for the Firm and Location INVALID LOCATION DUP AUDIOGRM TEST DATE DUP EMP REC TEST DATE SUMMARY MODIFYING GENERATED HEARING TES T5 sss suia FRA RU SUN TK ERRAT CE PRSE OR
41. Ne BIRTH SURNAME CLASS SUB OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM COMMENTS DATE CODE CHANGE TYPE CATG DATE S X M NUMBER 541 071983 HAMIL 841110 9173276 B N 022009 66 001 Duplicate audiogram error This hearing test has already been sent in before and has been processed by WorkSafeBC The main cause of the duplicate errors is those previously sent hearing tests with other types of errors have been corrected by WorkSafeBC and were processed into our system The audio lab also made the corrections and resent the corrected hearing tests again to WorkSafeBC EMP REC TEST DATE S BIRTH SURNAME CLASS SUB OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM COMMENTS DATE CODE CHANGE TYPE CATG DATE 5a do M NUMBER xxx xxx 541 071983 HAMIL 841110 9173276 N B N 022009 66 001 DUP AUDIOGRM TEST DATE DUP EMP REC TEST DATE Duplicate audiogram error This error message always goes with the previous duplicate error This hearing test has already been sent in before and has been processed by WorkSafeBC The main cause of the duplicate errors is those previously sent hearing tests with other types of errors have been corrected by WorkSafeBC and were processed into our system The audio lab also made the corrections and resent the corrected hearing tests again to WorkSafeBC Summary Since the electronic audiogram program has replaced the paper audiogram form if there are errors in the tests that you sent WorkSaf
42. September 16 2009 06 56 07 AM Contractor 66 Tests merged 11 Files merged 1 Files merged from IM ASMAudio File 5 2009 Electronic Records 09 2009 Sep SIN Refusal Construction SIN refusal 66 Audiogram form 1 2009 09 04 17 05 12 dat End Batch 66 SIN Refusal Audiogram Repaor You should check the report for the followings It has all the files that you have sent SIN refusal 66 Audiogram form 1 2009 09 04 17 05 12 dat It has the correct number of tests 71 of 115 WORK BC WORKING TO MAKE A DIFFERENCE Tests merged 11 You should contact WorkSafeBC if you find any discrepancies between the report and what you have sent in Electronic Audiogram Program User Manual Part 2 of 3 The SIN Refusal Audiogram Report Excel workbook attached to the email has an All Contractors tab and a Contractors Summary tab All Contractors The All Contractors tab contains all the hearing tests in the SIN refusal audiogram files that are being processed Run Date Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM Wednesday September 16 2009 06 56 02 AM
43. UM o 7 Data Entry Validation PReaceat Mnisa Hietory tah After Pynart Nata Then select and click the No in the dropdown list as seen in the screen shot below b AUODIOOFAaM vvinaov soom vo 7 Data Entry Validation 8 Reset Noise History tab After Export Data 9 Reset Medical History Hearing tab After Export Data 33 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Now the program is setup to only perform the validation when you save the hearing test result in the Audiogram Data Entry tab 1 Session 1 2 WorkSafeBC Audiogram File Path cWorkSafeBC Audiogram output 3 WorkSafeBC Audiogram File Name Audiogram 4 Archived Data Unload File Path c WorkSafeBC Audiogramiarchive 5 Archived Data Unload File Name Audiogram b am Window Zoom 400 DES nige History tao After Export Data 9 Reset Medical History Hearing tab After Export Data Yes 10 Reset Medical History Gen tab After Export Data Yes i1 Audiogram Chart Zoom 90 i2 Construction Industry Firms Yes Medical History Reminder For Type Types of Baseline and 1st Time In 3 Noisy Industry Yes 4 Backup Data File Path c WorkSafeBC Audiogram backup 15 Save Workbook After Each Test Result is Saved No 6 Reset Noise Control tab After Export Data i No I7 Contractor Number In House Name 66 The rest of this manual assumes validation for each field is performed as you are entering
44. URO DR UC CE UE U ERU 20 SEPARATE PROCESSING STREAMS FOR SIN vs NO SIN RECORDS 20 BATCHES 21 FILE LOCATION AND FILE NAME FOR GENERATED AUDIOGRAM FILE 24 SUMMARY 27 ENTERING HEARING TEST RESULTS IN DATA ENTRY MODE sccsccssccsccecccsccsccecccsccscceccesccsscescescesccescess 28 DATA ENTRY MODE VS FORMS MODE 28 WHY DO WE DO THIS 29 Data Groups Row 1 30 Special action buttons 31 Data fields 31 Data fields Row 3 your audiogram entry point 31 Data fields Row 4 onwards 32 Making mass changes to data in Row 4 onwards 32 DATA VALIDATION TIMING IN DATA ENTRY MODE 33 AUDIOGRAM DATA ENTRY 35 Entering Firm Info 36 Selecting a Firm From the Firms Tab 36 ENTERING TEST SUBJECT INFO 41 Setting up Test Subject in the Test Subjects Tab 41 Selecting a Test Subject from the Test Subjects Tab 43 Entering Test Subject Info Fields directly into an audiogram 45 ENTERING OCCUPATION CODE FIELD 48 Select Occupation Code from the Occupation Codes Tab 48 Entering Occupation Code Field Directly 50 Displaying Occupation Code Description 51 Entering Classification Code Field 51 Entering Classification Code Field Directly 54 Displaying Classification Code Description 55 2 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE ENTERING YEARS AT THAT OCCUPATION FIELD ENTERING IAT CERTIFICATION NUMBER FIELD ENTERING A DATE OF TEST FIELD ENTER
45. WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO DIFFERENCE WORK BC WORKING TO MAKE DIFFERENCE Electronic Audiogram Program User Manual Part 2 of 3 Using Data Entry Mode Created by Benny Yu September 24 2009 Revised by Ken Rushton March 2011 May 2012 1 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE TABLE OF CONTENTS PREFACE e 5 ELECTRONIC AUDIOGRAM PROGRAM OVERVIEW ccsccssccsccecccsccsccecccsccsscnccesccsccescesccnccescesccnccescessoncceses 5 DATA ENTRY MODE FUNCTIONS ssessesseesessecsecsecsecsscscsecsecsecsecsecsecsecsececsecsecsecsessecsecsscsessesecsecsessecsecsecseesee 6 SAVING A HEARING TEST RESULT IN DATA ENTRY MODE 7 CLEARING HEARING TEST DATA IN DATA ENTRY MODE cccssccsccscccsccnccesccsccnccesccsccnccescsccnccescesccsccescs 12 CREATING TEMPLATES IN DATA ENTRY MODE ccscccccssccsccesccsccsccecccsccnccesccsccnccescscceccescescceccescessceccescs 13 MODIFYING A SAVED HEARING TEST wa tU ERU GP Y DIR QI SUP EH LES ODER 15 DELETING SAVED HEARING TESTS i scveenSucvkv vas Y XE KON FC OY OOV VER ER 19 GENERATING AUDIOGRAM DATA ISI UR EU YR HERO E CEN VI E
46. a Archive tab but not all will be generated into the audiogram data file Click OK to continue 5 records archived 22 of 115 WORK BC WORKING TO MAKE A DIFFERENCE You should see all the hearing tests in the Audiogram Data Entry tab have been moved to the Audiogram Data Archive tab Occupation Codes Firms Test Subjects Audiogram Exported Data Audiog Electronic Audiogram Program User Manual Part 2 of 3 4 tn Firm Number gt jFirm Name Firm Location Test Subject Test Subject First Name Last Name Test Subject Occup Firm 2 Number 548380 5 amp Excavating Ltd 4 548380 Is amp A Excavating Ltd 5 614069 6 614069 7 614069 8 614069 9 10 Benny Construction Ltd Benny Construction Ltd Benny Construction Ltd Benny Construction Ltd Firm Location Test Subject First Name 001 Don 001 Patrick 001 Jane 001 Jane 001 John 001 Jane 23 of 115 Test Subject Last Name Test Subject Oc Jone Office Assistance More Office Assistance Doe Office Assistance MacDonald Office Assistance Smith Office Assistance MacDonald Office Assistance ram Archived Data EE WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Go to column CC of the Audiogram Data Archive tab and you should see the hearing tests that were generated into the audiogram data file all hav
47. be displayed with the location of WorkSafeBC Audiogram Session 1 the audiogram web page files Click the Yes button to continue or the No button to abort the process Save Audiograms As HTML C Data If you click the Yes button you will see the full version audiogram in the preview window Benny Construction Ltd 614069 001 Firm Name Firm No Firm Location Jane MacDonald 30 Office Assistance 18115423 15 Name Age Occupation Occupation Code Years At That Occupation Male 1978 10 234567899 714017 Gender Birth Date Social Insurance No Classification U nit 66 2009 08 _ Yes SR Technician S I N Contractor Date of Test Test Booth Type of Audiometer No Yes Wes your sudiometer calibrated within the psst year by a service agency scoeptable to the Work Ssfe BC 93 96 No 2 4 Noise Level dBA Impact Hours In Noise Before Test Do you regularly weer ear protectors n Type of protector wore before test Periodic Good Test Type Category of Test Reliability SS Bia 5 8 8 8 0l 2 9 8 8 8 Printed Thu Sep 10 2009 01 55 38 Signature 97 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Summary version Benny Construction Ltd 614069 001 Firm Name Firm No Firm Location Jane MacDonald 30 Office Assistance Name Age Occupation SRS SF B B ec Bc B sion amp
48. been changed to 721024 for firm number 828138 and location number 001 BATCH NO 4672 BATCH DATE 20090911 FORMS COUNT HEADER 00000 B M BIRTH SURNAME DATE 176 041972 WEISH GEOZONE ORIGIN DISK 1 75 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE We will correct the classification code in the hearing test for this type of error and you don t have to resend the corrected hearing test again But you should update your record with the updated classification code we send back to you 76 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE INVALID LOCATION OPSCAN BATCH EDIT ERROR LIST BATCH NO 4854 BATCH DATE 20090917 FIRM LOC 200375 002 T GEOZONE ORIGIN DISK FORMS COUNT HEADER 00000 FORMS COUNT 1 S Re B BIRTH SURNAME CLASS SUB OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM COMMENTS DATE CODE CHANGE TYPE CATG DATE Sa Wu NUMBER xxx xxx 541 071983 HAMIL 841110 9173276 N B 022009 66 001 The location number is not valid for the firm number or the firm number is not valid In this example the firm number 200375 does not exist in the WorkSafeBC system You should call WorkSafeBC if you don t know which firm number you should using the firm that you have tested You need to resend the corrected tests again DUP AUDIOGRM TEST DATE es E
49. ble check the test date is entered correctly because majority of the hearing tests are performed in the same month they are entered into the audiogram program This is only a warning message and you may ignore it 58 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Test Booth Field When you select the Test Booth field you should see the message box that reminds you the valid values for this field Test Booth Yes No 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 You will see the following error message if you enter a value other Test Booth than Yes or No Entering Type of Audiometer Field When you select the Type of Audiometer field you should see the message box that reminds you to select a valid value from the dropdown list Select from the dropdown list Type of to the Audiometer 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 You will see the following error message if you enter a Microsoft Excel value other than Manual S R or MPU The value you entered is not valid A user has restricted values that can be entered int
50. button on the right hand side and then select one of the values in the dropdown list Occupation Codes Firms Test Subjects Audiog porte t Audiogram Archived Data 5 106 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE If answer to one or all of the following questions is Yes the Worn ear protectors while shooting Shot trap skeet target not hand guns and Shot hand guns fields will be validated in sequence when you click the Save button to save the hearing test WorkSafeBC Audiogram Session 1 Worn ear protectors while shooting must be entered Data not saved Please correct data and try again You will see the following message box if Worn ear protectors while shooting is filled in and Shoulder shot from is not filled in WorkSafeBC Audiogram Session 1 shoulder shot from must be entered Worn ear protectors al Data not saved Please correct data and try again while ASH shooting You will see the following message box if Worn ear protectors while shooting and Shoulder shot from are filled in and No of years is not filled in 107 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE WorkSafeBC Audiogram Session 1 e No of years must be entered Worn ear Data not saved Please correct data and try again
51. ccccccccccccceccccceecs 106 ENTERING NOISE HISTORY INFO 106 ENTERING MEDICAL HISTORY HEARING INFO 109 ENTERING MEDICAL HISTORY GEN INFO 112 4 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Preface This user manual is split into three word documents so they can be sent through email Part 1 Introduction amp Getting Started An overview of how the Hearing test data is collected howto enter hearing tests in the simpler Form Mode generate audiogram data files Links to the manual covering sending send them securely to WorkSafeBC though our portal Part 2 Data Entry Mode this volume 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 and incorporates many features to assist in entering accurate error free audiograms in the field This highly detailed manual is designed to assist audio labs that have little or no experience in using computers wi
52. ce Assistance Select one or more hearing 548380 Construction Ltd 001 Jane Doe Office Assistance tests in the Audiogram Data 1 A Excavating Ltd 001 Don Jone Office Assistance Entry tab Excavating Ltd 001 Patrick More Office Assistance y Construction Ltd 001 Amy Yu Office Assistance Excel 2003 Click on the Audiogram menu item and jAudiegram Help SEI the Utilities sub menu se CHEK Record Hearing Test Result Arial 12 B I U the Save Audiogram As Webpage MEC option from the following dropdown Print Audiogram v list This function is only available for F snagit 7 window audiogram program with version date SEEN AOR SEDIS or later than April 20 2010 Create Audiogram Report By Class Charts J Data Entry 3 Archive Previniis Year Data b 7 Backup b Load Firms From File About WorkSafeBC Audiogram Save Test Subjects To File Load Test Subjects From File Save New Codes To File Load New Codes From File Update Classification Codes Update Occupation Codes ave Audiogram Report As Webpage 94 of 115 WORK BC WORKING TO MAKE A DIFFERENCE Excel 2007 Click the Add Ins menu tab at the top of the Excel window and you should see the Audiogram menu Home Insert Click the Audiogram menu item and select the Utilities sub menu and click the Save Audiogram As Webpage option from the following
53. dropdown list This function is only program with version date on or later than April 20 You will see the following message click the OK button to continue or the Cancel button to cancel the action You will see the following message if you selected row 3 You will see the following message if you selected an empty row Electronic Audiogram Program User Manual Part 2 of 3 Work Safe BC Audiogram Program xls Compatil 1 Add Ins Page Layout Formulas Data Review View Developer Record Hearing Test Result Generate Audiogram File Print Audiagram Print Audiogram Report available for audiogram 2010 Charts k Data Entry Save Firms To File Utilities Load Firms From File Ba ckup Save Test Subjects To File About WorkSafeBC Audiogram Load Test Subjects From File Save Mew Codes File Load Mew Codes From File Update Classification Codes Update Occupation Codes Save Audiogram As Webpage save Audiogram Report As Webpage WorkSafeBC Audiogram Session 1 Create Audiogram HTML WorkSafeBC Audiogram Session 1 Only saved data from row 4 onward can be printed No test result to print Please select a saved data row to print 95 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Next you will see the f
54. e Chart Audiogram tab Frequency in KHz Fitch Click No if you want to review or print the chart later Click Yes if you want to hide the tab iogram Exported Data Audiogram Archived Data 101 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Displaying test results for both ears on separate line charts 102 of 115 WORK BC WORKING TO MAKE A DIFFERENCE Select the hearing test that you want to display in the audiogram line chart and click the Display Chart L amp R Ears button When you see the following message box click the OK button to continue or click the Cancel button to cancel the display chart process Electronic Audiogram Program User Manual Part 2 of 3 Print Audiogram Audiograms Report swen to romm wode _ Clear Row 3 Display Chart Both Ears CopytoRow3 Save Row 3 Make Template Firm eei Test Subject 2 Number Firm Name Location First Name 3 te 6C Mac 4 060 5 0043 8 Canadian Forest Products Ltd 060 Mac 6 zen WorkSafeBC Audiogram Session 1 Display Audiogram for selected data from Audiogram Exported Data tab OK Cancel 103 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Test Subjects Audi
55. e right hand side and then select one of the values in the dropdown list Noise Befor Or WorkSafeBC Audiogram Session 1 You will see this error message if you have selected a value in both the Hours Away From Noise and Hours In Noise Before Test fields You will see the following error message if you enter a value that is not from the dropdown list in either field 63 of 115 e The value you entered is not valid user has restricted values that can be entered into this cell Hours Away From Noise Either Hours Away From Noise or Hours In Noise Before Test must be entered Hours Hours In Do you Hours Away From Noise Either Hours Away From Noise or Hours In Noise Before Test must be entered Housrs In Moise Before Test Either Haurs amp way From Moise or Hours In Noise Before Test must be entered WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Do you regularly wear ear protectors and Type of ear protector worn regularly Fields These two fields are related to each other If you enter No in the Do you regularly wear ear protectors field you will not be able to enter any value in the of ear protector worn regularly field The Type of ear protector worn regularly field will be blanked out if you try to enter a value Select from the dropdown list If you enter Yes in
56. e the This Record Has Been Generated field set to Y CC CD CE This Record Has Been Create Date and Last Updated Date Generated Time and Time 2009 09 11 08 03 07 2009 09 11 08 04 08 2009 09 11 07 48 08 2009 09 10 13 43 39 2009 09 11 08 00 27 Occupation Codes Firms Test Subjects Audiogram Exported Data File Location and File Name for Generated Audiogram File The folder location and file name of the generated audiogram data file is setup in the Parameters tab The c WorkSafeBC Audiogram output folder will be created by the audiogram program if it does not exist c WorkSafeBC Audiogram output n loe Audiogramiarchive Archived Data Unload File Name Audiogram Audiogram Window Zoom 100 Data Entry Validation Yes Reset Noise History tab After Export Data Yes Reset Medical History Hearing tab After Export Data Yes Reset Medical History Gen tab After Export Data Yes Audiogram Chart Zoom 00 Construction Industry Firms Yes Medical History Reminder For Type Types of Baseline and 1st Time In Noisy Industry Yes Backup Data File Path c WorkSafeBC Audiogram backup Save Workbook After Each Test Result is Saved No Reset Noise Control tab After Export Data No Contractor Number In House Name 66 M 4 Readme Help Mew Codes Classification Codes Readv
57. eBC will send a copy of the error report to you Hearing tests with error will have an error message in the COMMENTS column of the error report indicating the type of error Hearing tests that need to be resend will be specified in the copy of error report that is sent to you The instruction will be written on the report Don t resend any hearing tests with error that have no specific instruction to resend written on the error report If in doubt please call WorkSafeBC to clarify 77 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Lynne Doi 604 233 4060 Penny Albers 604 279 8172 78 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Modifying Generated Hearing Tests From time to time it is necessary to make corrections to hearing tests that do not pass the validations in the WorkSafeBC system Some of the validation errors are the birth date or last name do not match the value in our record See section Work Safe BC Audiogram Error Report in Part 1 of the user manual for some of the common errors Follow these steps to modify hearing tests that have been generated and moved to the Audiogram Data Archive tab First you need to move the hearing tests from the Audiogram Data Archive tab to the Audiogram Data Entry tab See section Restoring Archived Hearing Tests in Part 3 of the user manual for detail ins
58. earing tests saved in the Audiogram Data Entry tab Click the Yes button to indicate that we want to print the audiogram report for all firms At this point you can still click on the Cancel button to cancel the printing Note You will not see the following message if you selected an empty row in the Audiogram Data Entry tab when you click the Print Audiogram Report button Next you will be asked if you want to preview each audiogram report before printing Click the Yes button to preview each of the audiogram WorkSafeBC Audiogram Session 1 WorkSafeBC Audiogram Session 1 Print Audiogram Report for all firms Preview before printing each audiogram report Yes No Cancel reports before printing click the No button to print the audiogram reports directly to the printer At this point you can still click on the Cancel button to cancel the printing 90 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE WorkSafeBC Audiogram Session 1 If you click the No button the audiogram report will be printed directly to the printer and you will see the following message to R confirm the audiogram reports have been processed Jj 2 of 2 Audiogram Reports printed If you click the Yes button you will see a preview window for each firm number firm location and firm name combination Benny
59. en Plates Shon ta Ketan amn ae PO a amda Malatad ta A eet Molin et fo ete betes 2 New Codes gt Occupation Codes Firms Test Subjects Audiogram Parameters Occupation Codes tab The Occupation Codes tab contains valid occupation codes for all the workers See section Update Occupation Codes Tab in Part 3 of the user manual for instructions to update the Occupation Codes tab Occupation Codes 1116621 SAFETY HYGIENE ANSPECTION OFFICER 1133699 TEACHER INSTRUCTOR 2111141 CHEMIST 2112141 GEOLOGIST 2117510 LAB TECHNICIAN 2131510 ENVIRONMENTAL SCIENTIST 21425n0 FNGINFFRIPI ASTICS H Parameters New Codes Classification Codes_ Occupation Codes Firms Test Subjects 10 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE Firms tab The Firms tab contains firms that you have setup to be used for entering hearing tests A Firm Firm Numbers gt Locations gt D Classifications gt 614069 001 IBenny Construction Ltd 721027 614069 001001 Benny Construction Ltd 714017 423456 001 Benny Construction Ltd 721111 423456 002 Benny Construction Ltd 721111 5548380 001 S amp A Excavating Ltd 721031 654321 001 Sample Company 342123 002 Sample Company 2 New Codes Classification Codes Test Subjects tab The Test Subjects tab contai
60. es hearing tests with SIN normal and hearing tests without SIN into separate files The generation process will only extract hearing tests without SIN with classification codes start with 72 construction firms into the audiogram data file for SIN refusal Hearing tests without SIN with classification codes that do not start with 72 non construction firms are not extracted into any audiogram data file All hearing tests in the Audiogram Data Entry tab will be moved to the Audiogram Data Archive tab after the generation process The file name of the generated audiogram data file for hearing tests with SIN is made up of the contractor number or in house name for in house testers the file name in the Parameters tab and the date and time when the file is created The file will have an extension of dat The file name of the generated audiogram data file for hearing tests for SIN refusal for construction firms is made up of the prefix SIN refusal the contractor number or in house name for in house testers the file name in the Parameters tab and the date and time when the file is created The file will have an extension of dat The audiogram data files will be created in the c WorkSafeBC Audiogram output folder which is specified in the Parameters tab The c WorkSafeBC Audiogram output folder will be created by the audiogram program if it does not exist 27 of 115 WORK BC Electronic Audiogram Prog
61. est subject 15 this the same employee again If you click Yes you will WorkSafeBC Audiogram Session 1 SEE tAE SOND WINE a A record with the same Firm Number Firm Location Employee Name and Birthdate Is found to ask you to confirm you 5 1 old 123456782 new 234567899 want to replace the existing hearing test In this case Do you want to replace the data the old SIN will also be replaced with the new SIN 17 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE WorkSafeBC Audiogram Session 1 Ed If you click Yes you will see the following message to confirm the changed hearing test has been saved Click the OK button to close the message box WorkSafeBC Audiogram Session 1 If you click No and the SIN has been changed you will see the following Is this the same test subject message to ask you to confirm the hearing test is for the same test subject John Doe BirthDate 1978 03 again If you click the change hearing test in row 3 will be saved to the next empty row beyond WorkSafeBC Audiogram Session 1 record with the same Firm Number Firm Location Employee Name and Birthdate 15 found row 4 as a new hearing test SIN old 123456782 new 234567800 Is this the same employee Save Display Chart L amp R Ears Employee Test ist Five Social Firm Firm Test Subject Test Subject S
62. f Surname value Mc MacCE for last names like Mace WorkSafeBC Audiogram Session 1 There are validations on the birth date field You will see the following error message if the birth date is invalid You will see the following error message if calculated age from the birth date of the test subject is less than 12 Employee Birth Date 10 age of worker cannot be less than 12 WorkSafeBC Audiogram Session 1 Any fields for the test subject can be changed after it is filled in from the Select Test Subject window Note that changes to data in the Test Subjects tab does not affect entered data in the Audiograms rows once copied into the row Entering Test Subject Info Fields directly into an audiogram 45 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Employee Show Hide Code Descri Social 967 82 4950 01 04 Male 12112141 4 You can also enter the test subject info directly into the fields in row 3 of the Audiogram Data Entry tab When you save the hearing test the test subject info that does not exist in the Test Subjects tab will be created in the Test Subjects tab Test Subject Test 5 First Name When you select the Test Subject First field you should see the message box that reminds you that you can enter the first name directly or search a test subject Enter First Mame or Click right mouse
63. feBC Audiogram Session 1 row has been deleted Data entry row deleted Click the OK button to close the message box 19 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Generating Audiogram Data File When you need to send the hearing tests that you have saved in the Delete Selected Row s Audiogram Data Entry tab to WorkSafeBC you must generate an Clear Row 3 audiogram data file that contains information for the hearing tests in the Copy to Row 3 Display Chart L amp R Ears Audiogram Data Entry tab The audiogram data file is the file that you Save Row 3 Search Ey upload to WorkSafeBC Firm Test Subject Test lt The generate audiogram data file Number Firm Name Location First Name Middl function always process all the hearing Canadian Forest me tests in the Audiogram Data Entry tab 004378 Ltd John 3 and move them to the Audiogram Data 4 004378 Canadian Forest Products Ltd 5 _Switeh to Form Mode Display Chart Both Ears ma Archive tab after the generation 0043 8 Canadian Forest Products Ltd O60 5 process Only hearing tests that have not been marked as generated will be extracted into the audiogram data file Templates are ignored by the generation process You can check if a hearing test has been generated before by going to column CC in the Audiogram Data Entry tab gm
64. for each audio lab are processed The payment cutoff date for each month is the third Wednesday of that month The purpose of the reports is for you to reconcile the hearing tests that you have sent to WorkSafeBC and what WorkSafeBC has received and processed Any discrepancies should be resolved with WorkSafeBC 73 of 115 WORK Part 2 of 3 WORKING TO MRKE R DIFFERENCE Electronic Audiogram Program User Manual Work Safe BC Audiogram Error Report Each hearing test with SIN in the audiogram data files that you have sent in is validated against the information we have stored in our system An example of the validation would be the SIN in the hearing test must match with the SIN we have stored in our system for an existing worker An error report is generated to show any errors for each batch of hearing test hearing tests for the same firm number and firm location in an audiogram data file being processed WorkSafeBC will send a copy of this error report to you so you can take the appropriate corrections Hearing tests for construction firms SIN refusal are not validated against information in the WorkSafeBC system We only store audiogram information for hearing tests with SIN How To Read The Error Report Here is a sample of the error report with the SIN masked for privacy SEP 11 2009 23 20 36 IAEDMOO1 PAGE 149 INDUSTRIAL SYSTEM 5002 OPSCAN BATC GEOZONE ORIGIN DISK AUER FOI i
65. ft Excel 61 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Noise Level Impact Field When you select the Noise Level Impact field you should see the message box that reminds you the valid values for this field The field is to indicate if the worker has been exposed to immediately damaging levels of sound Has worker been exposed to Impact noise 140 dBC or greater 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 You will see the following error message if you enter an invalid value Microsoft Excel 62 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Hours Away From Noise or Hours In Noise Before Test Field When you select the Hours Away From Noise field you should see the message Hours you ear box that reminds you either the Hours Noise regularly protec Away From Noise or Hours In Noise Before Before wearear Test field must be entered Test__ protectors regule Housrs In Noise Before Test Either Hours Away From Noise or Hours In Noise Before Test must be entered You can select one of the valid values from the dropdown list by clicking on the dropdown button on th
66. gram Data Archive tab to the Audiogram Data Entry tab See section Restoring Archived Hearing Tests in the user manual for detail instructions Once the hearing tests are moved back into the Audiogram Data Entry Print Audiogram Report tab you must reset the Y in the This Record Has Been Generated field to blank Copy Display Chart Both Ears Select the rows you want to reset the generated Sau Display Chart L amp R Ears indicator by selecting the EM Firm Number column of This Record the target rows LIU EN Has Been L 2 Number Name First Name Generated gt Create Date and Time T af R amp Excavating Ltd 001 Don Y 2009 09 11 08 03 07 1548380 5 Excavating Ltd 001 Patrick 2009 09 11 08 04 08 1614069 Construction Ltd 001 2009 09 10 13 43 39 80 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE Work Safe BC Audiogram Program xls Compatik Add Ins E ad is Home Insert Page Layout Formulas Data d Audiogram View Developer Review Click the Add Ins menu tab at the top of the Excel window and you should see the Audiogram menu Menu Commands Audiogram i elp secord Hearing Test Result Arial E12 ee Aa Click the Audiogram menu item and select the Generate Audiogram File Data E
67. he following error message if you enter 29 and the age of the test subject is only 31 because the earliest age for a worker is 12 So the maximum years a worker can work at an occupation is his age minus 12 31 12 19 You will see the following error message if you enter a non Microsoft Office Excel numeric character or a number less than O or greater than 75 in this field 56 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering TAT Certification Number Field This field is where you enter the testing Industrial Audiometric Technician s current Certification LAT on Certification Number The Industrial Audiometric Technician s number is 6 digits You will see the usual edit messages if it is missing on invalid 57 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Date of Test Entering a Date of Test Field When you select the Date of Test field you should see the message box that reminds you the format of this field See section Select Date of Test From The Calendar Window in Part 3 of the user manual for instructions on how to select a test date from the calendar window The usual date field edits are done You may also see the following warning message to remind you that you have entered a test date that is not the current month This is done to dou
68. ion Code Field Directly When you select the Occupation Code field you should see the message box that reminds you that you can enter an occupation code directly or search for the occupation code You will see the following error message if you entered an occupation code that contains non numeric characters or has more or less than 7 digits You will see the following error message if you entered an occupation code that is not in the Occupation Codes or New Codes tabs Electronic Audiogram Program User Manual Part 2 of 3 Select Occupation Code search By C Code Description Zoom 10096 Occupation Code Description lab 2117510 Lab Technician 2117510 Lab Technician 02474 8715423 La kre cupation Codes found 0 New Occupation Codes found Select Occupation Code search By Code Description Zoom 10096 Occupation Code Description lab 8715423 Labourer 3 Occupation Codes found 0 New Occupation a Enter Occupation Code or Click right mouse button to search Microsoft Excel 50 of 1 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE Displaying Occupation Code Description You can display the description of an occupation code by selecting the occupation code and then click the Show Hide Code Description button Show Hide Code Description Show Hide Code Description
69. lassification Codes or New Codes tabs 54 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Displaying Classification Code Description You can display the description of a Classification or Occupation code by selecting the classification code and then click the Show Hide Code Description button ShowlHide Code Description IAT Occupation Years At That Classification Certification Date of Test Code Occupation perm e de 2112141 a 10300 2112141 Click the Show Hide Code Description button again will hide the Classification or Occupation code description The Show Hide Code Description button will toggle between showing and hiding the code description 55 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Years at That Occupation Field Enter the number of years the test subject has been in the occupation entered in the n Years At That Occupation Code field in the Years At That Occupation field WorkSafeBC Audiogram Session 1 There is a validation that will not allow you to enter a number greater than the age of the test subject For example you will get the following error message if you enter 46 and the age of the test subject is only 45 e Years At That Occupation of 46 cannot be greater than Age of 45 For example you will get t
70. le WorkSafeBC Audiogram File Path c WorkSafeBC Audiogram outputt 4 WorkSafeBC Audiogram File Name Form 5 Archived Data Unload File Path cWorkSafeBC Audiogram archive 6 Archived Data Unload File Name Audiogram Backup Data File Path c WorkSafeBC Audiogram backup 8 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 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 19 ist Time In Noisy Industry Yes 20 Save Workbook After Each Test Result is 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 100 26 Batch File Size Limit Warning Message 80 M H Audiogram Data Entry Audiogram Data Archive Long Term Archive Parameters Codes Classification For more information see Part 3 of the user manual Parameter section 9 of 115 WORK BC
71. lity 8 0 8 5 8 8 83 51 2 8 8 8 8 Printed Thu Sep 10 2009 01 55 38 Signsture it Microsoft Excel Work Safe BC Audiogram Program xls i Laose _ em aad cay Print Preview Te _ Next Page lt Previous Page Zoom Clase Print Setup Show Margins Preview Zoom Preview Click the Print icon at the top left corner of the preview window to print the audiogram do c 84 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE P b If you only want to review the audiogram then you can click the Close Print dii Preview h imd S L Next Page review icon to close the preview window dh Y previous Page Print Page Zoom l Clase Print Setup Show Margins Preview If you click on the Print icon you will see the following Print window displayed Your printer name will be different because you will have a different printer setup Click the OK button to print the audiogram or click the Cancel button to abort the printing You will see the following message to confirm the audiogram has been processed You will see this message even when you aborted the printing at any stage of the process Print Zoom Previevs Lee ve Printer Name cil WPRTPO1IWPCP 16 Properties S
72. m Clear Row 3 Display Chart Both Ears e Print an Audiogram Report about all the data in the Audiogram Data Copy to Row 3 Display Chart L amp R Ears Entry tab e Clear row 3 completely Save Row 3 Search Generate e Go into Forms Mode e Delete rows of data e Search lookup a value e another row to row 3 e Save row to another row e Display Chart Both Ears e Display Chart L amp R ears Firm Firm Test Subject T Number Firm Name Location First Name These will be covered later Data fields Row 2 also contains the headings for each field of the audiogram Test Subject Test SL Wer Subject Data fields Row 3 your audiogram entry point Row 3 with a green background is where you enter the values for each field of the hearing test Once entered and validated on this row the row s data is then moved to the next empty row below when you click on the Save button Firm Firm Test Subject Test Subject Subject a MUT EDEN j FK Lire nm m ES 31 of 115 WORK Electronic Audiogram Program User Manual Part 2 of WORKING TO MRKE R DIFFERENCE Data fields Row 4 onwards From row 4 onward are the hearing tests that have been saved from the data entered in row 3 amp Excavating Ltd 001 Don Jone Office Assistance 2f JONE 15 amp Excavating Ltd 001 Patrick More Office Assistance of MORE Benny Construction Ltd
73. m Data File in Part 1 of the user manual for detailed instructions Print Audiogram Print Audiogram Report Form Mode Display Chart Both Ears Save Display Chart L amp R Ears This Record Finally you can send the generated Firm ir Test Subject Been La audiogram data file to Number Firm Name Location First Name Generated Create Date and Time Tir 2 WorkSafeBC See the section Send 3 ___ A Audiogram Data File To 4 548380 15 amp Excavating Ltd 001 Don 209 09 11 08 03 07 WorkSafeBC in PartdxoPthediser 5 548380 5 amp A Excavating Ltd 001 Patrick 2 09 09 11 08 04 08 6 614069 Benny Construction Ltd 001 Jane 2 109 09 10 13 43 39 1 manual for detail instructions Summary To resend generated hearing tests you must move the hearing tests from the Audiogram Data Archive tab back to the Audiogram Data Entry tab and reset the This Record Has Been Generated fields from Y to blanks Once the This Record Has Been Generated fields are reset to blanks you can generate and send the audiogram data file to WorkSafeBC again Duplicate hearing tests for the same firm number firm location and SIN will not be processed again by WorkSafeBC These hearing tests will be identified as duplicates in the validation process See section Work Safe BC Audiogram Error Report in Part 1 of the user manual on how to read the error report sent to you by WorkSafeBC 82 of 1
74. nd firm number firm location and firm name When you print the audiogram reports the hearing tests for firm number 123456 and location 001 will be separated into two different audiogram reports Example firm number 123456 location 001 firm name Benny s Construction Ltd firm number 123456 location 001 firm name Benny s Construction Ltd Division one Saving Audiogram Report as Web Page This function has been included as an option when you print the audiogram report See 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 92 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE 93 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Saving Audiogram As Web Page This function saves the audiograms as standalone web page files so you attach these web page files to an email to send to a client This function saves the selected audiograms in the Copy Audiogram Data Entry tab Print Audiogram Report Display Chart Both Ears and lets you preview each y die selected audiogram first before saving each Fim T Test Subject uu 2 Number Firm Name LastName Subject Occupatior audiogram as a web page Construction Ltd 001 Yu Benny Offi
75. ns workers that you have setup to be used for entering hearing tests or contains workers that have been used in a saved hearing tests A a C an First Names Last Names Birthdate Gender John Doe Laborer 123456782 19 8 03 Male Jane Doe1 Office Assistance 111111118 19 8 01 Female Don Jone Office Assistance 111111134 1982 09 Male MacDonald Office Assistance 2345617899 1978 10 Female Jane MacDonald Office Assistance 234567899 19 8 10 Female New Codes Classification Codes Occupation Codes Firms Test Sub ts SAudiogram Exported Data 11 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Clearing Hearing Test Data In Data Entry Mode The Clear button is used to clear all the data entered in row 3 of the Audiogram Data Entry tab Normally the hearing test data in row 3 is cleared after it is saved when you clicked the Save button But there may be time when you want to quickly clear the data in row 3 for entering another hearing test m LI LI Print Audiogram Audiograms Report Delete Selected Switch to Form Mode Display Chart Both Ears Copy to Row 3 Display Chart L amp R Ears Save Row 3 Search Generate Firm Firm Test Subject Test Subject Test Subject _2 Number Firm Name Location First Name Middle Name Last Name 4 1004378 Canadian Foresf Click right
76. nt 40 to review or print the 45 chart later Click Yes 55 if you want to hide 60 the tab diagram Exported Data Audiogram Archived Data Displaying test results for both ears on the same line chart Select the hearing test that you want to display in the audiogram line chart and click the Display Chart Both Ears button When you see the following message box click the OK button to continue or click the Cancel button to cancel the display chart process Firm Test Subject Test Subj 2 Number Firm Name Location First Name Last Nam 3 porem 115483 S amp A Excavating Ltd 001 Don Jone 15 amp Excavating Ltd 001 Patrick More 5 714069 anny Construction Ltd 001 Jane Doe 7 614069 Benny Construction Ltd 001 Jane MacDonalt 8 614069 Benny Construction Ltd 001 John Smith WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Next you will be asked to choose the type of chart Click Bet ancud the No button to display a line chart Display Bar Chart Yes Bar Chart Mo Line Chart Cancel Next you will see the audiogram line chart with the test result for left and right ears side by side in the Both Ears Line Chart Audiogram tab Patrick More Both Ears Line Chart Audiogram on 2009 08 You will see the following message box when you click on any other tab to move away from the Both Ears Lin
77. ntry sub menu and click the Reset Print Audiogram T ents SnagIt window Generated Indicator option from the following Print Audiogram Report 2 i im dropdown list t e Data Entry Override 1st Five Character of Last Name Archive b Save Data Template Utilities b Reset Generated Indicator Backup b Clear Data About WorkSafeBC Audiogram Copy Data Save Data Delete Data Path Caral Override 1st Five Character of Last Save Data As Template Generate Audiogram File Clear Da Print Audiogram Print Audiogram Report Capy Data Save Data Delete Data Utilities Backup About WorkSafeBC Audiogram The following message box will be displayed click the button to WorkSafeBC Audiogram Session 1 continue or the Cancel button to abort the reset process Reset the currently selected data entry row The following message confirms the number of rows that are reset Click the OK button to close the message box 3 Data entry row reset OK 81 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Now you should see the This Record Has Been Generated fields for the selected rows have been reset to blank Now you can generate a new La CD audiogram data file containing the hearing tests you have moved back to the Audiogram Data Entry tab See the section Generate Audiogra
78. o the dropdown list Thus 711 retrieves all the firm numbers starting with 711 You cannot type in a number with no matching occupation codes For example since no occupation code starts with 712 in the Occupation Codes tab then you will not be able to type 2 after 71 Search by description is the same except now you are entering the description of the occupation code The search description text field is not case sensitive Select Occupation Code enisi By rom Description Zoom 100 Occupation Code 7112269 Aaricultural Worker 5 Occupation Codes found 0 New Occupation Codes found Select Occupation Code Description Zoom 100 Occupation Code Description lab 2117510 Lab Technician 3 Occupation Codes found 0 New Occupation Codes found 49 of 115 WORK BC WORKING TO MAKE A DIFFERENCE One may continue typing the rest of the description until the desired occupation code is found Or one can select the occupation code by clicking the occupation code in the dropdown list Click on the dropdown button on the right hand side and click on the occupation code that you want to select Once you have the selected occupation code displayed in the Select Occupation Code window as shown in the screen shot below you can click the Select button and the Occupation Code field will be automatically filled in for you Entering Occupat
79. o preview the audiogram before printing 83 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Click the Yes button to preview the audiogram before print click the No button to print the audiogram directly to the printer Next you will see the following message to ask you whether you WorkSafeBC Audiogram Session 1 want to print the full or summary audiogram Click the Yes button to print the full version and No button to print the summary version If you click the Yes button you will see the full version audiogram in the preview window if you have chosen preview audiogram earlier Otherwise the full Construction Ltd 614069 001 version audiogram will be printed directly to the Fame Fiminosin pri nter Jane M acDonakd Office Assistance mA Vase Occupation Male 19780 234567899 714017 Su mmary version IS shown Gender Birth Date Social Insurance No Classification U nit 66 9009 08 Yes SR Technician S I N Contractor Date of Test Test Booth Type of Audiometer No Yes Was your sudiometer calibrated within the year by service agency acceptable to the Work Safe BC 93 96 No 2 d 4 Noise Level dBA Impact Hours In Noise Before Test Do you regularly weer ear protectors os Type of ear protector wore before test Periodic mE _ Good Y Test Type Category of Test Reliabi
80. o this cell 59 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Was your Entering Was your audiometer calibrated Field audiometer When you select the Was your audiometer calibrated field you should see the message box calibrated that reminds you the valid values for this field within the past year by a service Was your sidus audiometer calibrated acceptable N within the to the Work Lt Yes No You can select one of the valid values from the dropdown list by clicking on the dropdown button on the right hand side aoe Was your and then select one of the values in the dropdown list Se audiometer 224231 calibrated within the You will see the following error message if you enter a value other than Yes or No 60 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Noise Level dBA Field When you select the Noise Level dBA field you should see the message box that able Noise reminds you to select a valid value from the dropdown list Vork Level 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 Select from the dropdown list You will see the following error message if you enter an invalid value Microso
81. of Birth FORMS COUNT 00000 FORMS COUNT COMPUTER 5 5 I N SURNAME CLASS SUB OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM COMMENTS CODE CHANGE TYFE CATG DATE 5 I N NUMBER XXX XXX 480 ROSS 732024 9151201 N NC 072009 255 006 NON MATCH DOB 74 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE The birth date sent in is 11 1965 but WorkSafeBC record shows it as 11 1985 We will correct the birth date in the hearing test for this type of error and you don t have to resend the corrected hearing test again However if you know the birth date 11 1965 you sent is correct you should call WorkSafeBC to correct the birth date in the WorkSafeBC record If your record of 11 1965 is incorrect you should correct the birth date for this worker in the Test Subjects tab of the audiogram program But you don t need to send in the corrected test again NON MATCH NAME S I N BIRTH SURNAME CLASS SUB OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM COMMENTS DATE CODE CHANGE TYPE CATG DATE 5 I N NUMBER 803 031957 BAQIS 711017 8215105 N P NC 072009 255 003 NON MATCH NAME The 1st five characters of last name sent in BAOIS but our record shown it as SHEER We will correct the 1st five characters of last name in the hearing test for this type of error and you don t have to resend the corrected hearing test again However if you kno
82. ogram Exported Data Audiogram Archived Data L amp Ears Line Chart Audiogram Next you will see two separate audiogram line charts with the test result for left and right ears in the L amp R Ears Line Chart Audiogram tab L LLL LLL O eee e gt O ee __ m i Oooo oo ee T M Ecc p 5 55 __ o _ LLL y 60 pj 65 70 75 80 85 __ To 90 o 95 o ee 100 2 3 Frequency in KHz Pitch Frequency in KHz Pitch Test Subjects Audiogram Exported Data Audiogram Archived Data 1 amp Ears Line Chart Audiogram lt ER CI 104 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE If the test type is Periodic the audiogram program will WorkSafeBC Audiogram Session 1 bq search the Long Term Archive tab to find a previous year test with the matching SIN or for no SIN tests with matching first name last name and birth date DD Previous test result for 2009 found You will see the following message if a matching test is found in the Long Term Archive tab WorkSafeBC Audiogram Session 1 You will see the following message if a matching test is not found in the Long Term Archive tab but you have selected a No previous test result found test in the Long Term Archive tab
83. ollowing message to ask you whether you want to print the full or summary audiogram WorkSafeBC Audiogram Session 1 Print full audiogram Yes Full No Summary Click the Yes button to print the full version and No button to print the summary version Next you will see the following message to ask you if you want to save the audiogram webpage file in the default location The location of the audiogram report webpage file is specified in the Parameters tab WorkSafeBC Audiogram Webpage File Path c WorkSafeBC AudiogramWwebpage If you click the button or if the location of the audiogram report webpage file specified in the Parameters tab is blank then you will be asked to specify the location WorkSafeBC Audiogram Session 1 Save Audiograms As HTML in c WorkSafeBC Audiogram webpage Excel 2003 amp 2007 The Browse for Folder window will be displayed for you to select the folder that you want to save the audiogram web page files In this example the c WorkSafeBC Audiogram Data folder is selected Click the OK button to continue Browse for Folder Select Directory G WCB C H apps BSort 4 Check Out Files E CMS Forms Config Msi and Settings dotNetProjects ow Cancel 96 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE The following message will
84. om the dropdown list Select from the dropdown list Category lof Test 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 lof Test Select from the dropdown list You will see the following error message if you enter an invalid value in the Category of Test field Microsoft Excel 66 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Reliability Field When you select the Reliability field you should see the message box that reminds you all the valid values can be selected from the dropdown list Select 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 Select from the dropdown list You will see the following error message if you enter an invalid value in the Reliability field Microsoft Excel Entering Hearing Test Result Fields When you select any one of the hearing test result fields you should see the message box that reminds you all the valid values can be selected from the dropdown list Right Right Right Right Right Right Right 05 ear1 ear 2 ear 3 ear 4 ear 6 ear 8 i KHZ KHZ KHZ KHZ KHZ
85. or performed only when you save the data You might elect to do the latter if you are expert at the system and just want to first key in all your data raw then review and correct second The Data Entry Validation parameter value is initially set to Yes in the Parameters tab Audiogram Data Entry Audiogram Data Archive Long Term Archive Parameters New Code A 1 Session 1 2 WorkSafeBC Audiogram File Path c WorkSafeBC Audiogram output 3 WorkSafeBC Audiogram File Name i Audiogram 4 Archived Data Unload File Path c WorkSafeBC Audiogramiarchive 5 Archived Data Unload File Name Audiogram 6 Audizaram Wisdsw Zoom 400 7 Data Entry Validation Yes 8 Reset Noise History tzo After Export Data res 3 Reset Medical History Hearing tab After Export Data Yes 10 Reset Medical History Gen tab After Export Data Yes 11 Audiogram Chart Zoom 90 12 Construction Industry Firms Yes Medical History Reminder For Type Types of Baseline and 1st Time In 13 Noisy Industry Yes 14 Backup Data File Path c WorkSafeBC Audiogram backup 15 Save Workbook After Each Test Result is Saved No Reset Noise Control tab After Export Data No 17 Contractor Number In House Name To change the Data Entry Validation parameter value select the cell with the Yes and then click the dropdown button on the right hand side of the cell as seen in the screen shot below 9 Fuulocouram vviniduovy SU
86. ot 654321 been updated to Occupation Descriptions Assistant Lab Technician Computer Program the Classification Codes tab can be setup in the New Codes tab Classification Codes Occupation Codes Firms Test Subjects New Codes If you have entered the classification code the Firms tab when you setup the firm that you have selected the classification code should be automatically filled in for you when you selected the firm However you can always select a different classification code at anytime 51 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE R DIFFERENCE Display Chart L amp R E To select a classification code for a hearing test select the cell for Classification Code and click on the Search button on the Audiogram Data Entry tab 3 1 1 at Classification i Code Nur 721027 Select Classification Code When the Select Classification Code Search By window comes up the search by option will ono M csse default the option you have selected the Classification Code last time you have search a classification code os PT Select Cancel 52 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Enter the classification code you wantto TTE search The search narrows down the aarch By list to match what is typed so far In
87. ot entered Data not saved Please correct data and try again Firm and Classification Code Validation If the c WorkSafeBC Audiogram Data audiogramfirmcu dat file that contains all the firm number firm location firm name and classification code combinations is setup 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 SUE hearing test by clicking on the Yes Firm number 614069 Firm Location 001 and Class Code 714017 is not found in the button if you are sure the combination c data audiogramfirmcu dat data file you entered is valid If you know 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 Note If the file audiogramfirmcu dat is not setup then you will not see the above warning message Do you still want to save data 8 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Parameters Tab The Parameters tab contains parameters that control the audiogram program 9 7 save Ctrl 5 Je WorkSafeBC Audiogram File Path O 3 1 Session 1 2 Default Drive
88. oyee Occt box that reminds you that you can enter the date directly or select from the Birth Date G calendar window See section Select Birthdate from the Calendar Window in Part 3 of the user manual for instructions on how to select a birth date from Enter Employee Birth Date th lendar wind YYYY MM d Click right mouse button to bring up calendar When you select the Employee Gender field you should see the message box that Employee reminds you all the valid values can be selected from the dropdown list Select 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 selecting a value in the dropdown list Employee Occup Gender Code Select from the dropdown list 47 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Occupation Code Field You can either select the Occupation Code field from the Occupation Codes tab or enter the value directly Select Occupation Code from the Occupation Codes Tab Occupation Descriptions All the valid occupation codes for a A worker are stored in the Occupation Occupation Codes tab 2 7112269 AGRICULTURAL WORKER 8533713 AIR CONDITIONING MECHANIC 4 8515024 AIRCRAFT ASSEMBLER 5 8582024 AIRCRAFT WORKER GROUND CREW 5 9173276 AMBUL
89. r worn before test field can be entered or left blank Type of ear Select from the Type dropdown list protector wore before or 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 Type of ear protector wore before Select from the dropdown list You will see the following error message if you enter an invalid value in the Type of ear protector worn before test field Microsoft Excel 65 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering the Test Type Field When you select the Test Type field you should see the message box that reminds you all the valid values can be selected from the dropdown list Select from the You can select one of the valid values dropdown list 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 Baseline Select from the dropdown list You will see the following error message if you enter an invalid Microsoft Excel value in the Test Type field Entering the Category of Test Field Category lof Test zal When you select the Category of Test field you should see the message box that reminds you all the valid values can be selected fr
90. ram User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Entering Hearing Test Results in Data Entry Mode Data Entry Mode VS Forms mode You can enter hearing tests either in Data Entry Mode or Form Mode Form Mode shown in the First section of this manual is used for entering hearing tests while conducting the tests in the field or by beginners as it is more user friendly Data Entry Mode shown below is used for entering a large number of hearing tests back at the office as this method is quicker It is also excellent for correcting audiograms with errors 004378 B Print Audiogram Audiograms Report Delete Selected Row s Clear Row 3j Display Chart Both Ears Display Chart L amp R Ears sen EI Firm Test Subject Test Subject Test 51 Occup Test Subject Canadian Forest Products Ltd In Data Entry Mode each hearing test is entered directly into row three of the Audiogram Data Entry tab Hearing test results are stored here and audiogram data files are generated from this location Data entry is done in the Circled red row 3 you see above 28 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE Why do we do this As each hearing test is entered it is saved and generated into a Audiogram data files that can be uploaded to the Industrial Audiometrics portion of WorkSafeBC s web site arksate
91. re often test conditions that are common for series of hearing tests For example the firm number firm location firm name classification test date test booth and type of audiometer could be the same for a test site You can save common data patterns as Templates in the Audiogram Data Entry tab and you can copy the data in a selected template to data entry row 3 then fill in the remaining data for the hearing test Enter data for the data pattern in rows 3 In this example have entered the firm number firm name firm location and classification code Firm Test Subject 2 Number Firm Name Location First Name Code 3 123456 BennyConstrctionltd 002 721111 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 Entry sub menu and click the Save Data As Template option ntj amp udiogram intj amp udiogram Report Audiogram Report By Class Save Data As Template prefilled firm information etc Reset Generated Indicator on selected rows 13 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MAKE A DIFFERENCE The next message box confirms the template has been saved Click to close the message box The template is always saved at the top of all the other hearing tests below row 3 Templates are identified by a prefi
92. rice is 35 00 and the Price Rate new price will be applied to Rate Price Per Per Eff any hearing tests with a test Test Date Form 28 00 Form 35 00 Date 2009 01 date on or after 2009 01 The 2009 07 new Rate column shows 2009 04 new what price each test is paid 2009 04 new The Contractors Summary tab contains a summary of each classification code and the total payment amount Contractors Summa From Wednesday September 16 2009 06 56 02 AM To 2256 02 14 hes ue ap Contractor No CUCODE Forms Unit Price Amount Total 2 _ of hearing tests and the total 66 721019 1 35 00 35 00 payment amount is correct You 66 721027 8 35 00 280 00 should contact WorkSafeBC if you 86 721028 1 35 00 35 00 find any discrepancies between the 66 722001 1 35 00 35 00 report and what you have sent in RB 11 385 00 Summary You should receive an email report when you send in audiogram data file that contains hearing tests with SIN or hearing tests for SIN refusal Audiogram data files contain hearing tests with SIN are processed immediately and the process reports sent in the email Audiogram data files contain hearing tests for construction firm with SIN refusal are not processed immediately All these type of audiogram data files received on or before the payment cutoff day are processed on the payment cutoff day of each month The process reports are sent in the email after the files
93. rm Do you want to replace the data that you want to replace the existing hearing test A record with the same Firm Number Firm Location and Employee SIN is found Name John Doe 16 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE The firm number firm location and employee SIN is used to find the hearing test row to find the row to update When you are changing the SIN of a hearing test then there will not be a match between the updated hearing test in row 3 and the one already entered and saved In the situation when there is no positive SIN match the firm number firm location employee first name employee last name and birth date are used to find a match If such match is found you will see the following Is this the same test subject message to ask you to confirm the hearing test found is for the same firm John Doe BirthDate 1978 03 and test subject that you want to save from row 3 WorkSafeBC Audiogram Session 1 Click Yes to confirm the hearing test you want to save is for the same hearing test that was saved before Click No if you want to save this hearing test as a new row If you click Yes and the SIN TH has been changed you will see this message to ask you A record with the same Firm Number Firm Location Employee Name and Birthdate is found to confirm the hearing test S L N old 123456782 new 234567899 is for the same t
94. rm Name Search All Firms Zoom 100 then it will retrieve all the NS pe firm numbers start with 12 It will not allow you to type in the next number that does 123456 001 721111 Benny Construction Ltd not have any matching firm numbers 1 Firm found For example if there are no firm numbers start with 14 in the Firms tab then you will not be able to type 4 after the 1 Searching by firm name is Select Firm the same except now you Search By are entering the name of C Firm Number Firm Name Search All Firms Zoom 10096 the firm in the search text The firm name you type is not case sensitive D You can also click on the 123456 001 721111 Benny Construction Ltd dropdown button on the right hand side to see the list of firms available for 1 Firm found you to select so far searching for is in the Search By dropdown list select Firm Number Firm Name Search All Firms Zoom 100 double click the entry on the dropdown list Firm Name 654321 001 Sample Company EP 854321 O04 342123 002 sample Company 2 2 Firms found Camel WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE When the entry you want is in the box then click the Select button and the Firm Number Firm Name and Firm Location fields in row 3 of the Audiogram Data Entry
95. t Hours Hours in Type noise Wearear Type wear before protector wear before Test test Date LOS Li L 13 14 16 L8 RO05 R1 R2 R3 RA RG R8 2 4 Flug Sood 1 0 Total Number Of Hearing Tests 23 Next we will learn how to print audiogram report for one specific firm or for a group of firms in the Audiogram Data Entry tab 86 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Printing Audiogram Report For A Specific Firm Number Location And Name Here are the steps to print one audiogram report to 1 show all the hearing tests that have been saved in the Audiogram Data Entry tab il ave for a specific firm number Delete firm location and firm name Copy Select the Firm Number cell in any row for the firm you want to print as in the Firm Test Subject Test Subject following screen shot and 2 Number Firm Name Location First Name LastName Test Subject Occupe click the Print Audiogram 3 Report button 4 548380 S amp A Excavating Ltd 001 Don Jone Office Assistance 5 amp Excavating Ltd 001 Patrick More Office Assistance Ber ny Construction Ltd 001 Jane Doe Office Assistance IBe y Construction Ltd 001 Jane MacDonald Office Assistance Benny Construction Ltd 001 John amith Office Assistance WorkSafeBC Audiogram Session 1 E The next message box will be displayed Click the OK but
96. tatus Idle Type Canon iR 5020 IR6020 PCL5e Where RC21 iR6020 ISD Development Services 10 2 112 249 Comment RC21 iR6020 ISD Development Services Print to file 10 2 112 249 Find Printer Print range Copies all Nod Print what T O Selection CO Entire workbook ji Active sheet s C Ignore print areas Cancel WorkSafeBC Audiogram Session 1 85 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Printing Audiogram Reports for Saved Hearing Tests D audiogram report contains the hearing test results for a firm number firm location and firm name for hearing tests that have been saved in the Audiogram Data Entry tab Audio labs can use this function to print audiogram reports to send to their clients Copy which are the firms in the tests Display Chart Both Ears Save Display Chart L amp R Ears The Print Audiogram Report function allows you to print audiogram reports for a selected E mM IEEE 2 Number Firm Name First Name Last Name firm number firm location and firm name or a separate audiogram report for each ofthe 41614069 Benny Construction Ltd 00 Jane MacDonald firm number firm location and firm name is a sample of audiogram report for firm 614069 001 Benny Construction Ltd 614069 001 Work Safe BC Audiogram Repor
97. th screenshots for every step in the instructions and likely errors This manual is updated as new features are added 5 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Data Entry Mode Functions There are eleven buttons on the Audiogram Data Entry tab that perform all the functions available on this tab Audiograms Report Delete Selected SwitchtoFormMode Clear Row 3 Display Chart Both Ears Copy to Row 3 Display Chart L amp R Ears Save Row 3 Search Generate Firm Firm Test Subject Te Number Firm Name Location First Name P CN 004378 060 ron S 0043 8 Canadian Forest Products Ltd O60 ron S Print Audiogram prints a saved hearing test result in paper form Clear clears all the data entered in row 3 Delete removes all the saved hearing test results that have been selected Copy copies the selected hearing test result to row 3 for modification Save saves the hearing test result entered in row 3 to the next empty row from row 4 onward Print Audiogram Report prints list of hearing test results for a firm Form Mode switches to audiogram form with the data entered in row 3 Search searches firm test subject occupation code classification code employee birth date or date of test Display Chart Both Ears displays audiogram chart for both ears in the same chart Display Chart L amp Ears
98. the Do WorkSafeBC Audiogram Session 1 you regularly wear ear Do you regularly wear ear protectors is Yes Type of ear protector wore regularly must be protectors field you will pou see the following error message if you don t enter a value in the Type of ear protector worn regularly field You can select one of the valid values from the Es dropdown list by clicking on the dropdown button on the right hand side and then select one of the di values in the dropdown list Bl n Nes jual Select from the dropdown list You will see the following error message if you enter an invalid value in the Do you regularly wear ear protectors field 64 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE You will see the following error message if you enter an invalid Microsoft Excel value in the Type of ear protector worn regularly field Entering Type of ear protector worn before test Field This field is related to the Hours In Noise Before Test field If the Hours In Noise Before Test field is blank then you will not be able to enter any value into the Type of ear protector worn before test field The of ear protector worn before test field will be blanked out if you neque try to enter a value If the Hours In Noise Before Test field is entered then the Type of ear _ E protecto
99. then For how many years have you smoke and How many cigarettes per day do you or did you smoke will be blanked out even if you selected a value How For how cigarettes per sad If you have selected Yes for one or both Do you smoke cigarettes now and Did you in the past fields and you have not selected a value for For how many years have you smoke You will see the following message box if you click the Save button to save the hearing test WorkSafeBC Audiogram Session 1 If Do you smoke cigarettes or Did you in the past is Yes For how many years have you smoked must be entered 114 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE If For how many years have you smoke is filled in and is not filled in You will see the following message box if you click the Save button to save the hearing test cigarettes per day do you or did you smoke saa past le make kes 1510 1 WorkSafeBC Audiogram Session 1 Do you smoke cigarettes or Did you in the past Is Yes How many cigarettes per day do you or did you smoke must be entered 115 of 115
100. ton to continue or the Print Audiogram Report Cancel button to cancel the printing Next you will be asked if you want to save the audiogram reports as webpage files Click the Yes button to save and or print the audiogram reports as webpage files Click the button to only print the audiogram reports as webpage files Click the Cancel button to cancel the printing The location of the audiogram report webpage file is specified in the Parameters tab WorkSafeBC Audiogram Webpage File Path c WorkSafeBC Audiogramwebpage Next you will be asked if you want to print audiogram reports for each firm number firm location and firm name with hearing tests saved in the Audiogram Data Entry tab WorkSafeBC Audiogram Session 1 Click the No button to indicate that we only want to print the audiogram report for the firm we have selected firm number 614069 location code 001 firm name Benny Construction Ltd At this point you can still click on the Cancel button to cancel the printing 87 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Next you will be asked to confirm the selected firm is the firm WorkSafeBC Audiogram Session 1 you want to print Print Audiogram Report for selected firm only Click the Yes button to continue the printing or click the Benny Construction Ltd 614069 001 button to skip printing the firm
101. tructions Once the hearing tests are moved back into the Audiogram Data Entry tab then you can make the necessary changes to the hearing tests See section Modify A Saved Hearing Test in Part 1 of the user manual for detail instructions After you have made all the corrections to the hearing tests you can generate a new audiogram data file containing the corrected hearing tests See section Generate Audiogram Data File in Part 1 of the user manual for detail instructions Finally you can send the generated audiogram data file to WorkSafeBC See section Send Audiogram Data File To WorkSafeBC in Part 1 of the user manual for detail instructions 79 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Resending Generated Hearing Tests Sometime it is necessary to resend some hearing tests without making any changes One such example is when you send in a group of SIN refusal hearing tests for construction firms and later received the SIN for one of the SIN refusal hearing tests In this situation you have to generate a new SIN refusal audiogram data file to exclude one of the hearing tests that now has a SIN New Code Audiogram Data Entry Audiogram Data Archive Long Term Archive Parameters Follow these steps to generate a new audiogram data file for hearing tests that have already been generated First you need to move the hearing tests from the Audio
102. ubject Letters of Insurance Employee 2 Number Firm Name Location First Name LastName Test Subject Occupation Age Surname No Birth Date 3 _ 614069 Constriction td nhn Doe Laborer 31 DOE 234567899 1978 0 A 5 1614069 Benny Construction Ltd 001 John Doe Laborer 31 DOE 123456782 1978 03 6 18 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Delete Selected Row s You can delete one or more Clear Row 3 Display Chart Both Ears hearing test result that has been saved in the Audiogram Data Entry tab You can also delete m Copy to Row 3 L templates that you have created f see section Create Template In Save Row 3 user manual for detail instructions Firm ibject Test on creating templates 2 Ll Firm _ Ame Middl Deleting Saved Hearing Tests rate Select the hearing test that you want to delete by highlighting the Firm Number cells of the target rows After you click the Delete button you will see the following message box to ask you to confirm deletion of the selected rows WorkSafeBC Audiogram Session 1 Click the OK button to confirm or the Cancel button to cancel the delete Delete the currently selected data entry row If you click the OK button you will see the following message box to confirm the selected WorkSa
103. w the 1st five characters of last name you sent is correct you should call WorkSafeBC to correct the 1st five characters of last name in the WorkSafeBC record If your record of the last name is incorrect you should correct the last name for this worker in the Test Subjects tab of the audiogram program But you don t need to send in the corrected test again INVALID TECH S I N Invalid Contractor Number or Technician SIN 5 BIRTH SURNAME CLASS SUB OCCUPATION MEDICAL TEST TEST TEST FORM COMMENTS DATE CODE CHANGE TYPE CATG 5 I NUMBEF 886 041952 31004 9313908 N B 062009 259005 INVALID TECH S I N The contractor number or technician SIN is you sent is not found in WorkSafeBC record In this example the contractor number should be 255 instead of 25 We will correct the contractor number in the hearing test for this type of error if we know what the correct contractor number should be and you don t have to resend the corrected hearing test again INVALID CLS SUB INDY Invalid Classification for the Firm and Location OPSCAN BATCH E OD 7 DE RM LOC 828138 001 m ri 455 508 OCCUPATION MEDICAL TEST TEST TEST TECHNICIAN FORM COMMENTS CODE CHANGE TYPE CATG DATE S I NUMBEP 721027 8781121 N B Ew 072009 255 001 INVALID CLS SUB INDY The classification code is not valid for the firm number and firm location In this example the classification code 721027 has
104. wing message box if you click the Save button to save the hearing test The message will indicate which fields should be filled in WorkSafeBC Audiogram Session 1 WorkSafeBC Audiogram Session 1 head injury location Exposure to a loud blast WorkSafeBC Audiogram Session 1 111 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE WorkSafeBC Audiogram Session 1 in the past location Do you now have trouble Ringing in your ears 1 Entering Medical History Gen Info 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 jor 1 lor 112 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE 113 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE The following fields are related to each other If Yes is selected for both or either Do you smoke cigarettes now or Did you in the past then For how many years have you smoke and How many cigarettes per day do you or did you smoke must be filled in If No is selected for both Do you smoke cigarettes now and Did you in the past
105. x of in the Firm Number field and a T in the This Record Has Been Generated field in column CC WorkSafeBC Audiogram Session 1 E Delete Selected Row s Clear Row 3 Copy to Row 3 Save Row 3 Firm Number Firm Name ear Snr canadian Forest Prod Ltd LIBE LM M 14 of 115 WORK BC Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Modifying a Saved Hearing Test All the hearing test results are saved in the Audiogram Data Entry tab from row 4 onward These rows are protected from being changed directly You will see the following message box if you attempt to change the data in any cells from row 4 onward Microsoft Office Excel The cell or chart that you are trying to change is protected and therefore read only AN To modify a protected cell or chart first remove protection using the Unprotect Sheet command Review tab Changes group You may be prompted for a password Since you can only change data in row 3 of the Audiogram Data Entry tab the procedure is to copy the hearing test that you want to change to row 3 Make your changes in row 3 and then save the hearing test result again Clear Row 3 Display Chart Both Ears Copy to Row 3 Display Chart L amp R Ears Save Row 3 earch Generate Firm Firm Test Subject Test Subject Test Subject 2 Number Firm Name Location First Name Middle Name
106. you will have a different printer setup Where C21 iR6020 ISD Development Services 10 2 112 249 Comment RC21 iR6020 ISD Development Services Print to file Click the OK button to print the audiogram 10 2 112 249 report or click the Cancel button to abort the icum vu printing all Number of copies Page s From B B Print what Selection Entire workbook Active sheet s C Ignore print areas Collate Cancel WorkSafeBC Audiogram Session 1 You will see the following message to confirm the audiogram reports have been processed Jj 2 of 2 Audiogram Reports printed Summary A list of all hearing tests in the Audiogram Data Entry tab for a firm number firm location and firm name can be printed out in the audiogram report You can choose to print the report for only tests from one firm number firm location and firm name or to print separate audiogram reports for all the hearing tests in the Audiogram Data Entry tab Tip Because hearing tests for each firm number firm location and firm name combination are printed in separate audiogram reports If you need to print the hearing tests for a firm number and firm location into two separate audiogram reports then setup a second entry in the Firms tab for the same firm number and firm location but with a different name Save all the hearing tests that you want to be included in a separate audiogram report under the seco
107. ystem Folder wv Microsoft Office Outlook System Folder Click on the sign beside the C drive to expand the sub folders Here is a screen shot of my C drive ES 2 Vocis Your drive name will not be WCB but you should Eat Favorites I Help see the C for your C drive J y Search Folders 17 _ f Agaress 3 Desktop Find the WorkSafeBC Audiogram folder under S Folders your C drive and click on the sign to expand the 3 sub folders C My Documents My C ter lt gt WCB C You may only see the output sub folder because the ED WorkSafeBC Audiogram other folders are only created when you used the archive and backup functions in the audiogram program WorkSafeBC Audiogram Click on the output folder C3 archive Audiogram Reports _ backup You should be able to find the file you have just ee generated on the right hand side panel o output 26 of 115 WORK Electronic Audiogram Program User Manual Part 2 of 3 WORKING TO MRKE R DIFFERENCE Size Date Modified 55 Audiogram form 1 2009 09 14 13 04 37 dat 1KB TextDocument 2009 09 14 1 04 PM Remember the location of this file you will upload it to WorkSafeBC Summary All hearing tests in the Audiogram Data Entry tab that have not been generated before will be extracted into one or two audiogram data files File generation separat

Electronic Audiogram Program User Manual Part 2

Contents

Download Pdf Manuals

Related Search

Related Contents