mean = avg(B1:B5) = 75.8
	A	B	C	D
0	grade	score	avg	stdev
1	60.29	57.00	75.80	14.31
2	70.77	67.00		
3	96.98	92.00		
4	91.74	87.00		
5	80.21	76.00		
	A	B	C	D
0	"grade"	"score"	"avg"	"stdev"
1	80+((15*(B1-mean))/$D$1)	57	mean	stdev(B1:B5)
2	80+((15*(B2-mean))/$D$1)	67		
3	80+((15*(B3-mean))/$D$1)	92		
4	80+((15*(B4-mean))/$D$1)	87		
5	80+((15*(B5-mean))/$D$1)	76		
	A	B	C	D
0	1051348	1051380	10513b8	10513f0
1	10517a8	0	10514d0	1051578
2	10517a8	0		
3	10517a8	0		
4	10517a8	0		
5	10517a8	0