StartingLibraryMultivalencyPredictor.xlsx

	A	B	C	D	E	F	G
1	Inputs in yellow:	Desired outputs in green:
2
3	num random bases (N)
4	25
5
6	EdU probability per random base as % A in random library template
7	15%
8
9	Library size in moles
10	0
11
12	Library size (molecules)
13	24000000000000			asdf
14
15
16	num EdUs in random region (M)	fraction (f) of library with M EdU's (as %)*	# of possible sequences	# of molecules in library	coverage of sequence space (%)	# unique sequences	combin
17	0	1.71978%	847288609443	412747436453	48.71%	412747436453	1
18	1	7.58727%	7060738412025	1820944572587	25.79%	1820944572587	25
19	2	16.06716%	28242953648100	3856117918419	13.65%	3856117918419	300
20	3	21.73792%	72176437100700	5217100713155	7.23%	5217100713155	2300
21	4	21.09857%	132323468017950	5063656574533	3.83%	5063656574533	12650
22	5	15.63776%	185252855225130	3753063108183	2.03%	3753063108183	53130
23	6	9.19868%	205836505805700	2207684181284	1.07%	2207684181284	177100
24	7	4.40609%	186233029062300	1057462170867	0.57%	1057462170867	480700
25	8	1.74948%	139674771796725	419874685491	0.30%	419874685491	1081575
26	9	0.58316%	87943374834975	139958228497	0.16%	139958228497	2042975
27	10	0.16466%	46903133245320	39517617458	0.08%	39517617458	3268760
28	11	0.03962%	21319606020600	9509587089	0.04%	9509587089	4457400
29	12	0.00816%	8290957896900	1957856165	0.02%	1957856165	5200300
30	13	0.00144%	2763652632300	345504029.2	0.01%	345504029.2	5200300
31	14	0.00022%	789615037800	52261113.66	0.01%	52261113.66	4457400
32	15	0.00003%	193017009240	6763202.944	0.00%	6763202.944	3268760
33	16	0.00000%	40211876925	745941.5012	0.00%	745941.5012	2042975
34	17	0.00000%	7096213575	69690.03644	0.00%	69690.03644	1081575
35	18	0.00000%	1051290900	5465.885211	0.00%	5465.885211	480700
36	19	0.00000%	129105900	355.3671499	0.00%	355.3671499	177100
37	20	0.00000%	12910590	18.813555	0.00%	18.813555	53130
38	21	0.00000%	1024650	0.7904855041	0.00%	0.7904855041	12650
39	22	0.00000%	62100	0.02536317125	0.00%	0.02536317125	2300
40	23	0.00000%	2700	0.000583807011	0.00%	0.000583807011	300
41	24	0.00000%	75	0.00000858539722	0.00%	0.00000858539722	25
42	25	0.00000%	1	0.00000006060280391	0.00%	0.00000006060280391	1
43
44	* For each M, fraction of library containing M EdU's in random region. Percentages are displayed only to 5th decimal, but are non-zero even for high M.
45
46	total number of unique sequences in library		24000000000000
47	# of possible sequences for all M together		1.1259E+15
48
49		100.00000%
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100