Home | Search | Help | Advertising | Contact Us | Bookmark and Share

 

NukeWorker.com, Nuclear Jobs & Nuclear Resumes
Radiation Safety Program Access Database??? What's out there?
WM2015 CONFERENCE MARCH 15 - 19, 2015 PHOENIX CONVENTION CENTER
Radiation Safety Program Access Database??? What's out there?

NukeWorker.com, Nuclear Jobs & Nuclear Resumes
 
Messages:
Welcome, Guest. Please Login or Register.
Forgot your password?


Related:

  Nuclear Jobs
  Nuclear News

  OSHA HAZWOPER
  Outage Schedules
  Gold Members
  Donate
  Nuke Shop
  Advertise
 


People online
68 Guests, 0 Users
View members:
View All Members
View By Letter
Search for User
View Top Posters


NukeWorker Forum
Oct 23, 2014, 10:46 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
 
   Home   Help Calendar Login Register  
Pages: [1]   Go Down
  Send this topic  |  Print  
Author Topic: Radiation Safety Program Access Database??? What's out there?  (Read 2308 times)
0 Members and 1 Guest are viewing this topic.
tritenick
Very Lite User
*

Karma: 7
Offline Offline

Gender: Female
Posts: 5



View Profile
« on: May 08, 2012, 09:58 »

Any HP's or RSO's using a Microsoft Access Database for tracking their radiation safety program? I'm curious what are people using....excel???  Anyone have Neveda Technicals RS-Solutions database?  Any comments?  Any other databases out there or has anyone created their own?  I would love to hear how others are tracking all the info.
Logged

"What you do speaks so loudly that I can not hear what you say" -R.W. Emerson
Rennhack
Forum Administrator
*

Karma: 4402
Offline Offline

Gender: Male
Posts: 7509



View Profile WWW
« Reply #1 on: May 08, 2012, 01:07 »

I once used excel to track the dose of the workers on a very small project.  No problem, I thought.  There are only a dozen of us. -- People leave and get replaced, that dozen turned into 50 dose records.  Tracking dosimeter exposure, bio assays, inhalation dose.... it tends to grow quickly.

I'm very guilty of using excel for things a database should be used for (I love me some vlookups).  I would highly suggest NOT using excel if you have more than a dozen folks, it can really get out of hand quickly. -- But it can be done.

I don't have any experience with the other systems.  I can tell you that for a small population, excel will work. I wouldn't recommend it, but I would do it again the exact same way.
Logged

RDTroja
Site Heretic
Gold Member
*

Karma: 4467
Offline Offline

Gender: Male
Posts: 3446


I knew I got into IT for a reason!


View Profile
« Reply #2 on: May 08, 2012, 01:32 »

I work in Access and have written several programs currently in use at three sites. While I have not written one for controlling access to the RCA (i.e. login/logout/turnstile control) I have written a front end to mine data from two different access control programs and generate reports. In addition I have an air sample program (and another near completion) an instrument issue program started, a job Observation database, instructor qualification tracking program, and a trainee feedback program for use at the end of a training session. I also wrote a utility that can graph the results over time from a remote dosimeter or group of dosimeters using the remote teledosimetry system.

The one that seems closest to what you are asking about gathers data from the Oracle back end of the access control program at St. Lucie and automatically creates and distributes (by email) dose reports every night after midnight for the day before. There is one version for outage dose that uses several spreadsheets to estimate daily dose by RWP and Task and then compares the estimates to the actual dose received and makes reports and a couple of graphs broken down by departments or projects. The other version is used for non-outage dose and uses estimates by workgroup (and RWP) but the estimates are not as detailed and there are fewer reports. Actually, both 'versions' are in the same database, but they are separated into outage/non-outage functions. It also generates transaction reports (who went into the RCA when , on which RWP and how much dose) and RWP lists that show description, status and workgroup.

Almost everything I write is custom developed for each application. If you have a need, I would be happy to talk about it. If you are developing something and need assistance I may be able to help there or steer you to an excellent website where there are a lot of developers willing to help with questions I might not be able to answer.

Oh, yeah, almost forgot. I agree with Mike. You could do something in Excel, but I strongly recommend against it.
« Last Edit: May 08, 2012, 01:33 by RDTroja » Logged

"I won't eat anything that has intelligent life, but I'd gladly eat a network executive or a politician."

                                  -Marty Feldman

"Politics is supposed to be the second-oldest profession. I have come to understand that it bears a very close resemblance to the first."
                                  -Ronald Reagan

I have never made but one prayer to God, a very short one: 'O Lord, make my enemies ridiculous.' And God granted it.

                                  - Voltaire
RDTroja
Site Heretic
Gold Member
*

Karma: 4467
Offline Offline

Gender: Male
Posts: 3446


I knew I got into IT for a reason!


View Profile
« Reply #3 on: May 09, 2012, 09:43 »

Check your PMs.

(Um... that would be Personal Messages, not PMS)
« Last Edit: May 09, 2012, 09:45 by RDTroja » Logged

"I won't eat anything that has intelligent life, but I'd gladly eat a network executive or a politician."

                                  -Marty Feldman

"Politics is supposed to be the second-oldest profession. I have come to understand that it bears a very close resemblance to the first."
                                  -Ronald Reagan

I have never made but one prayer to God, a very short one: 'O Lord, make my enemies ridiculous.' And God granted it.

                                  - Voltaire
Pages: [1]   Go Up
  Send this topic  |  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!
Page created in 0.206 seconds with 23 queries.
RSS for Messages RSS for Pictures RSS for Pictures