Software Set-up Example for Calculating Residues/Molecule-Unknown
| DATE RUN |
3/31/96 |
|
|
|
|
|
|
|
| TYPE IN |
|
|
|
|
|
|
|
|
| NAME/ID # |
KNOWN |
|
|
|
|
|
|
|
| VOL HYDROLYZED |
|
|
|
|
|
|
|
|
| RATIO APPLIED |
|
|
|
|
|
|
|
|
| Molecular weight |
|
|
|
|
|
|
|
|
| AMINO ACID |
known Composition |
pmol analyzed |
PMOL PROTIEN |
OVER 15% |
UNDER 15% |
EXP COMP |
INT COMP |
% INT ERR |
| ASP (D) |
|
|
=IF(B8=0,FALSE,C8/B8) |
=IF(D8
| =IF(E8>B29,E8,FALSE) |
=C8/(F26) |
=ROUND(G8,0) |
=IF(B8=0,FALSE,(ABS(B8-H8)/B8)*100) |
|
| GLU (E) |
|
|
=IF(B9=0,FALSE,C9/B9) |
=IF(D9
| =IF(E9>B29,E9,FALSE) |
=C9/(F26) |
=ROUND(G9,0) |
=IF(B9=0,FALSE,(ABS(B9-H9)/B9)*100) |
|
| SER (S) |
|
|
=IF(B10=0,FALSE,C10/B10) |
=IF(D10
| =IF(E10>B29,E10,FALSE) |
=C10/(F26) |
=ROUND(G10,0) |
=IF(B10=0,FALSE,(ABS(B10-H10)/B10)*100) |
|
| GLY (G) |
|
|
=IF(B11=0,FALSE,C11/B11) |
=IF(D11
| =IF(E11>B29,E11,FALSE) |
=C11/(F26) |
=ROUND(G11,0) |
=IF(B11=0,FALSE,(ABS(B11-H11)/B11)*100) |
|
| HIS (H) |
|
|
=IF(B12=0,FALSE,C12/B12) |
=IF(D12
| =IF(E12>B29,E12,FALSE) |
=C12/(F26) |
=ROUND(G12,0) |
=IF(B12=0,FALSE,(ABS(B12-H12)/B12)*100) |
|
| ARG (R) |
|
|
=IF(B13=0,FALSE,C13/B13) |
=IF(D13
| =IF(E13>B29,E13,FALSE) |
=C13/(F26) |
=ROUND(G13,0) |
=IF(B13=0,FALSE,(ABS(B13-H13)/B13)*100) |
|
| THR (T) |
|
|
=IF(B14=0,FALSE,C14/B14) |
=IF(D14
| =IF(E14>B29,E14,FALSE) |
=C14/(F26) |
=ROUND(G14,0) |
=IF(B14=0,FALSE,(ABS(B14-H14)/B14)*100) |
|
| ALA (A) |
|
|
=IF(B15=0,FALSE,C15/B15) |
=IF(D15
| =IF(E15>B29,E15,FALSE) |
=C15/(F26) |
=ROUND(G15,0) |
=IF(B15=0,FALSE,(ABS(B15-H15)/B15)*100) |
|
| PRO (P) |
|
|
=IF(B16=0,FALSE,C16/B16) |
=IF(D16
| =IF(E16>B29,E16,FALSE) |
=C16/(F26) |
=ROUND(G16,0) |
=IF(B16=0,FALSE,(ABS(B16-H16)/B16)*100) |
|
| TYR (Y) |
|
|
=IF(B17=0,FALSE,C17/B17) |
=IF(D17
| =IF(E17>B29,E17,FALSE) |
=C17/(F26) |
=ROUND(G17,0) |
=IF(B17=0,FALSE,(ABS(B17-H17)/B17)*100) |
|
| VAL (V) |
|
|
=IF(B18=0,FALSE,C18/B18) |
=IF(D18
| =IF(E18>B29,E18,FALSE) |
=C18/(F26) |
=ROUND(G18,0) |
=IF(B18=0,FALSE,(ABS(B18-H18)/B18)*100) |
|
| MET (M) |
|
|
=IF(B19=0,FALSE,C19/B19) |
=IF(D19
| =IF(E19>B29,E19,FALSE) |
=C19/(F26) |
=ROUND(G19,0) |
=IF(B19=0,FALSE,(ABS(B19-H19)/B19)*100) |
|
| ILE (I) |
|
|
=IF(B20=0,FALSE,C20/B20) |
=IF(D20
| =IF(E20>B29,E20,FALSE) |
=C20/(F26) |
=ROUND(G20,0) |
=IF(B20=0,FALSE,(ABS(B20-H20)/B20)*100) |
|
| LEU (L) |
|
|
=IF(B21=0,FALSE,C21/B21) |
=IF(D21
| =IF(E21>B29,E21,FALSE) |
=C21/(F26) |
=ROUND(G21,0) |
=IF(B21=0,FALSE,(ABS(B21-H21)/B21)*100) |
|
| PHE (F) |
|
|
=IF(B22=0,FALSE,C22/B22) |
=IF(D22
| =IF(E22>B29,E22,FALSE) |
=C22/(F26) |
=ROUND(G22,0) |
=IF(B22=0,FALSE,(ABS(B22-H22)/B22)*100) |
|
| LYS (K) |
|
|
=IF(B23=0,FALSE,C23/B23) |
=IF(D23
| =IF(E23>B29,E23,FALSE) |
=C23/(F26) |
=ROUND(G23,0) |
=IF(B23=0,FALSE,(ABS(B23-H23)/B23)*100) |
|
| |
|
|
|
|
|
|
|
|
| TOTAL #AA |
=SUM(B8:B23) |
|
|
NEW ESTIMATE |
PMOL PROTEIN |
|
|
|
| ESTIMATED AMOUNT |
ANALYZED |
|
|
WITHIN 15% |
=AVERAGE(F8:F23) |
|
AVERAGE % |
|
| PMOL PROTEIN |
=AVERAGE(D8:D23) |
|
|
|
|
|
ERROR |
=AVERAGE(I8:I23) |
| 15% OF PROTEIN |
=B27*0.15 |
|
TOTAL PMOL |
AMINO ACID |
=SUM(C8:C23) |
|
|
|
| -15% OF PROTEIN |
=B27-B28 |
|
TOTAL |
PMOL HYDROL |
=F26/B5 |
Total ugrams |
=(F29*B6)/1000000 |
|
| +15% OF PROTEIN |
=B27+B28 |
|
|
CONC pmol/µl |
=F29/B4 |
CONC µg/µl |
=H29/B4 |
|