Q1: How are employees pulled into the CNSC report?
Answer: The CNSC report is always ran from the start of the year and up to the end of the month selected. Employees are pulled into this report if they have any time cards in this period, or if they have any personal readings that can be used to generate an expsoure value.
Q2: Why do the calculated monthly exposures not include a reading that was just entered?
Answer: This could be happening for a number of reasons, the most likely reason is because this person already has a value calculated and posted for this month. The solution would be to go to the monthly calculations page, find the records for that individual and unpost their result (note, this unposting will have to be done for all of the months that your new personal reading covers). Once all of the monthly results are unposted, you can calculate the monthly exposures for all of the months again. The unposted results will now be overwritten with the new data. These results will be postable so long as the all of the data (area time cards, area readings, personal readings) used to make this result were posted.
Another reason your new record may not be showing up is because you are entering the result in the wrong column. For personal readings, it is the 'Reading2' or second reading column that gets used in the calculations. Depending on the method selected while viewing readings, this column may be called different names but it will always be the column to the right of the first reading column.
The date values can also cause this behavior. The dates used by the calculation are the actual date type column. The 'Type', 'Time frame', and 'Year' columns are not used in calculations. Note also that the span of days that a record is spread over is the span from the first date column to the second date column. If a mistake is made during entry and the date range spans a large number of years, the value will be divided by the days it spans making it very small for each day. The result will be an employee showing up in reports for a long period of time with what might appear to be zero readings (due to rounding).
The final reason why your personal reading is not included in the calculated exposures would be because it is not set up with a dose component which is used for calculating exposures. If this is the case, and you would like this entry method to be used in calculating exposures you will need to contact E.I.C. to get your version of WebRad upgraded.
Q3: Why am I getting a 'constraint' error when trying to delete a location I just created?
Answer: When a new location is created there is an option to assign contaminants to that location. If contaminants are selected, then the location will be created in one table and the contaminant link information will be created in another table. If a location was improperly added and you would like to remove it you will have to remove all data associated with that location. In this case you will have to go to the contaminant location page and remove all associations to that location before it can be removed.
Q4: How do you sort data that has been exported to Excel®?
Answer: Often, data exported from WebRad into an Excel® format contains hidden gridline separators, merged cells, and minimally sized cells. Data is sorted different ways depending of the version of Excel®.
Excel® 2003: First get the spreadsheet into a useable form. On the 'Tools menu', click 'Options'. On the 'View' tab, under 'Window options', select the Gridlines check box to show the gridlines. Next, make sure that the 'formatting' toolbar is displayed (this is the tool bar that allows you to merge the cells, change the position/font of the text, etc.). If the toolbar is not displayed, go to 'View' select the 'Toolbars' item and click on the 'Formatting' item so that it displays a check box next to it. Next, select all of the cells in the spreadsheet. This can be done by clicking on the left most, top most cell in the header of the sheet, or by clicking anywhere in the sheet and pressing the keyboard combination 'ctrl+a'. With all of the data selected, unmerge all of the cells by clicking on the 'Unmerge' button in the 'Formatting' toolbar. Next, resize all of the cells. Select all of the cells in the spreadsheet and move the mouse to the divider between the first and second row in the row header. Once it shows two arrows, adjust the height to a desirable size. When you release the mouse click, all of the rows will size to this value.
To sort the data, first select all of the data in the table. Columns that are left out of the selection will not be sorted and cause data to become invalid for a specified row. With the data selected, go to the 'Data' menu and select on the 'Sort...' item. A separate window will appear with options to sort. From here, you can select the first column you want to sort by, and set how you would like to sort the data. By default, you can sort by 3 layers.
Excel® 2007-2010: The first step to get back to a workable spreadsheet is to show the grid lines. First select all of the cells in the spreadsheet. This can be done by clicking on the left most, top most cell in the header of the sheet, or by clicking anywhere in the sheet and pressing the keyboard combination 'ctrl+a'. Once all of the cells are selected, go to the ribbon, select the 'view' tab, and in the 'show' section check the box next to 'Show Gridlines'. Next, unmerge all of the cells. To do this, select all of the cells. On the ribbon make sure the 'Home' tab is selected, and under the section on 'alignment', select the drop down labelled 'Merge & Center' and in the list of option select 'Unmerge Cells'. Next we need to resize all of the cells on the spreadsheet to a standard value. Select all of the cells in the spreadsheet and move the mouse to the divider between the first and second row in the row header. Once it shows two arrows, adjust the height to a desirable size. When you release the mouse click, all of the rows will size to this value. Do the same for the column headings by selecting the divider between column A and B. Now the data is in a viewable state and ready to be sorted
To sort the data, begin by selecting all of the data in the table that you wish to sort. Columns that are left out of the selection will not be sorted and cause data to become invalid for a specified row. With the data selected, right click on the mouse to bring up a list of selections. Under the 'Sort' item, select the 'Custom Sort...' option. A separte window will appear. The window defaults with one item to sort on. For this item, select the column name you wish to apply the sort logic to. Then select what aspect of the cell you want to sort based on using the 'sort on' drop down list. Finally, select the 'order' drop down list to specify how you would like to sort this data. If more levels of sorting are required, they may be added with the 'Add Level' button.
Q5: Why do I get an "MCL$ is not a valid name" error uploading my PAD import file?
Answer: This happens because the name of the sheet inside the Excel® file must be named "MCL". Rename the sheet by right clicking on the name tag and type in "MCL" then try the import again.
Q6: How do I go about changing a personal reading after it has been posted and stored exposures have been generated based on it?
Answer: Posting is required to make Personal Reading values static in the database so that they can not be edited from other areas. Sometimes a posted Personal Reading will require modification. To modify a posted personal reading, first go to the "Post Personal Readings" page. Enter a date range that the reading falls under. Select the Personal Method corresponding to the reading you wish to unpost. Look through the gridview to find the personal reading you are updating and uncheck the "Post/Unpost" check box. Then hit "Confirm Post/Unpost Selects". Take note of the records 'Created' date, as you will need it in the next step. Now the record is unposted and you may modify its value by going to the Personal Readings Entry page and searching for the record in the grid view. The personal readings grid view is filtered by Created date, hence why it was important to remember it from the posting page. Find the record once more and edit its value. Once the record is changed it must be posted again. Go back to the posting page, find it once more, and set its status back to posted. It is likely that the reading was used to calculate stored monthly exposures. If the reading2 value (the value used to calculate exposures based off of) was modified in the last step, you will need to find and unpost all of the stored exposures that were created based on this personal reading. Determine the individual that the reading belongs to and go to the "Post Monthly Personal Exposures" page. Filter the page for the employee of the modified reading and unpost all of the stored exposures for that employee that would fall in the range of the personal reading. I.e. if the personal reading was from Jan 30 2010 to March 1 2010, you would need to unpost Jan, Feb, and Mar stored exposures for 2010 for the individual. Once the stored exposures are unposted, run the "Calculate Monthly Personal Exposures" page for the months that were unposted. The new results should show up and if everything was done in the right order, they should be allowed to be posted. Go back to the "Post Monthly Personal Exposures" page and post the months effected.
Q7: How do I go about changing a protection factor without modifying historic doses?
Answer: WebRad was designed so that factors for protection equipment can be user modified over time. If the protection factor for a contaminant requires a new value, you can change this from the "protection factors" page. First select the protection equipment you wish to modify from the drop down list. This will update the gridview with the individual protection factors that are already assigned for each contaminant. Protection factors are the decimal value that is multiplied against the unprotected dose to generate a protected value. So if your equipment provides 90% protection from a given contaminant, you would use a protection factor of 0.10. Sometimes a protection factor will already exists for a given contaminant and you will want to use a new value going forward. To do this, you simply edit the old factor and change it's "End Date" to the last day you wish to use that factor. We are not deleting the old factor, just changing the date range it spans. This way, historic doses will still use the old factor. Next, create a new factor for the same contaminant and enter the new decimal value you wish to use. Change the "Start Date" of this new factor so it takes effect the day after the old one ends(WebRad will throw an error if you have factors with date ranges that overlap). Leave the "End Date" at its default value of Dec 31 9999. This will allow WebRad to make use of this factor for all future records until a new factor is needed.