Special Procedure 13
 
Instructions for using the Waste Disposition and Decay Excel Sheet (Top)
 
EHS has developed an Excel spreadsheet designed to be used to calculate the activity in waste and the amount of decay for a waste pick up.  The spreadsheet is not intended to replace the current paper inventory sheets, but it can provide the values needed by performing the calculations.  The spreadsheet includes multiple worksheets, each for a different isotope.  If the isotopes in use are not conveniently placed, click on the tab at the bottom of the ones you need and drag them to the front.  Below are instructions that explain how to use this spreadsheet to save time in inventory record keeping tasks.  Click here for the Waste Decay Calculator Excel spreadsheet.
 
Three examples of using the spreadsheet are included in this procedure.  The examples show:
  • a new stock vial and an associated waste pick up,
  • the same stock vial with a partial waste pick up, and
  • the final waste from that stock being removed from the lab.
The last page contains the completed inventory sheet for the stock used in the examples.  Reviewing the example inventory sheet along with each spreadsheet example may be useful for clarification on where to find the values you will need to enter into the Excel sheet.  In this example inventory sheet, the usual waste disposition values are noted at the top of the column and variances from the usual values are entered separately.  This method of recording waste disposition is commonly used to save writing.
 
Fields that require input are colored yellow in the Excel sheet.  These are listed and described in Table 1.
 
Table 1:  Fields for Data Entry
Cell
Field Name
Description
B2
Orig. Activity
Enter the activity in mCi to be decayed.  This would be the original activity received for the first decay calculation or the most current inventory balance if waste has already been removed for this stock.
B3
Orig. Date
Enter the date associated with the Orig. Activity.  This would be the receipt date for the first decay calculation or the date the activity had been decayed to, i.e. date of last waste pick up
B4
Orig. Volume
Enter the volume in ml that is associated with that stock.  This would be the original volume received if no waste pick ups have occurred or the volume that remained in the lab after waste was removed.
B5
Pick up date
Enter the date of the scheduled waste pick up or end of month for monthly decay
B9 - B22
Dispensed
Enter the volume of stock material that has been dispensed in ml.  If the percentages of waste disposition are the same for multiple dispensations, the sum of the ml can be entered on one line.  If the waste disposition is different, the dispensed volumes need to be entered separately.
D9 – D22
% dry
Enter the % of stock material that was disposed in the dry waste container
E9 - E22
% liquid
Enter the % of stock material that was disposed in the liquid waste container
F9 – F22
% vials
Enter the % of stock material that was disposed in the LSC vials
G9 - G22
% other
Enter the % of stock material that was disposed as the other types of waste, such as carcasses.
B23
Vial to waste
Enter the number of m1 of stock material that was disposed of directly to waste.  Normally, this would be putting 100% of what’s left in the vial either dispensed and added to the liquid waste or putting the whole vial into the dry waste.
D23
% dry
Enter 100 % if the stock was disposed to dry waste
E23
% liquid
Enter 100 % if the stock was disposed to liquid waste
 
Fields that provide the results you need are colored blue in the sheet.  The green fields are intermediate fields used in the calculations.  The result fields are as listed in Table 2.
Table 2:  Result Fields:
Cell
Field Name
Description
G1
Volume Left in Stock
Indicates the volume of stock material in m1 that remains in the stock vial.
G2
Volume Left in Lab
Indicates the volume of stock material in m1 that remains in the lab.  This value would also be the m1 to use for the calculation performed after the first waste pickup.
D6
Dry mCi
Indicates the activity in mCi from this stock that is in the dry waste.
E6
Liquid mCi
Indicates the activity in mCi from this stock that is in the liquid waste.
F6
Vials mCi
Indicates the activity in mCi from this stock that is in the LSC vial waste.
G6
Other mCi
Indicates the activity in mCi from this stock that is in other types of waste, such as carcasses.
H6
Decay mCi
Indicates the activity in mCi from this stock that has decayed.
I6
Balance mCi
Indicates the activity in mCi from this stock remains in the lab.
  
Example 1:  1.214 mCi P-32 stock vial and associated waste pick up
 
A
B
C
D
E
F
G
H
I
J
K
1
Halflife:
14.29
days
 Volume Left in Stock:
90
ml
 
 
P-32
2
Orig. Activity:
1.214
mCi
 Volume Left in Lab:
90
ml
 
 
 
3
Orig. Date:
01/08/2004
 
 
 
 
 
 
 
 
 
4
Orig. Volume:
100
ml
Dry
Liquid
Vials
Other
Decay
Balance
 
 
5
Pick up date:
01/13/2004
 
mCi
mCi
mCi
mCi
mCi
mCi
 
 
6
 
 
 
0.057
0.038
0.000
0.000
0.261
0.857
 
 
7
 
 
 
 
 
 
 
 
 
 
 
8
 
 
 
% dry
% liquid
% vials
% other
 
ml dry
ml
 liquid
ml
vials
ml
 other
9
Dispensed
10
ml
60%
40%
 
 
6
4
0
0
10
Dispensed
 
ml
 
 
 
 
0
0
0
0
11
Dispensed
 
ml
 
 
 
 
0
0
0
0
12
Dispensed
 
ml
 
 
 
 
0
0
0
0
13
Dispensed
 
ml
 
 
 
 
0
0
0
0
14
Dispensed
 
ml
 
 
 
 
0
0
0
0
15
Dispensed
 
ml
 
 
 
 
0
0
0
0
16
Dispensed
 
ml
 
 
 
 
0
0
0
0
17
Dispensed
 
ml
 
 
 
 
0
0
0
0
18
Dispensed
 
ml
 
 
 
 
0
0
0
0
19
Dispensed
 
ml
 
 
 
 
0
0
0
0
20
Dispensed
 
ml
 
 
 
 
0
0
0
0
21
Dispensed
 
ml
 
 
 
 
0
0
0
0
22
Dispensed
 
ml
 
 
 
 
0
0
0
0
23
Vial to waste
 
ml
 
 
 
 
0
0
0
0
24
 
10
 
 
 
 
 
6
4
0
0
Note that –
  • Orig. Activity, Orig. Date and Orig. Volume are found in the header of the inventory sheet example.  Orig. Date is the Date Received.
  • Pickup date is that of the scheduled waste pick up.
  • Lines 9-22 provide fields to enter dispensed volumes.  On line 9, the dispensed volume from the 1/10 experiment on the inventory sheet.
  • Round off error will occur, such that the sum of the waste removed, decay and new balance may not exactly equal the original activity.  This may be ignored as insignificant.
Example 2 (below) shows a partial waste pick up for the same stock shown in Example 1.  In this case, dry waste was removed, but the liquid waste was not.
 
Example 2:  Calculation for a Partial Waste Pick Up
 
A
B
C
D
E
F
G
H
I
J
K
1
Halflife:
14.29
days
 Volume Left in Stock:
70
ml
 
 
P-32
2
Orig. Activity:
0.857
mCi
 Volume Left in Lab:
78
ml
 
 
 
3
Orig. Date:
01/13/2004
 
 
 
 
 
 
 
 
 
4
Orig. Volume:
90
ml
Dry
Liquid
Vials
Other
Decay
Balance
 
 
5
Pick up date:
02/03/2004
 
mCi
mCi
mCi
mCi
mCi
mCi
 
 
6
 
 
 
0.041
0.000
0.000
0.000
0.547
0.268
 
 
7
 
 
 
 
 
 
 
 
 
 
 
8
 
 
 
% dry
% liquid
% vials
% other
ml
dry
ml
liquid
ml
vials
ml
other
9
Dispensed
10
ml
60%
 
 
 
6
0
0
0
10
Dispensed
10
ml
60%
 
 
 
6
0
0
0
11
Dispensed
 
ml
 
 
 
 
0
0
0
0
12
Dispensed
 
ml
 
 
 
 
0
0
0
0
13
Dispensed
 
ml
 
 
 
 
0
0
0
0
14
Dispensed
 
ml
 
 
 
 
0
0
0
0
15
Dispensed
 
ml
 
 
 
 
0
0
0
0
16
Dispensed
 
ml
 
 
 
 
0
0
0
0
17
Dispensed
 
ml
 
 
 
 
0
0
0
0
18
Dispensed
 
ml
 
 
 
 
0
0
0
0
19
Dispensed
 
ml
 
 
 
 
0
0
0
0
20
Dispensed
 
ml
 
 
 
 
0
0
0
0
21
Dispensed
 
ml
 
 
 
 
0
0
0
0
22
Dispensed
 
ml
 
 
 
 
0
0
0
0
23
Vial to waste
 
ml
 
 
 
 
0
0
0
0
24
 
20
 
 
 
 
 
12
0
0
0
Note that –
  • The Orig. Activity is now the Balance result from Example 1;
  • The Orig. Date is now the date that waste was picked up in Example 1;
  • The Orig. Volume is now the Volume Left in Lab in Example 1;
  • The Pickup date is that of the scheduled waste pick up.;
  • Lines 9 and 10 shows the dispensed volumes from the experiments on 1/15 and 1/18 on the inventory sheet and the 60% dry waste disposition; and
  • The liquid waste disposition is left blank.
Tip:  Record the volume left in lab on the inventory sheet for the next waste pick up.
 
Example 3 shows the final waste pick up of the material from that stock vial.
 
Example 3:  Final Disposal and Decay
 
A
B
C
D
E
F
G
H
I
J
K
1
Halflife:
14.29
days
 Volume Left in Stock:
-12
ml
 
 
P-32
2
Orig. Activity:
0.268
mCi
 Volume Left in Lab:
0
ml
 
 
 
3
Orig. Date:
02/03/2004
 
 
 
 
 
 
 
 
 
4
Orig. Volume:
78
ml
Dry
Liquid
Vials
Other
Decay
Balance
 
 
5
Pick up date:
02/24/2004
 
mCi
mCi
mCi
mCi
mCi
mCi
 
 
6
 
 
 
0.074
0.022
0.000
0.000
0.171
0.000
 
 
7
 
 
 
 
 
 
 
 
 
 
 
8
 
 
 
% dry
% liquid
% vials
% other
ml
dry
ml
liquid
ml
vials
ml
other
9
Dispensed
10
ml
 
40%
 
 
0
4
0
0
10
Dispensed
10
ml
 
40%
 
 
0
4
0
0
11
Dispensed
 25
ml
 60%
40%
 
 
15
10
0
0
12
Dispensed
 
ml
 
 
 
 
0
0
0
0
13
Dispensed
 
ml
 
 
 
 
0
0
0
0
14
Dispensed
 
ml
 
 
 
 
0
0
0
0
15
Dispensed
 
ml
 
 
 
 
0
0
0
0
16
Dispensed
 
ml
 
 
 
 
0
0
0
0
17
Dispensed
 
ml
 
 
 
 
0
0
0
0
18
Dispensed
 
ml
 
 
 
 
0
0
0
0
19
Dispensed
 
ml
 
 
 
 
0
0
0
0
20
Dispensed
 
ml
 
 
 
 
0
0
0
0
21
Dispensed
 
ml
 
 
 
 
0
0
0
0
22
Dispensed
 
ml
 
 
 
 
0
0
0
0
23
Vial to waste
 45
ml
  100%
 
 
 
45
0
0
0
24
 
90
 
 
 
 
 
60
18
0
0
Note that –
  • The Orig. Activity is now the Balance result from Example 2;
  • The Orig. Date is now the Pickup Date from Example 2;
  • The Orig. Volume is still the Volume Left in Lab in Example 2;
  • The Pickup date is the date of the waste pick up;
  • The Vial to waste field indicates the remaining volume in the stock when it was placed into dry waste;
  • The Volume Left in Lab goes to 0; and
  • The Volume Left in Stock is negative due to the 12ml of stock material removed in the partial waste pick up
Vial ID:          0000539                        Receipt Activity:                   1.214 mCi / 100.0 ml                           Vendor:                PerkinElmer                      Permit Holder:              ALEXANDER, MARTIN
 
Isotope:        P-32                              Reference Activity:              1.000 mCi  on  01/12/2004                 P.O. #:                   XXXXX0                      Wipe Test - package:  < 100 dpm
 
Compound:  (alpha-P32) dCTP                                                                                                                 Date Received:    01/12/2004                      Wipe Test - vial:          < 100 dpm
 
 
1.
 
2.
 
3.
 
4.  Original Stock
 
5.  Diluted Stock
40%
60%
6. Disposition
 
7.
 
Initials
 
Transaction
 
Date
 
Removed
 
Balance
 
Removed
 
Balance
 
Dry Waste
 
Bulk Liquid
 
Vials
 
Carcass
 
Decay
 
Other
Inventory Balance
lh
Receipt
01/08/2004
 
100
 
 
 
 
 
 
 
 
1.214
lh
exp
1/10/04
10
90
 
 
 
 
 
 
 
 
 
lh
waste
1/13/04
 
 
(90
ml
left in lab)
 
0.057
0.038
 
 
0.261
 
0.857
lh
exp
1/15/04
10
80
 
 
 
 
 
 
 
 
 
lh
exp
1/18/04
10
70
 
 
 
 
 
 
 
 
 
lh
dry waste
2/03/04
 
 
(78 
ml
left in lab)
 
0.041
 
 
 
0.547
 
0.268
lh
exp
2/10/04
25
45
 
 
 
 
 
 
 
 
 
lh
vial to waste
2/13/04
45
0
 
 
100%
 
 
 
 
 
 
lh
waste
2/24/04
 
 
 
 
0.074
0.022
 
 
0.171
 
0.000