Help me fill this Position Specific Scoring Matrix worksheet

Sequence alignment:

seq1 A G C T A

seq2 A A C T A

seq3 G T C T A

seq4 A G C A A

seq5 A C C A A

Table of occurrences:

A
G
C
T

PSSM (B = 0): score = obs. counts / total counts

A
G
C
T

PSSM (B = 0.1): score = (obs. counts + B*(base frequency)) / (total counts + B)

A (0.20)
G (0.30)
C (0.30)
T (0.20)

"Log Odds" form s' = -log (score / background frequency)

A (0.20)
G (0.30)
C (0.30)
T (0.20)

What is the score of GACAA?

G	A	C	A	A	Total

What is the uncertainty (H_c) of column 0?

H_c =S [p_ic * log₂(p_ic)] (summed over all 4 nucleotides)

(P_ic = fraction of nucleotides in column c that have identity i )