Spreadsheet Editor

[Total: 0    Average: 0/5]

This client-applet allows Internet Explorer 5+/NS6+ users to save and open spreadsheet files in HTML format.

Head Code:

<STYLE>
.tditem {
text-decoration: none;
}
</STYLE>

Body Code:

<FORM name=ss method=post>
<DIV align=center>
<TABLE cellSpacing=0 border=0 width="100%" cellpadding="0">
<TBODY>
  <TR>
    <TD align=center>
      <DIV align=center>
      <TABLE cellSpacing=0 cellPadding=0 border=0 bgcolor="#C0C0C0">
        <TBODY>
        <TR>
          <TD align="center">
            <div align="center">
              <table border="0" width="100%">
                <tr>
    <td>
      <p align="left"><font face="Tahoma" size="2"> <font color="#000000">   
      </font> <a href="JavaScript:openData()"><font color="#FFFFFF">Open...</font></a><font color="#FFFFFF">
      </font>  <font color="#FFFFFF">|</font> <font color="#000000">  </font><a href="JavaScript:saveData()"><font color="#FFFFFF">Save
      As...</font></a><font color="#FFFFFF">   </font></font></td>
                  <center>
    <td>
      <b><font face="Tahoma" size="1" color="#808080">  </font></b></td>
                  </center>
    <td>
      <p align="center"><font face="Tahoma" size="2"><font color="#000000">Self-Duplicating HTML
      Spreadsheet</font><font color="#808080">   </font><font color="#FFFFFF" size="1">(for IE5+) </font></font></td>
                </tr>
              </table>
            </div>
          </TD></TR>
        <TR>
          <TD align="center">
            <p align="center"><INPUT size=3 name=help class=tditem style=cursor:hand onclick="alert('About the Self-Duplicating HTML SpreadsheetnnWatch out for text starting with a number, such as 3-M Corp. or 22 Prospect Avenue. nThe number in the text will be interpreted as numeric data unless it is preceded by a nprintable non-numeric character. I suggest using the underscore  _  for this purpose. nNote that . + and - have a valid numeric function and cannot be used to force the number to be interpreted as text.nFor example:n22 Prospect Avenue is interpreted as the number 22n_22 Prospect Avenue is interpreted as _22 Prospect AvenuenAlso avoid using separators like commas or spaces within numbers. nFor example:n4,430,289 will be interpreted as 4n4 430 289 will be interpreted as 4n4430289 will be interpreted as 4,430,289 nOther than that, you should have no problem. Trying to average an empty ncolumn results in an error message, as you would expect. nNaN means that the result is Not a Number.nEnjoy! nn--------------------------------------------------------------------------------nnThis client-application version allows Internet Explorer 5+ users to save and open spreadsheet files in HTML format. It does NOT use cookies. Each cell can contain as much information as needed and is not restricted to the 4k limit of cookies. nDouble-click in a cell to open user prompt. Saving a spreadsheet will duplicate the entire JavaScript applet with whatever new data you put in it. Files can be re-opened, uploaded and emailed.nnTip: Zip compress your spreadsheet (it shrinks to about 5k!) before sending it as an email attachment to prevent Access Denied errors if your recipient tries to save new data. ')" style="color: #FFFFFF; text-align: center; font-weight: bold; background-color: #C0C0C0; border: 0 dotted #FFFFFF" value="Help"><INPUT 
            style="FONT-WEIGHT:bold;COLOR:#000000;BACKGROUND-COLOR:#c0c0c0;TEXT-ALIGN:center" 
            size=12 value=A name=A class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=12 value=B name=B class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=12 value=C name=C class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=12 value=D name=D class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=12 value=E name=E class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><br>
            <BR>
            <FONT color=#ffffff><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" size=3 value=1 name=T1 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"></FONT><INPUT size=12 name=A1 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA1() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B1 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB1() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C1 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC1() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D1 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD1() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E1 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE1() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=2 name=T2 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A2 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA2() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B2 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB2() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C2 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC2() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D2 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD2() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E2 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE2() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=3 name=T3 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A3 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA3() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B3 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB3() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C3 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC3() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D3 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD3() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E3 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE3() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=4 name=T4 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A4 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA4() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B4 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB4() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C4 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC4() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D4 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD4() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E4 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE4() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=5 name=T5 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A5 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA5() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B5 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB5() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C5 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC5() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D5 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD5() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E5 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE5() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=6 name=T6 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A6 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA6() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B6 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB6() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C6 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC6() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D6 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD6() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E6 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE6() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=7 name=T7 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A7 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA7() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B7 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB7() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C7 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC7() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D7 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD7() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E7 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE7() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=8 name=T8 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A8 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA8() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B8 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB8() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C8 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC8() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D8 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD8() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E8 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE8() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=9 name=T9 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A9 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA9() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B9 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB9() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C9 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC9() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D9 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD9() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E9 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE9() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="FONT-WEIGHT: bold; COLOR: #000000; BACKGROUND-COLOR: #c0c0c0; TEXT-ALIGN: center" 
            size=3 value=10 name=T10 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A10 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA10() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B10 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB10() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C10 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC10() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D10 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD10() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E10 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE10() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT 
            style="font-weight: bold; color: #000000; background-color: #C0C0C0; text-align: center" 
            size=3 value=11 name=T11 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT size=12 name=A11 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA11() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0', style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B11 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB11() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C11 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC11() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D11 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD11() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E11 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE11() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT style="font-weight: bold; color: #000000; background-color: #C0C0C0; text-align: center" 
            size=3 value=12 name=T12 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='silver' style="border-style:inset;border-width:1"><INPUT 
            size=12 name=A12 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcA12() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=B12 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcB12() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=C12 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcC12() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width='0',style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=D12 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcD12() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#E6EAEE' style.background-color='#E6EAEE',style.border.width='0',style.border='solid' style="background-color:#E6EAEE" style="border-style:inset;border-width:1"><INPUT 
            size=12 name=E12 class=tditem onclick=style.backgroundColor='white',style.cursor='crosshair' onDblclick=style.backgroundColor='cyan',doCalcE12() onfocus=style.backgroundColor='white' onmouseover=style.backgroundColor='silver',style.border.width='0' onmouseout=style.backgroundColor='#EEECE8' style.background-color='#EEECE8',style.border.width="0",style.border='solid' style="background-color:#EEECE8" style="border-style:inset;border-width:1"><BR><INPUT size=3 name=T13 class=tditem style="color: #FF0000; text-align: center; font-weight: bold; background-color: #C0C0C0; border-style: outset; border-width: 1"><INPUT style="font-weight: bold; color: #FFFF00; background-color: #808080; text-align: center" 
            size=12 name=A13 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='gray' style="border-style:inset;border-width:1"><INPUT style="font-weight: bold; color: #FFFF00; background-color: #808080; text-align: center" 
            size=12 name=B13 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='gray' style="border-style:inset;border-width:1"><INPUT style="font-weight: bold; color: #FFFF00; background-color: #808080; text-align: center" 
            size=12 name=C13 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='gray' style="border-style:inset;border-width:1"><INPUT style="font-weight: bold; color: #FFFF00; background-color: #808080; text-align: center" 
            size=12 name=D13 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='gray' style="border-style:inset;border-width:1"><INPUT style="font-weight: bold; color: #FFFF00; background-color: #808080; text-align: center" 
            size=12 name=E13 class=tditem onmouseover=style.backgroundColor='red' onclick=style.backgroundColor='dodgerblue' onmouseout=style.backgroundColor='gray' style="border-style:inset;border-width:1">
          </TD></TR></TBODY></TABLE></DIV></TD></TR></TBODY></TABLE></DIV>
<DIV align=center>
<CENTER>
<TABLE border=0 bgcolor="#C0C0C0">
  <TBODY>
  <TR>    
    <TD align=middle>
      <P align=center><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=addItA() type=button value=" Sum A " name=BT1></P></TD>
    <TD align=middle>
      <P align=center><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=addItB() type=button value=" Sum B " name=BT2></P></TD>
    <TD align=middle>
      <P align=center><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=addItC() type=button value=" Sum C" name=BT3></P></TD>
    <TD align=middle>
      <P align=center><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=addItD() type=button value=" Sum D" name=BT4></P></TD>
    <TD align=middle>
      <P align=center><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=addItE() type=button value=" Sum E " name=BT5></P></TD>
    <TD align=middle>
      <P align=center><INPUT style="font-family: Tahoma; font-size: 8pt; color: #FFFFFF" type=reset value=Clear name=BT12 color: #FFFFFF" onclick=addItE() type=button value=" Sum E " name=BT5 onMouseOver="this.style.color='#9999CC'" onMouseOut="this.style.color='#FFFFFF'" style="font-family: Tahoma; font-size: 8pt; color: #FFFFFF"></P></TD>
    <TD align=middle><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=avgA() type=button value="Avg. A" name=BT13></TD>
    <TD align=middle><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=avgB() type=button value="Avg. B" name=BT14></TD>
    <TD align=middle><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=avgC() type=button value="Avg.C" name=BT15></TD>
    <TD align=middle><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=avgD() type=button value="Avg.D" name=BT16></TD>
    <TD align=middle><INPUT style="FONT-SIZE: 8pt; FONT-FAMILY: Tahoma" onclick=avgE() type=button value="Avg. E" name=BT17></TD>
  </TR>
  </TBODY></TABLE></CENTER></DIV>
</FORM>
<SCRIPT language=JavaScript>
<!--hide this script from old browsers
function saveData(){
var userData = document.body.innerHTML;
saveHTML= window.open("", 'preview','');
saveHTML.document.write("<HTML><HEAD><!-- STEP ONE: Paste this code into the HEAD of your HTML document --><TITLE>Self-Duplicating HTML Spreadsheet (for IE5+)</TITLE><META http-equiv=Content-Type content=text/html;charset=windows-1252><STYLE>.tditem {text-decoration: none;}</STYLE></HEAD><BODY>" + userData + "</BODY></HTML>");
saveHTML.document.execCommand("SaveAs","<HTML><HEAD><!-- STEP ONE: Paste this code into the HEAD of your HTML document --><TITLE>Self-Duplicating HTML Spreadsheet (for IE5+)</TITLE><META http-equiv=Content-Type content=text/html; charset=windows-1252><STYLE>.tditem {text-decoration: none;}</STYLE></HEAD><BODY>" + userData + "</BODY></HTML>");
saveHTML.close();
}

/*  ******************************************************************************
IE5+ command functions and enhancements in this client-version script by F. Kapnistos.
****************             fkapnist@hotmail.com        *************************

Original written by Bill Buchanan, RR 3 Site 304 Box 11, Onoway, Alberta, Canada T0E 1V0
You may use this script freely, so long as this notice remains part of the script.
                Bill.Buchanan@Excite.com                 Enjoy!  
******************************************************************************  */

var nCountA=0
var nCountB=0
var nCountC=0
var nCountD=0
var nCountE=0
var nSumA=0
var nSumB=0
var nSumC=0
var nSumD=0
var nSumE=0
function tabSum() {
window.document.ss.T13.value='Sum'
}
function tabAvg() {
window.document.ss.T13.value='Avg.'
}
function addItA() {
nCountA=0
var nA1=parseFloat(window.document.ss.A1.value)
if (nA1/1!==nA1) {nA1=0} else {nCountA++}
var nA2=parseFloat(window.document.ss.A2.value)
if (nA2/1!==nA2) {nA2=0} else {nCountA++}
var nA3=parseFloat(window.document.ss.A3.value)
if (nA3/1!==nA3) {nA3=0} else {nCountA++}
var nA4=parseFloat(window.document.ss.A4.value)
if (nA4/1!==nA4) {nA4=0} else {nCountA++}
var nA5=parseFloat(window.document.ss.A5.value)
if (nA5/1!==nA5) {nA5=0} else {nCountA++}
var nA6=parseFloat(window.document.ss.A6.value)
if (nA6/1!==nA6) {nA6=0} else {nCountA++}
var nA7=parseFloat(window.document.ss.A7.value)
if (nA7/1!==nA7) {nA7=0} else {nCountA++}
var nA8=parseFloat(window.document.ss.A8.value)
if (nA8/1!==nA8) {nA8=0} else {nCountA++}
var nA9=parseFloat(window.document.ss.A9.value)
if (nA9/1!==nA9) {nA9=0} else {nCountA++}
var nA10=parseFloat(window.document.ss.A10.value)
if (nA10/1!==nA10) {nA10=0} else {nCountA++}
var nA11=parseFloat(window.document.ss.A11.value)
if (nA11/1!==nA11) {nA11=0} else {nCountA++}
var nA12=parseFloat(window.document.ss.A12.value)
if (nA12/1!==nA12) {nA12=0} else {nCountA++}
// alert("nCountA="+nCountA)
nSumA=nA1+nA2+nA3+nA4+nA5+nA6+nA7+nA8+nA9+nA10+nA11+nA12
window.document.ss.A13.value=nSumA
tabSum()
}
function addItB() {
nCountB=0
var nB1=parseFloat(window.document.ss.B1.value)
if (nB1/1!==nB1) {nB1=0} else {nCountB++}
var nB2=parseFloat(window.document.ss.B2.value)
if (nB2/1!==nB2) {nB2=0} else {nCountB++}
var nB3=parseFloat(window.document.ss.B3.value)
if (nB3/1!==nB3) {nB3=0} else {nCountB++}
var nB4=parseFloat(window.document.ss.B4.value)
if (nB4/1!==nB4) {nB4=0} else {nCountB++}
var nB5=parseFloat(window.document.ss.B5.value)
if (nB5/1!==nB5) {nB5=0} else {nCountB++}
var nB6=parseFloat(window.document.ss.B6.value)
if (nB6/1!==nB6) {nB6=0} else {nCountB++}
var nB7=parseFloat(window.document.ss.B7.value)
if (nB7/1!==nB7) {nB7=0} else {nCountB++}
var nB8=parseFloat(window.document.ss.B8.value)
if (nB8/1!==nB8) {nB8=0} else {nCountB++}
var nB9=parseFloat(window.document.ss.B9.value)
if (nB9/1!==nB9) {nB9=0} else {nCountB++}
var nB10=parseFloat(window.document.ss.B10.value)
if (nB10/1!==nB10) {nB10=0} else {nCountB++}
var nB11=parseFloat(window.document.ss.B11.value)
if (nB11/1!==nB11) {nB11=0} else {nCountB++}
var nB12=parseFloat(window.document.ss.B12.value)
if (nB12/1!==nB12) {nB12=0} else {nCountB++}
// alert("nCountB="+nCountB)
nSumB=nB1+nB2+nB3+nB4+nB5+nB6+nB7+nB8+nB9+nB10+nB11+nB12
window.document.ss.B13.value=nSumB
tabSum()
}
function addItC() {
nCountC=0
var nC1=parseFloat(window.document.ss.C1.value)
if (nC1/1!==nC1) {nC1=0} else {nCountC++}
var nC2=parseFloat(window.document.ss.C2.value)
if (nC2/1!==nC2) {nC2=0} else {nCountC++}
var nC3=parseFloat(window.document.ss.C3.value)
if (nC3/1!==nC3) {nC3=0} else {nCountC++}
var nC4=parseFloat(window.document.ss.C4.value)
if (nC4/1!==nC4) {nC4=0} else {nCountC++}
var nC5=parseFloat(window.document.ss.C5.value)
if (nC5/1!==nC5) {nC5=0} else {nCountC++}
var nC6=parseFloat(window.document.ss.C6.value)
if (nC6/1!==nC6) {nC6=0} else {nCountC++}
var nC7=parseFloat(window.document.ss.C7.value)
if (nC7/1!==nC7) {nC7=0} else {nCountC++}
var nC8=parseFloat(window.document.ss.C8.value)
if (nC8/1!==nC8) {nC8=0} else {nCountC++}
var nC9=parseFloat(window.document.ss.C9.value)
if (nC9/1!==nC9) {nC9=0} else {nCountC++}
var nC10=parseFloat(window.document.ss.C10.value)
if (nC10/1!==nC10) {nC10=0} else {nCountC++}
var nC11=parseFloat(window.document.ss.C11.value)
if (nC11/1!==nC11) {nC11=0} else {nCountC++}
var nC12=parseFloat(window.document.ss.C12.value)
if (nC12/1!==nC12) {nC12=0} else {nCountC++}
// alert("nCountC="+nCountC)
nSumC=nC1+nC2+nC3+nC4+nC5+nC6+nC7+nC8+nC9+nC10+nC11+nC12
window.document.ss.C13.value=nSumC
tabSum()
}
function addItD() {
nCountD=0
var nD1=parseFloat(window.document.ss.D1.value)
if (nD1/1!==nD1) {nD1=0} else {nCountD++}
var nD2=parseFloat(window.document.ss.D2.value)
if (nD2/1!==nD2) {nD2=0} else {nCountD++}
var nD3=parseFloat(window.document.ss.D3.value)
if (nD3/1!==nD3) {nD3=0} else {nCountD++}
var nD4=parseFloat(window.document.ss.D4.value)
if (nD4/1!==nD4) {nD4=0} else {nCountD++}
var nD5=parseFloat(window.document.ss.D5.value)
if (nD5/1!==nD5) {nD5=0} else {nCountD++}
var nD6=parseFloat(window.document.ss.D6.value)
if (nD6/1!==nD6) {nD6=0} else {nCountD++}
var nD7=parseFloat(window.document.ss.D7.value)
if (nD7/1!==nD7) {nD7=0} else {nCountD++}
var nD8=parseFloat(window.document.ss.D8.value)
if (nD8/1!==nD8) {nD8=0} else {nCountD++}
var nD9=parseFloat(window.document.ss.D9.value)
if (nD9/1!==nD9) {nD9=0} else {nCountD++}
var nD10=parseFloat(window.document.ss.D10.value)
if (nD10/1!==nD10) {nD10=0} else {nCountD++}
var nD11=parseFloat(window.document.ss.D11.value)
if (nD11/1!==nD11) {nD11=0} else {nCountD++}
var nD12=parseFloat(window.document.ss.D12.value)
if (nD12/1!==nD12) {nD12=0} else {nCountD++}
// alert("nCountD="+nCountD)
nSumD=nD1+nD2+nD3+nD4+nD5+nD6+nD7+nD8+nD9+nD10+nD11+nD12
window.document.ss.D13.value=nSumD
tabSum()
}
function addItE() {
nCountE=0
var nE1=parseFloat(window.document.ss.E1.value)
if (nE1/1!==nE1) {nE1=0} else {nCountE++}
var nE2=parseFloat(window.document.ss.E2.value)
if (nE2/1!==nE2) {nE2=0} else {nCountE++}
var nE3=parseFloat(window.document.ss.E3.value)
if (nE3/1!==nE3) {nE3=0} else {nCountE++}
var nE4=parseFloat(window.document.ss.E4.value)
if (nE4/1!==nE4) {nE4=0} else {nCountE++}
var nE5=parseFloat(window.document.ss.E5.value)
if (nE5/1!==nE5) {nE5=0} else {nCountE++}
var nE6=parseFloat(window.document.ss.E6.value)
if (nE6/1!==nE6) {nE6=0} else {nCountE++}
var nE7=parseFloat(window.document.ss.E7.value)
if (nE7/1!==nE7) {nE7=0} else {nCountE++}
var nE8=parseFloat(window.document.ss.E8.value)
if (nE8/1!==nE8) {nE8=0} else {nCountE++}
var nE9=parseFloat(window.document.ss.E9.value)
if (nE9/1!==nE9) {nE9=0} else {nCountE++}
var nE10=parseFloat(window.document.ss.E10.value)
if (nE10/1!==nE10) {nE10=0} else {nCountE++}
var nE11=parseFloat(window.document.ss.E11.value)
if (nE11/1!==nE11) {nE11=0} else {nCountE++}
var nE12=parseFloat(window.document.ss.E12.value)
if (nE12/1!==nE12) {nE12=0} else {nCountE++}
// alert("nCountE="+nCountE)
nSumE=nE1+nE2+nE3+nE4+nE5+nE6+nE7+nE8+nE9+nE10+nE11+nE12
window.document.ss.E13.value=nSumE
tabSum()
}
function avgA() {
addItA()
window.document.ss.A13.value=nSumA/nCountA
// alert('nSumA='+nSumA+'nnCountA='+nCountA)
tabAvg()
}
function avgB() {
addItB()
window.document.ss.B13.value=nSumB/nCountB
// alert('nSumB='+nSumB+'nnCountB='+nCountB)
tabAvg()
}
function avgC() {
addItC()
window.document.ss.C13.value=nSumC/nCountC
// alert('nSumC='+nSumC+'nnCountC='+nCountC)
tabAvg()
}
function avgD() {
addItD()
window.document.ss.D13.value=nSumD/nCountD
// alert('nSumD='+nSumD+'nnDountD='+nCountD)
tabAvg()
}
function avgE() {
addItE()
window.document.ss.E13.value=nSumE/nCountE
// alert('nSumE='+nSumE+'nnCountE='+nCountE)
tabAvg()
}
function doCalcA1() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A1.value))
document.ss.A1.value = ( input )
}
function doCalcA2() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A2.value))
document.ss.A2.value = ( input )
}
function doCalcA3() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A3.value))
document.ss.A3.value = ( input )
}
function doCalcA4() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A4.value))
document.ss.A4.value = ( input )
}
function doCalcA5() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A5.value))
document.ss.A5.value = ( input )
}
function doCalcA6() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A6.value))
document.ss.A6.value = ( input )
}
function doCalcA7() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A7.value))
document.ss.A7.value = ( input )
}
function doCalcA8() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A8.value))
document.ss.A8.value = ( input )
}
function doCalcA9() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A9.value))
document.ss.A9.value = ( input )
}
function doCalcA10() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A10.value))
document.ss.A10.value = ( input )
}
function doCalcA11() {
var input = prompt ("Enter text or data without separators like commas or spaces within numbers. Click on Help for rules.",(document.ss.A11.value))
document.ss.A11.value = ( input )
}
</script>

Times Viewed: 8

Leave a Reply

Your email address will not be published. Required fields are marked *