Jason,
Your feedback (shared information) seems to be a great solution in terms of an alert/notification feature that will allow for the tabulation of upcoming registration expiry and time required to complete (submit) the necessary documentation; thereby, staying ahead of the various registration expirations.
Your willingness to share is invaluable!! I will let you know the results of the shared effort once implemented.
Thank you very much.
Whitney,
I will reach out Kayla Sanders and Eric Pickrell to share the information provided by Jason Ford.
Julie,
Refer to Jason's response.
------------------------------
[Willis] [Edwards] [RAC (US)]
[Senior Regulatory Affairs Specialist]
[Misonix]
[Farmingdale] [NY]
[USA][Farmingdale]
------------------------------
Original Message:
Sent: 09-Nov-2018 11:11
From: Jason Ford
Subject: Registration Monitoring Spreadsheet (System)
Hi Willis,
We have been very successful using conditional formatting within the expiration date column. Once you have your expiration date column set, you can apply conditional formatting with the rule, "Format only cells that contain""cell value" "less than" X. Depending on how your date format is, you can set this value to equal 6 months or 8 months or any amount of months prior to the expiration date, and that will cause the cell to become highlighted when that condition is met.
With this system, as we see cells become highlighted, we add them to the planning que to renew that registration.
Hope this helps!
Jason
------------------------------
Jason Ford
QARA Engineer
Kennewick WA
United States
Original Message:
Sent: 08-Nov-2018 15:34
From: Willis Edwards, RAC (US)
Subject: Registration Monitoring Spreadsheet (System)
Hello fellow RAPS members,
I need your help/input/feedback!! Specifically, I've been tasked with updating our medical device registration spreadsheet by including a feature (column) that will give an alert/notification as to upcoming registration deadlines (i.e. China; registration expires in 6 months). However, I am seeking ideas as to adding a column that will account for (include) the time required for completing the registration documents (as determined internally) in combination with the upcoming registration expiry. For example, if China requires submission of registration documentation 6 months prior to expiry and we have determined it will take 3 months to complete registration documentation, then a feature/column on the registration spreadsheet should provide an alert feature 9 months prior to China registration expiry.
Does anyone have a template they would be willing to share that would easily incorporate the above mentioned?
Thank you in advance for the feedback provided.
Willis Edwards, RAC (US)
------------------------------
[Willis] [Edwards] [RAC (US)]
[Senior Regulatory Affairs Specialist]
[Misonix]
[Farmingdale] [NY]
[USA][Farmingdale]
------------------------------