ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Calculating quantities of cleaned, indexed PCR to pool
AG notes: Changed calculations to follow formula below
2
Automatically add in 113 bp in calculation.
3
Please follow the instructions below. Only cells highlighted in blue need to be modified.
4
5
1. Modify the following values as needed:
6
7
Final volume desired
200uL
8
9
Desired concentration of pool
40nM
10
11
Number of samples
73
12
13
Length of indexing adapter
113base pairs
Cells are protected
14
15
2. Input the concentration of the library preparation (in ng/uL) in column B.
16
17
3. Input the average size of the library preparation in base pairs in Column C (do not include length of index adapters)
18
19
4. Hit the tab key 1 time and the following will be displayed automatically:
20
Calculated molecular weight of the library based on average fragment size.
21
nM conversion of library concentration.
22
Amount of samples that must be added to pool.
23
Total expected volume from pooled samples.
24
Volume of water that must be added to pooled samples to reach the desired final volume.
25
26
5. Pay attention to the cells highlighted in green- they provide the quantities of samples and water you need to reach your desired volume
27
28
Total Sample Volume:Please make sure you enter all values correctly
29
30
Add water volume:
31
32
33
SampleLibrary concentration (ng/uL)Average Base Pair LengthMW calculationLibrary Concentration (nM)Amount of sample to add to pool
34
Example24222786337.1815.277.180.9995944486
35
1342227863310.7710.1810.770.9995944486
36
2342227863310.7710.1810.770.9995944486
37
350422278633179.450.61179.520.9995944486
38
42042227863371.781.5371.810.9995944486
39
5342227863310.7710.1810.77
40
64222786330.00#DIV/0!
41
74222786330.00#DIV/0!
42
84222786330#DIV/0!
43
94222786330#DIV/0!
44
104222786330#DIV/0!
45
114222786330#DIV/0!
46
124222786330#DIV/0!
47
134222786330#DIV/0!
48
144222786330#DIV/0!
49
154222786330#DIV/0!
50
164222786330#DIV/0!
51
174222786330#DIV/0!
52
184222786330#DIV/0!
53
194222786330#DIV/0!
54
204222786330#DIV/0!
55
214222786330#DIV/0!
56
224222786330#DIV/0!
57
234222786330#DIV/0!
58
244222786330#DIV/0!
59
254222786330#DIV/0!
60
264222786330#DIV/0!
61
274222786330#DIV/0!
62
284222786330#DIV/0!
63
294222786330#DIV/0!
64
304222786330#DIV/0!
65
314222786330#DIV/0!
66
324222786330#DIV/0!
67
334222786330#DIV/0!
68
344222786330#DIV/0!
69
354222786330#DIV/0!
70
364222786330#DIV/0!
71
374222786330#DIV/0!
72
384222786330#DIV/0!
73
394222786330#DIV/0!
74
401130#DIV/0!
75
411130#DIV/0!
76
421130#DIV/0!
77
431130#DIV/0!
78
441130#DIV/0!
79
451130#DIV/0!
80
461130#DIV/0!
81
471130#DIV/0!
82
481130#DIV/0!
83
491130#DIV/0!
84
501130#DIV/0!
85
511130#DIV/0!
86
521130#DIV/0!
87
531130#DIV/0!
88
541130#DIV/0!
89
551130#DIV/0!
90
561130#DIV/0!
91
571130#DIV/0!
92
581130#DIV/0!
93
591130#DIV/0!
94
601130#DIV/0!
95
96
97
98
99
100